Question

This is my 3rd time posting .. Please show step by ste how the answer is solved as in show what was clicked in SOLVER and which cells were selected .

USE SOLVER IN EXCEL TO ANSWER PROBLEM. Show step by step how you got your answer SOLVER | 387 18-2. Seven new projects are being proposed for our division. Each would require investments over the next three years, but each ultimately would result in a positive return on our investment. Expenditures in S Millions Return Project Year 1 Year 2 Year 3 in s Millions 1 5 4 3 A B С D E F G 8 9 4 2 فما 7 8 9 4 2 8 20 36 28 20 18 12 40 1 3 6 3 9 The CEO has decided that we have a maximum of $25 million each year to invest. Just on the basis of the numbers, which combination of projects should we invest in so that the sum of the returns is maximized? Set up a worksheet and use Solver to come up with a solution. You should set up the worksheet so there is a cell for each project that contains either a l (meaning we invest in the project) or a 0 (meaning we do not invest in the project). Solver should find the combination of l's and 0's that maximizes the sum of the returns subject to the constraints. • In the Text Box, tell the CEO which projects the company should invest in to maximize the return.

Answer 1

Eupenditure Total project | Retwan Yout- teat-2 years expendit Profit 5 1 20-00 A 6 14 B The Seven new 36.00 I 20 C 28.00 15 2 3 being proposed Garrow! division. 1 du ca 20.00 9 u E. 18.00 7 Iz € 3 2 12.00 Me alout prolecen las manon in above The coo has decided that we have a manimum of $ 25 million each yonul.to prve poroblema invent. 23 8 J G ogoh 6 8 a 23 I? Total (B. c. & G) 13 I 3 22 85. 46 * lr is 'best inven in project ins Giciando SIP20 Ans!