1. Compute the total budgeted manufacturing overhead cost for the upcoming year. (Always use cell references and formulas where appropriate to receive full credit.) Activity Total Budgeted Indirect Cost $ 45,000 Materials handling Machine setups Insertion of parts Finishing Total budgeted indirect costs 2. Compute the manufacturing overhead cost per wheel of each model using ABC. (Always use cell references and formulas where appropriate to receive full credit.) Activity Allocated Activity Cost Per Wheel Standard Deluxe Materials handling Machine setups Insertion of parts Finishing Total ABC allocated indirect cost 3. 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 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 are as follows: Standard Deluxe Units 1,000 Expected production for each model Parts per wheel Setups per 1,000 wheels Finishing direct labor hours per wheel Total direct labor hours per wheel 4.0 20.0 6.0 20.0 3.0 1.0 2.7 3.8 TELE