Value Stream Mapping Workbook

Setup + Stream Build

Enter the stream header, then add process steps and inventory in the order material moves. Drag a card by its handle to reorder, or use Up and Down. Every field feeds the map, the metrics, and the ranked opportunities. Leave a field blank and it drops out of the math instead of being assumed.

Stream Header

Demand + Available Time

Shifts

One row per shift the area operates. Paid minutes less breaks sets the operating hrs each shift carries. Steps then pick the shifts they run and the crew on each.

Steps + Inventory

No nodes yet. Add a process step or load the example stream.

Current State Map

Process boxes carry the data collected on the walk. Triangles carry inventory between steps. The ladder underneath runs high through wait and low through process time. Lead time is the whole ladder, value add is the low sections only.

Red box: load at or over 100% of demand, the constraint is marked • Amber box: 85 to 100% loaded, queue grows fast here • Navy box: capacity above demand • Red triangle count: days of supply over the target buffer • Drag any box or triangle to reorder the stream • Map scrolls sideways for long streams, print in landscape and fit to width • High sections: wait held in inventory, in hrs • Low sections: process time per unit, in hrs • cycle time is the time between good units coming off a step • changeover is the time from last good unit of one part to first good unit of the next

Stream Metrics

Every figure below shows its derivation. Verification status comes from the basis set on each node: observed on the floor, pulled from a system, or estimated.

Time + Flow

Step Capacity

Effective cycle time carries setup, downtime, speed, and defects. Capacity is good units per day on the shifts that step runs.

Where The Hours Go, Scheduled To Fully Productive

Each step starts from the hrs it is loaded and loses time in order: setup, then unplanned downtime, then speed, then defects. What is left is fully productive time, and that is what capacity comes from.

Labor By Shift

Crew comes from the shifts each step runs. Labor hrs required splits a step's work across the shifts it runs, weighted by the hrs each shift carries.

Inventory

Quality

Largest Areas Of Opportunity

Every line reads the same way: change one variable from what it is now to what it could be, and here is what the area gets. The target shown is the full gap, the floor or ceiling that variable can reach. Nothing here is assumed: if an input is missing, the line does not appear.

Wait, Change This To That

Capacity, Change This To That

Balance + Quality

Flow Read

Area Capacity Versus A Target

Enter the rate the area has to hit. The file compares it to what the area can run today, names every step that cannot hold that rate, and shows what each variable has to move to for that step to get there on its own.

Steps That Cannot Hold The Target

Every Step Against The Target

Each column is that variable moving on its own, with everything else held. Reaching the target usually takes two or three of them together, and the file shows what each one would have to do alone so the mix is a choice, not a guess.

Combine Streams + Shared Resource Load

One map answers what happens to one part family. It cannot tell you whether a machine several families share can carry all of them. Load two or more saved maps here, tell the file which steps are the same physical resource, agree on one set of numbers for that resource, and it adds the hrs every family puts on it.

Streams In The Library

Header Reconciliation

These have to agree before the hrs can be added. A stream on a different clock or a different demand window is not comparable, it is a second opinion.

Step To Resource Mapping

Two steps with the same name merge on their own, even across streams. That is right when it is one machine and wrong when two areas both call a step Pack. Check every merged row before reading the load, or use Keep resources separate by stream and merge only the ones you mean.

Every step from every stream gets a resource name. Two steps with the same resource name are treated as the same asset or the same team. Different families keep their own cycle time on that resource, that part is supposed to differ. Uptime, speed, first pass yield, and scheduled hrs belong to the resource, so those get one agreed value.

Agreed Numbers Per Resource

Blank uses the default shown. The default for scheduled hrs is the largest any stream claims, and for the loss numbers it is the hrs weighted average across the streams that use it. Where the streams disagree the row is flagged, and the flag stays until someone enters the agreed value.

Combined Load On Every Resource

What Each Stream Consumes

Answering The Objection

The objection is right about one thing and wrong about the other. It is right that a single map cannot size a shared machine, because it only carries one family's demand. It is wrong that this means the area cannot be modeled. The order of work is this:

  1. Map each family on its own. A family is a set of parts that run the same steps on the same equipment in roughly the same order. Two or three families usually cover most of the volume, and the rest gets carried as an other bucket with its own hrs.
  2. Give every step a resource name that matches the physical asset or team, not the local nickname. Two maps saying Mill 3 and Big Bridgeport are the same machine and have to end up on one line.
  3. Load the maps here and reconcile the header first: same shifts, same clock, same demand window, same unit.
  4. Agree the loss numbers per resource. The part carries the cycle time, the resource carries the uptime, the speed, the first pass yield, and the hrs it is scheduled.
  5. Read the combined load. The resource over 100 percent is what stops the mix, not the step someone complains about.
  6. Scale the mix. Change any stream's demand in the library and every resource reloads, which is what a schedule argument actually needs.

What this does not do is sequence jobs. It sizes whether the hrs exist across the whole mix. Sequencing is the scheduling system's job, and it cannot fix a resource that is short of hrs.

Reconciling Different Assumptions And Names

  • Name the resource by what it is on the floor: asset number, work center, or team. Nicknames go in the notes, not in the resource name.
  • One clock. Paid minutes, breaks, meetings, cleanup, and maintenance have to be the same on a shift that two maps both use. If one map says 7.08 hrs and another says 7.50 for the same shift, someone counted breaks and someone did not.
  • One demand window. All maps use the same weeks of demand, or the load is a comparison of different months.
  • Cycle time is allowed to differ by family. That is the whole point of a mix. Uptime, speed, first pass yield, and scheduled hrs are not allowed to differ on the same resource.
  • Where they do differ, the file shows every value and who claimed it. Pick one and enter it as the agreed number, or go back to the floor and settle it.
  • Watch the basis. A resource where one map says observed and another says estimate carries the weaker of the two into every number built on it.
  • No double counting. If two maps both include a shared inspection step, that step appears once per family with its own demand, which is correct. If the same family appears in two maps, remove one.
  • Changeover belongs to the resource across the mix. More families on one machine means more changeovers, and the file adds those hrs per family as entered.

Material Flow Actions + Modeled Effect

Every action names the one variable it moves, shows what that variable reads today, takes the value you want it set to, and returns what the area gets. Change changeover at Mill from 45 min to 20 min and the file says how many more units per day that is. Blank target means nothing is modeled.

Actions come from the Material Flow and Work In Process Playbook, items 1 to 31, in the playbook's own priority order. Items that the map can size appear against the node their pool belongs to. Items that hold gains or feed data appear in the reference table with no number attached, and item 24 sits out because it carries equipment moves. Add playbook item covers anything the area runs that is not on the list.

Modeled Effect On The Area

Change This, Get That, Ranked

Actions By Node

Nodes are ordered by the size of the gap their own data shows. The top three open by default, the rest expand on click, and everything opens when the page prints.

Playbook Coverage

Release and scheduling items, 1, 2, 3, 19, 21, and 25, appear on every buffer because a release rule acts on every queue. Set the target where the class expects the effect to land, not on all of them at once.
Actions on the same variable stack in playbook order. The Now column shows what the variable reads after the actions above it, so two actions cannot claim the same hrs twice. Targets past the floor are held at the floor: a buffer stops at the target days entered or the batch the adjacent step runs, uptime, speed, and first pass yield stop at 100%, and loading hrs stop at every shift covered.
Capital projects are out of scope here. If an action needs equipment, tooling spend, or facility work, it does not belong in this list.

Future State Model

Set targets, see the recomputed stream. Targets left blank hold at current. This models the arithmetic only: the plan to hit the target is separate work.

Current Versus Future

Buffer Detail

Future State Questions

  1. What is takt time for this family, and does the stream run to it
  2. Does the stream build to ship direct, or to a finished goods supermarket
  3. Where can continuous flow run, one piece or small transfer batch, with no buffer between steps
  4. Where does flow have to stop, and a supermarket pull set the release instead
  5. Which single step is the pacemaker, the one point scheduled
  6. How is mix leveled at the pacemaker
  7. What increment of work is released, and how often the release is checked
  8. What process improvements have to land for the design to hold: changeover, uptime, yield, staffing, layout
Scheduling runs on expected times, actuals with a challenge. T1 stays the work content target and the gap view runs alongside. A future state that only holds if T1 is achieved is not a schedule, it is a wish.

How To Build A Value Stream Map

A value stream map is one page that shows material flow, information flow, and the time a part spends in the stream, for one part family, door to door. It is drawn on the floor with a pencil and a stopwatch, then entered here.

Step 1: Pick The Part Family

Step 2: Set The Scope

Step 3: Walk The Flow Backward

Step 4: Draw The Boxes And Triangles

Step 5: Add The Information Flow

Step 6: Draw The Timeline

Step 7: Read It Before You Fix It

Step 8: Design The Future State And The Plan

Why The Map Works

  • It puts wait and work on the same page. Most streams are 1 to 5 percent value add, so the answer is almost never to work faster.
  • It sizes problems in hrs instead of opinions. The biggest triangle wins the argument.
  • It shows the whole part path, so local improvements that move a problem downstream get caught before they are funded.
  • It gives one shared picture across production, planning, quality, and engineering, built from the same walk.
  • It exposes the schedule mechanism. Push, pull, or verbal shows up in the information flow, not the material flow.
  • It sets a baseline the future state gets measured against, in lead time, process cycle efficiency, and inventory days.
  • It is fast. A door to door map on one family is a day or two of work, not a quarter.
What the map is not. It is not a layout, not a routing, not a capacity model, and not a substitute for a time study on a single operation. It sizes the stream and points at where the detail work goes.

Data To Collect

Collect what the map computes with. Each field below lists where it comes from and what it drives. Set the basis on every node so the verification status travels with the number.

Stream Level

FieldDefinitionSourceDrives
Demand per dayGood units the customer pulls per work day for this familyFirm orders, shipment history, forecast for the window mappedTakt • inventory days of supply • capacity gap
ShiftsOne row per shift the area operates, paid minutes less breaksShift schedulePlant operating time • takt • wait clock
Shifts run at a stepWhich shifts that step is manned and runningStaffing plan, observationOperating hrs at the step • capacity • load
Crew per shiftOperators on that step during that shiftObservation, staffing planLabor hrs available and required by shift
Work days per monthDays the stream runsPlant calendarMonthly demand to daily demand
Wait clock basisWhether wait is counted on work hrs or on a 24 hr calendarDecision, stated once and heldLead time • process cycle efficiency
Target buffer daysDays of supply a buffer is allowed to holdPolicy or the future state designOpportunity sizing

Process Step

FieldDefinitionSourceDrives
Cycle timeTime between good units coming off the step, per unit, at current staffingStopwatch on the floor, several units, not oneConstraint • capacity • process time on the ladder
Value add timePortion of cycle time that changes the part toward what the customer boughtObservation, split from cycle timeProcess cycle efficiency
Changeover timeLast good unit of the prior part to first good unit of the nextStopwatch across a real changeoverAvailable time lost • batch size pressure
Changeovers per dayHow many times the step changes over in a dayObservation, run historyHrs per day lost to setup
UptimePercent of scheduled time the step is able to runDowntime logs, transaction history, observationEffective cycle time • capacity • loss hrs
First pass yieldPercent of units through the step correct the first time, no reworkInspection records, scrap and rework countsRolled throughput yield • effective cycle time • rework hrs
OperatorsDefault crew on the step, used for any shift with no crew enteredObservationLabor content • staffing sizing
Batch size, or every part every intervalUnits run before the step changes to another part, or the interval between runs of the same partRun historyMinimum inventory the batch forces
BasisObserved, system, or estimateSet by the mapperVerification status carried into every figure

Inventory Point

FieldDefinitionSourceDrives
Count on handUnits sitting at that point on the day of the walkPhysical count on the walk, system stock as a cross checkDays of supply • wait hrs • lead time
Days of supplyCount on hand / demand per dayComputedRanking of the largest holds
Wait hrs, directMeasured dwell where a count is not meaningful, cure, cool, test soak, transitObservation or process specLead time on non queue waits
Reason heldWhy material sits: batch, changeover, quality hold, staffing, transport, awaiting paperworkAsk at the pointWhich countermeasure fits

What Varies The Productive Hours In A Day

Every factor below moves the hrs a step can actually produce in. The model runs them in order: calendar, then schedule, then planned stops, then setup, then downtime, then speed, then defects. Enter each one where it belongs and the loss shows up once, not twice.

LayerWhat eats the hrsWhere it goes in this fileSource
CalendarTotal clock, 24 hrs a day, 168 hrs a week. Nothing is lost yetFixedCalendar
ScheduleShifts not staffed • days not run in the week • weekends • holidays and shutdowns • no orders releasedShift rows: paid minutes, days per week, and how many shift rows existShift schedule, plant calendar
Planned stopsBreaks and meal • shift start huddle • pass-down at handoff • cleanup and 5S • planned maintenance window • training • safety stand-down • inventory countsShift rows: break, meetings, cleanup, maintenance minutes, and the break covered flag when relief keeps the asset runningShift routine, observation, maintenance plan
SetupChangeover, tool and fixture changes, first article and warm-up before the runStep fields: changeover time and changeovers per day. Setup comes off loading time before uptime is appliedStopwatch across a real changeover
Unplanned downtimeBreakdowns • jams • material starvation • blocked downstream • waiting on inspection, paperwork, crane, or forklift • waiting on an operatorUptime percent, per step and per shiftDowntime logs, transactions, observation
SpeedRunning under rate • minor stops under the logging threshold • learning curve on new operators • mixed model rate differencesSpeed percent, per step and per shiftCounts against cycle time over a run
DefectsStartup rejects • in process defects • rework loopsFirst pass yield percent, per step and per shiftInspection records, scrap and rework counts
LaborAbsence and call outs • vacation • training hours • indirect work pulled off the job • break relief coverage • crew size and qualification • overtime fatigue • new hire rampAttendance percent on the shift row, crew per shift on the step, and the Labor By Shift tableTime and attendance, staffing plan, skills matrix

Equipment effectiveness is availability times speed times quality, measured inside the hrs the step is scheduled to run. Total effective equipment performance is that same number times the share of the calendar the area is scheduled at all, which is what shows whether the answer is a better asset or more scheduled hrs. Both are on the Metrics tab.

Times entered here are expected times, what the part actually experiences. T1 is work content and the target, it is not the schedule input and not the performance expectation. Map on observed, keep the T1 gap view alongside.

Terms In Plain Words

TermWhat it means
Value stream mapOne page showing the path one part family takes, the time it spends working, and the time it spends waiting
Cycle timeThe time between good units coming off a step
ChangeoverLast good unit of one part to first good unit of the next
TaktThe customer pace. One unit has to finish this often to keep up with demand
Lead timeTotal time a part is in the area, waiting plus working
Value add timeThe part of the time that changes the part toward what the customer bought
Process cycle efficiencyValue add time as a share of lead time. Most areas land between 1 and 5 percent
Days of supplyUnits sitting at a point divided by daily demand. How many days that pile would cover
Work in processEverything started and not yet finished
UptimeShare of scheduled time the step is able to run
Speed, percent of rateHow fast it runs against the rate it should run, counting small stops and slow running
First pass yieldShare of units correct the first time, no rework
Rolled throughput yieldFirst pass yield of every step multiplied together, the odds a unit clears the whole stream clean
Equipment effectivenessUptime times speed times quality, measured inside the hrs the step is scheduled to run
Total effective equipment performanceEquipment effectiveness times the share of the calendar the area is scheduled at all
Scheduled running hoursPaid hrs less breaks, meetings, cleanup, and planned maintenance. The hrs the asset is available to run
Fully productive hoursWhat is left after changeover, downtime, slow running, and defects. Capacity comes from this
ConstraintThe step with the highest load, the one that sets what the area can ship
LoadDemand divided by capacity at a step. Over 100 percent means it cannot keep up
Full time equivalentHours expressed as a share of one person working a full shift
Pull signalA card, bin, or space that tells the step before it to make more, instead of a schedule pushing work in
PacemakerThe one step that gets a schedule. Everything before it refills, everything after it runs oldest first
Little's lawTime in the area equals work in process divided by units finished per day
Improvement is by part. A stream number that averages several parts hides the part that is actually late. If the family spread is wide, map the driver part and note the spread.

Reading The Map

Six reads, in order. Each one has a number behind it and a countermeasure family that fits. The Opportunities tab runs these against the entered data.

Read 1: Wait Versus Work

Read 2: The Constraint

Read 3: The Largest Triangles

Read 4: Balance

Read 5: Quality

Read 6: Variability And Load

Little's Law Check

Lead time equals work in process divided by throughput. Count work in process in the stream, divide by units shipped per day, and compare to the lead time the ladder produced. If the two disagree by more than a small margin, either the count missed material or the demand rate is wrong. Fix the disagreement before the map goes anywhere.

Common Errors

  • Routing standards entered as observed times. The map then describes a plant that does not exist.
  • Inventory taken from a system without a physical count. Floor stock, staging, and rework cages get missed.
  • Averaging several parts into one map, then chasing a number no single part has.
  • Mixing wait clocks. Some triangles on calendar hrs, others on work hrs, process cycle efficiency meaningless.
  • Mapping every part number in the shop. One family per map.
  • Jumping to the future state during the walk, before the current state numbers stand up.
  • Naming the map's constraint from memory instead of from effective cycle time.
  • Treating the map as the deliverable. The deliverable is the plan, the owners, and the remap.

Class Guide

How to run this file in a session. Everything is offline. No install, no account, no network.

Using The File

Session Flow, Half Day

TimeBlockOutput
20 minWhy the map, wait versus workClass states process cycle efficiency in their own words
20 minFamily selection and scopeOne family named, start and end point written
30 minData box fields and how to time themEveryone can define cycle time, changeover, uptime, first pass yield
60 minFloor walk, backward, counts and timesPencil map with every triangle counted
30 minEnter into this fileCurrent state with basis set on every node
30 minRead the map, six readsTop three opportunities in hrs
40 minMaterial flow actions, capture by nodeAction list with the hrs each one drives
40 minFuture state questions and targetsModeled lead time and process cycle efficiency, gap list
20 minPlan outItems with owner, date, number to move

Exercise Rules

Facilitator Checks

Fields are entered by the class. Nothing in this file is filled in from assumption. Blank stays blank and drops out of the math.