Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
G-94-05-12-10A - 5/12/1994
r� ORDINANCE NO. - - 65- I vS - /o,q AN ORDINANCE PROVIDING FOR THE REVISION OF THE BUDGET OF THE CITY OF ROUND ROCK, TEXAS FOR FISCAL YEAR 1993-94. 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 1993-1994 is hereby revised for municipal purposes pursuant to §102.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. ) p READ and APPROVED on first reading this the day of 0 -PA -1,--b, 1994. READ, APPROVED and ADOPTED on second reading this the /i0V day of )/ ATTEST: a/m a, LL e,' E LAND, City Secretary KS/ORDINANCES OR04284A , 1994. CHARLES CULPE'PE Mayor City of Round Rock, Texas BUDGET REVISION -1993/1994 REVENUE HIGHLIGHTS FUND DESCRIPTION ORIGINAL BUDGET REVISION GENERAL FUND UTILITY FUND SALES TAX BUILDING PERMITS FILING FEES SUBDIVISION INSPECTION FEE LOT CLEARING SERVICES PATROL CAR INSURANCE REIMBURSEMENT RECREATION, SPORTS PROGRAMS LEASE PROCEEDS -TRUNKED RADIO SYSTEM STRUCTURAL STEEL INSPECTION TOTAL REVISED REVENUE WATER SERVICE METERS & FITTING SALES $4,383,265 $168,236 $70,000 $25,000 $5,500 $188,054 $24,300 $4,960,000 $20,000 $323,000 $20,000 $40,000 $50,000 $2,000 $10,000 $21,141 $1,325,000 $5,000 $1,796,141 $477,904 $20,000 TOTAL REVISED REVENUE $497,904 1 BUDGET REVISION -1993/1994 EXPENDITURE HIGHLIGHTS FOR DISCUSSION GENERAL FUND ORIGINAL DEPARTMENT DESCRIPTION BUDGET AMOUNT ADMINISTRATION/ COMPUTER & SCANNER $2,200 COUNCIL SUBTOTAL $337,539 $2,200 PLANNING CITY WIDE TRAFFIC STUDY $25,000 ROAD IMPACT FEE STUDY $10,000 ADDRESSING PROJECT -APPRAISAL DISTRICT $9,000 SUBTOTAL $321,752 $44,000 BUILDING PRINTING COSTS -GROWTH RELATED $500 INSPECTION TELEPHONE ADJUSTMENT $1,000 SUPPLIES & REPAIRS $1,000 LIBRARY POLICE FIRE PARKS SUBTOTAL $207,603 $2,500 COMPUTER BACKUP, MONITOR, DISKS $2,070 LONGEVITY CORRECTION $904 SUBTOTAL $497,306 $2,974 DISPATCH/COURT COMPUTER EXPANSION $24,225 VEHICLE REPAIRS & MISCELLANEOUS $14,700 REPLACEMENT PATROL CAR $16,900 5 ADDITIONAL OFFICERS $82,000 VEHICLES FOR NEW OFFICERS $46,750 EQUIPMENT FOR NEW OFFICERS $2,900 SUBTOTAL $2,736,180 $187,475 PRIVACY FENCE FOR SECURITY $2,400 STORAGE BUILDING TO COVER GENERATOR $3,000 HURST TOOL HEAD -JAWS RELATED $9,400 PUBLIC EDUCATORS' CONFERENCE $4,400 SUBTOTAL $1,844,536 $19,200 RABB HOUSE BALCONY STRUCTURAL REPAIRS $17,000 SPORTS LEAGUES INCREASED PROGRAMS $1,303 BUS TRANSPORTATION -YOUTH PROGRAMS $8,678 POOL CONCESSIONS $3,000 SPECIAL EVENTS -JULY 4TH ETC. $16,700 PARD MOVE TO HERITAGE WOODS $100,000 SUBTOTAL $1,367,053 $146,681 PUBLIC POWER & LIGHT -ADDITIONAL BUILDING $10,460 WORKS VEHICLE REPAIRS $700 DEMOLITION CONTRACT $8,188 STREETS SUBTOTAL ADDITIONAL STREET STRIPING REQUIREMENTS REPAIRS DUE TO AGE OF EQUIPMENT COMPACTION MACHINES TO IMPROVE STREET REPAIR PROCESS SUBTOTAL $658,936 $19,348 $1,618 $5,000 $14,139 $1,314,719 $20,757 BUDGET REVISION -1993/1994 EXPENDITURE HIGHLIGHTS FOR DISCUSSION GENERAL FUND DEPARTMENT SHOP ORIGINAL DESCRIPTION BUDGET AMOUNT ROOF REPLACEMENT AT MAINTENANCE SHOP $6,000 UNIFORMS $1,139 FUEL TANKS -LEAK DETECTION COMPLIANCE $24,000 SUBTOTAL $237,589 $31,139 MUNICIPAL STATE COURT COSTS TO ACTUAL $20,000 COURT V.O.E. STUDENT PROGRAM THROUGH SUMMER $2,130 SUBTOTAL $268,928 $22,130 GENERAL 800 MHZ TRUNKED RADIO SYSTEM $1,325,000 GOVERNMENT PRE-EMPLOYMENT SCREENING $2,230 PROPERTY & LIABILITY INSURANCE $2,700 FLOOD INSURANCE $3,100 TRANSFER FOR CHILD SAFETY PROGRAM $15,000 CORRECTION TO FICA TAXES $3,400 STREET LIGHTING IMPROVEMENTS $133,000 VIDEO PRODUCTION EQUIPMENT $12,000 SUBTOTAL $738,578 $1,496,430 HEALTH TRANSFER TO SELF-FUNDED HEALTH INSURANCE INSURANCE FUND $56,250 NET AGAINST PERSONNEL COSTS BUDGET ($56,250) NET BUDGET CHANGE $0 GRAND TOTAL $1,994,834 NOTE --DETAILS PROVIDED IN ATTACHED BUDGET REVISION DOCUMENT. BUDGET REVISION -1993/1994 EXPENDITURE HIGHLIGHTS FOR DISCUSSION UTILITY FUND ORIGINAL DEPARTMENT DESCRIPTION BUDGET AMOUNT WATER DEPT. OF HEALTH TESTING FEE INCREASE $4,600 TREATMENT CHEMICALS -NEW STATE REGULATIONS $48,000 PLANT SUBTOTAL $740,108 $52,600 WATER SYSTEM POWER & LIGHT $45,000 SUPPORT MOTOR VEHICLE REPAIRS $1,753 METERS -BUDGET REQUIREMENTS & GROWTH, NET $58,840 SUBTOTAL $908,701 $105,593 WATER LINE OVERTIME -INCREASE $18,042 MAINTENANCE ADDITION OF CERTIFICATION PAY $540 CONTRACT LABOR -CONCRETE WORK $16,980 SUPPLIES -BULK PURCHASING $4,292 EQUIPMENT REPAIRS $8,000 AGING LINES MAINTENANCE $19,993 TRAINING -FIRE HYDRANT SCHOOL $1,500 SUBTOTAL $877,336 $69,347 WASTEWATER REPAIRS -SLUDGE BELT PRESS $10,000 TREATMENT SLUDGE -INCIDENT OF HIGH LEVEL CONTAMINATION $6,000 PLANT TEXAS WATER COMMISSION INSPECTIONS $1,700 REPAIRS -BLOWER & BEARING WORK $5,000 SUBTOTAL $971,100 $22,700 WASTEWATER REPAIRS -LIFT STATIONS $3,560 SYSTEM TELEMETRY -OAK BLUFF, FOREST CREEK $8,300 SUPPORT PUMP & CONTROLS -OAK BLUFF LIFT STATION $14,000 ADDITIONAL PUMP -MEADOWS LIFT STATION $16,200 SUBTOTAL $148,425 $42,060 WASTEWATER AIR CONDITIONING REPLACEMENT IN LABORATORY $2,500 LINE ADDITION OF CERTIFICATION PAY $240 MAINTENANCE SUBTOTAL $358,762 $2,740 UTILITY PROPERTY & LIABILITY INSURANCE $2,900 BILLING SUBTOTAL $538,509 $2,900 GENERAL LEGAL FEES -UTILITY MATTERS $32,000 PROPERTY & LIABILITY INSURANCE $9,500 FLOOD INSURANCE $3,300 PURCHASE -ROUND ROCK WATER SUPPLY ASSETS $125,000 PRE-EMPLOYMENT SCREENING $918 SUBTOTAL $170,718 BUDGET REVISION -1993/1994 EXPENDITURE HIGHLIGHTS FOR DISCUSSION UTILITY FUND ORIGINAL DEPARTMENT DESCRIPTION BUDGET AMOUNT HEALTH TRANSFER TO SELF-FUNDED HEALTH INSURANCE INSURANCE FUND $18,750 NET AGAINST PERSONNEL COSTS BUDGET ($18,750) NET BUDGET CHANGE $0 GRAND TOTAL $468,658 NOTE --DETAILS PROVIDED IN ATTACHED BUDGET REVISION DOCUMENT. 800 mhz trunked radio system Preliminary cost figures have been established for a city—wide trunked radio system. The system would provide upgraded radio communication service to all City departments and would also comply with the Federal Communications Commission efforts to narrow radio band widths over the next few years. The system would most feasibly be financed through a lease—purchase over 5 to 7 years as follows: System "backbone" cost $530,000 (includes repeaters, antenna system, backup site, console and computer operating system) Building to house the "backbone" $30,000 Backup generator $10,000 Radios (for all departments) $680,000 Contingency costs $75,000 Total costs projected for equipment, installation $1,325,000 Financing provided by lease purchase proceeds $1,325,000 Annual debt service requirements for 5 years $315,000 Annual maintenance and licensing costs could be required $69,000 (future years impact) The radio team will continue researching the most cost—effective and advantageous method of implementing the system (at once or over a period of years) 6 THE CITY OF ROUND ROCK, TEXAS 7 THE CITY OF ROUND ROCK, TEXAS GENERAL FUND Revenues Expenditures Total Change in Fund Balance $ 10,735 $ (188,538) 1993-1994 1993-1994 Revised Budget #1 $ 11,259,516 $ 13,055,657 (11,248,781) (13,244,195) UTILITY FUND Revenues $ 8,844,339 $ 9,342,243 Operating Expenditures (9,392,250) (9,860,908) Total Change in Fund Balance $ (547,911) $ (518,665) 8 THE CITY OF ROUND ROCK, TEXAS General Fund - Effect of the revision on fund balance: Audited Fund Balance 9/30/93 Less Reserves ( *1) Estimated Revenue (FY 1993-1994) Interfund Transfers Total Funds Available Budgeted Expenditures $ 5,119,893 $ (3,979,800) $ 12,155,657 $ 900,000 $ 14,195,750 $ (13,244,195) Estimated Fund Balance 9/30/94 $ 951,555 *1 Reserves are established in accordance with operating reserve policies and the $1,000,000 reserve for swimming pool. Utility Fund - Effect of the revision on cash balances: Audited Cash Balance 9/30/93 Less Reserves ( *2) Estimated Revenue (FY 1993-1994) $ 5,693,004 $ (2,465,227) $ 9,342,243 Other Financing Sources - Scheduled application of impact fees $ 550,000 Interfund Transfers $ (4,564,321) Total Funds Available $ 8,555,699 Budgeted Expenditures $ (5,296,587) Estimated Cash Balance 9/30/94 $ 3,259,112 *2 Reserves are established in accordance with operating reserve policies . 9 THE CITY OF ROUND ROCK, TEXAS GENERAL FUND Revenues DEPARTMENT 1993-1994 Budget 11,259,516 1993-1994 Revised #1 Variance 13,055,657 1,796,141 Executive/Administrative - 12 (337,529) (343,129) 5,600 Legal Services - 13 (165,100) (165,100) 0 Planning - 14 (321,752) (365,752) 44,000 Data Processing - 15 (53,173) (53,353) 180 Building Inspection - 16 (207,603) (210,103) 2,500 Finance - 17 (349,020) (349,020) 0 Purchasing - 18 (77,430) (77,430) 0 General Services - 19 (738,578) (758,608) 20,030 Library - 20 (497,306) (500,280) 2,974 Police - 21 (2,736,180) (2,923,655) 187,475 Fire - 22 (1,844,536) (1,863,736) 19,200 Parks & Recreation - 23 (1,367,053) (1,513,734) 146,681 Personnel - 24 (73,349) (73,749) 400 Public Works - 25 (658,936) (678,284) 19,348 Streets - 26 (1,314,719) (1,335,476) 20,757 City Shop - 28 (237,589) (268,728) 31,139 Municipal Court - 29 (268,928) (291,058) 22,130 General Government - Other 0 (1,473,000) 1,473,000 Total Expenditures (11,248,781) (13,244,195) 1,995,414 10 THE CITY OF ROUND ROCK, TEXAS UTILITY FUND Revenues DEPARTMENT 1993-1994 Budget 8,844,339 1993-1994 Revised #1 Variance 9,342,243 497,904 Water Treatment Plant - 41 (740,108) (838,426) 98,318 Water System Support - 42 (908,701) (1,014,294) 105,593 Waterline Maintenance - 43 (877,336) (946,683) 69,347 Wastewater Treatment Plant - 61 (971,100) (993,800) 22,700 Wastewater System Support - 62 (148,425) (190,485) 42,060 Wastewater Lines Maintenance - 63 (358,762) (361,502) 2,740 Pre Treatment - 64 (203,888) (203,888) 0 Utility Billing & Collection - 81 (538,509) (541,409) 2,900 Debt Service & Other - 90 (81,100) (81,100) 0 Transfers - 95 (4,564,321) (4,564,321) 0 General Government - Other 0 (125,000) 125,000 Total Expenditures (9,392,250) (9,860,908) 468,658 11 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Revenue General Fund 10-00-000-4120 10-00-000-4214 10-00-000-4217 10-00-000-4225 10-00-000-4301 10-00-000-4403 10-00-000-4404 10-00-000-4405 10-00-000-4410 10-00-000-4615 10-00-000-4616 Utility Fund Account Title Sales Tax Building Permits Filing Fees Subdivision Fees Lot Clearing Recreation Programs Swimming Pool Receipts Sports League Fees Structural Steel Inspections Miscellaneous Revenue Capitalized Lease Proceeds 20-00-000-4804 Water Service 20-00-000-4833 Meters & Fitting Sales Explanation Reflects growth; new businesses Increase in building activity Increase in building activity Increase in building activity Increased activity July 4th & special events Concession sales Increase in participation Increase in building activity Insurance reimbursement - patrol car 800 MHZ trunked radio system Budget Increase (Decrease) 323,000 20,000 40,000 50,000 2,000 14,034 4,000 3,107 5,000 10,000 1,325,000 1,796,141 Reflects increased consumption & climate conditions 477,904 Reflects increased consumption & climate conditions 20,000 12 497,904 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Account Title General Fund Executive/Administration 10-12-000-5110 Salaries 10-12-000-5113 FICA 10-12-000-6116 Computer Equipment Legal 10-13-000-5250 Legal Fees 10-13-000-5251 Litigation Planning 10-14-000-5216 10-14-000-5240 10-14-000-5316 10-14-000-5352 10-14-000-5465 10-14-000-6127 Data Processing 10-15-000-5317 10-15-000-5328 10-15-000-5434 10-15-000-6116 Building Inspections 10-16-000-5210 10-16-000-5211 10-16-000-5316 10-16-000-5328 10-16-000-6113 Finance 10-17-000-5216 10-17-000-5434 General Services 10-19-000-5416 10-19-000-5416 10-19-000-5458 10-19-000-6112 Library 10-20-000-5140 10-20-000-5315 10-20-000-5317 10-20-000-5328 10-20-008-6110 10-20-000-6116 Professional Services Maint Contract - Computers Supplies - Office Printing & Reproduction Comprehensive Plan Revision Computer Software Supplies - Data Processing Repairs - Equipment Training & Transportation Computer Equipment Printing & Publications Telephone Supplies - Office Repairs - Equipment Communication Equipment Professional Services Training & Transportation Insurance - General Liability Insurance - General Liability Contingency Machinery & Equipment Longevity Supplies/Materials - Other Supplies - Data Processing Repairs - Equipment Office Equipment Computer Equipment Explanation Budget correction Correction to FICA taxes Computer & Scanner Adjust to actual Adjust to actual Traffic & impact fee studies, addressing project PC -Arc Info Service phased out - new software Adjust to actual Adjust to actual Adjust to actual PC -Arc Info Service phased out - new software Adjust to actual Adjust to actual Novell training/mileage Adjust to actual Adjust to actual Adjust to actual Adjust to actual Adjust to actual Bag phone Adjust to actual Continuing education requirements for licensing Property & casualty Flood insurance Pre Employment Screening Video projection equipment Adjust to actual Book processing supplies for donated books Supplies costing more than budgeted Replacing some equipment Cover over -expenditure of photocopier MAC monitor, tape cartridge backup system 13 Budget Increase (Decrease) 1,600 1,800 2,200 5,600 (13,000) 13,000 0 44,000 (1,800) 1,200 (600) (600) 1,800 44,000 (276) (150) 480 126 180 500 1,000 300 300 400 2,500 (1,000) 1,000 0 2,700 3,100 2,230 12,000 20,030 904 500 100 (1,280) 680 2,070 2,974 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Police 10-21-000-5119 10-21-000-5120 10-21-000-5240 10-21-000-5330 10-21-005-5460 10-21-001-5119 10-21-001-5334 10-21-005-5330 10-21-001-5455 10-21-001-5314 10-21-005-5288 10-21-005-5314 10-21-005-5434 10-21-006-5314 10-21-007-5314 10-21-007-5434 10-21-007-5482 10-21-007-5437 10-21-006-5437 10-21-007-5483 10-21-006-5322 10-21-005-5323 10-21-006-5120 10-21-005-6114 10-21-000-6116 NEW NEW NEW Fire 10-22-000-5120 10-22-000-5211 10-22-000-5213 10-22-000-5265 10-22-000-5314 10-22-000-5316 10-22-000-5318 10-22-000-5329 10-22-000-5330 10-22-000-5352 10-22-000-5434 10-22-000-5458 10-22-000-6113 10-22-000-6127 10-22-011-5110 Account Title Overtime Professional Pay Maint - Computer System Repairs - Motor Vehicles Car Wash Overtime Uniforms Repairs - Motor Vehicles Animal Boarding & Control Fuel & Lube Detention of Prisoners Fuel & Lube Training & Transportation Fuel & Lube Fuel & Lube Training & Transportation Neighborhood Watch Psychological Testing Psychological Testing Youth Services Supplies - Investigations Supplies - ACC Investigations Professional Pay Mobile Equipment Computer Equipment Professsional Pay Telephone Equipment - Rent/Lease Repairs - Communication Fuel & Lube Supplies - Office Postage Repairs - Office Equipment Repairs - Motor Vehicles Printing & Reproduction Training & Transportation Contingency Communication Equipment Computer Software Salaries Explanation High turnover rate, fill for sick, holiday, etc. Transfer of staff Increase by provider Addition of one vehicle New vendor - higher fee Increase in work call -out & injuries Turnover in personnel Increased cost of parts & minor accidents Less fees - boarding New vehicles - better mileage Fewer expenses New vehicles - better mileage Adjust to actual New vehicles - better mileage New vehicles - better mileage Adjust to actual Adjust to actual Fewer cases Fewer cases Fewer cases Adjust to actual Adjust to actual Transfer of staff Replace patrol vehicle Dispatch/Court expansion 5 additional officers Vehicles for new officers Equipment for new officers Transfer personnel from 012 Adjust to actual Additional pager lease Adjust to actual Adjust to actual Adjust for administrative cost Adjust to actual Adjust to actual New admin vehicles - warranty Adjust to actual Administration travel, Chief, Fire Marshal Adjust to actual Small amount of equipment in administration Delay purchase Adjust to actual 14 Budget Increase (Decrease) 4,500 600 7,400 500 1,200 1,500 1,000 16,000 (5,000) (500) (500) (2,500) (2,000) (1,000) (1,500) (500) (500) (800) (800) (500) (800) (500) (600) 16,900 24,225 82,000 46,750 2,900 187,475 840 683 175 (175) (742) 422 (150) (450) (2,039) (66) 4,915 1,325 (500) (648) (2,111) City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Account Title 10-22-011-5125 Higher Classification Pay 10-22-011-5211 Telephone 10-22-011-5214 Power & Light 10-22-011-5265 Repairs - Communication 10-22-011-5314 Fuel & Lube 10-22-011-5315 Supplies/Materials -Other 10-22-011-5316 Supplies - Office 10-22-011-5321 Supplies - Janitorial 10-22-011-5324 Repairs - Building 10-22-011-5330 Repairs - Motor Vehicles 10-22-011-5434 Training & Transportation 10-22-011-5458 Contingency 10-22-011-6112 Equipment & Machinery 10-22-011-6113 Communication Equipment 10-22-011-6116 Computer Equipment 10-22-012-5110 Salaries 10-22-012-5120 Professional Pay 10-22-012-5125 Higher Classification Pay 10-22-012-5211 Telephone 10-22-012-5214 Power & Light 10-22-012-5265 Repairs - Communication 10-22-012-5314 Fuel & Lube 10-22-012-5315 Supplies/Materials -Other 10-22-012-5316 Supplies - Office 10-22-012-5321 Supplies - Janitorial 10-22-012-5324 Repairs - Building 10-22-012-5330 Repairs - Motor Vehicles 10-22-012-5334 Uniforms 10-22-012-5434 Training & Transportation 10-22-012-5458 Contingency 10-22-013-5211 Telephone 10-22-013-5214 Power & Light 10-22-013-5265 Repairs - Communication 10-22-013-5314 Fuel & Lube 10-22-013-5315 Supplies/Materials -Other 10-22-013-5316 Supplies - Office 10-22-013-5321 Supplies - Janitorial 10-22-013-5324 Repairs - Building 10-22-013-5330 Repairs - Motor Vehicles 10-22-013-5334 Uniforms 10-22-013-5434 Training & Transportation 10-22-013-5458 Contingency 10-22-013-6113 Communication Equipment 10-22-013-6116 Computer Equipment 10-22-020-5352 Printing & Reproduction 10-22-020-5354 Supplies - Emergency Mgt 10-22-020-5431 Fire Prevention 10-22-020-5458 Contingency NEW Explanation Adjust to actual Adjust to actual Added energy efficient system Adjust to actual Adjust to actual Adjust to actual Adjust to actual Adjust to actual Leaks in roof at Central Station Adjust to actual Adjust to number of personnel at Central Adjust to actual Adjust for David Clark System for E -I Adjust to actual Delay purchase Adjust to actual Transfer personnel to 000 Adjust to actual Less phone usage at sub -station Fewer square feet at Station #2 Adjust to actual Adjust to actual Adjust to actual Adjust to actual Adjust to actual Central Station roof repairs Increased alarms for Engine 2 Fewer uniforms being purchased Adjust to actual Adjust to actual Decreased phone usage New station - more energy efficeint Adjust to actual Decrease for less equipment Adjust to actual Adjust to actual Adjust to actual New building - fewer repairs Fewer repairs Fewer uniforms being purchased Annual Haz-Mat & Fire & Rescue School Adjust to actual Delay purchase Adjust to actual Adjust to actual Adjust to actual Adjust to actual Adjust to actual Privacy fence for security 15 Budget Increase (Decrease) 2,111 (280) (2,540) 292 (2,227) 900 104 (480) 3,000 (909) 3,334 5,600 3,500 (950) (650) (305) (840) 305 (1,177) (937) (337) (990) 625 (253) (255) (579) 908 (325) 1,147 936 (1,043) (937) (587) (989) 222 (429) (262) (500) (2,571) (122) 1,029 149 (900) (3,500) (1,100) 200 353 780 2,400 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department NEW NEW NEW PARD 10-23-000-5201 10-23-000-5316 10-23-003-5110 10-23-003-5113 10-23-003-5141 10-23-003-5142 10-23-003-5283 10-23-003-5315 10-23-003-5328 10-23-003-5334 10-23-003-5347 10-23-003-5390 10-23-003-5391 10-23-003-5393 10-23-003-6112 10-23-003-6113 10-23-004-5253 10-23-000-5110 10-23-004-5283 10-23-004-5424 10-23-004-5313 10-23-000-8155 Account Title Maintenance Agreements Office Supplies Salaries FICA Workers Compensation TEC Contract Labor Supplies/Materials - Other Repairs - Equipment Uniforms Seed & Fertilizer Athletic Facility Maintenance Supplies - Irrigation Facility Maintenance Machinery & Equipment Communication Equipment Sports League Officials Salaries Contract Labor Special Events & Programs Supplies - Pool Transfer to Self -Financed Const Personnel 10-24-000-5316 Supplies - Office Public Works 10-25-000-5214 10-25-002-5283 10-25-002-5330 Streets 10-26-000-5213 10-26-000-5228 10-26-000-5330 10-26-000-5356 10-26-000-5358 10-26-000-6112 Power & Light Contract Labor Repairs - Motor Vehicles Equipment - Rent/Lease Striping Contract Repairs - Motor Vehicles Traffic Signs Barricades Machinery & Equipment City Shop 10-28-000-5324 Repairs - Building 10-28-000-5334 Uniforms NEW Explanation Storage building for generator Hurst Tool Head Training - Public Educators Conference Adjust To Actual Used 82% of budget Cemetery - transfer from contract labor Cemetery - transfer from contract labor Cemetery - transfer from contract labor Cemetery - transfer from contract labor Cemetery - transfer to salary accounts Cemetery - transfer from contract labor Unexpected repairs Cemetery Adjust to actual Adjust to actual Additional repairs due to line breaks Rabb Balcony - structural repairs Cemetery - trailer, mower. blower Cemetery - radio Increase in participation Temporary service due to turnover Bus transportation- youth programs July 4th & Special Events Concession costs Move to Heritage Woods Computer upgrades Reflect move to larger building Demolition Contract Adjust to actual 3 additional pagers Increase due to striping of McNeil Rd Older vehicles requiring more repairs Adjust to actual Adjust to actual Compaction & Street repair equipment Replace city garage roof Adjust to actual Fuel site upgrades 16 Budget Increase (Decrease) 3,000 9,400 4,400 19,200 (500) 500 5,953 649 377 42 (11,500) 1,439 1,700 140 (1,250) (1,250) 800 17,000 2,300 600 1,303 (1,167) 9,845 16,700 3,000 100,000 146,681 400 400 10,460 8,188 700 19,348 118 5,000 5,000 (2,000) (1,500) 14,139 20,757 6,000 1,139 24,000 31,139 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Account Title Municipal Court 10-29-000-5461 Court Costs General Government Health Insurance Texas Employment Commission Salaries Street Lighting Trunk Radio System Child Safety Program Total Change - General Fund Explanation State Court costs to actual V.O.E. Student program through summer Transfer to self-funded Health Insurance Fund TEC rate increase Net against personnel costs budget Street lighting improvements 800 MHZ trunked radio system Transfer for child safety program 17 Budget Increase (Decrease) 20,000 2,130 22,130 56,250 22,351 (78,601) 133,000 1,325,000 15,000 1,473,000 1,995,414 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Utility Fund Water Plant 20-41-000-5312 20-41-000-5315 20-41-000-5250 20-41-000-5342 20-41-000-5376 20-41-000-5416 20-41-000-5416 20-41-000-5458 Account Title Chemicals Supplies/Materials - Other Legal Fees R & M - Plant & Equipment TDH Testing Insurance - General Liability Insurance - General Liability Contingency Water Systems Support 20-42-000-5118 20-42-000-5110 20-42-000-5120 20-42-000-5214 20-42-000-5330 20-42-000-6119 Stand-by Pay Salaries Professional Pay Power & Light Repairs - Motor Vehicles Water Meters/Lines Water Lines Maintenance 20-43-000-5119 20-43-000-5120 20-43-000-5210 20-43-000-5283 20-43-000-5315 20-43-000-5328 20-43-000-5344 20-43-000-5358 20-43-000-5434 Wastewater Plant 20-61-000-5221 20-61-000-5345 20-61-000-5377 20-61-010-5345 Overtime Professional Pay Printing & Publications Contract Labor Supplies/Materials - Other Repairs - Equipment R&M - Lines Barricades Training & Transportation Sludge Disposal R & M - Plant & Equipment Tx Water Comm - Inspection R & M - Plant & Equipment Wastewater Systems Support 20-62-000-5118 20-62-000-5120 20-62-000-5340 20-62-000-6112 20-62-000-6112 20-62-000-6112 Stand-by Pay Professional Pay R & M Lift Stations Machinery & Equipment Machinery & Equipment Machinery & Equipment Wastewater Line Maintenance 20-63-000-5120 Professional Pay 20-63-000-6112 Machinery & Equipment Explanation New State regulations Adjust to actual Utility matters Adjust to actual Department of Health testing fee increase Property & casualty Flood insurance Pre-employment screening Adjust to actual Adjust for building maintenance Addition of certification pay Adjust to actual Adjust to actual Meters, budget requirements & growth Overtime - increase Addition of certification pay Adjust to actual Concrete repair increases Adjust to actual Adjust to actual Aging lines maintenance Growth in building activity in City Fire hydrant school Incident of high level contamination Blower & bearing work required Adjust to actual Sludge belt press repairs Adjust to actual Addition of certification pay Repairs - lift stations Telemetry - Oak Bluff, Forest Creek Additional pump at Meadows lift station Pump & controls - Oak Bluff lift station Addition of certification pay Air conditioning replacement in laboratory 18 Budget Increase (Decrease) 48,000 1,500 32,000 (1,500) 4,600 9,500 3,300 918 98,318 200 (4,100) 240 45,000 1,753 62,500 105,593 18,042 540 (1,100) 16,980 4,292 8,000 25,093 (4,000) 1,500 69,347 6,000 5,000 1,700 10,000 22,700 (200) 180 3,580 8,300 16,200 14,000 42,060 240 2,500 2,740 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Account Title Environmental Services 20-64-000-5328 Repairs - Equipment 20-64-000-6112 Machinery & Equipment Utility Billing & Collection 20-81-000-5110 20-81-000-5216 20-81-000-5277 20-81-000-5330 20-81-000-5416 Salaries Professional Services Bank Service Fees Repairs - Motor Vehicles Insurance - General Liability General Government Health Insurance Texas Employment Commission Salaries Round Rock Water Supply Total Change - Utility Fund Explanation Adjust to actual Upgrade a/c unit/ sampling unit Temporary service due to turnover Temporary service due to turnover Adjust to actual Adjust to actual Property & casualty Transfer to self-funded Health Insurance Fund TEC rate increase Net against personnel costs budget Purchase of assets - Round Rock Water Supply 19 Budget Increase (Decrease) (2,500) 2,500 0 (3,000) 3,000 (900) 900 2,900 2,900 18,750 6,538 (25,288) 125,000 125,000 468,658 DATE: May 10, 1994 SUBJECT: City Council Meeting, May 12, 1994 ITEM: 10. A. Consider an ordinance amending the 1993-1994 Operating Budget (Second Reading) STAFF RESOURCE PERSON: Bob Bennett, David Kautz NARRATIVE AND STAFF RECOMMENDATION: The City's current strong growth environment has created opportunities and necessities which have substantial budget implications. Growth in the property tax base and commercial sales tax will continue to reduce the Effective Property Tax Rate for next year and the year after. The extent the Effective Tax Rate will decrease is dependent upon several factors: a) any new debt issues b) the final certified value of the property tax roll c) additional property tax exemptions d) growth in taxable retail sales In addition to a declining tax rate, the City is experiencing substantial growth—related revenue collections. The increased revenue, used appropriately, can provide funding for immediate operating needs as well as provide resources for longer term operating needs. In order to maintain current levels of service and adequately prepare for continued growth, the attached operating budget amendments are provided for the Council's consideration. A complete discussion of the attached items as well as longer term budget implications will also be available at the meeting. STATE OF TEXAS COUNTY OF WILLIAMSON CITY OF ROUND ROCK * * voL.2532P!GEO3Q1 I, JOANNE LAND, Assistant City Manager/City Secretary of the City of Round Rock, Texas do hereby certify that the above and foregoing is a true and correct copy of an ordinance passed and adopted by the City Council of the City of Round $ock, Texas, at L 1 two meetings held on the (;R : day of / /-Gb _ 19 C Li);)_/1—k-' '� \, and the / day of 19 which isrecorded in the minutes of the City of Round Rock in book ,31 WITNESSED by my hand and seal of the City of Round Rock, �_- Texas on this / 1 4_LLi day of �CL7� , 19 1 , ANNE LAND sistant City Manager/ City Secretary OFF CiAL RECORDS t7IILLifaTii COUNTY, TEM VOL.2532PaGEO3O2 ORDINANCE NO. . - - Ob - I - /0/q AN ORDINANCE PROVIDING FOR THE REVISION OF THE BUDGET OF THE CITY OF ROUND ROCK, TEXAS FOR FISCAL YEAR 1993-94. 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 1993-1994 is hereby revised for municipal purposes pursuant to §102.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. READ and APPROVED on first reading this the Yth day of � , 1994. READ, APPROVED and ADOPTED on second reading this the igh day of 17) � 1994. ATTEST: CSL,kunciL LAND, City Secretary KS/ORDINANCES 0R04284A CHARLES CULPE PE Mayor City of Round Rock, Texas BUDGET REVISION -1993/1994 REVENUE HIGHLIGHTS FUND DESCRIPTION YOL.2532PQGEO3O3 ORIGINAL BUDGET REVISION GENERAL FUND UTILITY FUND SALES TAX BUILDING PERMITS FILING FEES SUBDIVISION INSPECTION FEE LOT CLEARING SERVICES PATROL CAR INSURANCE REIMBURSEMENT RECREATION, SPORTS PROGRAMS LEASE PROCEEDS -TRUNKED RADIO SYSTEM STRUCTURAL STEEL INSPECTION TOTAL REVISED REVENUE WATER SERVICE METERS & FITTING SALES TOTAL REVISED REVENUE 1 $4,383,265 $168,236 $70,000 $25,000 $5,500 $188,054 $24,300 $4,960,000 $20,000 $323,000 $20,000 $40,000 $50,000 $2,000 $10,000 $21,141 $1,325,000 $5,000 $1,796,141 $477,904 $20,000 $497,904 vot.2532Pa6E0304 BUDGET REVISION -1993/1994 EXPENDITURE HIGHLIGHTS FOR DISCUSSION GENERAL FUND ORIGINAL DEPARTMENT DESCRIPTION BUDGET AMOUNT ADMINISTRATION/ COMPUTER & SCANNER $2,200 COUNCIL SUBTOTAL $337,539 $2,200 PLANNING CITY WIDE TRAFFIC STUDY $25,000 ROAD IMPACT FEE STUDY $10,000 ADDRESSING PROJECT -APPRAISAL DISTRICT $9,000 SUBTOTAL $321,752 $44,000 BUILDING PRINTING COSTS -GROWTH RELATED $500 INSPECTION TELEPHONE ADJUSTMENT $1,000 SUPPLIES & REPAIRS $1,000 LIBRARY POLICE FIRE PARKS SUBTOTAL $207,603 $2,500 COMPUTER BACKUP, MONITOR, DISKS $2,070 LONGEVITY CORRECTION $904 SUBTOTAL $497,306 $2,974 DISPATCH/COURT COMPUTER EXPANSION $24,225 VEHICLE REPAIRS & MISCELLANEOUS $14,700 REPLACEMENT PATROL CAR $16,900 5 ADDITIONAL OFFICERS $82,000 VEHICLES FOR NEW OFFICERS $46,750 EQUIPMENT FOR NEW OFFICERS $2,900 SUBTOTAL $2,736,180 $187,475 PRIVACY FENCE FOR SECURITY $2,400 STORAGE BUILDING TO COVER GENERATOR $3,000 HURST TOOL HEAD -JAWS RELATED $9,400 PUBLIC EDUCATORS' CONFERENCE $4,400 SUBTOTAL $1,844,536 $19,200 RABB HOUSE BALCONY STRUCTURAL REPAIRS $17,000 SPORTS LEAGUES INCREASED PROGRAMS $1,303 BUS TRANSPORTATION -YOUTH PROGRAMS $8,678 POOL CONCESSIONS $3,000 SPECIAL EVENTS -JULY 4TH ETC. $16,700 PARD MOVE TO HERITAGE WOODS $100,000 SUBTOTAL $1,367,053 $146,681 PUBLIC POWER & LIGHT -ADDITIONAL BUILDING $10,460 WORKS VEHICLE REPAIRS $700 DEMOLITION CONTRACT $8,188 STREETS SUBTOTAL ADDITIONAL STREET STRIPING REQUIREMENTS REPAIRS DUE TO AGE OF EQUIPMENT COMPACTION MACHINES TO IMPROVE STREET REPAIR PROCESS SUBTOTAL $658,936 $19,348 $1,618 $5,000 $14,139 $1,314,719 $20,757 BUDGET REVISION -1993/1994 EXPENDITURE HIGHLIGHTS FOR DISCUSSION GENERAL FUND DEPARTMENT VOL. 2532PaGEO305 ORIGINAL DESCRIPTION BUDGET AMOUNT SHOP ROOF REPLACEMENT AT MAINTENANCE SHOP $6,000 UNIFORMS $1,139 FUEL TANKS -LEAK DETECTION COMPLIANCE $24,000 SUBTOTAL $237,589 $31,139 MUNICIPAL STATE COURT COSTS TO ACTUAL $20,000 COURT V.O.E. STUDENT PROGRAM THROUGH SUMMER $2,130 SUBTOTAL $268,928 $22,130 GENERAL 800 MHZ TRUNKED RADIO SYSTEM $1,325,000 GOVERNMENT PRE-EMPLOYMENT SCREENING $2,230 PROPERTY & LIABILITY INSURANCE $2,700 FLOOD INSURANCE $3,100 TRANSFER FOR CHILD SAFETY PROGRAM $15,000 CORRECTION TO FICA TAXES $3,400 STREET LIGHTING IMPROVEMENTS $133,000 VIDEO PRODUCTION EQUIPMENT $12,000 SUBTOTAL $738,578 $1,496,430 HEALTH TRANSFER TO SELF-FUNDED HEALTH INSURANCE INSURANCE FUND $56,250 NET AGAINST PERSONNEL COSTS BUDGET ($56,250) NET BUDGET CHANGE $0 GRAND TOTAL $1,994,834 NOTE --DETAILS PROVIDED IN ATTACHED BUDGET REVISION DOCUMENT. VOL.2532PAGEO3O6 BUDGET REVISION -1993/1994 EXPENDITURE HIGHLIGHTS FOR DISCUSSION UTILITY FUND ORIGINAL DEPARTMENT DESCRIPTION BUDGET AMOUNT WATER DEPT. OF HEALTH TESTING FEE INCREASE $4,600 TREATMENT CHEMICALS -NEW STATE REGULATIONS $48,000 PLANT SUBTOTAL $740,108 $52,600 WATER SYSTEM POWER & LIGHT $45,000 SUPPORT MOTOR VEHICLE REPAIRS $1,753 METERS -BUDGET REQUIREMENTS & GROWTH, NET $58,840 SUBTOTAL $908,701 $105,593 WATER LINE OVERTIME -INCREASE $18,042 MAINTENANCE ADDITION OF CERTIFICATION PAY $540 CONTRACT LABOR -CONCRETE WORK $16,980 SUPPLIES -BULK PURCHASING $4,292 EQUIPMENT REPAIRS $8,000 AGING LINES MAINTENANCE $19,993 TRAINING -FIRE HYDRANT SCHOOL $1,500 SUBTOTAL $877,336 $69,347 WASTEWATER REPAIRS -SLUDGE BELT PRESS $10,000 TREATMENT SLUDGE -INCIDENT OF HIGH LEVEL CONTAMINATION $6,000 PLANT TEXAS WATER COMMISSION INSPECTIONS $1,700 REPAIRS -BLOWER & BEARING WORK $5,000 SUBTOTAL $971,100 $22,700 WASTEWATER REPAIRS -LIFT STATIONS $3,560 SYSTEM TELEMETRY -OAK BLUFF, FOREST CREEK $8,300 SUPPORT PUMP & CONTROLS -OAK BLUFF LIFT STATION $14,000 ADDITIONAL PUMP -MEADOWS LIFT STATION $16,200 SUBTOTAL $148,425 $42,060 WASTEWATER AIR CONDITIONING REPLACEMENT IN LABORATORY $2,500 LINE ADDITION OF CERTIFICATION PAY $240 MAINTENANCE SUBTOTAL $358,762 $2,740 UTILITY PROPERTY & LIABILITY INSURANCE $2,900 BILLING SUBTOTAL $538,509 $2,900 GENERAL LEGAL FEES -UTILITY MATTERS $32,000 PROPERTY & LIABILITY INSURANCE $9,500 FLOOD INSURANCE $3,300 PURCHASE -ROUND ROCK WATER SUPPLY ASSETS $125,000 PRE-EMPLOYMENT SCREENING $918 SUBTOTAL $170,718 BUDGET REVISION -1993/1994 EXPENDITURE HIGHLIGHTS FOR DISCUSSION UTILITY FUND VOL. 2532PAGE 03© 7 ORIGINAL DEPARTMENT DESCRIPTION BUDGET AMOUNT HEALTH TRANSFER TO SELF-FUNDED HEALTH INSURANCE INSURANCE FUND $18,750 NET AGAINST PERSONNEL COSTS BUDGET ($18,750) NET BUDGET CHANGE $0 GRAND TOTAL $468,658 NOTE ---DETAILS PROVIDED IN ATTACHED BUDGET REVISION DOCUMENT. v0L.2532PAGEO3O8 800 mhz trunked radio system Preliminary cost figures have been established for a city—wide trunked radio system. The system would provide upgraded radio communication service to all City departments and would also comply with the Federal Communications Commission efforts to narrow radio band widths over the next few years. The system would most feasibly be financed through a lease—purchase over 5 to 7 years as follows: System "backbone" cost (includes repeaters, antenna system, backup site, console and computer operating system) $530,000 Building to house the "backbone" $30,000 Backup generator $10,000 Radios (for all departments) $680,000 Contingency costs $75,000 Total costs projected for equipment, installation $1,325,000 Financing provided by lease purchase proceeds Annual debt service requirements for 5 years $1,325,000 $315,000 Annual maintenance and licensing costs could be required $69,000 (future years impact) The radio team will continue researching the most cost—effective and advantageous method of implementing the system (at once or over a period of years) 6 ¥ L. 2532PIGE0309 THE CITY OF ROUND ROCK, TEXAS 7 VOL.2532PaGE03I0 THE CITY OF ROUND ROCK, TEXAS GENERAL FUND Revenues Expenditures Total Change in Fund Balance UTILITY FUND 1993-1994 1993-1994 Revised Budget #1 $ 11,259,516 $ 13,055,657 (11,248,781) (13,244,195) $ 10,735 $ (188,538) Revenues $ 8,844,339 $ 9,342,243 Operating Expenditures (9,392,250) (9,860,908) Total Change in Fund Balance $ (547,911) $ (518,665) 8 VOL.2532PaGEO311 THE CITY OF ROUND ROCK, TEXAS General Fund - Effect of the revision on fund balance: Audited Fund Balance 9/30/93 Less Reserves ( *1) Estimated Revenue (FY 1993-1994) Interfund Transfers Total Funds Available Budgeted Expenditures $ 5,119,893 $ (3,979,800) $ 12,155,657 $ 900,000 $ 14,195,750 $ (13,244,195) Estimated Fund Balance 9/30/94 $ 951,555 *1 Reserves are established in accordance with operating reserve policies and the $1,000,000 reserve for swimming pool. Utility Fund - Effect of the revision on cash balances: Audited Cash Balance 9/30/93 Less Reserves ( *2) Estimated Revenue (FY 1993-1994) $ 5,693,004 $ (2,465,227) $ 9,342,243 Other Financing Sources - Scheduled application of impact fees $ 550,000 Interfund Transfers $ (4,564,321) Total Funds Available Budgeted Expenditures Estimated Cash Balance 9/30/94 $ 8,555,699 $ (5,296,587) $ 3,259,112 *2 Reserves are established in accordance with operating reserve policies . 9 YQI, 2 5 3 2 PAGE 0 3 12 THE CITY OF ROUND ROCK, TEXAS GENERAL FUND Revenues DEPARTMENT 1993-1994 Budget 11,259,516 1993-1994 Revised #1 Variance 13,055,657 1,796,141 Executive/Administrative - 12 (337,529) (343,129) 5,600 Legal Services - 13 (165,100) (165,100) 0 Planning - 14 (321,752) (365,752) 44,000 Data Processing - 15 (53,173) (53,353) 180 Building Inspection - 16 (207,603) (210,103) 2,500 Finance - 17 (349,020) (349,020) 0 Purchasing - 18 (77,430) (77,430) 0 General Services - 19 (738,578) (758,608) 20,030 Library - 20 (497,306) (500,280) 2,974 Police - 21 (2,736,180) (2,923,655) 187,475 Fire - 22 (1,844,536) (1,863,736) 19,200 Parks & Recreation - 23 (1,367,053) (1,513,734) 146,681 Personnel - 24 (73,349) (73,749) 400 Public Works - 25 (658,936) (678,284) 19,348 Streets - 26 (1,314,719) (1,335,476) 20,757 City Shop - 28 (237,589) (268,728) 31,139 Municipal Court - 29 (268,928) (291,058) 22,130 General Government - Other 0 (1,473,000) 1,473,000 Total Expenditures (11,248,781) (13,244,195) 1,995,414 10 THE CITY OF ROUND ROCK, TEXAS ¥OL.2532PAE0313 UTILITY FUND Revenues DEPARTMENT 1993-1994 Budget 1993-1994 Revised #1 Variance 8,844,339 9,342,243 497,904 Water Treatment Plant - 41 (740,108) (838,426) 98,318 Water System Support - 42 (908,701) (1,014,294) 105,593 Waterline Maintenance - 43 (877,336) (946,683) 69,347 Wastewater Treatment Plant - 61 (971,100) (993,800) 22,700 Wastewater System Support - 62 (148,425) (190,485) 42,060 Wastewater Lines Maintenance - 63 (358,762) (361,502) 2,740 Pre Treatment - 64 (203,888) (203,888) 0 Utility Billing & Collection - 81 (538,509) (541,409) 2,900 Debt Service & Other - 90 (81,100) (81,100) 0 Transfers - 95 (4,564,321) (4,564,321) 0 General Government - Other 0 (125,000) 125,000 Total Expenditures (9,392,250) (9,860,908) 468,658 11 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Revenue General Fund 10-00-000-4120 10-00-0004214 10-00-0004217 10-00-000-4225 10-00-000-4301 10-00-000-4403 10-00-000-4404 10-00-000-4405 10-00-000-4410 10-00-000-4615 10-00-000-4616 Utility Fund VOL. 25 3 2 PAGE 0 314 Account Title Sales Tax Building Permits Filing Fees Subdivision Fees Lot Clearing Recreation Programs Swimming Pool Receipts Sports League Fees Structural Steel Inspections Miscellaneous Revenue Capitalized Lease Proceeds 20-00-000-4804 Water Service 20-00-0004833 Meters & Fitting Sales Explanation Reflects growth; new businesses Increase in building activity Increase in building activity Increase in building activity Increased activity July 4th & special events Concession sales Increase in participation Increase in building activity Insurance reimbursement - patrol car 800 MHZ trunked radio system Budget Increase (Decrease) 323,000 20,000 40,000 50,000 2,000 14,034 4,000 3,107 5,000 10,000 1,325,000 1,796,141 Reflects increased consumption & climate conditions 477,904 Reflects increased consumption & climate conditions 20,000 12 497,904 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Account Title General Fund Executive/Administration 10-12-000-5110 Salaries 10-12-000-5113 FICA 10-12-000-6116 Computer Equipment Legal 10-13-000-5250 Legal Fees 10-13-000-5251 Litigation Planning 10-14-000-5216 10-14-000-5240 10-14-000-5316 10-14-000-5352 10-14-000-5465 10-14-000-6127 Data Processing 10-15-000-5317 10-15-000-5328 10-15-000-5434 10-15-000-6116 Building Inspections 10-16-000-5210 10-16-000-5211 10-16-000-5316 10-16-000-5328 10-16-000-6113 Finance 10-17-000-5216 10-17-000-5434 General Services 10-19-000-5416 10-19-000-5416 10-19-000-5458 10-19-000-6112 Library 10-20-000-5140 10-20-000-5315 10-20-000-5317 10-20-000-5328 10-20-008-6110 10-20-000-6116 Professional Services Maint Contract - Computers Supplies - Office Printing & Reproduction Comprehensive Plan Revision Computer Software Supplies - Data Processing Repairs - Equipment Training & Transportation Computer Equipment Printing & Publications Telephone Supplies - Office Repairs - Equipment Communication Equipment Professional Services Training & Transportation Insurance - General Liability Insurance - General Liability Contingency Machinery & Equipment Longevity Supplies/Materials - Other Supplies - Data Processing Repairs - Equipment Office Equipment Computer Equipment VOL. 25 3 2 PAGE 0315 Explanation Budget correction Correction to FICA taxes Computer & Scanner Adjust to actual Adjust to actual Traffic & impact fee studies, addressing project PC -Arc Info Service phased out - new software Adjust to actual Adjust to actual Adjust to actual PC -Arc Info Service phased out - new software Adjust to actual Adjust to actual Novell training/mileage Adjust to actual Adjust to actual Adjust to actual Adjust to actual Adjust to actual Bag phone Adjust to actual Continuing education requirements for licensing Property & casualty Flood insurance Pre Employment Screening Video projection equipment Adjust to actual Book processing supplies for donated books Supplies costing more than budgeted Replacing some equipment Cover over -expenditure of photocopier MAC monitor, tape cartridge backup system 13 Budget Increase (Decrease) 1,600 1,800 2,200 5,600 (13,000) 13,000 0 44,000 (1,800) 1,200 (600) (600) 1,800 44,000 (276) (150) 480 126 180 500 1,000 300 300 400 2,500 (1,000) 1,000 0 2,700 3,100 2,230 12,000 20,030 904 500 100 (1,280) 680 2,070 2,974 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Police 10-21-000-5119 10-21-000-5120 10-21-000-5240 10-21-000-5330 10-21-005-5460 10-21-001-5119 10-21-001-5334 10-21-005-5330 10-21-001-5455 10-21-001-5314 10-21-005-5288 10-21-005-5314 10-21-005-5434 10-21-006-5314 10-21-007-5314 10-21-007-5434 10-21-007-5482 10-21-007-5437 10-21-006-5437 10-21-007-5483 10-21-006-5322 10-21-005-5323 10-21-006-5120 10-21-005-6114 10-21-000-6116 NEW NEW NEW Fire 10-22-000-5120 10-22-000-5211 10-22-000-5213 10-22-000-5265 10-22-000-5314 10-22-000-5316 10-22-000-5318 10-22-000-5329 10-22-000-5330 10-22-000-5352 10-22-000-5434 10-22-000-5458 10-22-000-6113 10-22-000-6127 10-22-011-5110 VOL. 25 3 2 PAGE 0316 Account Title Overtime Professional Pay Maint - Computer System Repairs - Motor Vehicles Car Wash Overtime Uniforms Repairs - Motor Vehicles Animal Boarding & Control Fuel & Lube Detention of Prisoners Fuel & Lube Training & Transportation Fuel & Lube Fuel & Lube Training & Transportation Neighborhood Watch Psychological Testing Psychological Testing Youth Services Supplies - Investigations Supplies - ACC Investigations Professional Pay Mobile Equipment Computer Equipment Professsional Pay Telephone Equipment - Rent/Lease Repairs - Communication Fuel & Lube Supplies - Office Postage Repairs - Office Equipment Repairs - Motor Vehicles Printing & Reproduction Training & Transportation Contingency Communication Equipment Computer Software Salaries Explanation High turnover rate, fill for sick, holiday, etc. Transfer of staff Increase by provider Addition of one vehicle New vendor - higher fee Increase in work call -out & injuries Turnover in personnel Increased cost of parts & minor accidents Less fees - boarding New vehicles - better mileage Fewer expenses New vehicles - better mileage Adjust to actual New vehicles - better mileage New vehicles - better mileage Adjust to actual Adjust to actual Fewer cases Fewer cases Fewer cases Adjust to actual Adjust to actual Transfer of staff Replace patrol vehicle Dispatch/Court expansion 5 additional officers Vehicles for new officers Equipment for new officers Transfer personnel from 012 Adjust to actual Additional pager lease Adjust to actual Adjust to actual Adjust for administrative cost Adjust to actual Adjust to actual New admin vehicles - warranty Adjust to actual Administration travel, Chief, Fire Marshal Adjust to actual Small amount of equipment in administration Delay purchase Adjust to actual 14 Budget Increase (Decrease) 4,500 600 7,400 500 1,200 1,500 1,000 16,000 (5,000) (500) (500) (2,500) (2,000) (1,000) (1,500) (500) (500) (800) (800) (500) (800) (500) (600) 16,900 24,225 82,000 46,750 2,900 187,475 840 683 175 (175) (742) 422 (150) (450) (2,039) (66) 4,915 1,325 (500) (648) (2,111) City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Account Title 10-22-011-5125 Higher Classification Pay 10-22-011-5211 Telephone 10-22-011-5214 Power & Light 10-22-011-5265 Repairs - Communication 10-22-011-5314 Fuel & Lube 10-22-011-5315 Supplies/Materials -Other 10-22-011-5316 Supplies - Office 10-22-011-5321 Supplies - Janitorial 10-22-011-5324 Repairs - Building 10-22-011-5330 Repairs - Motor Vehicles 10-22-011-5434 Training & Transportation 10-22-011-5458 Contingency 10-22-011-6112 Equipment & Machinery 10-22-011-6113 Communication Equipment 10-22-011-6116 Computer Equipment 10-22-012-5110 Salaries 10-22-012-5120 Professional Pay 10-22-012-5125 Higher Classification Pay 10-22-012-5211 Telephone 10-22-012-5214 Power & Light 10-22-012-5265 Repairs - Communication 10-22-012-5314 Fuel & Lube 10-22-012-5315 Supplies/Materials -Other 10-22-012-5316 Supplies - Office 10-22-012-5321 Supplies - Janitorial 10-22-012-5324 Repairs - Building 10-22-012-5330 Repairs - Motor Vehicles 10-22-012-5334 Uniforms 10-22-012-5434 Training & Transportation 10-22-012-5458 Contingency 10-22-013-5211 Telephone 10-22-013-5214 Power & Light 10-22-013-5265 Repairs - Communication 10-22-013-5314 Fuel & Lube 10-22-013-5315 Supplies/Materials -Other 10-22-013-5316 Supplies - Office 10-22-013-5321 Supplies - Janitorial 10-22-013-5324 Repairs - Building 10-22-013-5330 Repairs - Motor Vehicles 10-22-013-5334 Uniforms 10-22-013-5434 Training & Transportation 10-22-013-5458 Contingency 10-22-013-6113 Communication Equipment 10-22-013-6116 Computer Equipment 10-22-020-5352 Printing & Reproduction 10-22-020-5354 Supplies - Emergency Mgt 10-22-020-5431 Fire Prevention 10-22-020-5458 Contingency NEW VOL. 2 5 3 2 PAGE O 317 Explanation Adjust to actual Adjust to actual Added energy efficient system Adjust to actual Adjust to actual Adjust to actual Adjust to actual Adjust to actual Leaks in roof at Central Station Adjust to actual Adjust to number of personnel at Central Adjust to actual Adjust for David Clark System for E -I Adjust to actual Delay purchase Adjust to actual Transfer personnel to 000 Adjust to actual Less phone usage at sub -station Fewer square feet at Station #2 Adjust to actual Adjust to actual Adjust to actual Adjust to actual Adjust to actual Central Station roof repairs Increased alarms for Engine 2 Fewer uniforms being purchased Adjust to actual Adjust to actual Decreased phone usage New station - more energy efficeint Adjust to actual Decrease for less equipment Adjust to actual Adjust to actual Adjust to actual New building - fewer repairs Fewer repairs Fewer uniforms being purchased Annual Haz-Mat & Fire & Rescue School Adjust to actual Delay purchase Adjust to actual Adjust to actual Adjust to actual Adjust to actual Adjust to actual Privacy fence for security 15 Budget Increase (Decrease) 2,111 (280) (2,540) 292 (2,227) 900 104 (480) 3,000 (909) 3,334 5,600 3,500 (950) (650) (305) (840) 305 (1,177) (937) (337) (990) 625 (253) (255) (579) 908 (325) 1,147 936 (1,043) (937) (587) (989) 222 (429) (262) (500) (2,571) (122) 1,029 149 (900) (3,500) (1,100) 200 353 780 2,400 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department NEW NEW NEW PARD 10-23-000-5201 10-23-000-5316 10-23-003-5110 10-23-003-5113 10-23-003-5141 10-23-003-5142 10-23-003-5283 10-23-003-5315 10-23-003-5328 10-23-003-5334 10-23-003-5347 10-23-003-5390 10-23-003-5391 10-23-003-5393 10-23-003-6112 10-23-003-6113 10-23-004-5253 10-23-000-5110 10-23-004-5283 10-23-004-5424 10-23-004-5313 10-23-000-8155 Personnel 10-24-000-5316 Public Works 10-25-000-5214 10-25-002-5283 10-25-002-5330 Streets 10-26-000-5213 10-26-000-5228 10-26-000-5330 10-26-000-5356 10-26-000-5358 10-26-000-6112 City Shop 10-28-000-5324 10-28-000-5334 NEW VOL 2 5 3 2 PAGE O 3 8 Account Title Maintenance Agreements Office Supplies Salaries FICA Workers Compensation TEC Contract Labor Supplies/Materials - Other Repairs - Equipment Uniforms Seed & Fertilizer Athletic Facility Maintenance Supplies - Irrigation Facility Maintenance Machinery & Equipment Communication Equipment Sports League Officials Salaries Contract Labor Special Events & Programs Supplies - Pool Transfer to Self -Financed Const Supplies - Office Power & Light Contract Labor Repairs - Motor Vehicles Equipment - Rent/Lease Striping Contract Repairs - Motor Vehicles Traffic Signs Barricades Machinery & Equipment Repairs - Building Uniforms Explanation Storage building for generator Hurst Tool Head Training - Public Educators Conference Adjust To Actual Used 82% of budget Cemetery - transfer from contract labor Cemetery - transfer from contract labor Cemetery - transfer from contract labor Cemetery - transfer from contract labor Cemetery - transfer to salary accounts Cemetery - transfer from contract labor Unexpected repairs Cemetery Adjust to actual Adjust to actual Additional repairs due to line breaks Rabb Balcony - structural repairs Cemetery - trailer, mower. blower Cemetery - radio Increase in participation Temporary service due to turnover Bus transportation- youth programs July 4th & Special Events Concession costs Move to Heritage Woods Computer upgrades Reflect move to larger building Demolition Contract Adjust to actual 3 additional pagers Increase due to striping of McNeil Rd Older vehicles requiring more repairs Adjust to actual Adjust to actual Compaction & Street repair equipment Replace city garage roof Adjust to actual Fuel site upgrades 16 Budget Increase (Decrease) 3,000 9,400 4,400 19,200 (500) 500 5,953 649 377 42 (11,500) 1,439 1,700 140 (1,250) (1,250) 800 17,000 2,300 600 1,303 (1,167) 9,845 16,700 3,000 100,000 146,681 400 400 10,460 8,188 700 19,348 118 5,000 5,000 (2,000) (1,500) 14,139 20,757 6,000 1,139 24,000 31,139 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Account Title Municipal Court 10-29-000-5461 Court Costs General Government Health Insurance Texas Employment Commission Salaries Street Lighting Trunk Radio System Child Safety Program Total Change - General Fund Y JL, 2 5 3 2 PAGE 0 319 Explanation State Court costs to actual V.O.E. Student program through summer Transfer to self-funded Health Insurance Fund TEC rate increase Net against personnel costs budget Street lighting improvements 800 MHZ trunked radio system • Transfer for child safety program 17 Budget Increase (Decrease) 20,000 2,130 22,130 56,250 22,351 (78,601) 133,000 1,325,000 15,000 1,473,000 1,995,414 VOL. 25 32P'AGE 0320 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Account Title Utility Fund Water Plant 20-41-000-5312 20-41-000-5315 20-41-000-5250 20-41-000-5342 20-41-000-5376 20-41-000-5416 20-41-000-5416 20-41-000-5458 Chemicals Supplies/Materials - Other Legal Fees R & M - Plant & Equipment TDH Testing Insurance - General Liability Insurance - General Liability Contingency Water Systems Support 20-42-000-5118 Stand-by Pay 20-42-000-5110 Salaries 20-42-000-5120 Professional Pay 20-42-000-5214 Power & Light 20-42-000-5330 Repairs - Motor Vehicles 20-42-000-6119 Water Meters/Lines Water Lines Maintenance 20-43-000-5119 20-43-000-5120 20-43-000-5210 20-43-000-5283 20-43-000-5315 20-43-000-5328 20-43-000-5344 20-43-000-5358 20-43-000-5434 Wastewater Plant 20-61-000-5221 20-61-000-5345 20-61-000-5377 20-61-010-5345 Overtime Professional Pay Printing & Publications Contract Labor Supplies/Materials - Other Repairs - Equipment R & M - Lines Barricades Training & Transportation Sludge Disposal R & M - Plant & Equipment Tx Water Comm - Inspection R & M - Plant & Equipment Wastewater Systems Support 20-62-000-5118 20-62-000-5120 20-62-000-5340 20-62-000-6112 20-62-000-6112 20-62-000-6112 Stand-by Pay Professional Pay R & M Lift Stations Machinery & Equipment Machinery & Equipment Machinery & Equipment Wastewater Line Maintenance 20-63-000-5120 Professional Pay 20-63-000-6112 Machinery & Equipment Explanation New State regulations Adjust to actual Utility matters Adjust to actual Department of Health testing fee increase Property & casualty Flood insurance Pre-employment screening Adjust to actual Adjust for building maintenance Addition of certification pay Adjust to actual Adjust to actual Meters, budget requirements & growth Overtime - increase Addition of certification pay Adjust to actual Concrete repair increases Adjust to actual Adjust to actual Aging lines maintenance Growth in building activity in City Fire hydrant school Incident of high level contamination Blower & bearing work required Adjust to actual Sludge belt press repairs Adjust to actual Addition of certification pay Repairs - lift stations Telemetry - Oak Bluff, Forest Creek Additional pump at Meadows lift station Pump & controls - Oak Bluff lift station Addition of certification pay Air conditioning replacement in laboratory 18 Budget Increase (Decrease) 48,000 1,500 32,000 (1,500) 4,600 9,500 3,300 918 98,318 200 (4,100) 240 45,000 1,753 62,500 105,593 18,042 540 (1,100) 16,980 4,292 8,000 25,093 (4,000) 1,500 69,347 6,000 5,000 1,700 10,000 22,700 (200) 180 3,580 8,300 16,200 14,000 42,060 240 2,500 2,740 City of Round Rock Operating Budget Revision Fiscal 1993 - 1994 Department Account Title Environmental Services 20-64-000-5328 Repairs - Equipment 20-64-000-6112 Machinery & Equipment Utility Billing & Collection 20-81-000-5110 Salaries 20-81-000-5216 Professional Services 20-81-000-5277 Bank Service Fees 20-81-000-5330 Repairs - Motor Vehicles 20-81-000-5416 Insurance - General Liability General Government Health Insurance Texas Employment Commission Salaries Round Rock Water Supply Total Change - Utility Fund la_ 2532PAGE 0321 Explanation Adjust to actual Upgrade a/c unit/ sampling unit Temporary service due to turnover Temporary service due to turnover Adjust to actual Adjust to actual Property & casualty Transfer to self-funded Health Insurance Fund TEC rate increase Net against personnel costs budget Purchase of assets - Round Rock Water Supply STATE COUNTY OF V;L +A: , t hereby certify fat this instrument was en the date and at the time stamped ic;c-.•: by rne, and was duty RECORDED in the Volum ant! Page of the name RECORDS of Williams, County. Texas as stamped hereon oy me. 0 71 � Y 1 9 1994 COUNTY CLERK JILLIAMSOt CORM, TE 19 Budget Increase (Decrease) (2,500) 2,500 0 (3,000) 3,000 (900) 900 2,900 2,900 18,750 6,538 (25,288) 125,000 125,000 468,658