Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-01 - Monthly Financial Report
Period Ending: Issued By: City of South Bend Financial Report Page Contents 2 Narrative 3 - 6 Revenue by Type 7 - 10 Revenue by Fund 11 Property Tax Revenue 12 - 15 Expenditures by Fund and Department 16 - 17 Outstanding Debt 18 - 19 Debt Payments Year-to-Date 20 - 21 Full-Time Summary by Fund 22 Full-Time Summary by Activity 23 Part-Time Summary by Fund 24 Paid Temporary, Seasonal, and Intern Staff Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg Common Council Department Heads Fiscal Officers January 31, 2018 Controller January 31, 2018 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format.Information is provided for revenue (by type and fund),expenditures,property taxes,debt status,and staffing levels.This report is prepared monthly and supplements other reports that the City prepares such as the Controller's Cash Report,the Monthly Departmental Financial Report,and the Comprehensive Annual Financial Report (CAFR). Revenue by Type For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 5%, similar to January 2017.Please note a few revenue types have reached well above their standard 8%of revenue at this time.This is due in part to monies received in January 2018 that are related to 2017 services.These include revenue type(335)Liquor Excise tax,type(342)EMS for Medicaid reimbursement,type(360)miscellaneous for P-Card Commission rebate,and type(391)TIF Property Sales/Land for the sale of 333 Western Ave. Revenue by Fund As of January 2018, the general fund has reached 2% of its budgeted revenue, similar to last year. As mentioned above,some funds have surpassed their normal 8%of revenue at this time due to monies received this month that are related to 2017 services.Fund 101-0401(Admin&Finance)has exceeded its budgeted revenue by$751 or 6%over budgeted revenue amount.This month rebate for the P- card commission was received in the amount of$12,800.Fund 287(EMS Capital)is at 186%of its budgeted revenue as result of 2017 Medicaid reimbursement received this month in the amount of$1,078,550.Fund 629(Waterworks Debt Reserve)is at 254%of its budgeted revenue.Money was transferred in from fund 620 to cover two months of operating expenditures plus additional money for anticipated roll over of encumbrances. Fund 407 (Cumulative Capital Improvement) is currently at 80% of its budgeted revenue. This month received hotel/motel tax payment, that should have been receipted into fund 672. Correction will be made in February 2018. Property Taxes Property taxes are received in June and December.Property taxes collected in 2017 totaled~$77.1 million.Civil city funds received~$49.8 million or 98%and TIF funds received~$27.2 million or 94%.For 2017,the projected levy collection rate was 95%or$75.6 million.Lower than expected TIF collection due to Meijer refund and other TIF adjustments made by the county. Total property taxes collected for the year 2016 was~$76.7 million or 96.78%of the tax levy.Specifically,in 2016 the City of South Bend received a total of$49,067,532 in property tax revenue in the civil city funds(general fund,parks,College Football Hall of Fame,and CCD).For TIF funds, the City received a total of $27,640,882 in property tax revenue. Expenditures As of January 2018,the City has spent 5%of budgeted expenditures,compared to 8%last year.The General Fund has spent 8%of its 2018 budgeted expenditures,similar to 2017.The following funds have reached 40%or more of its budgeted expenditures as a result of bond payments. Fund 313 (Hall of Fame), final payment was made this month. Fund 377 (PSDA), payment made for the Coveleski Stadium bond in the amount of $335,000. Fund 406 (Cumulative Capital Development), payment for vehicle equipment and fund 407 (Cumulative Capital Improvement) payment for the Century Center. Debt This month, various debt service payments were made in the amount of ~ $6.3 million. Payments are related to IT equipment leases. St. Joseph County PSAP, Indiana Finance Authority, and US Bank. Headcount The Full Time Headcount as of January was 1,101 vs. a budgeted amount of 1,116. Currently, there are a total of 16 vacant positions. The 16 open positions are in the following departments: General Government (3), Public Safety (3), Public Works (2), IT/Innovation/ 311 Call Center (3), Central Services (1), and Consolidated Bldg. Department (5). If you have any questions regarding this report, please contact the Department of Administration and Finance by calling 311. Monthly Financial Report 2 of 24 City of South Bend Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Taxes Property Tax 311 Property Tax Civil City various- - - - - - - - - - - - - 49,822,557 0% 311 Property Tax TIF Districts various- - - - - - - - - - - - - 27,878,133 0% Sub Total- - - - - - - - - - - - - 77,700,690 0% Income Tax 315 Econ Development Income Tax 408 893,413 - - - - - - - - - - - 893,413 10,720,965 8% 316 Local Option Income Tax - PS 249 635,795 - - - - - - - - - - - 635,795 7,629,539 8% 316 County Option Income Tax 404 908,858 - - - - - - - - - - - 908,858 10,906,293 8% Sub Total 2,438,066 - - - - - - - - - - - 2,438,066 29,256,797 8% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - - - - - - - - - 3,184,500 0% 312 Commercial Vehicle Tax various- - - - - - - - - - - - - 842,600 0% 317 Hotel Motel Tax Cum Cap Imprv 407 221,437 - - - - - - - - - - - 221,437 - NA 317 Hotel Motel Tax Century Center 670/672 106,250 - - - - - - - - - - - 106,250 1,496,437 7% 317 Hotel Motel Tax Century Center 324- - - - - - - - - - - - - 395,000 0% Sub Total 327,687 - - - - - - - - - - - 327,687 5,918,537 6% Total Taxes 2,765,753 - - - - - - - - - - - 2,765,753 112,876,024 2% Intergovernmental Revenue State Shared Revenue 335 Liquor Excise tax 101 50,193 - - - - - - - - - - - 50,193 75,000 67% 335 Liquor Gallonage Tax 101 58,696 - - - - - - - - - - - 58,696 210,000 28% 335 Cigarette Tax 101/407- - - - - - - - - - - - - 320,500 0% 335 Gaming Proceeds 101- - - - - - - - - - - - - 599,000 0% 335 Gasoline Tax 202/251 561,967 - - - - - - - - - - - 561,967 6,740,000 8% 335 Wheel Tax 202 132,033 - - - - - - - - - - - 132,033 2,050,000 6% 335 Prof Sports Development Tax 377- - - - - - - - - - - - - 600,000 0% 335 State Pension Subsidy 701/702- - - - - - - - - - - - - 11,205,638 0% Sub Total 802,888 - - - - - - - - - - - 802,888 21,800,138 4% Grants 331 Federal Grants various 130,898 - - - - - - - - - - - 130,898 6,088,514 2% 334 State Grants various 2,375 - - - - - - - - - - - 2,375 367,375 1% Sub Total 133,273 - - - - - - - - - - - 133,273 6,455,889 2% Other 336 Federal Drug 299- - - - - - - - - - - - - 50,000 0% 337 Regional Cities Grant 201 195,060 - - - - - - - - - - - 195,060 2,000,000 10% 337 State Drug 216- - - - - - - - - - - - - 30,000 0% 338 Payment in Lieu of Tax various 527,707 - - - - - - - - - - - 527,707 6,332,487 8% 339 Contractual Service 211 51,257 - - - - - - - - - - - 51,257 333,500 15% Sub Total 774,024 - - - - - - - - - - - 774,024 8,745,987 9% Total Intergovernmental Revenue 1,710,185 - - - - - - - - - - - 1,710,185 37,002,014 5% Charges for Services - Internal 340 Liability Insurance 226 177,187 - - - - - - - - - - - 177,187 2,058,123 9% 349 Central Services Mark-up 222 66,267 - - - - - - - - - - - 66,267 793,711 8% Total Charges for Services - Internal 243,454 - - - - - - - - - - - 243,454 2,851,834 9% Charges for Services - External Licenses & Permits 320 Inspections Central Service 222- - - - - - - - - - - - - 1,150 0% 321 Business License 101/222 32,444 - - - - - - - - - - - 32,444 121,910 27% 322 Building Fees 600 73,425 - - - - - - - - - - - 73,425 1,387,552 5% 322 Building Plan Review - Fire Safety 288 1,145 - - - - - - - - - - - 1,145 24,000 5% 322 General Government Fees 101 6,255 - - - - - - - - - - - 6,255 132,000 5% Sub Total 113,269 - - - - - - - - - - - 113,269 1,666,612 7% Period Ending: January 31, 2018 Monthly Financial Report 3 of 24 City of South Bend Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: January 31, 2018 Charges for Services - External Public Safety 340 Public Safety various- - - - - - - - - - - - - 500 0% 340 ND EMS Service 288- - - - - - - - - - - - - 150,000 0% 342 Public Safety various 18,988 - - - - - - - - - - - 18,988 170,000 11% 342 EMS - Capital Fund 287 1,078,551 - - - - - - - - - - - 1,078,551 575,000 188% 342 EMS - Operating Fund 288 261,623 - - - - - - - - - - - 261,623 2,700,000 10% 342 EMS - Neo Natal / Transport 288 52,088 - - - - - - - - - - - 52,088 509,400 10% 342 EMS - County Fees 288- - - - - - - - - - - - - 1,766,484 0% Sub Total 1,411,250 - - - - - - - - - - - 1,411,250 5,871,384 24% Culture & Recreation 347 Parks Maintenance (1101)201/405 38,216 - - - - - - - - - - - 38,216 983,722 4% 347 Golf (1102)201- - - - - - - - - - - - - 1,496,406 0% 347 Recreation (1103)201/203 67,191 - - - - - - - - - - - 67,191 1,438,496 5% 347 Graffiiti Removal (1108)201- - - - - - - - - - - - - 106,459 0% 347 Marketing & Events (1110)201/203 22,851 - - - - - - - - - - - 22,851 245,973 9% 347 Lease of Coveleski Stadium 401- - - - - - - - - - - - - 43,500 0% 347 Morris Ticket Surcharges 274/416 2,563 - - - - - - - - - - - 2,563 224,000 1% Sub Total 130,822 - - - - - - - - - - - 130,822 4,538,556 3% Code Enforcement 321 Code and Animal Fees 600 8,225 - - - - - - - - - - - 8,225 67,150 12% 322 Code Enforcement Fees 600- - - - - - - - - - - - - 17,500 0% 323 Rental Unit Inspection Fees 600- - - - - - - - - - - - - 30,000 0% 344 Code Environmental Clean Up 101/219/600 8,672 - - - - - - - - - - - 8,672 175,000 5% 349 Code Demolition Board Up 219/600 20,189 - - - - - - - - - - - 20,189 84,500 24% Sub Total 37,087 - - - - - - - - - - - 37,087 374,150 10% Public Works 342 Highway & Streets 202 19,724 - - - - - - - - - - - 19,724 223,365 9% 344 Solid Waste 610 412,322 - - - - - - - - - - - 412,322 4,992,585 8% 346 Solid Waste Misc 610 14,208 - - - - - - - - - - - 14,208 354,606 4% 346 Water Works Utility 620 1,000,323 - - - - - - - - - - - 1,000,323 15,986,169 6% 344 Water Leak Insurance 620 82,210 - - - - - - - - - - - 82,210 1,012,683 8% 344 Sewer Repair Insurance 640 52,568 - - - - - - - - - - - 52,568 615,685 9% 344 Sewage Waste Water 641 3,062,991 - - - - - - - - - - - 3,062,991 37,433,610 8% 346 Project ReLeaf 655 37,195 - - - - - - - - - - - 37,195 439,680 8% Sub Total 4,681,543 - - - - - - - - - - - 4,681,543 61,058,383 8% Parking Garages 349 Parking Garage Fees 601 116,271 - - - - - - - - - - - 116,271 1,162,700 10% Sub Total 116,271 - - - - - - - - - - - 116,271 1,162,700 10% Century Center 349 Parking Century Center 670 14,340 - - - - - - - - - - - 14,340 131,723 11% 371 Century Center Fees 670 18,397 - - - - - - - - - - - 18,397 416,440 4% 372 Century Center Fees 670 11,305 - - - - - - - - - - - 11,305 137,197 8% 373 Century Center Fees 670 68,911 - - - - - - - - - - - 68,911 1,836,743 4% 374 Century Center Fees 670 10,280 - - - - - - - - - - - 10,280 322,054 3% Sub Total 123,233 - - - - - - - - - - - 123,233 2,844,157 4% Other 341 General Government Various various 449 - - - - - - - - - - - 449 30,605 1% 341 Historic Presrv Comm Approval 211 80 - - - - - - - - - - - 80 1,000 8% 347 Sale of Merchandise-Mayor's Office 101-0101- - - - - - - - - - - - - 100 0% 351 Fines & Fees various 24,226 - - - - - - - - - - - 24,226 265,820 9% 352 Forfeits various 11,462 - - - - - - - - - - - 11,462 200,000 6% 354 Ordinance Violation various 2,515 - - - - - - - - - - - 2,515 108,500 2% Sub Total 38,732 - - - - - - - - - - - 38,732 606,025 6% Total Charges for Services - External 6,652,205 - - - - - - - - - - - 6,652,205 78,121,967 9% Monthly Financial Report 4 of 24 City of South Bend Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: January 31, 2018 Other Income Miscellaneous Revenue 360 Miscellaneous Revenue various 19,102 - - - - - - - - - - - 19,102 1,355,951 1% 360 Insurance Reimbursement various 2,960 - - - - - - - - - - - 2,960 40,000 7% 360 Sale of Scrap Metal various 2,352 - - - - - - - - - - - 2,352 36,582 6% 360 General Government Various 101 12,826 - - - - - - - - - - - 12,826 13,000 99% 360 Engineering / Curb & Sidewalk 101- - - - - - - - - - - - - 200 0% 360 Motor Veh Highway Curb Prgm 202- - - - - - - - - - - - - 3,000 0% 360 Waste Water 641- - - - - - - - - - - - - 38,475 0% 360 Century Center 670 551 - - - - - - - - - - - 551 6,629 8% 360 Morris PAC various 20,063 - - - - - - - - - - - 20,063 1,083,500 2% 360 Palais Royale various 48,381 - - - - - - - - - - - 48,381 299,572 16% 360 Common Area Maint. Fees 425 3,449 - - - - - - - - - - - 3,449 46,245 7% Sub Total 109,685 - - - - - - - - - - - 109,685 2,923,154 4% Interest Income 361 Bank Account Interest various 551,499 - - - - - - - - - - - 551,499 1,925,314 29% Sub Total 551,499 - - - - - - - - - - - 551,499 1,925,314 29% Rental of Property 362 Dept of Community Investment 212 1,847 - - - - - - - - - - - 1,847 7,387 25% 362 Palais Royale 101 2,002 - - - - - - - - - - - 2,002 75,000 3% 362 Police 101- - - - - - - - - - - - - 48,000 0% 362 Parks & Recreation 201 1,282 - - - - - - - - - - - 1,282 42,300 3% 362 South Bend School Corp Fee 407- - - - - - - - - - - - - 25,000 0% 362 Century Center Property Rental 670 55,092 - - - - - - - - - - - 55,092 431,328 13% 362 TIF Property various 4,447 - - - - - - - - - - - 4,447 142,583 3% Sub Total 64,670 - - - - - - - - - - - 64,670 771,598 8% Donations 367 ND Contribution 101- - - - - - - - - - - - - 337,500 0% 367 Donations various 18,825 - - - - - - - - - - - 18,825 192,250 10% Sub Total 18,825 - - - - - - - - - - - 18,825 529,750 4% Historic Preservation 368 Palais Royale 450 3,726 - - - - - - - - - - - 3,726 16,500 23% Sub Total 3,726 - - - - - - - - - - - 3,726 16,500 23% 3rd Party Revenue 350 Job Target Penalty Fee 408- - - - - - - - - - - - - 354,660 0% 364 Cable TV Franchise Fees 101- - - - - - - - - - - - - 768,000 0% 366 AT&T Franchise Fees 101- - - - - - - - - - - - - 215,000 0% 369 Memorial Hosp Leighton Plaza 408- - - - - - - - - - - - - 150,000 0% Sub Total- - - - - - - - - - - - - 1,487,660 0% Total Other Income 748,405 - - - - - - - - - - - 748,405 7,653,976 10% Reimbursements & Refunds Internal Reimbursements 380 Central Services Reimbursements 222 235,705 - - - - - - - - - - - 235,705 3,138,246 8% 380 Energy Office Reimbursements 222 392,685 - - - - - - - - - - - 392,685 4,725,000 8% 380 Police Take Home Vehicle 278 240 - - - - - - - - - - - 240 - NA 380 IT / Innovation / 311 Center 279 568,506 - - - - - - - - - - - 568,506 6,850,931 8% Sub Total 1,197,136 - - - - - - - - - - - 1,197,136 14,714,177 8% Miscellaneous 380 Miscellaneous Reimbursements various 46,138 - - - - - - - - - - - 46,138 1,182,852 4% 380 INDOT SR 933 Transfer 324- - - - - - - - - - - - - 4,100,000 0% 380 General Government 101- - - - - - - - - - - - - 50 0% Sub Total 46,138 - - - - - - - - - - - 46,138 5,282,902 1% Total Reimbursements & Refunds 1,243,274 - - - - - - - - - - - 1,243,274 19,997,079 6% Monthly Financial Report 5 of 24 City of South Bend Revenue by Type Report Fund% Revenue Type Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: January 31, 2018 Other Financing Sources Fixed Assets 391 Sale of Fixed Assets various- - - - - - - - - - - - - 93,000 0% 391 TIF (Property Sales / Land)various 92,660 - - - - - - - - - - - 92,660 250,000 37% 391 Vehicle Damage Reimbursement various 4,106 - - - - - - - - - - - 4,106 - NA 391 Water Hydrant Reimbursement 620 538 - - - - - - - - - - - 538 20,000 3% Sub Total 97,305 - - - - - - - - - - - 97,305 363,000 27% Miscellaneous 392 Administration Fee Allocation 101 452,408 - - - - - - - - - - - 452,408 5,454,725 8% 392 Inter-Fund Transfers various 229,386 - - - - - - - - - - - 229,386 41,036,491 1% Sub Total 681,794 - - - - - - - - - - - 681,794 46,491,216 1% Debt Proceeds 393 Bond Proceeds various- - - - - - - - - - - - - 4,601,750 0% Sub Total- - - - - - - - - - - - - 4,601,750 0% Contributions 395 Employee Assessment 711/713/714 277,172 - - - - - - - - - - - 277,172 3,066,596 9% 395 Employer Assessment 711/713/714 1,258,903 - - - - - - - - - - - 1,258,903 15,530,694 8% Sub Total 1,536,074 - - - - - - - - - - - 1,536,074 18,597,290 8% Refunds 396 Central Services Refunds 222 14,009 - - - - - - - - - - - 14,009 21,000 67% 396 Specific Stop Loss 711 1,844 - - - - - - - - - - - 1,844 10,000 18% Sub Total 15,853 - - - - - - - - - - - 15,853 31,000 51% Other 399 Bosch Retention Project 210- - - - - - - - - - - - - 65,593 0% 399 Principal on Loan various 511 - - - - - - - - - - - 511 127,914 0% 399 Principal Income various- - - - - - - - - - - - - 1,086,395 0% 511 - - - - - - - - - - - 511 1,279,902 0% Total Other Financing Sources 2,331,537 - - - - - - - - - - - 2,331,537 71,364,158 3% Revenue Total 15,694,813 - - - - - - - - - - - 15,694,813 329,867,052 5% Monthly Financial Report 6 of 24 City of South Bend Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Fund General Government 0000 General Revenues 101 1,229,231 - - - - - - - - - - - 1,229,231 57,358,601 2% 0101 Mayor 101- - - - - - - - - - - - - 100 0% 0201 Clerk 101- - - - - - - - - - - - - - NA 0301 Common Council 101- - - - - - - - - - - - - - NA 0401 Administration and Finance 101 12,801 - - - - - - - - - - - 12,801 12,050 106% 0501 Legal 101 18,875 - - - - - - - - - - - 18,875 76,885 25% Sub Total 1,260,907 - - - - - - - - - - - 1,260,907 57,447,636 2% Public Works 0602 Engineering 101 7,755 - - - - - - - - - - - 7,755 352,167 2% Sub Total 7,755 - - - - - - - - - - - 7,755 352,167 2% Public Safety 0801 Police 101 6,578 - - - - - - - - - - - 6,578 561,000 1% 0901 Fire 101- - - - - - - - - - - - - 146,114 0% Sub Total 6,578 - - - - - - - - - - - 6,578 707,114 1% Arts & Culture 0404 Morris PAC 101 21,240 - - - - - - - - - - - 21,240 1,101,000 2% 0405 Palais Royale 101 54,041 - - - - - - - - - - - 54,041 398,972 14% Sub Total 75,281 - - - - - - - - - - - 75,281 1,499,972 5% Human Rights 1008 Human Rights 101- - - - - - - - - - - - - - NA Sub Total- - - - - - - - - - - - - - NA Total General Fund Revenue 1,350,522 - - - - - - - - - - - 1,350,522 60,006,889 2% Venues, Parks & Arts Parks & Recreation 0000 Parks General Revenue 201 11,804 - - - - - - - - - - - 11,804 10,925,596 0% 1100 Administration 201 1,283 - - - - - - - - - - - 1,283 42,400 3% 1101 Maintenance 201 38,603 - - - - - - - - - - - 38,603 1,262,622 3% 1102 Golf Operations 201 2 - - - - - - - - - - - 2 1,501,406 0% 1103 Recreation Division 201 210 - - - - - - - - - - - 210 107,060 0% 1104 Potawatomi Zoo 201- - - - - - - - - - - - - - NA 1108 Graffiti Removal 201- - - - - - - - - - - - - 106,459 0% 1110 Marketing and Events 201- - - - - - - - - - - - - 254,973 0% 1111 Regional Cities Grant 201 195,060 - - - - - - - - - - - 195,060 2,000,000 10% Recreation Non Reverting 203 91,707 - - - - - - - - - - - 91,707 1,523,436 6% Morris Palais Marketing 273 330 - - - - - - - - - - - 330 20,400 2% Morris PAC Self-Promotion 274 1,122 - - - - - - - - - - - 1,122 100,000 1% Zoo Endowment 403- - - - - - - - - - - - - 400 0% Park Non-Reverting 405 490 - - - - - - - - - - - 490 120,600 0% Sub Total 340,612 - - - - - - - - - - - 340,612 17,965,352 2% Parking Garages 0000 Parking Garage Revenue 601 1,922 - - - - - - - - - - - 1,922 67,200 3% 0460 Main Street 601 31,708 - - - - - - - - - - - 31,708 311,600 10% 0462 Leighton Plaza 601 70,649 - - - - - - - - - - - 70,649 571,000 12% 0463 Enforcement 601 4,787 - - - - - - - - - - - 4,787 - NA 0464 Wayne Street 601 13,659 - - - - - - - - - - - 13,659 279,300 5% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 500 0% Sub Total 122,725 - - - - - - - - - - - 122,725 1,229,600 10% Century Center Century Center Operations 670 285,126 - - - - - - - - - - - 285,126 4,557,114 6% Century Center Capital 671 74 - - - - - - - - - - - 74 900 8% Century Center Energy Saving 672 4 - - - - - - - - - - - 4 420,124 0% Sub Total 285,204 - - - - - - - - - - - 285,204 4,978,138 6% Total Venues, Parks & Arts 748,540 - - - - - - - - - - - 748,540 24,173,090 3% Period Ending: January 31, 2018 Monthly Financial Report 7 of 24 City of South Bend Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: January 31, 2018 Public Safety Police Department Police Seizures 216 485 - - - - - - - - - - - 485 32,000 2% Curfew Violations 218 31 - - - - - - - - - - - 31 300 10% Law Enforcement Education 220 27,367 - - - - - - - - - - - 27,367 271,500 10% Public Safety LOIT 249 637,913 - - - - - - - - - - - 637,913 7,635,539 8% Police Take Home Vehicle 278 2,042 - - - - - - - - - - - 2,042 4,000 51% Police Block Grant 280 9 - - - - - - - - - - - 9 35 27% Police Grants 292- - - - - - - - - - - - - - NA Police Academy 294 7,809 - - - - - - - - - - - 7,809 22,500 35% COPS More Grants 295 1,496 - - - - - - - - - - - 1,496 92,000 2% Drug Enforcement 299 164 - - - - - - - - - - - 164 51,000 0% K-9 Unit 705 7 - - - - - - - - - - - 7 2,020 0% Sub Total 677,322 - - - - - - - - - - - 677,322 8,110,894 8% Fire Department EMS Capital 287 1,088,873 - - - - - - - - - - - 1,088,873 585,000 186% EMS Operating Fund 288 322,278 - - - - - - - - - - - 322,278 5,186,384 6% Hazmat 289 64 - - - - - - - - - - - 64 10,200 1% River Rescue 291 7,495 - - - - - - - - - - - 7,495 45,500 16% Sub Total 1,418,710 - - - - - - - - - - - 1,418,710 5,827,084 24% Total Public Safety 2,096,032 - - - - - - - - - - - 2,096,032 13,937,978 15% Public Works Streets Motor Vehicle Highway 202 579,560 - - - - - - - - - - - 579,560 11,288,058 5% Local Roads & Streets 251 203,272 - - - - - - - - - - - 203,272 1,868,000 11% Local Road & Bridge Grant 265- - - - - - - - - - - - - - NA Project ReLeaf 655 39,153 - - - - - - - - - - - 39,153 445,800 9% Sub Total 821,986 - - - - - - - - - - - 821,986 13,601,858 6% Solid Waste Solid Waste Operations 610 430,160 - - - - - - - - - - - 430,160 5,474,191 8% Solid Waste Capital 611 96 - - - - - - - - - - - 96 1,077,506 0% Sub Total 430,256 - - - - - - - - - - - 430,256 6,551,697 7% Water Works 0000 Water Works Revenues 620 947,619 - - - - - - - - - - - 947,619 14,799,959 6% 0630 Water Leak Insurance 620 82,210 - - - - - - - - - - - 82,210 1,012,683 8% 0640 Water Works 620- - - - - - - - - - - - - - NA 0660 Clay Water 620 70,281 - - - - - - - - - - - 70,281 1,356,710 5% Waterworks Capital 622 5,129 - - - - - - - - - - - 5,129 25,000 21% Waterworks Deposit 624 3,630 - - - - - - - - - - - 3,630 15,000 24% Waterworks Sinking 625 166,918 - - - - - - - - - - - 166,918 2,009,217 8% Waterworks Bond Reserve 626 3,335 - - - - - - - - - - - 3,335 16,000 21% Waterworks Debt Reserve 629 58,511 - - - - - - - - - - - 58,511 23,000 254% Sub Total 1,337,633 - - - - - - - - - - - 1,337,633 19,257,569 7% Wastewater/Sewer/Organic Resources Sewer Repair Insurance 640 57,037 - - - - - - - - - - - 57,037 626,535 9% 0000 Wastewater Revenues 641 2,916,439 - - - - - - - - - - - 2,916,439 35,598,915 8% 0621 Sewer Department 641 760 - - - - - - - - - - - 760 2,500 30% 0625 Concrete Crew 641- - - - - - - - - - - - - 55,170 0% 0630 Wastewater Operations 641- - - - - - - - - - - - - - NA 0631 Organic Resources 641- - - - - - - - - - - - - - NA 0650 Clay Sewage 641 183,418 - - - - - - - - - - - 183,418 2,160,000 8% Sewage Capital 642 17,620 - - - - - - - - - - - 17,620 9,900,000 0% Sewage Reserve 643 12,344 - - - - - - - - - - - 12,344 35,000 35% Sewage Bond Sinking 649 1,899 - - - - - - - - - - - 1,899 9,179,379 0% Sewage Works DS Reserve 653- - - - - - - - - - - - - 14,700 0% 2011 Sewer Bond 659 0 - - - - - - - - - - - 0 - NA 2012 Sewer Bond 661 1,538 - - - - - - - - - - - 1,538 10,000 15% Sub Total 3,191,056 - - - - - - - - - - - 3,191,056 57,582,199 6% Total Public Works 5,780,930 - - - - - - - - - - - 5,780,930 96,993,323 6% Monthly Financial Report 8 of 24 City of South Bend Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: January 31, 2018 Capital & Debt Service Fund Hall of Fame 313- - - - - - - - - - - - - 1,258,617 0% Professional Sports Development 377 37 - - - - - - - - - - - 37 620,000 0% Coveleski Stadium 401 131 - - - - - - - - - - - 131 44,250 0% COIT 404 929,149 - - - - - - - - - - - 929,149 11,611,424 8% Cumulative Capital Development 406 1,336 - - - - - - - - - - - 1,336 459,200 0% Cumulative Capital Improvement 407 222,424 - - - - - - - - - - - 222,424 278,500 80% EDIT 408 923,177 - - - - - - - - - - - 923,177 11,285,625 8% UDAG 410 1,129 - - - - - - - - - - - 1,129 138,728 1% Major Moves 412 6,962 - - - - - - - - - - - 6,962 518,178 1% Morris PAC Improvement 416 2,516 - - - - - - - - - - - 2,516 129,000 2% Palais Historic Preservation 450 3,987 - - - - - - - - - - - 3,987 17,100 23% 2017 Parks Bond 471- - - - - - - - - - - - - 3,000 0% Hall of Fame Capital 677 1,076 - - - - - - - - - - - 1,076 5,000 22% Equipment / Vehicle Leasing 750 200 - - - - - - - - - - - 200 4,604,750 0% Parks Bond Capital 751- - - - - - - - - - - - - 4,500 0% Smart Street Bond Capital 753- - - - - - - - - - - - - 1,500 0% SB Building Corp 755- - - - - - - - - - - - - 2,636,025 0% Parks Bond Debt Svc 757- - - - - - - - - - - - - 379,907 0% Eddy St. Commons Capital 759- - - - - - - - - - - - - 2,000 0% Eddy St. Commons Debt 760- - - - - - - - - - - - - 1,279,472 0% Total Capital & Debt Service 2,092,124 - - - - - - - - - - - 2,092,124 35,276,776 6% Department of Community Investment Studebaker/Oliver 209 37,428 - - - - - - - - - - - 37,428 167,514 22% State Grant 210 3,321 - - - - - - - - - - - 3,321 75,887 4% DCI Operating 211 97,850 - - - - - - - - - - - 97,850 2,654,656 4% 0000 Dept. of Community Investment 212 2,443 - - - - - - - - - - - 2,443 2,929,387 0% 1013 Programs 212- - - - - - - - - - - - - - NA Economic Revenue Bond 281 67 - - - - - - - - - - - 67 200 33% Total Dept of Community Investment 141,109 - - - - - - - - - - - 141,109 5,827,644 2% Central Services Central Services 222 711,462 - - - - - - - - - - - 711,462 8,708,507 8% Central Services Capital 224 467 - - - - - - - - - - - 467 78,000 1% Total Central Services 711,930 - - - - - - - - - - - 711,930 8,786,507 8% Liability Insurance 0000 Business Insurance Revenues 226 188,502 - - - - - - - - - - - 188,502 2,098,123 9% 0403 Self Funded Liability Ins 226- - - - - - - - - - - - - - NA 0412 Liability Insurance 226- - - - - - - - - - - - - - NA 0417 Business Insurance 226- - - - - - - - - - - - - - NA 0418 Workers Compensation 226- - - - - - - - - - - - - 2,000 0% Total Liability Insurance 188,502 - - - - - - - - - - - 188,502 2,100,123 9% Code Enforcement Unsafe Building 219 8,297 - - - - - - - - - - - 8,297 908,773 1% Landlord Registration 221 55 - - - - - - - - - - - 55 6,000 1% 1201 Neighborhood Code Enforcement 600 34,861 - - - - - - - - - - - 34,861 542,891 6% 1207 Animal Care & Control 600 9,000 - - - - - - - - - - - 9,000 894,312 1% 1208 Rental Unit Inspection 600- - - - - - - - - - - - - 30,000 0% Total Code Enforcement 52,213 - - - - - - - - - - - 52,213 2,381,976 2% Building Department 1306 Building Dept Operations 600 80,975 - - - - - - - - - - - 80,975 1,395,552 6% Total Building Department 80,975 - - - - - - - - - - - 80,975 1,395,552 6% Monthly Financial Report 9 of 24 City of South Bend Revenue by Fund Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: January 31, 2018 Other Miscellaneous Rainy Day 102 24,622 - - - - - - - - - - - 24,622 80,000 31% Gift, Donation, Bequest 217 18,967 - - - - - - - - - - - 18,967 45,800 41% Loss Recovery 227 2,029 - - - - - - - - - - - 2,029 4,000 51% LOIT 2016 Special Distribution 257 1,967 - - - - - - - - - - - 1,967 2,240,000 0% Human Rights 258 11,146 - - - - - - - - - - - 11,146 167,400 7% IT / Innovation /311 Call Center 279 584,945 - - - - - - - - - - - 584,945 6,850,931 9% Sub Total 643,676 - - - - - - - - - - - 643,676 9,388,131 7% Fiduciary Trust & Agency Fire Pension 701 3,766 - - - - - - - - - - - 3,766 5,217,138 0% Police Pension 702 2,515 - - - - - - - - - - - 2,515 6,005,500 0% Employee Benefits 711 1,562,014 - - - - - - - - - - - 1,562,014 18,511,596 8% Unemployment Comp 713 542 - - - - - - - - - - - 542 2,000 27% Parental Leave Fund 714- - - - - - - - - - - - - 155,694 0% City Cemetery Trust 730 68 - - - - - - - - - - - 68 250 27% Sub Total 1,568,905 - - - - - - - - - - - 1,568,905 29,892,178 5% Total Other 2,212,581 - - - - - - - - - - - 2,212,581 39,280,309 6% Total Civil City 15,455,459 - - - - - - - - - - - 15,455,459 290,160,167 5% Redevelopment Funds Tax Increment Financing TIF River West - Airport 324 166,079 - - - - - - - - - - - 166,079 24,507,986 1% TIF West Washington 422 5,328 - - - - - - - - - - - 5,328 436,000 1% TIF Leighton Plaza 425 10,000 - - - - - - - - - - - 10,000 197,014 5% TIF River East DEV (NE)429 23,830 - - - - - - - - - - - 23,830 2,357,000 1% TIF Southside 430 18,064 - - - - - - - - - - - 18,064 2,463,000 1% TIF Erskine Village 432- - - - - - - - - - - - - - NA TIF Douglas Road 435 368 - - - - - - - - - - - 368 1,150 32% TIF River East RES (NE RE)436 5,385 - - - - - - - - - - - 5,385 4,405,500 0% Sub Total 229,054 - - - - - - - - - - - 229,054 34,367,650 1% Redevelopment Funds Administration 433 18 - - - - - - - - - - - 18 135 13% Certified Technology Park 439 1,469 - - - - - - - - - - - 1,469 2,500 59% Airport Urban Enterprise Zone 454 926 - - - - - - - - - - - 926 3,900 24% Industrial Revolving 754- - - - - - - - - - - - - 210,000 0% Sub Total 2,413 - - - - - - - - - - - 2,413 216,535 1% Debt Service Airport Debt Reserve 2003 315 2,489 - - - - - - - - - - - 2,489 14,000 18% Coveleski Bond Debt Reserve 317 1,239 - - - - - - - - - - - 1,239 5,000 25% Central Development reserve 328 4,160 - - - - - - - - - - - 4,160 20,000 21% SB Redevelopment Authority 752- - - - - - - - - - - - - 3,367,200 0% Smart Streets Debt Svc 756- - - - - - - - - - - - - 1,716,500 0% Sub Total 7,888 - - - - - - - - - - - 7,888 5,122,700 0% Total Redevelopment 239,354 - - - - - - - - - - - 239,354 39,706,885 1% Revenue Total 15,694,813 - - - - - - - - - - - 15,694,813 329,867,052 5% Monthly Financial Report 10 of 24 City of South Bend Property Tax Revenue 2017 Tax Pay 2018 Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected Total Property Tax Collection Fund Fund #Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 0.95 - - - - - - Parks & Recreation 201 0.95 - - - - - - College Football Hall of Fame 313 0.95 - - - - - - Cumulative Capital District 406 0.95 - - - - - - Total - City- - - - - - - - 0.00% Tax Increment Financing Airport TIF District 324 0.95 - - - - - - West Washington TIF District 422 0.95 - - - - - - Northeast Residential TIF District 436 0.95 - - - - - - Southside TIF District #1 430 0.95 - - - - - - Douglas Road TIF District 435 0.95 - - - - - - Northeast TIF 429 0.95 - - - - - - Total - Tax Increment Financing- - - - - - - - 0.00% Grand Total- - - - - - - - 0.00% Note(s) 2017 pay 2018 to be determined 2016 Tax Pay 2017 Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/20/2017 12/20/2017 Total Property Tax Collection Fund Fund #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 17,747,933.08 - - 39,568,075.59 680,791.41 98.31% Parks & Recreation 201 9,179,442.00 0.95 8,720,469.90 4,976,456.29 4,057,274.45 - - 9,033,730.74 145,711.26 98.41% College Football Hall of Fame 313 833,277.00 0.95 791,613.15 451,820.36 368,250.79 - - 820,071.15 13,205.85 98.42% Cumulative Capital District 406 443,869.00 0.95 421,675.55 240,635.07 196,188.32 - - 436,823.39 7,045.61 98.41% Total - City 50,705,455.00 48,170,182.25 27,489,054.23 22,369,646.64 - - 49,858,700.87 846,754.13 98.33% Tax Increment Financing Airport TIF District 324 18,698,946.24 0.95 17,763,998.93 8,932,881.19 8,327,020.81 - - 17,259,902.00 1,439,044.24 92.30% West Washington TIF District 422 367,557.18 0.95 349,179.32 198,151.66 180,841.94 - - 378,993.60 (11,436.42) 103.11% Northeast Residential TIF District 436 4,405,723.00 0.95 4,185,436.85 2,320,321.06 1,942,596.42 - - 4,262,917.48 142,805.52 96.76% Southside TIF District #1 430 2,390,790.99 0.95 2,271,251.44 1,216,823.61 1,148,868.40 - - 2,365,692.01 25,098.98 98.95% Douglas Road TIF District 435 321,949.68 0.95 305,852.20 218,279.99 160,974.84 - - 379,254.83 (57,305.15) 117.80% Northeast TIF 429 2,766,113.25 0.95 2,627,807.59 1,428,045.99 1,202,840.55 - - 2,630,886.54 135,226.71 95.11% Total - Tax Increment Financing 28,951,080.34 27,503,526.32 14,314,503.50 12,963,142.96 - - 27,277,646.46 1,673,433.88 94.22% Grand Total 79,656,535.34 75,673,708.57 41,803,557.73 35,332,789.60 - - 77,136,347.33 2,520,188.01 96.84% Note(s) Distribution 1 - Issued by St. Joseph County on 6/20/17 Distribution 2 - Issued by St. Joseph County on 12/20/17 Period Ending: January 31, 2018 Monthly Financial Report 11 of 24 City of South Bend Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Fund General Government 0101 Mayor 101 66,242 - - - - - - - - - - - 66,242 908,142 7% 0201 Clerk 101 41,465 - - - - - - - - - - - 41,465 573,553 7% 0301 Common Council 101 47,784 - - - - - - - - - - - 47,784 670,013 7% 0302 WNIT Contract 101- - - - - - - - - - - - - 43,000 0% 0401 Administration and Finance 101 181,515 - - - - - - - - - - - 181,515 2,639,826 7% 0501 Legal 101 80,972 - - - - - - - - - - - 80,972 1,200,973 7% Sub Total 417,977 - - - - - - - - - - - 417,977 6,035,507 7% Public Works 0602 Engineering 101 97,206 - - - - - - - - - - - 97,206 1,750,084 6% Sub Total 97,206 - - - - - - - - - - - 97,206 1,750,084 6% Public Safety 0801 Police 101 2,553,505 - - - - - - - - - - - 2,553,505 29,626,242 9% 0901 Fire 101 1,702,483 - - - - - - - - - - - 1,702,483 21,439,343 8% Sub Total 4,255,987 - - - - - - - - - - - 4,255,987 51,065,585 8% Arts & Culture 0404 Morris PAC 101 66,022 - - - - - - - - - - - 66,022 1,320,791 5% 0405 Palais Royale 101 24,590 - - - - - - - - - - - 24,590 541,428 5% Sub Total 90,612 - - - - - - - - - - - 90,612 1,862,219 5% Human Rights 1008 Human Rights 101 24,673 - - - - - - - - - - - 24,673 447,133 6% Sub Total 24,673 - - - - - - - - - - - 24,673 447,133 6% Total General Fund Revenue 4,886,455 - - - - - - - - - - - 4,886,455 61,160,528 8% Venues, Parks & Arts Parks & Recreation 1100 Administration 201 106,755 - - - - - - - - - - - 106,755 1,227,968 9% 1101 Maintenance 201 443,597 - - - - - - - - - - - 443,597 7,184,730 6% 1102 Golf Operations 201 56,591 - - - - - - - - - - - 56,591 1,588,326 4% 1103 Recreation Division 201 136,104 - - - - - - - - - - - 136,104 2,181,005 6% 1104 Potawatomi Zoo 201 8,216 - - - - - - - - - - - 8,216 700,000 1% 1106 Potawatomi Greenhouse 201 5,430 - - - - - - - - - - - 5,430 46,602 12% 1108 Graffiti Removal 201 7,388 - - - - - - - - - - - 7,388 106,459 7% 1110 Marketing and Events 201 68,206 - - - - - - - - - - - 68,206 1,269,263 5% 1111 Regional Cities Grant 201 28,510 - - - - - - - - - - - 28,510 2,113,595 1% Recreation Non Reverting 203 49,052 - - - - - - - - - - - 49,052 1,616,634 3% Morris Palais Marketing 273- - - - - - - - - - - - - 18,000 0% Morris PAC Self-Promotion 274- - - - - - - - - - - - - 50,000 0% Zoo Endowment 403- - - - - - - - - - - - - - NA Park Non-Reverting 405 38,340 - - - - - - - - - - - 38,340 232,872 16% Sub Total 948,190 - - - - - - - - - - - 948,190 18,335,454 5% Parking Garages 0400 Parking Garage Administration 601 60,725 - - - - - - - - - - - 60,725 - NA 0460 Main Street 601 4,706 - - - - - - - - - - - 4,706 311,768 2% 0462 Leighton Plaza 601 5,884 - - - - - - - - - - - 5,884 452,307 1% 0463 Enforcement 601 416 - - - - - - - - - - - 416 104,632 0% 0464 Wayne Street 601 4,405 - - - - - - - - - - - 4,405 291,637 2% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,000 0% Sub Total 76,136 - - - - - - - - - - - 76,136 1,175,344 6% Century Center Century Center Operations 670 301,878 - - - - - - - - - - - 301,878 4,557,114 7% Century Center Capital 671- - - - - - - - - - - - - - NA Century Center Energy Saving 672- - - - - - - - - - - - - 306,737 0% Sub Total 301,878 - - - - - - - - - - - 301,878 4,863,851 6% Total Venues, Parks & Arts 1,326,204 - - - - - - - - - - - 1,326,204 24,374,649 5% Period Ending: January 31, 2018 Monthly Financial Report 12 of 24 City of South Bend Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: January 31, 2018 Public Safety Police Department Police Seizures 216- - - - - - - - - - - - - 32,000 0% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 57,873 - - - - - - - - - - - 57,873 594,624 10% Public Safety LOIT 249 491,276 - - - - - - - - - - - 491,276 7,622,970 6% Police Take Home Vehicle 278- - - - - - - - - - - - - 10,000 0% Police Block Grant 280- - - - - - - - - - - - - - NA Police Grants 292- - - - - - - - - - - - - - NA Police Academy 294 3,362 - - - - - - - - - - - 3,362 22,500 15% COPS More Grants 295 26,202 - - - - - - - - - - - 26,202 112,785 23% Drug Enforcement 299- - - - - - - - - - - - - 51,000 0% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 578,714 - - - - - - - - - - - 578,714 8,448,899 7% Fire Department EMS Capital 287 232,138 - - - - - - - - - - - 232,138 3,078,454 8% EMS Operating Fund 288 451,202 - - - - - - - - - - - 451,202 6,431,746 7% Hazmat 289- - - - - - - - - - - - - 10,000 0% River Rescue 291 620 - - - - - - - - - - - 620 101,800 1% Sub Total 683,959 - - - - - - - - - - - 683,959 9,622,000 7% Total Public Safety 1,262,673 - - - - - - - - - - - 1,262,673 18,070,899 7% Public Works Streets Motor Vehicle Highway 202 929,501 - - - - - - - - - - - 929,501 12,387,981 8% Local Roads & Streets 251- - - - - - - - - - - - - 3,088,508 0% Local Road & Bridge Grant 265 900 - - - - - - - - - - - 900 437,632 0% Project ReLeaf 655 3,267 - - - - - - - - - - - 3,267 702,042 0% Sub Total 933,668 - - - - - - - - - - - 933,668 16,616,163 6% Solid Waste Solid Waste Operations 610 353,032 - - - - - - - - - - - 353,032 5,496,049 6% Solid Waste Capital 611 185,219 - - - - - - - - - - - 185,219 1,076,706 17% Sub Total 538,251 - - - - - - - - - - - 538,251 6,572,755 8% Water Works 0630 Water Leak Insurance 620 26,512 - - - - - - - - - - - 26,512 1,035,000 3% 0640 Water Works 620 1,352,132 - - - - - - - - - - - 1,352,132 16,979,530 8% 0660 Clay Water 620 104 - - - - - - - - - - - 104 3,500 3% Waterworks Capital 622 1,642 - - - - - - - - - - - 1,642 1,578,570 0% Waterworks Deposit 624 1,289 - - - - - - - - - - - 1,289 15,000 9% Waterworks Sinking 625 1,279 - - - - - - - - - - - 1,279 2,009,217 0% Waterworks Bond Reserve 626- - - - - - - - - - - - - 16,000 0% Waterworks Debt Reserve 629 2,225 - - - - - - - - - - - 2,225 23,000 10% Sub Total 1,385,183 - - - - - - - - - - - 1,385,183 21,659,817 6% Wastewater/Sewer/Organic Resources Sewer Repair Insurance 640 21,863 - - - - - - - - - - - 21,863 632,224 3% 0621 Sewer Department 641 459,002 - - - - - - - - - - - 459,002 9,874,691 5% 0625 Concrete Crew 641 34,892 - - - - - - - - - - - 34,892 484,265 7% 0630 Wastewater Operations 641 1,548,265 - - - - - - - - - - - 1,548,265 37,870,668 4% 0631 Organic Resources 641 231,119 - - - - - - - - - - - 231,119 1,670,534 14% 0650 Clay Sewage 641 283 - - - - - - - - - - - 283 250 113% Sewage Capital 642 349,920 - - - - - - - - - - - 349,920 12,314,553 3% Sewage Reserve 643 4,386 - - - - - - - - - - - 4,386 35,000 13% Sewage Bond Sinking 649 1,000 - - - - - - - - - - - 1,000 9,156,379 0% Sewage Works DS Reserve 653- - - - - - - - - - - - - - NA 2011 Sewer Bond 659- - - - - - - - - - - - - - NA 2012 Sewer Bond 661- - - - - - - - - - - - - 642,186 0% Sub Total 2,650,730 - - - - - - - - - - - 2,650,730 72,680,750 4% Total Public Works 5,507,832 - - - - - - - - - - - 5,507,832 117,529,485 5% Monthly Financial Report 13 of 24 City of South Bend Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: January 31, 2018 Capital & Debt Service Fund Hall of Fame 313 633,000 - - - - - - - - - - - 633,000 1,258,617 50% Professional Sports Development 377 361,390 - - - - - - - - - - - 361,390 814,870 44% Coveleski Stadium 401- - - - - - - - - - - - - 145,000 0% COIT 404 651,760 - - - - - - - - - - - 651,760 11,726,673 6% Cumulative Capital Development 406 195,231 - - - - - - - - - - - 195,231 459,200 43% Cumulative Capital Improvement 407 249,500 - - - - - - - - - - - 249,500 278,500 90% EDIT 408 170,329 - - - - - - - - - - - 170,329 12,068,344 1% UDAG 410- - - - - - - - - - - - - 610,131 0% Major Moves 412 979 - - - - - - - - - - - 979 3,155,452 0% Morris PAC Improvement 416- - - - - - - - - - - - - 109,500 0% Palais Historic Preservation 450- - - - - - - - - - - - - 45,000 0% 2017 Parks Bond 471- - - - - - - - - - - - - 10,309,100 0% Hall of Fame Capital 677 5,294 - - - - - - - - - - - 5,294 129,227 4% Equipment / Vehicle Leasing 750- - - - - - - - - - - - - 7,590,534 0% Parks Bond Capital 751- - - - - - - - - - - - - 3,045,118 0% Smart Street Bond Capital 753- - - - - - - - - - - - - 2,101,500 0% SB Building Corp 755- - - - - - - - - - - - - 2,636,025 0% Parks Bond Debt Svc 757- - - - - - - - - - - - - 380,107 0% Eddy St. Commons Capital 759- - - - - - - - - - - - - 39,103,750 0% Eddy St. Commons Debt 760- - - - - - - - - - - - - 3,779,472 0% Total Capital & Debt Service 2,267,482 - - - - - - - - - - - 2,267,482 99,746,120 2% Department of Community Investment Studebaker/Oliver 209 14,869 - - - - - - - - - - - 14,869 1,041,098 1% State Grant 210- - - - - - - - - - - - - 257,133 0% DCI Operating 211 199,829 - - - - - - - - - - - 199,829 3,077,096 6% Programs 212 242,431 - - - - - - - - - - - 242,431 5,874,598 4% Economic Revenue Bond 281- - - - - - - - - - - - - - NA Total Dept of Community Investment 457,129 - - - - - - - - - - - 457,129 10,249,925 4% Central Services 0605 Equipment Services 222 255,181 - - - - - - - - - - - 255,181 3,072,612 8% 0606 Building Maintenance 222 17,233 - - - - - - - - - - - 17,233 213,832 8% 0612 Central Stores 222 19,345 - - - - - - - - - - - 19,345 236,428 8% 0613 Print Shop 222 10,612 - - - - - - - - - - - 10,612 192,329 6% 0614 Radio Shop 222 22,971 - - - - - - - - - - - 22,971 336,927 7% 0616 Energy/Sustainability 222 15,261 - - - - - - - - - - - 15,261 370,560 4% 0617 Electric & Gas Utilities 222 363,766 - - - - - - - - - - - 363,766 4,375,000 8% Central Services Capital 224 22,614 - - - - - - - - - - - 22,614 155,036 15% Total Central Services 726,982 - - - - - - - - - - - 726,982 8,952,724 8% Liability Insurance 0403 Self Funded Liability Ins 226 19,540 - - - - - - - - - - - 19,540 262,724 7% 0412 Liability Insurance 226 43,410 - - - - - - - - - - - 43,410 1,158,406 4% 0417 Business Insurance 226 18,256 - - - - - - - - - - - 18,256 665,269 3% 0418 Workers Compensation 226 59,655 - - - - - - - - - - - 59,655 680,717 9% Total Liability Insurance 140,861 - - - - - - - - - - - 140,861 2,767,116 5% Code Enforcement Unsafe Building 219 54,128 - - - - - - - - - - - 54,128 972,413 6% Landlord Registration 221- - - - - - - - - - - - - 1,000 0% 1201 Neighborhood Code Enforcement 600 176,422 - - - - - - - - - - - 176,422 1,835,827 10% 1207 Animal Care & Control 600 62,449 - - - - - - - - - - - 62,449 968,596 6% 1208 Rental Unit Inspection 600- - - - - - - - - - - - - 180,000 0% Total Code Enforcement 292,999 - - - - - - - - - - - 292,999 3,957,836 7% Monthly Financial Report 14 of 24 City of South Bend Expenditure Report Fund% Division Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Period Ending: January 31, 2018 Building Department 1306 Building Dept Operations 600 171,357 - - - - - - - - - - - 171,357 1,658,827 10% Total Building Department 171,357 - - - - - - - - - - - 171,357 1,658,827 10% Other Miscellaneous Gift, Donation, Bequest 217 3,461 - - - - - - - - - - - 3,461 46,161 7% Loss Recovery 227 107,957 - - - - - - - - - - - 107,957 515,323 21% LOIT 2016 Special Distribution 257 82,709 - - - - - - - - - - - 82,709 4,113,349 2% Human Rights 258 14,012 - - - - - - - - - - - 14,012 163,234 9% IT / Innovation /311 Call Center 279 235,061 - - - - - - - - - - - 235,061 7,155,112 3% Sub Total 443,200 - - - - - - - - - - - 443,200 11,993,179 4% Fiduciary Trust & Agency Fire Pension 701 373,509 - - - - - - - - - - - 373,509 5,112,457 7% Police Pension 702 593,204 - - - - - - - - - - - 593,204 6,583,452 9% Employee Benefits 711 1,436,330 - - - - - - - - - - - 1,436,330 18,145,518 8% Unemployment Comp 713- - - - - - - - - - - - - 80,000 0% Parental Leave Fund 714- - - - - - - - - - - - - 155,694 0% City Cemetery Trust 730- - - - - - - - - - - - - 25,000 0% Sub Total 2,403,043 - - - - - - - - - - - 2,403,043 30,102,121 8% Total Other 2,846,243 - - - - - - - - - - - 2,846,243 42,095,300 7% Total Civil City 19,886,217 - - - - - - - - - - - 19,886,217 390,563,409 5% Redevelopment Funds Tax Increment Financing TIF River West - Airport 324 3,981,156 - - - - - - - - - - - 3,981,156 45,356,182 9% TIF West Washington 422- - - - - - - - - - - - - 1,885,916 0% TIF Leighton Plaza 425 7,611 - - - - - - - - - - - 7,611 158,166 5% TIF River East DEV (NE)429 303,011 - - - - - - - - - - - 303,011 7,587,691 4% TIF Southside 430 3,188 - - - - - - - - - - - 3,188 7,556,026 0% TIF Erskine Village 432- - - - - - - - - - - - - - NA TIF Douglas Road 435- - - - - - - - - - - - - 144,650 0% TIF River East RES (NE RE)436 1,234,500 - - - - - - - - - - - 1,234,500 4,320,000 29% Sub Total 5,529,466 - - - - - - - - - - - 5,529,466 67,008,631 8% Redevelopment Funds Administration 433- - - - - - - - - - - - - 4,500 0% Certified Technology Park 439- - - - - - - - - - - - - - NA Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Industrial Revolving 754- - - - - - - - - - - - - 157,000 0% Sub Total- - - - - - - - - - - - - 211,500 0% Debt Service Airport Debt Reserve 2003 315 884 - - - - - - - - - - - 884 14,000 6% Coveleski Bond Debt Reserve 317- - - - - - - - - - - - - - NA Central Development reserve 328 1,478 - - - - - - - - - - - 1,478 20,000 7% SB Redevelopment Authority 752- - - - - - - - - - - - - 3,365,829 0% Smart Streets Debt Svc 756- - - - - - - - - - - - - 1,709,794 0% Sub Total 2,362 - - - - - - - - - - - 2,362 5,109,623 0% Total Redevelopment 5,531,828 - - - - - - - - - - - 5,531,828 72,329,754 8% Total Expenditures 25,418,045 - - - - - - - - - - - 25,418,045 462,893,163 5% Monthly Financial Report 15 of 24 1st 2nd 3rd 4th Civil City Debt Capital Leases 110 2013 PNC Vehicle & Equipment Lease Vehicl es/E qu i pment 2013 N/A 2018 Various 1/15 7/15----1,689,669.59 346,724.77 346,724.77 3,175.76 - 349,900.53 112 2013 Building Department Ricoh Co pier Copi er Leas e 2013 N/A 2018 600 Monthly 26th----4,093.64 613.22 613.22 12.80 - 626.02 113 2013 Sunt rust Vehicle Lease Vehicl es/E qu i pment 2013 N/A 2018 Various 4/24 10/24----1,506,465.26 310,880.69 310,880.69 3,700.46 - 314,581.15 114 2013 Adm inis tration & Finance Rico h Copier Copi er Leas e 2013 N/A 2018 101 1/16 4/16 7/16 10/16 11,247.97 634.57 634.57 9.23 - 643.80 117 2013 Police Department Records Div isio n Ricoh Copier Copi er Leas e 2013 N/A 2018 101 Monthly 3rd----9,678.26 2,154.91 2,154.91 65.09 - 2,220.00 118 2013 W at er Works Ma i n Street Ricoh Copier Copi er Leas e 2013 N/A 2018 620 Monthly 10th----5,647.50 1,258.33 1,258.33 38.07 - 1,296.40 119 2013 W at er Works Colfax Ricoh Copier Copi er Leas e 2013 N/A 2018 620 Monthly 16th----4,732.65 1,054.61 1,054.61 31.91 - 1,086.52 120 2013 W at er Works Olive Street Ricoh C opier Copi er Leas e 2013 N/A 2018 620 Monthly 10th----4,732.65 1,054.61 1,054.61 31.91 - 1,086.52 123 2014 Police Department Training Ricoh Copier Copi er Leas e 2014 N/A 2019 101 Monthly 30th----4,263.00 1,186.17 941.47 42.53 244.70 984.00 124 2014 Police & Public Wor ks Vehicles Vehicl es/E qu i pment 2014 N/A 2019 Various 4/1 10/1----1,959,485.95 801,993.28 397,900.73 10,895.81 404,092.55 408,796.54 125 2014 HP Computer L ease #1 Computer Leases 2014 N/A 2018 Various Monthly 8th----137,104.95 28,106.43 28,106.43 632.09 - 28,738.52 126 2014 HP Computer L ease #2 Computer Leases 2014 N/A 2018 Various Monthly 8th----4,000.00 915.42 915.42 22.56 - 937.98 127 2014 HP Computer L ease #4 Computer Leases 2014 N/A 2018 279 Monthly 8th----5,886.73 1,262.39 1,262.39 21.61 - 1,284.00 128 2014 HP Computer L ease #6 Computer Leases 2014 N/A 2018 201 Monthly 8th----3,755.50 959.08 959.08 23.80 - 982.88 129 2014 HP Computer L ease #7 Computer Leases 2014 N/A 2018 620 Monthly 8th----1,326.00 363.78 363.78 7.96 - 371.74 130 2014 Solid Waste Ricoh Copier Copi er Leas e 2014 N/A 2019 611 Monthly 17th----5,351.65 2,230.54 1,133.42 96.22 1,097.12 1,229.64 131 2014 Police Com mun i cations Copier Copi er Leas e 2014 N/A 2019 101 Monthly 12th----8,843.00 3,072.55 1,908.18 123.66 1,164.37 2,031.84 132 2014 Ricoh Copiers Copi er Leas e 2014 N/A 2019 641 Monthly 21st----12,260.16 4,044.71 2,657.97 159.05 1,386.74 2,817.02 134 2014 W at er Works Ri coh C op i er Copi er Leas e 2014 N/A 2019 620 Monthly 19th----4,732.65 1,139.81 1,048.77 36.75 91.04 1,085.52 136 2015 HP Computer L ease #8 Computer Leases 2015 N/A 2019 Various Monthly 16th----19,603.94 6,927.09 4,384.24 228.94 2,542.85 4,613.18 137 2015 Anim al Care & Cont rol Ricoh Copier Copi er Leas e 2015 N/A 2020 600 Monthly 30th----5,261.50 2,558.51 1,095.38 120.46 1,463.13 1,215.84 138 2015 HP Computer L ease #9 Computer Leases 2015 N/A 2019 Various Monthly------135,958.05 63,804.73 32,473.02 2,431.38 31,331.71 34,904.40 140 2015 Vehicl e/Equip Lease No. 1 Vehicl es/E qu i pment 2015 N/A 2020 Various 1/15 7/15----3,425,273.58 2,087,121.85 686,127.96 26,537.40 1,400,993.89 712,665.36 143 2015 HP Computer L ease #1 1 Computer Leases 2015 N/A 2019 279 Monthly------3,040.00 1,465.29 728.78 52.66 736.51 781.44 144 2015 Vehicl e Lease No. 2 Vehicl es/E qu i pment 2015 N/A 2020 Various 5/15 11/15----1,267,183.00 772,239.72 253,474.52 10,920.36 518,765.20 264,394.88 146 2015 Ricoh Copier - Parks Copi er Leas e 2015 N/A 2020 201 Monthly------4,302.06 2,644.67 857.61 129.03 1,787.06 986.64 147 2016 Cent ral Services - P rint Shop Copi er Copi er Leas e 2016 N/A 2020 222 Monthly------32,525.00 22,620.32 6,374.04 1,041.72 16,246.28 7,415.76 148 2016 Cent ral Services - P rint Shop Copi er Copi er Leas e 2016 N/A 2020 222 Monthly------11,413.00 7,937.47 2,236.63 365.57 5,700.84 2,602.20 149 2016 Vehicl e/Equip Lease No. 1 Vehicl es/E qu i pment 2016 N/A 2021 Various 2/15 8/15----3,339,830.00 2,364,700.45 662,240.83 35,152.79 1,702,459.62 697,393.62 150 2016 HP Computer L ease #1 2 Computer Leases 2016 N/A 2020 Various Monthly------17,439.85 10,105.08 4,096.37 386.83 6,008.71 4,483.20 151 2016 Adm inis tration & Finance Copier Copi er Leas e 2016 N/A 2021 101 Monthly------10,923.63 6,891.18 2,167.29 337.95 4,723.89 2,505.24 152 2016 Vehicl e/Equip Lease No. 2 Vehicl es/E qu i pment 2016 N/A 2021 Various 1/14 7/14----3,992,548.72 3,222,157.09 787,307.33 46,068.99 2,434,849.76 833,376.32 153 2016 Vehicl e/Equip Lease Am endment No. 1 Vehicl es/E qu i pment 2016 N/A 2021 201 1/17 7/17----78,808.00 63,520.71 15,520.85 907.95 47,999.86 16,428.80 154 2016 Vehicl e/Equip Lease No. 3 Vehicl es/E qu i pment 2016 N/A 2021 Various 4/19 10/19----1,256,096.99 1,012,026.89 247,371.35 14,237.21 764,655.54 261,608.56 155 2016 HP Computer L ease #1 3 Computer Leases 2016 N/A 2020 Various Monthly------156,029.30 116,995.36 35,245.46 4,936.18 81,749.90 40,181.64 157 2016 Ricoh Copier MPC2003 Copi er Leas e 2016 N/A 2021 201 Monthly----3,184.06 2,265.55 615.22 165.38 1,650.33 780.60 158 2017 Vehicl e/Equip Lease No. 1 Vehicl es/E qu i pment 2017 N/A 2022 Various 1/14 7/14----2,916,500.00 2,916,500.00 547,141.56 73,158.44 2,369,358.44 620,300.00 159 2017 Ricoh Copiers L ease Copi er Leas e 2017 N/A 2021 Various Monthly------15,702.09 12,417.04 3,729.79 773.57 8,687.25 4,503.36 160 2017 HP Computer L ease #1 4 Computer Leases 2017 N/A 2021 Various Monthly------10,305.25 8,452.80 2,317.66 337.22 6,135.14 2,654.88 162 2017 Vehicl e/Equip Lease No. 2 Vehicl es/E qu i pment 2017 N/A 2022 404 2/15 8/15----1,632,000.00 1,632,000.00 314,247.00 27,763.50 1,317,753.00 342,010.50 164 2017 HP Computer L ease #1 6 Computer Leases 2017 N/A 2021 Various Monthly 21st----108,921.75 101,278.63 23,670.40 4,316.12 77,608.23 27,986.52 T otal City Capital L ea se De bt 23,826,126.88 15,946,280.30 4,734,996.64 269,496.92 11,211,283.66 5,004,493.56 Bon ds 25 2002/2012 Ref un ding Water W orks Impro vements Various W ater Department projects 2002 2012 2023 625 1/1 7/1--5,975,000.00 2,005,000.00 380,000.00 40,100.00 1,625,000.00 420,100.00 36 2001 Public Wor ks Service Center (Bldg Corp) (87.7%)Public W or ks Service Center 2001 2010 2021 324 2/1 8/1--8,112,250.00 1,911,860.00 521,815.00 67,331.00 1,390,045.00 589,146.00 36 2001 Public Wor ks Service Center (Bldg Corp) (12.3%)Public W or ks Service Center 2001 2010 2021 641 2/1 8/1--1,137,750.00 268,140.00 73,185.00 9,444.00 194,955.00 82,629.00 39 2012 Fir e St ation/Poli ce Department Renov ations (Bldg Corp)New Cen tral Fire and Police buildings 2003 2012 2023 324 2/1 8/1--21,335,000.00 7,645,000.00 1,280,000.00 284,520.00 6,365,000.00 1,564,520.00 69 2009 W at er Works I m provements, Series B Various W ater Department projects 2009 N/A 2030 625 1/1 7/1--5,380,000.00 4,085,000.00 250,000.00 227,961.00 3,835,000.00 477,961.00 80 2010 Sewage Works Revenue Bonds Various W ast ewater Dep ar tment pr ojects 2010 N/A 2030 649 6/1 12/1--9,345,000.00 6,750,000.00 405,000.00 282,817.50 6,345,000.00 687,817.50 93 2011 Sewage Works Revenue Bonds W as tewater Long Term Cont rol Plan 2011 N/A 2031 649 6/1 12/1--21,500,000.00 16,400,000.00 920,000.00 627,450.00 15,480,000.00 1,547,450.00 99 2012 W at er Works Revenue Bond W at er Works Im provements 2012 N/A 2033 625 1/1 7/1----8,300,000.00 6,570,000.00 360,000.00 202,686.26 6,210,000.00 562,686.26 101 2012 Sewage Works Revenue Bonds W as tewater Long Term Cont rol Plan 2012 N/A 2032 649 6/1 12/1--25,000,000.00 19,830,000.00 1,075,000.00 465,480.00 18,755,000.00 1,540,480.00 105 2013A Sewage Works Revenue Bonds W as tewater Long Term Cont rol Plan 2013 N/A 2024 649 6/1 12/1--14,765,000.00 6,095,000.00 1,995,000.00 118,243.00 4,100,000.00 2,113,243.00 116 2013 Building Co rporat i on EMS Fire Station/Tower Bon ds Fir e St ation #5 & Trainin g Tower 2013 N/A 2033 287 2/1 8/1----5,580,000.00 4,920,000.00 225,000.00 170,730.00 4,695,000.00 395,730.00 133 2014 St. Joseph County PSAP (E DIT)City's share of PSAP building 2014 N/A 2034 408 Monthly Last----2,657,696.50 2,278,855.00 130,635.00 68,331.18 2,148,220.00 198,966.18 141 2015 EDIT/Parks Bonds Park s Improvem en ts 2015 N/A 2035 408 2/1 8/1----5,605,000.00 5,190,000.00 210,000.00 169,106.26 4,980,000.00 379,106.26 145 2015 Sewage Works Refu nd i ng Bo nd s Sewer Bond Improvements 2015 2015 2025 649 6/1 12/1----27,440,000.00 22,435,000.00 2,585,000.00 448,700.00 19,850,000.00 3,033,700.00 156 2016 W at erworks Refunding Bonds W at er Bond Refunding 2016 N/A 2027 625 1/1 7/1----3,300,000.00 2,895,000.00 420,000.00 86,850.00 2,475,000.00 506,850.00 161 2017 Economic Dev elo p. Reven ue Bonds (Studebak er Project)Façade Improvements - Buidling 84 2017 N/A 2018 324 One Time------3,500,000.00 3,500,000.00 3,500,000.00 - - 3,500,000.00 163 2017 Eddy Street Commons Phase II Eddy Street Commons Phase II 2017 N/A 2037 436 2/15 8/15----25,000,000.00 25,000,000.00 25,000.00 1,253,472.00 24,975,000.00 1,278,472.00 165 2017 Park District Bonds, Series 2017A-K Projects to improve City parks 2017 N/A 2033 312 1/15 7/15----14,075,000.00 14,075,000.00 350,000.00 243,303.69 13,725,000.00 593,303.69 T otal City Bond D ebt 208,007,696.50 151,853,855.00 14,705,635.00 4,766,525.89 137,148,220.00 19,472,160.89 Interfund Loan 82 2010 Interf und Fund 404 to UDAG Fund 410 1st Source Bank/Mar riott Garage Project 2010 N/A 2026 410 6/15 12/15--2,700,000.00 966,334.50 132,618.30 - 833,716.20 132,618.30 84 2011/2013 Major Moves-Triangle Development In terfund L oa n Tri angle Development Infr astructure 2011 2011/2013 2029 436 2/15 8/15--1,558,050.00 1,234,877.14 96,675.43 24,216.57 1,138,201.71 120,892.00 85 2011/2013 Major Moves-Ed dy Str eet Com m ons I nterfund Loan Tri angle Development Infr astructure 2011 2011/2013 2026 436 2/15 8/15--3,942,529.00 1,922,964.03 279,741.40 92,694.60 1,643,222.63 372,436.00 142 2016 Interf und Fund 412 to Parki ng Gar age Fund 601 Park i ng G arage Im prov ements 2016 N/A 2022 601 June Dec----1,511,331.00 31,191.33 31,191.33 - - 31,191.33 T otal City In terfund Loan Debt 9,711,910.00 4,155,367.00 540,226.46 116,911.17 3,615,140.54 657,137.63 L oan Payable 68 2009 W at er Works I m provements - S tate Revolving Fund Various W ater Department projects 2009 N/A 2030 625 1/1 7/1--427,400.00 311,650.00 21,617.00 10,502.60 290,033.00 32,119.60 70 2009 Sewage Works Revenue Bonds - State Revol ving Fu nd Various W ast ewater Dep ar tment pr ojects 2009 N/A 2028 649 6/1 12/1--3,297,000.00 2,087,171.00 167,038.00 58,650.00 1,920,133.00 225,688.00 122 2014 Synago gu e I nstallment Purchas e Agreement Impr ovem ents at Synagog ue - Coveleski 2014 N/A 2018 377 Annual 1/31----500,000.00 100,000.00 100,000.00 - - 100,000.00 139 2015 Cent ury C enter En er gy QECB Co nserv ation Bond Imro vements at Cent ury C enter 2015 N/A 2031 672 5/1 11/1----4,167,897.00 4,098,706.00 162,702.00 143,034.35 3,936,004.00 305,736.35 T otal City Loan Payable De bt 8,392,297.00 6,597,527.00 451,357.00 212,186.95 6,146,170.00 663,543.95 T otal Civil City Debt 249,938,030.38 178,553,029.30 20,432,215.10 5,365,120.93 158,120,814.20 25,797,336.03 Scheduled PaymentsD ebt Sche d. Period Ending: January 31, 2018 Debt Instrument Debt Purpose Year of Issue Year of Refinance Year of M aturity Fund No. Amount Issued Debt at 12/31/17 2018 Principal Payments 2018 Interest Payments City of South Bend Outstanding Debt Debt at 12/31/18 2018 Total Debt Payments Monthl y Financial Report 16 of 24 1st 2nd 3rd 4th Scheduled PaymentsD ebt Sche d. Period Ending: January 31, 2018 Debt Instrument Debt Purpose Year of Issue Year of Refinance Year of M aturity Fund No. Amount Issued Debt at 12/31/17 2018 Principal Payments 2018 Interest Payments City of South Bend Outstanding Debt Debt at 12/31/18 2018 Total Debt Payments Re development Comm ission Debt Capital Leases 13 2006 Main/Colfax Ga rage - T ranspo Lease Real Estate Purchas e 2006 N/A 2025 324 3/15 9/15--2,510,278.00 1,305,501.00 136,409.00 63,591.00 1,169,092.00 200,000.00 T otal Re development Capital Lea se De bt 2,510,278.00 1,305,501.00 136,409.00 63,591.00 1,169,092.00 200,000.00 Interfund Loans 86 2010 Interf und Fund 209 to Airport TIF Fund 324 Prairie Avenue - Br ownfields Clean up Loan 2011 N/A 2020 324 8/9----500,000.00 300,000.00 100,000.00 - 200,000.00 100,000.00 T otal Re development Inte rfund Loan Debt 500,000.00 300,000.00 100,000.00 - 200,000.00 100,000.00 L oan s Payable 3 2001 Ind i ana Development Finance Aut horit y (Bos ch) - Nonforgivable Rehabil i tate Pro perty 2001 N/A 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 238,409.07 65,591.47 6,418.97 172,817.60 72,010.44 4 2001 Ind i ana Development Finance Aut horit y (Bos ch) - Forgi vable Rehabil i tate Pro perty 2001 N/A 2021 210----260,000.00 65,888.51 - - 65,888.51 - T otal Re development Loan P ay able De bt 1,300,000.00 304,297.58 65,591.47 6,418.97 238,706.11 72,010.44 Re ve nue Bonds 5 2011 Sout h Bend Downtown Centr al Development Area TIF Public Improvements 2003 2011 2024 420/324 2/1 8/1--19,795,000.00 11,185,000.00 1,375,000.00 537,541.00 9,810,000.00 1,912,541.00 6 2011 Airport Development Area TIF Public Improvements 2003 2011 2024 324 2/1 8/1--14,420,000.00 6,375,000.00 790,000.00 306,305.50 5,585,000.00 1,096,305.50 7 2011 Cent ury C enter L ease Rental Revenue Rehabil i tation of a convention center 1994 2001, 2011 2018 404/407 2/1 8/1--6,825,000.00 245,000.00 245,000.00 3,675.00 - 248,675.00 8 2011 College Football Hall of Fame Const ruction Constr uction of a building 1994 2000, 2011 2018 313 2/1 8/1--15,370,000.00 620,000.00 620,000.00 11,315.00 - 631,315.00 12 2002 TJX S pecial Taxing District (Ref un ded 2014)Public Improvements 2002 2014 2022 324 1/1 7/1--6,620,000.00 1,795,000.00 430,000.00 53,850.00 1,365,000.00 483,850.00 54 2015/2008 Eddy Street Commons - Lease Rent al Revenue Bonds Park i ng G arage/Publ i c Impr ovem ents 2008 N/A 2027 436 2/15 8/15--36,000,000.00 28,760,000.00 1,360,000.00 1,108,431.26 27,400,000.00 2,468,431.26 62 2008 2013 Centu ry Center Special Tax Bonds Century Center Improvem ents 2008 2013 2026 324 4/15 10/15--4,655,000.00 2,875,000.00 310,000.00 76,712.50 2,565,000.00 386,712.50 81 2010 Coveleski Stadium Recovery Zone Econ. Develop. Bo nds Coveleski Stadium Area Expansion/Improve 2010 N/A 2019 377 1/15 7/15--4,980,000.00 1,015,000.00 670,000.00 44,070.00 345,000.00 714,070.00 135 2015 Redevelop ment Au thori ty Smart Streets Bonds Smart Streets Im prov ements 2015 N/A 2037 324 8/1 2/1----25,000,000.00 24,540,000.00 940,000.00 768,793.76 23,600,000.00 1,708,793.76 T otal Re development Revenue Bond D ebt 133,665,000.00 77,410,000.00 6,740,000.00 2,910,694.02 70,670,000.00 9,650,694.02 T otal Re development Comm ission Debt 137,975,278.00 79,319,798.58 7,042,000.47 2,980,703.99 72,277,798.11 10,022,704.46 T otal De bt 387,913,308.38 257,872,827.88 27,474,215.57 8,345,824.92 230,398,612.31 35,820,040.49 Monthl y Financial Report 17 of 24 1st 2nd 3rd 4th Civil City Debt Capital Leases 110 2013 PNC Vehicle & Equipment Lease Vehicl es/E qu i pment 2013 N/A 2018 Various 1/15 7/15----1,689,669.59 346,724.77 172,835.24 2,115.02 - 174,950.26 112 2013 Building Department Ricoh Co pier Copi er Leas e 2013 N/A 2018 600 Monthly 26th----4,093.64 613.22 151.19 5.31 462.03 156.50 113 2013 Sunt rust Vehicle Lease Vehicl es/E qu i pment 2013 N/A 2018 Various 4/24 10/24----1,506,465.26 310,880.69 - - 310,880.69 - 114 2013 Adm inis tration & Finance Rico h Copier Copi er Leas e 2013 N/A 2018 101 1/16 4/16 7/16 10/16 11,247.97 634.57 633.58 9.23 0.99 642.81 117 2013 Police Department Records Div isio n Ricoh Copier Copi er Leas e 2013 N/A 2018 101 Monthly 3rd----9,678.26 2,154.91 352.57 17.43 1,802.34 370.00 118 2013 W at er Works Ma i n Street Ricoh Copier Copi er Leas e 2013 N/A 2018 620 Monthly 10th----5,647.50 1,258.33 204.77 11.13 1,053.56 215.90 119 2013 W at er Works Colfax Ricoh Copier Copi er Leas e 2013 N/A 2018 620 Monthly 16th----4,732.65 1,054.61 171.59 9.33 883.02 180.92 120 2013 W at er Works Olive Street Ricoh C opier Copi er Leas e 2013 N/A 2018 620 Monthly 10th----4,732.65 1,054.61 171.59 9.33 883.02 180.92 123 2014 Police Department Training Ricoh Copier Copi er Leas e 2014 N/A 2019 101 Monthly 30th----4,263.00 1,186.17 153.28 10.72 1,032.89 164.00 124 2014 Police & Public Wor ks Vehicles Vehicl es/E qu i pment 2014 N/A 2019 Various 4/1 10/1----1,959,485.95 801,993.28 - - 801,993.28 - 125 2014 HP Computer L ease #1 Computer Leases 2014 N/A 2018 Various Monthly 8th----137,104.95 28,106.43 2,796.62 105.41 25,309.81 2,902.03 126 2014 HP Computer L ease #2 Computer Leases 2014 N/A 2018 Various Monthly 8th----4,000.00 915.42 81.51 3.53 833.91 85.04 127 2014 HP Computer L ease #4 Computer Leases 2014 N/A 2018 279 Monthly 8th----5,886.73 1,262.39 120.60 4.07 1,141.79 124.67 128 2014 HP Computer L ease #6 Computer Leases 2014 N/A 2018 201 Monthly 8th----3,755.50 959.08 75.87 3.89 883.21 79.76 129 2014 HP Computer L ease #7 Computer Leases 2014 N/A 2018 620 Monthly 8th----1,326.00 363.78 26.92 1.15 336.86 28.07 130 2014 Solid Waste Ricoh Copier Copi er Leas e 2014 N/A 2019 611 Monthly 17th----5,351.65 2,230.54 92.05 10.42 2,138.49 102.47 131 2014 Police Com mun i cations Copier Copi er Leas e 2014 N/A 2019 101 Monthly 12th----8,843.00 3,072.55 154.97 14.35 2,917.58 169.32 132 2014 Ricoh Copiers Copi er Leas e 2014 N/A 2019 641 Monthly 21st----12,260.16 4,044.71 432.74 36.76 3,611.97 469.50 134 2014 W at er Works Ri coh C op i er Copi er Leas e 2014 N/A 2019 620 Monthly 19th----4,732.65 1,139.81 170.80 10.12 969.01 180.92 136 2015 HP Computer L ease #8 Computer Leases 2015 N/A 2019 Various Monthly 16th----19,603.94 6,927.09 390.26 29.12 6,536.83 419.38 137 2015 Anim al Care & Cont rol Ricoh Copier Copi er Leas e 2015 N/A 2020 600 Monthly 30th----5,261.50 2,558.51 88.86 12.46 2,469.65 101.32 138 2015 HP Computer L ease #9 Computer Leases 2015 N/A 2019 Various Monthly------135,958.05 63,804.73 5,301.25 516.15 58,503.48 5,817.40 140 2015 Vehicl e/Equip Lease No. 1 Vehicl es/E qu i pment 2015 N/A 2020 Various 1/15 7/15----3,425,273.58 2,087,121.85 341,880.30 14,452.38 1,745,241.55 356,332.68 143 2015 HP Computer L ease #1 1 Computer Leases 2015 N/A 2019 279 Monthly------3,040.00 1,465.29 119.13 11.11 1,346.16 130.24 144 2015 Vehicl e Lease No. 2 Vehicl es/E qu i pment 2015 N/A 2020 Various 5/15 11/15----1,267,183.00 772,239.72 - - 772,239.72 - 146 2015 Ricoh Copier - Parks Copi er Leas e 2015 N/A 2020 201 Monthly------4,302.06 2,644.67 - - 2,644.67 - 147 2016 Cent ral Services - P rint Shop Copi er Copi er Leas e 2016 N/A 2020 222 Monthly------32,525.00 22,620.32 520.72 97.26 22,099.60 617.98 148 2016 Cent ral Services - P rint Shop Copi er Copi er Leas e 2016 N/A 2020 222 Monthly------11,413.00 7,937.47 182.72 34.13 7,754.75 216.85 149 2016 Vehicl e/Equip Lease No. 1 Vehicl es/E qu i pment 2016 N/A 2021 Various 2/15 8/15----3,339,830.00 2,364,700.45 - - 2,364,700.45 - 150 2016 HP Computer L ease #1 2 Computer Leases 2016 N/A 2020 Various Monthly------17,439.85 10,105.08 654.11 93.09 9,450.97 747.20 151 2016 Adm inis tration & Finance Copier Copi er Leas e 2016 N/A 2021 101 Monthly------10,923.63 6,891.18 351.84 65.70 6,539.34 417.54 152 2016 Vehicl e/Equip Lease No. 2 Vehicl es/E qu i pment 2016 N/A 2021 Various 1/14 7/14----3,992,548.72 3,222,157.09 392,161.10 24,527.06 2,829,995.99 416,688.16 153 2016 Vehicl e/Equip Lease Am endment No. 1 Vehicl es/E qu i pment 2016 N/A 2021 201 1/17 7/17----78,808.00 63,520.71 7,731.01 483.39 55,789.70 8,214.40 154 2016 Vehicl e/Equip Lease No. 3 Vehicl es/E qu i pment 2016 N/A 2021 Various 4/19 10/19----1,256,096.99 1,012,026.89 - - 1,012,026.89 - 155 2016 HP Computer L ease #1 3 Computer Leases 2016 N/A 2020 Various Monthly------156,029.30 116,995.36 5,755.50 941.44 111,239.86 6,696.94 157 2016 Ricoh Copier MPC2003 Copi er Leas e 2016 N/A 2021 201 Monthly----3,184.06 2,265.55 49.34 15.71 2,216.21 65.05 158 2017 Vehicl e/Equip Lease No. 1 Vehicl es/E qu i pment 2017 N/A 2022 Various 1/14 7/14----2,916,500.00 2,916,500.00 264,479.61 45,670.39 2,652,020.39 310,150.00 159 2017 Ricoh Copiers L ease Copi er Leas e 2017 N/A 2021 Various Monthly------15,702.09 12,417.04 603.17 147.39 11,813.87 750.56 160 2017 HP Computer L ease #1 4 Computer Leases 2017 N/A 2021 Various Monthly------10,305.25 8,452.80 189.85 31.39 8,262.95 221.24 162 2017 Vehicl e/Equip Lease No. 2 Vehicl es/E qu i pment 2017 N/A 2022 404 2/15 8/15----1,632,000.00 1,632,000.00 - - 1,632,000.00 - 164 2017 HP Computer L ease #1 6 Computer Leases 2017 N/A 2021 Various Monthly 21st----108,921.75 101,278.63 3,911.89 752.53 97,366.74 4,664.42 T otal City Capital L ea se De bt 23,826,126.88 15,946,280.30 1,202,996.55 90,257.90 14,569,394.22 1,293,254.45 Bon ds 25 2002/2012 Ref un ding Water W orks Impro vements Various W ater Department projects 2002 2012 2023 625 1/1 7/1--5,975,000.00 2,005,000.00 - - 2,005,000.00 - 36 2001 Public Wor ks Service Center (Bldg Corp) (87.7%)Public W or ks Service Center 2001 2010 2021 324 2/1 8/1--8,112,250.00 1,911,860.00 258,715.00 36,285.00 1,653,145.00 295,000.00 36 2001 Public Wor ks Service Center (Bldg Corp) (12.3%)Public W or ks Service Center 2001 2010 2021 641 2/1 8/1--1,137,750.00 268,140.00 37,272.50 5,227.50 230,867.50 42,500.00 39 2012 Fir e St ation/Poli ce Department Renov ations (Bldg Corp)New Cen tral Fire and Police buildings 2003 2012 2023 324 2/1 8/1--21,335,000.00 7,645,000.00 635,000.00 150,000.00 7,010,000.00 785,000.00 69 2009 W at er Works I m provements, Series B Various W ater Department projects 2009 N/A 2030 625 1/1 7/1--5,380,000.00 4,085,000.00 - - 4,085,000.00 - 80 2010 Sewage Works Revenue Bonds Various W ast ewater Dep ar tment pr ojects 2010 N/A 2030 649 6/1 12/1--9,345,000.00 6,750,000.00 - - 6,750,000.00 - 93 2011 Sewage Works Revenue Bonds W as tewater Long Term Cont rol Plan 2011 N/A 2031 649 6/1 12/1--21,500,000.00 16,400,000.00 - - 16,400,000.00 - 99 2012 W at er Works Revenue Bond W at er Works Im provements 2012 N/A 2033 625 1/1 7/1----8,300,000.00 6,570,000.00 - - 6,570,000.00 - 101 2012 Sewage Works Revenue Bonds W as tewater Long Term Cont rol Plan 2012 N/A 2032 649 6/1 12/1--25,000,000.00 19,830,000.00 - - 19,830,000.00 - 105 2013A Sewage Works Revenue Bonds W as tewater Long Term Cont rol Plan 2013 N/A 2024 649 6/1 12/1--14,765,000.00 6,095,000.00 - - 6,095,000.00 - 116 2013 Building Co rporat i on EMS Fire Station/Tower Bon ds Fir e St ation #5 & Trainin g Tower 2013 N/A 2033 287 2/1 8/1----5,580,000.00 4,920,000.00 112,500.00 88,750.00 4,807,500.00 201,250.00 133 2014 St. Joseph County PSAP (E DIT)City's share of PSAP building 2014 N/A 2034 408 Monthly Last----2,657,696.50 2,278,855.00 - - 2,278,855.00 - 141 2015 EDIT/Parks Bonds Park s Improvem en ts 2015 N/A 2035 408 2/1 8/1----5,605,000.00 5,190,000.00 17,500.00 13,960.94 5,172,500.00 31,460.94 145 2015 Sewage Works Refu nd i ng Bo nd s Sewer Bond Improvements 2015 2015 2025 649 6/1 12/1----27,440,000.00 22,435,000.00 - - 22,435,000.00 - 156 2016 W at erworks Refunding Bonds W at er Bond Refunding 2016 N/A 2027 625 1/1 7/1----3,300,000.00 2,895,000.00 - - 2,895,000.00 - 161 2017 Economic Dev elo p. Reven ue Bonds (Studebak er Project)Façade Improvements - Buidling 84 2017 N/A 2018 324 One Time------3,500,000.00 3,500,000.00 - - 3,500,000.00 - 163 2017 Eddy Street Commons Phase II Eddy Street Commons Phase II 2017 N/A 2037 436 2/15 8/15----25,000,000.00 25,000,000.00 - - 25,000,000.00 - 165 2017 Park District Bonds, Series 2017A-K Projects to improve City parks 2017 N/A 2033 312 1/15 7/15----14,075,000.00 14,075,000.00 - - 14,075,000.00 - T otal City Bond D ebt 208,007,696.50 151,853,855.00 1,060,987.50 294,223.44 150,792,867.50 1,355,210.94 Interfund Loan 82 2010 Interf und Fund 404 to UDAG Fund 410 1st Source Bank/Mar riott Garage Project 2010 N/A 2026 410 6/15 12/15--2,700,000.00 966,334.50 31,813.50 - 934,521.00 31,813.50 84 2011/2013 Major Moves-Triangle Development In terfund L oa n Tri angle Development Infr astructure 2011 2011/2013 2029 436 2/15 8/15--1,558,050.00 1,234,877.14 48,097.23 12,348.77 1,186,779.91 60,446.00 85 2011/2013 Major Moves-Ed dy Str eet Com m ons I nterfund Loan Tri angle Development Infr astructure 2011 2011/2013 2026 436 2/15 8/15--3,942,529.00 1,922,964.03 138,143.90 48,074.10 1,784,820.13 186,218.00 142 2016 Interf und Fund 412 to Parki ng Gar age Fund 601 Park i ng G arage Im prov ements 2016 N/A 2022 601 June Dec----1,511,331.00 31,191.33 - - 31,191.33 - T otal City In terfund Loan Debt 9,711,910.00 4,155,367.00 218,054.63 60,422.87 3,937,312.37 278,477.50 L oan Payable 68 2009 W at er Works I m provements - S tate Revolving Fund Various W ater Department projects 2009 N/A 2030 625 1/1 7/1--427,400.00 311,650.00 - - 311,650.00 - 70 2009 Sewage Works Revenue Bonds - State Revol ving Fu nd Various W ast ewater Dep ar tment pr ojects 2009 N/A 2028 649 6/1 12/1--3,297,000.00 2,087,171.00 - - 2,087,171.00 - 122 2014 Synago gu e I nstallment Purchas e Agreement Impr ovem ents at Synagog ue - Coveleski 2014 N/A 2018 377 Annual 1/31----500,000.00 100,000.00 - - 100,000.00 - 139 2015 Cent ury C enter En er gy QECB Co nserv ation Bond Imro vements at Cent ury C enter 2015 N/A 2031 672 5/1 11/1----4,167,897.00 4,098,706.00 - - 4,098,706.00 - T otal City Loan Payable De bt 8,392,297.00 6,597,527.00 - - 6,597,527.00 - T otal Civil City Debt 249,938,030.38 178,553,029.30 2,482,038.68 444,904.21 175,897,101.09 2,926,942.89 YTD Interest Payments City of South Bend Period Ending: January 31, 2018 Debt Payments Year-to-Date D ebt Sche d.Debt Instrument Debt Purpose Year of Issue Year of Refinance Year of M aturity Fund No. Debt at 01/31/18 Total YTD Debt Payments Scheduled Payments Amount Issued Debt at 12/31/17 YTD Principal Payments Monthl y Financial Report 18 of 24 1st 2nd 3rd 4th YTD Interest Payments City of South Bend Period Ending: January 31, 2018 Debt Payments Year-to-Date D ebt Sche d.Debt Instrument Debt Purpose Year of Issue Year of Refinance Year of M aturity Fund No. Debt at 01/31/18 Total YTD Debt Payments Scheduled Payments Amount Issued Debt at 12/31/17 YTD Principal Payments Re development Comm ission Debt Capital Leases 13 2006 Main/Colfax Ga rage - T ranspo Lease Real Estate Purchas e 2006 N/A 2025 324 3/15 9/15--2,510,278.00 1,305,501.00 - - 1,305,501.00 - T otal Re development Capital Lea se De bt 2,510,278.00 1,305,501.00 - - 1,305,501.00 - Interfund Loans 86 2010 Interf und Fund 209 to Airport TIF Fund 324 Prairie Avenue - Br ownfields Clean up Loan 2011 N/A 2020 324 8/9----500,000.00 300,000.00 - - 300,000.00 - T otal Re development Inte rfund Loan Debt 500,000.00 300,000.00 - - 300,000.00 - L oan s Payable 3 2001 Ind i ana Development Finance Aut horit y (Bos ch) - Nonforgivable Rehabil i tate Pro perty 2001 N/A 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 238,409.07 - - 238,409.07 - 4 2001 Ind i ana Development Finance Aut horit y (Bos ch) - Forgi vable Rehabil i tate Pro perty 2001 N/A 2021 210----260,000.00 65,888.51 - - 65,888.51 - T otal Re development Loan P ay able De bt 1,300,000.00 304,297.58 - - 304,297.58 - Re ve nue Bonds 5 2011 Sout h Bend Downtown Centr al Development Area TIF Public Improvements 2003 2011 2024 420/324 2/1 8/1--19,795,000.00 11,185,000.00 - - 11,185,000.00 - 6 2011 Airport Development Area TIF Public Improvements 2003 2011 2024 324 2/1 8/1--14,420,000.00 6,375,000.00 - - 6,375,000.00 - 7 2011 Cent ury C enter L ease Rental Revenue Rehabil i tation of a convention center 1994 2001, 2011 2018 404/407 2/1 8/1--6,825,000.00 245,000.00 245,000.00 4,500.00 - 249,500.00 8 2011 College Football Hall of Fame Const ruction Constr uction of a building 1994 2000, 2011 2018 313 2/1 8/1--15,370,000.00 620,000.00 620,000.00 13,000.00 - 633,000.00 12 2002 TJX S pecial Taxing District (Ref un ded 2014)Public Improvements 2002 2014 2022 324 1/1 7/1--6,620,000.00 1,795,000.00 - - 1,795,000.00 - 54 2015/2008 Eddy Street Commons - Lease Rent al Revenue Bonds Park i ng G arage/Publ i c Impr ovem ents 2008 N/A 2027 436 2/15 8/15--36,000,000.00 28,760,000.00 675,000.00 559,500.00 28,085,000.00 1,234,500.00 62 2008 2013 Centu ry Center Special Tax Bonds Century Center Improvem ents 2008 2013 2026 324 4/15 10/15--4,655,000.00 2,875,000.00 - - 2,875,000.00 - 81 2010 Coveleski Stadium Recovery Zone Econ. Develop. Bo nds Coveleski Stadium Area Expansion/Improve 2010 N/A 2019 377 1/15 7/15--4,980,000.00 1,015,000.00 335,000.00 26,390.00 680,000.00 361,390.00 135 2015 Redevelop ment Au thori ty Smart Streets Bonds Smart Streets Im prov ements 2015 N/A 2037 324 8/1 2/1----25,000,000.00 24,540,000.00 465,000.00 391,500.00 24,075,000.00 856,500.00 T otal Re development Revenue Bond D ebt 133,665,000.00 77,410,000.00 2,340,000.00 994,890.00 75,070,000.00 3,334,890.00 T otal Re development Comm ission Debt 137,975,278.00 79,319,798.58 2,340,000.00 994,890.00 76,979,798.58 3,334,890.00 T otal De bt 387,913,308.38 257,872,827.88 4,822,038.68 1,439,794.21 252,876,899.67 6,261,832.89 Monthl y Financial Report 19 of 24 City of South Bend Staffing Headcount Full-Time Summary by Fund Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 101 - General Fund 101-0101 Mayor's Office 7 7 101-0201 City Clerk 5 5 101-0301 Common Council 9 9 101-0401 Administration & Finance 24 21 101-0404 Morris PAC 7 7 101-0405 Palais Royale 2 2 101-0501 Legal Dept 10 10 101-0602 Engineering Dept 21 22 101-0801 Police Dept 248 242 101-0901 Fire Dept 178 184 101-1008 Human Rights 3 3 514 512 - - - - - - - - - - - 201 - Parks & Recreation 201-1100 Administration 6 7 201-1101 Maintenance 47 49 201-1102 Golf Courses 8 8 201-1103 Recreation 21 21 201-1104 Potawatomi Zoo 1 1 201-1108 Graffiti Removal 1 1 201-1110 Marketing & Events 11 10 95 97 - - - - - - - - - - - 202 - Motor Vehicle Highway 202-0607 Street Department 43 48 202-0619 Curb & Sidewalk Program 4 5 47 53 - - - - - - - - - - - 203 - Recreation Non-Reverting 203-1103 Recreation 1 - 211 - Dept of Community Investment Administration 211-1001 DCI 25 24 219 - Unsafe Building 219-1209 NEAT Crew 4 4 222 - Central Services 222-0605 Equipment Services 32 29 222-0606 Building Maintenance 3 3 222-0612 Central Stores 2 4 222-0613 Print Shop 1 1 222-0614 Radio Shop 3 3 222-0616 Office of Sustainability 2 1 43 41 - - - - - - - - - - - 226 - Liability Insurance 226-0403 Safety & Risk 2 2 226-0412 Liability Insurance 1 1 3 3 - - - - - - - - - - - Period Ending: January 31, 2018 Monthly Financial Report 20 of 24 City of South Bend Staffing Headcount Period Ending: January 31, 2018 Full-Time Summary by Fund Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 249 - Public Safety LOIT 249-0805 Police Department 43 43 249-0905 Fire Department 35 35 78 78 - - - - - - - - - - - 258 - Human Rights Grants 258-1008 EEOC 1 1 258-1009 HUD 1 1 2 2 - - - - - - - - - - - 279 - IT / Innovation / 311 Call Center 279-0104 311 Call Center 7 7 279-0672 Innovation & Technology 20 17 27 24 - - - - - - - - - - - 288 - Emergency Medical Services 288-0902 EMS 51 48 600 - Consolidated Building Dept. 600-1201 Neighborhood Code Enforce.15 16 600-1207 Animal Care & Control 8 8 600-1306 Building Department 18 13 41 37 - - - - - - - - - - - 610 - Solid Waste 610-0610 Solid Waste 24 22 620 - Water Works O&M 620-0640 Water Works 67 66 640 - Sewer Insurance 640-0620 Sewer Repair 2 2 641 - Sewage Works O&M 641-0621 Sewer Department 35 35 641-0625 Concrete Crew 5 3 641-0630 Wastewater Department 46 43 641-0631 Organic Resources 6 6 92 87 - - - - - - - - - - - Total Full-Time Employees by Fund 1,116 1,100 - - - - - - - - - - - Monthly Financial Report 21 of 24 City of South Bend Staffing Headcount Period Ending: January 31, 2018 Full-Time Summary by Activity Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor's Office 7 7 City Clerk 5 5 Common Council 9 9 Administration & Finance 24 21 Legal Dept 10 10 55 52 - - - - - - - - - - - Code Enforcement / Animal Care & Control 27 28 - - - - - - - - - - - Dept. of Community Investment 25 24 - - - - - - - - - - - Venues, Parks & Arts Parks & Recreation 96 97 Morris PAC & Palais Royale 9 9 105 106 - - - - - - - - - - - Public Safety Police - Sworn Officers 248 241 Police - Civilians 43 44 Fire/EMS - Sworn Firefighters 257 260 Fire/EMS - Civilians 7 7 555 552 - - - - - - - - - - - Public Works Office of Sustainability 2 1 Engineering Dept 21 22 Streets & Sewers 89 93 Solid Waste 24 22 Wastewater Department 46 43 Organic Resources 6 6 Water Works 67 66 255 253 - - - - - - - - - - - Liability Insurance/Safety & Risk 3 3 - - - - - - - - - - - Innovation & Technology / 311 Call Center 27 24 - - - - - - - - - - - Central Services 41 40 - - - - - - - - - - - Building Department 18 13 - - - - - - - - - - - Human Rights 5 5 - - - - - - - - - - - Total Full-Time Employees by Activity 1,116 1,100 - - - - - - - - - - - Monthly Financial Report 22 of 24 City of South Bend Staffing Headcount Period Ending: January 31, 2018 Part-Time Summary by Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 101 - General Fund 101-0404 Morris PAC 3 101-0501 Legal Dept 2 101-0602 Engineering Dept 4 101-0801 Police Dept 25 34 201 - Parks & Recreation 201-1100 Administration 1 201-1101 Maintenance 7 201-1103 Recreation 18 201-1108 Graffiti Removal 1 27 202 - Motor Vehicle Highway 202-0607 Street Department 4 203 - Recreation Non-Reverting 203-1103 Recreation 25 211 - Dept of Community Investment Administration 211-1001 DCI 1 222 - Central Services 222-0605 Equipment Services 1 279 - IT / Innovation / 311 Call Center 279-0104 311 Call Center 1 288 - Emergency Medical Services 288-0902 EMS 1 600 - Consolidated Building Dept. 600-1201 Neighborhood Code Enforce.2 600-1207 Animal Care & Control 2 4 640 - Sewer Insurance 640-0620 Sewer Repair 3 641 - Sewage Works O&M 641-0621 Sewer Department 4 Total Part-Time Employees by Fund 105 - - - - - - - - - - - Monthly Financial Report 23 of 24 City of South Bend Staffing Headcount Period Ending: January 31, 2018 Paid Temporary, Seasonal, and Intern Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 201 - Parks & Recreation 201-1100 Administration 1 203 - Recreation Non-Reverting 203-1103 Recreation 2 222 - Central Services 222-0606 Building Maintenance 1 641 - Sewage Works O&M 641-0621 Sewer Department 1 Total Paid Temporary, Seasonal, and Intern Staff 5 - - - - - - - - - - - Summary Budget Full-TimeJan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1,116 1,100 - - - - - - - - - - - Part Time Staff 105 - - - - - - - - - - - Temporary / Seasonal 5 - - - - - - - - - - - City Total 1,116 1,210 - - - - - - - - - - - Monthly Financial Report 24 of 24