City of Roseville
<br />Sewer Vehicle & Equipment Fund (600)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: current$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-
<br />Tax Levy: Add/Sub--------------------
<br />Fees, Licenses, & Permits1,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,329,6401,3
<br />29,640
<br />Sale of Assets--------------------
<br />Interest Earnings8,8743,144------------2,0248,65714,62321,50828,23133,408
<br />Revenues$1,338,514$1,332,784$1,329,640$1,329,640$1,329,640$1,329,640$1,329,640$1,329,640$1,329,640$1,329,640$1,329,640$1,329,640$1,329,640$1,329,640$1,331,664$1,338,297$1,344,263$1,351,148$1,357,871$
<br />1,363,048$26,713,269
<br />Vehicles$40,000$60,000$-$85,000$-$60,000$-$-$-$30,000$400,000$40,000$-$35,000$-$40,000$-$-$95,000$100,000
<br />Equipment75,00090,0005,0004,00075,000--25,0004,00017,500-15,00085,0004,000---15,0004,0007,500
<br />Furniture & Fixtures--------------------
<br />Buildings410,000590,000535,000360,000435,000295,000245,000235,000315,000-----------
<br />Improvements1,100,0001,100,0001,100,0001,100,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,0001,000,000
<br />
<br />Expenditures$1,625,000$1,840,000$1,640,000$1,549,000$1,510,000$1,355,000$1,245,000$1,260,000$1,319,000$1,047,500$1,400,000$1,055,000$1,085,000$1,039,000$1,000,000$1,040,000$1,000,000$1,015,000$1,099,
<br />000$1,107,500$25,231,000
<br />Beginning Cash Balance$443,701$157,215$(350,001)$(660,361)$(879,721)##############################$(931,161)$(920,521)$(638,381)$(708,741)$(434,101)$(189,461)$101,179$432,843$731,140$1,075,403$1,411,
<br />551$1,670,422
<br />Annual Surplus (deficit)(286,486)(507,216)(310,360)(219,360)(180,360)(25,360)84,64069,64010,640282,140(70,360)274,640244,640290,640331,664298,297344,263336,148258,871255,548
<br />Cash Balance$157,215$(350,001)$(660,361)$(879,721)##############################$(931,161)$(920,521)$(638,381)$(708,741)$(434,101)$(189,461)$101,179$432,843$731,140$1,075,403$1,411,551$1,670,422$1,92
<br />5,970
<br />5-Year Funding Status87%10-Year Funding Status96%Long-Term Funding Status108%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$7,103,91910-Year Funding Sources (Rev + Beg Cash Balance)#########Long-Term Funding Sources (Rev + Beg Cash Balance)##########
<br />Cash Balance (Year-End) *$977,0002016
<br />Sewer Vehicle & Equipment Fund
<br />Less Amt Needed for Operations **(404,905)2016
<br />Planned CIP Surplus/Deficit(128,394)2017
<br /> $2,500,000
<br />Adjust for Delayed CIP Items-2017
<br /> $2,000,000
<br />Cash Balance (Beg. Year)$443,7012018
<br /> $1,500,000
<br />Adopted Budget (Excl.Capital, Dep$4,049,0502017
<br /> $1,000,000
<br /> $500,000
<br />* Current Assets - Current Liabilities
<br />** 10% of Annual Budget Needed for Cash-Flow Purposes
<br /> $-
<br />2018202120242027203020332036
<br /> $(500,000)
<br /> $(1,000,000)
<br /> $(1,500,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />V#201 Jetter/Vactor$-$-$-$-$-$-$-$-$-$-$400,000$-$-$-$-$-$-$-$-$-$400,000
<br />V#202 1-ton with dump box/plow---40,000-----------40,000----80,000
<br />V#217 1-ton service truck---------30,000----------30,000
<br />V#209 1-ton "Flat Bed Crane"40,000-----------------40,00080,000
<br />V#213 Extend-a-jet replacement---35,000--------------35,000-70,000
<br />V#220 Towmaster trailer - 10 ton---10,000---------10,000------20,000
<br />V#225 Mini Backhoe (1/3) Water, Sa -----------40,000--------40,000
<br />V#211 360 Backhoe (3-way split)-----60,000------------60,000-120,000
<br />V#237 Wacker compactor-------------25,000------25,000
<br />VWater Truck (1/2)-60,000-----------------60,000120,000
<br />EPipe Camera75,000-----------75,000-------150,000
<br />E#211A Sand Bucket (1/3)---------5,000----------5,000
<br />ECompactor for #211 360 Backhoe (-----------15,000--------15,000
<br />EElectronic message board-attenuato---------7,500---------7,50015,000
<br />EReplace/Upgrade SCADA system (-75,000-----20,000----10,000----10,000--115,000
<br />EComputer replacement--5,000----5,000-5,000-------5,000--20,000
<br />EReplace 1990 air compressor(1/3)-15,000------------------15,000
<br />EGPS with computer (1/3 share)---4,000----4,000----4,000----4,000-16,000
<br />EReplace Onan portable generator----75,000---------------75,000
<br />BLS repairs/upgrades---------------------
<br />BFulham LS Rehab-------35,000315,000-----------350,000
<br />BJosephine LS Rehab---------------------
<br />BWagner LS Rehab---------------------
<br />BGaltier LS Rehab-50,000500,000-----------------550,000
<br />BLounge LS Rehab350,000-------------------350,000
<br />BDale/Owasso LS Rehab---45,000405,000---------------450,000
<br />BCleveland LS upgrade---------------------
<br />BCohansey LS upgrade---30,000270,000--------------300,000
<br />BCenter Street LS upgrade-----25,000225,000-------------250,000
<br />BBrenner LS upgrade------20,000200,000------------220,000
<br />BLong Lake Lift Station--35,000315,000----------------350,000
<br />
<br />
|