Loading...
HomeMy WebLinkAboutPSAP Financial Report - October 31, 2021Saint Joseph County Public Safety Communications Consortium Monthly PSAP Financial Report October 31, 2021 Saint Joseph County PSAP Operating Fund Financial Report October 31, 2021 2021 2021 YTD YTD Budget Percent Account Actual Actual Actual Actual Original Budget Amended Actual Estimated Estimated Balance of Amended Number Description 12/31/2017 12/31/2018 12/31/2019 12/31/2020 Budget Adjustments Budget 10/31/2021 Nov-Dec 12/31/2021 12/31/2021 Budget Fund 1222 - Statewide 911 Fund Revenue 2709 State 911 Revenue ($145,449)2,119,424 2,165,225 2,268,739 2,366,786 1,745,388 426,479 2,171,867 1,454,490 717,377 2,171,867 0 100% 2700 Other 0 0 2,353 0 0 0 0 0 0 0 0 0% 2711 Reimbursements 31,443 50 183 0 0 0 0 0 0 0 0 100% 6101 Bank Account Interest 0 10,079 29,458 19,974 20,000 (12,339)7,661 7,661 0 7,661 0 100% 6405 Payroll Withholding 0 0 0 894 0 0 0 0 0 0 0 0% 8400 Investment Interest 0 18,319 41,892 48,157 40,000 (14,778)25,222 25,222 0 25,222 0 100% 9999 Transfer In 106,322 0 0 0 0 0 0 0 0 0 0 0% Total Revenue 2,257,189 2,193,673 2,342,624 2,435,811 1,805,388 399,362 2,204,750 1,487,373 717,377 2,204,750 0 100% Expenditures 11032 Executive Director 65,577 80,000 90,000 92,700 92,700 0 92,700 78,438 14,262 92,700 0 100% 11312 IT Manager 13,462 53,846 66,731 72,100 72,100 0 72,100 61,008 11,092 72,100 0 100% 11314 IT Technician 45,000 32,452 0 0 0 0 0 0 0 0 0 0% 11409 Training Officer 54,006 18,846 0 0 0 0 0 0 0 0 0 0% 11973 Quality Assurance Manager 0 0 11,022 42,785 48,410 11,590 60,000 46,757 13,243 60,000 0 100% 11410 Communications Supervisor 145,655 149,677 157,093 161,645 169,500 0 169,500 135,995 25,929 161,924 7,576 96% 11412 Telecommunicator II 1,334,449 0 0 0 0 0 0 0 0 0 0 0% 11413 Telecommunicator I 813,519 0 0 0 0 0 0 0 0 0 0 0% 11414 Supervisor Pay Differential 23,816 20,717 3,845 0 0 0 0 0 0 0 0 100% 11415 On-Call Employee 0 37,559 23,074 8,424 35,000 0 35,000 20,582 0 20,582 14,418 59% 11417 Training Manager 0 0 0 0 0 60,000 60,000 26,191 9,231 35,422 24,578 59% 11452 Administrative Manager 40,000 45,000 41,884 47,277 47,277 0 47,277 40,004 7,273 47,277 0 100% 11458 Operations Manager 65,000 125,577 140,000 144,200 144,200 0 144,200 122,016 22,184 144,200 0 100% 11509 Public Information Officer 40,000 40,000 40,800 42,024 42,024 0 42,024 35,559 6,465 42,024 0 100% 11578 Education Overtime 0 0 0 0 0 0 0 0 0 0 0 0% 11979 CAD/Radio Specialist 0 0 0 55,385 60,000 0 60,000 50,769 9,231 60,000 0 100% 14800 FICA 0 303,368 306,760 320,463 357,785 0 357,785 285,176 72,609 357,785 (0)100% 14810 PERF 0 454,803 461,704 486,815 523,816 0 523,816 428,916 94,900 523,816 0 100% 14840 Group Medical Insurance 0 936,000 167,000 1,371,330 1,401,300 0 1,401,300 1,050,975 350,325 1,401,300 0 100% 22010 Gas Oil & Lubricants 1,217 0 0 0 0 0 0 0 0 0 0 0% 23460 Other Materials 30 0 0 0 0 0 0 0 0 0 0 0% 32050 Instruction & Training 3,235 0 0 0 0 0 0 0 0 0 0 0% 36015 Contractual Services 622 0 0 0 0 0 0 0 0 0 0 0% 36051 Technology - Lease Equipment 668,021 0 0 0 0 0 0 0 0 0 0 0% 36100 Repairs - Auto & Trucks 0 2,353 0 0 0 0 0 0 0 0 0 0% 65030 Inter Fund Transfer (PSAP Center Maint.)29,693 0 0 0 0 0 0 0 0 0 0 0% Total Expenditures 3,343,301 2,300,198 1,509,912 2,845,147 2,994,112 71,590 3,065,702 2,382,385 636,744 3,019,129 46,573 98% Net Surplus/(Deficit)(1,086,112)(106,525)832,712 (409,335)(1,188,724)(860,952)(895,013)80,633 (814,380) Beginning Cash Balance 3,715,805 2,629,693 2,523,168 3,355,880 2,946,545 2,946,545 2,946,545 2,946,545 Ending Cash Balance 2,629,693 2,523,168 3,355,880 2,946,545 1,757,821 2,085,592 2,051,532 2,132,165 Fund 4930 - Dispatch Operating Fund Revenue 2711 Saint Joseph County ($296,282 per month)2,774,988 3,415,380 3,892,151 3,852,672 3,555,382 0 3,555,382 2,666,536 888,846 3,555,382 0 100% 2711 City of South Bend - ($211,994 per month)1,997,628 2,338,776 2,749,751 2,698,781 2,543,931 0 2,543,931 2,119,943 423,989 2,543,931 0 100% 2711 City of Mishawaka - ($108,521 per month)993,396 1,180,008 1,413,666 1,411,903 1,302,256 0 1,302,256 1,085,213 217,043 1,302,256 0 100% 2711 Other Reimbursement 0 0 0 362 0 141 141 141 0 141 0 100% 2715 AT&T Telephone Reimbursement 0 0 0 0 0 442,654 442,654 0 442,654 442,654 0 100% 0000 General Government 0 0 0 296 0 287 287 287 0 287 0 100% 5206 Transfer of Funds 420 0 0 9,153 0 0 0 0 0 0 0 0% 6101 Bank Account Interest 0 4,317 18,341 12,045 20,000 (11,057)8,943 8,943 0 8,943 0 100% 8400 Investment Interest 0 6,297 20,260 24,917 20,000 8,799 28,799 28,799 0 28,799 0 100% 5600 Refunds 156,268 4,072 0 0 0 0 0 0 0 0 0 0% Total Revenue 5,922,700 6,948,850 8,094,169 8,010,129 7,441,569 440,824 7,882,393 5,909,862 1,972,531 7,882,393 0 100% Expenditures 11409 Training Officer 0 0 0 0 0 0 0 0 0 0 0 100% 11411 Telecommunicator III 484,956 2,436,755 2,579,604 1,296,991 2,483,845 (1,050,000)1,433,845 862,312 142,285 1,004,597 429,248 70% 11412 Telecommunicator II 0 0 0 715,437 453,200 220,000 673,200 562,843 116,427 679,270 (6,070)101% 11413 Telecommunicator I 0 0 3,730 268,956 0 670,000 670,000 431,545 119,965 551,510 118,490 82% 2 Saint Joseph County PSAP Operating Fund Financial Report October 31, 2021 2021 2021 YTD YTD Budget Percent Account Actual Actual Actual Actual Original Budget Amended Actual Estimated Estimated Balance of Amended Number Description 12/31/2017 12/31/2018 12/31/2019 12/31/2020 Budget Adjustments Budget 10/31/2021 Nov-Dec 12/31/2021 12/31/2021 Budget 11414 Acting Comm Supervisor Pay Dif 420 0 0 0 0 0 0 0 0 0 0 0% 11415 On-Call Employee 15,803 3,759 31,029 25,200 0 0 0 0 0 0 0 100% 11416 Telecommunicator IV 0 259,638 242,525 329,080 338,870 (48,410)290,460 298,050 48,602 346,652 (56,192)119% 11571 Overtime 754,546 799,682 584,353 820,083 477,000 0 477,000 785,027 180,000 965,027 (488,027)202% 14711 Longevity Pay 0 0 21,186 16,595 22,150 0 22,150 12,390 33,700 46,090 (23,940)208% 14712 QA Pay 0 0 9,573 13,320 10,000 0 10,000 11,482 2,500 13,982 (3,982)140% 14713 CTO Pay 0 0 53,597 58,900 72,000 0 72,000 108,635 38,000 146,635 (74,635)204% 14714 Holiday Pay 0 0 52,314 54,851 75,000 0 75,000 958 74,042 75,000 0 100% 14715 Shift Differential 0 0 19,998 20,092 22,000 0 22,000 64,389 39,000 103,389 (81,389)470% 14716 Foreign Language Pay 0 0 2,795 2,436 3,600 0 3,600 4,051 850 4,901 (1,301)136% 14717 Certification Pay 0 0 0 0 7,600 0 7,600 1,100 26,500 27,600 (20,000)363% 14718 Hazard Pay (70 x $600)0 0 0 42,000 0 0 0 0 0 0 0 0% 16801 Incentive Pay 0 0 0 0 0 160,000 160,000 81,354 732 82,086 77,914 51% 14800 FICA 277,375 0 126 0 0 0 0 0 0 0 0 0% 14810 PERF 417,810 0 188 0 0 0 0 0 0 0 0 0% 14840 Group Health Insurance 912,000 0 1,169,000 0 0 0 0 0 0 0 0 0% 21030 Office Supplies 9,308 11,124 10,570 9,462 10,000 134 10,134 10,498 2,000 12,498 (2,364)123% 22010 Gas Oil & Lubricants 3,661 7,292 6,107 4,124 8,000 0 8,000 2,723 662 3,385 4,615 42% 23460 Other Materials 12,304 14,092 3,462 3,067 12,000 108 12,108 1,769 1,300 3,069 9,039 25% 31010 Legal Services 5,351 24,316 5,913 9,487 30,000 40,000 70,000 67,574 2,200 69,774 226 100% 31070 Financial Consulting 0 0 26,747 27,905 30,000 0 30,000 31,952 12,500 44,452 (14,452)148% 32010 Mileage Allowance 657 957 891 745 1,000 0 1,000 301 699 1,000 (0)100% 32020 Travel 1,664 0 0 0 0 0 0 0 0 0 0 0% 32050 Instruction & Training 33,933 121,662 64,241 54,386 65,000 4,212 69,212 61,899 2,500 64,399 4,813 93% 32055 Public Eduation 0 0 0 0 5,000 0 5,000 625 0 625 4,375 13% 32071 Technology - Maint. & Support 441,440 842,034 774,545 576,082 606,331 (33,353)572,978 510,834 200,000 710,834 (137,856)124% 32200 Telephone 170,492 225,888 123,725 87,942 97,000 0 97,000 89,787 21,000 110,787 (13,787)114% 32350 Postage 87 55 131 51 232 0 232 60 60 120 112 52% 33021 Help Wanted Advertising 0 0 0 0 0 60,000 60,000 33,515 0 33,515 26,485 56% 34030 Liabiity Insurance Coverage 44,500 105,000 105,000 105,000 105,000 0 105,000 105,000 0 105,000 0 100% 35015 Utilities 95,108 97,614 101,776 94,251 119,000 (20,000)99,000 80,259 18,735 98,994 6 100% 37100 Auto Leasing (paid from principal/interest)0 0 0 0 0 0 0 0 0 0 0 0% 36015 Contractual Services 55,769 72,941 56,665 106,106 110,000 (38,400)71,600 42,403 3,200 45,603 25,997 64% 36051 Technology - Lease Equipment 1,367,413 0 0 0 0 0 0 0 0 0 0 0% 36100 Repair - Auto/Truck 0 0 2,353 35 2,000 0 2,000 0 0 0 2,000 0% 36300 Repair - Office Equipment 4,976 5,000 3,011 846 5,000 706 5,706 4,380 0 4,380 1,326 77% 38010 Paying Agent Fees 0 0 0 600 0 0 0 0 0 0 0 0% 38012 Capital Lease - Interest 0 250,338 222,852 190,017 154,635 0 154,635 115,350 39,285 154,635 0 100% 38013 Capital Lease - Principal 0 1,371,042 1,402,620 1,479,511 1,506,572 0 1,506,572 728,528 778,044 1,506,572 (0)100% 36011 Building Maintenance 0 0 24,912 24,725 25,000 2,646 27,646 5,768 1,500 7,268 20,378 26% 36018 Tower Maintenance 0 0 0 2,150 27,000 0 27,000 6,840 2,500 9,340 17,660 35% 43010 Tower Improvements (1)0 0 0 0 0 2,200,000 2,200,000 0 0 0 2,200,000 0% 44310 Radio Equipment (1)0 0 0 0 0 1,400,000 1,400,000 0 0 0 1,400,000 0% 45523 ERP Software Allocation 0 0 0 16,750 0 0 0 0 0 0 0 0% 65030 Transfer Out - To Fund 1222 106,322 0 0 0 0 0 0 0 0 0 0 0% Total Expenditures 5,215,895 6,649,189 7,705,541 6,457,184 6,884,035 3,567,643 10,451,678 5,124,202 1,908,788 7,032,990 3,418,688 67% Net Surplus/(Deficit)706,805 299,661 388,634 1,552,945 557,534 (2,569,285)785,660 63,743 849,403 Beginning Cash Balance 155,367 862,172 1,161,834 1,550,468 3,103,413 3,103,413 3,103,413 3,103,413 Ending Cash Balance 862,172 1,161,834 1,550,468 3,103,413 3,660,947 534,128 3,889,072 3,952,816 Encumbrance for Tower & Radio projects approved by the County Council & Commissioners (1)(3,600,000) Adjusted Balance 352,816 Summary Total Revenue 8,179,889 9,142,523 10,436,799 10,445,941 9,246,957 10,087,143 7,397,235 2,689,908 10,087,142 Total Expenditures 8,559,196 8,949,387 9,215,453 9,302,331 9,878,147 13,517,380 7,506,588 2,545,532 10,052,119 Net Surplus/(Deficit)(379,307)193,136 1,221,346 1,143,610 (631,190)(3,430,237)(109,353)144,376 35,023 Beginning Cash Balance 3,871,172 3,491,866 3,685,002 4,906,348 6,049,957 6,049,957 6,049,957 6,049,957 Ending Cash Balance 3,491,866 3,685,002 4,906,348 6,049,957 5,418,767 2,619,720 5,940,604 6,084,980 Proof 0 0 0 0 0 0 0 0 3 Saint Joseph County PSAP Operating Consolidated Financial Report October 31, 2021 2021 2021 YTD YTD Budget Percent Account Fund Actual Actual Actual Actual Original Budget Amended Actual Estimated Estimated Balance of Amended Number Number Description 12/31/2017 12/31/2018 12/31/2019 12/31/2020 Budget Adjustments Budget 10/31/2021 Nov-Dec 12/31/2021 12/31/2020 Budget Revenue 2709 1222 State 911 Revenue ($145,449 per month)2,119,424 2,165,225 2,268,739 2,366,786 1,745,388 426,479 2,171,867 1,454,490 717,377 2,171,867 0 100% 2700 1222 Other 0 0 2,358 0 0 0 0 0 0 0 0 0% 2711 4930 Saint Joseph County ($321,056 per month)2,774,988 3,415,380 3,892,151 3,852,672 3,555,382 0 3,555,382 2,666,536 888,846 3,555,382 0 100% 2711 4930 City of South Bend ($224,898 per month)1,997,628 2,338,776 2,749,751 2,698,781 2,543,931 0 2,543,931 2,119,943 423,989 2,543,931 0 100% 2711 4930 City of Mishawaka ($117,659 per month)993,396 1,180,008 1,413,666 1,411,903 1,302,256 0 1,302,256 1,085,213 217,043 1,302,256 0 100% 2715 4930 AT&T Telephone Reimbursement 0 0 0 0 0 442,654 442,654 0 442,654 442,654 0 0% 2711 4930 Other Reimbursement 0 0 0 362 0 141 141 141 0 141 0 100% 0000 4930 General Government 0 0 0 296 0 287 287 287 0 287 0 100% 5206 4930 Transfer of Funds 420 0 0 9,153 0 0 0 0 0 0 0 0% 5600 4930 Refunds 156,268 4,072 0 0 0 0 0 0 0 0 0 0% 2711 1222 Reimbursements 31,443 50 183 0 0 0 0 0 0 0 0 0% 6101 1222 Bank Account Interest 0 10,079 29,458 19,974 20,000 (12,339)7,661 7,661 0 7,661 0 100% 6101 4930 Bank Account Interest 0 4,317 41,892 12,045 20,000 (11,057)8,943 8,943 0 8,943 0 100% 6405 1222 Payroll Withholding 0 0 0 894 0 0 0 0 0 0 0 8400 1222 Investment Interest 0 18,319 18,341 48,157 40,000 (14,778)25,222 25,222 0 25,222 0 100% 8400 4930 Investment Interest 0 6,297 20,260 24,917 20,000 8,799 28,799 28,799 0 28,799 0 100% 9999 1222 Transfer In - From Fund 4930 106,322 0 0 0 0 0 0 0 0 0 0 0% Total Revenue 8,179,889 9,142,523 10,436,799 10,445,941 9,246,957 840,186 10,087,143 7,397,235 2,689,908 10,087,142 0 100% Expenditures 11032 1222 Executive Director 65,577 80,000 90,000 92,700 92,700 0 92,700 78,438 14,262 92,700 0 100% 11312 1222 IT Manager 13,462 53,846 66,731 72,100 72,100 0 72,100 61,008 11,092 72,100 0 100% 11314 1222 IT Technician 45,000 32,452 0 0 0 0 0 0 0 0 0 0% 11409 1222 Training Officer 54,006 18,846 0 0 0 0 0 0 0 0 0 0% 11409 4930 Training Officer 0 0 0 0 0 0 0 0 0 0 0 0% 11973 1222 Quality Assurance Manager 0 0 11,022 42,785 48,410 11,590 60,000 46,757 13,243 60,000 0 100% 11410 1222 Communications Supervisor 145,655 149,677 157,093 161,645 169,500 0 169,500 135,995 25,929 161,924 7,576 96% 11411 4930 Telecommunicator III 484,956 2,436,755 2,579,604 1,296,991 2,483,845 (1,050,000)1,433,845 862,312 142,285 1,004,597 429,248 70% 11412 4930 Telecommunicator II 1,334,449 0 0 715,437 453,200 220,000 673,200 562,843 116,427 679,270 (6,070)101% 11413 4930 Telecommunicator I 813,519 0 3,730 268,956 0 670,000 670,000 431,545 119,965 551,510 118,490 0% 11414 1222 Shift Differential 23,816 20,717 3,845 0 0 0 0 0 0 0 0 0% 11414 4930 Acting Comm Supervisor Pay Dif 420 0 0 0 0 0 0 0 0 0 0 0% 11415 1222 On-Call Employee 0 37,559 23,074 8,424 35,000 0 35,000 20,582 0 20,582 14,418 59% 11415 4930 On-Call Employee 15,803 3,759 31,029 25,200 0 0 0 0 0 0 0 0% 11416 4930 Telecommunicator IV 0 259,638 242,525 329,080 338,870 (48,410)290,460 298,050 48,602 346,652 (56,192)119% 11417 1222 Training Managaer 0 0 0 0 0 60,000 60,000 26,191 9,231 35,422 24,578 59% 11452 1222 Administrative Manager 40,000 45,000 41,884 47,277 47,277 0 47,277 40,004 7,273 47,277 0 100% 11458 1222 Operations Manager 65,000 125,577 140,000 144,200 144,200 0 144,200 122,016 22,184 144,200 0 100% 11509 1222 Public Information Officer 40,000 40,000 40,800 42,024 42,024 0 42,024 35,559 6,465 42,024 0 100% 11571 4930 Overtime 754,546 799,682 584,353 820,083 477,000 0 477,000 785,027 180,000 965,027 (488,027)202% 11578 1222 Education Overtime 0 0 0 0 0 0 0 0 0 0 0 0% 11979 1222 CAD/Radio Specialist 0 0 0 55,385 60,000 0 60,000 50,769 9,231 60,000 0 100% 14711 4930 Longevity Pay 0 0 21,186 16,595 22,150 0 22,150 12,390 33,700 46,090 (23,940)208% 14712 4930 QA Pay 0 0 9,573 13,320 10,000 0 10,000 11,482 2,500 13,982 (3,982)140% 14713 4930 CTO Pay 0 0 53,597 58,900 72,000 0 72,000 108,635 38,000 146,635 (74,635)204% 14714 4930 Holiday Pay 0 0 52,314 54,851 75,000 0 75,000 958 74,042 75,000 0 100% 14715 4930 Shift Differential 0 0 19,998 20,092 22,000 0 22,000 64,389 39,000 103,389 (81,389)470% 14716 4930 Foreign Language Pay 0 0 2,795 2,436 3,600 0 3,600 4,051 850 4,901 (1,301)136% 14717 4930 Certification Pay 0 0 0 0 7,600 0 7,600 1,100 26,500 27,600 (20,000)363% 14718 4930 Hazard Pay 0 0 0 42,000 0 0 0 0 0 0 0 0% 16801 4930 Incentive Pay 0 0 0 0 0 160,000 160,000 81,354 732 82,086 77,914 0% 14800 1222 FICA 0 303,368 306,760 320,463 357,785 0 357,785 285,176 72,609 357,785 (0)100% 14800 4930 FICA 277,375 0 126 0 0 0 0 0 0 0 0 0% 4 Saint Joseph County PSAP Operating Consolidated Financial Report October 31, 2021 2021 2021 YTD YTD Budget Percent Account Fund Actual Actual Actual Actual Original Budget Amended Actual Estimated Estimated Balance of Amended Number Number Description 12/31/2017 12/31/2018 12/31/2019 12/31/2020 Budget Adjustments Budget 10/31/2021 Nov-Dec 12/31/2021 12/31/2020 Budget 14810 1222 PERF 0 454,803 461,704 486,815 523,816 0 523,816 428,916 94,900 523,816 0 100% 14810 4930 PERF 417,810 0 188 0 0 0 0 0 0 0 0 0% 14840 1222 Group Health Insurance 0 936,000 167,000 1,371,330 1,401,300 0 1,401,300 1,050,975 350,325 1,401,300 0 100% 14840 4930 Group Health Insurance 912,000 0 1,169,000 0 0 0 0 0 0 0 0 0% Total Personnel Costs 5,503,393 5,797,679 6,279,931 6,509,088 6,959,377 23,180 6,982,557 5,606,521 1,459,347 7,065,868 (83,311)101% 21030 4930 Office Supplies 9,308 11,124 10,570 9,462 10,000 134 10,134 10,498 2,000 12,498 (2,364)123% 22010 1222 Gas Oil & Lubricants 1,217 0 0 0 0 0 0 0 0 0 0 0% 22010 4930 Gas Oil & Lubricants 3,661 7,292 6,107 4,124 8,000 0 8,000 2,723 662 3,385 4,615 42% 23460 1222 Other Materials 30 0 0 0 0 0 0 0 0 0 0 0% 23460 4930 Other Materials 12,304 14,092 3,462 3,067 12,000 108 12,108 1,769 1,300 3,069 9,039 25% 31010 4930 Legal Services 5,351 24,316 5,913 9,487 30,000 40,000 70,000 67,574 2,200 69,774 226 100% 31070 4930 Financial Consulting 0 0 26,747 27,905 30,000 0 30,000 31,952 12,500 44,452 (14,452)0% 32010 4930 Mileage Allowance 657 957 891 745 1,000 0 1,000 301 699 1,000 (0)100% 32020 4930 Travel 1,664 0 0 0 0 0 0 0 0 0 0 0% 32050 1222 Instruction & Training 3,235 0 0 0 0 0 0 0 0 0 0 0% 32050 4930 Instruction & Training 33,933 121,662 64,241 54,386 65,000 4,212 69,212 61,899 2,500 64,399 4,813 93% 32055 4930 Public Eduation 0 0 0 0 5,000 0 5,000 625 0 625 4,375 13% 32071 4930 Technology - Maint. & Support 441,440 842,034 774,545 576,082 606,331 (33,353)572,978 510,834 200,000 710,834 (137,856)124% 32200 4930 Telephone 170,492 225,888 123,725 87,942 97,000 0 97,000 89,787 21,000 110,787 (13,787)114% 32350 4930 Postage 87 55 131 51 232 0 232 60 60 120 112 52% 33021 4930 Help Wanted Advertising 0 0 0 0 0 60,000 60,000 33,515 0 33,515 26,485 56% 34030 4930 Liabiity Insurance Coverage 44,500 105,000 105,000 105,000 105,000 0 105,000 105,000 0 105,000 0 100% 35015 4930 Utilities 95,108 97,614 101,776 94,251 119,000 (20,000)99,000 80,259 18,735 98,994 6 100% 37100 4930 Auto Lease 0 0 0 0 0 0 0 0 0 0 0 0% 36015 1222 Contractual Services 622 0 0 0 0 0 0 0 0 0 0 0% 36015 4930 Contractual Services 55,769 72,940 56,665 106,106 110,000 (38,400)71,600 42,403 3,200 45,603 25,997 64% 36051 1222 Technology - Lease Equipment 668,021 0 0 0 0 0 0 0 0 0 0 0% 36051 4930 Technology - Lease Equipment 1,367,413 0 0 0 0 0 0 0 0 0 0 0% 36300 4930 Repair - Office Equipment 4,975 5,000 3,011 846 5,000 706 5,706 4,380 0 4,380 1,326 77% 36100 1222 Repair - Autos & Trucks 0 2,353 0 0 0 0 0 0 0 0 0 0% 36100 4930 Repair - Autos & Trucks 0 0 2,353 35 2,000 0 2,000 0 0 0 2,000 0% 38010 4930 Paying Agent Fees 0 0 0 600 0 0 0 0 0 0 0 0% 38012 4930 Capital Lease - Interest 0 250,338 222,852 190,017 154,635 0 154,635 115,350 39,285 154,635 0 100% 38013 4930 Capital Lease - Principal 0 1,371,042 1,402,620 1,479,513 1,506,572 0 1,506,572 728,528 778,044 1,506,572 (0)100% 65030 4930 Transfer Out - To Fund 1222 106,322 0 0 0 0 0 0 0 0 0 0 0% 36011 4930 Building Maintenance 0 0 24,912 24,725 25,000 2,646 27,646 5,768 1,500 7,268 20,378 0% 36018 4930 Tower Maintenance 0 0 0 2,150 27,000 0 27,000 6,840 2,500 9,340 17,660 0% 43010 4930 Tower Improvements (1)0 0 0 0 0 2,200,000 2,200,000 0 0 0 2,200,000 0% 44310 4930 Radio Equipment (1)0 0 0 0 0 1,400,000 1,400,000 0 0 0 1,400,000 0% 45523 4930 ERP Software Allocation 0 0 0 16,750 0 0 0 0 0 0 0 0% 65030 1222 Building Maintenance 29,693 0 0 0 0 0 0 0 0 0 0 0% Total Expenditures 8,559,195 8,949,386 9,215,453 9,302,333 9,878,147 3,639,233 13,517,380 7,506,588 2,545,532 10,052,119 3,465,261 74% Net Surplus/(Deficit)(379,306)193,137 1,221,346 1,143,608 (631,190)(3,430,237)(109,353)144,376 35,023 Beginning Cash Balance 3,871,172 3,491,866 3,685,003 4,906,349 6,049,957 6,049,957 6,049,957 6,049,957 6,049,957 Ending Cash Balance 3,491,866 3,685,003 4,906,349 6,049,957 5,418,767 2,619,720 5,940,604 6,194,333 6,084,980 Encumbrance for Tower & Radio projects approved by the County Council & Commissioners (1)(3,600,000) Adjusted Balance 2,484,980 Ending Cash Balance (percentage of expend.)40.80%41.18%53.24%65.04%54.86%19.38%79.14%24.72% 5 Saint Joseph County PSAP Budget vs. Actual October 31, 2021 2021 YTD YTD Account Fund Amended Actual Actual % Number Number Description Budget 10/31/2021 Balance of Budget Revenue 2709 1222 State 911 Revenue ($145,449/month + $426,479)2,171,867 1,454,490 717,377 66.97% 2711 4930 Saint Joseph County ($296,282 per month)3,555,382 2,666,536 888,846 75.00% 2711 4930 City of South Bend ($211,994 per month)2,543,931 2,119,943 423,989 83.33% 2711 4930 City of Mishawaka ($108,521 per month)1,302,256 1,085,213 217,043 83.33% 2715 4930 AT&T Telephone Reimbursement 442,654 0 442,654 0.00% 2711 4930 Other Reimbursement 141 141 0 0.00% 0000 4930 Other 287 287 0 0.00% 5206 4930 Transfer of Funds 0 0 0 0.00% 6405 1222 Payroll Withholding 0 0 0 0.00% 6101 1222 Bank Account Interest 7,661 7,661 0 100.00% 6101 4930 Bank Account Interest 8,943 8,943 0 100.00% 8400 1222 Investment Interest 25,222 25,222 0 100.00% 8400 4930 Investment Interest 28,799 28,799 0 100.00% Total Revenue 10,087,143 7,397,235 2,689,907 73.33% Expenditures 11032 1222 Executive Director 92,700 78,438 14,262 84.62% 11312 1222 IT Manager 72,100 61,008 11,092 84.62% 11973 1222 Quality Assurance Manager 60,000 46,757 13,243 77.93% 11409 1222 Training Officer 0 0 0 0.00% 11410 1222 Communications Supervisor 169,500 135,995 33,505 80.23% 11411 4930 Telecommunicator III 1,433,845 862,312 571,533 60.14% 11412 4930 Telecommunicator II 673,200 562,843 110,357 83.61% 11413 4930 Telecommunicator I 670,000 431,545 238,455 64.41% 11414 1222 Shift Differential 0 0 0 0.00% 11415 1222 On-Call Employee 35,000 20,582 14,418 58.81% 11415 4930 On-Call Employee 0 0 0 0.00% 11416 4930 Telecommunicator IV 290,460 298,050 (7,590)102.61% 11417 1222 Training Manager 60,000 26,191 33,809 43.65% 11452 1222 Administrative Manager 47,277 40,004 7,273 84.62% 11458 1222 Operations Manager 144,200 122,016 22,184 84.62% 11509 1222 Public Information Officer 42,024 35,559 6,465 84.62% 11571 4930 Overtime & Other 477,000 785,027 (308,027)164.58% 11578 1222 Education Overtime 0 0 0 0.00% 11979 1222 CAD/Radio Specialist 60,000 50,769 9,231 84.62% 14711 4930 Longevity Pay 22,150 12,390 9,760 55.94% 14712 4930 QA Pay 10,000 11,482 (1,482)114.82% 14713 4930 CTO Pay 72,000 108,635 (36,635)150.88% 14714 4930 Holiday Pay 75,000 958 74,042 1.28% 14715 4930 Shift Differential 22,000 64,389 (42,389)292.68% 14716 4930 Foreign Language Pay 3,600 4,051 (451)112.52% 14717 4930 Certification Pay 7,600 1,100 6,500 14.47% 14718 4930 Hazard Pay 0 0 0 0.00% 16801 4930 Incentive Pay 160,000 81,354 78,646 0.00% 14800 1222 FICA 357,785 285,176 72,609 79.71% 14800 4930 FICA 0 0 0 0.00% 14810 1222 PERF 523,816 428,916 94,900 81.88% 14810 4930 PERF 0 0 0 0.00% 14840 1222 Group Health Insurance 1,401,300 1,050,975 350,325 75.00% 14840 4930 Group Health Insurance 0 0 0 0.00% Total Personnel Costs 6,982,557 5,606,521 1,376,036 80.29% 21030 4930 Office Supplies 10,134 10,498 (364)103.59% 22010 4930 Gas Oil & Lubricants 8,000 2,723 5,277 34.03% 23460 4930 Other Materials 12,108 1,769 10,339 14.61% 31010 4930 Legal Services 70,000 67,574 2,426 96.53% 31070 4930 Financial Consulting 30,000 31,952 (1,952)106.51% 32010 4930 Mileage Allowance 1,000 301 699 30.14% 32050 4930 Instruction & Training 69,212 61,899 7,313 89.43% 32055 4930 Public Eduation 5,000 625 4,375 12.50% 32071 4930 Technology - Maint. & Support 572,978 510,834 62,144 89.15% 32200 4930 Telephone 97,000 89,787 7,213 92.56% 32350 4930 Postage 232 60 172 26.01% 33021 4930 Help Wanted Advertising 60,000 33,515 26,485 55.86% 34030 4930 Liabiity Insurance Coverage 105,000 105,000 0 100.00% 35015 4930 Utilities 99,000 80,259 18,741 81.07% 36015 4930 Contractual Services 71,600 42,403 29,197 59.22% 36018 4930 Tower Maintenance 27,000 6,840 20,160 25.33% 36300 4930 Repair - Office Equipment 5,706 4,380 1,326 76.77% 36100 4930 Repair - Autos & Trucks 2,000 0 2,000 0.00% 38010 4930 Paying Agent Fees 0 0 0 100.00% 38012 4930 Capital Lease - Interest 154,635 115,350 39,285 74.60% 38013 4930 Capital Lease - Principal 1,506,572 728,528 778,044 48.36% 43010 4930 Tower Improvements (New Project)2,200,000 0 2,200,000 0.00% 44310 4930 Radio Equipment (New Project)1,400,000 0 1,400,000 0.00% 45523 4930 ERP Software Allocation 0 0 0 0.00% 36011 4930 Building Maintenance 27,646 5,768 21,878 20.86% Total Expenditures 13,517,380 7,506,588 6,010,792 55.53% Net (3,430,237)(109,353)(3,320,885) 6 Saint Joseph County PSAP Comparative YTD Expenditures October 31, 2021 YTD YTD Account Fund Actual Actual Increase/Percent Number Number Description 10/31/2021 10/31/2020 (Decrease)Change 11032 1222 Executive Director 78,438 78,438 0 0.00% 11312 1222 IT Manager 61,008 61,008 0 0.00% 11314 1222 IT Technician 0 0 0 0.00% 11409 1222 Training Officer 0 0 0 0.00% 11409 4930 Training Officer 0 0 0 0.00% 11973 1222 Quality Assurance Manager 46,757 35,654 11,103 31.14% 11410 1222 Communications Supervisor 135,995 136,842 (847)-0.62% 11411 4930 Telecommunicator III 862,312 1,124,034 (261,722)-23.28% 11412 4930 Telecommunicator II 562,843 609,023 (46,180)0.00% 11413 4930 Telecommunicator I 431,545 202,888 228,657 112.70% 11414 1222 Acting Comm Supervisor Pay Dif 0 0 0 0.00% 11414 4930 Acting Comm Supervisor Pay Dif 0 0 0 0.00% 11415 1222 On-Call Employee 20,582 5,929 14,653 247.13% 11415 4930 On-Call Employee 0 22,327 (22,327)-100.00% 11416 4930 Telecommunicator IV 298,050 279,594 18,457 6.60% 11417 1222 Training Manager 26,191 0 26,191 0.00% 11452 1222 Administrative Manager 40,004 40,004 0 0.00% 11458 1222 Operations Manager 122,016 122,016 0 0.00% 11509 1222 Public Information Officer 35,559 35,559 0 0.00% 11571 4930 Overtime 785,027 672,305 112,722 16.77% 11578 1222 Education Overtime 0 0 0 0.00% 11979 1222 CAD/Radio Specialist 50,769 46,154 4,615 100.00% 14711 4930 Longevity Pay 12,390 14,317 (1,926)-13.46% 14712 4930 QA Pay 11,482 10,930 552 5.05% 14713 4930 CTO Pay 108,635 48,567 60,068 123.68% 14714 4930 Holiday Pay 958 39,143 (38,185)-97.55% 14715 4930 Shift Differential 64,389 17,108 47,280 276.36% 14716 4930 Foreign Language Pay 4,051 1,945 2,106 108.27% 14717 4930 Certification Pay 1,100 0 1,100 0.00% 14718 4930 Hazard Pay 0 0 0 100.00% 16801 4930 Incentive Pay 81,354 0 81,354 100.00% 14800 1222 FICA 285,176 266,684 18,492 6.93% 14800 4930 FICA 0 0 0 0.00% 14810 1222 PERF 428,916 405,716 23,200 5.72% 14810 4930 PERF 0 0 0 0.00% 14840 1222 Group Health Insurance 1,050,975 1,371,330 (320,355)-23.36% 14840 4930 Group Health Insurance 0 0 0 100.00% Total Personnel Costs 5,606,521 5,647,514 (40,993)-0.73% 21030 4930 Office Supplies 10,498 9,206 1,292 14.03% 22010 4930 Gas Oil & Lubricants 2,723 3,887 (1,164)-29.95% 23460 4930 Other Materials 1,769 2,321 (552)-23.78% 31010 4930 Legal Services 67,574 9,487 58,087 612.30% 31070 4930 Financial Consulting 31,952 11,905 20,047 168.39% 32010 4930 Mileage Allowance 301 531 (230)-43.27% 32050 4930 Instruction & Training 61,899 47,095 14,804 31.43% 32055 4930 Public Education 625 0 625 0.00% 32071 4930 Technology - Maint. & Support 510,834 478,745 32,089 6.70% 32200 4930 Telephone 89,787 74,488 15,300 20.54% 32350 4930 Postage 60 51 9 18.33% 33021 4930 Help Wanted Advertising 33,515 0 33,515 0.00% 34030 4930 Liabiity Insurance Coverage 105,000 105,000 0 0.00% 35015 4930 Utilities 80,259 81,243 (984)-1.21% 36015 4930 Contractual Services 42,403 33,476 8,927 26.67% 36018 4930 Tower Maintenance 6,840 2,150 4,691 0.00% 36300 4930 Repair - Office Equipment 4,380 0 4,380 100.00% 36100 1222 Repair - Office Equipment 0 0 0 0.00% 36100 4930 Repair - Autos & Trucks 0 35 (35)0.00% 38010 4930 Paying Agent Fees 0 550 (550)100.00% 38012 4930 Capital Lease - Interest 115,350 101,868 13,482 13.24% 38013 4930 Capital Lease - Principal 728,528 749,821 (21,292)-2.84% 43010 4930 Tower Improvements (New Project - $2.2M)0 0 0 0.00% 44310 4930 Radio Equipment (New Project - $1.4M)0 0 0 0.00% 45523 4930 ERP Software Allocation 0 16,750 (16,750)100.00% 36011 4930 Building Maintenance 5,768 18,873 (13,105)-69.44% Total Expenditures 7,506,588 7,394,994 111,594 1.51% 7 PSAP Cash Balances October 31, 2021 Fund Fund Cash Balance Cash Balance Cash Balance Cash Balance Cash Balance Number Name 12/31/2017 12/31/2018 12/31/2019 12/31/2020 10/31/2021 1222 Statewide 911 2,629,692.52 2,523,168.25 3,355,880.07 2,946,544.84 2,051,532.23 4930 Dispatch Operating 862,172.90 1,161,834.49 1,550,468.19 3,103,412.97 3,889,072.20 4931 Dispatch Capital 399,984.00 599,988.00 777,236.92 482,972.74 147,435.30 4932 Dispatch Bond Debt Service 0.00 0.00 450.66 1,957.37 23,930.13 4933 CEDIT/PSAP Construction 10,622.60 0.00 0.00 0.00 0.00 9155 NIPSCO PSAP Training Grant 0.00 0.00 3,680.00 0.00 0.00 0018 2015 U.S. Bank Lease Escrow 25,573.44 8,588.53 8,610.23 0.00 0.00 0019 2017 U.S. Bank Lease Escrow 1,716,684.70 261,998.48 95,416.64 0.00 0.00 Total 5,644,730.16 4,555,577.75 5,791,742.71 6,534,887.92 6,111,969.86 PSAP Debt & Lease Amounts October 31, 2021 Original 10/31/2021 2021 Principal Principal Debt Service Name Balance Balance Payments (1)2014 CEDIT Bond (Fund 4932) Schedule #5 9,155,000.00 6,230,000.00 686,431.26 (2)2015 U.S. Bank Lease (Fund 4930) Schedule #11 12,000,000.00 4,479,324.37 1,337,126.82 (3)2017 U.S. Bank Lease (Fund 4930) Schedule #12 2,500,000.00 1,697,332.94 284,252.88 (4)2019 Motorola Lease (Fund 4931) Sched. #25 2,976,131.00 2,205,682.72 494,204.14 (5)2019 PSAP Veh Lease Jordan Ford Sched (Fund 4930). #27 26,140.00 14,088.07 6,139.68 (6)2019 PSAP HP Computer Lease Sched. (Fund 4930) #28 131,612.05 71,681.14 33,687.00 Total 26,788,883.05 14,698,109.24 2,841,841.78 (1) 40 semi-annual payments from 6/30/15 to 12/31/34 (2) 20 semi-annual payments from 6/30/15 to 12/31/24 (3) 20 semi-annual payments from 5/16/18 to 11/16/27 (4) 7 annual payments from 2/1/20 to 2/1/26 (5) 60 monthly payments from 5/30/19 to 4/30/24 (6) 49 monthly payments from 8/15/19 to 8/15/24 8 Fund Name 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 12/31/2020 Est. 12/31/2021 Statewide 911 Fund 3,861,471.64 3,715,804.94 2,629,692.52 2,523,168.25 3,355,880.07 2,946,544.84 2,132,165.00 Dispatch Operating 165,544.43 155,367.32 862,172.90 1,161,834.49 1,550,468.19 3,103,412.97 3,952,816.00 Dispatch Capital 199,980.00 199,980.00 399,984.00 599,988.00 777,236.92 482,972.74 188,768.00 Dispatch Debt Service 228,103.12 27,853.22 0.00 0.00 450.66 1,407.37 23,930.00 NIPSCO PSAP Training Grant 0.00 0.00 0.00 0.00 3,680.00 0.00 0.00 Dispatch Construction 896,393.23 123,267.30 10,622.60 0.00 0.00 0.00 0.00 Total Cash Reserves 5,351,492.42 4,222,272.78 3,902,472.02 4,284,990.74 5,687,715.84 6,534,337.92 6,297,679.00 Excludes US Bank Lease Trustee Capital Funds Change 20120- 2021 (236,658.92) Important Note In October, 2021, the County Council and Commissioners approved an additional appropriation in the amount of $2.2 million dollares for a new tower and $1.4 million dollars for radios. These projects are not included in the above cash flow reserves estimate as money is not expected to be spent during 2022. $0.00 $1,000,000.00 $2,000,000.00 $3,000,000.00 $4,000,000.00 $5,000,000.00 $6,000,000.00 $7,000,000.00 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 12/31/2020 Est. 12/31/2021 PSAP Cash Reserves 2015 -2021 Statewide 911 Fund Dispatch Operating Dispatch Capital Dispatch Debt Service Dispatch Construction Total Cash Reserves NIPSCO PSAP Training Grant 9 Assessments - 2017 to 2022 (assessments eliminated for 2022) Annual Operating Assessment (Fund 4930)2017 Percent 2018 Percent 2019 Percent 2020 Percent 2021 Percent 2022 Percent Saint Joseph County 2,774,983 48.13%3,415,385 49.25%3,892,151 48.32%3,852,672 48.38%3,555,382 48.04%0 0.00% City of South Bend 1,997,626 34.64%2,338,773 33.73%2,749,751 34.13%2,698,781 33.89%2,543,931 34.37%0 0.00% City of Mishawaka 993,391 17.23%1,180,006 17.02%1,413,666 17.55%1,411,903 17.73%1,302,256 17.59%0 0.00% Total 5,766,000 100.00%6,934,164 100.00%8,055,568 100.00%7,963,356 100.00%7,401,569 100.00%0 0.00% Annual Captial Assessment (Fund 4931)2017 2018 2019 2020 2021 2022 Saint Joseph County 109,580 54.79%109,571 54.79%96,640 48.32%96,760 48.38%96,000 48.00%0 0.00% City of South Bend 56,500 28.25%56,506 28.25%68,260 34.13%67,780 33.89%69,000 34.50%0 0.00% City of Mishawaka 33,920 16.96%33,923 16.96%35,100 17.55%35,460 17.73%35,000 17.50%0 0.00% Total 200,000 100.00%200,000 100.00%200,000 100.00%200,000 100.00%200,000 100.00%0 0.00% Annual Debt Service Assessment (Fund 4932) (1)2017 2018 2019 2020 2021 2022 Saint Joseph County 369,688 53.63%367,570 53.63%368,079 53.63%368,481 53.63%368,133 53.63%0 0.00% City of South Bend 200,113 29.03%198,966 29.03%199,242 29.03%199,460 29.03%199,271 29.03%0 0.00% City of Mishawaka 119,530 17.34%118,845 17.34%119,010 17.34%119,140 17.34%119,027 17.34%0 0.00% Total 689,331 100.00%685,381 100.00%686,331 100.00%687,081 100.00%686,431 100.00%0 0.00% Total AnnualAssessments 2017 2018 2019 2020 2021 2022 Saint Joseph County 3,254,251 48.90%3,892,526 49.78%4,356,870 48.72%4,317,913 48.79%4,019,515 48.50%0 0.00% City of South Bend 2,254,239 33.87%2,594,245 33.18%3,017,253 33.74%2,966,021 33.51%2,812,202 33.93%0 0.00% City of Mishawaka 1,146,841 17.23%1,332,774 17.04%1,567,776 17.53%1,566,503 17.70%1,456,283 17.57%0 0.00% Total 6,655,331 100.00%7,819,545 100.00%8,941,899 100.00%8,850,437 100.00%8,288,000 100.00%0 0.00% (1) Deduction from LIT Economic Development Revenue. Allocation per Interlocal agreement - SJC 53.63%, South Bend 29.03% and Mishawaka 17.34%. An adjustment for prior withholding is being made. (2) Dedicated PSAP Local Income Tax starting in January 2022 replaces assessments. Assessments will only be needed if the PSAP funds are in a deficit position. 10 ] Revenue Expenditures Net 2015 Actual 8,422,585 8,372,723 49,862 2016 Actual 7,306,344 7,662,438 (356,094) 2017 Actual 9,041,871 9,249,027 (207,156) 2018 Actual 10,028,406 9,635,268 393,138 2019 Actual 11,327,811 9,925,085 1,402,726 2020 Actual 11,334,968 10,487,796 847,172 2021 Estimated 10,997,097 11,233,755 (236,658) Note: 2021 estimated expenditures do not include $3.6 millions dollars budgeted for a tower and radios projects. It is not expected that this money will be spent during 2021. 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 2015 Actual 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Estimated PSAP Revenue & Expenditures 2015 -2021 Revenue Expenditures 11 Fund 1222 Fund 4930 Fund 4931 Fund 4932 Fund 9155 Year Statewide 911 Dispatch Operating Dispatch Capital Dispatch Bond NIPSCO Grant Total 2015 Actual 2,891,719 4,416,151 199,980 914,735 0 8,422,585 2016 Actual 2,138,106 4,679,907 0 488,331 0 7,306,344 2017 Actual 2,257,189 5,922,700 200,004 661,978 0 9,041,871 2018 Actual 2,193,672 6,948,849 200,004 685,881 0 10,028,406 2019 Actual 2,342,624 8,094,175 200,000 687,332 3,680 11,327,811 2020 Actual 2,435,811 8,010,129 199,940 689,088 0 11,334,968 2021 Estimated 2,204,750 7,882,393 200,000 709,954 0 10,997,097 Revenue includes interest earned on investments during 2018 and 2019 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 2015 Actual 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Estimated PSAP Revenue -2015 to 2021 12 Fund 1222 Fund 4930 Fund 4931 Fund 4932 Fund 9155 Year Statewide 911 Dispatch Operating Dispatch Capital Dispatch Bond NIPSCO Grant Total 2015 Actual 3,435,485 4,250,607 0 686,631 0 8,372,723 2016 Actual 2,283,773 4,690,084 0 688,581 0 7,662,438 2017 Actual 3,343,301 5,215,895 0 689,831 0 9,249,027 2018 Actual 2,300,198 6,649,189 0 685,881 0 9,635,268 2019 Actual 1,509,912 7,705,541 22,751 686,881 0 9,925,085 2020 Actual 2,845,147 6,457,184 494,204 687,581 3,680 10,487,796 2021 Estimated 3,019,129 7,032,990 494,205 687,431 0 11,233,755 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 2015 Actual 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Estimated PSAP Expenditures -2015 to 2021 13 Saint Joseph County, Indiana Budgeted Personnel Counts - PSAP 2015 - 2022 2015 2016 2017 2018 2019 2020 2021 2022 Adopted Adopted Adopted Adopted Adopted Adopted Amended Adopted Position Name Budget Budget Budget Budget Budget Budget Budget Budget Administrative/Operations Executive Director 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Administrative Manager 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 CAD/Radio Specialist 0.00 0.00 0.00 0.00 0.00 1.00 1.00 1.00 IT Manager 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 GIS Technician 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 IT Technician 1.00 1.00 1.00 0.00 0.00 0.00 0.00 1.00 Public Information Officer 0.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Operations Manager 1.00 1.00 1.00 2.00 2.00 2.00 2.00 2.00 Quality Assurance Manager 0.00 0.00 0.00 0.00 1.00 1.00 1.00 1.00 Quality Assurance Assistant 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 Training Manager 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 Training Officer/Manager 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Subtotal 6.00 7.00 7.00 6.00 7.00 8.00 8.00 12.00 Communicicaions/Telecommunicators Communications Supervisor 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Telecommunicator I 9.00 19.00 19.00 0.00 0.00 0.00 0.00 12.00 Telecommunicator II 30.00 29.00 29.00 10.00 10.00 10.00 10.00 10.00 Telecommunicator III 18.00 12.00 16.00 50.00 53.00 53.00 53.00 56.00 Telecommunicator IV 0.00 0.00 0.00 7.00 7.00 7.00 7.00 6.00 Subtotal 60.00 63.00 67.00 70.00 73.00 73.00 73.00 87.00 Total Staffing 66.00 70.00 74.00 76.00 80.00 81.00 81.00 99.00 Prior to consolidation, in 2014, 15 dispatchers were paid from the County Police budget (0005) in the General Fund. Other dispatchers were paid directly by other governmental agencies. No new positions requested in the 2021 budget 14 Type Amount Percent State 911 Revenue 2,171,867 21.53% Saint Joseph County 3,555,382 35.25% City of South Bend 2,543,931 25.22% City of Mishawaka 1,302,256 12.91% AT&T Reimbursements 442,654 4.39% Interest Earnings 70,625 0.70% Other Refunds 427 0.00% Uses of Fund Balance 0 0.00% Total Revenue 10,087,142 100.00% $2,171,867 $3,555,382 $2,543,931 $1,302,256 $442,654 $70,625 $427 $0 2021 Estimated PSAP Operating Revenue State 911 Revenue Saint Joseph County City of South Bend City of Mishawaka AT&T Reimbursements Interest Earnings Other Refunds Uses of Fund Balance 15 Type Amount Percent Telecommunicator Salaries 2,602,611 25.80% Adm/Operations Salaries 655,646 6.50% Overtime & Special Pays 1,442,624 14.30% Incentive Pay 82,086 0.81% Fringe Benefits 2,282,901 22.63%70.05% Salaries & Benefits Debt Service - Leases 1,661,207 16.47% Technology Maintenance 710,834 7.05% Telephone 110,787 1.10% Utilities 98,994 0.98% Contractual Services 45,603 0.45% Legal & Financial Services 114,226 1.13% Instruction and Training 64,399 0.64% Help Wanted Ads 33,515 0.33% Liability Insurance 105,000 1.04% Other Expenditures 41,686 0.41% Source of Fund Balance 35,023 0.35%29.95%Non-Personnel Total Expenditures 10,087,142 100.00% Other Salaries Executive Director, IT Manager, Communications Supervisors, Quality Assurance Manager, Administrative Manager, Operations Managers, Public Information Officer, Qualitative Assurance Manager, Training Manager and CAD/Radio Specialist. Fringe Benefits Health insurance, FICA taxes, and PERF retirement. Technology Leases US Bank leases, Vehicle lease, HP computer refresh lease $2,602,611 $655,646 $1,442,624 $82,086 $2,282,901 $1,661,207 $710,834 $110,787 $98,994 $45,603 $114,226 $64,399 $33,515 $105,000 $41,686 $35,023 2021 Estimated PSAP Operating Expenditures Telecommunicator Salaries Adm/Operations Salaries Overtime & Special Pays Incentive Pay Fringe Benefits Debt Service - Leases Technology Maintenance Telephone Utilities Contractual Services Legal & Financial Services Instruction and Training Help Wanted Ads Liability Insurance Other Expenditures Source of Fund Balance 16