Activity Based System Question No 4 (with answer)

Question:

1(a) For below table, please fill up the following values

(i)   Overhead per cost driver unit

(ii)  Total Overhead per product per activity

(iii) Cost per item

Activity

Total Overheads

Total Cost driver units

Overhead per cost driver unit

Cost driver units per product

Total overhead per product per activity

$

Units

X

Y

Z

X

Y

Z

Machinery set-ups

20,000

230

140

80

100

-

-

-

Materials handling

12,000

90

12

14

14

-

-

-

Quality Control

24,000

120

75

55

70

-

-

-

Supervision

6,000

40

10

15

25

-

-

-

Maintenance

6,450

25

4

6

5

-

-

-

-

-

-

Number of units produced

1,100

450

450

$

$

$

Cost per item

Question

1(b): What is a cost driver unit, what do you understand by the term “cost driver unit”. Give an example for each activity listed in the above table.

SUGGESTED SOLUTION:

Part 1(a) is a simple illustration to identify all of the steps necessary to do the numerical part of an ABC question.

Activity

Total Overheads

Total Cost driver units

(i)         Overhead per cost driver unit

Cost driver units per product

(ii)                                                                           Total overhead per product per activity

$

Units

X

Y

Z

X

Y

Z

Machinery set-ups

20,000

230

86.96

140

80

100

12,174

6,957

8,696

Materials handling

12,000

90

133.33

12

14

14

1,600

1,867

1,867

Quality control

24,000

120

200.00

75

55

70

15,000

11,000

14,000

Supervision

6,000

40

150.00

10

15

25

1,500

2,250

3,750

Maintenance

6,450

25

258.00

4

6

5

1,032

1,548

1,290

31,306

23,621

29,602

Number of units produced

1,100

450

450

$

$

$

(iii)  Cost per item

28.46

52.49

65.78

Answer 1(b)

A cost driver is “an activity which generates cost”, such as number of quality inspections, or number of deliveries. The cost driver unit, therefore is one inspection, one delivery and so forth. Hours or weight may be cost driver units, depending upon the cost driver in question

Examples for each of the activities in the table are as follows:

Activity                                Possible cost driver unit

Machinery set-ups              Number of set-ups

Material handling                Kilograms of material handled

Quality control                    Inspection hour

Supervision                        Number of work teams

Maintenance                      Maintenance staff hours

Share and Enjoy:
  • Digg
  • del.icio.us
  • Netvouz
  • DZone
  • ThisNext
  • MisterWong
  • Wists

December 4, 2009  Tags: Activity based costing questions, Activity based costing questions and answers  Posted in: Activity-Based Costing

Leave a Reply


WordPress SEO fine-tune by Meta SEO Pack from Poradnik Webmastera
  • Google PageRank Checking tool