Exhibit 11.4 The Following Questions Use the Data Below

question 105

Multiple Choice

Exhibit 11.4
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.
-Refer to Exhibit 11.4. What formula should be entered in cell E3 to compute the base level when using the additive seasonal effects method?

• A) =AVERAGE($E$3:$E$6)
• B) =AVERAGE(E3, E7, E11)
• C) =AVERAGE($D$3:$D$6)
• D) =AVERAGE(D3, D7, D11)

---

Definitions:

Optimal Level

The most efficient, beneficial, or favorable point in a process or activity, often associated with achieving the best outcome or maximum productivity.

Public Good

A good that is non-excludable and non-rivalrous, where one person's enjoyment of the good does not diminish the ability of others to enjoy it, typically provided by the government.

Market Demand Curve

A graphical representation showing the quantity of a good that all consumers in a market are willing to purchase at various prices.

Public Good

A product or service that is made available to all members of a society by the government or a private entity, characterized by non-excludability and non-rivalry in consumption.