I need help working this excel problem

2 Use ABC to allocate manufacturing overhead Several years after reengineering its production process, Deitling Corporation hired a new controller, Alana Metzar. She developed an ABC wystem very similar to the one used by Dettling's chief rival Part of the reason Metatar developed the ABC system was because Dettling's profits had been declining, even though the company had shifted its product mix toward the product that had appeared most profitable under the old svitem. Before adopting the new ABC system, the company had used a plantwide overhead rate based on direct labor hours that was developed years ago 5 For the upcoming year, Dettling's budgeted ABC manufacturing overhead allocation rates are as follows: 7 Activity Cont B Activity Allocation Base Allocation Rate Materials handling Number of parts S 4.50 per part 10 Machine setup Number of setups $325.00 per setup Insertion of parts Number of parts $ 31.00 per part Finishing direct 12 Finishing Tbor hours S 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 44 data for the upcoming year are as follows: 15 18 Standard Deluxe Units Expected production for each model 1,000 Parts per wheel 400 6.0 0 Setups per 1.000 wheels 20.0 20.0 U Finishing direct labor hours per wheel 1.0 1 Total direct labor hours per wheel 3.8 310 2.1 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use coll references and formulas where appropriate to receive full credit Requirements 1 Compute the total budgeted manufacturing overhead cost for the upcoming year 2. Compute the manufacturing overhead cost per Wheel of lach modeling ABG Compute the company traditional plantwide overhead rute. Use this cate to determine the manufacturing overhead cost per Wheel under the traditional stem. Instructions P PC 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. (Always use cell references and formulas where appropriate to receive full credit.) 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) 3. Compute the company's traditional plantwide overhead rate. Use this rate to determine the manufacturing overhead cost per Wheel under the traditional system. (Always use cell references and formulas where appropriate to receive full credit)