Defect Escape Rate Calculator with Customer PPM
A low scrap rate can still hide a serious problem if defects slip past inspection. This calculator shows the escape rate, the customer PPM and the money lost because defects were found by the customer instead of by you.
Your numbers
Defects caught by your own inspection or test in the period.
Defects reported by customers, returned or complained about.
Scrap or rework cost when caught in your plant.
Include sorting, freight, credit, investigation and admin time.
Your results
Escape rate treats every defect equally. Weight critical and major defects separately if your customer scores them differently.
Avoidable cost vs escaped defects
Sweeps Defects found by customer from 0 to 60, holding your other inputs fixed.
Customer PPM straight from ERP data
Optional: we can build a read-only scorecard of PPM and escapes by customer and part from your ERP.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Enter the defects your own inspection found and the defects the customer found in the same period, using the same product scope. Add the units shipped and a cost for a defect caught internally and one that escaped. The escape rate is escaped defects divided by all defects. Customer PPM is escaped defects divided by units shipped, times one million. Detection effectiveness is the opposite of the escape rate. Use the chart to see how fast avoidable cost grows as escapes rise.
- Use the same period and product scope for all inputs
- Count customer-found defects by piece, not by complaint
- Include sorting and freight in the escape cost
- Track the result monthly as a trend
The formulas
Escape rate = escaped / (internal + escaped) x 100. Detection effectiveness = internal / (internal + escaped) x 100. Customer PPM = escaped / shipped x 1,000,000. Avoidable cost = escaped x (escape cost per defect - internal cost per defect). Customer scorecards often set PPM targets by product class, and some automotive and aerospace customers publish their own thresholds, so compare against your contract instead of a generic number.
Worked example
A plant finds 180 defects internally and the customers find 12 across 96,000 units shipped. The escape rate is 12 out of 192, about 6.3%. Customer PPM is 125. At 45 dollars per internal defect and 850 per escape, the 12 escapes cost 10,200 dollars. Had they been caught in-house, they would have cost 540 dollars, so the avoidable cost is 9,660 dollars. That figure often makes the case for added inspection or error-proofing.
Common mistakes
A common error is mixing periods, for example counting customer defects reported this month against last month's shipments. Defects found by the customer often lag shipment by weeks. Use a rolling window or match returns to ship dates. Another is using an escape cost that ignores sorting and administrative time. And a low escape rate can reflect weak internal detection reporting as much as good control, so check that internal defects are logged consistently.
Frequently Asked Questions
What is a good escape rate?
Lower is better, and the right target depends on your product and customer. Trend matters most: a falling escape rate with stable internal detection shows real improvement.
How is customer PPM different from the escape rate?
PPM compares escaped defects with units shipped, so it measures what the customer experiences. The escape rate compares escapes with all defects, so it measures how well your inspection catches problems.
Which cost should I use for an escaped defect?
Include sorting, freight, replacement, credit notes, investigation hours and any customer chargeback. Many plants find the true escape cost is ten or more times the internal cost.
Can I calculate it by supplier instead?
Yes. Use incoming inspection defects as internal, line failures or customer returns traced to the supplier as escaped, and units received as the base.
Netray can calculate escape rate and customer PPM from your ERP shipments and rejection records automatically, per customer and part.
Related Tools
Nonconformance Log and Pareto Worksheet
Log nonconformances by defect code with quantity, unit cost and cost of the event, then total them to see which codes drive the loss.
Quality & InspectionCustomer Complaint Response Letter Template
A structured response letter to a customer quality complaint that covers acknowledgement, containment, cause, action and next update date.
Quality & InspectionCAPA Action Tracker Worksheet
Track every open corrective and preventive action with owner, due date, days open and status, and see how many are overdue or ageing.
Quality & InspectionContainment Action Plan Template
A fill-in containment plan that lists every suspect location, the sort or inspection action, the owner and the criteria for releasing stock.
Quality & InspectionCAPA Closure Readiness Checklist
A pre-closure checklist that confirms the corrective action is complete, effective, documented and ready for audit review.
More Quality & Inspection tools
See all- A3 Problem Solving Report Template
- Rolled Throughput Yield Calculator
- A3 Problem Solving Template
- Rolled Throughput Yield Calculator
- Cpk Confidence Interval and Sample Size Calculator
- X-bar and S Control Chart Limits Calculator
- Individuals and Moving Range (I-MR) Chart Limits Calculator
- Expected PPM Out of Specification Calculator
- Taguchi Loss Function Calculator