Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-02 - 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 February 28, 2018 Controller Monthly Financial Report 2 of 24 February 28, 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 10%, compared to 13% in February 2017. Please note a few revenue types have reached well above their standard 16% of revenue at this time. This is due in part to monies received in January that were 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 February 2018, the general fund has reached 10% of its budgeted revenue, compared to 13% last year. As mentioned above, some funds have surpassed their normal 16% of revenue at this time due to monies received last 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. Last month rebate for the P-card commission was received in the amount of $12,800. Fund 287 (EMS Capital) is at 188% of its budgeted revenue as result of 2017 Medicaid reimbursement received last month in the amount of $1,078,550. Fund 629 (Waterworks Debt Reserve) is at 83% 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 226 (Worker's Compensation) has exceeded its revenue by $14,000 due to money received for 2017 services. Fund 101-0401 (Admin & Finance) has exceeded its budgeted revenue by $751 or 6% over budgeted revenue amount. Last month rebate for the P-card commission was received in the amount of $12,800. Fund 287 (EMS Capital) is at 188% of its budgeted revenue as result of 2017 Medicaid reimbursement received last month in the amount of $1,078,550. Fund 629 (Waterworks Debt Reserve) is at 83% 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 226 (Worker's Compensation) has exceeded its revenue by $14,000 due to money received for 2017 services. 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 February 28, 2018, the City has spent 11% of budgeted expenditures, compared to 14% last year. The General Fund has spent 15% 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 ~ $1.5 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 February was 1,101 vs. a budgeted amount of 1,116. Currently, there are a total of 15 vacant positions. The 15 open positions are in the following departments: General Government (3), Public Safety (3), Public Works (1), 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. City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof Budget Taxes Property Tax311Property Tax Civil Cityvarious- - - - - - - - - - - - - 49,822,557 0% 311Property Tax TIF Districtsvarious- - - - - - - - - - - - - 27,878,133 0% Sub Total - - - - - - - - - - - - - 77,700,690 0% Income Tax315Econ Development Income Tax408893,413 893,413 - - - - - - - - - - 1,786,827 10,720,965 17% 316Local Option Income Tax - PS249635,795 635,795 - - - - - - - - - - 1,271,590 7,629,539 17% 316County Option Income Tax404908,858 908,858 - - - - - - - - - - 1,817,716 10,906,293 17% Sub Total 2,438,066 2,438,066 - - - - - - - - - - 4,876,132 29,256,797 17% St Joseph County (Remitted by)312Auto Excise Taxvarious- - - - - - - - - - - - - 3,184,500 0% 312Commercial Vehicle Taxvarious- - - - - - - - - - - - - 842,600 0% 317Hotel Motel Tax Cum Cap Imprv407221,437 (221,437) - - - - - - - - - - - - NA 317Hotel Motel Tax Century Center670/672106,250 327,687 - - - - - - - - - - 433,937 1,496,437 29% 317Hotel Motel Tax Century Center324- - - - - - - - - - - - - 395,000 0% Sub Total 327,687 106,250 - - - - - - - - - - 433,937 5,918,537 7% Total Taxes2,765,753 2,544,316 - - - - - - - - - - 5,310,069 112,876,024 5% Intergovernmental RevenueState Shared Revenue335Liquor Excise tax10150,193 - - - - - - - - - - - 50,193 75,000 67% 335Liquor Gallonage Tax10158,696 - - - - - - - - - - - 58,696 210,000 28% 335Cigarette Tax101/407- - - - - - - - - - - - - 320,500 0% 335Gaming Proceeds101- - - - - - - - - - - - - 599,000 0% 335Gasoline Tax202/251561,967 526,500 - - - - - - - - - - 1,088,467 6,740,000 16% 335Wheel Tax202132,033 88,461 - - - - - - - - - - 220,493 2,050,000 11% 335Prof Sports Development Tax377- - - - - - - - - - - - - 600,000 0% 335State Pension Subsidy701/702- - - - - - - - - - - - - 11,205,638 0% Sub Total 802,888 614,961 - - - - - - - - - - 1,417,849 21,800,138 7% Grants331 Federal Grants various130,898 321,635 - - - - - - - - - - 452,533 6,138,556 7% 334 State Grants various2,375 - - - - - - - - - - - 2,375 367,375 1% Sub Total 133,273 321,635 - - - - - - - - - - 454,908 6,505,931 7% Other336Federal Drug299- 6,201 - - - - - - - - - - 6,201 50,000 12% 337Regional Cities Grant201195,060 - - - - - - - - - - - 195,060 2,000,000 10% 337State Drug216- 3,865 - - - - - - - - - - 3,865 30,000 13% 338Payment in Lieu of Taxvarious527,707 527,707 - - - - - - - - - - 1,055,414 6,332,487 17% 339Contractual Service21151,257 8,748 - - - - - - - - - - 60,004 333,500 18% Sub Total 774,024 546,520 - - - - - - - - - - 1,320,543 8,745,987 15% Total Intergovernmental Revenue1,710,185 1,483,115 - - - - - - - - - - 3,193,300 37,052,056 9% Charges for Services - Internal340Liability Insurance226177,187 171,512 - - - - - - - - - - 348,699 2,058,123 17% 349Central Services Mark-up22266,267 58,491 - - - - - - - - - - 124,758 793,711 16% Total Charges for Services - Internal243,454 230,003 - - - - - - - - - - 473,457 2,851,834 17% Charges for Services - ExternalLicenses & Permits320Inspections Central Service222- 10 - - - - - - - - - - 10 1,150 1% 321Business License101/22232,444 28,244 - - - - - - - - - - 60,688 121,910 50% 322Building Fees60073,425 93,065 - - - - - - - - - - 166,490 1,387,552 12% 322Building Plan Review - Fire Safety2881,145 1,977 - - - - - - - - - - 3,122 24,000 13% 322General Government Fees1016,255 24,555 - - - - - - - - - - 30,810 132,000 23% Sub Total 113,269 147,851 - - - - - - - - - - 261,120 1,666,612 16% Period Ending: February 28, 2018 Monthly Financial Report 3 of 24 City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: February 28, 2018 Charges for Services - ExternalPublic Safety340Public Safetyvarious- - - - - - - - - - - - - 500 0% 340ND EMS Service288- 750 - - - - - - - - - - 750 150,000 0% 342Public Safetyvarious18,988 18,890 - - - - - - - - - - 37,878 170,000 22% 342EMS - Capital Fund2871,078,551 - - - - - - - - - - - 1,078,551 575,000 188% 342EMS - Operating Fund288261,623 194,907 - - - - - - - - - - 456,530 2,700,000 17% 342EMS - Neo Natal / Transport28852,088 44,463 - - - - - - - - - - 96,550 509,400 19% 342EMS - County Fees288- - - - - - - - - - - - - 1,766,484 0% Sub Total 1,411,250 259,009 - - - - - - - - - - 1,670,259 5,871,384 28% Culture & Recreation347Parks Maintenance (1101)201/40538,216 2,133 - - - - - - - - - - 40,349 983,722 4% 347Golf (1102)201- 9,042 - - - - - - - - - - 9,042 1,496,406 1% 347Recreation (1103)201/20367,191 54,621 - - - - - - - - - - 121,812 1,438,496 8% 347Graffiiti Removal (1108)201- - - - - - - - - - - - - 106,459 0% 347Marketing & Events (1110)201/20322,851 16,927 - - - - - - - - - - 39,778 245,973 16% 347Lease of Coveleski Stadium401- - - - - - - - - - - - - 43,500 0% 347Morris Ticket Surcharges274/4162,563 22,020 - - - - - - - - - - 24,583 224,000 11% Sub Total 130,822 104,743 - - - - - - - - - - 235,565 4,538,556 5% Code Enforcement321Code and Animal Fees6008,225 5,675 - - - - - - - - - - 13,900 67,150 21% 322Code Enforcement Fees600- 2,300 - - - - - - - - - - 2,300 17,500 13% 323Rental Unit Inspection Fees600- - - - - - - - - - - - - 30,000 0% 344Code Environmental Clean Up101/219/6008,672 10,690 - - - - - - - - - - 19,363 175,000 11% 349Code Demolition Board Up219/60020,189 33,441 - - - - - - - - - - 53,630 84,500 63% Sub Total 37,087 52,106 - - - - - - - - - - 89,192 374,150 24% Public Works342Highway & Streets20219,724 - - - - - - - - - - - 19,724 223,365 9% 344Solid Waste610412,322 412,616 - - - - - - - - - - 824,938 4,992,585 17% 346Solid Waste Misc61014,208 14,312 - - - - - - - - - - 28,520 354,606 8% 346Water Works Utility6201,000,323 1,038,936 - - - - - - - - - - 2,039,259 15,986,169 13% 344Water Leak Insurance62082,210 82,136 - - - - - - - - - - 164,347 1,012,683 16% 344Sewer Repair Insurance64052,568 52,969 - - - - - - - - - - 105,537 615,685 17% 344Sewage Waste Water6413,062,991 3,147,975 - - - - - - - - - - 6,210,966 37,433,610 17% 346Project ReLeaf65537,195 37,230 - - - - - - - - - - 74,425 439,680 17% Sub Total 4,681,543 4,786,174 - - - - - - - - - - 9,467,717 61,058,383 16% Parking Garages349Parking Garage Fees601116,271 79,180 - - - - - - - - - - 195,450 1,162,700 17% Sub Total 116,271 79,180 - - - - - - - - - - 195,450 1,162,700 17% Century Center349Parking Century Center67014,340 12,563 - - - - - - - - - - 26,903 131,723 20% 371Century Center Fees67018,397 26,165 - - - - - - - - - - 44,562 416,440 11% 372Century Center Fees67011,305 16,861 - - - - - - - - - - 28,166 137,197 21% 373Century Center Fees67068,911 118,743 - - - - - - - - - - 187,654 1,836,743 10% 374Century Center Fees67010,280 14,302 - - - - - - - - - - 24,582 322,054 8% Sub Total 123,233 188,634 - - - - - - - - - - 311,866 2,844,157 11% Other341General Government Variousvarious449 1,671 - - - - - - - - - - 2,120 30,605 7% 341Historic Presrv Comm Approval21180 40 - - - - - - - - - - 120 1,000 12% 347Sale of Merchandise-Mayor's Office101-0101- - - - - - - - - - - - - 100 0% 349Developer Parking324- - - - - - - - - - - - - 4,320 0% 351Fines & Feesvarious24,226 18,656 - - - - - - - - - - 42,881 265,820 16% 352Forfeitsvarious11,462 7,073 - - - - - - - - - - 18,535 200,000 9% 354Ordinance Violationvarious2,515 8,042 - - - - - - - - - - 10,558 108,500 10% Sub Total 38,732 35,482 - - - - - - - - - - 74,214 610,345 12% Total Charges for Services - External6,652,205 5,653,179 - - - - - - - - - - 12,305,384 78,126,287 16% Monthly Financial Report 4 of 24 City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: February 28, 2018 Other IncomeMiscellaneous Revenue360Miscellaneous Revenuevarious19,102 109,003 - - - - - - - - - - 128,104 1,355,951 9% 360Insurance Reimbursementvarious2,960 - - - - - - - - - - - 2,960 40,000 7% 360Sale of Scrap Metalvarious2,352 1,027 - - - - - - - - - - 3,379 36,582 9% 360General Government Various10112,826 - - - - - - - - - - - 12,826 13,000 99% 360Engineering / Curb & Sidewalk101- - - - - - - - - - - - - 200 0% 360Motor Veh Highway Curb Prgm202- - - - - - - - - - - - - 3,000 0% 360Waste Water641- 1,534 - - - - - - - - - - 1,534 38,475 4% 360Century Center670551 98 - - - - - - - - - - 649 6,629 10% 360Morris PACvarious20,063 57,049 - - - - - - - - - - 77,112 1,083,500 7% 360Palais Royalevarious48,381 8,222 - - - - - - - - - - 56,604 299,572 19% 360Common Area Maint. Fees4253,449 2,237 - - - - - - - - - - 5,686 46,245 12% Sub Total 109,685 179,169 - - - - - - - - - - 288,854 2,923,154 10% Interest Income361Bank Account Interestvarious551,499 330,255 - - - - - - - - - - 881,754 1,925,314 46% Sub Total 551,499 330,255 - - - - - - - - - - 881,754 1,925,314 46% Rental of Property362Dept of Community Investment2121,847 - - - - - - - - - - - 1,847 7,387 25% 362Palais Royale1012,002 2,935 - - - - - - - - - - 4,937 75,000 7% 362Police101- 7,201 - - - - - - - - - - 7,201 48,000 15% 362Parks & Recreation2011,282 2,797 - - - - - - - - - - 4,079 42,300 10% 362South Bend School Corp Fee407- - - - - - - - - - - - - 25,000 0% 362Century Center Property Rental67055,092 25,563 - - - - - - - - - - 80,656 431,328 19% 362TIF Propertyvarious4,447 139,564 - - - - - - - - - - 144,012 149,970 96% Sub Total 64,670 178,061 - - - - - - - - - - 242,732 778,985 31% Donations367ND Contribution101- - - - - - - - - - - - - 337,500 0% 367Donationsvarious18,825 209 - - - - - - - - - - 19,034 192,250 10% Sub Total 18,825 209 - - - - - - - - - - 19,034 529,750 4% Historic Preservation368Palais Royale4503,726 433 - - - - - - - - - - 4,158 16,500 25% Sub Total 3,726 433 - - - - - - - - - - 4,158 16,500 25% 3rd Party Revenue350Job Target Penalty Fee408- - - - - - - - - - - - - 354,660 0% 364Cable TV Franchise Fees101- 181,977 - - - - - - - - - - 181,977 768,000 24% 366AT&T Franchise Fees101- - - - - - - - - - - - - 215,000 0% 369Memorial Hosp Leighton Plaza408- - - - - - - - - - - - - 150,000 0% Sub Total - 181,977 - - - - - - - - - - 181,977 1,487,660 12% Total Other Income748,405 870,104 - - - - - - - - - - 1,618,508 7,661,363 21% Reimbursements & RefundsInternal Reimbursements380Central Services Reimbursements222235,705 220,302 - - - - - - - - - - 456,007 3,138,246 15% 380Energy Office Reimbursements222392,685 463,881 - - - - - - - - - - 856,567 4,725,000 18% 380Police Take Home Vehicle278240 240 - - - - - - - - - - 480 - NA 380IT / Innovation / 311 Center279568,506 568,346 - - - - - - - - - - 1,136,852 6,850,931 17% Sub Total 1,197,136 1,252,770 - - - - - - - - - - 2,449,906 14,714,177 17% Miscellaneous380Miscellaneous Reimbursementsvarious46,138 78,029 - - - - - - - - - - 124,167 1,182,852 10% 380INDOT SR 933 Transfer324- - - - - - - - - - - - - 4,100,000 0% 380General Government101- - - - - - - - - - - - - 50 0% Sub Total 46,138 78,029 - - - - - - - - - - 124,167 5,282,902 2% Total Reimbursements & Refunds1,243,274 1,330,799 - - - - - - - - - - 2,574,072 19,997,079 13% Monthly Financial Report 5 of 24 City of South BendRevenue by Type Report Fund % Revenue TypeRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: February 28, 2018 Other Financing SourcesFixed Assets391Sale of Fixed Assetsvarious- - - - - - - - - - - - - 93,000 0% 391TIF (Property Sales / Land)various92,660 20,001 - - - - - - - - - - 112,661 270,000 42% 391Vehicle Damage Reimbursementvarious4,106 - - - - - - - - - - - 4,106 - NA 391Water Hydrant Reimbursement620538 - - - - - - - - - - - 538 20,000 3% Sub Total 97,305 20,001 - - - - - - - - - - 117,306 383,000 31% Miscellaneous392Administration Fee Allocation101452,408 452,408 - - - - - - - - - - 904,816 5,454,725 17% 392Inter-Fund Transfersvarious229,386 3,177,839 - - - - - - - - - - 3,407,225 41,088,741 8% Sub Total 681,794 3,630,247 - - - - - - - - - - 4,312,041 46,543,466 9% Debt Proceeds393Bond Proceedsvarious- - - - - - - - - - - - - 4,601,750 0% Sub Total - - - - - - - - - - - - - 4,601,750 0% Contributions395Employee Assessment711/713/714277,172 255,092 - - - - - - - - - - 532,263 3,066,596 17% 395Employer Assessment711/713/7141,258,903 1,252,774 - - - - - - - - - - 2,511,677 15,530,694 16% Sub Total 1,536,074 1,507,866 - - - - - - - - - - 3,043,940 18,597,290 16% Refunds396Central Services Refunds22214,009 - - - - - - - - - - - 14,009 21,000 67% 396Specific Stop Loss7111,844 495 - - - - - - - - - - 2,339 10,000 23% Sub Total 15,853 495 - - - - - - - - - - 16,348 31,000 53% Other399Bosch Retention Project210- - - - - - - - - - - - - 65,593 0% 399Principal on Loanvarious511 80,012 - - - - - - - - - - 80,523 127,914 63% 399Principal Incomevarious- 259,888 - - - - - - - - - - 259,888 1,086,395 24% 511 339,900 - - - - - - - - - - 340,411 1,279,902 27% Total Other Financing Sources2,331,537 5,498,508 - - - - - - - - - - 7,830,045 71,436,408 11% Revenue Total15,694,813 17,610,023 - - - - - - - - - - 33,304,836 330,001,051 10% Monthly Financial Report 6 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof Budget General FundGeneral Government0000General Revenues1011,229,231 1,191,884 - - - - - - - - - - 2,421,116 57,358,601 4% 0101Mayor101- - - - - - - - - - - - - 100 0% 0201Clerk101- - - - - - - - - - - - - - NA 0301Common Council101- - - - - - - - - - - - - - NA 0401Administration and Finance10112,801 - - - - - - - - - - - 12,801 12,050 106% 0501Legal10118,875 - - - - - - - - - - - 18,875 76,885 25% Sub Total 1,260,907 1,191,884 - - - - - - - - - - 2,452,792 57,447,636 4% Public Works0602Engineering1017,755 24,555 - - - - - - - - - - 32,310 352,167 9% Sub Total 7,755 24,555 - - - - - - - - - - 32,310 352,167 9% Public Safety0801Police1016,578 10,889 - - - - - - - - - - 17,468 561,000 3% 0901Fire101- - - - - - - - - - - - - 146,114 0% Sub Total 6,578 10,889 - - - - - - - - - - 17,468 707,114 2% Arts & Culture0404Morris PAC10121,240 58,357 - - - - - - - - - - 79,597 1,101,000 7% 0405Palais Royale10154,041 12,252 - - - - - - - - - - 66,293 398,972 17% Sub Total 75,281 70,609 - - - - - - - - - - 145,890 1,499,972 10% Human Rights1008Human Rights101- - - - - - - - - - - - - - NA Sub Total - - - - - - - - - - - - - - NA Total General Fund Revenue1,350,522 1,297,938 - - - - - - - - - - 2,648,459 60,006,889 4% Venues, Parks & ArtsParks & Recreation0000Parks General Revenue20111,804 8,621 - - - - - - - - - - 20,425 10,925,596 0% 1100Administration2011,283 2,799 - - - - - - - - - - 4,082 42,400 10% 1101Maintenance20138,603 50,870 - - - - - - - - - - 89,474 1,262,622 7% 1102Golf Operations2012 9,042 - - - - - - - - - - 9,044 1,501,406 1% 1103Recreation Division201210 1,865 - - - - - - - - - - 2,075 107,060 2% 1104Potawatomi Zoo201- - - - - - - - - - - - - - NA 1108Graffiti Removal201- - - - - - - - - - - - - 106,459 0% 1110Marketing and Events201- - - - - - - - - - - - - 254,973 0% 1111Regional Cities Grant201195,060 - - - - - - - - - - - 195,060 2,000,000 10% Recreation Non Reverting20391,707 75,029 - - - - - - - - - - 166,737 1,523,436 11% Morris Palais Marketing273330 89 - - - - - - - - - - 419 20,400 2% Morris PAC Self-Promotion2741,122 11,010 - - - - - - - - - - 12,132 100,000 12% Zoo Endowment403- - - - - - - - - - - - - 400 0% Park Non-Reverting405490 299 - - - - - - - - - - 789 120,600 1% Sub Total 340,612 159,625 - - - - - - - - - - 500,237 17,965,352 3% Parking Garages0000Parking Garage Revenue6011,922 13 - - - - - - - - - - 1,934 67,200 3% 0460Main Street60131,708 28,624 - - - - - - - - - - 60,332 311,600 19% 0462Leighton Plaza60170,649 28,496 - - - - - - - - - - 99,145 571,000 17% 0463Enforcement6014,787 5,905 - - - - - - - - - - 10,692 - NA 0464Wayne Street60113,659 22,084 - - - - - - - - - - 35,743 279,300 13% 0465Eddy Street Commons601- - - - - - - - - - - - - 500 0% Sub Total 122,725 85,121 - - - - - - - - - - 207,845 1,229,600 17% Century CenterCentury Center Operations670285,126 320,545 - - - - - - - - - - 605,671 4,557,114 13% Century Center Capital67174 66 - - - - - - - - - - 140 900 16% Century Center Energy Saving6724 221,441 - - - - - - - - - - 221,445 420,124 53% Sub Total 285,204 542,052 - - - - - - - - - - 827,256 4,978,138 17% Total Venues, Parks & Arts748,540 786,798 - - - - - - - - - - 1,535,338 24,173,090 6% Period Ending: February 28, 2018 Monthly Financial Report 7 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: February 28, 2018 Public SafetyPolice DepartmentPolice Seizures216485 4,179 - - - - - - - - - - 4,663 32,000 15% Curfew Violations21831 21 - - - - - - - - - - 52 300 17% Law Enforcement Education22027,367 18,710 - - - - - - - - - - 46,077 271,500 17% Public Safety LOIT249637,913 636,475 - - - - - - - - - - 1,274,388 7,635,539 17% Police Take Home Vehicle2782,042 1,457 - - - - - - - - - - 3,498 4,000 87% Police Block Grant2809 6 - - - - - - - - - - 16 35 45% Police Grants292- - - - - - - - - - - - - - NA Police Academy2947,809 8,737 - - - - - - - - - - 16,546 22,500 74% COPS More Grants2951,496 26,664 - - - - - - - - - - 28,160 92,000 31% Drug Enforcement299164 6,377 - - - - - - - - - - 6,541 51,000 13% K-9 Unit7057 5 - - - - - - - - - - 12 2,020 1% Sub Total 677,322 702,630 - - - - - - - - - - 1,379,952 8,110,894 17% Fire DepartmentEMS Capital2871,088,873 9,083 - - - - - - - - - - 1,097,957 585,000 188% EMS Operating Fund288322,278 245,130 - - - - - - - - - - 567,409 5,186,384 11% Hazmat28964 44 - - - - - - - - - - 109 10,200 1% River Rescue2917,495 8,022 - - - - - - - - - - 15,516 45,500 34% Sub Total 1,418,710 262,280 - - - - - - - - - - 1,680,990 5,827,084 29% Total Public Safety2,096,032 964,910 - - - - - - - - - - 3,060,942 13,937,978 22% Public WorksStreetsMotor Vehicle Highway202579,560 469,318 - - - - - - - - - - 1,048,878 11,288,058 9% Local Roads & Streets251203,272 163,889 - - - - - - - - - - 367,162 1,868,000 20% Local Road & Bridge Grant265- - - - - - - - - - - - - - NA Project ReLeaf65539,153 38,649 - - - - - - - - - - 77,802 445,800 17% Sub Total 821,986 671,857 - - - - - - - - - - 1,493,843 13,601,858 11% Solid WasteSolid Waste Operations610430,160 429,729 - - - - - - - - - - 859,889 5,474,191 16% Solid Waste Capital61196 293,038 - - - - - - - - - - 293,133 1,077,506 27% Sub Total 430,256 722,767 - - - - - - - - - - 1,153,022 6,551,697 18% Water Works0000Water Works Revenues620947,619 981,889 - - - - - - - - - - 1,929,508 14,799,959 13% 0630Water Leak Insurance62082,210 82,136 - - - - - - - - - - 164,347 1,012,683 16% 0640Water Works620- - - - - - - - - - - - - - NA 0660Clay Water62070,281 70,546 - - - - - - - - - - 140,827 1,356,710 10% Waterworks Capital6225,129 3,471 - - - - - - - - - - 8,600 25,000 34% Waterworks Deposit6243,630 2,451 - - - - - - - - - - 6,082 15,000 41% Waterworks Sinking625166,918 165,664 - - - - - - - - - - 332,582 2,009,217 17% Waterworks Bond Reserve6263,335 2,280 - - - - - - - - - - 5,615 16,000 35% Waterworks Debt Reserve62958,511 4,227 - - - - - - - - - - 62,737 75,250 83% Sub Total 1,337,633 1,312,665 - - - - - - - - - - 2,650,298 19,309,819 14% Wastewater/Sewer/Organic ResourcesSewer Repair Insurance64057,037 56,067 - - - - - - - - - - 113,104 626,535 18% 0000Wastewater Revenues6412,916,439 2,990,482 - - - - - - - - - - 5,906,921 35,598,915 17% 0621Sewer Department641760 - - - - - - - - - - - 760 2,500 30% 0625Concrete Crew641- 3,050 - - - - - - - - - - 3,050 55,170 6% 0630Wastewater Operations641- - - - - - - - - - - - - - NA 0631Organic Resources641- - - - - - - - - - - - - - NA 0650Clay Sewage641183,418 191,425 - - - - - - - - - - 374,843 2,160,000 17% Sewage Capital64217,620 11,009 - - - - - - - - - - 28,629 9,900,000 0% Sewage Reserve64312,344 246,543 - - - - - - - - - - 258,887 35,000 740% Sewage Bond Sinking6491,899 1,383 - - - - - - - - - - 3,282 9,179,379 0% Sewage Works DS Reserve653- 3,678 - - - - - - - - - - 3,678 14,700 25% 2011 Sewer Bond6590 0 - - - - - - - - - - 1 - NA 2012 Sewer Bond6611,538 1,039 - - - - - - - - - - 2,577 10,000 26% Sub Total 3,191,056 3,504,676 - - - - - - - - - - 6,695,732 57,582,199 12% Total Public Works5,780,930 6,211,964 - - - - - - - - - - 11,992,894 97,045,573 12% Monthly Financial Report 8 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: February 28, 2018 Capital & Debt Service FundHall of Fame313- 22 - - - - - - - - - - 22 1,258,617 0% Professional Sports Development37737 - - - - - - - - - - - 37 620,000 0% Coveleski Stadium401131 88 - - - - - - - - - - 219 44,250 0% COIT404929,149 954,707 - - - - - - - - - - 1,883,856 11,611,424 16% Cumulative Capital Development4061,336 976 - - - - - - - - - - 2,312 459,200 1% Cumulative Capital Improvement407222,424 (220,745) - - - - - - - - - - 1,679 278,500 1% EDIT408923,177 913,974 - - - - - - - - - - 1,837,150 11,285,625 16% UDAG4101,129 10,139 - - - - - - - - - - 11,268 138,728 8% Major Moves4126,962 312,097 - - - - - - - - - - 319,059 518,178 62% Morris PAC Improvement4162,516 11,683 - - - - - - - - - - 14,199 129,000 11% Palais Historic Preservation4503,987 621 - - - - - - - - - - 4,608 17,100 27% 2017 Parks Bond471- - - - - - - - - - - - - 3,000 0% Hall of Fame Capital6771,076 723 - - - - - - - - - - 1,798 5,000 36% Equipment / Vehicle Leasing750200 718 - - - - - - - - - - 917 4,604,750 0% Parks Bond Capital751- 557 - - - - - - - - - - 557 4,500 12% Smart Street Bond Capital753- 177 - - - - - - - - - - 177 1,500 12% SB Building Corp755- 1,324,193 - - - - - - - - - - 1,324,193 2,636,025 50% Parks Bond Debt Svc757- 31,935 - - - - - - - - - - 31,935 379,907 8% Eddy St. Commons Capital759- 34 - - - - - - - - - - 34 2,000 2% Eddy St. Commons Debt760- 425 - - - - - - - - - - 425 1,279,472 0% Total Capital & Debt Service2,092,124 3,342,322 - - - - - - - - - - 5,434,446 35,276,776 15% Department of Community InvestmentStudebaker/Oliver20937,428 4,300 - - - - - - - - - - 41,728 205,014 20% State Grant2103,321 673 - - - - - - - - - - 3,994 75,887 5% DCI Operating 21197,850 10,408 - - - - - - - - - - 108,258 2,654,656 4% 0000Dept. of Community Investment2122,443 363,662 - - - - - - - - - - 366,105 2,929,387 12% 1013Programs212- 12,542 - - - - - - - - - - 12,542 12,542 100% Economic Revenue Bond28167 45 - - - - - - - - - - 112 200 56% Total Dept of Community Investment141,109 391,630 - - - - - - - - - - 532,739 5,877,686 9% Central ServicesCentral Services222711,462 743,850 - - - - - - - - - - 1,455,313 8,708,507 17% Central Services Capital224467 262 - - - - - - - - - - 729 78,000 1% Total Central Services711,930 744,112 - - - - - - - - - - 1,456,042 8,786,507 17% Liability Insurance0000Business Insurance Revenues226188,502 178,952 - - - - - - - - - - 367,454 2,098,123 18% 0403Self Funded Liability Ins226- - - - - - - - - - - - - - NA 0412Liability Insurance226- - - - - - - - - - - - - - NA 0417Business Insurance226- - - - - - - - - - - - - - NA 0418Workers Compensation226- 16,000 - - - - - - - - - - 16,000 2,000 800% Total Liability Insurance188,502 194,951 - - - - - - - - - - 383,454 2,100,123 18% Code EnforcementUnsafe Building2198,297 10,793 - - - - - - - - - - 19,091 908,773 2% Landlord Registration22155 200 - - - - - - - - - - 255 6,000 4% 1201Neighborhood Code Enforcement60034,861 50,613 - - - - - - - - - - 85,474 542,891 16% 1207Animal Care & Control6009,000 5,690 - - - - - - - - - - 14,690 894,312 2% 1208Rental Unit Inspection600- - - - - - - - - - - - - 30,000 0% Total Code Enforcement52,213 67,296 - - - - - - - - - - 119,510 2,381,976 5% Building Department1306Building Dept Operations60080,975 97,855 - - - - - - - - - - 178,830 1,395,552 13% Total Building Department80,975 97,855 - - - - - - - - - - 178,830 1,395,552 13% Monthly Financial Report 9 of 24 City of South BendRevenue by Fund Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: February 28, 2018 Other MiscellaneousRainy Day10224,622 16,629 - - - - - - - - - - 41,251 80,000 52% Gift, Donation, Bequest21718,967 403 - - - - - - - - - - 19,370 45,800 42% Loss Recovery2272,029 1,226 - - - - - - - - - - 3,255 4,000 81% LOIT 2016 Special Distribution2571,967 10,003 - - - - - - - - - - 11,970 2,240,000 1% Human Rights25811,146 6,333 - - - - - - - - - - 17,479 167,400 10% IT / Innovation /311 Call Center279584,945 568,346 - - - - - - - - - - 1,153,291 6,850,931 17% Sub Total 643,676 602,940 - - - - - - - - - - 1,246,616 9,388,131 13% Fiduciary Trust & AgencyFire Pension7013,766 642 - - - - - - - - - - 4,408 5,217,138 0% Police Pension7022,515 1,314 - - - - - - - - - - 3,829 6,005,500 0% Employee Benefits7111,562,014 1,526,723 - - - - - - - - - - 3,088,737 18,511,596 17% Unemployment Comp713542 365 - - - - - - - - - - 907 2,000 45% Parental Leave Fund714- - - - - - - - - - - - - 155,694 0% City Cemetery Trust73068 46 - - - - - - - - - - 114 250 46% Sub Total 1,568,905 1,529,090 - - - - - - - - - - 3,097,995 29,892,178 10% Total Other2,212,581 2,132,030 - - - - - - - - - - 4,344,611 39,280,309 11% Total Civil City15,455,459 16,231,806 - - - - - - - - - - 31,687,265 290,262,459 11% Redevelopment FundsTax Increment FinancingTIF River West - Airport324166,079 208,028 - - - - - - - - - - 374,107 24,539,693 2% TIF West Washington4225,328 3,682 - - - - - - - - - - 9,010 436,000 2% TIF Leighton Plaza42510,000 11,541 - - - - - - - - - - 21,541 197,014 11% TIF River East DEV (NE)42923,830 13,582 - - - - - - - - - - 37,412 2,357,000 2% TIF Southside43018,064 12,668 - - - - - - - - - - 30,732 2,463,000 1% TIF Erskine Village432- - - - - - - - - - - - - - NA TIF Douglas Road435368 324 - - - - - - - - - - 692 1,150 60% TIF River East RES (NE RE)4365,385 - - - - - - - - - - - 5,385 4,405,500 0% Sub Total 229,054 249,826 - - - - - - - - - - 478,880 34,399,357 1% Redevelopment FundsAdministration43318 12 - - - - - - - - - - 30 135 22% Certified Technology Park4391,469 992 - - - - - - - - - - 2,461 2,500 98% Airport Urban Enterprise Zone454926 626 - - - - - - - - - - 1,552 3,900 40% Industrial Revolving754- 14,682 - - - - - - - - - - 14,682 210,000 7% Sub Total 2,413 16,311 - - - - - - - - - - 18,724 216,535 9% Debt ServiceAirport Debt Reserve 20033152,489 1,677 - - - - - - - - - - 4,165 14,000 30% Coveleski Bond Debt Reserve3171,239 837 - - - - - - - - - - 2,076 5,000 42% Central Development reserve3284,160 2,803 - - - - - - - - - - 6,964 20,000 35% SB Redevelopment Authority752- 249,971 - - - - - - - - - - 249,971 3,367,200 7% Smart Streets Debt Svc756- 856,792 - - - - - - - - - - 856,792 1,716,500 50% Sub Total 7,888 1,112,079 - - - - - - - - - - 1,119,967 5,122,700 22% Total Redevelopment239,354 1,378,217 - - - - - - - - - - 1,617,571 39,738,592 4% Revenue Total15,694,813 17,610,023 - - - - - - - - - - 33,304,836 330,001,051 10% Monthly Financial Report 10 of 24 City of South BendProperty Tax Revenue2017 Tax Pay 2018 LevyEstimatedDistribution 1Distribution 2Distribution 3Distribution 4LevyPer CountyCollectionProjected TotalProperty TaxCollectionFundFund #RecordsFactorCollectionsCollectionsCollectionsCollectionsCollectionsCollectionsReceivableRate CityGeneral Fund101 0.95 - - - - - - Parks & Recreation201 0.95 - - - - - - College Football Hall of Fame313 0.95 - - - - - - Cumulative Capital District406 0.95 - - - - - - Total - City - - - - - - - - 0.00% Tax Increment Financing Airport TIF District324 0.95 - - - - - - West Washington TIF District422 0.95 - - - - - - Northeast Residential TIF District436 0.95 - - - - - - Southside TIF District #1430 0.95 - - - - - - Douglas Road TIF District435 0.95 - - - - - - Northeast TIF429 0.95 - - - - - - Total - Tax Increment Financing - - - - - - - - 0.00% Grand Total - - - - - - - - 0.00% Note(s)2017 pay 2018 to be determined2016 Tax Pay 2017 LevyEstimatedDistribution 1Distribution 2Distribution 3Distribution 4Levy Per CountyCollectionProjected6/20/201712/20/2017TotalProperty TaxCollectionFundFund #RecordsFactorCollectionsCollectionsCollectionsCollectionsCollectionsCollectionsReceivableRate CityGeneral Fund101 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 & Recreation201 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 Fame313 833,277.00 0.95 791,613.15 451,820.36 368,250.79 - - 820,071.15 13,205.85 98.42% Cumulative Capital District406 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 District324 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 District422 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 District436 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 #1430 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 District435 321,949.68 0.95 305,852.20 218,279.99 160,974.84 - - 379,254.83 (57,305.15) 117.80% Northeast TIF429 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/17Distribution 2 - Issued by St. Joseph County on 12/20/17 Period Ending: February 28, 2018 Monthly Financial Report 11 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof Budget General FundGeneral Government0101Mayor10166,242 71,445 - - - - - - - - - - 137,687 908,142 15% 0201Clerk10141,465 49,121 - - - - - - - - - - 90,586 573,553 16% 0301Common Council10147,784 61,913 - - - - - - - - - - 109,697 670,013 16% 0302WNIT Contract101- - - - - - - - - - - - - 43,000 0% 0401Administration and Finance101181,515 157,607 - - - - - - - - - - 339,122 2,639,826 13% 0501Legal10180,972 80,377 - - - - - - - - - - 161,349 1,200,973 13% Sub Total 417,977 420,463 - - - - - - - - - - 838,440 6,035,507 14% Public Works0602Engineering10197,206 113,041 - - - - - - - - - - 210,247 1,750,084 12% Sub Total 97,206 113,041 - - - - - - - - - - 210,247 1,750,084 12% Public Safety0801Police1012,553,505 2,055,904 - - - - - - - - - - 4,609,408 29,626,242 16% 0901Fire1011,702,483 1,610,625 - - - - - - - - - - 3,313,107 21,439,343 15% Sub Total 4,255,987 3,666,528 - - - - - - - - - - 7,922,516 51,065,585 16% Arts & Culture0404Morris PAC10166,022 73,169 - - - - - - - - - - 139,191 1,320,791 11% 0405Palais Royale10124,590 30,996 - - - - - - - - - - 55,585 541,428 10% Sub Total 90,612 104,165 - - - - - - - - - - 194,777 1,862,219 10% Human Rights1008Human Rights10124,673 39,414 - - - - - - - - - - 64,087 447,133 14% Sub Total 24,673 39,414 - - - - - - - - - - 64,087 447,133 14% Total General Fund Revenue4,886,455 4,343,611 - - - - - - - - - - 9,230,067 61,160,528 15% Venues, Parks & ArtsParks & Recreation1100Administration201106,755 110,212 - - - - - - - - - - 216,967 1,227,968 18% 1101Maintenance201443,597 540,635 - - - - - - - - - - 984,233 7,184,730 14% 1102Golf Operations20156,591 61,999 - - - - - - - - - - 118,590 1,588,326 7% 1103Recreation Division201136,104 122,740 - - - - - - - - - - 258,844 2,181,005 12% 1104Potawatomi Zoo2018,216 357,457 - - - - - - - - - - 365,673 700,000 52% 1106Potawatomi Greenhouse2015,430 4,242 - - - - - - - - - - 9,672 46,602 21% 1108Graffiti Removal2017,388 7,283 - - - - - - - - - - 14,671 106,459 14% 1110Marketing and Events20168,206 71,319 - - - - - - - - - - 139,525 1,269,263 11% 1111Regional Cities Grant20128,510 9,390 - - - - - - - - - - 37,900 2,113,595 2% Recreation Non Reverting20349,052 76,096 - - - - - - - - - - 125,148 1,616,634 8% Morris Palais Marketing273- - - - - - - - - - - - - 18,000 0% Morris PAC Self-Promotion274- - - - - - - - - - - - - 50,000 0% Zoo Endowment403- - - - - - - - - - - - - - NA Park Non-Reverting40538,340 17,281 - - - - - - - - - - 55,621 232,872 24% Sub Total 948,190 1,378,655 - - - - - - - - - - 2,326,845 18,335,454 13% Parking Garages0400Parking Garage Administration60160,725 - - - - - - - - - - - 60,725 - NA 0460Main Street6014,706 13,676 - - - - - - - - - - 18,382 311,768 6% 0462Leighton Plaza6015,884 20,832 - - - - - - - - - - 26,716 452,307 6% 0463Enforcement601416 10,797 - - - - - - - - - - 11,213 104,632 11% 0464Wayne Street6014,405 12,676 - - - - - - - - - - 17,081 291,637 6% 0465Eddy Street Commons601- - - - - - - - - - - - - 15,000 0% Sub Total 76,136 57,981 - - - - - - - - - - 134,117 1,175,344 11% Century CenterCentury Center Operations670301,878 328,776 - - - - - - - - - - 630,654 4,557,114 14% Century Center Capital671- - - - - - - - - - - - - - NA Century Center Energy Saving672- - - - - - - - - - - - - 306,737 0% Sub Total 301,878 328,776 - - - - - - - - - - 630,654 4,863,851 13% Total Venues, Parks & Arts1,326,204 1,765,412 - - - - - - - - - - 3,091,615 24,374,649 13% Period Ending: February 28, 2018 Monthly Financial Report 12 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: February 28, 2018 Public SafetyPolice DepartmentPolice Seizures216- - - - - - - - - - - - - 32,000 0% Curfew Violations218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education22057,873 16,555 - - - - - - - - - - 74,429 594,624 13% Public Safety LOIT249491,276 597,065 - - - - - - - - - - 1,088,341 7,622,970 14% Police Take Home Vehicle278- - - - - - - - - - - - - 10,000 0% Police Block Grant280- - - - - - - - - - - - - - NA Police Grants292- - - - - - - - - - - - - - NA Police Academy2943,362 964 - - - - - - - - - - 4,326 22,500 19% COPS More Grants29526,202 960 - - - - - - - - - - 27,162 112,785 24% Drug Enforcement299- - - - - - - - - - - - - 51,000 0% K-9 Unit705- - - - - - - - - - - - - 2,020 0% Sub Total 578,714 615,545 - - - - - - - - - - 1,194,259 8,448,899 14% Fire DepartmentEMS Capital287232,138 245,348 - - - - - - - - - - 477,486 3,078,454 16% EMS Operating Fund288451,202 438,738 - - - - - - - - - - 889,940 6,431,746 14% Hazmat289- - - - - - - - - - - - - 10,000 0% River Rescue291620 231 - - - - - - - - - - 851 101,800 1% Sub Total 683,959 684,317 - - - - - - - - - - 1,368,276 9,622,000 14% Total Public Safety1,262,673 1,299,862 - - - - - - - - - - 2,562,535 18,070,899 14% Public WorksStreetsMotor Vehicle Highway202929,501 929,777 - - - - - - - - - - 1,859,278 12,387,981 15% Local Roads & Streets251- 41,614 - - - - - - - - - - 41,614 3,088,508 1% Local Road & Bridge Grant265900 1,755 - - - - - - - - - - 2,655 437,632 1% Project ReLeaf6553,267 3,043 - - - - - - - - - - 6,310 702,042 1% Sub Total 933,668 976,189 - - - - - - - - - - 1,909,857 16,616,163 11% Solid WasteSolid Waste Operations610353,032 690,851 - - - - - - - - - - 1,043,883 5,496,049 19% Solid Waste Capital611185,219 146,711 - - - - - - - - - - 331,931 1,076,706 31% Sub Total 538,251 837,563 - - - - - - - - - - 1,375,814 6,572,755 21% Water Works0630Water Leak Insurance62026,512 56,237 - - - - - - - - - - 82,748 1,035,000 8% 0640Water Works6201,352,132 1,350,826 - - - - - - - - - - 2,702,958 16,979,530 16% 0660Clay Water620104 91 - - - - - - - - - - 195 3,500 6% Waterworks Capital6221,642 - - - - - - - - - - - 1,642 1,578,570 0% Waterworks Deposit6241,289 2,451 - - - - - - - - - - 3,740 15,000 25% Waterworks Sinking6251,279 569 - - - - - - - - - - 1,849 2,009,217 0% Waterworks Bond Reserve626- - - - - - - - - - - - - 16,000 0% Waterworks Debt Reserve6292,225 4,227 - - - - - - - - - - 6,452 23,000 28% Sub Total 1,385,183 1,414,400 - - - - - - - - - - 2,799,584 21,659,817 13% Wastewater/Sewer/Organic ResourcesSewer Repair Insurance64021,863 43,609 - - - - - - - - - - 65,473 632,224 10% 0621Sewer Department641459,002 1,203,962 - - - - - - - - - - 1,662,964 9,874,691 17% 0625Concrete Crew64134,892 33,631 - - - - - - - - - - 68,523 484,265 14% 0630Wastewater Operations6411,548,265 1,540,774 - - - - - - - - - - 3,089,039 37,870,668 8% 0631Organic Resources641231,119 149,015 - - - - - - - - - - 380,133 1,670,534 23% 0650Clay Sewage641283 (420) - - - - - - - - - - (137) 250 -55% Sewage Capital642349,920 280,581 - - - - - - - - - - 630,501 12,314,553 5% Sewage Reserve6434,386 8,317 - - - - - - - - - - 12,703 35,000 36% Sewage Bond Sinking6491,000 500 - - - - - - - - - - 1,500 9,156,379 0% Sewage Works DS Reserve653- - - - - - - - - - - - - - NA 2011 Sewer Bond659- - - - - - - - - - - - - - NA 2012 Sewer Bond661- 501,426 - - - - - - - - - - 501,426 642,186 78% Sub Total 2,650,730 3,761,396 - - - - - - - - - - 6,412,126 72,680,750 9% Total Public Works5,507,832 6,989,548 - - - - - - - - - - 12,497,381 117,529,485 11% Monthly Financial Report 13 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: February 28, 2018 Capital & Debt Service FundHall of Fame313633,000 - - - - - - - - - - - 633,000 1,258,617 50% Professional Sports Development377361,390 100,800 - - - - - - - - - - 462,190 814,870 57% Coveleski Stadium401- - - - - - - - - - - - - 145,000 0% COIT404651,760 1,218,145 - - - - - - - - - - 1,869,905 11,726,673 16% Cumulative Capital Development406195,231 27,896 - - - - - - - - - - 223,126 459,200 49% Cumulative Capital Improvement407249,500 - - - - - - - - - - - 249,500 278,500 90% EDIT408170,329 175,790 - - - - - - - - - - 346,119 12,068,344 3% UDAG410- 31,814 - - - - - - - - - - 31,814 610,131 5% Major Moves412979 94,995 - - - - - - - - - - 95,974 2,573,799 4% Morris PAC Improvement416- - - - - - - - - - - - - 109,500 0% Palais Historic Preservation450- - - - - - - - - - - - - 45,000 0% 2017 Parks Bond471- 17,750 - - - - - - - - - - 17,750 10,309,100 0% Hall of Fame Capital6775,294 8,730 - - - - - - - - - - 14,024 129,227 11% Equipment / Vehicle Leasing750- - - - - - - - - - - - - 7,590,534 0% Parks Bond Capital751- 142,569 - - - - - - - - - - 142,569 3,045,118 5% Smart Street Bond Capital753- 12,431 - - - - - - - - - - 12,431 2,101,500 1% SB Building Corp755- - - - - - - - - - - - - 2,636,025 0% Parks Bond Debt Svc757- - - - - - - - - - - - - 380,107 0% Eddy St. Commons Capital759- - - - - - - - - - - - - 39,103,750 0% Eddy St. Commons Debt760- - - - - - - - - - - - - 3,779,472 0% Total Capital & Debt Service2,267,482 1,830,919 - - - - - - - - - - 4,098,400 99,164,467 4% Department of Community InvestmentStudebaker/Oliver20914,869 3,179 - - - - - - - - - - 18,048 1,041,098 2% State Grant210- - - - - - - - - - - - - 257,133 0% DCI Operating 211199,829 228,512 - - - - - - - - - - 428,341 3,077,096 14% Programs212242,431 218,522 - - - - - - - - - - 460,953 5,874,598 8% Economic Revenue Bond281- - - - - - - - - - - - - - NA Total Dept of Community Investment457,129 450,212 - - - - - - - - - - 907,342 10,249,925 9% Central Services0605Equipment Services222255,181 234,013 - - - - - - - - - - 489,194 3,072,612 16% 0606Building Maintenance22217,233 17,032 - - - - - - - - - - 34,265 213,832 16% 0612Central Stores22219,345 19,143 - - - - - - - - - - 38,488 236,428 16% 0613Print Shop22210,612 9,948 - - - - - - - - - - 20,560 192,329 11% 0614Radio Shop22222,971 23,167 - - - - - - - - - - 46,138 336,927 14% 0616Energy/Sustainability22215,261 25,951 - - - - - - - - - - 41,212 370,560 11% 0617Electric & Gas Utilities222363,766 477,069 - - - - - - - - - - 840,834 4,375,000 19% Central Services Capital22422,614 16,567 - - - - - - - - - - 39,181 155,036 25% Total Central Services726,982 822,890 - - - - - - - - - - 1,549,872 8,952,724 17% Liability Insurance0403Self Funded Liability Ins22619,540 16,545 - - - - - - - - - - 36,085 262,724 14% 0412Liability Insurance22643,410 151,831 - - - - - - - - - - 195,241 1,158,406 17% 0417Business Insurance22618,256 14,875 - - - - - - - - - - 33,131 665,269 5% 0418Workers Compensation22659,655 260,416 - - - - - - - - - - 320,072 680,717 47% Total Liability Insurance140,861 443,667 - - - - - - - - - - 584,529 2,767,116 21% Code EnforcementUnsafe Building21954,128 47,800 - - - - - - - - - - 101,928 972,413 10% Landlord Registration221- - - - - - - - - - - - - 1,000 0% 1201Neighborhood Code Enforcement600176,422 126,847 - - - - - - - - - - 303,269 1,835,827 17% 1207Animal Care & Control60062,449 81,335 - - - - - - - - - - 143,785 968,596 15% 1208Rental Unit Inspection600- - - - - - - - - - - - - 180,000 0% Total Code Enforcement292,999 255,982 - - - - - - - - - - 548,982 3,957,836 14% Monthly Financial Report 14 of 24 City of South BendExpenditure Report Fund % DivisionRecipientJanFebMarAprMayJunJulAugSepOctNovDecYearBudgetof BudgetPeriod Ending: February 28, 2018 Building Department1306Building Dept Operations600171,357 103,354 - - - - - - - - - - 274,711 1,658,827 17% Total Building Department171,357 103,354 - - - - - - - - - - 274,711 1,658,827 17% Other MiscellaneousGift, Donation, Bequest2173,461 - - - - - - - - - - - 3,461 46,161 7% Loss Recovery227107,957 26,251 - - - - - - - - - - 134,208 515,323 26% LOIT 2016 Special Distribution25782,709 64,142 - - - - - - - - - - 146,851 4,113,349 4% Human Rights25814,012 1,644 - - - - - - - - - - 15,656 163,234 10% IT / Innovation /311 Call Center279235,061 632,764 - - - - - - - - - - 867,826 7,155,112 12% Sub Total 443,200 724,801 - - - - - - - - - - 1,168,001 11,993,179 10% Fiduciary Trust & AgencyFire Pension701373,509 517,553 - - - - - - - - - - 891,062 5,112,457 17% Police Pension702593,204 510,652 - - - - - - - - - - 1,103,856 6,583,452 17% Employee Benefits7111,436,330 941,195 - - - - - - - - - - 2,377,524 18,145,518 13% Unemployment Comp713- 565 - - - - - - - - - - 565 80,000 1% Parental Leave Fund714- 1,765 - - - - - - - - - - 1,765 155,694 1% City Cemetery Trust730- - - - - - - - - - - - - 25,000 0% Sub Total 2,403,043 1,971,729 - - - - - - - - - - 4,374,772 30,102,121 15% Total Other2,846,243 2,696,530 - - - - - - - - - - 5,542,773 42,095,300 13% Total Civil City19,886,217 21,001,989 - - - - - - - - - - 40,888,206 389,981,756 10% Redevelopment FundsTax Increment FinancingTIF River West - Airport3243,981,156 1,852,277 - - - - - - - - - - 5,833,432 45,356,182 13% TIF West Washington422- 74,176 - - - - - - - - - - 74,176 1,885,916 4% TIF Leighton Plaza4257,611 3,202 - - - - - - - - - - 10,813 158,166 7% TIF River East DEV (NE)429303,011 77,081 - - - - - - - - - - 380,093 7,587,691 5% TIF Southside4303,188 9,734 - - - - - - - - - - 12,921 7,556,026 0% TIF Erskine Village432- - - - - - - - - - - - - - NA TIF Douglas Road435- - - - - - - - - - - - - 144,650 0% TIF River East RES (NE RE)4361,234,500 875,136 - - - - - - - - - - 2,109,636 4,320,000 49% Sub Total 5,529,466 2,891,606 - - - - - - - - - - 8,421,072 67,008,631 13% Redevelopment FundsAdministration433- - - - - - - - - - - - - 4,500 0% Certified Technology Park439- - - - - - - - - - - - - - NA Airport Urban Enterprise Zone454- - - - - - - - - - - - - 50,000 0% Industrial Revolving754- 5,832 - - - - - - - - - - 5,832 157,000 4% Sub Total - 5,832 - - - - - - - - - - 5,832 211,500 3% Debt ServiceAirport Debt Reserve 2003315884 1,677 - - - - - - - - - - 2,561 14,000 18% Coveleski Bond Debt Reserve317- - - - - - - - - - - - - - NA Central Development reserve3281,478 2,803 - - - - - - - - - - 4,281 20,000 21% SB Redevelopment Authority752- - - - - - - - - - - - - 3,365,829 0% Smart Streets Debt Svc756- - - - - - - - - - - - - 1,709,794 0% Sub Total 2,362 4,480 - - - - - - - - - - 6,842 5,109,623 0% Total Redevelopment5,531,828 2,901,918 - - - - - - - - - - 8,433,746 72,329,754 12% Total Expenditures25,418,045 23,903,907 - - - - - - - - - - 49,321,953 462,311,510 11% Monthly Financial Report 15 of 24 1st2nd3rd4th Civil City DebtCapital Leases 110 2013 PNC Vehicle & Equipment LeaseVehicles/Equipment 2013N/A2018Various1/157/15----1,689,669.59 346,724.77 346,724.77 3,175.76 - 349,900.53 112 2013 Building Department Ricoh CopierCopier Lease 2013N/A2018600Monthly26th----4,093.64 613.22 613.22 12.80 - 626.02 113 2013 Suntrust Vehicle LeaseVehicles/Equipment 2013N/A2018Various4/2410/24----1,506,465.26 310,880.69 310,880.69 3,700.46 - 314,581.15 114 2013 Administration & Finance Ricoh CopierCopier Lease 2013N/A20181011/164/167/1610/1611,247.97 634.57 634.57 9.23 - 643.80 117 2013 Police Department Records Division Ricoh Copier Copier Lea se 2013N/A2018101Monthly3rd----9,678.26 2,154.91 2,154.91 65.09 - 2,220.00 118 2013 Water Works Main Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----5,647.50 1,258.33 1,258.33 38.07 - 1,296.40 119 2013 Water Works Colfax Ricoh CopierCopier Lease 2013N/A2018620Monthly16th----4,732.65 1,054.61 1,054.61 31.91 - 1,086.52 120 2013 Water Works Olive Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----4,732.65 1,054.61 1,054.61 31.91 - 1,086.52 123 2014 Police Department Training Ricoh CopierCopier Lease 2014N/A2019101Monthly30th----4,263.00 1,186.17 941.47 42.53 244.70 984.00 124 2014 Police & Public Works VehiclesVehicles/Equipment 2014N/A2019Various4/110/1----1,959,485.95 801,993.28 397,900.73 10,895.81 404,092.55 408,796.54 125 2014 HP Computer Lease #1Computer Leases 2014N/A2018VariousMonthly8th----137,104.95 28,106.43 28,106.43 632.09 - 28,738.52 126 2014 HP Computer Lease #2Computer Leases 2014N/A2018VariousMonthly8th----4,000.00 915.42 915.42 22.56 - 937.98 127 2014 HP Computer Lease #4Computer Leases 2014N/A2018279Monthly8th----5,886.73 1,262.39 1,262.39 21.61 - 1,284.00 128 2014 HP Computer Lease #6Computer Leases 2014N/A2018201Monthly8th----3,755.50 959.08 959.08 23.80 - 982.88 129 2014 HP Computer Lease #7Computer Leases 2014N/A2018620Monthly8th----1,326.00 363.78 363.78 7.96 - 371.74 130 2014 Solid Waste Ricoh CopierCopier Lease 2014N/A2019611Monthly17th----5,351.65 2,230.54 1,133.42 96.22 1,097.12 1,229.64 131 2014 Police Communications CopierCopier Lease 2014N/A2019101Monthly12th----8,843.00 3,072.55 1,908.18 123.66 1,164.37 2,031.84 132 2014 Ricoh CopiersCopier Lease 2014N/A2019641Monthly21st----12,260.16 4,044.71 2,657.97 159.05 1,386.74 2,817.02 134 2014 Water Works Ricoh CopierCopier Lease 2014N/A2019620Monthly19th----4,732.65 1,139.81 1,048.77 36.75 91.04 1,085.52 136 2015 HP Computer Lease #8Computer Leases 2015N/A2019VariousMonthly16th----19,603.94 6,927.09 4,384.24 228.94 2,542.85 4,613.18 137 2015 Animal Care & Control Ricoh CopierCopier Lease 2015N/A2020600Monthly30th----5,261.50 2,558.51 1,095.38 120.46 1,463.13 1,215.84 138 2015 HP Computer Lease #9Computer Leases 2015N/A2019VariousMonthly------135,958.05 63,804.73 32,473.02 2,431.38 31,331.71 34,904.40 140 2015 Vehicle/Equip Lease No. 1Vehicles/Equipment 2015N/A2020Various1/157/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 Lease #11Computer Leases 2015N/A2019279Monthly------3,040.00 1,465.29 728.78 52.66 736.51 781.44 144 2015 Vehicle Lease No. 2 Vehicles/Equipment 2015N/A2020Various5/1511/15----1,267,183.00 772,239.72 253,474.52 10,920.36 518,765.20 264,394.88 146 2015 Ricoh Copier - ParksCopier Lease 2015N/A2020201Monthly------4,302.06 2,644.67 857.61 129.03 1,787.06 986.64 147 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------32,525.00 22,620.32 6,374.04 1,041.72 16,246.28 7,415.76 148 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------11,413.00 7,937.47 2,236.63 365.57 5,700.84 2,602.20 149 2016 Vehicle/Equip Lease No. 1Vehicles/Equipment 2016N/A2021Various2/158/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 Lease #12Computer Leases 2016N/A2020VariousMonthly------17,439.85 10,105.08 4,096.37 386.83 6,008.71 4,483.20 151 2016 Administration & Finance CopierCopier Lease 2016N/A2021101Monthly------10,923.63 6,891.18 2,167.29 337.95 4,723.89 2,505.24 152 2016 Vehicle/Equip Lease No. 2Vehicles/Equipment 2016N/A2021Various1/147/14----3,992,548.72 3,222,157.09 787,307.33 46,068.99 2,434,849.76 833,376.32 153 2016 Vehicle/Equip Lease Amendment No. 1Vehicles/Equipment 2016N/A20212011/177/17----78,808.00 63,520.71 15,520.85 907.95 47,999.86 16,428.80 154 2016 Vehicle/Equip Lease No. 3Vehicles/Equipment 2016N/A2021Various4/1910/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 Lease #13Computer Leases 2016N/A2020VariousMonthly------156,029.30 116,995.36 35,245.46 4,936.18 81,749.90 40,181.64 157 2016 Ricoh Copier MPC2003Copier Lease 2016N/A2021201Monthly----3,184.06 2,265.55 615.22 165.38 1,650.33 780.60 158 2017 Vehicle/Equip Lease No. 1Vehicles/Equipment 2017N/A2022Various1/147/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 LeaseCopier Lease 2017N/A2021VariousMonthly------15,702.09 12,417.04 3,729.79 773.57 8,687.25 4,503.36 160 2017 HP Computer Lease #14Computer Leases 2017N/A2021VariousMonthly------10,305.25 8,452.80 2,317.66 337.22 6,135.14 2,654.88 162 2017 Vehicle/Equip Lease No. 2Vehicles/Equipment 2017N/A20224042/158/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 Lease #16Computer Leases 2017N/A2021VariousMonthly21st----108,921.75 101,278.63 23,670.40 4,316.12 77,608.23 27,986.52 Total City Capital Lease Debt 23,826,126.88 15,946,280.30 4,734,996.64 269,496.92 11,211,283.66 5,004,493.56 Bonds 25 2002/2012 Refunding Water Works Improvements Various Water Depa rtment projects 2002201220236251/17/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 Works Service Center (Bldg Corp) (87.7%)Public Work s Service Center 2001201020213242/18/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 Works Service Center (Bldg Corp) (12.3%)Public Work s Service Center 2001201020216412/18/1--1,137,750.00 268,140.00 73,185.00 9,444.00 194,955.00 82,629.00 39 2012 Fire Station/Police Department Renovations (Bldg Corp)New Central Fire and Police buildings 2003201220233242/18/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 Water Works Improvements, Series BVarious Water Department projects 2009N/A20306251/17/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 Wastewater Department p rojects 2010N/A20306496/112/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 Wastewater Long Term Control Pl an 2011N/A20316496/112/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 Water Works Revenue BondWater Works Improvements 2012N/A20336251/17/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 Wastewater Long Term Control Pl an 2012N/A20326496/112/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 BondsWastewater Long Term Control Pl an 2013N/A20246496/112/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 Corporation EMS Fire Station/Tower BondsFire Stat ion #5 & Training Tower 2013N/A20332872/18/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 (EDIT)City's share of PSAP building 2014N/A2034408MonthlyLast----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 BondsParks Improvements 2015N/A20354082/18/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 Refunding BondsSewer Bond Improvements 2015201520256496/112/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 Waterworks Refunding BondsWater Bond Refunding 2016N/A20276251/17/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 Develop. Revenue Bonds (Studebaker Project)Façade Improvements - Buidling 84 2017N/A2018324One Time------3,500,000.00 3,500,000.00 3,500,000.00 - - 3,500,000.00 163 2017 Eddy Street Commons Phase IIEddy Street Commons Phase II 2017N/A20374362/158/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-KProjects to improve Cit y parks 2017N/A20333121/157/15----14,075,000.00 14,075,000.00 350,000.00 243,303.69 13,725,000.00 593,303.69 Total City Bond Debt 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 Interfund Fund 404 to UDAG Fund 4101st Source Bank/Marriot t Garage Project 2010N/A20264106/1512/15--2,700,000.00 966,334.50 132,618.30 - 833,716.20 132,618.30 84 2011/2013 Major Moves-Triangle Development Interfund LoanTriang le Development Infrastructure 20112011/201320294362/158/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-Eddy Street Commons Interfund LoanTriangl e Development Infrastructure 20112011/201320264362/158/15--3,942,529.00 1,922,964.03 279,741.40 92,694.60 1,643,222.63 372,436.00 142 2016 Interfund Fund 412 to Parking Garage Fund 601Parking Garag e Improvements 2016N/A2022601JuneDec----1,511,331.00 31,191.33 31,191.33 - - 31,191.33 Total City Interfund Loan Debt 9,711,910.00 4,155,367.00 540,226.46 116,911.17 3,615,140.54 657,137.63 Loan Payable 68 2009 Water Works Improvements - State Revolving FundVarious Wat er Department projects 2009N/A20306251/17/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 Revolving FundVarious W astewater Department projects 2009N/A20286496/112/1--3,297,000.00 2,087,171.00 167,038.00 58,650.00 1,920,133.00 225,688.00 122 2014 Synagogue Installment Purchase AgreementImprovements at Sy nagogue - Coveleski 2014N/A2018377Annual1/31----500,000.00 100,000.00 100,000.00 - - 100,000.00 139 2015 Century Center Energy QECB Conservation BondImrovements at Century Center 2015N/A20316725/111/1----4,167,897.00 4,098,706.00 162,702.00 143,034.35 3,936,004.00 305,736.35 Total City Loan Payable Debt 8,392,297.00 6,597,527.00 451,357.00 212,186.95 6,146,170.00 663,543.95 Total Civil City Debt 249,938,030.3 8 178,553,029.3 0 20,432,215.1 0 5,365,120.9 3 158,120,814.2 0 25,797,336.0 3 Period Ending: February 28, 2018 Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. AmountIssued Debt at 12/31/17 2018 PrincipalPayments 2018 InterestPayments City of South BendOutstanding Debt Debt at 12/31/18 2018 Total Debt Payments Scheduled Payments Debt Sched. Monthly Financial Report 16 of 24 1st2nd3rd4th Period Ending: February 28, 2018 Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. AmountIssued Debt at 12/31/17 2018 PrincipalPayments 2018 InterestPayments City of South BendOutstanding Debt Debt at 12/31/18 2018 Total Debt Payments Scheduled Payments Debt Sched. Redevelopment Commission DebtCapital Leases 13 2006 Main/Colfax Garage - Transpo LeaseReal Estate Purchase 2006N/A20253243/159/15--2,510,278.00 1,305,501.00 136,409.00 63,591.00 1,169,092.00 200,000.00 Total Redevelopment Capital Lease Debt 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 Interfund Fund 209 to Airport TIF Fund 324Prairie Avenue - Brownfields Cleanup Loan 2011N/A20203248/9----500,000.00 300,000.00 100,000.00 - 200,000.00 100,000.00 Total Redevelopment Interfund Loan Debt 500,000.00 300,000.00 100,000.00 - 200,000.00 100,000.00 Loans Payable 3 2001 Indiana Development Finance Authority (Bosch) - Nonforgiva bleRehabilitate Property 2001N/A20212103/226/229/2212/221,040,000.00 238,409.07 65,591.47 6,418.97 172,817.60 72,010.44 4 2001 Indiana Development Finance Authority (Bosch) - Forgivable Rehabilitate Property 2001N/A2021210 ---- 260,000.00 65,888.51 - - 65,888.51 - Total Redevelopment Loan Payable Debt 1,300,000.00 304,297.58 65,591.47 6,418.97 238,706.11 72,010.44 Revenue Bonds 5 2011 South Bend Downtown Central Development Area TIFPublic Imp rovements 200320112024420/3242/18/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 TIFPublic Improvements 2003201120243242/18/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 Century Center Lease Rental RevenueRehabilitation of a con vention center 19942001, 20112018404/4072/18/1--6,825,000.00 245,000.00 245,000.00 3,675.00 - 248,675.00 8 2011 College Football Hall of Fame ConstructionConstruction of a building 19942000, 201120183132/18/1--15,370,000.00 620,000.00 620,000.00 11,315.00 - 631,315.00 12 2002 TJX Special Taxing District (Refunded 2014)Public Improvem ents 2002201420223241/17/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 Rental Revenue BondsParki ng Garage/Public Improvements 2008N/A20274362/158/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 Century Center Special Tax BondsCentury Center Improv ements 2008201320263244/1510/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. BondsCovele ski Stadium Area Expansion/Improve 2010N/A20193771/157/15--4,980,000.00 1,015,000.00 670,000.00 44,070.00 345,000.00 714,070.00 135 2015 Redevelopment Authority Smart Streets BondsSmart Streets I mprovements 2015N/A20373248/12/1----25,000,000.00 24,540,000.00 940,000.00 768,793.76 23,600,000.00 1,708,793.76 Total Redevelopment Revenue Bond Debt 133,665,000.00 77,410,000.00 6,740,000.00 2,910,694.02 70,670,000.00 9,650,694.02 Total Redevelopment Commission Debt 137,975,278.0 0 79,319,798.5 8 7,042,000.4 7 2,980,703.99 72,277,798.11 10,022,704.4 6 Total Debt 387,913,308.3 8 257,872,827.8 8 27,474,215.5 7 8,345,824.9 2 230,398,612.31 35,820,040.4 9 Monthly Financial Report 17 of 24 1st2nd3rd4th Civil City DebtCapital Leases 110 2013 PNC Vehicle & Equipment LeaseVehicles/Equipment 2013N/A2018Various1/157/15----1,689,669.59 346,724.77 172,835.24 2,115.02 - 174,950.26 112 2013 Building Department Ricoh CopierCopier Lease 2013N/A2018600Monthly26th----4,093.64 613.22 151.19 5.31 462.03 156.50 113 2013 Suntrust Vehicle LeaseVehicles/Equipment 2013N/A2018Various4/2410/24----1,506,465.26 310,880.69 - - 310,880.69 - 114 2013 Administration & Finance Ricoh CopierCopier Lease 2013N/A20181011/164/167/1610/1611,247.97 634.57 633.58 9.23 0.99 642.81 117 2013 Police Department Records Division Ricoh Copier Copier Lea se 2013N/A2018101Monthly3rd----9,678.26 2,154.91 352.57 17.43 1,802.34 370.00 118 2013 Water Works Main Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----5,647.50 1,258.33 204.77 11.13 1,053.56 215.90 119 2013 Water Works Colfax Ricoh CopierCopier Lease 2013N/A2018620Monthly16th----4,732.65 1,054.61 171.59 9.33 883.02 180.92 120 2013 Water Works Olive Street Ricoh CopierCopier Lease 2013N/A2018620Monthly10th----4,732.65 1,054.61 171.59 9.33 883.02 180.92 123 2014 Police Department Training Ricoh CopierCopier Lease 2014N/A2019101Monthly30th----4,263.00 1,186.17 153.28 10.72 1,032.89 164.00 124 2014 Police & Public Works VehiclesVehicles/Equipment 2014N/A2019Various4/110/1----1,959,485.95 801,993.28 - - 801,993.28 - 125 2014 HP Computer Lease #1Computer Leases 2014N/A2018VariousMonthly8th----137,104.95 28,106.43 5,603.72 200.34 22,502.71 5,804.06 126 2014 HP Computer Lease #2Computer Leases 2014N/A2018VariousMonthly8th----4,000.00 915.42 163.34 6.74 752.08 170.08 127 2014 HP Computer Lease #4Computer Leases 2014N/A2018279Monthly8th----5,886.73 1,262.39 241.59 4.07 1,020.80 245.66 128 2014 HP Computer Lease #6Computer Leases 2014N/A2018201Monthly8th----3,755.50 959.08 152.05 7.75 807.03 159.80 129 2014 HP Computer Lease #7Computer Leases 2014N/A2018620Monthly8th----1,326.00 363.78 53.92 2.22 309.86 56.14 130 2014 Solid Waste Ricoh CopierCopier Lease 2014N/A2019611Monthly17th----5,351.65 2,230.54 184.53 20.41 2,046.01 204.94 131 2014 Police Communications CopierCopier Lease 2014N/A2019101Monthly12th----8,843.00 3,072.55 310.57 27.97 2,761.98 338.54 132 2014 Ricoh CopiersCopier Lease 2014N/A2019641Monthly21st----12,260.16 4,044.71 432.74 36.76 3,611.97 469.50 134 2014 Water Works Ricoh CopierCopier Lease 2014N/A2019620Monthly19th----4,732.65 1,139.81 170.80 10.12 969.01 180.92 136 2015 HP Computer Lease #8Computer Leases 2015N/A2019VariousMonthly16th----19,603.94 6,927.09 390.26 29.12 6,536.83 419.38 137 2015 Animal Care & Control Ricoh CopierCopier Lease 2015N/A2020600Monthly30th----5,261.50 2,558.51 178.16 24.48 2,380.35 202.64 138 2015 HP Computer Lease #9Computer Leases 2015N/A2019VariousMonthly------135,958.05 63,804.73 5,301.25 516.15 58,503.48 5,817.40 140 2015 Vehicle/Equip Lease No. 1Vehicles/Equipment 2015N/A2020Various1/157/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 Lease #11Computer Leases 2015N/A2019279Monthly------3,040.00 1,465.29 119.13 11.11 1,346.16 130.24 144 2015 Vehicle Lease No. 2 Vehicles/Equipment 2015N/A2020Various5/1511/15----1,267,183.00 772,239.72 - - 772,239.72 - 146 2015 Ricoh Copier - ParksCopier Lease 2015N/A2020201Monthly------4,302.06 2,644.67 - - 2,644.67 - 147 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------32,525.00 22,620.32 1,043.73 192.23 21,576.59 1,235.96 148 2016 Central Services - Print Shop CopierCopier Lease 2016N/A2020222Monthly------11,413.00 7,937.47 366.24 67.46 7,571.23 433.70 149 2016 Vehicle/Equip Lease No. 1Vehicles/Equipment 2016N/A2021Various2/158/15----3,339,830.00 2,364,700.45 324,595.10 24,101.71 2,040,105.35 348,696.81 150 2016 HP Computer Lease #12Computer Leases 2016N/A2020VariousMonthly------17,439.85 10,105.08 654.11 93.09 9,450.97 747.20 151 2016 Administration & Finance CopierCopier Lease 2016N/A2021101Monthly------10,923.63 6,891.18 351.84 65.70 6,539.34 417.54 152 2016 Vehicle/Equip Lease No. 2Vehicles/Equipment 2016N/A2021Various1/147/14----3,992,548.72 3,222,157.09 392,161.10 24,527.06 2,829,995.99 416,688.16 153 2016 Vehicle/Equip Lease Amendment No. 1Vehicles/Equipment 2016N/A20212011/177/17----78,808.00 63,520.71 7,731.01 483.39 55,789.70 8,214.40 154 2016 Vehicle/Equip Lease No. 3Vehicles/Equipment 2016N/A2021Various4/1910/19----1,256,096.99 1,012,026.89 - - 1,012,026.89 - 155 2016 HP Computer Lease #13Computer Leases 2016N/A2020VariousMonthly------156,029.30 116,995.36 5,755.50 941.44 111,239.86 6,696.94 157 2016 Ricoh Copier MPC2003Copier Lease 2016N/A2021201Monthly----3,184.06 2,265.55 49.34 15.71 2,216.21 65.05 158 2017 Vehicle/Equip Lease No. 1Vehicles/Equipment 2017N/A2022Various1/147/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 LeaseCopier Lease 2017N/A2021VariousMonthly------15,702.09 12,417.04 603.17 147.39 11,813.87 750.56 160 2017 HP Computer Lease #14Computer Leases 2017N/A2021VariousMonthly------10,305.25 8,452.80 189.85 31.39 8,262.95 221.24 162 2017 Vehicle/Equip Lease No. 2Vehicles/Equipment 2017N/A20224042/158/15----1,632,000.00 1,632,000.00 156,582.83 15,422.42 1,475,417.17 172,005.25 164 2017 HP Computer Lease #16Computer Leases 2017N/A2021VariousMonthly21st----108,921.75 101,278.63 3,911.89 752.53 97,366.74 4,664.42 Total City Capital Lease Debt 23,826,126.88 15,946,280.30 1,688,331.49 130,049.03 14,084,059.28 1,818,380.52 Bonds 25 2002/2012 Refunding Water Works Improvements Various Water Depa rtment projects 2002201220236251/17/1--5,975,000.00 2,005,000.00 - - 2,005,000.00 - 36 2001 Public Works Service Center (Bldg Corp) (87.7%)Public Work s Service Center 2001201020213242/18/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 Works Service Center (Bldg Corp) (12.3%)Public Work s Service Center 2001201020216412/18/1--1,137,750.00 268,140.00 37,272.50 5,227.50 230,867.50 42,500.00 39 2012 Fire Station/Police Department Renovations (Bldg Corp)New Central Fire and Police buildings 2003201220233242/18/1--21,335,000.00 7,645,000.00 635,000.00 150,000.00 7,010,000.00 785,000.00 69 2009 Water Works Improvements, Series BVarious Water Department projects 2009N/A20306251/17/1--5,380,000.00 4,085,000.00 - - 4,085,000.00 - 80 2010 Sewage Works Revenue Bonds Various Wastewater Department p rojects 2010N/A20306496/112/1--9,345,000.00 6,750,000.00 - - 6,750,000.00 - 93 2011 Sewage Works Revenue Bonds Wastewater Long Term Control Pl an 2011N/A20316496/112/1--21,500,000.00 16,400,000.00 - - 16,400,000.00 - 99 2012 Water Works Revenue BondWater Works Improvements 2012N/A20336251/17/1----8,300,000.00 6,570,000.00 - - 6,570,000.00 - 101 2012 Sewage Works Revenue Bonds Wastewater Long Term Control Pl an 2012N/A20326496/112/1--25,000,000.00 19,830,000.00 - - 19,830,000.00 - 105 2013A Sewage Works Revenue BondsWastewater Long Term Control Pl an 2013N/A20246496/112/1--14,765,000.00 6,095,000.00 - - 6,095,000.00 - 116 2013 Building Corporation EMS Fire Station/Tower BondsFire Stat ion #5 & Training Tower 2013N/A20332872/18/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 (EDIT)City's share of PSAP building 2014N/A2034408MonthlyLast----2,657,696.50 2,278,855.00 - - 2,278,855.00 - 141 2015 EDIT/Parks BondsParks Improvements 2015N/A20354082/18/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 Refunding BondsSewer Bond Improvements 2015201520256496/112/1----27,440,000.00 22,435,000.00 - - 22,435,000.00 - 156 2016 Waterworks Refunding BondsWater Bond Refunding 2016N/A20276251/17/1----3,300,000.00 2,895,000.00 - - 2,895,000.00 - 161 2017 Economic Develop. Revenue Bonds (Studebaker Project)Façade Improvements - Buidling 84 2017N/A2018324One Time------3,500,000.00 3,500,000.00 - - 3,500,000.00 - 163 2017 Eddy Street Commons Phase IIEddy Street Commons Phase II 2017N/A20374362/158/15----25,000,000.00 25,000,000.00 - 628,472.19 25,000,000.00 628,472.19 165 2017 Park District Bonds, Series 2017A-KProjects to improve Cit y parks 2017N/A20333121/157/15----14,075,000.00 14,075,000.00 - - 14,075,000.00 - Total City Bond Debt 208,007,696.50 151,853,855.00 1,060,987.50 922,695.63 150,792,867.50 1,983,683.13 Interfund Loan 82 2010 Interfund Fund 404 to UDAG Fund 4101st Source Bank/Marriot t Garage Project 2010N/A20264106/1512/15--2,700,000.00 966,334.50 31,813.50 - 934,521.00 31,813.50 84 2011/2013 Major Moves-Triangle Development Interf und LoanTriangle Developmen t Infrastructure 20112011/201320294362/158/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-Eddy Street Commons Interfund LoanTriangl e Development Infrastructure 20112011/201320264362/158/15--3,942,529.00 1,922,964.03 138,143.90 48,074.10 1,784,820.13 186,218.00 142 2016 Interfund Fund 412 to Parking Garage Fund 601Parking Garag e Improvements 2016N/A2022601JuneDec----1,511,331.00 31,191.33 - - 31,191.33 - Total City Interfund Loan Debt 9,711,910.00 4,155,367.00 218,054.63 60,422.87 3,937,312.37 278,477.50 Loan Payable 68 2009 Water Works Improvements - State Revolving FundVarious Wat er Department projects 2009N/A20306251/17/1--427,400.00 311,650.00 - - 311,650.00 - 70 2009 Sewage Works Revenue Bonds - State Revolving FundVarious W astewater Department projects 2009N/A20286496/112/1--3,297,000.00 2,087,171.00 - - 2,087,171.00 - 122 2014 Synagogue Installment Purchase AgreementImprovements at Sy nagogue - Coveleski 2014N/A2018377Annual1/31----500,000.00 100,000.00 - - 100,000.00 - 139 2015 Century Center Energy QECB Conservation BondImrovements at Century Center 2015N/A20316725/111/1----4,167,897.00 4,098,706.00 - - 4,098,706.00 - Total City Loan Payable Debt 8,392,297.00 6,597,527.00 - - 6,597,527.00 - Total Civil City Debt 249,938,030.38 178,553,029.30 2,967,373.62 1,113,167.53 175,411,766.15 4,080,541.15 City of South Bend Period Ending: February 28, 2018 Debt Payments Year-to-DateDebt Sched. Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. Debt at 02/28/18 Total YTD Debt Payments Scheduled Payments AmountIssued Debt at 12/31/17 YTD PrincipalPayments YTD InterestPayments Monthly Financial Report 18 of 24 1st2nd3rd4th City of South Bend Period Ending: February 28, 2018 Debt Payments Year-to-DateDebt Sched. Debt InstrumentDebt Purpose Year ofIssue Year of Refinance Year of Maturity FundNo. Debt at 02/28/18 Total YTD Debt Payments Scheduled Payments AmountIssued Debt at 12/31/17 YTD PrincipalPayments YTD InterestPayments Redevelopment Commission DebtCapital Leases 13 2006 Main/Colfax Garage - Transpo LeaseReal Estate Purchase 2006N/A20253243/159/15--2,510,278.00 1,305,501.00 - - 1,305,501.00 - Total Redevelopment Capital Lease Debt 2,510,278.00 1,305,501.00 - - 1,305,501.00 - Interfund Loans 86 2010 Interfund Fund 209 to Airport TIF Fund 324Prairie Avenue - Brownfields Cleanup Loan 2011N/A20203248/9----500,000.00 300,000.00 - - 300,000.00 - Total Redevelopment Interfund Loan Debt 500,000.00 300,000.00 - - 300,000.00 - Loans Payable 3 2001 Indiana Development Finance Authority (Bosch) - Nonforgiva bleRehabilitate Property 2001N/A20212103/226/229/2212/221,040,000.00 238,409.07 - - 238,409.07 - 4 2001 Indiana Development Finance Authority (Bosch) - Forgivable Rehabilitate Property 2001N/A2021210 ---- 260,000.00 65,888.51 - - 65,888.51 - Total Redevelopment Loan Payable Debt 1,300,000.00 304,297.58 - - 304,297.58 - Revenue Bonds 5 2011 South Bend Downtown Central Development Area TIFPublic Imp rovements 200320112024420/3242/18/1--19,795,000.00 11,185,000.00 680,000.00 276,641.50 10,505,000.00 956,641.50 6 2011 Airport Development Area TIFPublic Improvements 2003201120243242/18/1--14,420,000.00 6,375,000.00 390,000.00 157,666.75 5,985,000.00 547,666.75 7 2011 Century Center Lease Rental RevenueRehab ilitation of a convention center 19942001, 20112018404/4072/18/1--6,825,000.00 245,000.00 245,000.00 4,500.00 - 249,500.00 8 2011 College Football Hall of Fame ConstructionConstruction of a building 19942000, 201120183132/18/1--15,370,000.00 620,000.00 620,000.00 13,000.00 - 633,000.00 12 2002 TJX Special Taxing District (Refunded 2014)Public Improvem ents 2002201420223241/17/1--6,620,000.00 1,795,000.00 - - 1,795,000.00 - 54 2015/2008 Eddy Street Commons - Lease Rental Revenue BondsParki ng Garage/Public Improvements 2008N/A20274362/158/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 Century Center Special Tax BondsCentury Center Improv ements 2008201320263244/1510/15--4,655,000.00 2,875,000.00 - - 2,875,000.00 - 81 2010 Coveleski Stadium Recovery Zone Econ. Develop. BondsCoveleski Stadium Area Expansion/Improve 2010N/A20193771/157/15--4,980,000.00 1,015,000.00 335,000.00 26,390.00 680,000.00 361,390.00 135 2015 Redevelopment Authority Smart Streets BondsSmart Streets I mprovements 2015N/A20373248/12/1----25,000,000.00 24,540,000.00 465,000.00 391,500.00 24,075,000.00 856,500.00 Total Redevelopment Revenue Bond Debt 133,665,000.00 77,410,000.00 3,410,000.00 1,429,198.25 74,000,000.00 4,839,198.25 Total Redevelopment Commission Debt 137,975,278.00 79,319,798.58 3,410,000.00 1,429,198.25 75,909,798.58 4,839,198.25 Total Debt 387,913,308.38 257,872,827.88 6,377,373.62 2,542,365.78 251,321,564.73 8,919,739.40 Monthly Financial Report 19 of 24 City of South BendStaffing HeadcountFull-Time Summary by Fund Budget JanFebMarAprMayJunJulAugSepOctNovDec 101 - General Fund 101-0101 Mayor's Office7 7 7 101-0201 City Clerk5 5 5 101-0301 Common Council9 9 9 101-0401 Administration & Finance24 21 22 101-0404 Morris PAC7 7 7 101-0405 Palais Royale2 2 2 101-0501 Legal Dept10 10 9 101-0602 Engineering Dept21 22 22 101-0801 Police Dept248 242 242 101-0901 Fire Dept178 184 184 101-1008 Human Rights3 3 3 514 512 512 - - - - - - - - - - 201 - Parks & Recreation201-1100 Administration6 7 7 201-1101 Maintenance47 49 49 201-1102 Golf Courses8 8 8 201-1103 Recreation21 21 21 201-1104 Potawatomi Zoo1 1 1 201-1108 Graffiti Removal1 1 1 201-1110 Marketing & Events11 10 10 95 97 97 - - - - - - - - - - 202 - Motor Vehicle Highway202-0607 Street Department43 48 47 202-0619 Curb & Sidewalk Program4 5 5 47 53 52 - - - - - - - - - - 203 - Recreation Non-Reverting203-1103 Recreation 1 - - 211 - Dept of Community Investment Administration211-1001 DCI 25 24 24 219 - Unsafe Building219-1209 NEAT Crew 4 4 4 222 - Central Services222-0605 Equipment Services32 29 29 222-0606 Building Maintenance3 3 3 222-0612 Central Stores2 4 4 222-0613 Print Shop1 1 1 222-0614 Radio Shop3 3 3 222-0616 Office of Sustainability2 1 1 43 41 41 - - - - - - - - - - 226 - Liability Insurance226-0403 Safety & Risk2 2 2 226-0412 Liability Insurance1113 3 3 - - - - - - - - - - Monthly Financial Report 20 of 24 City of South BendStaffing HeadcountFull-Time Summary by Fund Budget JanFebMarAprMayJunJulAugSepOctNovDec 249 - Public Safety LOIT249-0805 Police Department43 43 43 249-0905 Fire Department35 35 35 78 78 78 - - - - - - - - - - 258 - Human Rights Grants258-1008 EEOC1 1 1 258-1009 HUD1 1 1 2 2 2 - - - - - - - - - - 279 - IT / Innovation / 311 Call Center279-0104 311 Call Center7 7 7 279-0672 Innovation & Technology20 17 17 27 24 24 - - - - - - - - - - 288 - Emergency Medical Services288-0902 EMS 51 48 48 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce.15 16 16 600-1207 Animal Care & Control8 8 8 600-1306 Building Department18 13 13 41 37 37 - - - - - - - - - - 610 - Solid Waste 610-0610 Solid Waste 24 22 22 620 - Water Works O&M620-0640 Water Works 67 66 66 640 - Sewer Insurance640-0620 Sewer Repair 2 2 2 641 - Sewage Works O&M 641-0621 Sewer Department35 35 35 641-0625 Concrete Crew5 3 3 641-0630 Wastewater Department46 44 45 641-0631 Organic Resources6 6 6 92 88 89 - - - - - - - - - - Total Full-Time Employees by Fund1,116 1,101 1,101 - - - - - - - - - - Monthly Financial Report 21 of 24 City of South BendStaffing HeadcountFull-Time Summary by Activity Budget JanFebMarAprMayJunJulAugSepOctNovDec General Government Mayor's Office7 7 7 City Clerk5 5 5 Common Council9 9 9 Administration & Finance24 21 22 Legal Dept10 10 9 55 52 52 - - - - - - - - - - Code Enforcement / Animal Care & Control27 28 28 - - - - - - - - - - Dept. of Community Investment25 24 24 - - - - - - - - - - Venues, Parks & ArtsParks & Recreation96 97 97 Morris PAC & Palais Royale9 9 9 105 106 106 - - - - - - - - - - Public Safety Police - Sworn Officers248 241 241 Police - Civilians43 44 44 Fire/EMS - Sworn Firefighters257 260 260 Fire/EMS - Civilians7 7 7 555 552 552 - - - - - - - - - - Public Works Office of Sustainability2 1 1 Engineering Dept21 22 22 Streets & Sewers89 93 92 Solid Waste24 22 22 Wastewater Department46 44 45 Organic Resources6 6 6 Water Works67 66 66 255 254 254 - - - - - - - - - - Liability Insurance/Safety & Risk3 3 3 - - - - - - - - - - Innovation & Technology / 311 Call Center27 24 24 - - - - - - - - - - Central Services41 40 40 - - - - - - - - - - Building Department18 13 13 - - - - - - - - - - Human Rights5 5 5 - - - - - - - - - - Total Full-Time Employees by Activity1,116 1,101 1,101 - - - - - - - - - - Monthly Financial Report 22 of 24 City of South BendStaffing HeadcountPart-Time Summary by Fund JanFebMarAprMayJunJulAugSepOctNovDec 101 - General Fund 101-0404 Morris PAC33 101-0501 Legal Dept22 101-0602 Engineering Dept44 101-0801 Police Dept2525 34 34 - - - - - - - - - - 201 - Parks & Recreation201-1100 Administration11 201-1101 Maintenance77 201-1103 Recreation1818 201-1108 Graffiti Removal11 27 27 - - - - - - - - - - 202 - Motor Vehicle Highway202-0607 Street Department 4 4 203 - Recreation Non-Reverting203-1103 Recreation 25 25 211 - Dept of Community Investment Administration211-1001 DCI 1 - 222 - Central Services222-0605 Equipment Services 1 1 279 - IT / Innovation / 311 Call Center279-0104 311 Call Center 1 1 288 - Emergency Medical Services288-0902 EMS 1 1 600 - Consolidated Building Dept.600-1201 Neighborhood Code Enforce.2 3 600-1207 Animal Care & Control2 2 4 5 - - - - - - - - - - 620 - Water Works O&M620-0640 Water Works 3 3 641 - Sewage Works O&M 641-0621 Sewer Department 4 4 Total Part-Time Employees by Fund105 99 - - - - - - - - - - Monthly Financial Report 23 of 24 City of South BendStaffing HeadcountPaid Temporary, Seasonal, and Intern Staff JanFebMarAprMayJunJulAugSepOctNovDec 201 - Parks & Recreation201-1100 Administration 1 1 203 - Recreation Non-Reverting203-1103 Recreation 2 2 222 - Central Services222-0606 Building Maintenance 1 1 641 - Sewage Works O&M 641-0621 Sewer Department 1 1 Total Paid Temporary, Seasonal, and Intern Staff5 5 - - - - - - - - - - Summary Budget Full-Time JanFebMarAprMayJunJulAugSepOctNovDec Full Time Staff1,116 1,101 1,101 - - - - - - - - - - Part Time Staff105 99 - - - - - - - - - - Temporary / Seasonal5 5 - - - - - - - - - - City Total 1,11 6 1,211 1,205 - - - - - - - - - - Monthly Financial Report 24 of 24