Please formulate a model first and solve it using Excel Solver. Thanks!

Problem 1 (30 points) The board of directors of Serious Cybernetics Company is considering 7 large capital investments. Each investment can be made only once. The capital requirements and estimates profits of the 7 potential investments are given in the table below (millions). Est. Profit Investment Opportunity 1 2 3 Req. Capital 43 28 34 48 17 32 23 17 10 15 19 7 13 9 4 5 6 7 There total amount of capital available is $100M. Investment opportunities 1 and 2 are mutually exclusive. Investment opportunities 3 and 4 are also mutually exclusive. Furthermore, neither 3 nor 4 can be undertaken unless one of the first two opportunities is undertaken. Projects 5 and 7 have synergies such that if both projects are undertaken, you expect to obtain an extra 5M in profit. What investments should Serious Cybernetics make