How should this be completed in Excel with the Excel formulas ?

Updated photos

Fde Insert Data Enable A1 G H 3 Home Page Layout Formules Review View Help O PROTECTED VIIW Beeweltfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View X Activity Based Costing Lean Operations, and the costs of Quality D Activity Based Corting, Lean Operations, and the Costs of Quality 2 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 4 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 6 follows: 7 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 10 11 12 Finishing $ $1.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 114 data for the upcoming year are as follows: INSTRUCTIONS ENTERANSWERS AS G 1 1 Fle Home Page Layout Formula Review View Help shu O POTICHID VIEW Beetom tenet cantiesies you need to deste stay in to view A1 > Adity-Based Costing Lean Operations, and the costs of Gality O Insertion of parts Number of parts $31.00 per part Finishing direct ta Finishing Labor hours $51.00 per hour 13 The number of parts is now a feasible allocation base because Detting recently installed a plantwide computer system. Detting produces two wheel model Standard and Deluwe. Hulgated data for the upcoming year we as follows 23 14 Standard Deluxe Units Expected production for each model 1.000 10 Pats per what 4.0 5.0 Setups er 1,000 wheels 20.0 200 20 Fishing direct labor hours per wheel 1.0 30 21 Total direct lahor hours per wheel 2.2 1 Uhe shadedress on the ENTERANSWERS tab for inputs. Always weerences and formule where appropriate travel credit Requirements 1 Compete aged mandating cost for the upcoming 1 come the managed cost per Wheel of each ABC come the model de verhadat. Use this at teine the manufacturing overcome the traditional Saving & Swing Solution TRUCTIONS 19 2 o EN H Home Page Layout Formudas Data Review View Help PORTO VIEW Beetrom the Internet con contain vies. Unless you need to edit alerta stay in Protected View AL 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. D F 2. Compute the total budgeted manufacturing overhead cost for the upcoming year. Always use cell references and formulas where appropriate to receive full credit) 1 Total Budgeted Activity Indirect Cost 5 Materials handling Machine seus 1 insertion of parts Polishing Total budgeted indirect costs VO 11 2. Compute the manufacturing overhead cost per wheel of each modeling ABC 13 Always use collierences and formules where appropriate to receive full credit.) Allocated Activity Cost Per Wheel Standard Deluwe 15 10 Material handling > Machines 18Insertion parts Pricing 20 Total ABC cated indirect Compute the company's traditional lantwide overhead rata MUCHO A1 Compute the total budgeted manurung ovenced cost for the upcoming year. D E F H Wheel 13 Allocated Activity Cost Per 14 Activity 15 Standard Deluxe 16 Materials handling 17 Machine setups 18 Insertion of parts 19 Finishing 20 Total ABC allocated indirect cost 21 22 3. Compute the company's traditional plantwide overhead rate 23 (Always use cell references and formulas where appropriate to receive full credit.) 24 23 Plant overhead rate per direct labor hour 26 37 Use this rate to determine the manufacturing overhead cost per wheel under the traditional system, Manufacturing overhead cost per wheel 10 Standard 31 Deluxe 3 3) 2/2013 STRUCTION ENTERANSWERS SD B NM File Home Insert Page Layout Formulas Data Review View Help O PROTECTED VIEW Be careful-Files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Al Activity-Based Costing Lean Operations, and the costs of Quality D Activity-used Costing, Lean Operations, and the Costs of Quality 2 Use ABC to allocate manufacturing overhead 3 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 4 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 6 follows: 7 Activity Cost Activity Allocation Base Allocation Rate 9 Materials handling Number of parts $ 4.50 per part 10 Machine setup Number of setups S 925.00 per setup 11 Insertion of parts Number of parts $ 31,00 per part Finishing direct 12 Finishing labor hours S. 51.00 per hour 13 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 14 data for the upcoming year are as follows: INSTRUCTIONS ENTERANSWERS View Home Insert Page Layout Formulas Data Review Help PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View fo Activity-Based Costing Lean Operations, and the costs of Quality Engl G H 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: 6 Standard Deluxe Units 7 Expected production for each model 1,000 Parts per wheel 4.0 6.0 9 Setups per 1,000 wheels 20.0 20.0 0 Finishing direct labor hours per wheel 1.0 3.0 1 Total direct labor hours per wheel 2.7 3.8 2 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. 5 6 Requirements 7 1 Compute the total budgeted manufacturing overhead cost for the upcoming year. 8 2 Compute the manufacturing overhead cost per wheel of each model using ABC. 9 3 Compute the company's traditional plantwide overhead rate. Use this rate to determine the manufacturing overhe 0 Saving & Submitting Solution 2 1 Save file to desktop Create folder on desktop, and label COMPLETED EXCEL PROJECTS 1 2 Upload and submit your file to be graded INSTRUCTIONS ENTERANSWERS File Home Insert Page Layout Formulas Data Review View Help O PROTECTED VIEW Be careful files from the Internet can contain vinases. Unless you need to edit a's saler to stay in Protected Ve 4 Al 1 1. Compute the total budgeted manufacturing overhead cost for the upcomi D E 2 (Always use cell references and formulas where appropriate to recelve full credit.) 3 Total Budgeted Activity Indirect Cost 5 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 recelve full credit.) 13 Allocated Activity Cost Per 14 Activity Wheel 15 Standard Deluxe 16 Materials handling 22 17 Machine setups 18 Insertion of parts 19 Finishing 20 Total ABC allocated indirect cost 21 PM 22 3. Compute the company's traditional plantwide overhead rate, 2021 23 (Always use cell references and formulas where appropriate to receive full credit) INSTRUCTIONS ENTERANSWERS File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected Vie Al 1 1. Compute the total budgeted manufacturing overhead cost for the upcomi D 16 Materials handling 17 Machine setups 18 Insertion of parts 19 Finishing 20 Total ABC allocated indirect cost 21 22 3. Compute the company's traditional plantwide overhead rate. 23 (Always use cell references and formulas where appropriate to receive full credit.) 24 25 Plant overhead rate per direct labor hour 26 27 Use this rate to determine the manufacturing overhead cost per wheel under the traditional system. 28 29 Manufacturing overhead cost per wheel 30 Standard 31 Deluxe 32 33 34 35 D 36 di 37 3:31 PM 30 2/2 2021 39 INSTRUCTIONS ENTERANSWERS