Alt LP Template From Flow in From Total cost. = To Flow balance equations Flow out Location Flow in Flow out Net flow Sign | RHS ANSWERS TO QUESTIONS (do not just put numbers - answers should be complete sentences) a)Denmark did not ship out all its supply. M9_4. Laptops R Us manufactures laptops France, Spain, and Denmark. They only partial build the laptops in Europe and then ship the partially completed laptops to Brazil, Costa Rica, and Peru and have them completed before final shipment to the U.S. distributors in Alabama, Maryland, and Illinois. The available supply from the European plants and the demand of the U.S, distributors States as follows: European Plant France Spain Denmark Supply (units) 550 680 490 U.S. Distributor Alabama Maryland Illinois Demand (units) 450 500 580 The unit costs of shipping partially completed laptops to the plants in South and Central America for finishing before sending them to the United States are as follows: European Plant France Brazil $280 Spain 180 Denmark 200 Factory Costa Rica $240 Peru $220 220 200 180 170 The unit costs of shipping completed laptops from the plants in South and Central America to the United States are as follows: U.S. Distributor Factory Alabama Maryland Illinois Brazil Costa Rica Peru $160 $140 $180 120 160 140 180 140 160 Formulate this problem in Excel and solve to determine the optimal shipment of laptops that will meet the demand at the U.S. Distributors at the minimum total cost. SOLUTION: The optimal solution, the value of the cost, should be $509,400. This is a transshipment problem. (Hint: count the supply available at the European countries and compare them to the demand needed at the distribution centers to determine which location (European country or U.S. Distributor) will have the inequality). Questions: a) Which European country did not ship out all its supply? b) Did any U.S. distributor receive shipment from more than one plant in South and Central America? Explain. c) Did any plant in South and Central America receive shipments from more than European country? Explain.