The official CQI-27 publication is more than just a manual; it is a structured framework. The second edition of the standard is divided into four primary sections.
To get the most value out of your CQI-27 XLS assessment, avoid treating it as a simple "check-the-box" paperwork exercise. Implement these strategies for a more effective audit:
A valuable feature to add or request in such an Excel tool is:
CQI-27 is an industry-recognized standard designed to evaluate the effectiveness of a manufacturer’s casting processes. Like other AIAG special process assessments (such as CQI-9 for heat treating or CQI-11 for plating), CQI-27 focuses on control, repeatability, and continuous improvement. Why the Standard Matters
To help tailor this to your facility, I can provide specific parameters for your casting type. Let me know: cqi-27 casting system assessment xls
Mark each line item in your Excel template as Compliant , Non-Compliant , or Not Applicable . Use the comments section to document objective evidence (e.g., calibration certificate numbers, specific temperatures observed).
: Unused columns, rows, and sheets are not protected, allowing users to perform standard Excel editing for internal reporting. Consolidated Requirements
Promoting standard work practices and robust problem-solving frameworks.
Always provide supporting records or explanations for actual conditions, especially if minimum requirements are not met. How to Obtain the Assessment The official CQI-27 publication is more than just
Once all metrics achieve compliance, have the Plant Manager and Head of Quality sign the digital cover sheet. Save the file using standard automotive document-control naming conventions.
Built-in formulas can automatically calculate compliance percentages, highlight failures via conditional formatting, and generate summary dashboards.
Promoting a culture of ongoing optimization within the foundry.
Captures high-level information about the foundry being assessed, including facility details, assessment dates, and final scoring results. Implement these strategies for a more effective audit:
Automotive standards require the CQI-27 assessment to be conducted at least to ensure process controls do not degrade over time. 5. Benefits of Utilizing an Excel (XLS) Template for CQI-27
Midwest Iron Foundry (MIF) supplied brake components to a Tier 1 automotive supplier. Their casting scrap rate was 12%, and they had failed two CQI-27 audits.
A: The 2nd edition, released in March 2018, added more process tables to cover a wider range of casting methods. It also deliberately left parts of the Excel file unprotected to allow for easier editing and customization.
When Henderson returned, Raj didn't hand him a repaired part. He handed him a printed report generated from the .xls file.