PLEASE, show the cell reference! Very important.
E A F G Activity-Based Costing, Lean Operations, and the Costs of Quality 1 Use ABC to allocate manufacturing overhead 2 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 had used a plantwide overhead rate based on direct labor hours that was developed years ago. 4 For the upcoming year, Dettling's budgeted ABC manufacturing overhead allocation rates are as follows: 6 7 Activity Cost Allocation Base 8 Activity Allocation Rate Number of parts Materials handling $ 4.50 per part Number of setups 325.00 per setup Machine setup 10 Number of parts Finishing direct labor Insertion of parts 31.00 per part 11 Finishing hours 51.00 per hour 12 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 upcoming year are as 14 follows: 15 Deluxe Standard Units 16 1,000 Expected production for each model 17 Parts per wheel 4.0 6.0 18 Setups per 1,000 wheels 20.0 20.0 19 Finishing direct labor hours per wheel 1.0 3.0 20 Total direct labor hours per w heel 2.7 3.8 21 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. 99 26 Requirements 1 Compute the total budgeted manufacturing overhead cost for the upcoming year. 2 Compute the manufacturing overhead cost per wheel 3 Compute the company's traditional plantwide overhead rate. Use this rate to determine the manufacturing overhead cost per wheel under the traditional system. 27 f each model using ABC. 28 29 30 31 Saving & Submitting Solution 1 Save file to des ktop. 32 33 Create folder on desktop, and label COMPLETED EXCEL PROJECTS . 2 Upload and submit your file to be graded. 34 Navigate back to the activity window screen where you downloaded the initial spreadsheet 35 . b Click Choose button under step 3; locate the file you just saved and click Open 36 37 Click Upload button under step 3 Click Submit button under step 4 C d 38 39 40 Viewing Results 1 Click on Results tab in MyAccounting Lab 41 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback 42 43 44 45 D A 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. (Always use cell references and formulas where appropriate to receive full credit.) 1 2 3 Total Budgeted Activity Indirect Cost Materials handling 5 Machine setups 6 Insertion of parts 7 8 Finishing 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 receive full credit.) 13 Activity Allocated Activity Cost Per Wheel 14 Standard Deluxe 15 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 Manufacturing overhead cost per wheel 29 30 Standard 31 Deluxe 32
