-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,the number of units shipped from Tokyo to Naples is ______.
A)500
B)1,200
C)3,500
D)4,850

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,the number of units shipped from Tokyo to Naples is ______.
A)500 
B)1,200 
C)3,500 
D)4,850

Quizplus · Accepted Answer

The balanced transportation problem requires that supply equals demand. The optimal solution, calculated using Excel Solver, indicates that 500 units are shipped from Tokyo to Naples.

-Refer to the Data Given for Production and Shipping Costs