The Decision Factory

Paper 03 of 06 · The wrong contest

Forecasting Is Not the Point

A forecast is not a number, and accuracy is not the objective. The organizations that win are not the ones with the smallest error. They are the ones whose errors cost least.

The argument in brief

  1. A forecast is not a number. It is a distribution over what could happen. The single figure your process circulates is one summary of that shape, and it is not the summary a stocking or staffing decision requires.
  2. Accuracy metrics select the wrong model. Two models with identical MAE, MAPE and RMSE can invert the money ranking once the ledger prices their errors, and the model your scorecard would reject can cost two-thirds less than the one it would shortlist.
  3. Controllable levers belong inside the model, not as adjustments after it. Price, promotion, marketing and service level move demand. Deciding them first and modeling their effect is the difference between a forecast and a negotiation.
  4. Where the data is thin, the correct action is to test, not to guess. A system that knows the limits of its own evidence can propose the experiment that would resolve them, which is a capability almost no planning process has.
  5. The measure of a forecasting function is the cost of the decisions it enables. Reporting accuracy in isolation is reporting on the instrument rather than on the outcome.
01

What a forecast actually is

Every planning organization produces a forecast, and almost every one of them produces the wrong object. Not an inaccurate one. The wrong kind of object.

What circulates in the monthly cycle is a single number per item per period. What the business actually faces is a range of possible outcomes with different likelihoods attached. The single number is one summary of that range, usually the mean or something near it, and the act of reducing the range to it discards precisely the information a decision needs.

Exhibit 1

The forecast is a summary of a shape, and it is not the summary a stocking decision needs

0–1 units 1–2 units 2–3 units 3–4 units 4–5 units 5–6 units 6–7 units 7–8 units 8–9 units 9–10 units 10–11 units 11–12 units 12–13 units 13–14 units 14–15 units 15–16 units 16–17 units 17–18 units 18–19 units 19–20 units 20–21 units 21–22 units 22–23 units 23–24 units 24–25 units 25–26 units The forecast: 11 units The tail that bankrupts you 0 26 Units demanded next period The forecast is not wrong. It is one summary of the shape behind it, and it is not the summary a stocking decision needs.
Illustrative. A demand distribution for a single item and period, with the point forecast marked at its mean. The right tail is shaded because it is where the expensive outcomes live and where a point estimate carries no information at all.

Consider what Exhibit 1 shows. The point forecast of eleven units is not wrong; it is a perfectly reasonable summary of that distribution. But a planner deciding how much to stock needs to know something the point forecast cannot express: how bad the bad case is, how likely it is, and what it would cost. Those questions are answerable from the shape and unanswerable from the number.

This is why the most common improvement program in the discipline, which is to make the point forecast more accurate, so frequently produces disappointing returns. It is an investment in refining a summary that was the wrong summary to begin with.

02

Why accuracy metrics select the wrong model

The second problem is more serious, because it is actively misleading rather than merely incomplete. The metrics used to choose between forecasting approaches do not measure what the business cares about, and they can and do select the worse option.

Error metrics are symmetric. Being ten units over and ten units under score identically. The business is not symmetric. As Paper 02 established, the two directions carry different costs, land in different budgets, and one of them is largely invisible. A metric that treats them as equivalent is measuring something the organization has no economic interest in.

To make these concepts concrete, we walk through the same demand data working through two different models.

The setup

One item. Ten weeks of history. The ledger from Paper 02 applies: $10 for each unit carried that was not needed (capital, storage and expected markdown) and $85 for each unit of demand not served ($40 of forgone contribution plus $45 of customer damage, the midpoint of the signed range). The stocking decision is the forecast, one for one, which keeps the arithmetic visible.

Two candidate models are on the table. Model B's errors are the exact mirror of Model A's: same magnitudes, opposite signs. This is not a trick to make the point, it is the cleanest way to remove every other explanation. Any symmetric metric will score them identically, because symmetric metrics cannot see sign.

Illustrative. Ten weeks of demand and two candidate forecasts. Error is forecast minus actual; negative means short.
WeekActualModel AError AModel BError B
110070−30130+30
2120130+10110−10
39080−10100+10
4140100−40180+40
5110120+10100−10
695100+590−5
713095−35165+35
8105115+1095−10
9115130+15100−15
1095100+590−5
Total1,1001,040−601,160+60

Step one: score them the way your organization scores them

Every symmetric accuracy metric returns the same verdict
MetricModel AModel BVerdict
Mean absolute error17.0 units17.0 unitsTie
MAPE14.7%14.7%Tie
RMSE21.0 units21.0 unitsTie
Mean error (bias)−6.0 units+6.0 unitsDifferent, and reported as a footnote if at all

A bake-off scored this way is a coin flip. Switching to RMSE does not help, because RMSE punishes large errors without asking which direction they went. The only line that distinguishes the two models is bias, and bias is conventionally treated as a diagnostic to be eliminated rather than a lever to be set.

Step two: price the same errors with the ledger

Split each model's errors into units carried and units short, then multiply.

The same ten weeks, priced. Units over × $10, units short × $85.
 Units overCarrying costUnits shortShortage costTotal (lower is better)
Model A55$550115$9,775$10,325
Model B115$1,15055$4,675$5,825

Two models that no accuracy metric can tell apart differ by $4,500 over ten weeks on a single item. Model B costs 44 percent less. Annualized, that is roughly $23,000 on one line of the catalog, decided by a coin flip in a model evaluation that was reported as a success.

The two models are indistinguishable to the metric and $4,500 apart in the accounts. The metric is not incomplete. It is pointing the wrong way.

Step three: the model that loses the accuracy contest

Now take Model A, the one that was tied for first, and make it deliberately worse. Add a fixed buffer of 35 units to every forecast, sized from the ledger rather than from a service target. Call it Model C.

With $85 against $10, the critical ratio is 85 ÷ 95, or 89.5 percent. The ledger is telling you to sit near the 90th percentile of demand, not at the middle of it. A buffer is not a fudge factor here. It is what the arithmetic asks for.

Three models, scored both ways
 MAEMAPERMSEBiasUnits overUnits shortCost
Model A17.014.7%21.0−655115$10,325
Model B17.014.7%21.0+611555$5,825
Model C30.028.5%35.3+292955$3,375

Read the two rankings against each other. On accuracy: A and B tied for first, C a distant and embarrassing last, 76 percent worse on MAE and nearly double the MAPE. On money: C first by a wide margin, then B, then A. The rankings are inverted. The model your forecast scorecard would reject outright is the one that costs 67 percent less than the model it would have shortlisted.

Model C is safety stock, stripped of the framing. The point is not that a buffer is novel. It is that this buffer was sized by the ledger instead of by a service target, and that the choice between A and B, which no amount of safety stock fixes, was already worth $4,500 on its own.

Model C also looks indefensible on the one summary a planning review actually reads. It forecasts 1,390 units against 1,100 of demand, a 26 percent over-forecast sustained for ten straight weeks. Any competent forecast governance process would flag that as systematic bias and order it corrected. Correcting it costs the business $6,950 over ten weeks.

Exhibit 2

Identical accuracy can invert the money ranking: the model the scorecard rejects costs least

Forecast accuracy Mean absolute error, units Model A Model A MAE: 17.0 17.0 Model B Model B MAE: 17.0 17.0 Model C Model C MAE: 30.0 30.0 Accuracy ranking: A and B tie. C is last by a wide margin. Costs Ledger cost over ten weeks Model A Model A cost: $10,325 $10,325 Model B Model B cost: $5,825 $5,825 Model C Model C cost: $3,375 $3,375 Cost ranking: C, then B, then A. The scorecard's reject is the cheapest. Same history. Same ledger. Accuracy and costs point opposite directions.
Illustrative. MAE and ledger cost for the three models in the walkthrough above. A and B are mirrors on every symmetric error metric; C is Model A plus a 35-unit buffer sized by the critical ratio. The accuracy ranking and the money ranking are inverted.

Check the working

Model C is Model A plus 35 units each week. Week 4 is the only week it runs short, by 5 units, at $85. The other nine weeks carry 295 units between them at $10. That is $425 plus $2,950. Move the buffer to 30 or to 40 and the total rises in both directions, which is what an optimum looks like. The buffer that minimizes cost here is 35, and nothing in any accuracy metric could have found it.

What this means for how you choose

The organizations that win are not the ones with the smallest forecast error. They are the ones whose errors cost the least.

The remedy is not a better error metric. Weighted and asymmetric metrics exist, and they are an improvement, but they are still a proxy standing between you and the number you actually care about. The remedy is to stop scoring the instrument and start scoring the outcome. Every candidate model gets evaluated by replaying the decisions it would have produced against the historical record and pricing those decisions with the ledger. Same history, same ledger, one number per candidate, in currency.

That is a harder evaluation to build. It takes a few weeks rather than an afternoon, and it requires Paper 02 to have been done first. It is also the only evaluation whose result a finance director has any reason to act on.

03

Model the drivers rather than adjusting for them

There is a third and quite different failure, and it concerns the things the business controls.

Price changes, promotions, marketing spend, assortment decisions and service commitments all move demand. In most planning processes they are handled as adjustments: a baseline forecast is produced, and then someone uplifts it because a promotion is planned. The uplift is a judgment, it is rarely recorded with its reasoning, and its accuracy is never assessed because the counterfactual is unobservable.

The correct treatment inverts the sequence. The controllable levers are decided first, and the model computes demand conditional on those decisions. The effect of each lever becomes a fitted relationship in its own right, estimated from the organization's own history of what it did and what followed, and carrying an explicit confidence range rather than a single coefficient.

Here is what changes in the room.

Somebody asks what happens if we double the promotion. Today that question is settled by whoever argues best. Marketing has a number from the last time they ran it. Supply has a different number and a long memory of the last time they believed marketing. The meeting picks one, the promotion runs, and six weeks later nobody can separate its effect from the weather, a competitor's price move, and the fact that Easter was early.

With lever effects modeled, that question has an answer before the money is committed. Not a certain answer. A number with a range around it, which is something two functions can argue about on the merits and then check afterward.

The second change is slower and worth more. Every promotion you run becomes evidence about the next one. The uplift argument stops resetting to zero every year.

04

When the data is too thin to exploit

Modeling lever effects raises an honest objection: for many decisions, the historical evidence is genuinely weak. The promotion was run once, three years ago, in one region, alongside a competitor action that confounds it. No amount of statistical sophistication conjures information that is not in the record.

This objection is correct, and the response to it is one of the few genuinely novel capabilities the architecture provides. A model that carries explicit confidence ranges knows where its evidence is thin. That knowledge is actionable: it identifies exactly which deliberate experiment would be worth running, and roughly what resolving the uncertainty would be worth in currency.

The organization therefore gains a queue of proposed tests, ranked by the value of the information they would produce. A controlled price variation in two regions. A holdout on one campaign. A deliberate service-level difference across comparable accounts. Each is small, each is priced, and each converts a permanent argument into a settled fact.

Why this rarely happens without deliberate design

Every commercial function already runs experiments implicitly, in the sense that it does different things in different places for different reasons. What is missing is the discipline of designing a small number of them to be readable afterwards, and an owner whose job includes deciding which uncertainties are worth paying to resolve. Paper 05 gives that role a name and a place in the organization.

05

What to ask your analytics team on Monday

This paper is not a brief to rebuild the forecasting function. In most organizations the forecasting function is competent and is being asked the wrong question. Four questions are usually enough to establish where you actually stand.

  1. Does our forecast carry a distribution, or only a number? If the model produces one internally and the process discards it downstream, the capability already exists and is being thrown away at the interface, which is a much easier problem than it sounds.
  2. How do we choose between two candidate models? If the answer is an error metric, the selection process cannot see the difference that matters, and the fix is to score candidates on the priced outcome of their decisions instead.
  3. Are promotions and price changes inputs to the model or adjustments after it? If they are adjustments, the organization is systematically failing to learn from its own commercial activity.
  4. Where is our data too thin to trust, and what would it cost to find out? A team that can answer this immediately is further along than most. A team that has never been asked will usually have a good answer within a fortnight.

None of these require a platform decision, and all four are answerable with people already on the payroll. The next paper sets out the machine that these components fit into, and where exactly a human being enters it.