A supplier promises to deliver packaging in three days, but your last few purchase orders arrived in four, five, or six. If you continue ordering as though three days were guaranteed, even an otherwise well-managed store can run out of supplies or pay extra for emergency shipping.
Supplier lead time measures the elapsed time between placing a confirmed purchase order and receiving the goods. In this guide, you will learn how to calculate actual lead time, compare it with the promised date, review delivery reliability, and use the results to plan purchasing with fewer last-minute orders.
We will use a fictional U.S. retail example and explain how to record the same data in a free Supplier Lead Time Excel template. For related operational guides, start at Processes & Operations.
On This Page
- What Is Supplier Lead Time?
- Promised vs. Actual Supplier Lead Time
- Define Your Measurement Rules
- How to Calculate Supplier Lead Time
- Supplier Lead Time Example
- How to Interpret Supplier Lead Time Results
- Use Lead Time to Plan Purchases
- Lead Time vs. Purchase Planning and OTIF
- Common Supplier Lead Time Mistakes
- How to Use the Excel Workbook
- Download the Free Excel Template
- Frequently Asked Questions
What Is Supplier Lead Time?
Supplier lead time is the elapsed time from a defined purchasing event—usually when the supplier receives an accepted purchase order—until the ordered goods are received at the agreed destination. For planning purposes, many businesses need the goods to be available for use or sale, not simply marked as shipped.
Example: if a purchase order is accepted on April 1 and the complete shipment is received on April 5, the actual lead time is 4 calendar days under the convention used in this guide.
Supplier lead time is one component of the wider replenishment process. Internal requisition approval, receiving inspection, put-away, and other steps may require additional time. Define whether those activities are included in the planning lead time before comparing suppliers or using the result in inventory calculations.
Promised vs. Actual Supplier Lead Time
| Measure | How to calculate | Management question |
|---|---|---|
| Promised lead time | Promised delivery date − Purchase order date | How quickly did the supplier commit to deliver? |
| Actual lead time | Actual receipt date − Purchase order date | How long did the order really take? |
| Delivery delay | Actual receipt date − Promised delivery date | How many days early or late did it arrive? |
| On-time result | Actual receipt date on or before the agreed promised date | Was the delivery made by the commitment date? |
A positive delivery delay means the shipment arrived late; zero means it arrived on the promised date; a negative value means it arrived early. These measures are related but answer different questions. A supplier can have a short average lead time and still miss promised dates frequently.
Keep the original agreed commitment when assessing delivery performance. If the supplier later revises its expected date, record the updated forecast separately rather than erasing the original promise. The revised date may be useful for operations, but replacing the historical commitment can make reliability look artificially high.
Define Your Measurement Rules Before Collecting Data
- Start: the date the confirmed purchase order is placed or acknowledged under your stated policy. Do not use an informal quote request.
- Finish: the date the required goods are actually received. If inspection or put-away delays usability, document that additional time separately or use a consistently defined available-to-use date.
- Calendar: this basic example uses calendar days, so weekends and holidays count. Use business days only if your entire process, supplier agreement, and spreadsheet calculate them consistently.
- Complete vs. partial receipts: if an order arrives in multiple shipments, decide whether the KPI measures first receipt or full delivery. For critical materials, the final complete and accepted receipt may be more meaningful.
- Unit of analysis: compare the same supplier, product or category, destination, and operating conditions when possible. Mixing imported equipment with local packaging can distort averages.
- Incomplete orders: an open purchase order does not have a final actual lead time yet. Track it as open or overdue instead of treating the missing receipt date as zero days.
These rules are not universal accounting standards; they define the operational metric in this article. Consistency makes later comparisons useful. SAP, Oracle, and NetSuite also distinguish purchasing dates, expected receipts, actual receipts, and the timing conditions used in replenishment planning.
How to Calculate Supplier Lead Time Step by Step
Step 1. Identify each purchase order
Record a unique purchase order ID, supplier, product or category, and the relevant order date. A shipment without a traceable order reference is hard to audit, particularly if multiple orders cover the same product.
Step 2. Capture the promised delivery date
Use the documented commitment, not an estimated delivery window remembered by a buyer. If the supplier quotes a range, define which date counts as the promised deadline and preserve the underlying confirmation.
Step 3. Record the actual receipt
Enter the date the goods actually arrived under your receipt policy. Confirm quantities and note shortages, damage, or split shipments. A delivery arriving on time but incomplete should not automatically be labeled a complete success.
Step 4. Calculate actual lead time and delay
Actual lead time (days) = Actual receipt date − Order date. Delay (days) = Actual receipt date − Promised receipt date. Both are date differences, using the same calendar convention.
Step 5. Repeat the measurement
One purchase order is a case, not a trend. Begin with a small history—five comparable completed orders may support a first diagnosis—but do not treat five as a statistically sufficient sample for every supplier. Expand the sample for critical products, seasonal demand, or erratic deliveries.
Step 6. Compare providers and review changes
Calculate the average, minimum and maximum actual lead times, delivery delays, and on-time share. Review the figures by supplier and relevant product group; investigate the individual orders behind long delays rather than relying on a single summary number.
Supplier Lead Time Example: Five U.S. Purchase Orders
Imagine Pine Creek Packaging, a fictional U.S. supplier delivering shipping mailers to a small online retailer. The supplier promises delivery three calendar days after each accepted order. The table shows five completed purchase orders; these are illustrative records, not actual supplier performance data.
| Order date | Promised date | Actual receipt | Promised LT | Actual LT | Delay |
|---|---|---|---|---|---|
| Apr 1, 2026 | Apr 4, 2026 | Apr 4, 2026 | 3 days | 3 days | 0 days |
| Apr 6, 2026 | Apr 9, 2026 | Apr 11, 2026 | 3 days | 5 days | +2 days |
| Apr 13, 2026 | Apr 16, 2026 | Apr 17, 2026 | 3 days | 4 days | +1 day |
| Apr 20, 2026 | Apr 23, 2026 | Apr 26, 2026 | 3 days | 6 days | +3 days |
| Apr 27, 2026 | Apr 30, 2026 | May 1, 2026 | 3 days | 4 days | +1 day |
The five actual lead times are 3, 5, 4, 6, and 4 days. The average is (3 + 5 + 4 + 6 + 4) ÷ 5 = 4.4 calendar days. The fastest order took 3 days; the slowest took 6 days. Their observed range is 3 days.
Only one order arrived on or before the promised date. On-time delivery rate = 1 ÷ 5 × 100 = 20%. The average delay is (0 + 2 + 1 + 3 + 1) ÷ 5 = 1.4 calendar days. The supplier is not meeting the stated three-day promise consistently in this small fictional sample.
A 4.4-day mean is an informative historical average, not a guaranteed future delivery date. The 6-day observation is a relevant warning for short-cover or essential items, but it is not a statistically established upper bound. The planned English Excel workbook will use these same five records.
How to Interpret Supplier Lead Time Results
| Metric | What it reveals | What it does not prove |
|---|---|---|
| Average actual lead time | Typical elapsed time in the recorded sample | That the next order will arrive on that exact day |
| Minimum and maximum | Best and slowest observed completed orders | Guaranteed bounds for future deliveries |
| Average delay | Typical difference from the stated promise | Why the delays occurred |
| On-time delivery rate | Share of completed orders received by commitment | That the ordered quantity and quality were correct |
| Delivery exceptions | Orders with shortages, partial receipts, or special conditions | A calculated in-full KPI unless quantities are recorded |
A supplier with a slightly longer but more predictable lead time may be easier to plan around than one with a lower average and frequent surprises. However, compare suppliers fairly: product mix, order size, origin, season and the number of completed observations can all affect results.
For broader supplier decisions, use our Supplier Evaluation Scorecard, which also considers quality, capacity, service, pricing and risk. Lead time is one criterion, not the entire supplier assessment.
How to Use Lead Time to Plan Purchases With Fewer Emergencies
Compare lead time with inventory coverage
Suppose a business uses 10 packaging units per day and has 45 usable units currently available, with no additional receipts scheduled. At that constant rate, the simple coverage is 45 ÷ 10 = 4.5 days. The observed supplier average is 4.4 days, but the slowest of the last five deliveries took six.
The 4.5-day coverage is uncomfortably close to the historical average and would not cover a repeat of the six-day lead time. The immediate action is to review the inventory position, any open orders and possible temporary supply options—not to assume that the average delivery will occur exactly on time.
Use the data in a reorder-point calculation
For a simple constant-demand illustration, demand during average lead time is 10 units/day × 4.4 days = 44 units. That is expected consumption during the historical average lead time, not the full reorder point. A complete reorder decision also considers safety stock, inventory already on order, commitments and supplier restrictions.
For the actual calculation of when and how much to reorder, use How to Plan Inventory Purchases. That guide covers demand, inventory position, safety stock, reorder points, purchase quantities and budget. The present article focuses on making the supplier lead-time input more credible.
Decide which improvement to test
- Confirm order cutoffs, shipping days and holiday schedules with the supplier.
- Issue purchase orders earlier for critical items when observed delivery time warrants it.
- Ask for earlier warning when the supplier anticipates missing a commitment.
- Review alternate sources or backup quantities for items that can stop operations.
- Recheck minimum order quantities (MOQs), case packs, freight costs and working-capital implications before increasing inventory.
- Measure again after operational changes; do not assume a policy change automatically improves supplier performance.
Supplier Lead Time vs. Purchase Planning and OTIF
| Concept | Main question | Best use |
|---|---|---|
| Supplier lead time | How many days did the replenishment take? | Measure delivery duration and variability |
| Purchase planning | What, when and how much should we order? | Combine lead time with demand, stock and budget |
| On-time delivery | Did the order arrive by the commitment date? | Measure schedule reliability |
| OTIF | Did it arrive both on time and in full? | Assess combined delivery timing and completeness |
The source workbook records a delivery-issue category, but dates alone do not calculate an independently verified in-full rate. To evaluate complete deliveries with quantity-based criteria, use our separate OTIF Formula and Excel Tracker. Avoid presenting an on-time result as if it also proved every ordered unit arrived.
Common Mistakes When Measuring Supplier Lead Time
- Using the quoted lead time as the actual result. A promise is a benchmark; actual receipt is the measurement.
- Counting shipping confirmation as receipt. Goods still in transit or awaiting required inspection are not yet available to use.
- Mixing business days with calendar days. A Friday-to-Monday delivery is three calendar days, not one business day.
- Combining different product types. Local consumables and imported equipment may have different replenishment patterns.
- Treating partial orders as complete. Set a consistent policy and document shortages rather than assuming the date proves completeness.
- Counting unfinished orders as zero-day lead time. Keep them in an open-order follow-up list until receipt is confirmed.
- Ignoring late deliveries after re-promising. Preserve the original promise for performance analysis and track revised dates separately.
- Making permanent decisions from a very small sample. Expand observation across relevant demand periods and seasons.
- Confusing lead time with a complete purchase plan. Delivery history informs planning but does not calculate order quantities or available cash by itself.
How to Use the Supplier Lead Time Excel Workbook
The companion Excel workbook follows four worksheets: Instructions, Glossary, Order Log, and Supplier Summary. Its workflow is to record suppliers, product categories, dates and delivery issues, then calculate promised lead time, actual lead time, delays and on-time results.
The English workbook will use the same Pine Creek Packaging example, with these four functions:
- 1. Instructions: workflow, date convention, editable fields, error messages and limitations.
- 2. Glossary: purchasing terms, lead-time definitions and formulas.
- 3. Order Log: supplier, order ID, product/category, order date, promised date, actual receipt, calculations, delivery issues and comments.
- 4. Supplier Summary: completed orders, average/minimum/maximum actual lead time, average delay and on-time share for each selected supplier.
The final adapted workbook must be checked for missing dates, invalid text or dates, duplicate order IDs, orders not yet received, and whether summaries exclude incomplete or invalid rows. It is a basic-to-intermediate tracker, not an automatic purchasing optimization engine, and it does not calculate safety stock or reorder quantities.
Download the Free Supplier Lead Time Excel Template
Use the free Supplier Lead Time Excel template to record purchase orders, compare promised and actual receipt dates, review supplier delays, and support more realistic replenishment decisions. It is intended for small retail, ecommerce and service businesses that want a repeatable purchasing record without specialized software.
Use this record to identify which suppliers meet their commitments and which need follow-up. The measured lead time supports purchasing decisions; it does not replace a complete inventory or safety-stock calculation.
Frequently Asked Questions
What is the difference between supplier lead time and delivery time?
Supplier lead time normally starts when the confirmed order is placed and ends at a defined receiving event. Shipping or transit time covers only part of that process. Agree on the boundaries used in your records.
Should I use calendar days or business days?
Either convention may be appropriate if consistently defined, but do not mix them. The example and simple date subtraction in this article use calendar days. Supplier shipping schedules and warehouse receiving hours may require a more detailed business-calendar calculation.
How many completed orders are enough for a useful average?
Five comparable completed orders can provide an initial picture, not a statistically reliable guarantee. Critical or seasonal items need more observations, and open orders should not be silently counted as completed.
Should I use average or maximum lead time when replenishing?
Use an assumption appropriate to the item’s shortage risk, demand variation and supplier reliability. The average describes observed central tendency; the maximum is only the highest value in your sample. Neither is a universal service-level guarantee.
Does on-time delivery mean the order arrived in full?
No. Timeliness and completeness are separate criteria. An on-time partial shipment may still disrupt operations; quantity verification belongs in your receiving process or an OTIF analysis.
Does this Excel template calculate reorder points or safety stock?
No. Its purpose is to measure supplier delivery history and summarize performance. Use the inventory purchase planning guide to combine a measured lead time with demand, inventory position and safety stock.
Sources and Further Reading
- Oracle Inventory — Reorder Point Planning. Demand during replenishment lead time, safety stock and order-point methodology.
- Oracle NetSuite — Vendor Purchase Orders Overview. Purchase-order dates, expected receipt dates and late-delivery data.
- SAP — Time-Based Planning with Delivery Cycles. How supplier delivery calendars affect replenishment.
- SAP — On-Time Delivery Performance. Committed versus actual receipt dates in supplier-performance scoring.
- ASCM — Safety Stock and Lead-Time Variability. Why variations in replenishment time matter for inventory protection.
Discover more from
Subscribe to get the latest posts sent to your email.
