Reorder Point Calculator
How the reorder point calculator works
The calculator combines three standard inventory management formulas. Enter your daily consumption, lead time, and safety stock. The three results show you when to reorder, how much buffer you need, and the maximum your stock should reach.
| Assumption | Default |
|---|---|
| Safety factor | 2 days |
| Optimal order quantity | 200 units |
| Working days per week | 5 |
Reorder point
Daily consumption × Lead time + Safety stock
Determine safety stock
Suggestion: Daily consumption × Safety factor (days)
Maximum stock
Safety stock + Optimal order quantity
Model limitations
The formulas assume steady daily consumption and a fixed lead time. In practice, both fluctuate. For items with highly variable demand or unreliable suppliers, set the safety stock higher accordingly.
Continue calculating offline with your own data
The Excel template contains all three formulas. Enter your items and calculate the reorder point, minimum stock, and maximum stock for each one.
Worked example: Electrical contractor with NYM cable
An electrical contractor with 6 employees uses NYM-J 3x1.5 cable daily. The wholesaler's lead time is 5 working days.
Inputs
- 15 coils daily consumption (average over 6 weeks)
- 5 working days lead time (actually measured)
- 30 coils safety stock (2-day buffer)
- Optimal order quantity: 200 coils
Result
105 coils
A reorder is triggered at 105 coils. During the 5-day lead time, the business uses 75 coils. That leaves 30 coils as a buffer. The delivery arrives before the safety stock is touched.
| Metric | Result |
|---|---|
| Reorder point | 105 coils |
| Safety stock | 30 coils |
| Maximum stock | 230 coils |
Frequently asked questions about reorder points
Sources and further reading
Sources
- Panko, R. (2005): What We Don’t Know About Spreadsheet Errors Today, University of Hawaii
- Tempelmeier, H. (2020): Bestandsmanagement in Supply Chains, Norderstedt: Books on Demand
- Gudehus, T. (2012): Logistik 2: Netzwerke, Systeme und Lieferketten, Springer
- Bitkom Research (2025): Digitalisierung im Handwerk 2025
Next steps
The reorder point tells you when to reorder. But what do stockouts and emergency runs actually cost you? The warehouse cost calculator puts concrete numbers on it.