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 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…
One rule of thumb suggests that no single customer should exceed 20-30% of total revenue, but this overlooks two crucial factors - gross margin and cash reserves. Our free calculator takes a simplified approach, using integer cents to eliminate rounding errors.
Inputs for the model include monthly revenue ($52,000), gross margin at 45% (4,500 basis points), other fixed monthly expenses ($22,500), bank balance ($48,000), and a safety reserve of $10,000.
The calculator computes gross profit (4.5% of revenue), monthly profit after expenses ($900), and the market share of each customer as a percentage of revenue. With four customers, the top 3 combined account for 60.6% of revenue, with one at 32.7%.
Profit today stands at $900/month, but if the largest customer - Northwind Retail - leaves, the business would face a loss of $6,750/month. Even after accounting for the safety reserve, this would leave $38,000 in cash to sustain operations for only 5.6 months (about 171 days).
The calculator demonstrates that relying on a single customer can be risky, as no single metric indicates vulnerability to customer loss. It's crucial to maintain diverse revenue streams and strong cash reserves to weather such scenarios.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.