ABC Costing
ABC Costing
ABC Costing
Muntazim Limited produces three products. Its budget for the year ending 30 June 2016 depicts the
following:
X Y Z
Sales volume Untis. 840,000 660,000 520,000
Sales Rs. 140,000,000 200,000,000 250,000,000
Cost of raw material per unit of production Rs. 60 110 180
Direct labour hours per unit 0.5 1.0 1.5
Machine hours per unit 0.1 0.2 0.3
Material requisitions to be issued per day number 5 3 2
Inspection time per unit minutes 12 15 20
% of units to be inspected - 1% 2% 4%
Average time taken to process a sales order Hours 5 10 15
Average size of the sales order Units 20,000 12,000 10,000
Opening inventory Units 60,000 50,000 40,000
Closing inventory Units 20,000 90,000 120,000
(i) Manufacturing overheads are estimated at 50% of direct labour cost. Labour rate is Rs. 50
per hour. Manufacturing overheads represent the cost of Production department (40%),
Quality control department (30%), Materials management department (20%) and
Engineering department (10%).
(ii) Total administration and selling expenses are budgeted at Rs. 40 million. These represent
helad office costs (60%) and sales department costs (40%). Head office expenses are
allocated on the basis of sales value.
(iii) Cost of opening inventory per unit is the same as production costs for the budget period.
(iv) Units are inspected at the time of transfer to finished goods warehouse.
Required:
Prepare a product wise profit and loss account using activity based costing. (19)
(ICAP Module F, Sum-2015, Q.3)
Chapter 2 ACTIVITY BASED COSTING (13)
Question No. 2
RCL manufactures three products. Presently, overheads are allocated to each product on the basis of direct
labour hours. In order to determine the cost of products more accurately, RCL has decided to implement
Activity Based Costing for allocation of overheads.
The following data has been extracted from RCL’s budget for the next year:
Products X Y Z
Cost per unit: -------------Rupees -------------
Direct material @ Rs. 200 per kg 400 300 500
Direct labour @ Rs. 50 per hour 300 350 250
Other data:
Production units 50,000 40,000 25,000
Batch size units 500 250 250
Inspection time per batch hours 20 15 18
Economic order quantity (EOQ) kg 10,000 12,000 6,250
Details of factory overheads budgeted for the next year are as under:
Rs. in ‘000
Procurement department costs 2,500
Batch set up costs 3,600
Quality control department costs 4,510
Utilities 4,230
Salaries of supervisors and foremen 3,525
Salaries of cleaners and maintenance staff 1,410
Miscellaneous costs 705
Total 20,480
Required:
Compute product-wise cost per unit using Activity Based Costing. (12)
(ICAP Module F, Win-2012, Q.3)
Question No. 3
Super Autos (SA) manufactures components for auto industries. It started its business in 1960 in a small
workshop which has now developed into a fully automated factory with latest computerized machines.
For allocating overheads, SA has been using single plant-wide factory overhead absorption rate based on
direct labour hours. In view of strong competition, the company’s management is reviewing its pricing
strategies and wants to introduce a more accurate method of product costing.
Chapter 2 ACTIVITY BASED COSTING (14)
(i) Actual expenses for the quarter ended 31 March 2012 were as under:
Rupees
Direct wages (30,000 labour hours) 3,000,000
Machines operating expenses (50,000 machine hours) 2,500,000
Maintenance expenses 1,500,000
Technical staff expenses 2,000,000
Expenses of procurement 1,000,000
Expenses of finished goods stores and dispatch 1,600,000
Administration and selling expenses 5,000,000
Total 16,600,000
(ii) During the quarter:
60 purchase orders were processed and received.
120 sales orders were acquired and delivered.
150 batches were set for production.
Required:
Compute the unit cost of components LV and MV using:
Activity Based Costing; and
A single factory overhead rate based on direct labour hours (20)
(ICAP Module F, Sum-2012, Q.5)
Chapter 2 ACTIVITY BASED COSTING (15)
Question No. 4
XYZ Ltd presently uses a single plant wide factory overhead rate for allocating factory overheads to products,
based on direct labour hours. A break-up of factory overheads is as follows:
Factory overheads
Production Support 1,225,000
Others 175,000
Total cost (Rs.) 1,400,000
It now plans to use activity-based costing to determine costs of its products. The company performs four
major activities in the Production Support Department. These activities and related costs are as follows:
Production Support Activities Rupees
Set up costs 428,750
Production control 245,000
Quality control 183,750
Materials management 367,500
Total 1,225,000
The planning department has gathered the relevant information which is given below:
Direct No. of
Batch Machine Inspections
Production labour Material
Products size hours hours per
in units hours per requisitions
(units) per unit unit
unit raised
Product X 10,000 2.5 125 7.50 0.2 320
Product Y 2,000 5.0 50 10.00 0.5 400
Product Z 50,000 2.8 10,000 3.00 0.1 30
The quality control department follows a policy of inspecting 5% of all production in case of X and Y, 2% of
all units of Z.
Required:
Determine the factory overhead cost per unit for Products X, Y and Z under:
a. Single factory overhead rate method.
b. Activity Based Costing. (18)
(ICAP Module F, Sum-2009, Q.7)
Question No. 5
The following budgeted information of AJFA Limited for the year 2005 is provided to you:
DVD Player TV Set Hi-Fi System
Sales and production (units) 50,000 40,000 30,000
Selling price (per unit) Rs. 4,500 9,500 7,300
Prime cost (per unit) Rs. 3,200 8,400 6,500
Recovery of overhead allocated and apportioned to machine and assembly departments including service
centre costs is to be made at the following rates:
Machine department at Rs.120 per machine hour
Assembly department at Rs. 8.25 per direct labour hour
The details of the overheads for the year are as follows:
Rs. ‘000’
Machining services 35,700
Assembly services 31,800
Set-up costs 2,600
Order processing 15,600
Purchasing 8,400
94,100
You have also been provided with the following estimates:
DVD TV Set Hi-Fi
Player System
Number of set ups 120 200 200
Number of orders by the customers 8,000 8,000 16,000
Number of orders to the suppliers 3,000 4,000 4,200
Required:
(b) Briefly comment on the difference between the results obtained under the above alternatives. (03)
(ICAP Module F, Win-2005, Q.5)
Question No. 6
What is Activity Based Costing (ABC)? Explain it with examples. Also narrate the mechanism, advantages
and disadvantages of ABC. (15)
(PAC)
Chapter 2 ACTIVITY BASED COSTING (17)
ANSWERS
Answer To Question No. 1
This question required allocation of production and other costs, using activity based costing and preparation
of product wise profit and loss account. Overall performance in this question was good. However many
students made different types of errors as discussed below:
Many students did not differentiate between cost of sales and selling and administrative expenses.
They included selling and administrative costs in the per unit cost calculations.
Many students used sales as basis of computation of cost rather than production.
Some students computed production incorrectly by taking opposite effects of opening and closing
inventories.
Production department’s costs were allocated on the basis of units of production instead of labour
hours.
Quality control costs were allocated on the basis of number of units inspected or time required for
inspection per unit instead of total time required for inspection.
Cost of material management was allocated on the basis of material cost instead of number of
requisitions.
Cost of engineering department was allocated on the basis of labour hours instead of machine hours.
Allocation of production cost on the basis of production units to compute per unit cost
MUNTAZIM LIMITED
X Y Z Total
Rs. Rs. Rs. Rs.
Sales 140,000,000 200,000,000 250,000,000 590,000,000
Cost of sales (W-1) (83,823,664) (120,457,197) (152,022,265) (356,303,126)
Admin and selling costs (W-2) (7,876,733) (13,849,879) (18,273,388) (40,000,000)
Net profit 48,299,603 65,692,924 79,704,347 193,696,874
Chapter 2 ACTIVITY BASED COSTING (18)
X Y Z Total
Average size of the sales order 20,000 12,000 10,000
Number of orders processed
(sales volume ÷ average size) 42 55 52 149
Average time to process a sales order - 5 10 15
hrs
Total time to process sales orders 210 550 780 1,540
Allocation of head office costs i.e. Rs.
24,000,000 in the ratio of sales value (G) 5,694,915 8,135,593 10,169,492 24,000,000
Allocation of sales department costs i.e.
Rs. 16,000,000 in ratio of no. of
processed orders (H) 2,181,818 5,714,286 8,103,896 16,000,000
Administrative and selling costs (G+H) 7,876,733 13,849,879 18,273,388 40,000,000
This was quite a simple question based on activity based costing. The overall response to this question was
quite satisfactory; however, only about 3% of the students could secure full marks. Most of the students made
simple mistakes and lost easy marks. These are described below:
• Procurement department costs were to be allocated on the basis of number of purchase orders which
should have been computed by dividing the raw material consumption with the Economic Order
Quantity (EOQ). Instead, many students computed the number of purchase orders by dividing the
production with EOQ.
• Some students did not compute the number of batches and/or Inspection hour. Instead, they
allocated the costs of batch set up and quality control department on the basis of total production.
• Some students also erred in selecting the basis of allocation of utilities, salaries of supervisors and
foreman, salaries of cleaners and maintenance staff and miscellaneous expenses.
Answer (Solution by ICAP)
RCL
X Y Z Total
Production Units A 50,000 40,000 25,000
Cost allocation by activity:
1. Procurement department
Direct material cost per unit at B 400 300 500
Rs. 200 per kg.
Raw material consumption - kg B/200*A C 100,000 60,000 62,500
EOQ - kg D 10,000 12,000 6,250
No. of purchase orders C/D 10 5 10 25
Procurement department cost E 1,000 500 1,000 2,500
Chapter 2 ACTIVITY BASED COSTING (20)
This was a simple question on activity based costing. Most of the students were able to secure good marks.
The important observations of the examiner are as follows:
Some candidates could not comprehend the fact that the total expenses for the quarter pertained to
the entire activity whereas product-wise data was available for 2 main products only. Consequently,
they tried to allocate the entire amount of expenses to the two products.
Quite often, the admin and selling expenses were included in factory overheads.
Many students carried out unnecessarily lengthy calculations, for example, instead of allocating total
cost of the various departments to the products in one step, they allocated each and every cost
individually and hence wasted a lot of their valuable time.
Chapter 2 ACTIVITY BASED COSTING (21)
(W-3)
F. goods
Quality
Computation of cost driver rate: Production Procurement stores &
control
dispatch
Machines operating expenses 2,500,000
Maintenance expenses; 1,500,000 × 70%, 5%,
1,050,000 75,000 225,000 150,000
15%, 10%
Technical staff expenses:
Maintenance; (2,000,000 ×50%) × 70%, 700,000 50,000 150,000 100,000
5%, 15%, 10%
Others; 2,000,000 × 30%, 12%, 0%, 8% 600,000 240,000 - 160,000
Procurement - 1,000,000
Finished goods stores & dispatch - - 1,600,000 -
Overheads by department 4,850,000 1,365,000 1,975,000 410,000
Cost drivers 50,000 300 (150 ×
60 Purchase 120 Sales
machine 2) Quality
orders orders
hours inspections
Cost per driver 97 22,750 16,458.33 1,366.67
Chapter 2 ACTIVITY BASED COSTING (22)
X Y Z Total
Number of units A 10,000 2,000 50,000
Direct labour hours per unit B 2.5 5.0 2.8
Direct labour hours (A× B)* C 25,000 10,000 140,000 175,000
Total factory overheads D 1,400,000
Factory overhead rate per hour (D/C) E Rs.8
Cost per unit-single factory overhead rate
method (B x E) F 20 40 22.40
Production control
Machine hours per unit K 7.5 10.0 3.0
Total machine hours (A × K) L 75,000 20,000 150,000 245,000
Production control M 75,000 20,000 150,000 245,000
X Y Z Total
Quality control Allocation
No. of inspections N 5% 5% 2%
Units inspected (A × N) P 500 100 1,000
Hours per unit inspected Q 0.2 0.5 0.1
Total inspection hours (P × Q) R 100 50 100 250
Quality control costs S 73,500 36,750 73,500 183,750
Materials management
No. of requisitions T 320 400 30 750
Material management costs U 156,800 196,000 14,700 367,500
*NOTE BY PAC
As total direct labour hours and other FOH cost are the same number, therefore, redistribution of other
FOH cost not specifically disclosed. Adjusted within the calculation.
Chapter 2 ACTIVITY BASED COSTING (23)
Workings Notes
Assembly deptt.
(50,000 x 7 x 8.25) 2,888
(40,000 x 3 x 8.25) 990
(30,000 x 2 x 8.25) 495
_____ _____ ______
14,888 24,990 14,895
(W-8) PURCHASING
8,400,000 @ 3: 4: 4.2
The income statements prepared under both methods i.e. absorption costing and activity based
costing show profit for each case. Absorption costing shows product-wise more profit than activity
based costing.
However, activity based costing is considered more meaningful. As it identifies processes which are
cost drivers for application of overhead which give a more reliable and meaningful picture as
opposed to absorption costing that uses arbitrary/random basis such as direct labor hours or
machine hours as basis of application/ allocation of overhead costs. Moreover, in absorption costing
overheads amounting to Rs. 39,327 remained unapplied as such product wise profit is overstated.
Chapter 2 ACTIVITY BASED COSTING (25)
What is ABC?
Definition:
Activity-based costing (ABC) is an approach to costing and monitoring of activities which involves
identifying the activities that are responsible for the generation of costs.
Determination of cost driver rates (the value of the cost pool/driver volume). This is the equivalent
of an absorption rate under conventional absorption costing systems
Recovery and charging of overhead to product/ service based upon the demand for the activity.
Advantages of ABC
(a) The perceived benefit of introducing an activity – based costing system is that the unit costs should
more accurately reflect the activities performed and therefore the resources used.
(b) An improved more accurate product cost may enable a company to concentrate on a more profitable
mix of products or customers. ABC has been effectively used in identifying customers who are
unprofitable to service and products which are unprofitable to produce.
(c) It helps identify those activities that add more to value than cost, so that the non-value added items
can be appraised effectively with a view to elimination. As such it forces managers and supervisors to
consider the drivers that affect cost and what these drivers contribute to the final product.
(d) By focusing attention on cost drivers managers will have a better understanding of the costs of
production and the costs of the activities performed by the company.
Disadvantages of ABC
(a) ABC is a relatively new technique and as such management are not familiar with its principles and
methods and as such may be reluctant to introduce the system. A recent survey commissioned by
ACCA showed that only 4% of firms had actually adopted ABC.
(b) It is a more complex and costly technique to set up and operate than conventional costing system –
this is also likely to make management reluctant to adopt ABC.
(c) It has been pointed out by several authors that that ABC is unlikely to relate all overheads to specific
activities. It also ignores the potential for conflict, especially where there is more than one potential
cost driver. A fundamental problem in operating an ABC system is to identify what the cost driver is,
for a given cost pool.
Chapter 2 ACTIVITY BASED COSTING (27)