Solve all three parts, show a screenshot of your excel sheet on how you set up the constraints and variables and using solver.

A company is planning to invest exactly $1 million among four bonds. The expected annual return, the worst-case annual return, and the duration of each bond are given in the table below. (The duration of a bond is a measure of the bond's sensitivity to interest rates.) The company wants to maximize the expected return from its bond investments, subject to three constraints: * The worst-case return of the bond portfolio must be at least 8%. * The average duration of the portfolio must be at most 6 . (For example, a portfolio that invests $600,000 in bond 1 and $400,000 in bond 4) has an average duration of [600,000(3)+400,000(9)]/1,000,000=5.4.) * Because of diversification requirements, at most 40% of the total amount invested can be invested in a single bond. Develop a linear program to determine how the company can maximize the expected return on its investment. Answer the following questions in the highlighted cells below: a) What is the maximum expected return (in \$) that can be achieved under these circumstances? b) By how much would the optimal expected return increase if they had one additional dollar to invest? c) By how much could the expected return for Bond 1 decrease without changing the optimal allocation of funds? HINT: This can be set up as a blending problem, but it doesn't necessarily have to be