please answer all aspects of the question and use Excel attached

2) Suppose you company has the following investment projects available to invest in. Capital (in $1,000s) Required in Selected? (Owno, Expected NPV (in Project 1 yes) $1,000s) 1 0 $192 2 0 $264 3 0 $166 4 0 $98 5 0 $425 6 0 $154 Capital Required Capital Available Year 1 Year 2 $125 $45 $90 $25 $60 $50 $25 $15 $100 $15 $10 SO $0 $325 $225 Year 3 $35 $5 $20 $15 $25 $30 $0 $125 Year 4 $25 $10 $25 $10 $30 $20 $0 $100 Year 5 $15 $35 $10 $10 $25 $35 $0 $75 $50 Total NPV $ $ 3) Construct a model using Solver to determine the subset of these 6 projects that will maximize the total NPV achieved, while not overspending the available capital in any year. Which projects are selected and what is the total NPV achieved? b) Now suppose that projects 1, 3, and represent alternatives for producing a certain part for a product. Thus, the company wants to ensure that no more than one of these three alternatives are selected. What is the optimal (maximum NPV) set of projects under this condition? What is the total NPV achieved? Capital (in $1,000s) Required in Selected? (O=no, Expected NPV (in Project 1=yes) $1,000s) 1 0 $192 2 0 $264 3 0 $166 4 0 $98 5 0 $425 6 0 $154 Capital Required Capital Available Year 1 $125 $90 $60 $25 $100 $50 Year 2 $45 $25 $50 $15 $15 $10 Year 3 $35 $5 $20 $15 $25 $30 Year 4 $25 $10 $25 $10 $30 $20 Year 5 $15 $35 $10 $10 $25 $35 $325 $225 $125 $100 $75 Total NPV