Purchase Order Lead Time & Safety Buffer Planner
Calculate safety stock and reorder points using lead time and demand variability for optimal inventory buffers
Formula
Safety Stock = Z × √(L × σD² + D² × σL²); ROP = (Avg Demand × Avg Lead Time) + Safety Stock
Safety stock calculation combines demand and lead time uncertainty using the square root of their weighted variances. Z-score (from normal distribution) corresponds to service level target: 95% = 1.65, 99% = 2.33. The formula accounts for: constant demand with variable lead time, variable demand with constant lead time, and both varying simultaneously (most realistic). Reorder point adds safety stock to expected lead time demand (average consumption during replenishment). Example: 100 units/day demand, 30-day lead time, 845 unit safety stock. ROP = 3,000 + 845 = 3,845. Order when inventory hits 3,845. During 30-day wait, consume 3,000 (average), leaving 845 buffer. If demand spikes to 120/day (common within variability), consume 3,600, leaving 245 buffer (no stockout). The formula works because it sizes buffer to cover typical variability at your chosen risk tolerance (5% stockout with 95% service). Higher variability or higher service level increases Z or variance terms, increasing buffer proportionally.
Worked Examples
Example 1: Manufacturing Buffer Planning
Problem:Component lead time 30 days (±5 days std dev), demand 100 units/day (±20 std dev), target 95% service level. Calculate safety stock and reorder point.
Solution:Inputs: - Avg lead time (L): 30 days - Lead time std dev (σL): 5 days - Avg demand (D): 100 units/day - Demand std dev (σD): 20 units/day - Service level: 95% (Z = 1.65) Safety Stock Calculation: Formula: SS = Z × √(L × σD² + D² × σL²) = 1.65 × √(30 × 20² + 100² × 5²) = 1.65 × √(30 × 400 + 10,000 × 25) = 1.65 × √(12,000 + 250,000) = 1.65 × √262,000 = 1.65 × 511.86 = 844.6 units Reorder Point: ROP = (D × L) + SS = (100 × 30) + 845 = 3,000 + 845 = 3,845 units Interpretation: - When inventory drops to 3,845, place order - Normal consumption during 30 days: 3,000 units - Safety buffer: 845 units (8.45 days demand) - Service level: 95% (1 stockout per 20 cycles) Cost Analysis (assuming $10/unit value, 25% holding cost): - Safety stock value: 845 × $10 = $8,450 - Annual holding cost: $8,450
Result:Safety stock: 845 units (8.5 days) | ROP: 3,845 units | 95% service level | $2,113 annual holding cost
Frequently Asked Questions
What is purchase order lead time?
Lead time is duration from placing PO (purchase order) to receiving goods. Includes: Supplier processing (1-3 days), manufacturing/picking (varies), shipping (3-30 days), customs (international, 3-14 days). Example: Order on Day 1, receive Day 30 = 30-day lead time. Variability matters: if lead time is '30 days ±10', you must buffer for worst case (40 days) to avoid stockouts. Reducing lead time or variability reduces inventory requirements.
What is safety stock?
Safety stock is buffer inventory to prevent stockouts from demand spikes or supply delays. Formula: Z-score × √(Lead time × Demand variance + Demand² × Lead time variance). Z-score depends on service level (95% service = 1.65). Higher safety stock = fewer stockouts but higher holding costs. Trade-off: Cost of carrying inventory vs. cost of lost sales. Optimize: balance holding cost with stockout cost.
How do I calculate reorder point?
Reorder point (ROP) = (Avg daily demand × Avg lead time) + Safety stock. When inventory hits ROP, place new order. Example: Demand 100 units/day, lead time 30 days, safety stock 500. ROP = (100 × 30) + 500 = 3,500 units. When inventory drops to 3,500, reorder. New stock arrives in 30 days (consumed 3,000 units), leaving 500 safety buffer. If demand spikes or delivery delays, safety stock prevents stockout.
What service level should I target?
Service level = % of time you don't stock out. Common targets: 90% (budget items, easy to substitute), 95% (standard products), 99% (critical items, no substitutes), 99.9% (medical, safety-critical). Trade-off: Each additional '9' roughly doubles safety stock. 95% requires Z=1.65, 99% requires Z=2.33 (40% more stock). Choose based on: stockout cost (lost sales, customer anger) vs. holding cost (warehouse, capital tied up).
What causes lead time variability?
Lead time variation sources: (1) Supplier capacity (busy periods = delays), (2) Shipping disruptions (weather, port congestion, carrier issues), (3) Customs (random inspections, paperwork errors), (4) Quality issues (rejected batches, rework), (5) Order prioritization (supplier delays your order for larger customer). Reduce variability: (1) Supplier relationship (priority customer status), (2) Dual-source (backup supplier), (3) Premium shipping (faster, more reliable), (4) Near-shore vs. offshore (shorter, less variable).
How do I reduce safety stock without stockouts?
Options: (1) Reduce lead time (faster supplier, air vs. ocean freight), (2) Reduce lead time variability (reliable supplier, premium shipping), (3) Reduce demand variability (better forecasting, smooth production), (4) Lower service level (accept occasional stockouts if cost justified), (5) Just-in-time (JIT) delivery (supplier ships small batches frequently). Toyota JIT: Near-zero safety stock but requires reliable suppliers and stable demand. Most companies: Balance—maintain some buffer.
What is the cost of holding inventory?
Holding cost components: (1) Capital cost (money tied up, can't invest elsewhere; 8-12%/year), (2) Warehouse (rent, utilities; $5-10/sqft/year), (3) Insurance (0.5-2%), (4) Obsolescence (3-10%; higher for tech/fashion), (5) Shrinkage (theft, damage; 1-3%). Total: 20-30% of inventory value annually. Example: $1M inventory, 25% holding cost = $250K/year. Reducing safety stock $200K saves $50K/year. Compare to stockout costs to optimize.
What is EOQ and how does it relate to safety stock?
EOQ (Economic Order Quantity) optimizes order size (how much to order). Safety stock optimizes inventory level (when to order). EOQ balances: ordering cost (fixed per order) vs. holding cost (variable per unit). Formula: EOQ = √(2 × Demand × Order cost / Holding cost). Safety stock is separate: buffer against uncertainty. Together: Order EOQ quantity when inventory hits ROP (which includes safety stock). EOQ minimizes cost of ordering + holding. Safety stock minimizes stockout risk.
Should I buffer lead time or safety stock?
Same effect, different implementation. Lead time buffer: Order earlier (when inventory is higher). Safety stock buffer: Order at normal reorder point but keep more inventory. Mathematically equivalent: 5-day lead time buffer = 5 days of demand as safety stock. Practical difference: Lead time buffer is proactive (order early), safety stock is reactive (maintain buffer). Most use safety stock (easier to manage one variable—inventory level—than multiple: timing + level).
How does demand variability affect safety stock?
Higher variability = more safety stock needed. Formula: Safety stock ∝ √Demand variance. Example: Demand 100 units/day ± 20 (20% CV). Safety stock for 95% service ≈ 1.65 × 20 × √30 days = 181 units. If variability doubles (±40), safety stock: 1.65 × 40 × √30 = 362 units (doubles). Reduce variability: Better forecasting, aggregate demand (multiple customers smooth individual spikes), level production (smooth orders to supplier), safety stock pooling (central warehouse vs. distributed).