-
Excel workbook preview
Procurement Risk, Fraud and Compliance
Supplier Concentration and Dependency Analysis
3 downloads per free account, no card needed.
Who this is for
A head of procurement runs it when finance or the board asks how exposed the organisation is to a handful of suppliers, and which way the dependency runs.
What is inside
- 19 sample suppliers in 6 categories with spend, revenue, alternatives and switching time
- Share of category spend, share of total spend and cumulative share calculate live
- Our share of each supplier's revenue flags suppliers that depend on us
- Category sheet: supplier count, top supplier share and HHI with a rating
- Dependency rating per supplier from share, alternatives and switching time
- Bar chart of the top supplier share in each category
How to use it: Paste 12 months of spend by supplier and category from your spend report, add the supplier revenue and switching data, and review the High rows with each category manager.
Files & formats
- XLSXsupplier-concentration-and-dependency-analysis.xlsx15 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



