Tour Destination Feasibility Analysis

This assignment involves analyzing the profitability of different tour destinations (Morocco, Turkey, Cuba, Dubai) by calculating their Net Present Value (NPV) and Internal Rate of Return (IRR). The goal is to identify the most financially viable destination for inclusion in a tour package. The analysis considers initial investment costs, cash flow projections, and discount rates.

BUSINESS DECISION
MAKING
1

2

INTRODUCTION
Decisions are imporrant aspects involved in an entity in which business actions are taken by
an individual for the sake of their entity. Tour operator has been selected by an entity who intends to
launch its new products in form of new tour packages in front of all the customers located in the
external business environment. The owner has evaluated four destinations as one of the prospective
tour packages developed by an entity in order to satisfy all the needs and the expectations of variety
of customers. This project report is all about creating data collection plan in order to collect facts
and information in order to support the overall aim of the research report. This report also stressed
on applying various statistical measures in order to test the overall accuracy of the data. This report
highlights that this report visualises the business information using bar charts, line charts, pie charts
and creation of trend line in order to predict the future performance of an enterprise after analysing
present resources kept in an entity for long time period. Different information processing tools are
used by an entity in order to convey important information about the business to all the external
market users. Project management tools are used to determine the total time required by an entity in
order to facilitate its variety of users. Financial tools are used by an entity owner in order to assess
the financial performance of an entity in order to grab higher market performance.
TASK 1
1.1 Identify sources of primary and secondary sources of data
Primary collection- Primary research is conducted by an entity in which personnel is specially
appointed in order to conduct a research to benefit its variety of users. In this kind of research study,
data is collected from its original source in order to provide ultimate advantage to its variety of
visitors which helps in designing customised tour packages to retain all the customers towards the
business of an entity. This particular research includes circulating questionnaires in order to taken
the consent of all the customers. Questionnaires will include both open end and closed end
questions included in the questionnaires in order to take the consent of all individuals in the external
market.
Secondary collection- This is another most important technique of data collection which is external
source of collection of facts and figures for supporting the desired aim of overall research study.
This kind of external data collection technique will help in knowing about the external market
trends about the travel and hospitality industry in order to consider all features and attributes. In this
particular source, data about customer’s income, tastes and preferences are determined by an
individual in order to generate higher business outcomes in the near future for securing the business
of an enterprise.
1.2 Present survey methodology
Research methodologies used by an entity will give right direction to the business as it
clarifies the path of an entity in collecting all important evidences in completing the overall research
report by identifying hidden areas of the research study (Baum and Crosby, 2014). The desired aim
of the business will get fulfilled in order to accomplish all the goals and the objectives within a
3

given time span. The research study conducted by an individual is to provide all solutions to the
research problem as every research is based on some problem or issue currently faced by a society
as without problem there is no existence of research study.
Cluster sampling technique used by an entity owner in order to select various facts and
figures by classifying all the data into various categories in facilitating an enterprise owner in order
to utilise all the information for the beneficial for the business in accomplishing all the goal and the
objectives develop by an entity owner. The total sample size for this particular research study is 90
customers for which all members of the society, businesses, local residents and students are
approached by an entity in order to seek their consent about the designing of various tour packages
for the beneficial of an enterprise.
1.3 Design questionnaire
Questionnaire
Name _______________
Gender
Male
Female
Transgender
Que. 1. How old are you?
 20-30 years old
 30-40 years old
Que. 2: Do you think tour operator will be able to meet with your satisfaction level by providing
tout products?
Yes
No
Que. 3: How often you are purchasing a tour package within one year ?
 Monthly
 Quarterly
 Half yearly
4

 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
 Strongly agree
Que. 5. How much you are going to pay for tour package or product for every person or
traveller for the destination A like as Morocco?
 £600 but less than 625
 £625 but less than 650
 £650 but less than 675
 £675 but less than 700
 £700 but less than 725
Que. 6. You 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
5

 £650 but less than 675
 £675 but less than 700
 £700 but less than 725
Que. 8: Are you going to buy package for Cuba destination in upcoming years?
 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
 £825 but less than 850
 £850 but less than 875
 £875 but less than 900
 £900 but less than 925
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
6

TASK 2
2.1 Summarizing of data
2.2 Analyse range of results
Mean- It is regarded as one of the important technique of statistical tools used in the measure of
central tendency. The arithmetic mean is refers to overall average of all the data set determined by
determining the total sum which will be divided by the number of observations made by an
individual in conducting a research in order to achieve their desired aims and the objectives within a
given period of time. It is that approach which is used by an entity in order to maintain a
consistency which helps in ascertaining the external market trend in the external business
environment. The answers of all the respondents are tested by applying mean on the given data set
in order to test the statistical accuracy of all the data. It can be said that the mean value of above
data set is fluctuating in nature as initially it increases which later on decreases with the different
questions asked by the tour operator to various respondents.
Median- Another important statistical tool used by an entity owner is median which divided the
overall set of data into two equal set in order to determine the middle position in the overall data set.
The data collected by an individual b conducting overall research is to achieve desired aims and the
objectives within a given period in improving business conditions of the business. The primary aim
of the business enterprise is to capture higher market share in the external market (Irani, 2010). It
can also be said that middle quartile in which middle value of the collected data will be used for the
benefit of the business tour operator who intends to launch new product in order to develop new
travel packages in accomplishing desired aims and the objectives develop by an entity in order to
grab higher market share in the external business environment. Hence, it can be said that after
analysing the above data set that median of the above data is 4 that shows that stable value of
median shows that most of the respondents have answered all the questions with high degree of
biasness as their major aim is to accomplish desired aims and the objectives of an entity in less time
period as compared to all the competitors located in the external business environment.
Mode- It is last component in the trilogy of the different measures of central tendency which states
7

that an entity which shows the repetitive values occurred in the overall data set as their major aim os
to show the consistency in the given data set. This particular approach reflects the frequently
occurred values in the overall data set as this helps an entity owner. This will help tour operator in
order to design all the tour packages in order to satisfy variety of users of the business by retaining
all of them with an entity for long period.
2.3 Analyse data using suitable measures of dispersion
Inter quartile range
Standard deviation
Interpretations
Standard deviation shows the variations takes places in the overall data set in order to
achieve desired aims and target in the business. Higher the values of standard deviations show its
closeness with the mean value of the above data set (Carr, Kolehmainen and Mitchell, 2010). It can
be said that the above data set is reflecting lower values of standard deviations which is even lesser
than the mean of the above collected data set.
2.4 Explain Quartile, percentile and correlation
Quartiles
Table 1: Computing quartile
Percentiles
8

Table 2: Computing percentile
Interpretations
Quartile is that technique which classifies the overall data set into four equal parts in lower
to know the performance of an entity in generating higher level of customer’s satisfaction. It is
regarded as the pre-requisite before designing tour packages in order to attract wide number of
customers towards the business enterprise in order to accomplish all the desired aims and the
objectives in less period of time.
TASK 3
3.1 Produce graphs and charts
Pie chart
For the year 2014
931
959
1104
713
For the year 2015
9

957
997
1163
769
2016
1008
1035
1189
811
Interpretation
The pie chart is that kind of visual presentation of data in which different answers of all the
respondents are assessed in relation to the travel and tour packages designed by an entity. It can be
seen from the above all the three pie charts which reflects the consent of all the customers in three
different years that helps in creating tour packages for the benefit of the business who intends to
launch new tour package by adopting particular tour destination.
2014
10

Q1
Q2
Q3
Q4
0 200 400 600 800 1000 1200
931
959
1104
713
2015
Q1
Q2
Q3
Q4
0 200 400 600 800 1000 1200 1400
957
997
1163
769
2016
Q1
Q2
Q3
Q4
0 200 400 600 800 1000 1200 1400
1008
1035
1189
811
11

Interpretation
Bar chart is that kind of technique that presents the overall data into horizontal format as this
particular approach used to determine the relationship among the collected data and helps in
creating strong link with the desired aim of the business (Ford and Richardson, 2013). This method
is help an entity owner in order seek the consent of all the customers which is essential in order to
consider all the tastes and preferences various customers. High level of customer satisfaction is
essential aspects for an entity in order to operate their business in the best possible manner.
Line chart
2014
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
931 959
1104
713
2015
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
1400
957 997
1163
769
2016
12

Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
1400
1008 1035
1189
811
Interpretation
Line chart is regarded as another most important technique which helps in reflecting higher
market performance of an entity in order to grab higher market opportunities. The desired aim of an
entity owner is to consider all the external market trends and buying patterns in improving current
business conditions which falls in the travel and tourism industry which is operating in a uncertain
sector which is full of market risks that can affect an entity’s overall performance in a particular
time period in order to focus on all hidden aspects of the business (Nowduri, 2011). The above line
chart shows that it is increasing by showing upward trend as the customer satisfaction is increasing
is increases with the rapid rate as higher level of customer satisfaction strengthen the overall
business of tour operator by considering all external market changes in the existing products or
services of a entity.
3.2 Create trend line
2014
13

Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
931 959
1104
713
f(x) = -50.9x + 1054
2015
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
1400
957 997
1163
769
f(x) = -39.8x + 1071
2016
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
1400
1008 1035
1189
811
f(x) = -43.7x + 1120
14

Interpretations
Trend line is one of the important aspects of the forecasting whose desired aims is to analyse
all the present resources of an entity in order to capture higher market share. It is essential to create
trend line in which the performance of the business will be considered as the major aspects in their
business entity to achieve desired market objectives in a given period of time (Indiveri and Liu,
2015). The current trend line shows that an entity’s higher level of customer satisfaction in order to
uplift the current condition of an entity in order to grab higher market opportunities in order to
achieve desired aims and targets.
3.3 Prepare business presentations
3.4 Prepare formal business report
To
The director of tour operator
Date- 19th April 2017
Sub- Product development
Introduction
Development of the products is the desired aim of an entity who intends to assess the current
tour destinations in order to develop all the tour destinations. This research report conducted by
an individual is to steal the attention of most of the user towards the services offered by an
entity to its external market users.
Data collection
Important aspect of a research study is to collect data in order to facilitate variety of users in
order to achieve the desired aims and the objectives of an enterprise. Hypothesis will be tested
in the overall research report which is regarded as the voyage of discovery in which detailed
explanation will be done on different aspects which help an entity in order to collect important
facts and figures in order to achieve all the goals and the objectives of an enterprise within a
given time period (Golbraikh and et.al., 2014). It can be collected in two important methods
such as primary as well as secondary method. Questionnaires are used in the primary research
and on other hand; secondary research will be used by an entity owner in order to collect
information from several books, journals, magazine articles about the current aim of the
research report.
Conclusion
It can be summarised from the above report that consent of all the customers are taken into
consideration by an enterprise in order to accomplish all its aims and the objectives within a
15

given period of time. Role of business entity is to improve its current market condition hy
grabbing higher market opportunities in the external business environment.
Yours Affectionately
Product manager
TASK 4
4.1 Use appropriate information processing tools
Management information system
This kind of system play an important role in an enterprise in conveying important
information from one end to another end for achieving all the desired aims nad the objectives. Thiss
particular technique will emphasises on communicating both financial as well as non-financial
information supplied by an entity in order to grab higher market opportunities in the external
business market (Mir and Pinnington, 2014). An entity will held responsible for all their actions as
an entity will involve all kinds of business transactions incurred in the business which will be
communicated internally in the business for the betterment of the business.
4.2 prepare project plan and determine critical path
S. No. Name of activity Activity Preceding activity Duration (in days)
1 Analysing market trend A - 11
2
Analysing about consumers and
people of country B A 14
3
Choosing business mode for
deliver products and services C B 10
4
Funding the project using different
financing sources D B, C 7
5 Create a schedule or plan E D 6
6 Implementing above prepared plan F E 5
7 Launching the new tour product G E, F 2
16

Interpretation
Critical path analysis is regarded as the important technique used in the project management
in which overall time duration of a particular project in order to help an entity in order to allocate all
their resources appropriately among all the business activities. Total time duration is 44 days in total
required by an entity in order to complete a project.
4.3 Use financial tools to test feasibility
Name of Tour
Initial
investment Variable cost Fixed cost Profit
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
17

Name of tour
Initial
investment Cash flow PV@9% Present value NPV
Tour A
(Morocco) 520000 315700 0.5263157895
166157.89473
6842
-
353842.10526
3158
Tour B
( Turkey) 475000 350665 0.5263157895
184560.52631
5789
-
290439.47368
4211
Tour C (Cuba) 459000 386085 0.5263157895
203202.63157
8947
-
255797.36842
1053
Tour D
(Dubai) 550000 421190 0.5263157895
221678.94736
8421
-
328321.05263
1579
Name of tour Initial investment 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%
Interpretations
Different tour destinations are analysed on the basis of two important technique of capital
appraisal method such as NPV and IRR in order to test the feasibility of the business project. It can
be seen from the above table that Cuba is that particular destination suitable for included in the tour
packages in order to generate higher amount of sales and the revenue for an entity as this
destinations has higher values in relation this particular methods.
CONCLUSION
It can be concluded from the above project report that decisions are important aspects of an
entity that needs to be taken in order to manage all the complexities of an entity. Cuba will be
selected as one of the important destination in order to include in the tour package in order to
accomplish all the desired aims and the objectives of the business enterprise.
18

19