Skip to content
LeanSuite

Free template

Updated

Lead time worksheet

Lead time is how long a product takes to get through the process, from a start point to an end point you choose, waiting included. On a value stream it is measured by counting the inventory in front of each step and dividing it by daily demand: 1,600 parts waiting in front of welding at 400 a day is 4 days. Add the waiting days and the cycle times and you have the production lead time. Set the value-added seconds against it and you get process cycle efficiency, which in batch production is usually a very small share of the lead time. Page 1 of this template is the worksheet: one row per step with the inventory, waiting days, cycle time, value-added time, batch size and changeover, a blank lead-time ladder and the sums. Page 2 traces one order from receipt to delivery by its dates, defines the four types of lead time and works an example. The Excel version does the arithmetic, shows the lead time so far and each step's share, names the biggest queue, charts the waiting days, and has an order trace sheet that averages each stage over many orders.

Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.

Page 1 of the lead time worksheetFields for product family, start and end point, daily demand and hours per day, a table with one row per process step for inventory, waiting days, cycle time, value-added time, batch size and changeover, a blank lead-time ladder and the formulas for lead time and process cycle efficiency.
Inventory in front of each stepWaiting daysCycle and value-added timeLead-time ladderProcess cycle efficiencyBiggest queueOrder traceWorked example
Filled-in Lead time worksheet: a steel bracket family, 400 a day
The same sheet filled in with the worked example (page 2 of the PDF, illustrative numbers). Open full size (opens the picture in a new tab)

When to use it

When to use a lead time worksheet

  • Before a value stream mapping session, to have measured numbers instead of guesses.
  • When customers wait weeks for a product that takes minutes to make.
  • To check whether a kaizen on one step shortened the whole lead time or only moved the queue.
  • To explain to sales or planning where quoted lead time goes.

How to fill it in

  1. 1

    Pick the product family and the two ends

    One family that shares most steps. Write down where the clock starts and stops, for example coil at receiving to shipped, and keep it the same next time.
  2. 2

    Get daily demand and the working hours

    Average units per day the customer takes over the coming weeks, and the hours worked per day. The hours turn seconds of cycle time into days.
  3. 3

    Count the inventory in one walk

    Walk upstream and count the units waiting in front of each step on the same day, including finished goods waiting to ship. A count taken over three days mixes up the queues.
  4. 4

    Write each step's cycle time and value-added time

    Cycle time from a time study or the machine. Value-added time is only the seconds that change the product in a way the customer pays for, so it is less than or equal to the cycle time.
  5. 5

    Add it up

    Waiting days = units ÷ daily demand. Production lead time = total waiting days + total cycle time ÷ (hours per day × 3,600). Process cycle efficiency = value-added seconds ÷ lead time in seconds.
  6. 6

    Trace a few real orders

    Take the dates from the paperwork of recent orders: received, released, started, finished, shipped, delivered. The order trace shows how much of the customer's wait is outside the shop floor.

A filled-in example

Illustrative, not a benchmark

An example: a steel bracket family, 400 a day, two 8-hour shifts (illustrative numbers).

Where the example's 17 days go

  • Before stamping (coil): 6 days
  • Before welding: 4 days
  • Before painting: 2.5 days
  • Before assembly: 1.5 days
  • Finished, before shipping: 3 days

Process cycle efficiency = value-added time ÷ lead time

  1. 110 s ÷ (17.0024 days × 57,600 s a day)= 0.011%

Of 17.0 days of production lead time, 6.0 are coil waiting before stamping, 4.0 before welding, 2.5 before painting, 1.5 before assembly and 3.0 finished goods before shipping. The four process steps take 137 seconds.

Almost all of the lead time is waiting. The 137 seconds of cycle time would not even show at this scale, so cutting the weld cycle would not move the lead time.
  • Waiting in front of each step: 2,400 coil-equivalents before stamping (6.0 days), 1,600 before welding (4.0), 1,000 before painting (2.5), 600 before assembly (1.5) and 1,200 finished brackets before shipping (3.0). Total 17.0 days.
  • Cycle times 2 + 45 + 30 + 60 = 137 s, value-added 2 + 38 + 20 + 50 = 110 s.
  • Production lead time = 17.0 days + 137 s ÷ 57,600 s a day = 17.00 days. Process cycle efficiency = 110 ÷ (17.0024 × 57,600) = 0.011%.
  • One order traced: received 1 September, released 3 September, started 7 September, finished 15 September, shipped 17 September, delivered 21 September. Customer lead time 20 days, 8 of them in production.

The coil (6.0 days) and the queue in front of welding (4.0 days) hold more than half of the lead time, so the first two projects were more frequent coil deliveries and a shorter changeover on the press that feeds welding. Cutting the 45-second weld cycle would not have moved the lead time at all.

To add up process, inspection, move and wait time for one unit, use the free Throughput time calculator.

Common mistakes

  • Adding up cycle times and calling it lead time

    137 seconds of work does not mean a 2-minute lead time. The days are in the queues, so count them.

  • Using last year's demand

    Waiting days depend on the demand you divide by. Use the rate for the coming weeks, or the numbers will not match what the floor sees.

  • Counting on different days

    Inventory moves. Count every queue in one walk, ideally at the same time of day as the last count.

  • Calling every second of cycle time value-added

    Loading, unloading, walking and checking are part of the cycle but add no value. Be strict or the efficiency figure means nothing.

Download the template

Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.

Run this template in LeanSuite

In LeanSuite video of each process step becomes a current-state value stream map: the inventory counted between steps is converted into days of WIP, lead time is computed from that WIP plus the cycle time at each process box, and process cycle efficiency is worked out from value-add time and total lead time.

See it in a 45-minute demo

FAQ

Lead time worksheet: common questions

  1. Count the units waiting in front of each step, divide each count by daily demand to get waiting days, and add them up with the cycle times converted to days. 1,600 parts in front of a step at 400 a day is 4 days of waiting.

  2. Customer lead time, from order to delivery; material lead time, from purchase order to material ready to use; production lead time, from the first step to the finished product; and cumulative lead time, the longest path to make the product from nothing, buying included.

  3. Value-added time divided by lead time, in the same units. For example, 110 seconds of value-added work in a 17-day lead time is 0.011%. A low figure is normal; it shows how much of the lead time is waiting.

  4. Cycle time is how often a step finishes a unit, in seconds or minutes. Lead time is how long one unit takes to get through the whole process, waiting included, and is usually counted in days.

  5. It is Little's Law: in a stable process the time a unit waits equals the units ahead of it divided by the rate they leave. It turns a pile you can count into days you can compare.

More free templates

All templates
Browse all 278 templates

Can't find the template you need?

Tell us what you're looking for. We'll make it and send it to your inbox, free.

A shift handover sheet, a red tag log, a changeover checklist for one machine: if your team uses it on the floor, ask.

By sending this form you agree to our Terms of Service and Privacy Policy.

Pass it on

We want LeanSuite to be the best place on the internet for lean help. If this was useful, send it to someone on your team or in your network who needs it.