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

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 SOLVE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!