Loading...
ITEM 4 FleetCity of Otsego, Minnesota Capital Improvement Plan 2020 thru 2029 PROJECTS BY FUNDING SOURCE Source # Priority 2020 2021 2022 2023 2024 2025 206 - Capital Equipment Revolving Single Axle Roll -Off Truck FLEET -20-01 nla 3l4 Ton Extended Cab Pickup FLEET -20-02 nla Compact SUV FLEET -20-03 nla Aluminum Tandem Axle Trailer FLEET -20-04 nla Floor Scrubbing Machine FLEET -20-05 nla Forced Air Debris Blower FLEET -20-06 nla Tractor Mounted Snow Blower FLEET -20-07 nla Hydraulic Shouldering Machine FLEET -20-08 nla 2021-2029 Future Fleet Purchases FLEET -21-29 nla 206 - Capital Equipment Revolving Total GRAND TOTAL FLEET - 1 2026 2027 2028 2029 Total 272,000 272, 000 40,000 40,000 25,054 25,054 10,000 10,000 23,500 23,500 8,000 8,000 15,500 15,500 9,300 9,300 361,500 208,400 255,360 422,695 386,800 669,000 362,994 398,210 472,800 3,537,759 403,354 361,500 208,400 255,360 422,695 386,800 669,000 362,994 398,210 472,800 3,941,113 403,354 361,500 208,400 255,360 422,695 386,800 669,000 362,994 398,210 472,800 3,941,113 Thursday, October 17, 2019 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET -20-01 Project Name Single Axle Roll -Off Truck 2020 Ihn, 2029 Type Vehicles Department Fleet Useful Life Contact Street Operations Manager Category Vehicles Priority n/a Description I Total Project Cost: $272,000 FLEET - 2 Single -axle dump truck equipped with a roll -off style chassis with dump body, plow equipment and anti -icing equipment. Justification 115 is a 2003 Sterling single -axle dump truck and plow. This truck is also used at the department's water truck throughout the summer. Staff is recommending that this truck be replaced with a roll -off style chassis because we have seen how useful the truck can be with the purchase of our first roll -off truck in 2016. This truck is )eing recommended to be outfitted with a dump body, plow equipment and anti -icing equipment. The addition of the anti -icing equipment will almost double the amount of pre -treating that we ,an do ahead of snow events and we have seen sizable reductions in the amount of salt needed after we do pre -treating of streets. The addition of another roll -off chassis is also needed as the JotBox unit is typically on our 2016 roll -off chassis much of the summer for blacktop patching and the addition of another similar chassis would be more economical. Expenditures 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Vehicles 272,000 272,000 Total 272,000 Funding Sources 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 206 - Capital Equipment 272,000 272,000 Revolving 272,000 Total 272,000 272,000 Thursday, October 17, 2019 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET -20-02 Project Name 3/4 Ton Extended Cab Pickup 2020 thru 2029 Type Vehicles Department Fleet Useful Life Contact Utility Operations Manager Category Vehicles Priority n/a FLEET - 3 Description I Total Project Cost: $40,000 'urchase of a new extended cab pickup in 3/4 ton size. Chis is an addition to the City's fleet. Justification Che Utility Department is requesting the addition of a 3/4 ton pick up to provide each department member the ability for emergency response, customer service needs, scheduled projects and nobility over the large service area. Che Utility Department currently maintains four 3/4 ton trucks for six staff, five full time employees and one year round seasonal. It should also be noted that the 2020 Utility Department budget ncludes the addition of another full-time staff member to align with the East WWTF Biosolids Facility. Expenditures 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Vehicles 40,000 40,000 Total 40,000 40,000 Funding Sources 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 206 - Capital Equipment 40,000 40,000 Revolving Total 40,000 40,000 Thursday, October 17, 2019 Capital Improvement Plan City of Otsego, Minnesota 'roject# FLEET -20-03 ?roject Name Compact SUV 2020 thru 2029 Type Vehicles Department Fleet Useful Life Contact Street Operations Manager Category Vehicles Priority n/a Total Project Cost: $25,054 FLEET -4 'urchase of a new compact SUV. Chis is an addition to the City's fleet. Justification Chis vehicle addition would primarily be used to support the Building Safety Department. Currently the City has only vehicle available for use by the building officials and inspectors. Due to this, he City is charged mileage on Metro West company vehicles, which is the City's contracted building official and inspection company. Since the beginning of 2017, the City has been charged 616,877, which equates to a monthly average of $544. The monthly average of purchasing a new vehicle at this price is $343, which is based on a ten-year useful life. Chis compact SUV would also be able to be used by other departments when available. Expenditures 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Vehicles 25,054 25,054 Total 25,054 25,054 Funding Sources 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 206 - Capital Equipment 25,054 25,054 Revolving Total 25,054 25,054 Thursday, October 17, 2019 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET -20-04 Project Name Aluminum Tandem Axle Trailer Type Equipment Useful Life Category Equipment 2020 thru 2029 Department Fleet Contact Park & Recreation Director Priority n/a Total Project Cost: $10,000 FLEET - 5 01 3eplacement of the 2006 Felling Trailer PW #49. Justification Che City purchased the 2006 Felling Trailer PW#49 in 2011 for transporting light equipment throughout the year. Since this trailer does see quite a bit of use during the winter months and the :railer is steel, Staff is recommending replacing the trailer with an 16' aluminum trailer. Expenditures 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Equipment 10,000 10,000 Total 10,000 10,000 Funding Sources 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 206 - Capital Equipment 10,000 10,000 Revolving Total 10,000 10,000 Thursday, October 17, 2019 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET -20-05 Project Name Floor Scrubbing Machine 2020 thru 2029 Type Equipment Department Fleet Useful Life Contact Street Operations Manager Category Equipment Priority n/a Description I Total Project Cost: $23,500 FLEET - 6 'urchase of a new small, driver operated floor scrubber that can be used to clean the shop floor. Chis is an addition to the City's fleet. Justification �urrently when the shop is cleaned, staff needs to remove all of the equipment from the shop and use the large Elgin sweeper which creates a lot of dust and is very inefficient. The Karcher nodel would allow a single employee to make rounds through the shop, in between equipment and the machine is narrow enough to go through doorways into most of our storage rooms as well. Chis machine will save staff significant time in housekeeping operations and assist in keeping a clean and tidy work area. Expenditures 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Equipment 23,500 23,500 Total 23,500 23,500 Funding Sources 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 206 - Capital Equipment 23,500 23,500 Revolving Total 23,500 23,500 Thursday, October 17, 2019 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET -20-06 Project Name Forced Air Debris Blower Type Equipment Useful Life Category Equipment 2020 thru 2029 Department Fleet Contact Park & Recreation Director Priority n/a Total Project Cost: $8,000 FLEET - 7 'urchase of a new towable debris blower. Chis is an addition to the City's fleet. Justification �turently, the City of Otsego has over 24 miles of trails and over 100 acres of maintained turf. Effectively keeping these areas clear of debris and safe for the public becomes more challenging ias the City acquires more trails and parks, trees and landscaping become more established, and the use of the parks and trails increase in use. A turbine debris blower is a multi -use towable piece A equipment that can remotely remove debris from trails, turfed areas, and parking lots. The blower can also removed snow when the amounts are light. Expenditures 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Equipment 8,000 8,000 Total 8,000 8,000 Funding Sources 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 206 - Capital Equipment 8,000 8,000 Revolving Total 8,000 8,000 Thursday, October 17, 2019 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET -20-07 Project Name Tractor Mounted Snow Blower 2020 thru 2029 Type Equipment Department Fleet Useful Life Contact Street Operations Manager Category Equipment Priority n/a Description I Total Project Cost: $15,500 FLEET - 8 'urchase of a new front mount hydraulically powered snow blower that would be mounted on the 6130M John Deere tractor that the City bought in 2019. Chis is an addition to the City's fleet. Justification Che Frontier SB 1388R is a large two stage snow blower that gives the 6130M John Deere tractor an entirely different use. That tractor will be used in our main snow fall responses with a box glow and then when we have the ability to switch implements from the box plow to the blower. The addition of this snow blower brings another large snow blower to our fleet for a relatively ;mall investment. The plow is narrow enough to help on blacktop paths and large enough to help out in areas where we have blowing and drifting concerns. Expenditures 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Equipment 15,500 15,500 Total 15,500 15,500 Funding Sources 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 206 - Capital Equipment 15,500 15,500 Revolving Total 15,500 15,500 Thursday, October 17, 2019 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET -20-08 Project Name Hydraulic Shouldering Machine 2020 thru 2029 Type Equipment Department Fleet Useful Life Contact Street Operations Manager Category Equipment Priority n/a FLEET - 9 Description I Total Project Cost: $9,300 'urchase of a shouldering machine that is an implement that goes on the rear of one of the City's large dump trucks that allows staff to apply class 5 or other shoulder materials to road shoulders. Chis model has the capability to discharge materials out of either side of the truck which makes it very useful for different applications. Chis is an addition to the City's fleet. Justification The City's current shouldering machine has reached it's useful life and is need of replacement. Many of the components are worn out and staff is constantly making repairs to the machine while it s being used. The chain, bearings and conveyor are all in a state of disrepair and we are being forced to get by shouldering at this point with our salt/sand spreaders. The class 5 and other ;houldering materials are quite hard on that equipment and therefor staff would like to replace the old model with the HTC 1800 Hydraulic Shouldering Machine. Expenditures 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Equipment 9,300 9,300 Total 9,300 9,300 Funding Sources 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 206 - Capital Equipment 9,300 9,300 Revolving Total 9,300 9,300 Thursday, October 17, 2019 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET -21-29 Project Name 2021-2029 Future Fleet Purchases Type Vehicles Useful Life Category Vehicles 2020 thru 2029 Department Fleet Contact Priority n/a FLEET - 10 Description I Total Project Cost: $3,537,759 Annual Fleet Purchases Che current replacement schedule can be found in the Capital Improvement Plan section of the budget. Years 2021-2029 are presented as lump sum amounts instead of individual purchase imounts as the potential purchases in any year beyond 2020 is subject to change. Justification itaff reviews fleet condition annually to provide a recommendation of scheduled replacements along with an evaluation of the City's equipment's capability to continue providing a high level of service. A rating system has been established to quantify these recommendations based on five criteria (age, mileage, maintenance cost, condition and level of use.) Equipment is recommended =or replacement based on industry life cycles for typical equipment, age of equipment and current condition. Expenditures 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total Vehicles 361,500 208,400 255,360 422,695 386,800 669,000 362,994 398,210 472,800 3,537,759 Total Funding Sources 2020 361,500 2021 208,400 2022 255,360 2023 422,695 2024 386,800 2025 669,000 2026 362,994 2027 398,210 2028 472,800 2029 3,537,759 Total 206 - Capital Equipment Revolving 361,500 208,400 255,360 422,695 386,800 669,000 362,994 398,210 472,800 3,537,759 Total 361,500 208,400 255,360 422,695 386,800 669,000 362,994 398,210 472,800 3,537,759 Thursday, October 17, 2019 City of Otsego FLEET - 11 Capital Equipment Revolving Fund Cash Flow Summary 4' Revised: October 22, 2019 7.69% 7.14% 6.67% 6.25% 5.88% 5.56% 5.26% 5.00% 4.76% 4.55% Forecast Projection - Capital Improvement Plan 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Comments Revenues Property Taxes $ 260,000 $ 280,000 $ 300,000 $ 320,000 $ 340,000 $ 360,000 $ 380,000 $ 400,000 $ 420,000 $ 440,000 $ 460,000 Investment Interest - - - - - - - - - - - Sales of Fixed Assets - - - - - - - - - - Sales of Fixed Assets (Est.) - 16,200 - - - - - - - - Utility Fund Contributions - 40,000 42,000 - 44,000 46,000 - 548,000 51,240 - - Transfers In - - - - - - - - - - - Total 260,000 336,200 342,000 320,000 384,000 406,000 380,000 948,000 471,240 440,000 460,000 Expenses Personal Services - - - - - - - - - - - Supplies - - - - - - - - Other Charges & Services - - - - - - - - - - Capital Outlay - General - - - - - - Capital Outlay - Streets 402,107 - - - - - - - - - - Capital Outlay - Parks 53,901 - - - - - - - - - - Capital Outlay (Fleet CIP) - 403,354 361,500 208,400 255,360 422,695 386,800 669,000 362,994 398,210 472,800 DRAFT 2020-2029 CIP Transfers Out - - - - - - - - - - - Total 456,008 403,354 361,500 208,400 255,360 422,695 386,800 669,000 362,994 398,210 472,800 Average = $399,738 Cash Balance - Beginning 586,561 390,553 323,399 303,899 415,499 544,139 527,444 520,644 799,644 907,890 949,680 Balance Sheet Effects Revenues 260,000 336,200 342,000 320,000 384,000 406,000 380,000 948,000 471,240 440,000 460,000 Expenditures (456,008) (403,354) (361,500) (208,400) (255,360) (422,695) (386,800) (669,000) (362,994) (398,210) (472,800) Cash Balance - Ending $ 390,553 $ 323,399 $ 303,899 $ 415,499 $ 544,139 $ 527,444 $ 520,644 $ 799,644 $ 907,890 $ 949,680 $ 936,880 Cash Balance - % of Next Year Capital 97% 89% 146% 163% 129% 136% 78% 220% 228% 201% X:\Budget\2020\Cash Flows\Capital Funds 206 -Capital Equipment FLEET - 12 City of Otsego - Capital Assets - Vehicles (by Year) Unit # Department Existing Description Replacement Description Year Purchased Purchased Cost Scheduled Replacement Replacement Cost Estimate Salvage Value (Trade / Sale) Net Cost PW #15 Streets 2003 Sterling S/A Dump Truck, Plow S/A Roll -off Truck - Plow / Dump / Anti -Icing 2003 135,216 2020 272,000 15,000 257,000 ADDITION Utilities 62,000 3/4 Ton Extended Cab Pickup N/A 2020 40,000 40,000 ADDITION Inspections Compact SUV N/A 2020 25,054 25,054 PW#49 Parks 2006 Felling tandem axel mowing trailer Aluminum Tandem Axle Trailer 2011 5,000 2020 10,000 1,200 8,800 ADDITION Streets 6,945 Floor Scrubber N/A 10,000 2020 23,500 2010 Mack GU713 Jet -Vac 23,500 ADDITION Parks 500,000 Forced Air Debris Blower Trailer N/A Utilities 2020 8,000 35,000 8,000 ADDITION Streets PW#54 Snow Blower for 6000 Series tractor N/A 2016 2020 15,500 63,000 15,500 ADDITION Streets Hydraulic Shouldering Machine N/A 2026 Total 2020 9,300 9,300 2020 Total 403,354 16,200 387,154 32,473 2027 39,584 39,584 PW #1 Streets 2007 Elgin street sweeper 2011 77,484 2027 ADDITION Streets PW#36 Tandem Axle Plow Truck N/A 2017 2021 232,000 49,930 232,000 PW #22 Parks 2012 John Deere Z925A Zero Turn 2017 2012 10,200 2021 11,000 PW#57 11,000 PW #46 Streets 2005 CAT 908 Loader 2027 2010 53,331 2021 76,500 76,500 PW#6 Utilities 2005 extended cab pickup 362,994 2005 22,080 2021 42,000 42,000 PW #14 Parks 2018 CAT 259D Track Skid Loader 2018 2021 Total 361,500 59,124 361,500 PW#60 Parks 2018 Ventrac 450OZ 2018 52,637 2028 63,164 63,164 PW #38 Parks PW #20 Streets Atlas Copco Air Compressor 2028 2011 10,270 2022 15,300 2018 Toro 5910 wide area mower 15,300 ADDITION Parks Tool Cat 124,310 N/A Streets 2022 57,000 29,356 57,000 BD#20 Inspections 2006 Ford Explorer Streets 2006 20,153 2022 30,600 35,558 30,600 PW#50 Parks 2013 GMC Sierra 3500 1 ton 4X4 w/ low 2018 2013 31,985 2022 45,000 PW#19 45,000 PW #31 Streets 2012 Wanco Radar/Speed Trailer 2028 2012 10,313 2022 16,500 16,500 PW#7 Streets 2012 Ford F350 Pickup w/plow 398,210 2012 34,516 2022 44,000 44,000 PW#64 Parks 2019 Ford F-350 truck w/dump 2019 2022 Total 208,400 60,000 208,400 PW#66 Parks 2019 ProGator 2019 2029 63,600 63,600 PW#70 Streets PW #10 Streets 2013 Ford F150 extended cab 4X4 2029 2013 25,600 2023 37,800 2019 Stepp Hot Box 37,800 ADDITION Streets 78,000 3/4 T Ext Cab N/A Streets 2023 50,760 50,760 ADDITION Streets Parks Used Sweeper N/A 2019 2023 85,000 27,000 85,000 PW#52 Parks 2013 Ford F150 extended cab 4X4 2013 23,900 2023 37,800 37,800 PW#12 Utilities 2013 F250 4X4 w/plow 2013 22,300 2023 44,000 44,000 2023 Total 255,360 255,360 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 2024 224,000 224,000 PW#24 Streets 2014 Larue D35 Snowblower 2014 87,646 2024 105,175 105,175 PW#2 Streets 2014 Kubota RTV-X1120D Utility Vehicle 2014 9,857 2024 12,000 12,000 ADDITION Utilities 3/4 T Ext Cab N/A 2024 46,000 46,000 PW #23 Streets 2004 WRT Rubber Tire Roller 2006 12,500 2024 20,520 20,520 2024 Total 422,695 422,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 2025 232,000 232,000 PW#4 Streets 2015 Ford F-350 One ton dump 2015 44,095 2025 62,000 62,000 2025 Total 386,800 386,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 10,000 10,000 PW #44 Utilities 2010 Mack GU713 Jet -Vac 2010 260,514 2026 500,000 500,000 PW #18 Utilities 2016 Ford F-250 Extended Cab 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 669,000 669,000 PW#56 Parks 2017 Ford F-250 Crew Cab 2017 32,473 2027 39,584 39,584 PW #1 Streets 2007 Elgin street sweeper 2011 77,484 2027 187,200 187,200 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 2017 42,390 2027 51,240 51,240 2027 Total 362,994 362,994 PW #14 Parks 2018 CAT 259D Track Skid Loader 2018 33,156 2028 59,124 59,124 PW#60 Parks 2018 Ventrac 450OZ 2018 52,637 2028 63,164 63,164 PW #38 Parks 2006 Ford F450 truck w/dump 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 398,210 398,210 PW#64 Parks 2019 Ford F-350 truck w/dump 2019 2029 60,000 60,000 PW#66 Parks 2019 ProGator 2019 2029 63,600 63,600 PW#70 Streets 2016 Cimline Tack Trailer 2019 12,000 2029 19,200 19,200 PW#69 Streets 2019 Stepp Hot Box 2019 2029 78,000 78,000 ADDITION Streets S/A Dump Body Plow Truck N/A 2029 225,000 225,000 Parks Parks Kromer Field Painter/ Groomer 2019 $22,500 2029 27,000 27,000 2029 Total 472,800 472,800