As a Data Analyst you have been asked to evaluate and select which projects should be supported. You have received twenty proposals and found that only seven projects are in$-$line with the company$$s mission. Unfortunately, the budget will not support them all. The funding requirements are summarized below along with the NPV the company expects to generate from each project. Capital $($in $$1,000$s$)$ Required in

Project Expected NPV $($in $$1,000$s$)$ Year $1$ Year $2$ Year $3$ Year $4$ Year $51$ $$70$ $$20$ $$30$ $$40$ $$50$ $$102$ $$80$ $$90$ $$0$ $$25$ $$20$ $$353$ $$70$ $$40$ $$20$ $$13$ $$40$ $$204$ $$75$ $$45$ $$25$ $$15$ $$30$ $$155$ $$65$ $$65$ $$30$ $$25$ $$25$ $$256$ $$90$ $$35$ $$35$ $$30$ $$0$ $$307$ $$85$ $$20$ $$25$ $$20$ $$30$ $$20$

The company currently has $$150,000$ available to invest in new projects.$$It has budgeted $$125,000$ for continued support for these projects in years $2$ and $3,$ and $$100,000$ per year for years $4,$ and $5.$ Surplus funds in any year are reappropriated for other uses within the company and may not be carried over to future years.

a$.$ What is the total net present value of the accepted projects? $$\_\_\_$

$($Remember to convert the answer back into "thousands" $...$Do not use commas $","$ in your answer... example $134225)$

b$.$ Which project$($s$)$ will be accepted?

Project $1\_\_\_($Enter either $...$ yes or no $)$

Project $2\_\_\_$

Project $3\_\_\_$

Project $4\_\_\_$

Project $5\_\_\_$

Project $6\_\_\_$

Project $7\_\_\_$

c$.$ How much capital was required in year $1?$ $$\_\_\_($Remember to convert the answer back into "thousands" $...$Do not use commas $","$ in your answer... example $134225)$