Analyzing Revenue Trends for Business Decisions in Tour Company

This report analyzes the revenue of a tour company from 2014 to 2016, using pie charts, bar charts, and line charts to visualize quarterly sales data. The analysis reveals that while revenue generally increased from Q1 to Q3, it declined in Q4 across all three years. Trend lines indicate a gradual decrease in overall sales and revenue, suggesting the company is struggling to attract more travelers. The rate of decline was highest in 2014, with a slightly lower rate in 2015 and 2016. Based on these trends, the report forecasts a continued reduction in sales and revenue for 2017 and 2018. The report references academic sources on statistical testing and distribution analysis to support its findings. Desklib provides students with access to this and other solved assignments for educational purposes.

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
 From the above presented all kinds of charts shows revenue
of the tour company which is generated in the year 2014,
2015 and 2016 from different destinations.
 It can be said that total sales in the year 2014 is worth of
931, 959, 1104 and 713 as per the quarter 1, 2, 3 and 4
respectively.
 On the other side in the case of 2015 and 2016 revenue
increases up to the quarter three in all the three years.
 After the quarter three sales of tour company declines in the
quarter four.

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