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
Get step-by-step solutions from verified subject matter experts
