Exhibit 7.2 The Following Questions Are Based on the Problem Below

question 9

Multiple Choice

Exhibit 7.2
The following questions are based on the problem below.
An investor has $150,000 to invest in investments A and B. Investment A requires a $10,000 minimum investment, pays a return of 12% and has a risk factor of .50. Investment B requires a $15,000 minimum investment, pays a return of 10% and has a risk factor of .20. The investor wants to maximize the return while minimizing the risk of the portfolio. The following multi-objective linear programming (MOLP) has been solved in Excel.
-Refer to Exhibit 7.2. What formula goes in cell B11?

• A) =SUMPRODUCT(B2:C2,$B$6:$C$6)/$D$7
• B) =B2*C2+B3*C3
• C) =SUMPRODUCT(B3:C3,$B$6:$C$6)/$D$7
• D) =SUMPRODUCT(B3:C3,$B$6:$C$6)

---

Definitions:

Team Effectiveness

The measure of a team's ability to achieve its goals and objectives in an efficient and timely manner.

Resource Inputs

The raw materials, labor, and other resources used in the production of goods and services.

Team Process

The sequence of actions, interactions, and methods used by a team to achieve its objectives efficiently.

Team Effectiveness

The extent to which a team achieves its objectives, meets the needs of its members, and sustains itself over time.