A forecast that tells you what to reorder, and when
Past sales and seasons turned into a simple reorder plan.
- Client
- Hardware retailer
- Timeline
- 5 weeks
- Scope
- Forecasting, reorder planning
The problem
Reordering was done by feel. Popular items ran out in busy seasons, while slow items filled the storeroom.
What we built
- Two years of sales were checked for seasons, trends and one-off spikes.
- Each item gets a forecast with a range, not a single guess.
- A weekly reorder list highlights items at risk of running out.
-35%stockouts
-18%cash tied up in slow stock
Weeklyreorder list, ready to use
Built with Python, Excel, Power BI.