Lead Time Analysis Calculator

Every supplier quotes a lead time. Almost no supplier hits it every single time. Lead Time Analysis takes your actual order history — not the quote, the reality — and turns it into an average, a range, and a measure of how much it actually varies.

This matters because a single average number hides the part that actually causes stockouts. Two suppliers can both average 11 days and be completely different to work with: one always lands between 10 and 12 days, the other swings anywhere from 5 to 20. Same average, very different risk. Reorder Point and Safety Stock both depend on knowing which kind of supplier you're actually dealing with — plugging in the quoted number instead of the observed spread is one of the most common ways those calculations end up wrong.

Buyers and planners run this whenever they're qualifying a new supplier, renegotiating terms, or just trying to figure out why a particular SKU keeps almost stocking out despite a reasonable reorder point.

Alongside the average, this calculator reports:

• Minimum and Maximum — the observed range, showing the best and worst case so far
• Standard deviation — how tightly the lead times cluster around the average. A small standard deviation means a predictable supplier; a large one means real variability you need to plan around.

The standard deviation is the number that feeds directly into Safety Stock's formula — it's not just a nice-to-have statistic, it's the actual input that determines how much buffer a variable supplier requires.

Observed lead times from the last 6 orders: 10, 12, 11, 10, 13, 12 days

This supplier's orders typically land in about 11-12 days, with a tight spread — a reasonably reliable performer.

Now compare a second supplier with the same 11.33-day average, but a rougher history: 6, 14, 9, 17, 8, 14 days. Same average — very different reality. The standard deviation on that second set comes out to roughly 3.9 days, more than three times as variable. A Safety Stock calculation using that supplier's real variability would call for a meaningfully larger buffer than one built on the first supplier's tighter spread, even though both suppliers "average 11 days."

This works best with a reasonable sample size — three or four orders isn't enough to say much about a supplier's real variability, while a dozen or more starts to tell a genuine story. It also assumes recent orders are representative of what's coming; a supplier that changed ownership, shipping method, or production location six months ago may not behave like their older order history suggests.

It's also worth remembering this only measures lead time variability, not demand variability. A complete safety stock picture accounts for both — this calculator handles one half of that equation.

Using the quoted lead time instead of the observed one.The number on the purchase order is an aspiration, not a fact. Pull actual receiving dates and use those.

Looking only at the average. Two suppliers with the same average lead time can carry very different risk. The standard deviation is where the real information is.

Using too small a sample. Three or four orders can make an inconsistent supplier look stable, or a stable one look erratic, just by chance. Pull as much recent history as you reasonably can.

Mixing old and new supplier behavior. If something changed — a new plant, a new freight carrier, a new account manager — older orders may not represent what to expect going forward. Weight recent history more heavily, or drop the stale data entirely.

Never recalculating. Supplier performance drifts. A supplier that was reliable a year ago may not be today — recheck the numbers periodically, especially after a rocky order or two.

There's no single "good" standard deviation — it scales with the lead time itself. As a rough gut check, a standard deviation under roughly 15% of the average lead time suggests a fairly predictable supplier; above 30% suggests real variability worth planning around with extra safety stock or a backup source. The two example suppliers above illustrate the gap clearly: 1.11 days on an 11.33-day average is about 10% — tight. 3.9 days on the same average is closer to 34% — loose enough to actively manage.

Once you know how a supplier actually performs:

1. Feed the real numbers into Reorder Point and Safety Stock— stop planning around the quoted lead time.
2. Fold it into a Supplier Scorecard — lead time reliability is a legitimate performance dimension, not just a planning input.
3. Weigh it against total cost — a cheap but erratic supplier can cost more once stockouts and expedited freight are counted.

• Reorder PointLead time is a direct input — don't guess it, measure it.
• Safety StockA wide lead time spread means you need more buffer, not just a longer one.
• Supplier ScorecardLead time reliability is one input to an overall supplier rating.
• Total Cost of OwnershipAn unreliable but cheap supplier may not actually be cheaper.

Books:

• Inventory and Production Management in Supply Chains by Edward Silver, David Pyke, and Douglas Thomas

Standards & curricula:

• APICS (ASCM) CSCP certification curriculum

General references for further study, not endorsements — verify course availability and content directly with the provider.