Cqi27 Casting System Assessment Xls Upd
CQI-27 is part of AIAG’s Special Process Series, which includes other critical standards like CQI-9 (Heat Treat), CQI-11 (Plating), and CQI-12 (Coating). It focuses exclusively on casting processes, covering:
The assessment is divided into three primary sections:
Section 2 – Process Control & Material Handling
Section 3 – Specific Casting Process Control cqi27 casting system assessment xls upd
Each section contains a series of questions. Suppliers are rated with a traffic light system: Green (Conforming), Yellow (Conforming with minor issues), Red (Non-Conforming). A red rating in a critical process stop often triggers an immediate corrective action.
The summary sheet automatically calculates:
A Red status requires immediate corrective action and customer notification. CQI-27 is part of AIAG’s Special Process Series,
The updated CQI27_Assessment_Template_v2.xls (or similar naming) includes the following enhancements compared to legacy versions:
| Feature | Old version | Updated (2024/2025) |
|--------|------------|--------------------------|
| Process tables | 3 main sections | 5 process tables (separated heat treat annex) |
| Scoring logic | Manual calculation | Automated scoring with conditional formatting |
| Corrective action tracker | Separate sheet | Integrated within each section |
| Heat treat annex | Generic | Aligned with CQI-9, 4th edition requirements |
| Part approval linkage | None | Link to PPAP/ISIR references |
| Digital signature fields | Missing | Added for supplier & customer approval |
| Dropdown menus | Partial | Full dropdowns for N/A, conforming, nonconforming |
📥 Download the updated XLS file here: [Internal link / shared drive / contact quality team] The assessment is divided into three primary sections:
CQI-27 is a standardized assessment that evaluates the robustness of casting processes and related controls — including melting, pouring, mold handling, heat treatment, machining, inspection, and transport — to ensure consistent part quality and reduced risk of defects. It documents process capability, preventive controls, training, and traceability across the casting workflow.
Use the integrated CAR tab. For every "Red" finding:
