Hello Team, The assignment is a problem solving assignment and has 4 questions to be answered. The writer must create a precision tree in excel sheet to answer the question and a report of 1000 words must also be provided. I'm attaching the assessment task, you can find the question in that file. Also i'm attaching a sample precision tree file and the excel sheet solution for an another problem where they have used the precision tree to solve the problem, i want the writer to provide me with a similar answer model in an excel sheet. Kindly take a look at them and let me know if you can do it, so that i can proceed to the payment. Scenario You are to undertake a study to find out whether the company Sharp Outfits needs to delay the shipment of customer orders in the face of delivery uncertainty. Case Study Sharp Outfits is trying to decide whether to ship some customer orders now via UPS or wait until after the threat of another UPS strike is over. If Sharp Outfits decides to ship the requested merchandise now and the UPS strike takes place, the company will i****** $******00 in delay and shipping costs. If Sharp Outfits decides to ship the customer orders via UPS and no strike occurs, the company will i****** $****** in shipping costs. If Sharp Outfits decides to postpone shipping its customer orders via UPS, the company will i****** $******00 in delay costs regardless of whether UPS goes on strike. Let p represent the probability that UPS will go on strike and impact Sharp Outfits’s shipments. a. For which values of p, if any, does Sharp Outfits minimise its expected total cost by choosing to postpone shipping its customer orders via UPS? b. Suppose now that, at the cos****** $******, Sharp Outfits can purchase information regarding the likelihood of a UPS strike in the near future. Based on similar strike threats in the past, the company assesses that if there will be a strike, the information will predict a strike with probability 0.75, and if there will not be a strike, the information will predict no strike with probability 0.85. Provided that p = 0.15, what strategy should Sharp Outfits pursue to minimise its expected total cost? c. Using the analysis from part b, find the EVSI when p = 0.15. Then use a data table to find EVI for p from 0.05 to 0.30 in increments of 0.05, and chart EVI versus p. d. continuing part 5, calculate and interpret the EVPI when p = 0.15. ASSIGNMENT TASKS • Construct a spreadsheet model with decision tree. • Develop a solution for Sharp Outfits, and write your recommendation in the form of a report. ASSESSMENT ELEMENTS • Spreadsheet. • Report.