please solvd part B

Question 1: (10 Marks) In order to control costs, Sweets firm uses budgets. The February 2022 budget report for Sweets firm's Mixing Department is provided below. The expected production of 42,000 units per month or 504,000 units per year were the base for the report monthly budget amounts. The president of Sweets firm was displeased with the performance of the mixing department manager. Nevertheless, the mixing department manager was not able to understand the unfavorable results and thought he had done a great job. The actual units produced in February were 40.600. Sweets Company Budget Report Mixing Department For the Month Ended February 28, 2022 Difference Favorable E Unfavorable y Budget Actual SAR SAR Manufacturing Cost Variable costs Direet materials Direct labor Indirect materials Indirect labor Utilities Maintenance Total variable 33.600 37.800 16,800 12,600 10.500 8,400 119.700 32,900 35,840 16,940 12,250 10.430 8,680 117,040 SAR 700 F 1.960 F 140U 350 F 70 F 280 U 2.660 F Fixed costs Rent Supervision Depreciation Total fixed Total costs 8,400 11.900 4,200 24,500 8,400 11.900 4,200 24.500 oool 0 0 SAR 144,200 SAR141,540 SAR 2,660 F B Instructions: A. Prepare a flexible budget report for Sweets firm for February. (Show ALL your calculations) 1. Explain why the flexible budget is a better performance evaluation base than the report based on static budget data. 2. Interpret why the president of Sweets firm was displeased with the performance of the mixing department manager 3. Advice the manger on how to improve the mixing department performance