AutoSave . Off) H BMercer Project 5 Search Ben Mercer BM X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Arial 12 ~ A" A " de Wrap Text General AutoSum 4 Paste [ Copy $ ~ % 9 70 20 Conditional Format as Cell Insert Delete Format Fill AY O = = = E Merge & Center Clear Sort & Find & Ideas Format Painter Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas 122 X Y fix A B C D E F G H I K L M 62 Inspection 63 Total fixed overhead cost 64 Total overhead cost 65 66 2. Explain to the supervisor of the baking department the reasons for your changes and discuss the issue of controlling costs. 67 68 69 70 71 72 3. Identify variances in the report you prepared that should be investigated? Explain in detail why these variances should be investigated. 73 74 75 76 77 78 79 80 ... Part 1 Part2 | Part 3 | + Ready + 130% Type here to search My e X w 9 11:33 PM 8/5/2020AutoSave . Off) H BMercer Project 5 Search Ben Mercer BM X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut [G Copy Arial 12 ~ A" A " de Wrap Text General AutoSum Paste EES E Merge & Center Conditional Format as Cell Fill AY O 4 BIUT DAY $ ~ % 9 70 20 Insert Delete Format Clear Sort & Find & Ideas Format Painter Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas 122 X Y B E F G H K M N O P Q 1 Part 1 2 Several years ago the Cookie Company developed a comprehensive budgeting system for profit planning and control purposes. The line supervisors have been very happy with the system and with the reports being prepared on their performance, but both middle and upper management have expressed considerable dissatisfaction with the information being generated by the system. The following is the overhead performance report for the Baking department. Cookie Company Overhead performance report-Baking department 9 For the quarter ended June 30 10 11 Actual Budget Variance U or F 12 Units 34,000 35,000 1,000 U 13 14 Variable Overhead 15 Indirect materials 35000 36000 1000 F 16 Rework time 8400 8500 100 F 17 Utilities 68000 69,000 1000 F 18 Machine setup 17500 18000 500 F 19 Total variable overhead cost 12890 131500 2600 F 20 21 Fixed overhead Costs Maintenance 79500 80000 500 F 23 Depreciation 10000 9800 200 U 24 Inspection 60100 60000 100 U 25 Total fixed overhead cost 149600 149800 200 F 26 Total overhead cost 281300 2800 F ... Part 1 Part2 | Part 3 | 278500 + Ready + 100% Type here to search e P x W 9 11:31 PM 8/5/2020AutoSave . Off) H BMercer Project 5 Search Ben Mercer BM X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Cut Arial 12 ~ A" A " = General Paste [G Copy de Wrap Text AutoSum Conditional Format as Cell Insert Delete Format Fill AY O 4 EES E Merge & Center $ ~ % 9 70 20 Ideas Formatting * Table Styles Clear Sort & Find & Format Painter Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas 122 X Y fx A B C D E F G H K L M 25 Total fixed overhead cost 149600 149800 200 F 26 Total overhead cost 278500 281300 2800 F 27 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. 34 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. 42 43 Solution: ... Part 1 Part2 Part 3+ Ready . + 130% Type here to search e P W 11:32 PM 8/5/2020AutoSave . Off) BMercer Project 5 Ben Mercer X H Search BM File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut AutoSum Arial 12 ~ A" A " ay Wrap Text General 4 $ ~ % 9 70 20 Conditional Format as Cell Insert Delete Format Fill AY O Paste [G Copy E= = E E Merge & Center Clear Sort & Find & Ideas Format Painter BIU FAV Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas 122 X Y fix B C D E F G H K M N O P Q 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. 42 43 Solution: 44 1. Revised flexible performance report. 45 Cookie Company 46 Overhead flexible performance report-Baking department 47 For the quarter ended June 30 48 49 Actual Budget Variance U or F 50 Units 51 52 Variable Overhead 53 Indirect materials 54 Rework time 55 Utilities 56 Machine setup 57 Total variable overhead cost 58 59 Fixed overhead Costs 60 Maintenance 61 Depreciation 62 Inspection 63 Total fixed overhead cost 64 Total overhead cost 65 Part 1 Part2 | Part 3 | + + 100% Ready ep w 9 11:32 PM Type here to search X 8/5/2020 E