A company needs to make deliveries on 10 different routes. The time (in minutes) to complete each route and the delivery amount (i.e., the load in number of units) are as follows. Route RO1 R02 R03 R04 R05 R06 R07 R08 R09 R10 Time 29 35 15 35 20 23 35 40 45 50 Load 200 240 110 90 65 135 80 170 150 270 The company is considering 6 carriers to make these deliveries. The vehicle capacities of these carriers are as follows. Carrier C01 C02 C03 C04 C05 C06 Capacity 600 720 450 510 660 550 The problem is to assign routes to the minimum number of carriers in such a way that all routes are completed within a time limit of two hours. For instance, routes 5, 9, and 10 could be assigned to carrier C04 because the total time to complete the routes is 115 minutes and the total load is 485. Create a spreadsheet model and use solver for optimized route?
Mo.
A company needs to make deliveries on 10 different routes. The time (in minutes) to complete each route and the delivery amount (i.e., the load in number of units) are as follows. Route RO1 R02 R03 R04 R05 R06 R07 R08 R09 R10 Time 29 35 15 35 20 23 35 40 45 50 Load 200 240 110 90 65 135 80 170 150 270 The company is considering 6 carriers to make these deliveries. The vehicle capacities of these carriers are as follows. Carrier C01 C02 C03 C04 C05 C06 Capacity 600 720 450 510 660 550 The problem is to assign routes to the minimum number of carriers in such a way that all routes are completed within a time limit of two hours. For instance, routes 5, 9, and 10 could be assigned to carrier C04 because the total time to complete the routes is 115 minutes and the total load is 485. Create a spreadsheet model and use solver for optimized route?
Step by step
Solved in 3 steps with 4 images
