HomeMy WebLinkAboutOrdinance 17479-04-2007Ordinance No 17479-04-2007
AN ORDINANCE INCREASING APPROPRIATIONS BY THE INDICATED AMOUNTS IN
THE INDICATED FUNDS FOR ENCUMBRANCE ROLLOVERS AND DESIGNATED
EXPENDITURES' PROVIDING A SEVERABILITY CLAUSE, MAKING THIS ORDINANCE
CUMULATIVE OF PRIOR ORDINANCES AND REPEALING ALL PRIOR 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 2006-2007 in the
Budget of the City Manager there shall also be increased appropriations in the General Fund in the amount
of $7 936 669 05 and decreasing the unreserved, undesignated fund balance by the same amount; in the
Crime Control and Prevention District Fund in the amount of $3,227 827 00 and decreasing the unreserved,
designated fund balance by the same amount; in the Engineering Fund in the amount of $64 364 00 and
decreasing the unreserved undesignated retained earnings by the same amount; in the Equipment
Services Fund by $538 896 67 and decreasing the unreserved, undesignated retained earnings by the
same amount; in the Information Systems Fund in the amount of $816 905 00 and decreasing the
unreserved, undesignated retained earnings by the same amount; in the Risk Management Fund by
$19 820 80 and decreasing the unreserved, undesignated retained earnings by the same amount; in the
Solid Waste Fund by $156 759.21 and decreasing the unreserved, undesignated retained earnings by the
same amount; in the Water and Sewer Fund in the amount of $2,839 609 61 and decreasing the
unreserved, undesignated retained earnings by the same amount; and in the Workers Compensation Fund
by $40 000 and decreasing the unreserved, undesignated retained earnings by the same amount, for
encumbrance rollovers and designated expenditures.
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 17142 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
9 s s ant ity Attorney
ADOPTED AND EFFECTIVE. April 3. 2007
City of Fort Worth, Texas
Mayor and Council Communication
COUNCIL ACTION Approved on 4/3/2007 Ordinance No 17479-04-2007
DATE Tuesday April 03 2007
LOG NAME 03ROLLOVER DESK REFERENCE NO G-15661
SUBJECT
Adopt Supplemental Appropriation Ordinance for Fiscal Year 2006-2007 for Rollover
Encumbrances and Designated Expenditures
RECOMMENDATION
It is recommended that the City Council adopt the attached supplemental appropriation ordinance
increasing appropriations by the indicated amounts in the following funds.
1 General Fund by $7 936 699 05 and decreasing the unreserved undesignated fund balance by the
same amount;
2. Crime Control and Prevention District Fund by $3,227 827 00 and decreasing the unreserved
designated fund balance by the same amount;
3 Engineering Fund by $64 364 00 and decreasing the unreserved undesignated retained earnings by
the same amount.
4 Equipment Services Fund by $538 896 67 and decreasing the unreserved undesignated retained
earnings by the same amount.
5 Information Systems Fund by $816 905 00 and decreasing the unreserved undesignated retained
earnings by the same amount.
6 Risk Management Fund by $19 820 80 and decreasing the unreserved undesignated retained
earnings by the same amount.
7 Solid Waste Fund by $156 759 21 and decreasing the unreserved undesignated retained earnings by
the same amount;
8 Water and Sewer Fund by $2,839 609 61 and decreasing the unreserved undesignated retained
earnings by the same amount; and
9 Workers Compensation Fund by $40 000 00 and decreasing the unreserved undesignated retained
earnings by the same amount.
DISCUSSION
The attached supplemental appropriation ordinance increases the FY2006-2007 budget for two categories
of expenditures encumbrance rollovers and designations The City Manager's Office and the Budget and
Management Services Department reviewed the items in each category and recommends their
approval A list by fund department, and amount is below
Logname• 03ROLLOVER DESI Page 1 of 8
ENCUMBRANCE ROLLOVERS
Encumbrances are used to reserve a portion of a department's budget for a specific purchase most often
identified by a contract or purchase order As goods are received or services rendered the encumbered
amount is reduced by the amount of the expenditure (expense)
As annual appropriations expire on September 30th the amounts encumbered on that date 'rollover" to
the new fiscal year to become encumbered against the new budget. However the corresponding funds
are not rolled over into the new fiscal year Instead the matching appropriations, or operating funds, are
closed and applied to the fund balance at year-end Therefore large value purchases must be re-
appropriated in the new fiscal year so that the City may honor outstanding purchase orders, contracts and
other commitments without adversely impacting the new fiscal year's operating budget programs and
services
The rollover of funds from the previous to the current fiscal year requires both an increase in appropriations
to accommodate the item and a corresponding decrease in unreserved undesignated fund balance or
retained earnings. The following items, including fund department and amount, are recommended for
rollover into the FY2006-2007 budget.
EXISTING EXPENDITURES/EXISTING PROGRAMS
GENERAL FUND (GG01)
The major existing expenditures to be rolled over in the General Fund are Tracking Hardware and
Software for the Code Department totaling $484 726 00 vehicles for the Parks Department totaling
$254 349 94 and library materials for the Library Department totaling $126,212 00
DEPARTMENT PROJECT/ITEM AMOUNT
Code Tracking Hardware and Software $484 726 00
Development Zucker Fee Study $40 000 00
Limehouse Publishing Software $97,255 00
Environmental Management Texas Clean Air Cities Coalition $10 000 00
Human Resources Furnishing for Meacham E-Lab $37 000 00
Office Furniture for Learning Services $28 115 00
HR Office Remodel in City Hall $13 066 00
Leadership Development Program $15,200 00
Electrical Work at Meacham for Learning Services $10 300 00
Law Outside Legal Counsel $70 659 00
Library Library Materials $126,212.00
Processing Fees for Library Materials $20 656 00
Media Displays for Branches $6 940 00
PACS Chipper Vehicle $73 176 47
Bulky Waste Vehicle $68 976 47
4 Door Truck with Flat Bed $34 613 00
4 Door Truck with Utility Body $39 067 00
4 Door Truck with Dump Flat Bed $38 517 00
Logname 03ROLLOVER DESI Page 2 of 8
Contract for Open Space Master Plan $50 000 00
Agreement with TCC for Maintenance $25 723 60
Play Structure Replacement $42,280 00
Planning Engineering Services $11 631 53
Police West Division Parking Lot Repair $60 000 00
SWAT Rifles $39,752.00
TOTAL $1 443 866 07
CCPD (GR79)
DEPARTMENT PROJECT/ ITEM AMOUNT
Police Installation of Security Systems at FWPD facilities $108 748 00
Mobile Store Fronts $480 000 00
Community Prosecutor Program $80 000 00
Safe Haven Contract $32,206 00
Communication Towers $300 000 00
Weapons Program $72,794 00
Replacement of High Mi leage Vehicles $470 015 00
Police Recruit Training Salaries $973 142.00
Police Recruit Training Medicare $7 698 00
Police Recruit Training Insurance $91 080 00
Police Recruit Training Retirement $119,229 00
Police Recruit Training Firearms Training Supplies $27 726 00
Police Recruit Training Uniforms & Special Clothing $45 475 00
Police Recruit Training Consulting $30 750 00
Police Recruit Training Printing & Binding $4,288 00
Police Recruit Training Copy Supplies 5 199.00
TOTAL $2,848 350 00
ENGINEERING FUND (P119)
DEPARTMENT PROJECT/ITEM AMOUNT
Engineering Work Truck for Survey $32,182 00
Work Truck for Survey $32.182.00
TOTAL $64 364 00
INFORMATION SYSTEMS FUND (P168)
DEPARTMENT PROJECT/ ITEM AMOUNT
IT E-Gov $432,665 00
Genwatch 3 (Sims Replacement) $164,240.00
TOTAL $596 905 00
Logname: 03ROLLOVER DESI Page 3 of 8
RISK MANAGEMENT FUND (FE71)
DEPARTMENT PROJECT/ITEM AMOUNT
Law Outside Legal Representation $19,820.80
TOTAL $19 820 80
SOLID WASTE FUND (PE64)
DEPARTMENT PROJECT/ITEM AMOUNT
Environmental Management Rotoboom Truck $120 504 46
Upgrade of Call Center Software to ITSM $36,254.75
TOTAL $156 759.21
WORKERS COMPENSATION FUND (FE73)
DEPARTMENT PROJECT/ITEM AMOUNT
Human Resources Safety Engineering & Environmental Services Contract $40,000.00
TOTAL $40 000 00
NEW EXPENDITURES/ NEW PROGRAMS
GENERAL FUND (GG01)
DEPARTMENT PROJECT/ITEM AMOUNT
Human Resources Physical Ability Test for Civil Service $132,000 00
Succession Planning $30,000.00
TOTAL $162,000 00
DESIGNATIONS
At the end of FY2005-2006 various City departments requested that unexpended appropriations and a
limited number of funding priorities from FY2005-2006 be approved for appropriation in the FY2006-2007
budget as designations. The City Manager's Office and the Budget and Management Services
Department reviewed each of these items individually and recommends their approval The following is a
summary of the resulting recommended designations.
EXISTING EXPENDITURES/EXISTING PROGRAMS
GENERAL FUND (GG01)
The major existing expenditures to be designated from the General Fund fund balance are Fort Worth
Community Arts HVAC replacement totaling $2,300 000 00 380 Agreements totaling $1 405 478 93 and
vehicles for the several departments totaling $671 061 44
DEPARTMENT PROJECT/ITEM AMOUNT
City Secretary Grant Match for Minute Book Restoration $30 000 00
Code Tracking Hardware and Software $4,274 00
Development Limehouse Publishing Software $12,745 00
Fire Utility Truck $34 300 00
Squad Rescue/Hazmat Trailer $8 995 00
Logname 03ROLLOVER DESI Page 4 of 8
Law Outside Legal Counsel $12 721.20
Non-Departmental 380 Agreements $1 405 478 93
Fort Worth Community Arts HVAC $2,300 000 00
Deloitte & Touche Audit $687 700 00
HUD Reimbursement $117 500 00
City Hall Security Initiatives $238 000 00
Contract with Boys and Girls Clubs and Comin Up Gang Program $104 377 00
PAS Communications Contract $82,000 00
Public Events Daewoo Forklift $24 649 00
Public Health 4 Consumer Health Vehicles $80 000 00
1 Health Promotions Vehicle $20 000 00
Animal Control Management Software $40 000 00
T/PW Bed of Truck $29 320 98
Bed of Truck $29 320 98
Bed of Truck $22,758 50
1 Ton Pick Up $35 000 00
1 Ton Pick Up $35 000 00
40 foot Bucket $111 516 00
1 Ton Pick Up $33 000 00
1 Ton Super Duty $42 000.00
1 Ton Super Duty $42 000 00
Roadway Impact Fee Study $524 945 41
Bed of Truck $29 320 98
2 Generators $24 880 00
Street Sweeper $169,000.00
TOTAL $6 330 802.98
CCPD (GR79)
DEPARTMENT PROJECT /ITEM AMOUNT
Police
Mobile command Post $313 099 00
In-Car Video Systems $37 845 00
After School Program 28 533
TOTAL $379 477 00
EQUIPMENT SERVICES FUND (P161)
DEPARTMENT PROJECT/ITEM AMOUNT
Equipment Services CCG Faster Fleet Management Software $318 896 67
Fuel Truck $220,000.00
TOTAL $538 896 67
Logname 03ROLLOVER DESI Page 5 of 8
INFORMATION SYSTEMS FUND (P168)
DEPARTMENT PROJECT/ITEM AMOUNT
IT ERP $120 000 00
Genesys Support $100.000.00
TOTAL $220 000 00
WATER & SEWER FUND (PE45)
DEPARTMENT PROJECT/ITEM AMOUNT
Water South Holly High Service Pump #2 $100 000 00
Duct Work &HVAC Controls $9 876 00
HVAC Controls $26 956 00
Maintenance Agreement $12,256 00
Business Planning $37 439 00
Lease Training Maint. (Naviline) $10 037 00
Call Center Network & Mobile Study $161 331 00
Planning $6 125 00
Stormwater $31 562.00
Managed Security Service $75 000 00
Implement Maximo $125 000 00
Technical Staff Support $31 850 00
IVR System $27 750 00
Boiler $45 836 00
Compressor Pumps $15 972.00
Control Valve $70 066 00
Air Handler $36 181 00
50-Ton Chiller $30 000 00
Sensus Data Metering System $44 080 00
Bayonet Breakers $43 848 00
Dump body $15 128 00
Service truck w/ backhoe, compressor crane $112,960 11
Aqualogic $45 500 00
Wastewater Flush truck, 32,000 GVWR $137 876.25
Root Eradication Contract $28 567 00
Trenchless point repair Contract $149,255 00
Clean-out installation Contract $132,740 00
Repair of PE Motors (13 & 21) Turnkey $101 000 00
UPS Batteries $55 000 00
Team Building Program $16 700 00
Permit Renewal Application Fee $21 628 00
Maintenance Agreement $12,257 00
Business Planning $37 439 00
Lease Training, Maint. (Naviline) $10 038 00
Call Center Network & Mobile Study $161 332.00
Planning $6 125 00
Stormwater $31 562.00
Logname 03ROLLOVER DESI Page 6 of 8
Technical Staff Support $11 000 00
IVR System $27 750 00
Managed Security Service $75 000 00
Implement Maximo $125 000 00
Technical Staff Support $31 850 00
Aqualogic $45 500 00
Classroom Trailer Building $45 073.25
Repair Algae Sweep Automation System $19 000 00
Purchase of Automatic Samplers $24,212.00
2 Flowserve Non-Clog Sewage Pumps $94 498 00
4 Stainless Steel Nas Pumps $65 372.00
Service Truck $30 307 00
Cargo Van for TV Inspection System $26 577 00
Cues TV Inspection System $166 937 00
Service Truck $35,261.00
TOTAL $2,839 609 61
SUMMARY OF ALL FUNDS
FUND ROLLOVERS- ROLLOVERS- DESIGNATIONS- DESIGNATIONS- TOTAL
EXISTING NEW EXISTING NEW
General Fund $1 443 866 07 $162,000 00 $6 330 802.98 $0 00 $7 936 669 05
CCPD $2,848 350 00 $0 00 $379 477 00 $0 00 $3,227 827 00
Engineering $64 364 00 $0 00 $0 00 $0 00 $64 364 00
Equipment Services $0 00 $0 00 $538 896 67 $0 00 $538 896 67
Information Systems $596 905 00 $0 00 $220 000 00 $0 00 $816 905 00
Risk Management $19 820 80 $0 00 $0 00 $0 00 $19 820 80
Solid Waste $156 759.21 $0 00 $0 00 $0 00 $156 759.21
Water & Sewer $0 00 $0 00 $2,839 609 61 $0 00 $2,839 609 61
Workers Compensation $40,000.00 0.00 0.00 0.00 $40,000.00
TOTAL ALL FUNDS $5 170 065 08 $162,000 00 $10 308 786.26 $0 00 $15 640 851 34
FISCAL INFORMATION/CERTIFICATION
The Finance Director certifies that upon adoption of the attached supplemental appropriation ordinance the
preliminary unaudited fund and cash balances will be as follows.
1 The unaudited unreserved undesignated fund balance of the General Fund will be $53 440 443 87
2. The unaudited unreserved designated fund balance of the Crime Control and Prevention District Fund
will be $31 808 706
3 The cash balance of the Water and Sewer Fund will be $65 109 548
4 The cash balance of the Solid Waste Fund will be $18 806 008
5 The unaudited unreserved designated fund balance of the Risk Management Fund will be
$ 5 707 320'
6 The unaudited unreserved undesignated fund balance of the Workers Compensation Fund will be
$6 304 576
7 The cash balance of the Engineering Fund will be $1 984 140
8 The cash balance of the Informations Systems Fund will be $2 050 032, and
9 The cash balance of the Equipment Services Fund will be ($1 701 098)
Logname• 03ROLLOVER DESI Page 7 of 8
TO Fund/AccountlCenters
FROM Fund/Account/Centers
Submitted for City Manager's Office b~ Karen Montgomery (6222)
Originating Department Head Bridgette Garrett (8518)
Additional Information Contact: Erin Roseman (8512)
Logname• 03ROLLOVER DESI
Page 8 of 8