Skip to content
Shop | Excel system

Complaint Management System

Severity classes, register with due dates and lead times, containment, cost per case, cost overview, causes, repeat cases per part, action tracker with proof, monthly key figures, business case and audit.

Screenshot of the Complaint Management System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: plant, volume, rates and targets. 03 Classes: the four classes and the dates that follow from them.
  2. 04 Register: every complaint on the day it arrives. 05 Containment and 06 Cost per Case for the single case.
  3. 07 Cost Overview and 08 Causes: where the money goes and which cause groups carry it.
  4. 09 Repeat Cases and 10 Actions: the parts that come back and the actions with their proof.
  5. 11 Monthly KPIs: twelve months of rate, lead time, on time and cost. 12 Business Case: what the change pays.
  6. 13 Audit every three months with the 25 statements. 14 Status every month.

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.
  • Escape point: The place in your process where the fault could have been found and was not.
  • Repeat case: The same cause group on the same part as a case you have already closed.

Sheets in the workbook

  1. Start
  2. Setup
  3. Classes
  4. Register
  5. Containment
  6. Cost per Case
  7. Cost Overview
  8. Causes
  9. Repeat Cases
  10. Actions
  11. Monthly KPIs
  12. Business Case
  13. Audit
  14. Status

Who it is for

Quality managers who run complaints across all customers and want the cost and the repeat cases visible.

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.

Newsletter

One Lean idea.
Every two weeks.