Modeling. Consider the Excel portfolio analysis in class with 6 projects. Suppose another project was added and the annual funding is increased from 10 to 12. Project 7 has three funding levels and supports Product 1. See the following table with value and cost data.

(Class excel)

Modeling. Consider the Excel portfolio analysis in class with 6 projects. Suppose another project was added and the annual funding is increased from 10 to 12 . Project 7 has three funding levels and supports Product 1 . See the following table with value and cost data. a. What is the maximum number of portfolios that must now be considered? (All are not feasible) b. What is the new maximum total value? c. How much value can you obtain if you could change the funds in the 5 years but not exceed the total funding of 60 ? d. For this example, which creates more value: adding the new alternative or removing the annual budget constraint after the alternative is added