HNC Business Decision Making Report: Data Analysis and Presentation

This report presents an analysis of data related to a leisure centre, focusing on business decision-making. It includes various graphical representations such as line graphs, bar charts, pie charts, scatter plots, and histograms to illustrate sales revenues, net income, and customer investment patterns. The report interprets these visualizations, highlighting trends and fluctuations, and employs forecasting techniques to predict future sales. A business report is also presented, outlining the methodology, which includes the use of questionnaires for market research. The findings indicate increasing sales trends and the report concludes with recommendations for refurbishing the leisure centres. References to supporting literature are also provided.

Business decision making
TASK 3.3

GRAPHICAL
PRESENTATION

LINE GRAPH

PIE CHART
2300
1400 1000
1600
900
Birmingham Branch
Coventry Branch
Wolverhampton Branch
Solihull Branch
Stoke Branch

BAR CHART
Birmingham Branch
Coventry Branch
Wolverhampton Branch
Solihull Branch
Stoke Branch
0 500 1000 1500 2000 2500
2300
1400
1000
1600
900
Net Income (£)

SCATTER PLOT ON
ADVERTISING AND SALES

INTERPRETATION
It can be interpreted from the above line graph that sales revenues of
leisure centre is continuously increasing from the year 1995 to
2010. As, promotional activities are increasing , the sales are
increasing with higher values. However, there are fluctuation in
the sales, but overall it is rapidly increasing. From the bar chart, it
can be state that net income generated by Aqua Sulis Leisure is
higher in Birmingham Branch with 2300, Solihull Branch also has
high income of 1600 than other branches. The same conclusion
can be drawn by the pie chart, in which Birmingham Branch has
high income than others. Furthermore, it can also be stated from
the scattered diagram that sales of leisure centre is continuously
increasing.

TREND LINE OF
ADVERTSING COST
and SALES

INTERPRETATION
Forecasting can be defined as the process to make predictions of future on the basis of
current and past data. Trend line the tool to forecast the sales and profits of the
company. From the above diagram, it can be stated that sales revenues of the leisure
centres are continuously increasing, where promotional activities kept almost
constant. There is high amount of profits can be obtained with the increased sales of
the leisure centres. With the help of forecasting methods, the fluctuation in the
market can be analysed and several effective measures can be taken to mitigate this
financial crisis.

HISTOGRAM

The average investment by customers at Solihull's Leisure Centre is
more in the class interval of 6.2 to 10.2 and 10.2 to 14.2 with the
frequency of 10 each. Furthermore, it can be stated that,
customers are willingly spend at leisure centre during the time
interval of 6.2 to 10.2 and 10.2 to 14.2.

BUSINESS REPORT
Introduction
The purpose of the present report is to market research and analyse whether
leisure centre should refurbished according to demand and preference of
customers.
Methodology
Questionnaire will be used as survey methodology to collect the information,
views and opinions of customers. There are various chart diagram will also be
used to determine the status of leisure centre in market.

CONTINUED...
Findings
It can be found that, with the help of trend line diagram and other techniques it can be
stated that the sales of leisure centre is continuously increasing.
Conclusion
It can be concluded that, BANES should refurbish its leisure centres in an effective way,
so that large number of customers can be attracted.

REFERENCES
Cohen, J. and et. al., 2013. Applied Multiple Regression/ Correlation
Analysis for the Behavioral Sciences. Routledge.
Deochand, N., Costello, M.S. and Fuqua, R.W., 2015. Phase‐change lines,
scale breaks, and trend lines using Excel 2013. Journal of applied
behavior analysis. 48(2). pp. 478-493.
Ferrell, O.C. and Fraedrich, J., 2016. Business ethics: Ethical decision
making & cases. Nelson Education
Gibson, A., 2011. Exposure and understanding the histogram. Peachpit
press.
Hamister, W. J. 2012. Supply chain management practices in small
retailers. International Journal of Retail & Distribution Management.
40(6). pp.427-450.

THANK YOU