Question: PA 1 5 - 6 ( Static ) La Villa is a ski resort in the Italian... La Villa is a ski resort in the

PA 15-6(Static) La Villa is a ski resort in the Italian...
La Villa is a ski resort in the Italian Alps. Many guests visit the town; 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. Fill in the table below. Using a smoothing parameter of 0.25 and an initial forecast of 17,000, forecast demand for the first four quarters in 2021.
Note: Round Seasonal Index to \(\mathbf{3}\) decimal places and all the other answers to \(\mathbf{2}\) decimal places.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|}
\hline Year & Quarter & Demand & Quarter & Season Average & Seasonal Index & Deaseasonalized Demand & Smoothed Demand & Forecast & Re-seasonalized Forecast \\
\hline \multirow{4}{*}{2018} & 1 & 22,100 & 1 & 21,866.87 & 1.250 & 17,720.00 & & 2021Q1 & 21,202.00\\
\hline & 2 & 14,900 & 2 & 14,666.67 & 0.840 & 17,812.00 & & 2021Q2 & 15,287.00\\
\hline & 3 & 13,700 & 3 & 14,466.67 & 0.830 & 16,604.00 & & 2021Q3 & 14,382.00\\
\hline & 4 & 19,000 & 4 & 19,133.33 & 1.090 & 17,411.00 & & 2021Q4 & 18,004.00\\
\hline \multirow{4}{*}{2019} & 1 & 20,100 & Overall & 17,533.33 & & 16,117.00 & & & \\
\hline & 2 & 17,000 & & & & 20,323.00 & & & \\
\hline & 3 & 16,500 & & & & 19,998.00 & & & \\
\hline & 4 & 18,700 & & & & 17,136.00 & & & \\
\hline \multirow{4}{*}{2020} & 1 & 23,400 & & & & 18,763.00 & & & \\
\hline & 2 & 12,100 & & & & 14,465.00 & & & \\
\hline & 3 & 13,200 & & & & 15,998.00 & & & \\
\hline & 4 & 19,700 & & & & 18,053.00 & & & \\
\hline
\end{tabular}
PA 1 5 - 6 ( Static ) La Villa is a ski resort in

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!