Free quality tools from Aegis: templates, kits and guides you can use today →

The Quality Performance Kit HandbookChapter 6 of 20

Collecting the data

Counts in, measures out

Collect counts, never percentages: lines shipped and lines shipped on time, lots inspected and lots accepted first time, parts received and parts rejected. The dashboard (AQL-F08) works out every ratio and, over three or twelve months, adds the counts up before dividing. That is the only way a quarter's figure agrees with the quarter's records, and it is why the dashboard's three-month figures can be checked against the ERP by anyone.

A collection calendar

CountSourceOwnerDue
Order lines shipped, on timeERP shipping report against promise dateProduction leadWorking day 2
Parts shipped, returned; escapes; complaintsERP; return log; complaint logQuality managerWorking day 2
Lots inspected, accepted first timeFinal inspection recordsQuality engineerWorking day 2
NCRs, classified; scrap and rework costNCR logQuality engineerWorking day 3
SalesFinance month-endFinanceWorking day 3
Corrective actions closed, effective, past dueCorrective action register (B09)Quality engineerWorking day 2
PO lines received, on time; parts received, rejectedERP receipts; receiving inspectionSupplier quality or buyerWorking day 2
Audits planned, doneInternal audit programInternal audit leadWorking day 2

Check before you read

The dashboard's record check catches a month out of order, a part larger than its whole and missing core counts. The NCR data's record check catches an NCR with no classification. Clear both before the numbers are read. Then do the human check: does any figure look wrong against what you know happened? A delivery figure that jumped four points in a month with no change on the floor usually means the report was run against the wrong date field.

Need more than one resource, or not sure where to start? Book a complimentary 30-minute Aegis Quality Guidance Call. We'll find the tools that fit your situation and a sensible place to start. No sales pressure, no obligation.

A management aid, not certification or a registrar audit. Using it does not by itself show conformity to AS9100D or any other standard, and your customers' requirements may add to it.

Clause numbers refer to AS9100D (SAE AS9100 Rev D) unless another document is named. The standards' text is not reproduced here: use your own licensed copy.

Aegis Insights are our own guidance, labeled wherever they appear: how we approach this work, not a requirement of any standard or customer.