Question

ULUI Dana Johnson Corp. is considering adding a fourth plant to its three are shown in the table ting es in Decatur, Minneapolis, and Carbondale Both St. Louis and East St. Louis reborg onded. The stations Decatur Blue Earth From Existing Plants Minneapolis Carbondale $17 20 Demand Des Moines Capacity $25 $22 From Proposed Plants East St Louis Blue Earth Cire Des Moines Capacity Using the unit production costs in the following the show which locations you the best Location Production Costs Minneapolis Carbondale East St Louis St Louis Enter your owwer in the answer box and then click Check Answer All parts showing Clov An 'MacBook TelwER

Answer 1

>> When St. Louis is selected

A Bi F To From Minneapolis Carbondale Demand Decatur St.Louis 20 450 Blue Earth 27 2 17 21 250 25 22 28 3 Ciro 27 20 500 31 Des Moines 4 25 27 450 250 Capacity Decision Variables 350 150 6 Number of units to be transported from each plant to each location 7 To From Minneapolis Carbondale Decatur St.Louis 8 Blue Earth 91 10 Circ 11 Des Moines Objective function 12 Minimize the total costs 12 14 . . -SUMPRODUCT(B9: E11, B2: E4) +B5*50+C5*60+D5*70+E5*50 Constraints 15 16 SUM(B9:E9) 17 SUM(B10:E10) F2 F3 18 SUM(B11:E11) =F4 19 SUM(B9:B11) 20 -SUM(C9:C11) 21 SUM(D9:D11) -85 =C5 -D5 22 -SUME9:F11) -FS

A B C D F G To From 1 Minneapolis Carbondale Demand Decatur St.Louis Blue Earth 450 2 20 17 21 27 2 Ciro 25 27 20 28 250 500 4. Des Moines 22 25 22 31 Сарacity 5 450 350 150 250 Decision Variables 6 Number of units to be transported from each plant to each location 7 To From Carbondale 8 Decatur Minneapolis St.Louis Blue Earth 10 Ciro 11 Des Moines Objective function 12 Minimize the total costs 13 14 66500 Constraints 15 16 C 450 17 0 250 18 500 19 0 450 20 350 21 0 150 22 C 250 LO

Reapply Tet to Sort Filter What-Jf For X Solver Parameters SAS14 Set Objective: To: Value Of Min Max ooli By Changing Variable Cells: SBS9:SES11 Subject to the Constraints: SAS16:SA$22 SC$16:SCS22 SBS9:SES11>= 0 Add m e Change ooli Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close

Decision Variables 6 Number of units to be transported from each plant to each location 7 To From Carbondale Minneapolis 8 Decatur St.Louis Blue Earth 350 0 100 10 Ciro 0 100 150 11 Des Moines 450 0 50 0 Objective function 12 Minimize the total costs 13 14 92350

\>> When East. St Louis is selected,

D E East St.Loui To From Minneapolis Carbondale Demand 1 Decatur 450 Blue Earth 2 20 17 21 29 250 3 Ciro 25 27 20 20 500 4 Des Moines 27 25 27 20 450 350 250 5 Capacity Decision Variables 150 6 Number of units to be transported from each plant to each location 7 To From Minneapolis East St.Louis Carbondale Decatur Blue Earth Ciro 10 11 Des Moines Objective function 12 Minimize the total costs 13 14 SUMPRODUCT(B9:E11, B2:E4)+B5*50+C5*60+D5* 70+E5*40 Constraints 15 16 SUM(B9:E9) 17 -SUM(B10:E10) 18 SUM(B11:E11) 19 SUMB9:B11) 20 SUM(C9:C11) 21 SUM(D9:D11) =F2 EF3 =F4. =B5 C5 ED5 22 SUM(E9:E11) E5

A C P To From Carbondale East St.Louis Demand Minneapolis 1 Decatur Blue Earth 2 20 17 21 29 450 3 Ciro 25 27 20 30 250 4 Des Moines 22 25 22 30 500 5 Сарacity 450 350 150 250 Decision Variables 6 Number of units to be transported from each plant to each location 7 To From Carbondale East St.Louis Minneapolis 8 Decatur Blue Earth 10 Ciro 11 Des Moines Objective function 12 Minimize the total costs 13 14 64000 Constraints 15 16 0 450 17 0 250 18 500 19 C 450 20 350 21 0 150 22 250

Reapply Tet to Sort Filter What-Jf For X Solver Parameters SAS14 Set Objective: To: Value Of Min Max ooli By Changing Variable Cells: SBS9:SES11 Subject to the Constraints: SAS16:SA$22 SC$16:SCS22 SBS9:SES11>= 0 Add m e Change ooli Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close

Capacity Decision Variables 6 Number of units to be transported from each plant to each location 7 To From Carbondale East St.Louis Minneapolis 8 Decatur Blue Earth 100 350 0 0 10 Ciro 0 0 150 100 11 Des Moines 350 0 0 150 Objective function 12 Minimize the total costs 13 14 90150

The total cost is lesser when East St. Louis is selected.

Johnson Corp should select East St. Louis with a total cost of $90150