In PC Tech's product mix problem, assume there is another PC model, the VXP, that the company
Fantastic news! We've Found the answer you've been seeking!
Question:
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".
% change in selling prices | Basic | XP | VXP | Total profit | |
-25% | $ | ||||
-20% | $ | ||||
-15% | $ | ||||
-10% | $ | ||||
-5% | $ | ||||
0% | $ | ||||
5% | $ | ||||
10% | $ |
Posted Date: