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
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 1, Problem 27QP
Summary Introduction
To provide: An example of decision by a leader in which the good decision resulted in bad and vice versa.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Hale's Productions is considering producing a pilot for a comedy series in the hope of selling it to a major streaming service. The
streaming service may decide to reject the series, but it may also decide to purchase the rights to the series for either one or two
years. At this point in time, Hale may either produce the pilot and wait for the streaming service's decision or transfer the rights
for the pilot and series to a competitor for $100,000. Hale's decision alternatives and profits (in thousands of dollars) are as
follows:
Decision Alternative
Produce pilot, d₁
Sell to competitor, d₂ 100
P(F) = 0.69
P(U)= 0.31
P(S₁IF) = 0.08
P(S₂IF) = 0.28
P(S3|F) = 0.64
i
Decision Tree
Agency
1
Reject, S₁
The probabilities for the states of nature are P(S₁) = 0.1947, P(S₂) = 0.3141, and P(S3) = 0.4912. For a consulting fee of $5,000,
an agency will review the plans for the comedy series and indicate the overall chances of a favorable streaming service reaction to
the series. Assume that the…
Hale's Productions is considering producing a pilot for a comedy series in the hope of selling it to a major streaming service.
The streaming service may decide to reject the series, but it may also decide to purchase the rights to the series for either one
or two years. At this point in time, Hale may either produce the pilot and wait for the streaming service's decision or transfer
the rights for the pilot and series to a competitor for $100,000. Hale's decision alternatives and profits (in thousands of
dollars) are as follows:
Decision Alternative
P(F) = 0.69
P(U) = 0.31
P(S₁IF) = = 0.07
P(S₂IF) = 0.29
P(S3IF) = 0.64
Produce pilot, d₁
Sell to competitor, d₂
The probabilities for the states of nature are P(S₁) = 0.1878, P(S₂) 0.3210, and P(S3) = 0.4912. For a consulting fee of
$5,000, an agency will review the plans for the comedy series and indicate the overall chances of a favorable streaming
service reaction to the series. Assume that the agency review will result in a favorable…
Hale's TV Productions is considering producing a pilot for a comedy series in the hope of selling it to a major television network. The network may decide to reject the series, but it may also decide to purchase the rights to the series for either one or two years. At this point in time, Hale may either produce the pilot and wait for the network's decision or transfer the rights for the pilot and series to a competitor for $150,000. Hale's decision alternatives and profits (in thousands of dollars) are as follows:
State of Nature
Decision Alternative
Reject, S1
1 Year, S2
2 Years, S3
Produce pilot, d1
-100
50
250
Sell to competitor, d2
150
150
150
The probabilities for the states of nature are P(S1) = 0.20, P(S2) = 0.30, and P(S3) = 0.50. For a consulting fee of $55,000, an agency will review the plans for the comedy series and indicate the overall chances of a favorable network reaction to the series. Assume that the agency review will result in a favorable (F) or an…
Chapter 1 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
Ch. 1 - Prob. 1QPCh. 1 - Prob. 2QPCh. 1 - Prob. 3QPCh. 1 - Prob. 4QPCh. 1 - What is the relationship between business...Ch. 1 - What kinds of spreadsheet applications would not...Ch. 1 - Prob. 7QPCh. 1 - Prob. 8QPCh. 1 - What is a dependent variable?Ch. 1 - What is an independent variable?
Ch. 1 - Can a model have more than one dependent variable?Ch. 1 - Can a decision problem have more than one...Ch. 1 - Prob. 13QPCh. 1 - Prob. 14QPCh. 1 - In what ways are descriptive models different from...Ch. 1 - Prob. 16QPCh. 1 - Prob. 17QPCh. 1 - Consider the spreadsheet model shown in Figure...Ch. 1 - Prob. 19QPCh. 1 - Prob. 20QPCh. 1 - Prob. 21QPCh. 1 - Prob. 22QPCh. 1 - Prob. 23QPCh. 1 - Prob. 24QPCh. 1 - Prob. 25QPCh. 1 - Prob. 26QPCh. 1 - Prob. 27QP
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
- Hale's TV Production is considering producing a pilot for a comedy series in the hope of selling it to a major television network. The network may decide to reject the series, but it may also decide to purchase the rights to the series for either one or two years. At this point in time, Hale may either produce the pilot and wait for the network's decision or transfer the rights for the pilot and series to a competitor for $100,000. Hale's decision alternatives and profits (in thousands of dollars) are as follows: The probabilities for the states of nature are P(S1) = 0.20, P(S2) = 0.30, and P(S3) = 0.50. For a consulting fee of $5000, an agency will review the plans for the comedy series and indicate the overall chances of a favorable network reaction to the series. Assume that the agency review will result in a favorable (F) or an unfavorable (U) review and that the following probabilities are relevant: Construct a decision tree for this problem What is the recommended decision if…arrow_forward6-11. Assume that an automotive company discloses the following risk factors, listed as (1) through (7), that might affect the specific assertion of primary concern to the financial statements. Continued decline in market share, and a market shift (or an increase in acceleration of market shift) away from sales of trucks or sport utility vehicles, or from sales of other more profitable vehicles in the U.S. Continued or increased price competition resulting from industry overcapacity, currency fluctuations, or other factors. Lower than anticipated market acceptance of new or existing products. Substantial pension and postretirement health care and life insurance liabilities impairing our liquidity or financial condition. Worse than assumed economic and demographic experience for our postretirement benefit plans (e.g., discount rates, investment returns, and health care cost trends). The discovery of defects in vehicles resulting in delays in a new model launches, recall campaigns, or…arrow_forwardYou are a staff associate at a major public accounting firm and graduated from college two years ago. You are working on an audit for a small, non-profit religious publishing firm. After performing tests on the royalty payables system, you discover that for the past five years, the royalty payable system has miscalculated the royalties it owes to authors for their publications. The firm owes almost $100,000 in past due royalties. All of the contracts with each author are negotiated differently. However, each author’s royalty percentage will increase at different milestones in books sold (i.e., 2% up to $10,000 and 3% thereafter). The software package did not calculate the increases, and none of the authors ever received their increase in royalty payments. At first you can’t believe that none of the authors ever realized they were owed their money. You double check your calculations and then present your findings to the senior auditor on the job.Much to your surprise, his suggestion is…arrow_forward
- All business decisions can be judged as right or wrong, ethical or unethical True or Falsearrow_forwardAt many universities, the title to any patentable inventions conceived or reduced to practice by faculty, staff, or students is assigned to the university regardless of the funding source. In this situation, if the innovator(s) intend to participate in commercialization of the technology via a start-up, they must license the rights to the invention from the university True Falsearrow_forwardWhen the volcano, Eyjafjallajokull, erupted in April 2010, the plume of volcanic ash that spread across thousands of miles disrupted air travel and global commerce for a number of days. The eruption of the Icelandic volcano, which produced a huge drifting ash, cloud throughout Europe, resulted in flight cancellations that disrupted global commerce. The halting of air travel for several days impacted managers plans for the production and distribution of goods and services and many other scheduled business operations. As thousands of flights were cancelled across Europe, tens of thousands of air travellers couldn't get to their destinations. For example, Marthin De Beer, vice president of emerging technologies at Cisco Systems, was headed to Oslo to discuss the final aspects of its acquisition of Tandberg, a Norwegian Teleconferencing Company. However, when his flight was cancelled, he and Tandberg’s CEO, Fredrik Halvorsen, used their merged companies’ equipment to hold a virtual press…arrow_forward
- Companies that are developing a formalized risk management process are encouraged to document and specify the desired outcomes associated with each risk identified. What is the purpose of this activity? Listing the outcomes desired by the organization creates a basis for prioritizing risks Listing the outcomes desired by the organization creates a basis for determining which mitigation strategies should be pursued Listing the outcomes desired by the organization creates a basis for assessing the potential impact of risks Listing the outcomes desired by the organization creates for assessing the costs associated with each riskarrow_forwardYou are required to select a well-established financial institution with a regional or international presence and assess key functions including risk management and compliance. You are to present a written report based on the following: Risk management framework – Conduct an analysis of the risk management process/ framework implemented at the institution (including risk assessment and risk control mechanisms). You are required to report on key risks that the institution is exposed to and explain aspects of the framework, emphasizing the effectiveness of the risk management strategies used. Anti-Money Laundering and Terrorist Financing Strategies – Discuss with examples, the institution’s approaches/ strategies to combat money laundering and terrorist financing issues. Statutory legislation and compliance - Explain the importance of financial institutions meeting regulatory requirements. Comment on specific legislation that the financial institution must be compliant with.arrow_forwardYou are entrusted with deciding whether to make or buy software. The make decision has a setup cost of $15,000 and a monthly maintenance cost of $1,200. A vendor will sell the software for an initial cost of $11,400 and a monthly cost of $3,000. For how many months must the company use this software to support a make decision?arrow_forward
- If a $900,000 30-year fully amortizing fixed rate mortgage loan from City National Bank has an annual interest rate of 6.25% with a monthly payment of $5,541.45, and a $900,000 15-year fully amortizing fixed rate mortgage loan from Wells Fargo Bank has an annual interest rate of 5.25% with a monthly payment of $7,234.90, a borrower should: a. Choose the 30-year fixed rate loan from City National Bank because of the lower monthly payments b. Make a careful analysis of all the terms and conditions of the available loans to determine which loan is better for that borrower under the circumstances, or if another loan or lender should be considered c. Choose a 7-year adjustable rate interest-only loan from PNC Bank instead with a low teaser interest rate of 1.0% for the first loan year d.Choose the 15-year fixed rate loan from Wells Fargo because of the lower interest ratearrow_forwardIn Georgia, when should the lender be notified that a seller is offering a loan assumption? When the buyer contacts the lender to be qualified for the loan assumption Immediately after the properties listed for sale At the time an offer to purchase is accepted by the seller After the buyer has been determined to be creditworthyarrow_forwardYou have decided to move into an apartment with your best friend shortly after graduating from high school. Create a roommate agreement that makes sure you and your friend agree on your living arrangements.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,Understanding Management (MindTap Course List)ManagementISBN:9781305502215Author:Richard L. Daft, Dorothy MarcicPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Understanding Management (MindTap Course List)
Management
ISBN:9781305502215
Author:Richard L. Daft, Dorothy Marcic
Publisher:Cengage Learning