BBampaa

Lessons › Demand Planning & Forecasting › S&OP

Demand Planning & Forecasting lesson

S&OP gap

In S&OP (sales and operations planning), the demand plan is compared with what supply can deliver each month.

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

The idea

In S&OP (sales and operations planning), the demand plan is compared with what supply can deliver each month:

Formulas

Supply − Demand

Key points

GapSupply − Demand, for each month.
Build aheadExtra supply in quiet months becomes stock for the peak.
S&OPA monthly meeting where sales, supply and finance agree one plan.

S&OP turns a forecast into a plan everyone can act on.

Practice

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

1. In D6, work out November's gap: supply − demand.
=C6-B6
2. Tap the first month where demand is more than supply.
October: 1,500 demand against 1,400 supply.
3. Make a pivot table of total demand by quarter.
Rows: Quarter, Values: Sum of Demand
4. Which visual shows the S&OP meeting how demand changes month by month?
Line chart

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