What Is Forecasting?

Forecasting is the quantitative process of using historical demand data — time series of shipments, sales, or consumption — and mathematical models to project future demand over a planning horizon. It is a statistical discipline, concerned with pattern recognition: detecting and extrapolating trends, seasonal cycles, and underlying signals from noisy data.

Forecasting is systematic and reproducible: given the same data and the same model, two people running the same algorithm will produce the same output. This repeatability is its strength — and also its limitation. A statistical model knows only what the historical data can tell it. It cannot anticipate a product discontinuation, a competitor recall, a promotional campaign, or a market disruption that has not happened before.

The role of the statistical forecast

In a mature demand planning process, the statistical forecast is the starting point — not the finished product. It provides the evidence-based baseline that commercial and market intelligence is layered on top of. Its role is to remove the unconscious biases that come from purely judgemental forecasting: the salesperson who always under-forecasts to ensure they beat target; the marketing team that over-forecasts promotional uplift; the operations manager who over-forecasts to guarantee supply availability.

Statistical forecast role: Anchors the demand plan to historical patterns. Removes human anchoring bias. Provides a neutral baseline for commercial review and adjustment.

What forecasting does not do

What Is Demand Planning?

Demand planning is the end-to-end business process through which an organisation arrives at a single, credible forecast of future demand — the consensus demand plan — and translates it into supply chain instructions. It encompasses data collection, statistical modeling, commercial review, cross-functional consensus building, and handoff to supply planning.

Demand planning is as much an organisational process as it is an analytical one. Its output — the consensus demand plan — is meaningful only because every function has committed to it. An accurate forecast that no one acts on has no value. A somewhat imprecise forecast that everyone plans from produces better supply chain outcomes than a theoretically perfect forecast that sales, operations, and finance each override independently.

Demand planning scope

Planning Horizon Primary Activity Key Output
Short-term (0–4 weeks) Demand sensing; order book analysis; short-term adjustments Executable demand signal for supply scheduling
Medium-term (1–6 months) Statistical forecasting + commercial overlays; promotional planning; consensus review Consensus demand plan feeding supply and inventory planning
Long-term (6–24+ months) Market-based projections; portfolio strategy; new product / phase-out planning Strategic demand signal for capacity planning, S&OP, and financial planning

Key Differences: Forecast vs Demand Planning

Dimension Forecasting Demand Planning
Nature Mathematical / statistical process Business process — cross-functional, decision-oriented
Input Historical demand data (time series) Statistical forecast + commercial intelligence + market data + financial targets
Output A number (projected demand quantity) A plan — a consensus, signed-off demand plan with assumptions documented
Who does it Demand planner / data analyst / algorithm Demand planner + sales + marketing + finance + supply chain leadership
Intelligence incorporated Only what is in the historical data History + promotions + new products + competitive moves + market trends + customer intelligence
Frequency Can be continuous / automated Typically monthly (aligned to S&OP cycle)
Accountability Owned by the model / algorithm Owned by the business — a committal plan with named stakeholders
Horizon Whatever the model is calibrated to produce Multi-horizon: short (execution), medium (supply planning), long (capacity/finance)
Role in supply chain Input to demand planning Input to supply planning, inventory management, S&OP, and financial forecasting

The Demand Planning Process

A mature demand planning process follows a structured monthly cycle, aligned with the broader S&OP rhythm. Each step has defined inputs, responsible parties, and outputs.

Step 1: Data Collection and Cleansing

Before any forecasting model can run, demand history must be cleansed. Raw shipment history contains events that should not be extrapolated — promotional spikes, one-off bulk orders, stockout-impacted periods where actual demand was higher than recorded shipments, prior forecast errors propagated through the supply chain. Demand history cleaning is one of the highest-value activities in demand planning and one of the most consistently under-invested.

Step 2: Statistical Baseline Generation

The cleansed demand history is fed into the forecasting engine to generate a statistical baseline. The choice of statistical method should be driven by the demand pattern actually present in the data:

For full method explanations, see the Demand Forecasting Guide.

Step 3: Commercial and Market Intelligence Overlays

The statistical baseline is presented to commercial stakeholders — sales, marketing, key account managers, product managers — for review and adjustment. Commercial overlays should be specific, quantified, and assumption-documented:

Step 4: Consensus Demand Review

The demand review brings together demand planning, sales, marketing, and finance to review the working demand plan, resolve disagreements, and agree on a consensus. Key discipline points:

Step 5: Handoff to Supply Planning

The approved consensus demand plan is released to supply planning to drive constrained supply plan generation, safety stock target setting, purchase order creation, and production scheduling. The quality of the supply plan is bounded by the quality of the demand plan — a biased or inaccurate demand plan propagates through the entire supply chain, generating excess inventory, stockouts, or both simultaneously.

Step 6: Performance Review and Calibration

Every planning cycle must close with a review of forecast accuracy from the prior cycle. No improvement in demand planning is possible without systematic measurement of forecast error. Accountability for forecast accuracy drives behaviours — documented assumptions enable learning; unmeasured forecasts drift.

Forecasting Methods Overview

Method Best For Key Characteristic
Naïve / Last Period Benchmark comparison only Forecast = last period actual. Used as FVA baseline.
Simple Moving Average (SMA) Very stable demand, no trend or seasonality Average of last N periods. Slow to respond to step changes.
Weighted Moving Average (WMA) Stable demand with some recency weighting desired Like SMA but recent periods get higher weights.
Single Exponential Smoothing (SES) Stable demand, no trend or seasonality Exponentially decaying weights; alpha controls responsiveness.
Double Exponential Smoothing (Holt) Trended demand, no seasonality Separates level and trend components; alpha and beta parameters.
Triple Exponential Smoothing (Holt-Winters) Trended demand with seasonality Adds seasonal component (gamma); additive or multiplicative.
Croston's Method Intermittent / sporadic demand Separately models inter-demand intervals and demand size when demand occurs.
Linear Regression Causal demand (price elasticity, economic drivers) Regresses demand on one or more explanatory variables.
Machine Learning (gradient boosting, neural nets) Large data availability; complex demand patterns; multiple causal features Automatically detects non-linear patterns; requires careful validation to avoid overfitting.

See the Demand Forecasting Guide for worked examples and full method explanations.

Demand Sensing

Demand sensing is a technique that dramatically improves near-term forecast accuracy by replacing projected demand with actual real-demand signals as close to execution as possible. Rather than running a monthly forecast cycle and leaving the short-horizon plan unchanged until the next cycle, demand sensing continuously updates the 1–4 week demand signal based on high-frequency data.

Demand sensing data sources

Demand sensing vs Statistical Forecasting

Dimension Statistical Forecasting Demand Sensing
Horizon 1–24 months 1–4 weeks
Update frequency Monthly Daily or more frequently
Data inputs Monthly or weekly shipment history Daily POS, order intake, inventory levels, external signals
Purpose Plan production, procurement, and inventory Adjust execution schedules and safety stock triggers in near real-time
Typical MAPE improvement Baseline accuracy method Typically reduces week-1 MAPE by 20–40% vs statistical monthly forecast

Demand Planning KPIs

Measuring demand planning performance is essential for continuous improvement. The key metrics address both the accuracy dimensions of the forecast and the process health indicators.

KPI Formula Target / Benchmark What It Measures
MAPE (Mean Absolute Percentage Error) (1/n) × Σ|Actual − Forecast| / Actual × 100% <20% at SKU level; <10% at product family Average magnitude of forecast error, direction-neutral
Forecast Bias Σ(Forecast − Actual) / ΣActual × 100% −5% to +5% Systematic over- or under-forecasting — the more dangerous accuracy problem
MAE (Mean Absolute Error) (1/n) × Σ|Actual − Forecast| Context-dependent (unit-based) Absolute error in units — useful for safety stock sizing
Forecast Value Add (FVA) MAPE(adjusted) − MAPE(naïve baseline) Negative (each step should improve accuracy) Whether each planning process step adds or destroys forecast accuracy
Forecast Coverage % of SKUs with a formal forecast in the system >95% of A/B SKUs Completeness of the demand planning process
Plan Stability % change in the forecast between planning cycles for the same horizon bucket <15% change per cycle for M+2 and beyond Frequency and magnitude of forecast revisions — high instability signals process dysfunction

The Bias vs MAPE Priority

Bias is more operationally damaging than high MAPE. A forecast with high MAPE but no systematic bias generates random overshoots and undershoots — the supply chain copes with safety stock. A biased forecast consistently pulls inventory in the wrong direction: a persistent positive bias (over-forecast) builds excess stock and eventually triggers write-offs; a persistent negative bias (under-forecast) generates chronic stockouts and lost revenue. Bias must be identified and corrected at the source — usually a commercial team that over-promises or a sales team that sand-bags.

Common Mistakes in Forecasting and Demand Planning

1. Confusing the statistical forecast with the demand plan

Treating the system-generated statistical number as "the forecast" and skipping the commercial review, assumption documentation, and consensus process is the most pervasive failure. The statistical model is a tool; the demand plan is a business decision.

2. Forecasting at the wrong level of aggregation

Statistical models are typically more accurate at higher aggregation levels (product family, region) than at SKU-location level. A good demand planning architecture forecasts at the statistically optimal level, then disaggregates to SKU-location using historical mix ratios. Running independent statistical models at SKU-location level for thousands of items generates massive aggregate bias and poor accuracy.

3. Not cleaning demand history

A promotional spike, a one-off bulk order, or a stockout-impacted period left in the demand history will corrupt the statistical model. A forecast that extrapolates an anomalous event as baseline demand is wrong before it has calculated a single number.

4. Allowing sales to over-adjust without accountability

Sales teams have access to commercial intelligence the statistical model lacks — but they also carry motivational biases. FVA analysis frequently shows that sales adjustments degrade forecast accuracy on average, even when individual adjustments are directionally correct. The solution is not removing sales from the process but creating accountability: every adjustment is documented with an assumption, and FVA is tracked by adjuster.

5. Not managing new products and end-of-life

Statistical models cannot forecast a product that has no history. New product forecasting requires analogous product benchmarks, launch curve frameworks, and commercial input. End-of-life requires explicit phase-out curves — not just dropping the item from the forecast and hoping inventory arrives at zero simultaneously with last sales.

6. Treating forecast accuracy as an IT problem

When forecast accuracy is poor, organisations often respond by buying a better forecasting system. In most cases, the root cause is not algorithmic — it is process: insufficient demand history cleaning, no commercial review, no assumption documentation, no accountability. Better algorithms on bad inputs produce bad outputs. Process discipline precedes system investment.

Frequently Asked Questions

What is the difference between forecasting and demand planning?

Forecasting is the statistical process of projecting future demand from historical data using mathematical models. Demand planning is the broader cross-functional business process that takes the statistical forecast, adds commercial intelligence (promotions, new products, customer commitments, market signals), resolves conflicts between sales, marketing, finance, and supply chain, and produces a consensus demand plan that all functions commit to. Forecasting answers "what does the data say?"; demand planning answers "what do we believe and what are we planning for?"

What is demand sensing?

Demand sensing uses high-frequency real-time data — daily point-of-sale, daily order intake, customer inventory positions, external signals — to update the short-term (1–4 week) demand signal between monthly planning cycles. Rather than extending the last monthly statistical forecast unchanged until the next cycle, demand sensing continuously adjusts the near-term demand signal as new information arrives. It typically reduces week-1 forecast MAPE by 20–40% compared to the monthly statistical forecast, enabling production and distribution schedules to be adjusted with much less latency.

What is a consensus forecast?

A consensus forecast is the single, signed-off demand plan that all functions — sales, marketing, finance, supply chain — agree to plan from. It is produced at the end of the demand review step in the S&OP cycle: statistical baseline reviewed, commercial adjustments applied with documented assumptions, disagreements resolved, and the final plan approved. The consensus is what makes it valuable — a technically perfect forecast that different functions override independently provides no coordination benefit and is not truly a plan.

What is Forecast Value Add (FVA)?

FVA measures whether each step in the demand planning process improves or deteriorates forecast accuracy compared to a naïve benchmark. FVA = MAPE(after adjustment) − MAPE(before adjustment). A negative result means the step improved accuracy; a positive result means it made the forecast worse. FVA analysis applied across planning process steps (statistical model vs naïve; commercial adjustment vs statistical; final consensus vs commercial) reveals which steps add value and which introduce bias — an essential tool for improving process quality and creating accountability for adjustments.

Should forecast accuracy be measured at SKU level or at aggregate level?

Both — but for different purposes. SKU-level accuracy drives safety stock sizing and replenishment decisions; it should be tracked for A and B class items where accuracy has material inventory or service level impact. Aggregate accuracy (product family, brand, region) is the relevant metric for S&OP and financial planning — small errors at SKU level tend to offset each other at aggregate, so aggregate accuracy should be significantly better. If aggregate accuracy is also poor, it indicates a systematic bias problem in the planning process, not just normal statistical noise.