Barnett Products manufactures three types of remote-control devices: Economy, Standard, and Deluxe. The company, which uses activity-based costing, has identified five activities (and related cost drivers). Each activity, its budgeted cost, and related cost driver is identified below. Activity Cost Cost Driver
Material handling $225,000 Number of parts
Material insertion 2,475,000 Number of parts
Automated machinery 840,000 Machine hours
Finishing 170,000 Direct labor hours
Packaging 170,000 Orders shipped
Total $3,880,000

The following information pertains to the three product lines for next year:

Economy Standard Deluxe
Units to be produced 10,000 5,000 2,000
Orders to be shipped 1,000 500 200
Number of parts per unit 10 15 25
Machine hours per unit 1 3 5
Labor hours per unit 2 2 2

Required:
a. What is Barnett's pool rate for the material-handling activity?
b. Under Barnett's activity-based costing system, what is the per-unit overhead cost of Economy?

Solution :

Particulars                        Economy       Standard        Delux               Total

Units produced (a)              10000             5000           2000               17000

Orders shipped (b)              1000                 500            200                  1700

No. of orders per unit (c)       10                      15               25

Total no. of parts (c)x(a)     100000           75000         50000             225000

Machine hrs per unit (d)           1                     3                  5

Total machines hrs (d)x(a)    10000            15000         10000                 35000

Lab hrs per unit (e)                   2                      2               2

Total lab hrs (e)x(a)               20000             10000       4000               34000

Pool rate for material handling activity

                                                               

                                                               = $ 1

a). Material handling cost per part

                                                               

                                                               = $ 1

b). Material insertion cost per part

                                                         

                                                          = $ 11

c). Cost per machine hours

                                           

                                            = $ 24

d). Cost per labor hours

                                       

                                        = $ 5

e). Cost per unit shipped

                                       

                                        = $ 10

Cost per unit overhead = (1 x 10) + (11 x 10) + (24 x 1) + (5 x 2) + (10 x 1)

                                       = $ 164

Given:

howler monkey: {15, 16, 17, 17, 17, 17, 18, 19}
spider monkey: {12, 13, 13, 14, 14, 14, 16, 16}

The mean of the first set (howler monkey) = (15 + 16 + 17 + 17 + 17 +17 + 18 + 19)/ 8 
The sum of all weights is divided by the number of monkeys weighed (n = 8)

mean = 17

Do the same for the second set (spider monkey) = 12+ 13 + 13+ 14 + 14+ 14 +14 +16 + 16 / 8

mean = 15.75

The ratio of the two is 17:15.75 or 1.08 is to 1.