Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-06 - Monthly Financial Report
Period Ending: Issued By: City of South Bend Financial Report Page Contents 2 Narrative 3 - 6 Revenue by Type 7 - 10 Revenue by Fund 11 Property Tax Revenue 12 - 15 Expenditures by Fund and Department 16 - 17 Outstanding Debt 18 - 19 Debt Payments Year-to-Date 20 - 21 Full-Time Staffing Summary by Fund 22 Full-Time Staffing Summary by Activity 23 Part-Time Staffing Summary by Fund 24 Paid Temporary, Seasonal, and Intern Staffing Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg Common Council Department Heads Fiscal Officers June 30, 2018 Controller Monthly Financial Report 2 of 24 June 30, 2018 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). Revenue by Type For discussion on property taxes, see section listed below. The overall percentage of budgeted revenues that have been received by the city is 55%, compared to 50% in June 2017. Please note a few revenue types have reached well above their standard 50% of revenue at this time. This is due in part to monies received in January that were related to 2017 services. These include revenue type (335) Liquor Excise tax, type (342) EMS for Medicaid reimbursement, type (360) miscellaneous for P-Card Commission rebate, type (350) Job Target Penalty Fee, and type (380) INDOT SR 933 Transfer. Revenue by Fund As of June 2018, the general fund has reached 54% of its budgeted revenue, compared to 52% last year. As mentioned above, some funds have surpassed their normal 50% of revenue at this time due to monies received in January that are related to 2017 services. Fund 287 (EMS Capital) is at 275% of its budgeted revenue as result of 2017 Medicaid reimbursement received in January in the amount of $1,078,550. Fund 278 (Police Take Home Vehicle) is at 188% of its budgeted revenue due to interest earnings. Fund 294 (Police Academy) is at 97% of its budgeted revenue. This is tuition revenue related to the advancement of police officers. Fund 629 (Waterworks Debt Reserve) is at 98% of its budgeted revenue. Money was transferred in from fund 620 to cover two months of operating expenditures plus additional money for anticipated roll over of encumbrances. Fund 217 (Gift, Donation, Bequest) has exceeded its budgeted revenue by $6,720 or 15% over budgeted revenue amount. In April, Animal Control received $30,568 in private donations. Also this month, funds 249, 408, and 404 received a one-time special distribution from the State of Indiana as a result of having a positive balance in the county’s trust account that exceeded 15% of the balance. Property Taxes Property taxes are received in June and December. For 2018, the projected levy collection rate is 95% or $79.5 million. Civil City Funds are expected to receive ~$55 million or 66% and TIF funds ~$28.7 million or 34%. This year civil city funds are budgeted ~$4.3 million higher than last year and TIF funds are $285,909 lower than last year. Property taxes collected this month totaled ~$44.6 million. Civil city funds received ~$28.5 million or 51% and TIF funds received ~ $16.1 million or 56%. Expenditures As of June 30, 2018, the City has spent 33% of budgeted expenditures, compared to 38% last year. The General Fund has spent 48% of its 2018 budgeted expenditures, compared to 46% in 2017. The following funds have reached 50% or more of its budgeted expenditures as a result of bond payments. Fund 313 (Hall of Fame), final payment was made this month. Fund 377 (PSDA), payment made for the Coveleski Stadium bond in the amount of $335,000. Fund 406 (Cumulative Capital Development), payment for vehicle equipment, fund 407 (Cumulative Capital Improvement), payment for the Century Center and fund 661 (2012 Sewer Bond) for payments related to the East Bank Sewer. Debt This month, various debt service payments were made in the amount of ~ $127,000. Payments are related to IT equipment leases, St. Joseph County PSAP, and Indiana Finance Authority. Headcount The Full Time Headcount as of June 2018 was 1,100 vs. a budgeted amount of 1,130. Overall, there are a total of 37 open positions, with several departments having more positions than budgeted due to employees overlapping as they leave. The following departments have vacant positions: General Government (6), Public Safety (7), Public Works (22) IT/Innovation/ 311 Call Center (1), Unsafe Building (1). If you have any questions regarding this report, please contact the Department of Administration and Finance by calling 311. City of South BendRevenue by Type ReportFund%Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetTaxesProperty Tax311 Property Tax Civil City various - - - - - 28,536,938 - - - - - - 28,536,938 49,334,375 58%311 Property Tax TIF Districts various - - - - - 16,093,585 - - - - - - 16,093,585 27,878,133 58%Sub Total- - - - - 44,630,523 - - - - - - 44,630,523 77,212,508 58%Income Tax315 Econ Development Income Tax 408 893,413 893,413 893,413 - 2,806,609 1,038,161 - - - - - - 6,525,010 10,720,965 61%316 Local Option Income Tax - PS 249 635,795 635,795 635,795 - 2,023,604 741,577 - - - - - - 4,672,566 7,629,539 61%316 County Option Income Tax 404 908,858 908,858 908,858 - 3,099,943 1,060,071 - - - - - - 6,886,587 10,906,293 63%Sub Total2,438,066 2,438,066 2,438,066 - 7,930,157 2,839,809 - - - - - - 18,084,163 29,256,797 62%St Joseph County (Remitted by)312 Auto Excise Tax various - - - - - 1,817,877 - - - - - - 1,817,877 3,184,500 57%312 Commercial Vehicle Tax various - - - - - 390,114 - - - - - - 390,114 842,600 46%317 Hotel Motel Tax Cum Cap Imprv 407 221,437 (221,437) - - - - - - - - - - - - NA 317 Hotel Motel Tax Century Center 670/672 106,250 327,687 106,250 - - - - - - - - - 540,187 1,496,437 36%317 Hotel Motel Tax Century Center 324 - - - 196,500 - - - - - - - - 196,500 395,000 50%Sub Total327,687 106,250 106,250 196,500 - 2,207,991 - - - - - - 2,944,678 5,918,537 50%Total Taxes 2,765,753 2,544,316 2,544,316 196,500 7,930,157 49,678,323 - - - - - - 65,659,365 112,387,842 58%Intergovernmental RevenueState Shared Revenue335 Liquor Excise tax 101 50,193 - - - - 33,066 - - - - - - 83,259 75,000 111%335 Liquor Gallonage Tax 101 58,696 - - 48,430 - - - - - - - - 107,126 210,000 51%335 Cigarette Tax 101/407 - - - - - 142,182 - - - - - - 142,182 320,500 44%335 Gaming Proceeds 101 - - - - - - - - - - - - - 599,000 0%335 Gasoline Tax 202/251 561,967 526,500 576,286 964,559 349,908 547,407 - - - - - - 3,526,627 6,740,000 52%335 Wheel Tax 202 132,033 88,461 183,060 197,848 196,892 181,671 - - - - - - 979,965 2,050,000 48%335 Prof Sports Development Tax 377 - - - - - - - - - - - - - 600,000 0%335 State Pension Subsidy 701/702 - - - - - 5,352,963 - - - - - - 5,352,963 11,205,638 48%Sub Total802,888 614,961 759,346 1,210,837 546,801 6,257,290 - - - - - - 10,192,122 21,800,138 47%Grants331 Federal Grants various 130,898 321,635 296,672 301,688 834,533 496,619 - - - - - - 2,382,045 9,102,155 26%334 State Grants various 2,375 - - 19,314 - 3,674 - - - - - - 25,363 367,375 7%Sub Total133,273 321,635 296,672 321,002 834,533 500,293 - - - - - - 2,407,408 9,469,530 25%Other336 Federal Drug 299 - 6,201 - - - - - - - - - - 6,201 50,000 12%337 Regional Cities Grant 201 195,060 - - 263,648 - - - - - - - - 458,708 2,000,000 23%337 State Drug 216 - 3,865 - - 3,524 - - - - - - - 7,389 30,000 25%338 Payment in Lieu of Tax various 527,707 527,707 527,707 527,707 527,707 527,707 - - - - - - 3,166,242 6,332,487 50%339 Contractual Service 211 51,257 8,748 11,248 10,477 13,162 7,914 - - - - - - 102,804 333,500 31%Sub Total774,024 546,520 538,955 801,832 544,393 535,621 - - - - - - 3,741,344 8,745,987 43%Total Intergovernmental Revenue 1,710,185 1,483,115 1,594,973 2,333,671 1,925,726 7,293,204 - - - - - - 16,340,874 40,015,655 41%Charges for Services - Internal340 Liability Insurance 226 177,187 171,512 168,832 168,832 176,872 168,832 - - - - - - 1,032,067 2,058,123 50%349 Central Services Mark-up 222 66,267 58,491 63,145 60,020 53,474 60,635 - - - - - - 362,032 793,711 46%Total Charges for Services - Internal 243,454 230,003 231,977 228,852 230,346 229,467 - - - - - - 1,394,099 2,851,834 49%Charges for Services - ExternalLicenses & Permits320 Inspections Central Service 222 - 10 - 310 70 780 - - - - - - 1,170 1,150 102%321 Business License 101/222 32,444 28,244 15,975 14,076 9,916 3,248 - - - - - - 103,903 121,910 85%322 Vacant Building Registration 219 - - - 300 - 600 - - - - - - 900 - NA 322 Building Fees 600 73,425 93,065 110,408 188,609 169,683 129,950 - - - - - - 765,141 1,387,552 55%322 Building Plan Review - Fire Safety 288 1,145 1,977 1,791 1,713 2,023 1,706 - - - - - - 10,355 24,000 43%322 General Government Fees 101 6,255 24,555 17,695 3,360 14,075 7,623 - - - - - - 73,563 132,000 56%Sub Total113,269 147,851 145,869 208,369 195,767 143,907 - - - - - - 955,031 1,666,612 57%Period Ending: June 30, 2018Monthly Financial Report3 of 24 City of South BendRevenue by Type ReportFund%Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetPeriod Ending: June 30, 2018Charges for Services - ExternalPublic Safety340 Public Safety various - - - - - - - - - - - - - 500 0%340 ND EMS Service 288 - 750 - 2,171 50,015 19,962 - - - - - - 72,898 150,000 49%342 Public Safety various 18,988 18,890 14,579 14,484 10,937 8,903 - - - - - - 86,781 170,000 51%342 EMS - Capital Fund 287 1,078,551 - - - - 538,032 - - - - - - 1,616,582 575,000 281%342 EMS - Operating Fund 288 261,623 194,907 457,456 234,783 374,625 225,314 - - - - - - 1,748,708 2,700,000 65%342 EMS - Neo Natal / Transport 288 52,088 44,463 46,959 13,342 70,564 44,895 - - - - - - 272,311 509,400 53%342 EMS - County Fees 288 - - 452,241 150,747 150,747 150,747 - - - - - - 904,482 1,766,484 51%Sub Total1,411,250 259,009 971,235 415,527 656,888 987,854 - - - - - - 4,701,763 5,871,384 80%Culture & Recreation347 Parks Maintenance (1101) 201/405 38,216 2,133 8,478 39,438 2,991 48,953 - - - - - - 140,210 983,722 14%347 Golf (1102) 201 - 9,042 114,573 51,363 197,653 178,556 - - - - - - 551,188 1,496,406 37%347 Recreation (1103) 201/203 67,191 54,621 148,259 81,735 76,818 98,426 - - - - - - 527,051 1,438,496 37%347 Graffiiti Removal (1108) 201 - - - - - - - - - - - - - 106,459 0%347 Marketing & Events (1110) 201/203 22,851 16,927 1,595 364 253 1,360 - - - - - - 43,350 184,769 23%347 Lease of Coveleski Stadium 401 - - - - - - - - - - - - - 43,500 0%347 Morris Ticket Surcharges 274/416 2,563 22,020 14,400 55,080 30,120 3,578 - - - - - - 127,761 224,000 57%Sub Total130,822 104,743 287,305 227,980 307,836 330,873 - - - - - - 1,389,559 4,477,352 31%Code Enforcement321 Code and Animal Fees 600 8,225 5,675 8,107 9,025 7,878 8,239 - - - - - - 47,148 67,150 70%322 Code Enforcement Fees 600 - 2,300 600 - - - - - - - - - 2,900 17,500 17%323 Rental Unit Inspection Fees 600 - - - - - - - - - - - - - 30,000 0%344 Code Environmental Clean Up 101/219/600 8,672 10,690 14,270 8,799 15,283 8,189 - - - - - - 65,904 175,000 38%349 Code Demolition Board Up 219/600 20,189 33,441 18,661 1,060 2,062 3,392 - - - - - - 78,805 84,500 93%Sub Total37,087 52,106 41,638 18,883 25,223 19,819 - - - - - - 194,756 374,150 52%Public Works342 Highway & Streets 202 19,724 - - 44,801 - - - - - - - - 64,525 223,365 29%344 Solid Waste 610 412,322 412,616 414,300 413,587 584,570 249,441 - - - - - - 2,486,836 4,992,585 50%346 Solid Waste Misc 610 14,208 14,312 15,082 44,193 63,226 27,677 - - - - - - 178,697 372,106 48%346 Water Works Utility 620 1,000,323 1,038,936 999,511 1,201,084 1,572,280 1,084,601 - - - - - - 6,896,735 15,965,983 43%344 Water Leak Insurance 620 82,210 82,136 82,151 83,498 117,515 55,449 - - - - - - 502,959 1,012,683 50%344 Sewer Repair Insurance 640 52,568 52,969 53,044 52,989 75,735 32,718 - - - - - - 320,023 615,685 52%344 Sewage Waste Water 641 3,062,991 3,147,975 3,146,045 3,587,736 4,021,785 2,386,463 - - - - - - 19,352,994 37,333,610 52%346 Sewer System Development Fees 622 - - - - 11,543 10,260 - - - - - - 21,803 195,000 11%344 Sewer System Development Fees 642 - - - - 30,075 24,742 - - - - - - 54,817 688,000 8%346 Project ReLeaf 655 37,195 37,230 37,137 37,103 51,847 22,684 - - - - - - 223,196 439,680 51%Sub Total4,681,543 4,786,174 4,747,270 5,464,990 6,528,574 3,894,034 - - - - - - 30,102,585 61,838,697 49%Parking Garages349 Parking Garage Fees 601 116,271 79,180 114,263 110,720 89,676 95,917 - - - - - - 606,026 1,162,700 52%Sub Total116,271 79,180 114,263 110,720 89,676 95,917 - - - - - - 606,026 1,162,700 52%Century Center349 Parking Century Center 670 14,340 12,563 18,826 7,565 5,881 4,240 - - - - - - 63,415 131,723 48%371 Century Center Fees 670 18,397 26,165 14,226 43,812 21,855 21,337 - - - - - - 145,792 416,440 35%372 Century Center Fees 670 11,305 16,861 17,464 17,981 5,696 19,489 - - - - - - 88,796 137,197 65%373 Century Center Fees 670 68,911 118,743 72,239 159,393 167,894 251,802 - - - - - - 838,982 1,836,743 46%374 Century Center Fees 670 10,280 14,302 6,378 29,858 23,385 41,881 - - - - - - 126,085 322,054 39%Sub Total123,233 188,634 129,134 258,609 224,711 338,750 - - - - - - 1,263,070 2,844,157 44%Other341 General Government Various various 449 1,671 4,221 9,121 291 943 - - - - - - 16,696 30,605 55%341 Historic Presrv Comm Approval 211 80 40 220 230 440 320 - - - - - - 1,330 1,000 133%347 Sale of Merchandise-Mayor's Office 101-0101 - - - - - - - - - - - - - 100 0%349 Developer Parking 324 - - 1,060 - - - - - - - - - 1,060 4,320 25%351 Fines & Fees various 24,226 18,656 20,525 19,185 15,216 21,851 - - - - - - 119,659 265,820 45%352 Forfeits various 11,462 7,073 6,948 2,699 10,663 17,638 - - - - - - 56,483 200,000 28%354 Ordinance Violation various 2,515 8,042 16,451 4,024 7,361 6,073 - - - - - - 44,467 108,500 41%Sub Total38,732 35,482 49,425 35,259 33,971 46,826 - - - - - - 239,694 610,345 39%Total Charges for Services - External 6,652,205 5,653,179 6,486,138 6,740,335 8,062,647 5,857,980 - - - - - - 39,452,484 78,845,397 50%Monthly Financial Report4 of 24 City of South BendRevenue by Type ReportFund%Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetPeriod Ending: June 30, 2018Other IncomeMiscellaneous Revenue360 Miscellaneous Revenue various 19,102 109,003 369,027 (328,283) 25,334 7,467 - - - - - - 201,649 648,368 31%360 Insurance Reimbursement various 2,960 - 4,527 2,000 1,113 64,316 - - - - - - 74,917 40,000 187%360 Sale of Scrap Metal various 2,352 1,027 2,825 1,039 53 2,002 - - - - - - 9,297 36,582 25%360 General Government Various 101 12,826 - 160 40 150 353 - - - - - - 13,528 13,000 104%360 Engineering / Curb & Sidewalk 101 - - - - - - - - - - - - - 200 0%360 Motor Veh Highway Curb Prgm 202 - - - - - - - - - - - - - 3,000 0%360 Waste Water 641 - 1,534 3,236 6,091 - 6,126 - - - - - - 16,986 38,475 44%360 Century Center 670 551 98 231 926 250 111 - - - - - - 2,167 6,629 33%360 Morris PAC various 20,063 57,049 206,037 172,565 107,301 157,429 - - - - - - 720,444 1,083,500 66%360 Palais Royale various 48,381 8,222 6,608 16,238 19,617 18,491 - - - - - - 117,558 299,572 39%360 Common Area Maint. Fees 425 3,449 2,237 3,449 2,237 - - - - - - - - 11,372 46,245 25%Sub Total109,685 179,169 596,101 (58,593) 153,817 256,295 - - - - - - 1,236,474 2,215,571 56%Interest Income361 Bank Account Interest various 551,499 330,255 212,014 203,811 205,984 437,616 - - - - - - 1,941,178 1,929,319 101%Sub Total551,499 330,255 212,014 203,811 205,984 437,616 - - - - - - 1,941,178 1,929,319 101%Rental of Property362 Dept of Community Investment 212 1,847 - - - 1,847 - - - - - - - 3,694 7,387 50%362 Palais Royale 101 2,002 2,935 - - - - - - - - - - 4,937 75,000 7%362 Police 101 - 7,201 - - - - - - - - - - 7,201 48,000 15%362 Parks & Recreation 201 1,282 2,797 3,184 4,861 4,913 5,291 - - - - - - 22,329 42,300 53%362 South Bend School Corp Fee 407 - - - - - - - - - - - - - 25,000 0%362 Century Center Property Rental 670 55,092 25,563 60,625 45,995 32,271 31,350 - - - - - - 250,896 431,328 58%362 TIF Property various 4,447 139,564 7,486 4,597 - - - - - - - - 156,094 149,970 104%Sub Total64,670 178,061 71,295 55,453 39,031 36,641 - - - - - - 445,151 778,985 57%Donations367 ND Contribution 101 - - - - - - - - - - - - - 337,500 0%367 Donations various 18,825 209 30,568 100,323 904 2,391 - - - - - - 153,219 217,250 71%Sub Total18,825 209 30,568 100,323 904 2,391 - - - - - - 153,219 554,750 28%Historic Preservation368 Palais Royale 450 3,726 433 525 803 1,837 1,670 - - - - - - 8,993 16,500 55%Sub Total3,726 433 525 803 1,837 1,670 - - - - - - 8,993 16,500 55%3rd Party Revenue350 Job Target Penalty Fee 408 - - 354,660 - - - - - - - - - 354,660 354,660 100%364 Cable TV Franchise Fees 101 - 181,977 - - 177,907 - - - - - - - 359,884 768,000 47%366 AT&T Franchise Fees 101 - - - 45,375 93,687 - - - - - - - 139,062 215,000 65%369 Memorial Hosp Leighton Plaza 408 - - - - - - - - - - - - - 150,000 0%Sub Total- 181,977 354,660 45,375 271,594 - - - - - - - 853,606 1,487,660 57%Total Other Income 748,405 870,104 1,265,162 347,171 673,168 734,612 - - - - - - 4,638,623 6,982,785 66%Reimbursements & RefundsInternal Reimbursements380 Central Services Reimbursements 222 235,705 220,302 209,553 235,110 220,977 208,356 - - - - - - 1,330,003 3,138,246 42%380 Energy Office Reimbursements 222 392,685 463,881 442,837 375,343 424,583 370,789 - - - - - - 2,470,119 4,725,000 52%380 Police Take Home Vehicle 278 240 240 240 240 240 240 - - - - - - 1,440 - NA 380 IT / Innovation / 311 Center 279 568,506 568,346 566,166 565,746 568,506 565,746 - - - - - - 3,403,016 6,850,931 50%Sub Total1,197,136 1,252,770 1,218,796 1,176,439 1,214,306 1,145,131 - - - - - - 7,204,578 14,714,177 49%Miscellaneous380 Miscellaneous Reimbursements various 46,138 78,029 58,491 98,181 65,283 168,837 - - - - - - 514,958 1,183,052 44%380 INDOT SR 933 Transfer 251 - - - - 330,000 - - - - - - - 330,000 - NA 380 INDOT SR 933 Transfer 324 - - - 4,100,000 - - - - - - - - 4,100,000 4,100,000 100%380 General Government 101 - - - - - - - - - - - - - 50 0%Sub Total46,138 78,029 58,491 4,201,498 395,283 168,837 - - - - - - 4,948,275 5,283,102 94%Total Reimbursements & Refunds 1,243,274 1,330,799 1,277,286 5,377,937 1,609,589 1,313,968 - - - - - - 12,152,852 19,997,279 61%Monthly Financial Report5 of 24 City of South BendRevenue by Type ReportFund%Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetPeriod Ending: June 30, 2018Other Financing SourcesFixed Assets391 Sale of Fixed Assets various - - - - 2,260 578,602 - - - - - - 580,862 93,000 625%391 TIF (Property Sales / Land) various 92,660 20,001 - 150,000 1,779 - - - - - - - 264,441 270,000 98%391 Vehicle Damage Reimbursement various 4,106 - - - - - - - - - - - 4,106 4,200 98%391 Water Hydrant Reimbursement 620 538 - - - - - - - - - - - 538 20,000 3%Sub Total97,305 20,001 - 150,000 4,039 578,602 - - - - - - 849,947 387,200 220%Miscellaneous392 Administration Fee Allocation 101 452,408 452,408 452,408 452,408 452,408 452,408 - - - - - - 2,714,448 5,454,725 50%392 Inter-Fund Transfers various 229,386 3,177,839 7,267,151 2,426,728 1,475,278 5,362,018 - - - - - - 19,938,400 41,782,472 48%Sub Total681,794 3,630,247 7,719,559 2,879,136 1,927,686 5,814,426 - - - - - - 22,652,848 47,237,197 48%Debt Proceeds393 Bond Proceeds various - - 4,864,008 11,960,245 185,607 6,112,609 - - - - - - 23,122,468 27,724,219 83%Sub Total- - 4,864,008 11,960,245 185,607 6,112,609 - - - - - - 23,122,468 27,724,219 83%Contributions395 Employee Assessment 711/713/714 277,172 255,092 252,456 257,327 254,419 251,088 - - - - - - 1,547,553 3,066,596 50%395 Employer Assessment 711/713/714 1,258,903 1,252,774 1,299,074 1,281,117 1,281,453 1,278,578 - - - - - - 7,651,900 15,530,694 49%Sub Total1,536,074 1,507,866 1,551,530 1,538,444 1,535,872 1,529,666 - - - - - - 9,199,453 18,597,290 49%Refunds396 Central Services Refunds 222 14,009 - 14,505 - 14,745 8,787 - - - - - - 52,046 21,000 248%396 Specific Stop Loss 711 1,844 495 127 - 396 2,959 - - - - - - 5,821 10,000 58%Sub Total15,853 495 14,632 - 15,141 11,746 - - - - - - 57,867 31,000 187%Other399 Bosch Retention Project 210 - - - - - 16,336 - - - - - - 16,336 65,593 25%399 Principal on Loan various 511 80,012 397 617 397 1,564 - - - - - - 83,499 127,914 65%399 Principal Income various - 259,888 - 33,602 - - - - - - - - 293,489 1,086,395 27%511 339,900 397 34,219 397 17,901 - - - - - - 393,324 1,279,902 31%Total Other Financing Sources 2,331,537 5,498,508 14,150,126 16,562,044 3,668,742 14,064,950 - - - - - - 56,275,907 95,256,808 59%Revenue Total 15,694,813 17,610,023 27,549,979 31,786,510 24,100,375 79,172,504 - - - - - - 195,914,204 356,337,600 55%Monthly Financial Report6 of 24 City of South BendRevenue by Fund ReportFund%Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetGeneral FundGeneral Government0000 General Revenues 101 1,229,231 1,191,884 1,011,043 1,113,840 1,282,616 25,232,083 - - - - - - 31,060,698 57,358,601 54%0101 Mayor 101 - - - - - - - - - - - - - 100 0%0201 Clerk 101 - - - - - - - - - - - - - - NA 0301 Common Council 101 - - - - - - - - - - - - - - NA 0401 Administration and Finance 101 12,801 - - - - - - - - - - - 12,801 12,050 106%0501 Legal 101 18,875 - - - 19,253 - - - - - - - 38,128 76,885 50%Sub Total1,260,907 1,191,884 1,011,043 1,113,840 1,301,869 25,232,083 - - - - - - 31,111,626 57,447,636 54%Public Works0602 Engineering 101 7,755 24,555 19,320 21,384 14,340 8,123 - - - - - - 95,477 352,167 27%Sub Total7,755 24,555 19,320 21,384 14,340 8,123 - - - - - - 95,477 352,167 27%Public Safety0801 Police 101 6,578 10,889 19,222 422 6,397 16,454 - - - - - - 59,962 561,000 11%0901 Fire 101 - - - - - 1,705 - - - - - - 1,705 146,114 1%Sub Total6,578 10,889 19,222 422 6,397 18,159 - - - - - - 61,667 707,114 9%Arts & Culture0404 Morris PAC 101 21,240 58,357 204,197 178,801 128,078 157,383 - - - - - - 748,055 1,101,000 68%0405 Palais Royale 101 54,041 12,252 7,122 18,018 21,594 19,948 - - - - - - 132,975 398,972 33%Sub Total75,281 70,609 211,319 196,819 149,672 177,331 - - - - - - 881,030 1,499,972 59%Human Rights1008 Human Rights 101 - - - - 21,734 - - - - - - - 21,734 - NA Sub Total- - - - 21,734 - - - - - - - 21,734 - NA Total General Fund Revenue 1,350,522 1,297,938 1,260,904 1,332,465 1,494,012 25,435,695 - - - - - - 32,171,535 60,006,889 54%Venues, Parks & ArtsParks & Recreation0000 Parks General Revenue 201 11,804 8,621 326,457 3,283 2,667 6,010,397 - - - - - - 6,363,229 10,925,596 58%1100 Administration 201 1,283 2,799 3,187 4,864 4,918 5,301 - - - - - - 22,352 42,400 53%1101 Maintenance 201 38,603 50,870 27,007 81,894 2,106 71,546 - - - - - - 272,027 1,262,622 22%1102 Golf Operations 201 2 9,042 115,093 51,725 199,099 180,187 - - - - - - 555,148 1,501,406 37%1103 Recreation Division 201 210 1,865 1,100 84 1,667 21,635 - - - - - - 26,561 107,060 25%1104 Potawatomi Zoo 201 - - - - - - - - - - - - - - NA 1108 Graffiti Removal 201 - - - - - - - - - - - - - 106,459 0%1110 Marketing and Events 201 - - - - - 1,500 - - - - - - 1,500 70,000 2%1111 Regional Cities Grant 201 195,060 - - 263,648 - - - - - - - - 458,708 2,000,000 23%Recreation Non Reverting 203 91,707 75,029 149,734 82,805 76,141 79,641 - - - - - - 555,059 1,647,205 34%Morris Palais Marketing 273 330 89 3,146 54 127 2,590 - - - - - - 6,336 20,400 31%Morris PAC Self-Promotion 274 1,122 11,010 7,205 27,552 15,086 1,870 - - - - - - 63,845 100,000 64%Zoo Endowment 403 - - - - - - - - - - - - - 400 0%Park Non-Reverting 405 490 299 413 751 1,033 757 - - - - - - 3,744 145,600 3%Sub Total340,612 159,625 633,340 516,661 302,846 6,375,425 - - - - - - 8,328,508 17,929,148 46%Parking Garages0000 Parking Garage Revenue 601 1,922 13 77 - - - - - - - - - 2,011 67,200 3%0460 Main Street 601 31,708 28,624 51,143 40,608 35,626 26,554 - - - - - - 214,262 311,600 69%0462 Leighton Plaza 601 70,649 28,496 41,970 60,682 31,104 53,908 - - - - - - 286,808 571,000 50%0463 Enforcement 601 4,787 5,905 8,543 10,069 7,358 7,029 - - - - - - 43,690 - NA 0464 Wayne Street 601 13,659 22,084 21,012 9,641 22,713 15,259 - - - - - - 104,367 279,300 37%0465 Eddy Street Commons 601 - - - - - - - - - - - - - 500 0%Sub Total122,725 85,121 122,744 120,999 96,801 102,749 - - - - - - 651,139 1,229,600 53%Century CenterCentury Center Operations 670 285,126 320,545 296,240 305,530 257,232 370,211 - - - - - - 1,834,883 4,557,114 40%Century Center Capital 671 74 66 - 144 73 70 - - - - - - 427 900 47%Century Center Energy Saving 672 4 221,441 - 8 4 55,072 - - - - - - 276,530 420,124 66%Sub Total285,204 542,052 296,240 305,682 257,309 425,354 - - - - - - 2,111,841 4,978,138 42%Total Venues, Parks & Arts 748,540 786,798 1,052,324 943,342 656,956 6,903,527 - - - - - - 11,091,487 24,136,886 46%Period Ending: June 30, 2018Monthly Financial Report7 of 24 City of South BendRevenue by Fund ReportFund%Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetPeriod Ending: June 30, 2018Public SafetyPolice DepartmentPolice Seizures 216 485 4,179 162 162 3,782 322 - - - - - - 9,092 32,000 28%Curfew Violations 218 31 21 11 11 10 71 - - - - - - 153 300 51%Law Enforcement Education 220 27,367 18,710 30,422 16,072 19,138 12,801 - - - - - - 124,511 271,500 46%Public Safety LOIT 249 637,913 636,475 636,611 846 2,024,136 742,965 - - - - - - 4,678,945 7,635,539 61%Police Take Home Vehicle 278 2,042 1,457 858 857 839 1,448 - - - - - - 7,501 4,000 188%Police Block Grant 280 9 6 3 3 3 6 - - - - - - 32 35 90%Police Grants 292 - - - - - - - - - - - - - - NA Police Academy 294 7,809 8,737 1,379 3,181 447 160 - - - - - - 21,713 22,500 97%COPS More Grants 295 1,496 26,664 1,128 1,056 14,999 1,221 - - - - - - 46,563 92,000 51%Drug Enforcement 299 164 6,377 160 197 211 220 - - - - - - 7,330 51,000 14%K-9 Unit 705 7 5 2 2 2 5 - - - - - - 23 2,020 1%Sub Total677,322 702,630 670,736 22,388 2,063,569 759,218 - - - - - - 4,895,863 8,110,894 60%Fire DepartmentEMS Capital 287 1,088,873 9,083 4,146 3,853 28,876 544,916 - - - - - - 1,679,747 610,425 275%EMS Operating Fund 288 322,278 245,130 962,243 404,791 651,597 447,139 - - - - - - 3,033,179 5,186,384 58%Hazmat 289 64 44 23 23 22 44 - - - - - - 220 10,200 2%River Rescue 291 7,495 8,022 5,508 6,114 1,315 14,154 - - - - - - 42,607 45,500 94%Sub Total1,418,710 262,280 971,920 414,780 681,810 1,006,253 - - - - - - 4,755,753 5,852,509 81%Total Public Safety 2,096,032 964,910 1,642,656 437,168 2,745,378 1,765,471 - - - - - - 9,651,615 13,963,403 69%Public WorksStreetsMotor Vehicle Highway 202 579,560 469,318 1,559,435 741,820 711,808 1,546,419 - - - - - - 5,608,360 11,288,058 50%Local Roads & Streets 251 203,272 163,889 163,935 623,779 174,065 291,302 - - - - - - 1,620,244 1,868,000 87%Local Road & Bridge Grant 265 - - 753 807 597 1,093 - - - - - - 3,249 - NA Project ReLeaf 655 39,153 38,649 37,857 37,835 52,491 23,998 - - - - - - 229,983 445,800 52%Sub Total821,986 671,857 1,761,980 1,404,241 938,961 1,862,812 - - - - - - 7,461,836 13,601,858 55%Solid WasteSolid Waste Operations 610 430,160 429,729 429,993 458,203 648,222 323,532 - - - - - - 2,719,839 5,493,691 50%Solid Waste Capital 611 96 293,038 - 83,101 20,538 185,581 - - - - - - 582,353 1,077,506 54%Sub Total430,256 722,767 429,993 541,304 668,760 509,112 - - - - - - 3,302,192 6,571,197 50%Water Works0000 Water Works Revenues 620 947,619 981,889 938,998 1,133,739 1,492,413 972,136 - - - - - - 6,466,794 14,784,173 44%0630 Water Leak Insurance 620 82,210 82,136 82,151 83,498 117,515 55,449 - - - - - - 502,959 1,012,683 50%0640 Water Works 620 - - - - - - - - - - - - - - NA 0660 Clay Water 620 70,281 70,546 69,452 81,550 85,849 125,763 - - - - - - 503,440 1,356,710 37%Waterworks Capital 622 5,129 3,471 1,764 1,758 13,251 13,497 - - - - - - 38,870 380,000 10%Waterworks Deposit 624 3,630 2,451 1,247 1,241 1,204 2,426 - - - - - - 12,200 15,000 81%Waterworks Sinking 625 166,918 165,664 165,836 165,897 166,129 166,943 - - - - - - 997,386 2,009,217 50%Waterworks Bond Reserve 626 3,335 2,280 1,176 1,172 1,147 2,274 - - - - - - 11,383 16,000 71%Waterworks Debt Reserve 629 58,511 4,227 2,190 2,179 2,116 4,260 - - - - - - 73,482 75,250 98%Sub Total1,337,633 1,312,665 1,262,813 1,471,034 1,879,624 1,342,746 - - - - - - 8,606,514 19,649,033 44%Wastewater/Sewer/Organic ResourcesSewer Repair Insurance 640 57,037 56,067 54,602 54,553 77,239 35,741 - - - - - - 335,239 626,535 54%0000 Wastewater Revenues 641 2,916,439 2,990,482 2,919,440 3,505,847 4,000,241 2,253,736 - - - - - - 18,586,185 35,660,069 52%0621 Sewer Department 641 760 - - - - 4,488 - - - - - - 5,248 2,500 210%0625 Concrete Crew 641 - 3,050 5,935 9,706 - 11,270 - - - - - - 29,961 55,170 54%0630 Wastewater Operations 641 - - - - - 1,014 - - - - - - 1,014 - NA 0631 Organic Resources 641 - - 50,000 (50,000) - 5,836 - - - - - - 5,836 - NA 0650 Clay Sewage 641 183,418 191,425 189,159 195,271 197,050 206,945 - - - - - - 1,163,269 2,160,000 54%Sewage Capital 642 17,620 11,009 5,623 1,005,502 35,758 2,036,994 - - - - - - 3,112,506 10,588,000 29%Sewage Reserve 643 12,344 246,543 4,240 4,407 4,278 8,614 - - - - - - 280,426 273,226 103%Sewage Bond Sinking 649 1,899 1,383 3,052,829 765,660 766,414 771,108 - - - - - - 5,359,293 9,187,029 58%Sewage Works DS Reserve 653 - 3,678 4,038 3,972 4,861 5,086 - - - - - - 21,636 14,700 147%2011 Sewer Bond 659 0 0 0 0 0 0 - - - - - - 1 5 23%2012 Sewer Bond 661 1,538 1,039 396 117 90 27 - - - - - - 3,208 10,000 32%Sub Total3,191,056 3,504,676 6,286,262 5,495,037 5,085,933 5,340,859 - - - - - - 28,903,822 58,577,234 49%Total Public Works 5,780,930 6,211,964 9,741,049 8,911,615 8,573,277 9,055,529 - - - - - - 48,274,364 98,399,322 49%Monthly Financial Report8 of 24 City of South BendRevenue by Fund ReportFund%Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetPeriod Ending: June 30, 2018Capital & Debt Service Fund2017 Parks Bond Debt Service 312 - - - - - 404,543 - - - - - - 404,543 451,000 90%Hall of Fame Debt Service 313 - 22 26,131 (26,012) - 248,545 - - - - - - 248,685 345,479 72%2018 Fire Station #9 Debt Service 350 - - - - - - - - - - - - - - NA Professional Sports Development 377 37 - - - - - - - - - - - 37 620,000 0%Coveleski Stadium 401 131 88 45 45 43 87 - - - - - - 439 44,250 1%COIT 404 929,149 954,707 1,240,204 40,933 3,106,815 1,090,669 - - - - - - 7,362,478 11,611,424 63%Cumulative Capital Development 406 1,336 976 350 327 317 259,322 - - - - - - 262,628 459,200 57%Cumulative Capital Improvement 407 222,424 (220,745) 311 149 145 112,006 - - - - - - 114,291 278,500 41%EDIT 408 923,177 913,974 1,259,362 11,898 2,821,210 1,638,989 - - - - - - 7,568,610 11,285,625 67%UDAG 410 1,129 10,139 369 9,745 337 682 - - - - - - 22,400 138,728 16%Major Moves 412 6,962 312,097 2,536 2,415 2,271 4,519 - - - - - - 330,800 518,178 64%Morris PAC Improvement 416 2,516 11,683 7,547 27,886 15,386 2,448 - - - - - - 67,466 129,000 52%Palais Historic Preservation 450 3,987 621 618 896 1,928 1,855 - - - - - - 9,906 17,100 58%2018 Fire Station #9 Capital 451 - - 4,864,008 142,151 3,854 7,764 - - - - - - 5,017,778 5,005,758 100%2017 Parks Bond Capital 471 - - 10,526 11,306 10,992 22,104 - - - - - - 54,928 3,000 1831%Hall of Fame Capital 677 1,076 723 363 355 342 683 - - - - - - 3,542 5,000 71%Equipment / Vehicle Leasing 750 200 718 651 511 101,682 6,116,382 - - - - - - 6,220,143 10,821,460 57%Parks Bond Capital 751 - 557 4,303 (3,322) 365 383 - - - - - - 2,287 4,500 51%Smart Street Bond Capital 753 - 177 175 157 173 208 - - - - - - 890 1,500 59%SB Building Corp 755 - 1,324,193 1,054 464 599 659 - - - - - - 1,326,969 2,636,025 50%Parks Bond Debt Svc 757 - 31,935 31,719 30,456 31,602 31,660 - - - - - - 157,372 379,907 41%Eddy St. Commons Capital 759 - 34 4 4 4 5 - - - - - - 51 2,000 3%Eddy St. Commons Debt 760 - 425 628,897 384 425 511 - - - - - - 630,642 1,279,472 49%Total Capital & Debt Service 2,092,124 3,342,322 8,079,175 250,749 6,098,491 9,944,026 - - - - - - 29,806,886 46,037,106 65%Department of Community InvestmentStudebaker/Oliver 209 37,428 4,300 2,632 733 713 1,406 - - - - - - 47,212 205,014 23%State Grant 210 3,321 673 339 338 316 18,620 - - - - - - 23,607 79,887 30%DCI Operating 211 97,850 10,408 597,142 11,407 14,423 476,296 - - - - - - 1,207,525 2,655,381 45%0000 Dept. of Community Investment 212 2,443 363,662 177,763 161,022 166,785 393,680 - - - - - - 1,265,354 5,654,789 22%1013 Programs 212 - 12,542 - - - - - - - - - - 12,542 250,739 5%Economic Revenue Bond 281 67 45 23 23 22 45 - - - - - - 225 200 112%Total Dept of Community Investment 141,109 391,630 777,899 173,523 182,259 890,046 - - - - - - 2,556,465 8,846,010 29%Central ServicesCentral Services 222 711,462 743,850 730,557 671,452 714,379 651,639 - - - - - - 4,223,339 8,708,507 48%Central Services Capital 224 467 262 140 127 123 205 - - - - - - 1,325 78,000 2%Total Central Services 711,930 744,112 730,697 671,579 714,502 651,844 - - - - - - 4,224,663 8,786,507 48%Liability Insurance0000 Business Insurance Revenues 226 188,502 178,952 172,513 175,756 180,379 175,233 - - - - - - 1,071,336 2,098,123 51%0403 Self Funded Liability Ins 226 - - - - - - - - - - - - - - NA 0412 Liability Insurance 226 - - - - - - - - - - - - - - NA 0417 Business Insurance 226 - - - - - - - - - - - - - - NA 0418 Workers Compensation 226 - 16,000 - - 780 - - - - - - - 16,780 2,000 839%Total Liability Insurance 188,502 194,951 172,513 175,756 181,159 175,233 - - - - - - 1,088,115 2,100,123 52%Code EnforcementUnsafe Building 219 8,297 10,793 177,440 8,805 19,463 174,038 - - - - - - 398,836 908,773 44%Landlord Registration 221 55 200 57 13 8 16 - - - - - - 349 6,000 6%1201 Neighborhood Code Enforcement 600 34,861 50,613 87,949 15,743 14,439 65,650 - - - - - - 269,255 542,891 50%1207 Animal Care & Control 600 9,000 5,690 213,293 9,060 7,893 213,449 - - - - - - 458,384 894,312 51%1208 Rental Unit Inspection 600 - - - - - - - - - - - - - 30,000 0%Total Code Enforcement 52,213 67,296 478,739 33,621 41,802 453,153 - - - - - - 1,126,824 2,381,976 47%Monthly Financial Report9 of 24 City of South BendRevenue by Fund ReportFund%Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetPeriod Ending: June 30, 2018Building Department1306 Building Dept Operations 600 80,975 97,855 112,720 190,817 171,901 134,235 - - - - - - 788,505 1,395,552 57%Total Building Department 80,975 97,855 112,720 190,817 171,901 134,235 - - - - - - 788,505 1,395,552 57%OtherMiscellaneousRainy Day 102 24,622 16,629 8,451 8,424 8,187 16,491 - - - - - - 82,803 80,000 104%Gift, Donation, Bequest 217 18,967 403 30,663 432 924 1,132 - - - - - - 52,520 45,800 115%Loss Recovery 227 2,029 1,226 590 583 560 1,125 - - - - - - 6,112 4,000 153%LOIT 2016 Special Distribution 257 1,967 10,003 1,770 18,352 671,605 41,768 - - - - - - 745,464 2,240,000 33%Human Rights 258 11,146 6,333 7,584 3,894 389 39,911 - - - - - - 69,258 167,400 41%IT / Innovation /311 Call Center 279 584,945 568,346 567,429 667,191 570,188 569,001 - - - - - - 3,527,100 6,850,931 51%Sub Total643,676 602,940 616,487 698,875 1,251,852 669,427 - - - - - - 4,483,257 9,388,131 48%Fiduciary Trust & AgencyFire Pension 701 3,766 642 14 - 3,052 2,239,434 - - - - - - 2,246,908 5,217,138 43%Police Pension 702 2,515 1,314 244 213 232 3,113,866 - - - - - - 3,118,384 6,005,500 52%Employee Benefits 711 1,562,014 1,526,723 1,520,927 1,534,819 1,532,899 1,532,713 - - - - - - 9,210,094 18,511,596 50%Unemployment Comp 713 542 365 185 182 173 342 - - - - - - 1,789 2,000 89%Parental Leave Fund 714 - - 39,462 12,844 12,678 18,950 - - - - - - 83,934 155,694 54%City Cemetery Trust 730 68 46 23 23 23 46 - - - - - - 229 250 92%Sub Total1,568,905 1,529,090 1,560,856 1,548,081 1,549,056 6,905,351 - - - - - - 14,661,339 29,892,178 49%Total Other 2,212,581 2,132,030 2,177,343 2,246,955 2,800,908 7,574,778 - - - - - - 19,144,596 39,280,309 49%Total Civil City 15,455,459 16,231,806 26,226,017 15,367,592 23,660,645 62,983,538 - - - - - - 159,925,056 305,334,083 52%Redevelopment FundsTax Increment FinancingTIF River West - Airport 324 166,079 208,028 26,039 4,492,291 24,964 10,652,105 - - - - - - 15,569,505 23,734,532 66%TIF West Washington 422 5,328 3,682 1,842 1,805 1,744 177,019 - - - - - - 191,420 436,000 44%TIF Leighton Plaza 425 10,000 11,541 11,324 6,996 126 254 - - - - - - 40,241 197,014 20%TIF River East DEV (NE) 429 23,830 13,582 6,937 75,411 6,610 1,455,261 - - - - - - 1,581,631 2,425,809 65%TIF Southside 430 18,064 12,668 6,438 6,409 6,203 1,271,003 - - - - - - 1,320,785 2,463,000 54%TIF Erskine Village 432 - - - - - - - - - - - - - - NA TIF Douglas Road 435 368 324 165 164 160 322 - - - - - - 1,504 1,150 131%TIF River East RES (NE RE) 436 5,385 - 61 6 - 2,616,136 - - - - - - 2,621,588 4,405,500 60%Sub Total229,054 249,826 52,806 4,583,083 39,807 16,172,099 - - - - - - 21,326,674 33,663,005 63%Redevelopment FundsAdministration 433 18 12 6 6 6 12 - - - - - - 60 135 44%Certified Technology Park 439 1,469 992 504 502 488 984 - - - - - - 4,939 2,500 198%2018 TIF Park Bond Capital 452 - - - 10,825,000 182,782 - - - - - - - 11,007,782 11,007,782 100%Airport Urban Enterprise Zone 454 926 626 318 317 308 620 - - - - - - 3,115 3,900 80%Industrial Revolving 754 - 14,682 32,213 12,451 16,700 9,233 - - - - - - 85,279 210,000 41%Sub Total2,413 16,311 33,041 10,838,276 200,284 10,849 - - - - - - 11,101,174 11,224,317 99%Debt ServiceAirport Debt Reserve 2003 315 2,489 1,677 853 849 825 1,660 - - - - - - 8,352 14,000 60%Coveleski Bond Debt Reserve 317 1,239 837 425 424 412 830 - - - - - - 4,167 5,000 83%Central Development reserve 328 4,160 2,803 1,427 1,420 1,378 2,775 - - - - - - 13,964 20,000 70%2018 TIF Park Bond Debt Service 351 - - - 993,495 - - - - - - - - 993,495 993,495 100%SB Redevelopment Authority 752 - 249,971 1,235,043 1,108 196,732 402 - - - - - - 1,683,255 3,367,200 50%Smart Streets Debt Svc 756 - 856,792 367 264 293 352 - - - - - - 858,068 1,716,500 50%Sub Total7,888 1,112,079 1,238,115 997,560 199,640 6,018 - - - - - - 3,561,300 6,116,195 58%Total Redevelopment 239,354 1,378,217 1,323,962 16,418,919 439,730 16,188,966 - - - - - - 35,989,148 51,003,517 71%Revenue Total 15,694,813 17,610,023 27,549,979 31,786,510 24,100,375 79,172,504 - - - - - - 195,914,204 356,337,600 55%Monthly Financial Report10 of 24 City of South BendProperty Tax Revenue2017 Tax Pay 2018Levy Estimated Distribution 1 Distribution 2Distribution 3 Distribution 4 LevyPer County Collection ProjectedTotal Property TaxCollectionFund Fund #Records Factor Collections Collections Collections Collections Collections Collections Receivable RateCityGeneral Fund 10143,581,137.00 0.95 41,402,080.15 22,404,587.07 - - 22,404,587.07 21,176,549.93 51.41%Parks & Recreation 20110,254,295.00 0.95 9,741,580.25 5,271,459.79 - - 5,271,459.79 4,982,835.21 51.41%2017 Parks Bond Debt Service 312704,791.00 0.95 669,551.45 386,442.49 - - 386,442.49 318,348.51 54.83%College Football Hall of Fame 313428,166.00 0.95 406,757.70 234,466.86 - - 234,466.86 193,699.14 54.76%Cumulative Capital District 406467,156.00 0.95 443,798.20 239,981.73 - - 239,981.73 227,174.27 51.37%Total - City55,435,545.00 52,663,767.75 28,536,937.94 - - - 28,536,937.94 26,898,607.06 51.48%Tax Increment FinancingAirport TIF District 32418,199,057.00 0.95 17,289,104.15 10,603,197.87 - - 10,603,197.87 7,595,859.13 58.26%West Washington TIF District 422340,278.00 0.95 323,264.10 173,582.65 - - 173,582.65 166,695.35 51.01%Northeast Residential TIF District 4364,646,292.00 0.95 4,413,977.40 1,442,090.26 - - 1,442,090.26 3,204,201.74 31.04%Southside TIF District #1 4302,421,630.00 0.95 2,300,548.50 1,258,578.92 - - 1,258,578.92 1,163,051.08 51.97%Northeast TIF 4293,057,914.00 0.95 2,905,018.30 2,616,135.74 - - 2,616,135.74 441,778.26 85.55%Total - Tax Increment Financing28,665,171.00 27,231,912.45 16,093,585.44 - - - 16,093,585.44 12,571,585.56 56.14%Grand Total84,100,716.00 79,895,680.20 44,630,523.38 - - - 44,630,523.38 39,470,192.62 53.07%Note(s)2017 pay 2018 to be determined2016 Tax Pay 2017Levy Estimated Distribution 1 Distribution 2Distribution 3 Distribution 4 LevyPer County Collection Projected 6/20/2017 12/20/2017 Total Property TaxCollectionFund Fund #Records Factor Collections Collections Collections Collections Collections Collections Receivable RateCityGeneral Fund 10140,248,867.00 0.95 38,236,423.65 21,820,142.51 17,747,933.08 - - 39,568,075.59 680,791.41 98.31%Parks & Recreation 2019,179,442.00 0.95 8,720,469.90 4,976,456.29 4,057,274.45 - - 9,033,730.74 145,711.26 98.41%College Football Hall of Fame 313833,277.00 0.95 791,613.15 451,820.36 368,250.79 - - 820,071.15 13,205.85 98.42%Cumulative Capital District 406443,869.00 0.95 421,675.55 240,635.07 196,188.32 - - 436,823.39 7,045.61 98.41%Total - City50,705,455.00 48,170,182.25 27,489,054.23 22,369,646.64 - - 49,858,700.87 846,754.13 98.33%Tax Increment FinancingAirport TIF District 32418,698,946.24 0.95 17,763,998.93 8,932,881.19 8,327,020.81 - - 17,259,902.00 1,439,044.24 92.30%West Washington TIF District 422367,557.18 0.95 349,179.32 198,151.66 180,841.94 - - 378,993.60 (11,436.42) 103.11%Northeast Residential TIF District 4364,405,723.00 0.95 4,185,436.85 2,320,321.06 1,942,596.42 - - 4,262,917.48 142,805.52 96.76%Southside TIF District #1 4302,390,790.99 0.95 2,271,251.44 1,216,823.61 1,148,868.40 - - 2,365,692.01 25,098.98 98.95%Douglas Road TIF District 435321,949.68 0.95 305,852.20 218,279.99 160,974.84 - - 379,254.83 (57,305.15) 117.80%Northeast TIF 4292,766,113.25 0.95 2,627,807.59 1,428,045.99 1,202,840.55 - - 2,630,886.54 135,226.71 95.11%Total - Tax Increment Financing28,951,080.34 27,503,526.32 14,314,503.50 12,963,142.96 - - 27,277,646.46 1,673,433.88 94.22%Grand Total79,656,535.34 75,673,708.57 41,803,557.73 35,332,789.60 - - 77,136,347.33 2,520,188.01 96.84%Note(s)Distribution 1 - Issued by St. Joseph County on 6/20/17Distribution 2 - Issued by St. Joseph County on 12/20/17Period Ending: June 30, 2018Monthly Financial Report11 of 24 City of South BendExpenditure ReportFund%Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetGeneral FundGeneral Government0101 Mayor 101 66,242 71,445 73,404 68,449 68,770 93,100 - - - - - - 441,410 908,142 49%0201 Clerk 101 41,465 49,121 40,587 39,949 40,713 50,724 - - - - - - 262,559 573,553 46%0301 Common Council 101 47,784 61,913 56,765 38,989 37,543 38,639 - - - - - - 281,634 670,013 42%0302 WNIT Contract 101 - - 43,000 - - - - - - - - - 43,000 43,000 100%0401 Administration and Finance 101 181,515 157,607 179,655 226,791 195,799 255,119 - - - - - - 1,196,486 2,639,826 45%0501 Legal 101 80,972 80,377 73,951 75,604 83,331 119,686 - - - - - - 513,920 1,200,973 43%Sub Total417,977 420,463 467,362 449,783 426,154 557,269 - - - - - - 2,739,009 6,035,507 45%Public Works0602 Engineering 101 97,206 113,041 103,308 119,067 116,490 178,064 - - - - - - 727,177 1,750,084 42%0628 AmeriCorps Grant Program 101 - - - - - - - - - - - - - 366,188 0%Sub Total97,206 113,041 103,308 119,067 116,490 178,064 - - - - - - 727,177 2,116,272 34%Public Safety0801 Police 101 2,553,505 2,055,904 2,718,475 2,132,895 2,350,326 3,006,258 - - - - - - 14,817,363 29,626,242 50%0901 Fire 101 1,702,483 1,610,625 1,725,671 1,768,450 1,674,070 2,246,841 - - - - - - 10,728,139 21,743,343 49%Sub Total4,255,987 3,666,528 4,444,146 3,901,345 4,024,396 5,253,100 - - - - - - 25,545,502 51,369,585 50%Arts & Culture0404 Morris PAC 101 66,022 73,169 75,014 97,698 72,067 84,366 - - - - - - 468,337 1,320,791 35%0405 Palais Royale 101 24,590 30,996 30,536 38,928 28,467 33,097 - - - - - - 186,613 541,428 34%Sub Total90,612 104,165 105,550 136,627 100,535 117,462 - - - - - - 654,951 1,862,219 35%Human Rights1008 Human Rights 101 24,673 39,414 28,107 30,137 28,074 50,657 - - - - - - 201,062 447,133 45%Sub Total24,673 39,414 28,107 30,137 28,074 50,657 - - - - - - 201,062 447,133 45%Total General Fund 4,886,455 4,343,611 5,148,473 4,636,958 4,695,650 6,156,553 - - - - - - 29,867,700 61,830,716 48%Venues, Parks & ArtsParks & Recreation1100 Administration 201 106,755 110,212 113,541 107,652 112,266 113,719 - - - - - - 664,146 1,227,968 54%1101 Maintenance 201 443,597 540,635 455,011 529,200 381,724 552,375 - - - - - - 2,902,542 7,184,730 40%1102 Golf Operations 201 56,591 61,999 131,255 128,948 179,825 168,374 - - - - - - 726,992 1,588,326 46%1103 Recreation Division 201 136,104 122,740 127,055 125,984 121,073 228,394 - - - - - - 861,350 2,181,005 39%1104 Potawatomi Zoo 201 8,216 357,457 3,005 2,991 5,273 9,022 - - - - - - 385,964 700,000 55%1106 Potawatomi Greenhouse 201 5,430 4,242 18,840 3,103 2,171 408 - - - - - - 34,194 46,602 73%1108 Graffiti Removal 201 7,388 7,283 7,197 6,062 7,375 11,255 - - - - - - 46,561 106,459 44%1110 Marketing and Events 201 68,206 71,319 71,723 57,212 70,917 91,671 - - - - - - 431,049 1,133,376 38%1111 Regional Cities Grant 201 28,510 9,390 225,748 18,685 211,886 56,822 - - - - - - 551,041 2,113,595 26%Recreation Non Reverting 203 49,052 76,096 61,804 52,166 101,332 109,720 - - - - - - 450,171 1,740,403 26%Morris Palais Marketing 273 - - - - 2,858 - - - - - - - 2,858 18,000 16%Morris PAC Self-Promotion 274 - - - - - - - - - - - - - 50,000 0%Zoo Endowment 403 - - - - - - - - - - - - - - NA Park Non-Reverting 405 38,340 17,281 2,465 7,191 7 - - - - - - - 65,283 277,872 23%Sub Total948,190 1,378,655 1,217,645 1,039,194 1,196,706 1,341,760 - - - - - - 7,122,150 18,368,336 39%Parking Garages0400 Parking Garage Administration 601 60,725 - - - - - - - - - - - 60,725 - NA 0460 Main Street 601 4,706 13,676 21,479 17,595 43,399 22,667 - - - - - - 123,522 335,768 37%0462 Leighton Plaza 601 5,884 20,832 29,852 23,965 48,940 28,444 - - - - - - 157,915 484,307 33%0463 Enforcement 601 416 10,797 17,893 9,992 39,101 20,222 - - - - - - 98,420 104,632 94%0464 Wayne Street 601 4,405 12,676 18,657 12,984 42,127 20,382 - - - - - - 111,230 312,637 36%0465 Eddy Street Commons 601 - - - - - - - - - - - - - 15,000 0%Sub Total76,136 57,981 87,880 64,535 173,567 91,714 - - - - - - 551,812 1,252,344 44%Century CenterCentury Center Operations 670 301,878 328,776 305,181 347,087 363,068 390,594 - - - - - - 2,036,584 4,557,114 45%Century Center Capital 671 - - - 5,216 4,800 - - - - - - - 10,016 20,000 50%Century Center Energy Saving 672 - - - - 95,748 - - - - - - - 95,748 306,737 31%Sub Total301,878 328,776 305,181 352,303 463,617 390,594 - - - - - - 2,142,349 4,883,851 44%Total Venues, Parks & Arts 1,326,204 1,765,412 1,610,706 1,456,032 1,833,889 1,824,067 - - - - - - 9,816,310 24,504,531 40%Period Ending: June 30, 2018Monthly Financial Report12 of 24 City of South BendExpenditure ReportFund%Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetPeriod Ending: June 30, 2018Public SafetyPolice DepartmentPolice Seizures 216 - - - - - - - - - - - - - 32,000 0%Curfew Violations 218 - - - - - - - - - - - - - 1,000 0%Law Enforcement Education 220 57,873 16,555 4,699 15,044 7,867 36,004 - - - - - - 138,043 594,624 23%Public Safety LOIT 249 491,276 597,065 748,915 614,419 627,510 898,175 - - - - - - 3,977,361 7,622,970 52%Police Take Home Vehicle 278 - - - - - (124) - - - - - - (124) 10,000 -1%Police Block Grant 280 - - - - - - - - - - - - - - NA Police Grants 292 - - - - - - - - - - - - - - NA Police Academy 294 3,362 964 695 2,795 1,222 135 - - - - - - 9,173 22,500 41%COPS More Grants 295 26,202 960 10,748 840 10,808 14,312 - - - - - - 63,870 112,785 57%Drug Enforcement 299 - - - - - - - - - - - - - 51,000 0%K-9 Unit 705 - - - - - - - - - - - - - 2,020 0%Sub Total578,714 615,545 765,057 633,097 647,407 948,503 - - - - - - 4,188,322 8,448,899 50%Fire DepartmentEMS Capital 287 232,138 245,348 612,456 (57,750) 168,513 744 - - - - - - 1,201,449 3,389,730 35%EMS Operating Fund 288 451,202 438,738 494,754 428,273 410,073 597,054 - - - - - - 2,820,094 6,431,746 44%Hazmat 289 - - - - - - - - - - - - - 10,000 0%River Rescue 291 620 231 1,296 231 7,794 4,343 - - - - - - 14,513 101,800 14%Sub Total683,959 684,317 1,108,506 370,754 586,379 602,141 - - - - - - 4,036,056 9,933,276 41%Total Public Safety 1,262,673 1,299,862 1,873,563 1,003,851 1,233,786 1,550,643 - - - - - - 8,224,378 18,382,175 45%Public WorksStreetsMotor Vehicle Highway 202 929,501 929,777 730,837 543,249 526,212 763,105 - - - - - - 4,422,682 12,393,981 36%Local Roads & Streets 251 - 41,614 38,357 57,236 308,409 208,005 - - - - - - 653,621 3,418,508 19%Local Road & Bridge Grant 265 900 1,755 254,290 3,480 147,066 - - - - - - - 407,491 2,437,632 17%Project ReLeaf 655 3,267 3,043 140,787 27,502 3,155 140,553 - - - - - - 318,308 702,042 45%Sub Total933,668 976,189 1,164,271 631,467 984,843 1,111,663 - - - - - - 5,802,101 18,952,163 31%Solid WasteSolid Waste Operations 610 353,032 690,851 316,475 525,146 360,359 653,109 - - - - - - 2,898,972 5,496,049 53%Solid Waste Capital 611 185,219 146,711 218 83,821 19,559 127 - - - - - - 435,657 1,076,706 40%Sub Total538,251 837,563 316,694 608,967 379,918 653,236 - - - - - - 3,334,629 6,572,755 51%Water Works0630 Water Leak Insurance 620 26,512 56,237 63,642 43,963 60,972 63,888 - - - - - - 315,213 1,035,000 30%0640 Water Works 620 1,352,132 1,350,826 1,337,064 1,187,277 1,155,640 1,270,202 - - - - - - 7,653,139 17,031,780 45%0660 Clay Water 620 104 91 - - 36 65 - - - - - - 296 3,500 8%Waterworks Capital 622 1,642 - - - 407,566 - - - - - - - 409,208 1,578,570 26%Waterworks Deposit 624 1,289 2,451 1,247 1,241 1,204 2,426 - - - - - - 9,858 15,000 66%Waterworks Sinking 625 1,279 569 241 302 534 285,314 - - - - - - 288,239 2,009,217 14%Waterworks Bond Reserve 626 - - - - - - - - - - - - - 16,000 0%Waterworks Debt Reserve 629 2,225 4,227 2,190 2,179 2,116 4,260 - - - - - - 17,197 23,000 75%Sub Total1,385,183 1,414,400 1,404,383 1,234,962 1,628,067 1,626,155 - - - - - - 8,693,150 21,712,067 40%Wastewater/Sewer/Organic ResourcesSewer Repair Insurance 640 21,863 43,609 82,703 50,004 58,271 45,967 - - - - - - 302,419 632,224 48%0621 Sewer Department 641 459,002 1,203,962 636,994 389,786 413,872 473,390 - - - - - - 3,577,007 9,874,691 36%0625 Concrete Crew 641 34,892 33,631 38,464 27,662 28,383 32,747 - - - - - - 195,779 484,265 40%0630 Wastewater Operations 641 1,548,265 1,540,774 4,512,206 3,138,965 2,029,241 4,137,688 - - - - - - 16,907,140 38,090,598 44%0631 Organic Resources 641 231,119 149,015 72,550 64,256 142,065 78,536 - - - - - - 737,540 1,670,534 44%0650 Clay Sewage 641 283 (420) - - 196 230 - - - - - - 289 250 116%Sewage Capital 642 349,920 280,581 15,324 - 81,701 - - - - - - - 727,526 12,314,553 6%Sewage Reserve 643 4,386 8,317 4,240 4,407 4,278 8,614 - - - - - - 34,242 35,000 98%Sewage Bond Sinking 649 1,000 500 - - 1,001,651 - - - - - - - 1,003,151 9,156,379 11%Sewage Works DS Reserve 653 - - - - - - - - - - - - - - NA 2011 Sewer Bond 659 - - - - - - - - - - - - - 150 0%2012 Sewer Bond 661 - 501,426 - 126,788 - - - - - - - - 628,214 649,686 97%Sub Total2,650,730 3,761,396 5,362,482 3,801,869 3,759,658 4,777,173 - - - - - - 24,113,307 72,908,330 33%Total Public Works 5,507,832 6,989,548 8,247,829 6,277,265 6,752,486 8,168,227 - - - - - - 41,943,188 120,145,315 35%Monthly Financial Report13 of 24 City of South BendExpenditure ReportFund%Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetPeriod Ending: June 30, 2018Capital & Debt Service Fund2017 Parks Bond Debt Service 312 - - - - - - - - - - - - - 595,304 0%Hall of Fame Debt Service 313 633,000 - (1,685) - - - - - - - - - 631,315 632,315 100%2018 Fire Station #9 Debt Service 350 - - - - - - - - - - - - - - NA Professional Sports Development 377 361,390 100,800 - - - - - - - - - - 462,190 814,870 57%Coveleski Stadium 401 - - - - - - - - - - - - - 145,000 0%COIT 404 651,760 1,218,145 1,190,526 388,527 408,002 1,015,038 - - - - - - 4,871,998 12,001,673 41%Cumulative Capital Development 406 195,231 27,896 - 10,711 - - - - - - - - 233,838 459,200 51%Cumulative Capital Improvement 407 249,500 - - - - - - - - - - - 249,500 278,500 90%EDIT 408 170,329 175,790 2,100,014 583,226 239,805 1,464,363 - - - - - - 4,733,527 12,214,594 39%UDAG 410 - 31,814 - 33,602 - - - - - - - - 65,415 610,131 11%Major Moves 412 979 94,995 267,049 113 108,825 - - - - - - - 471,960 2,573,799 18%Morris PAC Improvement 416 - - 39,497 2,545 41,873 - - - - - - - 83,915 184,100 46%Palais Historic Preservation 450 - - - - - - - - - - - - - 45,000 0%2018 Fire Station #9 Capital 451 - - - 138,575 - - - - - - - - 138,575 - NA 2017 Parks Bond 471 - 17,750 - - 295,720 73,560 - - - - - - 387,030 10,309,100 4%Hall of Fame Capital 677 5,294 8,730 4,224 3,185 1,395 1,340 - - - - - - 24,168 129,227 19%Equipment / Vehicle Leasing 750 - - 1,238,339 130,671 711,929 236,789 - - - - - - 2,317,729 9,457,649 25%Parks Bond Capital 751 - 142,569 742,870 417,001 249,750 24,628 - - - - - - 1,576,818 3,136,530 50%Smart Street Bond Capital 753 - 12,431 5,592 3,843 5,791 823,953 - - - - - - 851,610 2,101,500 41%SB Building Corp 755 - - 1,431,631 2,500 - - - - - - - - 1,434,131 2,636,025 54%Parks Bond Debt Svc 757 - - 190,341 - - - - - - - - - 190,341 380,107 50%Eddy St. Commons Capital 759 - - - - - - - - - - - - - 39,103,750 0%Eddy St. Commons Debt 760 - - 628,472 - - - - - - - - - 628,472 3,779,472 17%Total Capital & Debt Service 2,267,482 1,830,919 7,836,871 1,714,499 2,063,089 3,639,672 - - - - - - 19,352,532 101,587,846 19%Department of Community InvestmentStudebaker/Oliver 209 14,869 3,179 1,898 14,992 10,985 1,283 - - - - - - 47,205 1,078,598 4%State Grant 210 - - 18,003 - 18,003 - - - - - - - 36,005 257,133 14%DCI Operating 211 199,829 228,512 228,504 257,362 234,160 276,492 - - - - - - 1,424,858 3,077,096 46%Programs 212 242,431 218,522 64,822 268,529 186,255 334,220 - - - - - - 1,314,780 5,874,598 22%Total Dept of Community Investment 457,129 450,212 313,226 540,884 449,403 611,994 - - - - - - 2,822,848 10,287,425 27%Central Services0605 Equipment Services 222 255,181 234,013 180,814 189,297 227,444 230,621 - - - - - - 1,317,370 3,072,612 43%0606 Building Maintenance 222 17,233 17,032 17,679 16,050 16,278 21,870 - - - - - - 106,143 213,832 50%0612 Central Stores 222 19,345 19,143 19,527 18,754 19,731 27,028 - - - - - - 123,528 236,428 52%0613 Print Shop 222 10,612 9,948 11,992 9,965 9,512 20,670 - - - - - - 72,700 192,329 38%0614 Radio Shop 222 22,971 23,167 22,527 22,416 20,738 29,306 - - - - - - 141,125 336,927 42%0616 Energy/Sustainability 222 15,261 25,951 13,856 43,320 25,024 29,390 - - - - - - 152,803 380,560 40%0617 Electric & Gas Utilities 222 363,766 477,069 394,275 336,686 387,629 328,060 - - - - - - 2,287,484 4,375,000 52%Central Services Capital 224 22,614 16,567 - 2,100 32,979 2,550 - - - - - - 76,810 155,036 50%Total Central Services 726,982 822,890 660,670 638,589 739,334 689,497 - - - - - - 4,277,963 8,962,724 48%Liability Insurance0403 Self Funded Liability Ins 226 19,540 16,545 17,760 17,369 15,908 22,308 - - - - - - 109,429 262,724 42%0412 Liability Insurance 226 43,410 151,831 84,217 253,106 308,425 69,711 - - - - - - 910,700 2,058,406 44%0417 Business Insurance 226 18,256 14,875 16,075 5,459 45,758 138,200 - - - - - - 238,622 690,694 35%0418 Workers Compensation 226 59,655 260,416 142,763 132,349 88,620 91,198 - - - - - - 775,001 680,717 114%0419 Catastrophic Events 226 - - - - - 9,668 - - - - - - 9,668 - NA Total Liability Insurance 140,861 443,667 260,814 408,283 458,711 331,085 - - - - - - 2,043,421 3,692,541 55%Code EnforcementUnsafe Building 219 54,128 47,800 43,198 47,964 48,180 47,670 - - - - - - 288,939 972,413 30%Landlord Registration 221 - - 5 - - - - - - - - - 5 1,000 1%1201 Neighborhood Code Enforcement 600 176,422 126,847 123,310 109,863 130,210 166,465 - - - - - - 833,117 1,835,827 45%1207 Animal Care & Control 600 62,449 81,335 66,239 68,463 64,068 78,084 - - - - - - 420,640 968,596 43%1208 Rental Unit Inspection 600 - - 51 (51) - 5,134 - - - - - - 5,134 180,000 3%Total Code Enforcement 292,999 255,982 232,803 226,239 242,458 297,354 - - - - - - 1,547,836 3,957,836 39%Monthly Financial Report14 of 24 City of South BendExpenditure ReportFund%Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of BudgetPeriod Ending: June 30, 2018Building Department1306 Building Dept Operations 600 171,357 103,354 107,540 107,639 111,228 144,510 - - - - - - 745,627 1,658,827 45%Total Building Department 171,357 103,354 107,540 107,639 111,228 144,510 - - - - - - 745,627 1,658,827 45%OtherMiscellaneousGift, Donation, Bequest 217 3,461 - (3,461) 350 338 7,970 - - - - - - 8,658 43,428 20%Loss Recovery 227 107,957 26,251 10,857 - 1,583 7,911 - - - - - - 154,559 515,323 30%LOIT 2016 Special Distribution 257 82,709 64,142 118,674 27,105 140,861 56,660 - - - - - - 490,151 4,213,349 12%Human Rights 258 14,012 1,644 9,448 13,219 22,020 12,108 - - - - - - 72,451 163,234 44%IT / Innovation /311 Call Center 279 235,061 632,764 405,139 375,321 766,827 386,933 - - - - - - 2,802,046 7,155,112 39%Sub Total443,200 724,801 540,657 415,995 931,630 471,582 - - - - - - 3,527,866 12,090,446 29%Fiduciary Trust & AgencyFire Pension 701 373,509 517,553 378,759 376,521 377,630 383,979 - - - - - - 2,407,951 5,112,457 47%Police Pension 702 593,204 510,652 509,711 520,228 510,146 506,002 - - - - - - 3,149,943 6,583,452 48%Employee Benefits 711 1,436,330 941,195 1,462,636 1,290,461 1,505,457 818,176 - - - - - - 7,454,253 18,145,518 41%Unemployment Comp 713 - 565 5,094 4,483 4,630 3,386 - - - - - - 18,158 80,000 23%Parental Leave Fund 714 - 1,765 12,094 9,025 9,143 14,215 - - - - - - 46,242 155,694 30%City Cemetery Trust 730 - - - - - - - - - - - - - 25,000 0%Sub Total2,403,043 1,971,729 2,368,293 2,200,718 2,407,006 1,725,757 - - - - - - 13,076,547 30,102,121 43%Total Other 2,846,243 2,696,530 2,908,950 2,616,713 3,338,636 2,197,339 - - - - - - 16,604,413 42,192,567 39%Total Civil City 19,886,217 21,001,989 29,201,445 19,626,953 21,918,671 25,610,942 - - - - - - 137,246,217 397,202,503 35%Redevelopment FundsTax Increment FinancingTIF River West - Airport 324 3,981,156 1,852,277 2,735,556 1,057,684 900,737 2,529,790 - - - - - - 13,057,200 45,356,182 29%TIF West Washington 422 - 74,176 12,194 28,698 39,016 - - - - - - - 154,085 1,885,916 8%TIF Leighton Plaza 425 7,611 3,202 18,559 7,529 - - - - - - - - 36,901 158,166 23%TIF River East DEV (NE) 429 303,011 77,081 53,243 91,864 21,392 58,507 - - - - - - 605,098 7,587,691 8%TIF Southside 430 3,188 9,734 36,978 19,564 38,151 66,373 - - - - - - 173,987 7,556,026 2%TIF Erskine Village 432 - - - - - - - - - - - - - - NA TIF Douglas Road 435 - - - - - - - - - - - - - 144,650 0%TIF River East RES (NE RE) 436 1,234,500 875,136 - - - - - - - - - - 2,109,636 4,320,000 49%Sub Total5,529,466 2,891,606 2,856,530 1,205,339 999,296 2,654,670 - - - - - - 16,136,906 67,008,631 24%Redevelopment FundsAdministration 433 - - - - 561 - - - - - - - 561 4,500 12%Certified Technology Park 439 - - - - - - - - - - - - - - NA 2018 TIF Park Bond Capital 452 - - - - 169,947 28,424 - - - - - - 198,370 10,932,782 2%Airport Urban Enterprise Zone 454 - - - - - - - - - - - - - 50,000 0%Industrial Revolving 754 - 5,832 7,415 8,250 8,725 8,104 - - - - - - 38,326 157,000 24%Sub Total- 5,832 7,415 8,250 179,233 36,528 - - - - - - 237,257 11,144,282 2%Debt ServiceAirport Debt Reserve 2003 315 884 1,677 853 849 825 1,660 - - - - - - 6,748 14,000 48%Coveleski Bond Debt Reserve 317 - - - - - - - - - - - - - - NA Central Development reserve 328 1,478 2,803 1,427 1,420 1,378 2,775 - - - - - - 11,281 20,000 56%SB Redevelopment Authority 752 - - 1,483,953 324,220 - 349,906 - - - - - - 2,158,080 3,365,829 64%Smart Streets Debt Svc 756 - - 852,884 - - 1,650 - - - - - - 854,534 1,709,794 50%Sub Total2,362 4,480 2,339,118 326,489 2,203 355,991 - - - - - - 3,030,643 5,109,623 59%Total Redevelopment 5,531,828 2,901,918 5,203,062 1,540,079 1,180,731 3,047,189 - - - - - - 19,404,807 83,262,536 23%Total Expenditures 25,418,045 23,903,907 34,404,507 21,167,031 23,099,403 28,658,131 - - - - - - 156,651,024 480,465,039 33%Monthly Financial Report15 of 24 1st 2nd 3rd 4thCivil City DebtCapital Leases1102013 PNC Vehicle & Equipment Lease Vehicles/Equipment2013 N/A 2018 Various 1/15 7/15 -- -- 1,689,669.59 346,724.77 346,724.77 - 3,175.76 - 349,900.53 1122013 Building Department Ricoh Copier Copier Lease2013 N/A 2018 600 Monthly 26th -- -- 4,093.64 613.22 613.22 - 12.80 - 626.02 1132013 Suntrust Vehicle Lease Vehicles/Equipment2013 N/A 2018 Various 4/24 10/24 -- -- 1,506,465.26 310,880.69 310,880.69 - 3,700.46 - 314,581.15 1142013 Administration & Finance Ricoh Copier Copier Lease2013 N/A 2018 101 1/16 4/16 7/16 10/16 11,247.97 634.57 634.57 - 9.23 - 643.80 1172013 Police Department Records Division Ricoh Copier Copier Lease2013 N/A 2018 101 Monthly 3rd -- -- 9,678.26 2,154.91 2,154.91 - 65.09 - 2,220.00 1182013 Water Works Main Street Ricoh Copier Copier Lease2013 N/A 2018 620 Monthly 10th -- -- 5,647.50 1,258.33 1,258.33 - 38.07 - 1,296.40 1192013 Water Works Colfax Ricoh Copier Copier Lease2013 N/A 2018 620 Monthly 16th -- -- 4,732.65 1,054.61 1,054.61 - 31.91 - 1,086.52 1202013 Water Works Olive Street Ricoh Copier Copier Lease2013 N/A 2018 620 Monthly 10th -- -- 4,732.65 1,054.61 1,054.61 - 31.91 - 1,086.52 1232014 Police Department Training Ricoh Copier Copier Lease2014 N/A 2019 101 Monthly 30th -- -- 4,263.00 1,186.17 941.47 - 42.53 244.70 984.00 1242014 Police & Public Works Vehicles Vehicles/Equipment2014 N/A 2019 Various 4/1 10/1 -- -- 1,959,485.95 801,993.28 397,900.73 - 10,895.81 404,092.55 408,796.54 1252014 HP Computer Lease #1 Computer Leases2014 N/A 2018 Various Monthly 8th -- -- 137,104.95 28,106.43 28,106.43 - 632.09 - 28,738.52 1262014 HP Computer Lease #2 Computer Leases2014 N/A 2018 Various Monthly 8th -- -- 4,000.00 915.42 915.42 - 22.56 - 937.98 1272014 HP Computer Lease #4 Computer Leases2014 N/A 2018 279 Monthly 8th -- -- 5,886.73 1,262.39 1,262.39 - 21.61 - 1,284.00 1282014 HP Computer Lease #6 Computer Leases2014 N/A 2018 201 Monthly 8th -- -- 3,755.50 959.08 959.08 - 23.80 - 982.88 1292014 HP Computer Lease #7 Computer Leases2014 N/A 2018 620 Monthly 8th -- -- 1,326.00 363.78 363.78 - 7.96 - 371.74 1302014 Solid Waste Ricoh Copier Copier Lease2014 N/A 2019 611 Monthly 17th -- -- 5,351.65 2,230.54 1,133.42 - 96.22 1,097.12 1,229.64 1312014 Police Communications Copier Copier Lease2014 N/A 2019 101 Monthly 12th -- -- 8,843.00 3,072.55 1,908.18 - 123.66 1,164.37 2,031.84 1322014 Ricoh Copiers Copier Lease2014 N/A 2019 641 Monthly 21st -- -- 12,260.16 4,044.71 2,657.97 - 159.05 1,386.74 2,817.02 1342014 Water Works Ricoh Copier Copier Lease2014 N/A 2019 620 Monthly 19th -- -- 4,732.65 1,139.81 1,048.77 - 36.75 91.04 1,085.52 1362015 HP Computer Lease #8 Computer Leases2015 N/A 2019 Various Monthly 16th -- -- 19,603.94 6,927.09 4,384.24 - 228.94 2,542.85 4,613.18 1372015 Animal Care & Control Ricoh Copier Copier Lease2015 N/A 2020 600 Monthly 30th -- -- 5,261.50 2,558.51 1,095.38 - 120.46 1,463.13 1,215.84 1382015 HP Computer Lease #9 Computer Leases2015 N/A 2019 Various Monthly -- -- -- 135,958.05 63,804.73 32,473.02 - 2,431.38 31,331.71 34,904.40 1402015 Vehicle/Equip Lease No. 1 Vehicles/Equipment2015 N/A 2020 Various 1/15 7/15 -- -- 3,425,273.58 2,087,121.85 686,127.96 - 26,537.40 1,400,993.89 712,665.36 1432015 HP Computer Lease #11 Computer Leases2015 N/A 2019 279 Monthly -- -- -- 3,040.00 1,465.29 728.78 - 52.66 736.51 781.44 1442015 Vehicle Lease No. 2 Vehicles/Equipment2015 N/A 2020 Various 5/15 11/15 -- -- 1,267,183.00 772,239.72 253,474.52 - 10,920.36 518,765.20 264,394.88 1462015 Ricoh Copier - Parks Copier Lease2015 N/A 2020 201 Monthly -- -- -- 4,302.06 2,644.67 857.61 - 129.03 1,787.06 986.64 1472016 Central Services - Print Shop Copier Copier Lease2016 N/A 2020 222 Monthly -- -- -- 32,525.00 22,620.32 6,374.04 - 1,041.72 16,246.28 7,415.76 1482016 Central Services - Print Shop Copier Copier Lease2016 N/A 2020 222 Monthly -- -- -- 11,413.00 7,937.47 2,236.63 - 365.57 5,700.84 2,602.20 1492016 Vehicle/Equip Lease No. 1 Vehicles/Equipment2016 N/A 2021 Various 2/15 8/15 -- -- 3,339,830.00 2,364,700.45 662,240.83 - 35,152.79 1,702,459.62 697,393.62 1502016 HP Computer Lease #12 Computer Leases2016 N/A 2020 Various Monthly -- -- -- 17,439.85 10,105.08 4,096.37 - 386.83 6,008.71 4,483.20 1512016 Administration & Finance Copier Copier Lease2016 N/A 2021 101 Monthly -- -- -- 10,923.63 6,891.18 2,167.29 - 337.95 4,723.89 2,505.24 1522016 Vehicle/Equip Lease No. 2 Vehicles/Equipment2016 N/A 2021 Various 1/14 7/14 -- -- 3,992,548.72 3,222,157.09 787,307.33 - 46,068.99 2,434,849.76 833,376.32 1532016 Vehicle/Equip Lease Amendment No. 1 Vehicles/Equipment2016 N/A 2021 201 1/17 7/17 -- -- 78,808.00 63,520.71 15,520.85 - 907.95 47,999.86 16,428.80 1542016 Vehicle/Equip Lease No. 3 Vehicles/Equipment2016 N/A 2021 Various 4/19 10/19 -- -- 1,256,096.99 1,012,026.89 247,371.35 - 14,237.21 764,655.54 261,608.56 1552016 HP Computer Lease #13 Computer Leases2016 N/A 2020 Various Monthly -- -- -- 156,029.30 116,995.36 35,245.46 - 4,936.18 81,749.90 40,181.64 1572016 Ricoh Copier MPC2003 Copier Lease2016 N/A 2021 201 Monthly -- -- 3,184.06 2,265.55 615.22 - 165.38 1,650.33 780.60 1582017 Vehicle/Equip Lease No. 1 Vehicles/Equipment2017 N/A 2022 Various 1/14 7/14 -- -- 2,916,500.00 2,916,500.00 547,141.56 - 73,158.44 2,369,358.44 620,300.00 1592017 Ricoh Copiers Lease Copier Lease2017 N/A 2021 Various Monthly -- -- -- 15,702.09 12,417.04 3,729.79 - 773.57 8,687.25 4,503.36 1602017 HP Computer Lease #14 Computer Leases2017 N/A 2021 Various Monthly -- -- -- 10,305.25 8,452.80 2,317.66 - 337.22 6,135.14 2,654.88 1622017 Vehicle/Equip Lease No. 2 Vehicles/Equipment2017 N/A 2022 404 2/15 8/15 -- -- 1,632,000.00 1,632,000.00 314,247.00 - 27,763.50 1,317,753.00 342,010.50 1642017 HP Computer Lease #16 Computer Leases2017 N/A 2021 Various Monthly 21st -- -- 108,921.75 101,278.63 23,670.40 - 4,316.12 77,608.23 27,986.52 1662018 Police Radio Equipment Lease Purchase Police Radio Equipment2018 N/A 2021 404 12/15 -- -- -- 2,400,000.00 - 600,000.00 2,400,000.00 - 1,800,000.00 600,000.00 1672017 HP Computer Lease #15 Computer Leases2018 N/A 2022 279 Monthly 25th -- -- 9,698.00 - 2,083.11 9,698.00 355.53 7,614.89 2,438.64 1702018 HP Computer Lease #17 Computer Leases2018 N/A 2023 279 Monthly 21st -- -- 9,092.00 - 1,292.30 9,092.00 255.70 7,799.70 1,548.00 1712018 Vehicle/Equip Lease #1 (PNC) Sched 1 Vehicles/Equipment2018 N/A 2023 Various 5/25 11/25 -- -- 5,898,310.11 - 551,593.38 5,898,310.11 87,324.48 5,346,716.73 638,917.86 1722018 AT&T Lease 1 Computer Equipment2018 N/A 2021 279 Monthly 1st -- -- 27,101.47 - 4,259.44 27,101.47 587.96 22,842.03 4,847.40 Total City Capital Lease Debt32,170,328.46 15,946,280.30 5,894,224.87 8,344,201.58 358,020.59 18,396,257.01 6,252,245.46 Bonds252002/2012 Refunding Water Works Improvements Various Water Department projects2002 2012 2023 625 1/1 7/1 - - 5,975,000.00 2,005,000.00 380,000.00 - 40,100.00 1,625,000.00 420,100.00 362001 Public Works Service Center (Bldg Corp) (87.7%) Public Works Service Center2001 2010 2021 324 2/1 8/1 - - 8,112,250.00 1,911,860.00 521,815.00 - 67,331.00 1,390,045.00 589,146.00 362001 Public Works Service Center (Bldg Corp) (12.3%) Public Works Service Center2001 2010 2021 641 2/1 8/1 - - 1,137,750.00 268,140.00 73,185.00 - 9,444.00 194,955.00 82,629.00 392012 Fire Station/Police Department Renovations (Bldg Corp) New Central Fire and Police buildings2003 2012 2023 324 2/1 8/1 - - 21,335,000.00 7,645,000.00 1,280,000.00 - 284,520.00 6,365,000.00 1,564,520.00 692009 Water Works Improvements, Series B Various Water Department projects2009 N/A 2030 625 1/1 7/1 - - 5,380,000.00 4,085,000.00 250,000.00 - 227,961.00 3,835,000.00 477,961.00 802010 Sewage Works Revenue Bonds Various Wastewater Department projects2010 N/A 2030 649 6/1 12/1 - - 9,345,000.00 6,750,000.00 405,000.00 - 282,817.50 6,345,000.00 687,817.50 932011 Sewage Works Revenue Bonds Wastewater Long Term Control Plan2011 N/A 2031 649 6/1 12/1 - - 21,500,000.00 16,400,000.00 920,000.00 - 627,450.00 15,480,000.00 1,547,450.00 992012 Water Works Revenue Bond Water Works Improvements2012 N/A 2033 625 1/1 7/1 -- -- 8,300,000.00 6,570,000.00 360,000.00 - 202,686.26 6,210,000.00 562,686.26 1012012 Sewage Works Revenue Bonds Wastewater Long Term Control Plan2012 N/A 2032 649 6/1 12/1 - - 25,000,000.00 19,830,000.00 1,075,000.00 - 465,480.00 18,755,000.00 1,540,480.00 1052013A Sewage Works Revenue Bonds Wastewater Long Term Control Plan2013 N/A 2024 649 6/1 12/1 - - 14,765,000.00 6,095,000.00 1,995,000.00 - 118,243.00 4,100,000.00 2,113,243.00 1162013 Building Corporation EMS Fire Station/Tower Bonds Fire Station #5 & Training Tower2013 N/A 2033 287 2/1 8/1 -- -- 5,580,000.00 4,920,000.00 225,000.00 - 170,730.00 4,695,000.00 395,730.00 1332014 St. Joseph County PSAP (EDIT) City's share of PSAP building2014 N/A 2034 408 Monthly Last -- -- 2,657,696.50 2,278,855.00 130,635.00 - 68,331.18 2,148,220.00 198,966.18 1412015 EDIT/Parks Bonds Parks Improvements2015 N/A 2035 408 2/1 8/1 -- -- 5,605,000.00 5,190,000.00 210,000.00 - 169,106.26 4,980,000.00 379,106.26 1452015 Sewage Works Refunding Bonds Sewer Bond Improvements2015 2015 2025 649 6/1 12/1 -- -- 27,440,000.00 22,435,000.00 2,585,000.00 - 448,700.00 19,850,000.00 3,033,700.00 1562016 Waterworks Refunding Bonds Water Bond Refunding2016 N/A 2027 625 1/1 7/1 -- -- 3,300,000.00 2,895,000.00 420,000.00 - 86,850.00 2,475,000.00 506,850.00 1612017 Economic Develop. Revenue Bonds (Studebaker Project) Façade Improvements - Buidling 842017 N/A 2018 324 One Time -- -- -- 3,500,000.00 3,500,000.00 3,500,000.00 - - - 3,500,000.00 1632017 Eddy Street Commons Phase II Eddy Street Commons Phase II2017 N/A 2037 436 2/15 8/15 -- -- 25,000,000.00 25,000,000.00 25,000.00 - 1,253,472.00 24,975,000.00 1,278,472.00 1652017 Park District Bonds, Series 2017A-K Projects to improve City parks2017 N/A 2033 312 1/15 7/15 -- -- 14,075,000.00 14,075,000.00 350,000.00 - 243,303.69 13,725,000.00 593,303.69 1682018 Fire Station #9 General Obligation Bonds New Fire St #9 and Fire Training Classroom2018 N/A 2038 287 1/15 7/15 -- -- 5,045,000.00 - 75,000.00 5,045,000.00 45,662.81 4,970,000.00 120,662.81 1692018 Redevelopment District Bonds, TIF Parks Bond Projects to improve City parks2018 N/A 2033 324 2/1 8/1 -- -- 11,995,000.00 - 405,000.00 11,995,000.00 91,320.00 11,590,000.00 496,320.00 Total City Bond Debt225,047,696.50 151,853,855.00 15,185,635.00 17,040,000.00 4,903,508.70 153,708,220.00 20,089,143.70 Interfund Loan822010 Interfund Fund 404 to UDAG Fund 410 1st Source Bank/Marriott Garage Project2010 N/A 2026 410 6/15 12/15 - - 2,700,000.00 966,334.50 132,618.30 - - 833,716.20 132,618.30 842011/2013 Major Moves-Triangle Development Interfund Loan Triangle Development Infrastructure2011 2011/2013 2029 436 2/15 8/15 - - 1,558,050.00 1,234,877.14 96,675.43 - 24,216.57 1,138,201.71 120,892.00 852011/2013 Major Moves-Eddy Street Commons Interfund Loan Triangle Development Infrastructure2011 2011/2013 2026 436 2/15 8/15 - - 3,942,529.00 1,922,964.03 279,741.40 - 92,694.60 1,643,222.63 372,436.00 1422016 Interfund Fund 412 to Parking Garage Fund 601 Parking Garage Improvements2016 N/A 2022 601 June Dec -- -- 1,511,331.00 31,191.33 31,191.33 - - - 31,191.33 Total City Interfund Loan Debt9,711,910.00 4,155,367.00 540,226.46 - 116,911.17 3,615,140.54 657,137.63 Debt at12/31/182018 TotalDebt PaymentsScheduled PaymentsDebtSched.Period Ending: June 30, 2018Debt Instrument Debt PurposeYear ofIssueYear ofRefinanceYear ofMaturityFundNo.AmountIssuedDebt at12/31/172018 PrincipalPayments2018 InterestPaymentsCity of South BendOutstanding Debt2018AdditionsMonthly Financial Report16 of 24 1st 2nd 3rd 4thDebt at12/31/182018 TotalDebt PaymentsScheduled PaymentsDebtSched.Period Ending: June 30, 2018Debt Instrument Debt PurposeYear ofIssueYear ofRefinanceYear ofMaturityFundNo.AmountIssuedDebt at12/31/172018 PrincipalPayments2018 InterestPaymentsCity of South BendOutstanding Debt2018AdditionsLoan Payable682009 Water Works Improvements - State Revolving Fund Various Water Department projects2009 N/A 2030 625 1/1 7/1 - - 427,400.00 311,650.00 21,617.00 - 10,502.60 290,033.00 32,119.60 702009 Sewage Works Revenue Bonds - State Revolving Fund Various Wastewater Department projects2009 N/A 2028 649 6/1 12/1 - - 3,297,000.00 2,087,171.00 167,038.00 - 58,650.00 1,920,133.00 225,688.00 1222014 Synagogue Installment Purchase Agreement Improvements at Synagogue - Coveleski 2014 N/A 2018 377 Annual 1/31 -- -- 500,000.00 100,000.00 100,000.00 - - - 100,000.00 1392015 Century Center Energy QECB Conservation Bond Imrovements at Century Center2015 N/A 2031 672 5/1 11/1 -- -- 4,167,897.00 4,098,706.00 162,702.00 - 143,034.35 3,936,004.00 305,736.35 Total City Loan Payable Debt8,392,297.00 6,597,527.00 451,357.00 - 212,186.95 6,146,170.00 663,543.95 Total Civil City Debt275,322,231.96 178,553,029.30 22,071,443.33 25,384,201.58 5,590,627.41 181,865,787.55 27,662,070.74 Redevelopment Commission DebtCapital Leases132006 Main/Colfax Garage - Transpo Lease Real Estate Purchase2006 N/A 2025 324 3/15 9/15 - - 2,510,278.00 1,305,501.00 136,409.00 - 63,591.00 1,169,092.00 200,000.00 Total Redevelopment Capital Lease Debt2,510,278.00 1,305,501.00 136,409.00 - 63,591.00 1,169,092.00 200,000.00 Interfund Loans862010 Interfund Fund 209 to Airport TIF Fund 324 Prairie Avenue - Brownfields Cleanup Loan2011 N/A 2020 324 8/9 -- - - 500,000.00 300,000.00 100,000.00 - - 200,000.00 100,000.00 Total Redevelopment Interfund Loan Debt500,000.00 300,000.00 100,000.00 - - 200,000.00 100,000.00 Loans Payable32001 Indiana Development Finance Authority (Bosch) - Nonforgivable Rehabilitate Property2001 N/A 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 238,409.07 65,591.47 - 6,418.97 172,817.60 72,010.44 42001 Indiana Development Finance Authority (Bosch) - ForgivableRehabilitate Property2001 N/A 2021 210----260,000.00 65,888.51 - - - 65,888.51 - Total Redevelopment Loan Payable Debt1,300,000.00 304,297.58 65,591.47 - 6,418.97 238,706.11 72,010.44 Revenue Bonds52011 South Bend Downtown Central Development Area TIF Public Improvements2003 2011 2024 420/324 2/1 8/1 - - 19,795,000.00 11,185,000.00 1,375,000.00 - 537,541.00 9,810,000.00 1,912,541.00 62011 Airport Development Area TIF Public Improvements2003 2011 2024 324 2/1 8/1 - - 14,420,000.00 6,375,000.00 790,000.00 - 306,305.50 5,585,000.00 1,096,305.50 72011 Century Center Lease Rental Revenue Rehabilitation of a convention center1994 2001, 2011 2018 404/407 2/1 8/1 - - 6,825,000.00 245,000.00 245,000.00 - 3,675.00 - 248,675.00 82011 College Football Hall of Fame Construction Construction of a building1994 2000, 2011 2018 313 2/1 8/1 - - 15,370,000.00 620,000.00 620,000.00 - 11,315.00 - 631,315.00 122002 TJX Special Taxing District (Refunded 2014) Public Improvements2002 2014 2022 324 1/1 7/1 - - 6,620,000.00 1,795,000.00 430,000.00 - 53,850.00 1,365,000.00 483,850.00 542015/2008 Eddy Street Commons - Lease Rental Revenue Bonds Parking Garage/Public Improvements2008 N/A 2027 436 2/15 8/15 - - 36,000,000.00 28,760,000.00 1,360,000.00 - 1,108,431.26 27,400,000.00 2,468,431.26 622008 2013 Century Center Special Tax Bonds Century Center Improvements2008 2013 2026 324 4/15 10/15 - - 4,655,000.00 2,875,000.00 310,000.00 - 76,712.50 2,565,000.00 386,712.50 812010 Coveleski Stadium Recovery Zone Econ. Develop. Bonds Coveleski Stadium Area Expansion/Improve2010 N/A 2019 377 1/15 7/15 - - 4,980,000.00 1,015,000.00 670,000.00 - 44,070.00 345,000.00 714,070.00 1352015 Redevelopment Authority Smart Streets Bonds Smart Streets Improvements2015 N/A 2037 324 8/1 2/1 -- -- 25,000,000.00 24,540,000.00 940,000.00 - 768,793.76 23,600,000.00 1,708,793.76 Total Redevelopment Revenue Bond Debt133,665,000.00 77,410,000.00 6,740,000.00 - 2,910,694.02 70,670,000.00 9,650,694.02 Total Redevelopment Commission Debt137,975,278.00 79,319,798.58 7,042,000.47 - 2,980,703.99 72,277,798.11 10,022,704.46 Total Debt413,297,509.96 257,872,827.88 29,113,443.80 25,384,201.58 8,571,331.40 254,143,585.66 37,684,775.20 Monthly Financial Report17 of 24 1st 2nd 3rd 4thCivil City DebtCapital Leases1102013 PNC Vehicle & Equipment Lease Vehicles/Equipment2013 N/A 2018 Various 1/15 7/15 -- -- 1,689,669.59 346,724.77 172,835.24 - 2,115.02 173,889.53 174,950.26 1122013 Building Department Ricoh Copier Copier Lease2013 N/A 2018 600 Monthly 26th -- -- 4,093.64 613.22 457.78 - 11.72 155.44 469.50 1132013 Suntrust Vehicle Lease Vehicles/Equipment2013 N/A 2018 Various 4/24 10/24 -- -- 1,506,465.26 310,880.69 154,826.84 - 2,463.73 156,053.85 157,290.57 1142013 Administration & Finance Ricoh Copier Copier Lease2013 N/A 2018 101 1/16 4/16 7/16 10/16 11,247.97 634.57 1,276.39 - 9.23 (641.82) 1,285.62 1172013 Police Department Records Division Ricoh Copier Copier Lease2013 N/A 2018 101 Monthly 3rd -- -- 9,678.26 2,154.91 1,067.50 - 42.50 1,087.41 1,110.00 1182013 Water Works Main Street Ricoh Copier Copier Lease2013 N/A 2018 620 Monthly 10th -- -- 5,647.50 1,258.33 619.99 - 27.71 638.34 647.70 1192013 Water Works Colfax Ricoh Copier Copier Lease2013 N/A 2018 620 Monthly 16th -- -- 4,732.65 1,054.61 519.55 - 23.21 535.06 542.76 1202013 Water Works Olive Street Ricoh Copier Copier Lease2013 N/A 2018 620 Monthly 10th -- -- 4,732.65 1,054.61 519.55 - 23.21 535.06 542.76 1232014 Police Department Training Ricoh Copier Copier Lease2014 N/A 2019 101 Monthly 30th -- -- 4,263.00 1,186.17 464.16 - 27.84 722.01 492.00 1242014 Police & Public Works Vehicles Vehicles/Equipment2014 N/A 2019 Various 4/1 10/1 -- -- 1,959,485.95 801,993.28 198,182.35 - 6,215.92 603,810.93 204,398.27 1252014 HP Computer Lease #1 Computer Leases2014 N/A 2018 Various Monthly 8th -- -- 137,104.95 28,106.43 14,088.36 - 421.79 14,018.07 14,510.15 1262014 HP Computer Lease #2 Computer Leases2014 N/A 2018 Various Monthly 8th -- -- 4,000.00 915.42 350.72 - 14.48 564.70 365.20 1272014 HP Computer Lease #4 Computer Leases2014 N/A 2018 279 Monthly 8th -- -- 5,886.73 1,262.39 606.90 - 16.45 655.49 623.35 1282014 HP Computer Lease #6 Computer Leases2014 N/A 2018 201 Monthly 8th -- -- 3,755.50 959.08 382.45 - 16.35 576.63 398.80 1292014 HP Computer Lease #7 Computer Leases2014 N/A 2018 620 Monthly 8th -- -- 1,326.00 363.78 162.79 - 5.63 200.99 168.42 1302014 Solid Waste Ricoh Copier Copier Lease2014 N/A 2019 611 Monthly 17th -- -- 5,351.65 2,230.54 558.79 - 56.03 1,671.75 614.82 1312014 Police Communications Copier Copier Lease2014 N/A 2019 101 Monthly 12th -- -- 8,843.00 3,072.55 940.75 - 75.17 2,131.80 1,015.92 1322014 Ricoh Copiers Copier Lease2014 N/A 2019 641 Monthly 21st -- -- 12,260.16 4,044.71 1,310.40 - 98.09 2,734.31 1,408.49 1342014 Water Works Ricoh Copier Copier Lease2014 N/A 2019 620 Monthly 19th -- -- 4,732.65 1,139.81 517.16 - 25.60 622.65 542.76 1362015 HP Computer Lease #8 Computer Leases2015 N/A 2019 Various Monthly 16th -- -- 19,603.94 6,927.09 2,366.30 - 129.13 4,560.79 2,495.43 1372015 Animal Care & Control Ricoh Copier Copier Lease2015 N/A 2020 600 Monthly 30th -- -- 5,261.50 2,558.51 448.23 - 149.98 2,110.28 598.21 1382015 HP Computer Lease #9 Computer Leases2015 N/A 2019 Various Monthly -- -- -- 135,958.05 63,804.73 16,035.75 - 1,416.45 47,768.98 17,452.20 1402015 Vehicle/Equip Lease No. 1 Vehicles/Equipment2015 N/A 2020 Various 1/15 7/15 -- -- 3,425,273.58 2,087,121.85 341,880.30 - 14,452.38 1,745,241.55 356,332.68 1432015 HP Computer Lease #11 Computer Leases2015 N/A 2019 279 Monthly -- -- -- 3,040.00 1,465.29 299.56 - 26.04 1,165.73 325.60 1442015 Vehicle Lease No. 2 Vehicles/Equipment2015 N/A 2020 Various 5/15 11/15 -- -- 1,267,183.00 772,239.72 126,251.19 - 5,946.25 645,988.53 132,197.44 1462015 Ricoh Copier - Parks Copier Lease2015 N/A 2020 201 Monthly -- -- -- 4,302.06 2,644.67 422.69 - 70.63 2,221.98 493.32 1472016 Central Services - Print Shop Copier Copier Lease2016 N/A 2020 222 Monthly -- -- -- 32,525.00 22,620.32 3,158.88 - 549.00 19,461.44 3,707.88 1482016 Central Services - Print Shop Copier Copier Lease2016 N/A 2020 222 Monthly -- -- -- 11,413.00 7,937.47 1,108.44 - 192.66 6,829.03 1,301.10 1492016 Vehicle/Equip Lease No. 1 Vehicles/Equipment2016 N/A 2021 Various 2/15 8/15 -- -- 3,339,830.00 2,364,700.45 324,595.10 - 24,101.71 2,040,105.35 348,696.81 1502016 HP Computer Lease #12 Computer Leases2016 N/A 2020 Various Monthly -- -- -- 17,439.85 10,105.08 2,024.20 - 217.40 8,080.88 2,241.60 1512016 Administration & Finance Copier Copier Lease2016 N/A 2021 101 Monthly -- -- -- 10,923.63 6,891.18 1,067.34 - 185.28 5,823.84 1,252.62 1522016 Vehicle/Equip Lease No. 2 Vehicles/Equipment2016 N/A 2021 Various 1/14 7/14 -- -- 3,992,548.72 3,222,157.09 392,161.10 - 24,527.06 2,829,995.99 416,688.16 1532016 Vehicle/Equip Lease Amendment No. 1 Vehicles/Equipment2016 N/A 2021 201 1/17 7/17 -- -- 78,808.00 63,520.71 7,731.01 - 483.39 55,789.70 8,214.40 1542016 Vehicle/Equip Lease No. 3 Vehicles/Equipment2016 N/A 2021 Various 4/19 10/19 -- -- 1,256,096.99 1,012,026.89 123,224.20 - 7,580.08 888,802.69 130,804.28 1552016 HP Computer Lease #13 Computer Leases2016 N/A 2020 Various Monthly -- -- -- 156,029.30 116,995.36 17,337.21 - 2,753.61 99,658.15 20,090.82 1572016 Ricoh Copier MPC2003 Copier Lease2016 N/A 2021 201 Monthly -- -- 3,184.06 2,265.55 301.23 - 89.07 1,964.32 390.30 1582017 Vehicle/Equip Lease No. 1 Vehicles/Equipment2017 N/A 2022 Various 1/14 7/14 -- -- 2,916,500.00 2,916,500.00 264,479.61 - 45,670.39 2,652,020.39 310,150.00 1592017 Ricoh Copiers Lease Copier Lease2017 N/A 2021 Various Monthly -- -- -- 15,702.09 12,417.04 1,831.39 - 420.29 10,585.65 2,251.68 1602017 HP Computer Lease #14 Computer Leases2017 N/A 2021 Various Monthly -- -- -- 10,305.25 8,452.80 1,150.01 - 177.43 7,302.79 1,327.44 1622017 Vehicle/Equip Lease No. 2 Vehicles/Equipment2017 N/A 2022 404 2/15 8/15 -- -- 1,632,000.00 1,632,000.00 156,582.83 - 15,422.42 1,475,417.17 172,005.25 1642017 HP Computer Lease #16 Computer Leases2017 N/A 2021 Various Monthly 21st -- -- 108,921.75 101,278.63 13,670.67 - 2,654.80 87,607.96 16,325.47 1662018 Police Radio Equipment Lease Purchase Police Radio Equipment2018 N/A 2021 404 12/15 -- -- -- 2,400,000.00 - - 2,400,000.00 - 2,400,000.00 - 1672017 HP Computer Lease #15 Computer Leases2018 N/A 2022 279 Monthly 25th -- -- 9,698.00 - 1,030.99 9,698.00 188.33 8,667.01 1,219.32 1702018 HP Computer Lease #17 Computer Leases2018 N/A 2023 279 Monthly 21st -- -- 9,092.00 - 319.46 9,092.00 67.54 8,772.54 387.00 1712018 Vehicle/Equip Lease #1 (PNC) Sched 1 Vehicles/Equipment2018 N/A 2023 Various 5/25 11/25 -- -- 5,898,310.11 - - 5,898,310.11 - 5,898,310.11 - 1722018 AT&T Lease 1 Computer Equipment2018 N/A 2021 279 Monthly 1st -- -- 27,101.47 - - 27,101.47 - 27,101.47 - Total City Capital Lease Debt32,170,328.46 15,946,280.30 2,349,165.36 8,344,201.58 159,161.00 21,941,316.52 2,508,326.36 Bonds252002/2012 Refunding Water Works Improvements Various Water Department projects2002 2012 2023 625 1/1 7/1 - - 5,975,000.00 2,005,000.00 - - 19,966.67 2,005,000.00 19,966.67 362001 Public Works Service Center (Bldg Corp) (87.7%) Public Works Service Center2001 2010 2021 324 2/1 8/1 - - 8,112,250.00 1,911,860.00 259,600.00 - 36,052.50 1,652,260.00 295,652.50 362001 Public Works Service Center (Bldg Corp) (12.3%) Public Works Service Center2001 2010 2021 641 2/1 8/1 - - 1,137,750.00 268,140.00 35,400.00 - 4,916.25 232,740.00 40,316.25 392012 Fire Station/Police Department Renovations (Bldg Corp) New Central Fire and Police buildings2003 2012 2023 324 2/1 8/1 - - 21,335,000.00 7,645,000.00 635,000.00 - 150,000.00 7,010,000.00 785,000.00 692009 Water Works Improvements, Series B Various Water Department projects2009 N/A 2030 625 1/1 7/1 - - 5,380,000.00 4,085,000.00 - - 113,980.50 4,085,000.00 113,980.50 802010 Sewage Works Revenue Bonds Various Wastewater Department projects2010 N/A 2030 649 6/1 12/1 - - 9,345,000.00 6,750,000.00 - - 141,408.75 6,750,000.00 141,408.75 932011 Sewage Works Revenue Bonds Wastewater Long Term Control Plan2011 N/A 2031 649 6/1 12/1 - - 21,500,000.00 16,400,000.00 - - 313,725.00 16,400,000.00 313,725.00 992012 Water Works Revenue Bond Water Works Improvements2012 N/A 2033 625 1/1 7/1 -- -- 8,300,000.00 6,570,000.00 - - 101,343.13 6,570,000.00 101,343.13 1012012 Sewage Works Revenue Bonds Wastewater Long Term Control Plan2012 N/A 2032 649 6/1 12/1 - - 25,000,000.00 19,830,000.00 - - 232,740.00 19,830,000.00 232,740.00 1052013A Sewage Works Revenue Bonds Wastewater Long Term Control Plan2013 N/A 2024 649 6/1 12/1 - - 14,765,000.00 6,095,000.00 - - 58,910.80 6,095,000.00 58,910.80 1162013 Building Corporation EMS Fire Station/Tower Bonds Fire Station #5 & Training Tower2013 N/A 2033 287 2/1 8/1 -- -- 5,580,000.00 4,920,000.00 112,500.00 - 88,750.00 4,807,500.00 201,250.00 1332014 St. Joseph County PSAP (EDIT) City's share of PSAP building2014 N/A 2034 408 Monthly Last -- -- 2,657,696.50 2,278,855.00 - - - 2,278,855.00 - 1412015 EDIT/Parks Bonds Parks Improvements2015 N/A 2035 408 2/1 8/1 -- -- 5,605,000.00 5,190,000.00 105,000.00 - 85,340.63 5,085,000.00 190,340.63 1452015 Sewage Works Refunding Bonds Sewer Bond Improvements2015 2015 2025 649 6/1 12/1 -- -- 27,440,000.00 22,435,000.00 - - 224,350.00 22,435,000.00 224,350.00 1562016 Waterworks Refunding Bonds Water Bond Refunding2016 N/A 2027 625 1/1 7/1 -- -- 3,300,000.00 2,895,000.00 - - 43,425.00 2,895,000.00 43,425.00 1612017 Economic Develop. Revenue Bonds (Studebaker Project) Façade Improvements - Buidling 842017 N/A 2018 324 One Time -- -- -- 3,500,000.00 3,500,000.00 - - - 3,500,000.00 - 1632017 Eddy Street Commons Phase II Eddy Street Commons Phase II2017 N/A 2037 436 2/15 8/15 -- -- 25,000,000.00 25,000,000.00 - - 628,472.19 25,000,000.00 628,472.19 1652017 Park District Bonds, Series 2017A-K Projects to improve City parks2017 N/A 2033 312 1/15 7/15 -- -- 14,075,000.00 14,075,000.00 - - - 14,075,000.00 - 1682018 Fire Station #9 General Obligation Bonds New Fire St #9 and Fire Training Classroom2018 N/A 2038 287 1/15 7/15 -- -- 5,045,000.00 - - 5,045,000.00 - 5,045,000.00 - 1692018 Redevelopment District Bonds, TIF Parks Bond Projects to improve City parks2018 N/A 2033 324 2/1 8/1 -- -- 11,995,000.00 - - 11,995,000.00 - 11,995,000.00 - Total City Bond Debt225,047,696.50 151,853,855.00 1,147,500.00 17,040,000.00 2,243,381.42 167,746,355.00 3,390,881.42 Interfund Loan822010 Interfund Fund 404 to UDAG Fund 410 1st Source Bank/Marriott Garage Project2010 N/A 2026 410 6/15 12/15 - - 2,700,000.00 966,334.50 65,415.10 - - 900,919.40 65,415.10 842011/2013 Major Moves-Triangle Development Interfund Loan Triangle Development Infrastructure2011 2011/2013 2029 436 2/15 8/15 - - 1,558,050.00 1,234,877.14 48,097.23 - 12,348.77 1,186,779.91 60,446.00 852011/2013 Major Moves-Eddy Street Commons Interfund Loan Triangle Development Infrastructure2011 2011/2013 2026 436 2/15 8/15 - - 3,942,529.00 1,922,964.03 138,143.90 - 48,074.10 1,784,820.13 186,218.00 1422016 Interfund Fund 412 to Parking Garage Fund 601 Parking Garage Improvements2016 N/A 2022 601 June Dec -- -- 1,511,331.00 31,191.33 - - - 31,191.33 - Total City Interfund Loan Debt9,711,910.00 4,155,367.00 251,656.23 - 60,422.87 3,903,710.77 312,079.10 Scheduled PaymentsAmountIssuedDebt at12/31/17YTD PrincipalPayments2018AdditionsYTD InterestPaymentsCity of South BendPeriod Ending: June 30, 2018Debt Payments Year-to-DateDebtSched.Debt Instrument Debt PurposeYear ofIssueYear ofRefinanceYear ofMaturityFundNo.Debt at06/30/18Total YTDDebt PaymentsMonthly Financial Report18 of 24 1st 2nd 3rd 4thScheduled PaymentsAmountIssuedDebt at12/31/17YTD PrincipalPayments2018AdditionsYTD InterestPaymentsCity of South BendPeriod Ending: June 30, 2018Debt Payments Year-to-DateDebtSched.Debt Instrument Debt PurposeYear ofIssueYear ofRefinanceYear ofMaturityFundNo.Debt at06/30/18Total YTDDebt PaymentsLoan Payable682009 Water Works Improvements - State Revolving Fund Various Water Department projects2009 N/A 2030 625 1/1 7/1 - - 427,400.00 311,650.00 - - 5,251.30 311,650.00 5,251.30 702009 Sewage Works Revenue Bonds - State Revolving Fund Various Wastewater Department projects2009 N/A 2028 649 6/1 12/1 - - 3,297,000.00 2,087,171.00 - - 29,766.46 2,087,171.00 29,766.46 1222014 Synagogue Installment Purchase Agreement Improvements at Synagogue - Coveleski 2014 N/A 2018 377 Annual 1/31 -- -- 500,000.00 100,000.00 - - - 100,000.00 - 1392015 Century Center Energy QECB Conservation Bond Imrovements at Century Center2015 N/A 2031 672 5/1 11/1 -- -- 4,167,897.00 4,098,706.00 24,021.00 - 71,727.36 4,074,685.00 95,748.36 Total City Loan Payable Debt8,392,297.00 6,597,527.00 24,021.00 - 106,745.12 6,573,506.00 130,766.12 Total Civil City Debt275,322,231.96 178,553,029.30 3,772,342.59 25,384,201.58 2,569,710.41 200,164,888.29 6,342,053.00 Redevelopment Commission DebtCapital Leases132006 Main/Colfax Garage - Transpo Lease Real Estate Purchase2006 N/A 2025 324 3/15 9/15 - - 2,510,278.00 1,305,501.00 67,362.00 - 32,638.00 1,238,139.00 100,000.00 Total Redevelopment Capital Lease Debt2,510,278.00 1,305,501.00 67,362.00 - 32,638.00 1,238,139.00 100,000.00 Interfund Loans862010 Interfund Fund 209 to Airport TIF Fund 324 Prairie Avenue - Brownfields Cleanup Loan2011 N/A 2020 324 8/9 -- - - 500,000.00 300,000.00 - - - 300,000.00 - Total Redevelopment Interfund Loan Debt500,000.00 300,000.00 - - - 300,000.00 - Loans Payable32001 Indiana Development Finance Authority (Bosch) - Nonforgivable Rehabilitate Property2001 N/A 2021 210 3/22 6/229/22 12/22 1,040,000.00 238,409.07 32,550.69 - 3,454.53 205,858.38 36,005.22 42001 Indiana Development Finance Authority (Bosch) - ForgivableRehabilitate Property2001 N/A 2021 210----260,000.00 65,888.51 - - - 65,888.51 - Total Redevelopment Loan Payable Debt1,300,000.00 304,297.58 32,550.69 - 3,454.53 271,746.89 36,005.22 Revenue Bonds52011 South Bend Downtown Central Development Area TIF Public Improvements2003 2011 2024 420/324 2/1 8/1 - - 19,795,000.00 11,185,000.00 680,000.00 - 276,641.50 10,505,000.00 956,641.50 62011 Airport Development Area TIF Public Improvements2003 2011 2024 324 2/1 8/1 - - 14,420,000.00 6,375,000.00 390,000.00 - 157,666.75 5,985,000.00 547,666.75 72011 Century Center Lease Rental Revenue Rehabilitation of a convention center1994 2001, 2011 2018 404/407 2/1 8/1 - - 6,825,000.00 245,000.00 245,000.00 - 4,500.00 - 249,500.00 82011 College Football Hall of Fame Construction Construction of a building1994 2000, 2011 2018 313 2/1 8/1 - - 15,370,000.00 620,000.00 620,000.00 - 13,000.00 - 633,000.00 122002 TJX Special Taxing District (Refunded 2014) Public Improvements2002 2014 2022 324 1/1 7/1 - - 6,620,000.00 1,795,000.00 - - 26,925.00 1,795,000.00 26,925.00 542015/2008 Eddy Street Commons - Lease Rental Revenue Bonds Parking Garage/Public Improvements2008 N/A 2027 436 2/15 8/15 - - 36,000,000.00 28,760,000.00 675,000.00 - 559,500.00 28,085,000.00 1,234,500.00 622008 2013 Century Center Special Tax Bonds Century Center Improvements2008 2013 2026 324 4/15 10/15 - - 4,655,000.00 2,875,000.00 310,000.00 - 39,906.25 2,565,000.00 349,906.25 812010 Coveleski Stadium Recovery Zone Econ. Develop. Bonds Coveleski Stadium Area Expansion/Improve2010 N/A 2019 377 1/15 7/15 - - 4,980,000.00 1,015,000.00 335,000.00 - 26,390.00 680,000.00 361,390.00 1352015 Redevelopment Authority Smart Streets Bonds Smart Streets Improvements2015 N/A 2037 324 8/1 2/1 -- -- 25,000,000.00 24,540,000.00 465,000.00 - 387,884.38 24,075,000.00 852,884.38 Total Redevelopment Revenue Bond Debt133,665,000.00 77,410,000.00 3,720,000.00 - 1,492,413.88 73,690,000.00 5,212,413.88 Total Redevelopment Commission Debt137,975,278.00 79,319,798.58 3,819,912.69 - 1,528,506.41 75,499,885.89 5,348,419.10 Total Debt413,297,509.96 257,872,827.88 7,592,255.28 25,384,201.58 4,098,216.82 275,664,774.18 11,690,472.10 Monthly Financial Report19 of 24 City of South BendStaffing HeadcountFull-Time Staffing Summary by FundBudgetJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec101 - General Fund101-0101 Mayor's Office 7 7 7 7 7 7 7 101-0201 City Clerk 5 5 5 5 5 5 5 101-0301 Common Council 9 9 9 9 9 8 9 101-0401 Administration & Finance 24 21 22 24 24 22 23 101-0404 Morris PAC 7 7 7 7 7 7 7 101-0405 Palais Royale 2 2 2 2 2 2 2 101-0501 Legal Dept 10 10 9 9 10 10 10 101-0602 Engineering Dept 21 22 22 22 22 22 22 101-0801 Police Dept 248 242 242 244 243 243 243 101-0901 Fire Dept 178 184 184 186 186 184 182 101-1008 Human Rights 4 4 4 4 4 4 4 515 513 513 519 519 514 514 - - - - - - 201 - Parks & Recreation201-1100 Administration 6 7 7 7 7 6 6 201-1101 Maintenance 47 49 49 48 48 48 48 201-1102 Golf Courses 8 8 8 8 8 8 8 201-1103 Recreation 21 21 21 20 19 21 21 201-1104 Potawatomi Zoo 1 1 1 1 1 1 - 201-1108 Graffiti Removal 1 1 1 1 1 1 1 201-1110 Marketing & Events 11 10 10 10 11 11 11 95 97 97 95 95 96 95 - - - - - - 202 - Motor Vehicle Highway202-0607 Street Department 51 48 47 46 45 48 49 202-0619 Curb & Sidewalk Program 5 5 5 5 5 5 5 56 53 52 51 50 53 54 - - - - - - 203 - Recreation Non-Reverting203-1103 Recreation1 - - 1 1 1 1 211 - Dept of Community Investment Administration211-1001 DCI25 24 24 25 25 25 25 219 - Unsafe Building219-1209 NEAT Crew4 4 4 4 4 2 3 222 - Central Services222-0605 Equipment Services 32 28 28 27 26 27 25 222-0606 Building Maintenance 3 3 3 3 3 3 3 222-0612 Central Stores 2 4 4 4 4 4 4 222-0613 Print Shop 1 1 1 1 1 1 1 222-0614 Radio Shop 3 3 3 3 3 3 3 222-0616 Office of Sustainability 2 2 2 2 2 2 2 43 41 41 40 39 40 38 - - - - - - 226 - Liability Insurance226-0403 Safety & Risk 2 2 2 2 2 2 2 226-0412 Liability Insurance 1 1 1 1 1 1 13 3 3 3 3 3 3 - - - - - - Period Ending: June 30, 2018Monthly Financial Report20 of 24 City of South BendStaffing HeadcountPeriod Ending: June 30, 2018Full-Time Staffing Summary by FundBudgetJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec249 - Public Safety LOIT249-0805 Police Department 43 43 43 43 43 42 42 249-0905 Fire Department 35 35 35 34 34 34 34 78 78 78 77 77 76 76 - - - - - - 258 - Human Rights Grants258-1009 HUD1 1 1 1 1 1 1 279 - IT / Innovation / 311 Call Center279-0104 311 Call Center 7 7 7 7 7 7 7 279-0672 Innovation & Technology 20 17 17 19 19 19 19 27 24 24 26 26 26 26 - - - - - - 288 - Emergency Medical Services288-0902 EMS51 48 48 48 47 46 46 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce. 16 16 16 16 16 16 16 600-1207 Animal Care & Control 8 8 8 8 8 7 8 600-1208 Rental Unit Inspection 2 - - - - 2 2 600-1306 Building Department 15 13 13 14 14 14 14 41 37 37 38 38 39 40 - - - - - - 610 - Solid Waste610-0610 Solid Waste24 22 22 23 24 23 20 620 - Water Works O&M620-0640 Water Works67 66 66 66 66 65 61 640 - Sewer Insurance640-0620 Sewer Repair2 2 2 2 2 2 2 641 - Sewage Works O&M 641-0621 Sewer Department 35 35 35 35 35 34 34 641-0625 Concrete Crew 3 3 3 3 3 3 2 641-0630 Wastewater Department 46 44 45 43 43 43 43 641-0631 Organic Resources 6 6 6 6 6 6 6 90 88 89 87 87 86 85 - - - - - - 670 - Century Center670-0406 Century Center7 - - 6 6 7 7 Total Full-Time Employees by Fund1,130 1,101 1,101 1,112 1,110 1,105 1,097 - - - - - - Monthly Financial Report21 of 24 City of South BendStaffing HeadcountPeriod Ending: June 30, 2018Full-Time Staffing Summary by ActivityBudgetJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecGeneral GovernmentMayor's Office 7 7 7 7 7 7 7 City Clerk 5 5 5 5 5 5 5 Common Council 9 9 9 9 9 8 9 Administration & Finance 24 21 22 24 24 22 23 Legal Dept 10 10 9 9 10 10 10 55 52 52 54 55 52 54 - - - - - - Code Enforcement / Animal Care & Control30 28 28 28 28 27 29 - - - - - - Dept. of Community Investment25 24 24 25 25 25 25 - - - - - - Venues, Parks & ArtsParks & Recreation 96 97 97 96 96 97 96 Morris PAC & Palais Royale 9 9 9 9 9 9 9 Century Center 7 - - 6 6 7 7 112 106 106 111 111 113 112 - - - - - - Public SafetyPolice - Sworn Officers 248 241 241 230 229 228 239 Police - Civilians 43 44 44 49 49 49 44 Police - Police Recruit - - - 8 8 8 2 Fire/EMS - Sworn Firefighters 257 260 260 254 253 250 248 Fire/EMS - Civilians 7 7 7 7 7 7 7 Fire/EMS - Fire Recruits - - - 7 7 7 7 555 552 552 555 553 549 547 - - - - - - Public WorksOffice of Sustainability 2 2 2 2 2 2 2 Engineering Dept 21 22 22 22 22 22 22 Streets & Sewers 96 93 92 91 90 92 92 Solid Waste 24 22 22 23 24 23 20 Wastewater Department 46 44 45 43 43 43 43 Organic Resources 6 6 6 6 6 6 6 Water Works 67 66 66 66 66 65 61 262 255 255 253 253 253 246 - - - - - - Liability Insurance/Safety & Risk3 3 3 3 3 3 3 - - - - - - Innovation & Technology / 311 Call Center27 24 24 26 26 26 26 - - - - - - Central Services 41 39 39 38 37 38 36 - - - - - - Building Department15 13 13 14 14 14 14 - - - - - - Human Rights 5 5 5 5 5 5 5 - - - - - - Total Full-Time Employees by Activity1,130 1,101 1,101 1,112 1,110 1,105 1,097 - - - - - - Monthly Financial Report22 of 24 City of South BendStaffing HeadcountPeriod Ending: June 30, 2018Part-Time Staffing Summary by FundJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec101 - General Fund101-0101 Mayor's Office - - 1 1 1 1 101-0401 Admin & Finance - - 1 1 1 1 101-0404 Morris PAC 3 3 4 4 4 4 101-0501 Legal Dept 2 2 1 1 2 1 101-0602 Engineering Dept 4 4 4 4 3 3 101-0801 Police Dept 25 25 22 26 25 5 34 34 33 37 36 15 - - - - - - 201 - Parks & Recreation201-1100 Administration 1 1 1 1 1 1 201-1101 Maintenance 7 7 9 9 10 9 201-1102 Golf Courses - - 32 38 47 50 201-1103 Recreation 18 18 21 20 27 28 201-1108 Graffiti Removal 1 1 - - - - 27 27 63 68 85 88 - - - - - - 202 - Motor Vehicle Highway202-0607 Street Department4 4 4 5 5 5 203 - Recreation Non-Reverting203-1103 Recreation25 25 19 21 21 21 211 - Dept of Community Investment Administration211-1001 DCI1 - - - - - 222 - Central Services222-0605 Equipment Services1 1 1 1 1 1 279 - IT / Innovation / 311 Call Center279-0104 311 Call Center1 1 1 1 1 1 288 - Emergency Medical Services288-0902 EMS1 1 1 1 1 1 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce. 2 3 3 3 3 3 600-1207 Animal Care & Control 2 2 2 2 2 2 4 5 5 5 5 5 - - - - - - 620 - Water Works O&M620-0640 Water Works3 3 3 3 3 3 641 - Sewage Works O&M 641-0621 Sewer Department4 4 4 3 3 3 670 - Century Center670-0406 Century Center- - 6 5 8 8 Total Part-Time Employees by Fund105 105 140 150 169 151 - - - - - - Monthly Financial Report23 of 24 City of South BendStaffing HeadcountPeriod Ending: June 30, 2018Paid Temporary, Seasonal, and Intern StaffingJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec101 - General Fund101-0101 Mayor's Office - - - - 1 1 101-0201 City Clerk - - - - - 4 101-0301 Common Council - - - - 1 - 101-0401 Admin & Finance - - - - 2 2 101-0602 Engineering Dept - - - - 5 5 101-0801 Police Dept - - 1 1 1 15 - - 1 1 10 27 - - - - - - 201 - Parks & Recreation201-1100 Administration 1 1 - - - - 201-1101 Maintenance - - 7 15 30 36 201-1102 Golf Courses - - - - 2 2 201-1103 Recreation - - 1 1 39 95 1 1 8 16 71 133 - - - - - - 202 - Motor Vehicle Highway202-0607 Street Department - - - - 1 2 202-0619 Curb & Sidewalk Program - - 2 3 3 3 - - 2 3 4 5 - - - - - - 203 - Recreation Non-Reverting203-1103 Recreation2 2 - 5 25 26 222 - Central Services222-0605 Equipment Services - - 1 1 2 2 222-0606 Building Maintenance 1 1 - - - - 222-0616 Office of Sustainability - - - - 1 1 1 1 1 1 3 3 - - - - - - 600 - Consolidated Building Dept.600-1207 Animal Care & Control- - - - 1 1 620 - Water Works O&M620-0640 Water Works- - - - - 3 641 - Sewage Works O&M 641-0621 Sewer Department1 1 2 2 3 2 Total Paid Temporary, Seasonal, and Intern Staff5 5 14 28 117 200 - - - - - - Staffing SummaryBudgetFull-TimeJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecFull Time Staff 1,130 1,101 1,101 1,112 1,110 1,105 1,097 - - - - - - Part Time Staff 105 105 140 150 169 151 - - - - - - Temporary / Seasonal 5 5 14 28 117 200 - - - - - - City Total1,130 1,211 1,211 1,266 1,288 1,391 1,448 - - - - - - Monthly Financial Report24 of 24