Exhibit 11.8 The Following Questions Use the Data Below

question 6

Multiple Choice

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 E7 to compute the base level value for year 2 Quarter 1?

• A) =$D$17+(1-$D$17)*(E6+F6)
• B) =$D$17*D7/G3+(1-$D$17)*(E6+F6)
• C) =$D$17*D7/G3+(1-$D$17)
• D) =$D$17*D7/G3+($D$17)*(E6+F6)

---

Definitions:

Blood Pressure-Lowering Medication

Drugs prescribed to reduce high blood pressure, thereby lowering the risk of heart disease and stroke.

Cholesterol-Lowering Medication

Refers to drugs used to reduce the levels of cholesterol in the blood, which can help prevent cardiovascular diseases.

Senior Citizen

A term referring to individuals who have reached an advanced age, generally considered to be 65 years or older in many societies.

Off Campus Job

An Off Campus Job refers to employment opportunities located outside of the educational institution's premises.