As shown in the table below where the demand level is composed of two states only (Low
Fantastic news! We've Found the answer you've been seeking!
Question:
As shown in the table below where the demand level is composed of two states only (Low and High) and an estimate of their probabilities is given, answer the following questions. Show your work
Demand Level | |||
Probability | 0.20 | 0.80 | |
Low | High | ||
Alternative | Large Capacity | ($5,000) | $25,000 |
Average Capacity | $5,000 | $20,000 | |
Small Capacity | $4,000 | $9,000 | |
Net Profits |
- Using Excel, create an X,Y plot the expected-value lines for the three alternatives on a graph. Label the graph completely and clearly.
- Is there any alternative that would never be appropriate in terms of maximizing expected profit? Explain on the basis of your graph in part a.
- Over what range of P(High Demand) would alternative Large Capacity be the best choice if the goal is to maximize expected profit? Over what range of P(High Demand) would alternative Average Capacity be the best choice if the goal is to maximize expected profit?
- Using the probability of High Demand as 0.80 (therefore probability of Low Demand = 0.20), compute the expected payoffs of each of the alternatives. Show work. Using the expected payoff criterion, which of the alternatives will you recommend?
- Using the probability of High Demand as 0.80 (therefore probability of Low Demand = 0.20), compute the EVPI. Show work. Explain the significance of this number (i. what does it mean in terms of decision-making on the alternatives? How is this information to be used?).
- Using the sensitivity analysis approach, how confident will you be in building a large capacity operation? Do not express an opinion. Support your answer with the analysis above.
Related Book For
Business Forecasting with ForecastX
ISBN: 978-0073373645
6th edition
Authors: Holton wilson, barry keating, john solutions inc
Posted Date: