E EREACE
Back
Free up cashDistribution / Logistics - Operations and Procurement

Weekly Demand Forecasting by SKU to Optimise Purchasing and Stock

The Purchasing and Supply Chain Director needs to predict exactly how many units each reference (SKU) will sell next week across 150 warehouses in order to automate supplier orders.

Estimated annual impact on EBITDA
+€4.40M
Distributor with 150 warehouses and €900M in sales. Illustrative example with indicative figures: replace them with your own company figures.

Where the money comes from

Sales recovered through fewer stock-outs (margin)
+€2.80M
Less shrinkage and expired stock
+€1.60M
Less urgent transport
+€500k
System cost
-€500k
Annual EBITDA impact
+€4.40M
Adds profitReduces profitSystem cost

What to do now

  1. 1Measure current stock-outs, shrinkage and forecast error by category.
  2. 2Classify SKUs by margin and turnover and set the target service level.
  3. 3Pilot automatic ordering in 10 warehouses against a control group.

For your committee

One page with the decision, the impact, the risks, the steps and the KPI to track.

The print dialog opens: choose "Save as PDF".

Watch out: more volume is not always more profit

Maximising availability on every SKU raises stock and shrinkage on low-margin references. Set the service level per SKU according to its margin and turnover: not everything deserves 99%.

KPI for the committee

Stock-outs (%), shrinkage (%) and days of stock by category.

Cash

Reduces stock by ~€15M (cash).

Detail for your data team

Proposed technique: XGBoost

Why: Demand by SKU depends on complex interactions between price, promotions, day of the week and weather. XGBoost far outperforms simple models on historical time-series tables with multiple cross variables.

Cost of getting it wrong: Over-buying creates write-offs and storage costs; under-buying causes direct loss of sales and customer penalties.

Data needed: ERP / POS: Historical daily sales by SKU and warehouse over the last 3 years.; Purchasing and Marketing: Active promotions, selling price, discounts and supplier lead times.; Calendar and Weather: Local holidays, day of the week and weather forecast.

The Ereace system

Test decisions with synthetic people before you test them with real ones.

This tool helps you decide with numbers. Before you invest, understand, test and rehearse the decision with the people involved: your customers, your team or your committee.

Understand
QualiSynth

Before you invest, find out what your customers think, need or reject about the initiative.

Test
StrataSynth

Put the offer, the message or the journey in front of synthetic people who do not always follow the happy path.

Train
ArenaSynth

Rehearse the committee presentation or the vendor negotiation against synthetic decision-makers.

See all Ereace products

About this tool. It is free and made by Ereace, an AI-native product studio and human intelligence ecosystem: it connects real human signals, synthetic people and the systems built around them, so teams can understand, test and act on human behavior before decisions reach the real world. About Ereace

Comments or suggestions? info@ereace.es