Chukwumah Nigeria Limited manufactures and sells three products X, Y and Z. The company is recently considering the introduction of an activity-based costing approach to facilitate efficient cost allocation, as well as achieve improvement in cost accuracy and reduction.

The new approach will use two direct costs categories (direct materials and direct labour) as well as five indirect cost pools which represent the five activity areas. The prior product costing system uses the two direct cost categories and a single indirect cost pool where overheads are allocated using direct labour hours.

The following information is provided for the next period:

Product X Product Y Product Z
Production and sales (units) 120,000 75,000 30,000
Direct material cost N190 N180 N160
Direct Labour Hours 6 8 7
Machine hours 4 8 9
Number of production runs 15 30 75
Number of component receipts 45 75 360
Number of production orders 45 30 75

Direct labour is paid at N8 per hour. Variable overhead is paid at N34 per unit for Product X, N44 per unit for Product Y and N38 per unit for Product Z.

Fixed Overhead Costs in the period are expected to be as follows:

N Cost Driver
Set up 1,260,000 Production Runs
Machine 8,100,000 Machine Hours
Goods inwards 2,520,000 Company Receipt
Packaging 1,800,000 Production Order
Engineering 1,620,000 Production Order

N15,300,000

Required:

a. Calculate the unit costs of each product using:

(i) Prior product costing approach (Traditional Cost) based on direct labour hourly rate.

(ii) The ABC method. (10 Marks)

b. The company considered the pricing of the three products where sales prices have remained uncertain as shown in the table below:

Product X Product Y Product Z
Prob. N Prob. N Prob. N
0.5 300 0.6 350 0.5 450
0.3 360 0.3 400 0.4 440
0.2 390 0.1 420 0.1 430

Compute the expected unit sales prices for the three products and the total profit or loss for each product that will arise from the implementation of the ABC costing approach and the traditional costing method.     (7 Marks)

c. State reasons why activity based costing approach may be preferred to traditional absorption costing approach in modern manufacturing environment.    (3 Marks)

a.

(i) Traditional costing unit costs:

Product X: ₦332

Product Y: ₦368

Product Z: ₦324

(ii) ABC unit costs:

Product X: ₦307.83

Product Y: ₦354.57

Product Z: ₦454.25

b. Expected unit sales prices:

Product X: ₦336

Product Y: ₦372

Product Z: ₦444

Total profit/loss under ABC:

Product X: ₦3,380,400

profit Product Y: ₦1,307,250

profit Product Z: ₦(307,500) loss

Under traditional:

Product X: ₦480,000

profit Product Y: ₦300,000

profit Product Z: ₦3,600,000 profit

c. Reasons for preferring ABC:

  • Provides more accurate product costs by assigning overheads based on activities that drive costs.
  • Better reflects the complexity of modern manufacturing with diverse products and processes.
  • Aids in identifying non-value-adding activities for cost reduction.