Page 210 - Colleyville FY21 Budget

COLLEYVILLE CRIME CONTROL DISTRICT
FY 2020 THROUGH FY 2025 PROJECTION
ADOPTED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
FISCAL YEAR FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025
BEGINNING FUND BALANCE $1,298,863 $1,298,863 $1,420,796 $1,030,222 $1,121,525 $1,164,598 $1,157,854
REVENUES:
1/2 CENT SALES TAX REVENUE (+0-1.5% PROJECTED) $1,763,183 $1,763,183 $1,900,000 $1,900,000 $1,928,500 $1,957,428 $1,957,428
INTEREST INCOME $8,000 $8,000 $8,000 $8,080 $8,161 $8,242 $8,325
USE OF AVAILABLE CASH $375,000 $0 $550,000 $0 $0 $0 $0
TOTAL REVENUES $2,146,183 $1,771,183 $2,458,000 $1,908,080 $1,936,661 $1,965,670 $1,965,753
EXPENDITURES:
ADMINISTRATIVE BOARD/AUDIT EXPENSES: $1,850 $1,850 $1,850 $1,850 $1,850 $1,850 $1,850
SOFTWARE - ANNUAL MAINTENANCE CONTRACT $49,500 $49,500 $49,500 $49,500 $49,500 $49,500 $49,500
SOFTWARE - EARLY WARNING/INTERNAL AFFAIRS $5,500 $5,500 $5,949 $5,949 $5,949 $5,949 $5,949
SOFTWARE - INVESTIGATIVE TOOL $9,750 $9,750 $9,750 $9,750 $9,750 $9,750 $9,750
SOFTWARE - CRIME REPORTS ANALYTICAL CRIME MAPPING $5,492 $5,492 $5,492 $5,492 $5,492 $5,492 $5,492
RECRUITING AND HIRING PROCESS $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
TRAINING - LEADERSHIP DEVELOPMENT $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
TRAINING - DE-ESCALATION & CRISIS INTERVENTION $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
CRIME SCENE RESPONSE UNIT $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
NETMOTION WIRELESS MAINTENANCE AGREEMENT $3,219 $3,219 $3,219 $3,219 $3,219 $3,219 $3,219
IN-CAR VIDEO SYSTEM SERVER MAINTENANCE $0 $0 $0 $0 $0 $25,000 $25,000
OFF-DUTY WEBSITE ANNUAL FEES/MAINTENANCE $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
TICKET WRITER REPLACEMENT $4,700 $4,700 $4,700 $4,700 $4,700 $4,700 $4,700
CALEA ACCREDITATION $16,825 $16,825 $16,825 $11,450 $11,450 $16,825 $16,825
PERSONNEL:
12 POLICE OFFICERS $918,755 $1,193,514 $1,292,239 $1,337,467 $1,384,279 $1,432,728 $1,482,874
MOVE OFFICER FROM GENERAL FUND FY 2019 $105,000 $0 $0 $0 $0
ADDITIONAL 2 PT PUBLIC SAFETY OFFICERS $48,754 $0 $0 $0 $0
MOVE OFFICER FROM GENERAL FUND FY 2020 $105,000 $0 $0 $0 $0
ADDITIONAL SERGEANT IN FY 2020 $100,000 $0 $0 $0 $0
PT ACCREDITATION COORDINATOR $27,000 $0 $0 $0 $0
TEEN COURT $33,750 $33,750 $33,750 $33,750 $33,750 $33,750 $33,750
EQUIPMENT:
ANNUAL WEAPONS REPLACEMENT $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
SWAT EQUIPMENT AND TRAINING $6,150 $6,150 $6,150 $6,150 $6,150 $6,150 $6,150
SAFETY EQUIPMENT AND REPLACEMENT $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
TWO RADAR SIGNS- LICENSES $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
VEHICLES:
ANNUAL REPLACEMENT FUNDING $262,500 $262,500 $262,650 $291,000 $321,000 $321,000 $271,000
DEBT SERVICE:
2006 SERIES REFUNDING DEBT $0 $0 $0 $0 $0 $0 $0
TRANSFERS:
CAPITAL EQUIPMENT REPLACEMENT FUND -
IN-CAR MOBILE DIGITAL COMPUTER SYSTEM $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
CAPITAL -
REPLACE CAD/RMS SYSTEM $375,000 $0 $550,000 $0 $0 $0 $0
TOTAL EXPENDITURES $2,135,244 $1,649,250 $2,298,574 $1,816,777 $1,893,589 $1,972,413 $1,972,559
EXCESS REVENUES OVER EXPENDITURES ^^ $10,939 $121,933 $159,426 $91,303 $43,073 -$6,744 -$6,806
ENDING FUND BALANCE $934,802 $1,420,796 $1,030,222 $1,121,525 $1,164,598 $1,157,854 $1,151,048
^^ MUST HAVE A 1.4 TIMES COVERAGE RATIO ($203,640) FOR DEBT SERVICE PAYMENT IN FY 2019

208