TEMPLATE
Value stream map:
Excel template
Download the template
Use this template to capture one product family from the first process to the last and record cycle time, inventory and information flow separately.
Excel calculates inventory coverage in working days from inventory and daily demand and totals cycle time and value-added time in seconds per part. The workbook is a data collection sheet; you still draw the map with symbols on paper or in a drawing tool.
What is in the template:
Current-state process sequence with cycle time and inventory before each process
Inventory coverage from inventory and daily demand, calculated by formula
Cycle time, value-added time and coverage in separate units
Information flow, future state and actions, plus a filled example
Who it is for
Who the value stream map template is for
The template is for lean managers, production managers and planners who want to capture a product family from the first process to the last. It serves as a data collection sheet on the shop floor; you draw the value stream map afterwards.
How to work with the value stream map template
- 1
Capture the current state
Enter cycle time and inventory before each process as you find them on the shop floor.
- 2
Calculate coverage
Excel calculates inventory coverage in working days from inventory and daily demand and totals cycle time and value-added time.
- 3
Derive the future state
Record information flow, future state and actions.
What the value stream map shows
Waiting time, not processing time
A part is usually processed for only a small share of its lead time and waits in inventory for the rest. Coverage in days makes that difference visible.
Separate units prevent calculation errors
Cycle time is in seconds, coverage in working days. Mixing both in one column gets the lead time wrong.
Current state first, then future state
The future state only convinces if the current state was captured on site. Walk the value stream backwards from the customer.
Further reading
Download the value stream map template
Fill in the short form and you receive the download right after.