I need help with formulating the pictured problem in Excel to get the results for (a) and (b).

Pictured below is what I have in Excel so far and Problem 3.1.

I also need help inputting the constraints in Excel Solver for the problem.

A B C D E F G H 1 Problem 3.1 (Project selection problem) 3 * Coefficients * Decision Variables 12 * Objective Function * Constraints rhs 13 Max z= 21 Note that & decision variables are zero-one 22 binary variables. So, be sure to add an integer 23 constraint, =binary, in Excel - Solver., * Problem 3.1 (Project selection problem): A company wants to invest on some of projects. (Either the entire project is selected or not at all.) Each of the six projects has a cost and yields a revenue as shown below. Project | Cost (in $million) Revenue (in $million) 1 510 $12 2 540 850 3 $55 856 4 560 75 5 $15 518 6 530 533 The company has a total budget $150 (in $million) that cannot be exceeded. The goal 1s to invest the capital in such a way that 1t maximizes the total revenue. Formulate this situation as a zero- one integer program and {ind the optimal solution. (4 points) (a) What 1s the maximum revenue that can be obtained? (b) Suppose that (1) we can choose no more than three projects and (1) 1if Project #3 1s selected, then Project #4 cannot be selected. In this situation, what 1s the maximum revenue that can be obtained