Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
bartleby

Concept explainers

bartleby

Videos

Students have asked these similar questions
Southern Gas Company (SGC) is preparing to make a bid for oil and gas leasing rights in a newly opened drilling area in the Gulf of Mexico. SGC is trying to decide whether to place a high bid of $16 million or a low bid of $7 million. SGC expects to be bidding against its major competitor, Northern Gas Company (NGC) and predicts NGC to place a bid of $10 million with probability 0.4 or a bid of $6 million with probability 0.6. Geological data collected at the drilling site indicates a 0.15 probability of the reserves at the site being large, a 0.35 probability of being average, and a 0.50 probability of being unusable. A large or average reserve would most likely represent a net asset value of $120 million or $28 million, respectively, after all drilling and extraction costs are paid. The company that wins the bid will drill an exploration well at the site for a cost of $5 million.   a. Develop a decision tree for this problem.   b. What is the optimal decision according to the EMV…
Southern Gas Company (SGC) is preparing to make a bid for oil and gas leasing right in a newly opened drilling area in the Gulf of Mexico. SGC is trying to decide whether to place a high bid of $16 million or a low bid of $7 million. SGC expects to be bidding against its major competitor, Northern Gas Company (NGC) and predicts NGC to place a bid of $10 million with probability 0.4 or a bid of $6 million with probability 0.6. Geological data collected at the drilling site indicates a 0.15 probability of the reserves at the site being large, a 0.35 probability of being average, and a 0.50 probability of being unusable. A large or average reserve would most likely represent a net asset value of $120 million or $28 million, respectively, after all drilling and extraction costs are paid. The company that wins the bid will drill an exploration well at the site for a cost of $5 million. a.      Develop a decision tree for this problem. b.     What is the optimal decision according to the EMV…
A retailer must decide whether to build a small or a large facility at a new location. Demand at the location can be either low or high, with probabilities estimated to be 0.4 and 0.6, respectively. If a small facility is built and demand proves to be high, the manager may choose not to expand (payoff = $223,000) or to expand (payoff = $270,000). If a small facility is built and demand is low, there is no reason to expand and the payoff is $200,000. If a large facility is built and demand proves to be low, the choice is to do nothing ($40,000) or to stimulate demand through local advertising. The response to advertising may be either modest or sizable, with their probabilities estimated to be 0.3 and 0.7, respectively. If it is modest, the payoff is estimated to be only $20,000; the payoff grows to $220,000 if the response is sizable. Finally, if a large facility is built and demand turns out to be high, the payoff is $800,000.Draw a decision tree. Then analyze it to determine the…
Knowledge Booster
Background pattern image
Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License