Names and contact details for both internal and external assessors. 2. Process Tables (A through J)
Maintaining data in Excel allows for easy "Save As" functionality to compare this year's performance against previous audits. Core Components of the Assessment
What do you primarily pour? (e.g., Aluminum, ductile iron, steel?)
CQI-27 is an industry-recognized standard designed to evaluate the effectiveness of a manufacturer’s casting processes. Like other AIAG special process assessments (such as CQI-9 for heat treating or CQI-11 for plating), CQI-27 focuses on control, repeatability, and continuous improvement. Why the Standard Matters
[Preparation] ➔ [Shop Floor Audit] ➔ [Data Entry (XLS)] ➔ [Action Plan] ➔ [Sign-off]
Captures general information including facility location, date, auditor names, and the casting processes being assessed.
Use the XLS to tick through documents required by CQI-27. For Clause 2.1.4 (Material verification), you ask for melt logs. The supplier shows a spreadsheet. You record in the XLS: “Compliant – logs complete.”
Save the XLS to a shared drive with check-in/check-out functionality. This prevents two engineers from editing the same assessment simultaneously.