please do NOT use the lingo solution as it is hard to interpret. so please, use an excel spreadsheet along with the formulas while incorporating the parameter, model, and constraints. thank you.

New Foundations Real Estate has to make a capital budgeting decision around six different projects that they have to decide if they want to undertake or not. Each of these six projects are different real estate investments that the company can undertake. For a list of the projects, see the table below. The numbers are in millions of dollars. Also, the total budget is 220 million Project 1 4 5 6 Pittsburgh Cleveland Wheeling Columbus Philadelphia Erie Apartment Shopping Medical Office Apartment Shopping Complex Mall Building Building Complex Mall $15 $5 $13 $14 $20 $9 Net Present Value ($ Millions) Expenditure Required ($ Millions) $90 $34 $81 $70 $114 $50 There are conditions that limit the investment alternatives: At least two pf the projects 1,3,5 and 6 must be undertaken If either project 3 or S is undertaker, they must bot be undertaken Project 4 cannot be undertaken unless both projects 1 and 3 are also undertaken. Objective: Determine which projects to undertake in order to maximize your net present value