-Refer to the data given in the table for Acme Widgets,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 shipment of widgets from Riverside to Huntsville is ______.
A)2,500
B)4,200
C)4,500
D)5,000

Question

-Refer to the data given in the table for Acme Widgets,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 shipment of widgets from Riverside to Huntsville is ______.
A)2,500 
B)4,200 
C)4,500 
D)5,000

Quizplus · Accepted Answer

The optimum solution for a transportation problem using Excel Solver involves finding the most cost-effective way to distribute goods from several suppliers to several consumers. In this case, the specific shipment from Riverside to Huntsville being 5,000 indicates that, after setting up the problem correctly in Excel Solver with all constraints and solving, the optimal number of widgets to ship from Riverside to Huntsville to minimize costs or meet another objective is 5,000.

-Refer to the Data Given in the Table for Acme