|
City of Roseville
<br />Capital Improvement Plan: Public Works Vehicle & Equipment Fund (403)
<br />2025-2044
<br />Tar. Levy: Current
<br />Tax Levy: Add/Sub
<br />Other
<br />Sale of Assets
<br />Interest Earnings
<br />Vehicles
<br />Equipment
<br />Furniture & Fixtures
<br />Buildings
<br />Improvements
<br />Beginning Cash Balance
<br />Annual Surplus (deficit)
<br />Cash Balance
<br />Cash Balance (Year -End)
<br />Planned CIP Surplus/Deficit
<br />Adjust for Delayed CIP Items
<br />Cash Balance (Beg. Year)
<br />* Current Assets - Current Liabilities
<br />Expenditure Detail
<br />Updated 811212024
<br />2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044
<br />$ 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 />- - - - - - - - - - - - - - - - - - - -
<br />150,000 - - - - - - - - - - - - - - - - - - -
<br />- - - - - - - - - - - - - - - - - - - -
<br />4,500 12,808 15,424 4,762
<br />- - - - - - - - - - - - - - - -
<br />Revenues $ 389,500 $ 247,808 $ 250,424 $ 239,762 $ 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 $4,887,494
<br />$ 311,000 $ - $ 431,000 $ 721,000 $ 45,000 $ 50,000 $ 356,000 $ 60,000 $ 611,000 $ 311,000 $ 611,000 $ 140,000 $ 647,000 $ - $ 95,000 $ 721,000 $ 45,000 $ 50,000 $ 45,000 $ -
<br />30,000 117,000 352,500 75,000 120,000 65,000 80,000 110,000 22,000 117,000 60,000 71,100 210,500 110,000 155,000 117,000 252,000 70,000 20,000 20,000
<br />- - - - - - 30,000 - - - - - - - 30,000 - - - - -
<br />- - - - - - - - - - - 00,000 - - - - - - - -
<br />Expenditures $ 341,000 $ 117,000 $ 783,500 $ 796,000 $ 165,000 $ 115,000 $ 466,000 $ 170,000 $ 633,000 $ 428,000 $ 671,000 $ 311,100 $ 857,500 $ 110,000 $ 280,005 $ 838,000 $ 297,000 $ 120,000 $ 65,000 $ 20,000 $7,584,100
<br />$ 591,885 $ 640,385 $ 771,193 $ 238,117 $ (318,121) $ (248,121) $ (128,121) $ (359,121) $ (294,121) $ (692,121) $ (885,121) $(1,321,121) $(1,397,221) $(2,019,721) $(1,894,721) $(1,939,721) $(2,542,721) $(2,604,721) $(2,489,721) $ (2,319,721)
<br />48,500 130,808 (533,076) (556,238) 70,000 120,000 (231,000) 65,000 (398,000) (193,000) (436,000) (76,100) (622,500) 125,000 (45,000) (603,000) (62,000) 115,000 170,000 215,000
<br />$ 640,385 $ 771,193 $ 238,117 $ (318,121) $ (248,121) $ (128,121) $ (359,121) $ (294,121) $ (692,121) $ (885,121) $(1,321,121) $(1,397,221) $(2,019,721) $(1,894,721) $(1,939,721) $(2,542,721) $(2,604,721) $(2,489,721) $(2,319,721) $ (2,104,721)
<br />Key Description
<br />E 9100 2012 Graphtec/SignMate Sign Equipment (Sign Shop)
<br />E 91082017 Turf Maker 550 Hydro Seeder
<br />E 9110 2021 Toro Goundmaster PolorTrac 7210-D (1/2 stone:
<br />E 9111 A01 2005 Bobcat 18" Millhead
<br />E 9111 A02 2005 Bobcat SB240-72
<br />E 9111 A05 2007 Bobcat HB980 Hydraulic Breaker
<br />E 9111 A06 2006 Bobcat 78" Fork Grapple
<br />E 9111 A09 2012 Bobcat 2.5" Slot Mill
<br />E 9111 A10 2013 Kage SB96 Snow Pusher
<br />E 9111 All 2014 Bobcat 68" Angle Broom
<br />E 9111 A15 2017 Vimig VBW-72-HF33 SnowBlower
<br />E 9111 A16 2018 Bobcat 72" Sweeper
<br />E 9111 A17 2018 Bobcat 24PLA Millhead
<br />E 9111 A18 2018 Vimig TRPB90C Tree Puller
<br />E 9111 A19 2019 Bobcat HB980 Pallet Fork
<br />E 9111 A20 2021 Rapid Router
<br />E 9111 A21 2022 Vimig Pickup Broom
<br />E 9111 A03 2016 Stanley PD45131 Post Pounder
<br />E 9111 2020 Bobcat S76
<br />E 9113 2017 Vermeer BC1500 Chipper
<br />E 91162015 Kubota M110GXDTC Tractor (1/2 storm)
<br />E 9123 2017 Stepp SPHOJ-2.0 Patch Trailer
<br />E 9129 2011 Sullair 260 CFM Air Compressor
<br />E 9133 2022 Husqvama Walk Behind Saw
<br />E 91372017 Trafifix Scorpion Attenumor(split 4 way)
<br />E 91412013 Wacker RD-12 Roller
<br />E 9149 2015 Towmaster T16DD Trailer
<br />E 91532017 Towmaster T-16DT Trailer
<br />E 91572018 Bomag BW120SL5 Roller
<br />$ 592,385 2023�
<br />(30,500) 2024
<br />30,000 2024
<br />$ 591,885 2025
<br />Public Works Vehicle & Equipment Fluid
<br />$1,500,000
<br />$1,000,000
<br />$500,000
<br />$-
<br />$(500,000)
<br />$(1,000,000)
<br />$(1,500,000)
<br />$(2,000,000)
<br />$(2,500,000)
<br />$(3,000,000)
<br />Revenues Expenditures Cash Balance
<br />2025 2026 2027 2028 2029 2030 2031
<br />30,000 - - - - -
<br />- - - - 40,000
<br />20,000 - - - -
<br />2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044
<br />- - - - $ - $ - $ - $ - $ - $ 30,000 $ - $ - $
<br />40,000 - - - - - - - - - -
<br />- - - - - - - - - 40,000 - -
<br />20,000 - - - - - -
<br />- - - - - - - 10,000 - - - -
<br />10,000 - - - - - - - - - - -
<br />10,000 - - - - - - - - - - -
<br />-
<br />10,000 - - -
<br />- - - -
<br />- -
<br />10,000
<br />-
<br />- - -
<br />-
<br />10,000 - -
<br />- - - -
<br />- -
<br />10,000
<br />-
<br />- - -
<br />10,000
<br />- - - -
<br />- - - -
<br />- -
<br />-
<br />10,000
<br />- - -
<br />-
<br />10,000 - - -
<br />- - - -
<br />- -
<br />10,000
<br />-
<br />- - -
<br />10,000
<br />- - - -
<br />- - - 10,000
<br />- -
<br />-
<br />-
<br />- - -
<br />-
<br />- 20,000 - -
<br />- - - -
<br />- -
<br />-
<br />20,000
<br />- - -
<br />-
<br />- - - -
<br />- - - -
<br />- -
<br />-
<br />10,000
<br />- - -
<br />-
<br />- - 10,000 -
<br />- - - -
<br />- 1,100
<br />-
<br />-
<br />10,000 - -
<br />-
<br />- 15,000 - -
<br />- - - -
<br />15,000 -
<br />-
<br />-
<br />- - -
<br />-
<br />- - 10,000 -
<br />- - - -
<br />10,000 -
<br />-
<br />-
<br />- - -
<br />-
<br />- - - -
<br />- - - -
<br />- 10,000
<br />-
<br />-
<br />- - -
<br />-
<br />87,000 - - -
<br />- - - 87,000
<br />- -
<br />-
<br />-
<br />- - 87,000
<br />-
<br />83,000 - - -
<br />- - - -
<br />- -
<br />83,000
<br />-
<br />- - -
<br />-
<br />60,000 - - -
<br />- - -
<br />- -
<br />-
<br />-
<br />60,000
<br />- - - -
<br />- 50,000 - -
<br />-
<br />-
<br />-
<br />- - -
<br />-
<br />35,000 - - -
<br />- - - -
<br />- -
<br />-
<br />-
<br />- - 35,000
<br />-
<br />-
<br />- - - -
<br />7,500 - - -
<br />- - -
<br />- - - -
<br />- -
<br />- -
<br />-
<br />7,500
<br />-
<br />-
<br />- - -
<br />- - -
<br />25,000
<br />- - - -
<br />- - - -
<br />- -
<br />-
<br />-
<br />25,000 - -
<br />-
<br />- - - -
<br />- - - 20,000
<br />- -
<br />-
<br />-
<br />- - -
<br />-
<br />20,000 - - -
<br />- - - -
<br />- -
<br />20,000
<br />-
<br />- - -
<br />-
<br />- - - -
<br />- - - -
<br />- 50,000
<br />-
<br />-
<br />- - -
<br />10,000
<br />15,000
<br />10,000
<br />10,000
<br />20,000
<br />$ 60,000
<br />40,000
<br />80,000
<br />40,000
<br />10,000
<br />10,000
<br />10,000
<br />20,000
<br />20,000
<br />20,000
<br />20,000
<br />30,000
<br />40,000
<br />10,000
<br />21,100
<br />45,000
<br />30,000
<br />10,000
<br />261,000
<br />166,000
<br />120,000
<br />50,000
<br />70,000
<br />10,000
<br />15,000
<br />50,000
<br />40,000
<br />40,000
<br />50,000
<br />9
<br />Page 18 of 55
<br />
|