Pete’s Plastics manufactures plastic at plants in Miami, St. Louis and Cleveland
ID: 3010885 • Letter: P
Question
Pete’s Plastics manufactures plastic at plants in Miami, St. Louis and Cleveland. Pete needs to ship plastic to customers in Pittsburgh, Atlanta and Chicago. He wants to minimize the cost of shipping the plastic from his plants to his customers. Suppose the unit shipping cost is charged by a flat rate. The data for the problem is summarized in the following table:
Distance From Plants to Customers (miles)
Plant
Pittsburgh
Atlanta
Chicago
Supply
Miami
1200
700
1300
30
St. Louis
700
550
300
40
Cleveland
125
675
350
60
Demand
40
60
20
Build spreadsheet model for this problem and solve it by Solver software.
Distance From Plants to Customers (miles)
Plant
Pittsburgh
Atlanta
Chicago
Supply
Miami
1200
700
1300
30
St. Louis
700
550
300
40
Cleveland
125
675
350
60
Demand
40
60
20
Explanation / Answer
Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550 300 40 Cleveland 125 675 350 60 needed demand 40 60 20 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550 300 40 Cleveland 125 /40 675 350 20 needed demand 0 60 20 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550 300/20 20 Cleveland 125 /40 675 350 20 needed demand 0 60 0 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550/20 300/20 0 Cleveland 125 /40 675 350 20 needed demand 0 40 0 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700 1300 30 St. Louis 700 550/20 300/20 0 Cleveland 125 /40 675/20 350 0 needed demand 0 20 0 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700/20 1300 10 St. Louis 700 550/20 300/20 0 Cleveland 125 /40 675/20 350 0 needed demand 0 0 0 Plant/Miles Pittsburg Atlanta Chicago Supply Remaining Miami 1200 700/20 1300 10 St. Louis 700 550/20 300/20 0 Cleveland 125 /40 675/20 350 0 needed demand 0 0 0
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.