If you think about it, Solver is doing nothing more than running many iterations of the equations that calculate the objective. For forecasts, this is MAPE or MSE, etc. You have to have links from your objective cell back to the cells you want Solver to change. Inspect the following graphic that shows the linkage from MAPE back through the forecast model to alpha. The linkages from MAPE goes back to the actual values, but we cannot change them. That’s why you select MAPE as the objective and Alpha as the cell to change:

# MAPE

## Use Excel to Calculate MAD, MSE, RMSE & MAPE

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

## Using Excel 2016’s Solver to Optimize Exponential Smoothing Forecasts

An easy way to minimize MAPE:

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