$6.$ ANSWER THIS QUESTION IN EXCEL PLEASE WITH SOLVER: The Miramar Company in Hawaii is evaluating the introduction of one of three new products: a surfboard, a ukulele, or a coffee blend. The market conditions $($favorable$,$ stable, or unfavorable$)$ will significantly influence the profit or loss the company realizes. The probabilities for each market condition and the potential financial outcomes for each product are outlined in the following table: Product Market Condition: Favorable $(20\%)$ Stable $(70\%)$ Unfavorable $(10\%)$ Surfboard $$120,000$ $$70,000-$$$30,000$ Ukulele $$60,000$ $$40,000$ $$20,000$ Coffee Blend $$35,000$ $$30,000$ $$30,0001.$ Determine which possible strategy Miramar Company should employ using the following decision criteria a$.$ Maxima b$.$ Maximin c$.$ Minimax regret d$.$ Hurwicz $(=\mathrm{.}4)$ e$.$ Equal likelihood $2.$ Compute the expected value for each decision, and select the best one. $3.$ Develop the opportunity loss table, and compute the expected opportunity loss for each product. $4.$ Determine how much the firm would be willing to pay to a market research firm to gain better information about future market conditions $($perfect information$).$