Hi, this is Mike Negami, Lean Sigma Black Belt. In this episode, we’ll practice how
to draw a Value Stream Map that Toyota Production System created, using an Excel template. You
can download this template from my blog site: econoshift.com.
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. 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.
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. You can make a Value Stream Map by following
the SIPOC Diagram. 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. 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 the 1st 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. This is an Excel tip: 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. 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 Ctrl 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. 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.