Exhibit 11.4 The Following Questions Use the Data Below

question 81

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 E7 to compute the remaining expected levels?

• A) =$J$3*(D7-D3) + (1-$J$3)*E6
• B) =$J$3*(D7-D6) + (1-$J$3)*E6
• C) =$J$4*(D7-D3) + (1-$J$4)*E6
• D) =$J$4*(D7-D6) + (1-$J$4)*E6

---

Definitions:

Horyuji Kondo

The main hall of the Horyuji temple, notable for its architectural significance and historical value as one of the oldest wooden structures in the world.

Tori Busshi

A celebrated Japanese sculptor from the Asuka period, known for his Buddhist statues.

Ise Shrine

A Shinto shrine in Ise, Japan, dedicated to the goddess Amaterasu, that is famously rebuilt every 20 years in accordance with Shinto beliefs about death, renewal, and impermanence.

Amaterasu

The Shinto sun goddess and one of the major deities in Japanese mythology, symbolizing the universe’s life-giving forces.