Calculating the ROI in ERP: Legacy ERP vs New ERP System?

The process for calculating enterprise resource planning ROI (return on investment) seems straightforward enough: add up the costs, add up the benefits, and compare the two figures. However, there are a number of factors that need to be considered to make sure that your results are valid – and useful. It’s important to have a complete view of both costs and benefits, now and in the future, for both the existing system and the new system under evaluation. Following are expert tips based on dozens of ERP implementations.

Get the ERP ROI calculation worksheet

 

Preparing for the ERP ROI analysis

Use a reasonable time frame for ROI analysis. To ensure your analysis will cover the full lifecycle of both costs and benefits, consider a time frame of at least five years.

Look for cost differences between the legacy system and the replacement ERP system. To do this, you need to enumerate current costs to maintain your legacy system as well as future ERP upgrade costs. Remember that a key motivator to change systems is to add new functionality to remain competitive – so include a realistic estimate of upgrade costs for the legacy system.

Be thorough. Make sure you have gathered each and every cost estimate: for acquiring the new system, getting it implemented, and operating it effectively. In many cases, new system operating costs will be less than existing system costs. Also consider the projected benefits when calculating your ERP return on investment, recognizing that those benefits will be realized over time.

Think positively but realistically. If your company is product based (for example, a distributor or manufacturer), you might envision a significant inventory reduction – but do your homework to understand what result is typical. Also keep in mind that savings will not happen automatically, nor right away.  

Why this much detailed work? ROI is often required for financial planning purposes. It’s also important to understand total project costs and benefits to justify your ERP investment and to evaluate system performance against expectations once implemented. The ERP ROI calculator worksheet below can help you accurately identify your costs – while offering tips and advice to make the process smoother.

 

Using this worksheet

This page will guide you through a series of tables to be completed. Each step will provide information to assist in filling out those tables.

As you go through the process you can create your own custom spreadsheets based on these tables. We’ve also created a downloadable ERP ROI template worksheet to help you.

There are three major steps to calculating the ROI of an ERP upgrade:

  1. Calculating the costs
  2. Estimating the benefits
  3. Calculating the ROI

 

1. Calculate the ERP costs

How will your ERP system will be deployed?

How the ERP system is deployed significantly impacts the cost estimates. These are four options: 

  • On-premise (on-prem): On-premise deployment is the traditional way legacy ERP systems have been implemented for decades. The hardware and software are purchased and installed on a company’s own servers, and the system is maintained and upgraded by the company.  
  • Hosted: A hosted deployment is a private cloud model in which IT services are delivered over a private IT infrastructure for the dedicated use of a business. There are various options that determine responsibilities and costs. 
  • True cloud: In a true cloud deployment, the system runs entirely on a public cloud with hardware and software owned and supported by a third-party provider. This is the primary licensing model for software-as-a-service (SaaS) ERP, CRM, and similar solutions.  
  • Hybrid: In this model, elements of on-premise deployment, private cloud, and public cloud can be combined to create a hybrid cloud. This gives the company the ultimate flexibility but requires significantly more IT staff involvement. 

Which deployment options will be compared? 

ERP deployment optionsTable 1: ERP Deployment Options

 

Calculate the ERP cost of both systems 

This section of the worksheet is designed to calculate the total cost of ownership (TCO) for both the existing ERP legacy system and the new replacement system. There are typically four areas of investment: 

  • Infrastructure
  • Software
  • Implementation
  • Ongoing personnel costs

For the initial project justification, it will be necessary to estimate these costs (before you go out for proposals and quotes). Many or most of the items listed here may be included in a package quote but expect to pay for additional services, training, hardware, and software to complete the job.   

Growth and support costs will be significantly higher if your existing system is old, not well supported by the developer, or if it is “down-level,” that is, not up to date with developer fixes and releases.  

ERP infrastructure costs

In addition to the initial costs, estimate the cost of upgrades and expansion beyond the initial purchase. Since this is a time-oriented estimate – all costs will be replicated (and escalated) through the five years (at least) of the lifecycle – place these upgrade and expansion costs in future years as it is unlikely that you will need to upgrade or expand during the first year or so.   

  • Initial hardware: Purchase or lease cost of the computers, servers, printers, for example. In the comparison table, this expense should have already been spent for “legacy system.” 
  • Ongoing upgrades and maintenance: Continued costs for above infrastructure. There will be no or low infrastructure maintenance costs with SaaS. 
  • System software license: Includes operating system, database, utilities, for example. 
  • System software upgrades and maintenance: Ongoing costs for above system software. Expect no or low infrastructure maintenance costs with SaaS. 
  • Networking equipment and fees: Initial budget for networking equipment and services.  
  • User devices: Cost to purchase, replace, and maintain the various PC’s, tablets, scanners, and so forth.   
  • Infrastructure facilities fees: Calculated costs for the space and utilities, for example, that the system requires. 

ERP infrastructure costsTable: 2: ERP Infrastructure Costs

 

ERP software costs – business and productivity applications

Here, you will want to budget for the cost of upgrades and expansion beyond the initial purchase. The annual fees may rise over time as additional users or applications are added, depending on a supplier’s pricing strategy. 

  • Perpetual license fee initial cost: Upfront costs especially for on-premise plus some hosted and hybrid licensing options. This has already been spent for the legacy system. 
  • Perpetual license ongoing annual fee: This covers the updates and some level of support. For an ERP system, it is typically 16-20% of list price annually. At 20% yearly the license is “repurchased” every five years.
  • Annual subscription (SaaS): Use quoted or estimated annual subscription costs for cloud applications.  
  • Annual maintenance fees (SaaS): Additional support fees that will be needed on the software that are not included elsewhere. Most SaaS software maintenance fees are included in the subscription. 

ERP software costsTable 3: Software Costs

 

ERP implementation costs

Next you need to estimate the costs of implementing both the initial system and the planned upgrades over the five-year period. Most software suppliers have one or two major releases during a year. Each release is in fact a mini implementation. First, the project team must review the release to determine the overall impact to the current business process. Then the release is loaded and tested. Before going live, the users should be sufficiently trained on the new software. Potential costs to consider include: 

  • Staff project team: Factor in the budgeted time (including overtime) for IT staff and users. 
  • Consultancy fees: Determine the initial assistance you may need beyond what the supplier will be including. 
  • Data conversion, input, and testing: Use staff or temps for data entry, testing, or whatever other basic tasks you need covered. (This is often underbudgeted, which can lead to data quality issues.) 
  • User education and training: Some initial end user training will be included by the supplier, but to get the most of your system further education is highly recommended. 

ERP implementation costsTable 4: ERP Implementation Costs

 

Ongoing ERP personnel costs

Estimate the “normal” operational costs for keeping your new ERP business system up and running. When considering on-going (recurring) costs, be as realistic as possible and include a reasonable expectation for escalation or inflation year-to-year. The major items will be a blend of internal IT staff and consultants’ time and expenses such as: 

  • Infrastructure support costs: This covers time budgeted for support beyond what the supplier’s recommendation included. With SaaS, there will be either no infrastructure maintenance costs or minimal costs. 
  • Backup and disaster recovery: Include outsourced or in-house practices. 
  • Network and devices support: Estimated support required for the network, PC’s, and mobile, for example.  
  • Periodic bug fixes: This is for IT staff to apply the stream of bug fixes. 
  • Software integrations: Expect to maintain regularly as software products are updated. 
  • Software customizations: Updated or reapplied in software release cycles. 
  • User’s mobile device support: Effort required for app development and support. 

Chart of ongoing ERP personnel costsTable 5: Ongoing ERP Personnel Costs

 

Determine the total cost of your legacy ERP vs new ERP system

From the four tables above, transfer the total for each area of investment, as well as the subtotals of the new system costs, to the table below. You will now be able to see the total savings or additional costs of going to a new system. Expect a mix of negative and positive subtotals for the “5-Year Difference.” 

Summary of ERP costs to calculate ROITable 6: Summary of ERP Costs

What to do with this information 

  • If the total “5-Year Difference” is positive, it means that it is more expensive to maintain your legacy system then to replace it. That amount is a direct benefit and needs to be added to Table 8: Summary of ERP Benefits (below). 
  • If the total “5-Year Difference” is negative, it means the new system will be more expensive to implement then to maintain your existing system. The additional benefits will be covered in the next section.
  • The total of the New System’s 5-Year Costs will be used below in the ROI Calculation as “the investment.”

 

2. Estimate the ERP benefits

If the five-year cost of the new system is more than the cost of maintaining the legacy system, then you will need sufficient additional benefits to justify making the change – otherwise, why make the switch?

For example, if you anticipate more revenue and higher margins as a result of the upgrade to a new ERP – or if the system will deliver more value and a higher level of customer support – these benefits might help you rationalize the upgrade to a new ERP.  

Some of the new system’s benefits are by nature a bit harder to separate out and assign to the new system but well worth the effort to do so. In most cases, there will be plenty of direct benefits to more than justify the new system implementation. But documenting and estimating the indirect benefits will help in project planning, setting priorities, and measuring the results of the ERP implementation on the organization. Even if you cannot assign a monetary value to these benefits, go ahead and list them in the ROI worksheet and the project plan.

ERP benefit examples 

For this worksheet, sample ERP benefits have been organized into five areas of improvement: 

  • People productivity
  • Decision-making
  • Finance and accounting 
  • Operations
  • Business technology

The lists below are samples of the benefits. There will be many more that you and your team will uncover when reviewing customer success stories, analyst reports, business requirements, software options, and new technology. List the possible benefits and capture initial estimates for process improvements and their financial value.

People productivity

  • Support mobile devices to allow working anywhere at any time. 
  • Improve the efficiency and accuracy in data entry due to awkward procedures and slow system response associated with older ERP systems that are not “user friendly.” 
  • Reduce time to productivity with a role-based, modern user interface (UI) that decreases the training time required for users to get up and running. 
  • Help establish a controlled, managed environment to reduce variability with standard processes. 

Decision-Making 

  • Consolidate systems to reduce inaccuracies in data and eliminate redundant data. 
  • Centralize and manage information (single source of truth) to make intra-enterprise communications more effective and help avoid misunderstandings and confusion.  
  • Access Big Data with modern analytical tools to provide insights for better decision-making. 
  • Provide user friendly tools such as alerts and dashboards to allow fast and accurate self-service queries.

Finance and accounting 

  • Streamline finance and accounting processes across the company. 
  • Speed up monthly closes and improve accuracy of financial reporting. 
  • Improve accounts receivable by reducing days sales outstanding (DSO). 
  • Reduce the stress of audits because the data is organized and readily available, as well as accurate and complete. 
  • Facilitate regulatory compliance.  

Operations 

  • Improve company-wide business operations and modernize outdated processes. 
  • Integrate e-commerce into customer and order management. 
  • Decrease operational labor costs through better planning systems. 
  • Increase customer satisfaction with a firm product or delivery date at the time of quoting. 
  • Help procurement become proactive and controlled rather than chaotic and reliant on expediting. 
  • Reduce inventory without increasing the occurrence of shortages, backorders, or customer disappointment through better inventory planning and control. 

Business technology  

  • Replace obsolete infrastructure holding the business back. 
  • Improve interaction between the various department’s business systems. 
  • Consolidate standalone legacy applications and reduce the use of Excel spreadsheets and manual workarounds. 
  • Access new technology such as artificial intelligence (AI), machine learning, and the Internet of Things (IoT). 
  • Provide a path to scalability with modern systems that are designed to grow as a business grows.  
  • Enforce data security with up-to-date systems and controls. 
  • Alleviate the issue of finding support for legacy systems that are no longer supported by the vendor. 

 

Document the ERP improvements

The worksheet below is a sample spreadsheet for documenting your observations and estimates for process improvements and their financial value. Remember to populate each column in your own spreadsheet. 

  • Create a worksheet for each of the five areas of improvement listed above.   
  • Record the processes under each that will be improved. 
  • Estimate the annual direct and indirect amounts.  
  • Calculate the five-year total value. 
  • Specify the benefit, even if the dollar amount cannot be determined.  

Identify the direct and indirect benefits for each department in your organization. Following is an example of benefits in the finance and accounting area. You’ll need a table like this for each department in your organization.

Example ERP Benefits for Finance and AccountingTable 7: Example ERP Benefits for Finance and Accounting

 

Summarize all the ERP benefits

Once all the areas of improvement have been considered, add the sum of the five-year total from each department to determine the total benefit. 

Also, if you found that the “Total 5-Year Difference” from Table 6: Cost Summary in was positive, then it clearly will be more expensive to maintain your legacy system then replace it. The amount of savings is a direct benefit amount and should be added to the table below in Line 6. If that number was negative (new system costs more than existing) place a zero (0) in Line 6. 

Summary of ERP benefitsTable 8: Summary of ERP Benefits

 

3. Calculate the ERP ROI 

You will not need a spreadsheet for this phase.

At this point, you should have all the information you need to calculate the ROI on your ERP investment using this formula:

ROI = (Benefits – Investment)/Investment 

Here’s where you find the information:

  • The “Investment” is the “Total New System’s 5-Year Costs,” which is the total from Table 6: Summary of ERP Costs
  • The “Benefits” is the “Total Project ERP Benefits” from Table 8: Summary of ERP Benefits 

In most cases the benefit will be larger than the investment and you will end up with a ratio greater than 1.

For example, if the five-year benefit is US$2,000,000 and the five-year investment is $575,000, the ratio would be ($2,000,000 – $575,000) / $ 575,000 = 2.479 and that is rounded to 2.5.

Multiply that ratio by 100 to get the ROI percentage that results from upgrading your ERP system. In our example, the 2.5 ratio represents a 250% ROI.

The next step 

If the benefits and ROI are sound, the next step is to expand the effort to match your company’s planning and budgeting process. Since software affects both operating and capital budgets, you may need to involve more stakeholders.

  • Communicate with the sponsoring executives and team members who created the estimates. 
  • Provide supporting sales, costs, and other documentation. 
  • Create specific sales and cost forecasts by year. 
  • Prepare financial analysis data for total cost of ownership (TCO), payback period, and other calculations. 

Get the ERP ROI calculation worksheet to get started today! 

 

This post originally appeared on the SAP Insights blog