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: 1) 4,3,3 2) 4,3,1 3) 4,4,1 4) 4,2,1 5) 4,1,1 6) 4,4,2 7) 4,1,2 8) 4,2,2 9) 4,3,2 10) 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. Forecasting Exponential smoothing \begin{tabular}{|l|l|} \hline Next period & 0 \\ \hline \end{tabular} Forecasts and Error Analysis Forecasting DemandForecast Not enough data to compute the standard error Not enough data to compute the standard error 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: 1) 4,3,3 2) 4,3,1 3) 4,4,1 4) 4,2,1 5) 4,1,1 6) 4,4,2 7) 4,1,2 8) 4,2,2 9) 4,3,2 10) 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. Forecasting Exponential smoothing \begin{tabular}{|l|l|} \hline Next period & 0 \\ \hline \end{tabular} Forecasts and Error Analysis Forecasting DemandForecast Not enough data to compute the standard error Not enough data to compute the standard error
