Product Mix Problem PC Tech company assembles and tests two models of computers - Basic and XP Following tables gives all the associated data Model Basic XP Selling price 300 450 Component COS 150 225 Assembly Hour 5 6 Tosting hours 1 2 10,000 assembly hours and 3000 testing hours available Assembling labor hour costs $11 and testing labor hour costs $15 PC Tech company can sell at most 600 Basic and 1200 XP models Objective is to determine the product mix to maximize profit Extension to the problem covered in the video for Assignment 1: In PC Tech's product mix problem above, assume there is another PC model, the VXP model that the company can produce in addition to Basics and XPs. Each VXP requires eight hours for assembling three hours for testing, 5275 for component parts, and sells for $560. At most 50 VXPs can be sold. 1. Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix. 2. You should find that the optimal solution is not integer-valued. You can round the values in the decision variable cells to the nearest integers, but make sure it is still a feasible solution that covers all the constraints Problem 2: 10 points - Explained in the ProcuctMix Computer Sales (Basic vs XP) video. This problem needs to be extended to include the VXP model. Most of the work is available in the video, but you will need to add the 3rd model and re-solve