Explanation
BACKGROUND: In 1994, the Department of Public Utilities initiated a contract (CT-15918) for software and services related to the Water and Sewer Information Management System (WASIMS) with SCT Utility Systems. Section 12 of the original contract provided for modifications and changes in scope of service. SCT Utility Systems later changed their name to Indus Utility Systems, then to its current name Ventyx, Inc. These changes were approved through previous ordinances.
The WASIMS system now referred to as CUBS (Columbus Utility Billing System) is the billing system utilized by the Department of Public Utilities for customer billing for Water, Sewers and Power. Previously the system did not bill for Power customers.
This legislation authorizes the Department of Public Utilities to modify and increase the agreement with Ventyx, Inc, in the amount of $80,000.00, for the following services:
1). Modify delinquency process $ 5,000.00
2). Archive/Purge Functionality $60,000.00
3). CORE Upgrade and server space for payment files $10,000.00
4). Additional software modifications $ 5,000.00
$80,000.00
1. Amount of additional funds to be expended: $80,000.00
Original Contract Amount: $1,186,330.00
Amount of original contract and 21 modifications: $8,959,577.38
2. Reasons additional goods/services could not be foreseen:
With the addition of the Power accounts the Department of Public Utilities forsaw the need for the system upgrade. Upgrading the current version should reduce costs operationally and include modifications needed to the system.
3. Reason other procurement processes are not used:
It is not feasible to bid for an alternate service since Ventyx, Inc. developed the software for the CUBS System. The company has developed other modifications to the software and are familiar with those upgrades.
4. How cost of modification was determined:
The Department of Public Utilities received a quote from Ventyx, Inc. and was deemed appropriate.
EMERGENCY: The modifications to the system include upgrades of the delinquency process and emergency action is requested to avoid the Department of Public Utilities facing uncollectible receivables without the modification to the delinquency process.
CONTRACT COMPLIANCE: Ventyx Inc 94-3273443, expires 6/30/10, majority
FISCAL IMPACT: Funds for this project are available within the Water Works Enlargement Voted Bonds 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 Electricity G.O. Bonds Fund. An amendment to the 2010 Capital Improvements Budget is also necessary. This project was not budgeted in the Division of Power and Water's operating budget for 2010; however, expenditures will be reprioritized to accommodate this expenditure without increasing the existing budget.
Title
To authorize the Director of the Department of Public Utilities to modify and increase the agreement with Ventyx, Inc., for modifications to the Columbus Utility Billing System (CUBS) for the Division of Power and Water, to authorize the transfer of funds within the Water Works Enlargement Voted Bonds Fund, the Sanitary Build America Bonds (B.A.B.s) Fund, the Stormwater Build America Bonds (B.A.B.s) Fund, and the Electricity G.O. Bonds Fund; to authorize the expenditures of $31,040.00 from the Water Works Enlargement Voted Bonds Fund, $34,800.00 from the Sanitary Build America Bonds (B.A.B.s) Fund, $9,280.00 from the Stormwater Build America Bonds (B.A.B.s) Fund, and $4,880.00 from the Electricity G.O. Bonds Fund; and to amend the 2010 Capital Improvements Budget and to authorize the expenditure of $80,000.00 from Water Systems Operating Fund, and to declare an emergency. ($80,000.00)
Body
WHEREAS, SCT Utility Systems, Inc., currently known as Ventyx, Inc. and the Department of Public Utilities executed contract CT-15918 in 1994 under Ordinance 1996-94 software and services related to the Water and Sewer Information Management System (WASIMS); and
WHEREAS, the WASIMS system is now referred to as CUBS (Columbus Utility Billing System), as a result of adding accounts from the Power section; and
WHEREAS, the Department of Public Utilities needs to modify and increase the agreement with Ventyx, Inc. for upgrades to the system; and
WHEREAS, it is necessary to authorize the transfer within funds within the Water Works Enlargement Voted Bonds Fund, the Sanitary Build America Bonds (B.A.B.s) Fund, the Stormwater Build America Bonds (B.A.B.s) Fund, and the Electricity G.O. Bonds 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 Works Enlargement Voted Bonds Fund, the Sanitary Build America Bonds (B.A.B.s) Fund, the Stormwater Build America Bonds (B.A.B.s) Fund, and the Electricity G.O. Bonds Fund; and
WHEREAS, it is necessary to authorize an amendment to the 2010 Capital Improvements Budget for the purpose of providing sufficient spending authority for the aforementioned project expenditures; and
WHEREAS, an emergency exists in the usual daily operation of the Department of Public Utilities, in that it is immediately necessary to authorize the Public Utilities Director to modify and increase an agreement with Ventyx, Inc. for upgrades to the Columbus Utility Billing System (CUBS), in an emergency manner in order to reduce the amount of uncollectible receivables, for the immediate 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 Public Utilities Director be and hereby is authorized to modify and increase the agreement with Ventyx, Inc. for upgrades to the Columbus Utility Billing System (CUBS), in the amount of $80,000.00.
SECTION 2. That the City Auditor is hereby authorized to transfer $31,040.00 within the Division of Power and Water, Dept/Div. No. 60-09, Water Works Enlargement Voted Bonds Fund, Fund No. 606, Object Level One 06, Object Level Three 6655, as follows:
Fund No. | Project No. | Project Name | OCA Code | change
606 | 690331-100000 (carryover) | HCWP Lagoons Sludge Rmvl. | 606331 | -$31,040
606 | 690374-100000 (carryover) | WASIMS | 642900 | +$31,040
SECTION 3. That the City Auditor is hereby authorized to transfer $34,800.00 within the Division of Sewerage and Drainage, Dept/Div. No. 60-05, Sanitary Build America Bonds (B.A.B.s) Fund, Fund No. 668, Object Level One 06, Object Level Three 6655, as follows:
Project No. | Project Name | OCA Code | Change
650100-100000 | Sanitary Sewer Contingency (Carryover) | 668100 | -$34,800.00
650729-100000 | Technology Resources (EAI) | 650729 | +$34,800.00
SECTION 4. That the City Auditor is hereby authorized to transfer $9,280.00 within the Division of Sewerage and Drainage, Stormwater Section, Dept/Div. No. 60-15, Stormwater Build America Bonds (B.A.B.s) Fund, Fund No. 676, Object Level One 06, Object Level Three 6655, as follows:
Project No. | Project Name | OCA Code | Change
676 | 610796-100000 (carryover) | River South Roadway Imp. | 676796 | -$9,280.00
676 | 611018-100000 (carryover) | Computer Services | 676018 | +$9,280.00
SECTION 5. That the City Auditor is hereby authorized to transfer $4,880.00 within the Division of Power and Water (Power), Dept/Div. No. 60-07, Electricity G.O. Bonds Fund, Fund No. 553, Object Level One 06, Object Level Three 6655, as follows:
Project No. | Project Name | OCA Code | Change
553 | 670771-100000 (carryover) | 69 KV Line Relocation | 670771 | -$4,880.00
553 | 670638-100000 (carryover) | Computer System Upgrades | 670638 | +$4,880.00
SECTION 6. That the 2010 Capital Improvements Budget is hereby amended as follows (Water):
Fund No. | Proj. No. | Proj. Name | Current Authority | Revised Authority | Change
606 | 690331-100000 (carryover) | HCWP Lagoons Sludge Rmvl. | $82,360 | $51,320 | -$31,040
606 | 690374-100000 (carryover) | WASIMS | $0 | $31,040 | +$31,040
SECTION 7. That the 2010 Capital Improvements Budget is hereby amended as follows (Sanitary):
Fund No. | Proj. No. | Proj. Name | Current Authority | Revised Authority | Change
668 | 650100-100000 | Sanitary Sewer Contingency (Carryover) | $360,063| $325,263 | -$34,800
668 | 650729-100000 | Technology Resources (EAI) | $151,380 | $186,180 | +$34,800
SECTION 8. That the 2010 Capital Improvements Budget is hereby amended as follows (Storm):
Fund No. | Proj. No. | Proj. Name | Current Authority | Revised Authority | Change
676 | 610796-100000 (carryover) | River South Roadway Imp. | $639,734 | $630,454 | -$9,280
676 | 611018-100000 (carryover) | Computer Services | $40,368 | $49,648 | +$9,280
SECTION 9. That the 2010 Capital Improvements Budget is hereby amended as follows (Power):
Fund No. | Proj. No. | Proj. Name | Current Authority | Revised Authority | Change
553 | 670771-100000 (carryover) | 69 KV Line Relocation | $39,933 | $35,053 | -$4,880
553 | 611018-100000 (carryover) | Computer System Upgrades | $21,229 | $26,109 | +$4,880
SECTION 10. That for the purpose of paying the cost of the upgrades to the Columbus Utility Billing System (CUBS) 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 Works Enlargement Voted Bonds Fund | Fund No. 606 | Project 690374-100000 (carryover) | OCA 642900 | Object Level One 06 | Object Level Three 6655 | Amount $31,040.00.
SECTION 11. That for the purpose of paying the cost of the upgrades to the Columbus Utility Billing System (CUBS) 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 $34,800.00.
SECTION 12. That for the purpose of paying the cost of the upgrades to the Columbus Utility Billing System (CUBS) 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 $9,280.00.
SECTION 13. That for the purpose of paying the cost of the upgrades to the Columbus Utility Billing System (CUBS) 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 | Electricity G.O. Bonds Fund | Fund No. 553 | Project 670638-100000 | OCA 670638 | Object Level One 06 | Object Level Three 6655 | Amount $4,880.00.
SECTION 14 2. 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 15. 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 16. That the City Auditor is authorized to establish proper project accounting numbers as appropriate.
SECTION 3. That the expenditure of $80,000.00 or so much thereof as may be necessary, be and is hereby authorized from the Water System Operating Fund, Fund No. 600, as follows:
OCA 602995
Object Level 1: 03
Object Level 3 3369
SECTION 17 4: That for the reasons stated in the preamble hereto, which is hereby made a part hereof, this ordinance is hereby declared to be an emergency measure and shall take effect and be in force from and after its passage and approval by the Mayor, or ten days after passage if the Mayor neither approves nor vetoes the same.