- Get Data Power Query A1 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 V 24 25 26 27 Data From Picture 1 24 Capita 1 (184.44 KiB) Viewed 38 times
Get Data (Power Query) A1 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 V 24 25 26 27 Data from Picture 1 24. 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. Available Resources Project 1 Project 2 Project 3 Project 4 Project 5 Project 6 Project 7 Project 8 Project 9 Project 10 Project 11 Project 12 Project 13 Project 14 Project 15 B Refresh All fx 4. Capital Rationing (25 points) C 928 908 801 543 944 848 545 808 638 841 164 546 699 599 655 Queries & Connections Properties Edit Links NPV Cost Yr 1 1800 398 151 129 275 291 80 203 150 282 214 224 225 101 255 152 D Formula Bar F 700 111 139 56 54 123 19 54 67 37 130 51 35 43 3 85 Stocks Cost Yr 2 Labor Yr 1 Labor Yr 2 2300 180 269 189 218 252 283 220 113 141 54 271 150 218 202 211 750 108 86 61 70 141 84 44 101 55 72 79 107 90 75 59 Currencies G P