HomeMy WebLinkAboutOrdinance 20249-06-2012Ordinance No. 20249 -06 -2012
AN ORDINANCE INCREASING THE ESTIMATED RECEIPTS AND
APPROPRIATIONS IN THE WATER AND SEWER FUND IN THE AMOUNT OF
$7,431,687.00, AND DECREASING THE AVAILABLE CASH BALANCE BY THE
SAME AMOUNT, FOR THE PURPOSE OF FINANCING A PORTION OF THE
ENTERPRISE RESOURCE PLANNING (ERP) PHASE II SYSTEM; PROVIDING FOR
A SEVERABILITY CLAUSE; MAKING THIS ORDINANCE CUMULATIVE OF
PRIOR ORDINANCES; REPEALING ALL ORDINANCES IN CONFLICT
HEREWITH; AND PROVIDING AN EFFECTIVE DATE.
BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF FORT WORTH,
TEXAS:
SECTION 1.
That in addition to those amounts allocated to the various City departments for Fiscal Year 2011 -2012 in the
Budget of the City Manager, there shall also be increased estimated receipts and appropriations in the Water
and Sewer Fund in the amount of $7,431,687.00, and decreasing the available cash balance by the same
amount, for the purpose of financing a portion of the Enterprise Resource Planning (ERP) Phase II System.
SECTION 2.
That should any portion, section or part of a section of this ordinance be declared invalid, inoperative or
void for any reason by a court of competent jurisdiction, such decision, opinion or judgment shall in no way
impair the remaining portions, sections, or parts of sections of this ordinance, which said remaining
provisions shall be and remain in full force and effect.
SECTION 3.
That this ordinance shall be cumulative of Ordinance No.1 99 1 1 -09 -201 1 and all other ordinances and
appropriations amending the same except in those instances where the provisions of this ordinance are in
direct conflict with such other ordinances and appropriations, in which instance said conflicting provisions
of said prior ordinances and appropriations are hereby expressly repealed.
SECTION 4
This ordinance shall take effect upon adoption.
ROVED S TO FORM AND LEGALITY:
Assist n City Att �)`ey
ADOPTED AND EFFECTIVE: June_ 12, "012
City of Fort Worth, Texas
Mayor and Council Communication
COUNCIL ACTION: Approved on 6/12/2012 - Ordinance Nos. 20247 -06- 2012& 20248 -06
2012 & 20249 -06 -2012
DATE: Tuesday, June 12, 2012 REFERENCE NO.: G -17616
LOG NAME: 13ERP2TRANSFERS
SUBJECT:
Authorize Transfer in the Amount of $9,802,783.00 from Various Funds to the Specially Funded Capital
Projects Fund and the Enterprise Resource Planning Capital Project Fund to Fund a Portion of Enterprise
Resource Planning Phase II and Adopt Appropriation Ordinances (ALL COUNCIL DISTRICTS)
RECOMMENDATION:
It is recommended that the City Council:
1. Adopt the attached supplemental appropriation ordinance increasing estimated receipts and
appropriations in the Water and Sewer Fund in the amount of $7,431,687.00 and decreasing the available
cash balance by the same amount;
2. Authorize the transfer in the amount of $1,071,641.00 from the Municipal Airports Fund, $7,431,687.00
from the Water and Sewer Fund, $99,494.00 from the Municipal Parking Fund, $586,304.00 from the Solid
Waste Fund, $435,939.00 from the Storm Water Utility Fund, and $177,718.00 from the Culture and
Tourism Fund to the Specially Funded Capital Projects Fund in the amount of $7,165,447.50 and to the
Enterprise Resource Planning Capital Project Fund in the amount of $2,637,335.50; and
3. Adopt the attached appropriation ordinance increasing estimated receipts and appropriations in the
Specially Funded Capital Projects Fund in the amount of $7,165,447.50 and in the Enterprise Resource
Planning Capital Project Fund in the amount of $2,637,335.50 from available funds.
DISCUSSION:
Approval of this M &C will authorize transfer of previously budgeted and appropriated dollars from various
Enterprise Funds to finance a portion of the Enterprise Resource Planning (ERP) Phase II system, and it
will approve a supplemental appropriation and transfer of funds from the Water and Sewer Fund for the
same purpose.
On October 5, 2010, (M &C G- 17074) the City Council adopted Ordinance No. 19382, authorizing the
issuance of Combination Tax and Revenue Certificates of Obligation (CO), Series 2010A, in part to fund a
portion of the cost of Phase II of an ERP system. The CO debt issuance associated with Phase II was
limited to the General Fund and Municipal Golf Fund. All other contributing funds preferred transfers to the
project instead of a debt issue. The Municipal Airports Fund and Culture and Tourism Fund each
determined that a one -time transfer was most appropriate. The Water and Sewer Fund has determined
that a two -year payment strategy was appropriate, and the Solid Waste Fund, Municipal Parking Fund,
and Storm Water Utility Fund each opted for annual transfers from their operating budgets for a period of
up to four years. These decisions were based on the availability of funds and the individual business
Logname: 13ERP2TRANSFERS Page I of 3
needs of each enterprise.
FISCAL INFORMATION / CERTIFICATION:
The Financial Management Services Director certifies that upon approval of the above recommendations
and adoption of the attached appropriation ordinances, funds will be available in the current operating and
capital budgets, as appropriated, of the Specially Funded Capital Projects Fund and the ERP Capital
Project Fund. Upon approval, the available cash balance in the Water and Sewer Fund will exceed the
minimum reserve as outlined in the Financial Management Policy Statements.
FUND CENTERS:
TO Fund /Account/Centers
FROM Fund /Account/Centers
1) PE45
538070
0609000
$3,715,843.50
2) PE40 538070 0551000
$1,071,641.00
1) PE45
538070
0709000
$3,715,843.50
2) PE45 538070 0609000
$3,715,843.50
2) C291
472040
1310301361XX
$676,599.72
2) PE45 538070 0709000
$3,715,843.50
2) C291
472045
1310301361XX
$5,668,413.62
2) PE59 538070 0208500
$99,494.00
2) C291
472059
1310301361XX
$62,817.32
2) PE64 538070 0239901
$586.304.00
2) C291
472064
1310301361XX
$370,173.52
2) PE69 538070 0209000
$435,939.00
2) C291
472069
1310301361XX
$275,237.89
2) GG04 538070 0246000
$88.859.00
2) C291
472004
1310301361XX
$112,205.44
2) GG04 538070 0246010
$88.859.00
2) C296
472040
1310301361XX
$395,041.28
2) C296
472045
1310301361XX
$1,763,273.38
2) C296
472059
1310301361XX
$36.676.68
2) C296
472064
1310301361XX
$216.130.48
2) C296
472069
1310301361XX
$160.701.11
2) C296
472004
1310301361XX
$65,512.56
3) C291
472040
1310301361XX
$676,599.72
3) C291
472045
1310301361XX
$5,668,413.62
3) C291
472059
1310301361XX
$62,817.32
3) C291
472064
1310301361XX
$370,173.52
3) C291
472069
1310301361 XX
$275.237.89
3) C291
472004
1310301361XX
$112,205.44
3) C291
5XXXXX 1310301361XX
$7,165,447.70
3) C296
472040
1310301361XX
$395,041.28
3) C296
472045
1310301361XX
$1,763,273.38
3) C296
472059
1310301361XX
$36,676.68
3) C296
472064
1310301361XX
$216,130.48
3) C296
472069
1310301361XX
$160,701.11
3) C296
472004
1310301361XX
$65,512.56
3) C296
5XXXXX
1310301361XX
$2,637,335.50
Logname: 13ERP2TRANSFERS Page 2 of 3
CERTIFICATIONS:
Submitted for City Manager's Office by:
Originating Department Head:
Additional Information Contact:
Susan Alanis (8180)
Lena Ellis (8517)
Greg Jordan (8843)
Logname: 13ERP2TRANSFERS Page 3 of 3