Demand Planning and Forecasting

Demand planning translates market signals into an operational volume forecast used to drive supply, inventory, labor, and capacity decisions. A good demand plan is not the most accurate forecast — it’s the forecast that minimizes total system cost (stockouts + excess inventory + expediting + overtime) across all planning horizons.

Forecasting Methods

Method	Best For	Limitation
Simple moving average	Stable, no trend/seasonality	Lags trends; treats all periods equally
Weighted moving average	Stable with slight trend	Manual weight-setting
Exponential smoothing (SES)	Stable demand, self-correcting	No trend or seasonality
Holt’s method	Demand with trend	No seasonality
Holt-Winters (Triple ES)	Trend + seasonality	Requires 2+ years of history
Regression (causal)	Demand driven by external variable (price, weather, GDP)	Requires leading indicator data
ML / AI (LSTM, XGBoost)	Complex patterns, large SKU counts	Black box; requires data maturity

Most planning systems use Holt-Winters or a variant as the statistical baseline for replenishment SKUs, then layer in judgment adjustments.

Forecast Error Metrics

Metric	Formula	Notes
MAPE	Mean |Actual − Forecast| / Actual × 100	Intuitive but biased toward low-volume SKUs
WMAPE	Σ|Actual − Forecast| / Σ Actual × 100	Preferred — volume-weighted, not distorted by small SKUs
MAD	Mean |Actual − Forecast|	Same units as demand; useful for operations
Bias	Mean (Forecast − Actual)	Positive = over-forecast; negative = under-forecast
Tracking signal	Cumulative forecast error / MAD	>±4 signals systematic bias; trigger model review

WERC best-in-class benchmark: WMAPE < 15% at the SKU/week level. Most organizations operate at 20–35% WMAPE; top performers in stable categories reach 8–12%.

ABC/XYZ Segmentation

Segments the SKU portfolio to assign appropriate forecasting methods and safety stock policies:

	A (high volume)	B (medium)	C (low volume)
X (stable)	Statistical model; tight safety stock	Statistical model	Statistical model; moderate buffer
Y (variable)	Statistical + market input	Statistical + judgment	Statistical; wide buffer
Z (erratic/intermittent)	Consensus-heavy; min/max	Judgment-based	Make-to-order or zero stock

C/Z SKUs (low volume, erratic) are the biggest source of forecast error and excess inventory. Policies matter more than forecasting algorithms for this segment.

Consensus Demand Process

The statistical baseline is an input, not the output. The consensus process layers in:

1. Statistical baseline: System-generated, SKU/week level
2. Sales input: Promotional events, key account changes, new business pipeline
3. Marketing input: Trade spend, pricing changes, advertising calendars
4. Product management: New launches, end-of-life, portfolio changes
5. Consensus adjustment: Final one-number plan, with assumption log

Assumption logging is critical — if the forecast misses, you need to know which assumption failed.

New Product Forecasting

No history exists for new products. Methods:

• Analogue: Map to the lifecycle curve of a similar past product; scale by relative pricing, distribution, and marketing support
• Market research: Consumer/customer surveys; pilot/test market data
• Management judgment: Expert opinion with structured uncertainty ranges (P10/P50/P90)

New product forecast error rates of 40–70% in the first 6 months are common. Plan for this with flexible supply capacity and cautious initial inventory commitments.

Demand Sensing

Short-horizon demand sensing (1–14 days) supplements the statistical forecast with high-frequency signals:

• POS data from retailers (daily sell-through at store level)
• Customer order patterns (order frequency, order size trends)
• Warehouse shipment actuals vs. plan

Demand sensing tools (Blue Yonder, o9, ToolsGroup) improve short-horizon MAPE by 30–50% vs. unconstrained statistical models, directly reducing safety stock requirements at the DC level.

CPFR

Collaborative Planning, Forecasting and Replenishment — a retailer-supplier process where:

• Retailer shares POS data and promotional calendars
• Supplier shares production constraints and lead times
• Joint forecast is agreed and exception-managed

CPFR is most effective with top-5 retail accounts. Standard protocol defined by GS1/VICS. Requires EDI or portal connectivity and sustained account management attention.

Common Biases

Bias	Manifestation	Mitigation
Optimism bias	Sales always over-forecasts new products	Separate demand forecast from sales quota
Sandbagging	Sales under-forecasts to manage expectations	Accountability to forecast accuracy metric
Anchoring	Forecast snaps to last year’s number	Statistical override with documented exceptions
Hockey stick	Back-loads volume to end of period	Period-level shape analysis