In PC Tech$$s product mix problem, $($See Attached excel $-$ I need help with setting parameters in solver$)$ assume there is another PC model, the VXP$,$ that the company can produce in addition to Basics and XPs$.$ Each VXP requires eight hours for assembling, three hours for testing, $$275$ for component parts, and sells for $$560.$ At most $50$ VXPs can be sold. Perform a sensitivity analysis where the selling prices of Basics and XPs simultaneously change by the same percentage, but the selling price of VXPs remains at its original value. Let the percentage change vary from $-25\%$ to $10\%$ in increments of $5\%,$ and keep track of the values in the decision variable cells and the total profit. Round your answers to nearest whole number. If your answer is zero, enter $"0".$

$\%$ change in selling prices Basic XP VXP Total profit

$-25\%$

$

$-20\%$

$

$-15\%$

$

$-10\%$

$

$-5\%$

$

$0\%$

$

$5\%$

$

$10\%$

$

Discuss your findings.

As the $\%$ change in selling price increases, the optimal mix

Select

with

Select

pattern, but the optimal profit always

Select

$.$eBook

In PC Tech's product mix problem, assume there is another PC model, the VXP$,$ that the company can produce in addition to Basics

and XPs$.$ Each VXP requires eight hours for assembling, three hours for testing, $$275$ for component parts, and sells for $$560.$ At

most $50$ VXPs can be sold. Perform a sensitivity analysis where the selling prices of Basics and XPs simultaneously change by the

same percentage, but the selling price of VXPs remains at its original value. Let the percentage change vary from $-25\%$ to $10\%$ in

increments of $5\%,$ and keep track of the values in the decision variable cells and the total profit. Round your answers to nearest

whole number. If your answer is zero, enter $"0".$

Discuss your findings.

As the $\%$ change in selling price increases, the optimal mix

alwaysAssembling and testing computers