Click main image to view in full screen.
BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT
- Executive Dashboard: Displays preferred vendor recommendations (🏆 Recommended, 🥈 Shortlisted, ❌ Eliminated), top weighted scores, and financial summary cards automatically.
- Weighted Evaluation Framework: Score up to 4 vendors across 6 core criteria categories (Business Requirements, Security & Architecture, Usability, Vendor Reliability, Deployment Costs, Timeline).
- 3-Year TCO Calculator: Full breakdown of upfront licensing, implementation fees, cloud hosting, change management, and ongoing Year 2/3 maintenance costs.
INFORMATION TECHNOLOGY EXCEL DESCRIPTION
Making the right software or ERP choice is a multi-million dollar decision. Evaluating competing vendors on pricing alone often leads to hidden integration costs, scope creep, and low user adoption.
This IT Solution & Software Selection Matrix provides a structured, objective, and executive-ready decision framework. Designed for CTOs, CIOs, Procurement Leads, and Enterprise Architects, it simplifies vendor shortlisting by combining weighted functional scoring with a comprehensive 3-Year Total Cost of Ownership (TCO) calculator.
Key Features & Capabilities
Executive Dashboard: Displays preferred vendor recommendations (🏆 Recommended, 🥈 Shortlisted, ❌ Eliminated), top weighted scores, and financial summary cards automatically.
Weighted Evaluation Framework: Score up to 4 vendors across 6 core criteria categories (Business Requirements, Security & Architecture, Usability, Vendor Reliability, Deployment Costs, Timeline).
3-Year TCO Calculator: Full breakdown of upfront licensing, implementation fees, cloud hosting, change management, and ongoing Year 2/3 maintenance costs.
100% Customizable: Easily add sub-criteria, modify category weights, or update scoring rules without breaking formulas.
What's Included in the Workbook?
Instructions & Settings: Central project setup, custom criteria weighting.
.Executive Summary: C-level report presenting overall vendor rankings, score percentages, and timeline metrics.
Detailed Evaluation Matrix: Granular 1–5 scoring sheet across functional, technical, and vendor & TCO Analysis: Complete 36-month cost forecast model broken down by initial and recurring expenses.
Who Is This Template For?
CIOs, CTOs & IT Directors selecting Enterprise Software (ERP, CRM, HCM, WMS, BI tools).IT Procurement Managers & Buyers running formal RFPs or vendor comparative studies.Management Consultants & Enterprise Architects advising clients on software selection.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Information Technology, Make or Buy Excel: IT Solution & Software Selection Matrix Excel (XLSX) Spreadsheet, g60523761e11
