Please do it with Excel. Show how you enter the equations in Excel and output. Be clear.

Will rate!

1. Monthly demand at A&D Electronics for flat-screen TVs are as shown. Estimate demand for the next three months using simple exponential smoothing with alpha=.3 and Holt's model with alpha=.05 and beta=.1. For the simple exponential smoothing model, use the level at Period 0 to be L_O = 1,659 (the average demand over the 12 months). For Holt's double exponential smoothing, use level at Period 0 to be L_0=948 and the trend in Period 0 to be T_0=109 (both are obtained through regression). Evaluate the MAD, MAPE, and MSE in each case. Which of the two methods do you prefer? Why? Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand (units) 1,000 1,113 1,271 1,445 1,558 1,648 1,724 1,850 1,864 2,076 2,167 2,191