Spreadsheet: 676181d1588691985-optimize-freight-distribution-by-priority-distance-and-mass-yield-freight-example-priority-loading-hydr-
Sheet: Sheet1

FREIGHT | TONS | Priority |  | A LOGICAL SOLUTION:
JOB 1 |  | 10 |  | TRUCK 1 | TRUCK 2 | TRUCK 3 | TRUCK 4 | TRUCK 5 | TRUCK 6 | TRUCK 7 | TRUCK 8 | TRUCK 9 | TRUCK 10 | TRUCK 11
JOB 7 |  | 10 |  | JOB 1 (100%) | JOB 16 (46.37%) | JOB 16 (46.37%) | JOB 16 (7.26%) | JOB 13 (79.36%) | JOB 13 (20.64%) | JOB 11 (100%) | JOB 6 (46.90%) | JOB 7 (100%) | JOB 18 (92.07%) | JOB 12 (95.60%)
JOB 11 |  | 10 |  | JOB 2 (100%) |  |  | JOB 17 (100%) |  | JOB 4 (100%) | JOB 6 (53.10%) | JOB 20 (100%) | JOB 8 (100%) | JOB 19 (100%) | JOB 15 (100%)
JOB 19 |  | 10 |  | JOB 3 (100%) |  |  |  |  | JOB 10 (100%) |  | JOB 9 (100%) | JOB 18 (7.93%)
JOB 9 |  | 9 |  | JOB 14 (100%) |  |  |  |  | JOB 5 (100%) |  |  | JOB 12 (4.40%)
JOB 17 |  | 9
JOB 8 |  | 8
JOB 15 |  | 8 |  | SIDE NOTE: OUR LOGISTICS COMPANY IS A LITTLE CARELESS, AND TENDS TO GET THE DELIVERIES MIXED UP. IT IS BEST TO KEEP THE NUMBER OF JOBS ON THE TRUCKS TO A MINIMUM…
JOB 16 |  | 8 |  | SO THE COLUMN'S MARKED IN GREEN ARE A BIT OF A PROBLEM. IT WOULD BE BEST IF WE COULD KEEP THE NUMBER OF JOB'S PER TRUCK TO LESS THAN 3. THIS HOWEVER, IS LESS
JOB 5 |  | 7 |  | IMPORTANT THAN ACHIEVING A HIGHER % YIELD (>90%). AS YOU CAN SEE, TRUCK 9 IS A PROBLEM.
JOB 6 | 14.5 | 7
JOB 13 |  | 7
JOB 4 | 18 | 6
JOB 12 |  | 6
JOB 14 |  | 6
JOB 3 | 4.5 | 4
JOB 10 |  | 4
JOB 20 |  | 3
JOB 2 | 3.2 | 2
JOB 18 |  | 1
TOTAL:
TRUCKS:
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 | 1 | 0 | 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.067264574 | 0.93273543 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 14.9 | JOB 19 | 0 | 0.61744966 | 0.38255034 | 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.55652174 | 0.44347826 | 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.38513514 | 0.61486486 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 64.7 | JOB 16 | 0 | 0 | 0 | 0 | 0.32302937 | 0.46367852 | 0.21329212 | 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 | 1 | 0 | 0 | 0 | 0 |  |  |  |  | 1
 |  | 37.8 | JOB 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.76984127 | 0.23015873 | 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 (NO PERMUTATIONS)
 |  |  |  | BINARY VARIABLES |  |  |  |  |  |  |  |  |  |  |  |  |  | priority sum | #jobs/priority |  |  |  | T1 | T2 | T3 | T4 | T5 | T6 | T7 | T8 | T9 | T10 | T11
 |  |  | JOB 1 | 1 | 0 | 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 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10
 |  |  | JOB 19 | 0 | 1 | 1 | 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 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8
 |  |  | JOB 16 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 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 | 0 | 0 | 0 |  | 7
 |  |  | JOB 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 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