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 8 hours for assembling, 3 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 is not integer-valued. If you round the values in the decision variable 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?

AutoSave On . Product Mix 1 - Saved Search Kyndel Babin KB X File Home Insert Page Layout Formulas Data Review View Help Share Comments Queries & Connections Data Analysis Get Refresh Properties Stocks Geography Sort Filter Reapply Text to CV What-If Forecast Outline Data v All v Edit Links Advanced Columns CO 5 Analysis " Sheet Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Analysis K12 X v fc B C D E F G H K M N O P Q R 1 Assembling and testing computers N Cost per labor hour assembling $11 UI AW Cost per labor hour testing $15 Inputs for assembling and testing a computer Basic XP VXP 8 Labor hours for assembly 5 6 9 Labor hours for testing 10 Cost of component parts $150 $225 11 Selling price $300 $450 12 Unit margin 13 14 Assembling, testing plan (# of computers) 15 Basic XP VXP 16 Number to produce 17 18 Maximum sales 600 1200 19 20 Constraints (hours per month) Hours used Hours available 21 Labor availability for assembling 10000 22 Labor availability for testing 3000 23 24 Net profit ($ this month) Basic XP VXP Total Model + Enter 90% Type here to search W *CP X 5:19 PM 4/15/2021