From Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets (Fredrick Hillier, 6th Edition.). Can you provide step by step solution using Solver on Excel? 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 1 and 2 cannot both be selected together. Formulate the problem as a linear program and determine the optimal solution. Project 1 2 3 Cost $275,000 $235,000 $230,000 $225,000 $240,000 Net Present Value $750,000 $730,000 $760,000 $460,000 $600,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