-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 quantity shipped from Birmingham to Madison is more than double the quantity shipped from Brighton to Madison.
B) The quantity shipped from Danbury to Navarre is more than the quantity shipped from Cairo to Kalamazoo.
C) The quantity shipped from Birmingham to Madison is less than the quantity shipped from Brighton to Madison.
D) The quantity shipped from Escondido to Winston is less than the quantity shipped from Danbury to Sacramento.
Correct Answer:
Verified