|
FIXED ASSET SCHEDULE
<br />PUBLIC WORKS
<br />STREETS ASSET REPLACEMENT PROGRAM
<br />FIXED
<br />ASSET # YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2021
<br />EST.
<br />ACTUAL
<br />2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038
<br />2015
<br />1536 2014 CHEVY 5 PW DIRECTOR - SEDAN 10 1 22,000 - - 32,643 - - - - - - - - - 52,927 - - - - - -
<br />1464 2010 FORD 1 F150 PICKUP 15 1 31,500 - - - - - 41,527 - - - - - - - - - - - - -
<br />1409 2007 FORD 2 F150 4X4 15 1 31,500 - - - 39,144 - - - - - - - - - - - - - - 60,984
<br />1657 2020 FORD 6 F150 PICKUP 4X4 15 1 31,500 - - - - - - - - - - - - - - 54,184 - - - -
<br />1601 2017 FORD 8 F350 PICKUP 4X4 15 1 45,000 - - - - - - - - - - - - 72,962 - - - - - -
<br />1421 2008 FORD 9 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - - - 60,797 - - - - - - - - - - - - - -
<br />1338 2006 FORD 10 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - 57,307 - - - - - - - - - - - - - 86,682 - -
<br />256,500 - - 89,950 39,144 60,797 41,527 - - - - - - 125,889 - 54,184 - 86,682 - 60,984
<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 - - - - - - - - 270,108 - - - - - - - - - -
<br />1181 1995 FORD 12 L8000 DUMP TRUCK 15-25 1 187,500 - - - - 220,000 - - - - - - - - - - - - - -
<br />1582 2016 WESTERN 8 FT PLOW BLADE 15 1 6,682 - - - - - - - - - - 7,830 - - - - - - - -
<br />563,541 - - - - 220,000 - - - 270,108 - 7,830 - - - - - 331,870 - -
<br />1450 2010 VERMEER BRANCH CHIPPER 15 1 32,105 - - - - - 32,105 - - - - - - - - - - - - -
<br />1425 2008 FORD 17 F750 HIGH RANGER AERIAL TRUCK 15 1 140,000 - - - - - - 190,103 - - - - - - - - - - - -
<br />1670 NA BOBCAT BOBCAT 20 1 6,000 5,051 7,500 - - - - - - - - - - - - - - - 71,426 -
<br />1669 2020 JOHN DEERE 524L 524L FRONT END LOADER 20 1 160,000 - - - - - - - - - - - - - - - - - - -
<br />338,105 5,051 7,500 - - - 32,105 190,103 - - - - - - - - - - 71,426 -
<br />2017 DOOSAN AIR COMPRESSOR PULL BEHIND 20-25 1 23,350 - - - - - - - - - - - - - - - - - - -
<br />2017 DOOSAN JACK HAMMER 10-15 1 6,000 - - - - - - - - 6,429 - - - - - - - - - -
<br />1997 RHINO PD55 POST POUNDER 15-25 1 5,000 - - - 6,213 - - - - - - - - - - - - - - -
<br />1656 2019 STEPP 43 CRACK SEALER 15-20 1 45,000 - - - - - - - - - - - - - - - - - - -
<br />1671 2020 WACKER NEUSON WACKER NEUSON RD12A-90 ROLLER 15-20 1 15,000 - - - - - - - - - - - - - - - - - - -
<br />1672 2020 STEPP SPH-2.0T ASPHALT HOT BOX 15-20 1 50,000 - - - - - - - - - - - - - - - - - - -
<br />1997 WHACKER WP 1550AW VIBROPLATE 15-20 1 3,000 - - 3,619 - - - - - - - - - - - - - - - -
<br />2018 ERSKINE 1600 2418 - 61" SNOWBLOWER (1)15-20 1 5,000 - - - - - - - - - - - - - - - - 8,000 - -
<br />1999 BOBCAT 70" ANGLE BROOM 15-20 1 10,000 - - 11,372 - - - - - - - - - - - - - - - -
<br />1183 1998 TOWMASTER T-5T SINGLE AXEL TRAILER 15-20 1 15,000 16,561 16,561 - - - - - - - - - - - - - - - - -
<br />1182 1999 TOWMASTER T-10DDT TANDEM AXEL TRAILER 15-20 1 15,000 - - 18,097 - - - - - - - - - - - - - - - -
<br />2015 WHACKER BS50-2I DIRT COMPACTOR 15 1 2,550 - - - - - - - - - - - 3,542 - - - - - - -
<br />1579 2016 GRACO LINELAZER STREETS PAINTER 3900 13 1 10,000 - - - - - - - - - 14,838 - - - - - - - - -
<br />**NEW CADLINK VINYL CUTTER/PRINTER 15 1 7,500 - - - - - - - - - - - - - 11,344 - - - - -
<br />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 - - - - - - - - - - - - - -
<br />1675 2020 GASBOY GAS PUMPS 15-20 2 15,270 - - - - - - - - - - - - - - - 45,000 - - -
<br />WELDER 25 1 5,000 - - 5,000 - - - - 6,993 - - - - 8,107 - - - - 9,398 -
<br />PW SUPER OFFICE BUILD-OUT / COMPUTER 6,650
<br />RADIOS 989
<br />269,360 16,561 24,200 38,088 6,213 3,296 1,890 - 6,993 6,429 14,838 - 5,432 8,107 11,344 - 45,000 8,000 11,288 -
<br />TOTAL STREETS 21,612 31,700 128,039 45,357 284,093 75,522 190,103 6,993 276,537 14,838 7,830 5,432 133,996 11,344 54,184 45,000 426,551 82,714 60,984
<br />- - - - 270,108 - -
<br />#######501,733 753,789 680,778
<br />21,612 31,700 128,039 45,357 284,093 75,522 190,103 6,993 6,429 14,838 7,830 5,432 133,996 11,344 54,184 45,000 426,551 82,714 60,984
<br />FOOTNOTES
<br />(1) REPLACEMENT MADE RETAINED FOR BACKUP
<br />(2)NOT SCHEDULED FOR REPLACEMENT
<br />Specialty Equipment
<br />Fleet
<br />Plows/Dump Trucks
<br />Heavy Equipment
<br />3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL
<br />12
|