
How it works
- Open 07 Lists and adapt the defect types and alarm triggers to your line. Twelve defect types at most.
- Fill one row in 02 Daily Log per shift: units started, right first time, reworked and passed, scrapped.
- Enter the defects of every shift in 03 Defect Log by type, with the station and the quantity.
- Read 04 Dashboard in the weekly review: FPY, ppm, the trend and the Pareto of defect types.
- Log every quality alarm in 05 Alarm Log with the time raised and the time the team leader arrived.
- Agree one action per week in 06 Action Plan, with owner and date.
Definitions used in the workbook
- Internal ppm: Defective units divided by units started, times 1,000,000.
- Defective units: Units started minus units right first time. A unit with two defects counts once here and twice in the defect log.
- Period values: Calculated from the sums of units, never as an average of percentages.
Sheets in the workbook
- Start
- Daily Log
- Defect Log
- Dashboard
- Alarm Log
- Action Plan
- Lists
Who it is for
Quality engineers and line leaders who want fewer defects at the source.
The method behind the numbers
This workbook is part of the Zero Defects 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.