Logistics and distribution · Example: national food distributor, 120 employees
Stock-out days fell from 11 to 3 a month at a food distributor
Example project. Orders were placed by feel, and shortages surfaced when a customer was already waiting. We built an alert that works out when to order from seasonality and lead times; stock-out days fell from 11 to 3 a month.
- Client
- Example: national food distributor, 120 employees
- Industry
- Logistics and distribution
- Duration
- 12 weeks
- Systems and technology
- SAP Business One, Excel, monday, Claude
Baseline
The 60 best-selling items averaged 11 stock-out days a month over the six months before the project. The weekly order took the buyer about six hours.
What we built
A tool that reads sales and stock from SAP Business One, works out consumption by season and holidays, and alerts in monday when an item will run out before the supplier can deliver.
The tool recommends quantities; the buyer places the order.
Training and AI champions
The warehouse manager and the procurement coordinator trained as champions. They learned to change a supplier's lead time and add an item to tracking.
Before and after
| Before | After | |
|---|---|---|
| Stock-out days a month (60 items) | 11 | 3 |
| Time to prepare the weekly order | 6 hours | 1.5 hours |
What didn't work
New items without a year of history were not forecast accurately enough and stay on manual ordering.
Handover
An operations guide explains what to do when the forecast drifts. The champions added an overstock alert on their own.