In: Finance
Use the information in the 1st table (Weights & Periods) to fill in the missing values in the second table
Weights Applied | Period |
5 | Last month |
3 | Two months ago |
1 | Three months ago |
Month | Actual Sales | 3-Month Weighted Moving Average |
January | 100 | |
February | 150 | |
March | 130 | |
April | 160 | ( ( * 100 ) + ( * ) + ( * ) / = 133 |
May | 120 | ( ( * 150 ) + ( * ) + ( * ) / = 133 |
June | 110 | ( ( * 130 ) + ( * ) + ( * ) / = 133 |
July | 130 | ( ( * 160 ) + ( * ) + ( * ) / = 133 |
In any month, projected sales = Weighted Average of previous three months sales
Hence, your answers will be :
Month | Actual Sales | 3-Month Weighted Moving Average |
January | 100 | |
February | 150 | |
March | 130 | |
April | 160 | ((1* 100) + (3*150) + (5*130) / 9) = 133 |
May | 120 | ((1*150) + (3*130) + (5*160) / 9) = 149 |
June | 110 | ((1*130) + (3*160) + (5*120) / 9) = 134 |
July | 130 | ((1*160) + (3*120) + (5*110) / 9) = 119 |