1. 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 Furone

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question
100%

Please formulate the problem and solve it usingExcel Solver!

1.
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 Ib.) 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
Transcribed Image Text:1. 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 Ib.) 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
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.
Transcribed Image Text: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 7 steps with 7 images

Blurred answer
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,