Please provide responses to fit into each blue box in the excel document including:

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 companys traditional plant wide overhead rate.

Project Description: ca_braunma3e.e7.23a Steps to Perform: Several years after reengineering its production process, Enke Corp. hired a new controller, Natalie Rabin. She developed an ABC system very similar to the ane used by Enke's chief rival, Northstar. Part of the reason Babin developed the ABC system was hecause Enke's prafits had been declining, even though the company had shifted its product mix towatd the produrt that had appeared most profitable under the old system. Hefore adopting the new ABC system, the compary had used a plantwide overhead rate based on direct labour hours that was developed years ago. For the upcoming year, Enke's budgeted ABC. manufacturing overhead allocation rates are as The number of parts is now a feasible allocation base because Enke recently purchased bar-cuding technology. Enke produces two wheel models: Standard and Deluxe. Budgeted data for the 4 jucnmirna vear are as folluws: The number of parts is now a feasible allocation basc because Enke recently purchased bar-coding technology. Enke produces two wheel models: Standard and Deluxe. Budgeted data for the upcoming year are as follows: Use the blue shaded areas on the ENTERANSWLRS 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 yeat. 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 wheel under the traditional system. Saving \& Submitting Solution 1 Save lile to desktop. a. Create folder on desktop, and label COMPLETCD EXCEL PROJFCTS b. Save your solution in the folder you just created; add -solution date ta end of file name 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you duwnloaded the initial spreadsheet INSTRUCTIONS 1. Compute the total budgeted manufacturing overhead cost for the upcoming year. (Always use cell references and formulas where appropriate ta receive full credit.) 2. Compute the manufacturing overhead cost per wheel of each model using ABC. (Always use cell references and formulas where appropriate tu receive full credit.) 3. Compute the company's traditional plantwide overhead rate. (lways use cell references and formulas where appropriate to receive full crediL.) 2. Compute the manufacturing overhead cost per wheel of each model using ABC. (Always use cell references ind formulas where appropriate to receive full credit.) 3. Compute the company's traditional plantwide overhead rate. (Ahways use cell reterences and formula's where appropriate to receive full credit.) Plant overhead rate per direct labour hour Use this rime to determine the manufacturing overhead cost per wheel under the traditional system