+1443 776-2705 panelessays@gmail.com

 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.

You may also want to familiarize yourself with CRM selection criteria. 

Video to help on youtube

 https://www.youtube.com/watch?v=MJsWEMDhRQ8 

 

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

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.

Assignment Requirements:

  • Create a weighted decision model that evaluates these CRM systems.
  • 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.

Unworked

Buying a House
Criteria Age Location Cost
Age 20% < 10 Years 3 Excellent Area 3 Below Budget 3
Location 40% < 20 Years 2 Great area 2 At Budget 2
Cost 40% > 20 Years 1 Good area 1 Over Budget 1
Property Age Location Cost Sum
123 Main St 3 3 1
2506 Pearl Dr 2 3 2
455 Washington Ave 2 2 2
3451 Harmony Ln 1 1 3

Worked

Buying a House
Criteria Age Location Cost
Age 20% < 10 Years 3 Excellent Area 3 Below Budget 3
Location 40% < 20 Years 2 Great area 2 At Budget 2
Cost 40% > 20 Years 1 Good area 1 Over Budget 1
Property Age Location Cost Sum
20% 40% 40%
123 Main St 3 0.6 3 1.2 1 0.4 2.2
2506 Pearl Dr 2 0.4 3 1.2 2 0.8 2.4
455 Washington Ave 2 0.4 2 0.8 2 0.8 2
3451 Harmony Ln 1 0.2 1 0.4 3 1.2 1.8