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 |