In Solved Problem 10-3, nonlinear programming was used to find the best value for the smoothing constant,

Question:

In Solved Problem 10-3, nonlinear programming was used to find the best value for the smoothing constant, ( in an exponential smoothing forecasting problem. To see how much the MAD can vary due to the selection of the smoothing constant, use Excel and the data in Program 10.13A to find the value of the smoothing constant that would maximize the MAD. Compare this MAD to the minimum MAD found in the solved problem.