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
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Embassy Publishing Company received a six-chapter manuscript for a new college textbook. The editor of the college division is familiar with the manuscript and estimated a 0.7 probability that the textbook will be successful. If successful, a profit of $210,000 will be realized. If the company decides to publish the textbook and it is unsuccessful, a loss of $50,000 will occur. Before making the decision to accept or reject the manuscript, the editor is considering sending the manuscript out for review. A review process provides either a favorable (F) or unfavorable (U) evaluation of the manuscript. Past experience with the review process suggests that probabilities P(F) = 0.6 and P(U) = 0.4 apply. Let s1 = the textbook is successful, and s2 = the textbook is unsuccessful. The editor’s initial probabilities of s1 and s2 will be revised based on whether the review is favorable or unfavorable. The revised probabilities are as follows: P(s1 | F) = 0.15 P(s1 | U) = 0.465 P(s2 | F) = 0.85…
A 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…
Embassy Publishing Company received a six-chapter manuscript for a new college textbook. The editor of the college division is familiar with the manuscript and estimated a 0.65 probability that the textbook will be successful. If successful, a profit of $750,000 will be realized. If the company decides to publish the textbook and it is unsuccessful, a loss of $250,000 will occur. Before making the decision to accept or reject the manuscript, the editor is considering sending the manuscript out for review. A review process provides either a favorable (F) or unfavorable (U) evaluation of the manuscript. Past experience with the review process suggests that probabilities P(F) = 7 and P(U) = 0.3 apply. Let s1 = the textbook is successful, and s2 = the textbook is unsuccessful. The editor’s initial probabilities of s1 and s2 will be revised based on whether the review is favorable or unfavorable. The revised probabilities are as follows:
P(s1 | F) = 0.65 P(s1 | U) =…
Knowledge Booster
Similar questions
- Phillip Witt, president of Witt Input Devices, wishes to create a portfolio of local suppliers for his new line of keyboards. As the suppliers all reside in a location prone to hurricanes, tornadoes, flooding, and earthquakes, Phillip believes that the probability in any year of a "super-event" that might shut down all suppliers at the same time at least 2 weeks is 3%. Such a total shutdown would cost the company approximately $480,000. He estimates the "unique-event" risk for any of the suppliers to be 5%. Assuming that the marginal cost of managing an additional supplier is $16,000 per year, how many suppliers should Witt Input Devices use? Assume that up to three nearly identical local suppliers are available. Find the EMV for alternatives using 1, 2, or 3 suppliers. EMV(1)=$54,40054,400 (Enter your response rounded to the nearest whole number.) EMV(2)= ? $ (Enter your response rounded to the nearest whole number.) EMV(3)= ? $ (Enter your response…arrow_forwardPhillip Witt, president of Witt Input Devices, wishes to create a portfolio of local suppliers for his new line of keyboards. As the suppliers all reside in a location prone to hurricanes, tornadoes, flooding, and earthquakes, Phillip believes that the probability in any year of a "super-event" that might shut down all suppliers at the same time at least 2 weeks is 2%. Such a total shutdown would cost the company approximately $480,000. He estimates the "unique-event" risk for any of the suppliers to be 5%. Assuming that the marginal cost of managing an additional supplier is $14,800 per year, how many suppliers should Witt Input Devices use? Assume that up to three nearly identical local suppliers are available. Find the EMV for alternatives using 1, 2, or 3 suppliers. EMV(1) = $ whole number.) EMV (2)=$_ EMV(3)=$ (Enter your response rounded to the nearest Based on the EMV value, the best choice to use is... a. one supplier b. two suppliersarrow_forwardAnand Publishing Company received a six-chapter manuscript for a new college textbook. The editor of the college division is familiar with the manuscript and estimated a 0.6513 probability that the textbook will be successful. If successful, a profit of $950,000 will be realized. If the company decides to publish the textbook and it is unsuccessful, a loss of $150,000 will occur. Before making the decision to accept or reject the manuscript, the editor is considering sending the manuscript out for review. A review process provides either a favorable (F) or an unfavorable (U) evaluation of the manuscript. Past experience with the review process suggests probabilities P(F) = 0.7 and P(U) = 0.3 apply. Let s₁ = the textbook is successful, and $₂ = the textbook is unsuccessful. The editor's initial probabilities of s₁ and s₂ will be revised based on whether the review is favorable or unfavorable. The revised probabilities are as follows: P(S₁IF): = 0.75 P(S₂IF): = 0.25 P(S₁IU) = 0.421…arrow_forward
- The XYZ manufacturing company is considering replacing one of its metal cutting machine which can be sold today for $3,000. If they kept this machine for 4 more years, its salvage value will be zero. The challenger costs $18,000, and its life is 4 years. The estimated salvage value of the challenger at the end of four years is $6,000. Should the XYZ company replace the old machine? Use the opportunity cost approach with rate of return of 10%. Assume operating costs per year for defender equals $2,000 and a saving in operating costs per year of 75% for challenger.arrow_forwardA large steel manufacturing company has three options with regard to production: Produce commercially Build pilot plant Stop producing steel The management has estimated that their pilot plant, if built has 0.8 chance of high yield and 0.2 chance of low yield. If the pilot plant does show a high yield, management assigns a probability of 0.75 that the commercial plant will also have a high yield. If the pilot plant shows a low yield, there is only a 0.1 chance that the commercial plant will show a high yield. Finally, management’s best assessment of the yield on a commercial size plant without building a pilot plant first has 0.6 chance of high yield. A pilot plant will cost K300,000. The profits earned under high and low yield conditions are K12,000,000 and K1,200,000 respectively. Draw up an appropriate decision tree for the steel manufacturing company What is the company’s best strategy under EMV approacharrow_forwardEmbassy Publishing Company received a six-chapter manuscript for a new college textbook. The editor of the college division is familiar with the manuscript and estimated a 0.7207 probability that the textbook will be successful. If successful, a profit of $850,000 will be realized. If the company decides to publish the textbook and it is unsuccessful, a loss of $150,000 will occur. Before making the decision to accept or reject the manuscript, the editor is considering sending the manuscript out for review. A review process provides either a favorable (F) or an unfavorable (U) evaluation of the manuscript. Past experience with the review process suggests probabilities P(F) = 0.7 and P(U) = 0.3 apply. Let s1 = the textbook is successful, and s2 = the textbook is unsuccessful. The editor's initial probabilities of s1 and s2 will be revised based on whether the review is favorable or unfavorable. The revised probabilities are as follows: P(s1|F) = 0.85 P(s2|F) = 0.15…arrow_forward
- A 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_forwardYou drive a 4 year old truck valued at $15,000. You have a $70,000 personal automobile policy with $12,000 per-person medical payments coverage and both collision ($500 deductible) and comprehensive coverage. Your neighbor drives a five-year old SUV valued at $10,000. Your neighbor has a 25/50/15 automobile policy with $15,000 in medical payments coverage and both collision ($200 deductible) Early one morning your neighbor was driving down the street while you were driving the opposite way to drop your friend off at her house and your neighbor swerved into your lane and struck your vehicle. Below you will find the damage caused by the accident:Your Bodily Injury: $7,000Your Friend’s Bodily Injury: $25,000Your Car: $8,500Neighbor’s Bodily Injury: $3,000Neighbors Car: $9,000Using the information above, find the following:a) How much will your policy pay for your bodily injury? blank1 - Numeric Answer Please type your answer to submit b) How much will your policy pay for your…arrow_forwardYour manager is quite concerned about the recent deterioration of a section of the roof on a building that houses your firm's computer operations. According to your assistant there are three options which merit consideration: A, B, and C. Moreover, there are three possible future conditions that must be included in the analysis: I, which has a probability of occurrence of .5; II, which has a probability of .3; and III, which has a probability of .2. If condition I materializes, A will cost $12,000, B will cost $20,000, and C will cost $16,000. If condition II materializes, the costs will be $15,000 for A, $18,000 for B, and $14,000 for C. If condition III materializes, the costs will be $10,000 for A, $15,000 for B, and $19,000 for C. (A) Draw a decision tree for this problem (B) Using expected monetary value, which alternative should be chosen? Explain your Answer.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_forwardA 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 $12000, II will cost $20000, and III will cost $16000. If condition B materializes, the costs will be $15000 for I, $18000 for II, and $14000 for III. If condition C materializes, the costs will be $10000 for I, $15000 for I, and $19000 for III. (A) Draw a decision tree for this problem. (B) Using expected monetary value, which alternative should be chosenarrow_forwardIf a company identifies four risks with a risk score as follows: Risk An oven fire may result in the destruction of a store. A cybersecurity attack may result in the theft of customer data. A store employee getting sick may result in them backing out of their shift last minute. An employee stealing from a cash register may result in loss of cash. Which risk is the highest priority? Risk Score O An employee stealing from a cash register may result in loss of cash O A cybersecurity attack may result in theft of customer data OA store employee getting sick may result in them backing out of their shift last minute O An oven fire may result in the destruction of a store 5 15 4 6arrow_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,