Answer Problem 3 ONLY!!!!!!!

2. (15 pts) Western Engineering Company 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 Cost ($1000's) Staff Required Engineers Required 1 2 3 4 5 6 Net Present Value ($1000's) 100 145 200 250 500 695 35 65 95 180 250 475 5 8 11 4 16 19 2 3 2 2 7. 11 Western has a $550,000 budget and 30 engineers and 15 staff available. Which projects should Western perform during the quarter? Provide LP formulation (10 pts) and solve using excel Solver (5pts). 3. (5 pts) Refer to Problem 2 and 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 (i.e. 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. Which projects should Western undertake under these conditions? Provide LP formulation only