Question
Mountain Spring manufactures and sells varieties of sports drink (berry, lemon and orange) in bulk to upmarket. Budgeted and actual results for 2020 are as
Mountain Spring manufactures and sells varieties of sports drink (berry, lemon and orange) in bulk to upmarket. Budgeted and actual results for 2020 are as follows:
When preparing its budget for 2020, the company assumed that there would be a global market for 22,000,000 boxes of sports drinks and that Mountain Springs product would have a 11.409% share of this market.
However, a recent debate on sports drinks argues that while traditional sports drinks are designed to provide athletes with the right balance of carbohydrates, fluids and electrolytes during exercise, they do more harm than good, if youre just quenching a thirst because sports drinks contain high level of sugar. As a result, during 2020 both Mountain Spring and its competitors were adversely affected by diminishing consumer in sport drink products. The actual total market size was only 20,000,000 boxes.
The Sales director of Mountain Spring recently explained how they attempted to respond to the difficulties which it faced in 2020: First, we reduced our selling price for all products; this was a modest price reduction in comparison with those of our smaller competitors. Second, as a pilot project, we introduce natural ingredients such as natural sweetener to add value to our lemon sports drink. In doing so, we try to increase consumer confidence in the health of our product. Finally, to promote our new design lemon sports drink, we run several marketing campaigns as demonstrating the benefits of sports drinks, in particular, the health of our lemon sports drink (with all-natural ingredients) to the sport players.
Required:
1. Complete the flexible budget (of lemon flavour and all products combined) and associated variances using the template provided. (Please copy and paste the table with your calculations from Microsoft Excel to your Word File);
2. Complete the reconciliation of variances using the template provided (Calculate the profit variances and reconcile the actual operating profit to the planned operating profit using the template provided. (Please copy and paste the table with your calculations from Microsoft Excel to your Word File);
3. The companys director board is not happy with the net profit generate this year, as the actual net profit is less than the budgeted net profit. You are the consultant of the company and are required to provide a report of variance analysis based on the results you have calculated in Q1 and Q2. In your response, you should:
- Discuss how the variances may relate to each other?
- Critically evaluate the performance of Mountain Springs sales in 2019, supporting your answer by reference to the sale volume and sales price variances which you have calculated (For example, what are the favourable and unfavourable variances? What are the drivers of the variances?).
- What recommendations do you have for future improvement?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started