Exhibit 7.2 The Following Questions Are Based on the Problem Below

question 68

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 B10?

• 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(B2:C2,$B$6:$C$6)

---

Definitions:

Body Weight

The mass or heaviness of an individual, typically measured in kilograms or pounds.

Perfect Body

An idealized and often culturally influenced concept of what a human body should look like in terms of shape, size, and appearance.

Informal Survey

A non-scientific gathering of information, opinions, or feedback from a group of people without strict methodology.

Bulimia Nervosa

An eating disorder characterized by episodes of overeating, usually of high-calorie foods, followed by vomiting, laxative use, fasting, or excessive exercise.