Read, understand and solve the given problem carefully. Use Microsoft Excel as a tool in solving the problem. Create a managerial report in a separate worksheet. Submit a softcopy of your excel file. Amy Lloyd is interested in leasing a new Saab and has contracted three automobile dealers for pricing information. Each dealer offered Amy a closed-end- 36 month lease, with no down payment due at the time of signing. Each lease includes a monthly charge and a mileage allowance. Additional miles receive a surcharge on a per-mile basis. The monthly lease cost, the mileage allowance, and the cost for the additional miles follow: Dealer Monthly cost Mileage allowance Cost per additional mile Forno Saab $299 36,000 SO.15 Midtown motors $310 45,000 SO.20 Hopkins Automotive $325 54,000 SO.15 Amy decided to choose the lease option that will minimize her total 36-month cost. The difficulty is that Amy is not sure how many miles she will drive over the next three years. For purpose of this decision she believes it is reasonable to assume that she will drive 12,000 miles per year, 15,000 miles per year, or 18,000 miles per year. With this assumption Amy estimated her total costs for the three lease options. For example, she figures that Forno Saab lease will cost her 10,764 dollars if she drives 12,000 miles per year, 12,114 dollars if she drives 15,000 miles per year, or 13,464 dollars if she drives 18,000 miles per year. a. Construct a payoff table for Amy's problem b. If Amy has no idea which of the three mileage assumptions is most appropriate, what is the recommended decision using optimistic, conservative and minimax regret approach? C. Suppose that the probabilities that Amy drives 12,000, 15000, and 18,000 miles per year are 0.5, 0.4, and 0.1, respectively. What option should Amy choose using the expected value approach? d. What is the expected value of perfect information given Amy's