Skip to main content

P4038-R Greyhound - Detailed Business Case For Implementing A Human Resource Management System Strategy: Compiled And Presented By EIMS Project Core Team

This document is available in two formats: this web page (for browsing content) and PDF (comparable to original document formatting). To view the PDF you will need Acrobat Reader, which may be downloaded from the Adobe site. For an official signed copy, please contact the Antitrust Documents Group.
Government Exhibit P4038-R
Greyhound Lines, Inc.
Greyhound Canada Transportation Corp.
EIMS Project





Greyhound's logo

Greyhound Lines, Inc.

Greyhound Canada Transportation Corp.

Detailed Business Case for Implementing a Human
Resource Management System Strategy


Compiled and Presented by

EIMS Project Core Team





April, 2002

 

Confidential GDD 005132


Table of Contents

Executive Summary
   Goals
   Background
   Alternatives
   Recommendation
Background
   Introduction
   System Issues - Major risks, problems, and constraints
   Current Systems Environment
   Current System Costs
   Detailed Analysis of Risks, Problems and Constraints
Project Objectives
Business Alternatives
   Introduction
   Alternative # 1: Status Quo
   Alternative # 2: Modularize and Band Aid
   Alternative # 3: Implement an Integrated HRMS System
Recommendation
   Summary of Key Reasons for Recommendation
Software Selection and Recommendation
   Introduction
   Project Team Evaluation Results
   Five Year Total Cost of Ownership
   Contracts
   Other Considerations
Recommendation
   Key Reasons for Recommendation
Implementation Consultant Selection
Architecture and Development Considerations
   Introduction
   Application Architecture
   Development Tools
   System Environments
   Conclusion
Impact on the Operational Environment
   Introduction
   Hardware
   Network Environment
   Database
   Disaster Recovery
   Other Considerations
Cost / Financial Analysis
   Overview
   Five-Year Total Cost of Ownership
   Investment Benefits

Confidential GDD 005133

   Projected Return on Invesment(ROI)
Risk / Risk Avoidance
Project Timeline
   Overview of Scope and Approach
   Project Phases
Terminology

Confidential GDD 005134


Executive Summary

Goals

The goal of this project is to review Greyhound's (GLI and GCTC) system needs, assess viable alternatives, and provide a recommendation to management for a solution to improve Greyhound's ability to manage human resources effectively. This solution or project shall be referred to as the Employee Information Management System (EIMS).

The solution will accomplish the following goals:

Once senior management has approved the recommendation, the main purpose of the Project Team will be to facilitate implementation.

Background

Greyhound Lines Inc. is no longer just GLI. It is a blending of GLI, Greyhound Canada Transportation Corp., and its subsidiaries. The future undoubtedly holds acquisitions, mergers, and consolidation of subsidiaries within Greyhound.

There are 58 different sources of data currently identified within the Greyhound systems encompassed by this project. These are comprised of 10 major systems, 24 secondary systems, databases or data sources, and 24 interfaces and reporting tools between the major and minor systems and/or other mission critical systems of Greyhound.

As the company grew, individual department's developed or purchased their own software solutions. While this works fine for the individual departmental needs, it has some major faults. With information residing in so many places, updating becomes a difficult task. Which database is correct? Many of these systems are no longer supported, and Greyhound loses any synergies they may gain from a single source database. Reporting across multiple databases is constrained, and the ability to provide managers with real time data and reports to manage their business is restricted.

Confidential GDD 005135

Alternatives

In order to select the best possible solution for Greyhound's business needs, three different business alternatives were evaluated. The specific alternatives were as follows:

  1. Status Quo -Existing systems will be kept in place and supported as they are today is what Alternative 1 encompasses.
  2. Modularize and Band Aid - This option takes the current Greyhound applications and makes only necessary changes to essential applications to fix potential mission critical problems and improve driver/employee management. Outdated business practices and work arounds are eliminated. To accomplish this, the core HR systems will be replaced, payroll systems updated, a driver management system developed, and an Enterprise reporting tool will be purchased.
  3. Implement an Integrated HRMS System - By purchasing an "off the shelf" HRMS System, Greyhbund combines numerous systems and data sources into a single repository, allowing improved data access and integrity, and many synergies associated with a single database.

To assess the value of the individual alternatives, each was rated and scored based on the 12 primary customer requirements for the project goals. In addition, a cost was determined, a list of pros and cons developed, and key points were identified. Based on the data and information gathered, a recommendation was prepared and presented.

Recommendation

The recommendation is Alternative 3, Implement an Integrated HRMS System. Such a solution will provide for Greyhound and its subsidiaries the ability to fulfill the customer's current, future needs and meet the current, future requirements related to those needs.

The Project Team recommends Alternative #3 as the best long-term strategic solution for the company. The primary reasons for the recommendation are:

From a technology perspective this is "hand's down" the best alternative and consistent with all IT best practices for corporate system architecture. From a business perspective, this strategy provides the greatest possible upside to optimizing operations and streamlining processes.

Confidential GDD 005136

Background

Introduction

In June 2001, Greyhound (GLI and GCTC) initiated the EIMS project to recommend a strategy for addressing Grehound's Human Resource, Payroll, and Driver Management information needs. A Project Team was constructed with representatives from the functional areas within Greyhound that were seen as being under the EIMS umbrella. The listing of the actual Project Team members can be found in Appendix 1 - Project Team.

This document is the detailed business case created by the Project Team. It contains all the specifics on how the business case was built and the processe used to evaluate and select the final alternative for the recommendation.

System Issues - Major risks, problems, and constraints

The major risk today is the age of our current systems. Historically, the company has not made a significant investment in these systems, which resulted in a "piece meal" or "band aid" approach. This approach resulted in a system environment that is unstable, inflexible to change and constrains Greyhound's ability to streamline business processes.

For instance:

HR-1 (used by GLI HR) is a DOS based application originally installed in 1993. The system is no longer supported by the vendor and was developed in a "dead" programming language (A-REV).

A total of 12 risks, problems, and constraints were identified with these systems.

Support Costs

GLI paid $250K for a consultant from 1/99 thru 3/00 to stabilize HR1 and resolve programming issues.

HR2000 (used by GCTC HR) is a DOS based applicationinstalled in 1990. Like HR-1 above, the vendor no longer supports the current version of the system and the programming language (REV-G ) is even more out of date.

A total of 14 risks, problems, iind constraints were identified in this system.

Confidential GDD 005137

Driver Taxation Issue

GLI drivers often live (and should be taxed) in a different state from their work location.

For the normal paycheck ADP can accommodate this, however, for any supplemental check, ADP taxes strictly based on work location.

This can/has resulted in incorrect taxation, W2-Cs, and extremely unhappy drivers

GLI outsources the payroll processing to ADP in Atlanta, Georgia. ADP PCPW (used by GLI Payroll) is the canned application provided by ADP to allow GLI to process the payrolls.

A total of 11 risks, problems, and constraints were directly linked to the ADP solution.

Micro Pay (used by GCTC payroll) is a DOS based application installed in 1991 and heavily customized by Coridian to meet the unique pay requirements of our bus operations. The system is no longer supported by the vendor and customization to meet changing business requirements is not possible.

A total of 18 risks, problems and constraints were identified with this system.

Pension Data Load

Because of the floppy diskette interface from Micro Pay, the following 5-9 hour process is required to merely load summary information from one system to another:

  • Ceridian Overnights the floppy diskette
  • Benefits loads the data to HR2000 (1.5 hours)
  • Research errors (1-4 hours)
  • Benefits backs out the uploaded information (1.5 hours)
  • Benefits makes corrections (0.5 hours)
  • Benefits reloads diskette to HR2000 (1.5 hours)

Driver information is currently stored in a variety of data repositories (at least 12) scattered throughout the organization. Examples of the driver data include:

1. Safety data 2. Accident data 3. Pay data
 
4. Contact information 5. Mystery ride data 6. Certification data
 
7. Disciplinary data 8. Grievance data 9. Workers comp data
 
10. Drug and alcohol testing data 11. Safe bus data 12. Safety awards data

It is important to note these are individual data sources stored in an assorted variety of spreadsheets, standalone databases as well as major systems such as Driver Pay and BOSS. This creates a magnitude of data integrity, process inefficiencies (duplicate keying) and reporting constraints for the organization.

Confidential GDD 005138

Current Systems Environment

The following sections:

present a high-level view of the current system that shows the unnecessary complexity in our environment

present the costs associated with business processes and support

present the risks, problems and constraints from both a business and technical perspective

supplement these facts and opinions with actual war stories from the field

The diagrams in this section show examples of:

the complexity of the current technical environment

the complexity of the current business processes

the opportunity for improvement

Technical Environment

Diagram 1: GLI/GCTC High Level Systems Structure shows the current systems environment. Diagram 2: GLI/GCTC Integrated Systems Structure depicts the expected environment with the implementation of an integrated HRMS system.

As the diagrams illustrate, consolidating the current databases has a direct impact on the environment supporting them. This is especially evident in the interface sections. The major interfaces between the major databases (HR, Payroll, Driver Pay, Oracle) are reduced significantly. This is a microcosm of the improved efficiencies that will be inherent with an integrated system.

Confidential GDD 005139

Diagram 1: GLI/GCTC High Level Systems Structure

 GLI/GCTC High Level Systems Structure[D]

Confidential GDD 005140

Diagram 2: GLI/GCTC Integrated Systems Structure (Recommended Solution)

 GLI/GCTC Integrated Systems Structure (Recommended Solution)[D]

Confidential GDD 005141

Table 1: Technology Components statistically summarizes the major technology components and shows the opportunity for improvement.

Table 1: Technology Components

Component Category Current Environment Future Environment % Change
Major Applications/Databases      
HR1 (GLI)      
HR2000 (GCTC)      
ADP (GLI)      
ADP Mainframe (GLI)      
Ceridian (GCTC)      
Ceridian Mainframe (GCTC) 11 5 - 55%
EYA (GCTC)      
Oracle (GLI)      
JDEdwards (GCTC)      
Driver Pay (GLI)      
Kronos (GLI)      
Minor internally built/custom Apps
(MS Access, FoxPro, Excel)
16 0 - 100%
Minor 3rd Party Applications
(UPS, Manulife, EECRS)
9 9 0%
Major Critical Interfaces 36 7 - 81%
Supporting Interfaces 33 7 - 78%
Report Tools 12 6 - 50%
Total Major Components 117 34 - 71%
Note: A detailed listing of all the individual pieces is included in Appendix 3 - Current Environment.

Business Processes

GLI has approximately 200 processes related to HR and Payroll. To demonstrate complexity of the current business environment we flowcharted the processes to highlight the risks (or "failure points"), the cost, as well as the opportunity for improvement by automating process steps and decisions (or best practices).

Confidential GDD 005142

Each process presented includes a flow chart of the current process or "current state" (current), a flow chart of the streamlined process or "end state" (future) as well as a quantitative summary of the potential improvements. The processes presented include:

  1. Salary Change - Non-Driver
  2. ADP Company Transfer
  3. Daily Changes

The following diagrams reference the term "failure point". A failure point is any point in the process where data can be dropped, added incorrectly, or corrupted causing data integrity issues.

Note: The future processes as defined for purposes of this section are relative to the implementation of an integrated HRMS system.

Salary Change Process - Non-Drivers

GLI processes approximately 11,000 non-driver salary changes each year. The Best Practices re-engineering assumes that the data entry is done by the Managers in a decentralized fashion using Manager Self Service and workflow is used for approval and for notification purposes.

Diagram 3: GLI Salary Change - Non-Driver (Current) depicts the current process and Diagram 4: GLI Salary Change - Non-Driver (Future) encompasses the future view of the process.

Confidential GDD 005143

Diagram 3: GLI Salary Change Non-Driver (Current)

Based on current policies

 GLI Salary Change Non-Driver (Current)[D]

Confidential GDD 005144

Diagram 4 : GLI Salary Change - Non-Driver (Future)

Based on current policies

 

 GLI Salary Change - Non-Driver (Future)[D]

Confidential GDD 005145

Table 2: GLI Salary Change - Non-Driver Process Analysis shows the number of failure points, process steps, decisions, and process costs associated with the current and future process designs along with the calculated percentage of change from current to future.

Table 2: GLI Salary Change - Non-Driver Process Analysis

  Current Future % Change
Failure Points 7 2 - 71%
Total Process Steps 18 15 - 17%
    Automated Steps 0 11 + 100%
    Manual Steps 18 4 - 77%
Total Decisions 3 3 0%
    Automated 0 3 + 100%
    Manual 3 0 - 100%
Process Costs $ 27,500 $ 13,750 - 50%
    Initial Keying $ 13,750 $ 13,750 0%
    Second Keying $ 13,750             0 - 100%

ADP Company Transfers

This process is necessary because of the structure of the ADP Payroll System. It maintains 6 different "databases" called companies. We have approximately 100 of these "transfers" each year. An employee moving from a driver to a driver supervisor or an employee moving from customer service / food service to the TIC would constitute an ADP Company Transfer.

In a single, integrated database environment, these "transfers" would no longer be required. Only a move to a company with a separate EIN would require a transfer. An example of this would be an employee of GLI moving to GSS.

Diagram 5: GLI ADP Company Transfer (Current) shows the current process as having to be done by GLI. The future process is non-existent as shown in Diagram 6: GLI ADP Company Transfer (Future).

Confidential GDD 005146

Diagram 5: GLI ADP Company Transfer
(Current)

Moving from Hourly to Salaried,Customer Service to TIC, etc.

 GLI ADP Company Transfer (Current)[D]

Confidential GDD 005147

Diagram 5: GLI ADP Company Transfer (cont.) (Current)

 GLI ADP Company Transfer (cont.) (Current)[D]

Confidential GDD 005148

Diagram 6: GLI ADP Company Transfer (Future)

This process is completely eliminated with the implementation of an integrated HRMS System

Table 3: GLI ADP Company Transfer Process Analysis shows the number of failure points, process steps, decisions, and process costs associated with the current and future process designs along with the calculated percentage of change from current to future.

Table 3: GLI ADP Company Transfer Process Analysis

  Current Future % Change
Failure Points 17 0 - 100%
Total Process Steps 22 0 - 100%
    Automated Steps 5 0 - 100%
    Manual Steps 17 0 - 100%
Total Decisions 5 0 - 100%
    Automated 2 0 - 100%
    Manual 3 0 - 100%
Total Process Costs $ 495 0 - 100%
    Rework $ 495 0 - 100%

Daily Changes

The Daily Changes process moves changes entered into HR-1 to ADP. The process runs daily on business days.

In an integrated HRMS system, this type of data transfer would not be required because the HR and Payroll systems will simply be modules of the same application and will share the data. The remaining step in the process will be the transfer of data to Kronos.

Diagram 7: GLI Daily Changes Current shows the current processes and Diagram 8: GLI Daily Changes Future tne anticipated processes.

Confidential GDD 005149

Diagram 7: GLI Daily Changes (Current)

This process moves the changes from HR-1 to ADP and then to Kronos

 GLI Daily Changes (Current)[D]

Confidential GDD 005150

Diagram 8: GLI Daily Changes (Future)

With an integrated HRMS system, the only data movement necessary will be to Kronos.

  Export Data To Kronos  

Table 4: GLI Daily Changes Process Analysis shows the number of failure points, process steps, decisions, and process costs associated with the current and future process designs along with the calculated percentage of change from current to future.

Table 4: GLI Daily Changes Process Analysis

  Current Future % Change
Failure Points 10 0 - 100%
Total Process Steps 28 1 - 96%
    Automated Steps 2 0 - 100%
    Manual Steps 26 1 - 96%
Total Decisions 2 0 - 100%
    Automated 2 0 - 100%
    Manual 0 0 0%
Total Process Costs $ 2,813 $ 315 - 89%
    Manual Processing $ 2,813 $ 315 - 89%

Current System Costs

Activities based costing and benchmarking has historically been used to assist organizations in measuring internal processes and as a tool to identify opportunities for improvement. In conjunction with this initiative, both the Payroll and HR departments were analyzed for comparison with other companies and the transportation industry. The comparison benchmarks were supplied by CDG and Associates, an independent consulting organization. Greyhound's expenses were adjusted to provide the best possible "apples to apples" comparison. The details regarding the benchmark comparison can be found in the Appendices.

Note: All cost calculations include both direct departmental costs and IT support costs in the calculation.

Confidential GDD 005151

GLI US Payroll Costs

This graph shows that Greyhound's cost per payment is:

Bar graph showing Overall Cost Per Payment Produced (USD)[D]

GCTC Payroll Costs

The graph below shows that GTC's cost per payment is:

in the upper 75th percentile among all companies (way off the chart)

nearly 500% higher than the median in the transportation industry

$9.00 per check (340%) higher than companies with greater than 10,000 employees

Bar graph showing Overall Cost Per Payment Produced (USD)[D]

Confidential GDD 005152

GLI Human Resources

This graph shows GLI's HR cost per employee is:

Roughly $ 250 or 78% lower than the average of all companies in the survey

Bar graph showing HR Cost Per Employee (USD)[D]

GCTC Human Resources

This graph shows GCTC's HR cost per employee is:

$ 562 or 50% lower than the companies in the survey

Bar graph showing HR Cost Per Employee (USD)[D]

Note: All cost calculations include both direct departmental costs and IT support costs in the calculation.

Confidential GDD 005153

Summary

While benchmarking is more of an art than a science and should not be the only factor in a major decision, you can draw the following conclusion from the above analysis.

  • A large opportunity exists to improve Greyhound's payroll processing costs
  • Greyhound's HR expenses are lower than the companies surveyed

Detailed Analysis of Risks, Problems and Constraints

The following section provides detailed information regarding the risks, problems and constraints, as well as highlights a few corresponding opportunities where appropriate. Both the Technical Risks and Business Issues are addressed.

Technical Risks of System Failure

Maintaining the current environment and set of systems to perform the current mission critical business needs has a number of risks to the company. The risks are primarily due to the retention of old products discontinued by the vendor from both a development and support perspective. Below are examples of technical risks as a result of Greyhound's current environment:

  1. Internal Resource & Vendor Product Support
  2. HR1 Program & Memory Limitations
  3. HR1 Network Client, Protocol & Latency Limitations
  4. No ADP Test Environment

1. Internal Resource & Vendor Product Support

HR1/HR2000 are Greyhound's HR software packages written in the late 1980's by Ceridian. Greyhound has internally supported these products since 1997 when the vendor discontinued support.

HR1 and HR2000 are written in discontinued development languages; A-REV and REV-G respectively. This directly equates to increased risk and cost to Greyhound. GLI paid $ 250K for a consultant to stabilize HR1 and resolve programming issues. Since the technology is "dead", the resource pool available to support these applications is diminishing.

Due to the discontinuation of support, Greyhound no longer has access to:

If the system encounters a serious error causing corruption or degradation, the vendor will not supply any assistance.

Confidential GDD 005154

  • Technical Expertise

The vendor will not provide testing and settings for migrations to new operating systems, platforms, networks, or hardware. New platform environments are unknowns and Greyhound will essentially be beta testing the product with each Network, Database, or PC upgrade. The upgrade to Windows 2000 or Windows XP will affect Greyhound.

Email from GCTC Payroll Supervisor to the Manager

"I have been advised by my department that for some reason they are unable to run reports...Ceridian... advised her they no longer support report writer...and we should look at updating to a new process. [Ceridian] stated that they could no longer help us with reports...he said that basically he was told [our] system is dead in the water."

No future enhancements or patches will be developed or released. In 1998-2000 modifications to government compliance/business issues such as COBRA and HIPAA were coded within Greyhound at substantial internal cost. This also includes modifications to any government reports.

2. HR-1 Program Size and Memory Limitations

There is a hard limit of 34,000 characters for a program written in HR-1. There are currently at least 3 critical programs near this code size limit:

HR-1 is limited in the amount of RAM, or memory it can utilize. Furthermore, because it is an older DOS-based product, it can only access Expanded memory. Expanded memory is an out-dated memory access method no longer automatically available on computers. In order to provide expanded memory, a special memory manager must be configured on each computer. This memory manager does not always work correctly with newer hardware. This can cause significant issues with the availability, response, and usability of HR-1 on a computer.

3. HR-1 Network Protocol, Client & Latency Limitations

HR-1 is limited to running on an IPX network. The IPX protocol is specific to Novell NetWare networks, thus database files must reside on a Novell file server. Revelation Technologies does have a utility that will allow HR-1 to run on TCP/IP

Confidential GDD 005155

networks. However, performance is generally slower and there are more technical issues involved with keeping the application stable.

A "network client" is required for each PC on a network. Greyhound uses the Novell NetWare client provided by Novell. There are serious compatibility issues with the recent versions of the Novell NetWare client and HR-1. Users of HR-1 must have an older version of the NetWare client installed on their PCs. This client cannot be patched or upgraded as this causes HR-1 to not work correctly on that machine. This limitation restricts our abilities to upgrade the computers of HR-1 users if there is a "bug fix" or maintenance patch available for the Novell NetWare client.

HR-1 is very sensitive to "network latency". Latency is a measure of the responsiveness of a network. If the network is very busy, and requests process slowly, it is said to have high latency. The higher the latency of the network, the more unstable HR-1 becomes. In some instances, this means that no other network applications, such as email, can be run at the same time as HR-1. This causes significant frustrations for the users who just want the program "to work". Furthermore, network latency is a very difficult issue to diagnose and correct.

4. ADP: No Test Environment

GLI does not have a test environment for the ADP Payroll application. The primary reason for this is that the application is hard-coded to connect to a particular data source. ADP does not provide an easy method of choosing which database to connect to. A compromise has been reached where we have created a test company code within the production environment. This allows us to test some basic import functionality. However, it does limit our abilities to fully test changes to the interface between HR-1 and ADP.

In Atlanta on the ADP mainframe, the test process consists of "flipping a switch" that allows us to process a test payroll run. If for any reason they forget to "flip the switch" it can cause several days worth of clean up. It has happened in the past.

Discussion of Business Problems, Constraints, & Risks

Maintaining the current environment and set of systems to perform the current mission critical business needs has a number of risks to the company. The risks are primarily due to the retention of old products that have been discontinued by the vendor from both a development and support perspective. The following list contains the Top 10 Business Issues as result of Greyhound's current environment:

Confidential GDD 005156

Top 10 Business Issues (GLI/GCTC)

  1. Payroll Outsourcing Costs
  2. 3 X 5 Index Cards
  3. Mission Critical Systems & Floppy Diskette Interfaces
  4. Vacation, Sick and Personal Days
  5. Interest Savings on Tax Payments
  6. Inefficient Processes and Points of Failure
  7. Effective Dating
  8. Managing Personnel Files
  9. Garnishment Processing
  10. Limited Deduction and Earning Codes

Payroll Outsourcing Costs (GLI/GCTC)

The annual costs to outsource Payroll processes which includes W2, T4, and tax filings are:

GLI $ REDACTED
 
GCTC $ REDACTED
 
Subsidiaries, Average per $ REDACTED
 

Note: These costs increase 5% per year.

3 x 5 Index Cards (GCTC)

GCTC still relies on 3 x 5 paper index cards to track the following information:

  • Seniority information
  • Statutory holiday accruals
  • Vacation/Sick hours taken
  • Vacation accruals
  • STD/LTD
  • Workers Compensation
  • Leaves of absence
  • Part Time hours worked
  • Time missed by Full Time employees
3 x 5 Cards

Researching, updating, and maintaining 4,300 3 x 5 index cards makes up a core element of the daily business.

Confidential DD 005157

Examples of significant issues presented by Index Card filing are:

Mission Critical Systems & Floppy Diskette Interfaces (GCTC)

GCTC's link between the Payroll and HR systems is a floppy diskette. Ceridian produces the diskette and it is uploaded to the HR2000 system. This process is archaic and labor intensive (if, adjustments are required).

Vacation, Sick, and Personal Days (GLI/GCTC)

The ability to provide the field or corporate management how many vacation, sick, personal days an employee has available is not possible today. The unique rules provided by each contract prohibit the current systems from tracking such data accurately. This function, therefore, is the responsibility of each manager.

Examples of the related issues:

  • Employees are provided more personal time than they are eligible
  • Manual, labor intensive process placed on the local manager
  • Termination payoffs are difficult to assess; Greyhound will usually pay more in the case of disputed personal time off available
6 Location Audit

A 6 location audit for Vacation, Sick, and Personal days taken in excess of time allowed revealed an average of $35 per employee paid in ineligible dollars paid.

With a base number of related employees at 5,000, the total annual cost is $175K.

Interest Savings on Tax Payments (GLI)

ADP requires funding for tax liabilities to be sent to them 1 day prior to the check date. The liability is not due to the government entity until the day after the pay date.

Examples of the related issues:

Confidential GDD 005158

Inefficient Processes and Points of Failure (GLI/GCTC)

The presence of additional databases, interfaces, and points of data entry present process inefficiencies and data integrity issues. Simple employee record maintenance changes such as address, W4, beneficiary, emergency contact, name, and phone number changes require a number of processes for the employee, manager, and HRIS associates.

A prime example is an address change.

Table 5: Address Change Process Analysis

Current Processes HRMS Employee Self Service % Improvement
  • 8 steps
  • 3 steps
  •  62%
  • 3 Greyhound resources
  • 1 Greyhound resource
  •  67%
  • 3 interfaces
  • 0 interfaces
  • 100%
  • Key into 5 systems
  • Key into 1 system
  •  80%
  • Add to 1 index card
  • No index card needed
  • 100%

A Point of Failure is any point in the process where data can be dropped, added incorrectly, or corrupted causing data integrity issues. Consequently, a great deal of research is required to monitor the data integrity between systems. Table 6: Points of Failure illustrates reduction in points of failure an integrated HRMS system could provide.

Table 6: Points of Failure

Component Category Current System Expected HRMS
Databases 36 14
Interfaces 69 14
Report Tools 12 6
Total Major Components 117 34

NOTE: Details can be found in Appendix 3 - Current Environment, Current Environment Systems, Programs, & Major Interfaces table.

Effective Dating (GLI/GCTC)

No Greyhound HR/Benefits/Payroll related system provides effective (future or past) dating. The primary consequence is the need for manual paper processes to be applied at the exact correct time. If the changes are early or late, the ramifications have led to the following incorrect items:

Confidential GDD 005159

  • Benefits
  • Garnishments
  • Taxes
  • Earnings
  • Term Date
  • Hire Date
  • Term Date
  • Union Dues

Procedures to accommodate for this lack of functionality cause a great deal of inefficiencies. Two examples of these work-around processes are Annual Enrollment/Benefits and Merit Increases.

Annual Enrollment/ Benefits

Since the new benefits can not be applied to the live system with an effective date for the new elections, ITS is forced to create a temporary parallel environment. The future elections are entered irto a replica HR system instead of entering the data directly into the system.

ITS allocates $ 13,000 annually in costs to the annual enrollment process. This figure is an average amount based on the experience of the past three years.

Merit Increases

There are two significant issues in the merit increases:

  1. need for manual tracking
  2. need for changes to be applied exactly at the correct time

Because pay increases can not be entered in the system with a future effective date, the increase dates must be manually tracked. This is done using a variety of methods: 3 x 5 cards, spreadsheets, MS databases, and notes pinned to computers.

The changes must be entered in at the correct time in the pay cycle to accurately pay the employee with the old/new rates. The timing issues make Greyhound susceptible to missed increases and/or multiple costly retro checks to make up for the differences.

Managing personnel files

A significant portion of the Drver Supervisor's time is spent managing the employees paper files:
  • Filing copies of physicals, CDLs, drug tests, training certificates
  • File may be off-site for arbitration so the Driver Supervisor cannot file the paperwork until the file is returned. Document may get lost in the mean time or purged.
Paper Files

An outside consulting firm identified 8.0% of the Driver Supervisor's time is spent managing Paper Personnel Files.

Confidential GDD 005160

Having this data on-line instead of in paper copies will reduce the time spent shuffling paper and the possibilities of fraudulent activities.

Garnishment Processing (GCTC/GLI)

The limited garnishment, tax levy and child support functionality creates a need for processes which are extremely cumbersome.
  • Since GCTC uses 2 older payroll systems (DOS EYA and Ceridian), the garnishment functionality is very limited and unable to accommodate new compliance items. To compensate, several different calculation and tracking methods are employed: paper, MS Excel, and MS Access systems.
  • No historical data for each individual garnishment set up or time/date/User ID to show who and when changes are made to garnishment data.
Default Judgement vs. GLI

A Nebraska court sent an interrogatory letter stating their intention to enforce a $29K garnishment on a GLI employee. GLI has 7-10 days to answer this letter; otherwise a default judgement can be automatically levied against the employer.

The letter was lost in the paperwork handled in the garnishment process. Nebraska ruled GLI was liable for the $29K.

With the help of GLI Legal department, this was abated; however, this is a very real risk with the complexity and manual nature of the garnishment process.

Confidential GDD 005161

  • The current system will only allow six garnishments to be set up on an individual. Additional garnishments are calculated manually. This is an extremely laborious task and requires a very skilled garnishment resource to complete. GLI has employees who have more than 6 garnishments.
  • The number of deduction codes for garnishments are limited. The current system has only one garnishment deduction code and only one state tax levy code. If an employee has more than one garnishment, and both percentage amounts together and not over the Federal Limits, we can only set one. This is a non-compliance issue.
Too Many Garnishments

The ADP system accommodates 6 total child supports, garnishments, levies, and/or liens. A GLI employee has 8 child separate child support orders alone! Luckily 4 of the orders are being handled by a pair of courts allowing GLI to combine 4 orders into 2 payments.

If the orders were from 8 separate courts, the entire check would have to be calculated manually every pay period. This would be an extremely manual, error prone and laborious process. It would take an equally sharp garnishment resource to ensure it was calculated correctly to protect GLI from liability.

  • The case number field in ADP is limited and some case numbers are too large for the field. This causes the payees/courts to return the check and demand a reissue. The timing then becomes a possible liability to Greyhound in addition to the cost of void/reissue.
  • The current system does not have a comment area or flag to indicate that an employee has filed for bankruptcy or that we need to file an answer. There is no way to identify employees wio have garnishments that have been inactivated due to bankruptcies. This is a compliance issue.
Not enough Information

5% of the Case ID #'s are longer than the field provided by ADP. This creates a hybrid automated/manual process of allowing the checks to be printed automatically and pulling individuals to attach a separate document with the entire Case ID#. This task is done approximately 40 times per week or 2000 times per year.

Confidential GDD 005162

Limited deduction and earnings codes

Both GLI and GCTC are running out of earnings and deduction codes. For instance, the ADP system provides 84 earnings and 101 deduction codes. At this time only 18 earnings and 4 deduction codes remain. The negative impacts of this limitation are:

  • Inability to accommodate all driver earnings codes: Drivers have 73 earnings codes alone. Neither ADP nor Ceridian can accommodate this many codes; thus, they must be consolidated into a smaller number of like earnings types and provided a separate statement with the paycheck.
  • Driver Pay/GL Balancing: Not having direct mapping from earnings type to a specific account causes additional balancing time and more research that is laborious.
Earning Statement Woes

Producing and matching the earnings statement to the check, causes the following items:

  • 4 departments involved
  • 4 resources
  • 1,250 Work hrs/year
  • Paper, printing, envelope, stuffing, and collating costs

Additional Business Issues

In addition to the Top 10 Business Issues covered above, the following lists other important business issues Greyhound faces today. Appendix 4 - Additional Business Issues and Initiatives contains detailed descriptions of these.

Confidential GDD 005163

Project Objectives

The overall objective of the EIMS project is to develop and implement the best strategy for Greyhound. This strategy focuses on fulfilling customer needs as determined by the Executive Steering Committee.

Customer Needs

  1. Reduce risk of system failure
  2. Improve processes (save money)
  3. Improve data access and integrity
  4. Support the integration of affiliates
  5. Improve reporting (3 major areas)

Customer Requirements

Fulfilling the customer's needs will be accomplished with the EIMS project by meeting the customer's requirements.

  1. Consolidate the GLI and GCTC employee data into one database and eliminate as many other databases as possible
  2. Replace any remaining DOS based applications
  3. Allow the "effective dating" of transactions
  4. Provide a "one stop shop" for all driver, safety, and DOT indicative data
  5. Select an application package that will grow with us and be flexible to fit business needs
  6. Provide the field and corporate management desktop access to employee data and reports
  7. Automate and streamline internal processes/departmental structure to more effectively process HR, Payroll, Benefits, and driver specific and employee related transactions
  8. Provide a proactive means to notify management of critical items such as certification, license, and grievance deadlines to avoid penalties and liability
  9. Eliminate the need for GLI and GCTC to develop and support custom databases to accommodate the business needs in the areas of Safety, DOT, or Driver Management.
  10. Provide a software solution supported and guaranteed by the vendor

Confidential GDD 005164

  1. Reduce the cost and risk associated with shipping and eliminating the potential of fraud of Driver employee paper files
  2. Provide the employees basic self service via the desktop, kiosk, or intra/internet access

After reviewing Greyhound's objectives, the Steering Committee enlisted a team to research and identify the solution to best address the current issues.

Confidential GDD 005165

Business Alternatives

Introduction

In order to select the best possible solution for Greyhound's business needs, three different business alternatives were evaluated. The specific alternatives were as follows:

  1. Status Quo -Alternative 1 leaves Greyhound systems as they are with no changes implemented.
  2. Modularize and Band Aid - This option takes the current Greyhound applications and makes only necessary changes to essential applications to fix potential mission critical problems and improve driver/employee management. Outdated business practices and work arounds are eliminated. To accomplish this, the core HR system will be replaced, payrolls systems updated, a driver management system developed, and an Enterprise reporting tool will be purchased.
  3. Implement an Integrated HRMS System - By purchasing an "off the shelf" HRMS System, we combine numerous systems and data sources into a single system, allowing improved data and many synergies associated with a single database.

To assess the value of the individual alternatives, each was rated and scored based on the 12 primary customer requirements for the project goals. For each alternative, a cost was determined, a list of pros and cons developed, and key points were identified. Based on the data and information gathered, a recommendation was prepared and is stated in the Recommendation section of this document.

Confidential GDD 005166

Alternative # 1: Status Quo

Approach

Alternative 1 represents keeping systems and processes as they stand today. This will mean there will be no changes of any kind made to the following environments:

Scope and Timeline

None applicable as nothing will be changing.

Cost of Alternative

The current costs of business are assumed to remain constant. They are as follows:

Table 7: Alternative 1- Five Year Cost of Ownership

  Costs   Notes
Capital Expenditures:
  Human Resources 12.0   Sever Upgrade
  Payroll  -  
  Driver Management  -
            
 
  Sub-Total Capital Expenditures 12.0  
 
Operating Expenses:
  Personnel (IT Support US only) 1,662.7   3.7 FTEs
  Software Maintenance  -  
  Hardware Maintenance 7.5  
  Training  -  
  Payroll Outsourcing 3,387.2 ADP and Ceridian
  Internal Check Printing  -  
  Other  -
            
 
  Sub-total Operating Expenses 5,057.4  
  Total 5,069.4  
 
  Avg. Number of Employees 15,609  
  Annual Cost per Employee $ 64.96  

Confidential GDD 005167

Scoring versus Project Goals

The alternative was evaluated and scored based upon its abilities to fulfill the Customer Needs and meet the 12 primary Customer Requirements.

This alternative scored an averaged raw score of 5 on its ability to fulfill the needs of the customer. This translates to a 20% meeting of needs. Alternative 1 received an averaged raw score of 12 in meeting the primary customer requirements translating to a 20%.

The detailed score sheets for this alternative can be found in Appendix 5 - Scoring of Alternatives along with the Scoring Criteria used.

Pros and Cons

Pros Cons

Summary of Key Points

Greyhound is "taking care of business" and will continue to do so under this alternative.

Additional costs or capital outlays will be minimized or nonexistent.

Greyhound will remain in the 20th century and continue to have the pain points and points of failure with the DOS applications, manual processes, multiple databases and interfaces, and outsourcing costs they currently have.

Current subsidiaries and future acquisitions cannot be incorporated into the current systems and "workarounds" will need to be developed to support them with HR and payroll functionality. This could result in an increase in headcount to provide the required functions for these groups.

Confidential GDD 005168

Alternative # 2: Modularize and Band Aid

Approach

This alternative focuses on taking the current Greyhound applications and making only necessary changes to mission critical applications in order to allow Greyhound to move beyond the 20th Century. In order to do this, Greyhound will need to:

  1. replace its core HR/Benefits systems
  2. upgrade the payroll systems
  3. develop a driver management system internally
  4. purchase and implement an Enterprise reporting tool

Assumptions

For purposes of evaluating this alternative the following assumptions were used.

Confidential GDD 005169

Scope and Timeline

A specific timeline for this alternative cannot be established at this time. The Project Team does not have the information to build one and all projects involved are subject to approval, resources available, and projects currently in process or pending.

Scoring versus Project Goals

Alternative 2 was evaluated and scored based upon its ability to fulfill the Customer Needs and meet the 12 primary Customer Requirements.

The alternative scored an averaged raw score of 13.7 on its ability to fulfill the needs of the customer. This translates to a 54.7% meeting of needs. Alternative 2 received an averaged raw score of 33.3 in meeting the primary customer requirements translating to a 55.6% level of accomplishment. The detailed score sheets for Alternative 2 can be found in Appendix 5 - Scoring of Alternatives along with the Scoring Criteria used.

Cost of Alternative

Table 8: Alternative 2 - Five

  Costs   Notes
Capital Expenditures:
  Human Resources 1,692.2    
  Payroll 388.9  
  Driver Management    866.5  
  Sub-Total Capital Expenditures 2,947.6  
 
Operating Expenses:
  Personnel (IT Support US only) 1,822.7    
  Software Maintenance 732.3  
  Hardware Maintenance 185.6  
  Training 100.0  
  Payroll Outsourcing 3,387.2 ADP and Ceridian
  Internal Check Printing  -  
  Other  -
            
 
  Sub-total Operating Expenses 6,227.8  
  Total 9,175.4  
 
  Avg. Number of Employees 15,609  
  Annual Cost per Employee $ 117.57  

Confidential GDD 005170

Pros and Cons

Pros Cons
  • Capitalization of costs associated with development and implementation
  • Leverages expertise on staff to build Driver Management system
  • Critical business needs will be met by short term solutions
  • Improves some functionality and reporting capabilities
  • Minimal reduction in operating costs through process improvements
  • Increases stability of GLI/GCTC HR/P infrastructures
  • Reduction of costs associated with development/maintenance of government compliance reporting
  • Minimal effective dating is available through the HR and benefits modules
  • Does not fulfill the customer needs at a level greater than 54.7%
  • Does not meet the customer requirements by more than 55.6%
  • Does not allow effective dating of transactions in areas of driver management and payroll
  • No reduction in outsourcing costs
  • No automation of the manual processes nor reduction of headcount associated with these manual processes
  • Increased cost of building and maintaining numerous interfaces
  • Does not completely provide for the incorporation of subsidiaries, GLI and/or GCTC, for providing services
  • No integration of payroll and HR/benefits data and does not provide opportunity to identify and avoid costs incurred due to system/interface failures or human error
  • Does not reduce overall cost of ownership/implementation of a long term solution due to the complexity of the custom solutions in the current environment and those developed for this alternative
  • Increased costs of maintenance of systems not currently incurred due to no vendor support
  • Does not dramatically reduce the amount of redundant, manual data entry into multiple systems
  • No guarantee of data integrity between the multiple systems
  • No change will occur in the quality of life for Greyhound employees due to processes remaining as they are now

Confidential GDD 005171

Summary of Key Points

Risk of system failure will be improved by replacing the existing DOS applications.

However, the risk associated with maintaining and integrating separate applications and databases will remain.

The high degree of customization and system integration complexity will result in higher support costs, lack of flexibility and some degree of system risk.

The lack of total integration will limit the company's ability to dramatically improve processes.

IT support costs will be higher to address the risk associated with system complexity and high degree of customization.

Employee data will be divided among three (3) databases thereby limiting data access, integrity, and reporting.

Integration of affiliates will be possible, but speed of integration will be limited and the cost will be increased.

Confidential GDD 005172

Alternative # 3: Implement an Integrated HRMS System

Approach

Alternative 3, the implementation of an integrated HRMS system, was looked at from the perspective of only implementing core systems for HR/Benefits, Payroll, and Driver Management. For purposes of evaluation, any additional services/products available above and beyond what we can accomplish in Alternative 2 were not included in this section. The recommendation of which alternative to choose was therefore based upon an "apples to apples" comparison and nothing more. In order to accomplish this goal, this alternative will require the following:

  1. Replacement of current HR/Benefits system
  2. Replacing current outsourced payroll module with an in house payroll solution to process and print checks
  3. Use the employee indicative data stored in the HR module along with data converted from the ancillary databases to provide a one-stop shop for the Driver Management system
  4. Provide reporting capabilities at all management levels through an Enterprise reporting tool

Assumptions

The following list contains the assumptions made in regards to this alternative:

  1. All Customer Needs and Requirements are to be met by this alternative as defined in the Scope cocument for this project
  2. Current vendors of financial applications of GLI and GCTC will remain status quo
  3. Recommendation was based on features and functionality and cost of a solution was not to be a determining factor for the Team
  4. Current existing systems/applications will be replaced and not merely upgraded
  5. Implemented HRMS solution will be the point of entry and the system of record for all Greyhound employee indicative data
  6. Access will be available through the intranet and/or internet
  7. An Enterprise reporting tool will be required
  8. Greyhound payroll will be processed internally with checks printed in-house and tax filings will be brought in house

Confidential GDD 005173

Scope and Timeline

The Scope can not be established for this Alternative due to lack of knowledge as to which HR software would be implemented. A timeline is contained in section Project Timeline of this document. It does not address or take into account other projects currently under development and pending or waiting to be approved.

Scoring versus Project Goals

The alternative was evaluated and scored based upon its ability to fulfill the Customer Needs and meet the 12 primary Customer Requirements.

This alternative scored a raw score of 23 on its ability to fulfill the needs of the customer. This translates to a 92% meeting of needs. Alternative 3 received an averaged raw score of 57 in meeting the primary customer requirements translating to a 95.0%.

The detailed score sheets for this alternative can be found in Appendix 5 - Scoring of Alternatives along with the Scoring Criteria used.

Cost of Alternative

The one-time investment to implement this strategy is $ 6.1 million dollars over the next 6 years or 0.11% of GLI's projected revenues. The following table shows the investment by major software module and the net present value investment in today's dollars (NPV).

Table 9: Investment Summary of Alternative 3 (In 000's)

  One-time Capital [a] On-going Operating Total Investment Total Benefits NPV @12% IRR
Human Resources REDACTED REDACTED REDACTED 1,597 (885) -11%
Payroll REDACTED REDACTED REDACTED 4,325 139 14%
Total Core REDACTED REDACTED REDACTED 5,922 (746) 4%
Advanced Functionality REDACTED REDACTED REDACTED 4,179 (54) 11%
Grand Total (6,091) (2,318) (8,409) 10,101 (800) 7%

[a] One-time investment for occurs over the first (2) years.

Confidential GDD 005174

Key Points:

The first step in justifying this investment is to explore issues and opportunities throughout the current systems in greater detail.

Table 10: Alternative 3 - Five Year Cost of Ownership

  Costs   Notes
Capital Expenditures:
  Human Resources REDACTED    
  Payroll REDACTED  
  Driver Management REDACTED  
  Sub-Total Capital Expenditures REDACTED  
 
Operating Expenses:
  Personnel (IT Support US only) REDACTED    
  Software Maintenance REDACTED  
  Hardware Maintenance REDACTED  
  Training REDACTED  
  Payroll Outsourcing REDACTED [a]
  Internal Check Printing REDACTED [b]
  Other             -     
  Sub-total Operating Expenses REDACTED  
  Total 9,072.0  
 
  Avg. Number of Employees 15,609  
  Annual Cost per Employee $ 116.24  

Notes:

  [a] Payroll outsourcing costs are eliminated in Year 3.
  [b] Internal check printing costs are estimated at $ 0.15 per check plus capital expenditures.

Confidential GDD 005175

Pros and Cons

Pros Cons
  • Fulfills 95.67% of the customer needs as defined in the Scope document for this project
  • Meets 91.67% of the customer requirements as defined in the Scope document for this project
  • All areas of the system allow effective dating of transactions
  • Reduces operating costs by:
    • Reducing/eliminating duplicate/redundant data entry
    • Reducing/eliminating multiple ancillary systems/databases and their associated development/support costs
    • Eliminating outsourcing costs
    • Providing opportunity to automate the many manual processes
    • Allowing for reallocation of human assets in place of increasing head counts
    • Reducing costs associated with development/maintenance of government compliance reporting
  • Provides the ability to be proactive in response to events versus the more prevalent reactive mode currently in place
  • Provides management with up-to-date enterprise data at their fingertips to make on-going, business critical decisions
  • Does not eliminate the risk of implementation
  • Does not provide a positive ROI until 3-4 years after implementation
  • Increased liability of producing payroll checks in house and tax filings
  • Requires large investment in capital expenditures and support

Summary of Key Points

An integrated HRMS solution will fulfill the needs and meet the requirements of Greyhound's customers with those customers being HR, Benefits, Payroll, Driver Operations (GCTC's Driver Management), and Safety (GCTC's Health & Safety).

Greyhound will move into the 21st Century with the capability and flexibility to adjust to the ever-changing business needs of the current and future Greyhound and its subsidiaries.

Confidential GDD 005176

Improvements to systems and processes will result in the benefit of reduced costs across every functional area in which the system is implemented.

With the current lack of vendor support and their associated costs, system maintenance costs will be incurred. But on the flip side, costs incurred currently for complying with government requirements will be eliminated as the vendor will be responsible for those.

Provide a means to entice, retain, and proactively manage Greyhound's most valuable asset, its employees, along with increasing overall employee morale and reducing turnover rates.

Integration of critical employees data into a single database will allow access to more accurate, up to the minute data for reporting purposes along with a higher level of confidence in employee data when making business decisions.

Confidential GDD 005177

Recommendation

The recommended solution presented in this Evaluation and Selection Project by the Project Team is Alternative 3 - Implement an Integrated HRMS system.

To meet the current and future business needs of Greyhound, current systems/data sources need to be combined to keep Greyhound financially competitive and help to retain our most valuable asset, our employees. Bringing together the numerous Greyhound systems/data sources into an integrated system will provide Greyhound with far reaching benefits well into the 21st Century.

To meet the data, reporting, and decision-making needs and requirements of our employees and management an integrated system is paramount in the areas of Human Resources, Payroll, Benefits, Driver Management, and Safety. Such a solution will provide for Greyhound (GLI, GCTC, and all subsidiaries) the ability to fulfill their customer's current, future needs and meet the current, future requirements related to those needs.

With an integrated system recommendation in hand, the Project Team performed further work and reached a recommendation on the preferred solution, Oracle HRMS. The details on reaching the preferred solution can be found in the next section, Software Vendor Selection and Recommendation.

Summary of Key Reasons for Recommendation

The key reasons for making this recommendation are:

Confidential GDD 005178

Five Year TCO Comparison

Table 11: Five Year TCO Comparison (000's)

  Alt#1

Status Quo

Alt #2

Band Aid

Alt #3

Purchase

Difference of

Alt #2 vs. Alt #3

Capital Expenditures:
  Human Resources 12.0 1,692.2 REDACTED REDACTED
  Payroll                - 388.9 REDACTED REDACTED
  Driver Management                - 866.5 REDACTED REDACTED
  Sub-Total Capital Expenditures 12.0 2,947.6 REDACTED REDACTED
 
Operating Expenses:
  Personnel (IT Support US only) 1,662.7 1,822.7 REDACTED REDACTED
  Software Maintenance - 723.3 REDACTED REDACTED
  Hardware Maintenance 7.5 185.6 REDACTED REDACTED
  Training    - 100.0 REDACTED REDACTED
  Payroll Outsourcing 3,387.2 3,387.2 REDACTED REDACTED
  Internal Check Printing -    - REDACTED REDACTED
  Other                -                -                -                -
  Sub-total Operating Expenses 5,057.4 6,227.8 REDACTED REDACTED
  5,069.4 9,175.4 9,072.0 (103.4)
  - 1%
  Avg. Number of Employees 15,609 15,609 15,609  
  Annual Cost per Employee $ 64.96 $ 117.57 $ 116.24 $ (1.32)
 
  NPV of Cost Only @ 12% (3,631) (7,161) (7,533) (372)
  NPV of Benefits @ 12% 0 2,027 3,256 1,229
 
  Total (3,631) (5,134) (4,277) 857

[a] HR package is lower in Alt #3 due to sharing of databases and tools with payroll system.
[b] Driver management is higher in Alt #3 due to the use of external consultants.
[c] Payroll outsourcing costs are eliminated in Year 3.
[d] Internal check printing costs are estimated at $0.15 per check plus capital expenditures.
These expenses will not equal the total Project GER since this comparison does not include the advanced software functions.

Key Points:

Confidential GDD 005179

A table comparing each alternative in terms of the project goals, financial considerations and key factors is provided below:

Probability that the alternative will best meets the need or requirement? Ranking

1 equals the lowest or worst

3 equals the highest or best alternative

  Remain Status Quo Modularize / Band Aid Purchase Integrated System
Probability Ranking of Alternative Meeting
Company Needs
1 2 3
       
Probability Ranking of Alternative Meeting
Customer Needs
1 2 3
Financial Considerations      
   Total Investment (in 000's):      
   Five year total cost of ownership 5,069 9,175 9,072
   Potential annual cost savings [a] 0 3,126 4,965
   NPV including benefits (3,631) (5,134) (4,277)
   ROI over 5 years @ 12% [b] N/A N/A -27%
Other Key Factors      
   Risk of implementing on-time within budget N/A 3 2
   Risk of technology obsolescence 1 2 3
   Effort required to train users N/A 3 2
   Effort required to support the system 1 2 3
   Opportunity to produce largest cost savings 1 2 3
[a] Alternative #2 only allows an estimated 70% of the cost savings when compared to Alternative #3. Alternative #3 also includes an additional $ 500K in savings in existing database support costs.
[b] Neither Alternative #1 or #2 offers any positive cash flow over the five years.

Confidential GDD 005180

Pros and Cons

Pros Cons
  • All employee data is containep in one database
  • Increased data integrity
  • Reduced costs of maintaining multiple databases/systems
  • Increased data access for viewing and reporting purposes
  • Increased opportunity to reduce operating costs through process improvements and removal of many manual processes
  • Eliminates outsourcing costs
  • Functionality to meet the current and future needs of Greyhound
  • Cannot be implemented in less than a 18 month timeframe
  • Does not eliminate the risk of implementation
  • Does not provide a positive ROI until 3-4 years after implementation
  • Increased liability of producing payroll checks in house and tax filings
  • Requires large investment in capital expenditures and support

Confidential GDD 005181

Software Selection and Recommendation

Introduction

In June of 2001, the Project Team was defined (Appendix 1 - Project Team) and began an in-depth process to evaluate Human Resource Management System (HRMS) software packages. An initial field of 22 prospective vendors was identified as potential partners based upon their abilities to possibly meet Greyhound's business needs. Using a basic set of criteria and research tools, 18 vendors were eliminated to obtain a more manageable number of vendors to evaluate.

Evaluation criteria used in this process were:

Research tools used in this process were:

Based on the information gathered, the team narrowed the list to four vendor candidates, Lawson, Oracle, PeopleSoft, and Ultimate Software. The first three were chosen based upon their ability to meet the basic high-level technical and business requirements of Greyhound and the Gartner Group's identification of them as market leaders. Ultimate Software was chosen as a candidate based upon their low cost and highly respected payroll module.

Gartner Group Magic Quadrant TM

The Gartner Group Magic QuadrantTM is one of the most respected and widely referenced industry tools when comparing HRMS systems. The Magic QuadrantTM reflects the trends affecting large enterprises as well as the issues of viability, functionality, technology, service, and support.

Confidential GDD 005182

Table 12: Gartner Group Magic Quadrant

Gartner Group Magic Quadrant[D]

"Vendors in this market provide consistently high support for core HRMS functionality, but will continue to be differentiated based on their ability to support the integration, collaboration, and specialization within and beyond their enterprise". -Gartner Group Advisory, 2001.

Note: Originally published Q4 2000 (most recent version at the time of our initial evaluation).

Overview of Evaluation Methodology

To assist in the evaluation, an outside consulting firm was engaged. The consulting firm and Project Team started the process with a formal written Request for Proposal (RFP) that stated Greyhound's product requirements, then allowed each vendor candidate to demonstrate their product at Greyhound offices in Dallas and Calgary. Both the RFP and on-site demonstrations were weighted and scored by the Project Team with the finished products being the:

Fit/Gap Analysis - an evaluation tool to determine "if" the software meets Greyhound's stated requirements

Vendor Score Card - an evaluation tool to determine "how" the software meets Greyhound's stated requirements

Confidential GDD 005183

Additionally, the Project Team conducted both reference checks and site visits to firms utilizing the products as well as continued their independent research. Lastly, the vendor candidates were asked to provide responses to a supplemental set of questions focused on addressing any remaining questions or issues. The results from this second round of interviews and questions were summarized in a document entitled "Vendor Functionality Follow Up Matrix" which is included in Appendix 6 - Vendor Functionality Follow Up Matrix. Each major portion of the evaluation process is discussed in the following sections

Request for Proposals

A Request for Proposal (RFP) was defined and developed by the Project Team and sent to the four vendor candidates. The RFP was composed of basic Greyhound project required documentation (cover letter, timeframes, document formats, communication protocol, Greyhound Agreement, etc.), narrative questions, technical questions, and the product requirements.

The Project Team developed the RFP components of narrative questions, technical questions, and product requirements. The defined requirements for each component were primarily gathered from Joint Application Development (JAD) sessions with the Project Team members or Subject Matter Experts (SMEs) for the functional areas involved.

Utilizing the product requirements, vendor candidates evaluated and scored themselves on their ability to meet Greyhound's business needs. The vendor candidates returned the completed RFPs to Greyhound.

Once the RFPs were returned, the vendor candidate's self-evaluations of the product requirement were reviewed in an attempt to eliminate vendor candidates from the process. Greyhound eliminated Ultimate Software from consideration based upon deficiencies in Canadian payroll module, garnishment module, number of large clients, and system architecture.

These product requirements, as defined and with the vendor candidate responses, became the basis for the scoring process of the vendors.

On-Site Demonstrations

On-site demonstrations were then scheduled with the three remaining vendor candidates at GLI and GCTC. This was done to provide the Project Team with one point of contact with the vendor candidates while minimizing the amount of time required attending the demonstrations. The primary objectives of the on-site demonstrations were to:

  • validate vendor candidate's product requirements self-evaluation
  • demonstrate software to the user community and solicit their feedback

Confidential GDD 005184

  • identify possible solution issues or concerns that could throw a red-flag
  • provide a consistent arena with which to compare and contrast the base products

Vendor Scripts

Each functional area, with GL and GCTC collaborating, developed the Vendor Scripts. The scripts contained a list of items to be addressed during the demonstration and were provided to the vendor candidates prior to the demonstration to assist in their presentation preparation. The departmental Team Leads were responsible for making sure their team understood the vendor candidate's solution to each script requirement.

The objectives of the Vendor Scripts were to:

  • provide the vendor candidate an idea of Greyhound's primary concerns
  • provide structure and ensure the vendor candidates focused on Greyhound's concerns and not "Bells & Whistles"
  • provide the Project Team a common tool to compare and contrast the products

The Project Team scored and ranked the vendor candidates based upon these on-site demonstrations through the Fit/Gap Analysis and Vendor Score Card tools.

Project Team Evaluation Results

Fit/Gap Analysis

Scoring and Weighting

The Project Team used a Greyhound defined method for scoring and weighting the results of the Fit/Gap Analysis. The specifics on the criteria and process used can be found in Appendix 8, Fit/Gap Analysis Criteria, Process, and Results.

Fit/Gap Scoring Results

The Project Team scored only their functional area with the exception of requirements in the reporting, general and security sections. GLI and GCTC individually scored their specific requirements along with those requirements relevant to their organization. The calculated weighted scores were totaled and brought together to produce a final vendor candidate Fit/Gap score. The final Fit/Gap scores were then used to compare and contrast vendor candidate products to determine which was a best fit for Greyhound.

Confidential GDD 005185

Following is a summary showing how the three vendors scored for All Requirements, The scores and rankings represent the calculated GLI and GCTC weighted scores combined with no averaging involved.

Table 13: Fit/Gap Analysis - All Requirements

Vendor Vendor Ranking Total Team Score Total Team Highest Possible Score Team Rating % (Team Total / Team Possible)
Oracle 1 12,140 12,267 98.96%
Lawson 2 11,900 12,252 97.13%
PeopleSoft 3 11,719 12,237 95.77%

The detailed score sheets of the Fit/Gap Analysis are contained in Appendix 8 - Fit/Gap Analysis Criteria, Process, and Results.

The overall results are very close between the vendors in this area with slightly greater than 3 percentage points separating first from last. This is expected as the HRMS software market is mature and the overall functionality of the major vendors is similar.

Vendor Score Card

The Vendor Score Card was an evaluation tool for scoring functionality covered in the Vendor Scripts. The Project Team scored each section under a functional area with a score ranging from 1 to 5, low to high respectively. The scores were based upon the evaluator's determination of "how" the software met Greyhound's requirements addressed during the vendor demonstration.

In addition to assigning a score, the Vendor Score Card contained areas for recording comments, strengths, and weaknesses with each section. A final section at the end of each functional area allowed for an "overall impression" score along with a summary of Pros and Cons.

After each team member evaluated and scored the product, the respective departments of GLI and GCTC met independently, discussed the results, and agreed on a company specific departmental team score.

Below is the composite Vendor Score Card for GLI and GCTC for the three vendor demonstrations conducted. To produce these composite scores, the company specific departmental scores were combined and averaged.

The Project Team feels the Vendor Score Card is the better tool as it evaluates "how" the software meets our requirements.

Confidential GDD 005186

Table 14: Vendor Score Cards

Category Oracle Lawson PeopleSoft
Overall Ranking 1 2 3
Overview [a] 27.25 26.00 24.00
Vendor Rapport [b] 5.00 4.50 3.00
Human Resources 39.75 33.00 31.00
Compensation 44.25 38.00 39.00
Driver Ops 23.00 21.25 21.75
Benefits 39.50 36.50 34.00
Reporting Tool/ WorkFlow/Security/ General 38.25 35.25 33.75
Technical 26.00 23.25 23.00
Payroll 121.75 111.00 109.00
Total Score 364.75 328.75 318.50
% of Total Possible 95.9% 86.5% 83.8%
[a] Scoring covered client list, key differentiators, financials, product strengths and weaknesses, and system overview.
 
[b] Scored on: vemfor provided timely and pertinent answers to questions, demo was well planned, people I can work with, etc.
 
The Project Team scored all other categories based upon functionality and/or requirements.

Overall, the f|nal project team grades were:

Oracle "A" (96%) Lawson "B" (87%)

Confidential GDD 005187

Key reasons for the scoring differences are:

Oracle's software is rated "materially" better in the following areas:

Business functionality

Confidential GDD 005188

Technical functionality

Lawson's software is rated "materially" better in only one area:

Business functionality

PeopleSoft Elimination

After the scoring was completed, PeopleSoft was eliminated from further consideration due to:

Confidential GDD 005189

Reference Checks and Site Visits

The Core Team composed a list of questions to address the objectives and facilitate the client reference interviews. The Core Team interviewed references provided by the vendor candidates in addition to those identified without the vendor candidate's knowledge. In total 5-6 references were checked for each vendor candidate.

Lawson client references check ed were Canadian Auto Association, Cross Mark, Dart, McDonalds, and Petroleum Helicopters. The clients for Oracle were Agilera, ATA, Club Corp, Gevity, Liberty Mutual, Mrs. Bairds, and Stone & Weston.

Project Team members also conducted site visits for each vendor candidate to clients selected and arranged through the vendor candidates. The visits consisted of one site visit per vendor cadidate. Dart was visited for Lawson and Club Corp for Oracle.

The scoring methodology used to provide the Project Team with reference relevance can be found in Appendix 9 - Reference Scoring Methodology along with the actual client reference sheet for each reference.

The reference checks provided a great deal of valuable information. Key information learned and gleaned from the reference checks is contained in the following synopsis.

Table 15: Reference Checks Information

Lawson Oracle

Confidential GDD 005190

Vendor Site Visits

Following the vendor candidate demonstrations, there were several questions regarding functionality that lingered with the Team. In order to answer these questions, the Team developed a matrix comprised of the strengths, weaknesses, and critical assumptions from the demonstrations as agreed to by the Core Team.

Sources for the matrix were:

After completing the matrix, it was sent to the respective vendor candidates for confirmation/rebuttal. Greyhound requested that the vendor candidates validate, clarify, and return the matrix within three days. The full matrix with the responses can be found in Appendix 6 - Vendor Functionality Follow up Matrix,

Following the return of the matrix, the Core Team requested visits to both Lawson and Oracle facilities. The purpose of the visits was to establish additional rapport, view the facilities, address any new issues or concerns, and address any additional inconsistencies found in the vendor candidate responses to the Vendor Functionality Follow Up Matrix.

After these additional vendor site visits, the Core Team felt very comfortable with its assessments and assumptions regarding the Vendor Functionality Follow Up Matrix for both vendor candidates and found their previous decisions confirmed.

Five Year Total Cost of Ownership

Key Assumptions:

Confidential GDD 005191

Confidential GDD 005192

Table 16: Five-year Cost of Ownership Comparison [b]

  Oracle Lawson Difference %
Capital Expenditures        
 
   Software Licenses REDACTED REDACTED REDACTED REDACTED
 
      Applications REDACTED REDACTED REDACTED REDACTED
 
      Tools REDACTED REDACTED REDACTED REDACTED
 
      Database REDACTED REDACTED REDACTED REDACTED
 
      Total REDACTED REDACTED REDACTED REDACTED

 
   System Hardware Equipment REDACTED REDACTED REDACTED REDACTED
 
   User PC's & Check Printers REDACTED REDACTED REDACTED REDACTED
 
   Self-Serve PC's REDACTED REDACTED REDACTED REDACTED
 
   External Consulting REDACTED REDACTED REDACTED REDACTED
 
   Internal Capitalization of Labor REDACTED REDACTED REDACTED REDACTED
 
   Taxes & Contingency REDACTED REDACTED REDACTED REDACTED
 
   Total Capital Expenditures REDACTED REDACTED REDACTED REDACTED

 
Operating Expenses        
 
   Software Maintenance REDACTED REDACTED REDACTED REDACTED
 
      Applications REDACTED REDACTED REDACTED REDACTED
 
      Tools REDACTED REDACTED REDACTED REDACTED
 
      Database REDACTED REDACTED REDACTED REDACTED
 
      Sub-Total REDACTED REDACTED REDACTED REDACTED

 
   IT Support Personnel [a] REDACTED REDACTED REDACTED REDACTED
 
   Training REDACTED REDACTED REDACTED REDACTED
 
   Hardware Maintenance (15%) REDACTED REDACTED REDACTED REDACTED
 
   Total Operating Expenses REDACTED REDACTED REDACTED REDACTED

 
   Total Project 7, REDACTED 7, REDACTED REDACTED REDACTED

 
   Average # of Employees (US and CDN) 15,609 15,609 REDACTED REDACTED
 
   Average Annual Cost per Employee $ REDACTED $ REDACTED REDACTED REDACTED
 
[a] Model assumes an additional .6 FTE allocation to replicate the synergies found in the Oracle HR/FIN system and support customization required in Lawson for Driver Management.
 
[b] Model does not include any Oracle savings for existing database support.

Confidential GDD 005193

Overall the TCO is very close between the vendor candidates and consistent with general industry observations. Thpse can be summarized as follows:

  • Lawson's software license and maintenance costs are lower than Oracle
  • Lawson's core implementation costs are lower than Oracle
  • Oracle requires less customization as it is designed to be easily configurable
  • Oracle's fully integrated system environment and the synergies with our existing financial application require lower IT support costs

Contracts

Contract Terms

The last major evaluation performed was a review of the contract terms, which govern the overall business relationship. Oracle has a fairly simple, standard agreement that they typically do not customize. The simplicity of the agreement allows Oracle the freedom to use business practices (primarily pricing issues) and support policies to heavily influence the on-going relationship with their customers. Historically, this has created conflicts in their customer relationships.

Over the past six months, Oracle has been more flexible in meeting Greyhound's contract concerns and provide amendments that address our past relationship issues related to length of product support and database licensing. As part of our discussions to date, Oracle has offered to reduce our on-going database license costs by $ 100,000 per year ($ 500,000 over five years) if we purchase their HR / payroll solution. This cost saving is not included in the TCO numbers above in order to provide a fair comparison.

Lawson provides a typical licensing and support agreement that is common in the industry. They seem willing to address our contractual requirements and have also addressed our product support concerns. It should be noted that at this point in time, we have not negotiated in earnest with Lawson.

While the key contract terms are very similar between the two vendor candidates, Lawson's contract is rated better. This is primarily due to the fact they warrant the "unmodified" product will operate according to its specifications provided the software is under a support agreement.

Contract Comparison

Table 17: Key Contractual Issues and Differences directly compares the key contract terms for Lawson and Oracle.

Confidential GDD 005194

Table 17: Key Contractual Issues and Differences

Key Contractual Issues and Differences Oracle Lawson
Is the vendor providing a perpetual use license? Yes Yes
Can Greyhound process data for third party entities? No No
Can our customers, vendors and other 3rd parties access the software? No No
Will the vendor guarantee product support for 5 years? (see noteworthy) Yes [a] Yes [b]
How long is the initial warranty period? 1 Year 1 Year
Does the vendor warrant software "will operate according to it specifications" while under a maintenance agreement? No Yes
Does the vendor indemnify Greyhound for copyright infringement? Yes Yes
What is Greyhound's final remedy if the software does not work according to the vendor's specifications? Refund of license and support fees Full refund if claim made within 1 year

Noteworthy:

[a] Oracle submitted an Amendment guaranteeing to provide technical support for their 11I HRMS svstem for 5 years and cap the increase of support fees at 5% per year after Year 3.

[b] Lawson submitted a proposal guaranteeing to provide technical support for the products implemented by Greyhound for 5 years.

GLI software usage is subject to terms contained in the program documentation

Technical support policies are vague and subject to change at any time by Oracle

Lawson warrants the products will operate "materially and substantially" as described in the product documentation so long as the product is not modified and under a support agreement.
Overall Opinion on Software License
Note: Overall opinion based on the standard contracts of all vendors.
OK BETTER

Confidential GDD 005195

Other Considerations

Gartner Group Analysis of Strengths and Limitations

  Oracle Lawson
Strengths Integrated product line

Global focus

Content delivery

Rules based engine (workflow)

Functionality for small to mid-sized enterprises

Recruitment support

Analytics

Architecture

Limitations Limited recruitment support

No pension management functions

0racle database required

Gaps in product line

Small company relative to competition

Overall Summary "Comprehensive solution satisfying the tactical, transaction-based requirements of multi-national companies" "Small to mid-sized companies will find the cost of Lawson HR and the functionality of the product to be worthy of their consideration when evaluating HR software systems for implementation."

Market Focus and Implementations

The following table, Table 18: Current Version Implementation Statistics shows detailed information for Lawson and Oracle. Due to the fact the company size has a major part in these numbers, it must also be noted that Lawson is a "niche" market vendor with approximately 75% of their clients being in the Health Care Industry. Oracle on the other hand is a huge corporation with the majority of their business clients being the manufacturing arena.

Confidential GDD 005196

Table 18: Current Version Implementation Statistics (as of 11/19/01)

Statistical Area Lawson 8.x Oracle 11i.x
All Clients Live 18 920
HRMS Clients Live 9 84
HRMS Clients Paying Canadians 1 4
US References Checked 5 6
Canadian References Checked 1 1
Clients Currently Implementing 40 4000+

Financial Comparison Matrix

Each of the vendor candidates was also analyzed to assess their financial stability. The information was gathered from company financial reports, investment web sites, and Dunn and Bradstreet research. A summary of the findings follows, Table 19: Financial Comparison Matrix, with detail documents found in Appendix 11 - Vendor Financial Comparison.

Confidential GDD 005197

Table 19: Financial Comparison Matrix

  ORACLE LAWSON [b] Industry
Average
[a]
 
Current Last
Year [c]
Current Last
Year
Notes
Company Snapshot Annual Revenue
(Million's)
10,500   380      
Market Capitalization
(Billion's)
92.9   1.5    
Number of Employees 42,927   2,150    
Revenue / Employee
(Thousands)
244.6   176.7   280.0 Indicator of Management Efficiency
Stock Value Ratios Price Earnings Ratio 38.6 N/A 89.6 N/A 51.5 Higher ratios are an indicator that the stock market places a premium on the company's overall value to investors
Price/ Sales 7.9 20.0 3.5 3.6 9.1
Price/ Book 13.7 31.3 43.8 (31.1) 7.2
Profit Ratios Gross Margin (%) 78% 75% 63% 62% 82% Higher percentages are an indicator of the company's historic profitability
Net Profit Margin (%) 24% 20% 4% -1% 3%
Return on Equity (%) 41% 31% 7% 2% 7%
Return on Assets (%) 23% 15% 4% -2% 4%
Debt Ratios Debt/ Equity 0.05 0.05 0.75 (1.11) 0.07 Total Debt / Total Equity
Lower numbers are better
Negative numbers are bad
Leverage Ratio 1.8 2.0 1.7 (1.3) 1.5 Total Assets / Total Debt
Higher numbers are better
Negative numbers are bad
Current Ratio 2.0 1.9 2.3 1.0 2.7 Current Assets / Current Liabilities

Higher numbers are better

D&B Research Financial Stress
(Likelihood company will go bankrupt)
1 or less than 0.37% 2 or less than 1.62% N/A 1 is Lowest Risk

5 is Highest Risk

Credit Score (Likelihood
company will pay 90+ days past due)
5 5 N/A 1 is Lowest Risk

5 is Highest Risk

OVERALL RANKING BEST GOOD    

Notes: Current year computed Ratios are based on the latest 12 months results (Source MSN.com)

  [a] S&P 500 Industry averages were substituted for P/E Ratio and Return on Equity (%) since the Industry typically experiences negative profits
[b] Lawson Current Year results based on pro forma adjusted balance sheets found in their IPO prospectus. The company had negative equity in the previous year
[c] Oracle net profit does not include $ 6.9B in gains related to Marketable Securities.

Confidential GDD 005198

Oracle's financial statements were graded the best of the group primarily based on their high profit ratios and low debt ratios.

Lawson's financial ratios are considered good, however prior year results are a concern, and Lawson has a louver overall profit ratio.

Technical Environment

Diagrams 9 and 10 depict the "new" system environments with an integrated HRMS system for both Lawson and Oracle. The differences are apparent in that Lawson requires additional databases and interfaces that are depicted in gray at the bottom of Diagram 9.

Confidential GDD 005199

Diagram 9: Lawson HRMS Systems Structure

Lawson HRMS Systems Structure[D]

Confidential 005200

Diagram 10: Oracle HRMS Systems Structure

Oracle HRMS Systems Structure[D]

Confidential 005201

Recommendation

It is the recommendation of this Project Team to choose Oracle's suite of HRMS products for implementation at Greyhound. Their products meet, with few exceptions, the requirements for the current and future business needs of Greyhound Lines, Greyhound Canada, and any current subsidiary and future acquisition. Following are the Key Reasons upon which this recommendation was based.

Key Reasons for Recommendation

Functionality Reasons

Confidential GDD 005202

Approval Proxy provides two key advantages/benefits:

This can be done by defining how long the task sits before 1) a reminder notice is sent to the approver, 2) a notice is sent to all other parties involved, and/or 3) the task is escalated to the next approver or person in line.

These two items alone would reduce quick checks, upset employees, and allow District Managers to identify the weak links in their chain.

 

Updated January 12, 2023