please include formulas for excel and using excel solver... make sure to check make unconstrained variables non negotiable and solve with simplex lp

ent to ch 11 problems part 2 . Saved O Search References Mailings Review View Help Acrobat ===*== ! 211 03 AaBbcod AaBbceDd AaBbc AaBbc 1 Normal No Spac... Heading 1 Heading 2 Find Replace Select Create and Share Adobe PDF Paragraph Styles 5 Editing Adobe Acro S11.35. Globalnet Foods, Inc, imports food products such as meats, cheeses, and pastries to the United States from warehouses at ports in Hamburg, Marseille, 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 (5/1000 lb) from the European ports to the US cities and the available supply (1000 lb) at the European ports are provided in the following table. U.S. CITIES 1. Hamburg $420 $390 $610 55 2. Marseilles 510 590 470 78 3. Liverpool 450 360 480 37 The transportation costs (5/1000 lb) from each U.S. warehouse to the three distribution centers and the demand (1000 lb) at the distribution centers are as follows. DISTRIBUTION CENTER 4. Norfolk $ 75 $ 63 $ 81 5. New York 125 110 95 6. Savannah 68 82 95 60 45 50 Determine the optimal shipments between the European ports and the warehouses and the distribution centers that will minimize total transportation costs o 92F Mostly US Warehouses New York Nortok Savannah Port Hamburg Marseilles Liverpool Shipped Supply 55 78 37 Shipping Costa (8 US Warehouses Shipped Port Norfolk New York Savannah Hamburg 220 340 670 Marseite 510 590 470 Uverpool 450 3000 400 Shipping Costs (5) Distribution Centers St LOUIS Dallas Chicago Shipped Warehouses Norfolk New York Savannah Distribution Centers DAS St LOUIS Chicago 75 63 81 125 95 63 82 95 T10 60 25 50 U.S. Warehouses Norfolk New York Savannah Demand Shipped Transshipments Norfolk New York Savannah Cost ent to ch 11 problems part 2 . Saved O Search References Mailings Review View Help Acrobat ===*== ! 211 03 AaBbcod AaBbceDd AaBbc AaBbc 1 Normal No Spac... Heading 1 Heading 2 Find Replace Select Create and Share Adobe PDF Paragraph Styles 5 Editing Adobe Acro S11.35. Globalnet Foods, Inc, imports food products such as meats, cheeses, and pastries to the United States from warehouses at ports in Hamburg, Marseille, 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 (5/1000 lb) from the European ports to the US cities and the available supply (1000 lb) at the European ports are provided in the following table. U.S. CITIES 1. Hamburg $420 $390 $610 55 2. Marseilles 510 590 470 78 3. Liverpool 450 360 480 37 The transportation costs (5/1000 lb) from each U.S. warehouse to the three distribution centers and the demand (1000 lb) at the distribution centers are as follows. DISTRIBUTION CENTER 4. Norfolk $ 75 $ 63 $ 81 5. New York 125 110 95 6. Savannah 68 82 95 60 45 50 Determine the optimal shipments between the European ports and the warehouses and the distribution centers that will minimize total transportation costs o 92F Mostly US Warehouses New York Nortok Savannah Port Hamburg Marseilles Liverpool Shipped Supply 55 78 37 Shipping Costa (8 US Warehouses Shipped Port Norfolk New York Savannah Hamburg 220 340 670 Marseite 510 590 470 Uverpool 450 3000 400 Shipping Costs (5) Distribution Centers St LOUIS Dallas Chicago Shipped Warehouses Norfolk New York Savannah Distribution Centers DAS St LOUIS Chicago 75 63 81 125 95 63 82 95 T10 60 25 50 U.S. Warehouses Norfolk New York Savannah Demand Shipped Transshipments Norfolk New York Savannah Cost