Lessons › Demand Planning & Forecasting

9 free lessons

Demand Planning & Forecasting lessons

Demand planning and forecasting: moving averages, seasonality, forecast bias and accuracy, promotion uplift, event stock and S&OP, in Excel and Power BI.

Forecasting basics

• Moving averageForecast from recent weeks
• Seasonal indexHow much busier each quarter is
• Seasonal forecastBase forecast × seasonal index

Forecast quality

• Forecast biasToo high, or too low?
• Forecast accuracyHow close, ignoring direction

Events and promotions

• Promotion upliftHow much a promotion adds
• Event stockOrder enough for the big week

S&OP

• S&OP gapCan supply meet demand?
• What-if scenariosTest the plan before it happens