In: Accounting
Greenwood Company manufactures two products—15,000 units of Product Y and 7,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products Y and Z:
Using the ABC system, what percentage of the Machine Setups is assigned to Product Y and Product Z?
Activity cost pool | activity measure | estimated overhead cost | expected activity |
Machining | machine hours | 216700 | 11000 |
machine setups | number of setups | 79900 | 170 |
production design | number of products | 81000 | 2 |
general factory | direct labor hours | 247000 | 10000 |
Activity measure | product Y | product Z | |
machining | 67000 | 4300 | |
number of setups | 60 | 110 | |
number of products | 1 | 1 | |
direct labor hours | 7700 | 2300 |
The correct answer is :
Product Y = 35.29% as $ 28,200 is assigned
Product Z = 64.71% as $ 51,700 is assigned
Percentage of Cost Allocated of Machine Setup = Cost Allocated / Total Cost | ||||
Cost Allocated | Total Cost | Percentage | ||
product Y | 28,200.00 | 79,900.00 | 35.29 % | |
product Z | 51,700.00 | 79,900.00 | 64.71 % | |
Note :
1. Activity Rate
Activity cost pool | activity measure | estimated overhead cost | expected activity | Activity Rate ( Estimated Overhead Cost / Expected Activity) |
Machining | machine hours | 2,16,700 | 11,000 | 20 |
machine setups | number of setups | 79,900 | 170 | 470 |
production design | number of products | 81,000 | 2 | 40,500 |
general factory | direct labor hours | 2,47,000 | 10,000 | 25 |
2.
Cost Allocated of Machine Setup = Activity Rate * Number of Setups |
Activity measure | product Y | product Z | Activity Rate |
number of setups | 60 | 110 | 470 |
product Y | 60 * 470 |
28,200 | |
product Z | 110 * 470 |
51,700 |