Modeling.Consider the Excel portfolio analysis in class with 6 projects (See table below of class excel). 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.

ProjectValue12345P7.10.201.53.51.50.5P7.20.312.53.51.50P7.30.4233.51.50

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?

Class excel

Required Budget by YearRequired WorkSame ProjectProjectDecisionValue12345Product 1Product 2P1P2P1.110.15321001010P1.200.1221.51.5101010P1.300.11.51.51.5111010P2.100.34.55.56650101P2.200.26345540101P2.310.181.52.52.5200101P300.16222000100P410.19011.51.51.51000P510.2522.552.511000P600.2101.53.51.50.50000Total0.776.581062.53111Constraint10101010101111