Me.3 Global Foods, Inc. imports food products to the United States from Hamburg, Marseilles, and To Flow balance equations Liverpool Ships from these ports deliver the products to Norfolk, New York, and Savannah, where they From Flow out Location Flow in Flow out Net flow Sign RHS are stored in company warehouses before being shipped to distribution centers in Dallas, St. Louis, and Flow in Chicago. The shipping costs (5/1,000 lbs.) from the European ports to the U.S> cities and available To supplies (1,000 lbs.) at the European ports are provided in the following table: From Shipping Costs ($/1,000 Ibs.): Total cost U.S. Warehouses ANSWERS TO QUESTIONS (do not just put numbers - Supply answers should be complete sentences) Port Charleston Miami Wilmington (1,000 lbs.] Rotterdam $525 $488 $765 110 a Barcelona $625 $740 $590 125 Genoa $550 $450 $600 65 b) The transportation costs (5/1,000 lbs.) from each U.S. city of the three distribution centers and the demands (1,000 lba.) at the distribution centers: Distribution Center Houston Denver Detroit Charleston $105 $90 $110 From Miami $175 $154 $133 Warehouse Wilmington $115 $133 Demand (1,000 lbs.) 180 90 Formulate this problem in Excel and solve to deter um shipping costs required to meet demands. SOLUTION: The optimal solution, the value of the cost, should be $170,785. This is a transportation problem. (Hint: count the supply available at the European ports and compare them to the demand needed at the distribution centers to determine which location (European port or distribution center) will have the inequality). Questions a) Which European supplier did not ship out all its supply? b) How many pounds should be shipped from Barcelona to Wilmington? How many pounds should be shipped from Miami to Detroit