VSM 5 Steps of Value Stream Mapping 【Excel Template Practice】

(Duration: 5:06)


DOWNLOAD  ← Click this to download the “Value Stream Mapping” template file.


<< Related Videos >>


Hi, this is Mike Negami, Lean Sigma Black Belt.


We’ll practice how to draw a Value Stream Mapping

that Toyota Production System created, using an Excel template.  You can download this template by clicking this.


DOWNLOAD  ← Click this to download the Value Stream Mapping template file.


This is the template. It uses Macro, so click these buttons after downloading the file.  There are 12 hyperlinks here. Clicking each link makes a respective shape that is used in Value Stream Mapping for non-manufacturing processes.


(Click the image below to enlarge the image.)

VSM in Eng


For example, click here: Object Flow Icon, Information Flow Icon and Process Step Icon.  Drag them to draw a Map to describe your process.


However, before drawing a Value Stream Map, you should complete a SIPOC Analysis on your process. I talked about how to make a SIPOC Analysis in the prior video. Please watch that too.


<< Related Videos >>


This is a result of the SIPOC Analysis. You can make a list of objects and information that come into and out of each process step.




Let’s start drawing a Value Stream Map.


First, make all process step icons.

Click this link, “Process Step”.   Type a department name in the upper square and its process procedure in the square below.  Make all process steps icon and it will look like this.


VSM with only process boxes


Traditionally we put the 1st step in the upper-left corner and lay out the other steps counter-clock wise from it, but since you’ll change the arrangement as you continue, you should not focus on appearance until the end.


Next, draw items before and after each step.

This is a part of our SIPOC diagram.  The Supplier is your customer and the Customer is your Receiving Department.


Since both are not shown in the following process steps, make their icons.  Click here, on the Customer Icon and use the Department Icon for the Receiving Department and type its name on the icon.


The inputs from your customer are “Returned Products” and the other inputs are all information, so you need object flow and information flow icons.


Excel tips:

  • Drag only an edge of the arrow and move it to another shape, then black points will appear on the shape.  If you release your mouse on one of the black points, it turns into a green point.  Now if you move the shape, the arrow will move with it.


  • Another tip is this:  Press the Ctrl key on your keyboard.  While pressing it, drag and drop a shape.  You can copy the shape very easily.  Connect it to the box. Don’t focus on appearance so much here yet.


The outputs from this step are object flow and information flow icons.  I’ll make and connect them.  Repeat this on all of the following process steps.  It will look like this.


VSM with process boxes and flows


Finalize all the shapes’ layout.

We’ll put the names of inputs and outputs, but before that, it’s better to finalize all the shapes’ layout, arrange them to not overlap each other’s arrows as much as you can.


Here is the 3rd Excel tip for today.

  • While pressing the control key on your keyboard, click multiple shapes, then you can move them together.


This is the completion of our layout.  You can move overlapped arrows little by little, by pressing arrow keys on your keyboard.

VSM with layout completed

Lastly, make names for objects and information items.

An input from the customer is “Returned Products”.  Click “Textbox” and type it.  Then put it around here.  The rest of the inputs are all information, so put them in another textbox.


Repeat this on all outputs and inputs and here is the final completion of Value Stream Mapping.




Let me summarize all procedures:


  1. Conduct a SIPOC Analysis.
  2. Make all process step icons.
  3. Make all object and information flows and connect them to process step boxes.
  4. Complete the whole layout.
  5. Put all object and information names in their textboxes.


We practiced how to draw a Value Stream Map today.  Please practice and master Value Stream Mapping using this template.  Thank you very much for viewing.


Related posts: