Loading...
PACKET - FLEETCity of Otsego, Minnesota Capital Improvement Plan 2019 thru 2028 PROJECTS BY FUNDING SOURCE Source # Priority 2019 2020 2021 2022 2023 2024 206 - Capital Equipment Revolving i 400,922 Tractor -Equipped With FLEET -19-01 n/a 171,218 Mower/Broom/Plow 786,800 167,334 Roll -Off Mounted Asphalt Hot Box FLEET -19-02 n/a 66,962 Heavy Duty Utility Vehicle FLEET -19-03 n/a 57,097 Single Axle Dump - FLEET -19-04 n/a 223,000 Plow/Wing/Sander 2020-2028 Future Fleet Purchases FLEET -20-28 n/a GRAND TOTAL FLEET -1 2025 2026 2027 2028 Total 171,218 66,962 57,097 223,000 400,922 385,500 464,400 449,600 376,695 786,800 167,334 215,378 335,045 3,581,674 206 - Capital Equipment Revolving Total 518,277 400,922 385,500 464,400 449,600 376,695 786,800 167,334 215,378 335,045 4,099,951 GRAND TOTAL 518,277 400,922 385,500 464,400 449,600 376,695 786,800 167,334 215,378 335,045 4,099,951 Thursday, November 15, 2018 FLEET - 2 City of Otsego - Capital Assets - Vehicles (by Year) Unit # Department Existing Description Replacement Description Year Purchased Purchased Cost Scheduled Replacement Replacement Cost Salvage Value (Trade / Sale) Net Cost PW #43 Streets 2010 Mack GU713 Tandem Dump Truck, Plow 2010 197,609 2024 232,000 232,000 PW#4 PW #35 Streets 2006 5425 John Deere Tractor, Mower, Broom 6130 John Deere tractor w/mowers, broom, plow 2006 37,549 2019 171,218 25,000 146,218 ADDITION Streets 2010 Stepp Hot Box N/A 400,000 2019 66,962 66,962 PW #48 PW #47 Parks Parks 2011 John Deere Gator TX Utility Vehicle 2011 4720 John Deere Tractor 2030A Pro Gator 2011 2011 8,416 36,011 2019 2019 57,097 5,000 21,000 5,000 36,097 PW #3 Streets 2000 Sterling 7501 S/A Dump w/plow & wing Single Axle Dump truck with plow, wing, sander 2012 37,433 2019 223,000 15,000 208,000 40,000 2026 48,000 48,000 PW#55 Parks 2019 Total 518,277 66,000 452,277 2026 8,334 8,334 PW #18 Utilities 2016 Ford F-250 Extended Cab 3/4 Ton Ext Cab w Plow Package 2016 35,000 2026 PW #15 Streets 2003 Sterling S/A Dump Truck, Plow Roll -off truck, plow/wing, dump body, anti -icing body 2003 135,216 2020 272,000 - 272,000 ADDITION Streets Floor Scrubber N/A 20,222 167,334 20,222 ADDITION Parks Toro Blower - ADDITION Streets Tack Trailer 32,473 2027 39,584 22,000 PW#17 22,000 BD#20 Inspections 2006 Ford Explorer 32,473 2006 20,153 2020 30,600 - 30,600 PW #22 Parks 2012 John Deere Z925A - zero turn moved from 2019 2027 2012 10,200 2020 9,100 4,000 5,100 PW #6 Utilities 2005 Chevrolet extended cab pickup 3/4 Ton Ext Cab w Plow Package 2005 22,080 2020 47,000 1,000 46,000 42,390 2027 51,240 51,240 2020 Total 400,922 5,000 395,922 2027 Total 215,378 215,378 PW#57 Parks 2012 Field Painter/ Groomer Parks 2016 8,500 2021 20,000 - 20,000 ADDITION Streets Parks Tandem Axle Plow Truck 2018 232,000 232,000 PW #46 Streets 2005 CAT 908 Loader 2010 53,331 2020 76,500 - 76,500 PW#49 Parks 2006 Fellin tandem axel mowing trailer 2007 2011 5,000 2021 10,000 PW#51 10,000 ADDITION Utilities on xt a w ow PaCKage 103,592 N/A 1 124,310 2021 47,000 Streets 47,000 2018 29,356 2028 35,227 35,227 2021 Total 385,500 2018 Ford F-250 Extended Cab 4x4 385,500 2018 29,632 2028 35,558 35,558 PW#28 Parks 2018 Felling FT16-2 Tilt Trailer 2018 PW #20 Streets Atlas Copco Air Compressor 19,815 2011 10,270 2022 15,300 2018 15,300 PW #1 Streets 2007 Elgin street sweeper 2011 77,484 2021 187,200 187,200 PW #42 Streets 2002 Sterling L8511 Dump Truck, Plow 2010 52,983 2021 201,400 201,400 PW #31 Streets 2012 Wanco Radar/Speed Trailer 2012 10,313 2022 16,500 16,500 PW#7 Streets 2012 Ford F350 Pickup w/plow 2012 34,516 2022 44,000 44,000 2022 Total 464,400 464,400 PW #10 Streets 2013 Ford F150 extended cab 4X4 2013 25,600 2023 37,800 37,800 PW #5 Streets 2001 CAT 143H Road Grader 2013 116,227 2022 297,000 297,000 PW#52 Parks 2013 Ford F150 extended cab 4X4 2013 23,900 1 2023 37,800 37,800 PW#12 Utilities 2013 F250 4X4 w/plow, 3/4 Ton Ext Cab w Plow Package 2013 22,300 1 2023 35,000 35,000 PW#50 Parks 2013 GMC Sierra 35001 ton 4X4 w/plow 2013 31,985 2023 42,000 42,000 2023 Total 449,600 449,600 PW#56 Parks Dump Box Trailer 2014 12,000 2024 15,000 15,000 PW #39 Streets 2008 Sterling L8500 Dump Truck, Plow 2008 68,028 2023 224,000 224,000 PW#24 Streets 2014 Larue D35 Snowblower 1 2014 1 87,646 2024 105,175 105,175 PW#2 Streets 2014 Kubota RTV-X1120D Utility Vehicle 2014 9,857 2024 12,000 12,000 PW #23 Streets 2004 WRT Rubber Tire Roller 2006 12,500 2024 20,520 20,520 2024 Total 376,695 376,695 PW #8 Streets 2010 CAT 305C Excavator 2010 55,286 2025 92,800 92,800 PW #43 Streets 2010 Mack GU713 Tandem Dump Truck, Plow 2010 197,609 2024 232,000 232,000 PW#4 Streets 2015 Ford F-350 One ton dump 2015 44,095 2025 62,000 62,000 PW #44 Utilities 2010 Mack GU713 Jet -Vac Equivalent 2010 260,514 2025 400,000 400,000 2025 Total 786,800 786,800 PW#53 Parks 2016 Ford F-250 Extended Cab 2016 40,000 2026 48,000 48,000 PW#55 Parks 2016 John Deere Z930M zero turn mower 2016 6,945 2026 8,334 8,334 PW #18 Utilities 2016 Ford F-250 Extended Cab 3/4 Ton Ext Cab w Plow Package 2016 35,000 2026 48,000 48,000 PW#54 Streets 2016 Ford F-350 One ton dump 2016 52,946 2026 63,000 63,000 2026 Total 167,334 167,334 PW#56 Parks 2017 Ford F-250 Crew Cab 2017 32,473 2027 39,584 39,584 PW#17 Streets 2017 Ford F-250 Extended Cab 2017 32,473 2027 39,584 39,584 PW#36 Streets 2017 John Deere 4066R 2017 41,608 2027 49,930 49,930 PW#16 Streets 2017 Bomag BW90AD Asphalt Roller 2017 29,200 2027 35,040 35,040 PW#57 Utilities 2017 Ford F-250 Extended Cab & Plow 3/4 Ton Ext Cab w Plow Package 2017 42,390 2027 51,240 51,240 2027 Total 215,378 215,378 PW #14 Parks 2018 CAT 259D Track Skid Loader 2018 33,156 2028 59,124 59,124 PW#60 Parks 2018 Ventrac 450OZ 2018 2028 - PW #45 DISPOSAL 2010 John Deere Z925A Ztrak Mower - zero turn 2010 9,862 2028 - - PW #38 Parks 2006 Ford F450 truck w/dump 1 Ton Chassis w/ Dump Body 2007 32,500 2028 41,241 41,241 PW#51 Parks 2018 Toro 5910 wide area mower 2018 103,592 2028 124,310 124,310 PW#58 Streets 2018 Vermeer BC1000XL Chipper 2018 29,356 2028 35,227 35,227 PW#63 Streets 2018 Ford F-250 Extended Cab 4x4 2018 29,632 2028 35,558 35,558 PW#28 Parks 2018 Felling FT16-2 Tilt Trailer 2018 16,513 2028 19,815 19,815 PW#19 Streets Vermac Traffic Information Trailer 2018 16,475 2028 19,770 19,770 2028 Total 335,045 335,045 City of Otsego FLEET - 3 Capital Equipment Revolving Fund Cash Flow Summary i' Revised: November 15, 2018 10.54% 7.69% 7.14% 6.67% 6.25% 5.88% 5.56% 5.26% 5.00% 4.76% Forecast Projection - Capital Improvement Plan 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Comments Revenues Property Taxes $ 235,200 $ 260,000 $ 280,000 $ 300,000 $ 320,000 $ 340,000 $ 360,000 $ 380,000 $ 400,000 $ 420,000 $ 440,000 Investment Interest - - - - - - - - - - - Sales of Fixed Assets - - - - - - - - - - Sales of Fixed Assets (Est.) 74,600 66,000 - - - - - - - - Utility Fund Contributions - - 47,000 47,000 - 35,000 - 400,000 48,000 51,240 - Transfers In - - - - - - - - - - - Total 309,800 326,000 327,000 347,000 320,000 375,000 360,000 780,000 448,000 471,240 440,000 Expenses Personal Services - - - - - - - - - - - Supplies - - - - - - - Other Charges & Services - - - - - - - - - - Capital Outlay - General - - - - - - Capital Outlay - Streets 298,104 - - - - - - - - - - Capital Outlay - Parks 185,470 - - - - - - - - - - Capital Outlay (Fleet CIP) - 518,277 400,922 385,500 464,400 449,600 376,695 786,800 167,334 215,378 335,045 DRAFT 2019-2028 CIP Transfers Out - - - - - - - - - - - Total 483,574 518,277 400,922 385,500 464,400 449,600 376,695 786,800 167,334 215,378 335,045 Average = $409,995 Cash Balance - Beginning 624,018 450,244 257,967 184,045 145,545 1,145 (73,455) (90,150) (96,950) 183,716 439,578 Balance Sheet Effects Revenues 309,800 326,000 327,000 347,000 320,000 375,000 360,000 780,000 448,000 471,240 440,000 Expenditures (483,574) (518,277) (400,922) (385,500) (464,400) (449,600) (376,695) (786,800) (167,334) (215,378) (335,045) Cash Balance - Ending $ 450,244 $ 257,967 $ 184,045 $ 145,545 $ 1,145 $ (73,455) $ (90,150) $ (96,950) $ 183,716 $ 439,578 $ 544,533 Cash Balance - % of Next Year Capital 87% 64% 48% 31% 0% -19% -11% -58% 85% 131% X:\Budget\2019\Cash Flows\Capital Funds 206 -Capital Equipment