Customer Profitability Analysis

An analysis of the various activities and expenses incurred in servicing a customer in a given period of time

Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.

What is Customer Profitability Analysis?

Customer Profitability Analysis is a tool from managerial accounting that shifts the focus from product line profitability to individual customer profitability. Activity Based Costing looks at the various cost drivers to accurately isolate costs and determine a product’s profitability.

In contrast, Customer Profitability Analysis is a method of looking at the various activities and expenses incurred in servicing a particular customer. In other words, it focuses on analyzing profit per customer rather than profit per product.

Customer Profitability Analysis

Calculating Customer Profitability

Calculating customer profitability begins by identifying the various costs incurred specifically in relation to servicing a specific customer or segment of customers.

For example, a solar panel company serves two types of customers: Individuals and Small Medium Enterprises (SMEs). For the attainment, servicing, and retention of its customers, the company is required to provide consulting and service visits, as well as process sale orders. Individuals require only one site visit before placing an order.

SMEs require more frequent visits, as they are based in multiple locations and are provided with after-sale service as part of the bulk purchase. The customers’ behavior and profitability are given by the following table:

Customer Profitability Analysis Table

Customer Behavior Table

Application of Customer Profitability Analysis

From the given example, the customer profitability of the Individual segment exceeds the SME segment. This insight then supports the company in its strategic decisions. It can shift its focus towards attracting and retaining more customers from the more profitable Individual segment. Alternatively, it can look for cost reduction approaches for its SME segment.

Potentially, it can work to redesign its purchasing process in order to reduce the frequency of visits or orders. Otherwise, it can look to charge its customers for additional service visits to shift the weight of the cost from the company to the customer.

Benefits of Customer Profitability Analysis

These insights might not be attainable from traditional reporting methods. In a company’s income statement, there is no granularity provided in the calculation of its Selling, General, and Administrative Expense line.

One of the most common marketing metrics of sales per segment may also be misleading. If the company reported 120 customers in the Individual segment and 80 customers in the SME segment, managers might believe that SMEs contribute to two-thirds of their annual sales.

Sales by Segment Table

Sales by Segment Chart

By following the Pareto 80-20 Rule, they conclude that they should focus on this smaller group of customers that contribute to a larger share of annual revenue. However, as we know from the added analytical granularity offered by the above Customer Profitability Analysis, they would then be allocating more resources to a less profitable customer segment.

Customer Profitability by Segment Table

Customer Profitability By Segment Chart

By examining Customer Profitability rather than just sales, the company will gain a more accurate insight into which customer segment is the stronger driver of its overall profitability.

Criticism of Customer Profitability Analysis

The biggest criticism regarding Customer Profitability Analysis is the selection of a limited time frame and segmentation criteria. However, with the emergence of Big Data, customer profitability can be calculated using new methods that determine a customer’s lifetime value rather than just the sales within a restricted time frame.

Additionally, with respect to segmentation, predictive analytics will be able to estimate the value of individual customers by identifying drivers in behavioral patterns rather than just the value of the average customer in its respective segment.

More Resources

Thank you for reading CFI’s guide to Customer Profitability Analysis. To keep advancing your career, the additional free CFI resources below will be useful:

0 search results for ‘