Solve question 11 ( data in question 10). No paperwork, use excel formulas and models step by step. SOLVE QUESTION 11

10. (10 points) Algoma Engineering Company (AEC) is trying to decide which of 6 projects to perform during the next quarter. The net present value, the estimated cost, and the number of engineers and staff personnel required for each project are given in the following table. Project Net Present Cost ($1000's) Engineers Staff Required Value ($1000's) Required 100 35 2 145 65 8 3 200 95 11 2 250 180 4 2 500 250 16 7 6 695 475 19 11 OWN- New AEC has a $550,000 budget and 30 engineers and 15 staff available. Required: Solve this LP model by using Excel and computer Which projects should AEC perform during the quarter? 11. (10 points) For the Algoma Engineering Company (AEC) problem in question 10, suppose the budget is increased to $600,000 and that the additional engineers or additional staff (but not both) can be hired so that only one of the engineer or staff limitations must hold (ie, at least one of the two constraints holds). Also, if project 2 is performed, project 5 will not be performed, at least two of projects 1, 2, and 3 should be performed, and if project 3 is performed, project 4 should be performed. Required: Solve this LP model by using Excel and computer Which projects should AEC undertake under these conditions