Cost Allocation: Customer Profitability
Overview
- What you’ll learn: How to apply ABC to measure customer profitability, the whale curve and its implications, the customer cost hierarchy, strategies for managing unprofitable customers, and how customer lifetime value extends the analysis.
- Prerequisites: Lesson 2 — ABC Implementation & Management.
- Estimated reading time: 18 minutes
Introduction
The Grand Historian records: The merchants of antiquity knew their best customers by name, by face, and by the weight of gold they carried. But as empires grew and ledgers swelled, a terrible blindness descended — businesses treated all customers as if they were equally valuable, like a general who cannot distinguish his elite cavalry from his camp followers. Revenue was worshipped; profitability was ignored. And so it came to pass that many a company’s largest customer was also its largest source of loss, a magnificent parasite dining at the imperial table while the treasury bled dry.
Customer profitability analysis, powered by ABC, lifts this veil. It reveals that not all revenue is created equal — that the cost of serving one customer may be five times the cost of serving another, even when their revenue is identical. This lesson teaches you to see your customer base as it truly is: a handful of golden geese, a multitude of benign neutrals, and a troubling cadre of value destroyers.
Why Customer Profitability Matters
The Revenue Illusion
Traditional income statements report total revenue and total cost. They cannot tell you which customers generate that revenue profitably and which generate it at a loss. Consider two customers who each purchase $500,000 per year:
| Attribute | Customer A | Customer B |
|---|---|---|
| Annual revenue | $500,000 | $500,000 |
| Order frequency | 4 large orders/year | 200 small orders/year |
| Product mix | Standard products | Custom specifications |
| Payment terms | Pays in 15 days | Pays in 90 days |
| Returns | 0.5% return rate | 12% return rate |
| Support calls | 2 per year | 85 per year |
| Delivery | Standard shipping | Rush delivery required |
Both generate identical revenue. But Customer B consumes vastly more order-processing, engineering, returns-handling, customer-support, and expedited-shipping resources. Under ABC, Customer A might yield a $120,000 profit while Customer B produces a $40,000 loss. Without ABC, both appear equally valuable — and the company bends over backward to retain the one who is destroying value.
The Customer Cost Hierarchy
Just as products have a four-level activity hierarchy, customers have their own cost hierarchy:
| Level | Description | Examples |
|---|---|---|
| Customer output unit-level | Costs per unit sold to a customer | Handling, packaging per unit shipped |
| Customer batch-level | Costs per customer transaction | Order processing, delivery per shipment |
| Customer-sustaining | Costs to maintain the relationship | Dedicated account manager, catalog mailings, customer-specific engineering |
| Distribution-channel | Costs of the channel used | Retail vs. wholesale vs. online infrastructure |
| Corporate-sustaining | General overhead not traceable to customers | CEO salary, corporate headquarters |
Like facility-sustaining costs for products, corporate-sustaining costs should generally not be allocated to individual customers — they exist regardless of which specific customers the company serves.
The Whale Curve
The whale curve (also called the cumulative profitability curve or Stobachoff curve) is perhaps the most powerful visualization in managerial accounting. To construct it:
- Rank all customers from most profitable to least profitable.
- Plot cumulative profit on the Y-axis against the cumulative percentage of customers on the X-axis.
The result is striking: the curve rises steeply as the most profitable customers accumulate, peaks at roughly 150-300% of total company profit (often around the 20th percentile of customers), then declines as unprofitable customers erode the gains. The final point equals 100% of actual company profit.
What the Whale Curve Reveals
- The top 20% of customers often generate 150-300% of total profits.
- The middle 60-70% roughly break even — they contribute revenue but consume resources in equal measure.
- The bottom 10-20% destroy 50-200% of the profit generated by the top tier, dragging total profitability down to its actual level.
The Grand Historian observes: the shape of the whale curve is remarkably consistent across industries, from banking to manufacturing to telecommunications. It is a universal law of customer economics — and it is invisible without ABC.
Building a Customer Profitability Report
Step 1: Revenue and Gross Margin
Start with customer-level revenue, subtract cost of goods sold (using ABC product costs, not traditional costs), and compute gross margin per customer.
Step 2: Customer-Specific Operating Costs
Using ABC, trace the following costs to each customer:
- Order-processing costs: Activity rate x number of orders placed by this customer.
- Delivery and logistics: Activity rate x number of shipments, expedited deliveries, special handling requests.
- Sales and marketing: Dedicated sales representative time, customer-specific promotions, trade show visits, entertainment expenses.
- Customer service: Activity rate x number of support calls, complaints, warranty claims.
- Returns and rework: Activity rate x number of returns, credit memos, rework orders.
- Engineering and customization: Activity rate x hours of customer-specific design or modification.
- Accounts receivable: Cost of carrying receivables based on average days outstanding and credit risk.
Step 3: Customer Profitability Statement
| Customer A | Customer B | |
|---|---|---|
| Revenue | $500,000 | $500,000 |
| Cost of goods sold (ABC) | ($310,000) | ($335,000) |
| Gross margin | $190,000 | $165,000 |
| Order processing (4 x $250) | ($1,000) | ($50,000) |
| Delivery (4 x $400) | ($1,600) | ($48,000) |
| Customer service (2 x $75) | ($150) | ($6,375) |
| Returns processing | ($1,250) | ($30,000) |
| Engineering support | $0 | ($42,000) |
| A/R carrying cost | ($3,750) | ($22,500) |
| Customer-level operating income | $182,250 | ($33,875) |
| Customer margin % | 36.5% | (6.8%) |
Customer B is not merely less profitable — it is actively destroying $33,875 per year. Every dollar of revenue from Customer B costs the company $1.07 to generate.
Managing Unprofitable Customers
The discovery of unprofitable customers demands action, but the action should be surgical, not scorched-earth:
Strategy 1: Reprice to Reflect True Cost
Charge for services currently provided free: expedited shipping, small-order surcharges, engineering support, extended payment terms. Many customers will accept higher prices rather than switch suppliers.
Strategy 2: Reduce Cost-to-Serve
Move high-cost customers to lower-cost channels: online ordering instead of dedicated sales reps, standardized products instead of custom specifications, scheduled deliveries instead of rush orders.
Strategy 3: Renegotiate Terms
Require minimum order sizes, standard payment terms, and reduced returns. Convert batch-level costs from many small transactions to fewer large ones.
Strategy 4: Selective Customer Termination
When all other strategies fail, the rational course is to terminate the relationship. This is the most painful option, and the Grand Historian counsels extreme caution — losing a customer also means losing the revenue that covers allocated fixed costs. Only terminate when the savings from eliminated customer-specific costs clearly exceed the lost contribution margin.
Strategy 5: Do Nothing (Strategically)
Some unprofitable customers have strategic value: they provide market share that deters competitors, they are growing rapidly and will become profitable, or they provide referrals to profitable customers. Document the strategic rationale, set a timeline for profitability, and revisit.
Customer Lifetime Value (CLV)
A single year’s profitability snapshot may mislead. Customer Lifetime Value extends the analysis across the entire expected relationship:
CLV = Sum of (Annual Customer Profit / (1 + discount rate)^t) for t = 1 to n
A new customer who is unprofitable in year one due to acquisition costs may generate substantial profit over a ten-year relationship. Conversely, a currently profitable customer whose industry is declining may have low CLV. The Grand Historian advises: always consider the full arc of the relationship, not merely the current chapter.
Key Takeaways
- Revenue alone reveals nothing about customer profitability — the cost of serving customers varies enormously based on order patterns, product complexity, returns, and support requirements.
- The customer cost hierarchy (unit, batch, customer-sustaining, distribution-channel, corporate-sustaining) parallels the product activity hierarchy.
- The whale curve reveals that the most profitable 20% of customers typically generate 150-300% of total profit, while the least profitable 10-20% destroy significant value.
- Five strategies for managing unprofitable customers: reprice, reduce cost-to-serve, renegotiate terms, terminate, or retain strategically.
- Customer Lifetime Value extends the analysis beyond a single period, preventing short-sighted termination of customers with long-term potential.
What’s Next
In Lesson 4, we turn to revenue analysis — decomposing sales variances into volume, mix, quantity, market-share, and market-size components to understand exactly why revenue differed from plan.
繁體中文
概述
- 學習目標:以 ABC 衡量客戶獲利能力、鯨魚曲線及其意涵、客戶成本階層、管理虧損客戶之策略,以及客戶終生價值之延伸分析。
- 先決條件:第 2 課 — ABC 建置與管理。
- 預計閱讀時間:18 分鐘
簡介
太史公曰:古之商賈識其上客,知其名、識其面、量其攜金之重。然帝國日大、帳冊日厚,可怕之盲目降臨——企業視所有客戶如等值,猶將軍不辨精銳騎兵與營中雜役。營收被崇拜,獲利被忽視。遂有公司之最大客戶亦為最大虧損之源,華麗之寄生蟲宴飲於御桌,國庫日益枯竭。
以 ABC 驅動之客戶獲利分析揭開此面紗:非所有營收等質——服務一客戶之成本可為另一客戶之五倍,即便其營收相同。
為何客戶獲利分析重要
營收幻象
二客戶各購 $500,000/年。客戶 A:4 筆大單、標準品、15 天付款、0.5% 退貨。客戶 B:200 筆小單、客製品、90 天付款、12% 退貨、85 通支援電話、急件運送。同等營收,客戶 A 獲利 $182,250,客戶 B 虧損 $33,875。
客戶成本階層
| 層級 | 說明 | 範例 |
|---|---|---|
| 客戶產出單位層級 | 每售出單位之成本 | 每件包裝、搬運 |
| 客戶批次層級 | 每筆交易之成本 | 訂單處理、每次運送 |
| 客戶維持層級 | 維持關係之成本 | 專屬客戶經理、客製化工程 |
| 通路層級 | 所用通路之成本 | 零售 vs. 批發 vs. 線上 |
| 企業維持層級 | 無法追溯至客戶之一般間接費用 | 執行長薪資、總部 |
鯨魚曲線
將所有客戶依獲利排名,繪製累積利潤圖。曲線陡升至最高約 150-300% 之總公司利潤(約前 20% 客戶處),然後因虧損客戶侵蝕而下降至實際 100%。
- 前 20% 客戶通常創造 150-300% 之總利潤。
- 中間 60-70% 大致損益兩平。
- 後 10-20% 摧毀頂層所創之 50-200% 利潤。
管理虧損客戶
- 重新定價:收取目前免費之服務費用。
- 降低服務成本:將高成本客戶轉至低成本通路。
- 重新協商條件:要求最低訂購量、標準付款條件。
- 選擇性終止:當節省之客戶專屬成本明確超過流失之邊際貢獻時。
- 策略性保留:客戶具策略價值時,記錄理由並設定期限。
客戶終生價值(CLV)
單年度之獲利快照可能誤導。CLV 將分析延伸至整段預期關係:CLV = 各年度客戶利潤之折現值加總。新客戶首年因取得成本而虧損,十年關係或可創造可觀利潤。
重點摘要
- 僅憑營收無法判斷客戶獲利能力——服務成本因訂單模式、產品複雜度、退貨與支援需求而差異巨大。
- 客戶成本階層(單位、批次、客戶維持、通路、企業維持)平行於產品作業階層。
- 鯨魚曲線揭示前 20% 客戶通常創造 150-300% 之總利潤。
- 管理虧損客戶五策略:重新定價、降低服務成本、重新協商、終止、策略性保留。
- CLV 將分析延伸至單一期間之外,避免短視地終止具長期潛力之客戶。
下一步
第 4 課轉向營收分析——將銷售差異分解為數量、組合、數量、市佔率與市場規模成分,精確理解營收何以偏離計畫。
日本語
概要
- 学習内容:ABCによる顧客収益性の測定、クジラ曲線とその含意、顧客原価階層、不採算顧客の管理戦略、顧客生涯価値。
- 前提条件:レッスン2 — ABC導入と管理。
- 推定読了時間:18分
はじめに
太史公曰く:古の商人はその最良の顧客を名前と顔と携える金の重さで知りたり。されど帝国が大きくなり帳簿が膨れるにつれ、恐るべき盲目が降りかかれり——企業はすべての顧客を等しく価値あるものとして扱い、精鋭騎兵と陣営の従者を区別できぬ将軍の如し。収益は崇拝され、収益性は無視された。かくして多くの企業の最大顧客がまた最大の損失源となりぬ。
ABCによる顧客収益性分析はこのベールを取り除く。すべての収益が等しく創られるにあらず——ある顧客へのサービス原価は、同じ収益でも別の顧客の5倍に達し得る。
顧客収益性が重要な理由
収益の幻想
年間$500,000の2顧客を考える。顧客A:年4回の大口注文、標準品、15日支払、0.5%返品率。顧客B:年200回の小口注文、カスタム仕様、90日支払、12%返品率、年85回サポート、急送必須。ABC分析の結果:顧客A利益$182,250、顧客B損失$33,875。
顧客原価階層
| レベル | 説明 | 例 |
|---|---|---|
| 顧客産出ユニットレベル | 販売単位あたりの原価 | 梱包、取扱い |
| 顧客バッチレベル | 取引あたりの原価 | 受注処理、配送 |
| 顧客維持レベル | 関係維持の原価 | 専任営業、顧客固有エンジニアリング |
| 流通チャネルレベル | チャネルの原価 | 小売 vs. 卸売 vs. オンライン |
| 企業維持レベル | 顧客に追跡不能な一般間接費 | CEO給与、本社 |
クジラ曲線
全顧客を収益性順に並べ、累積利益をプロットする。曲線は急上昇し、総利益の150-300%でピークに達し(上位約20%の顧客で)、不採算顧客により低下して実際の100%に至る。
- 上位20%の顧客が通常、総利益の150-300%を生み出す。
- 中間60-70%はほぼ損益分岐。
- 下位10-20%が上位層の生み出した利益の50-200%を破壊する。
不採算顧客の管理
- 再価格設定:現在無料のサービスに課金する。
- サービス原価の削減:高コスト顧客を低コストチャネルに移行。
- 条件の再交渉:最低注文量、標準支払条件を要求。
- 選択的終了:削減される顧客固有原価が失われる限界利益を明確に上回る場合のみ。
- 戦略的保持:戦略的価値がある場合、根拠を文書化し期限を設定。
顧客生涯価値(CLV)
単年度の収益性スナップショットは誤導し得る。CLVは分析を予想される関係全体に拡張する。初年度に獲得費用で不採算の新規顧客も、10年の関係で相当な利益を生み得る。
重要ポイント
- 収益だけでは顧客収益性は分からない——サービス原価は注文パターン、製品複雑さ、返品、サポートにより大きく異なる。
- 顧客原価階層は製品の活動階層に並行する。
- クジラ曲線は上位20%の顧客が総利益の150-300%を生み出すことを明らかにする。
- 不採算顧客管理の5戦略:再価格設定、原価削減、再交渉、終了、戦略的保持。
- CLVは単一期間を超えて分析を拡張し、長期的可能性のある顧客の短視眼的終了を防ぐ。
次のステップ
レッスン4では収益分析に転じる——販売差異を数量、ミックス、数量、市場シェア、市場規模の構成要素に分解し、収益が計画と異なった理由を正確に理解する。