In: Accounting
2nd question part 4
he Foundational 15 [LO7-1, LO7-3, LO7-4]
[The following information applies to the questions displayed below.]
Hickory Company manufactures two products—13,000 units of Product Y and 5,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 $684,000 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 | $ | 235,200 | 12,000 | MHs |
Machine setups | Number of setups | $ | 73,600 | 160 | setups |
Product design | Number of products | $ | 80,000 | 2 | products |
General factory | Direct labor-hours | $ | 295,200 | 14,400 | DLHs |
Activity Measure | Product Y | Product Z |
Machine-hours | 6,600 | 5,400 |
Number of setups | 40 | 120 |
Number of products | 1 | 1 |
Direct labor-hours | 7,600 | 6,800 |
13. Using the ABC system, what percentage of Machine Setups cost is assigned to Product Y and Product Z? (Round your "Percentage" answers to 2 decimal places.)
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? (Round your "Percentage" answers to 2 decimal place.)
Question 13
Solution
Product Y | Product Z | |
Machine Setups | 25.00% | 75.00% |
Question 14
Solution
Product Y | Product Z | |
Product design | 50.00% | 50.00% |
Question 15
Solution
Product Y | Product Z | |
General factory | 52.78% | 47.22% |
Working
Cost Drivers Rate | |||||
Activity | Cost Drivers | Total Activity Amount (A) | Level of Activity (B) | Activity Rate (C=A/B) | |
Machining | Machine hours | $ 235,200.00 | 12000.00 | $ 19.60 | per machine hour |
Machining setups | Number of setups | $ 73,600.00 | 160.00 | $ 460.00 | per setup |
Product design | Number of products | $ 80,000.00 | 2.00 | $ 40,000.00 | per product |
General factory | Direct labor hours | $ 295,200.00 | 14400.00 | $ 20.50 | per labor hour |
.
Overhead applied to (Product Y) | |||
Product Y | Activity rate(A) | Activity Driver Incurred (B) | Overhead Assigned (C=A*B) |
Machining | $ 19.60 | 6600 | $ 129,360.00 |
Machining setups | $ 460.00 | 40 | $ 18,400.00 |
Product design | $ 40,000.00 | 1 | $ 40,000.00 |
General factory | $ 20.50 | 7600.00 | $ 155,800.00 |
Total Overheads applied | $ 343,560.00 |
.
Overhead applied to (Product Z) | |||
Product Z | Activity rate(A) | Activity Driver Incurred (B) | Overhead Assigned (C=A*B) |
Machining | $ 19.60 | 5400 | $ 105,840.00 |
Machine Setups | $ 460.00 | 120 | $ 55,200.00 |
Product design | $ 40,000.00 | 1 | $ 40,000.00 |
General factory | $ 20.50 | $ 6,800.00 | $ 139,400.00 |
Total Overheads | $ 340,440.00 |
.
Overhead per unit as per ABC system | Total Overheads | |||||
Product Y | Product Z | Total | ||||
Machining | $ 129,360.00 | 55.00% | $ 105,840.00 | 45.00% | $ 235,200.00 | 100% |
Machine Setups | $ 18,400.00 | 25.00% | $ 55,200.00 | 75.00% | $ 73,600.00 | 100% |
Product design | $ 40,000.00 | 50.00% | $ 40,000.00 | 50.00% | $ 80,000.00 | 100% |
General factory | $ 155,800.00 | 52.78% | $ 139,400.00 | 47.22% | $ 295,200.00 | 100% |