HELP! 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.

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,600 $ 31,000 11, 900 18,000 35, 700 54,000 $69,200 $103,000 14,200 ft. $ 4.87 Glassworks's controller wishes to apply activity-based costing (ABC) to allocate the $54,000 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 following information. Overhead Cost Category (Activity Cost Pool) Supervision Depreciation of machinery Assembly line preparation Total overhead Cost $ 2,160 28,840 23,000 $54,000 She has also collected the following information about the cost drivers for each category (cost pool) and the amount of each driver used by the two product lines. (Round activity rate and cost per unit answers to 2 decimal places.) Usage Overhead Cost Category (Activity Cost Pool) Supervision Depreciation of machinery Assembly line preparation Driver Direct labor cost ($) Machine hours Setups (number) Rounded Edge $6, 100 300 hours 32 times Squared Edge $11, 900 700 hours 95 times Total $18,000 1,000 hours 127 times Required: Answer is complete but not entirely correct. 1. Assign these three overhead cost pools to each of the two products using ABC. Activity Activity Rate Overhead Cost $ 21,600 X Activity Drivers 18,000 $ 12.00 of direct labor cost Supervision Depreciation of machinery Assembly line preparation Direct labor cost Machine hours 28,840 1,000 $ 28.84 Per machine hour 23,000 126 X Setups $ 182.54 X Per setup Rounded edge Activity rate Activity driver incurred Overhead assigned Squared edge Activity rate Activity driver incurred Overhead assigned Components 12.00 % of direct labor cost $ 11,900 1,428 Supervision Depreciation of machinery Assembly line preparation 28.84 Per machine hour 600 X 17,304 $ 182.54 Per setup 95 17,341 Total overhead cost 36,073 2. Determine average cost per foot for each of the two products using ABC. Rounded Squared edge edge Total direct material cost 9,400 $ 21,700 Total direct labor cost 6,100 11,900 Total overhead cost(ABC) 17,926 X 36,073 Total manufacturing cost 33,426 $ 69,673 Total production(feet) 10,600 14,200 Average cost per foot 3.15 $ 4.90 X 1. Assign these three overhead cost pools to each of the two products using ABC. Activity Activity Rate Overhead Cost $ 21,600 Activity Drivers 18,000 Supervision $ 12.00 % of direct labor cost Direct labor cost Machine hours 28,840 1,000 $ 28.84 Per machine hour Depreciation of machinery Assembly line preparation 23,000 126 X Setups 182.54 X Per setup Rounded edge Activity rate Activity driver incurred 6,100 Overhead assigned 12.00 % of direct labor cost $ 732 Supervision Depreciation of machinery Assembly line preparation $ 28.84 Per machine hour 400 11,536 X A 182.54 X Per setup 31 X 5,659 Total overhead cost 17,927 Squared edge Activity rate Activity driver incurred Overhead assigned Components Supervision Depreciation of machinery 12.00 % of direct labor cost $ 11,900 $ 1,428 28.84 Per machine hour 600 X 17,304