Lab 1
Build Acme’s downside scenario and Q3 reforecast
Scenario
Acme’s biggest customer, Brightline Dental ($96,000/year), hints they may in-source facilities work in Q4. Meanwhile the Q3 reforecast is due. Build both: the reforecast (Riverside upside carried forward) and a downside scenario losing Brightline October 1.
Steps
- 1
Snapshot the current forecast as "pre-Q3-reforecast".
Expected: The snapshot appears in the version list, immutable.
- 2
Create the Q3 reforecast: actuals through August locked, September–December editable. Raise revenue $1,500/month for Riverside and add $4,000 wages in September only.
Expected: Full-year forecast lands ~$221k net income vs. the $210k budget.
- 3
Submit the reforecast for approval and approve it (as the owner).
Expected: It becomes the forecast of record; the budget of record is untouched.
- 4
Copy the approved forecast into a scenario named "Downside - Brightline loss Oct 1" and remove $8,000/month revenue for October–December.
Expected: Scenario revenue drops $24,000 vs. base.
- 5
Stage the response in the same scenario: cut $2,500/month of discretionary spend from October and delay the planned Q4 equipment purchase.
Expected: The scenario’s full-year net income lands roughly $14–16k below base instead of $24k.
- 6
Compare base vs. downside on full-year net income and lowest cash month, and note the decision trigger ("if Brightline gives notice, activate the cuts within 2 weeks").
Expected: A one-line contingency plan exists, with the numbers already agreed.
Checkpoints - you got it right if…
- A named snapshot precedes the reforecast
- Reforecast approved through the workflow; original budget unchanged
- Downside scenario contains both the shock and the staged response
- The decision trigger for activating the downside plan is written down