Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
05-2015 Financial Report
Period Ending: Issued By: May 31, 2015 Controller 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 Chief of Staff Deputy Chief of Staff Controller Deputy Controller City Finance Director Sr. Budget Analyst Department Heads Fiscal Officers City Common Council Pete Buttigieg Kathryn Roos Brian Pawlowski John Murphy Jennifer Hockenhull Rahman Johnson Cecil Eastman Financial Report May 2015 Page 1 of 25 May 31, 2015 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as, the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). Revenue by type For discussion on property taxes, see section listed below. The overall percentage of budgeted revenues that have been received by the city is 29 %. The overall percentage of collected revenue amount for May 2014 was 25 %. 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. Revenue type 350 (Penalty Fee), has also reached 100% of its budgeted revenue. This is money from AJ Wright for penalties due to the City. Revenue by fund As of May 31, 2015, the general fund has received 10% of its budgeted revenue, similar to last year. The following funds have reached slightly above the normal percentage of their 2015 budgeted revenue amount at this time: Funds 249, 404, and 408 received their distributions on time this month. Fund 294 (Police Academy). This is tuition revenue related to the advancement of present and future police officers. Fund 289 (Hazmat). This fund has reached 139% of its budgeted revenue. This is revenue generated by the South Bend fire department responding to hazardous materials incidents. Fund 643 (Sewage Reserve), is at 105% or $12,593 over its budgeted revenue. This is due to a transfer of $256,085 from fund 641 (Sewage Works Operations) for reserve purposes. Fund 439 (Certified Technology Park), is at 267% or $7,338 over its budgeted revenue. This is revenue from bank and investment interest. Property taxes Property taxes are received in June and December. Property taxes collected for the year 2014 totaled -$72 million. Civil city funds received -$45 million and TIF funds received - $27 million. For 2014, the projected levy collection rate is 95% or $72.1 million. Please note, 2014 Civil City funds are $352,000 lower than 2013 budget and TIF funds are -$1.3 million less than 2013 budget. Total property taxes collected for the year 2013 was $69.8 million or 90.18 %. Specifically, in 2013 the City of South Bend received a total of $45,189,966 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,790,321 in property tax revenue. Expenditures As of May 2015, the City has spent 30% of budgeted expenditures, compared to 29% of budgeted expenditures in May 2014. The General Fund has spent 41% of its 2015 budgeted expenditures, versus 39% in 2014. The following funds have reached 50% or more of their budgeted expenditures as a result of bond payments: Fund 313 (Hall of Fame), Fund 407 (Cumulative Capital Improvement), Fund 377 (Professional Sports Development), Fund 432 (TIF - Erskine Village), and Fund 436 (Northeast Residential TIF). This month, Funds 420 and 426 had higher expenditures as money was transferred to Fund 324 (River West - Airport). This is a result of the TIF realignment. Debt In May 2015, several debt service payments were made in the amount of - $527,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. Headcount The Full Time Headcount as of May 2015 was 1,073 vs. a budgeted amount of 1,094. Currently, there are a total of 21 vacant positions. The 21 open positions are in the following departments: Public Safety (7), Public Works (8), Code Enforcement / Animal Control (1), Parks Recreation (2) and other (3). * In Public Safety (Fire), the headcount is over budget as there are currently three recruits in training to replace planned and unplanned departures. If you have any questions regarding this report, please contact John Murphy at (574) 235 -7678. Financial Report May 2015 Page 2 of 25 City of South Bend Period Ending: May 31, 2015 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I f Bud et Property Tax ,to Excise Tax various 2,508,752 mmercial Vehicle Tax 311 Pro a Tax Civil Ci various 883,438 tel Motel Tax Century Center 670 656,725 656,725 1,313, 436 45,606,508 0% 311 Pro a Tax T/FDgstricts various tel Motel Tax Century Center 420 _ _ _ _ _ _ _ _ _ _ _ _ _ _ tel Motel Tax Cum Cap Impm 24,514,604 0% Sub Total b Total 656,725 292,000 948,725 5,346,126 453,318 453,318 70,121,112 0% Income Tax 439 13,183 11,261 14,750 69,400 8,480 _ NA 315 Econ Development Income Tax 408 765,101 765,101 1,463,758 748,490 3,742,449 8,981,877 42% 316 Local Option Income Tax -PS 249 538,849 538,849 1,077,698 538,849 2,694,246 6,466,190 42% 316 County Option Income Tax 404 738,326 738,326 1,476,652 738,326 3,691,630 8,859,912 42% Sub Total 101 2,042,276 2,042,276 4,018,108 2,025,665 10,128,325 24,307,979 42% ;ounty (Remitted by) ,to Excise Tax various 2,508,752 mmercial Vehicle Tax various 434 883,438 tel Motel Tax Century Center 670 656,725 656,725 1,313, 436 tel Motel Tax Century Center 324 292,000 292,000 490,500 tel Motel Tax Century Center 420 _ _ _ _ _ _ _ _ _ _ _ _ _ _ tel Motel Tax Cum Cap Impm 407 0% 150,000 b Total 656,725 292,000 948,725 5,346,126 State of Indiana Remitted b 312 CRED Tax 434 1,729 226 31,642 12, 460 17,914 650,000 0% 335 Cigarette Tax 1011407 41% 340 810 1017289 317,818 0% 335 State Pension Subsidy 7011702 453,318 453,318 453,318 453,318 453,318 11,557,092 0% 335 CTP Distribution 439 13,183 11,261 14,750 69,400 8,480 _ NA 335 Gaming Proceeds 101 62,282 48,246 51,834 52,953 267,205 600,000 0% 335 Gasoline Tax 2021251 348,926 369,636 422,676 426,523 435,833 2,003,594 4,647,000 43% 335 Liquor Excise tax 101 41,349 Energy Office Reimbursements 222 383,538 41,349 65,000 64% 335 Liquor Gallonage Tax 101 67,259 44% 30,798 Internal Service Reimbursement 98,057 200,000 49% 335 ProfSports Development Tax 377 63,326 142,874 63,470 35,855 29,251 334,776 610,000 55% 335 Wheel Tax 202 418,779 67,941 392,533 215,701 1,094,954 2,050,000 53% Sub Total various 939,639 512,510 554,087 885,709 680,785 3,572,730 20,696,910 17% governmental Sources deral Drug 299 1,729 226 31,642 12, 460 17,914 63,744 75,000 vte Drug 216 41% 340 810 1017289 810 35,000 yment in Lieu of Tax various 453,318 453,318 453,318 453,318 453,318 2,266,590 5,439,810 ntractual Service 211 13,183 11,261 14,750 69,400 8,480 117,074 243,000 nds various 62,282 48,246 51,834 52,953 267,205 798,302 33% b Total Central Service 468,230 464,579 500,519 535,178 479,712 2,448,218 5,792,810 Charge for Service Internal City 340 Liability Insurance 226 99,293 101,897 101,897 104,502 99,293 506,882 1,222,727 41% 340 General Government Misc Ch s 1017289 50 50 6,000 1% 340 Police Take Home Vehicle 278 7,060 4,680 4,670 4,640 4,590 25,640 61,100 42% 349 Central Service 222 51,890 62,282 48,246 51,834 52,953 267,205 798,302 33% 380 Central Service 222 199,523 201,656 208,098 203,681 214,579 1,027,537 2,800,655 37% 380 Energy Office Reimbursements 222 383,538 417,794 450,403 363,667 331,109 1,946,511 4,471,200 44% 380 Internal Service Reimbursement various 114,099 125,201 140,744 220,036 141,034 741,113 2,853,931 26% 392 Administration Fee 101 303,580 303,580 303,580 303,580 303,580 1,517,898 3,642,953 42% 392 Internal Fund Transfers various 966,983 3,518,478 7,340,433 1,062,256 6,327,336 19,215,485 34,257,476 562L 395 Employee Benefits 711 1,234,237 1,233,503 1,224,809 1,216,576 1,207,904 6,117,028 16,540,996 37% Financial Report May 2015 - Revenue Report Page 3 025 City of South Bend Period Ending: May 31, 2015 Revenue by Type Report S Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I of Bud et 396 Central Service Refunds 222 2,968 1,971 1,970 1,742 8,651 22,000 39� 396 Self Funded Employee Benefits 711 13,173 13,173 13,000 101 Sub Total 3,373,375 5,972,039 9,824,850 3,532,789 8,684,121 31,387,173 66,690,340 47� ,d Party Revenue 340 No EMS Service 101 222 11,080 4,675 39,099 54,853 150,000 371, 340 Memorial Hospital Neo Natal 101 10,022 56,678 36,788 10,545 10,231 124,263 13,394 N/ 350 Job Target Penalty Fee 408 83% 321 Code and Animal Fees 600 354,660 354,660 354,660 100 364 Cable TV Franchise Fees 101 177,167 41% 322 Buildin Fees 183,970 361,137 700,000 52� 366 AT &T Franchise Fees 101 69,037 1,083,832 57% 69,608 138,644 276,000 50� Sub Total 500 10,022 302,882 47,868 15,220 657,567 1,033,558 1,480,660 70� rants 331 Federal Grants various 321,650 121,681 172,179 326,005 247,506 1,189,022 5,535,445 21� 334 State Grants various 3,600,000 0� Sub Total 321,650 121,681 172,179 326,005 247,506 1,189,022 9,135,445 13`, Fees for Services External 320 Inspections Central Service 222 330 490 10 830 1,400 59% 321 Business License 1011222 31,966 22,740 20,630 13,394 8,091 96,821 117,340 83% 321 Code and Animal Fees 600 3,725 4,795 5,793 6,503 3,595 24,411 59,850 41% 322 Buildin Fees 600 65,509 54,764 181,309 96,256 225,069 622,906 1,083,832 57% 322 Code Enforcement Fees 600 150 450 1,500 500 50 2,650 NA 322 EMS O erating Fund 288 2,233 2,460 1,295 2,375 2,046 10,409 24,500 42% 322 General Government Fees 101 6,640 725 1,030 2,430 2,115 12,940 10,000 129% 341 General Government Various various 1,736 1,940 1,164 1,602 4,952 11,394 27,405 42% 342 Highway &Streets 1011202 24,377 9,564 2,090 80,755 116,786 390,000 30% 342 Public Safety various 22,350 26,067 13,071 12,281 10,209 83,978 130,000 65% 342 EMS - Count Fees 288 426,728 142,243 142,243 711,213 1,667,565 43% 342 EMS - Capital Fund 287 396,727 396,727 NA 342 EMS - Operating Fund 288 198,675 156,466 226,551 290,112 249,516 1,121,320 2,900,000 39% 342 EMS - Neo Natal 288 385,000 0% 344 Solid Waste 610 401,357 397,131 400,073 405,112 406,770 2,010,444 5,091,168 39% 344 Code Environmental Clean Up 101 1600 11,215 1,263 1,051 27,629 4,609 45,767 50,000 92% 344 Sewage Waste Water 641 2,776,091 2,783,483 2,821,111 2,926,251 2,971,386 14,278,322 35,234,467 41% 344 Sewer Repair Insurance 640 50,523 52,458 49,781 51,388 49,827 253,977 548,000 46% 344 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 395,321 960,000 41% 346 Water Works Utility 620 979,733 976,299 965,088 992,620 1,024,608 4,938,349 13,678,403 36% 346 Solid Waste Misc 610 5,075 4,623 6,710 97,941 7,710 122,058 128,148 95% 346 Project ReLeaf 655 36,473 36,203 36,396 36,456 36,590 182,118 429,000 42% 347 Parks & Recreation various 88,374 165,687 152,152 218,148 248,263 872,624 3,565,575 24% 347 Blackthorn Golf Club 619 99,156 20,083 0 59 119,297 1,696,879 7% 347 Morris PAC 416 7,870 1,419 9,761 3,266 8,253 30,569 100,000 31% 349 Parking Garage Fees 601 77,130 56,458 83,412 67,492 90,594 375,085 973,926 39% 349 Code Demolition Board Up 1011600 2,932 9,994 467 12,513 11,595 37,501 20,000 188% 349 Parking Century Center 670 8,435 17,329 24,852 7,896 7,058 65,570 162,000 40% 349 Parking SBCDA 3241420 2,950 2,981 4,246 3,885 14,061 17,000 83% 351 Fines &Fees various 21,684 35,187 12,331 11,314 27,382 107,898 481,720 22% 352 Forfeits various 3,455 875 2,775 4,570 2,352 14,027 258,820 5% 354 Ordinance Violation various 1,305 2,165 4,133 2,313 1,662 11,577 35,500 33% 360 Morris PAC various 52,561 22,635 129,679 31,466 52,867 289,207 934,900 31% 360 Palais Royale various 22,259 6,290 10,385 18,475 17,124 74,533 243,820 31% 360 Parks & Recreation various 26,797 14,565 4,051 10,548 20,675 76,637 106,700 72% 360 Police various 3,170 4,378 2,510 1,609 7,606 19,273 46,600 41% 360 TIF various 5,056 2,657 3,480 3,373 3,284 17,850 44,806 40% 360 Central Services 222 19,705 3,212 15 320 4,646 27,897 11,000 254% 360 Century Center 670 5,117 4,970 35,471 3,054 7,135 25,430 25,000 -102% 360 Dept Of Community Investment 2111212 95,353 85,179 2,438 182,970 249,500 73% 360 EMS Operating Fund 288 60 102 162 5,000 3% 360 Engineering / Curb &Sidewalk 101 209 200 32,648 500 660 31,079 22,000 - 141% 360 Fire and Police Pension Fund 7011702 3,743 3,743 4,000 94% 360 Self Funded Employee Benefits 711 6,000 6,000 6,000 100% 360 General Government Various 101131226 196 853 1,386 2,436 2,100 116% 360 Motor Vehicle Highway Scrap Meta 202 1,735 1,127 2,863 4,000 72% 360 Motor Vehicle Highway Curb Pr gm 202 3,615 324 6,819 4,538 2,992 18,288 50,000 37% 360 Local Roads and Streets 251 14,730 5,644 20,375 NA 360 ProfessionalSports Development 377 29,523 29,523 60,661 49% 360 UDAG 410 98,485 143,363 241,849 528,576 46% 360 Code /Animal Control 600 0 0 NA Financial Report May 2015 - Revenue Report Page 4 or25 City of South Bend Period Ending: May 31, 2015 Revenue by Type Report S Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I of Bud et 360 Parkin Gara a 601 3 3 NA 360 Solid Waste Fund 610 2,000 0% 360 Waste Water 6411719 2,142 3,229 998 5,441 11,810 53,000 22% 360 Water Works Utility 620 908 1,318 17 2,243 39,580 6% 362 Dept Of Community Investment 212 1,847 1,847 3,694 NA 362 Palais Royale 101 572 2,269 2,588 10,146 5,182 20,757 72,000 29% 362 Parks & Recreation 201 2,064 4,531 4,138 4,574 6,162 21,469 40,000 54% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 15,621 17,156 19,059 30,447 12,509 94,792 339,025 28% 369 Memorial Hosp Leighton Plaza 408 150,000 150,000 150,000 100% 371 Century Center Fees 670 29,668 761,205 442,960 200,587 155,264 703,764 3,032,126 23% 399 Bosch Retention Project 210 59,966 0% 399 Principal on Loan various 1,799 20,705 18,387 19,002 18,841 78,733 207,398 38% 399 Principal Income xxx 368,031 146,068 514,099 1,224,390 42% Sub Total NEW 5,476,452 6,558,266 5,412,473 6,162,214 6,036,003 29,645,407 77,816,646 38% iterest Income 361 Bank Account Interest various 197,258 51,054 75,698 118,454 65,582 508,046 798,136 641, Sub Total 197,258 51,054 75,698 118,454 65,582 508,046 798,136 64`, onations 367 ND Contribution 101 405 405 330,000 0`, 367 Donations various 2,072 990 46 3,493 6,600 246,206 3`, Sub Total 2,072 990 405 46 3,493 7,005 576,206 1`, istoric Preservation 368 Lamp Program 227 19,750 5,750 750 26,250 30,000 88`, 368 Palais 450 1,225 3,703 357 982 1,115 7,382 16,000 46`, Sub Total 1,225 3,703 20,107 6,732 1,865 33,632 46,000 73`, Revenue Total 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 - - - - - - - 82,419,084 285,395,857 29% report 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 - - - - - - - 82,419,084 285,395,857 0 0 0 1 0 0 Financial Report May 2015 - Revenue Report Page 5025 City of South Bend Revenue by Fund Report Period Ending: May 31, 2015 s i Fund Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I ud et I ofeud et General Government 0000 General Revenues 101 1,167,120 944,443 669,668 734,592 944,924 4,460,747 50,176,282 9% 0101 Mayor 101 35 15 50 100 600 17% 0104 311 Call Center 101 55,195 36,290 43,995 32,989 35,855 204,324 486,733 42% 0301 Common Council 101 41 31 15 231 31 348 8,455 4% 0401 Administration and Finance 101 220 336 556 50 1112% 0501 Legal 101 508 18,113 3 18,523 53,000 35% Sub Total 1,222,390 981,491 714,030 785,924 980,863 4,684,698 50,725,131 9% Public Works 0602 Engineering 101 225 303 1,104 1,632 77,027 2% Sub Total 225 303 1,104 1,632 77,027 2% Public Safety 0801 Police 101 6,604 11,372 38,367 2,321 20,918 79,583 537,700 15% 0901 Fire 101 10,022 59,625 37,787 11,021 10,231 128,686 12000 1072% Sub Total 16,625 70,998 76,154 13,343 31,149 208,268 549,700 38% Code Enforcement 1205 Code Unsafe Building 101 143 733 876 NA 1207 Code Animal Control 101 NA Sub Total 143 733 876 NA Arts & Culture 0404 Morris PAC 101 53,329 23,300 128,425 31,841 51,783 288,678 923,000 31 0405 Palais Royale 101 24,368 9,347 13,572 30,163 23,990 101,440 334,820 30% Sub Total 77,697 3Z647 141,998 62 003 75,773 390,118 1,257,820 31 General Fund Revenue Total 1,316,569 1,085,136 931,673 861,573 1,088,889 - - - - - - - 5,283,840 52,609,678 10% Financial Report May 2015. Expenditure Summary Page 6 of 25 City of South Bend Revenue by Fund Report Period Ending: May 31, 2015 a % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I Of Bud et Parks & Recreation 0000 Parks General revenue 201 76,460 74,383 77,445 74,566 73,993 376,848 8,860,875 4% 1100 Administration 201 2,119 4,537 4,158 4,527 6,168 21,510 40,600 53% 1101 Maintenance 201 19,996 2425 3,330 1,823 4,085 31,658 319,600 10% 1102 GolfOperations 201 161 63,205 31,916 147,893 185,191 428,367 1,535,000 28% 1103 Recreation Division 201 26,067 16,036 5,765 54 3,370 51,291 185,640 28% 1104 Potawatomi Zoo 201 NA 1108 Grafd Removal 201 11,341 13,003 7,268 31,612 89,000 36% Recreation Non Reverting 203 65,607 98,601 112,441 78,613 75,090 430,352 1,578,935 27% East Race Waterway 271 5 1 2 3 2 12 NA Coveleski Stadium 401 36 9 14 23 13 95 15,100 1% Zoo Endowment 403 43 11 17 28 15 115 200 58% Park Non Reverting 405 4,435 260 261 1,080 1,573 7,609 143,700 5% Sub Total 194,930 270,809 235,349 321,616 356,766 1,379,470 12,768,650 11% Public Works Motor Vehicle Highway 202 716,020 1,133,459 404,476 730,770 1,504,136 4,488,862 9681,300 46% Central Services 222 655,888 688,603 709,665 623,157 619,227 3,295,540 8,121,097 41% Central Services Capital 224 271,850 0% Local Roads & Streets 251 87,782 90,155 98,666 112 757 99,309 488,670 1,593,300 31% Pro'ect ReLeaf 655 37,371 36,419 36,757 37,059 36,928 184,536 431,700 43% Sub Total 1,497,062 1 948 636 1,249,565 1 503 744 Z259,601 601 8 458, 608 20 099,247 42% Public Works Solid Waste Solid Waste Operations 610 408,178 401,846 406,879 589,225 414,603 2 220, 732 5,71Z289 289 39% Solid Waste Capital 611 190,033 10,001 84,001 17 284,052 753,011 38% Sub Total 598,211 401,846 416,880 673,226 414,621 Z504,784 6,465,300 39% Public Works Water Utility 0000 Water Works Revenues 620 916,194 910,250 905,299 929,577 96Z334 4,623,653 12 724,463 36% 0630 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 395,321 960,000 41% 0660 Clay Water 620 68,898 68,829 66,186 76,543 74,475 354,930 1,096,020 32% Waterworks Capital 622 Z 776 682 1,098 1,741 946 7,242 10,000 72% Waterworks Construction 623 180 41 62 83 41 407 NA Waterworks Deposit 624 1,307 324 527 854 463 3,474 6,000 58% Waterworks Sinking 625 468 340,551 170,359 170,557 170,477 852,412 2,050,078 42% Waterworks Bond Reserve 626 1,425 353 572 2351 9,500 25% Waterworks Debt Reserve 629 1,840 150,683 775 1,279 695 155,271 16Z 749 95% Sub Total 1,073,645 1,551,529 1,225,058 1,254,745 1,290,083 6,395,061 17,018,810 38% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 51,853 52,790 50,328 52,269 50,308 257,548 549,200 47% 0000 Wastewater Revenues 641 2,628,692 2,622,801 2,675,830 2,753,646 2,798,663 13,479,633 33,197,505 41% 0621 Sewer Department 641 998 998 2,000 50% 0625 Concrete Crew 641 4,705 10,805 15,510 75,000 21% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 157,337 162,329 150,270 180,708 171,223 821,868 2,059,962 40% Sewage Capital 642 3,385 815 1,313 2036 4,001,015 4,008,563 5,398,000 74% Sewage Reserve 643 3,020 256,833 1,248 2,104 1,143 264,348 250,612 105% Sewer Bond 2007 647 NA Sewage Bond Sinking 649 774,321 773,801 774,198 775,158 774,671 3,872,150 9,288,088 42% Sewer Bond 20078 651 0 0 NA Sewage Works DS Reserve 653 NA 2010 CSO Net Sewer Bond 658 0 0 NA 2011 Sewer Bond 659 1,477 330 386 460 175 2827 6,000 47% 2012 Sewer Bond 661 14,968 3,669 5,897 9,437 5,061 39,033 20,000 195% 2013A Sewer Refund Bonds 664 4 1 2 3 1 10 NA Sub Total 3,635,057 3,878,074 3,659,472 3,776,819 7,813,066 22,762,487 50,846,367 45% Financial Report May 2015. Expenditure Summary Page 7 of 25 City of South Bend Revenue by Fund Report Period Ending: May 31, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I ofeud et Public Safe - Police 601 909 30 939 4,000 23% Police Seizures 216 162 41 876 108 59 1,245 35,900 3% Curfew Violations 218 11 3 17 7 4 41 1,025 4% Law Enforcement Educadon 220 24,859 28,459 17,376 64,238 18,300 153,231 211,000 73% Public Safe Lon. 249 540,008 539,058 430 1,078,221 539,072 2,696,788 6,472,190 42% Excess Welfare Public Safety 252 0 - - - - 0 15.900 NA Police Take Home Vehicle 278 14,575 9,474 9,529 9,591 9,352 52,521 124,200 42% Police Block Grant 280 3 1 1 2 1 9 NA Police Grants 292 55 56,891 56,947 90,000 63% Police cademy 294 11,010 7,628 1,101 893 21 20,653 22,000 94% COPS More Grants 295 564 782 681 33,633 619 36,278 128,258 28% Drua Enforcement 299 1,817 83 31,713 12,542 18,004 64,159 77,000 83% K -9 Unit 705 503 1 1 2 1 508 2,000 25% Sub Total 593,567 585,530 61,724 1,256,127 585,433 3,082,381 7,163,573 4351 Publie Safe - Fire nc Te /e hone S stem 244 19 19 20 97% ital 287 396,727 13 206 112 397,059 750,000 53% erafin Fund U 288 204,337 169,122 667,161 441,484 434,559 1,916,663 5,676,065 34% 289 3 732 10 095 10 18 f0 13 866 f0 000 139% scue 291 3,093 Z423 3,038 651 12 628 21,834 45,200 48% Sub Total 211,182 578,368 670,222 44Z360 447,309 Z349,441 6,481,285 36% Department of mmunity Investment Studebaker /0liver 209 959 3,612 16,720 20,676 15,140 57,106 644,000 9% State Grant 210 290 70 112 181 93 747 3,673,510 0% ,,Cl Operating 211 14,699 503,257 17,090 72,469 500,684 1,108,199 Z 634,125 42% 0000 Dept of Community Investment 212 3,790 12Z 753 240,619 202 172 106,570 675,904 4,100,000 16% xxx Programs 212 95,353 124,819 220,172 NA 0000 Economic Revenue Bond 281 24 6 10 16 8 64 NA Sub Total 115,115 629,699 274,551 295,513 747,314 Z062,192 11 051, 635 19% 0000 Parking Garage Revenue 601 909 30 939 4,000 23% 0460 Main Street 601 20,879 17,180 24,111 20,473 21,925 104,568 267,487 39% 0462 Leighton Plaza 601 38,528 22,329 36,745 34,605 44,243 176,450 451,691 39% 0463 Enforcement 601 5,219 7,017 6,595 8,281 7,416 34,527 114,900 30% 0464 Wayne Street 601 17,498 16,724 22,424 12,234 24,291 93,171 254,748 37% 0465 Eddv Street Commons 601 - - - - - - 15.900 0% Financial Report May 2015. Expenditure Summary Page 8 of 25 City of South Bend Revenue by Fund Report Period Ending: May 31, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I ec I Year I Budget I ofeud et Other Miscellaneous Rain Da 102 7,630 1,888 3,064 4,949 2,689 20,220 34,680 58% Excess Le 103 1 1 2 1 5 NA Gift Donation Bequest 217 1,618 989 364 80 195 3,246 223,800 1% Loss Recovery 227 5,206 4,007 21,727 8,608 2,128 41,676 50,000 83% Human Rights 258 2,065 7,188 5,759 3,628 6,425 25,064 203,400 12% Morris Palais Marketing 273 274 6 1,373 366 1,258 3,276 18,000 18% Professional Sports Development 377 93,375 142,965 63,547 36,086 29,386 365,350 671,761 54% 1201 Code Enforcement 600 18,559 529,948 11,282 46,664 24,464 630,917 2,378,996 27% 1207 Animal Control 600 3,725 162,197 5,846 6,503 3,595 181,856 689,218 26% 1306 Building Operations 600 66,158 54,907 181,599 96,899 225,373 624,936 1,085,899 58% Century Center 670 32,985 783,504 203,146 211,537 169,457 1,400,629 4,532,562 31% Century Center Capital 671 24 21 23 22 74 164 500 33% Century Center Energy Saying 672 50,000 50,000 50,000 100% Sub Total 231,619 1,687,621 497,732 415,343 515,044 3,347,359 9,938,816 34% Business Insurance 0000 Business Insurance Revenues 226 104,344 103,108 103,815 107,554 100,942 519,763 1,243,227 42% 0418 Workers Compensation 226 17,000 0% Sub Total 104,344 103,108 103,815 107,554 100,942 519,763 1,260,227 41% Fiducia Trust & Agency Fire Pension 701 688 130 54 3,743 4,615 5211,592 0% Police Pension 702 1,133 230 184 1,546 6360,000 0% Employee Benefits lCi 711 1,248,718 1 226 227 1,217,884 1 210 699 1,200,922 6,104,451 16 357,570 37% Unemployment Comp 713 8,685 8,526 8,559 8,613 8,549 42,931 226,796 19% Cemetery Trust 730 25 6 10 16 9 66 150 44% Sub Total 1,259,249 1 235 119 1,226,689 1 223 071 1,209,480 6 153, 610 28 156,108 22% Civil City Revenues 12,653,540 15,953,113 10,816,094 15,511,366 18,836,330 - - - - - - - 73,770,442 248,727,850 30% Tax Increment Financing TIF Airport 324 50,350 33,228 6,479,376 346,205 37,081 6,946,240 24,940,646 28% TIF Central Development 420 695 4,240 (4,935) NA TIF West Washington 422 996 261 423 675 364 2,719 422,000 1% TIF Leighton Plaza 425 18,229 12,971 10,040 21,366 8,977 71,583 189,123 38% TIF Medical Service 426 1,941 501 (2,442) 0 NA TIF Northeast 429 23,215 993 1,434,000 2,685 1,830 1,462,724 3,829,653 38% TIF Southside 430 4,144 1,025 1,590 2,545 1,371 10,674 2,410,000 0% TIF Erskine Village 432 5,246 1,268 1,967 3,083 1,675 13,239 25,000 53% TIF Douglas Road 435 161 48 23 30 16 278 320,750 0% Northeast Residential TIF 436 1,215 352 5 1,571 2,815,000 05, Sub Total 106,191 54,887 7,920,047 376,589 51,315 8,509,028 34,952,172 24% Financial Report May 2015. Expenditure Summary Page 9 of 25 City of South Bend Revenue by Fund Report Period Ending: May 31, 2015 s i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Bud et I ofBUd et Redevelopment Commission 213,015 76,867 7,923,126 381,562 54,071 - - - - - - - 8,648,641 36,668,007 24% City Operations Total 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 - - - - - - - 82,419,084 285,395,857 29% Revenue report 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 0 0 0 0 0 0 0 82,419,084 285,395,857 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report May 2015. Expenditure Summary Page 10 of 25 City of South Bend Property Tax Revenue 2013 Tax Pay 2014 Fund Period Ending: May 31, 2015 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61612014 612512014 1212412014 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,715,401.11 0.95 36,779,631.05 13,984,752.01 6,078,082.84 16,646,154.38 36,708,989.23 2,006,411.88 94.82% Parks & Recreation 201 7,760,516.48 0.95 7,372,490.66 2,803,248.70 1,218,353.96 3,343,785.26 7,365,387.92 395,128.56 94.91% College Football Hall of Fame 313 524,471.43 0.95 498,247.86 - 271,788.05 225,979.78 497,767.83 26,703.60 94.91% Cumulative Capital District 406 453,896.12 0.95 431,201.31 163,956.07 71,258.93 195,570.89 430,785.89 23,110.23 94.91% Fire Pension 701 - 0.95 - - - 2,478,709.77 - - - Police Pension 702 99,497.78 0.95 Erskine Commons TIF District #2 431 0.95 - Total - City - 47,454,285.14 Erskine Village TIF District #3 45,081,570.88 16,951,956.78 7,639,483.78 20,411,490.31 45,002,930.87 2,451,354.27 94.83% Tax Increment Financinq Airport TIF District 324 15,600,858.95 0.95 14,820,816.00 7,521,012.22 6,763,722.21 14,284,734.43 1,316,124.52 91.56% South Bend Central TIF District 420 4,376,939.50 0.95 4,158,092.53 2,485,265.66 1,824,461.25 4,309,726.91 67,212.59 98.46% West Washington TIF District 422 602,782.79 0.95 572,643.65 304,152.20 276,835.15 580,987.35 21,795.44 96.38% Central Medical TIF District 426 764,755.26 0.95 726,517.50 459,659.10 391,551.74 851,210.84 (86,455.58) 111.30% Northeast Residential TIF District 436 2,674,146.48 0.95 2,540,439.16 1,382,498.19 1,343,410.58 2,725,908.77 (51,762.29) 101.94% Southside TIF District # 1 430 2,478,709.77 0.95 2,354,774.28 1,268,946.48 1,110,265.51 2,379,211.99 99,497.78 95.99% Erskine Commons TIF District #2 431 0.95 - - - - Erskine Village TIF District #3 432 - 0.95 - 9,175.08 - 9,175.08 (9,175.08) 100.00% Douglas Road TIF District 435 321,894.56 0.95 305,799.83 160,947.28 160,947.28 321,894.56 - 100.00% Northeast TIF 429 1,649,304.42 0.95 1,566,839.20 808,183.73 760,056.03 1,568,239.76 81,064.66 95.08% Airport Urban Enterprise Zone 454 0.95 - - - - Other xxx - Total - Tax Increment Financing 28,469,391.73 27,045,922.14 14,399,839.94 12,631,249.75 27,031,089.69 1,438,302.04 94.95% Grand Total 75,923,676.87 72,127,493.03 16,951,956.78 22,039,323.72 33,042,740.06 72,034,020.56 3,889,656.31 94.88% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 616114 2 Distribution 2 - Issued by St. Joseph County on 6125114 3 Distribution 3 - Issued by St. Joseph County on 12124114 Financial Report May 2015 - Property Tax Revenue Page 11 of 25 City of South Bend Property Tax Revenue 2012 Tax Pay 2013 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61412013 611712013 1212312013 Total Property Tax Collection Airport TIF District Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,369,939.03 0.95 36,451,442.08 13,051,204.28 6,798,591.66 16,401,600.74 36,251,396.68 2,118,542.35 94.48% Parks & Recreation 201 7,623,780.24 0.95 7,242,591.23 2,593,163.21 1,350,822.26 3,263,074.28 7,207,059.75 416,720.49 94.53% College Football Hall of Fame 313 1,341,607.54 0.95 1,274,527.16 - 693,822.13 574,356.46 1,268,178.59 73,428.95 94.53% Cumulative Capital District 406 490,121.50 0.95 465,615.43 166,710.61 86,842.35 209,778.19 463,331.15 26,790.35 94.53% Fire Pension 701 - 0.95 - - - 2,618,580.97 - - - Police Pension 702 214,165.13 0.95 Erskine Commons TIF District #2 431 0.95 - - Total - City - 47,825,448.31 Erskine Village TIF District #3 45,434,175.89 15,811,078.10 8,930,078.40 20,448,809.67 45,189,966.17 2,635,482.14 94.49% Tax Increment Financinq Airport TIF District 324 15,275,702.92 0.95 14,511,917.77 7,111,555.29 6,228,798.58 13,340,353.87 1,935,349.05 87.33% South Bend Central TIF District 420 3,761,712.00 0.95 3,573,626.40 1,705,490.58 885,317.48 2,590,808.06 1,170,903.94 68.87% West Washington TIF District 422 584,897.07 0.95 555,652.22 264,689.94 228,918.51 493,608.45 91,288.62 84.39% Central Medical TIFDistrict 426 2,128,725.48 0.95 2,022,289.21 613,184.76 608,491.41 1,221,676.17 907,049.31 57.39% Northeast Residential TIF District 436 2,607,578.70 0.95 2,477,199.77 1,340,027.53 922,737.17 2,262,764.70 344,814.00 86.78% Southside TIF District # 1 430 2,618,580.97 0.95 2,487,651.92 1,381,537.24 1,022,878.60 2,404,415.84 214,165.13 91.82% Erskine Commons TIF District #2 431 0.95 - - - - Erskine Village TIF District #3 432 1,319,469.76 0.95 1,253,496.27 659,734.88 651,393.90 1,311,128.78 8,340.98 99.37% Douglas Road TIF District 435 322,082.97 0.95 305,978.82 164,167.82 159,770.93 323,938.75 (1,855.78) 100.58% Northeast TIF 429 1,152,857.67 0.95 1,095,214.79 431,978.67 409,648.70 841,627.37 311,230.30 73.00% Airport Urban Enterprise Zone 454 0.95 - - - - - Other xxx 0.95 - Total - Tax Increment Financing 29,771,607.54 28,283,027.16 13,672,366.71 11,117,955.28 24,790,321.99 4,981,285.55 83.27% Grand Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 31,566,764.95 69,980,288.16 7,616,767.69 90.18% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 614113 2 Distribution 2 - Issued by St. Joseph County on 6117113 3 Distribution 3 - Issued by St. Joseph County on 12123113 X Financial Report May 2015 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending: May 31, 2015 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et vemment ryor 101 80,464 52,550 48,452 55,723 53,138 290,327 741,267 1 Call Center 101 55,195 36,290 43,995 32,989 35,855 204,324 486,733 erk 101 34,775 28,270 26,114 26,345 27,469 142,972 431,573 ommon Council 101 33,803 24,869 110,974 30,970 47,806 248,422 490,150 NIT Contract 101 411 43,000 43,000 43,000 Iministration and Finance 101 187,531 134,271 139,736 136,435 154,038 752,011 2,020,544 gal Department 101 99,178 73,129 64,725 70,589 73,432 381,053 1,006,979 ib Total 490,946 349,379 433,994 353,052 434,738 2,062,109 5,220,246 cs igineering 101 72,931 79,671 89,919 62,192 67,688 372,400 1,058,933 ib Total 72,931 79,671 89,919 62,192 67,688 372,400 1,058,933 ty dice 101 2,557,412 1,878,728 1,990,424 1,850,902 1,869,819 10,147,286 25,633,064 lice -PS LOIT funded 101 2,562 6,199 (8,761) Mice Communications 101 135,031 97 8 514,528 128,638 778,301 1,687,540 •e 101 2,150,469 1,590,349 1,505,644 1,328,213 1,314,720 7,889,395 17,774,474 v-PS LOIT funded 101 411 411 x ib Total 4,845,886 3,475,373 3,487,315 3,693,643 3,313,177 18,815,394 45,095,078 cement ode 101 (710) (710) 2,270 ode Unsafe Building 101 ode Animal Control 101 ib Total (710) (710) 2,270 Ire nris PAC 101 96,838 87,590 80,670 75,338 75,072 415,508 1,093,132 dais Royale 101 41,912 31,105 39,827 31,888 34,119 178,851 536,293 ib Total 138,749 118,696 120,497 107,226 109,192 594,360 1,629,425 Ws iman Rights 101 50,323 31,896 19,693 30,347 27,284 159,544 373,179 ib Total 50,323 31,896 19,693 30,347 27,284 159,544 373,179 General Fund Expenditure Total 5,598,836 4,055,015 4,151,418 4,246,460 3,951,368 - - - - - - - 22,003,097 53,379,131 41% Financial Report May 2015. Expenditure Summary Page 13 of 25 City of South Bend Period Ending: May 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Parks & Recreation Motor Vehicle Highay 1100 Administration 201 104,226 71,673 67,013 81,921 79,879 404,712 967,568 42% 1101 Maintenance 201 435,157 348,338 455,082 344,569 398,104 1,981,250 5,178,905 38% 1102 Golfo eradons 201 66,821 76,812 203,778 123,539 118,983 589,933 1,573,436 37% 1103 Recreation Division 201 193,339 143,079 147,938 140,851 152,356 777,564 2,328,698 33% 1104 Potawatomi Zoo 201 392,247 lIZ389 8,788 7,968 5,262 526,652 863,017 61% 1106 Potawatomi Greenhouse 201 5,079 20,391 5,260 3,156 2005 35,892 53,997 66% 1108 Graffiti Removal 201 9,057 7,116 5,887 7,268 6,941 36,269 98,374 37% Recreation Non Reverting 203 43,898 60,957 66,785 87,752 84,777 344,169 1,549,469 22% East Race Waterway 271 637 455 775 2098 695 2098 4,000 52% Coveleski Stadium 401 968,839 1,479,202 1,183,962 1,068,758 1,276,167 5,976,928 3,540 0% Zoo Endowment 403 _ _ _ _ _ _ _ _ _ _ _ _ _ 49,000 0% Park Non Reverting 405 - - - 2,197 19,422 21,619 192,933 11% Sub Total 659 1,249,824 840,754 960,531 801,319 867,731 4,720,159 12,862,937 37% Vorks Motor Vehicle Highay 202 734,565 950,683 835,051 410,155 418,569 3,349,022 8,843,890 Curb and Sidewalk 202 lIZ714 39,990 31,802 29,933 21,753 236,192 1,641,496 Central Services 222 679,565 621,835 691,937 716,505 537,157 3,246,998 8,300,242 Central Services Capital 224 4,000 9% Waterworks Capital 622 15,382 67,463 271,850 Local Roads & Streets 251 4,155 4,853 37,032 6,650 109,145 161,834 1,926,221 Project ReLeaf 655 15,357 2281 2386 27,010 2442 49,477 528,358 Sub Total 527 1,546,355 1,619,642 1,598,209 1,190,253 1,089,066 7,043,524 21,512,057 Vorks Solid Waste Solid Waste Operations 610 635,488 341,051 339,903 382,803 461,210 2,160,456 5,873,863 Solid Waste Capital 611 223,749 143 11,054 83,702 168 318,816 752,811 Sub Total 859,237 341,194 350,957 466,506 461,378 2,479,271 6,626,674 Public Works Water Utility 0630 Water Leak Insurance 620 33,830 53,166 43,413 474 131,182 262,066 1,115,000 249/ 0640 Water Works 620 906,773 1,320,043 1,131,090 1,058,030 1,143,612 5,559,548 14,725,471 38% 0660 Clay Water 620 22 29,608 309 26 13 371 4,000 9% Waterworks Capital 622 15,382 67,463 3,489 1,776,763 5,782,494 86,334 838,893 10% Waterworks Construction 623 11,278 37,750 4,276 438 85,097 53,743 53,085 101% Waterworks Deposit 624 452 324 527 854 463 2619 6,000 44% Waterworks Sinking 625 465 1 84 282 202 1,035 2,050,078 0% Waterworks Bond Reserve 626 1,045 747 1,248 7,374 1,143 7,374 15,000 NA Waterworks Debt Reserve 629 637 455 775 1,279 695 3,840 8,500 45% Sub Total 649 968,839 1,479,202 1,183,962 1,068,758 1,276,167 5,976,928 18,801,027 32% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 21,449 57,144 43,434 46,092 55,529 223,647 545,703 41% 0621 Sewer Repair 641 446,632 360,251 404,056 284,993 308,945 1,804,877 5,201,049 35% 0625 Concrete Crew 641 44,148 29,608 25,634 23,472 31,229 154,092 450,450 34% 0630 Wastewater Operations 641 2,004,256 2,110,111 1,803,497 1,776,763 5,782,494 13,477,120 31,017,413 43% 0631 Organic Resources 641 69,307 56,543 60,055 54,333 85,097 325,335 1,527,562 21% 0650 Clay Sewage 641 28 103 106 113 349 500 70% Sewage Ca ital 642 39,115 47,104 402228 2254 281,988 772,690 9,071,710 9% Sewage Reserve 643 1,045 747 1,248 2,104 1,143 6,287 15,000 42% Sewer Bond 2007 647 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA Sewage Bond Sinking 649 1,000 850 301,269 303,119 9,282,109 3% Sewage Bond 2007 651 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 2010 CSO Net Sewer Bond 658 - - - - - - - - - - - - - - NA 2011 Sewer Bond 659 143,037 50Z 799 246,856 184,257 8,408 1,085,357 3,711,838 29% 2012 Sewer Bond 661 39,170 249,076 234,187 81,154 302,659 906,245 16,624,275 5% 2013 Sewer Bond 663 NA Sub Total 2,809,188 3,414,232 3,221,297 2,455,529 7,158,873 19,059,119 77,447,609 25% Financial Report May 2015. Expenditure Summary Page 14 of 25 City of South Bend Period Ending: May 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et Public Safe - Police EMS Ca ital 287 35,728 Seizures 216 EMS O eratin Fund 288 247,977 32,280 210,228 382,360 383,042 1,255,887 6,855,366 35,900 0% Violations 218 21,542 31,530 River Rescue 291 0 2,120 21,395 854 20,421 1,000 0% forcement Education 220 15,730 29,274 27,290 24,802 29,310 126,406 362,478 35% nc Tele hone S stem 244 20 1 21 Administration 212 183,750 365,625 NA Safe LOIT UE-ergency 249 73 2,055 515,347 549,323 505,155 516,948 2,818,828 7,246,551 39% Welfare Pu61ic Safet 252 647,998 Sub Total 369,417 329,268 372,756 1,146 0% Take Home Vehicle 278 55,859 153,529 335,865 138,115 116,706 800,073 71,100 0% Grants 292 1,268 15,297 11,946 11,079 15,297 105,145 15% Academ 294 2,725 9,673 242 11,678 476 24,793 23,750 104% More Grants 295 20,490 784 4,485 1,262 479 27,500 172,335 16% Dnfa Enforcement 299 18,385 6,474 18,397 6,844 6,225 56,325 248,960 23% K -9 Unit 705 2,899,524 2,754,112 970 888,116 2,204,138 970 2,000 49% Sub Total 789,405 576,850 600,685 549,741 553,438 3,070,119 8,270,365 37% sfe - Fire EMS Ca ital 287 35,728 35,728 750,000 EMS O eratin Fund 288 247,977 32,280 210,228 382,360 383,042 1,255,887 6,855,366 Hazmat 289 20,939 602 21,542 31,530 River Rescue 291 0 2,120 21,395 854 20,421 44,790 120,800 Sub Total 186,881 268,916 70,730 231,622 383,215 403,463 1,357,946 7,757,696 ent of Community Investment StudebakeLVOliver 209 16,261 3,375 6,335 10,054 14,798 34,562 630,000 State Grant 210 12,200 24,311 18,003 24,096 400,000 430,203 3,694,412 DCI Operating 211 250,396 178,976 186,881 187,235 182,680 986,169 2,661,730 Dept, of Community Investment 212 102,720 134,503 161,537 515,770 284,129 1,198,659 5,899,970 Administration 212 183,750 365,625 50% EDIT 408 577,062 15,900 Programs 212 4,101 12,414 64,293 36,871 104,364 16,514 647,998 Sub Total 369,417 329,268 372,756 713,059 881,606 2,666,106 13,534,110 Garages Main Street 601 16,261 29,534 14,520 689 11,980 72,983 262,391 Leighton Plaza 601 16,812 24,311 21,634 24,096 24,047 110,899 696,570 Enforcement 601 1,340 31,872 16,253 335 8,521 58,321 89,236 Wayne Street 601 54,617 27,884 11,887 11,750 59,817 165,954 742,615 Eddy Street Commons 601 183,750 365,625 50% EDIT 408 577,062 15,900 Sub Total 154,855 89,030 113,600 64,293 36,871 104,364 408,158 1,806,712 Ce I I /Debt Service Hall of Fame 313 636,000 636,000 1,266,820 50% COIT 404 1,322,195 797,317 799,782 433,747 914,359 4,267,399 15,660,371 27% Cum Capital Development 406 112,650 56,546 135,726 304,922 542,691 56% Cum Ca ita /Improvement 407 183,750 183,750 365,625 50% EDIT 408 577,062 1,795,231 126,960 154,855 1,034,072 3,688,180 9,627,618 38% UDAG 410 146,068 146,068 438,203 33% Major Moves 412 55,859 153,529 335,865 138,115 116,706 800,073 3,096,061 26% Morris PAC Improvement 416 1,268 1,665 11,946 11,079 25,958 70,248 37% CRED 434 3,897 3,897 650,000 1% Palais Historic Preservation 450 16,150 0% Hallof Fame Ca ital 677 6,843 6,370 5,998 4,253 3,276 26,740 188,824 14% Sub Total 2,899,524 2,754,112 1,337,096 888,116 2,204,138 10,082,986 31,922,611 32% Financial Report May 2015. Expenditure Summary Page 15 of 25 City of South Bend Period Ending: May 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Other Miscellaneous ? Self Funded Liability Ins Gift Donation _Bequest 217 26,675 27,830 136 24,917 28,211 81,093 297,182 27% Loss Recovery 227 181,590 298,680 822,026 396,131 555,991 2,254,417 5,237,243 43% Human Ri hts 258 22,061 9,167 26,033 11,344 12,797 81,403 247,357 33% Morris Palais Marketin 273 67,459 96 989,000 2,358 730 2,454 18,974 13% ProfessionalSports Development 377 480,773 800 Sub Total 2,019,201 481,573 854,803 56% 1201 Code Enforcement 600 120,449 101,851 94,621 183,959 101,999 602,879 2,414,485 25% 1207 Animal Control 600 57,484 47,550 49,635 42,055 56,024 252,747 696,216 36% 1306 Building Operations 600 104,444 75,646 91,217 76,910 80,817 429,034 1,094,700 39% Century Center 670 306,497 285,449 289,304 326,417 340,496 1,548,163 4,532,562 34% Century Center Capital 671 1,464,000 66,156 50,000 116,156 308,156 38% Sub Total 1,273,296 913,225 1,372,972 1,064,090 1,226,335 5,849,918 15,701,678 37% as Insurance ? Self Funded Liability Ins 226 26,134 26,675 14,630 19,531 15,003 101,973 282,900 2 Liability Insurance 226 156,054 7,585 32,230 286,937 18,509 501,315 1,184,891 7 Business Insurance 226 15,927 14,875 21,403 1,739 75,766 129,711 600,000 4 Workers Compensation 226 64,123 206,418 63,790 43,608 67,459 445,398 989,000 Sub Total 730 262,238 255,553 132,053 351,815 176,737 1,178,398 3,056,791 Trust & A enc Fire Pension 701 441,192 441,276 450,317 433,126 43Z 764 2,198, 675 5,666,579 Police Pension 702 537,112 524,012 559,034 535,159 523,172 2,678,489 6,832,235 Employee Benefits I 711 1,030,771 963 626 1,093,990 1 462 313 1,140,933 5,691,633 16,696,935 Unemployment Comp 713 10,126 5,167 9,025 7,309 10,788 42,416 226,796 Cit Cemetery Trust 730 52,831 154,716 34% TIF Medical Service 426 20,000 Sub Total 2,019,201 1,934,080 2,112,366 2,437,907 2,107,658 10,611,212 29,442,545 Civil City Expenditure 21,003,306 18,697,459 17,690,217 16,653,639 22,462,321 - - - - - - - 96,506,942 302,121,943 32% Tax Increment Financing TIFAir ort 324 2,276,439 1,684,991 1,736,337 586,596 271,305 6,555,668 47,710,597 14% TIF Central Development 420 964,016 957,248 4,081,705 4,088,473 4,537,169 90% TIF West Washington 422 15,300 7,650 7,344 30,294 760,900 4% TIF Leighton Plaza 425 6,962 9,662 17,748 11,509 6,950 52,831 154,716 34% TIF Medical Service 426 2,294,533 2,294,533 2,476,033 93% TIF Northeast 429 112,956 5,000 16,291 4,700 138,947 7,239,524 2% TIF Southside 430 435,370 24,431 62,420 38,892 10,969 572,082 2,842,535 20% TIF Erskine Village 432 357,545 201,724 559,269 691,380 81% TIF Douglas Road 435 169,620 169,620 345,389 49% Northeast Residential TIF 436 1,464,000 246,589 1,000 1,711,589 3,425,632 50% Sub Total 5,617,288 1,400,070 8,200,393 660,631 294,924 16,173,306 70,183,875 23% Financial Report May 2015. Expenditure Summary Page 16 of 25 City of South Bend Period Ending: May 31, 2015 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of laud et �elo ment Funds Adminlstratlon 433 6,000 Certified Technology Park 439 198 405,121 96,682 502,001 51000,000 Blackthorn Golf Operations 619 69,055 89,358 22,845 227 181,484 1,671,706 Sub Total 69,055 89,358 23,043 405,121 96,909 683,485 6,677,706 Cervlce Airport Debt Reserve 2003 315 317 227 368 594 323 1,829 5,000 Central Development reserve 328 530 379 615 993 539 3,056 6,000 Sub Total M 847 606 983 1,587 862 4,885 11,000 Financial Report May 2015. Expenditure Summary Page 17 of 25 Redevelopment Commission 5,687,190 1,490,033 8,224,418 1,067,340 392,695 - - - - - - - 16,861,677 76,872,581 22% City Operations Total 26,690,496 20,187,492 25,914,635 17,720,979 22,855,017 - - - - - - - 113,368,619 378,989,838 30% Expenditure report 26,690,496 20,187,492 25,914,635 17,720,979 22,855,017 0 0 0 0 0 0 0 113,368,619 378,989,838 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report May 2015. Expenditure Summary Page 17 of 25 City of South Bend Period Ending: May 31, 2015 Debt Schedule Yearof I Yearof Yearof Schetluletl Payments Debt lOng/Renr Debtaf 2015Prfncipal 20151aterest 2015 Debt at 2015 Total Debt lnsWment Debt PU Issue Refuntlin Mafi Fund 1st 2ntl 3n1 4th Issue 1213112014 Pa ants Pa eat AtltllOOa 12/312015 Debt Pa rents CN#C#y Debt Bond Debt A_-k 3f CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11.870.000.00 2.055.000.00 790.000.00 86.100.00 0.00 1.265.000.00 876.100.00 36 South Bend Build Coroomllon Public Works Buildlno 2001 2010 2021 4041649 2/1 8/1 - - 9.250.000.00 3.860.000.00 545.000.00 129.726.00 0.00 3.315.000.00 674.726.00 25 Water Works l mwovements Water Works 2002 2012 2023 625 1/1 7/1 - - 5.975.000.00 3.100.000.00 355.000.00 62.000.00 0.00 2.745.000.00 417.000.00 . South Bend Buildinq Corporation Fire HQ/ Police HQ 2003 2012 2023 4041324 2/1 8/1 - - 21.335.000.00 11.245.000.00 1.160.000.00 403.635.00 0.00 10.085.000.00 1.563.635.00 24 Water Work s Improvements Water Works 2006 2027 625 1/1 7/1 - - 4.710.000.00 3.300.000.00 210.000.00 146.726.00 0.00 3.090.000.00 356.726.00 42 Sewsoa Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7.630.000.00 5.740.000.00 365.000.00 255.491.26 0.00 5.375.000.00 620.491.26 40 Sewage Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16.600.000.00 12.320.000.00 720.000.00 535.947.50 0.00 11.600.000.00 1.255.947.50 52 Sewage Works Revenue Bonds 20078 Sewage Works 2007 2027 649 6/1 12/1 - - 16.515.000.00 12.280.000.00 710.000.00 524.341.26 0.00 11.570.000.00 1.234.341.26 s2 Cenlury Center Special Tax Bonds Century Canter 2008 2028 420 5/1 11/1 - - 4.655.000.00 3.750.000.00 285.000.00 107.687.50 0.00 3.465.000.00 392.687.50 s9 Water Works Improvements Water Works 2009 2030 625 1/1 7/1 - - 5.380.000.00 4.775.000.00 220.000.00 261.098.00 0.00 4.555.000.00 481.098.00 70 Sewage Works Revenue Bonds - 2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3.297.000.00 2.561.387.00 153.712.00 71.974.00 0.00 2.407.675.00 225.686.00 so 2010 Sewage Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9.345.000.00 7.905.000.00 375.000.00 325.267.50 0.00 7.530.000.00 700.267.50 es Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21.500.000.00 19.040.000.00 865.000.00 706.650.00 0.00 18.175.000.00 1.571.650.00 ss 2012Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8.300.000.00 7.620.000.00 345.000.00 223.686.26 0.00 7.275.000.00 568.686.26 fof 2012 Sewace Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25.000.000.00 22.965.000.00 1.030.000.00 528.180.00 0.00 21.935.000.00 1.558.180.00 1. 2013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14.765.000.00 11.855.000.00 1.885.000.00 229.987.00 0.00 9.970.000.00 2.114.987.00 16 2013 Buildino Coroorabon EMS / Fire Department 2013 2033 288 2/1 8/1 - - 5.580.000.00 5.580.000.00 215.000.00 190.680.00 0.00 5.365.000.00 405.680.00 f33 St. Joseoh County PSAP St. Joseoh County PSAP 2014 2034 408 Month M 2.657.696.50 2.657.696.50 123.377.50 75.951.55 0.00 2.534.319.00 199.329.05 f39 Cenlury Center En- Savings Imbrovements at Certury Ctr. 2015 2031 672 5/1 11/1 4.167.897.00 0.00 0.00 0.00 4.167.897.00 4.167.897.00 0.00 Total Bond Debt 198.532.593.50 142.609.083.50 10.352.089.50 4.865.128.83 4.167.897.00 136.424.891.00 15.217.218.33 Loans Payable ss State RevoNing Fund Water Works Improvement 2009 2030 625 1/1 7/1 - - 427.332.00 372.364.00 19.571.00 12.548.66 0.00 352.793.00 32.119.66 az Interfund Lean 410 - UDAG 1 st Sourca/Mam tt Garage 2010 2015 410 6/15 12/15 - - 2.700.000.00 2.027.973.00 438.202.50 0.00 0.00 1.589.770.50 438.202.50 44 State Revolving Fund (Refunding) Sewage Works Improvement 1998 2018 649 6/1 1211 - - 24 .000. 00 0.00 0.00 0.00 0.00 0.00 0.00 zs State Revolving Fund Water Works Improvements 2000 2019 625 1/1 7/1 - - 2.600.000.00 860.913.00 162.482.00 24.966.00 0.00 698.431.00 187.448.00 Total Loans Payable 29.822.332.00 3.261.250.00 620.255.50 37.514.66 0.00 2.640.994.60 657.770.16 Capital Leases st Chase LED Eauipmant 2007 2017 101 1/1 7/1 1.531.573.00 559.122.04 178.539.39 22.040.27 0.00 380.582.65 200.579.66 ]2 Kansas State Bank Code Enfwcament Ow Copier 2010 2015 101 1/23 4/23 7/23 10123 9.209.00 539.14 539.14 10.50 0.00 0.00 549.64 ,e Kansas State Bank Central Be,!- Conner 2010 2015 222 2116 5/16 8/16 11116 13.366.40 1.496.90 1.496.90 33.10 0.00 0.00 1.530.00 n GE Capital Ind- b- Tachnolagv Animal Control Copier 2010 2015 101 2128 5/30 8/30 11130 3.550.69 403.62 403.62 4.04 0.00 0.00 407.66 ]s Kansas State Bank Mavw Ow Copier 2010 2015 101 1/8 4/8 7/8 1018 9.209.00 1.586.72 1.586.72 62.20 0.00 0.00 1.648.92 ]a Advanced Imaoina Central Services Dedicators 2010 2015 222 1/15 4/15 7/15 10/15 10.511.02 2.455.77 2.455.77 139.59 0.00 0.00 2.595.36 s] Public Finance- Inc Solid Waste Containers /crocks 2011 2015 611 6/15 12/15 321.853.00 67.665.30 67.665.30 1.599.70 0.00 0.00 69.265.00 as Sun Trust Polnce. Parks. Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2.167% 2.00 641.545.46 425.630.31 9.335.10 0.00 215.915.15 434.965.41 ao Capital One Public Funding Solid Waste ContainersiTrocks 2011 2016 611 3/15 6/15 9/15 12/15 207.432.00 74.504.09 42.308.31 977.25 0.00 32.195.78 43.285.56 at GE Capital Information Tachnolwv Police Debt Copier 2011 2016 101 1/11 4/11 7/11 10/11 3.836.00 1.275.18 837.22 51.50 0.00 437.96 888.72 az Kev Finance IT Phone Svstem 2011 2016 404 1/15 1.444.995.97 569.323.31 281.141.18 14.258.23 0.00 288.182.13 295.399.41 a4 Ikon Office Solutions Mavw Ricoh MP 2851 SP Co.!., 2011 2016 101 2115 5115 8115 11/15 2.569.53 1.110.31 539.50 48.98 0.00 570.81 588.48 as Sun Trost Eaunbmant Finance Parks -Goff Cars Lease 2012 2016 201 4/15 10115 - - 344.500.00 131.862.30 87.556.51 1.765.97 0.0 44.305.79 89.322.48 w Sun Trost Eauibmon[Finance Police VehiclesB Eauibmont 2012 2 1 406 1.295.000.00 661.712.34 261.339.69 10.111.59 Co 0.0 400.372.65 271.451.28 as PNC Eaul -ant Finance Pudic Works Vehicles Lease 2012 2 1 202/641/640 5/15 11/15 - - 945.674.38 481.717.95 190.523.14 6.535.71 0.00 291.194.81 197.058.85 0o PNC Eaul -ant Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15 - - 2.806.054.00 1.703.748.90 560.548.08 20.403.26 0.00 1.143.200.82 580.951.34 oz Ikon Office Solutions /Ricoh Wastewater Copier 2012 2 1 641 MonihN 1st 5.744.95 3.170.10 1.172.61 149.31 0.00 1.997.49 1.321.92 ps GE Capital lnfoa t- Tachnoloov Fire Debart-t Gooier 2012 2 1 101 2/28 5/26 8/28 11/28 5.471.01 3.205.85 1.106.31 164.49 0.00 2.099.54 1.270.80 pa Ricoh USA (New) Central Services Gooier 2013 2018 222 2127 5/27 8/27 1127 3.622.78 2.315.31 728.85 110.91 0.00 1.586.46 839.76 s] Ricoh USA Straet/Sewer Deor Cotner 2013 2018 202/641 3/4 6/4 9/4 1214 5.559.15 3.475.34 1.092.25 178.55 0.00 2.383.09 1.270.80 as Ricoh USA ON Attwnev Cooler 2013 2018 101 2112 5/12 8112 11/12 5.559.15 3.492.63 1.097.31 173.49 0.00 2.395.32 1.270.80 o& Raceh USA Parks & Rac Ricoh Cod -43) 2013 2018 201 2121 5121 821 1121 16.129.94 10.132.91 3.184.26 502.98 0.00 6.948.65 3.687.24 to PNC Eauibment Finance Vehide/E.abment Lease 2013 2018 101/202/406/641 1/15 7/15 1,689,669.59 1.361.951.27 334.301.24 15.599.28 0.00 1.027.650.03 349.900.52 11 Ricoh USA Enaineedna Plo6er /Scanner 2013 2018 101 3/3 fi/3 9/3 12/3 10.667.67 6.790.21 2.073.34 518.66 0.00 4.716.87 2.592.00 t2 Ricoh USA Buildinq Dad. Caller 2013 2018 600 MonihN 4.093.64 3.109.92 786.76 152.24 0.00 2.323.16 939.00 fs Sun Trust Eauibment Finance P. I- and PW vehicles 2013 2018 404/655/611/202 424 1024 1.506.465.26 1.214.609.68 296.499.82 18.081.32 0.00 918.109.86 314.581.14 t4 Ricoh USA Adman & Finance Copier 2013 2018 101 1/16 4/16 7/16 10/16 11.247.97 7.565.05 2.178.10 393.14 0.00 5.386.95 2.571.24 n Police Dent. Recem Div. Ricoh Police Records Cobior 2013 2018 101 MonfN 3rd 9.678.26 7.950.10 1.826.18 393.82 0.00 6.123.92 2.220.00 fa Water Works Main Racah Cooler Water Works Main Ricoh Cooler 2013 2018 620 MonihN 10th 5.647.50 4.639.36 1.065.38 230.08 0.00 3.573.98 1.295.46 fa Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Cable 2013 2018 620 MonihN 16th 4.732.65 3.887.84 892.77 192.75 0.00 2.995.07 1.085.52 12o Water Works Olive Ricoh Cooler Water Works Olive Racah Cooler 2013 2018 620 MonihN 10th 4.732.65 3.887.84 892.77 192.75 0.00 2.995.07 1.085.52 2a Police Treinina Debt. Ricoh Copier Tminina Caller 2014 2019 101 MonihN 30th 4.263.00 3.714.38 796.08 187.92 0.00 2.918.30 984.00 24 PolicalPublac Works Vehicle Lease 2014 Citv Vehicles 2014 2019 Various 4/1 1011 1.959.485.95 1.959.485.95 379.888.68 28.907.87 0.00 1.579.597.27 408.796.55 125 HP Combater Lease #1 Computes Eauibmont Lease 2014 2016 MonlhN 8th 137.104.95 12d .55d.02 29.828.93 4.995.44 0.00 94.725.09 34.824.37 1z6 HP Combater Lease #2 Computes Eauabmant Lease 2014 2018 201 and 620 Monffi 8th 4.000.00 3.720.95 866.48 154.00 0.00 2.854.47 1.020.48 z] HPCombuterl-mse#4 Computes Eauibment Lease 2014 2018 404 Mont, 8th 5.886.15 5.461.99 1.307.57 188.47 0.00 4.154.42 1.496.04 t2s HPCombuterl-mse#6 Computes Eauibment Lease 2014 2018 201 Monffi 8th 3.755.50 3.561.10 801.62 155.50 0.00 2.759.48 957.12 za HP Combater Lease #7 Compu[w Eauabment Lease 2014 2018 620 Monffi 8th 1.326.00 1.302.13 294.22 42.62 0.00 1.007.91 336.84 130 Solid Waste Cader Ricoh USA Coder 2014 2019 611 MonlhM 17th 5.351.65 5.351.65 1.035.84 296.27 0.00 4.315.81 1.332.11 tat Police Communications Cader Ricoh USA Coder 2014 2019 101 MonlhN 12th 8.843.00 8.196.86 1.613.55 418.29 0.00 6.583.31 2.031.84 13z Organic Resources &Wastewater Ricoh USA Coders 2014 2019 641 MonlhM 21st 12.260.18 11.182.59 2.247.61 569.39 0.00 8.934.98 2.817.00 te4 Water Works Cader- Nodh Station Ricoh USA Coders 2014 2019 620 MonlhM 19th 4.732.65 3.960.04 888.67 196.84 0.00 3.071.37 1.085.51 tea HP Combater Lease #B Computor Eauabmant Lease 2015 2019 404201/611 Monffi 16th 19.603.94 0.00 3.434.11 759.69 19.603.94 16.169.83 4.193.80 13] Animal Control Ricoh Cader Ricoh USA Caders 2015 2020 600 Monffi 30th 5.261.50 0.00 694.75 217.13 5.261.50 4.566.75 911.88 138 HP Combater Lease #9 Computes Eauabmont Lease 2015 2019 Various MonlhM TBD 135.958.05 0.00 14.229.04 3.223.14 135.958.05 121.729.01 17.452.18 too Vehide &Eauab. Lease Vehids/Eauabmant Lease 2015 2020 Various 1/15 7/15 3.425.273.58 0.00 0.00 0.00 3.425.273.58 3.425.273.58 0.00 Total Capital Lease 20,039,664.26 9,670,744.40 3,189,935.88 164,723.33 3,586,097.07 10,088,905.59 3,354,859.21 a�- City of South Bend Period Ending: May 31, 2015 Debt Schedule Yearof I Yearof Yearof Schetlu -I Payments Debf (Org/Re1)i Debtaf 2015Principal 20151nlerest 2015 Debt at 2015 TOfal Debt lnsWment Debt PU Issue Refuntlhl slatu Fund 1st 2ntl 3n1 4th Issue 1213112014 Pa eels Pa wit AtltllOOn 121312015 Debt Pa menls Ratlavalopment Commission Dabf Bontl Debf ] Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1 - - 6.825.000.00 1.630.000.00 450.000.00 37.500.00 0.00 1,180,000.00 487,500.00 8 College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15.370.000.00 4.160.000.00 1.150.000.00 116.820.00 0.00 3,010,000.00 1,266,820.00 11 Soulh Bend Building Corporation Mom PAC 1998 2009 2017 408 2/1 8/1 - - 13.300.000.00 2.460.000.00 950.000.00 87.212.50 0.00 1,510,000.00 1,037,212.50 12 TJX Special Tazinq Dist ct 2002 2014 2022 324/404/414 1/1 7/1 - - 6.620.000.00 3.010.000.00 395.000.00 88,350.00 0.00 2.615.000.00 481,350.00 5 Dovmtonn Centel Area TI F 2003 2011 2024 420 2/1 8/1 - - 19.795.000.00 14.965.000.00 1.205.000.00 709.525.00 0.00 13,760.000.00 1,914,525.00 6 Airport Development Area TI F Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14.420.000.00 8.535.000.00 690.000.00 404.611.50 0.00 7,845,000.00 1,094,611.50 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1 - - 5.485.000.00 4255.000.00 220.000.00 268.380.00 0.00 4,035,000.00 488,380.00 54 Lease Rental Revenue Bwdsof2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36.000.000.00 33.020.000.00 1.075.000.00 1,853.268.00 0.00 31,945.000.00 2,928,268.00 81 Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4,980,000.00 2,915,000.00 820,000.00 134,802.50 0.00 2295,000.00 754,802.50 104 2012 Gates Dovmtoom Campus VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 1.700.000.00 566.666.68 568.666.68 0.00 0.00 0.00 566,666.68 121 Blackthorn Golf Carl Lease Blackthorn Golf 2014 2019 619 Monthly 14th 293.788.00 257.238.04 257.238.04 4.688.91 0.00 0.00 261,926.95 122 Synagogue at COVeleski lmprovemenls Coveleski Stadium 2014 2016 377 1/31 500.000.00 400,000.00 100,000.00 0.00 0.00 300,000.00 100,000.00 135 2015 Redevolament Smart Streets Smarts Streets 2015 2037 324 2/1 8/1 25.000,000.00 0.00 0.00 0.00 25.000.000.00 25.000.000.00 0.00 Totafaontl Debt 153.788.788.00 76.173.904.72 7.678.904.72 3.703.158.41 25.000.000.00 93.495.000.00 11,382.063.13 Loans Payable 3 Indiana Development Finance Authority Bosch PropeM (NOMOrgivel 2001 2021 210 3/22 6/22 9/22 12/22 1.040.000.00 423.620.93 59.966.23 12.044.21 0.00 363.854.70 72,010.44 4 Intliana Development Finance Authority Bosch Property (Fomive) 2001 2021 210 - - 260.000.00 117.130.26 0.00 0.00 0.00 100.557.56 0.00 60 HUD Section 108 #8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4.000.000.00 180.000.00 180.000.00 7.794.00 0.00 0.00 187,794.00 63 City of Mishavmka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 47,003.08 47,003.08 1,175.08 0.00 0.00 48,178.17 64 Imerfund FUnd412- MajorM -a Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,040.319.00 886.677.00 251.157.00 41.852.00 0.00 635.520.00 293.009.00 83 inledund Fund 619- Blackthom Blackthorn Equip (qolf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31.032.00 0.00 0.00 0.00 0.00 0.00 0.00 84 Inledund Fund 412 -Major Moves Tnangle Development 2011 2029 436 2/15 8/15 - - 2.000.000.00 1.513259.50 90.929.20 29.812.80 0.00 1,422.330.30 120.742.00 85 Intedund FUnd 412 -Major Moves Eddy Slreel Commons 2011 2026 436 2/15 8/15 - - 4.100.000.00 3227.558.81 213.696.29 158.739.71 0.00 3,013.862.52 372.436.00 86 Interfund Fund 209 to Aimodt 324 Praine Ave Broamfeld Proieal 2011 2020 324 8/9 - - - 500.000.00 500.000.00 0.00 0.00 0.00 500.000.00 0.00 BB Blackthorn Loan from Airport Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53,598.50 0.00 0.00 0.00 0.00 0.00 0.00 Total Loans Payable 14.127.499.06 6.895.449.59 842.751.81 251.417.80 0.00 6,036.125.08 1,094.169.61 CapOaf Lease Total Ca Raf Lease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leases 37 Transco Lease Leiqhton Plaza Garage 2001 2015 404 6/30 12/30 - - 3.000.000.00 191.347.00 191,347.00 8.653.00 0.00 0.00 200,000.00 13 Transoo Lease Main /COSaz Game 2006 2025 404 3/15 9/15 - - 2.510278.00 1.676.543.00 117,825.00 82.375.00 0.00 1,558,918.00 200,000.00 ToWfLease 5.510278.00 1.867.890.00 308.972.00 91.028.00 0.00 1,558.918.00 400,000.00 Tofal Retlevelopment Commission 173.426.565.06 84.93].244.31 8.830.628.53 4.045.604.21 25.000.000.00 I 101.090.043.08 12.876.232.]4 City of South Bend Period Ending: May 31, 2015 Monthly Debt Schedule Yearof I Yearof Yearof Schetluletl Payments Debt lOrg /Rani Debtaf YTD Pdnclpal YTD lnlenast YTD Debtat Debt lnsWment Debt P. Issue Refuntlin Mafi w Fund 1st 2ntl 3n1 4th Issue JM112014 P.,_. Pa ants AtltliOOns 1 513112015 CN#C#y Debt Bond Debt A_-k 3f CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11.870.000.00 2.055.000.00 200.000.00 21.200.00 0.00 1.855.000.00 36 South Bend Build Coroordlon Public Works Buildlno 2001 2010 2021 4041649 2/1 8/1 - - 9.250.000.00 3.860.000.00 270.000.00 66.888.00 0.00 3.590.000.00 25 Water Works l mprovements Water Works 2002 2012 2023 625 7/1 12/31 - - 5.975.000.00 3.100.000.00 0.00 0.00 0.00 3.100.000.00 a9 South Bend Buildinq Corporation Fire HQ/ Police HQ 2003 2012 2023 4041324 2/1 8/1 - - 21.335.000.00 11.245.000.00 575.000.00 206.130.00 0.00 10.670.000.00 24 Water Work s Improvements Water Works 2006 2027 625 7/1 12/31 - - 4.710.000.00 3.300.000.00 0.00 0.00 0.00 3.300.000.00 42 Sewsoa Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7.630.000.00 5.740.000.00 0.00 0.00 0.00 5.740.000.00 40 Sewage Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16.600.000.00 12.320.000.00 0.00 0.00 0.00 12.320.000.00 52 Sewage Works Revenue Bonds 20078 Sawaga Works 2007 2027 649 6/1 12/1 - - 16.515.000.00 12.280.000.00 0.00 0.00 0.00 12.280.000.00 s2 Century Center Special Tax Bonds Century Canter 2008 2028 420 5/1 11/1 - - 4.655.000.00 3.750.000.00 285.000.00 55.981.25 0.00 3.465.000.00 s9 Water Works Improvements Water Works 2009 2030 625 7/1 12/31 - - 5.380.000.00 4.775.000.00 0.00 0.00 0.00 4.775.000.00 70 Sawa oa Works Revenue Bonds - 2009 Sawaga Works 2009 2028 649 6/1 12/1 - - 3.297.000.00 2.561.387.00 0.00 0.00 0.00 2.561.387.00 so 2010 Sewage Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9.345.000.00 7.905.000.00 0.00 0.00 0.00 7.905.000.00 es Sawa ge Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21.500.000.00 19.040.000.00 0.00 0.00 0.00 19.040.000.00 ss 2012Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8.300.000.00 7.620.000.00 345.000.00 115.243.13 0.00 7.275.000.00 101 2012 Sewage Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25.000.000.00 22.965.000.00 0.00 0.00 0.00 22.965.000.00 1. 20, 3A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14.765.000.00 11.855.000.00 0.00 0.00 0.00 11.855.000.00 16 2013 Buildino Corporation EMS / Fire Depadment 2013 2033 288 2/1 8/1 - - 5.580.000.00 5.580.000.00 215.000.00 96.952.50 0.00 5.365.000.00 f33 St. Joseph County PSAP St. Joseph County PSAP 2014 2034 408 Monthiv - - - 2.657.696.50 2.657.696.50 51.407.30 31.646.50 0.00 2.606.289.20 f39 Century Center En- Savings Improvements Century Cb. 2015 2031 672 5/1 11/1 - - 4.167.897.00 0.00 0.00 0.00 4.167.897.00 4.167.897.00 Total Bond Debt 198.532.593.50 142.609.083.50 1.941.407.30 594.041.38 4.167.897.00 144.835.573.20 Loans Payable ss State Revolving Fund Water Works Improvement 2009 2030 625 7/1 12/31 - - 427.332.00 372.364.00 0.00 0.00 0.00 372.364.00 az Intarfund Lean 410 - UDAG 1 st Sourca/Mamott Garage 2010 2015 410 6/15 12/15 - - 2.700.000.00 2.027.973.00 0.00 0.00 0.00 2.027.973.00 44 State Revolving Fund (ach# 1051 Sewage Works Improvement 1998 2018 649 6/1 1211 - - 24.09 .000. 00 0.00 0.00 0.00 0.00 0.00 zs State Ravovina Fund Water Works Improvements 2000 2019 625 7/1 12/31 - - 2.600.000.00 860.913.00 0.00 0.00 0.00 860.913.00 Total Loans Payable 29.822.332.00 3.261.250.00 0.00 0.00 0.00 3.261.250.00 Capflal Leases st Chase LED Equipment 2007 2017 101 1/1 7/1 1.531.573.00 559.122.04 88.324.62 11.965.21 0.00 470.797.42 ]2 Kansas State Bank Code Enfwcement Ow Copier 2010 2015 101 1/23 4/23 7/23 10123 9.209.00 539.14 539.14 10.50 0.00 0.00 ]s Kansas State Bank Central Be,!- Copier 2010 2015 222 2116 5/16 8/16 11116 13.366.40 1.496.90 1.496.90 33.10 0.00 0.00 n GE Capital Information Tach -licav Animal Control Copier 2010 2015 101 2128 5/30 8/30 11130 3.550.69 403.62 403.62 4.08 0.00 0.00 ]s Kansas State Bank Mavw Ow Copier 2010 2015 101 1/8 4/8 7/8 1018 9.209.00 1.586.72 1.047.58 51.70 0.00 539.14 ]a Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10.511.02 2.455.77 1.200.63 97.05 0.00 1.255.14 s] Public Finance.cem Inc Solid Waste Containersftrocks 2011 2015 611 6/15 12/15 321.853.00 67.665.30 0.00 0.00 0.00 67.665.30 as Sun Trust Police. Parks. Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2.068.202.00 641.545.46 105.638.79 3.102.56 0.00 535.906.67 ao Capital One Public Funding Solid Waste ContainersiTrocks 2011 2016 611 3/15 6/15 9/15 12/15 207.432.00 74.504.09 10.511.27 310.12 0.00 63.992.82 at GE Capital Information Technolwv Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10111 3.836.00 1.275.18 412.60 31.76 0.00 862.58 az Kev Finance IT Phone Svstam 2011 2016 404 1/15 1.444.995.97 569.323.31 281.141.18 14.258.23 0.00 288.182.13 a4 Ikon Office Solutions Mavw Ricoh MP 2851 SP Copier 2011 2016 101 2115 5115 8115 11/15 2.569.53 1.110.31 265.95 28.29 0.00 844.36 as Sun Trust Equipmant Finance Parks -Goff Cars Lease 2012 2016 201 4/15 10115 - - 344.500.00 131.862.30 43.603.35 1.057.89 0.00 88.258.95 w Sun Trust Eauipmon[Finance Police VehiclesB Equipment 2012 2 1 406 5/15 11/15 - - 1.295.000.00 661.712.34 130.118.56 5.607.08 0.00 531.593.78 as PNC Equipment Finance Pubic Works Vehicles Lease 2012 2 1 202/641/640 5/15 11/15 - - 945.674.38 481.717.95 94.904.49 3.624.93 0.00 386.813.46 0o PNC Eaui -ant Finance Public Works Vehicles Lease 2012 201] 202/641/600/288 1/15 7/15 - - 2.806.054.00 1.703.748.90 279.362.97 11.112.70 0.00 1.424.385.93 oz Ikon Office Solutions /Ricoh Wastewater Copier 2012 2 1 641 MonthN 1st 5.744.95 3.170.10 480.56 70.24 0.00 2.'689.54 pa GE Capital lnfor t- Tachnoloav Fire Department Caviar 2012 2 1 101 2128 5/26 8/28 11128 5.471.01 3.205.85 545.08 90.32 0.00 2.660.77 pa Ricoh USA Central Services Caviar 2013 2018 222 2127 5/27 8/27 1127 3.622.78 2.315.31 368.41 51.47 0.00 1.946.90 s] Ricoh USA Sbest/Sawer Deal Copier 2013 2018 202/641 3/4 6/4 9/4 1214 5.559.15 3.475.34 267.18 50.52 0.00 3.208.16 as Ricoh USA ON Aftn -Copiw 2013 2018 101 2112 5/12 8/12 11/12 5.559.15 3.492.63 554.91 80.49 0.00 2.937.72 o& Ricoh USA Parks & Rac Ricoh Cod -431 2013 2018 201 2121 521 821 1121 16.129.94 10.132.91 1.610.26 233.36 0.00 8.522.65 f. PNC Equipment Finance Vehide/Eauianent Lease 2013 2018 1011202/406/641 1/15 7/15 1.689.669.59 1.361.951.27 166.642.36 8.307.90 0.00 1.195.308.91 11 Ricoh USA Enaineedna Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10.0667.67 6.790.21 501.90 146.10 0.00 6.288.31 t2 Ricoh USA Buildinq DeW. Copier 2013 2018 600 MonthN - - 4.093.64 3.109.92 322.55 68.70 0.00 2.787.37 fa Sun Trust Eauibr ent Finance Police and PW vehicles 2013 2018 404165516111202 424 1024 1.506.465.26 1.214.609.68 147.664.79 9.625.78 0.00 1.O6fi.944.89 t4 Ricoh USA Admen 8 Finance Cagier 2013 2018 101 1/16 4/16 7/16 10/16 11.247.97 7.565.05 1.073.33 212.29 0.00 6.491.72 n Police Deal. Racem Div. Ricoh Police Records Copier 2013 2018 101 MonthN 3rd - - 9.678.26 7.950.10 748.68 176.32 0.00 7.201.42 fa Water Works Main Ricoh Copier Water Works Main Ricoh Cooler 2013 2018 620 Month N 10th - - 5.647.50 4.639.36 436.77 102.98 0.00 4.202.59 f& Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Cable 2013 2018 620 MonthN 16th - - 4.732.65 3.887.84 366.01 86.29 0.00 3.521.83 12o Water Works Olive Ricoh Cooler Water Works Olive Ricoh Cooler 2013 2018 620 Man thN 10th - - 4.732.65 3.887.84 366.01 86.29 0.00 3.521.83 2a Police Train no Dept. Ricoh Copier Tminina Gooier 2014 2019 101 MonthN 30th - - 4.263.00 3.714.38 326.30 83.70 0.00 3.388.08 24 Kev Goverment Finance 2014 City Vehicles 2014 2019 4/1 1011 - - 1.959.485.95 1.959.485.95 189.211.09 15.187.18 0.00 1.770.274.86 125 HP Computer Lease #1 Comrutw Eauipmont Lease 2014 2016 Mon" 8th - - 137.104.95 12d .55d.02 12.266.09 2.244.06 0.00 112.287.93 1z6 HP Computer Lease #2 Co..ter Equipment Lease 2014 2018 201 and 620 MonlhN 8th - - 4.000.00 3.720.95 356.17 69.03 0.00 3.364.78 z] HPComputer Lease#4 Co..ter Equipment Lease 2014 2018 404 Mont, 8th - - 5.886.15 5.461.99 538.68 84.67 0.00 4.923.31 tea HPComputer Lease#6 Co..ter Equipment Lease 2014 2018 201 MonlhN 8th - - 3.755.50 3.561.10 329.29 69.51 0.00 3.231.81 za HP Computer Lease #7 Conamter Equipment Lease 2014 2018 620 MonlhN 8th - - 1.326.00 1.302.13 120.47 19.88 0.00 1.181.66 13p Solid Waste Career Ricoh USA Gooier 2014 2019 611 MonlhN 17th - - 5.351.65 5.351.65 470.29 144.53 0.00 4.881.36 tat Police Communications Career Ricoh USA Gorier 2014 2019 101 MonlhN 12th - - 8.843.00 8.196.86 661.37 185.23 0.00 7.535.49 13z Organic Resources &Wast --ter Ricoh USA Coolers 2014 2019 641 MonlhN 21st - - 12.260.18 11.182.59 921.26 252.49 0.00 10.261.33 134 Water Works Career -Nodh Station Richo USA Goners 2014 2019 620 MonlhN 19th - - 4.732.65 3.960.04 364.33 87.97 0.00 3.595.71 fah HP Computer Lease #B Comonter Eauirrant Lease 2015 2019 404201/611 MonlhN 16th - - 19.603.94 0.00 1.015.14 243.00 19.603.94 18.588.80 13] Animal Control Ricoh Career Ricoh USA Gaolers 2015 2020 600 MonlhN 30th - - 5.261.50 0.00 151.77 50.87 5.261.50 5.109.73 138 HP Computer Lease #9 Conamter , Equipment Lease 2015 2019 Various MonlhN TBD - - 135.958.05 0.00 lI 0 0.00 135.958.05 135.958.05 too Vehide &Equip. Lease Vehids/Eauipmant Lease 2015 2020 Various 1/15 7/15 - - 3.425.273.58 0.00 0.00 0.00 3.425.273.58 3.425.273.58 Total Ca ftal Lease 20.039.664.26 9.670.744.40 1.567.652.70 89.406.37 3.586.097.07 11.689.188.77 ToteICNN CIfy 248.394.589.76 155.541.077.90 3.509.060.00 683.447.75 7.753.994.07 1 159.786.011.97 City of South Bend Period Ending: May 31, 2015 Monthly Debt Schedule Year of Yearof Yearof Schetluletl Payments Debf lOrg /Rani Debtof YTD Principal YTD Interest YTD Debtat Debt lnsWment Debt PU Issue Refundin Matu Fund 1st 2ntl 3n1 4th Issue 1213112014 Pa ants Pa enfs Atltlifions 1 513112015 Retlevelopment Commission Debf Bontl Debf 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1 - - 6.825.000.00 1.630.000.00 225.000.00 19.875.00 0.00 1,405,000.00 8 College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15.370.000.00 4.160.000.00 570.000.00 61.758.75 0.00 3,590,000.00 11 South Bend Building Coroomtion Mom PAC 1998 2009 2017 408 2/1 8/1 - - 13.300.000.00 2.460,000.00 470.000.00 48.012.50 0.00 1,990,000.00 12 TJX Special Taxinq Dist ct 2002 2014 2022 324/404/414 1/1 7/1 - - 8,820,000.00 3,010,000.00 0.00 0.00 0.00 3,010,000.00 5 Downtown Centel Area TIF 2003 2011 2024 420 2/1 8/1 - - 19.795.000.00 14.965.000.00 595.000.00 361.248.00 0.00 14,370.000.00 6 Airoad Development Area TI F Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14.420.000.00 8.535.000.00 340.000.00 206.011.75 0.00 8,195,000.00 22 Erskine Vulaoe TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1 - - 5.485.000.00 4255.000.00 220.000.00 137.545.00 0.00 4,035,000.00 54 Lease Rental Revenue B.d. of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36.000.000.00 33.020.000.00 530.000.00 931.934.00 0.00 32,490.000.00 81 Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4.980.000.00 2,915.000.00 310.000.00 70.772.50 0.00 2,605,000.00 104 2012 Gates Downtown Campus VA Clinic Agmt Loan 2012 2015 4201324 3/1 8/1 - - 1.700.000.00 566.666.68 283.333.33 0.00 0.00 283,333.35 121 Blackthorn Golf Cad Lease Blackthorn Golf 2014 2019 619 Monthlv 14th 293.788.00 257.238.04 257.238.04 535.91 0.00 0.00 122 Synagogue at Coveleski Improvements Coveleski Stadium 2014 2018 377 1/31 500.000.00 400.000.00 100.000.00 0.00 0.00 300.000.00 135 2015 Redevelopment Smart Streets Smart Streets 2015 2037 324 2/1 8/1 25.000.000.00 0.00 0.00 0.00 25.000.000.00 25.000.000.00 Total BOntl Debt 153.788.788.00 76.173.904.72 3.900.571.37 1.837.693.41 25.000.000.00 97.273.333.35 Loans Payable 3 Intliana Development Finance Authority Bosch Property (NOMOrgivel 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 423,820.93 14,823.95 3,178.86 0.00 408,996.98 4 Intliana Development Finance Authority Bosch Property (Fomwe) 2001 2021 210 - - 260,000.00 117,130.26 0.00 0.00 0.00 117,130.26 60 HUD Section 108 #8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4.000.000.00 180.000.00 0.00 3.897.00 0.00 180,000.00 63 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102.549.56 47.003.09 47.003.09 1.175.08 0.00 0.00 64 Intertund Fund 412 -Maio, Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1.040,319.00 888,877.00 99275.00 22,167.00 0.00 787402.00 83 in terfund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31.032.00 0.00 0.00 0.00 0.00 0.00 84 In FUnd 412 -Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2,000,000.00 1,513259.50 45238.41 15,132.80 0.00 1,488,021.09 85 Intedund FUnd 412 -Major Moves Eddy Street Commons 2011 2026 436 2/15 8/15 - - 4.100.000.00 3227.558.81 105.529.03 80.688.97 0.00 3,122.029.78 86 Interfund Fund 209 to Airport 324 Pmide Ave Brownfield Prgect 2011 2020 324 8/9 - - - 500.000.00 500.000.00 0.00 0.00 0.00 500.000.00 88 Blackthorn Loan from Aimort Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53.598.50 0.00 0.00 0.00 0.00 0.00 Total Loans Payable 14.127.499.06 6.895.449.59 311.869.48 126239.31 0.00 6,583.580.11 CapOal Lease Total Ca bal Lease 1 0.00 0.00 0.00 0.00 0.00 0.00 Leases 37 Tmnsoo Lease Leighton Plaza Game 2001 2015 404 6/30 12/30 - - 3.000.000.00 191.347.00 0.00 0.00 0.00 191,347.00 13 Transoo Lease Main /Colas Game 2006 2025 404 3/15 9/15 - - 2, 510278.00 1,878,543.00 58,088.00 41,914.00 0.00 1,618,457.00 Total Lease 5.510278.00 1.867.890.00 SBD86.00 41,914.00 0.00 1 1,809,804.00 Tofal Retlevelopment Commission 173.426.565.06 84.937.244.31 1 4.270.526.85 I 2.005.846.72 25.000. -Aft 1 105,666,717.46 City of South Bend Staffing Headcount Summary Budget Full Time I Jan Feb I Mar I Apr I May Jun I Jul Aug I Sep I Oct I Nov I Dec Full Time Staff 1094.00 1084.00 1076.00 1077.00 1072.00 1073.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Part Time Staff 68.00 70.00 90.00 101.00 110.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Temporary /Seasonal 111.00 109.00 113.00 126.00 209.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 1263.00 1255.00 1280.00 1299.00 1392.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report May 2015 - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Amended Budget General Government Mayor 7.00 7.00 7.00 7.00 7.00 7.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 311 Call Center 7.00 7.00 7.00 7.00 7.00 7.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 21.00 21.00 21.00 21.00 21.00 21.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Innovation / Technology Office 4.00 2.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Safety & Risk 3.00 3.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Clerk 5.00 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Common Council 9.00 9.00 9.00 9.00 9.00 9.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 L al De artment 11.00 10.00 11.00 11.00 11.00 11.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 67.00 64.00 65.00 65.00 65.00 65.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Ent. /Animal Control 24.00 23.00 23.00 22.00 22.00 23.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 25.00 23.00 23.00 24.00 24.00 24.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Administration 10.00 10.00 10.00 10.00 10.00 10.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 44.00 44.00 44.00 44.00 43.00 43.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Golf Operations 8.00 8.00 8.00 8.00 8.00 8.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 26.00 24.00 24.00 24.00 24.00 25.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Zoological Ops 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Non-reverting 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 91.00 89.00 89.00 89.00 88.00 89.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Safety Police 306.00 302.00 302.00 304.00 300.00 297.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Communications 0.00 7.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 see narrative Fire 258.00 258.00 258.00 260.00 260.00 260.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 564.00 567.00 560.00 564.00 560.00 557.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Works Central Services 37.00 34.00 34.00 33.00 34.00 35.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Office of Sustainability 2.00 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 16.00 15.00 15.00 15.00 16.00 16.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Operations 21.00 20.00 21.00 21.00 21.00 20.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Clean Crew 4.00 4.00 4.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Street Operations 56.00 56.00 56.00 55.00 56.00 56.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sewer Operations 33.00 33.00 30.00 30.00 28.00 30.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 44.00 44.00 44.00 43.00 43.00 42.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Organic Resources 6.00 6.00 6.00 6.00 6.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Utilit Ops 68.00 68.00 68.00 68.00 67.00 69.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 290.00 285.00 283.00 280.00 280.00 282.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Building Department 13.00 13.00 13.00 13.00 13.00 13.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Human Rights 6.00 6.00 6.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Morris & Palais 14.00 14.00 14.00 14.00 14.00 14.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 1094.00 1084.00 1076.00 1077.00 1072.00 1073.00 0.00 0.00 0.00 QWO 0.00 0.00 0.00 Financial Report May 2015 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Financial Report May 2015 - Headcount Staffing Page 24 of 25 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 311 Call Center 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Clerk 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Common Council 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Le al De artment 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 4.00 4.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enf. /Animal Control 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Administration 5.00 5.00 5.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 4.00 7.00 12.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Golf Operations 0.00 1.00 20.00 29.00 34.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 31.00 32.00 32.00 30.00 30.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Zoological Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 0.00 0.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 39.00 41.00 62.00 71.00 81.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Safety Police 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Communications Fire Sub Total 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Works Central Services 1.00 1.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Traffic & Lighting 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Ops 0.00 1.00 1.00 2.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Street Ops 4.00 3.00 3.00 3.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sewer Ops 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Utilit Ops 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 11.00 11.00 10.00 12.00 11.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Building Department 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Human Rights 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Morris & Palais 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 68.00 70.00 90.00 101.00 110.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report May 2015 - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Temporary, Seasonal, and Intern Staff General Government Jan I Feb Mar I Apr May I Jun Jul I Aug Sep I Oct I Nov Dec Mayor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 4.00 1.00 1.00 1.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Clerk 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Common Council 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Le al 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 4.00 1.00 1.00 1.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enforcement 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Public Works Building Department Human Rights Morris & Palais Administration 5.00 5.00 5.00 5.00 7.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 11.00 10.00 9.00 16.00 35.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Golf Operations 2.00 3.00 10.00 11.00 16.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 46.00 47.00 38.00 46.00 83.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Zoological Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 64.00 65.00 62.00 78.00 141.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 27.00 27.00 27.00 27.00 27.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Communications 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fire 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 27.00 27.00 27.00 27.00 27.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Central Services 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 4.00 4.00 5.00 5.00 10.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Energy /Sustainability 4.00 4.00 4.00 4.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Traffic & Lighting 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Ops 3.00 3.00 9.00 8.00 10.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Street Ops 1.00 4.00 1.00 0.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sewer Ops 2.00 0.00 2.00 2.00 6.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leaf Pickup 1.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Organic Resources 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Utilit Ops 1.00 1.00 1.00 0.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 16.00 16.00 23.00 20.00 38.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 111.00 109.00 113.00 126.00 209.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report May 2015 - Headcount Staffing Page 25 of 25