Business Decision Making: Data Analysis and Report for TUI Company

This report provides a comprehensive analysis of business decision-making within the context of TUI, a tour and travel company. It begins with an introduction to the importance of decision-making in organizational growth and outlines the report's structure, which includes data collection, survey methodology, and questionnaire design. The report delves into primary and secondary data sources, detailing a sampling framework and the use of questionnaires to gather customer preferences, buying behavior, and satisfaction levels. Task 2 focuses on data analysis, employing measures of central tendency such as mean, mode, and median to interpret survey results. The analysis reveals customer demographics, satisfaction levels, travel frequency, and budget preferences, guiding recommendations for tour package development. The report further explores trend line analysis and presents a business presentation and report, culminating in a project plan and evaluation method for launching new tour products. Overall, the report provides valuable insights into data-driven decision-making within the travel industry, emphasizing the importance of customer-centric strategies and market analysis.

BUSINESS DECISION
MAKING

Table of Contents
INTRODUCTION 4
TASK 1 4
1.1 Data collection plan 4
1.2 Survey methodology and sampling frame work 5
1.3 Questionnaire 6
TASK 2 7
2.1 Various measures of central tendency 7
2.2 Result Analysis8
2.3 Measurement of dispersion rate of tour 9
2.4 Quartile, percentile and correlation coefficient 9
TASK 3 10
3.1 Data analysis 10
3.2 Trend line Graph 13
3.3 Business Presentation 13
3.4 Business report to develop new product 13
TASK 4 14
4.1 Information processing tool for the launch of a new tour product 14
4.2 Project plan and critical path 15
4.3 Project evaluation method…………………………………………………………....15
CONCLUSION…………………………………………………………………………………16
REFERENCES………………………………………………………………………………….17

17
4.3 Project evaluation method 18
CONCLUSION 19

INTRODUCTION
The decision making is so important in the future growth of an organization. There are so
many components on the decision should be taken by the authority of business organization such
as assets, liability, investment etc. The right decision-making can help the organization to
achieve its objectives as it has to choose the best option for the organization by which the target
can be achieved. This report is done on the basis of the TUI which is a tour and travel company
and operating internationally. This report have survey methodology and frame of sampling that
relates with the business(Bharadwaj, and et.al., 2013). The primary and secondary sources for
data collection will be discussed in this report so acquiring modern products. The questionnaire
will be done for knowing data about the customer like profile, preference, buying behavior. The
data collection will be done from 90 customers and the study have analysis of that data. To make
sure about the new tour products the calculation of mean, mode, median, standard deviation and
the investment tools will be done in this report which leads to meet with the target effectively.
TASK 1
1.1 Data collection plan
The people of current generation are so very interested in exploring the world. They used to travel
in different places, the attractive destinations. The tour packages that can attract the people are provided
by various tour operators in the current technological generation. The basic needs of the customers,
behavior, new trends in market should be known by the TUI to provide tour packages that can satisfy the
customers, the data collection can be done by two way one is primary and other is secondary(Smith and
et.al., 2017).
Primary sources: It is the first hand data so the researcher collects the information for the
specific subject matter. The reality of market trend, necessities of travelers can be identified by this tool.
There are so many way by which the primary data can be collected such as interview, survey, observation
etc. The major needs of customers has to be identified by the TUI to develop the more attractive tour
packages for them and make sure that what are their expectations(Rasouli and Timmermans, 2014).
The survey can be the best way to collect the details which can help to achieve the desired objective of
the company. The communication between the researcher and customers can be done via email, social
networking sites and other platforms. Questionnaire is helpful to get the same information about
customer. The target population will be sampled as 90 customers, the individual will ask the questions to
them. The questionnaire can help the customer so their feelings, needs, desires can be shared by this. The

people's requirements should be knows to the organization as they can make tour packages
accordingly(Hair and et.al., 2014).
Secondary sources: The existing data can be used by the researcher for the data collection. By
the books, journals, various articles, online source can be used as the secondary sources for collecting the
data. The perception and the behavior of the customers regarding travel can be observed through the
gathered information by the researcher. These methods can help the TUI to get the uncertainties also
according to this information the further plan can be made. The existing researches will tell about the
taste and preference of the customers. The can be considered for making the new designs. The risk can be
evaluated which has been faced by the other organization previously. The uncertainty can be reduced by
making proper plan(Song and et.al., 2017).
1.2 Survey methodology and sampling frame work
Sampling frame work: Basically sampling can be done two methods, its division of its framework is done
in two parts, such as probabilistic and non-probabilistic. The researcher have a aim to identify the
behavior of the people and he also want to know about the desires and requirements of
customers(Gardiner and et.al., 2013). That TUI can make more satisfying tour packages for them. The
probabilistic sampling would be appropriate for achieving that aim. There are so many techniques for the
sampling such as random, stratum etc. the sampling would be best for the current research. The researcher
can have 90 customers with a random approach and whom each one can fill up the questionnaire.
Customer’s preference and the modern trends in the market, these kind of information can be gathered by
the investigator with this approach(Smaliukiene and et.al., 2015).
Survey Methodology: The customer’s preferable things and their needs should be identified by the
researcher to design the tour packages for them. The survey is so helpful to get the relevant information in
which the customer’s needs and their expectation in included. The identification of lacking points in the
existing tour packages can be done by the survey thus, new packages will be made by the TUI’s
manager(De Massis and Kotlar, 2014). That creation of new tour package will help the organization to
enhance their sales percentage and ultimately the profitability will be increased. The survey can be done
by many methods like questionnaire, interviews, documentation review etc. The deep information about
the topic will be gathered by these techniques. The questionnaire is all about the individual have to fill the
questions which will give big amount of information is less time. The interview is the medium in which
the response of the people depends on their knowledge, status, emotional status, and experience. The
present report has been collected the data from the questionnaire which can be helpful to get large data
and information will be reliable(Glavas and Mathews, 2014).

1.3 Questionnaire
Que. 1. How old are you ?
 20-35 years
 35-50 years
 50-65 years
 65 years and more
Que. 2: Do you agree that Tour services and products provided by TUI are up to the customers
satisfaction level ?
 Highly disagree
 Disagree
 Neutral
 Agree
 Highly agree
Que. 3: How frequently do you travel to different destinations?
 Once in a month
 Twice in a year
 Once in a year
 Thrice in a year
 Very rarely
Que. 4. What is your approx budget for the tour pacakages?
 £500 but less than 535
 £535 but less than 550
 £550 but less than 585
 £585 but less than 610
 £610 but less than 635

Que. 5: Up to which pricing level of the tour product you will pay for each traveler for the tour
of destination B which is Turkey ?
 £500 but less than 525
 £525 but less than 550
 £550 but less than 575
 £575 but less than 600
 £600 but less than 625
Que. 6. Rank the below options as priority that must be included in tour packages at scale of 1-5?
2 3 4 5 1
Accommodation facilities1
20 30 10 10 30
Local guide
5 20 15 30 20
Packages needs to be
affordable 25 15 20 10 20
Sports tour packages
10 25 15 20 20
TASK 2
2.1 Various measures of central tendency
Measures of tendency is used by the managers to for the process of decision making. It is a descriptive
tool. Various tools of measuring central tendency are used by the managers in terms of decision making.
The tools are described as under(Loebbecke and Picot, 2015):
 Mean: Mean is a measure of central tendency which measures the performance of variables. This
tools helps in getting the performance of the variable data set(Bartkus and McDonald, 2016).

 Mode: It helps in finding out the pattern of the data set. It basically measures the occurrence of a
variable in the data set. This tool is majorly used by the data scientist to find out the patterns of
variables.
 Median: it is a tool of central tendency which divides the data set into two parts. It helps to find
out the middle term of the data set. It displays the different information that cannot be identified
in a single look by a manager.
2.2 Result Analysis
Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11
Mean 4 4 4 4 3 4 4 4 4 4 3
Median 4 5 4 5 3 5 4 4 4 4 2
Mode 5 5 5 5 3 5 5 5 4 4 2
Interpretation:
 Mean: Mean value reflects the satisfaction level of the respondents. The respondents are
satisfied with the tour package delivered to them by the tour operators. Values like 4 and
5 of mean are reflecting the fact that most of the respondents are interested in visiting
Turkey for the next time as well. People are asked for the expenditure between the range
of £675-£700. Few people are also interested if the package is in the range of
£700-£725. People are ready to spend within the range of £875-£900 in case of
Cuba. It shows that the expenditure level of Cuba is higher than Turkey.
 Median: The major part of values lie is 4, hence it is diving the data set in
multiple parts. The median value of the people who can visit to Turkey is 5 and
for the tour packages is also 5 . Therefore, the value 5 is diving the data set into
multiple types. It divides the respondents in multiple parts.
 Mode: The mode signifies how many respondents of the data set agrees on the
same point. Based on the table above, the value of mode is 5. It indicates the
number of respondents willing to visit Turkey based on the tour packages given
by the tour operators on the package range between £700-£725. The results based
on Cuba signifies the same result. Therefore, people are preferably agree to visit
Turkey than Cuba.
2.3 Measurement of dispersion rate of tour

Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11
STDEV 1 2 1 1 1 1 1 1 1 1 1
Interpretation
Suitable measures of dispersion are like standard deviation, range, semi- interquartile
range are being evaluated in this section for the given business of tour. Standard deviation is
used to evaluate the firm to forecast the variation amount. If found that values are less shows that
stat point is close to the mean value and if found to be more than data point are found to be far.
It was found that standard deviation value is found to be less in case of all asked question which
forecasted that the mean value and response value are similar which was given by respondents.
The semi interquartile when evaluated shows that there is similarity in the forth and second
quartile. SD value is found to be 1 which means that respondent response is slow. Which allows
the question to be in same place. It also shows the places which are chosen by the people.
2.4 Quartile, percentile and correlation coefficient
Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11
Q1 3 4 3 5 3 5 3 4 5 5 3
Q2 5 3 4 5 4 3 5 4 3 3 5
Q3 3 5 4 5 4 3 5 3 5 4 4
Interpretation
Following data shows details about the quartiles, percentiles and correlation coefficient
which can be used for making decision in tour market.
Quartiles shows the details about the high and low range of money which the person is
allowed to spend per night. Percentile or shows the percentage data of observational fall.
Correlation shows the relation between expenditure per night and nights spend. Quartile and
percentile are classified into four parts. Values of quartile in 5, 6, 5 for Q1 Q2 Q3. This are the
area of strong and equal parts. Such reflecting shows data 625,700 and 655 category. Which
means respondents are making expenditure between £655 to £725. Same is the case in other
countries like in Cuba which is 3,4,5. This shows respondent are ready to pay between £840 to
£930.

TASK 3
3.1 Data analysis
Theme 1: The age of customers.
20-35 40
35-50 30
50-65 15
65 year and more 5
Interpretation: This discussion have made the scenario that people of maximum numbers are
from 20-35 age group. The interpretation of this theme is that TUI have to be focused on this
age group for designing the new packages for tour. It will help them to make more profit and
people will attract to them.
Theme 2: The customers are satisfied by the services and products provided by TUI.
Highly disagree 35
Disagree 25
Neutral 15
Agree 10
Highly agree 5
Interpretation: This tale interprets that maximum people are happy with the services of TUI.
There are plenty of opportunities for the organization to make rapid growth and design more
attractive products.
Theme 3: The frequent value of travelers to travel in various destination?
Once in a month 25
Twice in a year 35
Once in a year 10
Thrice in a year 15
Very rarely 5
Interpretation: This theme interprets that most of the people travels twice in a year and
organization can target these kind of people to get the opportunities.
Theme 4: The approximated budget for the traveler’s tour packages?
£500 but less than 535 35

£535 but less than 550 20
£550 but less than 585 15
£585 but less than 610 18
£610 but less than 635 2
Interpretation: This scenario interprets that maximum people have budget of £500 but less than
535. The organization should focus on its pricing plans and has to mind on the designing of new packages
that people can afford easily.
Theme 5: The ranking for quality of services with the tour offers
1 2 3 4 5
Accommodation facilities1 20 30 10 10 30
Local guide 5 20 15 30 20
Packages needs to be
affordable 25 15 20 10 20
Sports tour packages
10 25 15 20 20
1 2 3 4 5
0
5
10
15
20
25
30
35
20
30
10 10
30
Accommodation facilities1

Local guide
0 1 2 3 4 5 6
Column H
Column G
Column F
Column E
Column D
rank Packages needs to be affordable
0
1
2
3
4
5
6
4
Column E
Column F
Column G
Column H
Column I
Sports tour packages
0
5
10
15
20
25
30
5
Column D
Column E
Column F
Column G
Column H

This figures shows that accommodation facilities got the top rank from the maximum
people. That shows it should be included in the tour packages of TUI and local guide is needed,
that is the perception of most of the people. Almost 25 people have commit that travel packages
should be under their budget as they can afford.
3.2 Trend line Graph
Regression equation can be denoted as the trend line equation.
Figure: Trend analysis chart
Interpretation: Trend analysis is the one of the main toll is used to make prediction about the
variable. The complexity in this tool is none so it can be used by anyone to make decisions. The
last bar is not crossed by the trend line so it shows the sales will be increases in the upcoming
years and also the organization will have to make strategies that must have potential. The trend
analysis is significantly important for making predictions.
3.3 Business Presentation
Covered in PPT
3.4 Business report to develop new product
To,
General Manager
TUI, London
Date: 27 May 2017

Introduction
The research is being as the needs of the customers will be identified and the company
can be able to develop tour packages for their respondents. The questions are asked to the 90
customers to know about the actual behavior of them.
Discussion
The above discussion have stated that TUI is capable to develop new packages. The
employees of the company are having valuable skills. The need of the customer is they want
affordable tour packages. The priorities of them is rooming around the accommodation facility.
The cited firm can more profit if they will fulfill these requirement of the customers. Mostly the
youngsters are excited to travel at different place.
Conclusion
Organization should be aware of the customer’s needs and also they should offer various
discount and well services to their clients. That will help them to have huge profit by people
satisfaction.
TASK 4
4.1 Information processing tool for the launch of a new tour product
Tools needed for the evaluation of new tour:
 Transaction processing system: This helps in sorting information effectively. Through
this, TUI important information can be transferred to sales, marketing, production,
operation etc. Using this technique details can be identified for the future references of
TUI group. Moreover the data can be store by TUI group for the future
reference(Bernroider, E.W. and Schmöllerl, P. , 2013). Management information system: Such software are used by mangers of TUI group to
identify the demands and needs during the time of travelling of the customer. Such
software also contain previous data which highlights minimum expanses to visit those
places. Along with this it improves performance level. Such software also needed in
order to identify the problems and issues which may rise during time of tour.

 Decision support system: Information processing tool which are required to store the data
of raw material, personal knowledge etc. which are compiled through this software for
evaluation purpose. It helps the personal development of the TUI firm. Forming this
helps to make tour package of next time which can increase consumers and make
profitability for TUI group(Stacey, 2016).
 Electronic point sale: Business transparency is shown through Electronic point sale. It
makes large transaction easy and there is detail recorded in the system directly.
4.2 Project plan and critical path
S. No. Description Activities Predecessor Duration
1 Data collection of
Primary research
A 3
2 Idea screening B 5
3 Training program
for staff members
C A 2
4 Technology
installation
D A 3
5 Resource and
allocation
preparation
E D,B 3
6 Data analysis F E,C 5
7 Control and
monitoring
G C 1
8 Taking customer
feedback
H F,G 2
Task Name Duration Start Finish Predecessors Total Slack

Data collection
Primary
research
3 wks Wed
11/30/16
Tue
12/20/16 0 wks
Idea screening 5 wks Wed
11/30/16 Tue 1/3/17 1 wk
Training
program for
staff members
2 wks Wed
12/21/16 Tue 1/3/17 1 4 wks
Technology
installation 3 wks Wed
12/21/16
Tue
1/10/17 1 0 wks
Resource and
allocation
preparation
3 wks Wed
1/11/17
Tue
1/31/17 2,4 0 wks
Data analyses 5 wks Wed
2/1/17 Tue 3/7/17 3,5 0 wks
Control and
monitoring 1 wk Wed
1/4/17
Tue
1/10/17 3 8 wks
Taking
customer
feedback
2 wks Wed
3/8/17
Tue
3/21/17 6,7 0 wks

Critical path:
= 1+4+5+6+8
Weeks= 3+3+3+5+2
= 16 weeks

4.3 Project evaluation method
Name of the
Tour product
Investment at
the initial
Variable cost
(CC)
Fixed cost
(FC)
Profit and
income
Cash
flow(VC+FC)
Tour A
(Morocco)
520000 500 225000 90200 315700
Tour B
( Turkey)
475000 475 250000 100190 350665
Tour C (Cuba) 459000 775 275000 110310 386085
Tour D
(Dubai)
550000 850 300000 120340 421190
NPV (Net Present Value)-
Name of the
Tour product
Investment at
the initial
Cash flow PV@9% Present value
(PV)
NPV
Tour A
(Morocco)
520000 315700 0.526 166157.89 -353842.10
Tour B
( Turkey)
475000 350665 0.526 184560.52 -290439.47
Tour C (Cuba) 459000 386085 0.526 203202.63 -255797.37
Tour D
(Dubai)
550000 421190 0.526 221678.95 -328321.05
IRR (Internal Rate of return)-
Name of the Tour
product
Investment at the initial Cash flow IRR
Tour A (Morocco) -520000 315700 -39.29%

Tour B ( Turkey) -475000 350665 -26.18%
Tour C (Cuba) -459000 386085 -15.89%
Tour D (Dubai) -550000 421190 -23.42%
Interpretation: The NPV is negative so there is no option available for profit. The Cuba is rhe
lowest negative so that is viable for the firm. The return rate in internal is also low so it can be
assumed viable them other.
CONCLUSION
The study have concluded that decision making in business can have impact of the each
factor of the organization. The behavior of the consumers, their preference, there needs should be
known to the organization for making affordable products for them. The decision making and
judgment can be done so effectively by using the investment appraisal tools which can help to
increase the profitability.

REFERENCES
Books and journals
Bharadwaj, A. and et.al., 2013. Digital business strategy: toward a next generation of insights.
Smith, W.W. and et.al., 2017. Exploring the Length and Complexity of Couples Travel Decision
Making. Cornell Hospitality Quarterly, p. 1938965517704374.
F. Hair Jr, J. and et.al., 2014. Partial least squares structural equation modeling (PLS-SEM) An
emerging tool in business research. European Business Review. 26(2). pp. 106-121.
Smaliukiene, R. and et.al., 2015. Consumer value co-creation in online business: the case of
global travel services. Journal of Business Economics and Management. 16(2). pp. 325-
339.
Loebbecke, C. and Picot, A., 2015. Reflections on societal and business model transformation
arising from digitization and big data analytics: A research agenda. The Journal of
Strategic Information Systems. 24(3). pp. 149-157.
Bernroider, E.W. and Schmöllerl, P. , 2013. A technological, organisational, and environmental
analysis of decision making methodologies and satisfaction in the context of IT induced
business transformations. European Journal of Operational Research. 224(1). pp. 141-
153.
Stacey, R.D., 2016. The chaos frontier: creative strategic control for business. Butterworth-
Heinemann.
Wynstra, F. and et.al., 2015. Service triads: A research agenda for buyer–supplier–
customer triads in business services. Journal of Operations Management. 35. pp. 1-20.
De Massis, A. and Kotlar, J., 2014. The case study method in family business research:
Guidelines for qualitative scholarship. Journal of Family Business Strategy. 5(1). pp. 15-
29.
Glavas, C. and Mathews, S., 2014. How international entrepreneurship characteristics influence
Internet capabilities for the international business processes of the firm. International
Business Review. 23(1). pp. 228-245.
Song, H. and et.al., 2017. Exploring Disagreement Prevention and Resolution in Travel
Decision-Making of Young Chinese Travelers. Journal of Travel & Tourism
Marketing. 34(2). pp. 257-273.
Rasouli, S. and Timmermans, H., 2014. Applications of theories and models of choice and
decision-making under conditions of uncertainty in travel behavior research. Travel
Behaviour and Society. 1(3). pp. 79-90.
Gardiner, S. and et.al., 2013. Travel decision making: an empirical examination of generational
values, attitudes, and intentions. Journal of Travel Research. 52(3). pp. 310-324.