4. You have joined Unilever Bangladesh as an inter in the finance division. Your first project as an n intern will be to help the junior finance manager of Unilever Bangladesh, Mr. Reza Monem, to help in his flexible budget performance appraisal of the consumer products division for year ended December 31, 2021 The cost for the current year's planning budget appears below. Unilever Bangladesh planned to sell 5 different types of products and Mr. Monem estimated that total 60 machine hours will be required to produce those products Unilever Bangladesh Costs from the Planning Budget For the Year Ended December 31 Budgeted number of productions 5 Budgeted machine hours 60 Supervisory salaries Tk. 144.000 Gasoline expenses 27.000 Maintenance expenses 10.800 Supplies 43.000 Factory space rent 45.000 Utilities expenses 10.500 Machine Setup expenses 13,000 Administrative expenses 43.200 Total Tk. 336,500 You have observed that some of the costs vary with the mumber of productions, some with the machine hours, and some are fixed and depend on neither the number of productions or the machine hours. The costs of supplies, and machine star wary only with the number of productions On the other hand, nupervisory salaries in and maintenance expenses vary with the machine hours. Similarly, factory space rest and writies expres will vary with the machine hours Administrative perses are more difficult to pin down, but the best estimate is that approximately 75% of the bodgated costs are fired, 15% depend on the number of productions, and the remaining 10% depend on the machine bonus You are presented with the following actual results for the year from Mt. Monem Unilever Bangladesh Actual Costs For the Year Ended December 31 Actual number of productions Actual machine hours Supervisory salaries TL 14.000 Gasoline expenses 28,600 Maintenance expenses 12200 Supplies 39,900 Factory space rent 49.000 Utilities expose 10,950 Machine Setup expenses 12.000 Administrative expenses Total TL 342 400 41.650 Answer the following questions (8+2-101 a Prepare a flexible budget performance report for the year that shows both activity variances and spending variances. You provide the supporting calculato derive the cost formulas b) If you were the CTO of the Unilever langladesh, would you be pleased with how well couts were controlled during the year? Why or why not? 4. You have joined Unilever Bangladesh as an inter in the finance division. Your first project as an n intern will be to help the junior finance manager of Unilever Bangladesh, Mr. Reza Monem, to help in his flexible budget performance appraisal of the consumer products division for year ended December 31, 2021 The cost for the current year's planning budget appears below. Unilever Bangladesh planned to sell 5 different types of products and Mr. Monem estimated that total 60 machine hours will be required to produce those products Unilever Bangladesh Costs from the Planning Budget For the Year Ended December 31 Budgeted number of productions 5 Budgeted machine hours 60 Supervisory salaries Tk. 144.000 Gasoline expenses 27.000 Maintenance expenses 10.800 Supplies 43.000 Factory space rent 45.000 Utilities expenses 10.500 Machine Setup expenses 13,000 Administrative expenses 43.200 Total Tk. 336,500 You have observed that some of the costs vary with the mumber of productions, some with the machine hours, and some are fixed and depend on neither the number of productions or the machine hours. The costs of supplies, and machine star wary only with the number of productions On the other hand, nupervisory salaries in and maintenance expenses vary with the machine hours. Similarly, factory space rest and writies expres will vary with the machine hours Administrative perses are more difficult to pin down, but the best estimate is that approximately 75% of the bodgated costs are fired, 15% depend on the number of productions, and the remaining 10% depend on the machine bonus You are presented with the following actual results for the year from Mt. Monem Unilever Bangladesh Actual Costs For the Year Ended December 31 Actual number of productions Actual machine hours Supervisory salaries TL 14.000 Gasoline expenses 28,600 Maintenance expenses 12200 Supplies 39,900 Factory space rent 49.000 Utilities expose 10,950 Machine Setup expenses 12.000 Administrative expenses Total TL 342 400 41.650 Answer the following questions (8+2-101 a Prepare a flexible budget performance report for the year that shows both activity variances and spending variances. You provide the supporting calculato derive the cost formulas b) If you were the CTO of the Unilever langladesh, would you be pleased with how well couts were controlled during the year? Why or why not