11.2 Scenario Manager
In short: Scenario Manager stores sets of input values (scenarios) and switches between them or summarises them.
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
The scenario summary sheet is static – it doesn't update when the model changes, and many students send the manager an old summary. When the model changes, generate the Summary again. And name the input cells first, otherwise the summary shows things like "$B$2", which are hard to read.
Ravindra Bagale's Tip – मराठी
Scenario summary sheet static असते – model बदलला तर ती update होत नाही, बरेच students जुना summary manager ला पाठवतात. Model बदलला की Summary पुन्हा generate करा. आणि input cells ना आधी नावं द्या, नाहीतर summary मध्ये "$B$2" असं वाचायला कठीण दिसतं.
Ravindra Bagale's Tip – हिंदी
Scenario summary sheet static होती है – model बदलने पर वह update नहीं होती, और बहुत से students manager को पुराना summary भेज देते हैं. Model बदलते ही Summary दोबारा generate करो. और input cells को पहले नाम दो, वरना summary में "$B$2" जैसा दिखता है जो पढ़ना मुश्किल है.
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.