Vendor Evaluation Scorecard (Selection & Performance)

About the Vendor Evaluation Scorecard (Selection & Performance)

Two jobs in one scorecard. Selection: choose between suppliers on weighted criteria — price, quality, delivery, service, financial stability, compliance, or your own — scored on a scale of 0–5, 0–10 or 0–100, or entered as measured values (a price or a lead time where lower is better, a capacity where higher is better), which are normalised. You get a score out of 100 for each supplier, the ranking, and a sensitivity check: for every criterion, how far its weight can move before another supplier wins, worked out exactly.

Performance: open your purchase-order lines (with due dates) and goods receipts for a period, and each supplier gets its on time, in full and on-time-in-full (OTIF) rates, its average delay, its rejection rate and, when both files carry prices, its price variance — then a score and an A, B or C rating on the weights and limits you set. Each figure shows the definition used, because companies measure OTIF differently: grace days, early deliveries, a tolerance for small shortfalls and counting per line or per order are all yours to set.

Without a pass the scorecard is a free preview: the first rows of each ranking and a watermarked chart show, and the sensitivity check is hidden; the PDF scorecards, the workbooks, the ratings CSV and the summaries unlock with a Premium pass. Your scores, files and settings stay on this device.

Common uses

• A purchase committee choosing a supplier with criteria and weights agreed before the scores are given.
• Checking whether the chosen supplier would still win if price mattered a little more, or quality a little less.
• Quarterly supplier reviews: OTIF, rejections and price variance per supplier, with the definitions written down.
• Preparing for a supplier meeting with the late and short lines in hand.

How the selection score is worked out

• Normalising: a score ÷ the top of the scale; for “lower is better”, the lowest value ÷ the supplier’s value; for “higher is better”, the supplier’s value ÷ the highest value. Every criterion then counts from 0 to 1.
• Weighted score = Σ (weight × normalised value) ÷ Σ weights × 100.
• Sensitivity: each criterion’s weight moves from 0% to 100% of the total while the other weights keep their proportions. Each supplier’s score is then a straight line in that weight, so the points where another supplier overtakes the winner are solved exactly. A winner is called robust when every weight can move 10 points either way without changing it.

How performance is measured

• On time: the first delivery against a PO line arrives by its due date (plus any grace days), and not earlier than you allow.
• In full: everything accepted against the line, whenever it came, reaches the quantity ordered (less your tolerance).
• OTIF: the quantity accepted by the due date (plus grace) reaches the quantity ordered (less your tolerance). Rejected goods are not delivered goods.
• Delay: days from the due date to the receipt that completed the line.
• Rejection rate: quantity rejected ÷ quantity received. Price variance: (price paid − PO price) × quantity, over PO price × quantity.
• Score: weights × OTIF%, quality (100 − rejection%) and price (100 − variance% above the PO), from 0 to 100; grades A and B from the limits you set (90 and 75 to begin with), C below. Without prices, the price weight is left out.

Limitations

• Selection scores are the evaluators’ judgement: the scorecard makes them consistent and visible, not objective.
• Performance needs a due date on every PO line and a date on every receipt; receipts are matched to lines by PO number and item.
• Partial deliveries are counted by quantity; units of measure are not converted.
• Up to 30 suppliers and 20 criteria in a selection.

Privacy

On this device; its files download once

Your scores and files stay in this browser on this device; nothing is uploaded.