I am using excel for this question with the data solver, please show all steps in excel

C. Write a constraint modeling a situation in which, if projects 3 and 5 must taken, they must be undertaken simultaneously Write a constraint modeling a situation in which project I or 4 must be undertaken. but not both d. Write constraints modeling a situation where project 4 cannot be undertaken unless projects 1 and 3 also are undertaken. Revise the requirement in part (d) to accommodate the case in which, when projects 1 and 3 are undertaken. project 4 also must be undertaken. Spencer Enterprises is attempting to choose among a series of new investment alterna- lives. The potential investment alternatives, the net present value of the future stream of returns, the capital requirements, and the available capital funds over the next three years are summarized as follows: 8. Alternative Limited warehouse expansion Extensive warehouse expansion Test market new product Advertising campaign Basic research Purchase new equipment Capital funds available Net Present Value (S) 4,000 6.000 10,500 4.000 8,000 3,000 Capital Requirements ($) Year 1 Year 2 Year 3 3.000 1.000 4.000 2.500 3.500 3,500 6.000 4.000 5.000 2.000 1,500 1.800 5.000 1,000 4,000 1.000 500 900 10.500 7.000 8.750 C. a. Develop and solve an integer programming model for maximizing the net present value. b. Assume that only one of the warehouse expansion projects can be implemented. Mod- ify your model of part (a). Suppose that, if test marketing of the new product is carried out the advertising cam- paign also must be conducted. Modify your formulation of part (b) to reflect this new situation. Hawkins Manufacturing Company produces connecting mods for 4- and 6-cylinder auto 9