ISYS2059 Business Information Systems Assignment – UK

Part 1: Analysing a spread sheet 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 time table 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 spread sheet).
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 profit ability. 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:

• Under take 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).

Miriam has set up a spread sheet. She has asked you to use the data provided in the spread sheet 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 spread sheet 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.

Report Content :-

The analysis findings and recommendations which you prepare for Miriam should be outlined in a professional business report.

This report should include:
1. A title page with a report title student name/number course name Business Information Systems course number ISYS2056 your workshop time and your work shop tutors names.
2. A Table of Contents (TOC)
3. A brief introduction which outlines clearly the purpose of the report.
4. The analysis you have undertaken and a discussion regarding the results of this analysis.
5. A discussion based on the results of your analysis that outlines possible options for increasing future profitability.
6. A discussion of 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.
7. A short concluding summary of the major findings of the report.
8. Clear recommendationsthat Miriam can adopt. These recommendations must be drawn from the analysis you have carried out and must have been discussed in the body of your report.