BBampaa

Lessons › Demand Planning & Forecasting › S&OP

Demand Planning & Forecasting lesson

What-if scenarios

Planners test scenarios before they commit. Here's the 6-month total under four scenarios.

Try this lesson free →
About 5–10 minutes · no sign-up needed

The idea

Planners test scenarios before they commit. Here's the 6-month total under four scenarios:

Formulas

Supply − Demand

Key points

ScenarioOne change to the plan, like a promotion or extra capacity.
CompareWork out the gap for each scenario, side by side.
DecidePick the plan, or the mix of actions, with the smallest risk.

What-if analysis shows the cost of a decision before you make it.

Practice

Try each one in your head first, then open the answer.

1. Start with the 6-month plan. In G2, total the demand. Each answer stays in the report as you go.
=SUM(B2:B7)
2. In G3, total the supply.
=SUM(C2:C7)
3. In G4, work out the 6-month gap: supply − demand.
=G3-G2
4. In G5, find the peak month's demand.
=MAX(B2:B7)
5. In G6, count the months where supply falls short (a negative gap).
=COUNTIF(D2:D7,"<0")

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed