The meeting room at Prestige Auto Parts was freezing, but Raj felt like he was standing next to a ladle of molten iron.
You have three options:
Monitoring scrap rates, customer returns, and rework metrics. cqi-27 casting system assessment xls
"You know," Henderson said, picking up the brake caliper again, "most suppliers try to hack the spreadsheet. They fill it out to make the cells green, then go back to doing things the old way." The meeting room at Prestige Auto Parts was
Go to the Dashboard. Select “High Pressure Die Casting” (Section 2). Enter audit scope: Melting, shot end, trimming, and X-ray inspection. They fill it out to make the cells
Have a second XLS or a separate sheet that tracks scores over time. Plot a line chart of compliance % for Supplier XYZ across 5 audits. Show improvement (or degradation) visually.
Simplifies post-audit follow-ups by filtering open corrective actions in one sheet.