Cost Accounting • Pricing and Profitability

Customer Profitability Analysis — Compute customer profitability using activity-based cost drivers (intro)

Discover why some customers generate profit while others quietly erode it, using activity-based costing.

A calculator with a cost receipt and comparison chart for cost accounting
Inside this lesson 10 sections 5 questions 10 figures

SECTION 1

Historical Context & Motivation

For most of the twentieth century, companies allocated overhead costs to products using simple volume-based measures such as direct labor hours or machine hours. While these methods served well in manufacturing environments dominated by a narrow product range, they became increasingly unreliable as firms diversified their product lines, expanded service offerings, and cultivated heterogeneous customer bases. The fundamental problem was that traditional costing treated every customer as if they consumed resources in exactly the same proportion—an assumption that rarely held true in practice.

As global competition intensified during the 1980s and 1990s, managers realized that aggregate revenue figures masked enormous variation in the profitability of individual customers. A customer placing large, routine orders with minimal service demands might cost far less to serve than a customer requiring custom packaging, expedited shipping, and frequent technical support, even if both generated the same gross revenue. The inability of traditional systems to capture these differences led to cross-subsidization: profitable customers unknowingly subsidized unprofitable ones, distorting pricing decisions and strategic resource allocation.

1987 • Birth of Activity-Based Costing

Robin Cooper and Robert Kaplan publish seminal articles in the Harvard Business Review introducing activity-based costing (ABC), arguing that activities—not volume—drive costs.

1992 • The Balanced Scorecard Era

Kaplan and Norton extend managerial accounting toward customer-centric performance measurement, encouraging firms to look beyond aggregate financials to customer-level metrics.

1997 • Customer Profitability Analysis Gains Traction

Academic and practitioner literature formalizes customer profitability analysis (CPA), applying ABC principles to trace costs not just to products but to individual customers and customer segments.

2004 • Time-Driven ABC

Kaplan and Anderson introduce time-driven ABC, simplifying the implementation of activity-based systems and making customer-level analysis more practical for large, complex organizations.

2010s • Data Analytics & CPA Integration

Advances in enterprise resource planning (ERP) systems and data analytics enable real-time customer profitability tracking, embedding ABC-driven CPA into operational decision-making.

The central question that customer profitability analysis addresses is deceptively simple: which customers are truly profitable, and which are costing us money? Answering this question requires a costing methodology that traces resource consumption to the activities that individual customers actually trigger—precisely the logic of activity-based costing.

SECTION 2

Core Principles & Definitions

Before computing customer profitability, it is essential to understand the conceptual building blocks. Customer profitability analysis (CPA) is the process of attributing revenues and costs to individual customers or customer groups in order to determine the net operating income each generates. Unlike product-level profitability, CPA explicitly considers the downstream costs of serving a customer—order processing, delivery, after-sales support, returns handling, and more. When these service-related costs are assigned using activity-based cost drivers, the resulting analysis provides a far more accurate picture than traditional allocation methods.

1

Activity

A discrete unit of work that consumes resources—e.g., processing an order, handling a return, or making a sales visit. Activities are the building blocks of ABC.
2

Cost Driver

A measurable factor that causes an activity's cost to change. For example, the number of orders processed is a cost driver for the order-processing activity.
3

Cost Pool

The total cost accumulated for a given activity. Each cost pool is allocated to customers based on their consumption of the associated cost driver.
4

Activity Rate

The cost per unit of a cost driver, computed as the total cost pool divided by the total quantity of the cost driver. This rate is used to trace costs to individual customers.
5

Customer Operating Income

The net result after subtracting all activity-based costs from the revenue a customer generates. Positive values indicate profitability; negative values signal a cost-to-serve problem.
✦

KEY TAKEAWAY

Think of customer profitability analysis as an itemized restaurant bill rather than an even split among friends. If everyone pays an equal share, the diner who ordered a salad subsidizes the one who ordered lobster. ABC-driven CPA ensures that each customer 'pays' for the activities they actually consumed, revealing who contributes to profits and who is dining on someone else's tab.

SECTION 3

Visual Explanation — The ABC-to-CPA Flow

The following diagram illustrates the logical flow of an activity-based customer profitability analysis. Resources flow into activities, activities are measured by cost drivers, and cost drivers are traced to individual customers to compute customer-level operating income.

Activity-Based Customer Profitability Analysis FlowRESOURCESSalaries, Rent, MaterialsCOST POOLSassignOrder ProcessingDelivery & ShippingCustomer SupportReturnsACTIVITIESCOST DRIVERS# of Orders# of Deliveries# of Support Calls# of ReturnsCUSTOMERSCustomer ACustomer BCustomer CCUSTOMER OPERATING INCOME+$42,000−$5,200+$18,300Revenue − Cost of Goods Sold − Activity-Based Customer Costs = Customer Operating Income
Figure 1. Resources flow into cost pools, which fund activities. Each activity has a cost driver that measures consumption. Costs are traced to individual customers via their usage of each driver, yielding customer-level operating income. Note that Customer B is unprofitable despite generating revenue.

The diagram above captures the essence of ABC-driven CPA in five layers. At the top, resources (salaries, rent, materials) are assigned to cost pools based on how each activity consumes them. Activities such as order processing and customer support each have a measurable cost driver—the number of orders, the number of support calls, and so on. By multiplying the activity rate by each customer's usage, costs are traced downward to individual customers. The final layer reveals that Customer B, despite appearing to be a revenue-generating client, is actually destroying value because the costs of serving that customer exceed the revenue earned.

SECTION 4

Mathematical Framework

The mathematics behind customer profitability analysis is straightforward once the activity-based framework is established. The computation proceeds in three stages: calculating activity rates, tracing costs to customers, and deriving customer operating income.

ACTIVITY RATE

ActivityRate=TotalCostPoolforActivity÷TotalQuantityofCostDriverActivity Rate = Total Cost Pool for Activity ÷ Total Quantity of Cost Driver

The activity rate expresses the cost incurred each time one unit of the cost driver is consumed. For example, if the order-processing cost pool is $120,000 and 3,000 orders are processed in a period, the activity rate is $40 per order.

CUSTOMER ACTIVITY COST

CustomerActivityCost=ActivityRate×Customer′sQuantityofCostDriverCustomer Activity Cost = Activity Rate × Customer's Quantity of Cost Driver

This equation is applied for every activity. If Customer A placed 200 orders and the activity rate is $40 per order, Customer A's order-processing cost is $40 × 200 = $8,000.

TOTAL CUSTOMER COST

TotalCustomerCost=COGS+Σ(ActivityRatei×CustomerDriverQuantityi)Total Customer Cost = COGS + Σ (Activity Rate_i × Customer Driver Quantity_i)

Sum across all i activities. COGS (Cost of Goods Sold) is directly traceable; the summation captures all activity-based costs.

CUSTOMER OPERATING INCOME

CustomerOperatingIncome=CustomerRevenue−TotalCustomerCostCustomer Operating Income = Customer Revenue − Total Customer Cost

A positive result means the customer is profitable after accounting for all traced activity costs. A negative result indicates the customer is unprofitable and warrants managerial attention.

ℹ

Note on Cost Hierarchy

In a full ABC system, costs are organized into a hierarchy: unit-level (per unit produced), batch-level (per production batch), product-sustaining (per product line), and facility-sustaining (general infrastructure). Customer profitability analysis adds a customer-sustaining level that captures costs incurred to maintain the relationship with a specific customer, such as dedicated account management or customized reporting.

SECTION 5

Detailed Breakdown — Common Activity-Based Cost Drivers

Selecting the right cost drivers is critical to the accuracy of customer profitability analysis. A cost driver must be both causally related to the activity it measures and practically measurable using data the firm already collects (or can cost-effectively collect). The table below lists common customer-facing activities, their typical cost drivers, and examples of how cost driver consumption can vary dramatically across customers.

ActivityCost DriverHigh-Cost Customer BehaviorLow-Cost Customer Behavior
Order ProcessingNumber of ordersMany small, frequent ordersFew large, consolidated orders
Delivery / ShippingNumber of deliveries or shipmentsRequests expedited or special shippingUses standard shipping schedules
Sales VisitsNumber of sales visitsRequires frequent in-person meetingsOrders electronically with minimal contact
Technical SupportNumber of support hours or callsFrequently contacts help deskSelf-serves using documentation
Returns & ReworkNumber of returns processedHigh return rate or custom reworkMinimal returns
Invoicing & CollectionsNumber of invoices or collection contactsSlow payment requiring follow-upPays promptly via electronic transfer

Table 1. Common activities and cost drivers in customer profitability analysis

Cost Driver Consumption: Customer A vs. Customer B(Both customers generate $100,000 in annual revenue)OrdersDeliveriesSales VisitsSupport CallsReturns12104214840203015Customer A (low-maintenance)Customer B (high-maintenance)
Figure 2. Although both customers generate $100,000 in annual revenue, Customer B consumes four to fifteen times more of every cost driver. Under traditional costing, both might appear equally profitable; ABC reveals the stark difference.

The bar chart above crystallizes a fundamental insight of CPA: revenue equality does not imply profit equality. Customer B's heavy consumption of order processing, deliveries, sales visits, support calls, and returns translates into dramatically higher costs to serve. Without activity-based cost drivers, a company using a single allocation base—say, revenue—would assign identical overhead to both customers, hiding the fact that Customer B is likely unprofitable.

SECTION 6

Worked Example — Two-Customer Profitability Comparison

Greenfield Electronics sells circuit boards to two customers: Apex Corp and Beta Inc. Both generate $200,000 in annual revenue, and COGS for each is $120,000. The company has identified three customer-related activities. The data for the current period are summarized below.

ActivityTotal Cost PoolCost DriverTotal Driver QtyApex Corp UsageBeta Inc Usage
Order Processing$60,000# of orders50050200
Delivery$30,000# of deliveries30030150
Customer Support$20,000# of support hours40020180

Activity and cost driver data for Greenfield Electronics

Computing Customer Operating Income

  1. 1

    Step 1 — Compute Activity Rates

    Divide each cost pool by its total driver quantity. Order Processing: $60,000 ÷ 500 orders = $120 per order Delivery: $30,000 ÷ 300 deliveries = $100 per delivery Customer Support: $20,000 ÷ 400 hours = $50 per support hour
    Rates: $120/order, $100/delivery, $50/support hour
  2. 2

    Step 2 — Trace Activity Costs to Apex Corp

    Multiply each activity rate by Apex Corp's driver usage. Order Processing: $120 × 50 = $6,000 Delivery: $100 × 30 = $3,000 Customer Support: $50 × 20 = $1,000 Total activity costs for Apex Corp = $6,000 + $3,000 + $1,000 = $10,000
    Apex Corp total activity costs = $10,000
  3. 3

    Step 3 — Trace Activity Costs to Beta Inc

    Repeat the same calculation for Beta Inc. Order Processing: $120 × 200 = $24,000 Delivery: $100 × 150 = $15,000 Customer Support: $50 × 180 = $9,000 Total activity costs for Beta Inc = $24,000 + $15,000 + $9,000 = $48,000
    Beta Inc total activity costs = $48,000
  4. 4

    Step 4 — Compute Customer Operating Income

    Subtract COGS and total activity costs from revenue for each customer. Apex Corp: $200,000 − $120,000 − $10,000 = $70,000 Beta Inc: $200,000 − $120,000 − $48,000 = $32,000
    Apex Corp Operating Income = $70,000 | Beta Inc Operating Income = $32,000
  5. 5

    Step 5 — Interpret Results

    Both customers are profitable, but Apex Corp is more than twice as profitable as Beta Inc despite generating identical revenue and having identical COGS. The difference is driven entirely by Beta Inc's higher consumption of customer-facing activities. Under a simple allocation method (e.g., splitting $110,000 total activity costs equally), each customer would show an operating income of $25,000—understating Apex's true value and overstating Beta's.
    ABC reveals a $38,000 profitability gap hidden by traditional methods.

SECTION 7

Strengths & Limitations of ABC-Driven CPA

Activity-based customer profitability analysis offers substantial advantages over traditional costing approaches, but it is not without its challenges. Understanding both sides equips managers to deploy CPA effectively and to recognize situations where simpler methods may suffice.

StrengthsLimitations
Provides accurate, causally linked cost assignments by tracing costs through activities rather than using arbitrary allocation bases.Requires significant data collection effort; companies must identify activities, select cost drivers, and measure customer-level consumption.
Reveals cross-subsidization: identifies which profitable customers are subsidizing unprofitable ones.Activity rates assume costs are variable with respect to the driver, which may not hold for costs with large fixed components.
Enables strategic actions: renegotiate terms, reprice, restructure service, or discontinue unprofitable relationships.Implementation and maintenance costs can be high, particularly for firms with many diverse activities and customers.
Supports customer segmentation and targeted marketing by aligning service levels to profitability.Subjective judgment is required in selecting cost drivers and assigning resource costs to activities—different choices yield different results.
Enhances pricing decisions by incorporating the true cost to serve into customer-specific pricing models.A snapshot analysis may not capture the lifetime value of a customer—an unprofitable customer today may become highly profitable in the future.

Table 2. Strengths and limitations of ABC-driven customer profitability analysis

✦

KEY TAKEAWAY

Think of ABC-driven CPA as a high-resolution MRI scan of your customer base, compared to the blurry X-ray of traditional costing. The MRI reveals far more detail—but it also takes longer, costs more to administer, and requires a skilled technician to interpret. The value of the scan depends on how much hidden information it uncovers and how actionable that information is for the organization.

SECTION 8

Connection to Advanced Customer Analytics

The introductory CPA framework presented in this lesson serves as the foundation for several more sophisticated analytical tools. As you advance in cost and managerial accounting, you will encounter extensions that address some of the limitations noted above and integrate CPA with broader strategic frameworks.

ConceptIntroductory CPA (This Lesson)Advanced Extension
Time HorizonSingle-period snapshot (one quarter or one year).Customer Lifetime Value (CLV) models project profitability over the entire expected duration of the relationship, incorporating retention rates and discount factors.
Cost Driver MeasurementUses traditional ABC with survey- or interview-based activity mapping.Time-Driven ABC (TDABC) replaces activity surveys with time equations, estimating the time each transaction demands and multiplying by the capacity cost rate.
Decision FocusIdentifies profitable vs. unprofitable customers.Strategic Customer Management links CPA to customer acquisition, retention, and development strategies, integrating marketing and operations.
Capacity AnalysisAssumes full utilization; allocates all costs to customers.Advanced models separate the cost of used capacity from unused capacity, preventing distortion when volume fluctuates.

Table 3. Introductory CPA vs. advanced extensions

The progression from basic CPA to customer lifetime value and time-driven ABC reflects a broader trend in managerial accounting: moving from static, backward-looking reports to dynamic, forward-looking analytics that inform real-time decisions. Understanding the ABC-driven CPA framework you have learned here is essential preparation for these advanced tools, because the same logical architecture—resources → activities → cost drivers → cost objects—remains the backbone of every extension.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

Explain why two customers who generate the same revenue can have very different profitability under an activity-based costing system. In your explanation, identify at least two specific activities and their cost drivers that could cause this difference.
Show answer
Under ABC, costs are traced to customers based on their actual consumption of activities, not merely their revenue. Two customers with identical revenue may consume vastly different amounts of customer-related activities. For example, one customer may place 10 large orders per year (consuming 10 units of the order-processing cost driver), while the other places 100 small orders (consuming 100 units). Similarly, one customer may require 5 support calls annually while the other requires 50. Because each activity carries a cost per unit of its driver, the customer who consumes more of these activities incurs higher traced costs, reducing their operating income even though their revenue contribution is the same.

Question 2: BASIC CALCULATION

A company's delivery activity has a total cost pool of $45,000 and processes 900 deliveries per period. Customer X receives 60 deliveries and Customer Y receives 15 deliveries. Compute the activity rate and the delivery cost traced to each customer.
Show answer
Activity Rate = $45,000 ÷ 900 = $50 per delivery. Customer X's delivery cost = $50 × 60 = $3,000. Customer Y's delivery cost = $50 × 15 = $750. Customer X consumes four times the delivery resources of Customer Y, and the ABC system captures this difference precisely. Under a revenue-based allocation, this cost disparity would be hidden if both customers generated similar revenues.

Question 3: INTERMEDIATE

SunParts Inc. has two customers. Customer M generates $150,000 in revenue with $90,000 in COGS. Customer N generates $180,000 in revenue with $110,000 in COGS. Three activities are identified: order processing ($80,000 total pool, 1,000 orders total; M uses 100, N uses 400), packaging ($36,000 total pool, 600 units; M uses 50, N uses 250), and warranty service ($24,000 total pool, 480 hours; M uses 30, N uses 200). Compute the operating income for each customer and identify which is more profitable as a percentage of revenue.
Show answer
Activity rates: Order Processing = $80,000 ÷ 1,000 = $80/order; Packaging = $36,000 ÷ 600 = $60/unit; Warranty = $24,000 ÷ 480 = $50/hour. Customer M costs: ($80 × 100) + ($60 × 50) + ($50 × 30) = $8,000 + $3,000 + $1,500 = $12,500. Customer M operating income = $150,000 − $90,000 − $12,500 = $47,500 (31.7% of revenue). Customer N costs: ($80 × 400) + ($60 × 250) + ($50 × 200) = $32,000 + $15,000 + $10,000 = $57,000. Customer N operating income = $180,000 − $110,000 − $57,000 = $13,000 (7.2% of revenue). Although Customer N generates more revenue, Customer M is far more profitable both in absolute dollars and as a percentage of revenue.

Question 4: APPLIED

You are a cost analyst at a logistics firm. Management currently allocates $500,000 in customer-service overhead equally among 50 customers ($10,000 each). You conduct an ABC study and discover four activities: dispatching ($200,000; driver = dispatches), invoicing ($100,000; driver = invoices), complaint resolution ($120,000; driver = complaints), and account management ($80,000; driver = account meetings). Customer Z generates $60,000 in revenue with $35,000 COGS. Out of firm totals of 4,000 dispatches, 2,000 invoices, 600 complaints, and 200 meetings, Customer Z uses 300, 180, 50, and 12 respectively. Compare Customer Z's profitability under the equal-allocation method versus ABC. What recommendation would you make?
Show answer
Under equal allocation, Customer Z's operating income = $60,000 − $35,000 − $10,000 = $15,000. Under ABC: Dispatch rate = $200,000 ÷ 4,000 = $50; Invoice rate = $100,000 ÷ 2,000 = $50; Complaint rate = $120,000 ÷ 600 = $200; Meeting rate = $80,000 ÷ 200 = $400. Customer Z's ABC costs = ($50 × 300) + ($50 × 180) + ($200 × 50) + ($400 × 12) = $15,000 + $9,000 + $10,000 + $4,800 = $38,800. ABC operating income = $60,000 − $35,000 − $38,800 = −$13,800. Customer Z is actually unprofitable by $13,800. The equal-allocation method overstated profitability by $28,800. I would recommend renegotiating terms with Customer Z—perhaps consolidating dispatches, reducing complaint triggers through quality improvement, or increasing prices to reflect the true cost to serve.

Question 5: CRITICAL THINKING

A company's ABC-based CPA reveals that its largest customer, contributing 25% of total revenue, is unprofitable. The CFO proposes dropping this customer immediately. As a cost accountant, present at least three arguments for why this decision should not be made solely on the basis of a single-period CPA, and explain what additional analysis would be needed.
Show answer
First, the CPA is a single-period snapshot and does not account for customer lifetime value. The customer may be in an unusually high-cost phase (e.g., onboarding, ramp-up) and could become highly profitable once the relationship matures. A multi-period CLV analysis should be conducted. Second, some costs attributed to the customer may be fixed or committed costs that will not disappear if the customer is dropped. If facility-sustaining costs are allocated to this customer, those costs would simply be redistributed to remaining customers, potentially making other customers appear unprofitable. An incremental cost analysis separating avoidable from unavoidable costs is essential. Third, the customer contributes 25% of revenue, meaning it likely absorbs substantial production capacity. Losing this volume may push the firm below breakeven on its fixed cost structure and could trigger excess capacity costs. A capacity utilization analysis and contribution margin analysis should accompany the CPA before any discontinuation decision. Finally, strategic considerations—such as the customer's market influence, referral value, and competitive implications of losing them—extend beyond what any costing model captures.

SUMMARY

Lesson Summary

Summary

Customer profitability analysis (CPA) addresses a critical question in cost accounting: which customers actually contribute to a firm's bottom line? By applying activity-based costing (ABC), companies trace overhead costs through activities and their corresponding cost drivers to individual customers. The process begins by computing activity rates (total cost pool ÷ total driver quantity), then multiplying each rate by the customer's consumption of that driver to obtain customer activity costs. Subtracting COGS and total activity costs from customer revenue yields customer operating income.

This framework reveals cross-subsidization hidden by traditional volume-based allocations: low-maintenance customers often subsidize high-maintenance ones. While ABC-driven CPA demands more data and careful driver selection, its advantages—accurate cost tracing, better pricing, and informed customer management decisions—make it an indispensable tool in modern cost accounting. As you continue your studies, you will see this foundational framework extend into customer lifetime value analysis and time-driven ABC, both of which build directly on the concepts introduced here.

Varsity Tutors • Cost Accounting • Customer Profitability Analysis — Compute customer profitability using activity-based cost drivers (intro)