Loading...
HomeMy WebLinkAbout2017-03 Financial ReportPeriod Ending: Issued By: City of South Bend Financial Report Tab Page Contents Narrative 2 Brief discussion on notable fund activity Revenue 3-10 City Revenues Prop Tax Rev 11-12 Property Tax Revenue Collection Status Expenditures 13-17 Expenditures by Fund and Department Debt 18-19 Debt Status Debt Monthly 20-21 Current Debt at Month End Headcount 22-25 Staffing Levels Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Deputy Chief of Staff Suzanna Fritzberg Controller John Murphy Deputy Controller Jennifer Hockenhull Director of Treasury Rahman Johnson Sr. Budget Analyst Amy O'Connor Department Heads Fiscal Officers City Common Council March 31, 2017 Controller 2017-03 Financial Report Mar Page 1 of 25 March 31, 2017 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). Revenue by Type Revenue by Fund -Fund 287 (EMS Capital), is at 141% of its budgeted revenue. This is revenue related to EMS and Medicare reimbursements. -Fund 258 (Human Rights). This is revenue related to grants received to battle housing and employment discrimination. -Fund 294 (Police Academy). This is revenue related to the advancement of present and future police officers. -Fund 217(Gift, Donation), is at 277% of its budgeted revenue. This is revenue received in the amount $50,000 from Notre Dame for the Dr. Martin Luther King and the Reverend Father Theodore Hesburgh statue. Property Taxes Total property taxes collected for the year 2015 was~$70.9 million or 94.76%of the tax levy.Specifically,in 2015 the City of South Bend received a total of$46,171,932 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 $24,742,902 in property tax revenue. Expenditures Debt Headcount If you have any questions regarding this report, please contact John Murphy at (574) 235-7678. As of March 2017,the City has spent 21%of budgeted expenditures,compared to 19%in March 2016.The General Fund has spent 22% of its 2017 budgeted expenditures,similar to 2016.The following funds have reached 50%or more of their budgeted expenditures as a result of bond payments: Fund 313 (Hall of Fame), Fund 377 (Professional Sports Development), and Fund 432 (TIF -Erskine Village). This month,various debt service payments were made in the amount of~$92,000 to Sun Trust,Kansas State Bank,PNC Bank,U.S.Bank and Ricoh USA.Payments are related to IT equipment leases,police/public works vehicles,solid waste containers,and sewer bonds.In addition the City added ~$2.9 million of debt this month for a copier lease and vehicles. The Full Time Headcount as of March was 1,082 vs.a budgeted amount of 1,116.Currently,there are a total of 34 vacant positions.The 34 open positions are in the following departments:General Government(5),Parks(3),Public Safety(5),Public Works(12),DCI(2), Morris and Palais (2), and Code Enforcement / Animal Control (5). For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 19%,compared to 18%in March 2016.Revenue type 369(Memorial Hospital)has reached 100%of its budgeted revenue.This is revenue from Leighton Plaza for common area fees.It is a lease between Memorial Hospital and the South Bend Redevelopment Commission. Also revenue type 317 (Hotel Motel Tax) has reached 100% of its budgeted revenue. As of March 2017,the general fund has reached 7%of its budgeted revenue,compared to 6%last year.The following funds have reached slightly above the normal percentage of their 2017 budgeted revenue amount at this time: Property taxes are received in June and December.Property taxes collected in 2016 totaled~$76.7 million.Civil city funds received ~$49.1 million and TIF funds received~$27.6 million.For 2016,the projected levy collection rate is 95%or$75.2 million.Please note, 2016 civil city funds are ~$2.4 million more than 2015 budget. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. 2017-03 Financial Report Mar Page 2 of 25 City of South Bend Period Ending:March 31, 2017 Revenue by Type Report 18,366,497 $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Property Tax 311 Property Tax Civil City various- - - - - - - - - - - - 48,373,228 0% 311 Property Tax TIF Districts various- - - - - - - - - - - - 27,254,124 0% Sub Total- - - - - - - - - - - - - 75,627,352 0% Income Tax 315 Econ Development Income Tax 408 883,344 883,344 866,667 - - - - - - - - - 2,633,354 10,433,361 25% 316 Local Option Income Tax - PS 249 622,302 622,302 622,302 - - - - - - - - - 1,866,905 7,467,618 25% 316 County Option Income Tax 404 871,605 871,605 871,605 - - - - - - - - - 2,614,816 10,459,265 25% Sub Total 2,377,250 2,377,250 2,360,574 - - - - - - - - - 7,115,075 28,360,244 25% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - - - - - - - - - 3,206,500 0% 312 Commercial Vehicle Tax various- - - - - - - - - - - - - 843,000 0% 317 Hotel Motel Tax Century Center 670 637,500 - (318,750) - - - - - - - - - 318,750 1,275,000 25% 317 Hotel Motel Tax Century Center 324- - - - - - - - - - - - - 394,000 0% 317 Hotel Motel Tax Cum Cap Imprv 407 150,000 - - - - - - - - - - - 150,000 150,000 100% Sub Total 787,500 - (318,750) - - - - - - - - - 468,750 5,868,500 8% State of Indiana (Remitted by) 312 CRED Tax 434- - - - - - - - - - - - - - NA 335 Cigarette Tax 101/407- - - - - - - - - - - - - 328,000 0% 335 State Pension Subsidy 701/702- - - - - - - - - - - - - 11,342,638 0% 335 Gaming Proceeds 101- - - - - - - - - - - - - 599,000 0% 335 Gasoline Tax 202/251 361,601 314,230 394,563 - - - - - - - - - 1,070,395 4,668,000 23% 335 Liquor Excise tax 101- 42,158 - - - - - - - - - - 42,158 75,000 56% 335 Liquor Gallonage Tax 101 63,498 - - - - - - - - - - - 63,498 210,000 30% 335 Prof Sports Development Tax 377 62,404 - 115,348 - - - - - - - - - 177,752 700,000 25% 335 Wheel Tax 202- - 503,523 - - - - - - - - - 503,523 2,050,000 25% Sub Total 487,503 356,388 1,013,434 - - - - - - - - - 1,857,325 19,972,638 9% Other Intergovernmental Sources 336 Federal Drug 299- - - - - - - - - - - - - 30,000 0% 337 State Drug 216 10,113 2,962 - - - - - - - - - - 13,076 35,000 37% 338 Payment in Lieu of Tax various 517,361 871,113 517,361 - - - - - - - - - 1,905,835 7,623,328 25% 339 Contractual Service 211 9,669 12,407 38,314 - - - - - - - - - 60,389 316,000 19% Sub Total 537,143 886,481 555,675 - - - - - - - - - 1,979,300 8,004,328 25% Charge for Service Internal City 340 Liability Insurance 226 243,168 243,964 241,179 - - - - - - - - - 728,311 2,927,591 25% 340 General Government Misc Chgs 101/289- - - - - - - - - - - - - 500 0% 340 Police Take Home Vehicle 278- - - - - - - - - - - - - - NA 349 Central Service 222 51,820 48,684 51,854 - - - - - - - - - 152,358 873,809 17% 380 Central Service 222 210,212 208,994 226,075 - - - - - - - - - 645,281 2,880,310 22% 380 Energy Office Reimbursements 222 411,202 429,754 368,989 - - - - - - - - - 1,209,945 4,492,800 27% 380 LOIT 2016 Special Distribution 257- - 152,895 - - - - - - - - - 152,895 - NA 380 IT Innovation 311 Center 279 430,621 430,621 430,621 - - - - - - - - - 1,291,863 5,205,034 25% 380 Beck's Lake Reimbursement 404- - 283,432 - - - - - - - - - 283,432 283,432 100% 380 INDOT SR 933 Transfer 324- - - - - - - - - - - - - 4,100,000 0% 380 Internal Service Reimbursement various 65,792 89,865 18,297 - - - - - - - - - 173,954 1,404,921 12% 392 Administration Fee 101/279 414,748 414,748 414,748 - - - - - - - - - 1,244,244 4,977,026 25% 392 Internal Fund Transfers various 1,085,348 9,754,150 4,553,299 - - - - - - - - - 15,392,797 40,689,247 38% 395 Employee Benefits 711/713 1,499,317 1,460,178 1,492,929 - - - - - - - - - 4,452,424 17,836,850 25% 2017-03 Fin anc i al Re port Mar - Reve nue Re port Page 3 of 25 City of South Bend Period Ending:March 31, 2017 Revenue by Type Report 18,366,497 $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 396 Central Service Refunds 222 1,314 - 62,668 - - - - - - - - - 63,982 21,000 305% 396 Self Funded Employee Benefits 711 6,503 (2,436) 496 - - - - - - - - - 4,563 - NA xxx xxx xxx- NA Sub Total 4,420,045 13,078,521 8,297,481 - - - - - - - - - 25,796,047 85,692,520 30% 3rd Party Revenue 340 ND EMS Service 288- - 44,904 - - - - - - - - - 44,904 150,000 30% 340 Memorial Hospital Neo Natal 101- - - - - - - - - - - - - - NA 350 Job Target Penalty Fee 408- 354,660 - - - - - - - - - - 354,660 354,660 100% 364 Cable TV Franchise Fees 101- 192,238 - - - - - - - - - - 192,238 748,000 26% 366 AT&T Franchise Fees 101 55,865 - - - - - - - - - - - 55,865 284,000 20% 393 Debt Proceeds 750- - - - - - - - - - - - - 5,499,000 0% Sub Total 55,865 546,898 44,904 - - - - - - - - - 647,667 7,035,660 9% Grants 331 Federal Grants various 468,447 1,200,229 111,355 - - - - - - - - - 1,780,031 5,681,386 31% 332 Solar Energy Grant 222- - - - - - - - - - - - - - NA 334 State Grants various- - 33,745 - - - - - - - - - 33,745 20,000 169% Sub Total 468,447 1,200,229 145,100 - - - - - - - - - 1,813,776 5,701,386 32% Fees for Services External 320 Inspections Central Service 222- - - - - - - - - - - - - 1,450 0% 321 Business License 101/222 30,917 29,318 15,746 - - - - - - - - - 75,981 120,130 63% 321 Code and Animal Fees 600 4,536 4,585 6,015 - - - - - - - - - 15,135 54,500 28% 322 Building Fees 600 90,363 86,593 108,895 - - - - - - - - - 285,851 1,360,350 21% 322 Code Enforcement Fees 600 1,050 300 3,000 - - - - - - - - - 4,350 20,000 22% 322 EMS Operating Fund 288 1,923 1,380 1,542 - - - - - - - - - 4,845 24,000 20% 322 General Government Fees 101 32,047 7,275 12,535 - - - - - - - - - 51,857 100,000 52% 341 General Government Various various 3,316 959 5,210 - - - - - - - - - 9,485 27,005 35% 342 Highway & Streets 101/202 38,686 - 16,474 - - - - - - - - - 55,160 223,365 25% 342 Public Safety various 12,869 10,404 21,290 - - - - - - - - - 44,564 150,000 30% 342 EMS - County Fees 288- 294,414 147,207 - - - - - - - - - 441,621 1,740,000 25% 342 EMS - Capital Fund 287- 1,798,417 - - - - - - - - - - 1,798,417 1,275,000 141% 342 EMS - Operating Fund 288 160,939 235,524 271,371 - - - - - - - - - 667,835 2,700,000 25% 342 EMS - Neo Natal / Transport 288 16,185 18,553 16,128 - - - - - - - - - 50,866 1,699,512 3% 344 Solid Waste 610 445,203 460,843 468,017 - - - - - - - - - 1,374,063 5,636,175 24% 344 Code Environmental Clean Up 101/219/600 12,404 3,044 22,134 - - - - - - - - - 37,581 180,000 21% 344 Sewage Waste Water 641 3,208,590 3,128,008 3,112,534 - - - - - - - - - 9,449,132 37,020,404 26% 344 Sewer Repair Insurance 640 53,614 52,952 53,742 - - - - - - - - - 160,307 613,924 26% 344 Water Leak Insurance 620 81,303 81,237 81,371 - - - - - - - - - 243,911 1,173,361 21% 346 Water Works Utility 620 1,039,872 1,012,523 1,016,299 - - - - - - - - - 3,068,695 16,175,473 19% 346 Solid Waste Misc 610 1,504 10,324 12,564 - - - - - - - - - 24,392 110,000 22% 346 Project ReLeaf 655 36,802 36,730 36,817 - - - - - - - - - 110,349 440,153 25% 347 Parks & Recreation various 74,837 77,843 366,527 - - - - - - - - - 519,207 4,337,134 12% 347 Sale of Merchandise 101- - - - - - - - - - - - - 100 0% 347 Morris PAC 416- 12,214 13,143 - - - - - - - - - 25,357 100,000 25% 349 Parking Garage Fees 601 115,464 73,834 83,097 - - - - - - - - - 272,395 986,129 28% 349 Code Demolition Board Up 219/600 2,805 2,067 13,981 - - - - - - - - - 18,853 90,000 21% 349 Parking Century Center 670 12,814 19,676 20,911 - - - - - - - - - 53,400 100,033 53% 349 Parking SBCDA 324/429 350 700 350 - - - - - - - - - 1,400 8,400 17% 351 Fines & Fees various 27,430 36,628 37,210 - - - - - - - - - 101,268 252,720 40% 352 Forfeits various 734 616 3,897 - - - - - - - - - 5,248 200,000 3% 354 Ordinance Violation various 5,163 7,326 9,708 - - - - - - - - - 22,197 72,500 31% 360 Morris PAC various 10,087 86,686 184,282 - - - - - - - - - 281,054 976,000 29% 360 Palais Royale various 24,371 4,131 9,256 - - - - - - - - - 37,758 256,572 15% 360 Parks & Recreation various 9,055 4,207 4,552 - - - - - - - - - 17,814 94,206 19% 360 Police various 4,432 3,558 7,482 - - - - - - - - - 15,472 25,000 62% 360 Fire various- 37,987 - - - - - - - - - - 37,987 - NA 360 TIF various 31,545 2,510 6,859 - - - - - - - - - 40,913 52,725 78% 360 Central Services 222 608 - 50 - - - - - - - - - 658 11,000 6% 360 Century Center 670- 120 578 - - - - - - - - - 697 10,000 7% 360 Dept. Of Community Investment 211/212 65,547 23 - - - - - - - - - - 65,570 197,000 33% 360 Economic Dev. State Grant 210- - - - - - - - - - - - - - NA 360 EMS Operating Fund 288 525 - - - - - - - - - - - 525 5,000 11% 360 Engineering / Curb & Sidewalk 101- 50 50 - - - - - - - - - 100 11,000 1% 360 Fire and Police Pension Fund 701/702 1,523 675 5,700 - - - - - - - - - 7,898 2,000 395% 360 Self Funded Employee Benefits 711- - - - - - - - - - - - - - NA 360 Industrial Revolving 754- - 3,703 - - - - - - - - - 3,703 27,000 360 General Government Various 101/3/226 13,427 24 266 - - - - - - - - - 13,718 14,000 98% 2017-03 Fin anc i al Re port Mar - Reve nue Re port Page 4 of 25 City of South Bend Period Ending:March 31, 2017 Revenue by Type Report 18,366,497 $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 360 Motor Veh Highway Scrap Metal 202 285 - 1,117 - - - - - - - - - 1,402 4,896 29% 360 Motor Veh Highway Curb Prgm 202 11 - - - - - - - - - - - 11 32,000 0% 360 Local Roads and Streets 251- 274 - - - - - - - - - - 274 - NA 360 Professional Sports Development 377 17,864 - - - - - - - - - - - 17,864 30,000 60% 360 C.O.I.T.404 725 - 1,450 - - - - - - - - - 2,175 - NA 360 CCI / EDIT 407/408- - - - - - - - - - - - - - NA 360 UDAG 410- - - - - - - - - - - - - - NA 360 Code / Animal Control 600 170 5 - - - - - - - - - - 175 6,500 3% 360 Building Fees 600- - - - - - - - - - - - - - NA 360 Parking Garage 601 20 - 180 - - - - - - - - - 200 11,282 2% 360 Solid Waste Fund 610- 265 - - - - - - - - - - 265 2,000 13% 360 Waste Water 641/7/9- 3,437 - - - - - - - - - - 3,437 52,500 7% 360 Water Works Utility 620- 39 18 - - - - - - - - - 57 25,000 0% 360 Water Works Bond Reserve 626- - - - - - - - - - - - - - NA 360 Sewage Depreciation Fund 642- 400,000 - - - - - - - - - - 400,000 400,000 100% 362 Dept. Of Community Investment 212 1,847 - - - - - - - - - - - 1,847 - NA 362 Palais Royale 101- 5,114 1,940 - - - - - - - - - 7,054 82,500 9% 362 Police 101- - - - - - - - - - - - - 48,000 0% 362 Parks & Recreation 201 3,786 3,545 5,828 - - - - - - - - - 13,159 43,500 30% 362 S Bend School Corp Fee 407- - - - - - - - - - - - - 25,000 0% 362 Certified Technology Park 439- - - - - - - - - - - - - - NA 362 TIF Property various 14,223 24,108 14,479 - - - - - - - - - 52,810 319,603 17% 362 Self Funded Employee Benefits 711- - - - - - - - - - - - - - NA 369 Memorial Hosp Leighton Plaza 408 150,000 - - - - - - - - - - - 150,000 150,000 100% 371 Century Center Fees 670 260,617 191,881 72,253 - - - - - - - - - 524,751 2,809,278 19% 399 Bosch Retention Project 210- - 15,737 - - - - - - - - - 15,737 63,661 25% 399 Principal on Loan various 19,897 19,842 19,726 - - - - - - - - - 59,464 76,374 78% 399 Principal Income various 30,702 596,589 - - - - - - - - - - 627,291 1,703,614 37% Sub Total 6,172,987 8,889,356 6,333,219 - - - - - - - - - 21,395,562 84,559,029 25% Interest Income 361 Bank Account Interest various 156,963 166,772 205,325 - - - - - - - - - 529,060 1,642,811 32% Sub Total 156,963 166,772 205,325 - - - - - - - - - 529,060 1,642,811 32% Donations 367 ND Contribution 101- - - - - - - - - - - - - 337,500 0% 367 Donations various 75,816 1,040 70,660 - - - - - - - - - 147,516 172,250 86% Sub Total 75,816 1,040 70,660 - - - - - - - - - 147,516 509,750 29% Historic Preservation 368 Lamppost Program 227- - - - - - - - - - - - - - NA 368 C.O.I.T.404- - - - - - - - - - - - - - 368 Palais 450 1,838 114 345 - - - - - - - - - 2,297 16,500 14% Sub Total 1,838 114 345 - - - - - - - - - 2,297 16,500 14% Sale of Assets 391 TIF (Property Sales / Land)various- 60,000 2 - - - - - - - - - 60,002 77,331 78% 391 Property Sales 677- - - - - - - - - - - - - - NA 391 Water Hydrant Reimbursement 620- - - - - - - - - - - - - 20,000 0% 391 Proceeds F.A. Disposal 600- - - - - - - - - - - - - 3,000 0% 391 Sale of Fixed Assets various- - - - - - - - - - - - - 15,000 0% 391 Vehicle Damage Reimbursement various- - - - - - - - - - - - - - NA - Sub Total- 60,000 2 - - - - - - - - - 60,002 115,331 52% Revenue Total 15,541,356 27,563,049 18,707,970 - - - - - - - - - 61,812,376 323,106,049 19% report 15,541,356 27,563,049 18,707,971 - - - - - - - - - 61,812,377 323,106,049 - 0 (1) - - - - - - - - - (1) - 2017-03 Fin anc i al Re port Mar - Reve nue Re port Page 5 of 25 City of South Bend Period Ending:March 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0000 General Revenues 101 1,105,267 1,215,293 975,765 - - - - - - - - - 3,296,325 56,530,002 6% 0101 Mayor 101- - - - - - - - - - - - - 600 0% 0104 311 Call Center 101- - - - - - - - - - - - - - NA 0201 Clerk 101- - - - - - - - - - - - - - NA 0301 Common Council 101- - - - - - - - - - - - - - NA 0401 Administration and Finance 101 12,254 - 8 - - - - - - - - - 12,262 12,050 102% 0501 Legal 101 18,475 - - - - - - - - - - - 18,475 75,377 25% Sub Total 1,135,996 1,215,293 975,773 - - - - - - - - - 3,327,062 56,618,029 6% Public Works 0602 Engineering 101 32,047 7,275 12,535 - - - - - - - - - 51,857 317,337 16% Sub Total 32,047 7,275 12,535 - - - - - - - - - 51,857 317,337 16% Public Safety 0801 Police 101 34,608 15,151 13,175 - - - - - - - - - 62,935 326,500 19% 0901 Fire 101 4,387 37,987 - - - - - - - - - - 42,373 1,500 2825% Sub Total 38,995 53,138 13,175 - - - - - - - - - 105,309 328,000 32% Code Enforcement 1201 Code 101- - - - - - - - - - - NA 1203 Code Hearing 101- - - - - - - - - - - NA 1204 Code Junk Vehicle 101- - - - - - - - - - - NA 1205 Code Unsafe Building 101- - - - - - - - - - - - - - NA 1207 Code Animal Control 101- - - - - - - - - - - - - - NA xxx xxx- - - - - - - - - - - NA Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 10,888 86,733 183,972 - - - - - - - - - 281,593 965,000 29% 0405 Palais Royale 101 26,265 9,345 13,108 - - - - - - - - - 48,718 358,902 14% xxx xxx- NA Sub Total 37,153 96,078 197,080 - - - - - - - - - 330,311 1,323,902 25% General Fund Revenue Total 1,244,191 1,371,784 1,198,563 - - - - - - - - - 3,814,539 58,587,268 7% 2017-03 Financial Report Mar - Revenue Summary Page 6 of 25 City of South Bend Period Ending:March 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 0000 Parks General revenue 201 2,200 357,973 3,346 - - - - - - - - - 363,518 9,973,007 4% 1100 Administration 201 3,787 3,548 5,830 - - - - - - - - - 13,165 43,600 30% 1101 Maintenance 201 28,074 104,996 4,776 - - - - - - - - - 137,846 1,440,710 10% 1102 Golf Operations 201 1,356 402 152,340 - - - - - - - - - 154,098 1,519,934 10% 1103 Recreation Division 201 22 810 1,346 - - - - - - - - - 2,178 156,685 1% 1104 Potawatomi Zoo 201- - - - - - - - - - - - - - NA 1108 Graffiti Removal 201- - - - - - - - - - - - - 96,725 0% 1110 Marketing and Events 201- - - - - - - - - - - - - 570,471 0% Recreation Non Reverting 203 75,681 75,021 213,432 - - - - - - - - - 364,134 1,381,787 26% East Race Waterway 271 1 1 1 - - - - - - - - - 3 22 15% Coveleski Stadium 401 68 69 79 - - - - - - - - - 217 40,200 1% Zoo Endowment 403 37 38 44 - - - - - - - - - 119 200 60% Park Non Reverting 405 4,566 174 571 - - - - - - - - - 5,311 339,850 2% Sub Total 115,792 543,031 381,765 - - - - - - - - - 1,040,588 15,563,191 7% Public Works Motor Vehicle Highway 202 317,873 1,223,876 828,325 - - - - - - - - - 2,370,074 9,934,110 24% Central Services 222 675,986 688,080 710,659 - - - - - - - - - 2,074,725 8,308,569 25% Central Services Capital 224 84 72 89 - - - - - - - - - 246 287,600 0% Local Roads & Streets 251 106,827 88,499 130,547 - - - - - - - - - 325,873 1,344,000 24% Local Road & Bridge Grant 265- 1,000,000 1,000,000 - - - - - - - - - 2,000,000 - NA Project ReLeaf 655 37,450 37,428 37,604 - - - - - - - - - 112,482 444,556 25% Sub Total 1,138,220 3,037,955 2,707,224 - - - - - - - - - 6,883,400 20,318,835 34% Public Works Solid Waste Solid Waste Operations 610 445,931 471,682 480,834 - - - - - - - - - 1,398,446 5,782,675 24% Solid Waste Capital 611 179 240 100,039 - - - - - - - - - 100,458 835,813 12% Sub Total 446,110 471,922 580,873 - - - - - - - - - 1,498,904 6,618,488 23% Public Works Water Utility 0000 Water Works Revenues 620 973,972 948,744 947,938 - - - - - - - - - 2,870,654 15,080,627 19% 0630 Water Leak Insurance 620 81,303 81,237 81,371 - - - - - - - - - 243,911 1,173,361 21% 0660 Clay Water 620 72,507 69,573 74,940 - - - - - - - - - 217,019 1,265,346 17% Waterworks Capital 622 1,942 1,950 2,167 - - - - - - - - - 6,059 15,000 40% Waterworks Construction 623- - - - - - - - - - - - - - NA Waterworks Deposit 624 1,159 1,174 1,347 - - - - - - - - - 3,680 15,000 25% Waterworks Sinking 625 164,824 164,289 164,321 - - - - - - - - - 493,435 2,054,891 24% Waterworks Bond Reserve 626 1,154 1,073 1,235 - - - - - - - - - 3,462 16,000 22% Waterworks Debt Reserve 629 153,121 1,895 2,292 - - - - - - - - - 157,307 174,500 90% Sub Total 1,449,981 1,269,935 1,275,612 - - - - - - - - - 3,995,528 19,794,725 20% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,941 54,328 55,305 - - - - - - - - - 164,574 621,788 26% 0000 Wastewater Revenues 641 3,044,674 2,968,092 2,944,636 - - - - - - - - - 8,957,402 34,932,744 26% 0621 Sewer Department 641- 1,261 - - - - - - - - - - 1,261 2,500 50% 0625 Concrete Crew 641- 3,040 - - - - - - - - - - 3,040 74,500 4% 0630 Wastewater Operations 641- - - - - - - - - - - - - - NA 0631 Organic Resources 641- - - - - - - - - - - - - - NA 0650 Clay Sewage 641 177,865 174,732 185,177 - - - - - - - - - 537,773 2,162,160 25% Sewage Capital 642 5,472 404,555 5,255 - - - - - - - - - 415,282 4,887,000 8% Sewage Reserve 643 3,481 3,535 520,820 - - - - - - - - - 527,836 546,755 97% Sewer Bond 2007 647- - - - - - - - - - - - - - NA Sewage Bond Sinking 649 763,195 1,184 1,526,979 - - - - - - - - - 2,291,357 9,177,024 25% Sewer Bond 2007B 651- - - - - - - - - - - - - - NA Sewage Works DS Reserve 653- 955 1,176 - - - - - - - - - 2,132 4,400 48% 2010 CSO Net Sewer Bond 658- - - - - - - - - - - - - - NA 2011 Sewer Bond 659 41 39 45 - - - - - - - - - 125 - NA 2012 Sewer Bond 661 2,379 2,201 2,530 - - - - - - - - - 7,111 50,000 14% 2013A Sewer Refund Bonds 664- - - - - - - - - - - - - - NA 2015 Sewer Refund Bonds 666- - - - - - - - - - - - - - NA Sub Total 4,052,047 3,613,922 5,241,923 - - - - - - - - - 12,907,892 52,458,871 25% 2017-03 Financial Report Mar - Revenue Summary Page 7 of 25 City of South Bend Period Ending:March 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216 10,276 3,136 200 - - - - - - - - - 13,612 36,000 38% Curfew Violations 218 9 35 24 - - - - - - - - - 68 1,000 7% Law Enforcement Education 220 31,608 16,002 30,754 - - - - - - - - - 78,364 221,500 35% Public Safety LOIT 249 622,980 622,745 623,084 - - - - - - - - - 1,868,809 7,473,618 25% Excess Welfare Public Safety 252- - - - - - - - - - - - - - NA Police Take Home Vehicle 278 561 575 660 - - - - - - - - - 1,796 4,000 45% Police Block Grant 280 3 3 3 - - - - - - - - - 9 - NA Police Grants 292- - - - - - - - - - - - - - NA Police Academy 294 5,456 4,561 2,023 - - - - - - - - - 12,041 22,500 54% COPS More Grants 295 1,055 36,332 946 - - - - - - - - - 38,332 92,000 42% Drug Enforcement 299 149 162 148 - - - - - - - - - 459 32,000 1% K-9 Unit 705 2 2 3 - - - - - - - - - 7 2,020 0% Sub Total 672,099 683,553 657,845 - - - - - - - - - 2,013,496 7,884,638 26% Public Safety - Fire Emergency Telephone System 244- - - - - - - - - - - - - - NA EMS Capital 287 2,726 1,801,174 3,021 - - - - - - - - - 1,806,922 1,285,000 141% EMS Operating Fund 288 181,987 557,555 483,650 - - - - - - - - - 1,223,192 6,350,012 19% Hazmat 289 19 20 23 - - - - - - - - - 63 10,000 1% River Rescue 291 114 16,307 12,724 - - - - - - - - - 29,145 45,500 64% Sub Total 184,846 2,375,057 499,419 - - - - - - - - - 3,059,321 7,690,512 40% Department of Community Investment Studebaker/Oliver 209 25,242 626 34,113 - - - - - - - - - 59,981 104,000 58% State Grant 210 242 268 18,311 - - - - - - - - - 18,820 73,512 26% DCI Operating 211 10,748 394,129 39,598 - - - - - - - - - 444,475 2,291,309 19% 0000 Dept. of Community Investment 212 310,284 201,138 42,852 - - - - - - - - - 554,275 3,348,000 17% xxx Programs 212 93,743 - - - - - - - - - - - 93,743 - NA 0000 Economic Revenue Bond 281 21 21 24 - - - - - - - - - 66 200 33% Sub Total 440,280 596,182 134,898 - - - - - - - - - 1,171,360 5,817,021 20% Parking Garages 0000 Parking Garage Revenue 601 284 671 1,020 - - - - - - - - - 1,974 4,000 49% 0460 Main Street 601 25,906 27,933 28,062 - - - - - - - - - 81,901 267,966 31% 0462 Leighton Plaza 601 58,466 24,331 25,191 - - - - - - - - - 107,988 487,484 22% 0463 Enforcement 601 4,969 4,623 7,202 - - - - - - - - - 16,794 80,000 21% 0464 Wayne Street 601 30,977 20,895 29,889 - - - - - - - - - 81,761 241,961 34% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 120,601 78,453 91,364 - - - - - - - - - 290,418 1,097,311 26% Capital / Debt Service Hall of Fame 313 50 6 23 - - - - - - - - - 79 938,228 0% COIT 404 913,313 879,279 1,163,973 - - - - - - - - - 2,956,565 10,963,839 27% Cum Capital Development 406 357 436 410 - - - - - - - - - 1,203 476,500 0% Cum Capital Improvement 407 150,266 294 301 - - - - - - - - - 150,862 435,000 35% EDIT 408 1,041,459 1,981,678 877,267 - - - - - - - - - 3,900,404 11,733,257 33% UDAG 410 445 416 493 - - - - - - - - - 1,353 6,110 22% Major Moves 412 1,774 598,393 2,312 - - - - - - - - - 602,479 1,502,472 40% Morris PAC Improvement 416 436 12,664 13,666 - - - - - - - - - 26,766 104,000 26% CRED 434- - - - - - - - - - - - - - NA Palais Historic Preservation 450 1,907 187 428 - - - - - - - - - 2,522 17,100 15% Hall of Fame Capital 677 372 378 431 - - - - - - - - - 1,180 5,000 24% SB Building Corp 755- 1,326,786 210 - - - - - - - - - 1,326,996 2,643,214 50% Parks Bond Debt Svc 757- 65,162 124 - - - - - - - - - 65,287 391,482 17% xxx xxx xxx- - - - - - - - - - - NA Sub Total 2,110,380 4,865,679 2,059,637 - - - - - - - - - 9,035,696 29,216,202 31% 2017-03 Financial Report Mar - Revenue Summary Page 8 of 25 City of South Bend Period Ending:March 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Rainy Day 102 7,644 7,773 8,937 - - - - - - - - - 24,354 60,000 41% Excess Levy 103- - - - - - - - - - - - - - NA Gift, Donation, Bequest 217 50,900 1,097 69,994 - - - - - - - - - 121,991 175,800 69% Unsafe Building 219 11,928 152,225 26,129 - - - - - - - - - 190,283 793,757 24% Landlord Registration 221 2,260 270 1,245 - - - - - - - - - 3,775 1,000 378% Loss Recovery 227 730 741 851 - - - - - - - - - 2,322 9,000 26% LOIT 2016 Special Distribution 257- 6,605 156,406 - - - - - - - - - 163,011 1,318,000 12% Human Rights 258 91,498 4,790 5,975 - - - - - - - - - 102,262 165,040 62% Morris Palais Marketing 273 34 582 1,132 - - - - - - - - - 1,749 18,300 10% 311 Call Center 279 430,621 430,621 430,621 - - - - - - - - - 1,291,863 5,205,034 25% Professional Sports Development 377 80,547 318 115,357 - - - - - - - - - 196,222 732,000 27% 1201 Code Enforcement 600 12,749 366,188 37,109 - - - - - - - - - 416,045 1,810,451 23% 1207 Animal Control 600 4,706 187,306 6,015 - - - - - - - - - 198,026 789,865 25% 1306 Building Operations 600 92,341 88,523 111,064 - - - - - - - - - 291,928 1,368,350 21% Century Center 670 910,931 211,677 (225,009) - - - - - - - - - 897,599 4,194,311 21% Century Center Capital 671 74 66 74 - - - - - - - - - 214 750 28% Century Center Energy Saving 672 6 4 4 - - - - - - - - - 14 192,297 0% Sub Total 1,696,966 1,458,786 745,904 - - - - - - - - - 3,901,656 16,833,955 23% Business Insurance 0000 Business Insurance Revenues 226 246,679 247,476 245,267 - - - - - - - - - 739,421 3,527,591 21% 0418 Workers Compensation 226 619 35,123 - - - - - - - - - - 35,742 30,000 119% Sub Total 247,298 282,599 245,267 - - - - - - - - - 775,164 3,557,591 22% Fiduciary Trust & Agency Fire Pension 701 335 84 - - - - - - - - - - 419 5,217,138 0% Police Pension 702 2,386 1,224 5,915 - - - - - - - - - 9,526 6,136,500 0% Employee Benefits 711 1,511,154 1,463,664 1,500,195 - - - - - - - - - 4,475,013 17,795,850 25% Unemployment Comp 713 217 214 244 - - - - - - - - - 675 83,000 1% City Cemetery Trust 730 22 22 25 - - - - - - - - - 69 200 35% Equipment / Vehicle Leasing 750- 298 375 - - - - - - - - - 673 5,500,000 0% Parks Bond Capital 751- 369 539 - - - - - - - - - 908 7,500 12% Smart Street Bond Capital 753- 604 663 - - - - - - - - - 1,267 17,000 7% Sub Total 1,514,115 1,466,478 1,507,957 - - - - - - - - - 4,488,550 34,757,188 13% Civil City Revenues 15,432,926 22,115,337 17,328,250 - - - - - - - - - 54,876,513 280,195,796 20% Tax Increment Financing TIF River West - Airport 324 78,976 118,077 87,148 - - - - - - - - - 284,201 22,763,295 1% TIF Central Development 420- - - - - - - - - - - - - - NA TIF West Washington 422 1,411 1,497 1,721 - - - - - - - - - 4,629 436,000 1% TIF Leighton Plaza 425 10,467 14,196 10,498 - - - - - - - - - 35,160 197,014 18% TIF Medical Service 426- - - - - - - - - - - - - - NA TIF River East DEV (NE)429 5,927 6,699 11,342 - - - - - - - - - 23,968 3,065,400 1% TIF Southside 430 3,108 564,649 4,388 - - - - - - - - - 572,145 3,881,127 15% TIF Erskine Village 432 3,646 3,484 791 - - - - - - - - - 7,921 6,000 132% TIF Douglas Road 435 77 120 95 - - - - - - - - - 292 327,858 0% TIF River East RES (NE RE)436 442 - - - - - - - - - - - 442 3,300,903 0% Sub Total 104,055 708,721 115,983 - - - - - - - - - 928,758 33,977,597 3% 2017-03 Financial Report Mar - Revenue Summary Page 9 of 25 City of South Bend Period Ending:March 31, 2017 Revenue by Fund Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433 6 6 7 - - - - - - - - - 20 135 15% Certified Technology Park 439 1,614 1,641 1,887 - - - - - - - - - 5,142 - NA Airport Urban Enterprise Zone 454 288 292 336 - - - - - - - - - 917 3,900 24% Industrial Revolving 754- - 21,526 - - - - - - - - - 21,526 210,000 10% Sub Total 1,908 1,940 23,757 - - - - - - - - - 27,605 214,035 13% Debt Service Airport Debt Reserve 2003 315 780 792 902 - - - - - - - - - 2,474 14,000 18% Coveleski Bond Debt Reserve 317 385 391 450 - - - - - - - - - 1,225 5,000 25% Central Development reserve 328 1,303 1,323 1,522 - - - - - - - - - 4,148 15,000 28% SB Redevelopment Authority 752- 772,669 1,236,763 - - - - - - - - - 2,009,432 3,868,169 52% Smart Streets Debt Svc 756- 179 263 - - - - - - - - - 441 855,784 0% Erskine Village Debt. Svc 758- 3,961,697 82 - - - - - - - - - 3,961,780 3,960,668 100% Sub Total 2,468 4,737,051 1,239,982 - - - - - - - - - 5,979,501 8,718,621 69% Redevelopment Commission 108,431 5,447,712 1,379,721 - - - - - - - - - 6,935,864 42,910,253 16% City Operations Total 15,541,357 27,563,049 18,707,971 - - - - - - - - - 61,812,377 323,106,049 19% Revenue report 15,541,356 27,563,049 18,707,971 0 0 0 0 0 0 0 0 0 61,812,377 323,106,049 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2017-03 Financial Report Mar - Revenue Summary Page 10 of 25 City of South Bend Period Ending:March 31, 2017 Property Tax Revenue 2015 Tax Pay 2016 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/14/2016 12/20/2016 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 40,360,212.00 0.95 38,342,201.40 21,490,881.50 17,871,257.85 - - 39,362,139.35 998,072.65 97.53% Parks & Recreation 201 8,090,885.00 0.95 7,686,340.75 4,312,625.82 3,590,369.07 - - 7,902,994.89 187,890.11 97.68% College Football Hall of Fame 313 1,396,308.00 0.95 1,326,492.60 744,229.93 617,281.74 - - 1,361,511.67 34,796.33 97.51% Cumulative Capital District 406 451,368.00 0.95 428,799.60 240,589.67 200,296.91 - - 440,886.58 10,481.42 97.68% Total - City 50,298,773.00 47,783,834.35 26,788,326.92 22,279,205.57 - - 49,067,532.49 1,231,240.51 97.55% Tax Increment Financing Airport TIF District 324 19,123,985.00 0.95 18,167,785.75 9,769,452.30 8,389,858.48 - - 18,159,310.78 964,674.22 94.96% West Washington TIF District 422 516,171.00 0.95 490,362.45 282,809.66 170,692.93 - - 453,502.59 62,668.41 87.86% Northeast Residential TIF District 436 3,913,816.00 0.95 3,718,125.20 2,061,402.42 1,871,544.98 - - 3,932,947.40 (19,131.40) 100.49% Southside TIF District #1 430 2,481,892.00 0.95 2,357,797.40 1,251,613.66 1,149,638.01 - - 2,401,251.67 80,640.33 96.75% Douglas Road TIF District 435 337,099.00 0.95 320,244.05 231,288.93 113,972.95 - - 345,261.88 (8,162.88) 102.42% Northeast TIF 429 2,586,566.00 0.95 2,457,237.70 1,170,979.07 1,177,628.87 - - 2,348,607.94 237,958.06 90.80% Total - Tax Increment Financing 28,959,529.00 27,511,552.55 14,767,546.04 12,873,336.22 - - 27,640,882.26 1,318,646.74 95.45% Grand Total 79,258,302.00 75,295,386.90 41,555,872.96 35,152,541.79 - - 76,708,414.75 2,549,887.25 96.78% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/14/16 Distribution 2 - Issued by St. Joseph County on 12/20/16 2017-03 Financial Report Mar - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:March 31, 2017 Property Tax Revenue 2014 Tax Pay 2015 Fund Fund #Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 6/8/2015 6/16/2015 10/30/2015 12/15/2015 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 38,619,247.00 0.95 36,688,284.65 13,463,468.56 7,216,350.23 2,012,110.57 14,657,458.45 37,349,387.81 1,269,859.19 96.71% Parks & Recreation 201 7,742,127.00 0.95 7,355,020.65 2,699,065.71 1,446,685.42 403,374.41 2,938,428.80 7,487,554.34 254,572.66 96.71% College Football Hall of Fame 313 937,076.00 0.95 890,222.20 - 501,784.88 - 404,478.29 906,263.17 30,812.83 96.71% Cumulative Capital District 406 443,304.00 0.95 421,138.80 154,544.81 82,835.23 23,096.67 168,250.41 428,727.12 14,576.88 96.71% Fire Pension 701- 0.95 - - - - - - - - Police Pension 702- 0.95 - - - - - - - - Total - City 47,741,754.00 45,354,666.30 16,317,079.08 9,247,655.76 2,438,581.65 18,168,615.95 46,171,932.44 1,569,821.56 96.71% Tax Increment Financing Airport TIF District 324 17,709,737.84 0.95 16,824,250.95 - 9,396,167.91 - 6,897,072.02 16,293,239.93 1,416,497.91 92.00% South Bend Central TIF District 420- 0.95 - - - - - - - West Washington TIF District 422 512,917.39 0.95 487,271.52 - 195,865.56 - 207,045.03 402,910.59 110,006.80 78.55% Central Medical TIF District 426- 0.95 - - - - - - - Northeast Residential TIF District 436 3,273,328.42 0.95 3,109,662.00 - 1,663,572.10 - 1,466,109.03 3,129,681.13 143,647.29 95.61% Southside TIF District #1 430 2,504,494.11 0.95 2,379,269.40 - 1,298,974.33 - 906,847.80 2,205,822.13 298,671.98 88.07% Erskine Commons TIF District #2 431- 0.95 - - - - - - - Erskine Village TIF District #3 432 19,182.73 0.95 18,223.59 - 11,490.26 - 7,692.47 19,182.73 - 100.00% Douglas Road TIF District 435 327,887.96 0.95 311,493.56 - 163,943.98 - 106,813.87 270,757.85 57,130.11 82.58% Northeast TIF 429 2,743,819.42 0.95 2,606,628.45 - 1,391,012.32 - 1,030,295.80 2,421,308.12 322,511.30 88.25% Airport Urban Enterprise Zone 454- 0.95 - - - - - - - - Other xxx- - - - - - Total - Tax Increment Financing 27,091,367.87 25,736,799.48 - 14,121,026.46 - 10,621,876.02 24,742,902.48 2,348,465.39 91.33% Grand Total 74,833,121.87 71,091,465.78 16,317,079.08 23,368,682.22 2,438,581.65 28,790,491.97 70,914,834.92 3,918,286.95 94.76% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/8/15 2 Distribution 2 - Issued by St. Joseph County on 6/16/15 3 Distribution 3 - Issued by St. Joseph County on 10/30/15 Distribution 4 - Issued by St. Joseph County on 12/15/15 2017-03 Financial Report Mar - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:March 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0101 Mayor 101 59,009 57,926 57,827 - - - - - - - - - 174,762 872,923 20% 0104 311 Call Center 101- - - - - - - - - - - - - - NA 0201 Clerk 101 38,451 43,206 31,600 - - - - - - - - - 113,257 536,216 21% 0301 Common Council 101 33,451 49,728 27,207 - - - - - - - - - 110,385 571,148 19% 0302 WNIT Contract 101- - - - - - - - - - - - - 43,000 0% 0401 Administration and Finance 101 184,278 178,933 181,407 - - - - - - - - - 544,618 2,476,351 22% 0501 Legal Department 101 87,585 86,783 87,565 - - - - - - - - - 261,933 1,158,567 23% Sub Total 402,773 416,575 385,606 - - - - - - - - - 1,204,955 5,658,205 21% Public Works 0602 Engineering 101 81,736 88,219 89,641 - - - - - - - - - 259,596 1,445,157 18% Sub Total 81,736 88,219 89,641 - - - - - - - - - 259,596 1,445,157 18% Public Safety 0801 Police 101 2,401,801 2,081,566 2,099,258 - - - - - - - - - 6,582,626 29,668,433 22% 0805 Police -PS LOIT funded 101- - - - - - - - - - - - - - NA 0802 Police Communications 101- - - - - - - - - - - - - - NA 0901 Fire 101 1,586,894 1,525,036 1,582,606 - - - - - - - - - 4,694,536 21,111,466 22% 0905 Fire-PS LOIT funded 101- - - - - - - - - - - - - - NA Sub Total 3,988,695 3,606,602 3,681,864 - - - - - - - - - 11,277,161 50,779,899 22% Code Enforcement 1201 Code 101- - - - - - - - - - - - - NA Sub Total- - - - - - - - - - - - - - NA Arts & Culture 0404 Morris PAC 101 74,731 80,199 47,613 - - - - - - - - - 202,543 1,271,039 16% 0405 Palais Royale 101 24,999 30,061 10,824 - - - - - - - - - 65,884 530,200 12% Sub Total 99,730 110,260 58,436 - - - - - - - - - 268,426 1,801,239 15% Human Rights 1008 Human Rights 101 37,821 40,148 32,484 - - - - - - - - - 110,454 425,805 26% Sub Total 37,821 40,148 32,484 - - - - - - - - - 110,454 425,805 26% General Fund Expenditure Total 4,610,756 4,261,804 4,248,032 - - - - - - - - - 13,120,592 60,110,305 22% 2017-03 Financial Report Mar - Exp endit ure S ummary Page 13 of 25 City of South Bend Period Ending:March 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 1100 Administration 201 147,654 87,876 110,868 - - - - - - - - - 346,398 1,468,296 24% 1101 Maintenance 201 399,021 416,933 423,013 - - - - - - - - - 1,238,966 6,814,308 18% 1102 Golf Operations 201 54,483 75,381 77,362 - - - - - - - - - 207,226 1,638,575 13% 1103 Recreation Division 201 165,251 145,109 133,502 - - - - - - - - - 443,862 2,153,817 21% 1104 Potawatomi Zoo 201 355,692 7,425 7,231 - - - - - - - - - 370,348 704,464 53% 1106 Potawatomi Greenhouse 201 5,013 4,555 2,550 - - - - - - - - - 12,118 54,408 22% 1108 Graffiti Removal 201 13,483 12,628 11,465 - - - - - - - - - 37,576 97,861 38% 1110 Marketing and Events 201 16,583 45,412 58,810 - - - - - - - - - 120,805 953,588 13% Recreation Non Reverting 203 51,478 47,722 45,821 - - - - - - - - - 145,021 1,599,683 9% East Race Waterway 271- - - - - - - - - - - - - 1,367 0% Coveleski Stadium 401- - - - - - - - - - - - - 30,000 0% Zoo Endowment 403- - - - - - - - - - - - - 49,688 0% Park Non Reverting 405 45,874 17,251 22,621 - - - - - - - - - 85,745 228,024 38% Sub Total 1,254,532 860,290 893,243 - - - - - - - - - 3,008,065 15,794,079 19% Public Works Motor Vehicle Highway 202 919,033 515,568 547,694 - - - - - - - - - 1,982,295 9,686,533 20% Curb and Sidewalk 202 150,920 40,047 37,646 - - - - - - - - - 228,614 1,878,998 12% Central Services 222 730,352 648,645 561,962 - - - - - - - - - 1,940,960 8,564,643 23% Central Services Capital 224 10,575 4,009 - - - - - - - - - - 14,585 326,025 4% Local Roads & Streets 251 209,999 4,801 3,018 - - - - - - - - - 217,818 2,086,544 10% Local Roads & Bridge 265- - - - - - - - - - - - - 2,000,000 0% Project ReLeaf 655 15,049 90,567 3,684 - - - - - - - - - 109,300 525,416 21% Sub Total 2,035,929 1,303,638 1,154,005 - - - - - - - - - 4,493,572 25,068,159 18% Public Works Solid Waste Solid Waste Operations 610 489,623 312,159 388,501 - - - - - - - - - 1,190,284 5,662,910 21% Solid Waste Capital 611 286,902 146,712 218 - - - - - - - - - 433,832 1,135,613 38% Sub Total 776,525 458,871 388,720 - - - - - - - - - 1,624,115 6,798,523 24% Public Works Water Utility 0630 Water Leak Insurance 620 43,958 41,864 50,876 - - - - - - - - - 136,697 1,035,000 13% 0640 Water Works 620 1,417,876 1,256,524 1,085,407 - - - - - - - - - 3,759,808 16,688,754 23% 0660 Clay Water 620- - (0) - - - - - - - - - (0) 3,500 0% Waterworks Capital 622 111,938 177,777 13,775 - - - - - - - - - 303,490 1,414,466 21% Waterworks Deposit 624 874 1,174 1,347 - - - - - - - - - 3,395 15,000 23% Waterworks Sinking 625 815 289 321 - - - - - - - - - 1,425 2,054,891 0% Waterworks Bond Reserve 626- - - - - - - - - - - - - 16,000 0% Waterworks Debt Reserve 629 1,394 1,895 2,292 - - - - - - - - - 5,581 23,000 24% Sub Total 1,576,855 1,479,523 1,154,018 - - - - - - - - - 4,210,396 21,250,611 20% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 48,400 46,390 29,841 - - - - - - - - - 124,631 534,509 23% 0621 Sewer Repair 641 517,647 434,598 385,613 - - - - - - - - - 1,337,858 9,248,687 14% 0625 Concrete Crew 641 30,239 20,767 19,975 - - - - - - - - - 70,981 474,389 15% 0630 Wastewater Operations 641 2,358,990 1,454,679 3,260,858 - - - - - - - - - 7,074,527 33,209,563 21% 0631 Organic Resources 641 124,773 126,931 80,689 - - - - - - - - - 332,392 1,608,946 21% 0650 Clay Sewage 641- 5 26 - - - - - - - - - 31 750 4% Sewage Capital 642 1,298,328 387,989 178,442 - - - - - - - - - 1,864,759 8,040,455 23% Sewage Reserve 643 2,625 3,535 4,065 - - - - - - - - - 10,225 30,000 34% Sewage Bond Sinking 649 1,000 500 - - - - - - - - - - 1,500 9,163,754 0% 2011 Sewer Bond 659- - - - - - - - - - - - - 51,688 0% 2012 Sewer Bond 661 3,000 166,950 113,521 - - - - - - - - - 283,471 3,010,364 9% 2013A Sewer Bond 664- - - - - - - - - - - - - - NA 2014 Sewer Bond 665- - - - - - - - - - - - - - NA 2015 Sewer Bond 666- - - - - - - - - - - - - - NA Sub Total 4,385,001 2,642,343 4,073,031 - - - - - - - - - 11,100,375 65,373,105 17% 2017-03 Financial Report Mar - Exp endit ure S ummary Page 14 of 25 City of South Bend Period Ending:March 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Public Safety - Police Police Seizures 216- - - - - - - - - - - - - 36,000 0% Curfew Violations 218- - - - - - - - - - - - - 1,000 0% Law Enforcement Education 220 44,630 19,978 197,939 - - - - - - - - - 262,547 788,422 33% Emergency Telephone System 244- - - - - - - - - - - - - 33,671 0% Public Safety LOIT 249 466,245 487,781 613,087 - - - - - - - - - 1,567,113 7,462,645 21% Excess Welfare Public Safety 252- - - - - - - - - - - - - 8 0% LOIT 2016 Special Distribution 257 21,360 21,991 1,050,366 - - - - - - - - - 1,093,717 3,757,457 29% Police Take Home Vehicle 278- 972 - - - - - - - - - - 972 10,000 10% Police Grants 292 2,796 1,266 1,330 - - - - - - - - - 5,392 10,805 50% Police Academy 294 162 283 692 - - - - - - - - - 1,137 22,500 5% COPS More Grants 295 10,980 3,436 108,583 - - - - - - - - - 122,999 263,767 47% Drug Enforcement 299 11,242 23,096 13,200 - - - - - - - - - 47,537 196,337 24% K-9 Unit 705- - - - - - - - - - - - - 2,020 0% Sub Total 557,416 558,803 1,985,195 - - - - - - - - - 3,101,413 12,584,632 25% Public Safety - Fire EMS Capital 287 235,792 150,604 - - - - - - - - - - 386,396 3,100,377 12% EMS Operating Fund 288 438,601 356,431 401,753 - - - - - - - - - 1,196,785 6,117,914 20% Hazmat 289 430 255 - - - - - - - - - - 685 10,431 7% River Rescue 291 1,443 231 231 - - - - - - - - - 1,904 89,349 2% xxx xxx xxx- - - - - - - - - - - - - NA Sub Total 676,266 507,520 401,984 - - - - - - - - - 1,585,770 9,318,071 17% Department of Community Investment Studebaker/Oliver 209 70,702 4,592 23,072 - - - - - - - - - 98,366 539,393 18% State Grant 210- - 18,003 - - - - - - - - - 18,003 509,757 4% DCI Operating 211 197,318 171,937 175,385 - - - - - - - - - 544,640 2,650,376 21% 1001 Dept. of Community Investment 212 575,173 100,654 21,621 - - - - - - - - - 697,447 5,455,838 13% 1003 Administration 212- - - - - - - - - - - - - - NA xxx Programs 212- - - - - - - - - - - - - - NA Sub Total 843,192 277,183 238,081 - - - - - - - - - 1,358,456 9,155,364 15% Parking Garages 0400 General Administration 601- - - - - - - - - - - - - - NA 0460 Main Street 601 10,017 11,799 1,749 - - - - - - - - - 23,566 261,894 9% 0462 Leighton Plaza 601 20,044 21,722 1,360 - - - - - - - - - 43,126 596,368 7% 0463 Enforcement 601 7,858 7,238 437 - - - - - - - - - 15,533 128,675 12% 0464 Wayne Street 601 12,364 13,889 936 - - - - - - - - - 27,189 244,417 11% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 50,284 54,648 4,482 - - - - - - - - - 109,415 1,247,254 9% Capital / Debt Service Hall of Fame 313 635,000 - (3,265) - - - - - - - - - 631,735 1,268,999 50% COIT 404 1,172,640 1,270,520 840,369 - - - - - - - - - 3,283,528 12,071,593 27% Cum Capital Development 406 112,650 27,896 - - - - - - - - - - 140,546 476,500 29% Cum Capital Improvement 407 185,125 - - - - - - - - - - - 185,125 372,250 50% EDIT 408 697,093 1,928,675 70,750 - - - - - - - - - 2,696,517 11,559,184 23% UDAG 410 30,702 - - - - - - - - - - - 30,702 126,144 24% Major Moves 412 543 - 62 - - - - - - - - - 604 2,470,708 0% Morris PAC Improvement 416 408 - 1,645 - - - - - - - - - 2,053 106,144 2% CRED 434- - - - - - - - - - - - - - NA Palais Historic Preservation 450- - - - - - - - - - - - - 5,000 0% Hall of Fame Capital 677 3,866 14,859 2,574 - - - - - - - - - 21,299 81,091 26% SB Building Corp 755- - 1,437,970 - - - - - - - - - 1,437,970 2,643,214 54% Parks Bond Debt 757- - 198,566 - - - - - - - - - 198,566 391,482 51% Sub Total 2,838,027 3,241,949 2,548,669 - - - - - - - - - 8,628,645 31,572,309 27% 2017-03 Financial Report Mar - Exp endit ure S ummary Page 15 of 25 City of South Bend Period Ending:March 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Excess Levy 103- - - - - - - - - - - - - - NA Gift, Donation, Bequest 217 72,000 900 - - - - - - - - - - 72,900 238,700 31% Unsafe Building 219 80,336 43,005 41,261 - - - - - - - - - 164,602 902,746 18% Landlord Registration 221 5 5 - - - - - - - - - - 10 1,000 1% Loss Recovery 227- 3,345 7,600 - - - - - - - - - 10,945 598,675 2% Human Rights 258 17,100 3,192 7,767 - - - - - - - - - 28,060 201,773 14% Morris Palais Marketing 273 2,798 - 878 - - - - - - - - - 3,675 21,675 17% 311 Call Center 279 325,330 207,081 205,525 - - - - - - - - - 737,935 5,205,034 14% Professional Sports Development 377 467,640 800 - - - - - - - - - - 468,440 827,955 57% 1201 Code Enforcement 600 128,453 94,686 101,457 - - - - - - - - - 324,596 1,625,378 20% 1207 Animal Control 600 68,101 59,652 58,318 - - - - - - - - - 186,071 790,517 24% 1209 Illegal Dumping Crew 600- - - - - - - - - - - - - - NA 1306 Building Operations 600 110,343 98,842 97,813 - - - - - - - - - 306,998 1,361,925 23% Century Center 670 282,027 349,477 (15,339) - - - - - - - - - 616,165 4,194,310 15% Century Center Capital 671- - - - - - - - - - - - - - NA Century Center Energy Saving 672- - - - - - - - - - - - - 192,297 0% Sub Total 1,554,131 860,986 505,279 - - - - - - - - - 2,920,396 16,161,985 18% Business Insurance 0403 Self Funded Liability Ins 226 17,866 17,273 20,527 - - - - - - - - - 55,666 235,471 24% 0412 Liability Insurance 226 45,537 23,578 52,779 - - - - - - - - - 121,894 2,034,051 6% 0417 Business Insurance 226 45,354 - 21,392 - - - - - - - - - 66,746 595,678 11% 0418 Workers Compensation 226 119,520 87,561 54,191 - - - - - - - - - 261,272 722,386 36% Sub Total 228,276 128,412 148,890 - - - - - - - - - 505,578 3,587,586 14% Fiduciary Trust & Agency Fire Pension 701 388,455 396,509 396,201 - - - - - - - - - 1,181,165 5,098,269 23% Police Pension 702 513,053 511,187 523,297 - - - - - - - - - 1,547,536 6,423,889 24% Employee Benefits 711 1,060,085 1,343,141 951,392 - - - - - - - - - 3,354,619 17,803,200 19% Unemployment Comp 713 6,038 8,041 4,389 - - - - - - - - - 18,468 84,105 22% City Cemetery Trust 730- - - - - - - - - - - - 6,000 0% Equipment / Vehicle Leasing 750- 983,042 489,584 - - - - - - - - - 5,500,000 0% Parks Bond Capital 751- 63,156 211,200 - - - - - - - - - 3,500,000 0% Smart Street Bond 753- 986,652 285,891 - - - - - - - - - 10,000,000 0% xxx xxx xxx NA Sub Total 1,967,632 4,291,727 2,861,954 - - - - - - - - - 9,121,313 48,415,463 19% Civil City Expenditure 23,354,822 20,927,696 20,605,582 - - - - - - - - - 64,888,100 326,437,446 20% Tax Increment Financing TIF River West - Airport 324 4,348,398 123,050 1,434,861 - - - - - - - - - 5,906,309 39,618,887 15% TIF West Washington 422- - 2,420 - - - - - - - - - 2,420 1,428,292 0% TIF Leighton Plaza 425 5,141 9,302 4,480 - - - - - - - - - 18,923 158,166 12% TIF River East DEV (NE)429 27,144 45,644 101,171 - - - - - - - - - 173,959 10,602,696 2% TIF Southside 430 146,124 12,530 17,419 - - - - - - - - - 176,073 6,917,426 3% TIF Erskine Village 432 3,961,667 - - - - - - - - - - - 3,961,667 4,878,795 81% TIF Douglas Road 435- 150,000 - - - - - - - - - - 150,000 344,216 44% TIF River East RES (NE RE)436 1,236,500 446,589 - - - - - - - - - - 1,683,089 3,430,231 49% Sub Total 9,724,973 787,115 1,560,351 - - - - - - - - - 12,072,439 67,378,709 18% 2017-03 Financial Report Mar - Exp endit ure S ummary Page 16 of 25 City of South Bend Period Ending:March 31, 2017 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Redevelopment Funds Administration 433- - - - - - - - - - - - - 4,500 0% Certified Technology Park 439- - - - - - - - - - - - NA Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Industrial Revolving 754- - 14,437 - - - - - - - - - 14,437 157,000 9% Sub Total- - 14,437 - - - - - - - - - 14,437 211,500 7% Debt Service Airport Debt Reserve 2003 315 588 792 902 - - - - - - - - - 2,282 14,000 16% Central Development reserve 328 983 1,323 1,522 - - - - - - - - - 3,828 15,000 26% SB Redevelopment Authority 752- 735,236 2,004,503 - - - - - - - - - 2,739,739 4,603,405 60% Smart Streets Debt Svc 756- - 394,784 - - - - - - - - - 394,784 855,784 46% Erskine Village Debt Svc 758- 561,229 3,961,668 - - - - - - - - - 4,522,897 4,521,918 100% xxx xxx xxx NA Sub Total 1,571 1,298,580 6,363,379 - - - - - - - - - 7,663,530 10,010,107 77% Redevelopment Commission 9,726,545 2,085,695 7,938,167 - - - - - - - - - 19,750,406 77,600,316 25% City Operations Total 33,081,366 23,013,391 28,543,749 - - - - - - - - - 84,638,506 404,037,762 21% Expenditure report 33,081,366 23,013,391 28,543,749 0 0 0 0 0 0 0 0 0 84,638,506 404,037,762 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2017-03 Financial Report Mar - Exp endit ure S ummary Page 17 of 25 City of South Bend Period Ending:March 31, 2017 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2017 Princip al 2017 Inter est 2017 Debt a t 2017 Total D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Payme nt Addit ion 12/31/20 17 D ebt P aymen ts Civil City Debt Bond Deb t A mort s ch # 3 1 CEDIT Bond 199 7 200 6 20 17 40 8 2/1 8/1--11,870,00 0.00 430,000.00 4 30,000.00 9,932.50 0.00 0.00 439,93 2.50 3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 2,755,000.00 5 75,000.00 95,994.00 0.00 2,180,000.00 670,99 4.00 2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 1/1 7/1--5,975,00 0.00 2,380,000.00 3 75,000.00 47,600.00 0.00 2,005,000.00 422,60 0.00 3 9 Sout h B end Building C orporation Fire HQ / P ol ice H Q 200 3 201 2 20 23 40 4/324 2/1 8/1--21,335,00 0.00 8,885,000.00 1,2 40,000.00 325,740.00 0.00 7,645,000.00 1,565,74 0.00 2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 1/1 7/1--4,710,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 42 0 5/1 11/1--4,655,00 0.00 3,175,000.00 3 00,000.00 85,812.50 0.00 2,875,000.00 385,81 2.50 6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 1/1 7/1--5,380,00 0.00 4,325,000.00 2 40,000.00 239,938.00 0.00 4,085,000.00 479,93 8.00 7 0 Sewage W orks Reve nue Bon ds - 2009 Sewag e W orks 200 9 20 28 64 9 6/1 12/1--3,297,00 0.00 2,249,643.00 1 62,472.00 63,214.00 0.00 2,087,171.00 225,68 6.00 8 0 2 010 Sewage W orks Re v enue Bonds Sewag e W orks 201 0 20 30 64 9 6/1 12/1--9,345,00 0.00 7,145,000.00 3 95,000.00 298,617.50 0.00 6,750,000.00 693,61 7.50 9 3 Sewage W orks Reve nue Bon ds 201 1 Sewag e W orks 201 1 20 31 64 9 6/1 12/1--21,500,00 0.00 17,295,000.00 8 95,000.00 654,300.00 0.00 16,400,000.00 1,549,30 0.00 9 9 2 012 W ater Wo rks Reven ue Bond W ater W orks 201 2 20 33 62 5 1/1 7/1--8,300,00 0.00 6,925,000.00 3 55,000.00 209,786.26 0.00 6,570,000.00 564,78 6.26 10 1 2 012 Sewage W orks Re v enue Bonds Sewag e W orks 201 2 20 32 64 9 6/1 12/1--25,000,00 0.00 20,890,000.00 1,0 60,000.00 486,680.00 0.00 19,830,000.00 1,546,68 0.00 10 5 2 013A Sewer Bon d Refunding Sewag e W orks 201 3 201 3 20 24 64 9 6/1 12/1--14,765,00 0.00 8,050,000.00 1,9 55,000.00 156,170.00 0.00 6,095,000.00 2,111,17 0.00 11 6 2 013 Building C orporation EMS / Fire D epar t ment 201 3 20 33 28 8 2/1 8/1--5,580,00 0.00 5,145,000.00 2 25,000.00 177,480.00 0.00 4,920,000.00 402,48 0.00 13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly 2,657,69 6.50 2,386,507.92 1 07,652.90 59,107.80 0.00 2,278,855.02 166,76 0.70 13 9 Cen tury Center En ergy Saving s Impro v ements at Century Ctr.201 5 20 31 67 2 5/1 11/1 4,167,89 7.00 4,145,312.00 46,606.00 144,690.68 0.00 4,098,706.00 191,29 6.68 14 1 Park s and Rec reation Bo nd Parks Improveme nts 201 5 20 35 40 8 2/1 8/1--5,605,00 0.00 5,295,000.00 2 10,000.00 172,256.26 0.00 5,085,000.00 382,25 6.26 14 5 Sewage W orks Reve nue Bon ds -20 15 Sewer Impr ovemen ts 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 24,965,000.00 2,5 30,000.00 499,300.00 0.00 22,435,000.00 3,029,30 0.00 15 6 2 016 W ater Wo rks Refu nding Bon ds R efunding 20 00 / 2 006 SRF 201 6 20 27 62 5 1/1 7/1--3,300,00 0.00 3,300,000.00 4 05,000.00 49,500.00 0.00 2,895,000.00 454,50 0.00 xxx Total Bond Debt 2 34,877,59 3.50 129,741,462.92 11,5 06,730.90 3,776,119.50 0.00 118,234,732.02 15,282,85 0.40 Loa ns Payab le 6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 1/1 7/1--427,33 2.00 332,562.00 20,912.00 11,207.34 0.00 311,650.00 32,11 9.34 8 2 In terfu nd Loan 41 0 - UDAG 1st Sour c e/Marriott Garage 201 0 20 15 41 0 6/15 12/1 5--2,700,00 0.00 1,351,597.75 1 26,142.25 0.00 0.00 1,225,455.50 126,14 2.25 2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 1/1 7/1--2,600,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 xxx Total Loans Pa yable 29,822,33 2.00 1,684,159.75 1 47,054.25 11,207.34 0.00 1,537,105.50 158,26 1.59 Ca pita l Leases 5 1 Ch ase LE D Equipmen t 200 7 20 17 10 1 1/1 7/1--1,531,57 3.00 194,320.02 1 94,319.97 6,259.69 0.00 0.05 200,57 9.66 8 9 Sun Trust Police, Parks, Bl dg vehicles 201 1 20 16 40 4/20 1/600 3/15 6/15 9/15 12/15 2,068,20 2.00 0.00 0.00 0.00 0.00 0.00 0.00 9 0 Cap ital One Public Fundin g Solid Was te Cont ai ners/Truc k s 201 1 20 16 61 1 3/15 6/15 9/15 12/15 207,43 2.00 0.00 0.00 0.00 0.00 0.00 0.00 9 1 GE Cap ital I nfor mation Techn ology Police Dept Copier 201 1 20 16 10 1 1/11 4/11 7/11 10/11 3,83 6.00 0.00 0.00 0.00 0.00 0.00 0.00 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 0.00 0.00 0.00 0.00 0.00 0.00 9 4 Iko n Office Solu t ions Mayor Ric oh M P 2851 SP Copier 201 1 20 16 10 1 2/15 5/15 8/15 11/15 2,56 9.53 0.00 0.00 0.00 0.00 0.00 0.00 9 5 Sun Trust E quipme nt F in ance Parks-Golf C ars Lease 201 2 20 16 20 1 4/15 10/1 5--344,50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9 7 Sun Trust E quipme nt F in ance Police Veh ic le s & Equ ipment 201 2 20 17 40 6 5/15 11/1 5--1,295,00 0.00 134,585.22 1 34,585.22 1,140.42 0.00 0.00 135,72 5.64 9 8 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/640 5/15 11/1 5--945,67 4.38 97,793.51 97,793.52 735.98 0.00(0.01)98,52 9.50 10 0 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/600/288 1/15 7/15--2,806,05 4.00 575,316.55 5 75,316.53 5,634.82 0.00 0.02 580,95 1.35 10 2 Iko n Office Solu t ions / Ricoh W astewater C opier 201 2 20 17 64 1 Monthly 1st 5,74 4.95 756.77 756.77 65.82 0.00 0.00 82 2.59 10 3 GE Cap ital I nfor mation Techn ology Fire Department Cop ie r 201 2 20 17 10 1 2/28 5/28 8/28 11/28 5,47 1.01 926.68 926.68 27.40 0.00 0.00 95 4.08 10 6 Ricoh U SA (N ew)C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 815.82 814.82 24.94 0.00 1.00 83 9.76 10 7 Ricoh U SA Street/Sewer Dept Copier 201 3 20 18 20 2/641 3/4 6/4 9/4 12/4 5,55 9.15 1,225.93 1,225.93 44.88 0.00 0.00 1,27 0.81 10 8 Ricoh U SA C ity Att orney C opier 201 3 20 18 10 1 2/12 5/12 8/12 11/12 5,55 9.15 1,232.73 1,231.73 39.06 0.00 1.00 1,27 0.79 10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 2/21 5/21 8/21 11/21 16,12 9.94 3,575.09 3,574.09 113.15 0.00 1.00 3,68 7.24 11 0 PNC Equipm ent F inance Vehi c le/Equipmen t Lease 201 3 20 18 10 1/20 2/406/641 1/15 7/15--1,689,66 9.59 689,257.88 3 42,533.13 7,367.39 0.00 346,724.75 349,90 0.52 11 1 Ricoh U SA En gi neer in g P l otter/Scan ner 201 3 20 18 10 1 3/3 6/3 9/3 12/3 10,66 7.67 2,459.26 2,458.26 133.72 0.00 1.00 2,59 1.98 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly 4,09 3.64 1,491.77 878.55 60.45 0.00 613.22 93 9.00 11 3 Sun Trust E quipme nt F in ance Police and PW vehicles 201 3 20 18 40 4/65 5/611/202 4/24 10/2 4--1,506,46 5.26 616,891.89 3 06,011.19 8,569.95 0.00 310,880.70 314,58 1.14 11 4 Ricoh U SA Admi n & Fina nce Copier 201 3 20 18 10 1 1/16 4/16 7/16 10/16 11,24 7.97 3,079.36 2,444.79 126.44 0.00 634.57 2,57 1.23 11 7 Police Dept. R ecord D iv. R icoh Police Rec ords Co pi er 201 3 20 18 10 1 Monthly 3rd--9,67 8.26 4,194.14 2,039.23 180.77 0.00 2,154.91 2,22 0.00 11 8 Wat er Works Main R i c oh Copier W ater W orks M ain Ricoh Co pi er 201 3 20 18 62 0 Monthly 10th--5,64 7.50 2,448.11 1,189.78 105.62 0.00 1,258.33 1,29 5.40 11 9 Wat er Works Colfax Ricoh C opier W ater W orks Colfa x R ico h Copier 201 3 20 18 62 0 Monthly 16th--4,73 2.65 2,051.62 997.01 85.51 0.00 1,054.61 1,08 2.52 12 0 Wat er Works Oliv e Ricoh Copier W ater W orks Olive Ricoh C opier 201 3 20 18 62 0 Monthly 10th--4,73 2.65 2,051.62 997.01 85.51 0.00 1,054.61 1,08 2.52 12 3 Police T raining D ept. Ricoh C opier Tra in i ng Copier 201 4 20 19 10 1 Monthly 30th--4,26 3.00 2,076.44 890.27 93.73 0.00 1,186.17 98 4.00 12 4 Police/Public Works V ehicle Leas e 2014 Ci ty V ehicles 201 4 20 19 Various 4/1 10/1--1,959,48 5.95 1,193,797.05 3 91,803.77 16,992.78 0.00 801,993.28 408,79 6.55 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 63,525.63 32,632.97 2,191.39 0.00 30,892.66 34,82 4.36 12 6 HP Computer Lease #2 C omputer Equipment Le ase 201 4 20 18 20 1 and 620 Monthly 8th--4,00 0.00 1,947.01 950.39 70.09 0.00 996.62 1,02 0.48 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 2,795.30 1,412.70 83.34 0.00 1,382.60 1,49 6.04 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 1,917.99 883.34 73.78 0.00 1,034.65 95 7.12 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 706.05 315.44 21.40 0.00 390.61 33 6.84 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 3,302.32 1,071.78 157.86 0.00 2,230.54 1,22 9.64 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 4,876.99 1,804.44 227.40 0.00 3,072.55 2,03 1.84 13 2 Organic Resources & Was tewater R icoh US A C opiers 201 4 20 19 64 1 Monthly 21s t--12,26 0.18 6,558.16 2,513.45 303.55 0.00 4,044.71 2,81 7.00 13 4 Wat er Works Copier - Nort h S tation R icoh US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 2,132.25 992.44 93.08 0.00 1,139.81 1,08 5.52 13 6 HP Computer Lease #8 C omputer Equipment Le ase 201 5 20 19 40 4/20 1/611 Monthly 16th--19,60 3.94 11,854.14 4,538.52 494.04 0.00 7,315.62 5,03 2.56 13 7 Anima l Control Ricoh Copier R icoh US A C opiers 201 5 20 20 60 0 Monthly 30th--5,26 1.50 3,591.88 1,033.37 182.47 0.00 2,558.51 1,21 5.84 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 94,710.62 30,905.89 3,998.51 0.00 63,804.73 34,90 4.40 14 0 Vehicle & Equip. Lease Vehi c le/Equipmen t Lease 201 5 20 20 Various 1/15 7/15--3,425,27 3.58 2,763,845.35 6 76,723.50 35,941.86 0.00 2,087,121.85 712,66 5.36 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly--3,04 0.00 2,161.06 695.77 85.67 0.00 1,465.29 78 1.44 14 4 PNC Vehicle Lease No. 2 Vehi c le Lease Pu rchase 201 5 20 20 Various 5/15 11/1 5--1,267,18 3.00 1,021,855.36 2 49,580.62 14,814.26 0.00 772,274.74 264,39 4.88 14 6 Park s & Rec. Ricoh Cop ie r R icoh Copier 201 6 20 20 20 1 Monthly--4,30 2.06 3,454.72 810.05 176.59 0.00 2,644.67 98 6.64 14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly--32,52 5.00 28,667.19 6,046.87 1,368.89 0.00 22,620.32 7,41 5.76 14 8 Cen tral Services Lanier C opier C 6502 Copier 201 6 20 20 22 2 Monthly--11,41 3.00 10,059.31 2,121.84 480.36 0.00 7,937.47 2,60 2.20 14 9 Vehicle & Equip. Lease Pu bl ic W orks Vehicles Lease 201 6 20 21 Various 2/15 8/15--3,339,83 0.00 3,016,484.17 6 51,783.72 45,609.91 0.00 2,364,700.45 697,39 3.63 15 0 HP Computer Lease C opier L ease 201 6 20 20 Various Monthly--17,43 9.85 14,013.99 3,908.91 574.29 0.00 10,105.08 4,48 3.20 15 1 Admin and Finance R ic oh Copier C opier L ease 201 6 20 21 10 1 Monthly--10,92 3.63 8,938.27 2,047.09 458.15 0.00 6,891.18 2,50 5.24 15 2 PNC Vehicle / Equ ip Lease N o. 2 Vehi c le / E quipment Lea s e 201 6 20 21 Various 1/14 7/14--3,992,54 8.72 3,992,548.72 7 70,391.63 62,984.68 0.00 3,222,157.09 833,37 6.31 15 3 PNC Vehicle / Equ ip Lease Amend 1 Parks and R ecreat io n 201 6 20 21 20 1 1/17 7/17--78,80 8.00 78,808.00 15,287.29 1,141.51 0.00 63,520.71 16,42 8.80 15 4 PNC Vehicle / Equ ip Lease N o. 3 Parks & Rec / IT 201 6 20 21 20 1/279 4/19 10/1 9--1,256,09 6.99 1,256,096.99 2 44,070.10 17,538.46 0.00 1,012,026.89 261,60 8.56 15 5 HP Computer Lease No. 13 C omputer Equipment Le ase 201 6 20 20 Various Monthly---156,02 9.30 150,562.73 33,567.37 6,602.27 0.00 116,995.36 40,16 9.64 15 7 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly---3,18 4.06 3,184.06 918.51 382.49 0.00 2,265.55 1,30 1.00 15 8 Public Fi nance.c om Inc 2017 V ehicle Lea s e No. 1 201 7 20 22 Various 1/14 7/14--2,916,50 0.00 0.00 0.00 0.00 2,9 16,5 00.00 0.00 0.00 15 9 M ayor/W aste Wate r/Fir e Ricoh 2017 Ri c oh Copier Leas e 201 7 20 21 10 1/64 1/287 Monthly---15,70 2.09 0.00 3,285.05 843.03 15,7 02.09 12,417.04 4,12 8.08 xxx T otal Cap ital L ease 33,145,18 9.96 16,078,945.72 4,8 03,081.30 244,787.36 2,9 32,2 02.09 11,291,566.51 5,047,86 8.66 To tal Civ i l C i ty 2 97,845,11 5.46 147,504,568.39 16,4 56,866.45 4,032,114.20 2,9 32,2 02.09 131,063,404.03 20,488,98 0.65 2 0 1 7-03 Finan cial Report M a r - Debt Page 1 8 o f 25 City of South Bend Period Ending:March 31, 2017 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2017 Princip al 2017 Inter est 2017 Debt a t 2017 Total D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Payme nt Addit ion 12/31/20 17 D ebt P aymen ts Re dev elopment C ommis sion Debt Bond Deb t 7 Cen tury Center Lease Rental Reven ue C entury Center 199 4 2001/201 1 20 18 40 7 2/1 8/1--6,825,00 0.00 720,000.00 4 75,000.00 16,875.00 0.00 245,000.00 491,87 5.00 8 College Foot ball H all of Fame H al l of Fame 199 4 2000/201 1 20 18 31 3 2/1 8/1--15,370,00 0.00 1,830,000.00 1,2 15,000.00 53,407.50 0.00 615,000.00 1,268,40 7.50 1 1 Sout h B end Building C orporation Mor ris P AC 199 8 200 9 20 17 40 8 2/1 8/1--13,300,00 0.00 515,000.00 5 15,000.00 10,300.00 0.00 0.00 525,30 0.00 1 2 TJX Sp eci al Taxing D is t rict 200 2 201 4 20 22 32 4/40 4/414 1/1 7/1--6,620,00 0.00 2,210,000.00 4 15,000.00 66,300.00 0.00 1,795,000.00 481,30 0.00 5 Downt own Centr al Area T IF 200 3 201 1 20 24 42 0 2/1 8/1--19,795,00 0.00 12,500,000.00 1,3 15,000.00 598,625.00 0.00 11,185,000.00 1,913,62 5.00 6 Airport Development Are a TIF Airport TIF 200 3 201 1 20 24 32 4 2/1 8/1--14,420,00 0.00 7,125,000.00 7 50,000.00 341,210.50 0.00 6,375,000.00 1,091,21 0.50 2 2 Erskin e V illage TIF Development Bond Er s ki ne Vil la ge 200 5 20 27 43 2 2/1 8/1--5,485,00 0.00 3,800,000.00 3,8 00,000.00 161,666.72 0.00 0.00 3,961,66 6.72 5 4 L ease Ren t al R evenu e B onds of 200 8 Eddy S t reet Co mmons 200 8 20 27 42 9 2/15 8/15--36,000,00 0.00 30,075,000.00 1,3 15,000.00 1,148,181.26 0.00 28,760,000.00 2,463,18 1.26 8 1 Coveles k i Stadi um Reco v ery C oveleski S tadium 201 0 20 19 37 7 1/15 7/15--4,980,00 0.00 1,665,000.00 6 50,000.00 77,155.00 0.00 1,015,000.00 727,15 5.00 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 200,000.00 1 00,000.00 0.00 0.00 100,000.00 100,00 0.00 13 5 2 015 Redevelopm ent Smar t St reets Smarts Stre ets 201 5 20 37 32 4 2/1 8/1 25,000,00 0.00 25,000,000.00 4 60,000.00 394,784.38 0.00 24,540,000.00 854,78 4.38 xxx Total Bond Debt 1 53,788,78 8.00 85,640,000.00 11,0 10,000.00 2,868,505.36 0.00 74,630,000.00 13,878,50 5.36 Loa ns Payab le 3 In di ana Development Finance Autho rity Bos c h P roperty (Nonforgive)200 1 20 21 21 0 3/22 6/22 9/22 12/22 1,040,00 0.00 302,069.15 63,660.08 8,350.36 0.00 238,409.07 72,01 0.44 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 83,482.06 0.00 0.00 0.00 65,888.51 0.00 6 4 In terfu nd F und 412 - Major Mov es D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,040,31 9.00 323,005.00 3 22,201.00 12,088.00 0.00 804.00 334,28 9.00 8 4 In terfu nd F und 412 - Major Mov es Trian gle Development 201 1 20 29 43 6 2/15 8/15--2,000,00 0.00 1,329,573.43 94,621.29 26,120.71 0.00 1,234,952.14 120,74 2.00 8 5 In terfu nd F und 412 - Major Mov es Eddy S t reet Co mmons 201 1 20 26 43 6 2/15 8/15--4,100,00 0.00 2,384,347.86 6 61,383.84 111,052.16 0.00 1,722,964.02 772,43 6.00 8 6 In terfu nd F und 209 to Air port 324 Pr airie Ave Brownf ie ld Project 201 1 20 20 32 4 8/9---500,00 0.00 400,000.00 1 00,000.00 0.00 0.00 300,000.00 100,00 0.00 14 2 In terfu nd F und 412 - Major Mov es Parking Garage Improve ments 201 6 20 22 60 1 6/1 12/1 1,500,00 0.00 517,304.69 2 29,174.05 20,825.95 7 50,0 00.00 1,038,130.64 250,00 0.00 xxx Total Loans Pa yable 15,627,49 9.06 5,339,782.19 1,4 71,040.26 178,437.18 7 50,0 00.00 4,601,148.38 1,649,47 7.44 Ca pita l Lease xxx T otal Cap ital L ease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leas es 1 3 Tran s po Lea s e Main / C ol fax Gar age 200 6 20 25 40 4 3/15 9/15--2,510,27 8.00 1,435,338.00 1 29,838.00 70,162.00 0.00 1,305,500.00 200,00 0.00 xxx Tot al Lease 5,510,27 8.00 1,435,338.00 1 29,838.00 70,162.00 0.00 1,305,500.00 200,00 0.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 92,415,120.19 12,6 10,878.26 3,117,104.54 7 50,0 00.00 80,536,648.38 15,727,98 2.80 To tal Debt 4 72,771,68 0.52 239,919,688.58 29,0 67,744.71 7,149,218.74 3,6 82,2 02.09 211,600,052.41 36,216,96 3.45 2 0 1 7-03 Finan cial Report M a r - Debt Page 1 9 o f 25 City of South Bend Period Ending:March 31, 2017 Monthly Debt Schedule` Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at YT D Principa l Y TD Interes t YT D Debt a t D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Pay ments Ad ditions 3/3 1/2017 Civil City Debt Bond Deb t A mort s ch # 3 1 CEDIT Bond 199 7 200 6 20 17 40 8 2/1 8/1--11,870,00 0.00 430,000.00 4 30,000.00 9,932.50 0.00 0.00 3 6 Sout h B end Building C orporation Pu bl ic W orks Building 200 1 201 0 20 21 40 4/649 2/1 8/1--9,250,00 0.00 2,755,000.00 2 85,000.00 50,313.00 0.00 2,470,000.00 2 5 Wat er Works Impr ovemen ts W ater W orks 200 2 201 2 20 23 62 5 7/1 12/3 1--5,975,00 0.00 2,380,000.00 0.00 0.00 0.00 2,380,000.00 3 9 Sout h B end Building C orporation Fire HQ / P ol ice H Q 200 3 201 2 20 23 40 4/324 2/1 8/1--21,335,00 0.00 8,885,000.00 6 20,000.00 164,730.00 0.00 8,265,000.00 2 4 Wat er Works Impr ovemen ts W ater W orks 200 6 20 27 62 5 7/1 12/3 1--4,710,00 0.00 0.00 0.00 0.00 0.00 0.00 6 2 Cen tury Center Spec i al Tax Bonds C entury Center 200 8 20 28 32 4 5/1 11/1--4,655,00 0.00 3,175,000.00 0.00 0.00 0.00 3,175,000.00 6 9 Wat er Works Impr ovemen ts W ater W orks 200 9 20 30 62 5 7/1 12/3 1--5,380,00 0.00 4,325,000.00 0.00 0.00 0.00 4,325,000.00 7 0 Sewage W orks Reve nue Bon ds - 2009 Sewag e W orks 200 9 20 28 64 9 6/1 12/1--3,297,00 0.00 2,249,643.00 0.00 0.00 0.00 2,249,643.00 8 0 2 010 Sewage W orks Re v enue Bonds Sewag e W orks 201 0 20 30 64 9 6/1 12/1--9,345,00 0.00 7,145,000.00 0.00 0.00 0.00 7,145,000.00 9 3 Sewage W orks Reve nue Bon ds 201 1 Sewag e W orks 201 1 20 31 64 9 6/1 12/1--21,500,00 0.00 17,295,000.00 0.00 0.00 0.00 17,295,000.00 9 9 2 012 W ater Wo rks Reven ue Bond W ater W orks 201 2 20 33 62 5 1/1 7/1--8,300,00 0.00 6,925,000.00 0.00 0.00 0.00 6,925,000.00 10 1 2 012 Sewage W orks Re v enue Bonds Sewag e W orks 201 2 20 32 64 9 6/1 12/1--25,000,00 0.00 20,890,000.00 0.00 0.00 0.00 20,890,000.00 10 5 2 013A Sewer Bon d Refunding Sewag e W orks 201 3 201 3 20 24 64 9 6/1 12/1--14,765,00 0.00 8,050,000.00 0.00 0.00 0.00 8,050,000.00 11 6 2 013 Building C orporation EMS / Fire D epar t ment 201 3 20 33 28 8 2/1 8/1--5,580,00 0.00 5,145,000.00 2 25,000.00 90,427.50 0.00 4,920,000.00 13 3 St. Joseph Cou nty PS AP St. J oseph County PSA P 201 4 20 34 40 8 Monthly---2,657,69 6.50 2,386,507.92 0.00 0.00 0.00 2,386,507.92 paid thru 2/28/1 7 13 9 Cen tury Center En ergy Saving s Impro v ements C entury Ctr.201 5 20 31 67 2 5/1 11/1--4,167,89 7.00 4,145,312.00 0.00 0.00 0.00 4,145,312.00 14 1 Park s and Rec Bo nd Parks Improveme nts 201 5 20 35 40 8 2/1 8/1--5,605,00 0.00 5,295,000.00 1 10,000.00 88,566.00 0.00 5,185,000.00 14 5 Sewage W orks Reve nue Bon ds - 2015 Sewer B ond Improvements 201 5 20 25 64 9 6/1 12/1--27,440,00 0.00 24,965,000.00 0.00 0.00 0.00 24,965,000.00 15 6 2 016 W ater Wo rks Refu nding Bon ds R efunding 20 00 / 2 006 SRF 201 6 20 27 62 5 1/1 7/1--3,300,00 0.00 3,300,000.00 0.00 0.00 0.00 3,300,000.00 xxx Total Bond Debt 2 34,877,59 3.50 129,741,462.92 1,6 70,000.00 403,969.00 0.00 128,071,462.92 Loa ns Payab le 6 8 State R evolving F und W ater W orks Improvement 200 9 20 30 62 5 7/1 12/3 1--427,33 2.00 332,562.00 0.00 0.00 0.00 332,562.00 8 2 In terfu nd Loan 41 0 - UDAG 1st Sour c e/Marriott Garage 201 0 20 15 41 0 6/15 12/1 5--2,700,00 0.00 1,351,597.75 0.00 0.00 0.00 1,351,597.75 2 6 State R evolving F und W ater W orks Improvements 200 0 20 19 62 5 7/1 12/3 1--2,600,00 0.00 0.00 0.00 0.00 0.00 0.00 xxx Total Loans Pa yable 29,822,33 2.00 1,684,159.75 0.00 0.00 0.00 1,684,159.75 Ca pita l Leases 5 1 Ch ase LE D Equipmen t 200 7 20 17 10 1 1/1 7/1--1,531,57 3.00 194,320.02 96,131.38 4,158.45 0.00 98,188.64 8 9 Sun Trust Police, Parks, Bl dg vehicles 201 1 20 16 40 4/20 1/600 3/15 6/15 9/15 12/15 2,068,20 2.00 0.00 0.00 0.00 0.00 0.00 9 0 Cap ital One Public Fundin g Solid Was te Cont ai ners/Truc k s 201 1 20 16 61 1 3/15 6/15 9/15 12/15 207,43 2.00 0.00 0.00 0.00 0.00 0.00 9 1 GE Cap ital I nfor mation Techn ology Police Dept Copier 201 1 20 16 10 1 1/11 4/11 7/11 10/11 3,83 6.00 0.00 0.00 0.00 0.00 0.00 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 0.00 0.00 0.00 0.00 0.00 9 4 Iko n Office Solu t ions Mayor Ric oh M P 2851 SP Copier 201 1 20 16 10 1 2/15 5/15 8/15 11/15 2,56 9.53 0.00 0.00 0.00 0.00 0.00 9 5 Sun Trust E quipme nt F in ance Parks-Golf C ars Lease 201 2 20 16 20 1 4/15 10/1 5--344,50 0.00 0.00 0.00 0.00 0.00 0.00 9 7 Sun Trust E quipme nt F in ance Police Veh ic le s & Equ ipment 201 2 20 17 40 6 5/15 11/1 5--1,295,00 0.00 134,585.22 0.00 0.00 0.00 134,585.22 9 8 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/640 5/15 11/1 5--945,67 4.38 97,793.51 0.00 0.00 0.00 97,793.51 10 0 PNC Equipm ent F inance Pu bl ic W orks Vehicles Lease 201 2 20 17 20 2/64 1/600/288 1/15 7/15--2,806,05 4.00 575,316.55 2 86,723.17 3,752.50 0.00 288,593.38 10 2 Iko n Office Solu t ions / Ricoh W astewater C opier 201 2 20 17 64 1 Monthly 1st--5,74 4.95 756.77 321.28 9.20 0.00 435.49 10 3 GE Cap ital I nfor mation Techn ology Fire Department Cop ie r 201 2 20 17 10 1 2/28 5/28 8/28 11/28 5,47 1.01 926.68 304.08 13.62 0.00 622.60 10 6 Ricoh U SA C entra l Servi c es Copier 201 3 20 18 22 2 2/27 5/27 8/27 11/27 3,62 2.78 815.82 202.33 7.61 0.00 613.49 10 7 Ricoh U SA Street/Sewer Dept Copier 201 3 20 18 20 2/641 3/4 6/4 9/4 12/4 5,55 9.15 1,225.93 299.88 17.82 0.00 926.05 10 8 Ricoh U SA C ity Att orney C opier 201 3 20 18 10 1 2/12 5/12 8/12 11/12 5,55 9.15 1,232.73 305.77 11.93 0.00 926.96 10 9 Ricoh U SA Parks & Rec Ricoh Copi ers(3)201 3 20 18 20 1 2/21 5/21 8/21 11/21 16,12 9.94 3,575.09 887.23 34.58 0.00 2,687.86 11 0 PNC Equipm ent F inance Vehi c le/Equipmen t Lease 201 3 20 18 10 1/20 2/406/641 1/15 7/15--1,689,66 9.59 689,257.88 1 70,745.79 4,204.47 0.00 518,512.09 11 1 Ricoh U SA En gi neer in g P l otter/Scan ner 201 3 20 18 10 1 3/3 6/3 9/3 12/3 10,66 7.67 2,459.26 595.09 52.91 0.00 1,864.17 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly--4,09 3.64 1,491.77 215.11 19.64 0.00 1,276.66 11 3 Sun Trust E quipme nt F in ance Police and PW vehicles 201 3 20 18 40 4/65 5/611/202 4/24 10/2 4--1,506,46 5.26 616,891.89 0.00 0.00 0.00 616,891.89 11 4 Ricoh U SA Admi n & Fina nce Copier 201 3 20 18 10 1 1/16 4/16 7/16 10/16 11,24 7.97 3,079.36 598.03 44.70 0.00 2,481.33 11 7 Police Dept. R ecord D iv. R icoh Police Rec ords Co pi er 201 3 20 18 10 1 Monthly 3rd--9,67 8.26 4,194.14 499.31 55.69 0.00 3,694.83 11 8 Wat er Works Main R i c oh Copier W ater W orks M ain Ricoh Co pi er 201 3 20 18 62 0 Monthly 10th--5,64 7.50 2,448.11 291.31 32.54 0.00 2,156.80 11 9 Wat er Works Colfax Ricoh C opier W ater W orks Colfa x R ico h Copier 201 3 20 18 62 0 Monthly 16th--4,73 2.65 2,051.62 244.12 27.26 0.00 1,807.50 12 0 Wat er Works Oliv e Ricoh Copier W ater W orks Olive Ricoh C opier 201 3 20 18 62 0 Monthly 10th--4,73 2.65 2,051.62 244.12 27.26 0.00 1,807.50 12 3 Police T raining D ept. Ricoh C opier Tra in i ng Copier 201 4 20 19 10 1 Monthly 30th--4,26 3.00 2,076.44 217.92 28.08 0.00 1,858.52 12 4 Key Go v ernment Fi nance 2014 Ci ty V ehicles 201 4 20 19 various 4/1 10/1--1,959,48 5.95 1,193,797.05 0.00 0.00 0.00 1,193,797.05 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 63,525.63 8,021.33 684.76 0.00 55,504.30 12 6 HP Computer Lease #2 C omputer Equipment Le ase 201 4 20 18 20 1 and 620 Monthly 8th--4,00 0.00 1,947.01 233.49 21.63 0.00 1,713.52 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 2,795.30 348.07 25.94 0.00 2,447.23 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 1,917.99 216.84 22.44 0.00 1,701.15 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 706.05 77.74 6.47 0.00 628.31 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 3,302.32 262.35 45.06 0.00 3,039.97 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 4,876.99 441.70 66.26 0.00 4,435.29 13 2 Organic Resources & Was tewater R icoh US A C opiers 201 4 20 19 64 1 Monthly 21s t--12,26 0.18 6,558.16 615.25 89.00 0.00 5,942.91 13 4 Wat er Works Copier - Nort h S tation R icho US A C opiers 201 4 20 19 62 0 Monthly 19th--4,73 2.65 2,132.25 243.00 28.38 0.00 1,889.25 13 6 HP Computer Lease #8 C omputer Equipment Le ase 201 5 20 19 40 4/20 1/611 Monthly 16th--19,60 3.94 11,854.14 1,113.30 144.84 0.00 10,740.84 13 7 Anima l Control Ricoh Copier R icoh US A C opiers 201 5 20 20 60 0 Monthly 30th--5,26 1.50 3,591.88 252.72 51.24 0.00 3,339.16 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 94,710.62 7,583.76 1,142.34 0.00 87,126.86 14 0 Vehicle & Equip. Lease Vehi c le/Equipmen t Lease 201 5 20 20 Various 1/15 7/15--3,425,27 3.58 2,763,845.35 3 37,194.29 19,138.39 0.00 2,426,651.06 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly 3,04 0.00 2,161.06 170.94 24.42 0.00 1,990.12 14 4 PNC Vehicle Lease No. 2 Vehi c le Lease Pu rchase 201 5 20 20 various 5/15 11/1 5--1,267,18 3.00 1,021,855.36 0.00 0.00 0.00 1,021,855.36 14 6 Park s & Rec reation Copier R icoh Copier 201 6 20 20 20 1 Monthly 4,30 2.06 3,454.72 198.20 48.46 0.00 3,256.52 14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly---32,52 5.00 28,667.19 1,481.98 371.96 0.00 27,185.21 14 8 Cen tral Services Lanier C opier C 6502 201 6 20 20 22 2 Monthly---11,41 3.00 10,059.31 520.02 130.53 0.00 9,539.29 14 9 Vehicle & Equip. Lease Pu bl ic W orks Vehicles Lease 201 6 20 21 various 2/15 8/15 3,339,83 0.00 3,016,484.17 3 24,595.10 24,101.71 0.00 2,691,889.07 15 0 HP Computer Lease C omputer Leas e- Ref resh 201 6 20 20 40 4/64 1/620 Monthly---17,43 9.85 14,013.99 960.13 160.67 0.00 13,053.86 15 1 Admin and Finance R ic oh Copier MPC800 2S P Copier 201 6 20 21 10 1 Monthly---10,92 3.63 8,938.27 500.87 125.44 0.00 8,437.40 15 2 PNC Vehicle / Equ ip Lease N o. 2 Vehi c le / E quipment Lea s e 201 6 20 21 various 1/14 7/14--3,992,54 8.72 3,992,548.72 3 81,193.11 35,495.05 0.00 3,611,355.61 15 3 PNC Vehicle / Equ ip Lease Amend 1 Parks and R ecreat io n 201 6 20 12 20 1 1/17 7/17--78,80 8.00 78,808.00 7,614.67 599.73 0.00 71,193.33 15 4 PNC Vehicle / Equ ip Lease N o. 3 Parks & Rec / IT 201 6 20 21 20 1/279 4/19 10/1 9--1,256,09 6.99 1,256,096.99 0.00 0.00 0.00 1,256,096.99 15 5 HP Computer Lease No. 13 C omputer Equipment Le ase 201 6 20 20 various Monthly---156,02 9.30 150,562.73 8,238.95 1,806.46 0.00 142,323.78 15 7 Venue, Parks, Ar t Copier R icoh Copier 201 6 20 21 20 1 Monthly---3,18 4.06 3,184.06 489.45 226.12 0.00 2,694.61 15 8 Public Fi nance.c om Inc 2017 V ehicle Lea s e No. 1 201 7 20 22 various 1/14 7/14--2,916,50 0.00 0.00 0.00 0.00 2,9 16,5 00.00 2,916,500.00 15 9 M ayor/W aste Wate r/Fir e Ricoh 2017 Ri c oh Copier Leas e 201 7 20 21 10 1/64 1/287 Monthly---15,70 2.09 0.00 658.48 92.08 15,7 02.09 15,043.61 xxx T otal Cap ital L ease 33,145,18 9.96 16,078,945.72 1,6 42,051.66 97,147.64 2,9 32,2 02.09 17,369,096.15 To tal Civ i l C i ty 2 97,845,11 5.46 147,504,568.39 3,3 12,051.66 501,116.64 2,9 32,2 02.09 147,124,718.82 2 0 1 7-03 Finan cial Report M a r - Debt Page 2 0 o f 25 City of South Bend Period Ending:March 31, 2017 Monthly Debt Schedule` Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at YT D Principa l Y TD Interes t YT D Debt a t D eb t In strumen t D ebt Pur po se Issue Refunding M aturity F un d 1st 2nd 3rd 4th Is sue 12/3 1/20 16 Paym ents Pay ments Ad ditions 3/3 1/2017 Re dev elopment C ommis sion Debt Bond Deb t 7 Cen tury Center Lease Rental Reven ue C entury Center 199 4 2001/201 1 20 18 40 7 2/1 8/1--6,825,00 0.00 720,000.00 2 35,000.00 10,200.00 0.00 485,000.00 8 College Foot ball H all of Fame H al l of Fame 199 4 2000/201 1 20 18 31 3 2/1 8/1--15,370,00 0.00 1,830,000.00 6 00,000.00 31,728.75 0.00 1,230,000.00 1 1 Sout h B end Building C orporation Mor ris P AC 199 8 200 9 20 17 40 8 2/1 8/1--13,300,00 0.00 515,000.00 5 15,000.00 10,300.00 0.00 0.00 1 2 TJX Sp eci al Taxing D is t rict 200 2 201 4 20 22 32 4/40 4/414 1/1 7/1--6,620,00 0.00 2,210,000.00 0.00 0.00 0.00 2,210,000.00 5 Downt own Centr al Area T IF 200 3 201 1 20 24 42 0 2/1 8/1--19,795,00 0.00 12,500,000.00 6 50,000.00 306,755.00 0.00 11,850,000.00 6 Airport Development Are a TIF Airport TIF 200 3 201 1 20 24 32 4 2/1 8/1--14,420,00 0.00 7,125,000.00 3 70,000.00 174,841.75 0.00 6,755,000.00 2 2 Erskin e V illage TIF Development Bond Er s ki ne Vil la ge 200 5 20 27 43 2 2/1 8/1--5,485,00 0.00 3,800,000.00 2 50,000.00 123,667.50 0.00 3,550,000.00 5 4 L ease Ren t al R evenu e B onds of 200 8 Eddy S t reet Co mmons 200 8 20 27 42 9 2/15 8/15--36,000,00 0.00 30,075,000.00 6 55,000.00 579,003.13 0.00 29,420,000.00 8 1 Coveles k i Stadi um Reco v ery C oveleski S tadium 201 0 20 19 37 7 1/15 7/15--4,980,00 0.00 1,665,000.00 3 25,000.00 42,640.00 0.00 1,340,000.00 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 200,000.00 0.00 0.00 0.00 200,000.00 13 5 2 015 Redevelopm ent Smar t St reets Smart Stre ets 201 5 20 37 32 4 2/1 8/1 25,000,00 0.00 25,000,000.00 0.00 394,784.38 0.00 25,000,000.00 xxx Total Bond Debt 1 53,788,78 8.00 85,640,000.00 3,6 00,000.00 1,673,920.51 0.00 82,040,000.00 Loa ns Payab le 3 In di ana Development Finance Autho rity Bos c h P roperty (Nonforgive)200 1 20 21 21 0 3/22 6/22 9/22 12/22 1,040,00 0.00 302,069.15 15,737.09 2,265.52 0.00 286,332.06 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 83,482.06 0.00 0.00 0.00 66,406.56 6 4 In terfu nd F und 412 - Major Mov es D ouglas Road TIF 200 9 20 29 43 5 2/15 8/15--1,040,31 9.00 323,005.00 1 41,925.00 8,075.00 0.00 181,080.00 8 4 In terfu nd F und 412 - Major Mov es Trian gle Development 201 1 20 29 43 6 2/15 8/15--2,000,00 0.00 1,329,573.43 47,075.27 13,295.73 0.00 1,282,498.16 8 5 In terfu nd F und 412 - Major Mov es Eddy S t reet Co mmons 201 1 20 26 43 6 2/15 8/15--4,100,00 0.00 2,384,347.86 3 26,609.30 59,608.70 0.00 2,057,738.56 8 6 In terfu nd F und 209 to Air port 324 Pr airie Ave Brownf ie ld Project 201 1 20 20 32 4 8/9---500,00 0.00 400,000.00 0.00 0.00 0.00 400,000.00 14 2 In terfu nd F und 412 - Major Mov es Parking Garage Improve ments 201 6 20 22 60 1 6/1 12/1--1,500,00 0.00 517,304.69 0.00 0.00 7 50,0 00.00 1,267,304.69 xxx Total Loans Pa yable 15,627,49 9.06 5,339,782.19 5 31,346.66 83,244.95 7 50,0 00.00 5,541,360.03 Ca pita l Lease xxx T otal Cap ital L ease 0.00 0.00 0.00 0.00 0.00 0.00 Leas es 1 3 Tran s po Lea s e Main / C ol fax Gar age 200 6 20 25 40 4 3/15 9/15--2,510,27 8.00 1,435,338.00 64,117.00 35,883.00 0.00 1,371,221.00 xxx Tot al Lease 5,510,27 8.00 1,435,338.00 64,117.00 35,883.00 0.00 1,371,221.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 92,415,120.19 4,1 95,463.66 1,793,048.46 7 50,0 00.00 88,952,581.03 To tal Debt 4 72,771,68 0.52 239,919,688.58 7,5 07,515.32 2,294,165.10 3,6 82,2 02.09 236,077,299.85 2 0 1 7-03 Finan cial Report M a r - Debt Page 2 1 o f 25 City of South Bend Staffing Headcount Summary Budget Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1,116 1,080 1,069 1,082 - - - - 0 0 0 0 0 Part Time Staff 115 119 142 0 0 0 0 0 0 0 0 0 Temporary / Seasonal 12 11 13 0 0 0 0 0 0 0 0 0 City Total 1,207 1,199 1,237 - - - - 0 0 0 0 0 2017-03 Financial Report Mar - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Amended Budget FT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 7 6 6 6 0 0 0 0 0 0 0 0 0 311 Call Center 6 6 6 6 0 0 0 0 0 0 0 0 0 Admin & Finance 23 20 21 22 0 0 0 0 0 0 0 0 0 Innovation/ Technology Office 18 14 14 15 0 0 0 0 0 0 0 0 0 Safety & Risk 2 2 2 2 0 0 0 0 0 0 0 0 0 Clerk 5 5 5 5 0 0 0 0 0 0 0 0 0 Common Council 9 9 9 9 0 0 0 0 0 0 0 0 0 Legal Department 10 11 11 10 0 0 0 0 0 0 0 0 0 Sub Total 80 73 74 75 0 0 0 0 0 0 0 0 0 Code Enf. /Animal Control 29 20 22 24 0 0 0 0 0 0 0 0 0 Dept. of Community Investment 23 22 20 21 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 6 6 6 6 0 0 0 0 0 0 0 0 0 Maintenance 46 45 47 48 0 0 0 0 0 0 0 0 0 Golf Operations 8 7 8 7 0 0 0 0 0 0 0 0 0 Recreation Ops 25 22 21 21 0 0 0 0 0 0 0 0 0 Zoological Ops 1 1 1 1 0 0 0 0 0 0 0 0 0 Graffiti Removal 1 1 1 1 0 0 0 0 0 0 0 0 0 Recreation Non-reverting 1 1 1 1 Marketing and Events 10 8 10 10 0 0 0 0 0 0 0 0 0 Sub Total 98 91 95 95 0 0 0 0 0 0 0 0 0 Public Safety Police 289 284 272 282 0 0 0 0 0 0 0 0 0 Fire 264 268 267 266 0 0 0 0 0 0 0 0 0 Sub Total 553 552 539 548 0 0 0 0 0 0 0 0 0 Public Works Central Services 37 35 36 35 0 0 0 0 0 0 0 0 0 Office of Sustainability 2 2 2 2 0 0 0 0 0 0 0 0 0 Engineering 18 18 18 20 0 0 0 0 0 0 0 0 0 Maintenance 3 3 3 2 0 0 0 0 0 0 0 0 0 Solid Waste Operations 26 25 25 26 0 0 0 0 0 0 0 0 0 Unsafe Bldg Code Clean Crew 4 4 4 4 0 0 0 0 0 0 0 0 0 Street Operations 55 54 54 54 0 0 0 0 0 0 0 0 0 Sewer Operations 37 37 37 37 0 0 0 0 0 0 0 0 0 Waste Water Ops 45 45 45 44 0 0 0 0 0 0 0 0 0 Organic Resources 6 6 5 5 0 0 0 0 0 0 0 0 0 Water Utility Ops 71 64 63 63 0 0 0 0 0 0 0 0 0 Sub Total 304 293 292 292 0 0 0 0 0 0 0 0 0 Building Department 14 14 14 14 0 0 0 0 0 0 0 0 0 Human Rights 6 6 6 6 0 0 0 0 0 0 0 0 0 Morris & Palais 9 9 7 7 0 0 0 0 0 0 0 0 0 City Total 1,116 1,080 1,069 1,082 - - - - - - - - - 2017-03 Financial Report Mar - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1 1 1 0 0 0 0 0 0 0 0 0 311 Call Center 2 2 2 0 0 0 0 0 0 0 0 0 Admin & Finance 0 0 0 0 0 0 0 0 0 0 0 0 Safety and Risk 0 0 0 0 0 0 0 0 0 0 0 0 Innovation/ Technology Office 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal Department 1 1 1 0 0 0 0 0 0 0 0 0 Sub Total 5 4 4 0 0 0 0 0 0 0 0 0 Code Enf. / Animal Control 3 2 3 0 0 0 0 0 0 0 0 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 1 1 1 0 0 0 0 0 0 0 0 0 Maintenance 11 11 11 0 0 0 0 0 0 0 0 0 Golf Operations 2 0 18 0 0 0 0 0 0 0 0 0 Recreation Ops 46 54 54 0 0 0 0 0 0 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 4 4 4 0 0 0 0 0 0 0 0 0 Marketing & Events 1 1 1 0 0 0 0 0 0 0 0 0 Sub Total 65 70 88 0 0 0 0 0 0 0 0 0 Public Safety Police 25 25 29 0 0 0 0 0 0 0 0 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 25 25 29 0 0 0 0 0 0 0 0 0 Public Works` Central Services 1 1 1 0 0 0 0 0 0 0 0 0 Engineering 2 2 2 0 0 0 0 0 0 0 0 0 Traffic & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Ops 0 0 0 0 0 0 0 0 0 0 0 0 Street Ops 7 8 9 0 0 0 0 0 0 0 0 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 3 3 2 0 0 0 0 0 0 0 0 0 Sub Total 13 14 14 0 0 0 0 0 0 0 0 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 4 4 4 0 0 0 0 0 0 0 0 0 City Total 115 119 142 0 0 0 0 0 0 0 0 0 2017-03 Financial Report Mar - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Paid Temporary, Seasonal, and Intern Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 0 0 0 0 0 0 0 0 0 0 0 0 Admin & Finance 1 1 0 0 0 0 0 0 0 0 0 0 Safety and Risk 1 0 0 0 0 0 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 2 1 0 0 0 0 0 0 0 0 0 0 Code Enfor. / Animal 1 1 1 0 0 0 0 0 0 0 0 0 Dept. of Community Investment 0 0 0 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 1 1 2 0 0 0 0 0 0 0 0 0 Golf Operations 0 0 1 0 0 0 0 0 0 0 0 0 Recreation Ops 3 2 2 0 0 0 0 0 0 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 4 3 5 0 0 0 0 0 0 0 0 0 Public Safety Police 0 0 0 0 0 0 0 0 0 0 0 0 Communications 0 0 0 0 0 0 0 0 0 0 0 0 Fire 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 0 0 0 0 0 0 0 0 0 0 0 0 Public Works Central Services 0 0 0 0 0 0 0 0 0 0 0 0 Engineering 3 4 4 0 0 0 0 0 0 0 0 0 Energy / Sustainability 0 0 0 0 0 0 0 0 0 0 0 0 Traffic & Lighting 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 0 Solid Waste Ops 0 0 0 0 0 0 0 0 0 0 0 0 Street Ops 1 1 1 0 0 0 0 0 0 0 0 0 Sewer Ops 0 0 0 0 0 0 0 0 0 0 0 0 Leaf Pickup 0 0 0 0 0 0 0 0 0 0 0 0 Waste Water Ops 0 0 1 0 0 0 0 0 0 0 0 0 Organic Resources 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 0 0 0 0 0 0 0 0 0 0 0 0 Sub Total 4 5 6 0 0 0 0 0 0 0 0 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 1 1 1 0 0 0 0 0 0 0 0 0 City Total 12 11 13 0 0 0 0 0 0 0 0 0 2017-03 Financial Report Mar - Headcount Staffing Page 25 of 25