How to do it in excel OM

IS 614Excel OM Assignment for Forecasting

Part I. Verify/confirm with Excel OM your hand-calculation solutions to the homework problems.

Part II. Exponential Smoothing

Use the actual and forecast data presented to you in the homework problem to calculate the February Forecast with Exponential Smoothing as a function of Alpha starting at = 0.1 and, increasing by 0.1 units, ending with = 0.9. Tabulate your results and then present them as a graph with as the x-axis and the Forecasts as the y-axis. If the Actual for February turns out to be 18, which value or values would be best to use? Type a short explanation of your decision on your spreadsheet.

Part III. Moving Average

Calculate the Moving Averages for n = 3,4, 5,6,7,8,9,10,11,12 periods. Tabulate your results and then present them as a graph with n (the number of periods being averaged) as the x-axis vs. the Forecasts as the y-axis. If the actual for February turns out to be 15, which n(s) would be the best to use? Type a short explanation of your decision on your spreadsheet.

Part. IV. Weighted Moving Average

Calculate the Weighted Moving Averages for n = 3 and 4 periods for the weights shown below:

2. 4,3,3
4. 4,3,1
6. 4,4,1
8. 4,2,1
10. 4,1,1
12. 4,4,2
14. 4,1,2
16. 4,2,2
18. 4,3,2
20. 3,2,1

Tabulate your results. If the actual for February turns out to be 14, which combination of n and weights would be the best to use? Type a short explanation of your decision on your spreadsheet.