In: Accounting
Greenwood Company manufactures two products—14,000 units of Product Y and 6,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 | $ | 200,000 | 10,000 | MHs | ||
| Machine setups | Number of setups | $ | 100,000 | 200 | setups | ||
| Production design | Number of products | $ | 84,000 | 2 | products | ||
| General factory | Direct labor-hours | $ | 300,000 | 12,000 | DLHs | ||
| Activity Measure | Product Y | Product Z | ||||
| Machining | 8,000 | 2,000 | ||||
| Number of setups | 40 | 160 | ||||
| Number of products | 1 | 1 | ||||
| Direct labor-hours | 9,000 | 3,000 | ||||
1. Using the ABC system, how much total manufacturing overhead cost would be assigned to Product Z?
| Total maufacoring overhead cost | ? |
2. Using the plantwide overhead rate, what percentage of the total overhead cost is allocated to Product Y and Product Z?
| Total overhead cost | Product Y | Product Z |
| ?% | ?% |
3. Using the ABC system, what percentage of the Machining costs is assigned to Product Y and Product Z?
| Matching Cost | Product Y | Product Z |
| ?% | ?% |
4. Using the ABC system, what percentage of Machine Setups cost is assigned to Product Y and Product Z?
| Machine Setups Cost | Product Y | Product Z |
| ?% | ?% |
5. Using the ABC system, what percentage of the Product Design cost is assigned to Product Y and Product Z?
| Product Design Cost | Product Y | Product Z |
| ?% | ?% |
6. Using the ABC system, what percentage of the General Factory cost is assigned to Product Y and Product Z?
| General factory cost | Product Y | Product Z |
| ?% | ?% |
| 1 | ||
| Total manufacturing overhead cost | 237000 | |
| 2 | ||
| Total overhead cost: | ||
| Product Y | 75.00% | =9000/12000 |
| Product Z | 25.00% | =3000/12000 |
| 3 | ||
| Machining costs: | ||
| Product Y | 80.00% | =8000/10000 |
| Product Z | 20.00% | =2000/10000 |
| 4 | ||
| Machine Setups costs: | ||
| Product Y | 20.00% | =40/200 |
| Product Z | 80.00% | =160/200 |
| 5 | ||
| Product Design cost: | ||
| Product Y | 50.00% | =1/2 |
| Product Z | 50.00% | =1/2 |
| 6 | ||
| General Factory cost: | ||
| Product Y | 75.00% | =9000/12000 |
| Product Z | 25.00% | =3000/12000 |
| Workings: | ||
| Activity rate: | ||
| Machining | 20 | =200000/10000 |
| Machine setups | 500 | =100000/200 |
| Production design | 42000 | =84000/2 |
| General factory | 25 | =300000/12000 |
| Product Z: | ||
| Machining | 40000 | =2000*20 |
| Machine setups | 80000 | =160*500 |
| Production design | 42000 | |
| General factory | 75000 | =3000*25 |
| Total manufacturing overhead cost | 237000 |