Draw a decision tree and determine the payoff for each decision and event node. Which alternative should the manufacturer choose?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 40P
icon
Related questions
Question

Work to be done in EXcel with formulas

A manufacturer must decide whether to build a small or a large plant 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 plant is built, and demand is high, the production manager may choose to maintain the current size or to expand. The net present value of profits is $223,000 if the firm chooses not to expand. However, if the firm chooses to expand, there is a 50% chance that the net present value of the returns will be 330,000 and a 50% chance the estimated net present value of profits will be $210,000. If a small facility is built and demand is low, there is no reason to expand and the net present value of the profits is $200,000. However, if a large facility is built and the demand turns out to be low, the choice is to do nothing with a net present value of $40,000 or to stimulate demand through local advertising. The response to advertising can be either modest with a probability of .3 or favorable with a probability of .7. If the response to advertising is modest, the net present value of the profits is $20,000. However, if the response to advertising is favorable, then the net present value of the profits is $220,000. Finally, if the large plant is built and the demand happens to be high, the net present value of the profits $800,000.

Draw a decision tree and determine the payoff for each decision and event node. Which alternative should the manufacturer choose?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 8 images

Blurred answer
Knowledge Booster
Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,