Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 20.2, Problem 7E
The Lake Placid Town Council has decided to build a new community center to be used for conventions, concerts, and other public events, but considerable controversy surrounds the appropriate size. Many influential citizens want a large center that would be a showcase for the area, but the mayor feels that if demand does not support such a center, the community will lose a large amount of money. To provide structure for the decision process, the council narrowed the building alternatives to three sizes: small, medium, and large. Everybody agreed that the critical factor in choosing the best size is the number of people who will want to use the new facility. A regional planning consultant provided demand estimates under three scenarios: worst case, base case, and best case. The worst-case scenario corresponds to a situation in which tourism drops significantly; the base-case scenario corresponds to a situation in which Lake Placid continues to attract visitors at current levels; and the best-case scenario corresponds to a significant increase in tourism. The consultant has provided probability assessments of .10, .60, and .30 for the worstcase, base-case, and best-case scenarios, respectively.
The town council suggested using net cash flow over a five-year planning horizon as the criterion for deciding on the best size. A consultant developed the following projections of net cash flow (in thousands of dollars) for a five-year planning horizon. All costs, including the consultant’s fee, are included.
- a. What decision should Lake Placid make using the
expected value approach? - b. Compute the expected value of perfect information. Do you think it would be worth trying to obtain additional information concerning which scenario is likely to occur?
- c. Suppose the probability of the worst-case scenario increases to .2, the probability of the base-case scenario decreases to .5, and the probability of the best-case scenario remains at .3. What effect, if any, would these changes have on the decision recommendation?
- d. The consultant suggested that an expenditure of $150,000 on a promotional campaign over the planning horizon will effectively reduce the probability of the worst-case scenario to zero. If the campaign can be expected to also increase the probability of the best-case scenario to .4, is it a good investment?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The Lake Placid Town Council decided to build a new community center to be used for conventions, concerts, and other public events, but considerable controversy surrounds the appropriate size. Many influential citizens want a large center that would be a showcase for the area. But the mayor feels that if demand does not support such a center, the community will lose a large amount of money. To provide structure for the decision process, the council narrowed the building alternatives to three sizes: small, medium, and large. Everybody agreed that the critical factor in choosing the best size is the number of people who will want to use the new facility. A regional planning consultant provided demand estimates under three scenarios: worst-case, base-case, and best-case. The worst-case scenario corresponds to a situation in which tourism drops substantially; the base-case scenario corresponds to a situation in which Lake Placid continues to attract visitors at current levels; and the…
The Pharoah Inc., a manufacturer of low-sugar, low-sodium, low-cholesterol TV dinners, would like to increase its market share in the Sunbelt. In order to do so, Pharoah has decided to locate a new factory in the Panama City area. Pharoah will either buy or lease a site depending upon which is more advantageous. The site location committee has narrowed down the available sites to the following three very similar buildings that will meet their needs.Building A: Purchase for a cash price of $ 618,100, useful life 26 years.Building B: Lease for 26 years with annual lease payments of $ 70,340 being made at the beginning of the year.Building C: Purchase for $ 653,200 cash. This building is larger than needed; however, the excess space can be sublet for 26 years at a net annual rental of $ 6,540. Rental payments will be received at the end of each year. The Pharoah Inc. has no aversion to being a landlord.Click here to view factor tablesIn which building would you recommend that The…
Due to heavy rains that destroyed numerous roadways in Jamaica the National Works Agency (NWA) has decided to repair 300 km of the Sothern Coastal Highway and 200 km of Type A roads from Kingston to Lucea. The repair will cost $2 million per km for the Type A roads and $8 million per km for the Southern Coastal Highway. The NWA has identified two firms China Harbour and Caribbean Construction. Caribbean Construction can repair at most 300 km while China Harbour has no restriction on the amount of roadway it can repair. Each company must be awarded a contract of at least $300 million (before discounts).
Each company wants to maximize the quantity of highway and Type A roads awarded by the NWA so are willing to offer a per km discount. China Harbour offers a discount of 1% for each km of Southern Coastal Highway and Type A road. Caribbean Construction offers a flat discount of $30,000 for each km of Type A road and $50,000 for each km of the Southern CoastalHighway. Due to a significant…
Chapter 20 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
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
- Due to heavy rains that destroyed numerous roadways in Jamaica the National Works Agency (NWA) has decided to repair 300 km of the Sothern Coastal Highway and 200 km of Type A roads from Kingston to Lucea. The repair will cost $2 million per km for the Type A roads and $8 million per km for the Southern Coastal Highway. The NWA has identified two firms China Harbour and Caribbean Construction. Caribbean Construction can repair at most 300 km while China Harbour has no restriction on the amount of roadway it can repair. Each company must be awarded a contract of at least $300 million (before discounts). Each company wants to maximize the quantity of highway and Type A roads awarded by the NWA so are willing to offer a per km discount. China Harbour offers a discount of 1% for each km of Southern Coastal Highway and Type A road. Caribbean Construction offers a flat discount of $30,000 for each km of Type A road and $50,000 for each km of the Southern CoastalHighway. Due to a significant…arrow_forwardThe vintage Restaurant is located on Captiva Island, a resort community located near Fort Meyers, Florida. The restaurant, which is owned and operated by Karen Payne, has just completed its third year of operation. During this time, Karen sought to establish a reputation for the restaurant as a high-quality dining establishment that specializes in fresh seafood. The efforts made by Karen and her staff have proved successful, and her restaurant has become one of the best and fastest-growing restaurants on the island. Karen has just concluded that to plan better for the growth of the restaurant in the future, it is necessary to develop a system that will enable her to forecast food and beverage sales by the month for up to 1 year in advance. Karen has the following data available on the total food and beverage sales that were realized during the previous 3 years of operation. Food and Beverage Sales for the Vintage Restaurant ($1000s) Month First Year Second Year Third YearJanuary 242…arrow_forwardThe Tubular Ride Boogie Board Company has manufacturing plants in Tucson, Arizona, and Toronto, Ontario. You have been given the job of coordinating distribution of the latest model, the Gladiator, to their outlets in Honolulu and Venice Beach. The Tucson plant, when operating at full capacity, can manufacture 620 Gladiator boards per week, while the Toronto plant, beset by labor disputes, can produce only 310 boards per week. The outlet in Honolulu orders 470 Gladiator boards per week, while Venice Beach orders 490 boards per week. Transportation costs are as follows: Tucson to Honolulu: $10 per board; Tucson to Venice Beach: $5 per board; Toronto to Honolulu: $20 per board; Toronto to Venice Beach: $10 per board. Your manager has informed you that the company's total transportation budget is $5,250. You realize that it may not be possible to fill all the orders, but you would like the total number of boogie boards shipped to be as large as possible. Given this, how many Gladiator…arrow_forward
- If Electrocomp decides that at least 30 air conditioners should be produced, but no more than 50 fans should be produced, what would be the optimal solution? 15 air conditioners and 65 fans 35 air conditioners and 75 fans 40 air conditioners and 50 fans 45 air conditioners and 50 fansarrow_forwardThe Tubular Ride Boogie Board Company has manufacturing plants in Tucson, Arizona and Toronto, Ontario. You have been given the job of coordinating distribution of the latest model, the Gladiator, to outlets in Honolulu and Venice Beach. The Tucson plant, when operating at full capacity, can manufacture 620 Gladiator boards per week, while the Toronto plant, beset by labor disputes, can produce only 410 boards per week. The outlet in Honolulu orders 500 Gladiator boards per week, while Venice Beach orders 530 boards per week. Transportation costs are as follows. Tucson to Honolulu: $10 per board; Tucson to Venice Beach: $5 per board. Toronto to Honolulu: $20 per board; Toronto to Venice Beach: $10 per board. (a) Assuming that you wish to fill all orders and ensure full capacity production at both plants, is it possible to meet a total transportation budget of $10,400? Yes or No If so, how many Gladiator boards are shipped from each manufacturing plant to each…arrow_forwardThe advertising director for Diversey Paint and Supply, a chain of four retail stores on Chicago’s North Side, is considering two media possibilities. One plan is for a series of half-page ads in the Sunday Chicago Tribune newspaper, and the other is for advertising time on Chicago TV. The stores are expanding their lines of do-it-yourself tools, and the advertising director is interested in an exposure level of at least 40% within the city’s neighborhoods and 60% in northwest suburban areas. The TV viewing time under consideration has an exposure rating per spot of 5% in city homes and 3% in the northwest suburbs. The Sunday newspaper has corresponding exposure rates of 4% and 3% per ad. The cost of a half-page Tribune advertisement is $925; a television spot costs $2,000. Diversey Paint would like to select the least costly advertising strategy that would meet desired exposure levels. Formulate using LP. Solve the problem.arrow_forward
- The Housing Department of the Punjab Government plans to undertake four housing projects and lists material requirements for each house in each of the project as follows : Projects 1 Projects2 Projects 3 Projects 4 Paint in 100 gallon 1 2 1 1.5Wood in 10000 cu. ft. 3 4 2.5 2.5Brick in million 1 2 1.5 1 Labour in 1000 hrs 10 10 9 8 If the supplier 6800 gallons of paint, 1420000 cubic feet of wood, 64 million bricks and 448000 hours of labour , Find the number of houses built for each project. Solve by gauses Jordon method or cramer's rulearrow_forwardImagine you are a member of the moon space crew originally scheduled to rendezvous with a mother ship on the lighted surface of the moon. Due to mechanical difficulties, however, your ship was forced to land at a spot some 200 miles (320 km) from the rendezvous point. During reentry and landing, much of the equipment aboard was damaged, and because survival depends on reaching the mother ship, the most critical items available must be chosen for the 200-mile (320 km) trip. Please see the list of the 15 items left intact and undamaged after landing. Your task is to rank the items in terms of their importance for your crew to reach the rendezvous point. Place the number 1 by the most important, 2 by the next most important, and so on, with 15 being the least important.arrow_forwardThe Megabuck Hospital Corp. is to build a state-subsidized nursing home catering to homeless patients as well as high-income patients. State regulations require that every subsidized nursing home must house a minimum of 760 homeless patients and no more than 800 high-income patients in order to qualify for state subsidies. The overall capacity of the hospital is to be 2,100 patients. The board of directors, under pressure from a neighborhood group, insists that the number of homeless patients should not exceed twice the number of high-income patients. Due to the state subsidy, the hospital will make an average profit of $9,800 per month for every homeless patient it houses, whereas the profit per high-income patient is estimated at $7,800 per month. How many of each type of patient should it house in order to maximize profit? (If an answer does not exist, enter DNE.) high-income patients homeless patients profitarrow_forward
- The Security Company in charge of rescuing visitors in the case of problems at “High Mountain Natural Park” in South Bekaa area has the intention to purchase special trained dogs to help their rescue team, so that they can conduct their search for lost people more efficiently. The rescue team is composed of 10 employees and the company is going to provide each of them with a trained dog. Two types of dogs were selected. The German Shepherd dog breed and the Belgium Malinois breed. The cost of the Belgium Malinois dog breed is $550,00 per dog, while the German Shepherd dog breed is at $850,00 each. For budget reason, the number of German Shepherd dog should be less than half the number of Belgium Malinois. For technical reason, at least three German Shepherd dog must be purchased to get advantage of the special performance of such dog breed in their particular capacity to search for lost person in all weather and under heavy conditions. The overall budget is $6500,00. All of…arrow_forwardThe Megabuck Hospital Corp. is to build a state-subsidized nursing home catering to homeless patients as well as high-income patients. State regulations require that every subsidized nursing home must house a minimum of 700 homeless patients and no more than 620 high-income patients in order to qualify for state subsidies. The overall capacity of the hospital is to be 1,800 patients. The board of directors, under pressure from a neighborhood group, insists that the number of homeless patients should not exceed twice the number of high-income patients. Due to the state subsidy, the hospital will make an average profit of $13,000 per month for every homeless patient it houses, whereas the profit per high-income patient is estimated at $9,000 per month. How many of each type of patient should it house in order to maximize profit? Group of answer choices A)700 homeless patients and 1,100 high-income patients B)1,200 homeless patients and 600 high-income patientsC)700 homeless patients…arrow_forwardThe Megabuck Hospital Corp. is to build a state-subsidized nursing home catering to homeless patients as well as high-income patients. State regulations require that every subsidized nursing home must house a minimum of 700 homeless patients and no more than 620 high-income patients in order to qualify for state subsidies. The overall capacity of the hospital is to be 1,800 patients. The board of directors, under pressure from a neighborhood group, insists that the number of homeless patients should not exceed twice the number of high-income patients. Due to the state subsidy, the hospital will make an average profit of $13,000 per month for every homeless patient it houses, whereas the profit per high-income patient is estimated at $9,000 per month. How many of each type of patient should it house in order to maximize profit?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Introduction to experimental design and analysis of variance (ANOVA); Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=vSFo1MwLoxU;License: Standard YouTube License, CC-BY