Explanation
1. BACKGROUND: This legislation authorizes the Director of Public Utilities to enter into an agreement with Brown & Caldwell Ohio, LLC in the amount of $348,000.00, for Enterprise Application Integration (EAI).
The Department of Public Utilities (DPU) currently supports a wide variety of electronic business support systems each serving customers throughout the divisions. Many of these programs have overlapping data, users, technical criteria, and purposes. The desired Enterprise Application Integration will identify the most effective approach to leverage existing systems which, along with potential new investment, will help DPU achieve an optimal level of operational efficiency and will provide a data management environment that will foster the development of new and innovative tools for business analysis and management.
2. MULTI-PHASE AGREEMENT: This work may be divided into two phases. The first phase shall include the study and recommendations for the EAI. The second phase shall implement the EAI. On approval of the DPU Steering Committee, and based on associated costs, the consultant may be authorized to implement selected instances of Enterprise Application Integration. EAI implementation authorized in Phase II shall be based on work completed and accepted in Phase I unless exceptions are approved by the Steering Committee. Phase II may be implemented either in whole, in selected instances or not implemented at the discretion of the Steering Committee
3. BID INFORMATION: The selection of the firm providing the system has been performed in accordance with the procedures set forth in Columbus City Code, Section 329.14, "Awarding professional service contracts through requests for proposals". The evaluation criteria for this contract included: 1. proposal quality, 2. proposal feasibility, 3. experience of team, 4. past performance, and 5. local workforce.
Requests for Proposals (RFP's) were received on June 1, 2009 from Brown & Caldwell Ohio, LLC, Woolpert Inc., EMA Services, Inc., Crowe Horwath LLP, Sogeti USA LLC, Perficient, Inc., and CareWorks Technologies.
Brown & Caldwell Ohio, LLC was the firm selected to perform the Enterprise Application Integration. Their Contract Compliance Number is 94-1446346 (expires 6/11/10, Majority). Additional information regarding each firm, description of work, contract time frame and detailed amounts can be found on the attached Legislation Information Form.
4. FISCAL IMPACT: Funds for this project are available within the Water Build America Bonds (B.A.B.s) Fund, the Sanitary Build America Bonds (B.A.B.s) Fund, the Stormwater Build America Bonds (B.A.B.s) Fund, and the Voted Street Lighting and Electricity Distribution Improvement Fund. An amendment to the 2009 Capital Improvements Budget is also necessary.
Title
To authorize the Director of Public Utilities to enter into an agreement with Brown & Caldwell Ohio, LLC for an Enterprise Application Integration (EAI) for the Department of Public Utilities; to authorize the transfer of funds within the Sanitary Build America Bonds (B.A.B.s) Fund, the Stormwater Build America Bonds (B.A.B.s) Fund, and the Voted Street Lighting and Electricity Distribution Improvement Fund; to authorize the expenditures of $135,024.00 from the Water Build America Bonds Fund (B.A.B.s), $151,380.00 from the Sanitary Build America Bonds (B.A.B.s) Fund, $40,368.00 from the Stormwater Build America Bonds (B.A.B.s) Fund, and $21,228.00 from the Voted Street Lighting and Electricity Distribution Improvement Fund; and to amend the 2009 Capital Improvements Budget. ($348,000.00)
Body
WHEREAS, seven proposals for an Enterprise Application Integration (EAI) were received on June 1, 2009; and
WHEREAS, Brown & Caldwell Ohio, LLC was the firm selected for this project, based on criteria set forth in Columbus City Codes; and
WHEREAS, the purpose of the Enterprise Application Integration is to identify the most effective approach to leverage existing systems in order to achieve an optimal level of operational efficiency and to provide a data management environment that will foster the development of new and innovative tools for business analysis and management; and
WHEREAS, it is necessary to authorize the transfer within funds within the Sanitary Build America Bonds (B.A.B.s) Fund, the Stormwater Build America Bonds (B.A.B.s) Fund, and the Voted Street Lighting and Electricity Distribution Improvement Fund, for purposes of providing sufficient funding for the aforementioned project expenditures; and
WHEREAS, it is necessary for City Council to authorize the expenditure of funds from the Water Build America Bonds (B.A.B.s) Fund, Sanitary Build America Bonds (B.A.B.s) Fund, the Stormwater Build America Bonds (B.A.B.s) Fund, and the Voted Street Lighting and Electricity Distribution Improvement Fund; and
WHEREAS, it is necessary to authorize an amendment to the 2009 Capital Improvements Budget for the purpose of providing sufficient spending authority for the aforementioned project expenditures; and
WHEREAS, it has become necessary in the usual daily operation of the Department of Public Utilities, to authorize the Director of Public Utilities to enter into an agreement for the Enterprise Application Integration (EAI) Project, for the preservation of the public health, peace, property and safety;
BE IT ORDAINED BY THE COUNCIL OF THE CITY OF COLUMBUS:
SECTION 1. That the Director of Public Utilities be and hereby is authorized to enter into an agreement for an Enterprise Application Integration (EAI) with Brown & Caldwell Ohio, LLC, 4700 Lakehurst Court, Suite 100, Dublin, Ohio 43016; in the amount of $348,000.00; in accordance with the terms and conditions of the contract on file in the offices of the Divisions of Power and Water and Sewerage and Drainage.
SECTION 2. That the City Auditor is hereby authorized to transfer $151,380.00 within the Department of Public Utilities, Division of Sewerage and Drainage, Dept/Div. No. 60-05, Sewerage and Drainage Sanitary Build America Bonds (B.A.B.s) Fund, Fund No. 668, as follows:
Project No. | Project Name | OCA Code | Change
650348-100002 | WWTFS Instrumentation & Control System Upgrade | 652348 | -$151,380.00
650729-100000 | Enterprise Application Integration (EAI) | 650729 | +$151,380.00
SECTION 3. That the City Auditor is hereby authorized to transfer $40,368.00 within the Department of Public Utilities, Division of Sewerage and Drainage, Stormwater Section, Dept/Div. No. 60-15, Stormwater Build America Bonds (B.A.B.s) Fund, Fund No. 676, as follows:
Project No. | Project Name | OCA Code | Change
610775-100000 | Evergreen & Dewberry SSI's | 685775 | -$40,368.00
611018-100000 | Technology Services | 676018 | +$40,368.00
SECTION 4. That the City Auditor is hereby authorized to transfer $21,228.00 within the Department of Public Utilities, Division of Power and Water (Power), Dept/Div. No. 60-07, Voted Street Lighting and Electricity Distribution Improvement Fund, Fund No. 553, as follows:
Project No. | Project Name | OCA Code | Change
670608-100000 | Distribution System Imp's | 670608 | -$21,228.00
670638-100000 | Computer Services | 670638 | +$21,228.00
SECTION 5. That the 2009 Capital Improvements Budget Ordinance No. 0806-2009 is hereby amended as follows:
Fund No. | Proj. No. | Proj. Name | Current Authority | Revised Authority | Change
668 | 650348-100002 | WWTFS Instrumentation & Control System Upgrade | $6,520,362 | $6,368,982 | -$151,380
668 | 650729-100000 | Enterprise Application Integration (EAI) Project | $0 | $151,380 | +$151,380
SECTION 6. That the 2009 Capital Improvements Budget Ordinance No. 0806-2009 is hereby amended as follows:
Fund No. | Proj. No. | Proj. Name | Current Authority | Revised Authority | Change
676 | 610775-100000 | Evergreen & Dewberry SSI's | $950,000 | $909,632 | -$40,368
676 | 611018-100000 | Technology Services | $0 | $40,368 | +$40,368
SECTION 7. That the 2009 Capital Improvements Budget Ordinance No. 0806-2009 is hereby amended as follows:
Fund No. | Proj. No. | Proj. Name | Current Authority | Revised Authority | Change
553 | 670608-100000 | Distribution System Imp's | $28,600 | $7,372 | -$21,228
553 | 670638-100000 | Computer Services | $0 | $21,228 | +$21,228
SECTION 8. That for the purpose of paying the cost of the Enterprise Application Integration (EAI) or as much thereof as may be needed, by and the same, is hereby authorized as follows: Division of Power and Water (Water) | Div. No. 60-09 | Water Build America Bonds Fund | Fund No. 609 | Project 690485-100000 (new funding) | OCA 609485 | Object Level One 06 | Object Level Three 6655 | Amount $135,024.00.
SECTION 9. That for the purpose of paying the cost of the Enterprise Application Integration (EAI) or as much thereof as may be needed, by and the same, is hereby authorized as follows: Division of Sewerage and Drainage | Div. No. 60-05 | Sanitary Build America Bonds (B.A.B.s) Fund | Fund No. 668 | Project 650729-100000 | OCA 650729 | Object Level One 06 | Object Level Three 6655 | Amount $151,380.00
SECTION 10. That for the purpose of paying the cost of the Enterprise Application Integration (EAI) or as much thereof as may be needed, by and the same, is hereby authorized as follows: Division of Sewerage and Drainage (Stormwater) | Div. No. 60-15 | Stormwater Build America Bonds (B.A.B.s) Fund | Fund No. 676 | Project 611018-100000 | OCA 676018 | Object Level One 06 | Object Level Three 6655 | Amount $40,368.00.
SECTION 11. That for the purpose of paying the cost of the Enterprise Application Integration (EAI) or as much thereof as may be needed, by and the same, is hereby authorized as follows: Division of Power and Water (Power) | Div. No. 60-07 | Voted Street Lighting and Electricity Distribution Improvement Fund | Fund No. 553 | Project 670638-100000 | OCA 670638 | Object Level One 06 | Object Level Three 6655 | Amount $21,228.00.
SECTION 12. That the City Auditor is authorized to make any accounting changes to revise the funding source for all contracts or contract modifications associated with this Ordinance.
SECTION 13. That the City Auditor is hereby authorized and directed to transfer any unencumbered balance in the project account to the unallocated balance within the same fund upon receipt of certification by the Director of the Department administering said project that the project has been completed and the monies no longer required for said project; except that no transfer shall be made from a project account by monies from more than one source.
SECTION 14. That the City Auditor is authorized to establish proper project accounting numbers as appropriate.
SECTION 15. That this Ordinance shall take effect and be in force from and after the earliest period allowed by law.