-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 lowest non-zero shipment is from Aberdeen to Lakeland.
B)The lowest non-zero shipment is from Birmingham to Kalamazoo.
C)The lowest non-zero shipment is from Cairo to Winston.
D)The lowest non-zero shipment is from Fairview to Navarre.

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 lowest non-zero shipment is from Aberdeen to Lakeland. 
B)The lowest non-zero shipment is from Birmingham to Kalamazoo. 
C)The lowest non-zero shipment is from Cairo to Winston. 
D)The lowest non-zero shipment is from Fairview to Navarre.

Quizplus · Accepted Answer

The transportation problem solution using Excel Solver indicates that the lowest non-zero shipment is from Aberdeen to Lakeland.

-Refer to the Shipping Costs for the Terra Cotta Company