Measure Phase Templates and Worksheets Input Measures Supplier

Measure Phase Templates and Worksheets

Input Measures Supplier Leading Indicators/Drivers Customer Outcomes Measures Process Customer Internal Process Outcomes Measures

Fishbone Diagram Inputs Other Measures Identification Complexity Issues External Impacts Customer Outcomes Process Outcomes

Check Sheet for Funnel Experiment Reason category 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H Tally Frequency

Pareto Chart Proforma

Data Collection Sheet: The Funnel Experiment Drop Value (X) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Drop 16 17 18 19 20 21 22 23 24 25 Total Average Value (X) Type the information directly into an Excel Worksheet to simplify calculations.

Sigma Level Calculation Worksheet Select the process, unit and requirements: l Identify the process you want to evaluate? l What is the “thing” produced by the process? l What are the customer requirements for the thing? Define what a “defect” is and the number of opportunities: l Possible defects: How many defects could be found on a single unit? Collect Data and Calculate DPMO l Collect end-of-process data. No. of Units counted Total defects counted l Determine total opportunities in data collected: Units counted X Opportunities/Unit = Total Opportunities Calculate DPMO = (Defects/Total Opportunities) X 106 = l Convert to a Sigma Level using a conversion table. Estimated Sigma Level = (Process) (Unit) l DPMO

Data Collection Sheet: Attributes Data No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 np c No. 16 17 18 19 20 21 22 23 24 25 Total Average np c

Sigma Conversion Table

Daily Processing Quantity Sample Size Selection – Daily Data Minimum Daily Sample Size

Weekly Processing Quantity Sample Size Selection – Weekly Data Minimum Weekly Sample Size