Instructions You will be using Microsoft Excel to answer this question. Follow the steps below to complete the question. Click here to view a brief video demonstrating downloading the Excel file, completing your work in either Excel or Google Sheets, and uploading your response file successfully, with troubleshooting. Alternatively, see written instructions here.

AutoSave OFF OFF HEU Chapter7 WileyPLUSHomework_Question Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X X LG Liberation Sans v 12 ~ A Wrap Text Text Insert v Delete Format Paste BIU y A Merge & Center 2 Y Conditional Format Cell Formatting as Table Styles Sensitivity O Sort Filter Find & Select Analyze Data Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. fx Formula: Divide; Cell Referencing A1 G H. 4 Required: Provid formulas with cell a. Calculate Traditional A B C D E F 3 E7.7 - Using Excel to Calculate Overhead Rates 4 PROBLEM 5 Eric Parker has been studying his department's profitability reports for the past six months. He 6 has just completed a managerial accounting course and is beginning to question the company's 7 approach to allocating overhead to products based on machine hours. The current department 8 overhead budget is based on machine hours. In an initial analysis of overhead costs, Eric has 9 identified the following overhead budget amounts and activity cost pools. 10 11 12 Estimated machine hours 45,340 13 14 Cost Pool Expected Expected Cost Expected Activities 15 Product assembly $ 680,000 40,000 machine hours 16 Machine setup and calibration 320,000 5,000 setups 17 Product inspection 67,500 1,500 batches 18 Raw materials storage 66,000 300,000 pounds 19 $ 1,133,500 b. Calculate pools. Product as Machines Product in Raw mate 20 Enter Answer + EE - + 212% AutoSave OFF OFF HEU Chapter7 WileyPLUSHomework_Question Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Liberation Sans v 12 ~ A Wrap Text Text Insert v Delete WE Paste BIU 3 B y A e Merge & Center v Conditional Format Cell Formatting as Table Styles Y Sensitivity # Format O Sort Filter Find & Select Analyze Data Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. fx Formula: Divide; Cell Referencing A1 F G H I J K L M N O P z 3 4 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area as indicated. 5 6's 7 8 9 a. Calculate the company's traditional overhead rate based on machine hours. 10 Traditional overhead rate per 11 12 13 14 b. Calculate the company's overhead rates using the proposed activity-based costing pools. 15 16 Product assembly Machine setup and calibration Product inspection Raw materials storage per per per per 17 18 19 Enter Answer + 2 + 212% AutoSave OFF OF HESU Chapter7 WileyPLUSHomework_Question Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Liberation Sans v 12 ~ A Wrap Text Text Insert v Delete Format WES Paste BIU 3 y A Merge & Center 2 Y Conditional Format Cell Formatting as Table Styles Sensitivity Sort Filter Find & Select Analyze Data Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A1 f. Formula: Divide; Cell Referencing 1 L P a 1 U y W Y 2 2 AA 1 l'annula: Divide; Call Referencing a E7.7 - Using Excel to Calculate Overhead Rates PROBLEM 5 Ere Parcer has been studying his department's profitabity reports for the past six 6 months. He has just completed A maragerial counting course and is beginning to questiur the company's approach to a locating overhead to products based on 8 machro hours. The current department overhead bucget is based on machine hours. 9 In an Intial analyses cover cad costs, Eric has bientific the following overhead budget Amounts and active cost poola Student Work Area Required: Provide input into vols shaded in yeluw in this templates. Use mathematical forms the references to the Problem ama as indicated a Calculate the company's traditional overhead rate based on machine Tradioural Overhead rule per Estmated machine hours 45.340 b. Calculate the company's overhoed rates using the proposed activity based ( : 1846 11 12 13 14 15 10 17 18 Cusi Puol Exvuciuc Product assembly Machine setup and calbration Product inspection Raw materials storage Expected Oost S 680,000 320.000 87.500 GG,000 S 1.133,500 Expuciuc Activities 40,000 machine hours 5,000 seuns 1.500 batches 200,000 pounds Product ascembly Machine setup and calbration Product inspection Haw materie s storage por per per 19 20 21 22 23 25 26 27 39 20 21 14 25 37 14 29 40 43 44 45 46 47 43 Enter Answer + - + 20%