Sales and demand forecasting

Sales and demand forecasting tells you how much you'll sell in the coming weeks, as a range you can plan stock and cash on. Every forecast is backtested before you rely on it, by forecasting your most recent weeks blind and scoring the result against what sold.

Last reviewed

Forecast backtest, example

Over 12 held-back weeks, the model was out by 4.0% and the seasonal baseline by 8.4%

Example data
Over 12 held-back weeks, the model was out by 4.0% and the seasonal baseline by 8.4%. Weekly units, actual for 20 weeks, and the forecast with its 80% band and the seasonal baseline for the last 12.4,0005,0006,0007,00021 Jun16 Aug1 NovWeekly unitsHeld back from hereWeek ending 21 June 2026: actual 3,840Week ending 28 June 2026: actual 3,910Week ending 5 July 2026: actual 3,780Week ending 12 July 2026: actual 3,960Week ending 19 July 2026: actual 4,050Week ending 26 July 2026: actual 3,990Week ending 2 August 2026: actual 4,130Week ending 9 August 2026: actual 4,070Week ending 16 August 2026: actual 4,120, forecast 3,950, band 3,790 to 4,110, seasonal baseline 3,880Week ending 23 August 2026: actual 4,310, forecast 4,180, band 4,000 to 4,360, seasonal baseline 3,950Week ending 30 August 2026: actual 4,050, forecast 4,290, band 4,080 to 4,500, seasonal baseline 3,790Week ending 6 September 2026: actual 4,480, forecast 4,300, band 4,080 to 4,520, seasonal baseline 4,090Week ending 13 September 2026: actual 4,620, forecast 4,510, band 4,260 to 4,760, seasonal baseline 4,210Week ending 20 September 2026: actual 4,390, forecast 4,600, band 4,320 to 4,880, seasonal baseline 4,030Week ending 27 September 2026: actual 4,710, forecast 4,580, band 4,290 to 4,870, seasonal baseline 4,310Week ending 4 October 2026: actual 4,880, forecast 5,050, band 4,710 to 5,390, seasonal baseline 4,420Week ending 11 October 2026: actual 5,240, forecast 5,010, band 4,650 to 5,370, seasonal baseline 4,760Week ending 18 October 2026: actual 5,610, forecast 5,390, band 4,980 to 5,800, seasonal baseline 5,120Week ending 25 October 2026: actual 6,020, forecast 5,760, band 5,300 to 6,220, seasonal baseline 5,480Week ending 1 November 2026: actual 6,390, forecast 6,720, band 6,160 to 7,280, seasonal baseline 5,780Over 12 held-back weeks, the model was out by 4.0% and the seasonal baseline by 8.4%. Weekly units, actual for 20 weeks, and the forecast with its 80% band and the seasonal baseline for the last 12.4,0005,0006,0007,00021 Jun19 Jul16 Aug13 Sep11 Oct1 NovWeekly unitsHeld back from hereWeek ending 21 June 2026: actual 3,840Week ending 28 June 2026: actual 3,910Week ending 5 July 2026: actual 3,780Week ending 12 July 2026: actual 3,960Week ending 19 July 2026: actual 4,050Week ending 26 July 2026: actual 3,990Week ending 2 August 2026: actual 4,130Week ending 9 August 2026: actual 4,070Week ending 16 August 2026: actual 4,120, forecast 3,950, band 3,790 to 4,110, seasonal baseline 3,880Week ending 23 August 2026: actual 4,310, forecast 4,180, band 4,000 to 4,360, seasonal baseline 3,950Week ending 30 August 2026: actual 4,050, forecast 4,290, band 4,080 to 4,500, seasonal baseline 3,790Week ending 6 September 2026: actual 4,480, forecast 4,300, band 4,080 to 4,520, seasonal baseline 4,090Week ending 13 September 2026: actual 4,620, forecast 4,510, band 4,260 to 4,760, seasonal baseline 4,210Week ending 20 September 2026: actual 4,390, forecast 4,600, band 4,320 to 4,880, seasonal baseline 4,030Week ending 27 September 2026: actual 4,710, forecast 4,580, band 4,290 to 4,870, seasonal baseline 4,310Week ending 4 October 2026: actual 4,880, forecast 5,050, band 4,710 to 5,390, seasonal baseline 4,420Week ending 11 October 2026: actual 5,240, forecast 5,010, band 4,650 to 5,370, seasonal baseline 4,760Week ending 18 October 2026: actual 5,610, forecast 5,390, band 4,980 to 5,800, seasonal baseline 5,120Week ending 25 October 2026: actual 6,020, forecast 5,760, band 5,300 to 6,220, seasonal baseline 5,480Week ending 1 November 2026: actual 6,390, forecast 6,720, band 6,160 to 7,280, seasonal baseline 5,780Forecast6,720Actual6,390Seasonal baseline5,780Over 12 held-back weeks, the model was out by 4.0% and the seasonal baseline by 8.4%. Weekly units, actual for 20 weeks, and the forecast with its 80% band and the seasonal baseline for the last 12.4,0005,0006,0007,00021 Jun19 Jul16 Aug13 Sep11 Oct1 NovWeekly unitsHeld back from hereWeek ending 21 June 2026: actual 3,840Week ending 28 June 2026: actual 3,910Week ending 5 July 2026: actual 3,780Week ending 12 July 2026: actual 3,960Week ending 19 July 2026: actual 4,050Week ending 26 July 2026: actual 3,990Week ending 2 August 2026: actual 4,130Week ending 9 August 2026: actual 4,070Week ending 16 August 2026: actual 4,120, forecast 3,950, band 3,790 to 4,110, seasonal baseline 3,880Week ending 23 August 2026: actual 4,310, forecast 4,180, band 4,000 to 4,360, seasonal baseline 3,950Week ending 30 August 2026: actual 4,050, forecast 4,290, band 4,080 to 4,500, seasonal baseline 3,790Week ending 6 September 2026: actual 4,480, forecast 4,300, band 4,080 to 4,520, seasonal baseline 4,090Week ending 13 September 2026: actual 4,620, forecast 4,510, band 4,260 to 4,760, seasonal baseline 4,210Week ending 20 September 2026: actual 4,390, forecast 4,600, band 4,320 to 4,880, seasonal baseline 4,030Week ending 27 September 2026: actual 4,710, forecast 4,580, band 4,290 to 4,870, seasonal baseline 4,310Week ending 4 October 2026: actual 4,880, forecast 5,050, band 4,710 to 5,390, seasonal baseline 4,420Week ending 11 October 2026: actual 5,240, forecast 5,010, band 4,650 to 5,370, seasonal baseline 4,760Week ending 18 October 2026: actual 5,610, forecast 5,390, band 4,980 to 5,800, seasonal baseline 5,120Week ending 25 October 2026: actual 6,020, forecast 5,760, band 5,300 to 6,220, seasonal baseline 5,480Week ending 1 November 2026: actual 6,390, forecast 6,720, band 6,160 to 7,280, seasonal baseline 5,780Forecast6,720Actual6,390Seasonal baseline5,780Over 12 held-back weeks, the model was out by 4.0% and the seasonal baseline by 8.4%. Weekly units, actual for 20 weeks, and the forecast with its 80% band and the seasonal baseline for the last 12.4,0005,0006,0007,00021 Jun5 Jul19 Jul2 Aug16 Aug30 Aug13 Sep27 Sep11 Oct25 Oct1 NovWeekly unitsHeld back from hereWeek ending 21 June 2026: actual 3,840Week ending 28 June 2026: actual 3,910Week ending 5 July 2026: actual 3,780Week ending 12 July 2026: actual 3,960Week ending 19 July 2026: actual 4,050Week ending 26 July 2026: actual 3,990Week ending 2 August 2026: actual 4,130Week ending 9 August 2026: actual 4,070Week ending 16 August 2026: actual 4,120, forecast 3,950, band 3,790 to 4,110, seasonal baseline 3,880Week ending 23 August 2026: actual 4,310, forecast 4,180, band 4,000 to 4,360, seasonal baseline 3,950Week ending 30 August 2026: actual 4,050, forecast 4,290, band 4,080 to 4,500, seasonal baseline 3,790Week ending 6 September 2026: actual 4,480, forecast 4,300, band 4,080 to 4,520, seasonal baseline 4,090Week ending 13 September 2026: actual 4,620, forecast 4,510, band 4,260 to 4,760, seasonal baseline 4,210Week ending 20 September 2026: actual 4,390, forecast 4,600, band 4,320 to 4,880, seasonal baseline 4,030Week ending 27 September 2026: actual 4,710, forecast 4,580, band 4,290 to 4,870, seasonal baseline 4,310Week ending 4 October 2026: actual 4,880, forecast 5,050, band 4,710 to 5,390, seasonal baseline 4,420Week ending 11 October 2026: actual 5,240, forecast 5,010, band 4,650 to 5,370, seasonal baseline 4,760Week ending 18 October 2026: actual 5,610, forecast 5,390, band 4,980 to 5,800, seasonal baseline 5,120Week ending 25 October 2026: actual 6,020, forecast 5,760, band 5,300 to 6,220, seasonal baseline 5,480Week ending 1 November 2026: actual 6,390, forecast 6,720, band 6,160 to 7,280, seasonal baseline 5,780Forecast6,720Actual6,390Seasonal baseline5,780

Outside the 80% band: 4,120 on 16 Aug, above it. 4,050 on 30 Aug, below it.

80% prediction interval, ±4.0% in week 1 widening to ±8.4% by week 12
Model
4.0%mean absolute percentage error
Seasonal baseline
8.4%
Seasonal baseline: the same week last year, unadjusted
Actuals inside the 80% band
10 of 12
Example data: weekly units for an invented shop, all products. The model was trained on weeks up to 9 August 2026 and never saw the 12 weeks after it. Error is mean absolute percentage error: each week's gap between actual and forecast as a share of actual, averaged over the 12 weeks.
Show the numbers
Forecast backtest, weekly units, example data
Week endingActualForecastBand lowBand highSeasonal baseline
21 Jun3,840
28 Jun3,910
5 Jul3,780
12 Jul3,960
19 Jul4,050
26 Jul3,990
2 Aug4,130
9 Aug4,070
16 Aug4,1203,9503,7904,1103,880
23 Aug4,3104,1804,0004,3603,950
30 Aug4,0504,2904,0804,5003,790
6 Sep4,4804,3004,0804,5204,090
13 Sep4,6204,5104,2604,7604,210
20 Sep4,3904,6004,3204,8804,030
27 Sep4,7104,5804,2904,8704,310
4 Oct4,8805,0504,7105,3904,420
11 Oct5,2405,0104,6505,3704,760
18 Oct5,6105,3904,9805,8005,120
25 Oct6,0205,7605,3006,2205,480
1 Nov6,3906,7206,1607,2805,780

What a sales forecast should fix

The forecast is one numberThere's no measure of whether it's good to 2% or 20%, so buying adds a safety margin and finance adds another.
Last peak, we bought for a guessStock was ordered against an untested forecast, and the surplus went out at a discount in January.
The tool gives a number and no historyA predictive analytics tool gives next month's sales, with no record of how far off it was last quarter.
Finance and buying have their own forecastsTwo spreadsheets carry two growth assumptions, and neither team recorded which came closer.

What a demand forecasting project hands over

The backtest reportIt sets actual against forecast over the held-back weeks, with the error for the model and for the seasonal baseline, as in the exhibit.
The weekly forecastYou get the next 13 weeks by product range, each with its 80% band, refreshed every Monday in your warehouse.
The planning rulesStock is planned on the upper band so a strong week doesn't sell you out, and cash on the lower band so a weak week doesn't leave a bill unpaid. The cash side goes next to the actuals on a finance dashboard.
The forecast logEach week's forecast is stored as it was made and scored as actuals arrive, so you can check the error you were quoted against the error you got.

How a forecasting project runs

  1. 1

    Scoping

    The work needs two years or more of weekly sales at the level you buy, plus promotions and any stock-out records, because with less there's only one season to learn from.

  2. 2

    Build

    The seasonal baseline is fitted first, then the model, and both are scored on the same held-back weeks. The model only goes forward if its error is lower.

  3. 3

    Handover

    The forecast, its band and the log run on a schedule in your accounts, and your team learns to read the band.

  4. 4

    Every month after

    The log scores each forecast against actuals, so you'll see it if the model stops beating the baseline.

What usually goes wrong with stock forecasting

Scoring on the training dataA model checked on the weeks it learned from has seen the answers, so it's scored once, on weeks it never saw.
A point treated as a promiseOne number planned on as if it were certain leaves the miss with whoever bought the stock, so the forecast is a band, with written rules for which edge each plan uses.
Stock-outs read as low demandEmpty shelves record low sales that a model reads as low demand, so stock-out weeks are flagged before fitting.

In the example, the two actuals outside the band were 16 August, 10 units above its upper edge, and 30 August, 30 units below its lower edge.

Sales forecasting by industry

EcommerceWeekly units are forecast by product range, with promotions from the calendar and stock-out weeks flagged first.
Subscription and mediaNew subscribers and renewals are forecast by start-month cohort from the retention curves in customer analytics.

When the question is how much demand comes from ad spend, that's marketing mix modelling, and a planned spend level can go into the forecast as an input.

Questions about forecasts

How accurate will our sales forecast be?

Nobody can say before the backtest, which forecasts your most recent weeks blind and scores the result next to the seasonal baseline. You see how the model does on your own data before you plan on it.

What does the error figure mean?

It's mean absolute percentage error: each held-back week's gap between actual and forecast as a share of actual, averaged across the weeks. 4.0% means the forecast was out by 4% of the real figure in an average week. Products with zero-sale weeks get a weighted version.

Do you do demand forecasting for ecommerce stock?

Yes, weekly by product range at the level you buy. Out-of-stock weeks are flagged first, because sales in those weeks show what you had to sell, which can be less than what people wanted.

Is this predictive analytics?

Yes, it's the part of predictive analytics that predicts a quantity over time, such as units sold or revenue. Predicting which customers will buy again is customer analytics work.

What if the model doesn't beat the seasonal baseline?

Then we ship the baseline, because same week last year, adjusted for nothing, is a forecast too, and the backtest has scored it. The report says what more history or another input might change.

Does anyone know how far off last quarter's forecast was?

On the call we find where your weekly sales history is kept and say what a backtest on two years of it would need.

Book a call

Free 30 min call