In PC Techs 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 produced. Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix. What is your solution?

Assembling and Testing Computers Cost per labor hour assembling 11 Cost per labor hour testing, line 1 $ 19 Cost per labor hour testing, line 2 $ 17 Input for assembling and testing a computer Model 1 Model 2 Model 3 Model 4 Model 5 Model 6 Model 7 Model 8 Labor hours for assembly 4 5 5 5 5.5 5.5 5.5 6 Labor hours for testing, line 1 1.5 2 2 2 2.5 2.5 2.5 3 Labor hours for testing, line 2 2 2.5 2.5 2.5 3 3 3.5 3.5 Cost of component parts $ 150 $ 225 $ 225 $ 225 $ 250 $ 250 $ 250 $ 300 Selling price $ 350 $ 450 $ 460 $ 470 $ 500 $ 525 $ 530 $ 600 Unit margin, tested on line 1 Unit margin, tested on line 2 Assembling, testing plan (# of computers) Model 1 Model 2 Model 3 Model 4 Model 5 Model 6 Model 7 Model 8 Number tested on line 1 Number tested on line 2 Total computers produced Maximum sales Constraints (hours per month) Labor availability for assembling Labor availability for testing, line 1 Labor availability for testing, line 2 Net profit ($ per month) Tested on line 1 Tested on line 2