Plan replenishment from demand and lead time
Reorder Radar helps determine when additional stock should be purchased and how much inventory may be required.
Instead of relying only on a manually chosen minimum quantity, the workbook uses demand and supplier lead-time data to calculate its replenishment indicators.
Calculated values
- Safety stock
- Reorder point
- Recommended order quantity
- Buy signal
Each item is classified as:
- Critical
- Order Now
- Covered
Supporting sheets
- Demand History
- Purchase Plan
- Suppliers
The Suppliers sheet keeps lead-time and contact information available alongside the replenishment calculations.
How to use it
For each SKU, enter:
- Quantity on hand
- Quantity already on order
- Supplier lead time
- Average weekly demand
- Maximum weekly demand
The workbook calculates the remaining replenishment fields.
Best for
Small retailers, distributors, warehouse teams, and businesses that want a more structured approach to purchasing than a simple fixed minimum-stock rule.