1. Assign these three overhead cost pools to each of the two products using ABC.
Activity |
Overhead cost | Activity drivers | Activity rate | ||
Supervision | $2,160 | $18,000 | Direct Labour cost | 12.00% | of direct Labour costs |
Depreciation of machinery | $28,840 | 1,000 | Machine hours | $28.84 | Per machine hour |
Assembly line preparation | $23,000 | 124 | Setups | $185.48 |
Per setup |
Rounded edge | Activity rate | Actual driver included | Overhead assigned | |
Supervision | 12.00% | of direct Labour cost | $6,100 | $732 |
Depreciation of machinery | $28.84 | per machine hour | 400 | $11,536 |
Assembly line preparation | $185.48 | per setup | 31 | $5,750 |
Total overhead cost | $18,018 |
Squared edge | Activity rate | Actual driver included | Overhead assigned | |
Supervision | 12% | of direct Labour cost | $11,900 | $1,428 |
Depreciation of machinery | $28.84 | per machine hour | 600 | $17,304 |
Assembly line preparation | $185.48 | per setup | 93 | $17,250 |
Total overhead cost | $35,982 |
2. Determine average cost per foot for each of the two products using ABC
Rounded edge | Squared edge | |
Total direct material cost | $9,600 | $21,600 |
Total direct Labour cost | 6,100 | 11,900 |
Total overhead cost(ABC) | 18,018 | 35,982 |
Total manufacturing cost | $33,718 | $69,482 |
Total production (feet) | 10,300 | 14,200 |
Average cost per foot | $3.27 | $4.89 |
____×____
All the best
Exercise 4-14 Activity-based costing LO P3 A2 Glassworks Inc. produces two types of glass shelving, rounded...
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,100 18,300 $ 33,800 10,600 ft. $ 3.19 Squared Edge Total $ 21,700 $ 31,100 11,900 18,000 35,700 54,000 $ 69,300 $...
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-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-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...
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...
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 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,600 6,200 18.600 $34,400 10,500 ft. $ 3.28 Squared Edge Total $21,500 $ 31,100 11,900 18,100 35,700 54,300 $69,100 $103,500 14,200 ft. $ 4.87 Glassworks's controller wishes to apply activity-based...
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. Rounded Edge Squared Edge $21,700 11,900 35,700 $69,300 Total Direct materials $9,400 31,100 17,900 53,700 Direct labor 6,000 Overhead (300% of direct labor cost) 18,000 $33,400 $102,700 Total cost 10,600 ft. $ 3.15 Quantity produced 14,100 ft 4.91 Average cost per ft. (rounded) Glassworks's controller wishes to apply activity-based costing (ABC) to...