A 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 the town 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 0.10, 0.60, and 0.30 for the worst-case, 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. Demand Scenario Center Size Worst Base Best Case Case Case Small 420 520 680 Medium -230 670 820 Large -380 600 1,010 (a) What decision should the town make using the expected value approach? EV(Small) EV(Medium) EV(Large) 558,000 625,000 625,000 × × The best decision is to build a medium or large-sized ✓ community center. (b) Construct risk profiles for the medium and large alternatives (Submit a file with a maximum size of 1 MB.). Choose File No file chosen This answer has not been graded yet. Given the mayor's concern over the possibility of losing money and the result of part (a), which alternative would you recommend? O small-size center O medium-size center O large-size center (c) Compute the expected value of perfect information. EVPI = 122,000 Do you think it would be worth trying to obtain additional information concerning which scenario is likely to occur? The town should not consider additional information about the likelihood of the three scenarios. The town should consider additional information about the likelihood of the three scenarios. (d) Suppose the probability of the worst-case scenario increases to 0.2, the probability of the base-case scenario decreases to 0.5, and the probability of the best-case scenario remains at 0.3. EV(Small) 0.2 EV(Medium) 0.5 EV(Large) 0.3 What effect, if any, would these changes have on the decision recommendation? The best decision is to build a small community center. (e) 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. The campaign can be expected to also increase the probability of the best-case scenario to 0.4. (Remember to subtract the cost of the promotional campaign from the expected value.) EV(Small) 434,000 EV(Medium) 580,000 EV(Large) 614,000 The best decision is to build a large community center. Compared to the analysis in part (d), is this a good investment? It is a good investment as the risk of loss is eliminated. It is not a good investment as the risk of loss is eliminated. It is not a good investment as the risk of loss is not eliminated. It is a good investment as the risk of loss is not eliminated.
A 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 the town 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 0.10, 0.60, and 0.30 for the worst-case, 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. Demand Scenario Center Size Worst Base Best Case Case Case Small 420 520 680 Medium -230 670 820 Large -380 600 1,010 (a) What decision should the town make using the expected value approach? EV(Small) EV(Medium) EV(Large) 558,000 625,000 625,000 × × The best decision is to build a medium or large-sized ✓ community center. (b) Construct risk profiles for the medium and large alternatives (Submit a file with a maximum size of 1 MB.). Choose File No file chosen This answer has not been graded yet. Given the mayor's concern over the possibility of losing money and the result of part (a), which alternative would you recommend? O small-size center O medium-size center O large-size center (c) Compute the expected value of perfect information. EVPI = 122,000 Do you think it would be worth trying to obtain additional information concerning which scenario is likely to occur? The town should not consider additional information about the likelihood of the three scenarios. The town should consider additional information about the likelihood of the three scenarios. (d) Suppose the probability of the worst-case scenario increases to 0.2, the probability of the base-case scenario decreases to 0.5, and the probability of the best-case scenario remains at 0.3. EV(Small) 0.2 EV(Medium) 0.5 EV(Large) 0.3 What effect, if any, would these changes have on the decision recommendation? The best decision is to build a small community center. (e) 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. The campaign can be expected to also increase the probability of the best-case scenario to 0.4. (Remember to subtract the cost of the promotional campaign from the expected value.) EV(Small) 434,000 EV(Medium) 580,000 EV(Large) 614,000 The best decision is to build a large community center. Compared to the analysis in part (d), is this a good investment? It is a good investment as the risk of loss is eliminated. It is not a good investment as the risk of loss is eliminated. It is not a good investment as the risk of loss is not eliminated. It is a good investment as the risk of loss is not eliminated.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.