Question

NARRBEGIN: SA_111_116
An oil company is trying to determine the amount of oil that it can expect to recover from an oil field. The unknowns are: the area of the field (in acres), the thickness of the oil-sand layer, and the primary recovery factor (in barrels per acre per foot of thickness). Based on geological information, the following probability distributions have been estimated
Estimate of Productive Area
Acres Probability
9,000 0.05
10,000 0.10
11,000 0.15
12,000 0.35
13,000 0.25
14,000 0.10
Estimate of Pay Thickness
Smallest Value: 15 ft
Most Likely Value: 50 ft
Largest Value: 120 ft

Estimate of Primary Recovery
Minimum Value: 20 bbl./acre-ft
Maximum Value: 90 bbl./acre-ft
The amount of reserves that can be produced is then the product of the area, thickness, and recovery factor:
Number of barrels = Productive Area x Pay Thickness x Primary Recovery Factor
NARREND
(A) Use @RISK distributions to generate the three random variables and derive a distribution for the amount of reserves. What is the amount we can expect to recover from this field?
(B) The production output is a product of three very different types of input distributions. What does the output distribution look like? What are the implications of the shape of this distribution?
(C) What is the standard deviation of the recoverable reserves? What are the 5th and 95th percentiles of this distribution? What does this imply about the uncertainty in estimating the amount of recoverable reserves?
(D) Suppose you think oil price is normally distributed with a mean of $65 per barrel and a standard deviation of $10. How much revenue do you expect the field produce (ignore discounting)?
(E) Finally, your engineer is uncertain about costs to drill wells to develop the field, but she thinks the most likely cost will be $1.7Bn, although it could be as much as $3Bn or as little as $1Bn. What is your expected profit from the field?
(F) What is the chance that you will loose money? Is this a risky venture?

Answer

This answer is hidden. It contains 853 characters.