In: Accounting
Dace Company manufactures two products, Product F and Product G. The company expects to produce and sell 3,200 units of Product F and 2,100 units of Product G during the current year. Data relating to the company's three activity cost pools are given below for the current year:
Total Activity | ||||||||||||
Activity Cost Pool | Total Cost | Product F | Product G | Total | ||||||||
Machine setups | $ | 6,300 | 150 | setups | 150 | setups | 300 | setups | ||||
Purchase orders | $ | 53,320 | 530 | orders | 1,190 | orders | 1,720 | orders | ||||
Order size | $ | 64,020 | 3,620 | hours | 2,200 | hours | 5,820 | hours | ||||
Required:
Determine the overhead cost per unit for each product using the activity-based costing approach. (Do not round your intermediate calculations. Round your final answers to 2 decimal places.)
Solution
Total Activity cost | Activity Cost per unit | |
Product F | $ 59,400.00 | $ 18.56 |
Product G | $ 64,240.00 | $ 30.59 |
Calculation of Activity rates | |||||
Activity Cost Pool | Activity driver | Overhead Cost | Expected Activity (B) | Activity rate (A/B) | |
Machine Setups | Number of Setups | $ 6,300.00 | 300.00 | $ 21.00 | Per Setups |
Purchase Orders | Number of Orders | $ 53,320.00 | 1720 | $ 31.00 | Per Orders |
Order size | Number of Hours | $ 64,020.00 | 5820 | $ 11.00 | Per Hours |
Cost assigned to Product F | |||
Activity name | Activity Rates | Activity | ABC Cost |
(A) | (B) | (A x B) | |
Machine Setups | $ 21.00 | 150 | $ 3,150 |
Purchase Orders | $ 31.00 | 530 | $ 16,430 |
Order size | $ 11.00 | 3620 | $ 39,820 |
Total Overheads assigned | $ 59,400 | ||
Production | 3200 | ||
Overhead cost per unit | $ 18.56 |
Cost assigned to Product G | |||
Activity name | Activity Rates | Activity | ABC Cost |
(A) | (B) | (A x B) | |
Machine Setups | $ 21.00 | 150 | $ 3,150.00 |
Purchase Orders | $ 31.00 | 1190 | $ 36,890.00 |
Order size | $ 11.00 | 2200 | $ 24,200.00 |
Total Overheads assigned | $ 64,240.00 | ||
Production | 2100 | ||
Overhead cost per unit | $ 30.59 |