Business Decision Making Report: Analysis of Balti Palace Performance

This report provides a comprehensive analysis of business decision-making processes, focusing on a case study involving Balti Palace. It begins with an introduction to the role of business and the influence of external markets. The report covers the creation of data collection plans, including primary and secondary data methods, survey methodologies, and questionnaire design. It delves into data analysis, using representative values, measures of dispersion, and correlation coefficients to draw conclusions. The report also includes the production of graphs and trend lines using spreadsheets, along with a business presentation and formal report preparation. Furthermore, it explores the use of information tools, project planning (including critical path analysis), and financial tools for decision-making, such as NPV and IRR, to assess project feasibility. The report concludes with a summary of findings and provides references.

BUSINESS DECISION
MAKING

Table of Contents
INTRODUCTION...........................................................................................................................3
TASK 1............................................................................................................................................4
1.1 Create a plan for the collection of primary and secondary data for a given business
problem........................................................................................................................................4
1.2 Present the survey methodology and sampling frame...........................................................4
1.3 Design a questionnaire for a given business problem............................................................5
TASK 2............................................................................................................................................7
2.1 create information for decision making by summarizing data using representative values. .7
2.2 Analyze the results to draw valid conclusions in a business context.....................................8
2.3 Analyse data using measures of dispersion to inform a given business scenario..................8
2.4 Explain how Quartile, percentiles and the correlation coefficient are used..........................9
TASK 3..........................................................................................................................................10
3.1 Produce graphs using spreadsheets......................................................................................10
3.2 Create trend lines in spreadsheet graphs to assist in forecasting.........................................13
3.3 Prepare a business presentation...........................................................................................13
3.4 Produce a formal business report.........................................................................................13
TASK 4..........................................................................................................................................14
4.1 Use of information tools......................................................................................................14
4.2 Prepare a project plan for an activity and determine the critical path.................................15
4.3 Use financial tools for decision making..............................................................................16
CONCLUSION..............................................................................................................................18
REFERENCES..............................................................................................................................20

INTRODUCTION
Role of business has increases with the influence of external market on the business
which enhances its overall skills and the capabilities. Balti palace has been selected by an entity
in order to use various decision making tools to enhance the current skills and the capabilities of
an entity in order to make important decisions business. This project is all about creating data
collection plan which helps in organizing a research study in order to help an entity owner to
collect important facts and figures to accomplish desired aims and the objectives within a given
time frame. This project report also emphasis on using appropriate sampling method that helps in
collecting important facts and figures in order to achieve the desired aims and the objectives
within a given time frame. The reliability of the collected information will be based on the
method used by an individual so it is important to select appropriate among which gives right
direction to an individual. Sample size will be adopted to facilitate the researcher in order to
collect important facts related to the current aim of the overall research project report.
Questionnaires are used to circulate among various individuals to take their consent about the
consumer's satisfaction an entity gains by delivering all its products or services to all the
consumers of the Balti palace. This report is all about using statistical measures like mean,
median and mode in order to test the reliability of the information that may affect the overall
business performance of an entity in order to grab higher market opportunities located in the
external market. Graphs and charts are used to present al the information about the business in
order to take important action in the business as it is essential for an entity in order to gab higher
market advantage by offering variety of services to is variety of users located in the external
business environment. Different use of information technologies used in the business in
improving various business functions of the business in an enterprise using important tools and
techniques. The project will be managed using appropriate project management tool by
determining critical path analysis and Gantt charts. Capital budgeting tool is used to analyze the
feasibility and viability of all the projects taken into consideration such as NPV and IRR.

TASK 1
1.1 Create a plan for the collection of primary and secondary data for a given business problem
Primary collection of data- Primary research is regarded as one of the important method used
by an individual in order to collect reliable information relate to the current research based on
accomplishing the desired aims of the overall research study. In this particular approach
personally counselor is appointed in order to conduct study to gather important information to
support the overall study aims and the objectives. In this approach the information is collected
from the real source as higher reliability of the information (Hwang and Yoon, 2012). True facts
and figures collected y an individual in order to accomplish all the desired aim's ad targets as this
helps in improving higher business performance within a given time frame. Questionnaire is
essential source of primary collection of data that helps an individual in order to circulate among
different consumers exists in the local environment. The respondents for the given research
study is all the consumers as the current research study is conducting to know the consent of all
the consumers towards the products or services of the Balti palace. The personal appointed
especially for the current research preferences.
Secondary collection of data- The secondary research study will be conducted by an entity in
which facts and figures will be gathered to the external source as the nature of research specific
research will determine the use of different techniques. In secondary research methods journals,
books and magazine articles are used to collect information about the current market trends, tasts
and preferences of various customers.
1.2 Present the survey methodology and sampling frame
Various research methodologies will be adopted by an individual in order to collect
important information to conclude overall research study in order to accomplish desired aims and
targets of an entity (Craft, 2013). Primary research collected by an individual to determine the
actual performance of an entity in front of various customers located in the external market.
Sampling technique is used by an individual in which few samples are selected out of the
total population in order to generate true and reliable facts relate to the current business study
whose major objective is on getting higher level of customer satisfaction.

Random sampling will be adopted in which samples are selected randomly out of the total
popularization or unversed which assures an entity to get reliable samples out of the total
population. 50 Samples are selected to know the tastes and preferences of various customers in
order to ensure higher productivity of Balti palace whose income is highly related to the needs
and higher expectations of various customers.
1.3 Design a questionnaire for a given business problem
QUESTIONNAIRE
Name-
Gender
Male
Female
Transgender
How old are you?
18-25 years old
25-35 years old
35-45 years old
45 years and above
What is your occupation out of the given below categories?
Student
Self-employed
Salaried professional
How much do you earn in a month?
£3000-£8000
£8000-£15000
£15000-£25000
How often you visit Balti Palace restaurant?
Once in a week
2 times in month
Rarely
How much do you spend on your first purchase in Balti Palace?
£60-£100
£100-£200
£250-£500

What are the factors helps you while going to restaurants?
Price
Ambiance
Quality of food
Tastes of food
Variety of cuisines
Payment method
Amenities
What do you say about affordable pricing of Balti palace?
Good
Nice
Bad
Which theme of Balti palace mesmerize customers due to their overall ambiance?
Eco- friendly theme
Garden tables
Open space used
How much do you rank the taste of food served at Balti Palace?
 1-3
 3-5
 5-7
What are different cuisines you find in the restaurant of Balti palace?
 Chinese
 Continental
 Mexican
 Indian
 Thai
What kind of payment method offered by the owner of Balti palace to facilitate their customers?
 Cash

 Debit cards
 Credit cards
 Mobile money transfer
What kind of amenities given by Balti palace to its various customers?
 Friendly environment
 Proper hygienic measures
 Discounts and coupons
 Free parking area
 Child play area
 Rest and waiting room
 Mobile booking of tables
Please provide your suggestions to improve the services of the Balti palace-_____________
TASK 2
2.1 create information for decision making by summarizing data using representative
values
Year Sales Profit
2011 700 245
2012 800 280
2013 675 236
2014 887 310
2015 985 345
2016 1010 354
2017 1500 525
Mean 936.71 327.85
Median 887 310

2.2 Analyze the results to draw valid conclusions in a business context
Mean- It is one the important technique of measures of central tendency in which overall data set
will be sum up in order to determine the average of data set (Boulay et.al., 2015). The mean of
the sales is higher and standard deviation of profit is less which shows the overall performance of
an entity.
Median- Median is that technique which divides the overall data set two equal parts which sows
the consistency of sales and profit to be incurred minimum amount of values generated by the
business. The median value of sales is higher than compared to the values generated by the
business from the profit is less than compared to the overall value of the sales.
Mode- Mode shows the re-occurrence value in the data set which shows the consistency to be
maintained by generating same kind of sales over the period for the betterment of the business.
In the current case there are values of mode.
2.3 Analyse data using measures of dispersion to inform a given business scenario
Year Sales Profit
2011 700 245
2012 800 280
2013 675 236
2014 887 310
2015 985 345
2016 1010 354
2017 1500 525
Standard deviation 280 98
Variance (S^2) = ∑Fx2 – ((∑Fx)2 /n)/ n – 1
Standard deviation = √ Variance
Interpretation
Standard deviation shows the variation among the variables included for the analysis
purpose which shows the closeness with the means values of overall data set (Hwang and Yoon,

2012). In the given case, the standard deviation of sales and the profit is differed from each other
as all these values are lower than the mean value.
2.4 Explain how Quartile, percentiles and the correlation coefficient are used
Percentile Sales Profit
25.00% 750 263
50.00% 887 310
75.00% 997.5 349
Inter-quartile range
IQR= Q3-Q1
Sales
= 997.5-750= 247.5
Profit
= 349-263 = 86
Sales (Units) Discounts (%)
20 1
40 4
50 6
55 6
60 10
70 12
80 13
90 14
100 15
Particulars Sales (Units) Discounts (%)
Sales (in Units) 1 0.97
Discounts (%) 0.97 1

Interpretation
There is Strong relationship between two important variables such as sales and discount
which plays significant role in the business in increasing or decreasing value of sales currently
generated by an entity in a particular period.
TASK 3
3.1 Produce graphs using spreadsheets
2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
0
2000
4000
6000
Advertisement
Sales
Interpretation
Column chart is used to present the data visually in order to relationship among two of
the variable that is sales and advertising incurred in the business in a particular financial year.
This reflects that sales are increasing without incurring higher cost of advertising in the business.

2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
0 1000 2000 3000 4000 5000 6000
Interpretations
Bar chart reflects the increasing of sales and the reduction of advertising costs incurred
by an entity are presented in the horizontal format to facilitate its variety of users to take
important business decisions.
240
180 160
140
130
London
Birmingham
Bristol
Cambridge
Coventry
Interpretations

Pie chart reflects the overall branches of Balti palace by showcasing its existing profits to inspire
them to take new investment opportunity in order to achieve desired aims and targets of the
business in a given time frame.
2000 2002 2004 2006 2008 2010 2012 2014 2016
0
1000
2000
3000
4000
5000
6000
Interpretations
Scatter chart plot used by an entity is to accomplish all aims and the objectives of the
business within a given time frame. It shows that sales are going upward as compared to the
current level of advertising in the business.

3.2 Create trend lines in spreadsheet graphs to assist in forecasting
1 2 3 4 5 6 7 8 9 10 11 12 13 14
0
1000
2000
3000
4000
5000
6000
f(x) = 267.16x + 783.41
R² = 0.98
Column C
Linear (Column C)
Interpretations
Trend line chart used by an entity in order to depict the ultimate trend of forecasting the
future sales generated by the business to enhance overall skills and the capabilities of the
organization.
3.3 Prepare a business presentation
3.4 Produce a formal business report
To,
The director of Balti palace
Date- 14th April 2017
Introduction
The current research study will be conducted by an enterprise in order to identify various
reasons about the sales and the revenue generated by an organization. The generation of higher
sales and the revenue generated by an enterprise which in turn improves overall performance of
an entity by analyzing all the reasons responsible for increasing sales and the revenue of the
business.
Data collection

Primary research technique will be used by an entity in order to collect information about the
tastes and preferences of various customers by distributing questionnaires among all the
customers exist in the external market.
Secondary collection of data involves accessing books or journals in order to increase the
current market share by analyzing the consumer buying patterns to design their own products or
services.
Conclusions
It can be concluded that the reasons behind sale is the higher level of customers satisfaction
gained by an entity which will directly created impact on the overall profit of an entity. The
profit can be increased or decrease with the passage of time as the entity's skills will also gets
enhanced by taking external market opportunities.
TASK 4
4.1 Use of information tools
Information plays a significant role in the business which needs to be supplied from one
end to another according to the current nature of the business. Balti palace is required to adopt
the best suitable tool to improve their overall business as their major aim is to accomplish all he
goals and the objectives within a given time period. There are various tools of information
technology used by Balti palace in transferring important information from one end to another is
given as below:
Management information system- This particular system use by the management of Balti
palace is to communicate important information from the top management to its lower level
employees in order to ensure higher productivity of the overall organization (Petersen,,
Kushwaha and Kumar, 2015). In these systems the vision of the business will be aligned with all
the business practices of an entity in order to achieve all desired aim's and targets of the business
within a given time frame.
Transactions processing systems- Transactions involved in the business are automated by using
appropriate business systems that helps in generating higher outcomes in the near future which

helps in producing higher outcomes in the near future. Batch production systems will be adopted
in which food prepared by an entity in batches to optimally utilize all the current resources in the
business in order to help an organization in achieving desired aims and the objectives in give
period as this helps in accomplishing all the tasks and duties within a given time frame.
Transactions are processed in different batches to determine all sales and the revenue generated y
an entity in order to gain higher market advantage over its variety of customers.
4.2 Prepare a project plan for an activity and determine the critical path
Task Name Duration Start Finish Predecessors
Replace window in
lounges 5 wks Fri 9/9/16 Thu 10/13/16
Rewiring 4 wks Fri 9/9/16 Thu 10/6/16
Re-plaster walls of
lounges 2 wks Fri 10/14/16 Thu 10/27/16 1
Fit lights in lounges 1 wk Fri 10/7/16 Thu 10/13/16 2
Decorate bedrooms 5 wks Fri 10/7/16 Thu 11/10/16 2
Install plumbing 5 wks Fri 10/7/16 Thu 11/10/16 2
Decorate lounges 4 wks Fri 10/28/16 Thu 11/24/16 3,4
Decorate kitchens 3 wks Fri 11/11/16 Thu 12/1/16 6
Decorate 2 wks Fri 11/11/16 Thu 11/24/16 6
Interpretation
Gantt chart is used as visual presentation method which is used scheduling of all the
business activities included in a particular project which helps in achieving desired aims and the
objectives of an entity (Power, Sharda and Burstein, 2015). This saves the time of an individual

in order to classify all the activities in a chronological order according to the desired time allotted
to each and every business activities.
Interpretation
Critical path analysis is regarded s the important technique use in the project management
which is used to determine the time duration required to complete the desired aim and targets of
the business in order to enhance the capabilities of an entity. The critical path of above projects is
2+6+8 that means this project will take 12 weeks to complete the overall project.
4.3 Use financial tools for decision making
Year Cash flows PV@12% Present value

0 190000
1 50000 0.8928571429 44642.85
2 64000 0.7971938776 51020.40
3 58000 0.7117802478 41283.25
4 70000 0.6355180784 44486.26
Total 181432.78
NPV -8567.21
Interpretation
Net present value method is modern technique of capital budgeting which states about
evaluating the profitability of all the business projects used for the purpose of analysis. This
particular technique uses the time value of concept in which specific discounting rates is used by
an entity in order to determine the future performance of an entity in order to generate higher
business outcomes by utilize the current project for the betterment of the organization. The
higher profitability of the business projects will help an entity owner order to select a particular
project to generate higher outcome in the future (Rao and Tilt, 2015). The Balti palace is
dependent on the results of the capital budgeting techniques as positive results will facilitate the
in order to take higher competitive advantage over its variety of customers in the near future.
Negative cash flow values generated by particular business project will be tested using
discounting rate of 12% hat is the internal cost of capital determined by an entity in order to
achieve desired aims and the objectives of the business which is essential in order to get higher
competitive advantage. Hence, above project will be rejected as generated values are negative.
Year Cash flows
0 -190000
1 50000
2 64000

3 58000
4 70000
IRR 9.94%
Interpretation
Internal rate of return is one of the modernized techniques of capital budgeting in
analyzing the feasibility of different business projects. Business projects are used for the analysis
purpose in identifying various factors responsible for an entity to consider important projects for
the enhancing overall business of an enterprise. This rate is highly concerned with the break even
concept which determines that point in the business at which initial cost of an entity will be
recovered in the overall business tenure at the break even units (Welsh and Birch, 2015). It is
regarded as the alarming situation for the business as an entity will improve its overall
performance by generating higher amount of sales and the revenue by manufacturing higher
sales units as compared to the beak even point units in order to gain profit in the near future. The
higher rate of internal rate of return will be considered by an enterprise in selecting or rejecting a
particular project.
In the given case scenario, the internal rate of return is 9.94% which is higher as
compared to the internal cost of capital determined by the business enterprise in a particular
period. Lower rate of return in the current project will not be taken into consideration as this is
lower rate of return as compared to the internal cost of capital rate that is 12%.
CONCLUSION
It can be conclude for the assignment that decisions are important weapons used by an
entity in improving overall performance of the business. This report states that current
investment opportunity for Balti palace will be rejected as its overall performance is not good as
they have negative values of NPV and lowers internal rate of return generated by an entity after
assessing the projects. Critical path is used to determine the time duration of a particular project
that helps an entity in improving the overall performance of the business. This report also states

about the statistical judgments made by an entity in evaluating the current financial performance
of the Balti palace which states that it is showing good and favorable market position of the
business.

REFERENCES
Books and Journals
Boulay, A. M., et.al., 2015. Analysis of water use impact assessment methods (part B):
applicability for water footprinting and decision making with a laundry case study. The
International Journal of Life Cycle Assessment. 20(6). pp.865-879.
Craft, J. L., 2013. A review of the empirical ethical decision-making literature: 2004–2011.
Journal of Business Ethics. 117(2). pp.221-259.
Graham, J. R., Harvey, C. R. and Puri, M., 2015. Capital allocation and delegation of decision-
making authority within firms. Journal of Financial Economics. 115(3). pp.449-470.
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.
Ibrahim, B., Dumas, C. and McGuire, J., 2015. Strategic decision making in small family firms:
an empirical investigation. Journal of Small Business Strategy. 12(1), pp.80-90.
Kahraman, C., Onar, S. C. and Oztaysi, B., 2015. Fuzzy multicriteria decision-making: a
literature review. International Journal of Computational Intelligence Systems. 8(4).
pp.637-666.
Laureiro‐Martínez, D., Brusoni, S., Canessa, N. and Zollo, M., 2015. Understanding the
exploration–exploitation dilemma: An fMRI study of attention control and decision‐
making performance. Strategic Management Journal. 36(3). pp.319-338.
Petersen, J. A., Kushwaha, T. and Kumar, V., 2015. Marketing communication strategies and
consumer financial decision making: The role of national culture. Journal of Marketing.
79(1). pp.44-63.
Power, D. J., Sharda, R. and Burstein, F., 2015. Decision support systems. John Wiley & Sons,
Ltd.
Rao, K. and Tilt, C., 2015. Board composition and corporate social responsibility: The role of
diversity, gender, strategy and decision making. Journal of Business Ethics. pp.1-21.
Shepherd, D. A., Williams, T. A. and Patzelt, H., 2015. Thinking about entrepreneurial decision
making review and research agenda. Journal of management. 41(1). pp.11-46.