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
Videos
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
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…
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…
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.
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
- A 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_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_forwardA farmer is trying to decide if continuing to farm is the correct thing to do. Yields on his fields have been declining over the past several seasons. He has an offer on the table from a corporate farmer to lease his land for the season for $15,000. Whether or not he accepts this offer depends on how well his fields will produce and the market value of his crops. If yield is high, the farmer will make $50,000 and there is a 10% possibility of this occurring. If yield is medium, the farmer will make $20,000 and there is a 50% possibility of this occurring. If yield is low, the farmer will make $12,000 and there is a 40% possibility of this occurring. Draw a decision tree for this problem. What should the farmer do according to the decision tree? If the farmer could get more information that would help him predict his yield, what is the maximum amount that he should pay for this information?arrow_forward
- John Corner, chief engineer of Offshore Chemicals, Inc., have to decide whether to build a new processing facility based on an experimental technology. If the new facility works, the company will realize a net profit of $20 million. If the new facility fails, the company will lose $10 million. Benjamin’s best guess is that there is a 40 percent chance that the new facility will work What decision should Benjamin Moses make?arrow_forwardRobert Ragsdale is trying to decide if he should purchase repair and replacement insurance on a new laptop computer that he is planning to purchase. The policy costs $400.00 at the time of purchase, and over the next three years will replace the laptop if it is stolen or repair it if it is broken. The following table contains the total costs of this decision. Which alternative is best, according to each of the following decision criteria? Maximin Maximax Laplace Minimax regretarrow_forwardEllie 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_forward
- McHardee Press publishes the Fast Food Menu Book and wishes to determine how many copies to print. There is a fixed cost of $5,000 to produce the book and the incremental profit per copy is $0.40. Any unsold copies of the book can be sold at salvage at a $.60 loss. Sales for this edition are estimated to be normally distributed. The most likely sales volume is 12,000 copies and they believe there is a 7% chance that sales will exceed 20,000. How many copies should be printed? If any unsold copies can be sold at salvage at a $.70 loss, how many copies should be printed?arrow_forwardBenjamin Moses, chief engineer of Offshore Chemicals, Inc., must decide whether to build a new processing facility based on an experimental technology. If the new facility works, the company will realize a net profit of $20 million. If the new facility fails, the company will lose $10 million. Benjamin’s best guess is that there is a 40 percent chance that the new facility will work. What decision should Benjamin Moses make?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
- 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…arrow_forwardThe owner of the Columbia Construction Company must decide between building a housing development, constructing a shopping center, and leasing all the company’s equipment to another company. The profit that will result from each alternative will be determined by whether material costs remain stable or increase. The profit from each alternative, given the two possibilities for material costs, is shown in the following payoff table: Material Costs Decision Stable Increase Houses $70,000 $30,000 Shopping center 105,000 20,000 Leasing 40,000 40,000 Determine the best decision, using the following decision criteria. a. Maximax b. Maximin c. Minimax regret d. Hurwicz e. Equal likelihoodarrow_forwardHemmingway, Inc. is considering a $5 million research and development (R&D) project. Profit projections appear promising, but Hemmingway's president is concerned because the probability that the R&D project will be successful is only 0.50. Furthermore, the president knows that even if the project is successful, it will require that the company build a new production facility at a cost of $20 million in order to manufacture the product. If the facility is built, uncertainty remains about the demand and thus uncertainty about the profit that will be realized. Another option is that if the R&D project is successful, the company could sell the rights to the product for an estimated $25 million. Under this option, the company would not build the $20 million production facility. The decision tree follows. The profit projection for each outcome is shown at the end of the branches. For example, the revenue projection for the high demand outcome is $59 million. However, the cost of the R&D…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