SigmaFlow VSM Built-in Calculations

Standardized formulas with built-in fields and calculations enhance value stream ease-of-use and lower the required level of training.

Sigma Value for Defect (No Shift)
Sigma value for Defect with no shift

Sigma Value for Defect (With Yield % to Takt Time)
Sigma value for Defect with 1.5 shift

Yield % to Takt Time
If Average Cycle Time = User Entered, then (Yield % to Takt Time = 100%).
If Average Cycle Time is "Calculated", then this value comes from Data Collection Sheet.

Six Sigma Projected (MAD) Cycle Time
Six Sigma Projected Mean Average Deviation Cycle Time. Calculated using statistical methods.

Effective Six Sigma Projected (MAD) Cycle Time
Effective Six Sigma Projected Mean Average Deviation Cycle Time while taking defect, operators, machines, and changeovers into account. Calculated using the following formula = (Six Sigma Projected (MAD) Cycle Time) / ((1 - Average Defect (DPU) % ) x (Total # of Operators x Average Operator Availability %) x (# of Machines x Average Machine Availability %)) + (Changeover Time (CO) / Process Batch Size)

Process Step Cycle Time Score (Six Sigma)
Good/Bad score. Calculated using the following formula.
IF (Effective Six Sigma Projected (MAD) Cycle Time) <= Takt Time, then "Good" ELSE "Constraint)

Sigma Value for Cycle Time (No Shift)
Calculated using statistical methods with no shift

Sigma Value for Cycle Time (With 1.5 Shift)
Calculated using statistical methods with 1.5 shift

Effective Cycle Time (ECT)
Greater of "Average Cycle Time" and "Total NVA Time") /((1-Average Defect (DPU) % ) x (Total # of Operators x Average Operator Availability%) x (Total # of Machines x Average Machine Availability %))] + [Changeover Time (CO)/Process Batch Size]

SigmaFlow VSM's value stream mapping calculations will consistently be deployed throughout the enterprise, allowing users to focus on value-add activities as opposed to spending time building spreadsheets.