this assessment is an excel case study conducted in week 8 in class. You are required to work in...

Question

this assessment is an excel case study conducted in week 8 in class. You are required to work in groups of 3-4 students and critically analyse management accounting system (MAS) within your case company and suggest solutions to the identified problems. The case consists of a short case study description and an excel spreadsheet outlining financial and non-financial performance of a company. Students should install Microsoft Excel program on their computers before this assessment.
In this assessment student teams work as team of consultants that are hired by a particular company to suggest improvements to the MAS design. Students have to provide a written answer to the problems outlined by their case company managers. During this assessment, students will be using Microsoft Excel to find relevant information and conduct some basic calculations. This is an open book assessment and it will cover topics 4, 5 and 6.

archive-2-qfr0wscc-qke0xk1f.zip archive-dqgkzvpg-0fnq44ly.zip

Preeta · Accepted Answer

1.
2.
3. A. The variances are related to each other since as the sales volume varies so does the costs and eventually it affects the overall profit. 
B. The sales volume has highly varied. In fact, the variance is negative in the case of berry and orange and the actual amount sold is less than the budget. But the variance is positive in the case of lemon and the actual sales is more than the estimated. Overall, the positive sales variance is more than the negative sales variance and so it can be concluded that Mountain Spring’s sales director has made a good performance. 
C. To improve in future, the company can increase the production of lemon since that seems to be in high demand and marketing is to be done for orange and berries.

this assessment is an excel case study conducted in week 8 in class. You are required to work in groups of 3-4 students and critically analyse management accounting system (MAS) within your case...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment