Supply chain management, Sunil Chupra, 7th edition: Chapter 7, Problem 9:Quarterly demand for smartphones at a retailer is as shown. After obtaining initial estimates for level, trend, and seasonal factors, forecast quarterly demand for year 5 using Winters model with = 0.05 , = 0.10 , and = 0.15. Evaluate the MAD, MAPE, MSE, bias, and TS for the forecast. what is the Seasonal Factor for Period 15? what is the Seasonal Factor for Period 16?

From Exercise 9 of Chapter 7 of the textbook: (35 points) Quarterly demand for smartphone at a retailer is as shown. After obtaining initial estimates for level, trend, and seasonal factors, forecast quarterly demand for year 5 using Winter's model with =0.05,=0.1, and =0.15. Evaluate the MAD, MAPE, and MSE. Please feel free to use the Excel file provided to you as part of this assignment. Please plot the demand data and your demand forecasts