Create an Excel Spreadsheet for Both Problems. Answer the questions on this sheet. Printout the formulas and the spreadsheet, Turn in the printout of the answer to the questions, the spreadsheet, and the formulas. Problem #1 Ranga Ramasesh is the operations manager for a firm that is trying to decide which one of four countries it should research for possible outsourcing providers. The first step is to select a country based on cultural risk factors, which are critical to eventual business success with the provider. Ranga has reviewed outsourcing provider directories and found that the four countries in the table below have an ample number of providers from which they can choose. To aid in the country selection step, he has enlisted the aid of a cultural expert, John Wang, who has provided ratings of the various criteria in the table below. The resulting ratings are on a 1 to 10 scale, where 1 is a low risk and 10 is a high risk. Further, John Wang has determined six criteria weightings. Trust, with a weight of 0.40; Quality, with 0.20; Religious, with 0.10; Individualism, with 0.10; Time, with 0.10; Uncertainty, with 0.10. Using the weighted factor-rating method, which country should Ranga select? In the following table, compute the total weighted score for each candidate (enter each response as a decimal rounded to one place) Selection Criteria Weight Mexico Panama Peru Trust Society value of quality work Religious attitudes Individualism attitudes Time orientation attitudes Uncertainty avoidance attitude Total Weighted averages 0.40 0.20 0.10 0.10 0.10 0.10 4 4 3 4 4 3 1 3 3 6 6 2 Costa Rica 3 4 3 2 7 4 2 5 5 3 3 2 Which location should be selected based on the weighted locations? Why