Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-09 Financial Report
Period Ending: Issued By: City of South Bend Financial Report Tab Page Contents Narrative 2 Brief discussion on notable fund activity Revenue 3-10 City Revenues Prop Tax Rev 11-12 Property Tax Revenue Collection Status Expenditures 13-17 Expenditures by Fund and Department Debt 18-19 Debt Status Debt Monthly 20-21 Current Debt at Month End Headcount 22-25 Staffing Levels Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg South Bend Common Council Members Administration and Finance Department Heads Fiscal Officers September 30, 2017 Controller 2017-09 Financial Report Page 1 of 25 September 30, 2017 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 Revenue by Fund -Fund 291 (River Rescue), is at 99% of its budgeted revenue. This is revenue related to tuition fees for the river rescue class. -Fund 216 (Police Seizures) is at 113% of its budgeted revenue. This is revenue from confiscated property. -Fund 294 (Police Academy). This is revenue related to the advancement of present and future police officers. -Fund 221(Landlord Registration), is at 70% of its budgeted revenue. This is revenue received from an Ordinance enacted by the Common Council in 2016. Property Taxes Expenditures Debt Headcount If you have any questions regarding this report, please contact the Department of Administration and Finance at (574) 235-9216. As of September 2017,the City has spent 57%of budgeted expenditures,compared to 56%last year.The General Fund has spent 67% of its 2017 budgeted expenditures,compared to 70%in 2016.The following funds have reached 70%or more of their budgeted expenditures as a result of bond payments:Fund 313(Hall of Fame),Fund 377(Professional Sports Development),and Fund 432(TIF- Erskine Village). This month,various debt service payments were made in the amount of~$106,000 Ricoh USA.Payments are related to IT equipment leases. St. Joseph County PSAP, Indiana Finance Authority, and Transpo. The Full Time Headcount as of September was 1,092 vs.a budgeted amount of 1,107.Currently,there are a total of 15 vacant positions. The 15 open positions are in the following departments:General Government(1),Parks(3),Public Safety(3),Public Works(3),DCI(3), Morris and Palais (1), and Human Rights Commission (1). For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 75%,compared to 71%in September 2016.Revenue types 369(Memorial Hospital)335(State Pension Subsidy and Gaming Proceeds) and 317 (Hotel / Motel Tax) have all reached 100% of their budgeted revenue. As of September 2017,the general fund has reached 60%of its budgeted revenue,similar to last year.The following funds have reached slightly above the normal percentage of their 2017 budgeted revenue amount at this time: Property taxes are received in June and December.Property taxes collected this month totaled~$41.8 million.Civil city funds received ~$27.5 million and TIF funds received~$14.3 million.For 2017,the projected levy collection rate is 95%or$75.6 million.Please note, 2017 civil city funds are budgeted to be ~$400,000 more than 2016 budget. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. 2017-09 Financial Report Page 2 of 25 City of South Bend Period Ending:September 30, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Property Tax 311 Property Tax Civil City various- - - - - 27,489,054 - - - - - 27,489,054 49,770,000 55% 311 Property Tax TIF Districts various- - - - - 14,314,504 - - - - - 14,314,504 27,254,124 53% Sub Total- - - - - 41,803,558 - - - - - - 41,803,558 77,024,124 54% Income Tax 315 Econ Development Income Tax 408 883,344 883,344 866,667 866,667 866,667 866,667 866,667 866,667 866,667 - - - 7,833,359 10,433,361 75% 316 Local Option Income Tax - PS 249 622,302 622,302 622,302 622,302 622,302 622,302 622,302 622,302 622,302 - - - 5,600,714 7,467,618 75% 316 County Option Income Tax 404 871,605 871,605 871,605 871,605 871,605 871,605 871,605 871,605 871,605 - - - 7,844,449 10,459,265 75% Sub Total 2,377,250 2,377,250 2,360,574 2,360,574 2,360,574 2,360,574 2,360,574 2,360,574 2,360,574 - - - 21,278,521 28,360,244 75% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - 1,680,548 - - - - - - 1,680,548 3,206,500 52% 312 Commercial Vehicle Tax various- - - - - 402,188 - - - - - - 402,188 843,000 48% 317 Hotel Motel Tax Century Center 670 637,500 - (318,750) 106,250 106,250 106,250 106,250 106,250 106,250 - - - 956,250 1,275,000 75% 317 Hotel Motel Tax Century Center 324- - - 197,500 - - - - - - - - 197,500 394,000 50% 317 Hotel Motel Tax Cum Cap Imprv 407 150,000 - - - - - - - - - - - 150,000 150,000 100% Sub Total 787,500 - (318,750) 303,750 106,250 2,188,986 106,250 106,250 106,250 - - - 3,386,486 5,868,500 58% State of Indiana (Remitted by) 335 Cigarette Tax 101/407- - - - - 148,523 - - - - - - 148,523 328,000 45% 335 State Pension Subsidy 701/702- - - - - 5,565,446 - - 5,559,446 - - - 11,124,892 11,124,891 100% 335 Gaming Proceeds 101- - - - - - - - 599,027 - - - 599,027 599,000 100% 335 Gasoline Tax 202/251 361,601 314,230 394,563 456,411 426,999 355,323 422,807 165,846 501,809 - - - 3,399,589 4,668,000 73% 335 Liquor Excise tax 101- 42,158 - - - - 28,925 - - - - - 71,082 75,000 95% 335 Liquor Gallonage Tax 101 63,498 - - 44,056 - - 56,137 - - - - - 163,691 210,000 78% 335 Prof Sports Development Tax 377 62,404 - 115,348 24,070 23,090 - - - - - - - 224,912 700,000 32% 335 Wheel Tax 202- - 503,523 - 451,523 - 372,905 368,811 - - - - 1,696,762 2,050,000 83% Sub Total 487,503 356,388 1,013,434 524,537 901,612 6,069,292 880,773 534,657 6,660,282 - - - 17,428,477 19,754,891 88% Other Intergovernmental Sources 336 Federal Drug 299- - - - - - - - 1,823 - - - 1,823 30,000 6% 337 State Drug 216 10,113 2,962 - 30 1,897 - - - - - - - 15,003 35,000 43% 337 Regional Cities Grant 201- - - - - - - - - - - - - 5,000,000 0% 338 Payment in Lieu of Tax various 517,361 871,113 517,361 871,113 517,361 517,361 517,361 517,361 871,113 - - - 5,717,504 7,623,328 75% 339 Contractual Service 211 9,669 12,407 38,314 17,294 7,957 11,557 7,257 57,569 11,063 - - - 173,083 316,000 55% Sub Total 537,143 886,481 555,675 888,436 527,215 528,918 524,618 574,930 883,999 - - - 5,907,413 13,004,328 45% Charge for Service Internal City 340 Liability Insurance 226 243,168 243,964 241,179 246,749 241,179 246,749 241,179 241,179 241,179 - - - 2,186,525 2,927,591 75% 340 General Government Misc Chgs 101- - - - - - - - - - - - - 500 0% 349 Central Service 222 51,820 48,684 51,854 49,741 49,575 50,298 46,813 59,676 55,927 - - - 464,389 873,809 53% 380 Central Service 222 210,212 208,994 226,075 189,251 209,433 210,487 197,836 222,500 195,631 - - - 1,870,419 2,880,310 65% 380 Energy Office Reimbursements 222 411,202 429,754 368,989 361,064 360,950 322,928 276,803 432,821 355,622 - - - 3,320,132 4,492,800 74% 380 LOIT 2016 Special Distribution 257- - 152,895 - - 52,501 - - 55,792 - - - 261,189 205,397 127% 380 IT Innovation 311 Center 279 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 - - - 3,875,589 5,205,034 74% 380 Beck's Lake Reimbursement 404- - 283,432 - - - - - - - - - 283,432 283,432 100% 380 Insurance Claim various- - - - - - - - 143,523 - - - 143,523 143,523 100% 380 INDOT SR 933 Transfer 251 /324- - - - - - - - - - - - - 4,430,000 0% 380 TIF 324- - - - - - - - 151,064 - - - 151,064 151,065 100% 380 Internal Service Reimbursement various 65,792 89,865 18,297 77,763 111,522 51,754 103,533 49,917 387,855 - - - 956,298 2,408,166 40% 392 Administration Fee 101/279 414,748 414,748 414,748 414,748 414,748 414,748 414,748 414,748 414,748 - - - 3,732,732 4,977,026 75% 392 Internal Fund Transfers various 1,085,348 9,754,150 4,553,299 4,585,904 1,649,180 1,807,518 1,279,407 5,585,586 4,161,903 - - - 34,462,293 41,732,537 83% 395 Employee Benefits 711/713 1,499,317 1,460,178 1,492,929 1,487,450 1,477,818 1,483,231 1,473,862 1,497,421 1,474,726 - - - 13,346,932 17,770,850 75% 2017-09 Fin anc i al Re port - Rev enue Report Page 3 of 25 City of South Bend Period Ending:September 30, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 396 Central Service Refunds 222 1,314 - 62,668 (56,756) 2,392 1,416 - - - - - - 11,033 21,000 53% 396 Self Funded Employee Benefits 711 6,503 (2,436) 496 - - 389 41,857 52,421 5,572 - - - 104,801 46,809 224% xxx xxx xxx- NA Sub Total 4,420,045 13,078,521 8,297,481 7,786,534 4,947,418 5,072,640 4,506,658 8,986,890 8,074,163 - - - 65,170,351 88,549,849 74% 3rd Party Revenue 340 ND EMS Service 288- - 44,904 - 1,338 14,152 2,832 - - - - - 63,226 150,000 42% 350 Job Target Penalty Fee 408- 354,660 - - - - - - - - - - 354,660 354,660 100% 364 Cable TV Franchise Fees 101- 192,238 - - - - - 195,839 - - - - 388,077 748,000 52% 366 AT&T Franchise Fees 101 55,865 - - - 51,778 - - 48,750 - - - - 156,394 284,000 55% 393 Debt Proceeds various- - - - 2,916,500 - - - 26,632,000 - - - 29,548,500 5,499,000 537% Sub Total 55,865 546,898 44,904 - 2,969,616 14,152 2,832 244,589 26,632,000 - - - 30,510,856 7,035,660 434% Grants 331 Federal Grants various 468,447 1,200,229 111,355 149,580 103,356 263,868 96,934 77,343 302,268 - - - 2,773,381 8,916,624 31% 334 State Grants various- - 33,745 5,150 - 137,805 - 275,321 67,600 - - - 519,622 703,499 74% Sub Total 468,447 1,200,229 145,100 154,730 103,356 401,673 96,934 352,664 369,868 - - - 3,293,003 9,620,123 34% Fees for Services External 320 Inspections Central Service 222- - - 450 350 270 - 10 330 - - - 1,410 1,450 97% 321 Business License 101/222 30,917 29,318 15,746 12,407 11,383 4,566 1,656 10,809 7,191 - - - 123,994 129,532 96% 321 Code and Animal Fees 600 4,536 4,585 6,015 5,891 6,975 6,368 7,095 6,521 7,047 - - - 55,031 63,300 87% 322 Building Fees 600 90,363 86,593 108,895 95,111 141,205 195,184 108,715 170,070 124,307 - - - 1,120,442 1,369,350 82% 322 Code Enforcement Fees 600 1,050 300 3,000 1,500 600 2,800 1,200 900 1,200 - - - 12,550 20,000 63% 322 EMS Operating Fund 288 1,923 1,380 1,542 910 2,973 2,613 1,609 3,218 1,380 - - - 17,548 24,238 72% 322 General Government Fees 101 32,047 7,275 12,535 6,200 3,925 4,200 9,080 4,240 4,530 - - - 84,032 106,127 79% 341 General Government Various various 3,316 959 5,210 5,841 1,367 3,126 3,262 982 1,166 - - - 25,229 31,062 81% 342 Highway & Streets 101/202 38,686 - 16,474 2,320 43,516 13,142 - - - - - - 114,139 223,365 51% 342 Public Safety various 12,869 10,404 21,290 12,093 12,302 8,422 10,567 13,087 9,553 - - - 110,588 150,000 74% 342 EMS - County Fees 288- 294,414 147,207 147,207 147,207 147,207 147,207 147,207 147,207 - - - 1,324,864 1,740,000 76% 342 EMS - Capital Fund 287- 1,798,417 - - - - - 1,411,931 - - - - 3,210,349 4,485,349 72% 342 EMS - Operating Fund 288 160,939 235,524 271,371 210,652 215,161 283,974 218,716 352,673 283,950 - - - 2,232,961 2,700,000 83% 342 EMS - Neo Natal / Transport 288 16,185 18,553 16,128 14,553 4,909 167,113 37,377 46,570 34,401 - - - 355,789 1,699,512 21% 344 Solid Waste 610 445,203 460,843 468,017 403,574 285,268 412,168 416,424 414,479 415,555 - - - 3,721,531 5,636,175 66% 344 Code Environmental Clean Up 101/219/600 12,404 3,044 22,134 17,648 11,871 19,048 13,263 13,913 16,730 - - - 130,054 254,258 51% 344 Sewage Waste Water 641 3,208,590 3,128,008 3,112,534 3,105,650 3,096,610 3,192,879 3,215,485 3,301,710 3,280,685 - - - 28,642,150 37,121,004 77% 344 Sewer Repair Insurance 640 53,614 52,952 53,742 52,772 52,682 55,215 52,659 52,452 53,412 - - - 479,500 613,924 78% 344 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 81,942 82,009 81,955 - - - 734,828 980,000 75% 346 Water Works Utility 620 1,039,872 1,012,523 1,016,299 1,006,997 1,032,846 1,254,697 1,441,297 1,448,047 1,454,002 - - - 10,706,580 14,605,122 73% 346 Solid Waste Misc 610 1,504 10,324 12,564 40,321 44,124 42,440 42,652 43,023 43,931 - - - 280,882 240,000 117% 346 Project ReLeaf 655 36,802 36,730 36,817 36,854 37,012 37,156 37,164 37,212 37,209 - - - 332,956 440,153 76% 347 Parks & Recreation various 74,837 77,843 366,527 173,383 231,644 355,839 316,702 486,025 242,812 - - - 2,325,612 4,580,045 51% 347 Sale of Merchandise 101- - - - - 70 - - - - - - 70 100 70% 347 Morris PAC 416- 12,214 13,143 11,334 5,563 2,871 4,291 1,840 594 - - - 51,850 100,000 52% 349 Parking Garage Fees 601 115,464 73,834 83,097 119,933 135,473 65,973 116,506 39,938 61,382 - - - 811,599 1,000,729 81% 349 Code Demolition Board Up 219/600 2,805 2,067 13,981 5,115 1,466 20,689 12,810 3,414 20,141 - - - 82,487 103,000 80% 349 Parking Century Center 670 12,814 19,676 20,911 11,526 7,998 3,915 2,900 84,539 11,215 - - - 175,493 100,033 175% 349 Parking SBCDA 324/429 350 700 350 350 350 350 - - - - - - 2,450 8,400 29% 351 Fines & Fees various 27,430 36,628 37,210 30,621 38,987 57,046 17,958 14,697 11,990 - - - 272,567 348,635 78% 352 Forfeits various 734 616 3,897 5,014 1,556 23,381 8,542 456 3,570 - - - 47,767 200,500 24% 354 Ordinance Violation various 5,163 7,326 9,708 (3,068) 2,333 2,278 8,232 11,059 8,511 - - - 51,541 102,176 50% 360 Morris PAC various 10,087 86,686 184,282 72,560 46,729 117,156 32,782 17,918 62,083 - - - 630,282 976,000 65% 360 Palais Royale various 24,371 4,131 9,256 7,929 19,759 18,450 34,802 37,340 18,800 - - - 174,839 256,572 68% 360 Parks & Recreation various 9,055 4,207 4,552 9,758 3,205 5,864 4,035 1,982 11,374 - - - 54,032 98,206 55% 360 Police various 4,432 3,558 7,482 1,016 759 14,104 1,717 80,829 23,808 - - - 137,707 25,000 551% 360 Fire various- 37,987 - - - - 9 - - - - - 37,996 - NA 360 TIF various 31,545 2,510 6,859 2,110 2,110 309,933 2,273 154,051 2,110 - - - 513,499 637,204 81% 360 Central Services 222 608 - 50 251 623 57 179 7,784 - - - - 9,552 11,000 87% 360 Century Center 670- 120 578 303 - - - - - - - - 1,000 10,000 10% 360 Dept. Of Community Investment 211/212 65,547 23 - 67,821 291 119,174 55 116,427 641 - - - 369,979 315,838 117% 360 EMS Operating Fund 288 525 - - - 72 - 2,593 - 25 - - - 3,215 5,000 64% 360 Engineering / Curb & Sidewalk 101- 50 50 - 125 275 275 100 125 - - - 1,000 11,000 9% 360 Fire and Police Pension Fund 701/702 1,523 675 5,700 565 595 5,022 290 120 79 - - - 14,568 2,000 728% 360 Industrial Revolving 754- - 3,703 1,121 - - - - - - - - 4,824 27,000 18% 360 General Government Various 101/3/226 13,427 24 266 148 244 - 241 24 874 - - - 15,250 14,000 109% 360 Motor Veh Highway Scrap Metal 202 285 - 1,117 209 1,515 711 - 393 - - - - 4,231 4,896 86% 360 Motor Veh Highway Curb Prgm 202 11 - - 1,366 - - - - - - - - 1,377 32,000 4% 360 Local Roads and Streets 251- 274 - - - 3,812 - 4,422 - - - - 8,508 275 3094% 360 Professional Sports Development 377 17,864 - - - - - 14,460 - - - - - 32,324 30,000 108% 2017-09 Fin anc i al Re port - Rev enue Report Page 4 of 25 City of South Bend Period Ending:September 30, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 360 C.O.I.T.404 725 - 1,450 5,051 - - - - - - - - 7,226 - NA 360 Code / Animal Control 600 170 5 - - 181 - - - - - - - 356 6,500 5% 360 Building Fees 600- - - 898 - - - - 1,050 - - - 1,948 - NA 360 Parking Garage 601 20 - 180 - 96 - - - 4,423 - - - 4,719 11,282 42% 360 Solid Waste Fund 610- 265 - 2,357 - 229 - - - - - - 2,850 2,650 108% 360 Waste Water 641/7/9- 3,437 - 5,103 4,546 4,002 690 41,171 - - - - 58,949 52,500 112% 360 Water Works Utility 620 / 625- 39 18 2,167 2,237 12,780 25 1,723 28 - - - 19,017 37,751 50% 360 Sewage Depreciation Fund 642- 400,000 - - - - - - - - - - 400,000 400,000 100% 360 Equipment / Vehicle Leasing 750- - - - - - 161,154 (161,154) - - - - - - NA 360 Smart Street Bond Cap 753- - - - - - - 20,000 - - - - 20,000 20,000 100% 362 Dept. Of Community Investment 212 1,847 - - 1,847 - - - 1,847 - - - - 5,540 7,387 75% 362 Palais Royale 101- 5,114 1,940 1,745 11,426 11,032 10,491 11,008 4,326 - - - 57,082 82,500 69% 362 Police 101- - - 7,238 - - - - 14,475 - - - 21,712 48,000 45% 362 Parks & Recreation 201 3,786 3,545 5,828 3,970 6,820 6,514 4,422 8,432 1,511 - - - 44,828 45,500 99% 362 S Bend School Corp Fee 407- - - - - - 25,000 - - - - - 25,000 25,000 100% 362 TIF Property various 14,223 24,108 14,479 13,450 6,588 15,451 11,619 12,350 134,034 - - - 246,302 319,603 77% 369 Memorial Hosp Leighton Plaza 408 150,000 - - - - - - - - - - - 150,000 150,000 100% 371 Century Center Fees 670 260,617 191,881 72,253 282,346 298,445 201,174 303,672 268,845 236,919 - - - 2,116,152 2,842,650 74% 399 Bosch Retention Project 210- - 15,737 - - 15,855 - - - - - - 31,592 63,661 50% 399 Principal on Loan various 19,897 19,842 19,726 20,742 601 577 1,241 514 576 - - - 83,716 86,374 97% 399 Principal Income various 30,702 596,589 - 31,814 - - 31,814 346,054 186,218 - - - 1,223,190 1,254,928 97% Sub Total 6,172,987 8,889,356 6,333,219 6,158,391 6,066,357 7,329,097 6,979,149 9,175,212 7,069,434 - - - 64,173,202 87,089,816 74% Interest Income 361 Bank Account Interest various 156,963 166,772 205,325 97,825 95,274 271,135 328,751 296,209 207,385 - - - 1,825,639 2,377,269 77% Sub Total 156,963 166,772 205,325 97,825 95,274 271,135 328,751 296,209 207,385 - - - 1,825,639 2,377,269 77% Donations 367 ND Contribution 101- - - - - - 330,000 - - - - - 330,000 337,500 98% 367 Donations various 75,816 1,040 70,660 440 25,155 55,987 44,782 83,148 27,285 - - - 384,313 467,494 82% Sub Total 75,816 1,040 70,660 440 25,155 55,987 374,782 83,148 27,285 - - - 714,313 804,994 89% Historic Preservation 368 C.O.I.T.404- - - 500 250 250 1,000 500 - - - - 2,500 3,500 71% 368 Palais 450 1,838 114 345 390 646 1,410 2,472 2,815 1,616 - - - 11,645 16,500 71% Sub Total 1,838 114 345 890 896 1,660 3,472 3,315 1,616 - - - 14,145 20,000 71% Sale of Assets 391 TIF (Property Sales / Land)various- 60,000 2 1 61,029 - 1 - 224,892 - - - 345,924 137,331 252% 391 Water Hydrant Reimbursement 620- - - - - - - - - - - - - 20,000 0% 391 Proceeds F.A. Disposal 600- - - - - - - - - - - - - 3,000 0% 391 Sale of Fixed Assets various- - - - - 1,137 - 178,674 (23,000) - - - 156,811 73,426 214% 391 Vehicle Damage Reimbursement various- - - - - - - - - - - - - - NA - Sub Total- 60,000 2 1 61,029 1,137 1 178,674 201,892 - - - 502,736 233,757 215% Revenue Total 15,541,356 27,563,049 18,707,970 18,276,109 18,164,753 66,098,808 16,164,794 22,897,112 52,594,748 - - - 256,008,701 339,591,492 75% report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 16,164,795 22,897,112 52,594,748 - - - 256,008,701 339,591,492 - 0 (1) 0 (0) 0 (1) 0 (0) - - - (0) - 2017-09 Fin anc i al Re port - Rev enue Report Page 5 of 25 City of South Bend Period Ending:September 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0000 General Revenues 101 1,105,267 1,215,293 975,765 1,001,269 1,006,845 24,478,271 1,381,463 1,233,581 1,566,326 - - - 33,964,080 56,731,833 60% 0101 Mayor 101- - - - - 70 - - - - - - 70 600 12% 0401 Administration and Finance 101 12,254 - 8 - - - - - - - - - 12,262 12,304 100% 0501 Legal 101 18,475 - - - 18,875 - 18,875 - 874 - - - 57,099 75,377 76% Sub Total 1,135,996 1,215,293 975,773 1,001,269 1,025,720 24,478,341 1,400,338 1,233,581 1,567,200 - - - 34,033,510 56,820,114 60% Public Works 0602 Engineering 101 32,047 7,275 12,535 6,200 4,050 4,475 9,305 4,401 4,655 - - - 84,943 323,464 26% Sub Total 32,047 7,275 12,535 6,200 4,050 4,475 9,305 4,401 4,655 - - - 84,943 323,464 26% Public Safety 0801 Police 101 34,608 15,151 13,175 13,089 10,980 16,268 9,894 131,366 331,988 - - - 576,520 668,408 86% 0901 Fire 101 4,387 37,987 - - - - 9 - - - - - 42,382 42,883 99% Sub Total 38,995 53,138 13,175 13,089 10,980 16,268 9,903 131,366 331,988 - - - 618,903 711,291 87% Arts & Culture 0404 Morris PAC 101 10,888 86,733 183,972 72,872 46,790 113,721 33,286 18,425 60,791 - - - 627,478 976,645 64% 0405 Palais Royale 101 26,265 9,345 13,108 10,025 33,527 30,706 47,868 52,472 24,958 - - - 248,274 359,502 69% xxx xxx- NA Sub Total 37,153 96,078 197,080 82,898 80,317 144,427 81,154 70,897 85,749 - - - 875,752 1,336,147 66% General Fund Revenue Total 1,244,191 1,371,784 1,198,563 1,103,455 1,121,067 24,643,511 1,500,699 1,440,245 1,989,592 - - - 35,613,108 59,191,016 60% 2017-09 Financial Report - Rev enue Summar y Page 6 of 25 City of South Bend Period Ending:September 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 0000 Parks General revenue 201 2,200 357,973 3,346 356,258 672 5,358,382 3,408 8,311 385,747 - - - 6,476,296 11,044,007 59% 1100 Administration 201 3,787 3,548 5,830 3,974 7,149 6,524 4,562 8,447 1,523 - - - 45,345 46,500 98% 1101 Maintenance 201 28,074 104,996 4,776 82,975 77,815 45,183 58,498 84,665 390,850 - - - 877,832 1,707,710 51% 1102 Golf Operations 201 1,356 402 152,340 98,890 148,871 194,599 197,540 232,475 137,390 - - - 1,163,864 1,537,545 76% 1103 Recreation Division 201 22 810 1,346 20 1,410 26,012 41,188 29,398 2,532 - - - 102,737 158,585 65% 1104 Potawatomi Zoo 201- - - - - - - - 9,451 - - - 9,451 - NA 1108 Graffiti Removal 201- - - - - 65,540 29,214 7,557 - - - - 102,311 256,725 40% 1110 Marketing and Events 201- - - 69 - 162 1,717 (125) 222 - - - 2,046 572,471 0% 1111 Regional Cities Grant 201- - - - - - - - - - - - - 5,000,000 0% Recreation Non Reverting 203 75,681 75,021 213,432 75,516 66,022 68,745 106,575 97,011 48,289 - - - 826,290 1,507,543 55% East Race Waterway 271 1 1 1 1 1 2 2 1 - - - - 9 22 40% Coveleski Stadium 401 68 69 79 38 35 104 99 95 41,883 - - - 42,469 40,900 104% Zoo Endowment 403 37 38 44 21 11 - - - - - - - 151 200 76% Park Non Reverting 405 4,566 174 571 25,620 26,282 1,232 1,027 887 210,340 - - - 270,698 439,850 62% Sub Total 115,792 543,031 381,765 643,382 328,266 5,766,485 443,830 468,720 1,228,228 - - - 9,919,498 22,312,058 44% Public Works Motor Vehicle Highway 202 317,873 1,223,876 828,325 1,361,365 833,924 286,692 703,745 539,275 1,374,593 - - - 7,469,668 10,023,367 75% Central Services 222 675,986 688,080 710,659 544,455 623,794 586,845 523,002 737,413 611,840 - - - 5,702,073 8,308,569 69% Central Services Capital 224 84 72 89 41 35 105 98 85 286,760 - - - 287,370 287,600 100% Local Roads & Streets 251 106,827 88,499 130,547 93,992 107,567 126,254 105,638 45,608 184,421 - - - 989,352 1,692,997 58% Local Road & Bridge Grant 265- 1,000,000 1,000,000 - - - - - - - - - 2,000,000 2,000,000 100% Project ReLeaf 655 37,450 37,428 37,604 37,214 37,325 38,215 38,248 38,302 38,029 - - - 339,815 449,153 76% xxx xxx xxx NA Sub Total 1,138,220 3,037,955 2,707,224 2,037,067 1,602,646 1,038,111 1,370,730 1,360,683 2,495,642 - - - 16,788,278 22,761,686 74% Public Works Solid Waste Solid Waste Operations 610 445,931 471,682 480,834 494,568 329,577 455,642 459,819 457,997 483,053 - - - 4,079,103 5,954,241 69% Solid Waste Capital 611 179 240 100,039 83,600 20,027 290,004 65 200,348 7 - - - 694,508 836,713 83% xxx xxx xxx NA Sub Total 446,110 471,922 580,873 578,168 349,604 745,646 459,884 658,345 483,060 - - - 4,773,611 6,790,954 70% Public Works Water Utility 0000 Water Works Revenues 620 973,972 948,744 947,938 952,254 965,980 1,147,589 1,322,131 1,351,352 1,342,694 - - - 9,952,654 13,593,036 73% 0630 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 81,942 82,009 81,955 - - - 734,828 980,000 75% 0660 Clay Water 620 72,507 69,573 74,940 69,858 75,790 126,952 129,104 140,138 121,037 - - - 879,898 1,192,586 74% Waterworks Capital 622 1,942 1,950 2,167 958 875 2,956 2,890 2,762 1,985 - - - 18,486 24,000 77% Waterworks Deposit 624 1,159 1,174 1,347 639 583 1,965 1,923 1,851 1,352 - - - 11,994 15,000 80% Waterworks Sinking 625 164,824 164,289 164,321 164,211 164,266 177,878 1,266 328,973 811 - - - 1,330,838 2,067,642 64% Waterworks Bond Reserve 626 1,154 1,073 1,235 594 548 1,828 1,791 1,732 1,278 - - - 11,233 16,000 70% Waterworks Debt Reserve 629 153,121 1,895 2,292 1,092 1,000 3,386 3,328 3,214 2,354 - - - 171,682 176,500 97% xxx xxx xxx NA Sub Total 1,449,981 1,269,935 1,275,612 1,270,956 1,290,778 1,544,479 1,544,374 1,912,030 1,553,466 - - - 13,111,612 18,064,764 73% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,941 54,328 55,305 53,519 53,371 57,542 54,949 54,686 55,048 - - - 493,688 632,424 78% 0000 Wastewater Revenues 641 3,044,674 2,968,092 2,944,636 2,940,827 2,924,257 3,029,887 3,052,765 3,134,863 3,111,210 - - - 27,151,210 35,130,467 77% 0621 Sewer Department 641- 1,261 - - - 1,191 - 23,915 - - - - 26,367 26,415 100% 0625 Concrete Crew 641- 3,040 - - - - - 33,569 - - - - 36,610 74,500 49% 0630 Wastewater Operations 641- - - - - - - 11,132 - - - - 11,132 - NA 0631 Organic Resources 641- - - - - - - 26,220 - - - - 26,220 - NA 0650 Clay Sewage 641 177,865 174,732 185,177 179,053 184,419 191,141 188,087 193,939 187,143 - - - 1,661,554 2,162,160 77% Sewage Capital 642 5,472 404,555 5,255 444,486 502,267 508,096 508,114 508,122 506,095 - - - 3,392,463 4,894,000 69% Sewage Reserve 643 3,481 3,535 520,820 2,021 1,972 6,676 6,560 6,337 4,640 - - - 556,040 561,755 99% Sewage Bond Sinking 649 763,195 1,184 1,526,979 763,848 764,229 768,253 768,214 768,750 767,847 - - - 6,892,497 9,190,024 75% Sewage Works DS Reserve 653- 955 1,176 1,189 1,579 1,877 2,174 2,423 2,869 - - - 14,243 15,000 95% 2011 Sewer Bond 659 41 39 45 22 7 0 0 0 0 - - - 154 155 100% 2012 Sewer Bond 661 2,379 2,201 2,530 1,144 984 3,053 2,666 2,176 958 - - - 18,092 50,000 36% Sub Total 4,052,047 3,613,922 5,241,923 4,386,109 4,433,084 4,567,716 4,583,529 4,766,131 4,635,809 - - - 40,280,270 52,736,900 76% 2017-09 Financial Report - Rev enue Summar y Page 7 of 25 City of South Bend Period Ending:September 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216 10,276 3,136 200 127 1,986 300 297 287 25,051 - - - 41,660 37,000 113% Curfew Violations 218 9 35 24 5 17 54 54 28 22 - - - 248 1,000 25% Law Enforcement Education 220 31,608 16,002 30,754 31,643 18,459 16,970 17,860 30,427 14,125 - - - 207,848 246,175 84% Public Safety LOIT 249 622,980 622,745 623,084 622,832 622,663 623,768 623,678 623,559 623,187 - - - 5,608,497 7,478,618 75% Police Take Home Vehicle 278 561 575 660 315 288 977 1,521 1,250 922 - - - 7,069 8,360 85% Police Block Grant 280 3 3 3 2 1 5 5 5 4 - - - 31 50 61% Police Academy 294 5,456 4,561 2,023 886 2,483 288 111 105 77 - - - 15,990 22,980 70% COPS More Grants 295 1,055 36,332 946 1,029 10,378 1,054 1,011 991 946 - - - 53,741 123,500 44% Drug Enforcement 299 149 162 148 166 161 168 182 23,201 (20,971) - - - 3,366 33,000 10% K-9 Unit 705 2 2 3 1 1 4 4 4 3 - - - 23 2,036 1% Sub Total 672,099 683,553 657,845 657,005 656,439 643,588 644,721 679,857 643,364 - - - 5,938,470 7,952,719 75% Public Safety - Fire EMS Capital 287 2,726 1,801,174 3,021 2,108 1,927 6,015 5,158 1,416,814 3,510 - - - 3,242,454 4,529,349 72% EMS Operating Fund 288 181,987 557,555 483,650 374,307 372,922 650,471 413,058 564,862 473,638 - - - 4,072,451 6,385,015 64% Hazmat 289 19 20 23 11 10 30 28 3,087 22 - - - 3,252 10,250 32% River Rescue 291 114 16,307 12,724 1,869 23,462 10,989 3,211 186 128 - - - 68,988 69,400 99% Sub Total 184,846 2,375,057 499,419 378,295 398,322 667,505 421,455 1,984,949 477,298 - - - 7,387,145 10,994,014 67% Department of Community Investment Studebaker/Oliver 209 25,242 626 34,113 56,725 9,707 1,070 28,801 131,345 34,453 - - - 322,082 425,787 76% State Grant 210 242 268 18,311 148 135 18,459 455 3,130 319 - - - 41,464 262,141 16% DCI Operating 211 10,748 394,129 39,598 398,624 8,536 13,387 8,822 58,823 392,519 - - - 1,325,187 2,294,428 58% 0000 Dept. of Community Investment 212 310,284 201,138 42,852 164,474 83,939 357,952 31,360 49,702 229,167 - - - 1,470,869 5,574,676 26% xxx Programs 212 93,743 - - - - - - 116,141 - - - - 209,884 - NA 0000 Economic Revenue Bond 281 21 21 24 12 11 36 35 34 25 - - - 218 300 73% xxx xxx xxx NA Sub Total 440,280 596,182 134,898 619,981 102,326 390,903 69,474 359,175 656,484 - - - 3,369,704 8,557,332 39% Parking Garages 0000 Parking Garage Revenue 601 284 671 1,020 40 - - 108 361 - - - - 2,483 9,100 27% 0460 Main Street 601 25,906 27,933 28,062 26,202 64,761 21,525 22,907 40,399 24,541 - - - 282,235 268,766 105% 0462 Leighton Plaza 601 58,466 24,331 25,191 82,032 58,385 19,301 73,829 49,105 24,549 - - - 415,188 497,484 83% 0463 Enforcement 601 4,969 4,623 7,202 3,586 4,680 6,223 10,585 6,212 5,234 - - - 53,315 91,000 59% 0464 Wayne Street 601 30,977 20,895 29,889 11,565 12,333 24,967 19,680 29,994 16,625 - - - 196,924 242,261 81% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 120,601 78,453 91,364 123,425 140,159 72,016 127,108 126,071 70,949 - - - 950,145 1,124,511 84% Capital / Debt Service Hall of Fame 313 50 6 23 8 10 474,777 12 14 77 - - - 474,978 894,300 53% COIT 404 913,313 879,279 1,163,973 920,266 874,964 886,807 916,204 883,875 947,994 - - - 8,386,675 11,063,418 76% Cum Capital Development 406 357 436 410 184 169 259,526 492 674 395 - - - 262,642 485,600 54% Cum Capital Improvement 407 150,266 294 301 144 132 117,143 25,562 567 270 - - - 294,679 437,000 67% EDIT 408 1,041,459 1,981,678 877,267 871,706 870,753 882,446 882,180 882,560 878,800 - - - 9,168,848 11,794,400 78% UDAG 410 445 416 493 235 207 689 677 629 451 - - - 4,242 6,110 69% Major Moves 412 1,774 598,393 2,312 1,238 1,135 3,844 3,780 249,486 188,822 - - - 1,050,784 1,056,786 99% Morris PAC Improvement 416 436 12,664 13,666 11,585 5,797 3,677 5,090 2,616 1,165 - - - 56,696 106,500 53% Palais Historic Preservation 450 1,907 187 428 429 683 1,534 2,596 2,937 1,708 - - - 12,410 17,500 71% Hall of Fame Capital 677 372 378 431 200 182 612 598 576 420 - - - 3,767 5,000 75% SB Building Corp 755- 1,326,786 210 65 117 169 191 1,323,992 754 - - - 2,652,285 2,654,500 100% Parks Bond Debt Svc 757- 65,162 124 65,236 80 64,086 138 32,152 31,927 - - - 258,907 391,482 66% Eddy St. Commons Debt 760- - - - - - - - 2,500,000 - - - 2,500,000 - NA xxx xxx xxx Sub Total 2,110,380 4,865,679 2,059,637 1,871,297 1,754,228 2,695,308 1,837,521 3,380,078 4,552,784 - - - 25,126,912 28,912,596 87% 2017-09 Financial Report - Rev enue Summar y Page 8 of 25 City of South Bend Period Ending:September 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Rainy Day 102 7,644 7,773 8,937 4,262 3,906 13,232 13,013 12,585 9,225 - - - 80,578 90,000 90% Gift, Donation, Bequest 217 50,900 1,097 69,994 5,639 220 51,058 513 1,726 885 - - - 182,031 214,094 85% Unsafe Building 219 11,928 152,225 26,129 160,537 14,230 18,670 16,684 22,297 163,559 - - - 586,259 884,475 66% Landlord Registration 221 2,260 270 1,245 155 60 25 20 5 865 - - - 4,905 7,000 70% Loss Recovery 227 730 741 851 404 368 1,244 1,217 1,176 793 - - - 7,524 9,000 84% LOIT 2016 Special Distribution 257- 6,605 156,406 1,646 1,183 56,449 3,846 103,670 58,430 - - - 388,234 1,623,397 24% Human Rights 258 91,498 4,790 5,975 2,576 356 600 39,798 689 413 - - - 146,694 258,740 57% Morris Palais Marketing 273 34 582 1,132 577 947 3,950 58 60 1,532 - - - 8,871 18,450 48% IT / Innovation /311 Call Center 279 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 - - - 3,875,589 5,205,034 74% Professional Sports Development 377 80,547 318 115,357 24,107 23,146 214 14,680 213 - - - - 258,581 734,325 35% 1201 Code Enforcement 600 12,749 366,188 37,109 380,781 6,482 53,138 29,672 11,774 393,616 - - - 1,291,509 1,863,717 69% 1207 Animal Control 600 4,706 187,306 6,015 188,107 6,975 6,368 7,095 6,521 190,313 - - - 603,405 798,835 76% 1306 Building Operations 600 92,341 88,523 111,064 97,168 142,392 199,102 112,431 177,174 126,756 - - - 1,146,950 1,398,154 82% Century Center 670 910,931 211,677 (225,009) 400,425 412,693 311,339 412,822 379,895 354,384 - - - 3,169,156 4,228,683 75% Century Center Capital 671 74 66 74 71 74 71 74 74 71 - - - 648 750 86% Century Center Energy Saving 672 6 4 4 4 4 4 55,520 82,171 4 - - - 137,722 192,297 72% xxx xxx xxx NA Sub Total 1,696,966 1,458,786 745,904 1,697,080 1,043,657 1,146,084 1,138,062 1,230,651 1,731,467 - - - 11,888,656 17,526,951 68% Business Insurance 0000 Business Insurance Revenues 226 246,679 247,476 245,267 248,740 243,026 253,098 246,803 246,533 244,966 - - - 2,222,587 3,539,591 63% 0403 Self Funded Liability Ins 226- - - - - - - - - - - - - - NA 0412 Liability Insurance 226- - - - - - - - - - - - - - NA 0417 Business Insurance 226- - - - - - - - - - - - - - NA 0418 Workers Compensation 226 619 35,123 - - - 900 - - - - - - 36,642 36,643 100% xxx xxx xxx NA Sub Total 247,298 282,599 245,267 248,740 243,026 253,998 246,803 246,533 244,966 - - - 2,259,230 3,576,234 63% Fiduciary Trust & Agency Fire Pension 701 335 84 - - - 2,461,856 - 292 2,458,856 - - - 4,921,423 4,925,212 100% Police Pension 702 2,386 1,224 5,915 565 595 3,108,612 290 1,049 3,100,921 - - - 6,221,557 6,223,679 100% Employee Benefits 711 1,511,154 1,463,664 1,500,195 1,490,799 1,481,130 1,495,193 1,527,856 1,560,739 1,488,470 - - - 13,519,200 17,892,659 76% Unemployment Comp 713 217 214 244 114 102 339 329 310 221 - - - 2,089 2,800 75% City Cemetery Trust 730 22 22 25 12 11 37 37 36 26 - - - 228 280 82% Equipment / Vehicle Leasing 750- 298 375 223 2,916,712 532 161,897 (160,372) 1,632,769 - - - 4,552,435 5,502,900 83% Parks Bond Capital 751- 369 539 485 517 632 652 624 637 - - - 4,454 7,500 59% Smart Street Bond Capital 753- 604 663 544 545 606 561 42,305 22,038 - - - 67,865 58,880 115% Eddy St. Commons Capital 759- - - - - - - - 22,500,000 - - - 22,500,000 - NA xxx xxx xxx NA Sub Total 1,514,115 1,466,478 1,507,957 1,492,742 4,399,611 7,067,807 1,691,621 1,444,982 31,203,938 - - - 51,789,252 34,613,910 150% Civil City Revenues 15,432,926 22,115,337 17,328,250 17,107,703 17,863,212 51,243,156 16,079,811 20,058,449 51,967,048 - - - 229,195,891 295,115,645 78% Tax Increment Financing TIF River West - Airport 324 78,976 118,077 87,148 235,509 71,358 9,426,694 42,749 47,660 600,265 - - - 10,708,436 23,789,389 45% TIF West Washington 422 1,411 1,497 1,721 821 751 200,696 2,595 2,664 1,952 - - - 214,107 442,000 48% TIF Leighton Plaza 425 10,467 14,196 10,498 8,768 8,762 8,914 9,074 10,331 7,249 - - - 88,257 197,014 45% TIF River East DEV (NE)429 5,927 6,699 11,342 3,606 3,279 1,437,646 9,487 161,939 7,377 - - - 1,647,303 3,236,467 51% TIF Southside 430 3,108 564,649 4,388 906,618 2,039 1,224,439 7,953 9,233 6,328 - - - 2,728,754 3,916,127 70% TIF Erskine Village 432 3,646 3,484 791 378 219 1 1 - - - - - 8,519 8,520 100% TIF Douglas Road 435 77 120 95 3 3 218,289 111 277 36 - - - 219,010 328,208 67% TIF River East RES (NE RE)436 442 - - - - 2,320,321 - - - - - - 2,320,763 3,300,903 70% Sub Total 104,055 708,721 115,983 1,155,702 86,411 14,837,000 71,969 232,103 623,207 - - - 17,935,150 35,218,628 51% 2017-09 Financial Report - Rev enue Summar y Page 9 of 25 City of South Bend Period Ending:September 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433 6 6 7 4 3 10 9 9 7 - - - 62 135 46% Certified Technology Park 439 1,614 1,641 1,887 900 825 1,064 456 253,066 397 - - - 261,849 302,625 87% Airport Urban Enterprise Zone 454 288 292 336 160 147 498 489 473 347 - - - 3,031 3,900 78% Industrial Revolving 754- - 21,526 9,673 14,952 12,238 7,388 7,961 - - - - 73,738 223,824 33% Sub Total 1,908 1,940 23,757 10,737 15,927 13,810 8,342 261,509 750 - - - 338,681 530,484 64% Debt Service Airport Debt Reserve 2003 315 780 792 902 434 398 1,346 1,323 1,278 935 - - - 8,187 14,000 58% Coveleski Bond Debt Reserve 317 385 391 450 214 197 666 655 633 464 - - - 4,055 5,000 81% Central Development reserve 328 1,303 1,323 1,522 725 664 2,249 2,210 2,135 1,563 - - - 13,694 20,000 68% SB Redevelopment Authority 752- 772,669 1,236,763 395 197,726 305 195 1,484,222 400 - - - 3,692,675 3,868,669 95% Smart Streets Debt Svc 756- 179 263 197 218 277 291 856,782 381 - - - 858,588 857,284 100% Erskine Village Debt. Svc 758- 3,961,697 82 1 - - - - - - - - 3,961,781 3,961,782 100% Sub Total 2,468 4,737,051 1,239,982 1,967 199,202 4,843 4,673 2,345,050 3,743 - - - 8,538,980 8,726,735 98% Redevelopment Commission 108,431 5,447,712 1,379,721 1,168,406 301,541 14,855,652 84,984 2,838,662 627,701 - - - 26,812,810 44,475,847 60% City Operations Total 15,541,357 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 16,164,795 22,897,112 52,594,748 - - - 256,008,702 339,591,492 75% Revenue report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 16,164,795 22,897,112 52,594,748 0 0 0 256,008,701 339,591,492 0 0 0 0(0)0 0 0 0 0 0 0 0 0 2017-09 Financial Report - Rev enue Summar y Page 10 of 25 City of South Bend Period Ending:September 30, 2017 Property Tax Revenue 2016 Tax Pay 2017 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/20/2017 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,248,867.00 0.95 38,236,423.65 21,820,142.51 - - - 21,820,142.51 18,428,724.49 54.21% Parks & Recreation 201 9,179,442.00 0.95 8,720,469.90 4,976,456.29 - - - 4,976,456.29 4,202,985.71 54.21% College Football Hall of Fame 313 833,277.00 0.95 791,613.15 451,820.36 - - - 451,820.36 381,456.64 54.22% Cumulative Capital District 406 443,869.00 0.95 421,675.55 240,635.07 - - - 240,635.07 203,233.93 54.21% Total - City 50,705,455.00 48,170,182.25 27,489,054.23 - - - 27,489,054.23 23,216,400.77 54.21% Tax Increment Financing Airport TIF District 324 18,698,946.24 0.95 17,763,998.93 8,932,881.19 - - - 8,932,881.19 9,766,065.05 47.77% West Washington TIF District 422 367,557.18 0.95 349,179.32 198,151.66 - - - 198,151.66 169,405.52 53.91% Northeast Residential TIF District 436 4,405,723.00 0.95 4,185,436.85 2,320,321.06 - - - 2,320,321.06 2,085,401.94 52.67% Southside TIF District #1 430 2,390,790.99 0.95 2,271,251.44 1,216,823.61 - - - 1,216,823.61 1,173,967.38 50.90% Douglas Road TIF District 435 321,949.68 0.95 305,852.20 218,279.99 - - - 218,279.99 103,669.69 67.80% Northeast TIF 429 2,766,113.25 0.95 2,627,807.59 1,428,045.99 - - - 1,428,045.99 1,338,067.26 51.63% Total - Tax Increment Financing 28,951,080.34 27,503,526.32 14,314,503.50 - - - 14,314,503.50 14,636,576.84 49.44% Grand Total 79,656,535.34 75,673,708.57 41,803,557.73 - - - 41,803,557.73 37,852,977.61 52.48% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/20/17 2017-09 Financial Report - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:September 30, 2017 Property Tax Revenue 2015 Tax Pay 2016 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/14/2016 12/20/2016 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,360,212.00 0.95 38,342,201.40 21,490,881.50 17,871,257.85 - - 39,362,139.35 998,072.65 97.53% Parks & Recreation 201 8,090,885.00 0.95 7,686,340.75 4,312,625.82 3,590,369.07 - - 7,902,994.89 187,890.11 97.68% College Football Hall of Fame 313 1,396,308.00 0.95 1,326,492.60 744,229.93 617,281.74 - - 1,361,511.67 34,796.33 97.51% Cumulative Capital District 406 451,368.00 0.95 428,799.60 240,589.67 200,296.91 - - 440,886.58 10,481.42 97.68% Total - City 50,298,773.00 47,783,834.35 26,788,326.92 22,279,205.57 - - 49,067,532.49 1,231,240.51 97.55% Tax Increment Financing Airport TIF District 324 19,123,985.00 0.95 18,167,785.75 9,769,452.30 8,389,858.48 - - 18,159,310.78 964,674.22 94.96% West Washington TIF District 422 516,171.00 0.95 490,362.45 282,809.66 170,692.93 - - 453,502.59 62,668.41 87.86% Northeast Residential TIF District 436 3,913,816.00 0.95 3,718,125.20 2,061,402.42 1,871,544.98 - - 3,932,947.40 (19,131.40) 100.49% Southside TIF District #1 430 2,481,892.00 0.95 2,357,797.40 1,251,613.66 1,149,638.01 - - 2,401,251.67 80,640.33 96.75% Douglas Road TIF District 435 337,099.00 0.95 320,244.05 231,288.93 113,972.95 - - 345,261.88 (8,162.88) 102.42% Northeast TIF 429 2,586,566.00 0.95 2,457,237.70 1,170,979.07 1,177,628.87 - - 2,348,607.94 237,958.06 90.80% Total - Tax Increment Financing 28,959,529.00 27,511,552.55 14,767,546.04 12,873,336.22 - - 27,640,882.26 1,318,646.74 95.45% Grand Total 79,258,302.00 75,295,386.90 41,555,872.96 35,152,541.79 - - 76,708,414.75 2,549,887.25 96.78% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/14/16 Distribution 2 - Issued by St. Joseph County on 12/20/16 2017-09 Financial Report - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:September 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0101 Mayor 101 59,009 57,926 57,827 61,110 54,678 84,839 65,163 76,317 72,597 - - - 589,466 872,923 68% 0201 Clerk 101 38,451 43,206 31,600 35,638 35,273 46,995 33,861 36,722 39,439 - - - 341,185 536,216 64% 0301 Common Council 101 33,451 49,728 27,207 50,580 28,885 34,287 33,776 38,408 39,952 - - - 336,273 571,148 59% 0302 WNIT Contract 101- - - - 43,000 - - - - - - - 43,000 43,000 100% 0401 Administration and Finance 101 184,278 178,933 181,407 203,805 206,704 261,723 192,964 189,599 187,406 - - - 1,786,819 2,476,351 72% 0501 Legal Department 101 87,585 86,783 87,565 116,630 75,744 109,460 80,722 95,963 75,203 - - - 815,654 1,158,567 70% Sub Total 402,773 416,575 385,606 467,764 444,284 537,304 406,485 437,008 414,597 - - - 3,912,397 5,658,205 69% Public Works 0602 Engineering 101 81,736 88,219 89,641 89,644 103,226 120,430 96,986 98,261 109,104 - - - 877,246 1,445,157 61% Sub Total 81,736 88,219 89,641 89,644 103,226 120,430 96,986 98,261 109,104 - - - 877,246 1,445,157 61% Public Safety 0801 Police 101 2,401,801 2,081,566 2,099,258 2,016,036 2,087,143 2,837,886 2,194,381 2,006,824 2,131,759 - - - 19,856,655 29,668,433 67% 0901 Fire 101 1,586,894 1,525,036 1,582,606 1,554,060 1,604,395 2,215,029 1,508,966 1,445,712 1,524,297 - - - 14,546,995 21,111,466 69% Sub Total 3,988,695 3,606,602 3,681,864 3,570,096 3,691,539 5,052,914 3,703,347 3,452,537 3,656,056 - - - 34,403,650 50,779,899 68% Code Enforcement Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 74,731 80,199 47,613 60,412 60,629 72,212 60,726 61,783 58,942 - - - 577,248 1,271,039 45% 0405 Palais Royale 101 24,999 30,061 10,824 17,021 18,169 22,340 17,757 19,406 19,179 - - - 179,757 530,200 34% Sub Total 99,730 110,260 58,436 77,434 78,798 94,553 78,483 81,189 78,122 - - - 757,005 1,801,239 42% Human Rights 1008 Human Rights 101 37,821 40,148 32,484 37,408 31,913 34,695 29,063 35,285 29,894 - - - 308,711 425,805 73% Sub Total 37,821 40,148 32,484 37,408 31,913 34,695 29,063 35,285 29,894 - - - 308,711 425,805 73% General Fund Expenditure Total 4,610,756 4,261,804 4,248,032 4,242,346 4,349,760 5,839,896 4,314,364 4,104,281 4,287,772 - - - 40,259,009 60,110,305 67% 2017-09 Financial Report - Expe nditu re Su mmary Page 13 of 25 City of South Bend Period Ending:September 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 1100 Administration 201 147,654 87,876 110,868 112,743 118,476 128,067 111,926 111,828 113,095 - - - 1,042,533 1,468,296 71% 1101 Maintenance 201 399,021 416,933 423,013 569,543 553,920 672,696 511,411 561,135 453,106 - - - 4,560,777 6,854,308 67% 1102 Golf Operations 201 54,483 75,381 77,362 180,384 131,801 173,015 147,904 146,830 134,209 - - - 1,121,368 1,638,575 68% 1103 Recreation Division 201 165,251 145,109 133,502 139,866 147,123 241,949 247,358 212,855 135,982 - - - 1,568,994 2,153,817 73% 1104 Potawatomi Zoo 201 355,692 7,425 7,231 7,208 289,717 8,923 6,660 6,601 5,369 - - - 694,825 704,464 99% 1106 Potawatomi Greenhouse 201 5,013 4,555 2,550 2,375 1,198 15,764 411 408 566 - - - 32,840 54,408 60% 1108 Graffiti Removal 201 13,483 12,628 11,465 10,265 8,529 10,420 7,557 7,946 (6,469) - - - 75,824 97,861 77% 1110 Marketing and Events 201 16,583 45,412 58,810 61,326 60,810 83,508 58,196 67,592 57,881 - - - 510,118 953,588 53% 1111 Regional Cities Grant 201- - - - - - - - - - - - - 5,000,000 0% Recreation Non Reverting 203 51,478 47,722 45,821 94,361 71,392 92,875 159,108 155,475 75,309 - - - 793,540 1,599,683 50% East Race Waterway 271- - - - - - 1,353 - - - - - 1,353 1,367 99% Coveleski Stadium 401- - - 8,542 4,569 - 1,778 1,136 975 - - - 17,000 30,000 57% Zoo Endowment 403- - - 53,599 - (3,549) - - - - - - 50,049 49,688 101% Park Non Reverting 405 45,874 17,251 22,621 42,193 16,930 71,879 61,868 19,760 120,486 - - - 418,861 513,024 82% Sub Total 1,254,532 860,290 893,243 1,282,404 1,404,465 1,495,546 1,315,529 1,291,565 1,090,510 - - - 10,888,083 21,119,079 52% Public Works Motor Vehicle Highway 202 919,033 515,568 547,694 523,276 541,787 631,705 634,583 681,127 817,893 - - - 5,812,666 9,886,533 59% Curb and Sidewalk 202 150,920 40,047 37,646 38,164 143,273 121,813 209,102 113,133 54,706 - - - 908,803 1,878,998 48% Central Services 222 730,352 648,645 561,962 613,240 672,069 593,479 531,551 706,728 844,083 - - - 5,902,110 8,564,643 69% Central Services Capital 224 10,575 4,009 - 16,964 - 11,786 - 16,597 114,180 - - - 174,112 326,025 53% Local Roads & Streets 251 209,999 4,801 3,018 35,678 92,276 81,399 305,836 166,252 2,321 - - - 901,580 2,211,544 41% Local Roads & Bridge 265- - - - - - 64 - - - - - 64 2,000,000 0% Project ReLeaf 655 15,049 90,567 3,684 115,917 3,108 3,165 14,951 3,270 100,821 - - - 350,532 525,416 67% Sub Total 2,035,929 1,303,638 1,154,005 1,343,240 1,452,512 1,443,345 1,696,086 1,687,108 1,934,004 - - - 14,049,866 25,393,159 55% Public Works Solid Waste Solid Waste Operations 610 489,623 312,159 388,501 385,830 347,815 685,660 407,427 582,186 353,087 - - - 3,952,290 5,662,910 70% Solid Waste Capital 611 286,902 146,712 218 83,859 20,129 219 286,862 146,712 259 - - - 971,870 1,135,613 86% Sub Total 776,525 458,871 388,720 469,689 367,944 685,879 694,289 728,898 353,346 - - - 4,924,159 6,798,523 72% Public Works Water Utility 0630 Water Leak Insurance 620 43,958 41,864 50,876 46,504 58,900 71,053 44,809 145,869 99,045 - - - 602,878 1,035,000 58% 0640 Water Works 620 1,417,876 1,256,524 1,085,407 1,142,917 1,117,427 1,222,741 987,180 1,504,301 1,136,327 - - - 10,870,700 16,688,754 65% 0660 Clay Water 620- - (0) 169 37 5 26 13 14 - - - 265 3,500 8% Waterworks Capital 622 111,938 177,777 13,775 9,295 8,299 17,201 58,155 8,110 - - - - 404,549 1,414,466 29% Waterworks Deposit 624 874 1,174 1,347 639 583 1,965 1,923 1,851 1,352 - - - 11,708 15,000 78% Waterworks Sinking 625 815 289 321 211 266 255,311 52,101 1,373 811 - - - 311,498 2,054,891 15% Waterworks Bond Reserve 626- - - - - 10,000 - - - - - - 10,000 16,000 63% Waterworks Debt Reserve 629 1,394 1,895 2,292 1,092 1,000 3,386 3,328 3,214 2,354 - - - 19,955 23,000 87% Sub Total 1,576,855 1,479,523 1,154,018 1,200,827 1,186,511 1,581,662 1,147,523 1,664,732 1,239,903 - - - 12,231,553 21,250,611 58% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 48,400 46,390 29,841 52,988 63,829 41,714 55,751 28,271 35,884 - - - 403,069 534,509 75% 0621 Sewer Repair 641 517,647 434,598 385,613 579,850 349,846 452,561 422,426 441,576 375,871 - - - 3,959,988 9,248,687 43% 0625 Concrete Crew 641 30,239 20,767 19,975 30,713 26,000 34,774 27,113 25,357 22,159 - - - 237,097 474,389 50% 0630 Wastewater Operations 641 2,358,990 1,454,679 3,260,858 2,528,275 2,582,015 2,554,148 2,645,651 2,822,548 2,378,990 - - - 22,586,154 33,209,563 68% 0631 Organic Resources 641 124,773 126,931 80,689 53,682 214,126 78,314 116,920 145,157 68,948 - - - 1,009,540 1,608,946 63% 0650 Clay Sewage 641- 5 26 50 431 - 181 73 9 - - - 775 750 103% Sewage Capital 642 1,298,328 387,989 178,442 93,243 530,257 335,486 139,256 298,108 286,199 - - - 3,547,308 8,040,455 44% Sewage Reserve 643 2,625 3,535 4,065 2,021 1,972 6,676 6,560 6,337 4,640 - - - 38,429 30,000 128% Sewage Bond Sinking 649 1,000 500 - - 830,476 249,650 - - - - - - 1,081,626 9,163,754 12% 2011 Sewer Bond 659- - - 51,687 - - - - - - - - 51,687 51,688 100% 2012 Sewer Bond 661 3,000 166,950 113,521 180,305 269,318 115,454 988,844 - 190,669 - - - 2,028,061 3,010,364 67% Sub Total 4,385,001 2,642,343 4,073,031 3,572,814 4,868,271 3,868,777 4,402,703 3,767,427 3,363,367 - - - 34,943,734 65,373,105 53% 2017-09 Financial Report - Expe nditu re Su mmary Page 14 of 25 City of South Bend Period Ending:September 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216- - - - - - - - - - - - - 36,000 0% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 44,630 19,978 197,939 29,048 26,375 24,885 22,590 25,405 16,652 - - - 407,504 788,422 52% Emergency Telephone System 244- - - 4,708 - - - 28,963 (0) - - - 33,671 33,671 100% Public Safety LOIT 249 466,245 487,781 613,087 598,935 610,756 918,862 621,159 628,089 620,854 - - - 5,565,768 7,462,645 75% Excess Welfare Public Safety 252- - - - - - - - - - - - - 8 0% LOIT 2016 Special Distribution 257 21,360 21,991 1,050,366 38,621 39,807 69,470 81,018 26,739 20,191 - - - 1,369,562 3,757,457 36% Police Take Home Vehicle 278- 972 - (60) (120) (260) 340 100 - - - - 972 10,000 10% Police Grants 292 2,796 1,266 1,330 90 106 - - 21,735 630 - - - 27,952 10,805 259% Police Academy 294 162 283 692 909 515 3,776 179 249 523 - - - 7,288 22,500 32% COPS More Grants 295 10,980 3,436 108,583 11,664 915 240 347 - 180 - - - 136,345 263,767 52% Drug Enforcement 299 11,242 23,096 13,200 - - 3,172 - - 19,000 - - - 69,710 196,337 36% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 557,416 558,803 1,985,195 683,915 678,354 1,020,145 725,633 731,281 678,029 - - - 7,618,771 12,584,632 61% Public Safety - Fire EMS Capital 287 235,792 150,604 - 386,321 136,287 547,964 290,622 431,636 177,672 - - - 2,356,897 3,991,466 59% EMS Operating Fund 288 438,601 356,431 401,753 451,805 437,873 602,509 371,814 451,602 452,361 - - - 3,964,747 6,117,914 65% Hazmat 289 430 255 - - 4,057 - - 200 826 - - - 5,768 10,431 55% River Rescue 291 1,443 231 231 23,817 10,419 21,299 9,052 15,613 11,629 - - - 93,733 117,349 80% xxx xxx xxx- - - - - - - - - - - - - NA Sub Total 676,266 507,520 401,984 861,943 588,636 1,171,772 671,488 899,050 642,487 - - - 6,421,146 10,237,160 63% Department of Community Investment Studebaker/Oliver 209 70,702 4,592 23,072 39,510 43,825 - 31,342 25,919 15,560 - - - 254,522 539,393 47% State Grant 210- - 18,003 - - 18,003 - - 18,003 - - - 54,008 509,757 11% DCI Operating 211 197,318 171,937 175,385 177,600 195,239 226,245 174,958 184,330 168,181 - - - 1,671,193 2,750,376 61% 1001 Dept. of Community Investment 212 575,173 100,654 21,621 163,348 164,147 146,738 77,983 126,737 105,551 - - - 1,481,951 5,455,838 27% 1003 Administration 212- - - - - - - - - - - - - - NA xxx Programs 212- - - - - - - - - - - - - - NA Sub Total 843,192 277,183 238,081 380,458 403,211 390,985 284,283 336,985 307,295 - - - 3,461,673 9,255,364 37% Parking Garages 0461 St. Joseph 601- - 604 - (604) - - - - - - - NA 0460 Main Street 601 10,017 11,799 1,749 75,944 10,787 28,308 3,500 28,758 (26,473) - - - 144,391 261,894 55% 0462 Leighton Plaza 601 20,044 21,722 1,360 55,854 7,114 18,879 3,926 28,168 126,180 - - - 283,248 596,368 47% 0463 Enforcement 601 7,858 7,238 437 22,849 437 12,035 5,445 13,557 7,791 - - - 77,647 128,675 60% 0464 Wayne Street 601 12,364 13,889 936 32,097 5,591 20,718 1,558 21,801 29,321 - - - 138,276 244,417 57% 0465 Eddy Street Commons 601- - - 32 - 647 - 160 (840) - - - - 15,900 0% Sub Total 50,284 54,648 4,482 186,776 24,534 80,587 13,826 92,445 135,979 - - - 643,562 1,247,254 52% Capital / Debt Service Hall of Fame 313 635,000 - (3,265) - - - 633,000 - (121,315) - - - 1,143,420 1,268,999 90% COIT 404 1,172,640 1,270,520 840,369 1,585,347 13,821 530,881 881,651 450,575 1,889,332 - - - 8,635,136 12,071,593 72% Cum Capital Development 406 112,650 27,896 - - 149,081 - 112,650 27,896 - - - - 430,173 476,500 90% Cum Capital Improvement 407 185,125 - - - - - 187,125 - (1,000) - - - 371,250 372,250 100% EDIT 408 697,093 1,928,675 70,750 2,317,413 62,665 58,366 82,427 572,803 2,119,508 - - - 7,909,700 11,559,184 68% UDAG 410 30,702 - - 31,814 - - 31,814 - - - - - 94,329 126,144 75% Major Moves 412 543 - 62 - 910 - 274,046 142,171 - - - - 417,732 2,470,708 17% Morris PAC Improvement 416 408 - 1,645 1,423 540 - 334 2,704 10,825 - - - 17,878 401,144 4% Palais Historic Preservation 450- - - - - - - 627 - - - - 627 5,000 13% Hall of Fame Capital 677 3,866 14,859 2,574 3,209 2,159 2,638 2,500 3,993 2,785 - - - 38,582 81,091 48% SB Building Corp 755- - 1,437,970 - - - 500 - 1,203,744 - - - 2,642,214 2,643,214 100% Parks Bond Debt 757- - 198,566 - - - - - 191,916 - - - 390,481 391,482 100% Sub Total 2,838,027 3,241,949 2,548,669 3,939,206 229,176 591,885 2,206,047 1,200,770 5,295,793 - - - 22,091,521 31,867,309 69% 2017-09 Financial Report - Expe nditu re Su mmary Page 15 of 25 City of South Bend Period Ending:September 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Gift, Donation, Bequest 217 72,000 900 - 663 760 6,877 79,294 31,363 3,000 - - - 194,856 241,700 81% Unsafe Building 219 80,336 43,005 41,261 55,208 81,628 79,253 60,815 103,231 55,606 - - - 600,341 902,746 67% Landlord Registration 221 5 5 - - - - - - - - - - 10 1,000 1% Loss Recovery 227- 3,345 7,600 2,080 5,844 - - 102,343 - - - - 121,212 598,675 20% Human Rights 258 17,100 3,192 7,767 8,984 17,529 18,147 9,651 14,458 8,429 - - - 105,258 201,773 52% Morris Palais Marketing 273 2,798 - 878 - 1,998 - - - - - - - 5,673 21,675 26% IT / Innovation / 311 Call Center 279 325,330 207,081 205,525 260,505 495,245 278,491 182,978 249,728 181,011 - - - 2,385,893 5,205,034 46% Professional Sports Development 377 467,640 800 - - - - 359,515 - - - - - 827,955 827,955 100% 1201 Code Enforcement 600 128,453 94,686 101,457 110,099 112,811 146,364 122,698 114,832 113,507 - - - 1,044,907 1,625,378 64% 1207 Animal Control 600 68,101 59,652 58,318 65,964 68,163 74,484 66,442 65,853 63,349 - - - 590,326 790,517 75% 1306 Building Operations 600 110,343 98,842 97,813 101,286 98,111 129,067 111,279 102,136 109,926 - - - 958,803 1,361,925 70% Century Center 670 282,027 349,477 (15,339) 661,555 322,739 382,643 332,564 414,240 314,078 - - - 3,043,983 4,194,310 73% Century Center Energy Saving 672- - - 95,128 - - - - - - - - 95,128 192,297 49% Sub Total 1,554,131 860,986 505,279 1,361,472 1,204,828 1,115,326 1,325,236 1,198,182 848,906 - - - 9,974,345 16,164,985 62% Business Insurance 0403 Self Funded Liability Ins 226 17,866 17,273 20,527 15,424 16,015 21,466 15,567 19,357 14,973 - - - 158,467 235,471 67% 0412 Liability Insurance 226 45,537 23,578 52,779 27,697 640,369 40,160 62,615 40,802 96,968 - - - 1,030,505 2,034,051 51% 0417 Business Insurance 226 45,354 - 21,392 120 21,404 - 386,775 25,962 19,855 - - - 520,862 595,678 87% 0418 Workers Compensation 226 119,520 87,561 54,191 240,566 58,672 52,655 93,757 23,199 18,944 - - - 749,066 722,386 104% Sub Total 228,276 128,412 148,890 283,807 736,460 114,282 558,713 109,320 150,740 - - - 2,458,900 3,587,586 69% Fiduciary Trust & Agency Fire Pension 701 388,455 396,509 396,201 394,300 390,847 376,476 382,196 380,446 380,376 - - - 3,485,806 5,098,269 68% Police Pension 702 513,053 511,187 523,297 519,926 517,885 505,354 507,705 507,885 507,795 - - - 4,614,086 6,423,889 72% Employee Benefits 711 1,060,085 1,343,141 951,392 1,174,621 1,102,064 1,726,172 1,277,628 1,631,987 1,049,110 - - - 11,316,201 17,803,200 64% Unemployment Comp 713 6,038 8,041 4,389 5,340 3,324 5,526 7,729 3,827 5,733 - - - 49,947 84,105 59% City Cemetery Trust 730- - - - - - - - - - - - 6,000 0% Equipment / Vehicle Leasing 750- 983,042 489,584 65,756 135,750 128,509 - 501,098 23,547 - - - 2,327,286 5,500,000 42% Parks Bond Capital 751- 63,156 211,200 140,581 19,839 111,546 2,245 288,513 68,236 - - - 905,316 3,500,000 26% Smart Street Bond 753- 986,652 285,891 512,350 617,149 341,706 1,077,051 659,978 20,695 - - - 4,501,472 10,000,000 45% Eddy St. Commons Capital 759- - - - - - - - 396,250 - - - 396,250 - NA xxx xxx xxx NA Sub Total 1,967,632 4,291,727 2,861,954 2,812,874 2,786,859 3,195,289 3,254,554 3,973,734 2,451,740 - - - 27,596,363 48,415,463 57% Civil City Expenditure 23,354,822 20,927,696 20,605,582 22,621,770 20,281,521 22,595,375 22,610,274 21,785,777 22,779,871 - - - 197,562,687 333,404,535 59% Tax Increment Financing TIF River West - Airport 324 4,348,398 123,050 1,434,861 735,643 590,372 186,766 4,463,883 811,409 1,119,086 - - - 13,813,467 39,618,887 35% TIF West Washington 422- - 2,420 385 - - - - 65,778 - - - 68,583 1,428,292 5% TIF Leighton Plaza 425 5,141 9,302 4,480 11,400 9,310 29,194 7,696 12,611 7,484 - - - 96,618 158,166 61% TIF River East DEV (NE)429 27,144 45,644 101,171 587,302 45,684 343,124 122,068 129,047 76,124 - - - 1,477,306 10,602,696 14% TIF Southside 430 146,124 12,530 17,419 24,812 100,639 6,683 - 10,774 33,396 - - - 352,377 6,917,426 5% TIF Erskine Village 432 3,961,667 - - 904,519 - - - 598 - - - - 4,866,784 4,878,795 100% TIF Douglas Road 435- 150,000 - - - - - 185,608 - - - - 335,608 344,216 97% TIF River East RES (NE RE)436 1,236,500 446,589 - - - - 1,234,500 60,446 186,218 - - - 3,164,253 3,430,231 92% Sub Total 9,724,973 787,115 1,560,351 2,264,061 746,005 565,766 5,828,146 1,210,493 1,488,086 - - - 24,174,996 67,378,709 36% 2017-09 Financial Report - Expe nditu re Su mmary Page 16 of 25 City of South Bend Period Ending:September 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433- - - 816 316 - - - - - - - 1,133 4,500 25% Certified Technology Park 439- - - 1,800,000 - - - - - - 1,800,000 2,200,000 82% Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Industrial Revolving 754- - 14,437 16,553 775 17,679 775 10,814 - - - - 61,033 157,000 39% Sub Total- - 14,437 17,369 1,801,091 17,679 775 10,814 - - - - 1,862,166 2,411,500 77% Debt Service Airport Debt Reserve 2003 315 588 792 902 434 398 1,346 1,323 1,278 935 - - - 7,995 14,000 57% Central Development reserve 328 983 1,323 1,522 725 664 2,249 2,210 2,135 1,563 - - - 13,374 15,000 89% SB Redevelopment Authority 752- 735,236 2,004,503 5 - 345,906 - - 1,475,853 - - - 4,561,503 4,603,405 99% Smart Streets Debt Svc 756- - 394,784 - - - - - 854,784 - - - 1,249,569 855,784 146% Erskine Village Debt Svc 758- 561,229 3,961,668 1 - - - - - - - - 4,522,898 4,522,918 100% xxx xxx xxx NA Sub Total 1,571 1,298,580 6,363,379 1,165 1,062 349,501 3,532 3,412 2,333,136 - - - 10,355,338 10,011,107 103% Redevelopment Commission 9,726,545 2,085,695 7,938,167 2,282,595 2,548,158 932,945 5,832,453 1,224,719 3,821,222 - - - 36,392,500 79,801,316 46% City Operations Total 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 23,528,321 28,442,727 23,010,496 26,601,093 - - - 233,955,187 413,205,851 57% Expenditure report 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 23,528,321 28,442,728 23,010,496 26,601,093 0 0 0 233,955,188 413,205,851 0 0 0 0 0 0(1)0 0 0 0 0(1)0 2017-09 Financial Report - Expe nditu re Su mmary Page 17 of 25 City of South Bend Period Ending:September 30, 2017 Debt Schedule Year of Year of Year of Scheduled Payments Debt (Orig / R efi)Debt at 2017 Princ ipal 2017 Intere st 2017 Debt at 2017 Total Debt Instrume nt De bt Purpose Issue Re funding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payme nt Addition 12/31/2017 Debt Payments Civil City Debt Bond D ebt Amor t sch # 31 CEDIT Bond 1997 2006 2017 408 2/1 8/1--11,870,000.00 430,000.00 430,000.00 9,932.50 0.00 0.00 439,932.50 36 South Bend Building Corporation Public Wo rks Buil ding 2001 2010 2021 404/649 2/1 8/1--9,250,000.00 2,755,000.00 575,000.00 95,994.00 0.00 2,180,000.00 670,994.00 25 Water Works Im provements Water W orks 2002 2012 2023 625 1/1 7/1--5,975,000.00 2,380,000.00 375,000.00 47,600.00 0.00 2,005,000.00 422,600.00 39 South Bend Building Corporation Fire H Q / Pol ice HQ 2003 2012 2023 404/324 2/1 8/1--21,335,000.00 8,885,000.00 1,24 0,000.00 325,740.00 0.00 7,645,000.00 1,565,740.00 24 Water Works Im provements Water W orks 2006 2027 625 1/1 7/1--4,710,000.00 0.00 0.00 0.00 0.00 0.00 0.00 62 Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11/1--4,655,000.00 3,175,000.00 300,000.00 85,812.50 0.00 2,875,000.00 385,812.50 69 Water Works Im provements Water W orks 2009 2030 625 1/1 7/1--5,380,000.00 4,325,000.00 240,000.00 239,938.00 0.00 4,085,000.00 479,938.00 70 Sewage Works Revenue Bonds - 2009 Sewage Wor ks 2009 2028 649 6/1 12/1--3,297,000.00 2,249,643.00 162,472.00 63,214.00 0.00 2,087,171.00 225,686.00 80 20 10 Sewage Works Revenue Bonds Sewage Wor ks 2010 2030 649 6/1 12/1--9,345,000.00 7,145,000.00 395,000.00 298,617.50 0.00 6,750,000.00 693,617.50 93 Sewage Works Revenue Bonds 2011 Sewage Wor ks 2011 2031 649 6/1 12/1--21,500,000.00 17,295,000.00 895,000.00 654,300.00 0.00 16,400,000.00 1,549,300.00 99 20 12 Water Wo rks Revenue Bond Water W orks 2012 2033 625 1/1 7/1--8,300,000.00 6,925,000.00 355,000.00 209,786.26 0.00 6,570,000.00 564,786.26 101 20 12 Sewage Works Revenue Bonds Sewage Wor ks 2012 2032 649 6/1 12/1--25,000,000.00 20,890,000.00 1,06 0,000.00 486,680.00 0.00 19,830,000.00 1,546,680.00 105 20 13A Sewer Bond Refunding Sewage Wor ks 2013 2013 2024 649 6/1 12/1--14,765,000.00 8,050,000.00 1,95 5,000.00 156,170.00 0.00 6,095,000.00 2,111,170.00 116 20 13 Building Corporation EMS / Fire Department 2013 2033 288 2/1 8/1--5,580,000.00 5,145,000.00 225,000.00 177,480.00 0.00 4,920,000.00 402,480.00 133 St. Joseph County PSAP St. Joseph Coun ty PSAP 2014 2034 408 Mo nthl y 2,657,696.50 2,386,507.92 107,652.90 59,107.80 0.00 2,278,855.02 166,760.70 139 Century Center Energy Savings Im provements at Century Ctr.2015 2031 672 5/1 11/1 4,167,897.00 4,145,312.00 46,606.00 144,690.68 0.00 4,098,706.00 191,296.68 141 Parks and Recrea tion Bond Parks Im provements 2015 2035 408 2/1 8/1--5,605,000.00 5,295,000.00 210,000.00 172,256.26 0.00 5,085,000.00 382,256.26 145 Sewage Works Revenue Bonds -2015 Sewer Improvements 2015 2025 649 6/1 12/1--27,440,000.00 24,965,000.00 2,53 0,000.00 499,300.00 0.00 22,435,000.00 3,029,300.00 156 20 16 Water Wo rks Refunding Bonds Refun ding 2000 / 2006 SRF 2016 2027 625 1/1 7/1--3,300,000.00 3,300,000.00 405,000.00 49,500.00 0.00 2,895,000.00 454,500.00 xxx Total Bond Debt 234,877,593.50 129,741,462.92 11,50 6,730.90 3,776,119.50 0.00 118,234,732.02 15,282,850.40 Loans Payable 68 State Revolving Fund Water W orks Improvement 2009 2030 625 1/1 7/1--427,332.00 332,562.00 20,912.00 11,207.34 0.00 311,650.00 32,119.34 82 Interfund Loan 410 - UDAG 1st Source/Marriott Garag e 2010 2015 410 6/15 12/15--2,700,000.00 1,351,597.75 126,142.25 0.00 0.00 1,225,455.50 126,142.25 26 State Revolving Fund Water W orks Improvements 2000 2019 625 1/1 7/1--2,600,000.00 0.00 0.00 0.00 0.00 0.00 0.00 xxx Amy Shirk Total Loans Pa yable 29,822,332.00 1,684,159.75 147,054.25 11,207.34 0.00 1,537,105.50 158,261.59 Capital Leases 51 Chase LED Equipment 2007 2017 101 1/1 7/1--1,531,573.00 194,320.02 194,319.97 6,259.69 0.00 0.05 200,579.66 89 Sun Trust Police, Parks, Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2,068,202.00 0.00 0.00 0.00 0.00 0.00 0.00 90 Capital One Public Funding Solid Waste Containers/Trucks 2011 2016 611 3/15 6/15 9/15 12/15 207,432.00 0.00 0.00 0.00 0.00 0.00 0.00 91 GE Cap ita l Information Technology Police D ept Copie r 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 0.00 0.00 0.00 0.00 0.00 0.00 92 Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 0.00 0.00 0.00 0.00 0.00 0.00 94 Ikon Office Solution s Mayor R icoh MP 2851 SP Copier 2011 2016 101 2/15 5/15 8/15 11/15 2,569.53 0.00 0.00 0.00 0.00 0.00 0.00 95 Sun Trust Equipment Finance Parks-Golf Cars L ease 2012 2016 201 4/15 10/15--344,500.00 0.00 0.00 0.00 0.00 0.00 0.00 97 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15--1,295,000.00 134,585.22 134,585.22 1,140.42 0.00 0.00 135,725.64 98 PNC Equ ipm ent Finance Public Wo rks Vehicles Lease 2012 2017 202/641/640 5/15 11/15--945,674.38 97,793.51 97,793.52 735.98 0.00(0.01)98,529.50 100 PNC Equ ipm ent Finance Public Wo rks Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15--2,806,054.00 575,316.55 575,316.53 5,634.82 0.00 0.02 580,951.35 102 Ikon Office Solution s / Ricoh Wastewater Copier 2012 2017 641 Mo nthl y 1st 5,744.95 756.77 756.77 65.82 0.00 0.00 822.59 103 GE Cap ita l Information Technology Fire D epartment Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 926.68 926.68 27.40 0.00 0.00 954.08 106 Ricoh USA (New)Central Services Copier 2013 2018 222 2/27 5/27 8/27 11/27 3,622.78 815.82 814.82 24.94 0.00 1.00 839.76 107 Ricoh USA Street/Sewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 1,225.93 1,225.93 44.88 0.00 0.00 1,270.81 108 Ricoh USA City Attorne y Copier 2013 2018 101 2/12 5/12 8/12 11/12 5,559.15 1,232.73 1,231.73 39.06 0.00 1.00 1,270.79 109 Ricoh USA Parks & Rec Ricoh Copiers(3)2013 2018 201 2/21 5/21 8/21 11/21 16,129.94 3,575.09 3,574.09 113.15 0.00 1.00 3,687.24 110 PNC Equ ipm ent Finance Vehicle/Equipment Lease 2013 2018 101/202/406/641 1/15 7/15--1,689,669.59 689,257.88 342,533.13 7,367.39 0.00 346,724.75 349,900.52 111 Ricoh USA Engineering Plotter/Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 2,459.26 2,458.26 133.72 0.00 1.00 2,591.98 112 Ricoh USA Building D ept. Copier 2013 2018 600 Mo nthl y 4,093.64 1,491.77 878.55 60.45 0.00 613.22 939.00 113 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24--1,506,465.26 616,891.89 306,011.19 8,569.95 0.00 310,880.70 314,581.14 114 Ricoh USA Adm in & Finance C opier 2013 2018 101 1/16 4/16 7/16 10/16 11,247.97 3,079.36 2,444.79 126.44 0.00 634.57 2,571.23 117 Police Dept. Record Div. Ricoh Police R ecords Copier 2013 2018 101 Mo nthl y 3rd--9,678.26 4,194.14 2,039.23 180.77 0.00 2,154.91 2,220.00 118 Water Works Main Ricoh Copier Water W orks Main Ricoh C opier 2013 2018 620 Mo nthl y 10th--5,647.50 2,448.11 1,189.78 105.62 0.00 1,258.33 1,295.40 119 Water Works Col fax Ricoh Copier Water W orks Colfax Ricoh Cop ier 2013 2018 620 Mo nthl y 16th--4,732.65 2,051.62 997.01 85.51 0.00 1,054.61 1,082.52 120 Water Works Olive Ricoh Copier Water W orks Olive Ricoh Copier 2013 2018 620 Mo nthl y 10th--4,732.65 2,051.62 997.01 85.51 0.00 1,054.61 1,082.52 123 Police Tr aining Dept. Ricoh Copier Training Copier 2014 2019 101 Mo nthl y 30th--4,263.00 2,076.44 890.27 93.73 0.00 1,186.17 984.00 124 Police/Public Works Vehicle Lease 2014 City Vehicles 2014 2019 Vario us 4/1 10/1--1,959,485.95 1,193,797.05 391,803.77 16,992.78 0.00 801,993.28 408,796.55 125 HP Co mputer Lease #1 Computer Equipment Lease 2014 2018 various Mo nthl y 8th--137,104.95 63,525.63 32,632.97 2,191.39 0.00 30,892.66 34,824.36 126 HP Co mputer Lease #2 Computer Equipment Lease 2014 2018 201 and 620 Mo nthl y 8th--4,000.00 1,947.01 950.39 70.09 0.00 996.62 1,020.48 127 HP Co mputer Lease #4 Computer Equipment Lease 2014 2018 404 Mo nthl y 8th--5,886.15 2,795.30 1,412.70 83.34 0.00 1,382.60 1,496.04 128 HP Co mputer Lease #6 Computer Equipment Lease 2014 2018 201 Mo nthl y 8th--3,755.50 1,917.99 883.34 73.78 0.00 1,034.65 957.12 129 HP Co mputer Lease #7 Computer Equipment Lease 2014 2018 620 Mo nthl y 8th--1,326.00 706.05 315.44 21.40 0.00 390.61 336.84 130 Solid Waste Copier Ricoh USA Copier 2014 2019 611 Mo nthl y 17th--5,351.65 3,302.32 1,071.78 157.86 0.00 2,230.54 1,229.64 131 Police Comm unications Copier Ricoh USA Copier 2014 2019 101 Mo nthl y 12th--8,843.00 4,876.99 1,804.44 227.40 0.00 3,072.55 2,031.84 132 Or ganic Resour ces & Wastewater Ricoh USA Copiers 2014 2019 641 Mo nthl y 21st--12,260.18 6,558.16 2,513.45 303.55 0.00 4,044.71 2,817.00 134 Water Works Copier - North Station Ricoh USA Copiers 2014 2019 620 Mo nthl y 19th--4,732.65 2,132.25 992.44 93.08 0.00 1,139.81 1,085.52 136 HP Co mputer Lease #8 Computer Equipment Lease 2015 2019 404/201/611 Mo nthl y 16th--19,603.94 11,854.14 4,538.52 494.04 0.00 7,315.62 5,032.56 137 Animal Control R icoh Copier Ricoh USA Copiers 2015 2020 600 Mo nthl y 30th--5,261.50 3,591.88 1,033.37 182.47 0.00 2,558.51 1,215.84 138 HP Co mputer Lease #9 Computer Equipment Lease 2015 2019 Vario us Mo nthl y TBD--135,958.05 94,710.62 30,905.89 3,998.51 0.00 63,804.73 34,904.40 140 Vehicle & Equip. Lease Vehicle/Equipment Lease 2015 2020 Vario us 1/15 7/15--3,425,273.58 2,763,845.35 676,723.50 35,941.86 0.00 2,087,121.85 712,665.36 143 HP Co mputer Lease #11 Computer Equipment Lease 2015 2019 404 Mo nthl y--3,040.00 2,161.06 695.77 85.67 0.00 1,465.29 781.44 144 PNC Veh icle Lea se No. 2 Vehicle Lease Purchase 2015 2020 Vario us 5/15 11/15--1,267,183.00 1,021,855.36 249,580.62 14,814.26 0.00 772,274.74 264,394.88 146 Parks & Rec. R icoh Copier Ricoh Copier 2016 2020 201 Mo nthl y--4,302.06 3,454.72 810.05 176.59 0.00 2,644.67 986.64 147 Central Services Lan ier Copier C51005 C opier 2016 2020 222 Mo nthl y--32,525.00 28,667.19 6,046.87 1,368.89 0.00 22,620.32 7,415.76 2017-09 Finan c ia l Rep ort - De bt P age 18 o f 25 City of South Bend Period Ending:September 30, 2017 Debt Schedule Year of Year of Year of Scheduled Payments Debt (Orig / R efi)Debt at 2017 Princ ipal 2017 Intere st 2017 Debt at 2017 Total Debt Instrume nt De bt Purpose Issue Re funding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payme nt Addition 12/31/2017 Debt Payments 148 Central Services Lan ier Copier C6502 Co pier 2016 2020 222 Mo nthl y--11,413.00 10,059.31 2,121.84 480.36 0.00 7,937.47 2,602.20 149 Vehicle & Equip. Lease Public Wo rks Vehicles Lease 2016 2021 Vario us 2/15 8/15--3,339,830.00 3,016,484.17 651,783.72 45,609.91 0.00 2,364,700.45 697,393.63 150 HP Co mputer Lease Copier Lease 2016 2020 Vario us Mo nthl y--17,439.85 14,013.99 3,908.91 574.29 0.00 10,105.08 4,483.20 151 Admin and Finance Ricoh Copier Copier Lease 2016 2021 101 Mo nthl y--10,923.63 8,938.27 2,047.09 458.15 0.00 6,891.18 2,505.24 152 PNC Veh icle / Equip Lease No. 2 Vehicle / Equipment Lease 2016 2021 Vario us 1/14 7/14--3,992,548.72 3,992,548.72 770,391.63 62,984.68 0.00 3,222,157.09 833,376.31 153 PNC Veh icle / Equip Lease Amend 1 Parks and Rec reation 2016 2021 201 1/17 7/17--78,808.00 78,808.00 15,287.29 1,141.51 0.00 63,520.71 16,428.80 154 PNC Veh icle / Equip Lease No. 3 Parks & Rec / IT 2016 2021 201/279 4/19 10/19--1,256,096.99 1,256,096.99 244,070.10 17,538.46 0.00 1,012,026.89 261,608.56 155 HP Co mputer Lease No. 13 Computer Equipment Lease 2016 2020 Vario us Mo nthl y---156,029.30 150,562.73 33,567.37 6,602.27 0.00 116,995.36 40,169.64 157 Venu e, Parks, Art Copier Ricoh Copier 2016 2021 201 Mo nthl y---3,184.06 3,184.06 918.51 382.49 0.00 2,265.55 1,301.00 158 Public Finance.com Inc 2017 Vehicle Lease No. 1 2017 2022 Vario us 1/14 7/14--2,916,500.00 0.00 0.00 0.00 2,91 6,500.00 0.00 0.00 159 Mayor/W aste Water/Fire Ricoh 2017 Ricoh Copier Lea se 2017 2021 101/641/287 Mo nthl y---15,702.09 0.00 3,285.05 843.03 1 5,702.09 12,417.04 4,128.08 160 HP Co mputer Refresh Lease No. 14 2017 Ricoh Copier Lea se 2017 2021 279/201 Mo nthl y---10,305.25 0.00 1,852.45 359.95 1 0,305.25 8,452.80 2,212.40 162 Vehicle & Equip. Lease No. 2 Vehicle / Equipment Lease 2017 2021 404 2/15 8/15--1,632,000.00 0.00 0.00 0.00 1,63 2,000.00 1,632,000.00 0.00 xxx Total Capital Le ase 34,787,495.21 16,078,945.72 4,80 4,933.75 245,147.31 4,57 4,507.34 11,300,019.31 5,047,868.66 Total Civil City 299,487,420.71 147,504,568.39 16,45 8,718.90 4,032,474.15 4,57 4,507.34 131,071,856.83 20,488,980.65 Redevelopment Commission Debt Bond D ebt 7 Century Center Lease Rental Revenue Century Center 1994 20 01/2011 2018 407 2/1 8/1--6,825,000.00 720,000.00 475,000.00 16,875.00 0.00 245,000.00 491,875.00 8 Col lege Football Hall of Fame Hall of Fame 1994 20 00/2011 2018 313 2/1 8/1--15,370,000.00 1,830,000.00 1,21 5,000.00 53,407.50 0.00 615,000.00 1,268,407.50 11 South Bend Building Corporation Morris PAC 1998 2009 2017 408 2/1 8/1--13,300,000.00 515,000.00 515,000.00 10,300.00 0.00 0.00 525,300.00 12 TJX Special Taxing District 2002 2014 2022 324/404/414 1/1 7/1--6,620,000.00 2,210,000.00 415,000.00 66,300.00 0.00 1,795,000.00 481,300.00 5 Downtown Central Area TIF 2003 2011 2024 420 2/1 8/1--19,795,000.00 12,500,000.00 1,31 5,000.00 598,625.00 0.00 11,185,000.00 1,913,625.00 6 Airport Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1--14,420,000.00 7,125,000.00 750,000.00 341,210.50 0.00 6,375,000.00 1,091,210.50 22 Erskine Village TIF Develop ment Bond Erskine Village 2005 2027 432 2/1 8/1--5,485,000.00 3,800,000.00 3,80 0,000.00 161,666.72 0.00 0.00 3,961,666.72 54 Le ase Rental Revenue Bonds of 2008 Eddy Street C om mons 2008 2027 429 2/15 8/15--36,000,000.00 30,075,000.00 1,31 5,000.00 1,148,181.26 0.00 28,760,000.00 2,463,181.26 81 Covel eski Stadium R ecovery Coveleski Stadiu m 2010 2019 377 1/15 7/15--4,980,000.00 1,665,000.00 650,000.00 77,155.00 0.00 1,015,000.00 727,155.00 122 Synagogue at Coveleski Im provements Coveleski Stadiu m 2014 2018 377 1/31---500,000.00 200,000.00 100,000.00 0.00 0.00 100,000.00 100,000.00 135 20 15 Redevelopment Smart Streets Sma rts Streets 2015 2037 324 2/1 8/1--25,000,000.00 25,000,000.00 460,000.00 394,784.38 0.00 24,540,000.00 854,784.38 161 Studebaker Pr oject Façade Im provement Bldg 84 2017 2018 324 One tim e---3,500,000.00 0.00 3,50 0,000.00 0.00 3,50 0,000.00 0.00 3,500,000.00 163 20 17 Eddy St. Com mons Phase II Ed dy St. Commons Phase II 2017 2037 436 2/15 8/15--25,000,000.00 0.00 0.00 0.00 25,00 0,000.00 25,000,000.00 0.00 xxx Total Bond Debt 182,288,788.00 85,640,000.00 14,51 0,000.00 2,868,505.36 28,50 0,000.00 99,630,000.00 17,378,505.36 Loans Payable 3 Indiana Developm ent Fin anc e Authority Bosch Property (Nonforgive)2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 302,069.15 63,660.08 8,350.36 0.00 238,409.07 72,010.44 4 Indiana Developm ent Fin anc e Authority Bosch Property (Forgive)2001 2021 210----260,000.00 83,482.06 0.00 0.00 0.00 65,888.51 0.00 64 Interfund Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15--1,040,319.00 323,005.00 322,201.00 12,088.00 0.00 804.00 334,289.00 84 Interfund Fund 412 - Major Moves Triangle Development 2011 2029 436 2/15 8/15--2,000,000.00 1,329,573.43 94,621.29 26,120.71 0.00 1,234,952.14 120,742.00 85 Interfund Fund 412 - Major Moves Eddy Street C om mons 2011 2026 436 2/15 8/15--4,100,000.00 2,384,347.86 661,383.84 111,052.16 0.00 1,722,964.02 772,436.00 86 Interfund Fund 209 to Airport 324 Prair ie Ave Brownfield Project 2011 2020 324 8/9---500,000.00 400,000.00 100,000.00 0.00 0.00 300,000.00 100,000.00 142 Interfund Fund 412 - Major Moves Parking Garage Im provements 2016 2022 601 6/1 12/1 1,500,000.00 517,304.69 229,174.05 20,825.95 75 0,000.00 1,038,130.64 250,000.00 xxx Total Loans Pa yable 15,627,499.06 5,339,782.19 1,47 1,040.26 178,437.18 75 0,000.00 4,601,148.38 1,649,477.44 Capital Lease xxx Total Capital Le ase 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Lea ses 13 Transpo Lease Main / Colfax Garage 2006 2025 324 3/15 9/15--2,510,278.00 1,435,338.00 129,838.00 70,162.00 0.00 1,305,500.00 200,000.00 xxx Tot al Lease 5,510,278.00 1,435,338.00 129,838.00 70,162.00 0.00 1,305,500.00 200,000.00 Total Redevelopment Commission 203,426,565.06 92,415,120.19 16,11 0,878.26 3,117,104.54 29,25 0,000.00 105,536,648.38 19,227,982.80 Total Debt 502,913,985.77 239,919,688.58 32,56 9,597.16 7,149,578.69 33,82 4,507.34 236,608,505.21 39,716,963.45 2017-09 Finan c ia l Rep ort - De bt P age 19 o f 25 City of South Bend Period Ending:September 30, 2017 Monthly Debt Schedule` Year of Year of Year of Scheduled Payments Debt (Orig / Refi)Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refunding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payments Additions 9/30/2017 Civil City Debt Bond Debt Amort sch # 3 6 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1--9,250,000.00 2,755,000.00 575,000.00 95,994.00 0.00 2,180,000.00 2 5 Water Works Improvements W ater Works 2002 2012 2023 625 7/1 12/31--5,975,000.00 2,380,000.00 0.00 23,800.00 0.00 2,380,000.00 3 9 South Bend Building Corporation Fire HQ / Police HQ 2003 2012 2023 404/324 2/1 8/1--21,335,000.00 8,885,000.00 1,240,000.00 325,740.00 0.00 7,645,000.00 2 4 Water Works Improvements W ater Works 2006 2027 625 7/1 12/31--4,710,000.00 0.00 0.00 0.00 0.00 0.00 6 2 Century Center Special Tax Bonds Century Center 2008 2028 324 4/1 11/1--4,655,000.00 3,175,000.00 0.00 197,500.00 0.00 3,175,000.00 6 9 Water Works Improvements W ater Works 2009 2030 625 7/1 12/31--5,380,000.00 4,325,000.00 0.00 119,969.00 0.00 4,325,000.00 7 0 Sewage W orks Revenue Bonds - 2009 Sewage Works 2009 2028 649 6/1 12/1--3,297,000.00 2,249,643.00 0.00 31,607.00 0.00 2,249,643.00 8 0 2010 Sewage W orks Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1--9,345,000.00 7,145,000.00 0.00 149,308.75 0.00 7,145,000.00 9 3 Sewage W orks Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1--21,500,000.00 17,295,000.00 0.00 327,150.00 0.00 17,295,000.00 9 9 2012 Water Works Rev enue Bond W ater Works 2012 2033 625 1/1 7/1--8,300,000.00 6,925,000.00 0.00 104,893.13 0.00 6,925,000.00 10 1 2012 Sewage W orks Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1--25,000,000.00 20,890,000.00 0.00 243,340.00 0.00 20,890,000.00 10 5 2013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1--14,765,000.00 8,050,000.00 0.00 78,085.00 0.00 8,050,000.00 11 6 2013 Building Corporation EMS / Fire Department 2013 2033 288 2/1 8/1--5,580,000.00 5,145,000.00 225,000.00 177,480.00 0.00 4,920,000.00 13 3 St. Joseph County PSAP St. Joseph County PSAP 2014 2034 408 Monthly---2,657,696.50 2,386,507.92 75,357.03 41,375.46 0.00 2,311,150.89 13 9 Century Center Energy Savings Improvements Century Ctr.2015 2031 672 5/1 11/1--4,167,897.00 4,145,312.00 22,585.00 72,542.96 0.00 4,122,727.00 14 1 Parks and Rec Bond Parks Improvements 2015 2035 408 2/1 8/1--5,605,000.00 5,295,000.00 215,000.00 175,482.00 0.00 5,080,000.00 14 5 Sewage W orks Revenue Bonds - 2015 Sewer Bond Improvements 2015 2025 649 6/1 12/1--27,440,000.00 24,965,000.00 0.00 249,650.00 0.00 24,965,000.00 15 6 2016 Water Works Refunding Bonds Refundi ng 2000 / 2006 SRF 2016 2027 625 1/1 7/1--3,300,000.00 3,300,000.00 0.00 50,600.00 0.00 3,300,000.00 xxx Total Bond Debt 234,877,593.50 129,741,462.92 2,782,942.03 2,474,449.80 0.00 126,958,520.89 Loans Payable 6 8 State Rev olving Fund W ater Works Improvement 2009 2030 625 7/1 12/31--427,332.00 332,562.00 0.00 5,603.67 0.00 332,562.00 8 2 Interf und Loan 410 - UDAG 1st Source/Marriott Garage 2010 2015 410 6/15 12/15--2,700,000.00 1,351,597.75 94,328.75 0.00 0.00 1,257,269.00 2 6 State Rev olving Fund W ater Works Improvements 2000 2019 625 7/1 12/31--2,600,000.00 0.00 0.00 0.00 0.00 0.00 xxx Amy Shirk Total Loans Payable 29,822,332.00 1,684,159.75 94,328.75 5,603.67 0.00 1,589,831.00 Capital Leases 5 1 Chase LED Equipment 2007 2017 101 1/1 7/1--1,531,573.00 194,320.02 194,320.02 6,259.69 0.00 0.00 8 9 Sun Trust Police, Parks, Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2,068,202.00 0.00 0.00 0.00 0.00 0.00 9 0 Capital One Public Funding Solid W aste Containers/Trucks 2011 2016 611 3/15 6/15 9/15 12/15 207,432.00 0.00 0.00 0.00 0.00 0.00 9 1 GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 0.00 0.00 0.00 0.00 0.00 9 2 Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 0.00 0.00 0.00 0.00 0.00 9 4 Ikon Office Solutions Mayor Ricoh MP 2851 SP Copier 2011 2016 101 2/15 5/15 8/15 11/15 2,569.53 0.00 0.00 0.00 0.00 0.00 9 5 Sun Trust Equipment Finance Parks-Golf Cars Lease 2012 2016 201 4/15 10/15--344,500.00 0.00 0.00 0.00 0.00 0.00 9 7 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15--1,295,000.00 134,585.22 0.00 0.00 0.00 134,585.22 9 8 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15--945,674.38 97,793.51 0.00 0.00 0.00 97,793.51 10 0 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15--2,806,054.00 575,316.55 575,316.55 5,634.81 0.00 0.00 10 2 Ikon Office Solutions / Ricoh W astewater Copier 2012 2017 641 Monthly 1st--5,744.95 756.77 756.77 14.34 0.00 0.00 10 3 GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 926.68 926.68 27.40 0.00 0.00 10 6 Ricoh USA Central Services Copier 2013 2018 222 2/27 5/27 8/27 11/27 3,622.78 815.82 607.81 22.01 0.00 208.01 10 7 Ricoh USA Street/Sewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 1,225.93 909.23 43.87 0.00 316.70 10 8 Ricoh USA City Attorney Copier 2013 2018 101 2/12 5/12 8/12 11/12 5,559.15 1,232.73 918.62 34.48 0.00 314.11 10 9 Ricoh USA Parks & Rec Ricoh Copiers(3)2013 2018 201 3/21 6/21 9/21 12/21 16,129.94 3,575.09 2,665.52 117.07 0.00 909.57 11 0 PNC Equipment Finance Vehicle/Equipment Lease 2013 2018 101/202/406/641 1/15 7/15--1,689,669.59 689,257.88 342,533.13 7,367.39 0.00 346,724.75 11 1 Ricoh USA Engineering Plotter/Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 2,459.26 1,823.95 120.05 0.00 635.31 11 2 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly--4,093.64 1,491.77 654.35 49.90 0.00 837.42 11 3 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24--1,506,465.26 616,891.89 152,401.70 4,888.87 0.00 464,490.19 11 4 Ricoh USA Admin & Finance Copier 2013 2018 101 1/16 4/16 7/16 10/16 11,247.97 3,079.36 1,820.29 108.06 0.00 1,259.07 11 7 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd--9,678.26 4,194.14 1,518.83 146.17 0.00 2,675.31 11 8 Water Works Main Ricoh Copier W ater Works Main Ricoh Copier 2013 2018 620 Monthly 10th--5,647.50 2,448.11 886.13 85.42 0.00 1,561.98 11 9 Water Works Colfax Ricoh Copier W ater Works Colf ax Ricoh Copier 2013 2018 620 Monthly 16th--4,732.65 2,051.62 742.58 71.56 0.00 1,309.04 12 0 Water Works Olive Ricoh Copier W ater Works Olive Ricoh Copier 2013 2018 620 Monthly 10th--4,732.65 2,051.62 742.58 71.56 0.00 1,309.04 12 3 Police Training Dept. Ricoh Copier Training Copier 2014 2019 101 Monthly 30th--4,263.00 2,076.44 663.01 74.99 0.00 1,413.43 12 4 Key Gov ernment Finance 2014 City Vehicles 2014 2019 v arious 4/1 10/1--1,959,485.95 1,193,797.05 195,145.63 9,252.64 0.00 998,651.42 12 5 HP Computer Lease #1 Computer Equipment Lease 2014 2018 v arious Monthly 8th--137,104.95 63,525.63 24,336.79 1,781.48 0.00 39,188.84 12 6 HP Computer Lease #2 Computer Equipment Lease 2014 2018 201 and 620 Monthly 8th--4,000.00 1,947.01 708.65 56.71 0.00 1,238.36 12 7 HP Computer Lease #4 Computer Equipment Lease 2014 2018 404 Monthly 8th--5,886.15 2,795.30 1,054.39 67.64 0.00 1,740.91 12 8 HP Computer Lease #6 Computer Equipment Lease 2014 2018 201 Monthly 8th--3,755.50 1,917.99 658.47 59.37 0.00 1,259.52 12 9 HP Computer Lease #7 Computer Equipment Lease 2014 2018 620 Monthly 8th--1,326.00 706.05 235.45 17.18 0.00 470.60 13 0 Solid Waste Copier Ricoh USA Copier 2014 2019 611 Monthly 17th--5,351.65 3,302.32 798.19 124.04 0.00 2,504.13 13 1 Police Communications Copier Ricoh USA Copier 2014 2019 101 Monthly 12th--8,843.00 4,876.99 1,343.82 180.06 0.00 3,533.17 13 2 Organic Resourc es & Wastewater Ricoh USA Copiers 2014 2019 641 Monthly 21st--12,260.18 6,558.16 1,871.86 240.89 0.00 4,686.30 13 4 Water Works Copier - North Station Richo USA Copiers 2014 2019 620 Monthly 19th--4,732.65 2,132.25 739.17 74.97 0.00 1,393.08 13 6 HP Computer Lease #8 Computer Equipment Lease 2015 2019 404/201/611 Monthly 16th--19,603.94 11,854.14 3,382.38 392.04 0.00 8,471.76 13 7 Animal Control Ricoh Copier Ricoh USA Copiers 2015 2020 600 Monthly 30th--5,261.50 3,591.88 769.34 142.54 0.00 2,822.54 2017-09 Financial Report - Debt Page 20 of 25 City of South Bend Period Ending:September 30, 2017 Monthly Debt Schedule` Year of Year of Year of Scheduled Payments Debt (Orig / Refi)Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refunding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payments Additions 9/30/2017 13 8 HP Computer Lease #9 Computer Equipment Lease 2015 2019 Various Monthly TBD--135,958.05 94,710.62 23,035.52 3,142.78 0.00 71,675.10 14 0 Vehicle & Equip. Lease Vehicle/Equipment Lease 2015 2020 Various 1/15 7/15--3,425,273.58 2,763,845.35 676,723.50 35,941.86 0.00 2,087,121.85 14 3 HP Computer Lease #11 Computer Equipment Lease 2015 2019 404 Monthly 3,040.00 2,161.06 518.80 67.28 0.00 1,642.26 14 4 PNC Vehicle Lease No. 2 Vehicle Lease Purchase 2015 2020 v arious 5/15 11/15--1,267,183.00 1,021,855.36 124,310.54 7,886.90 0.00 897,544.82 14 6 Parks & Recreation Copi er Ricoh Copier 2016 2020 201 Monthly 4,302.06 3,454.72 603.19 136.79 0.00 2,851.53 14 7 Central Serv ices Lanier Copier C51005 Copier 2016 2020 222 Monthly---32,525.00 28,667.19 4,505.16 1,056.66 0.00 24,162.03 14 8 Central Serv ices Lanier Copier C6502 2016 2020 222 Monthly---11,413.00 10,059.31 1,580.85 370.80 0.00 8,478.46 14 9 Vehicle & Equip. Lease Public Works Vehicles Lease 2016 2021 v arious 2/15 8/15 3,339,830.00 3,016,484.17 651,783.72 45,609.90 0.00 2,364,700.45 15 0 HP Computer Lease Computer Lease- Refresh 2016 2020 404/641/620 Monthly---17,439.85 14,013.99 2,914.46 447.94 0.00 11,099.53 15 1 Admin and Financ e Ricoh Copier MPC8002SP Copier 2016 2021 101 Monthly---10,923.63 8,938.27 1,524.31 354.62 0.00 7,413.96 15 2 PNC Vehicle / Equip Lease No. 2 Vehicle / Equipment Lease 2016 2021 v arious 1/14 7/14--3,992,548.72 3,992,548.72 770,391.63 62,984.69 0.00 3,222,157.09 15 3 PNC Vehicle / Equip Lease Amend 1 Parks and Recreation 2016 2012 201 1/17 7/17--78,808.00 78,808.00 15,287.29 1,141.51 0.00 63,520.71 15 4 PNC Vehicle / Equip Lease No. 3 Parks & Rec / IT 2016 2021 201/279 4/19 10/19--1,256,096.99 1,256,096.99 121,761.99 9,042.29 0.00 1,134,335.00 15 5 HP Computer Lease No. 13 Computer Equipment Lease 2016 2020 v arious Monthly---156,029.30 150,562.73 25,021.39 5,114.84 0.00 125,541.34 15 7 Venue, Parks, Art Copier Ricoh Copier 2016 2021 201 Monthly---3,184.06 3,184.06 772.53 333.34 0.00 2,411.53 15 8 Public Finance.com Inc 2017 Vehicle Lease No. 1 2017 2022 v arious 1/14 7/14--2,916,500.00 0.00 0.00 0.00 2,916,500.00 2,916,500.00 15 9 Mayor/Waste W ater/Fire Ricoh 2017 Ricoh Copier Lease 2017 2021 101/641/287 Monthly---15,702.09 0.00 2,393.75 608.49 15,702.09 13,308.34 16 0 HP Computer Ref resh Lease No. 14 2017 Ricoh Copier Lease 2017 2021 279/201 Monthly---10,305.25 0.00 1,289.32 259.36 10,305.25 9,015.93 16 2 Vehicle & Equip. Lease No. 2 Vehicle / Equipment Lease 2017 2021 404 2/15 8/15--1,632,000.00 0.00 0.00 0.00 1,632,000.00 1,632,000.00 xxx Total Capital Lease 34,787,495.21 16,078,945.72 3,935,669.84 212,027.25 4,574,507.34 16,717,783.22 Total Civil City 299,487,420.71 147,504,568.39 6,812,940.62 2,692,080.72 4,574,507.34 145,266,135.11 Redevelopment Commission Debt Bond Debt 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1--6,825,000.00 720,000.00 475,000.00 16,875.00 0.00 245,000.00 8 College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1--15,370,000.00 1,830,000.00 1,215,000.00 53,407.50 0.00 615,000.00 1 2 TJX Special Taxing District 2002 2014 2022 324/404/414 1/1 7/1--6,620,000.00 2,210,000.00 0.00 33,150.00 0.00 2,210,000.00 5 Downtown Central Area TIF 2003 2011 2024 420 2/1 8/1--19,795,000.00 12,500,000.00 1,315,000.00 598,625.00 0.00 11,185,000.00 6 Airport Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1--14,420,000.00 7,125,000.00 750,000.00 341,210.50 0.00 6,375,000.00 2 2 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1--5,485,000.00 3,800,000.00 3,800,000.00 161,666.72 0.00 0.00 5 4 Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15--36,000,000.00 30,075,000.00 1,315,000.00 1,148,181.26 0.00 28,760,000.00 8 1 Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15--4,980,000.00 1,665,000.00 650,000.00 77,155.00 0.00 1,015,000.00 12 2 Synagogue at Coveleski Improvements Coveleski Stadium 2014 2018 377 1/31---500,000.00 200,000.00 0.00 0.00 0.00 200,000.00 13 5 2015 Redevelopment Smart Streets Smart Streets 2015 2037 324 2/1 8/1--25,000,000.00 25,000,000.00 460,000.00 789,568.76 0.00 24,540,000.00 16 1 Studebaker Project Façade Improvement Bldg 84 2017 2018 324 One-time---3,500,000.00 0.00 0.00 0.00 3,500,000.00 3,500,000.00 16 3 2017 Eddy St. Commons Phas e II Eddy St. Commons Phase II 2017 2037 436 2/15 8/15--25,000,000.00 0.00 0.00 0.00 25,000,000.00 25,000,000.00 xxx Total Bond Debt 182,288,788.00 85,640,000.00 10,495,000.00 3,230,139.74 28,500,000.00 103,645,000.00 Loans Payable 3 Indiana Development Finance Authority Bos ch Property (Nonforgive)2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 302,069.15 47,566.24 6,441.59 0.00 254,502.91 4 Indiana Development Finance Authority Bos ch Property (Forgiv e)2001 2021 210----260,000.00 83,482.06 0.00 0.00 0.00 66,406.56 8 4 Interf und Fund 412 - Major Moves Triangle Development 2011 2029 436 2/15 8/15--2,000,000.00 1,329,573.43 94,621.29 26,120.71 0.00 1,234,952.14 8 5 Interf und Fund 412 - Major Moves Eddy Street Commons 2011 2026 436 2/15 8/15--4,100,000.00 2,384,347.86 326,609.30 59,608.70 0.00 2,057,738.56 8 6 Interf und Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 8/9---500,000.00 400,000.00 100,000.00 0.00 0.00 300,000.00 14 2 Interf und Fund 412 - Major Moves Parking Garage Improvements 2016 2022 601 6/1 12/1--1,500,000.00 517,304.69 0.00 0.00 750,000.00 1,267,304.69 xxx Total Loans Payable 15,627,499.06 5,339,782.19 891,801.83 104,773.00 750,000.00 5,180,904.86 Capital Lease xxx Total Capital Lease 0.00 0.00 0.00 0.00 0.00 0.00 Leases 1 3 Transpo Lease Main / Colfax Garage 2006 2025 324 3/15 9/15--2,510,278.00 1,435,338.00 129,837.00 70,163.00 0.00 1,305,501.00 xxx Total Lease 5,510,278.00 1,435,338.00 129,837.00 70,163.00 0.00 1,305,501.00 Total Redevelopment Commission 203,426,565.06 92,415,120.19 11,516,638.83 3,405,075.74 29,250,000.00 110,131,405.86 Total Debt 502,913,985.77 239,919,688.58 18,329,579.45 6,097,156.46 33,824,507.34 255,397,540.97 2017-09 Financial Report - Debt Page 21 of 25 City of South Bend Staffing Headcount Summary Budget Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1,107 1,080 1,069 1,082 1,078 1,076 1,093 1,089 1079 1092 0 0 0 Part Time Staff 115 119 142 155 168 145 139 155 159 0 0 0 Temporary / Seasonal 12 11 13 41 86 206 202 80 39 0 0 0 City Total 1,207 1,199 1,237 1,274 1,330 1,444 1,430 1314 1290 0 0 0 2017-09 Financial Report - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Amended Budget FT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 7 6 6 6 5 6 8 8 8 9 0 0 0 311 Call Center 6 6 6 6 7 7 6 6 6 6 0 0 0 Admin & Finance 23 20 21 22 23 23 23 23 23 23 0 0 0 Innovation/ Technology Office 18 14 14 15 14 16 17 17 17 17 0 0 0 Safety & Risk 2 2 2 2 2 2 2 2 2 2 0 0 0 Clerk 5 5 5 5 5 5 5 5 5 5 0 0 0 Common Council 9 9 9 9 9 9 9 9 9 9 0 0 0 Central Services 40 38 39 37 37 38 39 38 38 40 0 0 0 Legal Department 11 11 11 10 10 10 10 11 9 9 0 0 0 Sub Total 121 111 113 112 112 116 119 119 117 120 0 0 0 Code Enf. /Animal Control/ Unsafe Bldg.29 24 26 28 28 29 28 29 29 29 0 0 0 Dept. of Community Investment 23 22 20 21 21 20 20 20 20 20 0 0 0 Parks & Recreation Administration 6 6 6 6 6 6 6 6 6 6 0 0 0 Maintenance 50 45 47 48 47 47 48 48 48 48 0 0 0 Golf Operations 8 7 8 7 8 8 8 8 8 8 0 0 0 Recreation Ops 21 22 21 21 21 21 22 22 22 21 0 0 0 Zoological Ops 1 1 1 1 1 1 1 1 1 1 0 0 0 Graffiti Removal 1 1 1 1 1 1 1 1 1 1 0 0 0 Recreation Non-reverting 1 1 1 1 1 1 0 0 0 0 0 0 0 Marketing and Events 10 8 10 10 10 10 10 10 10 10 0 0 0 Sub Total 98 91 95 95 95 95 96 96 96 95 0 0 0 Public Safety Police 289 284 272 282 280 278 288 283 280 280 0 0 0 Fire 264 268 267 266 263 261 259 260 260 270 0 0 0 Sub Total 553 552 539 548 543 539 547 543 540 550 0 0 0 Public Works Office of Sustainability 2 2 2 2 2 2 2 2 2 2 0 0 0 Engineering 18 18 18 20 20 20 20 20 20 18 0 0 0 Solid Waste Operations 26 25 25 26 25 24 25 25 26 25 0 0 0 Street Operations 55 54 54 54 54 53 56 54 52 52 0 0 0 Sewer Operations 621 37 37 37 37 37 35 37 37 37 37 0 0 0 Waste Water Ops 630 45 45 45 44 44 45 45 45 42 45 0 0 0 Organic Resources 6 6 5 5 6 6 6 6 6 6 0 0 0 Water Utility Ops 65 64 63 63 63 64 65 66 65 66 0 0 0 Sub Total 254 251 249 251 251 249 256 255 250 251 0 0 0 Building Department 14 14 14 14 14 14 14 14 14 14 0 0 0 Human Rights 6 6 6 6 6 6 5 5 5 5 0 0 0 Morris & Palais 9 9 7 7 8 8 8 8 8 8 0 0 0 City Total 1,107 1,080 1,069 1,082 1,078 1,076 1,093 1,089 1,079 1,092 - - - 2017-09 Financial Report - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1 1 1 1 1 0 0 0 0 0 0 0 311 Call Center 2 2 2 0 0 2 2 2 2 0 0 0 Admin & Finance 0 0 0 0 0 0 0 0 0 0 0 0 Safety and Risk 0 0 0 0 0 0 0 0 0 0 0 0 Innovation/ Technology Office 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal Department 1 1 1 1 1 1 1 1 1 0 0 0 Sub Total 5 4 4 2 2 3 3 3 3 0 0 0 Code Enf. / Animal Control 3 2 3 3 3 4 4 4 4 0 0 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 1 1 1 1 1 1 0 1 1 0 0 0 Maintenance 11 11 11 15 14 13 13 14 14 0 0 0 Golf Operations 2 0 18 41 54 54 53 44 38 0 0 0 Recreation Ops 46 54 54 46 48 42 40 43 48 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 4 4 4 1 1 0 1 1 1 0 0 0 Marketing & Events 1 1 1 1 1 1 1 1 1 0 0 0 Sub Total 65 70 88 104 118 110 108 103 102 0 0 0 Public Safety Police 25 25 29 27 27 10 5 26 28 0 0 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 1 1 1 1 0 0 0 Sub Total 25 25 29 27 27 11 6 27 29 0 0 0 Public Works` Central Services 1 1 1 1 1 1 1 1 1 0 0 0 Engineering 2 2 2 3 2 2 2 2 3 0 0 0 Traffic & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Ops 0 0 0 0 0 0 0 0 0 0 0 0 Street Ops 7 8 9 9 9 7 7 7 9 0 0 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 3 3 2 2 2 3 4 4 4 0 0 0 Sub Total 13 14 14 15 14 13 14 14 17 0 0 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 4 4 4 4 4 4 4 4 4 0 0 0 City Total 115 119 142 155 168 145 139 155 159 0 0 0 2017-09 Financial Report - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Paid Temporary, Seasonal, and Intern Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 0 0 0 0 0 0 1 1 0 0 0 0 Admin & Finance 1 1 0 0 1 1 1 0 0 0 0 0 Safety and Risk 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 2 1 0 0 1 1 2 1 0 0 0 0 Code Enfor. / Animal 1 1 1 1 1 0 2 2 0 0 0 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 0 0 0 0 0 0 1 0 0 0 0 0 Maintenance 1 1 2 12 29 36 32 24 17 0 0 0 Golf Operations 0 0 1 1 2 3 5 7 3 0 0 0 Recreation Ops 3 2 2 15 40 129 127 29 11 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 4 3 5 28 71 168 165 60 31 0 0 0 Public Safety Police 0 0 0 0 0 14 14 5 1 0 0 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 0 0 0 0 0 14 14 5 1 0 0 0 Public Works Central Services 0 0 0 0 0 1 0 1 0 0 0 0 Engineering 3 4 4 4 1 7 7 1 1 0 0 0 Energy / Sustainability 0 0 0 0 0 0 0 0 0 0 0 0 Traffic & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Ops 0 0 0 0 0 0 0 0 0 0 0 0 Street Ops 1 1 1 7 9 8 8 7 6 0 0 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Leaf Pickup 0 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 0 0 1 0 1 2 0 1 0 0 0 0 Organic Resources 0 0 0 0 0 1 0 0 0 0 0 0 Water Utility Ops 0 0 0 0 2 4 4 2 0 0 0 0 Sub Total 4 5 6 11 13 23 19 12 7 0 0 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 1 1 1 1 0 0 0 0 0 0 0 0 City Total 12 11 13 41 86 206 202 80 39 0 0 0 2017-09 Financial Report - Headcount Staffing Page 25 of 25