The URL can be used to link to this page

FY 2007-08 Budget CITY OF SCHERTZ Operating Budget Fiscal Year October 2007 - September 2008 CITY OF SCHERTZ, TEXAS ADOPTED ANNUAL BUDGET FISCAL YEAR 2007-08 OCTOBER 1, 2007 - SEPTEMBER 30,2008 CITY COUNCIL HAL BALDWIN Mayor JIM FOWLER Council Member, Place 1 DAVID SCAGLIOLA Council Member, Place 2 JOHN TRA YHAN Council Member, Place 3 TONY WILENCHIK Council Member, Place 4 MICHAEL CARPENTER Council Member, Place 5 PREPARED BY DON E. TAYLOR, CITY MANAGER JOHN E. BIERSCHWALE, ASSISTANT CITY MANAGER DAVID J. HARRIS, ASSISTANT CITY MANAGER JUAN F. SANTOYA JR., FINANCE DIRECTOR JOYCE DEBUYSERE, FINANCE OFFICE MANAGER RENEA. zARATE, STAFF ACCOUNTANT ELIZABETH WILEY, FINANCE CLERK MARTHA CANSECO-AMESCUA, FINANCE CLERK DONNA DYKES, HUMAN RESOURCES DIRECTOR City of Schertz Our Mission Recognizing that the purpose of Government is to provide service that cannot be readily obtained individually, it is the mission of the employees of the City of Schertz to provide courteous, responsive and efficient service in all areas of public safety, public works, information, recreation, administration and planning. This mission will be achieved through the joint efforts of the residents, elected and appointed officials, and the staff of the City. Efficient management of resources is considered a high priority which, coupled with a zest for integrity and the spirit of volunteerism, will insure our future. Our Vision The Vision of the City of Schertz is that of A prosperous community of involved citizens Who enjoy a high quality of life. Values We Hold True Safety for All Continuity - from the Past to the Future Honor our Environment Excellence is Our Goal Responsibilities Accepted T ogetherWe Can Z est for Life 1400 SCHERTZ PARKWAY SCHERTZ, TEXAS 78154-0890 (210) 619-1020 FAX (210) 659-3204 www.schertz.com DON E. TAYLOR CITY MANAGER July 31,2007 TO: The Honorable Mayor and Council Members FROM: Don E. Taylor, City Manager SUBJECT: Proposed Budget for 2007-2008 Fiscal Year The proposed budget for fiscal year 2007-2008 was filed with the City Secretary today, in accordance with the requirements of the City Charter. The revenues in each fund meet or exceed our proposed expenditures. The Guadalupe County Appraisal District lists the City's tax roll for 2007-2008 at $1,847,729,226. This is an 11 % increase or $180,095,002 over last year. The tax rate of $0.4090 per $100 of valuation is recommended for FY 2007-2008. The tax components are as follows: $0.2590 for Maintenance & Operations and $0.1500 for Interest & Sinking (debt service). This is a $0.0227 decrease in the tax rate from $0.4317 in FY 2006-2007. Trends through the first 7 months of 2007 indicate the City of Schertz's economy continues to grow. This is evident in a 17% increase in Sales Tax and the numbers are expected to continue in a positive trend. Lowe's is in the process of being built and will be finished by December or January. Lack's furniture store is constructing a warehouse with a retail store to follow. An International House of Pancakes and a Walgreen's are also under construction along with additional bank branches. There are also plans to build two new hotels, a Fairfield Inn and a La Quinta. Schertz continues to attract more and more viable businesses. Additionally, the City's housing starts continue to be strong with an estimated 555 single-family residential lots and 488 multi-family units. We are continuing to improve our employee benefits package by increasing the employee contribution to retirement from 6% to 7% with appropriate City match. We are also including a cost of living raise of 3.4%. We are anticipating an increase in employee health insurance to be about 10%. The FY 2007-2008 budget proposes additional positions to address the growing needs of our City. Salary adjustments and/or reclassifications are provided to court employees and the Purchasing Agent, Records Manager, and one Assistant City Manager (to bring this position in line with the other position). In addition, a Civic Center Department will be created out of Parks Department; the newly-hired Parks Superintendent is being upgraded to a Parks and Recreation Director. Additionally, two departments Municipal Court and Court Support will be consolidated into one. More detailed information is contained in the executive summary. Overall, the City of Schertz is in sound condition financially with adequate reserves. Our economy is strong and continues to grow. I would like to thank the Department Heads for their assistance in the development of this document. Special thanks are due to the following people for their critical roles in the completion of this budget: Assistant City Managers, John Bierschwale and David Harris. Finance Department staff Joyce DeBuysere, Rene Zarate, and Finance Director Juan F. Santoya, Jr., and Human Resources Director Donna Dykes. Lastly, I wish to thank the Mayor and City Council for your continued support and leadership on keeping our City the best place to live in Texas. Together, we are providing vision and quality operations to the City while being good stewards of the resources our residents and businesses have provided us. Thank you for your time, talents, and professionalism. Sincerely, cc:- Don E. Ta City Manager /"'^ /^^'^ Schertz.. '":r" :.Et :x:. .A. oS Corridor to the Future Executive Summa1Y: The FY 2007-08 all funds budget was adopted Tuesday, September 25,2007. It covers the fiscal year beginning October 1, 2007 and ending September 30, 2008. This document includes the following eleven funds: . General . Water/Sewer . Special Events . Emergency Medical Services . Drainage . Hotel/Motel . Park . Recycling . Capital Recovery . Tax Interest and Sinking . Economic Development Corp. The FY 2007-08 adopted budget maintains the highest level of service residents and businesses have grown to expect from this organization while attempting to control costs and ensuring good value for monies spent. Below are the highlights of the FY 2007-08 budget. All Funds A total of 21 new positions are added as part of the budget. Other personnel- related enhancements include increasing the employee portion of the retirement rate from 6 to 7 percent with a corresponding City match. Additionally, all salaries will automatically increase 3.4 percent as part of a cost of living allowance increase. General Fund 101 The FY 2007-08 budget was adopted Tuesday, September 25,2007. It covers the fiscal year beginning October 1, 2007 and ending September 30,2008. All departments & funds: . increases in costs for going from 6% to 7% in TMRS . increases in costs for Cost of Living Increase of 3.4% Revenue Sales tax and ad valorem taxes continue to be the largest revenue sources for the City followed by Fees, miscellaneous revenue, Franchise fees, Inter- Jurisdictional fees, Inter-Fund transfers, and Licenses. Sales tax assumes a 17 percent increase over FY 2006-07 estimates. Ad valorem tax is based on a rate of $0.2590 per $100 valuation (a.k.a. "Maintenance and Operating") and assumes an 11 percent increase in appraisals. Total revenue for the General Fund is budgeted at $16,662,083. Expenses The General Fund has $16,654,772 in expenses in the FY 2007-08 adopted budget Oept Name & Number City Council 150 This budget includes costs to conduct city elections, travel, and memberships. Expenses decrease due to reduction in printing and binding costs. City Manager 151 Additional costs in this department is due to full-year funding of a Special Projects Coordinator and regarding of one Assistant City Manager to put both positions in same pay grade. Additional travel/training funds added to cover costs of the additional Assistant City Manager and Special Project Coordinator that were not funded in 2006-07. These increases are offset in decreases in budget of 311 customer relations representatives and related equipment that are being spun off into new department. This department has one new Executive Assistant position effective January 1, 2008. Municipal Court 152 Beginning with in the FY 2007-08 budget, Court and Court Support departments are merged into one department. Increases are due to additional money needed for contract judge(s) and a replacement vehicle for a warrant officer. These increases are offset by reduction of full-year salaries of one full-time judge and one administrative assistant. Customer Relations-311 Oept# 153 This is a new department. Funding for this department was initially approved at mid-year FY 2006-07 and was contained in the City Manager's budget. For FY 2007-08, this unit is spun off into its own department. The FY 2007-08 adopted budget represents Full-year funding of 2 representatives. 9-month funding has been provided for 2 additional customer care representatives to be added when new building and office space comes available. Planning & Zoning 154 Expenses increase due to full-year funding of 1 Planning Director and contract services to provide Unified Development Code re-write, training staff and commissioners on the new UDC and land use plan, as well as travel costs to conferences. One new Planning Technician position is added effective October 1, 2007. Legal 155 Expenses increase in advertising for legal notices and cost of legal services. Facility Maintenance 161 The FY 2007-08 adopted budget reflects increases in operating supplies and utilities due to new buildings coming on-line, upgrades to the Northcliffe Civic Center (old Northcliffe VFD) and build fence, new A1C for Council conference room, and a replacement vehicle. City Secretary 164 Increases in funding to update City Code/Codification of ordinances and travel/training costs for staff to attend the Texas Municipal Clerks certification program. Non-Departmental 167 This department includes increases in expenses in costs for postage, insurance, EMS support, audit costs, bank service fees, and credit card service fees. Additional funds are provided to replace old City Seals on vehicles and badges as well as promoting the City's Money Magazine Top 40 in America/Number one in Texas Award. Decreases are noted in Guadalupe County Appraisal District fees and EMS. Community & Media Relations 170 Beginning with the FY 2007-08 adopted budget, this department will change the organization of Schertz Tales, the City's monthly magazine by bring ad sales and publishing costs in house including adding one Underwriting & Marketing Associate position to sell ads. This will increase publication and personnel costs. These increases are offset by ad sales income, which is reflected in the Revenue section of the General Fund budget. Records Management 171 The Records Management department is adding additional costs for scanning of large plats and plans; some costs are located in the Water/Sewer fund for those department's documents. Multiple departments will utilize these scanned documents as the City's use of computers in vehicles increases in the coming years. Engineering 173 For FY 2007-08, 1 Engineer position is deleted; full-year costs of current GIS Technician II position are added as is one additional GIS Technician I. Additional funds are added for contract engineering services. Police 256 Three new patrol officer positions and 1 new dispatcher are added in the FY 2007-08 adopted budget. Additionally, full-year funding is added for 1 new dispatcher approved mid year 2006-07. Other costs added include travel and training funds, usage costs of new 800 MHz radios, 2 new and 8 replacement vehicles and accessories. Fire 257 The Fire Department's FY 2007-08 adopted budget includes costs for replacement vehicles and accessories, replacement bunker gear, additional training for water rescue and incident command, usage costs of new 800 MHz radios, and increc:lses in fuel costs. Inspections 258 The Development Services Department's Inspection Division FY 2007-08 adopted budget contains funds to review and update the City's building code, upgrade Assistant Inspector to Deputy Chief Inspector, and upgrade Administrative Assistant position. The budget also includes costs for two replacement vehicles. Public Works-Streets 359 The Streets Division of the Public Works Department adds one Streets Supervisor position and three part-time seasonal worker positions. Increases in utility costs and fuel are also noted. Additional funding is provided for changing out approximately 300 of 900 street name signs across City (three to four year project) with larger lettering and street block numbers than is currently used. Parks 460 The FY 2007-08 adopted budget adds 1 park worker position, funds a new road for the "back 40" park area behind the City Hall Ballfields, funds as-needed equipment rental and contract mowing of the following locations: Northcliffe Community Center, Northcliffe Park, Country Club Boulevard, Legacy Oaks, Dr., and City Hall complex. These. increases are offset by the moving of personnel and related costs to new Civic/Community Centers department listed below. Pools 463 The hourly wage of pool lifeguards will increase to remain competitive with the local job market. Increases in operating supplies are also added. Civic/Community Centers 464 The personnel and related costs associated with the Civic and Community Centers are now located in a separate budget with approval of the FY 2007-08 adopted budget. With this separation, additional advertising costs were allocated to promote the three facilities: The Community Center and Civic Center located at the City Hall campus and the Northcliffe Community Center. Library 665 The FY 2007-08 adopted budget includes one-time costs of $165,000 for new telephones and computers/software for new library, adds one Circulation clerk. These increases are offset by transferring costs related to computer and telephone maintenance to the Information Technology budget. Animal Control 762 One new animal control officer position has been added to the Police Department's Animal Control Division as part of the FY 2007-08 adopted budget. Additional costs added include funds for purchasing dog and cat food, spaying and neutering services, micro chipping, and disposal costs. Several capital outlay items are added including new cat cages, ventilation/cooling system for kennels, and fencing. Information Technology 853 Beginning at mid-year budget adjustments in FY 2006-07, the Information Technology Department has begun establishing a solid foundation for the future growth of the city operation by investing in enhanced backup systems, new software, telephone system upgrades, and outsourcing the majority of the workforce related to this department. The FY 2007-08 adopted budget continues these projects and management philosophy. Increases in equipment costs and computer consulting fees are provided. These increases are offset by decreases in telephone costs and computer fees and licenses. Other increases include adding feellicense costs, computer peripherals. Six-month funding provided for one vacant IT Technician position. Human Resources 866 The FY 2007-08 adopted budget includes the addition of one Human Resources ( Clerk position, furniture for the department in new building; add additional funds for tuition reimbursements and advertising. These increases are offset by decreases in travel/training. Finance 868 The Finance Department's FY 2007-08 adopted budget adds one Finance and Budget Analyst position to the department. Purchasing 872 The Purchasing Department adds one new Warehouse Clerk position for both the purchasing and facilities maintenance departments in the FY 2007-08 adopted budget. Additionally, the Purchasing Agent position will be regarded once certification is achieved. These costs are offset by decreases in travel/training and furniture/fixtures. Fleet Services 877 The 2007-08 adopted budget includes increases in vehicle supplies and fuel. These increases are offset by decreases in maintenance agreements. Citizens Assistance 901 No change Summary of new authorized positions in the General Fund: 1 Animal Control Shelter Operator 1 Animal Control Shelter Operator (Temporary Full-Time) 1 Communications Officer (Dispatcher) 2 Customer Relations Representatives (9 months) in 311 1 Executive Assistant (9 months) in the City Manager's Office 1 Finance/Budget Analyst 1 GIS Technician I 1 Library Circulations Clerk 1 Parks Worker 3 Police Patrol Officers 1 Planning Technician 1 Street Supervisor 1 Underwriting Marketing Specialist for Schertz Tales (Community and Media Relations) 1 Warehouse Clerk in Purchasing 17 TOTAL Additionally, one Engineer position is deleted. Water/Sewer Fund 202 This fund has two departments: Public Works-Water and Sewer Administration and the Business Office. Revenues $12,038,345 in revenue is budgeted in this fund. Funds for this department come from retail water and sewer sales to customers and from interest income. Revenues see an increase in fees and investments income. Expenses Expenses in this fund total $12,009,258. Public Works-Water and Sewer Administration Funding is provided in this department for the scanning of large documents into Laserfische and increases in Cibolo Creek Municipal Authority (CCMA) (sewage processing agency) costs and debt service costs. Additionally, $715,000 is budgeted in capital improvements including new water meters, replacing a water lines and streets in Aviation Heights. Business Office Expenses in the Business office increase to include replacement vehicles; reclassification of positions and adding one debt collections clerk. Special Events Fund 106 Revenue $58,250 in revenues is budgeted in this fund. The sources of this fund come from the Hotel/Motel and General Funds. Expenses Funds are provided for the Festival of Angels, Employee Christmas Party, National Night Out, Relay for Life, 50th Anniversary Celebration, and Blue Santa program. Emergency Medical Services Fund 203 Revenues $5,559,791 is budgeted for revenue for this fund which comes from both user fees, insurance claims, and supplements from area cities (including Schertz's General Fund) and Guadalupe County. This is an increase over FY 2006-07. Expenses As this is a self-supporting "Enterprise Fund" its costs support day-to-day costs of the operation including transfers to the General Fund for administrative-related items such as Finance Department, City Manager's Office, and Information Technology overhead. For the FY 2007-08 budget, two new Paramedic positions are authorized. Additionally, increases are noted in medical supplies, computer and radio equipment costs and usage fees. Decreases are noted in vehicle capital costs. Total expenses for this fund are $5,409,791. Drainage Fund 204 Revenues $368,390 is the revenue budgeted for this fund. Fees applied to water bills are the primary funding source for this fund. Drainage Fund Expenses This fund includes costs for maintaining the City's drainage channels, inlets, and outlets. The budget remains consistent with current operations, though adds one additional Drainage Worker I position. Additional increases are due to adding debt service cost. Total expenses for this fund are $368,390. Hotel/Motel Tax Fund 314 Revenues Revenues for this fund come from a tax imposed on guests at the City's hotels. There are two hotels with a total of 157 rooms available. $219,800 is budgeted for revenue for FY 2007-08. This is a planned increase due to new hotels coming on line in the coming fiscal year. Expenses As different business units provide overall marketing and support for this fund, funds will be transferred to other funds and the Chamber of Commerce for their activities. Expenses also include costs for other special events and consulting fees. A total of $214,746 is budgeted in this fund. Parks Fund 317 Revenues This Fund receives its income from parkland dedication fees as well as tree mitigation fees collected from new developments. The FY 2007-08 adopted budget contains $220,000 in new revenue which is a decrease from FY 2006-07 due to lower anticipate tree mitigation fees paid by developers. Expenses Expenses can go to support acquisition of parks and their development. This year, the fund will purchase land near Public Works for the storage of raw material. In exchange, Public Works will give Parks land adjacent to Pickerell Park for its expansion. Expenses also include $100,000 for trees, which are purchased as needed. Recycling 318 Revenues Revenues come from the sale of recycled materials throughout the year. Revenue is expected to increase due to additional accounts. Recycling Fund Expenses are paid to Bexar Waste to haul off spring and fall cleanups. Capital Recovery Fund 411 Revenues Revenues for this fund come from impact fees applied to new developments. Revenues in this fund increase due to a transfer from reserves and investment income. Expenses Expenses increase due to debt service and four proposed projects costing approximately $6.3 M: Ground Storage NE 7.5 M Ground Storage-Live Oak Loop Feed line to NE booster station Town Creek Sewer line Tax Interest and Sinking Fund 505 Revenues The primary source of revenue for this fund is that portion of the ad valorem tax rate dedicated to "Interest and Sinking" or $0.1500 per $100 valuation. For FY 2007-08 $3,036,700 is budgeted. Expenses This fund pays down voter-approved bonds for a variety of projects approved through the years including bonds from 1992, 2001, 2003, 2004, 2005, 2006, and 2007. Economic Development Corporation 620 Revenues The Corporation's primary funding source is a portion of sales tax collected by the City. Revenue increases in sales tax to reflect higher same store sales and new businesses coming on line. Expenses Expenses include several Park and Facilities projects including construction of a fence at Pickerell Park, adding 22 tables at Pickerell Park pavilion, adding soccer and softball fields at Ashley Park, add a playscape at Woodland Oaks, provide a grant match for a walking trail in back of City Hall, and add pool slides at Northcliffe and Pickerell pools. Additionally, funding is transferred to the General Fund for publicizing the Money Magazine Award. Expenses also include funding $185,000 in business development programs, increases in debt service, and new furniture for staff for new building. . This budget will raise more total property taxes than last year's budget by $813,330 or 130/0 increase, and of that amount, $466,183 is tax revenue to be raised from new property added to the tax roll this year. CITY OF SCHERTZ 2007-2008 BUDGET Table of Contents Ordinance- T ax Rate ----------------------------------------------------------------------- I-II Ordinance-13ud~et --------------------------------------------------------------------------111 Tax Rate and Property Evaluation------------------------------------------------------IV . Rate per Hundred Val ua tion------------------------------------------------------------- V Tax on $100,000 Valuation by Y ear---------------------------------------------------- VI Assessed Property Val ues--------------------------------------------------------------- VII Revenues - All Funds---------------------------------------------------------------------- VIII <=l1art - All Funds------------------------------------------------------------------1)( Expenditures - All Funds-----------------------------------------------------------------)( <=l1art - All F unds------------------------------------------------------------------ )(1 General Fund Expenditures by function----------------------------------------------)(II <=l1art - General Fund Expenditures by function-------------------------- )(111 General Fund Revenue & Expenditure Summary--------------------------------------------1-6 Revenues-----------------------------------------------------------------------------7 -10 <=i ty <=ouncil-------------------------------------------------------------------------11-12 <=ity Mana~er--------------------------------------------------------------------- 13-14 311/ <=us tomer Rela tions-------------------------------------------------------- 15-16 Municipal <=ourt ------------------------------------------------------------------- 17-19 Plannin~ & Zonin~ ---------------------------------------------------------------- 20-22 Le~al Services----------------------------------------------------------------------- 23-24 General Services------------------------------------------------------------------- 25- 27 <=i ty Secretary ---------------------------------------------------------------------- 28- 29 N on- Departmen tal---------------------------------------------------------------- 30-32 <=ommunity & Media Relations----------------------------------------------- 33-34 Records Mana~ement ----------------------------------------------------------- 35-36 En~ineerin~ ------------------------------------------------------------------------- 37-39 P olice------------------------------------------------------------------------------ 40-42 !<ire------------------------------------------------------------------------------------ 4l3-Ll5 Inspections------------------------------------------------------------------------- 46-48 Streets--------------------------------------------------------------------------------4 9-51 I'2lrlcs---------------------------------------------------------------------------------- 52-54 P 001------------------------------------------------------------------------------------55-57 <=ivic <=enter-----------------------------------------------------------------------58-60 Library ------------------------------------------------------------------------------61-63 l\I1irrlal <=()Iltr()l---------------------------------------------~-----------------------~-66 InformatioIl T eclmology -------------------------------------------------------- 67-69 Human Resources------------------------------------------------------------ 70-72 !<iIlaIlce------------------------------------------------------------------------------ 73-74 I'urcl1asirl~------------------------------------------------------------------------ J7!)-J7J7 Fleet Service--------------------------------------------------------------------- 78-80 <=ity Assistance--------------------------------------------------------------- 81-82 Tax I&S Summary ----------------------------------------------------------------------------83-84 Revenues & Expendi tures------------------------------------------------------- 85-86 Water & Sewer Revenues & Expenses------------------------------------------------------------ 87-92 Business Office-------------------------------------------------------------------- 93-95 Water / Wastewater --------------------------------------------------------------- 96-99 Public Safety EMS Summary -----------------------------------------------------------------------------100-105 Rev enues----------------------------------------------------------------------------106 Expenses---------------------------------------------------------------------------- 107-109 Drainage Summary -----------------------------------------------------------------------------110-115 Rev en ues-----------------------------------------------------------------------------116 Expenses---------------------------------------------------------------------------- 117-118 Capital Recovery Summary-----------------------------------------------------------------------------119-120 Rev enues-----------------------------------------------------------------------------121 Expendi tures ----------------------------------------------------------------------- 122 Schertz Economic Development Corporation Summary --------------------------------------------------------------------------- 123-124 Rev enues-----------------------------------------------------------------------------125 Expenditures---------------------------------------------------------------------- 126-128 Special Event Fund Summcrry----------------------------------------------------------------------------129 Revenue---------------------------------------------------------------------------- 130 Expendi tures------------------------------------------------------------------------ 131 Hotel Tax Summary --------------------------------------------------------------------------- 132-133 Revenues --------------------------------------------------------------------------- 134 Expenditures---------------------------------------------------------------------- 135 Parks Summary ______________________________________________________--------------------- 136-137 Revenues----------------------------------------------_______________________________138 Expendi tures------------------------------------------------------------------------ 139 Recycling Summary-----------------------------------------------------------------------------lLlO-1Ll1 Revenues----------------------------------------------------------------------------1 Ll2 Expenditures------------------------------------------------------------------------1 Ll3 Working Capital Projects---------------------------------------------------------------- 144-1 Ll5 Organizati onal Chart--------------------------------------------------------------------- 1 Ll6 2007-2008 P osition Au thoriza tion ----------------------------------------------------- 1 Ll7 -153 2007-2008 Pay T a bles-----------------------------------------------------------------------15Ll-163 Com pensa tion Plan ------------------------------------------------------------------------ 16Ll-167 Travel, Training, & Conference Procedures---------------------------------------- 168-172 Debt Service Review ----------------------------------------------------------------------- 173 G 0 Bond, SR 1992 ----------------------------------------------------------------- 17 Ll C 0 Bond, SR2001----------------------------------------------------------------- 175 Combination Tax & Ltd Pledge Revenue -2003----------------------------176 Combination Tax & Ltd Pledge Revenue -200Ll----------------------------177 G 0 Bond, SR1998 ----------------------------------------------------------------178 Utility System Rev & Refund Bond, SR2001--------------------------------179 Schertz/Seguin Local Govt Corp, SR99 & SR01--------------------------- 180 GMAC Commercial Mortgage----------------------------------------------- 181 C 0 Bond, SR2005---------------------------------------------------------------- 182 CO Bond, SR2006--------------------------------------------------------------- 183 C 0 Bond, SR2007 --------------------------------------------------------------- 18Ll ORDINANCE NO. 07-T-42 AN ORDINANCE BY THE CITY OF SCHERTZ, TEXAS ADOPTING THE YEAR 2007 TAX RATE. WHEREAS, public hearings were held on September 4, 2007 and September 11, 2007 to receive public comment on the proposed tax rate; Now Therefore BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS: Section L THAT, the City Council of the City of Schenzo Texas, does hereby levy or adopt the tax rate on $10000 valuation for this city for tax year 2007 as follows: 0,259000 for the purpose of maintenance and operation ') 0,150000 for the payment of principal and interest on debt , 0,409000 total tax rate Section 2. TIDS TAX RATE \VILL RAISE MORE TAXES FOR MAINTENANCE AND OPERATIONS THAN LAST YEAR'S TAX RA TE. Section 3. THE TAX RATE WILL RAISE TAXES FOR MAINTENANCE AND OPERATIONS ON A $100,000 HOME BY APPROXIMATELY $6.60. Section 4. THAT, all ordinances and parts of ordinances in conflict are hereby repealed. I Passed and approved on first reading this j e""--day of September 2007 PASSED, APPROVED AND ADOPTED this~day of Septe ber 2007. ATTEST: ~:7~~etary II ORDINANCE NO. 07-T-41 AN ORDINANCE APPROVING THE FISCAL YEAR 2007-2008 BUDGET FOR THE CITY OF SCHERTZ, TEXAS AND DECLARING AN EMERGENCY. WHEREAS, as required by the 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, 2007 and Ending September 30, 2008; and WHEREAS, notice of a public hearing upon said budget has been posted and legally published; and WHEREAS, a public hearing has been held and full and final consideration has been given regarding the budget; NOW THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS: SECTION 1. THAT the budget of the City of Schertz, Texas, for the fiscal year beginning October 1, 2007 and ending September 30, 2008, 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 2007 -2008. SECTION 2. THAT this Ordinance approving and adopting a budget for fiscal year 2007-2008 is in accordance with the terms and provisions of the laws of the State of Texas and the City Charter. SECTION 3. 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 25th day of Hal Baldwin, Mayor ATTEST: M~~~~etary III Tax Year Rates and Property Evaluation Year Rate Total Valuation 1998 0.3544 $ 450,199,212 1999 0.3455 $ 534,039,183 2000 0.3405 $ 716,795,968 2001 0.3825 $ 822,745,104 2002 0.3825 $ 1,005,399,711 2003 0.3825 $ 1,105,234,626 2004 0.3760 $ 1,285,941,678 2005 0.3977 $ 1,397,297,729 2006 0.4317 $ 1,423,205,878 2007 0.4090 $ 1,787,055,405 IV 0.450 0.400 0.3544 0.3455 0.350 ~ ~ ~i 0.300 ~ ~. 0.250 "'~ f./ Q) '~. ;'t .. : 0 III D:: 0.200 0.150 0.100 0.050 0.000 1998 0.3405 1999 2000 Rate per Hundred Valuation 0.3825 .~ :A ~'~{ ;,:f~ f ii, ~ ~ ~ ~,., :i~ 2001 0.3825 t,,: ~\ r f; ~ ...~ ~, if 2002 v 0.3825 ii 'F.' !&i ~ '!:i \~l ~~ 2003 0.3760 ;,.i" c{ rT; iT.' ~, ~, ~~ ~' ";; 2004 ~ '.-)." 2005 0.3977 .\~\ ~.. ~ \... ,'1. ~ ~ ':'~ :-.:. ~\::\ ,. / 2006 0.4317 0.4090 ii ~, ~ ~ ~. ~ .~ ";' ,~.... fi: ,.~ "':'f,. r.'. ~! ~ ~ ~ .!.~ 1;: f ? I~ ,- - / ~i t' ~.~: / 2007 $354.40 $345.50 'a' $340.50 ~ ~^ Tax on $100,000 Valuation by Year $382.50 fe K; ri ~~ " ;t, '; .0{. t~, i~ 1998 1999 2000 2001 $382.50 i .;~~. ',l'l" , 2002 $382.50 2003 VI $376.00 2004 $397.70 ,:'" , .,~ 2005 $431.70 ~" 1.4;.. l";~ .':~ ~~ :<,": ~l: 2006 $409.00 '!~' .. 2007 Assessed Property Values 2,000,000,000 1,800,000,000 1,600,000,000 1,400,000,000 1,200,000,000 Q) :J 1,000,000,000 ~ 800,000,000 600,000,000 400,000,000 ..,.,1: 200,000,000 : y.- o OSeries1 C Series2 1 2 3 4 5 6 7 8 9 10 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 $450,199,212 $534,039,183 $716,795,968 $822,745,104 $1,005,399,711 $1,105,234,626 $1,285,941,678 $1,397,297,729 $1,423,205,878 $1,787,055,405 VII Revenues - All Funds General Revenue Debt Services Water & Sewer Drainage Schertz EMS Capital Recovery Park/Recycle/Hotel SED Corporation TOTAL $ 16,720,333 $ 3,036,700 $ 12,038,345 $ 368,390 $ 5,559,791 $ 6,801,280 $ 457,800 $ 2,104,100 $ 47,086,739 VIII Water & Sewer 260/0 Revenues - All Funds Schertz EMS 120/0 Capital Recovery 14% Park/Recycle/Hotel 10/0 Drainage 10/0 SED Corp 40/0 Debt Services 60/0 General Revenue 360/0 IX Expenditures - All Funds Debt Service Personnel Supplies Professional & City Svcs Utility & Maint. Services Operation Support & Svc Capital Expense TOTAL $ 7,039,491 $ 14,944,944 $ 756,456 $ 2,088,376 $ 7,852,311 $ 4,532,542 $ 9,234,690 $ 46,448,810 x Expenditures. All Funds Opr Support & Asst 100/0 Capital Expense 200/0 Utility & Maint. Svc 17% Debt Service 150/0 Prof & City Svc 40/0 Supplies 20/0 Personnel 320/0 XI General Fund Expenditures - by Function TOTAL $ 7,195,331 $ 4,192,534 $ 350,796 $ 2,199,388 $ 827,388 $ 1,871,835 $ 17,500 $ 16,654,772 Public Safety General Govt. Health Parks & Culture Public Environment Internal Services Misc. XII General Fund Expenditures - By Function Gen. Govt. 25.20/0 Parks & Culture 13.20/0 Public Environment 5.00/0 Internal Services 11.20/0 Misc 0.10/0 Pub. Safety 43.2% XIII General Fund - Revenues Taxes Sales Tax Franchises Permits/License/F ees Muni. Court Inter-Jurisdictional Inter- Fund Admin Miscellaneous TOTAL $ 5,090,267 $ 4,100,000 $ 1,086,000 $ 2,066,220 $ 1,247,330 $ 346,283 $ 862,313 $ 1,863,670 $ 16,662,083 1 Revenues - General Fund Franchises 70/0 Muni. Court 70/0 Inter-Jurisdictional 20/0 Inter-Fund Admin 50/0 J Miscellaneous 110/0 Permits/License/Fee 110/0 Sales Tax 250/0 2 General Fund - Expenditures Personnel Supplies Professional & City Svc Utility & Maint. Services Operation Support & Svc Capital Expense TOTAL $ 11,276,842 $ 325,862 $ 1,402,239 $ 988,185 $ 888,808 $ 1,772,836 $ 16,654,772 3 Expenditures - General Fund Utility & Maint. Svc 60/0 Opr Support & Asst. 5% Prof & City Svc 8% Supplies 20/0 4 Capital 11% Personnel 68% T1 II'S. n A ("'}'''' 'I'N1rf'l "N.l.~..I'(..)N AI. .I.\J' r . .r-l . k. _r .1-"'\, J _ ":::- ...1 ~ ,., .:::.1. ~ . . . . ,.. 1 f'\"'~'H./ -f ,I.. _l-i.[.~. "'..'1 l't! C I T Y OF S C HER T Z OPERATING BUDGET 2007-2008 101 GENERAL FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY REVENUE SUMMARY Taxes 6,015,134 7,480,078 8,103,093 9,190,267 Franchises 786,296 961 ,463 943,150 1,086,000 Permits 675,960 731,706 711,700 1,011,990 Licenses 21,913 26,632 26,600 30,600 Fees 1 ,459,579 1 ,774,403 1,750,790 2,242,960 Fines 22,992 24,703 26,000 28,000 Inter-jurisdictional 256,385 277,227 337,018 346,283 Inter-Fund Transfers 464,837 407,420 625,655 862,313 Miscellaneous 282,823 1,514,646 1,472,841 1,863,670 EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL 23,035 . 46,362 31 ,600 28,400 CITY MANAGER 323,721 330,888 549,655 650,457 CUSTOMER RELATIONS-311 133,916 MUNICIPAL COURT 267,366 421,322 482,662 404,892 PLANNING & ZONING 226,079 264,317 346,827 397,961 LEGAL SERVICES 299,205 244,446 189,000 249,000 GENERAL SERVICES 328,262 430,227 617,083 677,907 CITY SECRETARY 210,468 120,279 133,023 155,017 NON DEPARTMENTAL 524,169 638,109 1,097,081 781,451 COMMUNITY & MEDIA RELATIONS 60,466 70,785 165,386 350,249 RECORDS MANAGEMENT 111,440 112,156 160,995 ENGINEER 165,218 202,289 TOTAL GENERAL GOVERNMENT 2,262,771 2,566,735 3,889,691 4,192,534 PUBLIC SAFETY POLICE 2,564,307 2,911,352 3,353,716 4,421,832 FIRE 1,570,861 2,273,273 2,041,929 2,288,206 INSPECTIONS 324,247 340,622 409,862 485,293 TOTAL PUBLIC SAFETY 4,459,415 5,525,247 5,805,507 7,195,331 5 C I T Y OF S C HER T Z OPERATING BUDGET 2007-2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PUBLIC ENVIRONMENT STREETS 485,855 564,335 690,603 827,388 TOTAL PUBLIC ENVIRONMENT 485,855 564,335 690,603 827,388 PARKS & RECREATION PARKS 436,115 441 ,356 734,481 1,070,044 POOLS 130,908 146,156 190,803 203,372 COMMUNITY/CIVIC CENTER 266,239 TOTAL PARKS & RECREATION 567,023 587,512 925,284 1,539,655 CULTURAL LIBRARY 325,499 384,128 445,716 659,733 TOTAL CULTURAL 325,499 384,128 445,716 659,733 HEALTH ANIMAL CONTROL 208,502 217,769 291,879 350,796 TOTAL HEAL TH 208,502 217,769 291,879 350,796 INTERNAL SERVICE INFORMATION TECHNOLOGY 349,121 391,954 851,445 844,196 HUMAN RESOURCES 115,602 125,698 177,354 246,684 FINANCE 225,759 238,092 310,477 410,084 PURCHASING 60,986 97,115 FLEET SERVICE 194,854 231,810 309,801 273,756 TOTAL INTERNAL SERVICE 885,336 987,554 1,710,063 1,871,835 MISCELLANEOUS CITIZENS ASSISTANCE 10,000 10,000 17,500 17,500 TOTAL MISCELLANEOUS 10,000 10,000 17,500 17,500 6 C I T Y OF S C HER T Z OPERATING BUDGET 2007-2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED REVENUES Taxes 000-411100 Advalorem Tax - Current 3,685,396 4,223,680 4,575,093 4,961,267 000-411200 Advalorem Tax - Delinquent 56,674 55,647 60,000 55,000 000-411300 Advalorem Tax - P&I 34,397 38,589 38,000 39,000 000-411400 Roll Back Property Tax 000-411500 Sales Tax Revenue - Gen. Fund 2,227,283 3,136,970 3,400,000 4,100,000 000-411600 Bingo Tax 4,946 5,124 5,000 5,000 000-411700 Mixed Beverage 6,438 20,068 25,000 30,000 Total Taxes 6,015,134 7,480,078 8,103,093 9,190,267 Franchises 000-421200 Center PointlEntex Energy 17,498 22,042 25,750 27,500 000-421220 City Public Service 139,169 189,155 165,000 198,000 000-421240 Guadalupe Valley Elec Co-op 286,420 351,869 350,000 415,000 000-421250 New Braunfels Utilities 3,414 9,000 16,500 000-421440 Southwestern Bell Telephone 218,526 246,355 250,000 282,000 000-421460 AT&T Franchise Fee 67,641 67,725 66,400 70,000 000-421480 Other Telecom Franchise 6,239 12,914 13,000 6,000 000-421500 Solid Waste Franchise Fee 50,803 67,989 64,000 71,000 Total Franchises 786,296 961 ,463 943,150 1,086,000 Permits 000-431100 Home Occupation Permit 160 705 800 800 000-431200 Building Permit 480,103 490,600 500,000 780,000 000-431300 Mobile Home Permit 300 300 000-431400 Signs Permit 2,220 3,122 3,000 3,500 000-431500 Food Establishment Permit 27,750 37,000 23,000 25,000 000-431600 Garage Sale Permit 7,840 7,400 7,000 7,500 000-431700 Plumbing Permit 61,400 69,118 60,000 65,000 000-431750 Electrical Permit 49,487 50,291 49,000 45,000 000-431800 Mechanical Permit 25,124 35,070 30,000 35,000 000-431900 Solicitor/Peddler Permit 360 485 400 1,000 000-431950 Animal/Pet Permit 845 815 850 850 000-432000 Certificate of Occupancy Permit 660 510 750 1,000 000-432100 Security Alarm Permit 16,591 26,307 28,000 32,000 000-432200 Floodplain Permit 20 100 40 000-435000 Fire Permit 3,420 10,263 8,500 15,000 Total Permits 675,960 731,706 711,700 1,011,990 7 C I T Y OF S C HER T Z OPERATING BUDGET 2007-2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Licenses 000-441000 Alcohol Beverage License 2,488 5,205 3,900 3,900 000-442000 Contractors License 16,900 18,565 20,000 24,000 000-444000 Pet License 2,525 2,862 2,700 2,700 Total Licenses 21,913 26,632 26,600 30,600 Fees 000-451000 Municipal Court Fines 567,076 686,041 655,000 850,000 000-4511 00 Arrest Fee 36,520 46,373 45,000 55,000 000-451110 Expunction Fee 90 90 30 000-451200 Warrant Fees 82,955 107,642 95,000 118,000 000-451340 Judicial Fee - City 3,847 3,600 6,000 000-451400 Traffic Fine Costs TTL 18,048 23,587 23,000 25,000 000-451500 Teen Court Admin Fee 533 853 800 800 000-451510 Juvenile Court Fee 28,623 30,000 50,000 000-451600 Technology Fund Fee 32,325 40,873 35,000 48,000 000-451700 Security Fee 24,421 30,772 26,000 35,000 000-451800 Time Payment Fee - City 3,601 5,040 5,000 5,500 000-451850 State Fines 10% Service Fee 41,074 53,081 42,500 45,000 000-451900 DPS Payment - Local 7,586 9,495 8,500 9,000 000-452000 Child Safety Fee 6,872 8,355 7,000 7,000 000-452100 Platting Fees 68,550 150,564 120,000 125,000 000-452200 Site Plan Fee 6,949 39,697 48,000 55,000 000-452300 Plan Check Fee 230,463 232,762 210,000 335,000 000-452320 Tree Mitigation Admin Fee 4,720 7,000 4,000 000-452400 BOAlZoning Fees 1,750 5,250 7,000 10,000 000-452410 BOANariance Fee 1,000 000-452500 Food Handler Class 14,686 14,910 14,000 14,000 000-452520 Fire Training Classes 1,350 000-452600 Specific Use/Zone Chng Fee 56,047 46,763 55,000 70,000 000-452610 Plat Recording Fee 561 1,755 5,500 6,500 000-452710 Zoning Ltr&Dev Rights 150 1,195 1,500 1,500 000-452800 P&Z Public Hearing Fee 215 919 9,000 9,000 000-453100 Reinspection Fees 99,025 113,581 115,000 124,000 000-453110 Swim Pool Inspection Fee 675 900 900 1,000 000-453200 Mowing Fees - Inspections 1,390 383 800 2,500 000-453300 Solicitor's Investigation 10 000-453500 SubContractor Registration Fee 10,560 15,120 15,000 15,000 000-454100 Swim Pool Reservation Fee 5,482 763 4,000 7,000 000-454200 Pool Gate Admission Fee 25,674 21,332 28,000 30,000 000-454300 Seasonal Pool Pass Fee 7,425 5,240 8,000 6,000 000-454400 Swimming Lessons Fee 20,919 38,000 38,000 000-456500 Hazard Material Fee 2,743 9,257 1 0,100 7,500 8 C I T Y OF S C HER T Z OPERATING BUDGET 2007-2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Fees continued 000-456600 Fire Re-inspection Fee 363 283 100 2,000 000-458100 Sale of Merchandise 14 000-458300 Sale of Property/Auction 29,341 660 10,000 3,000 000-458400 Building Rental Fee 8,273 15,410 25,000 75,000 000-458500 Property Rental Fee 5,123 5,948 5,500 8,500 000-458600 Ball Field Use 80 100 100 130 000-458700 Vehicle Impoundment 2,450 2,760 2,500 2,500 000-459200 NSF Check Fee 280 100 100 300 000-459300 Notary Fee 189 192 150 200 000-459400 Maps, Copies, UDC Misc 1,671 1,327 50 300 000-459600 Animal Adoption Fee 17,615 14,726 15,000 14,500 000-459700 Pet Impoundment Fee 14,809 16,110 14,000 16,000 000-459800 Police Reports Fee 5,086 4,654 5,000 5,200 Total Fees 1,459,579 1,774,403 1,750,790 2,242,960 Fines 000-463000 Library Fines 22,992 24,703 26,000 28,000 Total Fines 22,992 24,703 26,000 28,000 Inter-Jurisdictional 000-473100 Bexar Co - Fire 13,725 13,725 13,725 13,725 000-473200 City of Seguin-Fire Contract 36,996 33,252 37,000 37,985 000-473300 Guad Co. library 115,778 115,784 154,812 163,066 000-473400 Randolph AFB-Animal Control 3,063 3,091 3,000 3,000 000-474200 Library Services - Cibolo 2,500 2,500 20,000 20,000 000-474400 Dispatch Service - Cibolo 81,928 106,093 106,081 106,097 000-474500 Dispatch Service -SCUCISD 1,200 1,410 1 ,400 1,410 000-474600 School Crossing Guard-Bexar 1,195 1,372 1,000 1,000 Total Inter-Jurisdictional 256,385 277,227 337,018 346,283 Fund Transfers 000-480000 Indirect Costs -EMS 25,000 50,000 58,700 66,755 000-480100 Indirect Costs -Hotel. 2,000 2,000 41 ,000 104,000 000-485000 lnterfund Charge-Drainage-3% 9,200 10,750 9,585 10,000 000-486000 Interfund Charges - Water 344,612 253,153 360,000 392,512 000-487000 Interfund Charges-Fleet 54,025 59,517 62,370 69,046 000-488000 Interfund Charges-4B 30,000 32,000 94,000 95,000 000-490020 Transfer In 125,000 Total Fund Transfers 464,837 407,420 625,655 862,313 9 C I T Y OF S C HER T Z OPERATING BUDGET 2007-2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Miscellaneous 000-491000 Interest Earned 6,688 15,671 18,000 19,500 000-491200 Investment Income 150,996 373,771 400,000 469,000 000-493120 Donation-Library 1,000,000 000-493400 Donations - Animal Control 4,664 3,540 4,000 500 000-493401 Donations-AlC Microchip 4,360 5,917 4,000 5,000 000-493402 Donations-Spay & Neuter 794 13,700 000-493502 Donations - Police Department 2,000 000-494481 LawEnforcemtOfficersStnd&Ed 3,075 3,192 3,100 3,300 000-497000 Misc Income-Gen Fund 50,236 27,834 25,000 15,000 000-497005 Misc Income-Publications 150,000 000-497020 Misc Income-Fleet Recycled Oil 25 320 350 000-497100 Misc Income- Police 8,831 13,147 6,000 7,500 000-497200 Misc Income - Library 5,059 6,239 5,000 6,400 000-497300 Misc Income - Animal Control 100 25 200 000-497400 Misc Income - Streets Dept 11,154 29,845 9,000 20,000 000-497500 Misc Income - TML Insurance 37,660 34,671 25,000 75,000 000-497550 Misc Income - TML Reimbursemen- 25,000 000-497600 Misc Income - Parks Vending 1,000 000-499000 Transfer from Reserves-AlC 773,372 517,550 000-499050 Transfer from Equip Res (IT) 66,950 346,170 000-499100 Transfer-Court Tech. Reserve 14,500 12,000 000-499150 Transfer-Court Security Reserve 44,500 000-499200 Transfer-Gen Fund Reserves 74,074 174,500 Total Miscellaneous 282,823 1,514,646 1,472,841 1,863,670 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 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES CITY COUNCIL Supplies 150-521000 Operating Supplies 26 3,200 1,000 Total Supplies 26 3,200 1,000 City Support Services 150-532600 City Elections 7,973 28,592 6,000 7,000 150-532800 Special Events 4,997 4,266 3,500 3,500 Total City Support Services 12,970 32,858 9,500 10,500 Operations Support 150-534200 Printing & Binding 80 490 3,200 500 Total Operations Support 80 490 3,200 500 Staff Support 150-535100 Uniforms 374 1,800 500 150-535200 Annual Awards 26 150 400 400 150-535300 Memberships 4,740 5,649 5,500 5,500 150-535500 Trainingffravel 5,193 6,841 8,000 10,000 Total Staff Support 9,959 13,014 15,700 16,400 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/Risk Manager, and two Assistant City Managers. Responsibility of this department includes personnel appointment and removal, preparation and execution of the City budget, as wellas administration of City Ordinances and policy as adopted by the City Council. 13 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES CITY MANAGER Personnel Services 151-511110 Regular 236,278 243,694 403,533 472,338 151-511180 L TO 423 377 1,145 1 ,482 151-511210 Longevity 7,212 4,848 5,256 5,838 151-511240 Vehicle Allowance 8,142 14,400 14,400 21,600 151-511310 FICA- Employer 19,691 19,396 28,583 36,580 151-511350 TMRS - Employer 18,661 23,323 39,362 62,450 151-511410 Health - Employer 10,800 8,621 22,148 25,720 151-511500 Workers Compensation 964 430 823 849 Total Personnel Services 302,171 315,089 515,250 626,857 Supplies 151-521100 Office Supplies 619 287 1,700 2,900 Total Supplies 619 287 1,700 2,900 Staff Support 151-535100 Uniforms 125 41 280 330 151-535200 Annual Awards 4,464 1,821 3,000 151-535300 Memberships 2,342 3,262 3,200 5,000 151-535400 Publications 142 120 120 151-535500 TraininglTravel 12,267 10,388 1 0,000 15,000 151-535600 Professional Certification 205 205 250 Total Staff Support 19,545 15,512 16,805 20,700 Operating Equipment 151-571300 Computer & Peripherals 151-571500 Operating Equipment 1,386 15,900 Total Supplies 1,386 15,900 14 CITY OF SCHERTZ COMMENT ARY DEPARTMENT: 311 / CUSTOMER RELATIONS FUNCTION: The 311 / Customer Relations Department is responsible for the Customer Service functions for the City of Schertz. It functions under the oversight of the City Manager's Department. Customer Relations call center serves as the clearing house for information to and from external and internal customers. Customer Relations operates the City switchboard which includes the 311 dial-in function. In addition, this department manages the email traffic from external customers using the www.schertz.comwebsite.This department includes two Customer Relations /311 operators. 15 101 GENERAL FUND C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES CUSTOMER RELATIONS-311 Personnel Services 151-511110 Regular 151-511120 Overtime 151-511180 L TO 151-511210 Longevity 151-511310 FICA- Employer 151-511350 TMRS - Employer 151-511410 Health - Employer 151-511500 Workers Compensation Total Personnel Services Supplies 151-521100 Office Supplies Total Supplies Staff Support 151-535100 Uniforms 151-535500 Training/Travel Total Staff Support OperatinQ EQuipment 151-571300 Computer & Peripherals 151-571500 Operating Equipment Total Operating Equipment 96,495 302 924 7,453 12,723 15,656 173 133,726 100 100 90 90 16 CITY OF SCHERTZ COMMENT ARY DEPARTMENT: MUNICIPAL COURT FUNCTION: The purpose of the 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. It is also the responsibliity of this department to maintain accurate records as the court case progresses through judgement and the satisfaction of that judgment including the collection of court costs and fines. 17 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES MUNICIPAL COURT Personnel Services 152-511110 Regular 182,136 283,837 303,546 206,321 152-511120 Overtime 942 1,705 4,000 4,000 152-511180 L TO 455 748 938 652 152-511210 Longevity 1,680 1,752 2,844 2,280 152-511220 Clothing Allowance 931 1,540 916 152-511230 Certification Allowance 203 405 1 ,430 806 152-511240 Vehicle Allowance 2,409 2,308 2,400 152-511310 FICA - Employer 13,402 21,315 23,469 16,090 152-511350 TMRS - Employer 15,485 25,564 32,421 27,468 152-511410 Health - Employer 20,655 33,222 39,866 26,838 152-511500 Workers Compensation 2,097 2,275 3,313 1,921 Total Personnel Services 239,464 374,062 415,767 287,292 Supplies 152-521100 Office Supplies 2,606 1,208 2,000 2,000 152-521300 Vehicle Maint. Supplies 200 152-521600 Equip Maint Supplies 1,822 3,844 2,500 2,500 Total Supplies 4,428 5,052 4,500 4,700 City Support Services 152-532800 Special Events 2,000 3,000 3,000 2,000 Total City Support Services 2,000 3,000 3,000 2,000 Utilitv Services 152-533500 Vehicle Fuel 1,176 2,124 3,000 2,000 Total Utility Services 1,176 2,124 3,000 2,000 Operations Support 152-534200 Printing & Binding 4,758 3,847 7,000 5,000 Total Operations Support 4,758 3,847 7,000 5,000 18 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Staff Support 152-535100 Uniforms 909 1,750 1,000 152-535300 Memberships 295 419 1,350 1 ,400 152-535400 Publications 692 1,261 2,000 2,500 152-535500 TrainingfTravel 691 2,583 6,395 6,000 152-535600 Professional Certifications 50 100 100 Total Staff Support 1,728 5,172 11,595 11,000 Court Support 152-536400 Collection Expense 1,013 152-536500 Court/Jury Cost 198 325 1,600 500 Total Court Support 1,211 325 1,600 500 Professional Services 152-541300 Other Consul/Prof Service 7,109 9,121 14,200 52,900 Total Professional Services 7,109 9,121 14,200 52,900 Maintenance Services 152-551400 Minor & Other Equip. Maint. 500 1,367 7,000 1,000 Total Maintenance Services 500 1,367 7,000 1,000 Operating Eauipment 152-571200 Vehicle Accessories 2,000 152-571300 Computer Peripherals 2,805 11,966 14,500 12,000 152-571400 Communications Equipment 2,187 5,286 500 500 Total Operating Equipment 4,992 17,252 15,000 14,500 Capital Overlav 152-581200 Vehicles 24,000 Total Capital Overlay 24,000 19 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. 20 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES PLANNING AND ZONING Personnel Services 154-511110 Regular 89,438 128,739 195,810 240,366 154-511120 Overtime 5,651 2,878 1,000 2,500 154-511180 L TO 233 330 626 765 154-511210 Longevity 912 1,164 7,284 6,450 154-511310 FICA - Employer 7,046 10,123 15,539 18,881 154-511350 TM RS - Employer 7,784 11,793 21,394 32,234 154-511410 Health - Employer 8,807 11,391 19,933 22,365 154-511500 Workers Compensation 229 223 452 635 Total Personnel Services 120,100 166,641 262,038 324,196 Supplies 154-521000 Operating Supplies 734 737 1,500 1,000 154-5211 00 Office Supplies 1,626 1,540 2,100 1,500 154-521600 Equipment Supplies 200 1,261 900 900 Total Supplies 2,560 3,538 4,500 3,400 City Support Services 154-532800 Special Events 40 74 1,500 500 Total City Support Services 40 74 1,500 500 Operations Support 154-534200 Printing & Binding 30 479 1,500 500 Total Operations Support 30 479 1,500 500 Staff Support 154-535100 Uniforms 18 200 300 500 154-535300 Memberships 734 1,584 3,015 3,015 154-535400 Publications 157 1 ,433 1,825 1,825 154-535500 TraininglTravel 5,082 12,569 17,000 20,000 154-535510 Meeting Expenses 800 Total Staff Support 5,991 15,786 22,140 26,140 21 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 101 GENERAL FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Professional Services 154-541300 Engineering Services 96,757 71,549 154-541400 Consulting 50,480 35,000 154-541500 State/County Admin Fees 2,000 2,500 Total Professional Services 96,757 71,549 52,480 37,500 Rental-ROW 154-461200 Lease/purchase agmts 601 2,878 669 Total Rental-ROW 601 2,878 669 Operatina EQuipment 154-571200 Fixtures & Equipment 3,372 2,000 5,725 Total Operating Equipment 3,372 2,000 5,725 22 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. 23 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES LEGAL SERVICES Operations Support 155-534100 Advertising/Legal Notices 13,701 39,702 14,000 14,000 Total Operations Support 13,701 39,702 14,000 14,000 Professional Services 155-541200 Legal Services 285,504 204,744 175,000 235,000 Total Professional Services 285,504 204,744 175,000 235,000 24 CITY OF SCHERTZ COMMENTARY DEPARTMENT: GENERAL SERVICES FUNCTION: This department's main functions include, but are not limited to, facilities maintenance repairs and upkeep of all City facilities, building access and security, custodial services, set up for meetings, special events and building rentals. Preventive maintenance and energy management programs. Responsibilities include, maintaining 14 facilities totaling 122,683 sq. ft. with a value of $11 ,362,300. Consisting of carpet, tile floors, other flooring, roofing systems, office/storage areas, rest rooms, cells, meeting/training rooms, sinks and water fountains, air condition units, light bulbs and ballasts, emergency generators, average of 98 meetings/events monthly along with numerous maintenance projects, repairs and over 550 completed work orders. This fiscal year's budget includes maintaining our new facility/shop which is located towards the back of the Municipal Buildings Complex and anticipating the City Hall annex building to also come on line this fiscal year. 25 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL FUND EXPENDITURES GENERAL SERVICES Personnel Services 161-511110 Regular 151,919 172,847 243,183 262,850 161-511120 Overtime 4,742 6,103 6,500 11,500 161-511180 L TO 391 469 765 838 161-511210 Longevity 6,228 6,900 7,692 8,861 161-511310 FICA - Employer 11,655 13,202 19,192 20,786 161-511350 TMRS - Employer 13,250 16,436 26,423 35,485 161-511410 Health - Employer 20,893 26,580 39,867 40,257 161-511500 Workers Compensation 8,296 4,132 7,033 5,845 Total Personnel Services 217,374 246,669 350,655 386,422 Supplies 161-521000 Operating Supplies 19,229 22,043 37,000 43,500 161-521100 Office Supplies 565 23,545 600 800 161-521200 Medical/Chemical Supplies 3,942 4,785 11,730 8,900 161-521300 Motor Veh. Supplies 360 478 772 1,072 161-521600 Equip Maint Supplies 264 585 585 Total Supplies 24,096 51,115 50,687 54,857 Utilitv Services 161-533100 Gas Utility Service 183 251 7,550 750 161-533200 Electric Utility Service 32,667 41,502 87,997 75,000 161-533410 Water Utility Service 3,937 9,062 12,000 12,000 161-533500 Vehicle Fuel 3,053 4,007 4,800 4,800 Total Utility Services 39,840 54,822 112,347 92,550 Operations Support 161-534200 Printing & Binding 60 179 240 Total Operations Support 60 179 240 26 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 101 GENERAL FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Staff Support 161-535100 Uniforms 2,912 3,135 4,500 4,500 161-535210 Employee Recognition 386 1,050 1,050 161-535300 Memberships 139 423 483 483 161-535400 Publications 253 253 285 253 161-535500 Training/Travel 1,062 1,941 2,000 3,000 161-535510 Meeting Expenses 750 Total Staff Support 4,366 6,138 8,318 10,036 Maintenance Services 161-551100 Building Maintenance 29,788 62,092 57,035 75,000 161-551400 Minor & Other Equip Maint 287 544 550 550 161-551700 Ground Maintenance 3,700 560 2,800 3,490 161-551800 Other Maint. Agreement 5,823 4,348 8,590 14,395 Total Maintenance Services 39,598 67,544 68,975 93,435 Rental-ROW 161-561100 Rental Equipment 213 463 750 750 Total Rental-ROW 213 463 750 750 OperatinQ EQuipment 161-571100 Furniture and Fixtures 2,320 375 1,950 161-571500 Operating Equipment 2,715 977 3,202 3,500 Total Operating Equipment 2,715 3,297 3,577 5,450 Capitalized EQuipment 161-581200 Vehicles 16,574 18,000 161-581700 Improvements over $5,000 5,200 16,167 Total Capitalized Equipment 21 ,774 34,167 27 CITY OF SCHERTZ COMMENTARY DEPARTMENT: CITY SECRETARY FUNCTION: The City Secretary is appointed by the City Council and is the Official Custodian of all City records. The City Secretary's Department consists of the City Secretary and the Deputy City Secretary. The function of the Department is to attend, record and post all Official City meetings, and ensure adherence to the Texas Open Meetings Act. The Department oversees all City Elections. 28 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES CITY SECRETARY Personnel Services 164-511110 Regular 142,745 86,831 94,457 97,848 164-511120 Overtime 16 164-511180 L TO 353 234 292 308 164-511210 Longevity 7,140 1,056 1,308 1,614 164-511310 FICA - Employer 11,230 6,791 7,281 7,609 164-511350 TMRS - Employer 12,018 7,845 10,024 12,990 164-511410 Health - Employer 12,054 8,963 8,859 8,946 164-511500 Workers Compensation 507 148 212 177 Total Personnel Services 186,063 111,868 122,433 129,492 Supplies 164-521100 Office Supplies 3,705 1,260 1,500 1,500 164-521200 Medical/Chem Supplies 553 Total Supplies 4,258 1,260 1,500 1,500 Citv Support Services 164-532700 Records Management 14,725 3,356 3,000 18,000 Total City Support Services 14,725 3,356 3,000 18,000 Operations Support 164-534200 Printing & Binding 1,905 44 200 200 Total Operations Support 1,905 44 200 200 Staff Support 164-535100 Uniforms 102 140 75 164-535300 Memberships 591 486 500 500 164-535400 Publications 754 444 250 250 164-535500 Training/Travel 2,172 2,719 5,000 5,000 Total Staff Support 3,517 3,751 5,890 5,825 29 CITY OF SCHERTZ COMMENTARY DEPARTMENT: NON DEPARTMENTAL FUNCTION: This department accounts for expenses and payments that are not specific to an individual function/department. Items in this department include Audit cost, City Insurance, Appraisal District contract, and Medical Services. 30 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES NONDEPARTMENTAL Supplies 167 -521000 Operating Supplies 17,930 Total Supplies 17,930 City Support Services 167 -532100 Sponsorships 250 167-532200 County Appraisal District 57,823 72,155 72,136 70,000 167 -532500 City Ins-Commercial 113,211 135,982 125,000 125,000 167 -532900 Contingencies 36,522 13,848 25,000 25,000 Total City Support Services 207,556 221,985 222,136 220,250 Operations Support 167-534000 Postage 30,512 31,172 45,000 52,000 167 -534300 Equip. Maintenance 34,016 35,609 40,000 45,000 167 -534600 Annexation Costs 12,072 Total Operations Support 76,600 66,781 85,000 97,000 Staff Support 167-535500 Travel/Training 2,832 2,900 1,000 Total Staff Support 2,832 2,900 1,000 City Assistance 167-537100 Medical Services 180,499 280,000 298,700 337,271 Total City Assistance 180,499 280,000 298,700 337,271 Professional Services 167-541300 Other Prof Services 15,633 9,272 25,758 24,000 167-541400 Auditor/Accounting Serv 23,810 35,925 35,000 48,200 167-541500 State/County & Admin Fees 2,534 2,675 3,211 3,800 167-541600 Miscellaneous Bank Charges 7,673 12,139 7,500 17,000 167-541800 Credit Card Service Fee 10,000 Total Professional Services 49,650 60,011 71,469 103,000 Fund CharQes/Transfers 167-548106 Transfer to Special Event Fd 9,864 6,500 6,500 5,000 Total Transfers 9,864 6,500 6,500 5,000 31 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 101 GENERAL FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES NONDEPARTMENTAL Capital Outlav 167 -581000 land Purchase Total Capital Outlay 410,376 410,376 TOTAL NONDEPARTMS:NTAl ...... 638,109 1,097,081 781,451 32 CITY OF SCHERTZ COMMENTARY DEPARTMENT: COMMUNITY & MEDIA RELATIONS FUNCTION: The City of Schertz Community & Media Relations office is the official liaison between the City and the news media. The goal of this office is to facilitate an accurate and consistent flow of public information to the City's various constituencies., Additionally, this office provides, plans and organizes programs and services designed to inform the public and to generate support from the public for local government. 33 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES COMMUNITY & MEDIA RELATIONS Personnel Services 170-511110 Regular 35,449 42,676 80,142 119,393 170-511180 L TO 83 244 371 170-511210 Longevity 112 120 230 170-511240 Vehicle Allowance 3,000 3,000 170-511310 FICA- Employer 2,695 3,239 6,140 9,151 170-511350 TMRS - Employer 2,869 3,782 8,453 15,623 170-511410 Health - Employer 3,263 4,139 8,859 13,419 170-511500 Workers Compensation 156 71 178 212 Total Personnel Services 44,515 54,019 107,136 161,399 Supplies 170-521100 Office Supplies 615 1,525 2,000 2,000 Total Supplies 615 1,525 2,000 2,000 Operations Support 170-534100 Advertising 569 8,025 32,000 163,500 170-534200 Printing & Binding 12,848 5,000 12,500 Total Operations Support 13,417 8,025 37,000 176,000 Staff Support 170-535100 Uniforms 390 200 300 170-535300 Memberships 87 250 200 170-535400 Publications 500 350 170-535500 Trainingrrravel 709 1,395 5,000 2,500 170-535510 Meeting Expenses 1,000 170-535600 Professional Certification 80 500 500 Total Staff Support 876 1,785 6,450 4,850 Operatina Eauipment 170-571500 Operating Equipment 1,043 5,431 12,800 6,000 Total Operating Equipment 1,043 5,431 12,800 6,000 34 CITY OF SCHERTZ COMMENT ARY DEPARTMENT: RECORDS MANAGEMENT FUNCTION: This department is responsible for maintaining the City's Record Management Program in accordance with our 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. This office is also responsible for the Public Information Act. We work closely with the City Attorney and must have a legal understanding of information that is public and information that is confidential. 35 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES RECORDS MANAGEMENT Personnel Services 171-511110 Regular 81,351 72,407 77,359 171-511120 Overtime 171-511180 LTD 204 233 250 171-511210 Longevity 3,444 3,048 3,344 171-511310 FICA - Employer 5,972 5,772 6,174 171-511350 TMRS - Employer 7,372 7,947 10,540 171-511410 Health - Employer 8,653 8,859 8,946 171-511500 Workers Compensation 141 168 143 Total Personnel Services 107,137 98,434 106,756 Supplies 171-521000 Operating Supplies 321 304 1 ,400 171-521100 Office Supplies 353 500 Total Supplies 321 657 1,900 Utilitv Services 171-533500 Vehicle Fuel 1,000 Total Utility Services 1,000 Staff Support 171-535100 Uniforms 124 140 150 171-535300 Memberships 230 225 225 171-535500 Trainingrrravel 1,056 376 419 171-535510 Meeting Expense 545 Total Staff Support 1,410 741 1,339 Professional Services 171-541300 Other Consul/Prof Svcs 1,391 10,500 50,000 Total Professional Services 1,391 10,500 50,000 Operatina EQuipment 171-571400 Computer Equipment 1,181 1,824 Total Operating Equipment 1,181 1,824 36 CITY OF SCHERTZ COMMENTARY DEPARTMENT: ENGINEERING FUNCTION: Performs engineering duties in planning, designing, and overseeing construction and maintenance of building structures, and facilities, such as roads, bridges, channels, pipelines, power plants, water and sewage systems, and waste disposal units. Provides professional technical services in connection with planning and executing a wide variety of public works improvement programs. 37 101 GENERAL FUND C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES ENGINEERING Personnel Services 173-511110 Regular 173-511120 Overtime 173-511180 L TO 173-511210 Longevity 173-511310 FICA - Employer 173-511350 TMRS - Employer 173-511410 Health - Employer 173-511500 Workers Compensation Total Personnel Services Supplies 173-521000 Operating Supplies 173-521100 Office Supplies 173-521600 Equipment Supplies Total Supplies Staff Support 173-535100 Uniforms 173-535300 Memberships 173-535400 Publications 173-535500 Training/Travel Total Staff Support Professional Services 173-541100 Engineering Services 173-541400 Other Prof Services 173-541500 Surveying Service Total Professional Services Rental-ROW 173-561200 Lease & Purchase Agmt Total Rental-ROW 38 61,756 67,487 192 209 4,726 5,163 6,507 8,814 4,429 8,946 138 120 77,748 90,739 1,100 1,500 500 1,200 3,200 1,100 70 200 350 500 2,500 3,550 1,000 1,070 50,000 11,300 19,000 80,300 85,000 10,000 2,500 97,500 3,500 3,500 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 OperatinQ Equipment 173-571400 Computer Equipment Total Operating Equipment 5,000 5,000 3,800 3,800 ;'rQTALEN~INEERIN~' DEP . 165,218 202,289 39 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 answered in excess of 32,900 calls for service in 2006/2007 fiscal year while striving to maintain a response time averaging 5.00 minutes. Officers generated 21,105 field generated calls and will averaging around 19,000 citations issued. In fiscal year 2007/2008 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. To be able to achieve this goal we need to increase the amount of patrol officers on the street. At this time we have 23 officers for an estimated population of 35,000. Using the normal formula of 1 officer per 1,000 you can see we fall short of the officers required. By adding 3 officers during this budget year it will aid us in obtaining our goals and not take from other departments needing additional manpower. 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 S.T.E.P and the use of our Motorcycle Units. 40 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES POLICE Personnel Services 256-511110 Regular 1,752,890 1,964,688 2,281,579 2,740,337 256-511120 Overtime 12,825 6,916 22,984 15,000 256-511180 L TO 4,342 5,213 7,290 8,838 256-511210 Longevity 46,380 49,152 53,184 61,542 256-511220 Clothing Allowance 46,713 44,497 46,250 56,368 256-511230 Certification Allowance 12,078 14,840 23,219 17,700 256-511310 FICA - Employer 139,360 155,277 180,324 220,010 256-511350 TMRS - Employer 150,785 179,923 250,370 372,335 256-511410 Health - Employer 176,392 206,605 243,626 295,218 256-511500 Workers Compensation 60,482 34,634 46,691 46,419 Total Personnel Services 2,402,247 2,661,745 3,155,517 3,833,767 Supplies 256-521000 Operating Supplies 5,871 9,275 27,837 28,082 256-521100 Office Supplies 2,937 1,369 2,000 2,000 256-521300 Motor Veh. Supplies 517 38 700 3,800 256-521600 Equip Maint Supplies 488 442 550 550 Total Supplies 9,813 11,124 31,087 34,432 City-Support Services 256-532500 City-Insurance-Comm. 21,627 20,640 23,000 23,000 Total City Support Services 21,627 20,640 23,000 23,000 Utility Services 256-533100 Gas Utility Service 256-533200 Electricity Utility Service 256-533410 Water Utility Service 256-533500 Vehicle Fuel 60,700 74,958 80,000 70,000 Total Utility Services 60,700 74,958 80,000 70,000 Operations Support 256-534100 Advertising 105 256-534200 Printing & Binding 1,362 1,214 1,300 1,300 Total Operations Support 1 ,467 1,214 1,300 1,300 41 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Staff Support 256-535200 Annual Awards 471 244 500 256-535210 Employee Recognition 200 200 256-535300 Memberships 833 909 930 450 256-535400 Publications 137 158 1,000 500 256-535500 TraininglTravel 12,475 7,856 13,000 16,000 256-535510 Meeting Expense 350 256-535500 T-Class Training 1,517 816 3,000 3,200 Total Staff Support 15,433 9,983 18,630 20,700 City Assistance 256-537100 Medical Services 3,996 4,070 4,000 5,000 256-537500 Citizen's Police Academy 199 141 2,000 1,500 256-537800 Crime/Fire Prevention 784 7,225 8,400 8,500 Total City Assistance 4,979 11 ,436 14,400 15,000 Professional Services 256-541300 Other Consult/Prof Serv. 538 2,002 4,100 5,000 Total Professional Services 538 2,002 4,100 5,000 Maintenance Services 256-551400 Minor & Other Equip. Maint. ' 7,339 1,772 6,000 6,000 256-551800 Other Maintenance Agrmt 7,927 11,838 17,182 40,181 Total Maintenance Services 15,266 13,610 23,182 46,181 Operatina Equipment 256-571000 Furniture & Fixtures 663 795 2,500 9,302 256-571200 Vehicle Accessories 21,390 51,600 256-571300 Computer & Peripherals 500 256-571800 Other Equipment 675 22,298 Total Operating Equipment 1,338 44,483 2,500 61,402 Capitalized Equipment 256-581200 Motor Vehicles 30,899 60,157 223,100 256-581800 Equipment over $5,000 87,950 Total Capitalized Equipment 30,899 60,157 311,050 42 CITY OF SCHERTZ COMMENT ARY DEPARTMENT: FIRE FUNCTION: Established in 1956 as a volunteer fire department. Today, the department has 27 full-time firefighters and 5 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 Department responses are 16% over last year, reflecting the continued growth in the area. However, value of the property loss is less serious, and we have not had any life loss in the last six 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. 43 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES FIRE DEPARTMENT Personnel Services 257-511110 Regular 1,065,447 1,240,064 1,301,723 1,401,445 257-511120 Overtime 63,966 52,015 76,420 60,000 257-511180 L TO 2,703 3,371 4,132 4,507 257-511210 Longevity 17,328 20,952 23,820 39,349 257-511220 Clothing Allowance 8,884 9,564 9,672 9,382 257-511230 Certification Allowance 5,910 14,874 20,560 24,050 257-511310 FICA - Employer 86,449 99,410 102,468 112,800 257-511350 TMRS - Employer 95,383 117,483 142,031 189,855 257-511410 Health - Employer 105,225 130,889 141,746 143,136 257-511500 Workers Compensation 25,060 17,685 24,670 20,784 Total Personnel Services 1,476,355 1,706,307 1,847,242 2,005,308 Supplies 257-521000 Operating Supplies 1,878 1,314 5,250 5,200 257-521100 Office Supplies 2,119 655 1,100 1,600 257-521200 Medical/Chemical Supplies 8,934 7,058 8,793 10,920 257-521300 Motor Veh. Supplies 303 162 600 1,100 257-521600 Equip Maint Supplies 5,534 1,911 2,250 2,500 Total Supplies 18,768 11, 1 00 17,993 21,320 Utilitv Services 257-533100 Gas 1,864 3,200 3,500 257 -533200 Electricity 880 8,205 7,800 10,000 257 -533410 Water Utility Service 912 1,900 2,000 257-533500 Vehicle Fuel 15,378 19,621 15,000 18,000 Total Utility Services 16,258 30,602 27,900 33,500 Operations Support 257-534100 Advertising 137 200 200 257-534200 Printing & Binding 325 479 550 500 Total Operations Support 325 616 750 700 44 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Staff Support 257 -535000 Uniforms 20,481 24,851 21,966 48,176 257 -535300 Memberships 1 ,439 2,440 2,105 2,595 257 -535400 Publications 936 4,806 4,000 3,000 257-535500 Trainingrrravel 13,597 12,207 20,700 31,812 257 -535510 Meeting Expenses 1,000 257 -535600 Professional Certifications 1,644 1,532 2,170 2,000 Total Staff Support 38,097 45,836 50,941 88,583 City Assistance 257 -537800 Crime/Fire Prevention 9,462 9,305 9,400 10,000 Total City Assistance 9,462 9,305 9,400 10,000 Maintenance Services 257-551400 Minor & Other Equip Maint 2,995 4,200 3,500 3,500 257-551800 Other Maintenance Agrmnts 1,750 11 ,400 Total Maintenance Services 2,995 4,200 5,250 14,900 Rental-ROW 257 -561200 Lease/Purchase Payments 2,880 Total Rental-ROW 2,880 Operating Equipment 257-571300 Computer & Peripherals 2,545 300 2,000 2,500 257-571400 Communications Equipment 2,517 6,185 19,945 257-571600 Police/Fire/Medical Equip. 9,782 15,918 16,950 257-571800 Other Equipment 3,539 2,349 600 Total Operating Equipment 8,601 12,431 24,703 39,395 Capitalized Equipment 257-581200 Motor Vehicle 449,996 57,750 74,500 Total Capitalized Equipment 449,996 57,750 74,500 45 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. 46 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES INSPECTIONS Personnel Services 258-511110 Regular 188,931 207,371 256,417 282,665 258-511120 Overtime 3,331 3,087 3,500 3,600 258-511180 L TD 479 538 828 902 258-511210 Longevity 7,428 8,736 6,684 7,306 258-511230 Certification Allowance 900 258-511310 FICA - Employer 13,975 16,197 20,595 22,252 258-511350 TMRS - Employer 16,353 19,499 28,355 37,988 258-511410 Health - Employer 21 ,585 25,378 35,436 35,784 258-511500 Workers Compensation 1,641 1,181 1,306 1,091 Total Personnel Services 253,723 281,987 353,121 392,488 Supplies 258-521000 Operating Supplies 2,926 2,818 2,850 3,000 258-521100 Office Supplies 2,000 2,000 258-521200 Medical Supplies 338 207 100 100 258-521600 Equip Maint Supplies 390 900 1,200 Total Supplies 3,654 3,025 5,850 6,300 Utilitv Services 258-533500 Vehicle Fuel 4,129 5,261 5,500 6,000 Total Utility Services 4,129 5,261 5,500 6,000 Operations Support 258-534100 Advertising 106 216 500 200 258-534200 Printing & Binding 2,565 2,235 3,000 3,000 Total Operations Support 2,671 2,451 3,500 3,200 Staff Support 258-535100 Uniforms 1,295 1,717 3,050 3,050 258-535300 Memberships 730 355 750 750 258-535400 Publications 1,504 703 2,400 2,400 258-535500 TraininglTravel 5,269 5,258 5,370 10,895 258-535510 Meeting Expense 810 258-535600 Professional Certifications 509 618 1 ,400 1 ,400 Total Staff Support 9,307 8,651 12,970 19,305 47 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Professional Services 258-541300 Other Consult/Prof Service 32,241 37,341 6,121 20,000 Total Professional Services 32,241 37,341 6,121 20,000 Maintenance Services 258-551700 Lot Cleaning 799 40 2,446 5,000 Total Maintenance Services 799 40 2,446 5,000 Operating Equipment 258-571000 Furniture & Fixtures 2,180 1,866 1,354 Total Operating Equipment 2,180 1,866 1,354 Capital Outlav 258-581200 Motor Vehicles 15,543 19,000 33,000 Total Capital Outlay 15,543 19,000 33,000 48 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. 49 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PUBLIC ENVIRONMENT EXPENDITURES STREETS Personnel Services 359-511110 Regular 222,614 251,727 295,972 375,563 359-511120 Overtime 3,166 1,837 5,000 5,000 359-511180 L TO 561 667 926 1,194 359-511210 Longevity 6,276 6,828 7,824 9,335 359-511230 Certification Allowance 358 300 300 359-511310 FICA - Employer 16,656 18,849 23,263 29,468 359-511350 TMRS - Employer 18,986 23,120 32,029 50,307 359-511410 Health - Employer 32,920 39,829 48,725 58,149 359-511500 Workers Compensation 29,910 15,686 18,990 18,433 Total Personnel Services 331,089 358,901 433,029 547,749 Supplies 359-521000 Operating Supplies 2,484 1,713 2,500 2,500 359-521100 Office Supplies 766 120 150 150 359-521200 Medical/Chemical Supplies 430 521 1,500 1,500 359-521300 Motor Vehicle Supplies 619 568 800 800 Total Supplies 4,299 2,922 4,950 4,950 Utilitv Services 359-533200 Electricity Utility Service 34,182 57,092 45,000 57,000 359-533410 Water Utility Service 727 755 900 900 359-533500 Vehicle Fuel 24,951 29,391 21,000 30,000 Total Utility Services 59,860 87,238 66,900 87,900 Operations Support 359-534300 Copy Services 1,960 1,525 Total Operations Support 1,960 1,525 Staff Support 359-535100 Uniforms 4,142 4,263 5,500 5,000 359-535200 Annual Awards 149 200 200 359-535300 Memberships 43 180 180 359-535500 TraininglTravel 911 606 1,500 1,000 359-535600 Professional Certifications 300 300 Total Staff Support 5,096 5,018 7,680 6,680 50 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Maintenance Services 359-551100 Building Maintenance 116 272 800 359-551400 Minor & Other Equip. Maint. 878 857 2,000 1,500 359-551600 Street Maintenance 60,856 99,816 125,000 175,000 Total Maintenance Services 61,850 100,945 127,000 177,300 Rental-ROW 359-561100 Rental Equipment 816 1 ,420 1,000 200 359-561200 Lease/Purchase Payments 84 84 Total Rental-ROW 816 1 ,420 1,084 284 Operating Equipment 359-581800 Other Equipment 2,682 1,000 1,000 Total Operating Equipment 2,682 1,000 1,000 Capital Outlav 359-581500 Equipment over $5,000 22,845 5,209 47,000 Total Capital Outlay 22,845 5,209 47,000 51 CITY OF SCHERTZ COMMENT ARY 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. The City maintains over 200 acres of park land and equipment, including a new ball field complex. The parks department is responsible for the use and maintenance of the new facility as well as coordination with recreational organizations, such as Buffalo Valley Youth Association. 52 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PARKS & RECREATION EXPENDITURES PARKS Personnel Services 460-511110 Regular 209,691 234,468 330,269 269,852 460-511120 Overtime 1,195 3,322 3,500 3,000 460-511180 L TO 527 608 1,031 790 460-511210 Longevity 6,816 7,752 8,688 3,624 460-511240 Vehicle Allowance 1,506 1,500 3,000 3,000 460-511310 FICA - Employer 16,326 17,824 25,930 20,921 460-511350 TMRS - Employer 17,872 21,269 35,681 33,579 460-511410 Health - Employer 24,482 28,846 39,866 35,784 460-511500 Workers Compensation 4,941 2,596 4,470 5,394 Total Personnel Services 283,356 318,185 452,435 375,944 Supplies 460-521000 Operating Supplies 8,739 9,835 15,000 15,000 460-5211 00 Office Supplies 467 467 1,000 500 460-521200 Medical/Chemical Supplies 180 1,078 1,000 500 460-521400 Plumbing Supplies 3,727 908 2,000 2,000 Total Supplies 13,113 12,288 19,000 18,000 Utilitv Services 460-533200 Electric Utility Service 20,040 40,227 48,000 21,000 460-533410 Water Utility Service 17,141 22,391 25,000 20,000 460-533500 Vehicle Fuel 5,126 8,602 6,200 7,000 Total Utility Services 42,307 71,220 79,200 48,000 Operations Support 460-534200 Printing & Binding 3 319 1,500 500 Total Operations Support 3 319 1,500 500 Staff Support 460-535100 Uniforms 2,513 2,001 3,000 2,700 460-535300 Memberships 427 265 500 300 460-535500 TraininglTravel 1,658 1,932 2,530 3,450 460-535510 Meeting Expenses 500 Total Staff Support 4,598 4,198 6,030 6,950 53 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Professional Services 460-541300 Other Prof. Services 47,900 Total Professional Services 47,900 Maintenance Services 460-551100 Building Maintenance 2,927 2,783 3,000 5,000 460-551400 Minor & Other Equip Maint. 3,028 4,679 5,000 5,000 460-551500 Water & Sewer Maint. 500 500 460-551600 Street Maint. Material 364 5,000 5,000 460-551702 Parkway Maintenance 26,316 27,684 34,316 27,000 Total Maintenance Services 32,635 35,146 47,816 42,500 Rental-ROW 460-561200 Lease/Purchase Payments 1 ,428 500 250 Total Rental-ROW 1 ,428 500 250 Capital Outlav 460-581200 Vehicles over $5,000 33,000 25,000 460-581700 Improvements over $5,000 5,4 75 35,000 500,000 460-581800 Equipment over $5,000 53,200 5,000 460-581900 Improvements - Signs 60,000 Total Capital Outlay 58,675 128,000 530,000 54 CITY OF SCHERTZ COMMENTARY DEPARTMENT: POOL FUNCTION: To provide and maintain a well-managed and safe environment for aquatic recreation for the citizens of our community as well as a system of instruction in aquatic safety, recreational swimming and physical fitness. The City of Schertz operates 2 pool facilities, one in Pickrell Park and one in the northern part of Schertz at 601 Cherry Tree Dr. 55 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED PARKS & RECREATION EXPENDITURES POOLS Personnel Services 463-511110 Regular 80,909 107,760 137,349 463-511120 Overtime 471 463-511310 FICA - Employer 6,252 8,244 10,507 463-511350 TMRS - Employer 526 463-511500 Workers Compensation 2,618 1,684 2,373 2,316 Total Personnel Services 90,250 1,684 118,903 150,172 Supplies 463-521 000 Operating Supplies 737 1,723 1,500 5,000 463-5211 00 Office Supplies 278 145 300 500 463-521200 Medical/Chemical Supplies 15,433 3,937 15,000 15,000 463-521600 Equip Maint Supplies 769 253 1,000 500 Total Supplies 17,217 6,058 17,800 21,000 Utility Services 463-533200 Electric Utility Service 15,370 16,624 15,000 16,000 463-533410 Water Utility Service 3,841 7,681 4,000 5,000 Total Utility Services 19,211 24,305 19,000 21,000 Staff Support 463-535100 Uniforms 502 500 600 463-535500 TraininglTravel 2,725 35 2,000 3,000 463-535510 Meeting Expenses 100 Total Staff Support 3,227 35 2,500 3,700 Maintenance Services 463-551100 Building Maintenance 487 117 1,100 2,000 463-551400 Minor & Other Equip Maint. 201 978 1,000 5,000 463-551700 Contract Maintenance 112,575 Total Maintenance Services 688 113,670 2,100 7,000 56 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 101 GENERAL FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Rental-ROW 463-561200 Lease/Purchase Payments Total Rental-ROW 315 315 404 404 500 500 500 500 Capital Outlay 463-581800 Equipment over $5,000 Total Capital Outlay 30,000 30,000 TOTAL POOLS 203,372 57 CITY OF SCHERTZ COMMENT ARY DEPARTMENT: CIVIC CENTER FUNCTION: In conjunction with the mission statement of the City of Schertz, it is the function of the Civic Center to provide space for: 1. The City of Schertz to use for educational, recreational and cultural events that support the mission of the City. 2. Non-profit groups and governmental entities for activities that ultimately enhance the quality of life on the citizens of Schertz. 3. Provision of rental space to generate income to help off-set the cost of operation of the facility. 58 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 101 GENERAL FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED CULTURAL EXPENDITURES COMMUNITY/CIVIC CENTER Personnel Services 464-511110 Regular 464-511120 Overtime 464-511180 L TD 464-51121 0 Longevity 464-511240 Vehicle Allowance 464-511310 FICA - Employer 464-511350 TMRS-Employer 464-511410 Health-Employer 464-511500 Workers Compensation Total Personnel Services 157,468 1,000 508 6,538 3,000 12,546 21,419 13,419 291 216,189 Supplies 464-521000 Operating Supplies 464-521100 Office Supplies 464-521200 Medical/Chemical Supplies 464-521400 Plumbing Supplies 464-521600 Equipment Maint Supplies Total Supplies 2,000 1,500 500 4,000 Utility Services 464-533200 Electric Utility Service 464-533410 Water Utility Service Total Utility Services 30,000 5,000 35,000 Operations Support 464-534100 Advertising 464-534200 Printing & Binding Total Operations Support 4,000 1,000 5,000 Staff Support 464-535100 Uniforms 464-535300 Memberships 464-535500 TraininglTravel 464-535510 Meeting Expenses Total Staff Support 300 200 2,600 250 3,350 59 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 Rental-ROW 464-561200 Lease/Purchase Payments Total Rental-ROW 200 200 Operating EQuipment 464-571401 Communication Equipment Total Operating Equipment 2,500 2,500 TOTAL COMMUNITY/CIVIC C-=NTER 60 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. 61 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED CULTURAL EXPENDITURES LIBRARY Personnel Services 665-511110 Regular 185,458 220,997 258,961 296,394 665-511120 Overtime 896 675 1,000 1,000 665-511180 LTD 387 447 604 725 665-511210 Longevity 4,284 5,112 6,132 7,180 665-511310 FICA - Employer 13,032 15,894 20,279 23,223 665-511350 TMRS-Employer 13,080 15,407 27,921 39,647 665-511410 Health-Employer 21 ,504 24,837 26,577 31,311 665-511500 Workers Compensation 667 406 602 528 Total Personnel Services 239,308 283,775 342,076 400,008 Supplies 665-521000 Operating Supplies 6,353 5,297 6,000 6,000 665-5211 00 Office Supplies 1,528 983 1,000 2,000 Total Supplies 7,881 6,280 7,000 8,000 Utility Services 665-533200 Electric Utility Service 10,216 12,018 10,000 10,000 665-53341 0 Water Utility Service 1,223 2,217 2,000 2,100 Total Utility Services 11,439 14,235 12,000 12,100 Operations Support 665-534200 Printing & Binding 2,515 1,821 3,500 2,500 Total Operations Support 2,515 1,821 3,500 2,500 Staff Support 665-535100 Uniforms 417 400 400 665-535200 Annual Awards 65 236 300 300 665-535300 Memberships 428 452 450 475 665-535500 TraininglTravel 571 790 1,850 1,500 665-535510 Meeting Expenses 75 Total Staff Support 1,064 1,895 3,000 2,750 Professional Services 665-541300 Other Consl/Prof Svcs 1,510 Total Professional Services 1,510 62 101 GENERAL FUND C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Maintenance Services 665-551300 Computer Maintenance 665-551800 Other Maint Agreement Total Maintenance Services OperatinQ EQuipment 665-571110 Telephones 665-571300 Computer/Peripherals 665-571400 Library Materials Total Operating Equipment Capital Outlay 665-581300 Computer Equipment Total Capital Outlay 5,500 1,925 7,425 4,682 51 ,185 55,867 5,500 1,850 7,350 3,626 63,636 67,262 5,500 1,850 7,350 1,875 1,875 5,000 65,790 70,790 5,000 1,500 66,000 72,500 160,000 160,000 63 384,128 445,716 659,733 CITY OF SCHERTZ COMMENTARY DEPARTMENT: ANIMAL CONTROL FUNCTION: To promote educational programs and services for our community, provide care, licensing, control, and public safety. Provide resources and assistance for wildlife, referral, capture, and relocation. 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, while maintaining comfort and care for all pets during their stay. To provide a Texas Department of State Health Services approved quarantine facility for Rabies control. 64 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED HEALTH EXPENDITURES ANIMAL CONTROL Personnel Services 762-511110 Regular 120,545 125,697 141,083 164,516 762-511120 Overtime 4,755 2,232 9,780 6,000 762-511180 L TD 320 345 432 532 762-511210 Longevity 600 960 1,200 1,550 762-511220 Clothing Allowance 3,132 3,158 3,200 4,160 762-511230 Certification Allowance 3,900 762-511310 FICA - Employer 9,797 9,959 10,885 13,321 762-511350 TMRS-Employer 10,280 11,417 15,205 22,741 762-511410 Health-Employer 17,847 19,670 22,148 26,838 762-511500 Workers Compensation 2,877 1,557 2,161 2,096 Total Personnel Services 170,153 174,995 206,094 245,654 Supplies 762-521000 Operating Supplies 2,929 4,204 5,380 13,000 762-521100 Office Supplies 927 1,000 1,200 762-521200 Medical/Chemical Supplies 6,250 4,907 8,200 9,000 762-521300 Motor Veh. Supplies 108 45 300 Total Supplies 10,214 9,156 14,580 23,500 Utility Services 762-533200 Electric Utility Service 1,542 2,035 3,000 3,000 762-533410 Water Utility Service 2,050 2,427 2,400 2,500 762-533500 Vehicle Fuel 2,481 3,620 4,000 4,000 Total Utility Services .6,073 8,082 9,400 9,500 Operations Support 762-534100 Advertising 184 250 100 762-534200 Printing & Binding 321 213 800 800 Total Operations Support 505 213 1,050 900 65 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED Staff Support 762-535300 Memberships 374 374 500 500 762-535500 TraininglTravel 1,613 635 1,800 1,800 762-535510 Meeting Expenses 200 762-535600 Professional Certification 190 300 Total Staff Support 2,177 1,009 2,600 2,500 City Assistance 762-537100 Medical Services 9,901 9,816 13,000 13,000 Total City Assistance 9,901 9,816 13,000 13,000 Professional Services 762-541300 Other Consult/Prof Service 322 686 700 435 762-541310 Contractual Srvc-Blue Bonnet 2,400 3,500 762-541700 Microchip Service 1,663 4,869 3,000 8,500 762-541702 Spay & Neuter 397 10,250 Total Professional Services 1,985 5,952 6,100 22,685 Maintenance Services 762-551100 Building Maintenance 3,734 611 1,050 762-551400 Minor & Other Equip Maint 55 1,089 1,050 2,000 Total Maintenance Services 3,789 1,700 1,050 3,050 Operatina Eauipment 762-571000 Furniture & Fixtures 10 5 200 6,057 762-571500 Operating Equipment 5,728 4,054 5,950 762-571700 Improvements 1,779 1,113 2,731 Total Operating Equipment 1,789 6,846 6,985 12,007 Capital Outlay 762-581800 Equipment over $5,000 1,916 31,020 18,000 Total Capital Outlay 1,916 31,020 18,000 66 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. 67 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES INFORMATION TECHNOLOGY Personnel Services 853-511110 Regular 100,985 124,995 116,345 59,349 853-511180 L TO 252 327 355 185 853-511210 Longevity 600 840 1,080 210 853-511310 FICA - Employer 7,663 9,463 8,983 4,556 853-511350 TMRS - Employer 8,319 11,123 12,368 7,778 853-511410 Health - Employer 7,179 11,049 11,074 8,946 853-511500 Workers Compensation 375 238 262 106 Total Personnel Services 125,373 158,035 150,467 81 ,130 Supplies 853-521100 Office Supplies 209 46 150 150 853-521600 Equip Maint Supplies 3,357 1,125 3,500 5,000 Total Supplies 3,566 1,171 3,650 5,150 City Support Services 853-532300 Computer Consulting 3,221 839 42,750 120,000 853-532400 Computer Fees & Licenses 62,335 99,821 354,396 161,000 Total City Support Services 65,556 100,660 397,146 281,000 Utility Services 853-533300 Telephone 66,315 88,436 130,068 104,916 853-533500 Vehicle Fuel 320 750 Total Utility Services 66,315 88,756 130,818 104,916 Staff Support 853-535100 Uniforms 140 250 853-535300 Memberships 247 105 300 300 853-535400 Publications 89 50 150 150 853-535500 TraininglTravel 4,740 1,345 21 ,500 10,000 Total Staff Support 5,076 1,500 22,090 10,700 Professional Services 853-541800 IT Svcs-Web Design/Maint 2,000 Total Professional Services 2,000 68 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 101 GENERAL FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Maintenance Services 853-551300 Computer Maintenance 853-551800 Other Maintenance Agreement Total Maintenance Services 6,950 1,990 8,940 Operatina EQuipment 853-571000 Furniture & Fixtures 853-571300 Computer & Peripherals 853-571401 Communication Equipment Total Operating Equipment 71,075 3,220 74,295 12,183 2,171 14,354 11,124 16,354 27,478 21,824 5,500 27,324 6,760 6,760 500 90,000 29,450 119,950 40,940 275,000 36,600 352,540 TOTAL.INF 69 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. Coordinates with City Attorney, as needed, and with Records Management 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. 70 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES HUMAN RESOURCES Personnel Services 866-511110 Regular 64,116 74,642 89,250 116,520 866-511120 Overtime 486 249 750 800 866-511180 L TO 154 196 276 366 866-511210 Longevity 840 1,080 1,392 1,903 866-511310 FICA - Employer 4,556 5,725 6,934 9,029 866-511350 TMRS - Employer 5,206 6,663 9,546 15,413 866-511410 Health - Employer 7,179 8,279 8,859 13,419 866-511500 Workers Compensation 250 125 202 209 866-511600 Unemployment Compensation 1,343 3,793 5,000 16,049 Total Personnel Services 84,130 100,752 122,209 173,708 Supplies 866-521000 Office Supplies 491 159 300 523 Total Supplies 491 159 300 523 Human Services 866-531100 Pre-Employment Check 498 183 3,000 3,000 866-531200 Medical Co-Pay 400 750 1,000 2,000 866-531300 Employee Assistance 6,732 6,171 7,500 8,325 866-531400 Tuition Reimbursement 4,770 3,800 10,000 15,000 866-531500 Fit City Program 1,208 2,000 1,200 Total Human Services 12,400 12,112 23,500 29,525 Operations Support 866-534100 Advertising 9,560 5,332 9,000 15,000 866-534200 Printing & Binding 654 829 1,045 2,718 Total Operations Support 10,214 6,161 10,045 17,718 Staff Support 866-535100 Uniforms 36 150 210 866-535210 Employee Recognition 5,000 5,000 866-535300 Memberships 235 235 250 300 866-535400 Publications 374 900 800 866-535500 TraininglTravel 2,588 1,731 5,000 2,000 Total Staff Support 2,823 2,376 11 ,300 8,310 71 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 101 GENERAL FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED City Assistance 866-537100 Medical Services Total City Assistance 5,544 5,544 4,138 4,138 5,000 5,000 6,000 6,000 Professional Services 866-541300 Other Consul/Prof Service Total Professional Services 5,000 5,000 5,000 5,000 Operatina EQuipment 866-571500 Operating Equipment Total Operating Equipment 5,900 5,900 .tOTAl}~OMAN, . ' .. '... ',_,' ,'" ..',.," ' ' '. . ',',.. '," ;~"","., '._' ~':"'." ,""~",, ::Co ','. :', '. .. ' 72 CITY OF SCHERTZ COMMENT ARY 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, payroll, payables, and cash collections. To facilitate the preparation of the annual budget and the comprehensive annual financial report. Specific duties include investments, budget, debt management, purchasing, financial reporting, accounts payable and payroll. 73 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES FINANCE Personnel Services 868-511110 Regular 167,493 177,186 226,315 294,617 868-511120 Overtime 1,000 500 868-511180 L TO 417 468 700 926 868-511210 Longevity 1,800 2,544 3,000 3,724 868-511230 Cewrtification Allowance 300 868-511310 FICA - Employer 12,681 13,628 17,542 22,846 868-511350 TMRS - Employer 13,916 16,009 24,152 39,003 868-511410 Health - Employer 17,947 19,639 22,148 26,838 868-511500 Workers Compensation 541 306 510 530 Total Personnel Services 214,795 229,780 295,367 389,284 Supplies 868-521000 Operating Supplies 1,833 1,265 1,500 1,500 868-521100 Office Supplies 940 263 1,500 1,500 Total Supplies 2,773 1,528 3,000 3,000 Operations Support 868-534100 Advertising 583 750 868-534200 Printing & Binding 82 142 1,000 500 Total Operations Support 82 142 1,583 1,250 Staff Support 868-535100 Uniforms 311 350 300 868-535300 Memberships 430 690 995 2,000 868-535400 Publications 306 120 265 200 868-535500 TraininglTravel 4,901 3,296 8,490 10,500 868-535600 Professional Certification 500 Total Staff Support 5,637 4,417 10,100 13,500 Operatina EQuipment 868-571000 Furniture & Fixtures 2,399 2,225 550 868-571300 Computer & Peripherals 73 427 2,500 Total Supplies 2,472 2,225 427 3,050 74 CITY OF SCHERTZ COMMENTARY DEPARTMENT: PURCHASING FUNCTION: The purpose of the Purchasing Department is to establish ethical guidelines and accountability for the expenditure of taxpayer funds to procure goods and services used by the City of Schertz departments and offices. The processes used to procure goods and services should always provide the best value (price and quality) for the City, while providing an open and fair process for vendors. This department serves as the central control of procurement activities when acquiring materials, parts, machines, supplies, services, and other goods for all City departments. This Department oversees negotiations for supply contracts; assists in construction projects; recommends, solicits, and supervises bids for services or products over the amount of $50,000. This Department sets policies and procedures that ensure compliance with federal, state, and local laws; provides a readily available supply of required items for immediate pick up; solicits ideas for improved efficiency; and, is responsible for disposing of surplus items. 75 101 GENERAL FUND C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES PURCHASING Personnel Services 872-511110 Regular 872-511120 Overtime 872-511180 L TO 872-511210 Longevity 872-511310 FICA - Employer 872-511350 TMRS - Employer 872-511410 Health - Employer 872-511500 Workers Compensation Total Personnel Services Supplies 872-521000 Operating Supplies 872-521100 Office Supplies Total Supplies Utility Services 872-533500 Vehicle Fuel Total Utility Services Operations Support 872-534200 Printing & Binding Total Operations Support Staff Support 872-535100 Uniforms 872-535300 Memberships 872-535400 Publications 872-535500 TraininglTravel 872-535510 Meeting Expenses Total Staff Support Rental-ROW 872-571000 Furniture and Fixtures Total Rental-ROW 76 32,560 65,471 104 206 924 1,089 2,561 5,092 3,527 8,593 4,430 8,946 230 118 44,336 89,515 500 250 750 500 1,000 1,500 2,500 2,500 1,200 1,200 150 150 150 150 275 275 200 5,000 300 500 200 2,500 400 3,900 5,750 500 500 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 Operating EQuipment 872-571000 Furniture and Fixtures Total Operating Equipment 7,000 7,000 850 850 '..,' . ',,;-<-..,.- '. ,,,,,,--,,.,. ,',,0.,....",...--.....,-,..-.,.:,...'.......:.... . . " -'- ..,....-". .. :iQTAL.'LJ ...:....,..........,.."........-....;......:.'..,..-....,..'," 77 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 extending their useful life. Fleet Service reviews each repair order and examines the vehicles and equipment to determine if necessary repairs can be completed in house, before subcontracting any repair work to local auto repair facilities or dealerships. 78 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED INTERNAL SERVICE EXPENDITURES FLEET SERVICE Personnel Services 877 -511110 Regular 70,657 78,458 86,093 90,123 877-511120 Overtime 572 975 1,000 1,000 877-511180 L TO 177 210 266 286 877-511210 Longevity 1,872 2,136 2,520 3,328 877-511310 FICA - Employer 5,483 6,215 6,649 7,167 877 -511350 TMRS - Employer 6,072 7,250 9,155 12,205 877 -511410 Health - Employer 10,093 12,418 13,289 13,419 877-511500 Workers Compensation 2,649 1 ,4 77 1,845 1,519 Total Personnel Services 97,575 109,139 120,817 129,047 Supplies 877-521000 Operating Supplies 1,476 2,171 2,500 2,500 877-521100 Office Supplies 392 247 400 600 877-521200 Medical/Chemical Supplies 1,510 1,351 1,500 1,500 877-521300 Motor Veh. Supplies 68,705 81 ,455 70,000 75,000 877-521600 Equip Maint Supplies 594 220 1,100 1,100 Total Supplies 72,677 85,444 75,500 80,700 Utility Services 877-533500 Vehicle Fuel 3,082 4,162 2,000 4,000 Total Utility Services 3,082 4,162 2,000 4,000 Operations Support 877 -534200 Printing & Binding 315 375 300 375 Total Operations Support 315 375 300 375 Staff Support 877-535100 Uniforms 1 ,440 1,095 1,500 1,500 877 -535200 Annual Awards 100 100 877 -535500 TraininglTravel 562 144 1,750 1,500 Total Staff Support 2,002 1,239 3,350 3,100 79 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 101 GENERAL FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Maintenance Services 877-551100 Building Maintenance 877-551400 Minor & Other Equip Maint 877-551800 Other Maint Agreement Total Maintenance Services 3,527 15,676 19,203 2,788 28,507 31,295 500 4,000 75,000 79,500 750 4,000 50,000 54,750 Rental-ROW 877-561100 Rental Equipment 877-561200 Lease/Purchase Payments Total Rental-ROW 156 200 84 284 200 84 284 156 Operatim:a EQuipment 877-571500 Operating Equipment Total Operating Equipment 1,500 1,500 Capital Outlay 877-581700 Improvements over $5,000 Total Capital Outlay 28,050 28,050 80 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. The City of Schertz provides assistance to the Senior Citizens Hot Meals program. This program provides hot meals for seniors twice a week at the Schertz Community Center. 81 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 101 GENERAL FUND ACTUAL ACTUAL BUDGET APPROVED MISCELLANEOUS EXPENDITURES CITY ASSISTANCE City Assistance 901-537300 Patient Assistance 5,000 5,000 5,000 5,000 901-537500 Children's Advocacy Asst. 5,000 5,000 5,000 5,000 901-537700 Senior Citizen Hot Meals 7,500 7,500 Total City Assistance 10,000 10,000 17,500 17,500 82 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. 83 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 505 TAX I & S ACTUAL ACTUAL BUDGET APPROVED FINANCIAL SUMMARY Revenue Summary Taxes 1,139,039 1,395,729 2,413,894 2,691,550 Fund Transfers 985,167 619,886 277,500 295,950 Miscellaneous 12,310 27,047 37,000 49,200 Expenditure Summary 3,500 3,033,200 Professional Service Debt Service 3,000 3,134 5,000 1,732,834 1,407,644 2,526,043 84 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 505 TAXI & S ACTUAL ACTUAL BUDGET APPROVED REVENUES Taxes 000-411900 Property Tax Revenue 1,134,297 1,388,926 2,413,894 2,691,550 000-411950 Public Improvement Dist-922 4,742 6,803 Total Taxes 1,139,039 1,395,729 2,413,894 2,691,550 Fund Transfers 000-486000 Transfer From Other Funds 913,167 547,886 205,500 295,950 000-486203 Transfer (EMS Loan Repay) 72,000 72,000 72,000 Total Fund Transfers 985,167 619,886 277,500 295,950 Miscellaneous 000-491000 Interest Earned 1,663 2,549 4,000 4,200 000-492000 Investment Income 10,647 24,498 33,000 45,000 Total Miscellaneous 12,310 27,047 37,000 49,200 . TOTALREVENUJ3S. 85 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 505 TAX I & S ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES Professional Services 101-541500 Paying Agent 3,000 3,134 5,000 3,500 Total Professional Services 3,000 3,134 5,000 3,500 Debt Service 101-551610 Debt Service 1,732,834 1 ,407,644 2,526,043 3,033,200 Total Debt Service 1,732,834 1,407,644 2,526,043 3,033,200 86 Water & Sewer Revenues Sale of Water Garbage Collection Sewer Charges Other Fees & Charges . Misc Income TOTAL $ 5,602,075 $ 2,700,000 $ 2,600,890 $ 717,260 $ 418,120 $ 12,038,345 87 Water & Sewer Fund - Revenue Sewer Charges 22% Other Fees & Charges 6% Misc Income 30/0 Sale of Water 470/0 Gargage Collection 220k 88 Water & Sewer Expenditures TOTAL $ 1,367,462 $ 188,850 $ 130,460 $ 6,423,801 $ 641,755 $ 783,949 $ 2,472,981 $ 12,009,258 Personnel Supplies Prof & City Svc Utility & Maint Srvc Opr Support & Asst Capital Expense Debt Service 89 Water & Sewer Expenditures Debt Service 210/0 Capital Expense 7% Opr Support & Asst 50/0 Utility & Maint. Svc 53% 90 Prof & City Svc 10/0 T'J'J'S"'p ',(~ ',.1-1,') i\.J ]'l()J\1 'r 13 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 CITY 2003-2004 2004-2005 2005-2006 COUNCIL ACTUAL ACTUAL BUDGET APPROVED 202-WATER & SEWER Revenue Summary Fees Fund Transfers Miscellaneous 7,637,731 641 ,168 67,095 9,232,480 42,880 143,058 10,029,860 169,800 275,550 , tOTAl.., R Expenditure Summary GENERAL GOVERNMENT BUSINESS OFFICE TOTAL GENERAL GOVERNMENT 295,254 295,254 PUBLIC WORKS W & S ADMINISTRATION TOTAL PUBLIC WORKS 7,481,755 7,481,755 377.271 377,271 6,598.411 6,598,411 369,615 369,615 10,063,437 10,063,437 11,620,225 96,320 321,800 609,382 609,382 11,399.876 11,399,876 TOTAL B~ 91 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 CITY 2004-2005 2005-2006 2006-2007 COUNCIL 202-WA TER & SEWER ACTUAL ACTUAL BUDGET APPROVED Fees 000-455200 Garbage Collection Fee 1,844,359 2,301,322 2,290,000 2,700,000 000-455600 Fire Line Fees 8,815 10,155 11,000 15,000 000-455700 Recycle Fee Revenue 123,197 128,931 134,000 140,000 000-455800 W&S Line Constructn Reimb 57,235 48,232 59,000 50,000 000-457100 Sale of Water 3,968,807 4,231,965 4,665,000 5,602,075 000-457110 Edwards Water Lease 13,845 233,915 179,000 138,500 000-457120 Transfer Charge-Selma 39,000 40,000 000-457130 Transfer Charge-UC 39,000 40,000 000-457200 Sale of Meters 63,716 30,915 121,260 121,260 000-457400 Sewer Charges 1,430,796 2,083,918 2,360,000 2,600,890 000-457500 Water Penalties 124,661 162,529 130,000 170,500 000-459100 Credit Card Fee 620 (1,162) 600 000-459200 NSF Check Fee-Water&Swr 1,680 1,760 2,000 2,000 Fund Transfers 000-486101 Transfer from Equip Reserves 132,000 56,000 000-486204 Interfnd Chrg-Drainage Billing 42,880 37,800 40,320 000-486411 Transfer in-Capital Recovery Miscellaneous 000-490000 Misc Charges 000-491000 Interest Earned 000-491200 Investment Income 000-496000 Water Construction Reserve 000-497000 Miscellaneous Income W&S 000-498100 Loan Repayment-EMS 000-498200 W&S Project Reimbursement 000-499000 Transfer from Reserves 921 8,580 45,369 909 15,152 110,519 6,241 4,971 900 6,600 100,050 65,000 12,000 32,250 5,000 100,000 5,984 11,507 92 CITY OF SCHERTZ COMMENT ARY DEPARTMENT: BUSINESS OFFICE FUNCTION: This department is responsible for maintaining all Water/Wastewater Utility Customer and Solid Waste Management 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. The department also bills garbage pickup for residental, commercial and construction. 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 and is responsible for debt collect for various departments. 93 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 CITY 2004-2005 2005-2006 2006-2007 COUNCIL 202-WA TER & SEWER ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT BUSINESS OFFICE Personnel Services 176-511110 Regular 155,439 214,794 189,365 304,912 176-511120 Overtime 292 151 1,000 1,000 176-511180 LTD 389 551 618 988 176-511210 Longevity 7,920 11 ,856 11,988 13,857 176-511310 FICA - Employer 12,014 16,824 15,403 24,386 176-511350 TMRS-Employer 13,382 20,240 21 ,207 41,631 176-511410 Health-Employer 22,521 34,427 26,577 49,164 176-511500 Workers Compensation 430 2,133 487 2,252 Total Personnel Services 212,387 300,976 266,645 438,190 Supplies 176-521000 Operating Supplies 903 737 1,000 1,500 176-521100 Office Supplies 1,598 2,428 3,500 3,500 176-521200 Medical/Chem Supplies 432 800 800 Total Supplies 2,501 3,597 5,300 5,800 City Support Services 176-532500 City Insurance-Commercial 1,680 Total City Support Services 1,680 Operations Support 176-534000 Postage 46,313 41 ,451 46,500 50,000 176-534200 Printing & Binding 31,297 29,599 45,000 45,000 Total Operations Support 77,610 71,050 91,500 95,000 Staff Support 176-535100 Uniforms 20 490 500 176-535500 TraininglTravel 2,157 832 3,000 4,000 176-535510 Meeting Expense 250 Total Staff Support 2,157 852 3,490 4,750 Operating EQuipment 176-571000 Furniture & Fixtures 599 796 1,000 6,000 176-571400 Communication Equipment 3,642 Total Operating Equipment 599 796 1,000 9,642 94 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 202-WA TER & SEWER CITY 2004-2005 2005-2006 2006-2007 COUNCIL ACTUAL ACTUAL BUDGET APPROVED Capital EQuipment 176-581200 Vehicles over $5,000 Total Capital Equipment 56,000 56,000 95 CITY OF SCHERTZ COMMENTARY DEPARTMENT: WATERlWASTEWATER 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. The department oversees maintenance and updating of Geographical Information System, utility and street maps. Produces and maintains reports to document activities as required by the State Health Department, Texas Commission on Environmental Quality and the City of Schertz. 96 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 202-WA TER & SEWER ACTUAL ACTUAL BUDGET APPROVED PUBLIC WORKS W & S ADMINISTRATION Personnel Services 575-511110 Regular 547,835 563,324 707,964 647,977 575-511120 Overtime 8,778 18,169 10,000 10,000 575-511180 LTD 1,392 1,534 2,231 2,082 575-511210 Longevity 16,848 17,988 19,392 21 ,403 575-511230 Certification Allowance 2,248 2,682 3,600 4,801 575-511310 FICA - Employer 42,211 44,683 55,851 51,575 575-511350 TMRS - Employer 47,094 53,684 76,896 88,048 575-511410 Health - Employer 67,398 70,750 97,450 93,411 575-511500 Workers Compensation 18,876 14,676 14,563 9,975 Total Personnel Services 752,680 787,490 987,947 929,272 Supplies 575-521000 Operating Supplies 7,754 5,818 9,500 9,500 575-521100 Office Supplies 3,005 3,608 6,000 5,000 575-521200 Medical Supplies 4,374 1,279 5,000 5,000 575-521400 Plumbing Supplies 128,978 123,130 65,000 75,000 575-521405 Water Meters-New 88,000 88,000 575-521600 Equip Maint Supplies 255 537 500 550 Total Supplies 144,366 134,372 174,000 183,050 City Support Services 575-532400 Computer Fees & Licenses 24,287 20,248 28,500 28,500 575-532410 Computer Consulting 32,624 7,000 7,000 575-532500 City Insurance-Commercial 13,965 11,196 20,000 20,000 575-532700 Records Management Service 2,000 20,000 575-532900 Contingencies 11,315 40,100 70,000 70,000 Total City Support Services 49,567 104,168 127,500 145,500 Utility Services 575-533100 Gas Utility 300 1,500 1,500 575-533200 Electricity 112,939 150,266 113,000 120,000 575-533300 Telephone 6,763 9,448 10,000 10,000 575-533400 Water Purchase 1 ,104,625 1 ,094,692 1 ,448,698 1,979,722 575-533410 Water Utility Service 941 983 1,700 1,700 575-533500 Vehicle Fuel 30,671 38,602 30,000 35,000 Total Utility Services 1 ,255,939 1,294,291 1 ,604,898 2,147,922 97 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 202-WA TER & SEWER 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Operations Support 575-534100 Advertising 1,357 1,740 1,740 575-534200 Printing & Binding 2,175 2,625 3,500 4,000 575-534300 Copy Services 2,674 3,420 3,000 Total Operations Support 2,175 6,656 8,660 8,740 Staff Support 575-535000 Rental-Building & Land 2,010 575-535100 Uniforms 7,307 7,049 15,000 15,000 575-535200 Annual Awards 516 56 600 600 575-535300 Memberships 2,934 3,133 4,000 4,000 575-535400 Publications 300 224 400 400 575-535500 TraininglTravel 5,802 8,958 11,000 9,000 575-535600 Prof. Certifications 300 300 Total Staff Support 16,859 19,420 31 ,300 31,310 City Assistance 575-537100 Medical Services 691 886 3,000 3,000 Total City Assistan~e 691 886 3,000 3,000 Professional Services 575-541100 Engineering Services 39,589 30,133 575-541200 Legal Services 21,912 7,996 20,000 20,000 575-541300 Other Consul/Prof Service 19,118 20,561 25,000 25,000 575-541310 Contractual Services 25,000 575-541400 Auditor/Accounting Service 13,000 13,000 15,000 20,000 575-541500 Paying Agent 1 ,400 1 ,400 1 ,400 Total Professional Services 93,619 73,090 61 ,400 91 ,400 Fund Charaes 575-548600 Inter Fund Charges-Admin 371,625 288,422 395,391 392,515 Total Fund Charges 371,625 288,422 395,391 392,515 98 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 202-WA TER & SEWER 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Maintenance Services 575-551100 Building Maintenance 573 2,139 4,250 4,250 575-551300 Computer Maintenance 8,358 4,241 12,000 12,000 575-551400 Minor & Other Equip Maint 2,491 1,075 2,500 2,500 575-551500 Water & Sewer Maintenance 21,528 12,769 25,000 25,000 575-551510 Payable to Wast Contractor 1,709,892 1,993,375 2,218,880 2,291,169 575-551520 Sewer Treatment-CCMAlMUD 1,173,740 1,523,375 1,765,230 1,919,760 575-551600 Street Maintenance Materials 6,866 8,351 6,000 6,000 575-551720 Low Flow Rebate Program 2,550 1,650 3,000 3,000 575-551740 Rebate UB Customer 3,000 3,000 575-551800 Other Maintenance 2,605 2,481 4,500 4,500 Total Maintenance Services 2,928,603 3,549,456 4,044,360 4,271,179 Debt Service 575-555900 Debt Service 1,862,602 328,721 2,305,474 2,472,981 Total Debt Service 1,862,602 328,721 2,305,474 2,472,981 Rental-ROW 575-561000 Rental-Building & Land 1,891 1,947 2,000 2,000 575-561100 Rental - Equipment 987 3,740 2,500 2,500 575-561200 Lease/Purchase Payments 151 1,910 200 200 Total Rental-ROW 3,029 7,597 4,700 4,700 OperatinQ EQuipment 575-571500 Minor Equipment 3,842 3,307 3,307 Total Operating Equipment 3,842 3,307 3,307 Capitalized EQuipment 575-581600 Large Equipment 11,500 575-581700 Other Improvements 300,000 300,000 575-588000 Repair in place 220' 15,000 575-589000 Aviation Heights Water Line 400,000 Total Capitalized Equipment 311,500 715,000 99 ! 1') l1 1. . Schertz EMS - Revenues Inter-Jurisdictional Contracts TOTAL $ 4,324,067 $ 84,800 $ 1,150,924 $ 5,559,791 ADlbulance/Mileage Fees Misc. Revenue 100 Schertz EMS - Revenue Inter-Jurisdictional Contracts 21% Misc. Rev 20/0 101 Schertz EMS - Expenditures Personnel $ 1,858,723 Supplies $ 217,983 Prof & City Svc $ 200,627 Utility & Maint. Svc $ 147,060 Opr Support & Asst $ 2,686,130 Capital Expense $ 125,375 Debt Service $ 173,893 TOTAL $ 5,409,791 102 Schertz EMS - Expenditures Debt Service 3% Personnel 340/0 Supplies 40/0 Prof & City Services 40/0 Utility & Maint. Svc 30/0 Capital Expense 20/0 Opr Support & Asst 500/0 103 T ,", T) A.r, i::' t/1\ tJ "1-' I ( " 1'-.J _)1 " CITY OF SCHERTZ COMMENT ARY 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, eight surrounding cities, and parts of three unincorporated counties. With 45 full-time, part-time,and volunteer Paramedics and EMT's we respond to over 6,700 requests for service annually with 4 full- time paramedic ambulances in our response district. We are the primary transport agency for not only Schertz, but also UniversalCity, 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 105,000 people currently reside. We strive to provide high quality patient focused pre- hospital health care at a reasonable price and to work through prevention and education to lessen the need for EMS services throughout our response area. 104 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 203 - EMS 2004-2005 ACTUAL 2005-2006 ACTUAL 2006-2007 CITY COUNCIL BUDGET APPROVED SUMMARY RECAP Revenue Summary Fees Inter-Jurisdictional Miscellaneous 2,790,384 652,594 105,325 Expenditure Summary Personnel Services Supplies City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Fund Charges Maintenance Service Debt Service Rental Lease Operating Equipment Capitalized Equipment it;;;~~.A; !'>:~:'1?10.?I_>~ ,';:;Y1?h:)b,,':,:/>:~.~~,~- 1,311,182 143,140 9,748 42,729 8,163 51,848 27,552 61,626 2,071,501 38,096 72,000 10,774 13,428 1,384,648 181 ,120 8,011 53,200 8,064 35,046 7,891 61,291 1,678,265 35,241 72,000 5,605 16,458 3,823,572 1,023,821 82,919 1,581,004 189,465 27,000 52,890 8,850 75,468 6,300 106,700 2,484,697 44,840 141 ,179 25,000 28,600 170,186 105 4,324,067 1,150,924 84,800 1,858,723 217,983 27,000 65,860 12,625 79,968 6,300 114,359 2,646,505 49,000 173,893 32,200 83,375 42,000 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 203 - EMS ACTUAL ACTUAL BUDGET APPROVED REVENUES Fees 000-456100 Ambulance/Mileage Transport 2,790,835 2,900,461 3,823,572 4,324,067 000-459100 Credit Card Fee (451 ) (592 ) Total Fees 2,790,384 2,899,869 3,823,572 4,324,067 Inter-Jurisdictional 000-473500 Seguin/Guad Co Support 193,657 216,990 215,394 240,841 000-473600 Comal Co Support 24,100 71,800 56,650 000-474300 Cibolo Support 39,200 80,000 103,000 138,991 000-475100 Garden Ridge Support 14,630 5,225 62,599 000-475200 Live Oak Support 64,092 101,000 113,300 116,710 000-475300 Universal City Support 105,000 165,690 175,100 180,370 000-475400 Selma Support 17,500 30,000 41 ,200 53,050 000-475500 Schertz Support 180,499 280,000 298,700 337,271 000-475600 Santa Clara Support 6,223 8,890 9,157 9,432 000-475800 Marion Support 7,693 10,990 11,320 11 ,660 Totallnter-Jurisdictional 652,594 970,585 1,023,821 1,150,924 Miscellaneous 000-491000 Interest Earned 1,291 4,919 000-493203 Donations- EMS 3,751 310 2,000 2,000 000-497000 Misc Income 68,709 126,560 20,000 20,000 000-497500 Misc Income-EMT Classes 32,865 35,394 56,000 62,800 Total Miscellaneous 105,325 163,555 82,919 84,800 106 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 203 - EMS ACTUAL ACTUAL BUDGET APPROVED PUBLIC SAFETY EXPENDITURES Personnel Services 280-511110 Regular 714,774 775,267 945,362 1,043,314 280-511120 Overtime 291,344 295,286 262,029 342,453 280-511180 L TD 2,236 2,449 3,180 4,116 280-511210 Longevity 8,784 10,164 12,912 12,091 280-511220 Clothing Allowance 5,298 5,520 5,304 8,424 280-511230 Certification Allowance 22,588 7,160 7,216 5,760 280-511310 FICA- Employer 76,388 81 ,267 91,071 108,021 280-511350 TMRS - Employer 75,558 86,370 116,401 172,070 280-511410 Health - Employer 73,446 88,081 106,320 134,190 280-511500 Workers Compensation 40,766 33,084 31,209 28,284 Total Personnel Services 1,311,182 1,384,648 1,581,004 1,858,723 Supplies 280-521000 Operating Supplies 8,119 4,996 7,000 7,700 280-521010 Operating Supplies-EMT Class 9,487 29,783 14,465 16,983 280-521100 Office Supplies 4,520 1,533 4,000 4,000 280-521200 Medical Supplies 121,014 143,259 160,000 184,000 280-521300 Motor Veh. Supplies 381 1,500 1,800 280-521600 Equip Maint Supplies 1,168 2,500 3,500 Total Supplies 143,140 181 ,120 189,465 217,983 City Support Services 280-532500 City-Insurance-Commercial 9,748 8,011 27,000 27,000 Total City Support Services 9,748 8,011 27,000 27,000 Utilitv Services 280-533200 Electricity 3,936 1,574 3,900 3,900 280-533300 Telephone 9,879 13,757 15,990 25,760 280-533410 Water Utility Service 112 1,200 280-533500 Vehicle Fuel 28,802 37,869 33,000 35,000 Total Utility Services 42,729 53,200 52,890 65,860 107 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 203 - EMS ACTUAL ACTUAL BUDGET APPROVED Operations SUPDort 280-534000 Postage 5,308 3,030 4,250 4,300 280-534100 Advertising 972 1,775 2,400 4,200 280-534200 Printing & Binding 1,883 2,667 2,200 3,000 280-534700 Credit Card Charges 592 1,125 Total Operations Support 8,163 8,064 8,850 12,625 Staff SUPDort 280-535100 Uniforms 12,549 9,400 22,000 22,000 280-535200 Annual Awards 53 1,200 1,200 280-535210 Employee Recognition/Morale 4,244 5,000 5,000 280-535300 Memberships 1,172 1,940 2,500 3,250 280-535400 Publications 422 1,202 1,500 1,600 280-535500 TraininglTravel 16,936 10,461 27,268 29,118 280-535510 Meeting Expense 1,800 280-535600 Prof. Certs 20,716 7,799 16,000 16,000 Total Staff Support 51,848 35,046 75,468 79,968 City Assistance 280-537100 Medical Services 18,093 4,895 3,000 3,000 280-537800 Crime/Fire Prevention 9,459 2,996 3,300 3,300 Total City Assistance 27,552 7,891 6,300 6,300 Professional Services 280-541200 Legal Services 474 1,747 2,000 2,200 280-541300 Other Consult/Prof Service 50,102 47,194 82,000 82,000 280-541400 Auditor/Accounting Serv 2,000 2,000 2,000 2,000 280-541500 EMT Class Instructors 9,050 10,350 20,700 28,159 Total Professional Services 61,626 61,291 106,700 114,359 Fund Charges 280-548500 Contractual Allowables 1,147,071 1,297,220 280-548600 Inter-Fund Charge - Admin 25,000 50,000 58,700 66,755 280-548700 Bad Debt Expense 1,902,988 1,541,515 1,278,926 1,282,530 280-548800 Depreciation Expense 143,513 86,750 Total Fund Charges 2,071,501 1,678,265 2,484,697 2,646,505 Maintenance Services 280-551100 Building Maintenance 7,000 4,762 7,500 7,500 280-551200 Motor Vehicle Fleet 24,311 19,839 20,340 24,500 280-551800 Other Maintenance Agreement 6,785 10,640 17,000 17,000 Total Maintenance Services 38,096 35,241 44,840 49,000 108 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 203 - EMS 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED Debt Service 280-555202 Loan from Water 32,250 280-555505 Payment to I & S-SR 2003 72,000 72,000 72,000 280-555600 Principal-CO Bond 2007 36,929 33,893 280-555600 Interest-CO Bond 2007 140,000 Total Debt Service 72,000 72,000 141,179 173,893 Rental-ROW 280-561200 Lease/Purchase Payments 10,774 5,605 25,000 32,200 Total Rental-ROW 10,774 5,605 25,000 32,200 Operatina EauiDment 280-571000 Furniture & Fixtures 490 406 3,600 4,000 280-571300 Computer & Peripherals 10,063 7,448 20,000 66,575 280-571400 Communications Equipment 2,875 8,604 5,000 12,800 Total Operating Equipment 13,428 16,458 28,600 83,375 CaDitalized EQuipment 280-581200 Vehicles 170,186 42,000 Total Capitalized Equipment 170,186 42,000 109 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 makes sure that all Flood Management measures are followed to ensure the safety of the Citizens of Schertz. 110 Drainage - Revenue TOTAL $ 360,359 $ 8,031 $ 368,390 Drainage Fees Misc Income 111 Drainage Fees 980/0 Drainage - Revenue Misc Income 20/0 112 Drainage - Expenditures Personnel $ 249,028 Supplies $ 4,225 Prof & City Svc $ 8,450 Utility & Maint. Svc $ 22,500 Opr Support & Asst $ 66,072 Capital Expense $ - Debt Service $ 18,115 TOTAL $ 368,390 113 Drainage - Expenditures Utility & Maint. Svc 60/0 Opr Support & Asst 180/0 Prof & City Services 20/0 Debt Service 5% Supplies 10/0 Personnel 680,'0 114 ,', 'p . c...' ~ ....A J I'.. f) 1\ [ , L'l V t C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 204-DRAINAGE FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Fees Miscellaneous .. TorA'" R~VeNUt:S . ,. ..,.'.........,.... " '.,....... c- ';'..,_;-_..'.............,' 303,055 2,481 305',536 323,579 4,793 3.....283....72 ; '~',._'" ,"c_.....J. .. . . . 348,704 3,000 351,704 360,359 8,031 ~68,$~O Expenditure Summary Personnel Services Supplies Utility Services Operations Support Staff Support City Assistance Professional Services Fund ChargeslTransfers Maintenance Services Debt Service Rental-ROW i{;)~I~JNII 162,233 191,040 258,409 249,028 1,778 2,481 4,225 4,225 5,451 9,207 6,000 6,000 820 775 3,005 3,085 5,475 5,650 800 800 27,766 50,696 2,000 2,000 62,664 66,065 58,603 65,297 1,376 2,837 16,000 16,000 18,115 288 500 500 ~P$;~$O' 115 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 204-DRAINAGE FUND 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED REVENUES Fees 000-457500 Water Penalties 000-457600 Drainage Fees 3,500 356,859 Miscellaneous 000-491000 Interest Earned 000-491200 Investment Income 000-497000 Misc Income-Drainage 2,406 2,327 60 1,000 2,000 2,200 4,500 1,331 116 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 204-DRAINAGE FUND ACTUAL ACTUAL BUDGET APPROVED General Government Expenditures Personnel Services 579-511110 Regular 118,523 140,732 183,470 174,893 579-511120 Overtime 1,124 136 2,000 1,500 579-511180 L TD 294 362 582 555 579-511210 Longevity 3,864 4,392 5,352 6,433 579-511310 FICA - Employer 8,544 10,635 14,444 13,680 579-511350 TMRS - Employer 9,928 12,369 19,888 23,355 579-511410 Health - Employer 14,332 18,657 27,114 24,582 579-511500 Workers Compensation 5,624 3,757 5,559 4,030 Total Personnel Services 162,233 191,040 258,409 249,028 Supplies 579-521000 Operating Supplies 509 371 1,000 1,000 579-521100 Office Supplies 147 99 125 125 579-521200 Medical/Chem Supplies 1,122 1,800 2,500 2,500 579-521300 Motor Veh. Supplies 211 300 300 579-521600 Equipment Maint. Supplies 300 300 Total Supplies 1,778 2,481 4,225 4,225 Utility Services 579-533300 Telephone 69 1 ,459 1,000 1,000 579-533500 Vehicle Fuel 5,451 7,748 5,000 5,000 Total Utility Services 5,451 9;207 6,000 6,000 Operations Support 579-53430C Copy Services 820 775 Total Operations Support 820 775 Staff Support 579-535100 Uniforms 1,875 1,964 3,100 3,100 579-535300 Memberships 109 175 100 100 579-535500 TraininglTravel 1,021 946 2,025 2,200 579-535600 Professional Certification 250 250 Total Staff Support 3,005 3,085 5,475 5,650 117 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 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 26,120 48,949 579-541200 Legal Service 646 747 1,000 1,000 579-541400 Auditor/Accounting Service 1,000 1,000 1,000 1,000 Total Professional Services 27,766 50,696 2,000 2,000 Fund CharaeslTransfers 579-548500 Inter-Fund Charge-I&S/GF 21,901 15,159 16,221 19,375 579-548600 Inter-Fund Charge - Water 36,720 42,880 38,340 41 ,872 579-548700 Bad Debt Expense 801 800 800 579-548800 Depreciation Expense 3,242 8,026 3,242 3,250 Total Fund ChargeslTransfers 62,664 66,065 58,603 65,297 Maintenance Services 579-551300 Computer Maintenance 1,148 2,000 2,000 579-551610 Drainage Channel Maintenance 228 2,837 14,000 14,000 Total Maintenance Services 1,376 2,837 16,000 16,000 Debt Service 579-555900 Debt Service 18,115 Total Debt Service 18,115 Rental-ROW 579-561100 Rental Equipment 288 500 500 Total Rental-ROW 288 500 500 118 CITY OF SCHERTZ COMMENT ARY 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. 119 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 411-CAPIT AL RECOVERY ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Fees 1,425,626 1,574,735 2,589,945 2,093,400 Fund Transfers 4,247,880 Miscellaneous 132,753 253,158 339,000 460,000 Expenditure Summary Operations Support Professional Services Fund Transfers Debt Service Projects 1,000 2,000 1,000 27,000 721,571 486,640 6,286,640 342,622 120 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 411-CAPITAL RECOVERY ACTUAL ACTUAL BUDGET APPROVED REVENUES Fees 000-455900 Capital Recovery-Water 755,798 1,039,138 2,225,742 1,479,600 000-455910 Capital Recovery-Waste Water 669,828 535,597 364,203 613,800 Total Fees 1,425,626 1,574,735 2,589,945 2,093,400 Fund Transfers 000-481000 Transfer from Reserves 4,247,880 Total Fund Transfers 4,247,880 Miscellaneous 000-491000 Interest Earned 1 0,498 7,440 9,000 10,000 000-491200 Investment Income 72,255 195,718 280,000 400,000 000-498100 Reimbursement-FM 78 Project 50,000 50,000 50,000 50,000 Total Miscellaneous 132,753 253,158 339,000 460,000 121 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 411-CAPIT AL RECOVERY ACTUAL ACTUAL BUDGET APPROVED General Government EXPENDITURES Operations Support 101-534100 Advertising 1,000 1,000 Total Operations Support 1,000 1,000 Professional Services 101-541100 Engineering Services 25,000 101-541400 Auditor Services 2,000 2,000 Total Professional Services 2,000 27,000 Fund CharQes/Transfers 101-548600 Interfund Transfer 721,571 Total Fund ChargeslTransfers 721,571 Debt Service 101-555900 Debt Service 342,622 486,640 Total Debt Service 342,622 486,640 Capital Expenditures 909-551900 1 Million Ground Storage-NE 911-551900 Towncreek Sewer 919-515900 7.5 Million Ground Storage-Live 920-515900 Loop Feed Line to NE Booster Total Capital Expenditures 2,100,000 486,640 3,100,000 600,000 6,286,640 122 CITY OF SCHERTZ COMMENTARY Schertz Economic Development Corporation FUNCTION: State law allows local municipalities to impose up to 1/2 cent additional sales tax for economic development activities. In 1997, Schertz citizens voted to increase the sales tax and the Schertz City Council formed the Schertz Economic Development Corporation, a 7 -member citizen board, to administer the fund and all its activities. In 2006, the corporation developed a Comprehensive Economic Development Plan and established the following vision statement: Schertz strives to develop as a premier Texas community that promotes a family atmosphere, is sustained by foresight and innovation, and continues a long-standing commitment to economic prosperity and workforce opportunities. 123 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 620-SED CORPORATION 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Taxes Miscellaneous 1,113,193 18,679 1131872 " ".:........",;...,.::,,",...:.<,...;::..,..; 1 ,534,815 50,809 1;g~~,()~4 1,650,821 53,000 t,703i8~1 2,050,000 54,100 .~.,tQ4inQP Expenditure Summary General Government Non-Departmental Economic Development 134,420 1,158,741 278,611 1,593,758 124 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 620-SED CORPORATION 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED REVENUES Taxes 000-411500 Sales Tax Revenues (4B) Total Taxes 1,113,193 1,113,193 1,534,815 1,534,815 1,650,821 1,650,821 2,050,000 2,050,000 Miscellaneous 000-491000 Interest Earned 000-491200 Investment Earnings Total Miscellaneous 2,425 16,254 18,679 4,612 46,197 50,809 3,000 50,000 53,000 4,100 50,000 54,100 T()TAL'~ew~lIes,', . 1,585,624 . 1~703;811 '.2104100 ':._.' 0' - 125 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 620-SED CORPORATION ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 101-521000 Operating Supplies 6,585 8,000 13,698 14,246 101-521200 Medical/Chemical Supplies 1,645 1,972 3,760 3,910 Total Supplies 8,230 9,972 17,458 18,156 Utilities 101-533200 Gas Utility Service 4,159 5,127 8,000 8,000 101-533300 Electricity Utility Service 50,426 58,145 54,250 54,250 101-533410 Water Utility Service 6,279 10,252 13,486 13,486 101-533500 Fuel Supply (Diesel) 1,892 1,304 3,194 1,800 Total Utilities 62,756 74,828 78,930 77,536 Maintenance Services 101-551100 Building Maintenance 10,242 12,900 23,848 28,145 101-551400 Minor & other Equip Maint 357 1,798 3,084 3,084 101-551700 Ground Maintenance 2,150 2,300 1,000 101-551800 Other Maint Agreement 4,599 3,621 8,800 30,800 Total Maintenance Services 15,198 20,469 38,032 63,029 Operatina Eauipment 101-581100 ED Project Support 30,165 119,890 Total Operating Equipment 30,165 119,890 126 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 620-SED CORPORATION ACTUAL ACTUAL BUDGET APPROVED GENERAL GOVERNMENT EXPENDITURES Personnel Services 966-511110 Regular 91 ,304 114,173 152,039 147,551 966-511120 Overtime 1,793 2,011 2,100 966-511180 LTD 219 295 469 459 966-511210 Longevity 480 720 1,320 530 966-511310 FICA - Employer 6,768 8,787 11,607 11,328 966-511350 TMRS - Employer 7,440 10,252 15,982 19,339 966-511410 Health - Employer 6,536 9,337 13,557 13,419 966-511500 Workers Compensation 336 395 337 263 Total Personnel Services 114,876 145,970 197,411 192,889 Supplies 966-521000 Operating Supplies 157 167 180 180 966-521100 Office Supplies 1,134 758 1,200 1,200 Total Supplies 1,291 925 1,380 1,380 City Support Services 966-532800 Special Events 924 1,192 18,500 12,500 Total City Support Services 924 1,192 18,500 12,500 Utilitv Services 966-533300 Telephone 152 2,149 3,790 4,700 966-533500 Vehicle Fuel 6,062 7,000 966-533550 Vehicle Maintenance 500 500 Total Utility Services 152 2,149 10,352 12,200 Operations Support 966-534000 Postage 139 1,250 500 966-534200 Printing & Binding 491 195 5,000 5,300 Total Operations Support 491 334 6,250 5,800 Staff Support 966-535100 Uniforms 12 95 1,180 325 966-535300 Memberships 1,924 3,105 3,400 3,100 966-535400 Publications 85 800 500 966-535500 TraininglTravel 9,743 16,009 22,534 15,900 966-535510 Meeting Expense 5,500 Total Staff Support 11,679 19,294 27,914 25,325 127 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 620-SED CORPORATION 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED City Assistance 966-537600 Business Development prog 185,000 Total City Assistance 185,000 Professional Services 966-541100 Engineering 7,262 1,580 7,000 7,000 966-541200 Legal Services 11,633 35,000 35,000 966-541300 Professional Services 25,070 67,837 45,000 60,000 966-541400 Auditor/Acct. Services 800 1,000 2,000 2,000 966-541500 Paying Agent 1,769 1,384 1,775 1,775 Total Professional Services 34,901 83,434 90,775 105,775 Fund ChargeslTransfers 966-548000 Transfer Out 125,000 966-548600 Interfund Charges-Admin 102,000 48,000 44,000 47,227 Total ChargeslTransfers 102,000 48,000 44,000 172,227 Debt Service 966-555400 Contribution-Community Pro 200,000 966-555600 GO Bond SR98-Pub Safety 381,486 378,098 542,828 966-555700 Tax Note SR01-Fire Engine 166,400 128,092 966-558000 New Fire Engine 111 ,834 111,834 Total Debt Service 547,886 618,024 854,662 Operatina EQuipment 966-571100 Furniture and Fixtures 120 20,000 966-571300 Computer & Peripherals 6,547 1,000 1,000 966-571800 Field Equipment 4,000 5,000 Total Operating Equipment 6,667 5,000 26,000 Capital Outlay 966-581200 Vehicles 28,471 139,135 Total Capital Outlay 28,471 139,135 128 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. Events such as Festival of Angels, 4th of July Jubilee, and Service awards dinner. 129 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 106 - SPECIAL EVENTS 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED REVENUES Miscellaneous 000-493000 Donations-July 4th 000-493200 Donations-Emergency Svc Day 000-493300 Donations-Business Apprec Dinner 000-453400 Donations-Christmas Activities 000-493450 Donations-Holiday Lock-up 000-493500 Community Svc Award Dinner Total Miscellaneous Fund Transfers 000-485000 Interfund Transfer In Total Fund Transfers 125 42,324 1,325 710 5,749 50,233 35,189 35,189 25 775 4,722 735 6,257 42,000 42,000 500 2,000 1,500 4,000 132,878 132,878 58,250 58,250 130 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2004-2005 2005-2006 2006-2007 CITY COUNCIL 106 - SPECIAL EVENTS ACTUAL ACTUAL BUDGET APPROVED Expenditures Miscellaneous 601-532800 Festival of Angels 12,825 11 ,289 12,000 602-532800 Employee Christmas Party 3,851 2,792 5,000 5,000 604-532800 4th of July Jubilee 6,778 10,005 8,000 607 -532800 National Night Out 50 50 608-532800 Relay for Life 200 200 610-532800 Community Svc Award Dinner 531 1,600 611-532800 Employee Remembrance Day 150 612-532800 50th Anniversary Celebration 50,000 615-532800 Blue Santa 2,800 2,336 3,000 3,000 Total Miscellaneous 26,254 26,953 30,000 58,250 131 crIll S i.) I 11 L. .~ ..~.-'I.N. f t~ .,; f i 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. Currently there are two hotels in Schertz, the Atrium Inn and the Hampton Inn representing 157 rooms. 132 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2003-2004 2004-2005 2005-2006 CITY COUNCIL 314-HOTEL TAX ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Taxes 42,982 202,107 150,000 200,000 Fund Transfers 22,986 Miscellaneous 5,437 11 ,263 8,900 19,800 Expenditure Summary Operations Support Professional Services Fund Charges Capital Outlay 6,289 13,500 127,325 4,040 1,000 21,500 24,120 70,000 60,826 91,245 123,500 133 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 2003-2004 2004-2005 2005-2006 CITY COUNCIL 314-HOTEL TAX ACTUAL ACTUAL BUDGET APPROVED General Government REVENUES Taxes 000-411800 Hotel Occupancy Tax 42,982 202,107 150,000 200,000 Total Taxes 42,982 202,107 150,000 200,000 Fund Transfers 000-481000 Transfer From Reserves 22,986 Total Fund Transfers 22,986 Miscellaneous 000-491000 Interest Earned 363 1,369 900 2,500 000-491200 Investment Income 5,074 9,894 8,000 17,300 Total Miscellaneous 5,437 11 ,263 8,900 19,800 134 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 314-HOTEL TAX 2003-2004 2004-2005 2005-2006 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED General Government EXPENDITURES Operations Support 101-534100 Advertising 6,289 Total Operations Support 6,289 Professional Services 101-541300 Other Consult/Prof Services 12,500 23,120 89,745 101-541400 Auditor/Accounting Services 1,000 1,000 1,000 1,500 Total Professional Services 13,500 1,000 24,120 91,245 Fund Charges 1 01-548600 Interfund Transfers 127,325 21,500 70,000 123,500 Total Fund Charges 127,325 21,500 70,000 123,500 Capital Outlay 101-581201 Motor Vehicle Refurbish 10,700 101-581700 Other Improvements 4,040 50,126 Total Capital Outlay 4,040 60,826 135 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. 136 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 317-PARK 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED General Government SUMMARY RECAP Revenue Summary 100,000 1 TOfAl; Expenditure Summary Other Professional Services Maintenance Services Operating Equipment Capital Outlay i'l"\~I~l:'~ . 1,153 7,100 9,920 23,424 13,986 30,000 50,000 1 00,000 64,754 21,000 1 137 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 317-PARK 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED General Government REVENUES Fees 000-458800 Developers Fees 000-458900 Tree Mitigation Total Fees 72,225 70,000 142,225 59,400 26,744 86,144 72,225 70,000 142,225 70,000 30,000 100,000 Miscellaneous 000-491000 Interest Earned 000-491200 Investment Interest 000-499100 Transfer In Total Miscellaneous 1,500 15,500 38,325 55,325 1,676 21,224 10,000 32,900 1,500 15,500 25,000 42,000 2,000 15,000 103,000 120,000 138 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 317-PARK 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED General Government EXPENDITURES Professional Services 101-541300 Other Prof Services 7,100 30,000 Total Professional Services 7,100 30,000 Maintenance Services 1 01-55111 0 Trees 1,153 9,878 50,000 100,000 101-551710 Landscaping 42 Total Maintenance Services 1,153 9,920 50,000 100,000 Operatina EQuipment 101-571000 Signs/Fixtures 16,695 101-571700 Minor Improvements 6,729 Total Operating Equipment 23,424 CapitalOutlav 101-581700 Other Improvements 64,754 13,986 21 ,000 120,000 Total Capital Outlay 64,754 13,986 21,000 120,000 139 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 City wide Fall and Spring clean up. 140 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 3i8-RECYCLlNG 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED SUMMARY RECAP Revenue Summary Fees 22,996 Expenditure Summary Maintenance Services 19,761 10,991 141 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 3i8-RECYCLlNG 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED REVENUES Fees 000-458200 Sale of Recycle Materials Total Fees 22,996 22,996 13,715 13,715 15,000 15,000 18,000 18,000 142 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 3i8-RECYCLlNG 2004-2005 2005-2006 2006-2007 CITY COUNCIL ACTUAL ACTUAL BUDGET APPROVED EXPENDITURES Maintenance Services 101-551510 Payable to Waste Contractor Total Maintenance Services 19,761 19,761 10,991 10,991 15,000 15,000 18,000 18,000 143 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 SUMMARY OF WORKING CAPITAL PROJECTS YTO COSTS STATUS SR 2004 COMMUNITY PROJECT BOND $ 621,839 COMPLETE LAND PURCHASE DRAINAGE PROJECTS 945-551900 AVIATION HEIGHTS $ 365,572 COMPLETE 946-551900 BORGFELD RD 1,167,897 COMPLETE 947-551900 ELBEL IMPROVEMENTS 5,956 COMPLETE 948-551900 UPPER WEST DIETZ CREEK 1,093,405 COMPLETE 949-551900 WOODLAND OAKS 3,280 COMPLETE TOTAL Drainage Projects $ 2,636,110 BUILDING RENOVATIONS 951-551900 COUNCIL CHAMBERS $ 857,522 COMPLETE 952-551900 CIVIC CENTER 2,998,272 COMPLETE 953-551900 CITY HALL REMODEL-INSPECTIONS 21,600 COMPLETE 954-551900 FACILITIES MAINTENANCE BLDG 430,832 COMPLETE 955-551900 COMMUNITY CENTER RENOVATIONS 38,527 COMPLETE 956-551900 CITY HALL ANNEX 125,112 ON GOING TOTAL Building Projects $ 4,471,865 Ball Field 957-551900 CONSTRUCTION 1,525,200 COMPLETE 144 C I T Y OF S C HER T Z OPERATING BUDGET 2007 - 2008 SUMMARY OF WORKING CAPITAL PROJECTS YTO COSTS STATUS 2005 BOND - PUBLIC IMPROVEMENTS ($3.200.000) Elevated Storage Tank for Lower Zone 944-551900 CONSTRUCTION 382,660 ON GOING 2006 BOND - $15.000.000 956-551900 960-551900 965-551900 $ Library Building Streets Drainage 1,038,319 203,323 78,404 ON GOING ON GOING ON GOING 2007 BOND - $9.940.000 911-551900 912-571800 912-581800 913-571401 T own creek Project EMS - Vehicles & Equipment Public Works - Machinery & Equipment Communication Equipment $ $ 230,615 90,250 293,784 1,218 ON GOING ON GOING ON GOING ON GOING 145 HUMAN PURCHASING INFORMATION RECORDS RESOURCES TECHNOLOGY MANAGEMENT FINANCE GENERAL SERVICES COMMUNITY & FIRE MEDIA RELATIONS DRAINAGE PARKS HEALTH & CODE & RECREATION ENFORCEMENT BUSINESS EMS OFFICE WATER I SEWER LIBRARY INSPECTIONS COURT SUPPORT STREETS CIVIC PLANNING CENTER & ZONING FLEET SERVICES CITY OF SCHERTZ STAFF ORGANIZATIONAL CHART WARRANT SERVICES OFFICER DEPUTY CITY SECRETARY BAILIFF AS OF 15 JUNE 2007 146 FY 2007-2008 POSITION AUTHORIZATION POSITION TITLE SERVICE GRADE AUTHORIZED MANAGEMENT City Manager Assistant City Manager Assistant City Manager Executive Assistant Assistant to City Manager/Risk Manager Special Projects Coordinator Council Discretion 46 46 28 37 35 1 1 1 1 1 1 MANAGEMENT CUSTOMER SERVICE Customer Relations/311 Services 17 4 MUNICIPAL COURT Court Clerk Deputy Court Clerk Warrant Officer Warrant Officer/Baliff 24 17 31 28 1 3 1 1 DEVELOPMENT SERVICES PLANNING AND ZONING Director of Development Services Planning Manager Planner II Planner I Planning Technician 40 38 28 24 22 1 1 1 1 1 DEVELOPMENT SERVICES INSPECTION DEPARTMENT Chief Inspector Sanitarian Assistant Inspector Code Enforcement Officer Administrative Assistant II Inspections Clerk Permit Clerk 28 28 20 20 24 13 13 2 1 1 1 1 1 1 147 SERVICE POSITION TITLE GRADE AUTHORIZED GENERAL SERVICES General Services Director 35 1 General Services Manager 28 1 Facility Worker 14 1 Facility Worker Helper 12 1 Custodian I 11 5 CITY SECRETARY Council Discretion/ City Secretary 32 1 Deputy City Secretary 24 1 COMMUNITY AND MEDIA RELATIONS Director of Community and Media Relations 35 1 Community and Media Relations Administrative Assistant 20 1 Underwriting/Marketing Assistant 25 1 RECORDS MANAGEMENT Records Manager Records Management Clerk 32 13 1 1 ENGINEERING GIS Technician II GIS Technician 28 26 1 1 148 SERVICE POSITION TITLE GRADE AUTHORIZED POLICE DEPARTMENT Police Chief 43 1 Assistant Police Chief 40 1 Lieutenant 34 2 Sergeant 31 6 Corporal 28 6 Police Officer 26 30 Office Manager 21 1 Records Clerk 12 2 Administrative Assistant II 24 1 Communications Supervisor 28 1 Communications Officer 17 12 Fire Department Law Enforcement 0 3 Court Warrant Officer 0 2 Crossing Guards (PIT) N/A 6 FIRE DEPARTMENT Fire Chief 42 1 Assistant Chief/Fire Marshal 38 1 Deputy Fire Marshal 31 1 Captain 33 3 Training Officer 28 1 Lieutenant 28 6 Fire Apparatus Operator 24 6 Firefighter 22 12 Administrative Assistant 20 1 STREET DEPARTMENT Street Supervisor 30 1 Foreman 20 1 Street Worker II 17 3 Street Sweeper Operator 17 1 Street Worker I 14 7 149 SERVICE POSITION TITLE GRADE AUTHORIZED COMMUNITY SERVICES PARKS Director 42 1 Parks and Recreation Director 40 1 Events Manager/Recreation Program Coordinator 30 1 Administrative Assistant 20 1 Park Foreman 20 1 Park Worker II 17 1 Park Worker I 14 4 Temporary Park Worker 5 1 COMMUNITY SERVICES POOLS Assistant Pool ManagerlWater Safety Instructor P.T. 8 5 Lifeguards - P.T. 7 26 COMMUNITY SERVICES LIBRARY Library Manager 35 1 Children's Librarian 28 1 Clerk 12 5 Clerk - P.T. 12 7 ANIMAL SHEL TER MANAGEMENT Supervisor 25 1 Animal Control Officer 17 2 Shelter Operator 11 3 INFORMATION TECHNOLOGY Systems Engineer II 30 1 Systems Engineer I 22 1 HUMAN RESOURCES Human Resources Director 35 1 Senior HR Generalist 27 1 HR Clerk 13 1 150 SERVICE POSITION TITLE GRADE AUTHORIZED FINANCE Finance Director 42 1 Finance Office Manager 35 1 Staff Accountant 28 1 Financial/Budget Analyst 28 1 Finance Clerk 18 2 PURCHASING Purchasing Agent 30 1 Warehouse Clerk 13 1 FLEET SERVICES Mechanic/Foreman 18 1 Mechanic 16 2 BUSINESS OFFICE Business Office Manager 35 1 Business Office Supervisor 25 1 Solid Waste Coordinator/Debt Collections Clerk 18 1 Senior Utility Billing Clerk 18 1 Utility Billing Clerk 14 3 Meter Tech II 15 1 Meter Tech I 13 2 PUBLIC WORKS DEPARTMENT Director 42 1 Assistant Director 38 1 Administrative Assistant II 24 1 Public Works Inspector 21 1 Records and Purchasing 18 1 Public Works Clerk/Dispatcher 12 1 151 POSITION TITLE SERVICE GRADE AUTHORIZED WATERlWASTEWATER DEPARTMENT Schertz/Seguin Local Government Corp Gen Mgr Supervisor Foreman Serviceman II Serviceman I DRAINAGE AND RIGHT OF WAY MAINTENANCE Public Works Superintendent Foreman Drainage Worker II Drainage Worker I EMS DEPARTMENT (Please see the note at the end of the Pay Tables) Director Operations Manager Clinical Manager EMS Office Manager Administrative Specialist Part Time Clerk Paramedic Supervisors Paramedic PIT Paramedics PIT EMT Intermediates ECONOMIC DEVELOPMENT Executive Director Economic Development Specialist 152 N/A 30 20 17 14 1 1 1 4 7 33 20 17 14 1 1 1 3 42 38 37 33 20 12 33 23 23 18 1 1 1 1 1 1 3 21 15 5 41 25 1 2 FY 2007-2008 POSITION AUTHORIZATION TOTAL FUll TIME TOTAL PART TIME TOTAL 231 59 290 Note: The above totals include these added positions for the FY: Position Executive Assistant to Assistant City Managers (9 months funding) Customer Rep/311 Services (9 months funding) GIS Technician II (Current GIS I promote to this position and Unfilled GIS I position funded 9 months) Planning Technician Communications and Media Relations Underwriting/Marketing Senior Utility Billing Clerk Police Officer Communications Officer Paramedic Street Supervisor Street Worker II Park Worker I Drainage Worker I Circulation Clerk Animal Control Shelter Operator HR Clerk Financial/Budget Analyst Warehouse Clerk Authorization 1 2 1 1 1 1 3 1 2 1 1 1 1 1 1 1 1 1 The above total reflect the following upgraded positions Assistant Facility Manager to General Services Manager Buyer Journey level to Purchasing Agent Fleet Mechanic Helper to Fleet Mechanic 1 1 1 1 1 The above totals reflect the following eliminated positions Engineer Municipal Court Judge Municipal Court Administrative Assistant Municipal Court Bailiff Information Technology Coordinator 1 1 1 1 1 Note: Schertz-Seguin local Government Corporation General Mana er not included in totals above. 153 FY 2007/2008 Pay Tables Effective 1 October 2007 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 SG5 Hour 7.68 7.83 7.99 8.15 8.31 8.47 8.64 8.82 8.99 9.17 9.36 9.54 9.73 9.93 10.13 BiWeek 614.08 626.36 638.89 651.66 664.70 677.99 691.55 705.38 719.49 733.88 748.56 763.53 778.80 794.37 810.26 Month 1330.50 1357.11 1384.25 1411.94 1440.18 1468.98 1498.36 1528.33 1558.89 1590.07 1621.87 1654.31 1687.40 1721.14 1755.57 Annual 15966 16285 16611 16943 17282 17628 17980 18340 18707 19081 19462 19852 20249 20654 21067 SG6 Hour 7.99 8.15 8.31 8.47 8.64 8.82 8.99 9.17 9.36 9.54 9.73 9.93 10.13 10.33 10.54 BiWeek 638.89 651.66 664.70 677.99 691.55 705.38 719.49 733.88 748.56 763.53 778.80 794.37 810.26 826.47 843.00 Month 1384.25 1411.94 1440.18 1468.98 1498.36 1528.33 1558.89 1590.07 1621.87 1654.31 1687.40 1721.14 1755.57 1790.68 1826.49 Annual 16611 16943 17282 17628 17980 18340 18707 19081 19462 19852 20249 20654 21067 21488 21918 SG 7 Hour 8.31 8.47 8.64 8.82 8.99 9.17 9.36 9.54 9.73 9.93 10.13 10.33 10.54 10.75 10.96 BIWeek 664.70 677.99 691.55 705.38 719.49 733.88 748.56 763.53 778.80 794.37 810.26 826.47 843.00 859.86 877.05 Month 1440.18 1468.98 1498.36 1528.33 1558.89 1590.07 1621.87 1654.31 1687.40 1721.14 1755.57 1790.68 1826.49 1863.02 1900.28 Annual 17282 17628 17980 18340 18707 19081 19462 19852 20249 20654 21067 21488 21918 22356 22803 SG8 Hour 8.64 8.82 8.99 9.17 9.36 9.54 9.73 9.93 10.13 10.33 10.54 10.75 10.96 11.18 11.41 BiWeek 691.55 705.38 719.49 733.88 748.56 763.53 778.80 794.37 810.26 826.47 843.00 859.86 877.05 894.59 912.49 Month 1498.36 1528.33 1558.89 1590.07 1621.87 1654.31 1687.40 1721.14 1755.57 1790.68 1826.49 1863.02 1900.28 1938.29 1977.05 Annual 17980 18340 18707 19081 19462 19852 20249 20654 21067 21488 21918 22356 22803 23259 23725 SG9 Hour 8.99 9.17 9.36 9.54 9.73 9.93 10.13 10.33 10.54 10.75 10.96 11.18 11.41 11.63 11.87 BiWeek 719.49 733.88 748.56 763.53 778.80 794.37 810.26 826.47 843.00 859.86 877.05 894.59 912.49 930.74 949.35 Month 1558.89 1590.07 1621.87 1654.31 1687.40 1721.14 1755.57 1790.68 1826.49 1863.02 1900.28 1938.29 1977.05 2016.59 2056.93 Annual 18707 19081 19462 19852 20249 20654 21067 21488 21918 22356 22803 23259 23725 24199 24683 SG 10 Hour 9.36 9.54 9.73 9.93 10.13 10.33 10.54 10.75 10.96 11.18 11.41 11.63 11.87 12.10 12.35 BiWeek 748.56 763.53 778.80 794.37 810.26 826.47 843.00 859.86 877.05 894.59 912.49 930.74 949.35 968.34 987.70 Month 1621.87 1654.31 1687.40 1721.14 1755.57 1790.68 1826.49 1863.02 1900.28 1938.29 1977.05 2016.59 2056.93 2098.06 2140.03 Annual 19462 19852 20249 20654 21067 21488 21918 22356 22803 23259 23725 24199 24683 25177 25680 154 FY 2007/2008 Pay Tables Effective 1 October 2007 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 11 Hour 9.73 9.93 10.13 10.33 10.54 10.75 10.96 11.18 11.41 11.63 11.87 12.10 12.35 12.59 12.85 BiWeek 778.80 794.37 810.26 826.47 843.00 859.86 877.05 894.59 912.49 930.74 949.35 968.34 987.70 1007.46 1027.61 Month 1687.40 1721.14 1755.57 1790.68 1826.49 1863.02 1900.28 1938.29 1977.05 2016.59 2056.93 2098.06 2140.03 2182.83 2226.48 Annual 20249 20654 21067 21488 21918 22356 22803 23259 23725 24199 24683 25177 25680 26194 26718 SG 12 Hour 10.13 10.33 10.54 10.75 10.96 11.18 11.41 11.63 11.87 12.10 12.35 12.59 12.85 13.10 13.36 BiWeek 810.26 826.47 843.00 859.86 877.05 894.59 912.49 930.74 949.35 968.34 987.70 1007.46 1027.61 1048.16 1069.12 Month 1755.57 1790.68 1826.49 1863.02 1900.28 1938.29 1977.05 2016.59 2056.93 2098.06 2140.03 2182.83 2226.48 2271.01 2316.43 Annual 21067 21488 21918 22356 22803 23259 23725 24199 24683 25177 25680 26194 26718 27252 27797 SG 13 Hour 10.54 10.75 10.96 11.18 11.41 11.63 11.87 12.10 12.35 12.59 12.85 13.10 13.36 13.63 13.90 BiWeek 843.00 859.86 877.05 894.59 912.49 930.74 949.35 968.34 987.70 1007.46 1027.61 1048.16 1069.12 1090.51 1112.32 Month 1826.49 1863.02 1900.28 1938.29 1977.05 2016.59 2056.93 2098.06 2140.03 2182.83 2226.48 2271.01 2316.43 2362.76 2410.02 Annual 21918 22356 22803 23259 23725 24199 24683 25177 25680 26194 26718 27252 27797 28353 28920 SG 14 Hour 10.96 11.18 11.41 11.63 11.87 12.10 12.35 12.59 12.85 13.10 13.36 13.63 13.90 14.18 14.47 BIWeek 877.05 894.59 912.49 930.74 949.35 968.34 987.70 1007.46 1027.61 1048.16 1069.12 1090.51 1112.32 1134.56 1157.25 Month 1900.28 1938.29 1977.05 2016.59 2056.93 2098.06 2140.03 2182.83 2226.48 2271.01 2316.43 2362.76 2410.02 2458.22 2507.38 Annual 22803 23259 23725 24199 24683 25177 25680 26194 26718 27252 27797 28353 28920 29499 30089 SG15 Hour 11.41 11.63 11.87 12.10 12.35 12.59 12.85 13.10 13.36 13.63 13.90 14.18 14.47 14.75 15.05 BiWeek 912.49 930.74 949.35 968.34 987.70 1007.46 1027.61 1048.16 1069.12 1090.51 1112.32 1134.56 1157.25 1180.40 1204.01 Month 1977.05 2016.59 2056.93 2098.06 2140.03 2182.83 2226.48 2271.01 2316.43 2362.76 2410.02 2458.22 2507.38 2557.53 2608.68 Annual 23725 24199 24683 25177 25680 26194 26718 27252 27797 28353 28920 29499 30089 30690 31304 SG16 Hour 11.87 12.10 12.35 12.59 12.85 13.10 13.36 13.63 13.90 14.18 14.4 7 14.75 15.05 15.35 15.66 BiWeek 949.35 968.34 987.70 1007.46 1027.61 1048.16 1069.12 1090.51 1112.32 1134.56 1157.25 1180.40 1204.01 1228.09 1252.65 Month 2056.93 2098.06 2140.03 2182.83 2226.48 2271.01 2316.43 2362.76 2410.02 2458.22 2507.38 2557.53 2608.68 2660.85 2714.07 Annual 24683 25177 25680 26194 26718 27252 27797 28353 28920 29499 30089 30690 31304 31930 32569 155 FY 2007/2008 Pay Tables Effective 1 October 2007 Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Slep 9 Slep 10 Step 11 Step 12 Slep 13 Step 14 Step 15 SG17 Hour 12.35 12.59 12.85 13.10 13.36 13.63 13.90 14.18 14.47 14.75 15.05 15.35 15.66 15.97 16.29 BiWeek 987.70 1007.46 1027.61 1048.16 1069.12 1090.51 1112.32 1134.56 1157.25 1180.40 1204.01 1228.09 1252.65 1277.70 1303.25 Month 2140.03 2182.83 2226.48 2271.01 2316.43 2362.76 2410.02 2458.22 2507.38 2557.53 2608.68 2660.85 2714.07 2768.35 2823.72 Annual 25680 26194 26718 27252 27797 28353 28920 29499 30089 30690 31304 31930 32569 33220 33885 SG 18 Hour 12.85 13.10 13.36 13.63 13.90 14.18 14.47 14.75 15.05 15.35 15.66 15.97 16.29 16.62 16.95 BiWeek 1027.61 1048.16 1069.12 1090.51 1112.32 1134.56 1157.25 1180.40 1204.01 1228.09 1252.65 1277.70 1303.25 1329.32 1355.91 Month 2226.48 2271.01 2316.43 2362.76 2410.02 2458.22 2507.38 2557.53 2608.68 2660.85 2714.07 2768.35 2823.72 2880.19 2937.80 Annual 26718 27252 27797 28353 28920 29499 30089 30690 31304 31930 32569 33220 33885 34562 35254 SG 19 Hour 13.36 13.63 13.90 14.18 14.47 14.75 15.05 15.35 15.66 15.97 16.29 16.62 16.95 17.29 17.63 BiWeek 1069.12 1090.51 1112.32 1134.56 1157.25 1180.40 1204.01 1228.09 1252.65 1277.70 1303.25 1329.32 1355.91 1383.02 1410.68 Month 2316.43 2362.76 2410.02 2458.22 2507.38 2557.53 2608.68 2660.85 2714.07 2768.35 2823.72 2880.19 2937.80 2996.55 3056.48 Annual 27797 28353 28920 29499 30089 30690 31304 31930 32569 33220 33885 34562 35254 35959 36678 SG20 Hour 13.90 14.18 14.47 14.75 15.05 15.35 15.66 15.97 16.29 16.62 16.95 17.29 17.63 17.99 18.35 BIWeek 1112.32 1134.56 1157.25 1180.40 1204.01 1228.09 1252.65 1277.70 1303.25 1329.32 1355.91 1383.02 1410.68 1438.90 1467.68 Month 2410.02 2458.22 2507.38 2557.53 2608.68 2660.85 2714.07 2768.35 2823.72 2880.19 2937.80 2996.55 3056.48 3117.61 3179.97 Annual 28920 29499 30089 30690 31304 31930 32569 33220 33885 34562 35254 35959 36678 37411 38160 SG 21 Hour 14.47 14.75 15.05 15.35 15.66 15.97 16.29 16.62 16.95 17.29 17.63 17.99 18.35 18.71 19.09 BiWeek 1157.25 1180.40 1204.01 1228.09 1252.65 1277.70 1303.25 1329.32 1355.91 1383.02 1410.68 1438.90 1467.68 1497.03 1526.97 Month 2507.38 2557.53 2608.68 2660.85 2714.07 2768.35 2823.72 2880.19 2937.80 2996.55 3056.48 3117.61 3179.97 3243.57 3308.44 Annual 30089 30690 31304 31930 32569 33220 33885 34562 35254 35959 36678 37411 38160 38923 39701 SG22 Hour 15.05 15.35 15.66 15.97 16.29 16.62 16.95 17.29 17.63 17.99 18.35 18.71 19.09 19.47 19.86 BiWeek 1204.01 1228.09 1252.65 1277.70 1303.25 1329.32 1355.91 1383.02 1410.68 1438.90 1467.68 1497.03 1526.97 1557.51 1588.66 Month 2608.68 2660.85 2714.07 2768.35 2823.72 2880.19 2937.80 2996.55 3056.48 3117.61 3179.97 3243.57 3308.44 3374.61 3442.10 Annual 31304 31930 32569 33220 33885 34562 35254 35959 36678 37411 38160 38923 39701 40495 41305 156 FY 2007/2008 Pay Tables Effective 1 October 2007 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 SG23 Hour 15.66 15.97 16.29 16.62 16.95 17.29 17.63 17.99 18.35 18.71 19.09 19.47 19.86 20.26 20.66 BiWeek 1252.65 1277.70 1303.25 1329.32 1355.91 1383.02 1410.68 1438.90 1467.68 1497.03 1526.97 1557.51 1588.66 1620.43 1652.84 Month 2714.07 2768.35 2823.72 2880.19 2937.80 2996.55 3056.48 3117.61 3179.97 3243.57 3308.44 3374.61 3442.10 3510.94 3581 .16 Annual 32569 33220 33885 34562 35254 35959 36678 37411 38160 38923 39701 40495 41305 42131 42974 SG24 Hour 16.29 16.62 16.95 17.29 17.63 17.99 18.35 18.71 19.09 19.47 19.86 20.26 20.66 21.07 21.50 BiWeek 1303.25 1329.32 1355.91 1383.02 1410.68 1438.90 1467.68 1497.03 1526.97 1557.51 1588.66 1620.43 1652.84 1685.90 1719.62 Month 2823.72 2880.19 2937.80 2996.55 3056.48 3117.61 3179.97 3243.57 3308.44 3374.61 3442.10 3510.94 3581.16 3652.78 3725.84 Annual 33885 34562 35254 35959 36678 37411 38160 38923 39701 40495 41305 42131 42974 43833 44710 SG25 Hour 16.95 17.29 17.63 17.99 18.35 18.71 19.09 19.47 19.86 20.26 20.66 21.07 21.50 21.93 22.36 BiWeek 1355.91 1383.02 1410.68 1438.90 1467.68 1497.03 1526.97 1557.51 1588.66 1620.43 1652.84 1685.90 1719.62 1754.01 1789.09 Month 2937.80 2996.55 3056.48 3117.61 3179.97 3243.57 3308.44 3374.61 3442.10 3510.94 3581 .16 3652.78 3725.84 3800.35 3876.36 Annual 35254 35959 36678 37411 38160 38923 39701 40495 41305 42131 42974 43833 44710 45604 46516 SG26 Hour 17.63 17.99 18.35 18.71 19.09 19.47 19.86 20.26 20.66 21.07 21.50 21.93 22.36 22.81 23.27 BiWeek 1410.68 1438.90 1467.68 1497.03 1526.97 1557.51 1588.66 1620.43 1652.84 1685.90 1719.62 1754.01 1789.09 1824.87 1861.37 Month 3056,48 3117.61 3179.97 3243.57 3308.44 3374.61 3442.10 3510.94 3581.16 3652.78 3725.84 3800.35 3876.36 3953.89 4032.97 Annual 36678 37411 38160 38923 39701 40495 41305 42131 42974 43833 44710 45604 46516 47447 48396 SG 27 Hour 18.35 18.71 19.09 19.47 19.86 20.26 20.66 21.07 21.50 21.93 22.36 22.81 23.27 23.73 24.21 BiWeek 1467.68 1497.03 1526.97 1557.51 1588.66 1620.43 1652.84 1685.90 1719.62 1754.01 1789.09 1824.87 1861.37 1898.60 1936.57 Month 3179.97 3243.57 3308.44 3374.61 3442.10 3510.94 3581 .16 3652.78 3725.84 3800.35 3876.36 3953.89 4032.97 4113.62 4195.90 Annual 38160 38923 39701 40495 41305 42131 42974 43833 44710 45604 46516 47447 48396 49363 50351 SG28 Hour 19.09 19.47 19.86 20.26 20.66 21.07 21.50 21.93 22.36 22.81 23.27 23.73 24.21 24.69 25.19 BiWeek 1526.97 1557.51 1588.66 1620.43 1652.84 1685.90 1719.62 1754.01 1789.09 1824.87 1861.37 1898.60 1936.57 1975.30 2014.81 Month 3308.44 3374.61 3442.10 3510.94 3581.16 3652.78 3725.84 3800.35 3876.36 3953.89 4032.97 4113.62 4195.90 4279.82 4365.41 Annual 39701 40495 41305 42131 42974 43833 44710 45604 46516 47447 48396 49363 50351 51358 52385 157 FY 2007/2008 Pay Tables Effective 1 October 2007 Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Step 9 Step 1 0 Step 11 Step 12 Step 13 Step 14 Step 15 SG29 Hour 19.86 20.26 20.66 21.07 21.50 21.93 22.36 22.81 23.27 23.73 24.21 24.69 25.19 25.69 26.20 BiWeek 1588.66 1620.43 1652.84 1685.90 1719.62 1754.01 1789.09 1824.87 1861.37 1898.60 1936.57 1975.30 2014.81 2055.10 2096.20 Month 3442.10 3510.94 3581.16 3652.78 3725.84 3800.35 3876.36 3953.89 4032.97 4113.62 4195.90 4279.82 4365.41 4452.72 4541.77 Annual 41305 42131 42974 43833 44710 45604 46516 47447 48396 49363 50351 51358 52385 53433 54501 SG30 Hour 20.66 21.07 21.50 21.93 22.36 22.81 23.27 23.73 24.21 24.69 25.19 25.69 26.20 26.73 27.26 BiWeek 1652.84 1685.90 1719.62 1754.01 1789.09 1824.87 1861.37 1898.60 1936.57 1975.30 2014.81 2055.10 2096.20 2138.13 2180.89 Month 3581.16 3652.78 3725.84 3800.35 3876.36 3953.89 4032.97 4113.62 4195.90 4279.82 4365.41 4452.72 4541.77 4632.61 4725.26 Annual 42974 43833 44710 45604 46516 47447 48396 49363 50351 51358 52385 53433 54501 55591 56703 SG 31 Hour 21.50 21.93 22.36 22.81 23.27 23.73 24.21 24.69 25.19 25.69 26.20 26.73 27.26 27.81 28.36 BiWeek 1719.62 1754.01 1789.09 1824.87 1861.37 1898.60 1936.57 1975.30 2014.81 2055.10 2096.20 2138.13 2180.89 2224.51 2269.00 Month 3725.84 3800.35 3876.36 3953.89 4032.97 4113.62 4195.90 4279.82 4365.41 4452.72 4541.77 4632.61 4725.26 4819.77 4916.16 Annual 44710 45604 46516 47447 48396 49363 50351 51358 52385 53433 54501 55591 56703 57837 58994 SG 32 Hour 22.36 22.81 23.27 23.73 24.21 24.69 25.19 25.69 26.20 26.73 27.26 27.81 28.36 28.93 29.51 BiWeek 1789.09 1824.87 1861.37 1898.60 1936.57 1975.30 2014.81 2055.10 2096.20 2138.13 2180.89 2224.51 2269.00 2314.38 2360.67 Month 3876.36 3953.89 4032.97 4113.62 4195.90 4279.82 4365.41 4452.72 4541.77 4632.61 4725.26 4819.77 4916.16 5014.49 5114.78 Annual 46516 47447 48396 49363 50351 51358 52385 53433 54501 55591 56703 57837 58994 60174 61377 SG 33 Hour 23.27 23.73 24.21 24.69 25.19 25.69 26.20 26.73 27.26 27.81 28.36 28.93 29.51 30.10 30.70 BiWeek 1861.37 1898.60 1936.57 1975.30 2014.81 2055.10 2096.20 2138.13 2180.89 2224.51 2269.00 2314.38 2360.67 2407.88 2456.04 Month 4032.97 4113.62 4195.90 4279.82 4365.41 4452.72 4541.77 4632.61 4725.26 4819.77 4916.16 5014.49 5114.78 5217.07 5321.41 Annual 48396 49363 50351 51358 52385 53433 54501 55591 56703 57837 58994 60174 61377 62605 63857 SG 34 Hour 24.21 24.69 25.19 25.69 26.20 26.73 27.26 27.81 28.36 28.93 29.51 30.10 30.70 31.31 31.94 BiWeek 1936.57 1975.30 2014.81 2055.10 2096.20 2138.13 2180.89 2224.51 2269.00 2314.38 2360.67 2407.88 2456.04 2505.16 2555.26 Month 4195.90 4279.82 4365.41 4452.72 4541.77 4632.61 4725.26 4819.77 4916.16 5014.49 5114.78 5217.07 5321.41 5427.84 5536.40 Annual 50351 51358 52385 53433 54501 55591 56703 57837 58994 60174 61377 62605 63857 65134 66437 158 FY 2007/2008 Pay Tables Effective 1 October 2007 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 35 Hour 25.19 25.69 26.20 26.73 27.26 27.81 28.36 28.93 29.51 30.10 30.70 31.31 31.94 32.58 33.23 BiWeek 2014.81 2055.10 2096.20 2138.13 2180.89 2224.51 2269.00 2314.38 2360.67 2407.88 2456.04 2505.16 2555.26 2606.37 2658.49 Month 4365.41 4452.72 4541.77 4632.61 4725.26 4819.77 4916.16 5014.49 5114.78 5217.07 5321.41 5427.84 5536.40 5647.13 5760.07 Annual 52385 53433 54501 55591 56703 57837 58994 60174 61377 62605 63857 65134 66437 67766 69121 SG 36 Hour 26.20 26.73 27.26 27.81 28.36 28.93 29.51 30.10 30.70 31.31 31.94 32.58 33.23 33.90 34.57 B/Week 2096.20 2138.13 2180.89 2224.51 2269.00 2314.38 2360.67 2407.88 2456.04 2505.16 2555.26 2606.37 2658.49 2711.66 2765.90 Month 4541.77 4632.61 4725.26 4819.77 4916.16 5014.49 5114.78 5217.07 5321.41 5427.84 5536.40 5647.13 5760.07 5875.27 5992.77 Annual 54501 55591 56703 57837 58994 60174 61377 62605 63857 65134 66437 67766 69121 70503 71913 SG 37 Hour 27.26 27.81 28.36 28.93 29.51 30.10 30.70 31.31 31.94 32.58 33.23 33.90 34.57 35.27 35.97 BiWeek 2180.89 2224.51 2269.00 2314.38 2360.67 2407.88 2456.04 2505.16 2555.26 2606.37 2658.49 2711.66 2765.90 2821.21 2877.64 Month 4725.26 4819.77 4916.16 5014.49 5114.78 5217.07 5321.41 5427.84 5536.40 5647.13 5760.07 5875.27 5992.77 6112.63 6234.88 Annual 56703 57837 58994 60174 61377 62605 63857 65134 66437 67766 69121 70503 71913 73352 74819 SG 38 Hour 28.36 28.93 29.51 30.10 30.70 31.31 31.94 32.58 33.23 33.90 34.57 35.27 35.97 36.69 37.42 BiWeek 2269.00 2314.38 2360.67 2407.88 2456.04 2505.16 2555.26 2606.37 2658.49 2711.66 2765.90 2821.21 2877.64 2935.19 2993.89 Month 4916.16 5014.49 5114.78 5217.07 5321.41 5427.84 5536.40 5647.13 5760.07 5875.27 5992.77 6112.63 6234.88 6359.58 6486.77 Annual 58994 60174 61377 62605 63857 65134 66437 67766 69121 70503 71913 73352 74819 76315 77841 SG39 Hour 29.51 30.10 30.70 31.31 31.94 32.58 33.23 33.90 34.57 35.27 35.97 36.69 37.42 38.17 38.94 BiWeek 2360.67 2407.88 2456.04 2505.16 2555.26 2606.37 2658.49 2711.66 2765.90 2821.21 2877.64 2935.19 2993.89 3053.77 3114.85 Month 5114.78 5217.07 5321.41 5427.84 5536.40 5647.13 5760.07 5875.27 5992.77 6112.63 6234,88 6359.58 6486.77 6616.51 6748.84 Annual 61377 62605 63857 65134 66437 67766 69121 70503 71913 73352 74819 76315 77841 79398 80986 SG40 Hour 30.70 31.31 31.94 32.58 33.23 33.90 34.57 35.27 35.97 36.69 37.42 38.17 38.94 39.71 40.51 BiWeek 2456.04 2505.16 2555.26 2606.37 2658.49 2711.66 2765.90 2821.21 2877.64 2935.19 2993.89 3053.77 3114.85 3177.14 3240.69 Month 5321.41 5427.84 5536.40 5647.13 5760.07 5875.27 5992.77 6112.63 6234.88 6359.58 6486.77 6616.51 6748,84 6883.81 7021 .49 Annual 63857 65134 66437 67766 69121 70503 71913 73352 74819 76315 77841 79398 80986 82606 84258 159 FY 2007/2008 Pay Tables Effective 1 October 2007 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 41 Hour 31.94 32.58 33.23 33.90 34.57 35.27 35.97 36.69 37.42 38.17 38.94 39.71 40.51 41.32 42.15 BIWeek 2555.26 2606.37 2658.49 2711.66 2765.90 2821.21 2877.64 2935.19 2993.89 3053.77 3114.85 3177.14 3240.69 3305.50 3371.61 Month 5536.40 5647.13 5760.07 5875.27 5992.77 6112.63 6234.88 6359.58 6486.77 6616.51 6748.84 6883.81 7021.49 7161.92 7305.16 Annual 66437 67766 69121 70503 71913 73352 74819 76315 77841 79398 80986 82606 84258 85943 87662 SG42 Hour 33.23 33.90 34.57 35.27 35.97 36.69 37.42 38.17 38.94 39.71 40.51 41.32 42.15 42.99 43.85 BiWeek 2658.49 2711.66 2765.90 2821.21 2877 .64 2935.19 2993.89 3053.77 3114.85 3177.14 3240.69 3305.50 3371.61 3439.04 3507.82 Month 5760.07 5875.27 5992.77 6112.63 6234.88 6359.58 6486.77 6616.51 6748.84 6883.81 7021 .49 7161.92 7305.16 7451.26 7600.29 Annual 69121 70503 71913 73352 74819 76315 77841 79398 80986 82606 84258 85943 87662 89415 91203 SG43 Hour 34.57 35.27 35.97 36.69 37.42 38.17 38.94 39.71 40.51 41.32 42.15 42.99 43.85 44.72 45.62 BiWeek 2765.90 2821.21 2877.64 2935.19 2993.89 3053.77 3114.85 3177.14 3240.69 3305.50 3371.61 3439.04 3507.82 3577.98 3649.54 Month 5992.77 6112.63 6234.88 6359.58 6486.77 6616.51 6748.84 6883.81 7021.49 7161.92 7305.16 7451.26 7600.29 7752.29 7907.34 Annual 71913 73352 74819 76315 77841 79398 80986 82606 84258 85943 87662 89415 91203 93028 94888 SG44 Hour 35.97 36.69 37.42 38.17 38.94 39.71 40.51 41.32 42.15 42.99 43.85 44.72 45.62 46.53 47.46 BIWeek 2877.64 2935.19 2993.89 3053.77 3114.85 3177.14 3240.69 3305.50 3371.61 3439.04 3507.82 3577.98 3649.54 3722.53 3796.98 Month 6234.88 6359.58 6486.77 6616.51 6748.84 6883.81 7021.49 7161.92 7305.16 7451.26 7600.29 7752.29 7907.34 8065.49 8226.80 Annual 74819 76315 77841 79398 80986 82606 84258 85943 87662 89415 91203 93028 94888 96786 98722 SG45 Hour 37.42 38.17 38.94 39.71 40.51 41.32 42.15 42.99 43.85 44.72 45.62 46.53 47.46 48.41 49.38 BiWeek 2993.89 3053.77 3114.85 3177.14 3240.69 3305.50 3371.61 3439.04 3507.82 3577.98 3649.54 3722.53 3796.98 3872.92 3950.38 Month 6486.77 6616.51 6748.84 6883.81 7021.49 7161.92 7305.16 7451.26 7600.29 7752.29 7907.34 8065.49 8226.80 8391.33 8559.16 Annual 77841 79398 80986 82606 84258 85943 87662 89415 91203 93028 94888 96786 98722 100696 102710 SG46 Hour 38.94 39.71 40.51 41.32 42.15 42.99 43.85 44.72 45.62 46.53 47.46 48.41 49.38 50.37 51.37 BiWeek 3114.85 3177.14 3240.69 3305.50 3371.61 3439.04 3507.82 3577.98 3649.54 3722.53 3796.98 3872.92 3950.38 4029.39 4109.98 Month 6748.84 6883.81 7021.49 7161.92 7305.16 7451.26 7600.29 7752.29 7907.34 8065.49 8226.80 8391.33 8559.16 8730.34 8904.95 Annual 80986 82606 84258 85943 87662 89415 91203 93028 94888 96786 98722 100696 102710 104764 106859 160 FY 2007/2008 Pay Tables Effective 1 October 2007 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 SG47 Hour 40.51 41.32 42.15 42.99 43.85 44.72 45.62 46.53 47.46 48.41 49.38 50.37 51.37 52.40 53.45 BiWeek 3240.69 3305.50 3371.61 3439.04 3507.82 3577.98 3649.54 3722.53 3796.98 3872.92 3950.38 4029.39 4109.98 4192.18 4276.02 Month 7021.49 7161.92 7305.16 7451.26 7600.29 7752.29 7907.34 8065.49 8226.80 8391.33 8559.16 8730.34 8904.95 9083.05 9264.71 Annual 84258 85943 87662 89415 91203 93028 94888 96786 98722 100696 102710 104764 106859 108997 111176 SG48 Hour 42.15 42.99 43.85 44.72 45.62 46.53 47.46 48.41 49.38 50.37 51.37 52.40 53.45 54.52 55.61 BiWeek 3371.61 3439.04 3507.82 3577.98 3649.54 3722.53 3796.98 3872.92 3950.38 4029.39 4109.98 4192.18 4276.02 4361.54 4448.77 Month 7305.16 7451.26 7600.29 7752.29 7907.34 8065.49 8226.80 8391.33 8559.16 8730.34 8904.95 9083.05 9264.71 9450.00 9639.00 Annual 87662 89415 91203 93028 94888 96786 98722 100696 102710 104764 106859 108997 111176 113400 115668 SG49 Hour 43.85 44.72 45.62 46.53 47.46 48.41 49.38 50.37 51.37 52.40 53.45 54.52 55.61 56.72 57.86 BiWeek 3507.82 3577.98 3649.54 3722.53 3796.98 3872.92 3950.38 4029.39 4109.98 4192.18 4276.02 4361.54 4448.77 4537.75 4628.50 Month 7600.29 7752.29 7907.34 8065.49 8226.80 8391.33 8559.16 8730.34 8904.95 9083.05 9264.71 9450.00 9639.00 9831.78 10028.42 Annual 91203 93028 94888 96786 98722 100696 102710 104764 106859 108997 111176 113400 115668 117981 120341 SG50 Hour 45.62 46.53 47.46 48.41 49.38 50.37 51.37 52.40 53.45 54.52 55.61 56.72 57.86 59.01 60.19 BIWeek 3649.54 3722.53 3796.98 3872.92 3950.38 4029.39 4109.98 4192.18 4276.02 4361.54 4448.77 4537.75 4628.50 4721.07 4815.49 Month 7907.34 8065A9 8226.80 8391 .33 8559.16 8730.34 8904.95 9083.05 9264.71 9450.00 9639.00 9831.78 10028.42 10228.99 10433.57 Annual 94888 96786 98722 100696 102710 104764 106859 108997 111176 113400 115668 117981 120341 122748 125203 SG 51 Hour 47.46 48.41 49.38 50.37 51.37 52.40 53.45 54.52 55.61 56.72 57.86 59.01 60.19 61.40 62.63 BiWeek 3796.98 3872.92 3950.38 4029.39 4109.98 4192.18 4276.02 4361.54 4448.77 4537.75 4628.50 4721.07 4815.49 4911.80 5010.04 Month 8226.80 8391.33 8559.16 8730.34 8904.95 9083.05 9264.71 9450.00 9639.00 9831.78 10028.42 10228.99 10433.57 10642.24 10855.08 Annual 98722 100696 102710 104764 106859 108997 111176 113400 115668 117981 120341 122748 125203 127707 130261 SG 52 Hour 49.38 50.37 51.37 52.40 53.45 54.52 55.61 56.72 57.86 59.01 60.19 61.40 62.63 63.88 65.16 BiWeek 3950.38 4029.39 4109.98 4192.18 4276.02 4361.54 4448.77 4537.75 4628.50 4721.07 4815.49 4911.80 5010.04 5110.24 5212.44 Month 8559.16 8730.34 8904.95 9083.05 9264.71 9450.00 9639.00 9831.78 10028.42 10228.99 10433.57 10642.24 10855.08 11072.18 11293.63 Annual 102710 104764 106859 108997 111176 113400 115668 117981 120341 122748 125203 127707 130261 132866 135524 161 FY 2007/2008 Pay Tables Effective 1 October 2007 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 SG53 Hour 51.37 52.40 53.45 54.52 55.61 56.72 57.86 59.01 60.19 61.40 62.63 63.88 65.16 66.46 67.79 BiWeek 4109.98 4192.18 4276.02 4361.54 4448.77 4537.75 4628.50 4721.07 4815.49 4911.80 5010.04 5110.24 5212.44 5316.69 5423.03 Month 8904.95 9083.05 9264.71 9450.00 9639.00 9831.78 10028.42 10228.99 10433.57 10642.24 10855.08 11072.18 11293.63 11519.50 11749.89 Annual 106859 108997 111176 113400 115668 117981 120341 122748 125203 127707 130261 132866 135524 138234 140999 SG54 Hour 53.45 54.52 55.61 56.72 57.86 59.01 60.19 61.40 62.63 63.88 65.16 66.46 67.79 69.14 70.53 BiWeek 4276.02 4361.54 4448.77 4537.75 4628.50 4721.07 4815.49 4911.80 5010.04 5110.24 5212.44 5316.69 5423.03 5531.49 5642.12 Month 9264.71 9450.00 9639.00 9831.78 10028.42 10228.99 10433.57 10642.24 10855.08 11072.18 11293.63 11519.50 11749.89 11984.89 12224.58 Annual 111176 113400 115668 117981 120341 122748 125203 127707 130261 132866 135524 138234 140999 143819 146695 SG 55 Hour 55.61 56.72 57.86 59.01 60.19 61.40 62.63 63.88 65.16 66.46 67.79 69.14 70.53 71.94 73.38 BiWeek 4448.77 4537.75 4628.50 4721.07 4815.49 4911.80 5010.04 5110.24 5212.44 5316.69 5423.03 5531 .49 5642.12 5754.96 5870.06 Month 9639.00 9831.78 10028.42 10228.99 10433.57 10642.24 10855.08 11072.18 11293.63 11519.50 11749.89 11984.89 12224.58 12469.08 12718.46 Annual 115668 117981 120341 122748 125203 127707 130261 132866 135524 138234 140999 143819 146695 149629 152621 SG56 Hour 57.86 59.01 60.19 61.40 62.63 63.88 65.16 66.46 67.79 69.14 70.53 71.94 73.38 74.84 76.34 BiWeek 4628.50 4721.07 4815.49 4911.80 5010.04 5110.24 5212.44 5316.69 5423.03 5531 .49 5642.12 5754.96 5870.06 5987.46 6107.21 Month 10028.42 10228.99 10433.57 10642.24 10855.08 11072.18 11293.63 11519.50 11749.89 11984.89 12224.58 12469.08 12718.46 12972.83 13232.28 Annual 120341 122748 125203 127707 130261 132866 135524 138234 140999 143819 146695 149629 152621 155674 158787 SG 57 Hour 60.19 61.40 62.63 63.88 65.16 66.46 67.79 69.14 70.53 71.94 73.38 74.84 76.34 77.87 79.42 BiWeek 4815.49 4911.80 5010.04 5110.24 5212.44 5316.69 5423.03 5531 .49 5642.12 5754.96 5870.06 5987.46 6107.21 6229.35 6353.94 Month 10433.57 10642.24 10855.08 11072.18 11293.63 11519.50 11749.89 11984.89 12224.58 12469.08 12718.46 12972.83 13232.28 13496.93 13766.87 Annual 125203 127707 130261 132866 135524 138234 140999 143819 146695 149629 152621 155674 158787 161963 165202 SG58 Hour 62.63 63.88 65.16 66.46 67.79 69.14 70.53 71.94 73.38 74.84 76.34 77.87 79.42 81.01 82.63 BiWeek 5010.04 5110.24 5212.44 5316.69 5423.03 5531.49 5642.12 5754.96 5870.06 5987.46 6107.21 6229.35 6353.94 6481.02 6610.64 Month 10855.08 11072.18 11293.63 11519.50 11749.89 11984.89 12224.58 12469.08 12718.46 12972.83 13232.28 13496.93 13766.87 14042.21 14323.05 Annual 130261 132866 135524 138234 140999 143819 146695 149629 152621 155674 158787 161963 165202 168506 171877 162 FY 2007/2008 Pay Tables Effective 1 October 2007 Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Slep 9 Slep 10 Slep 11 Slep 12 Step 13 Step 14 Slep 15 SG 59 Hour 65.16 66.46 67.79 69.14 70.53 71.94 73.38 74.84 76.34 77.87 79.42 81.01 82.63 84.29 85.97 BiWeek 5212.44 5316.69 5423.03 5531 .49 5642.12 5754.96 5870.06 5987.46 6107.21 6229.35 6353.94 6481.02 6610.64 6742.85 6877.71 Month 11293.63 11519.50 11749.89 11984.89 12224.58 12469.08 12718.46 12972.83 13232.28 13496.93 13766.87 14042.21 14323.05 14609.51 14901.70 Annual 135524 138234 140999 143819 146695 149629 152621 155674 158787 161963 165202 168506 171877 175314 178820 SG60 Hour 67.79 69.14 70.53 71.94 73.38 74.84 76.34 77.87 79.42 81.01 82.63 84.29 85.97 87.69 89.44 BiWeek 5423.03 5531.49 5642.12 5754.96 5870.06 5987.46 6107.21 6229.35 6353.94 6481.02 6610.64 6742.85 6877.71 7015.26 7155.57 Month 11749.89 11984.89 12224.58 12469.08 12718.46 12972.83 13232.28 13496.93 13766.87 14042.21 14323.05 14609.51 14901.70 15199.73 15503.73 Annual 140999 143819 146695 149629 152621 155674 158787 161963 165202 168506 171877 175314 178820 182397 186045 Note: This table does not apply to EMS Personel Working 24/48 Shifts. Computation of Hourly rates and Overtime Compensation is governed by The Fair Labor Standards Handbook, Section 520, Irregular Hours. 163 2007/2008 COMPENSATION PLAN SECTION I 1. Salary Schedule The p ay 0 f Cit y em ployees s hall be 0 n t he bas is 0 f t he 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 m ore than twelve months, when separation w as 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 164 2007/2008 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. 165 200712008 COMPENSATION PLAN SECTION III 1. Compensation of Part-Time Employees A part-time employee is an employee who works less than 30 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 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 stimulate interest in the principles of personnel administration through increased 166 2007/2008 COMPENSATION PLAN 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. 167 2007/2008 TRAVEL POLICY 1) OFFICIAL TRAVEL DEFINED: a) EMPLOYEES: City of Schertz employees perform official travel whenever they leave the immediate area of their work place pursuant to performing primary duties; attending meetings, training, or conferences; or performing any other acts as authorized or directed by Department Heads or the City Manager when such travel is necessary to conduct official business on behalf of the City. Travel between residence and any City office in Schertz is not considered official travel. b) ELECTED OFFICIALS: Elected officials perform official travel whenever they leave their residences pursuant to attending meetings, conferences, or training; attending public events when requested; or performing any other duties required to represent the City in their elected capacity. c) OTHERS: Members of commissions, committees, or boards may be required to perform official travel as described in la above. They are deemed to be in an official travel status only when such travel is approved, prior or subsequent to travel, by the City Manager or an Assistant City Manager. 2) GENERAL POLICIES: a) Travelers are expected to use City-owned vehicles when performing official or work related travel. When a City-owned vehicle is not available or its use is impractical, the travel-authorizing official (defined as the person, usually a supervisor, Department Head, Assistant City Manager, or the City Manager who directed the travel be performed) may authorize use of a privately owned vehicle. A statement from the travel-authorizing official must be attached to the reimbursement form. b) Travelers are expected to book commercial tickets well in advance of travel to take advantage of internet specials and other reduced fares. When commercial planes are used, full-fare tickets are not authorized unless no other tickets are available. Only the City Manager or an Assistant City Manager may approve full-fare tickets. c) Rental vehicles may be used during overnight travel or when commercial transportation is used for vicinity travel. Rental vehicles must be approved by the travel-authorizing official and supported with a statement attached to the reimbursement form. d) Travelers are expected to use hotel and airport shuttles whenever possible. If not practical or available, taxicabs may be used. Use of taxicabs is also allowed for travel between the hotel and the place where meals are procured. 168 2007/2008 TRAVEL POLICY e) Travelers who are issued City credit cards are expected to use the card whenever possible to pay for meals, lodging, transportation, and reimbursable expenses. Alcoholic beverages may not be charged against the credit card --- they are considered non-reimbursable personal expenses. f) Travelers may request an advance of funds based upon estimated expenses by completing the appropriate form at the Finance Department. Advanced funds are subtracted from the net payable upon completion of traveL Any amount due the City of Schertz must be repaid. Reimbursement in excess of the advanced funds will be paid to the traveler. 3) TYPES OF TRAVEL: a) VICINITY TRA VEL: Travel within and around the City of Schertz that does not require an overnight absence. All same-day travel is considered vicinity traveL b) TEMPORARY DUTY TRAVEL (TDY): Travel that requires the employee, elected official, or other designated person to remain overnight at one or more locations outside the City of Schertz. 4) MODES OF TRAVEL DEFINED AND BASIC REIMBURSEMENT RULES: a) GOVERNMENT VEHICLE: Travel in a vehicle owned by a state or municipal government including the City of Schertz. No reimbursement is authorized when this mode is used except when personal funds are expended for parking, gasoline, tolls, emergency repairs, or other necessary expenses. b) COMMERCIAL TRAVEL: Travel on any public conveyance including plane, train, taxi, and bus. When personal funds are used to procure this mode (except taxi), reimbursement is authorized but is limited to the cost that would have been incurred had the City of Schertz purchased the tickets in advance of traveL Actual cost oftaxicabs is authorized to include a customary 15% tip. c) PRIVATELY OWNED VEHICLE (POY): Reimbursement for use of a POV mayor may not be reimbursable. When it is reimbursable, there are two rates of reimbursement depending upon circumstances surrounding the travel as specified below: i) Use directed as more advantageous to the City: When the travel authorizing official determines that the use of the traveler's personal vehicle is necessary or more advantageous to the City, or a government vehicle is notavailable, a mileage allowance is payable at the rate prescribed at www.gsa.gov/mileage for "government vehicle not available." Since elected officials, board members, commission members, etc are not authorized to drive 169 2007/2008 TRAVEL POLICY government owned vehicles; they will always fall under this paragraph. All expenses associated with operation of the vehicle, including gasoline and parking, are borne by the operator. Only the owner/operator of the vehicle may receive this allowance; passengers do not receive any mileage payments. Per Diem is authorized for the actual elapsed travel time unless the traveler elects to take personal vacation in conjunction with the travel. ii) Used for personal convenience: A traveler may elect to use a POV for personal reasons. For vicinity travel, mileage reimbursement is payable at the rates prescribed in www.gsa.gov/mileage for "government vehicle not available." For TDY, mileage is payable at the rates prescribed at www.gsa.gov/mileage for "government vehicle available", but is limited to the cost of commercial transportation. When determining the cost of commercial transportation, include the cost oftickets plus the cost oftaxis from the common carrier terminal to the hotel, and return. If necessary, rental cars are also included in the constructive travel cost. Only the owner/operator of the vehicle may receive this allowance; passengers do not receive any mileage payments. iii) Employees Receiving an Annual Car Allowance: Employees who receive an annual car allowance do not receive any mileage payments unless they are performing duty more than 150 miles away from the City of Schertz. Tolls and parking are reimbursable for travel within the ISO-mile radius. 5) PER DIEM: Per Diem is defined as a method by which travelers receive compensation for meals and expenses at a fixed rate. The full Per Diem is payable at the rates prescribed at www.gsa.gov/perdiem. Travelers performing Vicinity Travel are authorized reimbursement for missed meals at the rates prescribed at www.gsa.gov/mie. Per Diem, not actual expenses, is used to reimburse travelers for incidental expenses and for missed meals during the performance ofTDY and Vicinity Travel. Generally, receipts for meals are not required. Hotel costs are reimbursed based upon actual expense not to exceed the hotel rate prescribed at the web site. Per Diem for meals is only payable when person3J. funds are used. If a City credit card is used, no reimbursement is authorized. However, alcoholic beverages may not be charged against the City credit card (they are considered non-reimbursable personal expenses). Additionally, if conference or meeting costs include the cost of meals, Per Diem is not payable for those meals. The following general rules apply to all travelers: a) The City Manager or an Assistant City Manager may authorize: i) Actual expense reimbursement for meals for attendance at conferences or meetings where the cost of meals is dictated but not included in the conference or meeting fee. 170 2007/2008 TRAVEL POLICY ii) Actual expense for meal reimbursement where entertainment is an essential element of the travel and the cost of meals exceeds the Per Diem rate. iii) Actual cost of hotel when the cost exceeds the Per Diem rate but use is required because of attendance at conferences or meetings. iv) In all cases, a written statement from the approving authority must support the reimbursement claim. b) The incidental expense portion of the Per Diem rate is only authorized for TDY, not for same-day travel (vicinity travel). c) The traveler's location at midnight determines the Per Diem and hotel rates payable that day for TDY. d) For purposes of determining eligibility for Per Diem, meal hours are considered to be 0700 (7:00 AM), 1200 (12:00 noon), and 1800 (6:00 PM) hours. For travelers performing Vicinity Travel, and for the days of departure from and return to Schertz while TDY, Per Diem is payable only if the employee or official is actually in a travel status over the meal hours e) For interim days, the full MIE rate is payable. f) For the days of departure to and from TDY, the incidental expense portion is payable as well as Per Diem for missed meals based upon actual or constructive times of departure or return (see 5d above). g) Airline meals and meals furnished free of charge to the traveler (unless included as part of the registration fee or conference fee) do not reduce Per Diem entitlement. h) For vicinity travel, the Per Diem rate for missed meals is determined by the traveler's location at the meal times defined in paragraph 5d above. i) Receipts for meals are not required unless subparagraph 5a applies. Receipts are required for reimbursement of hotel costs. j) When friends or family accompany the traveler, only the single rate for the hotel is authorized. Travelers may not be reimbursed for meals for friends and family. The City Manager or an Assistant City Manager may make an exception to these rules when it is determined that the nature of the travel (i.e.; entertainment of dignitaries) necessitates attendance of friends or family members. 6) V ACA TION CHARGEABLE IN CONNECTION WITH TDY: Travelers may elect to take vacation in conjunction with travel either prior to or after official duty is performed. In addition, travelers may elect to use their POV s for personal convenience. In both cases the following rules apply: a) The Finance Department will determine the time the traveler was required to be at, or was able to depart the TDY point. b) The Finance Department will construct a travel schedule using major airline schedules. c) For vacation travel prior to the TDY, the Finance Department will determine the required reporting time and construct a schedule that will 171 2007/2008 TRAVEL POLICY allow the traveler to arrive in time to meet the reporting requirements. Consideration must be given to the travel time required for taxi travel from the airport to the hotel or TDY point. d) For vacation after the TDY, the Finance Department will apply a constructive travel schedule based upon the time the traveler was free to depart the TDY point. Consideration must be given to the travel time required for taxi travel from the hotel or TDY point to the airport. e) Per Diem and hotel reimbursements are limited to the time included in the constructive travel schedule. f) In no case will a constructive travel schedule require a traveler to travel between 0001...:0600 hours. g) Employees will be charged vacation time for duty hours missed in excess of the constructive travel schedule. 7) REIMBURSABLE EXPENSES: Where specified, receipts are required to support reimbursement. The traveler may claim other reimbursements, which may be approved by the City Manager or an Assistant City Manager on a case-by-case basis. The following expenses may be reimbursed: a) Registration and conference fees (receipts required). Ifthe conference or registration fee includes the costs of meals, the traveler is obligated to inform the Finance Department to ensure Per Diem is not paid for those meals. b) Tips and gratuities for taxis, meals, and valet parking. Generally, such tips are limited to 15% of the cost or taxi or meals. c) Valet parking (receipt required) only when no other parking is available or practical. Tips are limited to $3.00 (no receipt required). d) Telephone charges, fax charges, and computer access charges when used to conduct official business. e) Commercial parking or metered parking. f) Taxi cabs between hotels and common carrier terminals, or between hotel and place where meals are procured. g) Baggage tips at hotel and airports not to exceed $1.50 per bag. h) Laundry and dry cleaning if travel exceeds five days (receipt required). 8) EXCLUDED EXPENSES: Items not reimbursable include, but are not limited to: a) Cleaning or laundry if the trip lasts five (5) days or less. b) Flight insurance. c) Rental car insurance. d) Personal entertainment. e) Conference-related tours for personal sightseeing and pleasure. f) Spouse/family member/guest expenses except as authorized in 5j above. g) Personal grooming and incidentals. h) In-room movies. i) Baby-sitting. j) Kenneling. 172 DEBT SERVICE REVIEW General Fund Year 2008 2009 2010 2011 2012 2013 1992 $ 74,480 $ - $ $ $ $ 2001 346,470 348,075 349,980 351,318 356,905 356,668 - to 2021 2003 243,089 243,270 247,480 250,820 253,800 256,368 - to 2018 2004 615,936 628,036 604,227 590,008 566,008 562,211 - to 2024 2006 1,240,381 756,981 752,981 650,981 748,981 842,981 - to 2031 2007 101,679 103,872 105,865 107,657 109,248 110,639 - to 2016 Total $2,622,036 $2,080,235 $2.060.533 $1.950.784 $2.034,942 $2,128,867 Water and Waste Water Debt Service Year 2008 2009 2010 2011 2012 2013 1974 $ 8,050 $ 7,700 $ 7,350 $ - $ - $ 2001 470,550 468,381 368,131 368,671 368,551 367,631 - to 2021 2005 237,994 234,169 234,956 235,331 235,363 235,031 - to 2025 2007 84,662 82,256 79,850 82,444 79,837 82,231 - to 2016 Total $ 716,594 $ 710,250 $ 610,437 $ 604,002 $ 603,914 $ 684,893 Schertz-Seguin Local Government Corporation Debt - Schertz Portion Year 2008 2009 2010 2011 2012 2013 1999 $ 156,526 $ 159,224 $ 158,972 $ - $ - $ 2001 1,171,033 1,168,124 1,167,409 1,166,341 1,164,963 1,165,674 - to 2041 2005 200,228 201,691 200,574 361,302 363,709 363,018 - to 2025 Total $1,527.787 $1,529.039 $1,526,955 $1,527.643 $1,528,672 $1,528.692 Schertz Emergency Medical Services Year 2008 2009 2010 2011 2012 2013 2007 $ 140,050 $ 135,238 $ 135,426 $ 140,414 Total $ 140.050 $ 135,238 $ 135,426 $ 140,414 $ $ Schertz Economic Development Corporation 4B Debt Year 2008 2009 2010 2011 2012 2013 1998 $ 378,914 $ 373,933 $ 375,673 $ 379,156 $ 382,016 $ 384,219 - to 2018 2006 111,834 111,834 2007 163,120 163,509 163,697 158,684 158,672 158,459 - to 2016 Total $ 653,868 $ 649,276 $ 539,369 $ 537,840 $ 540,688 $ 542,677 CAPITAL RECOVERY Year 2008 2009 2010 2011 2012 2013 2007 $ 486,640 $ 487,417 $ 484,793 $ 972,561 $ 487,342 $ 486,515 - to 2026 Total $ 486,640 $ 487,417 $ 484,793 $ 972,561 $ 487,342 $ 486,515 173 CITY OF SCHERTZ General Obligation Bonds, Series 1992 Street Improvements Amount issued: $620,000 Date Principal Coupon Interest Period Total Fiscal Total 12/1/2007 2,240.00 2,240.00 6/1/2008 70,000.00 6.400% 2,240.00 72,240.00 $ 74,480.00 $70,000.00 $4,480.00 $74,480.00 Paying Agent: The Sank of New Yark 174 CITY OF SCHERTZ Certificate of Obligation Bonds, Series 2001 Schertz Parkway Project Amount issued: $4,500,000 Date Principal Coupon Interest Period Total Fiscal Total 2/1/2008 180,000.00 5.000% 85,485.00 265,485.00 8/1/2008 80,985.00 80,985.00 $346,470.00 2/1/2009 190,000.00 4.100% 80,985.00 270,985.00 8/1/2009 77,090.00 77,090.00 $348,075.00 2/1/2010 200,000.00 4.200% 77,090.00 277,090.00 8/1/2010 72,890.00 72,890.00 $349,980.00 2/1/2011 210,000.00 4.250% 72,890.00 282,890.00 8/1/2011 68,427.50 68,427.50 $351,317.50 2/1/2012 225,000.00 4.400% 68,427.50 293,427.50 8/1/2012 63,477.50 63,4 77.50 $356,905.00 2/1/2013 235,000.00 4.500% 63,477.50 298,477.50 8/1/2013 58,190.00 58,190.00 $356,667.50 2/1/2014 250,000.00 4.600% 58,190.00 308,190.00 8/1/2014 52,440.00 52,440.00 $360,630.00 2/1/2015 260,000.00 4.700% 52,440.00 312,440.00 8/1/2015 46,330.00 46,330.00 $358,770.00 2/1/2016 275,000.00 4.800% 46,330.00 321,330.00 8/1/2016 39,730.00 39,730.00 $361,060.00 2/1/2017 290,000.00 4.900% 39,730.00 329,730.00 8/1/2017 32,625.00 32,625.00 $362,355.00 2/1/2018 300,000.00 5.000% 32,625.00 332,625.00 8/1/2018 25,125.00 25,125.00 $357,750.00 2/1/2019 320,000.00 5.000% 25,125.00 345,125.00 8/1/2019 17,125.00 17,125.00 $362,250.00 2/1/2020 335,000.00 5.000% 17,125.00 352,125.00 8/1/2020 8,750.00 8,750.00 $360,875.00 2/1/2021 350,000.00 5.000% 8,750.00 358,750.00 8/1/2021 0.00 $358,750.00 $ 3,620,000.00 $ 1,371 ,855.00 $ 4,991 ,855.00 Paying Agent: The Bank of New York 175 CITY OF SCHERTZ Combination Tax and Ltd Pledge Revenue Certificates of Obligation, Series 2003 Amount of Issue: $3,360,000 Date Principal Coupon Interest Period Total Fiscal Total 2/1/2008 165,000.00 2.750% 40,178.75 205,178.75 8/1/2008 37,910.00 37,910.00 $243,088.75 2/1/2009 170,000.00 3.000% 37,910.00 207,910.00 8/1/2009 35,360.00 35,360.00 $243,270.00 2/1/2010 180,000.00 3.600% 35,360.00 215,360.00 8/1/2010 32,120.00 32,120.00 $247,480.00 2/1/2011 190,000.00 3.600% 32,120.00 222,120.00 8/1/2011 28,700.00 28,700.00 $250,820.00 2/1/2012 200,000.00 3.600% 28,700.00 228,700.00 8/1/2012 25,100.00 25,100.00 $253,800.00 2/1/2013 210,000.00 3.650% 25,100.00 235,100.00 8/1/2013 21,267.50 21,267.50 $256,367.50 2/1/2014 220,000.00 3.550% 21,267.50 241,267.50 8/1/2014 17,362.50 17,362.50 $258,630.00 2/1/2015 225,000.00 3.600% 17,362.50 242,362.50 8/1/2015 13,312.50 13,312.50 $255,675.00 2/1/2016 225,000.00 3.700% 13,312.50 238,312.50 8/1/2016 9,150.00 9,150.00 $247,462.50 2/1/2017 225,000.00 3.800% 9,150.00 234,150.00 8/1/2017 4,875.00 4,875.00 $239,025.00 2/1/2018 250,000.00 3.900% 4,875.00 254,875.00 8/1/2018 $254,875.00 $ 2,260,000.00 $ 490,493.75 $ 2,750,493.75 Paying Agent: J.P. Morgan Chase Bank 176 CITY OF SCHERTZ Combination Tax and Ltd Pledge Revenue Certificates of Obligation, Series 2004 Amount of Issue: $ 7,750,000 Date Principal Coupon Interest Period Total Fiscal Total 2/1/2008 310,000.00 4.000% 156,068.13 466,068.13 8/1/2008 149,868.13 149,868.13 $615,936.26 2/1/2009 335,000.00 4.000% 149,868.13 484,868.13 8/1/2009 143,168.13 143,168.13 $628,036.26 2/1/2010 325,000.00 4.375% 143,168.13 468,168.13 8/1/2010 136,058.75 136,058.75 $604,226.88 2/1/2011 325,000.00 4.375% 136,058.75 461,058.75 8/1/2011 128,949.38 128,949.38 $590,008.13 2/1/2012 315,000.00 4.375% 128,949.38 443,949.38 8/1/2012 122,058.75 122,058.75 $566,008.13 2/1/2013 325,000.00 4.250% 122,058.75 447,058.75 8/1/2013 115,152.50 115,152.50 $562,211.25 2/1/2014 325,000.00 4.000% 115,152.50 440,152.50 8/1/2014 108,652.50 108,652.50 $548,805.00 2/1/2015 325,000.00 4.100% 108,652.50 433,652.50 8/1/2015 101,990.00 101,990.00 $535,642.50 2/1/2016 325,000.00 4.200% 101,990.00 426,990.00 8/1/2016 95,165.00 95,165.00 $522,155.00 2/1/2017 350,000.00 4.300% 95,165.00 445,165.00 8/1/2017 87,640.00 87,640.00 $532,805.00 2/1/2018 350,000.00 4.375% 87,640.00 437,640.00 8/1/2018 79,983.75 79,983.75 $517,623.75 2/1/2019 460,000.00 4.400% 79,983.75 539,983.75 8/1/2019 69,863.75 69,863.75 $609,847.50 2/1/2020 460,000.00 4.500% 69,863.75 529,863.75 8/1/2020 59,513.75 59,513.75 $589,~77 .50 2/1/2021 480,000.00 4.550% 59,513.75 539,513.75 8/1/2021 48,593.75 48,593.75 $588,107.50 2/1/2022 675,000.00 4.650% 48,593.75 723,593.75 8/1/2022 32,900.00 32,900.00 $756,493.75 2/1/2023 700,000.00 4.700% 32,900.00 732,900.00 8/1/2023 16,450.00 16,450.00 $749,350.00 2/1/2024 700,000.00 4.700% 16,450.00 716,450.00 9/30/2024 $716,450.00 $ 7,085,000.00 $ 3,148,084.41 $ 10,233,084.41 177 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 Coupon Interest Period Total Fiscal Total 2/1/2008 230,000.00 6.375% 78,122.50 308,122.50 8/1/2008 70,791.25 70,791.25 $378,913.75 2/1/2009 240,000.00 6.375% 70,791.25 310,791.25 8/1/2009 63,141.25 63,141 .25 $373,932.50 2/1/2010 255,000.00 4.400% 63,141.25 318,141.25 8/1/2010 57,531.25 57,531.25 $375,672.50 2/1/2011 270,000.00 4.375% 57,531.25 327,531.25 8/1/2011 51,625.00 51,625.00 $379,156.25 2/1/2012 285,000.00 4.375% 51,625.00 336,625.00 8/1/2012 45,390.63 45,390.63 $382,015.63 2/1/2013 300,000.00 4.375% 45,390.63 345,390.63 8/1/2013 38,828.13 38,828.13 $384,218.76 2/1/2014 315,000.00 4.375% 38,828.13 353,828.13 8/1/2014 31,937.50 31,937.50 $385,765.63 2/1/2015 335,000.00 4.375% 31,937.50 366,937.50 8/1/2015 24,609.38 24,609.38 $391,546.88 2/1/2016 355,000.00 4.375% 24,609.38 379,609.38 8/1/2016 16,843.75 16,843.75 $396,453.13 2/1/2017 375,000.00 4.375% 16,843.75 391,843.75 8/1/2017 8,640.63 8,640.63 $400,484.38 2/1/2018 395,000.00 4.375% 8,640.63 403,640.63 8/1/2018 $403,640.63 $ 3,355,000.00 $ 896,800.04 $ 4,251 ,800.04 Paying Agent: J.P. Morgan Chase Bank 178 CITY OF SCHERTZ Utility System Revenue & Refunding Bonds, Series 2001 Amount Issued: $5,550,000 Date Principal Coupon Interest Period Total Fiscal Total 3/1/2008 87,775.00 87,775.00 9/1/2008 295,000.00 4.125% 87,775.00 382,775.00 $ 470,550.00 3/1/2009 81,690.63 81,690.63 9/1/2009 305,000.00 5.000% 81,690.63 386,690.63 $ 468,381.26 3/1/2010 74,065.63 74,065.63 9/1/2010 220,000.00 4.300% 74,065.63 294,065.63 $ 368,131.26 3/1/2011 69,335.63 69,335.63 9/1/2011 . 230,000.00 4.400% 69,335.63 299,335.63 $ 368,671.26 3/1/2012 64,275.63 64,275.63 9/1/2012 240,000.00 4.550% 64,275.63 304,275.63 $ 368,551.26 3/1/2013 58,815.63 58,815.63 9/1/2013 250,000.00 4.650% 58,815.63 308,815.63 $ 367,631.26 3/1/2014 53,003.13 53,003.13 9/1/2014 265,000.00 4.750% 53,003.13 318,003.13 $ 371,006.26 3/1/2015 46,709.38 46,709.38 9/1/2015 280,000.00 4.850% 46,709.38 326,709.38 $ 373,418.76 3/1/2016 39,919.38 39,919.38 9/1/2016 290,000.00 5.000% 39,919.38 329,919.38 $ 369,838.76 3/1/2017 32,669.38 32,669.38 9/1/2017 295,000.00 5.000% 32,669.38 327,669.38 $ 360,338.76 3/1/2018 25,294.38 25,294.38 9/1/2018 230,000.00 5.000% 25,294.38 255,294.38 $ 280,588.76 3/1/2019 19,544.38 19,544.38 9/1/2019 240,000.00 5.100% 19,544.38 259,544.38 $ 279,088.76 3/1/2020 13,424.38 13,424.38 9/1/2020 255,000.00 5.125% 13,424.38 268,424.38 $ 281,848.76 3/1/2021 6,890.00 6,890.00 9/1/2021 265,000.00 5.200% 6,890.00 271,890.00 $ 278,780.00 $ 3,660,000.00 $1,346,825.12 $ 5,006,825.12 Paying Agent: The Sank of New York 179 The Schertz/Seguin Local Government Corporation Contract Revenue Bonds Paid 1/2 Schertz, 1/2 Seguin Fiscal Year Refunding Refunding Schertz Debt Ending 9/30 Series 1999 Series 2001 Series 2005 Series 2007 Total Payment 2008 313,053 815,614 400,455 1,863,038 3,392,159 $1,696,080 2009 318,447 809,798 403,383 1,860,738 3,392,365 $1,696,183 2010 317,944 808,366 401,149 1,863,138 3,390,596 $1,695,298 2011 806,230 722,605 1,860,238 3,389,073 $1,694,536 2012 520,000 727,418 2,141,338 3,388,755 $1,694,378 2013 520,000 726,036 2,141,138 3,387,174 $1,693,587 2014 520,000 728,436 2,140,138 3,388,574 $1,694,287 2015 520,000 734,936 2,138,338 3,393,274 $1,696,637 2016 520,000 735,536 2,135,738 3,391,274 $1,695,637 2017 520,000 740,236 2,127,438 3,387,674 $1,693,837 2018 520,000 739,036 2,133,238 3,392,274 $1,696,137 2019 520,000 737,036 2,128,038 3,385,074 $1,692,537 2020 520,000 738,844 2,131,419 3,390,263 $1,695,131 2021 520,000 739,194 2,118,044 3,377,238 $1,688,619 2022 520,000 738,201 2,123,188 3,381,389 $1,690,694 2023 520,000 740,735 2,121,950 3,382,685 $1,691,343 2024 520,000 741,661 2,124,331 3,385,993 $1,692,996 2025 520,000 740,859 2,125,225 3,386,084 $1,693,042 2026 520,000 2,912,525 3,432,525 $1,716,263 2027 520,000 2,903,438 3,423,438 $1,711,719 2028 520,000 2,908,900 3,428,900 $1,714,450 2029 520,000 2,910,538 3,430,538 $1,715,269 2030 520,000 2,903,463 3,423,463 $1,711,731 2031 2;268,330 1,167,500 3,435,830 $1,717,915 2032 2,272,390 1,169,113 3,441,503 $1,720,751 2033 2,271,250 1,170,050 3,441,300 $1,720,650 2034 2,269,780 1,170,313 3,440,093 $1,720,046 2035 2,272,590 1,169,900 3,442,490 $1,721,245 2036 3,426,838 3,426,838 $1,713,419 2037 3,428,650 3,428,650 $1,714,325 2038 3,434,613 3,434,613 $1,717,306 2039 3,434,500 3,434,500 $1,717,250 2040 3,433,200 3,433,200 $1,716,600 2041 3,430,488 3,430,488 $1,715,244 $949,444 $24,474,348 $12,235,758 $78,250,731 $115,910,280 180 CITY OF SCHERTZ CAP MARK (GMAC) Commercial Mortgage Schaefer Road Rural Water 5% Interest Rate Date Principal Interest Period Total Fiscal Total 2/1/2008 7,000.00 1,050.00 8,050.00 $ 8,050.00 2/1/2009 7,000.00 700.00 7,700.00 $ 7,700.00 2/1/2010 7,000.00 350.00 7,350.00 $ 7,350.00 $ 21,000.00 $ 2,100.00 $ 23,100.00 181 CITY OF SCHERTZ Certifcates of Obligation- Series 2005 Date Principal Coupon Interest Period Total Fiscal Total 2/1/2008 120,000.00 3.000% 59,896.88 179,896.88 8/1/2008 58,096.88 58,096.88 $ 237,993.76 2/1/2009 120,000.00 3.375% 58,096.88 178,096.88 8/1/2009 56,071.88 56,071.88 $ 234,168.76 2/1/2010 125,000.00 3.500% 56,071.88 181,071.88 8/1/2010 53,884.38 53,884.38 $ 234,956.26 2/1/2011 130,000.00 3.750% 53,884.38 183,884.38 8/1/2011 51,446.88 51,446.88 $ 235,331.26 2/1/2012 135,000.00 3.750% 51,446.88 186,446.88 8/1/2012 48,915.63 48,915.63 $ 235,362.51 2/1/2013 140,000.00 4.000% 48,915.63 188,915.63 8/1/2013 46,115.63 46,115.63 $ 235,031.26 2/1/2014 145,000.00 4.000% 46,115.63 191,115.63 8/1/2014 43,215.63 43,215.63 $ 234,331.26 2/1/2015 155,000.00 4.000% 43,215.63 198,215.63 8/1/2015 40,115.63 40,115.63 $ 238,331.26 2/1/2016 160,000.00 4.000% 40,115.63 200,115.63 8/1/2016 36,915.63 36,915.63 $ 237,031.26 2/1/2017 165,000.00 4.000% 36,915.63 201,915.63 8/1/2017 33,615.63 33,615.63 $ 235,531.26 2/1/2018 170,000.00 4.000% 33,615.63 203,615.63 8/1/2018 30,215.63 30,215.63 $ 233,831.26 2/1/2019 180,000.00 4.000% 30,215.63 210,215.63 8/1/2019 26,615.63 26,615.63 $ 236,831.26 2/1/2020 185,000.00 4.125% 26,615.63 211,615.63 8/1/2020 22,800.00 22,800.00 $ 234,415.63 2/1/2021 195,000.00 4.200% 22,800.00 217,800.00 8/1/2021 18,705.00 18,705.00 $ 236,505.00 2/1/2022 205,000.00 4.350% 18,705.00 223,705.00 8/1/2022 14,246.25 14,246.25 $ 237,951.25 2/1/2023 210,000.00 4.350% 14,246.25 224,246.25 8/1/2023 9,678.75 9,678.75 $ 233,925.00 2/1/2024 220,000.00 4.350% 9,678.75 229,678.75 8/1/2024 4,893.75 4,893.75 $ 234,572.50 2/1/2025 225,000.00 4.350% 4,893.75 229,893.75 9/30/2005 $ 229,893.75 2,985,000.00 1,250,994.50 4,235,994.50 182 CITY OF SCHERTZ $15,000,000 Certifcates of Obligation Bonds, Series 2006 Date Principal Coupon Interest Period Total Fiscal Total 2/1/2008 570,000.00 4.000% 340,890.63 910,890.63 8/1/2008 329,490.63 329,490.63 $ 1,240,381.26 2/1/2009 100,000.00 4.000% 329,490.63 429,490.63 8/1/2009 327,490.63 327,490.63 $ 756,981.26 2/1/2010 100,000.00 4.000% 327,490.63 427,490.63 8/1/2010 325,490.63 325,490.63 $ 752,981.26 2/1/2011 325,490.63 325,490.63 8/1/2011 325,490.63 325,490.63 $ 650,981.26 2/1/2012 100,000.00 4.000% 325,490.63 425,490.63 8/1/2012 323,490.63 323,490.63 $ 748,981.26 2/1/2013 200,000.00 4.000% 323,490.63 523,490.63 8/1/2013 319,490.63 319,490.63 $ 842,981.26 2/1/2014 200,000.00 4.000% 319,490.63 519,490.63 8/1/2014 315,490.63 315,490.63 $ 834,981.26 2/1/2015 350,000.00 4.000% 315,490.63 665,490.63 8/1/2015 308,490.63 308,490.63 $ 973,981.26 2/1/2016 400,000.00 4.000% 308,490.63 708,490.63 8/1/2016 300,490.63 300,490.63 $ 1,008,981.26 2/1/2017 425,000.00 4.125% 300,490.63 725,490.63 8/1/2017 291,725.00 291,725.00 $ 1,017,215.63 2/1/2018 475,000.00 4.200% 291,725.00 766,725.00 8/1/2018 281,750.00 281,750.00 $ 1,048,475.00 2/1/2019 655,000.00 4.300% 281,750.00 936,750.00 8/1/2019 267,667.50 267,667.50 $ 1,204,417.50 2/1/2020 685,000.00 4.375% 267,667.50 952,667.50 8/1/2020 252,683.13 252,683.13 $ 1,205,350.63 2/1/2021 715,000.00 4.400% 252,683.13 967,683.13 8/1/2021 236,953.13 236,953.13 $ 1,204,636.26 2/1/2022 750,000.00 5.250% 236,953.13 986,953.13 8/1/2022 217,265.63 217,265.63 $ 1,204,218.76 2/1/2023 790,000.00 5.250% 217,265.63 1,007,265.63 8/1/2023 196,528.13 196,528.13 $ 1,203,793.76 2/1/2024 835,000.00 5.250% 196,528.13 1,031,528.13 8/1/2024 174,609.38 174,609.38 $ 1,206,137.51 2/1/2025 880,000.00 5.250% 174,609.38 1,054,609.38 8/1/2025 151,509.38 151,509.38 $ 1,206,118.76 2/1/2026 925.000.00 5.250% 151,509.38 1,076,509.38 8/1/2026 127,228.13 127,228.13 $ 1,203,737.51 2/1/2027 975,000.00 5.250% 127,228.13 1,102,228.13 8/1/2027 101,634.38 101,634.38 $ 1,203,862.51 2/1/2028 1,025,000.00 4.625% 101,634.38 1,126,634.38 8/1/2028 77,931.25 77,931.25 $ 1,204,565.63 2/1/2029 1,070,000.00 4.625% 77,931.25 1,147,931.25 8/1/2029 53,187.50 53,187.50 $ 1,201,118.75 2/1/2030 1,125,000.00 4.625% 53,187.50 1,178,187.50 8/1/2030 27,171.88 27,171.88 $ 1,205,359.38 2/1/2031 1,175,000.00 4.625% 27,171.88 1,202,171.88 9/30/2031 $ 1,202,171.88 14,525,000.00 11,007,410.81 25,532,410.81 25,532,410.81 183 CITY OF SCHERTZ $9,940,000 Certifcates of Obligation Bonds, Series 2007 Date Principal Coupon Interest Debt Service Fiscal Total 2/1/2008 190,575.25 190,575.25 8/1/2008 595,000 4.010% 190,575.25 785,575.25 976,150.50 2/1/2009 178,645.50 178,645.50 8/1/2009 615,000 4.010% 178,645.50 793,645.50 972,291.00 2/1/2010 166,314.75 166,314.75 8/1/2010 640,000 4.010% 166,314.75 806,314.75 972,629.50 2/1/2011 153,482.75 153,482.75 8/1/2011 670,000 4.010% 153,482.75 823,482.75 976,965.50 2/1/2012 140,049.25 140,049.25 8/1/2012 555,000 4.010% 140,049.25 695,049.25 835,098.50 2/1/2013 128,921.50 128,921.50 8/1/2013 580,000 4.010% 128,921.50 708,921.50 837,843.00 2/1/2014 117,292.50 117,292.50 8/1/2014 605,000 4.010% 117,292.50 722,292.50 839,585.00 2/1/2015 105,162.25 105,162.25 8/1/2015 630,000 4.010% 105,162.25 735,162.25 840,324.50 2/1/2016 92,530.75 92,530.75 8/1/2016 655,000 4.010% 92,530.75 747,530.75 840,061.50 2/1/2017 79,398.00 79,398.00 8/1/2017 330,000 4.010% 79,398.00 409,398.00 488,796.00 2/1/2018 72,781.50 72,781.50 8/1/2018 340,000 4.010% 72,781.50 412,781.50 485,563.00 2/1/2019 65,964.50 65,964.50 8/1/2019 355,000 4.010% 65,964.50 420,964.50 486,929.00 2/1/2020 58,846.75 58,846.75 8/1/2020 370,000 4.010% 58,846.75 428,846.75 487,693.50 2/1/2021 51,428.25 51,428.25 8/1/2021 385,000 4.010% 51,428.25 436,428.25 487,856.50 2/1/2022 43,709.00 43,709.00 8/1/2022 400,000 4.010% 43,709.00 443,709.00 487,418.00 2/1/2023 35,689.00 35,689.00 8/1/2023 420,000 4.010% 35,689.00 455,689.00 491,378.00 2/1/2024 27,268.00 27,268.00 8/1/2024 435,000 4.010% 27,268.00 462,268.00 489,536.00 2/1/2025 18,546.25 18,546.25 8/1/2025 455,000 4.010% 18,546.25 473,546.25 492,092.50 2/1/2026 9,423.50 9,423.50 8/1/2026 470,000 4.01 0% 9,423.50 479,423.50 488,847.00 9,505,000 3,472,059 12,977,059 12,977,059 184 CITY OF SCHERTZ $6,000,000 Certifcates of Obligation Bonds, Series 2007 Date Principal Coupon Interest Period Total Fiscal Total 2/1/2008 190,000.00 4.070% 84,113.33 274,113.33 8/1/2008 118,233.50 118,233.50 $ 392,346.83 2/1/2009 285,000.00 4.070% 118,233.50 403,233.50 8/1/2009 112,433.75 112,433.75 $ 515,667.25 2/1/2010 250,000.00 4.070% 112,433.75 362,433.75 8/1/2010 107,346.25 107,346.25 $ 469,780.00 2/1/2011 275,000.00 4.070% 107,346.25 382,346.25 8/1/2011 101,750.00 101,750.00 $ 484,096.25 2/1/2012 225,000.00 4.070% 101,750.00 326,750.00 8/1/2012 97,171.25 97,171.25 $ 423,921.25 2/1/2013 235,000.00 4.070% 97,171.25 332,171.25 8/1/2013 92,389.00 92,389.00 $ 424,560.25 2/1/2014 245,000.00 4.070% 92,389.00 337,389.00 8/1/2014 87,403.25 87,403.25 $ 424,792.25 2/1/2015 255,000.00 4.070% 87,403.25 342,403.25 8/1/2015 82,214.00 82,214.00 $ 424,617.25 2/1/2016 265,000.00 4.070% 82,214.00 347,214.00 8/1/2016 76,821.25 76,821.25 $ 424,035.25 2/1/2017 280,000.00 4.070% 76,821.25 356,821.25 8/1/2017 71,123.25 71,123.25 $ 427,944.50 2/1/2018 290,000.00 4.070% 71,123.25 361,123.25 8/1/2018 65,221.75 65,221.75 $ 426,345.00 2/1/2019 300,000.00 4.070% 65,221.75 365,221.75 8/1/2019 59,116.75 59,116.75 $ 424,338.50 2/1/2020 315,000.00 4.070% 59,116.75 374,116.75 8/1/2020 52,706.50 52,706.50 $ 426,823.25 2/1/2021 325,000.00 4.070% 52,706.50 377,706.50 8/1/2021 46,092.75 46,092.75 $ 423,799.25 2/1/2022 340,000.00 4.070% 46,092.75 386,092.75 8/1/2022 39,173.75 39,173.75 $ 425,266.50 2/1/2023 355,000.00 4.070% 39,173.75 394,173.75 8/1/2023 31,949.50 31,949.50 $ 426,123.25 2/1/2024 370,000.00 4.070% 31,949.50 401,949.50 8/1/2024 24,420.00 24,420.00 $ 426,369.50 2/1/2025 385,000.00 4.070% 24,420.00 409,420.00 8/1/2025 16,585.25 16,585.25 $ 426,005.25 2/1/2026 400,000.00 4.070% 16,585.25 416,585.25 8/1/2026 8,445.25 8,445.25 $ 425,030.50 2/1/2027 415,000.00 4.070% 8,445.25 423,445.25 9/30/2027 $ 423,445.25 6,000,000.00 2,665,307.33 8,665,307.33 8,665,307.33 185