The Job Audit acts as a vertical slice verification. The auditor selects a specific part number currently in production and tracks it from raw material receipt to final packaging. This ensures that the theoretical procedures documented in Sections 1-3 are actively followed on the shop floor. Designing Excel Formulas for Automated Scoring
This sheet focuses on physical operations on the shop floor. Key audit criteria include:
While the official copyrighted Excel templates must be purchased directly from AIAG, I can generate a representative and a sample data entry piece that reflects the standard "Process Table" format used in CQI-27 assessments. CQI-27 Assessment Structure Overview
The process tables are highly specific to the type of casting being performed. They list the specific process parameters, tolerances, and frequencies required for control. Examples of process tables in CQI-27 include: Sand Casting (Molding, core making, pouring) Table B: Centrifugal Casting Table C: Permanent Mold / Gravity Die Casting Table D: Low-Pressure Die Casting Table E: High-Pressure Die Casting Table F: Investment Casting Why Use an XLS Template for CQI-27? cqi-27 casting system assessment xls
Complete Guide to CQI-27 Casting System Assessment XLS The is a comprehensive evaluation standard developed by the Automotive Industry Action Group (AIAG) to ensure robust casting processes in the automotive supply chain. Implementing this standard via an Excel (XLS) worksheet allows foundries and auditors to systematically evaluate control tracking, minimize scrap, and fulfill strict OEM quality mandates. 1. What is the CQI-27 Standard?
Final compliance score (automatically pulled from the summary tab). 2. Section 1: Management Responsibility & Quality Planning
Many foundries fail because their thermocouple calibrations and furnace temperature surveys do not match the exact frequencies mandated in the process tables. The Job Audit acts as a vertical slice verification
Good XLS templates include columns for “Target Value,” “Upper Limit,” and “Lower Limit.” Filling these turns the XLS from a checklist into a process capability tool. Enter actual limits (e.g., “Pour temp: 680°C ± 10°C”) so the audit is data-driven.
The assessment is divided into several sections, primarily focusing on general system requirements and specific process tables:
Here is a detailed breakdown of what the CQI-27 assessment entails, how the Excel file is typically structured, and key areas to focus on during a review. Designing Excel Formulas for Automated Scoring This sheet
The Automotive Industry Action Group (AIAG) publishes Special Process Assessments to ensure robust manufacturing standards across the global automotive supply chain. Among these, provides a common approach to a casting management system for automotive production and service parts organizations.
The assessment is applicable for both and second-party (customer) audits of a foundry. Self-assessment is particularly critical—it helps an organization identify and eliminate the primary causes of defects by constructing a robust process. The standard strongly recommends that organizations conduct this self-assessment regularly, typically every 12 months. It is also designed to be used for evaluating a foundry's ability to meet customer, regulatory, and its own internal requirements.
FMEA (Failure Mode and Effects Analysis) and Control Plan alignment. 3. Section 2: Floor and Material Handling Responsibility