2) On the PDF attachment work with Exhibit B. 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 a) What is the minimum cost of shipping while meeting the characteristics of the problem? b) Indicate the units shipped on each route (including zero shipments). c) What is the reduced cost number associated with shipping from Hamburg to Savannah and what does the number mean? d) 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? e) 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 15.) at the European ports are provided in the following table: U.S. City 4. Norfolk 5. New York Supply European Port 1. Hamburg 2. Marseilles 3. Liverpool $420 510 450 $390 590 360 6. Savannah $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 8. St. Louis Warehouse 7. Dallas 9. Chicago 4. Norfolk 5. New York 6. Savannah $75 125 68 $ 63 110 82 $81 95 95 60 45 50 2) On the PDF attachment work with Exhibit B. 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 a) What is the minimum cost of shipping while meeting the characteristics of the problem? b) Indicate the units shipped on each route (including zero shipments). c) What is the reduced cost number associated with shipping from Hamburg to Savannah and what does the number mean? d) 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? e) 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 15.) at the European ports are provided in the following table: U.S. City 4. Norfolk 5. New York Supply European Port 1. Hamburg 2. Marseilles 3. Liverpool $420 510 450 $390 590 360 6. Savannah $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 8. St. Louis Warehouse 7. Dallas 9. Chicago 4. Norfolk 5. New York 6. Savannah $75 125 68 $ 63 110 82 $81 95 95 60 45 50