City of Roseville
<br />Water Vehicle & Equipment Fund (610)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: current$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Tax Levy: Add/Sub--------------------
<br />Fees, Licenses, & Permits1,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,178,9601,1
<br />78,960
<br />Sale of Assets--------------------
<br />Interest Earnings5,794--1,6084,5196,88910,10613,88717,00419,82318,94918,90718,76417,67919,61219,98317,3625,0886,429-
<br />Revenues$1,184,754$1,178,960$1,178,960$1,180,568$1,183,479$1,185,849$1,189,066$1,192,847$1,195,964$1,198,783$1,197,909$1,197,867$1,197,724$1,196,639$1,198,572$1,198,943$1,196,322$1,184,048$1,185,389$
<br />1,178,960$23,801,603
<br />Vehicles$-$30,000$60,000$35,000$60,000$25,000$-$-$-$30,000$-$40,000$60,000$-$80,000$90,000$-$-$60,000$-
<br />Equipment75,0005,00082,000-5,000--37,00055,000112,50050,00065,00092,000---10,00017,000110,000-
<br />Furniture & Fixtures
<br />Buildings1,600,000---------50,000----140,000700,000-700,00030,000
<br />Improvements500,000700,000700,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,000
<br />
<br />Expenditures$2,175,000$735,000$842,000$1,035,000$1,065,000$1,025,000$1,000,000$1,037,000$1,055,000$1,242,500$1,200,000$1,205,000$1,252,000$1,100,000$1,180,000$1,330,000$1,810,000$1,117,000$1,970,000$
<br />1,130,000$24,505,500
<br />Beginning Cash Balance$289,714$(700,532)$(256,572)$80,388$225,956$344,435$505,284$694,350$850,197$991,160$947,444$945,353$938,220$883,944$980,583$999,155$868,098$254,420$321,468$(463,143)
<br />
<br />Annual Surplus (deficit)(990,246)443,960336,960145,568118,479160,849189,066155,847140,964(43,717)(2,091)(7,133)(54,276)96,63918,572(131,057)(613,678)67,048(784,611)48,960
<br />Cash Balance$(700,532)$(256,572)$80,388$225,956$344,435$505,284$694,350$850,197$991,160$947,444$945,353$938,220$883,944$980,583$999,155$868,098$254,420$321,468$(463,143)$(414,183)
<br />5-Year Funding Status106%10-Year Funding Status108%Long-Term Funding Status98%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$6,196,43510-Year Funding Sources (Rev + Beg Cash Balance)##########Long-Term Funding Sources (Rev + Beg Cash Balance)$24,091,317
<br />Cash Balance (Year-End) *$995,0002016
<br />Water Vehicle & Equipment Fund
<br />Less Amt Needed for Operations **(629,645)2016
<br />Planned CIP Surplus/Deficit(75,641)2017
<br /> $2,500,000
<br />Adjust for Delayed CIP Items-2017
<br /> $2,000,000
<br />Cash Balance (Beg. Year)$289,7142018
<br /> $1,500,000
<br />Adopted Budget (Excl.Capital, Dep$6,296,4502017
<br /> $1,000,000
<br />* Current Assets - Current Liabilities
<br /> $500,000
<br />** 10% of Annual Budget Needed for Cash-Flow Purposes
<br /> $-
<br />2018202120242027203020332036
<br /> $(500,000)
<br /> $(1,000,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />V#207 Pickup$-$-$-$35,000$-$-$-$-$-$-$-$-$-$-$-$35,000$-$-$-$-$70,000
<br />V#208 Meter van--30,000-----------30,000-----60,000
<br />V#210 4x4 pickup------------30,000-------30,000
<br />V#211 360 Backhoe (3-way split)----60,000-------------60,000-120,000
<br />V#214 Ford Transit - Locate Vehicle-----25,000---------25,000----50,000
<br />V#230 Ford 1/2-ton---------30,000----------30,000
<br />V#234 4x4 Pickup-30,000----------30,000-------60,000
<br />V#225 Mini Backhoe (1/3) Water, Sa -----------40,000--50,000-----90,000
<br />V#213 Water Utility Mobile Worksho --30,000------------30,000----60,000
<br />EWater AMR meter system replacem-------50,00050,00050,00050,000------100,000-300,000
<br />EReplace/Upgrade SCADA system (--75,000----20,000----10,000----10,000--115,000
<br />EGPS Unit (1/3 share)--7,000----7,000---7,000---7,000--28,000
<br />EField Computer Replacement/add5,000---5,000---5,000---5,000---5,000---25,000
<br />EReplace Air Compressor-------10,000----------10,000-20,000
<br />ESand Bucket 24"x36" for #211---------5,000----------5,000
<br />E#236 Trailer-5,000--------------5,000---10,000
<br />E#237 Wacker Compacter--------50,000----------50,000
<br />E Electronic message board-attenuato---------7,500----------7,500
<br />ECompactor for #211 360 Backhoe (-----------15,000--------15,000
<br />EValve Operator and Vac70,000-----------70,000-------140,000
<br />EReplace Trench Box--------------------
<br />BElevated storage tank repainting----------------700,000-700,000-1,400,000
<br />BBooster Station Rehabilitation1,600,000---------50,000----140,000---30,0001,820,000
<br />BReplace Water Tower Fence---------------------
<br />IWater main replacement500,000700,000700,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,0001,100,00020
<br />,000,000
<br />---------------------
<br />$2,175,000$735,000$842,000$1,035,000$1,065,000$1,025,000$1,000,000$1,037,000$1,055,000$1,242,500$1,200,000$1,205,000$1,252,000$1,100,000$1,180,000$1,330,000$1,810,000$1,117,000$1,970,000$1,130,000$24
<br />,505,500
<br />
<br />
|