What is the expected value of perfect information

Assignment Help Operation Management

Reference no: EM132148634

Show your work with Excel and Solver:

The senior executives of an oil company are trying to decide whether or not to drill for oil in a particular field in the Gulf of Mexico. It costs the company $1,000,000 to drill in the selected field. Company executives believe that if oil is found in this field its estimated value will be $4,000,000. At present, this oil company believes there is a 45% chance that the selected field actually contains oil. Before drilling, the company can hire a geologist at a cost of $60,000 to prepare a report that contains a recommendation regarding drillin in the selected field. In many similar situations in the past where this geologist has been hired, the geologist has predicted oil on 75% of all fields that have contained oil, and has predicted no oil on 85% of all fields that have not contained oil.

First consider the case when hiring the geologist is not an option. Should the company drill for oil?

Construct a decision table to represent this problem. Also, construct the regret table.

Using an EXCEL spread sheet determine: What should the company do if senior management:

is risk prone (optimistic)?

is risk averse (pessimistic)?

wants to maximize his average amount of money it makes?

What is the expected value of perfect information (of whether or not oil is really there)?

Reference no: EM132148634

Questions Cloud

What does the term contribution mean : In the basic break-even equation, the term contribution is used. What does the term contribution mean here? What does this number tell the manager?

Equity theory perspective : How might providing employees with a shortened workday contribute to motivation from an equity theory perspective? Also from a need theory perspective?

Compute the probabilities needed to solve the decision tree : Compute the probabilities needed to solve the decision tree?

What tools did you use to evaluate the diet : Pick a popular weight loss diet and evaluate it using the tools introduced in Lesson 1- which was- My plate. Does the diet provide an appropriate amount of all.

What is the expected value of perfect information : What is the expected value of perfect information (of whether or not oil is really there)?

Would a shortened workday : Would a shortened workday help improve productivity and decrease worker stress level?

What does the speaker mean by the nutritional floor : This podcast, Preventing Malnutrition: Addressing Undernutrition in Young U.S. Children by Dr. Robert Murray, will provide a good foundation for understanding.

Exponential distribution analysis could be used for work : Where an exponential distribution analysis could be used for work efficiency within a government entity would be and why?

Simulate gate-based 64-bit acl adder design : Device family to be used for the project is MAX II which is selected by default in Quartus - You can provide the schematics in a hierarchical manner

User Account

All Pages