X-Fit Chain Gyms: January 2018 Spreadsheet Report and Analysis

This report presents a financial analysis of X-Fit Chain Gyms based on data from January 2018. It explores the use of spreadsheets to analyze membership numbers and fees, distinguishing between peak and off-peak seasons across five London locations. The report details the financial performance of each club, identifying those operating at a profit or loss, and calculates the overall income. It also discusses the benefits of Microsoft Office applications like Word, Excel, and PowerPoint for business productivity, and highlights technological advancements such as interactive virtual bulletin boards, cloud-based collaboration, and resourcing through cloud computing. The conclusion summarizes the findings, recommending the adoption of new technologies to improve the quality and productivity of the business, ultimately aiming to enhance the gym's financial performance and member experience.

Running head: X-FIT CHAIN GYMS SPREADSHEET REPORT
X-Fit Chain Gyms Spreadsheet Report
Name of student
Name of University
Student Number
Submission Date
Author’s Note

1X-FIT CHAIN GYMS SPREADSHEET REPORT
Table of Contents
1. Introduction..............................................................................................................................2
2. Presentation & Explanation of Business Data..........................................................................2
3. Benefits of Microsoft Office to Business Productivity..........................................................15
3.1. Microsoft Word...................................................................................................................16
3.2. Microsoft Excel...................................................................................................................16
3.3. Microsoft PowerPoint.....................................................................................................17
4. Technological Advancements for Business...........................................................................17
4.1 Productivity:.........................................................................................................................17
4.2 Collaboration:.......................................................................................................................18
4.3 Resourcing:..........................................................................................................................18
5. Conclusion..............................................................................................................................19
6. References..............................................................................................................................20
7. Appendix................................................................................................................................22

2X-FIT CHAIN GYMS SPREADSHEET REPORT
1. Introduction
X-Fit Chain Gym has branches in Enfield, Shoreditch, Deptford, Wembley, Peckam that
are located in London. As an accountant in X-Fit chain of gyms, the question that could be raised
is that “What is the Gross Income that the club has achieved with the offer that they provide in
the peak and off peak season for a membership. Is the business actually making any kind of
profit?” Thus, the study will be done based on this concern and provide steps by step procedure
for the report. The report will give the presentation about the membership numbers and fees of
the month of January 2018 that contains the complete information about the income that the
company achieve and give a brief explanation about the financial situation of the business. In the
next section, it will discuss about the benefits of the Microsoft Office for the Productivity of the
Business. Finally, the report will contain the three technological advancements for increasing the
productivity.
2. Presentation & Explanation of Business Data
Report Sheet:

3X-FIT CHAIN GYMS SPREADSHEET REPORT
Figure 1: Table of January 2018
Data View:
Figure 2: Insert date
Formula View:
Figure 2.1: Formula to insert date
Data View:

4X-FIT CHAIN GYMS SPREADSHEET REPORT
Figure 3: Number of Peak and Off-Peak Members
Formula View:
Figure 3.1: Formula for Total Number of Peak Members
Figure 3.2: Formula for Total Number of Off-Peak Members
Data View:

5X-FIT CHAIN GYMS SPREADSHEET REPORT
Figure 4: Peak Members Total Paid Fees per Club
Formula View:

6X-FIT CHAIN GYMS SPREADSHEET REPORT
Figure 4.1: Formula Total Paid Fees for Peak Members per Club
Data View:
Figure 4.2: Total Paid Fees for Peak Members
Formula View:
Figure 4.3: Formula for Total Paid Fees for Peak Members
Data View:

7X-FIT CHAIN GYMS SPREADSHEET REPORT
Figure 5: Off-Peak Members Total Paid Fees per Club
Formula View:
Figure 5.1: Formula for Off-Peak Members Total Paid Fees per Club

8X-FIT CHAIN GYMS SPREADSHEET REPORT
Data View:
Figure 5.2: Total Paid Fees for Off-Peak Members
Formula View:
Figure 5.3: Formula for Total Paid Fees for Off-Peak Members
Data View:

9X-FIT CHAIN GYMS SPREADSHEET REPORT
Figure 6: Total Paid Fees Per Club
Formula View:
Figure 6.1: Formula for Total Paid Fees Per Club

10X-FIT CHAIN GYMS SPREADSHEET REPORT
Data View:
Figure 6.2: Club Total Paid Fees
Formula View:
Figure 6.3: Formula for Club Total Paid Fees

11X-FIT CHAIN GYMS SPREADSHEET REPORT
Data View:
Figure 7: Club running at profit or loss
Formula View:
Figure 7.1: Formula for Club running at profit or loss