A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 B C D Assembling and testing computers Cost per labor hour assembling Cost per labor hour testing $11 $15 Inputs for assembling and testing a computer Basic 5 1 $150 $300 XP 6 2 $225 $450 Basic XP 600 Labor hours for assembly Labor hours for testing Cost of component parts Selling price Unit margin 1200 Assembling, testing plan (# of computers) Number to produce Maximum sales Constraints (hours per month) Labor availability for assembling Labor availability for testing Net profit ($ this month) Hours used Basic Hours available 10000 3000 XP Total PC Tech product mix Background information PC Tech company assembles and tests two models of computers, Basic and XP. For the coming month, the company wants to decide how any of each model to assemble and then test. No computers are in inventory from the previous month and because these models are going to be changed after this month, the company doesn't want to hold any inventory after this month. It believes the most it can sell this month are 600 Basics and 1200 XPs. Each Basic sells for $300 and each SP sells for $450. The cost of component parts for a Basic is $150; for an XP it is $225. Labor is required for assembly and testing. There are at most 10,000 assembly hours and 3000 testing hours available. Each labor hour for assembling costs $11 and each labor hour for testing costs $15. Each basic requires five hours for assembling and one hour for testing, and each XP requires is hours for assembling and two hours for testing. PC Tech wants to know how many of each model it should produce (assemble and test) o maximize its net profit but it cannot use more labor hours than are available, and it does not want to produce more than it can sell. Object: To use LP to find the best mix of computer models that stays within the company's labor availability and maximum sales constraints. Question (Please show the work. Thank you.) 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 VP requires eight hours for assembling, three 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 in not integervalued. If you round the values in the changing 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? Question 4 (Please show the work. Thank you.) Again continuing problem 2, suppose that you want to force the optimal solution to be integers. Do this in Solver by adding a new constraint. Select the changing cells for the left side of the constraint, and in the middle dropdown list, select the \"int\" option (for \"integer\"). How does the optimal integer solution compare to the optimal noninteger solution in problem 2? Are the changing cell values rounded versions of those in problem 2? Is the objective value more or less than in problem 2