show all the excel formulas

C D 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 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 29 252 123 Project 6 141 848 80 283 19 84 Project 7 545 203 220 54 44 Project 8 808 150 113 67 Project 9 101 638 282 141 37 Project 10 55 841 214 54 130 Project 11 72 164 224 271 51 Project 12 79 546 225 150 35 Project 13 107 699 101 218 43 Project 14 90 599 255 202 3 Project 15 75 655 152 211 85 59 Instructions Problem 1 Problem 2 Problem 3 Problem 4 Ready Problem Circular References