IV$.$ Construct an Excel Model and solve the optimization problem with Excel Solver.

Answer the following questions based on the results from Excel Solver.

Note: You are NOT required to submit your Excel Model.

Question $22(3$ points$)$

$$ Saved

According to the optimal solution, Emerald should NOT invest in

projects $3$ and $4$

projects $5$ and $6$

project $1$ only

projects $4$ and $6$

projects $2$ and $5$

project $2$ only

projects $2$ and $3$

Question $23(3$ points$)$

$$ Saved

Which statement is CORRECT about the optimal objective function value $Z?$

$Z$$$19,000$

$Z>$$$31,000$$$22,000$

$Z>$$$31,000$