DATA & ANALYSIS

Supplier Spend Concentration & HHI Calculator

Rank a comparable supplier-spend dataset and calculate concentration, top-three exposure, and an equivalent equal-share supplier count.

Supplier spend concentration calculator

Rank a comparable supplier-spend dataset and calculate concentration, top-three exposure, and an equivalent equal-share supplier count.

How it works
supplier, annual_spend1,000 rows maximum

Adjust the example values to match your scenario.

YOUR RESULT LIVE CALCULATION
Purchasing-spend concentration
3,000/ 10,000 HHI
NO AUTOMATIC RISK THRESHOLDS
Largest supplier share40%
Top-three share90%
Total entered annual spend
$600,000
Active suppliers / CSV rows
4 / 4
Largest supplier spend share
40%
Top-three supplier spend share
90%
Equivalent equal-share suppliers
3.33

Purchasing-spend shares only, not a competition-law market. Equal-spend ties retain CSV order. Shared links exclude the dataset.

Supplier spend distribution

4 rows
SupplierAnnual spendSpend %Cumulative %
Supplier A240,0004040
Supplier B180,0003070
Supplier C120,0002090
Supplier D60,00010100
BEHIND THE NUMBER

How the calculation works

The HHI arithmetic is applied to your purchasing-spend distribution, not a competition-law market. One supplier gives 10,000; equal shares across four suppliers give 2,500. The default 40%, 30%, 20%, and 10% shares give HHI 3,000 and an equivalent equal-share count of 3.33. Zero-spend rows are retained in the table but not counted as active suppliers.

Spend share = supplier spend / total; HHI = sum((share x 100)^2); equivalent equal-share suppliers = 10,000 / HHI

When this calculation helps

Spend shares and concentration describe how the entered purchasing value is distributed among suppliers. Use a consistent period, currency, and supplier-entity definition.

Check the interpretation

Several legal entities can share a parent or a common production site, while a small-spend supplier may provide a critical component. Spend concentration is not the same as dependency risk or alternative capacity. Review those relationships before interpreting diversification as resilience.

Use a complete period and one currency, and consolidate related supplier entities appropriately before import. This is not an antitrust assessment, supplier failure forecast, or sourcing recommendation. Spend shares alone do not capture substitutability, geography, materials, or common ownership.

US DOJ: HHI arithmetic definition (not risk thresholds)

Good to know

Does the tool apply regulatory HHI thresholds?

No. Purchasing-spend concentration is not a competition-law market analysis. No regulatory or automatic risk classification is applied.

Does the CSV appear in a shared link?

No. The dataset stays in your browser and is excluded from shared URLs. The optional public calculation API processes only data deliberately posted to it.