Need step-by-step solution via Excel Solver. From Chapter 7.2 (Using BIP for Project Selection) of Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets (Fredrick Hillier, 6th Edition.). Please do not respond just to say you cannot solve this, which delays others from answering. Many thanks.

Your employer is trying to select from a list of possible capital projects. The projects, along with their cost and benefits, are listed below. The capital budget available is $1 million. In addition to spending constraints, your employer would like to select at least 3 projects. Projects 3 and 5 cannot both be selected together. Formulate the problem as a linear program and determine the optimal solution. Project 1 2 3 Cost $250,000 $245,000 $290,000 $280,000 $245,000 Net Present Value $600,000 $410,000 $780,000 $480,000 $570,000 4 5 Which projects should be selected? Project 1 will Project 2 will Project 3 will Project 4 will Project 5 will What is the total net present value of these projects? Total net present value