The sensitivity report for the investment problem in Problem $3$ is in the worksheet named

$$Investment $2.$ Use the report to answer the following questions.

a$.(2$ Points$)$ In cell C$23,$ input the word $$yes$$ or $$no$$ to indicate if a greater return on RE

could change the optimal solution.

b$.(2$ Points$)$ In cell C$24,$ input the word $$yes$$ or $$no$$ to indicate if a return on CD of $7\%$

would change the optimal solution.

c$.(2$ Points$)$ In cell C$25,$ input the value that represents the maximum amount the return on

MF $($in percent terms$)$ could increase without changing the optimal solution.

d$.(2$ Points$)$ In cell C$26,$ input the value that represents the maximum decrease in return on

Bonds $($in percent terms$)$ that would result in the optimal solution remaining unchanged.

e$.(2$ Points$)$ The requirement that $$at least $$250$ be allocated to each investment$$ serves as a

set of constraints. In cell C$27,$ enter either the word$($s$)$Slack$,,$Surplus$,$Shadow

Price,$$Reduced Value,$$ or $$Amount Used$$ to indicate the difference between the

minimum required investment of $$250$ and the actual amount allocated to each investment.