ISYS 2056: Analysing a Spreadsheet and Writing a Business Report Case Study - 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.

BUSINESS INFORMATON SYSTEMS 1 (ISYS2056) ISYS 2056

Business Report Semester 2, 2021 Page 2

• 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). Miriam has set up a spreadsheet. She has asked you to use the data provided in the spreadsheet to complete relevant calculations and to use Excel ‘tools’ to analyse the data provided. She then requires you to write a business report which analyses and discusses both profit growth and the various options available to help increase future profitability. A spreadsheet has been provided containing the data for “Keep Movin’ Gym” enrolments for semester 2 in 2019, semesters 1 and 2 in 2020 and semester 1 in 2021, and various related data on costs etc.

The above ISYS 2056:  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.