Challenges in advanced management accounting
Challenges in advanced management accounting

Start this free course now. Just create an account and sign in. Enrol and complete the course for a free statement of participation or digital badge if available.

Free course

Challenges in advanced management accounting

2.2.2 Applying Pareto analysis to customer profitability

It is often useful to distinguish between the most important few and the less important many in order to determine where management attention should be directed in keeping customers happy and/or cultivating relationships. The Pareto rule, that 80% of something is accounted for, or caused by, 20% of something else, often applies to customer profitability. These may not be the exact proportions but the general principle, that a high proportion of something is accounted for by a small proportion of something else, nevertheless often applies. Based on the assumed existence of this relationship, it can be helpful for management to undertake a Pareto analysis. For example, customers may be grouped by profitability to help management decide where their efforts should be directed, for example in KAM or CRM.

It is quite common to find that the top 20% of customers generate about 80% of total profit, the next 30% generate about 10% of total profit and the remaining 50% of customers generate about 10% or less of the total profit, as illustrated by the following example of DJM Ltd.

Example 1 Customer profitability analysis

DJM Ltd has 20 customers and has undertaken a Pareto analysis of customer profitability as shown below.

Table 12

CustomerProfit (£000s/year)Total profit (%)Cumulative profit (%)
A2,80026.3126.31
B2,47623.2649.57
C1,80016.9166.48
D1,60015.0381.51
E4003.7685.27
F2001.8887.15
G1761.6588.80
H1701.6090.40
I1301.2291.62
J1151.0892.70
K1101.0393.73
L1000.9494.67
M960.9095.57
N960.9096.47
O900.8597.32
P880.8398.15
Q800.7598.90
R640.6099.50
S320.3099.80
T200.19100.00
TotalTotal 10,643Total 100.00
(rounded)

It is useful to classify the top four customers as Class A customers and treat these as key accounts. The next six customers are treated as Class B customers, with less effort devoted to keeping them happy. All other customers receive relatively little attention.

It is sometimes helpful to illustrate the results of a Pareto analysis in a Pareto diagram, which shows the impact of each customer group on total profit, see Figure 2.

Described image
Figure 2 Pareto diagram for customer profitability

Stop and reflect

Internet retail outlets such as Amazon have thousands of customers in many countries. How could such companies use customer profitability analysis? They can no doubt trace the purchase history and related costs of each individual, but it may be useful to have categories of customer. Geographic region is one obvious category, gender or age might be others. Can you think of more possibilities?

This section has discussed how, in addition to knowing the costs (and hence the profitability) of providing particular products or services, an organisation should know the cost of serving different customers to determine their respective profitability. Many organisations’ cost and management accounting systems have focused only on product (rather than customer) costing. Increasingly, however, the impact of competitive pressures on profits is making it necessary for organisations to know the profitability of different customers. Activity based costing, although originally developed for product costing, can be adapted for this purpose. The next section lays the foundation for an important technique for addressing a different strategic challenge – making decisions about investments in projects.

B392_1

Take your learning further

Making the decision to study can be a big step, which is why you'll want a trusted University. The Open University has 50 years’ experience delivering flexible learning and 170,000 students are studying with us right now. Take a look at all Open University courses.

If you are new to university level study, find out more about the types of qualifications we offer, including our entry level Access courses and Certificates.

Not ready for University study then browse over 900 free courses on OpenLearn and sign up to our newsletter to hear about new free courses as they are released.

Every year, thousands of students decide to study with The Open University. With over 120 qualifications, we’ve got the right course for you.

Request an Open University prospectus