***Please show all formulas and steps

Project-SelectionTeam at ABC must evaluate 50 three-year-long projects whose characteristics are given below.

The company has $2M and 20 project managers availailable each year (each project requires a manager).

The company policy is that at most 4 projects selected can be high-risk projects.

The NPV and Cost (in thousands) is given below.

Which of the 50 projects should ABC select in order to maximize Total NPV (assume 0.1% Integer Optimality)

	Total NPV:
DO IT?		NPV	Risk Level	Cost Year 1	Cost Year 2	Cost Year 3
	Project 1	318	High	86	91	96
	Project 2	493	Medium	146	155	133
	Project 3	123	High	34	33	37
	Project 4	565	High	153	152	155
	Project 5	176	Medium	50	47	47
	Project 6	205	Low	57	55	56
	Project 7	211	Medium	62	60	60
	Project 8	347	High	99	103	103
	Project 9	551	Medium	164	149	152
	Project 10	226	Medium	64	70	63
	Project 11	452	Medium	130	123	122
	Project 12	106	Medium	31	31	29
	Project 13	418	Low	125	113	126
	Project 14	183	High	53	51	52
	Project 15	450	High	135	126	124
	Project 16	531	Medium	142	166	154
	Project 17	189	Low	56	58	58
	Project 18	315	Medium	88	86	93
	Project 19	152	High	45	46	45
	Project 20	309	High	86	87	86
	Project 21	550	Low	156	150	157
	Project 22	470	Low	148	138	145
	Project 23	265	Medium	79	71	78
	Project 24	537	Low	156	162	163
	Project 25	357	High	113	96	113
	Project 26	329	Medium	97	96	90
	Project 27	449	High	140	132	124
	Project 28	377	Medium	103	101	115
	Project 29	374	Medium	111	110	114
	Project 30	484	Low	148	147	149
	Project 31	482	Low	130	149	140
	Project 32	464	High	125	127	133
	Project 33	580	Medium	181	173	182
	Project 34	558	Medium	171	165	156
	Project 35	276	High	83	75	77
	Project 36	458	Low	129	130	124
	Project 37	106	High	30	32	32
	Project 38	390	Medium	122	108	114
	Project 39	290	Medium	81	78	91
	Project 40	220	Medium	65	69	69
	Project 41	573	Medium	157	155	166
	Project 42	468	Medium	129	139	137
	Project 43	245	High	68	70	68
	Project 44	189	High	52	57	56
	Project 45	431	High	119	134	117
	Project 46	540	Medium	158	170	165
	Project 47	181	Low	53	56	52
	Project 48	391	High	116	119	121
	Project 49	554	High	173	165	169
	Project 50	564	High	170	164	153