Drafting a for one of the process tables (e.g., Die Casting or Sand Casting). Creating a training outline for your internal audit team.
: Verification of advanced product quality planning (APQP), review of customer-specific requirements, and documentation of internal key performance indicators (KPIs).
To get the most out of your CQI-27 Excel tool, follow this systematic audit process:
Chemical composition analysis frequencies (e.g., spectrometer testing). Degassing and molten metal treatment times. Die temperature layouts and cooling water flow rates. 6. Job Audit Template cqi-27 casting system assessment xls
Pay special attention to the thermal controls. Ensure that thermocouples, infrared sensors, and furnace controllers are calibrated according to the frequencies mandated in the process tables.
Tracks Key Performance Indicators (KPIs) like scrap rates, downtime, and customer returns.
Name, address, and contact details of the audited foundry. Drafting a for one of the process tables (e
If you are preparing to implement or update your casting assessment workflow, let me know how you would like to proceed:
They checked "No" on the question regarding Annual Reviews of Quality Objectives . Result: The cell turned red. "It wants to know if we have a defined escalation process for tooling failures," Raj noted. "We do it verbally, but it’s not documented." "That’s a finding," Sal grumbled.
Robust segregation procedures to prevent defective castings from being shipped. 4. Section 3: Equipment and Facilities To get the most out of your CQI-27
This tab establishes the metadata for the audit. It should capture essential tracking information in clean, data-entry cells: Name of the casting facility and location. Date of the assessment.
If your XLS is unprotected, a user can accidentally delete a scoring formula, breaking the assessment. Lock all cells except data entry fields. Use password protect for the workbook structure.
Real-time data logging of critical casting variables. Process Tables (The Technical Core)
Use SUMIF and COUNTIF formulas to calculate compliance percentages while ignoring "Not Applicable" (N/A) entries.