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:

Performance Improvement Plan

A formal plan developed to help employees improve their performance in specific areas that have been identified as deficient.

Performance Management Plan

The documented plan of performance objectives set for the employee to achieve over the upcoming appraisal period.

Recency Effect

Refers to the psychological phenomenon where the most recently presented information is more likely to be remembered than older information.

Rater Bias

The influence of a reviewer's personal prejudices or preferences on the evaluation of another's performance or work.