| | Problem Data | | L1 | L2 | L3 | L4 |
| | | | "From" Distribution Centers | | | | | Travel Times (in Min) | Cambridge, OH | Dover, OH | Newark, OH | Toronto, OH |
| | | | Cambridge, OH | Dover, OH | Newark, OH | Toronto, OH | | Cambridge, OH | 0 | 45 | 62 | 90 |
| | | Maximum Supply: | 45 | 15 | 15 | 15 | | Bellaire, OH | 56 | 88 | 105 | 52 |
| | | | Shipping Costs | | | | | Cadiz, OH | 56 | 47 | 105 | 38 |
| | "To" Stores | Minimum Demand | | Logistic Cost per minute per unit: | $0.85 | | | Calcutta, OH | 108 | 86 | 154 | 27 |
| | Bellaire, OH | 5 | $47.60 | $74.80 | $89.25 | $44.20 | | Coshocton, OH | 47 | 46 | 44 | 104 |
| | Cadiz, OH | 5 | $47.60 | $39.95 | $89.25 | $32.30 | | Dover, OH | 45 | 0 | 81 | 81 |
| | Calcutta, OH | 9 | $91.80 | $73.10 | $130.90 | $22.95 | | East Palestine, OH | 129 | 90 | 165 | 48 |
| | Coshocton, OH | 4 | $39.95 | $39.10 | $37.40 | $88.40 | | Lisbon, OH | 106 | 68 | 142 | 38 |
| | East Palestine, OH | 10 | $109.65 | $76.50 | $140.25 | $40.80 | | Mt. Gilead, OH | 119 | 109 | 72 | 173 |
| | Lisbon, OH | 8 | $90.10 | $57.80 | $120.70 | $32.30 | | New Martinsville, WV | 94 | 125 | 142 | 90 |
| | Mt. Gilead, OH | 9 | $101.15 | $92.65 | $61.20 | $147.05 | | Newark, OH | 62 | 81 | 0 | 140 |
| | New Martinsville, WV | 3 | $79.90 | $106.25 | $120.70 | $76.50 | | Pataskala, OH | 67 | 101 | 27 | 150 |
| | Pataskala, OH | 10 | $56.95 | $85.85 | $22.95 | $127.50 | | Toronto, OH | 90 | 81 | 140 | 0 |
| | Uhrichsville, OH | 5 | $36.55 | $17.00 | $68.00 | $55.25 | | Uhrichsville, OH | 43 | 20 | 80 | 65 |
| | Weirton, WV | 7 | $71.40 | $63.75 | $113.90 | $17.85 | | Weirton, WV | 84 | 75 | 134 | 21 |
| | Zanesville, OH | 6 | $28.05 | $56.95 | $31.45 | $95.20 | | Zanesville, OH | 33 | 67 | 37 | 112 |
| | | Total: | | | | | $1,683.00 |
| | | | | | | | | What do I know? |
| | Optimized Model | | | | | | | There is a total minimum supply of 81 pallets per day that need to be delivered |
| | | | | | | | | Each truck can deliver a maximum of 26 pallets |
| | Decision Variables: | How many deliveries can be made from each distribution center. | | | | | | Each truck only has 11 hours to deliver everything |
| | Objective: | Maximize deliveries and minimize cost. | | | | | | 11 hours *60 mins = 660 mins |
| | Contraints: | Limited to a budget of $1065.90 | | | | | | 660 mins * $0.85 = $561.00 |
| | | Each truck has a maximum budget of $561.00 | | | | | | 3 truck * 660 mins = 1980 mins |
| | | Each truck can carry a maximu of 26 pallets | | | | | | maximum budget of 3 trucks = $1683.00 |
| | | There is a minimum demand of 81 pallets every day | | | | | | Total travel time for all 5 routs is 1254 minutes or 20.9 hours per day which is $1065.90 |
| | | Truck 1 - T1 | Truck 2 - T2 | Truck 3 - T3 |
Jubyhuff
Supply-Chain-Analytics-Case-Study-Template.xlsx
