-Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?
A)The shipping cost from all plants to Kalamazoo is $15,656.
B)The shipping cost from all plants to Lakeland is $14,280.
C)The shipping cost from all plants to Madison is $28,810.
D)The shipping cost from all plants to Winston is $21,123.

Question

-Refer to the shipping costs for The Terra Cotta Company.Solve the transportation problem using Excel Solver.(Remember that in balanced transportation problems all constraints-except the non-negativity constraints of the decision variables-should be set as an equal-to (=)sign in the Excel Solver dialogue.)At the optimum solution,which of the following statements is true?
A)The shipping cost from all plants to Kalamazoo is $15,656. 
B)The shipping cost from all plants to Lakeland is $14,280. 
C)The shipping cost from all plants to Madison is $28,810. 
D)The shipping cost from all plants to Winston is $21,123.

Quizplus · Accepted Answer

DThe correct answers are based on the optimal solution obtained from Excel Solver for the transportation problem. In such problems, Solver finds the least cost way to ship goods from several suppliers to several consumers. The statements about the shipping costs to Madison and Winston being $28,810 and $21,123, respectively, indicate that these are the costs associated with the optimal solution for shipping to these locations. This implies that, based on the constraints and costs provided in the problem, the minimum total shipping cost to Madison and Winston are as stated, reflecting the outcome of running the Solver.

-Refer to the Shipping Costs for the Terra Cotta Company