Please solve this.

9:18 x? IIDII fv'? (Q \"EA i X 4947998_3524'l820... +0 3 Not saved yet - Question 2. (25 Marks) You work for a travel company that runs holiday hotels throughout the Mediterranean. The general manager is worried that overall numbers of excursions purchased (a very profitable line for the hotel group) are falling. You have been asked to analyse data relating to the total number of excursions booked per quarter, and to provide forecasts for the numbers in 2021. Please note that the effect of reduced sales in 2020 has been ignored and so please do not take into account what the assumed real sales would be! He has provided you with the following data since 2017. Numbers of excursions sold 000's mmml _m 1555 2010 1065 Ell 1600 2080 m 1000 1660 2200 1206 m 1020 1680 2300 1110 The trend values have been calculated for you as follows you do not need to check these: Quarte Data 9:18 10 LTE LTE X 4947998 35241820... + .. . Not saved yet Quarte Data Year Trend r (000's) 2017 1 900 2 1555 3 2010 1394.37 5 4 1065 1411.875 2018 1 995 1426.25 1436.12 2 1600 5 3 2080 1437.87 5 4 1074 1446 2019 1000 1468.5 2 1660 1500 3 2200 1519 4 1206 1524 2020 1020 1539 2 1680 1539.5 3 2300 4 1110 a. Draw the appropriate graph using the above information given. (5 marks) b. Paste in a copy of your graph showing the fully annotated projected tre lines. (3 marks)9:18 x.' -IDI- if"? 6%) LLEA i X 4947998_3524'l820... +0 3 Not saved yet - I I _I'I IIIU I I a. Draw the appropriate graph using the above information given. (5 marks) b. Paste in a copy of your graph showing the fully annotated projected trend lines. (3 marks) 0. Paste in a copy of your average seasonal variation (ASV) calculations with an explanation of the meaning of the final values for each quarter, using terms that your manager would understand. (6 marks) d. Put your final forecasts into a suitably headed table showing the forecasted values for 2021 ONLY (4 marks) e. Clearly explain to your manager your model choice (you must include a copy of your annotated graph to show this) (4 marks) General presentation, spelling and grammar including submitting your spreadsheet and correct use of formulae- (3' 's \\