TEMPLATESVSMFree Excel (.xlsx) download

Value Stream Map Template and Symbol Legend

A data sheet for a current-state value stream map, plus a legend of the common symbols to draw it with. Enter each process step and the inventory in front of it, and the sheet works out takt time, inventory days, total lead time, processing time and process cycle efficiency.

Who this template is for

Manufacturing and industrial engineers, lean leads and supervisors mapping one product family from raw material to shipping, usually as a small cross-functional team walking the floor.

When to use it

Standards it supports

How to use this template

  1. Pick one product family — choose parts that share most process steps, and get daily customer demand and available working time.
  2. Walk the flow — start at shipping and walk upstream, recording each process step and counting the inventory in front of it.
  3. Collect process data — for each step, time the cycle, note changeover time, uptime and operators. Use what you observe, not the routing.
  4. Fill the sheet — enter the data; inventory days, takt comparison, lead time and process cycle efficiency calculate.
  5. Draw the map — sketch the map with the symbols below, put the sheet figures in the data boxes and the timeline, and mark kaizen bursts where the biggest waits are.

Tip: Draw the first map by hand on a long sheet of paper during the walk. Use the spreadsheet for the numbers, not as a replacement for going to see.

What's inside the template

1

Header

Product family, available working time per day, customer demand per day, mapped by and date

2

Process steps

Step number, name, cycle time, changeover, uptime and operators

3

Inventory

Units waiting before each step, converted to days of demand

4

Takt check

Each cycle time compared with takt time, with steps over takt highlighted

5

Timeline

Total lead time, total processing time, process cycle efficiency and operators

Value stream map symbols

These are the symbols most value stream maps use. The drawings are simplified; what matters is that everyone on the team reads them the same way.

SymbolNameWhat it shows
Supplier or customerAn outside company: the supplier on the upper left, the customer on the upper right.
Process boxOne step where material flows continuously. A new box starts wherever inventory builds up.
Data boxSits under a process box: cycle time, changeover, uptime, operators.
InventoryMaterial waiting between steps, with the count and the days it represents.
Push arrowMaterial moved to the next step on a schedule, whether the next step needs it or not.
SupermarketA controlled stock the downstream step pulls from, refilled by the upstream step.
FIFO laneA capped queue between steps, worked first in, first out.
ShipmentA truck delivery to or from the plant, with its frequency.
Manual information flowA paper schedule, traveler or verbal instruction.
Electronic information flowOrders, forecasts or schedules sent through a system or EDI.
OperatorPeople at a step; write the head count next to it.
Kaizen burstAn improvement idea placed where the problem is on the map.
TimelineThe ladder along the bottom: waiting time in days on the upper rungs, processing time in seconds on the lower ones.

Example: a completed template

Example Current-state data for a turned pin family at Example Precision Co., a fictional machine shop. One shift with 27,000 s (7.5 h) of available time and a demand of 600 pins per day. Every figure is invented for illustration.

Process steps

#StepC/T (s)C/O (min)UptimeInventory beforeInventory daysvs takt
1Saw cut181595%1,8003.0Within takt
2CNC turning484585%1,2002.0Over takt
3Deburr300100%9001.5Within takt
4Inspect and pack250100%6001.0Within takt
5Ship (finished goods)———1,5002.5—

Timeline

Takt time45 s
Total lead time10.0 days
Total processing time121 s
Process cycle efficiency0.045%
Steps over takt1 (CNC turning)

The math in this Example

How to fill in each field

FieldWhat to enterExample
Available working time per day (s)Shift time minus breaks and planned stops, in seconds, for all shifts that run.27000
Customer demand per dayAverage daily demand for the whole product family over the planning period.600
Cycle time (s)Observed time between parts leaving the step, timed on the floor.48
Changeover (min)Time from the last good part of one job to the first good part of the next.45
Uptime (%)Share of available time the step can actually run.85
Inventory before stepUnits counted waiting in front of the step on the day of the walk. Count, do not estimate from the system.1200
Inventory days (calculated)Inventory ÷ daily demand: how long a new part waits there.2.0
vs takt (calculated)Flags steps whose cycle time is longer than takt. These limit flow.Over takt

Common mistakes

Frequently asked questions

What is a value stream map?

A one-page picture of how material and information flow for one product family, from supplier to customer, with a timeline that separates waiting time from processing time.

Why is process cycle efficiency so low?

Because parts spend days waiting and only seconds being worked on. Values well under 1% are common in batch production. The low figure shows where to look, not that the plant is failing.

How is inventory converted to days?

Divide the units waiting by the daily customer demand. 1,200 parts with a demand of 600 per day is 2 days of waiting for a new part.

Should I map current state or future state first?

Current state first, from the floor. The future state is designed from what the current-state map reveals, then turned into an action plan.

Do I need special software?

No. Paper and pencil on the walk, then this sheet for the numbers, is enough for most maps. Software helps when you maintain many maps.

See also

COPLAIN AI PLATFORM

Generate yours automatically from your existing docs

Coplain writes the standard work for your future-state value stream, so the improvements from the map stick on the floor.

Generate yours automatically with Coplain →

Related Tools & Templates