how to find demand for 2022?

Assignment #4 (Due date: Apr 22", 2022) Problem (Ch. 15, Time Series Analysis) (100 pts / 100 pts) Mt. Bear is a ski resort in California. Many guests visit there; however, most of them come in the winter season because of the phenomenal skiing. A group of hotels has analyzed their demand for the last three years (see the table below). Ft = (a +At) + (1-2) to Foreca ES 2.2 Year 2019 Quarter 1 2 3 17 500 17 800 17 270 4 16516 17632.8 2020 Demand 19,000 14,900 13,700 22,100 18,700 17,000 16,500 20,100 19,700 12,100 13,200 23,400 1 2 3 4 17846.261 2021 1 2 3 4 17,67.992 17.441.5936 17,973.2749 16,518.6199 17,074 - $959 16,299.9167 Using a smoothing parameter of 0.2 and an initial forecast of 17,500, forecast demand for the four quarters in 2022 (If you use Excel spreadsheet in your problem-solving, you must submit screenshots or scans or photos of your Excel spreadsheet.). YEAR Demonol. Forecast zon 1 2. 3 4