G-93-07-20-8A - 7/20/1993ORDINANCE NO. C7 -q3-07- (Q0— gA
AN ORDINANCE PROVIDING FOR THE REVISION OF THE BUDGET
OF THE CITY OF ROUND ROCK, TEXAS FOR FISCAL YEAR
1992-93.
BE IT ORDAINED BY THE COUNCIL OF THE CITY OF ROUND ROCK,
TEXAS:
That the budget for the City of Round Rock, Texas for Fiscal
Year 1992-1993 is hereby revised for municipal purposes pursuant to
5102.010, Local Government Code and in accordance with the proposal
submitted to the Council by the City Manager, which proposal is
attached hereto as Exhibit "A" and is incorporated into this
ordinance by reference for all purposes.
The City Secretary is directed to file a certified copy of
this ordinance along with a true copy of the attached revised
budget with the County Clerk of Williamson County, Texas. Q
reading this the U
READ and APPROVED on first
day of
, 1993.
READ, APPROVED and ADOPTED on second reading this the
r
Oc0! day of �jL J -,--- , 1993.
ATTEST:
2/ Kt . hL ) 7A-
JE LAND, City Secretary
KS/ORDINANCES
OR07083C
4g/
CHARLES CULP •', Mayor
City of Round Rock, Texas
THE CITY OF ROUND ROCK, TEXAS
BUD
GET REVISION #3
FISCAL YEAR 1992 1993
GENERAL FUND
Revenues
Expenditures
Total Change in Fund Balance
UTILITY FUND
1992-1993
Revised
Budget
1992-1993
Revised
#3
$ 9,749,855 $ 10, 511, 337
(10,477,417) (10,815,481)
$ (727, 562) $ (304,144)
Revenues $ 8,625,167 $ 8,600,845
Operating Expenditures (8,693,173) (8,811,967)
Total Change in Fund Balance $ (68,006) $ (211,122)
1
City of Round Rock, Texas
Budget Revision #3
Fiscal Year 1992-1993
General Fund — Effect of the revision on fund balance:
Fund Balance (Audited) 9/30/92
Less Reserves (25% of operational requirements)
Revenue and Transfers (per this revision)
Expenses (per this revision)
Fund Balance Estimated at 9/30/93
Reserve for Swim Pool
Available, unreserved
$4,330,104
($2,703,870)
$10,511,337
($10,815,481)
$1,322,090
($1,000,000)
$322,090
Utility Fund — Effect of the revision on working capital:
Working Capital (Audited) 9/30/92 $6,002,865
Less Reserves (25% of operational requirements) ($2,202,992)
Revenue and Transfers (per this revision) $8,600,845
Expenses (per this revision) ($8,811,967)
Working Capital Estimated at 9/30/93 $3,588,751
1a
THE CITY OF ROUND ROCK, TEXAS
B
U
D
GET REVISION #3
FISCAL YEAR '1 992 1993
GENERAL FUND
Revenues
DEPARTMENT
1992-1993
Revised
Budget
1992-1993
Revised
#3
Variance
9,749,855 10, 511, 337 761,482
Executive/Administrative — 12 (309, 023) (314, 798) 5,775
Legal Services — 13 (147,600) (147,600) 0
Planning — 14 (305,624) (305,624) 0
Data Processing — 15 (56,816) (58,441) 1,625
Building Inspection — 16 (135,821) (145,028) 9,207
Finance — 17 (318,410) (318,410) 0
Purchasing — 18 (67,451) (67,451) 0
General Services — 19 (630,939) (722,564) 91,625
Library — 20 (426,325) (426,325) 0
Police — 21 (2,778,826) (2,800,676) 21,850
Fire — 22 (1,809,763) (1,833,706) 23,943
Parks & Recreation — 23 (1,151,239) (1,323,828) 172,589
Personnel — 24 (83,166) (83,166) 0
Public Works — 25 (613,947) (615,947) 2,000
Streets — 26 (1,177,409) (1,184,409) 7,000
City Shop — 28 (245,811) (248,061)
2,250
Municipal Court — 29 (219,247) (219,447) 200
Total General Fund (10,477,417) (10,815,481) 338,064
2
THE CITY OF ROUND ROCK, TEXAS
FISCAL YEAR 1992 -- 1993
UTILITY FUND
Revenues
DEPARTMENT
1992-1993
Revised
Budget
8,625,167
1992-1993
Revised
#3
Variance
8,600,845 (24, 322)
Water Treatment Plant — 41 (674,281) (730,981) 56,700
Water System Support — 42 (779,692) (777,692) (2,000)
Waterline Maintenance — 43 (519,243) (585,242) 65,999
Wastewater Treatment Plant — 61 (907,404) (899,304) (8,100)
Wastewater System Support — 62 (116,237) (126,237) 10,000
Wastewater Lines Treatment — 63 (391,100) (381,100) (10, 000)
Pre Treatment — 64 (141,871) (141,871) 0
Utility Billing & Collection — 81 (494,922) (501,117) 6,195
Debt Service & Other — 90 (173,100) (173,100) 0
Transfers — 95 (4,495,323) (4,495,323) 0
Total Utility Fund (8,693,173) (8,811,967) 118,794
3
City of Round Rock
Operating Budget Revision
Fiscal 1992 — 1993
Revenue
General Fund
10-00-000-4110
10-00-000-4115
10-00-000-4120
10-00-000-4124
10-00-000-4211
10-00-000-4214
10-00-000-4217
10-00-000-4224
10-00 —000 —4301
10-00-000-4410
10-00-000-4511
10-00-000-4517
10-00-000-4518
10-00-000-4610
10-00-000-4615
10-00-000-4639
Utility Fund
20 — 00 —000 —4443
20-00-000-4444
20-00-000-4610
20-00-000-4615
20-00-000-4629
20-00-000-4803
20 — 00 — 000 —4805
20-00-000-4823
20-00-000-4825
20 — 00 —000 —4833
Account Title
Current Property Taxes
Franchise—Lone Star Gas
Sales Tax
Bingo Tax
Garbage Collection License
Building Permits
Filing Fees
GIS Fees
Lot Clearing Services
Bldg Reinsp/Structural Steel
Police Dept. Fines & Costs
Library Miscellaneous Receipts
Child Safety Fines
Interest Income
Miscellaneous Revenue
Sale of Assets (Vehicles/Equip)
Industrial Pre—Trmt Surcharge
Connection & Transfer Fee
Interest Income
Miscellaneous Revenue
Gain/Loss on Sale of Assets
Water Taps
Water Insp & Meter Setting Fee
Sewer Taps
Sewer Inspection Fee
Meters and Fittings Sales
Justification
Continued growth in AV (residential;apartments)
Reduced because of the mild winter
Reflects rebounding economy;new businesses
New revenue this year
Reflects new franchise fee effective 1/93
Reflects increase in building activity
Reflects increase in building activity
Adjust to new estimate
Property owners are handling the responsibility
Reflects increase in building activity
Adjust to expected level of activity
Adjust to actual
Adjust to expected level of activity
Reflects decline in interest rates
Reflects insurance proceeds from barn fire
Adjust to more realistic estimate
Program still in developmental stage
Reflects adoption of new fee
Reflects decline in interest rates
Reflects telemetry bond payment
Adjust to more realistic estimate
Reflects increase in building activity
Reflects increase in building activity
Reflects increase in building activity
Reflects increase in building activity
Reflects increase in building activity
4
Budget
Increase
Decrease
65,943
(5,491)
593,456
6,500
31,242
73,221
74,085
(1,500)
(17,270)
12,695
(17,978)
300
(2,700)
(77,256)
47,897
(21,662)
761,482
(45,207)
30,000
(50,000)
14,520
(6,925)
1,875
7,620
6,900
7,015
9,880
(24,322)
City of Round Rock
Operating Budget Revision
Fiscal 1992 — 1993
Department
General Fund
Executive/Administration
10-12-000-5210
10-12-000-5211
10-12-000-5212
10-12-000-5224
10-12-000-5315
10-12-000-5316
10-12-000-5414
10-12-000-6116
Planning
10-14-000-5314
10-14-000-5318
10-14-000-5434
Data Processing
10-15-000-5317
10-15-000-5328
10-15-000-5434
Building Inspections
10-16-000-5110
10-16-000-5113
10-16-000-5115
10-16-000-5117
10-16-000-5141
10-16-000-5210
10-16-000-5316
10-16-000-5330
General Services
10-19-000-5274
10-19-000-5324
10-19-000-5328
10-19-000-81XX
10-19-000-81XX
10-19-286-5222
10-19-286-5324
Library
10-20-000-5110
10-20-000-5239
10 — 20 —000 —5283
10-20-000-5315
Account Title
Printing & Publications
Telephone
Legal Notices
Election Expenses
Supplies — Materials/Other
Supplies — Council
Dues & Subscriptions
Computer Equipment
Fuel & Lube
Postage
Travel & Training
Supplies — Data Processing
Repairs — Equipment
Travel & Training
Salaries
FICA
Insurance
TMRS
Worker's Compensation
Printing & Publications
Supplies — Office
Repairs — Motor Vehicles
Tax District Expense
Repairs — Building
Repairs — Equipment
Transfers
Transfers
Heritage Utilities
Repairs — Building
Salaries
Maint — Office Equipment
Contract Labor
Supplies/Materials — Other
Justification
Reflect growth in activity
Reflect growth in activity
Reflect growth in activity
Reflect growth in activity
Reflect growth in activity
Reflect growth in activity
Reflect growth in activity
Adjust to actual
Any further use would be Trvl/Trng related
Increase in development applications
Reflect growth in activity;restructuring of dept
Diskettes, cables, small tools, etc.
Inserter repairs & adjustments
Reflects restructure of dept; Novell Training
Reflects addition of building inspector
Reflects addition of building inspector
Reflects addition of building inspector
Reflects addition of building inspector
Reflects addition of building inspector
Reflect growth in activity;restructuring of dept
Reflect growth in activity;restructuring of dept
Adjust to actual
Adjust to actual
More repairs required than anticipated
Fewer repairs than anticipated
Community Center Improvements
Waterproof City Hall
Increase in usage
More repairs required than anticipated
Temporary services (budget correction)
Addition of second copier
Temporary services (budget correction)
Ordered fewer supplies
5
Budget
Increase
Decrease
100
175
400
100
1,000
3,000
750
250
5,775
(205)
(1,000)
1,205
0
100
100
1,425
1,625
6,310
483
379
368
167
1,500
200
(200)
9,207
1,225
1,300
(1,300)
9,500
78,000
1,700
1,200
91,625
(2,500)
300
2,500
(600)
City of Round Rock
Operating Budget Revision
Fiscal 1992 — 1993
Department
10-20-000-5324
10-20-000-5438
Police
10-21-000-5119
10-21-000-5211
10-21-000-5214
10-21-000-5265
10-21-000-5316
10-21-000-5324
10-21-000-5330
10-21-000-5334
10-21-000-6114
10-21-001-5110
10-21-001-5455
10-21-001-5201
10-21-001-5239
10-21-001-5317
10-21-001-5322
10-21-001-5323
10-21-001-5462
10-21-001-5464
10-21-001-5482
10-21-000-5483
10-21-000—New
Fire
10-22-000-5119
10-22-000-5125
10-22-000-5140
10-22-000-5330
10-22-000-5430
10-22-000-5434
10-22-000-6112
10-22-000-6113
10-22-000-6114
10-22-000-6116
10-22-000-6127
PAR D
10-23-000-5252
10-23-000-5253
10-23-000-5283
10-23-000-5313
10-23-000-5316
10-23-000-5324
10-23-000-5327
Account Title
Repairs — Building
Book Binding
Overtime
Telephone
Power & Light
Repairs — Communications
Supplies — Office
Repairs — Building
Repairs — Motor Vehicles
Uniforms
Mobile Equip/Vehicle
Salaries
Animal Boarding & Control
Maintenance Agreements
Maint — Office Equip
Supplies — Data Processing
Supplies — Invest
Supplies — Acc Invest
Officer Weapons
National Firearms
Neighborhood Watch
Youth Services
Drug Enforcement Program
Overtime
Higher Classification Pay
Longevity
Repairs — Motor Vehicles
Volunteer Fire Services
Travel & Training
Machinery & Equip
Communication Equip
Mobile Equipment/Vehicles
Computer Equipment
Computer Software
Contracted Rec Staff
Sports League Officials
Contract Labor
Pool Supplies
Supplies — Office
Building Repair
Supplies — Sports League
Justification
Reduction due to decrease in vandalism
Increase in damage to repair this year
Growth related, computer maintenance
New Plexar system costs
Increase due to larger police facility location
Increase in radio & radar repair
Expansion of office/activity
Move to larger facility
Required by older cars until all replaced
New personnel, vests not previously budgeted
Equipment for new vehicles (radar/lights)
Increased hours worked due to short staffing
Transfer to Salaries
1st year of software maint was free
Fewer repairs needed than anticipated
Fewer supplies used than anticipated
Fewer supplies used than anticipated
Fewer supplies used than anticipated
Used previous year supplies
Program not available
Decrease in activity
Decrease in activity
Participation with drug enforcement agency
Reflects open Captain position for 7 months
Open Captain position for 7 months
Adjust to actual
Reflects aging fleet;increased activity
Increase in insurance costs
Unforseen activity required
Reflect savings
No new purchases
Upgrade specifications of vehicles purchased
Increase in costs of items previously budgeted
Reflects savings
Reflects increase in activity
Growth of current programs/Sand volleyball
Bus services/Goff program
Drink concessions program (offset by revenue)
Due to increase in office equipment/activity
General maintenance & repairs on facilities
Growth of current programs/Sand volleyball
6
Budget
Increase
Decrease
(300)
600
0
5,000
1,500
3,000
500
600
500
5,000
2,000
5,000
3,500
(3,500)
(1,500)
(500)
(500)
(1,200)
(1,000)
(500)
(3,000)
(500)
(800)
8,250
21,850
6,400
6,850
(1,282)
5,000
1,000
5,000
(2,875)
(2,617)
5,992
928
(453)
23,943
300
4,100
3,950
2,250
500
1,000
2,550
City of Round Rock
Operating Budget Revision
Fiscal 1992 — 1993
Department Account Title
10-23-000-5328 Equipment Repairs
10-23-000-5329 Office Equipment — Repairs
10-23-000-5330 Repairs — Motor Vehicles
10-23-000-5347 Seed, Fertilizer
10-23-000-6110 Furniture/Office Equipment
10-23-000-6112 Machinery & Equipment
10-23-000-6114 Mobile EquipmentNehicles
10-23-000-81XX Transfers
Public Works
10-25-000-5211
10-25-000-5214
10-25-000-5286
10-25-000-5334
10-25-002-5283
10-25-002 —5334
Streets
10-26-000-5283
10-26-000-5309
10-26-002-5332
10— 26 —002-5434
City Shop
10-28-000-5315
10-28-000-5328
10-28-002-5332
10— 28-002-5334
10-28-002-5336
Municipal Court
10-29-000-5461
Telephone
Power & Light
Janitorial Supplies
Uniforms
Contract Labor
Uniforms
Contract Labor
Dumpsters
Tires & Tubes
Travel & Training
Other Materials/Supplies
Repairs — Equipment
Tires & Tubes
Uniforms
Equipment — Tools
Court Costs
Total Change — General Fund
Justification
Due to unexpected repairs on aging equipment
Due to unexpected repairs on equipment
Due to aging fleet until replaced
Good supply on hand/License requirement
Redo floor at Rabb Recreation Center
Purchase of canoe trailer to haul canoes
Reflect savings
To park development fund (for purpose of
setting up an expendable/reimbursable youth
sports account. Immediate funding will be
provided for Girls Softball Lights $10,000,
Little League Lights $35,000)
New Plexar phone system costs
Reflect move to larger building
Reflect move to larger building
Adjust to actual
Adjust to actual
Adjust to actual
Employee illness
Increase in repair activity
Older vehicles requiring more repairs
Low usage due to heavy work load
Reflects increased activity
Reflects increased activity
Adjust to actual
Adjust to actual
Reflects increased activity
Adjust to actual
7
Budget
Increase
Decrease
9,000
300
6,000
(6,000)
1,850
1,500
(4,711)
150,000
172,589
3,000
5,000
600
650
(7,000)
(250)
2,000
1,500
3,000
3,000
(500)
7,000
1,500
200
(150)
200
500
2,250
200
200
338,064
City of Round Rock
Operating Budget Revision
Fiscal 1992 — 1993
Department Account Title
Utility Fund
Water Plant
20-41-000-5119
20-41-000-5216
20-41-000-5240
Water Systems Support
20-42-000-5119
20-42-000-5331
20-42-000-5359
20-42-000-6113
Water Lines Maintenance
20-43-000-5119
20-43-000-5119
20-43-000-5119
20-43-000-5119
20-43-000-5119
20-43-000-5119
20-43-000-5315
20-43-000-5328
20-43-000-5330
20-43-000-5334
20-43-000-5344
Wastewater Plant
20-61-000-5374
20-61-000-5434
Overtime
Professional Services
Legal Fees
Overtime
Repairs — Meters
Telemetry Services
Communications Equipment
Insurance
Overtime
Salaries
FICA
TMRS
Worker's Compensation
Other — Materials/Supplies
Repairs — Equipment
Repairs — Motor Vehicles
Uniforms
R & M — Lines
Chemical Analysis
Travel & Training
Wastewater Systems Support
20-62-000-5214 Power & Light
Wastewater Line Maintenance
20-63-000-5119 Overtime
Utility Billing & Collection
20-81-000-5210
20-81-000-5280
20-81-000-5315
20-81-000-5316
20-81-000-5317
20-81-000-5318
20-81-000-5324
Printing & Publications
Armored Car Service
Other — Materials/Supplies
Supplies — Office
Supplies — Data Processing
Postage
Repairs — Building
Total Change — Utility Fund
Justification
Reflects increased activity
Brushy Creek MUD rate case—expert testimony
Brushy Creek MUD rate case
Adjust to actual
Reflects increased activity
Equipment newer, requiring Tess repairs
Trunk 2—way radios for after hours usage
Increase in personnel
Working 24 hr shifts/reflects activity
Increase in personnel
Increase in personnel
Increase in personnel
Increase in personnel
Adjust to actual
Unforseen repairs due to increased activity
Reflects aging fleet
Increase in personnel
Growth in building activity in city
Fewer supplies required
Adjust to actual
Adjust to actual requirement
Adjust to actual
Reflects Cycle Billing—printing of notices,etc
Reflects increase in fees
Extra bill inserts/cycle billing
Adjust to actual
Reflects increased activity
Reflects Cycle Billing—mailing notices ,etc
Reflects required maintenance
8
Budget
Increase
Decrease
800
20,000
35,900
56,700
(4,500)
2,500
(2,440)
2,440
(2,000)
1,512
20,000
12,807
980
747
601
100
500
3,500
252
25,000
65,999
(7,100)
(1,000)
(8,100)
10,000
10,000
(10,000)
(10,000)
1,400
445
500
(1,400)
450
4,300
500
6,195
118,794
DATE: July 16, 1993
SUBJECT: City Council Meeting, July 20, 1993
ITEM: 8.A. Consider an ordinance amending the 1992-1993 Operating Budget.
(Second Reading)
STAFF RESOURCE PERSON: David Kautz
STAFF RECOMMENDATION:
The proposed budget revision is completely detailed on the attached pages.
Highlights of the revision are described below:
General Fund
Revenue: led by a very strong sales tax performance, will increase by
Expenditures: are scheduled to increase by
—A new building inspector is being added (Dept 10-16) $7,707
— Additional transfer to fund improvements to the Community Center
(Dept 10-19) $9,500
— Fund the Waterproofing of City Hall $78,000
—Fund a Drug Enforcement Officer to work with the DEA $8,250
— Transfer designated fund balance to the Park Development Fund for
Youth Sports. Immediate expenditures are scheduled as follows:
$10,000
Girls Softball lights $37,000
Little League lights $103,000
— In genereBalance to transfer to Park Dev. Fund
of increased operational activity. $84,607
Total General Fund Expenditure increases
Utility Fund
Revenue: Expected to decrease slightly because of declining interest
rates; continued low water sales; not yet fully developed industrial
pre—treatment program.
Expenditures are scheduled to increase by
—Water rate case filed by Brushy Creek MUD, additional
professional/legal expenses $55,900
— Three new utility maintenance positions created (funding to Oct) 15,135
—In general, other operating expenditures are increasing as a result
of increased operational activity. $47,759
Total Utility Fund Expenditure increases
$761,482
$338,064
_($24,322)
$118,794