AutoSave one CH7 HomeworkPDR_Question (2) - Excel Jeniffer Tarn T File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum ~AA" === Wrap Text Text SLTX o 4 Literation Sana 12 BIU Till X Cut [Copy 3 Format Painter Cupboard Fyste === Insert Delete Format Ideas Merge & Center Sens tivity LA Conditional Format as Cell Formatting Table Styles Styles Clear Sort & Fins & Filter Select Editing Font F Algimant Numhar Ideas Sensitivity A1 G HI J K L M N 0 P 0 R 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. a. Traditional overhead rate per b. Product assembly Machine setup and calibration Product inspection Raw materials storage per per per per Formula: Divide; Cell Referencing B C D E F. 1 Forinula: Divide; Cell Referencing 2 2 E7.7 - Using Excel to Calculate Overhead Rates PROBLEM 5 Eric Parker has been studying his department's profitability reports for the past six 6 months. He has just completed a managerial accounting course and is beginning to 7 question the company's approach to allocating overhead to products based on machine a hours. The current department overhead budget is based on machine hours. In an initial 9 analysis of overhead costs, Eric has identified the following overhead budget amounts and 10 activity cost pools. 11 12 Estimated machine hours 45,340 13 14 Cost Pool Expected Expected Cost Expected Activities 15 Product assembly S 680,000 40.000 machine hours 16 Machine setup and calibration 320,000 5.000 setups 17 Product inspection 67,500 1,500 batches Raw materials storage 66,000 300.000 pounds 19 $ 1,133,500 20 21 a. Calculate the company's traditional overhead rate based on machine hours. 22 b. Calculate the company's overhead rates using the proposed activity-based costing 23 pools. 24 25 26 27 28 29 30 31 32 33 34 18 Enter Answer 101N + 10:04 PM 10/25/2020 Type here to search OHA ENG