DrBarry Soprano Wishes to Invest His Retirement Fund of $2,200,000

Essay

Dr.Barry Soprano wishes to invest his retirement fund of $2,200,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 5 percent; stocks that have an expected return of 22 percent; and a loan sharking business that is expected to return 58 percent.He has decided that the total $2,200,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, 50 percent of this in loansharking and at least 20 percent of this in CDs.Formulate this as a linear programming problem and solve in Excel.