Set up an excel file to complete the transshipment problem and have 1 answer report, 1 sensitivity report and 1 limit report included (you can delete the ones that are incorrect, should you have any). You will attach this file upon submitting the assignment.

Also answer

1. What is the minimum cost of shipping while meeting the characteristics of the problem?
2. Indicate the units shipped on each route (including zero shipments).
3. What is the range of feasibility for the supply amount from Liverpool and what does the shadow price for Liverpool mean?

Exhibit .B 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: U.S. City 4. Norfolk 5. New York 6. Savannah Supply European Port 1. Hamburg 2. Marseilles 3. Liverpool $420 510 450 $390 590 360 $610 470 480 55 78 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: Distribution Center 7. Dallas 8. St. Louis 9. Chicago Warehouse 4. Norfolk 5. New York 6. Savannah $75 125 68 $63 110 82 $81 95 95 60 45 50 Exhibit .B 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: U.S. City 4. Norfolk 5. New York 6. Savannah Supply European Port 1. Hamburg 2. Marseilles 3. Liverpool $420 510 450 $390 590 360 $610 470 480 55 78 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: Distribution Center 7. Dallas 8. St. Louis 9. Chicago Warehouse 4. Norfolk 5. New York 6. Savannah $75 125 68 $63 110 82 $81 95 95 60 45 50