1.

Month	Sales
January	$450,000
February	$375,000
March	$425,000
April	$475,000
May	$375,000
June

1. Using a 2 month moving average what would be the sales forecast be for June
2. Using a 3 month moving average what would be the sales forecast be for June
3. Using a 4 month weighted average with the following weight (30% for the most recent period, 25%for the next period, 25% for the next period and 20% for the furthest period) What would the sales forecast be for the month of June

2.

TSV	Forecast	Error	Sq Error
71
70	71	-1.00	1
69
68
64

Using a= .1 for exponential smoothing, complete the above chart

What is the Forecast for period 6?

What is the sum of the squared errors?

What is the Mean Squared Error?