Which what-if analysis tool is best to determine the optimal amount of shoes to produce in order to maximize profit and use 100% of materials?
A)Goal Seek
B)Solver
C)Scenario Manager
D)Two-variable Data Table

Question

Quizplus · Accepted Answer

Solver is the best tool because it can take multiple constraints and find the optimal solution. In this case, it can take into account the materials available and determine the number of shoes to produce that will maximize profit while using 100% of the materials. Goal seek can only find a single solution for a single input variable and cannot handle multiple constraints. Scenario Manager and Two-variable Data Table are useful for exploring different scenarios and input values, but cannot find the optimal solution with constraints.

Which What-If Analysis Tool Is Best to Determine the Optimal