I would like help with the following question:

You are in the process of planning a vacation to an exotic tropical island The island is served by" onlj.T one airline that is offering the following fare options: 1. But; a nonrefundable ticket for $3511] 2. Buy a full}; refundable exible ticket for 32mm If you buffr now, there is a 25% chance that your trip will need to be cancelled at the last minute because of demands from work Unused nonreindable tickets have no redemption value {are worthless], but a exible ticket can be refunded for the full price of the ticket You can also wait a week before buying your ticket. In that case: you assess that there is a :5an chance that fares will increase- If this happens, nonrefundable tickets will increase to a price of $120U', whereas the price of the exible tickets will be $229!]- However; in a week you will have greater clarity with regard to work demands: and the chance that the trip will need to be cancelled after you purchase the ticket will go down to just 5%. You have already determined that this vacation is worth going on (unless forced to cancel due to work reasons). You assign a dollar 1aralue to the pleasure and satisfaction of going on this vacation {assume this is 3?,5U'). a) Implement this decision problem in Excel and attach an image of the treel b} Describe the optimal decision in words [be careil to specify:r what needs to be done at each decision point that could be reached). c) at is the HEW of the optimal decision;I u ose eo tronto u awee oinnowcano Y o tame a a ee- tis Spp th p' by kfr nl_beb'db}rp}ringfwrha'ie most you would be willing to pay for this option {in what is the value of being able to Izlelafpr a decision]