Question: Complete the forecasting worksheets for: Nave Average Moving Average Weighted Moving Average using the weights of .8, .15, and .05 with .8 being the most
Complete the forecasting worksheets for:
Nave
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 using and alpha level of .75
ExponB will automatically be .25 when A is .75
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 |
| 1 | 115 |
| 2 | 118 |
| 3 | 128 |
| 4 | 122 |
| 5 | 135 |
| 6 | 128 |
| 7 | 135 |
| 8 | 132 |
| 9 | 132 |
| 10 | 135 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
