Use Decision Tree to analyze the situation described in the file attached by answering each of the questions. Submit your solution document .
Hydroelectric Dam Location
ASP&L is deciding whether to build a hydroelectric dam on the Travers river for $145 million in costs or on the French Canyon river for $170 million. The Travers river site has seen a fair amount of minor seismic activity over recent years and the company believes there is a 15% chance over the next four years that the seismic activity could lead to a large enough earthquake as to render the site useless. In this case, they will be out the full $145 million and will need to rebuild at the French Canyon location.
Please express monetary amounts in millions of dollars ($M) both in the models you construct and in responding to the questions posed.
Since this problem deals with costs instead of revenue or profit, in the Taskpane click on the Platform tab and change “Decision Node EV/CE” to Minimize.
Assuming ASP&L uses Expected Value (risk-neutral) as their decision criterion, use Decision Tree to construct and solve a neatly labeled decision tree for their decision. What is the optimal decision for ASP&L? Submit your tree.
ASP&L is interested in how sensitive the recommended strategy is to the probability of an earthquake occurring. Use Decision Tree to perform a sensitivity analysis on this value, varying it from 13% to 17%. Provide a graph showing the expected cost over this range for the optimal decision. Use 9 major axis points. Is there a “critical” value of this probability within this range at which the optimal decision changes? If so, provide the critical value, describe how the optimal decision changes, and explain intuitively why the change occurs.
ASP&L could hire a geologist with expertise in this area to predict whether such an event will occur in the next four years. What is the most ASP&L would be willing to pay for an expert prediction? Use Decision Tree to build a new tree that supports your answer. (Be sure to change “Decision Node EV/CE” to Minimize in the Taskpane again.) Submit your tree along with an explanation of why they would not be willing to pay any more than the amount that you found in your analysis.
