Loading...
O-1985-9-01ORDINANCE NO. 1985-9-01 ' AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF ALLEN, COLLIN COUNTY, TEXAS, ADOPTING A BUDGET FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2001, AND ENDING SEPTEMBER 30,2002; APPROPRIATING THE VARIOUS AMOUNTS REQUIRED FOR SUCH BUDGET; PROVIDING FOR RECORDING OF THE ORDINANCE; PROVIDING FOR A REPEALING CLAUSE; PROVIDING FOR A SEVERABILITY CLAUSE; AND PROVIDING FOR AN EFFECTIVE DATE. WHEREAS, the City Manager of the City of Allen, Collin County, Texas, has submitted to the City Council a proposed budget of the revenues and expenditures of conducting the affairs of the City and providing a complete financial plan for 2001-2002; and WHEREAS, the City Council has received the City Manager's proposed budget, a copy of which proposed budget and all supporting schedules have been filed with the City Secretary of the City of Allen, Collin County, Texas; and, WHEREAS, the City Council has conducted the necessary public hearings as required by law. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF ALLEN, COLLIN COUNTY, TEXAS, THAT: SECTION 1: The proposed budget of the revenues of the City of Allen, Collin County, Texas, and the expenditures of conducting the affairs of the City, providing a complete financial plan for the ensuing fiscal year beginning October 1, 2001, and ending September 30, 2002, as submitted to the City Council by the City Manager, be, and the same is hereby, in all things adopted and approved as the budget of all current revenues and expenditures of the City for the fiscal year beginning October 1, 2001, and ending September 30, 2002. SECTION 2. The sum of $73,147,292 is hereby appropriated for the payment of the expenditures established in the approved budget, attached hereto as Exhibit "A" and made part hereof for all purposes. SECTION 3. The City Council reserves the authority to transfer appropriations budgeted from one account or activity to another within any individual activity of the City and to transfer appropriations from designated appropriations to any individual department or activity. That all transfers of appropriations budgeted from one account or activity to another within any individual activity for the fiscal year 2000-01 are hereby ratified and the Budget Ordinance fm 2000-01, heretofore enacted by the City Council, be, and the same is hereby, amended to reflect revenues of $59,672,644 and expenditures of $55,819,518. SECTION 4. All notices and public hearings required by law have been duly completed. That the City Secretary is directed to provide a certified copy of the budget to the County Clerk of Collin County for recording after final passage hereof. SECTION 5. Should any word, sentence, paragraph, subdivision, clause, phrase or section of this ordinance, be adjudged or held to be void or unconstitutional, the same shall not affect the validity of the remaining portions of said ordinance, as amended hereby, which shall remain in full fome and effect. ' SECTION 6. All ordinances of the City of Allen, Collin County, Texas, in conflict with the provisions of this ordinance be, and the same are hereby, repealed; provided, however that all other provisions of said ordinances not in conflict with the provisions of this ordinance shall remain in full force and effect. SECTION 7. This Ordinance shall take effect immediately from and after its passage as the law and charter ' in such cases provide DULY PASSED AND APPROVED BY THE CITY COUNCIL OF THE CITY OF ALLEN, COLLIN COUNTY, TEXAS, ON THIS THE 6re DAY OF SEPTEMBER, 1001. APPROVED: Stephen MAYOR APPROVED AS TO FORM: ATTEST: ��� ��/,� Peter G. Smith, ATTORNEY J yJ y M�C/AAE, CITY SECRETARY/AAE, CITY SECRETARY Ordinance No. 1985-9-01. Page 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 "TARY OFFICIAL FI CITY OF ALLEN, TEXAS ANNUAL BUDGET FISCAL YEAR 2001 - 2002 CITY OF ALLEN Approved by the City Council September 6, 2001 Council Members Mayor Stephen Terrell Mayor Pro Tem, Place 6 Melissa Owen Place 1 Council Member Debbie Stout Place 2 Council Member Richard Buchanan Place 3 Council Member Bill Petty Place 4 Council Member Susan Bartlemay Place 5 Council Member Kenneth Fulk Management Staff City Manager Peter H. Vargas Finance Director Linda Vaughan E COPY m GOVERNMENT FINANCE OFFICERS ASSOCIATION Distinguished Budget Presentation Award PRESENTED TO City of Allen Texas For the Fiscal Year Beginning October 1, 2000 odi du --r President Executive Director The Government Finance Officers Association of the United States and Canada (GFOA) presented an award for Distinguished Budget Presentation to the City of Allen, Texas for its annual budget for the fiscal year beginning October 1, 2000. In order to receive this award, a governmental unit must publish a budget document that meets program criteria as a policy document, as an operations guide, as a financial plan, and as a communications device. The City of Allen has received the award for two consecutive years. The award is valid for a period of one year only. We believe our current budget continues to conform to program requirements, and we are submitting it to GFOA to determine its eligibility for another award. C I T Y O F A L L E N Our Mission To achieve excellence in managing development of the community and in providing city services so that conditions of living and public confidence are continually enhanced. Our Pledge to fulfill our mission in a way that. RESPECTS AND VALUES CITIZENS AND EMPLOYEES 43 NURTURES COMMUNITY INVOLVEMENT 43 DEMONSTRATES THE HIGHEST ETHICAL STANDARDS 17 IMPROVES EFFECTIVE COMMUNICATIONS 49 MODELS SAFETY 49 EXEMPLIFIES PROFESSIONALISM 4 PROMOTES TEAMWORK 13 DEMONSTRATES STEWARDSHIP $ REWARDS MERITORIOUS PERFORMANCE t.' MAXIMIZES THE USE OF TECHNOLOGY 43 ENCOURAGES FLEXIBILITY, INNOVATION AND CREATIVITY CJ UTILIZES EFFECTIVE PLANNING 43 PROVIDES OPPORTUNITIES FOR PERSONAL AND PROFESSIONAL GROWTH FOR ALL PERSONNEL IP AND ASSIGNS APPROPRIATE RESPONSIBILITY AND ACCOUNTABILITY. CITY OF ALLEN TABLE OF CONTENTS BUDGET OVERVIEW Letter from City Manager GENERALFUND Revenue and Expenditure Summary ........................................................................... 7 Revenue and Expenditures by Function Charts............................................................. 8 Revenues.............................................................................................................. 8 TaxStructure ......................................................................................................... 11 Assumptions Used for Projecting 2001-2002 Revenues.....................................................12 Expenditure by Function.............................................................................................13 Expenditure Classification ..........................................................................................14 ThreeYear Projection................................................................................................15 CitySecretary ............................................................................................................................... 18 MunicipalCourt ............................................................................................................................20 CityAdministration.......................................................................................................................24 ITDepartment.........................................................................................................28 Personnel.....................................................................................................................................32 InternalServices..................................................................................................... 36 Police...........................................................................................................................................40 Parks& Recreation......................................................................................................................45 Library..........................................................................................................................................50 Fire...............................................................................................................................................54 TABLE OF CONTENTS continued... Building and Code Compliance....................................................................................................58 Planningand Development..........................................................................................................62 CommunityServices....................................................................................................................66 cu.nnoe-------_____---------------------- ..................................................................77 Engineering................................................................ WATER AND SEWER FUND Revenue and Expenditure Summary ......................................... Revenue and Expenditures by Function Charts ........................... RevenueDetail.................................................................... Expenditure Classifications..................................................... Waterand Sewer................................................................. UtilityCollections.................................................................. MISCELLANEOUS FUNDS Solid Waste Fund ........................................ Drainage Fund ............................................ Parks & Recreation Enterprise Fund ................ Aquatics Enterprise Fund .............................. Development Fees Fund ............................... Economic Development Corporation Fund ........ Community Development Corporation .............. Capital Improvement Fund ........................... Hotel Occupancy Tax Fund ........................... Vehicle Replacement Fund ...........................� Self Insurance Fund ..................................... COAST Fund ............................................. FIVE YEAR CAPITAL IMPROVEMENT PROGRAM DEMOGRAPHICS ..................................... .....................85 ..........................88 ..... 94 153 ........................................ 157 GLOSSARY......................................................................................................... 161 Budget Overview ' October 1, 2001 CITY OF ALLEN ' Honorable Mayor and Members of the City Council City of Allen Allen, Texas 75013 Dear Mayor and City Council Members: ' I am pleased to present to you the 2001-02 City of Allen Annual Budget for Municipal Services. This budget represents the expected revenues and planned expenditures for ' the City's fiscal year from October 1, 2001 to September 30, 2002. It has been prepared in conformance to the requirements of the City Charter, Article IV, City financial policies, and state law. After the public hearings, the proposed 2001-02 ' budget and tax rate will be considered by the City Council on September 6, 2001. ' Property Values According to information received from the Central Appraisal District, total assessed ' property value for 2001-02 equals $3.4 billion, which equates to an increase of $595.4 million (20%) from the preceding year. Of the total assessed valuation, $327.3 million is attributed to new property coming on-line, and $602.9 million represents increased ' property values on existing property. As displayed in the graph below assessed property values have increased an average of 22% over the past five years. This increase in property values afforded the City Council the opportunity to reduce the ' property tax rate while at the same time continuing to offer improved services to the citizens of Allen. ' Assessed Property Valuation (in Billions) 1997 INS 1999 2000 2001 ONE ALLEN CIVIC PLAZA - ALLEN, TEXAS 75013 9721727-0100 - FAX 9721727-0165 EMAIL: m0ci.allm.m.w Budget Transmittal Letter Fiscal Year 2001-02 Page ii Proposed Tax Rate The total combined budget for 2001-02 equals $73,147,292 and was accomplished with a $0.001 cent property tax rate decrease from $0.564 to $0.563 per $100 of assessed property valuation. The total budget represents an increase in revenues of $13,010,147 or 24% over the 2000-01 fiscal year budget. Total budget expenditures are estimated to increase $19,719,745 or 37% from the 2000-01 fiscal year budget. The increases in expenditures included in the FY 2001-02 Budget are the direct result of a combination of the demands related to growth and the increasing need for infrastructure maintenance, increasing demand for enhanced city services, and the ability for the City to retain valued employees and compete for job applicants. The proposed ad valorem tax rate for 2001-02 is $0.563 per $100 of assessed valuation. Of the total tax rate, $0.357 is dedicated to operations and maintenance (O&M) in the General Fund, and $0.206 is dedicated to general obligation debt service. This is the ninth straight year the City Council has reduced the tax rate. The portion of the tax rate contributed to debt service is 37% of the overall tax rate and is consistent with the Citys policy to maintain the debt service portion below 40%. History of Tax Rate Fiscal Year O&M Rate Debt Service Rate Total Tax Rate 2001-2002 $ 0.357 $ 0.206 $ 0.563 2000-2001 $ 0.349 $ 0.215 $ 0.564 1999-2000 $ 0.346 $ 0.228 $ 0.574 1998-1999 $ 0.350 $ 0.225 $ 0.575 1997-1998 $ 0.349 $ 0.231 Budget Highlights This year's budget planning process involved incorporating the goals and strategies identified by the City Council's three-year Strategic Plan to provide for the community's highest priority needs. The goal statements developed by the City Council are as follows: A total of 51 additional full-time equivalent positions are included for 2001-02 budget. Of this total, 35 are budgeted in the General Fund and the remaining 16 are included in the enterprise funds. As always, personnel increases have been held to a minimum, but as the City grows so do the demands on operations and maintenance. These new employees are directly related to operation increases due to growth, program enhancements, or new programs. The chart below illustrates the relationship between the City of Allen's population and the City's workforce since Fiscal Year 1997-98. The number of employees per thousand citizens has remained fairy steady while the population has increased 44% during this time period. Employee per Thousand Citizens 1998 1999 2000 2001 2002 Budget Transmittal Letter ' Fiscal Year 2001-02 Page iii 1. Enhance neighborhood livability and safety. ' 2. Cultivate alliances and partnerships with agencies and governmental units that affect Allen. 3. Continue to provide first-rate emergency services. ' 4. Manage growth and development to preserve Allen's character. 5. Improve regional mobility through transportation initiatives. 6. Promote the continued development of recreational opportunities. ' 7. Systematically invest in community infrastructure. 8. Achieve operational excellence in City government services. ' 9. Signify City of Allen identity through beautification efforts. 10. Ensure good fiscal management. Staffing Levels A total of 51 additional full-time equivalent positions are included for 2001-02 budget. Of this total, 35 are budgeted in the General Fund and the remaining 16 are included in the enterprise funds. As always, personnel increases have been held to a minimum, but as the City grows so do the demands on operations and maintenance. These new employees are directly related to operation increases due to growth, program enhancements, or new programs. The chart below illustrates the relationship between the City of Allen's population and the City's workforce since Fiscal Year 1997-98. The number of employees per thousand citizens has remained fairy steady while the population has increased 44% during this time period. Employee per Thousand Citizens 1998 1999 2000 2001 2002 Budget Transmittal Letter Fiscal Year 2001-02 Page iv General Fund The General Fund is used to account for expenditures of traditional government services, such as public safety, parks and recreation, library, planning, community services, engineering and building and code inspections. General Fund revenue is generated from ad valorem property taxes, one -cent sales tax, and a variety of fees and services. General fund revenues and budget transfers total $28,496,797 for the 2001- 02 fiscal year budget, an increase of 13% from the amended 2000-01 budget. Of this total, the projection for sales tax revenues is based on an increase of 15% from the amended fiscal year 2000-01 to the fiscal year 2001-02 budget. These revenue estimates are conservative considering the anticipated revenue for fiscal year 2001-02 is projected to be 20% higher than the original 2000-01 budget projections. General Fund expenditures are estimated to increase 14% from the 2000-01 amended budget, which is consistent with the projected increase in revenues. The increase in expenditures is primarily due to service and program enhancements directly related to the continued increase in population through either additional staff or increases in operations to ensure service levels continue to improve. A total of 35 new full time equivalent positions are included in the 2001-02 General Fund. Of this total, 18 are public safety related (13 -police and 5 -fire). A career development program has been established in both the Police and Fire Departments, resulting in the reclassification of 12 Firefighter/Paramedic positions to a new classification Apparatus Operator, the creation of a Battalion Chief position to manage the day-to-day operations of the fire stations, and the formalizing the Field Training Officer (FTO) assignment with nine Firefighters fulfilling the FTO function. The career ladder developed in the Police Department will result in the creation of a Senior Police Officer classification and a new Corporal rank creating career advancement opportunities for the Police Officers. It is anticipated that subsequent years will address similar career development opportunities for the other general fund positions. The following highlights some of the new programs and personnel included in the 2001- 02 General Fund: • In response to the growth in the community, additional staffing in the Police Department includes one additional Sergeant position and nine new Police Officers, a new position of Communications Technician to meet ideal staffing levels by allowing for three per shift, and two new Jailer positions to improve in monitoring jail activity. 1 1 1 1 1 1 Budget Transmittal Letter Fiscal Year 2001-02 Page v In addition to the career development program established in the Fire Department, there is the need to create four new Firefighter/Paramedic positions to ensure adequate staffing levels continue to meet the increased demand of the growing population. • To respond to the City Council's goal of continuing City beautification efforts the Parks and Recreation Department will enhance the median maintenance program ($24,000) and undertake entryway renovations to some of the aging neighborhoods in Allen ($20,000). In order to complete these new programs and respond to the maintenance of existing and new properties a crew leader, a chemical technician and four maintenance workers positions are included in the 2001-02 budget as mid- year additions. • The Building and Codes Department has been directly impacted by growth and anticipates 1800 single family permits for fiscal year 2001-02. Two additional Building Inspector positions, one hired at mid -year, will allow the City to reduce the number of inspections per day from 30-35 to 16-19 inspections per employee. This is consistent with the industry standard of 16-18 inspections per Inspector. • In response to growth and to ensure the City continues to meets the beautification goals identified in the Strategic Plan, an additional Code Enforcement Officer position has been included in the budget. With an additional Code Enforcement Officer position the City will meet the industry standard of one Code Enforcement Officer per 15,000 population. • A Senior Signal Technician and a Street Signs and Markings Technician have been added to dedicate a three member crew to signal and sign maintenance for both new development and maintenance of signs and markings in Allen's aging neighborhoods. These new positions should ensure the City meets the goal of systematically investing in community infrastructure. • The new position of Programmer Analyst has been created, and will be filled at mid- year, to focus primarily on e -government initiatives to improve customer service by offering on-line payments for city services. The Programmer Analyst will also address the need to customize some of the City's software applications. • The Municipal Court will realize two additional positions as a result of increased population and workload from an increase in the number of citations being issued. • The reclassification of one Library Clerk and from part-time to full-time and additional hours for a part-time Librarian will assist the Library in enhancing the library services provided to citizens. Budget Transmittal Letter Fiscal Year 2001-02 Page vi • In response to the City Council's goal to improve communications to residents included is an additional $12,000 to enhance the Annual Report publication. Also, the reclassification of the Video Technician from part-time to full-time will allow staff to deliver additional programming through the City's cable channel. • Increasing the funding by $200,000 for asphalt surface treatment and spot replacement for concrete streets will enhance the Street Maintenance program and strive towards meeting the goal of systematically investing in community infrastructure. • In an effort to reduce the number of on-the-job injuries and the associated risk, the Human Resources Department will offer a new safety incentive program for employees ($17,400). Water and Sewer Fund The 2001-02 fiscal year represents an increase in the City's fees to purchase water and wastewater treatment from North Texas Municipal Water District (NTMWD), but will not result in an increase in rates to the customer. Currently the City is undertaking a rate study to ensure the City maintains the integrity of the fund to continue to enhance operations. The recommendations regarding the utility rate study will be presented to City Council when complete. The water and sewer fund will see an increase in operational expenditures with the continuation of the touch read meter installations ($128,000), which is in the second year of a ten-year implementation plan. The water/sewer fund includes 8 new positions for fiscal year 2001-02 including a utility coordinator and a utility locator to implement the Right -of -Way Management Ordinance recently adopted by the City Council. An additional equipment operator and maintenance worker positions will allow for full operation of the sewer vacuum truck to improve the sewer system maintenance program. Two meter services positions have been included to respond to the increased number of meters in the City. An additional maintenance worker position will allow for cross -training in water and sewer maintenance to increase efficiency in the field. Also, an engineer in training position has been added to assist in the engineering related to the capital projects in the water and sewer system. The fund currently has $11.5 million in retained earnings, allowing for the draw down of $5.8 million for water and sewer system capital projects in fiscal year 2001-02. More specifically, this will fund the expansion of Stacy Road Pump Station and water and sewer line replacements. I Budget Transmittal Letter Fiscal Year 2001-02 Page vii ' Drainage Fund Storm drainage facilities and services are funded by a specific fee charged of all utility ' customers. The featured capital improvement project in this fund includes $110,000 to complete the Phase II of Mustang Creek in the portion South of Main Street to Bethany. Improvements to operations and maintenance include an enhancement to the street ' sweeping services by increasing the frequency to twice monthly for arterials and thoroughfares. This fund will also initiate a storm drain marking system to deter illegal ' dumping of hazardous or toxic waste in the stone sewer system. A Maintenance Worker position is funded to assist in the new Household Hazardous Waste collection program and litter control program to deter debris from entering the storm water sewer ' system. 1 1 t 1 1 1 Solid Waste Fund The Solid Waste Fund represents the financial activity related to solid waste collection and disposal, including recycling services and management of household hazardous waste (HHW). New programs, consistent with the City Council's Strategic Plan, include a contract to collect litter along US 75 twice a month and the initiation of a Household Hazardous Waste collection program. The fund incorporates expenditures of $104,000 and $90,000 respectively for the new programs. A Maintenance Worker position is funded to assist in the new Household Hazardous Waste collection program and litter control program. Enterprise Funds The Enterprise Funds account for operations that are financed and operated in a manner similar to private business enterprises. The intent of the City is that the costs of providing the goods or services to the public will be financed solely through user charges. The two enterprise funds include the Parks and Recreation Enterprise Fund and the Aquatics Fund. The new Don Rodenbaugh Natatorium will be opened during fiscal year 2001-02 and the Aquatics Fund incorporates the revenue and expenditures anticipated for operating the facility and associated programs. The Aquatics Fund anticipates five new positions with four hired at mid -year. The actual expenses related to new employees and program offerings will be closely monitored throughout the year to ensure an appropriate level of cost recovery based on the level of customer interest. Budget Transmittal Letter Fiscal Year 2001-02 Page viii Employee Compensation To determine the competitiveness of the City of Allen's compensation plan, the Human Resources Department conducted a salary comparison among our market comparison cities using data compiled from the Texas Municipal League. The proposed budget includes funds to grant a market adjustment effective on October 1, 2001, and to provide for merit increases based on performance evaluations on employee anniversary dates. We believe that these increases will keep the compensation plan competitive in our labor market. Funds budgeted in the 2001-02 fiscal year budget for salary adjustments and health insurance costs total $978,534 and are currently budgeted in the Internal Services Fund. We are gathering additional information and plan to present a more detailed recommendation at the budget workshop. Conclusion This completes the highlights of the proposed 2001-02 fiscal year budget. I would like to give thanks to the Department Directors and their staffs for contributing to the budget process and for prioritizing the community's needs effectively and to the Finance Department for contributing to the development of the budget document. In addition, I would like to give a special thanks to all City employees who have worked so hard to provide quality services to our citizens and who are committed to the success of the City of Allen. Respectfully submitted, r-��- Peter H. Varga City Manager CITY OF ALLEN t FUND STRUCTURE 2001-2002 FISCAL YEAR ' The funds that make up the budget are divided into two categories: Governmental Funds and Proprietary Funds. ' Governmental Fund Types ' Governmental funds are used to account for the City's general government activities. Governmental funds types use the flow of current financial resources measurement focus using the modified accrual basis of accounting. ' General Fund t The General Fund is the general operating fund for the City. It is used to account for all financial resources except those required to be accounted for in other funds. All general tax revenues and other receipts that are not allocated by law or contractual agreement to other funds are accounted for in this fund. Debt Service Fund ' The Debt Service Fund accounts for the accumulation of resources for, and the payment of, general long-term debt principal, interest and related costs. ' Capital Projects Funds ' The Capital Project Funds account for financial resources to be used for the acquisition or construction of major capital facilities, other than those financed by the proprietary fund types. Proprietary Fund Types ' Proprietary funds are accounted for on the flow of economic resources measurement focus and use the accrual basis of accounting. Under this method, revenues are recorded when earned and expenses are recorded at the time the liability is incurred. ' There are two types of proprietary funds included in the budget, Enterprise Funds and an Internal Service Fund. ' Enterprise Funds The Enterprise Funds are used to account for operations that are financed and operated ' in a similar manner to a private business enterprise. The intent of the governing body is that the cost (expenses, including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered primarily through ' charges, or where the governing body has decided that periodic determination of revenues earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability or other purposes. ' City of Allen ix FY 2002 Budget CITY OF ALLEN FUND STRUCTURE 2001- 2002 FISCAL YEAR Proprietary Fund Types — continued Water and Sewer Fund The Water and Sewer Fund is used to account for the provision of water and sewer services to the residents of the City. Activities include administration, operation and maintenance of the water and sewer system and billing and collection activities. Acquisition and construction of major water and sewer capital facilities and repayment of indebtedness from related bond issues and lease purchases are accounted for by this proprietary fund. All costs are financed through charges made to utility customers with rates reviewed and adjusted if necessary to ensure integrity of the fund. Solid Waste Fund The Solid Waste fund is used to account for revenue and expenses associated with the privately contracted trash collection service and the solid waste disposal contract with the North Texas Municipal Water District. Development Fees Fund The Development Fees Fund is used to account for fee receipts and corresponding expenditures for additional impact on water and sewer system from new development. Drainage Fund The Drainage Fund is used to account for the provision of developing and maintaining proper drainage services to the residents of the City. Parks and Recreation Enterprise Fund The Parks and Recreation Enterprises Fund is used to account for revenue and expenses incurred in the operation of providing recreation services to the residents of the City. Aquatics Enterprise Fund The Aquatics Enterprise Fund is used to account for revenue and expenses incurred in the operations of providing leisure and competitive pool facilities for the residents of the City. Internal Service Fund The Internal Service Fund is used to account for financing of goods or services provided by one department or agency to other departments or agencies of the City, or to other governmental units, on a cost -reimbursement basis. City of Allen x FY 2002 Budget CITY OF ALLEN FUND STRUCTURE 2001-2002 FISCAL YEAR Proprietary Fund Types — continued Vehicle Replacement Fund The Vehicle Replacement Fund accounts for the cost associated with the acquisition through the rental of such vehicles to other departments. Self Insurance Fund The Self Insurance Fund accounts for the collection of employee insurance premiums and remits payment as necessary to health care vendors. ' City of Allen xi FY 2002 Budget CITY OF ALLEN REVENUE SUMMARY 2001-2002 FISCAL YEAR The revenue summary section of the budget provides a description and underlying assumptions for the major revenue sources included in the budget. It also includes any significant trends that are affecting the revenue assumption in the current and future fiscal years. General Fund Tax Revenue Ad Valorem Taxes Ad Valorem Taxes are the City's largest revenue source; they make up 43.35 % of the general funds budgeted revenue and are estimated at $12,353,622 in fiscal year 2001- 2002. The City's property tax is levied each October 1 on the assessed value listed as of the prior January 1 for all real and certain personal property located in the City. Appraised values are established by the Central Appraisal District of Collin County at 100% of estimated value and certified by the Appraisal Review Board. The assessed value upon which the 2001 levy was based was $3,444,882,485. The collection rate is set at 99% and is based on the City's historically high collection rate. The total tax rate was cut to $.563 per $100 of valuation of which $.35705 per $100 of valuation is for the General Fund operations. The remainder of the tax rate $.20595 per $100 of valuation is used for Debt Service Fund. The City in an effort to rely less on property taxes has cut the tax rate the last nine years. Sales Tax Sales taxes are collected by retailers and remitted to the State Comptroller's Office for the sale of goods and services within the City of Allen. The State returns the portion designated for the City. The City collects 2 cents of the total sales tax collected. One cent is used in the General Fund the other 1 cent is split between the Allen Economic Development Corporation and the Allen Community Development Corporation. The City's sales tax collection has grown at an impressive rate over the last few years, as corporations, retailers and restaurants move to Allen. Due to the high growth rate, the City Council has made an effort to use sales tax revenue to reduce the property tax rate for the citizens of Allen. General Fund Sales Tax 576..0.00.00.G s e..0oo,.0.0.0 $4.000.000 $3.000.000 3+.000.000 $0 ,22e Uel +us nve +m +vve uYe x.0.0.0 x.0.01 City of Allen xii FY 2002 Budget CITY OF ALLEN REVENUE SUMMARY 2001-2002 FISCAL YEAR Tax Revenue continued Franchise Taxes Franchise Taxes are charged to specific businesses that conduct business in the City of Allen. Utilities (electric, telephone, gas, and cable) that operate in the City pay this tax for their use of the City's right of way to run their utility lines. Franchise Taxes are based on a percentage of gross receipts. Projections are based on population increase and projected utility use. Franchise fees for fiscal year 2001-2002 are projected at $3,037,925. This represents a 43% increase from the previous year's actual collections. Licenses and Permits Licenses and Permits revenues represent 9.18% of the total projected revenues for the new fiscal year. They are made up of commercial permits, city licensing revenues and inspection fees. Permit revenues are collected by the Building Inspections department for building and construction activities throughout the City of Allen. They include project permits that cover all parts of the construction (electrical, plumbing, and mechanical permits and certificate of occupancy fees), specific permits (fences, electric, plumbing, etc.) and service fees (re -inspections, special inspections and special services). ' Water and Sewer Fund ' Water & Sewer collection revenues are the revenues collected for the sale of water and disposal of sewage for residential, commercial and apartment usage. Collections for fiscal year 2001-2002 are budgeted at $11,228,382 for water sales and $2,692,432 for ' sewer charges. This represents approximately a 15% increase which is inline with the projected City growth for the next year. Solid Waste These fees are charged for residential, commercial, and apartment garbage collection ' and solid waste disposal. These fees cover the cost of collection and disposal of this waste by Community Waste Disposal and the North Texas Municipal Water District. Collections for garbage, recycling, commercial collections, and solid waste disposal are ' projected for fiscal year 2001-2002 at $2,567,726. ' City of Allen xiii FY 2002 Budget CITY OF ALLEN BUDGETPROCESS 2001-2002 FISCAL YEAR Budgeting Basis The budget process is set forth in the City Charter, Article IV, Section 4.01 to 4.10. The City Council adopts an annual budget prepared by the City Management. The City of Allen uses a budget format based on modified accrual accounting for governmental funds. This means that budgeted expenditures are recorded when the services or goods are received and the liabilities are incurred, but revenues are recognized only when they are measurable and available. Proprietary Funds are budgeted based on an accrual accounting basis. Expenditures are still recognized as they are encumbered, but revenues are recognized as they are obligated to the City. The Comprehensive Annual Report (CAFR) shows the status of the City's finances on the basis of "generally accepted accounting principles' (GAAP). In most cases this conforms to the way the City prepares the budget with the exception of compensating absences (accrued but unused vacation and sick leave), which is treated differently in the budget and in the CAFR. Budget Process The budget process is a yearly activity. It is part of a five year planning process the City of Allen uses to proactively forecast programs needed in a fast growing community. The budget process starts each year in January with the City Staff analyzing new projects and goals that the City Council has identified as areas of interest and would like to see developed into the five-year plan. The Finance department prepares analyses of current revenues and expenditures for the City Manager and Department heads to begin preparing for midyear budget adjustments. In February Personnel meets with each department to forecast upcoming personnel requests for the coming year. This allows each department an opportunity to adjust parts of their five-year plan. The budget kick-off is a meeting scheduled every April where the City Manager meets with all of the department heads. The budget is then broken down into three parts; a year- end estimate, a base budget for the upcoming year and new programs for the new fiscal year. The year-end estimate is a projection of revenues and expenditures for the remainder of the current fiscal year. All accounts are evaluated to determine if they are inline with their current budget. Any accounts that are under or over budget are revised to meet year-end estimates. New projects are not added to the year-end estimate. Only the cost for maintaining the current base operation is revised as needed. The base budget estimate for the upcoming fiscal year is the proposed cost for maintaining the current base operation, and assumes no additional personnel or additional equipment will be added. Activities that require any additional resources to maintain the current service level due to growth, new facilities, new equipment, etc., are considered additions to the base budget, and will be included in the new programs step of the budget process. Each line item in the base estimate can only be increased by a City of Allen xiv FY 2002 Budget 1 1 1 1 CITY OF ALLEN BUDGETPROCESS 2001.2002 FISCAL YEAR Budget Process — continued set percentage that is tied to an economic indicator to reflect inflation. All capital and one time purchases from the previous fiscal year are not included in the base budget. The final step in the budget process is new programs. This is defined as any change in program emphasis, expenditure of funds, allocation of personnel or equipment that will result in a change in the level of service currently being delivered. All requests for new personnel, fleet, or equipment that represent a net addition to the operation are considered additions to the base budget and should be included in new costs. For all new programs and costs, the department will have to describe the program, itemize all new costs included in the new program, proposed personnel, and justify the reason why the request is needed. Each of these new programs should be prioritized according to the need and included in their five-year plan. When all three steps of the budget process have been completed Finance reviews all budgets to ensure that everything falls within the budget guidelines. Any budgets that are not within the stated parameters will be returned to the department and must be corrected immediately. Once all of the department budgets are completed each director will meet with the City Manager to review their budget. This will give the City Manager the opportunity to review all of the new programs requested by the departments and make any necessary changes, he will submit the proposed budget to Council at the Council budget workshop meeting. Council will then have the opportunity to review the budget and voice any opinions and concerns they have. After the Council budget workshop there will be a public hearing on the budget and a public hearing on the tax rate if it is necessary. This will give the public a chance to review the budget and voice their opinions. At the first regular Council meeting in September the City Council will adopt the final budget. Budget adiustment/amendments Budget changes that do no affect the "bottom line total for a department, but transfer dollars from one line item to another within a departments' operating budget, or changes between divisions within a department, may be allowed by the City Manager at the written request of the department. Any budget adjustment that brings about a change in the total appropriation for a department may be allowed by the City Manager at the written request of the department, based on the City's ability to fund these requests. Any budget adjustment that brings about a change in the total appropriation for a fund requires Council's approval in the form of an ordinance. City of Men xv FY 2002 Budget CITY OF ALLEN FISCAL YEAR 2001-2002 Investment Policies Investments are categorized into three categories as defined by GASB Statement No. 3 to give an indication of the level of risk assumed by the entity at year end: Category 1 includes investments that are insured or registered or for which the securities are held by the City or its agents in the City's name. Category 2 includes uninsured and unregistered investments for which the securities are held by the counterparty's trust department or agent in the City's name. Category 3 includes uninsured and unregistered investments for which the securities are held by the counterparty, or by its trust department or agent but not in the Citys name. At September 30, 2000, the City had no Category 2 or 3 investments. The City, AEDC and CDC invest in the Texpool which is an investment fund authorized by the Texas Legislature and administered by the Texas State Treasury. The Texas Treasury Safekeeping Trust Company is trustee of Texpool and is a limited purpose trust company authorized pursuant to Texas Government Code. The purpose of the Texpool is to allow for the pooling of public funds to provide a higher yield on the pooled investment than would be possible with the investment of the individual public entity's funds. Texpool investments are subject to the same investment policies maintained by the State Treasury for all state funds. The Legislature has authorized only certain investment instruments for public funds, including repurchase agreements, U.S. Treasury bills and bonds, securities of other U.S. government agencies, commercial paper and other safe instruments. The investment in Texpool and any accrued interest may be redeemed at the City's discretion. The City's position in the pool is not materially different from the value of the pool shares. City of Allen xvi FY 2002 Budget CITY OF ALLEN BUDGET CALENDAR FISCAL YEAR 2001-2002 January 26 Strategic Planning with Staff January 29 Distribute New Persormel/Reclass Request Forms for FY 2001-2002 February 10 Strategic Planning with Council March 2 New Personnel Request Forms Due to Personnel April 11 Department Head Work Shop (Beginning of Budget Process) April 16-20 Finance Meets With Departments for Budget Training May 7 Budget Input Deadline May 7-18 Finance Reviews Departmental Submittals to Ensue Budgets are Within Defined Targets May 21 -June 8 City Manager/Department Head Budget Review June 11 -July 30 Final Budget Preparations Aug. 2 Deliver Budget Document to City Council Aug. 10-12 Council Budget Workshop Aug. 28 Public Hearing on Budget Aug. 28 Public Hearing on Tax Rate (If needed) Sept. 6 Adopt Budget at Regular Council Meeting City of Alen zvii FY 2002 Budget CITY OF ALLEN COMBINED BUDGET SUMMARY OF REVENUES AND EXPENDITURES FOR FISCAL YEAR 2001-2002 Distribution of Revenues -All Funds Miscellaneous Operating Transfers in 170% TM% Interest Earned Ad Valorem Taxes 28.74% 150% Fines 148% Fran Charges for Seances 3199% Licenses ans, 378% Sales To 18.54% City of Allen Page 1 FY 2002 Budget Enterprise Funds General Debt Water& Solid Drainage Parks& Fund Service Sewer Waste Utility Recreation Aquatics BEGINNING BALANCE $ 5,249,882 $ 996,527 11,597,398 $ 786,201 $ 493,247 $ 27,881 $ 207,110 R V N I C Ad Valorem Taxes 12,353,622 7,534,817 - - - - - Franchise Taxes 3,037,925 - - - - - - Sales Tax 6,413,278 - - - - - - Licenses and Permits 2,615,988 - - - - - - Charges for Services 428,000 - 14,162,463 2,567,726 760,000 521,684 901,072 Fines 958,000 - 169,000 - - - - Interest Earned 285,271 - 381,949 18,786 21,661 6,678 6,867 Miscellaneous 564,384 - 250,000 - - 90,000 - Operating Transfers In 1,940,329 11,020 TOTAL REVENUES 28,496,797 7,534,817 14,974,432 2,586,512 781,661 618,362 907,939 TOTAL AVAILABLE XP NFXP $ 33,746,679 $ 8,531,344 $ 26,571,830 $ 3,372,713 $ 1,274,908 $ 646,243 $ 1,115,049 DITUPRi General Government 6,868,884 - 492,529 - - - - Public Safety 12,129,029 - - - - - - Public Works 2,597,830 - 9,814,013 2,566,276 871,173 - - Cu9ure & Recreation 5,369,183 - - - - 609,075 856,549 Community Development 1,531,871 - - - - - - Debt Service - 7,441,417 1,854,609 - - - - Capital Projects 5,821,000 TOTAL EXPENDITURES 28,496,797 7,441,417 17,982,151 2,566,276 871,173 609,075 856,549 ENDING BALANCE $ 5,249,882 $ 1,089,927 $ 8,589,679 $ 806,437 $ 403,735 $ 37,168 $ 258,500 Distribution of Revenues -All Funds Miscellaneous Operating Transfers in 170% TM% Interest Earned Ad Valorem Taxes 28.74% 150% Fines 148% Fran Charges for Seances 3199% Licenses ans, 378% Sales To 18.54% City of Allen Page 1 FY 2002 Budget Enterprise Component Units Spacial Revenue CITY OF ALLEN t COMBINED BUDGET SUMMARY OF REVENUES AND EXPENDITURES Economic Community FOR FISCAL YEAR 2001-2002 Vehicle Se" Enterprise Component Units Spacial Revenue Internal Service Funds Fiduciary Total All Funds Development Economic Community Capital Hotel Vehicle Se" - - ' Fees Development Development Improvement Occup.Tas Repl. Insurance COAST 2001-2002 $ 3,552,980 $ 779.481 $ 1,010,217 $ 299,092 $ 56,542 $ 3,354,073 $ 229,586 $ 2,413 $ 28,642,630 - - - - - - - - 19,888,439 - - - - - - - - 3,037,925 - 3,206,639 3,206,639 - - - - - 12,826,556 - - - - - - - - 2,615,988 2,777,600 - - - - - - 13,125 22,131,670 - - - - - - - - 1,027,000 146,519 35,000 25,000 22,116 1,500 67,461 18,607 - 1,037,415 - - - 200,000 67,000 - - - 1,171,384 999,875 2,501,829 5,453,053 2,924,119 3,241,639 3,231,639 222,116 68,500 1,067,336 2,520,436 13,125 69.189,430 $ 6,477,099 $ 4,021,120 $ 4,241,856 $ 521,208 $ 125,042 $ 4,421,409 $ 2,750,022 $ 15,538 $ 97,832,060 - 2,766,158 - - - - 2,216,009 - 12,343,580 - - - - - - 12,129,029 4,960,835 - - - - - - - 20,810,127 - - - 149,200 58,412 - - 12,210 7,054,629 - - - - - - - 1,531,871 - - - - - 9,296,026 3,986,517 174,513 9,982,030 4,960,835 2,766,158 3,986,517 149,200 58,412 174,513 2,216,009 12,210 73,147,292 $ 1,516,264 $ 1,254,962 $ 255,339 $ 372,008 $ 66,630 $ 4,246,896 $ 534,013 $ 3,328 $ 24,684,768 Distribution of Expenditures -All Funds Capital Projects 1365% Debt Service _ 12.71% Community Development 2.10% Culture & Recreation 964% General Government 16.87% Public Safety 16.58% Public Works 28.45% ' City of Allen Page 2 FY 2002 Budget CITY OF ALLEN ORGANIZATIONAL CHART20012002 FISCAL YEAR wayo� enH coq canal � EOMeenOCMmYIIPne G.M=wl I I P01t SMy I LPYMk W.ke CYIw1UeM RWM Clvs.M Polo E,I.. , PM. 6R..G. 'mdo m I.T. Pemm�el IH Nevence nunlYBMk WAN wemun airy cowft I sdM WW I EcanMkGsrsbpMnl City Staffing LlGery AM.., are shown a5 City of Allen Page 3 FY 2002 Budget REVISED ORIGINAL REVISED BUDGETED DIFFERENCE General Fund 1999.2000 2000.2001 2000.2001 2001.2002 2001.2002 City Secretary 2.50 3.00 3.00 3.00 - Municipal Court 6.00 6.00 6.00 8.00 2.00 City Administration 9.00 9.50 8.50 9.00 0.50 I.T. 4.00 4.00 4.00 6.00 2.00 Personnel 3.00 4.00 4.00 4.00 - Internal Services - 6.00 - - - Police 89.00 92.00 94.00 107.00 13.00 Parks & Recreation 36.00 44.75 44.75 52.75 8.00 Library 16.25 17.75 18.25 18.75 0.50 Fire 68.00 75.00 77.00 82.00 5.00 Building & Code Compliance 15.00 14.00 16.00 18.00 2.00 Planning & Development 6.50 7.50 7.50 7.50 - Community Services 21.00 21.00 21.00 23.00 2.00 Finance 7.25 10.25 10.25 10.25 - Engineering 10.00 11.00 11.00 11.00 Total General Fund 293.50 325.75 325.25 360.25 35.00 Water& Sewer Fund 34.00 38.00 38.00 46.00 8.00 Solid Waste Fund 1.00 1.00 1.00 2.00 1.00 Drainage Fund 5.00 5.00 5.00 6.00 1.00 Parks & Recreation Enterprise Fund 19.25 11.75 11.75 12.75 1.00 Aquatics Enterprise Fund - 36.50 36.50 41.50 5.00 Economic Development Fund 3.00 3.00 3.00 3.00 - SeO Insurance Fund - 1.00 1.00 1.00 - are shown a5 City of Allen Page 3 FY 2002 Budget CITY OF ALLEN DEBT SERVICE FUND FISCAL YEAR 2001-2002 Debt Policy The City of Allen issues general obligation bonds for a term of generally twenty years, for the purpose of constructing major capital improvements which included municipal facilities, parks and streets. As a home rule city, the City of Allen is not limited by law in the amount of debt it may issue. The City's Charter (Article 5, Section 1) states: "In accordance with the constitution of the State of Texas, and not contrary thereto, the City of Allen shall have the power to borrow money against the credit of the city for any public purpose that is not now nor hereafter prohibited by the constitution and laws of the State of Texas". The City's debt policy goal is to keep the ratio of ad valorem tax collections appropriated to the debt service fund below 40%. For fiscal year 2001-2002 the appropriation ratio of ad valorem tax to the debt service fund is 36.58%. The Tax rate at October 1, 2001 is $0.563 per $100.00 of assessed valuation of which $0.20595 is designated to the debt service fund. PROJECTED FUND BALANCE 10/1/01 TOTAL PROJECTED REVENUES TOTAL PROJECTED EXPENDITURES PROJECTED FUND BALANCE 9/30/02 FUND BALANCE REQUIRED: 10% OF ANNUAL DEBT SERVICE 996,527 7,534,817 (7,441,417) $ 1,089,927 $ 743,482 I' City of Allen Page 4 FY 2002 Budget 0 I m m m H V 1 G y +8 D 0 NN++++WG m z N D tp b b bfOb -1 D O O b b b b b m oowwobb m mFD'� Ro r b m N m r + O b m m A Nm p A A a N r O T N 0 r j W+ m m + W A W N N to Oo N n O rO000 O N O O O cbii cmiim��oo OV tmn tNT O YNi (Wli m O O o O O 0 0 0 0 0 0 0 0 z 0 O O O 0 0 0 0 0 0 0 0 mmm O oommm mm D yo b m N - O t0 m m "o m < 0 N mN N z O m- m V W N m A m m m A m O Wm b C 1D O A t0 W O m+ N 0 m m w y w 0 y 3 M O N y W C 10 A O AN z O A O O .t O m O m O a W m 0000- W 0 y tm0 IO 0 0 0 m W A O O O O O b A W O m m N 0 0 0 w o W w O O O O y N O O O O O O N O N V N W O A O O O O O + 000000 + O mo N IJ O O V m O O m m m O O m O O O O m j aoea v e v a a°aoe� d m O d° N V O m O N O O O lWl� Si rn rn ow mo w t0o00 0m CCC iaR3 o0 t0 m N O b m m m V m :: W+ V O O N t0 m m G y O m O m m m O m N N m m Q O O O m 0 0 0 0 0 0 t0 O O O ON O O O O O O N O O O O 000000-o M N O T r j W+ m V + W A W N N to N n O O N O O O OV tmn tNT YNi (Wli m O O o O O 0 0 0 0 0 0 0 0 N- 0 O O O 0 0 0 0 0 0 0 0 C O O O 0 0 0 0 0 0 0 0 N N O m- m V W N m A m m A m O Wm b 1D O A t0 W O m+ N m M o A .t N O a m y tm0 Y A A top m W A P O b A W O m m N O 6 W w N OVo A V N V N W O A O W m m V N -00000 0 m 00 T � N DA0 r M 00 D m m A A D A r Oam z e m 0 m m i ' General Fund REVENUES Ad Valorem Taxes 8,301,578 CITY OF ALLEN 10,033,546 GENERALFUND 10,022,135 REVENUE AND EXPENDITURE SUMMARY ' FISCAL YEAR 2001-2002 Franchise Taxes 1999-2000 2000-2001 2000-2001 2001-2002 ACTUAL BUDGET AMENDED BUDGET ' BEGINNING FUND BALANCE $ 4,577,854 $ 5,384,609 $5,384,609$ 5,249,882 , REVENUES Ad Valorem Taxes 8,301,578 10,033,546 10,022,135 12,353,622 ' Franchise Taxes 2,124,210 2,359,471 2,757,666 3,037,925 Sales Tax 4,572,178 4,964,358 5,576,764 6,413,278 Licenses and Permits 2,273,320 2,244,103 2,635,749 2,615,988 ' Charges for Services 369,488 436,854 370,960 428,000 Fines 742,820 642,000 902,650 858,000 Interest Earned 454,154 310,000 404,330 285,271 ' Miscellaneous 961,917 944,000 561,523 564,384 Operating Transfers In 1,618,535 1,741,349 1,740,474 1,940,329 Drawdown of Reserves -400,000 - ' TOTAL REVENUES $ 21,418,200 $ 23,675,681 $ 25,372,251 $ 28,496,797 TOTAL AVAILABLE $ 25,996,054 $ 29,060,290 $ 30,756,860 $ 33,746,679 ' EXPENDITURES General Government 4,591,610 5,136,378 5,501,555 6,868,884 Public Safety 9,417,166 10,603,467 11,154,622 12,129,029 Public Works 1,941,171 2,125,118 2,352,467 2,597,830 Culture & Recreation 3,410,601 4,615,082 4,782,700 5,369,183 , Community Development 1,250,897 1,195,636 1,315,634 1,531,871 TOTAL EXPENDITURES $ 20,611,445 $ 23,675,681 $ 25,106,978 $ 28,496,797 ' ENDING FUND BALANCE $ 5,384,609 $ 5,384,609 $ 5,249,882 $ 5,249,882 DAYS OPERATIONAL EXPENSES IN RESERVE 80.5 ' Fund Balance Required: 60 days operational expenses $ 3,910,685 City of Allen Page 7 FY 2002 Budget Franchise Taxe: 10.66% GENERAL FUND REVENUE FY 2001-2002 Sales Tax 22.51% Licenses and Permits 9.18% Charges for Services 1 50 % Ad Valorem Taxes 43.35% Fines 3.01% Interest Earned 1.00% Miscellaneous 1.98% Operating Transfers In 6.81% EXPENDITURES BY FUNCTION FY 2001-2002 Community Development Culture & Recreation 5.38% 18.84% Public Works 9.12% Public Safety 42.56% General Government 2410% City of Allen Page 8 FY 2002 Budget CITY OF ALLEN GENERALFUND REVENUES FISCAL YEAR 2001.2002 1999-2000 2000-2001 2000-2001 2001-2002 Current 7,872,098 9,821,546 9,856,850 12,183,622 Delinquent 71,749 56,000 95,432 60,000 Penalty & Interest 83,947 56,000 56,000 60,000 Miscellaneous 273,784 100,000 13,853 50,000 SUBTOTAL $ 8,301,578 $ 10,033,546 $ 10,022,135 $ 12,353,622 FRANCHISE TAXES Electric 1,326,812 1,570,543 1,777,627 2,018,000 Gas 152,972 153,527 234,527 192,200 Communication 234,817 245,017 271,500 298,650 Cable 301,648 285,024 351,085 400,000 Solid Waste 107,961 105,360 122,927 129,075 SUBTOTAL $ 2,124,210 $ 2,359,471 $ 2,757,666 $ 3,037,925 SALES TAX 4,572,178 4,964,358 5,576,764 6,413,278 SUBTOTAL $ 4,572,178 $ 4,964,358 $ 5,576,764 $ 6,413,278 PERMITS & LICENSES Single Family Permits 906,202 687,500 1,116,057 972,000 Multi Family Permits - 132,000 144,000 260,000 Commercial Permits 533,288 500,000 495,695 500,000 Building Permits -Other 145,028 120,000 127,392 125,240 Sign Permits 39,150 36,000 34,490 36,260 Health Permits 21,450 25,500 25,500 28,000 Uniform Fire Code Permits 35,420 35,000 17,408 20,000 Clearing & Grading Permit 2,350 1,900 2,300 2,000 Development Permits 2,250 2,300 2,300 2,300 Licenses & Registrations 30,125 28,000 26,800 28,640 Animal Licenses 17,398 25,000 28,000 30,000 Court Fees-Hb7-$3 13,396 10,368 20,245 22,208 Zoning & Platting Fees 126,508 165,000 98,078 90,000 Plat Administration Fees 4,216 4,800 2,594 2,350 Fire Reinspections 2,275 1,500 1,500 1,500 Inspection Fees 271,054 358,235 358,235 300,000 Reinspection Fees 107,978 96,000 113,735 173,000 Mixed Drink Tax 15,232 15,000 21,420 22,490 SUBTOTAL $ 2,273,320 $ 2,244,103 $ 2,635,749 $ 2,615,968 City of Allen Page 9 FY 2002 Budget I 1 ' City of Allen Page 10 FY 2002 Budget CITY OF ALLEN t GENERALFUND REVENUES ' FISCAL YEAR 2001-2002 1999-2000 2000-2001 2000-2001 2001-2002 'REVENUE TAI -continued ACTUAL RI IDGFT AMENDED BUDGET CHARGES FOR SERVICE Ambulance Services 369,488 436,854 370,960 428,000 ' SUBTOTAL $ 369,488 $ 436,854 $ 370,960 $ 428,000 ' FINES & FORFEITURES Police Reports 4,815 5,000 5,000 5,000 Court Fines 685,299 587,000 845,000 800,000 Library Fines 38,756 40,000 40,000 40,000 ' False Alarm Fines 13,950 10,000 12,650 13,000 SUBTOTAL $ 742,820 $ 642,000 $ 902,650 $ 858,000 ' INTEREST EARNED Interest 454,154 310,000 404,330 285,271 SUBTOTAL $ 454,154 $ 310,000 $ 404,330 $ 285,271 O-4$ MIR�AN Library Grant Funds 15,333 15,333 77,200 15,333 t Misc Grants 2,214 227,445 24,970 48,308 166,667 COPS Fast Grant 508,674 415,170 129,327 Sale Of Materials 5,075 3,200 2,804 3,000 ' Reproduction Revenues 1,532 1,500 1,450 2,000 85,000 Alarm Registration Fees 73,146 80,000 80,000 Finger Print Revenue 3,420 3,000 3,000 3,500 ' Sale Of Lots 100 - 150 - Facility Rental Fees 500 1,375 Arrest Fees 9,629 - 47,785 53,615 Donations/Sponsorships 11,520 5,000 5,022 5,000 ' Street Light Surcharge 51,436 15,750 15,750 15,750 Miscellaneous 49,950 3,725 8,923 5,211 School Resource Officer 169,053 141,977 141,977 140,000 ' Street Sign Reimbursement 60,335 31,900 21,790 21,000 SUBTOTAL $ 961,917 $ 944,000 $ 561,523 $ 554,384 Operating Transfer In 1,618,535 1,741,349 1,740,474 1,940,329 Drawdown Of Reserves - - 400,000 - ' TOTAL REVENUE $ 21,418,200 $ 23,675,681 $ 25,372,251 $ 28,496,797 1 ' City of Allen Page 10 FY 2002 Budget CITY OF ALLEN TAX STRUCTURE FISCAL YEAR 2001-2002 ASSESSED VALUE - 2001 $ 3,444,882,485 REVENUE AT $.563 PER $100 VALUATION $ 19,394,688 CONTRIBUTION TO DEBT SERVICE $ (7,094,817) CONTRIBUTION TO GENERAL FUND 99.0% COLLECTION RATE $ 12,183,622 TAX RATE DISTRIBUTION RATIO PERCENT AMOUNT GENERAL FUND 0.35705 63.42% 12,299,871 DEBT SERVICE FUND 0.20595 36.58% 7,094,817 0.56300 100.00% 19,394,688 City of Allen Page 11 FY 2002 Budget CITY OF ALLEN REVENUE ASSUMPTIONS FISCAL YEAR 2001-2002 Assumptions Used for Projecting 2001.02 Revenues 1. Tax rate used = $ .563 Based on approved assessed value of $3,444,882,485 2. Growth in sales tax revenue of 15% FY 2001 sales taxes through July running 32% higher than same period FY 00 3. Growth in franchise fees of an average of 16.2% 4. Overall city growth factor of 8% used I' City of Allen Page 12 FY 2002 Budget CITY OF ALLEN GENERALFUND EXPENDITURE BY FUNCTION FISCAL YEAR 2001-2002 1999-2000 2000-2001 2000-2001 2001-2002 ACTUAL BUDGET AMENDED t3UDzET General Government, City Secretary 238,371 283,627 291,740 305,748 Municipal Court 268,256 298,251 335,630 386,384 City Administration 538,656 633,981 601,163 670,913 Information Technology (IT) 483,514 623,822 629,749 770,956 Personnel 252,495 370,481 367,349 415,291 Internal Services 2,048,182 1,830,933 2,124,347 3,111,376 Building Maintenance 352,779 480,425 508,609 528,154 Finance 409,357 614,858 642,968 680,062 Total General Government $ 4,591,610 $ 5,136,378 $ 5,501,555 $ 6,868,884 Public of ty, Police 5,235,220 5,775,767 6,193,512 6,814,941 Fire 4,181,946 4,827,700 4,961,110 5,314,088 Total Public Safety $ 9,417,166 $ 10,603,467 $ 11,154,622 $ 12,129,029 Public Works, Community Service Admin 189,727 225,447 256,229 242,224 Streets 1,022,265 1,209,107 1,328,603 1,612,112 Engineering 729,179 690,564 767,635 743,494 Total Public Works $ 1,941,171 $ 2,125,118 $ 2,352,467 $ 2,597,830 Culture & Recreation, Parks & Recreation 2,486,776 3,573,721 3,634,656 4,235,388 Library 923,825 1,041,361 1,148,044 1,133,795 Total Culture & Recreation $ 3,410,601 $ 4,615,082 $ 4,782,700 $ 5,369,183 Community Development: Building& Code Compliance 913,735 733,415 815,783 1,001,192 Planning & Development 337,162 462,221 499,851 530,679 Total Community Development $ 1,250,897 $ 1,195,636 $ 1,315,534 $ 1,531,871 TOTAL EXPENDITURES $ 20,611,445 $ 23,675,681 $ 25,106,978 $ 28,496,797 City of Allen Page 13 FY 2002 Budget 1 Personnel Services 69.09% General Fund Expenditures By Classification operations 24.05% City of Allen Page 14 Debt Payments, 1.28% Professional Services 3.72% Capital 1.86% FY 2002 Budget CITY OF ALLEN EXPENDITURE CLASSIFICATION AS A PERCENT OF TOTAL GENERAL FUND BUDGET FISCAL YEAR 2001-2002 2000-2001 CLASSIFICATION 1999-2000 %OF REVISED ACTUAL ACTUAL BUDGET RUDGET %OF 2001-2002 BUDGET %OF BUDGET Personnel Services 13,399,996 65.01% 16,490,888 65.68% 19,688,095 69.09% Operations 4,737,916 22.99% 6,402,083 25.50% 6,853,707 24.05% Debt Payments - 0.00% 303,207 1.21% 363,848 1.28% Professional Services 921,015 4.47% 1,040,382 4.14% 1,060,047 3.72% Capital 1,552,518 7.58% 870,418 3.47% 531,100 1.86% TOTAL $ 20,611,445 $ 25,106,978 $ 26,496,797 Personnel Services 69.09% General Fund Expenditures By Classification operations 24.05% City of Allen Page 14 Debt Payments, 1.28% Professional Services 3.72% Capital 1.86% FY 2002 Budget CITY OF ALLEN GENERALFUND THREE YEAR PROJECTION Tax Revenues 2001-2002 2002-2003 2003-2004 Assessed Value $3,444,882,485 $ 3,892,717,208 $ 4,359,843,273 Tax Rate per $100 Valuation 0.56300 0.60718 0.61578 Tax Revenues $ 19,394,688 $ 23,635,800 $ 26,847,043 Debt Service Paid From Tax Revenue (7,094,817) (9,022,518) (9,430,374) Debt Service paid from Investment Income (340,000) (300,000) (300,000) General Fund Tax Revenues $ 12,183,622 $ 14,467,150 $ 17,242,502 Other General Fund Revenues 16,313,175 18,760,151 21,574,174 Use of Reserves Total Revenues $ 28,496,797 $ 33,227,301 $ 38,816,676 Personnel Expense $ 19,688,095 $ 23,625,714 $ 28,350,857 Operational & Capital Expense 8,808,702 9,601,485 10,465,619 Total Expense $ 28,496,797 $ 33,227,199 $ 38,816,476 Revenues Over/(Under) Expenses $ $ 102 $ 201 Assumptions Used For Projections 1. Annual growth in assessed value determined by CIP Finance Committee 2. Used tax rate necessary to balance budget given other assumptions 3. Debt service based on projected future bond sales of $23,317,000 in Spring 2002 and $5,378,000 in Spring 2003 4. Annual growth projected in other General Fund Revenues of 15%. 5. Personnel Expense estimated at annual increase of 20%. Average increase over past 5 years has been 21 %. FY2002 Budget Reflects 19% increase. 6. Operational and capital expenses estimated at annual increase of 9%. Average increase over past 5 years has been 15%. FY2002 Budget Reflects 2% increase. City of Allen Page 15 1 FY 2002 Budget ' CITY OF ALLEN, TEXAS FY 2001-2002 City Secretary (1) Assistant City Secretary (1) Administrative Secretary (1) CITY SECRETARY DIVISIONS CITY SECRETARY 001-1000-411 MAYOR & COUNCIL 001-1010-411 City of Allen Page 16 FY 2002 Budget FUND CITY SECRETARY 001-1000-411 DEPARTMENT DESCRIPTION To strive for excellence by providing efficient and effective quality service, responding to the needs of all customers and anticipating future growth so that public confidence in city government is enhanced. PROGRAM NARRATIVE Accomplishments for FY 2001: ❖ Administered General and Charter election in accordance with State Law. 6• Produced amended "City Charter" to represent results of Charter election. :• Continued the new outreach program for Board and Commission applicants. ❖ Provided advanced information to citizens via the Web site. ❖ Disposed of city records in accordance with the Texas State Library requirements. Moved Municipal Records Center from Hillside Water Tower to a new, more convenient, safe and climate controlled location in city hall. 4 Implemented records management software to control information in the form of records from their creation to the time of their disposal. ❖ Per the strategic plan, researched feasibility of implementing a volunteer clearinghouse for all city departments. Objectives for FY 2002: A Respond promptly to requests for documents so that customers receive information in a timely manner. S• Publish legal notices to satisfy State law and to inform the public through print media. v Maintain official City Records to ensure the efficient retrieval of those records. S• Administer City Elections in accordance with State Law being unbiased and ethical in the process. S• Provide increased support for the records management program ensuring compliance with the Texas State Library guidelines for records management. 6• Implement a citywide volunteer program, per FY 2001 strategic plan. t• Implement a program to encourage and increase voter participation in city elections. ❖ Conduct an Open Records Training program for city personnel. City of Allen Page 17 FY 2002 Budget FUND DEPARTMENT 46,625 46,625 ACCOUNT GENERALFUND CITY SECRETARY 19,076 001-1000-411 23,838 569 500 342 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 RUnQFT 2000-2001 AMENDS 2001-2002 RUnQET CI A. CIS FIGATION Personnel Services 135,571 158,266 165,015 173,495 Operations 102,801 125,861 126,725 132,253 Pro Services - ' 650 650 Capifessional tal DEPARTMENTTOTAL $ 238,371 $ 284,127 $ 291,740 $ 305,748 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 B.UnrFT 2000-2001 AMENS 2001-2002 RIIDQF FULL TIME City Secretary 1 1 1 1 1 Administrative Secretary 1 1 1 2,071 Assistant City Secretary 1 1 1 1 TOTAL FULL TIME 3 3 3 3 PARTTIME Department Secretary 0 0 0 0 TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 B II DQET 2000-2001 AMENDED 2001-2002 RUnQE[ PERSONNEL ERVICES Salaries 107,485 121,896 129,905 134,188 Longevity 1,016 1,126 1,068 1,228 FICA Expenses 8,244 9,231 9,980 10,092 TMRS Expenses 11,413 12,862 12,857 13,041 Workman's Comp Expenses 196 222 288 298 Health Insurance 6,219 11,673 9,307 12,892 Dental Insurance 575 775 983 1,130 Long -Tenn Disability 279 297 356 364 Life Insurance 144 184 271 262 SUBTOTAL $ 135,571 $ 158,266 $ 165,015 $ 173,495 renes & Training 47,179 46,625 46,625 36,980 & Subscriptions 19,590 19,076 21,288 23,838 569 500 342 500 1e hone 2,333 1,500 650 - rnce 648 800 774 - ssional Services 835 950 946 950 ige & Freight 586 650 650 - ig & Reproduction 788 3,000 3,000 3,000 rtising 5,165 7,000 7,000 7,000 ante Codification 3,060 3,800 4,200 3,800 rllaneous Oper. Exp. 625 2,000 2,071 18,025 City of Allen Page 18 FY 2002 Budget GENERALFUND EXPENDITURE DETAIL - cont. Supplies s & Commissions Ilaneous Supplies Tools & Minor Equip ment Maintenance /Council Salaries m Expenses uter Costs 'ds Management Exp. SUBTOTAL DEPARTMENT PITAL EXPENDITURES LIST capital outlay for this department CITY SECRETARY 1999-2000 2000-2001 ACTUAL RUnGiFT 1,302 1,700 1,006 2,200 9,986 9,950 - 2,830 - 500 1,750 1,920 5,432 8,000 - 500 1.947 12,360 TrYlrbklri 2,157 1,083 9,950 2,830 1,920 8,000 500 12.739 001-1000-411 2001-2002 BUDGET 45411 120001 4299 City of Allen Page 19 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 Finance Director Municipal Court Coordinator 1 Municipal Court 11 3 Municipal Court Supervisor Clerk Municipal Court Cashier Clerk 1 1 11 MUNICIPAL COURT DIVISIONS MUNICIPAL COURT 001-1200-412 City of Allen Page 20 FY 2002 Budget FUND DEPARTMENT DESCRIPTION MUNICIPAL COURT The Municipal Court exists for safety of the community through the impartial and timely adjudication of criminal cases under municipal law. PROGRAM NARRATIVE Accomplishments for FY 2001: Conducted a warrant drive with assistance from the Police Department. Implemented payment of court fines with credit cards. ❖ Continued to expand the Teen Court Program. :• Received Juvenile Accountability Incentive Block Grant in the amount of $5,779 with the City to provide an additional $642 to aid in the administration of our Teen Court program and other aspects of our Juvenile Crime Diversion Program. Implemented a First Offender Program. �e Began classroom education on Municipal Court and juvenile law in middle schools and high school. Objectives for FY 2002: Conduct two warrant drives with assistance from Police Department. :• Investigate possibility of paying court fines over the telephone and/or Internet. Research and implement process to have a collection agency collect older unpaid tickets. :• Study possibility of implementing seat belt course. Explore potential of expanding community service program. City of Allen Page 21 FY 2002 Budget FUND GENERAL FUND DEPARTMENT MUNICIPAL COURT ACCOUNT 001-1200-412 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BIS 2000-2001 AMENDED 2001-2002 BUDGET CI ASSIFICATION Personnel Services 236,399 256,274 281,366 337,992 Operations 30,762 31,239 29,741 39,189 Professional Services 1,095 10,738 24,523 9,203 Capital - - DEPARTMENTTOTAL $ 268,256 $ 298,251 $ 335,630 $ 386,384 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 B D T 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME Municipal Court Coordinator 0 0 0 1 Municipal Court Supervisor 1 1 1 1 Municipal Court Clerk 4 4 4 4 Cashier 0 0 0 1 Judge 1 1 1 1 TOTAL FULL TIME PARTTIME 6 6 6 8 TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 RUDGFT 2000-2001 AMENOED 2001-2002 BUDGET PrRSONNEL SERVICES Salaries 184,554 199,640 211,048 254,885 Longevity 678 969 1,020 1,332 Overtime 1,615 1,891 9,343 1,929 FICA Expenses 14,263 16,346 16,411 19,602 TMRS Expenses 19,637 20,963 21,057 25,105 Workman's Comp Expenses 337 361 470 564 Health Insurance 13,321 14,858 19,083 30,920 Dental insurance 1,390 1,550 2,016 2,6D6 Long -Term Disability 462 538 588 688 Life Insurance 143 158 330 364 SUBTOTAL $ 236,399 $ 256,274 $ 281,366 $ 337,992 OPERATING EXPENSES Conferences & Training 1,885 4,000 2,834 4,540 Dues & Subscriptions 334 420 284 758 Mileage 546 1,500 794 1,500 Telephone 2,352 2,690 922 - Insurance 1,130 1,153 1'518 Postage & Freight 1,594 1,800 1,540 - Pdnting & Reproduction 7,600 10,000 7,003 12,000 Advertising - 200 2,000 204 Jury Fees 1,236 1,552 2,464 3,083 City of Allen Page 22 FY 2002 Budget FUND DEPARTMENT ACCOUNT GENERAL FUND MUNICIPAL COURT 001-1200-412 EXPENDITURE DETAIL - cont. 1999-00 2000-01 ACTUAL BUDQFT 2000-01 AMENDED 2001-02 R1IDGIET OPERATING EXPENSES - cont 5,125 - - - 2,430 - 6,421 Computer Costs Teen Court Expenses - 3,320 270 676 276 Miscellaneous Oper. Exp. 2,687 3,854 3,854 4,591 Office Supplies 215 400 400 408 Miscellaneous Supplies 400 893 408 Small Tools & Minor Equip 1,735 Equipment Maintenance 1,003 3,000 2,129 5,000 SUBTOTAL $ 30,762 $ 31,239 $ 29,741 $ 39,189 PROFESSIONAL SERVICES Professional Services 1,095 2,650 21,916 4,203 Credit Card Costs - 8,088 2,607 5,000 SUBTOTAL $ 1,095 $ 10,738 $ 24,523 $ 9,203 DEPARTMENT TOTALS $ 268,256 $ 298,251 $ 335,630 $ 386,384 CAPITAL EXPENDITURES LIST No capital outlay for this department amity of Allen Page 23 FY 2002 Budget ' CITY OF ALLEN, TEXAS FY 2001-2002 --LCity Manager 1 Executive Secretary Public Information Officer � 1 Video Technician 1 Audio Visual Technician 1 Part -Time Assistant City ManagerI I I Management Assistant .5 m 1 Assistant to the City Manager 1 Administrative SecretaryI Intern .5 CITY ADMINISTRATION DIVISIONS CITY ADMINISTRATION 001-1501-413 PIO 001-1530-413 City of Nlen Page 24 FY 2002 Budget FUND DEPARTMENT DESCRIPTION CITY ADMINISTRATION The City Manager serves under the policy direction of the City Council and is responsible for making recommendations to the Council concerning policies and programs and developing methods to insure the efficient operation of city services. The office of the City Manager coordinates and administers the implementation of ordinances, policies and procedures that will provide for the orderly, positive and planned growth and development of the City of Allen. PROGRAM NARRATIVE Accomplishments for FY 2001: Planned for the construction of various City facilities including the Central Fire Station/Fire Administration, expansion of the Police Department, and Library. 4 -Facilitated agreements between the City, Allen Economic Development Corporation and Hilton Hotels to ensure the groundbreaking for a six -story, 150 room Hotel. 6• Prepared the annual budget with a reduction of the tax rate for the ninth consecutive year. 6• Continued partnership efforts between the City and AISD through regularly scheduled TRIAD meetings and the creation of a committee to analyze possible partnership opportunities. S Continued to research the feasibility of obtaining public transportation in the City of Allen. Objectives for FY 2002: Maintain fiscally responsible policies and procedures to continue to operate the City of Allen in a cost efficient manner. ❖ Continue to execute the policies and directives of the City Council in the areas of communications and City operations. Continue to offer employees professional growth and development opportunities while identifying outlets to celebrate organizational successes. ❖ Encourage creativity, flexibility and accessibility in responding to customers' requests. Enhance citizen communications through the web site, newsletters, and town hall meetings to provide timely information to citizens regarding service delivery options, planning and development initiatives and current events. City of Allen Page 25 FY 2002 Budget ' FUND GENERAL FUND DEPARTMENT CITY ADMINISTRATION 425,949 ACCOUNT 001-1500-413 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGE T 2000-2001 AMENDED 2001-2002 BUDGET Cl ASSIFICATION Personnel Services 453,254 551,228 510,673 586,084 Operations 81,382 79,403 85,547 83,479 Professional Services 4,020 3,350 4,943 1,350 Capital DEPARTMENTTOTAL $ 538,656 $ 633,981 $ 601,163 § 670,913 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUD(' T 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME City Manager 1 1 1 1 Assistant to the City Manager 1 1 1 1 Management Assistant 1 1 1 1 Executive Secretary 0 1 1 1 Administrative Secretary 2 1 1 1 Receptionist 1 1 0 0 Audio Visual Technician 1 1 1 1 Video Technician 0 0 0 1 Public Information Officer 1 1 1 1 TOTAL FULL TIME 8 8 7 8 PART TIME 0 Intern PIO .5 .5 .5 Intern City Manager's Office 0 .5 .5 .5 Temporary Assistant City Manager .5 .5 .5 .5 TOTAL PART-TIME 1 1.5 1.5 1.0 EXPENDITURE DETAIL 1999-2000 2000-2001 2000-2001 2001-2002 Salaries 348,703 425,949 392,720 452,947 Longevity 1,548 1,064 688 992 Overtime 5,276 3,060 4,923 4,923 Deferred Compensation 5,627 4,242 6,906 6,819 FICA Expenses 23,274 33,087 28,419 34,294 TMRS Expenses 37,123 41,540 36,128 40,075 Workman's Comp Expenses 718 942 1,091 1,214 Health Insurance 22,657 32,543 30,286 35,097 Dental Insurance 1,733 2,067 2,448 2,682 Long -Term Disability 875 1,017 971 984 Life Insurance 320 317 693 657 Car Allowance 5,400 5,400 5,400 5,400 SUBTOTAL $ 453,254 $ 551,228 $ 510,673 $ 586,084 City of Allen Page 26 FY 2002 Budget FUND GENERAL FUND DEPARTMENT CITY ADMINISTRATION ACCOUNT 001-1500-413 EXPENDITURE DETAIL - cont. 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET OPERATING XP NSS Conferences & Training 10,979 13,954 9,982 14,900 Dues & Subscriptions 3,361 4,782 4,688 6,995 Mileage 178 850 630 860 Telephone 6,048 5,870 4,680 - Insurance 1,988 2,870 2,870 Postage & Freight 9,711 15,224 12,963 - Printing & Reproduction 15,341 14,724 14,501 27,224 Advertising 1,166 2,408 928 1,000 Board/Commission Training - 1,224 1,200 3,400 Miscellaneous Oper. Exp. 1,669 4,807 2,904 800 Office Supplies 3,690 4,295 8,052 7,600 Computer Supplies 303 2,000 448 500 Small Tools & Minor Equip 26,441 6,204 21,701 20,200 Equipment Maintenance 508 102 - - Radio Maintenance - 89 - - SUBTOTAL $ 81,382 $ 79,403 $ 85,547 $ 83,479 PROFFSSIQNAI SERVICES Professional Services 4,020 3,000 4,673 1,000 Computer Services - 350 270 350 SUBTOTAL $ 4,020 $ 3,350 $ 4,943 $ 1,350 DEPARTMENT TOTALS $ 538,656 $ 633,981 $ 601,163 $ 670,913 CAPITAL EXPENDITURES LIST No capital outlay for this department City of Allen Page 27 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 Cly Manager ITMa 8p 1 IT Tobick AXklysl IT specialist Piopmm f Telecom 1 1 1 Amlysf Technician 1 1 INFORMATION TECHNOLOGY (IT) DIVISIONS IT ADMINISTRATION 001-1610-413 IT INTERNAL ITEMS 001-1620413 City of Allen Page 28 FY 2002 Budget DEPARTMENT ACCOUNTI FUND IT 001-1600.413 DEPARTMENT DESCRIPTION The I.T. (Information Technology) Department provides support to internal computer users so they can perform their daily job duties. I.T. also provides support to Emergency Services dispatching systems for continued support to the community. PROGRAM NARRATIVE Accomplishments for FY 2001: Developed a disaster recovery plan for the Information Technology Department by establishing guidelines to follow in the event of a natural disaster or any type of disaster for all city network equipment. The plan will also include how to establish a temporary network in the event that any city building is seriously damaged. Installed a new NT server to support space allocation needs for GIS and CAD information. Researched the feasibility of connecting the network to new city buildings including Central Fire, Library facility, and Don Rodenbaugh Natatorium. ❖ Installed an HTE Purchasing/Inventory System to support the newly developed Purchasing department. ❖ Installed HTE QREP, which is a reporting system for the AS/400. Avg. Number of Days to Resolve IT Requests 1998 1999 2000 2001 Objectives for FY 2002: Complete connectivity of Don Rodenbaugh Natatorium, New Central Fire Station and prepare for connections of New Library and Fire Station 5. Install a Citrix Server to reduce costs on installing desktop computers for users that do not require a full computer system. ❖ Complete upgrade from Windows 95/98/NT to Windows 2000 professional. Upgrade all workstations from Microsoft • Office 97 to Microsoft Office 2000 Professional. Upgrade from IBM's Office Vision product to HTE Document Management solution for Code Enforcement letters and Building Code letters. Hire a Programmer Analyst at mid -year to • develop e -government initiatives for Internet transactions, and to support user modifications of the city's software programs. e Hire a technician for support of Library activities on weekends, plus support of telephone equipment, lines, telephone sets, cellular phones and pagers. Major Budget Items: ❖ Cost associated with installing a new Citrix Server ($20,000). r Upgrade of Microsoft Office from version 97 to 2000 professional ($49,000). S Connectivity of all newly constructed facilities. City of Allen Page 29 FY 2002 Budget 7 FUND DEPARTMENT 19,650 19,650 At:L.UONI GENERAL FUND IT 810 810 001-1600-413 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET Cl ASSIFICATION Personnel Services 173,902 199,673 214,351 290,571 Operations 229,683 383,149 .370,598 429,835 Professional Services 32,326 21,000 21,000 21,000 Capital 47,603 20,000 23,800 29,550 DEPARTMENTTOTAL $ 483,514 11 580 770,955 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME IT Technician 1 1 1 1 IT Specialist 1 1 1 1 Programmer Analyst 0 0 0 1 Telecom Technician 0 0 0 1 AS/400 Analyst 1 1 1 1 IT Manager 1 1 1 1 TOTAL FULL TIME PARTTIME 0 0 0 0 TOTAL PART-TIME EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 MIDGET 2000-2001 AMENDED 2001-2002 BUDGET PFRSONNFI SERVICES Salaries 130,355 151,680 157,728 212,964 Longevity 100 276 284 500 Overtime 6,576 6,000 8,236 8,236 FICA Expenses 10,335 11,508 12,502 16,121 TMRS Expenses 14,419 15,995 16,322 21,137 Workman's Comp Expenses 399 636 1,006 663 Health Insurance 10,317 12,027 16,078 27,947 Dental insurance 924 1,033 1,426 2,060 Long -Term Disability 359 412 437 576 Life Insurance 118 106 332 366 SUBTOTAL 173,902 199,673 214,351 $ 290,571 :rences & Training 24,156 19,650 19,650 18,950 & Subscriptions 887 810 810 810 ge - 500 500 500 hone 21,459 47,780 47,780 58,900 ance 1,280 1,300 1,500 - ige & Freight 19 1,204 1,204 - ng & Reproduction 25 300 300 300 als/Leasing 361 580 580 100 )ase Services 4,569 9,900 9,900 4,160 ester Costs 115,407 216,010 225,599 257,180 Aaneous Oper. Exp. 105 175 175 175 City of Allen Page 30 FY 2002 Budget FUND GENERAL FUND DEPARTMENT IT ACCOUNT 001-1600413 EXPENDITURE DETAIL -cont. 1998-99 ACTUAL 1999-00 BUDGET 1999-00 AMENDED 2000-01 BUDGET OPERATING EXPENSES - cont. Office Supplies 602 1,820 1,820 1,170 Computer Supplies 7,835 12,480 17,980 62,140 Small Tools & Minor Equip 44,839 57,740 25,000 - Computer Maintenance 8,138 12,900 17,800 25,450 SUBTOTAL $ 229,683 $ 383,149 $ 370,598 $ 429,835 PROFESSIONAL SERVICES Professional Services 32,326 21,000 21,000 21,000 SUBTOTAL S 32,326 $ 21,000 $ 21,000 $ 21,000 CAPITAL OUT Office Equip & Furniture 47,603 20,000 23,800 29,550 SUBTOTAL $ 47,603 $ 20,000 $ 23,800 $ 29,550 DEPARTMENTTOTALS CAPITAL EXPENDITURES LIST 2001-2002 BUDGET OTHER CAPITAL Citrix Server 20,000 Office Equipment & Furniture 9,550 SUBTOTAL 29,550 TOTAL CAPITAL City of Allen Page 31 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 Director 1 Risk Manager Adminisl[AeSecrefary HR Generalist 1 1 1 PERSONNEL DIVISIONS PERSONNEL 001-1700-414 City of Allen Page 32 FY 2002 Budget IEUND DEPARTMENT ACCOUNTI ENERAL FUND PERSONNEL 001-1700-414 DEPARTMENT DESCRIPTION The City of Allen Personnel Department works in partnership with the City's management staff to effectively utilize and manage the organization's employee workforce and human resources. The Department provides management expertise in manpower planning, compensation and benefits planning, diversity and employee relations issues, training, and long-range human resources planning. PROGRAM NARRATIVE Accomplishments for FY 2001: ❖ Hired a Risk Manager and began development and implementation of an organization -wide risk program. ❖ Launched Un -Reimbursed Medical Expense and Dependent Child Care enhancements to Section 125 program. ❖ Facilitated Employee Day at the Park. f• Worked with the Fire Department to develop more consistent hiring procedures. ❖ Updated the Equal Employment Opportunity Plan (EEOP) for the Allen Police Department and Department of Justice. Objectives for FY 2002: S• Research and implement opportunities to enhance the City's relative market standing with respect to our total compensation strategies allowing the City to recruit and retain the most qualified individuals. ❖ Continue to develop and implement an organization -wide diversity initiative, including recruiting, training, and employee relations. S• Enhance the training program for department heads, supervisors, and employees. S• Offer a new safety incentive program for employees to reduce the number of on- the-job injuries and the associated risk ($17,400). :• Develop ana implemenr a wanness f• Worked with various departments in program for City of Allen employees. resolving employee relations issues. ❖ Assisted the Finance and Planning Departments in hiring key positions. Facilitated Breakfast with the City Manager meetings with employees. :• Conducted training programs on the performance review process, time management, and dealing with difficult people. City of Allen Page 33 FY 2002 Budget ' FUND DEPARTMENT 15,000 5,608 ACCOUNT GENERALFUND PERSONNEL 6,325 001-1700414 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET A IGLU ICATIraN Personnel Services 139,703 223,624 194,084 229,133 Operations 77,303 97,857 124,629 121,558 Professional Services 35,490 49,000 48,636 64,600 ,Capital - -- 1,500 - DEPARTMENT TOTAL $ 252,495 $ 370,481 $ 367,349 $ 415,291 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME Director 1 1 1 1 Personnel Technician* 1 0 0 0 HR Generalist 0 1 1 1 Risk Manager 0 1 1 1 Administrative Secretary 1 1 1 1 TOTAL FULL TIME 3 4 4 4 PART TIME 0 0 0 0 TOTAL PART-TIME 0 0 0 0 "Moved to Self -Insurance Fund EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 @UDSET PERSONNEL SERVICES Salanes 110,625 175,081 155,680 181,766 Longevity 208 252 252 404 Overtime 165 258 258 258 FICA Expenses 8,497 13,454 11,864 13,797 TMRS Expenses 11,678 18,393 15,223 17,543 Workman's Comp Expenses 200 317 343 401 Health Insurance 7,117 14,150 8,838 12,692 Dental Insurance 742 1,034 1,016 1,466 Long -Term Disability 309 473 345 493 Life Insurance 162 212 265 314 SUBTOTAL $ 139,703 $ 223,624 $ 194,084 $ 229,133 Tuition Reserve 5,276 15,000 5,608 6,000 Conferences & Training 4,757 6,325 7,106 8,875 Dues & Subscriptions 3,018 3,105 4,125 4,248 Mileage 151 450 450 450 Telephone 1,900 2,150 602 - Insurance 701 745 1,289 - Postage & Freight 1,454 1,500 1,543 - Printing & Reproduction 105 500 2,388 1,000 Advertising 37,340 25,000 52,000 53,000 City of Allen Page 34 FY 2002 Budget FUND OENERALFUND DEPARTMENT PERSONNEL ACCOUNT 001-1700-414 EXPENDITURE DETAIL cont. 1999-2000 2000-2001 ACTUAL RUDGFT 2000-2001 AMENDED 2001-2002 BUDGET OPFRATING EXPENSES -cont Miscellaneous Oper. Exp. 2,273 1,000 1,674 1,000 Office Supplies 2,131 2,500 2,500 3,000 Miscellaneous Supplies 4,599 10,000 9,500 15,000 Small Tools & Minor Equip 144 10,632 11,057 1,485 Unemployment Claims 2,154 6,000 3,021 6,000 Employee Recognition 11,301 12,950 21,766 21,500 SUBTOTAL $ 77,303 $ 97,857 $ 124,629 $ 121,556 PROFESSIONAL SERVICES Professional Services 35,490 49,000 48,636 64,600 SUBTOTAL $ 35,490 $ 49,000 $ 48,636 $ 64,600 DEPARTMENT TOTALS $ 252,495 $ 370,481 $ 367,349 $ 415,291 CAPITAL EXPENDITURES LIST No capital outlay for this department City of Allen Page 35 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 No Personnel in this Department INTERNAL SERVICES DIVISIONS INTERNAL SERVICES 001-1800-415 I, City of Allen Page 36 FY 2002 Budget FUND DEPARTMENT ACCOUNT GENERAL FUND INTERNAL SERVICES 001-1800-415 DEPARTMENT DESCRIPTION The Internal Services budget, administered by the City Managers Office, captures expenses that are shared between many departments. Highlights of some of the items included in this fund are as follows: ¢• Professional Services fees for City Attorney, annual audit, tax appraisal and tax collection services. i• Copier services including monthly lease fees and maintenance. ❖ Salary increases for general fund employees. f• Costs associated with City of Allen Strategic Planning. ❖ Costs associated with conducting a comprehensive plan study, auditing franchise fees, fleet maintenance study and a compensation plan study. City of Allen Page 37 FY 2002 Budget FUND GENERAL FUND DEPARTMENT INTERNAL SERVICES ACCOUNT 001-1800-415 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services - 1,136,729 - 978,534 Operations 821,504 374,563 1,334,163 1,349,882 Debt Payments - - 303,207 363,648 Professional Services 363,294 289,641 456,977 419,112 Capital 745,684 30,000 30,000 - DEPARTMENT TOTAL ; 1,930,481 $ 1,830,933 $ 2,124,347 $ 3,111,376 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 1311DGET PERSONNEL SERVICES Salary Reserve' - 842,870 - 978,534 2000 Police Grant Contingency 293,859 - SUBTOTAL $ - $ 1,136,729 $ - S 978,534 OPERATING EXPENSES Conferences & Training - - - - Dues &Subscriptions 1,290 3,121 3,121 8,100 Telephone - - - 119,857 Postage & Freight - - - 42,166 Insurance - - - 119,719 Miscellaneous Oper. Exp. 43 51,6430 68, 85,000 68,500 Office Supplies - - 5,000 12,000 Small Tools & Minor Equip - - - Equipment Maintenance - - - Computer Maintenance - - - Building Maintenance 8,743 - - Prior Year Tax Refund - 3,000 19,221 - Strategic Planning Exp. 26,190 285,012 280,012 349,540 Historic Structure Relocation - 15,000 15,000 30,000 Arbitrage Rebate Study 2,311 - - - Operating Transfer Out 731,327 926,809 600,000 SUBTOTAL $ 821,504 $ 374,563 $ 1,334,163 $ 1,349,882 City of Allen Page 38 FY 2002 Budget FUND GENERAL FUND DEPARTMENT INTERNAL SERVICES ACCOUNT 001-1800-415 EXPENDITURE DETAIL - cont. 1999-2000 ACTUAL 2000-2001 j3UDGET 2000-2001 AMENDED 2001-2002 BUDGET PROFESSIONAL SERVICES Audit Fees 23,500 28,840 33,750 40,250 Tax Service-AISD/Collin County 48,753 15,000 14,199 15,000 Tax Service -CAD 83,064 95,801 94,028 85,662 Retainer Fee -City Attomy 143,658 110,000 200,000 163,200 Other Legal Fees - - 50,000 50,000 Professional Services 25,767 - - - Computer Services 8,142 - - - Copier Service 30,409 40,000 65,000 65,000 SUBTOTAL $ 363,294 $ 289,641 $ 456,977 $ 419,112 DEBT PAYMENT¢ Chelsea Loan Payments - - 303,207 363,848 SUBTOTAL $ - $ - $ 303,207 $ 363,848 CAPITAL OUTLAY Office Equip & Furniture 745,684 30,000 30,000 SUBTOTAL-$-- 745,684 $ 30,000 $ 30,000 $ DEPARTMENT TOTALS $ 1,930,461 $ 1,830,933 $ 2,124,347 $ 3,111,376 ' Salary Reserve is transferred to each department as part of the pay plan adjustment CAPITAL EXPENDITURES LIST No capital outlay for this department City of Allen Page 39 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 Chief of Police 1 Assistant Police Chief Emcutive Secretary + + Amounting Inspectional Services Unit Assistant II 2 + Chaplain Support Service. Captain CID Captain Patrol Captain + + t DispatcM1 Department Secretary Department Secretary ++ Dispasher + + Remrtla Criminal A -W etcM1 1 Gima Analyst Investigation 3 Sergeants 3 Clarks +Sergeant 4 Corporals 4 Ima.tige[ore +O Officer Animal Control Narmtica B -W etch 1S upaisor 2 Invastigators 2 Sargean<a 2 Animal Control Officer. 4 Corporal' + Sh eltar Attendant +0 Officers ------------- ..at Maintenance Community Relations C -Watch + Service TBCM1nicien + Sargeant 2 Sergeant. 4 Officers 4 Corporals 9 Officer Jailers School Resource Traffic 2 + Sargeant 2 Officers e Officer Public Safety Sysbm K -g Administrator + Sargeant + + Ke Officer POLICE DIVISIONS ADMINISTRATION 001-2010-421 CRIMINAL INVESTIGATIONS 001-2020-421 SCHOOL RESOURCE OFFICER 001-2021-421 GRANT SCHOOL RESOURCE OFFICER 001-2022-421 PATROL 001-2030-421 1998 GRANT 001-2031-421 1999 GRANT 001-2032-421 SUPPORT SERVICES 001-2040-421 City of Allen Page 40 FY 2002 Budget FUND DEPARTMENT ACCOUNT GENERAL FUND POLICE 001-2000-421 DEPARTMENT DESCRIPTION 4 Reduced drug use in Allen through The City Charter provides for the Allen Police investigation and prosecution of individuals Department to preserve order within the city limits responsible for sales and distribution of illegal and secure the residents from violence and property narcotics. loss. PROGRAM NARRATIVE Accomplishments for FY 2001: P Began construction on the addition to the police department building. h Received several new grants including a Technology Grant, Equipment Grant, S.T.E.P. Grant, Vest Grant, and other grants are pending. Total applied for is approximately $414,500. C• Established Criminalist position and crime scene lab. s Reduced complaints against police department personnel by providing approved training, policy development, and continuing to enhance community -policing philosophy. S Expanded the Citizens Police Academy, the Citizens on Patrol (COP) and Police Explorer programs through additional training and member involvement. S Established the Volunteer in Policing (VIP) program with 10 VIP members, 22 COP members and 20 COP trainees who have donated 1,701.5 hours (year to date) of service. e> Identified and evaluated the needs of citizens and developed contingency plans for providing services during the renovation of the police building by staffing the front desk with volunteers and maintaining easy access to the building. Total Calls for Service 1997 1998 1999 2000 2001` • Proyecfions for 300/ (firs( six months data/ City of Allen Objectives for FY 2002: 8 Expand and improve communication in all divisions among all staff by initiating new methods of sharing information and ideas. 4 Develop and initiate a Career Development Plan for all current and future employees to chart the shared goals of the agency and the employee. J Improve interdepartmental cooperation on community programs e Enhance neighborhood livability and safety by the integration of public safety personnel in the design process. Improve police involvement in the planning of special events throughout the community. } Develop and enhance standards for quality police protection. Major Budget Items FY 2002: Four replacement patrol vehicles, one new patrol vehicle, and two new CID vehicles Two additional Traffic Motorcycles and related equipment Microwave antenna system. Hand held radar/ Laser Radar r Portable radios r MP4 Camera 1000 Page 41 800 600 400 200 0 Index Crimes 1997 1999 1999 2000 2001• ■Murder ■Raps ■Robbery ❑Asssuit ■Burpkry Theft ■Auto T. FY 2002 Budget ' FUND DEPARTMENT ACCOUNT GENERAL FUND POLICE 001-2000-421 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services 4,341,030 4,733,645 5,087,362 5,741,354 Operations 656,355 860,345 924,373 885,800 Professional Services 38,565 37,858 37,858 50,053 Capital 199,269 143,919 143,919 137,734 DEPARTMENTTOTAL $ 5,235,220 $ 5,775,767 $ 6,193,512 $ 6,814,941 PERSONNEL SUMMARY 1999-2000 2000-2001 2000-2001 2001-2002 FULL TIME ACTUAL BUDGET AMENDED BUDGET Police Chief 1 1 1 1 Assistant Police Chief 1 1 1 1 Police Captain 3 3 3 3 Police Sergeant 10 10 10 11 Police Corporal 0 0 0 12 Police Officer 52 52 54 51 Police Services Technician 1 1 1 1 Communications Lead Technician 1 1 1 1 Communications Technician 8 10 9 10 Public Safety Systems Administrator 0 0 1 1 Budget Payroll Coordinator 1 1 0 0 Accounting Assistant II 0 0 1 1 Police Records Technician 2 3 3 3 Criminal Analyst Technician 1 1 1 1 Criminalist 1 1 1 1 Department Secretary 2 2 2 2 Administrative Secretary 1 1 1 0 Executive Secretary 0 0 0 1 Jailer 0 0 0 2 Animal Control Supervisor 1 1 1 1 Animal Control Officer 2 2 2 2 Shelter Attendant 1 1 1 1 TOTAL FULL TIME 89 92 94 107 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED_ 2001-2002 BUDGET PERSONNEL SERVI C Salaries 3,126,262 3,455,823 3,652,637 4,153,714 Field Training Officer Pay 11,607 12,000 11,139 10,832 Dispatch Trainer Pay 325 800 1,648 1,805 Longevity 20,262 22,396 22,316 22,828 Overtime 171,325 124,745 173,480 124,745 FICA Expenses 248,800 269,721 285,600 314,201 TMRS Expenses 350,766 378,598 374,432 408,024 Workman's Comp Expenses 73,073 79,592 102,115 114,022 City of Allen Page 42 FY 2002 Budget FUND GENERAL FUND DEPARTMENT POLICE ACCOUNT 001-2000421 EXPENDITURE DETAIL - cont 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PERSONNEL SERVI - cont Health Insurance 289,782 336,048 395,915 495,152 Dental Insurance 21,597 23,768 32,775 39,244 Long -Term Disability 8,530 9,619 9,770 14,282 Life Insurance 2,351 2,535 4,874 5,191 Clothing/Comp Allowance 16,350 18,000 20,661 37,314 SUBTOTAL $ 4,341,030 $ 4,733,645 $ 5,087,362 $ 5,741,354 OPERATING XPENSES Conferences & Training 25,246 30,600 30,600 31,212 Dues & Subscriptions 4,216 5,700 5,700 5,614 Mileage 5 510 510 520 Clothing & Uniforms 35,073 43,895 43,895 67,993 Electricity 52,134 62,424 62,424 63,673 Gas 4,870 7,803 7,803 7,959 Telephone 42,721 39,536 30,000 - Water 2,756 5,202 5,202 5,306 Insurance 53,729 47,064 55,091 - Postage & Freight 5,601 6,630 6,630 7,763 Printing & Reproduction 17,814 24,683 20,483 25,177 Rentals 11,614 19,075 19,075 26,522 Canine Maintenance 4,649 6,705 6,705 6,839 Crime Prevention 14,653 10,404 10,404 10,612 Prisoners Keep 4,551 4,661 4,661 4,754 Computer Costs 15,263 23,000 23,000 - Donation Expenses - - 6,500 6,500 Miscellaneous Oper. Exp. 5,9120 66 6, 6,720 6,242 Narcotics Operations - - 7,500 10,000 Gasoline 60,866 61,100 72,000 115,000 Office Supplies 13,098 13,974 13,974 14,254 Animal Supplies 12,569 13,005 8,000 13,265 Small Tools & Minor Equip 65,468 90,000 82,500 69,375 Building Maintenance 22,793 30,330 34,530 27,061 Vehicle Maintenance 54,763 50,000 100,000 75,000 Equipment Maintenance 14,935 21,990 22,494 22,430 Radio Maintenance 25,043 28,365 28,365 28,361 Operating Transfer Out 85,960 207,569 209,607 234,168 SUBTOTAL $ 656,355 $ 860,345 $ 924,373 $ 885,800 PROFESSIONAL SERVICES Professional Services 38,280 36,658 36,658 48,053 Plaques/Awards/Proclamam 285 1,200 1,200 2,000 SUBTOTAL $ 38,565 $ 37,656 $ 37,868 $ 50,053 City of Allen Page 43 FY 2002 Budget GENERALFUND EXPENDITURE DETAIL - cont. Equip & Furniture iery & Equipment SUBTOTAL DEPARTMENT TOTALS EXPENDITURES LIST ,I Vehicles (Replacement Vehicles) CID Vehicles Patrol Vehicle SUBTOTAL Radios and Batteries Is Unit Radios SUBTOTAL TOTAL CAPITAL POLICE 1999-2000 2000-2001 ACTUAL BUDGET 136,347 127,419 6,389 - 2000-2001 AMENDED 2001-2002 RUDGFT 127,419 116,349 16.500 21,385 QUANTITY 2001-2002 RUQGFT 4 15,512 2 43,000 1 34,037 2 23,800 5 11,385 2 10,000 City of Allen Page 44 FY 2002 Budget CITY OF ALLEN CITY OF ALLEN, TEXAS FY 2001-2002 Director t rtlmnia[ratve Secretary � secretary 11 Conatmction Manager .'ice. Manager Recreatbn Services Menag< 1 1 Urban Forester Athletic Cooltllnstor 1 Landscape/ chlteot 1 Gran t Cooniinator Park Development In spactor Craw Leatler 2 Eq uipmen 'Op --- 1 Maln[ena nca Worker e PARKS AND RECREATION DIVISIONS ADMINISTRATION 001-2510-451 PARKS MAINTENANCE 001-2520-451 ATHLETICS AND RECREATION 001-2540-451 Intern 25 City of Allen Page 45 FY 2002 Budget Horibulture Claw Leader 2 Recreation Center Supe Maur 1 Moilononoe Wo*w 4 Recreation Speclalst II 1 Operations Supervisor 1 Cusludian 1 After School Program Recreation Speclalel II .375 Chemical Specialatl Chemical Technician 2 Maintenance Worker 1 Recre9tlOn Specialst I .]6 1"Wlon Speclelst l I mpation Tech nlcien 1 Maintenance Worker 1 Special Actimbes Coonlinator 1 Park Sp eclat att Perk Tech niclan 1 Maln[e nen ce Worker 1 Cuaural Arta Coortt lnator .375 Athletic Crew Leatl art Maintenance Worker4 Senbr Citizona Coordinator 1 Turf Gras- EquipmeMOperator 1 Ma dcetilg Coardl nator Op aratlone Supe Me. 1 Landscape/ chlteot 1 Gran t Cooniinator Park Development In spactor Craw Leatler 2 Eq uipmen 'Op --- 1 Maln[ena nca Worker e PARKS AND RECREATION DIVISIONS ADMINISTRATION 001-2510-451 PARKS MAINTENANCE 001-2520-451 ATHLETICS AND RECREATION 001-2540-451 Intern 25 City of Allen Page 45 FY 2002 Budget FUND DEPARTMENT ACCOUNTI GENERAL FUND PARKS & RECREATION 001-2500-451 DEPARTMENT DESCRIPTION The Park & Recreation Department strives to provide park facilities and recreation programs that enhance the aesthetic value of the City and help our citizens more fully enjoy living in Allen. Mission statement: 'To establish a Parks and Recreation system for our citizens that provides them with a source of pleasure, promotes economic development, minimizes demands on valuable City resources, and instills pride in those who make it happen." DEPARTMENT NARRATIVE Awards ❖ Texas Gold Medal Award, Texas Recreation and Parks Association ❖ Award of Excellence, American Society of Landscape Architecture Attendance Award, Texas Amateur Athletic Association f• Board -Commission Award, National Recreation and Parks Association Accomplishments for FY 2001: ❖ Obtained $1,020,000 in grants for park development ($500,000), land acquisition ($500,000) and operations ($20,000). Developed the Don Rodenbaugh Natatorium, two parks at Lost Creek, Suncreek Park, Glendover Park, Bethany Ridge Park, and the DaySpring Nature Preserve. ❖ Acquired the Baptist Camp, Estevie Property, Twin Creeks Greenbelts, LLC Greenbelts, Bridgewater Crossing Greenbelts, Lost Creek Park and the Bluffs at Lost Creek. :• Updated the Tree Preservation Ordinance. :• Implemented the first phase of the Centralized Irrigation System. Initiated the Urban Forestry Program, which is the first step in creating a greenbelt management program. Reduced mowing cycle from 8.6 days to 6.5 • days per cycle. Hired full time Senior Coordinator and increased the Senior Center operating hours from 10 hour to 25 hours per week. ❖ Implemented the Youth After-school program and the Xtreme Teen program. :• Hired the department's first Cultural Arts Specialist and Marketing Coordinator. Objectives for FY 2002: Acquire Twin Creeks Community parkland, Twin Creeks Phase VII, Twin Creek PD 88 NPs, and Watter's Branch greenbelt. Develop Malone Community Park, Story Park, Train Depot; design Phase II and III of Allen Station Park; and plan for renovation of Central Fire Station to a Senior Citizen Center. Create an Adopt -A -Park program for parks and facilities using volunteers and sponsors. Continue Centralized Irrigation Control System and implement a computerized lighting system. :• Increase programs available to seniors, • teens, and adult athletics. Developing concept/plan for new Citywide Special Event. Form a partnership with the Allen Chamber of Commerce, ACO, and the symphony boards to offer Citywide programs. Major Budget Items: Chemical Crew, Mowing Maintenance Crew • and Updated equipment added to Operations. Enhance median maintenance program ($24,000) and entryway renovations ($20,000). City of Allen Page 46 FY 2002 Budget ' GENERAL FUND PARKS S RECREATION 1,800,152 1,172,135 465,102 136,332 3,573,721 001-2500451 2,187,926 1,416,008 429,079 202,375 ; 4,235,388 PERSONNEL SUMMARY 1999-2000 2000-2001 EXPENDITURE SUMMARY 1999-2000 2000-2001 2000-2001 2001-2002 Personnel Services Operations Professional Services Capital DEPARTMENT TOTAL ; 1,201,356 878,718 247,169 159,533 2,486,776 ; 1,800,152 1,172,135 465,102 136,332 3,573,721 1,875,363 1,211,710 349,102 198,481 ; 3,634,656 2,187,926 1,416,008 429,079 202,375 ; 4,235,388 PERSONNEL SUMMARY 1999-2000 2000-2001 2000-2001 2001-2002 FULL TIME ACTUAL BUDGET AMENDED BUDGET Director 1 1 1 1 Grant Coordinator 1 1 1 1 Landscape Architect* 0 1 1 1 Administrative Secretary 1 1 1 1 Department Secretary 0 1 1 1 Park Services Manager 1 1 1 1 Urban Forester 0 1 1 1 Park Operation Supervisor 2 2 2 2 Parks Development Inspector 1 1 1 1 Equipment Operator 1 1 1 2 Crew Leader 4 4 4 5 Park Technician 1 1 1 1 Maintenance Worker 12 16 16 19 Chemical Specialist 0 1 1 1 Chemical Technician 1 1 1 2 Park Specialist 0 0 0 1 Irrigation Specialist 1 1 1 1 Irrigation Technician 1 1 1 1 Athletic Cordinator 1 1 1 1 Recreation Services Manager 1 1 1 1 Special Event Coordinator 1 1 1 1 Seniors Citizens Coordinator 1 1 1 1 Recreation Center Supervisor 1 1 1 1 Recreation Specialist II 1 1 1 1 Custodian 1 1 1 1 Marketing Coordinator ** 0 0 0 1 TOTAL FULL TIME 35 43 43 51 PART TIME Maintenance Worker .75 0 0 0 Intem .25 .25 .25 .25 Cultural Arts Coordinator 0 .375 .375 .375 Recreaction Specialist II -ASP 0 .375 .375 .375 Recreation Specialist I -ASP 0 .75 .75 .75 TOTAL PART-TIME 1.0 1.75 1.75 1.75 • 25% of Expenses Funded in the General Fund '• Moved from Aquatics Enterprise Fund FY 2001-2002 City of Allen Page 47 FY 2002 Budget 3ENERAL FUND PARKS & RECREATION 001-2500-4b1 EXPENDITURE DETAIL 1999-2000 2000-2001 2000-2001 2001-2002 R ONNFF�OE. 20,541 28,434 27,934 31,931 Salaries 875,252 1,300,438 1,359,513 1,576,481 -ongevity 5,160 5,584 5,508 7,144 Dvertime 36,097 46,933 46,933 46,933 FICA Expenses 67,648 100,756 103,115 117,499 I'MRS Expenses 96,120 136,789 134,025 150,371 Workman's Comp Expenses 15,418 23,061 29,020 32,467 Health Insurance 95,686 170,939 177,452 232,996 Dental Insurance 6,863 10,919 14,061 17,560 Long -Term Disability 2,308 3,509 3,525 4,052 Life Insurance 804 1,224 2,211 2,423 SUBTOTAL $ 1,201,356 E 1,800,152 $ 1,875,363 $ 2,187,926 Conferences &Training 20,541 28,434 27,934 31,931 Dues & Subscriptions 3,530 4,662 5,162 7,508 Mileage 9,060 10,014 7,264 6,141 Clothing &Uniforms 5,965 10,682 11,182 19,303 Electricity 147,604 126,524 126,524 129,054 Telephone 22,341 24,256 12,200 - Water 216,620 257,706 257,706 312,860 Insurance 14,750 14,808 18,769 - Postage & Freight 6,492 7,491 9,991 - Printing & Reproduction 13,818 23,247 22,247 23,550 Advertising 2,407 9,953 8,953 10,152 Rentals 4,491 6,822 5,822 41,457 Senior Citizens Support 7,090 18,203 18,203 18,567 Meetings & Receptions 1,453 2,692 2,792 3,584 Board/Commission Training 511 1,000 4,320 5,860 Cemetery Expenditures 10,270 46,244 46,244 47,168 Miscellaneous Oper. Exp. 17,478 1,000 1,000 1,000 Gasoline 12,005 17,164 16,664 19,607 Oil & Lubricants 1,182 2,371 2,371 2,818 Office Supplies 7,554 17,736 16,856 17,156 Boards & Commissions 240 700 700 700 Miscellaneous Supplies 4,706 4,684 5,203 5,821 Mechanical Supplies 18 778 778 - Janitorial Supplies 8,465 12,573 11,573 15,140 Medical & Chemical Supply 862 5,402 4,402 14,850 Chlorine Gas 4,328 Pool Supplies 6,061 - - - Agriculture Supplies 84,320 141,485 141,485 168,314 Small Tools & Minor Equip 20,638 41,129 40,629 45,000 Minor Equipment-Ballfield 6,151 11,393 11,393 - Minor Equipmt-Recreation 3,192 5,061 5,061 5,162 Building Maintenance 15,635 49,974 97,363 59,183 Vehicle Maintenance 9,734 10,008 9,508 10,048 Equipment Maintenance 16,899 13,568 17,885 27,358 n11 � vga i 1m - City of Allen Page 48 FY 2002 Budget ' FUND GENERAL FUND DEPARTMENT PARKS & RECREATION ACCOUNT 001-2500-451 EXPENDITURE DETAIL - cont. 1999-2000 2000-2001 ACTUAL BUDGE[ 2000-2001 AMENDED 2001-2002 MIDGET OPERATING EXPENSES - cont Miscellaneous Maintenance 2,868 4,111 1,837 - Ground Sprinkler System 45,341 44,529 44,529 45,419 Ballfield Clay 11,145 9,884 6,884 - Ballfield Maintenance 18,803 26,316 29,316 53,043 Landscaping - 19,455 - - Forestry 24,416 - 21,455 50,384 Pool Maintenance 14,142 - - - Park & Open Space Maint. 13,318 21,895 21,895 71,291 Rock/Sand/Gravel/Cement 803 3,641 3,641 - Street Maintenance 2,505 4,162 4,162 - Operating Transfer Out 38,037 108,610 108,610 146,579 SUBTOTAL $ 878,718 $ 1,172,135 $ 1,211,710 S 1,416,005 PROFESSIONAI SERVICES Professional Services 241,922 452,761 336,761 416,756 Sanitation Services 5,248 12,081 12,081 12,323 Computer Services - 260 260 - SUBTOTAL S 247,169 $ 465,102 $ 349,102 $ 429,079 CAPITAL OUTLAY Buildings 32,900 - - - Vehicles 122,193 80,632 140,576 105,075 Computer Equipment - - - 15,300 Office Equip & Furniture 4,439 - 2,205 - Machinery & Equipment - 19,100 19,100 82,000 Implements - 36,600 36,600 - SUBTOTAL $ 159,533 $ 136,332 $ 198,481 $ 202,375 DEPARTMENT TOTALS $ 2,486,776 $ 3,573,721 $ 3,634,656 $ 4,235,388 2001-2002 CAPITAL EXPENDITURES LIST QUANTITY BUDGET FS VEHICLES Light Duty Pick -Up (Replacement Vehicles) 3 8,075 Heavy Duty Pick -Up 3 68,500 Dump Truck 1 28,500 SUBTOTAL 7 105,075 COMPUTER FOUIPMENT GIS Hardware and Software 15,300 SUBTOTAL 15,300 .:rP SUBTOTAL TOTAL CAPITAL 1 20,000 1 62,000 2 82,000 City of Allen Page 49 FY 2002 Budget CITY OF ALLEN CITY OF ALLEN, TEXAS FY 2001-2002 Director 1 Administrative Secretary 1 Support Services Adult Librarian Children's Manager Supervisor Librarian Supervisor 1 1 1 Circulation Supervisor Librarian Librarian 1 1 1 PT Librarian PT Library Clerks Circulation Clerk 2 .5 1 PT Library Page Children's Clerk PT Library Clerks .75 1 3 Temporary Library Page LibraryAssociate .5 1 Catalog Librarian 1 LIBRARY DIVISIONS LIBRARY 001-3000-455 City of Allen Page 50 FY 2002 Budget FUND DEPARTMENT DESCRIPTION DEPARTMENT LIBRARY The Allen Public Library is dedicated to improving the quality of life of its users by supporting their lifelong learning and information needs. (Mission Statement adopted by Library Board, 1993) PROGRAM NARRATIVE Accomplishments for FY 2001: :• Expanded the partnership with Plano to include twice weekly courier service between Allen Public Library and Plano Public Library for transferring library materials for the convenience of our customers. :• Began offering Internet classes to the public, first with Senior Citizens, later with general public. Hosted six Sunday afternoon concerts in the library, in partnership with Arts Alliance and Friends of the Library. Expanded Internet services from four • workstations to thirteen workstations through Telecommunications Infrastructure Fund grant. Submitted winning proposal to host traveling exhibit from the Smithsonian Institute next spring —Allen will be the only site in Texas to host. Completed search for Architect firm and began development of program and design for new library building. :• Fostered the increased activity and visibility of the Friends organization, leading to Chamber of Commerce Spirit of Allen award and Northeast Texas Library System's Leadership award for that group. Cooperated with Plano Public Library to • accomplish successful migration from Dynix automated library system to Horizon library system (to be completed in August 2001). Objectives for FY 2002: :• Continue to offer citizens library services. :• Continue established relationships and programs with Arts Alliance and Friends group. Complete development of program and design for new library building. 4 Host traveling Smithsonian exhibit "Listening to the Prairie" next spring and solicit involvement from several other area agencies for complementary programs and support. v Expand outreach efforts to both youth and Senior Citizens' populations. :• Improve interlibrary loan services. :• Upgrade and expand media collection. Major Budget Items: On-going costs to purchase library materials ($164,483) and electronic resources ($10,200) for use by library customers. Improve efficiency and effectiveness of library automated services to residents by using laser scanners for checkout of materials and provide receipts to customers ($3,500). Expanded Service Level — Increase number and type of outreach programs ($12, 500). And upgrade interlibrary loan service throughout Southwest region (2,800). Library Materials per Capita loss 1999 2000 7001 City of Allen Page 51 FY 2002 Budget , FUND GENERAL FUND DEPARTMENT LIBRARY ACCOUNT 001-3000-455 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 RUn('FT 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services 637,615 744,881 788,418 830,062 Operations 267,718 284,280 347,426 295,733 Professional Services 18,492 12,200 12,200 8,000 DEPARTMENTTOTAL $ 923,825 $ 1,041,361 $ 1,148,044 $ 1,133,795 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 B D ET FULL TIME Director 1 1 1 1 Support Services Manager 1 1 1 1 Librarian Supervisor 2 2 2 2 Ubrarian 0 2 2 2 Circulation Supervisor 1 1 1 1 Library Associate 1 1 1 1 Administrative Secretary 1 1 1 1 Catalog Librarian 1 1 1 1 Circulation Clerk 1 1 1 1 Childrens Clerk 0 0 0 1 TOTAL FULL TIME 9 11 11 12 PARTTIME Librarian 2.5 2 2 2 Ubrary Clerk 3.5 4 4 3.5 Library Page 0.75 0.75 0.75 0.75 TOTAL PART-TIME 6.75 6.25 6.75 6.25 TEMPORARY Library Page 0.5 0.5 0.5 0.5 TOTALTEMPORARY 0.5 0.5 0.5 0.5 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PERSONNEL RVI C Salaries 515,006 596,184 632,430 656,395 Longevity 3,720 4,234 4,305 5,026 Overtime 64 332 332 332 FICA Expenses 39,495 45,946 48,311 55,611 TMRS Expenses 50,724 59,001 59,052 60,041 Workman's Comp Expenses 1,111 1,285 1,616 1,681 Health Insurance 24,008 33,606 36,904 44,821 Dental Insurance 2,268 2,842 3,605 4,147 Long-Term Disability 896 1,055 1,178 1,277 Life Insurance 323 396 685 730 SUBTOTAL $ 637,616 $ 744,881 E 788,418 $ 830,062 City of Allen Page 52 FY 2002 Budget FUND GENERAL FUND DEPARTMENT LIBRARY ACCOUNT 001-3000-455 EXPENDITURE DETAIL - cont. 1999-2000 2000-2001 2000-2001 2001-2002 BUDGET OPERATING XP N S Conferences & Training ACTUAL 5,027 BUDGET 5,100 AMENDED 5,100 6,500 Dues & Subscriptions 609 875 884 3,700 Mileage 570 700 684 700 Electricity 40,981 38,250 42,810 40,000 Telephone 7,469 8,840 4,816 - Water 336 450 450 450 Insurance 5,482 6,357 5,722 - Postage & Freight 2,768 3,200 2,772 3,000 Printing & Reproduction 591 1,500 1,375 1,500 Rentals 324 1,290 1,216 1,200 Database Services 9,562 13,700 8,629 10,200 Special Activities 8,481 7,500 7,500 10,000 Library Books 108,468 109,725 109,725 104,500 Library Books -County Fund 14,411 15,333 15,333 15,333 Libr.Book-Continuation Fd 7,398 8,650 8,650 11,150 Employee Tenure Pins 15 - - - Audio Visual Expense - - - 20,000 Miscellaneous Oper. Exp. 144 200 197 2,700 Office Supplies 2,094 2,040 3,460 4,000 Computer Supplies 800 820 130 - Periodicals 11,787 12,850 12,850 13,500 Boards & Commissions 264 400 400 800 Miscellaneous Supplies 494 600 16 - Small Tools & Minor Equip 3,817 6,200 15,600 3,500 Library Supplies 7,986 8,150 6,550 8,000 Building Maintenance 10,051 11,700 13,958 17,500 Equipment Maintenance 2,648 2,850 2,850 3,000 Grant Expenses - - 61,867 Book Collection Maint. 395 500 250 500 Computer Maintenance 14,746 16,500 13,632 14,000 SUBTOTAL $ 267,718 $ 284,280 S 347,426 $ 295,733 PROFESSIONAL SERVICES Professional Services 18,492 12,200 12,200 8,000 SUBTOTAL $ 18,492 $ 12,200 $ 12,200 $ 8,000 DEPARTMENT TOTALS $ 923,825 $ 1,041,361 $ 1,148,044 $ 1,133,795 CAPITAL EXPENDITURES LIST No capital outlay for this department City of Allen Page 53 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 Fire Chief t Asst. ChiefAsst. Chief EMS Coordinator Fire Marshall t t EMS Captain Fire Prevention t Specialist t Asst. Chief Administrative Secretary Training Officer t t Battalion Chief Department Secretary t t Captain Captain A Shift I BShift11 C Shift q 4 Apparatus Operator 4 Firefighter/Paramedic Firefighter/EMT 17 Apparatus Operator 4 Firefighter/Paramedic Firefighter/EMT 16 FIRE DIVISIONS FIRE 001-3500-422 Apparatus Operator 4 Firefighter/Paramedic Firefighter/EMT 16 City of Allen Page 54 FY 2002 Budget FUND DEPARTMENT DESCRIPTION FIRE The Allen Fire Department promotes safety by protecting life and property from fire, natural disaster and other emergencies. PROGRAM NARRATIVE Accomplishments for FY 2001: Purchased and placed in service eight new • twelve -lead heart monitor defibrillators to provide more detailed diagnostic functions. There is now one monitor per each ambulance and fire apparatus. 9 Purchased a new Fire Safety House for fire prevention education. The Safety House, funded by CDC, will be placed in service at the National Night Out event August 7, 2001. Provided 780 hours of live Ore training to 65 firefighters at the Collin County Community College facility. Replaced 1000 feet of large diameter fire hose. } Purchased and placed in service self- contained breathing apparatus for all Chief Officers. ❖ Fumished the EOC with used furniture and installed emergency radios, computer and weather radar. Expanded the Learn Not to Bum program to Kerr and Bolin Elementary School. Purchased a new ambulance in December 2000. Additional personnel were hired and trained before the ambulance was placed in service on August 13, 2001. Objectives for FY 2002: :• Minimize the loss of life and property due to fire. Implement a Fire Alarm Permit Process to • decrease false alarm response. O Provide 828 hours of live fire training and required continuing education. 1% Enhance fire safety training and severe weather training to community groups and AISD school children by the use of the new fire safety house. 4 Accomplish the transition to the new Central Fire Station. f• Create career development opportunities by promoting twelve firefighters to Apparatus Operators, and hiring a Battalion Chief. Major Budget Items: 9 Purchase and place in service two emergency staff vehicles ($57,000) T Provide the firefighters with 828 hours of live fire training at the Collin County Community College ($9,000). ee Replace 400 feet of large diameter fire hose ($2,800). Purchase and place in service a hose • coupling machine for repairing fire hose. ($6,500) City of Allen Page 56 FY 2002 Budget ' FUND GENERAL FUND DEPARTMENT FIRE ACCOUNT 001-3500-422 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services $ 3,556,991 $ 3,992,432 $ 4,013,824 $ 4,668,095 Operations 511,564 545,217 559,236 546,393 Professional Services 31,959 36,572 41,571 36,100 Capital 81,432 253,479 346,479 63,500 DEPARTMENTTOTAL $ 4,181,946 $ 4,827,700 $4,961,110 $ 5,314,088 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME Fire Chief 1 1 1 1 Assistant Fire Chief 3 3 3 3 Battalion Chief 0 0 0 1 Fire Captain 13 13 13 13 Apparatus Operator 0 0 0 12 Firefighter 48 55 57 49 Fire Prevention Specialist 1 1 1 1 Department Secretary 1 1 1 1 Administrative Secretary 1 1 1 1 TOTAL FULL TIME 68 75 77 82 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 Q1JQQFT PERSONNEL SERVICES Salaries 2,512,822 2,837,214 2,846,676 3,368,248 Longevity 23,936 27,048 26,712 27,516 Overtime 204,389 227,858 191,925 191,925 FICA Expenses 202,227 228,436 220,180 251,646 TMRS Expenses 288,338 323,016 293,082 329,041 Workman's Comp Expenses 38,499 44,412 51,568 59,533 Health Insurance 259,837 275,733 346,436 396,498 Dental Insurance 17,648 18,472 25,538 30,867 Long -Term Disability 7,345 8,250 7,895 8,781 Life Insurance 1,951 1,993 3,812 4,140 SUBTOTAL $ 3,556,991 $ 3,992,432 $ 4,013,824 $ 4,668,095 OPERATING XP N R Conferences & Training 20,654 22,490 22,490 25,990 Dues & Subscriptions 1,102 2,715 3,715 4,786 Mileage 112 125 1,625 1,500 Worker's Comp Claims - 300 300 300 Clothing & Uniforms 32,3596 46 53, 52,795 57,025 Electricity 20,312 19,000 22,499 24,000 Gas 4,730 7,000 9,000 9,000 Telephone 13,753 15,000 15,000 - City of Allen Page 56 FY 2002 Budget FUND GENERALFUND DEPARTMENT FIRE ACCOUNT 001-3500-422 EXPENDITURE DETAIL - cont 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET OPERATING XP N E -cont. Water 8,849 9,200 7,200 9,200 Insurance 25,809 25,809 30,975 - Postage & Freight 563 1,100 1,100 - Printing & Reproduction 1,440 1,500 1,500 1,500 Rentals 447 500 500 500 Code Enforcement 1,528 2,000 2,000 2,500 Computer Costs - 1,000 1,000 1,000 Employee Tenure Pins - 300 300 300 Miscellaneous Oper. Exp. 398 500 500 - Gasoline 17,949 13,500 16,000 16,500 Oil & Lubricants 1,629 2,000 2,800 3,260 Office Supplies 2,473 2,800 2,800 3,400 Miscellaneous Supplies 506 600 599 - Janitorial Supplies 4,626 3,800 3,800 4,800 Medical & Chemical Supply 45,067 42,200 42,200 43,200 'Chemical Spill Supplies 2,265 3,500 3,501 3,500 Small Tools & Minor Equip 7,630 4,471 4,471 9,271 Building Maintenance 8,667 7,600 7,600 7,600 Vehicle Maintenance 17,603 20,600 20,601 20,600 Equipment Maintenance 3,234 9,000 9,001 9,200 Radio Maintenance 292 2,700 2,700 2,700 Miscellaneous Maintenance - 200 200 - Operating Transfer Out 267,581 270,111 270,464 284,761 SUBTOTAL $ 511,564 $ 545,217 $ 559,236 $ 646,393 PROFESSIONAI SFRVICFS Professional Services 31,959 36,100 41,099 36,100 Computer Services - 472 472 - SUBTOTAL $ 31,959 $ 36,572 $ 41,571 $ 36,100 CAPITAL OUTLAY Vehicles 60,929 123,500 118,500 57,000 Machinery & Equipment 20,503 129,979 227,979 6,500 SUBTOTAL $ 81,432 $ 253,479 $ 346,479 $ 63,500 Utility Vehicle SUBTOTAL Coupling Expander SUBTOTAL TOTAL CAPITAL rir I City of Allen Page 57 FY 2002 Budget , CITY OF ALLEN, TEXAS FY 2001-2002 Chief Building Official 1 Code Compliance Environmental Services Coordinator Coordinator 1 1 Permit Technician 1 Code Enforcement Officer 3 Code Inspectors 7 Residential Plans Examiner 1 Customer Service Representative 2 Receptionist 1 BUILDING AND CODE COMPLIANCE DIVISIONS HEALTH INSPECTION 0014520-460 BUILDING INSPECTION 0014530460 CODE ENFORCEMENT 001-4540-460 City of Allen Page 58 FY 2002 Budget FUND DEPARTMENT ACCOUNT GENERAL FUND BUILDING & CODE COMPLIANCE 001-4500-460 DEPARTMENT DESCRIPTION The Department of Building and Code Compliance is a multi -functional department charged with the responsibility of managing compliance with building codes, zoning ordinances, health and property maintenance. PROGRAM NARRATIVE Accomplishments for FY 2001: ❖ Completed inspections and issued permits for 1785 single-family homes and over 120 businesses, representing the most activity of any previous fiscal year in the City. Adoption of the 2000 International Codes and NCTCOG amendment package in order to promote regional consistency in code administration. Objectives for FY 2002: Process, review and issue single family permits within five working days. ? Process, review, and issue minor permits within two working days. ❖ Average 18 minutes per inspection stop to assure quality. {• All inspectors obtain ICBO certification in their field of expertise to assure the highest quality inspections. ❖ All Code Enforcement Officers become certified pool operators to ensure the highest quality of public and semi-public pool inspection. Respond to expressed desires of contractors and citizens with regard to electronic financial transactions. Major Budget Items: ❖ Two Code Inspector positions will be added to the department in order to provide targeted inspection service levels in response to increase in activity levels. e A new Code Enforcement Officer will be added in order to enhance community appearance and facilitate more emphasis on environmental health issues. Single Family Permits Issued 97-98 98-99 99-00 0841 Permits Issued for Commercial Buildings 97-98 98-99 99-00 00-01 City of Allen Page 59 FY 2002 Budget FUND GENERAL FUND DEPARTMENT BUILDING AND CODE COMPLIANCE ACCOUNT 0014500-460 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services 736,637 658,498 737,662 880,172 Operations 63,108 73,709 76,861 93,820 Professional Services 15,962 1,208 1,260 1,200 Capital 98,029 - - 26,000 DEPARTMENTTOTAL 913,735 733,415 815,783 1,001,192 PERSONNEL SUMMARY 1999-2000 2000-2001 2000-2001 2001-2002 FULL TIME ACTUAL aUI2-QEI AMENDED BUDGET Director 1 0 0 0 Chief Building Official 1 1 1 1 Code Compliance Coordinator 1 1 1 1 Code Inspector 5 5 6 7 Com Dev Project Coordinator 1 0 0 0 Environmental Health Inspector 1 1 0 0 Environmental Services Coordinator 0 0 1 1 Plans Examiner 1 1 1 1 Permit Technician 1 1 1 1 Permit Clerk 1 2 0 0 Customer Service Representatives 0 0 2 2 Cade Enforcement Officer 2 2 2 3 Receptionist* 0 0 1 1 TOTAL FULL TIME 15 14 16 18 * Position moved from City Administration EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 PERSONNEL SERVICES BUDGET Salaries 570,884 502,469 557,802 661,094 Longevity 6,112 3,788 3,084 2,824 Overtime 1,353 1,431 4,859 4,859 FICA Expenses 42,959 37,806 42,114 49,571 TMRS Expenses 60,745 53,028 55,479 64,688 Workman's Comp Expenses 3,093 2,989 3,944 4,293 Health Insurance 45,868 51,645 62,986 83,482 Dental Insurance 3,697 3,617 5,228 6,735 Long-Term Disability 1,498 1,356 1,417 1,739 Life Insurance 426 369 749 887 SUBTOTAL $ 736,637 $ 658,498 $ 737,662 $ 880,172 OPERATING EXPENSES Conferences & Training 5,648 6,058 6,368 7,058 Dues &Subscriptions 2,255 2,170 1,975 2,432 Mileage 4,332 1,820 2,745 1,857 City of Allen Page 60 FY 2002 Budget FUND GENERAL FUND DEPARTMENT BUILDING AND CODE COMPLIANCE - ACCOUNT 0014500-460 EXPENDITURE DETAIL - cont. 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMFNDFD 2001-2002 BUDGET OPERATING EXPENSES - cont. - - SUBTOTAL $ 15,962 $ Clothing & Uniforms 1,100 1,850 2,000 2,647 Electricity 1,140 - - - Gas 680 - - - Telephone 6,839 13,496 9,410 - Water 53 - 4 - Insurance 2,896 4,000 11,821 - Postage & Freight 1,709 1,700 2,173 - Printing & Reproduction 1,315 2,300 2,045 27,391 Advertising 116 300 - - Board/Commission Training 27 200 - - Employee Tenure Pins 15 - - - Miscellaneous Oper. Exp. 920 1,400 - - Gasoline 2,882 6,100 6,144 7,222 Office Supplies 4,503 3,450 1,058 3,979 Miscellaneous Supplies 1,434 325 3,025 3,086 'Small Tools & Minor Equip 3,200 3,635 3,581 5,858 Building Maintenance - - - - Vehicle Maintenance 429 3,075 2,723 4,975 Equipment Maintenance 1,036 1,250 1,209 1,275 Operating Transfer Out 20,580 20,580 20,580 26,040 SUBTOTAL $ 63,108 $ 73,709 $ 76,861 $ 93,820 essional Services 10,796 - - - iputer Services 1,315 1,208 1,260 1,200 Expenditures 3,851 - - SUBTOTAL $ 15,962 $ 1,208 $ 1,260 $ 1,200 ITAL OUTLAY icles 98,029 - 26,000 SUBTOTAL $ 98,029 $ - $ - $ 26,000 DEPARTMENT TOTALS $ 913,735 733,415 815,783 $ 1,001,192 rITAL EXPENDITURES LIST 2001-2002 I1QE5 QUANTITY BUDGET icles 2 26,000 SUBTOTAL 2 26,000 TOTAL CAPITAL City of Allen Page 61 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 Director 1 (Administrative Secretary 1 Assistant Planning Director 1 Planner 2 GIS Administrator 1 Planning Technician 1 Intern .5 PLANNING AND DEVELOPMENT DIVISIONS PLANNING 001-4800-460 City of Allen Page 62 FY 2002 Budget FUND DEPARTMENT ACCOUNT GENERAL FUND PLANNING & DEVELOPMENT 001-4800-461 DEPARTMENT DESCRIPTION The Department of Planning & Development is responsible for land use and transportation planning, zoning administration, development coordination, capital improvement planning and for providing staff support for the Planning & Zoning Commission, the Board of Adjustment, the Sign Control Board and the Allen City Council. PROGRAM NARRATIVE Accomplishments for FY 2001: Updated the Allen Land Development Code. Updated the Thoroughfare Plan. J Completed the Central Business District Plan and regulatory system. J Completed the annexation of five tracts of land; including three "doughnut holes," a portion of a street right-of-way and a tract including four parcels formerly located in the City of Plano. J Completed the Consolidated Alternative Transportation and Recreational Trail Plan. 0i Completed the Street Image Study. 0s Acquired updated digital ortho-photographs and contours and implement Global Positioning Satellite control points. J Acquired digital parcel ownership maps and data. J Completed Regional Transit Feasibility Study. Objectives for FY 2002: J Initiate the implementation of the Central Business District Redevelopment Plan. J Update the Impact Fee Study and Capital Improvement Plan to conform to the new requirements of State law. J Complete Boundary Adjustment Agreements with the towns of Parker and Fairview, and the City of McKinney. Establish comprehensive erosion control regulations utilizing digital elevation models (DEMs). Develop interactive GIS intranet query capability and complete a comprehensive water and sewer map. Complete a Historic Preservation Ordinance and complete the design of the Allen Historic Village. O Update the Comprehensive Plan. ❖ Complete the SH 121 Corridor Plan. Follow-up on the Regional Transit Feasibility Study to determine an implementation plan. i• Complete an alternative transportation/ recreational trails implementation plan. CHy of Allen Page 63 FY 2002 Budget FUND GENERAL FUND DEPARTMENT PLANNING & DEVELOPMENT ACCOUNT 0014800461 EXPENDITURE SUMMARY 1999-2000 ACTURE 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services 308,129 404,205 438,225 464,234 Operations 25,228 58,016 54,633 55,735 Professional Services 3,805 - 6,993 - CapRal - - - 10,710 DEPARTMENT TOTAL $ 337,162 $ 462,221 $ 499,851 $ 530,679 PERSONNEL SUMMARY 1999-2000 2000-2001 2000-2001 2001-2002 FULL TIME ACTUAL BUDGET AMENDED RUDQFT Director 1 1 1 1 Assistant Planning Director 0 0 1 1 Planner 1 1 0 2 Com Dev Project Coordinator 0 1 1 0 Development Coordinator 1 1 1 0 GIS Administrator 0 0 1 1 GIS Coordinator 1 1 0 0 Administrative Secretary 1 1 1 1 Planning Technician 1 1 1 1 TOTAL FULL TIME 6 7 7 7 PARTTIME Intern .5 .5 .5 .5 TOTAL PART-TIME .5 .5 .5 .5 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PERSONNEL SERVI Salaries 244,803 317,473 340,889 366,456 Longevity 1,208 2,000 2,004 2,336 Overtime 818 1,513 1,308 1,308 FICA Expenses 18,564 24,375 26,098 27,962 TMRS Expenses 25,752 33,543 33,016 35,562 Workman's Comp Expenses 632 790 1,042 1,118 Health Insurance 14,311 21,578 29,909 25,584 Dental Insurance 1,216 1,809 2,517 2,472 Long -Term Disability 614 834 934 967 Life Insurance 211 290 508 469 SUBTOTAL $ 308,129 $ 404,205 $ 438,225 $ 464,234 OPERATING XP NC c Conferences & Training 3,059 5,200 4,924 10,300 Dues & Subscriptions 1,123 1,723 1,723 3,155 Mileage 341 730 730 750 Telephone 2,699 2,500 2,414 - insurance 1,221 1,250 1,595 - Postage & Freight 575 750 750 - Printing & Reproduction 3,827 11,000 13,300 15,000 Advertising 543 300 200 500 :ity of Allen Page 64 r T zuu[ cuagec FUND GENERAL FUND DEPARTMENT PLANNING & DEVELOPMENT ACCOUNT 0014800-461 EXPENDITURE DETAIL -cont. 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGE T OPERATING XP Ncont Board/Commission Training - 3,213 1,513 2,000 Plat Administration Exp 2,754 3,000 2,727 3,000 Miscellaneous Oper. Exp. 70 100 100 1,500 Office Supplies 2,387 3,500 3,500 3,500 Miscellaneous Supplies 104 1,400 1,400 3,250 Small Tools & Minor Equip 300 1,500 1,500 1,500 Professional Services 2,125 - - - ComputerServices 4,100 21,850 18,257 11,280 SUBTOTAL $ 25,228 $ 58,016 $ 54,633 $ 65,735 Capital Outlay Computer Equipment - - 6,993 5,000 Office Equipment & Furniture - - - 5,710 CIP Expenditures 3,805 - - - SUBTOTAL $ 3,805 $ - $ 6,993 $ 10,710 DEPARTMENT TOTALS $ 337,162 $ 462,221 $ 499,851 $ 530,679 2001-2002 CAPITAL EXPENDITURES LIST QUANTITY BUDGET Computer Equipment Computer Equipment 5,000 5,000 Office Fqulpment & Furniture Furniture 5,710 5,710 TOTAL CAPITAL $ 10,710 City of Allen Page 65 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 D'uertor 1 AdmnnlralkreSeerenn tI Superintendent 1 Form a Form aUOlides I 1 WaledSewei CroLader Lead Clsndna 2 I Cos he EpuipmeatOpemlm 2 2 Building Tech Mail toWerker 2 fi SanrSpoATecli I TmBcSgreIslSTguslklakngsTech TraAcSipoalTech 1 1 COMMUNITY SERVICES DIVISIONS ADMINISTRATION 001-5110-432 BUILDING MAINTENANCE 001-5120-418 STREETS 001-5130-431 City of Allen Page 66 FY 2002 Budget FUND COMMUNITY DEPARTMENT DESCRIPTION The Community Services Administration is responsible for the efficient and effective administration and direction of the following Divisions: Streets, Drainage, Building Maintenance, Water & Sewer, and Utility Collections. The Department manages its budget from the following funds: General Fund, Solid Waste, Drainage, and Water and Sewer. PROGRAM NARRATIVE Accomplishments for FY 2001: ❖ Completed Department -wide Standard Operating Procedures (SOPs). ❖ Obtained COG & TxDOT grants to fund eight additional Alternative Fuel Vehicles. B• Managed aggregation of City TXU electric accounts for contracting through Cities Aggregation Power Project (CAPP). Objectives for FY 2002: ❖ Provide responsible strategic planning to address long range water, sewer, and solid waste needs; both City Capital Improvement Investments and investments made by NTMWD. ❖ Complete a Water and Sewer Rate Study and make appropriate recommendations to City Council in response to North Texas Municipal Water District cost increases and the results of a rate study. f• Develop a "concept for fleet vehicle maintenance" for the City. ❖ Coordinate a "Needs Assessment" for construction of a City Service Center. ❖ Continue to stay involved in electric deregulation through the Cities Aggregation Power Project and in management of the City's power procurement and usage. v Resolve customer emergencies within three hours of initial call. ❖ Repair water main breaks within three hours during normal duty hours; and within six hours after normal duty days/hours. d• Respond to routine customer inquiries or comments within seven days. ¢• Continue fleet conversion to alternative fuels or vehicles meeting low emission standards (LEV). City of Allen Page 67 FY 2002 Budget 1 FUND GENERAL FUND DEPARTMENT/DIVISION COMMUNITY SERVICESIADMINISTRATION ACCOUNT 001-5110-432 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 allMET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services 140,536 203,432 234,214 224,019 Operations 21,535 19,515 19,515 15,705 Professional Services 10,423 2,500 2,500 2,500 Capital 17,233 - - - DEPARTMENTTOTAL $ 189,727 $ 225,447 $ 256,229 242,224 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 RUQQaET FULL TIME Director 1 1 1 1 Administrative Secretary 1 1 1 1 Superintendent 1 1 1 1 TOTAL FULL TIME 3 3 3 3 PART TIME TOTAL PART-TIME 0 0 0 0 * Superintendent and Administrative Secretary moved from Water & Sewer Administration FY99-00 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PERSONNEL SERVICES Salaries 110,818 162,012 182,108 175,995 Longevity 1,288 604 604 776 Overtime 881 - 1,369 1,369 FICA Expenses 8,603 12,408 13,775 13,089 TMRS Expenses 11,861 16,993 18,048 17,023 Workman's Comp Expenses 487 574 780 757 Health Insurance 5,635 9,551 15,280 12,892 Dental Insurance 587 775 1,440 1,380 Long-Term Disability 291 436 506 477 Life Insurance 84 79 304 262 SUBTOTAL $ 140,536 $ 203,432 $ 234,214 $ 224,019 OPERATING Xp Nc c Conferences & Training 1,104 1,290 3,290 3,290 Dues & Subscriptions 1,481 1,500 1,500 1,500 Mileage 3,328 3,000 1,000 1,000 Telephone 3,280 2,400 2,400 - Insurance 630 1,750 1,750 - Postage & Freight 192 500 500 - Printing & Reproduction 281 750 750 750 Gasoline 831 1,200 1,200 1,225 Office Supplies 2,035 1,250 1,250 2,065 Computer Supplies 234 250 250 250 Miscellaneous Supplies 371 1,000 1,000 1,000 Small Tools & Minor Equip 1,837 - - City of Allen Page 68 FY 2002 Budget FUND GENERALFUND DEPARTMENT/DIVISION COMMUNITY SERVICESIADMINISTRATION ACCOUNT 001-5110432 EXPENDITURE DETAIL - cont. 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET OPERATING XP N - cont Vehicle Maintenance 2,256 700 700 700 Radio Maintenance - 250 250 250 Operating Transfer Out 3,675 3,675 3,675 3,675 SUBTOTAL $ 21,535 $ 19,515 E 19,515 $ 15,705 PROFESSIONAL SERVICES Professional Services 10,423 2,500 2,500 2,500 SUBTOTAL $ 10,423 $ 2,500 $ 2,500 $ 2,500 CAPITAL OUT 4V Vehicles 17,233 - - - SUBTOTAL $ 17,233 $ - $ $ - DEPARTMENT TOTALS $ 189,727 $ 225,447 9 256,229 $ 242,224 CAPITAL EXPENDITURES LIST No Capital Outlay for this Department City of Allen Page 69 FY 2002 Budget FUND DEPARTMENT ACCOUNT GENERAL FUND COMMUNITY SERVICES/ 001-5120-418 BUILDING MAINTENANCE DIVISION DIVISION DESCRIPTION The Building Maintenance Division is responsible for maintaining a high quality interior building appearance and administering maintenance and minor repair contracts for the new City Hall, the City Hall Annex/Municipal Court, the City Library, Police Station, and Police Animal Shelter. Building Maintenance performs a variety of tasks including: incoming delivery distribution, furniture assembly, bulk mail transport to the post office, completion of minor remodeling projects, and other minor tasks/requirements to ensure efficient building operations. PROGRAM NARRATIVE Accomplishments for FY 2001: ❖ Completed the first round of customer satisfaction surveying and adjusted work effort in response to areas requiring improvement. ❖ Smoothly managed procurement of emergency repairs to the Library roof, a new air conditioner for the Municipal Court, and a new ice machine for employees located in the Municipal Annex. ❖ Prepared the final City Hall problem list for contractor repair at the end of the building's one-year warranty. Cross -trained the two -person daytime staff to perform building maintenance tasks as well as custodial functions. ❖ Achieved cost avoidance by beginning internal carpet cleaning by purchase of a carpet cleaning machine. Objectives for FY 2002: :• Finalize Building Maintenance Schedule and Checklists (Strategic Plan item). Continue to achieve the high level of customer satisfaction that resulted in three employees receiving the City's Outstanding Performance Award in 2001. Procure annual maintenance contracts for: ❖ Heating, Ventilation, and Air Conditioning ❖ Elevator Maintenance E• Stand -By Diesel Generator for the Emergency Operations Center •'r Electric Doors for City Hall & Library Pest Control Services Begin custodial maintenance of the Police Building expansion in summer 2002. Total Square Feet Cleaned per Employee 1998 1999 2000 2001 Major Budget Items: ❖ Electric and Gas Utilities - $195,075. i• Building Maintenance- $52,500. I' City of Allen Page 70 FY 2002 Budget I FUND GENERAL FUND DEPARTMENT/DIVISION COMMUNITY SERVICES/BUILDING MAINTENANCE ACCOUNT 0015120418 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED - - 2001-2002 BUDGET C A IIA II CCS IFIC�ATION Personnel Services 129,054 198,104 224,717 231,854 Operations 203,771 279,821 281,692 293,800 Professional Services 2,583 2,500 2,200 2,500 Capital 17,371 - - - DEPARTMENTTOTAL ; 352,779 ; 480,425 ; 508,609 528,154 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BU3 DGE'j 2000-2001 AMENDED 2001-2002 BUDGE FULL TIME Foreman 1 1 1 1 Lead Custodian 1 1 1 1 Building Technician 0 0 0 2 Custodian 4 4 4 2 TOTAL FULL TIME 6 6 6 6 PART TIME Custodian 0 0 0 0 TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PERSONNEL SERVICES Salaries 88,917 139,246 151,861 158,267 Longevity 519 500 656 1,004 Overtime 6,260 2,931 7,436 7,436 FICA Expenses 7,055 10,714 11,627 11,558 TMRS Expenses 10,045 14,910 15,708 15,409 Workman's Comp Expenses 2,885 4,366 5,874 5,917 Health Insurance 12,133 23,346 28,540 29,156 Dental Insurance 926 1,550 2,263 2,385 Long -Term Disability 221 383 422 410 Life Insurance 93 158 330 312 SUBTOTAL $ 129,054 $ 198,104 $ 224,717 $ 231,854 OPERATING XP N E Mileage - 50 50 50 Clothing & Uniforms 682 1,200 2,800 2,800 Electricity 80,285 170,000 170,000 173,400 Gas 1,447 21,250 21,250 21,675 Water 13 5,000 5,000 5,000 Telephone - - 83 - Insurance 5,176 6,646 8,134 - Gasoline 123 500 500 500 Janitorial Supplies 14,532 13,500 13,500 13,700 Small Tools & Minor Equip 8,023 5,000 5,000 17,500 Building Maintenance 88,817 50,000 48,700 52,500 City of Allen Page 71 FY 2002 Budget ' FUND GENERAL FUND DEPARTMENTIDIVISION COMMUNITY SERVICES/BUILDING MAINTENANCE ACCOUNT 001-5120-418 EXPENDITURE DETAIL -cont. 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET OPERATING XP N`; S- QQDJ. Vehicle Maintenance 44 500 500 500 Equipment Maintenance 954 2,500 2,500 2,500 Operating Transfer Out 3,675 3,675 3,675 3,675 SUBTOTAL $ 203,771 $ 279,821 $ 281,692 $ 293,800 PROFESSIONAL RVI C Professional Services 2,583 2,500 2,200 2,500 SUBTOTAL $ 2,583 $ 2,500 $ 2,200 $ 2,500 CAPITAL OUTLAY Vehicles 17,371 - - SUBTOTAL $ 17,371 $ - $ - $ - DEPARTMENT TOTALS $ 352,779 $ 480,425 $ 508,609 $ 528,154 CAPITAL EXPENDITURES LIST No capital outlay for this department City of Allen Page 72 FY 2002 Budget FUND DEPARTMENT/DIVISION ACCOUNT GENERAL FUND COMMUNITY SERVICES/STREETS DIVISION 001-5130-431 DIVISION DESCRIPTION Objectives for FY 2002: Streets Division is responsible for promoting quality of life and the public's safe driving experience through maintaining public streets, sidewalks, and alleys; including sign and street marking maintenance. PROGRAM NARRATIVE Accomplishments for FY 2001: ❖ Responded to emergency needs for brush and tree branch collection following an ice storm. Awarded a contract for "as needed" concrete repair and asphalt resurfacing. t• Prioritized older alleys and alley entrances for revitalization efforts and commenced the first, $500,000 phase of a repair and replacement program with available bond funding. v Completed a major street repair on Windsor Drive. ❖ Placed centerline buttons on Exchange Parkway from Highway 5 to Angel Parkway and on critical turns on Suncreek and Bel Air Drives. ❖ Performed critical routine concrete and asphalt street maintenance needed to extend the life of the City's infrastructure. ❖ Establish positions for Senior Traffic Signal Technician and Street Signs and Markings Maintenance Worker. ❖ Improve execution of street sign replacement program and begin a dedicated program to replace missing street buttons. ❖ Continue prioritization of older alleys and alley entrances for revitalization efforts. Continue repair and replacement program with available 2002 bond funding. d• Doubled funds available over last Fiscal Year to accomplish the concrete and asphalt street maintenance program through a combined funding increase of $200,000. This will greatly improve our capability to address street maintenance issues. Major Budget Items: i• Street Light Electricity- $345,000. ❖ Traffic Signal Electricity- $27,000. ❖ Concrete Street Maintenance - $222,500. S• Asphalt Street Maintenance- $169,250. A. Street/Traffic Sign Replacement $32,000. City of Allen Page 73 FY 2002 Budget , FUND DEPARTMENTIDIVISION ACCOUNT GENERAL FUND COMMUNITY SERVICES/STREETS 001-5130-431 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET A IC,I_SS FICATION Personnel Services 349,593 460,182 478,429 562,340 Operations 556,147 637,584 738,833 993,041 Professional Services 126 1,500 1,500 1,500 Capital 116,399 109,841 109,841 55,231 DEPARTMENTTOTAL $ 1,022,265 $ 1,209,107 $ 1,328,603 $ 1,612,112 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 RU QFT 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME Foreman 1 1 1 1 Crew Leader 2 2 2 2 Equipment Operator 2 2 2 2 Maintenance Worker 6 6 6 6 Senior Signal Technician 0 0 0 1 Signal/Signs/Markings Technician 0 0 0 1 Traffic Signal Technician 1 1 1 1 TOTAL FULL TIME 12 12 12 14 PARTTIME TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 RUnrFT PERSONNEL RVI C Salaries 240,446 317,021 322,834 377,526 Longevity 1,516 1,896 1,844 2,432 Overtime 12,214 10,904 11,072 11,072 FICA Expenses 18,793 24,596 24,657 27,779 TMRS Expenses 26,715 34,466 32,972 37,111 Workman's Comp Expenses 17,037 22,428 27,601 29,035 Health Insurance 29,682 44,570 51,618 70,195 Dental Insurance 2,306 3,100 4,326 5,490 Long-Term Disability 642 884 880 1,022 Life Insurance 242 317 625 677 SUBTOTAL $ 349,593 S 460,182 $ 478,429 $ 562,340 OPERATING XP N C Conferences & Training 1,841 3,000 3,000 3,250 Dues & Subscriptions 64 150 150 150 Mileage 544 200 200 200 Clothing & Uniforms 5,514 7,200 7,200 8,759 Telephone 1,826 - 959 - Electricity-Street Lights 272,604 248,600 324,000 345,000 Electricity-Traffic Signl 13,297 6,400 16,801 27,000 Insurance 5,452 6,737 7,371 - Postage & Freight 117 200 200 - Printing & Reproduction 900 900 900 City of Allen Page 74 FY 2002 Budget FUND URE DETAIL - cont. Vehicle Propane Gas Office Supplies Miscellaneous Supplies Medical & Chemical Supply Small Tools & Minor Equip Vehicle Maintenance Equipment Maintenance Radio Maintenance Asphalt Maintenancce Sidewalk Replacement Traffic Signal Maint. Street Maintenance Street Sign Replacement Gravel Street Maintenance School Crossing Guards Sidewalk Bond Interest Operating Transfer Out SUBTOTAL Services SUBTOTAL Signs iery & Equipment iter Equipment SUBTOTAL DEPARTMENTTOTALS K�]SJul1L`1wil y 01:7<1I1I;M9E9 1999-2000 ACTUAL 2000-2001 BUDGET 809 4,000 14,461 7,400 549 3,000 61 400 1,099 1,200 110 500 7,352 6,500 8,322 8,200 8,442 14,000 - 800 40,915 68,000 2,429 2,000 8,908 10,200 93,143 120,000 18,307 20,000 2,919 8,500 9,081 20,000 - 2,000 37.981 67.497 2000-2001 4,000 17,309 1,000 400 1,200 500 6,501 8,200 14,000 800 59,830 2,000 30,894 111,000 20,000 8,500 20,000 2,000 69,918 738,833 2001-2002 4,000 19,650 2,000 410 1,225 500 12,550 8,625 14,275 800 169,250 2,000 24,300 222,500 20,400 8,500 20,000 2,000 126 1,500 1,500 1,500 $ 126 $ 1,500 $ 1,500 $ 1,500 49,954 6,441 6,441 23,231 27,873 32,000 32,000 32,000 38,572 71,400 71,400 - $ 116,399 $ 109,841 $ 109,841 $ 55,231 S 1.022.265 $ 1.209.107 $ 1.328,603 $ 1,612,112 City of Allen Page 75 FY 2002 Budget FUND DEPARTMENTIDIVISION ACCOUNT GENERAL FUND COMMUNITY SERVICES/STREETS 001-5130-431 CAPITAL EXPENDITURES LIST 2001-2002 QUANTITY BUDGET VEHICLES Truck 1 23,231 SUBTOTAL 1 23,231 TRAFFIC SIGNS Traffic Signs 32,000 SUBTOTAL 32,000 TOTAL CAPITAL $ 55,231 City of Allen Page 76 FY 2002 Budget CITY OF ALLEN CITY OF ALLEN, TEXAS FY 2001-2002 RuceRedor 1 RtlmioislralNe Secretary 1 RccouofiugMger PurcWa Rgeel BudgdRoa�sl � 1 1 Rccouolaol Rccouuliug PaymllSpedisl PM -Time Buyer 2 Rssislanlll 75 Rceouuhg 1 1 Rssislanlll .5 FINANCE DIVISIONS FINANCE 001-5500-416 PURCHASING 001-5510-416 City of Allen Page 77 FY 2002 Budget FUND DEPARTMENT DESCRIPTION DEPARTMENT FINANCE The Finance Department's purpose is to assist the City Manager and all departments in planning and maintaining the City's financial health. PROGRAM NARRATIVE Accomplishments for FY 2001: ❖ Awarded Certificate of Achievement for Excellence in Financial Reporting for 1998-99 Comprehensive Annual Financial Report by the Government Finance Officers Association. (2nd award for the City). B• Received the Distinguished Budget Presentation Award from the Government Finance Officers Association for 2000-2001 Budget. (2nd award for the City). •A Established a centralized purchasing function and implemented purchasing software. •A Implemented financial software to track capital projects and developed reports for management as this function was moved from the Planning Dept. to the Finance Dept. S• Began updating various departmental policies to address management needs, growth, and software changes. Objectives for FY 2002: ❖ Receive 3rd Certificate of Achievement for Excellence in Financial Reporting Award. ❖ Receive 3rd Distinguished Budget Presentation Award. S• Begin policy and procedure development necessary for implementation of new financial reporting model (GASB 34). S• Continue updating departmental policies. ❖ Develop in-house training program for financial software users. S• Develop financial reports for directors and project managers using new financial reporting software. A. Receive Achievement of Excellence in Procurement Award from the National Purchasing Institute. 6• Establish a procurement card program. ❖ Establish a local, small, and disadvantaged business program in our purchasing division. City of Allen Page 78 FY 2002 Budget r, FUND GENERAL FUND DEPARTMENT FINANCE ACCOUNT 001-5500-416 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 RUnQFT 2000-2001 AMENDED 2001-2002 BUDGET Q1 ASSIFICATION Personnel Services 360,278 530,081 570,902 615,530 Operations 41,939 73,177 60,947 53,182 Professional Services 7,140 11,600 11,119 11,350 Capital DEPARTMENTTOTAL $ - 409,357 - $ 614,858 $ 642,968 $ 680,062 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 20002001 AMENDED 2001-2002 BIIID FTT FULL TIME Director 1 1 1 1 Accounting Manager 1 1 1 1 Senior Accountant 0 0 1 1 Accountant 1 2 1 1 Budget Analyst 1 1 1 1 Administrative Secretary 1 1 1 1 Purchasing Agent 0 1 1 1 Buyer 0 1 1 1 Accounting Assistant II 1 1 1 1 TOTAL FULL TIME 6 9 9 9 ART TIME Accounting Assistant II .5 .5 .5 .5 Payroll Specialist .75 .75 .75 .75 TOTAL PART-TIME 1.25 1.25 1.25 1.25 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 RUnrFT 2000-2001 AMENDED 2001-2002 BSlDGET PERSONNEL SERVI Salaries 285,275 414,785 448,026 484,326 Longevity 1,324 1,560 1,352 1,828 Overtime - 1,200 1,449 1,661 FICA Expenses 21,581 31,527 33,341 35,885 TMRS Expenses 30,143 43,665 43,991 46,816 Workman's Comp Expenses 518 751 990 1,070 Health Insurance 18,868 32,897 36,985 38,675 Dental Insurance 1,583 2,326 3,116 3,516 Long -Term Disability 735 1,027 1,091 1,179 Life Insurance 251 343 561 574 SUBTOTAL $ 360,276 $ 530,081 $ 570,902 $ 615,530 nPFRATINQ EXPENSES Conferences & Training 8,656 11,770 14,024 22,125 Dues & Subscriptions 1,139 1,920 2,537 3,475 Mileage 538 975 648 850 I' City of Allen Page 79 FY 2002 Budget FUND DEPARTMENT ACCOUNT GENERAL FUND FINANCE 001-5500-416' EXPENDITURE DETAIL - cont. OPERATING EXPENSES -cont 1999-2000 2000-2001 ACTUAL BUDGET 2000-2001 AMENDED 2001-2002 BUDGET , Telephone 3,288 6,050 3,524 - Insurance 1,845 1,900 2,435 - ' Postage & Freight 3,535 3,700 4,001 - Printing & Reproduction 9,530 9,315 10,916 10,000 Advertising 831 500 500 550 , Miscellaneous Oper. Exp. 2,354 2,160 3,367 2,500 Office Supplies 10,223 34,587 18,695 13,182 Equipment Maintenance - 300 300 500 , SUBTOTAL $ 41,939 $ 73,177 $ 60,947 $ 53,182 PROFESSIONAL SERVICES Professional Services 1,950 6,250 5,885 6,000 Courier Services 5,190 5,350 5,234 5,350 SUBTOTAL $ 7,140 $ 11,600 $ 11,119 $ 11,360 , DEPARTMENT TOTALS $ 409,357 $ 614,858 $ 642,968 $ 680,062 CAPITAL EXPENDITURES LIST No for this department ' capital outlay City of Allen Page 80 FY 2002 Budget ' CITY OF ALLEN, TEXAS FY 2001-2002 Director Administrative Secretary Civil Engineer I I Traffic Engineer I I Construction Inspector 4 Drafter 2 Graduate Civil Engineer 1 Graduate Civil Engineer' ROW/Utility Coordinator - Utility Locato Technician' 'Positions funded in Water & Sewer ENGINEERING DIVISION ENGINEERING 001-6000-432 City of Allen Page 81 FY 2002 Budget Id11121�. DEPARTMENT DESCRIPTION ENGINEERING The Engineering Department provides planning and engineering services for the City's infrastructure including streets, traffic signals, drainage, water and wastewater. In addition, it manages the implementation of the capital improvements program, ensures that all traffic signalization is operated to safely and efficiently move vehicular traffic through the community, and provides inspection services for public construction projects. PROGRAM NARRATIVE Accomplishments for FY 2001: Completed Phase I of Mustang Creek Drainage Improvements from Main Street to Timbercreek Drive Completed the construction projects below: - Allen Heights widened from Rivemrest to Main including the installation of the water transmission line from Stacy Rd to Main St. - Watters from McDermott to Bethany Road - Stacy Road from SH 121 to CR 150 and CR 196 to US 75 (not including street lights and landscaping) - Intersection improvements at Main St and Malone Road - Alma widened from Suncreek Dr to Hedcoxe - Angel Parkway from Oak Tree Rd to Muir Woods Dr - Exchange Parkway from Alma Drive to Watters Branch - Phase 1 SH 5 sidewalks Exchange to Post Oak :• Rowlett Water Tower rehabilitation Right -of -Way Management Ordinance Objectives for FY 2002: Complete the construction projects below: - Complete Mustang Creek Phase II - Alma expansion from Bel Air to Tatum including the 18° Water Line* - Stacy Road from CR 150 to CR 196 West Bethany from Watters to Alma' Intersection Improvements at McDermott Drive and Century Parkway- Two arkwayTwo lanes of Angel Parkway from Muir Woods Drive to Main Street* Malone Road widening adjacent to Malone Community Park Complete Phase I of the Alley replacement program Exchange Parkway (2 -lanes) from Twin Creeks Drive west to Twin Creeks Phase 7 - Allen Heights/Bethany Water Line from Main to Bethany, then to Malone - Hedgcoxe Water Line from Longwood Drive to Duchess Drive• - Water and Sewer Supervisory Control and Data Acquisition (SCADA) System - Expansion of the Stacy Road Pump Station - Historic Stone Dam Stabilization - Phase II of the SH 5 Sidewalks - Installation of a traffic signal at the intersection of Hedgooxe and Alma - Construct the Hillside Drainage relief storm sewer Begin construction on the replacement of • the Cottonwood Creek Sanitary Sewer Line from Bethany Drive to Chaparral Drive' Begin construction on the Ola Sewer Line from US 75 to Cottonwood Creek* ❖ Continue Engineering on projects below: - SH 5 from Exchange to Stacy - East Main from Malone Road to FM 2551 - Engineering and right-of-way acquisition from Allen Dr from Main to Whisenant Or - East Bethany Or from US 75 to Allen Heights - Exchange Parkway from SH 5 to Angel Parkway • Implement right-of-way management ordinance permitting • Complete Service Center needs assessment Project Schedule dependent upon completion of land acquisition City of Allen Page 82 FY 2002 Budget 1 1 1 1 FUND GENERAL FUND DEPARTMENT ENGINEERING ACCOUNT 001-6000-437 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services 499,948 617,492 676,283 686,700 Operations 50,697 51,574 55,454 48,294 Professional Services 108,566 2,500 18,000 2,500 Capital 69,968 16,998 17,898 6,000 DEPARTMENTTOTAL $ 729,179 $ 690,564 $ 767,635 $ 743,494 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 2000-2001 AMENDED 2001-2002 FULLTIME &1DC10: BUDGET Director 1 1 1 1 Traffic Engineer 1 1 1 1 Construction Inspector 4 4 4 4 Administrative Secretary 1 1 1 1 Drafter 2 2 2 2 Civil Engineer 1 1 1 1 Graduate Civil Engineer 0 1 1 1 TOTAL FULL TIME 10 11 11 11 PART TIME TOTAL PART-TIME 0 0 0 0 • Personnel moved from Water & Sewer Administration FY 99-00 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PERSONNEL SERVICES Salaries 373,139 470,487 525,633 531,952 Longevity 3,508 3,224 2,716 3,288 Overtime 24,174 12,311 12,311 12,311 FICA Expenses 30,179 36,970 40,183 40,242 TMRS Expenses 42,174 50,811 52,295 51,544 Workman's Comp Expenses 1,930 3,529 3,181 3,155 Health Insurance 21,514 35,727 34,520 38,276 Dental insurance 2,111 2,842 3,418 3,812 Long -Term Disability 946 1,301 1,371 1,442 Life Insurance 273 290 655 678 SUBTOTAL $ 499,948 E 617,492 S 676,283 $ 686,700 OPERATING EXPENSES Conferences & Training 4,061 3,000 3,000 3,000 Dues & Subscriptions 692 1,500 1,500 1,850 Mileage 6,323 2,000 2,000 2,500 Clothing & Uniforms 1,675 1,800 1,800 1,800 Telephone 9,685 6,000 6,000 - Water 122 - - - Insurance 1,885 1,860 4,040 - Postage & Freight 490 500 500 - Printing & Reproduction 555 750 750 750 City of Allen Page 83 FY 2002 Budget FUND GENERAL FUND DEPARTMENT ENGINEERING ACCOUNT 001-6000-437 EXPENDITURE DETAIL -cont. 1999-2000 2000-2001 ACTUAL RUDGET 2000-2001 AMENDED 2001-2002 BUDGET OPERATIN XPEN- ont Gasoline 2,775 3,000 4,350 4,080 Advertising 63 - - Office Supplies 6,282 7,800 7,800 9,000 Computer Supplies - 250 475 2,200 Miscellaneous Supplies 910 2,900 2,900 2,900 Miscellaneous Office Exp 23 - 125 - Vehicle Maintenance 456 1,000 1,000 1,000 Radio Maintenance - 525 525 525 Operating Transfer Out 14,700 18,689 18,689 18,689 SUBTOTAL $ 50,697 $ 51,574 $ 55,454 $ 48,294 PROFESSIONAL R I R Professional Services 108,566 21500 18,000 2,500 SUBTOTAL $ 108,566 $ 2,500 $ 18,000 $ 2,500 CAPITAL Ot JTl.8Y Vehicles 69,260 18,998 17,898 - Office Equip & Furniture 708 - - 6,000 SUBTOTAL $ 69,968 $------T8,998 $ 17,898 $ 6,000 DEPARTMENT TOTALS $ 729,179 E 690,564 $ 767,635 $ 743,494 CAPITAL EXPENDITURES LIST QUANTITY 2001-2002 BUDGET OFFICE Q IPM N7&F RNIT Furniture R 6,000 SUBTOTAL 6,000 TOTAL CAPITAL E 6,000 uty of Allen Page 84 FY 2002 Budget ' Water & Sewer Fund City of Allen Page 85 FY 2002 Budget ' CITY OF ALLEN WATER AND SEWER FUND REVENUE AND EXPENDITURE SUMMARY ' FISCAL YEAR FY 2001-2002 1999-2000 2000-2001 2000-2001 2001-2002 , REVENUES ACTUAL BUDGET AMENDED BUDGET Op rating Revenues t Water Sales 8,490,270 7,136,076 9,763,810 11,228,382 Sewer Charges 2,664,419 2,281,722 2,281,722 2,692,432 Connections 213,122 223,872 317,500 241,649 ' Service Charges 254,035 243,505 187,186 169,000 Miscellaneous 230,233 80,550 398,435 250,000 SUBTOTAL $ 11,852,079 $ 9,965,725 $ 12,948,653 $ 14,581,463 , Non -Operating Revenues Interest 554,665 567,536 541,491 381,949 ' Operating Transfer In 10,423 10,728 12,230 11,020 Drawdown of Reserves - 710,530 - 5,821,000 SUBTOTAL $ 565,088 $ 1,288,794 $ 553,721 $ 6,213,969 , TOTAL REVENUES $ 12,417,167 $ 11,254,519 $ 13,502,374 $ 20,795,432 1 1999-2000 2000-2001 2000-2001 2001-2002 EXPENDITURES General Government ACTUAL eUDGET AMENDED BUDGET 1 Utility Collections 346,061 443,525 429,261 492,529 TOTAL GENERAL GOV. $ 346,061 $ 443,525 $ 429,261 $ 492,529 ' Public Works' Water & Sewer Operating Expenditures 6,967,020 8,949,510 9,403,571 9,814,013 Capital Improvement Projects - - - 5,821,000 ' TOTAL PUBLIC WORKS $ 6,967,020 $ 8,949,510 $ 9,403,571 $ 15,635,013 Debt Service Payments $ 1,896,548 $ 1,861,484 $ 1,861,484 $ 1,864,609 ' TOTAL EXPENDITURES ' $ 9,209,629 $ 11,254,519 $ 11,694,316 $ 17,982,151 'Drawdown of Reserves is to fund the Stacy Road Pump Station Expansion and Water and Sewer Line Replacement ' PROJECTED FUND BALANCE 10/1/01 11,597,398 , TOTAL PROJECTED REVENUES 14,974,432 TOTAL PROJECTED EXPENDITURES (17,982,151) ' PROJECTED FUND BALANCE 9/30/02 $ 8,589,679 ' City of Allen Page 85 FY 2002 Budget ' WATER & SEWER FUND REVENUES FY 2002 Operating Transfer In 0.05% Interest 1.85% Miscellaneous 120% Service Charges 0.81% Drawdown of Reserves 2802% Connections 1.13% Sewer Charges 12.95% Water & Sewer 86.95°' WATER & SEWER FUND EXPENDITURES BY FUNCTION FY 2002 Water Sales 53 99% Utility Collections 2.74% Debt Service Payments 10.31% City of Allen Page 86 FY 2002 Budget CITY OF ALLEN WATER AND SEWER FUND REVENUE DETAIL FISCAL YEAR 2001.2002 Non -Operating Revenues Interest On Investments 1999-2000 2000-2001 2000-2001 2001-2002 REVENUE -DETAIL ACTUAL BUDGET AMENDED BUDGET Operating Revenues 8,490,270 7,136,076 9,763,810 11,228,382 Water Sales Sewer Charges 2,664,419 2,281,722 2,281,722 2,692,432 Connections 213,122 209,861 287,500 226,649 Re -Connect Fees 14,080 14,011 30,000 15,000 Penalties 218,609 243,505 165,516 165,000 Sewer Clean Outs 5,500 3,500 3,500 4,000 Miscellaneous 11,506 4,800 18,170 - Inspection Fees 230,233 72,250 398,435 250,000 Sale Of Materials 4,340 - - - SUBTOTAL $ 11,852,079 $ 9,965,725 $ 12,948,653 $ 14,581,463 Non -Operating Revenues Interest On Investments 475,383 455,400 541,357 381,949 Interest -I & S Reserve Fd 79,134 112,136 - - Interest -Buckingham W & S 148 - 134 - Operating Transfer In 10,423 10,728 12,230 11,020 Drawdown of Reserve ` - 710,530 5,821,000 SUBTOTAL $ 565,088 $ 1,288,794 $ 553,721 $ 6,213,969 TOTAL REVENUE $ 12,417,167 $ 11,254,519 $ 13,502,374 $ 20,795,432 `Drawdown of Reserves is to fund the Stacy Road Pump Station Expansion and Water and Sewer Line Replacement City of Allen Page 87 FY 2002 Budget ' Personnel Services Operations Professional Services Debt Service Payments Capital TOTAL $ 9,209,629 $ 11,694,316 $ 17,982,151 Water & Sewer Fund Expenditures By Classification Debt Service Payments 1031% Professional Services 032% Capital 352,% Operations 43.21% Personnel Services 10.55% City of Allen Page 88 FY 2002 Budget CITY OF ALLEN WATER & SEWER FUND EXPENDITURE CLASSIFICATIONS AS A PERCENT OF TOTAL BUDGET FISCAL YEAR 2001-2002 2000-01 1999-00 %OF REVISED ACTUAL ACTUAL BUDGET BUDGET %OF 2001-02 BUDGET %OF BUDGET $ 1,132,192 12.29% $ 1,462,882 12.51% $ 1,897,574 10.55% $ 6,140,782 66.68% $ 7,789,141 66.61% $ 7,770,458 43.21% $ 40,107 0.44% $ 121,897 1.04% $ 127,330 0.72% 1,896,548 20.59% 1,861,484 15.92% 1,854,609 10.31% - 0.00% 458,912 3.92% 6,332,180 35.21% TOTAL $ 9,209,629 $ 11,694,316 $ 17,982,151 Water & Sewer Fund Expenditures By Classification Debt Service Payments 1031% Professional Services 032% Capital 352,% Operations 43.21% Personnel Services 10.55% City of Allen Page 88 FY 2002 Budget CITY OF ALLEN 1 4 City of Allan Page 89 FV 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 C om m un ity Services Director Community Services Utility Siting Secretary Superintendent Supervisor 1 1 SewerForeman Water Foreman Customer Service 1 1 Representative 6 Meter Service Crew Chief Crew Chief Waler0uafty 3 Tech Pump Station Operators Technician 4 4 Equipment Meter Services Equipment Operator Maintenance Operator 3 Worker 3 2 Maintenance Maintenance Worker Worker 5 5 WATER AND SEWER DIVISIONS WATER AND SEWER 200-6500-433 UTILITY BILLING 200-7000-419 1 4 City of Allan Page 89 FV 2002 Budget ANDSEWER DIVISION DESCRIPTION COMMUNITY SERVICES/ WATER AND SEWER DIVISION The Water and Sewer Division is responsible for delivering potable water from the North Texas Municipal Water District to Allen customers; and collecting wastewater from the customers and delivering it to the North Texas Municipal Water District's sewer trunk lines. FUND NARRATIVE Accomplishments for FY 2001: Completed repainting of the Rowlett Water Tower. E• Landscaped the Stacy Road Pump Station and the two new water towers to improve their appearance. S• Prepared four new water tower antenna contracts that average $15,000 revenue per year. ❖ Provided water distribution capacity through the summer of 2001 without enacting water rationing measures. Objectives for FY 2002: 6• Continue to provide the City of Allen residents with high quality potable water. ❖ Anticipate future growth and plan water/sewer system infrastructure, construction, modernization, and maintenance to prevent City -controllable service shortfalls or interruptions. S• Identify and eliminate cross connections within the water system. 6• Maintain an acceptable water loss of < 10%. Water loss is the difference between the water amount NTMWD sells the City and what we bill our customers. S Maintain sanitary sewer system to minimize stoppages and back-ups; have no sewer discharges in violation of NPDES rules, and measure, control and lessen sewer inflows and infiltration (I&I). Purchase three new sewer flow meters to help isolate I&I problems. S• Add two new maintenance workers to allow full-time staffing of the Volvo Vacuum truck to increase our sewer system preventive maintenance efforts. • Continue regular 10% meter replacement program and phase-in of touch -read meter reading capability. r In coordination with Engineering Division, complete design then award a construction contract for a Supervisory Control and Data Acquisition System (SCADA) to improve the City's ability to monitor the water and sewer systems. 4 In coordination with Engineering Division, complete design then award a construction contract for expansion of Stacy Road Pump Station to include doubling pumping capacity and adding 6 million gallons of ground storage. Major Budget Items: B• Water payments to NTMWD- $2.60 million. ❖ Sewage interceptor, pretreatment program, and sewage treatment payments to NTMWD - $2.47 million. 6• Electricity- $265,000. ❖ Meters & Touch -Read pads- $261,000. City of Allen Page 90 FY 2002 Budget �&= VATER AND SEWER DEPARTMENT/DIVISION W&SANATER AND SEWER 836,779 ACCOUNT 200-6500-033 :XPENDITURE SUMMARY 1999-00 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET ;LASSIFICATION 'ersonnel Services 929,075 1,219,244 1,217,459 1,592,763 )peratlons 6,004,574 7,161,474 7,617,320 7,594,690 'rofessional Services 33,371 109,880 109,880 115,380 apital - 458,912 458,912 511,180 DEPARTMENTTOTAL $ 6,967,020 $ 8,949,510 $ 9,403,571 $ 9,814,013 rERSONNEL SUMMARY 1999-00 2000-01 BUDGET 2000-01 AMENDED 2001-02 RUDGET :ULL TIME ACTUAL 1,709 AMENDED 2,176 oreman 2 2 2 2 )apartment Secretary 0 1 1 1 lump Station Operator 4 4 4 4 'sew Leader 6 7 7 7 3aduate Engineer* 0 0 0 1 JUlity Coordinator* 0 0 0 1 Jtility Locator* 0 0 0 1 equipment Operator 5 5 5 6 Nater Quality Technician 1 1 1 1 later Service Technician 4 4 4 4 4eter Service Maintenance Worker 0 0 0 2 4aintenance Worker 6 B B 10 TOTAL FULL TIME 28 32 32 40 'ART TIME TOTAL PART-TIME 0 0 0 0 These oositlons are under supervision of Enoineenno Deot. EXPENDITURE DETAIL 1999-00 2000-01 2000-01 2001-02 Salaries 632,015 836,779 831,993 1,080,986 Longevity 3,856 4,940 4,760 6,008 Overtime 58,459 56,276 56,276 56,276 FICA Expenses 50,911 66,145 63,828 80,050 TMRS Expenses 73,016 93,886 85,355 106,784 Workman's Comp Expenses 18,395 23,772 28,627 33,229 Health Insurance 84,012 125,928 132,439 209,777 Dental Insurance 6,068 8,267 10,489 14,850 Long -Tenn Disability 1,709 2,406 2,176 2,927 Life Insurance 634 845 1,516 1,876 SUBTOTAL $ 929,075 $ 1,219,244 $ 1,217,459 $ 1,592,763 OPERATING EXPENSES Conferences & Training 3,283 3,500 3,500 4,000 Dues & Subscriptions 7,357 8,500 8,500 8,675 Mileage 210 400 400 400 Clothing & Uniforms 14,083 15,000 15,000 23,953 Electricity 238,040 240,000 240,000 265,000 Telephone 13,267 15,800 15,800 17,200 Insurance 20,900 23,201 32,477 32,477 Postage & Freight 3,558 5,000 5,000 5,500 I, City of Allen Page 91 FY 2002 Budget FUND WATER AND SEWER DEPARTMENT/DIVISION W&S/WATER AND SEWER ACCOUNT 200-6500433 EXPENDITURE DETAIL - cont OP RATING EXPENSES- 1999-00 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET cont. Printing & Reproduction 2,894 5,000 5,000 5,500 Rentals 1,088 1,500 1,500 1,500 Miscellaneous Oper. Exp. - 2,500 2,500 - Gasoline 22,924 18,188 23,188 25,000 Propane Gas 105 500 494 500 Vehicle Propane Gas 230 1,800 1,800 1,800 NTMWD-Upper E. Fork 822,021 780,000 890,512 932,580 NTMWD-Regnl Pretreatment 1,194,715 1,300,548 1,300,548 1,508,635 Water District -Water 1,999,299 2,168,128 2,395,581 2,601,753 NTMWD Pretreatment 21,600 26,013 29,993 32,000 Office Supplies 641 1,200 1,200 8,850 Computer Supplies 100 500 500 5,800 Miscellaneous Supplies 261 400 400 400 Mechanical Supplies 42,856 46,000 46,000 46,000 Medical & Chemical Supply 723 1,250 1,250 1,250 Chlorine Gas 243 1,500 1,500 1,500 Small Tools & Minor Equip 12,585 15,000 15,000 29,300 Building Maintenance 33,706 35,000 35,000 40,000 Vehicle Maintenance 9,491 13,000 13,000 14,250 Equipment Maintenance 7,475 12,500 12,500 12,750 Radio Maintenance 1,056 2,600 2,600 2,600 Meter Maintenance 19,937 10,500 10,500 11,025 Water System Maintenance 20,209 20,000 50,000 30,000 Sewer System Maintenance 28,923 30,000 30,000 30,000 Water Tower Repairs - 755,000 725,000 - Operating Transfer Out 1,460,794 1,601,446 1,701,077 1,894,492 SUBTOTAL E 6,004,574 $ 7,161,474 $ 7,617,320 $ 7,594,690 PROFESSIONAL SERVICES Professional Services 16,971 83,880 83,880 83,380 Contract Mowing 16,400 26,000 26,000 32,000 SUBTOTALS 33,371 $ 109,880 $ 109,880 $ 115,380 CAPITAL OUT Vehicles - 13,572 13,572 80,548 Mains & Connections - 120,000 110,000 120,000 Meters - 199,550 215,550 261,160 Machinery & Equipment 125,790 119,790 49,472 SUBTOTAL $ - $ 458,912 $ 458,912 $ 511,180 DEPARTMENT TOTALS $ 6,967,020 $ 8,949,510 $ 9,403,571 $ 9,814,013 City of Allen Page 92 fV 2002 Budget FUND DEPARTMENTIDIVISION WATER AND SEWER W&SNVATER AND SEWER ACCOUNT 200-6500-433 CAPITAL EXPENDITURES LIST QUANTITY 2001-2002 RUDOET VEHICLES Light Duty Pick-up 3 43,971 Utility Truck 1 36,577 SUBTOTAL 4 80,548 MAINS & CONNECTIONS Mains & Connections 120,000 SUBTOTAL 120,000 METERS Meters - 133,160 Touch Read Meters 128,000 SUBTOTAL 261,160 MACHINERY AND FOUIPMENT Metering Equipment 25,651 Replace Rotary Assembly 1 14,950 Replace Concrete Mixer 1 3,550 Replace Pressure Washer 1 5,321 SUBTOTAL 3 49,472 TOTAL CAPITAL $ 511,180 Cly of Allen Page 93 FY 2002 Budget AND SEWER COMMUNITY SERVICES/ 200-7000419 UTILITY COLLECTIONS DIVISION DIVISION DESCRIPTION Objectives for FY 2002: The Utility Collections Division is Initiate Average Utility Billing (Budget responsible for billing and processing Billing) program. payments from City utilities that includes water, sewer, drainage, solid waste, and 4• In coordination with the Information recycling services. Process all City and Technology and Finance Departments, Municipal Court bank deposits. Operate monitor studies to implement a capability the division with a strong customer service to accept customer payments through emphasis and philosophy. the Internet. PROGRAM NARRATIVE v Complete Utility Billing Division's Internal Standard Operating Procedures. Accomplishments for FY 2001: •'r Began bar code scanning of utility Major Budget Items: payments to improve the clerical staffs Postage -$95,064. processing efficiency. •;• Trained employees and set-up financial ° Printing/Reproduction- $41,751. system to offer Average Utility Billingee Computers- $18,077. (Budget Billing) in FY 01-02. Developed implementation policies and citizen announcement concerning program Utility Accounts Managed participation. revision that enhanced the City's ability 1998 1999 2000 2001 to prove water theft in order to encourage on-time bill payments by customers. City of Allen Page 94 FY 2002 Budget ' 20,000 ❖ Began accepting credit card payments 18,009 at the Utility Billing counter. 10,000 •;• Managed a major Utility Ordinance S 14.000 update that allows customers longer c 12,000 periods to make payments and before a 10,000 cut-offs. Updated rates for special A 8,000 customer services. Reduced the instance of late payments by 25% since 8,000 implementation of ordinance changes. 4,000 2,000 4• Developed wording for an ordinance o revision that enhanced the City's ability 1998 1999 2000 2001 to prove water theft in order to encourage on-time bill payments by customers. City of Allen Page 94 FY 2002 Budget ' VDITURE SUMMARY 1999-00 2000-01 2000-01 2001-02 inel Services 203,117 267,959 245,423 304,811 ions 136,208 165,621 171,821 175,768 sional Services 6,736 9,945 12,017 11,950 DEPARTMENTTOTAL $ 346,061 $ 443,525 ; 429,261 $ 492,529 DNNEL SUMMARY 1999-00 2000-01 2000-01 2001-02 Overtime ACTUAL BUDGET AMENDED BUDGET TME 11,331 11,989 13,342 12,000 Billing Supervisor 1 1 1 1 ner Service Representative 5 5 5 5 TOTAL FULL TIME 6 6 6 6 TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-00 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET PERSONNEL SERVICES Salaries 152,233 159,734 178,087 162,782 Salary Reserve - 53,376 - 82,832 Longevity 568 700 800 720 Overtime 1,265 1,575 1,575 1,575 FICA Expenses 11,331 11,989 13,342 12,000 TMRS Expenses 16,205 16,927 17,657 15,745 Workman's Comp Expenses 278 292 395 360 Health Insurance 19,255 21,224 30,193 25,784 Dental Insurance 1,419 1,550 2,296 2,260 Long -Tenn Disability 411 434 730 441 Life Insurance 152 158 348 312 SUBTOTAL E 203.117 $ 267,959 $ 245.423 E 304111 renes & Training 1,929 2,734 8,934 3,500 & Subscriptions 32 100 100 100 le 113 204 204 204 hone 3,940 3,672 3,672 2,972 ince 1,288 1,508 1,508 1,500 ge & Freight 82,990 93,200 93,200 95,064 Ig & Reproduction 26,292 40,933 40,933 41,751 tising - 100 100 100 cuter Costs 8,695 10,370 10,370 18,077 ■ ' City of Allen Page 95 FY 2002 Budget FUND WATER AND SEWER DEPARTMENT/DIVISION W&S/UTILITY COLLECTIONS ACCOUNT 200-7000-419 EXPENDITURE DETAIL - cont. 1999-00 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET OPERATING EXPENSES - cont. Miscellaneous Oper. Exp. 1,897 3,000 3,000 2,500 Office Supplies 5,813 5,200 5,200 5,300 Equipment Maintenance 3,219 4,600 4,600 4,700 SUBTOTAL E 136,208 E 165,621 E 171,821 $ 175,768 PROFESSIONAL ERVI S Professional Services 1,432 1,000 3,272 4,450 Courier Services 5,190 5,345 5,345 5,450 Credit Card Costs 114 3,600 3,400 2,050 SUBTOTAL $ 6,736 $ 9,945 $ 12,017 E 11,950 DEPARTMENT TOTALS E 346,061 $ 443,525 E 429,261 $ 492,529 CAPITAL EXPENDITURES LIST No capital outlay for this department City of Allen Page 96 FY 2002 Budget ' Solid Waste Fund CITY OF ALLEN SOLID WASTE FUND REVENUES AND EXPENDITURES BY FUNCTION ' FISCAL YEAR 2001-2002 1999-2000 2000-2001 2000-2001 1 REVENUES ACTUAL BUDGET AMENDED 2001-2002 BUOGET Operating Revenues ' Garbage Fees 1,271,588 1,415,669 1,428,270 1,550,522 Recycling Revenues 449,482 525,346 515,000 567,373 Commercial Garbage Fees 288,432 222,036 360,000 400,000 , Recycling Materials 40,845 22,823 46,140 49,831 Recycle Bin Revenue Franchise Fees - - - 70,000 420 62,831 - - ' Donations/Sponsorships - - - _ SUBTOTAL $ 2,050,347 $ 2,255,874 $ 2,412,661 $ 2,567,726 Non -O ep rating Revenues Interest On Investments 25,087 18,418 26,626 18,786 SUBTOTAL $ 25,087 $ 18,418 $ 26,626 $ 18,786 , TOTAL REVENUES $ 2,075,434 $ 2,274,292 $ 2,439,287 $ 2,586,512 EXPENDITURES 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET ' Public Works ' Solid Waste 1,898,675 2,183,261 2,141,944 2,566,276 TOTAL PUBLIC WORKS $ 1,898,675 $ 2,183,261 $ 2,141,944 $ 2,566,276 TOTAL EXPENDITURES $ 1,898,675 $ 2,183,261 $ 2,141,944 $ 2,566,276 FUND BALANCE PROJECTIONS 1 PROJECTED FUND BALANCE 10/1/01 786,201 ' TOTAL PROJECTED REVENUES 2,586,512 , TOTAL PROJECTED EXPENDITURES (2,566,276) PROJECTED FUND BALANCE 9/30/02 ' $ 806,437 City of Allen Page 97 FY 2002 Budget , CITY OF ALLEN, TEXAS FY 2001-2002 Community Services Director Recycling Coordinator Maintenance Worker 1 1 1 SOLID WASTE DIVISIONS SOLID WASTE 205-0000-435 City of Allen Page 98 FY 2002 Budget FUND DEPARTMENT ACCOUNT SOLID WASTE SOLID WASTE 205-0000-435 FUND DESCRIPTION The Solid Waste Fund represents the financial activity related to solid waste collection and disposal, including recycling services and management of household hazardous waste (HHW). Revenues fund contracts with North Texas Municipal Water District (NTMWD) and the City's franchised waste provider. The City's Solid Waste/Recycling/HHW Coordinator manages the City's solid waste contracts and responds to citizen issues and concerns. The coordinator also develops educational programs and provides staff support to the City's Keep Allen Beautiful Board. FUND NARRATIVE Accomplishments for FY 2001: ❖ Intensively managed CWD contract administration to assure the contractor was responsive to citizen needs. B• The City received the Environmental Vision Award from the Dallas Corporate Recycling Council. d• Participated in the development of North Texas Municipal Water District's Sub -Regional Solid Waste Plan. i• Improved Adopt -a -Highway visibility by upgrading roadside signage with larger and more colorful signs. +s Assisted the Keep Allen Beautiful (KAB) Board in execution of their highly successful Fall Texas Trash -Off and the Spring Spruce -Up. City of Allen Page 99 Implemented the ordinance change that requires recycling in apartments within the City. Put Allen among the lead cities to mandate apartment recycling. Objectives for FY 2002: i• Fund a new maintenance worker to dedicate to Household Hazardous Waste (HHW) collection. The same worker will collect litter and debris from streets and right-of-way to improve the appearance of City streets. ❖ Initiate a contract to accomplish litter collection on US75 at least twice a month. S• Work with the Keep Allen Beautiful (KAB) Board to: • Increase the City's school -focused educational programs for recycling, hazardous waste, illegal dumping, and supporting other environmental programs. • Further improve visibility of the City's "Adopt -A- Highway" program by organizing a City Council plaque recognition program. Major Budget Items: ❖ North Texas Municipal Water District solid waste transfer station and landfill services ($810,000) and CWD solid waste/recycling services ($1,388,283). New US75 litter collection contract - $104,000. •A New Residential Household Hazardous Waste Program- $60,000 funded first year by CWD funds. FY 2002 Budget ' FUND DEPARTMENT ACCOUNT SOLID WASTE SOLID WASTE 205-0000435 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services $ 31,509 $ 51,779 $ 44,311 $ 86,562 Operations 48,991 121,262 51,973 152,774 Professional Services 1,818,175 2,010,220 2,045,660 2,312,283 Capital - - - 14,657 DEPARTMENTTOTAL $ 1,898,675 $ 2,183,261 $ 2,141,944 $ 2,566,276 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 2000-2001 AMENDED 2001-2002 FULL TIME $UjjGQ BUDGET Recycling Coordinator 1 1 1 1 Maintenance Worker 0 0 0 1 TOTAL FULL TIME 1 1 1 2 PARTTIME TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PERSONNEL SERVICES Salaries 24,827 38,544 34,515 61,668 Salary Reserve - 2,994 - 3,157 Longevity 304 280 - 72 FICA Expenses 1,923 2,970 2,640 4,724 TMRS Expenses 2,652 4,057 3,398 6,165 Workman's Comp Expenses 46 70 75 824 Health Insurance 1,518 2,476 3,181 9,114 Dental Insurance 158 258 336 593 Long -Term Disability 64 104 111 167 Life Insurance 17 26 55 78 SUBTOTAL $ 31,509 $ 51,779 $ 44,311 $ 86,562 OPERATING xP N C Telephone 281 - 65 - Postage & Freight 113 200 200 200 Miscellaneous Oper. Exp. - 500 1,000 5,017 Recycling Expenses 504 72,000 10,000 - Environmental Grants 1,000 500 1,000 Bad Debt Expense 3,367 - - - Litter Control 5,834 7,000 - - Illegal Dumping 119 500 500 500 Household Hazardous Waste - 2,000 - 90,000 Beautification 9,953 10,000 10,000 22,765 Operating Transfer Out 28,820 28,062 29,708 33,292 SUBTOTAL $ 48,991 $ 121,262 $ 51,973 E 152,774 City of Allen Page 100 FY 2002 Budget FUND SOLID WASTE DEPARTMENT SOLID WASTE ACCOUNT 205-0000-435 EXPENDITURE DETAIL - cont. 1999-2000 2000-2001 ACTUAL BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PROFESSIONAL RVI S Sanitation Services 728,622 800,052 760,000 820,800 Professional Services - - 10,212 114,000 Recycling 432,853 525,448 525,448 567,483 Solid Waste-NTMWD 656,700 684,720 750,000 810,000 SUBTOTAL $ 1,818,175 $ 2,010,220 $ 2,045,660 $ 2,312,283 CAPITAL OUTLAY Vehicles 14,657 SUBTOTAL $ - $ - $ - $ 14,657 TOTAL EXPENSES $ 1,898,675 $ 2,183,261 $ 2,141,944 $ 2,566,276 CAPITAL EXPENDITURES LIST QUANTITY 2001-2002 BUDGET VEHICLE Ford Ranger 1 14,657 1 14,657 TOTAL CAPITAL $ 14,657 City of Allen Page 101 FY 2002 Budget ' Drainage Fund CITY OF ALLEN DRAINAGE FUND REVENUES AND EXPENDITURES BY FUNCTION FISCAL YEAR 2001-2002 1999-2000 2000-2001 2000-2001 2001-2002 REVENUES ACTUAL BUDGET AMENDED BUDGET Operating Revenues Inspection Fees 42,415 72,500 215,000 150,000 Drainage Fees 518,347 527,224 580,236 610,000 SUBTOTAL $ 560,762 $ 599,724 $ 795,236 $ 760,000 Non Operating Revenues Interest On Investments 43,167 33,060 30,701 21,661 Drawdown of Reserve' - - 246,319 89,512 SUBTOTAL $ 43,187 $ 33,060 $ 277,020 $ 111,173 TOTAL REVENUES $ 603,949 $ 632,784 $ 1,072,256 $ 871,173 rrr 2000 -2001 2000 -2001 2001-200-1 a 1 u i Public Works' Drainage Operating Expenditures 427,509 612,272 624,256 761,173 Capital Improvement Projects - - 448,000 110,000 TOTAL PUBLIC WORKS $ 427,509 $ 612,272 $ 1,072,256 $ 871,173 TOTAL EXPENDITURES $ 427,509 $ 612,272 $ 1,072,256 $ 871,173 *Drawdown of reserve for Mustang Creek drainage improvements PROJECTED FUND BALANCE 10/1/01 493,247 TOTAL PROJECTED REVENUES 781,661 TOTAL PROJECTED EXPENDITURES (871,173) PROJECTED FUND BALANCE 9/30/02 $ 403,735 City of Allen Page 102 FY 2002 Budget ' CITY OF ALLEN, TEXAS FY 2001-2002 S t ree is Foreman C rew Lead er 1 Equipment O pe rator 1 Mainten an ce W o rlce rs 4 DRAINAGE DIVISIONS DRAINAGE 210-0000-434 City of Allen Page 103 FY 2002 Budget DRAINAGE DIVISION DESCRIPTION The Drainage crew maintains the City's drainage structures, channels, and ditches to assure they remain free of vegetation and hazardous wastes, sedimentation is controlled, and channels can carry their design flows. FUND NARRATIVE Accomplishments for FY 2001: ❖ Completed Phase I Mustang Creek to protect homes from 100 -year flood event. Overall ongoing maintenance of Mustang Creek. Increased oversight of the City's street sweeping contractor to assure quality of work. No homes or businesses flooded during the year. Purchased new boom mower to mow drainage channels and right-of-way. Objectives for FY 2002: f• Inspect and clear all storm sewer inlets after major storm events. ❖ Hire new maintenance worker to assist in HHW collection and keeping litter and debris from entering the storm sewers from streets and right-of-way. S• Initiate a storm drain marking system to help deter illegal dumping of hazardous or toxic waste in the storm sewer system. 21 ❖ Improve appearance of City streets by increasing street sweeping frequencies from once to twice monthly on arterial and thoroughfares; while keeping frequency to once monthly on collectors. ❖ Have no homes or businesses flooded due to maintenance issues with City drainage structures or channels. Major Budget Items: Purchase of capital equipment including stump grinder and grappling attachments for the division's "Bobcat" skid steer loader- $35,000. ❖ Drainage System Maintenance - $90,000. ❖ Contract for developing Phase 11 NPDES documentation- $40,000. •:• Contract Street Sweeping- $79,100 Curb Miles of Street Sweeping Monthly 1998 1999 2000 2001 2002 Year City of Allen Page 104 FY 2002 Budget 300 250 200 750 100 50 n 1998 1999 2000 2001 2002 Year City of Allen Page 104 FY 2002 Budget FUND DEPARTMENT ACCOUNT DRAINAGE DRAINAGE 210-0000434 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services 150,146 194,651 191,788 238,015 Operations 218,576 334,130 332,777 396,501 Professional Services 58,787 27,500 29,500 77,000 Capital - 55,991 70,191 49,657 DEPARTMENTTOTAL $ 427,509 $ 612,272 $ 624,256 $ 761,173 PERSONNEL SUMMARY 1999-2000 2000-2001 2000-2001 2001-2002 FULL TIME ACTUAL BUDGET AMENDED BUDGET Crew Leader 1 1 1 1 Equipment Operator 1 1 1 1 Maintenance Worker 3 3 3 4 TOTAL FULL TIME 5 5 5 6 PART TIME TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PERSONNEL SERVICES Salaries 106,356 131,193 131,267 156,227 Salary Reserve - 9,404 - 9,446 Longevity 1,107 1,256 976 1,312 Overtime 2,371 3,832 3,832 3,832 FICA Expenses 8,246 10,256 10,043 11,842 TMRS Expenses 11,561 14,242 13,125 15,391 Workman's Comp Expenses 6,922 8,176 11,080 12,018 Health Insurance 12,163 14,504 19,055 25,179 Dental Insurance 1,024 1,292 1,762 2,059 Long -Term Disability 288 364 373 423 Life Insurance 108 132 275 286 SUBTOTAL $ 150,146 $ 194,651 $ 191,788 $ 238,015 OPERATING XP N C Conferences & Training 150 900 900 900 Mileage - 150 150 150 Clothing & Uniforms 3,048 3,630 3,630 4,417 Telephone 78 70 70 70 Insurance 2,548 3,660 4,135 4,135 Postage & Freight - 150 150 150 Printing & Reproduction - 250 250 250 Advertising - 100 100 100 Rentals 707 6,000 6,000 6,100 Miscellaneous Oper. Exp. 36 - - - City of Allen Page 105 FY 2002 Budget a EXPENDITURE DETAIL - cont 1999-2000 2000-2001 2000-2001 Gasoline 951 2,000 6,000 Oil & Lubricants 959 500 500 Vehicle Propane Gas 272 2,000 2,000 Office Supplies 32 400 400 Miscellaneous Supplies 522 500 500 Medical & Chemical Supply 106 500 500 Agriculture Supplies 1,736 4,000 4,000 Small Tools & Minor Equip 7,752 7,500 7,500 Vehicle Maintenance 3,647 4,000 4,000 Equipment Maintenance 14,928 7,800 7,800 Radio Maintenance 400 400 Rock/Sand/Gravel/Cement - - - Street Sweeping Maint. 16,876 45,000 45,000 Drainage System Maint. 21,177 90,000 84,000 Bad Debt Expense 1,001 - - Compensating Absences 701 - - OperatingTransferOut 141,349 154,620 154,792 SUBTOTAL $ 218,576 $ 334,130 $ 332,777 final Services 27,572 - 2,000 Mowing 31,215 27,500 27,500 SUBTOTAL $ 58,787 $ 27,500 $ 29,500 as - - nery & Equipment - 55,991 70,191 Equipment - - - SUBTOTAL $ - $ 55,991 $ 70,191 TOTAL EXPENSES $ 427,509 $ 612,272 $ 624,256 TAIL EXPENDITURES LIST Q FS QUANTITY Ranger 1 SUBTOTAL 1 Tractor SUBTOTAL 1 TOTAL CAPITAL City of Allen Page 106 FY 2002 Budget ' ' Parks & Recreation Enterprise Fund CITY OF ALLEN ■ PARKS & RECREATION ENTERPRISE FUND REVENUES AND EXPENDITURES BY FUNCTION FISCAL YEAR 2001-2002 REVENUES 5Qp rg atino Revenues 1999-2000 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET , Basketball Fees 13,141 14,663 14,663 14,663 Volleyball Fees 6,092 11,031 11,031 11,031 Softball Fees 57,970 61,183 61,183 61,183 ' Athletics - - - 99,502 Ballfield Rentals 525 6,390 3,100 6,390 Pool Admission Fees` 23,062 - - - ' Pool Concessions' 2,075 - - - Leam To Swim Fees' Pool Rental` 35,536 3,595 - - - - - - ' Day Camps 40,397 41,605 41,605 - Membership Revenue Class Fees 110,455 57,887 113,594 50,549 113,594 50,549 113,594 104,654 Saturday Night Revenue 61,370 72,697 72,697 72,697 Rec Center Concessions 2,584 2,689 2,689 - Saturday Youth Concession 14,001 12,270 12,270 - , Concession Sales - - 8,500 23,928 Facility Rental Fees 10,578 7,652 7,652 14,042 Special Activities Rev 10,592 20,000 20,000 - ' Sales At Special Events - 8,500 - - SUBTOTAL E 449,860 E 422,823 E 419,533 E 521,684 Non -Op rQ ating Revenues ' Interest On Investments 15,169 13,875 9,464 6,678 Donadons/Sponsorships 43,918 20,000 20,000 55,000 Miscellaneous 15 - 30 35,000 Operating Transfers In 55,000 - - - ' Drawdown of Reserve" - 166,569 172,857 - SUBTOTAL $ 114,102 $ 200,444 $ 202,351 $ 96,678 ' TOTAL REVENUES $ 563,962 $ 623,267 $ 621,884 $ 618,362 EXPENDITURES 1999-2000 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET , Culture a Recreaton Parks and Recreation 528,357 623,267 621,884 609,075 , TOTAL EXPENDITURES $ 528,357 $ 623,267 $ 621,884 $609,075 PROJECTED FUND BALANCE 10/1/01 27,881 TOTAL PROJECTED REVENUES 618,362 ' TOTAL PROJECTED EXPENDITURES (609,075) ' $ 37,168 PROJECTED FUND BALANCE 9/30/02 'Revenues moved to Aquatics Enterprise Fund "Drawdown of Reserve to fund construction of Rodenbaugh Natatorium City of Allen Page 107 FY 2002 Budget , CITY OF ALLEN, TEXAS FY 2001-2002 Parks & Recreation Director Recreation Services Manager Recreation Center AtNetb Coordinator Supervisor Recreation Special st II Park Attendant I 5 Recreation Specialist I 4 Camp Leader .25 Camp Coun sebr Saturday Night Event Supervisor .5 Assistant Saturday Night Event Supervisor 25 Saturday Night Event Chaperone 4.25 Assistant Recreation Services Manager 1 PARKS AND RECREATION ENTERPRISE DIVISIONS SPECIAL EVENTS 215-8540-453 ATHLETICS 215-8540-453 RECREATION 215-8550-453 City of Allen Page 108 FY 2002 Budget FUND DEPARTMENT P&R ENTERPRISE P&R ENTERPRISE 21 FUND DESCRIPTION The Parks & Recreation Enterprise Fund is established to support the classes and other leisure activities offered at Ford Pool, Joe Farmer Recreation Center and other City facilities. It is intended to recover costs for these recreation programs, but not the facilities themselves. FUND NARRATIVE Accomplishments for FY 2001: Z Participation increased an average of 20 youth per week in the "Saturday Night Rec N Rolf' program. ❖ Instituted the Xtreme Teen program. f• Increased the number and variety of programs offered at the Joe Farmer Recreation Center. ❖ Offered an additional 25 programs for teens. 4 Expanded the Allen USA celebration to a day long event. S• Implemented the Halloween special events including "Allen Nights of Terror" and "Booville." Objectives for FY 2002: ❖ Expand the range of programming possibilities to the citizens of Allen. Increase by 5% the participation in classes offered through the Joe Farmer Recreation Center by offering a wider variety of classes. S• Increase participation in the teen programs, including the "Teen Board," Xtreme teens and implement an intramural athletics program. 4 Offer outdoor adventure classes -such as camping, canoe and teen camps. 4- Continue to increase participation in the "Saturday Night Rec N Roll" program. ❖ Improve cost -recovery in special events. ❖ Begin an adult tennis program and co -recreational basketball program. City of Allen Page 109 FY 2002 Budget FUND P&R ENTERPRISE DEPARTMENT P&R ENTERPRISE ACCOUNT 215-8500-453 EXPENDITURE SUMMARY 1999-2000 2000-01 2000-01 2001-02 CLASSIFICATION ACTUAL BUDGET AMENDED BUDGET Personnel Services 234,237 179,662 179,231 246,392 Operations 294,095 403,605 442,306 362,683 Professional Services 25 40,000 347 - Capital - - - - DEPARTMENTTOTAL $ 528,357 $ 623,267 $ 621,884 $ 609,075 PERSONNEL SUMMARY 1999-2000 2000-01 2000-01 2001-02 FULL TIME ACTUAL HUDGEI AMENDED BUDGET Recreation Specialist II 1 1 1 1 Assistant Recreation Services Manager 0 0 0 1 TOTAL FULL TIME 1 1 1 2 PARTTIME Recreation Specialist I 4.00 4.00 4.00 4.00 Park Attendant 0.50 0.5 0.5 0.5 Saturday Night Event Supervisor 0.00 0.5 0.5 0.5 TOTAL PART-TIME 4.50 5.00 5.00 5.00 TEMPORARY Pool Manager* 0.25 0.00 0.00 0.00 Lifeguard* 7.50 0.00 0.00 0.00 Camp Counselor 1.00 1.00 1.00 1.00 Camp Leader 0.25 0.25 0.25 0.25 Saturday Night Event Supervisor 0.25 0.25 0.25 0.25 Asst. Saturday Night Event Supervisor 0.25 0.00 0.00 0.00 Saturday Night Event Chaperone 4.25 4.25 4.25 4.25 TOTAL TEMPORARY 13.75 5.75 5.75 5.75 *Moved to Aquatics Fund EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET PERSONNEL SERVICES Salaries 206,495 155,261 155,261 200,580 Salary Reserve - 1,365 - 10,993 Longevity - 44 44 45 Overtime 2,381 - 913 900 FICA Expenses 15,979 11,881 11,881 15,182 TMRS Expenses 3,667 5,361 5,361 8,678 Workman's Comp Expenses 3,927 2,919 2,940 3,690 Health Insurance 1,563 2,476 2,476 5,958 Dental Insurance 163 258 258 258 Long -Term Disability 45 71 71 81 Life Insurance 17 26 26 27 SUBTOTAL OPERATING EXPENSES $ 234,237 $ 179,662 $ 179,231 $ 246,392 Conferences & Training - 850 850 - Saturday Night Expenses 34,557 67,982 67,400 68,768 City of Allen Page 110 FY 2002 Budget FUND DEPARTMENT ACCOUNT P&R ENTERPRISE P&R ENTERPRISE 215-8500453 EXPENDITURE DETAIL - cont. 1999-2000 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET OPERATING XP N - cont 21,597 43,275 43,276 89,097 Class/Day Camp Expenses Special Activities 97,327 - 42,266 82,965 Rec Center Instructor Fee 37,253 33,412 33,412 - Softball 75,395 58,124 58,104 - Basketball 16,886 13,930 13,930 - Volleyball 5,913 10,479 10,128 - Athletics Expenses - - - 92,426 Pool Instructors 1,459 - - - Concession Expenses 1,576 4,267 1,654 18,115 Miscellaneous Oper. Exp. 100 - - - Miscellaneous Supplies 266 - - Minor Equipment -Recreation 420 - - - Small Tools & Minor Equip 467 - - - Credit Card Costs 879 1,286 1,286 1,312 Sponsorship - - - 10,000 Depreciation Expense - - - - Operating Transfer Out - 170,000 170,000 - SUBTOTAL $ 294,095 $ 403,605 $ 442,306 $ 362,683 PROFESSIONAL RVI ES Professional Services 25 40,000 347 - SUBTOTAL $ 25 $ 40,000 $ 347 $ - CAPITAL OUTLAY Machinery & Equipment - - - - SUBTOTAL $ - $ - $ - $ - TOTAL EXPENSES $ 528,357 $ 623,267 $ 621,894 $ 609,075 CAPITAL EXPENDITURES LIST No capital outlay for this department City of Allen Page 111 FY 2002 Budget Aquatics Enterprise Fund REVENUES Pool Admission Fees - CITY OF ALLEN 111,750 AQUATICS ENTERPRISE FUND ' REVENUES AND EXPENDITURES BY FUNCTION 678,653 FISCAL YEAR 2001-2002 Pool Concessions - 1 1999-2000 2000-2001 2000-2001 2001-2002 ACTUAL BUDGET AMENDED BUDGET t Pool Admission Fees - 2001-2002 $UQSaE2 111,750 Culture 8 Recreation Parks and Recreation 315 380,464 19,500 678,653 TOTAL EXPENDITURES $ 315 $ 380,464 $ Pool Concessions - 5,600 550 12,574 I Learn To Swim Fees - 43,320 34,334 81,091 ' Pool Rental 6,080 3,272 128,754 SUBTOTAL Non -Operating Revenues -$- - $ 166,750 $ 57,656 $ 901,072 , Operating Transfer In 250,000 - 50,000 - Interest On Investments 1,988 2,000 9,734 6,867 ' Drawdown of Reserves 211,714 44,563 - SUBTOTAL $ 251,988 $ 213,714 $ 104,297 $ 6,867 , TOTAL REVENUES $ 251,988 $ 380,464 $ 161,953 $ 907,939 1999-2000 2000-2001 EXPENDITURES ACTUAL BUDGET 2000-2001 AMENDED 2001-2002 $UQSaE2 ' Culture 8 Recreation Parks and Recreation 315 380,464 161,953856,549 , TOTAL EXPENDITURES $ 315 $ 380,464 $ 161,953 $ 856,549 FUND BALANCE PROJECTIONS I PROJECTED FUND BALANCE 1011/01 TOTAL PROJECTED REVENUES TOTAL PROJECTED EXPENDITURES PROJECTED FUND BALANCE 9/30/02 207,110 907,939 (856,549) , $ 258,500 City of Allen Page 112 FY 2002 Budget , Ch Pool CITY OF ALLEN, TEXAS Learn To Svnm Recreatbn FY 2001-2002 1 Parks 8 Recreation 1 Director Recreation Services Manager AquakC & Fitt ass Supervisor i Assistant Aquatics & Fitness Superxsa i Aqualic Aquatic Maintenance Fitness Coordinator W Coordinator Worker Coordinator 1 Fitness Manager Coordinator Specialist Instructors 25 .5 5 2.5 Ass star Learn To Swim Learn To Swim Pod Manager Instrudlors Aides 25 5 5 AQUATICS ENTERPRISE DIVISIONS FORD POOL 216-8560-453 RODENBAUGH NATATORIUM 216-8570-453 Ch Pool id Care Learn To Svnm Recreatbn orkers 1 2 1 1 Ch Pool Lifeguards Learn To Svnm Recreatbn 15 City of Allen Page 113 fY 2002 Budget FUND DEPARTMENT ACCOUNT AQUATICS ENTERPRISE AQUATICS ENTERPRISE 21&8500.453 FUND DESCRIPTION The Aquatics Enterprise Fund is composed of Ford Park Swimming Pool and the Don Rodenbaugh Natatorium. The Ford Park outdoor swimming pool is operated only in the summer. The Don Rodenbaugh Natatorium is a year round indoor facility with both leisure and competitive pools, and will open November 2001. FUND NARRATIVE Accomplishments for FY 2001: ❖ Hired a full time Aquatic supervisor to develop programs prior to opening the Natatorium and improve programs offered at Ford Park Pool. Objectives for FY 2002: i• Open the Don Rodenbaugh Natatorium with a full range of aquatic and fitness programs. ❖ Create a year round Learn to Swim program. S• Create a "wellness" program for Allen residents. ❖ Create a Junior Lifesaving program at the Don Rodenbaugh Natatorium. Begin a program on the Cable Access channel. ❖ Improvements to Ford Park pool included the repainting of the shallow end of the Major Budget Items: pool, replacement of all missing and cracked tile, repainting of buildings and ❖ Operations and maintenance at Ford shade structures, replacement of Park Swimming Pool. lifeguard stands to meet State Health codes. ❖ Operations and maintenance at Don Rodenbaugh Natatorium :• Instituted water aerobic classes at Ford Park Swimming Pool. ❖ Instituted lifeguard, CPR, First Aid, Disease Transmission, Water Safety Instructor, and Lifeguard Instructor certification classes. •'r Extended Ford Park Swimming Pool season through September. Updated Employee Manual and Lifeguard Manual. •'r Created an Emergency Crisis Plan for Ford Park Swimming Pool. City of Allen Page 114 FY 2002 Budget ' FUND AQUATICS ENTERPRISE DEPARTMENT AQUATICS ENTERPRISE ACCOUNT 216-8500-453 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 nUnrrT AA IC IFICATION Personnel Services - 216,657 128,333 400,700 Operations 315 158,307 33,620 405,502 Professional Services - 5,500 - 10,110 Capital - - - 40,237 DEPARTMENTTOTAL $ 315 $ 380,464 $ 161,953 $ 856,549 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 RUQQET FULL TIME Aquatic Supervisor 0 1 1 0 Fitness Supervisor 0 1 1 0 Aquatic & Fitness Supervisor 0 0 0 1 Fitness Coordinator 0 0 0 1 Maintenance Worker 0 1 1 1 Marketing Coordinator* 0 1 1 0 Aquatic Coordinator 0 0 1 2 Asst Aquatics & Fitness Supervisor 0 0 0 1 Assistant Manager Natatorium 0 1 0 0 Recreation Specialist I 0 0 0 2 Child Care Workers 0 0 0 2 TOTAL FULL TIME 0 5 5 10 PART TIME Learn to Swim Coordinator 0 .5 .5 .5 Fitness Instructors 0 2.5 2.5 2.5 TOTAL PART-TIME 0 3.0 3.5 3.0 TEMPORARY Pool Manager 0 .25 .25 .25 Assistant Pool Manager 0 .25 .25 .25 Lifeguard 0 15 15 15 Cashiers 0 3 3 0 Recreation Specialist I 0 0 0 3 Learn to Swim Instructors 0 5 5 5 Learn to Swim Aides 0 5 5 5 TOTAL TEMPORARY 0 28.5 28.5 28.5 `Moved to General Fund 2001-2002 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 RUQrFT PERSONNEL SERVI S Salaries - 182,371 109,848 332,067 Salary Reserve - 2,000 - 5,181 Longevity - - - 80 FICA Expenses - 13,951 8,399 25,410 TMRS Expenses - 6,203 4,107 13,632 Workman's Comp Expenses - 3,428 2,466 7,607 City of Allen Page 115 FY 2002 Budge FUND AQUATICS ENTERPRISE DEPARTMENT AQUATICS ENTERPRISE ACCOUNT 216-8500453 EXPENDITURE DETAIL - cont. 1999-2000 ACTUAL 2000-2001 2000-2001 2001-2002 Health Insurance - @UpSaEI 8,047 AMENDED 3,068 BUDGET 15,531 Dental Insurance - 452 322 851 Long -Term Disability - 159 98 237 Life Insurance 46 25 104 SUBTOTAL - $ 216,657 $ 128,333 $ 400,700 OPERATING EXPENSES Conferences & Training - 3,700 1,607 5,774 Dues & Subscriptions - 600 - 1,062 Mileage - 1,425 - 500 Clothing & Uniforms - 600 77 4,050 Electricity - 51,947 - 237,183 Insurance - 9,500 - 13,000 Postage & Freight - 750 - 1,015 Printing & Reproduction - 500 - 1,910 Advertising - 3,500 90 7,000 Rentals - 600 - 612 Pool Instructors - 28,387 1,675 - Meetings&Receptions 315 1,000 - 1,020 Concession Expenses - 450 - 8,008 Office Supplies - 5,569 2,295 11,980 Janitorial Supplies - 4,234 860 5,169 Medical & Chemical Supply - 3,500 - 3,738 Chlorine Gas - 7,911 6,840 24,410 Pool Supplies - 9,650 8,512 24,654 Minor Equipmt-Recreation - 2,400 - 14,862 Building Maintenance - 8,334 - 18,335 Equipment Maintenance - 500 - 3,010 Pool Maintenance - 12,750 11,664 15,500 Credit Card Costs - -i'- 500 - 1,710 SUBTOTAL 315 $ 158,307 $ 33,620 $ 405,502 PROFESSIONAL SERVICES Professional Services - 5,500 - 10,110 SUBTOTAL $ - S 5,500 $ - $ 10,110 CAPITAL EXPENDITURES Vehicles - - - 22,510 Machinery & Equipment - - - 13,000 Computer Equipment - -j'- _ 4,727 SUBTOTAL - $ - $ - $ 40,237 TOTAL EXPENSES $ 315 $ 380,464 $ 161,953 $ 856,549 City of Allen Page 116 FY 2002 Budget FUND DEPARTMENT AQUATICS ENTERPRISE AQUATICS ENTERPRISE ACCOUNT 216-8500-453 CAPITAL EXPENDITURES LIST 2001-2002 VEHICLES QUANTITY BUDGET Explorer Sport Track 1 22,510 1 22,510 MACHINERY 8 EQUIPMENT Cisco Router 1 13,000 1 13,000 COMPUTER FQUIPMrNT Computers 3 4,727 3 4,727 TOTAL CAPITAL $ 40,237 I' City of Allen Page 117 FY 2002 Budget 4 �! • I ' Development Fees Fund TOTAL REVENUES $ 2,046,387 $ 1,426,172 $ 1,901,028 $ 4,960,835 1999-00 EXPENDITURES ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET Public Works Development Fees 1,336,200 1,380,835 CITY OF ALLEN 4,960,835 TOTAL PUBLIC WORKS $ 1,336,200 $ 1,380,835 $ 1,398,793 $ DEVELOPMENT FEES FUND TOTAL EXPENDITURES $ 1,336,200 $ 1,380,835 $ 1,398,793 $ ' REVENUES AND EXPENDITURES BY FUNCTION FISCAL YEAR 2001-2002 , REVENUES 1999-00 2000-01 2000-01 2001-02 Operating Revenues ACTUAL BUDGET AMENDED BUDGET Development Fees - Water 1,558,293 943,900 1,311,131 2,043,900 ' Development Fees - Sewer 252,162 358,700 252,241 583,700 Development Fees - Roadway 88,464 129,987 150,000 SUBTOTAL $ 1,898,919 $ 1,302,600 $ 1,693,359 $ 2,777,600 , Non Operating Revenues Interest On Investments 147,468 123,572 207,669 146,519 , Drawdown of Reserves - - - 2,036,716 SUBTOTAL $ 147,468 $ 123,572 S 207,669 $ 2,183,235 TOTAL REVENUES $ 2,046,387 $ 1,426,172 $ 1,901,028 $ 4,960,835 1999-00 EXPENDITURES ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET Public Works Development Fees 1,336,200 1,380,835 1,398,793 4,960,835 TOTAL PUBLIC WORKS $ 1,336,200 $ 1,380,835 $ 1,398,793 $ 4,960,835 TOTAL EXPENDITURES $ 1,336,200 $ 1,380,835 $ 1,398,793 $ 4,960,835 PROJECTED FUND BALANCE 10/1/01 TOTAL PROJECTED REVENUES TOTAL PROJECTED EXPENDITURES PROJECTED FUND BALANCE 9/30/02 3,552,980 2,924,119 (4,960,835) $ 1,516,264 City of Allen Page 118 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 No Personnel In This Department Development Fees Fund DIVISIONS Water Development Fees 220-8000-436 Sewer Development Fees 220-8100-436 City of Allen Page 119 FY 2002 Budget FUND DEPARTMENT ACCOUNT DEVELOPMENT FEES DEVELOPMENT FEES 220-0000-436 FUND DESCRIPTION Development Impact fees are charges or assessments imposed for new development within the City to generate revenue for funding or recouping the costs of capital improvements or facility expansions necessary as a result of new development. The City of Allen collects impact fees for water, wastewater, and roadways to facilitate citywide improvements such as funding the capital construction of arterial roads, pump stations, lift stations, water towers and sewer interceptors. The fund can only be used to pay for infrastructure detailed in the last impact fee study, which was completed in September 1999. This study is based on a ten-year period requiring the collection and expenditure of impact fees to take place within this ten- year time frame. According to state law, the impact fee study can be updated every three years to reflect changes in land use assumptions, capital improvement plans, and impact fees. City of Allen Page 120 FY 2002 Budget ' FUND DEPARTMENT ACCOUNT DEVELOPMENT FEES DEVELOPMENT FEES 220-0000-436 EXPENDITURE SUMMARY 1999-00 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET A If A If S1L�FICATION Personnel Services - - - - Operations - - - - Professional Services - - - - Capital 1,336,200 1,380,835 1,398,793. 4,960,835 DEPARTMENT TOTAL $ 1,336,200 $ 1,380,835 $ 1,398,793 $ 4,960,835 PERSONNEL SUMMARY 1999-00 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET FULL TIME 0 0 0 0 TOTAL FULL TIME 0 0 0 0 PART TIME 0 0 0 0 TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-00 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET CAPITAL OUTLAY Construction 1,114,258 1,119,971 1,248,361 4,339,971 Design & Engineering 221,942 260,864 150,432 570,864 Land - - 50,000 SUBTOTAL $ 1,336,200 $ 1,380,835 $ 1,398,793 $ 4,960,835 TOTAL EXPENSES $ 1,336,200 $ 1,380,835 $ 1,398,793 $ 4,960,835 CAPITAL EXPENDITURES LIST 2001-02 BUDGET Capital Outlay Development Projects 4,960,835 TOTAL CAPITAL S 4,960,835 ' City of Allen Page 121 FY 2002 Budget CITY OF ALLEN ' Economic Development ' Corporation Fund CITY OF ALLEN ECONOMIC DEVELOPMENT CORPORATION FUND REVENUES AND EXPENDITURES BY FUNCTION FISCAL YEAR 2001-2002 1999-2000 REVENUES ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET Ooeratino Revenue Sales Tax 2,286,089 2,424,680 2,788,382 3,206,639 SUBTOTAL $ 2,286,089 $ 2,424,680 $ 2,788,382 $ 3,206,639 Non Operating Revenues Interest On Investments 64,769 52,133 51,300 35,000 Miscellaneous - - - - Operating Transfer In - - - - Drawdown of Reserve 104,145 - 506,700 - SUBTOTAL $ 168,914 $ 52,133 $ 558,000 $ 35,000 TOTAL REVENUES $ 2,455,003 $ 2,476,813 $ 3,346,382 $ 3,241,639 1999-2000 EXPENDITURES ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET General Government Economic Development 2,455,003 2,459,068 3,346,382 2,766,158 TOTAL GENERAL GOV. $ 2,455,003 $ 2,459,068 $ 3,346,382 $ 2,766,158 TOTAL EXPENDITURES $ 2,455,003 $ 2,459,068 $ 3,346,382 $ 2,766,158 FUND BALANCE PROJECTIONS FUND BALANCE 10/1101 PROJECTED 779,481 TOTAL PROJECTED REVENUES 3,241,639 , TOTAL PROJECTED EXPENDITURES (2,766,158) PROJECTED FUND BALANCE 9/30/02 $ 1,254,962 ' `Drawdown of Reserve in 2000-2001 for additional principal payment on bank loan City of Allen Page 122 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 ECONOMIC DEVELOPMENT DIVISIONS ECONOMIC DEVELOPMENT 500-0000-417 I' City of Allen Page 123 FY 2002 Budget Allen City Council AEDC Board of Directors Director 1 Marketing Coordinator 1 E. D. Assistant 1 ECONOMIC DEVELOPMENT DIVISIONS ECONOMIC DEVELOPMENT 500-0000-417 I' City of Allen Page 123 FY 2002 Budget DEVELOPMENT CORP. FUND DESCRIPTION The Allen Economic Development Corporation's primary purpose is to aggressively market and promote Allen to attract high quality, aesthetically attractive, environmentally sound businesses to increase the local employment and tax bases. Formed in 1992 by the voters of Allen, the AEDC receives funds from a half -cent sales tax for economic development. The five -member board is appointed by the Allen City Council. The cumulative benefit of 27 projects since the inception of AEDC has resulted in a 168% increase in the employment base and a 291% increase in the city's tax base. The cumulative (between 1992-2012) direct and indirect tax impact of these projects to the City of Allen is in excess of $90 million. FUND NARRATIVE Accomplishments for FY 2001: Assisted Trammell Crow Company in the development of the first two office/tech buildings in Allen Station Business Park, which is ultimately designed as a 102 -acre business park with 14 buildings. Completed architectural design for a 100,000 square foot, four-story, Class "A" office building in Millennium Corporate Center. v Assisted the Collin County Community College in the formation of the Collin County Job Training Consortium with eleven Allen industries participating. Continued an aggressive recruitment strategy that resulted in the relocation of Micron Technology, Nera Telecommunications, and Alcatel to Allen. 4 Other community needs were identified, resulting in the groundbreaking for a six -story, 150 room Hilton Hotel; the completion of Phase I and the beginning of construction on Phase II of the Allen Premium Outlets; and the opening of Presbyterian Hospital -Allen. •'r This year's activity by the AEDC resulted in over $81.2 million on the local tax rolls; 770 new jobs, over 528,000 square feet of new space and the leasing of over 300,000 square feet of existing space. Objectives for FY 2002: • Utilize retention program in maintaining Allen's current tax base and ensuring the continued success and growth of our existing local industries. Recruitment of quality companies to Allen, thereby increasing the local employment and ad valorem tax base. Promote and develop quality business parks designed with the amenities desired by technology and corporate entities. Pursue the construction of first-class (Class "A") office space in Allen. • Recruit industries to fill vacant office/tech space in Allen. Increase the diversification of Allen's industrial base. �:• Continue to enhance the community's position to attract retail and restaurant products, providing increased sales tax revenue to the community. Identify and recruit entertainment related • venues that will add to the cultural and recreational opportunities in Allen. :• Enhance the quality of commercial • developments by influencing the landscaping, construction materials, and appearance of buildings through the use of incentives. City of Allen Page 124 FY 2002 Budget FUND ECONOMIC DEVELOPMENT CORP. DEPARTMENT ECONOMIC DEVELOPMENT ACCOUNT 500-0000417 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 RUDGET CLASSIFICATION Personnel Services 255,068 268,542 292,652 266,058 Operations 494,245 805,260 772,360 1,120,110 Professional Services 44,064 42,000 72,000 58,300 Debt Payments 564,765 564,766 1,389,370 746,690 Capital 1,096,861 778,500 820,000 575,000 DEPARTMENTTOTAL $ 2,455,003 $ 2,459,068 3,346,382 $ 2,766,158 PERSONNEL SUMMARY 1999-2000 2000-01 2000-01 2001-02 FULL TIME ACTUAL BUDGET AMENDED BUDGET Director 1 1 1 1 Marketing Coordinator 1 I 1 1 Economic Development Assistant 1 1 1 1 TOTAL FULL TIME 3 3 3 3 PART TIME TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-01 BUDGET 2000-01 AMENDF__n 2001-02 BUDGET PERSONNEL SERVICES Salaries 201,948 212,979 219,379 197,000 Salary Reserve - - - 0 Longevity 548 740 784 880 FICA Expenses 13,714 16,350 16,842 15,138 TMRS Expenses 21,908 21,000 23,425 21,054 Workman's Comp Expenses 377 385 1,739 1,563 Health Insurance 9,133 9,551 22,449 22,449 Dental Insurance 798 775 1,334 1,334 Long-Term Disability 474 577 594 534 Life Insurance 168 185 106 106 Car Allowance 6,000 6,000 6,000 6,000 SUBTOTALT__ 255,068 $ 268,542 $ 292,652 $ 266,058 OPERATING EXPENSES Conferences & Training 5,791 9,000 8,000 8,000 Dues & Subscriptions 3,753 4,200 4,001 4,000 Mileage 1,432 1,500 1,500 1,500 Telephone 6,294 7,500 7,274 7,000 Insurance 2,510 2,550 2,575 2,650 Postage & Freight 6,453 7,000 7,000 7,000 Printing & Reproducton 223 500 300 300 Advertising 457 500 500 1,500 Rentals/Leasing 36,060 36,060 36,060 36,060 Travel 4,645 6,200 8,200 8,500 City of Allen Page 125 FY 2002 Budget FUND ECONOMIC DEVELOPMENT CORP. DEPARTMENT ECONOMIC DEVELOPMENT 5,000 ACCOUNT 500-0000-417 EXPENDITURE DETAIL -cont. 1999-2000 ACTUAL 2000-01 BUDGET 2000-01 AMENDED 2001-02 BUDGET OPERATING XP N S -cont Maps & Photography - 1,000 500 500 Meetings 2,670 5,100 5,100 5,100 Employee Tenure Pins - 50 - - Water Expenses - - - 13,200 Landscape Maintenance - - - 42,000 Miscellaneous Oper. Exp. 53 - - - Office Supplies 5,615 4,600 4,600 5,100 Equipment Maintenance 115 500 650 700 Direct Grants 254,193 600,000 570,000 850,000 Marketing Expenses 63,761 95,000 87,000 97,000 Mowing Maintenance - - 2,500 2,500 Electricity 76,220 - 2,600 3,500 Operating Transfer Out 24,000 24,000 24,000 24,000 SUBTOTALS 494,20.5 $ 805,260 $ 772,360 $ 1,120,110 Audit Fees 5,000 5,000 5,000 5,000 Other Attorney Fees - - - - Consulting Services 9,894 15,000 45,000 25,000 Professional Services 24,783 16,000 16,000 21,000 Copier Service 2,525 3,500 3,500 4,800 Janitorial Services 1,862 2,500 2,500 2,500 SUBTOTAL $ 44,064 $ 42,000 $ 72,000 $ 58,300 DEBT PAYMENTS Debt Retirement -Principal 345,251 346,193 1,064,519 459,051 Debt Retirement -Interest 219,514 218,573 173,247 105,715 Chelsea Loan Payments - 151,604 181,924 SUBTOTAL $ 564,765 $ 564,766 $ 1,389,370 $ 746,690 CAPITAL OUT Construction 752,534 703,500 700,000 500,000 Land 294,410 - - 50,000 Design & Engineering - - - - Architectural Fees 40,172 70,000 115,000 20,000 Advertising - - - - Legal Fees - - - - Office Equip & Furniture 9,745 5,000 5,000 5,000 SUBTOTAL $ 1,096,861 $ 778,500 $ 820,000 $ 575,000 TOTAL EXPENSES $ 2,455,003 $ 2,459,068 $ 3,346,382 S 2,766,158 AL EXPENDITURES LIST action 500,000 ase of TXDOT Property 50,000 ictural Fees 20,000 Equipment 5,000 TOTAL CAPITAL $ 575,000 City of Allen Page 126 FY 2002 Budget ' Community Development ' Corporation Fund CITY OF ALLEN COMMUNITY DEVELOPMENT CORP. FUND REVENUES AND EXPENDITURES BY FUNCTION FISCAL YEAR 2001-2002 1999-2000 2000-2001 2000-2001 2001-2002 REVENUES ACTUAL BUDGET AMENDED BUDGET Operating Revenues Sales Tax 2,286,089 2,424,680 2,788,382 3,206,639 SUBTOTAL $ 2,286,089 $ 2,424,680 $ 2,788,382 $ 3,206,639 Non Operating Revenues Interest On Investments 70,824 77,597 77,597 25,000 Operating Transfer In - - - - Drawdown of Reserve - - - - SUBTOTAL $ 70,824 $ 77,597 $ 77,597 $ 25,000 TOTAL REVENUES $ 2,356,913 $ 2,502,277 $ 2,865,979 $ 3,231,639 1999-2000 EXPENDITURES ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET Capital Outlay Community Development Corp. 2,168,093 2,471,660 2,259,115 3,986,517 TOTAL CAPITAL OUTLAY $ 2,168,093 $ 2,471,660 $ 2,2593115 $ 3,986,517 TOTAL EXPENDITURES $ 2,168,093 $ 2,471,660 $ 2,259,115 $ 3,986,517 FUND BALANCE PROJECTIONS PROJECTED FUND BALANCE 10/1/01 TOTAL PROJECTED REVENUES TOTAL PROJECTED EXPENDITURES FUNDS ALLOCATED TO ONGOING PROJECTS PROJECTED FUND BALANCE 9/30/02 4,063,663 3,231,639 (3,986,517) (3,053,446) $ 255,339 City of Allen Page 127 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 No Personnel In This Department Community Development Corp. DIVISIONS Community Development Corp. 504-0000-490 City of Allen Page 128 FY 2002 Budget FUND DEPARTMENT ACCOUNTI COMMUNITY DEVELOPMENT CORP COMMUNITY DEVELOPMENT 504-0000-490 FUND DESCRIPTION Formed in 1996 by the voters of Allen, the CDC receives funds from a half -cent sales tax for community development projects. The Allen City Council appoints the seven - member board. The Allen Community Development Corporation (CDC) identifies and authorizes projects to be funded by the 4B half -cent sales tax. Expenditures are subject to the provisions of the Development Corporation Act of 1979. FUND NARRATIVE Accomplishments for FY 2001: 0 Conducted a "Town Hall" meeting to receive citizen input on funding projects for the proceeds from the 4B half -cent sales tax. The input is then used to develop projects for a five-year work program. 4 Updated the five-year work program listing 11 current projects at a total cost of $1,358,465. w Published an article in the Municipal Messenger and made presentations to the Rotary Club and the Chamber of Commerce to help heighten public awareness of the Allen Community Development Corporation and the projects funded by the 4B half -cent sales tax. Objectives for FY 2002: fi Publicize and conduct the annual "Town Hall" meeting to obtain public input regarding projects funded by the 4B half -cent sales tax. S• Oversee the expenditure of $3,075,000 of 4B half -cent sales tax revenue on the following projects: - State Hwy 5 Sidewalks - Malone Community Park Playground - Under -served Park Areas - Malone Community Park - Hillside Park - Story Park Development - Allen Station Park Design - Tree Farm `e Continue to improve the process for informing citizens regarding projects funded by the 4B half -cent sales tax. City of Allen Page 129 FY 2002 Budget , FUND COMMUNITY DEVELOPMENT CORP DEPARTMENT COMMUNITY DEVELOPMENT ACCOUNT 504-0000490 EXPENDITURE SUMMARY 1999-2000 2000-2001 ACTUAL BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services - - - - Operations 632,363 37,880 37,880 39,500 Professional Services 5,462 5,500 5,500 5,500 Debt Payment 866,517 857,270 857,270 866,517 Capital 663,751 1,571,010 1,358,465 3,075,000 DEPARTMENTTOTAL $ 2,168,093 $ 2,471,660 $ 2,259,115 $ 3,986,517 SUMMARY 1999-2000 2000-2001 2000-2001 2001-2002 ACTUAL BUDGET AMENDED BUDGET TOTAL FULL TIME PART TIME TOTAL PART-TIME 0 0 0 0 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET OPERATING XP N S Dues 8 Subscriptions 5,497 - - - Postage 8 Freight 27 120 120 100 Printing 8 Reproduction - 560 560 400 Advertising 1,146 1,200 1,200 1,000 Library Books 45,241 - - - Computer Costs 523,602 - - 2,000 Miscellaneous Oper. Exp. 56,850 - - - Direct Grants - - - - Board Discretionary Proj - - - - Operating Transfer Out 36,000 36,000 36,000 SUBTOTAL $ 632,363 $ 37,880 $ 37,880 $ 39,500 PROFESSIONAL SERVICES Audit Fees 5,000 5,000 5,000 5,000 Other Attorney Fees 462 500 500 500 SUBTOTAL $ 5,462 $ 5,500 $ 5,500 $ 5,500 DEBTPAYMENTS Debt Retirement -Principal 359,295 340,000 340,000 340,000 Debt Retirement -Interest 507,222 517,270 517,270 526,517 SUBTOTAL $ 866,517 $ 857,270 $ 857,270 $ 866,517 City of Allen Page 130 FY 2002 Budget FUND DEPARTMENT ACCOUNT COMMUNITY DEVELOPMENT CORP COMMUNITY DEVELOPMENT 504-0000-490 EXPENDITURE DETAIL - cont. 1999-2000 2000-2001 2000-2001 2001-2002 ACTUAL BUDGET AMENDED BUDGET EXPENDITURES LIST 2001-2002 BUDGET Hwy 5 Sidewalks SUBTOTAL Tree Farm - 275,000 - - truction 163,678 1,600,000 - 100,000 in & Engineering 189 - - - lectural Fees 851 - - - .les 291,518 - - - t Improvements 55,650 - - 250,000 Improvements 151,865 1,255,800 1,318,255 2,825,000 Equipment & Furniture - 40,210 40,210 - inery & Equipment - - - SUBTOTAL $ 663,751 $ 1,571,010 $ 1,358,465 $ 3,075,000 TOTAL EXPENSES $ 2,168,093 $ 2,471,660 $ 2,259,115 $ 3,986,517 EXPENDITURES LIST 2001-2002 BUDGET Hwy 5 Sidewalks SUBTOTAL Tree Farm 50,000 Malone Park Playground 175,000 Under -served Park Areas (Boyd) 200,000 Malone Community Park 1,600,000 Hillside Park 100,000 Story Park Development 400,000 Allen Station Park Planning 300,000 SUBTOTAL 2,825,000 TOTAL CAPITAL City of Allen Page 131 FY 2002 Budget Capital Improvement Fund CITY OF ALLEN CAPITAL IMPROVEMENT FUND REVENUES AND EXPENDITURES BY FUNCTION FISCAL YEAR 2001-2002 REVENUES 1999-2000 ACTUAL 2000-2061 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET Operating Revenue Water Tower Rental Fees 169,211 - - 200,000 Sale of Land 45,555 - - - SUBTOTAL $ 214,766 $ $ - $ 200,000 Non Operating Revenues Interest On Investments 16,747 - - 22,116 SUBTOTAL $ 16,747 $ - $ - $ 22,116 TOTAL REVENUES $ 231,513 $ - $ - $ 222,116 1999-2000 2000-2001 2000-2001 2001-2002 EXPENDITURES ACTUAL BUDGET AMENDED BUDGET Culture and Improvements` 335,100 - - 149,200 TOTAL EXPENDITURES $ 335,100 $ $ - $ 149,200 TOTAL EXPENDITURES $ 335,100 $ - 8 $ 149,200 '$60,000 to fund Police Microwave Antenna in FY 2000-2001 FUND BALANCE PROJECTIONS PROJECTED FUND BALANCE 10/1/01 TOTAL PROJECTED REVENUES TOTAL PROJECTED EXPENDITURES PROJECTED FUND BALANCE 9/30/02 299,092 222,116 (149,200) $ 372,008 City of Allen Page 132 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 No Personnel In This Department CAPITAL IMPROVEMENT 505-0000-480 DIVISIONS CAPITAL IMPROVEMENT 505-0000-480 City of Allen Page 133 FY 2002 Budget FUND DEPARTMENT ACCOUNTI CAPITAL IMPROVEMENT CAPITAL IMPROVEMENT FUND 505-0000-480 FUND DESCRIPTION The Capital Improvement Fund is administered by the City Administration Department. Revenues are collected from the rental of space on water towers to companies for placement of various types of antennas. It is the City Council's directive that these funds should be used for advancement of the arts in the City. FUND NARRATIVE Objectives for FY 2002: Ensure fund collection is adequate to allow for continued cultural arts programs sponsored by the City. City of Allen Page 134 FY 2002 Budget FUND DEPARTMENT ACCOUNT CAPITAL IMPROVEMENT CAPITAL IMPROVEMENT FUND 505-0000-480 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services - - - - Operations 335,100 - - 149,200 Professional Services - - - - Capital - - _ _ DEPARTMENT TOTAL $ 335,100 $ - $ - $ 149,200 PERSONNEL SUMMARY 1999-2000 2000-2001 RUDGET 2000-2001 2001-2002 BUDGET FULL TIME ACTUAL AMENDED TOTAL FULL TIME 0 0 0 0 PART TIME TOTAL PART-TIME 0 0 0 O EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET OPERATING EXPENSES City Hall Landscaping 335,100 - - Allen Arts Alliance - - - 115,000 Allen USA Celebration - - - 30,000 Senior Citizen Support - - - 4,200 SUBTOTAL $ 335,100 $ - $ - $ 149,200 TOTAL EXPENSES $ 335,100 $ $ - $ 149,200 CAPITAL EXPENDITURES LIST No capital outlay for this department ' City of Allen Page 135 FY 2002 Budget CITY OF ALLEN ' Hotel Occupancy Tax Fund CITY OF ALLEN HOTEL OCCUPANCY TAX FUND REVENUES AND EXPENDITURES BY FUNCTION ' FISCAL YEAR 2001-2002 1999-2000 2000-2001 2000-2001 2001-2002 , BUDGET REVENUES Operating Revenue ACTUAL BUDGET AMENDED ' Hotel Occupancy Tax 55,207 49,800 63,900 67,000 SUBTOTAL $ Non Operatino Revenues 55,207 $ 49,800 $ 63,900 $ 67,000 ' Interest On Investments 2,575 2,000 2,500 1,500 SUBTOTAL $ 2,575 $ 2,000 $ 2,500 $ 1,500 ' TOTAL REVENUES $ ' 57,782 $ 51,800 $ 66,400 $ 68,500 1999-2000 2000-2001 2000-2001 2001-2002 EXPENDITURES ACTUAL BUDGET AMENDED BUDGET ' Culture & Recreation Culture 54,241 51,500 63,200 58,412 , TOTAL EXPENDITURES $ 54,241 $ 51,500 $ 63,200 $ 58,412 TOTAL EXPENDITURES $ 54,241 $ 51,500 $ 69,200 $ 58,412 FUND BALANCE PROJECTIONS 56,542 , PROJECTED FUND BALANCE 10/1101 TOTAL PROJECTED REVENUES 68,500 ' TOTAL PROJECTED EXPENDITURES (58,412) PROJECTED FUND BALANCE 9/30/02 ' $ 66,630 1 City of Allen Page 136 FY 2002 Budget , CITY OF ALLEN, TEXAS FY 2001-2002 No Personnel In This Department Hotel Occupancy Tax Fund DIVISIONS Hotel Occupancy Tax 506-0000-417 City of Allen Page 137 FY 2002 Budget FUND DEPARTMENT ACCOUNT HOTEL OCCUPANCY TAX HOTEL OCCUPANCY TAX 506-0000-417 FUND DESCRIPTION The Hotel Occupancy Tax Fund collects funds from a 7% tax on hotel rooms rented in the City of Allen. These funds are used to support various projects that enhance and promote tourism and the convention/hotel industry in the City of Allen. FUND NARRATIVE Accomplishments for FY 2001: ❖ The annual presentation of the Allen USA Celebration drew approximately 20,000 people and provided live entertainment. r� The Allen Civic Ballet presented the "Nutcracker" ballet, hosted the Allen Dance Festival and performed at the Collin County Community College's "Dance Fusion" concert. ❖ The Allen Chamber of Commerce dedicated funds for the development of an annual visitor guidelmagazine. The Allen Heritage Guild began the process for the restoration of St. Mary's Baptist Church. A Connemara Conservancy hosted the annual "Spring Season in the Meadow" complete with a sculpture show and musical performances. The free program brought much media attention and drew crowds from the Metroplex. ❖ The Allen Philharmonic Symphony hosted performances led by conductor, Chris Xeros including Tchaikovsky's "Violin Concerto in D Major," Manuel Ponce's "Concierto dol Sur" and Vivaldi's "Concerto in D Major," Rachmaninov's "Piano Concerto No. 2," a children's concert, and Handel's "Suite in D". A The first year for Allen's Northern Prairie Lights, a Christmas Holiday lighting display along US 75, brought over 13,000 vehicles with approximately 54,000 individuals to the community. Over $12,000 was returned back to local non-profit groups for their volunteer efforts with the event. i• Allen participated with other Collin County communities in the promotion of Dallas for hosting the 2012 Olympics. Objectives for FY 2002: .y Annual presentation of the Allen USA Celebration — a major event celebrating the 41 of July, drawing residents from Allen and the surrounding area. Continue the distribution and development of visitor and tourism -related materials promoting Allen and area attractions by the Allen Chamber of Commerce. Assistance with performances presented by the Allen Civic Ballet including the "Nutcracker" and participation in the "Allen Dance Festival." ❖ Assistance for the preservation of Allen's history through the efforts of the Allen Heritage Guild. This year's projects include production of a video, archiving photos and the placement of historic markers. Contribute toward the promotion of the • annual Connemara Conservancy's "Spring Season in the Meadow' featuring a sculpture show, musical performances and educational walks with a Texas naturalist. v Assist with concerts performed by the Allen Philharmonic Symphony. r•• Participate with promoting the second annual Northern Prairie Lights, holiday lighting display, expected to bring thousands of visitors to Allen. City of Allen Page 138 FY 2002 Budget ' 1 1 1 1 FUND HOTEL OCCUPANCY TAX DEPARTMENT HOTEL OCCUPANCY TAX ACCOUNT 506-0000417 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services - - - - Operations 54,241 51,500 63,200 58,412 Professional Services - - - - Capital _ _ _ _ DEPARTMENTTOTAL $ 54,241 $ 51,500 $ 63,200 $ 58,412 PERSONNEL SUMMARY 1999-2000 2000-2001 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME ACTUAL BUDGET TOTAL FULL TIME 0 0 0 0 PART TIME TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET OPERATING XP N C Administrative Expenses 1,500 1,500 1,512 Advertising 252 - - - LegalExpenses 270 - - - Allen USA Celebration 15,000 20,000 20,000 20,000 Dallas 2012 Olympics 2,500 5,000 5,000 - Allen Civic Ballet - 5,000 5,000 3,500 Allen Chamber of Commerce 8,000 5,000 5,000 7,000 Allen Heritage Guild 878 5,000 5,000 4,200 Connemara Conservancy 5,000 5,000 5,000 3,000 Northern Prairie Lights 11,700 - 11,700 11,700 Philharmonic Symphony 10,641 5,000 5,000 7,500 SUBTOTAL $ 54,241 $ 51,500 $ 63,200 $ 58,412 TOTAL EXPENSES $ 54,241 $ 51,500 $ 63,200 $ 58,412 CAPITAL EXPENDITURES LIST No capital outlay for this department City of Allen Page 139 FY 2002 Budget CITY OF ALLEN Vehicle Replacement Fund CITY OF ALLEN VEHICLE REPLACEMENT FUND REVENUES AND EXPENDITURES BY FUNCTION ' FISCAL YEAR 2001-2002 1999-2000 2000-2001 2000-2001 2001-2002 ' REVENUES BUDGET BUDGET INTEREST EARNED ACTUAL AMENDED , Interest On Investments 95,382 129,025 95,616 67,461 SUBTOTAL $ 95,382 $ 129,025 $ 95,616 $ 67,461 ' OPERATING TRANSFER IN General Fund 472,189 700,409 705,218 792,384 , Water & Sewer 100,185 151,445 151,445 147,686 Solid Waste Drainage - 20,974 - 43,934 - 41,428 3,078 52,000 t Aquatics - -4,727 SUBTOTAL $ 593,348 $ 895,788 $ 898,091 $ 999,875 OTHER REVENUES ' Auction Revenue 5,271 - - - Other Revimbursements 9,500 ' SUBTOTAL 14,771 - - - TOTAL REVENUES ' $ 703,501 $ 1,024,813 $ 993,707 $ 1,067,336 , 1999-2000 2000-2001 2000-2001 2001-2002 EXPENDITURES Capital Outlay ACTUAL BUDGET AMENDED BUDGET ' Vehicle Replacement Fund 423,305 210,751 210,751 174,513 TOTAL CAPITAL OUTLAY $ 423,305 $ 210,751 $ 210,751 $ 174,513 , TOTAL EXPENDITURES ' $ 423,305 $ 210,751 $ 210,751 $ 174,513 FUND BALANCE PROJECTIONS PROJECTED FUND BALANCE 1011/01 3,354,073 ' TOTAL PROJECTED REVENUES 1,067,336 ' TOTAL PROJECTED EXPENDITURES (174,513) PROJECTED FUND BALANCE 9/30102 , $ 4,246,896 City of Allen Page 140 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 No Personnel In This Department Vehicle Replacement Fund DIVISIONS Vehicle Replacement 600-0000-490 City of Allen Page 141 FY 2002 Budget FUND DEPARTMENT ACCOUNT VEHICLE REPLACEMENT VEHICLE REPLACEMENT 600-0000-490 FUND DESCRIPTION The Vehicle Replacement Fund is administered by the Finance Department to collect depreciation allowances on current vehicles so that the City is able to replace them in a timely manner on a cash basis. FUND NARRATIVE Objectives for FY 2002: Re-evaluate current vehicle replacement plan to ensure vehicles are in service for appropriate lengths of time. t• Ensure that funds put into the Vehicle Replacement Fund are adequate to facilitate future replacement of department vehicles. City of Allen Page 142 FY 2002 Budget ' FUND DEPARTMENT ACCOUNT VEHICLE REPLACEMENT VEHICLE REPLACEMENT 600-0000490 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 RUnGFT 2000-2001 AMENDED 2001-2002 BUDGET ClC ILS FICATION Personnel Services - - ' Operations Professional Services - - - " Capital 423,305 210,751 210,751 174,513 DEPARTMENTTOTAL $ 423,305 $ 210,751 $ 210,751 $ 174,513 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 RUDGFT 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME TOTAL FULL TIME 0 0 0 0 PART TIME TOTAL PART-TIME 0 0 0 0 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 @UnGE2 2000-2001 AMENS 2001-2002 BUDGET CAPITAL OUTLAY Vehicles 336,305 138,626 138,626 174,513 Machinery & Equipment 87,000 72,125 72,125 - SUBTOTAL $ 423,305 $ 210,751 $ 210,751 $ 174,513 TOTAL EXPENSES $ 423,305 $ 210,751 $ 210,751 $ 174,513 City of Allen Page 143 FY 2002 Budget FUND DEPARTMENT ACCOUNT VEHICLE REPLACEMENT VEHICLE REPLACEMENT 600-0000490 CAPITAL EXPENDITURES LIST 2001-2002 QUANTITY BUDGET GENERALFUND: Police Patrol Cars 4 81,088 Parks && Recreation Rangers 2 25,874 F150 Truck 1 15,551 FCe Remount Ambulance 1 52,000 SUBTOTAL GENERAL FUND 8 174,513 TOTAL VEHICLE REPLACEMENT FUND 8 $ 174,513 City of Allen Page 144 FY 2002 Budget Self I Insurance Fund CITY OF ALLEN SELF INSURANCE FUND REVENUES AND EXPENDITURES BY FUNCTION ' FISCAL YEAR 2001-2002 1999-2000 2000-2001 2000-2001 2001-2002 REVENUES Operating Revenues ACTUAL BUDGET AMENDED BUDGET ' Charges for Self Insurance 1,153,613 1,639,162 1,787,575 2,501,829 Other Reimbursements 2,367 - 20,993 - Operating Transfer In 177,454 - 42,809 - ' Residual Equity Transfer In 128,147 SUBTOTAL $ 1,461,681 $ 1,639,162 S 1,851,377 $ 2,501,829 Non Operat ng Revenues ' Interest on Investments 16,719 20,000 26,373 18,607 Drawdown of Reserves - - 34,557 - ' SUBTOTAL $ 16,719 $ 20,000 $ 60,930 $ 18,607 ' TOTAL REVENUES $ 1,478,300 $ 1,659,162 $ 1,912,307 $ 2,520,436 EXPENDITURES 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET ' General Government ' Self Insurance 1,214,158 1,620,943 1,912,307 2,216,009 L GENERAL GOVERNMENT $ 1,214,158 $ 1,620,943 S 1,912,307 $ 2,216,009 TOTAL EXPENDITURES $ 1,214,158 $ 1,620,943 $ 1,912,307 $ 2,216,009 FUND BALANCE PROJECTIONS ' PROJECTED FUND BALANCE 10/1/01 229,586 TOTAL PROJECTED REVENUES 2,520,436 , TOTAL PROJECTED EXPENDITURES (2,216,009) PROJECTED FUND BALANCE 9/30/02 534,013 ' $ City of Allen Page 145 FY 2002 Budget ' CITY OF ALLEN, TEXAS FY 2001-2002 Personnel Director Benefit Coordinator 1 SELF INSURANCE FUND DIVISIONS SELF INSURANCE 610-0000-490 I' City of Allen Page 146 FY 2002 Budget DEPARTMENT SELF INSURANCE FUND DESCRIPTION The Self Insurance Fund was established in the 2000/2001 budget. It accounts for contributions and expenditures relating to health and dental insurance benefits provided to City employees. The City of Allen retains the risk for individual claims up to $40,000, up to a lifetime maximum of $2,000,000 in -network, and $1,000,000 out -of -network. Contributions to the fund are comprised of charges to operating departments for the City's share of benefits and payroll deductions for the employees' share. One goal of the fund is to recover the costs of the health plan through charges to departments and employees. The Self Insurance Fund will allow the City to effectively manage the plan's performance. At the end of FY 1999/2000, the Seff- Insurance Fund realized $1,214,157 in expenses, and $1,155,980 in revenues. The ending unreserved fund balance was $264,143. City of Allen Page 147 FY 2002 Budget FUND SELF INSURANCE DEPARTMENT SELF INSURANCE ACCOUNT 610-0000490 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services - 47,777 47,643 59,145 Operations 1,214,158 1,573,166 1,864,664 2,156,864 Professional Services - - - - Capital - - - - DEPARTMENTTOTAL $ 1,214,158 $ 1,620,943 $ 1,912,307 $ 2,216,009 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME Benefit Coordinator* 0 1 1 1 TOTAL FULL TIME 0 1 1 1 PART TIME TOTAL PART-TIME 0 0 0 0 ' Moved From General Fund Personnel EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUMMI PERSONNEL SERVICES Salaries - 38,544 37,283 41,113 Salary Reserve - - - 3,659 Longevity - 100 - 60 Overtime - 150 - 150 FICA Expenses - 2,566 2,043 2,940 TMRS Expenses - 3,505 2,772 3,965 Workman's Comp Expenses - 61 62 90 Health Insurance - 2,476 5,130 6,546 Dental Insurance - 258 261 460 Long -Term Disability - 91 74 111 Life Insurance - 26 18 51 SUBTOTAL $ - $ 47,777 $ 47,643 $ 59,145 OPERATING XP NC S Miscellaneous Operating Expen 85,335 7,300 293,192 337,170 Employee Health Fair - - - 12,500 Prescription Claims 100,036 90,011 188,577 216,864 Health & Dental Claims 1,028,787 1,475,855 1,382,895 1,590,330 SUBTOTAL $ 1,214,168 $ 1,573,166 $ 1,864,664 $ 2,156,864 TOTAL EXPENSES $ 1,214,158 $ 1,620,943 $ 1,912,307 $ 2,216,009 CAPITAL EXPENDITURES LIST No capital outlay for this department ' City of Allen Page 148 FY 2002 Budget I_ CITY OF ALLEN i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 COAST Fund CITY OF ALLEN COASTFUND REVENUES AND EXPENDITURES BY FUNCTION FISCAL YEAR 2001-2002 1999-2000 2000-2001 2000-2001 2001-2002 REVENUES ACTUAL BUDGET AMENDED BUDGET Operating Revenues Swim Team Revenue 10,740 11,750 11,750 13,125 SUBTOTAL $ 10,740 $ 11,750 $ 11,750 $ 13,125 Non Op rig Revenues Interest On Investments - 200 200 - Drawdown of Reserves 1,844 SUBTOTAL $ 1,844 $ 200 $ 200 $ - TOTAL REVENUES $ 12,584 $ 11,950 $ 11,950 $ 13,125 1999-2000 2000-2001 2000-2001 2001-2002 EXPENDITURES ACTUAL BUDGET AMENDED BUDGET Culture & Recreation Parks and Recreation 12,584 11,887 11,757 12,210 TOTAL EXPENDITURES $ 12,584 $ 11,887 $ 11,757 $ 12,210 TOTAL EXPENDITURES $ 12,584 $ 11,887 $ 11,757 $ 12,210 PROJECTED FUND BALANCE 10/1/01 TOTAL PROJECTED REVENUES TOTAL PROJECTED EXPENDITURES PROJECTED FUND BALANCE 9/30/02 2,413 13,125 (12,210) $ 3,328 City of Allen Page 149 FY 2002 Budget CITY OF ALLEN, TEXAS FY 2001-2002 Parks & Recreation Director Recreation Services Manager COAST Coach .25 Assistant Coaches .75 COAST FUND DIVISIONS COAST 704-0000-454 City of FUlen Page 150 FY 2002 Budget FUND DEPARTMENT ACCOUNT COAST COAST 704-0000-454 FUND DESCRIPTION The COAST (City of Allen Swim Team) is a .,• Host the Texas Amateur Athletic summer season only recreational swim Federation Region 7 "A" Regional Swim team. Ford Park swimming pool is the home Meet at the Don Rodenbaugh base for the program, which competes with Natatorium. other municipal sponsored swim teams throughout the Texas Amateur Athletic ,• Purchase race equipment for the Don Federation. Rodenbaugh Natatorium in conjunction with the COAST Parents Association. FUND NARRATIVE Accomplishments for FY 2001: Major Budget Items: •:• A total of 156 swimmers participated in the City of Allen Swim Team. ❖ Operations of the COAST program by hiring Coaches to run the program. :• COAST hosted a circuit swim meet at Ford Park swimming pool. ❖ Purchase race equipment for the Don Rodenbaugh Natatorium from the ❖ COAST also hosted the Texas Amateur annual carryover of COAST funds. Athletic Federation Region 7 "B" Regional Swim Meet. fi A total of 11 COAST swimmers qualified for the 2000 Games of Texas hosted by the Texas Amateur Athletic Federation in Midland. Objectives for FY 2002: :• Increase participation to 200 swimmers for the Summer COAST program. ❖ Begin a year round United States Swim Team program at the new Don Rodenbaugh Natatorium. S• Host two Texas Amateur Athletic Federation circuit meets. City of Allen Page 151 FY 2002 Budget FUND DEPARTMENT ACCOUNT COAST COAST 704-0000-454 EXPENDITURE SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET CLASSIFICATION Personnel Services 8,469 9,062 8,932 9,130 Operations 4,115 2,825 2,825 3,080 Professional Services - - - - Capital - - - - DEPARTMENTTOTAL § 12,584 § 11,887 $ 11,757 § 12,210 PERSONNEL SUMMARY 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET FULL TIME TOTAL FULL TIME 0 0 0 0 PART TIME TOTAL PART-TIME 0 0 0 0 TEMPORARY COAST Coach 0.00 0.25 0.25 0.25 Assistant Coaches 0.00 0.75 0.75 0.75 TOTAL TEMPORARY 0.00 1.00 1.00 1.00 EXPENDITURE DETAIL 1999-2000 ACTUAL 2000-2001 BUDGET 2000-2001 AMENDED 2001-2002 BUDGET PERSONNEL RVI S Salaries 8,210 8,250 8,250 8,415 Fica Expenses 208 631 631 522 Workman's Comp Expense 51 181 51 193 SUBTOTAL $ 8,469 $ 9,062 $ 8,932 $ 9,130 OPERATING XP N S Miscellaneous Oper. Exp. 4,115 2,825 2,825 3,080 SUBTOTAL $ 4,115 $ 2,825 $ 2,825 $ 3,080 TOTAL EXPENSES $ 12,584 $ 11,887 $ 11,757 $ 12,210 CAPITAL EXPENDITURES LIST No capital outlay for this department ' City of Allen Page 152 Fy 2002 Budget CITY OF ALLEN ' 2001=2002 Capital Improvement ' Program I I I I I FY 2002 Capital Budget FY 2002 Capital Budget in $000s Category Government CBD ID# YR FIN. ID Project Name FY 2002 CBDO14 2002 CBD Star Fountain Entry 15 020002 2002 Civic Center Plaza 75 Public Safety Subtotal CBD 90 Library YR FIN. ID Project Name FY 2002 Of YR FIN. ID Project Name FY 2002 011001 2001 LB0101 Main Library/Auditorium 974 Subtotal Library Parks ID# YR FIN. ID Project Name FY 2002 01P003 2001 Senlw Citizens Center 225 Subto i Pants 225 Public Safety ID# YR FIN. ID Project Name FY 2002 OI F001 2000 P30004 Central Fire Station/Training Tower 2,475 01F002 2002 Fire Station No. 5 and pumper 935 OOPo01 2000 PS0001 Police Building 15 panslon 1.352 Subtotal Public Safety 4,762 Subtotal Government 6,051 City of Allen Page 163 FY 2002 Budget FY 2002 Capital Budget in $000s Category Parks Community Park YR FIN. ID Project Name ID# YR FIN. ID Project Name FY 2002 01 PD06 2002 PRO102 Allen Station Park (Phases 2 8 3) 750 OOP003 2000 PR0004 Malone Community Park 6,468 02P008 2002 Rowlett Creek Community Park 1,350 02PO12 2002 YR Watters Branch Community Park 2,250 Community Park Greenbelt ID# YR FIN. ID Project Name FY 2002 OOPD09 2001 PRO05 Trail Development 300 02P009 2002 Subtotal Greenbelt 300 Neighborhood Parks Subtotal Park Facilities 370 ID# YR FIN. ID Project Name FY 2002 OOP005 2000 PRO101 Bolin Park Fence -139 01POOl 2002 Fore Park Renovations 210 01P002 2002 Hillside Park Development 100 02P003 2002 Lost Creek Neighborhood Park 100 02P006 2002 Neighborhood Park 200 02P004 2002 Stacy Ridge Nelghbodlaed Park 50 OOPO06 2002 PR0008 Stay Park Development 50 Neighborhood Parka Park Facilities ID# YR FIN. ID Project Nam FY 2002 OID003 2001 DR9406 Historic Stare Dam StablUetion 270 02P009 2002 Park Signage 100 Subtotal Park Facilities 370 Parks Facilities ID# YR FIN. ID Project Name FY 2002 02P007 2001 Allen Heritage House 280 Subtotal Parks Facilities eau Subtotal Parke 12,617 City of Allen Page 154 FY 2002 Budget I FY 2002 Capital Budget In $000s , Category Public Works CBD IDN YR FIN. ID Project Name FY 2002 CBDO1 2002 Allen Drive 156 CB3003 2002 Ash Drive 460 CBDO05 2002 St. Mars Dave 121 2001 Subtotal CBD 737 Drainage IDN YR FIN. ID Project Name FY 2002 01DO02 2002 DR0108 Bowling Alley Drainage 40 02DO02 2002 DR0309 GabionStruclums - 50 01DO01 2001 Hillside Drainage 287 00DO01 2001 DR9301 Mustang Creek 477 Subtotal Drainage 854 Sidewalks - IDN YR FIN. ID Project Name FY 2002 025004 2002 Residential Sidewalks 110 005005 2000 ST9508 SH5 SidewalksNghting1landscaping 450 Subtotal Sidewalks 560 Street IDN YR FIN. ID Project Name FY 2002 015008 2000 ST0101 Allen Heights Drive Rehabilitation - 1,116 005001 2001 ST0138 Alma Drive Extension 460 O1S010 2001 ST0035 Angel Parkway/Malone Road 1,201 DOS006 2000 ST99N Chaparral Road Extension 819 00SO07 2002 ST0113 East Bethany Drive Expansion 308 025001 2002 ST0123 East Exchange Parkway Expansion 514 015005 2001 STOW FM 2170 Extension (Main Sbs et) 600 035005 2002 Median Landsceping4rrigabon 230 018003 2001 STO110 SH 5 Expansion 2,117 00SO03 2001 ST9829 Stacy Road Extension - Went 3,050 02S003 2002 Wallen Road at Stacy Road 350 OOS004 2002 ST9903 West Bethany Drive Extension 4,892 Subtotal Street 15,557 Street Maintenance IDN YR FIN. ID Project Name FY 2002 015002 2001 ST0142 Concrete Alley Replacement 200 015001 2000 ST0141 Replace Asphalt Pavement 350 Subtotal Street Maintenance 550 City of Allen Page 155 FY 2002 Budget Water IDR YR FIN. ID Project Name FY 2002 o1W0ol 2001 WA0027 Allen Heights Ddve Water Main 1,440 01WO14 2001 WA9931 Alma Main Extension 195 FY 2002 Capital Budget in $000s 2001 Trade Custer Pump Sudan 75 01WO16 2001 WA9923 Fencing, landscaping. sidewalks 75 01WO12 2001 WA0133 IDR YR FIN. ID Project Name FY 2002 Main Overs¢irg 01T001 2001 ST0143 Signal Shop and Signals 200 ' 967001 2000 2001 Traffic Signals 233 300 02WO02 2001 WA0036 Subtotal Traffic 433 02WO03 2002 Water tine Replacement Subtotal Public Works 16,691 ' Category Utilities West Bethany 18' Mein 225 04W005 2002 Wastewater Westside Water Main 300 IDR YR FIN. ID Project Name FY 2002 ' 02%003 2002 WA0216 Cobonwood Creek Replacement 900 02X004 2002 WA0215 Ola IM Station Replacement 432 02X002 2002 Sewer Main Oversmng 100 ' 00X01 2002 WA0178 Sewer Main Replacement 500 02X001 2002 Stacy Ridge lift Station 175 . Subtotal Wastewater 2,107 Water IDR YR FIN. ID Project Name FY 2002 o1W0ol 2001 WA0027 Allen Heights Ddve Water Main 1,440 01WO14 2001 WA9931 Alma Main Extension 195 01W015 2001 WA9925 Custer Pump Sudan 75 01WO16 2001 WA9923 Fencing, landscaping. sidewalks 75 01WO12 2001 WA0133 Hedgcoze Water Main 270 02W08 2001 WA0134 Main Overs¢irg 400 01W03 2001 WA0112 Presfige Elevated Storage 485 01WO02 2001 WAD132 SCADA 300 02WO02 2001 WA0036 Slacy Rd Pump Station 5,410 02WO03 2002 Water tine Replacement 250 01WO04 2002 West Bethany 18' Mein 225 04W005 2002 WA0335 Westside Water Main 300 Subtotal Water 9,425 Subtotal utilifies 11,532 Total FY 2002 Projects 48,891 City of Allen Page 156 FY 2002 Budget �_ CITY OF ALLEN ' Demographics CITY OF ALLEN DEMOGRAPHICS 2001-2002 FISCAL YEAR The City of Allen is located in Collin County, which is in north central Texas. It is approximately 20 miles north of interstate 635 on U.S. 75. Allen is completely surrounded by incorporated cities. To the north lies the City of McKinney; to the south, the City of Plano; to the east, the Town of Lucas; and to the west, the City of Plano. Allen was settled in the early 1850's from land grants given by the Republic of Texas as an inducement for settlers to come to the frontier. The railroad and telegraph came to Allen in 1872 and in future years made substantial contributions to the economy of the City. The town was officially incorporated in 1953 with a Council/Manager form or government. Similar in importance to the construction of the railroad almost a century before was the completion of U. S. 75 through Allen in 1960. Citizens could work at nearby companies because of the access and convenience of the highway. The relocation of high technology companies to the North Dallas and Richardson areas in the 1960's drastically increased employment opportunities for Allen's citizens, and the population rose to 1,940. It continued to increase to 8,324 in 1980, 19,198 in 1990, 39,482 in 1998, and is estimated to surpass 85,000 by the year 2010. Allen is 25 miles north of downtown Dallas, on U. S. Highway 75. The City has established a reputation in the Dallas/Fort Worth Metroplex and in the state of Texas for being at the forefront of development and is promoting commercial and residential growth in ways that will aid in having a balanced community. Important transportation routes serving the city include U. S. 75, which bisects the city in a north/south direction in the center of the city and provides an important link to adjacent cities. F.M. 2170 runs in an easUwest direction in the center of the city. S.H. 5, which formerly was the main north/south thoroughfare, lies roughly parallel to U. S. 75. City W Allen Page 157 FY 2002 Budget I ' CITY OF ALLEN ' DEMOGRAPHICS 2001.2002 FISCAL YEAR ' Since its inception in 1992, the Allen Economic Development Corporation has dedicated its resources to developing first-class technology parks and recruiting quality industries ' to the community. Allen's corporate landscape is now a well-designed blend of telecommunication, medical, semiconductor, and other technology -related industries. 1 1 1 1 During 2001, significant additions have been made to Allen's impressive list of existing companies. AEDC projects completed and started in 2001 will add approximately 1,155 new jobs, $187 million on the local tax rolls, and 1.2 million square feet of new space in Allen. Adding to the Allen skyline, Trammell Crow Company constructed Enterprise Office ll, a two-story office building with Daisytek and Micron Technology as tenants. Trammell Crow Company has begun construction on a two-story office/tech building in Allen Station Business Park. This master planned park will ultimately include 4.4 million square feet of office/tech space on 14 acres. $4,000,000,000 $3,000,000,000 $2,000,000,000 $1,000,000,000 $0 Assessed Property Valuations MM 1� 11M 1.M 1M 1� IMS f OM1 Shoppers from across the Metroplex now travel to Allen to visit the Allen Premium Outlets. The project has not only placed $60 million on the local tax rolls, but is one of the largest sales tax generators for the City. Phase II of the project was completed during 2001. This project includes up to 60 individual retailers and 500,000 square feet. Over the past year, the AEDC has coordinated efforts between the investment community, City of Allen, and Hilton Corporation to bring a six -story, full-service hotel to Allen. The AEDC also structured incentive programs to make the hotel a reality. The Hilton is currently under construction to be completed early 2002. The AEDC is currently working with developers on the construction of a first-class, four- story office building in Millennium Corporate Center. The group is also working with developers on additional tech space in Twin Creeks Business Park. City of Men Page 158 FY 2002 Budget CITY OF ALLEN MISCELLANEOUS STATISTICAL INFORMATION 2001- 2002 FISCAL YEAR Date of incorporation Form of government Area Miles of street Population (2001) Fire protection: Number of stations Number of personnel Number of fire hydrants Police protection: Number of stations Number of personnel Water service: Supplier Number of consumers Average daily consumption Miles of water lines Sewer service: Sanitary sewer lines Storrs sewer lines Building permits issued Parks Number Area Municipal employees: Full-time Part-time Temporary Public education Number of colleges Number of public schools Number of private schools July 1, 1953 Council/Manager 27.1059 square miles 216.03 center line miles 54,421 4 75 3584 1 87 North Texas Municipal Water District 17,897 9,632,057 gallons 242.88 linear miles 209.55 linear miles 71.29 linear miles 6013 38 830 acres 354 31 13 0 10 elem., 2 middle schools, 1 freshman center, 1 high school 0 City of Mien Page 159 FY 2002 Budget Glossary Glossary line by division. ' Activity A specified and distinguishable of work performed a ADA Americans with Disabilities Act ' Ad Valorem A tax computed from the assessed valuation of land and improvements. AISD Allen Independent School District ' Appropriation An authorization made by the legislative body of a government which permits officials to Incur obligations against and to make expenditures of governmental resources. Specific appropriations are usually made at the fund level and are granted for a one year period. Appropriation The official enactment by the legislative body establishing the legal ' Ordinance authority for officials to obligate and expend resources. Arbitrage The ability to obtain tax�exempt bond proceeds and invest the funds in higher ' yielding taxable securities resulting in a profit. Arbitrage restriction requirements describe the circumstances in which investment In materially higher yielding securities is allowed without compromising the tax-exempt status of the bond ' issue. The rebate requirements identify what must be done with profits earned from those securities under the arbitrage restriction requirement. Assessed valuation A value that is established for real or personal property for use as a basis for levying property taxes. (Note: Property values are established by the Central Appraisal District.) , Assets Resources owned or held by the City which have monetary value. Balanced Budget A budget adopted by the legislative body and authority by ordinance where the , proposed expenditures are equal to or less than the proposed resources. Bonds A written promise to pay a sum of money on a specific date at a specified interest rate. The interest payments and the repayment of the principal are , detailed in a bond ordinance. The most common types of [ands are general obligation and revenue bonds. Budget A plan of financial operation embodying an estimate of proposed means of financing it. The "operating budget" is the financial plan adopted for a single fiscal year, The "proposed budget" designates the financial plan initially developed by departments and presented by the City Manager to the Council ' for approval. The "adopted budget" is the plan as modified and finally approved by that body. The approved budget is authorized by ordinance and thus species the legal spending limits for the fiscal year. ' Budget Adjustment A legal procedure utilized by the City Staff and City Council to revise a budget appropriation. t Budget Document The compilation of the spending plans for the various funds, along with supporting schedules, tables and charts which, in total, comprises the annual revenue and expenditure plan. ' Budget Control The control or management of the organization in accordance with an approved budget for the purpose of keeping expenditures within the limitations ' of available appropriations and revenues. City of Allen Page 161 FY 2002 Budget , City of Allen Page 162 FY 2002 Budget Glossary Capital Outlay An expenditure which results in the acquisition of or addition to fixed assets, and meets these criteria: has an anticipated useful life of more than one year; can be permanently Identified as an individual unit of property; belongs to one of the following categories: Land, Buildings, Structures & Improvements, Equipment; constitutes a tangible, permanent addition to the value of the City assets; cost generally exceeds at least $5,000; does not constitute repair or maintenance; and, is not readily susceptible to loss. Capital Reserve Funds that have been appropriated from operating revenues which are to be set aside for designated types of maintenance to the existing infrastructure. CATV Cable Access Television CIP Capital Improvement Program Contingency Fund A budgetary reserve set aside for emergencies or unforeseen expenditures not otherwise budgeted. Cost Center A section of the total organization having a specialized function or activity, and segregated cost and revenue data. Covenant A binding agreement; contract. Current Taxes Taxes that are levied and due within one year. DARE Drug Abuse Resistance Education DART Dallas Area Rapid Transit Delinquent Taxes Taxes that remain unpaid on and after the date on which a penalty for non- payment Is attached. Debt Service Fund A fund used to account for the monies set aside for the payment of interest and principal to holders of the City's general obligation and revenue bonds, the sale of which finances long-term capital improvements, such as facilities, streets and drainage, parks and water/wastewater systems. Depreciation (1) Expiration in the service life of capital assets attributable to wear and tear, deterioration, action of the physical elements, inadequacy or obsolescence. (2) That portion of the cost of a capital asset which is charged as an expense during a particular period. EMS Emergency Medical Service EMT Emergency Medical Technicians Encumbrances Obligations in the form of purchase order, contracts or salary commitments which are chargeable to an appropriation and for which a part of the appropriation is reserved. When paid, the encumbrance is liquidated. City of Allen Page 162 FY 2002 Budget Glossa Enterprise Fund A fund established to account for operations that are financed and operated in a manner similar to private business enterprises-- where the intent of the governing body is that the costs of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges. EPA Environmental Protection Agency ERF Equipment Replacement Fund Expenditures The cost of goods received or services rendered whether cash payments have been made or encumbered. Fiscal Year A twelve-month period designated as the operating year for accounting and budgeting purposes in an organization. The City of Allen has specified October 1 to September 30 as its fiscal year. FLSA Fair Labor Standards Act Fund An accounting device established to control receipt and disburse income from sources set aside to support specific activities or attain certain objectives. Each fund is treated as a distinct fiscal entity with a self -balancing set of accounts. Fund Balance The excess of a fund's current assets over its current liabilities; sometimes called working capital In enterprise funds. A negative fund balance is often referred to as a deficit. Funding Provides budgetary resources to cover the total cost of a program or project at the time it is undertaken. GAAP Generally Accepted Accounting Principles GASB Governmental Accounting Standards Board General Fund The fund used to account for all financial resources except those required to be accounted for in another fund. The General Fund is tax supported. General Obligation Debt Monies owed on interest and principal to holders of the City's general obligation bonds. The debt is supported by revenue provided from real property which is assessed through the taxation power of the local governmental unit. Generally Accepted Detailed accounting standards and practices for state and local governments as Accounting Principles prescribed by the Governmental Accounting Standards Board (GASB). (GAAP) GIS GO Debt Infrastructure Geographic Information System General Obligation Debt That portion of a city's assets located at or below ground level, including the water system, sewer system, and streets. City of Allen Page 163 FY 2002 Budget , 11 ' Performance Indicators ' Glossary Internal Service Fund A fund used to account for the financing of goods or services provided by one City department or cost center to other departments, on a cost -reimbursement ' basis. Liabilities Debt or other legal obligations arising out of transactions in the past which ' must be liquidated, renewed, or refunded at some future date. This term does ' not include encumbrances. Modified Accrual The accrual basis of accounting adapted to the governmental fund type Basis spending measurement focus. Under it, revenues are recognized when they ' become both "measurable" and "available to finance expenditures of the current period." Expenditures are recognized when the related fund liability is Incurred except for (1) inventories of materials and supplies which may be considered expenditures either when purchased or when used; (2) prepaid insurance and similar items which need not be reported; (3) accumulated unpaid vacation, sick pay, and other employee benefit amounts which need not be recognized In the current period, but for which larger -than -normal accumulations must be disclosed in the notes to the financial statements; (4) interest earnings on special assessment levies; and (5) principal and interest on long-term debt which are generally recognized when due. NCTCOG North Central Texas Council of Governments NTMWD North Texas Municipal Water District Note A certificate pledging payment, issued by a government or bank. Operating Budget Plans of current expenditures and the proposed means of financing them. The annual operating budget is the primary means by which most of the financing, acquisition, spending, and service delivery activities of the City are controlled. The use of annual operating budgets is required by State Law. ' Performance Indicators ' Specific quantitative measures of work performed within an activity or program. They may also measure results obtained through an activity program. Monies contributed by several operating funds and set aside to finance significant unforeseen losses, which are uninsured. A form of self -Insurance. Quality Improvement Process Repayment to a specific fund for expenditures incurred or services performed by that fund to or for the benefit of another fund. The cost of an asset which can render similar service (but which need not be of the same structural form) as the property to be replaced. An account used to indicate that a portion of fund resources is restricted for a specific purpose, or is not available for appropriation and subsequent spending. A backup fund for payment of matured bonds and interest should the Water & Sewer Debt Service Fund fall short of required amounts. All amounts of money received by a government from external sources other than expense refunds, capital contributions, and residual equity transfers. Page 164 FY 2002 Budget Property/ Liability Loss Fund QIP ' Reimbursement ' Replacement Cost ' Reserve Reserve Fund Revenues ' City of Allen Specific quantitative measures of work performed within an activity or program. They may also measure results obtained through an activity program. Monies contributed by several operating funds and set aside to finance significant unforeseen losses, which are uninsured. A form of self -Insurance. Quality Improvement Process Repayment to a specific fund for expenditures incurred or services performed by that fund to or for the benefit of another fund. The cost of an asset which can render similar service (but which need not be of the same structural form) as the property to be replaced. An account used to indicate that a portion of fund resources is restricted for a specific purpose, or is not available for appropriation and subsequent spending. A backup fund for payment of matured bonds and interest should the Water & Sewer Debt Service Fund fall short of required amounts. All amounts of money received by a government from external sources other than expense refunds, capital contributions, and residual equity transfers. Page 164 FY 2002 Budget Glossa Rolling Stock Those capital items such as motor vehicles, heavy equipment, and other apparatus which is maintained by the Equipment Services department. ROW Right-of-way Service Area Major division within the total organization performing a function, which is composed of departments and is under the oversight of an Assistant City Manager who reports to the City Manager. Service areas include: Administration, Development, and General Government. SH State highway SSI Service Standard Index STEP State Traffic Enforcement Program Tax Rate A percentage applied to all taxable property to raise general revenues. It Is derived by dividing the total tax levy by the taxable net property valuation. Taxes Compulsory charges levied by a government for the purpose of financing services performed for the common benefit. TMRS Texas Municipal Retirement System TNRCC Texas Natural Resources Conservation Commission W & S Water & Sewer City of Allen Page 165 FY 2002 Budget