The URL can be used to link to this page

Home My WebLink AboutOrdinance 18919-11-2009Ordinance No. 18919-11-2009 AN ORDINANCE INCREASING ESTIMATED RECEIPTS AND APPROPRIATIONS IN THE SPECIALLY FUNDED CAPITAL PROJECTS FUND IN THE AMOUNT 4F $2,250,402.00, FROM AVAILABLE FUNDS, T4 PROVIDE FUNDS FOR THE GOLF AND AVIATION DEPARTMENTS' SHARE OF ERP PHASE I COSTS; PROVIDING FOR A SEVERABILITY CLAUSE; MAKING THIS ORDINANCE CUMULATIVE 4F PR14R ORDINANCES; REPEALING ALL ORDINANCES IN CONFLICT HEREWITH; AND PROVIDING AN EFFECTIVE DATE. BE IT ORDAINED BYTHE CITY COUNCIL 4F THE CITY 4F FORT WORTH, TEXAS: SECTION 1. That in addition to those amounts allocated to the various City departments for Fiscal Year 2010, there shall also be increased appropriations in the Specially Funded Capital Projects Fund in the amount of $2,250,402.00, from available funds, to provide funds for the Golf and Aviation Departments' share of ERP Phase I costs. 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.18809and 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: Assistant Ci Attorney ADOPTED AND EFFECTIVE: November 111.2009 City of Fort Worth, Texas Mayor and Council Communication ~`i;\~~`...:, .d ~ \\\`~06A``a~'`'A~a~43~br"o\+~eU`~3ca:.,,,~\4+e ,~N4~'~C .... ~. <' <~4~:C~1',l``h'~<':~ncY~``Y~... '~, ``<~F,$,'. ~`,t,~~,l`~~8i:M $3.~~ \ ?r'~\3.x C"\~v'°:nr a"~ t8~'c. ~.`\~\@ .mn `~~:: COU NCIL ATiO~: A~prav~~ o~ ~ ~ I~ ?!2009 - 0~~~ Na-. ~ 89~ T-~ ~ -2009 ~ ~~~ ~~ 1- 9 X009, ~ 1 ~~ ~ 9-~ ~ -949 w:r:;:;.:isli;:it;<;;caR;'SR,>;e,;~::.>.'C?:.;>,. ,::z:a•z... y~, r>,<.,.: ,~ .,..,..;..:.,: ;.;r .....:.::.... ......::.::..... ..... .......:....::,..:. ~\_ ,.:....~£, , ,a^cr....~ ....~.~.' :~.....\~\~ ,~£K,?,~,'~,~~~ a~::\\`~~\Mr.~~}r,~~~~ ,xo,s~"~;,,,:F:'a~~.A~a,i~~ri~r.~~;,r~<"x "~ n~ ~v, ~,~i, DATE: Tuesday, November 17, 2009 LOG NAME: 13ERPTRANSFERS SUBJECT: REFERENCE ND.: G-16764 Adopt Appropriation ordinances and Transfer Funds from Various Enterprise Funds to the Specially Funded Capital Projects Fund to Cover a Portion of the Costs Incurred by the City of Fort Worth for Phase I of the Enterprise Resource Planning System RECOMMENDATION: It is recommended that the City Council: 1. Adopt the attached appropriation ordinance increasing estimated receipts and appropriations in the Golf Capital Project Fund by $149,616.00 and the Airports Gas Lease Project Fund by $86,859.00 from available funds; 2. Authorize the transfer of $149,616.00 from the Golf Capital Project Fund to the Municipal Golf Fund and $86,859.00 from the Airports Gas Lease Project Fund to the Municipal Airports Fund; 3. Adopt the attached supplemental appropriation ordinance increasing estimated receipts and appropriations in the Municipal Golf Fund by $149,616.00 and the Municipal Airports Fund by $86,859.00 from available funds and increasing appropriations in the Water and Sewer operating Fund by $2,145,351.00, the Municipal Parking Fund by $6,204.00, the Solid Waste Fund by $248,161.00 and the Storm Water Utility Fund by $232,651.00 and decreasing the unreserved, undesignated retained earnings by the same amount; 4. Authorize the transfer of $149,616.00 from the Municipal Golf Fund, $86,859.00 from the Municipal Airports Fund, $2,745,351.00 from the Water and Sewer Operating Fund, $6,204.00 from the Municipal Parking Fund, $248,161.00 from the Solid Waste Fund and $232,651.00 from the Storm Water Utility Fund to the Specially Funded Capital Projects Fund; and 5. Adopt the attached appropriation ordinance increasing estimated receipts and appropriations in the Specially Funded Capital Projects Fund by $2,250,402.00 from available funds. DISCUSSION: This M&C is transferring funds from various Enterprise Funds to the Specially Funded Capital Projects Fund to cover a portion of the costs of Phase I of the Enterprise Resource Planning (ERP) system. Most funds had sufficient fund balance to cover their portion, however, Golf and Aviation required gas lease revenues. Because of the way governmental accounting works, the gas lease revenues first had to be appropriated from the proper Funds (Recommendation No. 1). Once appropriated, the funds could then be transferred to the appropriate operating funds (Recommendation No. 2). After transferring gas revenues, all Enterprise Funds could then have their portion of the costs appropriated for the transfer to the Specially Logname: 13ERPTRANSFERS Page 1 of 3 Funded Capital Projects Fund (Recommendation No. 3) and consequently transferred (Recommendation No. 4). Once all funds have been transferred, they then need to be appropriated for use (Recommendation No. 5). On August 26, 2608, ~M&C G-16255} the City Council adopted Ordinance No. 18231 authorizing the issuance of $25,604,406.46 in Tax Notes, in part to fund Phase l of an Enterprise Resource Planning ~ERP}system. Phase I involved replacing the City's aging Human ResourceslPayroll systems in order to benefit departments Citywide. The desire was to fund 20 percent of the costs from Enterprise Funds and the remainder from Tax Notes, with the 20 percent allocated among the Enterprise Funds according to the relative size of the departments. if approved, this action will appropriate the funds from the fund balance of each Enterprise Fund and authorize the transfer of said funds to the Specially Funded Capital Projects Fund, with the exception that Golf will be using gas well revenues instead of fund balance. The detailed amounts are as follows: E_nter~rise De artment Municipal Golf Courses Municipal Airporks Water and Sewer Municipal Parking Facilities Solid Waste Storm Wate r Uti I ity Totals FISCAL INFORMATION I CERTIFICATION: Relative Size 4.32 Percent 2.50 Percent 19.14 Percent 0.15 Percent 7.15 Percent R 71 pcrr+cr,f 1UU Percent Share of ERP Costs $149,616.00 $ 86,859.00 $2,145, 351.00 $6,204.00 $245,161.00 232x651'.00 $3,468,94.00 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 budgets, as appropriated, of the Specially Funded Capital Projects Fund, Golf Capital Project Fund and Airports Gas Lease Project Fund. Upon approval, the unreserved, undesignated fund balance in the Water and Sewer Operating Fund, Municipal Parking Fund, Solid Waste Fund and Storm Water Fund will exceed the minimum reserve as outlined in the Financial Management Policy Statements. Upon adoption of the attached supplemental appropriation ordinance, funds will be available in the current operating budgets, as appropriated, of the Municipal Golf Fund and Municipal Airports Fund. FUND CENTERS: To FundlAccountlCenters 1) P~43~.446200 801929990100 1) P243 538040 801929990100 ~P240 446200 551929990100 1~0 538040 551929990100 ~~ PE39 476243.0804090 2~_PE4Q 476240_., 0551000 3} PE39___476243.OS4.4090 3~_PE39_ _,538070,_, 0804090 3}_ PE44_ 41624 _4551.000 3} PE40 538070 0551000 3} PE45 538070 0609000 FROM FundlAccountlCenters 149 676.00 ~~ _P243 538040 801929990100 149 676.00 149 676.00 2) P240 538040 551929990100 86 859.00 86 859.00 4~PE39 538010 0804090 149 616..00 $86859.00 4 PE40 538010. 05.51.000 86 859.00 ~149~616.00 4}_PE45 _ 53$070_. ._0609400 $1 372L676.00 $86,859.00 4~ PE45__ 53H070. 0709000 $_113,12,675.00 X1.49,676.00 4~E59. 538070_ _0208504 $61204.0.0 ~149~676.00 4~_PE64 _ 5384.10,.. .052500.1_ X248,167.00 86 859.00 4~E69 _ ..538010 0209000 $232L651.0~ $861859.44 $1,312,676.00 Logname: 13 ERPTRANSFERS Page 2 of 3 3~PE45 538070 0709044 X1_,372 675.00 3~PE59 538070 0208500 X6,204.00 3} PE64 538070 0525001 248167.00 3~E69 538474 4249000 X32,657.00 4~C291 472045 131030136110 1 218 512.04 4 5} C291 472039 131030136110 149 676.00 4 5~ C291 _ .472440 131030136110 86 859.40 4 5 C291 472045 131434136110 $1, 526, 839.00 4 5} C291 472459.__131034136110 6 204.00 4 5~C291 472064 131030136110 .248167.44 4 5 C291 472069 131430136114 232 657.00 5} C291 5XXXXX 131430136110 $2,250,402.04 CERTIFICATIONS: Submitted for Ci#v Manaaer's Office bv: 4ri~inating De~me.nt Head: Additional Information Contact: Karen Montgomery (6222) Lena Ellis (8517) James Mauldin (2438) Logname: 13 ERPTRANSFERS Page 3 of 3