Set up an excel file to complete the transshipment problem and have 1 answer report and 1 sensitivity report. Please show your work on how you solve for this.

Also answer the following using the numbers in your output and describe meaning (when asked) in the context of the problem (you can use definitional idea but apply to problem at hand).

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 reduced cost number associated with shipping from Hamburg to Savannah and what does the number mean?
4. What is the range of optimality of the coefficient on the shipping amount from New York to St. Louis and what does this range mean?
5. What is the range of feasibility for the supply amount from Liverpool and what does the shadow price for Liverpool mean?

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 European Port 1. Hamburg 2. Marseilles 3. Liverpool $420 510 450 $390 590 360 $610 470 480 Supply 55 78 37 The transportation costs ($/1,000 1b.) 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