– (1-1) Forecast the quarterly demand for Year 4 (periods 13, 14, 15, and 16) using mixed static method– (1-2) Compare MSE, MAD, MAPE, bias, and TS at period 12 between mixed static method and moving average method– (1-3) Discuss which of the two methods is a better forecasting method for this demand• Hint: create two error analysis tables (for example, use two “Figure7.7_rev” sheets) – one for mixed static method and one for moving average method
