In: Accounting
PROBLEM - "ABC"
A company manufactures Product X and Product Y in the same factory.
Overhead costs are currently allocated using direct labor hours,
but the accounting manager has recommended an activity-based
costing system using the data in the table provided below. Answer
the following two questions: a) determine the amount of overhead to
be allocated to each type of product under activity-based costing;
b) determine the amount of overhead to be allocated to each type of
product using labor hours as the allocation base. Assume 60,000
labor hours were used to manufacture Product X and 20,000 labor
hours were used to manufacture Product Y.
| 
 Activity Level  | 
|||||||
| 
 Activity  | 
 Cost Driver  | 
 Cost  | 
 ProductX  | 
 Product Y  | 
|||
| 
 Production Setup  | 
 # of production setups  | 
 $ 100,000  | 
 12  | 
 8  | 
|||
| 
 Material Handling  | 
 # of parts  | 
 $ 20,000  | 
 70  | 
 30  | 
|||
| 
 Shipping  | 
 # of units shipped  | 
 $ 160,000  | 
 120,000  | 
 140,000  | 
|||
| 
 TOTAL OVERHEAD  | 
 $ 280,000  | 
||||||
| a.) | Product X | Product Y | |
| Production Setup | 60,000 | 40,000 | |
| Material Handling | 14,000 | 6,000 | |
| Shipping | 73,846 | 86,154 | |
| Overhead allocated $ | 147,846 | 132,154 | |
| Working | |||
| Product X | Product Y | ||
| Production Setup | =100000*12/20 | =100000*8/20 | |
| Material Handling | =20000*70/100 | =20000*30/100 | |
| Shipping | =160000*120000/260000 | =160000*140000/260000 | |
| Overhead allocated | 147,846 | 132,154 | |
| b.) | Predetermined overhead rate | $ 3.50 | =280000/(60000+20000) | 
| ( Per Labor Hour ) | |||
| Overhead allocated | |||
| Product X | $ 210,000 | =3.5*60000 | |
| Product Y | $ 70,000 | =3.5*20000 | |