In: Accounting
Ramsey Company produces speakers (Model A and Model B). Both products pass through two producing departments. Model A's production is much more labor-intensive than that of Model B. Model B is also the more popular of the two speakers. The following data has been gathered for the two products:
| Product Data | ||
| Model A | Model B | |
| Units produced per year | 10,000 | 100,000 |
| Prime costs | $153,000 | $1,530,000 |
| Direct labor hours | 138,000 | 320,000 |
| Machine hours | 18,000 | 205,000 |
| Production runs | 40 | 70 |
| Inspection hours | 1,000 | 1,000 |
| Maintenance hours | 9,000 | 91,000 |
| Overhead costs: | ||
| Setup costs | $275,000 | |
| Inspection costs | 190,000 | |
| Machining | 430,000 | |
| Maintenance | 250,000 | |
| Total | $1,145,000 | |
| Required: | |
| 1. | Compute the overhead cost per unit for each product by using a plantwide rate based on direct labor hours. (Round to two decimal places.) |
| 2. | Compute the overhead cost per unit for each product by using ABC. (Round rates and unit overhead cost to two decimal places.) |
| 3. | Suppose that Ramsey decides to use departmental overhead rates. There are two departments: Department 1 (machine intensive) with a rate of $3.50 per machine hour and Department 2 (labor intensive) with a rate of $0.90 per direct labor hour. The consumption of these two drivers is as follows: |
|
Department 1 |
Department 2 |
|
|
Machine Hours |
Direct Labor Hours |
|
| Model A | 11,000 | 135,000 |
| Model B | 150,000 | 280,000 |
| Compute the overhead cost per unit for each product by using departmental rates. (Round to two decimal places.) | |
| 4. | CONCEPTUAL CONNECTION Using the activity-based product costs as the standard, comment on the ability of departmental rates to improve the accuracy of product costing. Did the departmental rates do better than the plantwide rate? |
Plantwide Rate
1. Compute the overhead cost per unit for each product by using a plantwide rate based on direct labor hours. (Round to two decimal places.)
Plantwide rate: per DLH
| Model A: overhead cost per unit | |
| Model B: overhead cost per unit |
Activity Rates
2. Compute the overhead cost per unit for each product by using ABC. (Round rates and unit overhead costs to two decimal places.)
| Model A: overhead cost per unit | |
| Model B: overhead cost per unit |
Note: Be sure to complete both tables below.
| Activity | Driver | Activity Rate |
| Setups | per | |
| Inspections | per | |
| Machining | per | |
| Maintenance | per |
| Overhead assignment | ||
| Model A | Model B | |
| Setups | ||
| Inspections | ||
| Machining | ||
| Maintenance | ||
| Total overhead | ||
| ÷ Units produced | ||
| Overhead per unit | ||
Departmental Rates
3. Suppose that Ramsey decides to use departmental overhead rates. There are two departments: Department 1: (machine intensive) with a rate of $3.50 per machine hour and Department 2: (labor intensive) with a rate of $0.90 per direct labor hour. The consumption of these two drivers is as follows:
|
Department 1 |
Department 2 |
|
|
Machine Hours |
Direct Labor Hours |
|
| Model A | 11,000 | 135,000 |
| Model B | 150,000 | 280,000 |
Compute the overhead cost per unit for each product by using departmental rates. (Round to two decimal places.)
| Model A: per unit | |
| Model B: per unit |
1.
Plantwide overhead rate = Budgeted overhead cost / Direct labor hours
Plantwide overhead rate = $1,145,000 / 458,000 = $2.5
Model A = 138,000*$2.5 / 10,000 = $34.5 per unit
Model B = 320,000*$2.5 / 100,000 = $8 per unit
2.
| Activity | Driver | Activity rate | |
| Setups | 110 | $2,500 ($275,000/110) | per production run |
| Inspection | 2,000 | 95 (190,000/2,000) | per inspection hour |
| Machining | 223,000 | 1.93 (430,000/223,000) | per machine hour |
| Maintenance | 100,000 | 2.5 (250,000/100,000) | per maintenance hour |
| Overhead Assignment | ||
| Model A | Model B | |
| Setups | $100,000 (40*$2,500) | $175,000 (70*$2,500) |
| Inspection | 95,000 (1,000*$95) | 95,000 (1,000*$95) |
| Machining | 34,709 (18,000*$1.92827) | 395,295 (205,000*$1.92827) |
| Maintenance | 22,500 (9,000*$2.5) | 227,500 (91,000*$2.5) |
| Total overhead | $252,209 | $892,795 |
| Units produced | 10,000 | 100,000 |
| Overhead per unit | $25.22 | $8.93 |
3.
Model A = 11,000*$3.50+135,000*$0.90 / 10,000
Model A = $38,500+121,500 / 10,000 = $16 per unit
Model B = 150,000*$3.50+280,000*$0.90 / 100,000
Model B = $525,000+252,000 / 100,000 = $7.77 per unit