AutoSave O ChlowrittenHW (2) O Search (Alt. File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share 10 X Insert Arial . 10 A A 2 Wrap Text Il General 27 Fon) e Paste BIU A ===== Merye 31 Center $ % -9 Conditional Formatas Cell Formatting Table Sty es Styles De ata Format Sort & Find & Filter Select Analyze Sensitivity Data Unda Clipbaan Font Alignment Number R Cels Editing Ansiyos Sensitivity v 116 1x A A C C D G G H M N 0 P Q R S U VA V 1 P106 [LO 3) AN Durham Company uses a responsbilly reporting system. It has divisions in Denver, Seattle, and San Diega. Each division has three production departments Cutting Shaping and Finishing The responsibility for nach department rests with a manager who reports to the divis 2 3 In January 2022, controlable actual and bucgel manufacturing overleed cusl dels for the departments and divisions were as shown here. 4 Manufacturing Overliesc Actua Budget 5 Individual costs-Cutting Departmet 6 Indirect labor $73,000 570,000 7 Indirect materials 47300 46,000 8 Maintenance 20.500 18.DID 9 Utilities 20 100 17,000 10 Supervision 22 000 20,000 11 $193,500 $175.000 12 Total costs 13 Shaping Department-Seattle $158,000 3148.000 14 Finishing Department-Seattle 210.000 205,000 15 Derwer division 678000 673,000 16 16 San Diego division 722000 715,000 17 19 Additional overhead costs were incurred as follows: Seattle division procuction manager-actual costs $52,500, budget S51 000; vice president of production actual costs $65.000 budget S84000: president-actual costs $78 400 budget $74,200 These expenses are not allocated 19 20 The vice presidents who report to the president, other than the vice president of production to the following expenses 21 Vice President Actual Budget 22 Marketing $133,600 $130.000 23 Finance 109.000 104,000 21 25 Instructions 26 27 Using the format in Ilustration 10.19. complete the responsibly reports gren below f10 points cach) 29 29 (a) Manufacturing overhead-Cutting Department manager-Seattle division 30 31 (b) Manufacturing overtiead-Seattle division manager. 32 33 (c) Manufacturing over esc-vicepresident of production 34 35 (0) Manufacturing ovetead and expenses-president , , 37 (a) No. 1 38 To Cutting Department Manager-Seattle Division Month: January 39 Controllable Costs: Budget Actual Fav/Unfav 40 Indirect labor 41 Indirect materials 42 Maintenance P10 P10.6 1020 1021 Ready Accessibility Investigate 95%