Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Set up an excel file to complete the transshipment problem and have 1 answer report, 1 sensitivity report and 1 limit report included (you can

Set up an excel file to complete the transshipment problem and have 1 answer report, 1 sensitivity report and 1 limit report included (you can delete the ones that are incorrect, should you have any). You will attach this file upon submitting the assignment.

Also answer

  1. What is the minimum cost of shipping while meeting the characteristics of the problem?
  2. Indicate the units shipped on each route (including zero shipments).
  3. What is the range of feasibility for the supply amount from Liverpool and what does the shadow price for Liverpool mean?

image text in transcribed

Exhibit .B World Foods, Inc., imports food products such as meats, cheeses, 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 4. Norfolk 5. New York 6. Savannah Supply European Port 1. Hamburg 2. Marseilles 3. Liverpool $420 510 450 $390 590 360 $610 470 480 55 78 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 7. Dallas 8. St. Louis 9. Chicago Warehouse 4. Norfolk 5. New York 6. Savannah $75 125 68 $63 110 82 $81 95 95 60 45 50 Exhibit .B World Foods, Inc., imports food products such as meats, cheeses, 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 4. Norfolk 5. New York 6. Savannah Supply European Port 1. Hamburg 2. Marseilles 3. Liverpool $420 510 450 $390 590 360 $610 470 480 55 78 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 7. Dallas 8. St. Louis 9. Chicago Warehouse 4. Norfolk 5. New York 6. Savannah $75 125 68 $63 110 82 $81 95 95 60 45 50

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Managerial Finance

Authors: Lawrence J Gitman, Chad J Zutter

7th Edition

0133546403, 9780133546408

More Books

Students also viewed these Finance questions

Question

What are the three categories of time? (p. 291)

Answered: 1 week ago

Question

Define line and staff authority

Answered: 1 week ago

Question

Define the process of communication

Answered: 1 week ago

Question

Explain the importance of effective communication

Answered: 1 week ago

Question

* What is the importance of soil testing in civil engineering?

Answered: 1 week ago