Loading...
FY 2005-06 Budget1400 SCHERTZ PARKWAY SCHERTZ. TEXAS 78154 -1634 (210) 658 -7477 ext. i I I I FAX (210) 659 -3204 September 29, 2005 To: Mayor and City Council From: Don E. Taylor, City Manager Subject: 2005 -2006 Operating Budget Recommendations DON E. TAYLOR CITY MANAGER Budget Recommendations for year 2005 -2006 were filed with the City Secretary on July 29, 2005, in accordance with the requirements of the City Charter. The total estimated budget expenditures for all funds are recommended to be $26,450,067. Revenues in each fund meet or exceed proposed expenditures. A tax rate of 0.3977 or 39.77 cents of $100.00 of valuation is recommended. The tax rate is based on an assessed valuation certified by the Guadalupe County Appraisal District at $1,397,297,729. The tax rate components are as follows: 0.3005 for Maintenance and Operations and .0972 for debt service. Continued growth and demand for services necessitates the increase in the overall tax rate. The wet weather we have experienced over the last three years has placed stress on the Water Utility Fund causing lower than anticipated revenues. I am recommending an increase to our water rates to make the Utility Fund viable again. The Water Utility Fund was paying fees to General Fund in excess of $548,000, last year it was reduced $204,222 due to the decreasing water sales. Water Utility cannot continue to support the General Fund in this manner. This year the Water Utility Fund will be assessed a 3% fee based on gross sales. This is similar to fees charged to other franchises. In this budget we are striving to have General Fund operate with less support from the Water Utility Fund. This will express a true picture of our tax cost. Schertz EMS Department has struggled to stabilize and not ask for supplemental funds from the City of Schertz. An increase from $7.00 to $10.00 per capita will allow Schertz EMS to truly stand on its own and begin to pay back the loan from the City of Schertz for past operations. All Capital Projects approved are now actively underway. (See the Capital Projects list section of the Budget) Overall, the City of Schertz is in sound financial condition with adequate reserves. I cannot give enough thanks to the tireless efforts 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. Evelyn Boggess for working the tax rate /valuation numbers and Donna Dykes for her work on the personnel numbers. Sincerely, Don E Taylor City Manager Schertz Corridor to the Future CITY OF SCHERTZ 2005 -2006 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---------------------------------------------------------- - - - - -- IX Revenues- All Funds ---------------------------------------------------------------------- X Chart- All Funds------------------------------------------------------------ - - - - -- XI Expenditures - All Funds ----------------------------------------------------------------- XII Chart- All Funds------------------------------------------------------------ - - - - -- XIII General Fund Expenditures by function --------------------------- -- -------------- - -XIV Chart - General Fund Expenditures by function-------------------- - - - - -- XV General Fund Revenue & Expenditure Summary----------------------------------------- - - -1 -6 Revenues----------------------------------------------------------------------- - - - - -- 7 -10 CityCouncil----------------------------------------------------------------------- -11 -12 CityManager---------------------------------------------------------------------- -13 -14 CourtSupport--------------------------------------------------------------------- -15 -17 MunicipalCourt------------------------------------------------------------- - - - - -- 18 -20 Planning & Zoning---------------------------------------------------------- - - - - -- 21 -23 LegalServices---------------------------------------------------------------------- -24 -25 Facility Maintenance------------------------------------------------------- - - - - -- 26 -28 City Secretary----------------------------------------------------------------- - - - - -- 29 -31 Non - Departmental---------------------------------------------------------- - - - - -- 32 -33 Public Information Officer------------------------------------------------ - - - - -- 34 -35 Records Management------------------------------------------------------ - - - - -- 36 -37 Police--------------------------------------------------------------------------- - - - - -- 38-41 Fire------------------------------------------------------------------------------ - - - - -- 42-44 Inspections-------------------------------------------------------------------- - - - - -- 45-47 Streets--------------------------------------------------------------------------- - - - - -- 48 -50 Parks---------------------------------------------------------------------------- - - - - -- 51 -53 Pool----------------------------------------------------------------------------------- -54 -56 Library-------------------------------------------------------------------------- - - - - -- 57 -59 Animal Control-------------------------------------------------------------------- -60 -62 Information Technology 63 -65 Human Resources----------------------------------------------------------- - - - - -- 66 -68 Finance------------------------------------------------------------------------- - - - - -- 69 -70 FleetService------------------------------------------------------------------- - - - - -- 71 -73 City Assistance--------------------------------------------------------------- - - - - -- 74 -75 Tax I &S Summary---------------------------------------- Revenues & Expenditures------------ - - - - -- 76 -78 79 -80 Water & Sewer Revenues & Expenses------------------------------------------------------ - - - - -- 81 -86 Business Office--------------------------------------------------------------- - - - - -- 87 -88 Water/ Wastewater --------------------------------------------------------- - - - - -- 89 -92 Public Safety EMS Summary---------------------------------------------------------------------------- -93 -98 Revenues----------------------------------------------------------------------------- 99 Expenses---------------------------------------------------------------------- - - - - -- -100 -102 Drainage Summary----------------------------------------------------------------------- - - - - -- 103 -108 Revenues---------------------------------------------------------------------- - - - - -- -109 Expenses---------------------------------------------------------------------- - - - - -- -110 -111 Capital Recovery Summary----------------------------------------------------------------------- - - - - -- 112 -113 Revenues---------------------------------------------------------------------- - - - - -- -114 Expenditures---------------------------------------------------------------- - - - - -- -115 Schertz Economic Development Corporation Summary--------------------------------------------------------------------- - - - - -- -116 -117 Revenues---------------------------------------------------------------------- - - - - -- -118 Expenditures----------------------------------------------------------------- - - - - -- -119 -122 Development Foundation , Summary------------------- - - - - -- Revenues------------------------- Expenditures ------------- - - - - -- 123 -124 125 126 Special Event Fund Summary---------------------------------------------------------------------- - - - - -- -127 Revenue----------------------------------------------------------------------- - - - - -- -128 Expenditures----------------------------------------------------------------- - - - - -- -129 Hotel Tax Summary--------------------------------------------------------------------- - - - - -- -130 -131 Revenues---------------------------------------------------------------------- - - - - -- 132 Expenditures----------------------------------------------------------------- - - - - -- -133 Parks Summary---------------------------------------------------------------------- - - - - -- 134 -135 Revenues---------------------------------------------------------------------- - - - - -- -136 Expenditures----------------------------------------------------------------- - - - - -- -137 Recycling Summary----------------------------------------------------------------------- - --- -- 138 -139 Revenues-------------------------------------------------------------------- - - - - -- -140 Expenditures----------------------------------------------------------------- - - - - -- -141 Working Capital Projects---------------------------------------------------------- - - ---- -142 -143 Organizational Chart--------------------------------------------------------------- - - - - -- -144 2005 -2006 Position Authorization ----------------------------- -- --------------------- _ 145 -149 2005 -2006 Pay Tables----------------------------------------------------------------- - - - - -- 150 -157 Compensation Plan 158 -163 Debt Service Review---------------------------------------------------------------- - - - - -- -164 GO Bond, SR1992 ----------------------------------------------------------------- 165 CO Bond, SR2001----------------------------------------------------------- - - - - -- 166 Combination Tax & Ltd Pledge Revenue - 2003--------------------- --- - -- -167 Combination Tax & Ltd Pledge Revenue - 2004--------------------- - - - - -- -168 GO Bond, SR1998 --------------------------------------------------------- - - - - -- -169 Utility System Rev & Refund Bond, SR2001 -------------------------------- 170 Schertz /Seguin Local Govt Corp, SR99 & SR01 ------------ ----- -------- -- 171 GMAC Commercial Mortgage------------------------------------------ - - - - -- -172 ORDINANCE NO. 05 -T -43 AN ORDINANCE LEVYING AND ASSESSING ALL TAXABLE PROPERTY WITHIN THE CORPORATE LIMITS OF THE CITY OF SCHERTZ, TEXAS, FOR THE YEAR 2006; PROVIDING THE BASIS OF ASSESSMENT OF ONE HUNDRED PERCENT (100 %) APPRAISED VALUE AND PROVIDING FOR THE COLLECTION THEREOF AT THE RATE OF 0.3977 ON THE ONE HUNDRED DOLLAR ($100.00) ASSESSED VALUATION; AND DECLARING AN EMERGENCY. WHEREAS, a public hearing was held on August 31, 2005 and September 6, 2005, 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.3977 on the one hundred dollar ($100.00) assessed valuation for the year 2005. THIS TAX RATE WILL RAISE MORE TAXES FOR MAINTENANCE AND OPERATIONS THAN LAST YEAR'S TAX RATE. THE TAX RATE WILL RAISE TAXES FOR MAINTENANCE AND OPERATIONS ON A $100,000 HOME BY APPROXIMATELY $11.60. I SECTION 2. 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.3005 (B) For requirements of the Tax Bond Interest and Sinking Fund to meet the outstanding tax supported indebtedness of the City for Fiscal Year 2005 -2006. $ 0.0972 TOTAL TAX RATE . $ 0.3977 The City Manager has certified to the availability of funds to pay principal and interest on the following indebtedness during the fiscal year 2005 -2006. Debt Principal Interest Total 1992 City of Schertz, Street Improvement General Obligation Bonds $ 100,000.00 $ 17,080.00 $ 117,080.00 2001 City of Schertz, Certificate of Obligation Bond 160,000.00 185,790.00 345,970.00 2003 City of Schertz, Combination Tax and LTD Pledge Revenue Bond 250,000.00 87,857.50 337,857.50 2004 City of Schertz, Combination Tax and LTD Pledge Revenue Bond 280.000.00 326.736.26 606,736.26 TOTAL $790.000.00 II $617,463.76 $1,407.643.76 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 2005, such basis of assessment being required to meet the proposed expenditures of the General Fund for the Fiscal Year 2005 -2006 and collection of taxes thereof at the rate of 0.3977 assessed valuation as herein provided. SECTION 4. THAT the Council hereby determined that an emergency exists requiring immediate action, and this Ordinance is hereby passed as an emergency measure to be effective immediately upon its passage and the enactment of this Ordinance as an emergency measure in accordance with the provisions of Section 4.09 (e) of the City's Home Rule Charter will contribute to the preservation of the public peace, health, or safety. SECTION 5. THE recorded vote on this Ordinance was as follows: 2 "d Reading Place One Council Member Carl Douglas Aye Place Two Council Member John Trayhan Aye Place Three Council Member Reginna Agee Aye Place Four Council Member Tony Wilenchik Nay Place Five Council Member Michael Carpenter Aye Mayor Hal Baldwin SECTION 6. That all ordinances and parts of ordinances in conflict be and same are hereby repealed. PASSED, APPROVED AND ADOPTED this thea0k da ATTEST: Schertz, Texas — 77/� a" Deput Citi3Oklcretary, City of Schertz, Texas (SEAL OF CITY) III ORDINANCE NO. 05 -T -42 AN ORDINANCE PROVIDING FUNDS FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2005 AND ENDING SEPTEMBER 30, 2006, 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; AND DECLARING AN EMERGENCY. 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, 2005 and Ending September 30, 2006. WHEREAS, notice of a public hearing upon said budget has been duly and legally published; and WHEREAS, said public hearing 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, 2005 and ending September 30, 2006, the budget was prepared and submitted to the City Council for its consideration and approval and that said budget in the total amount of $ 26,450,067 and the same is hereby appropriated for the maintenance as set forth in said budget. IV SECTION 2. THAT the said budget of the City of Schertz, Texas, for the fiscal year beginning October 1, 2005 and ending September 30, 2006, 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 2005 -2006. 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. SECTION 4. THAT the Council hereby determined that an emergency exists requiring immediate action, and this Ordinance is hereby passed as an emergency measure to be effective immediately upon its passage and the enactment of this Ordinance as an emergency measure in accordance with the provisions of Section 4.09 (e) of the City's Home Rule Charter will contribute to the preservation of the public peace, health, or safety. PASSED, APPROVED AND ADOPTED this the der of September 2005. ATTEST: City ecr a , City of Schertz (SEAL OF CITY) V Mayor, City`of Schertz, Texas Tax Year Rates and Property Evaluation Year Rate Total Valuation 1996 0.4072 $ 33491229763 1997 0.3554 $ 3789784,051 1998 0.3544 $ 4509199,212 1999 0.3455 $ 534,039,183 2000 0.3405 $ 7161795,968 2001 0.3825 $ 82297459104 2002 0.3825 $ 110059399,711 2003 0.3825 $ 1910512349626 2004 0.3760 $ 148599419678 2005 0.3977 $ 1939792979729 0.420 0.400 J :f d v 0.36( 0.34 0.32 0.31 Rate per Hundred Valuation 1996 1997 1998 1999 2000 2001 2002 2003 LUU4 /-UUZ) Year VII $420.00 $400.00 $380.00 cd $360.00 $340.01 $320.0 $300.0 Tax on $100,000 Valuation by Year 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 Year VIII 1600000000 Assessed Property Values 1400000000 1200000000 1000000000 a� 800000000 600000000 — 400000000 200000000 0 1 2 3 4 5 6 7 8 9 10 O Series1 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 ■Series2 $334,122,76 $378,784,05 $450,199,21 $534,039,18 $716,795,96 $822,745,10 $1,005,399, $1,105,234, $1,285,941, $1,397,297, Year IX Revenues -All Funds General Revenue $ 10,607,360 Debt Services $ 1,419,194 Water &Sewer $ 8,746,440 Drainage $ 358,330 Schertz EMS $ 4,029,371 Capital Recovery $ 1,068,223 Park/Recycle /Hotel $ 704,750 SED Corp /Dev Foundation $ 1,169,020 TOTAL $ 28,102,688 X a Expenditures -All Funds Debt Service $ 4,310,787 Personnel $ 10,774,659 Supplies $ 500,997 Professional &City Svcs $ 1,293,667 Utility & Maint. Services $ 5,469,678 Operation Support &Svc $ 3,471,487 Equip. &Leasing $ 628,792 TOTAL $ 26,450,067 W Opr ci ir,nr%r+ k nce+ Utility & Maint. Svc 21% a Expenditures - All Funds Equip & Leasing 2% Debt Service 16% 0/0 Supplies 2% W nel General Fund Expenditures - by Function Public Safety $ 5,162,736 General Govt. $ 2,494,071 Health $ 230,288 Parks &Culture $ 963,290 Public Environment $ 654,965 Internal Services $ 1,061,167 Misc. $ 10,000 TOTAL $ 10,576,517 X1V Gen. Govt. 23.6% General Fund Expenditures - By Function Parks & Culture Health 9.1% Public Environment 6.2% Internal Services D% xv Nub. 5atety 48.8% Misc 0.1% 2 General Fund - Expenditures Personnel Supplies Professional &City Svc Utility & Maint. Services Operation Support &Svc Equip. &Leasing TOTAL 3 $ 7,928,084 $ 237,362 $ 765,755 $ 684,380 $ 687,374 $ 273,562 $ 10,576,517 Prof & City Svc Supplies 2% Expenditures - General Fund Utility & Maint. Svc Opr Support & Asst. 6% 6% Equip. & Leasing 4 Personnel 76% CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY REVENUE SUMMARY Taxes Franchises Permits Licenses Fees Fines Inter - jurisdictional Inter -Fund Transfers Miscellaneous TOTAL REVENUES EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL CITY MANAGER COURT SUPPORT MUNICIPAL COURT PLANNING & ZONING LEGAL SERVICES FACILITY MAINTENANCE CITY SECRETARY NON DEPARTMENTAL PUBLIC INFORMATION RECORDS MANAGEMENT 4,711,916 5,060,476 5,755,000 6,423,025 598,536 651,629 680,218 740,000 521,365 490,563 531,200 540,400 33,232 34,261 20,700 20,000 1,028,346 1,131,588 1,244,575 1,565,030 18,943 20,339 19,000 24,000 154,347 185,145 250,884 279,456 576,334 483,736 464,937 407,419 132,128 132,339 423,500 608,030 7,775,147 8,190,076 9,390,014 10,607,360 TOTAL GENERAL GOVERNMENT PUBLIC SAFETY POLICE FIRE INSPECTIONS TOTAL PUBLIC SAFETY 17,452 21,442 19,250 24,600 273,540 327,458 399,824 323,456 211,849 224,336 266,251 154,063 - - 100,076 247,814 132,781 262,010 206,176 269,805 88,729 182,915 147,500 187,500 310,722 320,741 347,900 391,976 118,536 118,602 225,591 112,316 306,322 439,966 468,500 597,068 59,209 59,992 71,205 82,602 - - - 102,871 1,519,140 1,957,462 2,252,273 2,494,071 2,268,544 2,293,098 2,473,049 1,181,963 1,231,149 1,532,795 278,814 274,828 350,664 3,729,321 3,799,075 4,356,508 3,061,360 1,750,938 350,438 5,162,736 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED PUBLIC ENVIRONMENT STREETS 427,831 452,250 617,319 654,965 TOTAL PUBLIC ENVIRONMENT 427,831 452,250 617,319 654,965 PARKS & RECREATION PARKS 245,592 524,346 448,079 434,953 POOLS 105,094 - 130,789 140,185 TOTAL PARKS & RECREATION 350,686 524,346 578,868 575,138 CULTURAL LIBRARY 303,279 298,127 334,178 388,152 TOTAL CULTURAL 303,279 298,127 334,178 388,152 HEALTH ANIMAL CONTROL 155,880 180,754 216,908 230,288 TOTAL HEALTH 155,880 180,754 216,908 230,288 INTERNAL SERVICE INFORMATION TECHNOLOGY 218,843 281,297 377,153 447,831 HUMAN RESOURCES 125,525 124,866 144,838 150,549 FINANCE 185,084 189,701 222,845 254,923 FLEET SERVICE 158,248 179,388 192,545 207,864 TOTAL INTERNAL SERVICE 687,700 775,252 937,381 1,061,167 MISCELLANEOUS CITIZENS ASSISTANCE 11,000 5,000 10,000 10,000 TOTAL MISCELLANEOUS 11,000 5,000 10,000 10,000 TOTAL EXPENDITURES 7,184,€337 7,992,266 9,303,435 10,576,517 C: CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED REVENUES Taxes 000 - 411100 Advalorem Tax - Current 3,140,463 3,252,597 3,650,000 4,042,325 000 - 411200 Advalorem Tax - Delinquent 43,197 40,147 40,500 45,000 000 - 411300 Advalorem Tax - P &I 32,203 25,876 25,000 25,000 000 - 411400 Roll Back Property Tax - 28,048 10,000 - 000- 411500 Sales Tax Revenue - Gen. Fund 1,487,282 1,703,995 2,020,000 2,300,000 000 - 411600 Bingo Tax 4,528 4,749 4,500 4,700 000 - 411700 Mixed Beverage 4,243 5,064 5,000 6,000 Total Taxes 4,711,916 5,060,476 5,755,000 6,423,025 Franchises 000 - 421200 Center Point/Entex Energy 12,774 16,942 17,498 18,000 000 - 421220 City Public Service 75,949 89,693 100,000 120,000 000 - 421240 Guadalupe Valley Elec Co -op 294,145 247,312 250,000 270,000 000 - 421300 Time Warner /Paragon Cable 92,159 178,505 180,000 205,000 000 - 421440 Southwestern Bell Telephone 60,185 61,776 63,000 62,000 000 - 421460 AT &T Franchise Fee 5,149 3,975 5,000 4,000 000 - 421480 Other Telecom Franchise 16,814 13,438 14,000 10,000 000 - 421500 Solid Waste Franchise Fee 41,361 39,988 50,720 51,000 Total Franchises 598,536 651,629 680,218 740,000 Permits 000 - 431100 Home Occupation Permit 125 130 300 300 000 - 431200 Building Permit 360,168 334,928 380,000 381,000 000 - 431300 Mobile Home Permit 160 200 300 300 000 - 431400 Signs Permit 982 925 1,000 1,000 000 - 431500 Food Establishment Permit 27,295 22,900 22,000 13,000 000 - 431600 Garage Sale Permit 7,550 8,361 7,000 6,500 000 - 431700 Plumbing Permit 58,309 51,276 50,000 55,000 000 - 431750 Electrical Permit 36,442 36,554 40,000 45,000 000 - 431800 Mechanical Permit 21,053 21,839 20,000 20,000 000 - 431900 Solicitor /Peddler Permit 485 550 600 500 000 - 431950 Animal /Pet Permit 895 1,000 1,000 1,000 000 - 432000 Certificate of Occupancy Permit 610 570 1,000 1,000 000 - 432100 Security Alarm Permit 7,291 11,330 8,000 11,000 000 - 435000 Fire Permit - - - 4,800 Total Permits 521,365 490,563 531,200 540,400 7 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Licenses 000 - 441000 Alcohol Beverage License 2,872 2,795 3,000 2,500 000 - 442000 Contractors License 14,300 16,505 15,200 15,000 000 - 443000 Electrical License 13,745 12,580 - - 000- 444000 Pet License 2,315 2,381 2,500 2,500 Total Licenses 33,232 34,261 20,700 20,000 Fees 000 - 451000 Municipal Court Fines 451,795 514,465 562,000 745,000 000 - 451100 Arrest Fee 30,671 30,724 30,000 33,000 000 - 451200 Warrant Fees 63,465 58,115 90,000 80,000 000 - 451400 Traffic Fine Costs TTL 14,951 15,198 14,000 15,000 000 - 451500 Teen Court Admin Fee 860 574 500 500 000 - 451510 Juvenile Case Mgr Fee - - - 44,000 000 - 451600 Technology Fund Fee 26,594 27,422 25,000 27,250 000 - 451700 Security Fee 20,330 20,741 19,000 22,000 000 - 451800 Time Payment Fee - City 1,719 2,417 2,000 2,500 000 - 451850 State Fines 10% Service Fee 31,288 33,051 30,000 35,000 000 - 451900 DPS Payment - Local 5,485 5,290 5,000 6,000 000 - 452000 Child Safety Fee 7,310 6,498 9,000 6,000 000 - 452100 Platting Fees 33,626 39,449 42,000 43,000 000 - 452200 Site Plan Fee 2,300 2,950 8,000 3,000 000 - 452300 Plan Check Fee 165,956 157,259 185,000 190,000 000 - 452320 Tree Mitigation Admin Fee - - - 81,600 000 - 452400 BOA/Zoning Fees 1,900 1,350 1,800 1,200 000 - 452500 Food Handler Class 12,020 12,984 11,000 15,000 000 - 452600 Specific Use /Zone Chng Fee 2,500 3,000 3,000 3,000 000 - 453100 Reinspection Fees 62,823 99,218 85,000 85,000 000 - 453110 Swim Pool Inspection Fee 225 600 75 500 000 - 453200 Mowing Fees - Inspections 2,296 807 1,500 1,800 000 - 453300 Solicitor's Investigation 620 220 1,000 100 000 - 453500 SubContractor Reqistration Fee - - 8,200 10,000 000 - 454100 Swim Pool Reservation Fee 1,880 4,425 3,000 4,000 000 - 454200 Pool Gate Admission Fee 19,155 21,583 19,000 25,000 000 - 454300 Seasonal Pool Pass Fee 5,455 6,050 7,000 7,500 000 - 454400 Swimming Lessons Fee 7,778 15,718 15,000 18,000 000 - 456500 Hazard Material Fee - - - 5,000 000 - 458100 Sale of Merchandise 60 30 300 30 000 - 458300 Sale of Property /Auction 12,573 - 20,000 10,000 000 - 458400 Building Rental Fee 8,022 4,886 5,000 7,000 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 9 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED Fees continued 000 - 458500 Property Rental Fee 4,235 6,253 6,000 5,000 000 - 458600 Ball Field Use - 200 250 200 000 - 458700 Vehicle Impoundment 470 990 500 1,500 000 - 459100 Credit Card /Check Fee (7,854) (493) 1,000 500 000 - 459200 NSF Check Fee 50 170 250 150 000 - 459300 Notary Fee 267 333 200 200 000 - 459400 Maps, Copies, UDC Misc 2,570 1,507 2,000 1,500 000 - 459600 Animal Adoption Fee 16,254 18,592 15,000 12,000 000 - 459700 Pet Impoundment Fee 14,143 14,011 12,000 12,000 000 - 459800 Police Reports Fee 4,554 5,001 5,000 5,000 Total Fees 1,028,346 1,131,588 1,244,575 1,565,030 Fines 000 - 463000 Library Fines 18,943 20,339 19,000 24,000 Total Fines 18,943 20,339 19,000 24,000 Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 13,894 13,725 13,725 13,725 000 - 473200 City of Seguin -Fire Contract 100 - 37,000 37,000 000 - 473300 Guad Co. Library 95,353 112,458 112,500 115,000 000 - 473400 Randolph AFB - Animal Control - 864 850 2,750 000 - 474100 Cibolo Fire Contract 15,000 - - - 000- 474200 Library Services - Cibolo 2,500 - 2,500 2,500 000 - 474400 Dispatch Service - Cibolo 26,300 56,402 81,928 106,081 000 - 474500 Dispatch Service - SCUCISD 1,200 1,200 1,200 1,400 000 - 474600 School Crossing Guard - Bexar - 496 1,181 1,000 Total Inter - Jurisdictional 154,347 185,145 250,884 279,456 Fund Transfers 000 - 480000 Indirect Costs -EMS 573,834 20,833 25,000 50,000 000 - 489010 Indirect Costs -Hotel 2,500 2,000 2,000 2,000 000 - 485000 Interfund Charge- Drainage -3% - - 9,300 10,750 000 - 486000 Interfund Charges - Water - 457,362 344,612 253,153 000 - 487000 Interfund Charges -Fleet - 3,541 54,025 59,516 000 - 488000 Interfund Charges -413 - - 30,000 32,000 Total Fund Transfers 576,334 483,736 464,937 407,419 9 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 10 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Miscellaneous 000 - 491000 Interest Earned 7,924 4,029 5,000 6,000 000 - 491200 Investment Income 61,762 60,286 60,000 140,000 000 - 493400 Donations - Animal Control 1,060 2,573 2,500 3,000 000 - 493401 Donations -A/C Microchip - - - 1,000 000 - 494481 LawEnforcemtOfficersStnd &Ed 4,264 3,121 4,500 3,000 000 - 495014 Matching Funds -Parks - 10,000 10,000 - 000- 497000 Misc Income -Gen Fund 43,321 17,207 25,000 25,000 000 - 497100 Misc Income- Police 3,880 4,517 50,000 44,000 000 - 497200 Misc Income - Library 4,580 4,560 6,000 4,000 000 - 497300 Misc Income - Animal Control 18 55 5,000 20 000 - 497400 Misc Income - Streets Dept 6,595 9,605 5,000 6,000 000 - 497500 Misc Income - TML Insurance - 12,667 5,000 50,000 000 - 498000 Reimbursement -Gen Fund (1,276) 3,719 15,000 - 000- 499000 Transfer from Reserves - - 201,500 71,000 000 - 499050 Transfer from Equip Res (IT) - - - 79,072 000 - 499100 Transfer -Court Tech. Reserve - - 29,000 12,045 000 - 499150 Transfer -Court Security Reserve - 28,093 000 - 499200 Transfer - Vehicle Replace Res. - - - 135,800 Total Miscellaneous 132,128 132,339 423,500 608,030 TOTAL REVENUES 7,775,147 8,190 „076 9,390,014, 10,607,360 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 Government. 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 2005 -2006 101GENERALFUND 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 CITY COUNCIL BUDGET APPROVED GENERAL GOVERNMENT 11,377 7,829 10,044 10,650 12,650 EXPENDITURES CITY COUNCIL Supplies 150 - 521100 Office Supplies 184 21 50 - Total Supplies 184 21 50 - City Support Services 150 - 532600 City Elections 150 - 532800 Special Events Total City Support Services Staff Support 150 - 535200 Annual Awards 150 - 535300 Memberships 150 - 535500 Training/Travel Total Staff Support 4,068 2,048 5,371 9,329 9,439 11,377 6,000 9,000 2,550 2,950 8,550 11,950 - - 150 150 3,956 5,390 5,500 5,500 3,873 4,654 5,000 7,000 7,829 10,044 10,650 12,650 TOTAL CITY COUNCIL 17,452 21,442 19,250 24,600 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, and 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 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES CITY MANAGER Personnel Services 151 - 511110 Regular 201,917 237,123 239,230 231,804 151- 511120 Overtime 167 - - - 151- 511180 LTD 514 659 683 639 151 - 511210 Longevity 5,568 8,496 7,212 4,848 151 - 511124 Vehicle Allowance 9,427 10,874 10,800 14,400 151 - 511310 FICA - Employer 16,252 18,556 19,331 18,104 151- 511350 TMRS - Employer 14,466 17,915 21,654 21,637 151 - 511410 Health - Employer 10,373 14,896 15,388 12,325 151 - 511500 Workers Compensation 603 597 890 549 Total Personnel Services 259,287 309,116 315,188 304,306 Supplies 151- 521100 Office Supplies 1,986 1,494 1,700 300 Total Supplies 1,986 1,494 1,700 300 City Support Service 151- 532800 Special Events 577 563 3,000 - Total City Support Service 577 563 3,000 - Staff Support 151 - 535100 Uniforms 216 218 200 500 151 - 535200 Annual Awards 1,241 3,078 4,500 4,500 151- 535300 Memberships 1,276 1,346 3,200 3,200 151 - 535400 Publications 230 347 400 400 151 - 535500 Training/Travel 8,048 9,706 10,000 10,000 151 - 535600 Professional Certification 71 - 250 250 Total Staff Support 11,082 14,695 18,550 18,850 Operating Equipment 151 -57100 Furniture & Fixtures 1,185 2,153 1,386 - Total Operating Equipment 1,185 2,153 1,386 - TOTAL CITY MANAGED 273,540 327,458, 339,824 323,456 14 V"I CITY OF SCHERTZ COMMENTARY DEPARTMENT: COURT SUPPORT FUNCTION: The purpose of the Court Support Department is to assist the judge, warrant officers, and prosecutor in the administration of justice. This department is responsible for accepting and processing all "Class C Misdemeanor" complaints filed by a variety of internal and external sources. 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 2005 -2006 101GENERALFUND 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED GENERAL GOVERNMENT Publications 152 - 535500 Training /Travel 152 - 535600 EXPENDITURES Total Staff Support 100 50 COURT SUPPORT 2,616 2,978 Personnel Services 152- 511110 Regular 144,001 151,657 183,467 98,417 152 - 511120 Overtime 2,187 1,360 2,000 2,500 152 - 511180 LTD 353 412 507 270 152- 511210 Longevity 4,488 1,080 1,680 600 152 - 511230 Certification Allowance 485 310 484 600 152 - 511240 Vehicle Allowance 2,400 2,483 2,400 - 152- 511310 FICA - Employer 11,553 11,357 14,359 7,659 152 - 511350 TMRS - Employer 10,414 10,730 17,617 9,153 152 - 511410 Health - Employer 15,575 19,458 23,082 16,432 152 - 511500 Workers Compensation 644 788 2,377 232 Total Personnel Services 192,100 199,635 247,973 135,863 Supplies 152- 521100 Office Supplies 629 892 2,200 1,500 152- 521600 Equip Maint Supplies 2,350 211 700 1,000 Total Supplies 2,979 1,103 2,900 2,500 Utility Services 152 - 533500 Vehicle Fuel Total Utility Services Operations Support 152 - 534200 Printing & Binding Total Operations Support Staff Support 152 - 535100 Uniforms 152 - 535300 Memberships 152 - 535400 Publications 152 - 535500 Training /Travel 152 - 535600 Professional Certifications Total Staff Support 16 1,286 1,266 350 1,286 1,266 350 836 1,803 2,950 6,000 836 1,803 2,950 6,000 109 597 150 184 124 100 465 631 500 402 1,164 2,178 150 100 50 1,310 2,616 2,978 250 250 2,000 100 2,600 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 101GENERALFUND 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED Court Support 152 - 536400 Collection Expense 715 104 - - 152- 536500 Court/Jury Cost 42 - 1,600 1,600 Total Court Support 757 104 1,600 1,600 Professional Services 152 - 541300 Other Consul /Prof Service Total Professional Services Operating Equipment 152 - 571000 Furniture & Fixtures 152- 571300 Computer & Peripherals Total Operating Equipment Capitalized Equipment 152 - 581400 Communications Equipment Total Capitalized Equipment 5,100 4,800 7,500 5,500 5,100 4,800 7,500 5,500 199 - - 7,223 6,750 - 7,422 6,750 - 59 6,259 - 59 6,259 - TOTAL COURT SUPPORT 211,849 224,336 266,251 154,063 17 I ON L. L Y L, I - I �' V 11) 1 N k'. CITY OF SCHERTZ COMMENTARY DEPARTMENT: MUNICIPAL COURT FUNCTION: The ultimate purpose of the Schertz Municipal Court is to administer justice at the municipal level. This department is responsible for adjudicating all "Class C Misdemeanor" complaints filed by a variety of internal and external sources that occur within the territorial jurisdiction of the City of Schertz. In addition, this department is also responsible for maintaining court security as well as the execution of warrants for failure to appear, capias pro fines and court summons. im CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES MUNICIPAL COURT Personnel Services 169-511110 Regular - - 25,966 153,275 169- 511120 Overtime - - 500 2,000 169 - 511180 LTD - - 42 417 169- 511210 Longevity - - - 1,152 169- 511220 Clothing Allowance - - 1,200 1,040 169 - 511230 Cerfication Allowance - 390 169 - 511240 Vehicle Allowance - - - 2,400 169- 511310 FICA - Employer - - 2,019 11,814 169- 511350 TMRS - Employer - - 2,233 14,118 169 - 511410 Health - Employer - - 1,929 12,324 169- 511500 Workers Compensation - - 1,115 2,754 Total Personnel Services - - 35,004 201,684 Supplies 169- 521100 Office Supplies - - 800 1,000 169 - 521600 Equip Maint Supplies - - 2,860 3,105 Total Supplies - - 3,660 4,105 City Support Services 169 - 532800 Special Events - - 2,000 3,000 Total City Support Services - - 2,000 3,000 Utilitv Services 169 - 533500 Vehicle Fuel - - 2,350 3,000 Total Utility Services - - 2,350 3,000 Operations Support 169 - 534200 Printing & Binding - - 1,500 750 Total Operations Support - - 1,500 750 19 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 101 GENERAL FUND 2002 -2003 2003 -2004 2004 -2005 ACTUAL ACTUAL BUDGET CITY COUNCIL APPROVED Staff Support 169 - 535100 Uniforms - - 150 2,500 169 - 535300 Memberships - - 350 750 169 - 535400 Publications - - 1,000 1,500 169 - 535500 Training/Travel - - 2,984 4,375 Total Staff Support - - 4,484 9,125 Professional Services 169 - 541300 Other Consul /Prof Service - - 500 7,000 Total Professional Services - - 500 7,000 Operating Equipment 169 - 571300 Computer & Peripherals - - 25,000 12,045 Total Operating Equipment - - 25,000 12,045 Capitalized Equipment 169- 581200 Vehicles - - 23,578 - 169- 581400 Communications Equipment - - 2,500 7,105 Total Capitalized Equipment - - 26,078 7,105 TOTAL MUNICIPAL COURT NEW DEPARTMENT . 100,576 247,814 20 THIS PAGE INTENTIONALLY LEFT BLANK CITY OF SCHERTZ COMMENTARY DEPARTMENT: PLANNING AND ZONING FUNCTION: Administer the Unified Development Code (UDC), Comprehensive Land Plan, Overlay Districts, Annexation, urban planning policy programs, prepare and implement planning - related policy and assist with FEMA Hazard Mitigation. Assist the public and the development customer as well as internal customer with land use process and policy. To provide professional staff analysis, recommendation, and support to the Planning and Zoning Commission, Board of Adjustment, ad hoc ordinance review committees, the City Manager's Office, the City Secretary's Office, and the City Council. 21 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES PLANNING AND ZONING Personnel Services 154 - 511110 Regular 59,601 129,888 99,072 132,513 154 - 511120 Overtime 2,468 3,278 5,040 3,153 154 - 511180 LTD 134 356 275 372 154- 511210 Longevity 600 840 912 1,164 154 - 511310 FICA - Employer 4,729 10,074 7,801 10,528 154-511350 TMRS - Employer 3,988 9,240 10,242 11,640 154-511410 Health - Employer 5,594 13,221 9,623 12,325 154 - 511500 Workers Compensation 216 300 355 298 Total Personnel Services 77,330 167,197 133,320 171,993 Supplies 154 - 521000 Operating Supplies 137 405 720 2,600 154 - 521100 Office Supplies 2,138 2,321 2,800 2,350 154- 521600 Equipment Supplies - - 200 1,300 Total Supplies 2,275 2,726 3,720 6,250 City Support Services 154 - 532800 Special Events 439 794 - 800 Total City Support Services 439 794 - 800 Operations Support 154- 534200 Printing & Binding 527 240 - 1,000 Total Operations Support 527 240 - 1,000 Staff Support 154 - 535100 Uniforms 64 102 120 210 154 - 535300 Memberships 460 2,707 916 3,119 154- 535400 Publications 84 674 600 1,825 154 - 535500 Training/Travel 9,615 14,396 7,500 16,140 Total Staff Support 10,223 17,879 9,136 21,294 22 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED Professional Services 154 - 541300 Engineering Services 154- 541500 State /County Admin Fees Total Professional Services Rental -Lease 154 - 461200 Lease /purchase agmts Total Rental -Lease 41,143 71,033 844 2,141 41,987 73,174 .1 111 62,000 3,000 65,000 3,468 - - - 3,468 TOTAL PLANNING B ZONING 132,781 262,010 206,176 269,805 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. ME CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND 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 13,017 16,262 12,500 12,500 13,017 16,262 12,500 12,500 75,712 166,653 135,000 175,000 75,712 166,653 135,000 175,000 TOTAL LEGAL SERVICES 88,729 182,915 147,500 187,500' 25 THIS PAGE INTENTIONALLY LEFT 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. ft. consisting of 23,406 sq. ft. carpet, 27,310 sq. ft. the 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. c CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERALFUND EXPENDITURES FACILITY MAINTENANCE Personnel Services 161 - 511110 Regular 126,061 147,479 154,298 164,976 161 - 511120 Overtime 11,698 4,020 4,700 6,277 161 - 511180 LTD 325 404 446 465 161- 511210 Longevity 5,376 6,096 6,228 6,900 161 - 511310 FICA - Employer 10,184 10,842 12,624 13,129 161- 511350 TMRS - Employer 9,826 10,429 14,084 15,716 161 - 511410 Health - Employer 16,042 22,345 23,082 25,676 161 - 511500 Workers Compensation 6,154 5,308 7,820 5,250 Total Personnel Services 185,666 206,923 223,282 238,389 Supplies 161 - 521000 Operating Supplies 15,257 15,471 19,665 25,665 161 - 521100 Office Supplies 656 677 900 24,900 161 - 521200 Medical /Chemical Supplies 3,468 3,223 4,600 4,600 161 - 521300 Motor Veh. Supplies 365 200 550 550 161 - 521600 Equip Maint Supplies 3,700 294 300 300 Total Supplies 23,446 19,865 26,015 56,015 Utilitv Services 161 - 533100 Gas Utility Service - 122 300 500 161 - 533200 Electric Utility Service 36,370 34,621 32,000 32,000 161 - 533300 Telephone Utility Service 2,751 - - - 161- 533410 Water Utility Service 3,186 3,820 3,700 3,700 161 - 533500 Vehicle Fuel 2,924 3,551 3,800 3,800 Total Utility Services 45,231 42,114 39,800 40,000 Operations Support 161- 534000 Postage 90 115 - - 161- 534200 Printing & Binding - 85 100 100 Total Operations Support 90 200 100 100 27 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED Staff Support 161 - 535100 Uniforms 161- 535210 Employee Recognition 161 - 535300 Memberships 161 - 535400 Publications 161- 535500 Training /Travel Total Staff Support Maintenance Services 161 - 551100 Building Maintenance 161 - 551400 Minor & Other Equip Maint 161 - 551700 Ground Maintenance 161 - 551800 Other Maint. Agreement Total Maintenance Services Rental -Lease 161 - 561100 Rental Equipment Total Rental -Lease Operating Equipment 161 - 571500 Operating Equipment Total Operating Equipment 2,516 2,434 2,980 3,451 - - - 500 149 131 150 150 253 253 275 275 863 346 2,198 2,198 3,781 3,164 5,603 6,574 39,952 37,326 39,000 40,000 800 663 550 550 - 1,344 2,600 1,000 8,661 8,709 7,200 7,500 49,413 48,042 49,350 49,050 479 433 750 750 479 433 750 750 2,616 - 3,000 1,098 2,616 - 3,000 1,098 TOTAL FACILITY MAINTENANCE 310,722 320,741 347,900 391,976 . THIS PAGE INTENTIONALLY LEFT 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 Council meetings and workshops, take and transcribe minutes from such meetings and post agendas for all Council meetings, workshops and meetings held by other boards and commissions. Responsible for document imaging of Ordinances and working toward imaging Resolutions, Minutes, etc. The department works closely with the Departmental Records Liaison for records retention and destruction. Attend annual Election Law Seminars to maintain currency with the Election Laws. 29 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES CITY SECRETARY Personnel Services 164- 511110 Regular 77,496 81,338 148,348 79,134 164- 511120 Overtime 98 - - - 164 - 511180 LTD 183 217 402 217 164- 511210 Longevity 3,408 3,756 6,540 1,056 164 - 511310 FICA - Employer 6,103 6,237 11,849 6,135 164- 511350 TMRS - Employer 5,564 5,961 13,101 7,332 164- 511410 Health - Employer 6,244 7,737 13,470 8,216 164- 511500 Workers Compensation 246 204 546 186 Total Personnel Services 99,342 105,450 194,256 102,276 Supplies 164 - 521000 Operating Supplies - - 150 - 164- 521100 Office Supplies 4,992 3,678 5,500 1,500 164 - 521200 Medical /Chem Supplies - - 400 - Total Supplies 4,992 3,678 6,050 1,500 City Support Services 164 - 532500 City Insurance - - - - 164 - 532700 Records Management 7,000 5,600 12,000 2,500 Total City Support Services 7,000 5,600 12,000 2,500 Operations Support 164 - 534000 Postage 497 360 - - 164- 534200 Printing & Binding 3,254 462 2,000 200 Total Operations Support 3,751 822 2,000 200 Staff Support 164- 535100 Uniforms - - 160 140 164 - 535300 Memberships 375 445 600 500 164 - 535400 Publications 55 120 325 200 164 - 535500 Training/Travel 3,021 2,487 3,700 5,000 Total Staff Support 3,451 3,052 4,785 5,840 30 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Operating Equipment 164 - 571000 Computer /Peripherals - - 5,173 - Total Operating Equipment - - 5,173 - Capital Outlay 164- 581400 Equipment - - 1,327 - Total Capital Outlay - - 1,327 - TOTAL CITY SECRETARY 118,536 118,602 225,591 112,316 31 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 Audit cost, City Insurance, Appraisal District contract, and Medical Services. Additionally this account contains provisions for contingency funds. 32 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 101 GENERAL FUND 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED GENERAL GOVERNMENT EXPENDITURES NONDEPARTMENTAL City Support Services 167 - 532200 County Appraisal District 68,425 55,804 65,000 65,000 167 - 532500 City Ins -Com 71,245 101,938 80,000 120,000 167 - 532900 Contingencies 1,341 13,218 25,000 25,000 Total City Support Services 141,011 170,960 170,000 210,000 Operations Support 167- 534000 Postage - - 31,700 31,000 167 - 534300 Copy Services - 23,811 27,000 30,968 167- 534600 Annexation Costs - 47,157 20,000 - Total Operations Support - 70,968 78,700 61,968 City Assistance 167 - 537100 Medical Services 142,894 151,800 184,800 280,000 Total City Assistance 142,894 151,800 184,800 280,000 Professional Services 167 - 541400 Auditor /Accounting Sery 7,256 37,750 20,000 30,000 167 - 541500 State /County & Admin Fees 5,389 2,483 2,500 2,600 167 - 541600 Miscellaneous Bank Charges 9,772 6,005 6,000 6,000 Total Professional Services 22,417 46,238 28,500 38,600 Fund Charges /Transfers 167 - 548106 Transfer to Special Event Fd - - 6,500 6,500 Total Transfers - - 6,500 6,500 TOTAL NONDEPARTMENTAL 306,322 439,966 468,500 :. 597,068 33 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 crisis 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. 34 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 101 GENERAL FUND 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED GENERAL GOVERNMENT EXPENDITURES PUBLIC INFORMATION Personnel Services 170 - 511110 Regular 36,247 34,446 39,907 39,255 170 - 511180 LTD 89 92 108 106 170 - 511210 Longevity - 120 - - 170- 511310 FICA - Employer 3,002 2,620 3,053 3,003 170 - 511350 TMRS - Employer 2,568 2,356 3,375 3,589 170 - 511410 Health - Employer 3,239 3,409 3,847 4,108 170 - 511500 Workers Compensation 124 94 140 91 Total Personnel Services 45,269 43,137 50,430 50,152 Supplies 170 - 521100 Office Supplies 993 820 851 2,000 Total Supplies 993 820 851 2,000 Operations Support 170- 534100 Advertising 1,841 1,152 500 10,000 170 - 534200 Printing & Binding 8,180 12,065 14,000 9,000 Total Operations Support 10,021 13,217 14,500 19,000 Staff Support 170 - 535100 Uniforms 58 34 75 400 170 - 535300 Memberships 470 478 500 500 170- 535400 Publications 1,064 151 300 300 170 - 535500 Training /Travel 1,320 1,184 2,500 3,500 170 - 535600 Professional Certification 14 - 500 - Total Staff Support 2,926 1,847 3,875 4,700 Professional Services 170 - 541300 Other Consult/Prof Srvcs - 971 500 - Total Professional Services - 971 500 - 35 CITY OF SCHERTZ COMMENTARY DEPARTMENT: RECORDS MANAGEMENT FUNCTION: The Records Management Officer and full -time clerk have been removed from the City Secrtary's Department for 2005 -2006. The functions include maintaining the City's Record Management Program in accordance with the City Ordinance and State mandates. Maintain 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. 36 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES RECORDS MANAGEMENT Personnel Services 171 - 511110 Regular - - - 74,914 171 - 511120 Overtime - - - _ 171- 511180 LTD - - - 212 171- 511210 Longevity - - - 3,444 171 - 511310 FICA - Employer - - - 5,994 171 - 511350 TMRS - Employer - - - 7,164 171 - 511410 Health - Employer - - - 8,216 171 - 511500 Workers Compensation - - - 182 Total Personnel Services - - - 100,126 Supplies 171 - 521000 Operating Supplies - - - 675 Total Supplies - - - 675 Staff Support 171 - 535100 Uniforms - - - 140 171 - 535300 Memberships - - - 400 171 - 535500 Training/Travel - - - 1,530 Total Staff Support - - - 2,070 TOTAL RE ORD MANAGEMENT » NEW DEPARTMENT 102,871 37 CITY OF SCHERTZ COMMENTARY DEPARTMENT: POLICE FUNCTION: The Department provides community based law enforcement committed to the prevention of crime, protection of life and property while remaining sensitive and impartial to the citizens they serve. PROGRAM MEASUREMENT: The uniform patrol division is expected to answer in excess of 16,000 calls for service in 2004/2005 fiscal year while striving to maintain a response time averaging 4.00 minutes. Officers will generate 7,000 to 8,000 field generated calls and will average around 14,000 citations issued. In fiscal year 2005/2006 this activity will increase another 10 to 15 % depending on the growth of the community and the demand for police services will increase accordingly. 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. PROGRAM COMMENTS: Due to the increase in population, call volume and the overall demand for services, the department's overall goal is to reduce crime by 2% and or to remain stable. Due to the economic conditions, prices of such things as gasoline continue to escalate. As growth continues traffic congestion will increase, and our goal is to try to reduce alcohol and injury accidents by 10 to 15 %, through implementation of high visibility on the main highways and by participation in programs such as Selective Traffic Enforcement Program (S.T.E.P.). CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES POLICE Personnel Services 256- 511110 Regular 1,411,207 1,521,246 1,688,146 2,003,374 256- 511120 Overtime 28,461 21,041 20,000 63,800 256- 511180 LTD 3,533 4,262 4,675 5,520 256- 511210 Longevity 37,380 41,580 46,380 48,960 256- 511220 Clothing Allowance 46,202 45,419 45,430 48,940 256- 511230 Certification Allowance 8,470 9,264 10,541 21,369 256- 511310 FICA - Employer 114,953 123,355 134,311 158,683 256- 511350 TMRS - Employer 102,694 109,788 155,349 186,933 256- 511410 Health - Employer 142,332 174,958 192,348 209,518 256- 511500 Workers Compensation 42,648 38,362 53,209 42,720 Total Personnel Services 1,937,880 2,089,275 2,350,389 2,789,817 Supplies 256- 521000 Operating Supplies 11,527 13,121 6,477 18,000 256- 521100 Office Supplies 4,267 3,637 3,500 1,000 256- 521300 Motor Veh. Supplies 979 465 518 650 256- 521600 Equip Maint Supplies 1,283 - 500 550 Total Supplies 18,056 17,223 10,995 20,200 City - Support Services 256- 532500 City- Insurance -Comm. - 17,590 18,000 23,000 Total City Support Services - 17,590 18,000 23,000 Utility Services 256- 533100 Gas Utility Service 469 941 - - 256- 533200 Electricity Utility Service 22,494 25,380 - - 256- 533410 Water Utility Service 3,853 2,004 - - 256- 533500 Vehicle Fuel 40,874 47,859 50,000 53,400 Total Utility Services 67,690 76,184 50,000 53,400 39 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 101 GENERAL FUND 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 Sery Total Professional Services 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED 1,173 1,521 - - - - 128 200 2,412 1,787 1,362 1,200 3,585 3,308 1,490 1,400 - 200 472 500 516 502 875 930 395 967 438 1,500 9,547 6,833 12,000 13,000 - 3,211 4,500 3,000 10,458 11,713 18,285 18,930 1,435 2,300 3,996 3,800 162 89 200 1,000 618 1,316 1,282 9,258 2,215 3,705 5,478 14,058 9,534 2,300 1,600 600 9,534 2,300 1,600 600 Maintenance Services 256- 551400 Minor & Other Equip. Maint 1,417 256- 551800 Other Maintenance Agrmt 7,023 Total Maintenance Services 8,440 Rental -Lease 256- 561100 Rental- Equipment 256- 561200 Lease /Purchase Pmts Total Rental -Lease Operating Equipment 256- 571000 Furniture & Fixtures Total Operating Equipment 3,285 6,862 6,500 7,653 8,450 11,500 10,938 15,312 18,000 5,403 5,253 - - 3,031 2,165 500 - 8,434 7,418 500 - 902 1,808 1,000 1,000 902 1,808 1,000 1,000 He] CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED Capitalized Equipment 256- 581200 Motor Vehicles 192,519 45,848 - 81,600 256- 581400 Communications Equip 2,578 1,707 - - 256- 581800 Other Equipment 6,253 4,081 - 39,355 Total Capitalized Equipment 201,350 51,636 - 120,955 TOTAL POLICE 2,268,544 2,293,098 2,473,049 3,061,360 41 THIS PAGE INTENTIONALLY LEFT BLANK CITY OF SCHERTZ COMMENTARY DEPARTMENT: FIRE FUNCTION: Established in 1956 as a volunteer fire department. Today, the department has 27 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, emergency management 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 call volume is up by 13% over the last three years which is directly related to the growth in the area. However, value of the property loss is less serious, and we have not had any life loss in the last five years, due to good fire prevention efforts 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. lar: CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES FIRE Personnel Services 257 - 511110 Regular 782,607 836,271 1,011,744 257 - 511120 Overtime 21,665 30,109 49,000 257 - 511180 LTD 1,919 2,330 3,034 257 - 511210 Longevity 13,860 14,460 17,184 257 - 511122 Clothing Allowance 30,661 7,712 9,372 257 - 511230 Certification Allowance - - 5,005 257 - 511310 FICA - Employer 61,196 65,986 84,511 257 - 511350 TMRS - Employer 56,137 60,465 96,450 257 - 511410 Health - Employer 72,773 89,025 119,256 257 - 511500 Workers Compensation 18,655 14,692 27,683 Total Personnel Services 1,059,473 1,121,050 1,423,239 Supplies 257 - 521000 Operating Supplies 4,000 3,742 1,698 257 - 521100 Office Supplies 1,795 2,030 2,250 257 - 521200 Medical /Chemical Supplies 8,168 8,044 9,365 257 - 521300 Motor Veh. Supplies 1,231 346 500 257 - 521600 Equip Maint Supplies 2,305 1,856 2,000 Total Supplies 17,499 16,018 15,813 Utilitv Services 257 - 533100 Gas 1,604 1,645 1,100 257 - 533200 Electricity 12,533 15,031 7,800 257 - 533410 Water Utility Service 2,810 2,007 1,900 257 - 533500 Vehicle Fuel 9,385 9,500 9,000 Total Utility Services 26,332 28,183 19,800 Operations Support 257 - 534000 Postage 122 148 - 257- 534200 Printing & Binding 238 347 400 257 - 534300 Copy Services 1,647 - - Total Operations Support 2,007 495 400 43 1,194, 531 49,000 3,313 20,616 9,360 93,864 112,182 131,462 22,221 1,636,549 2,000 250 6,734 500 2,000 11,484 1,100 7,800 1,900 10,450 21,250 400 400 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101GENERALFUND ACTUAL ACTUAL BUDGET APPROVED Staff Support 257 - 535000 Uniforms - 20,176 25,184 21,550 257 - 533530 Memberships 1,348 1,930 1,842 2,035 257 - 535400 Publications 807 1,203 1,565 6,635 257 - 535500 Training /Travel 20,116 13,922 17,050 22,400 257 - 535600 Professional Certifications 630 1,087 1,472 2,060 Total Staff Support 22,901 38,318 47,113 54,680 City Assistance - - - - 257 - 537800 Crime /Fire Prevention 18,326 7,041 10,050 10,000 Total City Assistance 18,326 7,041 10,050 10,000 Maintenance Services - 11,823 3,150 2,345 257 - 551400 Minor & Other Equip Maint 3,343 3,037 3,350 3,500 Total Maintenance Services 3,343 3,037 3,350 3,500 Rental -Lease 257 - 561200 Lease /Purchase Payments 2,311 2,999 2,880 2,880 Total Rental -Lease 2,311 2,999 2,880 2,880 Operating Equipment 257 - 571000 Furniture /Fixture 348 - 2,100 300 Total Operating Equipment 348 - 2,100 300 Capitalized Equipment 257 - 581200 Motor Vehicle - - - - 257 - 581300 Police /Fire /Medical Equip. 24,548 - 2,500 7,550 257 - 581400 Communications Equipment 4,875 2,185 2,400 - 257- 581800 Other Equipment - 11,823 3,150 2,345 Total Capitalized Equipment 29,423 14,008 8,050 9,895 TOTAL., FIRE 1,181,963 1,231,149 1,532,795 1,750,938 ' CE, I THIS PACE INTENTIONALLY LEFT 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 concerning 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. 45 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES INSPECTIONS Personnel Services 258 - 511110 Regular 163,363 167,435 204,059 211,058 258 - 511120 Overtime 1,115 690 1,500 1,500 258 - 511180 LTD 382 451 511 593 258 - 511210 Longevity 6,204 6,636 7,428 8,736 258 - 511310 FICA - Employer 12,266 12,567 14,466 16,814 258 - 511350 TMRS - Employer 11,545 12,049 16,759 20,096 258 - 511410 Health - Employer 19,008 22,362 23,082 24,649 258 - 511500 Workers Compensation 1,381 1,113 1,625 1,578 Total Personnel Services 215,264 223,303 269,430 285,024 Supplies 258 - 521000 Operating Supplies 3,974 4,037 4,350 4,350 258 - 521200 Medical Supplies - 384 500 50 258 - 521600 Equip Maint Supplies 799 2,358 2,000 1,400 Total Supplies 4,773 6,779 6,850 5,800 Utility Services 258 - 533500 Vehicle Fuel 2,425 2,957 2,400 3,240 Total Utility Services 2,425 2,957 2,400 3,240 Operations Support 258 - 534000 Postage 1,333 1,311 - - 258- 534100 Advertising - 183 500 500 258 - 534200 Printing & Binding 1,825 1,313 1,700 1,700 Total Operations Support 3,158 2,807 2,200 2,200 Staff Support 258 - 535100 Uniforms 1,761 1,635 2,120 2,120 258 - 535300 Memberships 280 370 525 750 258 - 535400 Publications 2,070 626 2,150 1,400 258 - 535500 Training /Travel 2,790 3,782 6,000 5,715 258 - 535600 Professional Certifications 150 251 250 700 Total Staff Support 7,051 6,664 11,045 10,685 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED City Assistance 258 - 537100 Medical Services - - 500 500 Total City Assistance - - 500 500 Professional Services 258 - 541300 Other Consult/Prof Service 31,142 30,936 35,689 40,489 Total Professional Services 31,142 30,936 35,689 40,489 Maintenance Services 258 - 551700 Lot Cleaning 1,105 1,382 2,500 2,500 258 - 551800 Other Maint. Agreement - - 100 - Total Maintenance Services 1,105 1,382 2,600 2,500 Capital Outlay 258 - 581200 Motor Vehicles 13,896 - 19,950 - Total Capital Outlay 13,896 - 19,950 - TOTAL INSPECTIONS 278,814 274,828 350,664 350,438 47 THIS PAGE INTENTIONALLY LEFT BLANK CITY OF SCHERTZ COMMENTARY DEPARTMENT: STREETS FUNCTION: To provide a means for transportation between the home, work place, recreational facilities and commercial establishments. Insuring the municipal roadways are sanitary and without excess debris. Establishing 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 city. 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 City sponsored clean up approximately six weeks a year, full time street sweeping, traffic sign repair. CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 101 GENERAL FUND PUBLIC ENVIRONMENT EXPENDITURES STREETS Personnel Services 359 - 511110 Regular 359 - 511120 Overtime 359 - 511180 LTD 359 - 511210 Longevity 359 - 511230 Certification Allowance 359-511310 FICA - Employer 359 - 511350 TMRS - Employer 359 - 511410 Health - Employer 359 - 511500 Workers Compensation Total Personnel Services Supplies 359 - 521000 359 - 521100 359 - 521200 359 - 521300 Total Sup Operating Supplies Office Supplies Medical /Chemical Supplies Motor Vehicle Supplies plies 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 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED 182,692 192,422 250,554 282,914 2,648 2,717 5,000 5,000 437 519 708 784 9,732 6,024 6,275 7,068 - - - 300 14,064 14,500 20,034 22,207 13,408 13,819 23,025 26,540 26,328 32,914 42,317 45,190 18,889 22,286 27,702 19,722 268,198 285,201 375,615 409,725 4,066 2,283 2,500 2,500 712 773 700 100 2,499 1,107 1,500 1,500 367 752 700 700 7,644 4,915 5,400 4,800 185 127 - - 27,180 38,269 35,000 35,000 521 1,349 900 900 18,636 18,602 21,500 18,000 46,522 58,347 57,400 53,900 - - 250 1,960 - - 250 1,960 49 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Staff Suaport 359 - 535100 Uniforms 5,712 4,693 5,500 5,500 359 - 535200 Annual Awards - - - 100 359 - 535300 Memberships - 14 170 180 359 - 535500 Training /Travel 92 1,418 1,500 1,500 359 - 535600 Professional Certifications - - 300 300 Total Staff Support 5,804 6,125 7,470 7,580 Professional Services 359 - 541100 Engineering Services 7,411 4,285 61,300 18,000 Total Professional Services 7,411 4,285 61,300 18,000 Maintenance Services 359 - 551100 Building Maintenance - 545 1,000 1,000 359 - 551400 Minor & Other Equip. Maint. - 558 1,000 1,000 359 - 551600 Street Maintenance 75,037 85,181 74,300 150,000 Total Maintenance Services 75,037 86,284 76,300 152,000 Rental -Lease 359 - 561100 Rental Equipment 399 2,232 2,000 2,000 359 - 561200 Lease /Purchase Payments 321 152 84 - Total Rental -Lease 720 2,384 2,084 2,000 Capitalized Equipment 359 - 581800 Other Equipment 16,495 4,709 31,500 5,000 Total Capitalized Equipment 16,495 4,709 31,500 5,000 TOTAL STREETS 427,831 452,250' 617,319' 654,965 50 THIS PAGE INTENTIONALLY LEFT 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. 51 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PARKS & RECREATION EXPENDITURES PARKS Personnel Services 460- 511110 Regular 127,123 260,792 207,133 223,991 460- 511120 Overtime 5,035 9,440 3,000 3,500 460- 511180 LTD 282 537 585 626 460- 511210 Longevity 4,500 6,012 6,816 7,752 460- 511240 Vehicle Allowance - 1,552 1,500 1,500 460- 511310 FICA - Employer 9,918 20,629 16,564 17,728 460- 511350 TMRS - Employer 9,281 14,494 18,613 21,188 460- 511410 Health - Employer 13,082 25,371 26,929 28,757 460- 511500 Workers Compensation 3,709 4,829 4,514 3,311 Total Personnel Services 172,930 343,656 285,654 308,353 Supplies 460- 521000 Operating Supplies 3,805 9,007 10,000 10,000 460- 521100 Office Supplies 363 579 500 500 460- 521200 Medical /Chemical Supplies - 12,897 2,000 2,200 460- 521400 Plumbing Supplies 545 1,699 5,000 3,000 460- 521600 Equip Maint Supplies 346 980 - - Total Supplies 5,059 25,162 17,500 15,700 Utility Services 460- 533200 Electric Utility Service 11,963 25,792 15,000 26,000 460- 533410 Water Utility Service 13,275 21,904 15,000 24,000 460- 533500 Vehicle Fuel 3,837 3,367 3,000 4,500 Total Utility Services 29,075 51,063 33,000 54,500 Operations Support 460- 534000 Postage 78 156 - - 460- 534200 Printing & Binding 20 91 200 500 Total Operations Support 98 247 200 500 52 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 101 GENERAL FUND 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 Building Maintenance 460- 551400 Minor & Other Equip Maint. 460- 551500 Water & Sewer Maint. 460- 551600 Street Maint. Material 460- 551702 Schertz Parkway Maint. Total Maintenance Services Rental -Lease 460- 561200 Lease /Purchase Payments Total Rental -Lease Operating Equipment 460- 571200 Office Equipment Total Operating Equipment Capital Outlay 460- 581400 Communications Equip. 460- 581700 Matching Improvements 460- 581701 Other Improvements 460- 581800 Other Equipment Total Capital Outlay 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED 2,443 3,315 3,000 3,000 81 81 500 500 676 3,753 1,800 3,000 3,200 7,149 5,300 6,500 9,271 9,765 10,000 10,000 9,271 9,765 10,000 10,000 1,133 3,637 3,000 3,000 2,784 7,869 7,000 5,000 - 226 500 500 - - 500 5,000 - 13,158 25,000 25,000 3,917 24,890 36,000 38,500 1,172 2,228 1,500 500 1,172 2,228 1,500 500 - 360 - - - 360 - - 8 1,385 250 400 - - 5,475 - - 5,610 - - 20,862 52,831 53,200 - 20,870 59,826 58,925 400 TOTAL PARKS 245,592 524,346 448,079 434,953' 53 THIS PAGE INTENTIONALLY LEFT BLANK CITY OF SCHERTZ COMMENTARY DEPARTMENT: POOL FUNCTION: To provide and maintain a well- managed and safe environment 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. 54 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PARKS & RECREATION EXPENDITURES POOLS Personnel Services 463- 511110 Regular 65,363 - 86,000 89,000 463- 511120 Overtime 1,539 - - 1,000 463- 511310 FICA - Employer 5,118 - 6,579 6,910 463- 511500 Workers Compensation 1,894 - 3,110 2,155 Total Personnel Services 73,914 - 95,689 99,065 Supplies 463- 521000 Operating Supplies 3,831 - 1,000 1,500 463- 521100 Office Supplies 348 - 500 500 463- 521200 Medical /Chemical Supplies 7,125 - 11,000 15,000 463- 521600 Equip Maint Supplies 25 - 1,000 1,000 Total Supplies 11,329 - 13,500 18,000 Utility Services 463- 533200 Electric Utility Service 4,469 - 6,000 11,000 463- 533410 Water Utility Service 2,949 - 5,000 5,000 Total Utility Services 7,418 - 11,000 16,000 Operations Support 463- 534000 Postage 9 - - - Total Operations Support 9 - - - Staff Support 463- 535100 Uniforms 1,447 - 600 620 463- 535500 Training/Travel 201 - 2,500 3,000 Total Staff Support 1,648 - 3,100 3,620 Maintenance Services 463- 551100 Building Maintenance 1,432 - 1,000 2,000 463- 551400 Minor & Other Equip Maint. 755 - 1,000 1,000 Total Maintenance Services 2,187 - 2,000 3,000 55 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Rental -Lease 463- 561200 Lease /Purchase Payments 67 - 500 500 Total Rental -Lease 67 - 500 500 Capital Outlay 463- 581700 Other Improvements 1,807 - - - 463- 581800 Other Equipment 6,715 - 5,000 - Total Capital Outlay 8,522 - 5,000 - TOTAL POOLS 105,094 With Parks 130,789 140,185 THIS PAGE INTENTIONALLY LEFT 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 engage in life -long learning. The Library assembles, preserves and makes available to all patrons in the service area, materials in a variety of formats that will assist them in fields of knowledge and recreation. The library service area includes the State of Texas, with the primary area being the City of Schertz and Guadalupe County. 57 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED CULTURAL EXPENDITURES LIBRARY Personnel Services 665 - 511110 Regular 169,429 165,160 186,338 665 - 511120 Overtime 340 383 1,000 665 - 511180 LTD 366 357 471 665- 511210 Longevity 4,572 3,648 4,284 665- 511310 FICA - Employer 12,700 11,907 14,732 665- 511350 TMRS - Employer 10,805 9,576 16,571 665- 511410 Health- Employer 18,181 20,575 23,082 665- 511500 Workers Compensation 678 373 690 Total Personnel Services 217,071 211,979 247,168 Supplies 665 - 521000 Operating Supplies 2,727 1,981 6,960 665 - 521100 Office Supplies 5,990 5,823 2,000 Total Supplies 8,717 7,804 8,960 Utility Services 665 - 533200 Electric Utility Service 7,841 10,283 9,000 665 - 533410 Water Utility Service 1,068 1,275 1,200 Total Utility Services 8,909 11,558 10,200 Operations Support 665 - 534000 Postage 924 1,100 - 665- 534200 Printing & Binding 889 1,944 2,500 Total Operations Support 1,813 3,044 2,500 Staff Support 665 - 535100 Uniforms 396 246 500 665 - 535200 Annual Awards - 7 300 665 - 535300 Memberships 316 181 350 665 - 535500 Training /Travel 1,381 1,049 800 Total Staff Support 2,093 1,483 1,950 W; 216,364 1,000 455 5,352 16,961 20,271 24,649 525 285,577 6,000 1,000 7,000 10,000 1,200 11,200 3,500 3,500 400 300 550 1,000 2,250 101 GENERAL FUND 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 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED 4,550 5,000 5,500 5,500 1,784 1,425 1,900 2,125 6,334 6,425 7,400 7,625 13,347 877 - - - 4,994 5,000 5,000 44,995 49,963 51,000 66,000 58,342 55,834 56,000 71,000 TOTAL LIBRARY 303,279 298,127 334,178 388,152 59 THIS PAGE INTENTIONALLY LEFT BLANK CITY OF SCHERTZ COMMENTARY DEPARTMENT: ANIMAL CONTROL FUNCTION: 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. To provide a Texas Department of Health approved quarantine facility for Rabies control. We CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED HEALTH EXPENDITURES ANIMAL CONTROL Personnel Services 762- 511110 Regular 77,241 104,344 113,275 127,704 762- 511120 Overtime 7,067 5,131 5,000 9,780 762 - 511180 LTD 167 294 321 347 762 - 511210 Longevity 480 - 600 840 762 - 511220 Clothing Allowance - 2,548 3,000 3,120 762- 511310 FICA - Employer 6,342 8,324 9,075 9,834 762 - 511350 TMRS - Employer 5,526 7,519 10,279 11,753 762- 511410 Health- Employer 11,836 16,666 20,632 20,541 762- 511500 Workers Compensation 1,609 2,140 2,666 1,995 Total Personnel Services 110,268 146,966 164,848 185,914 Supplies 762- 521000 Operating Supplies 4,846 3,241 5,000 5,000 762- 521100 Office Supplies 729 740 1,200 - 762- 521200 Medical /Chemical Supplies 5,899 3,357 6,000 4,000 762- 521300 Motor Veh. Supplies 100 49 400 200 Total Supplies 11,574 7,387 12,600 9,200 Utility Services 762- 533200 Electric Utility Service 5,425 1,096 4,000 4,000 762- 533410 Water Utility Service 2,814 2,107 2,500 2,500 762- 533500 Vehicle Fuel 3,081 1,853 2,000 2,500 Total Utility Services 11,320 5,056 8,500 9,000 Operations Support 762- 534000 Postage 85 203 - - 762- 534100 Advertising - - 250 250 762- 534200 Printing & Binding 508 125 2,000 1,000 762 - 534300 Copy Services 580 687 - - Total Operations Support 1,173 1,015 2,250 1,250 61 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 101 GENERAL FUND 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED Staff Support 762 - 535100 Uniforms 1,395 43 - - 762- 535300 Memberships 221 330 400 500 762- 535500 Training /Travel 1,011 1,177 1,613 1,774 762- 535600 Professional Certification - - 700 500 Total Staff Support 2,627 1,550 2,713 2,774 City Assistance 762 - 537100 Medical Services 9,407 11,766 15,000 13,000 Total City Assistance 9,407 11,766 15,000 13,000 Professional Services 762- 541300 Other Consult/Prof Service 1,710 305 750 500 Total Professional Services 1,710 305 750 500 Maintenance Services 762 - 551100 Building Maintenance 7,291 4,738 6,000 6,000 762 - 551400 Minor & Other Equip Maint 316 60 637 750 Total Maintenance Services 7,607 4,798 6,637 6,750 Rental -Lease 762- 561200 Lease /Purchase Payments 194 150 - - Total Rental -Lease 194 150 - - Operating Equipment 762 - 571000 Furniture & Fixtures - 526 110 1,000 Total Operating Equipment - 526 110 1,000 Capital Outlay 762- 581700 Improvements - 760 - 900 762- 581800 Other Equipment - 475 3,500 - Total Capital Outlay - 1,235 3,500 900 TOTAL ANIMAL CONTROL 18 ,880 180,754 216,908 230,288 62 THIS PAGE INTENTIONALLY LEFT 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. 63 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES INFORMATION TECHNOLOGY Personnel Services 853 - 511110 Regular 91,961 97,282 100,812 134,372 853 - 511180 LTD 218 259 274 365 853 - 511210 Longevity 120 360 600 840 853 - 511310 FICA - Employer 6,899 7,279 7,758 10,344 853 - 511350 TMRS - Employer 6,314 6,685 8,577 12,362 853 - 511410 Health - Employer 6,002 7,448 7,694 12,324 853 - 511500 Workers Compensation 286 232 357 313 Total Personnel Services 111,800 119,545 126,072 170,920 Supplies 853 - 521100 Office Supplies 298 242 250 150 853 - 521600 Equip Maint Supplies 3,418 3,005 3,500 3,000 Total Supplies 3,716 3,247 3,750 3,150 City Support Services 853 - 532300 Computer Consulting 9,913 - 6,000 6,000 853 - 532400 Computer Fees & Licenses 35,207 51,178 82,782 128,162 Total City Support Services 45,120 51,178 88,782 134,162 Utility Services 853 - 533300 Telephone 30,060 53,343 63,135 88,300 853 - 533500 Vehicle Fuel - - - 750 Total Utility Services 30,060 53,343 63,135 89,050 Operations Support 853 - 534000 Postage 122 117 - - Total Operations Support 122 117 - - Staff Suaaort 853 - 535100 Uniforms - 56 70 140 853 - 535300 Memberships 100 50 300 302 853 - 535400 Publications - 171 250 150 853 - 535500 Training/Travel 931 2,040 5,256 3,310 Total Staff Support 1,031 2,317 5,876 3,902 64 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 Capitalized Equipment 853 - 581401 Communication Equipment 3,156 23,669 4,800 Total Capitalized Equipment 3,156 23,669 4,800 17,850 17,850 TOTAL INFORMATION TECH 218,843 281,297' 377,153' 447,831 65 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Maintenance Services 853 - 551300 Computer Maint 888 1,443 7,688 12,942 853 - 551800 Other Maint. Agreement - 1,730 4,200 4,505 Total Maintenance Services 888 3,173 11,888 17,447 Operating Equipment 853 - 571000 Furniture & Fixtures - 130 - - 853- 571300 Computer & Peripherals 22,950 24,578 72,850 11,350 Total Operating Equipment 22,950 24,708 72,850 11,350 Capitalized Equipment 853 - 581401 Communication Equipment 3,156 23,669 4,800 Total Capitalized Equipment 3,156 23,669 4,800 17,850 17,850 TOTAL INFORMATION TECH 218,843 281,297' 377,153' 447,831 65 THIS PAGE INTENTIONALLY LEFT BLANK CITY OF SCHERTZ COMMENTARY DEPARTMENT: HUMAN RESOURCES FUNCTION: Provides recruiting, hiring process management, employee orientation, job description, development facilitation, performance evaluation processing and wage and benefits payroll coordination. Liaison with insurance broker 125 Plan Administrator. Coordinates annual open enrollment scheduling and payroll changes. Provides workers compensation administration. Provides organizational departures processing. Conducts research in the form of salary surveys, salary reviews, and staffing studies. Provides Unemployment Compensation Administration. Provides personnel budget projections to City Manager. Provides City Personnel Policy guidance to city staff. Responds to employment verification and background investigation requests. Confers with City Attorney for policy development guidance and in responding to Open Records requests and other personnel information requests. Provides recommendations to City Manager on personnel issues. Provides guidance and assistance with Family Medical Leave and Military Leave requests. Maintains personnel files and Human Resources Department information systems. Manages Human Resources Budget and billing for all personnel services. Coordinates and provides Employee Assistance Program information. Supports and provides information for the City of Schertz Fit City Program. .. CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES HUMAN RESOURCES Personnel Services 866 - 511110 Regular 47,722 52,948 53,780 67,942 866 - 511120 Overtime 15 142 750 750 866 - 511180 LTD 113 141 150 186 866 - 511210 Longevity 360 600 840 1,080 866 - 511310 FICA - Employer 3,382 3,722 4,236 5,280 866 - 511350 TMRS - Employer 3,296 3,672 4,877 6,311 866- 511410 Health - Employer 5,824 7,565 7,694 8,216 866- 511500 Workers Compensation 152 124 230 160 866 - 511600 Unemployment Compensation 21,881 23,966 30,000 10,000 Total Personnel Services 82,745 92,880 102,557 99,925 Supplies 866 - 535100 Uniforms - 42 140 210 866 - 521000 Office Supplies 552 600 500 383 Total Supplies 552 600 500 383 Human Services 866 - 531100 Pre - Employment Check 247 190 500 580 866 - 531200 Medical Co -Pay 1,650 900 2,000 1,000 866 - 531300 Employee Assistance 6,171 6,732 7,500 7,500 866 - 531400 Tuition Reimbursement 9,360 6,603 8,000 8,000 866 - 531500 Fit City Program - - - 2,000 Total Human Services 17,428 14,425 18,000 19,080 Operations Support 866 - 534000 Postage 702 616 - - 866- 534100 Advertising 9,961 6,897 10,000 10,000 866 - 534200 Printing & Binding 926 968 525 1,252 Total Operations Support 11,589 8,481 10,525 11,252 Staff Support 866 - 535100 Uniforms - 42 140 210 866 - 535210 Employee Recognition - - - 5,000 866 - 535300 Memberships 160 310 310 250 866 - 535400 Publications - - 85 449 866 - 535500 Training/Travel 1,285 2,175 3,504 5,000 Total Staff Support 1,445 2,527 4,039 10,909 r-YA CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 101 GENERAL FUND 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED City Assistance 866 - 537100 Medical Services 4,866 5,953 5,000 5,000 Total City Assistance 4,866 5,953 5,000 5,000 Professional Services 866 - 541300 Other Consul /Prof Service 6,900 - 4,217 4,000 Total Professional Services 6,900 - 4,217 4,000 TOTAL, HUMAN RESOURCES 125,525 124,866 144,838 150,549 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. We CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES FINANCE Personnel Services 868 - 511110 Regular 138,744 138,374 160,240 184,425 868- 511120 Overtime 3,173 132 1,000 1,000 868 - 511180 LTD 299 370 440 505 868 - 511210 Longevity 1,200 1,320 1,800 2,544 868- 511310 FICA - Employer 10,833 10,447 12,473 14,303 868- 511350 TMRS - Employer 8,843 9,592 14,236 17,095 868- 511410 Health - Employer 11,806 17,765 19,235 20,541 868- 511500 Workers Compensation 434 327 571 433 Total Personnel Services 175,332 178,327 209,995 240,846 Supplies 868 - 521000 Operating Supplies - 1,296 1,600 1,500 868 - 521100 Office Supplies 1,714 1,363 2,000 1,600 Total Supplies 1,714 2,659 3,600 3,100 Operations Support 868 - 534000 Postage 277 263 - - 868- 534200 Printing & Binding 3,044 645 1,026 2,000 Total Operations Support 3,321 908 1,026 2,000 Staff Suanort 868 - 535100 Uniforms 235 134 175 350 868 - 535300 Memberships 455 465 300 355 868- 535400 Publications - 90 275 272 868 - 535500 Training/Travel 4,027 5,534 5,000 8,000 Total Staff Support 4,717 6,223 5,750 8,977 70 THIS PAGE INTENTIONALLY LEFT BLANK CITY OF SCHERTZ COMMENTARY DEPARTMENT: FLEET FUNCTION: The Primary 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. 71 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 101 GENERAL FUND INTERNAL SERVICE EXPENDITURES FLEET SERVICE Personnel Services 877 - 511110 Regular 877 - 511120 Overtime 877 - 511180 LTD 877 - 511210 Longevity 877 - 511310 FICA - Employer 877 - 511350 TMRS - Employer 877 - 511410 Health - Employer 877 - 511500 Workers Compensation Total Personnel Services Supplies 61,334 877 - 521000 Operating Supplies 877 - 521100 Office Supplies 877 - 521200 Medical /Chemical Supplies 877 - 521300 Motor Veh. Supplies 877 - 521600 Equip Maint Supplies Total Supplies 1,968 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 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED 53,931 61,334 76,959 80,054 416 892 1,000 1,000 123 165 217 222 1,704 1,968 1,872 2,256 4,043 4,868 6,134 6,297 3,653 4,365 6,986 7,526 5,807 8,607 11,541 12,325 1,842 1,589 2,902 1,900 71,519 83,788 107,611 111,580 1,891 3,559 1,500 2,500 279 434 400 100 1,276 598 1,500 1,500 55,427 69,034 58,800 60,000 31 633 800 1,100 58,904 74,258 63,000 65,200 650 650 1,572 2,089 1,500 4,000 1,572 2,089 1,500 4,000 34 275 300 300 34 275 300 300 72 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Staff Support 877 - 535100 Uniforms 877 - 535200 Annual Awards 877 - 535500 Training /Travel Total Staff Support Maintenance Services 902 1,082 1,500 - - 100 675 133 1,750 1,577 1,215 3,350 877 - 551100 Building Maintenance - 200 - 877- 551400 Minor & Other Equip Maint 387 4,024 4,000 877 - 551800 Other Maint Agreement 23,354 13,467 12,500 Total Maintenance Services 23,741 17,691 16,500 1,500 1,000 2,500 500 4,000 19,500 24,000 Rental -Lease 877 - 561100 Rental Equipment - - 200 200 877 - 561200 Lease /Purchase Payments 251 72 84 84 Total Rental -Lease 251 72 284 284 TOTAL FLEET SERVICE 158,248 179,388 192,545 207,864 73 CITY OF SCHERTZ COMMENTARY DEPARTMENT: CITY 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 low 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. The City of Schertz also provides assistance to the Guadalupe Children's Advocacy Center. The Center provides a warm, homelike environment for children who visit to be interviewed about physical or sexual abuse. The Children's Advocacy Center's primary emphasis is placed on the well -being of the child to prevent further trauma. 74 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED MISCELLANEOUS EXPENDITURES CITY ASSISTANCE City Assistance 901 - 537300 Patient Assistance 11,000 5,000 5,000 5,000 901 - 537500 Children's Advocacy Asst. - - 5,000 5,000 Total City Assistance 11,000 5,000 10,000 10,000 TOTAL CITY ASSISTANCE 11,000 5,000 10,000' 10,000 75 THIS PAGE INTENTIONALLY LEFT 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 on city debt. The I &S portion of the property taxes are directly deposited by the County Assessor's Office into this fund. 76 TOTAL DEBT SERVICE 1,600,000 1,400,000 1,200,000 -- -- 1,000,000 800,000 600,000 400,000 200,000 ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® ® 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 77 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 505 TAX I & S ACTUAL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY Revenue Summary Taxes 762854 1,022,068 1,156,206 1,247,644 Fund Transfers 548374 739,230 452,481 - Miscellaneous 4030 4,951 3,800 171,550 TOTAL REVENUES 1,315,258 1,766,249'' 1,612,487 1,419,194 Expenditure Summary Maintenance Service Professional Service 738225 1,838,902 1,607,487 1,407,644 4565 3,220 5,000 5,000 TOTAL EXPENDITURES 742,790 1,842,122 1,612,487 1,412,644 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 505 TAX I & S 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 Miscellaneous 000 - 491000 Interest Earned 000 - 491000 Investment Income 000 - 498100 Reimbursement -EMS SR2003 Pymt 000 - 498200 Transfer from Reserve Total Miscellaneous 762,854 988,757 1,121,206 1,212,644 - 33,311 35,000 35,000 762,854 1,022,068 1,156,206 1,247,644 548,374 739,230 452,481 548,374 739,230 452,481 275 796 300 1,800 3,755 4,155 3,500 9,000 - - - 65,750 - - - 95,000 4,030 4,951 3,800 171,550 TOTAL REVENUES 1,315,258 1,766,249 1,612,487 1,419,194 79 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 505 TAX I& S ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES Professional Services 101 - 541500 Paying Agent Total Professional Services Maintenance Service 101- 551610 Debt Service Total Maintenance Service 4,565 3,220 5,000 5,000 4,565 3,220 5,000 5,000 738,225 1,838,902 1,607,487 1,407,644 738,225 1,838,902 1,607,487 1,407,644 TOTAL NONDEPARTMENTAL 742,790 1,842,122 1,612,487 1,412,644 * Water &Sewer Revenues Sale of Water $ 4,494,805 Garbage Collection $ 1,871,685 Sewer Charges $ 1,742,000 Other Fees &Charges $ 492,700 Mise Income $ 145,250 TOTAL $ 8,746,440 Sewer Charges 20% Water & Sewer Fund - Revenue Other Fees & Charges Misc Income uaigage uaiiection 21% ,h Sale of Water 51% Water &Sewer Expenditures Personnel $ Supplies $ Prof &City Svc $ Utility & Maint Srvc $ Opr Support &Asst $ Equip &Leasing $ Debt Service $ TOTAL $ 1,128,909 76,300 233,737 4,400,830 420,673 134,700 2,350,257 8,745,406 Equip & 2' Water & Sewer Expenditures Debt Service 27% Personnel 13% Supplies 1% . .5% 84 'rof & City Svc 3% Utility & Maint. Svc 49% CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 202 -WATER & SEWER ACTUAL ACTUAL BUDGET APPROVED Revenue Summary Fees 6,784,632 6,417,849 7,598,670 8,424,190 Fund Transfers - 32,959 630,010 177,000 Miscellaneous 163,204 410,537 140,250 145,250 TOTAL REVENUES 6,947,836 6,861,345 8,368,930 8,746,440 Expenditure Summary GENERAL GOVERNMENT BUSINESS OFFICE 329,002 373,612 294,430 373,356 TOTAL GENERAL GOVERNMENT 329,002 373,612 294,430 373,356 PUBLIC WORKS W & S ADMINISTRATION 5,227,407 5,171,249 7,789,259 8,372,050 TOTAL PUBLIC WORKS 5,227,407 5,171,249 7,789,259 8,372,050 TOTAL EXPENDITURES 5,556,409 5,544,861 8,083,689 8,745,406 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 202 -WATER & SEWER ACTUAL ACTUAL BUDGET APPROVED Fees 000 - 455200 Garbage Collection Fee 1,543,775 1,420,474 1,700,000 1,871,685 000 - 455600 Fire Line Fees - 9,136 10,000 10,000 000 - 455700 Recycle Fee Revenue 111,453 114,795 115,500 127,700 000 - 455800 W &S Line Constructn Reimb 46,723 28,319 31,000 15,000 000 - 457100 Sale of Water 3,641,105 3,396,425 3,744,948 4,494,805 000 - 457110 Edwards Water Lease 19,625 20,092 25,000 17,500 000 - 457200 Sale of Meters 28,514 20,744 23,000 23,000 000 - 457400 Sewer Charges 1,300,611 1,304,762 1,846,882 1,742,000 000 - 457500 Water Penalties 91,459 100,475 100,040 120,000 000 - 459100 Credit Card Fee 32 287 300 500 000 - 459200 NSF Check Fee - Water &Swr 1,335 2,340 2,000 2,000 Total Fees 6,784,632> 6,417,849 7,598,670 8,424,190 Fund Transfers 000 - 486101 Transfer from Equip Reserves - - - 132,000 000 - 486204 Interfnd Chrg- Drainage Billing - 32,959 36,720 45,000 000 - 486411 Transfer in- Capital Recovery - - 593,290 - Total Fund Transfers 32,959 630,010 177,000 Miscellaneous 000 - 490000 Misc Charges 22,637 - 20,000 - 000- 491000 Interest Earned 3,740 1,524 1,000 1,000 000 - 491200 Investment Income 67,559 26,102 10,000 30,000 000 - 496000 Water Construction Reserve - 364,500 65,000 65,000 000 - 497000 Miscellaneous Income W &S 61,199 15,346 7,000 12,000 000 - 498100 Loan Repayment -EMS - - 32,250 32,250 000 - 498200 W &S Project Reimbursement 8,070 3,065 5,000 5,000 Total Miscellaneous 163,205 410,537 140,250 145,250 TOTAL REVENUES :. 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 /on and transfers. Is responsible for sewer averaging every year. Office personnel provide friendly and efficient service for all customers and solves complaints in a timely manner. This department also collects various payments made to other departments. M CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 202 -WATER & SEWER GENERAL GOVERNMENT BUSINESS OFFICE Personnel Services 176 - 511110 Regular 176 - 511120 Overtime 176- 511180 LTD 176- 511210 Longevity 176- 511310 FICA - Employer 176- 511350 TMRS - Employer 176- 511410 Health- Employer 176- 511500 Workers Compensation Total Personnel Services Supplies 176 - 521000 Operating Supplies 176 - 521100 Office Supplies 176- 521200 Medical /Chem Supplies Total Supplies City Support Services 176 - 532500 City Insurance - 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 Operating Equipment 176- 571000 Furniture & Fixtures Total Operating Equipment 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED 209,335 216,051 146,746 196,897 2,643 105 1,000 1,000 494 573 418 564 9,960 11,592 7,128 11,856 16,540 16,947 11,848 15,970 15,058 15,482 13,406 19,086 25,969 29,571 23,082 29,199 579 2,897 542 484 280,578 293,218 204,170 275,056 2,835 814 1,000 1,000 3,365 1,985 3,500 3,500 - - - 800 6,200 2,799 4,500 5,300 - - 10 10 - - 10 10 38,625 39,512 46,500 46,500 2,205 32,932 35,000 42,000 40,830 72,444 81,500 88,500 216 269 250 490 1,178 3,382 3,000 3,000 1,394 3,651 3,250 3,490 - 1,500 1,000 1,000 - 1,500 1,000 1,000 TOTAk "$11NESS OFFICE 329,0( ,6','2 2 4;431) ` 313,350' :: CITY OF SCHERTZ COMMENTARY DEPARTMENT: WATER/WASTEWATER FUNCTION: The Water/Wastewater Department is responsible for providing the City of Schertz customers safe, potable drinking 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. 0 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 202 -WATER & SEWER ACTUAL ACTUAL BUDGET APPROVED PUBLIC WORKS W & S ADMINISTRATION Personnel Services 575 - 511110 Regular 591,502 539,401 564,995 615,831 575 - 511120 Overtime 10,332 9,147 10,000 10,000 575 - 511180 LTD 1,361 1,428 1,599 1,718 575 - 511210 Longevity 20,544 15,528 17,640 18,588 575 - 511230 Certification Allowance 2,850 2,841 2,827 3,600 575 - 511310 FICA - Employer 46,378 40,253 45,299 48,671 575 - 511350 TMRS - Employer 42,763 37,787 51,222 58,170 575 - 511410 Health - Employer 72,791 71,495 76,939 83,427 575 - 511500 Workers Compensation 22,836 11,059 19,669 13,848 Total Personnel Services 811,357 728,939 790,190 853,853 Supplies 575 - 521000 Operating Supplies 7,078 6,724 9,500 9,500 575 - 521100 Office Supplies 4,863 5,423 6,000 6,000 575 - 521200 Medical Supplies 6,225 3,785 5,000 5,000 575 - 521400 Plumbing Supplies 58,037 31,651 115,000 50,000 575 - 521600 Equip Maint Supplies 858 514 500 500 Total Supplies 77,061 48,097 136,000 71,000 Citv Suaaort Services 575 - 532400 Computer Fees & Licenses 33,635 17,528 28,327 28,327 575 - 532410 Computer Consulting 2,000 3,814 7,000 7,000 575 - 532500 City Insurance - Commercial 17,217 8,815 20,000 20,000 575 - 532700 Records Management Service - - 2,000 2,000 575 - 532900 Contingencies 96 - 4,000 69,000 Total City Support Services 52,948 30,157 61,327 126,327 Utilitv Services 575 - 533200 Electricity 128,354 98,802 110,000 110,000 575 - 533300 Telephone 9,461 7,154 10,000 10,000 575 - 533400 Water Purchase 846,377 1,092,734 1,003,918 1,127,654 575 - 533410 Water Utility Service 593 643 1,700 1,700 575 - 533500 Vehicle Fuel 20,763 23,113 25,000 25,000 Total Utility Services 1,005,548 1,222,446 1,150,618 1,274,354 X-C CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 202 -WATER & SEWER 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED Operations Support 11,024 10,350 14,000 14,000 575 - 534100 Advertising 357 - 1,490 1,740 575 - 534200 Printing & Binding 1,369 1,628 2,250 2,500 575 - 534300 Copy Services - 274 945 3,420 Total Operations Support 1,726 1,902 4,685 7,660 Staff Suaaort 575 - 535000 Rental- Building & Land 1,782 1,836 2,000 2,000 575 - 535100 Uniforms 11,024 10,350 14,000 14,000 575 - 535200 Annual Awards - 382 600 500 575 - 535300 Memberships 3,023 1,720 3,025 3,500 575 - 535400 Publications 333 263 400 400 575 - 535500 Training/Travel 7,247 3,911 7,472 11,901 575 - 535600 Prof. Certifications - - - 300 Total Staff Support 23,409 18,462 27,497 32,601 City Assistance 575 - 537100 Medical Services 501 1,016 3,000 3,000 Total City Assistance 501 1,016 3,000 3,000 Professional Services 575 - 541100 Engineering Services 101,624 35,378 62,300 50,000 575 - 541200 Legal Services 27,961 19,428 20,300 20,000 575 - 541300 Other Consul /Prof Service 20,788 16,802 25,000 20,000 575 - 541400 Auditor /Accounting Service 8,069 12,000 13,000 13,000 575 - 541500 Paying Agent - - 400 1,400 Total Professional Services 158,442 83,608 121,000 104,400 Fund Charges 575 - 548600 Inter Fund Charges -Admin 548,834 457,362 Total Fund Charges 548,834 372,791 91 372,791 288,422 372,791 288,422 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 202 -WATER & SEWER 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED Maintenance Services 3,502 200 200 Total Rental -Lease 4,884 575 - 551100 Building Maintenance 741 2,121 4,250 4,250 575 - 551300 Computer Maintenance 6,520 7,602 10,000 10,000 575 - 551400 Minor & Other Equip Maint 2,459 1,622 2,600 2,400 575 - 551500 Water & Sewer Maintenance 17,615 3,917 25,000 25,000 575 - 551510 Payable to Wast Contractor 1,380,472 1,402,567 1,552,578 1,648,826 575 - 551520 Sewer Treatment- CCMA/MUD 860,002 998,188 1,243,915 1,420,000 575 - 551600 Street Maintenance Materials 4,275 2,574 5,500 5,500 575 - 551610 Debt Service 251,458 232,864 2,266,308 2,350,257 575 - 551720 Low Flow Rebate Program 2,750 2,350 3,000 3,000 575 - 551740 Rebate UB Customer - - 3,000 3,000 575 - 551800 Other Maintenance 450 2,857 4,300 4,500 Total Maintenance Services 2,526,742 2,656,662 5,120,451 5,476,733 Rental -Lease 575 - 561100 Rental- Equipment 1,316 3,319 1,500 1,500 575 - 561200 Lease /Purchase Payments 3,568 3,502 200 200 Total Rental -Lease 4,884 6,821 1,700 1,700 Capitalized Equipment 575 - 581200 Vehicles 5,941 - - 32,000 575 - 581600 Water Tank Restoration 7,757 348 - - 575- 581700 Other Improvements 2,257 - - 100,000 Total Capitalized Equipment 15,955 348 - 132,000 TOTAL W & &ADMINISTRATION, 5,227,407= 5,171,249 7,789,259 8,372,050; 92 Schertz E M S - Revenues Ambulance /Mileage Fees $ 3,029,311 Misc. Revenue $ 62,500 Inter - Jurisdictional Contracts $ 937,560 TOTAL $ 4,029,371 93 Inter - Jurisdictional Contracts n, Misc. Rev 2% Schertz EMS - Revenue 94 75% Schertz E M S - Expenditures Personnel $ 1,341,879 Supplies $ 169,300 Prof &City Svc $ 123,600 Utility & Maint. Svc $ 78,339 Opr Support &Asst $ 2,028,372 Equip. &Leasing $ 50,600 Debt Service $ 104,250 TOTAL $ 3,896,340 95 Schertz EMS - Expenditures Opr Support & Asst 53% Utility & Maint. 2% Prof & City Services OuPNi11--S r Vi avi n ici 3% 4% 34% ising Debt Service 3% 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 primary 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 90,000 people currently reside. 97 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 203 - E M S ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Fees 1,452,134 1,151,467 2,650,000 3,029,311 Inter - Jurisdictional 561,992 572,164 642,628 937,560 Miscellaneous 66,138 71,976 60,000 62,500 TOTAL REVENUES 2,080,264 1,795,607 3,352,628 4,029,371 Expenditure Summary Personnel Services 1,100,353 1,133,625 1,303,077 1,341,879 Supplies 144,184 107,729 137,500 169,300 City Support Services 27,263 6,000 27,000 27,000 Utility Services 35,189 41,171 40,249 37,000 Operations Support 2,788 7,408 5,600 7,050 Staff Support 39,576 27,666 56,200 72,003 City Assistance 10,328 12,989 16,000 6,000 Professional Services 61,745 55,809 72,000 96,600 Fund Charges 717,541 953,920 1,540,000 1,943,319 Maintenance Service 15,080 14,766 47,311 41,339 Debt Service - 72,000 98,000 104,250 Rental Lease 10,342 10,692 10,000 10,000 Operating Equipment 14,086 13,801 12,500 35,600 Capitalized Equipment 1,262 3,237 5,000 5,000 TOTAL EMS EXPENDITURES 2,179,737 2,460,813 3,370,437 3,896,340 .; CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 203 - E M S ACTUAL ACTUAL BUDGET APPROVED REVENUES Fees 000 - 456100 Ambulance /Mileage Transport 1,452,069 1,151,447 2,650,000 3,029,311 000 - 459100 Credit Card Fee - - - - 000 - 459200 NSF Check Fee 65 20 - - Total Fees 1,452,134 1,151,467 2,650,000 3,029,311 Inter - Jurisdictional 000 - 473500 Seguin /Guad Co Support 181,291 162,550 176,990 210,310 000 - 473600 Comal Co Support 26,500 30,550 30,000 30,000 000 - 474300 Cibolo Support 20,031 27,720 35,700 80,000 000 - 475100 Garden Ridge Support 12,421 13,794 14,630 20,900 000 - 475200 Live Oak Support 60,430 60,430 64,092 100,780 000 - 475300 Universal City Support 98,003 99,000 105,000 165,690 000 - 475400 Selma Support 5,201 13,200 17,500 30,000 000 - 475500 Schertz Support 141,900 151,800 184,800 280,000 000 - 475600 Santa Clara Support 5,867 5,867 6,223 8,890 000 - 475700 St. Hedwig Support 3,094 - - - 000- 475800 Marion Support 7,253 7,253 7,693 10,990 Total Inter-Jurisdictional 561,991 572,164 642,628 937,560 Miscellaneous 000 - 491000 Interest Earned 1,039 - - - 000- 493203 Donations- EMS 360 2,245 2,000 000 - 497000 Misc Income 47,505 37,096 20,000 20,000 000 - 497500 Misc Income -EMT Classes 17,235 32,635 40,000 40,500 Total Miscellaneous 66,139 71,976 60,000 62,500 TOTAL REVENUES 2,080,264 1,795,607 3,352,628 4,029,3 1 0 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 203 - E M S ACTUAL ACTUAL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES Personnel Services 280 - 511110 Regular 661,399 667,753 789,530 744,208 280 - 511120 Overtime 167,747 193,505 200,389 273,995 280 - 511180 LTD 1,802 2,100 2,115 2,368 280 - 511210 Longevity 7,548 8,364 8,784 11,004 280 - 511220 Clothing Allowance 17,648 5,286 6,240 6,240 280 - 511230 Certification Allowance 36,301 33,206 29,764 9,140 280 - 511310 FICA - Employer 63,852 66,651 75,504 79,433 280 - 511350 TMRS - Employer 53,295 54,757 65,446 83,225 280 - 511410 Health - Employer 61,467 75,225 84,633 91,770 280 - 511500 Workers Compensation 29,294 26,778 40,672 40,496 Total Personnel Services 1,100,353 1,133,625 1,303,077 1,341,879 Supplies 280 - 521000 Operating Supplies 6,593 4,779 8,000 8,000 280 - 521010 Operating Supplies -EMT Class 8,045 11,000 15,000 11,300 280 - 521100 Office Supplies 7,097 5,149 5,500 6,000 280 - 521200 Medical Supplies 120,281 83,960 105,000 140,000 280 - 521300 Motor Veh. Supplies 1,124 1,056 1,500 1,500 280 - 521600 Equip Maint Supplies 1,044 1,785 2,500 2,500 Total Supplies 144,184 107,729 137,500 169,300 City Support Services 280 - 532500 City- Insurance - Commercial 27,263 6,000 27,000 27,000 Total City Support Services 27,263 6,000 27,000 27,000 Utilitv Services 280 - 533100 Gas 1,445 1,417 2,168 - 280- 533200 Electricity 10,406 12,287 12,730 - 280- 533300 Telephone 5,351 6,072 6,994 8,000 280 - 533410 Water Utility Service 2,025 2,660 3,357 - 280- 533500 Vehicle Fuel 15,962 18,735 15,000 29,000 Total Utility Services 35,189 41,171 40,249 37,000 100 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 203 - E M S 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED Operations Support 280 - 535200 Annual Awards 988 294 280 - 534000 Postage 1,830 4,065 3,000 4,250 280 - 534100 Advertising - 1,455 1,200 1,200 280 - 534200 Printing & Binding 958 1,888 1,400 1,600 Total Operations Support 2,788 7,408 5,600 7,050 Staff Support 280 - 535100 Uniforms - 9,616 12,000 22,000 280 - 535200 Annual Awards 988 294 1,000 1,000 280 - 535210 Employee Recognition /Morale - - - 5,000 280 - 535300 Memberships 1,000 820 1,800 2,300 280 - 535400 Publications 281 527 400 550 280 - 535500 Training/Travel 22,113 14,445 25,000 25,153 280 - 535600 Prof. Certs 15,194 1,964 16,000 16,000 Total Staff Support 39,576 27,666 56,200 72,003 Citv Assistance 280 - 537100 Medical Services 2,679 2,724 8,000 3,000 280 - 537800 Crime /Fire Prevention 7,649 10,265 8,000 3,000 Total City Assistance 10,328 12,989 16,000 6,000 Professional Services 15,080 14,766 47,311 41,339 280 - 541200 Legal Services 4,848 4,145 3,000 3,000 280 - 541300 Other Consult/Prof Service 51,559 35,414 42,000 75,000 280 - 541400 Auditor /Accounting Sery 2,388 2,000 2,000 2,000 280 - 541500 EMT Class Instructors 2,950 14,250 25,000 16,600 Total Professional Services 61,745 55,809 72,000 96,600 Fund Charaes 280 - 548500 Contractual Allowables - - 795,000 857,243 280 - 548600 Inter -Fund Charge - Admin 25,000 20,833 25,000 50,000 280 - 548700 Bad Debt Expense 692,541 933,087 720,000 1,036,076 Total Fund Charges 717,541 953,920 1,540,000 1,943,319 Maintenance Services 280 - 551100 Building Maintenance 6,271 5,180 7,500 7,500 280 - 551200 Motor Vehicle Fleet 117 2,416 24,311 19,839 280 - 551800 Other Maintenance Agreement 8,692 7,170 15,500 14,000 Total Maintenance Services 15,080 14,766 47,311 41,339 101 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 203 -EMS Debt Service 280 - 555202 Loan from Water 280 - 555505 Payment to I & S -SR 2003 Total Debt Service Rental -Lease 280 - 561200 Lease /Purchase Payments Total Rental -Lease Operating Equipment 280 - 571000 Furniture & Fixtures 280 - 571300 Computer & Peripherals Total Operating Equipment Capitalized Equipment 280 - 581400 Communications Equipment Total Capitalized Equipment 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED - - 26,000 32,250 - 72,000 72,000 72,000 - 72,000 98,000 104,250 10,342 10,692 10,000 10,000 10,342 10,692 10,000 10,000 - - - 3,600 14,086 13,801 12,500 32,000 14,086 13,801 12,500 35,600 1,262 3,237 5,000 5,000 1,262 3,237 5,000 5,000 TOTAL SC H ERTZ EMS 2,179, 737 2,460,813 3,370,437 3,896,340 102 THIS PAGE INTENTIONALLY LEFT BLANK CITY OF SCHERTZ COMMENTARY DRAINAGE FUND FUNCTION: Provides a system for storm water drainage. Insures the drainage system is properly maintained through mowing, silt and debris removal and erosion control and prevention. Includes maintenance of rural city Right of Ways. This Department maintains the G.I.S. Database and makes sure that all Flood Management measures are followed to ensure the safety of the Citizens of Schertz. 103 Drainage - Revenue Drainage Fees Misc Income 0 E11 TOTAL $ 104 357,4330 1,4000 358,330 FBI Drainage - Revenue Misc Income 0% 100% 105 _ __ Drainage - Expenditures Personnel $ 206,086 Supplies $ 4,200 Prof &City Svc $ 28,800 Utility & Maint. Svc $ 23,000 Opr Support &Asst $ 64,334 Equip. &Leasing $ 27,100 TOTAL $ 353,520 106 Opr Support &) 18% Utility & Maini 7% Drainage - Expenditures Capital 8% Prof & City Services 1 8% 107 Personnel 58% CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 204 - DRAINAGE FUND ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Fees - 305,315 309,670 357,330 Miscellaneous - 358 100 1,000 TOTAL REVENUES - 305,673 309,770 358,330 Expenditure Summary Personnel Services - 143,082 161,615 206,086 Supplies - 3,402 4,200 4,200 Utility Services - 4,959 6,000 6,000 Operations Support - - - 820 Staff Support - 2,626 4,726 5,475 City Assistance - - 800 800 Professional Services - 7,164 33,646 28,000 Fund Charges /Transfers - 36,500 58,621 58,039 Maintenance Services - 8,149 3,000 17,000 Rental Lease - 1,114 854 500 Capitalized Equipment - - 18,600 26,600 TOTAL EXPENDITURES 206,996 292,462 353,520 ' -* 204 - DRAINAGE FUND REVENUES CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Fees 000 - 457500 Water Penalties - 3,962 3,000 3,900 000 - 457600 Drainage Fees - 301,353 306,670 353,430 Total Fees - 305,315 309,670 " 357,330 Miscellaneous 000 - 491000 Interest Earned - 340 100 1,000 000 - 497000 Mis Income - Drainage - 18 - - Total Miscellaneous - 358 100 1,000 TOTAL REVENUES - 305,673 309,770 358,330 109 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 204 - DRAINAGE FUND 2002 -2003 2003 -2004 ACTUAL ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED General Government Expenditures Personnel Services 579 - 511110 Regular - 107,097 113,632 147,795 579 - 511120 Overtime - 1,328 2,000 2,000 579 - 511180 LTD - 257 324 412 579 - 511210 Longevity - 3,396 4,656 4,392 579 - 511310 FICA - Employer - 7,176 9,202 11,720 579 - 511350 TMRS - Employer - 7,035 10,404 14,008 579 - 511410 Health - Employer - 12,384 15,388 20,856 579 - 511500 Workers Compensation - 4,409 6,009 4,903 Total Personnel Services - 143,082 161,615 206,086 Supplies 579 - 521000 Operating Supplies - 995 1,000 1,000 579 - 521100 Office Supplies - 92 147 100 579 - 521200 Medical Supplies - 1,845 2,500 2,500 579 - 521300 Motor Veh. Supplies - 370 300 300 579 - 521600 Equipment Maint. Supplies - 100 253 300 Total Supplies - 3,402 4,200 4,200 Utility Services 579 - 533300 Telephone - - 1,000 1,000 579 - 533500 Vehicle Fuel - 4,959 5,000 5,000 Total Utility Services - 4,959 6,000 6,000 Operations Support 579 - 534300 Copy Services - - - 820 Total Operations Support - - - 820 Staff Support 579 - 535100 Uniforms - 2,027 3,100 3,100 579 - 535300 Memberships - 30 109 100 579 - 535500 Training/Travel - 519 1,266 2,025 579 - 535600 Professional Certification - 50 251 250 Total Staff Support - 2,626 4,726 5,475 110 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 204 - DRAINAGE FUND ACTUAL ACTUAL BUDGET APPROVED City Assistance 579 - 537100 Medical Services - - 800 800 Total City Assistance - - 800 800 Professional Services 579 - 541100 Engineering Services - 6,313 32,000 26,000 579 - 541200 Legal Service 351 646 1,000 579 - 541400 Auditor /Accounting Service - 500 1,000 1,000 Total Professional Services - 7,164 33,646 28,000 Fund Charaes /Transfers 579- 548500 Inter -Fund (Fleet/Admin) - - 21,901 15,159 579 - 548600 Inter -Fund Chgs - Water - 36,500 36,720 42,880 Total Fund Charges /Transfers - 36,500 58,621 58,039 Maintenance Services 579 - 551300 Computer Maintenance - - 2,000 2,000 579 - 551610 Drainage Channel Maintenance - 8,149 1,000 15,000 Total Maintenance Services - 8,149 3,000 17,000 Rental -Lease 579 - 561100 Rental Equipment - 1,114 854 500 Total Rental -Lease - 1,114 854 500 111 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 Texas Commission on Environmental Quality rules and regulations. 112 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 411 - CAPITAL RECOVERY ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Fees Fund Transfers Miscellaneous TOTAL REVENUES Expenditure Summary Professional Services Fund Transfers Projects 1,032,961 771,032 929,223 929,223 - - 1,230,348 - 72,393 83,059 130,000 139,000 1,105,354 854,091 2,289,571 1,068,223' 3,209 - - - 721,571 145,032 - - 2,000 157,036 TOTAL EXPENDITURES 145,032 3,209 '' 721,571 159,036 113 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 411 - CAPITAL RECOVERY ACTUAL ACTUAL BUDGET APPROVED REVENUES Fees 000 - 455900 Capital Recovery -Water 542,900 394,904 565,020 565,020 000 - 455910 Capital Recovery-Waste Water 490,061 376,128 364,203 364,203 Total Fees 1,032,961 771,032 929,223 929,223 Fund Transfers 000 - 481000 Transfer from Reserves - - 1,230,348 Total Fund Transfers - - 1,230,348 Miscellaneous 000 - 491000 Interest Earned 2,838 11,345 - 000- 491200 Investment Income 19,555 21,714 80,000 000 - 498100 Reimbursement -FM 78 Project 50,000 50,000 50,000 Total Miscellaneous 72,393 83,059 130,000 9,000 80,000 50,000 139,000 TOTAL REVENUES 1,105,354 854,091 2,289,571 1,068,223 114 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 411 - CAPITAL RECOVERY ACTUAL ACTUAL BUDGET APPROVED General Government EXPENDITURES Professional Services 101- 534100 Advertising 101 - 541100 Engineering Services 101 - 541400 Auditor Services Total Professional Services Fund Charges /Transfers 101 - 548600 Interfund Transfer Total Fund Charges /Transfers Capital Expenditures 101 - 581000 6000 8" Waterline -Lower Seguir 101 - 582000 12" Wtrline -FM 1103 (Chelsea) 101 - 581621 SSLG Corp. Total Capital Expenditures 2,209 - 1,000 - 3,209 - - - 721,571 721,571 2,000 2,000 - - - 115,808 - - - 41,228 145,032 - - - 145,032 - - 157,036 TOTAL - EXPENDITURES 145,032 3,209 721,571 159,036 115 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 it's activities. 116 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 620 -SED CORPORATION ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Taxes 743,641 850,863 1,010,000 1,150,000 Miscellaneous 9,137 7,017 70,243 17,000 TOTAL REVENUES 752,778 857,880 1,080,243 1,167,000 Expenditure Summary General Government Non - Departmental 540,435 620,168 832,334 692,459 Economic Development 94,548 - 171,207 316,995 TOTAL GENERAL GOVERNMENT 634,983 620,168 1,003,541 1,009,454 117 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 620 -SED CORPORATION ACTUAL ACTUAL BUDGET APPROVED REVENUES Taxes 000 - 411500 Sales Tax Revenues (4B) 743,641 850,863 1,010,000 1,150,000 Total Taxes 743,641 850,863 1,010,000 1,150,000 Miscellaneous 000 - 491000 Interest Earned 1,446 910 1,000 000 - 491200 Investment Earnings 7,691 6,107 5,000 000 - 499000 Transfer from Reserves - - 64,243 Total Miscellaneous 9,137 7,017 70,243 2,000 15,000 17,000 TOTAL REVENUES 752,778 857,880 1,080,243 1,167,000' 118 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 620 -SED CORPORATION 2002 -2003 2003 -2004 2004 -2005 ACTUAL ACTUAL BUDGET CITY COUNCIL APPROVED GENERAL GOVERNMENT - 1,769 1,775 1,775 NONDEPARTMENTAL 4,775 - - 65,000 Supplies - - 65,000 48,000 101 - 521000 Operating Supplies - - 10,835 11,435 101 - 521100 Office Supplies - - 100 100 101 - 521200 Medical /Chemical Supplies - - 2,300 2,300 Total Supplies - - 13,235 13,835 Utilities 101 - 533200 Gas Utility Service - - 4,319 4,500 101 - 533300 Electricity Utility Service - - 44,177 45,000 101 - 533410 Water Utility Service - - 7,165 8,000 101 - 533500 Fuel Supply (Diesel) - - 1,689 2,089 Total Utilities - - 57,350 59,589 Operations Support 101 - 534200 Printing and Binding Total Operations Support Professional Services 101- 541200 Legal Services 101 - 541400 Auditor /Accounting Service 101- 541500 Paying Agent Total Professional Services Fund Charges /Transfers 101 - 548600 Interfund Charges - Admin. Total Charges /Transfers Maintenance Services 101 - 551100 Building Maintenance 101 - 551400 Minor & other Equip Maint 101 - 551700 Ground Maintenance 101 - 551800 Other Maint Agreement Total Maintenance Services 2,000 2,000 1,226 - 1,816 2,000 800 750 800 1,000 - 1,769 1,775 1,775 2,026 2,519 4,391 4,775 - - 65,000 48,000 - - 65,000 48,000 - - 10,399 9,000 - - 375 375 - - 600 600 - - 5,000 6,399 119 16,374 16,374 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 620 -SED CORPORATION ACTUAL ACTUAL BUDGET APPROVED Debt Service 101 - 555600 Bond SR98 -Pub Safety Bldgs 387,974 101 - 555700 Tax Note SR01 -Fire Engine 150,435 Total Debt Service 538,409 Rental -Lease 101 - 561100 Rental Equipment - Total Rental -Lease _ Capital Outlay 381,189 384,236 161,460 166,748 542,649 550,984 200 - 200 101- 551603 Police Vehicles - 75,000 125,000 Total Capital Outlay - 75,000 125,000 381,486 166,400 547,886 TOTAL NONDERARTMENTAL 540,435 620,168 832,334 692,459 120 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 620 -SED CORPORATION ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES Personnel Services 966- 511110 Regular 57,327 - 90,150 131,310 966- 511120 Overtime - - 1,460 2,100 966- 511180 LTD 137 - 245 358 966- 511210 Longevity 120 - 480 720 966- 511310 FICA - Employer 4,221 - 6,933 10,117 966- 511350 TMRS - Employer 3,953 - 7,817 12,114 966- 511410 Health - Employer 3,239 - 7,694 12,514 966- 511500 Workers Compensation 156 - 319 468 Total Personnel Services 69,153 - 115,098 169,701 Supplies 966- 521000 Operating Supplies - - 180 180 966- 521100 Office Supplies 339 - 1,200 1,200 Total Supplies 339 - 1,380 1,380 City Support Services 966- 532800 Special Events 13,896 - 1,000 1,200 Total City Support Services 13,896 - 1,000 1,200 Utility Services 966- 533300 Telephone 2,071 - 290 1,260 Total Utility Services 2,071 - 290 1,260 Operations Support 966- 534000 Postage 388 - - 250 966- 534200 Printing & Binding 59 - 1,500 1,500 Total Operations Support 447 - 1,500 1,750 Staff Support 966- 535100 Uniforms 60 - 80 120 966- 535300 Memberships 541 - 1,284 3,284 966- 535400 Publications 350 - 575 800 966- 535500 Training /Travel 7,691 - 10,000 13,500 Total Staff Support 8,642 - 11,939 17,704 121 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 620 -SED CORPORATION ACTUAL ACTUAL BUDGET APPROVED Professional Services 966- 541100 Engineering - - - 7,000 966- 541400 Professional Services - - 40,000 82,000 Total Professional Services - - 40,000 89,000 Capital Outlay 966- 581100 Furniture and Fixtures - - - 5,000 966- 581200 Vehicles - - - 30,000 Total Capital Outlay - - - 35,000 TOTAL ECONOMIC DEVELOPMENT 94,548 171,207 316,095 122 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. 123 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 612 DEV FOUNDATION ACTUAL ACTUAL SUMMARY RECAP Revenue Summary 2004 -2005 CITY COUNCIL BUDGET APPROVED Fund Transfers - - 1,000 - Miscellaneous 1,649 1,170 1,000 2,020 TOTAL REVENUES 1,649 1,170 2,000' 2,020;' Expenditure Summary Staff Support 1,000 1,000 1,000 1,000 Professional Services 1,103 760 1,000 1,000 TOTAL NON - DEPARTMENTAL ' 2,103' 1,760 2,000 ' 2,000' 124 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 612 DEV FOUNDATION ACTUAL ACTUAL BUDGET APPROVED REVENUES Fund Transfers 000 - 481000 Transfer From Reserves - - 1,000 - Total Fund Transfers - - 1,000 - Miscellaneous 000 - 491000 Interest Earnings 412 77 40 20 000 - 491200 Investment Earnings 1,237 1,093 960 2,000 Total Miscellaneous 1,649 1,170 1,000 2,020 TOTAL'REVENUES 1,649 1,170 2,000 21'020 125 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 612 -DEV FOUNDATION ACTUAL ACTUAL BUDGET APPROVED General Government NONDEPARTMENTAL Staff Support 101 - 535300 Memberships Prof Organization 1,000 1,000 1,000 1,000 Total Staff Support 1,000 1,000 1,000 1,000 Professional Services 101 - 541400 Auditor /Accounting Service 1,103 101 - 541600 Misc Bank Charge - Total Professional Services 1,103 750 1,000 1,000 10 - - 760 1,000 1,000 TOTAL NONDEP"ARTMENTAL 2,103 1,760 2,000 2,000 iiIKel THIS PAGE INTENTIONALLY LEFT BLANK CITY OF SCHERTZ COMMENTARY SPECIAL EVENTS FUND FUNCTION: The Special Events Fund is designated to monitor and manage funds appropriated to pay for all events sponsored by the City of Schertz. 127 106 - SPECIAL EVENTS REVENUES Miscellaneous 000 - 458100 000 - 493100 000 - 493400 000 - 493500 000 - 453600 000 - 493450 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 Sale of Merchandise July 4th Jubilee Emergency Svc Day Donations -Bus Apprec Dinner Christmas Activites Holiday Lock -Up Total Miscellaneous Fund Transfers 000 - 480100 Interfund Transfer In Total Fund Transfers 2004 -2005 CITY COUNCIL BUDGET APPROVED 1,000 - 5,000 - 40,000 - 500 1,400 3,000 700 3,000 2,000 52,500 4,100 24,000 42,000 24,000 42,000 TOTAL REVENUES 76,500 46,100 128 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 106 - SPECIAL EVENTS 2004 -2005 BUDGET CITY COUNCIL APPROVED Expenditures 601 - 532800 Festival of Angels 5,000 12,000 602 - 532800 Employee Christmas Party 1,000 4,500 603 - 532800 Business Appreciation Dinner 13,400 16,000 604 - 532800 4th of July Jubilee 6,500 8,000 605 - 532800 Emergency Service Day 40,000 - 607- 532800 National Night Out 50 50 608 - 532800 Relay for Life 200 200 611 - 532800 Employee Remembrance Day 150 150 615 - 532800 Blue Santa 100 3,000 Total Miscellaneous 66,400 43,900 TOTAL EXPENDITURES 66,400 43,900 129 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. 130 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 314 -HOTEL TAX ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Taxes 43,177 37,688 38,000 37,500 Fund Transfers - - 105,080 9,150 Miscellaneous 2,821 2,713 2,420 5,600 TOTAL REVENUES 45,998 40,401 145,500 52,250' Expenditure Summary Operations Support 448 1,110 10,000 - Professional Services - 1,000 13,500 1,000 Fund Charges 2,500 2,000 119,500 21,500 Capital Outlay - - 15,000 29,750 TOTAL EXPENDITURES' 2,948 4,110 158,000 11 52,250 131 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 314 -HOTEL TAX ACTUAL ACTUAL BUDGET APPROVED General Government REVENUES Taxes 000 - 411800 Hotel Occupancy Tax 43,177 37,688 38,000 37,500 Total Taxes 43,177 37,688 38,000 37,500 Fund Transfers 000 - 481000 Transfer From Reserves - - 105,080 9,150 Total Fund Transfers - - 105,080 9,150 Miscellaneous 000 - 491000 Interest Earned 212 367 200 100 000 - 491200 Investment Income 2,609 2,346 2,220 5,500 Total Miscellaneous 2,821 2,713 2,420 5,600 TOTAL REVENUES 45,998 40,401 145,500 52,250' 132 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 314 -HOTEL TAX ACTUAL ACTUAL BUDGET APPROVED General Government EXPENDITURES Operations 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 Charges 101 - 548600 Interfund Transfers Total Fund Charges Capital Outlay 101 - 581201 Motor Vehicle Refurbish 101 - 581700 Other Improvements Total Capital Outlay 448 - - 1,110 448 1,110 5,000 r -^- UZ.9 . - 12,500 1,000 1,000 - 1,000 13,500 1,000 1,000 2,500 2,000 119,500 21,500 2,500 2,000 119,500 21,500 - 29,750 15,000 - 15,000 29,750 TOTAL NONDEII ARTMENTAL 2,94 4,110 158,000 52,250 133 CITY OF SCHERTZ COMMENTARY PARK FUND FUNCTION: The Parks Fund is a special fund designed to monitor and manage funds for improvement of the City of Schertz Park System. Revenues are derived from developer fees (in lieu of parkland dedication), grants, and donations. 134 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 317 PARK ACTUAL ACTUAL BUDGET APPROVED General Government SUMMARY RECAP Revenue Summary Fees Miscellaneous TOTAL REVENUES Expenditure Summary Other Professional Services Maintenance Services Capital Outlay TOTAL EXPENDITURES 99,735 7,875 20,000 579,400 1,743 2,554 38,250 7,000 101,478 10,429 58,250 586,400 ` IN 135 - 12,500 - 4,403 43,000 100,000 7,980 43,000 58,000 12,383 98,500 158,000 317 PARK General Government REVENUES Fees 000 - 458800 Developers Fees 000 - 458900 Tree Mitigation Total Fees Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Interest 000 - 499100 Transfer In Total Miscellaneous CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED 27,653 7,875 10,000 117,000 72,082 - 10,000 462,400 99,735 7,875 20,000 579,400 130 262 240 1,500 1,613 2,292 2,000 5,500 - - 36,010 - 1,743 2,554 38,250 7,000 TOTAL REVENUES 101,478 10,429 58,250 586,400 136 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 317 -PARK 2002 -2003 ACTUAL 2003 -2004 ACTUAL 2004 -2005 BUDGET CITY COUNCIL APPROVED General Government EXPENDITURES Professional Services 101 - 541300 Other Prof Services - - 12,500 - Total Professional Services - - 12,500 - Maintenance Services 101 - 551110 Trees 660 1,083 40,000 100,000 101 - 551710 Landscaping - 3,320 3,000 - Total Maintenance Services 660 4,403 43,000 100,000 Capital Outlay 101 - 581700 Other Improvements - 7,980 43,000 58,000 Total Capital Outlay - 7,980 43,000 58,000 TOTAL EXPENDITURES 660 12,383 98,500 158,000 137 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. 138 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 318 - RECYLING ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Fees 14,489 22,080 18,000 20,000 TOTAL REVENUES 14,489 22,080 18,000 20,000 Expenditure Summary Maintenance Services 15,091 16,562 18,000 20,000 TOTAL EXPENDITURES 15,091 16,562 18,000" 20,000, 139 CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL 318 - RECYLING ACTUAL ACTUAL BUDGET APPROVED REVENUES Fees 000 - 458200 Sale of Recycle Materials 14,489 22,080 18,000 20,000 Total Fees 14,489 22,080 18,000 20,000 TOTAL REVENUES 14,489 22,080 18,000 20,000 140 318 - RECYLING EXPENDITURES CITY OFSCHERTZ OPERATING BUDGET 2005 -2006 2002 -2003 2003 -2004 2004 -2005 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Maintenance Services 101 - 551510 Payable to Waste Contractor 15,091 Total Maintenance Services 15,091 16,562 12,118 20,000 16,562 12,118 20,000 TOTAL EXPENDITURES 15,091 16,562 12,118 20,000 iiE§l CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 SUMMARY OF WORKING CAPITAL PROJECTS ORIGINAL STATUS 2001 W &S REVENUE BOND ($5,550,000) 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 COMPLETE 290,155 COMPLETE 1,599,740 COMPLETE 740,582 COMPLETE 350,000 ON HOLD 650.000 ON GOING TOTAL 2001 W &S REVENUE BOND; 5,297,828 SR 2003 CITY PROJECTS ($3,360,000) VEHICLES 189,150 COMPLETE EMS AMBULANCE 260,000 COMPLETE EQUIPMENT -EMS 28,000 COMPLETE FURNITURE & FIXTURES - LIBRARY 12,392 COMPLETE EQUIPMENT -FIRE 32,000 COMPLETE SWIMMING POOL 250,000 COMPLETE FEMA MATCH 1,000,000 ON GOING PID 750,000 COMPLETE FIRE SUBSTATION 750.000 ON GOING TOTAL SR 2003 CITY PROJECT BOND 1 3,271,542 142 CITY OF SCHERTZ OPERATING BUDGET 2005 -2006 SUMMARY OF WORKING CAPITAL PROJECTS ORIGINAL STATUS SR 2004 COMMUNITY PROJECT BOND ($7,600,000) LAND PURCHASE 992,770 COMPLETE DRAINAGE PROJECTS 945 - 5551900 AVIATION HEIGHTS 175,000 ON GOING 946- 5551900 BORGFELD RD 850,000 ON GOING 947 - 5551900 ELBEL IMPROVEMENTS 120,000 ON GOING 948 - 5551900 UPPER WEST DIETZ CREEK 565,000 ON GOING 949 - 5551900 WOODLAND OAKS 325,000 ON GOING TOTAL Drainage Projects 2,035,000 BUILDING RENOVATIONS 951 - 5551900 COUNCIL CHAMBERS 1,027,606 ON GOING 952 - 5551900 COMMUNITY CENTER 1,788,160 ON GOING 953 - 5551900 CITY HALL REMODEL 50,000 ON GOING 954 - 5551900 OLD EMS BLDG 156,307 ON GOING 955 - 5551900 OFFICE SPACES 460,186 ON GOING TOTAL Building Projects 3,482,259 Ball Field 957 - 5551900 CONSTRUCTION 1,130,071 ON GOING TOTAL SR2,004 COMMUNITY PROJECT BOND 7,640,100 2005 BOND - PUBLIC IMPROVEMENTS ($3,200,000) Elevated Storage Tank for Lower Zone 944 - 551900 CONSTRUCTION 3,000,480 ON GOING TOTAL SR21005 BOND 3,000.,480 143 THIS PAGE INTENTIONALLY LEFT BLANK I CITY ATTORNEY I POLICE ANIMAL FNTROL PROSECUTING ATTORNEY EXECUTIVE ADMINISTRATIVE ASSISTANT RECORDS MANAGEMENT EMS 111 FIRE COURTSUPPORT PURCHASING GENERAL SERVICES MAYOR AND CITY COUNCIL CITY MANAGER (CM) ASSISTANT CITY MANAGER PUBLIC WORKS DRAINAGE WATER/SWR STREETS FLEET SVS RISK MANAGER PUBLIC INFORMATION OFFICER COMMUNITY SERVICES =PARKS LIBRARY 144 MUNICIPAL COURT JUDGE WARRANT SERVICES OFFICER BAILIFF 1 As of 15 Sep 2005 I CITY SECRETARY I HUMAN Schertz RESOURCES Economic Dev Corp (4 -B CORP) INFORMATION TECHNOLOGY BUSINESS OFFICE FINANCE IPLANNING & ZONING INSPECTIONS/ CODE ENFORCEMENT FY 2005 -2006 POSITION AUTHORIZATION As of 22 September 05 SERVICE POSITION TABLE GRADE AUTHORIZED MANAGEMENT (151) Council City Manager Discretion 1 Assistant City Manager 44 1 Risk Manager 24 1 CITY SECRETARY (164) Council City Secretary Discretion /28 1 Deputy City Secretary 24 1 PUBLIC INFORMATION (170) Public Information Officer 25 1 RECORDS MANAGEMENT (171) Records Manager 28 1 Records Management Clerk 13 1 HUMAN RESOURCES (866) Human Resources Director 26 1 Human Resources Clerk 20 1 INFORMATION TECHNOLOGY (853) Information Techonology Coordinator 35 1 Information Technology Technician 30 1 Information Technology Tecnician 22 1 FINANCE (668) Finance Director 40 1 Accounts Supervisor 28 1 Finance Clerk 18 2 Finance Clerk 12 1 145 POSITION TABLE SERVICE GRADE AUTHORIZED MUNICIPAL COURT (169) Municipal Court Judge /Adstr Council 1 Warrant Officer 28 1 Warrant Officer /Baliff 25 1 Baliff Part Time 23 1 COURT SUPPORT (152) Court Clerk 16 1 Deputy Court Clerk 14 1 Deputy Court Clerk 13 2 ECONOMIC DEVELOPMENT (966) Executive Director 40 Administrative Assistant 20 ED Marketing Research 25 Director Planner I Planning Technician Building Official Inspector Asst Inspector Code Enforcement Officer Administrative Assistant Senior Inspections Clerk PLANNING AND ZONING (154) 38 23 23 INSPECTION DEPARTMENT (258) 30 25 20 20 20 13 1 1 1 1 1 1 1 1 1 1 1 1 146 BUSINESS OFFICE (176) Manager 24 1 Utility Billing Supervisor 21 1 Utility Billing Clerk 14 1 Solid Waste Coordinator 14 1 Cash Collections Clerk 13 1 Collections Clerk 12 1 Receptionist 12 1 Meter Tech 11 15 1 Meter Tech 1 13 2 146 POSITION TABLE SERVICE GRADE AUTHORIZED 147 COMMUNITY SERVICES PARKS (460) Director 40 1 Administrative Assistant 20 1 Park Foreman 20 2 Park Worker 1 14 3 COMMUNITY SERVICES POOLS (463) Assistant Pool Manager /WSI P.T. 8 5 Lifeguards - P.T. 7 20 COMMUNITY SERVICES LIBRARY (665) Library Manager 28 1 Children's Librarian 20 1 Clerk 12 4 Clerk - P.T. 12 7 POLICE DEPARTMENT (256) Chief 42 1 Captain 38 1 Lieutenant 34 2 Sergeant 31 5 Corporal 28 5 Police Officer 25 23 Office Manager 21 1 Records Clerk 14 1 Records Clerk 12 2 Administrative Assistant 20 1 Communications Supervisor 25 1 Communications Officer 17 9 Fire Department Law Enforcement 0 4 Court Warrant Officer 0 2 Bailiff Part Time 0 1 Crossing Guards (P /T) N/A 7 ANIMAL SHELTER MANAGEMENT (762) Supervisor 24 1 Animal Control Officer 17 2 Shelter Operator 11 2 147 POSITION TITLE SERVICE GRADE AUTHORIZED FIRE DEPARTMENT (257) Chief 41 1 Assistant Chief /Fire Marshal 34 1 Deputy Fire Marshal 31 1 Captain 33 3 Training Officer 30 1 Lieutenant 28 6 Firefighter 21 18 Clerk 13 1 EMS DEPARTMENT (280) (Please see the note at the end of the Pay Tables) Director 40 1 EMS Training Manager 30 1 EMS Billing Supervisor 26 1 Paramedic Supervisors 33 3 Paramedic 22 15 Administrative Specialist 20 1 P/T EMT Attendant 17 20 VOE (Vocational Occupational Education) N/A 1 PUBLIC WORKS DEPARTMENT (575) Director 40 1 Asst. Director 35 1 Administrative Assistant 20 1 PW Inspector 21 1 Records and Purchasing 14 1 PW Clerk /Dispatcher 12 1 WATER /WASTEWATER DEPARTMENT (575) SSLGC GENERAL MANAGER N/A 1 Supervisor 30 1 Foreman 20 1 Serviceman II 17 4 Serviceman 1 14 5 STREET DEPARTMENT (359) Foreman 20 1 Street Worker 11 17 2 Street Sweeper Operator 17 1 Street Worker 1 14 7 148 POSITION TABLE SERVICE GRADE AUTHORIZED DRAINAGE AND RIGHT OF WAY MAINTENANCE (579) Environmental /QC Supervisor 30 1 Foreman 20 1 Worker 1 14 3 FLEET SERVICES (877) Mechanic /Foreman 18 1 Mechanic 16 1 Mechanic 14 1 FACILITY MAINTENANCE (161) Facility Manager 25 1 Assistant Facility Manager 19 1 Facility Worker 14 1 Custodian 1 11 3 Custodian I Part Time 11 1 TOTAL FULL TIME 213 TOTAL PART TIME 62 TOTAL Note: The above totals include these added positions for the FY: 1 SSLGC - GENERAL MANAGER 1 FT Fire Fighter 1 FT IT Technician 1 ED Marketing Research 1 Drainage Worker 2 Part Time Library Clerks 1 Full Time Custodian, 3 mos end of year 149 THIS PAGE INTENTIONALLY LEFT BLANK FY 2005/2006 Pay Tables Effective 1 October 2005 150 Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Step 9 Step 10 Step 11 Step 12 Step 13 Step 14 Step 15 SG 5 Hour 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 BiWeek 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 Month 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 Annual 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 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 BiWeek 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 Month 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 Annual 18418 18786 19162 19545 19936 20335 20741 21156 21579 22011 22451 22900 23358 23825 24302 150 Step 1 Step 2 Step 3 Step 4 SG 11 Hour 9.21 9.39 9.58 9.77 BiWeek 736.71 751.44 766.47 781.80 Month 1596.20 1628.12 1660.69 1693.90 Annual 19154 19537 19928 20327 SG 12 Hour 9.58 9.77 9.96 10.16 BiWeek 766.18 781.50 797.13 813.07 Month 1660.05 1693.25 1727.11 1761.66 Annual 19921 20319 20725 21140 SG 13 Hour 9.96 10.16 10.36 10.57 BiWeek 796.82 812.76 829.01 845.59 Month 1726.45 1760.98 1796.20 1832.12 Annual 20717 21132 21554 21985 SG 14 Hour 10.36 10.57 10.78 10.99 BiWeek 828.70 845.27 862.18 879.42 Month 1795.51 1831.42 1868.05 1905.41 Annual 21546 21977 22417 22865 SG 15 Step 5 9.97 797.44 1727.78 20733 10.37 829.33 1796.89 21563 10.78 862.51 1868.76 22425 11.21 897.01 1943.52 23322 FY 2005/2006 Pay Tables Effective 1 October 2005 Step 6 10.17 813.38 1762.33 21148 10.57 845.92 1832.83 21994 11.00 879.76 1906.14 22874 11.44 914.95 1982.39 23789 Step 7 Step 8 Step 9 10.37 10.58 10.79 829.65 846.25 863.17 1797.58 1833.53 1870.20 21571 22002 22442 10.79 11.00 11.22 862.84 880.10 897.70 1869.48 1906.87 1945.01 22434 22882 23340 11.22 11.44 11.67 897.35 915.30 933.61 1944.26 1983.15 2022.81 23331 23798 24274 11.67 11.90 12.14 933.25 951.91 970.95 2022.03 2062.47 2103.72 24264 24750 25245 Step 10 11.01 880.43 1907.61 22891 11.45 915.65 1983.91 23807 11.90 952.28 2063.27 24759 12.38 990.37 2145.80 25750 Step 11 11.23 898.04 1945.76 23349 11.67 933.96 2023.59 24283 12.14 971.32 2104.53 25254 12.63 1010.18 2188.71 26265 Step 12 Step 13 11.45 11.68 916.00 934.32 1984.67 2024.37 23816 24292 11.91 12.15 952.64 971.70 2064.06 2105.34 24769 25264 12.38 12.63 990.75 1010.56 2146.62 2189.56 25759 26275 12.88 13.14 1030.38 1050.99 2232.49 2277.14 26790 27326 Step 14 11.91 953.01 2064.85 24778 12.39 991.13 2147.45 25769 12.88 1030.78 2233.35 26800 13.40 1072.01 2322.68 27872 Step 15 12.15 972.07 2106.15 25274 12.64 1010.95 2190.40 26285 13.14 1051.3E 2278.01 2733E 13.67 1093.45 2369.13 28430 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 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 BiWeek 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 Month 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 Annual 23304 23770 24246 24731 25225 25730 26244 26769 27305 27851 28408 28976 29555 30147 30749 151 SG 17 Hour BiWeek Month Annual SG 18 Hour BiWeek Month Annual SG 19 Hour BiWeek Month Annual SG 20 Hour BiWeek Month Annual SG 21 FY 2005/2006 Pay Tables Effective 1 October 2005 Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Step 9 Step 10 Step 11 Step 12 Step 13 Step 14 Step 15 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 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 12.60 12.86 13.11 13.37 13.64 1008.24 1028.40 1048.97 1069.95 1091.35 2184.51 2228.20 2272.76 2318.22 2364.58 26214 26738 27273 27819 28375 13.11 13.37 13.64 13.91 14.19 1048.56 1069.54 1090.93 1112.75 1135.00 2271.89 2317.33 2363.67 2410.95 2459.17 27263 27808 28364 28931 29510 13.91 14.19 14.48 14.77 15.06 1113.17 1135.44 1158.15 1181.31 1204.93 2411.88 2460.11 2509.32 2559.50 2610.69 28943 29521 30112 30714 31328 14.47 14.76 15.06 15.36 15.66 1157.70 1180.85 1204.47 1228.56 1253.13 2508.35 2558.52 2609.69 2661.88 2715.12 30100 30702 31316 31943 32581 15.36 15.67 1229.03 1253.61 2662.91 2716.16 31955 32594 15.98 16.30 1278.19 1303.76 2769.42 2824.81 33233 33898 15.98 1278.69 2770.49 33246 16.62 1329.83 2881.31 34576 16.30 16.63 1304.26 1330.35 2825.90 2882.41 33911 34589 16.96 17.29 1356.43 1383.56 2938.93 2997.71 35267 35973 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 BiWeek 1134.13 1156.81 1179.95 1203.55 1227.62 Month 2457.28 2506.42 2556.55 2607.68 2659.84 Annual 29487 30077 30679 31292 31918 15.65 15.97 16.28 16.61 16.94 17.28 1252.17 1277.21 1302.76 1328.81 1355.39 1382.50 2713.03 2767.29 2822.64 2879.09 2936.67 2995.41 32556 33208 33872 34549 35240 35945 152 17.63 17.98 18.34 18.71 1410.15 1438.35 1467.11 1496.46 3055.31 3116.42 3178.75 3242.32 36664 37397 38145 38908 SG 23 Hour BiWeek Month Annual SG 24 Hour BiWeek Month Annual SG 25 FY 2005/2006 Pay Tables Effective 1 October 2005 Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Step 9 Step 10 Step 11 Step 12 Step 13 Step 14 Step 15 14.74 15.04 1179.49 1203.08 2555.57 2606.68 30667 31280 15.33 15.64 1226.67 1251.21 2657.79 2710.95 31893 32531 15.34 1227.14 2658.81 31906 15.95 1276.23 2765.16 33182 15.65 1251.69 2711.99 32544 16.27 1301.75 2820.47 33846 15.96 1276.72 2766.23 33195 16.60 1327.79 2876.88 34523 Hour 15.95 16.27 16.59 16.92 17.26 BiWeek 1275.74 1301.25 1327.28 1353.82 1380.90 Month 2764.10 2819.38 2875.77 2933.29 2991.95 Annual 33169 33833 34509 35199 35903 SG 26 16.28 1302.26 2821.55 33859 16.93 1354.35 2934.42 35213 16.60 16.94 17.27 1328.30 1354.87 1381.96 2877.98 2935.54 2994.25 34536 35227 35931 17.27 17.61 17.97 1381.43 1409.06 1437.24 2993.10 3052.97 3114.02 35917 36636 37368 17.62 1409.60 3054.14 36650 18.32 1465.99 3176.31 38116 17.61 17.96 18.32 18.68 19.06 1408.52 1436.69 1465.42 1494.73 1524.63 3051.79 3112.83 3175.08 3238.59 3303.36 36622 37354 38101 38863 39640 17.97 1437.80 3115.22 37383 18.69 1495.31 3239.83 38878 18.33 18.70 1466.55 1495.88 3177.53 3241.08 38130 38893 19.07 19.45 1525.21 1555.72 3304.63 3370.72 39656 40449 19.07 1525.80 3305.90 39671 19.84 1586.83 3438.14 41258 19.4E 1556.32 3372.02 40464 20.23 1618.57 3506.90 42083 19.44 19.83 20.22 20.63 21.04 1555.12 1586.22 1617.95 1650.30 1683.31 3369.42 3436.81 3505.55 3575.66 3647.17 40433 41242 42067 42908 43766 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 BiWeek 1379.84 1407.44 1435.59 1464.30 1493.58 Month 2989.65 3049.45 3110.43 3172.64 3236.10 Annual 35876 36593 37325 38072 38833 SG 28 Hour 17.94 18.30 18.66 19.04 19.42 BiWeek 1435.03 1463.73 1493.01 1522.87 1553.33 Month 3109.24 3171.42 3234.85 3299.55 3365.54 Annual 37311 38057 38818 39595 40386 19.04 19.42 19.81 20.21 20.61 1523.45 1553.92 1585.00 1616.70 1649.04 3300.82 3366.83 3434.17 3502.85 3572.91 39610 40402 41210 42034 42875 19.80 20.20 20.61 21.02 21.44 1584.39 1616.08 1648.40 1681.37 1715.00 3432.85 3501.51 3571.54 3642.97 3715.83 41194 42018 42858 43716 44590 153 21.03 21.45 1682.02 1715.66 3644.37 3717.26 43732 44607 21.87 22.30 1749.30 1784.28 3790.14 3865.95 45482 46391 21.87 1749.97 3791.60 45499 22.75 1819.97 3943.27 47319 22.31 22.76 1784.97 1820.67 3867.43 3944.78 46409 47337 23.20 23.67 1856.37 1893.50 4022.13 4102.57 48266 49231 FY 2005/2006 Pay Tables Effective 1 October 2005 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 154 Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Step 9 Step 10 Step 11 Step 12 Step 13 Step 14 Step 15 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 30 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 154 Step 1 Step 2 Step 3 Step 4 SG 35 Hour 23.61 24.08 24.56 25.05 BiWeek 1888.41 1926.17 1964.70 2003.99 Month 4091.55 4173.38 4256.84 4341.98 Annual 49099 50081 51082 52104 SG 36 Hour 24.55 BiWeek 1963.94 Month 4255.21 Annual 51062 SG 37 Hour 25.53 BiWeek 2042.50 Month 4425.42 Annual 53105 SG 38 25.04 2003.22 4340.31 52084 26.04 2083.35 4513.92 54167 25.54 26.05 2043.29 2084.15 4427.12 4515.66 53125 54188 26.56 27.09 2125.02 2167.52 4604.20 4696.29 55250 56355 Step 5 25.55 2044.07 4428.82 53146 26.57 2125.83 4605.97 55272 27.64 2210.87 4790.21 57483 FY 2005/2006 Pay Tables Effective 1 October 2005 Step 6 26.06 2084.95 4517.40 54209 27.10 2168.35 4698.09 56377 28.19 2255.08 4886.02 58632 Step 7 Step 8 Step 9 Step 10 Step 11 Step 12 Step 13 Step 14 Step 15 26.58 27.11 27.66 28.21 28.77 29.35 29.94 30.54 31.15 2126.65 2169.18 2212.57 2256.82 2301.96 2348.00 2394.96 2442.85 2491.71 4607.75 4699.90 4793.90 4889.78 4987.57 5087.32 5189.07 5292.85 5398.71 55293 56399 57527 58677 59851 61048 62269 63514 64784 27.65 28.20 28.76 2211.72 2255.95 2301.07 4792.06 4887.90 4985.65 57505 58655 59828 28.75 29.33 29.91 2300.19 2346.19 2393.11 4983.74 5083.41 5185.08 59805 61001 62221 29.34 2347.09 5085.37 61024 30.51 2440.98 5288.78 63465 29.93 2394.03 5187.07 62245 31.12 2489.80 5394.56 64735 30.52 31.13 2441.92 2490.75 5290.82 5396.63 63490 64760 31.74 32.38 2539.59 2590.38 5502.45 5612.50 66029 67350 31.76 2540.57 5504.57 66055 33.03 2642.19 5724.75 68697 32.39 2591.38 5614.6E 67376 33.69 2695.04 5839.24 70071 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 40 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 155 SG 41 Hour BiWeek Month Annual SG 42 Hour BiWeek Month Annual SG 43 Hour BiWeek Month Annual SG 44 Hour BiWeek Month Annual SG 45 Hour BiWeek Month Annual SG 46 Hour BiWeek Month . Annual FY 2005/2006 Pay Tables Effective 1 October 2005 Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Step 9 Step 10 Step 11 Step 12 Step 13 Step 14 Step 15 29.87 30.47 31.07 31.70 32.33 2389.44 2437.22 2485.97 2535.69 2586.40 5177.11 5280.65 5386.27 5493.99 5603.87 62125 63368 64635 65928 67246 31.06 31.68 32.32 32.96 33.62 2485.01 2534.71 2585.41 2637.12 2689.86 5384.20 5491.88 5601.72 5713.75 5828.03 64610 65903 67221 68565 69936 32.31 32.95 33.61 34.28 34.97 2584.41 2636.10 2688.82 2742.60 2797.45 5599.56 5711.55 5825.79 5942.30 6061.15 67195 68539 69909 71308 72734 33.60 34.27 34.95 35.65 36.37 2687.79 2741.55 2796.38 2852.30 2909.35 5823.55 5940.02 6058.82 6179.99 6303.59 69883 71280 72706 74160 75643 34.94 35.64 36.35 37.08 37.82 2795.30 2851.21 2908.23 2966.40 3025.72 6056.49 6177.62 6301.17 6427.19 6555.74 72678 74131 75614 77126 78669 36.34 37.07 37.81 38.56 39.33 2907.11 2965.26 3024.56 3085.05 3146.75 6298.75 6424.72 6553.22 6684.28 6817.97 75585 77097 78639 80211 81816 32.98 33.64 34.31 35.00 35.69 2638.13 2690.89 2744.71 2799.60 2855.60 5715.95 5830.27 5946.87 6065.81 6187.13 68591 69963 71362 72790 74246 34.30 34.98 35.68 36.39 37.12 2743.66 2798.53 2854.50 2911.59 2969.82 5944.59 6063.48 6184.75 6308.44 6434.61 71335 72762 74217 75701 77215 35.67 36.38 37.11 37.85 38.61 2853.40 2910.47 2968.68 3028.05 3088.61 6182.37 6306.02 6432.14 6560.78 6692.00 74188 75672 77186 78729 80304 37.09 37.84 38.59 39.36 40.15 2967.54 3026.89 3087.43 3149.17 3212.16 6429.67 6558.26 6689.42 6823.21 6959.68 77156 78699 80273 81879 83516 38.58 39.35 40.14 40.94 41.76 3086.24 3147.96 3210.92 3275.14 3340.64 6686.85 6820.59 6957.00 7096.14 7238.06 80242 81847 83484 85154 86857 40.12 40.92 41.74 42.58 43.43 3209.69 3273.88 3339.36 3406.15 3474.27 6954.33 7093.41 7235.28 7379.99 7527.59 83452 85121 86823 88560 90331 156 36.41 37.14 37.88 38.64 39.41 2912.71 2970.96 3030.38 3090.99 3152.81 6310.87 6437.09 6565.83 6697.15 6831.09 75730 77245 78790 80366 81973 37.87 38.62 39.39 40.18 40.99 3029.22 3089.80 3151.60 3214.63 3278.92 6563.30 6694.57 6828.46 6965.03 7104.33 78760 80335 81942 83580 85252 39.38 40.17 40.97 41.79 42.63 3150.39 3213.39 3277.66 3343.21 3410.08 6825.84 6962.35 7101.60 7243.63 7388.50 81910 83548 85219 86924 88662 40.96 41.77 42.61 43.46 44.33 3276.40 3341.93 3408.77 3476.94 3546.48 7098.87 7240.85 7385.66 7533.38 7684.04 85186 86890 88628 90401 92209 42.59 43.45 44.31 45.20 46.10 3407.46 3475.61 3545.12 3616.02 3688.34 7382.82 7530.48 7681.09 7834.71 7991.41 88594 90366 92173 94017 95897 44.30 45.18 46.09 47.01 47.95 3543.76 3614.63 3686.92 3760.66 3835.88 7678.14 7831.70 7988.33 8148.10 8311.06 92138 93980 95860 97777 99733 FY 2005/2006 Pay Tables Effective 1 October 2005 SG 47 Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Step 9 Step 10 Step 11 Step 12 Step 13 Step 14 Step 15 Hour 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 BiWeek 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 Month 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 Annual 78608 80181 81784 83420 85088 86790 88526 90296 92102 93944 95823 97740 99694 101688 103722 SG 48 Hour 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 BiWeek 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 Month 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 Annual 81753 83388 85056 86757 88492 90262 92067 93908 95786 97702 99656 101649 103682 105756 107871 SG 49 Hour 40.88 BiWeek 3270.11 Month 7085.23 Annual 85023 SG 50 Hour 42.51 BiWeek 3400.91 Month 7368.64 Annual 88424 41.69 3335.51 7226.94 86723 43.36 3468.93 7516.02 90192 42.53 43.38 3402.22 3470.26 7371.48 7518.91 88458 90227 44.23 45.11 3538.31 3609.08 7666.34 7819.66 91996 93836 44.25 3539.67 7669.28 92031 46.02 3681.26 7976.06 95713 45.13 3610.46 7822.67 93872 46.94 3754.88 8135.58 97627 46.03 46.95 47.89 3682.67 3756.33 3831.45 7979.12 8138.71 8301.48 95749 97664 99618 47.87 48.83 49.81 3829.98 3906.58 3984.71 8298.29 8464.25 8633.54 99579 101571 103602 48.85 3908.08 8467.51 101610 50.81 4064.40 8806.21 105675 49.83 3986.24 8636.86 103642 51.82 4145.69 8982.33 107788 50.82 51.84 4065.97 4147.29 8809.60 8985.79 105715 107829 52.86 53.91 4228.61 4313.18 9161.98 9345.22 109944 112143 Note: This table does not apply to EMS Personel Working 24148 Shifts. Computation of Hourly rates and Overtime Compensation is governed by The Fair Labor Standards Handbook, Section 520, Irregular Hours. 157 52.88 4230.23 9165.51 109986 54.99 4399.44 9532.13 114386 53.94 4314.84 9348.82 112186 56.09 4487.43 9722.77 116673 2005/2006 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 original 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 Return to Duty Employee's returning 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 158 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 one (1) year. 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. 159 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 hourly equivalent of required periods 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 160 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 twelve 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. 161 2005/2006 TRAVEL, TRAINING, AND CONFERENCE PROCEDURES 1. Travel Advances If travel expense advances are to be obtained, requests should be made on forms required by the Finance Department, and the employee's Department head must forward the employee's request to the City Manager for consideration. If approved, the City Manager will forward the request to the Finance Department for processing. 2. Per Diem Allowance The per diem allowance shall cover actual expenses for lodging, meals, tips, and transportation between the place(s) where business is conducted and where lodging and /or meals are provided, but not to exceed the amounts approved from time to time by the City Council. In instances where actual expenses exceed the maximum per diem allowable, written approval must be obtained from the City Manager before such payment can be made. In computing per diem expenses for travel continuing over a 24 -hour period, the calendar day (midnight to midnight) will be the unit. For travel of less than 24 hours or if lodging is not required, the per diem rate should be adjusted downward to only reflect costs for meals and other incidentals. 3. Air Travel If possible, employees will travel in "coach class" flight status. First -class or business class flight passage is allowed only in instances where the first -class or business -class travel serves the best interest of the City, as approved by the City Manager. Round trip tickets should be purchased if possible and if it is financially advantageous to the City to do so. Unused transportation tickets must be returned to the City's Finance Department. 4. City Vehicles When automobile is the chosen mode of transportation for travel, City -owned vehicles are to be used if available. If feasible and convenient to do so, employees should pool their vehicle transportation, particularly on short trips involving several employees. 5. Personal Vehicles City employees may use private automobiles for travel only in cases where a City -owned vehicle is not available. In such cases, the employee will be reimbursed at the reimbursable expense rate per mile allowable by Internal Revenue Service regulations, as in effect from time to time. Mileage should be computed from the latest official map published by the Texas Highway 162 Department for trips made inside the State. Mileage driven outside of the State will be computed from the latest official maps published by the American Automobile Association. When personal automobiles are used, total mileage to be considered for reimbursement shall in no case exceed the cost of first -class air passage if such service is available. The payment of such mileage will be based on the most direct route from the point of departure to the point of destination. 6. Official Long Distance Calls Charges for long distance telephone calls on official business will be allowed provided that the call is charged to the appropriate Department's telephone number used for long distance calls. 7. Registration Fees Conference and /or training registration fees approved by the City Manager will be paid in full by the City in addition to per diem allowance. 8. Car Rental If a car is rented while an employee is traveling, it must be the most practical means of transportation available. 9. Accompaniment by Spouses When the City Manager determines that it is appropriate in order to properly represent the City, spouses may accompany the employee on official City business. The spouse's expenses will be reimbursed on the same basis as the employee's expenses. 10. Procedures for Reimbursement In order to receive reimbursement for incurred expenses, the employee should submit the forms required by the Finance Department with all required receipts or vouchers to verify all expenses for which the employee seeks reimbursement. All forms shall be routed from the employee to his or her Department head who will route the forms to the City Manager. Department heads and other individuals not responsible to a Department head will route their forms directly to the City Manager. In all cases, the City Manager's authorization and approval is required before any travel expenses are reimbursed by the Finance Department. 163 THIS PAGE INTENTIONALLY LEFT BLANK DEBT SERVICE REVIEW General Fund Year 2006 2007 2008 2009 2010 2011 1992 $ 117,080 $ 110,830 $ 74,480 $ - $ - - 2001 345,970 346,070 346,470 348,075 349,980 351,318 -to 2021 2003 337,858 282,858 243,089 243,270 247,480 250,820 -to 2018 2004 606,736 541,636 615,936 628,036 604,227 590,008 -to 2024 Total $1,407,644 $1,281,394 $1,279,975 $1,219,381 $1,201,687 $1,192,146 Water and Waste Water Debt Service Year 2006 2007 2008 2009 2010 2011 1974 $ 7,700 $ 8,400 $ 8,050 $ 7,700 $ 7,350 $ - 2001 488,660 482,350 470,550 468,381 368,131 368,671 - to 2021 2005 256,305 236,519 237,994 234,169 234,956 235,331 - to 2025 Total $ 752,665 $ 727,269 $ 716,594 $ 710,250 $ 610,437 $ 604,002 Schertz- Seguin Local Government Corporation Debt - Schertz Portion Year 2006 2007 2008 2009 2010 2011 1999 $ 154,852 $ 155,881 $ 156,526 $ 159,224 $ 158,972 $ - 2001 1,170,960 1,171,159 1,171,033 1,168,124 1,167,409 1,166,341 - to 2041 2005 199,527 201,165 200,228 201,691 200,574 361,302 -to 2025 Total $1,525,339 $1,528,205 $1,527,787 $1,529,039 $1,526,955 $1,527,643 Schertz Economic Development Corporation 413 Debt Year 2006 2007 2008 2009 2010 2011 1998 $ 381,486 $ 378,098 $ 378,914 $ 373,933 $ 375,673 $ 379,156 - to 2018 2001 166,400 - - - - - Total $ 547,886 $ 378,098 $ 378,914 $ 373,933 $ 375,673 $ 379,156 164 CITY OF SCHERTZ General Obligation Bonds, Series 1992 Street Improvements 6.25% For 2006, 6.35% For 2007, 6.04% For 2008. Amount issued: $620,000 Date Principal Interest Period Total Fiscal Totai 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 $270,000.00 $32,390.00 $302,390.00 Paying Agent: The Bank of New York 165 CITY OF SCHERTZ Certificate of Obligation Bonds, Series 2001 Schertz Parkway Project Amount issued: $4,500,000 Date Principal Interest Period Total Fiscal Total 2/1/2006 160,000.00 95,385.00 255,385.00 8/1/2006 90,585.00 90,585.00 $345,970.00 2/1/2007 170,000.00 90,585.00 260,585.00 8/1/2007 85,485.00 85,485.00 $346,070.00 2/1/2008 180,000.00 85,485.00 265,485.00 8/1/2008 80,985.00 80,985.00 $346,470.00 2/1/2009 190,000.00 80,985.00 270,985.00 8/1/2009 77,090.00 77,090.00 $348,075.00 2/1/2010 200,000.00 77,090.00 277,090.00 8/1/2010 72,890.00 72,890.00 $349,980.00 2/1/2011 210,000.00 72,890.00 282,890.00 8/1/2011 68,427.50 68,427.50 $351,317.50 2/1/2012 225,000.00 68,427.50 293,427.50 8/1/2012 63,477.50 63,477.50 $356,905.00 2/1/2013 235,000.00 63,477.50 298,477.50 8/1/2013 58,190.00 58,190.00 $356,667.50 2/1/2014 250,000.00 58,190.00 308,190.00 8/1/2014 52,440.00 52,440.00 $360,630.00 2/1/2015 260,000.00 52,440.00 312,440.00 8/1/2015 46,330.00 46,330.00 $358,770.00 2/1/2016 275,000.00 46,330.00 321,330.00 8/1/2016 39,730.00 39,730.00 $361,060.00 2/1/2017 290,000.00 39,730.00 329,730.00 8/1/2017 32,625.00 32,625.00 $362,355.00 2/1/2018 300,000.00 32,625.00 332,625.00 8/1/2018 25,125.00 25,125.00 $357,750.00 2/1/2019 320, 000.00 25,125.00 345,125.00 8/1/2019 17,125.00 17,125.00 $362,250.00 2/1/2020 335,000.00 17,125.00 352,125.00 8/1/2020 8,750.00 8,750.00 $360,875.00 2/1/2021 350,000.00 8,750.00 358,750.00 8/1/2021 0.00 $358,750.00 $ 3,950,000.00 $ 1,733,895.00 $ 5,683,895.00 Paying Agent: The Bank of New York 166 CITY OF SCHERTZ Combination Tax and Ltd Pledge Revenue Certificates of Obligation, Series 2003 Amount of Issue: $3,360,000 Date Principal Interest Period Total Fiscal Total 2/1/2006 250,000.00 45,178.75 295,178.75 8/1/2006 42,678.75 42,678.75 $337,857.50 2/1/2007 200,000.00 42,678.75 242,678.75 8/1/2007 40,178.75 40,178.75 $282,857.50 2/1/2008 165, 000.00 40,178.75 205,178.75 8/1/2008 37,910.00 37,910.00 $243,088.75 2/1/2009 170,000.00 37,910.00 207,910.00 8/1/2009 35,360.00 35,360.00 $243,270.00 2/1/2010 180,000.00 35,360.00 215,360.00 8/1/2010 32,120.00 32,120.00 $247,480.00 2/1/2011 190, 000.00 32,120.00 222,120.00 8/1/2011 28,700.00 28,700.00 $250,820.00 2/1/2012 200,000.00 28,700.00 228,700.00 8/1/2012 25,100.00 25,100.00 $253,800.00 2/1/2013 210,000.00 25,100.00 235,100.00 8/1/2013 21,267.50 21,267.50 $256,367.50 2/1/2014 220,000.00 21,267.50 241,267.50 8/1/2014 17,362.50 17,362.50 $258,630.00 2/1/2015 225,000.00 17,362.50 242,362.50 8/1/2015 13,312.50 13,312.50 $255,675.00 2/1/2016 225,000.00 13,312.50 238,312.50 8/1/2016 9,150.00 9,150.00 $247,462.50 2/1/2017 225,000.00 9,150.00 234,150.00 8/1/2017 4,875.00 4,875.00 $239,025.00 2/1/2018 250,000.00 4,875.00 254,875.00 8/1/2018 $254,875.00 $2,710,000.00 $ 661,208.75 $3,371,208.75 Paying Agent: J.P. Morgan Chase Bank 167 CITY OF SCHERTZ Combination Tax and Ltd Pledge Revenue Certificates of Obligation, Series 2004 Amount of Issue: $ 7,750,000 Date Principal Interest Period Total Fiscal Total 2/11/2006 280, 000.00 166,168.13 446,168.13 8/11/2006 160, 568.13 160, 568.13 $606,736.26 2/1/2007 225,000.00 160,568.13 385,568.13 8/1/2007 156,068.13 156,068.13 $541,636.26 2/11/2008 310, 000.00 156, 068.13 466, 068.13 8/1/2008 149, 868.13 149, 868.13 $615,936.26 2/11/2009 335, 000.00 149, 868.13 484, 868.13 8/1/2009 143,168.13 143,168.13 $628,036.26 2/1/2010 325, 000.00 143,168.13 468,168.13 8/1/2010 136,058.75 136,058.75 $604,226.88 2/1/2011 325, 000.00 136, 058.75 461, 058.75 8/1/2011 128,949.38 128,949.38 $590,008.13 2/1/2012 315,000.00 128,949.38 443,949.38 8/11/2012 122, 058.75 122, 058.75 $566,008.13 2/1/2013 325,000.00 122,058.75 447,058.75 8/11/2013 115,152.50 115,152.50 $562,211.25 2/11/2014 325, 000.00 115,152.50 440,152.50 8/1/2014 108,652.50 108,652.50 $548,805.00 2/1/2015 325,000.00 108,652.50 433,652.50 8/1/2015 101,990.00 101,990.00 $535,642.50 2/1/2016 325, 000.00 101, 990.00 426, 990.00 8/11/2016 95,165.00 95,165.00 $522,155.00 2/1/2017 350, 000.00 95,165.00 445,165.00 8/1/2017 87,640.00 87,640.00 $532,805.00 2/1/2018 350, 000.00 87, 640.00 437, 640.00 8/1/2018 79,983.75 79,983.75 $517,623.75 2/1/2019 460,000.00 79,983.75 539,983.75 8/1/2019 69,863.75 69,863.75 $609,847.50 2/11/2020 460, 000.00 69, 863.75 529, 863.75 8/1/2020 59, 513.75 59, 513.75 $589,377.50 2/1/2021 480, 000.00 59, 513.75 539, 513.75 8/1/2021 48,593.75 48,593.75 $588,107.50 2/1/2022 675, 000.00 48, 593.75 723, 593.75 8/1/2022 32,900.00 32,900.00 $756,493.75 2/1/2023 700, 000.00 32, 900.00 732, 900.00 8/1/2023 16,450.00 16,450.00 $749,350.00 2/1/2024 700,000.00 16,450.00 716,450.00 9/30/2024 $716,450.00 $ 7,590,000.00 $ 3,791,456.93 $ 11,381,456.93 168 CITY OF SCHERTZ General Obligation Bonds, 4B Series 1998 Sales Tax Supported, Public Safety Complex Construction Bond Amount of issue: $4,930,000 Date Principal Interest Period Total Fiscal Total 2/1/2006 205,000.00 91,510.00 296,510.00 8/1/2006 84,975.63 84,975.63 $381,485.63 2/1/2007 215,000.00 84,975.63 299,975.63 8/1/2007 78,122.50 78,122.50 $378,098.13 2/1/2008 230, 000.00 78,122.50 308,122.50 8/1/2008 70,791.25 70,791.25 $378,913.75 2/1/2009 240,000.00 70,791.25 310,791.25 8/1/2009 63,141.25 63,141.25 $373,932.50 2/1/2010 255, 000.00 63,141.25 318,141.25 8/1/2010 57,531.25 57,531.25 $375,672.50 2/1/2011 270,000.00 57,531.25 327,531.25 8/11/2011 51,625.00 51,625.00 $379,156.25 2/1/2012 285,000.00 51,625.00 336,625.00 8/1/2012 45,390.63 45,390.63 $382,015.63 2/1/2013 300,000.00 45,390.63 345,390.63 8/1/2013 38,828.13 38,828.13 $384,218.76 2/1/2014 315, 000.00 38, 828.13 353, 828.13 8/1/2014 31,937.50 31,937.50 $385,765.63 2/1/2015 335,000.00 31,937.50 366,937.50 8/1/2015 24,609.38 24,609.38 $391,546.88 2/1/2016 355,000.00 24,609.38 379,609.38 8/1/2016 16,843.75 16,843.75 $396,453.13 2/1/2017 375,000.00 16,843.75 391,843.75 8/1/2017 8,640.63 8,640.63 $400,484.38 2/1/2018 395,000.00 8,640.63 403,640.63 8/1/2018 $403,640.63 $3,775,000.00 $1,236,383.80 $5,011,383.80 Paying Agent: J.P. Morgan Chase Bank 169 CITY OF SCHERTZ Utility System Revenue & Refunding Bonds, Series 2001 Amount Issued: $5,500,000 Date Principal Interest Period Total Fiscal Total 3/1/2006 99, 330.00 99, 330.00 9/1/2006 290, 000.00 99, 330.00 389, 330.00 $ 488, 660.00 3/1/2007 93,675.00 93,675.00 9/1/2007 295,000.00 93,675.00 388,675.00 $ 482,350.00 3/1/2008 87, 775.00 87, 775.00 9/1/2008 295, 000.00 87, 775.00 382, 775.00 $ 470, 550.00 3/1/2009 81,690.63 81,690.63 9/1/2009 305,000.00 81,690.63 386,690.63 $468,381.26 3/1/2010 74,065.63 74,065.63 9/1/2010 220,000.00 74,065.63 294,065.63 $ 368,131.26 3/1/2011 69, 335.63 69, 335.63 9/1/2011 230,000.00 69,335.63 299,335.63 $ 368,671.26 3/1/2012 64,275.63 64,275.63 9/1/2012 240,000.00 64,275.63 304,275.63 $ 368,551.26 3/1/2013 58,815.63 58,815.63 9/1/2013 250,000.00 58,815.63 308,815.63 $ 367,631.26 3/1/2014 53, 003.13 53, 003.13 9/1/2014 265, 000.00 53, 003.13 318, 003.13 $ 371, 006.26 3/1/2015 46, 709.38 46, 709.38 9/1/2015 280,000.00 46,709.38 326,709.38 $ 373,418.76 3/1/2016 39, 919.38 39, 919.38 9/1/2016 290,000.00 39,919.38 329,919.38 $ 369,838.76 3/1/2017 32,669.38 32,669.38 9/1/2017 295,000.00 32,669.38 327,669.38 $ 360,338.76 3/1/2018 25,294.38 25,294.38 9/1/2018 230,000.00 25,294.38 255,294.38 $ 280,588.76 3/1/2019 19, 544.38 19, 544.38 9/1/2019 240, 000.00 19, 544.38 259, 544.38 $ 279, 088.76 3/1/2020 13,424.38 13,424.38 9/1/2020 255,000.00 13,424.38 268,424.38 $ 281,848.76 3/1/2021 6,890.00 6,890.00 9/1/2021 265, 000.00 6,890.00 271, 890.00 $ 278, 780.00 $ 4, 245, 000.00 $1, 732, 835.12 $ 5, 977, 835.12 Paying Agent: The Bank of New York 170 The Schertz /Seguin Local Government Corporation Contract Revenue Bonds Paid 1/2 Schertz, 1/2 Seguin Fiscal Year Schertz Debt Ending 9/30 Series 1999 Series 2001 Refunding 2005 Total Payment 2006 $309,703 $2,341,920 $399,055 $3,050,678 $1,525,339 2007 311,763 2,342,318 402,330 3,056,410 $1,528,205 2008 313,053 2,342,065 400,455 3,055,573 $1,527,787 2009 318,447 2,336,249 403,383 3,058,079 $1,529,039 2010 317,944 2,334,818 401,149 3,053,910 $1,526,955 2011 2,332,681 722,605 3,055,286 $1,527,643 2012 2,329,926 727,418 3,057,344 $1,528,672 2013 2,331,348 726,036 3,057,384 $1,528,692 2014 2,322,010 728,436 3,050,446 $1,525,223 2015 2,321,925 734,936 3,056,861 $1,528,431 2016 2,320,625 735,536 3,056,161 $1,528,081 2017 2,313,375 740,236 3,053,611 $1,526,806 2018 2,320,250 739,036 3,059,286 $1,529,643 2019 2,315,881 737,036 3,052,918 $1,526,459 2020 2,315,381 738,844 3,054,225 $1,527,113 2021 2,308,453 739,194 3,047,647 $1,523,823 2022 2,309,938 738,201 3,048,139 $1,524,069 2023 2,310,078 740,735 3,050,813 $1,525,407 2024 2,308,875 741,661 3,050,536 $1,525,268 2025 2,311,194 740,859 3,052,053 $1,526,027 2026 3,095,266 3,095,266 $1,547,633 2027 3,094,881 3,094,881 $1,547,441 2028 3,095,331 3,095,331 $1,547,666 2029 3,096,347 3,096,347 $1,548,173 2030 3,092,794 3,092,794 $1,546,397 2031 3,105,705 3,105,705 $1,552,853 2032 3,109,765 3,109,765 $1,554,883 2033 3,108,625 3,108,625 $1,554,313 2034 3,107,155 3,107,155 $1,553,578 2035 3,109,965 3,109,965 $1,554,983 2036 3,096,475 3,096,475 $1,548,238 2037 3,096,394 3,096,394 $1,548,197 2038 3,099,488 3,099,488 $1,549,744 2039 3,100,363 3,100,363 $1,550,181 2040 3,098,756 3,098,756 $1,549,378 2041 3,099,275 3,099,275 $1,549,638 $1,570,909 $96,075,893 $13,037,143 $110,683,945 171 CITY OF SCHERTZ GMAC Commercial Mortgage Schaefer Road Rural Water 5% Interest Rate Date Principal Interest Period Total Fiscal Total 2/1/2006 6,000.00 1,700.00 7,700.00 $ 2/1/2007 7,000.00 1,400.00 8,400.00 $ 2/1/2008 7,000.00 1,050.00 8,050.00 $ 2/1/2009 7,000.00 700.00 7,700.00 $ 2/1/2010 7,000.00 350.00 7,350.00 $ $ 34,000.00 $ 5,200.00 $ 39,200.00 172 7,700.00 8,400.00 8,050.00 7,700.00 7,350.00