Loading...
HomeMy WebLinkAboutResolution - 2006-R0347 - Resolution Approving The FY 2006 Budget - Lubbock Emergency Communications Dist. - 07_10_2006Resolution No. 2006-RO347 July10, 2006 Item No. 5.9 RESOLUTION WHEREAS, pursuant to Section 772.309, Texas Health & Safety Code, the Lubbock Emergency Communications District is required to present its annual budget to the governing body of the most populous municipality in the District having a population of more than 140,000 for approval; and WHEREAS, the Board of Managers of LECD has approved a budget for fiscal year 2006/2007 for the District; and WHEREAS, the Board of Managers of LECD desire to obtain the approval of the City Council of the City of Lubbock for said proposed budget; NOW THEREFORE: BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF LUBBOCK: THAT the City Council of the City of Lubbock, Texas, hereby approves the fiscal year 2006/2007 budget for the Lubbock Emergency Communications District proposed by the LECD Board of Managers, a copy of which budget is attached hereto and made a part of this Resolution for all intents and purposes. Passed by the City Council this loth day of July , 2006. DAVID. MILLER, MAYOR ATTEST: Rebecca Garza, City Secretary � APPROVED AS TO CONTENT: Le n Dumbauld, City Manager APPROVED AWO FORM: City Attorney MS/LECDbudget06res July 3, 2006 esolut' N . 0 Jurylu, Zutio Item No. 5.9 Lubbock Emergency Communication District "...to provide the best possible, trouble free 9-1-1 network for the citizens we serve... " EMERGENCY HELP. ANYTIME, ANYWHERE, ANY DEVICE PROPOSED BUDGET Fiscal Year 2006-2007 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET Table Of Contents FY 2006-2007 BUDGET AgencyOverview.......................................................................................1 Significant Activities FY 2006-2007........................................................... 7 Budget Narrative District Operations........................................................................... 9 Database.......................................................................................15 LECDQuarterly.............................................................................21 Information Systems......................................................................22 Public Education Program.............................................................24 PSAPSupport ...............................................................................25 FY 2006-2007 Revenue Forecast............................................................36 Charts 1 & 2 — Revenue Comparison ............................................ 37 Chart 3 — Revenue vs. Expenses .................................................. 38 Financial Charts Chart 4 - Budget Breakdown......................................................... 39 Chart 5 - Budget Breakdown/PSAP Support.................................40 Chart 6 - Budget Breakdown/District Operations ........................... 41 9-1-1 Calls Chart7 - PSAP.............................................................................. 42 Proposed Budget 2006-2007 LUBBOCK EMERGENCY COMMUNICATJON DISTRICT PROPOSED 2006-2007 9U1)G9T ITEM TOTAL BUDGET 2005-2006 TOTAL BUDGET 2006.2007 DESCRIPTION REVoo - - Wireline $884,40 Wireless $1,011,000 Interest $211,500 TOTAL PROJECTED REVENUE $2,106,900 !! -- Equipment Reserves - $686,600 - Other Reserves _ $95 840 �- TOTAL ALLOCATED FUNDS $2,889,340 SALARY/EMPLOYEE EXPENSE _ Salaries - Full Time $333,200 Page 9,15-16,_18-22,24_,30 Salaries - Part Time _$316.000 $18,700 $17,200 Page 9,19-20 Retirement Expense $28,600 $32,000 Page 9 Insurance Benefit $52,300 _ $54,000 Page 9 Workers' Compensation $11300 $1,300 Page 9 TEC- Unemployment $1,600 _ $1,900 Page 10 FICA - Benefit $26,500 $27,700 Page 10 Payroll Service $1,000 $1,000 Page 10 Pre -Employment Expense $3,000 $3,000 Page 10 Other Benefits $5,000 $45,000 Page 10 TOTAL SALARY/EMPLOYEEEXPENSE $452,900 $516,300 SUPPUES Office/Operating Supplies $2,500 $2,500 Page 10,15,23 Other Supplies -- $4,000 $4,00_0 Page 10 Educational Supplies $1,100 _ ^! $850 _ Page 11,23 Postage $1,000 Page 11,15,21 _ Mapping Supplies _ _$1,200 $1,000 $600 Page 11,20 - Printing $2,600 $1,500 Page 11,21 _ TOTAL SUPPLIES $12,300 $10,460 MAINTENANCE Office Equipment Maintenance $1,500 $1,700 Page 11,22 Computer Equipment Maintenance $11,700 $14,350 Page 11,22-23 Facility Maintenance $4,000 _ $1,500 Page 11 Small Tools & Equipment $700 $800 Page 11,22 Rent/Lease Machinery $3,000 $2,300 Page 12 TOTAL MAINTENANCE $20,900 $20,450 OTHER SERVICES/EXPENSES RenULease Facilities $46,500 $43,200 Page_ 12 Lobbyist Services $3,600 $3,600 Page 12 Legal Services - $18,400 $18,400 Page 12 Accounting Services $5,000 $5,000 Page 12 _ Public Education $34,050 _ $34,000 Page 12,24 Professional Services $3,000 $3,000 _ Page 12,24 Communication Services _ $11,500 $14,400 Page 12 Professional Dues and Memberships $2,600 $2,900 _ Page 13 Travel $17,700 $19,900 Page 13,17 Training $8,300 -- - $8,100 Page 13,17,23 ---- Insurance $9,000 $8,000 Page 13 Vehicle Expense u $12,200 $12,000 Page 13 J TOTAL OTHER SERVICES/EXPENSES $171,850 $172,500 CAPITAL - ---- --------------- Office Furniture $1,000 $5,300 Page 13 Communication Equipment $1,000 $1.000 Page 14 TOTAL CAPITAL $2,000 $6,300 _ TOTAL DISTRICT OPERATIONS $667,650 $726,000 Computer Equipment- Replacement $7,700 $9,800 Page 14,22 Equipment Replacement Fund-LECD $11,936 $14,340 Page 14 2006-2007 Proposed Budget.xls LUBBOCK EMERGENCY COMMUNICA 16N DISTRICT PROPOSED 2006-2001 OU66�f ITEM PSDiF� EiCP 3 '� TOTAL BUDGET 2005-2006 TOTAL BUDGET 2008-2007 _ DESCRIPTION -- - - — Other PSAP Support Recurring Charges $448,600 $459,060 _ Pa_g_e 27_ Maintenance Charges $326,000 _ $934,600 Page 28-29 _ Telecommunicator Training/Travel $15,000 $15,000 Page 30 Catastrophic Contingency _ $100,000 $100,000 Page 31 u Emergency Response Support $7,500 $13,000 _ Page 16,20.31 Intergovernmental Aerial Mapping _ _ $5,000 PSAP Communication Services $1,600 Page 31 Equipment Replacement Fund-PSAP $430,000 Total Other PSAP Support $1,332,000 $1,523,200 Projects _ Wireless Implementation $100,000 _ $100,000 Page 32 Emerging Technologies $300,000 $300,000 Page 32 PSAP Grant Funding V $75,000 $47,000 Page 32 CLEC Audit $17,000 _ _ Training Center PSAP $120,000 Page 32-33 Microwave Path Feasibility Study $49,000 Page 33 TotalPmjecta $49Z,000 $616,000 TOTAL PSAP SUPPORT $1,824,000 $2,139,200 TOTAL $2,503,5861 $2,889,340 2006.2007 Proposed Budget.xis LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 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 AT&T, 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 in use in the PSAPs were replaced. In fiscal year 2004-2005 all of the workstations and servers in use were replaced with current technology equipment. Proposed Budget 2006-2007 Page 1 Software used in the PSAPs is constantly being upgraded to keep the most current programs in use by the Telecommunicators. Since fiscal year 2004-2005, all the major Wireless Service Providers in the District are providing Wireless E9-1-1 Phase II Service. The District has become more involved in the design and implementation of NG9-1-1 (Next Generation 9-1-1) in the State of Texas. More emphasis has been placed on legislative interaction regarding changes to the 9-1-1 system in Texas and in the nation. 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 2006-2007 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 carrying out the mission of the District. OPERATIONS MANAGER — Is in charge of the day-to-day 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. 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 the impact of future technologies on the computers used internally by the District. Occasionally interacts with PSAP personnel to resolve 9-1-1 related software problems. 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 —Is assigned to maintain a GPS accurate centerline map filelbook with address and block ranges, which will be used by various emergency response agencies. On request creates and prints custom maps. Is responsible to the Database Manager. Proposed Budget 2006-2007 Page 3 This page intentionally left blank Proposed Budget 2006-2007 Page 4 Resoonsibilities 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 service providers that provide dial tone, by wireline, wireless or VoIP within the District. CLECS/WIRELESS/VOIP - LECD is responsible for identifying and contracting with CLECs (Competitive Local Exchange Carriers), WSPs (Wireless Service Providers), and VSPs (Voice Over the Internet Service Providers) regarding provision of 9-1-1 service to their customers that reside within the District. TECHNOLOGY - LECD is responsible for identifying and working with Wireless Service Providers and Voice Over the Internet Providers in implementing and testing the latest technology to facilitate the location of callers from their respective service 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 Proposed Budget 2006-2007 Page 5 tips, equipment and software operation instruction, electronic equipment trouble reporting, and other reference information. 24-HOUR 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 and new communication technologies. TELECOMMUNICATOR TRAINING — This is a 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 funds so that telecommunicators can take advantage of numerous training opportunities. LECD also sponsors classes in the local area. STREET SIGNS — LECD pays for the manufacture of street signs in Lubbock County for replacement 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 require many hours of preparation. Meetings are also held monthly with AT&T 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 participation in the development of an 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 need to connect to the 9-1-1 network. 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 2006-2007 Page 6 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET SIGNIFICANT ACTIVITIES FOR FY 2006-2007 In addition to the routine duties of the District, which involve day-to-day addressing and assuring the 9-1-1 network is functional and CPE (9-1-1 Call Receiving Equipment) is operating properly: LECD plans to continue working on the following significant activities in this fiscal year. EQUIPMENT UPGRADE An upgrade to the "backroom" equipment is planned for all of the PSAPs in the District. The Plant/CML Pallas "backroom" equipment will position the PSAPs to take advantage of the NG9-1-1 (Next Generation 9-1-1) network, which is predicted to be deployed in Texas around the end of 2007. Current "backroom" equipment is not capable of operating with the newer technology that NG9-1-1 will provide. EMERGING TECHNOLOGY LECD will continue to focus on emerging technologies 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 NG9-1-1 that will be capable of receiving and locating 9-1-1 calls from ANY device. MICROWAVE PATH FEASIBILITY STUDY In this fiscal year, the District needs to explore some alternative/back-up network capabilities. A totally wireless (microwave) network is not the answer, but neither is a totally "hardwired" network. This study will give us insight into what would be required (towers, equipment, etc.), capacity (how much band width) and cost. LEGISLATION LECD continues to participate in the monitoring of State and National legislation as to how it relates to 9-1-1. 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 the Vesta equipment, Basic 9-1-1, and the changes that will come with the upgrade to the new Pallas backroom equipment. LECD will host seminars on topics that are pertinent to the education of the telecommunicator and suggested by the User Group. These are presented by well-known training consultants and are attended by public safety personnel throughout West Texas. LECD also provides a Proposed Budget 2006-2007 Page 7 funding source so that training can be provided to the telecommunicators. In this fiscal year we plan to install a functional PSAP in the District Office, which will provide specialized hands-on training for the user on the software and hardware used in the 9-1-1 centers. USER GROUP MEETINGS 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. PUBLIC EDUCATION LECD continues to maintain the Public Education Program. We plan to continue to build the LECD Road Show Team that consists of members of the 9-1-1 Public Safety Community. WIRELESS The major Wireless Service Providers have implemented Wireless Phase II Service in the District. LECD continues to work with Wireless Service Providers on 9-1-1 call routing from their network. CENTERLINE MAP LECD will continue to make updates to our centerline map and provide those changes to the PSAPs that use integrated mapping. LECD plans to publish an updated Public Safety Map Book in this fiscal year. This book provides the Dispatcher and the Field Responder with a comprehensive and easy to use reference for finding addresses in Lubbock County. Proposed Budget 2006-2007 Page 8 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET BUDGET NARRATIVE DISTRICT OPERATIONS This section of the budget describes the District Operating expenses of the budget. It pertains more to the day-to-day operations than to specific programs and projects. Employee Salaries And Benefits Salaries — Full Time $333,200 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 has been allocated to the primary job function of each employee. The unallocated percentage falls into general operations. Salaries — Part Time $17,200 This is for the salary of the part time District employee. Retirement Expense $32,000 This is the amount paid to the Texas County and District Retirement System by the District as the employer. The contribution rate is 7.73% for the calendar year 2006. The contribution rate for 2007 will be 9.79%. 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 $54,000 This is for medical, vision, dental, disability and life insurance through TML Intergovernmental Employee Benefits Pool for the full time District employees. Employees pay for a portion of the family members that are on the plan. A minimal increase is expected because the cost will be calculated according to LECD's group loss ratio, which is very low. 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. Proposed Budget 2006-2007 Page 9 TEC - Unemployment $1,900 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 .3%. Since the rate information is not received until after the first of the year, and the rate fluctuates from year to year, we are using a higher rate of 3% to calculate the amount for the 2007 calendar year. FICA - Benefit $27,700 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 This pays for 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 testing and any interviewing or moving expenses that may be required. Other Benefits $45,000 This pays for other employee benefits such as moving expenses and wellness benefit assistance. After a discussion with the LECD auditor, it was decided that funds should be available to pay out all accrued PTO (personal time off) and the applicable FICA and retirement contributions if the need arises. All full-time regular employees upon resignation are eligible to receive payment for earned, unused PTO up to 45 days. 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 Board Meetings and User Group Meetings are held at the LECD office on a regular basis as well as an increasing number of seminars and webinars that include local and area public safety agencies. This is used to purchase paper Proposed Budget 2006-2007 Page 10 goods and refreshments for these meetings. It is also used to purchase facility cleaning supplies. Funds are also designated for benevolent causes. Educational Supplies $850 This covers the cost of subscriptions to educational and technical publications and any other training material. Postage $1,000 In addition to the daily mailing that the District does, this also includes several projects including distribution of the LECD Quarterly newsletter and invitations to events. Mapping Supplies $600 Supplies necessary for production of reference maps for requesting agencies and PSAPs. Printing $1,500 The LECD Quarterly newsletter is printed quarterly. Other printing costs will be minimal because letterhead, envelopes and business cards were all printed when the move was made to the new facility. Maintenance Office Equipment Maintenance $1,700 This covers the cost of repair to any of the office equipment other than computers. This might include video equipment, fax machine, printers, telephone equipment, etc. Computer Equipment Maintenance $14,350 A detailed explanation of this item is included in the Information Systems narrative. Facility Maintenance $1,500 This covers cost of maintenance of the District offices not covered under the lease agreement. Small Tools & Equipment $600 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. Proposed Budget 2006-2007 Page 11 Rent/Lease Machinery $2,300 This covers leases of equipment such as the copy machine, postage meter and postage scale. It also includes rental of equipment for meetings and receptions. Other Services/Expenses Rent/Lease Facilities $43,200 This covers the annual office lease and costs incurred should alternate space need to be rented for meetings, training classes, etc. 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 on a regular basis 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. Regular 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. The audit of FY 2006-2007 will be the last year of a five- year contract with Pattillo, Brown & Hill. Public Education $34,000 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. Communication Services $14,400 This pays for the District's local telephone and long distance service. It also includes service for wireless phones, Internet, web hosting and the alpha/numeric pagers. Whenever possible, services are contracted through the State of Texas at a reduced rate. Proposed Budget 2006-2007 Page 12 Professional Dues and Memberships $2,900 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 $19,900 This is for the travel expenses of staff and Board Members to attend meetings, training, seminars, and conferences. This may include Texas 9-1-1 Alliance meetings, NG9-1-1 meetings, PEI User Group meetings, Board Executive Briefings, NENA Conference, NENA goes to Washington, Technical Development Conference, Critical Issues Forum, etc. It includes the cost of flights, hotel accommodations, meals, rental cars, cab/shuttle, parking, etc. Training $8,100 This covers the cost of tuition/registration for training classes, seminars and conferences for the LECD staff and Board members. Insurance $8,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,000 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 $5,300 With the move to the current facility, we have downsized the square footage in all of the individual offices. This is causing problems with space usage as the current furniture was all purchased for use in offices that were much larger. In addition, with the increase in the size of our conference room we have the ability to hold larger groups of people for training classes and seminars. This will require the purchase of more tables and adequate seating. Proposed Budget 2006-2007 Page 13 Communication Equipment $1,000 This pays for any changes or additions to the office telephone key system or communication devices carried by staff. Computer Equipment — Replacement $9,800 A detailed explanation of this item is included in the Information Systems narrative. This covers the replacement of legacy equipment. Equipment Replacement Fund $14,340 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-2007 Page 14 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET DATABASE Addressing Rural Route Conversions Rural Route Conversions were completed for the county during the fiscal year 2005-2006. This category is no longer necessary for the budget. Customer Service/Notification: 36% of Gross Income of Database Manager 40% of Gross Income of Database Technician This section represents time spent helping customers obtain addresses and the follow-up involved in distributing assigned addresses to all the necessary parties. Included in this category is the data entry and filing that is created by this service to the customers. Over the past year we have found that a significant portion of our time is being devoted to this process. Correction of Incorrect ALI Information: 40% of Gross Income of Database Technician 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. Proposed Budget 2006-2007 Page 15 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 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: 10% of Gross Income of Database Manager 20% 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: $6,000 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 purchase history of sign orders and what is anticipated for the coming year by our personnel and County sign personnel. Total For Street Signs: $5,000 Proposed Budget 2006-2007 Page 16 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET DATABASE Training Training: $1,000 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: $400 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 cost of flights, hotel accommodations and meals. Total For Database Training: $2,400 Proposed Budget 2006-2007 Page 17 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET DATABASE MSAG Maintenance This section covers the cost of the maintenance of the MSAG (Master Street Address Guide). All costs associated with this ongoing program in the Database department are under the category of salaries. MSAG Maintenance/Cleanup: 25% 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 of MSAG data with the Centerline file and will continue processing necessary changes to keep the two files concurrent. Proposed Budget 2006-2007 Page 18 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET DATABASE GIS Data Exchange and Update: 55% of Gross Income of GIS Coordinator Centerline maintenance makes up the bulk of this category. Data that is fundamental to our dataset is retrieved at least annually from both the City of Lubbock and the Lubbock Central Appraisal District. When received, this data must be massaged and converted for use in our GIS. Lubbock County has recently added GIS personnel, increasing the number of agencies with which we exchange data. 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. This same function is performed for Lubbock EMS, but the data has to be first sent to their CAD vendor for formatting. We work with their personnel in order to streamline EMS updates. The future addition of integrated mapping at the Lubbock Police Department (LPD) and Lubbock Sheriffs Office (LSO) will further increase the frequency and amount of data being provided to the PSAPs. Data Validation, Cleanup and Addressing: 10% of Gross Income of GIS Coordinator 5% 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 of the errors have been corrected by and continue to be 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 Lubbock Police Department, Lubbock Fire Department, and Lubbock Sheriff's Office. Overall, the amount of data validation and cleanup will be less than previous years and should continue to decrease. Proposed Budget 2006-2007 Page 19 Producing Maps for Third Parties: 20% of Gross Income of GIS Coordinator Mapping Supplies/Map Books:. $8,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, reprinting, and redistributing the Public Safety map books, which are being used now by the Emergency Responders and are much easier to provide 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 Significant time is spent by the 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: 5% 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: $8,500 Proposed Budget 2006-2007 Page 20 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006.2007 BUDGET LECD QUARTERLY NEWSLETTER Salaries: 25% 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,000 These 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: $390 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,390 Proposed Budget 2006-2007 Page 21 Lubbock Emergency Communication District FY 2006-2007 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 testing equipment or tools for repair necessary to maintain IS equipment or to enhance/improve operations as they relate to IS. This also includes disposables such as backup tapes & CDR/RW media. Replacement Equipment $9,800 This amount covers the replacement of an existing server, two workstations, one laptop, & two 21" monitors. These purchases will be made out of the replacement account. Office Equipment Maintenance $1,700 This amount covers the cost of maintenance contracts on the District printers and other office equipment other than computers. Hardware contracts ensure the District maintains normal operation of heavily used devices. Computer Equipment Maintenance $14,350 The following describes both hardware and software related maintenance items. Software Contracts $7,600 Software contracts ensure the District has the latest version of the programs in use for day-to-day operations. Repair Parts $1,500 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 $2,650 Software necessary to restore, upgrade, or add functionality required by District users. This includes incremental upgrades to a specific software program not covered by a maintenance contract. Proposed Budget 2006-2007 Page 22 Computer/Network Consulting $2,600 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 2006-2007 Page 23 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 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 and Board Members. 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 $100 Fees for conferences and meetings involving Public Education that may be attended by various staff members. Proposed Budget 2006-2007 Page 24 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET 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 Headsets Other Maintenance/Repair WAN Maintenance Upgrades CPE Backroom Equipment Upgrade Mission Control Upgrade Other Upgrades Telecom municator Training Salary Tuition Seminars Travel Expenses Education Materials Catastrophic Contingency PSAP Emergency Responder Support Communication Services Proiects Wireless Implementation Emerging Technologies PSAP Grant Funding Training Center PSAP Microwave Path Feasibility Study Proposed Budget 2006-2007 Page 25 This page intentionally left blank. Proposed Budget 2006-2007 Page 26 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 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: $53,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 AT&T, 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. Also included is the cost of a T-1 data circuit between Slaton PD and Slaton FD. This also includes the telephone lines installed at the PSAPs for remote maintenance. 9-1-1 Database Charges: $215,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 AT&T based on the number of ALI records that exist in the ALISA database, Currently there are approximately 165K subscriber records for LECD in the AT&T ALISA database. Wireless Network Costs: $159,000 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 15 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 2006-2007 Page 27 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET PSAP SUPPORT Maintenance The following describes the items included in PSAP maintenance expenses. Customer Premise Equipment — Servers/Workstations: $103,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. Logging Recorders: $15,000 This pays the annual maintenance on the logging recorders. This is also a year-to- year contract. Headsets: $2,000 LECD provides headsets to all of the telecommunicators in the District. This fund is for repair/replacement of headsets during the year. Other Maintenance/Repair: $12,000 This is used to pay for maintenancelrepairs 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. 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 2006-2007 Page 28 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET PSAP SUPPORT Upgrades CPE Backroom Equipment Upgrade: $686,600 Over the last five (5) years changes in technology have left our existing Plant MAARS Backroom Equipment quickly becoming ineffective and obsolete. While the "front end" equipment is viable for another couple of years, Backroom Equipment upgrades need to start now. In this fiscal year LECD will upgrade the Backroom Equipment from analog (MAARS) at all sites to Plant/CML Pallas (digital/IP ready). This process will take some time at each PSAP, but the end result will be that each PSAP will be capable of NG9-1-1 as soon as it becomes available. The cost also includes spare parts and funds for any changes that might need to take place in wiring or other area related to the change of equipment. Also included is the cost to relocate the 9-1-1 trunks in Slaton, due to the equipment change. Slaton Police Dept. Upgrade to Pallas ............................... $65,604 Slaton Fire Upgrade to Pallas (Remote off Slaton PD)....... $69,294 Lubbock County Sheriff Upgrade to Pallas.........................$81,500 Lubbock Police Dept. Upgrade to Pallas ......................... $132,028 Lubbock Fire Dept. Upgrade to Pallas ................................ $90,384 Lubbock EMS Upgrade to Pallas ....................................... $74,766 Texas Tech Police Upgrade to Pallas ................................ $66,818 Plainview Police Upgrade to Pallas .................................... $65,604 SpareParts........................................................................ $18,690 Retrofitting costs................................................................$21,912 Mission Control: $93,500 This is to add the new pieces of equipment (Pallas Servers) onto our Mission Control contract. This provides remote monitoring and repair and reporting of trouble that cannot be repaired remotely. This will be for a three (3) year contract. 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 2006-2007 Page 29 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET PSAP SUPPORT Telecommunicator Training/Travel This section details the planned expenditures for training and associated travel of PSAP personnel. 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: 10% of Gross Income of Operations Manager This is the percentage of staff salary that is spent training telecommunicators and supervisors and coordinating training events in direct support of PSAP personnel. Tuition: $2,700 This will be used at each PSAP to help with tuition for PSAP personnel 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 2006-2007 Page 30 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 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. Emergency Responder Support: $13,000 Street Signs $5,000 This is for manufacture and maintenance of street signs in rural areas of Lubbock County. (See database narrative for details.) Public Safety Map Books $8,000 LECD will provide map books for all responding agency personnel. (See database narrative for details.) PSAP Communication Services: $1,600 This covers a portion of the cost of services required to maintain availability of staff for PSAP requests. This includes wireless devices and pagers. Proposed Budget 2006-2007 Page 31 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 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 Funding: $47,000 Starting in fiscal year (FY 2005-2006) LECD 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, $35,830 to replace console furniture in the dispatch center. This is a continuation of a project started with a grant from LECD during FY 2005-2006; Lubbock County Sheriffs Department, $3,510 to purchase chairs for the dispatch center, printers, file cabinets and wireless mouse; Plainview Police Department, $6,700 to install an automatic transfer switch to the back-up generator system. All items meet the criteria of the Grant Program. Training Center PSAP: $120,000 LECD has always assisted the PSAPs with training. Since 1999-2000, LECD has provided training to the user agencies on the use of the 9-1-1 Vesta equipment installed in the PSAPs. In order to accomplish this, three (3) additional "training/backup" workstations were installed at Lubbock Police Department in their training room. By being "backup" they are connected to the "live" 9-1-1 backroom equipment at Lubbock PD. While this worked well, this setup prevented Proposed Budget 2006-2007 Page 32 LECD from having the ability to use the "training/backup" workstations for experimentation and troubleshooting of problems, as they are "live." With the migration to NG9-1-1 and the installation of a different backroom technology, the need for a training center/lab has increased. Along with issues of logistics that now occur when a training class needs to be presented, Staff would appreciate the ability to recreate reported problems in a "closed" environment. This training center would give the District the ability to test software upgrades before they are dispersed to the field and the ability to hold the training classes at the District Offices instead of hauling additional equipment to an offsite location. This cost includes the purchase of 9-1-1 backroom equipment and workstations and funds for any additional wiring, etc. required to establish the training PSAP. Also included is the cost to install the 9-1-1 trunks. Microwave Path Feasibility Study: $49,000 In this fiscal year, the District needs to explore some alternative/back-up network capabilities. This has been brought to the forefront on a couple of occasions when we have had cable cuts, etc. We also want to have a plan for next generation 9-1-1 and the network that it will travel on. A totally wireless (microwave) network is not the answer, but neither is a totally "hardwired" network. This study will give us insight on what would be required, such as towers, equipment, capacity or how much bandwidth, and cost. The District would have Harris MCD, the leader in microwave equipment and networks, conduct the study. The District would be under no obligation to make additional purchases from them if the project continues. Specifically this cost includes: upfront path engineering for eight (8) hops, field surveys for each path, alternative recommendations for up to three (3) additional paths if initial paths are not viable, a report containing complete information to license and implement paths, path profiles with calculations, and antenna size and placement. Also included would be tower recommendations where appropriate, survey of site to determine power requirements, equipment location, suitability of grounding, equipment location, cable routing, etc. This information will be used to generate an equipment list and cost of materials. Proposed Budget 2006-2007 Page 33 This page intentionally left blank. Proposed Budget 2006-2007 Page 34 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET CHARTS FY 2006-2007 Revenue Forecast Financial Charts 9-1-1 Calls Proposed Budget 2006-2007 Page 35 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET 2006-2007 REVENUE FORECAST AT&T-LUBBOCK AT&T - PLAINVIEW VALOR SOUTH PLAINS TELEPHONE COOP WIRELESS - LUBBOCK WIRELESS - PLAINVIEW PRIVATE SWITCH -TEXAS TECH CLEC-LUBBOCK CLEC - PLAINVIEW INTEREST INCOME -LUBBOCK INTEREST INCOME - PLAINVIEW SPAG-LUBBOCK SPAG - PLAINVIEW MISCELLANEOUS TOTAL REVENUE % CHANGE FROM PREVIOUS YEAR TOTAL SERVICE FEE REVENUE % CHANGE FROM PREVIOUS YEAR 2001-2002 2002-2003 2003-2004 2004-2005 Projected 2005-2006 Projected 2006-2007 691,678 599,607 554,608 613,864 451.000 390,000 54,652 48,946 46,468 50,614 46.800 43,000 43,493 34,931 43,338 35,903 31,000 26,000 22,958 21,871 21,566 20,944 20,000 19,000 627,065 666.934 737,978 816,623 875,000 933,000 67,226 60,096 65.422 71,520 75,000 78,000 38,809 36,051 33,047 20,218 18,400 9,000 450,378 410,095 389,869 364,242 381,800 390,000 1,500 2,000 $4,477 60,169 58,743 125,149 202,000 205,000 2,205 1,256 1,651 4,113 6,000 6,500 8,1431 7,599 7.474 7.4561 3,500 2,800 1,364 2,297 2,350 2,2481 2,300 2,600 214 207 2,881 300 0 2,062,662 1,949,851 1,962.711 2,035,775 2,114.600 2,106,900 -4.40% -6,38% 0.66% 3.72% 3.87% -0.36% 1,995,7661 1,888,4261 1,902,110 11903,632 1,906,300 1,895,400 -0.29% -5.38% 0.72% 0.08°h 0.14% -0.57% Proposed Budget 2006-2007 Page 36 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET Revenue Comparison REVENUE 1,200,000 1,000,000 800,000 600,000 — 400,000 200,000 0 ILEC CLEC Wireless Interest ■ 00-01 ❑ 01-02 ❑ 02-03 ■ 03-04 S 04.05 ■ 05-06 Proj. ❑ 06-07 Proj CHART 1 REVENUE vs SERVICE FEE 2,300,000.00 -- 2,200,000.00 -- 2,100,000.00 -Total Revenue 2,000,000.00 Service Fee 1,900,000.00 1,800,000.00 1,700,000.00 00-01 01-02 02-03 03-04 04-05 05-06 06-07 CHART 2 Proposed Budget 2006-2007 Page 37 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET Revenue vs. Expenses $2,500,000 — $2,000,000 i"�`♦ �..♦�♦ • $1,500,000 $1,000,000 $500,000 00-01 01-02 02-03 03-04 04-05 1-0---Expenses —*— Revenue This chart shows a comparison for the last five years between revenue and expenses. CHART 3 Proposed Budget 2006-2007 Page 38 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET District/PSAP Breakdown ■ District 26°10 a PSAP 74% This chart shows 74% of the District's FY 2006-2007 Budget goes toward the direct support of the Public Safety Answering Points (PSAPs). CHART 4 Proposed Budget 2006-2007 Page 39 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET Maintenance 43% Catastrophic 4% PSAP Support Emergency Responder Support a w r Training Recurring 1% 21% Projects 29% Comm Svcs 1% This chart shows how the 74% of the District's budget that goes toward direct support of the PSAP is broken down. 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 2006-2007 Page 40 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET District Operations Furn & Equip Equipment 2% Replacement *.. 2% `•fit Other Services 23% Maintenance' Y 3% r Supplies 1% Personnel 69% As shown in this chart, personnel services make up the bulk of the District portion of the budget. CHART 6 Proposed Budget 2006-2007 Page 41 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2006-2007 BUDGET Calls by PSAP May 05 Jun 05 Jul 06 Aug 05 Sept 05 Oct 05 Nov 05 Doc 05 Jan 06 Feb 06 Mar 06 Apr 06 Total Lubbock Police Wireline 6023 5670 6284 5529 5426 5219 4704 4802 4943 4229 4846 4882 62,577 Wireless 7740 6485 6974 6592 $766 6449 5721 6282 6225 6824 6591 6985 79,634 Lubbock So Wireline 660 666 886 643 604 611 556 625 586 515 599 571 7,522 Wireless 1053 862 1251 928 832 752 885 807 807 915 942 1010 1 11,044 Plainview Police Wireline 562 496 582 648 464 456 415 454 457 362 517 491 5,904 Wireless 573 342 435 439 444 413 357 428 493 414 549 663 5,650 Slaton Police Wireline 1 139 135 1 131 127 1 115 99 107 127 143 109 152 129 1,613 Wireless 144 89 1 126 132 89 70 125 89 140 133 101 115 1,3537 Texas Tech PD Wireline 208 47 64 56 66 96 73 53 48 65 135 50 1 961 Wireless' 7 0 8 3 18 15 12 4 7 21 9 9 1 113 Total primary 78,457 97,681 Lubbock EMS Wireline 1135 1113 1123 1190 1123 1143 1091 1165 1274 972 985 1097 13,411 Wireless' 372 355 386 411 359 340 306 392 398 387 388 413 4,507 Lubbock Fire Wireline 148 157 230 105 151 126 155 188 158 105 126 130 1,779 Wireless` 169 134 1 234 113 151 107 99 164 149 167 164 127 1,798 Slaton Fire Wireline 5 8 7 2 3 1 8 4 13 11 5 1 681 Wireless' 2 1 6 1 2 1 13 10 20 14 7 5 82 Total Seconds 15,258 6,387 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 AT&T ASK reporting system. During this time period of FY 05-06 55% of all 9-1-1 calls were from wireless phones. This percentage is up from 39.6% during the same time period of FY 04-05. CHART 7 Proposed Budget 2006-2007 Page 42