Exhibit 11.12 The Following Questions Use the Data Below

question 48

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 Excel command can be used in cells F4:F14 in lieu of a formula based on the regression statistics?

• A) =TREND($H$3:$H$14,$C$3:$G$14, C3:G3)
• B) =TREND($H$3:$H$14,$B$3:$G$14, B3:G3)
• C) =TREND($H$3:$H$14,$A$3:$G$14, A3:G3)
• D) =TREND($H$3:$H$14,$C$3:$D$14, C3:D3)

Grasp the concepts of direct vs. indirect expenses and controllable vs. uncontrollable costs.

Understand the principles of responsibility accounting and its performance reporting.

Comprehend the importance and method of allocating indirect expenses.

Learn the evaluations and responsibilities of investment center managers.

---

Definitions:

Elastic Bandage

A stretchable bandage used to create localized pressure, commonly utilized to reduce swelling and support injured joints or muscles.

Severe Strain

A significant or extensive injury to a muscle or tendon, caused by overstretching or tearing.

Swelling

An increase in size or volume of a body part, typically resulting from inflammation or accumulation of fluid.

Wound Dressing

The application of materials (such as bandages, gauze, or plasters) to a wound to protect it from infection, absorb discharge, and promote healing.