Question

Sheet1

Month	Sales	Moving Avg (5)	Moving Avg (6)	Moving Avg (7)	Weighted Moving Avg
January	20
February	21
March	15
April	14
May	13
June	16
July	17
August	18
September	20
October	20
November	21
December	23
January	22
February	19
March	21
April
1. Generate as many valid forecasts as you can for a five-period moving average, a six-period moving average, a 7-period moving average,
and a weighted average forecasts with weights 0.4, 0.3, 0.2, and 0.1 for the most recent data, the next most recent data, and so forth, respectively.
2. Calculate MAD for each forecast. Insert columns as necessary.
3. Recommend a forecast and explain why that is your choice.
4. Use Excel for all calculations.