Question: 2 (Please show the work. Thank you.) In PC Tech's product mix problem, assume there is another PC model, the VXP, that the company can
2 (Please show the work. Thank you.) 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 VP requires eight hours for assembling, three hours for testing. $275 for component parts, and sells for $560. At most 50 VXPs can be sold. a) Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix. b) You should find that the optimal solution in not integervalued. If you round the values in the changing cells to the nearest integers, is the resulting solution still feasible? If not, how might you obtain a feasible solution that is at least close to optimal? Question 4 (Please show the work. Thank you.) Again continuing problem 2, suppose that you want to force the optimal solution to be integers. Do this in Solver by adding a new constraint. Select the changing cells for the left side of the constraint, and in the middle dropdown list, select the \"int\" option (for \"integer\"). How does the optimal integer solution compare to the optimal noninteger solution in problem 2? Are the changing cell values rounded versions of those in problem 2? Is the objective value more or less than in problem 2
Step by Step Solution
There are 3 Steps involved in it
To solve the problem lets break it down into the two parts of the question Part a Modify the spreadsheet model to include the new product VXP and use Solver to find the optimal product mix 1 Objective ... View full answer
Get step-by-step solutions from verified subject matter experts
