FIXED ASSET SCHEDULE
<br />POLICE DEPARTMENT 1.0609 1.092727 1.12550881 1.159274 1.1940523 1.229874 1.26677 1.304773 1.3439164 1.384234 1.425761 1.468533713 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306 1.75350605
<br />1.137203 1.171319 1.2064589 1.242653 1.2799323 1.31833 1.35788 1.398617 1.440575 1.483792 1.528306 1.574155225 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734 1.87962366
<br />ASSET REPLACEMENT PROGRAM
<br />FIXED
<br />ASSET # YEAR MAKE DESCRIPTION LIFE QTY
<br />UNIT
<br />COST 2020
<br />EST.
<br />ACTUAL
<br />2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037
<br />Active Squads
<br />1576/tbd 705/711 2016/2020 DODGE DODGE CHARGER / DURANGO SUV - PATROL 3-4 1 37,433 33,979 47,665 - - 38,243 - - - 43,043 - - - 48,445 - - - 54,526 -
<br />1577 706 2016 FORD FORD EXPLORER SUV - PATROL 3-4 1 39,876 47,696 - 50,523 - 50,868 - - - 57,253 - - - 64,439 - - - 72,526 -
<br />1598 707 2017 DODGE DODGE CHARGER - PATROL 3-4 1 39,377 - 39,377 - 37,129 - - 41,789 - - - 47,034 - - - 52,938 - -
<br />1599 708 2017 DODGE DODGE CHARGER - PATROL 3-4 1 39,377 - - 40,559 - - 52,394 - - - 58,970 - - - 66,372 - - - 74,702
<br />1629 709 2018 FORD FORD INTERCEPTOR SUV - PATROL 3-4 1 43,335 - - - 49,387 - - 53,966 - - - 60,740 - - - 68,363 - - -
<br />1630 710 2018 DODGE DODGE CHARGER - PATROL 3-4 1 32,989 - - - 37,129 - - 40,572 - - - 45,664 - - - 51,396 - - -
<br />81,675 87,042 91,082 49,387 37,129 126,241 52,394 94,539 41,789 100,296 58,970 106,404 47,034 112,884 66,372 119,759 52,938 127,052 74,702
<br />Unmarked
<br />1557 6903 2016 CHEV CHEV IMPALA - INVESTIGATOR 6 1 24,577 - - - 32,630 - - - - 37,841 - - - - - 43,896 - - - -
<br />1600 6901 2017 CHEV CHEV IMPALA - CHIEF 6 1 23,000 - - - - 33,446 - - - - 38,787 - - - - - 44,993 - - -
<br />1631 6902 2018 FORD FORD TAURUS - CAPTAIN 6 1 31,191 - - - - - 34,282 - - - - 39,951 - - - - - 46,343 - -
<br />- - - 32,630 33,446 34,282 - - 37,841 38,787 39,951 - - - 43,896 44,993 46,343 - -
<br />Retired To Other Services (1)
<br />1558 702 2015 FORD FORD INTERCEPTOR SUV - CSO 7 1 700 - - - 845 - - - 951 - - - 1,070 - - - 1,204 - - -
<br />1513 698 2013 FORD FORD INTERCEPTOR SUV - RESERVE 7 1 700 796 - - - - 896 - - - 1,008 - - - 1,135 - - - 1,277 -
<br />1482 UM 2011 FORD FORD FUSION - COURT/SCHOOL 7 1 700 - - 820 - - - 923 - - - 1,039 - - - 1,169 - - - 1,316
<br />796 - 820 845 - 896 923 951 - 1,008 1,039 1,070 - 1,135 1,169 1,204 - 1,277 1,316
<br />Technology
<br />NA NA 2018 VARIOUS SQUAD COMPUTERS 5 9 4,550 - - 3,519 - 47,472 - 3,960 - - 55,033 - 4,729 - 63,799 - - - -
<br />1486 NA 2011 VARIOUS ETHERNET SWITCH 10 1 13,000 13,000 - - - - - - - - - - 19,868 - - - - - - -
<br />NA 2018 VARIOUS PANASONIC INTEGRATED VIDEO SYSTEM 5 varies varies 2,500 3,097 4,808 40,175 - - 42,142 29,982 12,244 5,913 - - 34,757 51,829 14,203 - 7,273 40,293 -
<br />NA NA VARIOUS VARIOUS PORTABLE/SQUAD RADIOS (2) varies varies varies 3,070 - - 3,257 - 3,456 - 3,666 - 51,789 - 4,126 - 4,378 - 4,644 - 4,927 -
<br />18,570 3,097 8,327 43,433 47,472 3,456 46,102 33,648 12,244 112,735 - 23,994 39,486 56,207 78,002 4,644 7,273 45,220 -
<br />Specialty Equipment
<br />NA NA ~ 2005 VARIOUS REDMAN SUIT & TASER SUIT 15 1 ea 1,000 - - - - - - 1,318 1,358 - - - - - - - - - - -
<br />NA NA VARIOUS VARIOUS BULLET RESISTANT SHIELDS 5 2 2,500 - - - 6,300 - 6,789 - - - - 7,871 - - - - - -
<br />NA NA VARIOUS VARIOUS PBT (BREATHLIZERS)5 10 500 569 - 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912 940
<br />NA NA VARIOUS VARIOUS RIOT GEAR - 12 sets total 10 6/6 1,000 - - - - 7,456 - - - - 8,643 - - - - 10,020 - - - -
<br />NA NA VARIOUS VARIOUS TASERS/BATTERIES 5 23 1,500 3,412 5,100 3,514 3,619 3,728 3,840 3,955 4,074 4,196 4,322 4,451 4,585 4,722 4,864 5,010 5,160 5,315 5,475 5,639
<br />NA NA VARIOUS VARIOUS FIREARMS 15 23+varies 2,274 1,764 2,343 2,413 2,485 2,560 2,637 2,716 2,797 2,881 2,968 3,057 3,148 3,243 3,340 3,440 3,543 3,650 3,759
<br />NA NA VARIOUS VARIOUS P.DEPT ISSUED SIDE ARMS+HOLSTERS 8-10 23 700 - - - - - - - - 20,700 - - - - - - - 36,675 - -
<br />NA NA VARIOUS VARIOUS SQUAD RADAR 4 7 1,200 2,729 - 2,811 - 2,982 3,072 - - 3,357 3,457 - - 3,778 3,891 - - 4,252 4,380 -
<br />NA NA VARIOUS VARIOUS HAND HELD RADAR 10 2 3,000 3,000 - - 3,000 - - - - - - - - - - - - - - -
<br />NA NA 2014 VARIOUS BIKES 10 2 1,500 3,412 - 3,514 - - - - 4,074 - - - - - - - - - - -
<br />15,396 6,864 12,767 9,636 17,273 16,411 8,569 19,689 31,749 20,024 8,161 8,406 20,307 12,809 19,205 9,461 50,671 14,417 10,338
<br />3% AVERAGE ANNUAL INFLATION OR ESTIMATED ACTUAL
|