Cqi-27 Casting System Assessment Xls -
Name, address, and contact details of the audited foundry.
You download a CQI-27 XLS from a forum from 2019. It doesn’t contain new 2022 requirements (e.g., digital data logging for melting). Always verify the XLS against the official AIAG CQI-27 standard PDF. Update your master template annually.
This section functions similarly to a "Layered Process Audit" (LPA).
The CQI-27 is a "Special Process" assessment, meaning it applies to processes where the final product's quality cannot be fully verified without destructive testing. It was created by OEM and Tier 1 customers to establish common process requirements for foundries supplying the automotive industry. The standard applies to: operations. Pouring and solidification processes. Finishing and heat treatment of cast components. cqi-27 casting system assessment xls
: The heart of the document, containing detailed requirements for specific processes: : Sand Castings (Iron/Steel) : Investment Castings (Iron/Steel) : Aluminum High Pressure Die Cast : Magnesium High Pressure Die Cast Critical Audit Elements
Specific technical requirements for different casting types (e.g., Sand Casting, Die Casting, Investment Casting).
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. Name, address, and contact details of the audited foundry
Deploying a CQI-27 assessment requires a structured, multi-phase methodology to move from initial gaps to full compliance. 1. Form a Cross-Functional Team
Automotive standards require the CQI-27 assessment to be conducted at least to ensure process controls do not degrade over time. 5. Benefits of Utilizing an Excel (XLS) Template for CQI-27
For every compliant marker in the XLS sheet, reference specific documents. Write down the exact control plan numbers, training record dates, or calibration certificate IDs in the evidence column. Always verify the XLS against the official AIAG
If you need help writing specific (like weighted averages or conditional formatting rules)?
Pay special attention to the thermal controls. Ensure that thermocouples, infrared sensors, and furnace controllers are calibrated according to the frequencies mandated in the process tables.




