Exhibit 11.10 The Following Questions Use the Data Below

question 83

Multiple Choice

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

• A) B3:B14
• B) C3:C14
• C) C3:D14
• D) C3:E14

---

Definitions:

Operating Leverage

The degree to which a company's net income can be affected by a change in sales, influenced by the proportion of fixed costs in a company's cost structure.

Salesvolume

The total amount of a product sold within a specific period.

Degree of Operating Leverage

A financial ratio that measures the sensitivity of a company's operating income to its sales volume, highlighting the impact of fixed costs.

Variable Expenses

Costs that vary directly with the level of production or sales volume.