Justification of ERP Investments
Part 1: Quantifiable Benefits from an ERP System

Featured Author - Dr. Scott Hamilton - February 10, 2004

1. Justification of ERP Investments*
2. Quantifiable Benefits from an ERP System
3. ERP System Benefits on the Balance Sheet
 

Justification of ERP Investments*

The expected return on investment provides the cost justification and motivation for investing in ERP. There are quantifiable benefits as well as intangible benefits in the ERP investment decision. The quantifiable benefits have a bottom-line impact on profitability, asset turnover, and a potential effect on stock value.

This section discusses the quantifiable and the intangible benefits of an ERP system, which compares firm performance before and after implementing ERP. Other scenarios are encountered in justifying ERP investments. For example, a firm may be considering replacement versus upgrade or re-implementation of an ERP software package.

There are significant costs for not successfully implementing an ERP system. Manufacturers often pay more for the lack of systems than they would have paid for improved systems. They carry excess inventory or provide poor customer service, for instance. And manufacturers may invest in ERP without gaining the benefits because the systems are partially implemented, unsuccessfully implemented, or usage deteriorates over time.

*This is Part One of a four-part article reprinted from Maximizing Your ERP System by Dr. Scott Hamilton. Bridging the theory and realities of current ERP systems, Maximizing Your ERP System provides practical guidance for managing manufacturing in various environments. Drawing on case studies from Dr. Hamilton’s first-hand experience in consulting with more than a thousand firms, it covers common problems and working solutions for how to effectively implement and use ERP systems. The book can be ordered on amazon.com. This excerpt on “Justification of ERP Investments” is presented in four parts:

  • Quantifiable benefits from an ERP system
  • The intangible effects of ERP
  • Costs of implementing an ERP system
  • Replacing or re-implementing an ERP system

Reprinted with permission of McGraw-Hill.

Quantifiable Benefits from an ERP System

Studies that surveyed manufacturers about the impact of ERP systems on firm performance indicate that company size and industry do not affect the results. Benefits have been indicated for large and small firms, whether they make standard or custom products or are in discrete or process manufacturing environments. This section explains the quantifiable benefits in terms of several areas of improvement.


Typical Benefits

The most significant quantifiable benefits involve reductions in inventory, material costs, and labor and overhead costs, as well as improvements in customer service and sales.

Inventory reduction. Improved planning and scheduling practices typically lead to inventory reductions of 20 percent or better. This provides not only a one time reduction in assets (and inventory typically constitutes a large proportion of assets), but also provides ongoing savings of the inventory carrying costs. The cost of carrying inventory includes not only interest but also the costs of warehousing, handling, obsolescence, insurance, taxes, damage, and shrinkage. With interest rates of 10 percent, the carrying costs can be 25 percent to 30 percent.

ERP systems lead to lower inventories because manufacturers can make and buy only what is needed. Demands rather than demand insensitive order points drive time phased plans. Deliveries can be coordinated to actual need dates; orders for unneeded material can be postponed or canceled. The bills of material ensure matched sets are obtained rather than too much of one component and not enough of another. Planned changes in the bills also prevent inventory build up of obsolete materials. With fewer part shortages and realistic schedules, manufacturing orders can be processed to completion faster and work-in-process inventories can be reduced. Implementation of JIT philosophies can further reduce manufacturing lead times and the corresponding inventories.

Material cost reductions. Improved procurement practices lead to better vendor negotiations for prices, typically resulting in cost reductions of 5 percent or better. Valid schedules permit purchasing people to focus on vendor negotiations and quality improvement rather than on expediting shortages and getting material at premium prices. ERP systems provide negotiation information, such as projected material requirements by commodity group and vendor performance statistics. Giving suppliers better visibility of future requirements helps them achieve efficiencies that can be passed on as lower material costs.

Labor cost reductions. Improved manufacturing practices lead to fewer shortages and interruptions, and less rework and overtime. Typical labor savings from successful ERP are a 10 percent reduction in direct and indirect labor costs. By minimizing rush jobs and parts shortages, less time is needed for expediting, material handling, extra setups, disruptions, and tracking split lots or jobs that have been set aside. Production supervisors have better visibility of required work and can adjust capacity or loads to meet schedules. Supervisors have more time for managing, directing and training people. Production personnel have more time to develop better methods and improve quality and throughput.

Improved customer service and sales. Improved coordination of sales and production leads to better customer service and increased sales. Improvements in managing customer contacts, in making and meeting delivery promises, and in shorter order to ship lead times, lead to higher customer satisfaction and repeat orders. Sales people can focus on selling instead of verifying or apologizing for late deliveries. In custom product environments, configurations can be quickly identified and priced, often by sales personnel or even the customer rather than technical staff. Taken together, these improvements in customer service can lead to fewer lost sales and actual increases in sales, typically 10 percent or more.

ERP systems also provide the ability to react to changes in demand and diagnose delivery problems. Corrective actions can be taken early, such as determining shipment priorities, notifying customers of changes to promised delivery dates, or altering production schedules to satisfy demand.

Improved accounting controls. Improved collection procedures can reduce the number of days of outstanding receivables, thereby providing additional available cash. Underlying these improvements are fast accurate invoice creation directly from shipment transactions, timely customer statements, and follow through on delinquent accounts. Credit checking during order entry and improved handling of customer inquiries further reduces the number of problem accounts. Improved credit management and receivables practices typically reduce the days of outstanding receivables by 18 percent or better.

Trade credit can also be maximized by taking advantage of supplier discounts and cash planning, and paying only those invoices with matching receipts. This can lead to lower requirements for cash-on-hand.

 

ERP System Benefits on the Balance Sheet

Benefits from improved business processes and improved information provided by an ERP system can directly affect the balance sheet of a manufacturer. To illustrate this impact, a simplified balance sheet is shown in figure 3.1 for a typical manufacturer with annual revenue of $10 million. The biggest impacts will be on inventory and accounts receivable.

In the example, the company has $3 million in inventory and $2 million in outstanding accounts receivable. Based on prior research concerning industry averages for improvements, implementation of an ERP system can lead to a 20 percent inventory reduction and an 18 percent receivables reduction.

Figure 3.1 Summarized balance sheet for a typical $10 million firm

 
Typical
  Current Improvement Benefit
Current assets    
Cash and other
500,000
 

Accounts receivable

2,000,000
18%
356,200

Inventory

3,000,000
20%
600,000

Fixed assets

3,000,000
 
Total assets
$8,500,000
 
$956,200
Current liabilities
xxx,xxx
 
Non current liabilities
xxx,xxx
 
Stockholder's equity
xxx,xxx
 
Total liabilities and equity
xxx,xxx
 

  • Inventory Reduction. A 20 percent inventory reduction results in $600,000 less inventory. Improved purchasing practices (that result in reduced material costs) could lower this number even more.

  • Accounts Receivable. Current accounts receivable represent seventy-three days of outstanding receivables. An 18 percent reduction (to sixty days' receivables) results in $356,200 of additional cash available for other uses.

ERP Benefits on the Income Statement

A simplified, summary income statement for the same $10 million manufacturer is shown in figure 3.2. For many manufacturers, the cost of sales ranges from 65 to 75 percent of sales (the example will use 75 percent). Using industry averages for each major benefit, the improved business processes and associated information system almost double the current pretax income.

  • Inventory Reduction. A 20 percent reduction in the current inventory of $3 million results in ongoing benefits of lower inventory carrying charges. Using a carrying cost of 25 percent results in $150,000 in lower carrying charges each year, identified here as part of the administrative expenses.

  • Material Cost Reductions. A 5 percent reduction in material costs because of improved purchasing practices results in annual savings of $225,000.

  • Labor Cost Reductions. A 10 percent reduction in labor costs because of less overtime and improved productivity results in annual savings of $100,000.

  • Increased Sales. Improvements in customer service typically lead to a 10 percent sales increase; this is not shown in figure 3.1.

Annual benefits totaling $475,000 in this example almost equals the current pretax income of $500,000.

Figure 3.2 Summarized income statement for a typical $10 million firm

 
Typical
 
Current
Improvement
Benefit
Sales
$10,000,000
10%

Cost of sales

7,500,000
 
Material
4,500,000
60%
Labor 
1,000,000
13%
Overhead
2,000,000
27%
5%
$225,000
10%
$100,000
 

Administrative expenses

2,000,000
 
$150,000
Pretax income
$ 500,000
 
$475,000

ERP Impact on Key Financial Ratios

Ration analysis provides another way to look at the impact of an ERP system. Three ratios illustrate the effect---two related to liquidity and one to operating performance.

  • Inventory turnover (Cost of Sales/Inventory). Low inventory turnover can indicate possible overstocking and obsolescence. It may also indicate deeper problems of too much of the wrong kind of inventory which can create shortages of needed inventory for production and sales. High turnover indicates better liquidity and superior materials management and merchandising. Given the example $10 million company, the current number of inventory turns is 2.5. With a 20 percent inventory reduction, the number of inventory turns increases to 3.1.

  • Days of Receivables (365 * 1/(Sales/Receivables)). This ratio expresses the average time in days that receivables are outstanding. It is a measure of the management of credit and collections. Generally, the greater the number of days outstanding, the greater the probability of delinquencies in accounts receivable. The lower the number of days, the greater the cash availability. With an 18 percent reduction in receivables, the current days receivable of seventy-three days can be reduced to sixty. This means $356,200 is available for other purposes.

  • Return on Assets (Profit Before Taxes/Total Assets). This ratio measures the effectiveness of management in employing the resources available to it. Several calculations are necessary to determine the return on assets. In this example, the return on assets can be improved from 5.9 to 12.9 by effectively implementing an ERP system.

Performance evaluation based on ratio analysis can also use comparisons between one's own company and similar firms in terms of size and industry. The Annual Statement Studies provide comparative ratios for this purpose. This use of comparative ratio analysis will use the same three ratios for inventory turnover, days receivable, and return on assets. To perform the analysis, you identify the median and upper quartile ratios for firms in the same industry. These roughly correspond to average and good performance. By comparing the ratios with your firm's current performance, you can calculate how much better your company should be performing to be competitive. The same analysis can be performed using the “BenchmarkReport.com” website.

Using the inventory turns ratio for the example $10 million manufacturer, assume the Annual Statement Studies indicate that the median and upper quartile are four and six turns for other firms in the same industry. Average performance of four inventory turns translates into an expected inventory of $1.875 million ($7.5 million divided by four). If the example firm had this ratio, it would have had $1.125 million less in inventory. With inventory carrying costs at 25 percent, this would produce savings of $281,250 each year.

For the days receivable ratio, assume the Annual Statement Studies indicate that sixty and fifty days are the median and upper quartile. The days receivable in the example $10 million manufacturer is currently seventy-three days; an improvement to sixty days would reduce receivables by $356,200 (using a daily sales rate of $27,400 and a thirteen day reduction). This means that cash is available for other purposes.

Note that the return on assets ratio is 5.9 for the example company. Assuming the Annual Statement Studies indicate the return on assets is ten and fifteen for firms in the same industry at the median and upper quartiles, improving the return on assets to equivalent levels would mean increased profits or asset turnover.

ERP Impact on Stock Price

If the integration and improved information of an ERP system results in a better balance sheet and increased profits, these improvements should impact stock price for the company. Although stock price is affected by a variety of factors, the typical effect of improved profits and balance sheet ratios can be estimated. Using the already described example of $10 million manufacturer and typical benefits, and assuming 100,000 shares outstanding and an existing stock price of $30.00 per share, , the stock price exhibits the effects of an effective ERP, as figure 3.3 shows. With a price/earnings multiplier of six, the stock price for the example company could be increased from $30 to $58.80 per share.

Figure 3.3 Calculating the potential stock appreciation

 
Before ERP
After ERP
 
Before tax profit
$500,000.00
$980,000.00
Earnings per share
$ 5.00
$9.80
Current stock price
$30.00
6 * 9.80 = $58.80
Multiplier
6
6

These calculations suggest that ERP systems can lead to significant impacts on financial results, including the balance sheet, income statement, key ratios, and stock price.

This concludes Part One of a four-part article reprinted from Maximizing Your ERP System by Dr. Scott Hamilton. Bridging the theory and realities of current ERP systems, Maximizing Your ERP System provides practical guidance for managing manufacturing in various environments. Drawing on case studies from Dr. Hamilton’s first-hand experience in consulting with more than a thousand firms, it covers common problems and working solutions for how to effectively implement and use ERP systems. The book can be ordered on amazon.com. This excerpt on “Justification of ERP Investments” is presented in four parts:

Reprinted with permission of McGraw-Hill.

 

Justification of ERP Investments
Part Two: The Intangible Effects of ERP

Featured Author - Dr. Scott Hamilton - February 11, 2004

1. The Intangible Effects of ERP*
2. Effects on Accounting
3. Effects on Product and Process Design
 

The Intangible Effects of ERP*

The intangible or non-financial benefits of an integrated enterprise resource planning (ERP) system can be viewed from several perspectives. For illustrative purposes, the discussion will focus on the benefits for accounting, product and process design, production, sales, and management information system (MIS) functions. From the overall company standpoint, ERP provides a framework for working effectively together and providing a consistent plan for action.

Each of the intangible effects could be quantified in terms of cost savings. Duplicate data maintenance, for example, requires personnel time in entering data (and possibly managerial time in determining which set of data should be used for decision making). Expediting efforts have a visible effect of consuming personnel time. These quantified cost savings can also be used to show impacts on financial results.

*This is Part Two of a four-part article reprinted from Maximizing Your ERP System by Dr. Scott Hamilton. Bridging the theory and realities of current ERP systems, Maximizing Your ERP System provides practical guidance for managing manufacturing in various environments. Drawing on case studies from Dr. Hamilton’s first-hand experience in consulting with more than a thousand firms, it covers common problems and working solutions for how to effectively implement and use ERP systems. The book can be ordered on amazon.com. This excerpt on “Justification of ERP Investments” is presented in four parts:

  • Quantifiable benefits from an ERP system
  • The intangible effects of ERP
  • Costs of implementing an ERP system
  • Replacing or re-implementing an ERP system

Reprinted with permission of McGraw-Hill.

Effects on Accounting

With a common database from ERP, accounting no longer requires duplicate files and redundant data entry. Product costing, for example, can be performed using accurate and up to date product structures. Product costing simulations can be used to analyze the impact of changing material costs, labor rates, and overhead allocations as well as planned changes to bills and routings. Differences between actual and standard costs are highlighted as variances. Order related variances help pinpoint problem areas.

Customer invoices can be based on actual shipments (without duplicate data entry), which helps speed invoice processing. Payables can use purchase order and receipt data for three way matching with supplier invoices.

As manufacturing transactions are recorded, the financial equivalents are automatically generated for updating the general ledger. This provides a complete audit trail from account totals to source documents, ensures accurate and up to date financial information, and permits tracking of actual versus budgeted expenses. Detailed transaction activity can also be easily accessed on line for answering account inquiries.

Since manufacturing transactions automatically update the general ledger, time consuming manual journal entries can be eliminated. Period end closing procedures can be performed in hours or days, rather than weeks. This improves reduces clerical accounting work, and improves the timeliness of financial reports.

Financial reports can be easily customized to meet the needs of various decision makers. Financial projections can be based on detailed ERP calculations for future requirements. Cash planning, for example, can account for current and projected sales orders and planned purchases, as well as current receivables and payables. Decision support tools (such as spreadsheets, graphics packages and data managers) can use the financial data maintained in the ERP database.

 

Effects on Product and Process Design

The product structure database offers engineering much greater control over product and process design, especially in terms of engineering change control. Planned changes can be phased in and emergency changes can be communicated immediately.

ERP systems offer numerous analytical tools for the engineering function. When diagnosing the impact of changes to materials and resources, for example, engineers can check where used information to identify the affected products. Lead time reduction efforts can use critical path analysis of item lead times in multi-level bills to focus attention on those key components affecting cumulative manufacturing lead time. Costed multi-level bills can be used to focus cost reduction efforts on high value items. Bill comparisons can be used to highlight differences between products or between revisions of the same product such as to identify upgrade kit requirements.

ERP systems support custom product configurations. Rules-based configurators reduce the need for expert assistance from engineers, and ensure sales personnel (or even customers) can develop timely accurate configurations. Cost estimates and pricing for custom product configurations can also be quickly calculated.

Effects on Production and Materials Management

ERP systems help establish realistic schedules for production and communicate consistent priorities so that everyone knows the most important job to work on at all times. Visibility of future requirements helps production prepare for capacity problems, and also helps suppliers anticipate and meet your needs. As changes to demands or supplies do occur, ERP helps identify the impact on production and purchasing.

Finite scheduling capabilities in ERP ensure production activities get scheduled based on capacity, tool and material constraints. Scheduling rules help minimize setup times and optimize sequencing. Changes in factory demands, as well as changes in available machine time, labor headcount and skill levels, tools, and material, can be immediately simulated to assess the impact on production and purchasing. ERP helps eliminate many crisis situations, so people have more time for planning and quality. Buyers can spend more time in vendor negotiation and quality improvement. When the shortage list is no longer used to manage the shop, the quality of working life can improve.

 

Effects on Sales

Customer service can be improved by making valid delivery promises and then meeting those promises. Custom product quotations can be developed faster and more accurately, which improves job estimating. Delivery lead times can be shortened and customer inquiries on order status can be answered immediately.

E-commerce capabilities enable customers to place orders and check status over the internet at any time. In addition to customer convenience, this reduces the time requirement for sales and customer service personnel.

Effects on the MIS Function

An ERP system implemented as an integrated software package offers several advantages to the MIS function. The software package can offer a growth path from simple to comprehensive applications built on top of a database management system. It provides an upgrade path to technology and functional enhancements supported by the software vendor. It can reduce the development time and cost for software, documentation, and training classes. These costs would be incurred before the firm can start obtaining the benefits of an ERP system. It permits the MIS staff to focus their attention on organizational change and servicing user needs for customization and professional assistance.

*This concludes Part Two of a four-part article reprinted from Maximizing Your ERP System by Dr. Scott Hamilton. Bridging the theory and realities of current ERP systems, Maximizing Your ERP System provides practical guidance for managing manufacturing in various environments. Drawing on case studies from Dr. Hamilton’s first-hand experience in consulting with more than a thousand firms, it covers common problems and working solutions for how to effectively implement and use ERP systems. The book can be ordered on amazon.com. This excerpt on “Justification of ERP Investments” is presented in four parts:

  • Quantifiable benefits from an ERP system
  • The intangible effects of ERP
  • Costs of implementing an ERP system
  • Replacing or re-implementing an ERP system

Reprinted with permission of McGraw-Hill.

 

Justification of ERP Investments
Part Three: Costs of Implementing an ERP System

Featured Author - Dr.Scott Hamilton - February 12, 2004

1. Costs of Implementing an ERP System*
2. One-Time Costs
3. OnGoing Annual Costs
 

Costs of Implementing an ERP System*

Enterprise resource planning (ERP) implementation costs can be divided into one-time costs and ongoing annual costs. Both types of costs can be segmented into hardware, software, external assistance, and internal personnel.

*This is Part Three of a four-part article reprinted from Maximizing Your ERP System by Dr. Scott Hamilton. Bridging the theory and realities of current ERP systems, Maximizing Your ERP System provides practical guidance for managing manufacturing in various environments. Drawing on case studies from Dr. Scott Hamilton’s first-hand experience in consulting with more than a thousand firms, it covers common problems and working solutions for how to effectively implement and use ERP systems. The book can be ordered on amazon.com. This excerpt on “Justification of ERP Investments” is presented in four parts:

  • Quantifiable benefits from an ERP system
  • The intangible effects of ERP
  • Costs of implementing an ERP system
  • Replacing or re-implementing an ERP system

Reprinted with permission of McGraw-Hill.

One-Time Costs

Software. The cost of an ERP software package varies widely, ranging from $30,000 (USD) for micro-based packages to several million for some mainframe packages. The number of concurrent users generally drives the software costs, so that smaller systems cost less. For illustrative and general guideline purposes, the software package costs range from $50,000 to $200,000 (USD) for smaller manufacturers. In addition to the ERP software package, one-time costs may include systems software, development of customized software, or integration with other applications.

Hardware. Hardware selection is driven by the firm’s choice of an ERP software package. The ERP software vendor generally certifies which hardware (and hardware configurations) must be used to run the ERP system. Hardware may need to be replaced or upgraded. As a general rule, small to medium-size manufacturers already have microcomputers and a local area network, so that a micro-based ERP system built on de facto standards requires little additional investment in hardware.

External Assistance. External assistance includes the consulting and training costs to implement the ERP package. The software vendor, reseller or independent consultant groups may provide external assistance. The amount of required external assistance is dependent on several factors, such as the complexity of the ERP package, the experience or knowledge of internal personnel, and the extent to which external personnel are used in place of internal personnel to implement the system.

A general guideline for these costs has been the ratio with the cost of the ERP software package. A comprehensive micro-based ERP package typically has a .5 to 1.0 ratio; the manufacturer requires $.50 to $1.00 (USD) of external assistance for each dollar of software package costs. The elapsed time for implementation of the entire ERP application typically requires four to six months. Many of the mainframe ERP packages have a three to five ratio for the costs of external assistance. The software package typically costs more, and the elapsed time for implementation requires nine to twenty-four months.

Internal Personnel. Internal personnel time reflects the time commitments for the implementation project team, the executive steering committee, the users in various functional areas, and management information system (MIS) personnel. The time commitments include training classes, development of internal procedures for using the system, developing customized reports and applications, preparation of the data, meetings with external consultants, and team meetings. A general guideline for internal personnel costs can also be expressed as a ratio with the ERP software costs, where a typical ratio is .5 to 1.0.

The one-time costs for implementing an ERP system can be simplistically estimated using typical ratios with ERP software costs. These ratios are summarized in figure 3.4 for one-time and ongoing annual costs, along with example calculations for a $100,000 (USD) ERP software package.

The one-time and ongoing annual costs for hardware are not included in the example. In many cases, the use of de facto standard hardware means that a firm already has the hardware for an ERP system. The example shown in figure 3.4 indicates an estimated $300,000 (USD) for one time costs and $65,000 (USD) for annual costs related to an ERP system.

 

OnGoing Annual Costs

Software. Ongoing software costs should include the annual customer support agreement with the ERP software and vendor. This customer support typically provides telephone assistance and software upgrades and is typically priced around 15 percent to 20 percent of the software price. Upgrades to system software releases will also be required.

The upgrade path for new releases of the ERP software package is critical. New releases contain enhancements for functionality and bug fixes, and ensure the software runs on the latest technology platform. From the user’s point of view, the upgrade path enables the manufacturer to take advantage of hundred of man-years of development efforts undertaken by the ERP software vendor (and other technology vendors) with minimal investment. From the vendor point of view, it is much easier to support users on the latest releases. However, user changes to source code and other user customizations can make it very expensive or even impossible to upgrade. Additional costs must then be incurred to ensure the customizations work with the latest upgrade. As shown in the example estimates in figure 3.4, a ratio of .25 has been used for total annual costs related to ERP software.

A phased implementation approach may mean that additional software must be purchased. A data collection system, for example, may be implemented as part of a second phase. Hardware. Ongoing hardware costs will reflect new requirements specified by the ERP vendor to run the software.

External Assistance. External assistance should be used as part of a continuous improvement program to effectively use an ERP system application for running the company. Training and consulting can focus on improved business processes, new or poorly used software functionality, and training of new personnel. A phased implementation approach requires additional assistance at each phase. Additional customizations may be required, especially with evolving user sophistication. As shown in the example estimates in figure 3.4, a ratio of .1 to .2 could be used for total annual costs related to external assistance.

Internal Personnel. The implementation project team does not necessarily end its responsibilities at time of system cutover. A phased implementation approach and continuous improvement efforts will require ongoing time commitments. Employee turnover and job rotation will also require ongoing training efforts. The nature of the ERP software package (and associated system software and hardware) typically mandates the number and expertise of MIS personnel needed for ongoing support. It may range from a part-time clerical person (for administering a micro-based ERP package) to a large group of MIS experts (for some mainframe ERP packages). As shown in the example estimates in figure 3.4, a ratio of .1 to .2 could be used for total annual costs related to internal personnel.

*This concludes Part Three of a four-part article reprinted from Maximizing Your ERP System by Dr. Scott Hamilton. Bridging the theory and realities of current ERP systems, Maximizing Your ERP System provides practical guidance for managing manufacturing in various environments. Drawing on case studies from Dr. Hamilton’s first-hand experience in consulting with more than a thousand firms, it covers common problems and working solutions for how to effectively implement and use ERP systems. The book can be ordered on amazon.com. This excerpt on “Justification of ERP Investments” is presented in four parts:

  • Quantifiable benefits from an ERP system

  • The intangible effects of ERP

  • Costs of implementing an ERP system

  • Replacing or re-implementing an ERP system

Reprinted with permission of McGraw-Hill.

 

Justification of ERP Investments
Part Four: Replacing or Re-implementing an ERP System

Featured Author - Dr.Scott Hamilton - February 13, 2004

1. Replacing or Re-implementing an ERP System*
2. Classifications of ERP Success
 

Replacing or Re-implementing an ERP System*

An investment analysis focusing on enterprise resource planning (ERP) benefits frequently applies to those firms initially justifying an ERP implementation. It can also be used to justify a “re-implementation” when the initial efforts have failed to produce desired results. The box describing “Classifications of ERP success” identifies situations where the ERP implementation falls short of producing desired benefits.

*This is Part Four of a four-part article reprinted from Maximizing Your ERP System by Dr. Scott Hamilton. Bridging the theory and realities of current ERP systems, Maximizing Your ERP System provides practical guidance for managing manufacturing in various environments. Drawing on case studies from Dr. Scott Hamilton’s first-hand experience in consulting with more than a thousand firms, it covers common problems and working solutions for how to effectively implement and use ERP systems. The book can be ordered on amazon.com. This excerpt on “Justification of ERP Investments” is presented in four parts:

  • Quantifiable benefits from an ERP system

  • The intangible effects of ERP

  • Costs of implementing an ERP system

  • Replacing or re-implementing an ERP system

Reprinted with permission of McGraw-Hill.

Classifications of ERP Success

Several measures have been used to gauge the successful implementation of an ERP system. The impacts on business performance and bottom-line results provide the best measure of success. Another measure of success is the degree to which the formal ERP system is used to run the business. Four classifications –-termed Class A through Class D--–have often been used to characterize success.

Figure 3.5 summarizes these classifications of ERP success.

Class A User. The formal ERP system is effectively used to run the entire company. The manufacturing database defines the way products are really built, and efforts have been undertaken to simplify factory layouts and business processes. The ERP system defines realistic agreed-upon S&OP (sales and operations planning) game plans that cover all demands, sales orders have realistic delivery promises, and the schedules are actually used to coordinate supply chain activities. Coordination efforts reflect action messages, with a manageable number of exceptions. The ERP system correctly updates accounting and provides useful management information. The ERP system typically reflects the latest releases from the software vendor.

Class B User. The formal ERP system is partially effective in being used to run the entire company. It defines S&OP game plans, but they typically lack company-wide agreement and completeness. Supply chain activities are frequently initiated that do not reflect schedules from the ERP system, and the volume of action messages frequently makes them difficult to use. Unrealistic delivery promises on many sales orders contribute to the problem, and also create a larger-than-necessary volume of exception conditions requiring expediting. Some informal and parallel systems are employed to manage expediting outside the formal system. While the manufacturing database provides a reasonably complete and accurate model of how products are really built, there are just enough exceptions to make some people question the formal system. The accounting applications are closely coupled to operational reporting, but sufficient exceptions exist to make the financial impacts suspect.

Class C User. The formal ERP system is only used in part of the company, typically in recording information about sales orders, shipments, purchase order receipts and accounting applications. The manufacturing database provides an incomplete or inaccurate model of how products are really built. S&OP game plans are typically non-existent, and unrealistic delivery promises are made on many sales orders. Several informal or parallel systems are required to coordinate procurement and production activities, typically with excessive expediting efforts and duplicate data maintenance. The accounting applications are not closely coupled to the activities reported in production. The ERP system reflects an old version of the software package.

Class D User. The formal ERP system is not used to run any part of the company, and might be “running” only in the management information system (MIS) function. Informal and parallel systems are being used to manage the business.

Over the last twenty-five years, field surveys about ERP success indicate approximately 10percent of firms achieve Class A status, 40percent are Class B, 40percent are Class C and the remainder (10percent) are failures.

Many manufacturers think they need a “new system” when they really need to upgrade and re-implement their current ERP software package. They can be characterized as a “Class B” or “Class C” user, and are not achieving the possible benefits--–both quantifiable and intangible. In many cases, they are using an older version of the software package and havve made significant customizations. The estimated costs to upgrade and re-implement are typically less than a “new system”, as illustrated in figure 3.6. In this example, some general rules of thumb (or ratios) have been used to estimate the one-time costs.

 

The costs to re-implement an ERP system should be significantly lower than implementing a new system. The users have familiarity with system usage, and should know the system strengths and weaknesses. Many firms can live with the shortcomings of their existing system. External assistance from the software vendor and consultants can help develop solutions to shortcomings, and should in any case be part of continuous improvement efforts. With a firm understanding of the re-implementation costs and shortcomings, the investment decision should be justified on the basis of benefits.

Many manufacturers are faced with decisions about replacing their current ERP software package or homegrown system. The replacement decision can stem from any number of situations. The current ERP software package is no longer supported; is too expensive to maintain; is heavily customized and cannot be upgraded; runs on old technology; is too complex and expensive to implement; and so forth. A homegrown ERP system provides partial solutions or non-integrated solutions; it’s not on the right technology platform; nobody knows the system and can support it; nobody can upgrade the system; and so forth. The investment decision in these cases tends to use cost comparisons between alternatives.

The starting point for cost comparisons should be the previously discussed classification of costs, both one-time and ongoing annual costs. The following case study illustrates the use of cost displacement as the basis for ERP investments.

Case Study: Cost Displacement as the Basis for ERP System Replacement

Several autonomous plants of a multisite manufacturing firm implemented a stand-alone micro-based ERP package at each site because it was a cheaper alternative than the corporate standard. The corporate ERP system was a complex mainframe system that required very high levels of external assistance, large expenses for customizations, and high charge-out rates from the corporate MIS function. The one-time and ongoing costs for the corporate system were two to three times higher. The plant management even argued (successfully) that they could implement the new system in three months, obtain the benefits over a six month payback period, and ultimately throw it away in two years when the corporate MIS function was finally ready to implement the mainframe system at their plants. Three years after these plants successfully implemented the single-site ERP system (with three month implementation periods), the plants are still using the system while other sites within the company have struggled to even partially implement the mainframe system. The cost displacements (and benefits) have been estimated to be more than one million dollars.

About the Author

Dr. Scott Hamilton has specialized in information systems for manufacturing and distribution for three decades as a consultant, developer, user, and researcher. Scott has consulted for over a thousand firms worldwide, conducted several hundred executive seminars, and helped design several influential ERP packages. He previously co-authored the APICS CIRM textbook on How Information Systems Impact Organizational Strategy and recently authored Managing Your Supply Chain Using Microsoft Navision. Dr. Hamilton is currently working closely with Microsoft partners involved with manufacturing and distribution, and can be reached at ScottHamiltonPhD@aol.com or 612-963-1163.