In: Accounting
X Company uses an activity-based costing allocation system. On January 1, 2020, its accountant budgeted the following costs and cost drivers for three of the activities that are used in the ABC system:
Activity | Budgeted cost | Cost driver |
Assembly | $79,000 | 90,400 parts |
Packaging | $47,400 | 14,600 finished units |
Purchasing | $31,600 | 4,700 purchase orders |
In May of 2020, 600 units of Product C were finished, requiring
$13,300 of direct materials, 4,000 direct labor hours, 1,382 parts,
and 49 purchase orders.
How much of the three activity costs was allocated to Product
C?
Solution
Cost assigned | |
Assembly | $ 1,208 |
Packaging | $ 1,948 |
Purchasing | $ 329 |
Alternate answer where allocation rate is rounded to 2 decimal.
Cost assigned | |
Assembly | $ 1,202 |
Packaging | $ 1,950 |
Purchasing | $ 329 |
Working
Calculation of Activity rates | |||||
Activity Cost Pool | Activity driver | Overhead Cost (A) | Expected Activity (B) | Activity rate (A/B) | |
Assembly | Number of part | $ 79,000 | 90400 | $ 0.87 | Per part |
Packaging | Number of finished unit | $ 47,400 | 14600 | $ 3.25 | Per finished unit |
Purchasing | Number of Purchase order | $ 31,600 | 4700 | $ 6.72 | Per Purchase order |
.
Cost assigned to Product C | |||
Activity name | Activity Rates | Activity | ABC Cost |
(A) | (B) | (A x B) | |
Assembly | $ 0.87 | 1,382.00 | $ 1,202.34 |
Packaging | $ 3.25 | 600.00 | $ 1,950.00 |
Purchasing | $ 6.72 | 49.00 | $ 329.28 |