EXCEL

$2.$ 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 x$1$ x$2$ lhs$$ rhs$$ Objective function value Notes: Step $1$ Decision Variables $56012001.$ Values that are boxed are the model parameters $2.$ Green: coefficients of objective function $($ c$)$ Step $2$ Objective Function $801291996003.$ Blue: coefficients of constraints$4.$Values that are changing Step $3$ Constraint $1561000010000$ C$15.$ Values that are in dashed boxes are changing Constraint $21229603000$ C$26.$ Red: Objective function value Constraint $31560600$ C$37.$ Orange: Decision variable values Constraint $4112001200$ C$48.$ Purple: lhs value of constraint Orange values Constraint $1$ Purple $($C$1)$ sumproduct$($C$12$:D$12,$C$16$:D$16)$ Constraint $2$ Purple $($C$2)$ sumproduct$($C$12$:D$12,$C$17$:D$17)$ Constraint $3$ Purple $($C$3)$ sumproduct$($C$12$:E$12,$C$18$:E$18)$ Constraint $4$ Purple $($C$4)$ sumproduct$($C$12$:E$12,$C$19$:E$19)$ Objective function Red sumproduct$($C$12$:D$12,$C$14$:D$14)$