Business Decision Making Report: Analysing Balti Palace Expansion Plan

This report delves into the business decision-making process, analyzing the expansion plan of Balti Palace. It begins with an introduction to decision-making and the factors involved in business growth. The report outlines a plan for collecting primary and secondary data, detailing survey methodologies, sampling frames, and a questionnaire designed to gather customer insights. It then proceeds to summarize and analyze the collected data, employing representative values, measures of dispersion, and statistical tools like quartiles and correlation coefficients. The use of spreadsheets for graphical representation and trend line creation to assist forecasting is also discussed. Furthermore, the report covers the creation of a business presentation and a formal business report. It concludes with an overview of information processing tools, project planning (including critical path determination), and the application of financial tools for decision-making, providing a comprehensive analysis of the business expansion plan.

BUSINESS DECISISON
MAKING

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
1.1 Create plan for the collection of primary and secondary data for Balti Palace.....................1
1.2 Present the survey methodology & sampling frame used.....................................................2
1.3 Questionnaire for given business problem............................................................................3
TASK 2............................................................................................................................................4
2.1 Information for decision making by summarising data using representative value..............4
2.2 Analyse the result to draw valid conclusion.........................................................................7
2.3 Analyse data measure of dispersion to inform given business scenario...............................8
2.4 Use of quartiles, percentiles and the correlation coefficient subject to draw useful
conclusion...................................................................................................................................8
TASK 3............................................................................................................................................9
3.1 Produce a graphs using spreadsheets and valid conclusion..................................................9
3.2 Create trend lines to assist forecasting for specified business information........................14
3.3 Business presentation Using suitable table and software and techniques to disseminate
information effectively..............................................................................................................14
3.4 Formal business report .......................................................................................................14
TASK 4..........................................................................................................................................15
4.1 Use of appropriate information processing tools................................................................15
4.2 Prepare a project plan for an activity and determine the critical path.................................16
4.3 Financial tools for decision making....................................................................................17
CONCLUSION..............................................................................................................................18
REFERENCES..............................................................................................................................19

INTRODUCTION
Business decision making is a process which helps to analyse business problems,
expansion plans and investment plans for better growth and development of organisation. This
report is prepared to analyse the business problem subject to analyse various complex business
situations (Yang, 2011). Business expansion plan of Balti Place is analysed with the help of
decision making process. Variety of sources for data collection by both primary and secondary
data are defined in this subject. Information which remain essential for effective decision making
process also illustrated in this context. Decision making process is summarised subject to
business problems. Use of software generated information for making business plans and
strategies in effective manner.
TASK 1
1.1 Create plan for the collection of primary and secondary data for Balti Palace
Business plans and investment proposals are analysed with the help of effective decision
making process which not only helps to understand and analyse the competitive analysis. There
is a business expansion plan is proposed subject to analyse effective business plans is discussed
with decision making process. Decisions which are take with the help of in depth analysis and
core study is called as decision making process (Tzeng and Huang, 2011). This not only build the
core competence and enhance the forecasting process but also increase the sustainability of
decision plans. Managers and executive committee of Balti palace wants to expand the business
size of Balti place there are type of data are required to analyse the business expansion proposal.
Various type of source of data are discussed below:
Primary data: these data are considered relevant and practical sources of collection of
data at initial stage. It remain essential for both the practical analysis and brief analysis of
subject. Primary data are gathered by connecting people and public directly or personal
interaction with people in order to determine the practical overview and relevant information.
Decision making process more realistic and practical with the help of primary sources of data
due to relevant information and figures.
Secondary data: these are the data which are collected by supporting sources and
information which remain associated with the subject and problem. Credibility and relevance of
information remain less effective in comparison to primary source of data. New papers, new
articles, journals, last year's financial informations and past business expansion reports are the
1

examples of secondary data resources. Collection of information through secondary data is cost
effective and time saving source.
Research: A deep study and analysis of particular subject which is required vast and
deep knowledge and skills are known as research. Research is done by experts and specialist to
critical analyse of subjects and evaluation of business problems. This contains huge amount of
investment for in depth research and analysis (Sethi and Zhang, 2012).
Questionnaire: this is an approach which is used to analyse and evaluate the perspective
and response of public by distributing set of questions. This approach will help managers of Balti
Palace to understand and analyse customer response subject to expansion plan.
1.2 Present the survey methodology & sampling frame used
Survey methodology is used to analyse the customer response and mindset of customers
and public for better investment plans and business proposals. As per above given scenario Balti
Palace wants to expand the business proposal further in UK. Managers want to get response and
perspective of customer subject to above business expansion plan (Saaty and Peniwati, 2013).
There are various research methodologies are defined for evaluating and measuring information
such as:
Sampling framing: this is type of methodology which is use to frame information and
data in adequate manner and effective manner. To get positive aspects and results only positive
aspects and assumptions are used under sampling framing. Not all the essential aspects are
covered under sampling framing but also some negative perspectives also taken to consideration
for rectification and improvement.
Random Sampling: Random sampling is used to get undefined and unspecified aspects
which are not selected subject to analyse business analysis which is to reduce the complexity and
reduce the burden of complex environment. This is one of the essential aspect which is
considered essential for better optimisation and effectiveness. There are some supportive
research techniques are used in random sampling such as quota, cluster and stratified sampling
techniques. This contains elements like affordable price for customers, quality services and
hospitality by staff members.
Qualitative and quantitative: this is a type of research which is used to proper
measurement and use of analysis in possible manner and way. This research methodology is
basically needs to analyse the research part with total collection and methodology.
2

Exploratory research: this is an approach used to explore the aspects which are analysed
to aim and objective of the essential methods and aspects which are considered to research
options. This research methodology usually used to get positive and nearest results for better
advancement and measurement of business problems (Routledge. Sinha and Labi, 2011).
Descriptive research: this is the research which include descriptive analysis and
evaluation of subject by presenting overall analysis and report for better advancement and report.
Not all the aspects are covered for better analysis expect practical and relevance figures.
1.3 Questionnaire for given business problem
Analysis of expansion plan for Food and Friends restaurant
QUESTIONNAIRE
Name:
Age:
Gender:
Occupation:
Q1: Are you happy with the concept of Business expansion plan of Blati Place ?
(a) Yes
(b) No
Q2: Whether this proposal would be able to attain consumer attraction?
(a) Yes
(b) No
(c) Neutral response
Q3: what is your thinking and mindset behind the pricing policy of Balti Palace?
(a) High
(b) Moderate
(c) Low
Q4: Major dishes you like most at Balti Palace restaurant?
(a) Chinese
(b) Thai
3

(c) Italian
(d) Other
Q5: What factors which attracts you towards Balti Palace?
(a) Multiple-cuisine
(b) Environment
(c) Hospitality
Q6: Is there are any changes and variations are required in new branch?
(a) Yes
(b) No
Q7: Is the quality standards of cookery satisfactory in Balti Palace?
(a) Yes
(b) No
Q8: Do you agree that Balti Palace is able to attract customers?
(a) Yes
(b) No
(c) Neutral response
Q9: Suggest the locations at which base of new branch can be situated?
(a) Country side
(b) Prime location
(c) Shopping Mall
(d) Other
Q10: Please provide views, suggestions and feedbacks in respect of proposed plans?
Ans.
TASK 2
2.1 Information for decision making by summarising data using representative value
Q1: Are you happy with the concept of Business expansion plan of Blati Place ?
Particular Respondent in %
(a): Yes 65
(b): No 15
4

Total 80
Mean 40
Median 40
Mode 5
Q2: Whether this proposal would be able to attain consumer attraction?
Particular Respondent in %
(a): Yes 55
(b): No 10
(c): Neutral Response 5
Total 80
Mean 23.33
Median 10
Mode 0
Q3: what is your thinking and mindset behind the pricing policy of Balti Palace?
Particular Respondent in %
(a): High 15
(b): Moderate 50
(c): Low 15
Total 80
Mean 26.67
Median 15
Mode 0
Q4: Major dishes you like most at Balti Palace restaurant?
Particular Respondent in %
(a): Italian 35
(b): Chinese 38
(c): Thai 5
(d): Other 2
5

Total 80
Mean 20
Median 20
Mode 1
Q5: What factors which attracts you towards Balti Palace?
Particular Respondent in %
(a): Environment 27
(b): Multi cuisine 33
(c): Hospitality 20
Total 80
Mean 26.66
Median 27
Mode 7
Q6: Is there are any changes and variations are required in new branch?
Particular Respondent in %
Yes 32
No 48
Total 80
Mean 40
Median 40
Mode 32
Q7: Is the quality standards of cookery satisfactory in Balti Palace?
Particular Respondent in %
Yes 62
No 18
Total 80
Mean 40
Median 40
6

Mode 8
Q8: Do you agree that Balti Palace is able to attract customers?
Particular Respondent in %
(a): Yes 58
(b): No 19
(c): Neutral response 3
Total 80
Mean 26.66
Median 19
Mode 1
Q9: Suggest the locations at which base of new branch can be situated?
Particular
Respondent
in %
Country side 24
Shopping mall 18
Prime location 16
Other 22
Total 80
Mean 20
Median 20
Mode 2
2.2 Analyse the result to draw valid conclusion
Results are analysed with the help of analysis of last year's income and profit results. Last
years' sales and profit results of Balti Palace are determined subject to sustainability of business
expansion plan.
Year Sales (£) Net Profit (£)
2008 4500 2500
2009 5640 2540
7

2010 3445 2650
2011 4700 1145
2012 5800 3600
2013 2480 1250
2014 3455 1560
2015 1245 860
2016 3650 1250
2017 3350 2150
Mean 3826.5 1950.5
Median 3552.5 1855
Mode 1150 350
Mean: it is considered as an average value which is calculated by dividing number of
objects with total number of aspects. In above context mean is calculated in respect of determine
average sales records and average profit records. This is one of the essential parts subject to
analyse average records in respect of sales. Mean for sales is calculated as 3826.5 and profit is
calculated as 1950.5
Mean: ∑X/N
Median: this tools is basically used to calculate information and details related to same
aspects and mean values which remain associated with effective management decision. It
majorly define the relation between upper and lower range values which remain associated with
subject. Median for the above analysis is calculated as 3552.5 in respect of sales and 1855 in
respect of profit (Mean, Median, Mode and Range. 2017).
Median: [L1 + (N/2) – c/F*i]
Mode: Mode is the value which is calculated as various type of factors and analysis. The
is the set of data and values which is the value of most often repetitive value. It defines the
frequency of values in which most profitable results are shown in consequent manner. As per
above given business scenario mode is calculated as 1150 in respect of sales and 350 for profit.
Mode: L + h ( fm – f1 / 2fm – f1 - f2 )
2.3 Analyse data measure of dispersion to inform given business scenario
Year Sales (£) Net Profit (£)
2008 4500 2500
8

2009 5640 2540
2010 3445 2650
2011 4700 1145
2012 5800 3600
2013 2480 1250
2014 3455 1560
2015 1245 860
2016 3650 1250
2017 3350 2150
Minimum range 1245 860
Maximum range 5800 3600
Standard deviation 813.17 247.4873734153
Correlation coefficient 0.6997898693
Range: It is related with all those variations among upper and lower limitation on a
specific scale of operations. This will assist in determining perfect relationship among two
variables. It would consider two aspects minimum range and maximum range among two
variables.
Standard Deviation: It is an effective measure that can determine total spread out of
total sales and net profit generated by the restaurant during the time. It is use to measure the
dispersion in a given data series. The standard deviation collected from sales and net profit is 813
and 247 respectively.
Variances: In case of probability and number data the expectation of the squared
deviation of a random variables collected out of total mean. It is used to measure total set of
numbers spread out from their average value (Rothman, 2017).
2.4 Use of quartiles, percentiles and the correlation coefficient subject to draw useful conclusion
Quartile: It is known as one of the statistical term which used to describe proper division
about total observation into four equal groups. It is done to make compare the entire set of data
collected from overall research process. This would divide any of the three values that divide the
items of overall frequency distribution into Q1, Q2, Q3 and Q4.
9

Percentile: It refers as total number of 100 equal set of groups into a given populations
which can segment according to the data distribution of values in a specific set of variables. This
will indicate total percentage that is falls below percentile range. This would represent total
percentage in list of data series. It would be determine a given value through smaller than that
particular value.
Correlation coefficient: This particular methods is said to correlation defined the
consequent values subject to reliability and linear interdependence of two variables. This is one
of the statistical measures of the degree to which changes to values are defined in single format
and variable predictions are implied (Cosgrove and Rijsberman, 2014).
TASK 3
3.1 Produce a graphs using spreadsheets and valid conclusion
Q1: Are you happy with the concept of Business expansion plan of Blati Place?
Q2: Whether this proposal would be able to attain consumer attraction?
10
(a): Yes (b): No
0
10
20
30
40
50
60
70 65
15
Column D

Q3: what is your thinking and mindset behind the pricing policy of Balti Palace?
Q4: Major dishes you like most at Balti Palace restaurant?
11
(a): Yes (b): No (c): Neutral Response
0
10
20
30
40
50
60 55
10
5
Respondent in %
15
50
15
(a): High
(b): Moderate
(c): Low

Q5: What factors which attracts you towards Balti Palace?
12
35
38
5
2
(a): Italian
(b): Chinese
(c): Thai
(d): Other
27
33
20
(a): Environment
(b): Multi cuisine
(c): Hospitality

Q6: Is there are any changes and variations are required in new branch?
Q7: Is the quality standards of cookery satisfactory in Balti Palace?
13
Yes No
0
10
20
30
40
50
60
32
48
Respondent in %
Yes No
0
10
20
30
40
50
60
70
62
18
Respondent in %

Q8: Do you agree that Balti Palace is able to attract customers?
Q9: Suggest the locations at which base of new branch can be situated?
14
58
19
3
(a): Yes
(b): No
(c): Neutral response
24
18
16
22
Country side
Shopping mall
Prime location
Other

3.2 Create trend lines to assist forecasting for specified business information
Year Sales (£) Net Profit (£)
2013 2480 1250
2014 3455 1560
2015 1245 860
2016 3650 1250
2017 3350 2150
15
1 2 3 4 5
0
500
1000
1500
2000
2500
3000
3500
4000
2013 2014 2015 2016 2017
2480
3455
1245
3650
3350
1250
1560
860
1250
2150 Year
Sales (£)
Net Profit (£)

3.3 Business presentation Using suitable table and software and techniques to disseminate
information effectively
3.4 Formal business report
REPORT
TO,
The Manager of Balti palace restaurant
Date: 15th April, 2018
Subject: “Evaluation of feedback and reviews of customers about expansion of business
into London Market”.
Introduction
This particular report is prepare by using various data that are collected during the
overall survey of the Balti palace restaurant. The expansion planning was proposed by the
managers is subject to exploration of restaurant scope in London. There are some effective data
evaluation which is being collected during the time.
Methodologies
Under this particular research various types of methods are being used. Such as
descriptive and quantitative. There are certain valuable facts and data that are gathered with the
help of useful methods.
Finding
After making proper analysis of all collected data, it has been found that plenty of
customers are provided positive responses in respect to opening of new restaurant in their
localities. With total of 80 respondents, there positive aspects are taken into considered to deal
with all issues that are coming in accordance with travelling into their nearest possible
restaurant.
Recommendation
out of all data collected analysis, it has been suggested that proper health and caring
aspects would be provided to various customers those are visiting to that particular restaurant. It
has been needed that management will need to pay proper attention towards the total services
and quality deliver into the restaurant.
Conclusion
From the above report, it has been concluded that there are certain positive and negative
16

aspects that are being faced during the time of research. But the opening decision related with
Balti palace restaurant is more suitable in London according to their view point of various
customers.
TASK 4
4.1 Use of appropriate information processing tools
There are many information processing tools which is used by Balti palace to improve
their communication channels. It provides the opportunity regarding development of every
aspect from operation to management level. Functions of such different kind of tools are defined
below:
Decision support system: The main aim behind implementation of this system is to take
support in decision making process. This will improves their overall efficiency of working
(Pourshahid, Richards and Amyot, 2011).
Transaction processing system: This system is used by the management of Balti palace
is to store the information regarding every aspect which happens on regular basis. It helps
regarding retrieval of important information on timely basis (Nooraie, 2012).
Management information system: The main function of this system is to provide the
information of every level which prevails in restaurant. This information is further used by the
management of restaurant regarding formulation of strategies to direct the employees for
performance of wok in more accurate and timely manner.
17

4.2 Prepare a project plan for an activity and determine the critical path
18

4.3 Financial tools for decision making
NPV: It is called as Net present value. It is financial tool which is used for effective
decision making regarding selection of most profitable project. The calculation presents the
information regarding time period which is required to recover their investment from
performance of particular project (Levy, Weitz and Grewal, 2012).
IRR: It is known as internal rate of return. This provides the information about return which
getting from project. Helps in determination of profitability of project (Kacprzyk and Fedrizzi,
2012).
Particular Project Discounting factor Discounted cash inflow
Year Cash Flow 12.00% Present Value
0 -190000 1 -190000
1 50000 0.893 44645
2 64000 0.797 51020.8
3 58000 0.712 41284.4
4 70000 0.636 44485
Total P.V 181435.2
Initial
investment
of year -190000
NPV -8564.8
19

IRR 9.94%
CONCLUSION
This report is prepared to analyse the business decision making process to examine and
elaborate the dimensions of business for better growth. Various type of sources for the collection
of data such as primary and secondary are defined in this context. Techniques which are used to
analyse data effectively for business purpose defined in in this context. Information is presented
in appropriate format for decision making in organisational context is also elaborated in this
context. Use of software generated information is used for effective decision making process
illustrated subject to business growth and development.
20