Value Added Flow Analysis Template for Excel

Is there a significant amount of "wait" or "idle" time in the process that can be eliminated? Use Value Added Flow Analysis to find out.

value added flow analysis excel

To Use this QI Macros Template:

Click on QI Macros menu and then Lean Tools, then select the Value Added Flow Analysis template.

  1. Decide if this is an action, a decision or is an arrow (delay)/requires movement.
  2. Next, input how long the action takes in column B. The cumulative time the task takes is calculated in Column C.
  3. Does this add to your product or service value? Input "Yes" or "No" in Column D.
  4. And does this change the product or service in some way? Input "Yes" or "No" in Column E.
  5. Lastly, is this action, decision or movement rework or is it correctly accomplished the first time?

Review Your Process and Ask These Questions

Are there rework loops in your process? Can they be eliminated? 

Are there an obvious ways to simplify the process? Can you eliminate bureaucracy in any way?

If there are rework loops in your process, is there a way to reduce the number of times they are invoked?

Check all activities, decisions, or arrows (movement) for non-valued added work:

  • Does the customer care if this activity, decision, or movement is done? If not, can you eliminate this step? 
  • Does this activity change the product or service physically? If not, can you eliminate this step?
  • Is this step essential to doing it "right the first time" (not a rework loop)? If not, can you eliminate this step?

Other Popular Lean Tools in the QI Macros

To create a Value Added Flow Analysis using QI Macros...
Try It Now!