Comparative Analysis of Tour Business Revenue Data: 2014-2016 Report

This report provides a detailed analysis of a tour business's quarterly revenue data from 2014 to 2016. The analysis utilizes pie charts, bar charts, and line charts to visualize sales trends across different quarters. The report interprets the data, highlighting both positive and negative trends, such as the initial increasing sales up to Q3 followed by a decline in Q4 for each year. Trend lines are also presented, indicating a decreasing sales trend over the years, with the most significant decline in 2014. The interpretations suggest the need for effective marketing strategies to attract more customers and improve profitability. The report concludes with references to relevant academic sources.

BUSINESS DECISION
MAKING
TASK 3.3

Pie Chart For Year 2014
931
959
1104
713
Q1
Q2
Q3
Q4

Pie Chart For Year 2015
Q1
Q2
Q3
Q4
957
997
1163
769

Pie Chart For Year 2016
Q1
Q2
Q3
Q4
1008
1035
1189
811

Bar chart for year 2014
Q1
Q2
Q3
Q4
0 200 400 600 800 1000 1200
931
959
1104
713

Bar chart for year 2015
Q1
Q2
Q3
Q4
0 200 400 600 800 1000 1200 1400
957
997
1163
769

Bar chart for year 2016
Q1
Q2
Q3
Q4
0 200 400 600 800 1000 1200 1400
1008
1035
1189
811

Line chart for year 2014
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
931 959
1104
713

Line chart for year 2015
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
1400
957 997
1163
769

Line chart for year 2016
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
1400
1008 1035
1189
811

INTERPRETATION
 It can be analysed from the above presented bar, line and pie chart
that the tour business entity generating revenue from different
destinations in positive and favourable situation.
 In the FY 2014 the firms able to sell its tour products in increasing
trend up to the quarter three which is 931, 959 and 1104 GBP.
 After that in the quarter four sales of the firm reduces and reaches
up to 713.
 In context to the fiscal year 2015 and 2016 sales and revenue of
the tour firm is also having increasing trend up to the third quarter.
 Moreover, in both the years such as 2015 and 2016 at the quarter
four sale of entity is worth of 769 GBP and 811 respectively
which are reduced from previous.

Trend Line For year 2014
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
931 959
1104
713
f(x) = -50.9x + 1054

Trend Line For year 2015
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
1400
957 997
1163
769
f(x) = -39.8x + 1071

Trend Line For year 2016
Q1 Q2 Q3 Q4
0
200
400
600
800
1000
1200
1400
1008 1035
1189
811
f(x) = -43.7x + 1120

INTERPRETATION
 The above trend line shows that in all the financial years sales
trend of the tour company is reducing and decreasing which is
not well for it.
 In the year 2014 sales reduce with the high rate when compare
with the another years. Among all the years, very low reducing
trend is in the FY 2015 where revenue declines from 957 to 769
GBP from quarter one to four.
 On the basis of such trend line and analysis it can be forecasted
that in the upcoming fiscal year the tour company will not able
to generate profitable and increasing trend.
 Hence, the management needs to make effective marketing
strategies for enhancing attraction of the local community and
consumers.

REFERENCES
Weise, T. and Chiong, R., 2015. An alternative way of presenting
statistical test results when evaluating the performance of
stochastic approaches. Neurocomputing. 147. pp. 235-238.
Arnold, B. C., 2015. Pareto distribution. John Wiley & Sons,
Ltd.
Lee, K. J. and et.al., 2014. Model-based asymptotically optimal
dispersion measure correction for pulsar timing. Monthly
Notices of the Royal Astronomical Society. 441(4). pp.2831-
2844.

THANK YOU