Question: Using Excel, please have step by step instructions using Solver. In Problem Phillups Corporation is just as concerned that its U.S. distributors receive shipments in
Using Excel, please have step by step instructions using Solver.
In Problem Phillups Corporation is just as concerned that its U.S. distributors receive shipments in the minimum amount of time as they are about minimizing their shipping costs. Suppose each U.S. distributor receives one major container shipment each month. Following are summaries of the shipping times (in days) between each of the embarkation and destination points along the Phillups global supply chain. These times not only encompass travel time but also processing, loading, and unloading times at each port.
| US Ports | ||||
| European Port | 4. Boston | 5. Savannah | 6. Mobile | 7. Houston |
| 1. Antwerp | 22 | 24 | 27 | 30 |
| 2. Barcelona | 17 | 20 | 23 | 26 |
| 3. Cherbourg | 25 | 21 | 24 | 26 |
| Inland Ports | |||
| US Ports | 8. Ohio | 9. Texas | 10. North Carolina |
| 4. Boston | 10 | 8 | 6 |
| 5. Savannah | 12 | 9 | 8 |
| 6. Mobile | 8 | 7 | 10 |
| 7. Houston | 12 | 6 | 8 |
| Distribution Centers | |||||
| Inland Port | 11. Phoenix | 12. Columbus | 13. Kansas City | 14. Louisville | 15. Cleveland |
| 8. Ohio | 5 | 6 | 5 | 7 | 8 |
| 9. Texas | 6 | 4 | 4 | 5 | 7 |
| 10. North Carolina | 10 | 5 | 7 | 4 | 6 |
Determine the optimal shipping route for each distribution center along this supply chain that will result in the minimum total shipping time.
| Optimal Shipping Route | |
| X24 | |
| X49 | |
| X410 | |
| X911 | |
| X910 | |
| X913 | |
| X912 | |
| X914 | |
| X915 | |
| Z | |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help