I am having trouble with this. I did not do well on last quiz and was hoping someone could solve it so I know what I did wrong.

2019SummerFinalProject due 810 - Excel katie_sandage@yahoo.com AutoSave On File Home B Insert - Page Layout Formulas Data Review View Help Search A1 x v f Part 2 1 Part 2 2 Several years ago the Cookie Company developed a comprehensive budgeting system for profit planning and 3 control purposes. The line supervisors have been very happy with the system and with the reports being prepared 4 on their performance, but both middle and upper management have expressed considerable dissatisfaction with the 5 information being generated by the system. The following is the overhead performance report for the Baking department. Cookie Company Overhead performance report-Baking department For the quarter ended June 30 Actual Budget 33,000 35,000 Variance U or F 2,000 U 12 Units 14 Variable Overhead Indirect materials Rework time Utilities Machine setup 19 Total variable overhead cost 33000 8200 63000 16200 120400 34000 8500 66,000 18000 126500 1000 F 300 F 3000 F 1800 F 6100 F 21 Fixed overhead Costs Maintenance Depreciation Inspection 25 Total fixed overhead cost 26 Total overhead cost 79000 10000 60100 149100 269500 80000 9800 60000 149800 276300 1000 F 200 U 100 U 700 F 6800 F OverviewFinalProject Part1 Budgetsolution Part 2 Part3 Part 4 1 O Type here to search LUIJUell TOFTUELLE ULU LALEI Fate alla File Home Insert Page Layout Formulas Data Review View Help Search | A1 x V & Part 2 A B C D E F G H I 1 I K 28 After receiving a copy of this overhead performance report, the supervisor of the baking department stated, "These reports 29 are super. It makes me feel really good to see how well things are going in my department I can't understand why those people 30 upstairs complain so much." 31 The company's vice president has hired you as a consultant to develop a new overhead performance report for the quarter for the 32 Baking department. After you have developed this new performance report, explain to the supervisor of the baking department the reasons 33 for your changes and discuss the issue of controlling costs. 35 Required: 36 1. Prepare a revised budget for June using the flexible performance approach. 37 You need to use cell reference to calculate the variance. You must designate a variance for each cost category and for the total cost: U or F. 38 The variable and fixed cost labeling has been set correctly, so do not change this around. 39 Please use the template I have set out below to complete this performance report. 40 2. Explain to the supervisor of the baking department the reasons for your changes and discuss the issue of controlling costs. 41 3. Identify variances in the report you prepared that should be investigated? Explain in detail why these variances should be investigated. 43 Solution: 44 1. Revised flexible performance report. Cookie Company Overhead flexible performance report-Baking department For the quarter ended June 30 Actual Budget Variance U or F 50 Units Variable Overhead Indirect materials OverviewFinalProject Part1 Budgetsolution Part 2 Parts Part 4 O Type here to search Auto Save 2019SummerFinal Project due 910 - Excel katie_sandage@yahoo.com File Home Insert Page Layout Formulas Data Review View Help Search A x vf Part 2 Actual Budget Variance U or F 50 Units 52 Variable Overhead Indirect materials Rework time Utilities Machine setup 57 Total variable overhead cost 59 Fixed overhead Costs Maintenance Depreciation Inspection 63 Total fixed overhead cost 64 Total overhead cost 66 2. Explain to the supervisor of the baking department the reasons for your changes and discuss the issue of controlling costs. 72 3. Identify variances in the report you prepared that should be investigated? Explain in detail why these variances should be investigated. OverviewFinalProject Part1 BudgetSolution Part 2 Part3 Part 4 O Type here to search