-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 total transportation costs are ______.
A)$57,500
B)$35,000
C)$48,900
D)$68,125

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 total transportation costs are ______.
A)$57,500 
B)$35,000 
C)$48,900 
D)$68,125

Quizplus · Accepted Answer

The total transportation costs at the optimum solution can be determined by setting up the problem in Excel Solver, ensuring all supply and demand constraints are met exactly (using the "=" sign for these constraints in Solver), and minimizing the total cost. The correct total cost, given this is a hypothetical scenario without specific data, would be based on the successful application of Solver to find the minimum cost that satisfies all constraints. Since we cannot run Excel Solver without the specific data, the answer provided is based on the premise of the question indicating a scenario where Solver has been used correctly.

-Refer to the Data Given in the Table for Acme