Value Stream Mapping (VSM) Calculator

Large View

Need to calculate the basic VSM data collected during your VSM session? The VSM Calculation Excel Template will save you time!

This template was developed as a tool to support Lean Six Sigma Black Belt teams conducting Values Stream Mappings.

It includes Cycle time, Value Added Time, Business Value Added Time, Non Value Added Time, Process Cycle Efficiency (PCE), TAKT time, Average Work in Progress (WIP), Process Value, FTEs and Labor Costs.

Provided is an instruction sheet, complete with the developer’s contact information. Aside from the working template is a completed template to use as a sample illustration. It includes the associated graphs generated from the template data.

To learn more on Value Stream Mapping, look for our Reference Guide and e-book