-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 costs from Brighton to Navarre are $21,672.
B)The shipping costs from Cairo to Navarre are $5,580.
C)The shipping costs from Cairo to Sacramento are $9,570.
D)The shipping costs from Fairview to Madison are $18,414.

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 costs from Brighton to Navarre are $21,672. 
B)The shipping costs from Cairo to Navarre are $5,580. 
C)The shipping costs from Cairo to Sacramento are $9,570. 
D)The shipping costs from Fairview to Madison are $18,414.

Quizplus · Accepted Answer

The shipping costs from Brighton to Navarre are $21,672.

-Refer to the Shipping Costs for the Terra Cotta Company