Page 179 - Colleyville FY19 Budget

COLLEYVILLE CRIME CONTROL DISTRICT
FY 2018 THROUGH FY 2023 PROJECTION
ADOPTED PROJECTED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED
FISCAL YEAR FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023
BEGINNING FUND BALANCE $1,438,234 $1,550,950 $1,325,041 $1,091,731 $1,088,593 $961,174 $1,133,111
REVENUES:
1/2 CENT SALES TAX REVENUE (+2% PROJECTED) $1,700,000 $1,711,496 $1,745,726 $1,780,640 $1,816,253 $1,852,578 $1,889,630
INTEREST INCOME $1,500 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
USE OF AVAILABLE CASH $444,643 $426,647 $436,950 $80,000 $200,000 $0 $0
TOTAL REVENUES $2,146,143 $2,146,143 $2,190,676 $1,868,640 $2,024,253 $1,860,578 $1,897,630

EXPENDITURES:
ADMINISTRATIVE BOARD/AUDIT EXPENSES: $1,850 $1,850 $1,850 $1,850 $1,850 $1,850 $1,850
POLICE SOFTWARE ANNUAL MAINTENANCE CONTRACT $49,500 $49,500 $49,500 $49,500 $49,500 $49,500 $49,500
RECRUITING AND HIRING PROCESS $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
CRIME SCENE RESPONSE UNIT $10,000 $10,000 $5,000 $5,000 $5,000 $5,000 $5,000
CRIME REPORTS ANALYTICAL CRIME MAPPING SOFTWARE $5,492 $5,492 $5,492 $5,492 $5,492 $5,492 $5,492
NETMOTION WIRELESS MAINTENANCE AGREEMENT $3,219 $3,219 $3,219 $3,219 $3,219 $3,219 $3,219
IN-CAR VIDEO SYSTEM SERVER MAINTENANCE $3,949 $3,949 $0 $0 $0 $0 $25,000
OFF-DUTY WEBSITE ANNUAL FEES/MAINTENANCE $0 $0 $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,000 $11,000 $11,325 $16,825 $11,450 $11,450 $16,825
PERSONNEL:
9 POLICE OFFICERS $841,350 $841,350 $883,418 $927,589 $973,968 $1,022,667 $1,073,800
MOVE OFFICER FROM GENERAL FUND FY 2019 $0 $0 $100,000 $105,000 $110,250 $115,763 $121,551
ADDITIONAL 2 PT PUBLIC SAFETY OFFICERS $0 $0 $46,432 $48,754 $51,191 $53,751 $56,438
ADDITIONAL SERGEANT IN FY 2020 $0 $0 $0 $100,000 $105,000 $110,250 $115,763
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
BALLISTIC TAC PLATE CARRIERS AND HELMETS $13,500 $13,500 $0 $0 $0 $0 $0
TWO RADAR SIGNS- LICENSES $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
IN CAR CAMERAS & SERVER $195,000 $195,000 $0 $0 $0 $0 $0
VEHICLES:
REPLACEMENT - PATROL VEHICLE AND EQUIPMENT $206,600 $206,600 $206,600 $206,600 $206,600 $206,600 $206,600
REPLACEMENT - MOTORCYCLE (TWO) $0 $0 $44,000 $0 $0 $0 $0
REPLACEMENT - ADMINISTRATIVE VEHICLES $27,000 $27,000 $0 $27,000 $27,000 $27,000 $27,000
NEW VEHICLE (FOR NEW SERGEANT) $0 $0 $0 $51,650 $0 $0 $0
DEBT SERVICE:
2006 SERIES REFUNDING DEBT $501,845 $501,845 $509,100 $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 $0 $0 $45,000 $0 $0 $0 $0
HVAC REPLACEMENT - JUSTICE CENTER $0 $0 $0 $0 $237,000 $0 $0
METAL ROOF COATING - JUSTICE CENTER $0 $0 $0 $167,200 $0 $0 $0
CARPET & VCT TILE REPLACEMENT - JUSTICE CENTER $0 $0 $0 $0 $88,052 $0 $0
TOTAL EXPENDITURES $1,945,405 $1,945,405 $1,987,036 $1,791,778 $1,951,672 $1,688,641 $1,784,137

EXCESS REVENUES OVER EXPENDITURES ^^ $200,738 $200,738 $203,640 $76,862 $72,581 $171,937 $113,492
ENDING FUND BALANCE $1,194,329 $1,325,041 $1,091,731 $1,088,593 $961,174 $1,133,111 $1,246,603
^^ MUST HAVE A 1.4 TIMES COVERAGE RATIO ($200,738) FOR DEBT SERVICE PAYMENT IN FY 2018
^^ MUST HAVE A 1.4 TIMES COVERAGE RATIO ($203,640) FOR DEBT SERVICE PAYMENT IN FY 2019

177