Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
04-2015 Financial Report
Period Ending: Issued By: April 30, 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 April 2015 Page 1 of 25 April 30, 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 22 %. The overall percentage of collected revenue amount for April 2014 was 20 %. 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 331 (Federal Grants), received $326,005 in police and community development block grants. Revenue by fund As of April 30, 2015, the general fund has received 8% 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 two distributions (March and April), 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 231 % or $5,780 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 April 2015, the City has spent 24% of budgeted expend itures,same as budgeted expenditures in April 2014. The General Fund has spent 34% of its 2015 budgeted expenditures, versus 32% 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 April 2015, several debt service payments were made in the amount of - $439,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. This month, $7.7 million in bond debt was added for the purpose of energy savings at the Century Center as well as for vehicles and equipment. Headcount The Full Time Headcount as of April 2015 was 1,072 vs. a budgeted amount of 1,094. Currently, there are a total of 22 vacant positions. The 22 open positions are in the following departments: Public Safety (4), Public Works (10), Code Enforcement / Animal Control (2), Parks Recreation (3) 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 April 2015 Page 2 of 25 City of South Bend Period Ending: April 30, 2015 Revenue by Type Report 240,300 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 311 Pro a Tax Civil Ci various 1,729 883,438 tel Motel Tax Century Center 670 656,725 45,606,508 0% 311 Pro a Tax T/FDgstricts various 292,000 490,500 tel Motel Tax Century Center 420 _ _ _ _ _ _ _ _ 24,514,604 0% Sub Total 407 453,318 150,000 b Total 656,725 292,000 70,121,112 0% Income Tax 439 13,183 11,261 14,750 69,400 _ NA 315 Econ Development Income Tax 408 765,101 765,101 1,463,758 2,993,959 8,981,877 33% 316 Local Option Income Tax -PS 249 538,849 538,849 1,077,698 2,155,397 6,466,190 33% 316 County Option Income Tax 404 738,326 738,326 1,476,652 2,953,304 8,859,912 33% Sub Total 101 2,042,276 2,042,276 4,018,108 $102,660 24,307,979 33% ;ounty (Remitted by) ,to Excise Tax various 2,508,752 mmercial Vehicle Tax various 1,729 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 453,318 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 650,000 0% 335 Cigarette Tax 1011407 33% 340 810 1011289 317,818 0% 335 State Pension Subsidy 7011702 453,318 453,318 453,318 453,318 11,557,092 0% 335 CTP Distribution 439 13,183 11,261 14,750 69,400 _ NA 335 Gaming Proceeds 101 51,890 62,282 48,246 51,834 600,000 0% 335 Gasoline Tax 2021251 348,926 369,636 422,676 426,523 1,567,760 4,647,000 34% 335 Liquor Excise tax 101 41,349 380 Energy Office Reimbursements 41,349 65,000 64% 335 Liquor Gallonage Tax 101 67,259 4,471,200 30,798 98,057 200,000 49% 335 ProfSports Development Tax 377 63,326 142,874 63,470 35,855 305,525 610,000 50% 335 Wheel Tax 202 418,779 67,941 392,533 879,253 2,050,000 43% Sub Total 392 939,639 512,510 554,087 885,709 2,891,945 20,696,910 14% governmental Sources deral Drug 299 1,729 226 31,642 12,460 45,830 75,000 vte Drug 216 33% 340 810 1011289 810 35,000 yment in Lieu of Tax various 453,318 453,318 453,318 453,318 1,813,272 5,439,810 ntractual Service 211 13,183 11,261 14,750 69,400 108,594 243,000 nds various 51,890 62,282 48,246 51,834 214,252 798,302 b Total 380 468,230 464,579 500,519 535,178 1,968,506 5,792,810 Charge for Service Internal City 340 Liability Insurance 226 99,293 101,897 101,897 104,502 407,589 1,222,727 33% 340 General Government Misc Ch s 1011289 50 50 6,000 1% 340 Police Take Home Vehicle 278 7,060 4,680 4,670 4,640 21,050 61,100 34% 349 Central Service 222 51,890 62,282 48,246 51,834 214,252 798,302 27% 380 Central Service 222 199,523 201,656 208,098 203,681 812,958 2,800,655 29% 380 Energy Office Reimbursements 222 383,538 417,794 450,403 363,667 1,615,402 4,471,200 36% 380 Internal Service Reimbursement various 114,099 125,201 140,744 220,036 600,079 2,853,706 21% 392 Administration Fee 101 303,580 303,580 303,580 303,580 1,214,318 3,642,953 33% 392 Internal Fund Transfers various 966,983 3,518,478 7,340,433 1,062,256 12,888,149 34,257,476 382L 395 Employee Benefits 711 1,234,237 1,233,503 1,224,809 1,216,576 4,909,124 16,425,996 30% Financial Report Apn12015 - Revenue Report Page 3 025 City of South Bend Period Ending: April 30, 2015 Revenue by Type Report 240,300 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 6,908 22,000 31� 396 Self Funded Employee Benefits 711 13,173 13,173 NI Sub Total 3,373,375 5,972,039 9,824,850 3,532,789 22,703,052 66,562,115 34� ,d Party Revenue 340 No EMS Service 101 320 Inspections Central Service 11,080 4,675 15,755 150,000 11� 340 Memorial Hospital Neo Natal 101 10,022 56,678 36,788 10,545 114,033 N! 350 Job Target Penalty Fee 408 13,394 88,729 117,340 76% 354,660 0� 364 Cable TV Franchise Fees 101 177,167 5,793 6,503 177,167 700,000 25� 366 AT &T Franchise Fees 101 69,037 65,509 54,764 69,037 276,000 25� Sub Total 1,083,832 10,022 302,882 47,868 15,220 375,992 1,480,660 25� rants 331 Federal Grants various 321,650 121,681 172,179 326,005 941,516 5,535,445 17� 334 State Grants various 3,600,000 0� Sub Total 321,650 121,681 172,179 326,005 941,516 9,135,445 10`, Fees for Services External 320 Inspections Central Service 222 330 490 820 1,400 59% 321 Business License 1011222 31,966 22,740 20,630 13,394 88,729 117,340 76% 321 Code and Animal Fees 600 3,725 4,795 5,793 6,503 20,816 59,850 35% 322 Building Fees 600 65,509 54,764 181,309 96,256 397,838 1,083,832 37% 322 Code Enforcement Fees 600 150 450 1,500 500 2,600 NA 322 EMS Operating Fund 288 2,233 2,460 1,295 2,375 8,363 24,500 34% 322 General Government Fees 101 6,640 725 1,030 2,430 10,825 10,000 108% 341 General Government Various various 1,736 1,940 1,164 1,602 6,442 27,405 24% 342 Highway & Streets 1011202 24,377 9,564 2,090 36,031 390,000 9% 342 Public Safety various 22,350 26,067 13,071 12,281 73,769 130,000 57% 342 EMS - Count Fees 288 426,728 142,243 568,970 1,667,565 34% 342 EMS - Capital Fund 287 396,727 396,727 NA 342 EMS - Operating Fund 288 198,675 156,466 226,551 290,112 871,804 2,900,000 30% 342 EMS - Neo Natal 288 385,000 0% 344 Solid Waste 610 401,357 397,131 400,073 405,112 1,603,673 5,091,168 31% 344 Code Environmental Clean Up 101 1600 11,215 1,263 1,051 27,629 41,158 50,000 82% 344 Sewage Waste Water 641 2,776,091 2,783,483 2,821,111 2,926,251 11,306,935 35,234,467 32% 344 Sewer Repair Insurance 640 50,523 52,458 49,781 51,388 204,150 548,000 37% 344 Water Leak Insurance 620 80,558 79,817 80,181 74,113 314,668 960,000 33% 346 Water Works Utility 620 979,733 976,299 965,088 992,620 3,913,741 13,678,403 29% 346 Solid Waste Misc 610 5,075 4,623 6,710 97,941 114,349 128,148 89% 346 Pro"ectReLeaf 655 36,473 36,203 36,396 36,456 145,528 429,000 34% 347 Parks & Recreation various 88,374 165,687 152,152 218,148 624,361 3,565,575 18% 347 Blackthorn Golf Club 619 99,156 20,083 0 119,238 1,696,879 7% 347 Morris PAC 416 7,870 1,419 9,761 3,266 22,316 100,000 22% 349 Parking Garage Fees 601 77,130 56,458 83,412 67,492 284,492 973,926 29% 349 Code Demolition Board Up 1011600 2,932 9,994 467 12,513 25,906 20,000 130% 349 Parking Century Center 670 8,435 17,329 24,852 7,896 58,512 162,000 36% 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 80,516 270,720 30% 352 Forfeits various 3,455 875 2,775 4,570 11,675 258,820 5% 354 Ordinance Violation various 1,305 2,165 4,133 2,313 9,916 35,500 28% 360 Morris PAC various 52,561 22,635 129,679 31,466 236,340 934,900 25% 360 Palais Royale various 22,259 6,290 10,385 18,475 57,409 243,820 24% 360 Parks & Recreation various 26,797 14,565 4,051 10,548 55,962 106,700 52% 360 Police various 3,170 4,378 2,510 1,609 11,667 46,600 25% 360 TIF various 5,056 2,657 3,480 3,373 14,566 44,806 33% 360 Central Services 222 19,705 3,212 15 320 23,252 11,000 211% 360 Century Center 670 5,117 4,970 35,471 3,054 32,565 25,000 - 130% 360 Dept Of Community Investment 2111212 95,353 85,179 2,438 182,970 249,500 73% 360 EMS Operating Fund 288 60 60 5,000 1% 360 Engineering /Curb & Sidewalk 101 209 200 32,648 500 31,739 22,000 -144% 360 Fire and Police Pension Fund 7011702 3,743 3,743 4,000 94% 360 Self Funded Employee Benefits 711 6,000 6,000 NA 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 15,296 50,000 31% 360 Local Roads and Streets 251 14,730 14,730 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 Aphl 2015 - Revenue Report Page 4 025 City of South Bend Period Ending: April 30, 2015 Revenue by Type Report 240,300 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 6,369 53,000 12% 360 Water Works Utility 620 908 1,318 17 2,243 39,580 6% 362 Dept Of Community Investment 212 1,847 1,847 NA 362 Palais Royale 101 572 2,269 2,588 10,146 15,575 72,000 22% 362 Parks & Recreation 201 2,064 4,531 4,138 4,574 15,307 40,000 38% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 15,621 17,156 19,059 30,447 82,283 339,025 24% 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 548,500 3,032,126 18% 399 Bosch Retention Project 210 59,966 0% 399 Principal on Loan various 1,799 20,705 18,387 19,002 59,892 207,398 29% 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 23,609,404 77,599,646 30% iterest Income 361 Bank Account Interest various 197,258 51,054 75,698 118,454 442,465 768,636 581, Sub Total 197,258 51,054 75,698 118,454 442,465 768,636 58`, onations 367 ND Contribution 101 405 405 330,000 0`, 367 Donations various 2,072 990 46 3,107 246,206 1`, Sub Total 2,072 990 405 46 3,513 576,206 1`, istoric Preservation 368 Lamp Program 227 19,750 5,750 25,500 30,000 85`, 368 Palais 450 1,225 3,703 357 982 6,267 16,000 391, Sub Total 1,225 3,703 20,107 6,732 31,767 46,000 69`, Revenue Total 12,866,555 16,029,980 18,739,220 15,892,928 - - - - - - - - 63,528,682 285,088,092 22% report 12,866,555 16,029,980 18,739,220 15,892,928 - - - - - - - - 63,528,683 285,088,092 0 0 0 1 1 Financial Report Apn12015 -Revenue Report Page 5025 City of South Bend Revenue by Fund Report Period Ending: April 30, 2015 s i Fund Jan I Feb I Mar I Apr I May Jun I Jul I u Se P I Oct Nov Dec I Year I Bud et I ofeud et General Government 0000 General Revenues 101 1,167,120 944,443 669,668 734,592 3,515,823 50,195,282 7% 0101 Mayor 101 35 15 50 600 8% 0104 311 Call Center 101 55,195 36,290 43,995 32,989 168,469 486,733 35% 0301 Common Council 101 41 31 15 231 317 8,455 4% 0401 Administration and Finance 101 220 336 556 50 1112% 0501 Legal 101 508 18,113 18,620 53,000 35% Sub Total 1,222,390 981,491 714,030 785,924 3,703,836 50,744,131 7% Public Works 0602 Engine rin 101 225 303 528 77,027 1 Sub Total 225 303 528 77,027 1% Public Safety 0801 Police 101 6,604 11,372 38,367 2,321 58,664 537,700 11% 0901 Fire 101 10,022 59,625 37,787 11,021 118,455 12000 987% Sub Total 16,625 70,998 76,154 13,343 177,119 549,700 32% 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 236,895 923,000 26% 0405 Palais Royale 101 24,368 9,347 13,572 30,163 77,450 334,820 23% Sub Total 77,697 3Z647 141,998 62 003 314,345 1,257,820 25% General Fund Revenue Total 1,316,569 1,085,136 931,673 861,573 - - - - - - - - 4,194,952 52,628,678 8% Financial Report April 2015. &p-dk- Summary Page 6 of 25 City of South Bend Revenue by Fund Report Period Ending: April 30, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun Ug I SP Nov Dec I Year I Budget I ofBUd et Parks & Recreation 0000 Parks General revenue 201 76,460 74,383 77,445 74,566 302,855 8,860,875 3% 1100 Administration 201 2,119 4,537 4,158 4,527 15,342 40,600 38% 1101 Maintenance 201 19,996 2425 3,330 1,823 27,573 319,600 9% 1102 GolfOperations 201 161 63,205 31,916 147,893 243,176 1,535,000 16% 1103 Recreation Division 201 26,067 16,036 5,765 54 47,922 185,640 26% 1104 Potawatomi Zoo 201 NA 1108 Grafd Removal 201 11,341 13,003 24,344 89,000 27% Recreation Non Reverting 203 65,607 98,601 lIZ441 78,613 355,262 1,578,935 23% East Race Waterway 271 5 1 2 3 11 NA Coveleski Stadium 401 36 9 14 23 82 15,100 1% Zoo Endowment 403 43 11 17 28 100 200 50% Park Non Reverting 405 4,435 260 261 1,080 6,036 143,700 4% Sub Total 194,930 270,809 235,349 321,616 1,022,703 12,768,650 8V Public Works Motor Vehicle Highway 202 716,020 1,133,459 404,476 730,770 2,984,726 9,681,300 31% Central Services 222 655,888 688,603 709,665 623,157 2,677,314 8,121,097 33% Central Services Capital 224 271,850 0% Local Roads & Streets 251 87,782 90,155 98,666 112 757 389,361 1,593,300 24% Pro'ect ReLeaf 655 37,371 36,419 36,757 37,059 147,607 431,700 34% Sub Total 1,497,062 1 948 636 1,249,565 1 503 744 6,199,007 20 099,247 31% Public Works Solid Waste Solid Waste Operations 610 408,178 401,846 406,879 589,225 1,806,129 5,71Z289 289 32% Solid Waste Capital 611 190,033 10,001 84,001 284,035 753,011 38% Sub Total 598,211 401,846 416,880 673,226 Z090,163 6,465,300 32% Public Works Water Utility 0000 Water Works Revenues 620 916,194 910,250 905,299 929,577 3,661,319 12 704,463 29% 0630 Water Leak Insurance 620 80,558 79,817 80,181 74,113 314,668 960,000 33% 0660 Clay Water 620 68,898 68,829 66,186 76,543 280,456 1,096,020 26% Waterworks Capital 622 Z 776 682 1,098 1,741 6,297 10,000 63% Waterworks Construction 623 180 41 62 83 366 NA Waterworks Deposit 624 1,307 324 527 854 3,011 6,000 50% Waterworks Sinking 625 468 340,551 170,359 170,557 681,935 2,050,078 33% Waterworks Bond Reserve 626 1,425 353 572 2351 NA Waterworks Debt Reserve 629 1,840 150,683 775 1,279 154,576 16Z 749 95% Sub Total 1,073,645 1,551,529 1,225,058 1,254,745 5,104,978 16,989,310 30% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 51,853 52,790 50,328 52,269 207,240 549,200 38% 0000 Wastewater Revenues 641 2,628,692 2,622,801 2,675,830 2,753,646 10,680,970 33,197,505 32% 0621 Sewer Department 641 998 998 2,000 50% 0625 Concrete Crew 641 4,705 4,705 75,000 6% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 157,337 162,329 150,270 180,708 650,645 2,059,962 32% Sewage Capital 642 3,385 815 1,313 2036 7,548 5,398,000 0% Sewage Reserve 643 3,020 256,833 1,248 2,104 263,205 250,612 105% Sewer Bond 2007 647 NA Sewage Bond Sinking 649 774,321 773,801 774,198 775,158 3,097,479 9,288,088 33% Sewer Bond 2007B 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 2,653 6,000 44% 2012 Sewer Bond 661 14,968 3,669 5,897 9,437 33,972 20,000 170% 2013A Sewer Refund Bonds 664 4 1 2 3 9 NA Sub Total 3,635,057 3,878,074 3,659,472 3,776,819 14,949,421 50,846,367 29% Financial Report April 2015. &p-dk- Summary Page 7 of 25 City of South Bend Revenue by Fund Report Period Ending: April 30, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I u Se P 1 Oct Nov Dec I Year I Budget I ofeud et Public Safe - Police 601 909 909 4,000 23% Police Seizures 216 162 41 876 108 1,187 35,900 3% Curfew Violations 218 11 3 17 7 37 1,025 4% Law Enforcement Education 220 24,859 28,459 17,376 64,238 134,932 211,000 54% Public Safety LOIT 249 540,008 539,058 430 1,078,221 2,157,717 6,472,190 33% Excess Welfare Public Safety 252 0 - - - 0 15.900 NA Police Take Home Vehicle 278 14,575 9,474 9,529 9,591 43,159 124,200 35% Police Block Grant 280 3 1 1 2 8 NA Police Grants 292 55 56,891 56,947 90,000 63% Police cademy 294 11,010 7,628 1,101 893 20,632 22,000 94% COPS More Grants 295 564 782 681 33,633 35,659 128,258 28% Drua Enforcement 299 1,817 83 31,713 12,542 46,154 77,000 60% K -9 Unit 705 503 1 1 2 507 2,000 25% Sub Total 593,567 585,530 61,724 1,256,127 2,496,948 7,163,573 3551 Publie Safe - Fire Emerge' Telephone System 244 19 19 20 97% ital 287 396,727 13 206 396,947 750,000 53% erafin Fund 288 204,337 16 9,122 667,161 441,484 1,482,104 5,676,065 26% 289 3 732 10 095 10 18 13 856 f0 000 139% scue 291 3,093 Z423 3,038 651 9,206 45,200 20% Sub Total 211,182 578,368 670,222 44Z360 1,902,132 6,481,285 29% Department of mmunity Investment Studebaker /0liver 209 959 3,612 16,720 20,676 41,967 644,000 7% State Grant 210 290 70 112 181 654 3,673,510 0% ,,CI Operating 211 14,699 503,257 17,090 72,469 607,515 Z 634,125 23% 0000 Dept of Community Investment 212 3,790 12Z 753 240,619 202 172 569,334 4,100,000 14% xxx Programs 212 95,353 95,353 NA 0000 Economic Revenue Bond 281 24 6 10 16 55 NA Sub Total 115,115 629,699 274,551 295,513 1,314,878 11 051,635 12% 0000 Parking Garage Revenue 601 909 909 4,000 23% 0460 Main Street 601 20,879 17,180 24,111 20,473 82,643 267,487 31% 0462 Leighton Plaza 601 38,528 22,329 36,745 34,605 132,208 451,691 29% 0463 Enforcement 601 5,219 7,017 6,595 8,281 27,111 114,900 24% 0464 Wayne Street 601 17,498 16,724 22,424 12,234 68,880 254,748 27% 0465 Eddv Street Commons 601 - - - - - 15.900 0% Financial Report April 2015. &p-dk- Summary Page 8 of 25 City of South Bend Revenue by Fund Report Period Ending: April 30, 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 Other Miscellaneous Rain Da 102 7,630 1,888 3,064 4,949 17,531 34,680 51% Excess Le 103 1 1 2 4 NA Gift Donation Bequest 217 1,618 989 364 80 3,051 223,800 1% Loss Recovery 227 5,206 4,007 21,727 8,608 39,549 50,000 79% Human Rights 258 2,065 7,188 5,759 3,628 18,639 203,400 9% Morris Palais Marketing 273 274 6 1,373 366 2,018 18,000 11% Professional Sports Development 377 93,375 142,965 63,547 36,086 335,974 671,761 50% 1201 Code Enforcement 600 18,559 529,948 11,282 46,664 606,453 2,378,996 25% 1207 Animal Control 600 3,725 162,197 5,846 6,503 178,271 689,218 26% 1306 Building Operations 600 66,158 54,907 181,599 96,899 399,563 1,085,899 37% Century Center 670 32,985 783,504 203,146 211,537 1,231,172 4,532,562 27% Century Center Capital 671 24 21 23 22 90 500 18% Century Center Energy Saying 672 50,000 0% Sub Total 231,619 1,687,621 497,732 415,343 2,832,315 9,938,816 28% Business Insurance 0000 Business Insurance Revenues 226 104,344 103,108 103,815 107,554 418,820 1,243,227 34% 0418 Workers Compensation 226 17,000 0% Sub Total 104,344 103,108 103,815 107,554 418,820 1260,227 33% 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 4,903,528 16 223,345 30% Unemployment Comp 713 8,685 8,526 8,559 8,613 34,382 226,796 15% Cemetery Trust 730 25 6 10 16 58 150 38% Sub Total 1,259,249 1 235 119 1,226,689 1 223 071 4,944,130 28 021,883 18% Civil City Revenues 12,653,540 15,953,113 10,816,094 15,511,366 - - - - - - - - 54,934,113 248,583,125 22% Tax Increment Financing TIF Airport 324 50,350 33,228 6,479,376 346,205 6,909,160 24,988,606 28% TIF Central Development 420 695 4,240 (4,935) NA TIF West Washington 422 996 261 423 675 2,355 422,000 1% TIF Leighton Plaza 425 18,229 12,971 10,040 21,366 62,605 189,123 33% TIF Medical Service 426 1,941 501 (2,442) 0 NA TIF Northeast 429 23,215 993 1,434,000 2,685 1,460,894 3,829,653 38% TIF Southside 430 4,144 1,025 1,590 2,545 9,303 2,410,000 0% TIF Erskine Village 432 5,246 1,268 1,967 3,083 11,564 25,000 46% TIF Douglas Road 435 161 48 23 30 261 320,750 0% Northeast Residential TIF 436 1,215 352 5 1,571 2,604,000 05, Sub Total 106,191 54,887 7,920,047 376,589 8,457,713 34,789,132 24% Financial Report April 2015. &p-dk- Summary Page 9 of 25 City of South Bend Revenue by Fund Report Period Ending: April 30, 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 ofeud et Redevelopment Commission 213,015 76,867 7,923,126 381,562 - - - - - - - - 8,594,570 36,504,967 24% City Operations Total 12,866,555 16,029,980 18,739,220 15,892,928 - - - - - - - - 63,528,683 285,088,092 22% Revenue report 12,866,555 16,029,980 18,739,220 15,892,928 0 0 0 0 0 0 0 0 63,528,683 285,088,092 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report Apol 2015. Expenditure Summary Page 10 of 25 City of South Bend Property Tax Revenue 2013 Tax Pay 2014 Fund Period Ending: April 30, 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 April 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 April 2015 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending: April 30, 2015 Expenditure Report S i 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 vemment ryor 101 80,464 52,550 48,452 55,723 237,189 741,267 1 Call Center 101 55,195 36,290 43,995 32,989 168,469 486,733 erk 101 34,775 28,270 26,114 26,345 115,504 431,573 immon Council 101 33,803 24,869 110,974 30,970 200,616 490,150 NIT Contract 101 411 411 43,000 Iministration and Finance 101 187,531 134,271 139,736 136,435 597,972 2,020,544 gal Department 101 99,178 73,129 64,725 70,589 307,621 1,006,979 ib Total 490,946 349,379 433,994 353,052 1,627,371 5,220,246 cs igineering 101 72,931 79,671 89,919 62,192 304,712 1,058,933 ib Total 72,931 79,671 89,919 62,192 304,712 1,058,933 ty dice 101 2,557,412 1,878,728 1,990,424 1,850,902 8,277,467 25,633,064 lice -PS LOIT funded 101 2,562 6,199 (8,761) Mice Communications 101 135,031 97 8 514,528 649,664 1,687,540 •e 101 2,150,469 1,590,349 1,505,644 1,328,213 6,574, 675 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 15,502,217 45,095,078 cement ode 101 2,270 ode Unsafe Building 101 ode Animal Control 101 ib Total 2 270 Ire nris PAC 101 96,838 87,590 80,670 75,338 340,436 1,093,132 dais Royale 101 41,912 31,105 39,827 31,888 144,732 536,293 ib Total 138,749 118,696 120,497 107,226 485,168 1,629,425 Ws iman Rights 101 50,323 31,896 19,693 30,347 132,260 373,179 ib Total 50,323 31,896 19,693 30,347 132,260 373,179 General Fund Expenditure Total 5,598,836 4,055,015 4,151,418 4,246,460 - - - - - - - - 18,051,729 53,379,131 34% Financial Report April 2015. &p-dk- Summary Page 13 of 25 City of South Bend Period Ending: April 30, 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 Parks & Recreation Motor Vehicle Highay 1100 Administration 201 104,226 71,673 67,013 81,921 324,833 967,568 34% 1101 Maintenance 201 435,157 348,338 455,082 344,569 1,583,146 5,178,905 31% 1102 Golfo eradons 201 66,821 76,812 203,778 123,539 470,950 1,573,436 30% 1103 Recreation Division 201 193,339 143,079 147,938 140,851 625,208 2,328,698 27% 1104 Potawatomi Zoo 201 392,247 lIZ389 8,788 7,968 521,391 863,017 60% 1106 Potawatomi Greenhouse 201 5,079 20,391 5,260 3,156 33,887 53,997 63% 1108 Graffiti Removal 201 9,057 7,116 5,887 7,268 29,327 98,374 30% Recreation Non Reverting 203 43,898 60,957 66,785 87,752 259,392 1,549,469 17% East Race Waterway 271 637 455 775 2098 2098 4,000 52% Coveleski Stadium 401 968,839 1,479,202 1,183,962 1,068,758 4,700,761 3,540 0% Zoo Endowment 403 _ _ _ _ _ _ _ _ _ _ _ _ _ 49,000 0% Park Non Reverting 405 - - - 2,197 2,197 192,933 1% Sub Total 659 1,249,824 840,754 960,531 801,319 3,852,428 12,862,937 30% Vorks Motor Vehicle Highay 202 734,565 950,683 835,051 410,155 2,930,454 8,843,890 Curb and Sidewalk 202 lIZ714 39,990 31,802 29,933 214,439 1,641,496 Central Services 222 679,565 621,835 691,937 716,505 2,709,842 8,300,242 Central Services Capital 224 4,000 9% Waterworks Capital 622 15,382 271,850 Local Roads & Streets 251 4,155 4,853 37,032 6,650 52,690 1,926,221 Project ReLeaf 655 15,357 2281 2386 27,010 47,035 528,358 Sub Total 324 1,546,355 1,619,642 1,598,209 1,190,253 5,954,458 21,512,057 Vorks Solid Waste Solid Waste Operations 610 635,488 341,051 339,903 382,803 1,699,246 5,873,863 Solid Waste Capital 611 223,749 143 11,054 83,702 318,648 752,811 Sub Total 859,237 341,194 350,957 466,506 2,017,894 6,626,674 Public Works Water Utility 0630 Water Leak Insurance 620 33,830 53,166 43,413 474 130,884 1,115,000 1291 0640 Water Works 620 906,773 1,320,043 1,131,090 1,058,030 4,415,936 14,725,471 30% 0660 Clay Water 620 22 29,608 309 26 358 4,000 9% Waterworks Capital 622 15,382 67,463 3,489 1,776,763 86,334 838,893 10% Waterworks Construction 623 11,278 37,750 4,276 438 53,743 53,085 1017 Waterworks Deposit 624 452 324 527 854 2,156 6,000 36% Waterworks Sinking 625 465 1 84 282 832 2,050,078 0% Waterworks Bond Reserve 626 1,045 747 1,248 7,374 7,374 15,000 NA Waterworks Debt Reserve 629 637 455 775 1,279 3,145 8,500 37% Sub Total 649 968,839 1,479,202 1,183,962 1,068,758 4,700,761 18,801,027 25% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 21,449 57,144 43,434 46,092 168,119 545,703 31% 0621 Sewer Repair 641 446,632 360,251 404,056 284,993 1,495,932 5,201,049 29% 0625 Concrete Crew 641 44,148 29,608 25,634 23,472 122,863 450,450 27% 0630 Wastewater Operations 641 2,004,256 2,110,111 1,803,497 1,776,763 7,694,627 31,017,413 25% 0631 Organic Resources 641 69,307 56,543 60,055 54,333 240,238 1,527,562 16% 0650 Clay Sewage 641 28 103 106 236 500 47% Sewage Ca ital 642 39,115 47,104 402228 2254 490,702 9,071,710 5% Sewage Reserve 643 1,045 747 1,248 2,104 5,144 15,000 34% Sewer Bond 2007 647 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA Sewage Bond Sinking 649 1,000 850 1,850 9,282,109 0% Sewage Bond 2007 651 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 2010 CSO Net Sewer Bond 658 - - - - - - - - - - - - - - NA 2011 Sewer Bond 659 143,037 50Z 799 246,856 184,257 1,076,950 3,711,838 29% 2012 Sewer Bond 661 39,170 249,076 234,187 81,154 603,586 16,624,275 4% 2013 Sewer Bond 663 NA Sub Total 2,809,188 3,414,232 3,221,297 2,455,529 11,900,246 77,447,609 15% Financial Report April 2015. &p-dk- Summary Page 14 of 25 City of South Bend Period Ending: April 30, 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 StudebakeLVOliver Seizures 216 750,000 EMS O eratin Fund 288 247,977 32,280 210,228 382,360 35,900 0% Violations 218 20,939 602 21,542 31,530 River Rescue 1,000 0% forcement Education 220 15,730 29,274 27,290 24,802 97,095 362,478 27% nc Tele hone S stem 244 20 1 21 212 183,750 365,625 NA Safe LOIT UE-ergency 249 73 2,055 515,347 549,323 505,155 2,301,880 7,246,551 32% Welfare Pu61ic Safet 252 Sub Total 369,417 329,268 372,756 1,146 0% Take Home Vehicle 278 55,859 153,529 335,865 138,115 683,367 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 24,317 23,750 102% More Grants 295 20,490 784 4,485 1,262 27,022 172,335 16% Dnfa Enforcement 299 18,385 6,474 18,397 6,844 50,100 248,960 20% K -9 Unit 705 2,899,524 2,754,112 970 888,116 970 2,000 49% Sub Total 789,405 576,850 600,685 549,741 2,516,681 8,270,365 30% sfe - Fire EMS Ca ital 287 StudebakeLVOliver 35,728 35,728 750,000 EMS O eratin Fund 288 247,977 32,280 210,228 382,360 872,844 6,855,366 Hazmat 289 20,939 602 21,542 31,530 River Rescue 291 0 2,120 21,395 854 24,369 120,800 Sub Total 2,661,730 268,916 70,730 231,622 383,215 954,483 7,757,696 ent of Community Investment StudebakeLVOliver 209 16,261 3,375 6,335 10,054 19,764 630,000 State Grant 210 12,200 24,311 18,003 24,096 30,203 3,694,412 DCI Operating 211 250,396 178,976 186,881 187,235 803,489 2,661,730 Dept, of Community Investment 212 102,720 134,503 161,537 515,770 914,530 5,899,970 Administration 212 183,750 365,625 50% EDIT 408 15,900 Programs 212 4,101 12,414 64,293 36,871 16,514 647,998 Sub Total 369,417 329,268 372,756 713,059 1,784,500 13,534,110 Garages Main Street 601 16,261 29,534 14,520 689 61,004 262,391 Leighton Plaza 601 16,812 24,311 21,634 24,096 86,852 696,570 Enforcement 601 1,340 31,872 16,253 335 49,801 89,236 Wayne Street 601 54,617 27,884 11,887 11,750 106,138 742,615 Eddy Street Commons 601 183,750 365,625 50% EDIT 408 15,900 Sub Total 126,960 89,030 113,600 64,293 36,871 303,794 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 3,353,041 15,660,371 21% Cum Capital Development 406 112,650 56,546 169,196 542,691 31% Cum Ca ita /Improvement 407 183,750 183,750 365,625 50% EDIT 408 577,062 1,795,231 126,960 154,855 2,654,108 9,627,618 28% UDAG 410 146,068 146,068 438,203 33% Major Moves 412 55,859 153,529 335,865 138,115 683,367 3,096,061 22% 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% HMiof Fame Ca ital 677 6,843 6,370 5,998 4,253 23,464 188,824 12% Sub Total 2,899,524 2,754,112 1,337,096 888,116 7,878,848 31,922,611 25% Financial Report April 2015. &p-dk- Summary Page 15 of 25 City of South Bend Period Ending: April 30, 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 Other Miscellaneous Self Funded Liability Ins Gift Donation _Bequest 217 26,675 27,830 136 24,917 52,882 297,182 18% Loss Recovery 227 181,590 298,680 822,026 396,131 1,698,426 5,237,243 32% Human Ri hts 258 22,061 9,167 26,033 11,344 68,605 247,357 28% Morris Palais Marketin 273 377,939 96 Sub Total 2,358 2,454 18,974 13% ProfessionalSports Development 377 480,773 800 2,294,533 2,019,201 481,573 854,803 56% 1201 Code Enforcement 600 120,449 101,851 94,621 183,959 500,880 2,414,485 21% 1207 Animal Control 600 57,484 47,550 49,635 42,055 196,723 696,216 28% 1306 Building Operations 600 104,444 75,646 91,217 76,910 348,217 1,094,700 32% Century Center 670 306,497 285,449 289,304 326,417 1,207,667 4,532,562 27% Century Center Capital 671 1,464,000 66,156 66,156 308,156 21 Sub Total 1,273,296 913,225 1,372,972 1,064,090 4,623,584 15,701,678 29% s Insurance Self Funded Liability Ins 226 26,134 26,675 14,630 19,531 86,970 282,900 Liability Insurance 226 156,054 7,585 32,230 286,937 482,806 1,184,891 Business Insurance 226 15,927 14,875 21,403 1,739 53,944 600,000 Workers Compensation 226 64,123 206,418 63,790 43,608 377,939 989,000 Sub Total 730 262,238 255,553 132,053 351,815 1,001,660 3,056,791 Trust & A enc Fire Pension 701 441,192 441,276 450,317 433,126 1,765,911 5,666,579 Police Pension 702 537,112 524,012 559,034 535,159 2,155,317 6,832,235 Employee Benefits 711 1,030,771 963 626 1,093,990 1 462 313 4,550,699 16,696,935 Unemployment Comp 713 10,126 5,167 9,025 7,309 31,628 226,796 Cit Cemetery Trust 730 45,881 154,716 30% TIF Medical Service 426 20,000 Sub Total 2,294,533 2,019,201 1,934,080 2,112,366 2,437,907 8,503,555 29,442,545 Civil City Expenditure 21,003,306 18,697,459 17,690,217 16,653,639 - - - - - - - - 74,044,621 302,121,943 25% Tax Increment Financing TIFAir ort 324 2,276,439 1,684,991 1,736,337 586,596 6,284,363 47,710,597 13% 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 45,881 154,716 30% TIF Medical Service 426 2,294,533 2,294,533 2,476,033 93% TIF Northeast 429 112,956 5,000 16,291 134,247 7,239,524 2% TIF Southside 430 435,370 24,431 62,420 38,892 561,113 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,710,589 3,425,632 50% Sub Total 5,617,288 1,400,070 8,200,393 660,631 15,878,382 70,183,875 23% Financial Report April 2015. &p-dk- Summary Page 16 of 25 City of South Bend Period Ending: April 30, 2015 Expenditure Report S i 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 laud et �elo ment Funds Adminlstratlon 433 6,000 Certified Technology Park 439 198 405,121 405,319 5,000,000 Blackthorn Golf Operations 619 69,055 89,358 22,845 181,258 1,671,706 Sub Total 69,055 89,358 23,043 405,121 586,576 6,677,706 Cervlce Airport Debt Reserve 2003 315 317 227 368 594 1,506 5,000 Central Development reserve 328 530 379 615 993 2,517 6,000 Sub Total M 847 606 983 1,587 4,023 11,000 Financial Report April 2015. &p-dk— Summary Page 17 of 25 Redevelopment Commission 5,687,190 1,490,033 8,224,418 1,067,340 - - - - - - - - 16,468,981 76,872,581 21% City Operations Total 26,690,496 20,187,492 25,914,635 17,720,979 - - - - - - - - 90,513,602 378,989,838 24% Expenditure report 26,690,496 20,187,492 25,914,635 17,720,979 0 0 0 0 0 0 0 0 90,513,602 378,989,838 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report April 2015. &p-dk— Summary Page 17 of 25 City of South Bend Period Ending: April 30, 2015 Debt Schedule Yearof I Yearof Yearof Schetluletl Payments Debt /Ong /Rehr 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 lmwovaments 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 Sawaga 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 Cent- Center Special Tax Bonds Cenlury 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 Sawa oa Works Revenue Bonds - 2009 Sawaga 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 Sawa ge 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 101 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. 20, 3A 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 Corborabon 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 Monthiv 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 mprovements at Century 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 R-INI g 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 Intarfund 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 06/1 1211 - - 24.09 .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 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 549.064 ]s 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- Tach -licav 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 Technolwv 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 Kav 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 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 Eaul -ent 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- Tachnoloav Fire Debart-t Cagier 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 Cagier 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 Strest/Sawer 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/Eaunbment 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 06/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 City 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 Eauabment 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 Computes Eauabment Lease 2014 2018 620 Monffi 8th 1.326.00 1.302.13 294.22 42.62 0.00 1.007.91 336.84 13p Solid Waste Career 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 131 Police Communications Career 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 Career - Nodh Station Ricoh USA Careers 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 Computer 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 Career Ricoh USA Careers 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: April 30, 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 sole Pa wit AtltllOOn 121312015 Debt Pa ments Retlevelopment 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 Taxinq Dist ct 2002 2014 2022 324/404/414 1/1 7/1 - - 6.620.000.00 3.010.000.00 395.000.00 86,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 Airoad 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 620.000.00 134.802.50 0.00 2,295,000.00 754,802.50 104 2012 Gates Dovmtown Campus VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 1.700.000.00 566.666.68 566.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 Improvements Coveleski Stadium 2014 2018 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 Totafeontl 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 Property 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 tnfordive) 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.09 47.003.09 1.175.08 0.00 0.00 48,178.17 64 Interfund FUnd412- MaiorM -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 -Maior 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 -Maior 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 Brownfield Proieal 2011 2020 324 8/9 - - - 500.000.00 500.000.00 0.00 0.00 0.00 500.000.00 0.00 86 Blackthorn Loan from Airport Blackthorn Equip (mowers) 2011 2016 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 Lesses 37 Transoo 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 /Colas Garage 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: April 30, 2015 Monthly Debt Schedule Yearof I Yearof Yearof Schetluhuf Payments Debt /Org /Rani Debtaf YTD Pdnclpal YTD lnlenast YTD Debtat Debt lnsWment Debt PU Issue Refuntlin Mafi w Fund 1st 2ntl 3n1 4th Issue 12/31/2014 P.,_. Pa ants AtltliOOns I 4/30/2015 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 ?9 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 0.00 0.00 0.00 3.750.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 9? Sewage 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 992012Water 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 Coroorabon 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 41.125.84 25.317.20 0.00 2.616.570.66 I. 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.646.125.84 531.730.83 4.167.897.00 145.130.854.66 Loans Payable ss State R-INI . 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 s2 Interfund Lean 410 - UDAG 1 st Sourca/Mamott Garage 2010 2015 410 6/15 12115 - - 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.095.000.00 0.00 0.00 0.00 0.00 0.00 zs State Revolving 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 Capital Leases st Chase LED Eauipment 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 ]z 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 ,e Kansas State Bank Central Be,!- Copier 2010 2015 222 2116 5/16 8/16 11116 13.366.40 1.496.90 742.99 22.01 0.00 753.91 n GE Capital Infonnst- Tach -licav Animal Control Copier 2010 2015 101 2128 5/30 8/30 11130 3.550.69 403.62 199.77 4.08 0.00 203.85 ]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 Central Services Duplicator 2010 2015 222 1/15 4/15 7/15 10115 10.511.02 2.455.77 1.200.63 97.05 0.00 1.255.14 s] Public Finance- Inc Solid Waste Containers /crocks 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 3115 6/15 9/15 12115 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 3115 6/15 9/15 12115 207.432.00 74.504.09 10.511.27 310.12 0.00 63.992.82 n 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 M- Ricoh MP 2851 SP Copies 2011 2016 101 2115 5115 8115 11115 2.569.53 1.110.31 132.03 15.09 0.00 978.28 as Sun Trost Eauipment Finance Parks -Goff Co. Lease 2012 2016 201 4/15 10115 - - 344.500.00 131.862.30 43.603.35 1.057.89 0.00 88.258.95 a7 Sun Trust Eauipment Finance Police Vehicles &Eautpmont 2012 2 1 406 5/15 11115 - - 1.295.000.00 661.712.34 0.00 0.00 0.00 661.712.34 as PNC Eauipment Finance Pubic Works Vehicles Lease 2012 201] 202/641/640 5/15 11/15 - - 945.674.38 481.717.95 0.00 0.00 0.00 481.717.95 0o PNC Eauipmon[Finance Public Works Vehicles Lease 2012 201] 202641/600/286 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 383.54 57.10 0.00 2.786.56 pp GE Capital lnfor t- Tachnoloav Fire Department Caviar 2012 2 1 101 2128 5/26 8/28 11128 5.471.01 3.205.85 270.55 47.15 0.00 2.935.30 pa Ricoh USA Central Services Caviar 2013 2018 222 2127 5127 8/27 1127 3.622.78 2.315.31 188.32 21.62 0.00 2.126.99 s] Ricoh USA Sbest/Sawer Deal Copier 2013 2018 202641 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 -Cooler 2013 2018 101 2112 5/12 8/12 11112 5.559.15 3.492.63 283.90 33.80 0.00 3.208.73 o& Ricoh USA Parks & Rac Ricoh Cod -431 2013 2018 201 2121 5121 8121 1121 16.129.94 10.132.91 823.82 97.99 0.00 9.309.09 1. PNC Eauipment Finance V. ide/Eauianent Lease 2013 2018 1011202406/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 1213 10.667.67 6.790.21 501.90 146.10 0.00 6.288.31 12 Ricoh USA Buildinq Debt. Copier 2013 2018 600 Monffi - - 4.093.64 3.109.92 257.45 55.55 0.00 2.852.47 1s Sun Trust Eauipment Finance Police and PW vehicles 2013 2018 4041655/611/202 4/24 10/24 1.506.465.26 1.214.609.68 147.664.79 9,262 .78 0.00 1106:944.89 t4 Ricoh USA Adman & Finance Copier 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 Debt. Racem Div. Ricoh Police Records Copier 2013 2018 101 MonfN 3rd - - 9.678.26 7.950.10 597.56 142.44 0.00 7.352.54 fa Water Works Main Ricoh Copier Water Works Main Ricoh Cooler 2013 2018 620 MonthN 10th - - 5.647.50 4.639.36 348.61 83.19 0.00 4.290.75 f& Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Conte 2013 2018 620 Man thN 16th - - 4.732.65 3.887.84 292.13 69.71 0.00 3.595.71 12o Water Works Olive Ricoh Cooler Water Works Olive Rtcah Cooler 2013 2018 620 MonthN 10th - - 4.732.65 3.887.84 292.13 69.71 0.00 3.595.71 2a Police Train no Dept. Ricoh Copier Tminina Carver 2014 2019 101 MonthN 30th - - 4.263.00 3.714.38 260.43 67.57 0.00 3.453.95 24 Kev Govemment 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 Comvutor Eauipmont Lease 2014 2016 MpnlhN 8th - - 137.104.95 124.554.02 9.794.47 1.813.65 0.00 114.759.55 1ze HP Computer Lease #2 Computer Eauarr ant Lease 2014 2018 201 and 620 M.nlhN 8th - - 4.000.00 3.720.95 284.39 55.77 0.00 3.436.56 z] HPComr.ter Lease#4 Computer Eauipment Lease 2014 2018 404 MonlhN 8th - - 5.886.15 5.461.99 430.25 68.43 0.00 5.031.74 1ze HPComr.ter Lease#6 Co..tar Eauipment Lease 2014 2018 201 Monffi 8th - - 3.755.50 3.561.10 262.90 56.14 0.00 3.298.20 za HP Computer Lease #7 Comunder Eauarr ent Lease 2014 2018 620 MonlhN 8th - - 1.326.00 1.302.13 96.22 16.06 0.00 1.205.91 13p Solid Waste Career Ricoh USA Gooier 2014 2019 611 M.nlhN 17th - - 5.351.65 5.351.65 390.99 121.36 0.00 4.960.66 ... Police Communications Career Ricoh USA Carter 2014 2019 101 M.nlhN 12th - - 8.843.00 8.196.86 527.86 149.42 0.00 7.669.00 13z Omani. Resources & W ast --ter Ricoh USA Coolers 2014 2019 641 M.nlhN 21 st - - 12.260.18 11.182.59 735.29 203.71 0.00 10.447.30 134 Water Works Career -North Station Richo USA Carters 2014 2019 620 MonlhN 19th - - 4.732.65 3.960.04 290.79 71.05 0.00 3.669.25 lea HP Computer Lease #B Computer EauIrrant Lease 2015 2019 404/201/611 MonlhN 16th - - 19.603.94 0.00 675.34 163.42 19.603.94 18.928.60 13] Animal Control Ricoh Career Ricoh USA Careers 2015 2020 600 MonlhN 30th - - 5.261.50 0.00 75.70 25.62 5.261.50 5.185.80 138 HP Computer Lease #9 Computer Eauapmont Lease 2015 2019 Various MonlhN TBD - - 135.958.05 0.00 0.00 0.00 135.958.05 135.958.05 too Vehide &Equip. Lease Vehids/Eauarrant 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 Ital Lease 20.039.664.26 9.670.744.40 1.335.780.21 79.059.13 3.586.097.07 11.921.061.26 ToteICNN CIfy 248.394.589.76 155.541.077.90 2.981.906.05 610.789.96 7.753.994.07 160.313.165.92 City of South Bend Period Ending: April 30, 2015 Monthly Debt Schedule Yearof I Yearof Yearof Schetluletl Payments Debf /Org /Rani Debtof YTD Principal YTD Interest YTD Debtat Debt lnsWment Debt PU Issue Refunding Matu w Fund 1st 2ntl 3n1 4th Issue 12/31/2014 P.,_. Pa enfs Atltlifions 1 4/30/2015 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 Soulh 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 Taxjnq Dist ct 2002 2014 2022 324/404/414 1/1 7/1 - - 6.620.000.00 3.010.000.00 0.00 0.00 0.00 3,010,000.00 5 Downlonn 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 Village 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 Cm leski 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 Acmt 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 Monthly 14th 293.788.00 257.238.04 257.238.04 535.91 0.00 0.00 122 Svnscogue 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 Tofal 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 Indiana Development Finance Authority Bosch Property (Nonfagive) 2001 2021 210 3/22 6/22 9/22 12/22 1.040.000.00 423.620.93 14.823.95 3.178.66 0.00 408,996.98 4 Intl Iana Development Finance Authority Bosch Property (Fomive) 2001 2021 210 - - 260.000.00 117.130.26 0.00 0.00 0.00 117,130.26 60 HUD Section 108 #8 Sludebaka 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 -Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1.040.319.00 886.677.00 99275.00 22.167.00 0.00 787402.00 83 interfund 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 Intedund FUnd 412 -Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2.000.000.00 1.513259.50 45238.41 15.132.60 0.00 1,468.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 Aimort 324 Pmine Ave Brownfield Project 2011 2020 324 819 - - - 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 Capffal Lease Total Ca hal Lease 0.00 0.00 0.00 0.00 0.00 0.00 Leases 37 Tmnsoo Lease Lejqhton 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 Tranam Lease Main /Colas Game 2006 2025 404 3/15 9/15 - - 2.510278.00 1.676.543.00 58.086.00 41.914.00 0.00 1,618,457.00 Total Lease 5.510278.00 1.867.890.00 58.086.00 41,914.00 0.00 1 1,809,804.00 Tofal Retlevelopment Commission 173.426.565.06 84.937.244.31 4.270.526.85 2.005.846.72 25.000.000.00 1 105,666,717.46 City of South Bend Staffing Headcount Summary City Total 1263.00 1255.00 1280.00 1299.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report April 2015 - Headcount Staffing Page 22 of 25 Budget Full Time 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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report April 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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 10 0.00 0.00 0.00 0.00 QWO 0.00 0.00 0.00 Financial Report April 2015 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Financial Report April 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 0.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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 4.00 7.00 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 3.00 3.00 3.00 3.00 0.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 0.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 0.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 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 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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report April 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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 11.00 10.00 9.00 16.00 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 27.00 27.00 27.00 27.00 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report April 2015 - Headcount Staffing Page 25 of 25