HomeMy WebLinkAboutOrdinance 20248-06-2012Ordinance No. 20248 -06 -2012
AN ORDINANCE INCREASING THE ESTIMATED RECEIPTS AND
APPROPRIATIONS IN THE ERP CAPITAL PROJECT FUND IN THE AMOUNT OF
$2,637,335.50, FROM AVAILABLE FUNDS, 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 ERP
Capital Project Fund in the amount of $2,637,335.50, from available funds, 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.19911 -09 -2011 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.
APPROVED AS TO FORM AND LEGALITY:
ADOPTED AND EFFECTIVE:.lune 12, 2012
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 1 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
1) PE45 538070 0609000
1) PE45 538070 0709000
2)C291 472040 1310301361XX
2) C291 472045 1310301361XX
2) C291 472059 1310301361XX
2)C291 472064 1310301361XX
2) C291 472069 1310301361 XX
2) C291 472004 1310301361XX
2)C296 472040 1310301361XX
2) C296 472045 1310301361 XX
2) C296 472059 1310301361XX
2)C296 472064 1310301361XX
2)C296 472069 1310301361XX
2) C296 472004 1310301361XX
3)C291 472040 1310301361XX
3) C291 472045 1310301361 XX
3) C291 472059 1310301361XX
3)C291 472064 1310301361XX
3) C291 472069 1310301361 XX
3) C291 472004 1310301361XX
3) C291 5XXXXX 1310301361XX
3) C296 472040 1310301361XX
3)C296 472045 1310301361XX
3)C296 472059 1310301361XX
3) C296 472064 1310301361XX
3) C296 472069 1310301361 XX
3) C296 472004 1310301361 XX
3) C296 5XXXXX 1310301361XX
FROM Fund /Account/Centers
$3,715,843.50 2) PE40 538070 0551000
$3,715,843.50 2) PE45 538070 0609000
$676,599.72 2) PE45 538070 0709000
$5,668,413.62 2) PE59 538070 0208500
$62,817.32 2) PE64 538070 0239901
$370,173.52 2) PE69 538070 0209000
$275,237.89 2) GG04 538070 0246000
$112,205.44 2) GG04 538070 0246010
$395,041.28
$1,763,273.38
$36,676.68
$216.130.48
$160,701.11
$65,512.56
$676,599.72
$5,668.413.62
$62,817.32
$370,173.52
$275,237.89
$112,205.44
$7,165,447.70
$395,041.28
$1,763,273.38
$36,676.68
$216,130.48
$160.701.11
$65,512.56
$2,637,335.50
$1,071,641.00
$3,715,843.50
$3,715,843.50
$99,494.00
$586,304.00
$435,939.00
$88,859.00
$88,859.00
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