Dev.to WebDev 🛠 Dev 👁 0 📖 1 min read

Customer concentration in integer cents: share, HHI and runway if one customer leaves

FREE tool, no sign-up: https://gettidycents.com/tools/customer-concentration-calculator "Don't let one customer be more than 20–30% of revenue" is a rule of thumb. It ignores the two things that decide whether losing th

FREE tool, no sign-up: https://gettidycents.com/tools/customer-concentration-calculator

"Don't let one customer be more than 20–30% of revenue" is a rule of thumb. It ignores the two things that decide whether losing that customer hurts: your margin and your cash. Here is the small model behind our free calculator, done in integer cents so nothing drifts.

Inputs (monthly, in cents)

const revenueTotal = 5_200_000;   // $52,000 total monthly revenue
const marginBp    = 4_500;        // 45.00% gross margin, in basis points
const otherOut    = 2_250_000;    // $22,500 every other monthly outflow
const cash        = 4_800_000;    // $48,000 in the bank
const reserve     = 1_000_000;    // $10,000 safety reserve
const customers = [
  ['Northwind Retail', 1_700_000],
  ['Harbor Clinics',     850_000],
  ['Alder & Co',         600_000],
  ['Kestrel Foods',      450_000],
];

The four numbers

const grossProfit = r => Math.round(r * marginBp / 10_000);
const profitToday = grossProfit(revenueTotal) - otherOut;          // 90_000 -> $900

const shareBp = r => Math.round(r * 10_000 / revenueTotal);        // 3_269 -> 32.69%
const hhi = customers.reduce((s,[,r]) => {                          // sum of squared % shares
  const p = r * 100 / revenueTotal; return s + p * p; }, 0);        // ≈ 1,544

for (const [name, r] of customers) {
  const after = profitToday - grossProfit(r);                        // Northwind: -675_000 -> -$6,750
  const buffer = cash - reserve;                                     // 3_800_000
  const months = after < 0 ? buffer / -after : Infinity;             // 5.63 months
  console.log(name, after / 100, months.toFixed(1));
}

Result for the sample: the largest customer is 32.7% of revenue, top-3 is 60.6%, HHI 1,544. Profit today is $900 a month. If Northwind leaves, profit becomes −$6,750 a month and the $38,000 above the reserve lasts 5.6 months (171 days). In this sample every one of the four customers would push the business into a loss on its own — the share alone never tells you that.

Why integer cents

Shares and runway are ratios, so they are computed once at the end from exact integer inputs. Money totals never pass through floats, so 0.1 + 0.2 style drift cannot creep into a "−$6,750" that should be exact.

The free version runs in your browser; nothing you type is sent or stored. It is one of the tools for running your business at Tidy Cents — fixed, tested formulas, every result shows its working, any currency.

What threshold do you use for "too dependent on one customer"?

📰 Read the original article on Dev.to WebDev

Originally published by Dev.to WebDev. Aggregated on AIWithGhost for educational purposes — full credit and traffic to the original publisher.