BUS0117 Information Systems for Business (October 2024)
Continual Assessment 2
Group Assignment (40%)
Total marks: 100 marks
Section A - Business Analytics using MS Excel (75 marks) Case Study:
“Star Fitness” is a fitness studio located at Holland Village specialising in group exercise classes. The studio was taken over by new management one year ago and the new manager Samuel Song wants to make some adjustments in order to operate the business more efficiently. Samuel handles bookings, accounts and organises the teaching timetable and roster for the part time fitness instructors he 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 senior citizen exercise classes.
Samuel believes that it’s about time to review the effectiveness of the fitness studio with regard to revenue and profitability. Is the business growing? What are the likely future trends? He intends to revise the timetable and possibly take other steps to further increase revenue and profits. He has engaged you as a business consultant and would like you to:
• Conduct descriptive analysis of the data he has maintained over the past three terms.
• Conduct predictive analysis and then provide an overview ofrevenue trends.
• Discuss the various options regarding possible future adjustments to the classes, fitness instructors and timetable based on your analysis.
• Make recommendations with regard to future changes which might assist in further improving revenue and profitability. Briefly justify these recommendations.
An excel spreadsheet has been provided containing the data for “Star Fitness” enrolments from January to September 2024, and various related data on costs. Samuel 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.
You will be required to write a business analysis report which analyses and discusses the performance of the business and the various options available to help increase future revenue and profitability. In addition, you will need to discuss about the potential growth of the business in the coming months.
Preparing the Business Analysis Report:
Report structure
The analysis, findings and recommendations which you prepare for the company should be outlined in a professional business analysis report.
This report should include:
• A Title page – with areport title, student name/number, class, module name (Information Systems for Business).
• A Table of Contents (TOC)
• A brief Introduction which clearly outlines the purpose of the report.
• The Analysis you have undertaken and a Discussion regarding the results of this analysis. You will have to conduct Descriptive and Predictive Analysis of the data.
• A short Conclusion which summarises the major findings of the report.
• At least THREE clear Recommendations that the management 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.
Report Format
The report should be written and presented to a professional standard and directed towards the management of the company.
Specifically you should:
• Ensure your report is concise: 2500 words. This word count includes Title page and Table of Contents.
• Present the report in a professional, business format with no spelling or grammatical errors.
• Use appropriate headings and subheadings throughout the body of the report.
• Use double or 1.5 spacing.
• Fully Justify all text in the report.
• You must include relevant charts and tables you have created in the body of your report (appropriately labelled). The material in the charts and tables must be discussed as part of the report.
• There is no need to include references or citations as this is a business report.
Section B - Presentation (25 marks)
The group will be required to make a presentation (10-15 mins) about their analysis of the business during the last two lessons. Your lecturer will provide more details about the format and structure of the presentation.
The group will have to prepare a set of PowerPoint slides to support the presentation. Every member of the group will have to participate in the group presentation.
Submission Guidelines
You will need to upload the following files to the Canvas (Learning Management System) dropbox by the assignment due date:
1. MS Excel file (containing all relevant calculations and data analysis worksheets).
2. MS Word file (containing the business analysis report).
Marking scheme for the Business Analysis Report
|
Structure and organisation
|
10 marks
|
|
Introduction
|
5 marks
|
|
Descriptive analysis and discussion
|
20 marks
|
|
Predictive analysis and discussion
|
10 marks
|
|
Conclusion
|
5 marks
|
|
Recommendations
|
15 marks
|
|
Supporting Charts and Tables
|
10 marks
|
|
Total
|
75 marks
|