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 Decatur Minneapolis Carbondale St. Louis Demand To Blue Earth $20 $17 $21 $27 To Ciro $25 $27 $20 $28 To Des Moines $22 $25 $22 $31 250 200 350 Capacity 300 200 150 150 Scenario A: New Plant in St. Louis From Decatur Minneapolis Carbondale St. Louis total demand To Blue To Des Earth To Ciro Moines 300 200 100 50 50 100 0 250 200 350 250 200 350 17250 <