Question: Three Period Weighted Moving Average Using Formulas, fill out each of the forecasts in the shaded boxes below. Assume that you are working with historical
Three Period Weighted Moving Average
Using Formulas, fill out each of the forecasts in the shaded boxes below. Assume that you are working with historical data and you wish to view what forecasts might have been for the previous year. Round to whole numbers.
| 3- Weighted Moving Average (0.6, 0.3, 0.1) | ||
| Jan | 1050 | |
| Feb | 940 | |
| Mar | 870 | |
| Apr | 830 | |
| May | 870 | |
| Jun | 750 | |
| Jul | 800 | |
| Aug | 690 | |
| Sep | 885 | |
| Oct | 925 | |
| Nov | 890 | |
| Dec | 740 | |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
