To optimize your forecast, whether moving average, exponential smoothing or other form, you need to calculate and evaluate MAD, MSE, RMSE, and MAPE. With Excel 2016, this is easy to do.

[embedyt] http://www.youtube.com/watch?v=H_N5_vxs8Tg[/embedyt]

Open the Excel workbook here MAP MSE MAPE