Question: can someone please help me understand how to solve this without using EXCEL? Just by problem solving writing it out the old fashioned way. Thank

can someone please help me understand how to solve this without using EXCEL? Just by problem solving writing it out the old fashioned way. Thank you. If your going to show it in excel please show the formulas for the cells please and 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
