|
City of Roseville
<br />Police Vehicle & Equipment Fund (400)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000$300,000
<br />Tax Levy: Add/Sub--------------------
<br />Other: K-9 Donation10,000-------------------
<br />Sale of Assets24,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,000
<br />Interest Earnings8,5139,27410,3806,8627,2197,4786,6797,2744,7875,1195,2826,2525,8282,5092,4542,2502,9913,7751731,142
<br />Revenues$342,513$333,274$334,380$330,862$331,219$331,478$330,679$331,274$328,787$329,119$329,282$330,252$329,828$326,509$326,454$326,250$326,991$327,775$324,173$325,142$6,596,243
<br />Vehicles$200,855$209,105$283,415$224,555$216,305$258,505$200,855$231,765$234,805$219,605$200,855$258,505$238,965$224,555$250,255$209,105$211,355$265,715$200,855$209,105
<br />Equipment95,17066,305222,75576,86091,485110,82091,170221,76568,63587,70071,53590,375248,380102,63080,22568,50067,535240,06561,815127,720
<br />Furniture & Fixtures8,4002,6004,10011,60010,4602,1008,9002,1008,73513,6608,4002,6008,4002,1006,16011,6008,9002,10013,0354,160
<br />Buildings--------------------
<br />Improvements--------------------
<br />Expenditures$304,425$278,010$510,270$313,015$318,250$371,425$300,925$455,630$312,175$320,965$280,790$351,480$495,745$329,285$336,640$289,205$287,790$507,880$275,705$340,985$6,980,595
<br />
<br />Beginning Cash Balance$425,629$463,717$518,981$343,091$360,937$373,906$333,959$363,713$239,358$255,970$264,124$312,617$291,389$125,472$122,696$112,510$149,555$188,756$8,652$57,120
<br />Annual Surplus (deficit)38,08855,264(175,890)17,84712,969(39,947)29,754(124,356)16,6128,15448,492(21,228)(165,917)(2,776)(10,186)37,04539,201(180,105)48,468(15,843)
<br />Cash Balance$463,717$518,981$343,091$360,937$373,906$333,959$363,713$239,358$255,970$264,124$312,617$291,389$125,472$122,696$112,510$149,555$188,756$8,652$57,120$41,277
<br />5-Year Funding Status122%10-Year Funding Status108%Long-Term Funding Status101%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$2,097,87610-Year Funding Sources (Rev + Beg Cash Balance)$3,749,214Long-Term Funding Sources (Rev + Beg Cash Balance)$7,021,872
<br />Cash Balance (Year-End)$459,0002016
<br />Police Vehicle & Equipment Fund
<br />Planned CIP Surplus/Deficit(33,371)2017
<br />Adjust for Delayed CIP Items-2017
<br /> $600,000
<br />Cash Balance (Beg. Year)$425,6292018
<br /> $500,000
<br /> $400,000
<br /> $300,000
<br /> $200,000
<br /> $100,000
<br /> $-
<br />2018202120242027203020332036
<br />RevenuesExpendituresCash Balance
<br />$10K Donation (see above)
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />VMarked squad cars (5 / yr)$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$165,000$3,300,000
<br />
<br />VUnmarked vehicles (1 / yr)24,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,00024,000480,000
<br />VCSO Vehicle--33,950--33,950--33,950--33,950--33,950--33,950--203,700
<br />VCommunity relations vehicle - new--22,660----22,660----22,660----22,660--90,640
<br />VSquad conversion--15,45015,45015,45015,450-----15,45015,45015,45015,450-----123,600
<br />VPark Patrol vehicle--10,500------10,500------10,500---31,500
<br />VRadar Units4,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,1204,12082,400
<br />VStop Sticks1,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,0301,03020,600
<br />VRear Transport Seats2,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,7052,70554,100
<br />VControl Boxes4,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,00080,000
<br />VVisabars-8,250-8,250-8,250-8,250-8,250-8,250-8,250-8,250-8,250-8,25082,500
<br />EComputer Equipment8,8007,4007,4008,8007,4007,4008,8007,4007,4008,8007,4007,4008,8007,4007,4008,8007,4007,4008,8007,400157,800
<br />EComputer replacements for fleet--150,000----150,000----150,000----150,000--600,000
<br />ECell phones/computer devices--5,645--5,645--5,645--5,645--5,645--5,645--33,870
<br />EPrinter replacements for fleet--7,2107,210---7,2107,210---7,2107,210---7,2107,210-57,680
<br />ESpeed notification unit----6,000----6,000---6,000----6,00024,000
<br />EGPS Devices---5,150----5,150----5,150----5,150-20,600
<br />ENew K-9-16,000-16,000---16,000-16,000-16,000---16,000-16,000-16,000128,000
<br />ENon-lethal weapons1,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,60032,000
<br />ELong guns replacement----11,33011,330----11,33011,330----11,33011,330--67,980
<br />ELong gun parts (squads)3,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,0903,09061,800
<br />ESidearms (officers)--9,270--------9,270--------18,540
<br />ESidearm parts (officers)2,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,0602,06041,200
<br />ETactical gear5,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,1505,150103,000
<br />
<br />
|