• Read Ch. 7 Exercise 1 “ABC Corporation” • ABC corp

• Read Ch. 7 Exercise 1 “ABC Corporation” • ABC corporation uses mixed static method fordemand forecasting • ABC corporation decided to use quarterlydemand instead of monthly demand fordemand forecasting • The table in the right lists quarterly demand ofthe most recent three years • Questions– (1-1) Forecast the quarterly demand for Year 4(periods 13, 14, 15, and 16) using mixed staticmethod– (1-2) Compare MSE, MAD, MAPE, bias, and TSat period 12 between mixed static method andmoving average method– (1-3) Discuss which of the two methods is abetter forecasting method for this demand • Hint: create two error analysis tables – one formixed static method and one for moving averagemethod • You may modify the attached Excel file so you do not have to create excel which save you a lot of time.