jagomart
digital resources
picture1_Excel Sheet Download 12008 | It Project Roi Tool | Business Form Tools


 229x       Filetype XLSX       File size 0.76 MB       Source: analysisplace.com


File: Excel Sheet Download 12008 | It Project Roi Tool | Business Form Tools
sheet 1 welcome hide after the quot it project roi and business case toolkit quot enables development of comprehensive business cases for it projects it helps organizations to assess quantify ...

icon picture XLSX Filetype Excel XLSX | Posted on 07 Jul 2022 | 3 years ago
Partial file snippet.
Sheet 1: Welcome



Hide After




















The "IT Project ROI and Business Case Toolkit" enables development of comprehensive business cases for IT projects





It helps organizations to assess, quantify, and communicate the costs, benefits, business value, and ROI of many types of enterprise-scale technology-based initiatives. It also helps to assess the organization’s current (as-is) and expected (to-be) IT spending (TCO) levels and the solution’s impact on a variety of key performance indicators (KPIs). It produces summary business case reports (Word and PowerPoint) that can be edited and presented to decision-makers.

The tool estimates the costs required to implement the new capabilities/solution, including hardware, software, IT labor, services, and user labor. It simulates benefits (user productivity, IT TCO savings, business cost savings, revenue growth, and KPI improvements) enabled by the solutions selected.
It supports both rapid (30 minute) and highly detailed assessments. The tool uses robust industry best-practice methods and research to assist the organization in assessing the costs and benefits of investing in the IT initiative. However, this tool cannot accurately/credibly estimate costs/benefits without review, validation, and adjustment of key data inputs. These inputs should be customized to each particular organization and scenario.






This tool was developed by AnalysisPlace for use with the Excel-to-Word Document Automation Add-In:





https://analysisplace.com/Document-Automation





You may customize this document for your own organization's use.


Version 5.0





This workbook contains many common components. When customizing this document, most organization's find they only need a portion of the components contained within and these may need to be substantially customized.




Workbook Table of Contents











Worksheet Name Title Description






Profile Organizational Profile Collects information about: organization size, location, and industry; end user types and labor costs; summary maturity levels; and the initiative to be modeled. This information is used to estimate default values for all costs and benefits throughout the rest of the model. It displays a summary of costs and benefits of the scenario modeled.






Solution Project/Initiative Descriptions For Reference Only: Lists key features, capabilities, benefits, and common vendors/products for the 18 sample initiative types included in the model.






Costs Implementation Costs Estimates all costs (direct and indirect) needed to implement, fully adopt, and support the solution. Cost categories include: hardware, software, IT labor, and user labor, including one-time and annual on-going costs.






TCO IT Spending (TCO) Estimates as-is (current) and to-be (after the project is implemented) IT spending.






Direct Savings Direct Cost Savings Estimates non-labor direct IT and business cost savings enabled by the solution.






Productivity User Productivity Benefits Estimates user time/labor savings enabled by the solution. First estimates the amount of time users spend conducting common business activities then estimates how much the solution is expected to increase the efficiency of conducting key activities. The time savings is discounted using a "Productivity Conversion Factor", then converted into $ value.






Revenue Revenue Impact Estimates how and how much the solution is expected to increase revenue. The benefit is the profit on the incremental revenue.






KPIs Key Performance Indicator Assessment (Optional) Assessment of how the solution may impact a variety of business KPIs. In this model, these KPI changes are not converted into financial benefits.






ROI Financial Analysis Summary of costs & benefits by type; Cash flow analysis; calculation of ROI, payback period, NPV, and IRR; and graphs


























Key Features










• Supports many types of enterprise-scale technology initiatives. Includes sample cost and benefit data for 18 common initiative types
• Comprehensive assessment of initiative costs and benefits
• Costs: hardware; software; IT labor, training, and services; and user labor and training. All direct and indirect, one-time and on-going costs needed to implement and support the initiative.
• Benefits: IT labor TCO savings, other direct cost savings, user productivity benefits, revenue growth, and non-financial key performance indicators
• Calculates annual on-going IT spending (TCO - total cost of ownership), including hardware, software, internal IT personnel, external service providers, and telecommunications
• Comprehensive financial analysis. Calculates project cash flow, cost-benefit analysis, ROI, NPV, IRR, and payback period
• Supports rapid (30 minute) or detailed assessments. This model was designed to provide either a rapid assessment (by just entering/selecting basic organizational profile and initiative information) or a very detailed assessment by modifying hundreds of detailed inputs.
• Provides default/sample values. Default values (labor costs, user type mix, financial information, TCO, benefits, etc.) are provided based on selected industry, geography, organization size and initiative type to enable more rapid assessments. Data/estimate sources are listed. You may overwrite any of the pre-populated defaults.
• The workbook contains instructions, descriptions, and references. Results are updated real-time and are displayed graphically throughout the model. Although the model is user-friendly, we recommend users have at least a moderately-advanced understanding of business value concepts to develop a credible business case.





Model Components / Flowchart










The chart below illustrates the components of the model.








































































































































Disclaimer










This product is for informational purposes only. AnalysisPlace MAKE NO WARRANTIES, EXPRESS, IMPLIED, OR STATUTORY, AS TO THE INFORMATION IN OR CREATED BY THIS PRODUCT. This tool is intended to help guide organizations in better understanding approximate/potential costs and benefits. Due to limitations of simulation tools, actual results may differ significantly from results estimated in this tool. Investment decisions should not be based on the results of this model alone -- it is not intended to be a substitute for expert advice.

In no event shall AnalysisPlace or suppliers be liable for any damages, including those arising as a result of AnalysisPlace negligence, whether those damages are direct, consequential, incidental, or special, flowing from your use of or inability to use the tool, or information provided herewith, or results of the tool's use, even if AnalysisPlace has been advised of the possibility of such damages.





Terms of Use










By using the product, you accept our "Terms of Use". If you do not accept them, do not use the product.
Summary of terms:
 You MAY create derivative works from this product but only for use within your organization
 You MAY redistribute this product in its original state. If you share this product with other organizations, you must maintain all copyright and other notices contained in this product
 You may NOT sell, rent, lease, or lend this product or portions/derivations of it without written permission from AnalysisPlace






For more information, please see our Terms of Use and Privacy Policy:










Terms of Use: http://analysisplace.com/terms






Privacy Statement: http://analysisplace.com/privacy











About the AnalysisPlace "Excel-to-Word Document Automation Add-In":










AnalysisPlace builds the Excel-to-Word Documentation Add-in. Our Add-in helps corporations and entrepreneurs work smarter and faster by automating the updating of Word or PowerPoint from Excel assessments.





The Excel-to-Word Document Automation Add-in automates updating of Excel-based content into Word and PowerPoint documents. Updatable content includes text, tables, and charts. It also makes it easy to link the “dynamic” content to be updated. Update any new or existing Word/PowerPoint document with content from any new or existing Excel workbook. It is easy to link existing spreadsheets and documents.





The add-in can be used in a wide variety of document automation scenarios. Here are a few:
- Customer business cases (from an Excel-based ROI/TCO Tool)
- Personalized sales and marketing collateral, including proposals and quotes
- Custom product documentation (from Excel sizing/capacity/configurator)
- Recurring financial reports (from Excel analysis)
- Custom datasheets (from engineering/scientific calculations in Excel)
The free "Basic" version does not require registration or login and is a great option to evaluate the add-in and for users with basic content automation needs. Fee-based versions are also available to enable premium and enterprise features and require an AnalysisPlace.com account.

















































Support / Contact










AnalysisPlace does not guarantee support for free tools. However, we do encourage you to provide comments, suggestions, and feedback.






Andrew Hall









www.analysisplace.com






























©AnalysisPlace. www.analysisplace.com














Hide After











Sheet 2: Profile

Organizational Profile

















This worksheet contains key inputs/assumptions that drive cost and benefit calculations throughout the model. Defaults input values are provided based on industry, location, and organization size. These default input values should be reviewed and modifed as appropriate. A summary of the results is provided to the right to assist in viewing output implications of input changes. This summary data will be updated as changes are made throughout the model.

Required Organization/Project Data








Summary Pre-view of Results








Enter values or select the closest fit from the drop-down menus. These are the most important inputs in the model. Your answers to these key questions will have the most significant impact on default cost and benefit drivers through-out the rest of the model.




Project Type










Project Type - Select the initiative type from the drop-down box that most closely matches the initiative to be modeled Data Center / Server















Project Scale (Investment level) Minor (e.g. enhancement/upgrade)




This pre-populates all costs and benefits with sample data based on the initiative type. If you do not want default values (all zeros), select "No Sample Data - Zero-out all costs/benefits". Sample data should not be used for making investment decisions. Sample data is not meant to represent average/typical project results and is only parially based on research. It should only be used as a starting point for assessing the business value of your project. Initiative costs and benefits can differ substantially from one organization to another.




Project Name: Data Center / Server






















Project Description:
















• Virtualization, consolidation, clustering, real-time infrastructure, self-service provisioning, power and cooling
• Improved performance, reliability, manageability, security
• Multi-core, 64-bit, RISC/Itanium, x86
• Web servers, application servers, DBMS servers, data warehouse servers, infrastructure servers, high performance computing servers












Vendors / Products (Optional):
















• Microsoft Windows Server, Novell SUSE, Red hat, Unix, Solaris, IBM AIX, HP–UX
• IBM, HP, Dell, Sun, Fujitsu, Bull





















Results Summary






Organization Profile









Per User Organization Total (000)





Organization Name CompanyName


Costs $149 $411





Industry - select the closest-matching from the drop-down Average or combination


Benefits $1,057 $2,909








Net Benefits $908 $2,498





Industry is used to pre-select various default values







NPV (Net Present Value) $703 $1,934





Primary geographic location - select the closest-matching from the drop-down NORTH AMERICA - United States


ROI 608%








IRR (Internal Rate of Return) 216%





Used to scale labor costs and estimate default work hours per year


Payback Period (Months)** 5




Organization Size / Project Scope








*Return on Investment - [Net Benefits / Total Costs]







Enter known value for one (or more) or the following inputs for the portion of the enterprise/organization that is in scope (impacted by the project). Other values are scaled based on the 1st value entered. Project scope could be the entire organization (default), a business unit, a division, etc. Size/scope data is used to scale most costs/benefits throughout the tool.


**From when benefits start to accrue







Employees / FTEs (in project scope) 5,000 Revenue per FTE (000):
$447











Organization Revenue (Millions) in scope $2,234 Million













Number of PC Users (in scope) 2,752 PC users as a % of employees: 55%










PC users as a % of employees:


Total Number of PCs (in scope) 3,275 Average PCs per PC User: 1.2










Average PCs per PC User:


Source of default data: HCR Benchmark Metric Database and is based on analysis of data from HCR assessments and surveys, Fortune 500, Fortune Magazine and is industry-dependent (varies depending on industry selected above)




























Current Adoption of IT Capabilities and Best Practices

















Characterize your organization's adoption of needed IT Capabilities and Best Practices in the following 4 domains:











Sales/Marketing 2. Basic - We lag in effective adoption of capabilities compared to others in our industry











Business Management 2. Basic - We lag in effective adoption of capabilities compared to others in our industry











Supply/Operations 2. Basic - We lag in effective adoption of capabilities compared to others in our industry






Technology Management & Operations 2. Basic - We lag in effective adoption of capabilities compared to others in our industry




Purpose / Status of this Assessment











This tool may upload data entered into this tool to a server database. Your responses to the 2 questions below will help us determine if and how to use the collected data to improve future versions of the tool. Note that we will never share data you've entered into this tool and we will never publish anything that reveals your identity or the identity of the organization being assessed.





Assessment Purpose / Status










Testing / evaluation of this toolkit





Confidence Level in Accuracy of the Data Entered and Results










Low confidence - most data entered are quick estimates/guesses and may not be realistic










Financial Information












Default values are provided based on inputs above. Defaults may be adequate for rapid/preliminary assessments, but otherwise should be reviewed/modified.




Organization Financials











Operating Margin % of Revenue 17.0%









Default value is based on industry average. This margin rate is used to calculate the business value of incremental revenue enabled by the initiative






Discount Rate / Cost of Capital (WACC) 8.2%









Used in Net Present Value calculations








Expected annual revenue growth rate 0.0%









Annual growth rate increases on-going costs and benefits in the cash flow financial analysis. Default is based on HCR analysis of ValueLine data





Project Financial Data












Duration of analysis (years) - Select from drop-down box. 5 Years








Does not include the deployment phase. A 3-year life-expectancy is standard for most IT projects. Some major initiatives may be 7+ years.






Project Start Date











Month 9
9/1/2019






Year 2019



















Project implementation time (prior to realization of any benefits) - Months 6 Months







In this model, the implementation period starts when sigificant costs start to accrue and ends when benefits start to accrue (i.e. recurring costs & benefits start to accrue at the end of the implementation period). NPV calculations are based off the end of the implementation periond.





Recurring benefit realization ramp-up










Year 1 100%








Year 2 100%








Year 3 100%








Determines what portion of the annual recurring steady-state benefits is actually realized. For many projects, only a portion of the steady-state benefits will actually be realized the first year (or two). View the cash flow for how this impacts outcome.















Personnel Profile and Costs












Default values are provided based on inputs above. Defaults may be adequate for rapid/ballpark assessments, but otherwise should be reviewed/modified.




User Type Mix





% of PC Users # of PC Users







Portion of PC Users that are Information Workers (IWs) 44% 1,224







Portion of PC Users that are Data-entry or Structured-Task Workers 56% 1,529







Total PC-Users (# of Employees that use PCs on a regular basis) 100% 2,752







Information Workers (Knowledge Workers) perform non-routine, cognitive, or creative work that often requires both structured and unstructured information inputs from multiple sources -- and that is not repeated throughout the course of the work day or work week. Examples include a product manager, analyst, accountant, engineer, sales executive, CFO, or CIO.
Data-entry and Structured Task Workers perform routine, structured tasks typically in a repeated manner. Examples include a customer service representative, insurance claims processor, or inside sales representative.




Labor Costs




Default values are provided based on inputs above. Defaults may be adequate for rapid/ballpark assessments, but otherwise should be reviewed/modified.




Burden rate (labor overhead as a % of cash compensation)* 32%








Standard Work Hours per Year 1,824















* Non-cash benefits (such as medical insurance and Social Security) and occupancy costs (such as office space and supplies)











Primary Site Locations - select the closest-matching from the drop-down box Suburban / Mixed













Used to scale labor costs. Urban labor costs tend to be 15-20% higher than suburban locations.












Average Ann'l Cash Comp-ensation** Burden Rate Burdened Annual Labor Cost Burdened Weekly Labor Rate Burdened Hourly rate























IT Staff Labor Costs











Application development $93,535 32% $123,466 $2,374 $67.69











Application support $86,715 32% $114,464 $2,201 $62.75











Data center $90,612 32% $119,608 $2,300 $65.57











Desktop / Client $80,382 32% $106,104 $2,040 $58.17











Help desk $53,588 32% $70,736 $1,360 $38.78











Voice Network $77,946 32% $102,889 $1,979 $56.41











Data Network $81,356 32% $107,390 $2,065 $58.88











Management & Administration $111,414 32% $147,066 $2,828 $80.63







Average (weighted) $86,809 32% $114,588 $2,204 $62.82






Source of salary data: based on HCR analysis of Bureau of Labor Statistics data and various Salary Surveys. Salary data is scaled based on industry, geography, and organization size.












PC User Labor Costs






IWs (Information Workers) $72,118 32% $95,196 $1,831 $52.19






Data-entry or Structured Task Workers $56,720 32% $74,870 $1,440 $41.05











Average (weighted) $63,566
$83,907 $1,840 $46.00











** Base compensation plus bonuses











Source of salary data: based on HCR analysis of U.S. Department of Labor, Bureau of Labor Statistics data; The World Bank, World Development Indicators Database; and Organisation for Economic Co-operation and Development. Salary data is scaled based on industry, geography, and organization size.



























































©AnalysisPlace. www.analysisplace.com









Hide after


















Sheet 3: Solution

IT Project ROI and Business Case Toolkit

Hide After
Description of Sample Initiatives (for reference only)




Sample data should not be used for making investment decisions. Sample data is not meant to represent average/typical project results, is not based on research, and is not provided at the lowest level of detail. It should only be used as a starting point for assessing the business value of your project. Initiative costs and benefits will differ substantially from one organization to another.
Infrastructure/Platform Technology Initiatives




Initiative Type Key Features, Capabilities, Benefits Sample Vendors And Products

PC/Client • Improved performance, reliability, security, manageability, productivity
• Notebook, desktop, thin-client, tablet
• Microsoft Windows 7, Linux, Red Hat, Novell, Apple
• Dell, HP, Apple, Toshiba, Lenovo, Fujitsu, Acer, Sony, Gateway
• Intel, AMD


Data Center / Server • Virtualization, consolidation, clustering, real-time infrastructure, self-service provisioning, power and cooling
• Improved performance, reliability, manageability, security
• Multi-core, 64-bit, RISC/Itanium, x86
• Web servers, application servers, DBMS servers, data warehouse servers, infrastructure servers, high performance computing servers
• Microsoft Windows Server, Novell SUSE, Red hat, Unix, Solaris, IBM AIX, HP–UX
• IBM, HP, Dell, Sun, Fujitsu, Bull


Infrastructure Mgmt / Networking • Asset inventory/management, OS management, configuration management, change management, systems management, software distribution, application packaging
• Directory services, group policy objects
• IPV6, LAN, WAN, bandwidth upgrades, mobile and wireless
• VOIP – voice over Internet protocol
• Microsoft System Center Configuration Manager, IBM Tivoli, BMC Software, CA Unicenter, HP, LANDesk, Novell ZENworks, Symantec Altiris, Cisco Systems

Storage • Digital storage of business data and documents
• Archival, records management, tape backup, SAN, NAS, disk arrays, iSCSI, fibre channel
• Capacity management, performance analysis, storage provisioning, quota management, event management
• EMC, HP, IBM, Sun, Hitachi, EDS, Network Appliance
• IBM DB2, Microsoft Exchange, Microsoft SQL Server, Oracle, SAP


Security • Security planning, assessment, incident/breach management
• Identity and access management, encryption, smartcards, authentication, authorization, patch management
• Firewalls, antivirus, anti-malware, anti-spyware, network access control, information and data rights management
• McAfee, Symantec, CA, Trend Micro
• Cisco Systems, NetIQ
• VeriSign, IBM, Unisys


Application Development / Architecture • Improved software quality, integration, usability
• Custom developed software
• Rapid application development
• Middleware, application server
• Web services, Service-Oriented Architecture, SaaS (software as a service)
• Enterprise architecture (EA)
• Microsoft .NET, Visual Studio
• IBM WebSphere, Rational
• Sun Microsystems Java
• Java/J2EE/EE, Ruby on Rails, PHP, Python, Perl
• Oracle Fusion Middleware, Application Server
• BEA Systems WebLogic, JBoss (Red Hat), SAP NetWeaver


Compliance, Governance, Risk • Methods and software to ease compliance with regulations such as HIPPA, Sarbanes-Oxley, Basel II
• ITIL, COBIT, Six Sigma, CMM, ISO 17799/9000, PMBOK
• Maturity / capability models
• Portfolio management, IT-business alignment, balanced scorecard, service level management, risk management, data security, sustainability
• Business continuity – disaster planning / recovery
• IT governance, policies, internal audit, monitoring
• Accenture, BearingPoint, CSC, Deloitte, Ernst & Young, IBM, Infosys, KPMG, PricewaterhouseCoopers, Wipro
• BWise, IBM OpenPages, Thomson Reuters, Oracle, MetricStream, SAP, SAS


Outsourcing • Outsource IT and business processes, applications, infrastructure, or initiatives to reduce costs and improve results
• Infrastructure management: helpdesk, on-site support, desktop management, data center services
• BPO – business process outsourcing
• Offshore services
• Application outsourcing, web hosting, cloud computing
• Accenture, Capgemini, Cognizant, CSC, EDS, IBM, HP, Siemens, CompuCom, Infosys, Keane, Perot Systems, Satyam, TCS, Wipro, Getronics, Unisys
• AT&T, IBM, MCI-Digex, Qwest, Rackspace, Verio


Wireless/ Mobility • Wireless e-mail, mobile access to line-of-business applications, unified communications,
• VPN, mobile remote access, telecommuting
• Handheld devices, smartphone, PDAs
• Wireless LAN/WAN, 802.11n, WiMAX, CDMA, UMTS, GPRS, EDGE
• Microsoft Windows Phone, Palm, Symbian
• RIM BlackBerry, Nokia, Apple iPhone, Sharp, Motorola/Symbol, Fujitsu,
• 3Com, Cisco Systems, Nortel Networks, Siemens
• Equant, AT&T, MCI, BT, Sprint, Verizon

Business Technology Initiatives




Initiative Type Key Features, Capabilities, Benefits Sample Vendors And Products

Office Productivity Software • Word processing, spreadsheets, personal databases, presentation graphics software, personal information management, note-taking, task and project management, document creation and publishing • Microsoft Office
• OpenOffice.org
• Sun StarOffice
• Google Apps


Messaging/ Collaboration • E-mail, calendaring/scheduling, task management, unified communications
• Real-time collaboration, presence, instant messaging, web conferencing
• Social computing, blogs, wikis
• Team workspaces, project management, discussion threads, document workflow
• Microsoft SharePoint, Exchange, Live Meeting
• IBM Domino / Lotus Notes
• Oracle Collaboration Suite
• Sun Java Enterprise System
• Novell GroupWise
• WebEx Communications


Content Management • Document management, web content management, document imaging, records management, digital asset management
• Knowledge management, information management
• Intranets, Extranets, Portals
• Microsoft SharePoint, EMC Documentum, FileNet, Hummingbird, IBM Content Management, Interwoven, Mobius Management Systems, Open Text, Oracle Content Services, Stellent, and Vignette

E-commerce / Internet • Web sites for external business information dissemination, marketing, sales transactions, etc.
• Web storefronts, shopping cart management, taxation, personalization, transaction management, settlement and product visualization
• B2B, B2C, AJAX, mashups
• LAMP, Microsoft, ATG, Escalate Retail, Comergent, Oracle, SAP

Business Process Mgmt / Integration • Process modeling, monitoring and management
• Workflow, business rules, automation, electronic forms
• BAM (business activity monitoring)
• EAI (enterprise application integration)
• Microsoft BizTalk Server, Captaris Workflow, EMC Documentum, Global 360, IBM FileNet, Open Text
• Pegasystems, Oracle, SAP, TIBCO, webMethods, BEA Systems, SeeBeyond, GXS, Sterling Commerce


Business Intelligence / Data Mgmt • Database management systems (DBMS), data warehousing, data marts, online transaction processing (OLTP)
• Master data management, data quality, metadata
• Financial planning, corporate performance management, reporting, analytics, dashboards, scorecards, enterprise search, ETL, OLAP, query
• Microsoft SQL Server, Teradata, IBM, Oracle, MySQL, Ingres, PostgreSQL, Sybase
• Oracle Hyperion, Business Objects, Informatica, Cognos, Information Builders, MicroStrategy, SAS


Business Applications (Vertical, LOB) • Wide variety of specialized software that helps organizations streamline business processes and improve results • Various products/vendors by business function and industry

CRM • Customer Relationship Management
• Sales force automation (account, contact and opportunity management), marketing campaign management, customer information management, order entry, customer service management, customer analytics, product configurators, proposal generation
• Hosted CRM
• Oracle Siebel, PeopleSoft
• Onyx, Sage, NetSuite, SAP CRM, Salesforce.com, Amdocs, Microsoft Dynamics CRM, SugarCRM


ERP / Supply Chain • Enterprise resource planning: supply chain management, operations/production management, inventory management, planning/scheduling,, finance/accounting, human resource management, product management, warehouse management, logistics, purchasing, order entry, CAD, etc. • SAP
• Oracle Fusion (E-Business Suite, J.D. Edwards, PeopleSoft)
• Lawson, Intentia, Infor, Sage, Ariba, Microsoft Dynamics


©AnalysisPlace. www.analysisplace.com
Hide after




The words contained in this file might help you see if this file matches what you are looking for:

...Sheet welcome hide after the quot it project roi and business case toolkit enables development of comprehensive cases for projects helps organizations to assess quantify communicate costs benefits value many types enterprisescale technologybased initiatives also organization rsquo s current asis expected tobe spending tco levels solution impact on a variety key performance indicators kpis produces summary reports word powerpoint that can be edited presented decisionmakersthe tool estimates required implement new capabilitiessolution including hardware software labor services user simulates productivity savings cost revenue growth kpi improvements enabled by solutions selected supports both rapid minute highly detailed assessments uses robust industry bestpractice methods research assist in assessing investing initiative however this cannot accuratelycredibly estimate costsbenefits without review validation adjustment data inputs these should customized each particular scenario was deve...

no reviews yet
Please Login to review.