BRISK ATLAS / GUIDES
Supplier scorecard guides
Practical guides to building and using supplier scorecards. Each one works through real calculations made with the Brisk Atlas scorecard, and the examples can be downloaded and imported into it.
- Supplier scorecard template (Excel, CSV and printable)Excel workbook with formulas, a blank CSV and a printable PDF.
- Supplier scorecard examples: three filled-in samplesPackaging, contract manufacturing and freight, scored and explained.
- Supplier scorecard metrics: formulas and 1–5 scoringOTIF, defect PPM, responsiveness, invoicing and price, with formulas.
- Supplier evaluation criteria: what to score and what to gateMust-haves versus weighted criteria, with a worked counter-example.
- Weighted scoring model: formula, example and ExcelThe formula, a project selection example and the Excel version.
- Vendor scorecard: running a quarterly vendor reviewA worked quarterly review of three current vendors.
Downloads
- Supplier scorecard template (Excel)Formulas for weighted scores, must-have status and rank; blank and example sheets.
- Printable scorecard (US Letter PDF)Also as A4 and a starter CSV.
- Packaging supplier example (JSON)Import into the scorecard with Import JSON.
- Contract manufacturer example (JSON)Import into the scorecard with Import JSON.
- Freight forwarder example (JSON)Import into the scorecard with Import JSON.
- Quarterly vendor review example (JSON)Import into the scorecard with Import JSON.
- Project selection example (JSON)Import into the scorecard with Import JSON.
The method
The weighted point method for supplier evaluation explains the calculation the scorecard uses: must-haves first, weights that total 100%, one 1–5 scale, and a check of how far each weight can move before the winner changes.