Loading...
HomeMy WebLinkAboutResolution - 2005-R0308 - Approve Lubbock Emergency Communication Disctrict Budget FY 2005-2006 - 07_14_2005Resolu06A No. 2005-R0308 July 14, 2005 Item 21 RESOLUTION BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF LUBBOCK: THAT the Mayor of the City of Lubbock BE and is hereby authorized to approve the Lubbock Emergency Communication District Budget for Fiscal Year 2005-2006. Documents incorporating this budget are incorporated in this Resolution as if fully set forth herein and shall be included in the minutes of the City Council. Passed by the City Council this 14th day of ATTEST: - f� kt� -e.- Rebecca Garza, City Secretary rohn M. Knight l/ Assistant City Attorney as/CityAtt/John/Resolutions/LECD05-06 July 5, 2005 I ,® /,/" �/, 'a -16211 Lubbock Emergency Communication District 1 5. Ea � "...to provide the best possible, trouble free 9-1-1 network for the citizens we serve... " Fiscal Year 2005-2006 Proposed Budget LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET Table Of Contents FY 2005-2006 BUDGET AgencyOverview........................................................................................1 Significant Activities FY 2005-2006...........................................................7 Budget Narrative District Operations ................... .............. .... .......................9 Database....................................................................................15 LECDQuarterly.............................................................................22 Information Systems......................................................................23 Public Education Program.............................................................25 PSAPSupport ..................................... ......... .............. ... .27 FY 2005-2006 Revenue Forecast.............................................................38 Charts 1 & 2 — Revenue Comparison............................................39 Chart 3 — Revenue vs. Expenses..................................................40 Financial Charts Chart 4 - Budget Breakdown...........................................................41 Chart 5 - Budget Breakdown/PSAP Support ..................................42 Chart 6 - Budget Breakdown/District Operations ...........................43 9-1-1 Calls Chart7 - PSAP..............................................................................44 Chart 8 - 9-1-1 Calls for Service...................................................45 Proposed Budget 2005-2006 LUBBOCK EMERGENCY COMMUNICATION DISTRICT ITEM PROPOSED 2005-2006 BUDGET TOTAL BUDGET TOTAL BUDGET 2004-2005 2005-2006 DESCRIPTION I Wireline $960,300' _ Wireless _---`---�-- _ _ $870,000 Interest _ - $103,000 _ TOTAL PROJECTED REVENUE i $1,933,300 From Reserves- $570,286�- TOTAL ALLOCATED FUNDS SALARYIEMPLOYEE EXPENSE Salaries - Full Time _ _ Salaries - Part Time - Retirement Expense _ . _. __._._._.. _._._ ..._ __. $303,700; - - _ - -_ $29,3501 -- $2,503,58 - $315,000, Page 9,15-17,19-23,25,33 $18,700 1 Page 9,20-21 --- $28,500 1 Page 9 - _ _---_ Insurance Benefit _ rk Woers' Compensation TEC - Unemployment - ._._ FICA - Benefit _ _- ____118.4001 $51,000 $1,100 _ . .. _ _ $1,700 - $26,000; $52,300 Page 9 _ _ - _ -- $1,39q[Fage $1,6001Page _ $26,500 9 10 - - Page 10- Payroll Service_ $1,000 - $1,000 Page 10 - - _- Pre -Employment Expense $3,000 $3,000 Page 10 _ Other Benefits--- $5,000 $5,000 Page 10 TOTAL SALARY/EMPLOYEE EXPENSE $440,250 $452,900 _ - SUPPLIES _ Office/Operating-Su-pp-lies $2,500 $2,500 Page 10,15,23 Other Supplies $4,000 $4,000 Page 10 Educational Supplies $1,100 $1,100 Page 10,24 _ Postage _ $2,000 $1,200 Page11,15,22 _-- - - Mapping Supplies_ --_ - $1,000 $1,000 Page 11,21 -_ - - Printing - $2,200 $2,500 - Page 11,15,22 TOTAL SUPPLIES $12,800 _ $12,300 MAINTENANCE _ - Office Equipment Maintenance $1,000 $1,5001 Page 11,23 _ Computer Equipment Maintenance $12,200 $11,700 Page 11,23,24 Facility Maintenance - $800 $4,000 Page 11 -_- Small Tools & Equipment $600 $700 Page 11,23 - -_ -_-1 Rent/Lease Machinery _ - TOTAL MAINTENANCE OTHER SERVICES/EXPENSES__ _-- $3,000 $17,600 $3,000 Page 11 $20,900 _ Rent/Lease_Facilities _ $46,000 $46,500 Page 12 ____ Lobbyist Services_ _ _ _ Legal Services - _v _ __- $3,000 -_ $13,600 - - - $3,600 $18,400 Page 12 Page 12 - Accounting Services - - $5,000 $5,000 Page 12 -_- _ Public Education $37,100 $34,050 Page 12,25 Services - $6,000 $3,000 Page 12,24 _Professional - --- ----_ --- --_- Telephone __ -- $12,500 $11,500 Page 12 _ Professional Dues and Memberships -- -�- $2,000 $2,600 - Page 13 Travel ---_ ----- --- $17,700 _ $17,700 - Page 13,18 - $8,300 _! - $8,300 Page 13,18,24 Insurance_ $9,000 $9,0001Page 13 _ - - - - _ --__ Vehicle Expense _ _ $12,200 $12.2001 Page 13- TOTAL OTHER SERVICES/EXPENSES $172,4001 $171,8501 CAPITAL _ __ Office Fumitur_e - $1,000 $1,000 Page 13 _- Communication Equipment _ $18,000 - $1,0001Page 13 _ - Computer Equipment _Capital Improvements -_ - $1,800 _ $01Page 23 _ Computer Equipment - Replacement $4,0001 $7,700 Page 14,23 TOTAL CAPITAL $24,8001 $9,700 TOTAL DISTRICT OPERATIONS ' $667,8501 $667,6501 EQUIPMENT REPLACEMENT FUND-LECD + 14,3191 11,936 Page 14 2005-2006 Proposed Budget.xis LUBBOCK EMERGENCY COMMUNICATION DISTRICT _ PROPOSED 2005-2006 BUDGET TOTAL BUDGET TOTAL BUDGET ITEM ; 2004-2005 2005-2006 DESCRIPTION Other PSAP Support ----- ---- --- -1 - $416,2001 Recurring Charges $448,500 Page 29 -- _--- Maintenance Charges _ _—- $1,161,500 $326,000 Page 30-32 Telecommunicator Training/Travel --- $12,500 - $15,000 Page 33 Catastrophic Contingency $100,000 $100,000 Page 34 Street Signs - — -- — --- -- -_ — !- -- -- ------ $10,500 $7,500 Page 17,34 ---_--_ Intergovernmental Aerial Mapping - -- - --- - -_ --_ _- — $5.000!Page 34 __ Equipment Replacement Fund-PSAP- $430,000jPage 34 Total Other PSAP Support - $1,700,7001 $1,332,0001 Projects _ Wireless Implementation $1,200,000 P _ _ _-- .. _ . _ _ $100,000IPage 35 Emerging Technologies $300,000; Page 35 PSAP Grant Funding $129,600I $75,000;Page 35 CLEC Audit $17,0001Page 35-36 - -- _ -- ---_i Total Projects $1,329,6001 $492,000 _ TOTAL PSAP SUPPORT $3,030,300 $1,824,000 TOTAL $3,712,4691 $2,503,586 2005-2006 Proposed Budget.xis LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET AGENCY OVERVIEW Background The creation of the Lubbock Emergency Communication District was approved by an overwhelming vote of the public in 1986. Authority to create the District was provided in Vernon's Texas Civil Statute 1432e (later codified in Texas Health and Safety Code Section 772.301 through 772.329, the Emergency Telephone Number Act for Cities with population over 20,000.) The District's mission upon creation was to establish 9-1-1 as the primary phone number to be used in an emergency in Lubbock County and the Emergency Telephone Network associated to provide the Enhanced 9-1-1 Service. All political subdivisions within Lubbock County assisted in this mission by establishing eight (8) Public Safety Answering Points (PSAPs) to receive emergency 9-1-1 calls. Our mission continues, but now in a different form. "The mission of the Lubbock Emergency Communication District is to provide the best possible, trouble free network for the citizens we serve to access emergency services by dialing 9-1-1; to provide the best tools (equipment and information) to each service provider agency that will enhance their ability to provide public safety services; and to educate the public on the effective and appropriate use of the 9-1-1 network." The City of Plainview joined the Lubbock Emergency Communication District through an interlocal agreement in January 1989. A six member Board of Managers oversees the Lubbock Emergency Communication District. Two appointments to the Board are made by the City of Lubbock, one by the County of Lubbock, one by the City of Slaton, one at -large appointment (made by the other Board Members), and one ex-officio member representing SBC, the primary telephone service provider in Lubbock County. Enhanced 9-1-1 operations started within LECD boundaries on January 27, 1989. Since that time more than 2.5 million 9-1-1 calls have been handled by the Public Safety Answering Points (PSAPs) supported by LECD. The 9-1-1 call taking equipment at each of the PSAPs supported by LECD was replaced with Vesta 9-1-1 standard telephony/computer equipment in fiscal years 1999-2000 and 2000-2001. This project replaced the original 9-1-1 call taking equipment that was installed in January of 1989. In fiscal year 2003-2004 all of the monitors used in the seven (7) PSAPs using the Plant Equipment, Inc Vesta software were replaced. The replacement monitor is an LCD type which should Proposed Budget 2005-2006 Page 1 resist the "bum in" problem suffered with the previous CRT type monitors. In fiscal year 2004-2005 all of the workstations and servers at the seven (7) PSAPS using the Plant Equipment, Inc Vesta software were replaced with current technology equipment. This new equipment included faster processors, larger hard drive, more RAM and dual monitor video cards. ALI queries are now being sent out through a computer program known as EAS. This program also reformats the incoming ALI responses so that they all appear the same to the dispatcher. This same program will give LECD the ability to use TCP/IP to make ALI requests and receive ALI responses. In fiscal year 2000-2001, all of the Wireless Service Providers within the District began providing Wireless E9-1-1 Phase 1 Service. In fiscal year 2002-2003 Wireless Phase II implementation began. In fiscal year 2004-2005, all six (6) of the major Wireless Service Providers in the District are providing Wireless E9-1-1 Phase II Service. The staff of LECD and the Board of Managers are continually looking forward, researching equipment, techniques and training to assist the Public Safety Telecommunicator in doing a better, more efficient job of providing emergency help to people calling 9-1-1. Proposed Budget 2005-2006 Page 2 Staff In addition to the Board of Managers, the District employs a staff of six (6) full time employees and one (1) part time employee. EXECUTIVE DIRECTOR — Has total oversight of the operation of the District. Is responsible to the Board of Managers for carving out the mission of the District. OPERATIONS MANAGER — Is in charge of the day -today operations of the District, including payroll, accounts payable/receivable, PSAP personnel training, and other responsibilities. Supervises the Office Coordinator. Assumes the role of "Acting Executive Director" in the absence of the Executive Director. Is responsible to the Executive Director. DATABASE MANAGER — Is in charge of providing addresses in the unincorporated areas of the County, verifying and correcting the MSAG (Master Street Address Guide) and supervising the Database Technician and GIS Coordinator. Database Manager assumes the role of "Acting Executive Director" in the absence of both the Executive Director and the Operations Manager. Is responsible to the Executive Director. DATABASE TECHNICIAN — Works with the Database Manager in the assignment of addresses in rural Lubbock County. Is responsible for maintaining an accurate database of the road signs that are purchased by the District and maintained by the Lubbock County Road Department. Works with the US Postal Service on address conversions from rural routes to physical addresses. Is responsible to the Database Manager. IS TECHNICIAN —Administers the internal computer network, which includes all hardware and software. Assists staff in the use of computer programs. Plans for future impact on the computer hardware/software used intemally by the District. Is responsible to the Executive Director. OFFICE COORDINATOR — Responsible for coordinating office services and administrative activities of the District, including meeting arrangements, supply monitoring, facility requirements and Public Education events. Is responsible to the Operations Manager. GIS COORDINATOR — This part time position is charged with the creation and verification of a GPS accurate street level map. Is assigned to maintain a centerline map file with accurate address/block ranges, which will be used by various emergency response agencies. Is responsible to the Database Manager. Proposed Budget 2005-2006 Page 3 Responsibilities MAINTENANCE OF MSAG — The MSAG (Master Street Address Guide) is the database that is used to determine to which PSAP 9-1-1 calls should be sent. The MSAG is also used to validate telephone subscriber addresses. RURAL ADDRESSING — Lubbock County Commissioners Court appointed LECD as sole addressing authority for all unincorporated areas of Lubbock County. LECD coordinates the provision and use of these addresses with all affected parties. MAP DEVELOPMENT — The centerline map that has been developed is used by PSAPs to locate the 9-1-1 call graphically on a map display. This takes place with both wire -line and wireless calls. The wireless call location appears when the PSAP receives a Wireless Phase II 9-1-1 call. LECD produces map books for use by the PSAPs and the field emergency responders. 9-1-1 NETWORK — LECD ensures the network that transports the 9-1-1 call is operating properly. This is accomplished by working closely with the telephone companies and jointly testing and reporting problems when they occur. 9-1-1 SERVICE FEE — LECD is responsible for receiving, tracking, and depositing service fee revenue from the telephone companies that provide dial tone within the District. CLECS — LECD is responsible for identifying and contracting with CLECs (Competitive Local Exchange Carriers) regarding provision of 9-1-1 service to their customers that reside within the District. WIRELESS — LECD is responsible for identifying and working with wireless service providers in implementing and testing the latest technology to facilitate the location of wireless callers to 9-1-1. CALL TAKER EQUIPMENT — LECD provides the equipment used at each PSAP to receive and answer the 9-1-1 calls. Specialized software is also provided to maintain a record of every 9-1-1 call that comes into the PSAP. LECD, through the use of maintenance contracts, assures that the equipment is working at its peak performance level at all times. The CPE (Customer Premise Equipment) is monitored remotely by Plant Equipment, Inc. with the use of a service called Mission Control. This system automatically notifies Plant Equipment of any problems with on -site CPE 247. LECD staff is also trained to troubleshoot, identify and repair minor configuration problems and serve as a resource to the PSAP personnel for technical information and problem resolution. LECD maintains a wide area network (WAN) that allows all PSAPs to exchange information with each other and with the District. The WAN also provides user tips, equipment/software operation instruction and electronic equipment trouble reporting. Proposed Budget 2005-2006 Page 4 LOGGING RECORDERS — Part of the equipment that LECD provides to the PSAPs that it supports is logging recorder equipment. This equipment makes a recording of every 9-1-1 call that is handled by the PSAP. Again, through the use of maintenance contracts, the equipment is maintained in peak operating condition. PUBLIC EDUCATION — The District is the primary supplier of educational material and public training programs on the use of 9-1-1. TELECOMMUNICATOR TRAINING — This is a big benefit to all agencies that operate a PSAP. LECD staff conducts training classes on Basic 9-1-1, the use of the Vesta workstation and the administration of the Vesta telephone equipment. The District also provides tuition funds so that telecommunicators can take advantage of numerous training opportunities. Funds are also available to sponsor classes in the local area. STREET SIGNS — LECD pays for the manufacture of street signs in Lubbock County for placement at the intersection of roads. The signs provide the street name and the block range at that location. These signs provide direction not only for emergency responders, but also for mail and other delivery service. PREPARATION AND HOSTING OF MEETINGS — Many hours are spent each month preparing information for a variety of meetings that are hosted by LECD. The monthly Board of Managers and User Group meetings take several hours to plan, prepare and transmit information for. Meetings are held monthly with SBC and as needed with other service providers and agency officials. QUARTERLY NEWSLETTER — The Database Manager serves as the Editor for this newsletter that is published every quarter. The publication takes many hours of the staffs time to prepare. More than 200 newsletters are mailed to PSAP personnel, Districts and many other people and businesses in Texas and across the United States. RESEARCH AND PLANNING - District staff is continually researching the most advanced technology on the market, determining if .it fits the needs of the District and planning for its implementation. This also includes the participation in the development of a NG9-1-1 (Next Generation 9-1-1) system for the District and the State of Texas. NG9-1-1 will be a network which will include database services that will be able to handle Enhanced 9-1-1 services for all devices that can currently connect to the 9-1-1 network, no matter how they connect, and future devices. These are the major items that LECD provides to the participating agencies and the citizens of Lubbock County and the City of Plainview. Proposed Budget 2005-2006 Page 5 This page intentionally left blank. Proposed Budget 2005-2006 Page 6 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET SIGNIFICANT ACTIVITIES FOR FY 2005-2006 In addition to the routine duties of the District, which involve day -today addressing and assuring the 9-1-1 network is functional and CPE is operating properly, etc.; LECD plans to continue working on and, in most cases, achieve the following significant activities in this fiscal year. PUBLIC EDUCATION LECD continues to make the Public Education Program more effective and versatile. In FY 2005-2006 we plan to continue to build the LECD Road Show Team that consists of members of the Public Safety Dispatching Community. Different methods of getting our message out will be researched and implemented where practical. TELECOMMUNICATOR TRAINING LECD will continue to provide local training for telecommunicators. Classes will be held on an as needed basis to educate telecommunicators and supervisors on the use of Vesta equipment and "Basic 9-1 A." Yearly, LECD will host a seminar on a topic that is pertinent to the education of the telecommunicator and suggested by their supervisors. These are presented by well-known training consultants and are attended by public safety personnel throughout West Texas. LECD also provides a funding source so that local training for telecommunicators can be provided. This will help ease the financial burden on the PSAPs that LECD supports. USER GROUP MEETINGS During the next fiscal year LECD will continue to host User Group Meetings on a monthly basis. Participation has been very good at these meetings, and we hope to see this continue. The User Group provides beneficial input and serves as a means of disseminating information, all of which helps LECD accomplish its mission. WIRELESS Completion of Wireless Phase I occurred in March of 2001. We continue to work with the PSAPs in the installation and configuration of integrated mapping solutions, whether through their CAD (Computer Aided Dispatch) Systems or through stand-alone applications. Wireless Phase II Enhanced 9-1-1 Service Orders were placed with all of the major Wireless Service Providers in the District. The six (6) major Wireless Service Providers do provide Wireless Phase II Service to the District. LECD will be starting the Wireless Phase II ordering process with the smaller Tier 3 Wireless Service Providers this fiscal year. Proposed Budget 2005-2006 Page 7 CENTERLINE MAP This project was completed for Lubbock County, including all of the smaller municipalities and the City of Plainview during fiscal year 2002-2003. Last fiscal year LECD published a Public Safety Map Book. This one of a kind document provides the dispatcher and the field responder with a comprehensive and easy to use reference for finding addresses in Lubbock County. This fiscal year LECD will continue to make updates to our centerline map and provide those changes to the PSAPs that use integrated mapping. . EQUIPMENT/SOFTWARE UPGRADE Upgrades in the software used by the PSAPs will continue this fiscal year. These upgrades include service packs and incremental version upgrades. Replacement of the printers used in the PSAPs will also be done this year. Currently some of the printers have been in service for five years, others have been replaced because of failure. Not all the printers are the same brand or model. This causes some confusion with the technicians, as each site is unique instead of being standardized. EMERGING TECHNOLOGY This is an area that LECD will be focusing on this fiscal year. With the advent of Voice Over The Internet, it is imperative that LECD be on the leading edge of the development of a new 9-1-1 network that can receive and locate 9-1-1 calls from current and future devices. Proposed Budget 2005-2006 Page 8 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET BUDGET NARRATIVE DISTRICT OPERATIONS This section of the budget describes the District Operation expenses of the budget. It pertains more to the day -today operations than to specific programs and projects. Employee Salaries And Benefits Salaries — Full Time $315,000 This is for salaries for the full time District employees. This figure includes applicable merit raises for all the full time employees. In the budget narrative, a percentage of salaries have been allocated to the primary job function of each employee. The unallocated percentage falls into general operations. Salaries — Part Time $18,700 This is for the salary of the part time Pistrict employee. Retirement Expense $28,500 This is the amount paid to the Texas County and District Retirement System by the District as the employer. The contribution rate is 7.56% for the calendar year 2005. This amount includes an increase in the District's contribution rate to allow for an increase in the employee contribution rate to 7%. The employee currently contributes 6% to this fund. Insurance Benefits $52,300 This is for medical, vision, dental, disability and life insurance for the full time District employees. Employees pay for spouses and family members that are -on the plan. This increase is based on a projected 15% increase in premiums. Workers' Compensation $1,300 This is the District's contribution for State Workers' Compensation insurance coverage. This covers the employee should they be injured on the job. The increase is due to a claim during 2004/2005. Proposed Budget 2005-2006 Page 9 TEC - Unemployment $1,600 This is the District's contribution to the Texas State Unemployment Fund. It is based on a percentage of the first $9,000 per employee. The rate for the current calendar year is .3%. The rate for the previous year was 2.3%. Since the rate information is not received until the end of the year, and the rate fluctuates from year to year, we are using a higher rate of 2.3% to calculate the amount for the 2006 calendar year. FICA - Benefit $26,500 This is the District's contribution to Social Security. OASDI (Old -age, Survivors, and Disability Insurance) — 6.2%. Medicare—1.45%. Payroll Service $1,000 Pays for the cost of our payroll service. They take responsibility for all payments and reports to state and federal agencies. Pre -Employment Expense $3,000 This covers the fees for pre -employment drug testing and interviewing expenses. Other Benefits $5,000 This pays for other employee benefits such as moving expenses and wellness benefit assistance. Supplies Office & Operating Supplies $2,500 This is used to cover the purchase of paper, pens, stationary, envelopes and other supplies essential for conducting business. Other Supplies $4,000 This is used to purchase supplies such as paper goods, facility and cleaning supplies, and refreshments for meetings. It also includes Board meeting/member supplies and funds for benevolent causes. Educational Supplies $1,100 This covers the cost of subscriptions and technical publications. Includes educational/training material. Proposed Budget 2005-2006 Page 10 Postage $1,200 This is for mailing that the District does. This is divided among several projects including address notifications, distribution of the LECD Quarterly newsletter and invitations to events. This amount has decreased because staff is using the internet for most routine correspondence. Mapping Supplies $1,000 Supplies necessary for production of reference maps for requesting agencies and PSAPs. Printing $2,500 This pays for printing letterhead, envelopes, LECD Quarterly newsletter, business cards, addressing brochures, etc. Maintenance Office Equipment Maintenance $1,500 This covers the cost of repair to any of the office equipment other than computers. This might include video equipment, fax machine, typewriter, printers, telephone equipment, etc. Computer Equipment Maintenance $11,700 A detailed explanation of this item is included in the Information Systems narrative. Facility Maintenance $4,000 This covers cost of maintenance of the District offices not covered under the lease agreement. This will cover painting of the main traffic areas of the LECD office. Small Tools & Equipment $700 This is used for the replacement or purchase of small equipment with a value of less than $500, such as calculators, excluding computers and monitors. It also includes tools required for maintenance of IS equipment. Rent/Lease Machinery $3,000 This covers the cost of leases on equipment such as the copy machine and postage meter and scale. It also includes rental of equipment for meetings and receptions. Proposed Budget 2005-2006 Page 11 Other Services/Expenses Rent/Lease Facilities $46,500 This covers the annual office lease and costs incurred should alternate space need to be rented for meetings, training classes, etc. This also includes cost of storage space. Lobbyist Services $3,600 This pays the District's share of a lobbyist retained by the Texas 9-1-1 Alliance to which LECD belongs. The lobbyist works on behalf of the Communication Districts and is our spokesperson at the Capitol. He also prepares and submits updates to the Districts. Legal Services $18,.400 Pays for our local attorney and for the attorney retained by the Texas 9-1-1 Alliance to watch over legal and regulatory issues that may affect all Districts. Updates from the Regulatory Attorney are included. Accounting Services $5,000 This pays for the annual District audit and other accounting services, including consultation if necessary. Public Education $34,050 A detailed explanation of this item is included in the Public Education narrative. Professional Services $3,000 This section is for technical consultants and outside services that the District might use in various projects. This includes LECD's share of any consultants that may be hired by the Texas 9-1-1 Alliance. Telephone $11,500 This pays for the District's local telephone and long distance service, wireless phones, Internet service, web hosting service, and the alpha/numeric pagers that are carried by staff. The pagers are on a contract through the State of Texas at a reduced rate. Proposed Budget 2005-2006 Page 12 Professional Dues and Memberships $2,600 This covers the annual dues of organizations like APCO (Association of Public Safety Communication Officials), NENA (National Emergency Number Association), State Purchasing Organization, Lubbock Chamber of Commerce, Human Resource Society, and other civic organizations, etc. Travel $17,700 This is for the travel expenses of staff and Board Members to attend meetings, training, seminars, etc. Staff may attend both state and national NENA/APCO conferences, District Director meetings, PEI User Group meetings, Public Education Group meetings, Technical Development Conference, Critical Issues Forum, etc. It includes the cost of flights, hotel accommodations, meals, rental cars, cab/shuttle, parking, etc. Training $8,300 This covers the cost of tuition/registration for training classes, seminars and conferences for the LECD staff and Board members. Insurance $9,000 This covers insurance on all District=owned or leased equipment, liability insurance and errors and omission coverage on staff and Board Members. Vehicle Expense $12,200 This covers the vehicle expense of eligible full time staff. Staff is expected to be able to travel to PSAPs and offsite locations for meetings, maintenance, etc. This also covers the mileage (IRS rate) paid to non-exempt full time and part time employees for travel on District business. Capital Office Furniture $1,000 This covers the cost of replacing furniture. Communication Equipment $1,000 This pays for changes or additions to the office telephone key system. Proposed Budget 2005-2006 Page 13 Computer Equipment — Replacement $7,700 A detailed explanation of this item is included in the Information Systems narrative. This covers the replacement of legacy equipment. Equipment Replacement Fund $11,936 We have developed a schedule of equipment that needs to be replaced. This schedule gives an estimated life expectancy for each piece of equipment and provides adequate money to replace the piece of equipment at the end of its life span. This is for equipment used by the District and not equipment located in the PSAP. Expenditures from this account will occur to replace existing equipment. Proposed Budget 2006-2006 Page 14 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET DATABASE Addressing Rural Route Conversions This section describes the costs attributed to the ongoing rural postal route conversion notification project for the residents of Lubbock County. It is estimated that the project will be 95% complete at the beginning of FY 2005/06, and we hope to be 100% complete by the end of FY 2005/06. This will encompass address changes to the last major route and smaller sub -routes. Salaries: 15% of Gross Income of Database Manager 30% of Gross Income of Database Technician These are the costs associated with the research, assignment, mail out production and database maintenance of all converted rural addresses. The costs are broken between hours dedicated by Database Manager and Database Technician. Printing Supplies: $100 These charges are associated with the assorted supplies required to produce notification letters to do mass mail -out to all converted rural route residents. Primarily it will be the cost of paper to produce two letters per resident. The US Postal Service provides all envelopes and postage. A printed brochure obtained from the CSEC regarding posting of addresses will be inserted into notification letters. Postage for Notification of Third Parties: $50 These are the postage costs to keep all affected parties apprised of the status of conversions and the updated address data. These third parties include the City of Lubbock, the Lubbock Central Appraisal District, any utility companies requesting the information, especially telephone companies. Also, we receive requests for address data from developers, builders and different mortgage lenders. Total For Rural Route Conversions: $150 Proposed Budget 2005-2006 Page 15 Customer Service/Notification This section represents time spent helping customers obtain addresses and the follow up involved in distributing assigned addresses to all the necessary parties. Over the past year we have found that a significant portion of our time is being devoted to this process. Salaries: 25% of Gross Income of Database Manager 20% of Gross Income of Database Technician Correction of Incorrect ALI Information Part of the job duties of the Database Technician calls for the correction of incorrect ALI records as reported by PSAP personnel. This reflects the amount of time spent researching the correct information and the subsequent updates to all affected databases. Salaries: 40% of Gross Income of Database Technician Proposed Budget 2005-2006 Page 16 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET DATABASE Street Signs The following describes the associated costs to place street name markers at most intersections in the unincorporated portions of Lubbock County. Salaries: 5% of Gross income of Database Manager 10% of Gross Income of Database Technician These are salary costs associated with this project. They are broken down between hours dedicated by Database Manager and Database Technician. Cost of Manufacture of Signs: $7,500 These figures are based upon "per sign" costs obtained from the District's sign vendor, Lubbock Grader Blade. Replacement of missing and vandalized signs will account for the biggest portion of this year's sign budget. Figures are based upon the average size of orders placed last year. Total For Street Signs: $7.500 Proposed Budget 2005-2006 Page 17 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET DATABASE Training Training: $1,500 Training for Database and GIS staff to bring more proficiency in actual use of various applications. Some training will probably be on-line. These costs cover both tuition and materials. Conferences/Seminars: These funds are earmarked for any conference fees deemed useful during the year for Addressing or GIS needs. Travel: $1,000 These will be travel costs associated with the above training, conferences and seminars. Travel expenses will include airline flight fares, hotel accommodations and meals. Total For Database Training: $2.900 Proposed Budget 2005-2006 Page 18 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET DATABASE MSAG Maintenance All costs associated with this ongoing program in the Database department are under the category of salaries. MSAG Maintenance/Cleanup: 20% of Gross Income of Database Manager Complete the process of MSAG comparisons with different telephone companies to get all discrepancies resolved. Mostly encompasses time spent maintaining MSAG database with all new development. We have begun a system -wide MSAG change to bring all database records into compliance with NENA addressing standards. We have completed a comparison or MSAG data to Centerline file and will continue processing necessary changes to keep the two files concurrent. Proposed Budget 2005-2006 Page 19 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET DATABASE GIS Data Exchange and Update: 50% of Gross Income of GIS Coordinator Completion of Base map and Centerline file development resulted in a shift from digitizing to data maintenance. Digitizing may continue to be done in an update capacity, as new layers of data are requested, providing that the data be provided to LECD in a format that is easily drawn, scanned or otherwise entered into the GIS.. LCAD has taken over the responsibilities for the parcel mapping, so data exchange and integration replace data digitizing. Lubbock County has recently added GIS personnel, increasing the number of agencies with which we exchange data. We serve a common area with Lubbock County, so the interaction cooperation and data sharing will be significantly increased in their first year of operation. The establishment of Integrated Mapping at Slaton Police Department (SPD) and Plainview Police Department (PPD) requires the review, update, and conversion of our GIS. Data is physically taken to each PSAP and the updates are performed onsite for each workstation with integrated mapping. The development and maintenance of Integrated Mapping at each PSAP requires the GIS Coordinator to interact with the dispatchers and administrators in order to identify, evaluate, and eliminate any shortcomings or problems with the dataset. The addition of integrated mapping at the Lubbock Police Department (LPD) and Lubbock Sheriffs Office (LSO) further increases the frequency and amount of data being provided to the PSAPs. Data Validation, Cleanup and Addressing: 25% of Gross Income of GIS Coordinator 15% of Gross Income of Database Manager Resolving discrepancies between our addressing database and map data is ongoing, but represents a much smaller task as the data has been reviewed and updated. Missing records, invalid data links, duplication, and missing objects on the map, remain as problems, but the majority have been corrected by the GIS Coordinator, Database Manager, and Database Technician. Validation, verification, and cleanup of data that is being used for integrated mapping in the PSAPs are in addition to this process. Problems between the Telco database, LECD, and City of Lubbock map data may become evident once integrated mapping is available to the remaining PSAPs. This will represent a shift in focus to discovering and correcting discrepancies between LECD data and data from outside agencies. Initially, this may prove to be a significant undertaking, but the severity will be dependent on how smoothly integrated mapping is added to LPD and LSO. While limited, we may play a crucial role in troubleshooting Proposed Budget 2005-2006 Page 20 problems and streamlining their resolution. Overall, the amount of data validation and cleanup will be less than previous years and should continue to decrease. Producing Maps for the Third Parties: 5% of Gross Income of GIS Coordinator Mapping Supplies: $500 We provide maps for all our responding agency personnel, and we also, for the cost of production, provide maps to outside parties who request them. While this map production did not significantly impact workflow in the past, we are finding that as the accuracy of our information becomes public knowledge, the requests for it are multiplying and are becoming more of a demand on our time. Effort will be focused on updating and distributing the Public Safety map books, which have been in high demand, but much easier to provide to the Emergency Responders than customized maps. Efforts are underway to provide our map data, in a less specialized version, to a private map book producer for the purpose of creating a commercial map book of Lubbock County that will be available to the public. We have also provided access to a data set similar to the Public Safety Map Book on the LECD website. Misc. Peripheral GIS Duties: 10% of Gross Income 'of GIS Coordinator Much time is spent by GIS Coordinator attending to things that are pertinent to the GIS, yet not a part of any project. Such things as research and troubleshooting of data migration and integration issues require a large amount of time. Hardware and software compatibility issues and new GIS technologies are other areas where much research is required. Documentation: 10% of Gross Income of GIS Coordinator Data organization, workflow development and documentation are becoming increasingly important as the number of GIS related projects increases. Keeping track of the various data sets that we manage is becoming a more complex task as the data grows and the ways in which we use the data increase. The documentation of workflow and procedure are also crucial to our GIS and require an increasing amount of time. Total for GIS: $500 Proposed Budget 2005-2006 Page 21 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET LECD QUARTERLY NEWSLETTER Salaries: 20% of Gross Income of Database Manager Salary costs are based on hours attributed to research, production, printing, folding, printing mailing labels and postage attachment for the LECD Quarterly newsletters. Printing Costs: $1,500 These printing costs are based on printing costs of the newsletters produced last year. The printing costs are attributed to the printing and folding of the newsletters by the City's Print Shop. Funds are budgeted to allow occasional color printing in some issues. Postage Costs: $370 The postage costs also are based on the postage costs of last year's mailed newsletters. The newsletters are posted on office postal equipment and mailed from the LECD offices. Total LECD Quarterly Newsletter: $1,870 Proposed Budget 2005-2006 Page 22 Lubbock Emergency Communication District FY 2005-2006 BUDGET INFORMATION SYSTEMS Salaries 100% of Gross Income of IS Technician This section addresses the staffing costs of the Information Systems program. This is the percentage of the annual salary of the Information Systems Technician attributed to his support role of District staff. Small Tools/Equipment/Supplies $700 Replacement or purchase of tools necessary to maintain IS equipment or to enhance/improve operations as they relate to IS (testing equipment or tools for repair) as well as disposables such as backup tapes & CDR/RW media. Replacement Equipment $7,700 This amount covers the replacement of an old -technology server, workstation, laptop, & scanner. These purchases will be made out of the replacement account. Office Equipment Maintenance $1,500 This amount covers the cost of maintenance contracts on the District printers and other office equipment other than computers. Computer Equipment Maintenance $11,700 The following describes both hardware and software related maintenance items. Software Contracts: $5,700 Software Contracts ensure the District has the latest version of the programs in use for day -today operations. Repair Parts: $1,900 Hardware - Parts necessary to restore operation of, or upgrades to, District computers and other IS equipment. Examples are items such as memory, hard drives, CD-ROM drives, mice, keyboards, etc. Software Upgrades: $1,500 Software necessary to restore, upgrade, or add functionality required by District users. This includes incremental upgrades to a speck software program not covered by a maintenance contract. Computer/Network Consulting: $2,600 Proposed Budget 2005-2006 Page 23 Support services for existing software and hardware and/or the integration of proposed, budgeted equipment. Also includes the repair of IS equipment. This includes items such as telephone support for various software programs, systems design consulting and implementation services. Publications: $400 Trade journals, magazines, reference manuals, and resource kits related to IS and Information Technologies. Training $1,200 This section describes the various training opportunities that IS technician will use to stay abreast of current trends and industry issues, as well as professional skills development. Online: $600 Training available over the Internet covering both professional and personal courses at MindLeaders.com & other providers. Classroom Based: $600 Tuition to attend training available in Lubbock or on -site. Proposed Budget 2005-2006 Page 24 LUBBOCK EMERd NCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET PUBLIC EDUCATION PROGRAM Salary 33% of Gross Income of Office Coordinator Recognition and Appreciation Events $2,500 Tokens of appreciation/recognition and activities related to National Telecommunicators' Week, 9-1-1 Day, and Kid Hero awards Advertising $15,500 Production of public service announcements and publication through print, television, radio, and billboards. Production and publication of brochures and flyers. Total also includes corporate advertising, which includes items such as coffee mugs, t-shirts, and other items bearing the LECD logo, including the clothing and accessories worn by LECD staff. Supplies and Materials $10,000 Book covers handed out to local schools. Cost of items distributed during public education events that are scheduled throughout the year. This total includes the cost of materials distributed through the Safety City program. Presentation Supplies $500 Repair and maintenance of presentation display and accessories, including the Red E. Fox costume. Road Show Team $4,700 Compensation and purchase of shirts for team members participating in events. Travel $700 Travel for quarterly Public Educators meetings and the Kid Hero award event. Training $150 Fees for conferences and meetings involving Public Education that may be attended by various staff members. Proposed Budget 2005-2006 Page 25 This page intentionally left blank. Proposed Budget 2005-2006 Page 26 FY PSAP SUPPORT This section of the budget covers expenditures to support the PSAPs within the District. Recurring Costs Wireline Network Charges 9-1-1 Database Charges Wireless Network Costs Language Line Services WAN Recurring Costs Maintenance Customer Premise Equipment — Servers/Workstations Logging Recorders UPS Equipment Headsets Mission Control Other Maintenance/Repair WAN Maintenance Upgrades Printer Replacement Other Upgrades Telecommunicator Training Salary Tuition Seminars Travel Expenses Education Materials Catastrophic Contingency Street Signs Intergovernmental Aerial Mapping Equipment Replacement Fund — PSAP Proiects Wireless Implementation Emerging Technologies PSAP Grant Funding CLEC Audit Proposed Budget 2005-2006 Page 27 This page intentionally left blank. Proposed Budget 2005-2006 Page 28 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET PSAP Support Recurring Costs This section describes the charges from both wire -line and wireless telephone companies for the provision of the network, database services and ancillary services necessary for the Enhanced 9-1-1 system. Wireline Network Charges: $30,000 These are the costs associated with providing the wireline service and 9-1-1 trunking in the Lubbock Emergency Communication District. These charges are paid to SBC, Valor, South Plains Telephone Cooperative and other CLECs (Competitive Local Exchange Carriers). The 9-1-1 network includes the 9-1-1 trunks from the various central offices to the selective router. Included in this amount is the cost to maintain a special 9-1-1 trunk group and three telephone lines to the training center. This also includes the telephone lines installed at the PSAPs for remote maintenance. 9-1-1 Database Charges: $227,000 These charges are associated with the database records that are maintained by the telephone companies to provide accurate records for the ALI (Automatic Location Identification) system. The charge for this service is about $0.108 per record. We pay this fee to SBC based on the number of ALI records that exist in the ALISA database. Currently there are approximately 175K subscriber records for LECD in the SBC ALISA database. Wireless Network Costs: $159,500 These are the costs to maintain Wireless E9-1-1 Phase I and Phase II service in the District. Some wireless service providers continue to charge for Wireless Phase I & II services. Language Line Services: $1,000 These are the costs involved with the provision of Language Line Services to all the PSAPs in the District. Language Line is an interpreter service that is used by the telecommunicators to converse with non-English speaking callers to 9-1-1. This service is used about 10 times per month and cost is based on the number of minutes used. WAN Recurring Costs: $31,000 This is the annual cost to keep the WAN (Wide Area Network) operational. This pricing is based on governmental tariff pricing on a three-year contract. Proposed Budget 2005-2006 Page 29 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET PSAP SUPPORT Maintenance The following describes the items included in maintenance expenses. A breakdown of the CPE maintenance expenses per answering position is $2,788. To calculate a per PSAP amount you would multiply this figure by the number of answering positions at each agency. Customer Premise Equipment — Servers/Workstations: $102,000 This pays for the yearly 24x7 maintenance on the telephone customer premise equipment and the servers/workstations used by the telecommunicators. This is a year-to-year contract. LECD has the ability to negotiate this contract every year or to change service providers. It also includes installation of service packs and hot fixes, but does not include time/materials to install software upgrades. Loggin i Recorders: $15,000 This pays the annual maintenance.on the logging recorders. This is also a year-to- year contract. UPS Equipment: $5,000 This section pays for the annual maintenance contract on the UPS (Uninterruptible Power Supply) located in each PSAP. These units were all purchased/replaced in FY 1999-2000. Headsets: $1,000 As part of the new CPE installation in FY 1999-2000, LECD provided headsets to all of the telecommunicators in the District. This fund is for repair/replacement of headsets during the year. Mission Control: $165,000 This is for the renewal of our existing contract. This is for a four-year period. Mission Control provides 24 hour monitoring of the PSAP CPE by Plant Equipment, Inc. in Temecula, CA. Any system alarms are automatically sent to Plant Equipment, and a technician accesses the system via a dial -up modem or through our Wide Area Network to find and correct the alarm cause. Plant indicates that 97% of the problems that they have found with Mission Control monitoring are corrected without a technician having to be on -site. The Mission Control service is also helpful in installing software patches and hot fixes. We have found the system beneficial during the last four years. Proposed Budget 2005-2006 Page 30 Other Maintenance/Repair: $12,000 This is used to pay for maintenance/repairs that are not covered by a maintenance contract. This includes an electrician checking a UPS prior to the dispatch of a UPS repair technician to move, add or delete lines from the 9-1-1 telephone equipment. It also provides funds for the purchase of new backup tapes for each PSAP. WAN Maintenance: $2,500 This is for maintenance of the WAN (Wide Area Network). This is based on a per hour service agreement and not on a contract. Proposed Budget 2005-2006 Page 31 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET PSAP SUPPORT Upgrades Printer Replacement: $3,500 Over the past five years there have been changes in the printers at the PSAPs. These printers are used by the PSAP to print reports from the MagIC information system and to print ALI screens for other reports. When a printer fails, it is replaced with a new one because the cost to repair a printer is more than it costs to purchase a new one. Consequently, we have a mix of printer brands and models. Some of the printers are the original ones installed five years ago, and some have been replaced within the last six months. This causes confusion with the technicians. They cannot cant' a common set of software valid for all the printers since most of them are different. In this fiscal year all of the printers will be replaced and sufficient spares purchased so that, if a printer is replaced, it will be replaced by the same brand and model as the original. Other Upgrades: $20,000 This covers software upgrades of programs at the District office that are used to DIRECTLY support the PSAPs, such as MapManager. It also covers other upgrade costs at the PSAPs that are not covered by a maintenance agreement. Proposed Budget 2005-2006 Page 32 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET PSAP SUPPORT Telecommunicator Training This section details the planned expenditures for the direct training of telecommunicators. Each PSAP has requirements for certification. These items will assist with the expense involved in meeting these requirements. In some cases, the funds are designated in proportion to the number of workstations at each PSAP. Salary: 5% of Gross Income of Operations Manager This would be a percentage of staff salary according to estimated time that is spent training telecommunicators and coordinating events. Tuition: $2,700 This amount will be used at each PSAP to help with tuition for the telecommunicator to attend required classes. This also includes registration costs for award winners and their supervisors to attend recognition events. Seminars: $4,000 Joining efforts and hosting instructors to come to Lubbock to present training to all PSAPs can realize cost savings. Whenever possible, LECD will coordinate with SPAG to provide a variety of subjects. These seminars are available for public safety personnel throughout West Texas to attend. Travel Expenses: $6,000 This will cover travel expenses to conferences and classes. This also includes cost for award winners along with their spouses and supervisors to attend recognition events. Education Materials: $2,300 This money would be used to purchase training materials used by LECD staff to train the telecommunicators on the use of the call answering equipment. This money would also be used to help the PSAPs build their own education libraries. It would include purchase of videos, instructional materials, reference materials and other meeting supplies. Proposed Budget 2005-2006 Page 33 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET PSAP SUPPORT Catastrophic Contingency: $100,000 In the event of a catastrophic loss, the insurance companies do not pay immediately so some funds need to be available for use in these circumstances. Street Signs: $7,500 This is for manufacture and maintenance of street signs in rural areas of Lubbock County. (See database narrative for details) Intergovernmental Aerial Mapping: $5,000 This is LECD's share to participate in an aerial photograph/mapping program with the City of Lubbock and Lubbock County. LECD would have access to the data (aerial photographs) that will be used to update our current centerline map, which is used in the PSAPs. The data will also be used to update the public safety map book. LECD has participated in a similar program in the past. Equipment Replacement Fund — PSAP: $430,000 This is a revolving fund. These funds cant' over from one year to the next and increase by the same amount each year. To arrive at this figure we took the cost of the CPE, software, logging recorders, netclocks and installation and added to this amount 20% to cover increases in products and services. Currently, we have about $1.1 million in the replacement account. With the changes in technology that we need to prepare for, the annual addition to this fund will put LECD in a position to make the necessary equipment changes without forcing an increase in the service fee. Currently, we project that all of the PSAP equipment (backroom, servers, workstations, monitors) will need to be replaced in three years or FY 2008-2009. This could be sooner if a major change in 9-1-1 network technology is made available. Proposed Budget 2005-2006 Page 34 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET PSAP SUPPORT Projects Wireless Implementation: $100,000 The major wireless carriers are providing Phase II service, and contracts have been established with them. Funds will be needed this fiscal year to pay the smaller carriers that may start the Phase II implementation process. Emerging Technologies: $300,000 Emerging Technologies are the future of 9-1-1. Currently there are more than ten different types of devices that can conceivably dial or call 9-1-1. The present 9-1-1 network does not have the capability to provide the life saving location information from all of these various devices. The above funding will allow LECD to fully investigate networks and technologies that will allow our PSAPs to locate these devices and future devices that could call 9-1-1. PSAP Grant Fundina: $75,000 Starting in this fiscal year (FY 2005-2006) LECD has changed from an entitlement - funding program to a grant -funding program. Grants are approved in June of the current fiscal year to be included in the budget of the forthcoming fiscal year. The grant program was approved in February of 2005, and the supported PSAPs were notified by letter of the program shortly thereafter. Three PSAPs have requested grant funding. They are: Lubbock Police Department, $44,505 to replace console furniture in the dispatch center; Lubbock County Sheriffs Department, $16,200 to install LCD monitors for the CAD System and purchase a ruggedized laptop computer for the Mobile Command Post; Texas Tech Police Department, $13,755 to install Orion MapStar, integrated mapping. All of these requests meet the criteria set forth in the PSAP grant -funding program. CLEC Audit: $17,000 LECD has been in contact with OnPoint Telecommunications Consultants regarding conducting an audit of CLECs (Competitive Local Exchange Carriers) doing business in the District. OnPoint, acting as our agent, would contact the CLEC and request information regarding how much service fee they are collecting, the number of customers, the type of service, etc. They would also request copies of customer invoices to document that the CLEC is in fact billing the customer Proposed Budget 2005-2006 Page 35 properly. OnPoint also tracks down all the CLECs that are doing business in the District. They have done work for three other Districts in Texas with outstanding results. LECD does not have the time or resources to complete this type of audit. This project would identify who is selling/providing dial tone in the District, if they are charging the service fee properly and if they are remitting it properly. It establishes a baseline that we can work forward from. Proposed Budget 2005-2006 Page 36 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET CHARTS FY 2005-2006 Revenue Forecast Financial Charts 9-1-1 Calls Proposed Budget 2005-2006 Page 37 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET 2005-2006 REVENUE FORECAST SBC-LUBBOCK SBC - PLAINVIEW VALOR SOUTH PLAINS TELEPHONE COOP WIRELESS - LUBBOCK WIRELESS - PLAINVIEW PRIVATE SWITCH -TEXAS TECH COMP. LOCAL EXCHANGE CARRIERS INTEREST INCOME - LUBBOCK INTEREST INCOME - PLAINVIEW SPAG-LUBSOCK SPAG - PLAINVIEW MISCELLANEOUS TOTAL REVENUE % CHANGE FROM PREVIOUS YEAR TOTAL SERVICE FEE REVENUE % CHANGE FROM PREVIOUS YEAR 2000-2001 2001-2002 2002-2003 2003-2004 Projected 2004-2005 Projected 2005-2006 830,422 691,678 599,607 554,608 523,062 467,000 63,921 54,652 48,946 46,458 44,312 40,000 48,066 43,493 34,931 43,338 36,500 30,700 27,468 22,958 21,871 21,566 21,000 20,500 490,018 627,065 666,934 737,978 792,000 800,000 46,192 57,226 60,096 65,422 69,600 70,000 35,558 38,809 36,051 33,047 18,400 18,400 449,668 450,378 410,095 389,869 382,000 374,000 173,337 84,477 60,169 58,743. 100,000 100,000 3,528 2,205 1,256 1,651 3,000 3,000 8,9 5 8,143 7,599 7,474 7,400 7,400 1,364 1,364 2,297 2,350 2,300 2,300 214 207 1,000 0 2,178,477 2,082,662 1,949,851 1,962,711 2,000,574 1,933,300 4.19% -4.40% -6.38% 0.66% 1.93% -3.36% - 2,001,612 1,995,766 1,888,426 1,902,110 1,896,574 1,830,300 7.66% -0.29% -5.38% 0.72% -0.29% -3.49% Proposed Budget 2005-2006 Page 38 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET Revenue Comparison REVENUE BY CATEGORY 1,200,000 1,000,000 800,000 600,000 400,000 — g 200,000 0 ILEC CLEC Wireless Interest ■ 99-00 O 00-01 0 01-02 ■ 02-03 ■ 03-04 ■ 04-05 Proj. EIS 05-06 Proj. 2,300,000.00 2,200,000.00 2,100,000.00 2, 000, 000.00 1,900,000.00 1,800,000.00 1,700,000.00 1,600,000.00 CHART 1 TOTAL REVENUE 99-00 00-01 01-02 02-03 03-04 04-05 05-06 C HART 2 Total Revenue Service Fee Proposed Budget 2005-2006 Page 39 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET Revenue vs. Expenses $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 99-00 00-01 01-02 02-03 03-04 Expenses —*—Revenue This chart shows a comparison for the last five years between revenue and expenses. If this trend continues, the District should consider reducing the service fee. CHART 3 Proposed Budget 2005-2006 Page 40 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET District/PSAP Breakdown ■ District 27% ■ PSAP 73% This chart shows 73% of the District's FY 2005-2006 BUDGET goes toward the direct support of the Public Safety Answering Points (PSAPs). CHART 4 Proposed Budget 2005-2006 Page 41 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET PSAP Support Equipment Replacement Signs 23% 1% Catastrophic Projects 5% 27% Mapping 1% Maintenance 18% n, Training Recurring 1 % 24% This chart shows how the 73% breaks down for the PSAP Support. The mission of LECD is to provide "end to end" support for the 9-1-1 call. To do this effectively the District expends the bulk of its resources on this task. CHART 5 Proposed Budget 2005-2006 Page 42 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET District Operations Capital Equipment 1 % Replacement an 2% Other Servi 25% Maintenanc 3% Sur rsonnel 67% As shown in this chart, personnel services make up the bulk of the District portion of the budget. CHART 6 Proposed Budget 2005-2006 Page 43 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET Calls by PSAP May 04 Jun 04 Jul 04 Aug 04 Sept 04 Oct 04 Nov 04 Dec 04 Jan 05 Feb 05 Mar 05 Apr 05 Total Lubbock Police Wireline 6026 6322 11673 11127 10346 10199 9931 10248 10362 9000 9948 5098 110,280 Wireless 6085 5421 5982 5745 5641 5898 5267 5744 5654 5126 6160 6121 68,844 Lubbock So Wireline 1 1078 1256 1213 1163 1149 880 628 623 571 537 652 579 10,329 Wireless 1 856 741 939 863 771 751 636 748 800 646 837 778 9,366 Plainview Police Wireline 665 563 625 596 562 592 596 475 538 458 568 516 6,754 Wireless 436 1 605 639 1 612 575 552 552 663 483 583 638 628 6 966 Slaton Police Wireline 1 314 398 344 332 311 254 168 193 184 216 146 120 2,980 Wireless 1 66 66 78 69 63 72 69 76 81 66 139 92 937 Texas Tech PD Wireline 101 64 104 1 82 90 1 107 113 105 1 90 76 1 70 60 1,062 Wireless' 11 4 5 1 9 10 18 8 10 4 8 4 10 101 Total Primary 131,405 86 113 Lubbock EMS Wireline 1261 1256 1300 1 1239 1269 1 1240 1051 1 1208 1 1180 1330 1250 1114 1 17,158 Wireless' 288 248 261 1 279 291 1 353 271 306 1 328 284 350 313 2,803 Lubbock Fire Wireline 16 7 154 174 150 111 128 185 132 110 84 1 126 148 1615 Wireless' 93 84 181 82 85 98 127 118 107 51 106 163 1005 Slaton Fire Wireline 7 9 2 1 5 16 2 5 33 17 6 5 3 1 71 Wireless' 0 4 3 0 2 0 2 9 3 3 6 4 26 Total Secondary_ 16,477 4.903 * Wireless Call received by Lubbock PD, Lubbock SO or Slaton Police and transferred to this PSAP. This chart represents the 9-1-1 calls handled by the PSAPs supported by the District. These numbers are based on the SBC ASK reporting system. During this time period 39.6% of all 9-1-1 calls were from wireless phones. CHART 7 Proposed Budget 2005-2006 Page 44 140,000 120,000 100,000 80,000 60,000 40,000 20,000 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2005-2006 BUDGET 9-1-1 Calls for Service Wireline Wireless ■ Jun 00-May 01 0Jun 01 - May 02 El Jun 02 - May 03 ■ Jun 03 - May 04 ■ May 04 - Apr 05 This chart shows the number of 9-1-1 Calls For Service, both Wireline and Wireless, for the last five years, handled by the PSAPs (Public Safety Answering Points) in the Lubbock Emergency Communication District. CHART 8 Proposed Budget 2005-2006 Page 45