Recently I need to calculate the tolerance values I have come up with the following conclusions
Tolerance Value When Metric Is Increasing/Decreasing
Formula for Tolerance Calculation When Tolerance Type is Absolute
Upper Tolerance Value = Goal Value + Upper Tolerance
Lower Tolerance Value = Goal Value - Lower Tolerance
Example
Yellow Band lies between these Values
Goal Val Upp Tol Low Tol Upp Tol Val Low Tol Val
60 -5 10 55 50
60 0 10 60 50
60 5 0 65 60
60 5 10 65 50
Tolerance Value When Metric Is Increasing/Decreasing
Tolerance Type Percentage of Goal Value
Formulae for Tolerance Calculation When Tolerance Type is
=> Percentage of Goal Value
Upper Tolerance Value = Goal Value + ((Upper Tolerance/100) * Goal Value)
Lower Tolerance Value = Goal Value - ((Lower Tolerance/100) * Goal Value)
Example
Yellow Band lies between these Values
Goal Val Upp Tol % Low Tol% Upp Tol Val Low Tol Val
60 -5 10 57 54
60 0 10 60 54
60 5 0 63 60
60 10 -10 66 66
Regards
Ishaq
ishaqbaig (BOB member since 2009-03-28)