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 | |