4. Capital Rationing (25 points) 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 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 Available Resources 1800 2300 700 750 Project 1 928 398 180 111 108 Project 2 908 151 269 139 86 Project 3 801 129 189 56 61 Project 4 543 275 218 54 70 Project 5 944 291 252 123 141 Project 6 848 80 283 19 34 Project 7 545 203 220 54 44 Project 8 808 150 113 67 101 Project 9 638 282 141 37 55 Project 10 841 214 54 130 72 Project 11 164 224 271 51 79 Project 12 546 225 150 35 107 Project 13 699 101 218 43 90 Project 14 599 255 202 3 75 Project 15 655 152 211 85 59