Dear beloved readers, welcome to our website! We hope your visit here brings you valuable insights and meaningful inspiration. Thank you for taking the time to stop by and explore the content we've prepared for you.
------------------------------------------------ Actual Predict Month: Average number of rooms sold 3-month Moving Average forecast

a) January: 143, February: 168, March: 152, April: 170, May: 145

b) January: 143, February: 168, March: 152, April: 170, May: 155

c) January: 143, February: 168, March: 152, April: 170, May: 160

d) January: 143, February: 168, March: 152, April: 170, May: 165

January: 143, February: 168, March: 152, April: 170, May: 165 because it has the closest forecast to the actual number of rooms sold in May. Thus, the correct answer is: d) January: 143, February: 168, March: 152, April: 170, May: 165

The three-month moving average forecast for May is calculated by taking the average of the actual number of rooms sold in February, March, and April. For Option (a), the average is (168 + 152 + 170) / 3 = 163.33. For Option (b), the average is (168 + 152 + 170) / 3 = 163.33. For Option (c), the average is (168 + 152 + 170) / 3 = 163.33. For Option (d), the average is (168 + 152 + 170) / 3 = 163.33. Therefore, based on the moving average forecast, the number of rooms sold in May would be 163.33 for all options except Option (d), where it would be 165.

In option (d), the three-month moving average forecast for May is calculated as (168 + 152 + 170) / 3 = 163.33. However, the actual forecasted value for May in Option (d) is 165. This indicates that Option (d) has the closest forecast to the actual number of rooms sold in May, making it the most accurate forecast among the given options.

Hence, the correct answer is: d) January: 143, February: 168, March: 152, April: 170, May: 165