In: Accounting
Doede Corporation uses activity-based costing to compute product margins. In the first stage, the activity-based costing system allocates two overhead accounts--equipment depreciation and supervisory expense--to three activity cost pools--Machining, Order Filling, and Other--based on resource consumption. Data to perform these allocations appear below:
Overhead costs: | |||||||
Equipment depreciation | $ | 92,000 | |||||
Supervisory expense | $ | 4,000 | |||||
Distribution of Resource Consumption Across Activity Cost Pools:
Activity Cost Pools | |||||
Machining | Order Filling | Other | |||
Equipment depreciation | 0.60 | 0.20 | 0.20 | ||
Supervisory expense | 0.30 | 0.20 | 0.50 | ||
In the second stage, Machining costs are assigned to products using machine-hours (MHs) and Order Filling costs are assigned to products using the number of orders. The costs in the Other activity cost pool are not assigned to products.
Activity:
MHs (Machining) | Orders (Order Filling) | |
Product W1 | 4,200 | 800 |
Product M0 | 15,800 | 200 |
Total | 20,000 | 1,000 |
Finally, sales and direct cost data are combined with Machining and Order Filling costs to determine product margins.
Sales and Direct Cost Data:
Product W1 | Product M0 | |||||||||
Sales (total) | $ | 236,500 | $ | 262,000 | ||||||
Direct materials (total) | $ | 90,900 | $ | 123,900 | ||||||
Direct labor (total) | $ | 110,400 | $ | 76,100 | ||||||
What is the product margin for Product W1 under activity-based costing?
Multiple Choice
$23,356
$35,200
$7,996
-$12,800
Correct answer--------$7,996
Working
Sales Revenue | $ 236,500.00 |
Total Cost (90900+110400+27204) | $ 228,504.00 |
Profit margin | $ 7,996.00 |
.
Calculation of Activity rates | |||||
Activity Cost Pool | Activity driver | Overhead Cost (A) | Expected Activity (B) | Activity rate (A/B) | |
Machining | Number of MHs | $ 56,400* | 20000 | $ 2.82 | Per MHs |
Order filling | Number of order | $ 19,200 | 1000 | $ 19.20 | Per order |
*(92000*0.6)+(4000*0.3)
.
Cost assigned to Product W1 | |||
Activity name | Activity Rates | Activity | ABC Cost |
(A) | (B) | (A x B) | |
Machining | $ 2.82 | 4,200.00 | $ 11,844.00 |
Order filling | $ 19.20 | 800.00 | $ 15,360.00 |
Total Overheads assigned | $ 27,204 |