-Refer to the data given for production and shipping costs for Auto Parts,Inc.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 number of units shipped from Kolkata to Naples is one fourth of the total quantity produced by Tokyo.
B)The Naples market requires more than can be produced by Tokyo alone.
C)The quantity shipped from Tokyo to Naples is equal to the quantity shipped from Bangkok to Naples.
D)The cost of producing/shipping from Tokyo to Naples is more than the cost of producing/shipping from Kolkata to Naples.

Question

-Refer to the data given for production and shipping costs for Auto Parts,Inc.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 number of units shipped from Kolkata to Naples is one fourth of the total quantity produced by Tokyo. 
B)The Naples market requires more than can be produced by Tokyo alone. 
C)The quantity shipped from Tokyo to Naples is equal to the quantity shipped from Bangkok to Naples. 
D)The cost of producing/shipping from Tokyo to Naples is more than the cost of producing/shipping from Kolkata to Naples.

Quizplus · Accepted Answer

The number of units shipped from Kolkata to Naples is one fourth of the total quantity produced by Tokyo.

-Refer to the Data Given for Production and Shipping Costs