1 spreadsheet with calculations, and a 1 page document
Your Director of Supply Chain needs help in developing forecasts. Choose one of the following three options.
1. Develop forecasts for periods 6 through 24 using moving average with 3 periods, 4 periods, and 5 periods, or…
2. Develop forecasts for periods 3 through 24 using a smoothing factor of 0.2 and 0.3, or…
3. Develop forecasts for periods 5 through 24 using weighted moving average with weights of 0.4, 0.3, 0.2, and 0.1.
· Calculate the MAD and MSE for all of your forecasts.
· Start MAD and MSE calculations for moving averages in period 6.
· Start MAD and MSE calculations for exponential smoothing in period 5.
· Start MAD and MSE calculations for Weighted Averages in period 5.
· Write a 1 page article describing the different forecasting tools.
To view the chart of period and actual quantity to perform your calculations see other attachment