|
FIXED ASSET SCHEDULE
<br />PUBLIC WORKS
<br />STREETS ASSET REPLACEMENT PROGRAM
<br />FIXED
<br />ASSET #YEAR MAKE DESCRIPTION LIFE QTY UNIT COST 2018
<br />EST.
<br />ACTUAL
<br />2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035
<br />2015
<br />1536 2014 CHEVY 5 MALIBU PW DIRECTOR 15 1 22,000 - - - - - - - - - - - - 32,643 - - - - - -
<br />1464 2010 FORD 1 F150 PICKUP 15 1 31,500 - - - - - - - - 41,527 - - - - - - - - - -
<br />1289 2004 FORD 2 MECH F150 4X4 15 1 31,500 - - 34,779 - - - - - - - - - - - - - - 54,184 -
<br />1409 2007 FORD 6 F150 PICKUP 4X4 PW SUPER 15 1 31,500 - - - - - 38,003 - - - - - - - - - - - - -
<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 - - - - - - 59,026 - - - - - - - - - - - -
<br />1338 2006 FORD 10 F450 MINI DUMP 2 TON 4X4 15 1 47,500 - - - - 55,638 - - - - - - - - - - - - - -
<br />256,500 - - 34,779 - 55,638 38,003 59,026 - 41,527 - - - 32,643 - - 72,962 - 54,184 -
<br />1508 2013 IHC 14 7400 DUMP TRUCK 15-25 1 181,859 - - - - - - - - - - - - - - - - - - 322,203
<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 - - - - 322,203
<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 - - - - - - - - 184,566 - - - - - - - - - -
<br />NA BOBCAT BOBCAT REPLACEMENT PROGRAM NA 1 6,000 6,623 2,500 6,788 6,958 7,132 7,310 7,493 7,681 7,873 8,069 8,271 8,478 8,690 8,907 9,130 9,358 9,592 9,832 10,077
<br />1216 1995 JOHN DEERE 32 444G FRONT END LOADER 20 1 160,000 - - - 179,259 - - - - - - - - - - - - - - -
<br />338,105 6,623 2,500 6,788 186,217 7,132 7,310 7,493 7,681 224,544 8,069 8,271 8,478 8,690 8,907 9,130 9,358 9,592 9,832 10,077
<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 />1222 1999 CRAFCO 200 PAVEMENT ROUTER (2)15-25 1 20,000 - - - - - - - - - - - - - - - - - -
<br />1189 1997 BEARCAT 43 BK CRACK SEALER (REPL W/ABOVE)15-25 1 45,000 48,709 - 49,684 - - - - - - - - - - - - - - - -
<br />1201 1995 ROSCO 42 VIBRASTAT 111(3) ASPHALT ROLLER 15-25 1 15,000 - - - 17,058 - - - - - - - - - - - - - - -
<br />1202 1999 STEPP 51 SPH-2.0T ASPHALT HOT BOX 15-25 1 50,000 - - 55,204 - - - - - - - - - - - - - - - -
<br />1997 WHACKER WP 1550AW VIBROPLATE 15-25 1 3,000 - - - - - 3,619 - - - - - - - - - - - - -
<br />1998 TRAFFIC MANAGER SY3913060 ARROW BOARD 30X60"15-25 1 9,000 - - - - - - 11,184 - - - - - - - - - - - -
<br />1997 ERSKINE 2418 - 61" SNOWBLOWER (1)15-25 1 5,000 - - - - - - - - - - - - - - - - - - -
<br />1999 BOBCAT 70" ANGLE BROOM 15-20 1 10,000 - - - 11,372 - - - - - - - - - - - - - - -
<br />1184 2000 MASTER TOW CAR DOLLY (2)NA 1 15,000 - - - - - - - - - - - - - - - - - - -
<br />1183 1998 TOWMASTER T-5T SINGLE AXEL TRAILER 20 1 15,000 - - 16,561 - - - - - - - - - - - - - - - -
<br />1182 1999 TOWMASTER T-10DDT TANDEM AXEL TRAILER 20 1 15,000 - - - - 17,570 - - - - - - - - - - - - - -
<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 />1991 MUD TUB CONCRETE HAULER/DUMPER (2)NA 1 10,000 - - - - - - - - - - - - - - - - - - -
<br />258,900 48,709 - 121,449 28,430 17,570 3,619 17,397 - - - - 6,429 14,838 - 3,542 - - - -
<br />TOTAL STREETS 55,332 2,500 163,016 214,647 300,340 48,933 83,916 7,681 266,071 8,069 8,271 285,015 56,171 16,737 12,672 82,320 9,592 64,016 332,281
<br />- - 174,887 - - - 270,108 -
<br />55,332 2,500 (11,871) 214,647 300,340 48,933 83,916 7,681 266,071 8,069 8,271 14,907 56,171 16,737 12,672 82,320 9,592 64,016 332,281
<br />FOOTNOTES 326,032
<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
|