[Solved] Your Director of Supply Chain needs help in developing - #80093

Assignment Type: Individual Project Deliverable Length: 1 or more excel or other worksheets

Your Director of Supply Chain needs help in developing forecasts. Choose one of the following three options.

Develop forecasts for periods 6 through 24 using MA with 3 periods, 4 periods, and 5 periods, or…

Develop forecasts for periods 3 through 24 using a smoothing factor of 0.2 and 0.3, or…

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.

To view the chart of period and actual quantity to perform your calculations, click here.

Please submit your assignment.

Solution: