Escaped Defect Cost by Detection Stage Calculator
Defects cost far more the later they are found. This calculator puts your own numbers on that idea: how many defects are found where, what each stage costs, and how much you save by catching a few more points of them in process.
Your numbers
Whatever is left after these two shares reaches the customer.
Rework or scrap plus a little handling.
Adds sunk operations, re-inspection and schedule disruption.
Return, replacement, freight, investigation, credit and relationship cost.
Percentage points of defects moved from customer-found to caught in process.
Your results
Illustrative model. Use your own failure cost data by stage. The 1-10-100 pattern is a rule of thumb, not a law.
Annual saving vs points of detection shifted earlier
Sweeps Detection shifted earlier from 0 to 40, holding your other inputs fixed.
COPQ by stage from your ERP
Optional: discuss pulling scrap, rework and return costs into a stage-based COPQ view.
Optional. The tool and every export work without this. No spam.
How to use it
Start with annual defect counts from NCRs, scrap reports and customer returns. Split them by where they were found. Estimate the average cost at each stage using your cost accounting, not a guess: include labor, material, extra inspection, freight and customer credits. If you do not know the customer cost, use warranty and return reports for a recent period and divide by units.
The model
Each stage cost is defects times the share found there times that stage unit cost. The customer share is whatever remains after in-process and final shares. The saving from shifting detection is the defects moved multiplied by the difference between customer cost and in-process cost. It assumes the shifted defects would otherwise have escaped, which is what a better in-process check is for.
- Stage cost = defects x share x unit cost
- External share = 100 - in-process - final
- Saving = defects x shift x (field cost - early cost)
How to read the result
The chart is usually a straight line, so the interesting question is what a point of detection is worth. Compare that value with the cost of a gauge, a test fixture, an SPC alarm or an added inspection step. Where the saving exceeds the investment within a year, the project is easy to justify to finance.
Common mistakes
Leaving out customer-side costs such as lost orders and expedited freight, assuming every escape is found by the customer when some are found at receiving inspection, and double counting scrap that is also in your COPQ report. Keep definitions the same as your cost of quality reporting so numbers reconcile.
Frequently Asked Questions
Is the 1-10-100 rule accurate?
It is a teaching shorthand. Real ratios vary by product, industry and contract. This tool lets you enter your own costs per stage instead of assuming a fixed multiplier.
What if more than 100 percent is entered?
If in-process and final shares total more than 100, the customer share is set to zero. Reduce one of the shares so the three stages add to 100 percent.
Where do I get external failure cost?
Use warranty, returns, credits and customer corrective action costs for a recent period, divided by the number of customer-found defects. Include freight and engineering time.
Can I use it for suppliers?
Yes. Treat receiving inspection as the early stage, your production as the middle stage and customer-found as external, with costs that match your situation.
If your defect counts and costs sit across several ERP and quality tables, we can help assemble a stage-by-stage view so this model runs on real data.
Related Tools
Suspect Lot Sorting and Containment Cost Calculator
Cost and time to 100 percent sort a suspect lot, including defects found, defects likely missed and cost per piece.
Quality & InspectionRework vs Scrap Disposition Break-Even Calculator
Expected cost of rework (including failures) versus scrap and remake, and the rework cost at which both options cost the same.
Quality & InspectionSupplier Reject PPM and Chargeback Calculator
Supplier PPM, the full cost of the rejects (material, labor, admin, expedite) and the chargeback you can recover.
Engineering & PLMBOM Error Cost of Poor Quality Calculator
Quantify what BOM line errors cost when they are found late, and see the chance that a released BOM is completely clean.
More Quality & Inspection tools
See all- SAP QM Process Capability Cp Cpk Calculator
- SAP QM Lot Rejection Rate, PPM and Sigma Level Calculator
- SAP QM Gauge R&R Study Calculator
- SAP QM Cp and Cpk Capability Calculator
- Job Shop Material Certification Log Worksheet
- Job Shop First Piece Inspection Sign-Off Template
- Job Shop Scrap and Rework Cost Calculator
- Master Data Audit Sample Size Calculator
- Data Quality Sigma Level Calculator