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...
icon
Related questions
Question
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
Transcribed Image Text: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.
Transcribed Image Text:(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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.