Supplier NCR Rate Calculator

• Inspection coverage (%) = (Inspected receipts ÷ Total receipts) × 100
• NCR rate (%) = (NCR count ÷ Selected denominator) × 100
• NCR per 100 receipts = (NCR count ÷ Total receipts) × 100
• Nonconforming unit rate (%) = (Nonconforming units ÷ Units received) × 100
• DPPM = (Nonconforming units ÷ Units received) × 1,000,000
• Weighted NCR points = (Minor×w₁) + (Major×w₂) + (Critical×w₃)
• Weighted points per 100 receipts = (Weighted points ÷ Total receipts) × 100

1. Enter receipts, inspected receipts, and NCR count for the period.
2. Add units received and nonconforming units to calculate defect metrics.
3. If you track severity, fill Minor/Major/Critical and adjust weights as needed.
4. Set targets to automatically flag suppliers that need action.
5. Click Calculate, then export CSV or PDF for reporting.

Why NCR rate matters

A supplier NCR rate turns scattered findings into a comparable performance signal. Many teams flag suppliers above 2.0% NCR rate or above 5,000 DPPM, then trigger containment, 8D, or audits. Use this calculator to normalize by receipts or units so low‑volume suppliers are not unfairly ranked. Pair the rate with inspection coverage; higher coverage can expose missed defects.

Choosing the right denominator

Receipt-based rates work well for lot-controlled materials, where each shipment is a discrete risk event. If inspection is partial, switching the denominator to inspected receipts highlights what was actually checked. In AQL sampling, inspected receipts may be 30–60% of arrivals; note the plan. Unit-based denominators are better for high-volume parts where a single NCR can contain many defects. Keep the denominator consistent when comparing suppliers month to month.

Severity weighting for prioritization

Counting NCRs alone can hide business impact. A mix of Minor, Major, and Critical NCRs lets you score severity using weights such as 1/3/5. For example, 2 Minor, 1 Major, and 1 Critical equals 2×1 + 1×3 + 1×5 = 10 points. Weighted points per 100 receipts supports supplier segmentation and audit planning. If critical share exceeds 10%, escalate and tighten inspection.

Targets and trend monitoring

Targets should reflect product risk and incoming inspection strategy. Set NCR%, DPPM, and weighted-point limits to auto-label performance as On Track or Needs Action. Add prior-month data to compute a rolling NCR/100 average; smoothing helps confirm whether corrective actions are working. Review trend shifts after engineering changes, new tooling, or supplier process moves. Use the risk score to prioritize audits, focusing first on high-risk suppliers and parts weekly.

Linking quality to COPQ

Rates drive decisions when they connect to cost. Populate rework, scrap, returns, downtime, and administration to estimate COPQ for the period. COPQ per receipt highlights hidden burdens on receiving and production teams. For example, COPQ 150,000 across 300 receipts equals 500 per receipt, enabling clear payback estimates. When two suppliers have similar NCR rates, higher COPQ signals deeper process instability and a stronger business case for improvement projects.