
How it works
- Open 02 Setup. Enter the process, up to ten defect types with their rework cost per unit, and the period you want to see.
- Enter one row per day in 03 Check Sheet: date, period, units inspected and units with a defect per type.
- Read 04 Pareto: defect types sorted by units and by cost, with class A and two charts.
- Sort the top defect by up to three factors in 05 Stratification. Enter units inspected and defects per group.
- Read 06 Run Chart every day and 07 Status once a month. After a change, enter the new days as period 2.
Definitions used in the workbook
- Defect rate: Units with a defect divided by units inspected. First pass yield is 1 minus the defect rate.
- Pareto chart: Defect types sorted from largest to smallest, with the cumulative share as a line.
- Stratification: The same data sorted by a factor such as shift, position, product or weekday. Compare the rates of the groups.
- Run chart: One point per day in time order with the median as center line.
Sheets in the workbook
- Start
- Setup
- Check Sheet
- Pareto
- Stratification
- Run Chart
- Status
Who it is for
Supervisors, team leaders and quality engineers who want to count, sort and chart the defects of one process.
The method behind the numbers
This workbook is part of the Quality Tools toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.