Complete the forecasting worksheets for: Naïve Average Moving Average Weighted Moving Average using the weights of .8, .15, and .05 with .8 being the most current, then .15, then .05 ExponA use an alpha level of .75 ExponB use an alpha level of .25 Exponential Solver What is the best alpha level as determined by the Exponential Solver? Which is the best forecasting option for MAE? What is the MAE? Which is the best forecasting option for MAPE? What is the MAPE? Period Sales This is the data for the forecasting template 1 115 2 118 3 128 4 122 5 135 6 128 7 135 8 132 9 132 10 135
Complete the
Naïve
Average
Moving Average
Weighted Moving Average using the weights of .8, .15, and .05 with .8 being the most current, then .15, then .05
ExponA use an alpha level of .75
ExponB use an alpha level of .25
Exponential Solver
What is the best alpha level as determined by the Exponential Solver?
Which is the best forecasting option for MAE? What is the MAE?
Which is the best forecasting option for MAPE? What is the MAPE?
Period Sales This is the data for the forecasting template
1 115
2 118
3 128
4 122
5 135
6 128
7 135
8 132
9 132
10 135
Trending now
This is a popular solution!
Step by step
Solved in 7 steps with 13 images
