A company needs a new CRM system. Using the information below construct a weighted matrix model that accounts for all information to help the company make the most appropriate choice. Make a weighted decision model that evaluates these CRM systems.

• Include a copy of the Microsoft Excel file that includes this model.
• Please explain below the solution output in Excel a 3-5-line analysis of this problem and the findings.

The company is evaluating several facets of CRM systems. These facets and their relative importance are listed below:

Contact Management	20%
Reporting	15%
Predictive Analysis	15%
Marketing Automation Integration	10%
Lead Management	10%
Mobile	2.5%
Social	2.5%
Cost	25%

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 Vendor Vendor Vendor A B C D Contact Management 5 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