|
City of Roseville
<br />Public Works Vehicle & Equipment Fund (403)
<br />Capital Improvement Plan:
<br />2018-2037
<br />20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />Tax Levy: Current$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000$235,000
<br />Tax Levy: Add/Sub--------------------
<br />Other--------------------
<br />Sale of Assets--------------------
<br />Interest Earnings12,73915,08414,55517,27713,80210,37810,58612,77712,62315,67513,4578,86410,68112,28512,05112,7929,6287,5302,521-
<br />Revenues$247,739$250,084$249,555$252,277$248,802$245,378$245,586$247,777$247,623$250,675$248,457$243,864$245,681$247,285$247,051$247,792$244,628$242,530$237,521$235,000$4,925,305
<br />Vehicles$97,000$233,000$40,000$280,000$405,000$205,000$76,000$192,000$14,000$284,500$437,500$115,000$35,000$233,000$210,000$405,000$300,000$368,000$242,000$7,500
<br />Equipment33,50043,50073,500146,00015,00025,00060,00053,50081,00077,10040,60038,000125,50026,000-1,00049,500125,000178,00067,000
<br />Furniture & Fixtures-----5,000-10,000----5,000------5,000
<br />Buildings--------------------
<br />Improvements--------------------
<br />Expenditures$130,500$276,500$113,500$426,000$420,000$235,000$136,000$255,500$95,000$361,600$478,100$153,000$165,500$259,000$210,000$406,000$349,500$493,000$420,000$79,500$5,463,200
<br />Beginning Cash Balance$636,950$754,189$727,773$863,828$690,105$518,907$529,285$638,871$631,148$783,771$672,847$443,203$534,068$614,249$602,534$639,585$481,376$376,504$126,034$(56,445)
<br />
<br />Annual Surplus (deficit)117,239(26,416)136,055(173,723)(171,198)10,378109,586(7,723)152,623(110,925)(229,643)90,86480,181(11,715)37,051(158,208)(104,872)(250,470)(182,479)155,500
<br />Cash Balance$754,189$727,773$863,828$690,105$518,907$529,285$638,871$631,148$783,771$672,847$443,203$534,068$614,249$602,534$639,585$481,376$376,504$126,034$(56,445)$99,055
<br />5-Year Funding Status138%10-Year Funding Status127%Long-Term Funding Status102%
<br />5-Year Funding Sources (Rev + Beg Cash Balance)$1,885,40710-Year Funding Sources (Rev + Beg Cash Balance)$3,122,447Long-Term Funding Sources (Rev + Beg Cash Balance)$5,562,255
<br />Cash Balance (Year-End)$944,0002016
<br />Public Works Vehicle & Equipment Fund
<br />Planned CIP Surplus/Deficit(307,050)2017
<br />Adjust for Delayed CIP Items-2017
<br /> $1,000,000
<br />Cash Balance (Beg. Year)$636,9502018
<br /> $800,000
<br /> $600,000
<br /> $400,000
<br /> $200,000
<br /> $-
<br />2018202120242027203020332036
<br /> $(200,000)
<br />RevenuesExpendituresCash Balance
<br />Expenditure Detail
<br />KeyDescription20182019202020212022202320242025202620272028202920302031203220332034203520362037
<br />VEng. Vehicle #307: ROW Equinox---------25,000------$-$-$-$-$25,000
<br />VEng. vehicle #302: Intern Astro----------25,000--------25,000
<br />VEng. vehicle #303: Survey F150----------30,000--------30,000
<br />VEng. vehicle #308: Proj.Cord.Escap----25,000----------25,000--50,000
<br />VEng. vehicle #304: Proj. Cord. C15030,000---------30,000-------60,000
<br />V#101 F-150 Pickup 2wd--30,000-----------30,000-----60,000
<br />V#104 1-ton pickup-35,000---------35,000--------70,000
<br />V#128 F250 4x4----------27,500---------27,500
<br />V#106 3-ton dump w/ plo----180,000----------180,000----360,000
<br />V#107 Wheel Loader (621)----------205,000---------205,000
<br />V#109 3-ton dump w/ plow-180,000-----------180,000------360,000
<br />V#111 Skidsteer Replacement---45,000---------45,000---90,000
<br />V#111 Kage plow------6,000---------6,000--12,000
<br />V#111 - Bobcat, snow blower-----------10,000--------10,000
<br />V#111 Bobcat, hydro hammer-8,000-----------8,000------16,000
<br />V#111 Bobcat, bucket5,000-----------5,000-------10,000
<br />V#111 Bobcat, millhead (18")22,000--------22,000--------22,000-66,000
<br />V#112 3-ton dump w/ plow---180,000----------180,000-----360,000
<br />V#123 Patch Hook Body----------------75,000--75,000
<br />V#125 5-ton Dump (tandem)---------230,000----------230,000
<br />V#133 - Walk behind saw--10,000------------10,000---20,000
<br />V#134 Sign truck and box and lift---55,000------------100,000---155,000
<br />V#141 Asphalt roller--------14,000-----------14,000
<br />V#143 Portable line striper-10,000--------------10,000---20,000
<br />
<br />
|