The Vendor Scorecard: Supplier Comparison & Review System

In the worked example, the cheapest quote scores 3.00 of 5 and — once its rejects and late deliveries are priced — costs $6,457 more per year than the incumbent. The "expensive" premium vendor wins the scorecard outright and lands within $284 of the incumbent's total cost. The quote was the least useful number on the table.

How it works

• The Scorecard — six real metrics per supplier, converted to 1–5 scores through published anchors you can edit and defend, weighted your way → PREFERRED / APPROVED / CONDITIONAL / EXIT PLAN
• The True Cost of Cheap — spend × price index + rejects at their real multiple + late orders at their real cost = total cost of ownership, per vendor, plus the cheap-quote premium in one cell
• The Review Rhythm — the 30-minute quarterly review (send them their scorecard a week ahead; vendors improve what's measured), the two-supplier 70/30 rule, the renegotiation script built on evidence instead of bluff, and the two-quarters-below-3.0 switching rule

Built for

Whoever does the buying: machine and fab shops · restaurants and their purveyors · construction · retail buyers · any purchasing manager tired of arguing feelings against quotes.

What you get

One .xlsx file, four tabs, instant download. Excel, Google Sheets, Apple Numbers, LibreOffice. No macros, no subscription. Anchors, weights and multipliers all editable and visible.