Excel Scenario Manager Examples for What-If Analysis

Excel Scenario Manager examples include comparing low, expected, and high sales forecasts, testing different staffing plans, or checking how input costs affect a budget. In Microsoft Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Scenario Manager, add scenarios built from input cells, and create a summary report to compare their results.

What Scenario Manager does

Scenario Manager is an Excel what-if analysis tool for saving several sets of input values and switching between them. Each saved set is a scenario. A worksheet formula calculates the result for the currently displayed inputs; a scenario report can then lay out the inputs and results for multiple scenarios side by side.

It is useful when a model has a small number of meaningful assumptions that may change together. For example, a business forecast might vary unit sales, selling price, unit cost, and fixed expenses. A staffing plan might compare weekday and weekend headcount, while a project estimate might compare labor hours and material costs. The tool does not forecast which set of assumptions will occur. It shows what the worksheet calculates if those assumptions are entered.

Scenarios are stored in the workbook, so you can return to named cases without manually retyping every input. They do not replace the model’s formulas: the formulas remain on the worksheet, and the scenario changes the values in selected input cells.

Example: compare sales and cost assumptions

Start with a simple operating-profit model. Put the assumptions in B2:B5 and the calculations in B7:B9. Use these labels and starting values:

A2: Units sold; B2: 1000
A3: Selling price per unit; B3: 25
A4: Variable cost per unit; B4: 14
A5: Fixed costs; B5: 8000
A7: Revenue; A8: Variable costs; A9: Operating profit

With units in B2 and selling price in B3, enter this formula in B7; the example returns 25000.

=B2*B3

With units in B2 and variable cost per unit in B4, enter this formula in B8; the example returns 14000.

=B2*B4

With revenue in B7, variable costs in B8, and fixed costs in B5, enter this formula in B9; the example returns 3000.

=B7-B8-B5

Now create three scenarios using B2:B5 as the changing cells. The expected case uses the starting values. A stronger-demand case might use 1250 units, a price of 26, a unit cost of 14, and fixed costs of 8500. Its revenue is 32500, variable costs are 17500, and operating profit is 6500. A cost-pressure case might use 900 units, a price of 25, a unit cost of 15, and fixed costs of 8500. Its revenue is 22500, variable costs are 13500, and operating profit is 500.

Those outcomes make the example useful: the high-sales case is not simply a higher sales number, because it also includes a price change and higher fixed costs. The cost-pressure case combines lower volume with more expensive inputs. Scenario Manager can apply each group of assumptions together, then report the resulting profit.

How to add and compare scenarios

Keep the model’s input cells separate from its formula cells. In this example, B2:B5 are inputs and B7:B9 are calculated results. Clear labels make the later report easier to read.
On Windows, select Data > What-If Analysis > Scenario Manager. Select Add, enter a name such as Expected, and confirm the changing-cell range, such as B2:B5.
In the Scenario Values dialog, enter the values for that scenario in the order of the changing cells. Confirm the entries and add the other named cases in the same way. Scenario names such as Lower demand or Higher costs are more informative than Scenario 1 and Scenario 2.
To display a saved case on the worksheet, select it in Scenario Manager and choose Show. Excel places that scenario’s values in the changing cells, and the worksheet formulas recalculate.
To compare cases, choose Summary in Scenario Manager. Select Scenario summary, identify result cells such as B7:B9, and create the report. Selecting clear result cells helps keep the report focused on useful outputs.

In Excel for Mac, Scenario Manager is also available in desktop Excel through the Data tab’s What-If Analysis tools, though ribbon layout can differ by release. Excel for the web does not provide the full Scenario Manager workflow; use desktop Excel to create and manage scenarios. A workbook with scenarios may still be opened in the web app, but do not assume the web interface can create or edit them.

Other practical Scenario Manager examples

Monthly staffing plan: Use input cells for employees scheduled on weekdays and weekends, average hours per person, and hourly labor cost. Formula cells can calculate total scheduled hours and estimated labor expense. Scenarios might represent normal coverage, a holiday schedule, and a reduced-coverage plan. This is useful for seeing how several schedule assumptions affect totals, not for automatically generating an optimized rota.

Project estimate: Set inputs for work hours, hourly rates, material quantities, and material prices. Compare a baseline estimate with a case involving extra hours or a rise in material prices. Include formula results for labor, materials, and total estimate so the summary reveals which outcomes move. Treat the results as model outputs, not guaranteed project costs.

Inventory planning: Change forecast demand, order quantity, and unit purchase cost to compare a regular-demand case with a seasonal peak or a slower-sales case. Formulas might calculate expected units remaining or total purchase cost. Make sure the worksheet’s formulas reflect the business rules you intend to model; Scenario Manager only substitutes the saved input values.

Class or event planning: Vary attendee count, room capacity, and per-person supply quantities to compare a small, typical, and large turnout. A separate formula can flag whether expected attendance exceeds capacity. This example is particularly easy to explain because the assumptions and resulting constraints are visible in the grid.

Choosing changing cells and result cells

Changing cells should be the model’s assumptions, not its calculated outputs. If a scenario overwrites a formula cell, that formula may be replaced by a scenario value when the case is shown. Keep a clear distinction between editable inputs and formulas, and consider using cell shading or labels to make input areas recognizable.

Scenario Manager supports up to 32 changing cells per scenario. That is enough for many compact models, but it is a constraint for a large forecast with dozens of independent assumptions. Changing cells can be in separate parts of the worksheet; use the range picker to select the relevant cells, and verify their order before entering each scenario’s values.

Result cells are the formulas or outputs you want to compare, such as profit, total hours, or remaining inventory. Choose a small, meaningful set rather than selecting an entire worksheet. A clear model might report revenue, costs, and profit; a report filled with unrelated intermediate calculations is harder to interpret.

Scenario Summary reports and their limits

The Scenario Summary report creates a new worksheet showing the changing-cell values and selected result cells for the scenarios. It is a convenient comparison table and can help someone who did not build the model understand which assumptions differ. Excel also offers a Scenario PivotTable report, which can organize scenario information for further analysis in a PivotTable.

A report is a snapshot of the scenario comparison when it is created; it does not serve as a live dashboard that automatically refreshes every time the original model changes. If you revise formulas, assumptions, or the set of cases, create a fresh summary when you need an up-to-date comparison. Check that the report’s labels and units are understandable, especially if inputs are percentages, dates, or amounts in different units.

Scenario Manager does not attach probabilities to cases, rank them by likelihood, or explain why a result changed. Those judgments require suitable assumptions and analysis from the person using the model. For money-related examples, the calculations here are illustrative spreadsheet mechanics, not financial, tax, or investment advice. Check actual costs, contractual terms, and other relevant details with the appropriate provider or a qualified professional.

Scenario Manager compared with other what-if tools

Scenario Manager: Best for named bundles of input values, such as baseline, optimistic, and cautious cases. It is useful when several assumptions change together and you want to compare a manageable number of cases.
Data Tables: Best for systematically calculating results across one or two input variables. For example, a two-variable table can show how profit changes across different prices and unit volumes. It is less convenient for a named case that changes several assumptions at once.
Goal Seek: Best for finding one input value that makes a formula reach a target. It answers a question such as what sales volume would produce a specified profit, rather than comparing several saved bundles of assumptions.
Solver: Best for more complex optimization problems involving an objective, adjustable cells, and constraints. Solver is an Excel add-in and may need to be enabled. Scenario Manager does not optimize values or enforce constraints for you.

These tools solve different questions, so one is not universally better. Use Scenario Manager to compare defined cases, a Data Table to explore a compact grid of inputs, Goal Seek to work backward from a target, and Solver when a constrained optimization problem is appropriate.

Common problems and good habits

The result does not change: Check that the formula result cell actually refers to the selected changing cells. Also check that Excel calculation is not set to Manual; if it is, recalculate the workbook.
Values appear in the wrong places: Verify the changing-cell order and the order of values in every scenario. Use adjacent, clearly labeled inputs where practical, or inspect the Scenario Values dialog carefully when inputs are separated.
A formula disappears: A calculated cell may have been included among the changing cells. Restore the formula, then define scenarios using input cells only.
The summary omits a useful outcome: Recreate the report and include the correct result cells. The report does not automatically infer which worksheet outputs matter.
There are too many cases to manage: Keep only cases that answer a distinct question, and use another analysis method if you need to explore many combinations. Scenario Manager is designed for a limited set of named cases, not exhaustive simulation.

Before sharing a workbook, consider showing the intended default scenario on the model sheet, labeling the units, and explaining assumptions such as whether costs are per unit or per period. Save a backup before making major structural changes. These habits reduce the chance that a reader mistakes a scenario input for a fixed fact.

Frequently Asked Questions

Where is Scenario Manager in Excel?
In desktop Excel for Microsoft 365 on Windows, go to Data > What-If Analysis > Scenario Manager. The feature is in desktop Excel; Excel for the web does not offer the same full scenario-management workflow.

How many changing cells can a scenario use?
A scenario can use up to 32 changing cells. If a model needs more, simplify the assumptions, split the analysis into related models, or consider another suitable approach.

Can Scenario Manager change several cells at once?
Yes. A scenario stores a set of values for its selected changing cells, so one named case can change multiple assumptions together. Its result formulas recalculate from those values.

Does a Scenario Summary update automatically?
No. Treat the summary as a report created from the scenarios and results at that point. Recreate it after relevant model or scenario changes when you need a current comparison.

Is Scenario Manager the same as a Data Table?
No. Scenario Manager saves named bundles of assumptions, while a Data Table calculates results across one or two input variables. Choose based on whether you need named cases or a systematic grid of values.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.