1.
Activity | Overhead Cost | Activity Drivers | Activity rate | ||
Supervision | $2,160 | $18,000 | Direct labor | 12% | Percentage |
Depreciation of machinery | $28,840 | 1000 | Machine Hours | $28.84 | Per MH |
Assembly line preparation | $23,000 | 126 | Setups | $182.54 | Per Setups |
Rounded Edge | Activity Rate | Activity Driver Incurred | Overhead Assigned | ||
Supervision | 12% | Direct Labor Cost | $6,100 | $732 | |
Depreciation of machinery | $28.84 | Machine Hours | 400 | Hours | $11,536 |
Assembly line preparation | $182.54 | Setups | 31 | Times | $5,658.74 |
$17,926.74 |
Squared Edge | Activity Rate | Activity Driver Incurred | Overhead Assigned | ||
Supervision | 12% | Direct Labor Cost | $11,900 | $1,428 | |
Depreciation of machinery | $28.84 | Machine Hours | 600 | Hours | $17,304 |
Assembly line preparation | $182.54 | Setups | 95 | Times | $17,341.30 |
$36,073.30 |
____________________________________________________________________________________________
2.
Compute Average Cost per foot as follows:
Rounded Edge | Square Edge | |
Direct Materials | $9,400 | $21,700 |
Direct Labor | $6,100 | $11,900 |
Assigned Overhead as per ABC system | $17,926.74 | $36,073.30 |
Total Cost | $33,426.74 | $69,673.30 |
Quantity produced | 10600 ft. | 14200 ft. |
Average cost per ft. | $3.15 | $4.90 |
Exercise 17-14 Activity-based costing LO P3 A2 Glassworks Inc. produces two types of glass shelving, rounded...
Exercise 4-14 Activity-based costing LO P3 A2 Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials Direct labor Overhead (3001 of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $9.500 6. 100 18,300 $34,000 10,300 ft. $ 3.30 Squared Edge Total $21.600 31,200 11,900 18,000 35,700 54,000 $69,200 $103,200 14,200 ft. $ 4.87...
Exercise 17-14 Activity-based costing LO P3 A2 Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materiale Direct labor Overhead (300% of direct labor cost) Total cost Quantity produced Average coat per ft. (rounded) Rounded Edge Squared Edge Total $ 9,500 $21,500 $ 31,000 6,100 12,000 18,100 18,300 36,000 54,900 $33,900 $69,500 $103,900 10, 400 ft. 14,100 ft $ 3.26...
Exercise 17-14 Activity-based costing LO P3 A2 Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials Direct labor Overhead (300% of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9,400 6,200 18,600 $34,200 10,400 ft. $ 3.29 Squared Edge Total $21,700 $ 31,100 12,000 18,200 36,000 54,600 $69,700 $103,900 14,100 ft. $...
Exercise 17-17 Activity-based costing LO P3 Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials Direct labor Overhead (300$ of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9,300 6,000 18,000 $33,300 10,700 ft. $ 3.11 Squared Edge Total $21,400 $ 30,700 12,000 18,000 36,000 54,000 $69,400 $102,700 14,200 ft. $ 4.89...
HOW DO I CALCULATE? Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials Direct labor Overhead (300% of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9,700 6,100 18,300 $34,100 10,600 ft. $ 3.22 Squared Edge Total $21,600 $ 31,300 11,900 18,000 35,700 54,000 $69,200 $ 103,300 14,200 ft. $ 4.87 Glassworks's...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials Direct labor Overhead (382% of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9,500 6.100 18,388 $ 33,982 10,688 ft. $ 3.20 Squared Edge Total $ 21,500 $ 31,000 11,900 18,00 35.700 54,00 $ 69,182 $183,888 14,288 ft. $ 4.87 Glassworks's controller wishes...
Glassworks Inc. produces two types of glass shelving, rounded edge and scared edge, on the same production line. For the current period, the company reports the following data Over 1000 of direct labe ) Quantity pod Average cost per t rouded Glassworks's controller wishes to apply activity based costing (ABC) to allocate the $54000 of overhead costs incurred by the two product lines to see whether cost per foot would change markedly from that reported above. She has collected the...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data Direct materials Direct labor Overhead (300x of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9,600 6,100 18,309 534,000 10,700 ft. $ 3.18 Squared Edge Total $21,800 $ 31,400 11,900 18.000 35,700 54,000 569,400 $103, 400 14,200 ft. Glassworks's controller wishes to apply activity-based costing...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials Direct labor Overhead (3008 of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9, 700 6.100 18,300 $34,100 10,300 ft. $ 3.31 Squared Edge Total $21,700 $ 31,400 11.900 18.000 35,700 54,000 $69,300 $103,400 14,000 ft. S 4.95 Glassworks's controller wishes to apply...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. ota Direct materials Direct labor Overhead (300% of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) 6,100 18,300 34,100 10,300 ft. 11,980 5,700 A 18,000 54,000 69,300 103,400 14,000 ft. $ 3.31 4.95 Glassworks's controller wishes to apply activity-based costing (ABC) to allocate the $54,000 of overhead costs...