Please answer both questions and show work in Excel. Images of the Excel and Formulas is fine

Trinity Amusement Corporation is considering investing $160 million for capital projects this year. The managers have examined various possibilities and have proposed five projects to consider. The projects cover a variety of activities, as listed below: P1: Implement a new ride application system. P2: License a new technology from another firm. P3: Build a state-of-the-art hydration facility. P4: Install automated ticket processing machines. P5: Outsource security team members. There is just one project of each type. Each project has an estimated net present value (NPV) and each requires a capital expenditure, which must come out of the allocated budget. The following table summarizes the possibilities, with all figures in millions of dollars: P5 P1 10 48 NPV Expenditure Projects P3 16 80 P2 17 96 P4 8 32 14 64 The committee would like to maximize the total NPV from projects selected, subject to the budget limit of $160 million. a) (20 pts) Determine which projects should be selected to maximize the total NPV. b) (10 pts) If at most one of Project 3 and Project 4 can be selected AND Project 4 requires Project 5, how does your solution from part a change? Please interpret the impact of these changes on your solution