Instructions:
In this assignment, you will be using a weighted decision model (also known as a weighted matrix) to help a company select a new CRM system. Use the information given below and construct a weighted matrix model that accounts for all information to help the company make the most appropriate choice
- Begin by reading the article titled: Constructing a Weighted Matrix" here.
- You may also want to familiarize yourself with CRM selection criteria. See the article here.
The company is evaluating several facets of CRM systems.
These facets and their relative importance is listed below:
|
Contact Management
|
20.0%
|
|
Reporting
|
15.0%
|
|
Predictive Analytics
|
15.0%
|
|
Marketing Automation Integration
|
10.0%
|
|
Lead Management
|
10.0%
|
|
Mobile
|
2.5%
|
|
Social
|
2.5%
|
|
Cost
|
25.0%
|
Each vendor's ability to meet these criteria is rated on a scale of 1 to 5. With 5 indicating good alignment, and 1 indicating poor alignment.
|
Vendor
A
|
Vendor
B
|
Vendor
C
|
Vendor
D
|
|
Contact Management
|
S
|
4
|
5
|
4
|
|
Reporting
|
3
|
4
|
5
|
1
|
|
Predictive Analytics
|
4
|
3
|
2
|
1
|
|
Marketing Automation Integration
|
1
|
3
|
5
|
5
|
|
Lead Management
|
5
|
5
|
1
|
4
|
|
Mobile
|
4
|
3
|
4
|
2
|
|
Social
|
3
|
2
|
3
|
4
|
|
Cost
|
2
|
3
|
4
|
4
|
Assignment Requirements:
- Create a weighted decision model that evaluates these CRM systems (download values here ).
- Include a copy of your Microsoft Excel file that includes this model.
- In one page briefly describe the evaluation and make a recommendation to the company on the system that they should select.