MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
8th Edition
ISBN: 9781337274876
Author: Cliff Ragsdale
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
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
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
- 1. The Yellow Cab Pizza wants to launch a new pizza variant next month. After deliberations with their research department, marketing, finance and operations, they have broken down the possible variants into two (2) options: the Neapolitan and Chicago Deep Dish. The table below shows the possible profits (expressed in millions) for each option and the corresponding probabilities: Chicago deep dish Profit (x;) Probability (P,) Neapolitan Profit (x;) Probability (P,) 35 0.15 35 0.20 45 0.30 45 0.35 50 0.35 50 0.30 60 0.20 60 0.15arrow_forwardA soft drink company is considering launching a ‘seasonal soda’ that will be sold for a limited duration. They are considering selling the new soda X-Mist during the upcoming summer season. The company believes, based on its limited market analysis, that there is a 0.75 probability that X-Mist will have a successful summer season and have estimated that they will receive a profit of $4 million if it is successful. If X-Mist is not successful over the summer season, the company will incur a loss of $900,000. The firm Market-Strategies can do an extensive market analysis for a fee of $35,000. Market-Strategies has demonstrated that it is 90 percent reliable in its market analysis for soft drinks, i.e., a soda that will be successful in the market will be reported as ‘Successful’ by Market-Strategies with a probability 0.9 and a soda that will not be successful in the market will be reported as ‘Fail’ by Market-Strategies with a probability of 0.9. The soft drink company must decide…arrow_forwardThe Americo Oil Company is considering making a bid for a shale oil development contract to be awarded by the federal government. The company has decided to bid $112 million. The company estimates that it has a 60% chance of winning the contract with this bid. If the firm wins the contract, it can choose one of three methods for getting the oil from the shale. It can develop a new method for oil extraction, use an existing (inefficient) process, or subcontract the processing to a number of smaller companies once the shale has been excavated. The results from these alternatives are as follows: Develop new process: Outcomes Probability Profit ($1,000,000s) Great success .30 $ 600 Moderate success .60 300 Failure .10 -100 Use present process: Outcomes Probability Profit ($1,000,000s) Great success .50 $ 300 Moderate success .30 200 Failure .20 -40 Subcontract: Outcome Probability Profit ($1,000,000s) Moderate success 1.00 250 The cost of preparing the contract proposal is $2 million. If…arrow_forward
- Ellie Daniels has $200,000 and is considering three mutual funds for investment—a global fund, an index fund, and an Internet stock fund. During the first year of investment, Ellie estimates that there is a .70 probability that the market will go up and a .30 probability that the market will go down. Following are the returns on her $200,000 investment at the end of the year under each market condition: Market Conditions Fund Up Down Global $25,000 $ -8,000 Index 35,000 5,000 Internet 60,000 -35,000 At the end of the first year, Ellie will either reinvest the entire amount plus the return or sell and take the profit or loss. If she reinvests, she estimates that there is a .60 probability the market will go up and a .40 probability the market will go down. If Ellie reinvests in the global fund after it has gone up, her return on her initial $200,000 investment plus her $25,000 return after 1 year will be $45,000. If the market goes down, her loss will be $15,000. If she reinvests after…arrow_forwardSubject: acountingarrow_forwardPeter Martin will help his brother who wants to open a grocery store. Peter initially believes there is a 50-50 chance that his brother's food store will be successful. Peter is considering doing market research. Based on historical data, there is a 0.8 probability that the market research will be favorable given a successful store. Furthermore, there is a 0.7 probability that the market research will be unfavorable given an unsuccessful store. a) If the market research is favorable, what is Peter's revised probability of a successful store for his brother?b) If the market survey is unfavorable, what is Peter's revised probability of a successful store for his brother?c) If the initial probability of a successful store is 0.60 (instead of 0.50), find the probabilities of (a) and (b).arrow_forward
- Pls help ASAP on botharrow_forwardRuka construction Company is considering bidding on a contract for a new office building complex. First company manger must decide whether to bid on the contract or not. The cost of preparing the bid is $20,000. The company has a 0.75 probability of winning the contract if it submits a bid. If the company wins the bid, it will have to pay $1,500,000 to become a partner in the project. The company will then consider doing a market research study to forecast demand prior to beginning construction. The cost of this study is $100,000. The possible outcomes of the market research study show there is 45% for high interest and 35% for moderate and 20% for low interest for office building. The manager of the company regardless of the result of market study or even without doing market study should decide whether to build the complex or to sell the rights in the project to another developer. If company decides to build the complex, cost of building will be $10,000,000. Based on market study…arrow_forwardA real estate investor has the opportunity to purchase land currently zoned residential. If the county board approves a request to rezone the property as commercial within the next year, the investor will be able to lease the land to a large discount firm that wants to open a new store on the property. However, if the zoning change is not approved, the investor will have to sell the property at a loss. Profits (in thousands of dollars) are shown in the following payoff table: State of Nature Rezoning Approved Rezoning Not Approved Decision Alternative S1 S2 Purchase, d1 590 -160 Do not purchase, d2 0 0 If the probability that the rezoning will be approved is 0.5, what decision is recommended?Recommended decision: What is the expected profit?Expected profit: $ fill in the blank 2 The investor can purchase an option to buy the land. Under the option, the investor maintains the rights to purchase the land anytime during the next three months while learning more…arrow_forward
- A manager is quite concerned about the recent deterioration of a section of the roof on a building that houses her firm's computer operations. According to her assistant there are three options which merit consideration: I, II, and III. Moreover, there are three possible future conditions that must be included in the analysis: A, which has a probability of occurrence of .25; B, which has a probability of .6; and C, which has a probability of .15. If condition A materializes, I will cost $12,000, II will cost $20,000, and III will cost $16,000. If condition B materializes, the costs will be $15,000 for I, $18,000 for II, and $14,000 for III. If condition C materializes, the costs will be $10,000 for I, $15,000 for II, and $19,000 for III. (A) Draw a decision tree for this problem. (B) Using expected monetary value, which alternative should be chosen?arrow_forwardKroft Food Products is attempting to decide whether it should introduce a new line of salad dressings called Special Choices. The company can test market the salad dressings in selected geographic areas or bypass the test market and introduce the product nationally. The cost of the test market is $150,000. If the company conducts the test market, it must wait to see the results before deciding whether to introduce the salad dressings nationally. The probability of a positive test market result is estimated to be 0.6. Alternatively, the company can decide not to conduct the test market and go ahead and make the decision to introduce the dressings or not. If the salad dressings are introduced nationally and are a success, the company estimates that it will realize an annual profit of $1.6 million, whereas if the dressings fail, it will incur a loss of $700,000. The company believes the probability of success for the salad dressings is 0.50, if they are introduced without the test market.…arrow_forwardJeffrey Mogul is a Hollywood film producer, and he is currently evaluating a script by a new screenwriter and director, Betty Jo Thurston. Jeffrey knows that the probability of a film by a new director being a success is about .10 and that the probability it will flop is .90. The studio accounting department estimates that if this film is a hit, it will make $25 million in profit, whereas if it is a box office failure, it will lose $8 million. Jeffrey would like to hire noted film critic Dick Roper to read the script and assess its chances of success. Roper is generally able to correctly predict a successful film 70% of the time and correctly predict an unsuccessful film 80% of the time. Roper wants a fee of $1 million. Determine whether Roper should be hired, the strategy Mogul should follow if Roper is hired, and the expected value.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
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