Question: Don Levine Corporation is considering adding an additional plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St. Louis and East St.

Don Levine Corporation is considering adding an additional plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St. Louis and East St. Louis are being considered. On this sheet, you will evaluate St. Louis. Use Solver to determine the best transportation schedule for the data given. Your answers and the total cost will be in the green cells.

Existing Plant Information
From To Blue Earth To Ciro To Des Moines Capacity
Decatur $20 $25 $22 300
Minneapolis $17 $27 $25 200
Carbondale $21 $20 $22 150
St. Louis $27 $28 $31 150
Demand 250 200 350
Scenario A: New Plant in St. Louis
From To Blue Earth To Ciro To Des Moines
Decatur
Minneapolis
Carbondale
St. Louis
<

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!