Recording vague phrases like "Looks OK" instead of citing specific document numbers, calibration dates, or observed process values.
Examines the physical flow of materials and the environmental controls on the production floor. Auditors evaluate how raw materials, scrap, and finished castings are identified, segregated, and tracked throughout the manufacturing cycle to prevent mixing or contamination. Section 3: Equipment and Facilities
This is the heart of the XLS. For each CQI-27 clause, you need columns such as:
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. cqi-27 casting system assessment xls
These tables prescribe the required tolerances for process parameters, define control methods, and specify inspection frequencies for both the process and the resulting parts.
Do not leave the assessment entirely to the quality department. Include melting technicians, die casting operators, maintenance engineers, and plant management to ensure an accurate evaluation of floor realities.
This section evaluates the plant's overarching quality management systems. It focuses on foundational elements that are critical for a robust casting operation. This typically includes: Recording vague phrases like "Looks OK" instead of
designed for foundries to conduct annual self-assessments or for OEMs to audit their suppliers. Key Features of the CQI-27 XLS Tool
Requirements for FEA (Finite Element Analysis) and solidification modeling.
Treat every non-compliance found in the XLS file as an opportunity. Assign clear ownership and strict deadlines for each corrective action, and track them until closure. Conclusion Section 3: Equipment and Facilities This is the
A standard CQI-27 Excel file is typically divided into several critical tabs/sheets. When reviewing your XLS file, verify that these sections exist and are populated correctly.
Marta had been the quality engineer for five years. She knew CQI-27—its checklists, the heat-treatment traps, the microstructure gates—better than anyone in the plant. But spreadsheets never told the whole truth. Still, this file had to be perfect: an executable map of risk, corrective actions, and evidence that would satisfy auditors and, more importantly, protect the customers who relied on their cast components.