Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-06 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 Angela Kouters Deputy Chief of Staff Suzanna Fritzberg City Common Council Administration and Finance Department Heads Fiscal Officers June 30, 2017 Controller 2017-06 Financial Report Page 1 of 25 June 30, 2017 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). Revenue by Type Revenue by Fund -Fund 291 (River Rescue), is at 144% of its budgeted revenue. This is revenue related to tuition fees for the river rescue class. -Fund 258 (Human Rights). This is revenue related to grants received to battle housing and employment discrimination. -Fund 294 (Police Academy). This is revenue related to the advancement of present and future police officers. -Fund 221(Landlord Registration), is at 57% 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 June 2017,the City has spent 38%of budgeted expenditures,compared to 35%in June 2016.The General Fund has spent 46%of its 2017 budgeted expenditures,compared to 45%in 2016.The following funds have reached 50%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~$134,000 to Sun Trust,Kansas State Bank,PNC Bank,U.S. Bank and Ricoh USA.Payments are related to IT equipment leases,police/public works vehicles,solid waste containers,and sewer bonds. The Full Time Headcount as of June was 1,093 vs.a budgeted amount of 1,112.Currently,there are a total of 19 vacant positions.The 36 open positions are in the following departments:Human Rights(1),Parks(2),Public Safety(6),Public Works(6),DCI(3),Morris and Palais (1). For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 50%,compared to 51%in June 2016.Revenue type 369(Memorial Hospital)has reached 100%of its budgeted revenue.This is revenue from Leighton Plaza for common area fees.It is a lease between Memorial Hospital and the South Bend Redevelopment Commission. Also revenue type 317 (Hotel Motel Tax Cum Cap Improvements) has reached 100% of its budgeted revenue. As of June 2017,the general fund has reached 52%of its budgeted revenue,compared to 53%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 ~$400,000 more than 2016 budget. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. 2017-06 Financial Report Page 2 of 25 City of South Bend Period Ending:June 30, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Property Tax 311 Property Tax Civil City various- - - - - 27,489,054 - - - - - 27,489,054 50,071,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,325,124 54% Income Tax 315 Econ Development Income Tax 408 883,344 883,344 866,667 866,667 866,667 866,667 - - - - - - 5,233,357 10,433,361 50% 316 Local Option Income Tax - PS 249 622,302 622,302 622,302 622,302 622,302 622,302 - - - - - - 3,733,809 7,467,618 50% 316 County Option Income Tax 404 871,605 871,605 871,605 871,605 871,605 871,605 - - - - - - 5,229,633 10,459,265 50% Sub Total 2,377,250 2,377,250 2,360,574 2,360,574 2,360,574 2,360,574 - - - - - - 14,196,798 28,360,244 50% 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 - - - - - - 637,500 1,275,000 50% 317 Hotel Motel Tax Century Center 324- - - 197,500 - - - - - - - - 197,500 394,000 50% 317 Hotel Motel Tax Cum Cap Imprv 407 150,000 - - - - - - - - - - - 150,000 150,000 100% Sub Total 787,500 - (318,750) 303,750 106,250 2,188,986 - - - - - - 3,067,736 5,868,500 52% 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,565,446 11,124,891 50% 335 Gaming Proceeds 101- - - - - - - - - - - - - 599,000 0% 335 Gasoline Tax 202/251 361,601 314,230 394,563 456,411 426,999 355,323 - - - - - - 2,309,127 4,668,000 49% 335 Liquor Excise tax 101- 42,158 - - - - - - - - - - 42,158 75,000 56% 335 Liquor Gallonage Tax 101 63,498 - - 44,056 - - - - - - - - 107,554 210,000 51% 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 - - - - - - - 955,046 2,050,000 47% Sub Total 487,503 356,388 1,013,434 524,537 901,612 6,069,292 - - - - - - 9,352,766 19,754,891 47% Other Intergovernmental Sources 336 Federal Drug 299- - - - - - - - - - - - - 30,000 0% 337 State Drug 216 10,113 2,962 - 30 1,897 - - - - - - - 15,003 35,000 43% 338 Payment in Lieu of Tax various 517,361 871,113 517,361 871,113 517,361 517,361 - - - - - - 3,811,670 7,623,328 50% 339 Contractual Service 211 9,669 12,407 38,314 17,294 7,957 11,557 - - - - - - 97,196 316,000 31% Sub Total 537,143 886,481 555,675 888,436 527,215 528,918 - - - - - - 3,923,868 8,004,328 49% Charge for Service Internal City 340 Liability Insurance 226 243,168 243,964 241,179 246,749 241,179 246,749 - - - - - - 1,462,988 2,927,591 50% 340 General Government Misc Chgs 101/289- - - - - - - - - - - - - 500 0% 349 Central Service 222 51,820 48,684 51,854 49,741 49,575 50,298 - - - - - - 301,973 873,809 35% 380 Central Service 222 210,212 208,994 226,075 189,251 209,433 210,487 - - - - - - 1,254,452 2,880,310 44% 380 Energy Office Reimbursements 222 411,202 429,754 368,989 361,064 360,950 322,928 - - - - - - 2,254,887 4,492,800 50% 380 LOIT 2016 Special Distribution 257- - 152,895 - - 52,501 - - - - - - 205,397 153,000 134% 380 IT Innovation 311 Center 279 430,621 430,621 430,621 430,621 430,621 430,621 - - - - - - 2,583,726 5,205,034 50% 380 Beck's Lake Reimbursement 404- - 283,432 - - - - - - - - - 283,432 283,432 100% 380 INDOT SR 933 Transfer 324- - - - - - - - - - - - - 4,100,000 0% 380 Internal Service Reimbursement various 65,792 89,865 18,297 77,763 111,522 51,754 - - - - - - 414,993 1,423,071 29% 392 Administration Fee 101/279 414,748 414,748 414,748 414,748 414,748 414,748 - - - - - - 2,488,488 4,977,026 50% 392 Internal Fund Transfers various 1,085,348 9,754,150 4,553,299 4,585,904 1,649,180 1,807,518 - - - - - - 23,435,399 41,710,246 56% 395 Employee Benefits 711/713 1,499,317 1,460,178 1,492,929 1,487,450 1,477,818 1,483,231 - - - - - - 8,900,923 17,755,850 50% 2017-06 Fin anc i al Re port - Rev enue Report Page 3 of 25 City of South Bend Period Ending:June 30, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 396 Central Service Refunds 222 1,314 - 62,668 (56,756) 2,392 1,416 - - - - - - 11,033 21,000 53% 396 Self Funded Employee Benefits 711 6,503 (2,436) 496 - - 389 - - - - - - 4,952 4,563 109% xxx xxx xxx- NA Sub Total 4,420,045 13,078,521 8,297,481 7,786,534 4,947,418 5,072,640 - - - - - - 43,602,639 86,808,232 50% 3rd Party Revenue 340 ND EMS Service 288- - 44,904 - 1,338 14,152 - - - - - - 60,394 150,000 40% 350 Job Target Penalty Fee 408- 354,660 - - - - - - - - - - 354,660 354,660 100% 364 Cable TV Franchise Fees 101- 192,238 - - - - - - - - - - 192,238 748,000 26% 366 AT&T Franchise Fees 101 55,865 - - - 51,778 - - - - - - - 107,643 284,000 38% 393 Debt Proceeds 750- - - - 2,916,500 - - - - - - - 2,916,500 5,499,000 53% Sub Total 55,865 546,898 44,904 - 2,969,616 14,152 - - - - - - 3,631,435 7,035,660 52% Grants 331 Federal Grants various 468,447 1,200,229 111,355 149,580 103,356 263,868 - - - - - - 2,296,835 9,090,424 25% 334 State Grants various- - 33,745 5,150 - 137,805 - - - - - - 176,700 20,000 884% Sub Total 468,447 1,200,229 145,100 154,730 103,356 401,673 - - - - - - 2,473,536 9,110,424 27% Fees for Services External 320 Inspections Central Service 222- - - 450 350 270 - - - - - - 1,070 1,450 74% 321 Business License 101/222 30,917 29,318 15,746 12,407 11,383 4,566 - - - - - - 104,337 120,130 87% 321 Code and Animal Fees 600 4,536 4,585 6,015 5,891 6,975 6,368 - - - - - - 34,368 54,500 63% 322 Building Fees 600 90,363 86,593 108,895 95,111 141,205 195,184 - - - - - - 717,350 1,360,350 53% 322 Code Enforcement Fees 600 1,050 300 3,000 1,500 600 2,800 - - - - - - 9,250 20,000 46% 322 EMS Operating Fund 288 1,923 1,380 1,542 910 2,973 2,613 - - - - - - 11,341 24,000 47% 322 General Government Fees 101 32,047 7,275 12,535 6,200 3,925 4,200 - - - - - - 66,182 100,000 66% 341 General Government Various various 3,316 959 5,210 5,841 1,367 3,126 - - - - - - 19,819 27,005 73% 342 Highway & Streets 101/202 38,686 - 16,474 2,320 43,516 13,142 - - - - - - 114,139 223,365 51% 342 Public Safety various 12,869 10,404 21,290 12,093 12,302 8,422 - - - - - - 77,380 150,000 52% 342 EMS - County Fees 288- 294,414 147,207 147,207 147,207 147,207 - - - - - - 883,243 1,740,000 51% 342 EMS - Capital Fund 287- 1,798,417 - - - - - - - - - - 1,798,417 4,485,349 40% 342 EMS - Operating Fund 288 160,939 235,524 271,371 210,652 215,161 283,974 - - - - - - 1,377,622 2,700,000 51% 342 EMS - Neo Natal / Transport 288 16,185 18,553 16,128 14,553 4,909 167,113 - - - - - - 237,441 1,699,512 14% 344 Solid Waste 610 445,203 460,843 468,017 403,574 285,268 412,168 - - - - - - 2,475,073 5,636,175 44% 344 Code Environmental Clean Up 101/219/600 12,404 3,044 22,134 17,648 11,871 19,048 - - - - - - 86,149 180,000 48% 344 Sewage Waste Water 641 3,208,590 3,128,008 3,112,534 3,105,650 3,096,610 3,192,879 - - - - - - 18,844,270 37,020,404 51% 344 Sewer Repair Insurance 640 53,614 52,952 53,742 52,772 52,682 55,215 - - - - - - 320,976 613,924 52% 344 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 - - - - - - 488,922 980,000 50% 346 Water Works Utility 620 1,039,872 1,012,523 1,016,299 1,006,997 1,032,846 1,254,697 - - - - - - 6,363,234 14,590,122 44% 346 Solid Waste Misc 610 1,504 10,324 12,564 40,321 44,124 42,440 - - - - - - 151,276 110,000 138% 346 Project ReLeaf 655 36,802 36,730 36,817 36,854 37,012 37,156 - - - - - - 221,371 440,153 50% 347 Parks & Recreation various 74,837 77,843 366,527 173,383 231,644 355,839 - - - - - - 1,280,073 4,343,134 29% 347 Sale of Merchandise 101- - - - - 70 - - - - - - 70 100 70% 347 Morris PAC 416- 12,214 13,143 11,334 5,563 2,871 - - - - - - 45,125 100,000 45% 349 Parking Garage Fees 601 115,464 73,834 83,097 119,933 135,473 65,973 - - - - - - 593,773 1,000,629 59% 349 Code Demolition Board Up 219/600 2,805 2,067 13,981 5,115 1,466 20,689 - - - - - - 46,123 90,000 51% 349 Parking Century Center 670 12,814 19,676 20,911 11,526 7,998 3,915 - - - - - - 76,839 100,033 77% 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 - - - - - - 227,922 261,820 87% 352 Forfeits various 734 616 3,897 5,014 1,556 23,381 - - - - - - 35,199 200,000 18% 354 Ordinance Violation various 5,163 7,326 9,708 (3,068) 2,333 2,278 - - - - - - 23,740 72,500 33% 360 Morris PAC various 10,087 86,686 184,282 72,560 46,729 117,156 - - - - - - 517,499 976,000 53% 360 Palais Royale various 24,371 4,131 9,256 7,929 19,759 18,450 - - - - - - 83,896 256,572 33% 360 Parks & Recreation various 9,055 4,207 4,552 9,758 3,205 5,864 - - - - - - 36,641 98,206 37% 360 Police various 4,432 3,558 7,482 1,016 759 14,104 - - - - - - 31,351 25,000 125% 360 Fire various- 37,987 - - - - - - - - - - 37,987 - NA 360 TIF various 31,545 2,510 6,859 2,110 2,110 309,933 - - - - - - 355,066 316,725 112% 360 Central Services 222 608 - 50 251 623 57 - - - - - - 1,590 11,000 14% 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 - - - - - - 252,855 197,000 128% 360 EMS Operating Fund 288 525 - - - 72 - - - - - - - 597 5,000 12% 360 Engineering / Curb & Sidewalk 101- 50 50 - 125 275 - - - - - - 500 11,000 5% 360 Fire and Police Pension Fund 701/702 1,523 675 5,700 565 595 5,022 - - - - - - 14,080 2,000 704% 360 Industrial Revolving 754- - 3,703 1,121 - - - - - - - - 4,824 27,000 18% 360 General Government Various 101/3/226 13,427 24 266 148 244 - - - - - - - 14,110 14,000 101% 360 Motor Veh Highway Scrap Metal 202 285 - 1,117 209 1,515 711 - - - - - - 3,838 4,896 78% 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,087 275 1486% 360 Professional Sports Development 377 17,864 - - - - - - - - - - - 17,864 30,000 60% 2017-06 Fin anc i al Re port - Rev enue Report Page 4 of 25 City of South Bend Period Ending:June 30, 2017 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 360 C.O.I.T.404 725 - 1,450 5,051 - - - - - - - - 7,226 - NA 360 Code / Animal Control 600 170 5 - - 181 - - - - - - - 356 6,500 5% 360 Building Fees 600- - - 898 - - - - - - - - 898 - NA 360 Parking Garage 601 20 - 180 - 96 - - - - - - - 296 11,282 3% 360 Solid Waste Fund 610- 265 - 2,357 - 229 - - - - - - 2,850 2,650 108% 360 Waste Water 641/7/9- 3,437 - 5,103 4,546 4,002 - - - - - - 17,087 52,500 33% 360 Water Works Utility 620 / 625- 39 18 2,167 2,237 12,780 - - - - - - 17,241 25,000 69% 360 Sewage Depreciation Fund 642- 400,000 - - - - - - - - - - 400,000 400,000 100% 362 Dept. Of Community Investment 212 1,847 - - 1,847 - - - - - - - - 3,694 7,387 50% 362 Palais Royale 101- 5,114 1,940 1,745 11,426 11,032 - - - - - - 31,257 82,500 38% 362 Police 101- - - 7,238 - - - - - - - - 7,238 48,000 15% 362 Parks & Recreation 201 3,786 3,545 5,828 3,970 6,820 6,514 - - - - - - 30,463 43,500 70% 362 S Bend School Corp Fee 407- - - - - - - - - - - - - 25,000 0% 362 TIF Property various 14,223 24,108 14,479 13,450 6,588 15,451 - - - - - - 88,299 319,603 28% 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 - - - - - - 1,306,716 2,809,278 47% 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 - - - - - - 81,384 86,374 94% 399 Principal Income various 30,702 596,589 - 31,814 - - - - - - - - 659,104 1,254,928 53% Sub Total 6,172,987 8,889,356 6,333,219 6,158,391 6,066,357 7,329,097 - - - - - - 40,949,407 85,857,892 48% Interest Income 361 Bank Account Interest various 156,963 166,772 205,325 97,825 95,274 271,135 - - - - - - 993,295 1,719,848 58% Sub Total 156,963 166,772 205,325 97,825 95,274 271,135 - - - - - - 993,295 1,719,848 58% Donations 367 ND Contribution 101- - - - - - - - - - - - - 337,500 0% 367 Donations various 75,816 1,040 70,660 440 25,155 55,987 - - - - - - 229,098 281,244 81% Sub Total 75,816 1,040 70,660 440 25,155 55,987 - - - - - - 229,098 618,744 37% Historic Preservation 368 C.O.I.T.404- - - 500 250 250 - - - - - - 1,000 - 368 Palais 450 1,838 114 345 390 646 1,410 - - - - - - 4,742 16,500 29% Sub Total 1,838 114 345 890 896 1,660 - - - - - - 5,742 16,500 35% Sale of Assets 391 TIF (Property Sales / Land)various- 60,000 2 1 61,029 - - - - - - - 121,032 137,331 88% 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 - - - - - - 1,137 15,000 8% 391 Vehicle Damage Reimbursement various- - - - - - - - - - - - - - NA - Sub Total- 60,000 2 1 61,029 1,137 - - - - - - 122,169 175,331 70% Revenue Total 15,541,356 27,563,049 18,707,970 18,276,109 18,164,753 66,098,808 - - - - - - 164,352,047 331,368,706 50% report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 - - - - - - 164,352,046 331,368,706 - 0 (1) 0 (0) 0 - - - - - - 0 - 2017-06 Fin anc i al Re port - Rev enue Report Page 5 of 25 City of South Bend Period Ending:June 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0000 General Revenues 101 1,105,267 1,215,293 975,765 1,001,269 1,006,845 24,478,271 - - - - - - 29,782,710 57,242,002 52% 0101 Mayor 101- - - - - 70 - - - - - - 70 600 12% 0401 Administration and Finance 101 12,254 - 8 - - - - - - - - - 12,262 12,304 100% 0501 Legal 101 18,475 - - - 18,875 - - - - - - - 37,350 75,377 50% Sub Total 1,135,996 1,215,293 975,773 1,001,269 1,025,720 24,478,341 - - - - - - 29,832,392 57,330,283 52% Public Works 0602 Engineering 101 32,047 7,275 12,535 6,200 4,050 4,475 - - - - - - 66,582 317,337 21% Sub Total 32,047 7,275 12,535 6,200 4,050 4,475 - - - - - - 66,582 317,337 21% Public Safety 0801 Police 101 34,608 15,151 13,175 13,089 10,980 16,268 - - - - - - 103,273 336,000 31% 0901 Fire 101 4,387 37,987 - - - - - - - - - - 42,373 1,500 2825% Sub Total 38,995 53,138 13,175 13,089 10,980 16,268 - - - - - - 145,646 337,500 43% Arts & Culture 0404 Morris PAC 101 10,888 86,733 183,972 72,872 46,790 113,721 - - - - - - 514,976 965,000 53% 0405 Palais Royale 101 26,265 9,345 13,108 10,025 33,527 30,706 - - - - - - 122,977 358,902 34% xxx xxx- NA Sub Total 37,153 96,078 197,080 82,898 80,317 144,427 - - - - - - 637,953 1,323,902 48% General Fund Revenue Total 1,244,191 1,371,784 1,198,563 1,103,455 1,121,067 24,643,511 - - - - - - 30,682,573 59,309,022 52% 2017-06 Financial Report - Rev enue Summar y Page 6 of 25 City of South Bend Period Ending:June 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 0000 Parks General revenue 201 2,200 357,973 3,346 356,258 672 5,358,382 - - - - - - 6,078,830 10,999,007 55% 1100 Administration 201 3,787 3,548 5,830 3,974 7,149 6,524 - - - - - - 30,812 43,600 71% 1101 Maintenance 201 28,074 104,996 4,776 82,975 77,815 45,183 - - - - - - 343,818 1,707,710 20% 1102 Golf Operations 201 1,356 402 152,340 98,890 148,871 194,599 - - - - - - 596,459 1,525,934 39% 1103 Recreation Division 201 22 810 1,346 20 1,410 26,012 - - - - - - 29,620 156,685 19% 1108 Graffiti Removal 201- - - - - 65,540 - - - - - - 65,540 96,725 68% 1110 Marketing and Events 201- - - 69 - 162 - - - - - - 231 570,471 0% Recreation Non Reverting 203 75,681 75,021 213,432 75,516 66,022 68,745 - - - - - - 574,415 1,381,787 42% East Race Waterway 271 1 1 1 1 1 2 - - - - - - 6 22 28% Coveleski Stadium 401 68 69 79 38 35 104 - - - - - - 393 40,900 1% 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 - - - - - - 58,445 439,850 13% Sub Total 115,792 543,031 381,765 643,382 328,266 5,766,485 - - - - - - 7,778,721 16,962,891 46% Public Works Motor Vehicle Highway 202 317,873 1,223,876 828,325 1,361,365 833,924 286,692 - - - - - - 4,852,054 9,934,110 49% Central Services 222 675,986 688,080 710,659 544,455 623,794 586,845 - - - - - - 3,829,819 8,308,569 46% Central Services Capital 224 84 72 89 41 35 105 - - - - - - 427 287,600 0% Local Roads & Streets 251 106,827 88,499 130,547 93,992 107,567 126,254 - - - - - - 653,686 1,674,275 39% 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 - - - - - - 225,237 444,556 51% Sub Total 1,138,220 3,037,955 2,707,224 2,037,067 1,602,646 1,038,111 - - - - - - 11,561,223 22,649,110 51% Public Works Solid Waste Solid Waste Operations 610 445,931 471,682 480,834 494,568 329,577 455,642 - - - - - - 2,678,234 5,799,475 46% Solid Waste Capital 611 179 240 100,039 83,600 20,027 290,004 - - - - - - 494,089 836,313 59% Sub Total 446,110 471,922 580,873 578,168 349,604 745,646 - - - - - - 3,172,322 6,635,788 48% Public Works Water Utility 0000 Water Works Revenues 620 973,972 948,744 947,938 952,254 965,980 1,147,589 - - - - - - 5,936,477 13,578,036 44% 0630 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 81,925 - - - - - - 488,922 980,000 50% 0660 Clay Water 620 72,507 69,573 74,940 69,858 75,790 126,952 - - - - - - 489,619 1,192,586 41% Waterworks Capital 622 1,942 1,950 2,167 958 875 2,956 - - - - - - 10,849 15,000 72% Waterworks Deposit 624 1,159 1,174 1,347 639 583 1,965 - - - - - - 6,867 15,000 46% Waterworks Sinking 625 164,824 164,289 164,321 164,211 164,266 177,878 - - - - - - 999,789 2,054,891 49% Waterworks Bond Reserve 626 1,154 1,073 1,235 594 548 1,828 - - - - - - 6,432 16,000 40% Waterworks Debt Reserve 629 153,121 1,895 2,292 1,092 1,000 3,386 - - - - - - 162,786 174,500 93% Sub Total 1,449,981 1,269,935 1,275,612 1,270,956 1,290,778 1,544,479 - - - - - - 8,101,741 18,026,013 45% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,941 54,328 55,305 53,519 53,371 57,542 - - - - - - 329,006 621,788 53% 0000 Wastewater Revenues 641 3,044,674 2,968,092 2,944,636 2,940,827 2,924,257 3,029,887 - - - - - - 17,852,372 34,932,744 51% 0621 Sewer Department 641- 1,261 - - - 1,191 - - - - - - 2,452 2,500 98% 0625 Concrete Crew 641- 3,040 - - - - - - - - - - 3,040 74,500 4% 0650 Clay Sewage 641 177,865 174,732 185,177 179,053 184,419 191,141 - - - - - - 1,092,386 2,162,160 51% Sewage Capital 642 5,472 404,555 5,255 444,486 502,267 508,096 - - - - - - 1,870,132 4,887,000 38% Sewage Reserve 643 3,481 3,535 520,820 2,021 1,972 6,676 - - - - - - 538,503 546,755 98% Sewage Bond Sinking 649 763,195 1,184 1,526,979 763,848 764,229 768,253 - - - - - - 4,587,687 9,177,024 50% Sewage Works DS Reserve 653- 955 1,176 1,189 1,579 1,877 - - - - - - 6,777 4,400 154% 2011 Sewer Bond 659 41 39 45 22 7 0 - - - - - - 154 - NA 2012 Sewer Bond 661 2,379 2,201 2,530 1,144 984 3,053 - - - - - - 12,292 50,000 25% Sub Total 4,052,047 3,613,922 5,241,923 4,386,109 4,433,084 4,567,716 - - - - - - 26,294,801 52,458,871 50% 2017-06 Financial Report - Rev enue Summar y Page 7 of 25 City of South Bend Period Ending:June 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216 10,276 3,136 200 127 1,986 300 - - - - - - 16,024 36,000 45% Curfew Violations 218 9 35 24 5 17 54 - - - - - - 144 1,000 14% Law Enforcement Education 220 31,608 16,002 30,754 31,643 18,459 16,970 - - - - - - 145,436 221,500 66% Public Safety LOIT 249 622,980 622,745 623,084 622,832 622,663 623,768 - - - - - - 3,738,072 7,473,618 50% Police Take Home Vehicle 278 561 575 660 315 288 977 - - - - - - 3,376 4,000 84% Police Block Grant 280 3 3 3 2 1 5 - - - - - - 17 50 35% Police Academy 294 5,456 4,561 2,023 886 2,483 288 - - - - - - 15,698 22,500 70% COPS More Grants 295 1,055 36,332 946 1,029 10,378 1,054 - - - - - - 50,794 123,500 41% Drug Enforcement 299 149 162 148 166 161 168 - - - - - - 954 32,000 3% K-9 Unit 705 2 2 3 1 1 4 - - - - - - 13 2,020 1% Sub Total 672,099 683,553 657,845 657,005 656,439 643,588 - - - - - - 3,970,528 7,916,188 50% Public Safety - Fire EMS Capital 287 2,726 1,801,174 3,021 2,108 1,927 6,015 - - - - - - 1,816,972 4,495,349 40% EMS Operating Fund 288 181,987 557,555 483,650 374,307 372,922 650,471 - - - - - - 2,620,892 6,350,012 41% Hazmat 289 19 20 23 11 10 30 - - - - - - 114 10,000 1% River Rescue 291 114 16,307 12,724 1,869 23,462 10,989 - - - - - - 65,464 45,500 144% Sub Total 184,846 2,375,057 499,419 378,295 398,322 667,505 - - - - - - 4,503,442 10,900,861 41% Department of Community Investment Studebaker/Oliver 209 25,242 626 34,113 56,725 9,707 1,070 - - - - - - 127,482 422,857 30% State Grant 210 242 268 18,311 148 135 18,459 - - - - - - 37,561 73,512 51% DCI Operating 211 10,748 394,129 39,598 398,624 8,536 13,387 - - - - - - 865,022 2,291,309 38% 0000 Dept. of Community Investment 212 310,284 201,138 42,852 164,474 83,939 357,952 - - - - - - 1,160,639 5,455,838 21% xxx Programs 212 93,743 - - - - - - - - - - - 93,743 - NA 0000 Economic Revenue Bond 281 21 21 24 12 11 36 - - - - - - 124 200 62% Sub Total 440,280 596,182 134,898 619,981 102,326 390,903 - - - - - - 2,284,571 8,243,716 28% Parking Garages 0000 Parking Garage Revenue 601 284 671 1,020 40 - - - - - - - - 2,014 9,100 22% 0460 Main Street 601 25,906 27,933 28,062 26,202 64,761 21,525 - - - - - - 194,389 268,766 72% 0462 Leighton Plaza 601 58,466 24,331 25,191 82,032 58,385 19,301 - - - - - - 267,705 497,484 54% 0463 Enforcement 601 4,969 4,623 7,202 3,586 4,680 6,223 - - - - - - 31,283 89,500 35% 0464 Wayne Street 601 30,977 20,895 29,889 11,565 12,333 24,967 - - - - - - 130,626 242,161 54% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 120,601 78,453 91,364 123,425 140,159 72,016 - - - - - - 626,017 1,122,911 56% Capital / Debt Service Hall of Fame 313 50 6 23 8 10 474,777 - - - - - - 474,874 894,300 53% COIT 404 913,313 879,279 1,163,973 920,266 874,964 886,807 - - - - - - 5,638,602 10,963,839 51% Cum Capital Development 406 357 436 410 184 169 259,526 - - - - - - 261,081 484,500 54% Cum Capital Improvement 407 150,266 294 301 144 132 117,143 - - - - - - 268,279 435,000 62% EDIT 408 1,041,459 1,981,678 877,267 871,706 870,753 882,446 - - - - - - 6,525,308 11,733,257 56% UDAG 410 445 416 493 235 207 689 - - - - - - 2,485 6,110 41% Major Moves 412 1,774 598,393 2,312 1,238 1,135 3,844 - - - - - - 608,696 1,053,786 58% Morris PAC Improvement 416 436 12,664 13,666 11,585 5,797 3,677 - - - - - - 47,825 104,000 46% Palais Historic Preservation 450 1,907 187 428 429 683 1,534 - - - - - - 5,168 17,100 30% Hall of Fame Capital 677 372 378 431 200 182 612 - - - - - - 2,173 5,000 43% SB Building Corp 755- 1,326,786 210 65 117 169 - - - - - - 1,327,347 2,643,214 50% Parks Bond Debt Svc 757- 65,162 124 65,236 80 64,086 - - - - - - 194,689 391,482 50% xxx xxx xxx- - - - - - - - - - - NA Sub Total 2,110,380 4,865,679 2,059,637 1,871,297 1,754,228 2,695,308 - - - - - - 15,356,529 28,731,588 53% 2017-06 Financial Report - Rev enue Summar y Page 8 of 25 City of South Bend Period Ending:June 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Rainy Day 102 7,644 7,773 8,937 4,262 3,906 13,232 - - - - - - 45,755 60,000 76% Gift, Donation, Bequest 217 50,900 1,097 69,994 5,639 220 51,058 - - - - - - 178,907 184,794 97% Unsafe Building 219 11,928 152,225 26,129 160,537 14,230 18,670 - - - - - - 383,720 793,757 48% Landlord Registration 221 2,260 270 1,245 155 60 25 - - - - - - 4,015 7,000 57% Loss Recovery 227 730 741 851 404 368 1,244 - - - - - - 4,337 9,000 48% LOIT 2016 Special Distribution 257- 6,605 156,406 1,646 1,183 56,449 - - - - - - 222,289 1,471,000 15% Human Rights 258 91,498 4,790 5,975 2,576 356 600 - - - - - - 105,794 165,040 64% Morris Palais Marketing 273 34 582 1,132 577 947 3,950 - - - - - - 7,222 18,300 39% IT / Innovation /311 Call Center 279 430,621 430,621 430,621 430,621 430,621 430,621 - - - - - - 2,583,726 5,205,034 50% Professional Sports Development 377 80,547 318 115,357 24,107 23,146 214 - - - - - - 243,689 732,000 33% 1201 Code Enforcement 600 12,749 366,188 37,109 380,781 6,482 53,138 - - - - - - 856,446 1,810,451 47% 1207 Animal Control 600 4,706 187,306 6,015 188,107 6,975 6,368 - - - - - - 399,476 789,865 51% 1306 Building Operations 600 92,341 88,523 111,064 97,168 142,392 199,102 - - - - - - 730,589 1,376,150 53% Century Center 670 910,931 211,677 (225,009) 400,425 412,693 311,339 - - - - - - 2,022,055 4,194,311 48% Century Center Capital 671 74 66 74 71 74 71 - - - - - - 430 750 57% Century Center Energy Saving 672 6 4 4 4 4 4 - - - - - - 26 192,297 0% Sub Total 1,696,966 1,458,786 745,904 1,697,080 1,043,657 1,146,084 - - - - - - 7,788,477 17,009,749 46% Business Insurance 0000 Business Insurance Revenues 226 246,679 247,476 245,267 248,740 243,026 253,098 - - - - - - 1,484,286 3,527,591 42% 0418 Workers Compensation 226 619 35,123 - - - 900 - - - - - - 36,642 30,000 122% Sub Total 247,298 282,599 245,267 248,740 243,026 253,998 - - - - - - 1,520,928 3,557,591 43% Fiduciary Trust & Agency Fire Pension 701 335 84 - - - 2,461,856 - - - - - - 2,462,275 4,925,212 50% Police Pension 702 2,386 1,224 5,915 565 595 3,108,612 - - - - - - 3,119,297 6,210,679 50% Employee Benefits 711 1,511,154 1,463,664 1,500,195 1,490,799 1,481,130 1,495,193 - - - - - - 8,942,135 17,800,413 50% Unemployment Comp 713 217 214 244 114 102 339 - - - - - - 1,230 83,000 1% City Cemetery Trust 730 22 22 25 12 11 37 - - - - - - 130 200 65% Equipment / Vehicle Leasing 750- 298 375 223 2,916,712 532 - - - - - - 2,918,140 5,501,000 53% Parks Bond Capital 751- 369 539 485 517 632 - - - - - - 2,541 7,500 34% Smart Street Bond Capital 753- 604 663 544 545 606 - - - - - - 2,962 17,000 17% Sub Total 1,514,115 1,466,478 1,507,957 1,492,742 4,399,611 7,067,807 - - - - - - 17,448,710 34,545,004 51% Civil City Revenues 15,432,926 22,115,337 17,328,250 17,107,703 17,863,212 51,243,156 - - - - - - 141,090,583 288,069,303 49% Tax Increment Financing TIF River West - Airport 324 78,976 118,077 87,148 235,509 71,358 9,426,694 - - - - - - 10,017,763 23,152,477 43% TIF West Washington 422 1,411 1,497 1,721 821 751 200,696 - - - - - - 206,896 436,000 47% TIF Leighton Plaza 425 10,467 14,196 10,498 8,768 8,762 8,914 - - - - - - 61,604 197,014 31% TIF River East DEV (NE)429 5,927 6,699 11,342 3,606 3,279 1,437,646 - - - - - - 1,468,499 3,069,524 48% TIF Southside 430 3,108 564,649 4,388 906,618 2,039 1,224,439 - - - - - - 2,705,240 3,901,127 69% TIF Erskine Village 432 3,646 3,484 791 378 219 1 - - - - - - 8,519 12,000 71% TIF Douglas Road 435 77 120 95 3 3 218,289 - - - - - - 218,587 327,858 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 - - - - - - 17,007,871 34,396,903 49% 2017-06 Financial Report - Rev enue Summar y Page 9 of 25 City of South Bend Period Ending:June 30, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433 6 6 7 4 3 10 - - - - - - 37 135 27% Certified Technology Park 439 1,614 1,641 1,887 900 825 1,064 - - - - - - 7,931 50,000 16% Airport Urban Enterprise Zone 454 288 292 336 160 147 498 - - - - - - 1,722 3,900 44% Industrial Revolving 754- - 21,526 9,673 14,952 12,238 - - - - - - 58,389 210,000 28% Sub Total 1,908 1,940 23,757 10,737 15,927 13,810 - - - - - - 68,079 264,035 26% Debt Service Airport Debt Reserve 2003 315 780 792 902 434 398 1,346 - - - - - - 4,652 14,000 33% Coveleski Bond Debt Reserve 317 385 391 450 214 197 666 - - - - - - 2,302 5,000 46% Central Development reserve 328 1,303 1,323 1,522 725 664 2,249 - - - - - - 7,786 15,000 52% SB Redevelopment Authority 752- 772,669 1,236,763 395 197,726 305 - - - - - - 2,207,858 3,868,169 57% Smart Streets Debt Svc 756- 179 263 197 218 277 - - - - - - 1,134 855,784 0% 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 - - - - - - 6,185,514 8,719,735 71% Redevelopment Commission 108,431 5,447,712 1,379,721 1,168,406 301,541 14,855,652 - - - - - - 23,261,463 43,380,673 54% City Operations Total 15,541,357 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 - - - - - - 164,352,047 331,368,706 50% Revenue report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 66,098,808 0 0 0 0 0 0 164,352,046 331,368,706 0 0 0 0(0)0 0 0 0 0 0 0 0 0 2017-06 Financial Report - Rev enue Summar y Page 10 of 25 City of South Bend Period Ending:June 30, 2017 Property Tax Revenue 2016 Tax Pay 2017 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/20/2017 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,248,867.00 0.95 38,236,423.65 21,820,142.51 - - - 21,820,142.51 18,428,724.49 54.21% Parks & Recreation 201 9,179,442.00 0.95 8,720,469.90 4,976,456.29 - - - 4,976,456.29 4,202,985.71 54.21% College Football Hall of Fame 313 833,277.00 0.95 791,613.15 451,820.36 - - - 451,820.36 381,456.64 54.22% Cumulative Capital District 406 443,869.00 0.95 421,675.55 240,635.07 - - - 240,635.07 203,233.93 54.21% Total - City 50,705,455.00 48,170,182.25 27,489,054.23 - - - 27,489,054.23 23,216,400.77 54.21% Tax Increment Financing Airport TIF District 324 18,698,946.24 0.95 17,763,998.93 8,932,881.19 - - - 8,932,881.19 9,766,065.05 47.77% West Washington TIF District 422 367,557.18 0.95 349,179.32 198,151.66 - - - 198,151.66 169,405.52 53.91% Northeast Residential TIF District 436 4,405,723.00 0.95 4,185,436.85 2,320,321.06 - - - 2,320,321.06 2,085,401.94 52.67% Southside TIF District #1 430 2,390,790.99 0.95 2,271,251.44 1,216,823.61 - - - 1,216,823.61 1,173,967.38 50.90% Douglas Road TIF District 435 321,949.68 0.95 305,852.20 218,279.99 - - - 218,279.99 103,669.69 67.80% Northeast TIF 429 2,766,113.25 0.95 2,627,807.59 1,428,045.99 - - - 1,428,045.99 1,338,067.26 51.63% Total - Tax Increment Financing 28,951,080.34 27,503,526.32 14,314,503.50 - - - 14,314,503.50 14,636,576.84 49.44% Grand Total 79,656,535.34 75,673,708.57 41,803,557.73 - - - 41,803,557.73 37,852,977.61 52.48% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/20/17 2017-06 Financial Report - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:June 30, 2017 Property Tax Revenue 2015 Tax Pay 2016 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/14/2016 12/20/2016 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,360,212.00 0.95 38,342,201.40 21,490,881.50 17,871,257.85 - - 39,362,139.35 998,072.65 97.53% Parks & Recreation 201 8,090,885.00 0.95 7,686,340.75 4,312,625.82 3,590,369.07 - - 7,902,994.89 187,890.11 97.68% College Football Hall of Fame 313 1,396,308.00 0.95 1,326,492.60 744,229.93 617,281.74 - - 1,361,511.67 34,796.33 97.51% Cumulative Capital District 406 451,368.00 0.95 428,799.60 240,589.67 200,296.91 - - 440,886.58 10,481.42 97.68% Total - City 50,298,773.00 47,783,834.35 26,788,326.92 22,279,205.57 - - 49,067,532.49 1,231,240.51 97.55% Tax Increment Financing Airport TIF District 324 19,123,985.00 0.95 18,167,785.75 9,769,452.30 8,389,858.48 - - 18,159,310.78 964,674.22 94.96% West Washington TIF District 422 516,171.00 0.95 490,362.45 282,809.66 170,692.93 - - 453,502.59 62,668.41 87.86% Northeast Residential TIF District 436 3,913,816.00 0.95 3,718,125.20 2,061,402.42 1,871,544.98 - - 3,932,947.40 (19,131.40) 100.49% Southside TIF District #1 430 2,481,892.00 0.95 2,357,797.40 1,251,613.66 1,149,638.01 - - 2,401,251.67 80,640.33 96.75% Douglas Road TIF District 435 337,099.00 0.95 320,244.05 231,288.93 113,972.95 - - 345,261.88 (8,162.88) 102.42% Northeast TIF 429 2,586,566.00 0.95 2,457,237.70 1,170,979.07 1,177,628.87 - - 2,348,607.94 237,958.06 90.80% Total - Tax Increment Financing 28,959,529.00 27,511,552.55 14,767,546.04 12,873,336.22 - - 27,640,882.26 1,318,646.74 95.45% Grand Total 79,258,302.00 75,295,386.90 41,555,872.96 35,152,541.79 - - 76,708,414.75 2,549,887.25 96.78% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/14/16 Distribution 2 - Issued by St. Joseph County on 12/20/16 2017-06 Financial Report - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:June 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0101 Mayor 101 59,009 57,926 57,827 61,110 54,678 84,839 - - - - - - 375,390 872,923 43% 0201 Clerk 101 38,451 43,206 31,600 35,638 35,273 46,995 - - - - - - 231,163 536,216 43% 0301 Common Council 101 33,451 49,728 27,207 50,580 28,885 34,287 - - - - - - 224,138 571,148 39% 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 - - - - - - 1,216,850 2,476,351 49% 0501 Legal Department 101 87,585 86,783 87,565 116,630 75,744 109,460 - - - - - - 563,766 1,158,567 49% Sub Total 402,773 416,575 385,606 467,764 444,284 537,304 - - - - - - 2,654,307 5,658,205 47% Public Works 0602 Engineering 101 81,736 88,219 89,641 89,644 103,226 120,430 - - - - - - 572,895 1,445,157 40% Sub Total 81,736 88,219 89,641 89,644 103,226 120,430 - - - - - - 572,895 1,445,157 40% Public Safety 0801 Police 101 2,401,801 2,081,566 2,099,258 2,016,036 2,087,143 2,837,886 - - - - - - 13,523,691 29,668,433 46% 0901 Fire 101 1,586,894 1,525,036 1,582,606 1,554,060 1,604,395 2,215,029 - - - - - - 10,068,020 21,111,466 48% Sub Total 3,988,695 3,606,602 3,681,864 3,570,096 3,691,539 5,052,914 - - - - - - 23,591,711 50,779,899 46% Code Enforcement Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 74,731 80,199 47,613 60,412 60,629 72,212 - - - - - - 395,796 1,271,039 31% 0405 Palais Royale 101 24,999 30,061 10,824 17,021 18,169 22,340 - - - - - - 123,415 530,200 23% Sub Total 99,730 110,260 58,436 77,434 78,798 94,553 - - - - - - 519,211 1,801,239 29% Human Rights 1008 Human Rights 101 37,821 40,148 32,484 37,408 31,913 34,695 - - - - - - 214,469 425,805 50% Sub Total 37,821 40,148 32,484 37,408 31,913 34,695 - - - - - - 214,469 425,805 50% General Fund Expenditure Total 4,610,756 4,261,804 4,248,032 4,242,346 4,349,760 5,839,896 - - - - - - 27,552,593 60,110,305 46% 2017-06 Financial Report - Expe nditu re Su mmary Page 13 of 25 City of South Bend Period Ending:June 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 1100 Administration 201 147,654 87,876 110,868 112,743 118,476 128,067 - - - - - - 705,684 1,468,296 48% 1101 Maintenance 201 399,021 416,933 423,013 569,543 553,920 672,696 - - - - - - 3,035,125 6,854,308 44% 1102 Golf Operations 201 54,483 75,381 77,362 180,384 131,801 173,015 - - - - - - 692,426 1,638,575 42% 1103 Recreation Division 201 165,251 145,109 133,502 139,866 147,123 241,949 - - - - - - 972,799 2,153,817 45% 1104 Potawatomi Zoo 201 355,692 7,425 7,231 7,208 289,717 8,923 - - - - - - 676,196 704,464 96% 1106 Potawatomi Greenhouse 201 5,013 4,555 2,550 2,375 1,198 15,764 - - - - - - 31,455 54,408 58% 1108 Graffiti Removal 201 13,483 12,628 11,465 10,265 8,529 10,420 - - - - - - 66,789 97,861 68% 1110 Marketing and Events 201 16,583 45,412 58,810 61,326 60,810 83,508 - - - - - - 326,448 953,588 34% Recreation Non Reverting 203 51,478 47,722 45,821 94,361 71,392 92,875 - - - - - - 403,648 1,599,683 25% East Race Waterway 271- - - - - - - - - - - - - 1,367 0% Coveleski Stadium 401- - - 8,542 4,569 - - - - - - - 13,111 30,000 44% Zoo Endowment 403- - - 53,599 - (3,549) - - - - - - 50,049 49,688 101% Park Non Reverting 405 45,874 17,251 22,621 42,193 16,930 71,879 - - - - - - 216,748 513,024 42% Sub Total 1,254,532 860,290 893,243 1,282,404 1,404,465 1,495,546 - - - - - - 7,190,480 16,119,079 45% Public Works Motor Vehicle Highway 202 919,033 515,568 547,694 523,276 541,787 631,705 - - - - - - 3,679,063 9,886,533 37% Curb and Sidewalk 202 150,920 40,047 37,646 38,164 143,273 121,813 - - - - - - 531,863 1,878,998 28% Central Services 222 730,352 648,645 561,962 613,240 672,069 593,479 - - - - - - 3,819,747 8,564,643 45% Central Services Capital 224 10,575 4,009 - 16,964 - 11,786 - - - - - - 43,335 326,025 13% Local Roads & Streets 251 209,999 4,801 3,018 35,678 92,276 81,399 - - - - - - 427,171 2,211,544 19% Local Roads & Bridge 265- - - - - - - - - - - - - 2,000,000 0% Project ReLeaf 655 15,049 90,567 3,684 115,917 3,108 3,165 - - - - - - 231,490 525,416 44% Sub Total 2,035,929 1,303,638 1,154,005 1,343,240 1,452,512 1,443,345 - - - - - - 8,732,669 25,393,159 34% Public Works Solid Waste Solid Waste Operations 610 489,623 312,159 388,501 385,830 347,815 685,660 - - - - - - 2,609,589 5,662,910 46% Solid Waste Capital 611 286,902 146,712 218 83,859 20,129 219 - - - - - - 538,038 1,135,613 47% Sub Total 776,525 458,871 388,720 469,689 367,944 685,879 - - - - - - 3,147,627 6,798,523 46% Public Works Water Utility 0630 Water Leak Insurance 620 43,958 41,864 50,876 46,504 58,900 71,053 - - - - - - 313,154 1,035,000 30% 0640 Water Works 620 1,417,876 1,256,524 1,085,407 1,142,917 1,117,427 1,222,741 - - - - - - 7,242,892 16,688,754 43% 0660 Clay Water 620- - (0) 169 37 5 - - - - - - 211 3,500 6% Waterworks Capital 622 111,938 177,777 13,775 9,295 8,299 17,201 - - - - - - 338,284 1,414,466 24% Waterworks Deposit 624 874 1,174 1,347 639 583 1,965 - - - - - - 6,582 15,000 44% Waterworks Sinking 625 815 289 321 211 266 255,311 - - - - - - 257,214 2,054,891 13% 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 - - - - - - 11,059 23,000 48% Sub Total 1,576,855 1,479,523 1,154,018 1,200,827 1,186,511 1,581,662 - - - - - - 8,179,396 21,250,611 38% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 48,400 46,390 29,841 52,988 63,829 41,714 - - - - - - 283,163 534,509 53% 0621 Sewer Repair 641 517,647 434,598 385,613 579,850 349,846 452,561 - - - - - - 2,720,115 9,248,687 29% 0625 Concrete Crew 641 30,239 20,767 19,975 30,713 26,000 34,774 - - - - - - 162,468 474,389 34% 0630 Wastewater Operations 641 2,358,990 1,454,679 3,260,858 2,528,275 2,582,015 2,554,148 - - - - - - 14,738,966 33,209,563 44% 0631 Organic Resources 641 124,773 126,931 80,689 53,682 214,126 78,314 - - - - - - 678,515 1,608,946 42% 0650 Clay Sewage 641- 5 26 50 431 - - - - - - - 512 750 68% Sewage Capital 642 1,298,328 387,989 178,442 93,243 530,257 335,486 - - - - - - 2,823,745 8,040,455 35% Sewage Reserve 643 2,625 3,535 4,065 2,021 1,972 6,676 - - - - - - 20,893 30,000 70% Sewage Bond Sinking 649 1,000 500 - - 830,476 249,650 - - - - - - 1,081,626 9,163,754 12% 2011 Sewer Bond 659- - - 51,687 - - - - - - - - 51,687 51,688 100% 2012 Sewer Bond 661 3,000 166,950 113,521 180,305 269,318 115,454 - - - - - - 848,549 3,010,364 28% Sub Total 4,385,001 2,642,343 4,073,031 3,572,814 4,868,271 3,868,777 - - - - - - 23,410,237 65,373,105 36% 2017-06 Financial Report - Expe nditu re Su mmary Page 14 of 25 City of South Bend Period Ending:June 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216- - - - - - - - - - - - - 36,000 0% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 44,630 19,978 197,939 29,048 26,375 24,885 - - - - - - 342,856 788,422 43% Emergency Telephone System 244- - - 4,708 - - - - - - - - 4,708 33,671 14% Public Safety LOIT 249 466,245 487,781 613,087 598,935 610,756 918,862 - - - - - - 3,695,667 7,462,645 50% 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 - - - - - - 1,241,614 3,757,457 33% Police Take Home Vehicle 278- 972 - (60) (120) (260) - - - - - - 532 10,000 5% Police Grants 292 2,796 1,266 1,330 90 106 - - - - - - - 5,587 10,805 52% Police Academy 294 162 283 692 909 515 3,776 - - - - - - 6,337 22,500 28% COPS More Grants 295 10,980 3,436 108,583 11,664 915 240 - - - - - - 135,818 263,767 51% Drug Enforcement 299 11,242 23,096 13,200 - - 3,172 - - - - - - 50,710 196,337 26% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 557,416 558,803 1,985,195 683,915 678,354 1,020,145 - - - - - - 5,483,828 12,584,632 44% Public Safety - Fire EMS Capital 287 235,792 150,604 - 386,321 136,287 547,964 - - - - - - 1,456,968 3,991,466 37% EMS Operating Fund 288 438,601 356,431 401,753 451,805 437,873 602,509 - - - - - - 2,688,971 6,117,914 44% Hazmat 289 430 255 - - 4,057 - - - - - - - 4,742 10,431 45% River Rescue 291 1,443 231 231 23,817 10,419 21,299 - - - - - - 57,439 117,349 49% xxx xxx xxx- - - - - - - - - - - - - NA Sub Total 676,266 507,520 401,984 861,943 588,636 1,171,772 - - - - - - 4,208,121 10,237,160 41% Department of Community Investment Studebaker/Oliver 209 70,702 4,592 23,072 39,510 43,825 - - - - - - - 181,701 539,393 34% State Grant 210- - 18,003 - - 18,003 - - - - - - 36,005 509,757 7% DCI Operating 211 197,318 171,937 175,385 177,600 195,239 226,245 - - - - - - 1,143,724 2,650,376 43% 1001 Dept. of Community Investment 212 575,173 100,654 21,621 163,348 164,147 146,738 - - - - - - 1,171,680 5,455,838 21% 1003 Administration 212- - - - - - - - - - - - - - NA xxx Programs 212- - - - - - - - - - - - - - NA Sub Total 843,192 277,183 238,081 380,458 403,211 390,985 - - - - - - 2,533,110 9,155,364 28% 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 - - - - - - 138,605 261,894 53% 0462 Leighton Plaza 601 20,044 21,722 1,360 55,854 7,114 18,879 - - - - - - 124,974 596,368 21% 0463 Enforcement 601 7,858 7,238 437 22,849 437 12,035 - - - - - - 50,854 128,675 40% 0464 Wayne Street 601 12,364 13,889 936 32,097 5,591 20,718 - - - - - - 85,596 244,417 35% 0465 Eddy Street Commons 601- - - 32 - 647 - - - - - - 679 15,900 4% Sub Total 50,284 54,648 4,482 186,776 24,534 80,587 - - - - - - 401,312 1,247,254 32% Capital / Debt Service Hall of Fame 313 635,000 - (3,265) - - - - - - - - - 631,735 1,268,999 50% COIT 404 1,172,640 1,270,520 840,369 1,585,347 13,821 530,881 - - - - - - 5,413,578 12,071,593 45% Cum Capital Development 406 112,650 27,896 - - 149,081 - - - - - - - 289,627 476,500 61% Cum Capital Improvement 407 185,125 - - - - - - - - - - - 185,125 372,250 50% EDIT 408 697,093 1,928,675 70,750 2,317,413 62,665 58,366 - - - - - - 5,134,962 11,559,184 44% UDAG 410 30,702 - - 31,814 - - - - - - - - 62,515 126,144 50% Major Moves 412 543 - 62 - 910 - - - - - - - 1,514 2,470,708 0% Morris PAC Improvement 416 408 - 1,645 1,423 540 - - - - - - - 4,016 401,144 1% Palais Historic Preservation 450- - - - - - - - - - - - - 5,000 0% Hall of Fame Capital 677 3,866 14,859 2,574 3,209 2,159 2,638 - - - - - - 29,304 81,091 36% SB Building Corp 755- - 1,437,970 - - - - - - - - - 1,437,970 2,643,214 54% Parks Bond Debt 757- - 198,566 - - - - - - - - - 198,566 391,482 51% Sub Total 2,838,027 3,241,949 2,548,669 3,939,206 229,176 591,885 - - - - - - 13,388,912 31,867,309 42% 2017-06 Financial Report - Expe nditu re Su mmary Page 15 of 25 City of South Bend Period Ending:June 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Gift, Donation, Bequest 217 72,000 900 - 663 760 6,877 - - - - - - 81,200 241,700 34% Unsafe Building 219 80,336 43,005 41,261 55,208 81,628 79,253 - - - - - - 380,690 902,746 42% Landlord Registration 221 5 5 - - - - - - - - - - 10 1,000 1% Loss Recovery 227- 3,345 7,600 2,080 5,844 - - - - - - - 18,869 598,675 3% Human Rights 258 17,100 3,192 7,767 8,984 17,529 18,147 - - - - - - 72,720 201,773 36% 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 - - - - - - 1,772,176 5,205,034 34% Professional Sports Development 377 467,640 800 - - - - - - - - - - 468,440 827,955 57% 1201 Code Enforcement 600 128,453 94,686 101,457 110,099 112,811 146,364 - - - - - - 693,870 1,625,378 43% 1207 Animal Control 600 68,101 59,652 58,318 65,964 68,163 74,484 - - - - - - 394,682 790,517 50% 1306 Building Operations 600 110,343 98,842 97,813 101,286 98,111 129,067 - - - - - - 635,462 1,361,925 47% Century Center 670 282,027 349,477 (15,339) 661,555 322,739 382,643 - - - - - - 1,983,102 4,194,310 47% Century Center Energy Saving 672- - - 95,128 - - - - - - - - 95,128 192,297 49% Sub Total 1,554,131 860,986 505,279 1,361,472 1,204,828 1,115,326 - - - - - - 6,602,021 16,164,985 41% Business Insurance 0403 Self Funded Liability Ins 226 17,866 17,273 20,527 15,424 16,015 21,466 - - - - - - 108,571 235,471 46% 0412 Liability Insurance 226 45,537 23,578 52,779 27,697 640,369 40,160 - - - - - - 830,120 2,034,051 41% 0417 Business Insurance 226 45,354 - 21,392 120 21,404 - - - - - - - 88,270 595,678 15% 0418 Workers Compensation 226 119,520 87,561 54,191 240,566 58,672 52,655 - - - - - - 613,166 722,386 85% Sub Total 228,276 128,412 148,890 283,807 736,460 114,282 - - - - - - 1,640,126 3,587,586 46% Fiduciary Trust & Agency Fire Pension 701 388,455 396,509 396,201 394,300 390,847 376,476 - - - - - - 2,342,788 5,098,269 46% Police Pension 702 513,053 511,187 523,297 519,926 517,885 505,354 - - - - - - 3,090,701 6,423,889 48% Employee Benefits 711 1,060,085 1,343,141 951,392 1,174,621 1,102,064 1,726,172 - - - - - - 7,357,476 17,803,200 41% Unemployment Comp 713 6,038 8,041 4,389 5,340 3,324 5,526 - - - - - - 32,658 84,105 39% City Cemetery Trust 730- - - - - - - - - - - - 6,000 0% Equipment / Vehicle Leasing 750- 983,042 489,584 65,756 135,750 128,509 - - - - - - 1,802,641 5,500,000 33% Parks Bond Capital 751- 63,156 211,200 140,581 19,839 111,546 - - - - - - 546,322 3,500,000 16% Smart Street Bond 753- 986,652 285,891 512,350 617,149 341,706 - - - - - - 2,743,748 10,000,000 27% xxx xxx xxx NA Sub Total 1,967,632 4,291,727 2,861,954 2,812,874 2,786,859 3,195,289 - - - - - - 17,916,334 48,415,463 37% Civil City Expenditure 23,354,822 20,927,696 20,605,582 22,621,770 20,281,521 22,595,375 - - - - - - 130,386,765 328,304,535 40% Tax Increment Financing TIF River West - Airport 324 4,348,398 123,050 1,434,861 735,643 590,372 186,766 - - - - - - 7,419,089 39,618,887 19% TIF West Washington 422- - 2,420 385 - - - - - - - - 2,805 1,428,292 0% TIF Leighton Plaza 425 5,141 9,302 4,480 11,400 9,310 29,194 - - - - - - 68,827 158,166 44% TIF River East DEV (NE)429 27,144 45,644 101,171 587,302 45,684 343,124 - - - - - - 1,150,068 10,602,696 11% TIF Southside 430 146,124 12,530 17,419 24,812 100,639 6,683 - - - - - - 308,206 6,917,426 4% TIF Erskine Village 432 3,961,667 - - 904,519 - - - - - - - - 4,866,186 4,878,795 100% TIF Douglas Road 435- 150,000 - - - - - - - - - - 150,000 344,216 44% TIF River East RES (NE RE)436 1,236,500 446,589 - - - - - - - - - - 1,683,089 3,430,231 49% Sub Total 9,724,973 787,115 1,560,351 2,264,061 746,005 565,766 - - - - - - 15,648,270 67,378,709 23% 2017-06 Financial Report - Expe nditu re Su mmary Page 16 of 25 City of South Bend Period Ending:June 30, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433- - - 816 316 - - - - - - - 1,133 4,500 25% Certified Technology Park 439- - - 1,800,000 - - - - - - 1,800,000 2,200,000 82% Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Industrial Revolving 754- - 14,437 16,553 775 17,679 - - - - - - 49,444 157,000 31% Sub Total- - 14,437 17,369 1,801,091 17,679 - - - - - - 1,850,577 2,411,500 77% Debt Service Airport Debt Reserve 2003 315 588 792 902 434 398 1,346 - - - - - - 4,460 14,000 32% Central Development reserve 328 983 1,323 1,522 725 664 2,249 - - - - - - 7,466 15,000 50% SB Redevelopment Authority 752- 735,236 2,004,503 5 - 345,906 - - - - - - 3,085,650 4,603,405 67% Smart Streets Debt Svc 756- - 394,784 - - - - - - - - - 394,784 855,784 46% 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 - - - - - - 8,015,258 10,011,107 80% Redevelopment Commission 9,726,545 2,085,695 7,938,167 2,282,595 2,548,158 932,945 - - - - - - 25,514,105 79,801,316 32% City Operations Total 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 23,528,321 - - - - - - 155,900,871 408,105,851 38% Expenditure report 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 23,528,321 0 0 0 0 0 0 155,900,870 408,105,851 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2017-06 Financial Report - Expe nditu re Su mmary Page 17 of 25 City of South Bend Period Ending:June 30, 2017 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2017 Princip al 2017 Inter est 2017 Debt a t 2017 Total D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Payme nt Addit ion 12/31/20 17 D ebt P aymen ts Civil City Debt Bond Deb t A mort s ch # 3 1 CEDIT Bond 199 7 200 6 20 17 40 8 2/1 8/1--11,870,00 0.00 430,000.00 4 30,000.00 9,932.50 0.00 0.00 439,93 2.50 3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 2,755,000.00 5 75,000.00 95,994.00 0.00 2,180,000.00 670,99 4.00 2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 1/1 7/1--5,975,00 0.00 2,380,000.00 3 75,000.00 47,600.00 0.00 2,005,000.00 422,60 0.00 3 9 Sout h B end Building C orporation Fire HQ / P ol ice H Q 200 3 201 2 20 23 40 4/324 2/1 8/1--21,335,00 0.00 8,885,000.00 1,2 40,000.00 325,740.00 0.00 7,645,000.00 1,565,74 0.00 2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 1/1 7/1--4,710,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 42 0 5/1 11/1--4,655,00 0.00 3,175,000.00 3 00,000.00 85,812.50 0.00 2,875,000.00 385,81 2.50 6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 1/1 7/1--5,380,00 0.00 4,325,000.00 2 40,000.00 239,938.00 0.00 4,085,000.00 479,93 8.00 7 0 Sewage W orks Reve nue Bon ds - 2009 Sewag e W orks 200 9 20 28 64 9 6/1 12/1--3,297,00 0.00 2,249,643.00 1 62,472.00 63,214.00 0.00 2,087,171.00 225,68 6.00 8 0 2 010 Sewage W orks Re v enue Bonds Sewag e W orks 201 0 20 30 64 9 6/1 12/1--9,345,00 0.00 7,145,000.00 3 95,000.00 298,617.50 0.00 6,750,000.00 693,61 7.50 9 3 Sewage W orks Reve nue Bon ds 201 1 Sewag e W orks 201 1 20 31 64 9 6/1 12/1--21,500,00 0.00 17,295,000.00 8 95,000.00 654,300.00 0.00 16,400,000.00 1,549,30 0.00 9 9 2 012 W ater Wo rks Reven ue Bond W ater W orks 201 2 20 33 62 5 1/1 7/1--8,300,00 0.00 6,925,000.00 3 55,000.00 209,786.26 0.00 6,570,000.00 564,78 6.26 10 1 2 012 Sewage W orks Re v enue Bonds Sewag e W orks 201 2 20 32 64 9 6/1 12/1--25,000,00 0.00 20,890,000.00 1,0 60,000.00 486,680.00 0.00 19,830,000.00 1,546,68 0.00 10 5 2 013A Sewer Bon d Refunding Sewag e W orks 201 3 201 3 20 24 64 9 6/1 12/1--14,765,00 0.00 8,050,000.00 1,9 55,000.00 156,170.00 0.00 6,095,000.00 2,111,17 0.00 11 6 2 013 Building C orporation EMS / Fire D epar t ment 201 3 20 33 28 8 2/1 8/1--5,580,00 0.00 5,145,000.00 2 25,000.00 177,480.00 0.00 4,920,000.00 402,48 0.00 13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly 2,657,69 6.50 2,386,507.92 1 07,652.90 59,107.80 0.00 2,278,855.02 166,76 0.70 13 9 Cen tury Center En ergy Saving s Impro v ements at Century Ctr.201 5 20 31 67 2 5/1 11/1 4,167,89 7.00 4,145,312.00 46,606.00 144,690.68 0.00 4,098,706.00 191,29 6.68 14 1 Park s and Rec reation Bo nd Parks Improveme nts 201 5 20 35 40 8 2/1 8/1--5,605,00 0.00 5,295,000.00 2 10,000.00 172,256.26 0.00 5,085,000.00 382,25 6.26 14 5 Sewage W orks Reve nue Bon ds -20 15 Sewer Impr ovemen ts 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 24,965,000.00 2,5 30,000.00 499,300.00 0.00 22,435,000.00 3,029,30 0.00 15 6 2 016 W ater Wo rks Refu nding Bon ds R efunding 20 00 / 2 006 SRF 201 6 20 27 62 5 1/1 7/1--3,300,00 0.00 3,300,000.00 4 05,000.00 49,500.00 0.00 2,895,000.00 454,50 0.00 xxx Total Bond Debt 2 34,877,59 3.50 129,741,462.92 11,5 06,730.90 3,776,119.50 0.00 118,234,732.02 15,282,85 0.40 Loa ns Payab le 6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 1/1 7/1--427,33 2.00 332,562.00 20,912.00 11,207.34 0.00 311,650.00 32,11 9.34 8 2 In terfu nd Loan 41 0 - UDAG 1st Sour c e/Marriott Garage 201 0 20 15 41 0 6/15 12/1 5--2,700,00 0.00 1,351,597.75 1 26,142.25 0.00 0.00 1,225,455.50 126,14 2.25 2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 1/1 7/1--2,600,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 xxx Amy Shirk Total Loans Pa yable 29,822,33 2.00 1,684,159.75 1 47,054.25 11,207.34 0.00 1,537,105.50 158,26 1.59 Ca pita l Leases 5 1 Ch ase LE D Equipmen t 200 7 20 17 10 1 1/1 7/1--1,531,57 3.00 194,320.02 1 94,319.97 6,259.69 0.00 0.05 200,57 9.66 8 9 Sun Trust Police, Parks, Bl dg vehicles 201 1 20 16 40 4/20 1/600 3/15 6/15 9/15 12/15 2,068,20 2.00 0.00 0.00 0.00 0.00 0.00 0.00 9 0 Cap ital One Public Fundin g Solid Was te Cont ai ners/Truc k s 201 1 20 16 61 1 3/15 6/15 9/15 12/15 207,43 2.00 0.00 0.00 0.00 0.00 0.00 0.00 9 1 GE Cap ital I nfor mation Techn ology Police Dept Copier 201 1 20 16 10 1 1/11 4/11 7/11 10/11 3,83 6.00 0.00 0.00 0.00 0.00 0.00 0.00 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 0.00 0.00 0.00 0.00 0.00 0.00 9 4 Iko n Office Solu t ions Mayor Ric oh M P 2851 SP Copier 201 1 20 16 10 1 2/15 5/15 8/15 11/15 2,56 9.53 0.00 0.00 0.00 0.00 0.00 0.00 9 5 Sun Trust E quipme nt F in ance Parks-Golf C ars Lease 201 2 20 16 20 1 4/15 10/1 5--344,50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9 7 Sun Trust E quipme nt F in ance Police Veh ic le s & Equ ipment 201 2 20 17 40 6 5/15 11/1 5--1,295,00 0.00 134,585.22 1 34,585.22 1,140.42 0.00 0.00 135,72 5.64 9 8 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/640 5/15 11/1 5--945,67 4.38 97,793.51 97,793.52 735.98 0.00(0.01)98,52 9.50 10 0 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/600/288 1/15 7/15--2,806,05 4.00 575,316.55 5 75,316.53 5,634.82 0.00 0.02 580,95 1.35 10 2 Iko n Office Solu t ions / Ricoh W astewater C opier 201 2 20 17 64 1 Monthly 1st 5,74 4.95 756.77 756.77 65.82 0.00 0.00 82 2.59 10 3 GE Cap ital I nfor mation Techn ology Fire Department Cop ie r 201 2 20 17 10 1 2/28 5/28 8/28 11/28 5,47 1.01 926.68 926.68 27.40 0.00 0.00 95 4.08 10 6 Ricoh U SA (N ew)C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 815.82 814.82 24.94 0.00 1.00 83 9.76 10 7 Ricoh U SA Street/Sewer Dept Copier 201 3 20 18 20 2/641 3/4 6/4 9/4 12/4 5,55 9.15 1,225.93 1,225.93 44.88 0.00 0.00 1,27 0.81 10 8 Ricoh U SA C ity Att orney C opier 201 3 20 18 10 1 2/12 5/12 8/12 11/12 5,55 9.15 1,232.73 1,231.73 39.06 0.00 1.00 1,27 0.79 10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 2/21 5/21 8/21 11/21 16,12 9.94 3,575.09 3,574.09 113.15 0.00 1.00 3,68 7.24 11 0 PNC Equipm ent F inance Vehi c le/Equipmen t Lease 201 3 20 18 10 1/20 2/406/641 1/15 7/15--1,689,66 9.59 689,257.88 3 42,533.13 7,367.39 0.00 346,724.75 349,90 0.52 11 1 Ricoh U SA En gi neer in g P l otter/Scan ner 201 3 20 18 10 1 3/3 6/3 9/3 12/3 10,66 7.67 2,459.26 2,458.26 133.72 0.00 1.00 2,59 1.98 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly 4,09 3.64 1,491.77 878.55 60.45 0.00 613.22 93 9.00 11 3 Sun Trust E quipme nt F in ance Police and PW vehicles 201 3 20 18 40 4/65 5/611/202 4/24 10/2 4--1,506,46 5.26 616,891.89 3 06,011.19 8,569.95 0.00 310,880.70 314,58 1.14 11 4 Ricoh U SA Admi n & Fina nce Copier 201 3 20 18 10 1 1/16 4/16 7/16 10/16 11,24 7.97 3,079.36 2,444.79 126.44 0.00 634.57 2,57 1.23 11 7 Police Dept. R ecord D iv. R icoh Police Rec ords Co pi er 201 3 20 18 10 1 Monthly 3rd--9,67 8.26 4,194.14 2,039.23 180.77 0.00 2,154.91 2,22 0.00 11 8 Wat er Works Main R i c oh Copier W ater W orks M ain Ricoh Co pi er 201 3 20 18 62 0 Monthly 10th--5,64 7.50 2,448.11 1,189.78 105.62 0.00 1,258.33 1,29 5.40 11 9 Wat er Works Colfax Ricoh C opier W ater W orks Colfa x R ico h Copier 201 3 20 18 62 0 Monthly 16th--4,73 2.65 2,051.62 997.01 85.51 0.00 1,054.61 1,08 2.52 12 0 Wat er Works Oliv e Ricoh Copier W ater W orks Olive Ricoh C opier 201 3 20 18 62 0 Monthly 10th--4,73 2.65 2,051.62 997.01 85.51 0.00 1,054.61 1,08 2.52 12 3 Police T raining D ept. Ricoh C opier Tra in i ng Copier 201 4 20 19 10 1 Monthly 30th--4,26 3.00 2,076.44 890.27 93.73 0.00 1,186.17 98 4.00 12 4 Police/Public Works V ehicle Leas e 2014 Ci ty V ehicles 201 4 20 19 Various 4/1 10/1--1,959,48 5.95 1,193,797.05 3 91,803.77 16,992.78 0.00 801,993.28 408,79 6.55 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 63,525.63 32,632.97 2,191.39 0.00 30,892.66 34,82 4.36 12 6 HP Computer Lease #2 C omputer Equipment Le ase 201 4 20 18 20 1 and 620 Monthly 8th--4,00 0.00 1,947.01 950.39 70.09 0.00 996.62 1,02 0.48 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 2,795.30 1,412.70 83.34 0.00 1,382.60 1,49 6.04 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 1,917.99 883.34 73.78 0.00 1,034.65 95 7.12 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 706.05 315.44 21.40 0.00 390.61 33 6.84 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 3,302.32 1,071.78 157.86 0.00 2,230.54 1,22 9.64 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 4,876.99 1,804.44 227.40 0.00 3,072.55 2,03 1.84 13 2 Organic Resources & Was tewater R icoh US A C opiers 201 4 20 19 64 1 Monthly 21s t--12,26 0.18 6,558.16 2,513.45 303.55 0.00 4,044.71 2,81 7.00 13 4 Wat er Works Copier - Nort h S tation R icoh US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 2,132.25 992.44 93.08 0.00 1,139.81 1,08 5.52 13 6 HP Computer Lease #8 C omputer Equipment Le ase 201 5 20 19 40 4/20 1/611 Monthly 16th--19,60 3.94 11,854.14 4,538.52 494.04 0.00 7,315.62 5,03 2.56 13 7 Anima l Control Ricoh Copier R icoh US A C opiers 201 5 20 20 60 0 Monthly 30th--5,26 1.50 3,591.88 1,033.37 182.47 0.00 2,558.51 1,21 5.84 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 94,710.62 30,905.89 3,998.51 0.00 63,804.73 34,90 4.40 14 0 Vehicle & Equip. Lease Vehi c le/Equipmen t Lease 201 5 20 20 Various 1/15 7/15--3,425,27 3.58 2,763,845.35 6 76,723.50 35,941.86 0.00 2,087,121.85 712,66 5.36 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly--3,04 0.00 2,161.06 695.77 85.67 0.00 1,465.29 78 1.44 14 4 PNC Vehicle Lease No. 2 Vehi c le Lease Pu rchase 201 5 20 20 Various 5/15 11/1 5--1,267,18 3.00 1,021,855.36 2 49,580.62 14,814.26 0.00 772,274.74 264,39 4.88 14 6 Park s & Rec. Ricoh Cop ie r R icoh Copier 201 6 20 20 20 1 Monthly--4,30 2.06 3,454.72 810.05 176.59 0.00 2,644.67 98 6.64 14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly--32,52 5.00 28,667.19 6,046.87 1,368.89 0.00 22,620.32 7,41 5.76 14 8 Cen tral Services Lanier C opier C 6502 Copier 201 6 20 20 22 2 Monthly--11,41 3.00 10,059.31 2,121.84 480.36 0.00 7,937.47 2,60 2.20 14 9 Vehicle & Equip. Lease Pu bl ic W orks Vehicles Lease 201 6 20 21 Various 2/15 8/15--3,339,83 0.00 3,016,484.17 6 51,783.72 45,609.91 0.00 2,364,700.45 697,39 3.63 15 0 HP Computer Lease C opier L ease 201 6 20 20 Various Monthly--17,43 9.85 14,013.99 3,908.91 574.29 0.00 10,105.08 4,48 3.20 15 1 Admin and Finance R ic oh Copier C opier L ease 201 6 20 21 10 1 Monthly--10,92 3.63 8,938.27 2,047.09 458.15 0.00 6,891.18 2,50 5.24 15 2 PNC Vehicle / Equ ip Lease N o. 2 Vehi c le / E quipment Lea s e 201 6 20 21 Various 1/14 7/14--3,992,54 8.72 3,992,548.72 7 70,391.63 62,984.68 0.00 3,222,157.09 833,37 6.31 15 3 PNC Vehicle / Equ ip Lease Amend 1 Parks and R ecreat io n 201 6 20 21 20 1 1/17 7/17--78,80 8.00 78,808.00 15,287.29 1,141.51 0.00 63,520.71 16,42 8.80 15 4 PNC Vehicle / Equ ip Lease N o. 3 Parks & Rec / IT 201 6 20 21 20 1/279 4/19 10/1 9--1,256,09 6.99 1,256,096.99 2 44,070.10 17,538.46 0.00 1,012,026.89 261,60 8.56 15 5 HP Computer Lease No. 13 C omputer Equipment Le ase 201 6 20 20 Various Monthly---156,02 9.30 150,562.73 33,567.37 6,602.27 0.00 116,995.36 40,16 9.64 15 7 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly---3,18 4.06 3,184.06 918.51 382.49 0.00 2,265.55 1,30 1.00 15 8 Public Fi nance.c om Inc 2017 V ehicle Lea s e No. 1 201 7 20 22 Various 1/14 7/14--2,916,50 0.00 0.00 0.00 0.00 2,9 16,5 00.00 0.00 0.00 15 9 M ayor/W aste Wate r/Fir e Ricoh 2017 Ri c oh Copier Leas e 201 7 20 21 10 1/64 1/287 Monthly---15,70 2.09 0.00 3,285.05 843.03 15,7 02.09 12,417.04 4,12 8.08 xxx T otal Cap ital L ease 33,145,18 9.96 16,078,945.72 4,8 03,081.30 244,787.36 2,9 32,2 02.09 11,291,566.51 5,047,86 8.66 To tal Civ i l C i ty 2 97,845,11 5.46 147,504,568.39 16,4 56,866.45 4,032,114.20 2,9 32,2 02.09 131,063,404.03 20,488,98 0.65 2 0 1 7-06 Finan cial Report - Debt Page 1 8 o f 25 City of South Bend Period Ending:June 30, 2017 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2017 Princip al 2017 Inter est 2017 Debt a t 2017 Total D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Payme nt Addit ion 12/31/20 17 D ebt P aymen ts Re dev elopment C ommis sion Debt Bond Deb t 7 Cen tury Center Lease Rental Reven ue C entury Center 199 4 2001/201 1 20 18 40 7 2/1 8/1--6,825,00 0.00 720,000.00 4 75,000.00 16,875.00 0.00 245,000.00 491,87 5.00 8 College Foot ball H all of Fame H al l of Fame 199 4 2000/201 1 20 18 31 3 2/1 8/1--15,370,00 0.00 1,830,000.00 1,2 15,000.00 53,407.50 0.00 615,000.00 1,268,40 7.50 1 1 Sout h B end Building C orporation Mor ris P AC 199 8 200 9 20 17 40 8 2/1 8/1--13,300,00 0.00 515,000.00 5 15,000.00 10,300.00 0.00 0.00 525,30 0.00 1 2 TJX Sp eci al Taxing D is t rict 200 2 201 4 20 22 32 4/40 4/414 1/1 7/1--6,620,00 0.00 2,210,000.00 4 15,000.00 66,300.00 0.00 1,795,000.00 481,30 0.00 5 Downt own Centr al Area T IF 200 3 201 1 20 24 42 0 2/1 8/1--19,795,00 0.00 12,500,000.00 1,3 15,000.00 598,625.00 0.00 11,185,000.00 1,913,62 5.00 6 Airport Development Are a TIF Airport TIF 200 3 201 1 20 24 32 4 2/1 8/1--14,420,00 0.00 7,125,000.00 7 50,000.00 341,210.50 0.00 6,375,000.00 1,091,21 0.50 2 2 Erskin e V illage TIF Development Bond Er s ki ne Vil la ge 200 5 20 27 43 2 2/1 8/1--5,485,00 0.00 3,800,000.00 3,8 00,000.00 161,666.72 0.00 0.00 3,961,66 6.72 5 4 L ease Ren t al R evenu e B onds of 200 8 Eddy S t reet Co mmons 200 8 20 27 42 9 2/15 8/15--36,000,00 0.00 30,075,000.00 1,3 15,000.00 1,148,181.26 0.00 28,760,000.00 2,463,18 1.26 8 1 Coveles k i Stadi um Reco v ery C oveleski S tadium 201 0 20 19 37 7 1/15 7/15--4,980,00 0.00 1,665,000.00 6 50,000.00 77,155.00 0.00 1,015,000.00 727,15 5.00 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 200,000.00 1 00,000.00 0.00 0.00 100,000.00 100,00 0.00 13 5 2 015 Redevelopm ent Smar t St reets Smarts Stre ets 201 5 20 37 32 4 2/1 8/1 25,000,00 0.00 25,000,000.00 4 60,000.00 394,784.38 0.00 24,540,000.00 854,78 4.38 xxx Total Bond Debt 1 53,788,78 8.00 85,640,000.00 11,0 10,000.00 2,868,505.36 0.00 74,630,000.00 13,878,50 5.36 Loa ns Payab le 3 In di ana Development Finance Autho rity Bos c h P roperty (Nonforgive)200 1 20 21 21 0 3/22 6/22 9/22 12/22 1,040,00 0.00 302,069.15 63,660.08 8,350.36 0.00 238,409.07 72,01 0.44 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 83,482.06 0.00 0.00 0.00 65,888.51 0.00 6 4 In terfu nd F und 412 - Major Mov es D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,040,31 9.00 323,005.00 3 22,201.00 12,088.00 0.00 804.00 334,28 9.00 8 4 In terfu nd F und 412 - Major Mov es Trian gle Development 201 1 20 29 43 6 2/15 8/15--2,000,00 0.00 1,329,573.43 94,621.29 26,120.71 0.00 1,234,952.14 120,74 2.00 8 5 In terfu nd F und 412 - Major Mov es Eddy S t reet Co mmons 201 1 20 26 43 6 2/15 8/15--4,100,00 0.00 2,384,347.86 6 61,383.84 111,052.16 0.00 1,722,964.02 772,43 6.00 8 6 In terfu nd F und 209 to Air port 324 Pr airie Ave Brownf ie ld Project 201 1 20 20 32 4 8/9---500,00 0.00 400,000.00 1 00,000.00 0.00 0.00 300,000.00 100,00 0.00 14 2 In terfu nd F und 412 - Major Mov es Parking Garage Improve ments 201 6 20 22 60 1 6/1 12/1 1,500,00 0.00 517,304.69 2 29,174.05 20,825.95 7 50,0 00.00 1,038,130.64 250,00 0.00 xxx Total Loans Pa yable 15,627,49 9.06 5,339,782.19 1,4 71,040.26 178,437.18 7 50,0 00.00 4,601,148.38 1,649,47 7.44 Ca pita l Lease xxx T otal Cap ital L ease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leas es 1 3 Tran s po Lea s e Main / C ol fax Gar age 200 6 20 25 32 4 3/15 9/15--2,510,27 8.00 1,435,338.00 1 29,838.00 70,162.00 0.00 1,305,500.00 200,00 0.00 xxx Tot al Lease 5,510,27 8.00 1,435,338.00 1 29,838.00 70,162.00 0.00 1,305,500.00 200,00 0.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 92,415,120.19 12,6 10,878.26 3,117,104.54 7 50,0 00.00 80,536,648.38 15,727,98 2.80 To tal Debt 4 72,771,68 0.52 239,919,688.58 29,0 67,744.71 7,149,218.74 3,6 82,2 02.09 211,600,052.41 36,216,96 3.45 2 0 1 7-06 Finan cial Report - Debt Page 1 9 o f 25 City of South Bend Period Ending:June 30, 2017 Monthly Debt Schedule` Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at YT D Principa l Y TD Interes t YT D Debt a t D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Pay ments Ad ditions 6/3 0/2017 Civil City Debt Bond Deb t A mort s ch # 3 1 CEDIT Bond 199 7 200 6 20 17 40 8 2/1 8/1--11,870,00 0.00 430,000.00 4 30,000.00 9,932.50 0.00 0.00 3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 2,755,000.00 2 85,000.00 50,313.00 0.00 2,470,000.00 2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 7/1 12/3 1--5,975,00 0.00 2,380,000.00 0.00 0.00 0.00 2,380,000.00 3 9 Sout h B end Building C orporation Fire HQ / P ol ice H Q 200 3 201 2 20 23 40 4/324 2/1 8/1--21,335,00 0.00 8,885,000.00 6 20,000.00 164,730.00 0.00 8,265,000.00 2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 7/1 12/3 1--4,710,00 0.00 0.00 0.00 0.00 0.00 0.00 6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 32 4 4/1 11/1--4,655,00 0.00 3,175,000.00 0.00 197,500.00 0.00 3,175,000.00 6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 7/1 12/3 1--5,380,00 0.00 4,325,000.00 0.00 0.00 0.00 4,325,000.00 7 0 Sewage W orks Reve nue Bon ds - 2009 Sewag e W orks 200 9 20 28 64 9 6/1 12/1--3,297,00 0.00 2,249,643.00 0.00 31,607.00 0.00 2,249,643.00 8 0 2 010 Sewage W orks Re v enue Bonds Sewag e W orks 201 0 20 30 64 9 6/1 12/1--9,345,00 0.00 7,145,000.00 0.00 149,308.75 0.00 7,145,000.00 9 3 Sewage W orks Reve nue Bon ds 201 1 Sewag e W orks 201 1 20 31 64 9 6/1 12/1--21,500,00 0.00 17,295,000.00 0.00 327,150.00 0.00 17,295,000.00 9 9 2 012 W ater Wo rks Reven ue Bond W ater W orks 201 2 20 33 62 5 1/1 7/1--8,300,00 0.00 6,925,000.00 0.00 0.00 0.00 6,925,000.00 10 1 2 012 Sewage W orks Re v enue Bonds Sewag e W orks 201 2 20 32 64 9 6/1 12/1--25,000,00 0.00 20,890,000.00 0.00 243,340.00 0.00 20,890,000.00 10 5 2 013A Sewer Bon d Refunding Sewag e W orks 201 3 201 3 20 24 64 9 6/1 12/1--14,765,00 0.00 8,050,000.00 0.00 78,085.00 0.00 8,050,000.00 11 6 2 013 Building C orporation EMS / Fire D epar t ment 201 3 20 33 28 8 2/1 8/1--5,580,00 0.00 5,145,000.00 2 25,000.00 90,427.50 0.00 4,920,000.00 13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly---2,657,69 6.50 2,386,507.92 43,061.16 23,643.12 0.00 2,343,446.76 13 9 Cen tury Center En ergy Saving s Impro v ements C entury Ctr.201 5 20 31 67 2 5/1 11/1--4,167,89 7.00 4,145,312.00 22,585.00 72,542.96 0.00 4,122,727.00 14 1 Park s and Rec Bo nd Parks Improveme nts 201 5 20 35 40 8 2/1 8/1--5,605,00 0.00 5,295,000.00 1 10,000.00 88,566.00 0.00 5,185,000.00 14 5 Sewage W orks Reve nue Bon ds - 2015 Sewer B ond Improvements 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 24,965,000.00 0.00 249,650.00 0.00 24,965,000.00 15 6 2 016 W ater Wo rks Refu nding Bon ds R efunding 20 00 / 2 006 SRF 201 6 20 27 62 5 1/1 7/1--3,300,00 0.00 3,300,000.00 0.00 0.00 0.00 3,300,000.00 xxx Total Bond Debt 2 34,877,59 3.50 129,741,462.92 1,7 35,646.16 1,776,795.83 0.00 128,005,816.76 Loa ns Payab le 6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 7/1 12/3 1--427,33 2.00 332,562.00 0.00 0.00 0.00 332,562.00 8 2 In terfu nd Loan 41 0 - UDAG 1st Sour c e/Marriott Garage 201 0 20 15 41 0 6/15 12/1 5--2,700,00 0.00 1,351,597.75 94,328.75 0.00 0.00 1,257,269.00 2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 7/1 12/3 1--2,600,00 0.00 0.00 0.00 0.00 0.00 0.00 xxx Amy Shirk Total Loans Pa yable 29,822,33 2.00 1,684,159.75 94,328.75 0.00 0.00 1,589,831.00 Ca pita l Leases 5 1 Ch ase LE D Equipmen t 200 7 20 17 10 1 1/1 7/1--1,531,57 3.00 194,320.02 96,131.38 4,158.45 0.00 98,188.64 8 9 Sun Trust Police, Parks, Bl dg vehicles 201 1 20 16 40 4/20 1/600 3/15 6/15 9/15 12/15 2,068,20 2.00 0.00 0.00 0.00 0.00 0.00 9 0 Cap ital One Public Fundin g Solid Was te Cont ai ners/Truc k s 201 1 20 16 61 1 3/15 6/15 9/15 12/15 207,43 2.00 0.00 0.00 0.00 0.00 0.00 9 1 GE Cap ital I nfor mation Techn ology Police Dept Copier 201 1 20 16 10 1 1/11 4/11 7/11 10/11 3,83 6.00 0.00 0.00 0.00 0.00 0.00 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 0.00 0.00 0.00 0.00 0.00 9 4 Iko n Office Solu t ions Mayor Ric oh M P 2851 SP Copier 201 1 20 16 10 1 2/15 5/15 8/15 11/15 2,56 9.53 0.00 0.00 0.00 0.00 0.00 9 5 Sun Trust E quipme nt F in ance Parks-Golf C ars Lease 201 2 20 16 20 1 4/15 10/1 5--344,50 0.00 0.00 0.00 0.00 0.00 0.00 9 7 Sun Trust E quipme nt F in ance Police Veh ic le s & Equ ipment 201 2 20 17 40 6 5/15 11/1 5--1,295,00 0.00 134,585.22 0.00 0.00 0.00 134,585.22 9 8 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/640 5/15 11/1 5--945,67 4.38 97,793.51 0.00 0.00 0.00 97,793.51 10 0 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/600/288 1/15 7/15--2,806,05 4.00 575,316.55 2 86,723.17 3,752.50 0.00 288,593.38 10 2 Iko n Office Solu t ions / Ricoh W astewater C opier 201 2 20 17 64 1 Monthly 1st--5,74 4.95 756.77 647.14 13.82 0.00 109.63 10 3 GE Cap ital I nfor mation Techn ology Fire Department Cop ie r 201 2 20 17 10 1 2/28 5/28 8/28 11/28 5,47 1.01 926.68 612.62 22.78 0.00 314.06 10 6 Ricoh U SA C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 815.82 403.66 16.22 0.00 412.16 10 7 Ricoh U SA Street/Sewer Dept Copier 201 3 20 18 20 2/641 3/4 6/4 9/4 12/4 5,55 9.15 1,225.93 604.12 31.28 0.00 621.81 10 8 Ricoh U SA C ity Att orney C opier 201 3 20 18 10 1 2/12 5/12 8/12 11/12 5,55 9.15 1,232.73 609.98 25.42 0.00 622.75 10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 3/21 6/21 9/21 12/21 16,12 9.94 3,575.09 1,769.96 90.82 0.00 1,805.13 11 0 PNC Equipm ent F inance Vehi c le/Equipmen t Lease 201 3 20 18 10 1/20 2/406/641 1/15 7/15--1,689,66 9.59 689,257.88 1 70,745.79 4,204.47 0.00 518,512.09 11 1 Ricoh U SA En gi neer in g P l otter/Scan ner 201 3 20 18 10 1 3/3 6/3 9/3 12/3 10,66 7.67 2,459.26 1,202.98 93.02 0.00 1,256.28 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly--4,09 3.64 1,491.77 433.22 36.28 0.00 1,058.55 11 3 Sun Trust E quipme nt F in ance Police and PW vehicles 201 3 20 18 40 4/65 5/611/202 4/24 10/2 4--1,506,46 5.26 616,891.89 1 52,401.70 4,888.87 0.00 464,490.19 11 4 Ricoh U SA Admi n & Fina nce Copier 201 3 20 18 10 1 1/16 4/16 7/16 10/16 11,24 7.97 3,079.36 1,204.75 80.79 0.00 1,874.61 11 7 Police Dept. R ecord D iv. R icoh Police Rec ords Co pi er 201 3 20 18 10 1 Monthly 3rd--9,67 8.26 4,194.14 1,005.55 104.45 0.00 3,188.59 11 8 Wat er Works Main R i c oh Copier W ater W orks M ain Ricoh Co pi er 201 3 20 18 62 0 Monthly 10th--5,64 7.50 2,448.11 586.67 61.03 0.00 1,861.44 11 9 Wat er Works Colfax Ricoh C opier W ater W orks Colfa x R ico h Copier 201 3 20 18 62 0 Monthly 16th--4,73 2.65 2,051.62 491.62 51.14 0.00 1,560.00 12 0 Wat er Works Oliv e Ricoh Copier W ater W orks Olive Ricoh C opier 201 3 20 18 62 0 Monthly 10th--4,73 2.65 2,051.62 491.62 51.14 0.00 1,560.00 12 3 Police T raining D ept. Ricoh C opier Tra in i ng Copier 201 4 20 19 10 1 Monthly 30th--4,26 3.00 2,076.44 438.91 53.09 0.00 1,637.53 12 4 Key Go v ernment Fi nance 2014 Ci ty V ehicles 201 4 20 19 various 4/1 10/1--1,959,48 5.95 1,193,797.05 1 95,145.63 9,252.64 0.00 998,651.42 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 63,525.63 16,133.25 1,278.93 0.00 47,392.38 12 6 HP Computer Lease #2 C omputer Equipment Le ase 201 4 20 18 20 1 and 620 Monthly 8th--4,00 0.00 1,947.01 469.70 40.54 0.00 1,477.31 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 2,795.30 699.52 48.50 0.00 2,095.78 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 1,917.99 436.32 42.24 0.00 1,481.67 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 706.05 156.22 12.20 0.00 549.83 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 3,302.32 528.40 86.42 0.00 2,773.92 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 4,876.99 889.61 126.31 0.00 3,987.38 13 2 Organic Resources & Was tewater R icoh US A C opiers 201 4 20 19 64 1 Monthly 21s t--12,26 0.18 6,558.16 1,239.16 169.34 0.00 5,319.00 13 4 Wat er Works Copier - Nort h S tation R icho US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 2,132.25 489.37 53.39 0.00 1,642.88 13 6 HP Computer Lease #8 C omputer Equipment Le ase 201 5 20 19 40 4/20 1/611 Monthly 16th--19,60 3.94 11,854.14 2,240.70 275.58 0.00 9,613.44 13 7 Anima l Control Ricoh Copier R icoh US A C opiers 201 5 20 20 60 0 Monthly 30th--5,26 1.50 3,591.88 509.15 98.77 0.00 3,082.73 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 94,710.62 15,261.88 2,190.32 0.00 79,448.74 14 0 Vehicle & Equip. Lease Vehi c le/Equipmen t Lease 201 5 20 20 Various 1/15 7/15--3,425,27 3.58 2,763,845.35 3 37,194.29 19,138.39 0.00 2,426,651.06 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly 3,04 0.00 2,161.06 343.86 46.86 0.00 1,817.20 14 4 PNC Vehicle Lease No. 2 Vehi c le Lease Pu rchase 201 5 20 20 various 5/15 11/1 5--1,267,18 3.00 1,021,855.36 1 24,310.54 7,886.90 0.00 897,544.82 14 6 Park s & Rec reation Copier R icoh Copier 201 6 20 20 20 1 Monthly 4,30 2.06 3,454.72 399.25 94.07 0.00 3,055.47 14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly---32,52 5.00 28,667.19 2,983.61 724.27 0.00 25,683.58 14 8 Cen tral Services Lanier C opier C 6502 201 6 20 20 22 2 Monthly---11,41 3.00 10,059.31 1,046.94 254.16 0.00 9,012.37 14 9 Vehicle & Equip. Lease Pu bl ic W orks Vehicles Lease 201 6 20 21 various 2/15 8/15 3,339,83 0.00 3,016,484.17 3 24,595.10 24,101.71 0.00 2,691,889.07 15 0 HP Computer Lease C omputer Leas e- Ref resh 201 6 20 20 40 4/64 1/620 Monthly---17,43 9.85 14,013.99 1,931.57 310.03 0.00 12,082.42 15 1 Admin and Finance R ic oh Copier MPC800 2S P Copier 201 6 20 21 10 1 Monthly---10,92 3.63 8,938.27 1,008.94 243.68 0.00 7,929.33 15 2 PNC Vehicle / Equ ip Lease N o. 2 Vehi c le / E quipment Lea s e 201 6 20 21 various 1/14 7/14--3,992,54 8.72 3,992,548.72 3 81,193.11 35,495.05 0.00 3,611,355.61 15 3 PNC Vehicle / Equ ip Lease Amend 1 Parks and R ecreat io n 201 6 20 12 20 1 1/17 7/17--78,80 8.00 78,808.00 7,614.67 599.73 0.00 71,193.33 15 4 PNC Vehicle / Equ ip Lease N o. 3 Parks & Rec / IT 201 6 20 21 20 1/279 4/19 10/1 9--1,256,09 6.99 1,256,096.99 1 21,761.99 9,042.29 0.00 1,134,335.00 15 5 HP Computer Lease No. 13 C omputer Equipment Le ase 201 6 20 20 various Monthly---156,02 9.30 150,562.73 16,579.00 3,511.82 0.00 133,983.73 15 7 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly---3,18 4.06 3,184.06 629.52 281.20 0.00 2,554.54 15 8 Public Fi nance.c om Inc 2017 V ehicle Lea s e No. 1 201 7 20 22 various 1/14 7/14--2,916,50 0.00 0.00 0.00 0.00 2,9 16,5 00.00 2,916,500.00 15 9 M ayor/W aste Wate r/Fir e Ricoh 2017 Ri c oh Copier Leas e 201 7 20 21 10 1/64 1/287 Monthly---15,70 2.09 0.00 1,518.32 358.08 15,7 02.09 14,183.77 xxx T otal Cap ital L ease 33,145,18 9.96 16,078,945.72 2,2 73,814.46 133,498.99 2,9 32,2 02.09 16,737,333.35 To tal Civ i l C i ty 2 97,845,11 5.46 147,504,568.39 4,1 03,789.37 1,910,294.82 2,9 32,2 02.09 146,332,981.11 2 0 1 7-06 Finan cial Report - Debt Page 2 0 o f 25 City of South Bend Period Ending:June 30, 2017 Monthly Debt Schedule` Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at YT D Principa l Y TD Interes t YT D Debt a t D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Pay ments Ad ditions 6/3 0/2017 Re dev elopment C ommis sion Debt Bond Deb t 7 Cen tury Center Lease Rental Reven ue C entury Center 199 4 2001/201 1 20 18 40 7 2/1 8/1--6,825,00 0.00 720,000.00 2 35,000.00 10,200.00 0.00 485,000.00 8 College Foot ball H all of Fame H al l of Fame 199 4 2000/201 1 20 18 31 3 2/1 8/1--15,370,00 0.00 1,830,000.00 6 00,000.00 31,728.75 0.00 1,230,000.00 1 1 Sout h B end Building C orporation Mor ris P AC 199 8 200 9 20 17 40 8 2/1 8/1--13,300,00 0.00 515,000.00 5 15,000.00 10,300.00 0.00 0.00 1 2 TJX Sp eci al Taxing D is t rict 200 2 201 4 20 22 32 4/40 4/414 1/1 7/1--6,620,00 0.00 2,210,000.00 0.00 0.00 0.00 2,210,000.00 5 Downt own Centr al Area T IF 200 3 201 1 20 24 42 0 2/1 8/1--19,795,00 0.00 12,500,000.00 6 50,000.00 306,755.00 0.00 11,850,000.00 6 Airport Development Are a TIF Airport TIF 200 3 201 1 20 24 32 4 2/1 8/1--14,420,00 0.00 7,125,000.00 3 70,000.00 174,841.75 0.00 6,755,000.00 2 2 Erskin e V illage TIF Development Bond Er s ki ne Vil la ge 200 5 20 27 43 2 2/1 8/1--5,485,00 0.00 3,800,000.00 2 50,000.00 123,667.50 0.00 3,550,000.00 5 4 L ease Ren t al R evenu e B onds of 200 8 Eddy S t reet Co mmons 200 8 20 27 42 9 2/15 8/15--36,000,00 0.00 30,075,000.00 6 55,000.00 579,003.13 0.00 29,420,000.00 8 1 Coveles k i Stadi um Reco v ery C oveleski S tadium 201 0 20 19 37 7 1/15 7/15--4,980,00 0.00 1,665,000.00 3 25,000.00 42,640.00 0.00 1,340,000.00 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 200,000.00 0.00 0.00 0.00 200,000.00 13 5 2 015 Redevelopm ent Smar t St reets Smart Stre ets 201 5 20 37 32 4 2/1 8/1 25,000,00 0.00 25,000,000.00 0.00 394,784.38 0.00 25,000,000.00 xxx Total Bond Debt 1 53,788,78 8.00 85,640,000.00 3,6 00,000.00 1,673,920.51 0.00 82,040,000.00 Loa ns Payab le 3 In di ana Development Finance Autho rity Bos c h P roperty (Nonforgive)200 1 20 21 21 0 3/22 6/22 9/22 12/22 1,040,00 0.00 302,069.15 31,592.21 4,413.01 0.00 270,476.94 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 83,482.06 0.00 0.00 0.00 66,406.56 6 4 In terfu nd F und 412 - Major Mov es D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,040,31 9.00 323,005.00 1 41,925.00 8,075.00 0.00 181,080.00 8 4 In terfu nd F und 412 - Major Mov es Trian gle Development 201 1 20 29 43 6 2/15 8/15--2,000,00 0.00 1,329,573.43 47,075.27 13,295.73 0.00 1,282,498.16 8 5 In terfu nd F und 412 - Major Mov es Eddy S t reet Co mmons 201 1 20 26 43 6 2/15 8/15--4,100,00 0.00 2,384,347.86 3 26,609.30 59,608.70 0.00 2,057,738.56 8 6 In terfu nd F und 209 to Air port 324 Pr airie Ave Brownf ie ld Project 201 1 20 20 32 4 8/9---500,00 0.00 400,000.00 0.00 0.00 0.00 400,000.00 14 2 In terfu nd F und 412 - Major Mov es Parking Garage Improve ments 201 6 20 22 60 1 6/1 12/1--1,500,00 0.00 517,304.69 0.00 0.00 7 50,0 00.00 1,267,304.69 xxx Total Loans Pa yable 15,627,49 9.06 5,339,782.19 5 47,201.78 85,392.44 7 50,0 00.00 5,525,504.91 Ca pita l Lease xxx T otal Cap ital L ease 0.00 0.00 0.00 0.00 0.00 0.00 Leas es 1 3 Tran s po Lea s e Main / C ol fax Gar age 200 6 20 25 32 4 3/15 9/15--2,510,27 8.00 1,435,338.00 64,117.00 35,883.00 0.00 1,371,221.00 xxx Tot al Lease 5,510,27 8.00 1,435,338.00 64,117.00 35,883.00 0.00 1,371,221.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 92,415,120.19 4,2 11,318.78 1,795,195.95 7 50,0 00.00 88,936,725.91 To tal Debt 4 72,771,68 0.52 239,919,688.58 8,3 15,108.15 3,705,490.77 3,6 82,2 02.09 235,269,707.02 2 0 1 7-06 Finan cial Report - Debt Page 2 1 o f 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,112 1,080 1,069 1,082 1,078 1,076 1,093 - 0 0 0 0 0 Part Time Staff 115 119 142 155 168 145 0 0 0 0 0 0 Temporary / Seasonal 12 11 13 41 86 206 0 0 0 0 0 0 City Total 1,207 1,199 1,237 1,274 1,330 1,444 - 0 0 0 0 0 2017-06 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 0 0 0 0 0 0 311 Call Center 6 6 6 6 7 7 6 0 0 0 0 0 0 Admin & Finance 23 20 21 22 23 23 23 0 0 0 0 0 0 Innovation/ Technology Office 18 14 14 15 14 16 17 0 0 0 0 0 0 Safety & Risk 2 2 2 2 2 2 2 0 0 0 0 0 0 Clerk 5 5 5 5 5 5 5 0 0 0 0 0 0 Common Council 9 9 9 9 9 9 9 0 0 0 0 0 0 Legal Department 10 11 11 10 10 10 10 0 0 0 0 0 0 Sub Total 80 73 74 75 75 78 80 0 0 0 0 0 0 Code Enf. /Animal Control 25 20 22 24 24 25 25 0 0 0 0 0 0 Dept. of Community Investment 23 22 20 21 21 20 20 0 0 0 0 0 0 Parks & Recreation Administration 6 6 6 6 6 6 6 0 0 0 0 0 0 Maintenance 46 45 47 48 47 47 48 0 0 0 0 0 0 Golf Operations 8 7 8 7 8 8 8 0 0 0 0 0 0 Recreation Ops 25 22 21 21 21 21 22 0 0 0 0 0 0 Zoological Ops 1 1 1 1 1 1 1 0 0 0 0 0 0 Graffiti Removal 1 1 1 1 1 1 1 0 0 0 0 0 0 Recreation Non-reverting 1 1 1 1 1 1 0 0 0 0 0 0 0 Marketing and Events 10 8 10 10 10 10 10 0 0 0 0 0 0 Sub Total 98 91 95 95 95 95 96 0 0 0 0 0 0 Public Safety Police 289 284 272 282 280 278 288 0 0 0 0 0 0 Fire 264 268 267 266 263 261 259 0 0 0 0 0 0 Sub Total 553 552 539 548 543 539 547 0 0 0 0 0 0 Public Works Central Services 37 35 36 35 34 35 36 0 0 0 0 0 0 Office of Sustainability 2 2 2 2 2 2 2 0 0 0 0 0 0 Engineering 18 18 18 20 20 20 20 0 0 0 0 0 0 Maintenance 3 3 3 2 3 3 3 0 0 0 0 0 0 Solid Waste Operations 26 25 25 26 25 24 25 0 0 0 0 0 0 Unsafe Bldg Code Clean Crew 4 4 4 4 4 4 3 0 0 0 0 0 0 Street Operations 55 54 54 54 54 53 56 0 0 0 0 0 0 Sewer Operations 37 37 37 37 37 35 37 0 0 0 0 0 0 Waste Water Ops 45 45 45 44 44 45 45 0 0 0 0 0 0 Organic Resources 6 6 5 5 6 6 6 0 0 0 0 0 0 Water Utility Ops 71 64 63 63 63 64 65 0 0 0 0 0 0 Sub Total 304 293 292 292 292 291 298 0 0 0 0 0 0 Building Department 14 14 14 14 14 14 14 0 0 0 0 0 0 Human Rights 6 6 6 6 6 6 5 0 0 0 0 0 0 Morris & Palais 9 9 7 7 8 8 8 0 0 0 0 0 0 City Total 1,112 1,080 1,069 1,082 1,078 1,076 1,093 - - - - - - 2017-06 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 0 0 0 0 0 0 Admin & Finance 0 0 0 0 0 0 0 0 0 0 0 0 Safety and Risk 0 0 0 0 0 0 0 0 0 0 0 0 Innovation/ Technology Office 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal Department 1 1 1 1 1 1 0 0 0 0 0 0 Sub Total 5 4 4 2 2 3 0 0 0 0 0 0 Code Enf. / Animal Control 3 2 3 3 3 4 0 0 0 0 0 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 1 1 1 1 1 1 0 0 0 0 0 0 Maintenance 11 11 11 15 14 13 0 0 0 0 0 0 Golf Operations 2 0 18 41 54 54 0 0 0 0 0 0 Recreation Ops 46 54 54 46 48 42 0 0 0 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 4 4 4 1 1 0 0 0 0 0 0 0 Marketing & Events 1 1 1 1 1 1 0 0 0 0 0 0 Sub Total 65 70 88 104 118 110 0 0 0 0 0 0 Public Safety Police 25 25 29 27 27 10 0 0 0 0 0 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 1 0 0 0 0 0 0 Sub Total 25 25 29 27 27 11 0 0 0 0 0 0 Public Works` Central Services 1 1 1 1 1 1 0 0 0 0 0 0 Engineering 2 2 2 3 2 2 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 7 8 9 9 9 7 0 0 0 0 0 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 3 3 2 2 2 3 0 0 0 0 0 0 Sub Total 13 14 14 15 14 13 0 0 0 0 0 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 4 4 4 4 4 4 0 0 0 0 0 0 City Total 115 119 142 155 168 145 0 0 0 0 0 0 2017-06 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 0 0 0 0 0 0 Admin & Finance 1 1 0 0 1 1 0 0 0 0 0 0 Safety and Risk 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 2 1 0 0 1 1 0 0 0 0 0 0 Code Enfor. / Animal 1 1 1 1 1 0 0 0 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 0 0 0 0 0 0 Maintenance 1 1 2 12 29 36 0 0 0 0 0 0 Golf Operations 0 0 1 1 2 3 0 0 0 0 0 0 Recreation Ops 3 2 2 15 40 129 0 0 0 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 4 3 5 28 71 168 0 0 0 0 0 0 Public Safety Police 0 0 0 0 0 14 0 0 0 0 0 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 0 0 0 0 0 14 0 0 0 0 0 0 Public Works Central Services 0 0 0 0 0 1 0 0 0 0 0 0 Engineering 3 4 4 4 1 7 0 0 0 0 0 0 Energy / Sustainability 0 0 0 0 0 0 0 0 0 0 0 0 Traffic & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Ops 0 0 0 0 0 0 0 0 0 0 0 0 Street Ops 1 1 1 7 9 8 0 0 0 0 0 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Leaf Pickup 0 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 0 0 1 0 1 2 0 0 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 0 0 0 0 0 0 Sub Total 4 5 6 11 13 23 0 0 0 0 0 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 1 1 1 1 0 0 0 0 0 0 0 0 City Total 12 11 13 41 86 206 0 0 0 0 0 0 2017-06 Financial Report - Headcount Staffing Page 25 of 25