calculating activity-based costing overhead rates

E18-21

Calculating Activity-based Costing Overhead Rates

Assume that manufacturing overhead for Glassman Company in the previous exercise consisted of the following activities and costs:

Setup (1,000 setup hours)                                            $144,000

Production scheduling (400 batches)                       60,000

Production engineering (60 change orders)         120,000

Supervision (2,000 direct labor hours)                     56,000

Machine maintenance (12,000 machine hours)  84,000

Total activity costs                                                           $464,000

 

The following additional data were provided for Job 845:

Direct materials costs                                                     $7,000

Direct labor cost (5 Milling direct labor hours;

35 Finishing direct labor hours)                                  $1000

Setup hours                                                                       5 hours

Production scheduling                                                   1 batch

Machine hours used (25 Milling machine hours;

5 Finishing machine hours                                            30 hours

Production engineering                                                                3 change orders

 

a.       Calculate the cost per unit of activity driver for each activity cost category.

b.      Calculate the cost of Job 845 using ABC to assign the overhead costs.

c.       Calculate the cost of Job 845 using the plantwide overhead rate based on machine hours calculated in the previous exercise.

d.      Calculate the cost of Job 845 using the machine hour departmental overhead rate for the Milling Department and a direct labor hour overhead rate for the Finishing Department.

 

E18-24

Traditional Product Costing versus Activity Based Costing

Assume that Panasonic Company has determined its estimated total manufacturing overhead cost for one of its plants to be $204,000 consisting of the following activity cost pools for the month.

Activity Center                                 Activity Costs                    Cost Driver                         Activity Level

Assembly setup                                                $45,000                 Setup hours                                       1,500

Material Handling                            15,000                                  Number of moves                              300

Assembly                                            120,000                 Assembly hours                                             12,000

Maintenance                                       24,000                                 Maintenance hours        1,200

Total                                                   $204,000

Total direct labor hours used during the month were 8,000. Panasonic produced many different electronic products, including the following two products produced during the current month:

                                                                                                                Model x301                        Modelz205

                Units produced                                                                   1,000                                   1,000

                Direct material cost                                                     $15,000                                 $15,000

                Direct Labor Cost                                                          $12,500                             $12,500

                Direct Labor hours                                                                500                                         500

                Setup hours                                                                              50                                         100

                Material moves                                                                                       25                                           50                                   

                Assembly hours                                                                                     800                                         800

                Maintenance hours                                                                10                                          40

 

a.  Calculate the total cost per-unit cost of each model using direct labor hours to assign manufacturing overhead to products.

b.  Calculate the total per-unit cost of each model using activity-based costing to assign manufacturing overhead to products.

c.  Comment on the accuracy of the two methods for determining costs.

d.  Discuss some of the strategic implications of your answers to the previous requirements.