a) Based on the scores provided in the table below, which service provider should be chosen? b) What score should Provider C get in the category “online plat- form" to be considered the best option?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
•.. 2.12 You are about to establish your own business; your
strategy is to focus on your core business and outsource the cus-
tomer service to an external service provider to handle the custom-
ers’ requirement queries and complaints. Based on an extensive
study, you have identified 6 key factors for the service provider.
Four service providers have offered their service and you and your
team have scored 4 different potential providers on the 6 factors,
using a scale of 1 to 5, with 5 representing the best option.
a) Based on the scores provided in the table below, which service
provider should be chosen?
b) What score should Provider C get in the category "online plat-
form" to be considered the best option?
SERVICE PROVIDER RATING (OUT OF 5)
WEIGHT PROVIDER PROVIDER PROVIDER PROVIDER
D
FACTORS
A
B
Speak Arabic
and English
20
5
2
3
2
Live chat
15
1
4
1
24 hours
service
25
4
Price
4
1
1
Location
2
3
4
Online
30
4
3
1
platform
5.
Transcribed Image Text:•.. 2.12 You are about to establish your own business; your strategy is to focus on your core business and outsource the cus- tomer service to an external service provider to handle the custom- ers’ requirement queries and complaints. Based on an extensive study, you have identified 6 key factors for the service provider. Four service providers have offered their service and you and your team have scored 4 different potential providers on the 6 factors, using a scale of 1 to 5, with 5 representing the best option. a) Based on the scores provided in the table below, which service provider should be chosen? b) What score should Provider C get in the category "online plat- form" to be considered the best option? SERVICE PROVIDER RATING (OUT OF 5) WEIGHT PROVIDER PROVIDER PROVIDER PROVIDER D FACTORS A B Speak Arabic and English 20 5 2 3 2 Live chat 15 1 4 1 24 hours service 25 4 Price 4 1 1 Location 2 3 4 Online 30 4 3 1 platform 5.
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.