The lead time formula has two canonical forms and four situational variants, and choosing the wrong one is the most common reason a calculation returns a confident, precise, wrong answer. The date-subtraction form reports what happened. The component-sum form explains why. Manufacturing, procurement and cumulative lead time each modify the component form for a different stage, and cumulative lead time breaks the pattern entirely by taking a maximum where every other variant takes a sum. This page sets out all six, runs a single order through each of them, and covers the three errors — mismatched triggers, mixed unit bases, and summing what should be maximised — that survive in planning spreadsheets precisely because none of them produces an obviously broken result.
- Two canonical forms.
Delivery Date − Request Datefor reporting,Pre-Processing + Processing + Post-Processingfor diagnosis. Use the second when you want to change the number, not just state it. - Cumulative lead time is a maximum, not a sum. Branches of 50, 12, 8 and 6 weeks give 50 weeks, not 76. This single error inflates more master-data records than any other.
- Run time is the smallest term in manufacturing lead time. Four hours of work inside 15 days is ~3% efficiency, and it means a faster machine attacks 3% of the problem.
- Calculate in working days, commit in dates. 20 working days and 20 calendar days differ by 8 days before any holiday.
- In Excel,
=NETWORKDAYS(start, end, holidays)−1. Without the −1 every lead time you report is one day long. - Most quote mismatches are trigger mismatches. The cross-industry median from requisition to purchase order is 55 hours, and that gap sits outside the supplier’s formula entirely.
The Two Canonical Forms
Every lead time formula is a variation on one of two statements. The first subtracts two dates. The second adds up what happened between them.
Lead Time = Order Delivery Date − Order Request DateLead Time = Pre-Processing Time + Processing Time + Post-Processing TimeThey return the same number when the timestamps are complete, and they answer different questions. The date-subtraction form needs two fields from a transaction record and is what you report. The component form needs the whole chain broken out and is what you use when someone asks why the number is what it is.
The practical test is what you intend to do with the answer. If the next step is a dashboard, subtract the dates. If the next step is an improvement project, break out the components — because a total nobody can decompose is a total nobody can reduce.
The Six Formulas
Four variants modify the component form for a specific stage. The fifth and sixth are where most calculation errors live.
1. Basic Lead Time
Lead Time = Delivery Date − Request DateThe reporting form. Fast, unambiguous, and silent about causes. Use it for measurement and historical analysis, never for diagnosis.
2. Component Lead Time
Lead Time = Pre-Processing + Processing + Waiting + Post-ProcessingThe diagnostic form. Waiting time is often folded into processing, and pulling it out separately is usually worth the effort — in most chains it is the largest term and the cheapest to attack.
3. Manufacturing Lead Time
Manufacturing Lead Time = Order Prep + Queue + Setup + Run + Wait + Move + InspectionNote where run time sits: one term among seven, and typically the smallest. World-class discrete manufacturers run manufacturing cycle efficiency between 5% and 15%, meaning 85% or more of the elapsed time is queue, setup, movement and inspection. A plant with a lead time problem is usually looking at the run column.
4. Procurement Lead Time
Procurement Lead Time = Requisition + Approval + PO Processing + Supplier Lead Time + Transit + Goods ReceiptThe first three terms are yours and the supplier never sees them. The cross-industry median for requisition through purchase order release is 55 hours, roughly two and a half working days, with the slowest industries at 90 hours. That block sits entirely outside any supplier quote, which is why a procurement lead time calculation that starts at the purchase order consistently reads short.
5. Cumulative Lead Time
Cumulative Lead Time = MAX( lead time of each branch through the bill of material )This is the one that breaks the pattern. Every other variant sums; this one maximises, because the levels of a bill of material are procured in parallel rather than in series. Summing the branches can overstate the answer several times over.
6. Lead Time Demand
Lead Time Demand = Average Daily Demand × Lead TimeNot a lead time at all, but the reason most lead times get calculated. It converts a duration into the quantity you must hold to cover it, and it is the bridge from this page into reorder point and safety stock work.
One Order Through Every Formula
A single purchase order, calculated six ways. A distributor orders a machined assembly. The requisition is raised Monday 5 January 2027 and the goods are received Monday 2 February.
| Stage | Owner | Days |
|---|---|---|
| Requisition raised | Buyer | 1 |
| Approval cycle | Manager | 3 |
| PO processing | Buyer | 1 |
| Supplier production | Supplier | 14 |
| Transit | Carrier | 7 |
| Goods receipt and inspection | Warehouse | 3 |
Applying each formula to the same order:
| Formula | Result | What it answers |
|---|---|---|
| Basic | 28 calendar days | What the record shows |
| Component | 29 days summed | Where the time went |
| Manufacturing (supplier's view) | 14 days | What the supplier controls |
| Procurement (full) | 29 days | What the business waits |
| Cumulative (if 3 parallel branches) | 29 days, not 87 | When the assembly can start |
| Lead time demand (at 100 units/day) | 2,900 units | What to hold to cover it |
Six defensible answers from one order. The supplier quoted fourteen days and delivered in fourteen. The requester waited twenty-nine. Five of those days were spent before the supplier saw the order and three after the goods arrived — and if this business reports lead time using the basic formula alone, that eight-day block is invisible to everyone who could shorten it.
Cumulative Lead Time: the Maximum, Not the Sum
This deserves its own section because it is the most expensive formula error in master data.
Take an assembly with four purchased branches:
| Branch | Component | Lead time |
|---|---|---|
| A | Memory module | 50 weeks |
| B | PCB, standard laminate | 12 weeks |
| C | Sheet metal | 8 weeks |
| D | Fasteners | 6 weeks |
The branches are ordered on the same day and arrive independently. Cumulative lead time is 50 weeks — the longest path. Summed, it would read 76 weeks, overstating by more than half a year and pushing every dependent date out with it.
Correct: MAX(50, 12, 8, 6) = 50 weeksWrong: 50 + 12 + 8 + 6 = 76 weeksThe same logic runs in reverse when the branches are dependent. If the PCB cannot be ordered until the sheet metal is measured, those two are in series and add. The rule is not "always maximise" — it is that parallel paths maximise and dependent paths sum, and a bill of material usually contains both.
Averaging the branches is worse than either. An average of 19 weeks describes nothing that will ever happen: the assembly cannot start at 19 weeks and does not need 76.
The Lead Time Formula in Excel
Two functions cover almost everything, and one character causes most of the errors.
| Purpose | Formula |
|---|---|
| Quoted lead time to a promised date | =WORKDAY(A2, B2, $H$2:$H$20) |
| Two dates to an actual lead time | =NETWORKDAYS(A2, D2, $H$2:$H$20)-1 |
| Non-standard working week | =WORKDAY.INTL(A2, B2, 7, $H$2:$H$20) |
| Variance against the quote | =E2-B2 |
| Variability across orders | =STDEV.S(E:E) |
The -1 on NETWORKDAYS is not optional. The function counts both the start and end dates, so an order placed and received on the same day returns 1 rather than 0. Without the subtraction, every figure in the sheet reads one day long — and because it is a constant offset rather than a random error, it never looks wrong enough to investigate. A lead time calculator in Excel walks through building this as a tracker.
Note the absolute references on the holiday range. Writing H2:H20 instead of $H$2:$H$20 means the range slides as you fill down, so row 2 reads the right holidays and row 40 reads empty cells. The sheet is then correct at the top and progressively wrong further down, which is the hardest error to catch in review.
Where the Arithmetic Breaks
Three errors account for most wrong answers, and none of them produces an obviously broken result.
Mismatched Triggers
The supplier's clock starts at order receipt or payment clearing. Yours starts at requisition. Both parties calculate correctly and get different numbers, and the gap is exactly the block neither is measuring. Before comparing any two lead time figures, establish what event each one starts at — in practice this resolves more disputes than any amount of recalculation.
Mixed Unit Bases
Twenty working days and twenty calendar days differ by eight days on a five-day week, before a single holiday. Quotes in weeks make it worse, because a supplier usually means calendar weeks and an internal planner usually hears working weeks. State the basis with every figure, every time. A working days calculator and a business days calculator handle the conversion, but the ambiguity has to be resolved in the conversation first.
Summing What Should Be Maximised
Covered above, and worth repeating because it is the only error on this list that can be wrong by a factor rather than by days. Parallel branches maximise. Dependent steps sum. Getting these the wrong way round produces master data that is out by months.
Choosing the Right Formula
| If you need to... | Use |
|---|---|
| Report what happened | Basic — date subtraction |
| Find where the time goes | Component |
| Improve a shop floor | Manufacturing |
| Hold a supplier to a quote | Procurement, split at the PO |
| Schedule an assembly | Cumulative — maximum of branches |
| Size inventory | Lead time demand |
The formula is chosen by the decision, not by the data available. Picking the one that fits the numbers you happen to have is how a reporting formula ends up driving an improvement project, and why so many lead time reduction efforts start by attacking the wrong term.
FAQs About the Lead Time Formula
What is the lead time formula?
The reporting form is Lead Time = Order Delivery Date − Order Request Date. The diagnostic form is Lead Time = Pre-Processing + Processing + Post-Processing. Both return the same number when the timestamps are complete, but only the second shows where the duration accumulates. An order placed 5 January and received 2 February has a lead time of 28 calendar days, or 20 working days.
What is the manufacturing lead time formula?
Manufacturing Lead Time = Order Preparation + Queue + Setup + Run + Wait + Move + Inspection. Run time is usually the smallest term. A part with 4 hours of run time inside a 15-day manufacturing lead time is running at roughly 3% manufacturing cycle efficiency, which is below the 5% to 15% world-class discrete manufacturers achieve but not unusual.
Why is cumulative lead time a maximum and not a sum?
Because the levels of a bill of material are procured in parallel, not in series. Cumulative lead time is the longest dependent path through the bill, so it is the maximum of the branch totals. Summing every branch overstates the answer, often by several times. An assembly with branches of 50, 12, 8 and 6 weeks has a cumulative lead time of 50 weeks, not 76.
How do I calculate lead time in Excel?
Use =WORKDAY(start, days, holidays) to turn a quoted lead time into a promised date, and =NETWORKDAYS(start, end, holidays)-1 to measure an actual lead time from two dates. The -1 matters because NETWORKDAYS counts both endpoints, so without it every lead time you report reads one day long.
Should lead time be calculated in calendar days or working days?
Calculate in working days and commit in calendar dates. Working days measure capacity, which is what a schedule needs; a customer needs a date. State the unit basis with every figure, because 20 working days and 20 calendar days differ by 8 days on a five-day week before a single holiday is counted.
What is the difference between lead time and cycle time in the formula?
Cycle time measures how long one unit is actively worked on. Lead time measures the full elapsed interval including every queue between steps. Cycle time sits inside lead time, and the ratio between them is process cycle efficiency. A process with 4.5 hours of work inside 10 elapsed days runs at about 6% efficiency.
Why does my calculated lead time never match the supplier’s quote?
Usually because the two formulas start at different events. A supplier’s clock starts at order receipt or at payment clearing; yours starts at requisition. The median requisition-to-PO cycle across industries is 55 hours, so a buyer measuring from requisition and a supplier measuring from PO receipt are roughly two and a half working days apart before anything physical happens.
The Bottom Line
The lead time formula is chosen by the decision it has to support. Subtract two dates to report; sum the components to diagnose; maximise the branches to schedule an assembly; multiply by demand to size inventory. Most wrong answers come from three places rather than from the arithmetic: two parties measuring from different start triggers, a figure moving between working and calendar bases without being restated, and parallel branches being summed when they should be maximised. Fix those three and the formulas themselves are straightforward.
Related Articles
- What Is Lead Time? Definition, Types, How to Measure — the ten types and the measurement method behind these formulas.
- How to Calculate Reorder Point When Lead Time Varies — where lead time demand leads.
- How Lead Time Variance Inflates Safety Stock — why the spread matters more than the average.
- How to Reduce Lead Time: 23 Strategies — what to do once the component form shows where the days are.
Related Calculators
- Lead Time Calculator — total order-to-delivery time across all stages.
- Procurement Lead Time Calculator — requisition through goods receipt, with the internal block split out.
- Manufacturing Lead Time Calculator — queue, setup, run, move and inspection time.
- Material Lead Time Calculator — the long pole on a bill of material.
- Lead Time Calculator in Excel — build the formulas above as a tracker.
- Lead Time Calculator Working Days — convert a working-day figure to elapsed time.
- Lead Time Calculator With Holidays — add shutdowns and public holidays.
- All lead time calculators — the full set.
External references: the Association for Supply Chain Management publishes the dictionary definitions these formulas follow, and APQC maintains the open-standard benchmarks for purchase order cycle time cited above.