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