Question 4 Consider the below data set. Months 1 3 4 6 8 9 10 11 12 Demand 74 76 74 99 93 94 63 92 62 88 63 91 a) Calculate 3- months and 5-months moving average forecasts for months #6-12. b) Error,...

part C D E

Extracted text: Question 4 Consider the below data set. Months 1 3 4 6 8 9 10 11 12 Demand 74 76 74 99 93 94 63 92 62 88 63 91 a) Calculate 3- months and 5-months moving average forecasts for months #6-12. b) Error, determine which method in part(a) fits the data better, 3-months moving average or 5-months moving average. If the performance measures give conflicting results, choose which method you prefer and explain why. Jsing Mean Absolute Deviation, Mean Absolute Percentage Error and Mean Squared Using 5-months moving average method, using the available data make a forecast for month#13 and month#15. d) step-ahead exponential smoothing forecasts for months #7-12 Assume that the forecast made for Month#6 is 100. Use a=0.3 and a=0.7 to calculate one- e) Error, determine which method in part(d) fits the data better exponential smoothing with a=0.3 or exponential smoothing with a=0.7 Using Mean Absolute Deviation, Mean Absolute Percentage Error and Mean Squared