PLEASE USE EXCEL TO Solve the question below. ONLY SOLVE this problem IF YOU CAN show the steps you used in excel and the excel formulas used.

UPDATE**:

PART (e) Make sure to calculate all 3 measures of forecasting accuracy listed below for the forecasts made by the techniques used in PART (c) & PART (d).

-i) MAPE (Mean Absolute Percent Error)

- ii ) MAD (Mean Absolute Deviation)

- iii) MSE ( Mean Squared Error)

REMINDER: PLEASE kindly USE EXCEL TO Solve the question below. ONLY SOLVE this problem IF YOU CAN show the steps you used in excel and the excel formulas used.

15. Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. ACTUAL MONTH DEMAND ACTUAL MONTH DEMAND - c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F) of 61 and an a of 0.30. d. Calculate the exponential smoothing with trend component forecast for periods 2-12 using an initial trend forecast (T) of 1.8, an initial exponential smoothing forecast (F) of 60, an a of 0.30, and a 8 of 0.30