Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

La Villa is a ski resort in the Italian Alps. Many guests visit the town, howeve

ID: 329637 • Letter: L

Question

La Villa is a ski resort in the Italian Alps. Many guests visit the town, however, most of them come in the winter seasor 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.20 and an initial forecast of 17000.00, forecast demand for the first four quarters in 2015 Round Seasonal Index to 3 decimal places and all the other answers to 2 decimal places.) Season SeasonalDeaseasonalized Smoothed Year Qtr Dema nd Quarter Average Index Demand -seasonalized Demand Forecast 2012 1 22.500 2 14,200 313,600 418,400 2015Q1 2015Q2 2015Q3 2015Q4 2 4 2013 121,200Overall 2 16,900 316,000 418,400 2014 1 24.300 2 11.900 3 13,400 419,000

Explanation / Answer

Year Qtr Demand Average Seasonal indices Deseasonalized demand smoothed demand 2012 1 22500 17175 1.310 17175 18240 2 14200 0.827 17175 16580 3 13600 0.792 17175 16460 4 18400 1.071 17175 17420 2013 1 21200 18125 1.170 18125 18740 2 16900 0.932 18125 17880 3 16000 0.883 18125 17700 4 18400 1.015 18125 18180 2014 1 24300 17150 1.417 17150 18580 2 11900 0.694 17150 16100 3 13400 0.781 17150 16400 4 19000 1.108 17150 17520