Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
06-2016 Financial Report
Period Ending: Issued By: City of South Bend Financial Report Tab Page Contents Narrative 2 Brief discussion on notable fund activity Revenue 3-10 City Revenues Prop Tax Rev 11-12 Property Tax Revenue Collection Status Expenditures 13-17 Expenditures by Fund and Department Debt 18-19 Debt Status Debt Monthly 20-21 Current Debt at Month End Headcount 22-25 Staffing Levels Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Controller John Murphy Deputy Controller Jennifer Hockenhull City Finance Director Rahman Johnson Sr. Budget Analyst Cecil Eastman Department Heads Fiscal Officers City Common Council June 30, 2016 Controller Financial Report June 2016 Page 1 of 25 June 30, 2016 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 257(LOIT 2016 Special Distribution). Last month, the City received a one-time special distribution from the state for local option option income tax (LOIT) totaling $5.6 million dollars. The state stipulated that 75% was to be used for infrastructure improvements and 25% could be used for any governmental purpose. Fund 257 was seeded with $4,217,549 to account for these funds. The remaining money was deposited into fund 102 (Rainy Day Fund). -Fund 258 (Human Rights). This is revenue related to grants received to battle housing and employment discrimination. -Fund 294 (Police Academy). This fund has reached 84% of its budgeted revenue. This is tuition related to the advancement of present and future officers. -Fund 677 (Hall of Fame), is at 95% of its budgeted revenue. This is revenue received in the amount of $48,709 for the sale of the property, for construction of a new motel. -Fund 661 (2012 Sewer Bond), is at 91% of its budgeted revenue. This is revenue from bank and investment interest. 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 June 2016,the City has spent 35%of budgeted expenditures,compared to 36%in June 2015.The General Fund has spent 45%of its 2016 budgeted expenditures,versus 49%in 2015.The following funds have reached 50%or more of their budgeted expenditures as a result of bond payments:Fund 313(Hall of Fame),Fund 410(UDAG),Fund 377(Professional Sports Development),and Fund 432(TIF- Erskine Village). This month,various debt service payments were made in the amount of~$289,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 $3.9 million in debt for a new vehicle and equipment lease with PNC Bank. The Full Time Headcount as of June was 1,072 vs.a budgeted amount of 1,102.Currently,there are a total of 30 vacant positions.The 30 open positions are in the following departments:Parks and Recreation(1),Public Safety(21),Public Works(6),DCl(1),and General Government (1). For discussion on property taxes,see section listed below.The overall percentage of budgeted revenues that have been received by the city is 51%,compared to 50%in June 2015.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 350 (Job Target Penalty Fee) has reached 100% of its budgeted revenue. As of June 2016,the general fund has reached 53%of its budgeted revenue,compared to 54%last year.The following funds have reached slightly above the normal percentage of their 2016 budgeted revenue amount at this time: Property taxes are received in June and December.Property taxes collected in June 2016 totaled~$41.5 million.Civil city funds received ~$26.8 million and TIF funds received ~ $14.7 million. For 2016, the levy collection rate has yet to be determined. - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) received normal and timely distributions this month. Financial Report June 2016 Page 2 of 25 City of South Bend Period Ending:June 30, 2016 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- - - - - 26,788,327 - - - - - 26,788,327 48,334,000 55% 311 Property Tax TIF Districts various- - - - - 14,767,546 - - - - - 14,767,546 25,562,223 58% Sub Total- - - - - 41,555,873 - - - - - - 41,555,873 73,896,223 56% Income Tax 315 Econ Development Income Tax 408 799,550 799,550 799,550 799,550 799,550 799,550 - - - - - - 4,797,301 9,594,602 50% 316 Rainy Day Fund 102- - - - 1,405,850 - - - - - - - 1,405,850 1,405,850 100% 316 Local Option Income Tax - PS 249 565,930 565,930 565,930 565,930 565,930 565,930 - - - - - - 3,395,580 6,791,160 50% 316 LOIT 2016 Special Distribution 257- - - - 4,217,550 - - - - - - - 4,217,550 4,217,550 100% 316 County Option Income Tax 404 787,835 787,835 787,835 787,835 787,835 787,835 - - - - - - 4,727,012 9,454,023 50% Sub Total 2,153,315 2,153,315 2,153,315 2,153,315 7,776,715 2,153,315 - - - - - - 18,543,292 31,463,185 59% St Joseph County (Remitted by) 312 Auto Excise Tax various- - - - - 1,573,554 - - - - - - 1,573,554 3,195,000 49% 312 Commercial Vehicle Tax various- - - - - 414,809 - - - - - - 414,809 824,700 50% 317 Hotel Motel Tax Century Center 670 656,725 - - - - - - - - - - - 656,725 1,313,436 50% 317 Hotel Motel Tax Century Center 324- 198,500 - - - - - - - - 198,500 396,000 50% 317 Hotel Motel Tax Cum Cap Imprv 407 150,000 - - - - - - - - - - - 150,000 150,000 100% Sub Total 806,725 - - 198,500 - 1,988,363 - - - - - - 2,993,588 5,879,136 51% State of Indiana (Remitted by) 312 CRED Tax 434- - - - - - - - - - - - - - NA 335 Cigarette Tax 101/407- - - - - 154,629 - - - - - - 154,629 331,000 47% 335 State Pension Subsidy 701/702- - - - - 5,432,011 - - - - - - 5,432,011 10,858,021 50% 335 Gaming Proceeds 101- - - - - - - - - - - - - 600,000 0% 335 Gasoline Tax 202/251 364,876 317,613 402,674 503,137 412,761 385,178 - - - - - - 2,386,238 4,118,000 58% 335 Liquor Excise tax 101 44,798 - - - - 29,634 - - - - - - 74,432 70,000 106% 335 Liquor Gallonage Tax 101 57,692 - - 46,627 - - - - - - - - 104,319 200,000 52% 335 Prof Sports Development Tax 377 149,007 47,449 64,753 42,616 110,536 42,482 - - - - - - 456,843 660,000 69% 335 Wheel Tax 202- - 510,537 217,294 223,843 - - - - - - - 951,674 2,050,000 46% Sub Total 616,372 365,062 977,964 809,675 747,140 6,043,933 - - - - - - 9,560,145 18,887,021 51% Other Intergovernmental Sources 336 Federal Drug 299- - - - - 1,093 - - - - - - 1,093 160,000 1% 337 State Drug 216 11,910 3,173 - 764 - 9,402 - - - - - - 25,250 35,000 72% 338 Payment in Lieu of Tax various 475,984 475,984 475,984 475,984 475,984 475,984 - - - - - - 2,855,904 5,711,803 50% 339 Contractual Service 211 33,285 2,800 73,688 70,185 14,297 6,255 - - - - - - 200,510 249,000 81% Sub Total 521,179 481,957 549,672 546,933 490,281 492,734 - - - - - - 3,082,757 6,155,803 50% Charge for Service Internal City 340 Liability Insurance 226 183,301 185,290 183,301 189,268 183,301 183,301 - - - - - - 1,107,762 2,223,483 50% 340 General Government Misc Chgs 101/289 35 20 - - - - - - - - - - 55 6,000 1% 340 Police Take Home Vehicle 278 4,470 4,480 4,440 4,430 4,370 4,360 - - - - - - 26,550 60,400 44% 349 Central Service 222 45,449 49,306 55,097 49,813 48,540 48,795 - - - - - - 297,000 760,564 39% 380 Central Service 222 173,853 194,647 195,047 196,211 226,068 213,522 - - - - - - 1,199,348 2,832,181 42% 380 Energy Office Reimbursements 222 338,206 425,619 387,718 342,687 355,964 331,820 - - - - - - 2,182,014 4,589,542 48% 380 Internal Service Reimbursement various 332,216 151,731 95,086 261,942 144,655 90,363 - - - - - - 1,075,992 2,076,445 52% 392 Administration Fee 101/279 357,493 357,917 358,676 358,565 358,996 357,616 - - - - - - 2,149,264 4,323,915 50% 392 Internal Fund Transfers various 3,384,665 2,063,476 950,537 2,621,591 937,936 851,889 - - - - - - 10,810,093 24,446,670 44% 395 Employee Benefits 711 1,380,393 1,364,636 1,389,431 1,404,154 1,395,299 1,386,929 - - - - - - 8,320,843 17,257,182 48% Fin anc i al Re port June 20 16 - Revenue Report Page 3 of 25 City of South Bend Period Ending:June 30, 2016 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,725 1,337 - 3,051 1,775 - - - - - - - 7,888 23,760 33% 396 Self Funded Employee Benefits 711 473 (217) - 140,236 20,511 446,817 - - - - - 607,820 1,000 60782% Sub Total 6,202,279 4,798,241 3,619,332 5,571,947 3,677,416 3,915,414 - - - - - - 27,784,629 58,601,142 47% 3rd Party Revenue 340 ND EMS Service 288- 1,365 - 54,110 - 20,786 - - - - - - 76,261 150,000 51% 340 Memorial Hospital Neo Natal 101 647 47 378 217 249 (1,538) - - - - - - - - NA 350 Job Target Penalty Fee 408- - 354,660 - - - - - - - - - 354,660 354,660 100% 364 Cable TV Franchise Fees 101- 182,827 - - 190,852 - - - - - - - 373,679 720,000 52% 366 AT&T Franchise Fees 101- 70,747 - - 65,898 - - - - - - - 136,645 284,000 48% 393 Sewer Bond Issuance 666- - - - - - - - - - - - - - NA Sub Total 647 254,986 355,038 54,327 256,999 19,248 - - - - - - 941,244 1,508,660 62% Grants 331 Federal Grants various 403,236 157,635 297,708 46,144 151,776 96,645 - - - - - - 1,153,145 8,544,539 13% 332 Solar Energy Grant 222- - - - - - - - - - - - - - NA 334 State Grants various- - 300,000 767,681 - 7,550 - - - - - - 1,075,231 2,624,161 41% Sub Total 403,236 157,635 597,708 813,825 151,776 104,195 - - - - - - 2,228,375 11,168,700 20% Fees for Services External 320 Inspections Central Service 222 10 - - 400 100 190 - - - - - - 700 1,450 48% 321 Business License 101/222 32,554 24,820 20,230 10,462 8,197 5,709 - - - - - - 101,971 118,890 86% 321 Code and Animal Fees 600 5,176 4,450 6,783 3,752 4,533 5,604 - - - - - - 30,297 58,500 52% 322 Building Fees 600 130,183 80,592 79,905 112,379 109,622 112,948 - - - - - - 625,629 1,321,000 47% 322 Code Enforcement Fees 600 1,757 830 2,321 2,455 1,840 1,550 - - - - - - 10,752 3,900 276% 322 EMS Operating Fund 288 1,190 2,555 1,352 1,356 2,055 3,390 - - - - - - 11,898 24,500 49% 322 General Government Fees 101 2,655 1,925 3,015 13,803 3,515 4,535 - - - - - - 29,448 225,000 13% 341 General Government Various various 976 956 9,068 2,129 1,047 2,835 - - - - - - 17,011 27,005 63% 342 Highway & Streets 101/202 18,716 20,087 11,180 56,028 - 51,440 - - - - - - 157,451 281,433 56% 342 Public Safety various 23,010 20,523 14,085 13,039 11,112 10,514 - - - - - - 92,283 145,000 64% 342 EMS - County Fees 288 289,512 144,756 144,756 144,756 144,756 144,756 - - - - - - 1,013,290 1,740,000 58% 342 EMS - Capital Fund 287- 1,307,757 - - - - - - - - - - 1,307,757 2,075,000 63% 342 EMS - Operating Fund 288 139,138 306,076 266,273 233,647 193,550 235,987 - - - - - - 1,374,671 2,700,000 51% 342 EMS - Neo Natal / Transport 288 42,424 41,856 44,710 41,615 45,900 50,910 - - - - - - 267,415 429,512 62% 344 Solid Waste 610 404,906 430,823 441,553 446,119 446,975 527,974 - - - - - - 2,698,349 5,492,249 49% 344 Code Environmental Clean Up 101/219 17,032 19,170 15,674 15,947 17,270 20,894 - - - - - - 105,985 80,000 132% 344 Sewage Waste Water 641 2,955,939 3,016,097 3,151,663 3,169,875 3,269,462 4,127,814 - - - - - - 19,690,849 36,568,100 54% 344 Sewer Repair Insurance 640 52,097 51,842 51,161 51,987 51,750 61,752 - - - - - - 320,590 561,225 57% 344 Water Leak Insurance 620 80,826 80,619 80,821 80,957 82,226 95,542 - - - - - - 500,990 969,960 52% 346 Water Works Utility 620 990,163 1,008,174 1,034,732 1,005,700 1,020,900 1,495,842 - - - - - - 6,555,511 13,453,156 49% 346 Solid Waste Misc 610 565 2,084 1,717 22,521 25,218 34,062 - - - - - - 86,165 100,000 86% 346 Project ReLeaf 655 36,589 36,432 36,616 36,712 36,848 43,582 - - - - - - 226,779 433,290 52% 347 Parks & Recreation various 79,924 101,243 290,639 216,615 287,997 356,118 - - - - - - 1,332,535 3,385,205 39% 347 Sale of Merchandise 101 10 40 30 30 - 20 - - - - - - 130 100 130% 347 Morris PAC 416 5,076 2,700 7,087 4,195 20,270 2,427 - - - - - - 41,755 100,000 42% 349 Parking Garage Fees 601 82,893 80,963 84,467 77,393 94,198 70,609 - - - - - - 490,522 931,812 53% 349 Code Demolition Board Up 219/600 1,095 7,958 23,676 5,554 (2,916) 28,579 - - - - - - 63,945 40,000 160% 349 Parking Century Center 670 8,744 17,522 20,578 3,525 9,972 9,053 - - - - - - 69,394 100,033 69% 349 Parking SBCDA 324/420- - - - - - - - - - - - - - NA 351 Fines & Fees various 235,002 24,915 19,359 13,088 33,758 11,988 - - - - - - 338,111 486,619 69% 352 Forfeits various 2,018 10,760 7,990 4,877 11,115 95,646 - - - - - - 132,405 100,000 132% 354 Ordinance Violation various 1,210 2,514 13,097 2,689 27,101 (3,254) - - - - - - 43,356 45,500 95% 360 Morris PAC various 31,967 25,382 167,961 38,667 145,583 113,944 - - - - - - 523,504 961,000 54% 360 Palais Royale various 6,522 6,401 7,587 11,398 29,700 19,758 - - - - - - 81,366 219,072 37% 360 Parks & Recreation various 9,797 7,359 2,837 5,880 7,740 5,072 - - - - - - 38,685 88,700 44% 360 Police various 3,295 12,706 1,450 6,430 866 18,097 - - - - - - 42,843 27,500 156% 360 Fire various- 9,485 - - - 150 - - - - - - 9,635 - NA 360 TIF various 2,574 1,932 3,647 1,317 4,609 3,558 - - - - - - 17,638 1,294,806 1% 360 Central Services 222 74 - 316 69 - 239 - - - - - - 697 11,000 6% 360 Century Center 670 379 6,169 745 13 350 - - - - - - - 7,655 5,630 136% 360 Dept. Of Community Investment 211/212 9 1,428 1,164 12 - - - - - - - - 2,613 893,648 0% 360 Economic Dev. State Grant 210- - 2,208 - - - - - - - - - 2,208 2,208 100% 360 EMS Operating Fund 288 200 - - 72,825 300 1,413 - - - - - - 74,738 5,000 1495% 360 Engineering / Curb & Sidewalk 101 75 1,901 70 - 350 475 - - - - - - 2,871 78,349 4% 360 Fire and Police Pension Fund 701/702- - - - - 3,080 - - - - - - 3,080 4,000 77% 360 Self Funded Employee Benefits 711- - - - - - - - - - - - - - NA 360 General Government Various 101/3/226 13,698 25 345 332 186 232 - - - - - - 14,817 33,548 44% 360 Motor Vehicle Highway Scrap Metal 202 456 299 747 - 1,180 - - - - - - - 2,682 3,200 84% 360 Motor Vehicle Highway Curb Prgm 202 2,029 1,978 1,419 1,836 1,033 865 - - - - - - 9,160 60,000 15% Fin anc i al Re port June 20 16 - Revenue Report Page 4 of 25 City of South Bend Period Ending:June 30, 2016 Revenue by Type Report $ Fund% Recipient Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget 360 Local Roads and Streets 251- 435 400 117 - - - - - - - - 952 1,200 79% 360 Professional Sports Development 377 24,026 - - - - - - - - - - - 24,026 48,263 50% 360 C.O.I.T.404- - 526 - - - - - - - - - 526 - NA 360 Cumulative Capital Improvement 407- - - - - - - - - - - - - - NA 360 UDAG 410- - - - - - - - - - - - - 169,717 0% 360 Code / Animal Control 600 23 - - 6,646 - - - - - - - - 6,669 500 1334% 360 Building Fees 600- - 17 - - - - - - - - - 17 - NA 360 Parking Garage 601- - - 7 - - - - - - - - 7 - NA 360 Solid Waste Fund 610- - 265 - 153 - - - - - - - 418 2,000 21% 360 Waste Water 641/7/9- 2,332 550 6,454 3,473 2,197 - - - - - - 15,006 52,500 29% 360 Water Works Utility 620- - - 11 23,084 - - - - - - - 23,095 77,000 30% 362 Dept. Of Community Investment 212- 1,847 - 1,847 - - - - - - - - 3,694 8,000 46% 362 Palais Royale 101- 2,069 1,849 7,643 10,881 6,791 - - - - - - 29,233 82,500 35% 362 Police 101 7,363 27,562 - - 7,198 - - - - - - - 42,123 - NA 362 Parks & Recreation 201 1,506 2,558 6,226 3,896 5,331 3,179 - - - - - - 22,696 43,000 53% 362 S Bend School Corp Fee 407- - - - - - - - - - - - - 25,000 0% 362 Certified Technology Park 439- - - - - - - - - - - - - - NA 362 TIF Property various 16,786 16,360 16,697 9,116 17,555 16,652 - - - - - - 93,164 356,098 26% 369 Memorial Hosp Leighton Plaza 408 150,000 - - - - - - - - - - - 150,000 150,000 100% 371 Century Center Fees 670 124,325 373,230 204,013 117,602 254,965 209,879 - - - - - - 1,284,013 2,564,688 50% 399 Bosch Retention Project 210 15,160 - - - 15,274 - - - - - - - 30,434 61,786 49% 399 Principal on Loan various 633 19,550 19,146 19,749 19,552 19,646 - - - - - - 98,276 225,288 44% 399 Principal Income various 146,068 586,589 - - - - - - - - - - 732,657 1,361,350 54% Sub Total 6,198,350 7,958,632 6,324,721 6,105,467 6,507,732 8,034,240 - - - - - - 41,129,141 80,914,990 51% Interest Income 361 Bank Account Interest various 364,372 78,487 115,853 175,196 221,033 185,133 - - - - - - 1,140,074 1,675,283 68% Sub Total 364,372 78,487 115,853 175,196 221,033 185,133 - - - - - - 1,140,074 1,675,283 68% Donations 367 ND Contribution 101- - - - - - - - - - - - - 337,500 0% 367 Donations various- 15 318 100 345 165 - - - - - - 943 367,500 0% Sub Total- 15 318 100 345 165 - - - - - - 943 705,000 0% Historic Preservation 368 Lamppost Program 227- 250 (250) - - - - - - - - - - - NA 368 C.O.I.T.404- - 500 - - 5,110 - - - - - - 5,610 37,500 368 Palais 450- 2,117 298 727 1,110 1,345 - - - - - - 5,596 17,000 33% Sub Total- 2,367 548 727 1,110 6,455 - - - - - - 11,206 54,500 21% Sale of Assets 391 TIF various- - 48,755 6,780 243,237 5,000 - - - - - - 303,771 55,550 547% 391 Property Sales 677- - - 48,709 - - - - - - - - 48,709 48,709 100% 391 Water Hydrant Reimbursement 620- - - - - - - - - - - - - 22,500 0% 391 Proceeds F.A. Disposal 600- - - - - - - - - - - - - 3,000 0% 391 Sale of Fixed Assets various- - - - 22 - - - - - - - 22 17,000 0% 391 Vehicle Damage Reimbursement various- - - 4,971 - - - - - - - - 4,971 5,000 99% Sub Total- - 48,755 60,459 243,259 5,000 - - - - - - 357,473 151,759 236% Revenue Total 17,266,476 16,250,698 14,743,224 16,490,472 20,073,804 64,504,067 - - - - - - 149,328,742 290,692,265 51% report 17,266,476 16,250,697 14,743,225 16,490,472 20,073,804 64,504,068 - - - - - - 149,328,742 290,692,265 (0) 0 (0) - 1 (0) - - - - - - 0 - Fin anc i al Re port June 20 16 - Revenue Report Page 5 of 25 City of South Bend Period Ending:June 30, 2016 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 890,848 998,846 744,957 796,087 985,410 23,897,865 - - - - - - 28,314,015 53,538,549 53% 0101 Mayor 101 160 40 105 105 - 20 - - - - - - 430 600 72% 0104 311 Call Center 101 2,224 1,586 - - - - - - - - 3,810 2,225 171% 0201 Clerk 101- - - - - - - - - - - NA 0301 Common Council 101- - - - - - - - - - - - - 250 0% 0401 Administration and Finance 101 13,548 - - - - 2,493 - - - - - - 16,041 13,598 118% 0501 Legal 101- - - 37,719 - 43 - - - - - - 37,762 50,000 76% Sub Total 904,556 998,886 747,286 835,497 985,410 23,900,422 - - - - - - 28,372,058 53,605,222 53% Public Works 0602 Engineering 101 32,123 1,901 20 - 1,366 475 - - - - - - 35,885 134,449 27% Sub Total 32,123 1,901 20 - 1,366 475 - - - - - - 35,885 134,449 27% Public Safety 0801 Police 101 41,628 60,405 4,103 14,376 21,337 26,673 - - - - - - 168,523 337,700 50% 0901 Fire 101 682 10,102 378 217 249 7,646 - - - - - - 19,274 12,000 161% Sub Total 42,311 70,507 4,481 14,593 21,586 34,319 - - - - - - 187,796 349,700 54% Code Enforcement 1201 Code 101- - - - - - - - - - - NA 1203 Code Hearing 101- - - - - - - - - - - NA 1204 Code Junk Vehicle 101- - - - - - - - - - - NA 1205 Code Unsafe Building 101- - - - (5,961) (726) - - - - - - (6,687) - NA 1207 Code Animal Control 101- - - - - - - - - - - - - - NA xxx xxx- - - - - - - - - - - NA Sub Total- - - - (5,961) (726) - - - - - - (6,687) - NA Arts & Culture 0404 Morris PAC 101 31,617 24,482 165,280 38,247 145,434 113,324 - - - - - - 518,384 950,000 55% 0405 Palais Royale 101 6,762 9,025 10,036 19,597 43,525 28,507 - - - - - - 117,454 324,012 36% xxx xxx- NA Sub Total 38,380 33,507 175,316 57,845 188,959 141,832 - - - - - - 635,838 1,274,012 50% General Fund Revenue Total 1,017,369 1,104,801 927,103 907,934 1,191,361 24,076,322 - - - - - - 29,224,891 55,363,383 53% Financial Report Ju ne 2016 - Re venu e Sum mary Page 6 of 25 City of South Bend Period Ending:June 30, 2016 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 86,846 78,467 78,887 78,950 78,001 4,714,127 - - - - - - 5,115,278 9,391,265 54% 1100 Administration 201 1,508 2,562 6,228 3,901 5,335 3,189 - - - - - - 22,723 43,600 52% 1101 Maintenance 201 6,220 7,757 3,806 24,061 29,277 30,532 - - - - - - 101,652 323,600 31% 1102 Golf Operations 201 983 7,988 144,933 105,695 181,202 205,048 - - - - - - 645,849 1,466,000 44% 1103 Recreation Division 201 21,022 6,327 584 1,430 1,528 24,158 - - - - - - 55,049 168,640 33% 1108 Graffiti Removal 201- - 15,856 - 14,599 7,503 - - - - - - 37,958 99,694 38% Recreation Non Reverting 203 59,146 87,227 144,974 91,318 83,304 101,600 - - - - - - 567,568 1,448,565 39% East Race Waterway 271 2 0 1 1 1 1 - - - - - - 7 30 22% Coveleski Stadium 401 137 30 40 52 33 56 - - - - - - 348 15,200 2% Zoo Endowment 403 82 18 27 42 27 46 - - - - - - 243 200 121% Park Non Reverting 405 925 446 753 1,109 1,154 1,078 - - - - - - 5,465 162,500 3% Sub Total 176,871 190,822 396,090 306,558 394,460 5,087,338 - - - - - - 6,552,139 13,119,294 50% Public Works Motor Vehicle Highway 202 1,148,770 254,903 834,492 1,866,801 551,533 347,166 - - - - - - 5,003,665 9,201,639 54% Central Services 222 561,404 671,636 638,910 593,185 633,048 595,810 - - - - - - 3,693,994 8,234,637 45% Central Services Capital 224 313 68 94 139 89 102 - - - - - - 807 130,519 1% Local Roads & Streets 251 305,371 115,867 97,202 170,056 92,992 105,483 - - - - - - 886,971 1,628,200 54% Project ReLeaf 655 38,110 36,779 37,150 37,561 37,403 44,224 - - - - - - 231,228 437,290 53% Sub Total 2,053,969 1,079,254 1,607,849 2,667,743 1,315,066 1,092,786 - - - - - - 9,816,666 19,632,285 50% Public Works Solid Waste Solid Waste Operations 610 405,999 459,788 443,628 468,863 472,529 562,429 - - - - - - 2,813,237 5,623,574 50% Solid Waste Capital 611 251,011 25 311,000 40 160 196 - - - - - - 562,433 925,397 61% Sub Total 657,011 459,812 754,629 468,904 472,689 562,624 - - - - - - 3,375,669 6,548,971 52% Public Works Water Utility 0000 Water Works Revenues 620 925,034 941,353 967,601 950,561 975,856 1,368,739 - - - - - - 6,129,144 12,624,656 49% 0630 Water Leak Insurance 620 80,826 80,619 80,821 80,957 81,226 95,542 - - - - - - 499,990 969,960 52% 0660 Clay Water 620 73,493 71,779 73,463 73,819 75,270 134,488 - - - - - - 502,311 1,046,000 48% Waterworks Capital 622 4,768 1,055 1,599 2,451 1,573 2,678 - - - - - - 14,124 28,000 50% Waterworks Construction 623- - - - - - - - - - - - - - NA Waterworks Deposit 624 2,502 553 840 1,291 830 1,418 - - - - - - 7,434 15,000 50% Waterworks Sinking 625 171,062 170,519 170,664 170,915 170,870 791 - - - - - - 854,820 2,049,681 42% Waterworks Bond Reserve 626 2,662 589 892 1,380 882 1,496 - - - - - - 7,901 16,000 49% Waterworks Debt Reserve 629 3,696 228,278 1,287 2,091 1,341 2,287 - - - - - - 238,981 175,166 136% Sub Total 1,264,042 1,494,746 1,297,166 1,283,466 1,307,847 1,607,437 - - - - - - 8,254,704 16,924,463 49% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 54,828 52,457 52,097 53,443 52,682 63,336 - - - - - - 328,842 571,241 58% 0000 Wastewater Revenues 641 2,797,138 2,842,869 2,979,437 2,997,625 3,091,630 3,954,090 - - - - - - 18,662,789 34,472,440 54% 0621 Sewer Department 641- - - 1,164 - - - - - - - 1,164 2,500 47% 0625 Concrete Crew 641- 3,786 - 6,781 5,679 3,045 - - - - - - 19,290 74,500 26% 0630 Wastewater Operations 641- - - - - - - - - - - - - - NA 0631 Organic Resources 641- - - - - - - - - - - - - - NA 0650 Clay Sewage 641 176,341 176,890 180,624 183,360 182,446 188,013 - - - - - - 1,087,674 2,162,160 50% Sewage Capital 642 14,620 3,000 4,485 6,773 4,288 7,172 - - - - - - 40,337 2,532,000 2% Sewage Reserve 643 6,083 898,070 2,265 3,885 2,492 4,249 - - - - - - 917,043 552,997 166% Sewer Bond 2007 647- - - - - - - - - - - - - - NA Sewage Bond Sinking 649 762,499 761,612 761,964 763,223 762,852 764,731 - - - - - - 4,576,881 9,274,391 49% Sewer Bond 2007B 651- - - - - - - - - - - - - - NA Sewage Works DS Reserve 653 25 - 612 586 524 - - - - - - - 1,746 1,300 134% 2010 CSO Net Sewer Bond 658- - - - - - - - - - - - - - NA 2011 Sewer Bond 659 384 85 129 197 127 216 - - - - - - 1,138 2,000 57% 2012 Sewer Bond 661 23,078 5,057 7,297 10,735 6,661 11,163 - - - - - - 63,991 70,000 91% 2013A Sewer Refund Bonds 664 7 2 3 4 2 4 - - - - - - 22 40 55% 2015 Sewer Refund Bonds 666 76 5 4 6 4 6 - - - - - - 100 130 77% Sub Total 3,835,079 4,743,833 3,988,916 4,027,781 4,109,385 4,996,025 - - - - - - 25,701,020 49,715,699 52% Financial Report Ju ne 2016 - Re venu e Sum mary Page 7 of 25 City of South Bend Period Ending:June 30, 2016 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 12,241 3,253 119 947 118 9,603 - - - - - - 26,281 36,000 73% Curfew Violations 218 33 54 32 10 19 49 - - - - - - 198 1,000 20% Law Enforcement Education 220 30,704 27,445 27,926 15,784 17,577 16,249 - - - - - - 135,686 218,000 62% Public Safety LOIT 249 567,011 566,039 566,326 566,640 566,310 566,657 - - - - - - 3,398,983 6,797,160 50% Excess Welfare Public Safety 252- - - - - - - - - - - - - - NA Police Take Home Vehicle 278 9,999 9,197 9,243 9,425 9,108 9,356 - - - - - - 56,328 64,400 87% Police Block Grant 280 6 1 2 3 2 4 - - - - - - 19 20 94% Police Grants 292- - - - - - - - - - - - - - NA Police Academy 294 8,566 6,928 1,146 1,473 797 81 - - - - - - 18,992 22,500 84% COPS More Grants 295 1,091 8,214 8,352 15,227 652 882 - - - - - - 34,418 92,000 37% Drug Enforcement 299 94 115 115 116 112 1,209 - - - - - - 1,761 162,000 1% K-9 Unit 705 6 1 2 3 2 4 - - - - - - 19 2,020 1% Sub Total 629,753 621,248 613,264 609,629 594,696 604,093 - - - - - - 3,672,683 7,395,100 50% Public Safety - Fire Emergency Telephone System 244- - - - - - - - - - - - - - NA EMS Capital 287 4,258 1,308,699 1,628 3,273 2,041 3,279 - - - - - - 1,323,178 2,075,500 64% EMS Operating Fund 288 476,961 497,776 458,825 550,849 388,068 459,608 - - - - - - 2,832,087 5,085,012 56% Hazmat 289 53 12 18 27 17 29 - - - - - - 156 10,000 2% River Rescue 291 5,554 11,435 9,956 4,895 21,664 721 - - - - - - 54,225 45,200 120% Sub Total 486,826 1,817,922 470,427 559,044 411,791 463,637 - - - - - - 4,209,646 7,215,712 58% Department of Community Investment Studebaker/Oliver 209 6,330 405 27,904 11,414 600 30,612 - - - - - - 77,265 587,250 13% State Grant 210 18,038 - 2,208 767,681 18,003 7,550 - - - - - - 813,480 2,699,880 30% DCI Operating 211 527,096 5,114 194,422 563,271 17,109 7,695 - - - - - - 1,314,706 2,651,425 50% 0000 Dept. of Community Investment 212 279,099 153,909 152,736 39,258 151,233 68,150 - - - - - - 844,385 7,444,900 11% xxx Programs 212- - - - - - - - - - - - - - NA 0000 Economic Revenue Bond 281 45 10 15 23 15 26 - - - - - - 134 150 89% Sub Total 830,609 159,437 377,285 1,381,648 186,959 114,032 - - - - - - 3,049,970 13,383,605 23% Parking Garages 0000 Parking Garage Revenue 601 849 - 45 - 77 45 - - - - - - 1,016 4,165 24% 0460 Main Street 601 20,681 17,090 26,345 24,194 29,496 20,281 - - - - - - 138,086 252,867 55% 0462 Leighton Plaza 601 40,901 48,496 33,149 34,823 43,002 32,822 - - - - - - 233,193 436,491 53% 0463 Enforcement 601 4,502 6,302 6,389 5,566 5,862 7,270 - - - - - - 35,891 121,500 30% 0464 Wayne Street 601 21,191 15,197 24,344 18,247 21,610 18,097 - - - - - - 118,686 233,748 51% 0465 Eddy Street Commons 601- - - - - - - - - - - - 15,900 0% Sub Total 88,124 87,084 90,272 82,831 100,046 78,515 - - - - - - 526,871 1,064,671 49% Capital / Debt Service Hall of Fame 313 9,343 9,343 9,343 9,343 9,343 787,685 - - - - - - 834,400 1,483,212 56% COIT 404 998,628 836,789 838,012 848,996 837,567 846,216 - - - - - - 5,206,206 10,370,484 50% Cum Capital Development 406 5,335 4,594 4,679 4,818 4,648 263,405 - - - - - - 287,480 527,737 54% Cum Capital Improvement 407 150,502 144 154 236 151 121,753 - - - - - - 272,941 435,700 63% EDIT 408 965,781 803,193 1,159,172 808,449 805,261 809,187 - - - - - - 5,351,045 10,159,262 53% UDAG 410 1,139 196 269 412 265 452 - - - - - - 2,733 175,827 2% Major Moves 412 3,574 587,379 1,223 65,617 58,775 2,286 - - - - - - 718,855 1,111,733 65% Morris PAC Improvement 416 5,931 2,891 7,376 4,634 20,552 2,923 - - - - - - 44,306 103,000 43% CRED 434 45 56 56 58 57 59 - - - - - - 330 - NA Palais Historic Preservation 450 126 2,145 341 794 1,153 1,420 - - - - - - 5,979 17,450 34% Hall of Fame Capital 677 833 184 271 49,118 271 485 - - - - - - 51,161 53,809 95% xxx xxx xxx- - - - - - - - - - - NA Sub Total 2,141,238 2,246,913 2,020,896 1,792,475 1,738,043 2,835,870 - - - - - - 12,775,435 24,438,214 52% Financial Report Ju ne 2016 - Re venu e Sum mary Page 8 of 25 City of South Bend Period Ending:June 30, 2016 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 14,388 3,184 4,825 7,397 1,410,597 9,026 - - - - - - 1,449,419 1,445,850 100% Excess Levy 103 6 1 - - - - - - - - - - 7 20 37% Gift, Donation, Bequest 217 107 39 354 155 381 226 - - - - - - 1,262 360,800 0% Unsafe Building 219 360,372 37,823 47,700 26,838 55,310 90,628 - - - - - 618,670 985,240 63% Loss Recovery 227 1,648 614 300 841 530 904 - - - - - - 4,837 7,660 63% LOIT 2016 Special Distribution 257- - - - 4,217,549 - - - - - - - 4,217,549 4,867,550 87% Human Rights 258 121,580 3,921 6,077 8,070 411 671 - - - - - - 140,730 165,040 85% Morris Palais Marketing 273 400 911 2,912 1,178 1,426 1,649 - - - - - - 8,476 18,250 46% 311 Call Center 279 38,778 39,201 39,960 39,849 40,281 38,900 - - - - - - 236,969 499,358 47% Professional Sports Development 377 173,741 47,553 64,832 42,802 110,670 42,808 - - - - - - 482,406 711,518 68% 1201 Code Enforcement 600 373,225 2,746 20,597 11,522 7,069 53,992 - - - - - - 469,151 1,500,600 31% 1207 Animal Control 600 162,540 4,450 6,783 3,752 4,585 5,604 - - - - - - 187,714 688,368 27% 1306 Building Operations 600 134,531 81,290 81,139 114,090 110,657 114,630 - - - - - - 636,336 1,329,000 48% Century Center 670 790,173 396,920 225,335 121,140 265,287 218,932 - - - - - - 2,017,787 3,983,787 51% Century Center Capital 671 85 79 85 82 82 76 - - - - - - 489 500 98% Century Center Energy Saving 672 4 4 4 4 107,725 79,680 - - - - - - 187,422 237,418 79% Sub Total 2,171,578 618,737 500,902 377,720 6,332,560 657,727 - - - - - - 10,659,224 16,800,959 63% Business Insurance 0000 Business Insurance Revenues 226 190,814 186,949 185,820 193,181 185,876 187,786 - - - - - - 1,130,427 2,243,983 50% 0418 Workers Compensation 226- 12,878 - - - 737 - - - - - 13,615 12,900 106% Sub Total 190,814 199,828 185,820 193,181 185,876 188,523 - - - - - - 1,144,042 2,256,883 51% Fiduciary Trust & Agency Fire Pension 701 929 131 - - - 2,437,715 - - - - - - 2,438,776 4,870,771 50% Police Pension 702 2,088 374 311 - - 2,997,375 - - - - - - 3,000,148 6,000,250 50% Employee Benefits 711 1,388,795 1,364,497 1,390,952 1,536,588 1,406,479 1,829,415 - - - - - - 8,916,727 17,176,345 52% Unemployment Comp 713 445 1,837 1,311 12,303 12,190 12,662 - - - - - - 40,748 107,282 38% City Cemetery Trust 730 47 10 16 24 16 27 - - - - - - 140 150 93% Sub Total 1,392,305 1,366,849 1,392,590 1,548,915 1,418,684 7,277,194 - - - - - - 14,396,538 28,154,798 51% Civil City Revenues 16,935,586 16,191,286 14,623,209 16,207,829 19,759,465 49,642,123 - - - - - - 133,359,498 262,014,037 51% Tax Increment Financing TIF River West - Airport 324 62,565 39,097 92,026 257,011 285,004 9,826,825 - - - - - - 10,562,528 19,268,864 55% TIF Central Development 420- - - - - - - - - - - - - - NA TIF West Washington 422 2,477 552 836 1,278 819 284,205 - - - - - - 290,167 435,500 67% TIF Leighton Plaza 425 11,420 10,732 13,574 3,711 15,392 13,502 - - - - - - 68,332 172,703 40% TIF Medical Service 426- - - - - - - - - - - - - - NA TIF River East DEV (NE)429 12,505 2,739 4,151 6,361 4,077 1,177,923 - - - - - - 1,207,755 2,807,000 43% TIF Southside 430 9,942 2,233 3,363 5,017 3,168 1,256,789 - - - - - - 1,280,511 2,433,000 53% TIF Erskine Village 432 8,776 1,827 2,741 4,202 2,697 4,601 - - - - - - 24,843 25,000 99% TIF Douglas Road 435 234 56 28 10 7 231,300 - - - - - - 231,634 320,750 72% TIF River East RES (NE RE)436 213,108 - - - - 2,061,402 - - - - - - 2,274,510 3,162,422 72% Sub Total 321,026 57,236 116,718 277,590 311,164 14,856,547 - - - - - - 15,940,281 28,625,239 56% Financial Report Ju ne 2016 - Re venu e Sum mary Page 9 of 25 City of South Bend Period Ending:June 30, 2016 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 14 3 5 7 5 8 - - - - - - 43 152 28% Certified Technology Park 439 3,792 833 1,262 1,935 1,174 1,986 - - - - - - 10,981 14,637 75% Airport Urban Enterprise Zone 454 628 139 211 323 207 354 - - - - - - 1,862 3,900 48% Sub Total 4,435 975 1,478 2,265 1,386 2,348 - - - - - - 12,887 18,689 69% Debt Service Airport Debt Reserve 2003 315 1,718 380 576 882 566 965 - - - - - - 5,086 14,000 36% Coveleski Bond Debt Reserve 317 841 186 282 432 277 473 - - - - - - 2,491 5,300 47% Central Development reserve 328 2,870 635 962 1,474 945 1,612 - - - - - - 8,498 15,000 57% Sub Total 5,429 1,201 1,820 2,788 1,789 3,050 - - - - - - 16,076 34,300 47% Redevelopment Commission 330,890 59,411 120,016 282,643 314,339 14,861,945 - - - - - - 15,969,243 28,678,228 56% City Operations Total 17,266,476 16,250,697 14,743,225 16,490,472 20,073,803 64,504,068 - - - - - - 149,328,742 290,692,265 51% Revenue report 17,266,476 16,250,697 14,743,225 16,490,472 20,073,804 64,504,068 0 0 0 0 0 0 149,328,742 290,692,265 0 0 0 0(1)0 0 0 0 0 0 0(0)0 Financial Report Ju ne 2016 - Re venu e Sum mary Page 10 of 25 City of South Bend Period Ending:June 30, 2016 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 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City General Fund 101- 0.95 - 21,490,881.50 - - - 21,490,881.50 (21,490,881.50) #DIV/0! Parks & Recreation 201- 0.95 - 4,312,625.82 - - - 4,312,625.82 (4,312,625.82) #DIV/0! College Football Hall of Fame 313- 0.95 - 744,229.93 - - - 744,229.93 (744,229.93) #DIV/0! Cumulative Capital District 406- 0.95 - 240,589.67 - - - 240,589.67 (240,589.67) #DIV/0! Fire Pension 701- 0.95 - - - - - - - - Police Pension 702- 0.95 - - - - - - - - Total - City- - 26,788,326.92 - - - 26,788,326.92 (26,788,326.92) #DIV/0! Tax Increment Financing Airport TIF District 324- 0.95 - 9,769,452.30 - - - 9,769,452.30 (9,769,452.30) #DIV/0! South Bend Central TIF District 420- 0.95 - - - - - - - - West Washington TIF District 422- 0.95 - 282,809.66 - - - 282,809.66 (282,809.66) #DIV/0! Central Medical TIF District 426- 0.95 - - - - - - - - Northeast Residential TIF District 436- 0.95 - 2,061,402.42 - - - 2,061,402.42 (2,061,402.42) #DIV/0! Southside TIF District #1 430- 0.95 - 1,251,613.66 - - - 1,251,613.66 (1,251,613.66) #DIV/0! Erskine Commons TIF District #2 431- 0.95 - - - - - - - - Erskine Village TIF District #3 432- 0.95 - - - - - - - 100.00% Douglas Road TIF District 435- 0.95 - 231,288.93 - - - 231,288.93 (231,288.93) #DIV/0! Northeast TIF 429- 0.95 - 1,170,979.07 - - - 1,170,979.07 (1,170,979.07) #DIV/0! Airport Urban Enterprise Zone 454- 0.95 - - - - - - - - Other xxx- - - - - - Total - Tax Increment Financing- - 14,767,546.04 - - - 14,767,546.04 (14,767,546.04) #DIV/0! Grand Total- - 41,555,872.96 - - - 41,555,872.96 (41,555,872.96) #DIV/0! Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6/14/16 Financial Report June 2016 - Property Tax Revenue Page 11 of 25 City of South Bend Period Ending:June 30, 2016 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 Financial Report June 2016 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending:June 30, 2016 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget General Government 0101 Mayor 101 62,117 48,772 50,030 46,449 48,335 47,667 - - - - - - 303,369 749,883 40% 0104 311 Call Center 101- 1,629 595 1,586 - - - - - - - - 3,810 5,933 64% 0201 Clerk 101 31,055 31,491 37,749 26,701 32,713 31,544 - - - - - - 191,254 443,475 43% 0301 Common Council 101 41,543 59,981 33,221 24,897 32,488 37,464 - - - - - - 229,593 522,735 44% 0302 WNIT Contract 101- - - 43,000 - - - - - - - - 43,000 43,000 100% 0401 Administration and Finance 101 130,914 141,679 128,874 123,875 153,924 136,469 - - - - - - 815,736 2,227,488 37% 0501 Legal Department 101 75,713 76,476 78,779 76,637 77,517 76,398 - - - - - - 461,519 1,036,772 45% Sub Total 341,342 360,028 329,247 343,146 344,977 329,542 - - - - - - 2,048,282 5,029,286 41% Public Works 0602 Engineering 101 60,668 91,788 89,283 80,759 85,036 92,517 - - - - - - 500,050 1,225,137 41% Sub Total 60,668 91,788 89,283 80,759 85,036 92,517 - - - - - - 500,050 1,225,137 41% Public Safety 0801 Police 101 1,839,872 1,836,378 1,935,878 1,851,538 1,928,033 2,039,599 - - - - - - 11,431,298 26,399,474 43% 0805 Police -PS LOIT funded 101- - - - - - - - - - - - - - NA 0802 Police Communications 101- - 369,753 123,251 123,251 123,251 - - - - - - 739,506 1,479,012 50% 0901 Fire 101 1,349,693 1,406,545 1,437,795 1,551,497 1,471,613 1,515,308 - - - - - - 8,732,452 18,210,989 48% 0905 Fire-PS LOIT funded 101- - - - - - - - - - - - - - NA Sub Total 3,189,565 3,242,923 3,743,426 3,526,286 3,522,897 3,678,158 - - - - - - 20,903,256 46,089,475 45% Code Enforcement 1201 Code 101 202,164 - - - - - - - - - - 202,164 202,164 100% Sub Total 202,164 - - - - - - - - - - - 202,164 202,164 100% Arts & Culture 0404 Morris PAC 101 75,543 84,588 92,842 72,255 89,432 74,463 - - - - - - 489,124 1,129,897 43% 0405 Palais Royale 101 36,586 48,725 38,176 29,957 37,155 39,288 - - - - - - 229,887 498,438 46% Sub Total 112,129 133,313 131,018 102,212 126,588 113,751 - - - - - - 719,011 1,628,335 44% Human Rights 1008 Human Rights 101 27,794 31,288 25,632 28,106 23,375 26,740 - - - - - - 162,935 371,226 44% Sub Total 27,794 31,288 25,632 28,106 23,375 26,740 - - - - - - 162,935 371,226 44% General Fund Expenditure Total 3,933,663 3,859,340 4,318,606 4,080,508 4,102,872 4,240,708 - - - - - - 24,535,697 54,545,623 45% Financial Report Ju ne 2016 - Expenditure Summary Page 13 of 25 City of South Bend Period Ending:June 30, 2016 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Parks & Recreation 1100 Administration 201 120,329 83,287 83,490 77,779 88,065 81,333 - - - - - - 534,283 1,056,714 51% 1101 Maintenance 201 368,679 389,966 441,134 343,837 406,986 491,137 - - - - - - 2,441,738 5,285,910 46% 1102 Golf Operations 201 49,757 92,103 89,804 120,631 199,079 162,933 - - - - - - 714,307 1,703,202 42% 1103 Recreation Division 201 154,760 162,409 147,645 158,818 152,871 163,301 - - - - - - 939,803 2,362,980 40% 1104 Potawatomi Zoo 201 5,034 5,339 405,050 5,383 4,946 5,247 - - - - - - 431,000 800,352 54% 1106 Potawatomi Greenhouse 201 783 6,648 3,813 16,965 1,673 598 - - - - - - 30,481 54,408 56% 1108 Graffiti Removal 201 8,180 7,676 7,468 7,131 7,503 7,762 - - - - - - 45,720 99,893 46% Recreation Non Reverting 203 34,956 57,650 69,287 61,600 144,795 98,576 - - - - - - 466,864 1,459,754 32% East Race Waterway 271- - - - - - - - - - - - - - NA Coveleski Stadium 401- 22,000 - - - - - - - - - - 22,000 22,000 100% Zoo Endowment 403- - - - - - - - - - - - - 49,000 0% Park Non Reverting 405- - 1,948 4,094 46,292 37,406 - - - - - - 89,740 268,333 33% Sub Total 742,479 827,079 1,249,640 796,237 1,052,209 1,048,293 - - - - - - 5,715,936 13,162,546 43% Public Works Motor Vehicle Highway 202 711,071 666,780 853,357 492,279 523,049 443,229 - - - - - - 3,689,765 9,216,413 40% Curb and Sidewalk 202 63,314 46,745 43,357 31,186 198,087 63,460 - - - - - - 446,149 1,760,996 25% Central Services 222 544,400 631,085 646,405 528,846 634,188 515,033 - - - - - - 3,499,958 8,306,979 42% Central Services Capital 224- 23,369 - - 112,077 15,173 - - - - - - 150,619 305,584 49% Local Roads & Streets 251 76,979 139,680 75,028 38,810 109,173 228,846 - - - - - - 668,518 2,242,944 30% Project ReLeaf 655 14,595 2,629 2,937 378,442 2,928 3,295 - - - - - - 404,824 528,358 77% Sub Total 1,410,360 1,510,289 1,621,083 1,469,563 1,579,502 1,269,035 - - - - - - 8,859,832 22,361,274 40% Public Works Solid Waste Solid Waste Operations 610 658,357 359,794 375,760 335,581 380,928 395,728 - - - - - - 2,506,147 5,597,412 45% Solid Waste Capital 611 250,879 236 11,143 83,883 20,064 11,080 - - - - - - 377,286 925,197 41% Sub Total 909,235 360,030 386,903 419,464 400,992 406,808 - - - - - - 2,883,433 6,522,609 44% Public Works Water Utility 0630 Water Leak Insurance 620 466 82,211 37,746 67,227 85,909 92,046 - - - - - - 365,605 1,010,000 36% 0640 Water Works 620 1,055,327 1,445,433 1,071,284 1,047,483 1,167,937 993,681 - - - - - - 6,781,146 16,034,157 42% 0660 Clay Water 620 51 - - - (0) (24) - - - - - - 26 3,500 1% Waterworks Capital 622- - - 6,750 - - - - - - - - 6,750 821,797 1% Waterworks Deposit 624 534 553 840 1,291 830 1,418 - - - - - - 5,466 8,400 65% Waterworks Sinking 625 551 14 159 410 365 347,055 - - - - - - 348,553 2,049,681 17% Waterworks Bond Reserve 626- - 2,050 - - - - - - - - - 2,050 9,500 22% Waterworks Debt Reserve 629 790 817 1,287 2,091 1,341 2,287 - - - - - - 8,614 10,000 86% Sub Total 1,057,719 1,529,028 1,113,367 1,125,253 1,256,382 1,436,462 - - - - - - 7,518,211 19,947,035 38% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 32,598 24,473 51,533 51,541 60,773 31,368 - - - - - - 252,286 549,413 46% 0621 Sewer Repair 641 365,864 307,474 341,407 345,729 437,696 432,810 - - - - - - 2,230,981 7,709,744 29% 0625 Concrete Crew 641 24,761 26,568 27,942 21,841 21,367 26,265 - - - - - - 148,744 455,797 33% 0630 Wastewater Operations 641 2,056,393 2,751,269 1,840,284 1,856,140 1,994,573 2,077,685 - - - - - - 12,576,344 30,546,550 41% 0631 Organic Resources 641 94,619 52,239 67,433 75,509 107,520 61,790 - - - - - - 459,111 1,384,847 33% 0650 Clay Sewage 641 220 - - 88 25 (42) - - - - - - 291 500 58% Sewage Capital 642 635,043 53,387 150,821 130,215 126,925 373,826 - - - - - - 1,470,218 7,631,946 19% Sewage Reserve 643 1,301 1,345 2,265 3,885 2,492 4,249 - - - - - - 15,536 16,000 97% Sewage Bond Sinking 649 1,350 500 - 750 1,145,856 - - - - - - - 1,148,456 9,274,298 12% 2011 Sewer Bond 659- - - - - - - - - - - - - 172,088 0% 2012 Sewer Bond 661 118,335 1,143,403 445,588 92,338 284,179 1,430,384 - - - - - - 3,514,228 20,187,062 17% 2015 Sewer Bond 666 2,500 - - - - - - - - - - 2,500 2,500 100% Sub Total 3,332,985 4,360,659 2,927,274 2,578,037 4,181,406 4,438,335 - - - - - - 21,818,696 77,930,745 28% Financial Report Ju ne 2016 - Expenditure Summary Page 14 of 25 City of South Bend Period Ending:June 30, 2016 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 16,882 35,846 13,572 11,028 22,588 96,409 - - - - - - 196,325 743,508 26% Emergency Telephone System 244- - - - - - - - - - - - - - NA Public Safety LOIT 249 521,395 492,883 513,715 500,885 519,490 556,228 - - - - - - 3,104,597 6,600,626 47% Excess Welfare Public Safety 252- - - - - - - - - - - - - 8 0% LOIT 2016 Special Distribution 257- - - - - - - - - - - - - 850,000 0% Police Take Home Vehicle 278 53 - - - - - - - - - - - 53 10,000 1% Police Grants 292 6,713 5,925 6,188 12,138 1,001 1,275 - - - - - - 33,239 55,373 60% Police Academy 294 251 50 280 986 632 1,263 - - - - - - 3,462 22,500 15% COPS More Grants 295 707 4,039 1,923 4,520 16,748 - - - - - - - 27,937 102,245 27% Drug Enforcement 299- 1,290 10,752 - - - - - - - - - 12,042 168,965 7% K-9 Unit 705- - - - - - - - - - - - 2,020 0% Sub Total 546,001 540,033 546,430 529,557 560,459 655,175 - - - - - - 3,377,654 8,592,245 39% Public Safety - Fire EMS Capital 287- - 152,919 - 432,134 411,578 - - - - - - 996,631 2,727,611 37% EMS Operating Fund 288 582,267 370,131 374,778 355,722 529,369 547,074 - - - - - - 2,759,342 6,140,643 45% Hazmat 289- - - 1,170 - - - - - - - - 1,170 10,000 12% River Rescue 291 1,200 1,311 3,610 271 6,280 5,444 - - - - - - 18,115 95,300 19% xxx xxx xxx- - - - - - - - - - - - - NA Sub Total 583,467 371,442 531,308 357,163 967,783 964,096 - - - - - - 3,775,259 8,973,554 42% Department of Community Investment Studebaker/Oliver 209 4,500 18,732 19,040 - 27,101 20,476 - - - - - - 89,849 1,683,250 5% State Grant 210 858,470 604,022 31,790 - - 18,003 - - - - - - 1,512,284 2,522,519 60% DCI Operating 211 193,791 183,367 177,764 177,360 207,513 184,292 - - - - - - 1,124,087 2,687,313 42% 1001 Dept. of Community Investment 212 219,263 153,095 172,309 105,228 77,082 92,772 - - - - - - 819,750 7,353,228 11% 1003 Administration 212- - - - - - - - - - - - - 4,235 0% xxx Programs 212- - - - (2,297) - - - - - - - (2,297) - NA Sub Total 1,276,023 959,216 400,902 282,589 309,399 315,543 - - - - - - 3,543,673 14,250,545 25% Parking Garages 0400 General Administration 601- - - - - - - - - - - - - 250,000 0% 0460 Main Street 601 26,730 908 24,914 12,853 12,270 11,178 - - - - - - 88,854 235,033 38% 0462 Leighton Plaza 601 44,392 2,288 47,457 25,257 24,656 25,386 - - - - - - 169,435 557,047 30% 0463 Enforcement 601 14,403 487 17,211 8,161 7,371 8,408 - - - - - - 56,041 97,844 57% 0464 Wayne Street 601 26,189 2,240 22,306 15,098 13,212 17,984 - - - - - - 97,029 237,645 41% 0465 Eddy Street Commons 601- - - - - - - - - - - - - 15,900 0% Sub Total 111,714 5,924 111,888 61,368 57,510 62,955 - - - - - - 411,359 1,393,469 30% Capital / Debt Service Hall of Fame 313 636,000 - - - - - - - - - - - 636,000 1,268,015 50% COIT 404 2,195,646 702,384 853,652 959,871 842,370 1,142,904 - - - - - - 6,696,826 15,191,448 44% Cum Capital Development 406 112,650 - 56,546 - 135,726 56,546 - - - - - - 361,467 526,737 69% Cum Capital Improvement 407 184,125 - - - - - - - - - - - 184,125 365,907 50% EDIT 408 2,192,756 59,872 169,782 1,123,043 80,832 99,244 - - - - - - 3,725,529 10,560,181 35% UDAG 410 146,068 - - - - - - - - - - - 146,068 238,173 61% Major Moves 412 110 312,495 38,870 34,165 146,498 58,844 - - - - - - 590,982 2,385,033 25% Morris PAC Improvement 416- 10,464 2,467 4,978 315 1,599 - - - - - - 19,824 78,923 25% CRED 434- - - - - - - - - - - - - - NA Palais Historic Preservation 450- - - - - - - - - - - - - 16,150 0% Hall of Fame Capital 677 4,658 15,819 6,938 2,373 3,043 2,787 - - - - - - 35,618 84,801 42% Sub Total 5,472,013 1,101,034 1,128,255 2,124,429 1,208,785 1,361,924 - - - - - - 12,396,439 30,715,368 40% Financial Report Ju ne 2016 - Expenditure Summary Page 15 of 25 City of South Bend Period Ending:June 30, 2016 Expenditure Report $ % Fund Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year Budget of Budget Other Miscellaneous Excess Levy 103- 3,648 - - - - - - - - - 3,648 3,688 99% Gift, Donation, Bequest 217- - - - - - - - - - - - - 362,500 0% Unsafe Building 219- 14,797 20,481 139,794 108,516 69,479 - - - - - - 353,068 926,497 38% Loss Recovery 227 8 3,200 20,008 - - - - - - - - - 23,216 480,311 5% Human Rights 258 12,916 12,344 11,301 11,621 20,577 14,350 - - - - - - 83,109 221,838 37% Morris Palais Marketing 273- - - - 2,457 - - - - - - - 2,457 18,878 13% 311 Call Center 279 38,778 39,201 40,140 39,669 40,281 38,900 - - - - - 236,969 499,357 47% Professional Sports Development 377 472,288 800 - - - - - - - - - - 473,088 838,052 56% 1201 Code Enforcement 600 134,860 98,504 97,400 114,564 138,852 132,188 - - - - - - 716,367 1,583,657 45% 1207 Animal Control 600 50,246 54,812 60,621 51,121 46,642 48,492 - - - - - - 311,934 729,330 43% 1209 Illegal Dumping Crew 600 35,125 41,910 40,652 (95,755) (21,931) - - - - - - - (0) - NA 1306 Building Operations 600 82,944 83,613 78,238 76,319 82,958 87,413 - - - - - - 491,485 1,211,490 41% Century Center 670 329,357 310,741 316,542 286,177 370,652 491,964 - - - - - - 2,105,433 3,972,438 53% Century Center Capital 671- - 38,747 - 56,406 - - - - - - 95,153 188,621 50% Century Center Energy Saving 672- - - 140,609 - - - - - - - 140,609 237,132 59% Sub Total 1,156,521 663,569 685,384 802,866 789,002 939,192 - - - - - - 5,036,535 11,273,789 45% Business Insurance 0403 Self Funded Liability Ins 226 17,058 14,315 14,138 13,343 15,017 11,494 - - - - - - 85,365 237,860 36% 0412 Liability Insurance 226 13,955 19,262 32,319 18,246 132,533 15,813 - - - - - - 232,128 1,383,363 17% 0417 Business Insurance 226 17,445 - 14,854 - 6,579 407,689 - - - - - - 446,568 647,125 69% 0418 Workers Compensation 226 48,983 203,070 39,908 25,926 17,412 45,053 - - - - - - 380,351 852,000 45% Sub Total 97,441 236,647 101,220 57,515 171,540 480,049 - - - - - - 1,144,412 3,120,348 37% Fiduciary Trust & Agency Fire Pension 701 427,167 402,025 407,173 524,845 414,901 534,598 - - - - - - 2,710,710 5,464,843 50% Police Pension 702 516,452 528,448 651,745 520,019 520,015 517,495 - - - - - - 3,254,174 6,797,398 48% Employee Benefits 711 634,312 1,803,358 1,576,792 1,282,480 1,326,426 1,793,912 - - - - - - 8,417,280 17,378,890 48% Unemployment Comp 713 1,487 7,828 5,252 4,339 10,387 2,955 - - - - - - 32,248 113,882 28% City Cemetery Trust 730- - - - - - - - - - - - 20,000 0% Sub Total 1,579,417 2,741,659 2,640,962 2,331,683 2,271,731 2,848,961 - - - - - - 14,414,413 29,775,013 48% Civil City Expenditure 22,209,039 19,065,949 17,763,220 17,016,232 18,909,572 20,467,536 - - - - - - 115,431,548 302,564,163 38% Tax Increment Financing TIF River West - Airport 324 4,064,434 1,454,126 1,749,039 554,649 907,744 551,962 - - - - - - 9,281,953 44,502,077 21% TIF West Washington 422 3,366 3,461 2,195 1,350 550 - - - - - - 10,922 1,403,366 1% TIF Leighton Plaza 425 4,481 4,849 6,656 8,004 6,436 41,531 - - - - - - 71,956 160,406 45% TIF River East DEV (NE)429 81,910 3,701 12,236 - 35,949 326,459 - - - - - - 460,255 8,335,159 6% TIF Southside 430 280 153,970 142,775 1,590 421,414 89,625 - - - - - - 809,654 7,411,815 11% TIF Erskine Village 432 365,835 - - - - - - - - - - - 365,835 490,503 75% TIF Douglas Road 435- 140,000 - - - - - - - - - - 140,000 354,200 40% TIF River East RES (NE RE)436 1,237,500 446,589 - - - - - - - - - - 1,684,089 3,430,000 49% Sub Total 5,754,441 2,206,601 1,914,167 566,437 1,372,892 1,010,126 - - - - - - 12,824,664 66,087,526 19% Financial Report Ju ne 2016 - Expenditure Summary Page 16 of 25 City of South Bend Period Ending:June 30, 2016 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- - 142,913 - - - - - - - - - 142,913 2,692,913 5% Airport Urban Enterprise Zone 454- - - - - - - - - - - - - 50,000 0% Sub Total- - 142,913 - - - - - - - - - 142,913 2,747,413 5% Debt Service Airport Debt Reserve 2003 315 367 380 576 882 566 965 - - - - - - 3,736 14,000 27% Central Development reserve 328 614 635 962 1,474 945 1,612 - - - - - - 6,242 15,000 42% Sub Total 981 1,015 1,538 2,356 1,511 2,577 - - - - - - 9,977 29,000 34% Redevelopment Commission 5,755,422 2,207,615 2,058,618 568,794 1,374,403 1,012,703 - - - - - - 12,977,554 68,863,939 19% City Operations Total 27,964,461 21,273,564 19,821,838 17,585,025 20,283,975 21,480,239 - - - - - - 128,409,103 370,397,682 35% Expenditure report 27,964,461 21,273,564 19,821,838 17,585,025 20,283,975 21,480,239 0 0 0 0 0 0 128,409,103 370,397,682 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report Ju ne 2016 - Expenditure Summary Page 17 of 25 City of South Bend Period Ending:June 30, 2016 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2016 Princip al 2016 Inter est 2016 Debt a t 2016 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 15 Paym ents Payme nt Addit ion 12/31/20 16 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 1,265,000.00 8 35,000.00 49,030.00 0.00 430,000.00 884,03 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 3,315,000.00 5 60,000.00 113,226.00 0.00 2,755,000.00 673,22 6.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,745,000.00 3 65,000.00 54,900.00 0.00 2,380,000.00 419,90 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 10,085,000.00 1,2 00,000.00 365,560.00 0.00 8,885,000.00 1,565,56 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 3,090,000.00 2 20,000.00 137,800.00 0.00 2,870,000.00 357,80 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,465,000.00 2 90,000.00 97,612.50 0.00 3,175,000.00 387,61 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,555,000.00 2 30,000.00 250,978.00 0.00 4,325,000.00 480,97 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,407,675.00 1 58,032.00 67,656.00 0.00 2,249,643.00 225,68 8.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,530,000.00 3 85,000.00 314,017.50 0.00 7,145,000.00 699,01 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 18,175,000.00 8 80,000.00 680,700.00 0.00 17,295,000.00 1,560,70 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 7,275,000.00 3 50,000.00 216,786.26 0.00 6,925,000.00 566,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 21,935,000.00 1,0 45,000.00 507,580.00 0.00 20,890,000.00 1,552,58 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 9,970,000.00 1,9 20,000.00 193,418.00 0.00 8,050,000.00 2,113,41 8.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,365,000.00 2 20,000.00 184,155.00 0.00 5,145,000.00 404,15 5.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 0.00 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,167,897.00 22,585.00 213,546.84 0.00 4,145,312.00 236,13 1.84 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,505,000.00 2 10,000.00 178,631.26 0.00 5,295,000.00 388,63 1.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 27,440,000.00 2,4 75,000.00 538,128.89 0.00 24,965,000.00 3,013,12 8.89 xxx Total Bond Debt 2 31,577,59 3.50 140,677,079.92 11,3 65,617.00 4,163,726.25 0.00 129,311,462.92 15,529,34 3.25 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 352,793.00 20,231.00 11,889.12 0.00 332,562.00 32,12 0.12 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,589,770.50 2 38,172.75 0.00 0.00 1,351,597.75 238,17 2.75 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 698,431.00 1 67,193.00 20,254.00 0.00 531,238.00 187,44 7.00 xxx Total Loans Pa yable 29,822,33 2.00 2,640,994.50 4 25,596.75 32,143.12 0.00 2,215,397.75 457,73 9.87 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 380,582.65 1 86,262.63 14,317.03 0.00 194,320.02 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 215,915.15 2 15,915.15 1,567.54 0.00 0.00 217,48 2.69 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 32,195.78 32,195.78 268.39 0.00 0.00 32,46 4.17 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 437.96 437.96 7.40 0.00 0.00 44 5.36 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 288,182.13 2 88,182.13 7,217.28 0.00 0.00 295,39 9.41 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 570.81 571.81 17.67 1.00 0.00 58 9.48 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 44,305.79 44,305.79 355.45 0.00 0.00 44,66 1.24 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 400,372.65 2 65,787.43 5,663.85 0.00 134,585.22 271,45 1.28 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 291,194.81 1 93,401.30 3,657.54 0.00 97,793.51 197,05 8.84 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 1,143,200.82 5 67,884.27 13,067.06 0.00 575,316.55 580,95 1.33 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 1,997.49 1,240.72 81.20 0.00 756.77 1,32 1.92 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 2,099.54 1,172.86 97.94 0.00 926.68 1,27 0.80 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 1,586.46 770.64 69.12 0.00 815.82 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 2,383.09 1,157.16 113.64 0.00 1,225.93 1,27 0.80 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 2,395.32 1,162.59 108.21 0.00 1,232.73 1,27 0.80 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 6,948.65 3,373.56 313.68 0.00 3,575.09 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 1,027,650.03 3 38,392.15 11,508.38 0.00 689,257.88 349,90 0.53 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 4,716.87 2,257.61 334.39 0.00 2,459.26 2,59 2.00 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly 4,09 3.64 2,323.16 831.39 107.61 0.00 1,491.77 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 918,109.86 3 01,217.97 13,363.17 0.00 616,891.89 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 5,386.95 2,307.59 263.65 0.00 3,079.36 2,57 1.24 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 6,123.92 1,929.78 290.22 0.00 4,194.14 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 3,573.98 1,125.87 169.53 0.00 2,448.11 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,995.07 943.45 142.07 0.00 2,051.62 1,08 5.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,995.07 943.45 142.07 0.00 2,051.62 1,08 5.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,918.30 841.86 142.14 0.00 2,076.44 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,579,597.27 3 85,800.22 22,996.32 0.00 1,193,797.05 408,79 6.54 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 94,725.09 31,199.46 3,624.89 0.00 63,525.63 34,82 4.35 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 2,854.47 907.46 113.02 0.00 1,947.01 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 4,154.42 1,359.12 136.92 0.00 2,795.30 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 2,759.48 841.49 115.63 0.00 1,917.99 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 1,009.77 303.72 33.12 0.00 706.05 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 4,315.81 1,013.49 216.15 0.00 3,302.32 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 6,583.31 1,706.32 325.50 0.00 4,876.99 2,03 1.82 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 8,934.98 2,376.82 440.18 0.00 6,558.16 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 3,071.37 939.12 146.40 0.00 2,132.25 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 16,169.83 4,315.69 716.87 0.00 11,854.14 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 4,566.75 974.87 240.97 0.00 3,591.88 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 124,125.01 29,414.39 5,490.01 0.00 94,710.62 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 3,425,273.58 6 61,428.23 51,237.13 0.00 2,763,845.35 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,825.33 664.27 117.17 0.00 2,161.06 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,267,183.00 2 45,327.64 19,067.24 0.00 1,021,855.36 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 4,219.84 765.12 221.52 0.00 3,454.72 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 0.00 3,857.81 1,086.03 32,5 25.00 28,667.19 4,94 3.84 14 8 Cen tral Services Lanier C opier C 6502 Copier 201 6 20 20 22 2 Monthly--11,41 3.00 0.00 1,353.69 381.11 11,4 13.00 10,059.31 1,73 4.80 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 0.00 3 23,345.83 25,350.98 3,3 39,8 30.00 3,016,484.17 348,69 6.81 15 0 HP Computer Lease C opier L ease 201 6 20 20 Various Monthly--17,43 9.85 0.00 3,425.86 683.74 17,4 39.85 14,013.99 4,10 9.60 15 1 Admin and Finance R ic oh Copier C opier L ease 201 6 20 21 10 1 Monthly--10,92 3.63 0.00 1,985.36 519.88 10,9 23.63 8,938.27 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 0.00 0.00 0.00 3,9 92,5 48.72 3,992,548.72 0.00 xxx T otal Cap ital L ease 28,718,86 9.52 11,343,531.62 4,1 57,918.88 206,647.01 7,4 04,6 81.20 14,590,293.94 4,364,56 5.89 To tal Civ i l C i ty 2 90,118,79 5.02 154,661,606.04 15,9 49,132.63 4,402,516.38 7,4 04,6 81.20 146,117,154.61 20,351,64 9.01 Fi nanci a l R e p or t June 2 0 1 6 - De b t Page 1 8 o f 25 City of South Bend Period Ending:June 30, 2016 Debt Schedule Year of Year of Year o f Sche du led Payme nts De bt (Or ig / Re fi)Debt at 2016 Princip al 2016 Inter est 2016 Debt a t 2016 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 15 Paym ents Payme nt Addit ion 12/31/20 16 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 1,180,000.00 4 60,000.00 27,875.00 0.00 720,000.00 487,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 3,010,000.00 1,1 80,000.00 88,015.00 0.00 1,830,000.00 1,268,01 5.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 1,510,000.00 9 95,000.00 50,600.00 0.00 515,000.00 1,045,60 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,615,000.00 4 05,000.00 78,450.00 0.00 2,210,000.00 483,45 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 13,760,000.00 1,2 60,000.00 655,958.00 0.00 12,500,000.00 1,915,95 8.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,845,000.00 7 20,000.00 373,987.50 0.00 7,125,000.00 1,093,98 7.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 4,035,000.00 2 35,000.00 254,502.50 0.00 3,800,000.00 489,50 2.50 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 31,450,000.00 1,3 75,000.00 1,095,929.43 0.00 30,075,000.00 2,470,92 9.43 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 2,295,000.00 6 30,000.00 107,251.25 0.00 1,665,000.00 737,25 1.25 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 300,000.00 1 00,000.00 0.00 0.00 200,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 0.00 0.00 0.00 25,000,000.00 0.00 xxx Total Bond Debt 1 53,788,78 8.00 93,000,000.00 7,3 60,000.00 2,732,568.68 0.00 85,640,000.00 10,092,56 8.68 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 363,854.70 61,785.55 10,224.89 0.00 302,069.15 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 100,557.56 0.00 0.00 0.00 83,482.06 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 635,520.00 2 51,327.00 28,673.00 0.00 384,193.00 280,00 0.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,422,330.30 92,756.87 27,985.13 0.00 1,329,573.43 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 3,013,862.52 6 29,514.66 142,921.34 0.00 2,384,347.86 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 500,000.00 1 00,000.00 0.00 0.00 400,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 0.00 2 32,695.31 17,304.69 7 50,0 00.00 517,304.69 250,00 0.00 xxx Total Loans Pa yable 15,627,49 9.06 6,036,125.08 1,3 68,079.39 227,109.05 7 50,0 00.00 5,400,970.19 1,595,18 8.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,558,918.00 1 23,580.00 76,420.00 0.00 1,435,338.00 200,00 0.00 xxx Tot al Lease 5,510,27 8.00 1,558,918.00 1 23,580.00 76,420.00 0.00 1,435,338.00 200,00 0.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 100,595,043.08 8,8 51,659.39 3,036,097.73 7 50,0 00.00 92,476,308.19 11,887,75 7.12 To tal Debt 4 65,045,36 0.08 255,256,649.12 24,8 00,792.02 7,438,614.11 8,1 54,6 81.20 238,593,462.80 32,239,40 6.13 Fi nanci a l R e p or t June 2 0 1 6 - De b t Page 1 9 o f 25 City of South Bend Period Ending:June 30, 2016 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 15 Paym ents Pay ments Ad ditions 6/3 0/2016 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 1,265,000.00 4 10,000.00 29,265.00 0.00 855,000.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 3,315,000.00 2 80,000.00 58,713.00 0.00 3,035,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,745,000.00 0.00 0.00 0.00 2,745,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 10,085,000.00 5 95,000.00 188,730.00 0.00 9,490,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 3,090,000.00 0.00 0.00 0.00 3,090,000.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,465,000.00 2 90,000.00 51,706.25 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,555,000.00 0.00 0.00 0.00 4,555,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,407,675.00 0.00 33,828.00 0.00 2,407,675.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,530,000.00 0.00 157,008.75 0.00 7,530,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 18,175,000.00 0.00 340,350.00 0.00 18,175,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 7,275,000.00 0.00 0.00 0.00 7,275,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 21,935,000.00 0.00 253,790.00 0.00 21,935,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 9,970,000.00 0.00 96,709.00 0.00 9,970,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,365,000.00 2 20,000.00 93,727.50 0.00 5,145,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,167,897.00 0.00 140,608.64 0.00 4,167,897.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,505,000.00 1 00,000.00 90,040.00 0.00 5,405,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 27,440,000.00 0.00 263,728.89 0.00 27,440,000.00 xxx Total Bond Debt 2 31,577,59 3.50 140,677,079.92 1,8 95,000.00 1,798,205.03 0.00 138,782,079.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 352,793.00 0.00 0.00 0.00 352,793.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,589,770.50 1 46,067.50 0.00 0.00 1,443,703.00 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 698,431.00 0.00 0.00 0.00 698,431.00 xxx Total Loans Pa yable 29,822,33 2.00 2,640,994.50 1 46,067.50 0.00 0.00 2,494,927.00 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 380,582.65 92,145.36 8,144.47 0.00 288,437.29 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 215,915.15 2 15,915.17 1,567.53 0.00(0.02) 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 32,195.78 21,419.23 223.55 0.00 10,776.55 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 437.96 436.97 7.45 0.00 0.99 9 2 Key Finance IT Phone S ystem 201 1 20 16 40 4 1/15 1,444,99 5.97 288,182.13 2 88,182.13 7,217.28 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 570.81 281.40 12.84 0.00 289.41 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 44,305.79 44,305.79 355.45 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 400,372.65 1 32,333.05 3,392.59 0.00 268,039.60 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 291,194.81 96,338.18 2,191.24 0.00 194,856.63 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 1,143,200.82 2 83,019.14 7,456.53 0.00 860,181.68 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 1,997.49 611.60 49.36 0.00 1,385.89 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 2,099.54 577.87 57.53 0.00 1,521.67 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 1,586.46 385.55 34.33 0.00 1,200.91 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 2,383.09 570.23 65.17 0.00 1,812.86 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 2,395.32 581.65 42.13 0.00 1,813.67 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 6,948.65 1,687.81 122.13 0.00 5,260.84 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 1,027,650.03 1 68,681.59 6,268.67 0.00 858,968.44 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 4,716.87 1,104.78 191.22 0.00 3,612.09 11 2 Ricoh U SA Bu ildin g Dept. Co pi er 201 3 20 18 60 0 Monthly--4,09 3.64 2,323.16 409.96 59.54 0.00 1,913.20 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 918,109.86 1 50,014.55 7,276.02 0.00 768,095.31 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 5,386.95 1,137.14 148.48 0.00 4,249.81 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 6,123.92 951.58 158.42 0.00 5,172.34 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 3,573.98 555.16 92.54 0.00 3,018.82 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,995.07 465.22 77.54 0.00 2,529.85 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,995.07 465.22 77.54 0.00 2,529.85 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,918.30 415.04 76.96 0.00 2,503.26 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,579,597.27 1 92,155.45 12,242.82 0.00 1,387,441.82 12 5 HP Computer Lease #1 C omputer Equipment Le ase 201 4 20 18 various Monthly 8th--137,10 4.95 94,725.09 15,424.55 1,987.63 0.00 79,300.54 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 2,854.47 448.49 61.75 0.00 2,405.98 12 7 HP Computer Lease #4 C omputer Equipment Le ase 201 4 20 18 40 4 Monthly 8th--5,88 6.15 4,154.42 672.98 75.04 0.00 3,481.44 12 8 HP Computer Lease #6 C omputer Equipment Le ase 201 4 20 18 20 1 Monthly 8th--3,75 5.50 2,759.48 415.63 62.93 0.00 2,343.85 12 9 HP Computer Lease #7 C omputer Equipment Le ase 201 4 20 18 62 0 Monthly 8th--1,32 6.00 1,009.77 150.42 18.00 0.00 859.35 13 0 Solid Waste C opier R icoh US A C opier 201 4 20 19 61 1 Monthly 17th--5,35 1.65 4,315.81 499.66 115.16 0.00 3,816.15 13 1 Police Com munications Copier R icoh US A C opier 201 4 20 19 10 1 Monthly 12th--8,84 3.00 6,583.31 841.25 174.67 0.00 5,742.06 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 8,934.98 1,171.80 236.70 0.00 7,763.18 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 3,071.37 463.08 79.68 0.00 2,608.29 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 16,169.83 2,130.69 385.59 0.00 14,039.14 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 4,566.75 480.34 127.58 0.00 4,086.41 13 8 HP Computer Lease #9 C omputer Equipment Le ase 201 5 20 19 Various Monthly TBD--135,95 8.05 124,125.01 14,525.33 2,926.87 0.00 109,599.68 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 3,425,273.58 3 26,552.80 29,779.88 0.00 3,098,720.78 14 3 HP Computer Lease #11 C omputer Equipment Le ase 201 5 20 19 40 4 Monthly 3,04 0.00 2,825.33 328.29 62.43 0.00 2,497.04 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,267,183.00 1 21,948.51 10,248.93 0.00 1,145,234.49 14 6 Park s & Rec reation Copier R icoh Copier 201 6 20 20 20 1 Monthly 4,30 2.06 4,219.84 459.33 116.21 0.00 3,760.51 14 7 Cen tral Services Lanier C opier C 5100 5 Copier 201 6 20 20 22 2 Monthly---32,52 5.00 0.00 951.79 284.17 32,5 25.00 31,573.21 14 8 Cen tral Services Lanier C opier C 6502 201 6 20 20 22 2 Monthly---11,41 3.00 0.00 333.98 99.72 11,4 13.00 11,079.02 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 0.00 0.00 0.00 3,3 39,8 30.00 3,339,830.00 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 0.00 1,538.98 329.02 17,4 39.85 15,900.87 15 1 Admin and Finance R ic oh Copier MPC800 2S P Copier 201 6 20 21 10 1 Monthly---10,92 3.63 0.00 1,004.80 247.82 10,9 23.63 9,918.83 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 0.00 0.00 0.00 3,9 92,5 48.72 3,992,548.72 xxx T otal Cap ital L ease 28,718,86 9.52 11,343,531.62 2,1 85,489.52 105,029.11 7,4 04,6 80.20 16,562,722.30 To tal Civ i l C i ty 2 90,118,79 5.02 154,661,606.04 4,2 26,557.02 1,903,234.14 7,4 04,6 80.20 157,839,729.22 Fi nanci a l R e p or t June 2 0 1 6 - De b t Page 2 0 o f 25 City of South Bend Period Ending:June 30, 2016 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 15 Paym ents Pay ments Ad ditions 6/3 0/2016 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 1,180,000.00 2 30,000.00 15,375.00 0.00 950,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 3,010,000.00 5 85,000.00 47,956.25 0.00 2,425,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 1,510,000.00 4 90,000.00 30,200.00 0.00 1,020,000.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,615,000.00 0.00 0.00 0.00 2,615,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 13,760,000.00 6 25,000.00 334,979.00 0.00 13,135,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,845,000.00 3 55,000.00 190,969.75 0.00 7,490,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 4,035,000.00 2 35,000.00 130,835.00 0.00 3,800,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 31,450,000.00 7 25,000.00 510,426.30 0.00 30,725,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 2,295,000.00 3 15,000.00 57,287.50 0.00 1,980,000.00 12 2 Synagogue at Coveleski Improvements C oveleski S tadium 201 4 20 18 37 7 1/31 500,00 0.00 300,000.00 0.00 0.00 0.00 300,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 0.00 0.00 25,000,000.00 xxx Total Bond Debt 1 53,788,78 8.00 93,000,000.00 3,5 60,000.00 1,318,028.80 0.00 89,440,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 363,854.70 30,661.95 5,343.27 0.00 333,192.75 4 In di ana Development Finance Autho rity Bos c h P roperty (Forgive)200 1 20 21 21 0----260,00 0.00 100,557.56 0.00 0.00 0.00 83,984.86 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 635,520.00 1 24,112.00 15,888.00 0.00 511,408.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,422,330.30 46,147.70 0.00 0.00 1,376,182.60 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 3,013,862.52 3 10,871.44 0.00 0.00 2,702,991.08 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 500,000.00 0.00 0.00 0.00 500,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 0.00 0.00 0.00 7 50,0 00.00 0.00 xxx Total Loans Pa yable 15,627,49 9.06 6,036,125.08 5 11,793.09 21,231.27 7 50,0 00.00 5,507,759.29 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,558,918.00 61,027.00 38,973.00 0.00 1,497,891.00 xxx Tot al Lease 5,510,27 8.00 1,558,918.00 61,027.00 38,973.00 0.00 1,497,891.00 Tot al Red evelop ment Commiss ion 1 74,926,56 5.06 100,595,043.08 4,1 32,820.09 1,378,233.07 7 50,0 00.00 96,445,650.29 To tal Debt 4 65,045,36 0.08 255,256,649.12 8,3 59,377.11 3,281,467.21 8,1 54,6 80.20 254,285,379.51 Fi nanci a l R e p or t June 2 0 1 6 - De b t 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,102 1,078 1087 1082 1079 1078 1072 0 0 0 0 0 0 Part Time Staff 122 115 115 137 135 114 0 0 0 0 0 0 Temporary / Seasonal 97 94 94 117 160 236 0 0 0 0 0 0 City Total 1,297 1296 1291 1333 1373 1422 0 0 0 0 0 0 Financial Report June 2016 - 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 7 6 6 6 6 6 0 0 0 0 0 0 311 Call Center 6 7 7 6 6 6 6 0 0 0 0 0 0 Admin & Finance 23 19 20 21 21 22 23 0 0 0 0 0 0 Innovation/ Technology Office 4 4 4 4 4 4 4 0 0 0 0 0 0 Safety & Risk 2 2 2 2 2 2 2 0 0 0 0 0 0 Clerk 5 5 5 5 5 5 5 0 0 0 0 0 0 Common Council 9 9 9 9 9 9 9 0 0 0 0 0 0 Legal Department 11 11 11 11 11 11 11 0 0 0 0 0 0 Sub Total 67 64 64 64 64 65 66 0 0 0 0 0 0 Code Enf. /Animal Control 24 24 24 24 24 24 24 0 0 0 0 0 0 Dept. of Community Investment 25 24 22 22 22 22 24 0 0 0 0 0 0 Parks & Recreation Administration 10 10 10 10 10 10 11 0 0 0 0 0 0 Maintenance 44 42 43 44 44 44 43 0 0 0 0 0 0 Golf Operations 10 7 7 7 8 8 8 0 0 0 0 0 0 Recreation Ops 25 25 25 25 24 25 25 0 0 0 0 0 0 Zoological Ops 1 1 1 1 1 1 1 0 0 0 0 0 0 Graffiti Removal 1 1 1 1 1 1 1 0 0 0 0 0 0 Recreation Non-reverting 1 1 1 1 1 1 1 0 0 0 0 0 0 Sub Total 91 87 88 89 89 90 90 0 0 0 0 0 0 Public Safety Police 306 299 304 299 297 296 292 0 0 0 0 0 0 Fire 258 261 259 258 254 254 251 0 0 0 0 0 0 Sub Total 564 560 563 557 551 550 543 0 0 0 0 0 0 Public Works Central Services 37 33 33 34 34 34 32 0 0 0 0 0 0 Office of Sustainability 2 1 1 1 1 1 1 0 0 0 0 0 0 Engineering 18 16 18 18 17 16 18 0 0 0 0 0 0 Maintenance 3 3 3 3 3 3 3 0 0 0 0 0 0 Solid Waste Operations 26 25 25 24 25 25 24 0 0 0 0 0 0 Code Clean Crew 4 4 4 4 4 4 4 0 0 0 0 0 0 Street Operations 58 56 58 58 58 58 58 0 0 0 0 0 0 Sewer Operations 31 30 30 32 32 32 32 0 0 0 0 0 0 Waste Water Ops 44 44 45 44 45 45 45 0 0 0 0 0 0 Organic Resources 6 6 6 6 6 6 6 0 0 0 0 0 0 Water Utility Ops 68 68 70 69 69 69 68 0 0 0 0 0 0 Sub Total 297 286 293 293 294 293 291 0 0 0 0 0 0 Building Department 14 13 12 13 14 13 14 0 0 0 0 0 0 Human Rights 6 6 6 6 6 6 6 0 0 0 0 0 0 Morris & Palais 14 14 15 14 15 15 14 0 0 0 0 0 0 City Total 1,102 1,078 1,087 1,082 1,079 1,078 1,072 - - - - - 0 Financial Report June 2016 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1 1 1 1 1 1 0 0 0 0 0 0 311 Call Center 1 1 1 2 2 2 0 0 0 0 0 0 Admin & Finance 1 1 1 1 2 1 0 0 0 0 0 0 Innovation/ Technology Office 0 0 0 0 0 1 0 0 0 0 0 0 Clerk 0 0 0 0 0 0 0 0 0 0 0 0 Common Council 0 0 0 0 0 0 0 0 0 0 0 0 Legal Department 1 1 1 1 1 1 0 0 0 0 0 0 Sub Total 4 4 4 5 6 6 0 0 0 0 0 0 Code Enf. / Animal Control 2 2 2 2 2 2 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 6 6 6 6 4 3 0 0 0 0 0 0 Maintenance 7 6 6 9 10 11 0 0 0 0 0 0 Golf Operations 18 18 18 32 32 41 0 0 0 0 0 0 Recreation Ops 38 39 39 41 40 33 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 69 63 63 82 82 85 0 0 0 0 0 0 Public Safety Police 30 28 28 29 27 3 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 30 28 28 29 27 3 0 0 0 0 0 0 Public Works` Central Services 1 1 1 1 1 1 0 0 0 0 0 0 Engineering 2 2 2 2 2 2 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 4 4 4 4 4 4 0 0 0 0 0 0 Sewer Ops 2 2 2 4 3 3 0 0 0 0 0 0 Waste Water Ops 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 4 4 4 3 3 3 0 0 0 0 0 0 Sub Total 13 13 13 14 13 13 0 0 0 0 0 0 Building Department 0 0 0 0 0 0 0 0 0 0 0 0 Human Rights 0 1 1 1 1 1 0 0 0 0 0 0 Morris & Palais 4 4 4 4 4 4 0 0 0 0 0 0 City Total 122 115 115 137 135 114 0 0 0 0 0 0 Financial Report June 2016 - 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 0 0 0 1 0 2 0 0 0 0 0 0 Safety and Risk 0 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 0 0 0 1 0 2 0 0 0 0 0 0 Code Enfor. / Animal 2 2 1 2 2 1 0 0 0 0 0 0 Dept. of Community Investment 0 0 1 0 0 0 0 0 0 0 0 0 Parks & Recreation Administration 6 5 4 4 3 2 0 0 0 0 0 0 Maintenance 4 3 7 20 31 39 0 0 0 0 0 0 Golf Operations 8 7 14 15 12 13 0 0 0 0 0 0 Recreation Ops 50 50 43 49 83 137 0 0 0 0 0 0 Zoological Ops 0 0 0 0 0 0 0 0 0 0 0 0 Graffiti Removal 1 1 1 1 1 1 0 0 0 0 0 0 Sub Total 69 66 69 89 130 192 0 0 0 0 0 0 Public Safety Police 14 14 13 12 0 14 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 14 14 13 12 0 14 0 0 0 0 0 0 Public Works Central Services 0 0 0 0 0 1 0 0 0 0 0 0 Engineering 8 4 4 4 12 12 0 0 0 0 0 0 Energy / Sustainability 0 3 3 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 3 3 0 0 0 0 0 0 Street Ops 2 3 2 3 4 4 0 0 0 0 0 0 Sewer Ops 2 2 1 3 4 4 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 0 0 2 1 0 0 0 0 0 0 Organic Resources 0 0 0 0 0 0 0 0 0 0 0 0 Water Utility Ops 0 0 0 0 2 2 0 0 0 0 0 0 Sub Total 12 12 10 13 27 27 0 0 0 0 0 0 Building Department 0 0 0 0 1 0 0 0 0 0 0 0 Human Rights 0 0 0 0 0 0 0 0 0 0 0 0 Morris & Palais 0 0 0 0 0 0 0 0 0 0 0 0 City Total 97 94 94 117 160 236 0 0 0 0 0 0 Financial Report June 2016 - Headcount Staffing Page 25 of 25