Skip to main content
Back to AI Academy
FREENo

Demand Forecasting in Practice

For CSCOs, S&OP heads, demand planners, operations directors past basic AI literacy. Eight chapters across the demand-forecasting surface: the forecasting landscape (Gartner 78% adoption / 41% measurable lift, McKinsey 15–30% MAPE reduction / top-decile 30–50%, M5 LightGBM domination, Hyndman canonical reference, Tetlock calibration > confidence); accuracy and the MAPE trap (APICS +5–12% structural bias, MAPE asymmetry, sMAPE/MASE/RMSSE alternatives, M5 used RMSSE, APICS $0.5–1.5M per percentage point); choosing the right model (3-variable decision tree — history × signal × granularity, LightGBM granular, classical aggregated, Croston intermittent, ensemble options); demand sensing (Blue Yonder + o9, POS/weather/social signals, 5–15% lift on 4-week horizon, confidence-weighted overrides, noise-chasing risk); promotional uplifts (Coca-Cola/Unilever/Carrefour 20–40% improvement, 3-component pattern, calendar drift failure mode); NPI (P&G McKinsey case 2024, analog-product lookup + first 4-week signal, judgement layer); S&OP integration (SCC 38% gap, FVA analysis, LokadTech LLM hallucination case, quote-or-cut narrative); and the close — 2-quarter rollout playbook with interactive builder, 4 trust trip-wires, through-line: planners with ML beat planners without it, planners plus ML still beats ML alone, calibration matters more than confidence.

8

Chapters

~35 min

Duration

Intermediate

Level

No

Certification

Course Content

01

The forecasting landscape

Gartner SCT25 2025: 78% have AI-in-forecasting initiative, 41% measurable lift. McKinsey: 15–30% MAPE reduction (top quartile), 30–50% top decile. M5 LightGBM domination, classical competitive on aggregates. SAP IBP/Oracle/Blue Yonder/o9/Kinaxis. Tetlock: calibration > confidence.

02

Accuracy, bias, and the MAPE trap

APICS 2024-25: median bias +5 to +12% (over-forecasting, structural). MAPE asymmetry — biased toward under-forecasting, catastrophic on intermittent demand. M5 used RMSSE. Use sMAPE/MASE/RMSSE by context. APICS: 1pp MAPE = $0.5–1.5M per $100M.

03

Choosing the right model

The 3-variable decision tree: history × signal × granularity. LightGBM for long-history granular, ETS/ARIMA/Theta for aggregated, Croston (or Croston-LightGBM hybrid, Boylan 2024) for intermittent, analog-lookup for short history. Ensemble for robustness. ML weak past 6 months.

04

Demand sensing

Blue Yonder + o9. POS, weather, ad spend, social signals. 5–15% MAPE reduction on 4-week horizon. Confidence-weighted overrides + cap on magnitude. Signal hygiene (POS latency, mapping) + FVA shadow-mode before production. Noise-chasing failure mode.

05

Promotional & event uplifts

Coca-Cola / Unilever / Carrefour 2024-25 cases: 20–40% accuracy improvement on promotional weeks. Pattern: clean promo calendar + LightGBM uplift model + explicit cannibalisation modelling. Calendar drift (planned ≠ executed) is the failure mode.

06

New product introduction

P&G NPI case via McKinsey 2024. Analog-product lookup + first-4-week early signal. Category expert picks analogs (judgement layer), ML does the math. Lock forecast for first 4 weeks, then re-tune. 3 buckets: analog-rich, analog-thin, genuinely novel.

07

Connecting forecast to S&OP

SCC 2025: only 38% connect ML forecast to executive S&OP decisions. The gap is narrative + accountability. LokadTech 2025 LLM hallucination case (phantom promotion). FVA analysis (Gilliland/SAS) measures where in the chain accuracy is added or lost. Quote-or-cut for S&OP commentary.

08

Making it stick: your demand-forecasting roadmap

2 use cases · 2 quarters · 1 FVA discipline. Q1 = baseline ML on top 100 SKUs + FVA. Q2 = demand sensing OR promo uplift. 4 trust trip-wires: no unexplainable model, no unrecorded override, no AI narrative without source check (LokadTech rule), no "set and forget". Interactive roadmap builder.