q2

Metzger. She developed an ABC wystem very similar to the one used by Dettling'schiefval. Part of the reason Metrgar developed the ABC system was because Detting profits had been declining even though the company had shifted its product mix toward the product that had appeared most profitable under the old witem. Before adopting the new ABC wystem, the company had used a plantwide overhead rate based on direct labor hours that was developed years ago For the upcoming year, Dettling's budgeted ABC manufacturing overhead allocation rates are as follows: Activity Materials handling Machine setup Insertion of parts Allocation Base Number of parts Number of setups Number of parts Finishing direct labor hours Activity Cost Allocation Rate $ 4.50 per part $325.00 per setup $ 31.00 per part Finishing $ 51.00 per hour The number of parts is now a feasible allocation base because Dettling recently installed a plantwide computer system. Dettling produces two wheel models: Standard and Deluxe Budgeted data for the upcoming year areas Hollow Deluxe Units 1,000 Standard Expected production for each model Parts per wheel 4.0 Setups per 1,000 wheels 20.0 Finishing direct labor hours per wheel 1.0 Total direct labor hours per wheel 2.7 e the blue shaded areas on the ENTERANSWERS tab for inputs ways use cell references and formulas where appropriate to receive full credit. 6.0 20.0 3.0 3.8 quirements 1 Compute the total budgeted manufacturing overhead cost for the upcoming year. 2 Compute the manufacturing overhead cost per wheel of each model using ABC. 3 Compute the company's traditional plantwide overhead rate. Use this rate to determine the manufacturing overhead cost per wheel under the traditional system, 1 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. 2 (Always use cell references and formulas where appropriate to receive full credit.) D F Total Budgeted Activity Indirect Cost s Materials handling 6 Machine setups 7 Insertion of parts 8 Finishing 9 Total budgeted indirect costs 10 11 2. Compute the manufacturing overhead cost per wheel of each model using ABC. 12 Always use cell references and formulas where appropriate to receive full credit.) 13 14 Activity Allocated Activity Cost Per Wheel 15 Standard Deluxe 16 Materials handling 27 Machine setups 18 Insertion of parts 9 Finishing 0 Total ABC allocated indirect cost 1 23. Compute the company's traditional plantwide overhead rate. (Always use cell references and formulas where appropriate to receive full credit.) Plant overhead rate per direct labor hour Use this rate to determine the manufacturing overhead cost per wheel under the traditional system Manufacturing overhead cost per wheel Standard Deluxe