Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-10 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 October 31, 2017 Controller 2017-10 Financial Report Page 1 of 25 October 31, 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 106% 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 94% 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 October 2017,the City has spent 63%of budgeted expenditures,compared to 62%last year.The General Fund has spent 75%of its 2017 budgeted expenditures,compared to 78%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~$728,000.Payments are related to IT equipment leases.St. Joseph County PSAP, Indiana Finance Authority, and Transpo. The Full Time Headcount as of October 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(1),Public Safety(3),Public Works(5),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 80%,compared to 76%in October 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 October 2017,the general fund has reached 62%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-10 Financial Report Page 2 of 25 City of South Bend Period Ending:October 31, 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 866,667 - - 8,700,026 10,433,361 83% 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 622,302 - - 6,223,015 7,467,618 83% 316 County Option Income Tax 404 871,605 871,605 871,605 871,605 871,605 871,605 871,605 871,605 871,605 871,605 - - 8,716,054 10,459,265 83% 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 2,360,574 - - 23,639,096 28,360,244 83% 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 106,250 - - 1,062,500 1,275,000 83% 317 Hotel Motel Tax Century Center 324- - - 197,500 - - - - - 196,500 - - 394,000 394,000 100% 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 302,750 - - 3,689,236 5,868,500 63% 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 629,893 - - 4,029,482 4,668,000 86% 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 - - 61,026 - - 224,717 210,000 107% 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 - 355,070 - - 2,051,832 2,050,000 100% Sub Total 487,503 356,388 1,013,434 524,537 901,612 6,069,292 880,773 534,657 6,660,282 1,045,990 - - 18,474,467 19,754,891 94% 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 517,361 - - 6,234,865 7,623,328 82% 339 Contractual Service 211 9,669 12,407 38,314 17,294 7,957 11,557 7,257 57,569 11,063 10,069 - - 183,152 316,000 58% Sub Total 537,143 886,481 555,675 888,436 527,215 528,918 524,618 574,930 883,999 527,430 - - 6,434,843 13,004,328 49% 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 252,319 - - 2,438,843 2,927,591 83% 340 General Government Misc Chgs 101- - - - - - - - - 25 - - 25 500 5% 349 Central Service 222 51,820 48,684 51,854 49,741 49,575 50,298 46,813 59,676 55,927 64,163 - - 528,552 873,809 60% 380 Central Service 222 210,212 208,994 226,075 189,251 209,433 210,487 197,836 222,500 195,631 239,484 - - 2,109,903 2,880,310 73% 380 Energy Office Reimbursements 222 411,202 429,754 368,989 361,064 360,950 322,928 276,803 432,821 355,622 367,851 - - 3,687,984 4,492,800 82% 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 430,621 - - 4,306,210 5,205,034 83% 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 46,154 - - 1,002,452 2,341,441 43% 392 Administration Fee 101/279 414,748 414,748 414,748 414,748 414,748 414,748 414,748 414,748 414,748 414,748 - - 4,147,480 4,977,026 83% 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 1,713,919 - - 36,176,213 41,795,537 87% 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 1,460,367 - - 14,807,299 17,770,850 83% 2017-10 Fin anc i al Re port - Rev enue Report Page 3 of 25 City of South Bend Period Ending:October 31, 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 - - - 3,330 - - 14,363 21,000 68% 396 Self Funded Employee Benefits 711 6,503 (2,436) 496 - - 389 41,857 52,421 5,572 4,911 - - 109,713 46,809 234% 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 4,997,893 - - 70,168,244 88,546,124 79% 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 68,852 - - 2,842,234 8,916,624 32% 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 68,852 - - 3,361,855 9,620,123 35% 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 2,485 - - 126,479 129,532 98% 321 Code and Animal Fees 600 4,536 4,585 6,015 5,891 6,975 6,368 7,095 6,521 7,047 6,372 - - 61,403 63,300 97% 322 Building Fees 600 90,363 86,593 108,895 95,111 141,205 195,184 108,715 170,070 124,307 125,105 - - 1,245,547 1,369,350 91% 322 Code Enforcement Fees 600 1,050 300 3,000 1,500 600 2,800 1,200 900 1,200 600 - - 13,150 20,000 66% 322 EMS Operating Fund 288 1,923 1,380 1,542 910 2,973 2,613 1,609 3,218 1,380 1,047 - - 18,595 24,238 77% 322 General Government Fees 101 32,047 7,275 12,535 6,200 3,925 4,200 9,080 4,240 4,530 10,500 - - 94,532 106,127 89% 341 General Government Various various 3,316 959 5,210 5,841 1,367 3,126 3,262 982 1,166 1,411 - - 26,640 31,062 86% 342 Highway & Streets 101/202 38,686 - 16,474 2,320 43,516 13,142 - - - 37,381 - - 151,520 223,365 68% 342 Public Safety various 12,869 10,404 21,290 12,093 12,302 8,422 10,567 13,087 9,553 15,129 - - 125,716 150,000 84% 342 EMS - County Fees 288- 294,414 147,207 147,207 147,207 147,207 147,207 147,207 147,207 147,207 - - 1,472,072 1,740,000 85% 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 328,536 - - 2,561,497 2,700,000 95% 342 EMS - Neo Natal / Transport 288 16,185 18,553 16,128 14,553 4,909 167,113 37,377 46,570 34,401 42,260 - - 398,049 1,699,512 23% 344 Solid Waste 610 445,203 460,843 468,017 403,574 285,268 412,168 416,424 414,479 415,555 416,566 - - 4,138,097 5,636,175 73% 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 10,580 - - 140,634 254,258 55% 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 3,276,664 - - 31,918,814 37,233,004 86% 344 Sewer Repair Insurance 640 53,614 52,952 53,742 52,772 52,682 55,215 52,659 52,452 53,412 52,805 - - 532,305 613,924 87% 344 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 81,942 82,009 81,955 82,227 - - 817,055 980,000 83% 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 1,332,942 - - 12,039,522 14,685,122 82% 346 Solid Waste Misc 610 1,504 10,324 12,564 40,321 44,124 42,440 42,652 43,023 43,931 43,882 - - 324,764 389,100 83% 346 Project ReLeaf 655 36,802 36,730 36,817 36,854 37,012 37,156 37,164 37,212 37,209 37,346 - - 370,302 440,153 84% 347 Parks & Recreation various 74,837 77,843 366,527 173,383 231,644 355,839 316,702 486,025 242,812 441,531 - - 2,767,142 4,193,585 66% 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 4,654 - - 56,504 100,000 57% 349 Parking Garage Fees 601 115,464 73,834 83,097 119,933 135,473 65,973 116,506 39,938 61,382 114,171 - - 925,771 1,039,479 89% 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 120 - - 82,607 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 8,046 - - 183,539 100,033 183% 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 20,321 - - 292,887 348,635 84% 352 Forfeits various 734 616 3,897 5,014 1,556 23,381 8,542 456 3,570 8,725 - - 56,492 200,500 28% 354 Ordinance Violation various 5,163 7,326 9,708 (3,068) 2,333 2,278 8,232 11,059 8,511 6,693 - - 58,233 102,176 57% 360 Morris PAC various 10,087 86,686 184,282 72,560 46,729 117,156 32,782 17,918 62,083 34,022 - - 664,304 976,000 68% 360 Palais Royale various 24,371 4,131 9,256 7,929 19,759 18,450 34,802 37,340 18,800 21,982 - - 196,821 256,572 77% 360 Parks & Recreation various 9,055 4,207 4,552 9,758 3,205 5,864 4,035 1,982 11,374 (33,897) - - 20,134 98,206 21% 360 Police various 4,432 3,558 7,482 1,016 759 14,104 1,717 80,829 23,808 3,785 - - 141,492 25,000 566% 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 1,310 - - 514,810 637,204 81% 360 Central Services 222 608 - 50 251 623 57 179 7,784 - 709 - - 10,261 11,000 93% 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 80 - - 1,080 11,000 10% 360 Fire and Police Pension Fund 701/702 1,523 675 5,700 565 595 5,022 290 120 79 12 - - 14,580 2,000 729% 360 Industrial Revolving 754- - 3,703 1,121 - - - - - 12,210 - - 17,034 27,000 63% 360 General Government Various 101/3/226 13,427 24 266 148 244 - 241 24 874 131 - - 15,381 14,000 110% 360 Motor Veh Highway Scrap Metal 202 285 - 1,117 209 1,515 711 - 393 - 1,417 - - 5,648 4,896 115% 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-10 Fin anc i al Re port - Rev enue Report Page 4 of 25 City of South Bend Period Ending:October 31, 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 - - - - - 2,250 - - 9,476 - NA 360 Code / Animal Control 600 170 5 - - 181 - - - - 914 - - 1,270 6,500 20% 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 - - - 362 - - 3,212 2,650 121% 360 Waste Water 641/7/9- 3,437 - 5,103 4,546 4,002 690 41,171 - 4,051 - - 62,999 86,480 73% 360 Water Works Utility 620 / 625- 39 18 2,167 2,237 12,780 25 1,723 28 22 - - 19,039 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 0% 362 Dept. Of Community Investment 212 1,847 - - 1,847 - - - 1,847 - 1,847 - - 7,387 7,387 100% 362 Palais Royale 101- 5,114 1,940 1,745 11,426 11,032 10,491 11,008 4,326 5,949 - - 63,030 82,500 76% 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 1,259 - - 46,087 49,000 94% 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 2,961 - - 249,264 319,603 78% 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 257,612 - - 2,373,764 2,842,650 84% 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 437 - - 84,153 86,374 97% 399 Principal Income various 30,702 596,589 - 31,814 - - 31,814 346,054 186,218 47,788 - - 1,270,977 1,254,928 101% 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 6,922,517 - - 71,095,720 87,120,686 82% 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 154,244 - - 1,979,883 2,382,315 83% Sub Total 156,963 166,772 205,325 97,825 95,274 271,135 328,751 296,209 207,385 154,244 - - 1,979,883 2,382,315 83% 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 1,102 - - 385,415 467,494 82% Sub Total 75,816 1,040 70,660 440 25,155 55,987 374,782 83,148 27,285 1,102 - - 715,415 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 1,848 - - 13,493 16,500 82% Sub Total 1,838 114 345 890 896 1,660 3,472 3,315 1,616 1,848 - - 15,993 20,000 80% 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 131,779 119% 391 Vehicle Damage Reimbursement various- - - - - - - - - - - - - - NA - Sub Total- 60,000 2 1 61,029 1,137 1 178,674 201,892 - - - 502,736 292,110 172% 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 16,383,200 - - 272,391,901 339,486,356 80% 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 16,383,200 - - 272,391,901 339,486,356 - 0 (1) 0 (0) 0 (1) 0 (0) (0) - - (1) - 2017-10 Fin anc i al Re port - Rev enue Report Page 5 of 25 City of South Bend Period Ending:October 31, 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 1,011,265 - - 34,975,344 56,731,833 62% 0101 Mayor 101- - - - - 70 - - - - - - 70 600 12% 0401 Administration and Finance 101 12,254 - 8 - - - - - - 11 - - 12,273 12,304 100% 0501 Legal 101 18,475 - - - 18,875 - 18,875 - 874 10 - - 57,109 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 1,011,286 - - 35,044,796 56,820,114 62% Public Works 0602 Engineering 101 32,047 7,275 12,535 6,200 4,050 4,475 9,305 4,401 4,655 10,580 - - 95,523 323,464 30% Sub Total 32,047 7,275 12,535 6,200 4,050 4,475 9,305 4,401 4,655 10,580 - - 95,523 323,464 30% Public Safety 0801 Police 101 34,608 15,151 13,175 13,089 10,980 16,268 9,894 131,366 331,988 10,423 - - 586,943 668,408 88% 0901 Fire 101 4,387 37,987 - - - - 9 - - 25 - - 42,407 42,883 99% Sub Total 38,995 53,138 13,175 13,089 10,980 16,268 9,903 131,366 331,988 10,448 - - 629,350 711,291 88% Arts & Culture 0404 Morris PAC 101 10,888 86,733 183,972 72,872 46,790 113,721 33,286 18,425 60,791 33,429 - - 660,907 976,645 68% 0405 Palais Royale 101 26,265 9,345 13,108 10,025 33,527 30,706 47,868 52,472 24,958 29,737 - - 278,011 359,502 77% xxx xxx- NA Sub Total 37,153 96,078 197,080 82,898 80,317 144,427 81,154 70,897 85,749 63,166 - - 938,918 1,336,147 70% 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 1,095,479 - - 36,708,588 59,191,016 62% 2017-10 Financial Report - Rev enue Summar y Page 6 of 25 City of South Bend Period Ending:October 31, 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 (249) - - 6,476,047 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 1,268 - - 46,612 50,000 93% 1101 Maintenance 201 28,074 104,996 4,776 82,975 77,815 45,183 58,498 84,665 390,850 287,232 - - 1,165,063 1,710,210 68% 1102 Golf Operations 201 1,356 402 152,340 98,890 148,871 194,599 197,540 232,475 137,390 81,010 - - 1,244,873 1,539,195 81% 1103 Recreation Division 201 22 810 1,346 20 1,410 26,012 41,188 29,398 2,532 - - - 102,737 118,435 87% 1104 Potawatomi Zoo 201- - - - - - - - 9,451 (9,451) - - - - NA 1108 Graffiti Removal 201- - - - - 65,540 29,214 7,557 - 7,946 - - 110,258 160,000 69% 1110 Marketing and Events 201- - - 69 - 162 1,717 (125) 222 41,077 - - 43,123 572,471 8% 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 33,284 - - 859,574 1,157,768 74% 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 39 - - 42,508 42,715 100% 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 130 - - 270,829 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 442,285 - - 10,361,783 21,834,873 47% 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 852,455 - - 8,322,122 10,023,367 83% Central Services 222 675,986 688,080 710,659 544,455 623,794 586,845 523,002 737,413 611,840 676,545 - - 6,378,618 8,308,569 77% Central Services Capital 224 84 72 89 41 35 105 98 85 286,760 18 - - 287,388 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 176,319 - - 1,165,671 1,692,997 69% 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 37,789 - - 377,605 449,153 84% 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 1,743,126 - - 18,531,404 22,761,686 81% 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 460,975 - - 4,540,077 6,103,341 74% Solid Waste Capital 611 179 240 100,039 83,600 20,027 290,004 65 200,348 7 85,029 - - 779,537 836,713 93% xxx xxx xxx NA Sub Total 446,110 471,922 580,873 578,168 349,604 745,646 459,884 658,345 483,060 546,003 - - 5,319,615 6,940,054 77% 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 1,223,667 - - 11,176,321 13,593,036 82% 0630 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 81,942 82,009 81,955 82,227 - - 817,055 980,000 83% 0660 Clay Water 620 72,507 69,573 74,940 69,858 75,790 126,952 129,104 140,138 121,037 113,261 - - 993,159 1,192,586 83% Waterworks Capital 622 1,942 1,950 2,167 958 875 2,956 2,890 2,762 1,985 1,073 - - 19,559 24,000 81% Waterworks Deposit 624 1,159 1,174 1,347 639 583 1,965 1,923 1,851 1,352 733 - - 12,726 15,000 85% Waterworks Sinking 625 164,824 164,289 164,321 164,211 164,266 177,878 1,266 328,973 811 328,522 - - 1,659,360 2,067,642 80% Waterworks Bond Reserve 626 1,154 1,073 1,235 594 548 1,828 1,791 1,732 1,278 705 - - 11,938 16,000 75% Waterworks Debt Reserve 629 153,121 1,895 2,292 1,092 1,000 3,386 3,328 3,214 2,354 1,276 - - 172,957 176,500 98% 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 1,751,464 - - 14,863,076 18,064,764 82% 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 53,701 - - 547,389 632,424 87% 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 3,098,520 - - 30,249,730 35,247,267 86% 0621 Sewer Department 641- 1,261 - - - 1,191 - 23,915 - 1,502 - - 27,869 26,416 105% 0625 Concrete Crew 641- 3,040 - - - - - 33,569 - - - - 36,610 74,500 49% 0630 Wastewater Operations 641- - - - - - - 11,132 - - - - 11,132 11,132 100% 0631 Organic Resources 641- - - - - - - 26,220 - - - - 26,220 26,220 100% 0650 Clay Sewage 641 177,865 174,732 185,177 179,053 184,419 191,141 188,087 193,939 187,143 189,761 - - 1,851,315 2,162,160 86% Sewage Capital 642 5,472 404,555 5,255 444,486 502,267 508,096 508,114 508,122 506,095 503,426 - - 3,895,889 4,894,000 80% Sewage Reserve 643 3,481 3,535 520,820 2,021 1,972 6,676 6,560 6,337 4,640 2,515 - - 558,554 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 765,892 - - 7,658,389 9,190,024 83% Sewage Works DS Reserve 653- 955 1,176 1,189 1,579 1,877 2,174 2,423 2,869 3,033 - - 17,276 15,000 115% 2011 Sewer Bond 659 41 39 45 22 7 0 0 0 0 0 - - 154 201 77% 2012 Sewer Bond 661 2,379 2,201 2,530 1,144 984 3,053 2,666 2,176 958 505 - - 18,597 50,000 37% 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 4,618,854 - - 44,899,124 52,891,099 85% 2017-10 Financial Report - Rev enue Summar y Page 7 of 25 City of South Bend Period Ending:October 31, 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 116 - - 41,776 37,000 113% Curfew Violations 218 9 35 24 5 17 54 54 28 22 6 - - 254 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 20,150 - - 227,998 246,175 93% Public Safety LOIT 249 622,980 622,745 623,084 622,832 622,663 623,768 623,678 623,559 623,187 622,735 - - 6,231,232 7,478,618 83% Police Take Home Vehicle 278 561 575 660 315 288 977 1,521 1,250 922 610 - - 7,679 8,360 92% Police Block Grant 280 3 3 3 2 1 5 5 5 4 2 - - 33 50 65% Police Academy 294 5,456 4,561 2,023 886 2,483 288 111 105 77 3,141 - - 19,131 22,980 83% COPS More Grants 295 1,055 36,332 946 1,029 10,378 1,054 1,011 991 946 1,108 - - 54,848 123,500 44% Drug Enforcement 299 149 162 148 166 161 168 182 23,201 (20,971) 218 - - 3,584 63,000 6% K-9 Unit 705 2 2 3 1 1 4 4 4 3 1 - - 24 2,036 1% Sub Total 672,099 683,553 657,845 657,005 656,439 643,588 644,721 679,857 643,364 648,088 - - 6,586,559 7,982,719 83% 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 2,252 - - 3,244,707 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 522,004 - - 4,594,455 6,385,015 72% Hazmat 289 19 20 23 11 10 30 28 3,087 22 12 - - 3,264 10,250 32% River Rescue 291 114 16,307 12,724 1,869 23,462 10,989 3,211 186 128 4,260 - - 73,248 69,400 106% Sub Total 184,846 2,375,057 499,419 378,295 398,322 667,505 421,455 1,984,949 477,298 528,528 - - 7,915,673 10,994,014 72% Department of Community Investment Studebaker/Oliver 209 25,242 626 34,113 56,725 9,707 1,070 28,801 131,345 34,453 13,383 - - 335,465 425,787 79% State Grant 210 242 268 18,311 148 135 18,459 455 3,130 319 18,176 - - 59,640 262,141 23% DCI Operating 211 10,748 394,129 39,598 398,624 8,536 13,387 8,822 58,823 392,519 10,494 - - 1,335,680 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 58,202 - - 1,529,071 5,574,676 27% xxx Programs 212 93,743 - - - - - - 116,141 - - - - 209,884 - NA 0000 Economic Revenue Bond 281 21 21 24 12 11 36 35 34 25 14 - - 232 300 77% xxx xxx xxx NA Sub Total 440,280 596,182 134,898 619,981 102,326 390,903 69,474 359,175 656,484 100,269 - - 3,469,972 8,557,332 41% 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 31,901 - - 314,136 306,516 102% 0462 Leighton Plaza 601 58,466 24,331 25,191 82,032 58,385 19,301 73,829 49,105 24,549 59,425 - - 474,612 497,484 95% 0463 Enforcement 601 4,969 4,623 7,202 3,586 4,680 6,223 10,585 6,212 5,234 5,899 - - 59,214 91,000 65% 0464 Wayne Street 601 30,977 20,895 29,889 11,565 12,333 24,967 19,680 29,994 16,625 22,711 - - 219,636 243,261 90% 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 119,935 - - 1,070,080 1,163,261 92% Capital / Debt Service Hall of Fame 313 50 6 23 8 10 474,777 12 14 77 18 - - 474,996 894,300 53% COIT 404 913,313 879,279 1,163,973 920,266 874,964 886,807 916,204 883,875 947,994 914,931 - - 9,301,606 11,063,418 84% Cum Capital Development 406 357 436 410 184 169 259,526 492 674 395 201 - - 262,844 485,600 54% Cum Capital Improvement 407 150,266 294 301 144 132 117,143 25,562 567 270 147 - - 294,825 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 873,124 - - 10,041,973 11,794,400 85% UDAG 410 445 416 493 235 207 689 677 629 451 245 - - 4,487 6,110 73% Major Moves 412 1,774 598,393 2,312 1,238 1,135 3,844 3,780 249,486 188,822 1,380 - - 1,052,163 1,056,786 100% Morris PAC Improvement 416 436 12,664 13,666 11,585 5,797 3,677 5,090 2,616 1,165 4,958 - - 61,654 106,500 58% Palais Historic Preservation 450 1,907 187 428 429 683 1,534 2,596 2,937 1,708 1,898 - - 14,308 17,500 82% Hall of Fame Capital 677 372 378 431 200 182 612 598 576 420 226 - - 3,993 5,000 80% SB Building Corp 755- 1,326,786 210 65 117 169 191 1,323,992 754 333 - - 2,652,618 2,654,500 100% Parks Bond Debt Svc 757- 65,162 124 65,236 80 64,086 138 32,152 31,927 31,815 - - 290,722 391,482 74% Eddy St. Commons Debt 760- - - - - - - - 2,500,000 233 - - 2,500,233 - 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 1,829,510 - - 26,956,421 28,912,596 93% 2017-10 Financial Report - Rev enue Summar y Page 8 of 25 City of South Bend Period Ending:October 31, 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 5,005 - - 85,583 90,000 95% Gift, Donation, Bequest 217 50,900 1,097 69,994 5,639 220 51,058 513 1,726 885 1,153 - - 183,185 214,094 86% Unsafe Building 219 11,928 152,225 26,129 160,537 14,230 18,670 16,684 22,297 163,559 13,846 - - 600,105 884,475 68% Landlord Registration 221 2,260 270 1,245 155 60 25 20 5 865 1,655 - - 6,560 7,000 94% Loss Recovery 227 730 741 851 404 368 1,244 1,217 1,176 793 418 - - 7,941 9,000 88% LOIT 2016 Special Distribution 257- 6,605 156,406 1,646 1,183 56,449 3,846 103,670 58,430 1,475 - - 389,709 1,623,397 24% Human Rights 258 91,498 4,790 5,975 2,576 356 600 39,798 689 413 218 - - 146,912 258,740 57% Morris Palais Marketing 273 34 582 1,132 577 947 3,950 58 60 1,532 744 - - 9,615 18,450 52% IT / Innovation /311 Call Center 279 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 430,621 - - 4,306,210 5,205,034 83% 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 13,627 - - 1,305,135 1,863,717 70% 1207 Animal Control 600 4,706 187,306 6,015 188,107 6,975 6,368 7,095 6,521 190,313 7,286 - - 610,690 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 126,481 - - 1,273,431 1,398,154 91% Century Center 670 910,931 211,677 (225,009) 400,425 412,693 311,339 412,822 379,895 354,384 371,908 - - 3,541,064 4,228,683 84% Century Center Capital 671 74 66 74 71 74 71 74 74 71 74 - - 722 750 96% Century Center Energy Saving 672 6 4 4 4 4 4 55,520 82,171 4 4 - - 137,726 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 974,514 - - 12,863,170 17,526,951 73% 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 254,535 - - 2,477,122 3,539,591 70% 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 254,535 - - 2,513,764 3,576,234 70% 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 12 - - 6,221,569 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 1,469,820 - - 14,989,019 17,892,659 84% Unemployment Comp 713 217 214 244 114 102 339 329 310 221 118 - - 2,208 2,800 79% City Cemetery Trust 730 22 22 25 12 11 37 37 36 26 14 - - 242 280 87% Equipment / Vehicle Leasing 750- 298 375 223 2,916,712 532 161,897 (160,372) 1,632,769 766 - - 4,553,201 5,502,900 83% Parks Bond Capital 751- 369 539 485 517 632 652 624 637 588 - - 5,042 7,500 67% Smart Street Bond Capital 753- 604 663 544 545 606 561 42,305 22,038 (19,750) - - 48,115 58,880 82% 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 1,451,568 - - 53,240,820 34,613,910 154% 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 16,104,158 - - 245,300,050 295,010,509 83% 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 212,113 - - 10,920,549 23,789,389 46% TIF West Washington 422 1,411 1,497 1,721 821 751 200,696 2,595 2,664 1,952 1,054 - - 215,160 442,000 49% TIF Leighton Plaza 425 10,467 14,196 10,498 8,768 8,762 8,914 9,074 10,331 7,249 3,553 - - 91,810 197,014 47% 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 3,955 - - 1,651,258 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 3,426 - - 2,732,180 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 20 - - 219,030 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 224,120 - - 18,159,270 35,218,628 52% 2017-10 Financial Report - Rev enue Summar y Page 9 of 25 City of South Bend Period Ending:October 31, 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 4 - - 66 135 49% Certified Technology Park 439 1,614 1,641 1,887 900 825 1,064 456 253,066 397 299 - - 262,148 302,625 87% Airport Urban Enterprise Zone 454 288 292 336 160 147 498 489 473 347 188 - - 3,220 3,900 83% Industrial Revolving 754- - 21,526 9,673 14,952 12,238 7,388 7,961 - 51,814 - - 125,552 223,824 56% Sub Total 1,908 1,940 23,757 10,737 15,927 13,810 8,342 261,509 750 52,304 - - 390,985 530,484 74% Debt Service Airport Debt Reserve 2003 315 780 792 902 434 398 1,346 1,323 1,278 935 507 - - 8,694 14,000 62% Coveleski Bond Debt Reserve 317 385 391 450 214 197 666 655 633 464 252 - - 4,306 5,000 86% Central Development reserve 328 1,303 1,323 1,522 725 664 2,249 2,210 2,135 1,563 847 - - 14,541 20,000 73% SB Redevelopment Authority 752- 772,669 1,236,763 395 197,726 305 195 1,484,222 400 682 - - 3,693,357 3,868,669 95% Smart Streets Debt Svc 756- 179 263 197 218 277 291 856,782 381 329 - - 858,917 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 2,617 - - 8,541,597 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 279,042 - - 27,091,852 44,475,847 61% 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 16,383,200 - - 272,391,901 339,486,356 80% 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 16,383,200 0 0 272,391,901 339,486,356 0 0 0 0(0)0 0 0 0 0 0 0 0 0 2017-10 Financial Report - Rev enue Summar y Page 10 of 25 City of South Bend Period Ending:October 31, 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-10 Financial Report - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:October 31, 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-10 Financial Report - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:October 31, 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 78,827 - - 668,293 872,923 77% 0201 Clerk 101 38,451 43,206 31,600 35,638 35,273 46,995 33,861 36,722 39,439 40,750 - - 381,935 536,216 71% 0301 Common Council 101 33,451 49,728 27,207 50,580 28,885 34,287 33,776 38,408 39,952 33,663 - - 369,936 571,148 65% 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 197,229 - - 1,984,047 2,476,351 80% 0501 Legal Department 101 87,585 86,783 87,565 116,630 75,744 109,460 80,722 95,963 75,203 69,972 - - 885,626 1,158,567 76% Sub Total 402,773 416,575 385,606 467,764 444,284 537,304 406,485 437,008 414,597 420,441 - - 4,332,838 5,658,205 77% Public Works 0602 Engineering 101 81,736 88,219 89,641 89,644 103,226 120,430 96,986 98,261 109,104 97,783 - - 975,029 1,485,157 66% Sub Total 81,736 88,219 89,641 89,644 103,226 120,430 96,986 98,261 109,104 97,783 - - 975,029 1,485,157 66% 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 2,294,848 - - 22,151,503 29,668,433 75% 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 1,741,647 - - 16,288,642 21,111,466 77% 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 4,036,494 - - 38,440,145 50,779,899 76% Arts & Culture 0404 Morris PAC 101 74,731 80,199 47,613 60,412 60,629 72,212 60,726 61,783 58,942 234,731 - - 811,979 1,271,039 64% 0405 Palais Royale 101 24,999 30,061 10,824 17,021 18,169 22,340 17,757 19,406 19,179 86,714 - - 266,471 530,200 50% Sub Total 99,730 110,260 58,436 77,434 78,798 94,553 78,483 81,189 78,122 321,444 - - 1,078,450 1,801,239 60% Human Rights 1008 Human Rights 101 37,821 40,148 32,484 37,408 31,913 34,695 29,063 35,285 29,894 29,160 - - 337,871 425,805 79% Sub Total 37,821 40,148 32,484 37,408 31,913 34,695 29,063 35,285 29,894 29,160 - - 337,871 425,805 79% 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 4,905,322 - - 45,164,332 60,150,305 75% 2017-10 Financial Report - Expe nditu re Su mmary Page 13 of 25 City of South Bend Period Ending:October 31, 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 114,622 - - 1,157,155 1,468,296 79% 1101 Maintenance 201 399,021 416,933 423,013 569,543 553,920 672,696 511,411 561,135 453,106 658,697 - - 5,219,474 6,914,308 75% 1102 Golf Operations 201 54,483 75,381 77,362 180,384 131,801 173,015 147,904 146,830 134,209 108,194 - - 1,229,562 1,669,575 74% 1103 Recreation Division 201 165,251 145,109 133,502 139,866 147,123 241,949 247,358 212,855 135,982 133,540 - - 1,702,534 2,153,817 79% 1104 Potawatomi Zoo 201 355,692 7,425 7,231 7,208 289,717 8,923 6,660 6,601 5,369 (4,949) - - 689,876 715,964 96% 1106 Potawatomi Greenhouse 201 5,013 4,555 2,550 2,375 1,198 15,764 411 408 566 665 - - 33,505 54,408 62% 1108 Graffiti Removal 201 13,483 12,628 11,465 10,265 8,529 10,420 7,557 7,946 (6,469) 7,915 - - 83,740 112,932 74% 1110 Marketing and Events 201 16,583 45,412 58,810 61,326 60,810 83,508 58,196 67,592 57,881 73,844 - - 583,961 953,588 61% 1111 Regional Cities Grant 201- - - - - - - - - 149,910 - - 149,910 5,000,000 3% Recreation Non Reverting 203 51,478 47,722 45,821 94,361 71,392 92,875 159,108 155,475 75,309 70,450 - - 863,990 1,599,683 54% East Race Waterway 271- - - - - - 1,353 - - - - - 1,353 1,367 99% Coveleski Stadium 401- - - 8,542 4,569 - 1,778 1,136 975 61,597 - - 78,597 30,000 262% Zoo Endowment 403- - - 53,599 - (3,549) - - - - - - 50,049 50,050 100% Park Non Reverting 405 45,874 17,251 22,621 42,193 16,930 71,879 61,868 19,760 120,486 (22,800) - - 396,061 553,024 72% 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 1,351,684 - - 12,239,767 21,277,012 58% Public Works Motor Vehicle Highway 202 919,033 515,568 547,694 523,276 541,787 631,705 634,583 681,127 817,893 636,586 - - 6,449,252 9,886,533 65% Curb and Sidewalk 202 150,920 40,047 37,646 38,164 143,273 121,813 209,102 113,133 54,706 181,909 - - 1,090,713 1,878,998 58% Central Services 222 730,352 648,645 561,962 613,240 672,069 593,479 531,551 706,728 844,083 630,259 - - 6,532,369 8,564,643 76% Central Services Capital 224 10,575 4,009 - 16,964 - 11,786 - 16,597 114,180 25,071 - - 199,182 326,025 61% Local Roads & Streets 251 209,999 4,801 3,018 35,678 92,276 81,399 305,836 166,252 2,321 146,800 - - 1,048,379 2,308,544 45% Local Roads & Bridge 265- - - - - - 64 - - 1,400 - - 1,464 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 28,300 - - 378,831 537,171 71% 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 1,650,324 - - 15,700,190 25,501,914 62% 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 425,165 - - 4,377,455 5,662,910 77% Solid Waste Capital 611 286,902 146,712 218 83,859 20,129 219 286,862 146,712 259 83,924 - - 1,055,794 1,135,613 93% Sub Total 776,525 458,871 388,720 469,689 367,944 685,879 694,289 728,898 353,346 509,089 - - 5,433,249 6,798,523 80% 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 70,498 - - 673,376 1,035,000 65% 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 1,211,390 - - 12,082,090 16,688,754 72% 0660 Clay Water 620- - (0) 169 37 5 26 13 14 2 - - 267 3,500 8% Waterworks Capital 622 111,938 177,777 13,775 9,295 8,299 17,201 58,155 8,110 - 2 - - 404,551 1,414,466 29% Waterworks Deposit 624 874 1,174 1,347 639 583 1,965 1,923 1,851 1,352 733 - - 12,441 15,000 83% Waterworks Sinking 625 815 289 321 211 266 255,311 52,101 1,373 811 522 - - 312,020 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 1,276 - - 21,231 23,000 92% 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 1,284,422 - - 13,515,975 21,250,611 64% 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 43,442 - - 446,510 634,509 70% 0621 Sewer Repair 641 517,647 434,598 385,613 579,850 349,846 452,561 422,426 441,576 375,871 1,430,923 - - 5,390,911 9,548,100 56% 0625 Concrete Crew 641 30,239 20,767 19,975 30,713 26,000 34,774 27,113 25,357 22,159 24,865 - - 261,962 474,389 55% 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 2,660,466 - - 25,246,620 33,198,000 76% 0631 Organic Resources 641 124,773 126,931 80,689 53,682 214,126 78,314 116,920 145,157 68,948 101,374 - - 1,110,914 1,608,946 69% 0650 Clay Sewage 641- 5 26 50 431 - 181 73 9 - - - 775 1,750 44% Sewage Capital 642 1,298,328 387,989 178,442 93,243 530,257 335,486 139,256 298,108 286,199 402,622 - - 3,949,930 8,051,255 49% Sewage Reserve 643 2,625 3,535 4,065 2,021 1,972 6,676 6,560 6,337 4,640 2,515 - - 40,944 30,000 136% 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,888 100% 2012 Sewer Bond 661 3,000 166,950 113,521 180,305 269,318 115,454 988,844 - 190,669 235,348 - - 2,263,409 3,010,364 75% 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 4,901,553 - - 39,845,287 65,772,955 61% 2017-10 Financial Report - Expe nditu re Su mmary Page 14 of 25 City of South Bend Period Ending:October 31, 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- - - - - - - - - - - - - 116,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 59,013 - - 466,516 788,422 59% 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 518,805 - - 6,084,573 7,462,645 82% 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 331,499 - - 1,701,061 3,757,457 45% 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 226 - - 28,178 35,805 79% Police Academy 294 162 283 692 909 515 3,776 179 249 523 254 - - 7,542 22,500 34% COPS More Grants 295 10,980 3,436 108,583 11,664 915 240 347 - 180 19,534 - - 155,879 263,767 59% Drug Enforcement 299 11,242 23,096 13,200 - - 3,172 - - 19,000 79,491 - - 149,201 286,337 52% 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 1,008,821 - - 8,627,592 12,779,632 68% Public Safety - Fire EMS Capital 287 235,792 150,604 - 386,321 136,287 547,964 290,622 431,636 177,672 138,888 - - 2,495,785 3,991,466 63% EMS Operating Fund 288 438,601 356,431 401,753 451,805 437,873 602,509 371,814 451,602 452,361 392,910 - - 4,357,657 6,137,914 71% 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 981 - - 94,714 117,349 81% xxx xxx xxx Sub Total 676,266 507,520 401,984 861,943 588,636 1,171,772 671,488 899,050 642,487 532,779 - - 6,953,925 10,257,160 68% Department of Community Investment Studebaker/Oliver 209 70,702 4,592 23,072 39,510 43,825 - 31,342 25,919 15,560 26,237 - - 280,759 539,393 52% 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 165,449 - - 1,836,642 2,775,376 66% 1001 Dept. of Community Investment 212 575,173 100,654 21,621 163,348 164,147 146,738 77,983 126,737 105,551 343,006 - - 1,824,957 5,455,838 33% 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 534,692 - - 3,996,366 9,280,364 43% 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) 26,398 - - 170,788 261,894 65% 0462 Leighton Plaza 601 20,044 21,722 1,360 55,854 7,114 18,879 3,926 28,168 126,180 102,835 - - 386,083 596,368 65% 0463 Enforcement 601 7,858 7,238 437 22,849 437 12,035 5,445 13,557 7,791 20,833 - - 98,480 128,675 77% 0464 Wayne Street 601 12,364 13,889 936 32,097 5,591 20,718 1,558 21,801 29,321 28,921 - - 167,197 244,417 68% 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 178,986 - - 822,548 1,247,254 66% Capital / Debt Service Hall of Fame 313 635,000 - (3,265) - - - 633,000 - (121,315) 800 - - 1,144,220 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 1,134,105 - - 9,769,240 12,071,593 81% Cum Capital Development 406 112,650 27,896 - - 149,081 - 112,650 27,896 - 10,711 - - 440,885 476,500 93% Cum Capital Improvement 407 185,125 - - - - - 187,125 - (1,000) 800 - - 372,050 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 215,858 - - 8,125,558 11,559,184 70% UDAG 410 30,702 - - 31,814 - - 31,814 - - 31,814 - - 126,142 126,144 100% Major Moves 412 543 - 62 - 910 - 274,046 142,171 - 93,796 - - 511,527 2,470,708 21% 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 2,067 - - 40,649 81,091 50% 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 1,489,951 - - 23,581,472 31,867,309 74% 2017-10 Financial Report - Expe nditu re Su mmary Page 15 of 25 City of South Bend Period Ending:October 31, 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 94,695 - - 695,037 905,479 77% 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 8,794 - - 114,052 201,773 57% 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 558,378 - - 2,944,271 5,205,034 57% 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 138,485 - - 1,183,391 1,613,201 73% 1207 Animal Control 600 68,101 59,652 58,318 65,964 68,163 74,484 66,442 65,853 63,349 66,287 - - 656,613 810,517 81% 1306 Building Operations 600 110,343 98,842 97,813 101,286 98,111 129,067 111,279 102,136 109,926 95,273 - - 1,054,076 1,361,925 77% Century Center 670 282,027 349,477 (15,339) 661,555 322,739 382,643 332,564 414,240 314,078 360,110 - - 3,404,094 4,194,310 81% Century Center Energy Saving 672- - - 95,128 - - - - - 96,169 - - 191,297 192,297 99% 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 1,418,191 - - 11,392,536 16,175,541 70% 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 17,697 - - 176,164 235,471 75% 0412 Liability Insurance 226 45,537 23,578 52,779 27,697 640,369 40,160 62,615 40,802 96,968 165,041 - - 1,195,546 2,034,051 59% 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 19,313 - - 768,379 722,386 106% Sub Total 228,276 128,412 148,890 283,807 736,460 114,282 558,713 109,320 150,740 202,052 - - 2,660,951 3,587,586 74% Fiduciary Trust & Agency Fire Pension 701 388,455 396,509 396,201 394,300 390,847 376,476 382,196 380,446 380,376 378,976 - - 3,864,781 5,098,269 76% Police Pension 702 513,053 511,187 523,297 519,926 517,885 505,354 507,705 507,885 507,795 507,795 - - 5,121,881 6,423,889 80% 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 1,206,650 - - 12,522,851 17,803,200 70% Unemployment Comp 713 6,038 8,041 4,389 5,340 3,324 5,526 7,729 3,827 5,733 4,323 - - 54,270 84,105 65% City Cemetery Trust 730- - - - - - - - 599 - - 599 6,000 10% Equipment / Vehicle Leasing 750- 983,042 489,584 65,756 135,750 128,509 - 501,098 23,547 912,178 - - 3,239,464 5,500,000 59% Parks Bond Capital 751- 63,156 211,200 140,581 19,839 111,546 2,245 288,513 68,236 130,079 - - 1,035,395 3,500,000 30% Smart Street Bond 753- 986,652 285,891 512,350 617,149 341,706 1,077,051 659,978 20,695 406,356 - - 4,907,828 10,000,000 49% 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 3,546,955 - - 31,143,318 48,415,463 64% 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 23,514,820 - - 221,077,508 334,361,629 66% 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 2,086,165 - - 15,899,631 39,618,887 40% TIF West Washington 422- - 2,420 385 - - - - 65,778 4,008 - - 72,591 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 6,020 - - 102,638 158,166 65% TIF River East DEV (NE)429 27,144 45,644 101,171 587,302 45,684 343,124 122,068 129,047 76,124 127,537 - - 1,604,844 10,602,696 15% TIF Southside 430 146,124 12,530 17,419 24,812 100,639 6,683 - 10,774 33,396 52,826 - - 405,203 6,917,426 6% 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 - 116 - - 335,724 344,216 98% TIF River East RES (NE RE)436 1,236,500 446,589 - - - - 1,234,500 60,446 186,218 2,331 - - 3,166,584 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 2,279,003 - - 26,453,999 67,378,709 39% 2017-10 Financial Report - Expe nditu re Su mmary Page 16 of 25 City of South Bend Period Ending:October 31, 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 - 24,153 - - 85,186 157,000 54% Sub Total- - 14,437 17,369 1,801,091 17,679 775 10,814 - 24,153 - - 1,886,319 2,411,500 78% Debt Service Airport Debt Reserve 2003 315 588 792 902 434 398 1,346 1,323 1,278 935 507 - - 8,502 14,000 61% Central Development reserve 328 983 1,323 1,522 725 664 2,249 2,210 2,135 1,563 847 - - 14,221 15,000 95% 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 1,252,284 100% 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 1,354 - - 10,356,692 10,407,607 100% 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 2,304,510 - - 38,697,010 80,197,816 48% 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 25,819,330 - - 259,774,517 414,559,445 63% 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 25,819,330 0 0 259,774,518 414,559,445 0 0 0 0 0 0(1)0 0 0 0 0(1)0 2017-10 Financial Report - Expe nditu re Su mmary Page 17 of 25 City of South Bend Period Ending:October 31, 2017 Debt Schedule Year of Year of Year of Scheduled Payments Debt (Orig / Refi)Debt at 2017 Principal 2017 Interest 2017 Debt at 2017 Total Debt Instrument Debt Purpose Issue Refunding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payment Addition 12/31/2017 Debt Payments Civil City Debt Bond Debt Amo rt 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 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 670,994.00 25 Water Works Improvements Water Works 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 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 1,565,740.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 Improvements Water Works 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 Work s 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 2010 Sewage Work s Revenue Bonds Sewage Work s 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 Work s 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 2012 Water Works Revenue Bond Water Works 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 2012 Sewage Work s Revenue Bonds Sewage Work s 2012 2032 649 6/1 12/1--25,000,000.00 20,890,000.00 1,060,000.00 486,680.00 0.00 19,830,000.00 1,546,680.00 105 2013A Sewer Bond Refunding Sewage Work s 2013 2013 2024 649 6/1 12/1--14,765,000.00 8,050,000.00 1,955,000.00 156,170.00 0.00 6,095,000.00 2,111,170.00 116 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 402,480.00 133 St. Joseph County PSAP St. Joseph County PSAP 2014 2034 408 Monthly 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 Sav ings Improvements 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 Recreation Bond Parks Improvements 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,530,000.00 499,300.00 0.00 22,435,000.00 3,029,300.00 156 2016 Water Works Refunding Bonds Ref unding 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,506,730.90 3,776,119.50 0.00 118,234,732.02 15,282,850.40 Loans Payable 68 State Revolving Fund Water Works 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 Garage 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 xxx Total Loans Payable 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 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 Equipment Finance Public Works 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 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.53 5,634.82 0.00 0.02 580,951.35 102 Ik on Office Solutions / Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 756.77 756.77 65.82 0.00 0.00 822.59 103 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 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 Attorney 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 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 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 Dept. Copier 2013 2018 600 Monthly 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 Admin & Finance Copier 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 Records Copier 2013 2018 101 Monthly 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 Works Main Ricoh Copier 2013 2018 620 Monthly 10th--5,647.50 2,448.11 1,189.78 105.62 0.00 1,258.33 1,295.40 119 Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copier 2013 2018 620 Monthly 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 Works Olive Ricoh Copier 2013 2018 620 Monthly 10th--4,732.65 2,051.62 997.01 85.51 0.00 1,054.61 1,082.52 123 Police Training Dept. Ricoh Copier Training Copier 2014 2019 101 Monthly 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 Various 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 Computer Lease #1 Computer Equipment Lease 2014 2018 various Monthly 8th--137,104.95 63,525.63 32,632.97 2,191.39 0.00 30,892.66 34,824.36 126 HP Computer Lease #2 Computer Equipment Lease 2014 2018 201 and 620 Monthly 8th--4,000.00 1,947.01 950.39 70.09 0.00 996.62 1,020.48 127 HP Computer Lease #4 Computer Equipment Lease 2014 2018 404 Monthly 8th--5,886.15 2,795.30 1,412.70 83.34 0.00 1,382.60 1,496.04 128 HP Computer Lease #6 Computer Equipment Lease 2014 2018 201 Monthly 8th--3,755.50 1,917.99 883.34 73.78 0.00 1,034.65 957.12 129 HP Computer Lease #7 Computer Equipment Lease 2014 2018 620 Monthly 8th--1,326.00 706.05 315.44 21.40 0.00 390.61 336.84 130 Solid W aste Copier Ricoh USA Copier 2014 2019 611 Monthly 17th--5,351.65 3,302.32 1,071.78 157.86 0.00 2,230.54 1,229.64 131 Police Communications Copier Ricoh USA Copier 2014 2019 101 Monthly 12th--8,843.00 4,876.99 1,804.44 227.40 0.00 3,072.55 2,031.84 132 Organic Resources & Wastewater Ricoh USA Copiers 2014 2019 641 Monthly 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 Monthly 19th--4,732.65 2,132.25 992.44 93.08 0.00 1,139.81 1,085.52 136 HP Computer Lease #8 Computer Equipment Lease 2015 2019 404/201/611 Monthly 16th--19,603.94 11,854.14 4,538.52 494.04 0.00 7,315.62 5,032.56 137 Animal Control Ricoh Copier Ricoh USA Copiers 2015 2020 600 Monthly 30th--5,261.50 3,591.88 1,033.37 182.47 0.00 2,558.51 1,215.84 138 HP Computer Lease #9 Computer Equipment Lease 2015 2019 Various Monthly 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 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 712,665.36 143 HP Computer Lease #11 Computer Equipment Lease 2015 2019 404 Monthly--3,040.00 2,161.06 695.77 85.67 0.00 1,465.29 781.44 144 PNC Vehicle Lease No. 2 Vehicle Lease Purchase 2015 2020 Various 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. Ricoh Copier Ricoh Copier 2016 2020 201 Monthly--4,302.06 3,454.72 810.05 176.59 0.00 2,644.67 986.64 147 Central Services Lanier Copier C51005 Copier 2016 2020 222 Monthly--32,525.00 28,667.19 6,046.87 1,368.89 0.00 22,620.32 7,415.76 148 Central Services Lanier Copier C6502 Copier 2016 2020 222 Monthly--11,413.00 10,059.31 2,121.84 480.36 0.00 7,937.47 2,602.20 149 Vehicle & Equip. Lease Public Works Vehicles Lease 2016 2021 Various 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 Computer Lease Copier Lease 2016 2020 Various Monthly--17,439.85 14,013.99 3,908.91 574.29 0.00 10,105.08 4,483.20 2017-10 Financial Re port - Deb t P age 18 of 25 City of South Bend Period Ending:October 31, 2017 Debt Schedule Year of Year of Year of Scheduled Payments Debt (Orig / Refi)Debt at 2017 Principal 2017 Interest 2017 Debt at 2017 Total Debt Instrument Debt Purpose Issue Refunding Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2016 Payments Payment Addition 12/31/2017 Debt Payments 151 Admin and Finance Ricoh Copier Copier Lease 2016 2021 101 Monthly--10,923.63 8,938.27 2,047.09 458.15 0.00 6,891.18 2,505.24 152 PNC Vehicle / Equip Lease No. 2 Vehicle / Equipment Lease 2016 2021 Various 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 Vehicle / Equip Lease Amend 1 Parks and Recreation 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 Vehicle / 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 Computer Lease No. 13 Computer Equipment Lease 2016 2020 Various Monthly---156,029.30 150,562.73 33,567.37 6,602.27 0.00 116,995.36 40,169.64 157 Venue, Parks, Art Copier Ricoh Copier 2016 2021 201 Monthly---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 Various 1/14 7/14--2,916,500.00 0.00 0.00 0.00 2,916,500.00 0.00 0.00 159 Mayor/Waste Water/Fire Ricoh 2017 Ricoh Copier Lease 2017 2021 101/641/287 Monthly---15,702.09 0.00 3,285.05 843.03 15,702.09 12,417.04 4,128.08 160 HP Computer Refres h Lease No. 14 2017 Ricoh Copier Lease 2017 2021 279/201 Monthly---10,305.25 0.00 1,852.45 359.95 10,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,632,000.00 1,632,000.00 0.00 xxx Total Capital Lease 34,787,495.21 16,078,945.72 4,804,933.75 245,147.31 4,574,507.34 11,300,019.31 5,047,868.66 Total Civil City 299,487,420.71 147,504,568.39 16,458,718.90 4,032,474.15 4,574,507.34 131,071,856.83 20,488,980.65 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 491,875.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,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 Taxi ng 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,315,000.00 598,625.00 0.00 11,185,000.00 1,913,625.00 6 Airport Devel opment 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 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 3,961,666.72 54 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 2,463,181.26 81 Coveleski Stadi um 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 727,155.00 122 Synagogue at Coveleski Improvements Coveleski Stadium 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 2015 Redevelopment Smart Streets Smarts 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 Project Façade Improvement Bldg 84 2017 2018 324 One time---3,500,000.00 0.00 3,500,000.00 0.00 3,500,000.00 0.00 3,500,000.00 163 2017 Eddy St. Commons Phase 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 0.00 xxx Total Bond Debt 182,288,788.00 85,640,000.00 14,510,000.00 2,868,505.36 28,500,000.00 99,630,000.00 17,378,505.36 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgi ve)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 Development Finance 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 Commons 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 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 100,000.00 142 Interfund Fund 412 - Major Moves Parking Garage Improvements 2016 2022 601 6/1 12/1 1,500,000.00 517,304.69 229,174.05 20,825.95 750,000.00 1,038,130.64 250,000.00 xxx Total Loans Payable 15,627,499.06 5,339,782.19 1,471,040.26 178,437.18 750,000.00 4,601,148.38 1,649,477.44 Capital Lease xxx Total Capital Lease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leases 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 Total 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,110,878.26 3,117,104.54 29,250,000.00 105,536,648.38 19,227,982.80 Total Debt 502,913,985.77 239,919,688.58 32,569,597.16 7,149,578.69 33,824,507.34 236,608,505.21 39,716,963.45 2017-10 Financial Re port - Deb t P age 19 of 25 City of South Bend Period Ending:October 31, 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 10/31/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 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 86,122.32 47,286.24 0.00 2,300,385.60 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,793,707.32 2,480,360.58 0.00 126,947,755.60 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 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 9 7 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 9 8 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15--945,674.38 97,793.51 97,793.51 735.90 0.00 0.00 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 728.74 53.76 0.00 763.03 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 306,011.19 8,569.95 0.00 310,880.70 11 4 Ricoh USA Admin & Finance Copier 2013 2018 101 1/16 4/16 7/16 10/16 11,247.97 3,079.36 2,445.81 125.35 0.00 633.55 11 7 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd--9,678.26 4,194.14 1,691.50 158.50 0.00 2,502.64 11 8 Water Works Main Ricoh Copier W ater Works Main Ricoh Copier 2013 2018 620 Monthly 10th--5,647.50 2,448.11 986.88 92.62 0.00 1,461.23 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 827.00 77.60 0.00 1,224.62 12 0 Water Works Olive Ricoh Copier W ater Works Olive Ricoh Copier 2013 2018 620 Monthly 10th--4,732.65 2,051.62 827.00 77.60 0.00 1,224.62 12 3 Police Training Dept. Ricoh Copier Training Copier 2014 2019 101 Monthly 30th--4,263.00 2,076.44 738.41 81.59 0.00 1,338.03 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 391,803.76 16,992.78 0.00 801,993.29 12 5 HP Computer Lease #1 Computer Equipment Lease 2014 2018 v arious Monthly 8th--137,104.95 63,525.63 27,091.84 1,928.46 0.00 36,433.79 12 6 HP Computer Lease #2 Computer Equipment Lease 2014 2018 201 and 620 Monthly 8th--4,000.00 1,947.01 788.92 61.48 0.00 1,158.09 12 7 HP Computer Lease #4 Computer Equipment Lease 2014 2018 404 Monthly 8th--5,886.15 2,795.30 1,173.44 73.26 0.00 1,621.86 12 8 HP Computer Lease #6 Computer Equipment Lease 2014 2018 201 Monthly 8th--3,755.50 1,917.99 733.12 64.48 0.00 1,184.87 12 9 HP Computer Lease #7 Computer Equipment Lease 2014 2018 620 Monthly 8th--1,326.00 706.05 262.03 18.67 0.00 444.02 13 0 Solid Waste Copier Ricoh USA Copier 2014 2019 611 Monthly 17th--5,351.65 3,302.32 888.96 135.74 0.00 2,413.36 13 1 Police Communications Copier Ricoh USA Copier 2014 2019 101 Monthly 12th--8,843.00 4,876.99 1,496.64 196.56 0.00 3,380.35 13 2 Organic Resourc es & Wastewater Ricoh USA Copiers 2014 2019 641 Monthly 21st--12,260.18 6,558.16 2,084.73 262.77 0.00 4,473.43 13 4 Water Works Copier - North Station Richo USA Copiers 2014 2019 620 Monthly 19th--4,732.65 2,132.25 823.21 81.39 0.00 1,309.04 13 6 HP Computer Lease #8 Computer Equipment Lease 2015 2019 404/201/611 Monthly 16th--19,603.94 11,854.14 3,766.14 427.66 0.00 8,088.00 13 7 Animal Control Ricoh Copier Ricoh USA Copiers 2015 2020 600 Monthly 30th--5,261.50 3,591.88 856.92 156.28 0.00 2,734.96 13 8 HP Computer Lease #9 Computer Equipment Lease 2015 2019 Various Monthly TBD--135,958.05 94,710.62 25,648.17 3,438.83 0.00 69,062.45 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 577.56 73.64 0.00 1,583.50 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 671.82 150.38 0.00 2,782.90 14 7 Central Serv ices Lanier Copier C51005 Copier 2016 2020 222 Monthly---32,525.00 28,667.19 5,016.81 1,162.99 0.00 23,650.38 14 8 Central Serv ices Lanier Copier C6502 2016 2020 222 Monthly---11,413.00 10,059.31 1,760.39 408.11 0.00 8,298.92 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 2017-10 Financial Report - Debt Page 20 of 25 City of South Bend Period Ending:October 31, 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 10/31/2017 15 0 HP Computer Lease Computer Lease- Refresh 2016 2020 404/641/620 Monthly---17,439.85 14,013.99 3,244.65 491.35 0.00 10,769.34 15 1 Admin and Financ e Ricoh Copier MPC8002SP Copier 2016 2021 101 Monthly---10,923.63 8,938.27 1,697.74 389.96 0.00 7,240.53 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 244,070.10 17,538.46 0.00 1,012,026.89 15 5 HP Computer Lease No. 13 Computer Equipment Lease 2016 2020 v arious Monthly---156,029.30 150,562.73 27,858.48 5,626.22 0.00 122,704.25 15 7 Venue, Parks, Art Copier Ricoh Copier 2016 2021 201 Monthly---3,184.06 3,184.06 820.86 350.06 0.00 2,363.20 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,689.07 688.45 15,702.09 13,013.02 16 0 HP Computer Ref resh Lease No. 14 2017 Ricoh Copier Lease 2017 2021 279/201 Monthly---10,305.25 0.00 1,476.32 293.60 10,305.25 8,828.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 4,653,211.90 235,330.84 4,574,507.34 16,000,241.16 Total Civil City 299,487,420.71 147,504,568.39 7,541,247.97 2,721,295.09 4,574,507.34 144,537,827.76 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 19,057,886.80 6,126,370.83 33,824,507.34 254,669,233.62 2017-10 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 1092 0 0 Part Time Staff 115 119 142 155 168 145 139 155 159 145 0 0 Temporary / Seasonal 12 11 13 41 86 206 202 80 39 30 0 0 City Total 1,207 1,199 1,237 1,274 1,330 1,444 1,430 1314 1290 1267 0 0 2017-10 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 8 0 0 311 Call Center 6 6 6 6 7 7 6 6 6 6 6 0 0 Admin & Finance 23 20 21 22 23 23 23 23 23 23 23 0 0 Innovation/ Technology Office 18 14 14 15 14 16 17 17 17 17 17 0 0 Safety & Risk 2 2 2 2 2 2 2 2 2 2 2 0 0 Clerk 5 5 5 5 5 5 5 5 5 5 6 0 0 Common Council 9 9 9 9 9 9 9 9 9 9 9 0 0 Central Services 40 38 39 37 37 38 39 38 38 40 40 0 0 Legal Department 11 11 11 10 10 10 10 11 9 9 9 0 0 Sub Total 121 111 113 112 112 116 119 119 117 120 120 0 0 Code Enf. /Animal Control/ Unsafe Bldg.29 24 26 28 28 29 28 29 29 29 29 0 0 Dept. of Community Investment 23 22 20 21 21 20 20 20 20 20 20 0 0 Parks & Recreation Administration 6 6 6 6 6 6 6 6 6 6 7 0 0 Maintenance 50 45 47 48 47 47 48 48 48 48 49 0 0 Golf Operations 8 7 8 7 8 8 8 8 8 8 8 0 0 Recreation Ops 21 22 21 21 21 21 22 22 22 21 21 0 0 Zoological Ops 1 1 1 1 1 1 1 1 1 1 1 0 0 Graffiti Removal 1 1 1 1 1 1 1 1 1 1 1 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 10 0 0 Sub Total 98 91 95 95 95 95 96 96 96 95 97 0 0 Public Safety Police 289 284 272 282 280 278 288 283 280 280 280 0 0 Fire 264 268 267 266 263 261 259 260 260 270 270 0 0 Sub Total 553 552 539 548 543 539 547 543 540 550 550 0 0 Public Works Office of Sustainability 2 2 2 2 2 2 2 2 2 2 1 0 0 Engineering 18 18 18 20 20 20 20 20 20 18 17 0 0 Solid Waste Operations 26 25 25 26 25 24 25 25 26 25 25 0 0 Street Operations 55 54 54 54 54 53 56 54 52 52 53 0 0 Sewer Operations 621 37 37 37 37 37 35 37 37 37 37 37 0 0 Waste Water Ops 630 45 45 45 44 44 45 45 45 42 45 44 0 0 Organic Resources 6 6 5 5 6 6 6 6 6 6 6 0 0 Water Utility Ops 65 64 63 63 63 64 65 66 65 66 66 0 0 Sub Total 254 251 249 251 251 249 256 255 250 251 249 0 0 Building Department 14 14 14 14 14 14 14 14 14 14 14 0 0 Human Rights 6 6 6 6 6 6 5 5 5 5 5 0 0 Morris & Palais 9 9 7 7 8 8 8 8 8 8 8 0 0 City Total 1,107 1,080 1,069 1,082 1,078 1,076 1,093 1,089 1,079 1,092 1,092 - - 2017-10 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 2 0 0 Admin & Finance 0 0 0 0 0 0 0 0 0 1 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 Central Services 1 1 1 1 1 1 1 1 1 0 0 0 Legal Department 1 1 1 1 1 1 1 1 1 1 0 0 Sub Total 6 5 5 3 3 4 4 4 4 4 0 0 Code Enf. / Animal Control 3 2 3 3 3 4 4 4 4 4 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 12 0 0 Golf Operations 2 0 18 41 54 54 53 44 38 28 0 0 Recreation Ops 46 54 54 46 48 42 40 43 48 48 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 1 0 0 Marketing & Events 1 1 1 1 1 1 1 1 1 1 0 0 Sub Total 65 70 88 104 118 110 108 103 102 90 0 0 Public Safety Police 25 25 29 27 27 10 5 26 28 27 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 1 0 0 Sub Total 25 25 29 27 27 11 6 27 29 28 0 0 Public Works` Engineering 2 2 2 3 2 2 2 2 3 4 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 8 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 3 0 0 Sub Total 12 13 13 14 13 12 13 13 16 15 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 4 0 0 City Total 115 119 142 155 168 145 139 155 159 145 0 0 2017-10 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 Central Services 0 0 0 0 0 1 0 1 0 0 0 0 Legal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 2 1 0 0 1 2 2 2 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 8 0 0 Golf Operations 0 0 1 1 2 3 5 7 3 2 0 0 Recreation Ops 3 2 2 15 40 129 127 29 11 3 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 13 0 0 Public Safety Police 0 0 0 0 0 14 14 5 1 1 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 1 0 0 Public Works Engineering 3 4 4 4 1 7 7 1 1 1 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 15 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 22 19 11 7 16 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 30 0 0 2017-10 Financial Report - Headcount Staffing Page 25 of 25