Get in touch with us
Send us an e-mail
Question
You work for a large international oil company searching for oil off the coast of Australia, not too far from Melbourne, Your firm has acquired drilling rights at two locations, sites A and B, and you are contemplating your firm's options,
1. First consider site A alone. The estimated drilling cost is $40 million. For simplicity, assume that if you drill at this site, there are two possible outcomes; either there is oil at the site or there is no oil. Based on the available data, your geologists assign a 20% chance that there is oil at the site (the site is classified as "wet"). If there is oil, your geologists believe that the expected present value of a well in this location is $180 million. If there is no oil (the site is classified as "dry"), assume that the value of the drilled site is $0.
a) i. Should you drill at site A? (Show Excel Decision Tree and explain why/why not you would drill in comprehensive detail.)
ii. How does the optimal decision change as the "wet" probability changes? (Show in Excel using Bayes’ rule and describe in comprehensive detail.)
*See Finding the probabilities by Bayes’ rule in Appendix of this document as reference!
iii. Calculate the break-even probability both algebraically and using Goal Seek in Excel. (Show in Excel and describe in comprehensive detail– including what done for Goal Seek.)
b) Suppose you could find out definitively whether or not there was oil at this site, before deciding whether to drill.
i. What is the most you would be willing to pay for this information? (Show in Excel and describe in comprehensive detail.)
ii. How does the Expected Value with perfect information (EVPI) change as "wet" probability changes? (Show Excel EVPI Decision Tree and EV without perfect information and describe in comprehensive detail.)
*See EVPI/Bayes’ Rule examplein Appendix of this document as reference!
c) Although you cannot resolve all the uncertainty about whether the site contains oil, you can gather some information. In particular, you can do seismic testing. In this procedure, one sets off explosives on the ocean floor and measures the seismic waves at other points on the ocean floor. From the seismic data, one can construct a 3D image of the subsurface geology and see if there are structures that may form an oil reservoir. Your geologists estimate that most (30%) of the wet sites have structures that can be detected by this seismic test. However many (80%) of the dry sites also have these structures. The seismic test costs $2.5 million.
i. Do you want to do the test? - (Show Excel Decision Tree and calculations.) - (Explain why/why not you want to do the test in comprehensive detail.)
ii. Suppose instead that your geologists estimate that half of the wet sites have structures that can be detected by the seismic test, However, half of the dry sites also have these structures,
What is the maximum you would be willing to pay for the test then? - (Show Excel Decision Tree and calculations.) - (Explain why is maximum you would pay for test in comprehensive detail.)
iii. How does the Expected Value (EV) of doing the seismic test change as "wet" probability changes?
(Show in Excel using Bayes’ rule and describe in comprehensive detail.)
*See Finding the probabilities by Bayes’ rule in Appendix of this document as reference!
2. Now consider sites A and B, Like site A, site B would cost $40 million to drill, with the same assessment of the outcomes; a 20% chance of a value of $160 million (wet) and an 80% chance of $0 (dry). Because of the similarities between the two locations, the outcomes at the two sites are not probabilistically independent. In particular, if you knew that site A was wet, that information would change your assessment of the probability that B is wet from 20% to 60%. Similarly, if you knew that A was dry, that information would change your assessment of the probability that B is wet from 20% to 10%.
a) i. Should you drill one, both, or neither of these sites? (Show Excel Decision Tree and explain why/why not you would drill in comprehensive detail.)
b) i. Ignoring the possibility of doing the seismic test, what is the optimal drilling strategy?
(Show Excel Decision Tree and explain optimal drilling strategy in comprehensive detail.)
Summary
The question is about Decision Tree analysis using Excel TreePlan & Bayes’ Rule. The situation is about an oil company’s exploration sites A and B off the coast of Australia near Melbourne. The company wants to make out an optimal drilling strategy for both sites A and B.
Total Word Count 865
Download Full Solution
The day when my professor asked us to start preparing a Research Proposal I approached HwA for help. I was already taking their help for my other assignments as well, but never thought that they had a strong research proposal writing and dissertation writing support. Really impressed with the kind of feedback I got in my Research Proposal.
When I was handed over a data filled excel sheet to analyze as a part of the assignment, then I had no idea what to do and how to approach. I kept on thinking as the deadline kept on getting nearer. Then one of my seniors in college told me about HwA and that is how I first approached them. The experience was fantastic as the experts here found out definitive trends and made sense out of that sheet. They also helped me with the writing the analysis and I got good grades.
I would like to thank HelpwithAssignment.com and its team for the wonderful service. You guys have produced what I exactly asked for and were so efficient with deadlines. I would definitely recommend this service.
There was a research based assignment on the clinical services available for the aboriginals of New Zealand and for that I needed some expert who knows the nursing industry of New Zealand more than anything else. Luckily here I got hold of one lovely professor who helped me that assignment and many other assignments in the due time.
I was using another online physics assignment help service provider. They charged me a bomb and over that they completely botched up my assignment. HelpWithAssignment came as a savior and their online physics assignment help expert helped me to recover my quantum physics assignment within the deadline. The tutors listen to your requirements and provide the solutions exactly as you want them. They have a loyal customer in me now.
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.