HND Business Decision Making Assignment Solution - Task Analysis

This assignment solution addresses a business decision-making problem for Murano restaurant, focusing on their expansion plans. It begins with a plan for collecting primary and secondary data, followed by a presentation of survey methodologies and sampling frames. A questionnaire is designed to gather customer insights, and the collected data is then analyzed using measures of central tendency and dispersion to draw valid conclusions. The solution also includes the creation of graphs and spreadsheets for data visualization, the development of a project management plan, and the application of financial tools for decision-making. The analysis explores customer preferences, market trends, and financial implications to support informed business decisions regarding the new outlet's location and operational strategies. The assignment also includes a questionnaire design, data analysis using measures of central tendency and dispersion, and a project management plan.

Add more information to 4.2 and do 3.2 please.

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
1.1 Plan for collecting primary and secondary data...............................................................1
1.2 Present the survey methodology and sampling frame used..............................................2
1.3 Design a questionnaire for given business problem.........................................................3
2.1 Creation of information....................................................................................................4
2.2 Analyse the result for drawing valid conclusion..............................................................5
2.3 Analysis of information through measure of dispersion..................................................6
2.4 Quartile and correlation coefficient in better decision making........................................7
TASK 2............................................................................................................................................8
3.1 Produce graphs and spreadsheets for drawing valid conclusion......................................8
3.2 Create trend lines for future estimation............................................................................9
3.3 Presentation for senior management..............................................................................10
3.4 Formal business report for management........................................................................10
TASK 3..........................................................................................................................................11
4.1 Use of appropriate information processing tool.............................................................11
4.2 Prepare a project management plan with critical path system.......................................11
4.3 Use of financial tools for decision making.....................................................................14
CONCLUSION..............................................................................................................................15
REFERENCES..............................................................................................................................16

INTRODUCTION
An effective decision need to be taken by each organisation as this enables them to gain
opportunities which help them to survive at marketplace for longer period of time. Judgement for
company will be related to their expansion of business or their activities as well (Barlett, 2016).
Present assignment is based on Murano restaurant which is set up in UK and they are going
enlarge their business activities. They have to take decision regarding this so that they will
improve profits and market share effectually. To gather data and information they will acquire
support of primary or secondary source. To conclude result, charts or tables will be formulated
by manager. There are many financial tools or methods which will support company into their
process of decision making.
TASK 1
1.1 Plan for collecting primary and secondary data
It is required for an organisation to utilize significant methods or tools as this will assist
them to comprehend numerous facts. This will aid to gather appropriate data as well as
information; therefore, they will be able to promote business effectually (Beach and Lipshitz,
2017). Henceforth, there are many techniques which will be used by Murano for data collection
and these are stated as beneath:
Primary data: There is requirement for latest information for some project so that it is
must for an enterprise to conduct this sort of research. It is much accurate and in addition recent;
thus, manager of firm will easily acquire judgement effectively. There are several methodologies
which will comprise into this, like questionnaire, survey and so forth.
Secondary data: With assistance of this, company will collect data through many
resources, such as internet, research paper, magazine and many others. Fundamental
disadvantage of using this technique is that, data is old so that it cannot be considered as most
accurate or effective. But, it consumes less time as well as cost (Blondel and Müller-Rommel,
2016).
In this assignment, superior use primary data collection method as it helps to understand
each things in a proper manner. This will aid to take decision more effectively and efficiently.
Primary data will define:
 There is requirement of flexibility of data and information collection procedure.
1

 Identify and select sample size so that research will be conduct properly, here sample size
is 80.
 Determine most suitable methodologies to gather data and information, i.e. questionnaire.
 Choose best technique to evaluate result.
1.2 Present the survey methodology and sampling frame used
Survey is refereed to as activity through which researcher gathered data on specific issue
and problem (Drucker, 2017). So, this process is used to ascertain adequate results and take
appropriate selections. In Murano, various methods of survey are used to acknowledge elements
which are advantage for company's functionality; which are stated as beneath:
Questionnaire: This is adequate tool of survey through which each and every person
opinion is taken. For this series of questions are asked, to enquire their thoughts and make
system function appropriately. So, it helps firm to make appropriate and efficient decisions on
basis of feedback of every individual.
Personal interview: It is another technique of survey which defines process that
investigator takes suggestions from people by asking appropriate questions. This provide support
in enhancing and making system function effectively.
Social media: As there is technological advancements, so this tool is important through
which adequate outcomes are get. Through this survey, investigator gets support to get
appropriate suggestions from people (Goleman, 2017).
From above described method, questionnaire and social media is considered as a best tool
to gather response from respondents in an effective way. People are get selected with assistance
of social media followers and send them invitation to fill the form of questionnaire. Instead of,
there is another methodologies which will be used by manager to gather data and information,
i.e. sampling. Hence, there are various types of sampling tools which will be utilized by Murano,
these are stated as below:
 Random sampling
 Quota sampling
 Strata sampling
From above techniques, random sampling methodology is using by association to select
viewpoint of distinctive people. It will be helpful for firm to get an effective decision for
business which is much beneficial for them (Rao and Tilt, 2016).
2

1.3 Design a questionnaire for given business problem
This is considered as a most suitable method to gather an appropriate data and
information so that manager will take judgement in an appropriate way. As manager of Murano
is going to open new outlet in UK; therefore, they conduct a survey to gather views or thoughts
of people regarding this (Rothman, 2017). It will help them into procedure of decision making.
Questionnaire
Name:
E- mail:
Age:
Gender:
Q1. According to you, how is quality of items and services of company which is providing
to customers?
a) Good
b) Excellent
c) Bad
Q2. Is organisation being able to accomplish needs and wants of clients effectively?
a) Yes
b) No
Q3. During a month, how many time you visit Murano?
a) Twice
b) One
c) Rarely
Q4. As per you, prices of firm are affordable for each sort of consumers?
a) Yes
b) No
Q5. Is quality of beverages of Hotel is appropriate?
a) Yes
b) No
Q6. Are staff members of an enterprise friendly to every client?
a) Agree
b) Disagree
3

Q7. Category of Murano?
a) Five star
b) Three star
c) Average
Q8. Do you ever refer Murano to your friends or family?
a) Yes
b) No
Q9. What type of location will be most appropriate for new outlet of Murano hotel?
a) Near to sea side
b) Rooftop
Q10. Any recommendations or suggestions which you want to provide company.....
2.1 Creation of information
It is like a data creation concept which aid to provide assistance so that entire information
will spread to top authority so that they will take an effective decision for affiliation. Almost 80
respondents are taken to fill questionnaire (Sekaran and Bougie, 2016). Minimum 30
respondents are required to be taken so it takes 80 respondents. Through proper research firm
will be able to attain coveted targets and goals within limited period of time effectually.
Rating R1 R2 R3
1 15 50 15
2 65 15
3 25 30 25
4 70 10
5 45 35
6 55 25
7 15 25 40
8 53 27
9 41 39
4

Questions are mentioned above this table. It has been analysed that, quality of products
and services of Murano is much effective which aid to gain attention of numerous people
towards them. But, as per some individual they have to improve quality of items. Additionally,
many persons want that they need to open their new outlet near sea as it is much advantageous
for them in improvisation of revenues and market customer base. Price of food and beverages is
much efficient which aid to capture attention of many individuals towards them.
2.2 Analyse the result for drawing valid conclusion
Data and information is collected by manager of hotel by preparing questionnaire so that
they will easily acquire an effective judgement for business. For above stated aim, superior of
Murano needs to identify measure of central tendency which is calculated as beneath:
Rating R1 R2 R3 Mean Median Mode
1 15 50 15 26.6666666667 15 15
2 65 15 40 40 #VALUE!
3 25 30 25 26.6666666667 25 25
4 70 10 40 40 #VALUE!
5 45 35 40 40 #VALUE!
6 55 25 40 40 #VALUE!
7 15 25 40 26.6666666667 25 #VALUE!
8 53 27 40 40 #VALUE!
9 41 39 40 40 #VALUE!
Mean: This will define an average of the series by which less value will get found out in
an effective and efficient manner (Shapiro and Stefkovich, 2016). This will help an organisation
to take an appropriate judgement which will help them in forthcoming time. Quality of goods
and services are effective which help to gain attention of numerous people towards them; Mean
for this is almost 26. instead of, it has been analysed that firm is able to fulfil needs and wants of
people as per their demands so that they are maintaining their customer base in a significant way.
5

Median: It helps to identify present value of the data, this has to proper; therefore,
manager will easily acquire best and effective decision for business and it enables them in
accomplishment of work. There are various people who visit Murano twice in a month which
shows that they are providing positive effect on the minds of people. It has been analysed that,
prices of goods and services of company is affordable for each sort of individual who visit this
place.
Mode: There will be many times when some number will come repetitively and shows
same kind of nature (Measures of Central Tendency, 2013). Most of the number is showing that
quality of products and services of company is much effective which help to gain attention of
numerous persons towards them. Along with, there are many people who visit twice or rarely
Murano hotel. As a result, client base of an enterprise will easily get improved.
2.3 Analysis of information through measure of dispersion
Rating R1 R2 R3 standard
deviation
variance
1 15 50 15 20.2072594216 408.3333333333
2 65 15 35.3553390593 1250
3 25 30 25 2.8867513459 8.3333333333
4 70 10 42.4264068712 1800
5 45 35 7.0710678119 50
6 55 25 21.2132034356 450
7 15 25 40 12.5830573921 158.3333333333
8 53 27 18.3847763109 338
9 41 39 1.4142135624 2
Standard deviation: This describes about difference from mean value of series to its real
frequency; thus, best and effective organisational decision will be taken (Wheelen and et. al.,
2017). It has been analysed that quality of products and services of Murano is much effective
6

which help them to capture attention of numerous people towards them. As a result, client base
of organisation will easily get improved.
Variances: Deviations will be arising in each series which has to be understand by
managerial department so that they will easily take an appropriate judgement for company. There
are many clients of company who wants to refer Murano to their friends or families because of
an effective quality of goods and services.
2.4 Quartile and correlation coefficient in better decision making
Rating R1 R2 R3 Correlation
coefficient
1 15 50 15 1 Relationship
between 1 & 3
2 65 15
3 25 30 25
4 70 10
5 45 35
6 55 25 1 Relationship
between 6 & 8
7 15 25 40
8 53 27
9 41 39
Interpretation: There is relation of correlation coefficient is established in rating 1 & 3
and rating 6 & 8. Apart from this there is no relationship has established in the whole table on
the basis of correlation coefficient.
Correlation coefficient: With help of this, manager will easily find out relation amongst
two or more variables so that they will easily take an appropriate judgement for betterment of
enterprise. Quality of food and beverage is much effective which aid to gain attention of many
individuals so that in a month there are many individuals who visit two or more time this place.
7

Quartile: This will be classified into many segment; thus, superior will take positive
decision (Zavadskas and et. al., 2016). There is some person who rated them as a five-star hotel
and this enables them to take benefits from their rivals at marketplace.
Percentile: It represents a percentage position in a list of data. It is used in statistics
reflects the value below which a given percentage of observation in a range of observation.
TASK 2
3.1 Produce graphs and spreadsheets for drawing valid conclusion
Theme 1: Quality of goods and services are excellent
Good Excellent Bad
0
10
20
30
40
50
60
15
50
15
Interpretation: Quality of goods and services of hotel is much effective which help to
gain attention of many individuals towards them. Almost 15 respondents think that quality is
good, but 50 persons marked it as an excellent. Remaining people are not happy with their
quality as they had not experienced good.
Theme 2: Organisation is able to fulfil requirement of people
65
15
Yes
No
8

Interpretation: Company is providing goods and services to customers according to their
demands so that their requirements are accomplishing within limited period of time. From above
data it has been analysed that almost 65 respondents are favouring this statement but remaining
are entirely against of this.
Theme 2: Prices of goods and services are much affordable
Yes No
0
10
20
30
40
50
60
70
80 70
10
Interpretation: Company is offering reasonable products and services to people so that
they will go to place many times. Almost 70 respondents are in favour of this argument but
remaining individuals are entirely against of this.
Theme 3: Quality of beverages are much appropriate
1 2
0
10
20
30
40
50 45
35
Interpretation: It has been analysed that quality of beverages of Murano hotel is much
appropriate which help to gain attention of many individuals towards them. From above data it
has been examined that almost 45 individuals are favouring this argument but, remaining are not.
3.2 Create trend lines for future estimation
Year Sales Net Profit
9

2017 7650 5000
2018 7700 5150
2019 7850 5200
2020 8000 5600
From the above trend line, it has been found that this positive change of generating more
revenue in coming next few years. As the sales are increasing regularly, the total incomes get
beginning to enhance at the same period of time. It means that the Murano restaurant need to go
with this trend line estimation so that future opportunity can be created in maximum manner.
It has been analysed from the above trend line that the restaurant will be growing with
effective rate that represents that enough amount of fund is present with restaurant to start their
new restaurant. From the increasing trend, easily depicts that customers are satisfied with the
services of restaurant and they prefer to spend their time in the restaurant with family. This will
be considered as the beneficial situation for an restaurant to start one more new restaurant and
earn large amount of profits along with capturing huge market share.
3.3 Presentation for senior management
3.4 Formal business report for management
The Management
Murano Restaurant
Date: 26th March, 2018
10