[Preparation] ➔ [Shop Floor Audit] ➔ [Data Entry (XLS)] ➔ [Action Plan] ➔ [Sign-off]
The 2nd Edition of the standard, released in 2018, introduced several critical changes directly impacting the Excel workbook:
Do not isolate the audit to the quality department. Include foundry process engineers, metallurgical lab technicians, maintenance staff, and floor supervisors. Step 2: Conduct the Pre-Assessment
CQI-27 Special Process: Casting System Assessment (2nd Edition) cqi-27 casting system assessment xls
Built-in Excel formulas calculate compliance percentages instantly across different categories.
Protect formula-driven cells and standard checklist text to prevent accidental modification during data entry. 4. Step-by-Step Guide to Conducting the Assessment
The 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 [Preparation] ➔ [Shop Floor Audit] ➔ [Data Entry
Implementing this standard typically involves utilizing a detailed spreadsheet (XLS format) to track compliance, score processes, and manage corrective actions. This article explores the core components of the CQI-27 assessment, how the XLS tool functions, and best practices for a successful audit. What is the CQI-27 Assessment?
If your template supports it, use the "form builder" tab to construct a layout that matches your specific material flow.
Always provide supporting records or explanations for actual conditions, especially if minimum requirements are not met. How to Obtain the Assessment Protect formula-driven cells and standard checklist text to
Implementing this framework manually can be incredibly time-consuming and error-prone. This is why a CQI-27 Casting System Assessment XLS (Excel) template is an indispensable tool for quality managers and auditors.
This is the heart of the assessment. CQI-27 divides different casting processes into distinct "sub-process tables," each with its own exclusive set of control points designed to address unique failure modes and critical process parameters [9†L5-L8]. The standard defines 10 or more process tables, although the exact number can vary by edition. The primary tables include: