Supplier processes align with global benchmarks like IATF 16949. đź“Š Navigating the CQI-27 XLS Tables
Use SUMIF and COUNTIF formulas to calculate compliance percentages while ignoring "Not Applicable" (N/A) entries.
Foundries must provide basic facility information, including:
Move through your casting cell section by section. In your Excel file, use the to document evidence: cqi-27 casting system assessment xls
The CQI-27 Excel workbook is structured to mirror the standard's assessment framework, which is built on three core sections.
They got to the question about Operator Training . "Of course they’re trained," Sal said. "But do we have records specifically for 'Press Operation' and 'Safety' that are current within the year?" Raj asked, clicking through the dropdown menus. "The file demands evidence. If we don't have the certificate uploaded or referenced, we fail."
The CQI-27 assessment document typically includes an Excel file containing several critical sections that must be completed. Supplier processes align with global benchmarks like IATF
Basic information about the facility, assessment date, and the specific casting processes being reviewed (e.g., Sand Casting, Die Casting, Investment Casting).
Like its siblings (CQI-9 for Heat Treat or CQI-11 for Plating), CQI-27 is designed to provide a proactive approach to casting. It focuses on: Process controls Testing and equipment maintenance Continuous improvement Reduction of waste and defects Who needs it?
For each question, the auditor inputs a compliance rating. If a requirement is missed, the XLS sheet flags the item, often turning the cell red. The template aggregates these inputs to output an overall percentage score, which categorizes the foundry's capability (e.g., "Excellent," "Satisfactory," or "Needs Immediate Action"). Best Practices for Completing the Assessment In your Excel file, use the to document
Midwest Automotive Casting (MAC), 120 employees, die casting aluminum transmission housings.
Formula example: =SUM(Section1_Scores) / (COUNTIF(Section1_Responses, "<>N/A") * 10)