Please include formulas used, thank you.

Insert Draw File Home Page Layout Formulas Review Data View Acrobat Help Formula Bar Groupon Gridlines Headings Normal Page Break Page Custom Preview Layout Views Workbook View Zoom 100% Zoom to Selection Sheet View Show Zoom 1 3 8 D E Activity-Based Costing, 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 had used a plantwide overhead rate based on 4 direct labor hours that was developed years ago. 5 6 For the upcoming year, Dettling's budgeted ABC manufacturing overhead allocation rates are as follows: 7 Activity Cost B Activity Allocation Base Allocation Rate 9 Materials handling Number of parts $ 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 labor 12 Finishing hours $ 51.00 per hour 15 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 14 upcoming year are as follows: 15 16 Standard Deluxe Units 27 Fested production for each model INSTRUCTIONS ENTERANSWERS 1000 Type here to search EK Home Insert Draw Page Layout Formu Review View Help Acrobat Formula Com HomePageBreak Page Custom Prev Layout Views Var View Ordines Headings Zoom 100% Zoom to Selection New Arrange Freeze Hide Window All PanerinWireWir Shet Show Zoom M A 8 F G H 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 data for the 14 upcoming year are as follows: 15 Standard Deluxe Units 17 Expected production for each model 1,000 18 Parts per wheel 4.0 60 19 Setups per 1,000 wheels 20.0 2000 20 Finishing direct labor hours per wheel 1.0 3.0 21 Total direct labor hours per wheel 27 3.8 22 2 Use the blue shaded areas on the ENTERANSWERS tab for inputs. 24 Always use cell references and formulas where appropriate to receive full credit, 25 26 Requirements 27 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. 29 3 Compute the company's traditional plantwide overhead rate. Use this rate to determine the manufacturing overhead cost per Wheel under the traditional system 30 31 Saving & Submitting Solution 1 Save file to desktop Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded 35 a. Navigate back to the activity window screen where you downloaded the initial spreadsheet 36 b. Click Choose button under step 3: locate the file you just saved and click Open Click Vload button under step 3 INSTRUCTIONS INTERANSWERS Type here to wach O Saunch Brid_BT6e_4_27a_start - Excel AutoSave 02 Data Formulas Review View Help Acrobu File Home Insect Draw Page Layout Formula Bar Zoom 10 Gridlines Headings Options Normal Page Break Page Custom Preview Layout Views Workbook Views Show 20 Sheet View G9 D A B C 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.) 3 Total Budgeted Activity Indirect Cost 5 Materials handling 6 Machine setups 7 Insertion of parts B Finishing 9 Total budgeted indirect costs 4 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.) 12 14 Activity Allocated Activity Cost Per Wheel 15 Standard Deluxe 16 Materials handling 17 Machine setups 15 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 ce references and formulas where appropriate to receive full credit.) 24 SDCTIONS INTERANSWERS Type here to search O C - Esc AutoSave Brid_876e_e4_27a_start - Excel Draw Data Page Layout File insert Formulas Review View Home Help Acrobat Formula Bar Zoom TOON Site Options Gridlines Headings Normal Page Break Page Custom Preview Layout Views Workbook Views Sheet View Show Zoom G9 X B D E 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 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 25 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 INSTRUCTIONS ENTERANSWERS Type here to search O C BD