Examlex

Solved

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. 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)
-Refer to Exhibit 7.2. What formula goes in cell B11?


Definitions:

Social Involvement

The degree to which an individual participates in a broad range of social activities and engages with their community.

Happiness

A state of well-being and contentment characterized by positive emotions and fulfillment.

Children

Young human beings who are not yet adults, characterized by rapid physical growth, cognitive development, and emotional maturation.

Young Adults

Young adults are individuals who are in a transitional stage of physical and psychological development that generally occurs during the period from the late teens through the twenties.

Related Questions