Murano Restaurant: Data Analysis and Business Decision Making Report

This report provides a comprehensive analysis of Murano Restaurant's business decision-making process. It begins by outlining plans for collecting both primary and secondary data, including personal interviews, emails, observations, and simulations, along with a detailed survey methodology and questionnaire format. The report then delves into the statistical tools used for data analysis, such as mean, median, mode, measures of dispersion (standard deviation, variance, correlation coefficient, and range), and quartiles/percentiles, using revenue and profit data from the last ten years. Furthermore, it discusses conclusions drawn from graphs, trend lines, and the creation of a business presentation and report. Finally, the report explores the application of information tools for decision-making, including a business plan, Gantt chart, NPV, and IRR calculations, providing a well-rounded view of the data-driven decision-making process for the restaurant, including its potential for expansion.

Business Decision
Making

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
TASK- 1...........................................................................................................................................3
1.1 Plan For the Collection Of Primary & Secondary Data.........................................................3
1.2 Survey Methodology..............................................................................................................4
1.3 Questionnaire Format For Murano........................................................................................5
2.1 Information Used in Decision Making..................................................................................7
2.2 Mean, Median & Mode .........................................................................................................8
2.3 Measures Of Dispersion ........................................................................................................8
2.4 Quartiles & Percentiles..........................................................................................................9
TASK-2..........................................................................................................................................10
3.1 Conclusions Based on Graphs.............................................................................................10
3.2 Trend Lines..........................................................................................................................13
3.3 Business Presentation .........................................................................................................13
3.4 Business Report...................................................................................................................13
TASK-3..........................................................................................................................................14
4.1 Information Tools For Decision-Making.............................................................................14
4.2 Business Plan and Gantt Chart.............................................................................................14
4.3 NPV & IRR .........................................................................................................................16
CONCLUSION..............................................................................................................................16
REFERENCES..............................................................................................................................18
2

INTRODUCTION
Decision making is an integral part of every successful business enterprise in the present
scenario. Rational and sound decision making on the basis of statistical data is the primary
function of the management executives in any organization. Decision making processes are the
indispensable and continuous component for managing any company and its business activities.
The present report will provide a a detailed description of the various statistical tools that can be
used for the purpose of efficient and effective decision making (Groebner and et.al, 2011). The
study will also help in analyzing the various data collected from the external and internal
environment and hence enable the organization to take decisions on a reasonable basis. For the
purpose of carrying out this assessment Murano restaurant is selected. It is the food chain
restaurant which operating in London and is presently considering for opening a second branch.
TASK- 1
1.1 Plan For the Collection Of Primary & Secondary Data
For the purpose of carrying out data interpretation and take effective decisions on that
basis the activity of data collection plays a vital role. Data is the primary input for any kind of
decision making exercise. There are two broad classification of methods by which a business can
be collected. They are primary and secondary sources of data collection. The first hand evidence
left behind by the observers or the participants at a particular time is called primary data. That
means this data is directly collected from the participants or people for the purpose of decision-
making. On the contrary the secondary sources of data is collected and interpreted by someone
else and used for the purpose of making decisions (Groebner and et.al, 2011). Secondary Sources
discuss, describe, comment upon, analyze and comment upon the data collected from primary
sources. Below is a brief description of the various sources by which data can be collected
through primary and secondary sources.
Primary data- The following are some of the sources from which Murano can collect the data
which can be used for an effective decision making.
 Personal Interviews- Interviews of the people residing nearby can be taken. The
observation are to be recorded that can be interpreted later on. The opinions of the people
can be used in making the necessary changes (Hwang and Yoon, 2012).
3

 Emails- Different questionnaires can be floated by emails to customers who have either
visited the webpage of the restaurant or have used the services provided by the restaurant
at least once. The emails may require them to provide the ratings for the services
provided of the restaurants. Hence this is an effective source for collection of an authentic
data.
 Observations- By personally observing the reaction of the customers who have used the
services once the assessment of the performance can be done. Marano can collect the
feedback given by the customers and by observing general trends it can conclude whether
another branch in the city can be opened or not. Simulation- Another method by which Murano can collect data is through conducting an
effective simulation. Simulation is a technique which involves the imitation of the real
real processes of the world over the definite time period taken as sample.
Secondary Data- Some of the common sources for the purpose of collecting the secondary data
which can be used by Murano Restaurant are described in brief below (Groebner and et.al,
2011).
 Internal Sources- These can be the historical information of the restaurants like the cost
sheet of the previous years, reviews of the customers, other reports and feedback
prepared on the basis of data gathered. The purpose of Murano for the collection of data
through these sources is to formulate various marketing strategies.
 External Sources- The main motive of Murano behind using the data for making financial
applications. The various sources available are the books, newspapers, journals, internet
and libraries.
1.2 Survey Methodology
Survey for the purpose of collection of the feedback of the customers will be conducted
by using an online survey mechanism. The questionnaires are mailed to the respective list of
persons. The responses collected by them will enable Murano to draw reasonable conclusions.
The online method used for the purpose of data collection is best as the data can be collected
easily that too without the any unnecessary wastage of time and money. Hence this method is the
most effective method for the collection of structured data.
4

Sampling Frame- A sample of 100 customers have been taken by Murano in order to collect data
as per their responses. The selection of the customers will be done by using structured sampling
technique. This method involves the selection of the random selection of customers of Murano
and so the problem of using a biased data is resolved. Hence random sampling will give the most
accurate outcomes and thus will ensure in the effective decision making (Popovič, and et.al,
2012).
1.3 Questionnaire Format For Murano
A questionnaire covering all the necessary questions which are relevant for the purpose
of opening a branch of Murano have been included. Data will be compiled on the basis of the
responses given by the people. The information collected by this questionnaire will further help
Murano in framing its marketing strategies.
Q.1 Select from the given alternatives the reason for choosing Murano-
a) Wanted to try out something new.
b) Friendly environment of Murano.
c) The food is delicious.
Q.2 As a customer which of the following items would be a top priority for you?
a) Food Quality
b) Environment & Ambiance of the place
c) The Services & Hospitality of the restaurant.
Please rate from the following about the services provided by Murano-
Q.3 Pleasant greeting by the doorman:
a) Excellent
b) Very Good
c) Good
d) Average
e) Poor
Q.4 Minimal waiting time after placing the order:
a) Excellent
b) Very Good
5

c) Good
d) Average
e) Poor
Q.5 Courtesy displayed by the staff at the front desk:
a) Excellent
b) Very good
c) Good
d) Average
e) Poor
Q.6 Orderly Reservations made by the restaurant as soon as I arrive:
a) Excellent
b) Very Good
c) Good
d) Average
e) Poor
Q.7 Promptness of Services Provided:
a) Excellent
b) Very Good
c) Good
d) Average
e) Poor
Q.8 Quality & taste of food served:
a) Excellent
b) Very Good
c) Good
d) Average
e) Poor
Q.9 Environment of Murano:
6

a) Excellent
b) Very Good
c) Good
d) Average
e) Poor
Q.11 The level of hygiene maintained :
a) Excellent
b) Very Good
c) Good
d) Average
e) Poor
Q.10 General level of Satisfaction Derived from the Restaurant & its Services:
a) Excellent
b) Very Good
c) Good
d) Average
e) Poor
2.1 Information Used in Decision Making
The following data has been collected of Murano of last ten years showing the revenues and
profits.
Years Revenues (in '0000' £) Profits (in '0000' £)
1 20 5
2 35 10
3 42 14
4 46 19
5 49 25
6 51 30
7 55 36
8 59 42
7

9 65 50
10 72 58
Total 494 289
Conclusion- By analysing above data it is clearly evident that both the revenues and profits of the
restaurant are displaying an increasing trend. The factors that have contributed in this increase
has the better customer services provided by Murano, Good quality of food supplied, and the
hygienic environment in which the food is being served. Thus it can be concluded that the
restaurant is showing a speedy growth and has become one of the most favorite dining place of
the people of London.
2.2 Mean, Median & Mode
MEAN is the measure used to find out the average of the data collected. It is one of the
most common and popular measures of central tendency and therefore is used to identify the mid
value of the given series. It is calculated by using the following Formula-
Total Of observations/ Number Of Observations
Accordingly,
Mean of the Revenues will be £ 49.40 .
Mean Of Profits will be £ 28.90 .
MEDIAN- It is the middle score of the given set of data which is being arranged in the order to
its magnitude. Median is remains unaffected by the skewed values and other outliars. It the value
of (N+1)th item /2
Accordingly,
MEDIAN of Revenues will be (10+1)th item/2
That is 5.5th item =50
Similarly median for Profits is 27.50
MODE-
As there are no repetitive figures or the data with more than one frequency in the revenues and
profits and so the mode cannot be calculated of these series (Measures of Central Tendency,
2013).
8

2.3 Measures Of Dispersion
These measures helps in identifying the differences in the values from that of their mean values.
In the present scenario of Murano restaurant these measures will find the difference in the values
of the revenues and profits of any year from that of its mean value. Hence this will enable to
identify the levels of the risks to which the business is exposed (Popovič, and et.al, 2012). The
following are measures of Dispersion which is relevant for Murano:
Standard deviation- The significance of the calculating standard deviation is to analyse the risk
factors of Murano. Hence it is the difference of the value of any particular year from that of its
mean value. Likewise Standard Deviation of the Revenues is 14.98 and that of the profits is
17.57. Standard Deviation is the value of square root of the variance (Groebner and et.al, 2011).
Variance is the the square of the deviations of the values from that of its mean value.
Likewise variance of the Revenues- 224.267
Variance Of the Profits-308.766
Correlation Coefficient- Correlation coefficient is used to analyse the relation between the given
set of variables. In the given set of data the correlation coefficient between the revenues and
profits of Murano is 0.9603 . This correlation coefficient implies that the profits and revenues are
directly related. That means with the increase in the revenues the profits will also rise.
Years Revenues (in '0000' £) Profits (in '0000' £)
1 20 5
2 35 10
3 42 14
4 46 19
5 49 25
6 51 30
7 55 36
8 59 42
9 65 50
10 72 58
Range- Range is the mean of the highest and the lowest value in the given series. That means for
the purpose of calculating range of the revenues and profits the mean of the highest and lowest
values will be taken.
9

Accordingly, range of the revenues is 52 while that of profits is 53.
2.4 Quartiles & Percentiles
Quartile/ Percentiles Revenues Profits
1st Quartile / 25th Percentile 43 15.25
2nd Quartile / 50th Percentile 50 27.5
3rd Quartile / 75th Percentile 58 40.5
Quartiles represents the 25 % , 50% and 75 % of the quarterly values of revenues and profits
earned by Murano restaurant. Hence calculation of the the quartiles for the year has been
represented in the tabular format.
TASK-2
3.1 Conclusions Based on Graphs
Column Graph
Conclusion- By the analysis of the conclusion of the above graph it can be concluded that the
revenues and profits are increasing in the period of 10 years. Also there is a positive correlation
10
0
10
20
30
40
50
60
70
80
Relationship between revenue and profit
Revenues
Profits

between the profits and revenues of Murano. However the increase in the profits is lesser than
that of revenues which is quite obvious and is reflected.
Conclusion- By the analysis of the bar graph it can be interpreted that the revenues and profits
are increasing in the period of 10 years. However there is a lesser increase in the percentage of
increase in profits than that of revenues (Groebner and et.al, 2011).
11
1
2
3
4
5
6
7
8
9
10
0 10 20 30 40 50 60 70 80
Profits
Revenues

Pie Chart Of Profits
Conclusion
The above pie chart represents the percentage of profits of Murano in 10 years. It can be
interpreted that the highest percentage of profits were earned in the year 10 which is the recent
year. It is also seen that the profits are increasing as time passes (Popovič, and et.al, 2012).
Pie Chart of Revenues
12
510
14
19
25
30
36 42
50
58 1
2
3
4
5
6
7
8
9
10

Conclusion- The above pie chart represents the proportional revenues earned by the Murano in a
particular period of time of ten years. By the analysis it can be interpreted that the revenues are
constantly increasing in the respective years. Also the highest revenues is that in the 10th year.
3.2 Trend Lines
13
20
35
42
46
49
51 55
59
65
72 1
2
3
4
5
6
7
8
9
10

Conclusion- The above graph represents the trend lines for the profits and revenues of the
Murano restaurant. There is a linear trend reflected by the lines which means that the profits and
revenues of the stated restaurant are showing a linear constant increasing trend.
3.3 Business Presentation
Covered in ppt.
3.4 Business Report
To
The Manager Of Murano restaurant
Introduction- This report is prepared for the purpose of analysing whether the profitability of the
Murano restaurant would increase by opening a new branch in London. The decision regarding
the viability of opening a new branch will be taken on the basis of the various statistical
projections.
Methodology: Firstly data is being collected by using primary and secondary sources. The online
surveys are being conducted for the purpose of data collection. Online method is used as it the
most time and other resources saver method. The mean, mode and median are computed for
drawing out the necessary conclusions based on the company's historical data. Also other
14
1 2 3 4 5 6 7 8 9 10
0
10
20
30
40
50
60
70
80
f(x) = 4.8 x + 23
f(x) = 5.77575757575758 x − 2.86666666666667
Revenues
Linear (Revenues )
Profits
Linear (Profits)

methods of dispersion are used to analyse the risk factors in this industry. Than the data collected
is being presented in form of well explained graphs and trend lines.
Findings- By analysing the data from the graphs and the trends lines along with the other
statistical measures it has been found that the profits and revenues are showing increasing trend
in the respective years. Also both the profits and revenues are showing the positive correlation
that implies that they are directly proportional to each other (Hwang and Yoon, 2012).
Conclusion- After making the analysis it can be inferred that the revenues and profits are
constantly increasing from last ten years. However based on the NPV evaluation the net
discounted cash inflows are negative. Also the IRR of the prospective project has came out to be
9% which less than the expected return of 12%. NPV & IRR are more effective and accurate
methods of decision-making. Hence based on NPV & IRR it can be concluded that the
prospective project of opening a branch of Murano is not recommended to be undertaken.
TASK-3
4.1 Information Tools For Decision-Making
4.2 Business Plan and Gantt Chart
In order to start another branch of Murano a set of activities have been identified in order to
assess the final completion time or total duration required for the new restaurant to be
operational. The following activities have been identified along with their duration:
Activity Activity Name Duration (in days) Predecessor Activity
1 Primary Investigation 10
2 Setting new project location 6 1
3 Collecting Primary Data 8 2,1
4 Carrying out Secondary Investigation 7
5 Data Analysis 12 4
6 Documentation 4 5
7 Recruiting staff 7 4,5
8 Starting up the new restaurant 13 5,6
9 Business Analysis 8 6,7,8
10 Taking the decisions to combat issues 4 9
11 Change Implementation 2 9,10
15

Conclusion- The above Gantt Chart represents the time required for the completion of all the
activities presented in the form of a Gantt chart. It can be interpreted that the total time required
in order to complete all the activities is 11 days. All the activities highlighted in red are on the
critical path and are thus called critical path activities.
16

4.3 NPV & IRR
Year Inflows
Present value @
12% Present Value
0 -190000 1 -190000
1 50000 0.892 44642.857
2 64000 0.797 51020.408
3 58000 0.711 41283.254
4 70000 0.635 44486.265
NPV -8567.214
IRR 9.94%
Net Present value- This the present values of all the inflows of the project undertaken reduced
by that of its initial investment. NPV is an effective method to analyse the viability of the project
and to make decision whether to undertake it or not. NPV is the net discounted value of the cash
flows generated which will help in assessing the yearly expected discounted cash inflows. In the
present case the NPV of the project is negative which implies that the project is not yielding
sufficient revenues to cover its initial investment at the required rate of return. Hence this project
should not be undertaken (Zsambok and Klein, 2014).
Internal Rate Of Return- The rate at which the restaurant is earning returns by employing the
funds in business is known as internal rate of return. The rate of return of Murano is the 9.94%
which lesser than the expected rate of return of 12% which is the discounted rate mentioned.
Hence it is suggested not to make investment in the prospective project as it doesn't yields the
requisite return (Measures of Central Tendency, 2013).
CONCLUSION
The analysis for Murano has been conducted for the purpose of evaluating the viability
of opening a branch in the London. For the purpose of drawing conclusions the data has been
collected from primary and secondary sources and the interpretation of the collected data has
been made by using respective analytical tools. The methods of NPV & IRR are given priorities
for decision making. Finally the conclusion drawn is not to open any branch of Murano at
present as it is not profitable in comparison with the company.
17

18

REFERENCES
Books & Journals
Zsambok, C.E. and Klein, G., 2014. Naturalistic decision making. Psychology Press.
Power, D.J., Sharda, R. and Burstein, F., 2015. Decision support systems. John Wiley & Sons,
Ltd.
Hwang, C.L. and Yoon, K., 2012. Multiple attribute decision making: methods and applications
a state-of-the-art survey (Vol. 186). Springer Science & Business Media.
Popovič, A., and et.al, 2012. Towards business intelligence systems success: Effects of maturity
and culture on analytical decision making. Decision Support Systems, 54(1), pp.729-739.
Groebner, D.F., and et.al, 2011. Business statistics. A Decision making approach, 5.
Stewart, D.D. and Stasser, G., 1995. Expert role assignment and information sampling during
collective recall and decision making. Journal of personality and social psychology, 69(4),
p.619.
Cyert, R.M., Simon, H.A. and Trow, D.B., 2016. Observation of a business decision. The
Journal of Business, 29(4), pp.237-248.
Black, K., 2009. Business statistics: Contemporary decision making. John Wiley & Sons.
Hwang, C.L. and Yoon, K., 2012. Multiple attribute decision making: methods and applications
a state-of-the-art survey (Vol. 186). Springer Science & Business Media.
Chen, M.F. and Tzeng, G.H., 2004. Combining grey relation and TOPSIS concepts for selecting
an expatriate host country. Mathematical and Computer Modelling, 40(13), pp.1473-1490.
Davis, K., 2012. The case for and against business assumption of social responsibilities.
Academy of Management journal, 16(2), pp.312-322.
DeTore, A.W. and Suever, R.D., Lincoln National Risk Management, Inc., 2015. Automated
decision-making arrangement. U.S. Patent 5,732,397.
ONLINE
Decision-making, 2016. [ONLINE] Available through
<http://www.inc.com/encyclopedia/decision-making.html> Assessed on 3rd January 2017.
19