demand forecasting in a supply chain
– (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
I’ve attached an excel sheet and a PDF with the question.