I need an excel solution for this linear programming question.

This is a typical capital budgeting model. The company must decide which of the 15 potential investments to invest in -- all or nothing for each. The total investment cost must not exceed the budget, and the objective is to maximize the total NPV. In addition, there are two "side" constraints: considering investments 1 to 5 as group 1, 6 to 10 as group 2, and 11 to 15 as group 3, the company must invest in at least as many group 1 investments as in group 2 investments, and it must invest in at least as many group 2 investments as in group 3 investments. Which of the following is true of the optimal solution? Note: When you run Solver, make sure the Integer Optimality % is set to 0, to ensure that you find the optimal solution. Click here to reference the data needed to answer the question. a. More than 1% of the budget is not invested. b. By enforcing these side constraints, the company sacrifices more than $600 in optimal total NPV. C. The company should invest in exactly the same number of investments in each of the three groups. d. All of these choices are true. C D E F H 1 J K L M N o P Q 3 5 6 10 2 5010 16430 3.279 3070 9500 3.094 4 5810 17460 3.005 5940 17990 3.029 4170 14450 3.465 7 3690 11860 3.214 8 4560 14290 3.134 9 5080 16610 3.270 6350 21600 3.402 11 5060 17690 3.496 12 4660 15190 3.260 13 4100 12810 14 4130 12890 3.121 15 4470 14350 3.210 3.124 A B 1 Capital budgeting model 2 3 Input data on potential investments 4 Investment 1 5 Investment cost 6190 6 NPV 20680 7 NPV per investment dollar 7 3.341 8 9 Decisions: whether to invest 10 Investment levels 11 12 Budget constraint 13 Amount invested 14 15 16 Objective to maximize 17 Total NPV 18 binary Budget 38500 19