You have a worksheet with a calculation to estimate production costs based on cost of raw materials, labor, fuel and delivery costs.You would like to see what would happen if the price of fuel and raw materials spiked.Which what-if analysis tool would be best?
A)Goal Seek
B)Solver
C)Data Tables
D)Scenario Manager

Question

Quizplus · Accepted Answer

The best what-if analysis tool for this scenario would be Scenario Manager which allows for the creation and comparison of different scenarios with changes in multiple input values. In this case, the fuel and raw material prices can be varied and the resulting impact on production costs can be analyzed by creating multiple scenarios.

You Have a Worksheet with a Calculation to Estimate Production