Free quality tools from Aegis: templates, kits and guides you can use today →
Aegis Technologies Inc.

Resource Library/Supplier Quality and Supply Chain/Supplier Concentration Risk Assessment

Workbook · AQL-C15

Supplier Concentration Risk Assessment

See how much of your business rests on a few suppliers: share of spend, part numbers with no alternate, revenue that depends on each source, time to replace it, and the sub-tier sources your suppliers quietly share.

Download the ExcelDownload the fillable PDF
  • Excel
  • fillable PDF
  • Worked example
  • Your logo on it
  • Aegis Insights
Page 1 of the Supplier Concentration Risk Assessment

Page 1 of the PDF. Every resource includes a fully worked example.

Part of the Supplier Performance and Recovery Kit16 of 19← Supplier Change Notification RegisterSpecial Process Supplier Control Matrix →

The problem it solves

Most supply risk reviews rank suppliers by spend, and the risky ones are often not near the top. A $300,000 anodizer can touch 60 percent of what you ship; two approved machining suppliers can send their heat treat to the same shop; a forging die can take nine months to duplicate. None of that shows in a spend report. This workbook looks at concentration five ways (share of spend, part numbers with no qualified alternate, share of revenue using the supplier's parts, weeks to qualify an alternate, and shared sub-tier or material sources), counts the flags against thresholds you set, shows concentration by commodity, and tracks the mitigation.

Who uses it

Supply chain and purchasing leaders, supplier quality managers, and the executive who owns risks and opportunities.

When

Once a year as part of business planning and management review, before awarding a large new program, and after any supplier failure, acquisition or exit.

Free to use, change and copy, in your own organization or with your clients; add your own logo, keep the Aegis credit. Part of: Supplier Performance and Recovery Kit. Clause references: 6.1, 8.4.1 (numbers only; use your own licensed copy of the standard).

Aegis Insights inside. Wherever this resource gives our own guidance, it is labeled Aegis Insights, so you always know what is our experience and what a standard or your customer requires.

A management aid, not certification or a registrar audit. Using it does not by itself show conformity to AS9100D or any other standard.

How to put it to work

Chapters of our free guides that use this tool.

  1. The kit at a glanceThe Supplier Performance and Recovery Kit Handbook, chapter 2
  2. The supplier control workflowThe Supplier Performance and Recovery Kit Handbook, chapter 3
  3. Rating risk and setting the level of controlThe Supplier Performance and Recovery Kit Handbook, chapter 6
  4. Running the systemThe Supplier Performance and Recovery Kit Handbook, chapter 13
  5. Quick referenceThe Supplier Performance and Recovery Kit Handbook, chapter 17
  6. Where the kit touches AS9100DThe Supplier Performance and Recovery Kit Handbook, chapter 18

Related resources

  • Workbook

    Supplier Business Continuity Assessment

    Find out which suppliers could stop your deliveries, how long you could keep shipping without them, and how ready they are to recover: ten plain questions, an exposure gap in weeks, and the actions that close it.

    Excel · PDFFree download
  • Workbook

    Supplier Risk Assessment Matrix

    Rate every supplier on how much a failure would hurt and how likely one is, with eight plain factors and weights you control, then let the rating set how closely you watch each one.

    Excel · PDFFree by email
  • Workbook

    Approved Supplier List Register

    Keep one controlled list of who you may buy from, for exactly what, on what conditions, with the certificate and evaluation dates watched for you and every status change passed on to purchasing and receiving.

    Excel · PDFFree download
  • Workbook

    Supplier Performance Scorecard

    Score every supplier each period on delivery, quality, responsiveness and documentation, with plain counts and weights you control, see who is slipping, and decide what to do about it.

    Excel · PDFFree by email
  • Workbook

    Risks and Opportunities Register

    One register for the quality system's risks and opportunities: each written as 'if ... then ...', rated on scales you set, treated with an owned action, re-rated afterward and checked, with a heat map and a summary for management review.

    Excel · PDFFree download
  • Workbook

    Special Process Supplier Control Matrix

    Show that whoever performs each special process on your parts, including your suppliers' own sources, is qualified for that exact process: scope, specifications, customer approvals, expiry dates, certificates, performance and oversight on one line.

    Excel · PDFFree by email

Need more than one resource, or not sure where to start? Book a complimentary 30-minute Aegis Quality Guidance Call. We'll find the tools that fit your situation and a sensible place to start. No sales pressure, no obligation.

These tools help you run the work by hand. When you want the whole picture of your quality system from the records you already keep, that's what the AeroAssure Audit Defense Pack and the IA9100 Transition Gap Analysis do.