|
City of Mounds View
<br />Vehicle and Equipment Replacement Fund
<br />Target Actual
<br />Estimated Age Replacement Replacement Balance New
<br />Veh.Year Original Replace Replacement In Balance Balance Remaining To Be Annual
<br />Department Manufacturer Model No.VIN Acq.Cost Year Life Cost 2020 as of 12/20 as of 12/20 Life Funded Cost
<br />Park US CARGO Cargo trailer 306 4X4UTS2103W012414 2003 2,923.00 2028 25 5,000 17 3,400.00 3,400.00 8 1,600.00 200.00
<br />Park AEBI TERRATRAC TT75 (Not replacing)307 14004 2005 74,839.81 2025 20 - 15 - - 5 - -
<br />Park FORD F250 4X4 Pickup (CC)308 1FTNF215X5ED18387 2005 25,723.77 2023 18 40,000 15 33,333.33 33,333.33 3 6,666.67 2,222.22
<br />Park FORD Sterling/Precision (Tanker)309 2FZACHDC66AV96438 2006 126,221.86 2026 20 200,000 14 140,000.00 140,000.00 6 60,000.00 10,000.00
<br />Park FORD F350 Pickup (To be Ordered)310 Ordered 2020 54,976.89 2033 13 72,000 0 - - 13 72,000.00 5,538.46
<br />Park JACOBSEN Turfcat JRM372 4WD 314 95723402186 2013 21,343.81 2023 10 29,000 7 20,300.00 20,300.00 3 8,700.00 2,900.00
<br />Park BOB CAT 3400 Utility Vehicle 315 AJNT11764 2013 7,500.00 2023 10 9,000 7 6,300.00 6,300.00 3 2,700.00 900.00
<br />Park TBD Place holder to replace AEBI 2013 2028 15 100,000 7 46,666.67 46,666.67 8 53,333.33 6,666.67
<br />Park AEBI TERRATRAC TT705 (not replacing)316 9098 2013 130,384.23 2028 15 - 7 - - 8 - -
<br />Park AEBI AEBI/SMWA Rev CF225 mower (not replacing)2013 10,686.49 2028 15 - 7 - - 8 - -
<br />Park AEBI Lastec 126" Batwing mower (not replacing)2013 16,975.00 2028 15 - 7 - - 8 - -
<br />Park FORD F350 w/service body and compressor 317 1FTBF3A6XFEA71021 2014 65,593.98 2027 13 87,000 6 40,153.85 40,153.85 7 46,846.15 6,692.31
<br />Park TORO Groundmaster 4000 318 314000231 2015 57,212.00 2025 10 71,500 5 35,750.00 35,750.00 5 35,750.00 7,150.00
<br />Park TORO Groundmaster 4000 319 314000237 2015 57,212.00 2025 10 71,500 5 35,750.00 35,750.00 5 35,750.00 7,150.00
<br />Park BOB CAT 3400 Utility Vehicle (added 2017)320 AJNT30458 2017 7,900.00 2027 10 13,000 3 3,900.00 3,900.00 7 9,100.00 1,300.00
<br />Park John Deere Z920M Mower 321 1TC920MELKT070096 2019 11,510.96 2029 10 15,000 1 1,500.00 1,500.00 9 13,500.00 1,500.00
<br />Park Kromer FO-1 322 400 2019 36,660.50 2029 10 47,000 1 4,700.00 4,700.00 9 42,300.00 4,700.00
<br />Total Parks 56,919.66
<br />Total General Fund 258,107.18
<br />Storm FORD F250 646 1FTBF2B67BEC30936 2011 25,923.55 2024 13 37,000 9 25,615.38 25,615.38 4 11,384.62 2,846.16
<br />Storm Tymco 500X mounted on International 4300-M7 Chassis 647 1HTJTSKN1EH018891/201407SNF59502BAH 2015 272,612.45 2027 12 355,000 5 147,916.67 147,916.67 7 207,083.33 29,583.33
<br />Storm Water Fund Total:32,429.49
<br />Water Custom Water tower (fluted column)500,000 gallon 2012 517,019.07 2032 20 780,000 8 312,000.00 312,000.00 12 468,000.00 39,000.00
<br />Water CAT 446B Backhoe 703 05BL00672 1995 88,281.05 2026 31 140,000 25 112,903.23 112,903.23 6 27,096.77 4,516.13
<br />Water REDIHAUL WOLFPAC Trailer (Not replaced)705 47SS121T5K1005396 1989 2,129.75 2020 31 - 31 - - 0 - -
<br />Water FORD 4X2 3/4 ton 706 1FTNF20L32EC81193 2002 25,761.85 2020 18 35,000 18 35,000.00 35,000.00 0 - -
<br />Water ONAN Booster Station (generator)J910431288 1990 2021 31 125,000 30 120,967.74 120,967.74 1 4,032.26 4,032.26
<br />Water BOBCAT S650 T4 skid steer 708 ALJ827772 2019 40,403.10 2021 2 3,570 1 1,785.00 1,785.00 1 1,785.00 1,785.00
<br />Water FORD F350 Pickup 709 1FT8X3A64FEB55441 2014 64,414.70 2027 13 85,000 6 39,230.77 39,230.77 7 45,769.23 6,538.46
<br />Water FORD F150 4x4 Super Cab (ordered)710 1FTFX1EG3HKD34430 2017 33,120.00 2030 13 45,000 3 10,384.62 10,384.62 10 34,615.38 3,461.54
<br />Water Advance SC6000 36C Floor scrubber 711 3510191100158 2019 33,120.00 2030 11 45,000 1 4,090.91 4,090.91 10 40,909.09 4,090.91
<br />Water BOBCAT Hydraulic Frost Breaker A00Y02317 2007 5,888.39 2022 15 7,500 13 6,500.00 6,500.00 2 1,000.00 500.00
<br />Water Interstate Power Systems 150RJC6DT3 Generator 176142-0608 2008 83,125.61 2033 25 137,000 12 65,760.00 65,760.00 13 71,240.00 5,480.00
<br />Water Fund Total:69,404.30
<br />Sewer FORD F250 4X2 834 1FTNF20L11EA62781 2001 35,500.30 2031 30 82,500 19 52,250.00 52,250.00 11 30,250.00 2,750.00
<br />Sewer INT'NATL Work Star (sewer jetter)836 1HTWGAZT4CJ591184 2011 346,416.78 2026 15 450,000 9 270,000.00 270,000.00 6 180,000.00 30,000.00
<br />Sewer FORD F250 837 1FT7X2A60HEB80040 2016 43,064.00 2029 13 57,000 4 17,538.46 17,538.46 9 39,461.54 4,384.62
<br />Sewer FORD Ordered 838 1FTSS34P44HB43679 2019 182,397.74 2039 20 292,000 1 14,600.00 14,600.00 19 277,400.00 14,600.00
<br />Sewer Fund Total:51,734.62
<br />4,331,417.43 5,953,070 2,821,757.10 2,821,757.10 3,099,312.90 411,675.58
<br />2010 125,000.00 Fund Balance 12-31-2019 1,904,974.00
<br />2011 100,000.00 916,783.10 2021 Budgeted transfers
<br />2012 125,000.00 2020 Transfers In (454,000.00) General Fund 299,000.00
<br />2013 155,000.00 2020 Budget Expenses 304,100.00 Water Fund 70,000.00
<br />2014 155,000.00 Unfunded Balance 766,883.10 Sewer Fund 55,000.00
<br />2015 120,000.00 Storm Water 33,000.00
<br />2016 82,000.00 457,000.00
<br />2017 92,000.00
<br />954,000.00 Over (Under) funded Transfers 45,324.42 4
|