Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
10202021 City Council Work Session LAYDOWN - Updated Budget Docs
LAYDOWN 10/20/2021 City Council Work Session PUBLIC WORKS Combined General Fund - Streets (01000-1310) 2021 General Fund - Streets (01000- 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 1310)Expense Budget Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Expenditures: Personnel Costs: 6000 Salaries 82,946 109,407 132,707 143,079 161,992 160,656 96,395 268,552 includes snow & ice personnel budget 6001 Overtime 15,388 6,807 11,809 6,435 17,534 2,385 5,262 9,000 6002 Standby Time 248 339 496 2,887 -5,027 0 0 0 6100 Medicare 1,437 1,708 2,355 2,255 2,813 2,272 1,655 4,025 6101 Unemployment Insurance 5,550 2,617 0 0 0 2,000 0 0 6102 Workers' Compensation 10,802 12,851 16,399 18,433 20,354 20,307 10,126 19,374 6200 Leave Time 10,809 15,790 19,568 14,133 16,777 19,608 17,885 0 6201 Retirement Benefits 11,094 11,731 13,439 44,633 15,566 10,306 2,521 60,476 6202 Health Insurance 44,870 57,979 69,187 96,802 126,763 91,861 64,108 192,042 6203 In Lieu of FICA 461 0 0 0 0 0 0 0 Total Personnel Costs: $183,605 $219,229 $265,960 $328,657 $356,772 $309,395 $197,952 $553,469 Non -Personnel Costs: 7001 Communications 169 1,020 509 127 180 1,000 122 375 7002 Postage and Freight 615 3,594 2,940 297 1,607 3,600 661 1,768 7004Insurance 21,816 20,451 20,935 22,183 25,722 22,000 13,084 28,300 7006 Legal 0 0 0 0 0 0 0 2,000 7009 Contracted Services 56,400 19,532 19,557 3,919 25,357 25,000 0 20,800 7011 Testing 976 1,647 742 514 0 1,000 0 650 7015 Utilities 98,357 93,400 99,531 98,916 102,446 108,500 60,465 108,500 7210 Vehicle Supplies 485 550 0 0 70 0 0 0 7211 Gas & Lube 26,772 43,644 29,250 16,726 20,891 28,000 8,389 28,000 7212 Uniform Allowance 0 48 270 150 150 850 0 850 7213 Safety Equipment 837 700 1,079 300 305 1,200 15 1,200 7215 Operating Supplies 56,410 19,710 18,998 15,867 25,420 18,500 18,351 25,000 7216 Maintenance & Repair 57,779 33,447 25,227 7,723 15,376 25,000 14,727 25,000 7217 Small Tools & Equipment 2,207 3,517 937 248 976 2,100 0 1,325 7300 Advertising 1,582 419 0 359 136 400 0 400 7301 Subscriptions & Dues 1,980 45 206 29 240 350 419 500 7302 Travel & Subsistence 662 1,488 786 1,543 1,747 1,200 359 1,150 7303 Education & Training 1,008 284 0 1,380 689 1,200 120 1,200 7304 Equipment Rent 0 0 1,515 40 0 1,000 0 275 7810 Miscellaneous Expense 1,865 1,721 1,819 675 718 2,000 1,120 1,375 7811 Miscellaneous Programs 0 28 0 0 0 0 0 0 8103 Capital Equipment 0 7,500 2,511 0 0 0 0 0 8104 Motor Pool Rent 0 0 0 0 90,000 90,000 0 0 Total Non -Personnel Costs: $329,920 $252,745 $226,812 $170,996 $312,030 $332,900 $117,832 $248,668 Total Expenditures: $513,525 $471,974 $492,772 $499,653 $668,802 $642,295 $315,784 $802,137 General Fund - Snow & Ice (01000-1311) 2021 General - Snow & Ice (01000- 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 1311) Expense Budget Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Expenditures: Personnel Costs: 6000 Salaries 6001 Overtime 6002 Standby Time 6100 Medicare 6102 Workers' Compensation 6201 Retirement Benefits 6202 Health Insurance Total Personnel Costs: Non -Personnel Costs: 7002 Postage and Freight 7009 Contracted Services 7015 Utilities 7211 Gas & Lube 7213 Safety Equipment 7215 Operating Supplies 7216 Maintenance & Repair 7217 Small Tools & Equipment 7300 Advertising 7301 Subscriptions & Dues 7302 Travel & Subsistence 7303 Education & Training 7810 Miscellaneous Expense 8103 Capital Equipment 8104 Motor Pool Rent Total Non -Personnel Costs: Total Expenditures: 70,763 8,521 5,537 1,241 10,453 10,404 40,922 58,623 41,588 5,489 1,595 6,126 11,366 35,991 39,717 20,690 4,127 972 9,010 6,050 30,174 7,136 6,353 1,920 242 2,170 1,133 9,390 25,766 18,845 882 708 4,476 10,039 19,795 82,273 4,530 6,106 1,571 12,748 3,451 52,328 52,368 13,613 3,432 1,069 7,719 12,129 33,526 0 0 0 0 0 0 0 $147,841 $160,778 $110,740 $28,344 $80,511 $163,007 $123,856 $0 117 3,764 2,987 391 0 3,000 1,063 1,475 1,219 21,356 38,201 11,036 0 12,000 2,000 12,500 0 175 0 0 0 0 0 0 4,390 1,027 4,599 7,071 17,378 10,000 20,151 35,000 0 49 17 0 0 500 0 500 47,726 109,432 52,602 68,442 108,569 50,000 32,448 75,000 8,527 36,504 18,626 8,244 7,538 23,500 4,763 14,450 0 1,011 240 14 20 500 0 325 0 0 0 260 0 300 0 0 0 41 0 0 0 0 0 0 0 0 23 0 0 750 0 0 0 30 0 0 0 250 0 0 0 0 359 0 147 500 0 100 0 0 8,500 6,432 0 0 0 0 0 0 0 0 35,000 35,000 0 0 $61,979 $173,389 $126,154 $101,890 $168,652 $136,300 $60,425 $139,350 $209,820 $334,167 $236,894 $130,234 $249,163 $299,307 $184,281 $139,350 General Fund - City Shop (01000-1312) 2021 General - City Shop Budget 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 (01000-1312) Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Revenues: Operating Revenue: 4331 Shop Work Orders 2,221 4,935 3,244 2,721 1,474 2,000 945 1,775 Total Operating Revenues: $2,221 $4,935 $3,244 $2,721 $1,474 $2,000 $945 $1,775 Total Revenues: $2,221 $4,935 $3,244 $2,721 $1,474 $2,000 $945 $1,775 Expenditures: Personnel Costs: 6000 Salaries 111,815 125,864 120,161 88,807 89,655 69,932 60,531 113,387 6001Overtime 7,178 15,069 6,067 6,443 9,526 2,472 3,445 8,225 6002 Standby Time 2,141 2,419 1,684 5,733 2,661 1,987 1,439 5,923 6100 Medicare 1,526 2,107 1,936 1,537 1,794 1,130 1,008 1,849 6101 Unemployment Insurance 0 3,885 0 0 -28 0 0 0 6102 Workers' Compensation 2,055 14,911 13,117 7,728 6,936 7,387 3,403 9,068 6200 Leave Time 11,548 6,110 8,623 9,444 7,622 7,910 7,119 0 6201 Retirement Benefits 12,409 14,823 11,766 18,714 7,129 4,046 3,702 27,811 6202 Health Insurance 43,015 60,918 59,447 46,739 44,755 36,630 27,500 52,534 6203 In Lieu of FICA 461 0 0 0 0 0 0 0 Total Personnel Costs: $192.148 $246.106 $222.801 $185.145 $170.050 $131.494 $108.147 $218.797 Non -Personnel Costs: 7001 Communications 8,855 7,825 8,743 9,308 9,532 8,000 5,429 8,750 7002 Postage and Freight 625 1,623 1,230 1,198 2,541 1,500 1,408 1,450 7004 Insurance 6,216 5,893 6,099 5,149 6,023 6,500 3,538 6,625 7009 Contracted Services 774 1,331 2,653 4,583 7,207 2,000 5,417 5,000 7010 Engineering 0 0 0 0 0 0 0 5,000 7011 Testing 404 92 106 432 0 0 0 0 7015 Utilities 33,258 31,048 31,849 27,802 30,199 33,000 20,638 33,000 7016 Heating Fuel 12,673 17,031 16,627 14,261 15,373 17,000 10,268 17,000 7210 Vehicle Supplies 0 50 0 0 23 0 0 0 7211 Gas & Lube 4,127 10,638 10,305 5,366 3,251 7,600 1,424 7,600 7213 Safety Equipment 1,922 1,631 1,370 335 669 1,500 0 1,000 7214 Janitorial Supplies 657 66 43 0 0 0 0 0 7215 Operating Supplies 45,851 20,282 37,228 21,882 28,753 28,000 18,572 28,000 7216 Maintenance & Repair 10,067 3,665 3,946 18,124 43,403 4,900 18,672 15,000 7217 Small Tools & Equipment 7,241 10,071 9,665 4,848 4,308 7,300 2,709 7,300 7300 Advertising 1,948 1,066 0 166 84 0 0 0 7301 Subscriptions & Dues 1,736 534 441 1,308 2,765 2,000 2,138 2,500 7302 Travel & Subsistence 91 247 525 0 328 1,000 37 500 7303 Education & Training 25 199 0 82 453 500 560 500 7810 Miscellaneous Expense 317 1,753 451 242 68 1,000 558 575 8102 Buildings 0 0 3,300 0 0 0 0 0 8103 Capital Equipment 0 6,678 14,618 0 12,434 0 0 0 8104 Motor Pool Rent 0 0 0 0 8,000 8,000 0 0 Total Non -Personnel Costs: $136,787 $121,723 $149,199 $115,086 $175,414 $129,800 $91,368 $139,800 Total Expenditures: $328,935 $367,829 $372,000 $300,231 $345,464 $261,294 $199,515 $358,597 General Fund - City Hall (01000-1350) 2021 General - City Hall Budget 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 (01000-1350) Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Revenues: Operating Revenue: 4383 Municipal Building Rent 54,220 49,850 109,022 42,611 64,940 43,471 32,500 52,200 Total Operating Revenues: 54,220 49,850 109,022 42,611 64,940 43,471 32,500 52,200 Total Revenues: $54,220 $49,850 $109,022 $42,611 $64,940 $43,471 $32,500 $52,200 Expenditures: Personnel Costs: 6000 Salaries 6001 Overtime 6100 Medicare 6102 Workers' Compensation 6200 Leave Time 6201 Retirement Benefits 6202 Health Insurance Total Personnel Costs: Non -Personnel Costs: 7001 Communications 7002 Postage and Freight 7004 Insurance 7009 Contracted Services 7010 Engineering 7011 Testing 7015 Utilities 7016 Heating Fuel 7211 Gas & Lube 7212 Uniform Allowance 7213 Safety Equipment 7214 Janitorial Supplies 7215 Operating Supplies 7216 Maintenance & Repair 7217 Small Tools & Equipment 7300 Advertising 7301 Subscriptions & Dues 7302 Travel & Subsistence 7303 Education & Training 7810 Miscellaneous Expense 8102 Buildings Total Non -Personnel Costs: Total Expenditures: 77,028 1,045 1,217 10,214 10,354 9,636 53,845 72,051 221 1,207 14,233 12,420 8,810 55,808 59,057 190 885 8,368 6,463 5,608 45,739 39,139 137 576 6,012 4,587 14,387 33,113 40,476 -5,022 620 4,942 4,926 8,221 14,148 42,290 0 650 6,073 5,124 2,328 33,300 26,645 192 421 2,820 3,351 3,516 9,710 45,776 474 671 3,288 0 9,971 18,290 $163,339 $164,750 $126,310 $97,951 $68,311 $89,765 $46,655 $78,470 705 660 737 807 893 800 492 775 28 18 18 0 53 200 0 50 8,472 7,797 7,973 7,165 9,908 8,500 5,827 10,899 12,206 10,903 6,900 8,315 13,747 10,000 3,813 9,650 0 0 0 0 258 0 0 0 0 205 0 0 0 0 0 0 64,547 68,077 58,644 62,533 66,263 66,000 39,554 65,000 10,832 14,162 13,795 15,744 11,916 13,000 8,190 13,000 322 1,717 668 289 409 800 312 800 0 0 0 0 0 300 0 300 663 635 155 11 429 250 0 250 1,497 0 0 0 1,251 0 1,062 0 3,433 5,297 2,859 3,320 3,981 6,000 2,429 3,775 6,482 5,483 577 5,712 3,418 6,000 385 3,725 1,497 606 780 239 80 500 0 500 451 0 0 0 84 0 0 0 0 28 0 103 0 0 0 0 0 0 0 0 0 600 0 0 0 0 0 0 0 100 0 0 0 146 169 0 468 250 0 150 0 0 3,520 0 0 0 0 60,000 Fire alarm system $111,135 $115,734 $96,795 $104,238 $113,158 $113,300 $62,064 $168,874 $274,474 $280,484 $223,105 $202,189 $181,469 $203,065 $108,719 $247,344 General Fund - Community Center (01000-1351) 2021 General - Community Center 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 (01000-1351) Expense Budget Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Expenditures: Personnel Costs: Total Personnel Costs: $0 $0 $0 $0 $0 $0 $0 $0 Non -Personnel Costs: 7004Insurance 3,388 3,132 3,201 3,177 4,700 3,400 2,795 5,170 7009 Contracted Services 0 1,279 5,029 2,162 2,940 3,000 3,733 3,000 7015 Utilities 11,528 11,883 11,106 11,494 11,502 12,000 7,614 12,000 7016 Heating Fuel 4,193 4,171 5,356 3,847 1,504 4,500 3,281 4,500 7211 Gas & Lube 0 0 0 767 0 0 0 0 7214 Janitorial Supplies 632 0 0 0 0 0 0 0 7215 Operating Supplies 0 1,440 831 0 2 800 0 400 7216 Maintenance & Repair 0 2,480 2,551 2,181 1,704 4,000 0 1,500 7810 Miscellaneous Expense 0 0 0 0 0 250 0 0 8102 Buildings 0 0 4,140 4,140 0 0 0 0 Total Non -Personnel Costs: $19,741 $24,385 $32,214 $27,768 $22,352 $27,950 $17,423 $26,570 Total Expenditures: $19,741 $24,385 $32,214 $27,768 $22,352 $271950 $17,423 $26,570 General Fund - City Hall Annex (01000-1352) 2021 General - City Hall Annex (01000- 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 1352) Expense Budget Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Expenditures: Personnel Costs: 6000 Salaries 0 663 0 0 0 0 0 0 6100 Medicare 0 51 0 0 0 0 0 0 6102 Workers' Compensation 0 95 0 0 0 0 0 0 Total Personnel Costs: $0 $809 $0 $0 $0 $0 $0 $0 Non -Personnel Costs: 7004Insurance 1,998 1,872 1,962 1,936 2,900 2,500 1,725 2,150 7009 Contracted Services 680 483 733 2,018 1,345 5,000 586 2,000 7015 Utilities 12,678 13,328 12,836 12,034 12,629 12,000 6,888 13,500 7016 Heating Fuel 3,199 3,544 3,514 3,763 4,371 5,000 2,962 5,000 7211 Gas & Lube 0 0 0 554 0 0 0 0 7213 Safety Equipment 0 89 1,255 0 0 250 0 225 7215 Operating Supplies 1,759 1,385 2,676 117 1,783 1,000 417 1,000 7216 Maintenance & Repair 410 1,044 2,363 542 334 2,000 98 0 7301 Subscriptions & Dues 0 0 0 14 0 0 0 0 8102 Buildings 0 0 10,400 0 0 0 0 0 Total Non -Personnel Costs: $20,724 $21,745 $35,739 $20,978 $23,362 $27,750 $12,676 $23,875 Total Expenditures: $20,724 $22,554 $35,739 $20,978 $23,362 $27,750 $12,676 $23,875 Streets (01000-1310) 6000 Salaries 6001 Overtime 6002 Standby Time 6100 Medicare 6101 Unemployment Insurance 6102 Workers' Compensation 6200 Leave Time 6201 Retirement Benefits 6202 Health Insurance 6203 In Lieu of FICA Total Personnel Costs: Snow & Ice (01000-1311) 6000 Salaries 6001 Overtime 6002 Standby Time 6100 Medicare 6102 Workers' Compensation 6201 Retirement Benefits 6202 Health Insurance Total Personnel Costs: Public Works (Streets and Snow & Ice) Personnel Comparison Information 2021 2016 2017 2018 2019 2020 Amended 2022 Actual Actual Actual Actual Actual Budget Proposed 82,946 109,407 132,707 143,079 161,992 160,656 268,552 15,388 6,807 11,809 6,435 17,534 2,385 9,000 2022 Proposed Budget 248 339 496 2,887 -5,027 0 0 includes Snow & Ice 1,437 1,708 2,355 2,255 2,813 2,272 4,025 personnel line items. 5,550 2,617 0 0 0 2,000 0 10,802 12,851 16,399 18,433 20,354 20,307 19,374 10,809 15,790 19,568 14,133 16,777 19,608 0 11,094 11,731 13,439 44,633 15,566 10,306 60,476 44,870 57,979 69,187 96,802 126,763 91,861 192,042 461 0 0 0 0 0 0 $183,605 $219,229 $265,960 $328,657 $356,772 $309,395 $553,469 2021 2016 2017 2018 2019 2020 Amended 2022 Actual Actual Actual Actual Actual Budget Proposed 70,763 58,623 39,717 7,136 25,766 82,273 0 8,521 41,588 20,690 6,353 18,845 4,530 0 2022 Proposed Budget 5,537 5,489 4,127 1,920 882 6,106 0 moves Snow & Ice to 1,241 1,595 972 242 708 1,571 0 Streets personnel line 10,453 6,126 9,010 2,170 4,476 12,748 0 items. 10,404 11,366 6,050 1,133 10,039 3,451 0 40,922 35,991 30,174 9,390 19,795 52,328 0 $147,841 $160,778 $110,740 $28,344 $80,511 $163,007 $0 2021 2016 2017 2018 2019 2020 Amended 2022 Actual Actual Actual Actual Actual Budget Proposed Total Personnel Costs: $331,446 $380,007 $376,700 $357,001 $437,283 $472,402 $553,469 LAYDOWN 10/20/2021 City Council Work Session PUBLIC WORKS Water - 17000 Water - Revenue & Expenditures Revenue 17000-0000 General Operations Expenditures $ 1,622,973.40 Total: $ 1,622,973.40 17000-0000 General Operations $ 1,710,413.03 17000-0900 Debt Service $ 156,844.55 17000-4002 SMIC $ 69,406.35 Total: $ 1,936,663.93 Transfers Out $ 142,823.37 Total Expenditures $ 2,079,487.29 Motor Pool Rent: $ 5,150.00 Depreciation Expense: $ 605,247.59 Total Motor Pool Rent & Depreciation Expense: $ 610,397.59 Total expenditures (less depreciation and Motor Pool Rent): $ 1,469,089.70 Revenue over Expenditures (less depreciation expense and Motor Pool Rent): $ 153,883.70 Water General Revenue and Expenditures (17000-0000) Water General (17000-0000) Revenue and Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Revenues: Operating Revenue: 5919 Contra PERS (paid by SOA) -593 1,329 0 0 0 0 0 0 5920 PERS On -Behalf Paid by SOA 9,565 7,766 -4,579 -7,590 12,426 0 0 0 5300 Residential 481,202 495,280 509,634 519,887 524,973 523,000 304,804 529,276 5310 SG Service 131,223 147,929 155,657 165,622 148,944 159,000 80,507 160,908 5320 LG Service 229,373 224,982 222,753 221,912 205,416 222,000 156,546 224,664 5330 SMIC Sales 47,066 60,861 58,184 62,534 50,812 54,200 20,066 54,850 5340 Special Contracts 245,585 260,992 176,960 200,785 196,375 180,475 112,234 198,750 5800 Labor & Services 0 0 0 0 496 0 0 0 5801 Turn On Fees 11,182 17,032 18,331 17,134 16,233 17,000 8,055 17,200 5806 Ship Water 93,877 87,550 80,395 110,855 2,435 94,600 1,436 94,300 5807 Hydrant Rentals 55,572 112,191 128,653 140,486 129,842 132,000 77,720 132,650 5899 Miscellaneous Revenue -2,190 4,503 5,537 14,128 130 10,000 16,189 0 Total Operating Revenue: $1,301,862 $1,420,414 $1,351,525 $1,445,753 $1,288,083 $1,392,275 $777,557 $1,412,598 Non -Operating Revenue: 5901 Investment Interest 2,393 22,998 43,725.12 67,524 58,568 15,000 1,016 6,900 5905 Penalties and Interest 4,250 687 421.79 702 161 500 291 500 5940 Amort. Of CIA General 24,402 186,036 184,499 202,977 202,977 205,000 0 202,975 Total Non -Operating Revenue: $31,044 $209,720 $228,646 $271,203 $261,706 $220,500 $1,307 $210,375 Total Revenue: $1,332,906 $1,630,134, , , ,956 $1,549,789 $1,612,775, , , 973 Expenditures: Personnel Cost: 6000 Salaries 156,370 172,542 180,164 186,627 181,953 178,906 111,057 222,880 Includes SMIC Water Salaries 6001 Overtime 8,152 15,188 9,762 14,098 9,728 4,274 9,466 17,386 6002 Standby Time 8,515 8,243 7,503 9,112 10,085 9,027 4,533 14,258 6100 Medicare 2,871 2,906 3,053 3,091 3,447 2,930 2,026 3,691 6102 Workers' Compensation 7,503 9,103 13,757 14,479 11,174 12,582 5,941 11,352 6200 Leave Time 11,496 17,769 9,582 4,983 22,200 21,346 14,824 0 6201 Retirement Benefits 105,389 -9,951 28,704 35,130 25,677 10,539 11,800 55,510 6202 Health Insurance 79,306 87,487 97,999 117,449 113,198 106,799 63,601 139,547 6203 In Lieu of FICA 461 0 0 0 0 0 0 0 6209 PERS DC Forfeitures 0 0 0 -1,555 0 0 0 0 Total Personnel Costs: $380,063 $303,289 $350,523 $383,414 $377,461 $346,403 $223,248 $464,624 Non -Personnel Costs: 7000 Audit 0 0 0 0 0 0 0 0 7001 Communications 9,208 8,183 6,790 7,705 6,629 10,000 5,220 7,700 7002 Postage and Freight 2,443 4,330 3,152 2,090 3,284 5,000 780 2,750 7003 Bank and Credit Card Fees 6,782 7,401 9,192 12,024 11,179 11,279 6,119 9,300 7004 Insurance 10,347 13,131 14,303 16,827 19,689 9,476 10,900 18,796 7006 Legal 0 0 0 0 0 5,150 0 5,150 7009 Contracted Services 22,824 8,014 22,819 28,314 16,536 69,062 4,692 20,000 7010 Engineering 0 0 0 0 0 0 0 10,000 R &M Engineering 7011 Testing 4,781 6,907 6,549 4,328 13,203 9,270 3,110 10,000 7015 Utilities 152,185 188,911 168,531 176,312 190,314 231,750 99,793 200,000 7016 Heating Fuel 3,067 0 1,382 732 1,981 0 1,039 1,475 Water General(17000-0000) Revenue and Expense Budget Non -Personnel Costs: 7210 Vehicle Supplies 7211 Gas & Lube 7213 Safety Equipment 7214 Janitorial Supplies 7215 Operating Supplies 7216 Maintenance & Repair 7217 Small Tools & Equipment 7300 Advertising 7301 Subscriptions & Dues 7302 Travel & Subsistence 7303 Education & Training 7304 Equipment Rent 7307 GF Administrative Fee 7330 P.I.L.T. 7331 Reclass PILT to Transfer -Out 7808 Bad Debt Expense 7810 Miscellaneous Expense 7900 Depreciation Expense 8104 Motor Pool Rent Total Non -Personnel Costs: Total Expenditures: Water General Revenue and Expenditures (17000-0000) 2021 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments 1,361 171 0 0 137 0 0 300 4,844 6,396 3,356 7,366 3,185 10,300 2,748 10,000 2,052 2,016 1,597 290 805 2,575 87 1,600 0 0 0 0 37 0 0 0 23,869 21,461 15,932 17,715 18,171 41,200 13,872 18,850 6,347 30,730 8,983 3,141 10,213 27,660 21,091 11,900 6,222 5,233 5,405 5,451 2,506 6,180 210 4,200 0 30 1,312 0 0 1,030 375 350 880 1,279 227 227 752 1,545 1,289 1,200 3,611 901 1,248 2,617 69 5,150 178 2,500 2,507 449 1,300 2,620 100 5,150 0 2,500 1,350 0 0 0 0 8,240 0 1,000 245,122 251,004 258,849 262,991 262,991 269,340 269,340 277,420 3% over previous year 103,606 112,843 108,488 116,267 102,053 111,382 47,463 111,300 -103,606 -112,843 -108,488 -116,267 -102,053 -111,382 -47,463 -111,300 715 456 97,898 100,510 -98,479 2,060 315 16,950 103 8,048 133 150 217 1,545 0 1,450 193,365 389,467 386,629 413,175 413,236 609,782 0 605,248 0 0 5,000 5,000 5,000 5,150 5,048 5,150 $703,985 $954,517 $1,020,587 $1,069,586 $881,755 $1,347,894 $446,206 $1,245,789 $1,084,048 $1,257,805 $1,371,110 $1,453,001 $1,259,216 $1,694,297 $669,454 $1,710,413 Water Debt Service Expenditures (17000-0900) 2021 Water Debt Service (17000-0900) 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 Expense Budget Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Expenditures: Personnel Costs: 6201 Retirement Benefits 32,007 33,326 28,562 -53,384 -6,044 34,992 17,939 0 6202 Health Insurance 0 0 -3,171 -318 0 0 0 0 6209 PERS DC Forfeitures 0 0 0 -318 -600 0 0 0 Total Personnel Costs: $32,007 $33,326 $25,391 -$54,020 -$6,644 $34,992 $17,939 $0 Non -Personnel Costs: 8012 Debt Service Interest Expense 24,098 5,923 20,429 18,303 16,016 15,523 15,523 13,404 8300 Debt Service Principal 131,182 133,150 135,147 0 0 141,321 141,321 143,441 Total Non -Personnel Costs: $155,280 $139,074 $155,576 $18,303 $16,016 $156,844 $156,844 $156,845 Total Expenditures: $187,288 $172,399 $180,968 -$35,717 $9,372 $191,836 $174,783 $156,845 Water SMIC Expenditures (17000-4002) Water SMIC (17000-4002) Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Expenditures: Personnel Cost: 6000 Salaries 4,286 0 0 0 0 4,613 0 0 Salaries Moved to General 6001 Overtime 288 3,331 2,012 367 294 452 920 0 6100 Medicare 65 48 30 5 5 88 13 0 6102 Workers' Compensation 278 231 160 34 25 451 56 0 6201 Retirement Benefits 492 316 187 15 21 265 42 0 6202 Health Insurance 1,868 668 540 108 208 2,425 172 0 Total Personnel Costs: $7,278 $4,593 $2,929 $530 $553 $8,294 $1,203 $0 Non -Personnel Costs: 7002 Postage and Freight 0 0 90 75 0 515 0 100 7004 Insurance 1,803 1,761 1,964 2,410 2,316 1,854 1,176 2,641 7009 Contracted Services 0 289 3,128 752 1,160 25,750 1,910 1,075 7011 Testing 15 2,038 389 0 1,743 2,060 410 800 7015 Utilities 33,547 43,576 41,994 40,644 45,520 35,020 30,437 46,203 7016 Heating Fuel 0 0 0 0 639 0 0 0 7211 Gas & Lube 0 125 0 0 0 515 0 0 7213 Safety Equipment 0 385 110 0 0 515 0 100 7215 Operating Supplies 0 105 1,688 841 0 4,635 0 4,000 7216 Maintenance & Repair 19 653 8,836 128 224 3,090 110 1,675 7217 Small Tools & Equipment 12 0 815 0 0 515 0 150 7301 Subscriptions & Dues 0 0 0 0 170 206 100 0 7302 Travel & Subsistence 0 0 0 0 0 618 0 0 7303 Education & Training 0 0 0 0 0 618 0 0 7810 Miscellaneous Expense 0 82 100 0 0 309 0 0 7900 Depreciation Expense 6,958 6,958 6,958 10,436 10,436 12,661 0 12,662 8103 Capital Equipment 0 0 17,387 0 0 0 0 0 Total Non -Personnel Costs: $42,355 $55,972 $83,460 $55,286 $62,208 $88,881 $34,143 $69,406 Total Expenditures: $49,633 $60,565 $86,389 $55,816 $62,761 $97,175 $35,346 $69,406 Water Total Personnel Comparison Information 2021 2016 2017 2018 2019 2020 Amended 2022 Actual Actual Actual Actual Actual Budget Proposed Water General (0000) 6000 Salaries 153,370 172,542 180,164 186,627 181,953 178,906 222,880 6001 Overtime 8,152 15,188 9,762 14,098 9,728 4,274 17,386 2022 Proposed Budget 6002 Standby Time 8,515 8,243 7,503 9,112 10,085 9,027 14,258 includes Water SMIC 6100 Medicare 2,871 2,906 3,053 3,091 3,447 2,930 3,691 personnel line items. 6102 Workers' Compensation 7,503 9,103 13,757 14,479 11,174 12,582 11,352 6200 Leave Time 11,496 17,769 9,582 4,983 22,200 21,346 0 6201 Retirement Benefits 105,389 -9,951 28,704 35,130 25,677 10,539 55,510 6202 Health Insurance 79,306 87,487 97,999 117,449 113,198 106,799 139,547 6203 In Lieu of FICA 461 0 0 0 0 0 0 6209 PERS DC Forfeitures 0 0 0 -1,555 0 0 0 Total Personnel Costs: $377,063 $303,287 $350,524 $383,414 $377,462 $346,403 $464,624 2021 2016 2017 2018 2019 2020 Amended 2022 Water SMIC (4002) Actual Actual Actual Actual Actual Budget Proposed 6000 Salaries 4,286 0 0 0 0 4,613 0 6001 Overtime 288 3,331 2,012 367 294 452 0 2022 Proposed Budget 6100 Medicare 65 48 30 5 5 88 0 includes Water SMIC 6102 Workers' Compensation 278 231 160 34 25 451 0 personnel line items. 6201 Retirement Benefits 492 316 187 15 21 265 0 6202 Health Insurance 1,868 668 540 108 208 2,425 0 Total Personnel Costs: $7,277 $4,594 $2,929 $529 $553 $8,294 $0 2021 2016 2017 2018 2019 2020 Amended 2022 Actual Actual Actual Actual Actual Budget Proposed Total Personnel Costs: $384,340 $307,881 $353,453 $383,943 $378,015 $354,697 $464,624 LAYDOWN 10/20/2021 City Council Work Session PUBLIC WORKS Wastewater - 18000 Wastewater - Revenue & Expenditures Revenue 18000-0000 General Operations Expenditures $ 1,388,459.80 Total: $ 1,388,459.80 18000-0000 General Operations $ 1,411,689.11 18000-0900 Debt Service $ 79,521.37 18000-4502 SMIC $ 78,760.76 Total: $ 1,569,971.24 Transfers Out $ 128,569.43 Total Expenditures $ 1,698,540.67 Motor Pool Rent: $ 5,150.00 Depreciation Expense: $ 484,290.00 Total Motor Pool Rent & Depreciation Expense: $ 489,440.00 Total expenditures (less depreciation and Motor Pool Rent): $ 1,209,100.67 Revenue over Expenditures (less depreciation expense and Motor Pool Rent): $ 179,359.13 Wastewater General Revenue and Expenditures (18000-0000) Waste Water General (18000-0000) Revenue Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Revenues: Operating Revenues: 5919 Contra PERS On -behalf paid by SOA -453 902 0 0 0 0 0 0 5920 PERS Paid by SOA 7,314 5,269 -2,846 -3,705 9,243 0 0 0 5921 Federal Grant Revenue 0 62,194 44,550 0 0 0 0 0 5300 Residential 637,860 667,499 682,758 694,384 699,692 700,000 412,489 708,400 5310 SG Service 194,606 192,426 198,888 208,197 193,898 200,000 117,177 202,400 5320 LG Service 279,178 282,426 282,649 281,600 271,115 283,300 152,592 286,700 5330 SMIC Sales 35,895 44,292 25,050 23,921 24,214 28,350 15,248 28,690 5801 Turn on Fees 0 0 5,650 15,027 17,739 10,000 10,633 14,100 5804 Work Order Revenue 0 0 0 791 0 0 0 0 5809 Misc. Service Revenue 4,223 6,373 4,960 15,750 1,883 4,250 1,408 5,400 5899 Misc Revenue 1 0 36 0 0 0 11,800 0 Total Operating Revenue: $1,158,623 $1,261,381 $1,241,695 $1,235,966 $1,217,784 $1,225,900 $721,347 $1,245,690 Non -Operating Revenues: 5901 Investment Interest 1,813 19,111 30,612 68,162 63,768 8,000 -613 3,475 5905 Penalties and Interest 1,184 1,120 723 1,350 302 1,000 375 850 5910 Gain on Sale of Fixed Assets 0 260 0 0 0 0 0 0 5940 Amort. Of CIA General 411,522 398,445 398,445 398,445 398,445 398,445 0 138,445 Total Non -Operating Revenue: $414,519 $418,936 $429,779 $467,957 $462,515 $407,445 -$238 $142,770 Total Revenue: $1,573,142 $1,680,318, , , ,923 $1,680,299 $1,633,345, , , 460 Expenditures: Personnel Costs: 6000 Salaries 122,443 118,778 110,576 105,795 135,908 143,870 95,133 162,377 Includes SMIC WW Salaries 6001 Overtime 5,665 4,694 3,211 4,875 8,512 3,560 6,527 12,158 6002 Standby Time 7,231 6,967 7,628 6,784 6,317 6,879 6,663 17,839 6100 Medicare 2,004 2,049 1,910 1,770 2,654 2,367 1,687 2,789 6102 Workers' Compensation 16,932 16,451 7,622 7,279 7,638 10,286 4,779 10,504 6200 Leave Time 18,771 22,343 29,136 27,687 22,329 18,882 20,627 0 6201 Retirement Benefits 80,388 -6,284 17,823 17,088 9,552 8,585 6,737 41,969 6202 Health Insurance 56,237 58,320 55,170 58,710 80,656 73,594 56,441 98,452 6203 In Lieu of FICA 461 0 0 0 0 0 0 0 Total Personnel Costs: $310,132 $223,320 $233,076 $229,988 $273,565 $268,023 $198,594 $346,088 Non -Personnel Costs: 7000 Audit 0 0 0 0 0 0 0 0 7001 Communications 6,529 5,763 6,920 6,553 6,511 7,725 4,018 6,400 7002 Postage and Freight 2,359 2,793 2,526 2,156 3,353 4,120 2,181 2,650 7003 Bank and Credit Card Fees 8,797 9,755 11,747 14,900 13,851 14,142 8,122 11,850 7004 Insurance 5,020 5,113 4,883 4,475 4,934 6,699 2,703 4,969 7006 Legal 1,680 0 0 0 0 12,360 0 10,000 7009 Contracted Services 24,790 14,857 3,206 33,345 9,222 150,022 90,222 140,000 7010 Engineering 0 0 0 0 0 0 0 10,000 7011 Testing 23,533 20,709 17,117 26,447 20,235 18,025 9,360 20,350 7015 Utilities 130,018 136,313 117,017 132,909 139,194 180,250 64,471 155,000 Waste Water General (18000-0000) Revenue Budget Non -Personnel Costs: 7016 Heating Fuel 7017 Rents & Leases 7210 Vehicle Supplies 7211 Gas & Lube 7212 Uniform Allowance 7213 Safety Equipment 7214 Janitorial Supplies 7215 Operating Supplies 7216 Maintenance & Repair 7217 Small Tools & Equipment 7300 Advertising 7301 Subscriptions & Dues 7302 Travel & Subsistence 7303 Education & Training 7304 Equipment Rent 7307 GF Administrative Fee 7330 P.I.L.T. 7331 Reclass PILT to Transfer -Out 7808 Bad Debt Expense 7810 Miscellaneous Expense 7900 Depreciation Expense 8103 Capital Equipment 8104 Motor Pool Rent Total Non -Personnel Costs: Total Expenditures: Wastewater General Revenue and Expenditures (18000-0000) 2021 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments 118 832 0 0 0 2,060 149 200 33 17 0 0 0 206 0 100 1,784 385 0 56 0 0 0 0 6,215 7,827 11,343 7,834 6,946 9,270 7,355 10,000 0 0 0 91 0 0 0 0 906 246 294 274 778 1,030 912 1,000 0 0 0 0 15 0 0 0 11,785 6,655 7,060 16,253 23,237 9,270 32,695 13,000 9,921 19,691 5,219 5,874 8,472 25,600 11,097 9,850 2,710 1,349 2,426 3,801 1,532 3,090 907 2,200 0 0 0 0 0 412 0 0 432 2,570 10,511 2,821 0 2,575 0 2,750 202 930 540 258 132 3,090 115 1,500 439 1,165 187 920 320 2,060 300 1,500 1,350 0 0 0 0 5,150 0 250 149,694 153,287 158,077 160,606 162,533 164,483 164,483 169,417 3% increase over previous year 92,141 95,441 95,996 99,174 96,683 96,880 47,114 97,815 -92,141 -95,441 -95,996 -99,174 -96,683 -96,880 -47,114 -97,815 486 426 6,079 7,002 -1,442 2,060 433 2,675 92 6,055 101 422 0 1,030 0 500 366,619 363,381 365,108 364,082 351,762 480,679 0 484,290 0 0 3,276 0 0 0 0 0 0 0 5,000 5,000 5,000 5,150 5,048 5,150 $755,512 $760,119 $738,637 $796,078 $756,584 $1,110,558 $404,571 $1,065,601 $1,065,643 $983,439 $971,713 $1,026,066 $1,030,149 $1,378,581 $603,165 $1,411,689 Wastewater Debt Expenditures (18000-0900) Waste Water Debt Service (18000- 0900)Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Expenditures: Personnel Costs: 6201 Retirement Benefits 0 0 0 -22,217 4,942 28,696 18,730 0 6209 PERS DC Forfeitures 0 0 0 0 -539 0 0 0 6201 Retirement Benefits 24,510 23,108 17,763 0 0 0 0 0 6209 PERS DC Forfeitures 0 0 -776 -569 0 0 0 0 Total Personnel Costs: $24,510 $23,108 $16,987 -$22,786 $4,403 $28,696 $18,730 $0 Non -Personnel Costs: 8012 Debt Service Interest Expense 0 0 0 16,007 15,363 14,504 14,504 13,652 8300 Debt Service Principal 0 0 0 0 57,270 58,128 58,128 65,870 8012 Debt Service Interest Expense 5,900 13,732 17,744 0 0 0 0 0 8300 Debt Service Principal 58,986 56,880 57,733 0 0 0 0 0 Total Non -Personnel Costs: $64,886 $70,612 $75,478 $16,007 $72,632 $72,632 $72,632 $79,521 Total Expenditures: $89,397 $93,720 $92,465 -$6,779 $77,035 $101,328 $91,362 $79,521 Wastewater SMIC Expenditures (18000-4502) Wastewater SMIC (18000-4502) Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Expenditures: Personnel Costs: 6000 Salaries 4,286 0 308 0 0 5,462 0 0 moved salaries to waste water general 6001 Overtime 800 252 527 262 1,836 649 736 0 6002 Standby Time 0 453 554 0 172 0 0 0 6100 Medicare 72 11 19 4 31 108 11 0 6102 Workers' Compensation 301 54 105 24 130 290 44 0 6201 Retirement Benefits 542 64 122 23 124 275 34 0 6202 Health Insurance 2,009 186 444 77 470 2,663 198 0 Total Personnel Costs: $8,011 $1,019 $2,079 $390 $2,763 $9,447 $1,023 $0 Non -Personnel Costs: 7001 Communications 0 0 8 0 0 824 0 0 7002 Postage and Freight 0 25 300 50 25 721 0 100 7004 Insurance 1,597 1,321 1,327 1,463 1,385 1,545 788 1,602 7009 Contracted Services 48,232 9,895 1,497 700 2,560 46,350 25,000 12,600 7011 Testing 14,286 7,830 9,215 5,087 10,850 9,785 6,285 10,000 7015 Utilities 35,567 33,172 31,503 33,263 36,828 44,290 21,615 40,000 7016 Heating Fuel 2,278 1,162 1,163 2,446 0 1,545 281 1,250 7211 Gas & Lube 126 135 864 24 0 721 79 250 7213 Safety Equipment 256 0 0 0 0 515 0 100 7215 Operating Supplies 211 744 455 642 8,226 8,240 8,915 3,500 7216 Maintenance & Repair 657 7,776 1,838 2,054 800 9,785 680 3,500 7217 Small Tools & Equipment 1,027 16 3,159 226 0 1,030 0 750 7301 Subscriptions & Dues 0 2,520 10,440 2,700 0 2,060 0 2,650 7302 Travel & Subsistence 24 0 0 0 0 2,266 0 0 7303 Education & Training 0 0 1,453 200 0 1,854 0 275 7304 Equipment Rent 0 0 0 0 0 1,030 0 0 7810 Miscellaneous Expense 0 0 0 0 0 206 0 0 7900 Depreciation Expense 925 925 2,184 2,184 2,111 2,184 0 2,184 Total Non -Personnel Costs: $105,186 $65,522 $65,407 $51,041 $62,784 $134,951 $63,643 $78,761 Total Expenditures: $113,197 $66,542 $67,486 $51,431 $65,547 $144,398 $64,666 $78,761 Wastewater Total Personnel Comparison Information 2021 2016 2017 2018 2019 2020 Amended 2022 Actual Actual Actual Actual Actual Budget Proposed Wastewater General (0000) 6000 Salaries 122,443 118,788 110,576 105,795 135,908 143,870 162,377 6001 Overtime 5,665 4,694 3,211 4,875 8,512 3,560 12,158 2022 Proposed Budget 6002 Standby Time 7,231 6,967 7,628 6,784 6,317 6,879 17,839 includes Wastewater SMIC 6100 Medicare 2,004 2,049 1,910 1,770 2,654 2,367 2,789 personnel line items. 6102 Workers' Compensation 16,932 16,451 7,622 7,279 7,638 10,286 10,504 6200 Leave Time 18,771 22,343 29,136 27,687 22,329 18,882 0 6201 Retirement Benefits 80,388 -6,284 17,823 17,088 9,552 8,585 41,969 6202 Health Insurance 56,237 58,320 55,170 58,710 80,656 73,594 98,452 6203 In Lieu of FICA 461 0 0 0 0 0 0 Total Personnel Costs: $310,132 $223,328 $233,076 $229,988 $273,566 $268,023 $346,088 2021 2016 2017 2018 2019 2020 Amended 2022 Wastewater SMIC (4002) Actual Actual Actual Actual Actual Budget Proposed 6000 Salaries 4,286 0 0 0 0 5,462 0 6001 Overtime 800 252 527 262 1,836 649 0 2022 Proposed Budget 6002 Standby Time 0 453 554 0 172 0 0 includes Wastewater SMIC 6100 Medicare 72 11 19 4 31 108 0 personnel line items. 6102 Workers' Compensation 301 54 105 24 130 290 0 6201 Retirement Benefits 542 64 122 23 124 275 0 6202 Health Insurance 2,009 186 444 77 470 2,663 0 Total Personnel Costs: $8,010 $1,020 $1,771 $390 $2,763 $9,447 $0 2021 2016 2017 2018 2019 2020 Amended 2022 Actual Actual Actual Actual Actual Budget Proposed Total Personnel Costs: $318,142 $224,348 $234,847 $230,378 $276,329 $277,470 $346,088 LAYDOWN 10/20/2021 City Council Work Session POLICE,, ANIMAL CONTROL & JAIL General Fund - Police Revenue and Expenditure Budget (01000-1210) 2021 General - Police (01000-1210) 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 Revenue and Expense Budget Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Revenues: Operating Revenue: 4102 DMV Drivers License 21,353 18,908 15,818 29,910 20,490 19,000 6,865 19,475 4103 Motor Vehicles 61,551 50,388 60,985 70,826 43,541 58,000 16,858 60,000 4203 Dispatch Contract w/SOA 36,000 36,000 36,000 36,000 36,000 36,000 18,000 36,000 4204 KBP 911 Dispatch 52,560 52,800 52,800 52,800 52,800 52,800 26,400 52,800 4251 Federal GF Grants 0 721 3,735 0 8,707 0 0 0 4252 State GF Grants 0 0 0 0 0 0 2,555 0 4253 Misc GF Grants 0 0 0 0 1,850 0 0 0 4322 Micellaneous Dispatching 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 4323 Micellaneous Police Fees 2,389 2,500 2,135 3,506 1,870 2,500 1,305 2,500 Total Operating Revenue: $183,853 $171,317 $181,473 $203,041 $175,258 $178,300 $81,983 $180,775 Total Revenues: $183,853 $171,317 $181,473 $203,041 $175,258 $178,300 $81,983 $180,775 Expenditures: Personnel Costs: 6000 Salaries 899,329 985,562 1,011,539 972,089 565,021 1,085,537 701,195 1,430,172 6001 Overtime 61,354 93,588 103,936 154,603 62,645 97,755 73,078 100,000 6100 Medicare 21,174 22,855 24,983 23,941 9,889 25,685 16,274 29,925 6101 Unemployment Insurance 5,640 4,810 0 0 1,682 0 2,175 0 6102 Workers' Compensation 37,457 53,782 68,885 73,124 34,444 75,513 41,472 89,515 6200 Leave Time 116,156 145,472 116,036 98,664 57,805 122,372 76,451 0 6201 Retirement Benefits 106,882 107,380 99,652 306,681 66,767 66,145 58,533 309,182 6202 Health Insurance 448,549 451,281 495,540 516,866 273,543 599,400 317,996 794,753 Total Personnel Costs: $1,696,541 $1,864,730 $1,920,571 $2,145,968 $1,071,796 $2,072,407 $1,287,174 $2,753,547 Non -Personnel Costs: 7001 Communications 20,338 17,815 20,996 21,267 24,130 20,000 16,803 20,000 7002 Postage and Freight 1,795 1,129 726 1,309 985 2,000 804 1,300 7003 Bank and Credit Card Fees 6,306 5,396 6,529 8,541 5,511 6,100 2,072 6,000 7004Insurance 78,463 66,096 75,851 65,455 79,931 80,000 47,206 80,000 7006 Legal 0 0 0 0 0 0 0 10,000 7009 Contracted Services 1,663 2,919 2,671 7,587 59,498 34,234 49,875 68,000 7011 Testing 1,062 322 20 0 0 0 0 0 7012 Other Special Services 4,947 2,260 3,206 1,606 12,766 3,300 172 4,175 7016 Heating Fuel 450 0 0 0 0 0 0 0 7018 Towing Fees 0 0 0 0 0 0 0 5,000 7210 Vehicle Supplies 0 0 0 0 4,022 0 0 0 7211 Gas & Lube 10,920 12,853 15,502 12,177 12,702 19,000 8,325 19,000 7212 Uniform Allowance 2,906 5,052 3,272 4,513 5,191 5,000 1,562 8,000 7213 Safety Equipment 1,630 1,387 1,230 1,666 4,156 2,000 0 6,500 7215 Operating Supplies 11,633 13,710 11,056 10,739 25,364 14,500 6,764 13,775 7216 Maintenance & Repair 9,823 14,486 16,134 15,963 36,140 20,000 14,595 19,000 7217 Small Tools & Equipment 2,860 4,069 0 9,174 5,476 41,000 34,057 8,000 7300 Advertising 2,992 6,278 1,767 408 1,010 2,000 630 2,000 7301 Subscriptions & Dues 5,136 4,957 4,890 3,465 1,150 6,000 2,348 5,000 7302 Travel& Subsistence 22,645 26,732 40,491 16,114 15,615 15,000 5,482 26,000 General Fund - Police Revenue and Expenditure Budget (01000-1210) General - Police (01000-1210) Revenue and Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Non -Personnel Costs: 7303 Education & Training 3,503 2,504 12,480 2,119 16,170 25,000 5,522 15,000 7304 Equipment Rent 2,560 2,028 1,515 0 0 2,500 902 3,000 7308 Police Recruitment Incentive 0 0 0 0 0 0 0 0 7309 Police Academy Training 0 0 0 0 0 0 0 26,000 7808 Bad Debt Expense 30 0 0 0 0 0 0 0 7810 Miscellaneous Expense 1,313 2,313 1,826 1,437 167 3,500 1,223 1,000 8103 Capital Equipment 48,037 0 0 0 0 0 0 0 8104 Motor Pool Rent 0 0 0 0 50,000 50,000 49,014 0 Total Non -Personnel Costs: $241,012 $192,306 $220,162 $183,540 $359,984 $351,134 $247,357 $346,750 Total Expenditures: $1,937,553 $2,057,036 $2,140,733 $2,329,508 $1,431,780 $2,423,541 $1,534,531 $3,100,297 General Fund - Jail Revenue and Expenditure Budget (01000-1211) 2021 General - Jail (01000-1211) 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 Revenue and Expense Budget Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Revenues: Operating Revenue: 4202JailContract 368,952 368,952 368,952 368,952 368,952 350,000 184,476 368,952 4251 Federal GF Grants 0 0 0 0 635 0 0 0 4300 Admin Expense - Jail 0 99,951 0 0 0 0 0 0 4382 Jail Facility Rental 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Total Operating Revenue: $398,952 $498,903 $398,952 $398,952 $399,587 $380,000 $214,476 $398,952 Total Revenues: $398,952 $498,903 $398,952 $398,952 $399,587 $380,000 $214,476 $398,952 Expenditures: Personnel Costs: 6000 Salaries 227,812 201,000 191,977 185,951 119,232 308,295 159,595 338,030 6001 Overtime 35,059 44,030 69,705 43,942 23,750 45,952 27,411 42,350 6100 Medicare 4,136 3,658 3,745 3,434 2,671 5,363 3,466 5,516 6101 Unemployment Insurance 0 0 157 0 1,370 0 0 0 6102 Workers' Compensation 20,622 19,446 22,115 21,550 11,596 33,998 12,944 22,252 6200 Leave Time 15,325 19,914 16,270 18,055 11,402 31,172 21,327 0 6201 Retirement Benefits 30,713 25,078 23,535 67,676 10,309 19,194 16,336 82,955 6202 Health Insurance 135,666 121,685 132,736 138,912 80,438 199,800 76,274 229,204 6209 Contra -Retirement PERS 0 0 0 0 0 0 -1,212 0 Total Personnel Costs: $469,333 $434,811 $460,240 $479,520 $260,768 $643,774 $316,141 $720,307 Non -Personnel Costs: 7001 Communications 4,925 4,382 5,071 5,848 5,771 4,500 4,862 6,000 7002 Postage and Freight 213 199 3 10 74 1,000 34 100 7004Insurance 25,682 20,754 22,094 18,844 24,034 23,000 14,144 22,300 7009 Contracted Services 0 595 910 649 911 2,000 2,460 2,450 7011 Testing 341 188 321 0 0 200 0 350 7017 Rents & Leases 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 7212 Uniform Allowance 1,422 611 991 0 1,586 2,500 1,015 1,600 7214 Janitorial Supplies 1,232 1,320 0 0 0 2,000 688 600 7215 Operating Supplies 3,753 3,554 5,000 755 2,340 6,500 5,067 5,850 7216 Maintenance & Repair 700 585 3,330 0 1,959 3,000 2,174 3,300 7217 Small Tools & Equipment 560 1,149 1,293 0 314 2,000 2,396 2,675 7218Inmate Meals 10,061 8,628 5,635 8,386 10,926 9,000 5,843 9,000 7300 Advertising 1,461 3,960 0 0 0 1,000 0 1,000 7301 Subscriptions & Dues 543 94 89 0 0 1,000 0 150 7302 Travel & Subsistence 1,548 2,055 630 0 1,390 2,000 3,200 3,000 7303 Education & Training 20 275 0 0 0 2,000 0 500 7307 GF Administrative Fee 97,097 99,951 91,513 92,761 110,103 112,537 112,537 114,788 7810 Miscellaneous Expense 270 50 200 215 191 1,200 490 300 Total Non -Personnel Costs: $179,828 $178,350 $167,080 $157,468 $189,599 $205,437 $184,910 $203,963 Total Expenditures: $649,161 $613,161 $627,320 $636,988 $450,367 $849,211 $501,052 $924,270 Loss:-250,209-114,258-228,368-238,036-50,780-469,211-525,318 General Fund - Animal Control Revenue and Expenditure Budget (01000-1212) General - Animal Control (01000- 2021 1212) Revenue and Expense 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 Budget Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Revenues: Operating Revenue: 4104 Animal Control Licenses 105 145 90 200 235 200.00 100 175 4253 Misc Grants 4320 Misc Dog Fees Total Operating Revenue: Total Revenues: Expenditures: Personnel Costs: 6000 Salaries 6001 Overtime 6100 Medicare 6101 Unemployment Insurance 6102 Workers' Compensation 6200 Leave Time 6201 Retirement Benefits 6202 Health Insurance Total Personnel Costs: Non -Personnel Costs: 7001 Communications 7002 Postage and Freight 7004 Insurance 7009 Contracted Services 7011 Testing 7012 Other Special Services 7015 Utilities 7211 Gas & Lube 7212 Uniform Allowance 7215 Operating Supplies 7216 Maintenance & Repair 7217 Small Tools & Equipment 7300 Advertising 7301 Subscriptions & Dues 7302 Travel & Subsistence 7303 Education & Training 7304 Equipment Rent 7810 Miscellaneous Expense Total Non -Personnel Costs: Total Expenditures: 0 0 600 0 0 0.00 0 0 1,075 742 540 1,139 550 600.00 300 550 $1,180 $887 $1,230 $1,339 $785 $800 $400 $725 1,180 887 $1,230 $1,339 785 800 400 725 55,354 58,302 57,899 66,452 67,033 79,575 49,558 83,357 4,106 3,272 7,146 3,704 4,967 0 2,003 4,325 899 913 953 995 1,075 1,219 891 2,938 0 0 1,602 0 0 0 0 0 7,066 5,296 3,512 4,002 3,502 8,065 2,004 5,129 5,675 5,372 5,676 6,877 6,926 9,045 7,264 0 6,655 6,275 5,760 24,142 12,280 4,365 6,134 18,157 26,961 27,860 29,254 33,127 14,922 33,300 9,888 18,335 $106,716 $107,290 $111,802 $139,299 $110,705 $135,569 $77,742 $132,241 1,288 644 418 340 440 1,200 440 650 143 51 0 0 0 500 0 100 1,241 1,247 1,492 1,361 1,613 1,000 956 1,813 0 0 95 85 0 0 0 0 0 186 0 0 0 0 0 0 0 0 0 0 -10,500 0 0 0 5,482 6,753 6,153 5,900 7,954 6,000 4,579 10,000 532 213 173 137 73 1,000 0 3,000 499 415 0 358 1,202 1,200 90 1,200 3,344 3,882 5,600 1,779 936 5,000 2,575 3,875 114 24,782 1,145 233 40 4,000 151 4,425 0 399 592 173 0 1,500 0 1,500 610 1,079 0 312 0 1,000 0 400 125 149 175 0 25 500 0 100 0 1,114 401 864 0 2,500 0 1,000 0 0 174 200 347 500 0 1,000 95 255 0 0 0 500 0 100 0 0 0 423 0 1,200 0 100 $13,473 $41,169 $16,418 $12,165 $2,130 $27,600 $8,792 $29,263 $120,189 $148,459 $128,220 $151,464 $112,835 $163,169 $86,533 $161,504