|
FIXED ASSET SCHEDULE
<br />POLICE DEPARTMENT 1.03 1.03 1.0609 1.092727 1.12550881 1.159274 1.1940523 1.229874 1.26677 1.304773 1.34391638 1.384234 1.425761 1.468534 1.51258972 1.55796742 1.60470644 1.65284763 1.70243306
<br />1.104081 0 1.137203 1.171319 1.206458904 1.242653 1.27993225 1.31833 1.35788 1.398617 1.44057502 1.483792 1.528306 1.574155 1.62137988 1.67002128 1.72012192 1.77172557 1.82487734
<br />ASSET REPLACEMENT PROGRAM
<br />FIXED
<br />ASSET #YEAR MAKE DESCRIPTION LIFE QTY
<br />UNIT
<br />COST 2019
<br />EST.
<br />ACTUAL
<br />2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036
<br />Active Squads
<br />1576 705 2016 DODGE DODGE CHARGER - PATROL 3 1 37,433 41,775 - 33,979 - - - 38,243 - - - 43,043 - - - 48,445 - - - 54,526
<br />1577 706 2016 FORD FORD EXPLORER SUV - PATROL 3 1 39,876 43,880 - 47,696 - - - 50,868 - - - 57,253 - - - 64,439 - - - 72,526
<br />1598 707 2017 DODGE DODGE CHARGER - PATROL 3 1 39,377 - - - 34,998 - 37,129 - - - 41,789 - - - 47,034 - - - 52,938 -
<br />1599 708 2017 DODGE DODGE CHARGER - PATROL 3 1 39,377 - - - 49,052 - - - 52,394 - - - 58,970 - - - 66,372 - -
<br />1629 709 2018 FORD FORD INTERCEPTOR SUV - PATROL 3 1 43,335 - - - 47,948 - - - 53,966 - - - 60,740 - - - 68,363 - -
<br />1630 710 2018 DODGE DODGE CHARGER - PATROL 3 1 32,989 - - - - 36,048 - - - 40,572 - - - 45,664 - - - 51,396 - -
<br />85,655 - 81,675 84,050 83,996 37,129 89,112 52,394 94,539 41,789 100,296 58,970 106,404 47,034 112,884 66,372 119,759 52,938 127,052
<br />Unmarked
<br />1557 6 2016 CHEV CHEV IMPALA - INVESTIGATOR 6 1 24,577 - - - 32,630 - - - - - 37,841 - - - - - 43,896 - - -
<br />1600 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 - - - -
<br />1559 703 2015 DODGE DODGE CHARGER - COURT 7 1 700 - - - - 845 - - - 951 - - - 1,070 - - - 1,204 - -
<br />1482 2011 FORD FORD FUSION - COURT/SCHOOL 7 1 700 - - - 820 - - - 923 - - - 1,039 - - - 1,169 - - -
<br />- - 796 820 1,689 - 896 923 1,901 - 1,008 1,039 2,140 - 1,135 1,169 2,408 - -
<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 NA NEW VARIOUS BODY CAMERAS / VIDEO/WEARABLES 5 23 400 - 7,103 - - 10,562 - - - - 12,244 - - - - - 14,203 - - -
<br />NA NA NEW VARIOUS SQUAD VIDEO CAMERAS 7 7 4,895 - 3,830 - 4,808 - - 42,142 - - 5,913 - - - 51,829 - - 7,273 7,491
<br />NA NA NEW VARIOUS FACILITY VIDEO CAMERAS 5 6 3,680 38,000 24,366 2,500 14,074 15,539 - - - 29,982 - - - - 34,757 - - - - -
<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 - -
<br />38,000 35,299 18,570 22,401 29,359 47,472 3,456 46,102 33,648 12,244 112,735 - 23,994 39,486 56,207 78,002 4,644 7,273 7,491
<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 - - - 5,857 - - - - 6,789 - - - - 7,871 - - - - -
<br />NA NA VARIOUS VARIOUS PBT (BREATHLIZERS)5 10 500 552 552 569 586 603 621 640 659 679 699 720 742 764 787 811 835 860 886 912
<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,312 4,312 3,412 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
<br />NA NA VARIOUS VARIOUS FIREARMS 15 23+ varies 2,208 3,621 2,274 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
<br />NA NA VARIOUS VARIOUS P.DEPT ISSUED SIDE ARMS+HOLSTERS 8-10 23 700 16,100 14,662 - - - - - - - 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
<br />NA NA 2014 VARIOUS BIKES 10 2 1,500 - - 3,412 - - - - - 4,074 - - - - - - - - - -
<br />22,172 23,147 15,396 15,110 6,636 17,273 10,111 8,569 19,689 31,749 20,024 8,161 8,406 20,307 12,809 19,205 9,461 50,671 14,417
<br />3% AVERAGE ANNUAL INFLATION
<br />10
|