$($a $-25$ pts$)$ Solve H$6-$P$1($Whoop University$)$ with Excel and upload your solved Excel Model Spreadsheet

$+$ Answer Report $+$ Sensitivity Report

Answer the following questions by referring to the sensitivity report:

$($b $-3$ pts$)$ A new program costing $\backslash (\backslash$$ $50,000\backslash )$ would increase the number of Physics applicant by $200.$ Would you recommend pursuing it$?[$Choose one$]$

$-$ Yes! We can admit them all and Whoop! University will make a net of $\backslash (\backslash$$ $50,000\backslash )!$

$-$ We cannot tell from the sensitivity analysis. We will need to rerun the model

$-$ No$,$ since the incurred cost would just equal the extra tuition

$-$ No$,$ the corresponding constraint is already binding

$($c $-3$ pts $)$ Available computer hours are reduced by $10,000.[$Choose one$]$

$-$ We will need to rerun the model to identify the impact on the current admission policy

$-$ Not a problem, the current optimal admission policy won't be affected

$-$ No need to rerun the model, but $\backslash ($ Z$^\{*\}\backslash )$ will decrease by $\backslash (\backslash$$ $62,400\backslash )$

$-$ Total admitted students will be reduced by $12,600$ because of diminished resource

$($d $-3$ pts$)1,000$ additional dorm rooms are available! $[$Choose one$]$

$-$ We will need to rerun the model to identify the impact on the current admission policy

$-$ Nothing to be excited, the current optimal admission policy won't be affected

$-$ Excellent! We can admit $1,000$ extra students and the new $\backslash ($ Z$^\{*\}\backslash )$ will increase by $\backslash (\backslash$$ $2\backslash$mathrm$\{$M$\}\backslash )!$

$-$ We can admit $1,000$ extra students but the $\backslash ($ Z$^\{*\}\backslash )$ won't change

$($e $-3$ pts$)1,500$ additional Chemical Engineering students have applied! $[$Choose one$]$

$-$ All will be admitted, but the $\backslash ($ Z$^\{*\}\backslash )$ won't change

$-$ All will be admitted and the $\backslash (\backslash$mathrm$\{$Z$\}^\{*\}\backslash )$ will increase by $\backslash (\backslash$$ $1\mathrm{.}5\backslash$mathrm$\{$M$\}\backslash )!$

$-$ None will be admitted, as already a max of $3,000$ Engineering students are admitted

$-$ Only $1,200$ of them will be admitted as constraint $[6]$ specifies

$($f$-3$ pts$)$ Tuition for Civil Engineering Students just increased to $\backslash (4,000\backslash$ldots $\backslash ).$ But there is no need to modify the number of admitted Civil Eng. Students.