Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017-05 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 May 31, 2017 Controller 2017-05 Financial Report Page 1 of 25 May 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 120% 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 May 2017,the City has spent 33%of budgeted expenditures,compared to 29%in May 2016.The General Fund has spent 36%of its 2017 budgeted expenditures,compared to 37%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~$170,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 May was 1,076 vs.a budgeted amount of 1,112.Currently,there are a total of 36 vacant positions.The 36 open positions are in the following departments:General Government(2),Parks(3),Public Safety(14),Public Works(13),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 30%,similar to May 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 May 2017,the general fund has reached 10%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 in 2016 totaled~$76.7 million.Civil city funds received ~$49.1 million and TIF funds received~$27.6 million.For 2016,the projected levy collection rate is 95%or$75.2 million.Please note, 2016 civil city funds are ~$2.4 million more than 2015 budget. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. 2017-05 Financial Report Page 2 of 25 City of South Bend Period Ending:May 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- - - - - - - - - - - - 48,373,228 0% 311 Property Tax TIF Districts various- - - - - - - - - - - - 27,254,124 0% Sub Total- - - - - - - - - - - - - 75,627,352 0% Income Tax 315 Econ Development Income Tax 408 883,344 883,344 866,667 866,667 866,667 - - - - - - - 4,366,689 10,433,361 42% 316 Local Option Income Tax - PS 249 622,302 622,302 622,302 622,302 622,302 - - - - - - - 3,111,508 7,467,618 42% 316 County Option Income Tax 404 871,605 871,605 871,605 871,605 871,605 - - - - - - - 4,358,027 10,459,265 42% Sub Total 2,377,250 2,377,250 2,360,574 2,360,574 2,360,574 - - - - - - - 11,836,224 28,360,244 42% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - - - - - - - - - 3,206,500 0% 312 Commercial Vehicle Tax various- - - - - - - - - - - - - 843,000 0% 317 Hotel Motel Tax Century Center 670 637,500 - (318,750) 106,250 106,250 - - - - - - - 531,250 1,275,000 42% 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 - - - - - - - 878,750 5,868,500 15% State of Indiana (Remitted by) 335 Cigarette Tax 101/407- - - - - - - - - - - - - 328,000 0% 335 State Pension Subsidy 701/702- - - - - - - - - - - - - 11,342,638 0% 335 Gaming Proceeds 101- - - - - - - - - - - - - 599,000 0% 335 Gasoline Tax 202/251 361,601 314,230 394,563 456,411 426,999 - - - - - - - 1,953,804 4,668,000 42% 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 - - - - - - - 3,283,474 19,972,638 16% 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 - - - - - - - 3,294,309 7,623,328 43% 339 Contractual Service 211 9,669 12,407 38,314 17,294 7,957 - - - - - - - 85,639 316,000 27% Sub Total 537,143 886,481 555,675 888,436 527,215 - - - - - - - 3,394,950 8,004,328 42% Charge for Service Internal City 340 Liability Insurance 226 243,168 243,964 241,179 246,749 241,179 - - - - - - - 1,216,239 2,927,591 42% 340 General Government Misc Chgs 101/289- - - - - - - - - - - - - 500 0% 349 Central Service 222 51,820 48,684 51,854 49,741 49,575 - - - - - - - 251,674 873,809 29% 380 Central Service 222 210,212 208,994 226,075 189,251 209,433 - - - - - - - 1,043,965 2,880,310 36% 380 Energy Office Reimbursements 222 411,202 429,754 368,989 361,064 360,950 - - - - - - - 1,931,959 4,492,800 43% 380 LOIT 2016 Special Distribution 257- - 152,895 - - - - - - - - - 152,895 153,000 100% 380 IT Innovation 311 Center 279 430,621 430,621 430,621 430,621 430,621 - - - - - - - 2,153,105 5,205,034 41% 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 - - - - - - - 363,239 1,423,071 26% 392 Administration Fee 101/279 414,748 414,748 414,748 414,748 414,748 - - - - - - - 2,073,740 4,977,026 42% 392 Internal Fund Transfers various 1,085,348 9,754,150 4,553,299 4,585,904 1,649,180 - - - - - - - 21,627,881 41,710,246 52% 395 Employee Benefits 711/713 1,499,317 1,460,178 1,492,929 1,487,450 1,477,818 - - - - - - - 7,417,692 17,836,850 42% 2017-05 Fin anc i al Re port - Rev enue Report Page 3 of 25 City of South Bend Period Ending:May 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 - - - - - - - 9,617 21,000 46% 396 Self Funded Employee Benefits 711 6,503 (2,436) 496 - - - - - - - - - 4,563 4,563 100% xxx xxx xxx- NA Sub Total 4,420,045 13,078,521 8,297,481 7,786,534 4,947,418 - - - - - - - 38,529,999 86,889,232 44% 3rd Party Revenue 340 ND EMS Service 288- - 44,904 - 1,338 - - - - - - - 46,242 150,000 31% 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 - - - - - - - 3,617,284 7,035,660 51% Grants 331 Federal Grants various 468,447 1,200,229 111,355 149,580 103,356 - - - - - - - 2,032,968 6,999,973 29% 334 State Grants various- - 33,745 5,150 - - - - - - - - 38,895 20,000 194% Sub Total 468,447 1,200,229 145,100 154,730 103,356 - - - - - - - 2,071,863 7,019,973 30% Fees for Services External 320 Inspections Central Service 222- - - 450 350 - - - - - - - 800 1,450 55% 321 Business License 101/222 30,917 29,318 15,746 12,407 11,383 - - - - - - - 99,771 120,130 83% 321 Code and Animal Fees 600 4,536 4,585 6,015 5,891 6,975 - - - - - - - 28,001 54,500 51% 322 Building Fees 600 90,363 86,593 108,895 95,111 141,205 - - - - - - - 522,166 1,360,350 38% 322 Code Enforcement Fees 600 1,050 300 3,000 1,500 600 - - - - - - - 6,450 20,000 32% 322 EMS Operating Fund 288 1,923 1,380 1,542 910 2,973 - - - - - - - 8,728 24,000 36% 322 General Government Fees 101 32,047 7,275 12,535 6,200 3,925 - - - - - - - 61,982 100,000 62% 341 General Government Various various 3,316 959 5,210 5,841 1,367 - - - - - - - 16,693 27,005 62% 342 Highway & Streets 101/202 38,686 - 16,474 2,320 43,516 - - - - - - - 100,997 223,365 45% 342 Public Safety various 12,869 10,404 21,290 12,093 12,302 - - - - - - - 68,958 150,000 46% 342 EMS - County Fees 288- 294,414 147,207 147,207 147,207 - - - - - - - 736,036 1,740,000 42% 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 - - - - - - - 1,093,648 2,700,000 41% 342 EMS - Neo Natal / Transport 288 16,185 18,553 16,128 14,553 4,909 - - - - - - - 70,328 1,699,512 4% 344 Solid Waste 610 445,203 460,843 468,017 403,574 285,268 - - - - - - - 2,062,905 5,636,175 37% 344 Code Environmental Clean Up 101/219/600 12,404 3,044 22,134 17,648 11,871 - - - - - - - 67,101 180,000 37% 344 Sewage Waste Water 641 3,208,590 3,128,008 3,112,534 3,105,650 3,096,610 - - - - - - - 15,651,392 37,020,404 42% 344 Sewer Repair Insurance 640 53,614 52,952 53,742 52,772 52,682 - - - - - - - 265,761 613,924 43% 344 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 - - - - - - - 406,997 980,000 42% 346 Water Works Utility 620 1,039,872 1,012,523 1,016,299 1,006,997 1,032,846 - - - - - - - 5,108,537 14,590,122 35% 346 Solid Waste Misc 610 1,504 10,324 12,564 40,321 44,124 - - - - - - - 108,836 110,000 99% 346 Project ReLeaf 655 36,802 36,730 36,817 36,854 37,012 - - - - - - - 184,215 440,153 42% 347 Parks & Recreation various 74,837 77,843 366,527 173,383 231,644 - - - - - - - 924,234 4,343,134 21% 347 Sale of Merchandise 101- - - - - - - - - - - - - 100 0% 347 Morris PAC 416- 12,214 13,143 11,334 5,563 - - - - - - - 42,254 100,000 42% 349 Parking Garage Fees 601 115,464 73,834 83,097 119,933 135,473 - - - - - - - 527,800 1,000,629 53% 349 Code Demolition Board Up 219/600 2,805 2,067 13,981 5,115 1,466 - - - - - - - 25,434 90,000 28% 349 Parking Century Center 670 12,814 19,676 20,911 11,526 7,998 - - - - - - - 72,924 100,033 73% 349 Parking SBCDA 324/429 350 700 350 350 350 - - - - - - - 2,100 8,400 25% 351 Fines & Fees various 27,430 36,628 37,210 30,621 38,987 - - - - - - - 170,876 261,820 65% 352 Forfeits various 734 616 3,897 5,014 1,556 - - - - - - - 11,818 200,000 6% 354 Ordinance Violation various 5,163 7,326 9,708 (3,068) 2,333 - - - - - - - 21,462 72,500 30% 360 Morris PAC various 10,087 86,686 184,282 72,560 46,729 - - - - - - - 400,343 976,000 41% 360 Palais Royale various 24,371 4,131 9,256 7,929 19,759 - - - - - - - 65,446 256,572 26% 360 Parks & Recreation various 9,055 4,207 4,552 9,758 3,205 - - - - - - - 30,777 98,206 31% 360 Police various 4,432 3,558 7,482 1,016 759 - - - - - - - 17,247 25,000 69% 360 Fire various- 37,987 - - - - - - - - - - 37,987 - NA 360 TIF various 31,545 2,510 6,859 2,110 2,110 - - - - - - - 45,133 52,725 86% 360 Central Services 222 608 - 50 251 623 - - - - - - - 1,533 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 - - - - - - - 133,681 197,000 68% 360 EMS Operating Fund 288 525 - - - 72 - - - - - - - 597 5,000 12% 360 Engineering / Curb & Sidewalk 101- 50 50 - 125 - - - - - - - 225 11,000 2% 360 Fire and Police Pension Fund 701/702 1,523 675 5,700 565 595 - - - - - - - 9,057 2,000 453% 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 - - - - - - - 3,127 4,896 64% 360 Motor Veh Highway Curb Prgm 202 11 - - 1,366 - - - - - - - - 1,377 32,000 4% 360 Local Roads and Streets 251- 274 - - - - - - - - - - 274 - NA 360 Professional Sports Development 377 17,864 - - - - - - - - - - - 17,864 30,000 60% 2017-05 Fin anc i al Re port - Rev enue Report Page 4 of 25 City of South Bend Period Ending:May 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 - - - - - - - - 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 - - - - - - - - 2,621 2,650 99% 360 Waste Water 641/7/9- 3,437 - 5,103 4,546 - - - - - - - 13,086 52,500 25% 360 Water Works Utility 620- 39 18 2,167 2,237 - - - - - - - 4,461 25,000 18% 360 Sewage Depreciation Fund 642- 400,000 - - - - - - - - - - 400,000 400,000 100% 362 Dept. Of Community Investment 212 1,847 - - 1,847 - - - - - - - - 3,694 - NA 362 Palais Royale 101- 5,114 1,940 1,745 11,426 - - - - - - - 20,225 82,500 25% 362 Police 101- - - 7,238 - - - - - - - - 7,238 48,000 15% 362 Parks & Recreation 201 3,786 3,545 5,828 3,970 6,820 - - - - - - - 23,949 43,500 55% 362 S Bend School Corp Fee 407- - - - - - - - - - - - - 25,000 0% 362 TIF Property various 14,223 24,108 14,479 13,450 6,588 - - - - - - - 72,848 319,603 23% 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 - - - - - - - 1,105,542 2,809,278 39% 399 Bosch Retention Project 210- - 15,737 - - - - - - - - - 15,737 63,661 25% 399 Principal on Loan various 19,897 19,842 19,726 20,742 601 - - - - - - - 80,807 76,374 106% 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 - - - - - - - 33,620,310 85,576,230 39% Interest Income 361 Bank Account Interest various 156,963 166,772 205,325 97,825 95,274 - - - - - - - 722,159 1,719,848 42% Sub Total 156,963 166,772 205,325 97,825 95,274 - - - - - - - 722,159 1,719,848 42% Donations 367 ND Contribution 101- - - - - - - - - - - - - 337,500 0% 367 Donations various 75,816 1,040 70,660 440 25,155 - - - - - - - 173,111 272,250 64% Sub Total 75,816 1,040 70,660 440 25,155 - - - - - - - 173,111 609,750 28% Historic Preservation 368 C.O.I.T.404- - - 500 250 - - - - - - - 750 - 368 Palais 450 1,838 114 345 390 646 - - - - - - - 3,332 16,500 20% Sub Total 1,838 114 345 890 896 - - - - - - - 4,082 16,500 25% 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- - - - - - - - - - - - - 15,000 0% 391 Vehicle Damage Reimbursement various- - - - - - - - - - - - - - NA - Sub Total- 60,000 2 1 61,029 - - - - - - - 121,032 175,331 69% Revenue Total 15,541,356 27,563,049 18,707,970 18,276,109 18,164,753 - - - - - - - 98,253,238 327,588,849 30% report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 - - - - - - - 98,253,238 327,588,849 - 0 (1) 0 (0) - - - - - - - 0 - 2017-05 Fin anc i al Re port - Rev enue Report Page 5 of 25 City of South Bend Period Ending:May 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 - - - - - - - 5,304,438 56,530,002 9% 0101 Mayor 101- - - - - - - - - - - - - 600 0% 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 - - - - - - - 5,354,050 56,618,283 9% Public Works 0602 Engineering 101 32,047 7,275 12,535 6,200 4,050 - - - - - - - 62,107 317,337 20% Sub Total 32,047 7,275 12,535 6,200 4,050 - - - - - - - 62,107 317,337 20% Public Safety 0801 Police 101 34,608 15,151 13,175 13,089 10,980 - - - - - - - 87,005 336,000 26% 0901 Fire 101 4,387 37,987 - - - - - - - - - - 42,373 1,500 2825% Sub Total 38,995 53,138 13,175 13,089 10,980 - - - - - - - 129,378 337,500 38% Code Enforcement xxx xxx- - - - - - - - - - - - - - NA Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 10,888 86,733 183,972 72,872 46,790 - - - - - - - 401,256 965,000 42% 0405 Palais Royale 101 26,265 9,345 13,108 10,025 33,527 - - - - - - - 92,271 358,902 26% xxx xxx- NA Sub Total 37,153 96,078 197,080 82,898 80,317 - - - - - - - 493,527 1,323,902 37% General Fund Revenue Total 1,244,191 1,371,784 1,198,563 1,103,455 1,121,067 - - - - - - - 6,039,062 58,597,022 10% 2017-05 Financial Report - Rev enue Summar y Page 6 of 25 City of South Bend Period Ending:May 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 - - - - - - - 720,448 9,977,007 7% 1100 Administration 201 3,787 3,548 5,830 3,974 7,149 - - - - - - - 24,288 43,600 56% 1101 Maintenance 201 28,074 104,996 4,776 82,975 77,815 - - - - - - - 298,635 1,707,710 17% 1102 Golf Operations 201 1,356 402 152,340 98,890 148,871 - - - - - - - 401,859 1,525,934 26% 1103 Recreation Division 201 22 810 1,346 20 1,410 - - - - - - - 3,608 156,685 2% 1108 Graffiti Removal 201- - - - - - - - - - - - - 96,725 0% 1110 Marketing and Events 201- - - 69 - - - - - - - - 69 570,471 0% Recreation Non Reverting 203 75,681 75,021 213,432 75,516 66,022 - - - - - - - 505,671 1,381,787 37% East Race Waterway 271 1 1 1 1 1 - - - - - - - 4 22 20% Coveleski Stadium 401 68 69 79 38 35 - - - - - - - 289 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 - - - - - - - 57,213 439,850 13% Sub Total 115,792 543,031 381,765 643,382 328,266 - - - - - - - 2,012,235 15,940,891 13% Public Works Motor Vehicle Highway 202 317,873 1,223,876 828,325 1,361,365 833,924 - - - - - - - 4,565,362 9,934,110 46% Central Services 222 675,986 688,080 710,659 544,455 623,794 - - - - - - - 3,242,974 8,308,569 39% Central Services Capital 224 84 72 89 41 35 - - - - - - - 322 287,600 0% Local Roads & Streets 251 106,827 88,499 130,547 93,992 107,567 - - - - - - - 527,432 1,674,275 32% 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 - - - - - - - 187,022 444,556 42% Sub Total 1,138,220 3,037,955 2,707,224 2,037,067 1,602,646 - - - - - - - 10,523,112 22,649,110 46% Public Works Solid Waste Solid Waste Operations 610 445,931 471,682 480,834 494,568 329,577 - - - - - - - 2,222,592 5,799,475 38% Solid Waste Capital 611 179 240 100,039 83,600 20,027 - - - - - - - 204,085 836,313 24% Sub Total 446,110 471,922 580,873 578,168 349,604 - - - - - - - 2,426,677 6,635,788 37% Public Works Water Utility 0000 Water Works Revenues 620 973,972 948,744 947,938 952,254 965,980 - - - - - - - 4,788,888 13,578,036 35% 0630 Water Leak Insurance 620 81,303 81,237 81,371 81,350 81,736 - - - - - - - 406,997 980,000 42% 0660 Clay Water 620 72,507 69,573 74,940 69,858 75,790 - - - - - - - 362,667 1,192,586 30% Waterworks Capital 622 1,942 1,950 2,167 958 875 - - - - - - - 7,893 15,000 53% Waterworks Deposit 624 1,159 1,174 1,347 639 583 - - - - - - - 4,902 15,000 33% Waterworks Sinking 625 164,824 164,289 164,321 164,211 164,266 - - - - - - - 821,912 2,054,891 40% Waterworks Bond Reserve 626 1,154 1,073 1,235 594 548 - - - - - - - 4,604 16,000 29% Waterworks Debt Reserve 629 153,121 1,895 2,292 1,092 1,000 - - - - - - - 159,400 174,500 91% Sub Total 1,449,981 1,269,935 1,275,612 1,270,956 1,290,778 - - - - - - - 6,557,262 18,026,013 36% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,941 54,328 55,305 53,519 53,371 - - - - - - - 271,464 621,788 44% 0000 Wastewater Revenues 641 3,044,674 2,968,092 2,944,636 2,940,827 2,924,257 - - - - - - - 14,822,486 34,932,744 42% 0621 Sewer Department 641- 1,261 - - - - - - - - - - 1,261 2,500 50% 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 - - - - - - - 901,245 2,162,160 42% Sewage Capital 642 5,472 404,555 5,255 444,486 502,267 - - - - - - - 1,362,036 4,887,000 28% Sewage Reserve 643 3,481 3,535 520,820 2,021 1,972 - - - - - - - 531,828 546,755 97% Sewage Bond Sinking 649 763,195 1,184 1,526,979 763,848 764,229 - - - - - - - 3,819,433 9,177,024 42% Sewage Works DS Reserve 653- 955 1,176 1,189 1,579 - - - - - - - 4,900 4,400 111% 2011 Sewer Bond 659 41 39 45 22 7 - - - - - - - 154 - NA 2012 Sewer Bond 661 2,379 2,201 2,530 1,144 984 - - - - - - - 9,239 50,000 18% Sub Total 4,052,047 3,613,922 5,241,923 4,386,109 4,433,084 - - - - - - - 21,727,085 52,458,871 41% 2017-05 Financial Report - Rev enue Summar y Page 7 of 25 City of South Bend Period Ending:May 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 - - - - - - - 15,724 36,000 44% Curfew Violations 218 9 35 24 5 17 - - - - - - - 90 1,000 9% Law Enforcement Education 220 31,608 16,002 30,754 31,643 18,459 - - - - - - - 128,466 221,500 58% Public Safety LOIT 249 622,980 622,745 623,084 622,832 622,663 - - - - - - - 3,114,304 7,473,618 42% Police Take Home Vehicle 278 561 575 660 315 288 - - - - - - - 2,399 4,000 60% Police Block Grant 280 3 3 3 2 1 - - - - - - - 12 50 25% Police Academy 294 5,456 4,561 2,023 886 2,483 - - - - - - - 15,410 22,500 68% COPS More Grants 295 1,055 36,332 946 1,029 10,378 - - - - - - - 49,740 123,500 40% Drug Enforcement 299 149 162 148 166 161 - - - - - - - 785 32,000 2% K-9 Unit 705 2 2 3 1 1 - - - - - - - 9 2,020 0% Sub Total 672,099 683,553 657,845 657,005 656,439 - - - - - - - 3,326,940 7,916,188 42% Public Safety - Fire EMS Capital 287 2,726 1,801,174 3,021 2,108 1,927 - - - - - - - 1,810,957 4,495,349 40% EMS Operating Fund 288 181,987 557,555 483,650 374,307 372,922 - - - - - - - 1,970,421 6,350,012 31% Hazmat 289 19 20 23 11 10 - - - - - - - 84 10,000 1% River Rescue 291 114 16,307 12,724 1,869 23,462 - - - - - - - 54,475 45,500 120% Sub Total 184,846 2,375,057 499,419 378,295 398,322 - - - - - - - 3,835,937 10,900,861 35% Department of Community Investment Studebaker/Oliver 209 25,242 626 34,113 56,725 9,707 - - - - - - - 126,412 422,857 30% State Grant 210 242 268 18,311 148 135 - - - - - - - 19,103 73,512 26% DCI Operating 211 10,748 394,129 39,598 398,624 8,536 - - - - - - - 851,635 2,291,309 37% 0000 Dept. of Community Investment 212 310,284 201,138 42,852 164,474 83,939 - - - - - - - 802,687 3,348,000 24% xxx Programs 212 93,743 - - - - - - - - - - - 93,743 - NA 0000 Economic Revenue Bond 281 21 21 24 12 11 - - - - - - - 88 200 44% Sub Total 440,280 596,182 134,898 619,981 102,326 - - - - - - - 1,893,668 6,135,878 31% 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 - - - - - - - 172,864 268,766 64% 0462 Leighton Plaza 601 58,466 24,331 25,191 82,032 58,385 - - - - - - - 248,404 497,484 50% 0463 Enforcement 601 4,969 4,623 7,202 3,586 4,680 - - - - - - - 25,061 89,500 28% 0464 Wayne Street 601 30,977 20,895 29,889 11,565 12,333 - - - - - - - 105,659 242,161 44% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 120,601 78,453 91,364 123,425 140,159 - - - - - - - 554,001 1,122,911 49% Capital / Debt Service Hall of Fame 313 50 6 23 8 10 - - - - - - - 97 938,528 0% COIT 404 913,313 879,279 1,163,973 920,266 874,964 - - - - - - - 4,751,795 10,963,839 43% Cum Capital Development 406 357 436 410 184 169 - - - - - - - 1,555 476,500 0% Cum Capital Improvement 407 150,266 294 301 144 132 - - - - - - - 151,137 435,000 35% EDIT 408 1,041,459 1,981,678 877,267 871,706 870,753 - - - - - - - 5,642,863 11,733,257 48% UDAG 410 445 416 493 235 207 - - - - - - - 1,796 6,110 29% Major Moves 412 1,774 598,393 2,312 1,238 1,135 - - - - - - - 604,853 1,053,786 57% Morris PAC Improvement 416 436 12,664 13,666 11,585 5,797 - - - - - - - 44,148 104,000 42% Palais Historic Preservation 450 1,907 187 428 429 683 - - - - - - - 3,634 17,100 21% Hall of Fame Capital 677 372 378 431 200 182 - - - - - - - 1,562 5,000 31% SB Building Corp 755- 1,326,786 210 65 117 - - - - - - - 1,327,178 2,643,214 50% Parks Bond Debt Svc 757- 65,162 124 65,236 80 - - - - - - - 130,603 391,482 33% xxx xxx xxx- - - - - - - - - - - NA Sub Total 2,110,380 4,865,679 2,059,637 1,871,297 1,754,228 - - - - - - - 12,661,221 28,767,816 44% 2017-05 Financial Report - Rev enue Summar y Page 8 of 25 City of South Bend Period Ending:May 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 - - - - - - - 32,522 60,000 54% Gift, Donation, Bequest 217 50,900 1,097 69,994 5,639 220 - - - - - - - 127,849 175,800 73% Unsafe Building 219 11,928 152,225 26,129 160,537 14,230 - - - - - - - 365,050 793,757 46% Landlord Registration 221 2,260 270 1,245 155 60 - - - - - - - 3,990 7,000 57% Loss Recovery 227 730 741 851 404 368 - - - - - - - 3,094 9,000 34% LOIT 2016 Special Distribution 257- 6,605 156,406 1,646 1,183 - - - - - - - 165,840 1,471,000 11% Human Rights 258 91,498 4,790 5,975 2,576 356 - - - - - - - 105,194 165,040 64% Morris Palais Marketing 273 34 582 1,132 577 947 - - - - - - - 3,273 18,300 18% IT / Innovation /311 Call Center 279 430,621 430,621 430,621 430,621 430,621 - - - - - - - 2,153,105 5,205,034 41% Professional Sports Development 377 80,547 318 115,357 24,107 23,146 - - - - - - - 243,475 732,000 33% 1201 Code Enforcement 600 12,749 366,188 37,109 380,781 6,482 - - - - - - - 803,309 1,810,451 44% 1207 Animal Control 600 4,706 187,306 6,015 188,107 6,975 - - - - - - - 393,108 789,865 50% 1306 Building Operations 600 92,341 88,523 111,064 97,168 142,392 - - - - - - - 531,488 1,376,150 39% Century Center 670 910,931 211,677 (225,009) 400,425 412,693 - - - - - - - 1,710,716 4,194,311 41% Century Center Capital 671 74 66 74 71 74 - - - - - - - 358 750 48% Century Center Energy Saving 672 6 4 4 4 4 - - - - - - - 22 192,297 0% Sub Total 1,696,966 1,458,786 745,904 1,697,080 1,043,657 - - - - - - - 6,642,393 17,000,755 39% Business Insurance 0000 Business Insurance Revenues 226 246,679 247,476 245,267 248,740 243,026 - - - - - - - 1,231,188 3,527,591 35% 0418 Workers Compensation 226 619 35,123 - - - - - - - - - - 35,742 30,000 119% Sub Total 247,298 282,599 245,267 248,740 243,026 - - - - - - - 1,266,930 3,557,591 36% Fiduciary Trust & Agency Fire Pension 701 335 84 - - - - - - - - - - 419 5,217,138 0% Police Pension 702 2,386 1,224 5,915 565 595 - - - - - - - 10,685 6,136,500 0% Employee Benefits 711 1,511,154 1,463,664 1,500,195 1,490,799 1,481,130 - - - - - - - 7,446,942 17,800,413 42% Unemployment Comp 713 217 214 244 114 102 - - - - - - - 890 83,000 1% City Cemetery Trust 730 22 22 25 12 11 - - - - - - - 92 200 46% Equipment / Vehicle Leasing 750- 298 375 223 2,916,712 - - - - - - - 2,917,608 5,501,000 53% Parks Bond Capital 751- 369 539 485 517 - - - - - - - 1,909 7,500 25% Smart Street Bond Capital 753- 604 663 544 545 - - - - - - - 2,356 17,000 14% Sub Total 1,514,115 1,466,478 1,507,957 1,492,742 4,399,611 - - - - - - - 10,380,903 34,762,751 30% Civil City Revenues 15,432,926 22,115,337 17,328,250 17,107,703 17,863,212 - - - - - - - 89,847,428 284,472,446 32% Tax Increment Financing TIF River West - Airport 324 78,976 118,077 87,148 235,509 71,358 - - - - - - - 591,068 22,888,477 3% TIF West Washington 422 1,411 1,497 1,721 821 751 - - - - - - - 6,200 436,000 1% TIF Leighton Plaza 425 10,467 14,196 10,498 8,768 8,762 - - - - - - - 52,690 197,014 27% TIF River East DEV (NE)429 5,927 6,699 11,342 3,606 3,279 - - - - - - - 30,853 3,069,524 1% TIF Southside 430 3,108 564,649 4,388 906,618 2,039 - - - - - - - 1,480,802 3,901,127 38% TIF Erskine Village 432 3,646 3,484 791 378 219 - - - - - - - 8,518 12,000 71% TIF Douglas Road 435 77 120 95 3 3 - - - - - - - 298 327,858 0% TIF River East RES (NE RE)436 442 - - - - - - - - - - - 442 3,300,903 0% Sub Total 104,055 708,721 115,983 1,155,702 86,411 - - - - - - - 2,170,871 34,132,903 6% 2017-05 Financial Report - Rev enue Summar y Page 9 of 25 City of South Bend Period Ending:May 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 - - - - - - - 27 135 20% Certified Technology Park 439 1,614 1,641 1,887 900 825 - - - - - - - 6,867 50,000 14% Airport Urban Enterprise Zone 454 288 292 336 160 147 - - - - - - - 1,224 3,900 31% Industrial Revolving 754- - 21,526 9,673 14,952 - - - - - - - 46,151 210,000 22% Sub Total 1,908 1,940 23,757 10,737 15,927 - - - - - - - 54,269 264,035 21% Debt Service Airport Debt Reserve 2003 315 780 792 902 434 398 - - - - - - - 3,306 14,000 24% Coveleski Bond Debt Reserve 317 385 391 450 214 197 - - - - - - - 1,637 5,000 33% Central Development reserve 328 1,303 1,323 1,522 725 664 - - - - - - - 5,538 15,000 37% SB Redevelopment Authority 752- 772,669 1,236,763 395 197,726 - - - - - - - 2,207,553 3,868,169 57% Smart Streets Debt Svc 756- 179 263 197 218 - - - - - - - 857 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 - - - - - - - 6,180,671 8,719,735 71% Redevelopment Commission 108,431 5,447,712 1,379,721 1,168,406 301,541 - - - - - - - 8,405,811 43,116,673 19% City Operations Total 15,541,357 27,563,049 18,707,971 18,276,109 18,164,753 - - - - - - - 98,253,239 327,588,849 30% Revenue report 15,541,356 27,563,049 18,707,971 18,276,109 18,164,753 0 0 0 0 0 0 0 98,253,239 327,588,849 0 0 0 0(0)0 0 0 0 0 0 0 0 0 2017-05 Financial Report - Rev enue Summar y Page 10 of 25 City of South Bend Period Ending:May 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-05 Financial Report - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:May 31, 2017 Property Tax Revenue 2014 Tax Pay 2015 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/8/2015 6/16/2015 10/30/2015 12/15/2015 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 38,619,247.00 0.95 36,688,284.65 13,463,468.56 7,216,350.23 2,012,110.57 14,657,458.45 37,349,387.81 1,269,859.19 96.71% Parks & Recreation 201 7,742,127.00 0.95 7,355,020.65 2,699,065.71 1,446,685.42 403,374.41 2,938,428.80 7,487,554.34 254,572.66 96.71% College Football Hall of Fame 313 937,076.00 0.95 890,222.20 - 501,784.88 - 404,478.29 906,263.17 30,812.83 96.71% Cumulative Capital District 406 443,304.00 0.95 421,138.80 154,544.81 82,835.23 23,096.67 168,250.41 428,727.12 14,576.88 96.71% Fire Pension 701- 0.95 - - - - - - - - Police Pension 702- 0.95 - - - - - - - - Total - City 47,741,754.00 45,354,666.30 16,317,079.08 9,247,655.76 2,438,581.65 18,168,615.95 46,171,932.44 1,569,821.56 96.71% Tax Increment Financing Airport TIF District 324 17,709,737.84 0.95 16,824,250.95 - 9,396,167.91 - 6,897,072.02 16,293,239.93 1,416,497.91 92.00% South Bend Central TIF District 420- 0.95 - - - - - - - West Washington TIF District 422 512,917.39 0.95 487,271.52 - 195,865.56 - 207,045.03 402,910.59 110,006.80 78.55% Central Medical TIF District 426- 0.95 - - - - - - - Northeast Residential TIF District 436 3,273,328.42 0.95 3,109,662.00 - 1,663,572.10 - 1,466,109.03 3,129,681.13 143,647.29 95.61% Southside TIF District #1 430 2,504,494.11 0.95 2,379,269.40 - 1,298,974.33 - 906,847.80 2,205,822.13 298,671.98 88.07% Erskine Commons TIF District #2 431- 0.95 - - - - - - - Erskine Village TIF District #3 432 19,182.73 0.95 18,223.59 - 11,490.26 - 7,692.47 19,182.73 - 100.00% Douglas Road TIF District 435 327,887.96 0.95 311,493.56 - 163,943.98 - 106,813.87 270,757.85 57,130.11 82.58% Northeast TIF 429 2,743,819.42 0.95 2,606,628.45 - 1,391,012.32 - 1,030,295.80 2,421,308.12 322,511.30 88.25% Airport Urban Enterprise Zone 454- 0.95 - - - - - - - - Other xxx- - - - - - Total - Tax Increment Financing 27,091,367.87 25,736,799.48 - 14,121,026.46 - 10,621,876.02 24,742,902.48 2,348,465.39 91.33% Grand Total 74,833,121.87 71,091,465.78 16,317,079.08 23,368,682.22 2,438,581.65 28,790,491.97 70,914,834.92 3,918,286.95 94.76% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/8/15 2 Distribution 2 - Issued by St. Joseph County on 6/16/15 3 Distribution 3 - Issued by St. Joseph County on 10/30/15 Distribution 4 - Issued by St. Joseph County on 12/15/15 2017-05 Financial Report - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:May 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 - - - - - - - 290,550 872,923 33% 0201 Clerk 101 38,451 43,206 31,600 35,638 35,273 - - - - - - - 184,168 536,216 34% 0301 Common Council 101 33,451 49,728 27,207 50,580 28,885 - - - - - - - 189,850 571,148 33% 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 - - - - - - - 955,127 2,476,351 39% 0501 Legal Department 101 87,585 86,783 87,565 116,630 75,744 - - - - - - - 454,306 1,158,567 39% Sub Total 402,773 416,575 385,606 467,764 444,284 - - - - - - - 2,117,003 5,658,205 37% Public Works 0602 Engineering 101 81,736 88,219 89,641 89,644 103,226 - - - - - - - 452,465 1,445,157 31% Sub Total 81,736 88,219 89,641 89,644 103,226 - - - - - - - 452,465 1,445,157 31% Public Safety 0801 Police 101 2,401,801 2,081,566 2,099,258 2,016,036 2,087,143 - - - - - - - 10,685,805 29,668,433 36% 0901 Fire 101 1,586,894 1,525,036 1,582,606 1,554,060 1,604,395 - - - - - - - 7,852,991 21,111,466 37% Sub Total 3,988,695 3,606,602 3,681,864 3,570,096 3,691,539 - - - - - - - 18,538,796 50,779,899 37% Code Enforcement Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 74,731 80,199 47,613 60,412 60,629 - - - - - - - 323,584 1,271,039 25% 0405 Palais Royale 101 24,999 30,061 10,824 17,021 18,169 - - - - - - - 101,074 530,200 19% Sub Total 99,730 110,260 58,436 77,434 78,798 - - - - - - - 424,658 1,801,239 24% Human Rights 1008 Human Rights 101 37,821 40,148 32,484 37,408 31,913 - - - - - - - 179,774 425,805 42% Sub Total 37,821 40,148 32,484 37,408 31,913 - - - - - - - 179,774 425,805 42% General Fund Expenditure Total 4,610,756 4,261,804 4,248,032 4,242,346 4,349,760 - - - - - - - 21,712,697 60,110,305 36% 2017-05 Financial Report - Expe nditu re Su mmary Page 13 of 25 City of South Bend Period Ending:May 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 - - - - - - - 577,617 1,468,296 39% 1101 Maintenance 201 399,021 416,933 423,013 569,543 553,920 - - - - - - - 2,362,429 6,814,308 35% 1102 Golf Operations 201 54,483 75,381 77,362 180,384 131,801 - - - - - - - 519,412 1,638,575 32% 1103 Recreation Division 201 165,251 145,109 133,502 139,866 147,123 - - - - - - - 730,850 2,153,817 34% 1104 Potawatomi Zoo 201 355,692 7,425 7,231 7,208 289,717 - - - - - - - 667,273 704,464 95% 1106 Potawatomi Greenhouse 201 5,013 4,555 2,550 2,375 1,198 - - - - - - - 15,691 54,408 29% 1108 Graffiti Removal 201 13,483 12,628 11,465 10,265 8,529 - - - - - - - 56,370 97,861 58% 1110 Marketing and Events 201 16,583 45,412 58,810 61,326 60,810 - - - - - - - 242,940 953,588 25% Recreation Non Reverting 203 51,478 47,722 45,821 94,361 71,392 - - - - - - - 310,773 1,599,683 19% East Race Waterway 271- - - - - - - - - - - - - 1,367 0% Coveleski Stadium 401- - - 8,542 4,569 - - - - - - - 13,111 30,000 44% Zoo Endowment 403- - - 53,599 - - - - - - - - 53,599 49,688 108% Park Non Reverting 405 45,874 17,251 22,621 42,193 16,930 - - - - - - - 144,869 228,024 64% Sub Total 1,254,532 860,290 893,243 1,282,404 1,404,465 - - - - - - - 5,694,934 15,794,079 36% Public Works Motor Vehicle Highway 202 919,033 515,568 547,694 523,276 541,787 - - - - - - - 3,047,358 9,686,533 31% Curb and Sidewalk 202 150,920 40,047 37,646 38,164 143,273 - - - - - - - 410,051 1,878,998 22% Central Services 222 730,352 648,645 561,962 613,240 672,069 - - - - - - - 3,226,269 8,564,643 38% Central Services Capital 224 10,575 4,009 - 16,964 - - - - - - - - 31,549 326,025 10% Local Roads & Streets 251 209,999 4,801 3,018 35,678 92,276 - - - - - - - 345,772 2,086,544 17% Local Roads & Bridge 265- - - - - - - - - - - - - 2,000,000 0% Project ReLeaf 655 15,049 90,567 3,684 115,917 3,108 - - - - - - - 228,325 525,416 43% Sub Total 2,035,929 1,303,638 1,154,005 1,343,240 1,452,512 - - - - - - - 7,289,324 25,068,159 29% Public Works Solid Waste Solid Waste Operations 610 489,623 312,159 388,501 385,830 347,815 - - - - - - - 1,923,928 5,662,910 34% Solid Waste Capital 611 286,902 146,712 218 83,859 20,129 - - - - - - - 537,819 1,135,613 47% Sub Total 776,525 458,871 388,720 469,689 367,944 - - - - - - - 2,461,748 6,798,523 36% Public Works Water Utility 0630 Water Leak Insurance 620 43,958 41,864 50,876 46,504 58,900 - - - - - - - 242,101 1,035,000 23% 0640 Water Works 620 1,417,876 1,256,524 1,085,407 1,142,917 1,117,427 - - - - - - - 6,020,151 16,688,754 36% 0660 Clay Water 620- - (0) 169 37 - - - - - - - 206 3,500 6% Waterworks Capital 622 111,938 177,777 13,775 9,295 8,299 - - - - - - - 321,083 1,414,466 23% Waterworks Deposit 624 874 1,174 1,347 639 583 - - - - - - - 4,617 15,000 31% Waterworks Sinking 625 815 289 321 211 266 - - - - - - - 1,902 2,054,891 0% Waterworks Bond Reserve 626- - - - - - - - - - - - - 16,000 0% Waterworks Debt Reserve 629 1,394 1,895 2,292 1,092 1,000 - - - - - - - 7,673 23,000 33% Sub Total 1,576,855 1,479,523 1,154,018 1,200,827 1,186,511 - - - - - - - 6,597,734 21,250,611 31% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 48,400 46,390 29,841 52,988 63,829 - - - - - - - 241,449 534,509 45% 0621 Sewer Repair 641 517,647 434,598 385,613 579,850 349,846 - - - - - - - 2,267,554 9,248,687 25% 0625 Concrete Crew 641 30,239 20,767 19,975 30,713 26,000 - - - - - - - 127,694 474,389 27% 0630 Wastewater Operations 641 2,358,990 1,454,679 3,260,858 2,528,275 2,582,015 - - - - - - - 12,184,818 33,209,563 37% 0631 Organic Resources 641 124,773 126,931 80,689 53,682 214,126 - - - - - - - 600,200 1,608,946 37% 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 - - - - - - - 2,488,259 8,040,455 31% Sewage Reserve 643 2,625 3,535 4,065 2,021 1,972 - - - - - - - 14,217 30,000 47% Sewage Bond Sinking 649 1,000 500 - - 830,476 - - - - - - - 831,976 9,163,754 9% 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 - - - - - - - 733,094 3,010,364 24% Sub Total 4,385,001 2,642,343 4,073,031 3,572,814 4,868,271 - - - - - - - 19,541,460 65,373,105 30% 2017-05 Financial Report - Expe nditu re Su mmary Page 14 of 25 City of South Bend Period Ending:May 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- - - - - - - - - - - - - 36,000 0% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 44,630 19,978 197,939 29,048 26,375 - - - - - - - 317,971 788,422 40% 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 - - - - - - - 2,776,804 7,462,645 37% Excess Welfare Public Safety 252- - - - - - - - - - - - - 8 0% LOIT 2016 Special Distribution 257 21,360 21,991 1,050,366 38,621 39,807 - - - - - - - 1,172,144 3,757,457 31% Police Take Home Vehicle 278- 972 - (60) (120) - - - - - - - 792 10,000 8% Police Grants 292 2,796 1,266 1,330 90 106 - - - - - - - 5,587 10,805 52% Police Academy 294 162 283 692 909 515 - - - - - - - 2,561 22,500 11% COPS More Grants 295 10,980 3,436 108,583 11,664 915 - - - - - - - 135,578 263,767 51% Drug Enforcement 299 11,242 23,096 13,200 - - - - - - - - - 47,537 196,337 24% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 557,416 558,803 1,985,195 683,915 678,354 - - - - - - - 4,463,683 12,584,632 35% Public Safety - Fire EMS Capital 287 235,792 150,604 - 386,321 136,287 - - - - - - - 909,004 3,100,377 29% EMS Operating Fund 288 438,601 356,431 401,753 451,805 437,873 - - - - - - - 2,086,462 6,117,914 34% Hazmat 289 430 255 - - 4,057 - - - - - - - 4,742 10,431 45% River Rescue 291 1,443 231 231 23,817 10,419 - - - - - - - 36,140 89,349 40% xxx xxx xxx- - - - - - - - - - - - - NA Sub Total 676,266 507,520 401,984 861,943 588,636 - - - - - - - 3,036,349 9,318,071 33% 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 509,757 4% DCI Operating 211 197,318 171,937 175,385 177,600 195,239 - - - - - - - 917,479 2,650,376 35% 1001 Dept. of Community Investment 212 575,173 100,654 21,621 163,348 164,147 - - - - - - - 1,024,942 5,455,838 19% 1003 Administration 212- - - - - - - - - - - - - - NA xxx Programs 212- - - - - - - - - - - - - - NA Sub Total 843,192 277,183 238,081 380,458 403,211 - - - - - - - 2,142,125 9,155,364 23% Parking Garages 0461 St. Joseph 601- - 604 - - - - - - - 604 - NA 0460 Main Street 601 10,017 11,799 1,749 75,944 10,787 - - - - - - - 110,298 261,894 42% 0462 Leighton Plaza 601 20,044 21,722 1,360 55,854 7,114 - - - - - - - 106,095 596,368 18% 0463 Enforcement 601 7,858 7,238 437 22,849 437 - - - - - - - 38,819 128,675 30% 0464 Wayne Street 601 12,364 13,889 936 32,097 5,591 - - - - - - - 64,878 244,417 27% 0465 Eddy Street Commons 601- - - 32 - - - - - - - - 32 15,900 0% Sub Total 50,284 54,648 4,482 186,776 24,534 - - - - - - - 320,725 1,247,254 26% 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 - - - - - - - 4,882,696 12,071,593 40% 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 - - - - - - - 5,076,596 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 106,144 4% Palais Historic Preservation 450- - - - - - - - - - - - - 5,000 0% Hall of Fame Capital 677 3,866 14,859 2,574 3,209 2,159 - - - - - - - 26,666 81,091 33% 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 - - - - - - - 12,797,026 31,572,309 41% 2017-05 Financial Report - Expe nditu re Su mmary Page 15 of 25 City of South Bend Period Ending:May 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 - - - - - - - 74,323 238,700 31% Unsafe Building 219 80,336 43,005 41,261 55,208 81,628 - - - - - - - 301,437 902,746 33% 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 - - - - - - - 54,573 201,773 27% 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 - - - - - - - 1,493,685 5,205,034 29% 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 - - - - - - - 547,506 1,625,378 34% 1207 Animal Control 600 68,101 59,652 58,318 65,964 68,163 - - - - - - - 320,198 790,517 41% 1306 Building Operations 600 110,343 98,842 97,813 101,286 98,111 - - - - - - - 506,395 1,361,925 37% Century Center 670 282,027 349,477 (15,339) 661,555 322,739 - - - - - - - 1,600,459 4,194,310 38% 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 - - - - - - - 5,486,695 16,161,985 34% Business Insurance 0403 Self Funded Liability Ins 226 17,866 17,273 20,527 15,424 16,015 - - - - - - - 87,104 235,471 37% 0412 Liability Insurance 226 45,537 23,578 52,779 27,697 640,369 - - - - - - - 789,960 2,034,051 39% 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 - - - - - - - 560,511 722,386 78% Sub Total 228,276 128,412 148,890 283,807 736,460 - - - - - - - 1,525,845 3,587,586 43% Fiduciary Trust & Agency Fire Pension 701 388,455 396,509 396,201 394,300 390,847 - - - - - - - 1,966,312 5,098,269 39% Police Pension 702 513,053 511,187 523,297 519,926 517,885 - - - - - - - 2,585,347 6,423,889 40% Employee Benefits 711 1,060,085 1,343,141 951,392 1,174,621 1,102,064 - - - - - - - 5,631,304 17,803,200 32% Unemployment Comp 713 6,038 8,041 4,389 5,340 3,324 - - - - - - - 27,132 84,105 32% City Cemetery Trust 730- - - - - - - - - - - - 6,000 0% Equipment / Vehicle Leasing 750- 983,042 489,584 65,756 135,750 - - - - - - - 1,674,132 5,500,000 30% Parks Bond Capital 751- 63,156 211,200 140,581 19,839 - - - - - - - 434,776 3,500,000 12% Smart Street Bond 753- 986,652 285,891 512,350 617,149 - - - - - - - 2,402,042 10,000,000 24% xxx xxx xxx NA Sub Total 1,967,632 4,291,727 2,861,954 2,812,874 2,786,859 - - - - - - - 14,721,046 48,415,463 30% Civil City Expenditure 23,354,822 20,927,696 20,605,582 22,621,770 20,281,521 - - - - - - - 107,791,390 326,437,446 33% Tax Increment Financing TIF River West - Airport 324 4,348,398 123,050 1,434,861 735,643 590,372 - - - - - - - 7,232,324 39,618,887 18% 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 - - - - - - - 39,633 158,166 25% TIF River East DEV (NE)429 27,144 45,644 101,171 587,302 45,684 - - - - - - - 806,944 10,602,696 8% TIF Southside 430 146,124 12,530 17,419 24,812 100,639 - - - - - - - 301,524 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 - - - - - - - 15,082,505 67,378,709 22% 2017-05 Financial Report - Expe nditu re Su mmary Page 16 of 25 City of South Bend Period Ending:May 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 - - - - - - - 31,765 157,000 20% Sub Total- - 14,437 17,369 1,801,091 - - - - - - - 1,832,898 2,411,500 76% Debt Service Airport Debt Reserve 2003 315 588 792 902 434 398 - - - - - - - 3,114 14,000 22% Central Development reserve 328 983 1,323 1,522 725 664 - - - - - - - 5,218 15,000 35% SB Redevelopment Authority 752- 735,236 2,004,503 5 - - - - - - - - 2,739,743 4,603,405 60% 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,521,918 100% xxx xxx xxx NA Sub Total 1,571 1,298,580 6,363,379 1,165 1,062 - - - - - - - 7,665,757 10,010,107 77% Redevelopment Commission 9,726,545 2,085,695 7,938,167 2,282,595 2,548,158 - - - - - - - 24,581,160 79,800,316 31% City Operations Total 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 - - - - - - - 132,372,550 406,237,762 33% Expenditure report 33,081,366 23,013,391 28,543,749 24,904,365 22,829,679 0 0 0 0 0 0 0 132,372,550 406,237,762 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2017-05 Financial Report - Expe nditu re Su mmary Page 17 of 25 City of South Bend Period Ending:May 31, 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-05 Finan cial Report - Debt Page 1 8 o f 25 City of South Bend Period Ending:May 31, 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 40 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-05 Finan cial Report - Debt Page 1 9 o f 25 City of South Bend Period Ending:May 31, 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 5/3 1/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 0.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 0.00 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 0.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 0.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 0.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 32,295.87 17,732.34 0.00 2,354,212.05 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 0.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 24,880.87 691,744.30 0.00 128,016,582.05 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 0.00 0.00 0.00 1,351,597.75 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 0.00 0.00 0.00 1,684,159.75 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 538.01 12.79 0.00 218.76 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 299.88 17.82 0.00 926.05 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 887.23 34.58 0.00 2,687.86 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 595.09 52.91 0.00 1,864.17 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 360.18 31.07 0.00 1,131.59 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 836.03 88.97 0.00 3,358.11 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 487.76 51.99 0.00 1,960.35 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 408.74 43.56 0.00 1,642.88 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 408.74 43.56 0.00 1,642.88 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 364.90 45.10 0.00 1,711.54 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 13,419.15 1,091.00 0.00 50,106.48 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 390.66 34.24 0.00 1,556.35 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 581.99 41.36 0.00 2,213.31 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 362.86 35.94 0.00 1,555.13 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 129.98 10.37 0.00 576.07 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 439.30 73.05 0.00 2,863.02 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 739.61 106.99 0.00 4,137.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,030.22 143.53 0.00 5,527.94 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 406.87 45.43 0.00 1,725.38 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 1,863.32 233.58 0.00 9,990.82 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 423.26 83.34 0.00 3,168.62 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 12,691.95 1,851.55 0.00 82,018.67 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 286.00 39.60 0.00 1,875.06 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 331.92 79.18 0.00 3,122.80 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,480.87 609.03 0.00 26,186.32 14 8 Cen tral Services Lanier C opier C 6502 201 6 20 20 22 2 Monthly---11,41 3.00 10,059.31 870.53 213.72 0.00 9,188.78 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,606.49 261.51 0.00 12,407.50 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 838.78 205.07 0.00 8,099.49 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 13,787.67 2,954.68 0.00 136,775.06 15 7 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly---3,18 4.06 3,184.06 582.51 263.16 0.00 2,601.55 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,229.99 271.13 15,7 02.09 14,472.10 xxx T otal Cap ital L ease 33,145,18 9.96 16,078,945.72 2,2 60,328.87 131,736.02 2,9 32,2 02.09 16,750,818.94 To tal Civ i l C i ty 2 97,845,11 5.46 147,504,568.39 3,9 85,209.74 823,480.32 2,9 32,2 02.09 146,451,560.74 2 0 1 7-05 Finan cial Report - Debt Page 2 0 o f 25 City of South Bend Period Ending:May 31, 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 5/3 1/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 15,737.09 2,265.52 0.00 286,332.06 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 31,346.66 83,244.95 7 50,0 00.00 5,541,360.03 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 40 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,1 95,463.66 1,793,048.46 7 50,0 00.00 88,952,581.03 To tal Debt 4 72,771,68 0.52 239,919,688.58 8,1 80,673.40 2,616,528.78 3,6 82,2 02.09 235,404,141.77 2 0 1 7-05 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 - - 0 0 0 0 0 Part Time Staff 115 119 142 155 168 0 0 0 0 0 0 0 Temporary / Seasonal 12 11 13 41 86 0 0 0 0 0 0 0 City Total 1,207 1,199 1,237 1,274 1,330 - - 0 0 0 0 0 2017-05 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 0 0 0 0 0 0 0 311 Call Center 6 6 6 6 7 7 0 0 0 0 0 0 0 Admin & Finance 23 20 21 22 23 23 0 0 0 0 0 0 0 Innovation/ Technology Office 18 14 14 15 14 16 0 0 0 0 0 0 0 Safety & Risk 2 2 2 2 2 2 0 0 0 0 0 0 0 Clerk 5 5 5 5 5 5 0 0 0 0 0 0 0 Common Council 9 9 9 9 9 9 0 0 0 0 0 0 0 Legal Department 10 11 11 10 10 10 0 0 0 0 0 0 0 Sub Total 80 73 74 75 75 78 0 0 0 0 0 0 0 Code Enf. /Animal Control 25 20 22 24 24 25 0 0 0 0 0 0 0 Dept. of Community Investment 23 22 20 21 21 20 0 0 0 0 0 0 0 Parks & Recreation Administration 6 6 6 6 6 6 0 0 0 0 0 0 0 Maintenance 46 45 47 48 47 47 0 0 0 0 0 0 0 Golf Operations 8 7 8 7 8 8 0 0 0 0 0 0 0 Recreation Ops 25 22 21 21 21 21 0 0 0 0 0 0 0 Zoological Ops 1 1 1 1 1 1 0 0 0 0 0 0 0 Graffiti Removal 1 1 1 1 1 1 0 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 0 0 0 0 0 0 0 Sub Total 98 91 95 95 95 95 0 0 0 0 0 0 0 Public Safety Police 289 284 272 282 280 278 0 0 0 0 0 0 0 Fire 264 268 267 266 263 261 0 0 0 0 0 0 0 Sub Total 553 552 539 548 543 539 0 0 0 0 0 0 0 Public Works Central Services 37 35 36 35 34 35 0 0 0 0 0 0 0 Office of Sustainability 2 2 2 2 2 2 0 0 0 0 0 0 0 Engineering 18 18 18 20 20 20 0 0 0 0 0 0 0 Maintenance 3 3 3 2 3 3 0 0 0 0 0 0 0 Solid Waste Operations 26 25 25 26 25 24 0 0 0 0 0 0 0 Unsafe Bldg Code Clean Crew 4 4 4 4 4 4 0 0 0 0 0 0 0 Street Operations 55 54 54 54 54 53 0 0 0 0 0 0 0 Sewer Operations 37 37 37 37 37 35 0 0 0 0 0 0 0 Waste Water Ops 45 45 45 44 44 45 0 0 0 0 0 0 0 Organic Resources 6 6 5 5 6 6 0 0 0 0 0 0 0 Water Utility Ops 71 64 63 63 63 64 0 0 0 0 0 0 0 Sub Total 304 293 292 292 292 291 0 0 0 0 0 0 0 Building Department 14 14 14 14 14 14 0 0 0 0 0 0 0 Human Rights 6 6 6 6 6 6 0 0 0 0 0 0 0 Morris & Palais 9 9 7 7 8 8 0 0 0 0 0 0 0 City Total 1,112 1,080 1,069 1,082 1,078 1,076 - - - - - - - 2017-05 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 0 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 0 0 0 0 0 0 0 Sub Total 5 4 4 2 2 0 0 0 0 0 0 0 Code Enf. / Animal Control 3 2 3 3 3 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 1 1 1 1 1 0 0 0 0 0 0 0 Maintenance 11 11 11 15 14 0 0 0 0 0 0 0 Golf Operations 2 0 18 41 54 0 0 0 0 0 0 0 Recreation Ops 46 54 54 46 48 0 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 0 0 0 0 0 0 0 Sub Total 65 70 88 104 118 0 0 0 0 0 0 0 Public Safety Police 25 25 29 27 27 0 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 25 25 29 27 27 0 0 0 0 0 0 0 Public Works` Central Services 1 1 1 1 1 0 0 0 0 0 0 0 Engineering 2 2 2 3 2 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 7 8 9 9 9 0 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 0 0 0 0 0 0 0 Sub Total 13 14 14 15 14 0 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 0 0 0 0 0 0 0 City Total 115 119 142 155 168 0 0 0 0 0 0 0 2017-05 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 0 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 0 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 0 0 0 0 0 0 0 Golf Operations 0 0 1 1 2 0 0 0 0 0 0 0 Recreation Ops 3 2 2 15 40 0 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 0 0 0 0 0 0 0 Public Safety Police 0 0 0 0 0 0 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 0 0 0 0 0 0 0 Public Works Central Services 0 0 0 0 0 0 0 0 0 0 0 0 Engineering 3 4 4 4 1 0 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 0 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 0 0 0 0 0 0 0 Organic Resources 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 0 0 0 0 2 0 0 0 0 0 0 0 Sub Total 4 5 6 11 13 0 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 0 0 0 0 0 0 0 2017-05 Financial Report - Headcount Staffing Page 25 of 25