Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4. You have joined Unilever Bangladesh as an intern in the finance division. Your first project as an intern will be to help the junior
4. You have joined Unilever Bangladesh as an intern in the finance division. Your first project as an 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 Budgeted machine hours Supervisory salaries Gasoline expenses Maintenance expenses 5 60 Tk. 144,000 27,000 10,800 43,000 45,000 Utilities expenses 10,500 Machine Setup expenses 13.000 Administrative expenses 43,200 Total Tk. 336,500 Supplies Factory space rent You have observed that some of the costs vary with the number of productions, some with the machine hours, and some are fixed and depend on neither the number of productions nor the machine hours. The costs of supplies, and machine setup vary only with the number of productions. On the other hand, supervisory salaries, gasoline, and maintenance expenses vary with the machine hours. Similarly, factory space rent and utilities expenses will vary with the machine hours. Administrative expenses are more difficult to pin down, but the best estimate is that approximately 75% of the budgeted costs are fixed, 15% depend on the number of productions, and the remaining 10% depend on the machine hours. You are presented with the following actual results for the year from Mr. Monem: Unilever Bangladesh Actual Costs For the Year Ended December 31 Actual number of productions Actual machine hours 4 64 Tk. 148,000 Supervisory salaries Gasoline expenses Maintenance expenses Supplies Factory space rent Utilities expenses Machine Setup expenses Administrative expenses Total Answer the following questions: [8+2=10] 28,600 12,300 39,300 3/3 49,600 10,950 12.000 41,650 Tk. 342,400 a) Prepare a flexible budget performance report for the year that shows both activity variances and spending variances. [You must provide the supporting calculations to derive the cost formulas] b) If you were the CFO of the Unilever Bangladesh, would you be pleased with how well costs were controlled during the year? Why or why not
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started