The current-state data sheet for value stream mapping
The data capture that has to be done once before the VSM workshop: cycle time, changeover, inventory and availability per process step. It yields takt time, lead time and process cycle efficiency.
Rows start with example values — edit, delete or add steps.
| Step | Cycle time (s) | Changeover (min) | Operators | Availability (%) | Inventory before (pcs) |
|---|
The sheet stays on your screen. If you ask, we review the captured data and flag what to watch for when mapping the current state.
The email opens in your own mail client with the captured data. Calculated takt, lead time and PCE are not included.
What this sheet is for
Data collection is the biggest time sink in a VSM workshop. With these five or six figures per step ready in advance, the map can be drawn in half a day.
Takt time is the customer rhythm. Any step whose cycle time exceeds takt is a constraint: either add capacity or cut the cycle time.
In discrete manufacturing a PCE above 25% is world class. A typical starting point is 1–5%, which is not a fault but the room for improvement.
How it is calculated
Takt time = net available time × 60 ÷ daily demand Value-adding = Σ cycle time (s) Lead time = Σ (inventory before ÷ daily demand) [days] PCE = value-adding time ÷ (lead time × available time × 60)
Inventory days follow from Little’s law: the pieces waiting before a step are consumed at the daily demand rate. The calculation applies to one product family and one shift pattern; with multiple shifts, sum the net available time.
This tool is a preparation sheet and does not replace on-site observation. Fill the cycle times with measured values, not standard times.
Just B · info@just-b-ltd.com · Lean overview · Waste calculator