Please show all excel formulas and a picture of the solver box.

Thank you!

7. Exponential Smoothing. Many forecasting models use parameters that are estimated using nonlinear optimization. A good example is the Bass model introduced in this chapter. Another example is the exponential smoothing forecasting model which is a common forecasting model used in practice. For instance, the basic exponential smoothing model for forecasting sales is The exponential smoothing model is described in more detail in Chapter 8 Ut+1 = Qyt + (1 - a)t where t+1 forecast of sales for period t +1 Yt actual sales for period t forecast of sales for period t a = smoothing constant, 0