Question: Here is the data to work with: Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Using
Here is the data to work with:
| Week | Auto Sales |
| 1 | 8 |
| 2 | 10 |
| 3 | 9 |
| 4 | 11 |
| 5 | 10 |
| 6 | 13 |
| 7 | - |
Using the Naive Method the MAD for the forecast of weeks 4-7=2
Using a 3-week moving average method the MAD for the forecast of weeks 4-7 =1.67
-----------------------------------------------------------------
HERE IS MY QUESTION:
Develop a 3-week weighted-moving average and make a forecast for week 4-7 using the following weights. What is the MAD for your forecast?
| Weights | Period |
| 3 | Last week |
| 2 | Two weeks ago |
| 1 | Three weeks ago |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
