## (Solved) Malcomb Heizer wishes to invest his retirement fund of \$2,000,000 so that his return on investment is maximized, but he also wishes to keep the risk...

Dr. Malcomb Heizer wishes to invest his retirement fund of \$2,000,000 so that his return on investment is maximized, but he also wishes to keep the risk level relatively low. He has decided to invest his money in any of three possible ways: CDs that pay a guaranteed 4 percent; stocks that have an expected return of 14 percent; and a money market mutual fund that is expected to return 18 percent. He has decided that the total \$2,000,000 will be invested, but any part (or all) of it may be put in any of the three alternatives. Thus, he may have some money invested in all three alternatives. He has also decided to invest, at most, 30 percent of this in stocks and at least 20 percent of this in money market funds. Formulate this as a linear programming problem and carefully define all the decision variables.Formulate this problem.

I dont know how to set this up in excel qm using linear programming

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 05, 2019

Solution~000200212609.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 05, 2019

EXPERT

Tutor