Working
Overhead Absorption Rate (OAR) = Total Overhead/Total direct labour hours
OAR = 10,980,000/((7 x 900) + (5 x 800) x (8 x 1,000)) = 600 per labour hour
Overhead
➫ American = 600 x 7 x 900 = 3,780,000
➫ Butterfly = 600 x 5 x 800 = 2,400,000
➫ Comfy = 600 × 8 × 1,000 = 4,800,000
Profit statement |
Selling price
Prime cost
Contribution margin
Sales unit
Total contribution Less overhead
Net profit |
American
40,000
(35,000)
5,000
900
4,500,000
(3,780,000)
720,000 |
Butterfly
20,000
(16,000)
4,000
800
3,200,000
(2,400,000)
800,000 |
Comfy
30,000
(24,000)
6,000
1,000
6,000,000
(4,800,000)
1,200,000 |
Total profit = 720,000 + 800,000 + 1,200,000 = 2,720,000
(ii) Activity based costine (ABC).
Profit statement |
Selling price
Prime cost
Contribution margin
Sales units
Total contribution overheads
Processing cost (W1)
Assembly services (W2)
Quality control(W3)
Selling & Administration (W4)
Net profit |
American
40,000
(35,000)
5,000
900
4,500,000
1,044,000
882,000
643,500
751,875
1,178,625 |
Butterfly
20,000
(16,000)
4,000
800
3,200,000
696,000
560,000
572,000
1,002,500
369,500 |
Comfy
30,000
(24,000)
6,000
1,000
6,000,000
1,740,000
1,120,000
715,000
1,253,125
1,171,875 |
Working
OAR = Overhead Cost / Cost driver
W1
Processing services
Processing services =3,480,000 / (4 x 900 + 3 x 800 + 6 × 1,000) =
Sh 290 per hour
American - 290 x 4 × 900 = 1,044,000
Butterfly - 290 × 3 × 800 = 696,000
Comfy - 290 × 6 × 1,000 = 1,740,000
W2
Assembly services
Assembly services = 2,562,000 / (7 × 900 + 5 x 800 + 8 x 1,000 ) =
Sh 140 per hour
American 140 × 7 x 900 = 882,000
Butterfly 140 × 5 x 800 = 560,000
Comfy 140 x 8 x 1,000 = 1,120,000
W3
Quality control
Quality control = 1,930,500 / 54
= Sh 35,750 per hour
Number of run / set up
American 900 ÷ 50 = 18 runs x 35,750 = 643,500
Butterfly 800 ÷ 50 = 16 runs x 35,750 = 572,000
Comfy = 1,000 ÷ 50 = 20 runs x 35,750 = 715,000
Total number of runs 54
W4
Selling and administration (number of customer order)
3,007,500/(30+40 +50) = Sh 25,062.5 per customer order
American - 25,062.5 x 30 = 751,875
Butterfly - 25,062.5 x 40 = 1,002,500
Comfy - 25,062.5 × 50 = 1,253,125