Question: PLEASE SOLVE PROBLEMS IN EXCEL AND WRITE DOWN ALL FORMULAS/FUNCTIONS Walker Accounting Software is marketed to small accounting firms throughout the U.S. and Canada. Owner
PLEASE SOLVE PROBLEMS IN EXCEL AND WRITE DOWN ALL FORMULAS/FUNCTIONS
Walker Accounting Software is marketed to small accounting firms throughout the U.S. and Canada. Owner George Walker has decided to outsource the companys help desk and is considering three providers: Manila Call Center (Philippines), Delhi Services (India), and Moscow Bell (Russia). The following table summarizes the data Walker has assembled. Which outsourc- ing firm has the best rating? (Higher weights imply higher impor- tance and higher ratings imply more desirable providers.)
| Provider Ratings | |||||
| Factor | Weight | A | B | C | D |
| Labor | w | 5 | 4 | 3 | 5 |
| Quality procedures | 30 | 2 | 3 | 5 | 1 |
| Logistics system | 5 | 3 | 4 | 3 | 5 |
| Price | 25 | 5 | 3 | 4 | 4 |
| Trustworthiness | 5 | 3 | 2 | 3 | 5 |
| Technology in place | 15 | 2 | 5 | 4 | 4 |
| Management team | 15 | 5 | 4 | 2 | 1 |
Weights are on a scale from 1 through 30, and the outsourcing provider scores are on a scale of 1 through 5. The weight for the labor factor is shown as a w because Raos OM team cannot agree on a value for this weight. For what range of values of w, if any, is company C a recommended outsourcing provider, according to the factor-rating method?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help