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:

Transformational Leadership

A style of leadership where the leader works with teams or followers to identify needed change, creating a vision to guide the change through inspiration and executing the change in tandem with committed members of the group.

Contingent Reward

A leadership approach where rewards are given based on the performance and achievement of specific criteria or goals by the followers.

Transformational Leadership Factors

Elements that contribute to transformational leadership, including inspirational motivation, individualized consideration, intellectual stimulation, and idealized influence.

Transformational Leadership

A leadership approach that causes change in individuals and social systems, characterized by the leader working with teams to identify needed change, creating a vision to guide the change through inspiration, and executing the change in tandem with committed members of the group.