File #: 18-125    Name: ERP Consultant
Type: Resolution Status: Approved
In control: City Council Regular Meeting
On agenda: 2/6/2018 Final action: 2/6/2018
Title: Consider/Discuss/Act on a Resolution Authorizing the City Manager to Execute a Contract in the Amount of $85,200 with Berry Dunn, McNeil and Parker, LLC for a Contract Award for an Enterprise Resource Planning (ERP) RFP Specifications Development, Distribution, Evaluation and Award of an ERP Application Vendor and Authorizes all Necessary Change Orders Under Said Contract to an Aggregated Contract Amount Not to Exceed $97,980
Attachments: 1. Resolution

Title

Consider/Discuss/Act on a Resolution Authorizing the City Manager to Execute a Contract in the Amount of $85,200 with Berry Dunn, McNeil and Parker, LLC for a Contract Award for an Enterprise Resource Planning (ERP) RFP Specifications Development, Distribution, Evaluation and Award of an ERP Application Vendor and Authorizes all Necessary Change Orders Under Said Contract to an Aggregated Contract Amount Not to Exceed $97,980

 

Summary

 

COUNCIL GOAL:                     Operational Excellence

 

MEETING DATE:                     February 6, 2018

 

DEPARTMENT:                      Information Technology

 

CONTACT:                       Sid Hudson, Chief Information Officer

 

 

RECOMMENDED CITY COUNCIL ACTION:                     

                     Approval of Resolution

 

ITEM SUMMARY: 

                     This Resolution authorizes a contract award with Berry Dunn, McNeil and Parker, LLC for development of Enterprise Resource Planning (ERP) Request for Proposals regarding specifications development, distribution, evaluation and award of an ERP Application vendor.

 

BACKGROUND INFORMATION:

                     The City of McKinney’s current ERP system is Superion NaviLine, operating on an IBM iSeries platform.  This ERP system has been in place since 1995 and includes modules that focus on core financial transactions (general ledger, accounts payable, accounts receivable, utility billing, and payroll) as well as a few modules that focus on operation systems (human resources, business license, permits, work orders).  The integration of these modules are a great strength of this system, however its inability to integrate with external databases and accommodate a more mobile and e-government environment are weaknesses of the system.  Due to the limitations of the system, City departments have looked to develop alternatives.  Departments have turned to independent software applications (over 10 in total) that are not integrated with the core application as departmental operating processes and procedures have changed during the past 20 years, in keeping up with technology and customer demands.

 

                     Additional Superion modules in use include: Cash Receipts, Fixed Assets, GMBA (General Ledger, Accounts Payable, Budget, and Procurement Card), Accounts Receivable, Payroll, Purchasing/Inventory, Business Licenses, Building Permits, Code Enforcement, Work Orders, Court, Utility (water/sewer) Billing.

                     The City had ten (10) respondents to our RFP of which we short listed three (3) consulting firms.  Interviews were conducted by a committee that was selected from a variety of departments within the organization covering I.T., Finance, Utility Billing, Public Works, Purchasing and the City Managers Office. After the interviews were complete and scoring was tabulated, Berry Dunn was the top selection of all committee members.

                     It is anticipated that this contract will be Phase I of a two Phase process.  Upon selection of an ERP system, it is likely that staff will be recommending a consultant firm to assist the City with the Multi-Year implementation process.

 

FINANCIAL SUMMARY: 

                     This Resolution authorizes a contract with Berry Dunn, McNeil and Parker, LLC for an amount not to exceed $97,980.

 

                     Funding for this project is available in the Technology Improvement Fund budget, project IT1007-ERP Implementation.

 

BOARD OR COMMISSION RECOMMENDATION:

                     N/A