$.$ Go back to the PC Tech product mix model. Run Excel Solver and produce Sensitivity Analysis Report.

Answer the impact of following changes on your optimal solution using Excel Sensitivity Analysis Report if

possible. Notice that this question might not be straightforward. Feel free to rerun Solver if you face a

problem that cannot be answered using the sensitivity report you created. You do not have to do that

though! Make sure to show your steps though!

$2$

a$.$ Let the selling price for Basic decrease from $$300$ to $$240.$

Hint: Potential answers

i$)$ The profit will increase by $$33600.$

ii$)$ The profit will decrease by $$33600.$

iii$)$ There is no change to the objective function value and optimal solution.

iv$)$ We cannot use the current sensitivity analysis report to answer this question. We need to

rerun Excel.

b$.$ Let the labor cost per hour for assembling change from $$11$ to $$20.$

c$.$ Let the labor hours for testing a Basic change from $1$ to $\mathrm{.}5.$

d$.$ Let the labor hours for testing a Basic change from $1$ to $3.$

e$.$ Let the total availability of assembly hours increase to $10100.$

f$.$ Let the total availability of testing hours increase to $3300.$

g$.$ Let the max XP requirement be $1180$