M5"! Global Foods. Inc. Imports food products to the United States from 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 Daiias, St. Louis. and Chicago. The shipping costs [$1.000 lbs.} from the European ports to the U.S> cities and available supplies [1,000 Ibs.l at the European ports are provided In the following table: 1.' - Cone pooen..- The transportation costs [$11,000 lst lfrom each U.S. city of the three distribution centers and the demands {1.000 lbs.) at the distribution centers: -m-sm- M \"\""\""\"" \"-- 90 ED Formulate this problem In Excel and solve to determine the minimum shipping costs required to meet demands. SOLUTION: The optimal solution. the value of the cost. should be $110,185. 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? bl How many pounds should be shipped from Barcelona to Wilmington? c} HOW many pounds should be shipped from Miami to Detroit