Exhibit 11.6 The Following Questions Use the Data Below

question 96

Multiple Choice

Exhibit 11.6
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 double moving average model with k = 4.
-Refer to Exhibit 11.6. What formula should be entered in cell H9 to compute the trend using the double moving average model with k = 4?

• A) =2*(AVERAGE(E9,F9))/4
• B) =2*(E9-F9)/(4-1)
• C) =2*(E9-F9)/(4*2)
• D) =2*(D9-F9)/(4-1)

---

Definitions:

Buying Decision Process

A series of steps consumers go through, including need recognition, information search, evaluation of alternatives, purchase decision, and post-purchase behavior.

Vendor Rating System

A method used by businesses to evaluate and rank suppliers based on performance criteria such as quality, delivery time, price, and compliance.

Postpurchase Behavior

The actions and reactions of consumers after buying and using a product, which can include product reviews, repeat purchases, or complaints.

Buying Committee

A group of individuals within an organization responsible for making purchase decisions, typically involving high-value products or services.