Enter Supplier and Inspection Details
Example Data Table
| Supplier | Shipments | Compliant | Late | Doc Issues | Units | Defects | Audit | Final Score |
|---|---|---|---|---|---|---|---|---|
| Apex Components | 52 | 49 | 2 | 1 | 5200 | 21 | 92% | 96.20% |
| Bright Metals | 38 | 33 | 4 | 2 | 3800 | 44 | 88% | 88.79% |
| Crescent Plastics | 60 | 54 | 7 | 4 | 6000 | 90 | 81% | 80.05% |
Formula Used
Simple compliance rate measures how many inspected shipments met all checks:
Simple Rate (%) = (Compliant Shipments ÷ Total Shipments Inspected) × 100
Component rates convert inspection signals into comparable percentages:
- On-time Rate = (Total − Late) ÷ Total
- Documentation Pass = 1 − (Documentation Issues ÷ Total)
- Quality Pass = 1 − (Defective Units ÷ Units Inspected)
- Audit Rate = Audit Score ÷ 100
Weighted compliance score blends rates using your program weights:
Weighted Score (%) = (Σ(rate × weight) ÷ Σweights) × 100
Penalties subtract point impacts for nonconformances:
Final Score (%) = max(0, Weighted Score − (Minor×p₁ + Major×p₂ + Critical×p₃))
How to Use This Calculator
- Enter shipments inspected and how many were fully compliant.
- Add late shipments, documentation issues, and inspection unit counts.
- Provide audit score and NCR/finding counts for the same period.
- Optional: open Advanced Settings to tune weights and penalties.
- Press Submit to view results above the form instantly.
- Use the export buttons to download CSV or PDF evidence.
Coverage and Sampling Discipline
A reliable compliance rate starts with consistent coverage. Track total shipments inspected, then link units inspected to your sampling plan, such as AQL 1.0–2.5. When inspection coverage stays above 90% of inbound lots, trend comparisons become defensible. If sampling drops, the score can look better than reality. Use the period dates to align counts with supplier scorecards and prevent mixing late confirmations from another month.
Delivery Reliability Metrics
Late shipments directly reduce the on-time delivery rate, which carries a weight you can tune. Many programs set an on-time target of 98% for A suppliers and 95% for B suppliers. Document the “late” definition, for example arrival beyond agreed dock date plus one day. Use the penalty fields to reflect expediting cost impact when major delays trigger line stoppage or premium freight.
Quality Yield and Defect Signals
The quality pass rate converts defects into a clear percentage, but it also supports PPM analysis. Example: 35 defects in 5,000 units equals 7,000 PPM. Pair this with defect severity rules: cosmetic issues may be minor NCRs, while functional failures become major NCRs. If critical findings occur, raise the critical penalty to protect customers and highlight containment urgency.
Documentation and Traceability Controls
Documentation issues often hide downstream risk. Count missing COAs, incorrect labels, incomplete packing lists, or unapproved revision levels as doc issues. A documentation pass rate below 97% typically increases receiving time and blocks release. Use supplier name and period fields to keep records searchable for audits. When doc issues repeat, require updated control plans and proof of training at the supplier site.
Audit Readiness and Corrective Actions
Audit score adds process maturity context to transactional data. Keep audit methods consistent, such as ISO 9001 clause scoring or layered process audits. Track NCR closure time; many teams expect 30 days for minor and 14 days for major items. Use the final score band to decide escalation: extra audits, tighter incoming inspection, or dual sourcing. Export CSV and PDF to attach evidence to CAPA reviews. Review quarterly weight settings to reflect new risks, and compare suppliers using the same normalization rule so improvements reflect real operational control across product families.
FAQs
What does the final compliance score show?
It is the weighted compliance score minus NCR penalties, floored at zero. It summarizes delivery, quality, documentation, and audit performance in one percentage for the chosen period.
Do the weights need to total 100?
No. The calculator normalizes by the sum of weights. Use weights to reflect business impact, then keep them consistent across suppliers so comparisons stay fair.
Why track both simple rate and weighted score?
Simple rate counts fully compliant shipments only. Weighted score uses component rates, so you can see whether delays, defects, or paperwork drive performance changes.
How should I set penalty points for NCRs?
Start with minor 1, major 3, critical 5 points, then adjust based on risk and cost. Increase critical penalties when findings can affect safety, regulatory release, or customer downtime.
How often should supplier compliance be calculated?
Monthly works for high-volume suppliers, while quarterly fits lower volume. Use the same inspection rules each cycle to avoid score swings caused by changing definitions.
Can I use this for multiple plants or sites?
Yes. Run separate entries for each site and period, or keep site names in the supplier field. Export reports to build a site-by-site compliance dashboard.