Audit Inputs
Formula Used
1) Weighted score combines each criterion score with its weight.
If you turn off normalization, the calculator uses Σw = 100 and requires weights to total 100.
2) Penalty points reduce the weighted score based on findings.
3) Final score is bounded to avoid negative results.
A critical finding overrides the grade to D for a conservative decision.
Grading Bands
| Grade | Score Range | Typical Decision | Corrective Action Due |
|---|---|---|---|
| A | ≥ 90 | Approved | ~90 days (routine) |
| B | 80–89.99 | Conditional approval | ~30 days |
| C | 70–79.99 | Probation | ~14 days |
| D | < 70 | Disapproved | Immediate / stop-use |
How to Use This Calculator
- Enter supplier details to label your audit record.
- Confirm your Pass Threshold and weight handling choice.
- Update criterion names, weights, and scores to match your scorecard.
- Add findings counts and penalties for your audit program rules.
- Click Calculate Score to view the result above.
- Use Download CSV or Download PDF to archive outcomes.
Example Data Table
This sample shows a typical weight distribution and scoring snapshot for a mid-risk supplier.
| Criterion | Weight (%) | Score | Weighted Contribution |
|---|---|---|---|
| Quality Management System | 20 | 85 | 17.00 |
| Incoming & Process Quality | 25 | 88 | 22.00 |
| Delivery Performance | 20 | 82 | 16.40 |
| Traceability & Records | 15 | 90 | 13.50 |
| Regulatory & Compliance | 10 | 92 | 9.20 |
| Continuous Improvement | 10 | 80 | 8.00 |
| Total | 100 | — | 86.10 |
If penalties total 6 points, the final score becomes 80.10 (Grade B).
Standardized Scorecard Setup
Define 5–10 audit criteria that reflect your purchase risk, product complexity, and customer requirements. Common buckets include QMS, process control, delivery, traceability, compliance, and improvement. Assign a weight to each bucket so the total equals 100%, or enable normalization to accept small rounding gaps. Keep criterion scores on a 0–100 scale so different sites and auditors compare cleanly. Use scoring anchors like 100 best practice and 70 minimum control.
Weighting and Normalization Control
Weights represent business impact, not effort. For example, a critical part supplier may use 25% for process quality and 20% for delivery, while a low-risk supplier may reverse those numbers. Normalization converts each weight to wᵢ/Σw, which protects the final score when teams add or remove criteria during program changes. If your weights sum to 98 or 103, normalization preserves proportional intent without forcing rework mid-audit.
Findings Penalty Discipline
Nonconformities translate audit observations into measurable risk. Many programs start with 5 points per major, 2 per minor, and 1 per observation. If a supplier has 2 majors and 3 minors, the penalty is (2×5)+(3×2)=16 points before observations. Escalate when repeated majors occur in the same clause. This discourages “high scores with serious findings” and supports fair escalation across auditors.
Interpreting Grades and Risk
Use score bands to align actions: A (≥90) for approved status, B (80–89.99) for conditional approval, C (70–79.99) for probation, and D (<70) for disapproval. Pair grade with a pass threshold, such as 80, to trigger a formal corrective action request. Link risk language to your controls, for example Low for A, Medium for B, Elevated for C, and High for D. A critical finding should force a stop-use decision until verification.
Using Trends for Improvement
Track the final score per quarter and plot penalties separately from weighted performance. A rising weighted score with stable penalties indicates system maturity; a flat score with increasing penalties indicates containment without root cause. Review top three low-scoring criteria, assign owners, and set due dates based on grade (90, 30, 14, or immediate days). Use rolling averages to reduce one-off noise and highlight sustained improvement. Export CSV/PDF to keep evidence ready for formal management review.
FAQs
1) What pass threshold is commonly used?
Many programs use 80 as the pass threshold because it aligns with a “B” level result. Adjust it to your commodity risk, customer requirements, and sourcing strategy, then keep the threshold consistent across suppliers for fair comparison.
2) Do weights have to total 100?
If auto-normalize is off, yes—weights must equal 100 to calculate correctly. With normalization on, any positive total works and each weight is scaled proportionally, which helps when scorecards are revised or rounded.
3) How can I score criteria consistently across auditors?
Use a short rubric for each criterion with defined evidence. For example: 100 = documented, implemented, verified; 85 = implemented with minor gaps; 70 = basic control with recurring issues; below 70 = ineffective control.
4) How should penalty values be selected?
Start with common settings like 5 points per major, 2 per minor, and 1 per observation, then calibrate using past audit outcomes. If majors rarely occur, increase the major penalty to reflect real business impact.
5) When should a critical finding be applied?
Apply it for safety, legal, or systemic failures that require immediate containment. The calculator forces the grade to D, flags the risk as critical, and supports a stop-use decision until verification is completed.
6) Can this calculator support supplier performance monitoring?
Yes. Run it for initial qualification and periodic reviews, export CSV/PDF, and trend the final score, weighted score, and penalties separately. Use the lowest-scoring criteria to target improvement plans and verify effectiveness.