• Preview of Supplier Concentration and Dependency AnalysisExcel workbook preview

Procurement Risk, Fraud and Compliance

Supplier Concentration and Dependency Analysis

$17.99 Free XLSX
Excel workbook · 15 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.