Use excel qm. Warm up sample is 1-6 (feb 1-6) , forecasting sample is from 7-31 (Feb 7-Mar 3). Weights is 1-7. Restraints is = 0 for solver in determining alpha value. Keep solver results and in the option of reports, click 'answers' then generate result. Present solutions and formulas. Graph

Sales Forecast next period using 1-Feb 16 16-Feb 8 2-Feb 10 17-Feb 7 3. 3-Feb 12 18-Feb 7-period moving average (weighted) 12 4. Simple exponential smoothing (Excel gm Solver 4-Feb 15 19-Feb 9 to calculate the al 5-Feb 24 20-Feb 13 6-Feb 14 21-Feb 14 7-Feb 10 22-Feb 6 8-Feb 3 23-Feb 12 Calculating mean absolute deviation 9-Feb 7 24-Feb 19 10-Feb 0 25-Feb 15 (MAD), mean squared error (MSE), mean absolute 11-Feb 15 26-Feb 12 percentage error (MAPE) 12-Feb 13 27-Feb 13 use warm-up and forecasting samples calculations 13-Feb 7 28-Feb 4 14-Feb 12 1-Mar 4 15-Feb 3 2-Mar 13 What is the best forecast basing on MSE? 3-Mar 16