Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
04-2014 Financial Report
Tab Narrative Revenue Prop Tax Rev Expenditures Debt Debt Monthly Headcount Distribution Period Ending: Issued BY: April 2014 Controller City of South Bend Financial Report Page Contents 2 Brief discussion on notable fund activity 3 -10 City Revenues 11 -12 Property Tax Revenue Collection Status 13 -17 Expenditures by Fund and Department 18 -19 Debt Status 20 -21 Current Debt at Month End 22 -25 Staffing Levels Mayor Deputy Mayor Chief of Staff Deputy Chief of Staff Controller Deputy Controller City Finance Director Financial Specialist Senior Department Heads Fiscal Officers City Common Council Pete Buttigieg Mark Neal Kathryn Roos Brian Pawlowski John Murphy Jennifer Hockenhull Rahman Johnson Cecil Eastman Financial Report April 2014 Page 1 of 25 April 2014 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 20 %. In comparison, the overall percentage of collected revenue amount for April 2013 was 22 %. Revenue type 344 (State Grants), has reached 100% of its budgeted revenue. This is 911 revenue received by the county. This was formerly in the general fund and is now in fund 244 the Telephone Emergency System. Also, revenue type 350 (Job Target Penalty Fee) has reached 100% of its budgeted revenue. This is money received from AJ Wright for penalties due to the City. Revenue by fund As of April 2014, the general fund has received 8% of its budgeted revenue versus 14% last year. In 2013, the City made an early quarter transfer from the Public Safety LOIT fund to the general fund. This quarterly transfer was in the amount of $1,775,439.25 and was made in January 2013. Some following funds have reached 50% of their 2014 budgeted revenue amount: Fund 642 (Sewage Capital) is at 112% of its budgeted revenue. In January, a transfer from fund 641 was made for capital projects. Also in January, a transfer was made from fund 641 (Sewage Works Operations) to fund 643 (Sewage Reserve) per city policy. Fund 244, the Telephone Emergency System has reached 100% of its budgeted revenue. This is 911 revenue received by the county. This was formerly in the general fund. Property taxes Property taxes are received in June and December. Information on property taxes payable in 2014 will be available in the coming months. Total property taxes collected for the year 2012 was $72.9 million or 91.56% of the levy collection rate. For 2013, the projected levy collection rate is 95 %. The first distribution amount received was in June 2013 for $38.4 million compared to $39.5 million in June 2012. The second distribution amount was received in December 2013, in the amount of $31.5 million compared to $33.3 million in December 2012. Specifically, in 2013 the City of South Bend received a total of $45,189,966.17 in property tax revenue in the civil city funds (general fund, parks, College Football Hall of Fame, and CCD). This is a shortfall of -$3.7 million compared to 2012, in which $48.8 million was received. For TIF funds, the City received a total of $24,790,321.99 in property tax revenue. This is a surplus of $729,194 as compared to 2012, in which $24,061,128 was received. Overall, total property taxes collected in 2013 is -$70.0 million, which is a net reduction of $2.9 million from 2012. Information on property taxes payable in 2014 will be available in the coming months. Expenditures As of April 2014, the City has spent 24% of budgeted expenditures, versus 26% of budgeted expenditures in April 2013. The General Fund has spent 32% of its 2014 budgeted expenditures, compared to 31 % in 2013. 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), and fund 432 (TIF - Erskine Village). Fund 405 (Park Non Reverting) has spent 64% of budget due to capital improvement for the zoo. Debt In April 2014, several debt service payments were made in the amount of - $206,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 April, 2014 was 1,109 vs. a budgeted amount of 1,160. Currently, there are a total of 51 vacant positions; 31 open positions and 20 budgeted positions in the parks department that will not be filled due to privatizing of the Potowatomi Zoo. The remaining 31 open positions are in Public Safety (20), Public Works (5), Code Enforcement/ Animal Control (3), and other (3). City of South Bend Period Ending: April 2014 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et Property Tax 312 CREED Tax 312 Auto Excise Tax 311 Pro a Tax Civil City various 299 Liability Insurance 226 2,504,793 0% 45,307,800 0% 311 Pro a Tax TIF Districts various 216 335 State Pension Subsidy 882,628 0% 312 Financial Institutions Tax 26,325,126 0% 311 Pro a Tax Civil City - Prior various 439 377,765 NA 317 Hotel Motel Tax Century Center 670 656,725 NA 311 Property Tax TIF Districts - Prior various 1,313,436 50% 317 Hotel Motel Tax Century Center 420 2021251 200,000 NA xxx xxx xxx 50% 317 Hotel Motel Tax Cum Cap Im ry 407 233,496 266,072 38,577 NA Sub Total 101 55,845 222 47,661 45,989 71,632,926 0% Income Tax xxx 31% 380 335 Century Center 671 NA xxx xxx 315 Econ Development Income Tax -Prh 102 198,773 335 Wheel Tax 202 406,771 NA 342 EMS County Contract NA 315 Econ Development Income Tax 408 733,068 733,068 733,068 733,068 2,932,274 8,796,821 33% 316 Local Option Income Tax -PS 249 531,669 531,669 531,669 531,669 2,126,676 6,380,029 33% 316 County Option Income Tax 404 720,484 720,484 720,484 720,484 2,881,937 8,645,811 33% 316 County Option Income Tax -Prior Yr 102 3,470,989 33% 392 Internal Fund Transfers various 4,314,974 NA Sub Total 1,985,222 1,985,222 1,985,222 1,985,222 7,940,887 23,822,661 33% St Joseph Count Remitted b 312 CREED Tax 312 Auto Excise Tax various 299 Liability Insurance 226 2,504,793 0% 312 Commercial Vehicle Tax van.ous ite Drug 216 335 State Pension Subsidy 882,628 0% 312 Financial Institutions Tax van.ous 35,000 335 CTP Distribution 439 377,765 NA 317 Hotel Motel Tax Century Center 670 656,725 101 656,725 1,313,436 50% 317 Hotel Motel Tax Century Center 420 2021251 200,000 200,000 401,000 50% 317 Hotel Motel Tax Cum Cap Im ry 407 233,496 266,072 38,577 150,000 0% 101 55,845 222 47,661 45,989 335 Prof Sports Development Tax NA xxx xxx xxx 31% 380 335 Century Center 671 NA xxx xxx xxx 198,773 335 Wheel Tax 202 406,771 NA 342 EMS County Contract 101 136,239 136,239 136,239 136,239 544,956 1,588,824 34% xxx xxx xxx 380 459,805 585,235 495,555 NA Sub Total 251,882 136,239 792,964 136,239 336,239 1,401,681 6,840,681 20% State of Indiana (Remitted by) 312 CREED Tax 434 decal Drug 299 Liability Insurance 226 335 Cigarette Tax 1011407 5,304 75,000 ite Drug 216 335 State Pension Subsidy 7011702 General Government Misc Ch s 10,810 10,810 35,000 335 CTP Distribution 439 377,765 377,765 377,765 377,765 335 Gaming Proceeds 101 ntractual Service 211 13,419 11,183 335 Gasoline Tax 2021251 337,414 362,053 381,987 420,143 335 Liquor Excise tax 101 233,496 266,072 38,577 21,000,000 335 Liquor Gallonage Tax 101 55,845 222 47,661 45,989 335 Prof Sports Development Tax 377 66,547 113,592 31% 380 335 Century Center 671 204,221 185,484 b Total 198,773 335 Wheel Tax 202 406,771 109,590 74,990 25,841,975 xxx xxx xxx 417,491 380,370 1,646,942 4,632,222 Sub Total 380 459,805 585,235 495,555 466,132 governmental Sources decal Drug 299 Liability Insurance 226 235,157 5,304 5,304 75,000 ite Drug 216 33% 340 General Government Misc Ch s 10,810 10,810 35,000 yment in Lieu of Tax various 377,765 377,765 377,765 377,765 1,511,060 4,533,175 ntractual Service 211 13,419 11,183 29,006 57,869 111,477 198,800 nds various 151,160 281,678 233,496 266,072 932,406 21,000,000 nd premium 6611623 Central Service 222 47,661 49,015 46,909 47,019 K XXX 31% 380 Central Service 222 204,221 185,484 b Total 198,773 391,184 388,948 406,771 451,747 1,638,651 25,841,975 Charge for Service Internal City 340 Liability Insurance 226 235,157 235,157 241,463 238,310 950,087 2,859,690 33% 340 General Government Misc Ch s 101 160 160 NA 340 Police Take Home Vehicle 278 7,160 4,730 4,640 4,700 21,230 60,580 35% 342 EMS Capital 288 151,160 281,678 233,496 266,072 932,406 2,600,000 36% 349 Central Service 222 47,661 49,015 46,909 47,019 190,604 619,002 31% 380 Central Service 222 204,221 185,484 192,354 198,773 780,832 2,545,960 31% 380 Energy Office Reimbursements 222 417,066 432,016 417,491 380,370 1,646,942 4,632,222 36% 380 Internal Service Reimbursement various 138,730 122,721 267,168 251,882 780,501 2,156,750 36% 392 Administration Fee 101 289,249 289,249 289,249 289,249 1,156,996 3,470,989 33% 392 Internal Fund Transfers various 4,314,974 1,011,355 3,039,278 3,486,819 11,852,427 26,031,652 46% 395 Employee Benefits various 946,856 995,209 1,002,625 1,362,041 4,306,731 13,621,548 32% Financial Report Apn12014 - Revenue Report Page 3 025 City of South Bend Revenue by Type Report Period Ending: April 2014 S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et 396 Central Service Refunds 222 1,763 1,798 6,662 10,224 22,000 46% 396 Self Funded Employee Benefits 711 11,182 (99) 11,083 NA xxx xxx xxx NA Sub Total 6,753,998 3,608,413 5,746,016 6,531,797 22,640,224 58,620,393 39% 3rd Party Revenue 331 Federal Grants various 186,142 152,888 51,992 47,583 438,605 340 No EMS Service 101 334 State Grants 28,006 3,332 31,338 90,000 35% 340 Memorial Hospital Neo Natal 101 40,938 39,124 35,592 34,101 149,755 365,000 41% 350 Job Target Penalty Fee 408 354,660 653,605 4,733,787 354,660 354,660 100% 364 Cable TV Franchise Fees 101 180,787 180,787 750,000 24% 366 AT&T Franchise Fees 101 55,613 55,613 202,000 28% 380 Loss Recovery 227 NA 380 Bosch Reimbursement/ DCI 324 NA Sub Total 40,938 630,184 63,598 37,433 772,153 1,761,660 44% Grants 331 Federal Grants various 186,142 152,888 51,992 47,583 438,605 4,518,787 10% 334 State Grants various 215,000 215,000 215,000 100% 360 UDAG 410 NA xxx xxx NA Sub Total 401,142 152,888 51,992 47,583 653,605 4,733,787 14% Fees foi 320 321 321 322 322 322 322 341 342 342 343 344 344 344 344 344 346 346 346 347 347 347 349 349 349 349 351 352 354 360 360 360 360 360 360 360 360 360 360 360 360 360 360 Financial Report Apn12014 - Revenue Report Page 4 025 City of South Bend Period Ending: April 2014 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et 360 Fire 701 4201324 NA 360 Police Pension Fund 702 eter Hydrant Reimbursement 620 11,797 3,176 (150) 14,823 4,000 0% 360 General Government Various 101131226 36,377 803 202 37,382 1,100 3398% 360 P -Card Commissions 101 hicle Damage Reimbursement various 1,000 80,000 0% 360 General SBCDA Account 420 b Total 11,797 11,421 (150) 23,068 NA 360 Hall of Fame 3131677 NA 360 Motor Vehicle Highway 202 NA 360 Motor Vehicle Highway Scrap Meta 202 1,331 1,331 4,000 33% 360 Motor Vehicle Highway Curb Pr gm 202 6,563 8,579 4,684 1,803 21,630 25,000 87% 360 Parking Garage Fund 601 275 78 353 NA 360 ProfessionalSports Development 377 34,608 34,608 74,228 47% 360 Solid Waste Fund 610 1,389 1,389 1,000 139% 360 Waste Water 6411719 2,621 2,611 5,321 4,529 15,082 24,620 61% 360 Sewage Depreciation Fund 642 NA 360 Streets Scrap Metal Sale 101 NA 360 Water Works Utility 620 31,554 846 58 1,676 34,134 39,580 86% 362 General Fund 101 NA 362 Dept. Of Community Investment 212 1,847 1,847 3,694 NA 362 Palais Royale 101 2,490 990 1,848 1,825 7,153 84,000 9% 362 Parks & Recreation 201 1,329 2,226 5,680 4,781 14,016 43,900 32% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 14,675 17,473 10,973 25,185 68,306 201,951 34% 362 UDAG 410 NA 369 Memorial Hosp Leighton Plaza 408 150,000 0% 371 Century Center Fees 670 90,135 146,746 129,551 100,543 466,975 3,031,462 15% 399 Bosch Retention Project 210 14,387 14,387 58,203 25% 399 Principal on Loan various 19,196 21,428 1,967 35,031 77,622 195,349 40% 399 Principal Income xxx 186,218 41,443 227,661 556,798 4191 xxx xxx xxx NA Sub Total 4,937,828 5,353,133 5,089,003 5,409,190 20,789,153 70,123,276 30% ome nk Account Interest various 32,479 87,965 108,404 120,271 349,119 992,030 K XXX K XXX b Total 32,479 87,965 108,404 120,271 349,119 992,030 1 Contribution 101 330,000 nations van.ous 268 22,291 62 27 22,648 32,740 K XXX b Total 268 22,291 62 27 22,648 362,740 enervation lais 450 1,796 334 125 384 2,639 16,000 �neral Fund 101 - - - - - - - - - - - - - - K XXX b Total 1,796 334 125 384 2,639 16,000 ets 4201324 8,245 8,245 eter Hydrant Reimbursement 620 11,797 3,176 (150) 14,823 20,000 oceeds F.A. Disposal 600 1,500 le of Fixed Assets van.ous 12,000 hicle Damage Reimbursement various 1,000 K XXX b Total 11,797 11,421 (150) 23,068 34,500 Revenue Total 15,140,898 13,619,374 14,094,408 15,385,874 - - - - - - - - 58,240,553 287,194,697 2011 report 15,140,898 13,619,374 14,094,408 15,385,874 58,240,553 287,194,697 Financial Report Apn12014 - Revenue Report Page 5 025 City of South Bend Revenue by Fund Report Period Ending: April 2014 s % 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 Bud et I ofeud et General Government 0000 General Revenues 101 831,705 1,001,393 800,251 805,843 3,439,192 51,660,458 7% 0101 Mayor 101 227 151 35 276 689 600 115% 0104 311 Call Center 101 26,509 109,227 38,185 173,921 480,077 36% 0201 Clerk 101 NA 0301 Common Council 101 41 27 27 95 8,300 1% 0401 Administration and Finance 101 80,050 0% 0501 Legal 101 15 1,044 8 542 1,609 72,350 2% xxx xxx NA Sub Total 858,496 1,002,615 909,548 844,847 3,615,506 52,301,835 7% Public Works 0600 Energy Office 101 NA 0602 Engineering 101 115 115 6,100 2% 0606 Building Maintenance 101 NA 0607 Traffic & Lighting 101 NA xxx xxx NA Sub Total 115 115 6,100 2% Public Safety 0801 Police 101 38,053 30,089 10,162 7,215 85,518 337,700 25% 0802 Police Communications 101 NA 0805 Police -PS LOIT funded 101 NA 0901 Fire 101 41,063 39,253 63,964 37,433 181,713 1,616,000 11% 0905 Fire-PS LOIT funded 101 NA Sub Total 79,116 69,341 74,126 44,647 267,231 1,953,700 14% Code Enforcement 1201 Code 101 NA 1203 Code Hearing 101 NA 1204 Code Junk Vehicle 101 NA 1205 Code Unsafe Building 101 2 150 2 150 4,300 NA 1207 Code Animal Control 101 20 20 NA xxx xxx NA Sub Total 2,150 2,150 20 4,320 NA Arts 8 Culture 0404 Morris PAC 101 56,152 47,987 141,683 67,721 313,542 882,000 36% 0405 Palais Royale 101 29,101 7,384 7,641 8,067 52,193 309,981 17% xxx xxx NA Sub Total 85,253 55,371 149,324 75,788 365,735 1,191,981 31% Human Rights 1008 Human Rights 101 NA xxx xxx NA Sub Total NA General Fund Revenue Total 1,025,130 1,127,327 1,135,147 965,302 - - - - - - - - 4,252,907 55,453,616 8% Financial Report ApdI 2014 - &p-dk- Summary Page 6 of 25 City of South Bend Revenue by Fund Report Period Ending: April 2014 a % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sap I Oct Nov Dec I Year I Budget I of8ud et Parks & Recreation 0000 Parks General revenue 201 61,214 62,071 62,107 61,846 247,238 8,770,213 3% 1100 Administration 201 1,551 2251 5,730 4,891 14,423 45,750 32% 1101 Maintenance 201 6,893 7,305 7,508 83,872 105,579 299,000 35% 1102 GolfOperations 201 2,568 71,543 11,607 161,363 241,945 1,582,000 15% 1103 Recreation Division 201 18,881 13,633 7,265 835 40,614 184,140 22% 1104 Potawatomi Zoo 201 265 34 299 NA 1106 Potawatomi Greenhouse 201 NA 1107 Community Svc Block Grant 201 NA 1108 Grafd Removal 201 6,464 6,425 3,296 15,185 99,304 16% Recreation Non Reverting 203 76,057 104,016 91,333 87,416 358,822 1,449,592 25% East Race Waterway 271 2 5 7 8 22 100 22% Coveleski Stadium 401 3 10 13 14 41 500 8% Zoo Endowment 403 6 18 24 26 74 2900 3% Park Non Reverting 405 79 7,670 443 518 8,709 195,700 4% xxx x xxx NA Sub Total 168,582 275,212 189,369 400,789 1,033,952 12,629,199 8% Public Works Motor Vehicle Ni hway 202 285,523 416,631 384,110 1,840,889 2,927,153 9,106,300 32% Central Services 222 670,844 738,759 669,859 637,842 Z 717,304 7,847,374 35% Local Roads & Streets 251 87,148 91,181 93,475 123,983 395,787 1,088,000 36% Protect ReLeaf 655 36,373 36,471 36,737 36,904 146,485 431,700 34% xxx xxx xxx NA Sub Total 1,079,887 1 283 043 1,184,182 2 639 616 6,186,728 18,473,374 33% Public Works Solid Waste Solid Waste Operations 610 400,585 396,447 396,179 515,673 1,708,883 5,257,701 33% Solid Waste Capital 611 230,437 27 80,040 45,019 355,523 736,202 48% xxx x xxx NA Sub Total 631,022 396,474 476,219 560,691 Z064,406 5,993,903 34% Public Works Water Utility 0000 Water Works Revenues 620 863,045 1,048,116 935 227 955,067 3,801,454 12 655,313 30% 0630 Water Leak Insurance 620 80,687 80,448 80,578 80,851 322,565 960,000 34% 0640 Water Works 620 NA 0660 Clay Water 620 74,439 74,966 75,443 72,891 297,739 1,096,020 27% Waterworks Capital 622 453 1,296 1,756 1,853 5,358 10,000 54% Waterworks Construction 623 223 296 311 313 1,143 5,000 23% Waterworks Deposit 624 186 534 724 768 2212 6,000 37% Waterworks Sinking 625 171,006 170,846 170,967 171,050 683,870 2,057,224 33% Waterworks Bond Reserve 626 8,761 9,130 9,337 9,383 36,612 90,073 41% Waterworks Debt Reserve 629 261 54,253 1,021 1,094 56,629 70,312 81% xxx xxx xxx NA Sub Total 1,199,062 1,439,885 1,275,364 1,293,271 5,207,581 16,949,942 31% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 47,833 46,355 48,966 50,116 193,269 549,200 35% 0000 Wastewater Revenues 641 2,517,238 2,480,217 2,496,145 2,616,135 10,109,735 32,588,386 31% 0621 Sewer Department 641 2,000 0% 0625 Concrete Crew 641 4,008 4,376 6,385 5,927 20,696 47,000 44% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 153,599 152,617 158,751 160,954 625,921 1,915,802 33% Sewage Ca ital 642 2,000,563 1,522 2,002,341 3,149 4,007,576 3,566,580 112% Sewage Reserve 643 130,386 1,221 1,702 1,797 135,106 238,715 57% Sewer Bond 200612006 645 NA Sewer Bond 2007 647 1 0 1 1 2 NA Sewage Bond Sinking 649 775,028 775,371 775,900 776,314 3,102,613 9,804,645 32% Clay Sewage General 650 NA Sewage Bond 2007 651 NA Sewage Works DS Reserve 653 NA 2010 CSO Net Sewer Bond 658 0 1 1 1 4 NA 2011 Sewer Bond 659 1,034 2810 3,709 3,771 11,323 25,000 45% 2012 Sewer Bond 661 2372 6,686 8,940 9,354 27,352 45,000 61% 2013 Sewer Bond 663 60,000 0% 2013A Sewer Refund Bonds 664 1 2 2 2 7 NA 2014 Sewer Bond 665 21,000,000 0% Sub Total 5,632,063 3,471,179 5,502844 3,627,519 18,233,605 69,842,328 26% Financial Report April 2014 - &p-dk- Summary Page 7 of 25 City of South Bend Revenue by Fund Report Period Ending: April 2014 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 Public Safe - Police 601 0460 Main Street 601 0462 Leighton Plaza 601 0463 Enforcement 601 0464 Wayne Street Police Seizures 216 20 58 79 10,893 11,050 35,900 31% Curfew Violations 218 14 39 83 19 155 1,025 15% Law Enforcement Educadon 220 30,247 12,673 17,643 17,502 78,064 211,000 37% Public Safe Lon. 249 531,895 532,362 532,719 532,647 2,129,624 6,391,029 33% Excess Welfare Public Safety 252 0 0 1 1 2 NA Police Take Home Vehicle 278 14,378 9,629 9,407 9,652 43,066 123,160 35% Police Block Grant 280 0 1 2 2 6 NA Police Grants 292 66,716 66,716 NA P 294 13,159 4,127 41 694 18,021 22,000 82% COPS More Grants 295 863 992 957 819 3,631 41,600 9% Drua Enforcement 299 91 81 73 5,388 5,633 77,000 7% K -9 Unit 705 0 1,000 1 1 1,003 2,000 50% xxx xxx Sub Total xxx 657,384 560,963 561,005 577,618 2,355,971 6,904,714 NA 34% Publie Safe - Fire enc Tele hone S stem 244 215,000 215,000 215,000 100% a ital U 288 154,587 286,614 238,953 270,628 950,782 2,661,000 36% t 289 2 6 8 9 24 10.000 0% River Rescue 291 Z412 Z435 7,249 8,453 20,549 45,200 45% xxx xxx xxx NA Sub Total 372,001 289,056 246,209 279,090 1,186,356 2,931,200 40% Department of Communi Investment Studebaker /Oliver 209 139 398 539 569 1,645 305,000 1% State Grant 210 85 128 174 18,184 18,571 77,016 24% DCI Operating 211 435,848 11,776 40,226 480,581 968,431 Z278,246 43% 0000 Dept of Community Investment 212 125,073 158,522 95,663 9Z945 472,203 3,811,000 12% xxx Programs 212 NA 0000 Economic Revenue Bond 281 3 10 14 14 41 NA xxx xxx xxx NA Sub Total 561,149 170,834 136,615 592294 1,460,891 6471,262 23% 0000 Parking Garage Revenue 601 0460 Main Street 601 0462 Leighton Plaza 601 0463 Enforcement 601 0464 Wayne Street 601 0465 Eddy Street Commons 601 xxx xxx xxx Financial Report Aprl12014 - &p-dk- Summary Page 8 of 25 City of South Bend Revenue by Fund Report Period Ending: April 2014 a i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I u Sap 1 Oct Nov Dec I Year I Budget I of8ud et Other Miscellaneous Rain Da 102 1,105 3,164 4,289 4,527 13,084 52,000 25% Gift Donation Be nest 217 10 21,140 38 50 21,238 7,290 291% Loss Recove 227 1,018 2,913 3,945 4,119 11,995 17,000 71% Human Ri hts 258 89 4,817 9,168 4,420 18,494 210,700 9% Morris Palais Marketing 273 354 3,005 542 364 4,265 8,100 53% Professional Sports Development 377 101,255 113,844 299 354 215,752 678,228 32% 1201 Code Enforcement 600 585,873 8,041 13,979 598,989 1,206,883 2,596,460 46% 1207 Animal Control 600 5,770 4,102 4,463 5,513 19,848 57,000 35% 1306 Building Operations 600 80,574 51,956 84,261 76,484 293,275 1,159,100 25% Century Center 670 101,443 830,395 167,457 108,952 1,208,247 4,564,898 26% Century Center Capital 671 30 57 29 116 100,500 0% xxx xxz xxx NA Sub Total 877,520 1,043,378 288,498 803,800 3,013,197 9,451,276 32% Business Insurance 0000 Business Insurance Revenues 226 235,841 273,423 244,661 240,954 994,880 2,881,690 35% 0403 Self Funded Liability Ins 226 - - - - - - - - - - - - - - NA 0412 Liability Insurance 226 - - - - - - - - - - - - - - NA 0417 Business Insurance 226 - - - - - - - - - - - - - - NA 0418 Workers Compensation 226 17,000 0% xxx xxx xxx NA Sub Total 235,841 273,423 244,661 240,954 994,880 Z898,690 690 34% Fiduc- Trust & A enc Trust Fire Pension 701 157 330 223 711 5391,332 0% Police Pension 702 261 614 539 217 1,632 6310,000 0% Police / Fire Pension 703 NA Employee Benerits 711 939,099 988,883 1,008,404 1 356 220 4,292,605 13 418,450 32% Unemployment Comp 713 8,564 8,625 8,658 8,661 34,508 236,898 15% Cemtery Trust 730 5 14 18 19 56 250 22% xxx xxx xxx NA Sub Total 948,086 998,466 1,017,843 1 365 117 4,329,512 25 356,930 17% Civil City Revenues 15,022,977 13,469,813 13,985,515 14,960,176 - - - - - - - - 57,438,482 256,637,317 22% Tax Increment Financing ort 324 2,853 9,393 12,246 12,595 37,088 13,484,612 0% tral Develo ment 420 30,402 30,591 15,776 254,752 331,521 4,418,336 8% st Washin ton 422 58 225 305 322 909 422,000 0% hton Plaza 425 9,940 15,407 12,374 18,352 56,073 164,303 34% UTIFAirport dical Service 426 371 1,141 1,524 1,609 4,645 1,615,000 0% heast 429 349 1,104 1,497 1,580 4,530 827,000 1% uthside 430 402 1,246 1,669 1,721 5,038 3,615,000 0% kine Commons 431 NA kineW a a 432 762 2,277 3,012 3,180 9,231 15,000 62% u /as Road 435 23 108 147 143 421 320,750 0% Northeast Residential TIF 436 244 920 502 362 2,028 2,510,000 0% xxx xxx xxx NA Sub Total 45,404 62,412 49,053 294,616 451,486 27,392,001 2% Financial Report Apol 2014 - &p-dk- Summary Page 9 of 25 City of South Bend Revenue by Fund Report Period Ending: April 2014 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 Budget I of Bud et Redevelo ment Funds Central Bond Proceeds 305 NA District Capital 2003 428 NA Administration 433 3 9 10 10 31 NA Coveleski Bond Construction 438 NA Certified Technology Park 439 472 1,352 1,833 1,934 5,591 1,453,000 0% Airport Urban Enterprise Zone 454 48 138 187 198 571 1,500 38% Blackthorn Golfo erations 619 71,571 84,446 56,179 127,218 339,413 1,696,879 20% xxx xxz xxx NA Sub Total 72,094 85,944 58,208 129,360 345,607 3,151,379 11% Debt Service Public Improvement 1990 314 - - - - - - - - - - - - - - NA Airport Debt Reserve 2003 315 133 381 517 545 1,577 5,000 32% Coveleski Bond Debt Reserve 317 65 185 251 264 764 3,000 25% Blackthorn Debt Service 319 NA Central Development reserve 328 223 637 863 911 2,634 6,000 44% xxx x xxx NA Sub Total 420 1,203 1,631 1,721 4,975 14,000 36% Redevelopment Commsssion 117,919 149,560 108,892 425,698 - - - - - - - - 802,069 30,557,380 3% City Operations Total 15,140,898 13,619,373 14,094,408 15,385,874 - - - - - - - - 58,240,553 287,194,697 20% Revenue report 15,140,898 13,619,374 14,094,408 15,385,874 58,240,553 287,194,697 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report Apol 2014 - Expenditure Summary Page 10 of 25 City of South Bend Property Tax Revenue 2012 Tax Pay 2013 Fund Period Ending: April 2014 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61412013 611712013 1212312013 Total Property Tax Collection 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% State Board 2010 Audit Fee Revised 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 2014 - Property Tax Revenue Page 11 of 25 City of South Bend Property Tax Revenue i1 Tax Pay 2012 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61112012 612212012 1212812012 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Cit General Fund 101 42,159,959.10 0.95 40,051,961.15 14,149,210.75 7,476,750.77 17,742,469.36 39,368,430.88 2,791,528.22 93.38% Parks & Recreation 201 8,374,886.47 0.95 7,956,142.15 2,810,677.15 1,485,222.94 3,528,156.04 7,824,056.13 550,830.34 93.42% College Football Hall of Fame 313 859,959.09 0.95 816,961.14 - 622,017.06 511,188.06 1,133,205.12 (273,246.03) 131.77% Cumulative Capital District 406 554,158.31 0.95 526,450.39 185,979.85 98,275.80 233,454.74 517,710.39 36,447.92 93.42% Fire Pension 701 - 0.95 - - - - - - Police Pension 702 0.95 Total - City 51,948,962.97 49,351,514.82 17,145,867.75 9,682,266.57 22,015,268.20 48,843,402.52 3,105,560.45 94.02% Tax Increment Financing Airport TIF District 324 12,266,234.17 0.95 11,652,922.46 6,111,684.64 5,519,602.49 11,631,287.13 634,947.04 94.82% South Bend Central TIF District 420 3,781,492.40 0.95 3,592,417.78 1,909,554.48 1,761,923.84 3,671,478.32 110,014.08 97.09% West Washington TIF District 422 483,719.73 0.95 459,533.74 225,083.13 197,631.37 422,714.50 61,005.23 87.39% Central Medical TIFDistrict 426 3,668,649.86 0.95 3,485,217.37 876,400.86 730,513.97 1,606,914.83 2,061,735.03 43.80% Northeast Residential TIF District 436 2,542,578.19 0.95 2,415,449.28 1,252,274.84 1,261,773.08 2,514,047.92 28,530.27 98.88% Southside TIF District #1 430 2,608,924.21 0.95 2,478,478.00 1,337,317.29 1,128,885.46 2,466,202.75 142,721.46 94.53% Erskine Commons TIF District #2 431 0.95 - - Erskine Village TIF District #3 432 - 0.95 - - - - - - Douglas Road TIF District 435 561,079.06 0.95 533,025.11 264,862.03 20,851.19 285,713.22 275,365.84 50.92% Northeast TIF 429 1,685,484.97 0.95 1,601,210.72 693,351.99 657,696.09 1,351,048.08 334,436.89 80.16% Airport Urban Enterprise Zone 454 74,480.84 0.95 70,756.80 37,240.42 74,480.84 111,721.26 (37,240.42) 150.00% Other xxx 0.95 - - - - Total -Tax Increment Financing 27,672,643.43 26,289,011.26 12,707,769.68 11,353,358.33 24,061,128.01 3,611,515.42 86.95% Grand Total 79,621,606.40 75,640,526.08 17,145,867.75 22,390,036.25 33,368,626.53 72,904,530.53 6,717,075.87 91.56' tate Board 2010 Audit Fee Revised Total 79,621,606.40 75,640,526.08 17,145,867.75 22,390,036.25 33,368,626.53 72,904,530.53 6,717,075.87 91.56' Note(s) 1 Distribution 1 - Issued by St. Joseph County on 611112 2 Distribution 2 - Issued by St. Joseph County on 6122112 3 Distribution 3 - Issued by St. Joseph County on 12128112 x Financial Report April 2014 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending: April 2014 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 We ryor 101 73,969 52,004 52,578 54,407 232,958 711,711 1 Call Center 101 39,235 38,732 31,260 38,185 147,412 488,908 erk 101 33,254 24,949 24,763 25,023 107,988 394,608 immon Council 101 33,804 16,129 22,696 28,970 101,598 472,598 Iministration and Finance 101 184,882 129,923 146,822 191,183 652,810 2,091,944 gal 101 111,670 74,144 74,485 83,836 344,136 1,025,635 K 4,776,421 3,539,947 3,470,493 3,794,204 15,581,065 48,011,105 ib Total 476,814 335,881 352,603 421,604 1,586,902 5,185,404 cs iergy Office 101 igineering 101 100,714 83,713 46,461 132,468 363,356 1,126,302 affic 8 Lighting 101 K ib Total 100,714 83,713 46,461 132,468 363,356 1,126,302 ty We lice 101 2,352,204 1,889,108 1,847,740 1,829,954 7,919,006 24,725,204 Mice Communications 101 205,840 146,325 143,663 159,049 654,877 2,236,486 /ice -PS LOIT funded 101 ode Junk Vehicle 101 ,e 101 2,004,690 1,591,802 1,605,489 1,805,201 7,007,182 21,049,415 -e-PS LOIT funded 101 213,687 (87,288) (126,399) (0) 0 300 K X ib Total 4,776,421 3,539,947 3,470,493 3,794,204 15,581,065 48,011,105 cement We 101 740 3,642 (2,402) (1,129) 851 5,225 eights and Measure 101 ode Hearing 101 ode Junk Vehicle 101 ode Unsafe Building 101 ode Animal Control 101 612 (0) (312) 300 2,254 X ib Total 740 4,254 (2,403) (1,441) 1,150 7,479 ire wis PAC 101 87,838 86,253 87,012 79,972 341,075 1,063,527 dais Royale 101 43,724 31,427 36,381 35,103 146,636 523,710 K ib Total 131,562 117,680 123,393 115,075 487,711 1,587,237 Ws iman Rights 101 31,977 26,096 24,523 26,765 109,360 367,262 K ib Total 31,977 26,096 24,523 26,765 109,360 367,262 General Fund Expenditure Total 5,518,227 4,107,572 4,015,071 4,488,675 - - - - - - - - 18,129,544 56,284,789 32% Financial Report April 2014 - &p-dk- Summary Page 13 0/ 25 City of South Bend Period Ending: April 2014 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 0630 Water Leak Insurance )tor Vehicle Highway 1100 Administration 201 113,658 84,616 98,120 123,483 419,878 1,564,813 27% 1101 Maintenance 201 440,988 353,914 390,644 351,149 1,536,696 4,947,775 31% 1102 GolfOperations 201 79,201 66,423 162,024 161,674 469,322 1,526,640 31% 1103 Recreation Division 201 195,148 128,820 129,384 142,829 596,180 2,114,512 28% 1104 Potawatomi Zoo 201 669,326 24,910 19,666 20,268 734,170 2,283,664 32% 1106 Potawatomi Greenhouse 201 8,161 7,588 5,995 4,098 25,842 59,614 43% 1107 Community Svc Block Grant 201 261 746 1,021 1,094 3,122 xxx xxx NA 1108 Graffiti Removal 201 7,701 4,982 7,622 7,691 27,997 103,860 27% Recreation Non Reverting 203 42,584 72,465 55,717 59,083 229,849 1,479,064 16% East Race Waterway 271 2045 2045 10,346 20% Coveleski Stadium 401 500 850 750 2,100 3,540 0% Park Non RevemIng 405 4,814 111,962 14,077 130,852 205,217 64% xxx xkx xxx NA Sub Total 653 1,561,582 855,681 869,172 886,397 - - 4,172,831 14,299,045 29% (s 0630 Water Leak Insurance )tor Vehicle Highway 202 818,846 888,630 620,621 596,446 2,924,543 8,555,846 irb and Sidewalk 202 49,312 36,865 30,043 28,523 144,743 1,152,802 antral Services 222 672,962 610,722 687,806 59Z 769 2,564,259 8,036,532 Ical Roads &Streets 251 19,206 IZ316 11,761 17,780 43,282 1,124,520 oiect ReLeaf 655 14,433 3,216 2324 26,854 46,827 430,114 X xxx 625 196 36 157 240 630 ib Total 626 1,574,759 1,551,748 1,352,556 1,244,591 5,723,654 19,299,814 rs Solid Waste did Waste Operations 610 672,124 364,775 527,277 436,201 2,000,378 5,439,463 ,11d Waste Capital 611 264,795 79,617 45,260 83,600 473,273 896,070 X xxx ib Total 936,920 444,393 572,537 519,801 2,473,651 6,335,533 Public Works Water Utility 0630 Water Leak Insurance 620 60,631 71,687 52,589 62,286 247,192 0640 Water Works 620 1,137,738 1,021,433 1,021,980 1,133,868 4,315,019 0660 Clay Water 620 215 1,523,963 3 30% 218 Waterworks Capital 622 3,600 32,982 27,777 137,141 3,600 Waterworks Construction 623 17,780 195,292 4,436 191,283 408,790 Waterworks Deposit 624 186 534 724 768 2212 Waterworks Sinking 625 196 36 157 240 630 Waterworks Bond Reserve 626 0 978 1,000 -98% Waterworks Debt Reserve 629 261 746 1,021 1,094 3,122 xxx xxx xxx Sewage Reserve 643 422 1,221 1,702 Sub Total 5,142 1,220,608 1,289,727 1,080,910 1,389,538 - - - - - - - - 4,980,783 Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 17,250 30,211 23,925 22,790 94,176 549,978 17% 0621 Sewer Repair 641 461,905 389,062 283,083 389,913 1,523,963 5,132,912 30% 0625 Concrete Crew 641 39,120 37,262 32,982 27,777 137,141 453,145 30% 0630 Wastewater Operations 641 4,020,021 1,880,989 3,676,419 1,803,956 11,381,386 28,766,521 40% 0631 Organic Resources 641 78,091 82,861 91,592 95,259 347,802 1,202,616 29% 0650 Clay Sewage 641 978 0 978 1,000 -98% Sewage Ca ital 642 978,994 416,435 421,874 311,133 2,128,435 9,267,941 23% Sewage Reserve 643 422 1,221 1,702 1,797 5,142 15,000 34% Sewer Bond 200612006 645 NA Sewer Bond 2007 647 1,138 0% Sewage Bond Sinking 649 500 850 750 2,100 9,802,031 0% Clay Sewage General 650 NA Sewage Bond 2007 651 NA Sewage Works DS Reserve 653 NA 2010 CSO Net Sewer Bond 658 NA 2011 Sewer Bond 659 275,419 265,818 144,834 676,437 1,362,507 13,598,486 10% 2012 Sewer Bond 661 272,470 216,156 17,815 575 507,016 18,868,570 3% 2013 Sewer Bond 663 19,100,000 0% 2014 Sewer Bond 665 500,000 0% Sub Total 6,143,212 3,320,865 4,694,227 3,330,387 - - - - - - - - 17,488,690 107,259,338 16% Financial Report Apol 2014 - &p-dk- Summary Page 14 of 25 City of South Bend Period Ending: April 2014 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 Public Safe - Police 4S Capital 288 449,207 280,578 359,503 943,903 2,033,191 5,402,215 mmat Seizures 216 10,000 ver Rescue 291 199 1,283 0 57 1,540 52,300 40,000 0% Curfew Violations 218 ib Total 449,407 281,861 359,503 943,960 2,034,731 5,464,515 18,003 1,000 0% Law Enforcement Education 220 11,075 20,490 23,204 3,629 58,398 294,802 20% Emer enc Tele hone System 244 27,387 16,003 16,999 18,603 78,992 215,000 37% Public Safe LOIT 249 517,291 613,746 709,196 593,832 2,434,064 7,214,658 34% IPolice Excess Welfare Public Safety 252 X xxx 1,146 0% Police Take Home Vehicle 278 15,269 811 12 709 5,393 34,183 80,580 0% Police Block Grant 280 29,594 71,075 113,460 98,190 312,319 5,823,729 NA Police Grants 292 337,650 358,693 138,059 377,775 138,059 228,060 61% PoliceAcademy294 434 136 197 330 3,967 4,631 23,750 19% COPS More Grants 295 175 1,484 1,185 1,417 4,261 141,600 3% Drug Enforcement 299 6,273 2,731 3,839 29,849 36,419 151,499 24% K -9 Unit 705 2,000 0% xxx xxx xxx 4,831,372 709,183 802,655 3,116,534 9,459,744 29,290,528 NA Sub Total 556,065 654,651 892,811 651,297 - - - - - - - - 2,754,824 8,394,095 33% ty - Fire 4S Capital 288 449,207 280,578 359,503 943,903 2,033,191 5,402,215 mmat 289 209 10,000 ver Rescue 291 199 1,283 0 57 1,540 52,300 X xxx State Grant 210 ib Total 449,407 281,861 359,503 943,960 2,034,731 5,464,515 De artmento mmunity Investment lin Street StudebakedOliver 209 15,801 740 43,308 82,581 203,425 1,385,000 0% State Grant 210 1,612,310 385,712 18,003 943,423 18,003 117,886 15% DCI Operating 211 236,843 167,810 175,126 174,007 753,787 2,404,884 31% 1001 Dept. of Community Investment 212 85,538 190,071 52,948 198,374 526,931 6,499,680 89/ 1002 Dept. of Community Investment 212 150,869 Idy Street Commons 601 2,057,472 4,707,905 10,014,984 NA 1003 Administration 212 X xxx 2,328 0% xxx Programs 212 15,269 811 12 709 5,393 34,183 408,775 8% xxx xxx xxx 29,594 71,075 113,460 98,190 312,319 5,823,729 NA Sub Total 416 337,650 358,693 258,786 377,775 1,332,903 10,818,553 12% -ages lin Street 601 22,732 15,801 740 43,308 82,581 203,425 Joseph 601 COIT 404 1,612,310 385,712 447,510 943,423 ighton Plaza 601 39,122 41,189 2,241 69,225 151,777 337,008 iforoement 601 13,486 4,479 196 8,021 26,182 90,606 ayne Street 601 21,424 12,784 718 39,704 74,631 150,869 Idy Street Commons 601 2,057,472 4,707,905 10,014,984 47% Cumulative Sewer 15,900 X xxx NA UDAG ib Total 96,764 74,254 3,896 160,258 335,171 797,808 Capital /Debt Service Hall of Fame 313 634,500 634,500 1,268,116 50% COIT 404 1,612,310 385,712 447,510 943,423 3,388,955 10,193,285 33% Cum Capital Development 406 112,650 56,546 169,196 722,935 23% Cum Capital Improvement 407 185,250 185,250 364,762 51% EDIT 408 2,229,819 244,434 176,179 2,057,472 4,707,905 10,014,984 47% Cumulative Sewer 409 NA UDAG 410 NA Major Moves 412 29,594 71,075 113,460 98,190 312,319 5,823,729 5% Morris PAC Improvement 416 2,911 2,911 53,200 5% CREED 434 20,975 20,975 650,950 3% Palais Historic Preservation 450 10,000 0% Hall of Fame Capital 677 6,273 7,962 6,049 17,448 37,732 188,567 20% xxx xxx xxx NA Sub Total 4,831,372 709,183 802,655 3,116,534 9,459,744 29,290,528 32% Financial Report Aprl12014 - Expenditure Summary Page 15 of 25 City of South Bend Period Ending: April 2014 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 226 Excess Levy 103 18,955 17,554 75,518 253,743 Liability Insurance 226 NA 243,446 Gift, Donation, Bequest 217 394,256 1,028,811 Business Insurance 226 6,557 51,010 0% 1,799 Loss Recovery 227 5,154 6,805 201,942 81,844 295,745 5,615,805 5% 1,042,346 General Grant 250 319 657,534 0% TIF Lei Leighton Plaza 425 20,595 NA xxx Human Rights 258 19,647 10,646 9,995 11,474 51,762 224,001 23% 2,916,392 Morris Palais Marketing 273 3,628 27,828,418 982 2,453 7,063 8,100 87% 617 Economic Revenue Bond 281 TIF Southside 430 81,949 8,298 169,406 27,289 NA 6,487,957 ProfessionalSports Development 377 382,873 800 100,000 483,673 865,746 56% 1201 Code Enforcement 600 87,023 68,770 63,184 171,941 390,918 1,836,074 21% 1207 Animal Control 600 58,611 49,070 47,679 54,707 210,067 689,215 30% 1306 Building Operations 600 102,831 81,636 75,880 78,138 338,485 1,273,620 27% Century Center 670 314,629 427,425 323,712 278,861 1,344,626 4,564,898 29% 987,594 Century Center Capital 671 8,585,044 51,797,693 17% 106,684 0% xxx xxx xxx NA Sub Total 974,395 645,150 723,375 779,417 3,122,337 15,235,153 205/ m Insurance Self Funded Liability Ins 226 20,289 18,720 18,955 17,554 75,518 253,743 Liability Insurance 226 39,002 243,446 47,138 64,670 394,256 1,028,811 Business Insurance 226 6,557 29,628 27,028 1,799 65,012 572,300 Workers Compensation 226 37,558 198,648 118,501 11,833 366,539 1,042,346 xxx xxx 319 657,534 0% TIF Lei Leighton Plaza 425 20,595 Sub Total xxx 103,406 490,442 211,622 95,856 901,325 2,897,200 y Trust 8 Agency Fire Pension 701 457,164 448,542 448,687 456,878 1,811,271 5,874,445 Police Pension 702 54Z603 643,997 645,479 553,882 2,385,960 7,221,941 Employee Benefits 711 526,930 1,807,630 1,315,439 1,462,755 5,112,753 14,483,463 Unemployment Comp 713 9,673 16,224 12 294 13,584 51,774 227,974 City Cemetery Trust 730 319 657,534 0% TIF Lei Leighton Plaza 425 20,595 xxx xxx 7,161 38,745 149,425 26% TIF Medical Service 426 Sub Total 1,536,369 2,916,392 2,421,899 2,487,098 9,361,758 27,828,418 Civil City Expenditure 25,840,735 17,700,611 18,259,018 20,471,583 - - - - - - - - 82,271,946 322,907,786 25% Tax Increment Financing TIF Air ort 324 1,403,524 250,577 673,576 192,333 2,520,010 27,286,693 9% TIF Sam le Ewing 414 NA TIF Central Development 420 1,015,931 314,263 51,873 339,598 1,721,665 5,829,261 30% TIF West Washington 422 319 319 657,534 0% TIF Lei Leighton Plaza 425 4,077 13,665 13,842 7,161 38,745 149,425 26% TIF Medical Service 426 169,224 1,532,233 1,701,457 4,103,504 41% TIF Northeast 429 617 617 2,806,117 0% TIF Southside 430 81,949 8,298 169,406 27,289 286,942 6,487,957 4% TIF Erskine Commons 431 NA TIF Erskine Villa a 432 354,606 354,606 494,151 72% TIF Dou las Road 435 160 95,231 95,391 399,823 24% North east Residential TlF 436 1,464,500 400,791 1,865,291 3,583,228 52% xxx xxx xxx NA Sub Total 4,494,908 987,594 1,003,928 2,098,614 8,585,044 51,797,693 17% Financial Report Apol 2014 - Expendk- Summary Page 16 of 25 City of South Bend Period Ending: April 2014 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 Redevelo ment Funds 1,042,292 1,075,730 2182,004 - - - - - - - - 8,848,919 57,100,399 15% central Bond Proceeds 305 City Operations Total 30,389,628 18,742,903 19,334,748 NA District Capital 2003 428 133 381 517 545 1,577 NA Administration 433 6,072 4,140 5,491 15,703 20,000 79% Coveleski Bond Construction 438 NA CertlBed Technology Park 439 223 637 863 911 3,600,000 0% Air ort Urban Enterprise Zone 454 NA Blackthorn Goff Operations 619 47,557 53,680 66,283 76,441 243,961 1,671,706 15% xxx xxx xxx NA Sub Total 53,629 53,680 70,422 81,933 259,664 5,291,706 5% e 1,042,292 1,075,730 2182,004 - - - - - - - - 8,848,919 57,100,399 15% iblic Improvement 1990 314 City Operations Total 30,389,628 18,742,903 19,334,748 22,653,588 - rport Debt Reserve 2003 315 133 381 517 545 1,577 5,000 rveleski Bond Debt Reserve 317 0 0 0 0 0 0 0 0 0 0 0 0 ackthorn Debt Service 319 ?ntral Development reserve 328 223 637 863 911 2,634 6,000 X xxx ib Total 356 1,019 1,380 1,457 4,211 11,000 Redevelopment Commsssion 4,548,893 1,042,292 1,075,730 2182,004 - - - - - - - - 8,848,919 57,100,399 15% City Operations Total 30,389,628 18,742,903 19,334,748 22,653,588 - - - - - - - - 91,120,866 380,008,185 24% Expenditure report 30,389,627 18,742,903 19,334,748 22,653,588 91,120,866 380,008,185 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report Aprl12014 - Expenditure Summary Page 17 of 25 City of South Bend Debt Schedule Period Ending; April 2014 Year of I Year of Year of Scheduled Payments Debt (Orig / Ref•) Debt at 2014 Principal 2014 Interest 2014 Debt at 2114 Total Debt Instrument Debt Purpose Issue Refunding maturity Fund list 2nd 3rd 4th Issue 1231/2013 Payments Payment Addition 1231/2014 Debt Pa menu Civil City Debt Bond Debt Arran scb k of CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11,870,000.00 2,815,000.00 760,000.00 121,520.00 0.00 2,055,000.00 881,520.00 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1 - - 9,250,000.00 4,385,000.00 525,000.00 145,626.00 0.00 3,860,000.00 670,626.00 25 Water Works Improvements Water Works 2002 2012 2023 625 1/1 7/1 - - 5,975,000.00 3,450,000.00 350,000.00 69,000.00 0.00 3,100,000.00 419,000.00 39 South Bend Building Corporation Fire HO / Police HO 2003 2012 2023 404/324 21 8/1 - - 21,335,000.00 12,365,000.00 1,120,000.00 446,010.00 0.00 11,245,000.00 1,566,010.00 41 Sewage Works Improvements Sewage Works 2004 2024 649 611 12/1 - - 11,425,000.00 0.00 0.00 0.00 0.00 0.00 0.00 24 Water Works Improvements Water Works 2006 2027 625 1/1 7/1 - - 4,710,000.00 3,505,000.00 205,000.00 155,438.00 0.00 3,300,000.00 360,438.00 42 Sewage Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7,630,000.00 6,090,000.00 350,000.00 269,491.26 0.00 5,740,000.00 619,491.26 4o Saw age Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16,600,000.00 13,010,000.00 690,000.00 563,547.50 0.00 12,320,000.00 1,253,547.50 52 Sewage Works Revenue Bonds 2007B Sewage Works 2007 2027 649 6/1 12/1 - - 16,515,000.00 12,960,000.00 680,000.00 551,541.26 0.00 12,280,000.00 1,231,541.26 62 Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11/1 - - 4,655,000.00 3,990,000.00 240,000.00 104,308.26 0.00 3,750,000.00 344,308.26 6s Water Works Improvements Water Works 2009 2030 625 1/1 7/1 - - 5,380,000.00 4,985,000.00 210,000.00 270,232.00 0.00 4,775,000.00 480,232.00 70 Sewage Works Revenue Bonds -2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3,297,000.00 2,710,898.00 149,511.00 76,176.00 0.00 2,561,387.00 225,687.00 ao 2010 Sewage Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9,345,000.00 8,270,000.00 365,000.00 336,217.50 0.00 7,905,000.00 701,217.50 93 Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21,500,000.00 19,895,000.00 855,000.00 732,300.00 0.00 19,040,000.00 1,587,300.00 99 2012 Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8,300,000.00 7,960,000.00 340,000.00 233,886.26 0.00 7,620,000.00 573,886.26 101 2012 Sewage Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25,000,000.00 23,985,000.00 1,020,000.00 548,580.00 0.00 22,965,000.00 1,568,580.00 fo52013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14,765,000.00 13,700,000.00 1,845,000.00 265,780.00 0.00 11,855,000.00 2,110,780.00 116 2013 Building Corporation xxx EMS / Fire Department 2013 2033 288 21 8/1 - - 5,580,000.00 5,580,000.00 0.00 142,197.00 0.00 5,580,000.00 142,197.00 Total Bond Debt 225 632 000.00 149 655 898.00 9,704,511.00 5 031 851.04 0.00 139 951 387.00 14 736 362.04 Loans Payable 1 State Revolving Fund Bosch Property 2002 2022 210 1/30 10/30 - - 506,448.00 0.00 0.00 0.00 0.00 0.00 0.00 6e State Revolving Fund Water Works Improvement 2009 2030 625 1/1 7/1 - - 427,332.00 391,297.00 18,933.00 13,186.70 0.00 372,364.00 32,119.70 82 lnterfund Loan 410 - UDAG 1st Source/Marriott Garage 2010 2015 410 6/15 1215 - - 2,700,000.00 2,027,973.00 0.00 0.00 0.00 2,027,973.00 0.00 44 State Revolving Fund (Refunding) Sewage Works Improvement 1998 2018 649 6/1 12/1 - - 24,095,000.00 0.00 0.00 0.00 0.00 0.00 0.00 26 State Revolving Fund Water Works Improvements 2000 2019 625 1/1 7/1 - - 2,600,000.00 1,018,815.00 157,902.00 29,546.00 0.00 860,913.00 187,448.00 Total Loans Pa able 35 533 780.00 3.438.085.00 176 835.00 42 732.70 0.00 3.261.250.00 219 567.70 Capital Leases 27 LaSalle Bank - Fire Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 0.00 0.00 0.00 0.00 sf Chase LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 730,258.41 171,136.37 29,443.29 0.00 559,122.04 200,579.66 5s Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 963,508.00 0.00 0.00 0.00 0.00 0.00 0.00 56 Oce Copier 209 N Main 2008 2013 620 Monthly - - - 12,078.21 0.00 0.00 0.00 0.00 0.00 0.00 57 Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 0.00 5a Lanier Copier 915 Oil- 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 0.00 5s Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 0.00 0.00 0.00 0.00 0.00 0.00 67 Sun Trust Solid Waste Containers/Tmcks 2009 2014 611 9/1 3/1 - - 720,990.00 78,167.28 78,167.28 1,450.00 0.00 0.00 79,617.28 71 Kansas State Bank Clark Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,209.00 638.84 638.84 10.63 0.00 0.00 649.47 72 Kansas State Bank Code Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10/23 9,209.00 2,594.75 2,055.52 143.04 0.00 539.23 2,198.56 73 Kansas State Bank Engineering Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,391.00 651.47 651.47 10.84 0.00 0.00 662.31 74 CSI Leasing Inc IT Netapp San 2010 2014 404 1/1 4/1 7/1 10/1 207,521.37 14,236.41 14,236.41 210.59 0.00 0.00 14,447.00 76 Kansas State Bank Central Services Copier 2010 2015 222 216 5/16 8/16 11/16 13,366.40 4,362.77 2,865.87 194.13 0.00 1,496.90 3,060.00 n GE Capital Information Technology Animal Control Copier 2010 2015 101 2/28 5/30 8/30 11130 3,550.69 1,161.97 758.35 57.05 0.00 403.62 815.40 78 Kansas State Bank Mayor Oce Copier 2010 2015 101 1/8 4/8 7/8 10/8 9,209.00 3,564.45 1,977.73 220.83 0.00 1,586.72 2,198.56 7s Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10,511.02 4,702.41 2,246.64 348.72 0.00 2,455.77 2,595.36 87 Public Finance.- Inc Solid Waste Containers /Trucks 2011 2015 611 6/15 1215 - - 321,853.00 133,252.34 65,587.04 3,677.96 0.00 67,665.30 69,265.00 as Sun Trust Police, Parks, Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2,068,202.00 1,05 04 84 417,495.38 17,470.02 0.00 641,545.46 434,965.40 so Capital One Public Funding Solid Waste Containers /Trucks 2011 2016 611 3/15 6/15 9/15 1215 207,432.00 116,115.23 41,611.14 1,674.42 0.00 74,504.09 43,285.56 s1 GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 2,065.68 790.50 98.22 0.00 1,275.18 888.72 s2 Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 843,595.57 274,272.26 21,127.15 0.00 569,323.31 295,399.41 s4 Ikon Office Solutions Mayor Ricoh MP 2851 SP Copiei 2011 2016 101 2/15 5/15 8/15 11/15 2,569.53 1,620.15 509.86 78.62 0.00 1,110.29 588.48 s5 Sun Trust Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 218,030.66 86,168.37 3,154.11 0.00 131,862.29 89,322.48 s7 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1,295,000.00 918,678.73 256,966.38 14,484.90 0.00 661,712.35 271,451.28 s3 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202641/640 5/15 11/15 - - 945,674.38 669,405.77 187,687.81 9,371.03 0.00 481,717.96 197,058.84 too PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15 - - 2,806,054.00 2,257,055.55 553,306.66 27,644.68 0.00 1,703,748.89 580,951.34 I. Ikon Office Solutions /Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 4,278.32 1,108.22 213.70 0.00 3,170.10 1,321.92 1. GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11128 5,471.01 4,249.41 1,043.56 227.24 0.00 3,205.85 1,270.80 foe Ricoh USA (New) Central Services Copier 2013 2018 222 227 5127 8/27 11/27 3,622.78 3,004.64 689.33 150.43 0.00 2,315.31 839.76 107 Ricoh USA StreeUSewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 4,506.34 1,031.00 239.80 0.00 3,475.34 1,270.80 Ica Ricoh USA City Adomey Copier 2013 2018 101 212 5112 8112 11/12 5,559.15 4,528.32 1,035.69 235.11 0.00 3,492.63 1,270.80 ms Ricoh USA Parks & Rec Ricoh Copieni 2013 2018 201 2121 5/21 8/21 11/21 16,129.94 13,138.50 3,005.59 681.65 0.00 10,132.91 3,687.24 Ire INC Equipment Finance Vehicle/Equipment Lease 2013 2018 1011202/406/641 1115 7115 - - 1,689,669.59 1,689,669.59 327,718.32 22,182.20 0.00 1,361,951.27 349,900.52 111 Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 8,694.31 1,904.10 687.90 0.00 6,790.21 2,592.00 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 3,854.45 744.53 194.47 0.00 3,109.92 939.00 113 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 - - 1,506,465.26 1,506,465.26 291,855.59 22,725.55 0.00 1,214,609.67 314,581.14 114 Ricoh USA Admin & Finance Copier 2013 2018 101 1116 4116 7116 10/16 11,247.97 9,620.91 2,055.86 515.39 0.00 7,565.05 2,571.25 115 CSI Leasing Inc 2010 Server IT Lease 2010 2014 404 211 5/1 8/1 11/1 28,588.00 5,869.74 5,869.79 169.81 0.00 (0.05) 6,039.60 117 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 9,678.26 1,728.17 491.83 0.00 7,950.09 2,220.00 113 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 5,647.50 1,008.13 287.27 0.00 4,639.37 1,295.40 fts Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Co k 2013 2018 620 Monthly 16th 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 1,085.52 In Water Works Olive Ricoh Copier xxx Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 1,085.52 Total Capital Lease 18 788 201.74 10 341 870.13 1 2.801.617.38 180 354.00 0.00 7,540,252.75 2 981 971.38 Total Civil City 279,953,981.74 163,435,853.13 12,682,963.38 5,254,937.74 0.60 150,752,889.75 17,937,901.12 Financial Repel April 2014 -Debt Page IS d25 City of South Bend Debt Schedule Period Ending; April 2014 Year of I Year of Year of Scheduled Payments Debt (Orig / Reb) Debt at 2014 Principal 2014 Interest 2014 Debt at 2tl4 Total Debt Instrument Debt Purpose Issue Refunding maturity Fund 1st 2ntl 3rd 4th Issue 12/31/2013 Payments Payment Addition 12/31/2014 Debt Pa merits Redevelopment Commission Debt Bond Debt 9 Central Business TIF 1990 1996 2012 420 2J 1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 0.00 to Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 0.00 0.00 0.00 0.00 0.00 0.00 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2J 1 811 - - 6,825,000.00 2,070,000.00 440,000.00 46,350.00 0.00 1,630,000.00 486,350.00 a College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15,370,000.00 5,285,000.00 1,130,000.00 137,687.50 0.00 4,155,000.00 1,267,687.50 ti South Bend Building Corporation Morris PAC 1998 2009 2017 408 211 811 - - 13,300,000.00 3,380,000.00 920,000.00 120,262.50 0.00 2,460,000.00 1,040,262.50 12 TJX Special Taxing District 2002 2022 324/404/414 1/1 7/1 - - 6,620,000.00 3,405,000.00 360,000.00 152,712.50 0.00 3,045,000.00 512,712.50 5 Downtown Central Area TIF 2003 2011 2024 420 211 8/1 - - 19,795,000.00 16,120,000.00 1,155,000.00 759,297.00 0.00 14,965,000.00 1,914,297.00 5 Airport Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14,420,000.00 9,195,000.00 660,000.00 433,067.75 0.00 8,535,000.00 1,093,067.75 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 211 8/1 - - 5,485,000.00 4,465,000.00 210,000.00 281,495.00 0.00 4,255,000.00 491,495.00 sa Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36,000,000.00 34,050,000.00 1,030,000.00 1,894,868.00 0.00 33,020,000.00 2,924,868.00 at Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4,980,000.00 3,520,000.00 605,000.00 159,745.00 0.00 2,915,000.00 764,745.00 as SB Economic Develop Revenue Bonds Career Academy 2011 2014 324 2/15 5/15 8/15 11/15 1,500,000.00 500,000.00 500,000.00 12,500.00 0.00 0.00 512,500.00 too 2012 Gatos Downtown Campus VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 1,700,000.00 1,133,333.34 566,666.66 0.00 0.00 566,666.68 566,666.66 121 Blackthom Golf Cart Lease xxx Blackthorn Golf 2014 2019 619 Monthly 14th 293,788.00 0.00 36,549.96 5,248.60 293,788.00 257,238.04 41,798.56 Total Bond Debt 139 713 788.00 83 123 333.34 7,613,216.62 4 003 233.85 293 788.00 75 803 904.72 11 616 450.47 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 482,021.41 58,200.48 13,809.96 0.00 423,820.93 72,010.44 4 Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 133,214.96 16,084.70 3,816.62 0.00 117,130.26 19,901.32 2 State Industrial Development Fund Bosch Property 2002 2017 210 4/1 10/1 - - 1,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00 14 Indiana Development Finance Authority Frederickson Park 2003 2012 404 3131 6/30 9130 12131 764,809.60 0.00 0.00 0.00 0.00 0.00 0.00 15 Indiana Development Finance Authority Frederickson Park (Forgive) 2003 2012 404 - - - - 191,202.40 0.00 0.00 0.00 0.00 0.00 0.00 is Indiana Development Finance Authority Anchor 2005 2014 404 6130 12131 - - 600,000.00 66,666.72 66,666.72 1,250.00 0.00 0.00 67,916.72 17 Indiana Development Finance Authority Anchor (Forgive) 2005 2014 404 6/30 12/31 - - 75,000.00 10,714.32 10,714.32 200.89 0.00 0.00 10,915.21 tfD HUD Section 108#8 Studebaker Oliver 2008 2025 434 211 811 - - 4,000,000.00 1,005,000.00 825,000.00 41,949.00 0.00 180,000.00 866,949.00 w City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 343,532.46 91,529.37 16,046.63 0.00 252,003.09 107,576.00 e4 Intertund Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 2115 8/15 - - 1,040,319.00 923,829.00 37,152.00 45,733.00 0.00 886,677.00 82,885.00 as Interfund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31,032.00 15,516.00 3,879.00 0.00 0.00 11,637.00 3,879.00 a4 Interfund Fund 4112 Major Moves Triangle Development 2011 2029 436 2115 8115 - - 2,000,000.00 1,558,050.00 44,790.50 15,580.50 0.00 1,513,259.50 60,371.00 a5 ntedund Fund 412 - Major Moves Eddy Street Commons 2011 2026 436 2/15 8/15 - - 4,100,000.00 3,430,958.01 203,399.20 169,036.80 0.00 3,227,558.81 372,436.00 es Interfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 819 - - - 500,000.00 500,000.00 0.00 0.00 0.00 500,000.00 0.00 ae Blackthom Loan from Airport xxx Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53,598.50 36,848.90 6,699.84 0.00 0.00 30,149.06 6,699.84 Total Loans Payable 22 058 511.06 8,506,351.78 1 364 116.13 307 423.40 0.00 7,142.235.65 1 671 539.53 Capital Lease 75 PNC Equipment Financing xxx Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 106,802.80 52,087.76 4,333.24 0.00 54,715.04 56,421.00 Total Capital Lease 246,509.64 106,802.80 52,087.76 4,333.24 0.00 54,715.04 56,421.00 Leases 37 Transpo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3,000,000.00 371,710.00 180,363.00 19,637.00 0.00 191,347.00 200,000.00 13 Transpo Lease xxz Main / Colfax Garage 2006 2025 404 3/15 9/15 - - 2,510,278.00 1,788,501.00 111,958.00 88,042.00 0.00 1,676,543.00 200,000.00 Total Lease 5,510,278.00 2 160 211.00 1 292 321.00 1 107 679.00 0.00 1 1,867,890.00 400 000.00 Total Redeve /opment commisslon 167,529,086.70 93,896,698.92 1 9,321,741.51 1 4,422,669.49 293,788.00 1 84,868,745.41 13,744,411.00 Financial Report April 2014 -Debt City of South Bend Monthly Debt Schedule Period Ending; April 2014 Year of I Year of Year of Scheduled Payments Debt (Orig / Ref•) Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refunding wha Fund let I 2nd I 3rd I 4th Issue 12/3112013 I Payments Payments I A 4130 12014 Civil City Debt Bond Debt Amen scb k 3/ CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11,870,000.00 2,815,000.00 375,000.00 65,050.00 0.00 2,440,000.00 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1 - - 9,250,000.00 4,385,000.00 260,000.00 74,763.00 0.00 4,125,000.00 25 Water Works Improvements Water Works 2002 2012 2023 625 711 12/31 - - 5,975,000.00 3,450,000.00 0.00 0.00 0.00 3,450,000.00 39 South Bend Building Corporation Fire HO / Police HO 2003 2012 2023 404/324 2/1 8/1 - - 21,335,000.00 12,365,000.00 555,000.00 227,167.50 0.00 11,810,000.00 41 Sawage Works Improvements Sewage Works 2004 2024 649 611 12/1 - - 11,425,000.00 0.00 0.00 0.00 0.00 0.00 24 Water Works Improvements Water Works 2006 2027 625 7/1 12/31 - - 4,710,000.00 3,505,000.00 0.00 0.00 0.00 3,505,000.00 42 Sewage Works Improvements Sewage Works 2006 2026 649 611 12/1 - - 7,630,000.00 6,090,000.00 0.00 0.00 0.00 6,090,000.00 4o Sewage Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16,600,000.00 13,010,000.00 0.00 0.00 0.00 13,010,000.00 52 Sewage Works Revenue Bonds 2007B Sawage Works 2007 2027 649 6/1 12/1 - - 16,515,000.00 12,960,000.00 0.00 0.00 0.00 12,960,000.00 62 Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11/1 - - 4,655,000.00 3,990,000.00 0.00 0.00 0.00 3,990,000.00 69 Water Works Improvements Water Works 2009 2030 625 7/1 12131 - - 5,380,000.00 4,985,000.00 0.00 0.00 0.00 4,985,000.00 70 Sawaga Works Revenue Bonds -2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3,297,000.00 2,710,898.00 0.00 0.00 0.00 2,710,898.00 so 2010 Sawage Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9,345,000.00 8,270,000.00 0.00 0.00 0.00 8,270,000.00 93 Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21,500,000.00 19,895,000.00 0.00 0.00 0.00 19,895,000.00 ss 2012 Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8,300,000.00 7,960,000.00 340,000.00 118,643.13 0.00 7,620,000.00 101 2012 Sewage Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25,000,000.00 23,985,000.00 0.00 0.00 0.00 23,985,000.00 fo5 2013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14,765,000.00 13,700,000.00 0.00 0.00 0.00 13,700,000.00 116 2013 Building Corporation xxx EMS / Fire Department 2013 2033 288 2/1 8/1 - - 5,580,000.00 5,580,000.00 0.00 45,244.50 0.00 5,580,000.00 Total Bond Debt 225 632 000.00 149 655 898.00 1,530,000.00 530 868.13 0.00 148 125 898.00 Loans Payable 1 State Rev olvng Fund Bosch Property 2002 2022 210 1/30 4/30 7/30 10/30 506,448.00 0.00 0.00 0.00 0.00 0.00 6e State Revolving Fund Water Works Improvement 2009 2030 625 711 12131 - - 427,332.00 391,297.00 0.00 0.00 0.00 391,297.00 82 Interfund Loan 410 - UDAG tat Source/Marriott 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 Sewage Works Improvement 1998 2018 649 6/1 12/1 - - 24,095,000.00 0.00 0.00 0.00 0.00 0.00 26 State Revolving Fund xxx Water Works Improvements 2000 2019 625 7/1 12/31 - - 2,600,000.00 1,018,815.00 0.00 0.00 0.00 1,018,815.00 Total Loans Pa able 35 533 780.00 3.438.085.00 0.00 0.00 0.00 3.438.085.00 Capital Leases 27 LaSalle Bank - Fire Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 0.00 0.00 0.00 sf Chase LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 730,258.41 84,662.30 15,627.53 0.00 645,596.11 m Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 963,508.00 0.00 0.00 0.00 0.00 0.00 56 Oce Copier 209 N Main 2008 2013 620 Monthly - - - 12,078.21 0.00 0.00 0.00 0.00 0.00 57 Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 5s Lanier Copier 915 Oil- 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 59 Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 0.00 0.00 0.00 0.00 0.00 67 Sun Trust Solid Waste Containers/Trucks 2009 2014 611 3/1 9/1 - - 720,990.00 78,167.28 78,167.28 1,450.00 0.00 0.00 71 Kansas State Bank Clark Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,209.00 638.84 638.84 10.63 0.00 0.00 n Kansas State Bank Code Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10/23 9,209.00 2,594.75 1,007.94 91.34 0.00 1,586.81 73 Kansas State Bank Engineering Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,391.00 651.47 651.47 10.84 0.00 0.00 74 CSI Leasing Inc IT Netapp San 2010 2014 404 4/1 7/1 10/1 12/31 207,521.37 14,236.41 14,236.41 210.59 0.00 0.00 76 Kansas State Bank Central Services Copier 2010 2015 222 2/16 5/16 8/16 11/16 13,366.40 4,362.77 700.86 64.14 0.00 3,661.91 n GE Capital Information Technology Animal Control Copier 2010 2015 101 2/28 5/30 8/30 11130 3,550.69 1,161.97 186.33 17.52 0.00 975.64 7e Kansas State Bank Mayor Oce Copier 2010 2015 101 1/8 4/8 7/8 10/8 9,209.00 3,564.45 969.79 129.49 0.00 2,594.66 7s Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10,511.02 4,702.41 1,098.69 198.99 0.00 3,603.72 87 Public Finance.com Inc Solid Waste Containers /Trucks 2011 2015 611 6/15 12/15 - - 321,853.00 133,252.34 0.00 0.00 0.00 133,252.34 as Sun Trust Police, Parks, Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2,068,202.00 1,059,040.84 103,619.75 5,121.60 0.00 955,421.09 so Capital One Public Funding Solid Waste Containers /Trucks 2011 2016 611 3/15 6/15 9/15 12/15 207,432.00 116,115.23 10,338.06 483.33 0.00 105,777.17 s1 GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 2,065.68 389.58 54.78 0.00 1,676.10 s2 Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 843,595.57 274,272.26 21,127.15 0.00 569,323.31 s4 Ikon Office Solutions Mayor Ricoh MP 2851 SP Copiei 2011 2016 101 2/15 5/15 8/15 11/15 2,569.53 1,620.15 124.78 22.34 0.00 1,495.37 s5 Sun Trust Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 218,030.66 42,912.05 1,749.19 0.00 175,118.61 sl Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1,295,000.00 918,678.73 0.00 0.00 0.00 918,678.73 0 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15 - - 945,674.38 669,405.77 0.00 0.00 0.00 669,405.77 too PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15 - - 2,806,054.00 2,257,055.55 275,754.03 290,475.67 0.00 1,981,301.52 foe Ikon Office Solutions / Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 4,278.32 362.47 78.16 0.00 3,915.85 1. GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 4,249.41 255.21 62.49 0.00 3,994.20 Ice Ricoh USA Central Services Copier 2013 2018 222 2/27 5/27 8/27 11/27 3,622.78 3,004.64 181.89 28.05 0.00 2,822.75 107 Ricoh USA Street/Sewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 4,506.34 252.20 65.50 0.00 4,254.14 toe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5112 8112 11/12 5,559.15 4,528.32 273.87 43.82 0.00 4,254.45 127 Ricoh USA Parks & Rec Ricoh Copiem(3) 2013 2018 201 2121 5/21 8/21 11121 16,129.94 13,138.49 794.75 127.06 0.00 12,343.74 11c INC Equipment Finance Vehicle/Equipirent Lease 2013 2018 1011202/406/641 1115 7115 - - 1,689,669.59 1,689,669.59 162,086.32 12,863.94 0.00 1,527,583.27 111 Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 8,694.31 460.94 187.06 0.00 8,233.37 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 3,854.47 243.64 69.36 0.00 3,610.83 113 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 - - 1,506,465.26 1,506,465.26 145,351.84 11,938.73 0.00 1,361,113.42 114 Ricoh USA Admin & Finance Copier 2013 2018 101 1116 4116 7116 10/16 11,247.97 9,620.91 1,013.08 272.54 0.00 8,607.83 115 CSI Leasing Inc 2010 Server IT Lease 2010 2014 404 211 5/1 8/1 11/1 28,588.00 5,869.74 1,928.70 84.50 0.00 3,941.04 117 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 9,678.26 565.50 174.50 0.00 9,112.76 113 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 5,647.50 329.88 101.92 0.00 5,317.62 fts Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copie 2013 2018 620 Monthly 16th 4,732.65 4,732.65 276.44 85.40 0.00 4,456.21 12o Water Works Olive Ricoh Copier Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 4,732.65 276.44 85.40 0.00 4,456.21 Total Ca ita /Lease 18,788,201.74 10,341,870.14 1,204,383.59 363,113.56 0.00 9,137,486.55 Total Glvll GUY 279,953,961.74 163,435,653.141 2,734,353.591 693,961.69 U.UU 11JU,7U1,469.551 Financial RepW April 2014 - Debt Page 20 0/25 City of South Bend Monthly Debt Schedule Period Ending; April 2014 Year of I Year of Year of Scheduled Payments Debt (Orig / Reh) Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refunding Maturi Fund 1st 2rd 3rd 4th Issue 12/31/2013 Pa ments Payments I A 4130 12014 Redevelopment Commission Debt Bond Debt 9 Central Business TIF 1990 1996 2012 420 2J 1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 to Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 0.00 0.00 0.00 0.00 0.00 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2J 1 811 - - 6,825,000.00 2,070,000.00 220,000.00 24,275.00 0.00 1,850,000.00 a College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15,370,000.00 5,285,000.00 560,000.00 71,083.75 0.00 4,725,000.00 tI South Bend Building Corporation Morris PAC 1998 2009 2017 408 211 811 - - 13,300,000.00 3,380,000.00 455,000.00 64,112.50 0.00 2,925,000.00 12 TJX Special Taxing District 2002 2022 324/404/414 1/1 7/1 - - 6,620,000.00 3,405,000.00 345,000.00 83,256.25 0.00 3,060,000.00 5 Downtown Central Area TIF 2003 2011 2024 420 211 811 - - 19,795,000.00 16,120,000.00 570,000.00 385,676.25 0.00 15,550,000.00 s Airport Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14,420,000.00 9,195,000.00 325,000.00 219,970.75 0.00 8,870,000.00 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 211 8/1 - - 5,485,000.00 4,465,000.00 210,000.00 143,950.00 0.00 4,255,000.00 sa Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36,000,000.00 34,050,000.00 510,000.00 952,534.00 0.00 33,540,000.00 a1 Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4,980,000.00 3,520,000.00 300,000.00 82,872.50 0.00 3,220,000.00 96 SB Economic Develop Revenue Bonds Career Academy 2011 2014 324 2/15 5/15 8/15 11/15 1,500,000.00 500,000.00 125,000.00 5,000.00 0.00 375,000.00 104 2012 Gates Downtown Campus VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 - - 1,700,000.00 1,133,333.34 283,333.33 0.00 0.00 850,000.01 121 Blackthorn Golf Cart Lease xxx Blackthorn Golf 2014 2019 619 Monthly 14th 293,788.00 0.00 0.00 0.00 293,788.00 293,788.00 Total Bond Debt 139 713 788.00 83 123 333.34 3,903,333.33 2 032 731.00 293 788.00 79 513 788.01 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 482,021.41 14,387.45 3,615.16 0.00 467,633.96 4 Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 133,214.96 0.00 0.00 0.00 133,214.96 2 State Industrial Development Fund Bosch Property 2002 2017 210 4/1 10/1 - - 1,000,000.00 0.00 0.00 0.00 0.00 0.00 14 Indiana Development Finance Authority Frederickson Park 2003 2012 404 3131 6130 9130 12131 764,809.60 0.00 0.00 0.00 0.00 0.00 15 Indiana Development Finance Authority Frederickson Park (Forgive) 2003 2012 404 - - - - 191,202.40 0.00 0.00 0.00 0.00 0.00 is Indiana Development Finance Authority Anchor 2005 2014 404 6/30 12131 - - 600,000.00 66,666.72 0.00 0.00 0.00 66,666.72 17 Indiana Development Finance Authority Anchor (Forgive) 2005 2014 404 - - - - 75,000.00 10,714.32 0.00 0.00 0.00 10,714.32 so HUD Section 108#8 Studebaker Oliver 2008 2025 434 211 811 - - 4,000,000.00 1,005,000.00 0.00 20,974.00 0.00 1,005,000.00 s3 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 343,532.46 45,199.69 8,588.31 0.00 298,332.77 s4 Intertund Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 2115 8/15 - - 1,040,319.00 923,829.00 18,347.00 23,096.00 0.00 905,482.00 a1 Interfund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31,032.00 15,516.00 0.00 0.00 0.00 15,516.00 b4 Interfund Fund 412 - Major Moves Triangle Development 2011 2029 436 2115 8115 - - 2,000,000.00 1,558,050.00 0.00 0.00 0.00 1,558,050.00 85 ntedund Fund 412 - Major Moves Eddy Street Commons 2011 2026 436 2/15 8/15 - - 4,100,000.00 3,430,958.01 100,444.05 85,773.95 0.00 3,330,513.96 es Interfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 819 - - - 500,000.00 500,000.00 0.00 0.00 0.00 500,000.00 ae Blackthom Loan from Airport Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53,598.50 36,848.90 0.00 0.00 0.00 36,848.90 Total Loans Pa able 22058511. 178 378.19 142 047.42 0.00 8,327,973.59 Capital Lease 75 PNC Equipment Financing Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 106,802.80 0.00 1,765.68 0.00 106,802.80 Total Capital Lease 246,509.64 106,802.80 0.00 1,765.68 0.00 106,802.80 Leases 37 Transpo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3,000,000.00 371,710.00 0.00 0.00 0.00 371,710.00 13 Transpo Lease xxz Main / Colfax Garage 2006 2025 404 3/15 9/15 - - 2,510,278.00 1,788,501.00 55,288.00 44,712.00 0.00 1,733,213.00 Total Lease 5,510,278.00 2 160 211.00 1 55 288.00 1 44 712.00 0.00 2,104,923.00 Total Redevelopment Commission 167,529,086.70 93,896,698.92 1 4,136,999.52 1 2,221,256.10 293,788.00 90,053,487.40 Financial Repat Apn12014 - Debt Page 21 0/25 City of South Bend Staffing Headcount Summary City Total 1328.00 1316.00 1298.00 1325.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report April 2014 - Headcount Staffing Page 22 of 25 Budget I I I I I I I Prior Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec I Year End Full Time Staff 1160.00 1116.00 1104.00 1106.00 1109.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Part Time Staff 74.00 74.00 71.00 71.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Temporary /Seasonal 1 138.00 138.00 121.00 145.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 1328.00 1316.00 1298.00 1325.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report April 2014 - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff General Government Mayor 7.00 7.00 7.00 7.00 7.00 311 Call Center 7.00 7.00 7.00 7.00 7.00 Admin & Finance 23.00 21.00 21.00 21.00 22.00 Safety & Risk 3.00 3.00 3.00 3.00 3.00 Clerk 5.00 5.00 5.00 5.00 5.00 Common Council 9.00 9.00 9.00 9.00 9.00 L al De artment 10.00 9.00 9.00 9.00 10.00 Sub Total 64.00 61.00 61.00 61.00 63.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enfor. /Animal Control 26.00 24.00 21.00 21.00 23.00 Dept. of Community Investment 26.00 26.00 26.00 26.00 26.00 Parks & Recreation Public Safety Public Works Administration 12.00 11.00 11.00 11.00 11.00 Maintenance 44.00 44.00 44.00 44.00 44.00 Golf Operations 8.00 8.00 8.00 8.00 9.00 Recreation Cps/ 26.00 26.00 26.00 27.00 26.00 Zoological Ops 23.00 3.00 3.00 3.00 3.00 Greenhouse Ops 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 1.00 1.00 Recreation Nonreverting 1.00 1.00 1.00 1.00 1.00 Sub Total 115.00 94.00 94.00 95.00 95.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 297.00 289.00 283.00 285.00 283.00 Communications 38.00 32.00 33.00 34.00 34.00 Fire 260.00 263.00 260.00 261.00 258.00 Sub Total 595.00 584.00 576.00 580.00 575.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Central Services 40.00 37.00 37.00 37.00 38.00 Engineering 16.00 14.00 14.00 16.00 16.00 Maintenance 3.00 3.00 3.00 3.00 3.00 Solid Waste Operations 25.00 25.00 25.00 25.00 25.00 Street Operations 60.00 60.00 60.00 59.00 60.00 Sewer Operations 35.00 35.00 35.00 32.00 33.00 Waste Water Ops 44.00 44.00 44.00 44.00 44.00 Organic Resources 6.00 6.00 6.00 6.00 6.00 Water Utilit O s 70.00 69.00 69.00 68.00 69.00 Sub Total 299.00 293.00 293.00 290.00 294.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Building Department 15.00 14.00 13.00 13.00 13.00 Human Rights 6.00 6.00 6.00 6.00 6.00 Morris & Palais 14.00 14.00 14.00 14.00 14.00 City Total 1160.00 1116.00 1104.00 1106.00 1109.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report April 2014 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff General Government Code Enf. /Animal Control Prior Jan Feb Mar I Apr May I Jun I Jul Aug I Sep I Oct Nov I Dec Year End Mayor 1.00 1.00 1.00 1.00 311 Call Center 1.00 Admin & Finance 1.00 Clerk Common Council Le al De artment 4.00 4.00 4.00 4.00 Sub Total 5.00 5.00 5.00 7.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.00 2.00 2.00 2.00 Dept. of Community Investment 1.00 1.00 Parks & Recreation Public Safety Administration 5.00 5.00 5.00 5.00 Maintenance 3.00 3.00 3.00 3.00 Golf Operations 4.00 4.00 1.00 1.00 Recreation Ops 30.00 30.00 28.00 26.00 Zoological Ops 6.00 6.00 3.00 3.00 Greenhouse Ops 2.00 2.00 2.00 2.00 Graffiti Removal 3.00 3.00 5.00 4.00 Sub Total 44.00 44.00 40.00 38.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 4.00 4.00 5.00 5.00 Communications Fire 1.00 1.00 1.00 1.00 Sub Total 5.00 5.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Works 1.00 5.00 1.00 5.00 2.00 5.00 2.00 5.00 Central Services 1.00 1.00 1.00 2.00 0.00 Engineering 4.00 4.00 2.00 2.00 Traffic & Lighting Maintenance Solid Waste Ops 2.00 2.00 2.00 2.00 Street Ops 3.00 3.00 5.00 4.00 Sewer Ops Waste Water Ops Water Utilit Ops 1.00 1.00 1.00 1.00 Sub Total 11.00 11.00 11.00 11.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Building Department 0.00 Human Rights Morris & Palais 1.00 5.00 1.00 5.00 2.00 5.00 2.00 5.00 0.00 City Total 74.00 74.00 71.00 71.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report April 2014 - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Temporay,Seasonal, and Intern Staff Public Works Building Department Human Rights Morris & Palais Central Services Engineering 1.00 1.00 1.00 1.00 Traffic & Lighting Prior Jan Feb Mar Apr l Ma Jun y l Jul Au Se Aug l p l Oct Nov Dec Year End General Government Street Ops 2.00 2.00 2.00 10.00 Sewer Ops 5.00 5.00 5.00 Leaf Pickup Mayor Waste Water Ops Organic Resources 1.00 1.00 1.00 Admin & Finance 1.00 2.00 2.00 2.00 3.00 Sub Total 20.00 20.00 17.00 25.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Clerk Common Council Le al Sub Total 1.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enforcement 1.00 0.00 1.00 1.00 0.00 Dept. of Community Investment Parks & Recreation Administration 5.00 5.00 5.00 5.00 Maintenance 17.00 17.00 9.00 19.00 Golf Operations 1.00 1.00 24.00 40.00 Recreation Ops 51.00 51.00 35.00 27.00 Zoological Ops 0.00 0.00 0.00 0.00 Greenhouse Ops 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 1.00 Sub Total 75.00 75.00 74.00 92.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Safety Police 41.00 41.00 27.00 25.00 Communications Fire Sub Total 41.00 41.00 27.00 25.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Works Building Department Human Rights Morris & Palais Central Services Engineering 1.00 1.00 1.00 1.00 Traffic & Lighting Maintenance Solid Waste Ops 8.00 8.00 5.00 10.00 Street Ops 2.00 2.00 2.00 10.00 Sewer Ops 5.00 5.00 5.00 Leaf Pickup Waste Water Ops Organic Resources 1.00 1.00 1.00 1.00 Water Utilit Ops 3.00 3.00 3.00 3.00 Sub Total 20.00 20.00 17.00 25.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 138.00 138.00 121.00 145.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report April 2014 - Headcount Staffing Page 25 of 25