Cqi27 Casting System Assessment Xls Upd [exclusive] [2026 Update]
Organizations are required to conduct CQI-27 assessments:
Ensure you are using the official AIAG template. You can find the hardcopy with the downloadable assessment on the AIAG Store or through authorized distributors like Standards Media .
This content is designed to be used as the within the Excel file, outlining the purpose, structure, and how to use the tool to audit your casting processes according to AIAG CQI-27 standards.
Visual cues (such as cells turning bright red or soft amber) that immediately highlight failed criteria or missing compliance documentation. cqi27 casting system assessment xls upd
The remains the gold standard for casting system assessments. Its official Excel spreadsheet is more than just a form; it's a powerful, structured tool for driving quality, consistency, and continuous improvement. The term "upd" serves as a reminder that this is a living document and a process that requires regular, annual updating to be effective.
This section evaluates leadership commitment. Auditors look for evidence of advanced product quality planning (APQP), robust failure mode and effects analysis (FMEA), controlled control plans, and defined internal training pathways for specialized casting operators. Section 2: Floor and Material Handling Responsibility
=SUMIFS(Detailed!D:D, Detailed!A:A, ">=0") / (COUNTIF(Detailed!A:A, "Process Control")*10) *100 Visual cues (such as cells turning bright red
Digital transformation trends may also influence future versions of the assessment tool. While Excel provides flexibility and accessibility, future iterations could incorporate cloud-based platforms, automated scoring, real-time collaboration, or integration with quality management software systems.
With 10 distinct process tables, the XLS tool ensures that assessments are tailored to the specific casting technologies employed—whether sand casting, die casting, investment casting, or centrifugal casting. This targeted approach prevents generic assessments that may miss process-specific risks.
The CQI-27 requirements should be combined with applicable customer-specific requirements to establish comprehensive quality management for foundries. The term "upd" serves as a reminder that
The CQI-27 requires "Job Audits," where a specific part number is followed from the raw material storage stage all the way to final packaging and shipping. This verifies if shop-floor practices match the written control plans.
The is a critical quality standard developed by the Automotive Industry Action Group (AIAG). Like its siblings (CQI-9 for heat treating or CQI-11 for plating), CQI-27 is designed to provide a common approach to a casting quality management system for automotive production and service part organizations.
The official CQI-27 standard, including the downloadable Excel assessment file, can be purchased directly from AIAG or authorized distributors such as TopQM-Systems, EN-Standard, or other AIAG partners. The standard is available as a hardcopy with downloadable assessment or as an e-document.
Casting is a complex metallurgical process where minor deviations in temperature, chemistry, or cooling can lead to catastrophic structural failures. CQI-27 was designed to move beyond simple product inspections. Instead, it focuses on . By assessing the entire system—from raw material handling to final heat treatment—it ensures that quality is "baked in" rather than just checked at the end. Key Components of the Assessment