Exhibit 11.11 The Following Questions Use the Data Below

question 23

Multiple Choice

Exhibit 11.11
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using seasonal indices. 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.11. What formula should be entered in cell H3 to compute the Seasonal Forecast value for year 1 Quarter 1?

• A) =F3*VLOOKUP(B3,$B$18:$C$21,2)
• B) =F3*HLOOKUP(B3,$B$18:$B$21,2)
• C) =F3*VLOOKUP(B3,$B$18:$B$21,2)
• D) =F3*VLOOKUP(B3,$C$18:$C$21,2)

---

Definitions:

Basic Earnings

The net income divided by the weighted average number of shares outstanding, representing a company's earnings per share without any adjustments.

Common Shares

Equity securities that represent ownership interests in a corporation, providing voting rights and potential dividends to shareholders.

Preferred Shares

A class of ownership in a corporation with a fixed dividend, that has priority over common shares in the distribution of dividends and assets.

SEC Requires

Mandatory rules and requirements established by the Securities and Exchange Commission that publicly traded companies must follow to protect investors and ensure the integrity of the securities markets.