Revenue EUR 120k, profit EUR 20k—is RetailCo worth keeping?
Compare net 16.7% to portfolio median and strategic value. Merkur Trade runs 90-day recovery on service cost before exit.
Library / Pricing & Profitability / Customer Profitability
ZBI Business Control Library
Customer Profitability
Customer Profitability: plain-English definition, formula, worked example, how to interpret the result, peer-based benchmark guidance, common mistakes, and management actions in the ZBI Business Control Library.
What is Customer Profitability?
Customer profitability is revenue minus direct costs minus allocated service costs for a customer or account—contribution after you pay to serve them, not only product margin on the invoice. Merkur Trade closes Q1 on RetailCo d.o.o.: revenue EUR 120,000, direct product cost EUR 78,000, allocated service cost EUR 22,000 (dedicated inside sales, small-order picking, and three emergency deliveries). Customer profit = 120,000 − 78,000 − 22,000 = EUR 20,000. I rank customers on this number quarterly because a 26% invoice margin can become 17% net contribution when cost-to-serve is honest.
Why Customer Profitability matters
Revenue heroes can destroy margin when service cost is free in the CRM. Merkur Trade's EUR 20,000 profit on EUR 120k revenue looks healthy until you compare to peers at EUR 35k on similar revenue with fewer line-item orders. Sales chases RetailCo for volume while logistics pays overtime on their Thursday rush releases. Finance allocates service cost once a year and wonders why net margin compresses while gross holds. Customer profitability is how you decide which accounts get key-account managers, which get minimum order rules, and which need a recovery plan or exit.
Formula and variables
Customer Profit = Revenue − Direct Costs − Allocated Service Costs
Revenue — net sales to the customer in the period (returns and rebates per policy).
Direct costs — product COGS or variable cost attributed to the customer's orders.
Allocated service costs — cost-to-serve: picking, shipping, sales visits, returns handling, payment terms cost.
Excel: =B2-B3-B4
Real business example
Merkur Trade Q1 customer review for RetailCo d.o.o.: revenue EUR 120,000; direct product cost EUR 78,000 (65% COGS ratio on net sales); allocated service cost EUR 22,000 built from 840 line picks, twelve small shipments under MOQ, and EUR 4,800 finance cost on extended terms. Customer profit = 120,000 − 78,000 − 22,000 = EUR 20,000 (16.7% net contribution on revenue). Peer account TechnoMarket at similar revenue delivers EUR 31k profit on EUR 8k service cost—RetailCo enters 90-day recovery: MOQ, consolidated deliveries, and terms aligned to policy.
How to interpret the result
Customer profit is contribution after cost-to-serve—not invoice margin alone.
- EUR 20k profit on EUR 120k revenue is 16.7% net—compare to gross margin before celebrating.
- Service cost EUR 22k must use measurable drivers (lines, shipments, visits), not equal split overhead.
- Rank customers quarterly; strategic loss-makers need recovery plan or exit date.
- Include payment terms cost—60-day terms on EUR 120k is real money in the allocation.
Benchmark context
Industrial distributors often target top-quartile customers above 20% net contribution after service cost; below 12% triggers review. Merkur Trade benchmarks RetailCo's 16.7% against portfolio median 19%—not against a generic 'all customers must be 25%.' Strategic accounts may run below target for twelve months with a signed recovery plan; without the plan, they are subsidized by profitable accounts.
Red flags
- Top-ten revenue account below 10% net customer profit two quarters—subsidized by portfolio.
- Service cost allocation flat while line-item orders up 30%—model stale, heroes look profitable.
- Customer profit positive but below cost of capital on receivables and inventory held for one account.
- Sales comp on revenue while customer profit ranking shows bottom-quartile—misaligned incentives.
- Strategic account label on unprofitable customer with no signed recovery plan or exit date.
Common mistakes
- Using gross margin only—EUR 42k product margin hides EUR 22k service cost.
- Allocating service cost as equal percent of revenue—small-order customers look better than they are.
- Excluding sales commission from service cost when comp drives unprofitable small orders.
- Annual allocation only—RetailCo's Q1 rush behavior invisible until year-end.
- No action threshold—ranking customers without MOQ or terms consequence changes nothing.
What should management do next?
- Rank customers quarterly on contribution after cost-to-serve allocation.
- Implement measurable cost-to-serve drivers in ERP or allocation model within one quarter.
- Board review unprofitable strategic accounts with 90-day recovery or exit.
- Share transparent ranking with sales—include commission in net view where policy allows.
- Block new key-account terms without 90-day cost-to-serve prototype.
Related calculators
Related analyzers
Related templates & software
Related KPI pages
Related blog articles
FAQ
How do we allocate EUR 22k service cost fairly?
Drivers: line picks, shipments, visits, returns, payment days. Avoid equal revenue percent—it flatters multi-line small-order accounts.
Should sales see customer profit ranking?
Yes with rules—transparency fixes behavior. Pair with MOQ and terms policy so ranking leads to action.
Direct cost EUR 78k—standard or actual COGS?
Use one policy consistently—actual for key accounts quarterly, standard for speed if variance is small.
When does customer profit trigger contract renegotiation?
Two quarters below target net contribution without approved strategic rationale—or any quarter below variable cost.
Summary
Customer profitability is revenue minus direct and service costs. Merkur Trade's EUR 20k on EUR 120k revenue shows why cost-to-serve allocation matters—rank honestly and act on recovery or exit, not only invoice margin.
Reviewed by ZBI Business Control Library · Last updated 2026-06-15