World Foods, Inc., imports food products such as meats, cheese, and pastries to the United States from warehouses at ports in 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 Dallas, St. Louis, and Chicago. The products are then distributed to specialty food stores and sold through catalogs. The shipping costs ($/1,000 lb.) from the European ports to the U.S. cities and the available supplies (1,000 lb.) at the European ports are provided in the following table:   U.S. City   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   The transportation costs ($/1,000 lb.) from each U.S. city of the three distribution centers and the demands (1,000 lb.) at the distribution centers are as follows:     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 Demand     60     45  50           Determine the optimal shipments between the European ports and the warehouses and the ­distribution centers to minimize total transportation costs.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

World Foods, Inc., imports food products such as meats, cheese, and pastries to the United States from warehouses at ports in 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 Dallas, St. Louis, and Chicago. The products are then distributed to specialty food stores and sold through catalogs. The shipping costs ($/1,000 lb.) from the European ports to the U.S. cities and the available supplies (1,000 lb.) at the European ports are provided in the following table:

 

U.S. City

 

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

 

The transportation costs ($/1,000 lb.) from each U.S. city of the three distribution centers and the demands (1,000 lb.) at the distribution centers are as follows:

 

 

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

Demand

    60

    45

 50

 

 

 

 

 

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

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.