management >> Basic Components
by rwoodson » Wed, 06 Jul 2005 05:24:11 GMT
I did a COTS matrix last year. Here is how I did it.
Put together a list of your basic requirements. Group the items in the
list into logical headings. Rank each item in terms of how important it
is. Rankings are not only orderings of the items, but tags such as
"Must Have", Should Have", "Would be Nice to Have", and
"Doesn't matter because the only one who wanted it was that weird
guy in Accounting".
Using a workbook, in spreadsheet 1, Col A = the ranking, Col B = the
requirement, Col C = A better description of the requirement (which can
be hidden), Col D = "Can Do? Y/N", and Col E = the first vendor
possibility. Col D is a column that tells you if the vendor can do the
requirement at all. Col E is for briefly explaining how the vendor will
accomplish the requirement, IE: is it standard functionality,
tailoring, or customization? Col E can also be used for short
commentary about that item and that vendor. Col D and Col E repeat for
each of the vendors you are considering. You should also have a column
for your own comments, and a column for explanation or the importance
of the requirement.
Spreadsheet 2 is for your voting. It repeats Col A and B. Col C is the
possible point value for the item (Must Have = 4, Should Have = 3,
etc.). The next 5 to whatever columns are for each of the vendors and
each voter within each vendor
Vendor1 Vendor2
You Me Him You Me Him
2 1 2 1 2 1
Spreadsheet 3 is the voting categories, and results.
Product Ranking Vendor1 Vendor2
Grouping Score Rank Score Rank
Product Requirements / Compliance 5 1 4 2
Search Capabilities
Reporting Flexibility
Storage Options
Workflow Interface and Administration
System Security
System Administration
User Interface
Totals
Overall Score
Overall Rank
Hope this helps. There is a fairly new book out on Procurement
Management by Quintin Fleming that you might want to pick up.