Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
07-2014 Financial Report
Tab Narrative Revenue Prop Tax Rev Expenditures Debt Debt Monthly Headcount Distribution Period Ending: Issued BY: July 2014 Controller City of South Bend Financial Report Page Contents 2 Brief discussion on notable fund activity 3 -10 City Revenues 11 -13 Property Tax Revenue Collection Status 14 -18 Expenditures by Fund and Department 19 -20 Debt Status 21 -22 Current Debt at Month End 23 -26 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 July 2014 Page 1 of 26 July 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 55 %. In comparison, the overall percentage of collected revenue amount for July 2013 was 52 %. Revenue type 334 (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. Also this month for revenue type 367 (Donations) the City received $480,027. The University of Notre Dame donated $330,000 as part of its ten year pledge that will expire in 2018. Also $150,000 was received from the Urban Enterprise Association, (UEA), for vacant and abandoned property demolitions. Revenue by fund As of July 2014, the general fund has received 54% of its budgeted revenue versus 55% last year. In 2013, the City made an early quarter transfer from the Public Safety LOIT fund to the general fund. The 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 from the county. This was formerly in the general fund. Fund 227 (Loss Recovery) is at 94% of its budgeted revenue. Also, fund 217 ( Gift, Donation, Bequest) is at 2350% of its budgeted revenue. As mentioned above, $150,000 was received for vacant and abandoned properties from the UEA. This month funds 249, 404, and 408 did not receive its monthly contributions from the county. The money will be received in August. These contributions total $1.9 million per month. Property taxes Property taxes are received in June and December. Property taxes collected in June 2014 totaled $38.9 million. Civil city funds received $24.5 million and TIF funds received $14.4 million (more information on property taxes in 2014 as it relates to levy records and projected collections will be available soon.) 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 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 was -$70.0 million, which is a net reduction of $2.9 million from 2012. Expenditures As of July 2014, the City has spent 40% of budgeted expenditures, versus 44% of budgeted expenditures in July 2013. The General Fund has spent 55% of its 2014 budgeted expenditures, compared to 54% in 2013. The following funds have reached 70% 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 73% of budget due to capital improvement for the zoo. Debt In July 2014, several debt service payments were made in the amount of - $861,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 July 2014 was 1,108 vs. a budgeted amount of 1,160. Currently, there are a total of 52 vacant positions. There are 32 open positions in the following departments: Public Safety (13), Public Works (9), Code Enforcement / Animal Control (3), Building Department (1), Parks Administration (3) and other (3). The other 20 budgeted positions in the parks department will not be filled due to privatizing of the Potawatomi Zoo. Financial Report July 2014 Page 2 of 26 City of South Bend Period Ending: July 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 Auto Excise Tax various 311 Property Tax Civil City various 226 1,570,035 2,504,793 63% 312 Commercial Vehicle Tax 24,319,653 24,319,653 44,418,000 55% 311 Pro a Tax T/F Districts various 47% 312 Financial Institutions Tax various 2,575 14,671,628 14,671,628 24,374,000 60% 311 Pro a Tax Civil City - Prior various 656,725 377,765 377,765 667,713 1,324,438 1,313,436 101% 317 Hotel Motel Tax Century Center NA 311 Property Tax TIF Districts - Prior various 11,403 200,000 401,000 50% 317 Hotel Motel Tax Cum Cap Im ry 407 various 266,072 NA xxx xxx xxx 100% 62% 101,267 Central Service nd premium 6611623 49,015 46,909 NA NA Sub Total xxx 337,414 362,053 381,987 420,143 394,207 38,991,281 38,991,281 68,792,000 57% Income Tax 101 188,273 1,315,867 38,577 NA 342 EMS County Contract 101 136,239 136,239 136,239 136,239 136,239 136,239 315 Econ Development Income Tax -Prig 102 60% xxx xxx xxx 45,989 56% 380 48,434 150,267 NA 315 Econ Development Income Tax 408 733,068 733,068 733,068 733,068 733,068 733,068 4,398,410 8,796,821 50% 316 Local Option Income Tax -PS 249 531,669 531,669 531,669 531,669 531,669 531,669 3,190,015 6,380,029 50% 316 County Option Income Tax 404 720,484 720,484 720,484 720,484 720,484 720,484 4,322,905 8,645,811 50% 316 County Option Income Tax -Prior Yr 102 459,805 585,235 495,555 466,132 973,694 6,586,862 666,018 10,233,300 NA 46% Sub Total 1,985,222 1,985,222 1,985,222 1,985,222 1,985,222 1,985,222 11,911,330 23,822,661 50% St Joseph Count Remitted b 312 Auto Excise Tax various decal Drug 312 CREED Tax 1,570,035 226 1,570,035 2,504,793 63% 312 Commercial Vehicle Tax various 26,080 75,000 414,633 0% 414,633 882,628 47% 312 Financial Institutions Tax various 2,575 157,249 35,000 157,249 329,818 NA 317 Hotel Motel Tax Century Center 670 656,725 377,765 377,765 667,713 1,324,438 1,313,436 101% 317 Hotel Motel Tax Century Center 420 487 200,000 439 11,403 200,000 401,000 50% 317 Hotel Motel Tax Cum Cap Im ry 407 various 266,072 1,450,000 150,000 150,000 150,000 100% 62% 101,267 Central Service nd premium 6611623 49,015 46,909 600,000 NA xxx xxx xxx 337,414 362,053 381,987 420,143 394,207 474,981 NA xxx xxx xxx 59% 335 Liquor Excise tax 101 188,273 1,315,867 38,577 NA 342 EMS County Contract 101 136,239 136,239 136,239 136,239 136,239 136,239 136,239 953,673 1,588,824 60% xxx xxx xxx 45,989 56% 380 48,434 150,267 200,000 NA Sub Total 377 136,239 792,964 136,239 336,239 136,239 2,120,907 953,952 4,61Z779 6,840,681 67% State of Indiana Remitted b decal Drug 312 CREED Tax 434 226 235,157 5,304 14,852 4,256 1,668 26,080 75,000 650,000 0% 335 Cigarette Tax 1011407 General Government Misc Ch s 10,810 12,724 2,575 157,249 35,000 157,249 329,818 48% 335 State Pension Subsidy 7011702 377,765 377,765 377,765 377,765 2,644,355 5,620,482 ntractual Service 5,620,482 11,686,832 487 335 CTP Distribution 439 11,403 37,393 59,225 219,499 198,800 nds various 266,072 1,450,000 0% 335 Gaming Proceeds 101 101,267 62% 101,267 Central Service nd premium 6611623 49,015 46,909 600,000 0% 335 Gasoline Tax 2021251 337,414 362,053 381,987 420,143 394,207 474,981 405,682 2,776,467 4,713,418 59% 335 Liquor Excise tax 101 188,273 1,315,867 38,577 52% 391,184 25,240 406,771 63,817 82,000 78% 335 Liquor Gallonage Tax 101 55,845 373,168 2,571,254 45,989 56% 380 48,434 150,267 200,000 75% 335 ProfSports Development Tax 377 66,547 113,592 259,246 1,306,527 2,190,551 121,525 40,184 341,848 600,000 57% 335 Wheel Tax 202 289,249 109,590 74,990 289,249 579,487 187,385 171,718 1,123,170 2,000,000 56% xxx xxx xxx 3,039,278 3,486,819 1,050,575 956,852 1,120,384 14,980,238 24,931,652 60% 395 NA Sub Total 946,856 459,805 585,235 495,555 466,132 973,694 6,586,862 666,018 10,233,300 22,312,068 46% 7overnmental Sources decal Drug 299 Liability Insurance 226 235,157 5,304 14,852 4,256 1,668 26,080 75,000 ite Drug 216 58% 340 General Government Misc Ch s 10,810 12,724 2,575 26,108 35,000 yment in Lieu of Tax various 377,765 377,765 377,765 377,765 377,765 377,765 377,765 2,644,355 4,533,175 ntractual Service 211 13,419 11,183 29,006 57,869 11,403 37,393 59,225 219,499 198,800 nds various 266,072 219,847 300,262 168,560 1,621,076 101,267 62% 101,267 Central Service nd premium 6611623 49,015 46,909 47,019 43,783 46,212 46,488 327,087 619,002 53% K XXX 222 204,221 185,484 192,354 198,773 164,513 182,249 188,273 1,315,867 b Total 52% 391,184 388,948 406,771 451,747 416,744 520,681 441,233 3,017,310 4,841,975 Charge for Service Internal City 340 Liability Insurance 226 235,157 235,157 241,463 238,310 238,310 238,310 238,310 1,665,017 2,859,690 58% 340 General Government Misc Ch s 1017289 160 1,316 26,800 28,276 NA 340 Police Take Home Vehicle 278 7,160 4,730 4,640 4,700 4,700 4,700 4,680 35,310 60,580 58% 342 EMS Capital 288 151,160 281,678 233,496 266,072 219,847 300,262 168,560 1,621,076 2,600,000 62% 349 Central Service 222 47,661 49,015 46,909 47,019 43,783 46,212 46,488 327,087 619,002 53% 380 Central Service 222 204,221 185,484 192,354 198,773 164,513 182,249 188,273 1,315,867 2,545,960 52% 380 Energy Office Reimbursements 222 417,066 432,016 417,491 380,370 309,248 241,895 373,168 2,571,254 4,632,222 56% 380 Internal Service Reimbursement various 138,730 122,721 267,168 251,882 161,822 104,957 259,246 1,306,527 2,190,551 60% 392 Administration Fee 101 289,249 289,249 289,249 289,249 289,249 289,249 289,249 2,024,743 3,470,989 58% 392 Internal Fund Transfers various 4,314,974 1,011,355 3,039,278 3,486,819 1,050,575 956,852 1,120,384 14,980,238 24,931,652 60% 395 Employee Benefits various 946,856 995,209 1,002,625 1,362,041 1,088,236 1,081,657 1,090,339 7,566,964 13,487,514 56% Financial Report July 2014 - Revenue Report Page 3 026 City of South Bend Period Ending: July 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 396 Central Service Refunds 222 1,763 1,798 6,662 1,927 1,831 13,981 22,000 6, 396 Self Funded Employee Benefits 711 11,182 (99) 93,040 104,123 1, xxx xzx xxx A Sub Total 6,753,998 3,608,413 5,746,016 6,531,797 3,573,526 3,448,174 3,898,539 33,560,463 57,420,160 51 I Party Revenue 340 No EMS Service 101 320 Inspections Central Service 28,006 3,332 13,674 5,512 2,824 53,347 90,000 5S 340 Memorial Hospital Neo Natal 101 40,938 39,124 35,592 34,101 32,462 38,807 34,860 255,884 365,000 A 350 Job Target Penalty Fee 408 354,660 98,865 116,865 85% 321 Code and Animal Fees 600 354,660 354,660 IN 364 Cable TV Franchise Fees 101 180,787 5,776 4,823 181,751 57,000 61% 362,538 750,000 41 366 AT&T Franchise Fees 101 55,613 75,911 80,144 56,518 83,665 546,625 112,131 202,000 51! 380 Loss Recovery 227 550 100 100 450 5,900 5,650 A 380 Bosch Reimbursement/ DCI 324 322 EMS Capital 288 1,951 2,376 2,353 1,310 2,678 A Sub Total 13,386 40,938 630,184 63,598 37,433 284,405 44,319 37,684 1,138,561 1,761,660 & ints 331 Federal Grants various 186,142 152,888 51,992 47,583 390,448 160,732 1,110,410 2,100,195 7,648,787 2; 334 State Grants various 215,000 10,000 225,000 2,215,000 V 360 UDAG 410 1. xxx xxx 1 Sub Total 401,142 152,888 51,992 47,583 390,448 170,732 1,110,410 2,325,195 9,863,787 2, Fees for Services External 320 Inspections Central Service 222 370 680 400 1,450 1,050 138% 321 Business License 1011222 36,125 19,849 15,838 15,052 6,766 2,937 2,298 98,865 116,865 85% 321 Code and Animal Fees 600 5,770 4,097 4,413 5,415 4,285 5,776 4,823 34,579 57,000 61% 322 Building Fees 600 80,552 51,919 83,990 75,911 80,144 90,443 83,665 546,625 1,156,600 47% 322 Code Enforcement Fees 600 550 100 100 450 5,900 5,650 1,450 3,000 48% 322 EMS Capital 288 1,951 2,376 2,353 1,310 2,678 1,823 895 13,386 19,000 70% 322 General Government Fees 101 920 1,681 2,375 1,500 1,860 1,195 3,225 12,756 10,000 128% 341 General Government Various various 952 1,077 2,703 1,681 2,425 1,852 7,540 18,231 87,405 21% 342 Highway &Streets 1011202 26,493 20,100 9,381 8,871 38,266 30,104 15,066 148,280 190,000 78% 342 Public Safety various 25,316 10,922 7,390 14,858 6,362 5,416 11,331 81,593 130,000 63% 343 Highway & Streets 202 NA 344 Solid Waste 610 396,546 392,279 391,374 398,710 399,877 402,065 399,430 2,780,281 4,766,995 58% 344 Code Environmental Clean Up 1011600 5,284 5,038 7,784 11,188 8,001 3,605 4,517 45,416 50,000 91% 344 Sewage Waste Water 641 2,670,534 2,630,565 2,649,615 2,773,801 2,849,977 2,918,413 2,956,564 19,449,469 34,485,568 56% 344 Sewer Repair Insurance 640 47,660 45,850 48,269 49,367 48,620 49,793 48,706 338,265 548,000 62% 344 Water Leak Insurance 620 80,687 80,448 80,578 80,851 80,849 4,310 80,970 488,695 960,000 51% 346 Water Works Utility 620 904,758 1,107,816 1,002,853 1,016,525 1,025,445 1,320,058 1,085,238 7,462,692 13,629,253 55% 346 Solid Waste Misc 610 3,940 3,910 4,492 18,633 34,920 25,948 16,975 108,818 48,835 223% 346 Project ReLeaf 655 36,254 36,124 36,251 36,372 36,376 36,453 36,462 254,290 429,000 59% 347 Parks& Recreation various 70,289 189,088 109,825 323,691 253,042 364,432 467,876 1,778,242 3,424,732 52% 347 Blackthorn Golf Club 619 71,571 84,446 56,179 127,218 204,566 229,433 239,340 1,012,753 1,696,879 60% 347 Morris PAC 416 7,305 7,851 13,814 8,587 8,549 1,497 2,477 50,080 100,000 50% 349 Parking Garage Fees 601 94,897 64,534 74,073 71,198 62,422 92,266 63,249 522,639 900,500 58% 349 Code Demolition Board Up 1017600 6,168 1,463 1,403 1,207 9,670 1,555 1,904 23,370 20,000 117% 349 Parking Century Center 670 9,503 19,224 23,453 6,149 5,480 5,791 3,090 72,690 175,000 42% 349 Parking SBCDA 420 2,432 2,820 3,359 3,342 3,175 1,324 3,634 20,086 34,000 59% 351 Fines &Fees various 16,291 14,865 24,764 18,480 18,613 13,293 19,410 125,716 265,320 47% 352 Forfeits various 1,250 1,340 1,950 9,495 75 87,594 5,450 107,154 200,000 54% 354 Ordinance Violation various 2,238 2,170 1,518 2,370 1,112 3,049 535 12,991 36,800 35% 360 Morris PAC various 55,061 50,740 141,675 67,138 53,643 258,527 24,933 651,717 884,000 74% 360 Palais Royale various 24,895 6,097 5,364 5,319 31,626 12,232 7,978 93,511 207,981 45% 360 Parks& Recreation various 28,974 14,868 7,730 8,693 5,161 3,401 10,312 79,139 84,050 94% 360 Police various 11,956 950 900 760 1,080 1,346 2,380 19,373 46,600 42% 360 TIF various 3,416 4,763 3,883 4,318 841 4,467 3,373 25,061 44,194 57% 360 COIT 404 36,458 0% 360 Central Services 222 41,759 3,015 351 1,351 1 46,477 11,000 423% 360 Century Center 670 1,805 7,700 14,453 2,260 4,666 5,330 127 36,342 45,000 81% 360 Code 101 1600 46 51 252 118 50 517 1,000 52% 360 Cumulative Capital Improvement 4061407 854 854 NA 360 Dept. Of Community Investment 2117212 6 52,208 40,415 56,705 111,753 261,087 283,000 92% 360 Stud. /Oliver Rev. Grants 209 300,000 0% 360 EMS Capital 288 59 117 9 1,256 1,441 16,000 9% 360 Engineering/ Curb & Sidewalk 101 89 189 104 164 175 725 350 1,798 22,000 8% Financial Report July 2014 - Revenue Report Page 4 026 City of South Bend Period Ending: July 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 8,245 1,220 9,465 eter Hydrant Reimbursement NA 360 Police Pension Fund 702 20,000 oceeds F.A. Disposal 600 1,500 le of Fixed Assets various 4,000 0% 360 General Government Various 101131226 various 36,377 803 202 469 XXX 97 37,010 1,100 3365% 360 P -Card Commissions 101 27,672 34,500 30,000 0% 360 General SBCDA Account 420 NA 360 Hall of Fame 3131677 NA 360 Motor Vehicle Highway 202 NA 360 Motor Vehicle Highway Scrap Meta 202 1,331 1,204 2,535 4,000 63% 360 Motor Vehicle Highway Curb Pr gm 202 6,563 8,579 4,684 1,803 2,857 8,184 3,215 35,885 25,000 144% 360 Parking Garage Fund 601 275 78 235 588 NA 360 ProfessionalSports Development 377 34,608 32,102 66,710 74,228 90% 360 Solid Waste Fund 610 1,389 15 1,404 1,000 140% 360 Waste Water 6411719 2,621 2,611 5,321 4,529 5,637 346 14,841 35,906 24,620 146% 360 Sewage Depreciation Fund 642 NA 360 Streets Scrap Metal Sale 101 NA 360 Water Works Utility 620 31,554 846 58 1,676 861 2,568 37,563 39,580 95% 362 General Fund 101 NA 362 Dept. Of Community Investment 212 1,847 1,847 1,847 5,540 NA 362 Palais Royale 101 2,490 990 1,848 1,825 8,498 2,192 5,668 23,511 84,000 28% 362 Parks & Recreation 201 1,329 2,226 5,680 4,781 7,774 6,724 5,241 33,755 43,900 77% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 14,675 17,473 10,973 25,185 13,019 19,295 15,724 116,344 201,951 58% 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 152,417 152,953 670,535 1,442,881 3,031,462 48% 399 Bosch Retention Project 210 14,387 14,495 28,883 58,203 50% 399 Principal on Loan various 19,196 21,428 1,967 35,031 18,244 19,075 18,435 133,375 195,349 68% 399 Principal Income xxx 186,218 41,443 5,289 232,950 556,798 42% xxx xxx xxx NA Sub Total 4,937,828 5,353,133 5,089,003 5,409,190 5,50Z275 6,263,873 6,507,717 39,063,018 70,073,276 56% ome nk Account Interest various 32,479 87,965 108,404 120,271 38,199 51,939 27,878 467,136 991,830 K XXX K XXX b Total 32,479 87,965 108,404 120,271 38,199 51,939 27,878 467,136 991,830 I Contribution 101 330,000 330,000 330,000 nations various 268 22,291 62 27 27 27 150,027 172,729 32,740 K XXX b Total 268 22,291 62 27 27 27 480,027 502,729 362,740 enervation lais 450 1,796 334 125 384 145 841 132 3,757 16,000 �neral Fund 101 - - - - - - - - - - - - - - K XXX b Total 1,796 334 125 384 145 841 132 3,757 16,000 ets 4201324 8,245 1,220 9,465 eter Hydrant Reimbursement 620 11,797 3,176 (150) 3,384 18,207 20,000 oceeds F.A. Disposal 600 1,500 le of Fixed Assets various 12,000 hicle Damage Reimbursement various 1,000 K XXX b Total 11,797 11,421 (150) 1,220 3,384 27,672 34,500 Revenue Total 15,140, 898 13, 619, 374 14, 094,408 15, 385, 874 13,30Z 144 60,188, 241 14,123, 591 - - - - - 145,854,530 267,133,338 5511 report 15,140, 898 13, 619, 374 14, 094,408 15, 385, 874 13,30Z 144 60,188, 241 14,123, 591 145,854,530 267,133,338 Financial Report July 2014 - Revenue Report Page 5 026 City of South Bend Revenue by Fund Report Period Ending: July 2014 s i Fund Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Bud et I ofeud et General Government 0000 General Revenues 101 831,705 1,001,393 800,251 805,843 982,078 22,482,554 1,119,005 28,022,829 50,899,278 55% 0101 Mayor 101 227 151 35 276 27 (636) 80 600 13% 0104 311 Call Center 101 26,509 109,227 38,185 34,017 31,299 34,739 273,976 480,077 57% 0201 Clerk 101 NA 0301 Common Council 101 41 27 27 27 434 556 8,300 7% 0401 Administration and Finance 101 30,050 0% 0501 Legal 101 15 1,044 8 542 14 1,623 72,350 2% xxx xxx NA Sub Total 858,496 1,002,615 909,548 844,847 1,016,135 22,513,880 1,153,542 28,299,064 51,490,655 55% Public Works 0600 Energy Office 101 NA 0602 Engineering 101 115 18,481 575 200 19,371 6,100 318% 0606 Building Maintenance 101 NA 0607 Traffic & Lighting 101 NA xxx xxx NA Sub Total 115 18,481 575 200 19,371 6,100 318% Public Safety 0801 Police 101 38,053 30,089 10,162 7,215 40,040 10,913 29,390 165,861 337,700 49% 0802 Police Communications 101 NA 0805 Police -PS LOIT funded 101 NA 0901 Fire 101 41,063 39,253 63,964 37,433 47,452 44,319 40,430 313,913 1,616,000 19% 0905 Fire-PS LOIT funded 101 NA Sub Total 79,116 69,341 74,126 44,647 87,492 55,231 69,820 479,774 1,953,700 25% Code Enforcement 1201 Code 101 NA 1203 Code Hearing 101 NA 1204 Code Junk Vehicle 101 NA 1205 Code Unsafe Building 101 2150 Z150 90 4,210 NA 1207 Code Animal Control 101 20 20 NA xxx xxx NA Sub Total 2,150 2,150 20 (90) 4,230 NA Arts 8 Culture 0404 Morris PAC 101 56,152 47,987 141,683 67,721 53,602 257,930 24,726 649,801 882,000 74% 0405 Palais Royale 101 29,101 7,384 7,641 8,067 41,102 16,359 14,560 124,214 309,981 40% xxx xxx NA Sub Total 85,253 55,371 149,324 75,788 94,704 274,289 39,286 774,015 1,191,981 65% 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 1,216,722 22,843,976 1,262,847 - - - - - 29,576,453 54,642,436 54% Financial Report July 2014 - Expenditure Summary Page 6 of 26 City of South Bend Revenue by Fund Report Period Ending: July 2014 a % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Se 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 61,020 4,357,371 61,052 4,726,681 8,689,315 54% 1100 Administration 201 1,551 2251 5,730 4,891 7,949 6,824 5,266 34,462 45,750 75% 1101 Maintenance 201 6,893 7,305 7,508 83,872 16,746 17,247 75,330 214,903 299,000 72% 1102 GolfOperations 201 2,568 71,543 11,607 161,363 186,018 22Z 156 241,418 891,537 1,582,000 56% 1103 Recreation Division 201 18,881 13,633 7,265 835 65 24,272 28,387 93,339 184,140 51% 1104 Potawatomi Zoo 201 265 34 13 312 NA 1106 Potawatomi Greenhouse 201 NA 1107 Community Svc Block Grant 201 NA 1108 Graffiti Removal 201 6,464 6,425 3,296 15,313 49,650 15,158 95,306 99,304 97% Recreation Non Reverting 203 76,057 104,016 91,333 87,416 50,145 103,711 129,002 641,681 1,449,592 44% East Race Waterway 271 2 5 7 8 2 3 1 27 100 27% Coveleski Stadium 401 3 10 13 14 5 7 3 55 500 11% Zoo Endowment 403 6 18 24 26 8 12 5 100 2900 3% Park Non Reverting 405 79 7,670 443 518 5,448 740 4,687 19,584 195,700 10% xxx x xxx NA Sub Total 168,582 275,212 189,369 400,789 34Z 719 4,782,007 560,308 6,718,985 12,548,301 54% Public Works Motor Vehicle Hi hway 202 285,523 416,631 384,110 1,840,889 927 707 611,250 523,905 4,990,015 9,106,300 55% Cenhal Services 222 670,844 738,759 669,859 637,842 544,739 473,838 608,357 4,344,238 7,847,374 55% Local Roads & Streets 251 87,148 91,181 93,475 123,983 91,165 91,503 97,527 675,981 1,121,801 60% Protect ReLeaf 655 36,373 36,471 36,737 36,904 36,554 36,709 36,568 256,317 431,700 59% xxx xxx xxx NA Sub Total 1,079,887 1 283 043 1,184,182 2 639 616 1,600,165 1 213 300 1,266,358 10 266,551 18 507,175 55% Public Works Solid Waste Solid Waste Operations 610 400,585 396,447 396,179 515,673 434,883 428,158 530,782 3,102,707 5 257,701 59% Solid Waste Capital 611 230,437 27 80,040 45,019 94,513 10 165,006 615,052 736,202 84% xxx x xxx NA Sub Total 631,022 396,474 476,219 560,691 529,396 428,168 695,788 3,717,759 5,993,903 62% Public Works Water Utility 0000 Water Works Revenues 620 863,045 1,048,116 935,227 955,067 949,603 1,205,037 1,001,701 6,957,795 12,655,313 55% 0630 Water Leak Insurance 620 80,687 80,448 80,578 80,851 80,849 81,037 80,970 565,421 960,000 59% 0640 Water Works 620 NA 0660 Clay Water 620 74,439 74,966 75,443 72,891 78,085 123,249 84,374 583,446 1,096,020 53% Waterworks Capital 622 453 1,296 1,756 1,853 603 856 346 7,163 10,000 72% Waterworks Construction 623 223 296 311 313 70 94 36 1,343 5,000 27% Waterworks Deposit 624 186 534 724 768 250 355 183 3,000 6,000 50% Waterworks Sinking 625 171,006 170,846 170,967 171,050 170,927 171,008 170,908 1,196,712 2,057,224 58% Waterworks Bond Reserve 626 8,761 9,130 9,337 9,383 8,833 8,947 8,719 63,110 90,073 70% Waterworks Debt Reserve 629 261 54,253 1,021 1,094 356 505 204 57,694 70,312 82% xxx xxx xxx NA Sub Total 1,199,062 1,439,885 1,275,364 1,293,271 1,289,576 1,591,088 1,347,441 9,435,686 16,949,942 56% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 47,833 46,355 48,966 50,116 48,868 50,147 48,850 341,134 549,200 62% 0000 Wastewater Revenues 641 2,517,238 2,480,217 2,496,145 2,616,135 2,682,708 2,677,476 2,782,933 18,252,852 32,588,386 56% 0621 Sewer Department 641 573 573 2,000 29% 0625 Concrete Crew 641 4,008 4,376 6,385 5,927 6,327 19,233 46,256 47,000 98% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 153,599 152,617 158,751 160,954 168,094 166,939 170,475 1,131,428 1,915,802 59% Sewage Ca ital 642 2,000,563 1,522 2,002,341 3,149 1,036 1,416 538 4,010,566 3,566,580 112% Sewage Reserve 643 130,386 1,221 1,702 1,797 585 829 335 136,855 238,715 57% Sewer Bond 200612006 645 NA Sewer Bond 2007 647 1 0 1 1 0 0 0 3 NA Sewage Bond Sinking 649 775,028 775,371 775,900 776,314 775,538 775,951 775,257 5,429,359 9,804,645 55% 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 0 1 0 5 NA 2011 Sewer Bond 659 1,034 2810 3,709 3,771 1,163 1,535 530 14,551 25,000 58% 2012 Sewer Bond 661 2372 6,686 8,940 9,354 3,043 4,317 1,744 36,455 45,000 81% 2013 Sewer Bond 663 60,000 0% 2013A Sewer Refund Bonds 664 1 2 2 2 1 1 0 9 NA 2014 Sewer Bond 665 NA Sub Total 5,632,063 3,471,179 5,502844 3,627,519 3,687,937 3,678,611 3,799,893 29,400,045 48,842,328 60% Financial Report July 2014. Expenditure Summary Page 7 of 26 City of South Bend Revenue by Fund Report Period Ending: July 2014 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 -feud et Public Safe - Police 601 0460 Main Street 601 0462 Leighton Plaza 601 0463 Enforcement 601 0464 Wayne Street 601 0465 Eddy Street Commons 601 Police Seizures 216 20 58 79 10,893 12,751 40 17 23,857 35,900 66% Curfew Violations 218 14 39 83 19 2 128 51 336 1,025 33% Law Enforcement Education 220 30,247 12,673 17,643 17,502 8,915 18,632 21,415 127,026 211,000 50% Public Safety LOIT 249 531,895 532,362 532,719 532,647 531,932 532,054 150 3,193,760 6,391,029 50% Excess Welfare Public Safety 252 0 0 1 1 0 0 0 2 NA Police Take Home Vehicle 278 14,378 9,629 9,407 9,652 9,484 9,521 9,410 71,481 123,160 58% Police Block Grant 280 0 1 2 2 1 1 0 8 NA Police Grants 292 66,716 66,716 NA Ponce Academy 294 13,159 4,127 41 694 14 19 7 18,061 22,000 82% COPS More Grants 295 863 992 957 819 709 1,374 861 6,575 41,600 16% Drua Enforcement 299 91 81 73 5,388 14,935 4,338 1,751 26,556 77,000 35% K -9 Unit 705 0 1,000 1 1 0 1 0 1,004 2,000 50% xxx xxx Sub Total xxx 657,384 560,963 561,005 577,618 578,743 566,106 33,663 3,535,483 6,904,714 NA 51% 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 223,443 305,054 170,620 1,649,899 2,661,000 62% t 289 2 6 8 9 3 4 24,056 24 087 in 000 241% River Rescue 291 2,412 2,435 7,249 8,453 10,619 3,629 3,987 38,784 45,200 86% xxx xxx xxx NA Sub Total 372,001 289,056 246,209 279,090 234,064 308,687 198,663 1,927,770 2,931,200 66% Department of Communi Investment Studebaker /0liver 209 139 398 539 569 185 263 106 2 199 335,000 1% State Grant 210 85 128 174 18,184 57 85 18,036 36,748 Z077,016 2% DCI Operating 211 435,848 11,776 40,226 480,581 11,562 37,945 59,311 1,077,250 Z278,246 47% 0000 Dept of Community Investment 212 125,073 158,522 95,663 9Z945 363,187 220,198 1,114,430 2 170,018 6,911,000 31% xxx Programs 212 111,753 111,753 NA 0000 Economic Revenue Bond 281 3 10 14 14 5 7 3 55 NA xxx xxx xxx NA Sub Total 561,149 170,834 136,615 59Z294 374,996 258,497 1,303,639 3 398,024 11,501,262 29% 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 July 2014 - Expenditure Summary Page 8 0/ 26 City of South Bend Revenue by Fund Report Period Ending: July 2014 a 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 of8ud et Other Miscellaneous Rain Da 102 1,105 3,164 4,289 4,527 1,474 2,091 845 17,494 52,000 34% Gift Donation Be nest 217 10 21,140 38 50 16 23 150,009 171,287 7,290 2350% Loss Recove 227 1,018 2,913 3,945 4,119 1,316 1,850 738 15,899 17,000 94% Human Ri hts 258 89 4,817 9,168 4,420 5,145 148 9,936 13,850 210,700 7% Morris Palais Marketing 273 354 3,005 542 364 932 1,118 653 6,968 8,100 86% Professional Sports Development 377 101,255 113,844 299 354 106 121,664 72,350 409,872 678,228 60% 1201 Code Enforcement 600 585,873 8,041 13,979 598,989 20,188 99,607 12,878 1,339,556 2,596,460 52% 1207 Animal Control 600 5,770 4,102 4,463 5,513 4,285 5,776 6,423 36,332 57,000 64% 1306 Building Operations 600 80,574 51,956 84,261 76,484 80,228 90,611 83,722 547,836 1,159,100 47% Century Center 670 101,443 830,395 167,457 108,952 162,563 164,074 1,341,465 2,876,350 4,564,898 63% Century Center Capital 671 30 57 29 30 29 174 500 35% xxx xxz xxx NA Sub Total 877,520 1,043,378 288,498 803,800 276,284 486,961 1,659,176 5,435,618 9,351,276 58% Business Insurance 0000 Business Insurance Revenues 226 235,841 273,423 244,661 240,954 239,180 250,200 238,824 1723,084 2,881,690 60% 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 239,180 250,200 238,824 1,723,084 Z898,690 59% Fiducia Trust & Agency Fire Pension 701 157 330 223 2 564 549 2 565,260 5,391,332 48% Police Pension 702 261 614 539 217 3,055,933 3 057,565 6,310,000 48% lCi Police / Fire Pension 703 NA Employee Benerits 711 939,099 988,883 1,008,404 1 356 220 1,080,537 1 074 338 1,175,351 7 622,832 13 418,450 57% Unemployment Comp 713 8,564 8,625 8,658 8,661 8,572 8,588 8,553 60,220 102 864 59% Cemetery Trust 730 5 14 18 19 6 9 4 75 250 30% xxx xxx xxx NA Sub Total 948,086 998,466 1,017,843 1 365 117 1,089,115 6 703 416 1,183,908 13 305,952 25 222,896 53% Civil City Revenues 15,022,977 13,469,813 13,985,515 14,960,176 13,049,281 45,399,015 13,831,845 - - - - - 129,718,624 239,009,158 54% Tax Increment Financing TIF Airport 324 2,853 9,393 12,246 12,595 4,035 7,627,935 7,704 7,676,762 13,484,612 57% TIF Central Development 420 30,402 30,591 15,776 254,752 33,198 2,515,902 30,165 2,910,786 4,168,336 70% TIF West Washington 422 58 225 305 322 105 304,301 66 305,381 422,000 72% TIF Leighton Plaza 425 9,940 15,407 12,374 18,352 7,014 16,916 12,244 92,246 164,303 56% TIF Medical Service 426 371 1,141 1,524 1,609 445 460,029 157 465,276 640,000 73% TIF Northeast 429 349 1,104 1,497 1,580 514 808,914 311 814,269 827,000 98% TIF Southside 430 402 1,246 1,669 1,721 542 1,269,709 331 1,275,620 2,515,000 51% TIF Erskine Commons 431 NA TIF Erskine Village 432 762 2,277 3,012 3,180 1,035 10,644 593 21,503 15,000 143% TIF Douglas Road 435 23 108 147 143 34 160,996 23 161,474 320,750 50% Northeast Residential TIF 436 244 920 502 362 118 1,382,665 95 1,384,906 2,394,000 58% xxx xxx xxx NA Sub Total 45,404 62,412 49,053 294,616 47,040 14,558,011 51,686 15,108,223 24,951,001 61% Financial Report July 2014 - Expenditure Summary Page 9 of 26 City of South Bend Revenue by Fund Report Period Ending: July 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 of Bud et Redevelo ment Funds Central Bond Proceeds 305 NA District Capital 2003 428 NA Administration 433 3 9 10 10 2 2 1 37 NA Coveleski Bond Construction 438 NA Certified Technology Park 439 472 1,352 1,833 1,934 630 894 361 7,476 1,462,000 1% Airport Urban Enterprise Zone 454 48 138 187 198 64 91 37 764 1,500 51 Blackthorn Golfo erations 619 71,571 84,446 56,179 127,218 204,566 229,433 239,340 1,012,753 1,696,879 60% xxx xxz xxx NA Sub Total 72,094 85,944 58,208 129,360 205,262 230,421 239,739 1,021,029 3,160,379 32% Debt Service Public Improvement 1990 314 - - - - - - - - - - - - - - NA Airport Debt Reserve 2003 315 133 381 517 545 177 252 102 Z107 5,000 42% Coveleski Bond Debt Reserve 317 65 185 251 264 86 122 49 1,022 1,800 57% Blackthorn Debt Service 319 NA Central Development reserve 328 223 637 863 911 297 421 170 3,521 6,000 59% xxx x xxx NA Sub Total 420 1,203 1,631 1,721 560 794 321 6,651 12 800 52% Redevelopment Commission 117,919 149,560 108,892 425,698 252,863 14,789,226 291,746 - - - - - 16,135,903 28,124,180 57% City Operations Total 15,140,898 13,619,373 14,094,408 15,385,874 13,302,144 60,188,241 14,123,591 - - - - - 145,854,529 267,133,338 55% Revenue report 15,140,898 13,619,374 14,094,408 15,385,874 13,302,144 60,188,241 14,123,591 145,854,530 267,133,338 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report July 2014 - Expenditure Summary Page 10 of 26 City of South Bend Property Tax Revenue 2013 Tax Pay 2014 Fund Period Ending: July 2014 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 6/6/2014 6/25/2014 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 0.95 13,984,752.01 6,078,082.84 20,062,834.85 (20,062,834.85) #DIV /0! Parks & Recreation 201 0.95 2,803,248.70 1,218,353.96 4,021,602.66 (4,021,602.66) #DIV /0! College Football Hall of Fame 313 0.95 - 271,788.05 271,788.05 (271,788.05) #DIV /0! Cumulative Capital District 406 0.95 163,956.07 71,258.93 235,215.00 (235,215.00) #DIV /0! Fire Pension 701 0.95 - - - 1,268,946.48 (1,268,946.48) Police Pension 702 0.95 0.95 - - Total - City 432 0.95 16,951,956.78 7,639,483.78 24,591,440.56 (24,591,440.56) #D1 V /0! Tax Increment Financinq Airport TIF District 324 0.95 7,521,012.22 7,521,012.22 (7,521,012.22) #DIV /0! South Bend Central TIF District 420 0.95 2,485,265.66 2,485,265.66 (2,485,265.66) #DIV /0! West Washington TIF District 422 0.95 304,152.20 304,152.20 (304,152.20) #DIV /0! Central Medical TIF District 426 0.95 459,659.10 459,659.10 (459,659.10) #DIV /0! Northeast Residential TIF District 436 0.95 1,382,498.19 1,382,498.19 (1,382,498.19) #DIV /0! Southside TIF District # 1 430 0.95 1,268,946.48 1,268,946.48 (1,268,946.48) #DIV /0! 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) #DIV /0! Douglas Road TIF District 435 0.95 160,947.28 160,947.28 (160,947.28) #DIV /0! Northeast TIF 429 0.95 808,183.73 808,183.73 (808,183.73) #DIV /0! Airport Urban Enterprise Zone 454 0.95 - - Other xxx 0.95 Total - Tax Increment Financing 14,399,839.94 14,399,839.94 (14,399,839.94) #DIV /01 Grand Total - 16,951,956.78 22,039,323.72 - 38,991,280.50 (38,991,280.50) #DIV /0! State Board 2013 Audit Fee Revised Total 0.00 0.00 16,951,956.78 22,039,323.72 0.00 38,991,280.50 (38,991,280.50) #DIV /0! 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 - Financial Report July 2014 - Property Tax Revenue Page 11 of 26 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% 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 July 2014 - Property Tax Revenue Page 12 of 26 City of South Bend Property Tax Revenue 2011 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 Airport TIF District Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District 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 - - - 2,608,924.21 - - - Police Pension 702 142,721.46 0.95 Erskine Commons TIF District #2 431 0.95 Total - City - 51,948,962.97 Erskine Village TIF District #3 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 Financinq 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% State 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.560/6 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 July 2014 - Property Tax Revenue Page 13 of 26 City of South Bend Period Ending: July 2014 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au I Sep 1 Oct 1 Nov I Dec I Year I Budget of Bud et vemment We 101 740 3,642 (2,402) oyor 101 73,969 52,004 52,578 54,407 51,628 51,451 51,780 387,818 711,711 1 Call Center 101 39,235 38,732 31,260 38,185 35,128 32,410 32,517 247,467 488,908 ark 101 33,254 24,949 24,763 25,023 25,501 22,930 32,837 189,256 394,608 ommon Council 101 33,804 16,129 22,696 28,970 24,570 16,770 48,596 191,535 542,598 Iministradon and Finance 101 184,882 129,923 146,822 191,183 163,566 156,110 186,876 1,159,361 2,091,944 gal Department 101 111,670 74,144 74,485 83,836 76,265 73,434 68,166 562,002 1,025,635 K 4,776,421 3,539,947 3,470,493 3,794,204 3,416,835 3,770,647 3,679,398 26,447,945 48,011,105 ib Total 476,814 335,881 352,603 421,604 376,658 353,106 420,772 2,737,438 5,255,404 cs iergy Office 101 igineering 101 100,714 83,713 46,461 132,468 68,149 78,784 76,398 586,686 1,126,302 Ofic 8 Lighting 101 K ib Total 100, 714 83,713 46,461 132,468 68,149 78,784 76,398 586,686 1,126,302 ty We 101 740 3,642 (2,402) lice 101 2,352,204 1,889,108 1,847,740 1,829,954 1,666,157 1,831,413 1,791,370 13,207,946 24,725,204 Mice Communications 101 205,840 146,325 143,663 159,049 149,203 162,622 162,099 1,128,801 2,236,486 /ice -PS LOIT funded 101 ode Unsafe Building 101 750 750 ode Animal Control 101 ,e 101 2,004,690 1,591,802 1,605,489 1,805,201 1,601,475 1,776,613 1,725,929 12,111,198 21,049,415 •e-PS LOIT funded 101 213,687 (87,288) (126,399) (1,441) 750 1,900 7,479 0 K ib Total 4,776,421 3,539,947 3,470,493 3,794,204 3,416,835 3,770,647 3,679,398 26,447,945 48,011,105 cement We 101 740 3,642 (2,402) (1,129) 851 5,225 nights and Measure 101 - - - - - - - - - ode Hearing 101 ode Junk Vehicle 101 ode Unsafe Building 101 750 750 ode Animal Control 101 612 (0) (312) 300 2,254 X ib Total 740 4,254 (2,403) (1,441) 750 1,900 7,479 ire rrris PAC 101 87,838 86,253 87,012 79,972 71,819 78,815 64,421 556,131 1,063,527 dais Royale 101 43,724 31,427 36,381 35,103 32,903 32,545 28,354 240,438 523,710 K ib Total 131,562 117,680 123,393 115,075 104,722 111,360 92,776 796,569 1,587,237 Ws Oman Rights 101 31,977 26,096 24,523 26,765 25,976 25,472 26,797 187,604 367,262 K ib Total 31,977 26,096 24,523 26,765 25,976 25,472 26,797 187,604 367,262 General Fund Expenditure Total 5,518,227 4,107,572 4,015,071 4,488,675 3,992,340 4,340,119 4,296,141 - - - - - 30,758,143 56,354,789 55% Financial Report July 2014 - Expenditure Summary Page 14 of 26 City of South Bend Period Ending: July 2014 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au I 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 117,058 108,772 lIZ157 757,864 1,564,813 48% 1101 Maintenance 201 440,988 353,914 390,644 351,149 421,395 439,897 483,557 2,881,545 4,947,775 58% 1102 Golfo eradons 201 79,201 66,423 162,024 161,674 154,410 148,933 160,978 933,642 1,526,640 61% 1103 Recreation Division 201 195,148 128,820 129,384 142,829 13Z 121 145,116 226,862 1,100,279 2,114,512 52% 1104 Potawatomi Zoo 201 669,326 24,910 19,666 20,268 18,914 423,970 20,573 1,197,627 2,283,664 52% 1106 Potawatomi Greenhouse 201 8,161 7,588 5,995 4,098 17,073 1,247 2,193 46,355 59,614 78% 1107 Community Svc Block Grant 201 9,148,856 19,600,043 421,874 311,133 Waterworks Debt Reserve 629 261 746 1,021 NA 1108 Graffiti Removal 201 7,701 4,982 7,622 7,691 6,556 8,602 7,235 50,390 103,860 49% Recreation Non Reverting 203 42,584 72,465 55,717 59,083 74,464 80,663 125,151 510,126 1,479,064 34% East Race Waterway 271 2045 7,047 805 338 9,092 10,346 88% Coveleski Stadium 401 500 850 750 1,539,362 132,890 350 1,674,702 3,540 0% Park Non Reverting 405 4,814 111,962 14,077 19,071 67 7,473 157,463 205,217 77% xxx xkx xxx 2 2 NA Sub Total 653 1,561,582 855,681 869,172 886,397 968,107 1,357,266 1,146,178 - - - - - 7,644,383 14,299,045 53% (s 0630 Water Leak Insurance )tor Vehicle Highway 202 818,846 888,630 620,621 596,446 460,643 459,703 431,613 4,276,501 8,856,075 irb and Sidewalk 202 49,312 36,865 30,043 28,523 40,168 41,673 96,666 323,250 1,152,802 antral Services 222 672,962 610,722 687,806 59Z 769 556,636 479,824 587,811 4,188,530 8,036,532 Ical Roads &Streets 251 19,206 IZ316 11,761 14,903 Waterworks Construction 43,936 206,924 294,142 1,124,520 oiect ReLeaf 655 14,433 3,216 2324 26,854 2823 2517 14,265 66,433 430,114 X xxx 143 2960 Waterworks Sinking 625 196 36 157 240 117 ib Total 448 1,574,759 1,551,748 1,352,556 1,244,591 1,060,270 1,027,652 1,337,279 9,148,856 19,600,043 rs Solid Waste did Waste Operations 610 672,124 364,775 527,277 436,201 495,263 408,192 585,467 3,489,299 5,609,963 did Waste Capital 611 264,795 79,617 45,260 83,600 29,025 10,821 220,069 733,188 996,070 X xxx ib Total 936,920 444,393 572,537 519,801 524,288 419,013 805,536 4,222,487 6,606,033 Public Works Water Utility 0630 Water Leak Insurance 620 60,631 71,687 52,589 62,286 117,419 588 242,562 607,761 0640 Water Works 620 1,137,738 1,021,433 1,021,980 1,133,868 1,231,292 1,069,240 1,131,394 7,746,945 0660 Clay Water 620 215 2,545,441 3 50% 105 35 2 360 Waterworks Capital 622 3,600 26,040 24,188 216,143 453,145 53 11,250 14,903 Waterworks Construction 623 17,780 195,292 4,436 191,283 38,778 430 76,003 524,001 Waterworks Deposit 624 186 534 724 768 250 355 143 2960 Waterworks Sinking 625 196 36 157 240 117 384,067 448 385,262 Waterworks Bond Reserve 626 1,000 80% Sewage Ca ital 642 978,994 416,435 421,874 311,133 Waterworks Debt Reserve 629 261 746 1,021 1,094 356 505 204 4,187 xxx xxx xxx 585 829 335 6,891 15,000 46% Sewer Bond 200612006 645 Sub Total 1,220,608 1,289,727 1,080,910 1,389,538 1,388,316 1,455,274 1,462,006 - - - - - 9,286,380 Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 17,250 30,211 23,925 22,790 50,604 16,799 89,589 251,167 549,978 46% 0621 Sewer Repair 641 461,905 389,062 283,083 389,913 341,488 309,177 370,813 2,545,441 5,132,912 50% 0625 Concrete Crew 641 39,120 37,262 32,982 27,777 28,774 26,040 24,188 216,143 453,145 48% 0630 Wastewater Operations 641 4,020,021 1,880,989 3,676,419 1,803,956 1,896,757 1,768,194 1,830,588 16,876,925 28,766,521 59% 0631 Organic Resources 641 78,091 82,861 91,592 95,259 63,735 92,096 69,529 573,161 1,202,616 48% 0650 Clay Sewage 641 978 0 158 1,939 802 1,000 80% Sewage Ca ital 642 978,994 416,435 421,874 311,133 164,146 350,346 152,471 2,795,399 9,267,941 30% Sewage Reserve 643 422 1,221 1,702 1,797 585 829 335 6,891 15,000 46% Sewer Bond 200612006 645 NA Sewer Bond 2007 647 805 338 1,143 1,138 100% Sewage Bond Sinking 649 500 850 750 1,539,362 132,890 350 1,674,702 9,802,031 17% Clay Sewage General 650 NA Sewage Bond 2007 651 2 2 NA Sewage Works DS Reserve 653 NA 2010 CSO Net Sewer Bond 658 924 924 NA 2011 Sewer Bond 659 275,419 265,818 144,834 676,437 418,754 711,646 424,489 2,917,396 13,598,486 21% 2012 Sewer Bond 661 272,470 216,156 17,815 575 6,278 513,294 18,868,570 3% 2013 Sewer Bond 663 19,100,000 0% 2014 Sewer Bond 665 NA Sub Total 6,143,212 3,320,865 4,694,227 3,330,387 4,504,204 3,414,941 2,965,557 - - - - - 28,373,392 106,759,338 27% Financial Report July 2014 - Expenditure Summary Page 15 of 26 City of South Bend Period Ending: July 2014 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 4S Capital 288 449,207 280,578 359,503 943,903 306,775 116,574 363,982 2,820,521 6,287,299 mmat 289 10,000 Police Seizures 216 24,271 52,300 X xxx 12,650 10,669 ib Total 449,407 281,861 359,503 943,960 311,974 122,587 375,500 40,000 0% Curfew Violations 218 1,612,310 385,712 18,003 943,423 420,072 18,003 1,018,798 36,005 1,000 0% Law Enforcement Education 220 11,075 20,490 23,204 3,629 11,393 22,041 11,790 103,622 294,802 35% Emergency Telephone System 244 27,387 16,003 16,999 18,603 17,040 11,973 12,813 120,818 215,000 56% Public Safety LOIT 249 517,291 613,746 709,196 593,832 573,243 614,034 575,843 4,197,184 7,214,658 58% Excess Welfare Public Safety 252 15,900 X xxx 1,146 0% Police Take Home Vehicle 278 15,269 811 12 709 5,393 18,891 37,774 8,365 99,213 80,580 0% Police Block Grant 280 1,597,808 71,075 113,460 98,190 68,110 119,867 412,296 912,592 5,823,729 NA Police Grants 292 337,650 358,693 138,059 377,775 481,205 380,019 1,319,168 138,059 228,060 61% Police Academy 294 136 197 330 3,967 6,380 564 259 11,835 23,750 50% COPS More Grants 295 175 1,484 1,185 1,417 1,328 1,795 2,417 9,801 141,600 7% Drug Enforcement 299 6,273 2,731 3,839 29,849 8,657 3,957 4,120 49,033 166,499 29% K -9 Unit 705 2,000 0% xxx xxx xxx 4,831,372 709,183 802,655 3,116,534 751,299 949,985 3,506,193 14,667,221 30,538,028 NA Sub Total 556,065 654,651 892,811 651,297 618,041 654,364 603,122 - - - - - 4,630,351 8,409,095 55% ty - Fire 4S Capital 288 449,207 280,578 359,503 943,903 306,775 116,574 363,982 2,820,521 6,287,299 mmat 289 10,000 ver Rescue 291 199 1,283 0 57 5,200 6,014 11,517 24,271 52,300 X xxx 12,650 10,669 ib Total 449,407 281,861 359,503 943,960 311,974 122,587 375,500 2,844,792 6,349,599 De artmento mmunity Investment tin Street StudebakedOliver 209 15,801 740 43,308 12,138 12,650 10,669 118,037 388,575 1,415,000 0% State Grant 210 1,612,310 385,712 18,003 943,423 420,072 18,003 1,018,798 36,005 2,117,886 2% DCI Operating 211 236,843 167,810 175,126 174,007 169,920 174,698 173,575 1,271,979 2,404,884 53% 1001 Dept of Community Investment 212 85,538 190,071 52,948 198,374 292,394 149,543 1,137,228 2,106,097 6,532,862 32% 1002 Dept. of Community Investment 212 10,495 9,389 108,339 527,719 Idy Street Commons 601 1,137,926 6,086,735 10,289,984 NA 1003 Administration 212 15,900 X xxx 2,328 0% xxx Programs 212 15,269 811 12 709 5,393 18,891 37,774 8,365 99,213 375,593 26% xxx xxx xxx 1,597,808 71,075 113,460 98,190 68,110 119,867 412,296 912,592 5,823,729 NA Sub Total 416 337,650 358,693 258,786 377,775 481,205 380,019 1,319,168 3,513,294 12,848,553 27% ages tin Street 601 22,732 15,801 740 43,308 12,138 12,650 10,669 118,037 388,575 Joseph 601 COIT 404 1,612,310 385,712 447,510 943,423 420,072 649,232 1,018,798 ighton Plaza 601 39,122 41,189 2,241 69,225 21,180 18,657 18,771 210,386 575,008 iforoement 601 13,486 4,479 196 8,021 4,204 4,739 8,900 44,026 90,606 ayne Street 601 21,424 12,784 718 39,704 13,824 10,495 9,389 108,339 527,719 Idy Street Commons 601 1,137,926 6,086,735 10,289,984 59% Cumulative Sewer 409 15,900 X xxx NA UDAG 410 ib Total 96,764 74,254 3,896 160,258 51,347 46,542 47,729 480,788 1,597,808 Capital /Debt Service Hall of Fame 313 634,500 636,000 1,270,500 1,268,116 100% COIT 404 1,612,310 385,712 447,510 943,423 420,072 649,232 1,018,798 5,477,058 11,165,785 49% Cum Capital Development 406 112,650 56,546 135,726 56,545 112,650 474,118 722,935 66% Cum Capital Improvement 407 185,250 183,750 369,000 364,762 101% EDIT 408 2,229,819 244,434 176,179 2,057,472 119,643 121,261 1,137,926 6,086,735 10,289,984 59% Cumulative Sewer 409 NA UDAG 410 NA Major Moves 412 29,594 71,075 113,460 98,190 68,110 119,867 412,296 912,592 5,823,729 16% Morris PAC Improvement 416 2,911 4,227 652 7,791 53,200 15% 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 3,521 3,079 4,120 48,453 188,567 26% xxx xxx xxx NA Sub Total 4,831,372 709,183 802,655 3,116,534 751,299 949,985 3,506,193 14,667,221 30,538,028 48% Financial Report July 2014 - Expenditure Summary Page 16 of 26 City of South Bend Period Ending: July 2014 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et Other Miscellaneous Self Funded Liability Ins Excess Levy 103 18,720 18,955 17,554 15,920 15,072 16,406 122,915 253,743 Liability Insurance NA Gift, Donation, Bequest 217 47,138 64,670 26,048 15,285 2,786 563,117 10,950 13,736 201,010 7% Loss Recovery 227 5,154 6,805 201,942 81,844 47,647 130,545 104,828 578,765 6,615,805 9% General Grant 250 73,933 51,044 56,596 548,112 1,042,346 xxx xxx 319 657,534 NA Human Rights 258 19,647 10,646 9,995 11,474 18,099 14,553 14,445 98,857 224,001 44% Morris Palais Marketing 273 3,628 1,740,807 982 2,453 705 547 2,916,392 8,314 18,000 46% Economic Revenue Bond 281 15,982,643 27,828,418 859 1,475 2,806,117 NA ProfessionalSports Development 377 382,873 800 169,406 100,000 15,925 43,125 381,873 865,545 865,746 100% 1201 Code Enforcement 600 87,023 68,770 63,184 171,941 96,142 64,086 275,227 826,373 1,836,074 45% 1207 Animal Control 600 58,611 49,070 47,679 54,707 52,463 43,720 54,024 360,274 689,215 52% 1306 Building Operations 600 102,831 81,636 75,880 78,138 76,132 81,274 82,824 578,714 1,273,620 45% Century Center 670 314,629 427,425 323,712 278,861 560,565 306,614 360,870 2,572,675 4,564,898 56% Century Center Capital 671 393,547 0% xxx xxx xxx 4,494,908 987,594 1,003,928 2,098,614 535,583 254,451 4,326,789 13,701,866 51,797,693 NA Sub Total 974,395 645,150 723,375 779,417 854,539 641,338 1,285,039 5,903,253 16,681,916 35% s Insurance Self Funded Liability Ins 226 20,289 18,720 18,955 17,554 15,920 15,072 16,406 122,915 253,743 Liability Insurance 226 39,002 243,446 47,138 64,670 26,048 15,285 127,528 563,117 1,028,811 Business Insurance 226 6,557 29,628 27,028 1,799 6,529 430,622 4,500 506,663 572,300 Workers Compensation 226 37,558 198,648 118,501 11,833 73,933 51,044 56,596 548,112 1,042,346 xxx xxx 319 657,534 0% TIF Lei Leighton Plaza 425 4,077 13,665 13,842 20,595 Sub Total xxx 103,406 490,442 211,622 95,856 122,430 512,022 205,029 1,740,807 2,897,200 y Trust 8 Agency Fire Pension 701 457,164 448,542 448,687 456,878 451,651 462,793 450,825 3,176,540 5,874,445 Police Pension 702 54Z603 643,997 645,479 553,882 530,320 566,915 543,126 4,026,321 7,221,941 Employee Benefits 711 526,930 1,807,630 1,315,439 1,462,755 1,128,213 846,028 1,602,281 8,689,276 14,483,463 Unemployment Comp 713 9,673 16,224 12 294 13,584 18,283 13,315 7,135 90,506 227,974 City Cemetery Trust 730 319 657,534 0% TIF Lei Leighton Plaza 425 4,077 13,665 13,842 20,595 xxx xxx 8,803 79,118 149,425 53% TIF Medical Service 426 169,224 Sub Total 28,057 1,536,369 2,916,392 2,421,899 2,487,098 2,128,467 1,889,051 2,603,367 15,982,643 27,828,418 Civil City Expenditure 25,840,735 17,700,611 18,259,018 20,471,583 17,756,829 17,210,172 21,957,844 - - - - - 139,196,792 329,472,862 42% Tax Increment Financing TIF Air ort 324 1,403,524 250,577 673,576 192,333 433,246 161,642 1,435,500 4,550,399 27,286,693 17% TIF Sam le Ewing 414 NA TIF Central Development 420 1,015,931 314,263 51,873 339,598 42,310 32,302 1,274,876 3,071,153 5,829,261 53% TIF West Washington 422 319 319 657,534 0% TIF Lei Leighton Plaza 425 4,077 13,665 13,842 7,161 15,045 16,524 8,803 79,118 149,425 53% TIF Medical Service 426 169,224 1,532,233 28,057 1,729,515 4,103,504 42% TIF Northeast 429 617 859 1,475 2,806,117 0% TIF Southside 430 81,949 8,298 169,406 27,289 15,925 43,125 6,064 352,055 6,487,957 5% TIF Erskine Commons 431 NA TIF Erskine Villa a 432 354,606 137,545 492,151 494,151 100% TIF Dou las Road 435 160 95,231 95,391 399,823 24% Northeast Residential TlF 436 1,464,500 400,791 1,000 1,464,000 3,330,291 3,583,228 93% xxx xxx xxx NA Sub Total 4,494,908 987,594 1,003,928 2,098,614 535,583 254,451 4,326,789 13,701,866 51,797,693 26% Financial Report July 2014 - Expenditure Summary Page 17 of 26 City of South Bend Period Ending: July 2014 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 Redevelo ment Funds 1,042,292 1,075,730 2182,004 740,166 433,162 4,580,881 - - - - - 14,603,129 Central Bond Proceeds 305 iblic Improvement 1990 314 NA District Ca ital 2003 428 City Operations Total 30,389,628 18,742,903 19,334,748 22,653,588 rport Debt Reserve 2003 NA Administration 433 6,072 4,140 5,491 15,703 20,000 79% Cove leski Bond Construction 438 317 386,573,261 0 0 0 NA Certified Technology Park 439 0 0 0 0 0 0 0 ackthorn Debt Service 319 3,600,000 0% A R U 454 NA B Go /fOperations 619 47,557 53,680 66,283 76,441 204,109 178,039 253,821 879,930 1,671,706 53% xxx xxx xxx X xxx NA Sub Total 53,629 53,680 70,422 81,933 204,109 178,039 253,821 895,634 5,291,706 17% e 1,042,292 1,075,730 2182,004 740,166 433,162 4,580,881 - - - - - 14,603,129 57,100,399 26% 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 177 252 102 2,107 5,000 rveleski Bond Debt Reserve 317 386,573,261 0 0 0 0 0 0 0 0 0 0 0 0 0 ackthorn Debt Service 319 ?ntral Development reserve 328 223 637 863 911 297 421 170 3,521 6,000 X xxx ib Total 356 1,019 1,380 1,457 474 672 271 5,629 11,000 Redevelopment Commission 4,548,893 1,042,292 1,075,730 2182,004 740,166 433,162 4,580,881 - - - - - 14,603,129 57,100,399 26% City Operations Total 30,389,628 18,742,903 19,334,748 22,653,588 18,496,995 17,643,334 26,538,725 - - - - - 153,799,921 386,573,261 40% Expenditure report 30,389,627 18,742,903 19,334,748 22,653,588 18,496,995 17,643,334 26,538,725 153,799,921 386,573,261 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report July 2014 - Expenditure Summary Page 18 of 26 City of South Bend Debt Schedule Period Ending; July 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 3/ 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 4f 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 69 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 so 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 tot 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 tf6 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 t 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 xxx 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 5s Lanier Copier 915 Oil- 2008 2013 620 Monthly - - - 5,154.00 0.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 0.00 67 Sun Trust Solid Waste Containers/Tri 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 76 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.com 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 foe 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 103 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 8127 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 toe 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 & Rep Ricoh Copiem(3) 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 Ile 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 fn 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 119 Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Cook 2013 2018 620 Monthly 16th 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 1,085.52 12o 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 1 7,540,252.7 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 July 2014 -Debt Page 19 0/26 City of South Bend Debt Schedule Period Ending; July 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 menu 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 2014 2022 324/404/414 1/1 7/1 - - 6,620,000.00 3,405,000.00 430,000.00 54,860.00 35,000.00 3,010,000.00 484,860.00 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 Gates 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,683,216.62 3 905 381.35 328 788.00 75 768 904.72 11 588 597.97 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 t6 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 fio 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 296,529.37 16,046.63 0.00 47,003.09 312,576.00 fia 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 e4 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 e6 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 569 116.13 307 423.40 0.00 6,937.235.65 1 878 539.53 Capital Lease 75 PNC Equipment Financing 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 Redevelopment commisslon 167,529,086.70 93,896,698.92 1 9,596,741.51 1 4,324,816.99 328,788.00 1 84,628,745.41 13,921,558.50 Financial Report July 2014 - Debt Page 20 or 26 City of South Bend Monthly Debt Schedule Period Ending; July 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 when Fund let 2nd 3rd 4th Issue 12/31/2013 Payments Payments Addttions 1 713112014 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 12031 - - 5,975,000.00 3,450,000.00 0.00 34,500.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 77,719.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 134,745.63 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 281,773.75 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 275,770.63 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 240,000.00 48,327.01 0.00 3,750,000.00 69 Water Works Improvements Water Works 2009 2030 625 7/1 12131 - - 5,380,000.00 4,985,000.00 0.00 135,116.00 0.00 4,985,000.00 7o Sewage Works Revenue Bonds -2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3,297,000.00 2,710,898.00 0.00 38,088.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 168,108.75 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 366,150.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 233,886.26 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 274,290.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 132,890.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,770,000.00 2 613 590.03 0.00 147 885 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 6,593.35 0.00 391,297.00 62 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 611 1211 - - 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 14,773.00 0.00 1,018,815.00 Total Loans Pa able 35 533 780.00 3.438.085.00 0.00 21 366.35 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 171,136.37 29,443.29 0.00 559,122.04 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 5g 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 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 1,526.68 122.24 0.00 1,068.07 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 1,412.02 117.98 0.00 2,950.75 n GE Capital Information Technology Animal Control Copier 2010 2015 101 2/28 5/30 8/30 11130 3,550.69 1,161.97 375.47 32.23 0.00 786.50 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,468.90 180.02 0.00 2,095.55 7s Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10,511.02 4,702.41 1,666.67 279.85 0.00 3,035.74 87 Public Finance.com Inc Solid Waste Containers /Trucks 2011 2015 611 6/15 12/15 - - 321,853.00 133,252.34 32,537.77 2,094.73 0.00 100,714.57 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 207,740.61 9,742.09 0.00 851,300.23 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 20,719.15 923.63 0.00 95,396.08 91 GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 2,065.68 588.60 77.94 0.00 1,477.08 92 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 N Ikon Office Solutions Mayor Ricoh MP 2851 SP Copies 2011 2016 101 2/15 5/15 8/15 11/15 2,569.53 1,620.15 251.33 42.91 0.00 1,368.82 95 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 97 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1,295,000.00 918,678.73 127,941.13 7,784.51 0.00 790,737.60 as PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15 - - 945,674.38 669,405.77 93,492.14 5,037.28 0.00 575,913.63 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 fo2 Ikon Office Solutions / Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 4,278.32 638.84 133.27 0.00 3,639.48 103 GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11128 5,471.01 4,249.41 514.16 121.24 0.00 3,735.25 toe Ricoh USA Central Services Copier 2013 2018 222 2/27 5127 8127 11/27 3,622.78 3,004.64 352.21 67.67 0.00 2,652.43 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 508.06 127.34 0.00 3,998.28 foe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5112 8112 11/12 5,559.15 4,528.32 529.67 105.72 0.00 3,998.65 row Ricoh USA Parks & Rec Ricoh Copiem(3) 2013 2018 201 2121 5/21 8/21 11121 16,129.94 13,138.49 1,537.07 306.55 0.00 11,601.42 110 PNC Equipment Finance Vehicle/Equipirent Lease 2013 2018 101/202/406/641 1115 7115 - - 1,689,669.59 1,689,669.59 327,718.32 22,182.20 0.00 1,361,951.27 111 Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 8,694.31 931.79 364.21 0.00 7,762.52 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 3,854.47 429.32 16.07 0.00 3,425.15 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,530.70 397.73 0.00 8,090.21 115 CSI Leasing Inc 2010 Server IT Lease 2010 2014 404 211 5/1 8/1 11/1 28,588.00 5,869.74 3,885.16 141.24 0.00 1,984.58 117 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 9,678.26 996.50 298.50 0.00 8,681.76 113 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 5,647.50 581.30 174.35 0.00 5,066.20 fts Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copie 2013 2018 620 Monthly 16th 4,732.65 4,732.65 487.13 146.09 0.00 4,245.52 12o Water Works Olive Ricoh Copier Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 4,732.65 487.13 146.09 0.00 4,245.52 Total Ca ita /Lease 18,788,201.74 10,341,870.14 2,111,521.01 144,748.78 0.00 8,230,349.13 Total Glvll GUY 279,953,961.74 163,435,653.141 3,661,511.01 2,779,705.16 U.UU 159,554,332.131 Financial Repent July 2014 - Debt Page 21 0/26 City of South Bend Monthly Debt Schedule Period Ending; July 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 let 2rd 3rd 4th Issue 12/31/2013 Payments Payments Atidttions 1 713112014 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 6 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 tt 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 2014 2022 324/404/414 1/1 7/1 - - 6,620,000.00 3,405,000.00 0.00 7,385.00 35,000.00 3,440,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 6 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 st 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 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 250,000.00 8,750.00 0.00 250,000.00 too 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 Blackthom Golf Cart Lease xxx Blackthorn Golf 2014 2019 619 Monthly 14th 293,788.00 0.00 13,863.30 1,811.16 293,788.00 279,924.70 Total Bond Debt 139 713 788.00 83 123 333.34 4,002,196.63 2 039 293.41 328 788.00 79 449 924.71 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 28,882.81 7,122.41 0.00 453,138.60 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 6/30 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 33,333.33 833.33 0.00 33,333.39 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 60 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 a3 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 a4 Intertund Fund 412 -Major Moves Douglas Road TIF 2009 2029 435 7115 8/15 - - 1,040,319.00 923,829.00 18,347.00 23,096.00 0.00 905,482.00 a1 Interfund Fun'6 19 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31,032.00 15,516.00 1,939.50 0.00 0.00 13,576.50 64 Intertund 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 a5 Interfund 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 m 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 3,349.92 0.00 0.00 33,498.98 Total Loans Pa able 22058511. 231 496.30 146 388.00 0.00 8,274,855.48 Capital Lease 75 PNC Equipment Financing Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 106,802.80 25,217.47 2,993.03 0.00 81,585.33 Total Capital Lease 246,509.64 106,802.80 25,217.47 2,993.03 0.00 81,585.33 Leases 37 Transpo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3,000,000.00 371,710.00 88,849.00 11,151.00 0.00 282,861.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 144 137.00 1 55 863.00 0.00 2,016,074.00 Total Redeve /opment Commission 167,529,086.70 93,896,698.92 1 4,403,047.40 1 2,244,537.44 328,788.00 89,822,439.52 Financial Repat July 2014 - Debt Page 22 of 26 City of South Bend Staffing Headcount Summary Budget I I I I I I Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1160.00 1116.00 1104.00 1106.00 1109.00 1107.00 1101.00 1108.00 0.00 0.00 0.00 0.00 0.00 Part Time Staff 75.00 75.00 72.00 71.00 73.00 73.00 66.00 0.00 0.00 0.00 0.00 0.00 Temporary /Seasonal 137.00 137.00 120.00 144.00 213.00 361.00 341.00 0.00 0.00 0.00 0.00 0.00 City Total 1328.00 1316.00 1298.00 1324.00 1393.00 1535.00 1515.00 0.00 0.00 0.00 0.00 0.00 Financial Report July 2014 - Headcount Staffing Page 23 of 26 City of South Bend Staffing Headcount Full Time Staff Amended Budget FT I Jan I Feb I Mar I Apr I Mav I Jun Jul Aua I Sea Oct I Nov I Dec General Government 12.00 11.00 11.00 11.00 11.00 11.00 10.00 10.00 Maintenance 44.00 Mayor 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 8.00 311 Call Center 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 26.00 Admin & Finance 23.00 21.00 21.00 21.00 22.00 22.00 22.00 22.00 3.00 Safety & Risk 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 0.00 Clerk 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 1.00 Common Council 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 1.00 Le al De artment 10.00 9.00 9.00 9.00 10.00 9.00 8.00 9.00 92.00 0.00 0.00 0.00 0.00 0.00 Sub Total 64.00 61.00 61.00 61.00 63.00 62.00 61.00 62.00 0.00 0.00 0.00 0.00 0.00 Code Enfor. /Animal Control Water Utilit O s 26.00 24.00 21.00 21.00 23.00 22.00 22.00 23.00 Dept. of Community Investment Sub Total 26.00 26.00 26.00 26.00 26.00 26.00 26.00 26.00 Parks & Recreation Public Safety Administration 12.00 11.00 11.00 11.00 11.00 11.00 10.00 10.00 Maintenance 44.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 Golf Operations 8.00 8.00 8.00 8.00 9.00 9.00 8.00 8.00 Recreation Ops 26.00 26.00 26.00 27.00 26.00 26.00 26.00 25.00 Zoological Ops 23.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Greenhouse Ops 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 1.00 1.00 1.00 Recreation Nonreverting 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Sub Total 115.00 94.00 94.00 95.00 95.00 95.00 93.00 92.00 0.00 0.00 0.00 0.00 0.00 Police 297.00 289.00 283.00 285.00 283.00 283.00 284.00 292.00 Communications 38.00 32.00 33.00 34.00 34.00 34.00 33.00 33.00 Fire 260.00 263.00 260.00 261.00 258.00 258.00 257.00 257.00 Sub Total 595.00 584.00 576.00 580.00 575.00 575.00 574.00 582.00 0.00 0.00 0.00 0.00 0.00 Public Works Central Services 40.00 37.00 37.00 37.00 38.00 37.00 37.00 37.00 Engineering 16.00 14.00 14.00 16.00 16.00 16.00 16.00 16.00 Maintenance 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Solid Waste Operations 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 Street Operations 60.00 60.00 60.00 59.00 60.00 60.00 60.00 60.00 Sewer Operations 35.00 35.00 35.00 32.00 33.00 33.00 33.00 31.00 Waste Water Ops 44.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 Organic Resources 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 Water Utilit O s 70.00 69.00 69.00 68.00 69.00 70.00 68.00 68.00 Sub Total 299.00 293.00 293.00 290.00 294.00 294.00 292.00 290.00 0.00 0.00 0.00 0.00 0.00 Building Department 15.00 14.00 13.00 13.00 13.00 13.00 14.00 14.00 Human Rights 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 Morris & Palais 14.00 14.00 14.00 14.00 14.00 14.00 13.00 13.00 City Total 1160.00 1116.00 1104.00 1106.00 1109.00 1107.00 1101.00 1108.00 0.00 0.00 0.00 0.00 0.00 Financial Report July 2014 - Headcount Staffing Page 24 of 26 City of South Bend Staffing Headcount Part Time Staff General Government Code Enf. /Animal Control Jan I Feb I Mar I Apr I May I Jun I Jul I Aug I Sep I Oct I Nov I Dec Mayor 1.00 1.00 1.00 1.00 1.00 1.00 1.00 311 Call Center 0.00 0.00 0.00 1.00 1.00 1.00 1.00 Admin & Finance 1.00 1.00 1.00 1.00 1.00 1.00 0.00 Clerk 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 Le al De artment 4.00 4.00 4.00 4.00 3.00 3.00 2.00 Sub Total 6.00 6.00 6.00 7.00 6.00 6.00 4.00 0.00 0.00 0.00 0.00 0.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Dept. of Community Investment 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Public Works Administration 5.00 5.00 5.00 5.00 5.00 5.00 5.00 Maintenance 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Golf Operations 0.00 0.00 1.00 1.00 1.00 1.00 1.00 Recreation Ops 30.00 30.00 28.00 26.00 26.00 26.00 25.00 Zoological Ops 6.00 6.00 3.00 3.00 3.00 3.00 3.00 Greenhouse Ops 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 Sub Total 44.00 44.00 40.00 38.00 38.00 38.00 37.00 0.00 0.00 0.00 0.00 0.00 Police 4.00 4.00 5.00 5.00 5.00 5.00 3.00 Communications 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fire 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Sub Total 5.00 5.00 6.00 6.00 6.00 6.00 4.00 0.00 0.00 0.00 0.00 0.00 Central Services 1.00 1.00 1.00 2.00 1.00 1.00 1.00 Engineering 4.00 4.00 2.00 2.00 3.00 3.00 3.00 Traffic & Lighting 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 Solid Waste Ops 2.00 2.00 2.00 2.00 2.00 2.00 1.00 Street Ops 3.00 3.00 5.00 4.00 4.00 5.00 4.00 Sewer Ops 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 Water Utilit Ops 1.00 1.00 1.00 1.00 3.00 3.00 3.00 Sub Total 11.00 11.00 11.00 11.00 13.00 14.00 12.00 0.00 0.00 0.00 0.00 0.00 Building Department 0.00 0.00 0.00 0.00 1.00 0.00 0.00 Human Rights 1.00 1.00 2.00 2.00 2.00 2.00 2.00 Morris & Palais 5.00 5.00 5.00 5.00 5.00 5.00 5.00 75.00 75.00 72.00 71.00 73.00 73.00 66.00 0.00 0.00 0.00 0.00 0.00 Financial Report July 2014 - Headcount Staffing Page 25 of 26 City of South Bend Staffing Headcount Temporary, Seasonal, and Intern Staff General Government Code Enforcement Jan I Feb I Mar I Apr I May I Jun I Jul I Aug Sep I Oct I Nov I Dec Mayor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 0.00 1.00 1.00 1.00 5.00 6.00 6.00 Clerk 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 Mal0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 0.00 1.00 1.00 1.00 5.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 1.00 0.00 1.00 1.00 1.00 1.00 1.00 Dept, of Community Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Public Works Administration 5.00 5.00 5.00 5.00 5.00 7.00 7.00 Maintenance 17.00 17.00 9.00 19.00 47.00 52.00 51.00 Golf Operations 1.00 1.00 24.00 40.00 48.00 53.00 54.00 Recreation Ops 51.00 51.00 35.00 27.00 34.00 164.00 170.00 Zoological Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Greenhouse Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Sub Total 75.00 75.00 74.00 92.00 135.00 277.00 283.00 0.00 0.00 0.00 0.00 0.00 Police 41.00 41.00 27.00 25.00 32.00 37.00 10.00 Communications 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 Sub Total 41.00 41.00 27.00 25.00 32.00 37.00 10.00 0.00 0.00 0.00 0.00 0.00 Central Services 0.00 0.00 0.00 0.00 0.00 1.00 1.00 Engineering 1.00 1.00 1.00 1.00 7.00 6.00 6.00 Traffic & Lighting 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 Solid Waste Ops 8.00 8.00 5.00 10.00 12.00 12.00 13.00 Street Ops 2.00 2.00 2.00 10.00 7.00 8.00 8.00 Sewer Ops 5.00 5.00 5.00 0.00 8.00 8.00 8.00 Leaf Pickup 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 1.00 1.00 1.00 Organic Resources 1.00 1.00 1.00 1.00 1.00 0.00 0.00 Water Utility s 3.00 3.00 3.00 3.00 4.00 4.00 4.00 Sub Total 20.00 20.00 17.00 25.00 40.00 40.00 41.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 Human Rights 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Morris & Palais 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 137.00 137.00 120.00 144.00 213.00 361.00 341.00 0.00 0.00 0.00 0.00 0.00 Financial Report July 2014 - Headcount Staffing Page 26 of 26