show all work on excel

Use Excel for the calculations for this problem. Be sure to use the SUMPRODUCT Function Mark's Marketing firm has decided to outsource their payroll department and is considering three outsource providers Speedy Payroll (Philippines), Do it Fast Payroll (India), and Pay it Right Payroll (Russia). The following table summarizes the data Mark's has assembled. Importance Weight Speedy Do it Fast Pay it Right 0.5 Flexibility Trustworthiness 70 60 80 60 0.2 50 80 Price Delivery 70 60 60 0.1 0.1 60 70 80 a. Which outsourcing firm has the best rating? ( Higher weights imply higher importance and higher ratings imply more desirable providers.) Why? b. Which provider is the most desirable if the weights for trustworthiness and flexibility are switched? Now trustworthiness has an importance weight of 0.5 and flexibility an importance weight of 0.1