Analysing a Spreadsheet and Writing a Business Report Writing - Management Assignment Help

Assignment Task:

Task:

Part 1: Analysing a spreadsheet and writing a business report. Case Study “Keep movin’ Gym” is a fitness studio specialising in group exercise classes in Adelaide, South Australia. The studio was taken over by new management two years ago and the new manager (Miriam Brown) wants to make some adjustments in order to operate the business more efficiently. Miriam handles bookings, accounts and organises the teaching timetable and roster for the casual fitness instructors she employs. Note that the instructors’ pay rates have been determined by experience, age and qualifications and so they differ for each instructor. The fitness studio offers a range of group exercise classes for members and also a senior citizen class which is discounted. The gym also offers individual sessions for those wanting a personal training session.

Classes are booked per semester. Since purchasing the fitness studio, Miriam has been operating essentially the same timetable from semester 2 2019 through to semester 1 2021 and has continued to employ the same staff. In an effort to encourage new and current members to take extra classes she introduced a discount scheme during semester 2 2020 and semester 1 2021 (see the “Multiple class discount” columns in the spreadsheet). A discount is offered if two or more members of the one family enrol in a class or if a member enrols in two or more classes. Miriam believes that it is time to review the effectiveness of her dance studio with regard to profitability. Is the business growing? Are her profits growing? What are the likely future trends? She wants to revise the timetable and possibly take other steps to further increase profits and has asked you to:

• Undertake descriptive analysis of the data she has maintained over the past four semesters.

• Provide an overview of profitability trends undertaking predictive analysis.

• Discuss the various options regarding possible future changes to the timetable based on your analysis. 

• Discuss at least one business issue you have identified as a result of your data analysis that you believe may need to be further analysed. E.g. You require further information from Miriam before you can take action.

Clearly explain your reasoning.

• Make recommendations with regard to future changes which might assist in further improving profitability. Briefly justify these recommendations (i.e. prescribe what should be done and why this would be helpful, drawing on your predictive and prescriptive analysis).

The above Management  Assignment has been solved by our  Management Assignment  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire considered worthy of the highest distinction.