Explanation
1. BACKGROUND: This ordinance authorizes the Director of Public Utilities to modify and increase the Enterprise Application Integration (EAI) agreement with Brown & Caldwell Ohio, LLC, in the amount of $466,014.00, for the Division of Power and Water.
The Department of Public Utilities (DPU) entered into contract with Brown and Caldwell in May 2010 to determine the Department's level of readiness for an Enterprise Application Integration (EAI) solution. The objective of the project was to look at options that allow software systems to share information to improve access to business data. DPU's goal was to evaluate options for pulling together the essential data DPU staff needed to perform their jobs. Brown and Caldwell Team has been researching and reporting the use of data and information systems and how employees use those systems to support the key business processes. It was determined that the Department of Public Utilities level of readiness is low to moderate due to lack of data consolidation, repetition and cohesive organization.
This modification (No. 1) is to begin to implement improvements of readiness, improve chances of successful EAI implementation, and lower risked associated with lack of data control and organization. The Brown and Caldwell Team will assist DPU in developing a Business Intelligence System (BIS) Pilot. The scope of work will include requirements gathering, prototype development, refinement and deployment of a BIS Pilot as well as assisting in software selection. The BIS Pilot will also include documentation of the system functional requirements in a Software Requirements Specification (SRS). The SRS will include a conceptual database structure and functional requirements of the BIS.
1.1 Amount of additional funds to be expended: $466,014.00
Original Contract Amount: $347,999.58
Modification 1 (current) $466,014.00
Total (Orig. + Mod. 1) $814,013.58
1.2. Reasons additional goods/services could not be foreseen:
This was a planned contract modification identified in the original contracting legislation, Ordinance No. 0138-2010.
1.3. Reason other procurement processes are not used:
This was a planned contract modification identified in the original contracting legislation. The Brown and Caldwell Team is familiar with the project and will provide continuity in completion of the agreement in the best interests of the City.
1.4. How cost of modification was determined:
Costs were submitted by the Consultant and reviewed and verified by the City Project Manager.
2. CONTRACT COMPLIANCE INFO: 94-1446346, expires 6/28/12, Majority
Searches in the Excluded Party List System (Federal) and the Findings for Recovery list (State) produced no findings against Brown & Caldwell Ohio, LLC.
3. 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, Fund 668, the Stormwater Build America Bonds (B.A.B.s) Fund, and the Electric Build America Bonds (B.A.B.s) Fund. An amendment to the 2011 Capital Improvements Budget is also necessary.
Title
To authorize the Director of Public Utilities to modify and increase the Enterprise Application Integration (EAI) agreement with Brown & Caldwell Ohio, LLC in the amount of $466,014.00; to authorize transfers and expenditures within the Water Build America Bonds Fund, the Sanitary Build America BondsFund, the Stormwater Build America Bonds Fund, and the Electric Build America Bonds Fund; and to amend the 2011 Capital Improvements Budget. ($466,014.00)
Body
WHEREAS, Contract No. EL010294 was authorized by Ordinance No. 0138-2010, passed March 1, 2010, was executed on April 23, 2010, and was approved by the City Attorney on May 3, 2010; 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, Modification No. 1 is needed to improve DPU's level of readiness, improve chances of successful EAI implementation, and lower risked associated with lack of data control and organization; and
WHEREAS, it is necessary for this Council to authorize the City Auditor to transfer and expend funds within the Water Build America Bonds Fund, the Sanitary Build America Bonds (B.A.B.s) Fund, the Stormwater Build America Bonds (B.A.B.s) Fund, and the Electric Build America Bonds (B.A.B.s) Fund; and
WHEREAS, it is necessary to authorize an amendment to the 2011 Capital Improvements Budget for purposes of providing sufficient funding and expenditure authority for the aforementioned project expenditures; and
WHEREAS, it has become necessary in the usual daily operation of the Department of Public Utilities, Division of Power and Water, to authorize the Director of Public Utilities to modify and increase the Enterprise Application Integration (EAI) agreement with Brown & Caldwell Ohio, LLC, for the preservation of the public health, peace, property, safety and welfare; now, therefore,
BE IT ORDAINED BY THE COUNCIL OF THE CITY OF COLUMBUS:
SECTION 1. That the Director of Public Utilities is hereby authorized and directed to modify and increase the Enterprise Application Integration (EAI) agreement with Brown & Caldwell Ohio, LLC, for the in the amount of $466,014.00.
SECTION 2. That this contract modification is in compliance with Section 329.16 of Columbus City Codes, 1959.
SECTION 3. That the City Auditor is hereby authorized to transfer $180,813.43 within the Division of Power and Water, Dept/Div. No. 60-09, Water Build America Bonds Fund, Fund No. 609, as follows:
Fund No. | Project No. | Project Name | OCA Code | change
609 | 690365-100000 (carryover) | Sullivant Ave. W.L. Cleaning | 693650 | -$180,813.43
609 | 690485-100000 (carryover) | Technology Resources | 609485 | +$180,813.43
SECTION 4. That the City Auditor is hereby authorized to transfer $202,716.09 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, Object Level Three 6655, as follows:
Project No. | Project Name | OCA Code | Change
From: 668999-100000 | Unallocated Balance | 668999 | -$202,716.09
To: 650729-100000 | Enterprise Application Integration (EAI) | 650729 | +$202,716.09
SECTION 5. That the City Auditor is hereby authorized and directed to appropriate the following funds: Division: Sewerage and Drainage | Div. No. 60-05 | Fund Name: Sanitary Sewer Build America Bond (B.A.B.'s) Fund | Fund No. 668 | Object Level Three 6655
Project No. Project Name OCA Amount
668999-100000 Unallocated Balance 668999 $202,716.09
SECTION 6. That the City Auditor is hereby authorized to transfer $54,057.62 within the Department of Public Utilities, Division of Sewerage and Drainage, Dept/Div. No. 60-15, Storm Build America Bond (B.A.B.'s) Fund, Fund No. 676, as follows:
Project No. | Project Name | OCA Code | Change
610990-100002 | Seventeenth Avenue Imp. | 698902 | -$54,057.62
610018-100000 | Technology Services | 676018 | +$54,057.62
SECTION 7. That the City Auditor is hereby authorized to transfer $28,426.86 within the Department of Public Utilities, Division of Power and Water (Power), Dept/Div. No. 60-07, Electric Build America Bond (B.A.B.'s) Fund, Fund No. 559, as follows:
Project No. | Project Name | OCA Code | Change
670790-100000 | Front Street | 559790 | -$28,426.86
670639-100000 | Technology Services | 559639 | +$28,426.86
SECTION 8. That the 2011 Capital Improvements Budget is hereby amended as follows:
Fund No. | Proj. No. | Proj. Name | Current Authority | Revised Authority | Change
609 | 690365-100000 (carryover) | Sullivant Ave. W.L. Cleaning | $860,438 | $679,624 | -$180,814
609 | 690485-100000 (carryover) | Technology Resources | $0 | $180,814 | +$180,814
668 | 668999-100000 | Unallocated Balance | $553,002 | $350,286 | -$202,717
668 | 650729-100000 | Enterprise Application Integration | $0 | $202,717 | +$202,717
676 | 610990-100002 | Seventeenth Avenue Imp. | $81,593 | $27,535 | -$54,058
676 | 611018-100000 | Technology Services | $0 | $54,058 | +$54,058
559 | 670790-100000 | Front Street | $186,890 | $158,463 | -$28,427
559 | 670639-100000 | Technology Services | $0 | $28,427 | +$28,427
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 Power and Water (Water) | Div. No. 60-09 | Water Build America Bonds Fund | Fund No. 609 | Project 690485-100000 (carryover) | OCA 609485 | Object Level One 06 | Object Level Three 6655 | Amount $180,813.43.
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 | 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 $202,716.09
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 Sewerage and Drainage (Stormwater) | Div. No. 60-15 | Storm 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 $54,057.62.
SECTION 12. 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 | Electric Build America Bonds (B.A.B.s) Fund | Fund No. 559 | Project 670639-100000 | OCA 559639| Object Level One 06 | Object Level Three 6655 | Amount $28,426.86.
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 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 16. That this Ordinance shall take effect and be in force from and after the earliest period allowed by law.