The URL can be used to link to this page

Home My WebLink AboutOrdinance 18918-11-2009Ordinance No. 18918-11-2009 AN ORDINANCE INCREASING ESTIMATED RECEIPTS AND APPROPRIATIONS IN THE MUNICIPAL GOLF FUND IN THE AMOUNT OF $149,676.00 AND IN THE MUNICIPAL AIRPORTS FUND IN THE AMOUNT OF $86,859.00 FROM AVAILABLE FUNDS; IN THE WATER AND SEWER FUND IN THE AMOUNT OF $2,745,351, THE MUNICIPAL PARKING FUND IN THE AMOUNT OF $6,204.00, THE SOLID WASTE FUND IN THE AMOUNT OF $248,167,00 AND IN THE STORM WATER UTILITY FUND IN THE AMOUNT OF $232,657.00 AND DECREASING THE UNRESERVED, UNDESIGNATED RETAINED EARNINGS BY THE SAME AMOUNTS FOR THE PURPOSE OF TRANSFERRfNG SAID FUNDS TO THE SPECIALLY FUNDED CAPITAL PROJECTS FUND TO PROVIDE FUNDS FOR THE GOLF AND AVIATION DEPARTMENTS' SHARE OF ERP PHASE I COSTS; PROVIDING FOR A SEVERABILITY CLAUSE; MAKING THIS ORDINANCE CUMULATIVE OF PRIOR ORDINANCES; REPEALING ALL ORDINANCES IN CONFLICT HEREWITH; AND PROVIDING AN EFFECTIVE DATE. BE fT 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 2010, there shall also be increased appropriations in the Municipal Golf Fund in the amount of $149,676.00 and in the Municipal Airports Fund in the amount of $86,859.00 from available funds; in the Water and Sewer Fund in the amount of $2,745,351.00, the Municipal Parking Fund in the amount of $6,204.00, the Solid Waste Fund in the amount of $248,167.00 and the Storm Water Utility Fund in the amount of $232,657.00 and decreasing the unreserved, undesignated retained earnings by the same amounts, for the purpose of transferring said funds to the Municipal Airports Fund 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. APPROV D TO FORM AND LEGALITY: U` Assistant Ci Attorney ADOPTED AND EFFECTIVE: November 17,.2009 City of Fort Worth, Texas Mayor and Council Communication .,, • ~Y~T ~,•..ta\\~£o'~w;•.. ... .:,<.~, ~,4E; i ~,.;a,J~,::.•\`\\\~,"3~0, ,~e:Sk,\'~ ,. ,;~` 'S\~,~t;•:...~...~t,.,~t~"tao- ~ ;a,,>....`ts~~. .~,\tt, . ~\'~ ,... .\i,'4 ~Y,.~'~\.. .,~.Wl~3~S?. C~uNC~~ A~~r~~~ Approved o~ ~ X11 ~IZ~Q9 - ord. No. ~ 89~ ~~~ ~ ~~009 ~ 8~1 S-~ 1-ZOOS & ,. ~~~~ ~-~ ~-ZOOS .,,,11.......,U....nXN.CkOf~~~........,..?~C.......,.,\... ..mW.. h.....»...... ..... ~,~,~\E~~~E .'P t. •~., \.n 'L::'.:., ,.~~~„~":':,\,~~~~~y;,'~;', ,,.. •.,..t., ~. .:...: ,,• :: ...:::.... .:. .. ... ...:::...:.:. ..nE,,.E`~`.~.........c ..............k.....~:.,?,~~~.'..a0..~~,~~~~~~\~~~~~~.?J~\'.'~~C..~\~i~`~..•.\~~:,,•:~•1):~::3'i~•.fi~.gi4~'~i'~~~,1~?~5t':ta. E`~~~,\~~~+.+\~.•:... .E'uY.:E':•i: ~,.,;., ..~.c ...... E •:~~~, ....;;: ~;~ ~~,~~~ :. ..,.::;»:., \~,,,\,\\E\,.~.?3.,`~11Nt <• ,.......U .,~..... \~\'~ d~:.\~\`~•.,,,,ffi>, '~`<'~'k\\ l;h,`~ \o•. ; ~\~~'$F+"ice, '~~: DATE: Tuesday, November 1l, 2009 REFERENCE N4.: G-16164 LnG NAME: 13ERPTRANSFERS SUBJECT: 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 RECnMMENDATION: 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,676.00 and the Airports Gas Lease Project Fund by $86,859.00 from available funds; 2. Authorize the transfer of $149,676.00 from the Golf Capital Project Fund to the Municipal Golf Fund and $86,859.04 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,676.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 Mun~c~pal Parking Fund by $6,204,04, 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.04 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 Pale 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). Gn August 26, 2008, ~M&C G-16255} the City Council adopted Ordinance No. 18231 authorizing the issuance of $25,000,000.00 in Tax Notes, in part to fund Phase l of an Enterprise Resource Planning ~ERP}system. Phase l involved replacing the City's aging Human ResourceslPayrollsystems inorder 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: Enter rise De artment Relative Size Share of ERP Costs Municipal Golf Courses 4.32 Percent $149 6?6.00 Municipal Airports 2.50 Percent $ 86,559.00 Water and Sewer 79.14 Percent $2,745,351.00 Municipal Parking Facilities 0.18 Percent $6,204.00 Solid Waste 7.15 Percent $248,161.00 Storm Water Utility 6.71 Percent 232,651,.00 Totals 100 Percent $3,465,94.00 FISCAL INF~RMATI~N ! 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 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: T~ FundlAccountlCenters FROM FundlAccountlCenters 1~__P243 446200 801929990100 ~ ~ 49, 676.00 2 P243 538040 801929990100 149 676.00 ~ P243 538040 801929990100 149 616.00 2~P240 538040 551929990100 86 859.00 ~P240 446200. 551929990100 86 859.00 4 PE39 538010 0804090 ~9~616.00 ~~ P240 _, ,.538040_ .5519299901.00 $86 859.00 4~ PE40 . _538070 .0551000 $86,859.00 2~_ PE39 , .4.16243 0804090 $1491616.00 4~ PE45_ _538070_ X609000 $1.,372,676,..00 2} PE4Q _4.16240_ ,0551000 $86859.00 4} PE45 _ _5380_l0_ „0109000 $1,3121615.00 3}__PE39 416243 0804090 $149L616.00 4~_PE_59 _ .538070 .0._2.08500 $.61204.00 3~ PE39 .5_38010 .0804090 $ ~ 491616.00 4~ PE64 _ _53801 _ _ 0525001 $248L~ 61.00 3~PE40 .416240. 055.000 $861859_.,_00 4~ PE69__ _ 538010, ._0209000 $232657.00 3} PE40 538070 0551000 $86,859.00 3 }PE45 538010 0609000 $1, 372, 676.00 Logname: 13ERPTRANSFERS Page 2 of 3 3 PE45 538014 4709044 1 312,615.40 3~PE_59 538470 0248500 ~6~204.04 3~ PE64 5380?0 4525041 X248,161.44 3 PE69 538410 0249000 $232,65?.00 4 0291 412045 131434136114 ~ ~ , 218L512.00 4 5} 029.1 472039 ~ 3~ 034136114 X149,6.16.44 4 5} C29~ 412044 131030136110 86 859.04 4 5~ C291 412445 131434 ~ 36110, 1 526 839.40 4 5 0291 4?2059 131034136114 6 204.44 4 5~ C291 472064 131030136110 248167.00 4 5 C291 412069 131434136114 232 65?.40 5 C291 5XXXXX 131430136110 ~2~250,442.00 CERTIFICATIaNS: Submitted for Cit Mana er's Office b Sri inatin De artment Head: Additional Information Contact: Karen Montgomery (6222) Lena Ellis (8517) James Mauldin (2438) Logname: 13ERPTRANSFERS Page 3 of 3