Please work out the problem in excel sheet and make tables for everything asked. For the summary part please type the answer and for the excel please put the screenshot of the results and also the formulas or cell reference used to get the answer. Will rate the answer for sure. Thanks a lot

A company is analyzing a possible decision to either outsource its operations to a South Carolina Company, Mexico, or keep the operations internal. Run your analysis. You must use excel formulas for everything except where you need to write the Decision Criterion's decision. Calculate Maximax, Maximin, Equally Likely, Hurwicz (a=.4), Minimax Regret, Expected Montary Value, Expected Opportunity Lost, and Expected Value of Perfect Information if we looking at spending 5,000 to do market research. Is the market research worth the cost??? Write a summary of the Decision Making without probabilities, if you were the CEO of this company what would your decision be? Probability Outsource Operations to a South Carolina Company Outsource Operations to Mexico Keep Operations Internal Good Economic Conditions 0.45 $30,000.00 $25,000.00 $20,000.00 Average Economic Conditions 0.35 $20,000.00 $15,000.00 $13,000.00 Peer Economic Conditions 0.2 $10,000.00 -$15,000.00 $10,000.00 Good Economic Conditions 0.45 Average Economic Conditions Peer Economic Conditions 0.2 Rerret Table Probability Outsource Operations to a South Carolina Company Outsource Operations to Mexico Keep Operations Internal