Loading...
FY 2004-05 Budget1400 SCHERTZ PARKWAY P.O. DRAWER I SCHERTZ, TEXAS 78154-0890 (210) 658-7477 FAX (210) 659-3204 MARK MARQUEZ CITY MANAGER 23 September 2004 To: Mayor and City Council From: Mark Marquez, City Manager Subject: FY 2004-2005 Operating Budget Recommendations Budget recommendations for FY 2004-2005 were filed with the City Secretary on 30 July 2004 in accordance with the requirements of the City Charter. The total estimated budget expenditures for all funds are recommended to be $24,897,151 on projected revenues of $25,026,693. Projected revenues in each fund meet or exceed proposed expenditures except for the Park Fund. Funds from the tree mitigation portion of the Park Fund will be applied to a tree-planting program throughout City Parks and the Municipal Campus. I was pleasantly surprised at the growth in assessed valuations. We went from $1,105,234,626.00 to $1,285,941,678, an increase of $180,707,052.00, much of which was new growth. As a result, I am recommending a decrease in our tax rate from .3825 per hundred to .3760 per hundred. The mix of the components to the tax rate has also been adjusted. The M & O rate has been reduced to ..2888 from .2946 and the interest and sinking fund has been reduced to .0872 from .0879. This equates to a $.02 cent reduction in our M & O rate over the last two years, with the I & S rate remaining about the same. You will notice several new funds in this year's budget. Two of the funds are designed to help track recent bond packages, one for each bond. I believe they will help provide better visibility for the many capital projects that are ongoing. In addition, I have created a special events fund. We looked at all the events that City hosts and sponsors throughout the year, and believed a tracking mechanism was needed. Again, the intent is better visibility and the ability to more closely monitor these events. This is an experimental project that I hope will prove beneficial. All the projects approved in last years bond are now actively underway, the last being the contract for the new Emergency Services Building on IH-35. We have also begun work on the projects from the most recent bond. Activity on the drainage and streets projects on Borgfeld Road and Maske Road are underway. I have just approved the design and engineering contracts for the new ball fields as well as the renovations of the church property. We are continuing to improve our employee benefits package by offering the 2 to 1 match in the retirement program. This was something asked for by our employees. I believe this improvement will aid in our recruitment and retention of employees. I am also recommending continuing the merit pay program. While somewhat perverse, I am pleased that the rate of increase for employee health insurance only rose by 16%. I had anticipated an increase of over 20%. We will be adding 6 firemen for our new station on IH-35, as well as a records clerk in the Police Department. In addition, I plan to merge the Records Management function into the City Secretary office for better utilization of resources. The wet weather we've had over the last two years has placed some stress on the Water Fund because of reduced revenues. However, I am not recommending any changes to our water rates. We are actively working on an additional elevated water storage tank for better balance of water pressures as well as increased storage capacity. Our EMS department has stabilized. We have a new contract with Guadalupe County and we are seeking additional contracts in the area. Our training program is expanding to include a certificate for EMT Intermediates. Overall, the City is in sound condition financially with adequate reserves. In fact, we are now allocating reserves from limited purpose funds such as Hotel/Motel and the Parks fund where we hadn't in the past. The continued strong support of the Mayor and City Council has made this another good year for me as your City Manager. The job is always demanding, but more often than not, very rewarding. I cannot give enough thanks to the untiring effort of all City employees, especially my department heads, for trying to make Schertz a better place. We are all trying to get better at what we do! The department heads also deserve kudos for working with me to develop a budget that meets the needs of our citizens. Special thanks to Mr. Juan F. Santoya, our Finance Director, Ms. Joyce DeBuysere, and the staff in the Finance Department for helping me crunch the numbers. Thank You CITY OF SCHERTZ 2004-2005 BUDGET Index Ordinance-Tax Rate .......... I-III Ordinance-Budget ........................................................................ IV-V Tax Rate and Property Evaluation ..................................................... VI Rate per Hundred Valuation ---VII Tax on $100,000 Valuation by Year ........... VIII Assessed Property Values. Revenues - All Funds Chart - All Funds. Expenditures - All Funds. Chart - All Funds General Fund Expenditures by function. Chart - General Fund Expenditures by function. IX .X ,-XI -XII --XIII XIV General Fund Revenue & Expenditure Summary .......... Revenues City Council City Manager ........... Municipal Court ............ Information Technology ............ Community Development Legal Services. Police ....... Fire Inspections. Street~ .--1-6 7-10 --11-12 13-14 15-17 18-20 21-23 24-25 2029 30-32 33-35 3038 39-41 Facility Maintenance ............ Animal Control. Pool. -42-44 45-47 -48-50 City Secretary ............... Library .............. Human Resources. Non-Departmental. Finance ................. Public Information Officer ........... Fleet Service ................. Patient Assistance ................ 51-53 54-56 57-59 60-61 62-63 64-66 67-69 70-71 Tax I&S Summary ........................................................................... 72-74 Revenues & Expenditures ....................................................... 75-76 Water & Sewer Revenues & Expenditures ......................................................77-82 Water/Wastewater .............................................................. 83-86 Business Office ................................................................... 87-88 Public Safety EMS Summary ........................................................................ 89-94 Revenues ............................................................................ 95 Expenditures 96-98 Drainage Summary ......................................................................99-104 Revenues 105 Expenditures 106-107 Capital Recovery Summary ........................................................................... 108-109 Revenues .......................................................................... 110 Expenditures 111 Schertz Economic Development Corporation Summary Revenues Expenditures. 112-113 114 115-116 Development Foundation Summary ........................ Revenues Expenditures ,117-118 119 120 Special Event Fund Summary ............................................................................ 121 Revenue ............................................................................. 122 Expenditures ........................................................................ 123 Hotel Tax Summary .......................................................................... 124-125 Revenues ............................................................................ 126 Expenditures 127 Parks Summary ........... Revenues. 128-129 130 Expenditures ..................................................................... 131 Recycling Summary ............... Revenues. Expenditures, 132-133 134 135 Working Capital Projects. 136-137 Organizational Chart 138 2003-2004 Position Authorization. 139-143 2003-2004 Pay Tables. 144-151 Compensation Plan- 152-155 Debt Service Review ............. G O Bond, SR1992. G O Refunding Bond, SR1995 C O Bond, SR2001 Tax Notes, SR2002 Combination Tax & Ltd Pledge Revenue -2003 Combination Tax & Ltd Pledge Revenue -2004 Tax Notes, SR2001 G O Bond, SR1998 G O Refunding Bond, SR1995 Utility System Rev & Refund Bond, SR2001 Schertz/Seguin Local Govt Corp, SR99 & SR01 GMAC Commercial Mortgage ........... G O Refunding Bond, SR1999 ............ - 156 157 ,158 159 160 161 - 162 163 164 165 166 167 168 169 ORDINANCE' NO. ~ z//'-'7'-~43 AN ORDINANCE LEVYING AND ASSESSING ALL TAXABLE PROPERTY WITHIN THE CORPORATE LIMITS OF THE CITY OF SCHERTZ, TEXAS, FOR THE YEAR 2004; PROVIDING THE BASIS OF ASSESSMENT OF ONE HUNDRED PERCENT (100%) APPRAISED VALUE AND PROVIDING FOR THE COLLECTION THEREOF AT THE RATE OF 0.3760 ON THE ONE HUNDRED DOLLAR ($100.00) ASSESSED VALUATION. WHEREAS, a public hearing was held on September 7, 2004, to receive public comment on the proposed tax rate; and BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS: SECTION 1. THAT there is hereby levied and assessed against all taxable property, both real and personal, within' the corporate limits of the City of Schertz, Texas, and there shall be collected by such City a tax of 0.3760 on the one hundred dollar ($100.00) assessed valuation for the year 2004. SECTION2. THAT such tax is hereby levied and assessed in accordance with the applicable Statutes of the State of Texas, and such levy and assessment is made for the following purposes, to wit: (A) For the current expense and operation of the General Fund and its various Departments $ 0.2889 (B) For requirements of the Tax Bond Interest and Sinking Fund to meet the outstanding tax supported indebtedness of the City for Fiscal Year 2004-2005. $ 0.0871 TOTAL TAX RATE $ 0.3760 The City Manager has certified to the availability of funds to pay princiPal and interest on the following indebtedness during the fiscal year 2004-2005. Debt , Principal Interest Total 1992 City of Schertz, Street Improvement General Obligation Bonds 1995 City of ScherIz, General Obligation, Refunding Bonds 2001 City of Schertz, Certificate of Obligation Bond (Schertz Parkway) 2002 City of Schertz Tax Notes 2003 City of Schertz, Certificate of Obligation Bond 2004 City of Schertz, Certificate of Obligation Bond $ 50,000.00 $ 20,130.00 $ 70,130.00 41,000.00 1,025.00 42,025.00 195,270.00 150,000.00 345,270.00 135,000.00 2,126.25 137,126.25 92,607.50 407,047.00 225,000.00 1601000.00 317,607.50 567,047.24 TOTAL $761,000.00 $718,205.99 $1,479,205.99 TI SECTION 3. THAT the Tax Assessor and Collector for Guadalupe County, Texas is hereby directed to assess and collect taxes of the City of Schertz, Texas on the basis of one hundred percent (100%) of appraised values for the year 2004, such basis of assessment being required to meet the proposed expenditures of the General Fund for the Fiscal Year 2004-2005 and collection of taxes thereof at the rate of 0.3760 assessed valuation as herein provided. APPROVED on first reading on this .. ~,/..~ day of(~_~,4_.,~ 2004. Mayor, City of Schertz, Texas ATTEST: Dep~ O{ty~'ecretary, city of Schertz, Texas (SEAL OF CITY) III ORDINANCE NO. ~'~ z/Z_/~-.~. ~ AN ORDINANCE PROVIDING FUNDS FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2004 AND ENDING SEPTEMBER 30, 2005, BY APPROVING THE BUDGET FOR SAID PERIOD AND APPROPRIATING THE NECESSARY FUNDS OUT OF THE GENERAL AND OTHER REVENUES OF THE CITY OF SCHERTZ, TEXAS, FOR SAID YEAR FOR THE MAINTENANCE AND OPERATION OF THE VARIOUS DEPARTMENTS AND FOR VARIOUS ACTIVITIES AND IMPROVEMENTS OF THE CITY. WHEREAS, as required by the General Laws of the State of Texas and the City Charter, the budget has been prepared and submitted to the City Council with estimates of expenditures and revenues of all City Departments and activities for the fiscal year beginning October 1, 2004 and Ending September 30, 2005. WHEREAS, notice of a public hearing upon said budget has been duly and legally published; and WHEREAS, said public headng has been held and full and final consideration given said budget; NOW THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS: SECTION 1. THAT for the purpose of providing the funds necessary and proposed to be expended in the budget for said City for the fiscal year beginning October 1, 2004 and ending September 30, 2005, the budget was prepared and submitted to the City Council for its consideration and approval and that said budget in the total amount of $24,897,151 and the same is hereby appropriated for the maintenance as set forth in said budget. TV SECTION 2. THAT the said budget of the City of Schertz, Texas, for the fiscal year beginning October 1, 2004 and ending September 30, 2005, an exact copy of which is marked "Exhibit A" and made a part hereof for all purposes the same as if it were copied in full herein, is hereby approved and adopted by the City Council for fiscal year 2004-2005. SECTION 3. THAT this Ordinance approving and. adopting a budget for the twelve-month period hereinabove specified is made in all things in accordance with the terms and provisions of the General laws of the State. of Texas and the City Charter. APPROVED on first reading the ~/-x~ day of ~ 2004. PASSED, APPROVED AND ADOPTED this the ~.~'/d4Of September 2004. Mayor, City orSchertz, Texas A'i-rEST: City Secretary, City of Schertz (SEAL OF CITY) Tax Year Rates and Property Evaluation Year 1995 1996 1997 1998 1999 2000 2001 Rate Total Valuation 0.4275 $ 312,676,505 0.4072 $ 334,122,763 0.3554 $ 378,784,051 0.3544 $ 450,199,212 0.3455 $ 534,039,183 0.3405 $ 716,795,968 0.3825 $ 822,745,104 2002 0.3825 $1,005,399,711 2003 0.3825 $1,105,234,626 2004 0.3760 $ 1,285,941,678 VI Rate per Hundred Valuation 0.45 0.4 0.35 0.3 0.25 0.2 0.15 0.1 0.05 0 1995 1996 1997 1998 1999 2000 2001 2002 2003 ISeflesl 0.4275 0.4072 0.3554 0.3544 0.3455 0.3405 0.3825 0.3825 0.3825 Year 2O04 0.3760 VII Tax on $100,000 Valuation by Year $450.00 $427.50 $407.20 $382.50 $382.50 $382.50 $376.00 $355.40 $354.40 $345.50 $340.50 $400.00 $350.00 $300.00 $250.00 $200.00 $150.00 $100.00 $50.00 Year · 1995 [] 1996 [] 1997 · 1998 [] 1999 13 2000 · 2001 · 2002 13 2003 · 2004 VIII Assessed Property Values 10000000 )0000000 -- )0000000 -- )0000000 - -- )0000000 - -- )0000000 - -- )0000000 ---/ -- 1 2 3 4 5 6 7 8 9 10 · Series1 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 · Series2 $312,676,5 $334,122,7 $378,784,0 $450,199,2 $534,039,1 $716,795,9 $822,745,1 $1,005,399, $1,105,234, $1,285,941, 140( 1200 10 80{; 40C Year IX Revenues - All Funds General Revenue $ 8,955,037 Debt Services $ 1,484,206 Water & Sewer $ 8,330,692 Drainage $ 309,770 Schertz EMS $ 3,339,328 Capital Recovery $ 1,568,000 Park/Recycle/Hotel $ 181,660 SED Corp/Dev Foundation $ 858,000 TOTAL $ 25,026,693 Revenues - All Funds Park/Recycle/Hotel Capital Recovery 6% L Schertz EMS 13% 1% SED Corp/Dev Found 3% General Revenue 37% Drainage 1% Water & Sewer 33% Debt Services 6% Xl Expenditures - All Funds Debt Service $ 4,274,798 Personnel $ 9,168,773 Supplies $ 440,415 Professional & City Svcs $ 970,233 Utility & Maint. Services $ 4,817,033 Operation Support & Svc $ 3,277,551 Equip. & Leasing $ 1,948,348 TOTAL $ 24,897,151 ×Il Expenditures - All Funds Opr Support & Asst 13% Equip & Leasing 8% Debt Service 17% Utility & Maint. Svc 19% Prof & City Svc 4% Supplies 2% Personnel 37% XIII General Fund Expenditures - by Function Public Safety $ 4,200,827 General Govt. $ 2,117,974 Health $ 214,142 Parks & Culture $ 907,049 Public Environment Internal Services Misc. $ 586,836 $ 885,762 $ 11,000 TOTAL $ 8,923,590 ×IV General Fund Expenditures - By Function Internal Services Public Environment 9.9% 6.6% Parks & Culture 10.2% Misc 0.1% Pub. Safety 47.1% Health 2.4% Gen. Govt. 23.7% XV General Fund - Revenues Taxes $ 3,718,524 Sales Tax $ 1,700,000 Franchises $ 670,220 Permits/License/Fees $ 1,013,825 Muni. Court $ 665,000 Inter-Jurisdictional Inter-Fund Admin Miscellaneous TOTAL $ 250,309 $ 709,159 $ 228,000 $ 8,955,037 Revenues - General Fund Permits/License/Fees 11% Franchises 7% Muni. Court 7% Inter-Jurisdictional 3% Inter-Fund Admin 8% Miscellaneous 3% Sales Tax 19% Taxes 42% General Fund - Expenditures Personnel $ 6,771,144 Supplies $ 209,380 Professional & City Svcs $ 600,171 Utility & Maint. Services $ 607,588 Operation Support & Svc Equip. & Leasing $ 538,459 $ 196,848 TOTAL $ 8,923,590 3 Expenditures - General Fund Professional & City Svcs 7% Operation Support & Utility & Maint.Svc Services 6% 7% Equip. & Leasing 2% Supplies 2% Personnel 76% 4 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED FINANCIAL SUMMARY REVENUE SUMMARY Taxes Franchises Permits Licenses Fees Fines Inter-jurisdictional Inter-Fund Transfers Miscellaneous TOTAL REVENUES 4,115,162 562 224 4OO 08O 36 639 781 019 12 902 164 887 574 557 186,331 4,711,916 4,838,892 5,418,524 598,535 618,354 670,220 514,154 472,900 522,750 40,523 41,450 20,500 1,028,645 968,800 1,117,575 18,943 18,000 18,000 265,855 187,585 250,309 576,334 623,834 709,159 4,272,268 138,350 228,000 6,833,801 12,027,173 7,908,165 8,955,037 EXPENDITURE SUMMARY GENERAL GOVERNMENT NON DEPARTMENTAL CITY COUNCIL CITY MANAGER MUNICIPAL COURT COMMUNITY DEVELOPMENT LEGAL SERVICES FACILITY MAINTENANCE CITY SECRETARY PUBLIC INFORMATION TOTAL GENERAL GOVERNMENT PUBLIC SAFETY POLICE FIRE INSPECTIONS TOTAL PUBLIC SAFETY PUBLIC ENVIRONMENT STREETS TOTAL PUBLIC ENVIRONMENT 2O7 545 25 616 305 643 194 211 272 093 256 75O 281 564 109,397 1,652,819 1,773,633 1,023,916 221,879 3,019,428 513,593 513,593 1,794 524 18,088 277 888 216 119 137 817 88 729 348 225 124815 3,006,205 2,313,007 1,205,938 281,891 3,800,836 429,430 429,430 399 800 23 250 329 988 249 975 268 630 147500 323,148 124,081 1,866,372 2,156,806 1,203,840 282,076 3,642,722 473,989 473,989 440,200 16,850 338 575 261 514 278 772 147 50O 347 234 216124 71,205 2,117,974 2,366,993 1,515,628 318,206 4,2OO,827 586,836 586,836 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED PARKS & RECREATION PARKS POOLS TOTAL PARKS & RECREATION CULTURAL LIBRARY TOTAL CULTURAL HEALTH ANIMAL CONTROL TOTAL HEALTH INTERNAL SERVICE INFORMATION TECHNOLOGY HUMAN RESOURCES FINANCE FLEET SERVICE TOTAL INTERNAL SERVICE MISCELLANEOUS PATIENT ASSISTANCE TOTAL MISCELLANEOUS 185,667 288,914 469,330 446,259 - 105,094 - 130,789 185,667 394,008 469,330 577,048 305,865 310,740 296,908 330,001 305,865 310,740 296,908 330,001 120,527 173,024 200,814 214,142 120,527 173,024 200,814 214,142 301,506 453,489 297,000 334,618 265,489 126,525 146,740 142,681 172,555 186,958 198,350 217,883 120,061 158,295 150,559 190,580 859,611 925,267 792,649 885,762 6,463 - 11,000 11,000 6,463 - 11,000 11,000 6 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 ACTUAL 2002-2003 2003-2004 CITY COUNCIL ACTUAL BUDGET APPROVED REVENUES Taxes 000-411100 000-411200 000-411300 000-411400 000-411500 O00-4116O0 000-411700 Advalorem Tax - Current Advalorem Tax - Delinquent Advalorem Tax - P&I Roll Back Property Tax Sales Tax Revenue - Gen. Fund Bingo Tax Mixed Beverage TotalTaxes Franchises 000-421200 000-421220 000-421240 000-421300 000-421440 000-421460 000-421480 000-421500 Center PointJEntex Energy City Public Service Guadalupe Valley Elec Co-op Time Warner/Paragon Cable Southwestern Bell Telephone AT&T Franchise Fee Other Telecom Franchise Solid Waste Franchise Fee Total Franchises Permits 000-431100 000-431200 000-431300 000-431400 000-431500 000-431600 000-431700 000-431750 000-431800 000-431900 000-431950 000-432000 000-445000 Home Occupation Permit Building Permit Mobile Home Permit Signs Permit Food Establishment Permit Garage Sale Permit Plumbing Permit Electrical Permit Mechanical Permit Solicitor/Peddler Permit Animal/Pet Permit Certificate of Occupancy Permit Security Alarm Permit Total Permits 2,605,782 3,140,463 3,190,892 3,639,524 40,662 43,197 35,000 35,000 27,696 32,203 25,000 25,000 - 29,000 10,000 1,432,187 1,487,282 1,550,000 1,700,000 4,954 4,528 4,500 4,500 3,881 4,243 4,500 4,500 4,115,162 4,711,916 4,838,892 5,418,524 15,742 12,774 17,000 18,000 63,518 75,949 75,000 90,000 210,894 294,145 235,000 250,000 158,521 92,159 170,000 175,000 57,583 60,185 60,000 65,000 - 5,149 4,354 4,500 13,185 16,814 17,000 17,000 42,781 41,361 40,000 50,720 562,224 598,536 618,354 670,220 221 125 300 300 288,118 360,168 350,000 380,000 505 160 300 300 107 982 1,000 1,000 15,709 27,295 15,000 15,000 4,705 7,550 6,500 6,500 41,369 58,309 45,000 50,000 29,445 36,442 35,000 40,000 17,816 21,053 18,000 20,000 850 485 500 750 600 895 650 900 585 610 600 1,000 7,291 5,000 7,000 400,030 521,365 477,850 522,750 7 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND i' '~)~)l~.2002 ACTUAL 2002-2003 2003-2004 CITY COUNCIL ACTUAL BUDGET APPROVED Licenses 000-441000 000-442000 000-443000 000-444000 Alcohol Beverage License Contractors License Electrical License Pet License Total Licenses Fees 000-451000 000-451100 000-451200 000-451400 000-451500 000-451600 000-451700 000-451800 000-451850 000-451900 000-452000 000-452100 000-452200 000-452300 000-452400 000-452500 000-452600 000-453100 000-453110 000-453200 000-453300 000-453400 000-453600 000-453700 000-454100 000-454200 000-454300 000-454400 000-458100 000-458300 000-458400 Municipal Court Fines Arrest Fee Warrant Fees Traffic Fine Costs TTL Teen Court Admin Fee Technology Fund Fee Secudty Fee Time Payment Fee - City State Fines 10% Service Fee DPS Payment- Local Child Safety Fee Platting Fees Site Plan Fee Plan Check Fee BOA/Zoning Fees Food Handler Class Specific Use/Zone Chng Fee Reinspection Fees Swim Pool Inspection Fee Mowing Fees- Inspections Solicitor's Investigation Electrical Admin Fees Mechanical Admin Fees Plumbing Admin Fees Swim Pool Reservation Fee Pool Gate Admission Fee Seasonal Pool Pass Fee Swimming Lessons Fee Sale of Merchandise Sale of Property/Auction Building Rental Fee 2,848 2,872 3,000 3,000 15,225 14,300 15,000 15,000 16,025 13,745 16,000 - 2,541 2,315 2,400 2,500 36,639 33,232 36,400 20,500 349,418 22,051 48,064 10,417 468 18,276 14,432 1,403 15,744 4,560 20,373 6,484 130,365 11,299 554 35,910 1,545 1,838 17,313 4,835 10,781 (2,200) 7,166 451,795 30,671 63,465 14,951 860 26,594 20,330 1,719 31,288 5,485 7,310 33,626 2,300 165,956 1,900 12,020 2,500 62,823 225 2,296 620 1,880 19,155 5,455 7,778 60 12,573 8,022 400,000 25,000 50,000 14,000 500 22 000 17 000 1 500 25 000 5 000 4 000 35 000 9 000 170 000 I 800 10 000 I 000 80 000 1,500 1,000 1,000 15,000 7,000 11,000 300 20,000 6,500 475,000 30,000 60,000 14,000 500 25,000 19,000 2,000 30,000 5,000 4,500 42,000 8,000 185,000 1,800 11,000 3,000 85,000 75 1,500 1,000 2,400 2,400 3,400 2,000 17,000 7,000 15,000 300 20,000 5,000 8 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 ACTUAL 2002-2003 2003-2004 CITY COUNCIL ACTUAL BUDGET APPROVED Fees continued 000-458500 O00-4586OO 000-458700 000-459100 000-459200 000-459300 000-459400 000-459600 000-459700 000-459800 Property Rental Fee Ball Field Use Vehicle Impoundment Credit Card/Check Fee NSF Check Fee Notary Fee Maps, Copies, UDC Misc Animal Adoption Fee Pet Impoundment Fee Police Reports Fee Total Fees Fines 000-463000 Library Fines Total Fines 000-473100 000-473200 000-473300 000-473800 000-474100 000-474200 000-474400 000-474500 000-474600 Inter-Jurisdictional Bexar Co - Fire Guadalupe Co - Fire Guad Co. Library Guadalupe Co Econo Develop Cibolo Fire Contract Library Services - Cibolo Dispatch Service - Cibolo Dispatch Service-SCUCISD School Crossing Guard-Bexar Total Inter-Jurisdictional 000-480000 000-489010 000-480200 000-485000 000-486000 000-487000 000-488000 Fund Transfers Indirect Costs -EMS Indirect Costs -Hotel Inter'fund Transfer-Parks Interfund Charge-Drainage-3% Interfund Charges - Water Interfund Charges-Fleet Interfund Charges-4B Total Fund Transfers 5,026 4,235 4,500 6,000 (350) 250 250 540 470 500 500 2,397 (7,854) 1,500 1,000 260 50 250 250 173 267 200 200 1,254 2,570 2,000 2,000 9,673 16,254 10,000 13,000 12,967 14,143 11,500 11,500 3,548 4,554 4,000 5,000 778,863 1,028,346 968,800 1,117,575 12,902 18,943 18,000 18,000 12,902 18,943 18,000 18,000 10,800 13,894 13,725 14,000 24,728 100 - 37,000 95,378 95,353 112,458 112,500 25,000 - - 15,000 15,000 - - 2,500 2,500 2,500 2,500 15,281 26,300 56,402 81,928 1,200 1,200 2,500 1,200 - - 1,181 164,887 179,347 187,585 250,309 18,328 2,500 553,729 573,834 25,000 25,000 2,500 50,000 2,000 - - 40,000 - - 9,300 - 548,834 548,834 - 54,025 - - 30,000 574,557 576,334 623,834 709,159 9 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001 2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED Miscellaneous 000-491000 Interest Earned 17,100 7,924 15,000 5,000 000-491200 Investment Income 62,441 61,762 40,000 40,000 000-493100 Donations - Christmas D~cor 452 - 500 - 000-493200 Donations - Parade Float - 50 - 000-493400 Donations - Animal Control 2,336 1,060 2,500 2,500 000-494481 LawEnforcemtOfficersStnd&Ed 2,899 4,264 4,500 4,500 000-495014 Woodland Oaks Park-Match - 5,000 10,000 000-497000 Misc Income-Gen Fund 62,364 43,321 25,000 25,000 000-497100 Misc Income- Police 1,931 3,880 5,750 5,000 000-497200 Misc Income - Library 2,376 4,580 6,000 6,000 000-497300 Misc Income - Animal Control 48 18 50 5,000 000-497400 Misc Income - Streets Dept 3,927 6,595 3,750 5,000 000-497500 Misc Income - TML Insurance - 5,000 000-498000 Reimbursement-Gen Fund 20,844 (1,276) 15,000 15,000 000-499000 Tmnsferfrom Reserves - - 100,000 Total Miscellaneous 176,718 132,128 123,100 228,000 10 CITY OF SCHERTZ COMMENTARY DEPARTMENT: CITY COUNCIL FUNCTION: The City Council consists of five members and the Mayor and is the governing and legislative body of the City of Schertz. The Mayor and City Council are responsible for policy, leadership and general direction of City Govemment. The Mayor and all Council members are elected from the City at large, with each Council member occupying a numbered position. Terms of the Mayor and members of the Council are staggered with the Mayor and Council members filling positions number one and two, elected in even numbered years, and positions three, four and five elected during odd-numbered years. Elections to the positions are held in May of each year for a new two-year term. The Council operates under a Home Rule Charter. 11 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES CITY COUNCIL Supplies 150-521100 Office Supplies Total Supplies City SuDDort Services 150-532600 City Elections 150-532800 Special Events Total City Support Services Staff Support e 150-535200 Annual Awards 150-535300 Memberships Prof Orgs 150-535500 Training/Travel Total Staff Support Professional Services 150-541300 Other Consul/Prof Services Total Professional Services 167 184 200 200 167 184 200 200 - 4,068 6,000 6,000 8,209 5,371 6,500 - 8,209 9,439 12,500 6,000 - 150 150 5,203 3,956 5,500 5,500 4,521 3,873 4,500 5,000 9,724 '7,829 10,150 10,650 4OO 4OO 12 CITY OF SCHERTZ COMMENTARY DEPARTMENT: CITY MANAGER FUNCTION: The City Manager is appointed by the City Council and is Chief Executive Officer of the City. The City Manager's Department consists of the City Manager, Executive Services Coordinator, Assistant City Manager, and Administrative Assistant to the Assistant City Manager. Responsibility of this department includes personnel appointment and removal, preparation and execution of the City budget, as well as administration of City Ordinances and policy as adopted by the City Council. 13 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES CITY MANAGER Personnel Services 151-511110 Regular 151-511120 Overtime 151-511180 LTD 151-511210 Longevity 151-511124 Vehicle Allowance 151-511310 FICA- Employer 151-511350 TMRS - Employer 151-511410 Health- Employer 151-511500 Workers Compensation Total Personnel Services Supplies 151-521100 Office Supplies Total Supplies City-Support Services 151-532800 Special Events Total City Support Services Operations Support 151-534000 Postage Total Operations Support Staff SUDDOrt 151-535100 151-535200 151-535300 151-535400 151-535500 151-535600 Uniforms Annual Awards Memberships Publications Training/Travel Professional Certification Total Staff Support Operatin~l Equipment 151-57100 Furniture & Fixtures Total Operating Equipment 208,482 201,917 234,507 241,183 - 167 2,000 - 306 514 689 676 1,320 5,568 8,496 9,084 4,454 9,427 10,200 10,800 15,087 16,252 18,757 19,145 15,067 14,466 16,907 21,168 6,293 10,373 13,401 15,388 - 6O3 7O6 881 251,009 259,287 305,663 318,325 1,718 1,986 1,700 1,700 1,718 1,986 1,700 1,700 2,846 577 600 2,846 577 600 ; 495 314 450 495 314 450 261 206 150 200 5,122 1,241 5,000 4,500 1,801 1,276 3,200 3,200 124 230 500 400 8,157 8,048 10,000 10,000 71 225 250 15,465 11,072 19,075 18,550 1,185 2,500 1,185 2,500 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: MUNICIPAL COURT FUNCTION: The ultimate purpose of the Schertz Municipal Court is to administer justice at the municipal level. Staff is responsible for accepting, processing and adjudicating all "Class C Misdemeanor" complaints filed by a vadety of internal and external sources that occur within the territorial jurisdiction of the City of Schertz. It is the responsibility of this department to maintain accurate records as the court case progresses through judgment and the satisfaction of that judgment including the collection of court costs and fines. 15 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES MUNICIPAL COURT Personnel Services 152-511110 152-511120 152-511180 152-511210 152-511230 152-511240 152-511310 152-511350 152-511410 152-511500 Regular Overtime LTD Longevity Certification Allowance Vehicle Allowance FICA- Employer TMRS - Employer Health - Employer Workers Compensation Total Personnel Services Supplies 152-521100 Office Supplies 152-521600 Equip Maint Supplies Total Supplies City Support Services 152-532800 Special Events Total City Support Services Utility Services 152-533500 Vehicle Fuel Total Utility Services Operations Support 152-534000 Postage 152-534200 Printing & Binding 152-534300 Copy Service Total Operations Support 130,192 144,001 152,792 168,418 994 2,187 3,000 2,500 267 353 432 466 4,080 4,488 1,080 1,680 600 485 300 600 2,400 2,400 2,400 2,400 10,566 11,553 11,755 13,204 9,763 10,414 10,596 14,598 11,336 15,575 20,101 23,082 644 1,429 1,791 170,198 192,100 203,885 228,739 1,278 629 2,000 2,000 - 2,350 1,000 1,000 1,278 2,979 3,000 3,000 250 1,000 2,000 250 1,000 2,000 1,086 1,286 1,800 1,800 1,086 1,286 1,800 1,800 898 1,641 2,000 - 609 836 1,950 1,950 973 1,037 - 2,480 3,514 3,950 1,950 16 101 GENERAL FUND CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 ~2001.2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Staff Support 152-535100 152-535300 152-535400 152-535500 152-535600 Uniforms Memberships Publications Training/Travel Prof. Certs Total Staff Support Court Support 152-536100 State Comp- FTA 152-536200 OMNI-Base-FTA 152-536400 Collection Expense 152-536500 Court/Jury Cost Total Court Support Professional Services 152-541300 Other Consul/Prof Service Total Professional Services Maintenance Services 152-551800 Other Maintenance Agreement Total Maintenance Services ODeratinQ EQuk)ment 152-571000 Furniture & Fixtures 152-571300 Computer & Peripherals Total Operating Equipment Capitalized Eaui~3ment 152-581400 Communications Equipment Total Capitalized Equipment 367 109 800 250 195 184 450 450 385 465 1,800 1,500 4,122 402 5,000 5,325 175 150 540 100 5,244 1,310 8,590 7,625 1,500 1,500 1,000 581 715 1,500 606 42 1,600 1,600 1,187 757 6,100 2,600 7,270 5,100 5,500 5,500 7,270 5,100 5,500 5,500 181 375 181 375 224 199 650 - 1,711 7,223 7,500 7,500 1,935 7,422 8,150 7,500 59 8,000 800 59 8,000 800 17 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: INFORMATION TECHNOLOGY FUNCTION: The Information Technology Department is responsible for all voice and data communications within the City government. This includes, but not limited to software, hardware, and network communication upgrades and/or replacement. Information Technology handles all day-to-day issues encountered by City employees in the operation of their computers, peripherals, cell phones, pagers and telephones. 18 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES INFORMATION TECHNOLOGY Personnel Services 853-511110 853-511180 853-511210 853-511310 853-511350 853-511410 853-511500 Regular LTD Longevity FICA- Employer TMRS - Employer Health - Employer Workers Compensation Total Personnel Services Supplies 853-521100 Office Supplies 853-521600 Equip Maint Supplies Total Supplies City Support Services 853-532300 Computer Consulting 853-532400 Computer Fees & Licenses Total City Support Services Utility Services 853-533300 Telephone Total Utility Services Operations Support 853-534000 Postage Total Operations Support Staff Support 853-535100 Uniforms 853-535300 Memberships 853-535400 Publications 853-535500 Training/Travel Total Staff Support 60,504 91,961 96,581 100,812 115 218 262 274 120 360 600 4,415 6,899 7,125 7,758 4,189 6,314 6,422 8,577 3,145 6,002 6,700 7,694 - 286 268 357 72,368 111,800 117,718 126,072 181 298 300 250 474 3,418 3,000 3,500 655 3,716 3,300 3,750 13,842 9,913 6,000 6,000 18,279 35,207 47,432 82,782 32,121 45,120 53,432 88,782 1,427 30,060 64,800 50,000 1,427 30,060 64,800 50,000 66 122 150 66 122 150 65 70 70 100 150 300 178 - 250 250 1,656 931 2,500 5,256 1,899 1,031 2,970 5,876 19 101 GENERAL FUND CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Maintenance Services 853-551300 Computer Maint 853-551800 Other Maint, Agreement Total Maintenance Services Operatinq Equipment 853-571000 Furniture & Fixtures 853-571300 Computer & Peripherals Total Operating Equipment Capitalized Equipment 853-581401 Communication Equipment Total Capitalized Equipment 1,087 888 1,500 7,288 3,790 - 2,000 4,200 4,877 888 3,500 11,488 857 - 130 - 184,395 22,950 25,000 43,850 185,252 22,950 25,130 43,850 2,607 3,156 26,000 4,800 2,607 3,156 26,000 4,800 20 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: COMMUNITY DEVELOPMENT FUNCTION: The function of this department is the administration of the Unified Development Code (UDC), Comprehensive Land Plan, Master Jogging, Bicycle and Pedestrian Plan, Annexation, Zoning, ET J, AICUZ, Grants, historical programs, and assist the City Manager with FEMA Hazard Mitigation. To provide staff support for the Planning and Zoning Commission, Board of Adjustments, Comprehensive Land Plan Review Commission, Schertz Development Foundation and the Economic Development Commission. This department is also responsible for all Tax Abatement applications and processing, recruitment of new business and industry, and retention and expansion of local business. 21 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES COMMUNITY DEVELOPMENT Personnel Services 154-511110 Regular 154-511120 Overtime 154-511180 LTD 154-511210 Longevity 154-511310 FICA - Employer 154-511350 TMRS - Employer 154-511410 Health - Employer 154-511500 Workers Compensation Total Personnel Services Supplies 154-521000 Operating Supplies 154-521100 Office Supplies 154-521600 Equipment Supplies Total Supplies City Support Services 154-532400 Computer Fees & License 154-532800 Special Events Total City Support Services Operations Support 154-534000 Postage 154-534100 Advertising 154-534200 Printing & Binding Total Operations Support Staff Support 154-535100 Uniforms 154-535300 Memberships 154-535400 Publications 154-535500 Training/Travel Total Staff Support 107,761 59,601 140,149 146,283 2,608 2,468 2,000 2,000 195 134 386 404 2,976 600 840 1,392 8,830 4,729 10,510 11,450 8,312 3,988 9,473 12,660 6,057 5,594 13,401 15,388 216 396 520 136,739 77,330 177,155 190,097 490 137 4OO 9O0 2,626 2,138 2,500 3,000 - - 200 200 3,116 2,275 3,100 4,100 - - 1,000 2,455 439 2,000 1,000 2,455 439 2,000 2,000 725 582 1,900 - - - 3,000 - 1,597 527 2,500 1,500 2,322 1,109 7,400 1,500 474 64 2OO 200 1,351 460 2,100 2,200 281 84 675 1,175 8,296 9,615 15,000 15,000 10,402 10,223 17,975 18,575 22 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Professional Services 154-541300 Engineering Services 154-541500 State/County Admin Fees Total Professional Services 88,397 41,143 59,000 60,000 1,126 844 2,000 2,500 89,523 41,987 61,000 62,500 23 CITY OF SCHERTZ COMMENTARY DEPARTMENT: LEGAL SERVICES FUNCTION: The Legal Department is responsible for legal transactions of the City of Schertz. The City Attorney is appointed by the City Council and serves as the legal advisor to the City Council and City operations. It is the duty and responsibility of the City Attorney to examine and approve or disapprove, as to form and legality, all documents, contracts and legal instruments in which the City has an interest. The City Attorney, through his law firm, represents the City of Schertz in areas of litigation, contract dispute and other civil matters. 24 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES LEGAL SERVICES Operations Support 155-534100 Advertising Total Operations Support Professional Services 155-541200 Legal Services Total Professional Services 12,854 13,017 12,500 12,500 12,854 13,017 12,500 12,500 243,896 75,712 135,000 135,000 243,896 75,712 135,000 135,000 25 CITY OF SCHERTZ COMMENTARY DEPARTMENT: POLICE FUNCTION: The police department provides community based law enforcement. This approach is dedicated to the proactive approach of the prevention of crime, protection of life and property while remaining sensitive to the needs of the citizens they serve. The uniform patrol division is expected to answer in excess of 34,000 calls for service in 2004/2005 fiscal year while stdving to maintain a response time averaging 4.00 minutes. Officers will generate 12,000 field generated calls and averaging 14,000 citations issued. The department will strive to maintain a stable Part 1. cdme rate and or reduction by 5% using proactive measures to target problem areas. Increases in staffing levels will aid in higher visibility of patrol officers on the street to reduce the fear of crime and increased saturation of problem areas. Call volumes are expected to reach 15 or more percent increases over the same pedod last year. Crime trends may fluctuate due to this increase and the stability of economic conditions. Traffic will increase in new development of commercial areas placing a demand for police/fire and EMS services. 26 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 200i-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVFF) PUBLIC SAFETY EXPENDITURES POLICE Personnel Services 256-511110 256-511120 256-511180 256-511210 256-511220 256-511230 256-511310 256-511350 256-511410 256-511500 Regular Overtime LTD Longevity Clothing Allowance Certification Allowance FICA- Employer TMRS - Employer Health - Employer Workers Compensation Total Personnel Services Supplies 256-521000 256-521100 256-521200 256-521300 256-521600 Operating Supplies Office Supplies Medical Supplies Motor Veh. Supplies Equip Maint Supplies Total Supplies Citv-SuDDort Services 256-532500 City-Insurance-Comm. Total City Support Services Utility Services 256-533100 Gas Utility Service 256-533200 Electricity Utility Service 256-533410 Water Utility Service 256-533500 Vehicle Fuel Total Utility Services 1,234,881 14 169 254O 34 404 46 608 6 393 99 182 92 095 101449 1,411,207 1,432,885 1,608,471 28,461 20,000 20,000 3,533 4,061 4,467 37,380 41,580 46,620 46,202 61,500 48,430 8,470 8,401 8,608 114,953 110,540 128,145 102,694 98,146 139,918 142,332 156,003 192,348 42,648 37,423 50,561 1,631,721 1,937,880 1,970,539 2,247,568 10,344 4,165 11,527 13,000 13,100 4,267 5,000 5,000 - 1,500 979 500 500 1,283 500 500 14,509 18,056 20,500 19,100 3O2 18,801 4,842 26,287 50,232 18,000 18,000 469 600 - 22,494 18,000 - 3,853 3,600 - 40,874 38,000 40,000 67,690 60,200 40,000 27 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Operations Support 256-534000 Postage 256-534100 Advertising 256-534200 Printing & Binding Total Operations Support Staff Support 256-535200 Annual Awards 256-5335300 Memberships 256-535400 Publications 256-535500 Training/Travel 256-535500 T-Class Training Total Staff Support City Assistance 256-537100 Medical Services 256-537500 Citizen's Police Academy 256-537800 Crime/Fire Prevention Total City Assistance Professional Services 256-541300 Other Consult/Prof Serv. Total Professional Services Maintenance Services 256-551400 Minor & Other Equip. Maint 256-551800 Other Maintenance Agrmt Total Maintenance Services Rental-Lease 256-561100 Rental-Equipment 256-561200 Lease/Purchase Pmts. Total Rental-Lease OI3eratin.q Equipment 256-571000 Furniture & Fixtures Total Operating Equipment 790 1,173 1,300 74 - 200 200 1,084 2,412 1,500 1,948 3,585 3,000 200 - 200 200 476 516 600 875 365 395 967 1,500 8,918 9,547 11,000 12,000 - 4,000 4,500 9,759 10,458 16,767 19,075 950 1,435 1,500 2,500 - 162 100 200 946 618 1,500 2,500 1,896 2,215 3,100 5,200 5,954 9,534 2,100 1,600 5,954 9,534 2,100 1,600 3,002 1,417 2,500 2,300 11,395 7,023 13,000 10,450 14,397 8,440 15,500 12,750 2,590 5,403 4,600 2,802 3,031 2,000 5,392 8,434 6,600 3,384 902 2,000 3,384 902 2,000 5OO 5OO 1,000 1,000 28 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 200~'-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Capitalized Equipment 256-581200 Motor Vehicles 256-581400 Communications Equip. 256-581800 Other Equipment Total Capitalized Equipment - 192,519 50,000 5,528 2,578 1,500 1,639 6,253 5,000 2,000 7,167 201,350 56,500 2,000 29 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: FIRE FUNCTION: Established in 1956 as a volunteer fire department. Today, the department has 21 full-time firefighters and 4 staff employees to provide fire protection, fire prevention, rescue, hazardous materials response, weapons of mass destruction response, and emergency medical first response (advance life support level of care) services to the community. The department also, provides fire prevention education, code enforcement, and arson investigation. Fire personnel are on duty 24-hours a day, 365 days a year to provide immediate response to emergency situations and public assistance. Fire Emergencies are down by 24% from 2001 which is directly related to fire prevention by the Schertz Fire & Rescue, our vigilant citizens and new construction. The following is a list of programs that will assist the fire services in building a better community to live in: Automatic Aid: Enhance the Automatic Aid Response program in the Tri-County area to reduce response time to area residents to assure that search and rescue can be improved. Fire Prevention Activities: Conduct demos of our fire safety house, fire equipment and station, fire safety lectures, fire extinguisher classes, and teaching fire safety and fire prevention skills. Additional programs include Juvenile Fire Setter Intervention Program, Fire Safety House Education, Pre-Planning Target Hazards, and Developing evacuation programs for industrial & assembly occupancy. 30 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES FIRE Personnel Services 257-511110 Regular 257-511120 Overtime 257-511180 LTD 257-511210 Longevity 257-511122 Clothing Allowance 257-511310 FICA - Employer 257-511350 TMRS - Employer 257-511410 Health - Employer 257-511500 Workers Compensation Total Personnel Services Supplies 257-521000 257-521100 257-521200 257-521300 257-521600 Operating Supplies Office Supplies Medical/Chemical Supplies Motor Veh. Supplies Equip Maint Supplies Total Supplies Utility Services 257-533100 Gas 257-533200 Electricity 257-533410 Water Utility Service 257-533500 Vehicle Fuel Total Utility Services Operations Support 257-534000 Postage 257-534200 Printing & Binding 257-534300 Copy Services Total Operations Support 672,394 782,607 30,491 21,665 1,348 1,919 13,920 13,860 - 30,661 52,721 61,196 51,016 56,137 50,054 72,773 - 18,655 795 230 50 000 2,523 14 316 7 500 63 189 58,914 81,454 18,618 871,944 1,059,473 1,091,744 1,008,307 49.000 2 904 17184 9 372 82 275 90 965 119 256 26 809 1,406,072 4,738 4,000 3,700 1,500 1,960 1,795 2,000 2,250 5,717 8,168 9,000 9,365 777 1,231 500 500 1,864 2,305 2,000 2,000 15,056 17,499 17,200 15,615 1,726 1,604 2,050 1,100 10,525 12,533 12,000 7,800 2,367 2,810 2,138 1,900 5,573 9,385 8,500 9,000 20,191 26,332 24,688 19,800 169 122 300 - 208 238 400 400 1,188 1,647 - - 1,565 2,007 700 400 31 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001.2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED Staff Support 257-535000 257-533530 257-535400 257-535500 257-535600 Uniforms Memberships Publications Training/Travel Prof. Certs Total Staff Support City Assistance 257-537800 Crime/Fire Prevention Total City Assistance Maintenance Services 257-551400 Minor & Other Equip Maint Total Maintenance Services Rental-Lease 257-561200 Lease/Purchase Payments Total Rental-Lease ODeratina E(~uipment 257-571000 Furniture/Fixture Total Operating Equipment Capitalized Equipment 257-581300 Police/Fire/Medical Equip. 257-581400 Communications Equipment 257-581700 Other Improvements 257-581800 Other Equipment Total Capitalized Equipment 32,193 - 22,003 25,184 1,205 1,348 2,040 2,040 1,087 807 1,475 1,565 22,849 20,116 13,960 17,050 315 630 840 1,472 57,649 22,901 40,318 47,311 7,528 18,326 7,925 10,050 7,528 18,326 7,925 10,050 2,352 3,343 3,500 3,350 2,352 3,343 3,500 3,350 2,119 2,311 2,876 2,880 2,119 2,311 2,876 2,880 348 2,100 348 2,100 24,548 2,500 3,555 4,875 2,250 2,400 - 2,149 - 10,490 3,150 28,103 4,875 14,889 8,050 32 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: INSPECTIONS FUNCTION: Enforces the building, residential, electrical, energy, gas, mechanical, plumbing and backflow and cross-connection codes adopted by the City through permits and inspections. Provides support and enforcement of the City's Unified Development Code in cooperation with Planning and Zoning. Investigates and resolves complaints received by the public conceming alleged code violations. Conducts plan review of all proposed construction within the city limits. Assists the Health Official by issuing food establishment permits, while providing information necessary for the maintenance of sanitation within food environments. Assists Public Works Director in conducting customer service inspections and maintaining records concerning backflow devices in compliance with Texas Commission on Environmental Quality rules and regulations. 33 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES INSPECTIONS Personnel Services 258-511110 Regular 258-511120 Overtime 258-511180 LTD 258-511210 Longevity 258-511310 FICA - Employer 258-511350 TMRS - Employer 258-511410 Health - Employer 258-511500 Workers Compensation Total Personnel Services Supplies 258-521000 Operating Supplies 258-521200 Medical Supplies 258-521600 Equip Maint Supplies Total Supplies Utility Services 258-533500 Vehicle Fuel Total Utility Services Operations Support 258-534000 Postage 258-534100 Advertising 258-534200 Printing & Binding Total Operations Support Staff Support 258-535100 258-535300 258-535400 258-535500 258-535600 Uniforms Memberships Publications Training/Travel Prof. Certs Total Staff Support 135,557 163,363 158,609 173,528 664 1,115 2,000 1,500 269 382 549 493 3,564 6,204 6,636 7,428 10,092 12,266 14,942 13,958 9,958 11,545 13,468 15,432 12,780 19,008 23,451 23,082 - 1,381 1,477 1,551 172,884 215,264 221,132 236,972 1,762 3,974 4,350 4,350 - 500 500 300 799 2,325 2,000 2,062 4,773 7,175 6,850 1,315 2,425 2,400 2,400 1,315 2,425 2,400 2,400 1,829 1,333 1,500 500 500 2,273 1,825 1,700 1,700 4,102 3,158 3,700 2,200 2,118 1,761 2,090 2,120 255 280 480 525 1,377 2,070 650 2,150 2,232 2,790 5,410 6,000 230 150 250 250 6,212 7,051 8,880 11,045 34 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED City Assistance 258-537100 Medical Services Total City Assistance Professional Services 258-541300 Other Consult/Prof Service Total Professional Services Maintenance Services 258-551700 Lot Cleaning 258-551800 Other Maint. Agreement Total Maintenance Services Capital Outlay 258-581200 Motor Vehicles Total Professional Services 92 - 500 500 92 - 500 500 22,710 31,142 35,689 35,689 22,710 31,142 35,689 35,689 2,275 1,105 2,500 2,500 103 - 100 100 2,378 1,105 2,600 2,600 19,950 19,950 35 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: STREETS FUNCTION: To provide a means for transportation behveen the home, work place, recreational facilities and commercial establishments. Insuring the municipal roadways are sanitary and without excess debris. E:stablishing and maintaining sufficient traffic control devises to inform the general public on the conditions of the requirements for the use and control of vehicular movement through out the ci~. The Streets Department repairs and maintains 120 miles of paved roadways and 7 miles of gravel roads. Other work duties consist of a weekly chipping service, a C,i~y Sponsored clean up approximately six weeks a year, full time street sweeping, Traffic Sign Repair. 36 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED PUBLIC ENVIRONMENT EXPENDITURES STREETS Personnel Services 359-511110 359-511120 359-511180 359-511210 359-511310 359-511350 359-511410 359-511500 Regular Overtime LTD Longevity FICA- Employer TMRS - Employer Health - Employer Workers Compensation Total Personnel Services Supplies 359-521000 359-521100 359-521200 359-521300 Operating Supplies Office Supplies Medical/Chemical Supplies Motor Veh. Supplies Total Supplies Utility Services 359-533100 Gas Utility Service 359-533200 Electricity Utility Service 359-533410 Water Utility Service 359-533500 Vehicle Fuel Total Utility Services Operations Support 359-534300 Copy Services Total Operations Support 207,616 182,692 174,069 242,409 9,276 2,648 6,000 5,000 414 437 450 687 14,184 9,732 4,896 6,876 17,179 14,064 13,595 19,453 16,551 13,408 12,254 21,507 21,103 26,328 23,451 42,317 - 18,889 15,967 26,883 286,323 268,198 250,682 365,132 7,113 4,066 2,500 2,500 461 712 800 700 2,701 2,499 2,000 1,500 851 367 700 700 11,126 7,644 6,000 5,400 699 185 - - 20,279 27,180 35,000 35,000 4,338 521 900 900 11,133 18,636 10,000 12,000 36,449 46,522 45,900 47,900 250 - 250 250 25O - 250 25O 37 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Staff Support 359-535100 Uniforms 359-535300 Memberships 359-535500 Training/Travel 359-535600 Prof. Certs Total Staff Support Professional Services 359-541100 Engineering Services Total Professional Services Maintenance Services 359-551100 Building Maintenance 359-551400 Minor & Other Equip. Maint. 359-551600 Street Maintenance Total Maintenance Services Rental-Lease 359-561100 Rental Equipment 359-561200 Lease/Purchase Payments Total Rental-Lease Capitalized Equipment 359-581800 Other Equipment Total Capitalized Equipment 3,737 5,712 5,315 5,500 136 - 170 170 200 92 1,488 1,500 - - 500 300 4,073 5,804 7,473 7,470 58,496 7,411 6,600 6,600 58,496 7,411 6,600 6,600 428 - 1,000 1,000 - - 2,000 1,000 94,074 75,037 148,033 150,000 94,502 75,037 151,033 152,000 1,685 399 1,967 2,000 274 321 84 84 1,959 720 2,051 2,084 4,000 4,000 38 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: PARKS FUNCTION: The purpose of the Parks Department is to advance the parks, recreation and environmental efforts that enhance the quality of life of the citizens of the City of Schertz. Provide a safe and sanitary recreational City Park system by maintaining park equipment, baseball/softball fields, volleyball field, walk/jogging paths, and including the on-going day-to- day maintenance of the restrooms, pavilions and other recreational facilities. 39 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED PARKS & RECREATION EXPENDITURES PARKS Personnel Services 460-511110 460-511120 460-511180 460-511210 460-511240 460-511310 460-511350 460-511410 460-511500 Regular Overtime LTD Longevity Vehicle Allowance FICA- Employer TMRS - Employer Health o Employer Workers Compensation Total Personnel Services Supplies 460-521000 460-521100 460-521200 460-521400 460-521600 Operating Supplies Office Supplies Medical/Chemical Supplies Plumbing Supplies Equip Maint Supplies Total Supplies Utility Services 460-533200 Electric Utility Service 460-533410 Water Utility Service 460-533500 Vehicle Fuel Total Utility Services Operations Support 460-534000 Postage 460-534200 Printing & Binding Total Operations Support 71,151 127,123 279,606 203,984 2,282 5,035 3,000 3,000 143 282 460 578 1,752 4,500 6,012 6,936 1,500 1,500 5,606 9,918 21,325 16,365 5,405 9,281 11,496 18,093 7,809 13,082 18,426 26,929 3,709 5,855 4,424 94,148 172,930 347,680 281,809 4,903 3,805 9,000 10,000 894 363 1,000 500 1,082 - 13,000 2,000 1,093 545 2,000 5,000 4,425 346 1,000 - 12,397 5,059 26,000 17,500 5,032 11,963 13,500 15,000 9,056 13,275 12,900 15,000 2,254 3,837 3,000 3,000 16,342 29,075 29,400 33,000 91 78 100 20 500 91 98 600 200 2OO 40 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Staff Support 460-535100 Uniforms 460-535300 Memberships 460-535500 Training/Travel Total Staff Support City Assistance 460-537200 Buff Val Youth Assoc Total City Assistance Maintenance Services 460-551100 460-551400 460-551500 460-551600 460-551702 Building Maintenance Minor & Other Equip Maint. Water & Sewer Maint. Street Maint. Matedal Schertz Parkway Maint. Total Maintenance Services Rental-Lease 460-561200 Lease/Purchase Payments Total Rental-Lease Operatin.cl Ecluil~ment 460-571200 Office Equipment 460-571300 Computer & Peripherals Total Operating Equipment Capital Outlay 460-581400 Communications Equip. 460-581600 Trees 460-581700 Matching Improvements 460-581800 Other Equipment Total Capital Outlay 1,877 2,443 3,400 3,000 15 81 250 500 - 676 3,000 1,800 1,892 3,200 6,650 5,300 10,120 9,271 8,000 10,000 10,120 9,271 8,000 10,000 447 1,133 91 2,784 4,000 3,000 7,5OO 7,0OO 500 500 500 500 12,500 25,000 538 3,917 25,000 1,023 1,172 1,500 1,023 1,172 1,500 2,702 - 1,000 2,026 - 2,702 2,026 1,000 1,810 8 1,500 20,862 22,000 1,810 20,870 23,500 36,000 1,500 1,500 25O 40,000 20,000 7OO 60,950 41 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: FACILITY MAINTENANCE FUNCTION: This department's main functions include, but are not limited to, facilities maintenance repairs and upkeep of all City facilities, custodial services, and set up for meetings, special events and building rentals. Responsibilities include, maintaining 9 facilities totaling 73,505 sq. f. consisting of 23,406 sq. ft. carpet, 27,310 sq. ft. tile floors, 22,789 sq. ft. other flooring, 177 office/storage areas, 53 rest rooms, 7 meeting/training rooms, 125 sinks and water fountains, 38 air condition units, 3,641 light bulbs and ballasts, 2 emergency generators, average of 97 meetings/events - monthly along with numerous maintenance projects and repairs. 42 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED GENERAL FUND EXPENDITURES FACILITY MAINTENANCE Personnel Services 161-511110 161-511120 161-511180 161-511210 161-511310 161-511350 161-511410 161-511500 Regular Overtime LTD Longevity FICA- Employer TMRS - Employer Health - Employer Workers Compensation Total Personnel Services Supplies 161-521000 161-521100 161-521200 161-521300 161-521600 Operating Supplies Office Supplies Medical/Chemical Supplies Motor Veh. Supplies Equip Maint Supplies Total Supplies Utility Services 161-533200 Electric Utility Service 161-533300 Telephone Utility Service 161-533410 Water Utility Service 161-533500 Vehicle Fuel Total Utility Services Operations Support 161-534000 Postage 161-534200 Printing & Binding Total Operations Support 111,195 126,061 146,895 153,200 8,405 11,698 3,000 3,700 213 325 421 443 4,728 5,376 6,096 7,020 8,776 10,184 11,465 12,540 8,586 9,826 10,341 13,864 10,964 16,042 20,101 23,082 6,154 6,165 7,767 152,867 185,666 204,484 221,616 16,304 15,257 16,300 19,665 653 656 700 900 3,326 3,468 3,500 4,600 215 365 365 550 2,607 3,700 799 300 23,105 23,446 21,664 26,015 25,151 36,370 24,000 32,000 3,820 2,751 - - 2,770 3,186 3,300 3,700 2,862 2,924 3,800 3,800 34,603 45,231 31,100 39,500 61 90 150 - 127 100 100 188 90 250 100 43 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED Staff Support 161-535100 Uniforms 161-535300 Memberships 161-535400 Publications 161-535500 Training/Travel Total Staff Support 2,521 2,516 2,500 2,980 99 149 105 150 253 275 275 716 863 970 2,198 3,336 3,781 3,850 5,603 Maintenance Services 161-551100 161-551400 161-551700 161-551720 161-551800 Building Maintenance Minor & Other Equip Maint Ground Maintenance Landscaping Other Maint. Agreement Total Maintenance Services Rental-Lease 161-561100 Rental Equipment Total Rental-Lease Operating Equipment 161-571500 Operating Equipment Total Operating Equipment 24,198 39,952 45,000 40,000 783 800 800 550 1,539 - 3,000 2,600 2,0O0 - 3,919 8,661 10,500 7,500 30,439 49,413 61,300 50,650 149 479 500 750 149 479 500 750 2,976 2,616 2,976 2,616 3,000 3,000 44 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: ANIMAL CONTROL FUNCTION: To provide a Texas Department of Health approved quarantine facility for Rabies control. Promote education, programs, and services to our community for care, licensing, control, and service. Serve as a disaster relief center for pets during natural disasters in our region. To provide an enriched adoption facility that is both educational and customer oriented, at the same time maintaining comfort and concern for all pets during their stay. 45 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 ACTUAL 2002-2003 2003-2004 CITY COUNCIL ACTUAL BUDGET APPROVED HEALTH EXPENDITURES ANIMAL CONTROL Personnel Services 762-511110 762-511120 762-511180 762-511210 762-511220 762-511310 762-511350 762-511410 762-511500 Regular Overtime LTD Longevity Clothing Allowance FICA- Employer TMRS-Employer Health-Employer Workers Compensation Total Personnel Services 63,045 77,241 106,284 111,153 6,230 7,067 5,000 5,000 126 167 302 315 120 480 - 360 - - 3,500 3,000 5,004 6,342 8,223 8,913 4,953 5,526 7,412 9,855 7,020 11,836 16,751 20,632 - 1,609 2,074 2,614 86,498 110,268 149,546 161,842 Supplies 762-521000 762-521100 762-521200 762-521300 Operating Supplies Office Supplies Medical/Chemical Supplies Motor Veh. Supplies Total Supplies 4,817 4,846 7,000 5,000 1,265 729 1,250 1,200 3,444 5,899 5,000 6,000 - 100 400 400 9,526 11,574 13,650 12,600 Utility Services 762-533200 Electric Utility Service 762-533410 Water Utility Service 762-533500 Vehicle Fuel Total Utility Services 6,706 5,425 5,000 4,000 1,872 2,814 2,500 2,500 793 3,081 2,000 2,000 9,371 11,320 9,500 8,500 Operations Support 762-534000 Postage 762-534100 Advertising 762-534200 Printing & Binding 762-534300 Copy Services Total Operations Support 78 85 225 - - 20O 25O 730 508 2,000 2,000 580 500 - 808 1,173 2,925 2,250 46 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Staff Support 762-535100 Uniforms 762-535300 Memberships 762-535500 Training/Travel 762-535600 Professional Certification Total Staff Support City Assistance 765-537100 Medical Services Total City Assistance Professional Service,~ 762-541300 Other Consult/Prof Service Total Professional Services Maintenance Services 762-551100 Building Maintenance 762-551400 Minor & Other Equip Maint Total Maintenance Services Rental-Lease 762-561200 Lease/Purchase Payments Total Rental-Lease Operatinq Equipment 762-571000 Furniture & Fixtures Total Operating Equipment Capital Outlay 762-581400 Communications Equipment 762-581800 Other Equipment Total Capital Outlay 1,641 1,395 43 - 164 221 400 400 1,083 1,011 1,750 1,500 45O 7OO 2,888 2,627 2,643 2,600 5,984 9,407 12,000 15,000 5,984 9,407 12,000 15,000 1,710 4O0 750 1,710 400 750 2,505 7,291 6,000 6,000 493 316 1,500 750 2,998 7,607 7,500 6,750 44 194 150 44 194 150 700 350 700 350 800 1,000 1,800 3,500 3,500 47 This Page left Intentionally Blank CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED PARKS & RECREATION EXPENDITURES POOLS Personnel Services 463-511110 Regular 463-511120 Overtime 463-511310 FICA - Employer 463-511500 Workers Compensation Total Personnel Services Supplies 463-521000 463-521100 463-521200 463-521600 Operating Supplies Office Supplies Medical/Chemical Supplies Equip Maint Supplies Total Supplies Utility Services 463-533200 Electric Utility Service 463-533410 Water Utility Service Total Utility Services Operations Support 463-534000 Postage Total Operations Support Staff Support 463-535100 Uniforms 463-535500 Training/Travel Total Staff Support Maintenance Services 463-551100 Building Maintenance 463-551400 Minor & Other Equip Maint. Total Maintenance Services 45,503 65,363 - 86,000 268 1,539 - - o 3,502 5,118 - 6,579 355 1,894 3,110 49,628 73,914 - 95,689 2,350 3,831 - 1,000 233 348 - 5OO 6,025 7,125 - 11,000 62 25 - 1,000 8,670 11,329 - 13,500 4,761 4,469 - 6,000 2,612 2,949 - 5,000 7,373 7,418 - 11,000 5 9 5 9 - 1,447 - 600 416 201 - 2,500 416 1,648 - 3,100 6,684 1,432 - 1,000 259 755 - 1,000 6,943 2,187 - 2,000 49 CITY OF SCHERTZ COMMENTARY DEPARTMENT: POOL FUNCTION: To provide and maintain a well-managed and safe enviomment for aquatic pleasures for the citizens of our community. Providing for a system of instruction in aquatic safety, recreational swimming and physical fitness. Swimming lessons offered have been a great Success. 48 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Rental-Lease 463-561200 Lease/Purchase Payments Total Rental-Lease - 67 500 - 67 - 500 Capital Outlay 463-581700 Othe Improvements - 1,807 - 463-581800 Other Equipment - 6,715 5,000 Total Capital Outlay - 8,522 5,000 50 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: CITY SECRETARY FUNCTION: To maintain all City records such as Ordinances, Resolutions Minutes, Agendas, Council Packets, Projects, Policies, Warranty Deeds, Easements, Rights-of-way, Litigation, Election reports, Budgets, Audits, the Code of Ordinances, Vehicle Titles, Beer and Wine Permits and other miscellaneous correspondence. To attend all Council meetings and workshops, to take and transcribe minutes from such meetings and to post agendas for all Council meetings, workshops and meetings held by other boards and commissions. Attend annual Election Law Seminars so that this department stays current with the Election Laws. The Records Management Officer and part-time clerk have been added to this department and the function has expanded to include maintaining the City's Record Management Program in accordance with the City Ordinance and State mandates. Maintains the document imaging program and is responsible for the maintenance of the records control schedule. This area works closely with the Departmental Records Liaison for records destruction and provides correct documentation to all departments. 51 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES CITY SECRETARY Personnel Services 164-511110 Regular 164-511120 Overtime 164-511180 LTD 164-511210 Longevity 164-511310 FICA- Employer 164-511350 TMRS - Employer 164-511410 Health - Employer 164-511500 Workers Compensation Total Personnel Services Supplies 164-521000 Operating Supplies 164-521100 Office Supplies 164-521200 Medical/Chem Supplies Total Supplies City-Support Services 164-532500 City Insurance 164-532700 Records Management Total City Support Services Operations Support 164-534000 Postage 164-534200 Printing & Binding Total Operations Support Staff Support 164-535100 Uniforms 164-535300 Memberships 164-535400 Publications 164-535500 Training/Travel Total Staff Support 69,647 77,496 78,772 141,906 1,210 98 - 138 183 223 367 2,772 3,408 3,684 6,540 5,573 6,103 6,061 11,356 5,239 5,564 5,463 12,556 4,781 6,244 6,700 11,541 - 246 228 523 89,360 99,342 101,131 184,789 - - - 150 5,335 4,992 5,000 5,500 - - - 400 5,335 4,992 5,000 6,050 - 105 - 7,000 12,000 12,000 7,000 12,105 12,000 204 497 500 - 2,092 3,254 2,000 2,000 2,296 3,751 2,500 2,000 116 - 75 160 215 375 445 600 192 55 325 325 1,751 3,021 2,500 3,700 2,274 3,451 3,345 4,785 52 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 10t GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Operatin;! Equipment 164-571000 Computer/Peripherals Total Operating Equipment 2,840 - - 6,500 2,840 - 6,500 53 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: LIBRARY FUNCTION: The function of the Schertz Public Library is to serve the community as a center of reliable information and provide opportunity and encouragement for people of all ages to educate themselves continually. The Library assembles, preserves and makes available to all patrons in the service area, pdnted and other materials that will assist them in fields of knowledge and recreation. The library service area includes the State of Texas, with the pdmary area being the City of Schertz and Guadalupe County. 54 CITY OFSCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED CULTURAL EXPENDITURES LIBRARY Personnel Services 665-511110 665-511120 665-511180 665-511210 665-511310 665-511350 665-511410 665-511500 Regular Overtime LTD Longevity FICA- Employer TMRS-Employer Health-Employer Workers Compensation Total Personnel Services Supplies 665-521000 Operating Supplies 665-521100 Office Supplies Total Supplies Utility Services 665-533200 Electric Utility Service 665-533410 Water Utility Service Total Utility Services Operations Support 665-534000 Postage 665-534200 Pdnting & Binding Total Operations Support Staff Support 665-535100 Uniforms 665-535200 Annual Awards 665-535300 Memberships 665-535500 Training/Travel Total Staff Support 171,568 169,429 164,297 183,888 1,191 340 1,000 1,000 285 366 404 430 6,732 4,572 3,648 5,244 13,199 12,700 12,426 14,545 12,029 10,805 9,913 16,081 13,245 18,181 20,101 23,082 - 678 479 681 218,249 217,071 212,268 244,951 1,076 2,727 2,000 6,000 5,355 5,990 6,000 2,000 6,431 8,717 8,000 8,000 6,531 7,841 7,500 9,000 708 1,068 1,200 1,200 7,239 8,909 8,700 10,200 832 924 1,200 2,839 889 2,000 3,671 1,813 3,200 357 396 44O 66 - 300 329 316 350 439 1,381 85O 1,191 2,093 1,940 2,500 2,500 5OO 3OO 35O 8OO 1,950 55 101 GENERAL FUND CITY OFSCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 2001-2002 ACTUAL 2002-2003 2003-2004 ACTUAL BUDGET CITY COUNCIL APPROVED Maintenance Services 665-551300 Computer Maint 665-551800 Other Maint Agreement Total Maintenance Services Operating Equipment 665-571000 Furniture&Fixture 665-571300 Computer/Peripherals 665-571400 Library Materials Total Operating Equipment 4,000 4,550 5,000 5,500 1,645 1,784 1,800 1,900 5,645 6,334 6,800 7,400 536 - 1,000 - - 5,000 5,000 44,592 44,995 50,000 50,000 45,128 44,995 56,000 55,000 56 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: HUMAN RESOURCES FUNCTION: Provides Recruiting, Hiring Process Management, Employee Orientation, Training, Benefits Administration, Employee/Labor Relations Facilitation, Job Description Development Facilitation, Performance Evaluation Processing, Workers Compensation Administration, Organizational Departure and COBRNHIPAA services and Research in the form of Salad' Surveys, Salary Reviews, and Staffing studies. Provides recommendations to Cib7 Manager on personnel issues. Provides assistance along with other cit~ departments for cit~ functions and projects as needed. 57 CITY OFSCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES HUMAN RESOURCES 866-511110 866-511120 866-511180 866-511210 866-511310 866-511350 866-511410 866-511500 866-511600 Personnel Services Regular OVertime LTD Longevity FICA- Employer TMRS - Employer Health- Employer Workers Compensation Unemployment Compensation Total Personnel Services Supplies 866-521000 Office Supplies Total Supplies Human Services 866-531100 Pre-Employment Check 866-531200 Medical Co-Pay 866-531300 Employee Assistance 866-531400 Tuition Reimbursement Total Human Services Operations Suppo~ 866-534000 Postage 866-534100 Advertising 866-534200 Pdnting & Binding Total Operations Suppo~ Staff Suppo~ 866-535100 Uniforms 866-535300 Memberships 866-535400 Publications 866-535500 Tmining/Tmvel Total Staff Suppo~ 25,283 47,722 53,510 52,099 1,556 15 750 750 48 113 148 145 120 360 600 840 1,764 3,382 4,032 4,107 1,858 3,296 3,635 4,541 2,317 5,824 6,700 7,694 178,728 152 152 186 9,349 21,881 30,000 30,000 221,023 82,745 99,527 100,362 709 552 8OO 5OO 709 552 800 500 64 247 275 250 275 1,650 2,500 2,000 6,190 6,171 7,271 7,500 3,552 9,360 9,000 8,000 10,081 17,428 19,046 17,750 322 702 600 - 14,115 9,961 12,000 10,000 380 926 1,800 525 14,817 11,589 14,400 10,525 - 70 140 415 160 310 310 - - 369 1,727 1,285 1,500 2,725 2,142 1,445 1,880 3,544 58 CITY OFSCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED City Assistance 866-537100 Medical Services Total City Assistance Professional Services 866-541300 Other Consul/Prof Service Total Professional Services Maintenance Service 866-551400 Minor & Other Equip. Maint. Total Maintenance Service 5,538 4,866 6,000 5,000 5,538 4,866 6,000 5,000 4,538 6,900 5,000 5,000 4,538 6,900 5,000 5,000 87 87 59 CITY OF SCHERTZ COMMENTARY DEPARTMENT: NON DEPARTMENTAL FUNCTION: This account includes a number of expenses and payments that are not specific to an individual function/department. Items in this account include Adit cost, City Insurance, Appraisal District contract, and Medical Services. Additionally this account contains provisions for contingency funds. 60 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES NONDEPARTMENTAL City Support Services 167-532200 County Appraisal Distdct 167-532500 City Ins-Com 167-532900 Contingencies Total City Support Services Operations Support 167-534000 Postage 167-534300 Copy Services 167-534600 Annexation Costs Total Operations Support City A~sistance 167-537100 Medical Services Total City Assistance Professional Services 167-541400 Auditor/Accounting Serv 167-541500 State/County & Admin Fees 167-541600 Miscellaneous Bank Charges Total Professional Services Fund Charges/Transfers 167-548106 Transfer to Special Event Fd Total Transfers - 68,425 65,000 65,000 38,717 71,245 75,000 80,000 26,123 1,341 25,000 25,000 64,840 141,011 165,000 170,000 - - - 16,700 250 - 25,000 27,000 - - 25,000 20,000 250 - 50,000 63,700 112,164 142,894 151,800 171,500 112,164 142,894 151,800 171,500 5,850 7,256 15,000 20,000 - 5,389 6,000 2,500 - 9,772 2,000 6,000 5,850 22,417 23,000 28,500 6,500 6,500 61 CITY OF SCHERTZ COMMENTARY DEPARTMENT: FINANCE FUNCTION: The Finance Department's function is to provide financial management assistance to the City Manager. To provide assistance to all departments with purchasing, accounts, payroll, payables, cash collections and budget. Specific duties include investments, budget, debt management, purchasing, financial reporting, accounts payable and payroll. 62 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES FINANCE Personnel Services 868-511110 868-511120 868-511180 868-511210 868-511310 868-511350 868-511410 868-511500 Regular Overtime LTD Longevity FICA- Employer TMRS - Employer Health - Employer Workers Compensation Total Personnel Services Supplies 868-521000 Operating Supplies 868-521100 Office Supplies Total Supplies Operations Support 868-534000 Postage 868-534200 Pdnting & Binding Total Operations Support Staff Support 868-535100 Uniforms 868-535300 Memberships 868-535400 Publications 868-535500 Training/Travel Total Staff Support ODeratin¢~ EouiDment 868-571300 Computer & Peripherials Total Operating Equipment 124,221 138,744 145,272 156,371 585 3,173 1,000 1,000 247 299 398 430 720 1,200 1,320 1,800 9,501 10,833 10,848 12,177 8,945 8,843 9,778 13,463 9,534 11,806 16,751 19,235 434 408 557 153,753 175,332 185,775 205,033 1,600 1,600 1,796 1,714 2,200 2,000 1,796 1,714 3,800 3,600 465 277 500 588 3,044 1,500 1,053 3,321 2,000 2,000 2,000 258 235 175 175 295 455 500 300 - 100 275 3,862 4,027 5,000 5,000 4,415 4,717 5,775 5,750 1,500 1,500 63 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: PUBLIC INFORMATION OFFICER FUNCTION: The City of Schertz Public Information Office develops and implements strategic communication plans tied to City goals and priorities in the areas of media relations, city advocacy, public education, public information, and cdsis communications. Additionally, the Public Information Office provides professional communication services including, designing print materials, web design, content management of website, taking photos, and creating media statements to support all City departments and City Council. 64 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES PUBLIC INFORMATION Personnel Services 170-511110 170-511180 170-511210 170-511310 170-511350 170-511410 170-511500 Regular LTD Longevity FICA- Employer TMRS- Employer Health - Employer Workers Compensation Total Personnel Services Supplies 170-521100 Office Supplies Total Supplies City Support Services 170-532800 Special Events Total City Support Services Operations Support 170-534100 Advertising 170-534200 Printing & Binding · Total Operations Support Staff Support 170-535100 170-535300 170-535400 170-535500 170-535600 Uniforms Memberships Publications Training/Travel Prof Certification Total Staff Support 20,463.00 36,247 37,544 39,907 39.00 89 102 108 120 - 1,502.00 3,002 2,768 3,053 1,400.00 2,568 2,495 3,375 1,244.00 3,239 3,350 3,847 165.00 124 104 140 24,813.00 45,269 46,483 50,430 1,051.00 993 1,500 1,400 1,051.00 993 1,500 1,400 3,183.00 1,668 1,500 3,183.00 1,668 1,500 1,770.00 1,841 2,000 500 2,708.00 8,180 13,500 14,000 4,478.00 10,021 15,500 14,500 113.00 58 40 75 160.00 470 400 500 72.00 1,064 200 300 1,461.00 1,320 1,100 2,500 - 14 500 500 1,806.00 2,926 2,240 3,875 65 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED Professional Services 170-541300 Other Consult/Prof Srvcs Total Professional Services 1,000 500 1,000 500 Equipment 170-571500 Operating Equipment Total Operating Equipment 500 500 66 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: FLEET FUNCTION: The Pdmary function of the Fleet Service Department is to perform preventive maintenance and repair on all city owned vehicles and equipment. Before subcontracting any repair work to local auto repair facilities or dealerships, Fleet Service reviews each repair order and examines the vehicles and equipment to determine if necessary repairs can be completed in house. 67 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES FLEET SERVICE Personnel Services 877-511110 877-511120 877-511180 877-511210 877-511310 877-511350 877-511410 877-511500 Regular Overtime LTD Longevity FICA - Employer TMRS - Employer Health - Employer Workers Compensation Total Personnel Services Supplies 877-521000 877-521100 877-521200 877-521300 877-521600 Operating Supplies Office Supplies Medical/Chemical Supplies Motor Veh. Supplies Equip Maint Supplies Total Supplies City Support Services 877-532400 Computer Fees & Licenses Total City Support Services Utility Services 877-533500 Vehicle Fuel Total Utility Services Operations Support 877-534200 Printing & Binding Total Operations Support 47,400 53,931 53,889 75,192 623 416 1,000 1,000 140 123 154 212 1,320 1,704 1,968 2,232 3,857 4,043 4,179 5,999 3,627 3,653 3,767 6,633 4,781 5,807 6,700 11,541 - 1,842 1,722 2,837 61,748 71,519 73,379 105,646 2,623 1,891 2,500 2,500 275 279 500 400 1,630 1,276 2,100 1,500 40,750 55,427 50,250- 55,000 885 31 1,100 1,100 46,163 58,904 56,450 60,500 650 450 650 450 558 1,572 1,000 1,500 558 1,572 1,000 1,500 25 34 300 300 25 34 3OO 30O 68 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Staff Support 877-535100 Uniforms 877-535200 Annual Awards 877-535500 Training/Travel Total Staff Support Maintenance Services 877-551100 Building Maintenance 877-551300 Computer Maintenance 877-551400 Minor & Other Equip Maint 877-551800 Other Maint Agreement Total Maintenance Services Rental-Lease 877-561100 Rental Equipment 877-561200 Lease/Purchase Payments Total Rental-Lease Capital Outlay 877-581700 Other Improvements Total Capital Outlay 1,101 902 1,000 1,500 100 100 675 552 1,750 1,101 1,577 1,652 3,350 - - 75O 500 - - 500 6,434 387 4,000 4,000 4,056 23,354 11,800 12,500 10,490 23,741 17,050 17,000 - 200 200 251 78 84 251 278 284 2,000 2,000 69 CITY OF SCHERTZ COMMENTARY DEPARTMENT: PATIENT ASSISTANCE FUNCTION: The Patient Assistance program is an Interlocal Agreement between the City of Schertz and Guadalupe Valley Hospital. The Hospital agrees to provide prescription medication free of charge or at a Iow cost to citizens of Schertz who qualify for assistance under established guidelines. The Hospital agrees to maintain a part-time intake and information office in Schertz. Prescriptions will be filled and other wise administered at the Hospital's Seguin facility. The City agrees to pay the hospital an agreed upon amount on final execution of this Agreement. The Hospital agrees to provide written reports to the City and to provide the City with the complete budget for the Hospital's drug program. 7O CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 101 GENERAL FUND 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED EXPENDITURES CITIZENS ASSISTANCE City Assistance 901-537300 Patient Assistance 6,463 11,000 11,000 5,000 901-537400 Students of Christ 1,100 901-537500 Misc Assistance - - 4,900 Total City Assistance 6,463 11,000 11,000 11,000 71 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY INTEREST & SINKING FUND FUNCTION: This fund is used to account for the accumulation of resources for, and the payment of, general long-term debt principal and interest. The I&S portion of the property taxes are directly deposited by the County Assessor's Office into this fund. 72 TOTAL DEBT SERVICE 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 73 CITY OFSCHERTZ OPERATING BUDGET FOR YEaR 2004'2005 2001-2002 2002-2003 2003-2004 CITY COUNCIL 505 TAX I & S ACTUAL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY Revenue Summary Taxes 578,106 762,854 971,501 1,156,206 Fund Transfers - - - 236,200 Miscellaneous 7,569 4,030 69,550 91,800 Expenditure Summary Maintenance Service Professional Service 762,240 738,225 1,171,672 1,479,206 3,713 3,000 3,000 5,000 74 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 505 - TAX I & S 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED REVENUES Taxes 000-411900 Property Tax Revenue 000-411950 Public Improvement Dist-922 Total Taxes Fund Transfers 000-486000 Transfer From Other Funds Total Fund Transfers 578,106 762,854 971,501 1,121,206 - 35,000 578,106 762,854 971,501 1,156,206 Miscellaneous 000-491000 Interest Earned 000-491000 Investment Income 7,569 000-498100 Reimbursement-EMS SR2003 Pymt 000-499000 Transfer from Reserve Total Miscellaneous 7,569 233,000 233,000 275 300 300 3,755 3,500 3,500 - 65,750 65,750 - 25,450 4,030 69,550 95,000 75 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 505 - TAX I & S 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES Maintenance Service 101-551610 Debt Service Total Maintenance Service Professional Services 101-541500 Paying Agent Total Professional Services 762,240 738,225 1,171,672 1,479,206 762,240 738,225 1,171,672 1,479,206 3,713 3,000 3,000 5,000 3,713 3,000 3,000 5,000 76 Water & Sewer Revenues Sale of Water $ 4,300,000 Garbage Collection $ 1,700,000 Sewer Charges $ 1,846,882 Other Fees & Charges $ 343,560 Misc Income $ 140,250 TOTAL $ 8,330,692 77 Water & Sewer Fund - Revenue Other Fees & Charges Misc Income 4% 2% Sewer Charges 22% Sale of Water 52% Gargage Collection 20% 78 Water & Sewer Expenditures Personnel $ 977,253 Supplies Prof & City Svc Utility & Maint. Svc Opr Support & Asst Equip. & Leasing Debt Service 75,500 247,337 4,004,761 696,945 ;2,700 ;2,266,308 TOTAL $ 8,270,804 79 Water & Sewer Expenditures Equip & Leasing 0% Debt Service Personnel 27% 12% Supplies 1% Opr Support & Asst 8% Prof & City Svc 3% Utility & Maint. Svc 49% 80 202-WATER & SEWER CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY REVENUE SUMMARY Fees Fund Transfers Miscellaneous 5,203,588 6,852,535 7,752,282 8,153,722 - 33,000 36,720 172,667 163,205 124,800 140,250 EXPENDITURE SUMMARY GENERAL GOVERNMENT BUSINESS OFFICE TOTAL GENERAL GOVERNMENT PUBLIC WORKS W & S ADMINISTRATION TOTAL PUBLIC WORKS 236,524 328,423 363,819 291,015 236,524 328,423 363,819 291,015 4,130,054 5,220,978 7,492,090 7,979,789 4,130,054 5,220,978 7,492,090 7,979,789 81 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 202-WATER & SEWER 2001-2002 Actual 2002-2003 Actual 2003-2004 Budget CITY COUNCIL APPROVED Fees 000-455200 000-455210 000-455300 000-455500 000-455600 000-455700 000-455800 000-457100 000-457110 000-457200 000-457300 000-457400 000-457500 000-459100 000-459200 Total Fees Garbage Collection Fee 1,293,470 Drainage Fee - Reconnection Fee 6,803 Water & Sewer Transfer Fee - Fire Line Fees - Recycle Fee Revenue - W&S Line Constructn Reimburse 18,075 Sale of Water 2,610,325 Edwards Water Lease - Sale of Meters 13,942 Service Charges 25 Sewer Charges 1,163,764 Water Penalties 97,184 Credit Card Fee - NSF Check Fee-Water&Swr - Fund Transfers 000-486204 Interfnd Chrg-Drainage Billing Total Fund Transfers 000-491000 000-491200 000-496000 000-497000 000-498100 000-498200 Miscellaneous 000-490000 Misc Charges Interest Eamed Investment Income Water Construction Reserve Miscellaneous Income W&$ Reimbumement-EMS Loan W&S Project Reimbursement Total Miscellaneous 5,203,588 6,399 5,527 155,364 5,377 172,667 1,543,775 67,378 525 111,453 46,723 3,641,105 19,625 28,514 1,300,611 91,459 32 1,335 6,852,535 22,637 3,740 67,559 61,199 8,070 163,205 1,650,307 7,200 1,000 105,000 25,750 4,389,710 85,000 23,000 3,990 1,380,382 80,943 7,752,282 33,000 33,000 20,800 5,000 80,000 7,O00 32,250 12,000 157,050 1,700,000 10,000 115,500 31,000 4,300,000 25,000 23,000 1,846,882 100,040 300 2,000 8,153,722 36,720 36,720 20,000 1,000 10,000 65,000 7,000 32,250 5,000 140,250 82 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: WATER/WASTEWATER FUNCTION: The Water/Wastewater Department is responsible for providing the City of Schertz customers safe, potable ddnking water to include adequate fire protection as well as maintain a safe sanitary sewer collection system. It is also bound by state and federal law, local ordinance, and the city charter to keep the public water and wastewater systems maintained in a satisfactory condition. The Department plans, designs and coordinates all future water/wastewater mains and services, sewer lift stations, water production facilities, and storage plants. Produces and maintains reports to document activities as required by the State Health Department, Texas Commission on Environmental Quality and the City of Schertz. 83 202-WATER & SEWER PUBLIC WORKS W & S ADMINISTRATION 2001-2002 ACTUAL 2002-2003 ACTUAL 2003-2004 BUDGET CITY COUNCIL APPROVED Personnel Services 575-511110 575-511120 575-511180 575-511210 575-511230 575-511310 575-511350 575-511410 575-511500 Regular Overtime LTD Longevity Certification Allowance FICA- Employer TMRS - Employer Health - Employer Workers Compensation Total Personnel Services Supplies 575-521000 575-521100 575-521200 575-521400 575-521600 Operating Supplies Office Supplies Medical Supplies Plumbing Supplies Equip Maint Supplies Total Supplies 575-532410 575-532500 575-532700 575-532900 City Support Services 575-532400 Computer Fees & Licenses Computer Consulting City Insurance- / Comm Records Management Service Contingencies Total City Support Services Utility Services 575-533200 575-533300 575-533400 575-533410 575-533500 Electricity Telephone Water Purchase Water Utility Service Vehicle Fuel Total Utility Services Operations Support 575-534000 Postage 575-534100 Advertising 575-534200 Printing & Binding 575-534300 Copy Services Total Operations Support 577,964 8,474 1,579 21,924 2,631 45,274 43,227 54,719 17,281 773,073 8,855 7,124 7,434 51,245 3,659 78,317 11,891 12 11,903 127,808 10,564 192,559 953 11,082 342,966 7,220 494 2,333 977 11,024 591,502 10,332 1,361 2O,544 2,850 46,378 42,763 72,791 22,836 811,357 7,078 4,863 6,225 58,O37 858 77,061 33,635 2,000 17,218 96 52,949 128,354 9,461 846,377 593 20,763 1,005,548 9,525 357 1,369 11,251 506 526 10 000 I 444 15 528 2 700 39 313 35 435 63 653 14 800 689,399 9,500 6,000 5,000 50,000 500 71,000 15,000 7,000 20,000 2,000 69,000 113,000 139,000 12,769 1,009,275 1,700 25,000 1,187,744 6,500 1,740 2,000 945 11,185 554,640 10,000 1,572 17,640 2,700 44,544 49,249 76,939 19,214 776,498 9,500 6,000 5,000 50,000 500 71,000 28,327 7,000 20,000 2,000 69,000 126,327 110,000 10,000 1,003,918 1,700 25,000 1,150,618 1,740 2,000 945 4,685 84 202-WATER & SEWER PUBLIC WORKS W & S ADMINISTRATION 2001'2002 ACTUAL 2002-2003 ACTUAL 2003-2004 BUDGET CITY COUNCIL APPROVED Staff Support 575-535000 575-535100 575-535200 575-535300 575-535400 575-535500 Rental-Building & Land Uniforms Annual Awards Membemhips Publications Training/Travel Total Staff Support City Assistance 575-537100 Medical Services Total City Assistance Professional Services 575-541100 Engineering Services 575-541200 Legal Services 575-541300 Other Consul/Prof Service 575-541400 Auditor/Accounting Service Total Professional Services Fund Charges 575-548600 Inter Fund Charges-Admin Total Fund Charges Maintenance 575-551100 575-551300 575-551400 575-551500 575-551510 575-551520 575-551600 575-551610 575-551720 575-551740 575-551800 Services Building Maintenance Computer Maintenance Minor & Other Equip Maint Water & Sewer Maintenance Payable to Wast Contractor Sewer Treatment - CCMAJMUD Street Maintenance Materials Debt Service Low Flow Rebate Program Rebate UB Customer Other Maintenance Total Maintenance Services 1,669 8,460 317 3,244 292 5,261 19,243 166 166 14,007 39,964 29,158 5,350 88,479 553,729 553,729 7,497 4,039 5,355 21,344 1,264,509 937,598 3,773 3,100 2,247,215 1,782 11,024 3,023 333 7,247 23,409 501 501 101,624 27,961 20,788 8,069 158,442 548,834 548,834 741 6,520 2,459 17,615 1,380,472 860,002 4,275 251,458 2,750 450 2,526,742 16,000 10,000 450 3,021 400 6,000 35,871 3,000 3,000 48,000 20,000 24,564 12,000 104,564 548,834 548,834 4,250 10,000 2,400 25,000 1,402,761 1,000,000 5,500 2,265,382 3,000 3,000 4,500 4,725,793 2,000 14,000 450 3,025 400 7,622 27,497 3,000 3,000 63,000 20,000 25,000 13,000 121,000 577,013 577,013 4,250 10,000 2,400 25,000 1,552,578 1,243,915 5,500 2,266,308 3,000 3,000 4,500 5,120,451 85 202-WATER & SEWER PUBLIC WORKS W & S ADMINISTRATION 2001-2002 ACTUAL 2002-2003 ACTUAL 2003-2004 BUDGET CITY COUNCIL APPROVED Rental-Lease 575-561100 Rental-Equipment 575-561200 Lease/Purchase Payments Total Rental-Lease 414 3,525 3,939 1,316 3,568 4,884 1,500 200 1,700 1,500 200 1,700 86 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY DEPARTMENT: BUSINESS OFFICE FUNCTION: This department is responsible for maintaining all Water Utility Customer Accounts. Prepares Water Utility Bills for mailing. Collects utility payments and posts these payments to the customer's account. Sets up new water utility accounts, executes water turn offs and transfers. Office personnel provide fdendly and efficient service for all customers and solves complaints in a timely manner. This department also collects vadous payments made to other departments. 87 202-WATER & SEWER GENERAL GOVERNMENT BUSINESS OFFICE 2001-2002 ACTUAL 2002-2003 ACTUAL 2003-2004 BUDGET CITY COUNCIL APPROVED Personnel Services 176-511110 176-511120 176-511180 176-511210 176-511310 176-511350 176-511410 176-511500 Regular Overtime LTD Longevity FICA- Employer TMRS-Employer Health-Employer Workers Compensation Total Personnel Services Supplies 176-521000 Operating Supplies 176-521100 Office Supplies Total Supplies City Su~)Dort Services 176-532500 City Ins.-Commercial Total City Support Services Operations Support 176-534000 Postage 176-534200 Printing & Binding Total Operations Support Staff Support 176-535100 Uniforms 176-535500 Training/Travel Total Staff Support O~3eratina Equipment 176-571000 Furniture & Fixtures Total Operating Equipment 145,640 3,531 286 5,364 11,538 10,937 14,373 191,669 336 3,288 3,624 24,447 13,161 37,608 464 2,076 2,540 1,083 1,083 209,335 2,643 494 9,960 16,540 15,058 25,969 279,999 2,835 3,365 6,200 38,625 2,205 40,830 216 1,178 1,394 208,640 4,000 6O5 11,232 16,455 14,832 26,801 619 283,184 1,000 3,500 4,500 6O 6O 40,000 29,500 69,500 250 4,825 5,075 1,500 1,500 144,084 1,000 411 7,128 11,644 12,874 23,082 532 200,755 1,000 3,500 4,500 10 10 46,500 35,000 81,500 250 3,000 3,250 1,000 1,000 88 Schertz E M S - Revenues Ambulance/Mileage Fees$ 2,650,000 Inter-Jurisdictional Contracts $ 629,328 Misc Income $ 60,000 TOTAL $ 3,339,328 89 Schertz EMS - Revenue Inter-Jurisdictional Contracts 19% Misc. Rev 2% Fees 79% 90 Schertz E M S - Expenditures Personnel $ 1,261,416 Supplies $ 137,500 Prof & City Svc Utility & Maint. Svc $ 99,000 $ 87,560 Opr Support & Asst $ 1,617,800 Equip. & Leasing $ 27,500 Debt Service $ 98,000 TOTAL $ 3,328,776 Schertz EMS - Expenditures Opr Support & Asst 48% Equip & Leasing 1% Debt Service 3% Utility & Maint. Svc 3% Prof & City Services 3% Supplies 4% ~ersonnel 38% 92 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY EMS FUND FUNCTION: The EMS department is a third service municipal EMS agency that provides emergency medical care and transport to the sick and injured throughout Schertz and the Greater Randolph"Metrocom Region. With almost 50 full-time, part-time, and volunteer Paramedics and EMT's we respond to almost 5,000 requests for service annually with 3 full-time paramedic ambulances in our response district. We are the pdmary transport agency for not only Schertz, but also Universal City, Live Oak, Selma, Garden Ridge, Cibolo, Santa Clara, and Marion. Additionally we also provide service for large portions of unincorporated Comal and Guadalupe Counties. This is a service area of almost 220 square miles where over 75,000 people currently reside. 93 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 2001-2002 2002-2003 203 E M S ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED FINANCIAL SUMMARY Revenue Summary Fees 1,624,749 1,452,134 979,200 2,650,000 Inter-Jurisdictional 501,660 561,991 575,314 629,328 Miscellaneous 4,212 66,139 100,000 60,000 Expenditure Summary PUBLIC SAFETY Schertz EMS 1,261,000 2,248,652 1,501,369 3,328,776 94 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 203 E M S 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED REVENUES Fees 00O-4561OO 000-4591OO O00-45920O Total Fees Ambulance/Mileage Transport Credit Card Fee NSF Check Fee Inter-Jurisdictional 000-473500 000-473600 000-474300 000-475100 000-475200 000-475300 000-475400 000-475500 000-475600 000-475700 000-475800 Seguin/Guad Co Support Comal Co Support Cibolo Support Garden Ridge Support Live Oak Support Universal City Support Selma Support Schertz Support Santa Clara Support St. Hedwig Support Marion Support Total Inter-Jurisdictional Miscellaneous 1,480,521 1,452,069 65 979,200 2,650,000 1,480,521 1,452,134 979,200 2,650,000 175,800 17 592 18 210 11 292 54 936 89 094 4 728 112 164 11,250 6,594 181,291 26,500 20,031 12,421 60,430 98,OO3 5,201 141,900 5,867 3,094 7,253 162,550 33.700 27~720 13 794 60,430 99.000 13 200 151.800 5 867 7,253 176990 30,000 35,700 14 630 64 092 105 000 17 500 171 500 6 223 7,693 501,660 561,991 575,314 629,328 000-491000 Interest Eamed 575 1,039 - - 000-491200 Investment- Earnings 85 - - 000-493203 Donations- EMS - 360 - - 000-497000 Misc Income 3,552 47,505 100,000 20,000 000-497500 Misc Income-EMT Classes - 17,235 - 40,000 Total Miscellaneous 4,212 66,139 100,000 60,000 95 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 203 EMS 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES Personnel Services 280-511110 280-511120 280-511180 280-511210 280-511220 280-511230 280-511310 280-511350 280-511410 280-511500 Regular Overtime LTD Longevity Clothing Allowance Certification Allowance FICA- Employer TMRS - Employer Health - Employer Workers Compensation Total Personnel Services 541,098 661,399 751,938 741,030 188,019 167,747 20,000 200,388 1,300 1,802 2,022 1,986 5,736 7,548 8,364 10,824 22,852 17,648 6,240 6,240 33,727 36,301 42,000 42,000 56,734 63,852 60,552 73,001 52,267 53,295 50,936 62,192 49,474 61,467 73,704 84,633 24,937 29,294 27,193 39,122 976,144 1,100,353 1,042,949 1,261,416 Supplies 280-521000 280-521010 280-521100 280-521200 280-521300 280-521600 Operating Supplies Operating Supplies-EMT Class Office Supplies Medical Supplies Motor Veh. Supplies Equip Maint Supplies Total Supplies City Su~3Dort Services 280-532500 City-lns.-Commercial Total City Support Services Utility Services 28O-5331OO 280-533200 280-533300 280-533410 280-533500 Gas Utility Service Electric Utility Service Telephone Water Utility Service Vehicle Fuel Total Utility Services 6,527 6,593 6,500 8,000 8,045 - 15,000 3,469 7,097 4,000 5,500 59,871 120,281 81,000. 105,000 893 1,124 1,500 1,500 445 1,044 2,000 2,500 71,205 144,184 95,000 137,500 15,959 27,263 25,000 27,000 15,959 27,263 25,000 27,000 1,412 1,445 1,550 2,168 9,188 10,406 9,100 12,730 7,759 5,351 6,000 6,994 1,344 2,025 2,310 3,357 10,744 15,962 15,000 15,000 30,447 35,189 33,960 40,249 96 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 203 EMS 2001-2002 ACTUAL 2002-2003 ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED _Operations Support 280-534000 Postage 280-534100 Advertising 280-534200 Printing & Binding Total Operations Support Staff Support 280-535100 280-535200 280-535300 280-535400 280-535500 280-535600 Uniforms Annual Awards Memberships Publications Training/Travel Prof. Certs Total Staff Support City Assistance 280-537100 Medical Services 280-537800 Crime/Fire Prevention Total City. Assistance Professional Services 280-541200 Legal Services 280-541300 Other Consult/Prof Service 280-541400 Auditor/Accounting Serv 280-541500 EMT Class Instructors Total Professional Services Fund Charqes 280-548500 Contractual Allowables 280-548600 Inter-Fund Charge- Admin 280-548700 Bad Debt Expense Total Fund Charges Maintenance Services 280-551100 Building Maintenance 280-551200 Motor Vehicle Fleet 280L551800 Other Maintenance Agreement Total Maintenance Services 549 1,830 ' 2,000 3,000 1,213 1,200 1,200 2,801 958 1,500 1,400 4,563 2,788 4,700 5,600 1,253 2OO 23,945 4,406 988 1,000 281 22,113 15,194 8,760 " 12,000 1,000 1,000 1,800 1,800 400 400 25,000 25,000 11,000 16,000 29,804 39,576 47,960 56,200 - 2,679 8,000 8,000 4,144 7,649 7,000 8,000 4,144 10,328 15,000 16,000 1,699 4,848 2,000 3,000 55,025 51,559 42,000 42,000 1,680 2,388 2,000 2,000 - 2,950 25,000 58,404 61,745 46,000 72,000 18,328 18,328 5,753 9,939 10,596 25,000 25,000 6,271 117 8,692 15,080 26,288 25,000 25,000 5,500 9,200 15,500 30,200 795,000 25,000 720,000 1,540,000 7,500 24,311 15,500 47,311 97 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 203 EMS 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED Debt Service 280-555202 Loan from Water 280-555505 Motor Vechicles-SR 2003 Total Debt Service Rental-Lease 280-561200 Lease/Purchase Payments Total Rental-Lease ODeratin.q Equipment 280-571300 Computer & Peripherals Total Operating Equipment Capitalized Equipment 280-581400 Communications Equipment Total Capitalized Equipment 2,480 32,250 26,000 400 65,750 72,000 2,880 98,000 98,000 7,714 10,342 12,000 10,000 7,714 10,342 12,000 10,000 14,086 20,600 12,500 14,086 20,600 12,500 1,262 5,000 5,000 1,262 5,000 5,000 98 CITY OF SCHERTZ COMMENTARY DRAINAGE FUND FUNCTION: Provide a system for storm water drainage and removal. Insure the municipal roadways are sanitary and without excess debris. Insure water quality by providing safe, potable drinking water. Inspects all new utilities to ensure that all construction meets State, Federal, and Local Ordinances. This Department makes sure that all Flood Management measures are followed to ensure the safety of the Citizens of Schertz. 99 Drainage- Revenue Drainage Fees $ 309,670 Misc Income $ 100 TOTAL 309,770 100 Drainage - Revenue Misc Income O% Drainage Fees 100% 101 Drainage- Expenditures Personnel $ 158,960 Supplies $ 4,200 Prof & City Svc Utility & Maint. Svc Opr Support & Asst Equip. & Leasing TOTAL 19,000 23,000 64,147 20,100 289,407 102 Drainage- Expenditures Opr Support & Asst 22% Capital 7% Personnel 55% Utility & Maint. Svc 8% Prof & City Services 7% Supplies 1% 103 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 204 DRAINAGE 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY Revenue Summary Fees Miscellaneous 276,000 309,670 - 100 Expenditure Summary Personnel Services Supplies Utility Services Staff Support City Assistance Professional Services Fund Charges/Transfers Maintenance Services Rental Lease Capitalized Equipment 151,886 158,960 4,600 4,200 5,000 6,000 2,97O 4,726 - 800 15,500 19,000 36,500 58,621 12,000 17,000 1,500 1,500 - 18,600 104 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 2001-2002 204 DRAINAGE ACTUAL 2002-2003 2003-2004 CITY COUNCIL ACTUAL BUDGET APPROVED REVENUES ,Fees 000-457500 Water Penalties - - 3,000 000-457600 Drainage Fees - - 276,000 306,670 Total Fees Miscellaneous 000-491000 Interest Earned Total Miscellaneous - 276,000 309,670 100 100 105 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 204 DRAINAGE 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES Personnel Services 579-511110 Regular 579-511120 Overtime 579-511180 LTD 579-511210 Longevity 579-511310 FICA- Employer 579-511350 TMRS - Employer 579-511410 Health - Employer 579-511500 Workers Compensation Total Personnel Services Supplies 579-521000 579-521100 579-521200 579-521300 579-521600 Operating Supplies Office Supplies Medical Supplies Motor Yeh. Supplies Equipment Maint. Supplies Total Supplies Utility Services 579-533300 Telephone 579-533500 Vehicle Fuel Total Utility Services Staff Support 579-535100 579-535300 579-535500 579-535600 Uniforms Memberships Training/Travel Professional Certification Total Staff Support City Assistance 579-537100 Medical Services Total City Assistance - 109,500 111,635 - 4,000 2,000 - 316 319 - 3,396 4,656 - 8,601 9,049 - 7,752 10,005 - 13,401 15,388 - 4,920 5,908 - 151,886 158,960 - 1,000 1,000 - 200 100 - 2,500 2,500 - 500 300 - 400 30O - 4,600 4,200 - 1,000 5,000 5,000 5,000 6,000 1,600 3,100 170 60 1,000 1,266 200 300 2,970 4,726 80O 800 106 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 204 DRAINAGE 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Professional Services 579-541100 Engineering Services 579-541400 Auditor/Accounting Service Total Professional Services Fund Char,qes/Transfers 579-548600 Inter-Fund Charge-Admin Total Fund Charges/Transfers Maintenance Services 579-551300 Computer Maintenance 579-551610 Drainage Channel Maintenance Total Maintenance Services Rental-Lease 579-561100 Rental Equipment Total Rental-Lease Capitalized Equipment 579-581800 Other Improvements Total Capitalized Equipment - 15,000 18,000 - 5OO 1,000 - 15,500 19,000 - 36,500 58,621 - 36,500 58,621 - 2,000 2,000 - 10,000 15,000 - 12,000 17,000 1,500 1,500 1,500 1,500 18,600 18,600 107 CITY OF SCHERTZ COMMENTARY CAPITAL RECOVERY FUND FUNCTION: The Capital Recovery program is designed to support future growth of population and commercial water and wastewater demands without an impact on existing customers, while keeping bond supported programs to a minimum. Capital Recovery projects are based on the number of connections sold to increase pumping, storage and transmission water lines, and wastewater programs. In accordance with House Bill 336 impact funds (Capital Recovery) must be used within five years of collection date. All water and wastewater improvements are constructed to meet State Board of Insurance and TCEQ rules and regulations. 108 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 411 - CAPITAL RECOVERY 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED General Government Revenue Summary Fees 512,550 1,032,960 929,223 929,223 Fund Transfers - 341,000 - 508,777 Miscellaneous 47,974 90,000 26,852 130,000 Expenditure Summary Professional Svc 17,429 146,449 26,000 150 Projects- Construction 17,429 146,449 26,000 1,568,000 109 CITY OF SCHERTZ OPERTATING BUDGET FOR YEAR 2004-2005 411 - CAPITAL RECOVERY 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED General Government NON DEPARTMENTAL REVENUES Fees 000-455900 000-455910 Total Fees Capital Recovery-Water Capital Recovery-Waste Water Fund Transfers 000-455910 Transfer from Investment Total Fund Transfers Miscellaneous 000-491000 Interest Earned 000-491200 Investment Income 000-498100 Reimbursement-FM 78 Project Total Miscellaneous 361,553 542,900 565,020 565,020 150,997 490,061 364,203 364~203 512,550 1,032,961 929,223 929,223 341,000 - 508,777 - 341,000 - 508,777 - - 8,984 - 47,974 40,000 5,368 80,000 - 50,000 12,500 50,000 47,974 90,000 26,852 130,000 110 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 411 - CAPITAL RECOVERY 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED General Government NON DEPARTMENTAL EXPENDITURES Professional Services 101-541100 Engineering Services 101-541400 Auditor Service Total Professional Services 17,429 25,000 - 1,000 17,429 26,000 2,209 150 2,209 150 Maintenance Services 944-551900 Construction Total Capital Projects 1,568,000 1,568,000 111 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY S E D CORPORATION FUND FUNCTION: State law allows 1/2 of 1-cent additional tax to be imposed, after voter approval, for economic development activities. By voter referendum in 1997, the tax was increased and the Schertz Economic Development Corporation was established to administer the fund and all activities. A number of proposals for initial use of this sales tax revenue were submitted for voter approval. It was determined that with no history of revenue, city obligation could be issued at a lower rate than the corporation could issue the debt for projects approved by the Board of Directors. An inter-local agreement was made to allow the corporation to reimburse the city for this bonded debt. 112 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 620-SED CORPORATION 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED SUMMARY RECAP Revenue Summary Taxes 716,061 743,641 775,000 850,000 Miscellaneous 18,548 9,137 11,000 6,000 Expenditure Summary General Government Non-Departmental 552,643 539,209 620,519 830,718 Public Information 38,994 93,764 80,973 move to en fd 113 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 620-SED CORPORATION 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES NON DEPARTMENTAL Supplies 101-521000 Operating Supplies 101-521100 Office Supplies 101-521200 Medical/Chemical Supplies Total Supplies Utilities 101-533200 101-533300 101-533410 101-533500 Gas Utility Service Electdcity Utility Service Water Utility Service Fuel Supply (Diesel) Total Utilities Professional Services 101-541400 Auditor/Accounting Service 101-541500 Paying Agent Total Professional Services Fund Charges/Transfers 101-548600 Interfund Charges-Administrative Total Charges/Transfers Maintenance Services 101-551100 Building Maintenance 101-551400 Minor & Other Equip Maint 101-551700 Ground Maintenance 101-551800 Other MaintAgreement Total Maintenance Services Rental-Lease 101-561100 Rental Equipment Total Rental-Lease 2O4 2O4 7OO 700 8O0 8OO - 11,435 100 100 - 2,300 100 13,835 1,000 1,770 2,770 4,319 44,177 7,165 1,089 56,750 800 1,775 2,575 65,000 65,000 9,000 375 6OO 6,399 16,374 2OO 2OO 115 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 620-SED CORPORATION 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT REVENUES Taxes 000-411500 Sales Tax Revenues (4B) Total Taxes Miscellaneous 000-491000 Interest Earned 000-491200 Investment Earnings Total Miscellaneous 716,061 743,641 775,000 850,000 716,061 743,641 775,000 850,000 1,117 1,446 1,000 1,000 17,431 7,691 10,000 5,000 18,548 9,137 11,000 6,000 114 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 620-SED CORPORATION 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED Debt Service 101-555600 GO Bond SR98-Pub Safety Bldgs 101-555700 Tax Note SR01-Fire Engine Total Debt Service .Capital Outlay 101-551603 Police Vehicles Total Charges/Transfers - 387,974 381,189 384,236 - 150,435 161,460 166,748 - 538,409 542,649 550,984 75,000 125,000 75,000 125,000 116 CITY OF SCHERTZ COMMENTARY S E D FOUNDATION FUND FUNCTION: The Foundation was incorporated under the Texas Non-profit Corporation Act to assist the City in developing and implementing plans for economic viability for the City. The Board of Directors is appointed by the City Council and the executive director is employed by the City. 117 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 612 DEV FOUNDATION 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Fund Transfers - 25,000 1,000 Miscellaneous - 1,649 2,000 1,000 Expenditure Summary_ Staff Support - 1,000 1,000 1,000 Professional Services - 1,103 1,000 1,000 IIII __ II'1 '~_ -' I '1' '1' ~' 118 CITY OFSCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 612 DEV FOUNDATION 2001-2002 ACTUAL 2O02-2OO3 ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED REVENUES Fund Transfers 000-481000 Transfer From Reserves Total Fund Transfers 25,000 1,000 25,00O 1,000 Miscellaneous 000-491000 Interest Eamings 000-491200 Investment Eamings Total Miscellaneous 412 500 40 1,237 1,500 960 1,649 2,000 1,000 119 CITY OFSCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 612-DEV FOUNDATION 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED General Government EXPENDITURES NON-DEPARTMENTAL __Staff SuoDort 101-535300 Memberships Prof Organization Total Staff Support Professional Services 101-541400 Auditor/Accounting Service 101-541600 MiscBank Charge Total Professional Services - 1,000 1,000 1,000 - 1,000 1,000 1,000 736 1,103 1,000 1,000 736 1,103 1,000 1,000 120 This Page left Intentionally Blank CITY OF SCHERTZ COMMENTARY SPECIAL EVENT FUND FUNCTION: The Event Fund is designated to monitor and manage funds appropriated to pay for all events sponsored by the City of Schertz. 121 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 106 SPECIAL EVENTS CITY COUNCIL APPROVED REVENUES Miscellaneous 000-458100 Sale of Merchandise Total Miscellaneous Donations 000.-493000 000-493100 000-493200 000-493300 000-493400 000-493500 Misc Donations Donations-Fesival of Angles Donations-Emergency Svc Day Donations-Business Apprec Din Donations-Christmas Activites Blue Santa Total Donations Fund Transfers 000-548600 Transfer From Reserves Total Fund Transfers 1,000 1,000 5,000 2,500 5OO 500 3,000 11,500 24,000 24,000 122 CITY OFSCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 106 SPECIAL EVENTS CITY COUNCIL APPROVED EXPENDITURES 601-532800 602-532800 603-532800 604.-532800 605-532800 606-532800 607-532800 608-532800 609-532800 610-532800 611-532800 612-532800 613-532800 614-532800 615-532800 Festival of Angels Employee Christmas Party Business Appreciation Dinner 4th of July Jubilee Emergency Service Day Fire Prevention Week National Night Out Relay for Life Stdde for Sight Trail Riders to Stock Show & Rodeo Employee Remembrance Day Easter Egg Hunt-Animal Shelter Doggie Dash BVYA Opening Day Blue Santa 5,000 1,000 13,400 6,500 5O 2OO 100 150 150 50 100 123 CITY OF SCHERTZ COMMENTARY HOTEL/MOTEL FUND FUNCTION: Revenues for Hotel/Motel Fund are derived from a seven percent tax on rooms rented at local hotel/motels, State law limits expenditures from this fund to those programs that promote the tourism industry. 124 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 314 HOTEL TAX 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY Revenue Summary Taxes Fund Transfers Miscellaneous 40,410 43,177 35,000 38,000 - - 40,000 100,000 4,566 2~821 3,200 2,420 Expenditure Summary Operations Support Professional Services Fund Charges 34 448 10,000 10,000 500 - 41,000 1,000 2,500 2,500 2,000 119,500 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 314 HOTEL TAX 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED REVENUES Taxes 000-411800 Total Taxes Hotel Occupancy Tax Fund Transfers 000-481000 Transfer From Reserves Total Fund Transfers Miscellaneous 000-491000 Interest Earned 000-491200 Investment Income Total Miscellaneous 40,410 43,177 35,000 38~000 40,410 43,177 35,000 38,000 40,000 100,000 40,000 100,000 669 212 200 2O0 3,897 2,609 3,000 2,220 4,566 2,821 3,200 2,420 126 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 314 HOTEL TAX 2001-2002 2002-2003 Actual Actual 2003-2004 CITY COUNCIL Budget APPROVED GENERAL GOVERNMENT EXPENDITURES O~3erations Support 101-534100 Advertising 101-534200 Printing & Binding Total Operations Support .Professional Services 101-541300 Other Consult/Prof Services 101-541400 Auditor/Accounting Services Total Professional Services .Fund Char,qes 101-548600 Interfund Charges-Admin Total Fund Charges 34 448 5,000 5,000 - 5,0O0 5,000 34 448 10,000 10,000 - - 40,000 - 500 - 1,000 1,000 500 - 41,000 1,000 2,500 2,500 2,000 119,500 2,500 2,500 2,000 119,500 127 CITY OF $CHERTZ COMMENTARY PARK FUND FUNCTION: The Park Fund is a special fund designed to monitor and manage funds for improvements of the City of Schertz Park System. Revenues are dedved from developer fees (in lieu of parkland dedication), grants, and donations. 128 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 2001-2002 317 PARK ACTUAL 2002-2003 2003-2004 CITY COUNCIL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY Revenue Summary Fees 15,538 99,735 70,000 20,000 Miscellaneous 2,897 1,743 500 2,240 Expetrlditure Summary Maintenance Services 660 5,000 3,000 Transfers - 40,000 Capital Outlay - 8,000 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 317 PARK 2001-2002 2002-2003 ACTUAL ACTUAL 2003-2004 CITY COUNCIL BUDGET APPROVED REVENUES Fees 000-458800 000-458900 Total Fees Developers Fees Tree Mitigation 5,378 27,653 20,000 10,000 10,160 72,082 50,000 10,000 15,538 99,735 70,000 20,000 Miscellaneous 000-491000 Intemst Eamed 000-491200 Inve~mentlntemst Total Miscellaneous 285 130 100 240 2,612 1,613 400 2,000 2,897 1,743 500 2,240 130 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 317-PARK 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES Transfer 101-548101 Transfer to Gen Fund - Trees Total Transfers Maintenance Services 101-551710 Landscaping Total Fund Charges Capital Outlay 101-581700 Other Improvements Total Capital Outlay 40,000 40,000 660 5,000 3,000 660 5,000 3,000 8,000 8,000 131 CITY OF SCHERTZ COMMENTARY RECYCLING FUND FUNCTION: The Recycling Fund is designed to monitor and manage revenues received from the sale of recyclable materials. These funds are used to fund the Fall and Spring City wide clean up. 132 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 318 RECYCLING 2001-2002 ACTUAL 2002-2003 2003-2004 CITY COUNCIL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY Revenue Summary Fees 11,354 14,489 18,000 18,000 ,Expenditure Summary Maintenance Services 21,979 15,091 18,000 18,000 133 CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 318 RECYCLING 2001-2002 ACTUAL 2002-2003 2003-2004 CITY COUNCIL ACTUAL BUDGET APPROVED REVENUES Fees 000-458200 Total Fees Sale of Recycle Material 11,354 14,489 18,000 18,000 11,354 14,489 18,000 18,000 134 318 RECYCLING CITY OF SCHERTZ OPERATING BUDGET FOR YEAR 2004-2005 2001-2002 2002-2003 2003-2004 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES Maintenance Services 101-551510 Payable to Waste Contractor Total Maintenance Services 21,979 15,091 18,000. 18,000 21,979 15,091 18,000 18,000 135 CITY OF SCHERTZ WORKING CAPITAL PROJECTS FOR YEAR 2004-2005 SUMMARY OF WORKING CAPITAL PROJECTS ORIGINAL BOND YEAR TO DATE BALANCE BUDGETED 2001 W&S REVENUE BOND 12 MDG PUMP STATION 16" WATER LINE-LIVE OAK 1.5 MG ELEVATED WATER TANK 16" WATER LINE-WEIDERSTEIN RD HOPE LANE PAVING PUBLIC WORKS RENOVATION 1,667,351 1,667,351 290,155 290,155 1,599,740 1,599,740 740,582 740,582 350,000 - 650,000 92~376 350,000 557~624 Complete Complete Complete Complete 350,000 557~624 SR 2003 CITY PROJECTS VEHICLES EMS AMBULANCE EQUIPMENT-EMS FURNITURE & FIXTURES-LIBRARY EQUIPMENT-FIRE SWIMMING POOL FEMA MATCH PID FIRE SUBSTATION 189 150 260 000 28 000 12 392 32 000 250.000 1,000.000 750.000 750,000 152,950 260,000 22,457 13,347 21,173 199,202 731,157 422,704 237,672 36,200 5,543 (955) 10,827 50,798 268,843 327,296 512,328 Complete Complete Complete Complete Complete Complete 268,843 327,296 512,328 136 CITY OF SCHERTZ WORKING CAPITAL PROJECTS FOR YEAR 2004-2005 SUMMARY OF WORKING CAPITAL PROJECTS ORIGINAL BOND YEAR TO DATE BALANCE BUDGETED SR 2004 COMMUNITY PROJECT BOND LAND PURCHASE DRAINAGE PROJECTS - 2004 CO BOND 992,770 620,000 372,770 372,770 945-5551900 Aviation Heights 175,000 175,000 175,000 946-5551900 Borgfeld Rd 850,000 3,900 846,100 846,100 947-5551900 Elbel Improvements 120,000 3,440 116,560 116,560 948-5551900 Upper West Dietz Creek 565,000 346,683 218,317 218,317 949-5551900 Woodland Oaks 325,000 - 325,000 325,000 TOTAL Drainage Projects 2,035,000 354,023 1,680,977 1,680,977 BUILDING RENOVATIONS - 2004 CO BOND 951-5551900 Council Chambers 1,027,606 36,337 991,269 991,269 952-5551900 Community Center 1,788,160 1,788,160 1,788,160 953-5551900 City Hall Remodel 50,000 50,000 50,000 954-5551900 Old EMS Bldg 156,307 - 156,307 156,307 955-5551900 Office Spaces 460,186 - 460,186 460,186 TOTAL Building Projects 3,482,259 36,337 3,445,922 3,445,922 Ball Field - 2004 CO BOND 957-5551900 Construction 1,130,071 1,130,071 1,130,071 137 This Page left Intentionally Blank As of I Oct 2004 City Council Municipal City Secretary Court Judge Asst. City I City Manager ~ Exec Svcs Public Works Dept EMS Dept Community Services Fire De~t Municipal Court Opers Police De~t Animal Control Econ Der Info Tech Bus Office H/R Finance Del~t Mgr. tGeneral Svcs }~ Purchasing Community Development Inspection /Code Enf Planning PlO 138 As of 1 Oct, 2004 FY 2004-2005 POSITION AUTHORIZATION POSITION TITLE City Manager Asst City Manager Executive Services Executive Assistant SERVICE GRADE MANAGEMENT (51) Council discretion 44 24 21 AUTH MUNICIPAL COURT (52) Municipal Court Judge/Adstr Court Clerk Deputy Court Clerk Warrant Officer/Baliff Council Discretion 15 12 23 INFORMATION TECHNOLOGY (53) Information Technology Coordinator 35 Asst Information Technology Coordinator 30 COMMUNITY AND ECONOMIC DEVELOPMENT (54) 1 1 3 1 Director 40 1 Planner 20 2 Administrative Assistant 15 1 POLICE DEPARTMENT (56) 42 34 30 26 23 20 15 10 15 23 13 Chief Captain Lieutenant Sergeant Corporal Patrolmen Office Manager Records Clerk Secretary Dispatcher Supervisor Dispatcher 1 1 1 5 4 25 1 1 1 1 10 139 POSITION TITLE SERVICE GRADE AUTH POLICE DEPARTMENT (56) (Continued} Crossing Guards (P/T) N/A FIRE DEPARTMENT (57) Chief Assistant Chief/Fire Marshal Captain Training Officer Lieutenant Inspector Firefighter Clerk 41 34 29 25 25 21 19 10 INSPECTION DEPARTMENT (58) Building Official Inspector Asst Inspector Code Enforcement Officer Secretary Inspections Clerk 30 21 15 15 12 10 STREET DEPARTMENT (59) Supervisor Foreman Street Worker II Street Sweeper Operator Street Worker I Street Worker I / Part Time 30 15 12 12 10 10 COMMUNITY SERVICES (60) Director Administrative Assistant Park Foreman Park Worker I Pool Manager - P.T. Assistant Pool Manager/WSI P.T. Lifeguards - P.T. 40 19 18 10 8 8 7 5 1 1 3 1 6 1 17 1 1 1 2 1 7 2 1 1 2 3 1 5 25 140 POSITION TITLE SERVICE GRADE AUTH FACILITY MAINTENANCE (61) Facility Maintenance Supervisor Assistant Facility Manager Facility Worker Custodian I 25 18 13 10 ANIMAL SHELTER MANAGEMENT (62) Supervisor Animal Control Officer Shelter Operator 24 14 10 PUBLIC INFORMATION (63) Public Information Officer 25 CITY SECRETARY (64) City Secretary Council Discretion Deputy City Secretary 24 Records Manager 28 Records Manager Clerk Part Time 13 LIBRARY (65) 1 1 1 3 1 2 2 Library Manager 28 1 Children's Librarian 22 1 Clerk 10 4 Clerk - P.T. 10 5 HUMAN RESOURCES (66) FINANCE (68) Human Resources Director Human Resources Clerk 26 12 Finance Director Accounts Supervisor Finance Clerk 40 28 10 1 1 3 141 POSITION TITLE SERVICE GRADE AUTH PUBLIC WORKS DEPARTMENT (75) Director Asst. Director Administrative Assistant PW Inspector Records and Purchasing PW Clerk/Dispatcher 40 35 20 21 12 10 WATER/WASTEWATER DEPARTMENT (75) Supervisor Foreman Serviceman II Serviceman I Meter Tech II Meter Tech I 30 16 12 10 13 11 BUSINESS OFFICE (76) Utility Billing Supervisor Collections Clerk II Solid Waste Coordinator Collections Clerk I Collections Clerk Receptionist 20 12 12 11 10 10 FLEET SERVICES (77) 1 1 3 6 1 2 Mechanic / Foreman 17 1 Mechanic 15 1 Mechanic 10 1 DRAINAGE AND RIGHT OF WAY MAINTENANCE (79) 30 15 10 Environmental/QC Supervisor Foreman Worker 1 1 1 2 142 POSITION TITLE SERVICE GRADE AUTH EMS DEPARTMENT (80) (Please see the note at the end of the Pay Tables) Director EMS Training Manager EMS Billing Supervisor Captain EMT Attendant Administrative Specialist P/T EMT Attendant 40 1 30 1 26 1 26 4 19 14 15 1 Depending on Cert 20 Summary: Total Full Time Employees: 206; Total Part Time Employees: 64 143 This Page left Intentionally Blank FY 2004/2005 Pay Tables Effective I October 2004 SG 5 Hour BiWeek Month Annual Step1 Step2 Step3 Step4 Step5 Step6 Step7 Step8 Step9 Step10 Step11 Step12 Step13 Step14 Step15 7.28 7.42 7.57 7.72 7.88 8.04 8.20 8.36 8.53 8.70 8.87 9.05 9.23 9.41 9.60 582.23 593.88 605.75 617.87 630.23 642.83 655.69 668.80 682.18 695.82 709.74 723.93 738,41 753.18 768.24 1261,50 1286.73 1312.46 1338.71 1365.49 1392.80 1420.65 1449.07 1478.05 1507.61 1537.76 1568.52 1599.89 1631,88 1664.52 15138 15441 15750 16065 16386 16714 17048 17389 17737 18091 18453 18822 19199 19583 19974 SG 6 Hour 7.57 7.72 7.87 8.03 8.19 8.36 8.52 8.69 8.87 9.05 9.23 9.41 9.60 9.79 9.99 BiWeek 605.52 617.63 629.98 642.58 655.43 668.54 681.91 695.55 709.46 723.65 738.13 752.89 767.95 783.30 798.97 Month 1311.96 1338.20 1364.96 1392.26 1420.11 1448.51 1477.48 1507.03 1537.17 1567.91 1599.27 1631.26 1663.88 1697.16 1731.10 Annual 15744 16058 16380 16707 17041 17382 17730 18084 18446 18815 19191 19575 19967 20366 20773 SG 7 Hour 7.87 8.03 8.19 8.35 8.52 8.69 8.86 9.04 9.22 9.41 9.60 9.79 9.98 10.18 10.39 BiWeek 629.74 642.34 655.18 668.29 681.65 695.28 709.19 723.37 737.84 752.60 767.65 783.00 798.66 814.64 830.93 Month 1364.44 1391.73 1419.56 1447.95 1476.91 1506.45 1536.58 1567.31 1598.66 1630,63 1663.24 1696.51 1730.44 1765.05 1800.35 Annual 16373 16701 17035 17375 17723 18077 18439 18808 19184 19568 19959 20358 20765 21181 21604 SG 8 Hour 8.19 8.35 8.52 8.69 8.86 9.04 9.22 9.40 9.59 9.78 9.98 10.18 10.38 10.59 10.80 BiWeek 654.93 668.03 681.39 695.02 708.92 723.10 737.56 752.31 767.36 782.70 798.36 814.32 830.61 847.22 864.17 Month 1419.02 1447.40 1476.34 1505.87 1535.99 1566.71 1598.04 1630.00 1662.60 1695.86 1729.77 1764.37 1799.66 1835.65 1872.36 Annual 17028 17369 17716 18070 18432 18800 19177 19560 19951 20350 20757 21172 21596 22028 22468 SG 9 Hour 8.51 8.68 8.86 9.04 9.22 9.40 9.59 9.78 9.98 10.18 10.38 10.59 10.80 11.01 11.23 BiWeek 681.13 694.75 708.65 722.82 737.27 752.02 767.06 782.40 798.05 814.01 830.29 846.90 863.83 881.11 898.73 Month 1475.78 1505.29 1535.40 1566.11 1597.43 1629.38 1661.96 1695.20 1729.11 1763.69 1798.96 1834.94 1871.64 1909.07 1947.26 Annual 17709 18064 18425 18793 19169 19553 19944 20342 20749 21164 21588 22019 22460 22909 23367 SG 10 Hour BiWeek Month Annual 8.85 9.03 9.21 9.40 9.58 9.78 9.97 10.17 10.37 10.58 10.79 11.01 11.23 11.45 11.68 708.37 722.54 736.99 751.73 766.77 782.10 797.74 813.70 829.97 846.57 863.50 880.77 898,39 916.36 934.68 1534.81 1565.50 1596.81 1628.75 1661,33 1694,55 1728.44 1763.01 1798.27 1834.24 1870.92 1908,34 1946,51 1985,44 2025.15 18418 18786 19162 19545 19936 20335 20741 21156 21579 22011 22451 22900 23358 23825 24302 144 FY 2004/2005 Pay Tables Effective I October 2004 SG 11 Hour BiWeek Month Annual Step1 Step2 Step3 Step4 Step5 Step6 Step7 Step8 Step9 SteplO Step11 Step12 Step13 Step14 Step15 9.21 9.39 9.58 9.77 9.97 10.17 10.37 10.58 10.79 11.01 11.23 11.45 11.68 11.91 12.15 736.71 751.44 766.47 781.80 797.44 813.38 829.65 846.25 863.17 880.43 898.04 916.00 934.32 953.01 972.07 1596.20 1628.12 1660.69 1693.90 1727.78 1762.33 1797.58 1833.53 1870.20 1907.61 1945.76 1984.67 2024.37 2064.85 2106.15 19154 19537 19928 20327 20733 21148 21571 22002 22442 22891 23349 23816 24292 24778 25274 SG 12 Hour BiWeek Month Annual 9.58 9.77 9.96 10.16 10.37 10.57 10.79 11.00 11.22 11.45 11.67 11.91 12.15 12.39 12.64 766.18 781.50 797.13 813.07 829.33 845.92 862.84 880.10 897.70 915.65 933.96 952.64 971.70 991.13 1010.95 1660.05 1693.25 1727.11 1761.66 1796.89 1832.83 1869.48 1906.87 1945.01 1983.91 2023.59 2064.06 2105.34 2147.45 2190.40 19921 20319 20725 21140 21563 21994 22434 22882 23340 23807 24283 24769 25264 25769 26285 SG 13 Hour 9.96 10.16 10.36 10.57 10.78 11.00 11.22 11.44 11.67 11.90 12.14 12.38 12.63 12.88 13.14 BiWeek 796.82 812.76 829.01 845.59 862.51 879.76 897.35 915.30 933.61 952.28 971.32 990.75 1010.56 1030.78 1051.39 Month 1726.45 1760.98 1796.20 1832.12 1868.76 1906.14 1944.26 1983.15 2022.81 2063.27 2104.53 2146.62 2189.56 2233.35 2278.01 Annual 20717 21132 21554 21985 22425 22874 23331 23798 24274 24759 25254 25759 26275 26800 27336 SG 14 Hour 10.36 10.57 10.78 10.99 11.21 11.44 11.67 11.90 12.14 12.38 12.63 12.88 13.14 13.40 13.67 BiWeek 828.70 845.27 862.18 879.42 897.01 914.95 933.25 951.91 970.95 990.37 1010.18 1030.38 1050.99 1072.01 1093.45 Month 1795.51 1831.42 1868.05 1905.41 1943.52 1982.39 2022.03 2062.47 2103.72 2145.80 2188.71 2232.49 2277.14 2322.68 2369.13 Annual 21546 21977 22417 22865 23322 23789 24264 24750 25245 25750 26265 26790 27326 27872 28430 SG 15 Hour 10.77 10.99 11.21 11.43 11.66 11.89 12.13 12.37 12.62 12.87 13.13 13.39 13.66 13.94 14.21 BiWeek 861.84 879.08 896.66 914.60 932.89 951.55 970.58 989.99 1009.79 1029.98 1050.58 1071.59 1093.03 1114.89 1137.18 Month 1867.33 1904.67 1942.77 1981.62 2021.26 2061.68 2102.91 2144.97 2187.87 2231.63 2276.26 2321.79 2368.22 2415.59 2463.90 Annual 22408 22856 23313 23779 24255 24740 25235 25740 26254 26780 27315 27861 28419 28987 29567 SG 16 Hour BiWeek Month Annual 11.20 11.43 11.66 11.89 12.13 12.37 12.62 12.87 13.13 13.39 13.66 13.93 14.21 14.49 14.78 896.32 914.24 932.53 951.18 970.20 989.61 1009.40 1029.59 1050.18 1071.18 1092.61 1114.46 1136.75 1159.48 1182.67 1942.02 1980.86 2020.48 2060.89 2102.11 2144.15 2187.03 2230.77 2275.39 2320.90 2367.31 2414.66 2462.95 2512.21 2562.46 23304 23770 24246 24731 25225 25730 26244 26769 27305 27851 28408 28976 29555 30147 30749 145 FY 2004/2005 Pay Tables Effective 1 October 2004 SG 17 Hour BiWeek Month Annual Step1 Step2 Step3 Step4 Step5 Step6 Step7 Step8 Step9 Step10 Step11 Step12 Step13 Step14 Step15 11.65 11.89 12.12 12.37 12.61 12.86 13.12 13.38 13.65 13.93 14.20 14.49 14.78 15.07 15.37 932.17 950.81 969.83 989.23 1009.01 1029.19 1049.78 1070.77 1092.19 1114.03 1136.31 1159.04 1182.22 1205.86 1229.98 2019.70 2060.10 2101.30 2143.32 2186.19 2229.91 2274.51 2320.00 2366.40 2413.73 2462.01 2511.25 2561.47 2612.70 2664.95 24236 24721 25216 25720 26234 26759 27294 27840 28397 28965 29544 30135 30738 31352 31979 SG 18 Hour BiWeek Month Annual 12.12 12.36 12.61 12.86 13.12 13.38 13.65 13.92 14.20 14.48 14.77 15.07 15.37 15.68 15.99 969.46 988.85 1008.62 1028.80 1049.37 1070.36 1091.77 1113.60 1135.87 1158.59 1181.76 1205.40 1229.51 1254.10 1279.18 2100.49 2142.50 2185.35 2229.06 2273.64 2319.11 2365.49 2412.80 2461.06 2510.28 2560.49 2611.70 2663.93 2717.21 2771.55 25206 25710 26224 26749 27284 27829 28386 28954 29533 30123 30726 31340 31967 32606 33259 SG 19 Hour 12.60 12.86 13.11 13.37 13.64 13.91 14.19 14.48 14.77 15.06 15.36 15.67 15.98 16.30 16.63 BiWeek 1008.24 1028.40 1048.97 1069.95 1091.35 1113.17 1135.44 1158.15 1181.31 1204.93 1229.03 1253.61 1278.69 1304.26 1330.35 Month 2184.51 2228.20 2272.76 2318.22 2364.58 2411.88 2460.11 2509.32 2559.50 2610.69 2662.91 2716.16 2770.49 2825.90 2882.41 Annual 26214 26738 27273 27819 28375 28943 29521 30112 30714 31328 31955 32594 33246 33911 34589 SG 20 Hour 13.11 13.37 13.64 13.91 14.19 14.47 14.76 15.06 15.36 15.66 15.98 16.30 16.62 16.96 17.29 BiWeek 1048.56 1069.54 1090.93 1112.75 1135.00 1157.70 1180.85 1204.47 1228.56 1253.13 1278.19 1303.76 1329.83 1356.43 1383.56 Month 2271.89 2317.33 2363.67 2410.95 2459.17 2508.35 2558.52 2609.69 2661.88 2715.12 2769.42 2824.81 2881.31 2938.93 2997.71 Annual 27263 27808 28364 28931 29510 30100 30702 31316 31943 32581 33233 33898 34576 35267 35973 SG 21 Hour 13.63 13.90 14.18 14.47 14.76 15.05 15.35 15.66 15.97 16.29 16.62 16.95 17.29 17.63 17.99 BiWeek 1090.51 1112.32 1134.56 1157.26 1180.40 1204.01 1228.09 1252.65 1277.70 1303.26 1329.32 1355.91 1383.03 1410.69 1438.90 Month 2362.77 2410.02 2458.22 2507.39 2557.53 2608.68 2660.86 2714.08 2768.36 2823.72 2880.20 2937.80 2996.56 3056.49 3117.62 Annual 28353 28920 29499 30089 30690 31304 31930 32569 33220 33885 34562 35254 35959 36678 37411 SG 22 Hour 14.18 14.46 14.75 15.04 15.35 15.65 15.97 16.28 16.61 16.94 17.28 17.63 17.98 18.34 18.71 BiWeek 1134.13 1156.81 1179.95 1203.55 1227.62 1252.17 1277.21 1302.76 1328.81 1355.39 1382.50 1410.15 1438.35 1467.11 1496.46 Month 2457.28 2506.42 2556.55 2607.68 2659.84 2713.03 2767.29 2822.64 2879.09 2936.67 2995.41 3055.31 3116.42 3178.75 3242.32 Annual 29487 30077 30679 31292 31918 32556 33208 33872 34549 35240 35945 36664 37397 38145 38908 146 FY 2004/2005 Pay Tables Effective 1 October 2004 Step1 Step2 Step3 Step4 Step5 Step6 Step7 Step8 Step9 Step10 Step11 Step12 Step13 Step14 Step15 SG 23 Hour 14.74 15.04 15.34 15.65 15.96 16.28 16.60 16.94 17.27 17.62 17.97 18.33 18.70 19.07 19.45 BiWeek 1179.49 1203.08 1227.14 1251.69 1276.72 1302.26 1328.30 1354.87 1381.96 1409.60 1437.80 1466.55 1495.88 1525.80 1556.32 Month 2555.57 2606.68 2658.81 2711.99 2766.23 2821.55 2877.98 2935.54 2994.25 3054.14 3115.22 3177.53 3241.08 3305.90 3372.02 Annual 30667 31280 31906 32544 33195 33859 34536 35227 35931 36650 37383 38130 38893 39671 40464 SG 24 Hour 15.33 15.64 15.95 16.27 16.60 16.93 17.27 17.61 17.97 18.32 18.69 19.07 19.45 19.84 20.23 BiWeek 1226.67 1251.21 1276.23 1301.75 1327.79 1354.35 1381.43 1409.06 1437.24 1465.99 1495.31 1525.21 1555.72 1586.83 1618.57 Month 2657.79 2710.95 2765.16 2820.47 2876.88 2934.42 2993.10 3052.97 3114.02 3176.31 3239.83 3304.63 3370.72 3438.14 3506.90 Annual 31893 32531 33182 33846 34523 35213 35917 36636 37368 38116 38878 39656 40449 41258 42083 SG 25 Hour 15.95 16.27 16.59 16.92 17.26 17.61 17.96 18.32 18.68 19.06 19.44 19.83 20.22 20.63 21.04 BiWeek 1275.74 1301.25 1327.28 1353.82 1380.90 1408.52 1436.69 1465.42 1494.73 1524.63 1555.12 1586.22 1617.95 1650.30 1683.31 Month 2764.10 2819.38 2875.77 2933.29 2991.95 3051.79 3112.83 3175.08 3238.59 3303.36 3369.42 3436.81 3505.55 3575.663647.17 Annual 33169 33833 34509 35199 35903 36622 37354 38101 38863 39640 40433 41242 42067 42908-~ 43766 SG 26 Hour 16.58 16.92 17.25 17.60 17.95 18.31 18.68 19.05 19.43 19.82 20.22 20.62 21.03 21.45 21.88 BiWeek 1326.77 1353.30 1380.37 1407.98 1436.14 1464.86 1494.16 1524.04 1554.52 1585.61 1617.32 1649.67 1682.66 1716.32 1750.64 Month 2874.67 2932.16 2990.80 3050.62 3111.63 3173.86 3237.34 3302.09 3368.13 3435.49 3504.20 3574.29 3645.77 3718.69 3793.06 Annual 34496 35186 35890 36607 37340 38086 38848 39625 40418 41226 42050 42891 43749 44624 45517 SG 27 Hour 17.25 17.59 17.94 18.30 18.67 19.04 19.42 19.81 20.21 20.61 21.03 21.45 21.87 22.31 22.76 BiWeek 1379.84 1407.44 1435.59 1464.30 1493.58 1523.45 1553.92 1585.00 1616.70 1649.04 1682.02 1715.66 1749.97 1784.97 1820.67 Month 2989.65 3049.45 3110.43 3172.64 3236.10 3300.82 3366.83 3434.17 3502.85 3572.91 3644.37 3717.26 3791.60 3867.43 3944.78 Annual 35876 36593 37325 38072 38833 39610 40402 41210 42034 42875 43732 44607 45499 46409 47337 SG 28 Hour 17.94 18.30 18.66 19.04 19.42 19.80 20.20 20.61 21.02 21.44 21.87 22.30 22.75 23.20 23.67 BiWeek 1435.03 1463.73 1493.01 1522.87 1553.33 1584.39 1616.08 1648.40 1681.37 1715.00 1749.30 1784.28 1819.97 1856.37 1893.50 Month 3109.24 3171.42 3234.85 3299.55 3365.54 3432.85 3501.51 3571.54 3642.97 3715.83 3790.14 3865.95 3943.27 4022.13 4102.57 Annual 37311 38057 38818 39595 40386 41194 42018 42858 43716 44590 45482 46391 47319 48266 49231 147 FY 200412005 Pay Tables Effective I October 2004 Step1 Step2 Step3 Step4 Step5 Step6 Step7 Step8 Step9 Step10 Step11 Step12 Step13 Step14 Step15 SG 29 Hour 18.66 19.03 19.41 19.80 20.19 20.60 21.01 21.43 21.86 22.29 22.74 23.20 23.66 24.13 24.62 BiWeek 1492.43 1522.28 1552.73 1583.78 1615.46 1647.77 1680.72 1714.34 1748.62 1783.60 1819.27 1855.65 1892.77 1930.62 1969.24 Month 3233.61 3298.28 3364.25 3431.53 3500.16 3570.16 3641.57 3714.40 3788.69 3864.46 3941.75 4020.59 4101.00 4183.02 4266.68 Annual 38803 39579 40371 41178 42002 42842 43699 44573 45464 46374 47301 48247 49212 50196 51200 SG 3O Hour 19.40 19.79 20.19 20.59 21.00 21.42 21.85 22.29 22.73 23.19 23.65 24.12 24.61 25.10 25.60 BiWeek 1552.13 1583.17 1614.84 1647.13 1680.08 1713.68 1747.95 1782.91 1818.57 1854.94 1892.04 1929.88 1968.48 2007.85 2048.01 Month 3362.95 3430.21 3498.82 3568.79 3640.17 3712.97 3787.23 3862.98 3940.23 4019.04 4099.42 4181.41 4265.04 4350.34 4437.34 Annual 40355 41163 41986 42826 43682 44556 45447 46356 47283 48228 49193 50177 51180 52204 53248 SG 31 Hour 20.18 20.58 20.99 21.41 21.84 22.28 22.72 23.18 23.64 24.11 24.60 25.09 25.59 26.10 26.62 BiWeek 1614.22 1646.50 1679.43 1713.02 1747.28 1782.23 1817.87 1854.23 1891.31 1929.14 1967.72 2007.08 2047.22 2088.16 2129.93 Month 3497.47 3567.42 3638.77 3711.54 3785.77 3861.49 3938.72 4017.49 4097.84 4179.80 4263.40 4348.67 4435.64 4524.35 4614.84 Annual 41970 42809 43665 44539 45429 46338 47265 48210 49174 50158 51161 52184 53228 54292 55378 SG 32 Hour 20.98 21.40 21.83 22.27 22.71 23.17 23.63 24.10 24.59 25.08 25.58 26.09 26.61 27.15 27.69 BiWeek 1678.79 1712.36 1746.61 1781.54 1817.17 1853.52 1890.59 1928.40 1966.97 2006.30 2046.43 2087.36 2129.11 2171.69 2215.12 Month 3637.37 3710.12 3784.32 3860.01 3937.21 4015.95 4096.27 4178.19 4261.76 4346.99 4433.93 4522.61 4613.06 4705.33 4799.43 Annual 43648 44521 45412 46320 47246 48191 49155 50138 51141 52164 53207 54271 55357 56464 57593 SG 33 Hour 21.82 22.26 22.71 23.16 23.62 24.10 24.58 25.07 25.57 26.08 26.60 27.14 27.68 28.23 28.80 BiWeek 1745.94 1780.86 1816.47 1852.80 1889.86 1927.66 1966.21 2005.53 2045.64 2086.56 2128.29 2170.85 2214.27 2258.56 2303.73 Month 3782.86 3858.52 3935.69 4014.41 4094.69 4176.59 4260.12 4345.32 4432.23 4520.87 4611.29 4703.52 4797.59 4893.54 4991.41 Annual 45394 46302 47228 48173 49136 50119 51121 52144 53187 54250 55335 56442 57571 58722 59897 SG 34 Hour 22.70 23.15 23.61 24.09 24.57 25.06 25.56 26.07 26.59 27.13 27.67 28.22 28.79 29.36 29.95 BiWeek 1815.77 1852.09 1889.13 1926.91 1965.45 2004.76 2044.86 2085.75 2127.47 2170.02 2213.42 2257.69 2302.84 2348.90 2395.88 Month 3934.18 4012.86 4093.12 4174.98 4258.48 4343.65 4430.52 4519.13 4609.52 4701.71 4795.74 4891.66 4989.49 5089.28 5191.07 Annual 47210 48154 49117 50100 51102 52124 53166 54230 55314 56420 57549 58700 59874 61071 62293 148 FY 2004/2005 Pay Tables Effective 1 October 2004 Step1 Step2 Step3 Step4 Step5 Step6 Step7 Step8 Step9 Step10 Step11 Step12 Step13 Step14 Step15 SG 35 Hour 23.61 24.08 24.56 25.05 25.55 26.06 26.58 27,11 27.66 28.21 28.77 29.35 29.94 30.54 31.15 BiWeek 1888.41 1926.17 1964.70 2003.99 2044.07 2084.95 2126.65 2169.18 2212.57 2256.82 2301.96 2348.00 2394.96 2442.85 2491.71 Month 4091.55 4173.38 4256.84 4341.98 4428.82 4517,40 4607.75 4699.90 4793.90 4889.78 4987.57 5087.32 5189.07 5292.85 5398.71 Annual 49099 50081 51082 52104 53146 54209 55293 56399 57527 58677 59851 61048 62269 63514 64784 SG 36 Hour 24.55 25.04 25.54 26.05 26.57 27.10 27.65 28.20 28.76 29.34 29.93 30.52 31.13 31.76 32.39 BiWeek 1963.94 2003.22 2043.29 2084.15 2125.83 2168.35 2211.72 2255.95 2301.07 2347.09 2394.03 2441.92 2490.75 2540.57 2591.38 Month 4255.21 4340.31 4427.12 4515.66 4605.97 4698.09 4792.06 4887.90 4985.65 5085.37 5187.07 5290.82 5396.63 5504.57 5614.66 Annual 51062 52084 53125 54188 55272 56377 57505 58655 59828 61024 62245 63490 64760 66055 67376 SG 37 Hour 25.53 26.04 26.56 27.09 27.64 28.19 28.75 29.33 29.91 30.51 31.12 31.74 32.38 33.03 33.69 BiWeek 2042.50 2083.35 2125.02 2167.52 2210.87 2255.08 2300.19 2346.19 2393.11 2440.98 2489.80 2539.59 2590.38 2642.19 2695.04 Month 4425.42 4513.92 4604.20 4696.29 4790.21 4886.02 4983.74 5083.41 5185.08 5288.78 5394.56 5502.45 5612.50 5724.75.5839.24 Annual 53105 54167 55250 56355 57483 58632 59805 61001 62221 63465 64735 66029 67350 68697 . 70071 SG 38 Hour 26.55 27.08 27.63 28.18 28.74 29.32 29.90 30.50 31.11 31.73 32.37 33.01 33.67 34.35 35.04 BiWeek 2124.20 2166.68 2210.02 2254.22 2299.30 2345.29 2392.19 2440.04 2488.84 2538.62 2589.39 2641.18 2694.00 2747.88 2802.84 Month 4602.43 4694.48 4788.37 4884.14 4981.82 5081.46 5183.09 5286.75 5392.48 5500.33 5610.34 5722.55 5837.00 5953.74 6072.81 Annual 55229 56334 57460 58610 59782 60977 62197 63441 64710 66004 67324 68671 70044 71445 72874 SG 39 Hour 27.61 28.17 28.73 29.30 29.89 30.49 31.10 31.72 32.35 33.00 33.66 34.34 35.02 35.72 36.44 BiWeek 2209.17 2253.35 2298.42 2344.39 2391.27 2439.10 2487.88 2537.64 2588.39 2640.16 2692.96 2746.82 2801.76 2857.79 2914.95 Month 4786.53 4882.26 4979.91 5079.50 5181.09 5284.72 5390.41 5498.22 5608.18 5720.35 5834.75 5951.45 6070.48 6191.89 6315.72 Annual 57438 58587 59759 60954 62173 63417 64685 65979 67298 68644 70017 71417 72846 74303 75789 SG 4O Hour 28.72 29.29 29.88 30.48 31.09 31.71 32.34 32.99 33.65 34.32 35.01 35.71 36.42 37.15 37.89 BiWeek 2297.53 2343.49 2390.35 2438.16 2486.93 2536.66 2587.40 2639.14 2691.93 2745.77 2800.68 2856.70 2913.83 2972.11 3031.55 Month 4977.99 5077.55 5179.10 5282.68 5388.34 5496.10 5606.03 5718.15 5832.51 5949.16 6068.14 6189.51 6313.30 6439.56 6568.35 Annual 59736 60931 62149 63392 64660 65953 67272 68618 69990 71390 72818 74274 75760 77275 78820 149 FY 200412005 Pay Tables Effective I October 2004 Step1 Step2 Step3 Step4 Step5 Step6 Step7 Step8 Step9 Step10 Step11 Step12 Step13 Step14 Step15 SG 41 Hour 29.87 30.47 31.07 31.70 32.33 32.98 33.64 34.31 35.00 35.69 36.41 37.14 37.88 38.64 39.41 BiWeek 2389.44 2437.22 2485.97 2535.69 2586.40 2638.13 2690.89 2744.71 2799.60 2855.60 2912.71 2970.96 3030.38 3090.99 3152.81 Month 5177.11 5280.65 5386.27 5493.99 5603.87 5715.95 5830.27 5946.87 6065.81 6187.13 6310.87 6437.09 6565.83 6697.15 6831.09 Annual 62125 63368 64635 65928 67246 68591 69963 71362 72790 74246 75730 77245 78790 80366 81973 SG 42 Hour 31.06 31.68 32.32 32.96 33.62 34.30 34.98 35.68 36.39 37.12 37.87 38.62 39.39 40.18 40.99 BiWeek 2485.01 2534.71 2585.41 2637.12 2689.86 2743.66 2798.53 2854.50 2911.59 2969.82 3029.22 3089.80 3151.60 3214.63 3278.92 Month 5384.20 5491.88 5601.72 5713.75 5828.03 5944.59 6063.48 6184.75 6308.44 6434.61 6563.30 6694.57 6828.46 6965.03 7104.33 Annual 64610 65903 67221 68565 69936 71335 72762 74217 75701 77215 78760 80335 81942 83580 85252 SG 43 Hour 32.31 32.95 33.61 34.28 34.97 35.67 36.38 37.11 37.85 38.61 39.38 40.17 40.97 41.79 42.63 BiWeek 2584.41 2636.10 2688.82 2742.60 2797.45 2853.40 2910.47 2968.68 3028.05 3088.61 3150.39 3213.39 3277.66 3343.21 3410.08 Month 5599.56 5711.55 5825.79 5942.30 6061.15 6182.37 6306.02 6432.14 6560.78 6692.00 6825.84 6962.35 7101.60 7243.63 7388.50 Annual 67195 68539 69909 71308 72734 74188 75672 77186 78729 80304 81910 83548 85219 86924 88662 SG 44 Hour 33.60 34.27 34.95 35.65 36.37 37.09 37.84 38.59 39.36 40.15 40.96 41.77 42.61 43.46 44.33 BiWeek 2687.79 2741.55 2796.38 2852.30 2909.35 2967.54 3026.89 3087.43 3149.17 3212.16 3276.40 3341.93 3408.77 3476.94 3546.48 Month 5823.55 5940.02 6058.82 6179.99 6303.59 6429.67 6558.26 6689.42 6823.21 6959.68 7098.87 7240.85 7385.66 7533.38 7684.04 Annual 69883 71280 72706 74160 75643 77156 78699 80273 81879 83516 85186 86890 88628 90401 92209 SG 45 Hour 34.94 35.64 36.35 37.08 37.82 38.58 39.35 40.14 40.94 41.76 42.59 43.45 44.31 45.20 46.10 BiWeek 2795.30 2851.21 2908.23 2966.40 3025.72 3086.24 3147.96 3210.92 3275.14 3340.64 3407.46 3475.61 3545.12 3616.02 3688.34 Month 6056.49 6177.62 6301.17 6427.19 6555.74 6686.85 6820.59 6957.00 7096.14 7238.06 7382.82 7530.48 7681.09 7834.71 7991.41 Annual 72678 74131 75614 77126 78669 80242 81847 83484 85154 86857 88594 90366 92173 94017 95897 SG 46 Hour 36.34 37.07 37.81 38.56 39.33 40.12 40.92 41.74 42.58 43.43 44.30 45.18 46.09 47.01 47.95 BiWeek 2907.11 2965.26 3024.56 3085.05 3146.75 3209.69 3273.88 3339.36 3406.15 3474.27 3543.76 3614.63 3686.92 3760.66 3835.88 Month 6298.75 6424.72 6553.22 6684.28 6817.97 6954.33 7093.41 7235.28 7379.99 7527.59 7678.14 7831.70 7988.33 8148.10 8311.06 Annual 75585 77097 78639 80211 81816 83452 85121 86823 88560 90331 92138 93980 95860 97777 99733 150 SG 47 Hour BiWeek Month Annual SG 48 Hour BiWeek Month Annual SG 49 Hour BiWeek Month Annual SG 5O Hour BiWeek Month Annual FY 2004/2005 Pay Tables Effective 1 October 2004 Step1 Step2 Step3 Step4 Step5 Step6 Step7 Step8 Step9 Step10 Step11 Step12 Step13 Step14 Step15 37.79 38.55 39.32 40.11 40.91 41.73 42.56 43.41 44.28 45.17 46.07 46.99 47.93 48.89 49.87 3023.40 3083.87 3145.54 3208.45 3272.62 3338.08 3404.84 3472.93 3542.39 3613.24 3685.51 3759.22 3834.40 3911.09 3989.31 6550.70 6681.71 6815.35 6951.65 7090.68 7232.50 7377.15 7524.69 7675.19 7828.69 7985.26 8144.97 8307.87 8474.02 8643.51 78608 80181 81784 83420 85088 86790 88526 90296 92102 93944 95823 97740 99694 101688 103722 39.30 40.09 40.89 41.71 42.54 43.39 44.26 45.15 46.05 46.97 47.91 48.87 49.85 50.84 51.86 3144.33 3207.22 3271.37 3336.79 3403.53 3471.60 3541.03 3611.85 3684.09 3757.77 3832.93 3909.58 3987.78 4067.53 4148.88 6812.72 6948.98 7087.96 7229.72 7374.31 7521.80 7672.23 7825.68 7982.19 8141.84 8304.67 8470.77 8640.18 8812.99 8989.25 81753 83388 85056 86757 88492 90262 92067 93908 95786 97702 99656 101649 103682 105756 107871 40.88 41.69 42.53 43.38 44.25 45.13 46.03 46.95 47.89 48.85 49.83 50.82 51.84 52.88 53.94 3270.11 3335.51 3402.22 3470.26 3539.67 3610.46 3682.67 3756.33 3831.45 3908.08 3986.24 4065.97 4147.29 4230.23 4314.84 7085.23 7226.94 7371.48 7518.91 7669.28 7822.67 7979.12 8138.71 8301.48 8467.51 8636.86 8809.60 8985.79 9165.51 9348.82 85023 86723 88458 90227 92031 93872 95749 97664 99618 101610 103642 105715 107829 109986 112186 42.51 43.36 44.23 45.11 46.02 46.94 47.87 48.83 49.81 50.81 51.82 52.86 53.91 54.99 56.09 3400.91 3468.93 3538.31 3609.08 3681.26 3754.88 3829.98 3906.58 3984.71 4064.40 4145.69 4228.61 4313.18 4399.44 4487.43 7368.64 7516.02 7666.34 7819.66 7976.06 8135.58 8298.29 8464.25 8633.54 8806.21 8982.33 9161.98 9345.22 9532.13 9722.77 88424 90192 91996 93836 95713 97627 99579 101571 103602 105675 107788 109944 112143 114386 116673 Note: This table does not apply to EMS Personel Working 24~48 Shifts. Computation of Hourly rates and Overtime Compensation is governed by The Fair Labor Standards Handbook, Section 520, Irregular Hours. 151 2004~2005 COMPENSATION PLAN SECTION I 1. Salary Schedule The pay of City employees shall be on the basis of the appropriate salary schedule prescribed by the City of Schertz and approved by the Council. The general salary schedule consists of an entrance rate, and through a series of steps to a maximum rate. The salaries prescribed in the schedule are fixed on the basis of regular service for 40 hours of work per week. 2. Application of Plan to Position The service grade assigned refers to the service grade established for each of the positions. Each employee shall be paid within the range established for his/her position, subject to the provisions of Section 2 of this plan. The City Manager will determine the rate on the basis of his/her evaluation of the experience, ability and length of service of the employee. SECTION II 1. Starting Rate on Initial Employment On odginal hiring to any position, the salary shall be in successive steps. The City Manager may approve initial compensation at the 2nd or 3rd step in the appropriate service grade when experience, skill, training, or labor market conditions justify the action. The City Manager may approve initial compensation in salary grades of Department Heads in any step of the appropriate salary grade when exceptional experience, training, or labor market conditions justify the action. 2. Starting Rate on Retum to Duty Employee's retuming to duty in the same class of position after a separation from City service of not more than twelve months, when separation was without prejudice to the employee, may, at the discretion of the City Manager, receive the rate in the salary schedule corresponding to the step rate received at time of separation and shall subsequently be paid such rate for at least such period as is normally required for advancement to the next higher salary. 3. Starting Rate in New Position Whenever an employee is assigned to duty in a position of a different class not previously held, and such change is not a promotion, the employee shall receive 152 2004~2005 COMPENSATION PLAN the entrance rate in the salary schedule or such other rate within the applicable schedule as may be reasonable for prior service, meeting the following conditions: a. Duties of new position similar to those from old position; b. Service in former position provided experience valuable to performance of duties in new position. 4. Rate of Pay on Promotion When an employee is promoted to a position with a higher salary schedule, the entrance salary rate shall be at the lowest step in the higher salary schedule. The lowest step is considered to be the lowest step that will provide an increase over the salary received immediately prior to promotion. 5. Advancement of Salary Within a Salary Schedule Advancement in the salary of an employee within a salary schedule shall be based on the achievement of minimum periods of service and satisfactory performance. a. The minimum period of service for the first salary advance after hire or promotion shall be six (6) months. For each succeeding advance, uninterrupted service of twelve month periods shall be required. In both instances, the individual supervisor must make a recommendation based on performance as noted in Section IV. b. To recognize exceptional performance or current labor market conditions, the City Manager may approve advancement; but such advancement cannot exceed two steps in any twelve (12) month period. The provisions of this section shall be in addition to all other provisions for step advancement within grade. 6. Recommendations for Salary Advancement within Grade Department Heads may recommend in writing to the City Manager the advancement in salary rate of employees in his/her department who have completed special training, or who have accepted additional duties and responsibilities within the department beyond those normally required. 153 2004/2005 COMPENSATION PLAN SECTION III 1. Compensation of Part-Time Employees A part-time employee is an employee who works less than 35 hours per week and/or whose total hours worked in a twelve consecutive month period does not exceed 1,040 hours. A part-time employee shall be paid on an hourly rate basis equivalent to the appropriate monthly rate in the salary schedule for the classification. 2. Advancement in Salary for Part-Time Employees A part-time employee may be advanced in pay in the same manner as other employees, provided that only actual hours of work shall be considered in determining such advancement. When the houdy equivalent of required pedods of service has been attained, advancement to the next higher step rate may be effected in accordance with Section II above. The preceding paragraph does not apply to Part Time EMS personnel. Part Time EMS personnel are considered for wage scale increases based on certifications. The City Manager may approve a wage scale increase if and when appropriate. 3. Compensation for Temporary Employees A temporary employee is an employee who is employed for a known period of time not to exceed four consecutive calendar months, or for a season, to perform a specific function. All such employment must be specified as to length of time anticipated to complete the temporary assignment in the salary schedule. SECTION IV 1. Periodic Performance Evaluation The Periodic Performance Evaluation is a management method, which puts in actual operation, the philosophy that human assets of organizations are just as important to organizational development as material resources. The objectives of this method are the following: to evaluate the performance and potential of each employee; to recognize and correct each employee's weaknesses through helpful discussion, special training, and personal development; to discover old and new talent with a view to further development and improved placement; to develop organizational replacement charts; to strengthen morale through assurance that recognition is based on merit only; to 154 2004~2005 COMPENSATION PLAN stimulate interest in the principles of personnel administration through increased understanding between supervisors and employees; and finally, to assist in the establishment of complete personnel records and manpower inventories as a means of implementing the policy of promotion from within. 2. Planning and Scheduling Evaluations It is important that each employee understands the organization's periodic Performance Evaluation procedures and knows who will review his or her performance. The Department Head or his/her appointed representative will perform the evaluation based upon the job performance of the employee on a regular basis, within six months of initial hire or promotion, and at least annually thereafter. After discussion with the employee, the department head will forward the Performance Evaluation to the City Manager for his review and action. 3. Conclusion This program will furnish management with a reliable overall inventory of its human assets in terms of skills and aptitudes, present and potential. On an individual basis, it provides the necessary data for appraising potential ability of all employees. Moreover, it promotes better understanding and communication between supervisors and employees. Finally, experience with the program has shown that sound personnel evaluation is almost invariably reflected in improved organizational functioning. 155 This Page left Intentionally Blank DEBT SERVICE REVIEW General Fund Year 2005 2006 2007 2008 1992 $ 70,130 $ 117,080 $ 110,830 $ 74,480 $ 1995 42,025 - 2001 345,270 345,970 346,070 346,470 2002 137,126 - 2003 317,608 337,858 282,858 243,089 2004 567,047 606,736 541,636 615,936 2O09 - $ 348,075 243,270 628,036 2010 349,980 -to 2021 247,480 -to 2018 604,227 -to 2024 Total $1,479,206 $1,407,644 $1,281,394 $1,279,975 $1,219,381 $1,201,687 Water and Waste Water Debt Service Year 2005 2006 2007 2008 1974 $ 8,000 $ 7,700 $ 8,400 $ 8,050 $ 1995 65,600 - - - 2001 593,290 488,660 482,350 470,550 2009 2010 7,700 $ 7,350 468,381 368,131 -to 2021 Total $ 666,890 $ 496,360 $ 490,750 $ 478,600 $ 476,081 $ 375,481 Sche~z-Seguin Local Government Corporation Debt-Sche~z Potion Year 2005 2006 2007 2008 2009 2010 1999 $ 375,290 $ 376,632 $ 377,662 $ 378,307 $ 381,004 $ 380,752 -to 2025 2001 1,173,009 1,170,960 1,171,159 1,171,033 1,168,125 1,167,409 -to 2041 Total $1,548,299 $1,547,592 $1,548,821 $1,549,340 $1,549,129 $1,548,161 Year 2005 1999 $ 128,281 $ G O Refnd MUD2 SR1999-Capital Recovery 2006 2007 2008 2009 - $ - $ $ 2010 Total $ 128,281 $ - $ $ - $ - Sche~z Economic Development Corporation 4B Debt Year 2005 2006 2007 2008 2009 2010 1998 $ 384,236 $ 381,486 $ 378,098 $ 378,914 $ 373,933 $ 375,673 -to 2018 2001 166,748 166,400 - - - Total $ 550,984 $ 547,886 $ 378,098 $ 378,914 $ 373,933 $ 375,673 156 CITY OF SCHERTZ General Obligation Bonds, Series 1992 Street Improvements 5.90% For 2004, 6.10% For 2005, 6.25% For 2006, 6.35% For 2007, 6.04% For 2008. Amount issued: $620,000 Date Principal Interest Period Total Fiscal Total 12/1/2004 10,065.00 10,065.00 6/1/2005 50,000.00 10,065.00 60,065.00 $70,130.00 12/1/2005 8,540.00 8,540.00 6/1/2006 100,000.00 8,540.00 108,540.00 $117,080.00 12/1/2006 5,415.00 5,415.00 6/1/2007 100,000.00 5,415.00 105,415.00 $110,830.00 12/1/2007 2,240.00 2,240.00 6/1/2008 70,000.00 2,240.00 72,240.00 $74,480.00 $320,000.00 $52,520.00 $372,520.00 Paying Agent: The Bank of New York 157 CITY OF SCHERTZ General Obligation Refunding Bonds, Series 1995 General Fund's Portion 4.90% For 2004, 5.00% For 2005. Amount issued: $1,700,000 Date Principal Interest Period Total Fiscal Total 2/1/2005 41,000.00 1,025.00 42,025.00 8/1/2005 $42,025.00 $41,000.00 $1,025.00 $42,025.00 Paying Agent: The Bank of New York 158 Date CITY OF SCHERTZ Certificate of Obligation Bonds, Series 2001 Schertz Parkway Project Amount issued: $4,500,000 Principal Interest Period Total Fiscal Total 2/1/2005 150,000.00 8/1/2005 2/1/2006 160,000.00 8/1/2006 2/1/2007 170,000.00 8/1/2007 2/1/2008 180,000.00 8/1/2008 2/1 ~2009 190,000.00 8/1/2009 2/1/2010 200,000.00 8/1/2010 2/1/2011 210,000.00 8/1/2011 2/1/2012 225,000.00 8/1/2012 2/1/2013 235,000.00 8/1/2013 2/1/2014 250,000.00 8/1/2014 2/1/2015 260,000.00 8/1/2015 2/1/2016 275,000.00 8/1/2016 2/1/2017 290,000.00 8/1/2017 2/1/2018 300,000.00 8/1/2O 18 2/1/2019 320,000.00 8/1/2019 2/1/2020 335,000.00 8/1/2020 2/1/2021 350,000.00 8/1/2021 99 885.00 95 385.00 95.385.00 90 585.00 90 585.00 85 485.00 85 485.00 80 985.00 80 985.00 77 090.00 77 090.00 72 890.00 72.890.00 68,427.50 68 427.50 63 477.50 63 477.50 58.190.00 58 190.00 52 440.00 52 440.00 46 330.00 46 330.00 39 730.00 39 730.00 32,625.00 32,625.00 25,125.00 25,125.00 17,125.00 17,125.00 8,750.00 8,750.00 249,885.00 95 385.00 255 385.00 90 585.00 260 585.00 85 485.00 265.485.00 8Q 985.00 270.985.00 77 090.00 277 O90.0O 72 890.00 282.890.00 68 427.50 293 427.5O 63 477.50 298 477.50 58 190.00 308,190.00 52,440.00 312,440.00 46,330.00 321,330.00 39,730.00 329,730.00 32,625.00 332,625.00 25,125.00 345,125.00 17,125.00 352,125.00 8,750.00 358,750.00 0.00 $4,100,000.00 $ 1,929,165.00 $ 6,029,165.00 Paying Agent: The Bank of New York $345,270.00 $345,97O.OO $346,070.00 $346,470.00 $348,075.00 $349,980.00 $351,317.50 $356,9O5.OO $356,667.50 $360,630.00 $358,770.00 $361,060.00 $362,355.00 $357,750.00 $362,250.00 $360,875.00 $358,750.00 159 CITY OF SCHERTZ Tax Notes, Series 2002 Technology Upgrade & Equipment Amount issued: $ 400,000 Date Principal Interest Period Total Fiscal Total 2/1/2005 135,000.00 2,126.25 137,126.25 8/1/2005 $ 135,000.00 $ 2,126.25 $ 137,126.25 $137,126.25 Paying Agent: The Bank Of New York 160 Date CITY OF SCHERTZ Combination Tax and Ltd Pledge Revenue Certificates of Obligation, Series 2003 Amount of Issue: $3,360,000 Principal Interest Pedod Total Fiscal Total 2/1/2005 225,000.00 8/1/2005 2/1/2006 250,000.00 8/1/2006 2/1/2007 200,000.00 8/1/2007 2/1/2008 165,000.00 8/1/2008 2/1/2009 170,000.00 8/1/2009 2/1/2010 180,000.00 8/1/2010 2/1/2011 190,000.00 8/1/2011 2/1/2012 200,000.00 8/1/2012 2/1/2013 210,000.00 8/1/2013 2/1/2014 220,000.00 8/1/2014 2/1/2015 225,000.00 8/1/2015 2/1/2016 225,000.00 8/1/2016 2/1/2017 225,000.00 8/1/2017 2/1/2018 250,000.00 8/1/2018 47,428.75 45,178.75 45 178.75 42 678.75 42 678.75 40.178.75 40 178.75 37 910.00 37,910.00 35 360.00 35 360.00 32 120.00 32 120.00 28,700.00 28 700.00 25 100.00 25,100.00 21 267.50 21 267.50 17 362.50 17 362.50 13.312.50 13 312.50 9 150.00 9.150.00 4 875.00 4 875.00 272,428.75 45 178.75 295 178.75 42 678.75 242 678.75 40.178.75 205,178.75 37,910.00 207,910.00 35,360.00 215,360.00 32,120.00 222,120.00 28,700.00 228,700.00 25,100.00 235,100.00 21,267.50 241,267.50 17,362.50 242,362.50 13,312.50 238,312.50 9,150.00 234,150.00 4,875.00 254,875.00 $2,935 000.00 $ 753,816.25 Paying Agent: J.P. Morgan Chase Bank $ 3,688,816.25 $317,607.50 $337,857.5O $282,857.5O $243,O88.75 $243,270.0O $247,480.0O $250,820.00 $253,800.00 $256,367.50 $258,630.00 $255,675.00 $247,462.50 $239,025.0O $254,875.00 161 Date CITY OF SCHERTZ Combination Tax and Ltd Pledge Revenue Certificates of Obligation, Series 2004 Amount of Issue: $ 7,750,000 Principal Interest Period Total Fiscal Total 2/1/2OO5 8/1/2005 2/1/2O06 8/1/2006 2/1/2007 8/1/2007 2/1/2008 8/1/2008 2/1/2009 8/1/2009 2/1/2010 8/1/2010 2/1/2011 8/1/2011 2/1/2012 8/1/2012 2/1/2013 8/1/2013 2/1/2014 8/1/2014 2/1/2015 8/1/2015 2/1/2016 8/1/2016 2/1/2017 8/1/2017 2/1/2018 8/1/2018 2/1/2019 8/1/2019 2/1/2020 8/1/2020 2/1/2021 8/1/2021 2/1/2022 8/1/2022 2/1/2023 8/1/2023 2/1/2024 9/30/2024 160,000.00 280,000.00 225,000.00 310,000.00 335,000.00 325,000.00 325,000.00 315,000.00 325,000.00 325,000.00 325,000.00 325,000.00 350,000.00 350,000.00 460,000.00 460,000.00 480,000.00 675,000.00 700,000.00 700,000.00 240,879.11 166,168.13 166,168.13 160,568.13 160,568.13 156 068.13 156.068.13 149.868.13 149.868.13 143.168.13 143.168.13 136 058.75 136 058.75 128,949.38 128 949.38 122 058.75 122 058.75 115 152.50 115 152.50 108 652.50 108 652.50 101 990.00 101 990.00 95 165.00 95 165.00 87 640.00 87 640.00 79 983.75 79 983.75 69 863.75 69 863.75 59 513.75 59 513.75 48 593.75 48 593.75 32 900.00 32 900.00 16 450.00 16 450.00 400,879.11 166,168.13 446,168.13 160,568.13 385,568.13 156,068.13 466,068.13 149 868.13 484 868.13 143 168.13 468 168.13 136 058.75 461 058.75 128 949.38 443 949.38 122 058.75 447 058.75 115 152.50 440 152.50 108 652.50 433 652.50 101 990.00 426 990.00 95 165.00 445 165.00 87 640.00 437 640.00 79 983.75 539 983.75 69 863.75 529 863.75 59 513.75 539 513.75 48 593.75 723 593.75 32 900.00 732 900.00 16 450.00 716 450.00 $7,750,000.00 $4,198,504.17 $ 11,948,504.17 $567,047.24 $606,736.26 $541,636.26 $615,936.26 $628,036.26 $604,226.88 $590,008.13 $566,008.13 $562,211.25 $548,805.00 $535,642.50 $522,155.00 $532,805.00 $517,623.75 $609,847.50 $589,377.50 $588,107.50 $756,493.75 $749,350.00 $716,450.00 162 CITY OF SCHERTZ Tax Notes, Series 2001 Sales Tax Supported, Fire Truck & Equipment Amount of issue: $750,000 Date Principal Interest Pedod Total Fiscal Total 11/1/2004 5,873.75 5,873.75 5/1/2005 155,000.00 5,873.75 160,873.75 11/1/2005 3,200.00 3,200.00 5/1/2006 160,000.00 3,200.00 163,200.00 $315,000.00 $18,147.50 $333,147.50 Paying Agent: The Bank of New York $166,747.5O $166,400.00 163 Date CITY OF SCHERTZ General Obligation Bonds, 4B Series 1998 Sales Tax Supported, Public Safety Complex Construction Bond Amount of issue: $4,930,000 Principal Interest Period Total Fiscal Total 2/1/2005 195,000.00 8/1/2OO5 2/1/2006 205,000.00 8/1/2006 2/1/2007 215,000.00 8/1/2007 2/1/2008 230,000.00 8/1/2008 2/1/2009 240,000.00 8/1/2009 2/1/2010 255,000.00 8/1/2010 2/1/2011 270,000.00 8/1/2011 2/1/2012 285,000.00 8/1/2012 2/1/2013 300,000.00 8/1/2013 2/1/2014 315,000.00 8/1/2014 2/1/2015 335,000.00 8/1/2015 2/1/2016 355,000.00 8/1/2016 2/1/2017 375,000.00 8/1/2017 2/1/2018 395,000.00 8/1/2018 97.725.63 91.510.00 91 510.00 84,975.63 84 975.63 78 122.50 78 122.50 70 791.25 70 791.25 63 141.25 63 141.25 57 531.25 57 531.25 51 625.00 51 625.00 45 390.63 45 390.63 38 828.13 38 828.13 31 937.50 31 937.50 24 609.38 24 609.38 16 843.75 16 843.75 8 640.63 8 640.63 292 725.63 91510.00 296.510.00 84.975.63 299.975.63 78.122.50 308.122.50 70.791.25 310,791.25 63.141.25 318 141.25 57.531.25 327.531.25 51.625.00 336.625.00 45.390.63 345.390.63 38.828.13 353.828.13 31.937.50 366.937.50 24.609.38 379.609.38 16.843.75 391 843.75 8 640.63 403,640.63 $ 3,970,000.00 $1,425,619.43 $ 5,395,619.43 $384 235.63 $381 485.63 $378,O98.13 $378,913.75 $373 932.5O $375 672.50 $379 156.25 $382,015.63 $384,218.76 $385 765.63 $391 546.88 $396 453.13 $4OO 484.38 $403 64O.63 Paying Agent: J.P. Morgan Chase Bank 164 CITY OF SCHERTZ General Obligation Refunding Bonds, Series 1995 Utility Fund Portion 4.85% For 2003, 4.90% For 2004, 5.00% For 2005. Amount issued: $1,700,000 Date Principal Interest Pedod Total Fiscal Total 2/1/2005 64,000.00 1,600.00 65,600.00 8/1/2005 $65,600.00 $ 64,000.00 $ 1,600.00 $ 65,600.00 Paying Agent: The Bank of New York 165 CITY OF SCHERTZ Utility System Revenue & Refunding Bonds, Series 2001 Amount Issued: $5,500,000 Date Principal Interest Period Total Fiscal Total 3/1/2005 9/1/2005 380,000.00 3/1/2006 9/1/2006 290,000.00 3/1/2007 9/1/2007 295,000.00 3/1/2008 9/1/2008 295,000.00 3/1/2009 9/1/2009 305,000.00 3/1/2010 9/1/2010 220,000.00 3/1/2011 9/1/2011 230,000.00 3/1/2012 9/1/2012 240,000.00 3/1/2013 9/1/2013 250,000.00 3/1/2014 9/1/2014 265,000.00 3/1/2015 9/1/2015 280,000.00 3/1/2016 9/1/2016 290,000.00 3/1/2017 9/1/2017 295,000.00 3/1/2018 9/1/2018 230,000.00 3/1/2019 9/1/2019 240,000.00 3/1/2020 9/1/2020 255,000.00 3/1/2021 9/1/2021 265,000.00 106.645.00 106.645.00 99.330.00 99.330.00 93.675.00 93.675.00 87.775.00 87 775.00 81.690.63 81.690.63 74.065.63 74 065.63 69.335.63 69.335.63 64.275.63 64.275.63 58.815.63 58.815.63 53003.13 53.003.13 46.709.38 46.709.38 39.919.38 39.919.38 32.669.38 32.669.38 25.294.38 25294.38 19,544.38 19,544.38 13,424.38 13,424.38 6,890.00 6,890.00 106,645.00 486,645.00 99,330.00 389,330.00 93,675.00 388,675.00 87,775.00 382,775.00 81,690.63 386,690.63 74,065.63 294,065.63 69,335.63 299,335.63 64,275.63 304,275.63 58,815.63 308,815.63 53,003.13 318,003.13 46,709.38 326,709.38 39,919.38 329 919.38 32.669.38 327.669.38 25.294.38 255 294.38 19.544.38 259 544.38 13,424.38 268,424.38 6,890.00 271,890.00 $4,625,000.00 $1,946,125.12 $6,571,125.12 $ 593,290.00 $ 488 66O.O0 $ 482 35O.O0 $ 470 550.O0 $ 468,381.26 $ 368,131.26 $ 368,671.26 $ 368,551.26 $ 367,631.26 $ 371 006.26 $ 373,418.76 $ 369,838.76 $ 360,338.76 $ 280,588.76 $ 279,088.76 $ 281,848.76 $ 278,78O.00 Paying Agent: The Bank of New York 166 SCHERTZ/SEGUIN LOCAL GOVERNMENT CORPORATION S/S/Local Govt Corp Contract Revenue Bond SR1999 Paid 1/2 Schertz, 1/2 Seguin Amount Issued: $10,000,000 Fiscal Year Series 1999 Series 2001 Total Schertz's Share 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 750,579 753,263 755,323 756,613 762,007 761,504 765 104 767,460 768 468 773 096 776 085 777 291 781,643 779 218 779,855 783,091 784,015 782,733 783,750 782,050 782,800 2,346,018 3,096,597 $1,548,299 2,341,920 3,095,183 $1,547,592 2,342,318 3,097,641 $1,548,821 2,342,065 3,098,678 $1,549,339 2,336,249 3,098,256 $1,549,128 2,334,818 3,096,322 $1,548,161 2,332,681 3,097,785 $1,548,893 2,329,926 3,097,386 $1,548,693 2,331,348 3,099,816 $1,549,908 2,322,010 3,095,106 $1,547,553 2,321,925 3,098,010 $1,549,005 2,320,625 3,097,916 $1,548,958 2,313,375 3,095,018 $1,547,509 2,320,250 3,099,468 $1,549,734 2,315,881 3,095,736 $1,547,868 2,315,381 3,098,472 $1,549,236 2,308,453 3,092,468 $1,546,234 2,309,938 3,092,671 $1,546,336 2,310,078 3,093,828 $1,546,914 2,308,875 3,090,925 $1,545,463 2,311,194 3,093,994 $1,546,997 3,095,266 3,095,266 $1,547,633 3,094,881 3,094,881 $1,547,441 3,095,331 3,095,331 $1,547,666 3,096,347 3,096,347 $1,548,174 3,092,794 3,092,794 $1,546,397 3,105,705 3,105,705 $1,552,853 3,109,765 3,109,765 $1,554,883 3,018,625 3,018,625 $1,509,313 3,107,155 3,107,155 $1,553,578 3,109,965 3,109,965 $1,554,983 3,096,475 3,096,475 $1,548,238 3,096,394 3,096,394 $1,548,197 3,099,488 3,099,488 $1,549,744 3,100,363 3,100,363 $1,550,182 3,098,756 3,098,756 $1,549,378 3,099,275 3,099,275 $1,549,638 $16,205~948 $98,331,913 $114,537,861 $57,268,931 Paying Agent: The Bank of New York 167 Date CITY OF SCHERTZ GMAC Commercial Mortgage Schaefer Road Rural Water 5% Interest Rate Principal Interest Period Total Fiscal Total 2/1/2005 2/1/2006 2/1/2007 2/1/2008 2/1/2009 2/1/2010 000.00 2,000.00 000.00 1,700.00 000.00 1,400.00 000.00 1,050.00 000.00 700.00 000.00 350.00 $ 40000.00 $ 7,200.00 $ 8 000.00 7 700.00 8 400.00 8 050.00 7 700.00 7 350.00 47 200.00 $8 $7 $8 $8 $7. $7 000.00 700.00 400.00 050.00 700.00 350.00 168 CITY OF SCHERTZ General Obligation Refunding Bonds, Series 1999 Amount issued: $ 650,000 Date Principal Interest Period Total Fiscal Total 3/1/2005 125,000.00 3,281.25 128,281.25 9/1/2005 $ 125,000.00 $ 3,281.25 $ 128,281.25 $128,281.25 Paying agent: JP Morgan Chase Bank 169