Fiscal Year 2021ACTUAL 2016ACTUAL 2017ACTUAL2018ACTUAL2019BUDGET2020EST. ACTUAL2020BUDGET2021GENERAL FUND EXPENDITURES DETAILCABLE FRANCHISE101‐4110‐19‐0000 CF REGULAR EMPLOYEE6,143$ 6,330$ 7,259$ 7,999$ 8,319$ 8,320$ 8,515$ 2.36% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS 101‐4121‐19‐0000 CF PERA461 475 544 600 624 624 639 2.36% BASED ON CURRENT PERA FUNDING RATE 101‐4122‐19‐0000 CF FICA/MEDICARE470 484 555 612 636 636 651 2.36% BASED ON ER 7.65% OF GROSS101‐4131‐19‐0000 CF INSURANCE HEALTH 1,690 1,652 1,723 1,793 1,869 1,869 1,972 5.51% SPLIT 9.4% PREMUIM INCREASE IN 2021101‐4211‐19‐0000 CF OPERATING SUPPLIES‐ 86 ‐ 20 400 400 408 2.00% 2021 PROJECTED RUN RATE101‐4221‐19‐0000 CF SUPPLIES‐ EQUIPMENT‐ ‐ ‐ 32 1,025 1,025 1,046 2.00% 2021 PROJECTED RUN RATE101‐4307‐19‐0000CF NSCC OPERATING SUPPORT28,736 29,402 30,529 29,777 31,716 31,716 32,350 2.00% 2021 PROJECTED RUN RATE101‐4310‐19‐0000 CF MISC CONTRACTED SERVICES5,203 6,961 6,961 3,403 3,772 3,772 3,970 5.26% 2021 Annual website support ‐SEE MISC CONTRACTED SPREADSHEET101‐4341‐19‐0000 CF TRAINING, CONF & MTG‐ ‐ ‐ ‐ ‐ ‐ ‐ 0.00%TOTAL 42,703$ 45,391$ 47,572$ 44,237$ 48,361$ 48,362$ 49,551$ 2.46%POLICE PROTECTION101‐4110‐21‐0000 PD REGULAR EMPLOYEE2,170,749$ $ 2,014,439 $ 1,934,184 1,976,883$ 2,074,359$ 1,878,448$ 2,157,963$ 4.03%2021 INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS AND UNIFORM 2020 EXCLUDES PR COSTS FOR COVID ‐19 ACTIVITY / CARES101‐4110‐21‐0100 PD MECHANIC ALLOC‐WAGES 16,097 17,242 17,894 18,476 19,212 19,212 19,854 3.34% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS 101‐4110‐21‐0200 PD DARE ALLOC‐WAGES 8,257 7,726 7,947 8,215 10,749 8,612 8,913 ‐17.08% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS 101‐4111‐21‐0000 PD OVERTIME EMPLOYEE 68,103 64,615 105,139 98,673 98,120 115,000 108,034 10.10% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS 101‐4111‐21‐0100 PD MECHANIC OVERTIME EMPLOYEE 164 150 71 159 162 162 165 2.00% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS 101‐4111‐21‐0200 PD DARE ALLOC ‐ OT118 228 371 538 765 765 891 16.47% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS 101‐4111‐21‐0300 PD SAFE & SOBER ‐ OT26,843 28,732 31,805 37,916 32,250 32,370 34,566 7.18% PASS THROUGH COSTS NO NET LEVY IMPACT101‐4111‐21‐0400 PD COURT OVERTIME10,274 5,721 3,927 4,316 4,500 3,000 4,700 4.44% Based on estimated run rate101‐4111‐21‐0500 PD OTHER REIMB OT‐ ‐ 15,379 ‐ 10,000 ‐ ‐ ‐100.00%101‐4121‐21‐0000 PD PERA359,051 332,437 322,711 340,375 376,846 381,245 391,636 3.92% BASED ON CURRENT PERA FUNDING RATE 101‐4121‐21‐0100 PD MECHANIC ALLOC‐ PERA1,297 1,371 1,423 1,474 1,453 1,453 1,501 3.33% BASED ON CURRENT PERA FUNDING RATE 101‐4121‐21‐0200 PD DARE ALLOC‐ PERA1,537 1,442 1,487 1,621 2,050 2,050 2,142 4.49% BASED ON CURRENT PERA FUNDING RATE 101‐4122‐21‐0000 PD FICA/MEDICARE37,946 38,792 37,432 38,224 41,903 41,903 43,313 3.36% DEPT SUMMARIES FICA101‐4122‐21‐0100 PD MECHANIC ALLOC‐SS/MEDICARE1,251 1,342 1,383 1,430 1,470 1,470 1,519 3.34% BASED ON ER 7.65% OF GROSS101‐4122‐21‐0200 PD DARE ALLOC‐SS/MEDICARE127 119 123 128 167 167 173 3.62% BASED ON 1.45% ER MEDICARE RATE101‐4131‐21‐0000 PD INSURANCE HEALTH337,706 304,352 308,057 318,684 326,054 331,949 354,123 8.61% SPLIT 9.4% PREMUIM INCREASE IN 2021 & TURNOVER PLAN CHANGES 101‐4131‐21‐0100PD MECHANIC ALLOC‐HLTH INS445 655 840 958 1,008 564 1,058 4.96% SPLIT 9.4% PREMUIM INCREASE IN 2021101‐4131‐21‐0200 PD HEALTH ‐ DARE1,629 1,394 1,450 1,506 1,907 1,560 2,012 5.51% SPLIT 9.4% PREMUIM INCREASE IN 2021101‐4135‐21‐0000 PD WORKER'S COMP INS68,584 60,750 71,027 83,558 87,105 91,376 106,025 21.72% BASED ON 2020/2021 RENEWAL 101‐4212‐21‐0100 PD MOTOR FUELS45,023 47,085 47,154 36,821 56,882 38,882 44,526 ‐21.72% 2020 contracted cost per gal $2.13 / 2021 projection $2.28 / 3yr avg usage101‐4220‐21‐0000 PD SQUADS CLEANING1,165 1,232 1,399 1,336 1,900 1,900 1,938 2.00% 2021 PROJECTED RUN RATE101‐4221‐21‐0000 PD SUPPLIES‐ EQUIPMENT113 138 537 3,959 2,000 725 2,040 2.00% 2021 PROJECTED RUN RATE101‐4221‐21‐0100 PD VEHICLE REPAIRS/PARTS12,955 30,315 11,045 16,144 16,000 14,145 16,000 0.00% 2021 PROJECTED RUN RATE101‐4226‐21‐0000 PD GENERAL SUPPLIES22,455 12,593 19,439 17,894 21,500 16,508 21,500 0.00% 2021 PROJECTED RUN RATE101‐4226‐21‐0100 PD SHOP SUPPLIES‐ ‐ 100 536 500 500 510 2.00% 2021 PROJECTED RUN RATE101‐4226‐21‐0200 PD DARE SUPPLIES2,718 2,719 1,981 2,595 2,000 125 2,040 2.00% 2021 PROJECTED RUN RATE101‐4226‐21‐0500 PD VEST GRANT SUPPLIES9,313 1,303 2,212 4,073 3,500 1,500 3,570 2.00% Supported by grant revenues101‐4309‐21‐0000 PD CONTRACTED IT & SFTW SUPPORT56,748 62,306 69,210 87,643 91,780 96,780 108,860 18.61% BASED ON CONTRACTED IT SPREADSHEET, ADDED LEXIPOL IN 2019101‐4310‐21‐0000 PD MISC CONTRACTED SERVICES8,074 4,512 5,008 10,814 8,420 15,025 16,250 92.99% BASED ON MISC. CONTRACTED SERVICES SPREADSHEET101‐4325‐21‐0000 PD COMMUNICATIONS44,478 44,672 55,454 61,645 63,220 58,420 62,500 ‐1.14% BASED ON COMMUNICATION SPREADSHEET101‐4333‐21‐0000 PD HC PRISONER SERVICES5,692 3,913 5,766 7,233 6,885 8,400 8,500 23.46% 2021 PROJECTED RUN RATE101‐4341‐21‐0000 PD TRAINING, CONF. & MTG.21,876 16,658 27,738 22,353 33,611 8,500 24,000 ‐28.59% 2021 PROJECTED RUN RATE101‐4342‐21‐0000 PD MEMBERSHIPS & DUES2,085 2,580 1,954 5,606 5,600 5,100 5,150 ‐8.04% 2021 PROJECTED RUN RATE101‐4350‐21‐0000 PD PRINTED FORMS & ENVELOPES902 602 769 1,442 969 969 988 2.00% 2021 PROJECTED RUN RATE101‐4365‐21‐0000 PD INSURANCE PC / LIABILITY51,476 47,941 51,065 54,753 56,615 60,359 64,265 13.51% BASED ON 2020/2021 RENEWAL 101‐4345‐21‐0000 PD MISC GRANTS / REIMB EXPENDITURES1,293 848 1,756 ‐ 1,500 500 500 ‐66.67% 2021 PROJECTED RUN RATE101‐4499‐21‐0000 PD MISCELLANEOUS3,809 75 49 ‐ 250 50 250 0.00% PLACEHOLDER TOTAL 3,400,353$ 3,160,996$ 3,170,332$ 3,276,319$ 3,463,212$ 3,239,694$ 3,621,976$ 4.58%FIRE PROTECTION27
|