38 X B C D E F G H A The ABC Corporation Period Demand Forecast Monday 372 Tuesday 462 4 Weeks Ago Wednesday 597 Thursday 4 147 Friday 282 Monday 6 552 Tuesday 7 507 3 Weeks Wednesday 8 642 ago Thursday 9 237 Friday 10 165 Monday 11 542 Tuesday 12 408 2 weeks Wednesday 13 552 Ago Thursday 14 237 Friday 15 462 Monday 16 542 Tuesday 17 531 Last week wednesday 18 732 Thursday 19 372 Friday 20 336 Monday 21 This week Data Question 1 | Question 2 Question 3 Question 4 + eady Accessibility: Good to go 25 . C Q Sea SunnyQuestion 1 - (3 marks) 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? Q Search X hp