A clearer path from supplier search to purchase order. Meet your sourcing toolkit

Inventory & Reordering

How to Manage Lead Time Variability in Your Inventory Planning

By Nathan RobbPublished 5 min read

THE SHORT ANSWER

Lead time variability refers to the uncertainty in the time between placing an order and receiving it. Managing this requires calculating the standard deviation of delivery times and maintaining strategic safety stock to hedge against late deliveries and manufacturing delays.

Understanding Lead Time Variability

In a stable supply chain, lead time is the predictable duration between the initiation of a procurement process and the arrival of goods. However, in real-world operations, this duration is rarely constant. Lead time variability is the fluctuation around the average lead time, often expressed as a standard deviation. This uncertainty can stem from various sources, including transportation delays, customs bottlenecks, or manufacturing instabilities.

From a planning perspective, lead time variability represents a significant risk. If a company plans based solely on the average lead time, any delivery that arrives later than the mean will result in a stockout unless there is a buffer in place. Therefore, organizing supply timing variability is a critical component of inventory optimization [1].

Key Factors of Supply Variability

To manage variability, planners must first distinguish between the different types of uncertainty affecting the supply chain. Not all delays are treated the same in inventory algorithms.

Lead Time Uncertainty

This is the primary driver of supply timing variability. It captures the variations in lead times caused by natural or external forces [1]. For example, a shipment that typically takes 14 days might take 21 days due to a port strike or severe weather. This variability is what planners typically hedge against using safety stock.

Exclusions in Variability Planning

It is important to note that standard lead time variability calculations typically exclude certain operational choices and systemic failures to avoid skewing the data:

  • Expediting: The effects of rushing an order or placing advance orders are generally not included, as these are tactical decisions rather than natural variability [1].
  • Upstream Unavailability: Delays caused by a supplier’s lack of raw materials are often categorized as a separate measurement of material unavailability rather than simple lead time variability [1].

Practical Workflow for Managing Variability

Managing lead time variability requires a transition from static planning to a statistical approach. The following workflow outlines how to integrate variability into an inventory plan.

1. Data Collection and Lead Time Calculation

The first step is to calculate the actual lead times for a specific set of SKUs over a defined period. This involves recording the date the purchase order was sent and the date the goods were received and made available for use.

2. Calculating the Standard Deviation

Once the mean (average) lead time is established, the planner must calculate the standard deviation. This figure represents the “variability.” A low standard deviation indicates a highly reliable supplier, while a high standard deviation suggests a volatile supply chain that requires more protection.

3. Determining Safety Stock Requirements

Safety stock is specifically employed to hedge against uncertainty in delivery and manufacturing lead times [1]. The amount of safety stock required is typically a function of:

  • The desired service level (e.g., 95% or 99% probability of not stocking out).
  • The standard deviation of demand.
  • The standard deviation of lead time (the variability).

4. Implementation of Inventory Optimization

In advanced systems, such as SAP IBP, this variability is fed into an inventory optimization operator. This allows the system to determine whether to hold safety stock at a single stage (decomposed optimization) or across a multi-stage network (global optimization) to maximize efficiency [1].

Worked Example: Lead Time Variability Calculation

Note: The following scenario uses illustrative numbers to demonstrate the reasoning behind safety stock for lead time variability.

Scenario: A company orders custom packaging from a supplier. The average lead time is 20 days. However, the lead time varies. Over the last five orders, the lead times were 18, 22, 20, 25, and 15 days.

  • Average Lead Time: 20 days.
  • Observed Variability: The range is 10 days (from 15 to 25).
  • Impact: If the company only holds enough stock for 20 days of demand, they will be out of stock for any order that takes 21 days or longer. In this sample, 40% of orders (2 out of 5) arrived late.
  • Solution: The planner calculates the standard deviation of these lead times and applies a service factor (e.g., 1.65 for a 95% service level) to determine the exact amount of extra “days of cover” needed as safety stock to ensure they don’t run out during those 25-day cycles.

Limitations and Evidence Checks

While statistical models are powerful, they have inherent limitations that planners must monitor:

  • Normal vs. Gamma Distribution: Most basic calculations assume a “Normal” (bell curve) distribution of lead times. However, lead times are often skewed (they can’t be less than zero but can be infinitely long), meaning a Gamma distribution may be more accurate for certain supply chains [1].
  • Time-Varying Demand: Lead time variability does not act alone. If demand is also fluctuating (time-varying demand), the impact on safety stock is compounded [1].
  • Data Quality: Variability calculations are only as good as the timestamp data. If “received date” is logged when the truck arrives rather than when the items are put away, the lead time is underestimated.

Common Mistakes in Variability Management

MistakeConsequenceCorrective Action
Planning only for the average lead timeFrequent stockouts during late deliveriesIntegrate standard deviation into safety stock formulas
Including “expedited” orders in the averageArtificially low lead times in the systemSeparate tactical expediting from natural variability data [1]
Ignoring upstream material shortagesMisidentifying a supplier’s process failure as “timing variability”Track material unavailability as a separate metric [1]

FAQ

Does lead time variability include the time it takes to expedite an order?

No. According to SAP IBP guidelines, lead time variability should capture variations due to natural and external forces and should not include the effects of expediting or advance order placements [1].

How does lead time variability differ from material unavailability?

Lead time variability refers to the timing of the delivery (e.g., the truck is late), whereas material unavailability refers to the supplier's inability to provide the material at all due to upstream shortages [1].

FOLLOW THE INFORMATION

Sources & references

  1. SAP Learning, Organizing supply timing variability, https://learning.sap.com/courses/mastering-sap-ibp-for-inventory-planning-and-optimization/organizing-supply-timing-variability

Use this reference alongside your own requirements and the information provided by prospective suppliers. Suggest a correction.

Add to the conversation

Your email address will not be published. Required fields are marked *