Customer Concentration Risk Dashboard: Surfacing the Numbers (Simply Explained)

The Two Numbers He Kept In His Gut

I worked with a distributor who carried two scary numbers around in his head for years. He had never seen either one written down.

The first: his top three customers made up 79% of his revenue. The second: he resold six products from suppliers he had no contracts with. No paperwork. Nothing stopping those suppliers from walking away tomorrow.

He knew both facts. Ask him over a beer and he'd nod and say, "yeah, I lean on those big accounts" and "yeah, I should lock up that supplier." But he'd never seen the two numbers side by side, in actual dollars. They lived as vague worries, the kind you push to next quarter every quarter.

Here's the thing about a dashboard like this: the math is easy. Dividing one number by another is grade-school stuff. The real value is that it forces you to look at the number you've been avoiding.

Why Smart Owners Avoid Their Scariest Numbers

This owner wasn't dumb. He built a real business. He avoided these numbers because nothing forced him to look.

The big accounts paid on time. The suppliers kept delivering. Day to day, nothing screamed danger. Why go poke the thing that might ruin your week?

That's the trap. Your gut tracks the last few months, and the last few months were fine. It doesn't run worst-case scenarios.

So I asked him: what happens if you lose your number two account? He said, "that'd hurt." Hurt is a feeling. Feelings are easy to defer.

Then I showed him the number. Account two was 31% of revenue. Lose it, and a third of the business disappears overnight. You don't defer 31%.

That's where good software earns its keep. Not the sci-fi version where AI "transforms" your company. The boring, useful version: it puts the scary number on your screen, in red, every time you log in, so you can't ignore it anymore.

I've built more than 15 of these systems across my own fashion brand and client work. The most valuable ones almost always do this. They surface the thing you'd rather not face.

Building the Dashboard

The build was simple. I put a small panel on the home screen of his customer system. It ranked his accounts by revenue, showed each one as a percentage of the total, and turned colors based on risk.

Green if his top three were under 40% of revenue. Yellow in the danger zone. Red above 60%. His was deep red the day it went live.

Each account broke out individually. Number one at 27%, number two at 31%, number three at 21%. Then a long list of small accounts adding up to the last 21%.

The most important decision wasn't the math. It was putting this on the home screen, not buried in a report. I've watched too many businesses pay for fancy "analysis" that lives in a PDF nobody opens after the kickoff meeting. A risk you have to go hunting for is a risk you'll forget.

One thing I want to be clear about: there's no AI guessing on these numbers. Revenue divided by total revenue is just division. I don't want AI anywhere near a figure that has to be exactly right. The software's job here was simple: pull the numbers together, color the scary one red, and put it where he'd see it every morning.

The Supplier Problem Was Worse

The customer numbers were scary. But the scariest number was on the supplier side.

This distributor's whole advantage, the reason customers came to him at all, was access to six specific products from six specific suppliers. That was his edge. It's why the big accounts stayed.

And there were no contracts. Nothing on paper stopping any of those six suppliers from selling directly to his customers, or signing up his competitor next week.

The thing that made his business special was completely exposed. That happens a lot. The thing that makes you special often grew out of a handshake, not a contract.

It got worse when we looked closer. Five of the six suppliers had a backup option. If they walked, he could find a similar product somewhere else. Painful, but survivable.

One supplier had no backup at all. Their product met specs his customers required, and nobody else could match it. If that supplier went direct, a chunk of his catalog simply vanished, with no replacement.

He knew this supplier was "important." But "important" and "this one relationship holds up the whole business" are very different statements. One you can ignore. The other you can't, once you've seen it on paper.

Putting a Dollar Figure on Each Supplier

So I did the same thing on the supplier side. For each one, I calculated how much revenue disappears if they walk.

That move turns a vague worry into a number you act on. "That supplier is important" became "$1.4 million of revenue depends on this relationship, and there's no contract behind it." You feel a sentence like that differently.

I built a risk rating that combined three things: how much revenue depends on the supplier, whether there's a contract, and whether you have a backup. A supplier only scored high when all three lined up badly. High revenue, no contract, no replacement. That's the combination that ends businesses. Now it had its own row at the top of the list, flagged red.

The point was forcing him to prioritize. You can't fix six supplier relationships at once. But you can see, instantly, which one to lock down first.

Don't Just Show the Problem, Show the Fix

A dashboard that only shows you the problem is a machine for making you anxious. Now you know exactly how exposed you are and have no idea what to do about it. That's worse than not knowing.

So I paired the scary numbers with a plan. For each at-risk supplier, the AI drafted an outreach message to negotiate a contract or exclusivity. The supplier with no backup got the most detailed plan, because that's the one to fix first.

These weren't generic templates. The AI used what we knew about each relationship, how long they'd worked together, the volume, the products, to write something that actually fit.

But nothing got sent automatically. The owner read every draft, edited what didn't sound like him, and hit send himself. That's non-negotiable in everything I build. A supplier negotiation is exactly the kind of thing you never let software fire off on its own. The cost of one awkward message to a critical supplier is huge.

The split is clean. AI does the organizing, the ranking, and the first draft. The human does the judgment and the sending.

Most dashboards report what's going well. Revenue up, orders flowing, a wall of green. Comfortable to look at, which is exactly why they're useless. Nobody changes their behavior because a number is green.

The valuable ones surface what you've been avoiding. For this distributor, that meant three numbers he'd carried in his gut for years, finally on a screen, finally in dollars, and finally with a first move attached to each one.

If you've got a number you keep not looking at, that's the work I do.

Want to explore what AI could do for your business?

Book a free 30-minute strategy call. No pitch deck, no sales team, just a real conversation about your operations and where AI fits.

Book a Discovery Call