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
Question
100%

Please formulate the problem and solve it usingExcel Solver!

1. **World Foods, Inc. Supply Chain Overview**

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. These goods are transported via ships to Norfolk, New York, and Savannah, where they are stored in company warehouses. Subsequently, they are sent to distribution centers located in Dallas, St. Louis, and Chicago. Ultimately, the products are distributed to specialty food stores and sold through catalogs.

### Shipping Costs:

The costs for shipping the products (expressed in $/1,000 lb.) from the European ports to the U.S. cities, along with the available supplies (in 1,000 lb.) at each European port, are detailed in the following table:

| European Port | U.S. City Costs (per 1,000 lb.)                          | Supply (1,000 lb.) |
|---------------|-----------------------------------------|----------------|
|               | **4. Norfolk** | **5. New York** | **6. Savannah** |                 |
| 1. Hamburg    | $420           | $390             | $610            | 55              |
| 2. Marseilles | $510           | $590             | $470            | 78              |
| 3. Liverpool  | $450           | $360             | $480            | 37              |

### Transportation Costs and Demands:

The transportation costs (in $/1,000 lb.) from each U.S. city to the distribution centers, along with the demand (1,000 lb.) at these centers, are provided below:

| Distribution Center | Transportation Costs (per 1,000 lb.)   |
|---------------------|--------------------------------------------------|
| Warehouse 7. Dallas | 8. St. Louis | 9. Chicago |
| -                         | -                      | -                     |

(Note: The specific costs and demands for each distribution center are not provided in the visible part of the image.)
Transcribed Image Text:1. **World Foods, Inc. Supply Chain Overview** 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. These goods are transported via ships to Norfolk, New York, and Savannah, where they are stored in company warehouses. Subsequently, they are sent to distribution centers located in Dallas, St. Louis, and Chicago. Ultimately, the products are distributed to specialty food stores and sold through catalogs. ### Shipping Costs: The costs for shipping the products (expressed in $/1,000 lb.) from the European ports to the U.S. cities, along with the available supplies (in 1,000 lb.) at each European port, are detailed in the following table: | European Port | U.S. City Costs (per 1,000 lb.) | Supply (1,000 lb.) | |---------------|-----------------------------------------|----------------| | | **4. Norfolk** | **5. New York** | **6. Savannah** | | | 1. Hamburg | $420 | $390 | $610 | 55 | | 2. Marseilles | $510 | $590 | $470 | 78 | | 3. Liverpool | $450 | $360 | $480 | 37 | ### Transportation Costs and Demands: The transportation costs (in $/1,000 lb.) from each U.S. city to the distribution centers, along with the demand (1,000 lb.) at these centers, are provided below: | Distribution Center | Transportation Costs (per 1,000 lb.) | |---------------------|--------------------------------------------------| | Warehouse 7. Dallas | 8. St. Louis | 9. Chicago | | - | - | - | (Note: The specific costs and demands for each distribution center are not provided in the visible part of the image.)
**Transportation Costs and Demand Data**

The table below outlines the transportation costs (in dollars per 1,000 pounds) from each warehouse in U.S. cities to three distribution centers, along with the demand in each distribution center (in 1,000 pounds):

| Warehouse  | Distribution Center 7: Dallas | Distribution Center 8: St. Louis | Distribution Center 9: Chicago |
|------------|------------------------------|--------------------------------|-------------------------------|
| 4. Norfolk | $75                           | $63                            | $81                           |
| 5. New York| $125                          | $110                           | $95                           |
| 6. Savannah| $68                           | $82                            | $95                           |

**Demands:**

- Dallas: 60,000 pounds
- St. Louis: 45,000 pounds
- Chicago: 50,000 pounds

---

**Objective:**

Determine the optimal shipments between the European ports and the warehouses, and then from the warehouses to the distribution centers, to minimize total transportation costs.
Transcribed Image Text:**Transportation Costs and Demand Data** The table below outlines the transportation costs (in dollars per 1,000 pounds) from each warehouse in U.S. cities to three distribution centers, along with the demand in each distribution center (in 1,000 pounds): | Warehouse | Distribution Center 7: Dallas | Distribution Center 8: St. Louis | Distribution Center 9: Chicago | |------------|------------------------------|--------------------------------|-------------------------------| | 4. Norfolk | $75 | $63 | $81 | | 5. New York| $125 | $110 | $95 | | 6. Savannah| $68 | $82 | $95 | **Demands:** - Dallas: 60,000 pounds - St. Louis: 45,000 pounds - Chicago: 50,000 pounds --- **Objective:** Determine the optimal shipments between the European ports and the warehouses, and then from the warehouses to 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
Similar questions
  • SEE MORE QUESTIONS
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,