Skip to content

For quality managers and process engineers, the most practical tool to execute these audits efficiently is the —an Excel spreadsheet that structures the audit, calculates scores, and ensures compliance.

is a guideline published by the Automotive Industry Action Group (AIAG). It is designed to assess the capability of casting suppliers (Iron, Steel, Aluminum, etc.) to meet customer requirements.

The core of the assessment lies in its . In the 2nd Edition, the AIAG provided these as Excel-based checklists (XLS) to allow for easier editing and data entry. There are 10 specific tables tailored to different casting methods: Table A: Sand Casting (Iron/Steel) Table B/C: Centrifugal Castings & Liners Table D: Investment Castings

: Captures basic data about the casting organization, audited areas, and contact information for auditors and participants. Assessment Results

They scrolled to the section on Question 2.3: "Is the die temperature monitored and recorded continuously for critical zones?" "We check it every hour," Sal said confidently. Raj read the requirement carefully. "It asks for continuous monitoring . We write it on a clipboard once an hour. That’s not continuous."

When you download or build a CQI-27 Excel assessment, ensure it includes the following mandatory sections: