Calculator Inputs
Example Data Table
| Supplier | Orders | On-time | In-full | Quality | Docs | Avg delay | Critical | Score* |
|---|---|---|---|---|---|---|---|---|
| Apex Components | 50 | 46 | 47 | 48 | 49 | 0.8 | 0 | 92.30 |
| Nova Packaging | 40 | 34 | 36 | 38 | 37 | 1.7 | 1 | 79.10 |
| BlueRiver Metals | 30 | 29 | 27 | 28 | 28 | 0.2 | 0 | 93.90 |
| Vertex Fasteners | 25 | 20 | 23 | 21 | 24 | 2.4 | 0 | 74.80 |
| Orion Logistics | 18 | 15 | 16 | 17 | 16 | 1.1 | 2 | 63.20 |
*Scores shown are illustrative and depend on your weights and penalties.
Formula Used
- On-time rate = (On-time deliveries ÷ Total orders) × 100
- In-full rate = (In-full deliveries ÷ Total orders) × 100
- Quality acceptance rate = (Quality accepted ÷ Total orders) × 100
- Documentation compliance rate = (Documentation compliant ÷ Total orders) × 100
Weighted score = (On-time rate × On-time weight + In-full rate × In-full weight + Quality rate × Quality weight + Docs rate × Docs weight) ÷ 100
If weights do not total 100, the calculator normalizes them to keep scoring consistent.
Final score = clamp(Weighted score − (Avg delay days × Penalty per delay day) − (Critical incidents × Penalty per critical), 0, 100)
How to Use This Calculator
- Enter total orders for the period you want to assess.
- Fill in counts for on-time, in-full, quality accepted, and documentation compliant deliveries.
- Optionally add average delay days and critical incidents to reflect risk.
- Adjust weights to match your quality policy and category criticality.
- Click calculate, then download CSV or PDF for your records.
FAQs
1) What does the final score represent?
It’s a 0–100 rating combining delivery reliability, completeness, quality acceptance, and documentation accuracy, minus optional penalties for delays and critical incidents.
2) Do my weights need to add up to 100?
No. The calculator automatically normalizes weights so the score stays comparable across suppliers, even if you enter totals like 50 or 200.
3) How should I pick penalty values?
Start small, then calibrate using historical performance. Use larger penalties for regulated parts, safety risks, or production-critical materials.
4) What if some orders are split or partially received?
Count an order as in-full only when the required quantity is fully received. If your system tracks line items, you can adapt totals to lines instead.
5) Should “quality accepted” include rework and concessions?
Use your internal rule. Many teams count concessioned lots as not accepted to encourage prevention, while others track them separately as a penalty.
6) How can I compare multiple suppliers fairly?
Use the same weights, definitions, and period length. Keep denominators consistent, and avoid mixing emergency shipments with normal replenishment cycles.
7) Is this score suitable for supplier audits?
Yes, as a supporting KPI. Pair it with evidence like delivery logs, inspection records, corrective actions, and a clear definition of each metric.