Explanation

Excel can create a Scenario Summary Report to compare scenarios.

In Scenario Manager:

Summary → Scenario Summary

Select the result cell, such as Profit.

Excel creates a report containing the scenario assumptions and resulting values.

Example

The exact results depend on the model’s fixed cost and formulas.

Practice

Generate a Scenario Summary Report using Profit as the result cell.