Reorder Point Calculator โ When to Trigger a Purchase Order
Calculate the exact reorder point for each SKU. Know when to trigger a purchase order so stock arrives before you run out, even accounting for demand variability and lead time uncertainty.
๐ Reorder Point Calculator
How to Use This Calculator
- Enter average daily demand and variability โ use 13-week rolling average for demand; standard deviation from demand history.
- Enter lead time and its variability โ average days from PO to receipt. If lead time is also variable, include its std dev for a more accurate ROP.
- Enter current stock โ to see how many days until you hit the reorder point and should place a purchase order.
Worked Example
50 units/day demand, ฯ15, 14-day lead time, ฯ3, 95% service level, 850 units on hand.
- Safety stock: 1.65 ร โ(14ร225 + 2500ร9) = 1.65 ร โ(3150+22500) = 1.65 ร 160.2 = 265 units
- Cycle stock: 50 ร 14 = 700 units
- ROP: 700 + 265 = 965 units
- Days to ROP: (850 โ 965) รท 50 = โ2.3 (already below ROP โ order now!)
Including lead time variability significantly increases the ROP vs a simple formula. If your supplier sometimes delivers in 11 days and sometimes in 17 days (ฯ=3), you need substantially more safety stock to maintain service levels.
Frequently Asked Questions
Safety stock is the buffer against variability (demand spikes, late deliveries). ROP is the total inventory level that triggers a purchase order โ it includes both the expected consumption during lead time (cycle stock) AND the safety stock. ROP = Cycle Stock + Safety Stock. You should always have at least safety stock on hand when your new order arrives.
Monthly for fast-moving A-items with variable demand. Quarterly for B-items. Annually for slow-moving C-items. Recalculate immediately after significant demand changes, supplier changes, or lead time shifts. Most WMS/ERP systems can automate this calculation if fed with current demand statistics.