The following table shows the actual demand observed over the last 11 years: 1 2 3 4 5 6 7 8 9 10 11 Year Demand 6 10 6
Posted: Mon May 30, 2022 5:45 pm
The following table shows the actual demand observed over the last 11 years: 1 2 3 4 5 6 7 8 9 10 11 Year Demand 6 10 6 7 11 9 11 12 10 11 7 This exercise contains only parts b, c, and d. b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year 4 5 6 7 8 9 10 11 12 Forecast c) Using the 3-year weighted moving average with weights 0.15, 0.30, and 0.55, using 0.55 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places). 4 5 6 7 8 9 10 11 12 Year Forecast d) Mean absolute deviation for the forecast developed using the 3-year moving average is 1.63 and for the 3-year weighted moving average is 1.59. Based on this information, the better forecast is achieved using the approach.