Quality & InspectionFree calculatorPDF, Excel, Word export

Nonconformance Containment and Sort Cost Calculator

When a lot is suspect, the first cost is not the defect itself but the work needed to find the bad pieces. This calculator estimates sorting labor, elapsed time, rework and scrap so you can size containment, set a supplier chargeback or justify earlier detection.

Your numbers

pcs

All parts in the suspect lot, stock and WIP.

pcs/hour
people
$/hour
8 %
25 %
min
$/hour
$

Your results

Total containment cost
$1,513
Sorting plus rework plus scrap. Excludes freight, line stoppage and customer charges.
Total sorting labor hours
12.5
Pieces divided by the rate of one inspector.
Elapsed time to finish the sort
4 hrs
Calendar hours with the assigned team working in parallel.
Sorting cost
$475
Defective pieces found
120
Pieces scrapped
30
Rework cost
$378
Scrap cost
$660

Estimate only. It excludes expedite freight, production downtime, customer charges, administrative time and any cost recovered from a supplier.

Save results:

Total containment cost vs defect rate

Sweeps Expected defect rate found in sort from 0 to 40, holding your other inputs fixed.

Cost of poor quality from ERP data

Optional: we can review your scrap, rework and reject postings and outline a cost of poor quality report from them.

Optional. The tool and every export work without this. No spam.

How to use the calculator

Enter the number of pieces that must be sorted, including stock, WIP and anything in transit. Set the sort rate per inspector from a trial or time study, the number of inspectors and the loaded labor rate. Estimate the defect rate from the original sample, then split defects between scrap and rework. The results show total labor hours, elapsed time with your team, and the cost of sorting, rework and scrap. The chart shows how total cost climbs with defect rate, which helps you plan for a worse case than the sample suggests.

  • Time a real sort to set the rate.
  • Include all suspect stock, not only the rejected sample.
  • Use loaded labor, not base wage.
  • Test higher defect rates on the chart.

The formulas

Sorting hours equal suspect quantity divided by the sort rate. Elapsed hours equal sorting hours divided by the number of inspectors. Sorting cost is sorting hours times labor rate. Defects equal quantity times defect percentage. Scrap quantity is defects times scrap share, and the remainder is reworked at the rework minutes per piece and rework rate. Total cost adds sort, rework and scrap cost. These are the visible costs only. Hidden costs such as line disruption, delayed shipments and management time usually push the true figure higher.

Reading the result and common mistakes

Use the total as an order of magnitude figure for a chargeback request or for the cost of quality report. Compare it with the cost of better detection upstream, such as a receiving inspection plan or a gauge at the machine. The common mistakes are using an optimistic sort rate, ignoring parts already in the customer's hands, and forgetting re-inspection after rework. Remember that sorting finds defects but does not remove the cause, so it should be paired with a corrective action.

Frequently Asked Questions

Is 100 percent sorting reliable?

Not fully. Manual visual inspection typically misses some defects, especially on long runs. For critical characteristics use gauging or automated inspection, and consider a second pass. Sorting is a containment step, not a permanent control.

Can I charge the supplier for sorting?

Only if your purchase terms or quality agreement allow it. Typical recoverable items include sorting labor, rework, scrap and freight. Keep time records and photos, and agree the rates with procurement before issuing a debit.

How do I choose the defect rate input?

Start from the rate found in the inspection sample, then run higher values with the chart, since samples may understate the real rate. If the defect is progressive, such as tool wear, the rest of the lot may be worse.

What does this leave out?

It leaves out expedite freight, production stoppage, overtime premiums, administrative effort, customer penalties and lost sales. For a full view, use a cost of quality model that includes prevention, appraisal, internal failure and external failure.

If you want cost of poor quality calculated from actual ERP reject, scrap and rework transactions, we can help set that up.