|
FIXED ASSET SCHEDULE
<br />PUBLIC WORKS
<br />STREETS ASSET REPLACEMENT PROGRAM 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
<br />1.27993225 1.31833022 1.35788013 1.39861653 1.44057502 1.48379228 1.52830604 1.57415523 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366 1.93601237 1.994092743 2.053915525 2.115532991
<br />FIXED ASSET
<br /># YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2024
<br />EST.
<br />ACTUAL
<br />2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041
<br />2015
<br />1464 2010 FORD 1 F150 PICKUP -SIGN TRUCK (if ev) 15 1 31,500 - - 85,000 - - - - - - - - - - - - - 169,498 - -
<br />TBD 2024 FORD 2 F150 4X4 /FORD LIGHTNING 15 1 31,500 - 62,076 - - - - - - - - - - - - - 113,344 - -
<br />1657 2020 FORD 6 F150 PICKUP 4X4 EXTENDED CAB 15 1 62,000 - - - - - - - - - - - - 109,847 - - - - - -
<br />1601 2017 FORD 8 F350 PICKUP 4X4 CREW CAB 15 1 45,000 - - - - - - - - - 72,962 - - - - - - - - -
<br />1421 2008 FORD 9 F450 MINI DUMP 2 TON 4X4 w/plow 15 1 63,000 - - 65,000 - - - - - - - - - - - - - - 129,397 -
<br />1712 2022 FORD 10 F450 MINI DUMP 2 TON 4X4 w/plow 15 1 63,000 - - - - - - - - - - - - - 114,967 - - - - -
<br />318,000 - 62,076 150,000 - - - - - - 72,962 - - 109,847 114,967 - 113,344 169,498 129,397 -
<br />1508 2013 IHC 14 7400 DUMP TRUCK 15-25 1 181,859 - - - - - - - - - - - - - 331,870 - - - - -
<br />1186 2003 STERLING 11 M8500 DUMP TRUCK 15-25 1 187,500 - - - - - 251,528 - - - - - - - - - - - - -
<br />tbd 2024 FREIGHTLINER 13 2024 FREIGHTLINER 108SD 15-25 1 263,313 173,564 173,564 - - - - - - - - - - - - - - - -
<br />820,172 173,564 173,564 - - - 251,528 - - - - - - - 331,870 - - - - -
<br />1450 2010 VERMEER BRANCH CHIPPER 32,105 - - - - - - - - - - - - - - - - 75,000 - -
<br />1425 2008 FORD 17 F750 HIGH RANGER AERIAL TRUCK 15 1 140,000 - - - - 195,806 - - - - - - - - - - - - -
<br />1670 2022 BOBCAT BOBCAT 10-15 1 43,723 - - - - - - - - - - - 61,152 - - - - - - -
<br />1669 2020 JOHN DEERE 524L #32 524L FRONT END LOADER 20 1 160,000 - - - - - - - - - - - - - - - - - 328,626 -
<br />375,828 - - - - 195,806 - - - - - - 61,152 - - - - 75,000 328,626 -
<br />2017 DOOSAN AIR COMPRESSOR PULL BEHIND 20-25 1 23,350 - - - - - - - - - - - - - - - - 46,562 - -
<br />2017 DOOSAN JACK HAMMER 10-15 1 6,000 - - - - - 6,429 - - - - - - - - - - - 12,323 -
<br />1997 RHINO PD55 POST POUNDER 15-25 1 5,000 - - - - - - - 7,642 - - - - - - - - - 10,270 -
<br />1656 2019 STEPP 43 CRACK SEALER 15-20 1 45,000 - - - - - - - - - - - 77,405 - - - - - - -
<br />1671 2020 WACKER NEUSON WACKER NEUSON RD12A-90 ROLLER 15-20 1 15,000 - - - - - - - - - - - - 26,576 - - - - - -
<br />1672 2020 STEPP SPH-2.0T ASPHALT HOT BOX 15-20 1 50,000 - - - - - - - - - - - - 88,586 - - - - - -
<br />1997 WHACKER WP 1550AW VIBROPLATE 20-30 1 3,000 - - - - 5,000 - - - - - - - - - - - - - -
<br />2018 ERSKINE 1600 2418 - 61" SNOWBLOWER (1) 15-20 1 5,000 - - - - - - - - - - - - - - - - - - -
<br />1727-1728 2022 BOBCAT 52" & 60" ANGLE BROOMS 10-15 2 10,000 - - - - - - - - - - - 12,340 - - - - - - -
<br />1183 2021 TOWMASTER T-5T SINGLE AXEL TRAILER 15-20 1 15,000 - - - - - - - - - - - - - - - - - - -
<br />TBD 2023 FELLING FT14DT-16 #30 Dump Trailer 15-20 1 18,170 -
<br />1182 1999 TOWMASTER T-10DDT TANDEM AXEL TRAILER 15-20 1 15,000 - - - - - - - - - - - - - - - 29,040 - - -
<br />2015 WHACKER BS50-2I DIRT COMPACTOR 15 1 2,550 - - - - - - - - 3,542 - - - - - - - - - -
<br />1579 2016 GRACO LINELAZER STREETS PAINTER 3900 15 1 10,000 - - - - - - - 15,283 - - - - - - - - - - -
<br />2019 CADLINK VINYL CUTTER/PRINTER 15 1 7,500 - - - - - - - - - - 11,344 - - - - - - - -
<br />2019 NETWORK SWITCH 6 1 1,290 - - 1,290 - - - - - 1,290 - - - - - 1,290 - - - -
<br />WIFI ROUTER 6 1 600 - - 600 - - - - - 600 - - - - - 600 - - - -
<br />GARAGE & OFFICE COMPUTERS 6 4 800 3,296 3,300 - - - - 3,395 - - - - 3,497 - - - - 3,602 - -
<br />1675 2020 GASBOY GAS PUMPS 15-20 2 15,270 - - - - - - - - - - - - 45,000 - - - - - -
<br />2022 WELDER 7 1 5,000 - - - - - - 7,419 - - - - - - 9,124 - - - - -
<br />2022 PW SUPER OFFICE BUILD-OUT / COMPUTER 6 1 2,500 - - - - - 3,601 - - - - - 4,300 - - - - - 5,135 -
<br />2022 PRESSURE WASHER 7 1 1,657 - - - - - - 2,459 - - - - - 2,936 - - - - - -
<br />291,687 3,296 3,300 1,890 - 5,000 10,031 13,272 22,925 5,432 - 11,344 97,543 163,098 9,124 1,890 29,040 50,164 27,728 -
<br />TOTAL STREETS 176,860 238,940 151,890 - 200,806 261,559 13,272 22,925 5,432 72,962 11,344 158,694 272,945 455,961 1,890 142,384 294,662 485,751 -
<br />251,528 - -
<br />503,994 973,797 1,043,219
<br />176,860 151,890 - 200,806 10,031 13,272 5,432 72,962 11,344 158,694 272,945 455,961 1,890 142,384
<br />FOOTNOTES 22,925
<br />(1) REPLACEMENT MADE RETAINED FOR BACKUP
<br />Specialty Equipment
<br />Fleet
<br />Plows/Dump Trucks
<br />Heavy Equipment
<br /> ANNUAL INFLATION OR ESTIMATED ACTUAL
<br />hours based
|