Please use Excel Solver in the following problems, show work and explain how you arrived at the solutions.
World foods, Inc., imports food products such as meats, cheeses, and pastries to the United States from warehouses at ports in Hamburg, Marseilles, and Liverpool. Ships from these ports deliver the products to Norfolk, New York, and Savannah, where they are stored in company warehouses before being shipped to distribution centers in Dallas, St. Louis, and Chicago. The products are then distributed to specialty food stores and sold through catalogs. The shipping costs ($/1,000 lb) from the European ports to the U.S. Cities and the available supplies (1,000 lb) at the European ports are provided in the following table:
European Port 4. Norfolk 5. New York 6. Savannah Supply
1. Hamburg $420 $390 $610 55
2. Marseilles 510 590 470 78
3. Liverpool 450 360 480 37
The transportation costs ($/1,000 lb) from each U.S. city of the three distribution centers and the demands (1,000 lb) at the distribution centers are as follows:
Warehouse 7. Dallas 8. St. Louis 9. Chicago
4. Norfolk $ 75 $ 63 $ 81
5. New York 125 110 95
6. Savannah 68 82 95
60 45 50
Determine the optimal shipments between the European ports and the warehouses and the distribution centers to minimize total transportation costs.
Max Z = 3x1 + 5x2
7x1 + 12x2 <= 136
3x1 + 5x2 <= 36
x1, x2 >= 0 and integer
Find the optimal solution.
This posting contains solutions to following problems using Excel solver.
Integer Programming Problem: Transportation and Transshipment
Part 1 Transportation
The following network describes a transportation scenario in which there are four sources A, B, C, and D; and there are three destinations P, Q, and R. (The numbers next to each arrow represents the cost of transporting one unit from that particular source to the destination located at the other end of that arrow).
Part 2 Transshipment)
By including intermediary distribution centers X and Y as shown below and using the given network, will the company save money in its transportation costs compared to the results obtained in part 1? Need assistance solving the problem by using Excel, and find the optimal cost.
(see the attached file for more information)View Full Posting Details