Reference no: EM132998625

Question - Given the following data on hotel check-ins for a 6-month period:

July: 70 rooms

August: 105 rooms

September: 90 rooms

October: 120 rooms

November: 130 rooms

December: 115 rooms

i) What is the 3-month moving average forecast for January?

ii) With alpha = 0.3, what is the simple exponential smoothing forecast for October? Assume the forecast for July was 75 rooms.

iii) Using a weighted moving average with weights of 0.6, 0.3, and 0.1 (from most recent), how many check-ins can be forecasted for January?

iv) Using the exponential smoothing factor 0.75, how many check-ins can be forecasted for January? Assume the forecast for November was 122 rooms.