In: Accounting
Greenwood 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 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 |
$ |
249,600 |
12,000 |
MHs |
Machine setups |
Number of setups |
$ |
162,400 |
280 |
setups |
Production design |
Number of products |
$ |
92,000 |
2 |
products |
General factory |
Direct labor-hours |
$ |
309,600 |
12,000 |
DLHs |
Activity Measure |
Product Y |
Product Z |
||
Machining |
7,800 |
4,200 |
||
Number of setups |
40 |
240 |
||
Number of products |
1 |
1 |
||
Direct labor-hours |
8,800 |
3,200 |
||
1. |
What is the company’s plantwide overhead rate? (Round your answer to 2 decimal places.) Predetermined overhead rate_____ per DLH |
|||
Manufacturing overhead allocated: Product Y _______ Product Z____________
|
1 | Predetermined overhead rate=Total estimated overhead cost/Expected direct labor hours | ||||||||||
Total estimated overhead cost: | |||||||||||
Machining | 249600 | ||||||||||
Machine setups | 162400 | ||||||||||
Production design | 92000 | ||||||||||
General factory | 309600 | ||||||||||
Total | 813600 | ||||||||||
Expected direct labor hours=12000 hours | |||||||||||
Predetermined overhead rate=813600/12000=$67.8 per DLH | |||||||||||
2 | Manufacturing overhead allocated=Direct labor hours in the department*Predetermined overhead rate | ||||||||||
Product Y=8800*67.8=$596640 | |||||||||||
Product Z=3200*67.8=$216960 | |||||||||||
Activity rate=Estimated Overhead Cost/Expected Activity | |||||||||||
3 | For Machining,Activity rate=249600/12000=$20.8 per MH | ||||||||||
4 | For Machine setups,Activity rate=162400/280=$580 per setup | ||||||||||
5 | For production design,Activity rate=92000/2=$46000 per product | ||||||||||
6 | For gheneral factory,Activity rate=309600/12000=$25.8 per DLH | ||||||||||
7 | d. Machine setups activity | ||||||||||
8 | b. Product design activity | ||||||||||
9 | Overhead allocated=Expected activity for the product*Activity rate | ||||||||||
Y | |||||||||||
Machining | 7800*20.8 | 162240 | |||||||||
Machine setups | 40*580 | 23200 | |||||||||
Production design | 1*46000 | 46000 | |||||||||
General factory | 8800*25.8 | 227040 | |||||||||
458480 | |||||||||||
10 | Overhead allocated=Expected activity for the product*Activity rate | ||||||||||
Z | |||||||||||
Machining | 4200*20.8 | 87360 | |||||||||
Machine setups | 240*580 | 139200 | |||||||||
Production design | 1*46000 | 46000 | |||||||||
General factory | 3200*25.8 | 82560 | |||||||||
355120 | |||||||||||
11 | Y | Z | Total | ||||||||
Overhead allocated | 596640 | 216960 | 813600 | ||||||||
Precentage | 73.33% | 26.67% | |||||||||
Y | Z | Total | |||||||||
12 | Machining | 162240 | 87360 | 249600 | |||||||
Percentage | 65.00% | 35.00% | |||||||||
13 | Machine setups | 23200 | 139200 | 162400 | |||||||
Percentage | 14.29% | 85.71% | |||||||||
14 | Production design | 46000 | 46000 | 92000 | |||||||
Percentage | 50.00% | 50.00% | |||||||||
15 | General factory | 227040 | 82560 | 309600 | |||||||
Percentage | 73.33% | 26.67% | |||||||||