Calculate supplier lead time standard deviation and its impact on safety stock requirements. Measure supply reliability and buffer inventory needs.
Supplier lead time variability measures how consistently a supplier delivers relative to the promised lead time. While average lead time tells you when to expect delivery, the standard deviation tells you how much that delivery timing fluctuates. High variability forces you to hold more safety stock to prevent stockouts during unexpectedly long lead times.
For manufacturers, lead time variability often has a bigger impact on safety stock requirements than demand variability. A supplier who delivers in 10 days on average but ranges from 5 to 20 days requires substantially more safety stock than one averaging 12 days but consistently delivering in 11-13 days.
This calculator takes your lead time data and computes the standard deviation, coefficient of variation, and the resulting safety stock impact, helping you quantify the cost of unreliable supply and justify supplier improvement initiatives.
Tracking this metric consistently enables manufacturing teams to identify performance trends early and take corrective action before minor inefficiencies escalate into significant production losses.
Lead time variability is a hidden inventory cost driver. Quantifying it helps you identify which suppliers are most unreliable, calculate the excess safety stock their inconsistency forces you to carry, and build a business case for supplier development or alternative sourcing. This quantitative approach replaces subjective estimates with hard data, enabling confident planning decisions and more effective resource allocation across production operations.
Lead Time Std Dev (σ_LT) = √[Σ(LT_i − Avg_LT)² / (n−1)] Coefficient of Variation = σ_LT / Avg_LT × 100 Safety Stock (LT component) = Z × Avg_Daily_Demand × σ_LT
Result: Safety stock = 495 units from LT variability
With σ_LT = 3 days, Z = 1.65, and daily demand of 100 units: Safety stock = 1.65 × 100 × 3 = 495 units. The coefficient of variation is 3/14 = 21.4%, indicating moderate variability.
Collect the actual number of days between placing each order and receiving the goods. Calculate the average and standard deviation of this series. Track it over time with a control chart to spot trends or shifts in supplier performance. A sudden increase in variability may signal capacity issues, raw material problems, or transportation disruptions at the supplier.
Each day of additional lead time variability (standard deviation) forces you to hold more safety stock. For a $50 item consumed at 100 units per day with a carrying rate of 25%, each additional day of σ_LT costs approximately $50 × 100 × 1.65 × 25% = $2,063 in annual carrying cost at 95% service.
Share your lead time data with the supplier transparently. Set variability targets alongside average lead time targets. Conduct joint root cause analysis on outlier deliveries. Consider capacity reservation agreements or consignment inventory at intermediate points to buffer variability.
Safety stock is driven by uncertainty, not averages. A supplier averaging 10 days with σ=1 requires much less safety stock than one averaging 10 days with σ=5, because the chance of an unexpectedly long delivery is much higher.
Below 10% is good, indicating consistent deliveries. 10-20% is moderate and manageable with safety stock. Above 25% is poor and should trigger supplier development or alternative sourcing efforts.
At least 20-30 lead time observations give a reasonable estimate. More data points improve accuracy. Use recent data (last 6-12 months) to reflect current supplier performance.
The combined safety stock formula is: SS = Z × √(LT × σ_d² + d² × σ_LT²), where LT = average lead time, d = average demand, σ_d = demand std dev, and σ_LT = lead time std dev. Reviewing these factors periodically ensures your analysis stays current as conditions and requirements evolve over time.
Yes, through supplier development programs, joint process improvement projects, upstream inventory buffers at the supplier, better transportation management, and in some cases, shifting to a closer supplier or adding a local distribution point. Keeping detailed records of these calculations will streamline future planning and make it easier to track changes over time.
Z = 1.28 for 90% service level, 1.65 for 95%, 2.05 for 98%, and 2.33 for 99%. Higher service levels require exponentially more safety stock. Match the Z-score to the item's criticality and ABC classification.