11.2 Scenario Manager
Scenario Manager stores sets of input values (scenarios) and switches between them or summarises them.
| Scenario | Orders/day (B2) | AOV (B3) |
|---|---|---|
| Normal | 400 | ₹320 |
| Ganeshotsav | 520 | ₹340 |
| Monsoon slump | 330 | ₹300 |
Steps in Excel
- Name the input cells first (Name Box:
OrdersPerDay,AOV) and the result (Profit) – the summary report then shows names instead of addresses. - Data › Forecast › What-If Analysis › Scenario Manager… › Add…
- Scenario name
Normal› Changing cellsB2:B3› OK › enter 400 and 320 › Add to create the next scenario (Ganeshotsav 520/340, Monsoon slump 330/300) › OK. - Select a scenario › Show to put its values into the model.
- Summary… › Result cells
B13› Scenario summary › OK. A new sheet shows all scenarios side by side.
Result (Profit): Normal −₹94,800; Ganeshotsav +₹67,920; Monsoon slump −₹1,92,600.
Ravindra Bagale's Tip
Scenario summary sheet static aste – model badalla tar ti update hot nahi, khup students juna summary manager la pathavtat. Model badalla ki Summary punha generate kara. Ani input cells la aadhi nava dya, nahitar summary madhe "$B$2" asa vachayla kathin disto.
Practice task
Add a fourth scenario "Diwali" (600 orders/day, AOV ₹360, delivery cost ₹32) and create a scenario summary with Profit and Revenue as result cells.