Product Traceability Challenge

An exercise with an answer key: walk a finished aerospace fitting back through its records to the mill heat, find where the chain breaks, then time the same walk on a part from your own shop.

Free to use, change and copy inside your own organization. Editable Excel, plus a fillable PDF you can complete on screen.

The problem it solves

Auditors test traceability with a walk: they pick a finished part and ask you to take it back to the work order, the inspection, the special process certificates, the receiving record, the material certificate and the mill heat. Most shops have every record. Fewer have checked that the numbers on them agree, and the walk fails on a heat number that does not match or a certificate quantity one short. This exercise gives your team twelve realistic records for one fitting with deliberate gaps, a self-checking trace sheet, an answer key that explains how an auditor reads each link, and a sheet to run the same walk on your own parts.

Who uses it, and when

Quality teams, receiving and final inspectors, internal auditors, and anyone who trains them. Before an audit, as a training exercise for new inspectors and auditors, and whenever you change how receiving or outside processing is checked. Allow about 30 minutes for the exercise.

Companion to

The Audit Ready Brief, issue 5: walking a part back to the mill.

Clause references: 8.5.2 (with 7.1.5.2, 8.1.4, 8.4.3, 8.5.1.2). Clause numbers only; the standards text is not reproduced, use your own licensed copy.

A management aid, not certification or a registrar audit. Using it does not by itself show conformity to AS9100D or any other standard.

Page 1 of the PDF. Every resource includes a worked example.