Exhibit 11.8
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using Winter's method. The store has collected 12 quarters of data and needs your help to analyze the data.
-Refer to Exhibit 11.8. What formula should be entered in cell H7 to compute the Predicted Sales value for year 2 Quarter 1?
A) =SUM(E6:F6)*G3
B) =SUM(E6:F6)+G3
C) =SUM(E6:F6)
D) =SUM(E6:G3)

Question

Exhibit 11.8
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using Winter's method. The store has collected 12 quarters of data and needs your help to analyze the data. 
-Refer to Exhibit 11.8. What formula should be entered in cell H7 to compute the Predicted Sales value for year 2 Quarter 1?
A) =SUM(E6:F6)*G3 
B) =SUM(E6:F6)+G3 
C) =SUM(E6:F6) 
D) =SUM(E6:G3)

Quizplus · Accepted Answer

The formula in cell H7 should be =SUM(E6:F6)*G3. This formula multiplies the sum of the values in cells E6 and F6 by the value in cell G3. The result is the Predicted Sales value for year 2 Quarter 1.

Exhibit 11.8 The Following Questions Use the Data Below