Customer-Profitability Profiles

Learning Objective 2 Identify the importance of customer-profitability profiles

Customer-profitability profiles are a useful tool for managers. Exhibit 15-4 ranks the Provalue Division’s 10 wholesale customers based on customer-level operating income. (We analyzed four of these customers in Exhibit 15-3.)

Exhibit 15-4

Cumulative Customer-Profitability Analysis for Provalue Division’s Wholesale-Channel Customers: Astel Computers, 2019

Spreadsheet screenshot shows the cumulative customer-profitability analysis for Provalue division wholesale-channel customers for the year 2019..

Spreadsheet shows the operating income, customer revenue, and other details of Astel Computers.

1. Retail customer code: B

2. Retail customer code: A

3. Retail customer code: C

4. Retail customer code: D

5. Retail customer code: F

6. Retail customer code: J

7. Retail customer code: E

8. Retail customer code: G

9. Retail customer code: H

10. Retail customer code: I

11. Total

Column 4, computed by adding the individual amounts in column 1, shows the cumulative customer-level operating income. For example, Customer C shows a cumulative income of $13,260,000 in column 4. This $13,260,000 is the sum of $5,690,000 for Customer B, $4,915,000 for Customer A, and $2,655,000 for Customer C.

Column 5 shows what percentage the $13,260,000 cumulative total for customers B, A, and C is of the total customer-level operating income of $15,027,500 earned in the wholesale distribution channel from all 10 customers. The three most profitable customers contribute 88% of total customer-level operating income. These customers deserve the highest service and priority. It is common for a small number of customers to contribute a high percentage of operating income. Microsoft uses the phrase “not all revenue dollars are endowed equally in profitability” to stress this point. Companies keep their best customers happy in a number of ways, including special phone numbers and upgrade privileges for elite-level frequent flyers and free usage of luxury hotel suites and big credit limits for high rollers at casinos. Concepts in Action: Amazon Prime and Customer Profitability describes how Amazon introduced Amazon Prime to support its most profitable customers.

Column 3 shows the profitability per dollar of revenue by customer. This measure of customer profitability indicates that, although Customer A contributes the second-highest operating income, the profitability per dollar of revenue is lowest among the top six customers because of high price discounts and higher customer-level costs (see sections Customer-Revenue Analysis and Customer-Level Costs). To increase operating income margins for Customer A, managers would need to decrease price discounts or save customer-level costs while maintaining or increasing sales. Customers D, F, and J have high operating income margins but low total sales. For these customers, managers would like to increase sales while maintaining margins. With Customers E, G, H, and I, managers have the dual challenge of boosting sales and operating income.

Presenting Profitability Analysis

Exhibit 15-5 illustrates two common ways of displaying the results of customer-profitability analysis. The bar chart presentation in Panel A (based on Exhibit 15-4, column 1) is an intuitive way to visualize customer profitability because (1) the highly profitable customers clearly stand out and (2) the number of “unprofitable” customers and the magnitude of their losses are apparent. Panel B of Exhibit 15-5 is a popular alternative way to express customer profitability. It plots the contents of Exhibit 15-4, column 5. This chart is called the whale curve because it is backward-bending at the point where customers start to become unprofitable (cumulative customer-level operating income goes from 111% after accounting for Customer E to 100% after accounting for Customer I) and thus resembles a humpback whale.*

Exhibit 15-5

Exhibit shows two graphs Panel A and Panel B depicting the profitability analysis. Details of each of the graph are as follows:

Panel A: Bar graph shows the customer level operating income for its wholesale channel customers ranging from A to J. Y-axis shows the customer level operating income ranging from negative $ 1,000,000 to positive $7,000,000 with increments of $1,000,000. All values are approximate here. Operating incomes of each wholesale channel customer are as follows:

Panel B

Line graph shows the whale curve that depicts the cumulative income as a percent of total income. Y-axis shows the cumulative income as a percent of total income ranging from 0 to 120% with increments of 20, and X-axis shows wholesale channel customers in the order of B, A, C, D, F, J, E, G, H, and I.

Exhibits 15-2 to 15-5 emphasize annual customer profitability. Managers should also consider other factors when prioritizing customers, including the following:

Managers should be cautious about discontinuing customers. In Exhibit 15-4, the current unprofitability of Customer G, for example, may not be indicative of Customer G’s profitability in the long run, for example, because of higher anticipated sales. Moreover, as in any ABC-based system, the costs assigned to Customer G are not all variable. In the short run, it may be efficient for the Provalue Division managers to use spare capacity to serve Customer G on a contribution-margin basis. Discontinuing Customer G will not eliminate all costs assigned to Customer G and may result in losing more revenues relative to costs saved.

Of course, particular customers might be chronically unprofitable and hold limited future prospects. Or they might fall outside a company’s target market or require unsustainably high levels of service relative to the company’s strategies and capabilities. In such cases, organizations sever customer relationships. For example, Capital One 360, one of the largest direct lenders and fast-growing financial services organizations in the United States, asks 10,000 “high maintenance” customers (for example, those who maintain low balances and make frequent deposits and withdrawals) to close their accounts each month.*