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

Question: 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

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 That is, the return will be realized only if the project is successful (use the "Yes-No" 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

★★★★★

3.48 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Data Project 1 Project 2 Project 3 Project 4 Project 5 Available Expected Return NPV 180000 2... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

749-M-S-S-D (3369).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

The permeability of a membrane used as a moisture barrier in a biological application depends on the thickness of two integrated layers. The layers are normally distributed with means of 0.5 and 1...

The permeability of a membrane used as a moisture barrier in a biological application depends on the thickness of three integrated layers. Layers 1, 2, and 3 are normally distributed with means of...

The lives of refrigerators are normally distributed with mean = 14 years and standard deviation = 2.5 years. (a) Draw a normal curve with the parameters labeled. (b) Shade the region that...

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...

Helpful hint: The following topics/concepts are covered in this homework, in no particular order (different problems cover different concepts): Class 6: Discrete Probability Distributions The...

1. Suppose that the gain from a portfolio during a 6-month holding period is normally distributed with mean $12 million and standard deviation $18 million. What of the following is closest to the VaR...

In this problem you are trying to value an employee stock option. The option is granted with a 4 year vesting period; i . e . , it can only be exercised only after 4 years from the time it is...

In this problem you are trying to value an employee stock option. The option is granted with a 4 year vesting period; i.e., it can only be exercised only after 4 years from the time it is granted....

1.3 (5 points) Two stocks have the following expected returns and standard deviations Stock Stock Expected return Standard Deviation A 10% 12% B 15% 20% Consider a portfolio of A and B, and let w,...

you have been given this probability distribution for the holding - period return for XYZ stock with an initial price of $ 1 0 0 : The state of the Economy can be: Boom, Normal growth or recession,...

Q.4 Suppose that a company like Calm Ltd Products and Chemicals is considering building a new lights-out facility and has gathered the following information: Purchase price K600, 000 Residual value...

Use the data in Problem to prepare the Daughtry Cosmetics statement of retained earnings for the year ended December 31, 2010. Use the Statement of Retained Earnings for Maxim, Inc., in the...

The tremendous growth in assets under management of open - end funds was fuelled by two sources: a high rate of return in the capital markets and huge inflows of new capital due in large part to the...

(a) Distinguish between the direct method and the indirect method of calculating the amount of cash generated from an entity's operations. (b) List the main steps in the accounting work required if...

Compute the number of observations required in a work-sampling study if the standard deviation is 0.2 minute and there should be a 90 percent chance that the sample mean has an error of (a) 0.15...

Exhibit A.10 shows a partially completed time-study worksheet. Determine the standard time for this operation.

Using a fatigue allowance of 20 percent, and given the following time-study data obtained by continuous time measurement, compute the standard time.

Scanlin, Inc., is considering a project that will result in initial aftertax cash savings of $1.73 million at the end of the first year, and these savings will grow at a rate of 3 percent per year...

Solve for the probability functions In each situation below, is it reasonable to use a binomial distribution for the random variable X? Give reasons for your answerin each case. {a} A random sample...

For December 31,20xx, the balance sheet of the Gardner Corporation is as follows: Sales for 20XY were $293.000, with cost of goods sold being 63 percent of sales. Amortization expense was 14 percent...