Skip to content
Shop | Excel system

Supplier Management System

Spend Pareto, scorecards, complaints, process audits, new parts, risks, total cost of ownership and development.

Screenshot of the Supplier Management System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup holds weights, point bands, class limits, segment thresholds and the status date.
  2. 03 Suppliers lists the supply base with segments. 04 Spend Pareto ranks the suppliers by volume and shows where 80 percent of the spend sits.
  3. 05 Scorecard holds the monthly scores, 06 Dashboard reads them for one month. 07 Complaints tracks every 8D against its deadlines.
  4. 08 Process Audits and 09 New Parts cover approval and launch. 10 Risks scores critical parts and single sources.
  5. 11 TCO compares the total cost of two sourcing options. 12 Development tracks targets of supplier development plans.
  6. 13 Self Check holds the 25 statements of the checklist with a profile chart. 14 Actions collects all actions with owner and date.

Definitions used in the workbook

  • Total cost of ownership: All cost of a part until it is used at your line: price, freight, customs handling, inventory carrying, quality cost and support.
  • Risk score: Impact times probability, each 1 to 5. 12 or more needs a written mitigation, 20 or more a management decision.
  • Audit result: Share of points reached. 90 percent or more approved, 80 to 89 percent with conditions, below 80 percent not approved.

Sheets in the workbook

  1. Start
  2. Setup
  3. Suppliers
  4. Spend Pareto
  5. Scorecard
  6. Dashboard
  7. Complaints
  8. Process Audits
  9. New Parts
  10. Risks
  11. TCO
  12. Development
  13. Self Check
  14. Actions

Who it is for

Purchasing managers who manage a supplier base strategically.

The method behind the numbers

This workbook is part of the Supplier Management toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every week.