Using a simple five-day moving average, calculate the daily forecasts for the last 15 days. In...

  

Transcribed Image Text:

Using a simple five-day moving average, calculate the daily forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? Question 2 - (3 marks) Using a weighted average of 0.30 [last day], 0.25 [2 days ago] 0.20 [3 days ago], 0.15 [4 days ago], 0.10 [5 days ago), calculate the forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? [Continue to the next page] Question 3 - (5 marks) Assume that the forecast for Monday of 4 weeks ago was 450 units. Using an Exponential Smoothing with a = 0.25, calculate the daily forecasts for the last 15 days. If a is unknown, find the best value of the smoothing coefficient (a) that results in the lowest MSE. Question 4-(4 marks) Using your forecast for the last 15 days in parts (b) and (c), calculate MAD, MSE and MAPE for each forecasting method. Between the forecasting methods in parts (b) and (c), which one would you choose? Why? Using a simple five-day moving average, calculate the daily forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? Question 2 - (3 marks) Using a weighted average of 0.30 [last day], 0.25 [2 days ago] 0.20 [3 days ago], 0.15 [4 days ago], 0.10 [5 days ago), calculate the forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? [Continue to the next page] Question 3 - (5 marks) Assume that the forecast for Monday of 4 weeks ago was 450 units. Using an Exponential Smoothing with a = 0.25, calculate the daily forecasts for the last 15 days. If a is unknown, find the best value of the smoothing coefficient (a) that results in the lowest MSE. Question 4-(4 marks) Using your forecast for the last 15 days in parts (b) and (c), calculate MAD, MSE and MAPE for each forecasting method. Between the forecasting methods in parts (b) and (c), which one would you choose? Why?