AutoSave OFF BES 5 Chapter10ExcelProjectResponsibilityAccountingandResponsibilityCentersBriefExercise 106L03_Question1 Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Liberation Sans 12 AP Custom = = = Insert v 99 5 Apu O PX Delete v DOM Paste E v $ % ) .00 .00 0 Conditional Format Cell Formatting as Table Styles Sort & Filter Format Find & Select Analyze Data Sensitivity F H J L M N O P Q R S T U BI U v av A A R23 xv fx A B C D E 1 Function: SUM; Formula: Subtract; Cell Referencing 2 3 Using Excel To Prepare a Responsibility Report for a Cost 4 Center 5 PROBLEM 6 In the Assembly Department of Hannon Company, budgeted and actual 7 manufacturing overhead costs for the month of April 2020 were as follows. 8 9 10 Budget Actual 11 Indirect materials $ 16,000 $ 14,300 12 Indirect labor 20,000 20,600 13 Utilities 10,000 10,850 14 Supervision 5,000 5,000 15 16 All costs are controllable by the department manager. 17 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. Use the SUM function with cell references to calculate totals. Prepare a responsibility report for April for the cost center. Hannon Company Assembly Department Manufacturing Overhead Cost Responsibility Report For the Month Ended April 30, 2020 Difference Favorable F Controllable Cost Budget Actual Unfavorable U Indirect materials $ 16,000 $ 14,300 $ 1,700 F 18 19 20 21 Indirect labor 20,000 20,600 -600 U Utilities 10,000 10,850 -850 U 22 23 24 25 26 Supervision 5,000 5,000 0 U $ 51,000 $ 50,750 $ 250 U 27 28 29 30 Enter Answer + 117%