Exhibit 11.5 The Following Questions Use the Data Below

question 76

Multiple Choice

Exhibit 11.5
The following questions use the data below.
A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the multiplicative seasonal effects model.
-Refer to Exhibit 11.5. What formula should be entered in cell E7 to compute the remaining expected levels?

• A) =$J$3*(D7/F3) + (1-$J$3)*E6
• B) =$J$3*(D7/D6) + (1-$J$3)*E6
• C) =$J$4*(D7/D3) + (1-$J$4)*E6
• D) =$J$4*(D7/D6) + (1-$J$4)*E6

---

Definitions:

Aggressive Teens

Adolescents who frequently exhibit anger, hostility, or violent behavior, often due to a combination of environmental, psychological, and genetic factors.

Peers

Individuals who are equal to another in abilities, qualifications, age, background, and social status, often used to describe people of the same age group.

Elderly Population

The demographic group consisting of individuals typically aged 65 and older.

Poor Health

A general state characterized by physical, emotional, or mental unwellness, often resulting from disease, lifestyle choices, or environmental factors.