50.1K

Verified Solution

Link Copied!

Excel 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: 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. Enter alpha (between 0 and 1), enter the past demands in the shaded column then enter a starting forecast. If the starting forecast is not in the first period then delete the error ir Forecasting Weighted moving averages - 2 period moving average Enter the data in the shaded area. Enter weights in INCREASING order from top to bottom. [ F F F the standard error Excel 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: 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. Enter alpha (between 0 and 1), enter the past demands in the shaded column then enter a starting forecast. If the starting forecast is not in the first period then delete the error ir Forecasting Weighted moving averages - 2 period moving average Enter the data in the shaded area. Enter weights in INCREASING order from top to bottom. [ F F F the standard error

Answer & Explanation Solved by verified expert

See Answer