Please Help!!

Grader - Instructions Accounting 2019 Project BT6e E4-27A v2 Font Project Description: BT60 E4-27A Steps to Perform: Step Points Possible 1 6 2 Instructions 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. (Always use coll references and formulas where appropriate to receive full credit.) 2. Compute the manufacturing overhead cost per wheel of each model uning ABC. (Always use coll references and formulas where appropriate to receive full credit.) 3. Compute the companys traditional plantwide overhead rato. Use this rate to determine the manufacturing overhead coat per whoel under the traditional system. (Always use coll references and formulas where appropriate to receive full credit.) 10 3 3 Total Points 18 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 St For the upcoming year, Dettling's budgeted ABC manufacturing overhead allocation rates are as follows: 1 Activity Cost Activity Allocation Base Allocation Rate Materials handling Number of parts $ 4.50 per part D Machine setup Number of setups $325.00 per setup Insertion of parts Number of parts $ 31.00 per part Finishing direct labor 2 Finishing hours $ 51.00 per hour 3 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 4 follows: -5 .6 Standard Deluxe Units 7 Expected production for each model 1,000 18 Parts per wheel 4,0 6.0 19 Setups per 1,000 wheels 20.0 20.0 20 Finishing direct labor hours per wheel 1.0 3.0 21 Total direct labor hours per wheel 2.7 3.8 22 23 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. 28 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 sys 30 31 Saving & Submitting Solution 32 1 Save file to desktop 332 resta folder ALINI Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell 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 each model using ABC. 3 Compute the company's traditional plantwide overhead rate. Use this rate to determine the manufacturing overhead cost per w Saving & Submitting Solution 1 Save file to desktop a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open Click Upload button under step 3 d. Click Submit button under step 4 a. C. Viewing Results 1 Click on Results tab in My Accountinglab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Summary 4 Within Score Summary window, click on Download (upper right) to download the spreadsheet with feedback 1. Compute the total budgeted manufacturing overhead cost the upcomin Always use cell references and formulas where appropriate to receive full credit.) Total Budgeted Indirect Cost Activity 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 Use this rate to determine the manufacturing overhead cost per wheel under the traditional system. Manufacturing overhead cost per Wheel Standard Deluxe