Loading...
HomeMy WebLinkAboutIR 24-1897INFORMAL REPORT TO CITY COUNCIL MEMBERS No. 24-1897 To the Mayor and Members of the City Council September 10, 2024 Page 1 of 2 SUBJECT: Tarrant County 9-1-1 District, Structure, Funding, and FY25 Budget Approval The following Informal Report provides an update on the Tarrant County 9-1-1 District's governance, organizational structure, priority initiatives, and an overview of the District's FY25 budget, which requires Mayor and Council approval. History In April 1985, the citizens of Tarrant County overwhelmingly approved (86.5% of the vote) a referendum creating a communications district and giving the authorization to collect a service fee (20 cents per residential phone line, 46 cents per business phone line, and 74 cents per business trunk line). Following the 1985 balloting, the Tarrant County 9-1-1 Emergency Assistance District was staffed and began implementation of 9-1-1 districtwide. On August 1, 1987, enhanced 9-1-1 was implemented in Tarrant County. Governance and Mission The District is governed by a Board of Managers, comprised of two members appointed by the City of Fort Worth, one appointed by Commissioners Court, the City of Arlington, the City of Grand Prairie, the City of Irving, and the Tarrant County Mayor's Council. One non -voting member represents the major service supplier. The Tarrant County 9-1-1 District's mission is to continuously provide reliable, accurate, responsive, and effective emergency communication networks and services to our member jurisdictions ensuring the protection of life and property for citizens in our community. Key Deliverables • Ensure availability of the 9-1-1 system to all persons and entities within the Tarrant County 9-1-1 District. • Provide continuous improvement of systems and services through research and implementation of industry "best practices." • Enhance public education and awareness of available and future 9-1-1 services. • To provide leadership in the areas of legislation, regulation, and technology. • Advise, inform and educate Telecom m u nicators (and other public safety personnel) to ensure adherence to federal and state emergency communications laws and requirements. TC 9-1-1 District Funding Legislation under which the District was created authorizes the District to receive a monthly per -line fee from each telephone customer of up to six percent of the dominant telephone service provider's base rate. The following monthly 9-1-1 service fees on each telephone line were revised and adopted by the Board of Managers on August 23, 2021: Residential lines: $0.20 per line Business lines: $1.75 per line Business trunks: $2.50 per trunk Nomadic VolP: $0.50 per line In addition to the fee established by the Board of Managers, the District also receives a portion of the statewide surcharge on wireless telephone service. The surcharge is assessed at 50 cents per activated handset and is distributed to 9-1-1 jurisdictions based on population. ISSUED BY THE CITY MANAGER FORT WORTH, TEXAS INFORMAL REPORT TO CITY COUNCIL MEMBERS No. 24-1897 To the Mayor and Members of the City Council September 10, 2024 Page 2 of 2 SUBJECT: Tarrant County 9-1-1 District, Structure, Funding, and FY25 Budget Approval FY25 Proposed Budaet for the Tarrant Countv 9-1-1 District Board (attached) includes Below are bullet points highlighting our major budget projects for 2025: • Finalizing the sale of 2600 Airport Freeway with the Texas Department of Transportation o The District's commitment to securing a new headquarters due to eminent domain is complete and payment from 2600 Airport Freeway marked to ensure the new building meets 9-1-1 standards and security requirements. o Extensive research and feasibility studies concluded the new location meets the District's long-term needs. These studies involved a comprehensive analysis of various sites, including their strategic value, accessibility, and cost-effectiveness. o The District hired an Eminent Domain Consultant to ensure the legal framework governing eminent domain meets all actions for compliant with relevant regulations and standards. • Construction and buildout of 12600 Willow Springs, Fort Worth, TX 76052: • The Board of Managers approved a Construction Manager at Risk (CMaR), and the Phase 2 buildout completion date is May 2025. • Phase 3 includes landscape and earth moving to comply with FEMA requirements targeted for completion in December 2025. • Next Generation Core Services The Board of Managers approved Motorola Solutions as the NG9-1-1 Core Services provider. Due to eminent domain, implementation is contingent of the newly completed Phase 1 Data Center buildout at 12600 Willow Springs, Fort Worth, TX 76052: o Providing a robust and resilient NG9-1-1 infrastructure, including a resilient Data Center, Lab, and Network Operations Center, allows (for the first time) in-house care, custody, and control of a redundant, resilient, and secure 9-1-1 system for our citizens. o The NG9-1-1 Project is a multi -year project targeted to be complete in December 2026. Next Steps An M&C will be on the September 17t" Council non -consent agenda to approve the FY25 budget for the Tarrant County 9-1-1 District. Additionally, the District is available to update the Mayor and Council on the Next Gen 911 Project at an upcoming Council Work Session. If you have questions concerning this information, please contact Valerie Washington at valerie.washington(a�fortworthtexas.gov. David Cooke City Manager ISSUED BY THE CITY MANAGER FORT WORTH, TEXAS ANNUAL BUDGET FISCAL YEAR 2025 Approved by the Board of Managers on June 17, 2024 PRESENTED BY Sherry Decker, Executive Director PREPARED BY Aniel Austin, Chief Financial Officer TARRANT `9oa THIS PAGE IS INTENTIONALLY LEFT BLANK OVERVIEW OUR MISSION TARRANT 9-1-1 ��ISTRICT The Tarrant County 9-1-1 District will continuously provide reliable, accurate, responsive, and effective emergency communication networks and services to our member jurisdictions ensuring the protection of life and property for citizens in our community. 9-1-1 District Background Purpose The establishment of the Tarrant "To establish the number 9-1-1 as the County 9-1-1 Emergency Assistance District was authorized by the State Legislature and ratified by the voters in 1985 for the purpose of implementing and maintaining an Enhanced 9-1-1 Emergency call network for residents of the District District boundaries include all of Tarrant County, all areas outside Tarrant County included in the corporate limits of a member city, DFW Airport, and the City of Irving 00! �rlru� rowli'llh L�- 2A, primary emergency telephone number for use by certain local governments in this state and to encourage units of local governments and combinations of those units of local government to develop and improve emergency communication procedures and facilities in a manner that will make possible the quick response to any person calling the telephone number 9-1-1 seeking police, fire, medical, rescue and other emergency services." ,,ter _Y7r � ipl.l_ ■E icy '� i sad ■iEsi ii ii ■ Participating Member Cities • Arlington • Azle • Bedford • Benbrook • Blue Mound • Burleson • Calleyville • Crowley • Dallas/ Fort Worth Airport • Da Iwo rthington Gardens • EdgedifFs • Euless • Everman • Forest Hill • Fort Worth District Management • Grand Prairie Grapevine • Haltom City • Haslet • Hurst • Irving • Keller • Kennedale • Lakeside • Lake Worth • Mansfield • North Richland Hills Pantego • Pelican Bay Richland Hills • River Oaks Saginaw • Sansom Park • Southlake • Watauga • Westlake • Westover Hills • Weslworth Village • White Settlement Unincorporated Tarrant County TARRANT 9-1-1 DISTRICT As defined in the legislation, the District is governed by a Board of Managers, who appoints an Executive Director. Current board members and their appointing authority include: Member Aubry Insco (Chair) Rick Brunson (Vice -Chair) Jonathan Ingols Ray Richardson Valerie Washington Robert Alldredge Sam Hall Robert Brooks Appointed By City of Grand Prairie Tarrant County Commissioners Court City of Arlington Mayors' Council City of Fort Worth City of Fort Worth City of Irving AT&T (non -voting) The Emergency Telephone Number Act states, "...the Board shall manage, control and administer the District. The Board may adopt rules for the operation of the District." The legislation also allows the Board to appoint a director of communications for the District who serves as its general manager. The director, with approval from the Board, manages the services necessary to carry out the purposes of the Emergency Telephone Number Act. TARRANT 9-1-1 DISTRICT Goals and Obiectives Goal 1: Maintain Standards of Sound Governance Objective 1-A: Budget Performance Objective 1-B: Annual Policy Review Objective 1-C: Annual Review of Mandated Statutory and Regulation Compliance Objective 1-D: Annual PSAP Managers Survey Objective 1-E: Staff Development Objective 1-F: External Influence Goal 2: Maintain Reliable Network Objective 2-A: Network Availability Objective 2-13: Monitor PSAP Hold Times Objective 2-C: Mean -time to Repair Objective 2-D: System Capacity Objective 2-E: Preparedness Objective 2-F: Wireless and Nomadic VoIP Testing Objective 2-G: Customer Premise Equipment Goal 3: Maintain Quality Databases Objective 3-A: Call Statistics Objective 3-13: Routing Goal4: Effective Outreach, Communications, and Education Objective 4-A: Engaging Stakeholders Objective 4-B: Stakeholder Communications Objective 4-C: Training Executive Assistant Administrative Assista nt Director of Netw Director of Gis & Technology GIS liaison Technology & Network Manager Board of Managers Executive Director Deputy Director GIS Data Analyst security Analyst Network Analyst GISSpecialist N etwo rk Su p port Systems Specialist Administrator GIs Specialist IT Support Technician Chief human Resources Officer Chief Financial Officer Director of Technical Operations System Integration & Next Generation performance Analyst System Technologist PSAP Support Implementation Analyst Specialist QualitAssurance Telephony Analyst Analyst APIAR Specialist Strategic Communications Gfficer Communications Coordinator Training Coordinator Training Co-ordinator Training Coordinator TARRANT COUNTY 9-1-1 EMERGENCY ASSISTANCE DISTRICT FY 2025 BUDGET Executive Summary U TARRANT 9-1-1 DISTRICT The FY 2025 Budget has been crafted to support the District's forward movement in several critical areas of public safety communications. NG9-1-1 call routing technology is constantly evolving, and TC9-1-1 is dedicated to providing a solution to end -of -life equipment. TC9-1-1 staff continues to research new technologies and service offerings that help enhance our 9-1-1 service infrastructure to deliver voice, video, text, and data calls. Legacy 9-1-1 solutions have limitations Next Generation 9-1-1 Core Services (NGCS) has been designed to eliminate. • The migration away from legacy 9-1-1 systems covers eight categories: Network (NG9-1-1 and ESlnet), 9-1-1 Call Routing and Location, Geographic Information Systems (GIS), NG9-1-1 Core Services, PSAP 9-1-1 Call Handling Systems and Applications, Security, Operations and Operational Planning. • Planned progress on the Next Generation of 9-1-1 services through continued interaction with our user base, proof of concept projects, and the continued maintenance and upgrades to the NG911 system, when appropriate. • A focus on Contingency and Continuation of Operations through proof of concept on our Regional Relocation Site strategy and an expanded program for onsite power support to enhance the ability of PSAPs to remain in their primary facility and sustain normal operations during limited commercial failure incidents. • Continue testing with carriers and service providers for improved location -based routing and preparation for the Z-Axis (height) data. • The District has been awarded Grant through Commission on State Emergency Communications (CSEC) as a Subrecipient of federal Coronavirus State Fiscal Recovery Fund (CSFRF) funding opportunity # 4549601 for the Next -Generation 9-1-1 upgrade. The grant program originally was ending on December 31, 2024 but the deadline was extended to December 31, 2026. • The District is continuing to build the reserves for the Next -Generation 9-1-1 upgrade. • Due to the Texas Department of Transportation's eminent domain, the District's new headquarters Phase 1 is near completion, and Phase 2 and Phase 3 are scheduled to start soon. The total cost of building build -out is approximately $27 million, scheduled to be completed in May 2025. U TARRANT 9-1-1 DISTRICT Funding Legislation under which the District was created authorizes the District to receive a monthly per -line fee from each telephone customer of up to six percent of the dominant telephone service provider's base rate. The following monthly 9-1-1 service fees on each telephone line were revised and adopted by the Board of Managers on May 15, 2023 (RN 23-028): Residential lines: Business lines: Business trunks: Nomadic VoIP: $0.20 per line $1.75 per line $2.50 per trunk $0.50 per line In addition to the fee established by the Board of Managers, the District also receives a portion of the statewide surcharge on wireless telephone service. The surcharge is assessed at 50 cents per activated handset and is distributed to 9-1-1 jurisdictions based on population. Expenditures The following are highlights of expenditures for FY 2025: • The District's overall operating budget for FY 2025 decreased by $3.57 million. The reduction will help support the completion of the Next -Generation Core Services project. In FY 2025, the District designated around $2.4 million specificallyfor Next -Generation 9-1-1 related expenditures. • TC9-1-1 will work with industry providers to research, identify, and evaluate mitigation solutions. The Network & Technology Team will recommend potential solutions for future years based on funding availability. • An extensively expanded training program and assistance with pre -hiring testing to support call - taker retention at participating PSAPs. • An expanded public education emphasis with an outreach program strongly focused on young consumers and family units. • The GIS team will continue to work on addressing data to ensure optimal location accuracy for wireless devices used to call for assistance. Ensuring the Master Street Address Guide (MSAG) and Automatic Location Identification (ALI) data are current and match the National Emergency Number Association (NENA) standards of 98% accuracy (currently at 99.22%). • Continued focus on network security for both the PSAP and administrative networks. • Texas Department of Transportation has notified the District to vacate the main office building located at 2600 Airport Freeway Fort Worth, TX 76111, due to the expansion work on Hwy 121. The District didn't budget or plan this expenditure, so it will use its reserve fund balance to plan and pay for the new office building location and any associated expenses related to the move. U TARRANT 9-1-1 DISTRICT FY 2025 FUND BALANCE PROJECTION There are three significant types of reserve funds: Legally Restricted Reserves, Board Designated Reserves, and Unrestricted Reserves. Legally Restricted Reserves have restrictions imposed by an outside source, such as bond covenants, contractual obligations, etc. Board Designated Reserves are set aside for a specific purpose as determined by the Board of Managers. The Board of Managers has the authority to redirect the use of these reserves as the needs of the District change. Unrestricted Reserves are planned for use within a budget year for contingencies. Legally Restricted Reserves 9-1-1 Emergency Equipment Fund The Board established this fund to fund equipment acquisition and replacement projects as planned in the Capital Improvement Program (CIP) and the Five -Year Financial Plan. The balance shall not exceed total expenditures planned in the Capital Improvement Program and Five -Year Financial Plan. Board Designated Reserves Employee Benefits Payable Fund Even though Government Accounting Standards Board (GASB) Statement 45 does NOT require the reporting of other post -employment benefits, they are a District's financial obligation. Sick Leave Payable: It is the policy of the District to reward an employee upon retirement for a percentage of unused sick leave in accordance with the provision of the Personnel Policy. Vacation Payable: Upon termination of employment, each employee is eligible for their accrued vacation leave. TCDRS Underfunding: If at any time the District's Texas County and District Retirement System (TCDRS) account is underfunded, the District will establish sufficient reserves to fund that account fully. Unemployment Compensation: The District is self -insured against unemployment liabilities. The District shall maintain sufficient reserves for this self-insurance. *ARRANT 9-1-1 DISTRICT Unrestricted Undesignated Reserves Any remaining balance shall be considered unrestricted reserves. Any excess reserves in this category may result in an adjustment to the District's service fee. Tarrant County 9-1-1 District's Reserve Fund - Specific Purposes Amount $20,817,074 Fund Balance, September 30, 2023 Projected surplus (deficit), FY 2024 $9,880,591 Projected surplus (deficit), FY 2025 $10,715,385 New District Headquarters - Building ($20,700,000) Projected Fund Balance, September 30, 2025 $20,713,049 Three -Month Operating Reserve ($4,750,000) Available Equipment Replacement Fund $15,963,049 TARRANT 9-1-1 Tarrant County 9-1-1 District Emergency Assistance District Annual Budget Summary for FY 2025 Acct. No. Account Description I FY 2025 1 FY 2024 $ Inc / (Dec) I % Inc / (Dec) 4010 Wireline Service Fee $ 5,800,000 $ 6,000,000 $ (200,000) -3.33% 4011 Wireless Service Fee $ 14,000,000 $ 13,300,000 $ 700,000 5.26% 4030 Intergovernmental $ 9,701,445 $ - $ 9,701,445 100.00% 4020 Interest Income $ 480,000 $ 300,000 $ 180,000 60.00% Total income $ 29,981,445 $ 19,600,000 $ 10,381,445 52.97% Operating Budget: 5110 Salaries $ 3,314,411 $ 3,101,763 $ 212,647 6.86% 5431 Auto Allowance $ 27,000 $ 32,400 $ (5,400)-16.67% 5120 Health Insurance $ 1,000,000 $ 950,000 $ 50,000 5.26% 5130 Retirement Benefits $ 500,969 $ 476,100 $ 24,870 5.22% 5132 Medicare $ 48,450 $ 45,445 $ 3,005 6.61% 5140 Worker's Comp $ 15,000 $ 12,000 $ 3,000 25.00% Personal Services $ 4,905,830 $ 4,617,708 $ 288,122 6.24% 5210 Office Supplies $ 25,000 $ 21,000 $ 4,000 19.05% 5211 Incentives / Appreciations $ 18,000 $ 26,500 $ (8,500) -32.08% 5212 Meetings Expenses $ 28,850 $ 14,000 $ 14,850 106.07% 5220 Printing $ 500 $ 500 $ - 0.00% 5230 Postage $ 2,600 $ 2,600 $ - 0.00% 5240 Supplies and Materials $ 43,250 $ 45,750 $ (2,500) -5.46% 5250 Software $ 299,185 $ 252,550 $ 46,635 18.47% Supplies and Materials $ 417,385 $ 362,900 $ 54,485 15.01% 5310 Office Furniture $ 10,000 $ 14,000 $ (4,000) -28.57% 5311 PSAP Furniture $ 2,000 $ 1,000 $ 1,000 100.00% 5320 Office Equipment $ 599,500 $ 202,000 $ 397,500 196.78% 5321 PSAP Equipment $ 34,000 $ 28,000 $ 6,000 21.43% Furniture and Equipment $ 645,500 1 $ 245,000 1 $ 400,500 163.47% 5411 Legal $ 65,000 $ 50,000 $ 15,000 30.00% 5413 Professional Audit $ 28,500 $ 27,500 $ 1,000 3.64% 5414 Equipment Maintenance $ 175,600 $ 151,100 $ 24,500 16.21% 5415 Other Services $ 52,100 $ 54,000 $ (1,900) -3.52% 5416 Professional Development/Training $ 131,840 $ 98,655 $ 33,185 33.64% 5418 Building Improvements - Repairs $ 65,000 $ 65,000 $ - 0.00% 5429 Professional Services / Contracts $ 1,017,400 $ 1,179,600 $ (162,200) -13.75% 5430 IT Admin Services $ 42,600 $ 41,000 $ 1,600 3.90% Services, Rentals and Contractual Services $ 1,578,040 $ 1,666,855 1 $ (88,815) -5.33% 5422 Equipment Lease $ 5,000 $ 5,000 $ - 0.00% 5423 Back -Up Site Lease $ 102,886 $ 100,000 $ 2,886 2.89% TARRANT 9-1-1 `­ra,1r Acct. No. Account Description FY 2025 FY 2024 $ Inc / (Dec) % Inc / (Dec) 5424 Back -Up Site Fuel $ 15,000 $ 9,500 $ 5,500 57.89% 5425 Back -Up Site Maintenance $ 100,000 $ 15,100 $ 84,900 562.25% Lease Expense & Backup Sites $ 222,886 $ 129,600 $ 93,286 71.98% 5432 Travel $ 188,000 $ 170,000 $ 18,000 10.59% 5433 Vehicle Maintenance $ 10,000 $ 10,000 $ - 0.00% Travel and Auto $ 198,000 $ 180,000 $ 18,000 10.00% 5441 Professional Memberships $ 17,025 $ 14,746 $ 2,279 15.46% 5442 Subscriptions $ 750 $ 1,050 $ (300)-28.57% Memberships and Subscriptions $ 17,775 $ 15,796 $ 1,979 12.53% 5419 Building Utilities $ 200,000 $ 140,000 $ 60,000 42.86% 5451 Office Telephone $ 16,000 $ 15,000 $ 1,000 6.67% 5452 9-1-1 Telephone Service $ 3,141,000 $ 6,637,411 $ (3,496,411)-52.68% 5453 9-1-1 Enhancements $ 1,734,800 $ 820,600 $ 914,200 111.41% 5454 PS 9-1-1 Service $ 37,000 $ 30,000 $ 7,000 23.33% 5456 Wireless 9-1-1 Service $ 80,000 $ 80,000 $ - 0.00% Total Utilities $ 5,208,800 $ 7,723,011 1 $ (2,514,211) -32.55% 5460 Insurance $ 200,000 $ 80,000 $ 120,000 150.00% Insurance $ 200,000 1 $ 80,000 1 $ 120,000 1 150.00% 5472 Pub. Ed. Products/Services $ 100,000 $ 97,000 $ 3,000 3.09% 5474 Pub. Ed. Activities $ 115,000 $ 120,500 $ (5,500) -4.56% Advertising $ 215,000 1 $ 217,500 1 $ (2,500) -1.15% 5420 Bank Charges & Fees $ 4,000 $ 4,000 $ - 0.00% Miscellaneous 1 $ 4,000 1 $ 4,000 1 $ -1 0.00% Total Operating Budget 1 $ 13,613,216 1 $ 15,242,370 1 $ (1,629,153) -10.69% 1100 Furniture & Fixtures $ - $ - $ - 0.00% 1120 Office Equipment $ - $ - $ - 0.00% District Furniture and Equipment $ - $ - $ - 0.00% 1110 PSAP Furniture $ - $ - $ - 0.00% 1122 PSAP Equipment $ 2,411,000 $ 4,357,630 $ (1,946,630)-44.67% PSAP Furniture and Equipment $ 2,411,000 $ 4,357,630 1 $ (1,946,630) -44.67% 1130 New office building-12600 Willow Springs $ 3,241,844 $ - $ 3,241,844 100.00% District Building $ 3,241,844 $ - 1 $ 3,241,844 100.00% kFARRANT `9o1a1 Acct. No. Account Description FY 2025 FY 2024 1 $ Inc / (Dec) % Inc / (Dec) Total Capital Budget $ 5,652,844 $ 4,357,630 1 $ (1,946,630) -44.67% Total Operating & CAPEX Budget 1 $ 19,266,060 1 $ 19,600,000 1 $ (3,575,784)-18.24% Total Budgeted Surplus / (Deficit) 1 $ 10,715,385 1 $ - TARRANT Tarrant County 9-1-1 Emergency Assistance District Modeled Five -Year Funding Projection Acct. No. Account Description FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 Actuals Estimated YE Budget Forecast Forecast Forecast Forecast Revenue Budget: 4010 Wireline Service Fee 6,205,029 5,950,000 5,800,000 5,666,600 5,536,268 5,408,934 5,284,529 4011 Wireless Service Fee 13,963,311 13,700,000 14,000,000 14,210,000 14,423,150 14,639,497 14,859,090 4030 Intergovernmental - 7,149,743 9,701,445 - - - - 4020 Interest Income 953,779 851,431 480,000 455,000 430,000 405,000 380,000 Total Income $ 21,122,119 $ 27,651,174 $ 29,981,445 $ 20,331,600 $ 20,389,418 $ 20,453,431 $ 20,523,618 Operating Budget: 5110 Salaries 2,648,757 2,783,645 3,314,411 3,977,293 4,772,751 5,250,026 5,775,029 5431 Auto Allowance 32,400 32,400 27,000 32,400 32,400 32,400 32,400 5120 Health Insurance 806,373 849,287 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 5130 Retirement Benefits 713,146 407,038 500,969 477,275 572,730 630,003 693,003 5132 Medicare 37,612 41,207 48,450 57,671 69,205 76,125 83,738 5140 Worker's Comp 10,958 10,958 15,000 12,000 12,000 14,000 15,000 Personal Services $ 4,249,247 $ 4,124,536 $ 4,905,830 $ 5,556,638 $ 6,459,086 $ 7,002,555 $ 7,599,170 5210 Office Supplies 13,407 18,709 25,000 27,563 28,941 30,388 31,907 5211 Incentives / Appreciations 4,913 7,228 18,000 19,845 20,837 21,879 22,973 5212 Meetings Expenses 5,018 9,390 28,850 31,807 33,397 35,067 36,821 5220 Printing - - 500 551 579 608 638 5230 Postage 553 800 2,600 2,867 3,010 3,160 3,318 5240 Supplies and Materials 5,506 21,500 43,250 47,683 50,067 52,571 55,199 5250 Software 176,616 221,555 299,185 368,014 404,215 444,037 487,840 Supplies and Materials $ 206,012 $ 279,182 $ 417,385 $ 498,329 $ 541,047 $ 587,710 $ 638,697 5310 Office Furniture 4,590 - 10,000 10,000 10,000 10,000 10,000 5311 PSAP Furniture - 500 2,000 2,000 2,000 2,000 2,000 5320 Office Equipment 54,677 178,446 599,500 242,500 264,500 304,175 349,801 5321 PSAP Equipment 81 16,069 34,000 34,000 34,000 34,000 34,000 Furniture and Equipment $ 59,348 $ 195,015 $ 645,500 $ 288,500 $ 310,500 $ 350,175 $ 395,801 5411 Legal 71,282 46,709 65,000 68,959 71,027 73,158 75,353 5413 Professional Audit 24,500 27,000 28,500 29,651 30,244 30,849 31,466 5414 Equipment Maintenance 162,666 141,078 175,600 182,694 186,348 190,075 193,877 TARRANT 9-1-1 Acct. No. Account Description FY 2023 Actuals FY 2024 Estimated YE FY 2025 Budget FY 2026 Forecast FY 2027 Forecast FY 2028 Forecast FY 2029 Forecast 5415 Other Services 31,593 35,141 52,100 55,273 56,931 58,639 60,398 5416 Professional Development/Training 60,338 45,210 131,840 134,490 135,835 137,193 138,565 5418 Building Improvements - Repairs 55,445 52,629 65,000 68,959 71,027 73,158 75,353 5429 Professional Services / Contracts 936,974 843,568 1,017,400 1,235,684 1,288,768 1,347,656 1,410,489 5430 IT Admin Services 27,940 43,435 42,600 46,967 49,315 51,781 54,370 Services, Rentals and Contractual Services $ 1,370,737 1 $ 1,234,770 $ 1,578,040 1 $ 1,822,676 1 $ 1,889,496 1 $ 1,962,509 1 $ 2,039,870 5422 Equipment Lease 4,303 4,802 5,000 5,513 5,788 6,078 6,381 5423 Back -Up Site Lease 86,580 99,850 102,886 113,432 119,103 125,059 131,312 5424 Back -Up Site Fuel 980 5,912 15,000 16,538 17,364 18,233 19,144 5425 Back -Up Site Maintenance 7,046 11,039 100,000 110,250 115,763 121,551 127,628 $ 98,909 $ 121,604 $ 222,886 $ 245,732 $ 258,018 $ 270,919 $ 284,465 Lease Expense & Backup Sites 5432 Travel 100,848 102,493 188,000 207,270 217,634 228,515 239,941 5433 Vehicle Maintenance 6,975 - 10,000 10,201 10,303 10,406 10,510 Travel and Auto $ 107,824 $ 102,493 $ 198,000 $ 217,471 $ 227,937 $ 238,921 $ 250,451 5441 Professional Memberships 10,527 12,308 17,025 17,367 17,541 17,716 17,893 5442 Subscriptions - 700 750 765 773 780 788 Memberships and Subscriptions $ 10,527 $ 13,008 $ 17,775 $ 18,132 $ 18,314 $ 18,497 $ 18,682 5419 Building Utilities 98,423 139,757 200,000 212,180 218,545 225,102 231,855 5451 Office Telephone 8,574 14,974 16,000 17,640 18,522 19,448 20,421 5452 9-1-1 Telephone Service 4,789,183 5,394,422 3,141,000 2,300,000 4,065,705 3,114,129 3,114,129 5453 9-1-1 Enhancements 159,872 2,869,768 1,734,800 5,527,211 5,720,903 6,002,730 5,251,487 5454 PS 9-1-1 Service 23,204 36,948 37,000 38,495 39,265 40,050 40,851 5456 Wireless 9-1-1 Service 73,508 - 80,000 80,000 80,000 80,000 80,000 Total Utilities $ 5,152,763 $ 8,455,869 $ 5,208,800 $ 8,175,526 $ 10,142,940 $ 9,481,459 $ 8,738,742 5460 Insurance 66,600 1 80,000 200,000 220,500 231,525 243,1011 255,256 Insurance $ 66,600 $ 80,000 $ 200,000 $ 220,500 $ 231,525 $ 243,101 $ 255,256 5472 Pub. Ed. Products/Services 82,096 - 100,000 104,040 106,121 108,243 ,408 5474 Pub. Ed. Activities 114,232 - 115,000 179,646 182,039 184,480 ,969 ;27 Advertising $ 196,328 $ - $ 215,000 $ 283,686 $ 288,160 $ 292,723 $ ,377 TARRANT 9-1-1 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FAcct. No. Account Description Actuals Estimated YE Budget Forecast Forecast Forecast Forecast 5420 Bank Charges & Fees 232 362 4,000 4,410 4,631 4,862 5,105 Miscellaneous $ 232 $ 362 $ 4,000 $ 4,410 1 $ 4,631 $ 4,862 $ 5,105 1 Total Operating Budget $ 11,518,526 $ 14,606,838 $ 13,613,216 $ 17,331,600 $ 20,371,652 $ 20,453,431 $ 20,523,618 Capital Budget: 1130 Building Purchase 10,628,044 1 2,086,125 1 3,241,844 - I - I - I - District Building $ 10,628,044 1 $ 2,086,125 1 $ 3,241,844 1 $ - 1 $ - 1 $ - 1 $ - PSAP Furniture and Equipment I $ - 1 $ 1,077,6211 $ 2,411,000 $ 3,000,000 1 $ 17,767 1 $ - I $ - Total Capital Budget 1 $ 10,634,236 1 $ 3,163,746 1 $ 5,652,844 1 $ 3,000,000 1 $ 17,767 1 $ - 1 $ - Total Operating & CAPEX Budget $ 22,152,762 $ 17,770,584 $ 19,266,060 $ 20,331,600 $ 20,389,419 $ 20,453,431 $ 20,523,618 Total Encumbered Funds 1 $ 697,011 1 $ - 1 $ - 1 $ - I $ - I $ - I $ - Net impact on the reserves 1 $ (1,727,654)1 $ 9,880,5911 $ 10,715,385 $ - $ - $ - $ - FUND BALANCE MOVEMENT Beginning Fund Balance $ 22,544,728 1 $ 20,817,074 1 $ 30,697,665 $ 20,713,049 $ 15,563,049 $ 10,413,049 1 $ 7,913,049 Net impact on the reserves 1 $ (1,727,654)1 $ 9,880,5911 $ 10,715,385 $ - 1 $ - 1 $ - 1 $ - GMP Phase 2 & Furniture $ - $ - $ 20,700,000 $ - $ - $ - $ - Future Projects $ - $ - $ - $ 5,150,000 $ 5,150,000 $ 2,500,000 $ 2,500,000 Estimated Ending Fund Balance $ 20,817,074 $ 30,697,665 $ 20,713,049 $ 15,563,049 $ 10,413,049 $ 7,913,049 $ 5,413.049 Tarrant County 9-1-1 Emergency Assistance District 12600 Willow Springs - Budget Architectural and Interior Design Services Fransen Pittman Construction: GMP - Phase 1 GMP - Phase 1 - Change Order Chiller Loop Pipes Switch Gear - ABB - 24-PO-3324 GMP - Phase 2 & 3 (WIP) - Number as of 2/27/2024 Furniture for the building Generators 500 & 750 kW - 24-PO-2619 Data Center Grid, Cabinets, PDUs - 24-PO-2565 Opticool Data Center - 24-PO-2717 Busway & Lighting - 24-PO-2816 UPS A & B 93PM - 24-PO-3205 Electric work for septic Project Manager North Texas Septic: Septic work Network Infrastructure - 23-PO-2310 Engineering Services - 24-PO-3203 Switch Infrastructure - 23-PO-2309 Pre -Wire Access Control - 24-PO-3364 BA Alarm - 24-PO-3210 BA Equipment - 24-PO-3603 AIDE - Willow Springs Construction Charges - 24-PO-3929 Potholing Willow Springs - Natural Gas Easement TARRANT 9-1-1 DISTRICT 1,233,943.00 465,745.37 768,197.63 Approved by the BOM RN 23-038 1,078,262.00 587,080.94 491,181.06 Approved by the BOM RN 24-007 73,508.10 73,508.10 - Approved by the BOM RN 24-011 46,784.00 46,784.00 Executive Director approved Emergency Purchase 18,000,000.00 18,000,000.00 Work in progress 6/20/2024 2,700,000.00 2,700,000.00 Target date 10/31/2024 602,655.00 574,855.00 27,800.00 Executive Director approved Emergency Purchase 296,204.00 69,500.00 226,704.00 Executive Director approved Emergency Purchase 674,613.00 674,613.00 - Executive Director approved Emergency Purchase 148,356.00 66,581.00 81,775.00 Executive Director approved Emergency Purchase 549,184.00 77,480.00 471,704.00 Executive Director approved Emergency Purchase 1,500.00 1,500.00 - 174,000.00 160,735.00 13,265.00 Approved by the BOM RN 23-031 10,550.00 10,550.00 - Executive Director approved Emergency Purchase 87,439.80 87,439.80 Executive Director approved Emergency Purchase 5,000.00 5,000.00 Executive Director approved Emergency Purchase 271,689.62 271,689.62 Executive Director approved Emergency Purchase 18,637.65 18,637.65 Executive Director approved Emergency Purchase 1,865.21 - 1,865.21 Executive Director approved Emergency Purchase 1,463.28 - 1,463.28 Executive Director approved Emergency Purchase 47,624.76 47,624.76 - Executive Director approved Emergency Purchase 2,520.00 2,520.00 - Executive Director approved Emergency Purchase Tarrant County 9-1-1 Emergency Assistance District 12600 Willow Springs - Budget .Building Committed Expenses: City of Fort Worth Flood Study 24-PO-3866 TARRANT 9-1-1 DISTRICT Total Unpaid Paid I Comments 2,170.00 2,170.00 Executive Director approved Emergency Purchase 26,027,969.42 I 23,941,844.24 I 2,086,125.18 N z[c��cWM 9A1