B 14. Capital Rationing (25 points) 2 Pfizer has identified 15 R&D projects that will tie up money and researchers for t
Posted: Mon Jul 11, 2022 11:51 am
- B 14 Capital Rationing 25 Points 2 Pfizer Has Identified 15 R D Projects That Will Tie Up Money And Researchers For T 1 (201.29 KiB) Viewed 32 times
- B 14 Capital Rationing 25 Points 2 Pfizer Has Identified 15 R D Projects That Will Tie Up Money And Researchers For T 2 (189.47 KiB) Viewed 32 times
B 14. Capital Rationing (25 points) 2 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 3 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 4 available resources is provided in the table below. 5 6 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 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 Problem 1 C NPV Cost Yr 1 1800 398 151 129 275 291 80 203 150 282 214 224 225 101 255 152 928 908 801 543 944 848 545 808 638 841 164 546 699 599 655 D Problem 2 Cost Yr 2 2300 180 269 189 218 252 283 220 113 141 54 271 150 218 202 211 E Labor Yr 1 700 111 139 56 54 123 19 54 67 37 130 51 35 43 3 85 Problem 3 F Labor Yr 2 750 108 86 61 70 141 84 44 101 55 72 79 107 90 75 59 Problem 4 G + Problem 5 H + J K M N O P
Home Paste H9 10 11 12 13 14 15 16 17 18 19 20 21 Excel File Edit View Insert AutoSave OFF 22 23 24 25 26 27 Insert X A Draw Page Layout Times New Roman BIUV C ✓ fx 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 C ✓ 16 928 908 801 543 944 848 545 808 638 841 164 546 699 599 655 V NPV Cost Yr 1 1800 398 151 129 275 291 80 203 150 282 214 224 225 101 255 152 Format Tools Data Window Help 9. Formulas Data Α Α΄ V V www D E 1 4. Capital Rationing (25 points) 2 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 lim 3 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 4 the projects and available resources is provided in the table below. 5 6 7 8 9 Cost Yr 2 Labor Yr 1 2300 180 269 189 218 252 283 220 113 141 54 271 150 218 202 211 Review 700 111 139 56 54 123 19 54 67 37 130 51 35 43 3 85 F View 75 59 Labor Yr 2 750 108 86 61 70 141 84 44 101 55 72 79 107 ab G Assignment 1 Tell me H General $%9 1 500-0000 J K L V Conditional Format Formatting as Table M N