In: Accounting
Hickory 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 $729,600 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:
Activity Cost Pool | Activity Measure | Estimated Overhead Cost | Expected Activity | ||
Machining | Machine-hours | $ | 227,700 | 11,000 | MHs |
Machine setups | Number of setups | $ | 153,900 | 270 | setups |
Product design | Number of products | $ | 91,000 | 2 | products |
General factory | Direct labor-hours | $ | 257,000 | 13,200 | DLHs |
Activity Measure | Product Y | Product Z |
Machine-hours | 7,700 | 3,300 |
Number of setups | 60 | 210 |
Number of products | 1 | 1 |
Direct labor-hours | 8,700 | 4,500 |
Required :
9. Using the ABC system, how much total manufacturing overhead cost would be assigned to Product Y?
10. Using the ABC system, how much total manufacturing overhead cost would be assigned to Product Z?
11. Using the plantwide overhead rate, what percentage of the total overhead cost is allocated to Product Y and Product Z?
12. Using the ABC system, what percentage of the Machining costs is assigned to Product Y and Product Z?
13. Using the ABC system, what percentage of Machine Setups cost is assigned to Product Y and Product Z?
14. Using the ABC system, what percentage of the Product Design cost is assigned to Product Y and Product Z?
15. Using the ABC system, what percentage of the General Factory cost is assigned to Product Y and Product Z?
9) Overhead assigned to product Y under ABC
Product Y | |
Machining | 7700*20.7 = 159390 |
Machine setups | 570*60 = 34200 |
Product design | 45500 |
General factory | 257000/13200*8700 = 169836 |
Total overhead | 408476 |
10) Overhead assigned to product Z under ABC
Product Y | |
Machining | 3300*20.7 = 68310 |
Machine setups | 570*210 = 119700 |
Product design | 45500 |
General factory | 257000/13200*4500 = 87614 |
Total overhead | 321124 |
11) Percentage
Product y | Product Z | |
Direct labor hour | 8700/13200 = 65.91% | 4500/13200 = 34.09% |
12) Percentage
Product Y | Product Z | |
Machine hour | 7700/11000 = 70% | 30% |
13) Percentage
Product Y | Product Z | |
Machine setup | 60/2\0 = 22.22% | 210/270 = 77.78% |
14) Percentage
Product Y | Product Z | |
Product design | 1/2 = 50% | 50% |
15) Percentage
Product y | Product Z | |
General factory | 8700/13200 = 65.91% | 4500/13200 = 34.09% |