Compute a weighted three-month moving average forecast using weights of (a) 10%, 30%, 60%, and (b) 25% 30% 45% for the most distant data, next recent, and the most recent respectively.
The manager of a fabric company needs to accurately
|
Month |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
|
Demand |
37 |
45 |
47 |
50 |
52 |
54 |
58 |
60 |
63 |
65 |
Forecast Table:
|
Month |
Actual |
WMA (10%, 30%, 60%) |
WMA (25%, 30%, 45%) |
|
January |
|
|
|
|
February |
|
|
|
|
March |
|
|
|
|
April |
|
|
|
|
May |
|
|
|
|
June |
|
|
|
|
July |
|
|
|
|
August |
|
|
|
|
September |
|
|
|
|
October |
|
|
|
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
