|
City of Mounds View
<br />Vehicle and Equipment Replacement Fund
<br />Target
<br />Estimated Age Replacement Balance New
<br />Veh.Year Original Replace Replacement In Balance To Be Annual
<br />Department Manufacturer Model No.VIN Acq.Cost Year Life Cost 2021 as of 12/21 Funded Cost
<br />Park US CARGO Cargo trailer 306 4X4UTS2103W012414 2003 2,923.00 2028 25 5,000 18 3,600.00 1,400.00 200.00
<br />Park AEBI TERRATRAC TT75 (Not replacing)307 14004 2005 74,839.81 2025 20 - 16 - - -
<br />Park FORD F250 4X4 Pickup (CC)308 1FTNF215X5ED18387 2005 25,723.77 2023 18 40,000 16 35,555.56 4,444.44 2,222.22
<br />Park FORD Sterling/Precision (Tanker)309 2FZACHDC66AV96438 2006 126,221.86 2026 20 200,000 15 150,000.00 50,000.00 10,000.00
<br />Park JACOBSEN Turfcat JRM372 4WD 314 95723402186 2013 21,343.81 2023 10 29,000 8 23,200.00 5,800.00 2,900.00
<br />Park BOB CAT 3400 Utility Vehicle 315 AJNT11764 2013 7,500.00 2023 10 9,000 8 7,200.00 1,800.00 900.00
<br />Park John Deere 5090M Utility Tractor Ordered 2021 82,042.00 2036 15 100,000 0 - 100,000.00 6,666.67
<br />Park Normand N86-280H Snow blower Ordered 2021 9,810.00 2036 15 12,000 0 - 12,000.00 800.00
<br />Park M-B USA 72" Broom Ordered 2021 6,825.00 2036 15 9,000 0 - 9,000.00 600.00
<br />Park Diamond Rear Swing Flail Mower Ordered 2021 16,615.00 2036 15 22,000 0 - 22,000.00 1,466.67
<br />Park AEBI TERRATRAC TT705 (not replacing)316 9098 2013 130,384.23 2028 15 - 8 - - -
<br />Park AEBI AEBI/SMWA Rev CF225 mower (not replacing)2013 10,686.49 2028 15 - 8 - - -
<br />Park AEBI Lastec 126" Batwing mower (not replacing)2013 16,975.00 2028 15 - 8 - - -
<br />Park FORD F350 w/service body and compressor 317 1FTBF3A6XFEA71021 2014 65,593.98 2027 13 87,000 7 46,846.15 40,153.85 6,692.31
<br />Park TORO Groundmaster 4000 318 314000231 2015 57,212.00 2025 10 71,500 6 42,900.00 28,600.00 7,150.00
<br />Park TORO Groundmaster 4000 319 314000237 2015 57,212.00 2025 10 71,500 6 42,900.00 28,600.00 7,150.00
<br />Park BOB CAT 3400 Utility Vehicle (added 2017)320 AJNT30458 2017 7,900.00 2027 10 13,000 4 5,200.00 7,800.00 1,300.00
<br />Park John Deere Z920M Mower 321 1TC920MELKT070096 2019 11,510.96 2029 10 15,000 2 3,000.00 12,000.00 1,500.00
<br />Park Kromer FO-1 322 400 2019 36,660.50 2029 10 47,000 2 9,400.00 37,600.00 4,700.00
<br />Park FORD F350 Pickup 323 1FDRF3H65LEE48673 2020 54,976.89 2033 13 72,000 1 5,538.46 66,461.54 5,538.46
<br />59,786.32
<br />231,053.13
<br />Storm FORD F250 646 1FTBF2B67BEC30936 2011 25,923.55 2024 13 37,000 10 28,461.54 8,538.46 2,846.15
<br />Storm Tymco 500X mounted on International 4300-M7 Chassis 647 1HTJTSKN1EH018891/201407SNF59502BAH 2015 272,612.45 2027 12 355,000 6 177,500.00 177,500.00 29,583.33
<br />32,429.49
<br />Water Custom Water tower (fluted column)500,000 gallon 2012 517,019.07 2032 20 780,000 9 351,000.00 429,000.00 39,000.00
<br />Water CAT 446B Backhoe 703 05BL00672 1995 88,281.05 2026 31 150,000 26 125,806.45 24,193.55 4,838.71
<br />Water REDIHAUL WOLFPAC Trailer (Not replaced)705 47SS121T5K1005396 1989 2,129.75 2020 31 - 32 - - -
<br />Water FORD 4X2 3/4 ton 706 1FTNF20L32EC81193 2002 25,761.85 2021 19 35,000 19 35,000.00 - -
<br />Water ONAN Booster Station (generator)J910431288 1990 2021 31 125,000 31 125,000.00 - -
<br />Water BOBCAT S650 T4 skid steer 708 ALJ827772 2019 40,403.10 2021 2 3,570 2 3,570.00 - -
<br />Water FORD F350 Pickup 709 1FT8X3A64FEB55441 2014 64,414.70 2027 13 85,000 7 45,769.23 39,230.77 6,538.46
<br />Water FORD F150 4x4 Super Cab (ordered)710 1FTFX1EG3HKD34430 2017 33,120.00 2030 13 45,000 4 13,846.15 31,153.85 3,461.54
<br />Water Nilfisk SC6000 36C Ecoflex Floor scrubber 711 3510191100158 2019 26,463.84 2034 15 45,000 2 6,000.00 36,818.18 2,832.17
<br />Water BOBCAT Hydraulic Frost Breaker A00Y02317 2007 5,888.39 2022 15 7,500 14 7,000.00 500.00 500.00
<br />Water Interstate Power Systems 150RJC6DT3 Generator 176142-0608 2008 83,125.61 2033 25 137,000 13 71,240.00 65,760.00 5,480.00
<br />62,650.88
<br />Sewer FORD F250 4X2 834 1FTNF20L11EA62781 2001 35,500.30 2031 30 82,500 20 55,000.00 27,500.00 2,750.00
<br />Sewer INT'NATL Work Star (sewer jetter)836 1HTWGAZT4CJ591184 2011 346,416.78 2026 15 450,000 10 300,000.00 150,000.00 30,000.00
<br />Sewer FORD F250 837 1FT7X2A60HEB80040 2016 43,064.00 2029 13 57,000 5 21,923.08 35,076.92 4,384.62
<br />Sewer FORD Transit Van 250 (televising)838 1FTYR3XV2KKB77507 2019 182,397.74 2039 20 292,000 2 29,200.00 262,800.00 14,600.00
<br />51,734.62
<br />4,684,816.24 6,330,070 2,782,876.68 3,515,011.50 377,868.11
<br />2010 125,000.00 Fund Balance 12-31-2020 1,957,247.00
<br />2011 100,000.00 825,629.68
<br />2012 125,000.00 2021 Transfers In (457,000.00) 300,000.00
<br />2013 155,000.00 2021 Budget Expenses 637,000.00 70,000.00
<br />2014 155,000.00 Unfunded Balance 1,005,629.68 55,000.00
<br />2015 120,000.00 35,000.00
<br />2016 82,000.00 460,000.00
<br />2017 92,000.00
<br />954,000.00 Over (Under) funded Transfers 82,131.89
|