The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using the additive seasonal method. The store has collected 12 quarters of data and needs your help to analyze the data.

	A	B	C	D	E	F	G	H	I	J
1			Time	Actual	Base	Seasonal	Predicted
2	Year	Qtr	Period	Sales	Level	Factor	Sales
3	1	1	1	284	331.25	47.250			alpha	0.764
4		2	2	184	331.25	147.250			beta	1.0
5		3	3	365	331.25	33.750
6		4	4	492	331.25	160.750
7	2	1	5	485	484.85	0.146	284.00
8		2	6	277	438.54	161.541	337.60
9		3	7	606	540.72	65.279	472.29
10		4	8	722	556.41	165.591	701.47
11	3	1	9	763	714.17	48.827	556.56
12		2	10	593	745.02	152.022	552.63
13		3	11	912	822.74	89.260	810.30
14		4	12	1145	942.47	202.534	988.33
15
16							17688.777

Refer to Exhibit 11.4. What formula should be entered in cell F7 to compute the seasonal factor using the additive seasonal effects model?

a. =$J$3*D4+(1-$J$3)*(E3+F3)

b. =$J$4*(D7-E7)+(1-$J$4)*F3

c. =$J$4*(E7-E6)+(1-$J$4)*E6

d. =$J$3*G3+(1-$J$3)*(D3+G3)