Page 206 - FY2020Colleyville

COLLEYVILLE CRIME CONTROL DISTRICT
FY 2019 THROUGH FY 2024 PROJECTION
ADOPTED PROJECTED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED
FISCAL YEAR FY 2019 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024
BEGINNING FUND BALANCE $1,325,041 $1,432,016 $1,198,706 $834,495 $802,075 $726,727 $606,704
REVENUES:
1/2 CENT SALES TAX REVENUE (+1-2.5% PROJECTED) $1,745,726 $1,745,726 $1,763,183 $1,798,447 $1,843,408 $1,889,493 $1,936,731
INTEREST INCOME $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
USE OF AVAILABLE CASH $436,950 $436,950 $370,000 $100,000 $150,000 $150,000 $120,000
TOTAL REVENUES $2,190,676 $2,190,676 $2,141,183 $1,906,447 $2,001,408 $2,047,493 $2,064,731
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 $0 $0 $5,500 $5,500 $5,500 $5,500 $5,500
SOFTWARE - INVESTIGATIVE TOOL $0 $0 $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 $17,500 $2,500 $2,500 $2,500 $2,500 $2,500
TRAINING - LEADERSHIP DEVELOPMENT $0 $5,000 $10,000 $10,000 $10,000 $10,000 $10,000
TRAINING - DE-ESCALATION & CRISIS INTERVENTION $0 $0 $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 $11,325 $11,325 $16,825 $11,450 $11,450 $16,825 $16,825
PERSONNEL:
9 POLICE OFFICERS $883,418 $883,418 $918,755 $955,505 $993,725 $1,033,474 $1,074,813
MOVE OFFICER FROM GENERAL FUND FY 2019 $100,000 $100,000 $105,000 $110,250 $115,763 $121,551 $127,628
ADDITIONAL 2 PT PUBLIC SAFETY OFFICERS $46,432 $46,432 $48,754 $51,191 $53,751 $56,438 $59,260
MOVE OFFICER FROM GENERAL FUND FY 2020 $0 $0 $105,000 $110,250 $115,763 $121,551 $127,628
ADDITIONAL SERGEANT IN FY 2020 $0 $0 $100,000 $105,000 $110,250 $115,763 $121,551
PT ACCREDITATION COORDINATOR $0 $0 $27,000 $27,810 $28,644 $29,504 $30,389
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 $250,600 $250,600 $262,650 $291,000 $321,000 $321,000 $271,000
DEBT SERVICE:
2006 SERIES REFUNDING DEBT $509,100 $509,100 $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 -
JUSTICE CENTER DUMPSTER ENCLOSURES $45,000 $25,000 $0 $0 $0 $0 $0
REPLACE CAD/RMS SYSTEM $0 $0 $375,000 $0 $0 $0 $0
HVAC REPLACEMENT - JUSTICE CENTER (moved- General Capital $300k) $0 $0 $0 $0 $0 $0 $0
$0
METAL ROOF COATING - JUSTICE CENTER (moved- General Capital $246K or $476 full replacement)$0 $0 $0 $0 $0 $0
CARPET & VCT TILE REPLACEMENT - JUSTICE CENTER (moved- General Capital $99k) $0 $0 $0 $0 $0 $0
$0
TOTAL EXPENDITURES $1,987,036 $1,987,036 $2,135,394 $1,838,867 $1,926,756 $2,017,516 $2,030,505
EXCESS REVENUES OVER EXPENDITURES ^^ $203,640 $203,640 $5,789 $67,580 $74,652 $29,977 $34,226
ENDING FUND BALANCE $1,091,731 $1,198,706 $834,495 $802,075 $726,727 $606,704 $520,930
^^ MUST HAVE A 1.4 TIMES COVERAGE RATIO ($203,640) FOR DEBT SERVICE PAYMENT IN FY 2019

204