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 | $ | 82,000 | |||||
Supervisory expense | $ | 12,100 | |||||
Distribution of Resource Consumption Across Activity Cost Pools:
Activity Cost Pools | |||||
Machining | Order Filling | Other | |||
Equipment depreciation | 0.60 | 0.30 | 0.10 | ||
Supervisory expense | 0.60 | 0.20 | 0.20 | ||
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 | 5,480 | 197 |
Product M0 | 19,500 | 948 |
Total | 24,980 | 1,145 |
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) | $ | 71,600 | $ | 65,200 | ||||||
Direct materials (total) | $ | 30,000 | $ | 14,900 | ||||||
Direct labor (total) | $ | 21,900 | $ | 26,000 | ||||||
What is the product margin for Product W1 under activity-based costing? (Round your intermediate calculations to 2 decimal places.)
Activity cost pools | |||||
Machining | Order filling | Other | Total | ||
Equipment Depreciation | $49,200 | $24,600 | $8,200 | $82,000 | |
Supervisory expenses | $7,260 | $2,420 | $2,420 | $12,100 | |
Total | $56,460 | $27,020 | $10,620 | $94,100 | |
Activities | Costs | Cost drivers | Cost driver total | Overhead rate(Costs/Cost driver total) | |
Machining | $56,460 | No. of machine hours | 24,980 | $2.26 | per machine hrs |
Order Filling | $27,020 | No. of orders | 1,145 | $23.60 | per order |
Calculation of Product Costs | |||||
Product W1 | Product Mo | ||||
Activity Based usage | Activity Based usage*ABC rate | Activity Based usage | Activity Based usage*ABC rate | ||
Machining | 5480 | $ 12,385 | 19500 | $ 44,070 | |
Order Filling | 197 | $ 4,649 | 948 | $ 22,373 | |
Total Overhead Cost allocated | $ 17,034 | $ 66,443 | |||
Computation of Product Margin | |||||
Product W1 | Product Mo | ||||
Sales | $ 71,600 | $ 65,200 | |||
Less:Direct Materials | $ 30,000 | $ 14,900 | |||
Less:Direct labor | $ 21,900 | $ 26,000 | |||
Less:Overhead Costs | $ 17,034 | $ 66,443 | |||
Product Margin | $ 2,666 | $ -42,143 | |||