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) 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 2018 Quarter 1 2 3 2019 4 1 2 3 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 4 2020 1 2 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. DO NOT USE EXCEL TO SOLVEStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
