Display the model on a spreadsheet. Use Excel Solver to solve the model by the simplex

method. What is the optimal objective value?

$($c$)$ Use the sensitivity analysis report to answer the following questions:

$-$ What is the optimal value of the dual variable for the cash flow requirement in each year?

$-$What is the reduced cost of Asset $3$ in the optimal solution? How do you interpret this value?

$-$ Will the optimal basic solution change if the investment cost of Asset $1$ becomes $$1\mathrm{.}5$M$?$ What

will be the optimal objective function value in this case? Answer without resolving if possible.