Business Decision Making: Tour Package Analysis and Findings Report

This report delves into business decision-making processes, focusing on data analysis related to tour packages. It begins with an introduction to the importance of decision-making in achieving business objectives. The report outlines the methodology, including primary and secondary data collection methods, such as questionnaires and travel magazines. It details the survey methodology, including sampling techniques and questionnaire design. The report then summarizes the collected data using statistical tools like mean, median, mode, standard deviation, and interquartile range. The analysis includes measures of central tendency and dispersion, with interpretations of the results. Finally, the report presents the data visually using pie charts and bar charts to illustrate customer preferences and predict future performance, concluding with a discussion of quartiles, percentiles, and correlation.

BUSINESS DECISION
MAKING

INTRODUCTION
Decision plays an important role in enhancing overall skills and the capabilities of an
individual in order to achieve desired aims and the objectives within a given period. This project
report is all about considering each and every features of the tour packages in order to satisfy all
the needs and higher expectations of various customers in order to retain all of them within the
same business for long period in the same business. This project is al about creating data analysis
plan of collecting data and facts using two important methods such as primary and secondary.
Questionnaires is prepared to take the consent of all the visitors who intends to launch a new tour
package according to the tastes and preferences of various consumers located at the external
market. It includes various statistical tools such as mean, median, mode, standard deviation,
range and internal quartile range to test the feasibility of the collected data. The data will be
presented using graphs, bar charts and pic chart and tend line is used to predict the future
performance of an entity. Information processing tools are used to supply information from one
end to another and project tenure will be determined by preparing appropriate project plan and
feasibility will be checked through the application of various capital budgeting technique NPV
and IRR.
TASK 1
1.1 Identify sources of primary and secondary sources of data
Collection of data is regarded as one of the important approach in the research study as
this is act like an important pillar without which the building of research is not possible as an
individual starts research but will not conclude their overall research in the best possible manner.
There are two important sources of collection of data choose by an individual in order to collect
reliable amount of data in order to achieve all the desired aims and the objectives in a given
period to accomplish al desired aims and the objectives (Golbraikh and et.al., 2014). There are
two methods used in the overall research is given as below:
Data will be collected by a researcher about the details of al the visitors in knowing their
tastes and preferences about a particular destination. Destinations preferences of all the customer
is essential to be determine as this help an entity owner in customizing tour packages according
their wants.
1

Primary research- In this kind of research data will be collected from its designated source by
an individual in order to support the research study in completing them in a given period for the
beneficial of the business entity. Questionnaires are used by an entity in order to take the consent
of all individuals in accomplishing all the goals and the objectives.
Secondary research- In this kind of approach external market sources will be accessed in order
to collect important data about the customer's tastes and preferences, market trends as major aim
of an entity is accomplished all goals and the objectives of the business in order to complete the
research. Travel magazines will be used as one of the external source in which details about the
travel and tourism industry will be identified. Census data will be assessed in identifying he
income patterns of all the customers in order to design prices for various tour packages.
1.2 Present survey methodology
Methodologies play a significant role in a particular survey in which desired aim of the
business to provide right direction to the overall business (Haq, Brown and Moltchanova, 2014).
The survey conducted by the researcher will emphasize on considering all the facts and figures
important for concluding the research for the betterment of the firm.
Sampling used by an entity will help an individual in order to collect important facts and
figures in achieving all the goals and the objectives within a given period. Sample of 90
respondents will be selected by a researcher in order to take the answers of various respondents
on the viability of different tour destinations to be included in a variety of tour packages
designed by an entity.
Random sampling used by an individual in which data will be collected randomly as in
this stage every samples got equal chance of selection in contributing towards the conclusion of
overall research.
1.3 Design questionnaire
Questionnaire
Name _______________
Gender
Male
2

Female
Transgender
Que. 1. How old are you?
 20-30 years old
 30-40 years old
 40-60 years old
 60 years and above
Que. 2: What is your experience with the travel and tour operator while you book your tickets?
 Good
 Fair
 Very Good
 Awesome
Que. 3: What is the frequency of your travel booking?
 Monthly
 Quarterly
 Half yearly
 Yearly
 Sometimes
Que. 4: You will buy a tour package or product for destination A such as Morocco in further
years ?
 Strongly disagree
 Disagree
 Neutral
 Agree
3

 Strongly agree
Que. 5. How much you are going to pay for tour package or product for every person or traveler
for the destination A like as Morocco ?
 £500- £1000
 £1000-£1500
 £1500-£2000
Que. 6. I will buy a tour package or product for destination B such as Turkey in upcoming years
 Strongly disagree
 Disagree
 Neutral
 Agree
 Strongly agree
Que. 7: How much you will spend on the ravel package for the destination B like as Turkey ?
 £600 but less than 625
 £625 but less than 650
 £650 but less than 675
Que. 8: Do you purchase tour package for the famous destination like Cuba in future?
 Strongly disagree
 Disagree
 Neutral
 Agree
 Strongly agree
Que. 9. How much do you pay for booking ravel package for the destination like Cuba?
 £800 but less than 825
4

 £825 but less than 850
 £850 but less than 875
Que. 10. Will you book a tour package for destination D such as Dubai in near future?
 Strongly disagree
 Disagree
 Neutral
 Agree
 Strongly agree
Que. 11: How much you are ready to pay for tour package for destination D that is Dubai?
 £900 but less than 925
 £925 but less than 950
 £950 but less than 975
 £975 but less than 1000
TASK 2
2.1 Summarizing of data
Costs of tour
Number of customers
agreed X FX
500-1000 19 750 14250
1000-1500 20 1250 25000
1500-2000 18 1750 31500
2000-2500 15 2250 33750
2500-3000 6 2750 16500
3000-3500 7 3250 22750
3500-4000 3 3750 11250
5

4000-4500 2 4250 8500
N 90 163500
Mean £1816.67
Costs of tour
Number of customers
agreed X CF
500-1000 19 750 19
1000-1500 20 1250 39
1500-2000 18 1750 57
2000-2500 15 2250 72
2500-3000 6 2750 78
3000-3500 7 3250 85
3500-4000 3 3750 88
4000-4500 2 4250 90
Median 45.5
Lower Limit 1500
N 45.5
Cf 39
f 18
I 500
Median L+N1-cf/f*i
6

Median £1680.56
Mode 0
2.2 Analyse range of results
Arithmetic average- It is one of the important technique of measures of central tendency that is
arithmetic mean determined by an entity in order to accomplish desired aims and the objectives
within a given period. The average will be ascertained by an entity in order to enhance its overall
skills and the capabilities in improving current market position. The mean value is decreasing for
all the questions. It can be evident from the above results that out f the total 90 respondents of a
research majority of customers will purchase the tour packages on an average of £1816.67.
Median- It is that part of measures of the central tendency which will divides the overall data set
into two equal set out of which one part is higher than other part of the data (Golbraikh and et.al.,
2014). It is used to create a market trend that shows that median value of al the questions is
fluctuating in nature. Customers will purchase at least this tour package costs of £1680.56 which
generates this much revenue for an entity.
Mode- Higher number of repetition found in the overall data set will help an entity in order to
achieve desired aims and the objectives as this particular technique is useful in showing
consistency in the performance.
2.3 Analyse data using suitable measures of dispersion
Inter quartile range
Particulars Amount
Q1 22.75
Q3 68.25
IQR Q3-Q1
IQR 45.5
IQR= Q3-Q1
7

Interpretation
It is a basic difference among higher and lower quartile by using this particular approach
which improves overall performance of an entity in a particular financial year.
Standard deviation
Costs of tour
Number of
customers agreed X X^2 Fx^2
500-1000 19 750 562500 10687500
1000-1500 20 1250 1562500 31250000
1500-2000 18 1750 3062500 55125000
2000-2500 15 2250 5062500 75937500
2500-3000 6 2750 7562500 45375000
3000-3500 7 3250 10562500 73937500
3500-4000 3 3750 14062500 42187500
4000-4500 2 4250 18062500 36125000
N 90 370625000
STD √(fx^2/n)
£2,030.00
Interpretation
Standard deviation is one of the measure of dispersion technique which shows the
variations in the overall data set which shows closeness with the mean value of data. The results
show that the value of standard deviation is less than compared to the mean value of data.
8

Standard deviation is £2,030 is higher than the mean of the company in terms of all the tour
packages offered by an entity to all its customers.
2.4 Explain Quartile, percentile and correlation
Quartiles
Table 1: Computing quartile
Particulars Formula Amount
Q1 N+1/4 22.75
Q3 3(N+1)/4 68.25
Interpretation
Quartile is that techniques which divides all data set into four equal parts in order to
determine the overall performance of an entity. All values of quartile are ascertained in the
absolute manner in achieving all desired aims and the objectives of the business which states that
all values of Quartile remain the same for all the questions asked by the firm to all the
respondents on whom the overall research study is based (Irani, 2010). The values of quartile are
same for all the questions which shows that an entity have not applied higher efforts in
improving the overall business conditions in an enterprise.
Percentile is revised form of Quartile in which the performance of an entity will be
determined by focusing on each and every aspects essential for maintaining the performance of
an entity are focuses by the business. All varieties of percentile are remains the same which
needs to be improved by the business enterprise in a particular financial year.
TASK 3
3.1 Produce graphs and charts
Pie chart
For the year 2014
9

931
959
1104
713
For the year 2015
957
997
1163
769
2016
10