What demand forecasting is
Demand forecasting is the practice of predicting how many units of a product will sell in a future period, store by store and week by week, so the people downstream can order, ship, and stock against a number instead of a guess. I spent eight years owning this number for a natural snack brand, pulling sell-through every Monday from Walmart Retail Link and KeHE Connect, and the forecast was the line everyone in the building either trusted or quietly worked around.
When the forecast was good, the S&OP meeting was short. When it was off by 20%, we either ran out of a hero SKU at Sprouts during a promotion or sat on six weeks of slow-moving inventory in the UNFI Atlanta DC. Both cost real money, and both traced back to the same forecast.
Baseline plus seasonality plus promo lift
A working retail demand forecast is three pieces added together, not one magic regression. You build each piece separately because each one breaks in a different way.
| Component | What it captures | How I sourced it |
|---|---|---|
| Baseline | Underlying sell-through with no promo running | Trailing 8 to 12 weeks of POS velocity |
| Seasonality | Predictable swings (Q4 lift, summer slump) | Same week last year, indexed |
| Promotional lift | Extra units a TPR or display pulls in | Past promos, by retailer and depth |
Take a single SKU: a 10 oz bag of roasted almonds at 140 Sprouts stores. Baseline runs 9 units per store per week. December indexes at 1.3x on seasonality. A planned 25%-off TPR has historically pulled a 2.1x lift on top of that. So the December promo-week forecast per store is 9 x 1.3 x 2.1 = roughly 25 units, and across 140 stores that is about 3,500 units for the week. Miss the seasonality multiplier and you under-order by a third going into your biggest month.
The reason brands separate lift from baseline is the same reason it shows up in inventory management work: you cannot plan replenishment off a blended average that silently buries a promotion inside it. The promotion ends, the average stays high, and you over-ship for a month.
Why POS-driven beats shipment-driven
Here is the distinction that took me two years to fully respect. You can forecast off what you shipped to the distributor, or off what actually sold through to a shopper. They are not the same series, and the gap between them is the difference between consumption and shipment data.
Shipment data is lumpy. A distributor places a forward buy ahead of a price increase and your shipment line spikes 40% in a week when true consumer demand did not move at all. Forecast off that spike and you chase a phantom. POS data (Retail Link, SPINS, Circana) shows the demand signal itself, smoothed of the distributor's ordering behavior. I learned to treat shipments as a financial number and POS as the demand number, and to never let the two get confused in the same model.
Forecast accuracy: MAPE and bias
A forecast you do not score is a wish. The two numbers I lived by were MAPE (mean absolute percentage error, how far off you are on average) and bias (whether you consistently over- or under-forecast). MAPE tells you the size of the miss; bias tells you the direction, which matters more for inventory than people expect.
Here is a four-week forecast-versus-actual on that almond SKU, in units per store per week:
| Week | Forecast | Actual | Abs error | Abs % error |
|---|---|---|---|---|
| W1 | 10 | 9 | 1 | 11.1% |
| W2 | 12 | 14 | 2 | 14.3% |
| W3 | 25 | 22 | 3 | 13.6% |
| W4 | 11 | 12 | 1 | 8.3% |
| Total | 58 | 57 | 7 | - |
MAPE is the average of the percentage errors: (11.1 + 14.3 + 13.6 + 8.3) / 4 = 11.8%. Bias is total forecast minus total actual: 58 - 57 = +1 unit, or about +1.8%, so this forecast runs very slightly hot but is close to neutral. A MAPE near 12% on a promoted natural SKU is respectable; the promo week (W3) is where most of the error lives, which is exactly where you would expect it. If bias had been +15% week after week, no amount of good MAPE would save you. You would be quietly building a stockpile.
Where Scout fits
Scout is a demand-side analytics layer. It connects your SPINS, Circana, or retailer POS exports so the baseline, seasonality, and promo-lift signal you forecast against come from real sell-through, and so you can score prior forecasts against actuals (MAPE and bias) by retailer and SKU without rebuilding the spreadsheet every Monday. It is not an S&OP system or a supply-planning engine. It does not place orders or generate the replenishment plan. It measures the demand signal and the accuracy of your calls so the planning system downstream has a cleaner number to work from.
The short version
- Demand forecasting predicts future unit sales by period and location so ordering and stocking run off a number, not a guess.
- A working forecast is baseline plus seasonality plus promo lift, each built and checked separately.
- POS-driven forecasts beat shipment-driven ones because shipments carry the distributor's ordering noise (forward buys), not pure demand.
- Score every forecast with MAPE (size of miss) and bias (direction). A small MAPE with a steady positive bias still builds dead inventory.