Supplier concentration risk (HHI) and expected loss
From the suppliers’ shares of the buy counts the Herfindahl–Hirschman index (HHI) and the effective number of suppliers, the expected margin loss if the largest fails (probability × share × margin × share of the season without supply) and compares it with the cost of a second source: the price surcharge on the moved volume.
At a glance
- What question does it answer?
- How concentrated the buy is, what a failure of the largest costs and whether a second source pays off.
- What data is needed?
- Supplier shares.
- How to read the result?
- HHI and the effective number of suppliers, then the loss against the cost of a second source. Example on the default values: HHI: 0.3; Effective number of suppliers: 3.33; Share of the largest: 45%; Expected margin loss: RUB 553,846. The figures are illustrative: enter your own to see your result.
Why and how to reason
The share of the largest supplier is not everything: what matters is what a failure costs and how long a replacement takes. In the example HHI is 0.300, the effective number of suppliers 3.33, the expected loss 0.55 m RUB. A second source pays off if it costs less than this loss.
When to use it
Apply when revising the supplier base and before launching a new collection at one factory.
How to read the result
Look at HHI and the effective number, then the loss against the cost of a second source and the break-even surcharge.
Common mistakes
They count risk by share only, not by the switching time, and treat a second source as free.
What data is needed?
- Supplier shares.
- Probability and duration of failure, margin.
- The second source surcharge.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Supplier 1 | % | 45 | Share of the buy by value. The shares are rescaled to 100%; an empty field is zero. The example value is illustrative. |
| Supplier 2 | % | 25 | Share of the buy by value. The shares are rescaled to 100%; an empty field is zero. The example value is illustrative. |
| Supplier 3 | % | 15 | Share of the buy by value. The shares are rescaled to 100%; an empty field is zero. The example value is illustrative. |
| Supplier 4 | % | 10 | Share of the buy by value. The shares are rescaled to 100%; an empty field is zero. The example value is illustrative. |
| Supplier 5 | % | 5 | Share of the buy by value. The shares are rescaled to 100%; an empty field is zero. The example value is illustrative. |
| Supplier 6 | % | 0 | Share of the buy by value. The shares are rescaled to 100%; an empty field is zero. The example value is illustrative. |
| Probability of failure per season | % | 10 | Your estimate: a missed delivery, sanctions, a closed port. There is no single norm. The example value is illustrative. |
| Weeks without supply | weeks | 8 | How many weeks switching to a replacement takes: count the time, not only the share. The example value is illustrative. |
| Weeks in the season | weeks | 26 | The length of the period the margin refers to. The example value is illustrative. |
| Margin for the period | ₽ | 40,000,000 | Gross margin of goods that depend on this source over the season or the year. The example value is illustrative. |
| Purchases from the largest for the period | ₽ | 120,000,000 | For the surcharge on the moved volume. If all purchases are 120 m and the largest has 45%, enter 54 m. The example value is illustrative. |
| Part of the largest supplier’s volume you move | % | 50 | The share of volume you keep at a second source permanently. The example value is illustrative. |
| Second source surcharge on the price | % | 3 | How much more expensive than the largest, including qualification and logistics. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| HHI | the sum of squared supplier shares; effective number = 1 ÷ HHI |
| Expected loss | probability of failure × share of the largest × margin × (weeks of failure ÷ weeks of the season) |
| Second source | cost = surcharge × purchases from the largest × share moved; benefit = loss × share moved |
| Decision | diversify if the benefit exceeds the cost |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- HHI
- 0.3The sum of squared shares (as fractions of one).
- Effective number of suppliers
- 3.331 ÷ HHI: that many equal suppliers would give the same concentration.
- Share of the largest
- 45 %
- Expected margin loss
- 553,846 ₽Probability × share × margin × (weeks of failure ÷ weeks of the season).
- Loss removed by a second source
- 276,923 ₽
- Cost of a second source
- 810,000 ₽Surcharge × moved volume.
- Decision
- does not pay off yet
- Break-even surcharge
- 1.03 %
- HHI after the move
- 0.199
Data as a table
| Measure | Share |
|---|---|
| 1 | 45 |
| 2 | 25 |
| 3 | 15 |
| 4 | 10 |
| 5 | 5 |
| 6 | 0 |
Suppliers’ contribution to HHI
| Supplier | Share | Square | Contribution to HHI |
|---|---|---|---|
| Supplier 1 | 45 % | 0.2025 | 67.5 % |
| Supplier 2 | 25 % | 0.0625 | 20.8 % |
| Supplier 3 | 15 % | 0.0225 | 7.5 % |
| Supplier 4 | 10 % | 0.01 | 3.3 % |
| Supplier 5 | 5 % | 0.0025 | 0.8 % |
| Supplier 6 | 0 % | 0 | 0 % |
At this surcharge a second source costs more than the expected loss (810,000 ₽ vs 276,923 ₽): it does not pay off; it would pay off at a surcharge of no more than 1.03 %.
The model treats the second source as independent: it does not fail together with the largest and manages to take the moved volume. A rare but heavy failure and insurance cases are poorly shown by the expected loss: look at the worst case too.
What to do with the result: if HHI is high and switching takes more than a month, qualify a second supplier in advance for a small volume. A typical mistake: counting risk only by share, not by the replacement time.
Nuances and limits
- Counting risk by share only.
- Ignoring the switching time.
- Treating a second source as free.