Model Assignment This problem is just adding an extra computer to the example model in the online videos.

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 sold.

How many of each computer type should the company produce?

Setup the Excel model in preparation to use Solver. Use proper color-coding; there should

be four colors (inputs, changing cells, constraints, objective cell).

Use Solver to find a solution. Do NOT use integer constraints for your solution. It is okay to

have answers with decimal places.

Create Answer, Sensitivity, and Limits reports for the model.