
How it works
- Open 02 Setup. Enter the plant, the deliveries and parts of the period, the revenue, the two hour rates and your targets.
- Check 03 Classes. Four classes with the days for acknowledgment, containment and answer. Change the days to your own promise.
- Enter every complaint in 04 Register on the day it arrives. The answer due date comes from the class.
- Use 05 Containment for a case with affected lots: locations, quantities, sorting results and the ten steps.
- Fill 06 Cost per Case when a case closes. 07 Status shows the plant on one page for the monthly review.
Definitions used in the workbook
- Complaint: A customer tells you that delivered parts or documents are not as agreed. Internal scrap is not a complaint.
- Lead time to the answer: Working days from the day the complaint arrived to the day the written answer was sent.
- Containment: Everything that protects the customer and your stock before the cause is known.
- Repeat case: The same cause group on the same part as a case you have already closed.
Sheets in the workbook
- Start
- Setup
- Classes
- Register
- Containment
- Cost per Case
- Status
Who it is for
Quality engineers and complaint coordinators who want one register for the whole plant.
Cheaper in the pack
This workbook is part of the Quality and Inspection Tool Pack (EUR 149), which holds all 20 Excel tools of this topic area, and of the Excel Tools Complete Library with all 100 tools.
The method behind the numbers
This workbook is part of the Complaint Management 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.