Demand Forecasting

What is demand forecasting?

Demand forecasting is the process of predicting future consumer demand at the style, category, channel, or location level using historical sales data, trend analysis, seasonality patterns, and external market signals. In apparel merchandising, demand forecasting is the quantitative foundation upon which buy plans, inventory budgets, and receipt flows are built — it translates merchandising strategy into unit-level projections that drive purchasing decisions months before products reach the selling floor.

Demand forecasting in apparel operates across two distinct time horizons: pre-season forecasting (6–12 months out, used for buy planning) and in-season forecasting (weekly adjustments based on actual sell-through).

Why demand forecasting matters in apparel

Apparel's long lead times and seasonal selling windows make forecast accuracy existentially important. A forecast that is 20% too high results in excess inventory, markdowns, and margin erosion. A forecast that is 20% too low means stockouts, lost sales, and disappointed customers during peak selling weeks.

The financial stakes are significant:

• →Overbuy cost: Every 1% of excess inventory above plan typically requires 15–25% markdown depth to clear, eroding 15–25 basis points of gross margin
• →Underbuy cost: Lost sales from stockouts are unrecoverable in seasonal apparel — a missed size run in week 3 of a 12-week selling season represents permanent revenue loss
• →Working capital efficiency: Accurate forecasts reduce safety stock requirements and improve inventory turns, freeing capital for growth investments

The challenge in apparel is that 30–50% of each season's assortment consists of new styles with no sales history, forcing forecasters to rely on analogous style matching, trend indicators, and category-level demand patterns.

Demand forecasting in practice: apparel example

A men's activewear brand is forecasting demand for its Spring running shorts program. The team builds the forecast using multiple inputs:

• →Historical baseline: Last Spring's running shorts category sold 42,000 units across 8 styles. The category has grown 8% annually over three years.
• →Trend adjustment: Running and outdoor fitness participation continues to rise, supporting a +10% trend factor
• →Assortment change: Two new performance fabrics are replacing older styles, with analogous style analysis suggesting 15% higher velocity than departing styles
• →Channel shift: DTC e-commerce now represents 35% of sales versus 28% last year, with higher average sell-through online

The consolidated forecast projects 48,500 units. The team stress-tests with upside (53,000) and downside (44,000) scenarios, setting initial buys at 46,000 with a 5% chase reserve held for in-season reorders on winners.

Common mistakes

• →Relying solely on last year's sales without adjusting for assortment changes, competitive dynamics, or macro trends — last year's results reflect last year's assortment, not this year's
• →Forecasting at too high an aggregation level — a category forecast of +8% means nothing if growth is concentrated in two styles while six others decline
• →Ignoring the difference between demand and sales — historical sales reflect constrained demand; if a style stocked out in week 6, actual demand was higher than recorded sales
• →Treating forecast accuracy as a planning-only problem — forecast quality depends on clean POS data, accurate inventory positions, and disciplined promotional calendars