Question: can someone please explain the steps necessary to solve this problem without using EXCEL? Thank you! 1. Problem (Ch. 15, Time Series Analysis - Seasonality)

can someone please explain the steps necessary to solve this problem without using EXCEL? Thank you!
1. Problem (Ch. 15, Time Series Analysis - Seasonality) (50 pts/100) 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). Year Quarter Demand 2018 1 2 3 4 2019 1 2 19,000 14,900 13,700 22,100 18,700 17,000 16,500 20,100 19,700 12,100 13,200 23,400 3 4 2020 1 N 3 4 Using a smoothing parameter of 0.3 and an initial forecast of 18,000, forecast demand for the first four quarters in 2021. If you use Excel sprea et in your proble solving, you must submit screenshots or scans or photos of your Excel spreadsheetStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
