
How it works
- 02 Setup holds weights, point bands, class limits, segment thresholds and the status date.
- 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.
- 05 Scorecard holds the monthly scores, 06 Dashboard reads them for one month. 07 Complaints tracks every 8D against its deadlines.
- 08 Process Audits and 09 New Parts cover approval and launch. 10 Risks scores critical parts and single sources.
- 11 TCO compares the total cost of two sourcing options. 12 Development tracks targets of supplier development plans.
- 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
- Start
- Setup
- Suppliers
- Spend Pareto
- Scorecard
- Dashboard
- Complaints
- Process Audits
- New Parts
- Risks
- TCO
- Development
- Self Check
- 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.