|
UTILITES INFRASTRUCTURE
<br />EQUIPMENT
<br />1.1713193 0 1.2064589 1.2426527 1.2799323 1.3183302 1.3578801 1.3986165 1.440575 1.4837923 1.528306 1.5741552 1.6213799 1.6700213 1.7201219 1.7717256 1.8248773 1.8796237 1.9360124
<br />FIXED ASSET
<br /># 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 />1403 2006 SPRINTER 4 W WATER UTILITY VAN 15 1 30,000 35,140 36,101 - - - - - - - - - - - - - - - - -
<br />1561 2015 FORD 7 D F350 UTILITY 4X4 W /CRANE 10 1 51,750 - - - - - 68,224 - - - - - - - - - - 94,437 - -
<br />81,750 35,140 36,101 - - - 68,224 - 1,000 - - - - - - - - 94,437 - -
<br />-
<br />1438 1999 STERLING 19 S STERLING VACTOR/JETTER 15 1 225,000 - - - - - - - - - - - - - - - - - - -
<br />1644 2018 FORD 15 D L8000 DUMP TRUCK 15-25 187,500 - - - - - - - - - - - - - - - - - 384,110 -
<br />2007 ZIEGLER CAT S GENERATOR 200KW - FOSS RD LS 25-30 1 70,000 - - - - - - - - - - - - 113,497 - - - - - -
<br />1292 2004 FREIGHTLINER 16 W M2 WATER TANKER/FLUSHER 15-20 1 150,000 - - - 190,000 - - - - - - - - - - - - - - -
<br />1517 2013 CASE 590 D BACKHOE 20-25 104,963 - - - - - - - - - - - - - 175,290 - - - - -
<br />737,463 - - - 190,000 - - - - - - - - 113,497 175,290 - - - 384,110 -
<br />1212 2002 SPEEDSHORE D VARIABLE 4X6 TRENCH BOX 25-30 1 5,000 - - - - - - - 6,993 - - - - - - - - - - -
<br />1213 1990 SHORING INT D 8X6, 24" & 48" TRENCH SHORING 25-30 1 5,000 - - - - - - - 6,993 - - - - - - - - - - -
<br />1999 MAGNA TRAK D 100 FERROUS IRON LOCATOR 10 1 1,100 1,288 1,288 - - - - 1,494 - - - - - - - - - 2,007 2,068 -
<br />2013 LINE LOCATOR D RD400 UNDERGROUND LOCATOR 10 2 1,500 - - 1,810 - - - - 2,098 - - - - 2,432 2,505 - - - - -
<br />EST 2008 MINIGAS D OFCH MULTI-GAS MONITOR 5 1 1,100 - - - 1,367 - - - - 1,585 - - - - - - - 2,007 - -
<br />1247 2008 HACH D DR2000 SPECTROPHOTOMETER 5 1 1,500 1,706 1,706 - - - 1,977 - - - - 2,292 - - - - - 2,737 - -
<br />1209 2005 INGERSOL RAND D ROTO HAMMER 10 1 250 - - - - - - - - - 371 - - - - - - - - -
<br />1417 2005 HONDA D EG1500W GENERATOR 10 1 500 - - - - - - - - - 742 - - - - - - - - -
<br />EST 2005 HOMELITE D 3" TRASH PUMP 250 GPM 5-10 1 1,000 - - - - 1,280 - - - - - 1,528 - - - - - - - -
<br />EST 2005 HOMELITE D 2" TRASH PUMP 173 GPM 5-10 1 1,000 1,137 1,137 - - - 1,318 - - - - - 1,574 - - - - - - 1,936
<br />EST 2005 NA D ELECTRIC SEWER SNAKE 5-10 1 2,000 2,343 2,343 - - - - - - - 2,968 - - - - 3,440 - - - -
<br />EST 2005 NA D 12V POWER VENT 5-10 1 1,500 - - - - 1,920 - - - - - 2,433 - - - - - - - 2,904
<br />1246 2005 MOHAWK D PERSONNEL SAFETY LIFT 5-10 1 1,500 - - - - - - 2,037 - - - - - - 2,505 - - - - -
<br />2018 HACH WATER TESTING EQUIPMENT 5-10 3,445 - - - - - 4,542 - - - - - - 5,586 - - - - - -
<br />EST 2005 STIHL D TS460 PARTNER SAW 5-10 1 1,000 1,171 1,171 - - - - - - - 1,484 - - 1,001 1,001 - - - - -
<br />32,395 7,645 7,645 1,810 1,367 3,200 7,837 3,530 16,084 1,585 5,564 6,254 1,574 9,019 6,011 3,440 - 6,752 2,068 4,840
<br />2016 RTA D RTA FLEET SOFTWARE (SHOP)15-20 1 6,000 - - - - - 9,000 - - - - - - - - - - - - -
<br />D NETWORK SWITCHES 7-10 10 1,000 - - - - 1,200 - - - - - - 1,200 - - - - - - 1,200
<br />D COMPUTERS/PRINTERS 7-10 10 1,000 2,500 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 - 2,500 -
<br />1442 2009 SENSUS D COMPUTER SOFTWARE 20 1 15,000 - - - - - - 20,368 - - - - - - - - - -
<br />23,000 2,500 2,500 - 2,500 1,200 11,500 20,368 2,500 - 2,500 - 3,700 - 2,500 - 2,500 - 2,500 1,200
<br />TOTAL UTILITY 874,608 45,285 46,246 1,810 193,867 4,400 87,561 23,899 19,584 1,585 8,064 6,254 5,274 122,515 183,802 3,440 2,500 101,189 388,678 6,040
<br />EQUIPMENT SPECIFIC TO WATER 180,000 35,140 36,101 0 190,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
<br />EQUIPMENT SPECIFIC TO SEWER 295,000 0 0 0 0 0 0 0 0 0 0 0 0 113,497 0 0 0 0 0 0
<br />DUAL PURPOSE EQUIPMENT 399,608 10,145 10,145 1,810 3,867 4,400 87,561 23,899 18,584 1,585 8,064 6,254 5,274 9,019 183,802 3,440 2,500 101,189 388,678 6,040
<br />874,608 45,285 46,246 1,810 193,867 4,400 87,561 23,899 18,584 1,585 8,064 6,254 5,274 122,515 183,802 3,440 2,500 101,189 388,678 6,040
<br />ASSET REPLACEMENT PRORGRAM
<br />Technology Reassigned from Capital Equipment Fund
<br />3% AVERAGE ANNUAL INFLATION
<br />Fleet Reassigned from Capital Equipment Fund
<br />Heavy Equipment Reassigned from Capital Equipment Fund
<br />Specialty Equipment Reassigned from Capital Equipment Fund
<br />21
|