Please show steps. Question is located on the right and data is on the left

1 Assembling and testing computers Problem 2 (24 points) a) You need to modify the spreadsheet provided to include the VXP computers. Then you need to find the new optimal solution. I will look at the optimal number of computers to produce and at 2 the value of the objective function. (12 points). part a. Is the solution still feasible? Basically check if the number of hours used is still less than the number of hours available (6 3 Cost per labor hour assembling $11 points). If the rounded solution was not feasible, look for integer values closed to the ones obtained on part a (by trial and error), until you find an optimal combination that maximizes the value of the Cost per labor hour testing $15 objective function AND is feasible. (6 points). 5 Inputs for assembling and testing a computer 7 Basic XP 8 Labor hours for assembly 5 6 9 Labor hours for testing 1 2 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 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 Total