Please show me the excel sheet.Thank you

Question $1$: Investment Advisors, Inc., is a brokerage firm that manages stock portfolios

for a number of clients. A particular portfolio consists of $x_1$ shares of U$.$S$.$ Oil and $x_2$

shares of Huber Steel. The annual return for U$.$S$.$ Oil is $$3$ per share and the annual return

for Huber Steel is $$5$ per share. U$.$S$.$ Oil sells for $$25$ per share and Huber Steel sells for

$$50$ per share. The portfolio has $$80,000$ to be invested. The portfolio risk index $(0\mathrm{.}50$ per

share of U$.$S Oil and $0\mathrm{.}25$ per share for Huber Steel$)$ has a maximum of $700.$ In addition,

the portfolio is limited to a maximum of $1000$ shares of U$.$S$.$ Oil. The linear programming

formulation that will maximize the total annual return of the portfolio is as follows:

Max $3x_1+5x_2$

$s.t.25x_1+50x_{2}80,000$ Funds Available

$0\mathrm{.}5x_1+0\mathrm{.}25x_{2}700$ Risk maximum

$,x_1,1000US$ Oil maximum

$,x_{1}0,x_{2}0$

$(1\mathrm{.}1)$ Use Excel$-$Solver to generate the sensitivity analysis report.

$(1\mathrm{.}2)$ How many US Oil and Huber Stell shares will maximize the annual return of the

company's portfolio? What is the maximum return? Justify your answer.

$(1\mathrm{.}3)$ Assume some additional funds is available for investment. How much additional

funds would be beneficial to be used in the above investment? Justify your answer.

$(1\mathrm{.}4)$ How many constraints are non$-$binding? Justify your answer.

$(1\mathrm{.}5)$ Assume the company wanted to use $$12,000($out of $$80,000)$ of their funds in a

different project and hence it will not be used in the above investment. What would be

the impact of this change on the company's annual return? Justify your answer.