15.1 Customer Profitability Analysis & Cost-to-Serve

Customer Profitability Analysis & Cost-to-Serve

In conventional management accounting, profitability analysis has historically centered on individual products, service lines, or organizational divisions. Under standard absorption costing and conventional income statement formats, customer-related commercial expenses—such as sales representation, order processing, technical support, expedited delivery, and warehousing—are aggregated into general Selling, General, and Administrative (SG&A) overhead pools. These overheads are routinely allocated across product lines using broad volume-based drivers (such as percentage of sales revenue or direct labor hours).

In contemporary competitive environments, this product-centric view is dangerously incomplete. Customers purchasing identical products at identical list prices can generate wildly divergent net profit margins due to differences in their buying behavior and demands on corporate infrastructure. Customer Profitability Analysis (CPA) applies the principles of Activity-Based Costing (ABC) to trace not only the direct cost of goods sold (COGS), but the entire cost-to-serve directly to individual customer accounts or market segments.

---

Principles of Activity-Based Cost-to-Serve Modeling

A comprehensive CPA model separates the economics of what a customer buys (product mix and gross manufacturing margin) from how a customer orders, receives, and utilizes organizational resources (cost-to-serve). Tracing costs requires establishing cost pools and cause-and-effect activity drivers across the downstream commercial value chain:

By quantifying these cost drivers, the strategic management accountant calculates Customer Net Margin:

$$\text{Customer Gross Margin} = \text{Net Realized Revenue} - \text{Direct Manufacturing COGS}$$ $$\text{Customer Surplus after Capital Charges} = \text{Customer Gross Margin} - \text{Customer Cost-to-Serve}$$

---

The Pareto Rule and the Cumulative Profitability "Whale Curve"

Rank accounts by profit, then accumulate those profits from highest to lowest. Cumulative profit rises as profitable accounts are added and falls when loss-making accounts are added. That shape is called a whale curve. For example, profitable accounts contribute 150 units and loss-making accounts contribute −50: final profit is 100 and the peak is 150% of final profit. The loss is 50% of final profit but 33.3% of the peak. Percentages and customer shares depend on the business; an 80/20 split is not a rule or forecast.

---

The Customer Classification Matrix

To formulate actionable managerial strategies, Cooper and Kaplan constructed a 2x2 matrix categorizing accounts along two dimensions: Net Margin Realized (Price vs COGS) and Cost-to-Serve:

---

Strategic Remedies for Unprofitable Accounts

Strategic management accountants do not treat account termination as an immediate default. Firing an unprofitable customer risks stranding fixed overhead and underutilizing productive capacity. Instead, management implements structured remedies:

• Unbundled Activity-Based Pricing: Transition from all-inclusive bundle pricing to menu-based pricing. Charge explicit surcharges for non-standard pallet configurations, rush freight, and on-site engineering consultations.
• Minimum Order Quantities (MOQ) and Order Consolidation: Impose order floor thresholds or tiered quantity discounts that incentivize clients to consolidate five small weekly orders into a single monthly bulk shipment.
• Channel Migration to Self-Service Portals: Shift transaction entry from high-cost manual sales administration to automated electronic data interchange (EDI) or cloud procurement portals, slashing processing costs from $75 per order to $3 per order.
• Standardization of Delivery Schedules: Transition client delivery windows from erratic, daily on-demand dispatches to scheduled, consolidated geographic route runs.
• Contract Renegotiation or Firing: If a loss-making customer refuses price adjustments, declines operational compromises, and fails to cover its short-term avoidable variable costs, the enterprise should formally exit the relationship and redeploy capacity toward profitable segments.

---

Customer Lifetime Value (CLV)

While CPA evaluates historical or single-period profitability, strategic management accountants evaluate ongoing customer acquisition and retention through Customer Lifetime Value (CLV). CLV models the present value of all future operating cash flows expected from a customer over the duration of the commercial relationship:

$$CLV = \sum_{t=1}^n \frac{(R_t - C_t) \times r^t}{(1 + d)^t} - AC$$

Where:

• $R_t$ = Expected revenue generated from the customer in period $t$
• $C_t$ = Expected manufacturing COGS and cost-to-serve in period $t$
• $r$ = Customer retention probability rate ($0 \le r \le 1$)
• $d$ = Annual corporate discount rate (WACC)
• $AC$ = Upfront customer acquisition cost (sales commissions, marketing, client onboarding)

Under assumptions of constant annual net cash contribution ($m = R - C$), constant retention rate ($r$), and an infinite time horizon, CLV simplifies to:

$$CLV = \left( \frac{m \times r}{1 + d - r} \right) - AC$$

---

Corporate Application: Meridian Industrial Supplies Ltd

Meridian Industrial Supplies Ltd distributes maintenance and engineering hardware across Australia. The executive committee historically evaluated commercial performance using gross margin percentages. A strategic management accountant conducted an Activity-Based CPA study, analyzing four primary client accounts representing annual revenue of $10,000,000:

Account Operating Profiles

• Client Alpha (Mining Conglomerate): $3,500,000 revenue. Demands 18% volume discount. Requires 520 emergency site dispatches, specialized barcoded packaging, and 75-day credit terms.
• Client Beta (Regional Hardware Wholesaler): $3,000,000 revenue. Purchases standard catalog goods in full truckloads via EDI. 12 orders per year, standard packaging, 30-day payment compliance.
• Client Gamma (Precision Engineering Firm): $2,000,000 revenue. High-specification components with minimal discount. Places 48 scheduled orders per year with modest technical inquiries.
• Client Delta (Municipal Maintenance Works): $1,500,000 revenue. Extremely aggressive tender pricing. Places 1,200 micro-orders annually, demands bespoke wooden crating, and incurs 90-day settlement delays.

Activity Cost Pool Drivers

• Order Processing: $80 per order
• Specialized Packaging: $120 per custom pack run
• Logistics & Urgent Freight: $350 per dispatch
• Technical Field Support: $150 per hour
• Working Capital Holding Cost: 12% per annum on average trade receivables balance

Comprehensive Customer Profitability Schedule

Revenue is already net of negotiated discounts. Receivable capital charges use revenue × collection days / 365 × 12%, rounded to the nearest $100. These are economic opportunity charges, so the final surplus is a management measure, not statutory operating profit. Allocated fixed costs are not automatically avoidable.

Cumulative Whale Curve Construction

Ranking clients from most to least profitable illustrates the Whale Curve dynamic:

1. Rank 1: Client Beta — Operating Profit = $572,240 (Cumulative Profit: $572,240; 58.2% of total net profit)
2. Rank 2: Client Gamma — Operating Profit = $548,460 (Cumulative Profit: $1,120,700; 113.9% of total net profit)
3. Rank 3: Client Alpha — Operating Profit = $247,700 (Cumulative Profit: $1,368,400; 139.1% peak profit)
4. Rank 4: Client Delta — Operating Loss = -$384,400 (Cumulative Profit: $984,000; erodes 28.1% of peak profit (39.1% of final total profit))

Strategic Takeaway: Under traditional gross margin metrics, Client Alpha appeared to be the corporate flagship (generating $1,050,000 in gross margin). However, Alpha's severe cost-to-serve ($462,300) eroded its net operating contribution down to 7.1%. Meanwhile, Client Beta, with an identical 30% gross margin, delivered $572,240 in customer surplus because its cost-to-serve was a negligible 1.3% of revenue. Most critically, Client Delta obliterated $384,400 of enterprise value by generating 1,200 small-batch customized orders at discounted prices. Meridian enacted minimum order batching and unbundled freight surcharges for Delta, converting a 25.6% net loss into an accretive 8.4% commercial margin.

---

Exam Traps to Avoid