Focusing on rotational speeds and cooling rates.
Quality management in automotive casting is not optional—it's essential. For foundries supplying Original Equipment Manufacturers (OEMs), the AIAG's CQI-27 Special Process: Casting System Assessment is the standard that sets the benchmark for process control, defect prevention, and continuous improvement. Central to this assessment is the —a dynamic tool that enables organizations to systematically evaluate their casting operations. This comprehensive article explores everything you need to know about the CQI-27 assessment, the XLS tool, and the latest updates to help you maintain compliance and drive excellence in your casting processes.
The CQI-27 assessment serves several critical purposes:
The CQI-27 XLS update is an Excel-based tool used to facilitate the assessment process. The update provides a user-friendly interface for evaluating the casting process and calculating the assessment score. cqi27 casting system assessment xls upd
Management must review the assessment, sign the final document, and ensure the action plan is completed. 5. Benefits of Implementing CQI-27
AIAG released a silent but significant revision to the CQI-27 workbook. If you are using an old XLS file, you are likely missing these :
Review the assessment criteria and ensure that you understand the requirements for each section. Focusing on rotational speeds and cooling rates
A: Then you must complete both Process Table A-C (CQI-27) and Process Table D (CQI-27 heat treat annex), which is functionally equivalent to a reduced CQI-9.
: In the 2nd Edition, unused columns, rows, and sheets are generally not protected, allowing for easier common Excel editing by the user. Core Components : The assessment file typically includes sections for a Cover Sheet (facility info, assessment dates, and findings summary), Process Tables (detailed technical requirements), and a Mandatory Submissions
New tables have been added to cover a wider range of casting processes. Central to this assessment is the —a dynamic
In previous versions, strict spreadsheet protection made basic editing cumbersome. The current edition leaves unused columns, rows, and sheets unprotected. This allows automotive quality engineers to comfortably edit, filter, and adapt the sheets to their internal data systems.
$$ \textConformance % = \left( \frac\textTotal "Yes" Responses\textTotal Applicable Questions \right) \times 100 $$
Organizations seeking to implement or improve their CQI-27 assessment process should consider investing in proper training, ensuring their Excel assessment tools are up to date, and integrating the standard's requirements into their broader quality management system. The time invested in mastering this important standard pays dividends in reduced defect rates, improved customer satisfaction, and stronger competitive positioning.
The "XLS" files for CQI-27 are most valuable because of the specific process tables. Depending on your facility, you will need to complete tables for: