Exhibit 11.12 The Following Questions Use the Data Below

question 111

Multiple Choice

Exhibit 11.12
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using a seasonal regression model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is provided in the following table.
-Refer to Exhibit 11.12. What is the Input X Range in the Regression command settings dialog box?

• A) $C$3:$C$14
• B) $H$3:$H$14
• C) $C$3:$G$14
• D) $H$3:$I$14

---

Definitions:

Derived Demand

A demand for a product or service that arises from the demand for another product or service. For example, demand for steel is derived from the demand for automobiles.

Decoupling Inventories

Inventories held to separate or buffer different stages of the production process, reducing dependency and potential disruptions.

Anticipated Change

A forecasted or expected modification in conditions, trends, or operations that may impact future performance.

Derived Demand

Demand that is not for the goods or services themselves but results from the demand for another good or service.