The potential revenues of all projects are in fact uncertain

[Uncertain Scenario – Maximizing the Mean]

The potential revenues of all projects are in fact uncertain. The company determines that the revenue for project 1 is following a uniform distribution ranging from $1,200,000 to $2,000,000. The revenue for project 2 is distributed normally, with a mean of $1,500,000 and a standard deviation of $200,000. The revenue for project 3 follows a triangular distribution with a minimum of $1,350,000, maximum of$1,600,000, and it is most likely to be $1,500,000. The revenue for project 4 is distributed normally, with a mean of $1,800,000 and a standard deviation of $800,000. The bank wants to find the optimal solution which takes all these uncertainties into account

a.) In a worksheet, demonstrate the uncertainties. Find the optimal solution which can maximize the average uncertain profit. Paste screen shoots of your model with formulas, model with solutions, solver setting, simulation setting, and the output distribution of the uncertain profit (Hint: you will have to use Psi distribution functions, Psi statistics functions, and simulation optimization)

b.) What is the optimal solution that can maximize average uncertain profit?

[Uncertain Scenario – Minimizing the Probability of Low Profit] The Company also would like to know the optimal solution if the objective is to minimize the probability of having a profit that is less than $1,800,000.

c.) In another worksheet, modify your model from a and find the optimal solution for this new objective. Paste screen shoots of your model with formulas, solutions, and your solver setting. What is the optimal solution that can minimize the probability of having a profit that is less than$1,600,000?

[Uncertain Scenario – Maximizing the Probability of High Profit]

d.) Repeat a, but with a new objective to maximize the probability of having at least $2,500,000 of profit. Paste screen shoots of your model with formulas, solutions, and your solver setting. What is the optimal solution that can maximize the probability of having at least $2,600,000 of profit?

e.) Discuss the optimal solutions you found from all scenarios. If you are the CEO of the company, which solution would you adopt and why?