Balti Palace: Data Analysis and Report for Business Decisions

This report analyzes the data collected for Balti Palace, a restaurant chain, to assess the viability of opening a new branch in London. The report begins with an introduction outlining the need for data-driven decision-making and the use of primary and secondary data collection methods. Task 1 focuses on primary and secondary data sources, survey methodologies, and questionnaire design. Task 2 covers the creation of information for decision-making using representative values, drawing conclusions from research, evaluating measures of dispersion, and the advantages of using quartiles, percentiles, and correlation coefficients. Task 3 involves the formulation of charts, graphs, and trend lines to interpret information and prepare a formal report. Task 4 addresses the application of information processing and financial tools for decision-making, including project planning and critical path determination. The report uses questionnaires to gather data on customer satisfaction, preferences, and opinions regarding the expansion plan. Statistical tools such as mean, median, and mode are used to analyze the collected data and draw conclusions. The report aims to provide insights and recommendations for Balti Palace's expansion strategy.

BDM

Table of Contents
INTRODUCTION...........................................................................................................................3
TASK 1............................................................................................................................................3
1.1: Primary and secondary sources of data collection..........................................................3
1.2: Survey methodologies and designing of sampling framework.......................................4
1.3: Designing of Questionnaire.............................................................................................5
TASK 2............................................................................................................................................7
2.1: Creation of information for decision making with the help of representative values.....7
2.2: Draw valid conclusions from the information collected from research........................11
2.3: Evaluating measure of dispersion..................................................................................12
2.4: Advantages of using quartile, percentile and coefficient correlation............................13
TASK 3..........................................................................................................................................13
3.1: Formulation of charts and graphs to interpret information...........................................13
3.2: Formulation of Trend line.............................................................................................19
3.3: Covered in PPT.............................................................................................................20
3.4: Preparation of Formal report.........................................................................................20
TASK 4..........................................................................................................................................21
4.1: Application of information processing tools for decision-making................................21
4.2: Preparation of project plan to determine Critical path..................................................22
4.3: Application of financial tools for improvement of decision making............................23
CONCLUSION..............................................................................................................................23
REFERENCES..............................................................................................................................25

INTRODUCTION
To improve decision making power manager of organisation is need to collect the
information from the market and respondents. It provides the opportunity to draw important
conclusions which contributes in attaining sustainability in their operations. There are many
statistical tools like mean, median and mode which helps to attain results in quantitative terms.
The best method which helps to collect true and reliable information is primary method. It
provides the opportunity to grab the real views of respondents. Balti palace is restaurant which
provides their services in UK (Cosgrove and Rijsberman, 2014).
In the present report explain about, use of primary and secondary sources to attain the
view of respondents, formulation of research framework, designing of questionnaire, draw
important conclusions with the help of statistical tools and measures of dispersion and
application of quartiles, percentiles and correlation coefficient to interpret information. Also,
formulation of graphs using spreadsheets, formulation of trend lines to forecast business
information and application of information processing and financial tools to improve decision-
making.
TASK 1
1.1: Primary and secondary sources of data collection
The main objective of Balti palace is attain sustainability in their business operations and
open new branch of their restaurant in London. Large number of cuisines are provided like
Italian, Thai etc. which helps in attraction of the large number of customers and improves their
sales and net profit. Research is the important technique which helps to check the viability of
their growth plan through ascertaining the views of respondents. This includes the application of
two methods like primary and secondary source of data collection.
Primary source
The information which is gathered with the use of this method is unbiased because it
directly received from respondents. So, there is less chance of manipulation. All the information
which is collected is related to research topic. It means reliable and accurate which is most
appropriate to draw important conclusions. The different aspects which are included in primary
sources are historical and legal documents, statistical data, speeches etc. The different methods
which are considered under this are Questionnaire, survey, online etc.

 Questionnaire: It is a list of survey questions which is asked to different respondents
selected from total population to extract desired information. Open-ended questionnaire
is much more appropriate which provides the chance to respondents to provide their
feedbacks in answer. Close-ended questionnaire is attached with multiple answer from
which one is selected (Kacprzyk and Fedrizzi, 2012).
 Survey: This includes face to face conversation with respondents. It helps to collect the
information from their gestures and behaviours also. It takes more time to collect
information in comparison to the method of questionnaire.
 Online: It includes the collection of data through use the source of internet. Under this,
social media research helps to provide insight about the behaviour of consumer and
particular segments of society. This method helps to save the time and money.
Secondary source
It helps in collection of data which already published somewhere. Such different sources
are newspapers, articles, magazines etc. For research purpose, this method is not optimum
because the information is not relevant to research objectives and out dated. It does not helps to
grab the actual views of respondents. One of the major advantage of this method that it saves the
time and money of researcher (Nooraie, 2012).
1.2: Survey methodologies and designing of sampling framework
There are different methods of research are available from which best is select by
researcher as per their requirement. In present case, research objective is to attain the views of
respondents about the expansion of Balti palace in London. Many kind of informations also
gathered which helps to accomplish their objective like customer's satisfaction, quality of current
services and food, factors which are present in business environment, competitors etc. On the
basis of such information future plans are formulated which directs the employees to effectively
provide their functions.
Research methodologies: Primary and secondary are two methods which helps to
conduct the research. Both the methods have their different usage and advantages. Primary
method helps in collection of real opinions and secondary method helps to gather different
information from the market. In present case, management of Balti palace uses primary method
of data collection which helps to collect real and accurate information. There are many methods
which comes under primary method like survey, questionnaire, online etc. One of the best

method which is used is questionnaire. Close-ended questionnaire is formulate which contains 10
different questions asked from respondents.
Sample framework: It is the process outlining of research work which helps to carry their
activities in more appropriate manner. Under the process of designing framework need of
selection of respondents from total population is identifies to get the results in stipulated period
of time. The different methods which contributes in selection of respondents are cluster,
stratifies, random sampling etc. Researcher of Balti palace used random sampling method to
select 80 respondents (Pourshahid, Richards and Amyot, 2011).
The process of collection of information starts with the mailing of questionnaire to all 80
respondents which returned by them after selection of one option as answer. Such informations
are interpreted with the help of different statistical tools and method of measures of dispersion.
The questions covered such objectives:
 Viability of move to open new branch in London
 Quality of current services
 Current position in market
1.3: Designing of Questionnaire
Questionnaire: It is a document which includes set of questions regarding their
objectives and issues to ascertain the views of respondents. The main purposes of preparing
questionnaire are:
 Collection of information
 Comparison of data to interpret important conclusions
 Attaining unbiased information
 Collect information about different aspects
In the present report, close-ended questionnaire is prepared which includes different
options with questions from which respondents have to select their answer. It provides the
opportunity to attain accurate and reliable information.
Questionnaire
Name:
Gender:
Occupation:

Age:
Q1. Opening of another branch of restaurant in London is viable for Balti palace?
 Yes
 No
Q2. Does expansion plan of Balti palace help in attraction of large number of customers?
 Yes
 No
 Cant say
Q3. Do you satisfied with the prices charged by the management of Balti palace?
 Highly satisfied
 Satisfactory
 Dissatisfied
Q4. How often you visit balti palace?
 Once in a month
 Twice in a month
 More than four times
Q5. What cuisine you like in Balti palace?
 Seafood
 Italian
 Thai
Q6. What attracts you most towards Balti palace?
 Surroundings
 Fast services
 Different dishes
Q7. Are you satisfied with the quality of food items?
 Highly satisfied
 Satisfactory
 Dissatisfied
Q8. Which place you prefer to see the new branch of Balti palace in London?
 Prime location
 Countryside

 At popular tourist destination
Q9. Does opening of new branch helps Balti palace to capture large market share?
 Yes
 No
 Cant say
Q10. What you want suggest to the management of Balti palace?
TASK 2
2.1: Creation of information for decision making with the help of representative values
Q1. Opening of another branch of restaurant in London is viable for Balti palace?
Particulars
No. of
respondents
Yes 65
No 15
Total 80
Mean 40
Median 40
Mode 5
Q2. Does expansion plan of Balti palace help in attraction of large number of customers?
Particulars
No. of
respondents
Yes 45
No 20
Can’t say 15
Total 80
Mean 26.6666666

667
Median 20
Mode 0
Q3. Do you satisfied with the prices charged by the management of Balti palace?
Particulars
No. of
respondents
Highly
satisfied 25
Satisfactory 35
Dissatisfied 20
Total 80
Mean
26.6666666
667
Median 25
Mode 5
Q4. How often you visit balti palace?
Particulars
No. of
respondents
Once in a
month 42
Twice in a
month 28
More than
four times 10
Total 80
Mean
26.6666666
667
Median 28
Mode 2
Q5. What cuisine you like in Balti palace?

Particulars
No. of
respondents
Seafood 22
Italian 38
Thai 20
Total 80
Mean
26.6666666
667
Median 22
Mode 2
Q6. What attracts you most towards Balti palace?
Particulars
No. of
respondents
Surrounding
s 20
Fast services 25
Different
dishes 35
Total 80
Mean
26.6666666
667
Median 25
Mode 20
Q7. Are you satisfied with the quality of food items?
Particulars
No. of
respondents
Highly
satisfied 28
Satisfactory 42
Dissatisfied 10

Total 80
Mean
26.6666666
667
Median 28
Mode 8
Q8. Which place you prefer to see the new branch of Balti palace in London?
Particulars
No. of
respondents
Prime
location 36
Countryside 12
At popular
tourist
destination 32
Total 80
Mean
26.6666666
667
Median 32
Mode 4
Q9. Does opening of new branch helps Balti palace to capture large market share?
Particulars
No. of
respondents
Yes 39
No 23
Cant say 18
Total 80
Mean
26.6666666
667
Median 23
Mode 3

2.2: Draw valid conclusions from the information collected from research
YEAR Sales Net Profit
2008 5125 1725
2009 5250 1856
2010 5480 1936
2011 5575 1968
2012 5700 1992
2013 5810 2025
2014 5890 2073
2015 5965 2125
2016 6025 2195
2017 6225 2210
Mean 5704.5 2010.5
Median 5755 2008.5
Mode 5125 1725
Mean: It is the process of calculation of average of the data which is present in given
series. The mean of sales and net profit is 5704.5 and 2010.5.
Median: This method is used to ascertain the middle value of the figures present in given
series of sales and net profit. It is calculated as 5755 and 2008.5.
Mode: It shows the figure which comes most number of time in a series. Mode of sales
and net profit is 5125 and 1725 (Rothman, 2017).
2.3: Evaluating measure of dispersion
YEAR Sales Net Profit
2008 5125 1725
2009 5250 1856
2010 5480 1936
2011 5575 1968
2012 5700 1992

2013 5810 2025
2014 5890 2073
2015 5965 2125
2016 6025 2195
2017 6225 2210
Minimum 5125 1725
Maximum 6225 2210
Standard
deviation
349.065816
7802
150.608580
2484
Correlation
coefficient
0.98045387
56
Standard deviation: It helps to assess the risk which is associated with project. It
improves decision making power. It is calculated for sales and net profit as 349.0658167802
and150.6085802484 (Saaty and Peniwati, 2013).
Range: Two kinds of range are available which are called minimum and maximum.
Comparison of both limits helps to know important results. Minimum range of sales and net
profit as 5125 and 1725. Maximum range of sales and net profit as 6225 and 2210.
2.4: Advantages of using quartile, percentile and coefficient correlation
Quartiles: It is a range. It is divided into three parts called as Q1, Q2 and Q3. It used to
compare mean and median differences. It is observed that they play a huge role in the process of
benchmarking. This will assist the employees of organisation is to design their workings
according to such standards to achieve overall objectives.
Percentiles: It is the method helps in conversion of results into percentage form which is
easy to compare (Sethi and Zhang, 2012). This will improve the comparison ability of
management with their past performances and ascertain the information regarding current
position of organisation. This will improve decision making of organisation.
Correlation coefficient: This method shows the relationship between two variables. The
results are called good if come between the limit of 1 to -1. This will provides the opportunity
regarding assessment of the relation between two variables and also their impact on each other.

This will enables the organisation is to provide their functions in such way that maximum
benefits are derived.
TASK 3
3.1: Formulation of charts and graphs to interpret information
Q1. Opening of another branch of restaurant in
London is viable for Balti palace?
Frequency
Yes 65
No 15
Yes No
0
10
20
30
40
50
60
70 65
15
Column B
Q2. Does expansion plan of Balti palace help
in attraction of large number of customers?
Frequency
Yes 45
No 20
Cant say 15

45
20
15
Yes
No
Cant say
Q3. Do you satisfied with the prices charged
by the management of Balti palace?
Frequency
Highly satisfied 25
Satisfactory 35
Dissatisfied 20
25
35
20
Highly satisfied
Satisfactory
Dissatisfied
Q4. How often you visit balti palace? Frequency
Once in a month 42

Twice in a month 28
More than four times 10
Once in a month Twice in a month More than four times
0
5
10
15
20
25
30
35
40
45 42
28
10
Column B
Q5. What cuisine you like in Balti palace? Frequency
Seafood 22
Italian 38
Thai 20

Seafood Italian Thai
0
5
10
15
20
25
30
35
40
22
38
20
Column B
Q6. What attracts you most towards Balti
palace?
Frequency
Surroundings 20
Fast services 25
Different dishes 35
20
25
35 Surroundings
Fast services
Different dishes
Q7. Are you satisfied with the quality of food
items?
Frequency
Highly satisfied 28

Satisfactory 42
Dissatisfied 10
Highly satisfied Satisfactory Dissatisfied
0
5
10
15
20
25
30
35
40
45
28
42
10
Column B
Q8. Which place you prefer to see the new
branch of Balti palace in London?
Frequency
Prime location 36
Countryside 12
At popular tourist destination 32

36
12
32 Prime location
Countryside
At popular tourist
destination
Q9. Does opening of new branch helps Balti
palace to capture large market share?
Frequency
Yes 39
No 23
Cant say 18
Yes No Cant say
0
5
10
15
20
25
30
35
40
45
39
23
18 Column B
3.2: Formulation of Trend line
Trend line: It a line which is drawn over the highest and lowest points to show the
direction. Such lines helps to understand about the future trend and growth of different aspects

aspects. In the present case, trend lines are drawn over highest points of sales and net profit. It
helps to forecast their future activities and profitability which is going to earn from business
operations (Shapiro and Stefkovich, 2016).
Year Sales Net Profit
2017 6225 2210
2018 7150 2560
2019 8240 2950
2020 9110 3100
1 2 3 4
0
1000
2000
3000
4000
5000
6000
7000
8000
9000
10000
2017 2018 2019 2020
6225
7150
8240
9110
2210 2560 2950 3100
Column A
Linear (Column A)
Column B
Linear (Column B)
Column C
Linear (Column C)
From the above trend line graph, it is observed that sales and net profit figures of Balti
palace is increase continuously in future years. In 2017, the figure of sales is 6225 which is
continuously increase and in 2020 it will reaches towards 9110. On other hand, in 2017 net profit
is 2210 which will reached in 2020 towards 3100. This showed that Balti palace from their
business operations earns large number of profits. It means that customer's are satisfied with their
existing services and having sufficient amount of funds which is used further to open new branch
in London (Sinha and Labi, 2011).
3.3: Covered in PPT
3.4: Preparation of Formal report
Report

To,
The Manager
Date: 18th April 2018
Subject: Ascertain the views of customer's about opening of new branch of Balti palace in
London
Methodologies
As per above analysis there is a research methodology used by organisation to collect different
kind of informations to accomplish the objective of Balti palace. Through this large number of
benefits are gathered by the management like informed decision-making, better customer
satisfaction, attraction of large number of customers etc. one of the best is used for ascertaining
the views of respondents which is known as primary method of data collection. To effectively
conduct research close-ended questionnaire is used which helps to attains the views on different
research topics. For selection of respondents from total population random sampling method is
used which makes the process of research more precise and effective which provides better
results. Through random sampling method, 80 respondents are selected to whom such
questionnaire is mailed.
Findings
From the process of research the data which is received provides the information regarding
preferences of customers, their views about current services, dish which they like most in Balti
palace etc. To draw important conclusions different statistical methods are used like mean,
median and mode. It helps in attainment of the results in quantitative terms which are easy to
comparable. Trend line provides success of Balti palace in future. It I observed that, Balti palace
has good sales and revenue figures which customers are satisfied from their services.
Conclusion
It has been concluded from the above report, current position of Balti palace is good in market.
This will provides that it is the good move to open new branch in London. It helps in
satisfaction of their different demands of customers and capture large market share.

TASK 4
4.1: Application of information processing tools for decision-making
Information processing means the disbursement of information with the help of different
tools like DSS, TIS and MIS. It provides the opportunity regarding maintenance of effective
communication and coordination among the different staff members of various teams (Tzeng,
and Huang, 2011). It is used by the management of Balti palace to effectively manage their
material and other informations to make their business operations more profitable. In this regard,
contribution of different tools is mentioned below:
 Management information system: It is the process of generation of information from
computers of other intelligent devices. It helps to provides the regular report upon the
operations which are conduct at every level in restaurant. Manager of Balti palace used
this system to generate special reports which improves their decision making to improve
their decision-making.
 Decision support system: It is a application which helps in evaluation of the different
information which helps to make their difficult decisions more easily. It is used by
manager of Balti palace to solve the issues and problems which are faced in real.
 Transactional processing system: It is the system which performs different functions
like collect, store, modify and retrieval of important data. It provides the opportunity to
the management of Balti palace to attain important results which is used further to gain
higher profits (Xu, 2015.).
4.2: Preparation of project plan to determine Critical path
Critical path: It is important method which provides the information regarding time
period which is needed to complete the whole project. It shows the information about the longest
sequences which are present in project which should be complete on time to accomplish their
objectives. If such long paths are not achieved within stipulated period of time then the whole
project is delayed and impacts the efficiency of project.

Path A: 1+4+7+8 = 10Days
Path B: 1+2+5+6+8 = 15 Days
Path C: 1+2+3+7+8 = 17 Days
It is interpreted from the above information that path c takes the longest period of time to
complete. So, as per critical path method management of Balti palace is need to complete path c
first. It helps them to complete their whole project within given period of time.
4.3: Application of financial tools for improvement of decision making
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
IRR 9.94%