HND Business: Data Analysis and Presentation for Decision Making

This report focuses on data analysis and presentation for business decision-making within the context of an HND Business course. It uses both primary and secondary data to evaluate the performance of a restaurant called Murano. The analysis of secondary data reveals an increase in sales revenue and profit margin over the years. Trend lines are used to project future performance, suggesting positive results for expansion. Primary data, gathered through surveys, assesses customer preferences regarding dining services, food quality, and other factors. The report interprets these findings to inform business decisions related to Murano's operations and potential growth. Desklib provides students access to this and many other solved assignments.

Business decision making
Task 2

3.3 Business presentation
Graphical presentation
2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
0
500
1000
1500
2000
2500
Sales (in £)
Profit (in £)

Continued
 By doing analysis of secondary data set, it has found
that sales revenue of Murano increased from £980 to
£2050 at the end of 2017. Along with this, profit margin
of the restaurant unit also inclined over the years to a
great extent.
 Hence, increasing sales pattern entail that customer base
of restaurant unit is good. Further, higher sales indicate
that customers give more preference to the dinning
services which are offered by Murano.
 Along with this, profitability trend exhibits that such
restaurant unit has made effectual control on expenses.
Thus, it can be depicted that financial performance of
Murano is good in terms of revenue and margin.

Continued
Trend Line:
It shows direction or pattern on the basis
of which specific data set will move in the
near future.
Such statistical tool helps business entity
or analyst in understanding or evaluating
future trends.

Continued
2008 2009 2010 2011 2012 2013 2014 2015 2016 2017
0
500
1000
1500
2000
2500
f(x) = 115.575757575758 x + 862.333333333333
f(x) = 78.3636363636364 x + 28
Sales (in £)
Linear (Sales (in £))
Profit (in £)
Linear (Profit (in £))

Continued
Interpretation:
The above depicted trend line shows increasing pattern in
both the variables considered for the evaluation. It is a
positive indicator which in turn shows that by establishing
another unit in London owner of Murano will get positive
results.
Thus, to achieve the same results business entity needs to
lay more focus on promotional aspects which in turn helps
in attracting more customers and enhancing revenue.
Further, such restaurant unit also needs to exert control
on expenses for generating suitable and higher margin.

Primary Data Assessment
Theme 1: Dinning services of
Murano comes under which
one of the following category Particulars
Responden
ts
% of
respondent
s
Poor 2 8%
Average 3 12%
Good 4 16%
Better 10 40%
Best 6 24%
Total 25 100%
Poor
Average
Good
Better
Best
0%
5%
10%
15%
20%
25%
30%
35%
40%
45%
% of respondents
% of respondents

Continued
Theme 2: At the time of
selecting restaurant food
quality is the most preferred
criteria that is considered by
the customers
Particular
s
Responde
nts
% of
responden
ts
Concept of
restaurant 3 12%
Quality of
food 8 32%
Service 2 8%
Pricing 3 12%
Convenien
ce 4 16%
Ambiance 5 20%
Total 25 100%
Concept of restaurant
Quality of food
Service
Pricing
Convenience
Ambiance
0%
10%
20%
30%
% of respondents
% of respondents

REFERENCES
Moja, L. and et.al., 2016. Implementing an evidence-based
computerized decision support system to improve patient care in a
general hospital: the CODES study protocol for a randomized
controlled trial. Implementation Science. 11(1). p.89.
Mukaka, M. M., 2012. A guide to appropriate use of Correlation
coefficient in medical research. Malawi Medical Journal. 24(3).
pp.69-71.