Cqi-27 Casting System Assessment Xls May 2026

CQI-27 Special Process: Casting System Assessment (2nd Edition)

11. Verification & Follow‑Up

• Schedule follow‑up verification audits based on severity: Critical — within 30 days; Major — within 60–90 days; Minor — next planned assessment.
• Require objective evidence: revised procedures, training records, process data showing sustained compliance.
• Close findings only after verification evidence is uploaded to XLS and approved by Assessment Lead and Quality Manager.

Worksheet 3: Corrective Action Plan (CAP) Matrix

A non-compliant finding is useless without a close-loop corrective action. This sheet should include: cqi-27 casting system assessment xls

❌ Trap 3: Ignoring the “For Reference Only” Fields

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. Solution: Enter actual limits (e.g., “Pour temp: 680°C ± 10°C”) so the audit is data-driven. Worksheet 3: Corrective Action Plan (CAP) Matrix A

Important: The XLS must mirror the latest version of CQI-27 (currently 3rd edition, 2022). Outdated templates referencing obsolete clauses will fail a customer audit. Key objectives of CQI-27:

This article provides a comprehensive breakdown of CQI-27, a step-by-step guide to using the XLS assessment tool, and best practices for achieving a "Level A" rating.

5.2 Automate Data Collection

Excel assessments are retrospective, but real-time data wins audits. Link your XLS to SPC software or CMM systems. Many advanced users embed Power Query in their XLS to pull live scrap rates from SQL databases.

8. Typical High‑Risk Areas for Casting

• Melt chemistry control and charge calculation errors
• Inconsistent pouring temperature and metal cleanliness
• Core/mold integrity and core print mismatches
• Sand system control (moisture, fines, clay, CBEs)
• Heat treatment cycle inaccuracies and furnace calibration
• Inadequate NDT or sampling plans
• Poor segregation of conforming vs nonconforming parts
• Insufficient maintenance of refractory, ladles, and pouring equipment
• Incomplete material traceability and certification retention
• Training gaps for operators and inspectors

Key objectives of CQI-27: