Cqi-27 Casting System Assessment Xls

When reviewing your specific XLS file, look for these common audit failures:

1. "Blind" Checkboxes

2. Lack of Traceability in Melting

3. Special Characteristics (SC) Disconnect

4. Maintenance of Dies/Patterns

5. Laboratory Competency


CQI-27 is a sector-specific standard that assesses the quality management system for casting processes. It covers multiple casting methods, including:

The standard is structured into three main sections:


If you’d like, I can:

The CQI-27 Special Process: Casting System Assessment (2nd Edition) is a standardized framework developed by the Automotive Industry Action Group (AIAG) to evaluate and improve casting processes across the automotive supply chain. The assessment is typically conducted via an Excel-based tool that provides a structured checklist for auditors and suppliers. Key Features of the CQI-27 Assessment CQI-27 | Special Process: Casting System Assessment - AIAG

The CQI-27 Special Process: Casting System Assessment provides requirements for foundry suppliers of OEM automotive castings. CQI-27 Casting System Assessment Guide | PDF - Scribd

The CQI-27 Special Process: Casting System Assessment (2nd Edition) is a common process requirement developed by the AIAG to ensure foundries consistently produce high-quality automotive castings. It is designed to evaluate a foundry's ability to meet customer requirements and is typically required for self-assessment at least once a year. Assessment Structure & Components

The assessment is structured around several key sections, typically provided in an Excel (XLS) format to facilitate documentation:

Management Systems: Evaluates overall quality management, including operator training, maintenance, and documentation effectiveness.

Process Controls: Focuses on critical parameters such as melting temperatures, pouring conditions, and solidification control.

Casting Design & Tooling: Covers requirements for design software, stress analysis (FEA), casting simulations, and tool maintenance.

Process Tables (A-J): Specific requirements tailored to different casting methods: Table A: Sand Casting (Iron/Steel) Table B/C: Centrifugal Castings & Liners Table D: Investment Casting (Iron/Steel) Table E: Aluminum Semi-Permanent Mold (Cylinder Heads) Table G: Aluminum Metal Mold Table H: Aluminum High-Pressure Die Casting Table J: Zinc High-Pressure Die Casting Scoring and Documentation Guidelines cqi-27 casting system assessment xls

When completing the XLS template, the following rules generally apply for each line item:

Conforming: Mark if requirements and customer-specific standards are met. Non-Conforming: Requires a detailed corrective action plan. Not Applicable (N/A):

Enter a score of "3" if the element is N/A and there is no current risk.

Enter a score of "2" if the element is N/A but has potential future risk.

Notes: Always provide supporting records or explanations for actual conditions, especially if minimum requirements are not met. How to Obtain the Assessment

Official copies and the accompanying Excel file are proprietary and must be purchased directly from the AIAG Store. Some foundries use third-party platforms like TopQM-Systems for specialized support and training. CQI-27 Casting System Assessment - TopQM-Systems

Optimizing Your Foundry: A Guide to the CQI-27 Casting System Assessment

In the high-stakes world of automotive manufacturing, precision isn't just a goal—it's a requirement. For foundries, the AIAG CQI-27 Special Process: Casting System Assessment serves as the definitive roadmap for ensuring robust, defect-free production. When reviewing your specific XLS file, look for

Whether you are preparing for an upcoming audit or looking to refine your internal quality management, understanding the nuances of the CQI-27 (currently in its 2nd Edition) is essential for staying competitive in the global supply chain. What is CQI-27?

Developed by the Automotive Industry Action Group (AIAG), CQI-27 is a specialized assessment designed to evaluate and improve the control of casting processes. Unlike general quality standards, it focuses specifically on the common failure modes—like porosity, leakage, and cracks—that lead to non-conforming parts.

The assessment typically includes a comprehensive Excel-based assessment file (XLS) that auditors and quality teams use to document compliance across multiple process tables. Key Areas of Focus

The assessment provides a structured framework to evaluate several critical categories: CQI-27 Casting System Assessment - TopQM-Systems


This is the most important part of the spreadsheet. It lists the manufacturing steps.

A good CSA XLS uses data validation to prevent errors. For example:

A common failure in CQI-27 audits is “no evidence of operator training.” This sheet lists: