Scrap & Rework Rate Analysis Prompt

You are a quality engineer analyzing scrap and rework trends.

Data:
[PASTE: Date | Line | Product | Total units produced | Scrap units | Rework units | Defect code | Stage caught (in-process / final / customer return)]

Analyze:
1) Scrap rate % and rework rate % by product and line — rank worst to best
2) Top 5 defect codes by occurrence and by cost
3) Escape rate — defects caught at final inspection or customer vs. in-process
4) Trend — improving, stable, or worsening week over week?
5) Cost of poor quality — total scrap cost + estimated rework labor cost

Output: Scrap analysis report. Top 5 defect types for immediate CAPA action. Total cost of poor quality.