Inventory Reorder Point & Safety Stock
Calculate optimal reorder points and safety stock with demand variability. Enter values for instant results with step-by-step formulas.
Formula
ROP = (Daily Demand × Lead Time) + Safety Stock; SS = Z × √(LT×σD² + D²×σLT²)
## Core Formulas **Reorder Point (ROP)**: ROP = (D × LT) + SS Where D = average daily demand, LT = lead time in days, SS = safety stock. **Safety Stock (with both demand and lead time variability)**: SS = Z × √(LT × σD² + D² × σLT²) Where Z = Z-score for desired service level, σD = demand standard deviation, σLT = lead time standard deviation. **Economic Order Quantity (EOQ)**: EOQ = √(2DS / H) Where D = annual demand, S = ordering cost per order, H = annual holding cost per unit. ## Why This Formula Works The safety stock formula captures the statistical reality that uncertainty compounds during the lead time period. The demand during lead time isn't just "average demand × lead time"—it's a random variable with its own distribution. When both demand and lead time vary, we must account for their combined effect. The square root in the formula comes from the statistics of summing random variables. If daily demands are independent, the variance of total demand over LT days is LT × σD² (not LT × σD). Similarly, if lead time itself is random, its contribution to uncertainty is D² × σLT². The combined standard deviation is the square root of the sum of these variances. The Z-score translates the desired service level (e.g., 95% probability of not stocking out) into "how many standard deviations above average" we need. This assumes demand follows a normal distribution—reasonable for high-volume items with many independent customer orders, less reliable for lumpy demand. The EOQ formula optimizes the tradeoff between ordering costs (favoring larger, less frequent orders) and holding costs (favoring smaller, more frequent orders). The square root relationship means that if demand doubles, optimal order quantity increases by only 41% (√2 ≈ 1.41), not 100%.
Worked Examples
Example 1: Electronics Retailer
Problem:Daily demand: 100 units (σ=20). Lead time: 7 days (σ=2 days). Target 95% service level. Order cost $50. Holding cost 25% of $10 unit cost.
Solution:Step 1: Calculate Z-score for 95% = 1.65 Step 2: Combined standard deviation σcombined = √(7×20² + 100²×2²) = √(2800 + 40000) = √42800 = 207 units Step 3: Safety Stock SS = 1.65 × 207 = 342 units (3.4 days supply) Step 4: Demand during lead time DDLT = 100 × 7 = 700 units Step 5: Reorder Point ROP = 700 + 342 = 1,042 units Step 6: EOQ Annual demand = 100 × 365 = 36,500 Holding cost = $10 × 25% = $2.50/unit/year EOQ = √(2×36500×50/2.50) = 1,208 units Order 1,208 units when inventory hits 1,042.
Result:ROP: 1,042 units | Safety Stock: 342 units | EOQ: 1,208 units | 30 orders/year
Example 2: Food Distributor (High Variability)
Problem:Daily demand: 500 units (σ=150). Lead time: 3 days (σ=1 day). 97% service level. Order cost $100. Holding cost 35% of $5 unit.
Solution:High variability scenario: Demand CV = 150/500 = 30% (high) Lead time CV = 1/3 = 33% (high) Z-score for 97% = 1.88 σcombined = √(3×150² + 500²×1²) = √(67500 + 250000) = √317500 = 564 units Safety Stock = 1.88 × 564 = 1,060 units DDLT = 500 × 3 = 1,500 units ROP = 1,500 + 1,060 = 2,560 units EOQ = √(2×182500×100/1.75) = 4,564 units High variability requires 2+ days safety stock despite short lead time.
Result:ROP: 2,560 units | Safety Stock: 1,060 (2.1 days) | High variability = high buffer
Example 3: Pharmaceutical - 99% Service
Problem:Daily demand: 50 units (σ=5). Lead time: 14 days (σ=1 day). 99% service (critical medicine). Order cost $200. Holding cost 20% of $100 unit.
Solution:Critical item - 99% service level: Z-score = 2.33 Low demand variability (CV=10%) but strict service requirement. σcombined = √(14×5² + 50²×1²) = √(350 + 2500) = √2850 = 53 units Safety Stock = 2.33 × 53 = 124 units (2.5 days) DDLT = 50 × 14 = 700 units ROP = 700 + 124 = 824 units EOQ = √(2×18250×200/20) = 604 units High unit cost makes holding expensive; order more frequently.
Result:ROP: 824 units | SS: 124 units | EOQ: 604 | 30 orders/year | $12K holding cost
Frequently Asked Questions
What is a reorder point?
The reorder point (ROP) is the inventory level at which a new order should be placed to replenish stock before it runs out. It accounts for demand during lead time plus safety stock buffer. When inventory drops to ROP, trigger a purchase order. ROP = (Average Daily Demand × Lead Time) + Safety Stock.
What is safety stock?
Safety stock is extra inventory held to protect against uncertainty in demand and lead time. It acts as a buffer against stockouts when demand exceeds forecast or suppliers deliver late. Higher service levels require more safety stock. Typical ranges: 1-4 weeks of average demand depending on variability and service requirements.
How do I calculate safety stock with variable demand and lead time?
Combined formula: SS = Z × √(LT × σD² + D² × σLT²) where Z is service level factor, LT is lead time, σD is demand standard deviation, D is average demand, and σLT is lead time standard deviation. This captures both sources of uncertainty simultaneously.
What service level should I target?
Common targets: 90% for low-margin items, 95% for standard items, 97-99% for critical items, 99.9% for safety-critical items. Higher service levels cost exponentially more in safety stock. Balance customer expectations, margin, and stockout costs. Most businesses target 95-97%.
What is the Economic Order Quantity (EOQ)?
EOQ is the optimal order size that minimizes total inventory costs (ordering + holding). Formula: EOQ = √(2DS/H) where D is annual demand, S is order cost, H is annual holding cost per unit. It balances: fewer orders (saves ordering costs) vs smaller orders (saves holding costs).
What costs go into holding cost?
Holding costs include: capital cost (opportunity cost of tied-up money, typically 10-15%), storage costs (warehouse rent, utilities), insurance, taxes, obsolescence/spoilage risk, and handling costs. Total typically 20-30% of inventory value per year.
How does lead time variability affect inventory?
Lead time variability often has bigger impact than demand variability. A supplier who sometimes delivers in 3 days, sometimes 10 days, requires far more safety stock than one consistently delivering in 7 days. Work with suppliers to reduce variability, not just average lead time.
What is cycle stock vs safety stock?
Cycle stock is inventory that cycles between order quantities - it gets depleted and replenished regularly (EOQ/2 average). Safety stock is the minimum level maintained at all times as a buffer. Total average inventory = (EOQ/2) + Safety Stock.
When should I use periodic vs continuous review?
Continuous review: order when inventory hits ROP, any quantity (usually EOQ). Best for: valuable items, reliable systems. Periodic review: order at fixed intervals, variable quantity to reach target. Best for: supplier consolidation, simple systems. Both need safety stock but calculate differently.
How do I reduce safety stock without increasing stockouts?
Strategies: reduce lead time (faster suppliers), reduce lead time variability (reliable suppliers), reduce demand variability (better forecasting, smoothing promotions), accept lower service level on low-value items, use vendor-managed inventory, or implement postponement strategies.