Spreadsheet: 676585d1588875535-optimize-freight-distribution-by-priority-distance-and-mass-yield-freight-example-best-priority-hydr-
Sheet: Sheet1

Parameters
tons/truck | 30
percentage | 0.9
num jobs | 5
job upper limit | 1
big M | 35
equations
constraints
ob Function
[NAME] variable | 0
cont variable | 0
 |  |  |  | [NAME] VARIABLES
 |  |  |  | TRUCK 1 | TRUCK 2 | TRUCK 3 | TRUCK 4 | TRUCK 5 | TRUCK 6 | TRUCK 7 | TRUCK 8 | TRUCK 9 | TRUCK 10 | TRUCK 11
 |  | 12.6 | JOB 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 12.9 | JOB 7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 22.3 | JOB 11 | 0 | 0.78026906 | 0.21973094 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 14.9 | JOB 19 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 8.5 | JOB 9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 23 | JOB 17 | 0 | 0 | 0.59130435 | 0.40869565 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 11.1 | JOB 8 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 14.8 | JOB 15 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 64.7 | JOB 16 | 0 | 0 | 0 | 0.11901082 | 0.46367852 | 0.41731066 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 0.8 | JOB 5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 14.5 | JOB 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0.45517241 | 0 | 0.54482759 | 0 | 0 |  |  |  |  | 1
 |  | 37.8 | JOB 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0.20634921 | 0.79365079 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 18 | JOB 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  |  |  | 1
 |  | 15.9 | JOB 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.20754717 | 0.79245283 | 0 |  |  |  |  | 1
 |  | 9.5 | JOB 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  |  | 1
 |  | 4.5 | JOB 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  |  | 1
 |  | 1.4 | JOB 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  |  | 1
 |  | 12.4 | JOB 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.16129032 | 0.83870968 |  |  |  |  | 1
 |  | 3.2 | JOB 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  | 1
 |  | 16.4 | JOB 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TRUCK LOADING ORDER 1 |  |  |  |  |  |  |  |  |  |  |  | TRUCK LOADING ORDER 2
 |  |  |  | BINARY VARIABLES |  |  |  |  |  |  |  |  |  |  |  |  |  | priority sum | #jobs/priority |  |  | T1 | T2 | T3 | T4 | T5 | T6 | T7 | T8 | T9 | T10 | T11 |  | T1 | T2 | T3 | T4 | T5 | T6 | T7 | T8 | T9 | T10 | T11
 |  |  | JOB 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
 |  |  | JOB 7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
 |  |  | JOB 11 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
 |  |  | JOB 19 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
 |  |  | JOB 9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 9
 |  |  | JOB 17 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 9
 |  |  | JOB 8 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8
 |  |  | JOB 15 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  | 8
 |  |  | JOB 16 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |  | 8
 |  |  | JOB 5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  | 7
 |  |  | JOB 6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 |  | 7
 |  |  | JOB 13 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |  | 7
 |  |  | JOB 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  | 6
 |  |  | JOB 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |  | 6
 |  |  | JOB 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  | 6
 |  |  | JOB 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  | 4
 |  |  | JOB 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  | 4
 |  |  | JOB 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | 3
 |  |  | JOB 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  | 2
 |  |  | JOB 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # parts
 |  |  |  | BINARY <-> [NAME] CONSTRAINT
 |  |  | constr 1
 |  |  | constr 2
 |  |  | constr 3
 |  |  | constr 4
 |  |  | constr 5
 |  |  | constr 6
 |  |  | constr 7
 |  |  | constr 8
 |  |  | constr 9
 |  |  | constr 10
 |  |  | constr 11
 |  |  | constr 12
 |  |  | constr 13
 |  |  | constr 14
 |  |  | constr 15
 |  |  | constr 16
 |  |  | constr 17
 |  |  | constr 18
 |  |  | constr 19
 |  |  | constr 20
 |  |  | lowest
 |  |  | highest | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  | #jobs