Use Excel for the calculations for this problem. Be sure to use the SUMPRODUCT Function Good Plumbing Company decided to outsource their payroll department and is considering three outsource providers Payroll Partners (Montana), Payroll Resources (India), and Payroll Partners (Phillipines). The following table summarizes the data Singleton has assembled. Payroll Importance Weight Partners Payroll Payroll Resources Partners + Nearness to facility Trustworthiness Price Accuracy 0.2 90 50 60 0.4 80 70 75 0.2 50 90 80 0.2 80 70 80 a. (5 points) Which outsourcing firm has the best rating? (Higher weights imply higher importance and higher ratings imply more desirable providers.) Why? I b. (5 points) Which provider is the most desirable if the weights for trustworthiness and price are switched? Now trustworthiness has an importance weight of 0.2 and price has a weight of 0.4.