Each variable and solution must be clearly indicated on the excel worksheet, do not just solve the question, clearly define each variable and comment on the objective function and sensitivity analysis (explain each resulting sensitivity analysis page). Sensitivity analysis pages without your comments will not be graded.

6. The company has a portfolio of investments in shares, bonds and other investment alternatives. Now it has available funds amounting to $200,000 which must be considered for new investments. The four investment alternatives that Company is contemplating are offered in table below. The measure of risk indicates uncertainty associated with the share in terms of its capacity to reach the annual return foreseen; the higher the value, the greater the risk. The company has stipulated the annual rate of return from this portfolio must be at least 9% and no value can represent more than 50% of the total investment in dollars. a. Use the linear programming model to develop a portfolio of investments which minimizes the risk. b. If the firm ignores the risk involved and uses a maximum return strategy on its investment, how will the former model be amended? (Find the solutions using excel solver and carry out sensitivity analysis)