Forecast forfirstquarter of year 6.
Mean Squared Error (MSE)
Mean Absolute Percentage Error (MAPE)

Forecast forfirstquarter of year 6.
Mean Squared Error (MSE)
Mean Absolute Percentage Error (MAPE)

Optimal =
Forecast forfirstquarter of year 6.
Mean Absolute Percentage Error (MAPE) for the optimal

Forecast forfirstquarter of year 6.
Mean Squared Error (MSE)
Mean Absolute Percentage Error (MAPE)

Optimal =
Forecast forfirstquarter of year 6.
Mean Squared Error for the optimal- (MSE)

Equation for the Trend Line
Forecast forQ1year 6
Forecast forQ2year 6
Forecast forQ3year 6
Forecast forQ4year 6

	Interpretation
S1=
S2=
S3=
S4=

Forecast forQ1year 6
Forecast forQ2year 6
Forecast forQ3year 6
Forecast forQ4year 6

Mean Absolute Percentage Error (MAPE) for theTrend Line Method
Mean Absolute Percentage Error (MAPE) for theTrend + Seasonality Method
Mean Absolute Percentage Error (MSE) for theTrend Line Method
Mean Absolute Percentage Error (MSE) for theTrend + Seasonality Method

										=INTERCEPT( Y-Range,X-Range)
Quarterly Umbrella Sales (Million Dollars)					=SLOPE(Y-Range,X-Range)
Year	Quarter -1=Fall,2=Winter,3=Spring, 4=Summer	time	Sales			Error	Mean Absolute Error (MAE)	(MAPE)	Squared of Error
Year	Q	time	Yt	Trend Line Tt =b0+b1 t	Trend + Seasonality Y^=Tt xSt	(Y-Y^)	IY-Y^I	(( IY-Y^I ) / Y )	(Y-Y^)2
1	1	1	$275
1	2	2	$685
1	3	3	$153
1	4	4	$99
2	1	5	$259
2	2	6	$721
2	3	7	$192
2	4	8	$114
3	1	9	$304
3	2	10	$645
3	3	11	$163
3	4	12	$90
4	1	13	$240
4	2	14	$614
4	3	15	$180
4	4	16	$122
5	1	17	$286
5	2	18	$739
5	3	19	$184
5	4	20	$108
						MAE	MAPE	MSE