In: Accounting
Brisky 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 | $46,000 |
Supervisory expense | $12,200 |
Distribution of Resource Consumption Across Activity Cost Pools: | |||
Activity Cost Pools |
|||
Machining | Order Filling | Other | |
Equipment depreciation | 0.50 | 0.20 | 0.30 |
Supervisory expense | 0.50 | 0.10 | 0.40 |
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 I3 | 5,940 | 124 |
Product U8 | 14,600 | 923 |
Total |
20,540 |
1,047 |
Finally, sales and direct cost data are combined with Machining and Order Filling costs to determine product margins. |
Sales and Direct Cost Data: | ||
Product I3 | Product U8 | |
Sales (total) | $66,500 | $61,600 |
Direct materials (total) | $30,700 | $23,100 |
Direct labor (total) | $19,300 | $35,200 |
What is the product margin for Product I3 under activity-based costing? (Round your intermediate calculations to 2 decimal places and final answer to the nearest dollar amount.) |
$2,609
$11,391
$7,611
$6,831
Distribution of Resource Consumption Across Activity Cost Pools: | |||
Activity Cost Pools | |||
Machining | Order Filling | Other | |
Equipment depreciation | 23000 | 9200 | 13800 |
Supervisory expense | 6100 | 1220 | 4880 |
Now, the cost of machining per hour | |||
(Equipment depreciation for machining + supervisory expense for machining) / total machine hours | |||
($23000+6100) / 20540 machine hours | |||
1.42 | |||
$1.42 per hour | |||
Also,the cost of order filling per order | |||
(Equipment depreciation for order filling + supervisory expense for order filling) / total orders | |||
($9200+1220) / 1,047 orders | |||
$10420/1047 orders | |||
9.95 per order | |||
Now, for product I3, the total assigned overhead cost | |||
Cost of machining per hour * machine hours for product I3 + Cost of order filling per order * orders for product I3 | |||
$1.42 per hour * 5,940 machine hours + $9.95 per order * 124 orders | |||
$ 9,668.60 | |||
Also, the profit margin for product I3 | |||
Sales - (direct materials + direct labor + assigned overhead Cost) | |||
$66500-(30700+19300+9668.60) | |||
$ 6,831.40 | |||
Note : For Arthimetical calculations, Answers were calculated and rounded off upto 2 decimals. |