Value Stream Maps are typically designed to flow horizontally left to right. When a process is complex it becomes difficult to view the whole process: it may require several pages and this makes difficult to see the total picture.

Making the VSM vertically allows us to visualize complex processes in a single page. 

Another common practice is to map the process by sticking post-its on a wall or large wrapping paper. This has the advantage of simplicity but it creates some inconveniences. It becomes impractical to save all the work done to continue working on it later on. It is also difficult to communicate to others: photos are difficult to read. If you ask other people, not present in the VSM exercise, to give their input they can not modify the work you have done.

VSM directly built in a spread sheet in the cloud (Google Drive)

You can draw your VSM directly using Google Spread Sheets in Google Drive and give write access to your document to all participants in the team and it will take shorter to build the VSM than if you have to write and stick the post-its. You can even have team members participating from remote locations. 

The first step is to go to Gemba: the team has a good look at what is going on and then they gather in a room where the VSM being built is projected on the wall (large screen if possible). All participants write the process step descriptions with their portables or smart phones into the spread sheet in Google drive that is visible on the wall. In this group exercise it is easy to make changes in the sequence, insert new steps, etc. At the end of this process we have a workable VSM agreed to by all participants which represents the current state as seen in Gemba.

After the current VSM is concluded we give write access to all process participants including those who were not present in its elaboration, in this way they can make modifications to make sure the VSM reflects what is really going on in Gemba. We might find out that we have more than one process, for instance the night shift is doing it differently. Google Drive keeps track of who has made what modifications.

We also give read only access to the VSM in the cloud to other people and plot an A1 size copy to stick on the department or line wall for everyone to see. 

We keep backup copies of the different stages in the modifications to make sure we can go back to a previous version. 

I find it very useful to indicate who does what in the VSM instead of making another separate document. In order to do this we include participant swim lanes on the left which are easily filled while building the VSM. 

In the example above you can notice that the switchboard participates in the process on several occasions. 

Complex value streams

More complex VSMs with feedback loops can be done with Excel such as:

 

Download this VSM example:   Value Stream Map and Modeling

Share your VSM in the cloud with Microsoft's OnDrive

In a complex process as the one above Google Drive is not able to manage the graphic flow chart so it is best to use Microsoft's OneDrive:

In this case it will even be possible to run the simulator we will see later in the cloud.

Process times collection in Gemba

After we have agreed on the VSM flow (who does what and when) we need to go back to Gemba to collect process times and WIP data for each process step. If we use the Excel approach we can carry with us the VSM we have just produced in our smart phone or tablet and directly enter the numbers in our spread sheet. 

It is easy to share this work among all participants each taking care of a few process steps. 

They can all write simultaneously into our VSM in the cloud.

Excel VSM advantages:

  1. The team involved in the VSM exercise can be located in remote locations and can all share a spread sheet in the cloud with communication via Hangouts or Skype.
  2. To insure your VSM represents the current reality (hidden factory) rather than a theoretical process flow you need to validate your VSM with all other participants who were not in the room: line operators, suppliers, maintenance, etc. You can not start improving until you are certain of what the current reality is. 
  3. All the work done is not lost at the end of the meeting and it can be updated remotely at a later stage by all process participants
  4. You can easily keep track of the different versions of the VSM as you implement your improvements and you can even go back to a previous version if something goes wrong
  5. You can go to Gemba with your VSM on your tablet or smart phone and directly enter process times, WIP, etc. on your VSM in the cloud.
  6. Excel allows the addition of the process parameters for each process step by adding as many columns as required on the right:

·         Process time

·         Setup time

·         Cycle time

·         Work-In-Process waiting

VSMs with feedback loops and alternative routes

Complex processes require often feedback loops: repair failing items and test them again. These loops are an essential part of the VSM because they often become the bottleneck of the total process. 

When the process doesn’t have a single flow but there are several branches you need to estimate the proportion of items that will flow along each branch and this you can do by collecting data along a period of time.

Process times have variability so you will need to estimate not only their average values but also their standard deviations.

 

In this Repair process the average time it takes to receive a product is 2 min and its standard deviation 0.5 min.

20% of the products are under warranty so 80% will follow the “N” branch.

Average inter arrival time of products coming from the customer for repair is 5 min. This is the takt time the process has to comply with. 

 

Not all products go through all process steps, therefore we need to calculate % throughput for each step based on the % of products flowing along each branch.

Line staffing calculation 

In order to balance the line we need the right staffing on each process step to insure enough capacity to handle the product arrivals. This means that Cycle time  Inter arrival time (takt).

Cycle time  =  Average time   x   % Throughput  /  Staffing 

We can calculate the staffing (Full Time Equivalent) required for each step M4 – M13 with Solver

 To do this we calculate the total staff required in cell M1 just adding all the yellow cells in column M. This cell is what we want to minimize as long as we meet the requirements that all cycle times P4:P13  are below the inter arrival time in K3. 

 We are adding the constraint M4:M13 0.1. The proposed staffing by Solver in the yellow cells M4:M13 is:

Which gives a total staff of 13.6 (M1). This is a theoretical minimum which assumes all staff has all skills, which is not the case.

In cells D1 to H1 we obtain the compound for each process participant (some perform several operations) obtained from the column M.

If Receive and Coordinator can be combined we may have to round up the sum of the two from the 1.6 requirement to 2.0

Invoicing we round up from 1.8 to 2. Test from 2.9 to 3 and repair from 7.4 to 8. 

This manual rounding will lead us to this situation:

Where the total staff has increased from the theoretical 13.6 to 15 after considering the different skills required in the different steps.

This increase in the staffing has an effect on lowering the cycle of the steps affected below the takt time of 5 minutes.

Looking at the % Throughput column we notice that some steps only process 4% of the products to be repaired while test and repair have to process 123%. The reason for this is that only 80% pass the test OK the first time. This means 20% have to be tested a second time. Same with burn-in, where 10% fail and have to be retested.

Convert your VSM into a simulator 

So far we have not taken into account variability but we will do so by adding some additional columns to our VSM converting it into a simulator in our next article: How to convert your VSM into a simulator to experience variation