Please show all work and steps please To answer number 8 question 7 has to be answered first

Question #7- Show All Work and Steps

Table 7.11 and Excels data Analysis Add in,

Month Demand

January 160

February 268

March 170

April 275

May 180

1. Compute an exponentially smoothing forecast with alpha = 0.20 through May

2. Compute the forecast for the next month (June)

Question #8 Show All Work and Steps

Table 7.12 and Excels data Analysis Add in,

Month Demand

January 160

February 268

March 170

April 275

May 180

1. Compute an exponentially smoothing forecast with alpha = 0.0.6 through May and create a forecast for the next month, June

2. Compare the forecasts you computed by using an exponential smoothing model from problem #7. Which forecasting model does a better job