please show excel formulas

Get Data (Power Data from Refresh Query) Picture All Edit Links A1 X V fx 4. Capital Rationing (25 points) B C D Formula Bar F G 2 4. Capital Rationing (25 points) 3 Pfizer has identified 15 R&D projects that will tie up money and researchers for the next two years. It cannot undertake all of these projects since it has limited available resources. The CFO wants to know which projects should be undertaken in order to maximize NPV, Use Solver to advise the 4 CFO. The summary of the projects and available resources is provided in the table below. NPV Cost Yr 1 Cost Yr 2 Labor Yr 1|Labor Yr 2 9 Available Resources 1800 2300 700 750 10 Project 1 928 398 180 111 108 11 Project 2 908 151 269 139 86 12 Project 3 801 129 189 56 61 13 Project 4 543 275 218 54 70 14 Project 5 944 291 252 123 141 15 Project 6 848 80 283 19 84 16 Project 7 545 203 220 54 44 17 Project 8 808 150 113 67 101 18 Project 9 538 282 141 37 55 19 Project 10 841 214 54 130 72 20 Project 11 64 224 271 51 79 21 Project 12 546 225 150 35 107 22 Project 13 699 101 218 43 90 23 Project 14 599 255 202 3 75 24 Project 15 655 152 211 85 59 25 26 27 28 29