Loading...
HomeMy WebLinkAboutResolution - 2002-R0320 - Resolution To Approve LECD Budget For 2001_02 Fiscal Year - 08_29_2002Resolution No. 2002—RO320 August 29, 2002 Item No. 51 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 and directed to execute for and on behalf of the City of Lubbock, a Resolution to approve the Lubbock Emergency Communication District Budget for Fiscal Year 2001/2002 and the L.E.C.D. action in setting the service fee at 5% of the telephone base rate effective January 1, 2003. Said budget is attached hereto and 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 29th ATTEST: Rebecca Garza, City Secretary APPROVED AS TO CONTENT: 14, Sharlett Chowning (i Information Technology Manager APPROVED AS TO FORM: William de Haas Contract Manager/Attorney gs/ccdocs/LECD Budget 2001/2002.res August 20, 2002 day of August , 2002. Resolution No. 2002-RO320 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET Table Of Contents FY 2002-2003 BUDGET AgencyOverview..............................................:.....................................1 Goals.........................................................................................................7 Budget Narrative Administrative..................................................................................9 Database.......................................................................................15 LECDQuarterly.............................................................................22 Information Systems......................................................................23 Public Education Program.............................................................25 PSAPSupport................................................................................27 Financial Charts Chart 1 - Budget Breakdown..........................................................40 Chart 2 - Budget Breakdown/PSAP Support .................................41 Chart 3 - Budget Breakdown/District Operations ...........................42 FY 2002-2003 Revenue Forecast.............................................................43 Chart 4 — Budget Breakdown/Revenue FY 2002-2003..................44 9-1-1 Calls by PSAP.................................................................................45 Chart 5 - 9-1-1 Calls for Service...................................................46 Proposed Budget 2002-2003 LUBBOCK EMERGENCY COMMUNICATION DISTRICT - PROPOSED 2002-2003 BUDGET ITEM ACCOUNT # TOTAL BUDGET 2001-2002 TOTAL BUDGET 2002-2003 % CHANGE LUBBOCK 2002-2003 PLAINVIEW 2002-2003 DESCRIPTION SALARYIEMPLOYEE EXPENSE Salaries - Full Time 5010-000 $250,200 $283,742 $265,299 $18,443 Page 2,3,9,1546,18-23,34 Salaries - Part Time 5020-000 $51,075 $20,100 $18,794 $1,307 Page 2,9,25 Retirement Expense 5030.000 $17,300 $16,500 $15,428 $1,073 Page 9 Insurance Benefd 50404W $36,265 $49,400 $46,189 $3,211 Page 9 Workers' Compensation 50504W $600 $750 $701 $49 Page 9 TEC - Unemployment 5060-000 $820 $1,300 $1,216 $85 Page 10 FICA - Benefd 5080.000 $22,250 $23,000 $21,505 $1,495 Page 10 Payroll Service 5090-000 $730 $850 $795 $55 Page 10 Pre -Employment Expense 51004= $5,000 $5,000 $4,675 $325 Page 10 Other Benefds 51104000 $5,000 $5,000 $4,675 $325 Page 10 TOTAL SALARY/EMPLOYEEEXPENSE $389,240 $406,642 4.21% . $379,275 $26,367 SUPPLIES Office/Operating Supplies 60104000 $2,700 $2,700 $2,525 $176 Page 10,15 Other Supplies 60204000 $3,700 $3,5W $3,273 $228 Page 10 Educational Supplies 6030-000 $1,800 $1,600 $1,496 $104 Page 10,24 Postage 6040.000 $2,100 $2,500 1 $2,338 $163 Page 11.15-16,22 Mapping Supplies 6050.000 $1,000 $4,000 $3,740 $260 Page 11.21 Printing 60704000 $2,700 $2,600 $2,431 $169 Page 11,16,22 TOTAL SUPPLIES $14,000 $16,900 20.71% $16,802 $1,099 MAINTENANCE Office Equipment Maintenance 70104000 $1,000 $1,700 $1,590 $111 Page 11 Computer Equipment Maintenance 7020-000 $11,500 $10,300 $9,631 $670 Page 23-24 Facility Maintenance 7030 000 $2,000 $1,000 $935 $65 Page 11 Small Tools & Equipment 7040-000 $800 $600 $561 $39 Page 11,23 Rent/Lease Machinery . 7050-000 $3,000 $3,300 $3,086 $215 Page 11 TOTAL MAINTENANCE $18,300 416,900 -7.66% $15,802 $1,099 OTHER SERVICES/EXPENSES Rent/Lease Facilities 8010-000 $47,6W $46,000 $43,010 $2,990 Page 11 Relocation Expense 8011-000 $30,000 $0 $0 $0 Lobbyist Services 8040-000 $4,000 $3,000 $2,805 $195 Page 12 Legal Services 8050.000 $18,000 $10,000 $9,350 $650 Page 12 Accounting Services 8060-W0 $6,000 $5,000 $4,675 $325 Page 12 Public Education 8070-000 $34,315 $36,590 $34,212 $2,378 Page 25-26 Professional Services 8080-000 $9,000 $8,000 .$7,480 $520 Page 12,20,24 Telephone 8090-000 $11,500 $11,000 $10.285 $715 Page 12 Professional Dues and Memberships 81004)00 $1,730 $1,900 $1,777 $124 Page 12 Travel 81104000 $25,700 $21,300 $19,916 $1,385 Page 12,17,26 Training 8120-000 $10,000 $10,000 $9,350 $650 Page 13,17,24,26 Insurance 8130-000 $8,000 $8,000 $7,480 $520 Page 13 Vehicle Expense 81404)W $12,500 $12,5001 $11,688 $813 Page 13 TOTAL OTHER SERWCE&EXPENSES 1 $218,346 $173,290 -20.63%1 $162,026 $11,264 Proposed Budget 2002-2003 LUBBOCK EMERGENCY COMMUNICATION DISTRICT - PROPOSED 2002-2003 BUDGET ITEM ACCOUNT # TOTAL BUDGET 2001-2002 TOTAL BUDGET 2002-2003 % CHANGE LUBBOCK 2002-2003 PLAIWIEW 2002-2003 DESCRIPTION CAPITAL Office Furniture 1210-000 $1,000 $1,000 $1,000 Page 13 Communication Equipment 1220-000 $2,500 $1,200 $1,200 Page 13 Computer Equipment - Capital Improvements 1230-000 $12,000 $8,500 $8,5W Page 23 Computer Equipment - Replacement 9030-OW $5,000 $5,000 Page 23 TOTAL CAPITAL $16,600 $15,700 1.29% $15,700 SUBTOTAL DISTRICT OPERATIONS $666,385 $628,432 4.11% $588,604 $39,828 PROJECTS Street Signs 9020-105 $7,750 TOTAL PROJECTS $7,750 TOTAL DISTRICT OPERATIONS $676,635 $628,432 -6.97% $588,604 $39,828 EQUIPMENT REPLACEMENT FUND-LECD 9030-100 $12,400 13,106 $13,106 Page 13 PSAP SUPPORT Other PSAP Support Recurring Charges 9810-M $444.200 $544,2o0 $521,969 $22,231 Page 29,30 Maintenance Charges 9830-000 $454,600 - $193,000 $174,487 $18,513 Page 31-33 Telecommunicator Training 9850-000 $11,500 $9,700 $9,100 $600 Page 34 Catastrophic Contingency 9860-000 $100,000 $100,000 $93,500 $6,6W Page 35 Street Signs 1 9870.000 $8,700 $8,700 Page 36 Equipment Replacement Fund-PSAP 9030-200 $430,000 $430,000 1 $389,688 $40,312 Page 37 Total Other PSAP Support $1,440,300 $1,285,600 -10.74% $1,197,444 $88,156 Projects Wireless Implementation 9020-104 $200.000 $350.000 $350,000 Page 33,38 Technology Funding 9020-106 $492,600 $470,6o0 $460,600 $10,000 Page 38 Wide, Area Computer Network 9020-107 $50,000 PSAP Radio Network 9020-108 $12,000 $12,000 Page 38-39 Central Office Back Up 9020-109 $40,000 $40,000 Page 39 Adm. Strategic Planning 9020-110 $3,000 Total Projects $746,600 $872,600 17.03%1 $862,600 $10,000 TOTAL PSAP SUPPORT $2,185,900 $2,158,200 4.27% $2,060,044 $98,156 TOTAL $2,861,435 $2,799,738 -2.16% $2,661,7114 $137,984 Proposed Budget 2002-2003 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET AGENCY OVERVIEW Background In 1986 an overwhelming vote of the public approved the creation of the Lubbock Emergency Communication District. Authority to create the District is 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 over 20,000.) The District's mission was to establish the Enhanced 9-1-1 system as the primary emergency telephone communication system for Lubbock County. All political subdivisions within Lubbock County assisted in this mission by establishing Public Safety Answering Points to receive emergency 9-1-1 calls. 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 Southwestern Bell Telephone Company, 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 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 in fiscal years 1999-2000 and 2000-2001. This project replaced 9-1-1 call taking equipment that was installed in January of 1989. In fiscal year 2000-2001, all of the Wireless Service Providers within the District began providing Wireless E9-1-1 Phase I 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 2002-2003 Page 1 Staff In addition to the Board of Managers, the District employs a staff of six (6) full time employees, one (1) part time employee, and has a contract with an employment agency for the services of one (1) person. In this budget we would like to change this to seven (7) 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 MANGER — Is in charge of the day-to-day operations of the District, including payroll, accounts payable/receivable, PSAP personnel training, and other responsibilities. Becomes "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 hardwarelsoftware used internally by the District. Is responsible to the Executive Director. PUBLIC EDUCATION COORDINATOR —Administers the District's Public Education Program. Responsible for creating and purchasing hand out material as it relates to 9-1-1 use. Coordinates the Road Show Team in making public presentations at schools, health fairs and other events to spread the word about the proper use of 9-1-1. This position is a part time position and is responsible to the Executive Director. GIS COORDINATOR — Is charged with the. creation and verification of a GPS accurate street level map. Is assigned to create a centerline map file with accurate address/block ranges, which will be used by various emergency response agencies. This position is responsible to the Database Manager. Proposed Budget 2002-2003 Page 2 RECEPTIONIST/CLERICAL ASSISTANT —Assists Operation Manager with clerical/receptionist duties. Assists other staff members as necessary with projects. This position is currently filled through a contract with a temporary employment agency and is responsible to the Operations Manager. In this budget we are requesting to make this a full-time non-exempt position. Proposed Budget 2002-2003 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 and which addresses supplied for ALI are validated against. RURAL ADDRESSING — Lubbock County Commissioners Court made LECD sole addressing authority for all unincorporated portion of Lubbock County. LECD coordinates the provision and use of these addresses to all affected parties. MAP DEVELOPMENT — The centerline map that is being developed will be used by the PSAPs to locate the 9-1-1 call graphically on a map display. This will be both wire -line calls and wireless calls. The wireless call location will occur when Wireless Phase II Service becomes available. 9-1-1 NETWORK —'LECD is responsible for assuring the 9-1-1 network that transports the 9-1-1 calls is operating properly. LECD accomplishes this by working closely with SWBT and jointly testing and reporting problems when they occur. 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 is also 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 24x7. LECD staff is also trained to troubleshoot, identify and repair minor configuration problems and serve as a resource to the PSAP operators for technical information and problem resolution. LOGGING RECORDERS — Part of the equipment that LECD provides to the PSAPs that it supports is logging recorder equipment. The 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 retained 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" and the use of the "Vesta" workstation. 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. ROAD 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. Proposed Budget 2002-2003 Page 4 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. QUARTERLY NEWSLETTER — The Database Manager serves as the. Editor for this publication that goes out every quarter. The publication takes many hours of the staffs time to prepare. More than 200 newsletters are mailed to PSAPs, Districts, people, and businesses in Texas and across the United States. RESEARCH AND PLANNING — District staff are continually researching the most advanced technology on the market, determining if it fits the needs of the District and planning for its implementation. 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 2002-2003 Page 5 This page intentionally left blank. Proposed Budget 2002-2003 Page 6 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET GOALS FOR FY 2002-2003 In addition to the routine duties of the District, which involve the day-to-day addressing, assuring the 9-1-1 network is functional, CPE is operating properly, etc.; LECD plans to achieve the following goals in this fiscal year. PUBLIC EDUCATION LECD is in the process of revising our Public Education Program to make it more effective and versatile. In FY 2002-2003 we plan to continue to build the LECD Road Show Team that consists of members of the Public Safety Dispatching Community. Additionally investigate the use of Texas Tech students who are involved in the public speaking program at Tech and incorporate their expertise into the Road Show team. Presenters are interviewed and critiqued before presentations. TELECOM MUNICATOR TRAINING Continue to provide local training for telecommunicators. Getting telecommunicators to training is a difficult task due to schedules and budgets, but if they have to go out of town to get the training, it is even more difficult. LECD will provide a funding source so that local training for telecommunicators can be provided. This will help ease the financial burden on most of the PSAPs that LECD supports. Training will be of the same quality they would receive if they had to go "out of town" to get it. USER GROUP MEETINGS During the next fiscal year LECD will continue to host User Group meetings, at least monthly, on a schedule that is amenable to those who participate. Participation has been very good at these meetings in the last fiscal year, and we hope to see this continue. The User Group provides beneficial input to how LECD accomplishes its mission. WIRELESS Completion of Wireless Phase 1 occurred in March of 2001. We will 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. In January 2003, the orders will be placed with the Wireless Carriers for Wireless Phase 'II Service. Proposed Budget 2002-2003 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 2001-2002. In this fiscal year, we will continue to update and enhance this map by adding features to it that are needed by our 9-1-1 PSAPs. MAP BOOKS Produce a high quality map book that can be used by the PSAPs and the field emergency responders. This was planned in last year's budget, but could not be implemented due to the incompletion of the centerline map file. We will procede with the project during this fiscal year. Proposed Budget 2002-2003 Page 8 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET BUDGET NARRATIVE ADMINISTRATIVE This section of the budget describes the General Administrative section of the budget. This section pertains more to the day-to-day District operations than to specific programs and projects. EMPLOYEE SALARIES AND BENEFITS Salaries — Full Time $283,742 This is for salaries for the full time District employees. This figure includes applicable merit raises for all the full time employees, plus move the Receptionist/Clerical position to full time. 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 $20,100 This is for the salaries of the part time District employee and payment to Road Show Team members. Retirement Expense $16,500 This is the amount paid to the Texas Retirement System by the District as the employer. The contribution rate is 6.16% for the calendar year 2002. The rate will decrease in the year 2003 to 5.58%. The employee also contributes 5% to this fund. Insurance Benefits $49,400 This is for medical, vision, dental and life insurance for the District employees. Employees pay for spouses and family members that are on the plan. This increase is based on a projected 25% increase in premiums, plus the addition of one full time employee. Workers' Compensation $750 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 2002-2003 Page 9 TEC - Unemployment $1,300 This is the District's contribution to the Texas State Unemployment Fund. It is based on a percentage of first $9,000 per employee. The rate for the current calendar year is 1.5%. The rate for the previous year was .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 1.75% to calculate the amount for the 2003 calendar year. FICA - Benefit $23,000 This is the District's contribution to Social Security. OASDI (Old -age, Survivors, and Disability Insurance) — 6.2%. Medicare—1.45%. Payroll Service $850 Pays for the cost of our payroll service. They take responsibility for all payments and reports to state and federal agencies. Pre -Employment Expense $5,000 This covers the fees for pre -employment drug testing and interviewing expenses. Other Benefits This pays for other employee benefits such as moving expenses. SUPPLIES Office & Operating Supplies Paper, pens, stationary, staples, envelopes and other supplies essential to conducting business. Other Supplies $5,000 $2,700 $3,500 This is used to purchase supplies such as paper goods and refreshments for meetings and special events. Includes Board meeting/member supplies. This also includes facility supplies such as paper goods and cleaning supplies. Educational Supplies $1,600 This covers the costs of subscriptions and technical publications. Includes educational/training material. Proposed Budget 2002-2003 Page 10 Postage $2,500 This is for mailing that the District does. This is divided among several projects including the rural route conversion and the LECD Quarterly newsletter. Mapping Supplies $4,000 Supplies necessary for production of reference maps and map books for requesting agencies and PSAPs. Printing $2,600 This pays for printing letterhead, envelopes, LECD Quarterly newsletter, business cards, etc. MAINTENANCE Office Equipment Maintenance $1,700 This covers the cost of any repair to the equipment other than computers. This might include desks, fax machine, typewriter, printers, etc. Facility Maintenance $1,000 This covers cost of maintenance on the District offices not covered under the lease agreement. This also includes furniture cleaning/upkeep. Small Tools & Equipment $600 Replacement or purchase of small equipment such as calculators, video player, any item excluding computers with a value of less than $500. RentlLease Machinery $3,300 This covers the cost of leases on equipment such as the copy machine and postage meter. In this fiscal year we plan on leasing, through the State of Texas Copier Lease Program, a new technology, faster copy machine. OTHER SERVICES/EXPENSES RentlLease Facilities $46,000 This covers the annual office lease and costs incurred should alternate space need to be rented for meetings, training classes, etc. Proposed Budget 2002-2003 Page 11 Lobbyist Services $3,000 This pays the District's share of a lobbyist retained by all the Districts as a whole. The lobbyist works on behalf of the Communication Districts and is our spokesperson at the Capitol. He also prepares and submits monthly updates to -the Districts Legal Services $10,000 Pays for our local attorney and for the co-op attorney retained by the Districts to watch over legal issues that may affect all Districts. Accounting Services $5,000 This pays for the annual District audit and other accounting services, including consultation. Professional Services This section is for consultants and outside services that the District might use in various projects. This includes completion of the scanning of maps described in the GIS section of the budget. Telephone $11,000 This pays for the District's telephone local and long distance service and for the alpha/numeric pagers that are carried by staff. The pagers are on a contract through SPEMS at a reduced rate. Also includes cost of wireless phones, Internet service and web hosting service. Professional Dues and Memberships $1,900 This covers the annual dues to organizations like APCO (Association of Public Safety Communication Officials), NENA (National Emergency Number Association), URISA (Urban & Regional Information Systems Association), Lubbock Chamber of Commerce, and other civic organizations, etc. Travel $21,300 This is for the travel expenses of staff, Board Members, and telecommunicators to attend meetings, training, seminars, etc. Staff will attend both state and national NENA/APCO conferences, District Director meetings, Public Education Group meetings, Technical Development Conference, Critical Issues Forum, etc. This includes the cost of flights, hotel accommodations, meals, rental cars, cab/shuttle, parking, etc. Proposed Budget 2002-2003 Page 12 Training $10,000 This covers the cost of tuition/registration for training classes, seminars and conferences for the LECD staff, Board members, and telecommunicators. Insurance $8,000 This covers insurance on all District -owned or leased equipment, liability insurance and errors and omission coverage. Vehicle Expense $12,500 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 paid to non-exempt full time and part time employees for travel on District business. Office Furniture $1,000 This covers cost of replacing furniture. Communication Equipment $1,200 This covers the cost of replacing/repairing telephones and key system. Replacement Account $13,106 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 2002-2003 Page 13 This page intentionally left blank. Proposed Budget 2002-2003 Page 14 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 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 is 80% complete at the beginning of FY 2002/03 and we hope to be 95% complete by the end of FY 2002/03. This will encompass address changes to approximately 5 to 6 routes. Salaries: 15% of Gross Income of Database Manager 75% 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. Office 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: $30 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: $130 Proposed Budget 2002-2003 Page 15 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 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: $8,700 These figures are based upon "per sign" costs obtained from the District's sign vendor, Lubbock Grader Blade. We have revisited these costs, and based on quotes from other manufacturers, Lubbock Grader Blade is still the most cost effective. 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 since beginning the maintenance phase. Also included are figures for replacing all signs in subdivisions that may be converted from city street names to numbered county roads. Regular Maintenance sign orders $5,600 Proposed Subdivision Conversion sign replacement $3,100 Notification Campaign: $570 Costs attributed to any public information campaign deemed necessary to the acceptance and maintenance of installed street signs. This campaign could be done jointly with other campaigns produced by Lubbock County officials. Funds could be used toward any campaign geared toward the proposed subdivision conversion and notification of residents. Proposed Subdivision Conversion brochure printing $200 Postage to mail brochures to all affected residents $370 Total For Street Signs: $9,270 Proposed Budget 2002-2003 Page 16 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET DATABASE Training Training: $1,000 Training for Database and GIS staff to bring more proficiency in actual use of various applications, including upgrades to ArcView 8 and possibly, GeoMedia 5. Some training will probably be on-line training. These costs cover both tuition and materials. Conferences/Seminars: $800 Another helpful resource in addressing and GIS is the annual Street Smart and Address Savvy conference hosted by URISA. Funds included for Database Manager and one other staff person to attend. The 2003 conference will be held in mid -August 2003. These costs cover both registration and materials. Tuition is also included for the Database Technician to attend NENA's E911 Database course sometime in 2003, if feasible, place and date to be announced. Travel: 1 $4,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: $5,800 Proposed Budget 2002-2003 Page 17 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET DATABASE MSAG Maintenance All costs associated with this ongoing program in the Database department are under the category of salaries. MSAG Maintenance/Cleanup: 10% of Gross Income of Database Manager 5% of Gross Income of Database Technician Continuation of the data cleanup resulting from the map development and migration to new database. Complete the process of MSAG comparisons with different Telco's to get all discrepancies resolved. Proposed Budget 2002-2003 Page 18 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET DATABASE GIS Base Mapping Development: Base map development has been completed. Our base mapping efforts are now concerned with map maintenance and update. Periodic updates will be processed (See Data Exchange and Update). Centerline File Development: Centerline file development will have been completed. Data update, verification, and validation on this dataset will continue. Data Exchange and Update: 20% of Gross Income of GIS Coordinator Completion of Base map and Centerline file development results in a shift from digitizing to data maintenance. LCAD has taken over the responsibilities for the parcel mapping, so data exchange and integration replace data digitizing. The establishment of Integrated Mapping in the PSAPs 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. 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. Data Validation, Cleanup and Addressing: 20% of Gross Income of GIS Coordinator 45% of Gross Income of Database Manager 10% of Gross Income of Database Technician Resolving discrepancies between our addressing database and map data will be a main focus of our GIS project. Missing records, invalid data links, duplication, and missing objects on the map, are all examples of problems that are being identified and corrected by the GIS Coordinator, Database, Manager, and Database Technician. Each problem record must be identified, located, evaluated, and corrected. This process involves individual and group. effort, since each person is involved with a different part of data creation, and uses the data differently, resolving potential problems can be time consuming for multiple people. Assigning missing addresses will also be a part of this workflow. Proposed Budget 2002-2003 Page 19 Validation, verification, and cleanup of data that is being used in the PSAP's for integrated mapping is an addition to this process. Problems between the Telco database and LECD created map need to be identified and corrected. A workflow for this task has not been developed, but it will involve personnel at each PSAP using integrated mapping, the GIS Coordinator and other LECD staff, and Telco database management personnel. - Maps for the Third Parties: 5% of Gross Income of GIS Coordinator This is becoming an increasingly time-consuming task. Not only do we provide maps for all our responding agency personnel, but we also, for a price, provide maps to outside parties who request them. While this map production did not significantly impact work flow in the past, we are finding that as our information gets closer to completion and the word gets around as to what we have, the requests are becoming more of a demand on our time. We anticipate that a significant amount of time will be spent during the next fiscal year responding to these demands so we need to include this factor into the budget. We also will make data available on the Internet in an attempt to lessen the burden of data requests on the staff. Map Scanning Project: 25% of Gross Income of GIS Coordinator Now that the base map project is completed, we plan to finish the project of scanning our paper maps into digital format. We plan to migrate to our automated addressing program concurrently with centerline completion. We will archive the maps and use them for reference in address assignments. Map Scanning Costs $2,000 This cost is based on 400 maps at $5.00 each. 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: 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. Proposed Budget 2002-2003 Page 20 Map Book Production: 15% of Gross Income of GIS Coordinator 5% of Gross Income of Database Manager Mapping Supplies $3,000 Production of a high quality map book geared toward emergency responders is a priority now that the GIS data development is completed. Our emergency responders will be provided with a detailed hard copy of our data set so that they may navigate rural Lubbock County (and perhaps the entire County) more efficiently. The GIS Coordinator will work closely with LECD staff, emergency responders, and PSAP personnel in order to develop data display standards and conventions acceptable for all users. A master copy of the book will be printed in- house, and we will develop a reference grid and feature index. Proposed Budget 2002-2003 Page 21 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 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: $2,000 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 a local copy vendor. 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 and are adjusted to accommodate the new postal rate. The newsletters are posted on office postal equipment and mailed from the LECD offices. Total LECD Quarterly Newsletter: $2,370 Proposed Budget 2002-2003 Page 22 Lubbock Emergency Communication District FY 2002-2003 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: $200 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) Replacement Equipment $5,000 This amount covers the replacement of an old -technology workstation, 3 large - screen monitors, and an old -technology modem, all currently in-service. These purchases will be made out of the replacement account. Capital Improvements $8,500 This section describes expenditures for capital items for use in the everyday operations of District Staff. This amount covers a new presentation projector, a new notebook PC, and gigabit expansion switching hardware for our network backbone. Maintenance $10,300 The following describes both hardware and software related maintenance items. Software Contracts: $7,000 Geomedia GIS — $3,700 ESRI GIS - $1,000 MS Great Plains accounting — $1,000 Symantec Anti -virus - $200 Lotus E-Mail - $1,100 Repair Parts: $1,200 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. _ Proposed Budget 2002-2003 Page 23 Software Upgrades: $2,100 Software - $1,000 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. Veritas Backup Exec addition - $500 Add agent for enhanced open -file backup. Defrag Commander - $300 Software for automating and monitoring the defragmenting of files/data on all workstation and server hard drives. Additional Adobe Acrobat License - $300 Purchase of an additional user license for staff to be able to easily create PDF files at their workstations. Other Services and Charges $4,800 Computer/Network Consulting: $4,000 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: $800 ' Trade journals, magazines, reference manuals, and resource kits related to IS and Information Technologies. Training $2,300 This section describes the various training opportunities that IS technician can use to stay abreast of current trends and industry issues, as well as professional skills development. Online: $800 Training available over the Internet covering both professional and personal courses at MindLeaders.com & other providers. Classroom Based: $1,500 Tuition to attend training available in Lubbock or on -site. Proposed Budget 2002-2003 Page 24 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET PUBLIC EDUCATION PROGRAM Salary 100% of Gross Income of Public Education Coordinator This is the salary for the Public Education Coordinator. The Public Education Coordinator's position is part time and may work up to 40 hours per pay period in this fiscal year. Public Awareness Evaluations Marketing Survey $3,800 Contract with The Institute of Communications Research, Texas Tech University School of Mass Communications, for a yearly Telephone Survey of residents of Lubbock County regarding their knowledge of the proper use of 9-1-1. The survey will be used for yearly comparisons to determine the target groups that need further education. Total also includes any in-house evaluations such as a PSAP survey and school age children survey. Public Awareness Campaign $1,000 Contract with the Texas Tech School of Mass Communications to develop several awareness campaign plans regarding wireless phones and the proper use of 9-1-1. Recognition and Appreciation Events $2,500 Tokens of appreciation and activities related to National Telecom municators Week, 9-1-1 Day and Kid Hero awards. Advertising $16,800 Production of Public Service Announcements through print, television, radio, and billboards. Clothing and accessories worn by LECD staff. Production of brochures and flyers. Total also includes $10,500 for our participation in the state wide wireless campaign or a local wireless campaign. Proposed Budget 2002-2003 Page 25 Supplies and Materials $11,790 Book covers handed out to school age children. Cost of items distributed during public education events such as the following: South Plains Fair, Safety City, Senior Jamboree, city wide Health Fair at South Plains Mall, Harwell Elementary Science Fair, Fiestas Del Llano, Fire Prevention Week, July 4th Parade, Stubbs Elementary Health Fair, PTA meetings, Neighborhood Watch Association meetings, and Career Days. CSEC will provide an additional $2,210 for supplies and materials. Presentation Supplies $500 Repair and maintenance of presentation display and accessories. Road Show Team $4,700 Purchase of team shirts for 8 members. Compensation for team participating in events. Travel $2,450 Quarterly Public Educators meetings, TENA conference for award nominees and Kid Hero award event. Registration Fee $1,200 Conference fees attended by Public Education Coordinator and award nominees. Proposed Budget 2002-2003 Page 26 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 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 9-1-1 Central Office Isolation Network Maintenance CPE Equipment —Workstations Logging Recorders UPS Equipment Headsets Other Maintenance/Repair WAN Maintenance Upgrades Enhanced ALI Server Other Upgrade Installations CPE Replacement Funds Telecommunicator Training Salary Tuition Instructors Travel Expenses Education Materials Catastrophic Contingency Street Signs Proiects Wireless Implementation Technology Funding PSAP Radio Network 9-1-1 Central Office Back-up Proposed Budget 2002-2003 Page 27 This page intentionally left blank. Proposed Budget 2002-2003 Page 28 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET PSAP Support Recurring Costs This section describes the charges from the telephone companies for the provision of 9-1-1 network and database services. We have also included funds for the recurring wireless costs that are anticipated in this fiscal year. 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 Southwestern Bell, Valor and South Plains Telephone Cooperative. 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, and the ALI Fax capability. 9-1-1 Database Charges: $230,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 average charge for this service is about $0.105 per record. We pay this fee to Southwestern Bell, Valor and South Plains Telephone Cooperative based on the number of subscriber line records that they maintain. Currently there are approximately 154K subscriber records for LECD on the Southwestern Bell ALISA database. Wireless Network Costs: $250,000 These are the costs to keep the wireless telephone network in operation. The various wireless providers charge for their recurring service in two different methods. One method is the pass along of the actual cost for the telephone trunks to link the Mobile Switch Center (MSC) to the SWBT Tandem and to include database costs for keeping the subscriber database up to date. The second method used is based on a set amount, normally $0.15 to $0.25 per subscriber. We have an additional expense from SWBT. Each antenna has it's own telephone number or pAni (psuedo ANI) this number directs the routing of the wireless phone call from the antenna to the proper PSAP. SWBT charges a monthly fee for each pANI number that is in use. Currently the wireless service providers are using about 250 pANls to provide the Wireless Phase 1 Service. Proposed Budget 2002-2003 Page 29 Language Line Services: $1,200 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 foreign callers to 9-171. This service is used about 10 times per month. The cost is a minimum of $50 per month based on number of minutes used. WAN Recurring Costs: $30,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. 9-1-1 Central Office Back Up: $3,000 This is the cost to maintain the required seven -digit telephone lines and wireless phones to keep this network in operation. In the event of a central office isolation, this system will route the 9-1-1 call over the wireless telephone network to the PSAP. Proposed Budget 2002-2003 Page 30 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET PSAP SUPPORT Maintenance The following describes the various portions of the maintenance expenses. A breakdown of the CPE maintenance expenses per answering position is $3,969. To calculate a per PSAP amount you would multiply this figure by the number of answering positions an agency has. CPE Equipment —Workstations: $127,000 This pays for the yearly 24x7 maintenance on the telephone customer premises equipment and the workstations used by the telecommunicators. Included in this amount is the extended software maintenance support that provides for software updates (media/license) from Plant, Inc. This is the third year of a four-year contract that continues until July 2005. Logging Recorders: $ 15,000 This pays the annual maintenance on the logging recorders. This is the third year of a four-year contract that ends in 2005. UPS Equipment: $5,000 This section pays for the annual maintenance contract on the UPS (Uninterruptible Power Supplies) 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 for the next fiscal year. Other Maintenance/Repair: $10,000 This will take care of 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, moving, adding or deleting lines from the 9-1-1 telephone equipment. Proposed Budget 2002-2003 Page 31 WAN Maintenance: $5,000 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 2002-2003 Page 32 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET PSAP SUPPORT Upgrades Enhanced ALI Server Upgrade Funds Included in Wireless Implementation Amount $100,000 Since the provisioning of Wireless 9-1-1 Phase I Service in Lubbock we have been working to get the wireless ALI (Automatic Number Identification) display to appear the same as a wireline ALI display. The Enhanced ALI Server upgrade will cure this problem and will also give us the ability to take advantage of new technology as it comes available. This software program will receive the ANI (Automatic Number Identification) or telephone number from the MAARS equipment. It will send the ANI to the ALI database for look -up. Upon receiving the ALI back, this program will rearrange the information so that the proper information shows up in the right places. All ALI displays will be presented to the 9-1-1 dispatcher in the same format, regardless if it is a wireline call, a HCAS or NCAS wireless call. This upgrade also includes a newer version of the Vesta software, which is the primary software run on the 9-1-1 workstations. Upgrade Installations — other: $30,000 This category covers the cost of software upgrades at the PSAPs for module upgrades that are scheduled for release by the manufacturer by the end of calendar year 2002. Since these have not been released, the cost to install them has been estimated. These upgrades include, Orion MapStar v5.1 and Orion MapManager v3.0. Proposed Budget 2002-2003 Page 33 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 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. Salary:. 5% of Gross Income of Operations Manager This would be a percentage of staff salary according to estimated time that would be spent training telecommunicators and coordinating events. Tuition: $1,600 This amount will be used at each PSAP to help with tuition for the telecommunicator to attend required classes either on -site or on-line. This amount has been designated in proportion to the number of telecommunicators employed. Instructors: $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. Travel Expenses: $2,100 This amount has been designated in proportion to the number of employees employed. This will cover travel expenses to conferences or classes. Education Materials: $2,000 This money would be used to purchase training materials used by LECD staff to train the telecommunicators. This would include videos and instructional materials. The larger PSAPs are very actively training their employees individually on -site. They have built.their own education libraries. This money would also be used to help them keep their materials current. Proposed Budget 2002-2003 Page 34 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 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. Proposed Budget 2002-2003 Page 35 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET PSAP SUPPORT Street Signs: $8,700 This is for manufacture and maintenance of street signs in rural areas of Lubbock County. (See database narrative for details) Proposed Budget 2002-2003 Page 36 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET PSAP SUPPORT Replacement CPE Equipment Replacement: $430,000 This is a revolving fund. The funds will carry 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, added to this amount 20% to cover increases in products and services, and then divided it into a five (5) year plan. At the end of the five (5) year period there will be about $2.1 million to replace all of the equipment at all of the PSAPs. Greater Harris County ECD and the State CSEC (Commission on State Emergency Communications) use a three-year replacement schedule. We feel that five years is a reasonable time frame for this equipment. Due to the dramatic changes in computer operating systems in the last couple of years, LECD is faced with having to replace computer equipment in the PSAPs sooner than expected. Due to changes in the base operating system (Windows XP as opposed to Windows NT) upgrades and enhancements to the core software that operates the 9-1-1 equipment in the PSAP is being written for the newest operating system only. This is not much different than what we are seeing in the business world. In order for LECD to use the newest operating system and take advantage of the newest upgrades for our core 9-1-1 software, we must replace the existing computers. This however is not a "forklift" replacement. The main "backroomn components of the system will stay in place, while the computers and servers are replaced. Monitors currently being used will also remain in place. We may make this change NEXT fiscal year (2003-2004). Proposed Budget 2002-2003 Page 37 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET PSAP SUPPORT Projects Wireless Implementation: $350,000 Wireless Phase 1 Service was implemented in the last fiscal year. We are now working on the implementation of the Wireless Phase II Service. Wireless Phase II E9-1-1 Service will supply the dispatcher/telecommunicator with the location of the wireless caller to within 125 meters 50% of the time per standards set by the Federal Communications Commission. It is the intent of District staff to place the order for Wireless Phase II service with all of the Wireless Service Providers in January of 2003. There will also be some wireline network costs that at this time are basically unknown. These costs will probably be divided between the Wireless Service Provider and Southwestern Bell. As described in documentation under PSAP Upgrades, $100,000 of this amount would be for Enhanced ALI Server Upgrade. Technology Funding: $470,600 This is a continuation of the Technology Funding from fiscal year (2000-2001). In this fiscal year, those agencies that did not request/receive the full amount of their allocation are eligible in this fiscal year to request the total amount or the remainder of their allocation. The same criteria and guidelines for requesting the allocation apply this fiscal year. If an agency requested and received the full amount of their allocation in fiscal year 2000-2001 or 2001-2002, they are only eligible for funding in the amount of $10,000 this fiscal year. PSAP Radio Network: $12,000 In this fiscal year, LECD wants to take the final steps in establishing a radio network between the PSAPs in Lubbock County. This radio network will provide an additional means for the PSAPs to communicate should the 9-1-1 telephone trunks going to a PSAP become damaged. The 9-1-1 calls will automatically route to a different location, and with the radio network the alternate PSAP can still provide the primary PSAP the information so that the proper emergency services can be dispatched as quickly as possible. The concept is to put all the PSAPs on the -City of Lubbock's 800 MHz trunk radio system. The PSAPs would be in their own "talk group." This means that they would only hear conversation initiated by one of the other PSAPs. There would be no other routine radio traffic heard. Proposed Budget 2002-2003 Page 38 Lubbock County Sheriffs Office has started using the City's 800 MHz radio system to dispatch their deputies. This means that only two radios, one for Texas Tech and one for Slaton would have to be purchased and installed. EMS, City Police Department and City Fire already have a radio to which a PSAP talk group can be added. To purchase and install the two radios required, pay the City system charge and the first year maintenance fee we will be expending about $12,000. 9-1-1 Central Office Back Uw. $40,000 One of the projects that we have worked on for the last couple of years is the back up of a central office in the event of isolation. We have four locations in the Lubbock area where isolation of the central office will mean a disruption in the 9-1-1 service. A solution is on the market that we have looked at, and it has been installed in other parts of Texas. The solution would basically call a seven -digit number in the exchange served by the central office and then route the call to the 9-1-1 wireless network. The PSAP would then receive the call as a wireless call. This is a clean way to make this happen. There are a couple of drawbacks. We have to have a telephone line to forward the calls to. We have to have a location to place the interface box, and we must have a wireless phone number on an analog wireless system for each site. Once installed, this system will cost about $3,000 to maintain, but we will have taken a step to ensure that at least one 9-1-1 call will pass through the system in the event of central office isolation. Proposed Budget 2002-2003 Page 39 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET Budget Breakdown This chart shows 77% of the District's FY 2002-2003 BUDGET goes toward the direct support of the Public Safety Answering Points (PSAPs). CHART 1 Proposed Budget 2002-2003 Page 40 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET Repla 200) MaiJ 9%, Trainii 1% PSAP Support CatastSigns 4% 1% Recurring 25% Projects 40% This chart shows how the 77% 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 2 Proposed Budget 2002-2003 Page 41 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET As shown in this chart, personnel services make up the bulk of the District portion of the budget. CHART 3 Proposed Budget 2002-2003 Page 42 SWBT - LUBBOCK SWBT - PLAINVIEW VALOR SOUTH PLAINS TELEPHONE COOP WIRELESS -LUBBOCK WIRELESS - PLAINVIEW PRIVATE SWITCH CLEC INTEREST INCOME -LUBBOCK INTEREST INCOME - PLAINVIEW SPAG-LUBBOCK SPAG -PLAINVIEW TOTALREVENUE % CHANGE FROM PREVIOUS YEAR TOTAL SERVICE FEE REVENUE % CHANGE FROM PREVIOUS YEAR 2002/2003 REVENUE FORECAST Annual Annual Annual Annual Annual 1996 1997 1998 1999 2000 Projected Projected Annual Annual Annual 2001 2002 2003 809,928 845,958 1,068,343 1,106,792 1,005,763 830,422 698,355 650,148 61,183 62,292 77,544 79,269 73,435 63,921 54,907 51,102 35,822 33,869 44,914 55,766 52,522 48,066 45,356 43,200 14,173 15,528 20,293 21,318 24,361 27,468 22,949 21,996 21,176 55,030 266,591 352,212 372,050 490,018 597,036 600,000 44,164 46,192 54,009 55,000 20,251 17,358 21,454 42,669 39,114 35,558 38,807 36,048 1,013 12,390 84,135 236,644 449,668 450,000 396,000 69,257 87,782 116,045 155,824 219,472 173,337 84,300 77,556 3,305 1,907 12,320 3,528 750 1,680 8,336 6,682 9,355 8,935 8,016 8,016 56,100 9,012 1,510 1,240 1,736 1,364 1,488 1,488 1,087,890 1,127,842 1,640,785 1,907,815 2,090,934 2,178,477 2,055,973 1,942,234 3.67% 45.48% 16.27% 9.60% 4.19% -5.62% -5.53% 1,127,842 1,521,375 1,750,084 1,859,142 2,001,612 1,970,923 1,862,998 34.89%1 15.03%1 6.23%1 7.66% -1.53% -5.48% Proposed Budget 2002-2003 Page 43 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET Our projected revenue for Fiscal Year 2002-2003 is $1,942,234. We project this to be 5.53% lower than the projected Fiscal Year 2001-2002. Revenue is expected from ILEC (Incumbent Local Exchange Carrier), CLEC (Competitive Local Exchange Carrier), Wireless Carriers, Private Switch (PS) and other sources, which includes income from interest. CHART 4 Proposed Budget 2002-2003 Page 44 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET 9-1-1 Calls by PSAP Jun- 01 Jul- 01 Aug- 01 Sep- 01 Oct- 01 Nov- 01 Dec- 01 Jan- 02 Feb- 02 Mar- 02 Apr- 02 May- 02 Total Lubbock Police Wireline 8712 8894 8118 7496 7491 7273 6616 6132 5925 7156 7163 7184 88,160 Wireless 4505 4967 1 5124 4959 5253 5386 4994 4673 4745 544.3 5326 5183 60,558 4 Lubbock SO Wireline 1673 1602 1564 1311 1536 1522 1299 1189 1204 1525 1440 1435 17,300 Wireless 1 635 700 657 531 580 659 616 577 519 605 599 686 7,364 Plainview Police P2914 Wireline 581 584 610 580 591 579 511 457 458 582 455 620 6,608 Wireless 17 16 7 16 17 40 29 113 172 174 172 794 7 t 441 Awl Slaton Police Wireline 146 157 116 171 125 139 113 88 97 99 128 97 1,476 Wireless* 9 a 7 5 11 7 10 5 8 2 7 5 84 Texas Tech PD Wireline 151 123 123 118 140 124 149 103 145 121 153 117 1,567 Wireless* 4 2 0 4 7 4 3 1 2 3 2 2 0 33 Total Primary 115,111 68,833 Lubbock EMS Wireline 1185 1202 1075 1050 1011 1022 1083 1088 992 1124 998 1098 12,928 Wireless* 94 144 146 110 132 152 136 131 142 171 136 207 1,701 Lubbock Fire Wireline 0 284 182 128 186 141 155 131 138 142 167 148 1,802 Wireless* 0 165 1 99 77 87 69 1100 90 75 77 68 96 11,003 Slaton Fire Wireline 5 7 2 1 7 12 10 4 1 1 3 4 57 Wireless* 3 1 4 3 2 1 1 1 0 1 0 1 18 Total Secondary 1 14,787 2,722 Wireless Call received by Lubbock PD or Lubbock SO 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 Southwestern Bell ASK reporting system. During this time period 37% of all 9-1-1 calls were from wireless phones. Proposed Budget 2002-2003 Page 45 LUBBOCK EMERGENCY COMMUNICATION DISTRICT FY 2002-2003 BUDGET 9-1-1 Calls for Service 140900C 120100C 100,000 80,000 60,000 40,000 20,000 0 IN Jun 00 - May 01 []Jun 01 - May 02 This chart shows the number of 9-1-1 Calls For Service, both Wireline and Wireless, for the last two years, handled by the PSAPs (Public Safety Answering Points) in the Lubbock Emergency Communication District. CHART 5 Proposed Budget 2002-2003 Page 46