Exhibit 11.12 The Following Questions Use the Data Below

question 116

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 formula should be entered in cell I3 to compute the Seasonal Value for year 1 Quarter 1?

• A) =388.88+10.052*C3+4.248*D3+79.917*E3+296.008*F3+84.924*G3
• B) =10.052*C3+4.248*D3-79.917*E3-296.008*F3-84.924*G3
• C) =388.88+10.052*C3+4.248*D3-79.917*E3-296.008*F3-84.924*G3
• D) =I3+10.052*C3+4.248*D3-79.917*E3-296.008*F3-84.924*G3

---

Definitions:

Book

A set of written, printed, or digital pages bound together and covered, containing text or illustrations.

The Great Gatsby

A classic American novel written by F. Scott Fitzgerald, exploring themes of decadence, idealism, and resistance to change in the 1920s.

Shakespearean Play

A dramatic work authored by William Shakespeare, famed for their rich language, complex characters, and profound themes.

Concept

An abstract idea representing the fundamental characteristics of what it represents.