PLEASE SHOW ALL SOLVER WORKING AND ANALYSIS/RECOMMENDATIONS.

A famous car dealership is soon going to open a new dealership. They have three offers: from a foreign compact car company, from a U.S. producer of full-sized cars, and from a truck company. The success of each type of dealership will depend on how much gasoline is going to be available during the next few years. The profit from each type of dealership, given the availability of gas, is shown in the following payoff table: Dealership Compact cars Full-sized cars Trucks Gasoline Availability Shortage Surplus .6 .4 $ 300,000 $150,000 -100,000 600,000 120,000 170,000 Part (a) Determine which type of dealership should be purchased. Please use the expected value decision criterion. Part (b) Construct a decision tree for the decision situation described on this problem and indicate the best decision. Part (c) The car dealership is considering hiring a petroleum analyst to determine the future availability of gasoline. The analyst will report that either a shortage or a surplus will occur. The probability that the analyst will indicate a shortage, given that a shortage actually occurs is.90; the probability that the analyst will indicate a surplus, given that a surplus actually occurs is.70. 1. Determine the decision strategy the dealership should follow, the expected value of this strategy, and the maximum amount the dealership should pay for the analyst's services. 2. Compute the efficiency of the sample information for the car dealership. What to submit: Final submission must be an Excel file with answers to the above questions, including any excel solver answer reports. Please include a written recommendation or interpretation of your data. You may follow the format of the examples provided in the Excel Lab