Logistics
Demand forecasting
A demand-forecasting pipeline that replaced gut-feel replenishment with a measured, retrainable model — and put its output where the ops team already worked.
- Python
- Postgres
- Docker
stockouts
forecast accuracy
In short
- Replenishment runs on a measured, retrainable model instead of stale spreadsheets.
- The baseline error was measured first, so the improvement is provable, not asserted.
- Forecasts land in the tools the ops team already uses — not a dashboard nobody opens.
The engagement
- Sector
- Logistics / supply chain
- Company shape
- Established mid-market operator
- Engagement
- Data pipeline + model + delivery
Anonymised by policy
The challenge
Replenishment decisions ran on intuition and spreadsheets that were stale by the time anyone read them. The result was predictable: too much of the wrong stock, too little of the right, and no way to tell whether a change helped.
The approach
- 1Make the baseline measurable
We quantified the existing forecast error first, so every model change could be judged against a real number.
- 2A model that fits the data, not the hype
We chose a forecasting approach matched to the data volume and seasonality rather than the most complex option, and made it retrainable on a schedule.
- 3Deliver where the work happens
Forecasts land in the systems the ops team already uses, so the model informs decisions instead of sitting in a dashboard nobody opens.
The solution
A reproducible pipeline ingests demand history, retrains on a schedule, and writes forecasts back to the operational systems. Because the baseline was measured up front, the improvement is provable — not a claim.
The system we built
- Ingestdemand history
- Feature buildseasonality, trends
- Train + backtestagainst a measured baseline
- Serveinto ops systems
The results
stockouts
over the first two quarters
forecast accuracy
vs. the prior baseline
Data & safety
- Evaluation
- Backtested against a measured baseline; forecast error is tracked over time, not assumed.
- Reproducibility
- A reproducible pipeline retrains on a schedule so the model stays current.
- Delivery
- Forecasts are written into existing operational systems, keeping the model in the workflow.
The stack
- Python
- Postgres
- Docker