Skip to content
Shop | Excel tracker

Value Stream Data Sheet and Lead Time Calculator

Takt time and pitch, a data box per process with capacity check, inventory in days, the lead time ladder with chart, flow efficiency and a one page status.

Screenshot of the Value Stream Data Sheet and Lead Time Calculator workbook with example data
Example data from the workbook.

How it works

  1. Open 02 Setup. Enter the product family, the customer demand per day, the shift model and the pieces per container. Takt time and pitch calculate.
  2. After the walk, enter one row per process in 03 Data Boxes, in the order of the flow. The sheet checks every process against takt time and capacity.
  3. Enter the counted inventory in 04 Lead Time Ladder, one row per inventory point. Days, value, lead time and flow efficiency calculate.
  4. List what the map tells you in 05 Findings, with one action, an owner and a date per finding.
  5. Read 06 Status with the team and agree the target lead time.

Definitions used in the workbook

  • Takt time: Available seconds per day divided by customer demand per day.
  • C/T and P/T: C/T is the time between two pieces at the output of a process. P/T is the time one piece is worked on. They differ when machines run in parallel.
  • Inventory in days: Pieces divided by customer demand per day, at every point of the stream.
  • Lead time: Sum of all inventory days from raw material to finished goods.
  • Flow efficiency: Value-added time divided by lead time, both in working time.

Sheets in the workbook

  1. Start
  2. Setup
  3. Data Boxes
  4. Lead Time Ladder
  5. Findings
  6. Status

Who it is for

Production managers and lean coordinators who map the current state of one product family.

The method behind the numbers

This workbook is part of the Value Stream Mapping toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every two weeks.