please solve it in excel and also show solver and formula

Problem 3 A NY Times best-selling author wants to write a new book as either volume II of her earlier successful book or an autobiography. She believes that by writing the volume II, given her previous success, she will have a 50% chance of placing it with a major publisher where it should ultimately sell about 40,000 copies. However, the worst-case scenario, if she can't get a major publisher to take it, then she thinks there is 80% chance of placing it with a smaller publisher, with sales of 30,000 copies. On the other hand, if she writes an autobiography, considering the potential interest in her journey as successful writer, she thinks there will be 40% chance of placing it with a major publisher, and it should result in ultimate sales of about 50,000 copies. If she can't get a major publisher to take it, the worst-case scenario, she thinks there is a 50% chance of placing it with a smaller publisher, with ultimate sales of 35,000 copies, (a) Construct a decision tree to help this author decide. (b) What book should the author pursue? (c) What is the expected payoff for the optimum decision alternative? (d) Set up a systematic sensitivity analysis to choose the best alternative and the expected payoff when the probability of placing the autobiography with a major publisher ranges from 0.4 to 0.9 (with 0.05 increments). What is the best altemative when this probability is 0.45