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.1 Tracing of costs to customers

In order to apply the activity-based costing approach it is necessary to identify the cost driver for a particular indirect cost and then establish a cost driver rate for charging the cost to a particular ‘cost object’, be it a product or customer. For example, the cost driver for sales order processing cost might be the number of orders taken. If the total sales order processing cost for a period is £150,000 and the number of orders taken is 1,000, then the cost driver rate will be:

Order processing costs should then be allocated to customers at a rate of £150 for every sales order received from the customer.

Activity 4 Calculate customer profitability using activity based costing

Timing: Spend about 25 minutes on this activity.

(This activity is adapted from Glad and Becker, 1995, pp. 57–58.)

Alpha Ltd has three customers: Beta, Gamma and Delta. The management accountant has collected the following data concerning sales, transactions and costs relating to the three customers, as follows:

Table 3

BetaGammaDelta
Sales revenue£120,000£150,000£90,000
Number of orders placed136639
Number of units sold300500450
Warehouse floor space occupied (square metres) 30 40 25

Table 4

Alpha’s indirect costs and cost drivers
£
Order taking (number of orders taken)1,534.00
Packing (number of units packed)5,250.00
Dispatch (number of units dispatched)4,312.50
Warehousing (cost of floor space occupied by goods)1,007.00
Account administration (number of orders taken)2,242.00

The gross profit on sales (based on the standard profit margin) is 30%. The directly traceable service and support costs (consisting of selling, delivery, financing and settlement discounts) for each customer are as follows.

Table 5

Beta:£13,120
Gamma:£18,476
Delta:£13,620

Using activity based costing, calculate the net profit for each of the three customers.

Note: You can assume that the number of units packed is the same as the number of units dispatched/sold.

Answer

Table 6 Calculation of cost driver rates

Order taking = £1,534/118= £13.00 per order
Packing = £5,250/1,250= £4.20 per unit
Dispatch = £4,312.50/1,250= £3.45 per unit
Warehousing = £1,007/95= £10.60 per square metre of floor space
Account administration = £2,242/118= £19.00 per order

Table 7 Customer activity costs

ActivityBetaGammaDelta
£££

Ord. taking

13 × £13 =16966 × £13 =85839 × £13 =507

Packing

300 × £4.20 =1,260500 × £4.20 =2,100450 × £4.20 =1,890

Dispatch

300 × £3.45 =1,035500 × £3.45 =1,725450 × £3.45 =1,553

W’housing

30 × £10.60 =31840 × £10.60 =42425 × £10.60 =265

Acc. admin

13 × £19.00 =Total 24766 × £19.00 =Total 1,25439 × £19.00 =Total 741

Total act’y

traced costs

Total 3,029Total 6,361Total 4,956

Table 8 Customer profitability analysis

BetaGammaDelta
£££
Sales revenue120,000150,00090,000
Gross profit (30% of sales)36,00045,00027,000
Directly traceable service/support costs13,12018,47613,620
Total activity costs (as per above analysis)3,0296,3614,956
Net profitTotal 19,851Total 20,163Total 8,424

Discussion

The calculations show that the ranking of customers in terms of total profit is the same as in terms of sales revenue:

Table 9

BetaGammaDelta
Revenue120,000150,00090,000
Ranking213
Net profit19,85120,1638,424
Ranking213

However, if profitability in terms of profit as a percentage of sales revenue is considered, a different picture emerges:

Table 10

BetaGammaDelta
Revenue120,000150,00090,000
Ranking213
Net profit as % of revenue16.5%13.4%9.4%
Ranking123

This is because both indirect costs and directly traceable service and support costs are (proportionately) highest for Delta and lowest for Beta (with Gamma in between):

Table 11

BetaGammaDelta
Indirect costs as % of revenue2.5%4.2%5.5%
Direct support as % of revenue10.9%12.3%15.1%

This analysis indicates that Delta consumes a proportionately (relative to sales revenue) higher amount of indirect and support resources than the other two customers. Gamma consumes significantly more resources than Beta, so that, although sales for Gamma are 25% higher than for Beta, the difference in profit is almost negligible.

It is appropriate at this point to add a cautionary note. Activity based costing has considerable potential for providing more accurate product and customer costing, but it is based on a number of assumptions which may not always hold true in practice. It effectively assumes a linear relationship between activities and costs which may not be realistic due to the existence of fixed costs and joint costs. It also assumes that the costs of individual activities are independent of each other and therefore separable (Noreen, 1991) which may also not always be the case. These assumptions limit the possible application of activity based costing in practice (Bhimani and Bromwich, 2010).

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