Question: 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

show all work on excel Use Excel for the 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!