Question: 23. For the project selection example, suppose that the returns in the objective function are normally distributed with means as given by the expected returns

23. For the project selection example, suppose that the returns in the objective function are normally distributed with means as given by the expected returns and standard deviation equal to 10% of the mean. However, also assume that each project has a success rate modeled as a Bernoulli distribution. That is, the return will be realized only if the project is successful (use the “Yes–

No” distribution in Crystal Ball ). Success rates for the five projects are 0.80, 0.70, 0.90, 0.40, and 0.60, respectively.

Modify the spreadsheet model, and use OptQuest to find a solution that maximizes the mean return.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Essential Statistics Questions!