Which Customers Lose You Money | HL Hunt
Which Customers Lose You Money
Every customer carries the same 38% gross margin, so the margin report says they are all profitable. Price the orders, deliveries, support tickets and slow payments each one generates, and a quarter of a 120-customer business loses $57,739 a year while the top quarter produces 89.6% of profit. The obvious response is to drop the losers. If most of the cost to serve is fixed, that makes profit worse.
What you'll learn
Gross margin is not customer profit
A business with $1.56m of revenue at a 38% gross margin earns $592,800 before the cost of serving its customers. That cost is not spread evenly. It follows activity: orders placed, deliveries made, support requests handled, and the time each customer takes to pay.
Price each activity: $45 to process an order, $60 a delivery, $28 a support ticket, and a 12% annual cost of carrying receivables. Then group 120 customers into three types.
| Segment | Customers | Revenue each | Orders, tickets | Pays in | Profit each |
|---|---|---|---|---|---|
| A | 30 | $28,000 | 12, 4 | 30 days | $8,992 |
| B | 60 | $10,000 | 18, 10 | 45 days | $1,482 |
| C | 30 | $4,000 | 26, 22 | 75 days | −$1,925 |
The top quarter of customers produces 89.6% of total profit. The middle half produces the rest and a little more. The bottom quarter subtracts. None of this is visible on a gross margin report, because every segment carries the same 38%.
Small customers are not the problem; demanding small customers are. Segment C orders 26 times a year for $4,000 of goods, which is about $154 an order, and each order costs $105 to process and deliver before any support. Per our quoting analysis, a price that covers materials and labour can still lose money on everything around the job.
Why it goes unnoticed
- The costs are real and unallocated. Order processing, delivery and support sit in overhead, not against the customer who caused them.
- Revenue is visible per customer; cost is not. Every report that ranks customers ranks them by sales.
- The losses are small individually. $1,925 a year is not a number anyone flags.
- Slow payment looks free. Per our net terms analysis, 75-day payers are being lent money at no charge.
The second point is the one that compounds. A sales team rewarded on revenue will chase segment C as eagerly as segment A, because both appear as revenue, and per our concentration analysis the instinct to spread revenue across many small customers to reduce concentration can add exactly the customers who cost the most to serve.
The fourth point is the cheapest to fix and the least often counted. A customer paying in 75 days on $4,000 a year is carrying about $822 of your money at any moment, and at a 12% cost of funds that is roughly $99 a year. On segment A the same calculation is $276 a customer, but against $8,992 of profit it barely registers. On segment C it is another loss stacked on a loss, and the customers who order most often and pay slowest are frequently the same ones.
Dropping them is not the obvious answer
The tempting conclusion is to let segment C go. Whether that helps depends on a question the table above does not answer: how much of the cost to serve actually disappears when the customers do.
Segment C brings $45,600 of gross margin and drives $100,380 of service cost plus $2,959 of receivable carrying cost.
| Share of service cost that is avoidable | Effect of dropping segment C |
|---|---|
| 100%, every cost scales with activity | Profit rises $57,739 |
| 60% | Profit rises $17,587 |
| 40%, most cost is fixed staff and vehicles | Profit falls $2,489 |
An activity cost is an average, and averages hide fixed costs. If the order clerk, the support person and the delivery van remain after segment C leaves, most of the $100,380 remains too, and the business loses the $45,600 of margin while keeping the cost. Per our step cost analysis, cost that comes in units only falls when a whole unit is removed.
Customer profitability is a pricing tool before it is a pruning tool
The analysis is most useful when it changes how customers are served and priced, not when it is used to dismiss them. Dropping customers is irreversible and frequently saves less than the spreadsheet says. Repricing the activity that makes them costly is reversible and teaches the customer what their behaviour costs.
Repricing the activity
Segment C loses money because of what it does, so change what it does or charge for it.
- Set a minimum order. Halving order frequency to 13 a year halves processing and delivery cost on the same revenue.
- Charge for small orders or deliveries, such as a $15 fee below a threshold.
- Enforce payment terms. Per our collection analysis, moving a 75-day payer to 30 days removes most of the carrying cost.
- Move support to self-service for routine questions.
- Offer a cheaper service tier, such as weekly scheduled delivery, at a lower cost to serve.
Applying the first four together brings a segment C customer from −$1,925 to about −$137. Close to breakeven, not profitable, and that is a realistic outcome: some customers cannot be made profitable at any price they will accept, and per our pricing analysis the ones who leave after a repricing are usually the ones whose behaviour was costliest.
The repricing tends to work better than the numbers suggest, because a minimum order or delivery fee changes behaviour as well as revenue. Customers who were ordering daily out of habit consolidate, and the activity cost falls further than the fee alone would imply.
Slow payers are borrowing from you at zero percent
A 75-day payer costs about $99 a year in carrying cost alone on $4,000 of sales, and the cash gap has to be funded somewhere. HL Hunt Business Credit Builder establishes tradelines in your business's name, so working capital sits on your own record rather than on a personal guarantee.
Running the analysis
- List the activities that cost money: orders, deliveries, support, returns, custom work, credit terms.
- Estimate a cost per activity, roughly. A rough figure is far better than an implicit zero.
- Count activities by customer for the last twelve months.
- Compute profit per customer and sort it. The resulting curve almost always rises steeply and then falls.
- Separate avoidable from fixed cost before deciding anything.
- Reprice behaviour before removing customers.
- Pay sales on margin after cost to serve, not revenue. Per our capacity analysis, the customer that fills capacity at a loss also crowds out one that would not.
Item two is where most attempts stall, and it should not. A per-order cost can be estimated by dividing the cost of the people and systems that handle orders by the number of orders handled: a $56,000 order desk processing 1,250 orders a year is about $45 an order. A delivery cost is the vehicle, fuel and driver time divided by drops. The figures will be wrong by a margin, and per our small numbers analysis that matters less than it seems, because the differences between customer segments are usually large enough to survive a 30% error in any single rate.
Item seven is the change that keeps the problem from returning. A business that reprices segment C and continues to pay commission on revenue will rebuild segment C within two years. Per our turnover analysis and our queueing analysis, the hidden cost of high-touch customers also includes the staff time and wait they impose on everyone else.
Frequently asked questions
Gross margin ignores cost to serve. A $4,000 customer ordering 26 times with 22 tickets and 75-day payment loses about $1,925 a year.
Here the top quarter produced 89.6% of profit and the bottom quarter subtracted $57,739, while every segment showed the same gross margin.
Only after checking how much service cost actually disappears. If only 40% is avoidable here, dropping them lowers profit by $2,489.
Reprice the behaviour: minimum orders, small-order fees, enforced terms and self-service. Here that moved a loss of $1,925 to about $137.
Key takeaways
- Gross margin excludes cost to serve, which follows orders, deliveries, support and payment terms.
- Here a quarter of customers lost $57,739 a year while the top quarter produced 89.6% of profit.
- The losing quarter brought 7.7% of revenue and removed 16.1% of the profit the rest earned.
- Small customers are not the problem; demanding small customers are.
- Dropping the losers raises profit only if their service cost is avoidable; at 40% avoidable, profit falls $2,489.
- Repricing with minimum orders, fees, enforced terms and self-service moved a $1,925 loss to about $137.
- Repricing is reversible and changes behaviour; dropping customers is neither.
- Pay sales on margin after cost to serve, or the unprofitable segment rebuilds.
This guide is educational and does not constitute financial or accounting advice. All figures are stylized illustrations using assumed customer counts, revenues, gross margins, activity costs, payment periods, and avoidable cost shares, and do not describe any particular business. Activity-based cost estimates are approximations and depend heavily on which costs actually vary with activity. Consult a qualified adviser before changing pricing or customer policies.