weight decsiion model
Rhiastudent20
weighteddecisionmodel.docxIn 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 reviewing the following resources on Constructing a weighted matrix.
· Constructing a weighted matrix (Links to an external site.) . (Borysowich, 2006) https://it.toolbox.com/blogs/craigborysowich/constructing-a-weighted-matrix-112306
· CRM software selection quick start guide (Links to an external site.) . (SelectHub, 2018).
· Weighted Matrix Model (Herzing Business, 2018).
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.
Assignment Requirements:
· Create a weighted decision model that evaluates these CRM systems.
· Include a copy of your Microsoft Excel file that includes this model.
· Below your solution output in Excel please write a 3–5-line analysis of this problem and your findings.
Resource(s)
Weighted Matrix Example Download Weighted Matrix Example[Excel Spreadsheet]
Borysowich, C. (2006). Constructing a weighted matrix. Toolbox Tech.https://it.toolbox.com/blogs/craigborysowich/constructing-a-weighted-matrix-112306
SelectHub. (2018). CRM software selection quick start guide. [Weblog] https://selecthub.com/customer-relationship-management/crm-software-selection-quick-start-guide/
Herzing Business. (2018 Oct 11). Weighted Matrix Model. [Video]. YouTube. https://youtu.be/MJsWEMDhRQ8
Assignment Requirements:
· Create a weighted decision model that evaluates these CRM systems.
· Include a copy of your Microsoft Excel file that includes this model.
· Below your solution output in Excel please write a 3–5-line analysis of this problem and your findings.
Resource(s)
Weighted Matrix Example Download Weighted Matrix Example[Excel Spreadsheet]
Borysowich, C. (2006). Constructing a weighted matrix. Toolbox Tech.https://it.toolbox.com/blogs/craigborysowich/constructing-a-weighted-matrix-112306
SelectHub. (2018). CRM software selection quick start guide. [Weblog] https://selecthub.com/customer-relationship-management/crm-software-selection-quick-start-guide/
Herzing Business. (2018 Oct 11). Weighted Matrix Model. [Video]. YouTube. https://youtu.be/MJsWEMDhRQ8
