20 pts. Deleting input data is optional but solver settings must be saved. Project-Selection Team at ABC must evaluate 50 three-year-long projects whose characteristics are given below. Managers: 22 The company has a limited budget each year and limited number of managers (each project requires a manager). Budget Year 1: 2200 The company policy also limits the number of high-risk project selected. Budget Year 2: 2100 The NPV and Cost (in thousands of dollars) is given below. Budget Year 3: 2000 Which of the 50 projects should ABC select in order to maximize the Total NPV? Max no. of High Risk: 5 Required setting in Options: assume 0.1% Integer Optimality. No. of Projects Selected: No. of. High-Risk Projects Selected: Total NPV: Options When changing solver options, do not change anything else other that what the problem is asking. 4 B 13 Selected 14 15 16 17 18 19 20 347 High 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 D E G . NPV Risk Level Cost Year 1 Cost Year 2 Cost Year 3 318 High 86 91 96 493 Medium 146 155 133 123 High 34 33 37 565 High 153 152 155 176 Medium 50 47 47 205 Low 57 55 56 211 Medium 62 60 60 99 103 103 551 Medium 164 149 152 226 Medium 64 70 63 452 Medium 130 123 122 106 Medium 31 31 29 418 Low 125 113 126 183 High 53 51 52 450 High 135 126 124 531 Medium 142 166 154 189 Low 56 58 58 315 Medium 88 86 93 152 High 45 46 45 309 High 86 87 86 550 Low 156 150 157 470 Low 148 138 145 265 Medium 79 71 78 537 Low 156 162 163 357 High 113 96 113 329 Medium 97 96 90 140 132 124 377 Medium 103 101 115 374 Medium 111 110 114 484 Low 148 147 149 482 Low 130 149 140 464 High 125 127 133 580 Medium 181 173 182 558 Medium 171 165 156 276 High 83 75 77 458 Low 129 130 124 106 High 30 32 32 390 Medium 122 108 114 290 Medium 81 78 91 220 Medium 65 69 69 573 Medium 157 155 166 468 Medium 129 139 137 245 High 68 70 68 189 High 52 57 56 431 High 119 134 117 540 Medium 158 170 165 181 Low 53 56 52 391 High 116 119 121 554 High 173 165 169 564 High 170 164 153 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 Project 16 Project 17 Project 18 Project 19 Project 20 Project 21 Project 22 Project 23 Project 24 Project 25 Project 26 Project 27 Project 28 Project 29 Project 30 Project 31 Project 32 Project 33 Project 34 Project 35 Project 36 Project 37 Project 38 Project 39 Project 40 Project 41 Project 42 Project 43 Project 44 Project 45 Project 46 Project 47 Project 48 Project 49 Project 50 38 39 40 41 449 High 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 20 pts. Deleting input data is optional but solver settings must be saved. Project-Selection Team at ABC must evaluate 50 three-year-long projects whose characteristics are given below. Managers: 22 The company has a limited budget each year and limited number of managers (each project requires a manager). Budget Year 1: 2200 The company policy also limits the number of high-risk project selected. Budget Year 2: 2100 The NPV and Cost (in thousands of dollars) is given below. Budget Year 3: 2000 Which of the 50 projects should ABC select in order to maximize the Total NPV? Max no. of High Risk: 5 Required setting in Options: assume 0.1% Integer Optimality. No. of Projects Selected: No. of. High-Risk Projects Selected: Total NPV: Options When changing solver options, do not change anything else other that what the problem is asking. 4 B 13 Selected 14 15 16 17 18 19 20 347 High 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 D E G . NPV Risk Level Cost Year 1 Cost Year 2 Cost Year 3 318 High 86 91 96 493 Medium 146 155 133 123 High 34 33 37 565 High 153 152 155 176 Medium 50 47 47 205 Low 57 55 56 211 Medium 62 60 60 99 103 103 551 Medium 164 149 152 226 Medium 64 70 63 452 Medium 130 123 122 106 Medium 31 31 29 418 Low 125 113 126 183 High 53 51 52 450 High 135 126 124 531 Medium 142 166 154 189 Low 56 58 58 315 Medium 88 86 93 152 High 45 46 45 309 High 86 87 86 550 Low 156 150 157 470 Low 148 138 145 265 Medium 79 71 78 537 Low 156 162 163 357 High 113 96 113 329 Medium 97 96 90 140 132 124 377 Medium 103 101 115 374 Medium 111 110 114 484 Low 148 147 149 482 Low 130 149 140 464 High 125 127 133 580 Medium 181 173 182 558 Medium 171 165 156 276 High 83 75 77 458 Low 129 130 124 106 High 30 32 32 390 Medium 122 108 114 290 Medium 81 78 91 220 Medium 65 69 69 573 Medium 157 155 166 468 Medium 129 139 137 245 High 68 70 68 189 High 52 57 56 431 High 119 134 117 540 Medium 158 170 165 181 Low 53 56 52 391 High 116 119 121 554 High 173 165 169 564 High 170 164 153 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 Project 16 Project 17 Project 18 Project 19 Project 20 Project 21 Project 22 Project 23 Project 24 Project 25 Project 26 Project 27 Project 28 Project 29 Project 30 Project 31 Project 32 Project 33 Project 34 Project 35 Project 36 Project 37 Project 38 Project 39 Project 40 Project 41 Project 42 Project 43 Project 44 Project 45 Project 46 Project 47 Project 48 Project 49 Project 50 38 39 40 41 449 High 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63