The URL can be used to link to this page

Home My WebLink AboutOrdinance 18917-11-2009Ordinance No. 18917-11-2009 AN ORDINANCE INCREASING ESTIMATED RECEIPTS AND APPROPRIATIONS IN THE GOLF CAPITAL PROJECT FUND GAS WELLS} IN THE AMOUNT 4F $149,616.00 AND IN THE AIRPORTS GAS LEASE PROJECT FUND BY $86,859.00, FRAM AVAILABLE FUNDS, T4 PROVIDE FUNDS FOR THE GOLF AND AVIATION DEPARTMENTS' SHARE 4F ERP PHASE I COSTS; PROVIDING FOR A SEVERABILITY CLAUSE; MAKING THIS ORDINANCE CUMULATIVE OF PR14R ORDINANCES; REPEALING ALL ORDINANCES IN CONFLICT HEREWITH; AND PROVIDING AN EFFECTIVE DATE. BE IT ORDAINED BYTHE CITY COUNCIL 4FTHE CITY4F F4RTW4RTH, 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 Golf Capital Project Fund Gas Wells} in the amount of $149,616.00 and in Airports Gas Lease Pro}ect Fund by $86,859.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 Qrdinance 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: Assistan C ty Attorney ADOPTED AND EFFECTIVE: November 1l, 2009 City of Fort Worth, Texas Mayor and Council Communication "' ~ ~e~}r~"fi; rs. '~ ~ ~~~~b~ati S~;SO ~J~,.,'~ ~ ~~3; . s ~ `0C. `S~ ~ ~ ...... ~:.. ,a;.; ?~~U`~`h~~e`'~:. ~:4 ;q :`\~\~., ~55~,~,~`~~'~~ ,r. J`Tx..' 4~ ,\ .. .. .... ~\~~°.?~ .., .. .., ..\\\.... .. z.:ti\~~ti,~~~^?@'~~,~'h~: UN. IL ~~TI~-N r App-ro~wed on ~ ~ ~1 ?l2Da9 ~ Card. Nor ~ D~'~?'~1 ~t ~~DD9, ~ ~~~ 8~~ ~ ~~DD9 ~~1 D-~ ~~~DO~ ,, ,,. ~~~•. . DATE: Tuesday, November 17, 2009 REFERENCE NQ.: G-16164 LQG 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 RECQMMENDATIQN; 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,676.40 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 Mun~c~pal 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,745,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 earnin s g 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,145,351.00 from the Water and Sewer Operating Fund, $6,204.00 from the Municipal Parking Fund, $248,167.00 from the Solid Waste Fund and $232,657.00 from the Storm Water Utili tY 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,254,402.00 from available funds. DISCUSSfQN: This M8~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 Pa e 1 of 3 g 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). 0n August 26, 2008, ~M&C G-~ 6255 the City Council adopted Ordinance No. 18231 authorizing the issuance of $25,000,000.00 in Tax Notes, in part to fund Phase I 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: Enterprise De artment .._~ _ Municipal Golf Courses Municipal Airports Water and Sewer Municipal Parking Facilities Solid Waste Storm Water Utility Totals FISCAL INFORMATION I 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. Relative Size Share of ERP Costs 4.32 Percent $149,676.00 2.50 Percent $ 86,859.00 79.14 Percent $2,745,351.00 0.18 Percent $6,204.00 7.15 Percent $248,167.00 6.71 Percent 232 657.00 100 Percent $3,468,914.00 FUND CENTERS: T~ FundlAccountlCenters 1 P243 446200_801929990100 ~__P243 ~P240 1 ~_P240 2~ PE39 2~PE40 3}.PE39 3~PE39 3~ PE40 3} PE40 3} PE45 FROM FundlAccountlCenters $149,616.00 2 P243 538040 801929990100 $149,616.00 2~P240 538040 551929990100 X86,859.00 4 PE39 538010 0804090 X86,859.00 4}_ PE40 ,_ .538010 05.51.000 $1.49 616.00 4~PE45 __ 538010 0609000 X86,859,00 4} PE45 _ 53801 .._0109000 $149616.00 4~PE59 53$Ol0.0208500 ~~ 491616.00 4~ PE54_ _ 538010 0525001 X86 859.00 4~_PE69_____ 538010 _ _0209000 $861859.00 149 676.00 ~6i859.00 149 616.00 ~86~859.00 $1,312 616.00 $1 2312615.00 $61204.04 $24$161..0.0 $2.32 651.00 538040 801929990100 446200..,.55192999010.0 538040 5519.2.9.990100 416243 0.804090 416240.055 ~ 000 4_l_6243_ _.0804090 538010 0804090 416240.0551.000 538010 0551000 538010 0609000 Logname: 13 ERPTRANSFERS $1,312,616.00 Page 2 of 3 3~45~.. 538070 0109000 1 372 675.00 ~PE59 538014 0208500 6 204.00 3~ PE64 538070 0525001 248161.00 3~ 69 538070 0209000 232 651.00 4~C291 412045 13103D136110 X1,218,512.00 4 5} C291 472039 131030136110 149 616.00 4 5 C291 472040 131030136110 86 859.00 4 5 C291 412045 131030136110 $_11526,839.00 4 5} C291 472059 13,1030136114 6 204.00 4 5 C291_ ~472064 131030136110 248167.00 4 5 C291 .472069 131030136110 X232,657.00 5} C291 5XXXXX 131030136110 2 250 402.00 CERTIFICATIONS: Submitted for City Manager's office bv: originating Department Head: Additional Information Contact: Logname: 13 ERPTRAN S F E RS Karen Montgomery (6222) Lena Ellis (8517) James Mauldin (2438) Page 3 of 3