Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-07 - 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 July 31, 2018 Controller Monthly Financial Report 2 of 24 July 31, 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 59%, compared to 54% in July 2017. Please note a few revenue types have reached well above their standard 59% 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. Type (396) Specific Stop Loss received $48,740 this month from Anthem, which pushed it 446% above its budgeted revenue amount. Revenue by Fund As of July 2018, the general fund has reached 56% of its budgeted revenue, compared to 54% last year. As mentioned above, some funds have surpassed their normal 59% 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 71% of its budgeted revenue due to interest earnings. Fund 291 (River Rescue) is at 166% of its budgeted revenue. This is tuition revenue related to the advancement of firefighters. Fund 629 (Waterworks Debt Reserve) is at 102% 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) is at 93% of its budgeted revenue amount. In March, Animal Control received $30,568 in private donations. 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 in June 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 July 30, 2018, the City has spent 39% of budgeted expenditures, compared to 45% last year. The General Fund has spent 56% of its 2018 budgeted expenditures, compared to 53% in 2017. The following funds have reached 60% or more of its budgeted expenditures because 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 ~ $2.02 million. Payments are related to IT equipment leases, St. Joseph County PSAP, bond payments for Eddy St. and the Indiana Park District. Headcount The Full Time Headcount as of July 2018 was 1,101 vs. a budgeted amount of 1,130. Overall, there are a total of 35 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 (18) IT/Innovation/ 311 Call Center (1), Unsafe Building (1), and Consolidated Building (2). 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,685,249 57%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,563,382 58%Income Tax315 Econ Development Income Tax 408 893,413 893,413 893,413 - 2,806,609 1,038,161 893,413 - - - - - 7,418,423 10,720,965 69%316 Local Option Income Tax - PS 249 635,795 635,795 635,795 - 2,023,604 741,577 635,795 - - - - - 5,308,361 7,629,539 70%316 County Option Income Tax 404 908,858 908,858 908,858 - 3,099,943 1,060,071 908,858 - - - - - 7,795,445 10,906,293 71%Sub Total2,438,066 2,438,066 2,438,066 - 7,930,157 2,839,809 2,438,066 - - - - - 20,522,229 29,256,797 70%St Joseph County (Remitted by)312 Auto Excise Tax various - - - - - 1,817,877 - - - - - - 1,817,877 3,214,346 57%312 Commercial Vehicle Tax various - - - - - 390,114 - - - - - - 390,114 848,954 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,954,737 49%Total Taxes 2,765,753 2,544,316 2,544,316 196,500 7,930,157 49,678,323 2,438,066 - - - - - 68,097,431 112,774,916 60%Intergovernmental RevenueState Shared Revenue335 Liquor Excise tax 101 50,193 - - - - 33,066 - - - - - - 83,259 83,259 100%335 Liquor Gallonage Tax 101 58,696 - - 48,430 - - 58,129 - - - - - 165,255 210,000 79%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 632,527 - - - - - 4,159,155 6,740,000 62%335 Wheel Tax 202 132,033 88,461 183,060 197,848 196,892 181,671 280,102 - - - - - 1,260,067 2,050,000 61%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 970,759 - - - - - 11,162,881 21,808,397 51%Grants331 Federal Grants various 130,898 321,635 296,672 301,688 834,533 496,619 77,054 - - - - - 2,459,098 9,127,578 27%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 77,054 - - - - - 2,484,462 9,494,953 26%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 527,707 - - - - - 3,693,949 6,332,487 58%339 Contractual Service 211 51,257 8,748 11,248 10,477 13,162 7,914 7,452 - - - - - 110,256 333,500 33%Sub Total774,024 546,520 538,955 801,832 544,393 535,621 535,159 - - - - - 4,276,503 8,745,987 49%Total Intergovernmental Revenue 1,710,185 1,483,115 1,594,973 2,333,671 1,925,726 7,293,204 1,582,972 - - - - - 17,923,846 40,049,337 45%Charges for Services - Internal340 Liability Insurance 226 177,187 171,512 168,832 168,832 176,872 168,832 168,832 - - - - - 1,200,899 2,061,259 58%349 Central Services Mark-up 222 66,267 58,491 63,145 60,020 53,474 60,635 55,945 - - - - - 417,977 793,711 53%Total Charges for Services - Internal 243,454 230,003 231,977 228,852 230,346 229,467 224,777 - - - - - 1,618,876 2,854,970 57%Charges for Services - ExternalLicenses & Permits320 Inspections Central Service 222 - 10 - 310 70 780 20 - - - - - 1,190 1,170 102%321 Business License 101/222 32,444 28,244 15,975 14,076 9,916 3,248 2,082 - - - - - 105,985 126,986 83%322 Vacant Building Registration 219 - - - 300 - 600 - - - - - - 900 900 100%322 Building Fees 600 73,425 93,065 110,408 188,609 169,683 129,950 118,955 - - - - - 884,095 1,392,630 63%322 Building Plan Review - Fire Safety 288 1,145 1,977 1,791 1,713 2,023 1,706 2,963 - - - - - 13,318 24,000 55%322 General Government Fees 101 6,255 24,555 17,695 3,360 14,075 7,623 5,335 - - - - - 78,898 132,000 60%Sub Total113,269 147,851 145,869 208,369 195,767 143,907 129,355 - - - - - 1,084,386 1,677,686 65%Period Ending: July 31, 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: July 31, 2018Charges for Services - ExternalPublic Safety340 Public Safety various - - - - - - - - - - - - - 500 0%340 ND EMS Service 288 - 750 - 2,171 50,015 19,962 3,062 - - - - - 75,960 150,000 51%342 Public Safety various 18,988 18,890 14,579 14,484 10,937 8,903 10,615 - - - - - 97,396 175,000 56%342 EMS - Capital Fund 287 1,078,551 - - - - 538,032 - - - - - - 1,616,582 1,691,583 96%342 EMS - Operating Fund 288 261,623 194,907 457,456 234,783 374,625 225,314 333,774 - - - - - 2,082,482 2,700,000 77%342 EMS - Neo Natal / Transport 288 52,088 44,463 46,959 13,342 70,564 44,895 42,379 - - - - - 314,690 509,400 62%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 389,830 - - - - - 5,091,592 6,992,967 73%Culture & Recreation347 Parks Maintenance (1101) 201/405 38,216 2,133 8,478 39,438 2,991 48,953 67,527 - - - - - 207,737 983,722 21%347 Golf (1102) 201 - 9,042 114,573 51,363 197,653 178,556 203,071 - - - - - 754,259 1,496,406 50%347 Recreation (1103) 201/203 67,191 54,621 148,259 81,735 76,818 98,426 129,003 - - - - - 656,054 1,438,496 46%347 Graffiiti Removal (1108) 201 - - - - - - - - - - - - - 106,459 0%347 Marketing & Events (1110) 201/203 22,851 16,927 1,595 364 253 1,360 68,623 - - - - - 111,973 184,769 61%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 5,040 - - - - - 132,801 245,000 54%Sub Total130,822 104,743 287,305 227,980 307,836 330,873 473,265 - - - - - 1,862,824 4,498,352 41%Code Enforcement321 Code and Animal Fees 600 8,225 5,675 8,107 9,025 7,878 8,239 7,867 - - - - - 55,015 77,880 71%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 8,835 - - - - - 74,739 187,479 40%349 Code Demolition Board Up 219/600 20,189 33,441 18,661 1,060 2,062 3,392 998 - - - - - 79,803 104,500 76%Sub Total37,087 52,106 41,638 18,883 25,223 19,819 17,700 - - - - - 212,456 417,359 51%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 415,716 - - - - - 2,902,552 4,992,585 58%346 Solid Waste Misc 610 14,208 14,312 15,082 44,193 63,226 27,677 45,511 - - - - - 224,208 372,206 60%346 Water Works Utility 620 1,000,323 1,038,936 999,511 1,201,084 1,572,280 1,084,601 1,369,364 - - - - - 8,266,099 15,965,983 52%344 Water Leak Insurance 620 82,210 82,136 82,151 83,498 117,515 55,449 86,657 - - - - - 589,616 1,012,683 58%344 Sewer Repair Insurance 640 52,568 52,969 53,044 52,989 75,735 32,718 53,561 - - - - - 373,584 615,685 61%344 Sewage Waste Water 641 3,062,991 3,147,975 3,146,045 3,587,736 4,021,785 2,386,463 2,851,588 - - - - - 22,204,582 37,338,110 59%346 Sewer System Development Fees 622 - - - - 11,543 10,260 168,530 - - - - - 190,333 195,000 98%344 Sewer System Development Fees 642 - - - - 30,075 24,742 534,990 - - - - - 589,806 688,000 86%346 Project ReLeaf 655 37,195 37,230 37,137 37,103 51,847 22,684 37,320 - - - - - 260,516 439,680 59%Sub Total4,681,543 4,786,174 4,747,270 5,464,990 6,528,574 3,894,034 5,563,237 - - - - - 35,665,822 61,843,297 58%Parking Garages349 Parking Garage Fees 601 116,271 79,180 114,263 110,720 89,676 95,917 117,289 - - - - - 723,315 1,165,035 62%Sub Total116,271 79,180 114,263 110,720 89,676 95,917 117,289 - - - - - 723,315 1,165,035 62%Century Center349 Parking Century Center 670 14,340 12,563 18,826 7,565 5,881 4,240 3,735 - - - - - 67,150 131,723 51%371 Century Center Fees 670 18,397 26,165 14,226 43,812 21,855 21,337 17,972 - - - - - 163,764 416,440 39%372 Century Center Fees 670 11,305 16,861 17,464 17,981 5,696 19,489 10,425 - - - - - 99,221 137,197 72%373 Century Center Fees 670 68,911 118,743 72,239 159,393 167,894 251,802 177,194 - - - - - 1,016,176 1,836,743 55%374 Century Center Fees 670 10,280 14,302 6,378 29,858 23,385 41,881 32,368 - - - - - 158,452 322,054 49%Sub Total123,233 188,634 129,134 258,609 224,711 338,750 241,693 - - - - - 1,504,762 2,844,157 53%Other341 General Government Various various 449 1,671 4,221 9,121 291 943 1,648 - - - - - 18,344 30,605 60%341 Historic Presrv Comm Approval 211 80 40 220 230 440 320 160 - - - - - 1,490 2,500 60%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 51,635 - - - - - 171,293 300,223 57%352 Forfeits various 11,462 7,073 6,948 2,699 10,663 17,638 6,201 - - - - - 62,684 200,900 31%354 Ordinance Violation various 2,515 8,042 16,451 4,024 7,361 6,073 7,280 - - - - - 51,747 108,500 48%Sub Total38,732 35,482 49,425 35,259 33,971 46,826 66,924 - - - - - 306,618 647,148 47%Total Charges for Services - External 6,652,205 5,653,179 6,486,138 6,740,335 8,062,647 5,857,980 6,999,291 - - - - - 46,451,775 80,086,001 58%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: July 31, 2018Other IncomeMiscellaneous Revenue360 Miscellaneous Revenue various 19,102 109,003 369,027 (328,283) 25,334 7,467 10,502 - - - - - 212,151 675,675 31%360 Insurance Reimbursement various 2,960 - 4,527 2,000 1,113 64,316 203 - - - - - 75,119 108,470 69%360 Sale of Scrap Metal various 2,352 1,027 2,825 1,039 53 2,002 6,202 - - - - - 15,499 36,582 42%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 5,254 - - - - - 22,240 38,475 58%360 Century Center 670 551 98 231 926 250 111 966 - - - - - 3,133 6,629 47%360 Morris PAC various 20,063 57,049 206,037 172,565 107,301 157,429 15,500 - - - - - 735,944 1,083,500 68%360 Palais Royale various 48,381 8,222 6,608 16,238 19,617 18,491 22,621 - - - - - 140,179 299,572 47%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 61,247 - - - - - 1,297,722 2,379,904 55%Interest Income361 Bank Account Interest various 551,499 330,255 212,014 203,811 205,984 437,616 322,678 - - - - - 2,263,856 3,249,070 70%Sub Total551,499 330,255 212,014 203,811 205,984 437,616 322,678 - - - - - 2,263,856 3,249,070 70%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 3,614 - - - - - 25,943 42,300 61%362 South Bend School Corp Fee 407 - - - - - - 25,000 - - - - - 25,000 25,000 100%362 Century Center Property Rental 670 55,092 25,563 60,625 45,995 32,271 31,350 21,292 - - - - - 272,189 431,328 63%362 TIF Property various 4,447 139,564 7,486 4,597 - - - - - - - - 156,094 274,970 57%Sub Total64,670 178,061 71,295 55,453 39,031 36,641 49,907 - - - - - 495,058 903,985 55%Donations367 ND Contribution 101 - - - - - - 330,000 - - - - - 330,000 337,500 98%367 Donations various 18,825 209 30,568 100,323 904 2,391 776 - - - - - 153,995 328,100 47%Sub Total18,825 209 30,568 100,323 904 2,391 330,776 - - - - - 483,995 665,600 73%Historic Preservation368 Palais Royale 450 3,726 433 525 803 1,837 1,670 1,705 - - - - - 10,698 16,500 65%Sub Total3,726 433 525 803 1,837 1,670 1,705 - - - - - 10,698 16,500 65%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 - 44,565 - - - - - 183,627 215,000 85%369 Memorial Hosp Leighton Plaza 408 - - - - - - - - - - - - - 150,000 0%Sub Total- 181,977 354,660 45,375 271,594 - 44,565 - - - - - 898,171 1,487,660 60%Total Other Income 748,405 870,104 1,265,162 347,171 673,168 734,612 810,877 - - - - - 5,449,499 8,702,719 63%Reimbursements & RefundsInternal Reimbursements380 Central Services Reimbursements 222 235,705 220,302 209,553 235,110 220,977 208,356 200,472 - - - - - 1,530,475 3,138,246 49%380 Energy Office Reimbursements 222 392,685 463,881 442,837 375,343 424,583 370,789 419,686 - - - - - 2,889,805 4,725,000 61%380 Police Take Home Vehicle 278 240 240 240 240 240 240 404 - - - - - 1,844 2,500 74%380 IT / Innovation / 311 Center 279 568,506 568,346 566,166 565,746 568,506 565,746 567,506 - - - - - 3,970,522 6,864,491 58%Sub Total1,197,136 1,252,770 1,218,796 1,176,439 1,214,306 1,145,131 1,188,068 - - - - - 8,392,646 14,730,237 57%Miscellaneous380 Miscellaneous Reimbursements various 46,138 78,029 58,491 98,181 65,283 168,837 80,156 - - - - - 595,114 1,374,680 43%380 INDOT SR 933 Transfer 251 - - - - 330,000 - - - - - - - 330,000 330,000 100%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 80,156 - - - - - 5,028,431 5,808,047 87%Total Reimbursements & Refunds 1,243,274 1,330,799 1,277,286 5,377,937 1,609,589 1,313,968 1,268,225 - - - - - 13,421,077 20,538,284 65%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: July 31, 2018Other Financing SourcesFixed Assets391 Sale of Fixed Assets various - - - - 2,260 578,602 - - - - - - 580,862 673,862 86%391 TIF (Property Sales / Land) various 92,660 20,001 - 150,000 1,779 - - - - - - - 264,441 271,779 97%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 969,841 88%Miscellaneous392 Administration Fee Allocation 101 452,408 452,408 452,408 452,408 452,408 452,408 452,408 - - - - - 3,166,856 5,454,725 58%392 Inter-Fund Transfers various 229,386 3,177,839 7,267,151 2,426,728 1,475,278 5,362,018 1,281,453 - - - - - 21,219,852 42,135,301 50%Sub Total681,794 3,630,247 7,719,559 2,879,136 1,927,686 5,814,426 1,733,861 - - - - - 24,386,708 47,590,026 51%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 258,914 - - - - - 1,806,468 3,066,596 59%395 Employer Assessment 711/713/714 1,258,903 1,252,774 1,299,074 1,281,117 1,281,453 1,278,578 1,256,860 - - - - - 8,908,759 15,580,694 57%Sub Total1,536,074 1,507,866 1,551,530 1,538,444 1,535,872 1,529,666 1,515,774 - - - - - 10,715,227 18,647,290 57%Refunds396 Central Services Refunds 222 14,009 - 14,505 - 14,745 8,787 - - - - - - 52,046 52,046 100%396 Specific Stop Loss 711 1,844 495 127 - 396 2,959 48,740 - - - - - 54,561 10,000 546%Sub Total15,853 495 14,632 - 15,141 11,746 48,740 - - - - - 106,607 62,046 172%Other399 Bosch Retention Project 210 - - - - - 16,336 16,215 - - - - - 32,551 65,593 50%399 Principal on Loan various 511 80,012 397 617 397 1,564 57,339 - - - - - 140,838 127,914 110%399 Principal Income various - 259,888 - 33,602 - - 323,777 - - - - - 617,267 1,086,395 57%511 339,900 397 34,219 397 17,901 397,331 - - - - - 790,655 1,279,902 62%Total Other Financing Sources 2,331,537 5,498,508 14,150,126 16,562,044 3,668,742 14,064,950 3,695,706 - - - - - 59,971,613 96,273,324 62%Revenue Total 15,694,813 17,610,023 27,549,979 31,786,510 24,100,375 79,172,504 17,019,913 - - - - - 212,934,117 361,279,551 59%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 1,443,670 - - - - - 32,504,368 57,372,617 57%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 1,443,670 - - - - - 32,555,297 57,461,652 57%Public Works0602 Engineering 101 7,755 24,555 19,320 21,384 14,340 8,123 5,335 - - - - - 100,812 352,167 29%Sub Total7,755 24,555 19,320 21,384 14,340 8,123 5,335 - - - - - 100,812 352,167 29%Public Safety0801 Police 101 6,578 10,889 19,222 422 6,397 16,454 44,038 - - - - - 104,000 561,000 19%0901 Fire 101 - - - - - 1,705 44 - - - - - 1,749 146,114 1%Sub Total6,578 10,889 19,222 422 6,397 18,159 44,081 - - - - - 105,748 707,114 15%Arts & Culture0404 Morris PAC 101 21,240 58,357 204,197 178,801 128,078 157,383 12,685 - - - - - 760,741 1,101,000 69%0405 Palais Royale 101 54,041 12,252 7,122 18,018 21,594 19,948 24,994 - - - - - 157,969 398,972 40%Sub Total75,281 70,609 211,319 196,819 149,672 177,331 37,679 - - - - - 918,710 1,499,972 61%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 1,530,766 - - - - - 33,702,301 60,020,905 56%Venues, Parks & ArtsParks & Recreation0000 Parks General Revenue 201 11,804 8,621 326,457 3,283 2,667 6,010,397 3,740 - - - - - 6,366,969 10,962,801 58%1100 Administration 201 1,283 2,799 3,187 4,864 4,918 5,301 3,627 - - - - - 25,979 42,400 61%1101 Maintenance 201 38,603 50,870 27,007 81,894 2,106 71,546 99,272 - - - - - 371,299 1,262,622 29%1102 Golf Operations 201 2 9,042 115,093 51,725 199,099 180,187 205,074 - - - - - 760,222 1,501,406 51%1103 Recreation Division 201 210 1,865 1,100 84 1,667 21,635 42,201 - - - - - 68,762 107,060 64%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 156,553 - - - - - 711,611 1,651,205 43%Morris Palais Marketing 273 330 89 3,146 54 127 2,590 354 - - - - - 6,689 20,550 33%Morris PAC Self-Promotion 274 1,122 11,010 7,205 27,552 15,086 1,870 2,597 - - - - - 66,442 121,000 55%Zoo Endowment 403 - - - - - - - - - - - - - - NA Park Non-Reverting 405 490 299 413 751 1,033 757 633 - - - - - 4,377 145,600 3%Sub Total340,612 159,625 633,340 516,661 302,846 6,375,425 514,051 - - - - - 8,842,558 17,991,103 49%Parking Garages0000 Parking Garage Revenue 601 1,922 13 77 - - - 20 - - - - - 2,031 59,090 3%0460 Main Street 601 31,708 28,624 51,143 40,608 35,626 26,554 33,408 - - - - - 247,670 312,842 79%0462 Leighton Plaza 601 70,649 28,496 41,970 60,682 31,104 53,908 59,768 - - - - - 346,576 571,000 61%0463 Enforcement 601 4,787 5,905 8,543 10,069 7,358 7,029 13,280 - - - - - 56,971 49,110 116%0464 Wayne Street 601 13,659 22,084 21,012 9,641 22,713 15,259 24,847 - - - - - 129,214 279,300 46%0465 Eddy Street Commons 601 - - - - - - - - - - - - - 500 0%Sub Total122,725 85,121 122,744 120,999 96,801 102,749 131,323 - - - - - 782,462 1,271,842 62%Century CenterCentury Center Operations 670 285,126 320,545 296,240 305,530 257,232 370,211 263,951 - - - - - 2,098,835 4,557,114 46%Century Center Capital 671 74 66 - 144 73 70 73 - - - - - 500 900 56%Century Center Energy Saving 672 4 221,441 - 8 4 55,072 4 - - - - - 276,534 420,124 66%Sub Total285,204 542,052 296,240 305,682 257,309 425,354 264,028 - - - - - 2,375,869 4,978,138 48%Total Venues, Parks & Arts 748,540 786,798 1,052,324 943,342 656,956 6,903,527 909,401 - - - - - 12,000,889 24,241,083 50%Period Ending: July 31, 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: July 31, 2018Public SafetyPolice DepartmentPolice Seizures 216 485 4,179 162 162 3,782 322 251 - - - - - 9,342 32,100 29%Curfew Violations 218 31 21 11 11 10 71 41 - - - - - 194 360 54%Law Enforcement Education 220 27,367 18,710 30,422 16,072 19,138 12,801 16,831 - - - - - 141,342 283,780 50%Public Safety LOIT 249 637,913 636,475 636,611 846 2,024,136 742,965 637,770 - - - - - 5,316,715 7,641,439 70%Police Take Home Vehicle 278 2,042 1,457 858 857 839 1,448 1,341 - - - - - 8,842 12,500 71%Police Block Grant 280 9 6 3 3 3 6 5 - - - - - 36 35 104%Police Grants 292 - - - - - - - - - - - - - - NA Police Academy 294 7,809 8,737 1,379 3,181 447 160 123 - - - - - 21,836 28,000 78%COPS More Grants 295 1,496 26,664 1,128 1,056 14,999 1,221 1,492 - - - - - 48,055 118,923 40%Drug Enforcement 299 164 6,377 160 197 211 220 227 - - - - - 7,557 51,700 15%K-9 Unit 705 7 5 2 2 2 5 4 - - - - - 27 2,035 1%Sub Total677,322 702,630 670,736 22,388 2,063,569 759,218 658,084 - - - - - 5,553,947 8,170,872 68%Fire DepartmentEMS Capital 287 1,088,873 9,083 4,146 3,853 28,876 544,916 5,376 - - - - - 1,685,123 1,761,008 96%EMS Operating Fund 288 322,278 245,130 962,243 404,791 651,597 447,139 386,684 - - - - - 3,419,862 5,196,584 66%Hazmat 289 64 44 23 23 22 44 34 - - - - - 254 10,280 2%River Rescue 291 7,495 8,022 5,508 6,114 1,315 14,154 34,675 - - - - - 77,282 46,500 166%Sub Total1,418,710 262,280 971,920 414,780 681,810 1,006,253 426,768 - - - - - 5,182,521 7,014,372 74%Total Public Safety 2,096,032 964,910 1,642,656 437,168 2,745,378 1,765,471 1,084,853 - - - - - 10,736,468 15,185,244 71%Public WorksStreetsMotor Vehicle Highway 202 579,560 469,318 1,559,435 741,820 711,808 1,546,419 742,429 - - - - - 6,350,789 11,391,485 56%Local Roads & Streets 251 203,272 163,889 163,935 623,779 174,065 291,302 185,877 - - - - - 1,806,120 2,300,960 78%Local Road & Bridge Grant 265 - - 753 807 597 1,093 726 - - - - - 3,975 5,000 80%Project ReLeaf 655 39,153 38,649 37,857 37,835 52,491 23,998 38,346 - - - - - 268,329 453,259 59%Sub Total821,986 671,857 1,761,980 1,404,241 938,961 1,862,812 967,378 - - - - - 8,429,214 14,150,704 60%Solid WasteSolid Waste Operations 610 430,160 429,729 429,993 458,203 648,222 323,532 462,010 - - - - - 3,181,849 5,543,349 57%Solid Waste Capital 611 96 293,038 - 83,101 20,538 185,581 17 - - - - - 582,370 1,077,506 54%Sub Total430,256 722,767 429,993 541,304 668,760 509,112 462,027 - - - - - 3,764,218 6,620,855 57%Water Works0000 Water Works Revenues 620 947,619 981,889 938,998 1,133,739 1,492,413 972,136 1,251,120 - - - - - 7,717,914 14,785,654 52%0630 Water Leak Insurance 620 82,210 82,136 82,151 83,498 117,515 55,449 86,657 - - - - - 589,616 1,012,683 58%0640 Water Works 620 - - - - - - - - - - - - - - NA 0660 Clay Water 620 70,281 70,546 69,452 81,550 85,849 125,763 131,360 - - - - - 634,799 1,356,710 47%Waterworks Capital 622 5,129 3,471 1,764 1,758 13,251 13,497 178,761 - - - - - 217,630 380,000 57%Waterworks Deposit 624 3,630 2,451 1,247 1,241 1,204 2,426 1,878 - - - - - 14,078 15,000 94%Waterworks Sinking 625 166,918 165,664 165,836 165,897 166,129 166,943 166,825 - - - - - 1,164,211 2,009,217 58%Waterworks Bond Reserve 626 3,335 2,280 1,176 1,172 1,147 2,274 1,775 - - - - - 13,159 16,000 82%Waterworks Debt Reserve 629 58,511 4,227 2,190 2,179 2,116 4,260 3,299 - - - - - 76,782 75,250 102%Sub Total1,337,633 1,312,665 1,262,813 1,471,034 1,879,624 1,342,746 1,821,675 - - - - - 10,428,189 19,650,514 53%Wastewater/Sewer/Organic ResourcesSewer Repair Insurance 640 57,037 56,067 54,602 54,553 77,239 35,741 55,906 - - - - - 391,145 636,535 61%0000 Wastewater Revenues 641 2,916,439 2,990,482 2,919,440 3,505,847 4,000,241 2,253,736 2,671,011 - - - - - 21,257,196 35,754,079 59%0621 Sewer Department 641 760 - - - - 4,488 1,971 - - - - - 7,219 6,988 103%0625 Concrete Crew 641 - 3,050 5,935 9,706 - 11,270 9,184 - - - - - 39,145 55,170 71%0630 Wastewater Operations 641 - - - - - 1,014 - - - - - - 1,014 1,015 100%0631 Organic Resources 641 - - 50,000 (50,000) - 5,836 - - - - - - 5,836 5,837 100%0650 Clay Sewage 641 183,418 191,425 189,159 195,271 197,050 206,945 199,510 - - - - - 1,362,779 2,160,000 63%Sewage Capital 642 17,620 11,009 5,623 1,005,502 35,758 2,036,994 764,594 - - - - - 3,877,100 10,658,000 36%Sewage Reserve 643 12,344 246,543 4,240 4,407 4,278 8,614 6,672 - - - - - 287,097 315,226 91%Sewage Bond Sinking 649 1,899 1,383 3,052,829 765,660 766,414 771,108 786,652 - - - - - 6,145,946 9,232,029 67%Sewage Works DS Reserve 653 - 3,678 4,038 3,972 4,861 5,086 5,599 - - - - - 27,234 51,700 53%2011 Sewer Bond 659 0 0 0 0 0 0 0 - - - - - 1 5 27%2012 Sewer Bond 661 1,538 1,039 396 117 90 27 21 - - - - - 3,229 10,000 32%Sub Total3,191,056 3,504,676 6,286,262 5,495,037 5,085,933 5,340,859 4,501,120 - - - - - 33,404,942 58,886,584 57%Total Public Works 5,780,930 6,211,964 9,741,049 8,911,615 8,573,277 9,055,529 7,752,200 - - - - - 56,026,564 99,308,657 56%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: July 31, 2018Capital & Debt Service Fund2017 Parks Bond Debt Service 312 - - - - - 404,543 100 - - - - - 404,643 705,751 57%Hall of Fame Debt Service 313 - 22 26,131 (26,012) - 248,545 - - - - - - 248,685 477,943 52%2018 Fire Station #9 Debt Service 350 - - - - - - - - - - - - - - NA Professional Sports Development 377 37 - - - - - 7,431 - - - - - 7,468 620,000 1%Coveleski Stadium 401 131 88 45 45 43 87 68 - - - - - 507 44,250 1%COIT 404 929,149 954,707 1,240,204 40,933 3,106,815 1,090,669 956,377 - - - - - 8,318,855 11,951,048 70%Cumulative Capital Development 406 1,336 976 350 327 317 259,322 547 - - - - - 263,175 461,800 57%Cumulative Capital Improvement 407 222,424 (220,745) 311 149 145 112,006 25,332 - - - - - 139,623 278,500 50%EDIT 408 923,177 913,974 1,259,362 11,898 2,821,210 1,638,989 913,006 - - - - - 8,481,616 11,958,596 71%UDAG 410 1,129 10,139 369 9,745 337 682 528 - - - - - 22,929 138,728 17%Major Moves 412 6,962 312,097 2,536 2,415 2,271 4,519 250,076 - - - - - 580,876 518,178 112%Morris PAC Improvement 416 2,516 11,683 7,547 27,886 15,386 2,448 3,011 - - - - - 70,477 129,000 55%Palais Historic Preservation 450 3,987 621 618 896 1,928 1,855 1,851 - - - - - 11,757 17,600 67%2018 Fire Station #9 Capital 451 - - 4,864,008 142,151 3,854 7,764 6,021 - - - - - 5,023,799 5,025,758 100%2017 Parks Bond Capital 471 - - 10,526 11,306 10,992 22,104 16,771 - - - - - 71,699 110,000 65%Hall of Fame Capital 677 1,076 723 363 355 342 683 528 - - - - - 4,071 5,000 81%Equipment / Vehicle Leasing 750 200 718 651 511 101,682 6,116,382 1,076 - - - - - 6,221,219 10,821,960 57%Parks Bond Capital 751 - 557 4,303 (3,322) 365 383 365 - - - - - 2,652 4,500 59%Smart Street Bond Capital 753 - 177 175 157 173 208 46 - - - - - 936 1,500 62%SB Building Corp 755 - 1,324,193 1,054 464 599 659 723 - - - - - 1,327,692 2,641,925 50%Parks Bond Debt Svc 757 - 31,935 31,719 30,456 31,602 31,660 63,175 - - - - - 220,547 381,107 58%Eddy St. Commons Capital 759 - 34 4 4 4 5 5 - - - - - 57 2,000 3%Eddy St. Commons Debt 760 - 425 628,897 384 425 511 532 - - - - - 631,174 1,283,972 49%Total Capital & Debt Service 2,092,124 3,342,322 8,079,175 250,749 6,098,491 9,944,026 2,247,569 - - - - - 32,054,455 47,579,116 67%Department of Community InvestmentStudebaker/Oliver 209 37,428 4,300 2,632 733 713 1,406 101,082 - - - - - 148,294 213,014 70%State Grant 210 3,321 673 339 338 316 18,620 18,473 - - - - - 42,080 79,887 53%DCI Operating 211 97,850 10,408 597,142 11,407 14,423 476,296 8,412 - - - - - 1,215,937 2,659,181 46%0000 Dept. of Community Investment 212 2,443 363,662 177,763 161,022 166,785 393,680 78,306 - - - - - 1,343,659 5,654,789 24%1013 Programs 212 - 12,542 - - - - - - - - - - 12,542 250,739 5%Economic Revenue Bond 281 67 45 23 23 22 45 35 - - - - - 259 425 61%Total Dept of Community Investment 141,109 391,630 777,899 173,523 182,259 890,046 206,307 - - - - - 2,762,772 8,858,035 31%Central ServicesCentral Services 222 711,462 743,850 730,557 671,452 714,379 651,639 677,624 - - - - - 4,900,963 8,739,573 56%Central Services Capital 224 467 262 140 127 123 205 149 - - - - - 1,473 79,000 2%Total Central Services 711,930 744,112 730,697 671,579 714,502 651,844 677,772 - - - - - 4,902,436 8,818,573 56%Liability Insurance0000 Business Insurance Revenues 226 188,502 178,952 172,513 175,756 180,379 175,233 173,571 - - - - - 1,244,906 2,104,576 59%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 16,780 100%Total Liability Insurance 188,502 194,951 172,513 175,756 181,159 175,233 173,571 - - - - - 1,261,686 2,121,356 59%Code EnforcementUnsafe Building 219 8,297 10,793 177,440 8,805 19,463 174,038 13,106 - - - - - 411,942 913,073 45%Landlord Registration 221 55 200 57 13 8 16 12 - - - - - 362 6,070 6%1201 Neighborhood Code Enforcement 600 34,861 50,613 87,949 15,743 14,439 65,650 9,177 - - - - - 278,432 575,565 48%1207 Animal Care & Control 600 9,000 5,690 213,293 9,060 7,893 213,449 7,911 - - - - - 466,295 905,042 52%1208 Rental Unit Inspection 600 - - - - - - - - - - - - - 30,000 0%Total Code Enforcement 52,213 67,296 478,739 33,621 41,802 453,153 30,207 - - - - - 1,157,031 2,429,750 48%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: July 31, 2018Building Department1306 Building Dept Operations 600 80,975 97,855 112,720 190,817 171,901 134,235 122,123 - - - - - 910,628 1,430,630 64%Total Building Department 80,975 97,855 112,720 190,817 171,901 134,235 122,123 - - - - - 910,628 1,430,630 64%OtherMiscellaneousRainy Day 102 24,622 16,629 8,451 8,424 8,187 16,491 12,786 - - - - - 95,589 160,000 60%Gift, Donation, Bequest 217 18,967 403 30,663 432 924 1,132 959 - - - - - 53,479 57,250 93%Loss Recovery 227 2,029 1,226 590 583 560 1,125 870 - - - - - 6,982 8,000 87%LOIT 2016 Special Distribution 257 1,967 10,003 1,770 18,352 671,605 41,768 3,129 - - - - - 748,593 2,294,687 33%Human Rights 258 11,146 6,333 7,584 3,894 389 39,911 2,100 - - - - - 71,358 169,400 42%IT / Innovation /311 Call Center 279 584,945 568,346 567,429 667,191 570,188 569,001 570,030 - - - - - 4,097,130 6,988,576 59%Sub Total643,676 602,940 616,487 698,875 1,251,852 669,427 589,874 - - - - - 5,073,132 9,677,913 52%Fiduciary Trust & AgencyFire Pension 701 3,766 642 14 - 3,052 2,239,434 - - - - - - 2,246,908 5,222,552 43%Police Pension 702 2,515 1,314 244 213 232 3,113,866 229 - - - - - 3,118,613 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 1,566,970 - - - - - 10,777,064 18,611,602 58%Unemployment Comp 713 542 365 185 182 173 342 261 - - - - - 2,050 2,000 102%Parental Leave Fund 714 - - 39,462 12,844 12,678 18,950 12,612 - - - - - 96,546 155,854 62%City Cemetery Trust 730 68 46 23 23 23 46 35 - - - - - 265 250 106%Sub Total1,568,905 1,529,090 1,560,856 1,548,081 1,549,056 6,905,351 1,580,106 - - - - - 16,241,445 29,997,758 54%Total Other 2,212,581 2,132,030 2,177,343 2,246,955 2,800,908 7,574,778 2,169,981 - - - - - 21,314,577 39,675,671 54%Total Civil City 15,455,459 16,231,806 26,226,017 15,367,592 23,660,645 62,983,538 16,904,750 - - - - - 176,829,806 309,669,020 57%Redevelopment FundsTax Increment FinancingTIF River West - Airport 324 166,079 208,028 26,039 4,492,291 24,964 10,652,105 37,525 - - - - - 15,607,031 24,119,532 65%TIF West Washington 422 5,328 3,682 1,842 1,805 1,744 177,019 2,684 - - - - - 194,104 454,000 43%TIF Leighton Plaza 425 10,000 11,541 11,324 6,996 126 254 197 - - - - - 40,437 197,014 21%TIF River East DEV (NE) 429 23,830 13,582 6,937 75,411 6,610 1,455,261 10,530 - - - - - 1,592,161 2,569,365 62%TIF Southside 430 18,064 12,668 6,438 6,409 6,203 1,271,003 9,906 - - - - - 1,330,691 2,463,000 54%TIF Erskine Village 432 - - - - - - - - - - - - - - NA TIF Douglas Road 435 368 324 165 164 160 322 250 - - - - - 1,753 3,150 56%TIF River East RES (NE RE) 436 5,385 - 61 6 - 2,616,136 - - - - - - 2,621,588 4,405,567 60%Sub Total229,054 249,826 52,806 4,583,083 39,807 16,172,099 61,092 - - - - - 21,387,765 34,211,628 63%Redevelopment FundsAdministration 433 18 12 6 6 6 12 28,135 - - - - - 28,195 28,226 100%Certified Technology Park 439 1,469 992 504 502 488 984 763 - - - - - 5,702 10,000 57%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 481 - - - - - 3,596 3,900 92%Industrial Revolving 754 - 14,682 32,213 12,451 16,700 9,233 20,185 - - - - - 105,464 230,000 46%Sub Total2,413 16,311 33,041 10,838,276 200,284 10,849 49,564 - - - - - 11,150,738 11,279,908 99%Debt ServiceAirport Debt Reserve 2003 315 2,489 1,677 853 849 825 1,660 1,286 - - - - - 9,638 14,000 69%Coveleski Bond Debt Reserve 317 1,239 837 425 424 412 830 643 - - - - - 4,810 5,000 96%Central Development reserve 328 4,160 2,803 1,427 1,420 1,378 2,775 2,149 - - - - - 16,113 20,000 81%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 63 - - - - - 1,683,318 3,370,000 50%Smart Streets Debt Svc 756 - 856,792 367 264 293 352 366 - - - - - 858,434 1,716,500 50%Sub Total7,888 1,112,079 1,238,115 997,560 199,640 6,018 4,508 - - - - - 3,565,808 6,118,995 58%Total Redevelopment 239,354 1,378,217 1,323,962 16,418,919 439,730 16,188,966 115,163 - - - - - 36,104,311 51,610,531 70%Revenue Total 15,694,813 17,610,023 27,549,979 31,786,510 24,100,375 79,172,504 17,019,913 - - - - - 212,934,117 361,279,551 59%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: July 31, 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 67,398 - - - - - 508,807 908,142 56%0201 Clerk 101 41,465 49,121 40,587 39,949 40,713 50,724 39,012 - - - - - 301,571 573,553 53%0301 Common Council 101 47,784 61,913 56,765 38,989 37,543 38,639 46,669 - - - - - 328,303 670,013 49%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 195,461 - - - - - 1,391,947 2,639,826 53%0501 Legal 101 80,972 80,377 73,951 75,604 83,331 119,686 95,920 - - - - - 609,841 1,200,973 51%Sub Total417,977 420,463 467,362 449,783 426,154 557,269 444,460 - - - - - 3,183,469 6,035,507 53%Public Works0602 Engineering 101 97,206 113,041 103,308 119,067 116,490 178,064 126,347 - - - - - 853,524 1,750,084 49%0628 AmeriCorps Grant Program 101 - - - - - - - - - - - - - 366,188 0%Sub Total97,206 113,041 103,308 119,067 116,490 178,064 126,347 - - - - - 853,524 2,116,272 40%Public Safety0801 Police 101 2,553,505 2,055,904 2,718,475 2,132,895 2,350,326 3,006,258 2,157,557 - - - - - 16,974,920 29,626,242 57%0901 Fire 101 1,702,483 1,610,625 1,725,671 1,768,450 1,674,070 2,246,841 1,671,012 - - - - - 12,399,151 21,743,343 57%Sub Total4,255,987 3,666,528 4,444,146 3,901,345 4,024,396 5,253,100 3,828,569 - - - - - 29,374,071 51,369,585 57%Arts & Culture0404 Morris PAC 101 66,022 73,169 75,014 97,698 72,067 84,366 77,142 - - - - - 545,480 1,320,791 41%0405 Palais Royale 101 24,590 30,996 30,536 38,928 28,467 33,097 34,209 - - - - - 220,822 541,428 41%Sub Total90,612 104,165 105,550 136,627 100,535 117,462 111,351 - - - - - 766,302 1,862,219 41%Human Rights1008 Human Rights 101 24,673 39,414 28,107 30,137 28,074 50,657 30,988 - - - - - 232,050 447,133 52%Sub Total24,673 39,414 28,107 30,137 28,074 50,657 30,988 - - - - - 232,050 447,133 52%Total General Fund 4,886,455 4,343,611 5,148,473 4,636,958 4,695,650 6,156,553 4,541,715 - - - - - 34,409,415 61,830,716 56%Venues, Parks & ArtsParks & Recreation1100 Administration 201 106,755 110,212 113,541 107,652 112,266 113,719 100,246 - - - - - 764,391 1,227,968 62%1101 Maintenance 201 443,597 540,635 455,011 529,200 381,724 552,375 597,692 - - - - - 3,500,234 7,184,730 49%1102 Golf Operations 201 56,591 61,999 131,255 128,948 179,825 168,374 133,272 - - - - - 860,264 1,588,326 54%1103 Recreation Division 201 136,104 122,740 127,055 125,984 121,073 228,394 234,188 - - - - - 1,095,538 2,181,005 50%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 418 - - - - - 34,612 46,602 74%1108 Graffiti Removal 201 7,388 7,283 7,197 6,062 7,375 11,255 9,160 - - - - - 55,721 106,459 52%1110 Marketing and Events 201 68,206 71,319 71,723 57,212 70,917 91,671 71,101 - - - - - 502,150 1,133,376 44%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 139,875 - - - - - 590,046 1,740,403 34%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 - 5,286 - - - - - 70,569 277,872 25%Sub Total948,190 1,378,655 1,217,645 1,039,194 1,196,706 1,341,760 1,291,237 - - - - - 8,413,387 18,368,336 46%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 44,279 - - - - - 167,801 335,768 50%0462 Leighton Plaza 601 5,884 20,832 29,852 23,965 48,940 28,444 55,308 - - - - - 213,224 484,307 44%0463 Enforcement 601 416 10,797 17,893 9,992 39,101 20,222 44,206 - - - - - 142,626 104,632 136%0464 Wayne Street 601 4,405 12,676 18,657 12,984 42,127 20,382 41,343 - - - - - 152,573 312,637 49%0465 Eddy Street Commons 601 - - - - - - - - - - - - - 15,000 0%Sub Total76,136 57,981 87,880 64,535 173,567 91,714 185,136 - - - - - 736,948 1,252,344 59%Century CenterCentury Center Operations 670 301,878 328,776 305,181 347,087 363,068 390,594 329,550 - - - - - 2,366,134 4,557,114 52%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 329,550 - - - - - 2,471,898 4,883,851 51%Total Venues, Parks & Arts 1,326,204 1,765,412 1,610,706 1,456,032 1,833,889 1,824,067 1,805,923 - - - - - 11,622,233 24,504,531 47%Period Ending: July 31, 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: July 31, 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 9,219 - - - - - 147,262 594,624 25%Public Safety LOIT 249 491,276 597,065 748,915 614,419 627,510 898,175 600,968 - - - - - 4,578,329 7,622,970 60%Police Take Home Vehicle 278 - - - - - (124) 124 - - - - - - 10,000 0%Police Block Grant 280 - - - - - - - - - - - - - - NA Police Grants 292 - - - - - - - - - - - - - - NA Police Academy 294 3,362 964 695 2,795 1,222 135 808 - - - - - 9,981 22,500 44%COPS More Grants 295 26,202 960 10,748 840 10,808 14,312 78 - - - - - 63,948 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 611,196 - - - - - 4,799,518 8,448,899 57%Fire DepartmentEMS Capital 287 232,138 245,348 612,456 (57,750) 168,513 744 596,734 - - - - - 1,798,183 3,389,730 53%EMS Operating Fund 288 451,202 438,738 494,754 428,273 410,073 597,054 467,705 - - - - - 3,287,799 6,431,746 51%Hazmat 289 - - - - - - 1,860 - - - - - 1,860 10,000 19%River Rescue 291 620 231 1,296 231 7,794 4,343 6,024 - - - - - 20,537 101,800 20%Sub Total683,959 684,317 1,108,506 370,754 586,379 602,141 1,072,323 - - - - - 5,108,379 9,933,276 51%Total Public Safety 1,262,673 1,299,862 1,873,563 1,003,851 1,233,786 1,550,643 1,683,519 - - - - - 9,907,898 18,382,175 54%Public WorksStreetsMotor Vehicle Highway 202 929,501 929,777 730,837 543,249 526,212 763,105 977,166 - - - - - 5,399,848 12,393,981 44%Local Roads & Streets 251 - 41,614 38,357 57,236 308,409 208,005 255,584 - - - - - 909,205 3,418,508 27%Local Road & Bridge Grant 265 900 1,755 254,290 3,480 147,066 - 566,887 - - - - - 974,377 2,437,632 40%Project ReLeaf 655 3,267 3,043 140,787 27,502 3,155 140,553 3,120 - - - - - 321,428 702,042 46%Sub Total933,668 976,189 1,164,271 631,467 984,843 1,111,663 1,802,757 - - - - - 7,604,859 18,952,163 40%Solid WasteSolid Waste Operations 610 353,032 690,851 316,475 525,146 360,359 653,109 377,613 - - - - - 3,276,585 5,496,049 60%Solid Waste Capital 611 185,219 146,711 218 83,821 19,559 127 185,407 - - - - - 621,064 1,076,706 58%Sub Total538,251 837,563 316,694 608,967 379,918 653,236 563,020 - - - - - 3,897,649 6,572,755 59%Water Works0630 Water Leak Insurance 620 26,512 56,237 63,642 43,963 60,972 63,888 75,936 - - - - - 391,149 1,035,000 38%0640 Water Works 620 1,352,132 1,350,826 1,337,064 1,187,277 1,155,640 1,270,202 1,250,860 - - - - - 8,904,000 17,031,780 52%0660 Clay Water 620 104 91 - - 36 65 137 - - - - - 433 3,500 12%Waterworks Capital 622 1,642 - - - 407,566 - 6,625 - - - - - 415,833 1,578,570 26%Waterworks Deposit 624 1,289 2,451 1,247 1,241 1,204 2,426 1,878 - - - - - 11,736 15,000 78%Waterworks Sinking 625 1,279 569 241 302 534 285,314 1,230 - - - - - 289,469 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 3,299 - - - - - 20,496 23,000 89%Sub Total1,385,183 1,414,400 1,404,383 1,234,962 1,628,067 1,626,155 1,339,965 - - - - - 10,033,116 21,712,067 46%Wastewater/Sewer/Organic ResourcesSewer Repair Insurance 640 21,863 43,609 82,703 50,004 58,271 45,967 38,776 - - - - - 341,195 632,224 54%0621 Sewer Department 641 459,002 1,203,962 636,994 389,786 413,872 473,390 436,562 - - - - - 4,013,569 9,874,691 41%0625 Concrete Crew 641 34,892 33,631 38,464 27,662 28,383 32,747 33,097 - - - - - 228,876 484,265 47%0630 Wastewater Operations 641 1,548,265 1,540,774 4,512,206 3,138,965 2,029,241 4,137,688 2,433,776 - - - - - 19,340,915 38,090,598 51%0631 Organic Resources 641 231,119 149,015 72,550 64,256 142,065 78,536 243,113 - - - - - 980,653 1,670,534 59%0650 Clay Sewage 641 283 (420) - - 196 230 479 - - - - - 769 250 307%Sewage Capital 642 349,920 280,581 15,324 - 81,701 - 352,355 - - - - - 1,079,881 12,314,553 9%Sewage Reserve 643 4,386 8,317 4,240 4,407 4,278 8,614 6,672 - - - - - 40,913 35,000 117%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 - - - - - - 146 - - - - - 146 150 98%2012 Sewer Bond 661 - 501,426 - 126,788 - - 17,136 - - - - - 645,350 649,686 99%Sub Total2,650,730 3,761,396 5,362,482 3,801,869 3,759,658 4,777,173 3,562,112 - - - - - 27,675,419 72,908,330 38%Total Public Works 5,507,832 6,989,548 8,247,829 6,277,265 6,752,486 8,168,227 7,267,854 - - - - - 49,211,042 120,145,315 41%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: July 31, 2018Capital & Debt Service Fund2017 Parks Bond Debt Service 312 - - - - - - 593,304 - - - - - 593,304 595,304 100%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 - - - - 352,680 - - - - - 814,870 814,870 100%Coveleski Stadium 401 - - - - - - - - - - - - - 90,000 0%COIT 404 651,760 1,218,145 1,190,526 388,527 408,002 1,015,038 961,013 - - - - - 5,833,011 12,001,673 49%Cumulative Capital Development 406 195,231 27,896 - 10,711 - - 195,231 - - - - - 429,068 459,200 93%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 672,504 - - - - - 5,406,030 12,214,594 44%UDAG 410 - 31,814 - 33,602 - - 33,602 - - - - - 99,017 610,131 16%Major Moves 412 979 94,995 267,049 113 108,825 - 120,795 - - - - - 592,755 2,573,799 23%Morris PAC Improvement 416 - - 39,497 2,545 41,873 - 4,144 - - - - - 88,059 184,100 48%Palais Historic Preservation 450 - - - - - - - - - - - - - 45,000 0%2018 Fire Station #9 Capital 451 - - - 138,575 - - 109,679 - - - - - 248,254 - NA 2017 Parks Bond 471 - 17,750 - - 295,720 73,560 40,725 - - - - - 427,755 10,309,100 4%Hall of Fame Capital 677 5,294 8,730 4,224 3,185 1,395 1,340 1,215 - - - - - 25,383 129,227 20%Equipment / Vehicle Leasing 750 - - 1,238,339 130,671 711,929 236,789 982,473 - - - - - 3,300,202 9,457,649 35%Parks Bond Capital 751 - 142,569 742,870 417,001 249,750 24,628 6,099 - - - - - 1,582,917 3,136,530 50%Smart Street Bond Capital 753 - 12,431 5,592 3,843 5,791 823,953 119,252 - - - - - 970,862 2,101,500 46%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 - - - - - - 2,282,639 - - - - - 2,282,639 39,103,750 6%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 6,475,354 - - - - - 25,827,886 101,532,846 25%Department of Community InvestmentStudebaker/Oliver 209 14,869 3,179 1,898 14,992 10,985 1,283 3,888 - - - - - 51,093 1,078,598 5%State Grant 210 - - 18,003 - 18,003 - 55,662 - - - - - 91,667 257,133 36%DCI Operating 211 199,829 228,512 228,504 257,362 234,160 276,492 238,375 - - - - - 1,663,233 3,077,096 54%Programs 212 242,431 218,522 64,822 268,529 186,255 334,220 621,769 - - - - - 1,936,549 5,874,598 33%Total Dept of Community Investment 457,129 450,212 313,226 540,884 449,403 611,994 947,820 - - - - - 3,770,668 10,287,425 37%Central Services0605 Equipment Services 222 255,181 234,013 180,814 189,297 227,444 230,621 227,153 - - - - - 1,544,523 3,072,612 50%0606 Building Maintenance 222 17,233 17,032 17,679 16,050 16,278 21,870 16,562 - - - - - 122,705 213,832 57%0612 Central Stores 222 19,345 19,143 19,527 18,754 19,731 27,028 18,750 - - - - - 142,278 236,428 60%0613 Print Shop 222 10,612 9,948 11,992 9,965 9,512 20,670 10,665 - - - - - 83,365 192,329 43%0614 Radio Shop 222 22,971 23,167 22,527 22,416 20,738 29,306 19,990 - - - - - 161,114 336,927 48%0616 Energy/Sustainability 222 15,261 25,951 13,856 43,320 25,024 29,390 22,828 - - - - - 175,630 380,560 46%0617 Electric & Gas Utilities 222 363,766 477,069 394,275 336,686 387,629 328,060 388,598 - - - - - 2,676,082 4,375,000 61%Central Services Capital 224 22,614 16,567 - 2,100 32,979 2,550 5,711 - - - - - 82,521 155,036 53%Total Central Services 726,982 822,890 660,670 638,589 739,334 689,497 710,256 - - - - - 4,988,219 8,962,724 56%Liability Insurance0403 Self Funded Liability Ins 226 19,540 16,545 17,760 17,369 15,908 22,308 17,054 - - - - - 126,483 262,724 48%0412 Liability Insurance 226 43,410 151,831 84,217 253,106 308,425 69,711 69,406 - - - - - 980,106 2,058,406 48%0417 Business Insurance 226 18,256 14,875 16,075 5,459 45,758 138,200 425,292 - - - - - 663,914 690,694 96%0418 Workers Compensation 226 59,655 260,416 142,763 132,349 88,620 91,198 120,858 - - - - - 895,859 680,717 132%0419 Catastrophic Events 226 - - - - - 9,668 - - - - - - 9,668 - NA Total Liability Insurance 140,861 443,667 260,814 408,283 458,711 331,085 632,609 - - - - - 2,676,030 3,692,541 72%Code EnforcementUnsafe Building 219 54,128 47,800 43,198 47,964 48,180 47,670 55,378 - - - - - 344,317 972,413 35%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 173,743 - - - - - 1,006,860 1,835,827 55%1207 Animal Care & Control 600 62,449 81,335 66,239 68,463 64,068 78,084 64,367 - - - - - 485,007 968,596 50%1208 Rental Unit Inspection 600 - - 51 (51) - 5,134 6,953 - - - - - 12,088 180,000 7%Total Code Enforcement 292,999 255,982 232,803 226,239 242,458 297,354 300,441 - - - - - 1,848,277 3,957,836 47%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: July 31, 2018Building Department1306 Building Dept Operations 600 171,357 103,354 107,540 107,639 111,228 144,510 132,044 - - - - - 877,671 1,658,827 53%Total Building Department 171,357 103,354 107,540 107,639 111,228 144,510 132,044 - - - - - 877,671 1,658,827 53%OtherMiscellaneousGift, Donation, Bequest 217 3,461 - (3,461) 350 338 7,970 1,619 - - - - - 10,278 43,428 24%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 82,510 - - - - - 572,661 4,213,349 14%Human Rights 258 14,012 1,644 9,448 13,219 22,020 12,108 11,228 - - - - - 83,678 163,234 51%IT / Innovation /311 Call Center 279 235,061 632,764 405,139 375,321 766,827 386,933 441,065 - - - - - 3,243,112 7,155,112 45%Sub Total443,200 724,801 540,657 415,995 931,630 471,582 536,422 - - - - - 4,064,288 12,090,446 34%Fiduciary Trust & AgencyFire Pension 701 373,509 517,553 378,759 376,521 377,630 383,979 384,851 - - - - - 2,792,803 5,112,457 55%Police Pension 702 593,204 510,652 509,711 520,228 510,146 506,002 506,180 - - - - - 3,656,122 6,583,452 56%Employee Benefits 711 1,436,330 941,195 1,462,636 1,290,461 1,505,457 818,176 1,461,533 - - - - - 8,915,786 18,145,518 49%Unemployment Comp 713 - 565 5,094 4,483 4,630 3,386 1,728 - - - - - 19,886 80,000 25%Parental Leave Fund 714 - 1,765 12,094 9,025 9,143 14,215 13,384 - - - - - 59,626 155,694 38%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 2,367,676 - - - - - 15,444,223 30,102,121 51%Total Other 2,846,243 2,696,530 2,908,950 2,616,713 3,338,636 2,197,339 2,904,099 - - - - - 19,508,511 42,192,567 46%Total Civil City 19,886,217 21,001,989 29,201,445 19,626,953 21,918,671 25,610,942 27,401,635 - - - - - 164,647,852 397,147,503 41%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 3,000,956 - - - - - 16,058,156 45,356,182 35%TIF West Washington 422 - 74,176 12,194 28,698 39,016 - 30,244 - - - - - 184,329 1,885,916 10%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 14,037 - - - - - 619,134 7,587,691 8%TIF Southside 430 3,188 9,734 36,978 19,564 38,151 66,373 40,814 - - - - - 214,800 7,556,026 3%TIF Erskine Village 432 - - - - - - - - - - - - - - NA TIF Douglas Road 435 - - - - - - - - - - - - - 144,650 0%TIF River East RES (NE RE) 436 1,234,500 875,136 - - - - 246,664 - - - - - 2,356,300 4,320,000 55%Sub Total5,529,466 2,891,606 2,856,530 1,205,339 999,296 2,654,670 3,332,714 - - - - - 19,469,621 67,008,631 29%Redevelopment FundsAdministration 433 - - - - 561 - 1,333 - - - - - 1,894 4,500 42%Certified Technology Park 439 - - - - - - - - - - - - - - NA 2018 TIF Park Bond Capital 452 - - - - 169,947 28,424 15,625 - - - - - 213,995 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 8,831 - - - - - 47,157 157,000 30%Sub Total- 5,832 7,415 8,250 179,233 36,528 25,789 - - - - - 263,046 11,144,282 2%Debt ServiceAirport Debt Reserve 2003 315 884 1,677 853 849 825 1,660 1,286 - - - - - 8,034 14,000 57%Coveleski Bond Debt Reserve 317 - - - - - - - - - - - - - - NA Central Development reserve 328 1,478 2,803 1,427 1,420 1,378 2,775 2,149 - - - - - 13,431 20,000 67%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,435 - - - - - 3,034,079 5,109,623 59%Total Redevelopment 5,531,828 2,901,918 5,203,062 1,540,079 1,180,731 3,047,189 3,361,938 - - - - - 22,766,745 83,262,536 27%Total Expenditures 25,418,045 23,903,907 34,404,507 21,167,031 23,099,403 28,658,131 30,763,573 - - - - - 187,414,597 480,410,039 39%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: July 31, 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: July 31, 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 346,724.76 - 3,175.76 0.01 349,900.52 1122013 Building Department Ricoh Copier Copier Lease2013 N/A 2018 600 Monthly 26th -- -- 4,093.64 613.22 535.31 - 12.44 77.91 547.75 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,248.30 - 46.70 906.61 1,295.00 1182013 Water Works Main Street Ricoh Copier Copier Lease2013 N/A 2018 620 Monthly 10th -- -- 5,647.50 1,258.33 725.00 - 30.65 533.33 755.65 1192013 Water Works Colfax Ricoh Copier Copier Lease2013 N/A 2018 620 Monthly 16th -- -- 4,732.65 1,054.61 607.54 - 25.68 447.07 633.22 1202013 Water Works Olive Street Ricoh Copier Copier Lease2013 N/A 2018 620 Monthly 10th -- -- 4,732.65 1,054.61 607.54 - 25.68 447.07 633.22 1232014 Police Department Training Ricoh Copier Copier Lease2014 N/A 2019 101 Monthly 30th -- -- 4,263.00 1,186.17 542.79 - 31.21 643.38 574.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 16,874.53 - 537.65 11,231.90 17,412.18 1262014 HP Computer Lease #2 Computer Leases2014 N/A 2018 Various Monthly 8th -- -- 4,000.00 915.42 575.02 - 20.26 340.40 595.28 1272014 HP Computer Lease #4 Computer Leases2014 N/A 2018 279 Monthly 8th -- -- 5,886.73 1,262.39 852.41 - 20.28 409.98 872.69 1282014 HP Computer Lease #6 Computer Leases2014 N/A 2018 201 Monthly 8th -- -- 3,755.50 959.08 537.61 - 20.71 421.47 558.32 1292014 HP Computer Lease #7 Computer Leases2014 N/A 2018 620 Monthly 8th -- -- 1,326.00 363.78 190.22 - 6.27 173.56 196.49 1302014 Solid Waste Ricoh Copier Copier Lease2014 N/A 2019 611 Monthly 17th -- -- 5,351.65 2,230.54 653.45 - 63.84 1,577.09 717.29 1312014 Police Communications Copier Copier Lease2014 N/A 2019 101 Monthly 12th -- -- 8,843.00 3,072.55 1,099.37 - 85.87 1,973.18 1,185.24 1322014 Ricoh Copiers Copier Lease2014 N/A 2019 641 Monthly 21st -- -- 12,260.16 4,044.71 1,532.39 - 110.86 2,512.32 1,643.25 1342014 Water Works Ricoh Copier Copier Lease2014 N/A 2019 620 Monthly 19th -- -- 4,732.65 1,139.81 604.75 - 28.47 535.06 633.22 1362015 HP Computer Lease #8 Computer Leases2015 N/A 2019 Various Monthly 16th -- -- 19,603.94 6,927.09 2,754.92 - 180.74 4,172.17 2,935.66 1372015 Animal Care & Control Ricoh Copier Copier Lease2015 N/A 2020 600 Monthly 30th -- -- 5,261.50 2,558.51 629.89 - 79.35 1,928.62 709.24 1382015 HP Computer Lease #9 Computer Leases2015 N/A 2019 Various Monthly -- -- -- 135,958.05 63,804.73 18,747.14 - 1,613.76 45,057.59 20,360.90 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 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 494.32 - 81.22 2,150.35 575.54 1472016 Central Services - Print Shop Copier Copier Lease2016 N/A 2020 222 Monthly -- -- -- 32,525.00 22,620.32 3,693.50 - 632.36 18,926.82 4,325.86 1482016 Central Services - Print Shop Copier Copier Lease2016 N/A 2020 222 Monthly -- -- -- 11,413.00 7,937.47 1,296.04 - 221.91 6,641.43 1,517.95 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,366.20 - 249.00 7,738.88 2,615.20 1512016 Administration & Finance Copier Copier Lease2016 N/A 2021 101 Monthly -- -- -- 10,923.63 6,891.18 1,248.35 - 213.04 5,642.83 1,461.39 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 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 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 20,350.64 - 3,088.65 96,644.72 23,439.29 1572016 Ricoh Copier MPC2003 Copier Lease2016 N/A 2021 201 Monthly -- -- 3,184.06 2,265.55 352.66 - 102.69 1,912.89 455.35 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 2,143.07 - 483.89 10,273.97 2,626.96 1602017 HP Computer Lease #14 Computer Leases2017 N/A 2021 Various Monthly -- -- -- 10,305.25 8,452.80 1,339.15 - 209.53 7,113.65 1,548.68 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 15,654.79 - 3,002.89 85,623.84 18,657.68 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 - 480.09 9,092.00 100.41 8,611.91 580.50 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 - 1,408.86 27,101.47 206.94 25,692.61 1,615.80 Total City Capital Lease Debt32,170,328.46 15,946,280.30 3,174,091.53 8,344,201.58 201,793.27 21,116,390.35 3,375,884.80 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 - - 20,050.00 2,005,000.00 20,050.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 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 - 148,610.00 7,010,000.00 783,610.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 225,000.00 - 87,052.50 4,695,000.00 312,052.50 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 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.82 4,970,000.00 120,662.82 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,685,000.00 17,040,000.00 2,529,343.76 167,208,855.00 4,214,343.76 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 99,016.70 - - 867,317.80 99,016.70 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 - Total City Interfund Loan Debt9,711,910.00 4,155,367.00 475,433.53 - 116,911.17 3,679,933.47 592,344.70 City of South BendPeriod Ending: July 31, 2018Debt Payments Year-to-DateDebtSched.Debt Instrument Debt PurposeYear ofIssueYear ofRefinanceYear ofMaturityFundNo.Debt at07/31/18Total YTDDebt PaymentsScheduled PaymentsAmountIssuedDebt at12/31/17YTD PrincipalPayments2018AdditionsYTD InterestPaymentsMonthly Financial Report18 of 24 1st 2nd 3rd 4thCity of South BendPeriod Ending: July 31, 2018Debt Payments Year-to-DateDebtSched.Debt Instrument Debt PurposeYear ofIssueYear ofRefinanceYear ofMaturityFundNo.Debt at07/31/18Total YTDDebt PaymentsScheduled PaymentsAmountIssuedDebt at12/31/17YTD PrincipalPayments2018AdditionsYTD InterestPaymentsLoan 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 5,358,546.06 25,384,201.58 2,954,793.32 198,578,684.82 8,313,339.38 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 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/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 - 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 - - 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 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 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 4,055,000.00 - 1,507,583.88 73,355,000.00 5,562,583.88 Total Redevelopment Commission Debt137,975,278.00 79,319,798.58 4,254,912.69 - 1,543,676.41 75,064,885.89 5,798,589.10 Total Debt413,297,509.96 257,872,827.88 9,613,458.75 25,384,201.58 4,498,469.73 273,643,570.71 14,111,928.48 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 7 101-0201 City Clerk 5 5 5 5 5 5 5 5 101-0301 Common Council 9 9 9 9 9 8 9 9 101-0401 Administration & Finance 24 21 22 24 24 22 23 23 101-0404 Morris PAC 7 7 7 7 7 7 7 7 101-0405 Palais Royale 2 2 2 2 2 2 2 2 101-0501 Legal Dept 10 10 9 9 10 10 10 10 101-0602 Engineering Dept 21 22 22 22 22 22 22 22 101-0801 Police Dept 248 242 242 244 243 243 243 243 101-0901 Fire Dept 178 184 184 186 186 184 182 182 101-1008 Human Rights 4 4 4 4 4 4 4 4 515 513 513 519 519 514 514 514 - - - - - 201 - Parks & Recreation201-1100 Administration 6 7 7 7 7 6 6 6 201-1101 Maintenance 47 49 49 48 48 48 48 48 201-1102 Golf Courses 8 8 8 8 8 8 8 8 201-1103 Recreation 21 21 21 20 19 21 21 21 201-1104 Potawatomi Zoo 1 1 1 1 1 1 - - 201-1108 Graffiti Removal 1 1 1 1 1 1 1 1 201-1110 Marketing & Events 11 10 10 10 11 11 11 11 95 97 97 95 95 96 95 95 - - - - - 202 - Motor Vehicle Highway202-0607 Street Department 51 48 47 46 45 48 49 47 202-0619 Curb & Sidewalk Program 5 5 5 5 5 5 5 5 56 53 52 51 50 53 54 52 - - - - - 203 - Recreation Non-Reverting203-1103 Recreation1 - - 1 1 1 1 1 211 - Dept of Community Investment Administration211-1001 DCI25 24 24 25 25 25 25 26 219 - Unsafe Building219-1209 NEAT Crew4 4 4 4 4 2 3 3 222 - Central Services222-0605 Equipment Services 32 28 28 27 26 27 25 26 222-0606 Building Maintenance 3 3 3 3 3 3 3 3 222-0612 Central Stores 2 4 4 4 4 4 4 4 222-0613 Print Shop 1 1 1 1 1 1 1 1 222-0614 Radio Shop 3 3 3 3 3 3 3 3 222-0616 Office of Sustainability 2 2 2 2 2 2 2 2 43 41 41 40 39 40 38 39 - - - - - 226 - Liability Insurance226-0403 Safety & Risk 2 2 2 2 2 2 2 2 226-0412 Liability Insurance 1 1 1 1 1 1 1 13 3 3 3 3 3 3 3 - - - - - Period Ending: July 31, 2018Monthly Financial Report20 of 24 City of South BendStaffing HeadcountPeriod Ending: July 31, 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 42 249-0905 Fire Department 35 35 35 34 34 34 34 34 78 78 78 77 77 76 76 76 - - - - - 258 - Human Rights Grants258-1009 HUD1 1 1 1 1 1 1 1 279 - IT / Innovation / 311 Call Center279-0104 311 Call Center 7 7 7 7 7 7 7 7 279-0672 Innovation & Technology 20 17 17 19 19 19 19 19 27 24 24 26 26 26 26 26 - - - - - 288 - Emergency Medical Services288-0902 EMS51 48 48 48 47 46 46 46 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce. 16 16 16 16 16 16 16 15 600-1207 Animal Care & Control 8 8 8 8 8 7 8 8 600-1208 Rental Unit Inspection 2 - - - - 2 2 2 600-1306 Building Department 15 13 13 14 14 14 14 14 41 37 37 38 38 39 40 39 - - - - - 610 - Solid Waste610-0610 Solid Waste24 22 22 23 24 23 20 21 620 - Water Works O&M620-0640 Water Works67 66 66 66 66 65 61 63 640 - Sewer Insurance640-0620 Sewer Repair2 2 2 2 2 2 2 2 641 - Sewage Works O&M 641-0621 Sewer Department 35 35 35 35 35 34 34 36 641-0625 Concrete Crew 3 3 3 3 3 3 2 2 641-0630 Wastewater Department 46 44 45 43 43 43 43 43 641-0631 Organic Resources 6 6 6 6 6 6 6 6 90 88 89 87 87 86 85 87 - - - - - 670 - Century Center670-0406 Century Center7 - - 6 6 7 7 7 Total Full-Time Employees by Fund1,130 1,101 1,101 1,112 1,110 1,105 1,097 1,101 - - - - - Monthly Financial Report21 of 24 City of South BendStaffing HeadcountPeriod Ending: July 31, 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 7 City Clerk 5 5 5 5 5 5 5 5 Common Council 9 9 9 9 9 8 9 9 Administration & Finance 24 21 22 24 24 22 23 23 Legal Dept 10 10 9 9 10 10 10 10 55 52 52 54 55 52 54 54 - - - - - Code Enforcement / Animal Care & Control30 28 28 28 28 27 29 28 - - - - - Dept. of Community Investment25 24 24 25 25 25 25 26 - - - - - Venues, Parks & ArtsParks & Recreation 96 97 97 96 96 97 96 96 Morris PAC & Palais Royale 9 9 9 9 9 9 9 9 Century Center 7 - - 6 6 7 7 7 112 106 106 111 111 113 112 112 - - - - - Public SafetyPolice - Sworn Officers 248 241 241 230 229 228 239 239 Police - Civilians 43 44 44 49 49 49 44 44 Police - Police Recruit - - - 8 8 8 2 2 Fire/EMS - Sworn Firefighters 257 260 260 254 253 250 248 248 Fire/EMS - Civilians 7 7 7 7 7 7 7 7 Fire/EMS - Fire Recruits - - - 7 7 7 7 7 555 552 552 555 553 549 547 547 - - - - - Public WorksOffice of Sustainability 2 2 2 2 2 2 2 2 Engineering Dept 21 22 22 22 22 22 22 22 Streets & Sewers 96 93 92 91 90 92 92 92 Solid Waste 24 22 22 23 24 23 20 21 Wastewater Department 46 44 45 43 43 43 43 43 Organic Resources 6 6 6 6 6 6 6 6 Water Works 67 66 66 66 66 65 61 63 262 255 255 253 253 253 246 249 - - - - - Liability Insurance/Safety & Risk3 3 3 3 3 3 3 3 - - - - - Innovation & Technology / 311 Call Center27 24 24 26 26 26 26 26 - - - - - Central Services 41 39 39 38 37 38 36 37 - - - - - Building Department15 13 13 14 14 14 14 14 - - - - - Human Rights 5 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 1,101 - - - - - Monthly Financial Report22 of 24 City of South BendStaffing HeadcountPeriod Ending: July 31, 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 1 101-0401 Admin & Finance - - 1 1 1 1 1 101-0404 Morris PAC 3 3 4 4 4 4 4 101-0501 Legal Dept 2 2 1 1 2 1 1 101-0602 Engineering Dept 4 4 4 4 3 3 3 101-0801 Police Dept 25 25 22 26 25 5 5 34 34 33 37 36 15 15 - - - - - 201 - Parks & Recreation201-1100 Administration 1 1 1 1 1 1 1 201-1101 Maintenance 7 7 9 9 10 9 9 201-1102 Golf Courses - - 32 38 47 50 50 201-1103 Recreation 18 18 21 20 27 28 28 201-1108 Graffiti Removal 1 1 - - - - - 27 27 63 68 85 88 88 - - - - - 202 - Motor Vehicle Highway202-0607 Street Department4 4 4 5 5 5 4 203 - Recreation Non-Reverting203-1103 Recreation25 25 19 21 21 21 21 211 - Dept of Community Investment Administration211-1001 DCI1 - - - - - - 222 - Central Services222-0605 Equipment Services1 1 1 1 1 1 1 279 - IT / Innovation / 311 Call Center279-0104 311 Call Center1 1 1 1 1 1 1 288 - Emergency Medical Services288-0902 EMS1 1 1 1 1 1 1 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce. 2 3 3 3 3 3 3 600-1207 Animal Care & Control 2 2 2 2 2 2 2 4 5 5 5 5 5 5 - - - - - 620 - Water Works O&M620-0640 Water Works3 3 3 3 3 3 3 641 - Sewage Works O&M 641-0621 Sewer Department4 4 4 3 3 3 2 670 - Century Center670-0406 Century Center- - 6 5 8 8 8 Total Part-Time Employees by Fund105 105 140 150 169 151 149 - - - - - Monthly Financial Report23 of 24 City of South BendStaffing HeadcountPeriod Ending: July 31, 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 1 101-0201 City Clerk - - - - - 4 4 101-0301 Common Council - - - - 1 - - 101-0401 Admin & Finance - - - - 2 2 2 101-0602 Engineering Dept - - - - 5 5 5 101-0801 Police Dept - - 1 1 1 15 15 - - 1 1 10 27 27 - - - - - 201 - Parks & Recreation201-1100 Administration 1 1 - - - - - 201-1101 Maintenance - - 7 15 30 36 36 201-1102 Golf Courses - - - - 2 2 2 201-1103 Recreation - - 1 1 39 95 95 1 1 8 16 71 133 133 - - - - - 202 - Motor Vehicle Highway202-0607 Street Department - - - - 1 2 2 202-0619 Curb & Sidewalk Program - - 2 3 3 3 3 - - 2 3 4 5 5 - - - - - 203 - Recreation Non-Reverting203-1103 Recreation2 2 - 5 25 26 26 222 - Central Services222-0605 Equipment Services - - 1 1 2 2 2 222-0606 Building Maintenance 1 1 - - - - - 222-0616 Office of Sustainability - - - - 1 1 1 1 1 1 1 3 3 3 - - - - - 600 - Consolidated Building Dept.600-1207 Animal Care & Control- - - - 1 1 1 620 - Water Works O&M620-0640 Water Works- - - - - 3 3 641 - Sewage Works O&M 641-0621 Sewer Department1 1 2 2 3 2 2 Total Paid Temporary, Seasonal, and Intern Staff5 5 14 28 117 200 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 1,101 - - - - - Part Time Staff 105 105 140 150 169 151 149 - - - - - Temporary / Seasonal 5 5 14 28 117 200 200 - - - - - City Total1,130 1,211 1,211 1,266 1,288 1,391 1,448 1,450 - - - - - Monthly Financial Report24 of 24