CAN YOU ALSO EXPLAIN HOW TO CROSS REFERENCE THE CELLS FROM ONE SHEET INTO A FORMULA NEEDED IN ANOTHER SHEET ON EXCEL

Use ABC to allocate manufacturing overhead Several years after reengineering its production process, Dettling Corporation hired a new controller, Alana Metzgar. She developed an ABC system very similar to the one used by Dettling's chief rival Part of the reason Metzgar 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 system. Before adopting the new ABC system, 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 Cost Allocation Base Number of parts 4.50 per part Number o setups 325.00 per setup Number of parts 31.00 per part Finishing direct labor hours Allocation Rate Activit Materials handling Machine setup Insertion of parts Finishin 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 data for the upcoming year are as follows: Standard Deluxe Units 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 1,000 4.0 20.0 1.0 2.7 6.0 20.0 3.0 3.8 1. Compute the total budgeted manufacturing overhead cost for the upcoming year (Always use cell references and formulas where appropriate to receive full credit.) Total Budgeted Indirect Cost Activi 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.) Allocated Activity Cost Per Wheel Activi 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 Use this rate to determine the manufacturing overhead cost per wheel under the traditional system Manufacturing overhead cost per wheel Standard Deluxe