****Network design problem using Excel Solver (USE Simplex LP in the solver)****

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 ($/1000 lb) from the European ports to the U.S. cities and the available supply (1000 lb) at the European ports are provided in the following table.

The transportation costs ($/1000 lb) from each U.S. warehouse to the three distribution centers and the demand (1000 lb) at the distribution centers are as follows.

Determine the optimal shipments between the European ports and the warehouses and the distribution centers that will minimize total transportation costs.

ANSWERS ARE BELOW, I NEED HELP AS TO FORMULATING THIS IN EXCEL WITH SOLVER, PLEASE!!!

PLEASE HELP ME OUT! WILL UPVOTE*******

U.S. CITIES EUROPEAN PORT 4. NORFOLK 5. NEW YORK 6.SAVANNAH SUPPLY 1. Hamburg $420 $390 $610 55 2. Marseilles 510 590 470 78 3. Liverpool 450 360 480 37 DISTRIBUTION CENTER WAREHOUSE 7. DALLAS 8. ST. LOUIS 9.CHICAGO 4. Norfolk $ 75 $ 63 $ 81 5. New York 125 110 95 6. Savannah 68 82 95 60 4 45 50 ANSWER Hamburg - Norfolk = 42, NY - Chicago = 50. Marseilles - Savannah = 63, Liverpool - NY = 37. Norfolk - St. Louis = 42. Hamburg - NY = 13. Savannah Dallas = 60. Savannah - St. Louis = 3: Z = $77,362 E F G . K L M Shipped Supply 55 78 37 Shipping Costs ($): U.S. Warehouses Port Norfolk New York Savannah Hamburg 420 390 610 Marseilles 510 590 470 Liverpool 450 360 480 Shipping Costs ($): Chicago Shipped B D 1 2 3 4 U.S. Warehouses 5 Port Norfolk New York Savannah 6 Hamburg 7 Marseilles 8 Liverpool 9 Shipped 10 11 12 Distribution Centers 13 U.S. Warehouses Dallas St. Louis 14 Norfolk 15 New York 16 Savannah 17 Demand 60 45 18 Shipped 19 20 Transshipment flows: 21 Norfolk 22 New York 23 Savannah 24 25 Cost = 26 27 28 29 30 Warehouses Norfolk New York Savannah Distribution Centers Dallas St. Louis Chicago 75 63 81 125 110 95 68 82 95 50