Procurement

Why Forecast Accuracy Analytics Solution for Procurement Matters

Forecast error in procurement turns into cost through four mechanisms: carrying cost on inventory you didn’t need, expedite and emergency purchase premiums, lost sales when you’re short, and a weaker position at the negotiating table. Each one is measurable. Most procurement teams size none of them, which is why procurement forecast accuracy so rarely translates into a number finance will act on.

That gap matters more than the accuracy itself. Teams know the forecast is wrong. They can’t say what the wrongness costs — and that makes the fix hard to fund and almost impossible to evaluate afterwards, which is how these programmes end up defended with a dashboard instead of a number.

The four ways forecast error turns into cost

Forecast accuracy gets treated as a demand planning problem that procurement happens to inherit. It’s closer to the opposite. The forecast decides what you commit to buy, how much you hold, what you pay when you’re caught short, and how much leverage you carry into a negotiation. All four land in a cost line somebody in finance already watches.

They behave differently enough that treating them as a single bucket is where most business cases go wrong.

Carrying cost on inventory you didn’t need. Over-forecast and the excess sits in a warehouse eating capital, space, insurance, handling and obsolescence risk. Across the engagements we’ve run, the all-in rate usually lands somewhere between 20 and 30% of average inventory value per year — but that’s a starting hypothesis, not a number to build a case on. The right figure depends on your product mix, obsolescence exposure and what money costs you right now. Recalculate it quarterly. We’ve seen teams running on a carrying cost rate somebody set in 2019, which was a different interest rate environment entirely.

Expedite and emergency purchase premiums. Under-forecast and you buy in a hurry. Rush freight, spot pricing, split shipments, change fees. This one sits in the ledger where anyone can see it and almost never gets attributed back to the forecast that caused it.

Lost sales and service penalties. Harder to quantify, frequently the biggest of the four. Missed business from a stockout can dwarf the carrying cost you were trying to avoid.

A weaker position at the negotiating table. The quiet one. When you can’t commit to volume with confidence, you buy on shorter horizons and worse terms, and suppliers price your uncertainty into the contract whether or not anyone names it.

Notice what those four do to each other. Only the first two are easy to see, and fixing one can make another worse. Cut inventory to reduce carrying cost and you drive stockouts and expedites that swallow the saving. The goal was never minimum inventory. It’s right-sized inventory, with a defensible reason behind every buffer.

Before you buy anything, check whether it’s a modelling problem

It usually isn’t.

The most common root cause we run into is coordination failure. Procurement buffers against demand uncertainty it can’t see clearly. Operations plans against forecasts that commercial activity has already moved. Finance sets working capital targets without visibility into what hitting them does to service. You get systematic overstock in slow-moving categories, safety stock nobody can justify, and inventory sitting at the wrong point in the network.

No model fixes that. It’s an information-sharing problem, and it’s considerably cheaper to solve than a platform.

Second: one policy stretched across an unlike portfolio. A rule like “hold two months of cover” is easy to administer and almost always wrong. Fast movers, slow movers, seasonal lines and long-lead-time items need different thresholds. Run them all on one rule and you’ll be overstocked and short at the same time, which is a genuinely impressive thing to achieve.

Third: you’re measuring at the wrong level. Aggregate accuracy at family level looks fine while SKU-location accuracy — where buying actually happens — is much worse. If your reported number never matches what the plants are telling you, check the aggregation before you question the model.  Your forecast accuracy number is measuring the wrong thing covers why this happens and how to re-cut the numbers.

What analytics genuinely improves

Being specific matters here, because vague capability claims are exactly why procurement leaders have learned to distrust these projects.

Segmentation is the first real gain. Stable, high-volume items respond well to statistical methods. Intermittent and lumpy demand needs different treatment entirely, and running one approach across everything guarantees mediocre results in both groups.

Lead time variability modelling is the underrated one. Safety stock is driven by variability in demand and in supply, and the supply side is often the larger contributor. Model what your suppliers actually deliver, rather than the contracted lead time sitting untouched in the ERP since onboarding, and you’ll frequently release more working capital than an equivalent demand forecast improvement would.

Demand sensing on short horizons has a narrower use. Blending recent orders, open pipeline and channel signals to correct the near term works where your lead times are short enough to act on the correction. It does nothing for a commitment you made three months ago.

Spend pattern analysis surfaces maverick and off-contract buying. Worth saying plainly: that’s usually a symptom of forecast failure, not indiscipline. People route around a process when the process doesn’t have what they need.

What none of this fixes is a demand signal that commercial teams inflate on purpose, a supplier base that can’t deliver reliably, or a planning process where nobody has the authority to reject a number.

Calculating the saving so it survives contact with finance

Five steps, in this order.

  1. Establish the baseline first. Twelve months of history at SKU-location level: forecast error by segment, inventory value by category, expedite and premium freight spend, stockout incidents with an estimated revenue impact, and off-contract spend. Skip this and every later claim is unverifiable, which you’ll discover at the worst possible moment.
  2. Isolate the avoidable portion. Not all error is addressable. New products, real demand shocks and intermittent items carry irreducible uncertainty. Segment the portfolio and work only on the part where a better process would plausibly have produced a better number. This step is the whole difference between a credible business case and a hopeful one.
  3. Convert error into cost, one mechanism at a time. Excess units × unit cost × your own carrying rate. Expedite premium as the delta between rush and standard, × frequency. Stockout impact using a documented lost-margin assumption — and label it an assumption rather than burying it as a fact.
  4. Model the improvement conservatively. If a pilot on one category delivers a measured gain, extrapolate only across categories with similar demand behaviour. Stretching a fast-mover result across intermittent items is how these cases fall apart at the six-month review.
  5. Track against the baseline, not against your projection. Same metrics, twelve months on. If carrying cost, expedite spend and stockout frequency haven’t moved, the accuracy gain never reached the P&L.

That last point deserves more weight than it usually gets. Better forecast accuracy does not automatically produce lower cost. The gain only materialises if inventory policies, safety stock parameters and order cycles are reset to reflect it. Plenty of organisations improve the forecast, leave the buffers exactly where they were, and then spend a quarter wondering where the money went.

What to report every month

Five metrics, reviewed by segment rather than in aggregate:

  • Weighted forecast error (WAPE or WMAPE) at the level you buy at, not the level that flatters you
  • Bias by segment, tracked as a trend, since persistent one-way error is a process problem rather than a model problem
  • Carrying cost as a percentage of average inventory value, recalculated as rates and turns shift
  • Premium freight and expedite spend as a share of total freight
  • Off-contract spend percentage, standing in for whether the process is meeting real needs

On why weighted error and bias beat a headline MAPE, and how to build the scorecard around them, see your forecast accuracy number is measuring the wrong thing.

Pair every accuracy metric with an outcome metric. Accuracy improving while all four cost mechanisms sit still means the improvement stopped somewhere between the model and the business.

Where to start

Pick one category. Establish its baseline properly, which means the cost mechanisms rather than the accuracy percentage on its own. Segment it by demand pattern and check whether your current policy is treating unlike items alike. Model supplier lead time variability alongside demand variability, because the supply side is usually the bigger lever and reliably the neglected one.

Then reset the parameters and watch what moves.

One category done rigorously gives you a defensible number and a method you can repeat. A portfolio-wide programme launched without that baseline gives you a dashboard and an argument about attribution — and only one of those is easy to defend in front of a CFO.

← All posts

Want the perspective most relevant to you?

Tell us the decision you’re trying to improve and we’ll share the most relevant KEPLER thinking.

Talk to KEPLER