Exhibit 11.5 The Following Questions Use the Data Below

question 64

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 E3 to compute the base level when using the multiplicative 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:

Response Time

The duration between when a customer request is made and when it is fulfilled, which is critical for customer satisfaction.

Vanquished Competitor

A competitor that has been thoroughly defeated or overcome, often no longer able to compete in the market.

Netflix

A streaming platform offering a wide variety of TV shows, movies, anime, documentaries, and more on thousands of internet-connected devices.

Property Costs

Expenses associated with owning or renting physical spaces, including warehouses, offices, or retail outlets, such as leases, taxes, maintenance, and utilities.