Only Question 5 please show work thank you

PROBLEMS Level A 4. The fixed cost of S6 million in the Acme problem is evidently not large enough to make Acme abandon the product at the current time. How large would the fixed cost need to be to make the abandon option the best option? Explain how the decision tree, especially the version in Figure 6.5, answers this question easily Perform a sensitivity analysis on the probability of a great market. To do this, enter formulas in cells B9 and B10 (see Figure 6.4) to ensure that the probabili- ties of "fair" and "awful" remain in the same ratio, 35 to 20, and that all three probabilities continue to sum to 1. Then let the probability of "great" vary from 0.25 to 0.50 in increments of 0.05. Is it ever best to abandon the product in this range? 5 Sometimes it is possible for a company to influ- ence the uncertain outcomes in a favorable direction. Suppose Acme could, by an early marketing blitz, change the probabilities of "great," "fair," and "awful" from their current values to 0.75, 0.15, and 0.10. In terms of EMV, how much would the company be willing to pay for such a blitz? 6. PROBLEMS Level A 4. The fixed cost of S6 million in the Acme problem is evidently not large enough to make Acme abandon the product at the current time. How large would the fixed cost need to be to make the abandon option the best option? Explain how the decision tree, especially the version in Figure 6.5, answers this question easily Perform a sensitivity analysis on the probability of a great market. To do this, enter formulas in cells B9 and B10 (see Figure 6.4) to ensure that the probabili- ties of "fair" and "awful" remain in the same ratio, 35 to 20, and that all three probabilities continue to sum to 1. Then let the probability of "great" vary from 0.25 to 0.50 in increments of 0.05. Is it ever best to abandon the product in this range? 5 Sometimes it is possible for a company to influ- ence the uncertain outcomes in a favorable direction. Suppose Acme could, by an early marketing blitz, change the probabilities of "great," "fair," and "awful" from their current values to 0.75, 0.15, and 0.10. In terms of EMV, how much would the company be willing to pay for such a blitz? 6