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