DF CONSULTING
I fix problems.

Lean toolkit / 09

Value Stream Map Data

The numbers behind the map. Process time is what you pay people for; lead time is what the customer waits. The gap between them is the whole opportunity.

XLSX templatePDF template Entries stay in this browser

Walk the stream backwards from the customer and collect the data yourself. Cycle time is machine-to-machine on one piece. Inventory is what is actually sitting there right now, not what the system says.

Process cycle efficiency under 5% is normal for a first map and is not a failure — it is the size of the prize.


Value-adding time—days
Total lead time—days, door to door
Process cycle efficiency—value-add ÷ lead time
Inventory held—pieces across the stream

Lead time, drawn to scale

Process data

In the direction the product flows
#Process stepCycle (s) C/O (min)Uptime %Ops Inventory after (pcs)= days Notes
Totals00 00.00

Working on something harder than a worksheet?

Tools do not fix processes. People with a method do.

I am David Fowles. I have spent 25 years in nuclear operations, power generation field service, manufacturing quality and supply chain, and I build the capability to keep an improvement after I leave. If one of these sheets has shown you something you would rather not solve alone, say so.

Email me See what I do

david@df-consulting.net
Connecticut, United States