Exhibit 11.7 The Following Questions Use the Data Below

Multiple Choice

Exhibit 11.7
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using Holt's method. The store has collected 12 quarters of data and needs your help to analyze the data.
-Refer to Exhibit 11.7. What formula should be entered in cell F4 to compute the trend when using Holt's method?

A) =$J$3*D4+(1-$J$3) *(E3+F3)
B) =$J$4*(E4-E3) +(1-$J$4) *F3
C) =$J$4*(E4-E3) +(1-$J$4) *G3
D) =$J$4*G3+(1-$J$4) *(D3+G3)