Click on the above Link to open a Spreadsheet file with Weekly Data to calculate the 3 Week Weighted Moving Avg Forecasts. next calculate the Goodness Criteria, particularly MAD.

Based on your calculations, the MAD is =

	a.	5.37
	b.	3.30
	c.	3.46
	d.	6.84
	e.	4.11

Data for 3 Week Weighted Moving Average Forecasting USE THE FOLLOWING WEIGHTS (W) Ft=A(t-1)*W(t-1) +A(t-2)*W/t-2)+At-3)*Wit-3) W(t-1)- 50% W(t-2)= 30% Wit-3)= 20% Total(W) 100% 6. UwN 6 Week (t) Sale (At) F(t) 1 $90.00 2 $95.00 3 $85.00 $100.00 85*50%+95*30%+90*20% 5 $102.00 Drop the A1 and A4 in the above Formula to get the F5 (Forecast for Week 5) $98.00 Calcualte allthe remaining Forecast and then Calculate the Goodness Criteria. $96.00 $110.00 $112.00 10 $115.00 11 $108.00 12 $107.00 13 $118.00 14 $120.00 15 $122.00 16 $116.00 17 $114.00 18 $127.00 19 $130.00 20 7 8