The URL can be used to link to this page

Home My WebLink AboutColleyville Crime Control and Prevention District (CCCPD )-Agenda Packets-5/31/2012~'~ ~~ City of Colleyville City Hall COLLEY'~JILLE Colleyville Crime Control and 100 Main Street Colleyville, Texas 76034 f r k,~ ~ Prevention District Board 817. 503.1000 Agenda WWW•colleyville.com Thursday, May 31, 2012 Executive Conference Room, 3rd Floor 5:00 p.m. 1. CALL TO ORDER 2. PRESENTATION AND DISCUSSION 2a Colleyville Crime Control and Prevention District (CCCPD) Fiscal Year 2012 (FY 2012) budget update 2b Presentation and discussion of the Colleyville Crime Control and Prevention District (CCCPD) Fiscal Year 2013 (FY 2013) budget 3. ADJOURNMENT I hereby certify this agenda was posted on City Hall bulletin boards by Friday, May 25, 2012, by 5:00 p.m. Cynthia Singleton, TRMC, CMC City Secretary Any matter on this agenda may, at the discretion of the governing body, be opened for public comment and discussion. If you plan to attend this public meeting and have a disability that requires special accommodations, please advise the City Secretary at least 48 hours in advance at 817.503.1133, and reasonable accommodations will be made to assist you. ~'~Y~;~ City of Colleyville CityHall CC}LLEYVILLE Colleyville Crime Control 100 Main Street Colleyville, Texas 76034 and Prevention District www.colleyville.com ~'F { AS Board Agenda Briefing Agenda Number za Agenda Date 05/31/2012 Number za Type Presentation and Discussion Department City Manager Title Colleyville Crime Control and Prevention District (CCCPD) Fiscal Year 2012 (FY 2012) budget update Explanation This briefing provides an update on the current FY 2012 CCCPD budget. A summary of the FY 2012 CCCPD adopted budget is as follows: Beginning Fund Balance Total Budgeted Revenues (includes draw down of available cash of $279,846) Total Budgeted Expenditures Estimated Excess Revenues Over Expenditures* Estimated Ending Fund Balance $ 846,681 $1,282,386 $1,080,302 $ 202,084 $ 768,919 * Must have a 1.4 times coverage ratio ($202,084) for Debt Service payment. Attached is a comparison of the FY 2012 adopted budget versus the FY 2012 revised projection. The FY 2012 beginning fund balance was higher than anticipated, due to the higher than anticipated sales tax revenues received in four of the last five months of FY 2011. Midway through the 2012 fiscal year, sales tax revenues have totaled $594,053, which is 10.7% above sales tax revenues received during the same time period in FY 2011. It is projected that sales tax revenues will be $100,000 greater than the adopted budget of $1,000,000 at the end of the fiscal year, due to increased sales tax receipts. Due to the continued lower than anticipated interest rates, income on investments is projected to be $540 lower than the adopted budget of $2,540. Additionally, the annual CCCPD budget incorporates the use of available cash within the fund balance, which is the utilization of the prior year's 1.40 coverage ratio for bonded debt. In most fiscal years, this annual addition to available cash within the fund balance is over $200,000. With net anticipated increased revenues totaling slightly less than $100,000, it is projected that the ending fund balance at September 30, 2012 will be $953,023. CCCPD Board Agenda Briefing 2a Attachments 1. CCCPD FY 2012 adopted budget versus FY 2012 revised projection COLLEYVILLE CRIME CONTROL DISTRICT FY 2012 ADOPTED BUDGET VERSUS FY 2012 REVISED PROJECTION ADOPTED PROJECTED FISCAL YEAR FY 2012 FY 2012 BEGINNING FUND BALANCE $846,681 $931,325 REVENUES: 1/2 CENTSALES TAX REVENUE $1,000,000 $1,100,000 INTEREST INCOME $2,540 $2,000 USE OF AVAILABLE CASH $279,846 $180.386 TOTAL REVENUES $1,282,386 $1,282,386 EXPENDITURES: ADMINISTRATIVE BOARD/AUDIT EXPENSES: $1,850 $1,850 POLICE SOFTWARE ANNUAL MAINTENANCE CONTRACT $45,000 $45,000 REGIONAL RECRUITWG AND HIRING PROCESS (PACT TEST) $2,000 $2,000 CRIME REPORTS CRIME MAPPING SOFTWARE $1,200 $1.200 NETMOTION WIRELESS MAINTENANCE AGREEMENT $3,219 $3,219 TLETS SECURITY UPGRADE FOR NETMOTION $2,000 $2,000 PERSONNEL: POLICE OFFICERS: 4 OFFICERS $328,937 $328.937 TEEN COURT $33,750 $33,750 CAPITAL - VEHICLES: REPLACEMENT - PATROL VEHICLE AND EQUIPMENT $39.500 $39,500 REPLACEMENT - CID VEHICLE $18,405 $18,405 EQUIPMENT: REPLACEMENT - HAND HELD RADIOS (3 IN FY 2012) $12,000 $12,000 REPLACEMENT- THREE (3) IN-CAR VIDEO SYSTEMS $21,180 $21,180 CRIME PREVENTION BAR CODING EQUIPMENT $1,900 $1,900 EQUIPMENT FOR WOMEN'S SELF-DEFENSE CLASSES $7,500 $7,500 LICENSE PLATE READER $22,650 $22,650 REPLACEMENT - L3 1N-CAR VIDEO SERVER $18,000 $18.000 DEBT SERVICE: 2006 SERIES REFUNDING DEBT $505,211 $505,211 TRANSFERS: CAPITAL EQUIPMENT REPLACEMENT FUND - IN-CAR MOBILE DIGITAL COMPUTER SYSTEM $16,000 $16,000 TOTAL EXPENDITURES $1,080,302 $1.080,302 EXCESS REVENUES OVER EXPENDITURES $202,084 `x $202,084 "` ENDING FUND BALANCE $768,919 $953,023 "MUST HAVE A 1.4 TIMES COVERAGE RATIO ($202,084) FOR DEBT SERVICE PAYMENT IN FY 2012 ~'~Y~;~ City of Colleyville CityHall CC}LLEYVILLE Colleyville Crime Control 100 Main Street Colleyville, Texas 76034 and Prevention District www.colleyville.com ~'F { AS Board Agenda Briefing Agenda Number 2b Agenda Date 05/31/2012 Number 2b Type Presentation and Discussion Department Police Title Presentation and discussion of the Colleyville Crime Control and Prevention District (CCCPD) Fiscal Year 2013 (FY 2013) budget Explanation In accordance with the Local Government Code, the Colleyville Crime Control and Prevention District (CCCPD) Board, which is comprised of the City Council, must approve an annual budget at least 100 days before the start of the fiscal year. In order to comply with this requirement, a meeting will be held on Tuesday, June 19, 2012 for the Board to approve the proposed FY 2013 CCCPD Budget. Staff has proposed the following FY 2013 budget for review and discussi on, and is seeking direction on the proposed expenditures prior to the meeting for the adoption of the proposed FY 2013 budget. Estimated Beginning Fund Balance for FY 2013 Revenues: '/z Cent Sales Tax Interest Income Use of Available Cash TOTAL REVENUES Expenditures: Administrative Board/Audit Expenses Police Records Management System Annual Contract Regional Recruiting and Hiring Process (PACT Test) Crime Reports Crime Mapping Software Crime Reports Analytical Crime Mapping Software NetMotion Wireless Maintenance Agreement Maintenance $ 953,023 $1,135,000 $ 2,000 $ 172,254 $1,309,254 $ 1,850 $ 45,000 $ 2,000 $ 1,200 $ 4,000 $ 3,219 CCCPD Board Agenda Briefing 2b Personnel: Five (5) Police Officer Positions Metroport Teen Court Capital: Vehicles: Replacement - 2 vehicles including in-car video system Debt Service: 2006 Series Refunding Debt Transfers: Capital Equipment Replacement Fund - In-Car Mobile Digital Computer System TOTAL EXPENDITURES - **EXCESS REVENUES OVER EXPENDITURES - ENDING FUND BALANCE - ~ ~ $ 404,641 ~ $ ~ 33,750 ~ $ 89,300 ~ ~ ~ $ ~ 505,924 ~ I $ 16,000 I ~ $1,106,884 ~ ~ $ 202,370 ~ ~ $ 983,139 ~ **Must have a 1.4 times coverage ratio ($202,370) for debt service payment in FY 2013. Attachments 1. Colleyville Crime Control and Prevention District FY 2013 Proposed Budget COLLEYVILLE CRIME CONTROL DISTRICT FY 2013 PROPOSED BUDGET ADOPTED PROJECTED PROPOSED FISCAL YEAR FY 2012 FY 2012 FY 2013 BEGINNING FUND BA~ANCE $846,681 $931,325 $953,023 REVENUES: 1/2 CENT SALES TAX REVENUE $1,000,000 $1,100,000 $1,135,000 INTEREST INCOME $2,540 $2,000 $2,000 USE OF AVAILABLE CASH $279,846 $180,386 $226,690 TOTAL REVENUES $1,282,386 $1,282,386 $1,363,690 EXPENDITURES: ADMINISTRATIVE BOARD/AUDIT EXPENSES: $1,650 $1,850 $1,850 POLICE SOFTWARE ANNUAL MAINTENANCE CONTRACT $45,000 $45,000 $45,000 REGIONAL RECRUITING AND HIRING PROCESS (PACT TEST) $2,000 $2,000 $2,000 CRIME REPORTS CRIME MAPPING SOFTWARE $1,200 $1,200 $1,200 CRIME REPORTS ANALYTICAL CRIME MAPPING SOFTWARE $0 $0 $4,000 NETMOTION WIRELESS MAINTENANCE AGREEMENT $3,219 $3,219 $3,219 TLETS SECURITY UPGRADE FOR NETMOTION $2,000 $2,000 $0 L-3 IN-CAR VIDEO SYSTEM SERVER MA~NTENANCE $0 $0 $3,768 PERSONNEL: POLICE OFFICERS: 4 OFFICERS $328,937 $326,937 $404,641 TEEN COURT $33,750 $33,750 $33,750 CAPlTAL - VEHICLES: REPLACEMENT - PATROL VEHICLE AND EQUIPMENT $39,500 $39,500 $103,300 (FY 2012 - 1 VEHICLE) (FY 2013 - 2 VEHICLES INCLUDING IN-CAR VIDEO SYSTEM) REPLACEMENT-CIDVEHICLE $18,405 $18,405 $0 EQUIPMENT: REPLACEMENT - HAND HELD RADIOS (3 IN FY 2012) $12,000 $12,000 $0 CRIME PREVENTION BAR CODING EQUIPMENT $1,900 $1,900 $0 EQUIPMENT FOR WOMEN'S SELF-DEFENSE CLASSES $7,500 $7,500 $0 LICENSE PLATE READER $22,650 $22,650 $0 REPIACEMENT - L3 IN-CAR VIDEO SERVER $18,000 $18,000 $0 CONDUCTED ENERGY DEVICE (TASER) EQUIPMENT $0 $0 $36,668 DEBT SERVICE: 2006 SERIES REFUNDING DEBT $505,211 ` $505,2~ 1 $505,924 TRANSFERS: CAPITAL EQUIPMENT REPLACEMENT FUND - IN-CAR MOBILE DIGITAL COMPUTER SYSTEM $16,000 $16,000 $16,000 TOTAL EXPENDITURES $1,080,302 $1,080,302 $1,161,320 EXCESS REVENUES OVER EXPENDITURES $202,064 ' $202,084 ' $202,370 " ENDING FUND BALANCE _ $768,919 $953,023 $928,703 ` MUST HAVE A 1.4 TIMES COVERAGE RATIO ($202,084) FOR DEBT SERVICE PAYMENT IN FY 2012 " MUST HAVE A 1.4 TIMES COVERAGE RATIO ($202,370) FOR DEBT SERVICE PAYMENT IN FY 2013 Campare data by date, area, crime type, and day/time of uvee~C with four powerfe~l graphs. Each graph can drill-down, allowing you to move frc~m high-level trends to incid~nt-level data. Multiple-view Dashboard Pawerrnap cvmparisons {mprove your intelligence-led policing efforts by comparing crime s~atistics in a side-by-side map that you can customize by crime types, areas, and date ranges. Crime tr~nd mapp~ng ~valuate policy changes, beat assignments, and overall crime trer~ds with a heat map that highlights areas where crime is on t1~e risE and decfine. ~ .~~~.~.~-° ~ ~..~ ~~ .. __ ~~ ~~P ~~ , ~ ,.2.,~.m.= _._ . . .__ .- - ~ ~~ ~~. _ ~ - y~i ~•=s.{..-y~+~, :. _~,a . ., . .,_ ___ ,~,Q 13=~J!'C ~ 0.~~ _ . . _ _ . . . ~ - ~~ _ ~ ._.o -- ---_-~~ ~. ._ ~ -- -~ ._ r ~ ~ ''°'~ ~ ~+ - -: .~- - :,~ _ .~ ~ - ~. --~ _ _ _ ~ --- ~. m: „~, ~? ,;~ ~~,: _~ - , ._ ~: _ ~ ~~ ~-~~, - .._ _ . . _ r_ _, ~~ _ wr~i, ~ _ _ #,:_ ,.~, . ~ `~ ~. ~r:~ - -~ ~ ; - -_- >_ ` ° - ~: ~ ~,,a - "~ , E-'"•~ra ~ ~ ~ - ~ &~ .~. ~. ~ -- ---- ~,.r , ____ ~ .~ ~ .~..° _ _ ~ ,~~, ,~ ~, ~. _ --' _ ~., ~ e ~: _ ~ F .,_ -- - ~ I~ ~ ~r^ "~~.e_ Y e~~~~..,.~ - ~ ~ ~ L~ " , ~ ~ ~, _•: -s.~oe ~-. ~~: ,~ . '. - ~ ~ ' - ~ _ - _ ii~..o`.:,: ,l;.i~ i's5i .~ . -_.. ` ~ ~ _5g:~~ .~ ~ ~ ^ '!~-,W. ~ : . : ~ "- ... IEti_Ff,~ G ~ _--.t ' '- ~ .. _' ts'd _ d^'_:~:. u.y , . . .. .y~~ ~ ' .. -~ ~i d;;~u ~;s.F; . . ,, -~~. • s -d i ~'~ - .- -_ ~ .~e.~.-.. _._.e ~ .. .~.. `_ . r _ --° _. '.-. ~ s-1' .. '- ~ --~~ai-~ - ~ ~ . ..__. ..... v -... ~:-- ` ' _ ' ' ~~~ ~_ . ~.~..~ _ , ~ '_r _ - . . '..~ G~ Ea. ~ - - 99~.. ~~~-~S:z-''"~ .- ° i `-- . --_ _ _-^. ~ ! ~ ~..~ ~ A ~_ _ n ~~- 1 ~ ~ -~-~ - P ~.~~ tY~s ;~ - ,~' -° ~, ;~'a ~°'' ~' ~? -- ~-.~ ._-. ~ - %-°-~ ~ ~`~ ~ ,~ `~~- ~ - ~ ~~ -1 ^ ~ ° ..~ - _ ~-.:-#- ~.' .~. ~ , e ~ ~-r^,~'~ ' ~ ~~a , ~ ~ ~:- ~ :a - _ - ~ ~ --..~a~ -~~3 ~. ~~~ hcr - iyJ1 ~ o:.ll~ . G°qli' ~''~~ ~ ~.~' - ~ = ~ ~d .=-i:3 . : ~ - -_ _ _. , c ~ '~~~ z~ $~ ~- ~}~ ._.,.~`_~- ~M -'4~~: . -~•.. L r'~~•` - ~ ~. ~ '~' .ly, .s .~, ,~, •~+ '- li~ ~= --.-s: t.s c~~~ ~y,~r _ . `=~._ r.-.~ Roll call and crime detail m~p Wherever they are, every officer becomes an analyst with this snapshot af crime. Set the dat~ range, click ac~ incident marker and s~e ~rime detail in the list ~iew.