Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357191484
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 20.3, Problem 10E
Dante Development Corporation is considering bidding on a contract for a new office building complex. Figure 20.9 shows the decision tree prepared by one of Dante’s analysts. At node 1, the company must decide whether to bid on the contract. The cost of preparing the bid is $200,000. The upper branch from node 2 shows that the company has a .8 probability of winning the contract if it submits a bid. If the company wins the bid, it will have to pay $2,000,000 to become a partner in the project. Node 3 shows that the company will then consider doing a market research study to forecast demand for the office units prior to beginning construction. The cost of this study is $150,000. Node 4 is a chance node showing the possible outcomes of the market research study.
Nodes 5,6, and 7 are similar in that they are the decision nodes for Dante to either build the office complex or sell the rights in the project to another developer. The decision to build the complex will result in an income of $5,000,000 if demand is high and $3,000,000
FIGURE 20.9 DECISION TREE FOR THE DANTE DEVELOPMENT CORPORATION
if demand is moderate. If Dante chooses to sell its rights in the project to another developer, income from the sale is estimated to be $3,500,000. The probabilities shown at nodes 4, 8, and 9 are based on the projected outcomes of the market research study.
- a. Verify Dante’s profit projections shown at the ending branches of the decision tree by calculating the payoffs of $2,650,000 and $650,000 for first two outcomes.
- b. What is the optimal decision strategy for Dante, and what is the expected profit for this project?
- c. What would the cost of the market research study have to be before Dante would change its decision about conducting the study?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
2. Let Y₁,……., Y be a random sample with common mean μ and common variance σ². Use the
CLT to write an expression approximating the CDF P(Ỹ ≤ x) in terms of µ, σ² and n, and
the standard normal CDF Fz(·).
math
Compute the median of the following data.
32, 41, 36, 42, 29, 30, 40, 22, 25, 37
Chapter 20 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
Ch. 20.2 - Prob. 1ECh. 20.2 - Prob. 2ECh. 20.2 - 3. Hudson Corporation is considering three options...Ch. 20.2 - 4. Myrtle Air Express decided to offer direct...Ch. 20.2 - 5. The distance from Potsdam to larger markets and...Ch. 20.2 - 6. Seneca Hill Winery recently purchased land for...Ch. 20.2 - 7. The Lake Placid Town Council has decided to...Ch. 20.3 - Consider a variation of the PDC decision tree...Ch. 20.3 - 9. A real estate investor has the opportunity to...Ch. 20.3 - Dante Development Corporation is considering...
Ch. 20.3 - 11. Hale’s TV Productions is considering producing...Ch. 20.3 - 12. Martin’s Service Station is considering...Ch. 20.3 - 13. Lawson’s Department Store faces a buying...Ch. 20.4 - Prob. 14ECh. 20.4 - 15. In the following profit payoff table for a...Ch. 20.4 - 16. To save on expenses, Rona and Jerry agreed to...Ch. 20.4 - 17. The Gorman Manufacturing Company must decide...Ch. 20 - Prob. 18SECh. 20 - 19. Warren Lloyd is interested in leasing a new...Ch. 20 - Hemmingway, Inc., is considering a $50 million...Ch. 20 - 21. Embassy Publishing Company received a...Ch. 20 - Case Problem Lawsuit Defense Strategy
John...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Task Description: Read the following case study and answer the questions that follow. Ella is a 9-year-old third-grade student in an inclusive classroom. She has been diagnosed with Emotional and Behavioural Disorder (EBD). She has been struggling academically and socially due to challenges related to self-regulation, impulsivity, and emotional outbursts. Ella's behaviour includes frequent tantrums, defiance toward authority figures, and difficulty forming positive relationships with peers. Despite her challenges, Ella shows an interest in art and creative activities and demonstrates strong verbal skills when calm. Describe 2 strategies that could be implemented that could help Ella regulate her emotions in class (4 marks) Explain 2 strategies that could improve Ella’s social skills (4 marks) Identify 2 accommodations that could be implemented to support Ella academic progress and provide a rationale for your recommendation.(6 marks) Provide a detailed explanation of 2 ways…arrow_forwardQuestion 2: When John started his first job, his first end-of-year salary was $82,500. In the following years, he received salary raises as shown in the following table. Fill the Table: Fill the following table showing his end-of-year salary for each year. I have already provided the end-of-year salaries for the first three years. Calculate the end-of-year salaries for the remaining years using Excel. (If you Excel answer for the top 3 cells is not the same as the one in the following table, your formula / approach is incorrect) (2 points) Geometric Mean of Salary Raises: Calculate the geometric mean of the salary raises using the percentage figures provided in the second column named “% Raise”. (The geometric mean for this calculation should be nearly identical to the arithmetic mean. If your answer deviates significantly from the mean, it's likely incorrect. 2 points) Starting salary % Raise Raise Salary after raise 75000 10% 7500 82500 82500 4% 3300…arrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forward
- I need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forward310015 K Question 9, 5.2.28-T Part 1 of 4 HW Score: 85.96%, 49 of 57 points Points: 1 Save of 6 Based on a poll, among adults who regret getting tattoos, 28% say that they were too young when they got their tattoos. Assume that six adults who regret getting tattoos are randomly selected, and find the indicated probability. Complete parts (a) through (d) below. a. Find the probability that none of the selected adults say that they were too young to get tattoos. 0.0520 (Round to four decimal places as needed.) Clear all Final check Feb 7 12:47 US Oarrow_forwardhow could the bar graph have been organized differently to make it easier to compare opinion changes within political partiesarrow_forward
- 30. An individual who has automobile insurance from a certain company is randomly selected. Let Y be the num- ber of moving violations for which the individual was cited during the last 3 years. The pmf of Y isy | 1 2 4 8 16p(y) | .05 .10 .35 .40 .10 a.Compute E(Y).b. Suppose an individual with Y violations incurs a surcharge of $100Y^2. Calculate the expected amount of the surcharge.arrow_forward24. An insurance company offers its policyholders a num- ber of different premium payment options. For a ran- domly selected policyholder, let X = the number of months between successive payments. The cdf of X is as follows: F(x)=0.00 : x < 10.30 : 1≤x<30.40 : 3≤ x < 40.45 : 4≤ x <60.60 : 6≤ x < 121.00 : 12≤ x a. What is the pmf of X?b. Using just the cdf, compute P(3≤ X ≤6) and P(4≤ X).arrow_forward59. At a certain gas station, 40% of the customers use regular gas (A1), 35% use plus gas (A2), and 25% use premium (A3). Of those customers using regular gas, only 30% fill their tanks (event B). Of those customers using plus, 60% fill their tanks, whereas of those using premium, 50% fill their tanks.a. What is the probability that the next customer will request plus gas and fill the tank (A2 B)?b. What is the probability that the next customer fills the tank?c. If the next customer fills the tank, what is the probability that regular gas is requested? Plus? Premium?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Probability & Statistics (28 of 62) Basic Definitions and Symbols Summarized; Author: Michel van Biezen;https://www.youtube.com/watch?v=21V9WBJLAL8;License: Standard YouTube License, CC-BY
Introduction to Probability, Basic Overview - Sample Space, & Tree Diagrams; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=SkidyDQuupA;License: Standard YouTube License, CC-BY