Exhibit 11.4 The Following Questions Use the Data Below

question 21

Multiple Choice

Exhibit 11.4
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using the additive seasonal method. The store has collected 12 quarters of data and needs your help to analyze the data.
-Refer to Exhibit 11.4. What formula should be entered in cell F7 to compute the seasonal factor using the additive seasonal effects model?

• A) =$J$3*D4+(1-$J$3)*(E3+F3)
• B) =$J$4*(D7-E7)+(1-$J$4)*F3
• C) =$J$4*(E7-E6)+(1-$J$4)*E6
• D) =$J$3*G3+(1-$J$3)*(D3+G3)

---

Definitions:

Stocks Traded

Refers to the buying and selling of stock shares on financial markets.

NYSE

An abbreviation for New York Stock Exchange, one of the largest securities exchanges in the world.

Money Market Instrument

Short-term debt instruments, often with high liquidity and low risk, used by companies and governments to manage their finances efficiently.

Commercial Paper

An unsecured, short-term debt instrument issued by corporations, typically used for the financing of payroll, accounts payable, and inventories.