|
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 Remaining To Be Annual
<br /> Department Manufacturer Model No. VIN Acq. Cost Year Life Cost 2024 as of 12/24 Life Funded Cost
<br /> Park US CARGO Cargo trailer 306 4X4UTS2103W012414 2003 2,923.00 2028 25 5,000 21 4,200.00 4 800.00 200.00
<br /> Park AEBI TERRATRACTT75(Not replacing) 307 14004 2005 74,839.81 2025 20 - 19 - 1
<br /> Park FORD F250 4X4 Pickup(CC) 308 1FTNF215X5ED18387 2005 25,723.77 mu 19 85,000 19 85,000,00 0
<br /> Park FORD Sterling/Precision(Tanker) 309 2FZACHDC66AV96438 2006 126,221.86 2026 20 202,000 18 181,800.00 2 20,200.00 10,100.00
<br /> Park JACOBSEN Turfcat JRM372 4WD 314 95723402186 2013 21,343.81 2023 10 29,000 11 31,900.00 -1 (2,900.00) 2,900.00
<br /> Park BOB CAT 3400 Utility Vehicle 315 AlNT11764 2013 7,500.00 2028 15 11,000 11 8,066.67 4 2,933.33 733.33
<br /> Park John Deere 5090M Utility Tractor 324 1LV5090MVMM402464 2021 82,042.00 2036 15 119,000 3 23,800.00 12 95,200.00 7,933.33
<br /> Park Normand N86-280H Snow blower 2021. 9,810.00 2036 15 14,000 3 2,800.00 12 11,200.00 933.33
<br /> Park M-B USA 72"Broom 2021 6,825.00 2036 15 10,000 3 2,000.00 12 8,000.00 666.67
<br /> Park Diamond Rear Swing Flail Mower 2021 16,615.00 2036 15 24,000 3 4,800.00 12 19,200.00 1,600.00
<br /> Park Chipper(NEW EQUIPMENT) New in 2024 2024 65,000.00 2039 15 94,000 0 - 15 94,000.00 6,266.67
<br /> Park FORD F350 w/service body and compressor 317 1FTBF3A6XFEA71021 2014 65,593.98 2027 13 91,000 10 70,000.00 3 21,000.00 7,000.00
<br /> Park TORO Groundmaster 4000 318 314000231 2015 57,212.00 2025 10 74,000 9 66,600.00 1 7,400.00 7,400.00
<br /> Park TORO Groundmaster 4000 319 314000237 2015 57,212.00 2025 10 74,000 9 66,600.00 1 7,400.00 7,400.00
<br /> Park BOB CAT 3400 Utility Vehicle(added 2017) 320 A1NT30458 2017 7,900.00 2032 15 14,000 7 6,533.33 8 7,466.67 933.33
<br /> Park John Deere Z920M Mower 321 1TC920MELKT070096 2019 11,510.96 2029 10 15,000 5 7,500.00 5 7,500.00 1,500.00
<br /> Park Kromer F0-1 322 400 2019 36,660.50 2029 10 47,000 5 23,500.00 5 23,500.00 4,700.00
<br /> Park FORD F350 Pickup 323 1FDRF3H65LEE48673 2020 54,976.89 2033 13 72,000 4 22,153.85 9 49,846.15 5,538.46
<br /> Total Parks 65,805.13
<br /> Total General Fund 260,091.87
<br /> Storm FORD F250 646 1FTBF2B67BEC30936 2011 25,923.55 NMI 13 45,000 13 45,000.00 0 - -
<br /> Storm Cat T76 74 Compact Track Loader New in 2023 2023 79,000.00 2030 7 95,000 1 13,571.43 6 81,428.57 13,571.43
<br /> Storm Tymco 500x mounted an International 4300-M7 Chassis 647 11.115e110100891/2014075.595028.1 2015 272,612.45 2027 12 400,000 9 300,000.00 3 100,000.00-Ik , , 33,333.33
<br /> Storm Water Fund Total: 46,904.76
<br /> Water Custom Water tower(fluted column) 500,000 gallon 2012 517,019.07 2032 20 780,000 12 468,000.00 8 312,000.00 39,000.00
<br /> Water CAT 446B Backhoe 703 05BL00672 1995 88,281.05 2026 31 150,000 29 140,322.58 2 9,677.42 4,838.71
<br /> Water REDIHAUL WOLFPAC Trailer(Not replaced) 705 4755121T5K1005396 1989 2,129.75 2025 36 - 35 - 1 - -
<br /> Water FORD 4X4 F150 Super Cab Ordered 2023 25,761.85 2036 13 60,000 1 4,615.38 12 55,384.62 4,615.39
<br /> Water InterrtatePower Systems Generator GG10BK183A1N(Booster Station) 94100500215 2021 136,885.00 2046 25 240,000 3 28,800.00 22 211,200.00 9,600.00
<br /> Water BOBCAT 5650 T4 skid steer 708 AU827772 2019 40,403.10 2026 7 52,000 5 37,142.86 2 14,857.14 7,428.57
<br /> Water FORD F350 Pickup 709 1FT8X3A64FEB55441 2014 64,414.70 2027 13 90,000 10 69,230.77 3 20,769.23 6,923.08
<br /> Water FORD F150 4x4 Super Cab(ordered) 710 1FTFX1EG3HKD34430 2017 33,120.00 2030 13 46,000 7 24,769.23 6 21,230.77 3,538.46
<br /> Water Nilfisk SC6000 36C Ecoflex Floor scrubber 711 3510191100158 2019 26,463.84 2034 15 39,000 5 13,000.00 10 26,000.00 2,600.00
<br /> Water BOBCAT Hydraulic Frost Breaker AO0Y02317 2007 5,888.39 2023 16 7,500 17 7,968.75 -1 (468.75) 468.75
<br /> Water '"t"""`r,,,,,sn ,,, 150RJC6DT3Generator 176142-0608 2008 83,125.61 2033 25 146,000 16 93,440.00 9 52,560.00 5,840.00
<br /> Water Fund Total: 84,852.95
<br /> Sewer FORD F2504X2 834 1FTNF20L11EA62781 2001 35,500.30 2031 30 82,500 23 63,250.00 7 19,250.00 2,750.00
<br /> Sewer INTNATL Work Star)sewer letter) 836 1HTWGAZT4C1591184 2011 346,416.78 2026 15 500,000 13 433,333.33 2 66,666.67 33,333.34
<br /> Sewer FORD F250 837 1FT7X2A60HEB80040 2016 43,064.00 2029 13 60,000 8 36,923.08 5 23,076.92 4,615.38
<br /> Sewer FORD Transit Van 250(televising) 838 1FTYR3XV2KKB77507 2019 182,397.74 2039 20 292,000 5 73,000.00 15 219,000.00 14,600.00
<br /> Sewer Fund Total: 55,298.72
<br /> 5094,918.69 7,125,500 4,032,350.75 3,069,149.25 447,148.30
<br /> 2010 125,000.00 Fund Balance 12-31-2022 2,314,637
<br /> 2011 100,000.00 1,717,714 2024 Budgeted transfers
<br /> 2012 125,000.00 2023 Transfers In (465,000) General Fund 350,000.00
<br /> 2013 155,000.00 2023 Budget Expenses 459,000 Water Fund 90,000.00
<br /> 2014 155,000.00 2024 Transfers In (550,000) Sewer Fund 60,000.00
<br /> 2015 120,000.00 2024 Budget Expenses 307,000 Storm Water 50,000.00
<br /> 2016 82,000.00 550,000.00
<br /> 2017 92,000.00 Unfunded Balance 1,468,714
<br /> 954000.00 Over(Under)funded Transfers 102,851.70
<br />
|