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)?