A company is deciding whether to develop and launch a new product. Research and development costs are expected to be $300,000 and there is a 60% chance that the product launch will be successful, and a 40% chance that it will fail. If it is successful, the levels of expected revenue and the probability of each occurring have been estimated as follows, depending on whether the product popularity is high, medium or low Revenue 500,000 er year for two years 400,000 per year for two years $300,000 per year for two years High: 0.25 0.45 0.3 Medium If it is a failure, there is a 0.55 probability that the research and development work can be sold for $60,000 and a 0.45 probability that it will be worth nothing at all a. Construct a decision tree for this problem and answer this question that whether this company should develop and launch this new product. Please draw your decision tree in PrecisionTree enter all given data, and analyze the problern over there to answer this question Hint: Please enter all of the given data/parameters value in Excel cells; rather than writing their constant values, that you can refer to them to calculate necessary values for each branch of your decision tree. This will be needed in order to be able to conduct sensitivity analysis of different influencing factors in part "b". (30 points) Provide a list (At LEAST 4) of influencing factors/parameters (e.g. revenue per year when product popularity is high) on the final decision to develop and launch the new product or not. (5 points) For your provided list in part b", select 2 of those factors, conduct a one-way sensitivity analysis for each SEPARATELY, show your graphs, and describe the behaviar you abserve. (15 points) b. c. d. For your provided list in part "b, which factor is the most influential one on the decision to develop and launch the product or not? Please support your answer by providing necessary graphs and explaining them. Only conduct one-way sensitivity analysis in this part. (10 points) A company is deciding whether to develop and launch a new product. Research and development costs are expected to be $300,000 and there is a 60% chance that the product launch will be successful, and a 40% chance that it will fail. If it is successful, the levels of expected revenue and the probability of each occurring have been estimated as follows, depending on whether the product popularity is high, medium or low Revenue 500,000 er year for two years 400,000 per year for two years $300,000 per year for two years High: 0.25 0.45 0.3 Medium If it is a failure, there is a 0.55 probability that the research and development work can be sold for $60,000 and a 0.45 probability that it will be worth nothing at all a. Construct a decision tree for this problem and answer this question that whether this company should develop and launch this new product. Please draw your decision tree in PrecisionTree enter all given data, and analyze the problern over there to answer this question Hint: Please enter all of the given data/parameters value in Excel cells; rather than writing their constant values, that you can refer to them to calculate necessary values for each branch of your decision tree. This will be needed in order to be able to conduct sensitivity analysis of different influencing factors in part "b". (30 points) Provide a list (At LEAST 4) of influencing factors/parameters (e.g. revenue per year when product popularity is high) on the final decision to develop and launch the new product or not. (5 points) For your provided list in part b", select 2 of those factors, conduct a one-way sensitivity analysis for each SEPARATELY, show your graphs, and describe the behaviar you abserve. (15 points) b. c. d. For your provided list in part "b, which factor is the most influential one on the decision to develop and launch the product or not? Please support your answer by providing necessary graphs and explaining them. Only conduct one-way sensitivity analysis in this part. (10 points)