Loading...
HomeMy WebLinkAbout07-2013 Financial ReportPeriod Ending Issued BY.- July 2013 Controller City of South Bend Financial Report Tab Page Contents Narrative 2 Brief discussion on notable fund activity Revenue 3 -10 City Revenues Prop Tax Rev 11 -15 Property Tax Revenue Collection Status Expenditures 16 -20 Expenditures by Fund and Department Debt 21 -22 Debt Status Debt Monthly 23 -24 Current Debt at Month End Headcount 25 -28 Staffing Levels Distribution Mayor Chief of Staff Controller Deputy City Controller City Finance Director Department Heads Fiscal Officers City Common Council Pete Buttigieg Kathryn Roos Mark Neal John Murphy Rahman Johnson Financial Report July 2013 -As Page 1 of 28 July 2013 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 52 %. In comparison, the collected revenue amount for July 2012 was 57% overall of budgeted revenues. The following funds have surpassed their 2013 budgeted revenue amount: Revenue type 340 (ND EMS Service) is over by 102% ($1,355). Events taking place at Notre Dame are being billed in a timely manner, thus payment is being received in a timely manner. Revenue type 352 (forfeits) is over by 386% ($142,929). This is due in large part to 2012 budgeted revenue being received in 2013. Also, in June, the City received civil tax penalties from the County in the amount of $68,797. Revenue type 360 (MVH Curb Program) is over by $30,087 or 220 %. This program has been well received by homeowners who want to improve their property with new curb and sidewalk. This month, revenue type 334 (Grants) is over by 2,235% ($170,820). This month, the Solid Waste Department, received a grant for CNG (Compressed Natural Gas) garbage trucks in the amount of $178,820 from I.D.E.M. (Indiana Department of Environmental Management). Revenue by fund As of July 2013, the general fund has received 55% of its budgeted revenue compared to 56% last year. Fund 643 (Sewage Reserve) is over by 163% ($80,611). In March, a mandatory transfer from fund 641 in the amount of $200,295 was added to increase the sewage reserve per state guidelines. In addition, public safety funds 289 (Hazmat) and 291 (River Rescue) have seen increases in revenue for related services. This year, the City is receiving its COIT, EDIT, and Public Safety distributions from the County on a timely basis. Property taxes Property taxes are received in June and December. In December, the City of South Bend collected approximately $33 million in property taxes for 2012. Total property taxes collected for the year were $72.9 million or 91.56% of the levy collection rate. For 2013, the projected levy collection rate is 95 %. At this time, the City has projected to receive approximately $73.7 million in property taxes. The first distribution amount received was in June 2013 for $38.4 million compared to $39.5 million in June 2012. A breakdown of the distribution is shown page 11. Please note, civil city funds are lower than budget and TIF funds are higher than budget. Specifically, the City expects to experience a shortfall of $2.8 million in property tax revenue in the civil city funds (general fund, parks, CCD) as compared to the $47.3 million budgeted in 2013. On the other hand, the City expects a $1.1 million surplus in property taxes of the $23,751,000 that was budgeted in 2013 for the TIF districts. This results in an estimated net reduction of $1.7 million. Expenditures As of July 2013, the City has spent 44% of budgeted expenditures compared to 48% of budgeted expenditures in July 2012. The General Fund has spent 54% of its 2013 budgeted expenditures, compared to 55% in 2012. The following funds have reached or exceeded 70% 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). In addition, funds 289 (Hazmat) and 291 (River Rescue) have exceeded their budget. Debt In July, several debt service payments were made in the amount of $690,000 to Chase Equipment, CSI Leasing, and PNC Equipment. Payments were for IT equipment lease, vehicle leases, Coveleski Stadium, and the 2007 LED lease. Headcount The Full Time Headcount as of July 31, 2013 was 1,130 vs. a budgeted amount of 1,160. Currently, there is a total of 30 open positions. The open positions are in Parks (4), Public Safety (12), Public Works (8), and other (6). City of South Bend Revenue by Type Report Period Ending: July 2013 S Fund Recipient I Jan I Feb I Mar I Apr I May I Jun I Jul I Aug I Sep I Oct I Nov I Dec I Year I Budget of Budget Property Tax 311 Property Tax Civil City various 24,741,157 24,741,157 48,448,460 51% 311 Property Tax TIF Districts various 13,672,367 13,672,367 23,751,000 58% 311 Property Tax Civil City - Prior various . . . . . . . . . . . . . . NA 311 Property Tax TIF Districts - Prior various . . . . . . . . . . . . . . NA xxx xxx xxx NA Sub Total 38,413,523 38,413,523 72,199,460 53% Income Tax 315 Econ Development Income Tax -Prio 102 NA 315 Econ Development Income Tax 408 681,446 681,446 681,446 681,446 681,446 681,446 681,446 4,770,122 8,177,352 58% 316 Local Option Income Tax - PS 249 491,032 491,032 491,032 491,032 491,032 491,032 491,032 3,437,225 5,89$386 58% 316 County Option Income Tax 404 653,912 653,912 653,912 653,912 653,912 653,912 653,912 4,577,381 7,846,940 58% 316 County Option Income Tax -Prior Yr 102 NA Sub Total 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 12,784,728 21,916,678 58% St Joseph County Remitted by 312 Auto Excise Tax various 1,480,802 1,480,802 $434,362 61% 312 Commercial Vehicle Tax various 442,706 442,706 883,812 50% 312 Financial Institutions Tax various NA 317 Hotel Motel Tax Century Center 670 656,718 656,718 1,313,436 1,313,436 100% 317 Hotel Motel Tax Century Center 420 198,500 198,500 398,500 50% 317 Hotel Motel Tax Cum Cap Impry 407 150,000 150,000 150,000 100% . . . . . . . . . . . . . . NA xxx xxx xxx NA xxx xxx xxx NA 342 EMS County Contract 101 153,268 132,402 132,402 132,402 13$402 132,402 815,278 1,578,277 52% xxx xxx xxx NA Sub Total 656,718 153,268 132,402 330,902 575,108 2,269,922 282,402 4,400,722 6,758,387 65% State of Indiana Remitted by 312 CREED Tax 434 650,000 051. 335 Cigarette Tax 1011407 164,319 164,319 329,808 50% 335 State Pension Subsidy 7011702 5,449,495 5,449,495 10,898,989 50% 335 CTP Distribution 439 1,446,074 1,446,074 1,446,074 10051. 335 Gaming Proceeds 101 600,000 051. 335 Gasoline Tax 2021251 247,877 284,905 372,655 335,708 337,240 287,713 297,670 2,163,767 3,822,432 57% 335 Liquor Excise tax 101 4$017 24,384 66,400 80,000 83% 335 Liquor Gallonage Tax 101 53,748 4$850 48,522 145,120 210,000 69% 335 Prof Sports Development Tax 377 61,389 54,017 54,274 34,458 93,077 297,215 600,000 50% 335 Century Center 671 100,000 100,000 100,000 10051. 335 Wheel Tax 202 322,246 182,545 205,690 361,384 1,071,865 1,980,000 54% xxx xxx xxx NA Sub Total r 2,231,334 380,938 609,474 618,706 430,317 6,287,295 346,192 10,904,256 20,717,303 53% Other Intergovernmental Sources 336 Federal Drug 299 2,216 7,968 27,926 561 8,734 47,406 100,000 47% 337 State Drug 216 5,124 3,816 8,939 35,000 26% 338 Payment in Lieu of Tax various 359,776 359,776 359,776 359,776 359,776 359,776 359,776 2,518,431 4,317,309 58% 339 Contractual Service 211 14,469 5,688 93,910 3,653 5,580 6,897 76,783 206,981 198,800 104% 393 Bonds various 85,740 85,740 21,200,000 0% 398 Bond premium 6611623 NA xxx xxx xxx NA Sub Total 376,462 370,588 461,654 477,096 369,733 375,407 436,559 2,867,497 25,851,109 11% Charge for Service Internal City 340 Liability Insurance 226 247,413 247,413 252,318 249,048 249,048 249,048 249,048 1,743,336 2,988,576 58% 340 General Government Misc Chgs 101 610 410 599 440 80 2,139 NA 340 Police Take Home Vehicle 278 4,810 4,790 7,140 4,750 4,730 4,680 4,660 35,560 63,700 56% 342 EMS Capital 288 152,222 236,226 272,859 274,033 287,104 203,718 226,114 1,652,277 2,760,000 60% 349 Central Service 222 41,565 43,743 42,737 4$867 41,528 41,953 43,839 298,231 648,228 46% 380 Central Service 222 164,610 158,339 205,476 154,014 163,315 144,991 151,451 1,142,195 $227,398 51% 380 Energy Office Reimbursements 222 349,577 373,748 400,916 424,933 375,278 336,207 375,551 2,636,209 4,560,017 58% 380 Internal Service Reimbursement various 118,338 217,335 230,301 243,372 361,836 110,165 148,859 1,430,205 $764,168 52% 392 Administration Fee 101 269,083 269,083 269,083 269,083 269,083 269,083 269,083 1,883,581 3,228,996 58% 392 Internal Fund Transfers various 3,543,576 1,023,207 1,783,951 6,23$734 976,509 1,306,404 4,835,492 19,701,873 31,831,680 62% 395 Employee Benefits various 1,451,937 601,952 1,022,128 1,03$620 1,027,823 1,023,162 1,016,794 7,176,416 12,279,050 58% 396 Central Service Refunds 222 1,577 1,739 1,967 3,080 1,776 5,529 15,667 22,000 71% F1 -,d,l Repo Ju1y2013.x1,. Revenue Report Page3o1`29 City of South Bend Revenue by Type Report Period Ending: July 2013 S Fund Recipient I Jan I Feb I Mar I Apr I May I Jun I Jul I Aug I Sep I Oct I Nov I Dec I Year I Budget I of Budget 396 Self Funded Employee Benefits 711 NA xxx xxx xxx NA Sub Total 6,345,317 3,177,573 4,489,286 8,928,053 3,759,774 3,691,266 7,326,420 37,717,689 63,373,813 60% 3rd Party Revenue 340 ND EMS Service 101 44,870 31,631 4,961 3,479 6,414 91,355 90,000 102% 340 Memorial Hospital Neo Natal 101 12,698 11,638 16,050 113,157 33,334 3$929 35,689 255,495 365,000 70% 350 Job Target Penalty Fee 408 354,660 354,660 354,660 100% 364 Cable TV Franchise Fees 101 18$109 187,926 370,036 703,000 53% 366 AT &TFranchise Fees 101 48,974 51,758 100,732 194,000 52% 380 Loss Recovery 227 3,798,548 3,798,548 3,804,857 100% 380 Bosch Reimbursement /DCI 324 $073,155 76,417 2,149,572 $163,299 99% Sub Total 57,569 24$722 47,681 2,545,933 276,497 39,343 3,910,654 7,120,397 7,674,816 93% Grants 331 Federal Grants various 959,203 417,095 440,882 204,209 202,478 700,426 211,841 3,136,133 9,834,492 32% 334 State Grants various 178,820 178,820 8,000 2235% 360 UDAG 410 448 659 298 345 298 183 2,231 67,715 3% xxx xxx NA Sub Total 959,651 417,754 440,882 204,506 202,823 700,724 390,844 3,317,184 9,910,207 33% Fees for Services External 320 Inspections Central Service 222 510 10 30 10 10 570 1,150 50% 321 Business License 1011222 31,365 26,453 24,240 21,556 7,391 9,293 8,127 128,425 169,617 76% 322 Building Fees 600 88,652 68,472 84,066 74,583 82,269 68,674 73,164 539,880 1,147,035 47% 322 EMS Capital 288 1,666 $673 979 1,624 1,635 $446 1,815 12,838 1$000 107% 322 General Government Fees 101 3,160 4,085 1,145 1,770 3,110 1,985 1,970 17,225 13,000 133% 341 General Government Various various 982 294 1,467 640 3,063 155 1,306 7,907 107,255 7% 342 Highway & Streets 1011202 155,183 43,238 29,026 43,608 271,055 202,000 134% 342 Public Safety various 25,912 1$212 25,556 1$102 7,398 4,381 16,568 104,128 1,027,084 10% 343 Highway & Streets 202 . . . . . . . . . . . . . . NA 344 Solid Waste 610 394,808 396,586 398,932 398,295 401,886 404,208 400,738 2,795,453 4,766,995 59% 344 Code Environmental Clean Up 101 13,797 8,889 5,947 6,492 3,312 7,041 3,554 49,032 50,000 98% 344 Sewage Waste Water 641 2,366,557 $488,497 2,623,876 2,630,897 2,644,550 2,700,171 2,690,426 18,144,974 33,033,547 55% 344 Sewer Repair Insurance 640 44,566 45,535 45,142 45,786 46,435 45,900 45,344 318,709 548,000 58% 344 Water Leak Insurance 620 75,340 75,492 80,340 80,179 80,379 80,920 80,440 553,089 920,340 60% 346 Water Works Utility 620 962,371 1,002,564 1,026,177 1,014,284 1,032,511 1,390,261 1,128,436 7,556,604 13,606,408 56% 346 Solid Waster Misc 610 4,180 4,490 4,770 5,279 4,790 6,820 5,660 35,989 48,835 74% 346 Project ReLeaf 655 35,745 35,760 35,928 35,865 36,001 36,222 36,061 251,582 429,000 59% 347 Parks & Recreation various 150,151 170,910 148,652 337,563 543,231 58$796 700,478 2,633,781 4,746,083 55% 347 Blackthorn Golf Club 619 83,555 43,855 69,388 149,348 227,562 191,052 226,188 990,947 1,696,879 58% 347 Morris PAC 416 743 11,904 2,976 5,186 38,786 1,164 3,986 64,745 100,000 65% 349 Parking Garage Fees 601 59,217 72,531 69,079 80,015 87,601 60,806 77,271 506,521 943,905 54% 349 Code Demolition Board Up 101 474 3,380 4,882 1,062 4,755 1,883 6,242 22,678 50,000 45% 349 Parking Century Center 670 11,950 17,187 18,844 13,008 8,797 7,903 3,050 80,739 170,125 47% 349 Parking SBCDA 420 3,688 $288 3,658 1,613 1,320 3,639 1,914 18,121 34,000 53% 351 Fines & Fees various 18,250 9,903 28,021 31,874 17,372 13,711 12,518 131,649 314,769 42% 352 Forfeits various 101,169 4,914 9,000 150 72,697 5,000 192,929 50,000 386% 354 Ordinance Violation various 6,755 $888 4,739 4,760 5,223 3,283 3,120 30,767 46,000 67% 360 Morris PAC various 16,137 61,947 122,896 53,759 156,538 120,543 25,395 557,215 884,000 63% 360 Palais Royale various 21,021 1$991 5,701 7,794 22,887 19,107 36,489 125,991 207,981 61% 360 Parks & Recreation various 43,263 24,718 2,588 1$023 4,388 13,585 33,088 133,652 66,050 202% 360 Police various 1,043 1,076 880 1,551 1,070 1,815 1,507 8,943 74,850 12% 360 TIF various 4,608 4,638 3,406 76,005 3,749 $989 2,881 98,277 174,371 56% 360 COIT 404 17,500 17,500 36,458 48% 360 Central Services 222 275 1,773 1,588 708 3 78 4,424 8,000 55% FIm,d,l Repo Jely2013.x1,- Revenue Report Page4o1`29 City of South Bend Revenue by Type Report Period Ending: July 2013 S Fund Recipient I Jan I Feb I Mar I Apr I May I Jun I Jul I Aug I Sep I Oct I Nov I Dec I Year I Budget of Budget 360 Century Center 670 8,131 7,823 11,039 9,640 9,307 1,024 3,435 50,400 145,578 35% 360 Code 101 43 70 70 105 221 25 533 $000 27% 360 Cumulative Capital Improvement 4061407 212 212 NA 360 Dept. Of Community Investment 2111212 46,375 23,408 21 59,889 129,694 552,200 23% 360 Stud. /Oliver Rev. Grants 209 NA 360 EMS Capital 288 67 78 146 16,000 1% 360 Engineering/ Curb & Sidewalk 101 938 1,029 2,913 609 738 475 444 7,146 22,000 32% 360 Fire 701 . . . . . . . . . . . . . . NA 360 Police Pension Fund 702 4,000 051. 360 General Government Various 101131226 3,027 860 499 40 4,426 1,100 402% 360 General SBCDA Account 420 79,419 0% 360 Hall of Fame 3131677 42 42 NA 360 Motor Vehicle Highway 202 9 3 12 300 4% 360 Motor Vehicle Highway Scrap Metal 202 250 1,002 1,252 4,000 31 360 Motor Vehicle Highway Curb Prgm 202 557 734 889 643 25,172 21,712 5,380 55,087 25,000 220% 360 Parking Garage Fund 601 (8) (3) 33 22 NA 360 Professional Sports Development 377 41,646 36,205 77,851 81,301 96% 360 Solid Waste Fund 610 617 617 1,000 62% 360 Waste Water 6411719 2,999 3,597 5,766 3,454 15,816 53,000 30% 360 Streets Scrap Metal Sale 101 . . . . . . . . . . . . . . NA 360 Water Works Utility 620 3,799 712 1,423 1,423 37,805 736 45,897 88,500 52% 362 General Fund 101 . . . . . . . . . . . . . . NA 362 Dept. Of Community Investment 212 2,500 1,847 9,674 1,847 15,868 40,800 39% 362 Palais Royale 101 2,050 1,199 1,454 5,575 8,416 8,288 9,511 36,492 84,000 43% 362 Parks & Recreation 201 2,889 3,124 3,013 3,575 6,678 5,518 5,312 30,109 36,000 84% 362 S Bend School Corp Fee 407 25,000 051. 362 TIF Property various 21,775 35,341 20,163 25,368 26,836 27,215 21,503 178,200 238,165 75% 362 UDAG 410 . . . . . . . . . . . . . . NA 369 Memorial Hosp Leighton Plaza 408 150,000 0% 371 Century Center Fees 670 114,235 6$402 87,298 94,025 99,586 90,477 156,212 704,234 1,306,207 54% 399 Bosch Retention Project 210 120,875 120,875 1,46$358 851. 399 Principal on Loan various 18,477 18,726 24,351 18,885 35,287 18,277 21,154 155,157 240,442 65% 399 Principal Income xxx 237,331 1,763 1,763 1,763 242,620 753,687 32% xxx xxx xxx NA Sub Total 4,791,458 5,155,697 5,023,822 5,435,645 5,754,223 6,174,692 5,943,531 38,279,068 71,097,794 54% Interest Income 361 Bank Account Interest various 115,132 147,388 87,581 46,045 53,075 99,112 44,821 593,155 1,291,446 46% xxx xxx NA xxx xxx NA Sub Total 115,132 147,388 87,581 46,045 53,075 99,112 44,821 593,155 1,291,446 46% Donations 367 ND Contribution 101 275,000 275,000 275,000 100% 367 Donations various 66,651 1,132 1,412 1,120 855 1$630 855 84,653 111,668 76% xxx xxx xxx NA Sub Total 66,651 1,132 1,412 1,120 855 12,630 275,855 359,653 386,668 93% Historic Preservation 368 Palais 450 1,251 686 339 551 1,277 1,293 2,722 8,118 16,000 51% 368 General Fund 101 NA xxx xxx xxx NA Sub Total 1,251 686 339 551 1,277 1,293 2,722 8,118 16,000 51% Sale of Assets 391 TIF 4201324 196 1,673 21,513 23,382 136,673 17% 391 Water Hydrant Reimbursement 620 190 8,214 65 7,347 571 70 16,457 20,000 82% 391 Sale of Fixed Assets various 300 300 3,500 9% 391 Vehicle Damage Reimbursement various 1,000 0% xxx xxx xxx NA Sub Total 386 8,214 1,738 7,347 571 21,583 300 40,139 161,173 25% Revenue Total 17,428,318 11,882,349 13,122,661 20,42$293 13,209,343 59,913,179 20,786,689 - - - - - 156,764,831 301,354,854 52% report 17,428,318 11,882,349 13,122,661 20,422,293 13,209,343 59,913,179 20,786,689 - - - - - 156,764,831 301,354,854 (0) 0 (0) F1nam9al Repo Jely2013.x1s- Revenue Report Page 5 of29 City of South Bend Period Ending: July 2013 Revenue by Fund Report s % Fund 1 Jan I Feb I r I A r Ma Jun I Jul I I.g ct I Nov Dec Year I Bud et of Bud et ernment 'ice 101 29,524 neral Revenues 101 1,158,752 1,042,137 741,662 775,058 1,313,822 21,830,281 1,006,054 _ _ _ 27,867,766 53,080,130 yor 101 151 186 227 151 151 151 251 1,271 4,617 I Call Center 101 17,304 73,555 618,846 44,009 39,551 35,818 887,262 1,616,000 = -PS LOIT funded 101 783,298 320,102 A 101 2,349,893 3,133,190 i Total 1,191,981 1,863,142 63,002 127,615 2,409,661 65,685 60,725 1,843,571 6,433,402 mmon Council 101 696 703 1,055 703 703 703 703 5,267 8,300 ntroller 101 29 3 253,727 365 10 406 50 fal 101 560 32 144 21 138 193 18 1,106 72,350 i Total 1,160,189 1,043,061 743,088 776,299 1,314,815 21,831,339 1,007,026 27,875,816 53,485,549 s -rgy Office 101 _ _ _ _ _ _ _ _ _ _ _ _ _ _ pneering 101 45,123 (41,173) 186 199 4,335 36,100 Xg Maintenance 101 c 8 Lighting 101 250 100 350 i Total 250 45,123 (41,173) 186 299 4,685 36,100 V 'ice 101 29,524 45,699 35,877 15,376 21,676 21,174 32,314 201,639 360,500 'ice Communications 101 de Hearing 101 ais Royale 101 24,589 14,785 7,711 'ice -PS LOITfunded 101 992,142 18,184 992,142 992,142 2,994,609 3,968,567 1,976 101 58,179 17,304 73,555 618,846 44,009 39,551 35,818 887,262 1,616,000 = -PS LOIT funded 101 783,298 218,107 783,298 783,298 2,349,893 3,133,190 i Total 1,191,981 1,863,142 63,002 127,615 2,409,661 65,685 60,725 1,843,571 6,433,402 9,078,257 ement de 101 22 2,301 17 8 16 371 36 2,772 300 de Hearing 101 ais Royale 101 24,589 14,785 7,711 14,554 33,008 28,626 de Junk Vehicle 101 240 120 135 1,976 2,471 36,000 de Unsafe Building 101 102,493 9,294 5,032 10,512 4,905 74,580 11,292 218,107 103,000 de Animal Control 101 8 8 1,191,981 70 30,291 30,377 1,100 i Total 102,763 11,723 5,184 10,520 6,967 74,951 41,619 253,727 140,400 re rris PAC 101 16,931 59,825 123,647 53,629 155,607 122,628 24,954 557,221 882,000 ais Royale 101 24,589 14,785 7,711 14,554 33,008 28,626 48,532 171,805 309,981 i Total 41,520 74,611 131,358 68,182 188,615 151,254 73,486 729,026 1,191,981 is man Rights 101 Total General Fund Revenue Total 3,167,863 1,237,519 1,007,245 3,264,663 1,534,908 22,118,455 2,966,001 - - - - - 35,296,655 63,932,287 55% Financial Report July 2013..b - E� Summary Page 6 0/26 City of South Bend Period Ending: July 2013 Revenue by Fund Report s % Fund I Jan I Feb I r I A r Ma Jun I Jul I Aug Se Oct I Nov I c I Year I Bud et of Bud et Parks 8 Recreation for Vehicle Highway 0000 Parks General revenue 201 60,506 59,913 59,371 58,552 130,152 4,241,013 58,727 4,668,235 9,039,090 52% 1100 Administration 201 3,038 3,249 3,163 3,800 7,113 6,078 6,002 32,443 37,050 88% 1101 Maintenance 201 41,982 3,002 2,115 2,242 2,114 2,024 30,000 77,474 345,000 22% 1102 Golfo erations 201 1,724 83,527 12,732 147,111 232,715 231,350 245,688 954,846 1,599,000 60% 1103 Recreation Division 201 43,772 12,475 4,014 707 1,912 24,765 45,254 132,899 195,640 68% 1104 Potawatomi Zoo 201 6,854 4,230 7,896 118,947 238,168 221,300 264,801 862,197 1,036,500 83% 1106 Potawatomi Greenhouse 201 984 570 640 268 2,020 642 252 3,645 8,400 43% 1107 Communit Svc Block Grant 201 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 1108 Graffiti Removal 201 26,059 25,958 25,882 12,564 14,473 18,094 17,714 27,037 101,649 27% Recreation Non Reverting 203 100,355 98,597 124,637 72,144 74,440 116,426 142,844 729,443 1,636,943 45% East Race Water way 271 7 6 5 3 3 6 3 33 100 33% Coveleski Stadium 401 14 12 10 5 6 12 5 62 500 12% Zoo Endowment 403 25 21 18 9 10 22 9 114 2,900 4% Park Non Reverting 405 329 256 308 8,666 794 1,035 5,925 17,311 203,500 9% xxx xxx xxx 3,524 3,524 3,524 3,524 14,096 1,805,314 NA Sub Total 658 259,590 259,284 214,909 424,750 703,919 4,844,031 799,255 7,505,739 14,206,272 53% s for Vehicle Highway 202 488,959 201,470 457,710 2,885,616 320,036 613,846 1,606,089 6,573,726 8,691,971 �tral Services 222 594,468 613,113 655,810 712,436 620,498 560,628 612,323 4,369,277 7,922,703 ;al Roads 8 Streets 251 83,847 89,429 99,998 92,159 90,773 89,360 92,567 638,133 1,061,143 eject ReLeaf 655 36,186 36,134 36,262 36,044 36,154 36,562 36,198 253,541 431,700 133,438 xxx 594,769 1,086,500 55% Waterworks Capital 622 2,126 1,790 1,521 784 i Total 1,848 1,203,460 940,145 1,249,780 3,726,255 1,067,463 1,300,395 2,347,178 11,834,676 18,107,517 s Solid Waste 'id Waste Operations 610 399,588 410,140 404,066 408,709 406,873 411,360 585,350 3,026,085 5,257,701 'id Waste Capital 611 279,339 29 32 235,002 13 105 315,937 830,457 784,261 xxx i Total 678,926 410,168 404,098 643,710 406,886 411,465 901,287 3,856,542 6,041,962 Public Works Water Utility 0000 Wastewater Revenues 620 899,232 945,800 956,340 951,433 975,187 1,302,134 1,032,586 7,062,713 12,680,908 56% 0630 Wastewater 620 75,340 75,492 80,340 80,179 80,379 80,920 80,440 553,089 920,340 60% 0640 Water Works 620 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 0660 Clay Water 620 69,426 72,918 73,398 72,030 75,449 133,438 98,110 594,769 1,086,500 55% Waterworks Capital 622 2,126 1,790 1,521 784 859 1,848 702 9,630 14,000 69% Waterworks Construction 623 2,976 2,475 2,077 995 1,032 2,120 813 12,489 18,000 69% Waterworks Deposit 624 722 570 520 268 295 642 252 3,269 6,100 54% Waterworks Sinking 625 170,955 170,979 171,024 171,037 171,096 171,320 171,124 1,197,535 2,108,381 57% Waterworks Bond Reserve 626 26,059 25,958 25,882 25,654 25,686 18,094 17,714 165,047 313,509 53% Waterworks Debt Reserve 629 46,320 860 747 382 422 910 356 49,996 52,801 95% xxx xxx xxx 10 8 7 4 4 2 1 36 NA Sub Total 649 1,293,155 1,296,842 1,311,848 1,302,762 1,330,406 1,711,426 1,402,098 9,648,537 17,200,539 56% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 45,161 46,036 45,577 46,014 46,690 46,449 45,561 321,489 549,200 59% 0000 Wastewater Revenues 641 2,232,520 2,342,225 2,468,427 2,478,278 2,511,840 2,546,646 2,521,189 17,101,126 31,288,374 55% 0621 Sewer Department 641 2,142 1,261 3,403 2,000 0625 Concrete Crew 641 4,930 4,503 6,237 3,876 19,546 75,000 26% 0630 Wastewater Operations 641 _ _ _ _ _ _ _ _ _ _ _ _ NA 0631 Organic Resources 641 _ _ _ _ _ _ _ _ _ _ _ _ NA 0650 Clay Sewage 641 136,798 151,188 157,884 153,565 135,652 157,535 169,502 1,062,123 1,766,173 60% Sewage Capital 642 4,546 3,819 3,102 1,525 1,655 3,541 1,296 19,483 4,560,000 0% Sewage Reserve 643 1,586 1,335 201,432 619 684 1,475 577 207,709 127,098 163% Sewer Bond 200612006 645 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA Sewer Bond 2007 647 10 8 7 4 4 2 1 36 NA Sewage Bond Sinking 649 814,673 814,684 815,032 814,845 775,341 776,031 774,947 5,585,553 8,234,756 68% Clay Sewage General 650 0 0 0 0 0 0 0 2 NA Sewage Bond 2007 651 20 17 13 6 6 2 1 65 NA Sewage Works DS Reserve 653 3,524 3,524 3,524 3,524 14,096 1,805,314 1% 2010 CSO Net Sewer Bond 658 58 48 39 20 20 17 5 206 NA 2011 Sewer Bond 659 5,214 4,149 3,371 1,669 1,826 3,885 1,518 21,633 60,000 36% 2012 Sewer Bond 661 10,033 8,508 4,388 4,814 10,366 4,011 60,000 0% 2013 Sewer Bond 663 21,200,000 0% 2013A Sewer Refund Bonds 664 85,740 2 85,742 NA Sub Total 3,244,109 3,377,066 3,711,847 3,594,701 3,486,911 3,545,950 3,523,745 24,484,330 69,727,915 35% Financial Report Juy 201I.b - E� Summary Page 7 of 28 City of South Bend Period Ending: July 2013 Revenue by Fund Report s % Fund 1 Jan 1 Feb 1 r A r Ma Jun I Jul I I.g ct 1 Nov 1 c I Year I Bud et of Bud et Public Safet - Police 'S-Capital 288 158,312 Police Seizures 216 74 5,186 54 28 3,845 63 25 9,276 35,900 26% Curfew Violations 218 43 17 42 27 27 17 139 313 1,025 31% Law Enforcement Education 220 25,208 10,840 16,746 24,433 9,531 10,554 20,227 117,539 347,000 34% Public Safet LOIT 249 492,566 491,812 713,536 491,501 491,342 830,749 491,431 4,002,936 5,900,386 68% Excess Welfare Public Safet 252 1 1 0 0 0 1 0 3 10 NA Police Take Home Vehicle 278 9,821 9,752 14,430 9,580 9,549 9,530 9,399 72,061 129,400 56% Police Block Grant 280 2 2 1 1 1 2 1 9 185,300 0% Police Grants 292 12,771,400 12,075 3,121 5,262 38,870 1,348 38,532 38,532 110,000 35% Police Academ 294 10,138 3,935 1,231 3,415 962 37 14 19,732 28,500 69% COPS More Grants 295 1,085 1,102 919 950 1,092 737 819 6,705 41,600 16% Dru Enforcement 299 2,320 23,108 8,046 28,002 641 8,806 64 70,988 102,000 70% K -9 Unit 705 1 1 1 1 0 1 0 6 2,000 0% xxx xxx xxx 1,406,622 1,652,183 1,408,869 1,820,562 1,445,449 2,540,054 1,548,524 11,822,263 21,142,979 NA Sub Total 541,259 545,756 755,006 557,939 516,990 860,496 560,652 4,338,099 6,883,111 63% V - Fire 'S-Capital 288 158,312 241,519 276,434 277,404 293,748 208,431 230,331 1,686,181 3,730,084 rmat 289 1 1 16,723 3 4 9 3 16,744 3,000 ,er Rescue 291 2,561 49 12,538 17,520 5,664 4,053 578 42,963 31,500 7,289 xxx 1,637,764 2,341,808 ot. of Community Investment 212 61,995 76,544 144,292 121,560 i Total 160,875 241,569 305,695 294,927 299,417 212,493 230,912 1,745,888 3,764,584 of Community Investment 'debakerl0liver 209 554 466 397 205 225 484 190 2,520 5,000 to Grant 210 471 163,234 336 201 210 449 175 165,075 1,624,187 I Operating 211 444,219 6,698 165,307 433,348 5,885 7,289 575,019 1,637,764 2,341,808 ot. of Community Investment 212 61,995 76,544 144,292 121,560 161,963 504,897 98,665 1,169,915 6,714,700 grams 212 431,260 390,046 255,729 81,742 55,179 230,679 13,959 1,458,593 2,085,605 gnomic Revenue Bond 281 14 12 10 5 6 12 5 63 100 303 xxx 310 187 3,289 70,104 5% Major Moves 412 4,050 240,741 i Total 1,527 938,512 636,999 566,070 637,061 223,467 743,811 688,012 4,433,932 12,771,400 ages king Garage Revenue 601 367 281 268 123 155 326 103 1,624 4,010 in Street 601 16,336 24,002 16,035 18,220 38,122 16,331 36,895 165,940 259,581 ghton Plaza 601 25,840 31,229 35,667 42,758 30,056 29,854 42,255 237,658 458,904 �orcement 601 5,689 7,750 5,449 6,096 8,421 7,024 8,810 49,238 183,267 yne Street 601 16,989 17,256 17,329 18,992 19,411 14,577 28,521 133,075 225,150 Jy Street Commons 601 1,100 5,217,727 770 60% 310 410 50 2,230 15,900 303 xxx 310 187 3,289 70,104 5% Major Moves 412 4,050 240,741 i Total 1,527 66,320 80,517 75,518 86,190 96,476 68,111 116,634 589,765 1,146,812 Capital /Debt Service Hall of Fame 313 5,956 5,956 5,956 5,956 11,643 727,753 5,956 769,174 1,257,789 61% COIT 404 702,571 701,326 701,762 699,819 698,955 717,369 696,926 4,918,728 8,732,872 56% Cum Capital Development 406 4,267 4,199 4,147 3,997 8,823 273,033 3,966 302,432 614,325 49% Cum Capital Improvement 407 50 34 129,108 150,001 279,193 434,090 64% EDIT 408 686,567 685,681 689,737 1,102,953 683,657 685,888 683,245 5,217,727 8,732,012 60% UDAG 410 461 1,093 585 303 351 310 187 3,289 70,104 5% Major Moves 412 4,050 240,741 2,894 1,527 1,665 3,527 1,283 255,687 528,662 48% Morris PAC Improvement 416 946 12,075 3,121 5,262 38,870 1,348 4,063 65,685 101,500 65% CREED 434 106 57 43 47 47 42 38 379 651,000 0% Palais Historic Preservation 450 1,280 711 361 563 1,289 1,321 2,733 8,258 16,125 51% Hall of Fame Capital 677 369 310 264 136 149 357 127 1,711 4,500 38% xxx xxx xxx NA Sub Total 1,406,622 1,652,183 1,408,869 1,820,562 1,445,449 2,540,054 1,548,524 11,822,263 21,142,979 56% Financial Report July 2013..b - E� summary Page 8 0f 28 City of South Bend Period Ending: July 2013 Revenue by Fund Report s % Fund 1 Jan 1 Feb 1 Mar I 1p, I Ma Jun I Jul I log I Se Oct I Nov I Dec I Year I Bud et of Bud et Other Miscellaneous Pension Rain Da 102 4,405 3,708 3,159 1,629 1,787 3,852 1,509 20,050 52,000 39% Gift, Donation, Be uest 217 827 297 154 277 13 9,839 12 11,420 17,011 67% Loss Recover 227 2,227 1,875 7,905 821 900 1,938 3,799,307 3,814,973 3,829,857 100% Human Ri hts 258 264 207 12,147 3,602 740 28,048 127 45,134 237,250 19% Morris Palais Marketin 273 23 2,162 10 265 1,406 13 785 4,663 8,100 58% Professional Sorts Develo ment 377 103,569 54,401 54,533 34,601 93,242 382 36,362 377,090 687,801 55% Buildin O erations 600 88,757 68,560 85,230 74,621 82,311 68,761 73,197 541,437 1,148,035 47% Centur Center 670 791,035 87,640 117,181 116,672 117,690 756,122 162,697 2,149,037 2,935,706 73% Centur Center Capital 671 100,022 21 23 23 1,087 46 971 100,135 100,500 100% xxx xxx xxx 83 69 38 12 14 164,197 25 164,438 321,000 NA Sub Total 436 1,091,128 218,870 280,343 232,512 298,089 869,000 4,073,995 7,063,938 9,016,260 78% wrance siness Insurance Revenues 226 250,264 249,680 254,272 250,212 250,230 251,570 250,040 1,756,268 3,016,076 f Funded Liability Ins 226 bility Insurance 226 siness Insurance 226 rkers Compensation 226 17,000 xxx i Total 250,264 249,680 254,272 250,212 250,230 251,570 250,040 1,756,268 3,033,076 ust 8A_, ency Pension 701 691 567 311 66 2,149,032 2,517,646 7,120,851 2,519,282 5,040,279 'ice Pension 702 1,451 1,249 1,129 294 133 2,931,894 19 2,936,170 5,873,697 'ice/ Fire Pension 703 420,791 (420,791/ 422 232 191 133 69 75 264,847 ployee Benefits 711 1,006,296 997,370 996,182 1,005,536 1,218,384 1,005,264 1,002,172 7,231,204 12,188,900 employment Comp 713 28,475 28,471 28,477 28,462 21,362 21,408 16,029 172,684 341,450 y Cemtery Trust 730 21 18 15 8 9 18 7 96 250 415 xxx 432,960 420 437,157 823,000 53% TIF Southside 430 2,767 2,323 i Total 969 1,457,725 606,885 1,026,114 1,034,366 1,239,887 6,476,231 1,018,227 12,859,436 23,444,576 Civil City Revenues 15,759,811 11,753,485 12,571,614 17,870,609 12,900,498 45,953,489 20,426,562 - - - - - 137,236,067 270,419,290 51% Tax Increment Financing TIFAir ort 324 74,452 8,846 373,716 2,149,032 4,970 7,120,851 82,267 9,814,134 13,940,252 701/ TIF Central Dave lo ment 420 38,071 45,172 38,158 233,554 58,723 1,765,391 35,447 2,214,515 4,663,254 47% TIF West Wash in ton 422 232 191 133 69 75 264,847 81 265,628 444,000 60% TIF Lei hton Plaza 425 13,032 19,331 10,063 15,086 12,575 16,317 10,321 96,726 156,905 62% TIF Medical Service 426 1,979 1,611 1,326 676 709 614,692 624 621,618 1,730,000 36% TIF North east 429 1,138 957 810 415 455 432,960 420 437,157 823,000 53% TIF Southside 430 2,767 2,323 1,931 969 1,036 1,383,745 945 1,393,716 1,840,000 76% TIF Erskine Commons 431 NA TIF Erskine Villa a 432 2,855 2,327 1,921 991 1,087 662,077 971 672,230 1,346,000 50% TIF Douglas Road 435 83 69 38 12 14 164,197 25 164,438 321,000 51% Northeast Residential TIF 436 1,796 1,493 776 367 403 1,340,895 449 1,346,179 2,460,000 55% xxx xxx xxx NA Sub Total 136,404 82,321 428,873 2,401,173 80,048 13,765,973 131,550 17,026,342 27,724,411 61% Financial Report July 2013,1s - Expe� Summary Page 9 0f 28 City of South Bend Period Ending: July 2013 Revenue by Fund Report s % Fund 1 Jan I Feb I r A r Ma Jun I Jul I log I Se Oct I Nov Dec Year I Bud et of Bud et ant Funds 128,863 551,047 2,551,683 308,846 13,959,690 358,782 - - - - - 19,527,418 30,935,564 63% �tral Bond Proceeds 305 City Operations Total 17,428,318 11,882,348 13,122,661 20,422,293 trict Capital 2003 428 _ _ _ _ _ _ _ _ _ _ _ _ _ _ ministration 433 16 14 12 6 7 14 5 73 150 veleski Bond Construction 438 167 141 120 36 464 50 ,tified Technology Park 439 1,446,493 956 832 429 471 1,014 397 1,450,593 1,448,074 port Urban Enterprise Zone 454 192 162 138 71 78 168 66 876 1,000 ickthorn Golf Operations 619 83,555 43,855 119,869 149,348 227,562 191,052 226,188 1,041,428 1,747,379 xlor i Total 1,530,256 44,987 120,850 149,854 228,117 192,248 226,657 2,492,969 3,196,603 Redevelopment Commsssion 1,668,507 128,863 551,047 2,551,683 308,846 13,959,690 358,782 - - - - - 19,527,418 30,935,564 63% Ili, Improvement 1990 314 City Operations Total 17,428,318 11,882,348 13,122,661 20,422,293 Fort Debt Reserve 2003 315 533 449 382 197 216 465 182 2,423 5,000 veleski Bond Debt Reserve 317 257 217 185 95 104 225 88 1,171 3,500 ickthorn Debt Service 319 167 141 120 36 464 50 ntral Development reserve 328 890 750 638 329 361 777 304 4,049 6,000 xxx i Total 1,848 1,556 1,324 657 681 1,468 575 8,108 14,550 Redevelopment Commsssion 1,668,507 128,863 551,047 2,551,683 308,846 13,959,690 358,782 - - - - - 19,527,418 30,935,564 63% City Operations Total 17,428,318 11,882,348 13,122,661 20,422,293 13,209,343 59,913,178 20,786,689 - - - - - 156,764,831 301,354,854 52% Revenue report 17,428,318 11,882,349 13,122,661 20,422,293 13,209,343 59,913,179 20,786,689 0 0 0 0 0 156,764,831 301,354,854 0 0 0 0 0 1 0 0 0 0 0 0 0 0 Financial Report July 2013..b - E� summary Page 10 of 26 City of South Bend Property Tax Revenue 2012 Tax Pay 2013 Fund Period Ending. July 2013 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61412013 611712013 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 38,369,939.03 0.95 36,451,442.08 13,051,204.28 6,798,591.66 19,849,795.94 18,520,143.09 51.73% Parks & Recreation 201 7,623,780.24 0.95 7,242,591.23 2,593,163.21 1,350,822.26 3,943,985.47 3,679,794.77 51.73% College Football Hall of Fame 313 1,341,607.54 0.95 1,274,527.16 - 693,822.13 693,822.13 647,785.41 51.72% Cumulative Capital District 406 490,121.50 0.95 465,615.43 166,710.61 86,842.35 253,552.96 236,568.54 51.73% Fire Pension 701 - 0.95 - - - - - - Police Pension 702 2,607,578.70 0.95 2,477,199.77 1,340,027.53 1,340,027.53 1,267,551.17 Total - City 51.39% 47,825,448.31 430 45,434,175.89 15,811,078.10 8,930,078.40 24,741,156.50 23,084,291.81 51.73% Tax Increment Financing Airport TIF District 324 15,275,702.92 0.95 14,511,917.77 7,111,555.29 7,111,555.29 8,164,147.63 46.55% South Bend Central TIF District 420 3,761,712.00 0.95 3,573,626.40 1,705,490.58 1,705,490.58 2,056,221.42 45.34% West Washington TIF District 422 584,897.07 0.95 555,652.22 264,689.94 264,689.94 320,207.13 45.25% Central MedicalTlFDistrict 426 2,128,725.48 0.95 2,022,289.21 613,184.76 613,184.76 1,515,540.72 28.81% Northeast Residential TIF District 436 2,607,578.70 0.95 2,477,199.77 1,340,027.53 1,340,027.53 1,267,551.17 51.39% Southside TIF District # 1 430 2,618,580.97 0.95 2,487,651.92 1,381,537.24 1,381,537.24 1,237,043.73 52.76% 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 659,734.88 659,734.88 50.00% Douglas Road TIF District 435 322,082.97 0.95 305,978.82 164,167.82 164,167.82 157,915.15 50.97% Northeast TIF 429 1,152,857.67 0.95 1,095,214.79 431,978.67 431,978.67 720,879.00 37.47% 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 13,672,366.71 16,099,240.83 45.92% Grand Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 - 38,413,523.21 39,183,532.64 49.50° State Board 2010 Audit Fee Revised Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 0.00 38,413,523.21 39,183,532.64 49.50° Note(s) 1 Distribution 1 - 2 Distribution 2 - 3 Distribution 3 - x Financial Report July 2013.xis - Property Tax Revenue Page 11 o 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 Records Factor Collections Collections Collections Collections Collections Receivable Rate City General Fund 101 42,159,959.10 0.95 40,051,961.15 14,149,210.75 7,476,750.77 17,742,469.36 39,368,430.88 2,791,528.22 93.38% Parks & Recreation 201 8,374,886.47 0.95 7,956,142.15 2,810,677.15 1,485,222.94 3,528,156.04 7,824,056.13 550,830.34 93.42% College Football Hall of Fame 313 859,959.09 0.95 816,961.14 - 622,017.06 511,188.06 1,133,205.12 (273,246.03) 131.77% Cumulative Capital District 406 554,158.31 0.95 526,450.39 185,979.85 98,275.80 233,454.74 517,710.39 36,447.92 93.42% Fire Pension 701 - 0.95 - - - - - - Police Pension 702 0.95 Total - City 51,948,962.97 49,351,514.82 17,145,867.75 9,682,266.57 22,015,268.20 48,843,402.52 3,105,560.45 94.02% Tax Increment Financing Airport TIF District 324 12,266,234.17 0.95 11,652,922.46 6,111,684.64 5,519,602.49 11,631,287.13 634,947.04 94.82% South Bend Central TIF District 420 3,781,492.40 0.95 3,592,417.78 1,909,554.48 1,761,923.84 3,671,478.32 110,014.08 97.09% West Washington TIF District 422 483,719.73 0.95 459,533.74 225,083.13 197,631.37 422,714.50 61,005.23 87.39% Central MedicalTlFDistrict 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° Mate Board 2010 Audit Fee Revised Total 79,621,606.40 75,640,526.08 17,145,867.75 22,390,036.25 33,368,626.53 72,904,530.53 6,717,075.87 91.56° Note(s) 1 Distribution 1 - 2 Distribution 2 - 3 Distribution 3 - x Comment(s) Financial Report July 2013.xis - Property Tax Revenue Page 12 of 28 City of South Bend Property Tax Revenue 2010 Tax Pay 2011 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy 101 Per County Collection Projected 612112011 1212812011 Date Total Property Tax Collection 39,963,057.95 Records Factor Collections Collections Collections Collections Collections Receivable Rate City Airport TIF District General Fund 101 42,066,376.79 0.95 39,963,057.95 21,251,193.18 17,263,356.48 38,514,549.66 3,551,827.13 91.56% 420 Parks & Recreation 201 8,312,858.52 0.95 7,897,215.59 4,199,509.82 3,414,250.57 7,613,760.39 699,098.13 91.59% 478,174.00 College Football Hall of Fame 313 1,254,347.89 0.95 1,191,630.50 854,618.51 695,335.24 1,549,953.75 (295,605.86) 123.57% 0.95 Cumulative Capital District 406 590,078.38 0.95 560,574.46 298,097.21 242,356.51 540,453.72 49,624.66 91.59% 2,363,686.96 Fire Pension 701 - 0.95 - - - - - 2,252,259.60 - Police Pension 702 561,847.33 0.95 Erskine Commons TIF District #2 431 2,698,264.66 0.95 2,563,351.43 1,362,916.56 (578,543.97) Total - City 1,913,892.07 52,223,661.58 Erskine Village TIF District #3 49,612,478.50 26,603,418.72 21,615,298.80 - 48,218,717.52 4,004,944.06 92.33% Tax Increment Financing Airport TIF District 324 11,653,069.38 0.95 11,070,415.91 5,952,841.44 5,234,926.22 11,187,767.66 465,301.72 96.01% South Bend Central TIF District 420 3,859,762.90 0.95 3,666,774.76 2,014,629.66 1,618,843.54 3,633,473.20 226,289.70 94.14% West Washington TIF District 422 478,174.00 0.95 454,265.30 196,385.97 234,699.42 431,085.39 47,088.61 90.15% Central MedicalTlFDistrict 426 3,695,172.21 0.95 3,510,413.60 852,442.61 851,795.76 1,704,238.37 1,990,933.84 46.12% Northeast Residential TIF District 436 2,488,091.54 0.95 2,363,686.96 1,227,023.65 1,219,079.25 2,446,102.90 41,988.64 98.31% Southside TIF District # 1 430 2,370,799.58 0.95 2,252,259.60 1,136,488.71 672,463.54 1,808,952.25 561,847.33 76.30% Erskine Commons TIF District #2 431 2,698,264.66 0.95 2,563,351.43 1,362,916.56 (578,543.97) 784,372.59 1,913,892.07 29.07% Erskine Village TIF District #3 432 2,570,770.65 0.95 2,442,232.12 1,285,385.33 317,796.76 1,603,182.09 967,588.56 62.36% Douglas Road TIF District 435 517,502.30 0.95 491,627.19 183,946.89 122,106.31 306,053.20 211,449.10 59.14% Northeast TIF 429 841,360.54 0.95 799,292.51 374,489.89 340,572.61 715,062.50 126,298.04 84.99% Airport Urban Enterprise Zone 454 123,164.82 0.95 117,006.58 61,582.41 61,582.41 123,164.82 - 100.00% Other xxx 0.95 Total - Tax Increment Financing 31,296,132.58 29,731,325.95 14,648,133.12 10,095,321.85 - 24,743,454.97 6,552,677.61 79.06% Grand Total 83,519,794.16 79,343,804.45 41,251,551.84 31,710,620.65 - 72,962,172.49 10,557,621.67 87.36% State Board 2010 Audit Fee - Revised Total 83,519,794.16 79,343,804.45 41,251,551.84 31,710,620.65 0.00 72,962,172.49 10,557,621.67 87.36% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6121111 2 Distribution 2 - 3 Distribution 3 - x Comment(s) Financial Report July 2013.xis - Property Tax Revenue Page 13 o City of South Bend Property Tax Revenue 2009 Tax Pay 2010 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Distribution 4 Levy Per County Collection Projected 5/27/2010 6/29/2010 111912010 1212912010 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City Airport TIF District 324 10,906,735.00 General Fund 101 43,440,450.00 0.95 41,268,427.50 13,247,102.10 9,621,576.15 4,648,299.56 12,297,565.55 39,814,543.36 3,625,906.64 91.65% 1,685,661.11 Parks & Recreation 201 8,483,379.00 0.95 8,059,210.05 2,586,993.98 1,878,973.94 907,754.99 2,401,561.33 7,775,284.24 708,094.76 91.65% (204,578.95) College Football Hall of Fame 313 1,295,350.00 0.95 1,230,582.50 - 869,696.83 - 646,790.08 1,516,486.91 (221,136.91) 117.07% 429 Cumulative Capital District 406 659,240.00 0.95 626,278.00 201,034.29 146,014.34 70,541.30 186,624.39 604,214.32 55,025.68 91.65% 2,092,721.75 Fire Pension 701 - 0.95 - - 431 - - - - 1,565,972.05 - Police Pension 702 Erskine Village TIF District #3 0.95 1,919,446.00 0.95 1,823,473.70 959,722.81 898,703.74 1,858,426.55 61,019.45 96.82% Douglas Road TIF District Total - City 321,325.00 53,878,419.00 305,258.75 51,184,498.05 16,035,130.37 12,516,261.26 5,626,595.85 15,532,541.35 49,710,528.83 4,167,890.17 92.26% 0.95 Tax Increment Financing Airport TIF District 324 10,906,735.00 0.95 10,361,398.25 5,390,314.95 6,030,692.29 11,421,007.24 (514,272.24) 104.72% South Bend Central TIF District 420 3,558,777.00 0.95 3,380,838.15 1,685,661.11 2,229,497.21 3,915,158.32 (356,381.32) 110.01% West Washington TIF District 422 426,766.00 0.95 405,427.70 88,267.35 543,077.60 631,344.95 (204,578.95) 147.94% Central MedicalTIFDIStrfcf 426 3,593,126.00 0.95 3,413,469.70 849,441.76 909,586.45 1,759,028.21 1,834,097.79 48.96% Northeast TIF District 429 208,326.00 0.95 197,909.70 103,892.25 77,373.83 181,266.08 27,059.92 87.01% Southside TIF District # 1 430 2,202,865.00 0.95 2,092,721.75 1,134,619.79 1,315,314.36 2,449,934.15 (247,069.15) 111.22% Erskine Commons TIF District #2 431 3,162,689.00 0.95 3,004,554.55 1,574,777.70 1,565,972.05 3,140,749.75 21,939.25 99.31% Erskine Village TIF District #3 432 1,919,446.00 0.95 1,823,473.70 959,722.81 898,703.74 1,858,426.55 61,019.45 96.82% Douglas Road TIF District 435 321,325.00 0.95 305,258.75 137,583.10 135,928.49 273,511.59 47,813.41 85.12% Northeast Residential TIF 436 1,815,862.00 0.95 1,725,068.90 897,114.07 918,714.85 1,815,828.92 33.08 100.00% Airport Urban Enterprise Zone 454 132,020.00 0.95 125,419.00 66,009.75 66,009.75 132,019.50 0.50 100.00% Other xxx 0.95 Total -Tax Increment Financing 28,247,937.00 26,835,540.15 - 12,887,404.64 - 14,690,870.62 27,578,275.26 669,661.74 97.63% Grand Total 82,126,356.00 78,020,038.20 16,035,130.37 25,403,665.90 5,626,595.85 30,223,411.97 77,288,804.09 4,837,551.91 94.11% State Board 2008 Audit Fee or Revised Total 82,126,356.00 78,020,038.20 16,035,130.37 25,403,665.90 5,626,595.85 30,223,411.97 77,288,804.09 4,837,551.91 94.11% 2 Distribution 2 - Issued by County on June 29 3 Distribution 3 -Draw issued by County on November 9 x Comment(s) Financial Report July 2013.xis - Property Tax Revenue Page 14 of 28 City of South Bend Property Tax Revenue 2008 Tax Pay 2009 Fund Fund # Levy Estimated Levy Per County Collection Projected Distribution 1 Distribution 2 Distribution 3 Distribution 4 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate City Airport TIF District General Fund 101 46,551,387.02 0.95 44,223,817.67 42,771,228.00 (991,832.22) 41,779,395.78 4,771,991.24 89.75% Parks & Recreation 201 8,605,545.37 0.95 8,175,268.10 7,906,741.00 (183,351.88) 7,723,389.12 882,156.25 89.75% College Football Hall of Fame 313 1,315,782.24 0.95 1,249,993.13 1,208,935.00 (28,033.85) 1,180,901.15 134,881.09 89.75% Cumulative Capital District 406 805,004.52 0.95 764,754.29 739,635.00 (17,151.21) 722,483.79 82,520.73 89.75% Fire Pension 701 275,396.27 0.95 261,626.46 253,033.00 (5,867.38) 247,165.62 28,230.65 89.75% Police Pension 702 444,870.93 0.95 422,627.38 408,746.00 9,479.00 399,267.00 45,603.93 89.75% Total - City 99.55% 57,997,986.35 432 55,098,087.03 53,288,318.00 (1,235,715.54) 52,052,602.46 5,945,383.89 89.75% Tax Increment Financinq Airport TIF District 324 10,058,437.13 0.95 9,555,515.27 10,087,422.39 10,087,422.39 (28,985.26) 100.29% South Bend Central TIF District 420 3,526,506.54 0.95 3,350,181.21 3,420,958.84 3,420,958.84 105,547.70 97.01% West Washington TIF District 422 256,464.52 0.95 243,641.29 228,704.14 228,704.14 27,760.38 89.18% Central Medical TIFDistrkt 426 3,614,010.63 0.95 3,433,310.10 1,765,934.06 1,765,934.06 1,848,076.57 48.86% Northeast TIF District 429 14,133.54 0.95 13,426.86 14,133.72 14,133.72 (0.18) 100.00% Southside TIF District # 1 430 1,937,246.72 0.95 1,840,384.38 1,644,200.70 1,644,200.70 293,046.02 84.87% Erskine Commons TIF District #2 431 2,850,711.91 0.95 2,708,176.31 2,837,842.49 2,837,842.49 12,869.42 99.55% Erskine Village TIF District #3 432 2,771,936.93 0.95 2,633,340.08 1,900,860.36 1,900,860.36 871,076.57 68.58% Douglas Road TIF District 435 218,606.56 0.95 207,676.23 187,247.91 187,247.91 31,358.65 85.66% Airport Urban Enterprise Zone 454 169,410.67 0.95 160,940.14 169,410.67 169,410.67 - 100.00% Other xxx 0.95 0.23 0.23 (0.23) #DIV /0! Total - Tax Increment Financing 25,417,465.15 24,146,591.89 22,256,715.51 22,256,715.51 3,160,749.64 87.56% Grand Total 83,415,451.50 79,244,678.93 53,288,318.00 21,020,999.97 74,309,317.97 9,106,133.53 89.08° State Board 2008 Audit Fee Op (18,844.00) (18,844.00) Revised Total 83,415,451.50 79,244,678.93 53,288,318.00 21,002,155.97 0.00 0.00 74,290,473.97 9,106,133.53 89.06°/ Note(s) 1 2 X X Comment(s) Financial Report July 2013.xis - Property Tax Revenue Page 15 of28 City of South Bend Period Ending: July 2013 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep Oct Nov I Dec I Year I ud et of Bud et rernment rris PAC 101 79,568 80,987 90,428 72,893 69,441 orgy Office 101 542,447 or 101 62,503 47,311 54,127 44,646 49,780 52,944 53,396 364,708 694,229 r Call Center 101 10,455 20,659 27,025 18,726 19,097 18,951 22,094 137,007 320,102 ,rk 101 25,214 22,533 37,222 24,635 24,564 23,219 25,395 182,783 365,170 mmon Council 101 27,381 22,507 29,612 69,206 26,565 21,305 26,512 223,088 515,397 ntroller 101 132,676 133,465 185,982 146,255 143,535 147,644 136,610 1,026,167 1,877,728 ial 101 64,312 57,169 76,908 61,743 63,274 69,686 71,415 464,506 1,028,466 r 3,849,063 3,787,951 5,447,214 3,940,341 3,881,069 4,560,197 4,082,798 29,548,633 53,791,388 b Total 322,541 303,644 410,877 365,212 326,815 333,749 335,422 2,398,259 4,801,092 's rris PAC 101 79,568 80,987 90,428 72,893 69,441 orgy Office 101 542,447 lice 54,256 1,837,065 54,256 2,307,957 gineering 101 92,121 103,866 131,505 109,771 112,729 76,945 116,507 743,443 1,393,561 dflc 8 Lighting 101 24,326 46,239 10,341 19,670 8,960 109,536 111,815 r lice -PS LOITfunded 101 232,248 362,762 415,315 288,534 295,407 b Total 116,446 150,105 141,846 183,697 112,729 85,905 116,507 907,235 1,505,376 L rris PAC 101 79,568 80,987 90,428 72,893 69,441 68,319 80,811 542,447 lice 101 1,837,065 1,587,293 2,307,957 1,698,826 1,632,809 1,801,813 1,733,157 12,598,920 23,795,376 lice Communications 101 149,657 146,236 210,289 165,511 162,301 168,876 159,503 1,162,374 2,326,560 lice -PS LOITfunded 101 232,248 362,762 415,315 288,534 295,407 408,201 282,287 2,284,754 3,968,567 e 101 1,463,155 1,527,091 2,061,862 1,609,128 1,614,715 1,752,189 1,441,165 11,469,305 20,567,695 9-PS LOIT funded 101 166,938 164,570 451,790 178,342 175,838 429,118 466,685 2,033,280 3,133,190 r b Total 3,849,063 3,787,951 5,447,214 3,940,341 3,881,069 4,560,197 4,082,798 29,548,633 53,791,388 :ement rris PAC 101 79,568 80,987 90,428 72,893 69,441 68,319 80,811 542,447 de 101 108,213 122,305 148,505 139,379 115,365 111,452 145,251 890,471 2,186,969 de Hearing 101 b Total 1,500 5,478 1,500 1,500 2,500 7,500 19,978 40,000 de Junk Vehicle 101 4,142 5,020 8,874 4,846 4,564 2,611 (1,874) 28,203 65,829 de Unsafe Building 101 2,765 1,870 5,460 875 2,082 1,695 2,360 17,107 107,684 de Animal Control 101 41,716 44,150 61,637 40,359 45,592 45,312 51,246 330,012 596,111 r b Total 156,835 174,845 229,954 186,960 169,123 163,286 204,483 1,285,486 2,996,593 re rris PAC 101 79,568 80,987 90,428 72,893 69,441 68,319 80,811 542,447 1,033,800 eis Royale 101 31,386 27,038 38,976 32,036 32,333 28,508 37,204 227,481 492,830 r b Total r 110,954 108,025 129,405 104,929 101,774 96,826 118,015 769,928 1,526,630 ,is man Rights 101 23,083 24,800 31,528 28,881 20,153 24,164 27,355 179,964 346,237 b Total 23,083 24,800 31,528 28,881 20,153 24,164 27,355 179,964 346,237 General Fund Expenditure Total 4,578,923 4,549,371 6,390,823 4,810,018 4,611,663 5,264,127 4,884,581 - - - - - 35,089,505 64,967,316 54% Fm-wlRepatJ* 2013.x6 - ExperMdwe Sunx Page 16 &28 City of South Bend Period Ending: July 2013 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I ct Nov Dec I Year I ud of of Bud of Parks & Recreation lid Waste Operations 610 640,573 399,576 for Vehicle Highway 1100 Administration 201 108,405 89,616 105,106 83,749 84,356 108,543 84,864 664,638 1,160,278 57% 1101 Maintenance 201 393,900 350,794 452,885 394,825 533,739 458,919 416,673 3,001,734 5,651,698 53% 1102 Gol(O erations 201 64,123 175,427 137,984 155,769 145,797 146,068 163,063 988,230 1,619,936 61% 1103 Recreation Division 201 124,459 135,459 182,820 146,559 135,171 162,637 209,878 1,096,983 2,058,335 53% 1104 Potawatomi Zoo 201 137,992 133,640 205,665 156,904 158,040 175,569 193,939 1,161,748 2,213,702 52% 1106 Potawatomi Greenhouse 201 5,144 8,264 5,540 4,181 2,134 1,706 840 27,808 86,865 32% 1107 Comm unit Svc Block Grant 201 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 1108 Graffiti Removal 201 5,920 6,644 7,490 6,983 6,298 5,883 6,310 45,527 101,649 45% _ Recreation Non Revertin 203 45,993 43,310 88,061 43,801 66,744 64,738 168,231 520,878 1,560,777 33% 910 East Race 271 7,500 63% xxx xxx xxx 13,616 346 0% 19,017 Coveleski Stadium 401 Sewa a Bond Sinking NA Sub Total 800 1,171,111 1,391,545 1,432,417 1,144,004 3,540 0% 1,575,350 Park Non Reverting 405 6,302 4,874 10,366 31,388 8,761 3,482 7,275 72,449 217,316 33% xxx xxx xxx Sewa a Bond 2007 651 4,582 5,220 26,182 NA Sub Total 1 892,237 948,028 1,195,916 1,024,158 1,141,041 1,127,545 1,251,072 7,579,996 14,674,442 52% 's lid Waste Operations 610 640,573 399,576 for Vehicle Highway 202 483,878 566,089 730,143 463,866 468,146 507,769 588,107 3,807,998 9,066,496 nfral Services 222 563,474 609,351 701,699 677,588 771,690 361,445 610,818 4,296,064 7,979,429 :al Roads & Streets 251 17,647 13,100 500 271,678 6,350,045 39,810 138,450 481,184 1,235,924 Iject ReLea( 655 3,735 2,354 2,447 252,179 13,947 826 13,645 289,132 432,065 r xxx 31,788 238,977 1,216,792 20% 641 Waterworks Construction 623 90,214 392,957 b Total 75,752 1,068,733 1,190,895 1,434,788 1,665,310 1,253,783 909,850 1,351,020 8,874,378 18,713,914 's Solid Waste lid Waste Operations 610 640,573 399,576 401,422 613,502 390,482 387,538 786,291 3,619,382 5,565,984 lid Waste Capital 611 188,809 79,617 10,821 45,454 188,809 513,511 784,061 I xxx 1,021,803 929,932 1,044,184 1,016,672 936,030 1,009,124 b Total 829,382 479,193 412,243 613,502 390,482 432,992 975,100 4,132,893 6,350,045 Public Works Wafer Utility 0630 Wastewater 620 57,675 53,878 38,049 49,067 82,881 120,503 130,536 532,591 1,191,000 45% 0640 Water Works 620 1,021,803 929,932 1,044,184 1,016,672 936,030 1,009,124 1,114,491 7,072,235 13,601,947 52% 0660 Clay Wafer 620 26,901 235 37,513 3 15 150 2,311 2,707 3,000 90% 0630 Wastewater Operations Waterworks Capital 622 818 10,754 3,600 1,782 11,025 179,210 31,788 238,977 1,216,792 20% 641 Waterworks Construction 623 90,214 392,957 345,248 75,752 246,843 34,170 295,145 1,480,329 4,826,536 31% Waterworks Deposit 624 1,332 520 268 295 642 252 3,309 4,000 83% 47,174 Waterworks Sinking 625 600 578 71 84 143 408,567 471 410,515 2,108,381 19% Waterworks Bond Reserve 626 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA _ Waterworks Debt Reserve 629 _ 1,879 747 382 422 910 356 4,695 7,500 63% xxx xxx xxx 13,616 13,616 19,017 72% Sewa a Bond Sinking NA Sub Total 800 1,171,111 1,391,545 1,432,417 1,144,004 1,277,654 1,753,276 1,575,350 9,745,357 22,959,156 42% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 34,416 18,132 32,759 29,708 46,100 26,994 27,995 216,103 555,844 39% 0621 Sewer Repair 641 445,598 393,031 424,400 321,521 343,147 326,245 362,527 2,616,469 5,228,916 50% 0625 Concrete Crew 641 26,901 23,851 37,513 26,075 22,711 29,834 27,495 194,380 449,446 43% 0630 Wastewater Operations 641 1,947,182 1,828,903 2,152,180 1,864,780 1,918,510 1,857,179 1,805,752 13,374,485 27,922,500 48% 0631 Organic Resources 641 54,465 45,115 63,900 93,819 83,682 107,691 70,761 519,435 1,374,876 38% 0650 Clay Sewage 641 171 34 379 5,602 6,186 6,500 95% Sewa a Ca ital 642 47,174 693,978 127,395 50,895 83,594 700,698 322,960 2,026,694 11,774,073 17% Sewa a Reserve 643 2,921 1,136 619 684 1,475 577 7,413 18,000 41% Sewer BOnd 2006/2006 645 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA Sewer Bond 2007 647 13,616 13,616 19,017 72% Sewa a Bond Sinking 649 800 1,080,895 1,581,020 300 2,663,015 8,723,149 31% Cla Sewa a General 650 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA Sewa a Bond 2007 651 4,582 5,220 26,182 35,983 39,512 91% Sewa a Works OS Reserve 653 2,434,563 3,524 2,438,087 NA 2010 CSO Net Sewer Bond 658 518 6,692 4,415 63,651 24,521 99,796 112,089 89% 2011 Sewer Bond 659 745,740 609,749 34,944 113,818 5,500 36,536 14,334 1,560,622 10,696,720 15% 2012 Sewer Bond 661 104,981 206 157,047 335,748 978,383 1,576,365 19,160,000 8% 2013 Sewer Bond 663 2,100,000 0% 2013A Sewer Bond 664 35,750 45,314 81,064 NA Sub Total 3,406,975 3,627,925 2,883,862 6,120,348 4,281,302 3,492,613 3,616,687 27,429,712 88,180,642 31% F-11?.,, tJ* 2013.x% - Expendbne Suns Gage 17 or28 City of South Bend Period Ending: July 2013 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep Oct Nov I Dec I Year I Bud et of Bud of Public Safef - Police "S Capital 288 38,560 40,567 806,139 697,957 21,335 874,056 322,488 2,801,101 4,581,267 -at Police Seizures 216 3,017 3,238 500 10,000 291 18,756 1,342 3,654 13,194 2,451 27,675 9,759 10,500 45,900 23% xxx Curfew Violations 218 11,487 432,675 b Total m 57,317 41,909 809,897 711,150 23,901 904,748 332,248 2,881,170 4,635,933 1,000 0% 175,425 Law Enforcement Education 220 9,543 118,650 11,254 30,860 5,769 1,639 11,575 189,290 478,131 40% 284,403 Public Safef LOIT 249 1,775,439 of. of Community Investment 18,184 1,775,439 436 26,824 1,775,439 5,344,501 7,101,757 75% 1,557 Excess Welfare Public Safety 252 212 90 98,334 1,991,851 70,876 400 143 95 238 NA grams Police Take Home Vehicle 278 388,265 394,456 197,024 254,365 174,722 15,983 63,700 63,700 103,700 61% 94,299 Police Block Grant 280 253,515 62,349 9,823 97,234 571,622 1,129,839 b Total W 185,000 0% 777,126 Police Grants 292 622,929 395,435 4,092,214 13,572,364 62,989 36,911 123,222 36,911 110,000 34% Police Academy 294 1,298 427 8,513 549 259 6,077 130 17,252 28,500 61% COPS More Grants 295 485 2,281 1,784 980 864 600 1,114 8,107 41,980 19% Oru Enforcement 299 6,433 65,631 20,649 3,390 3,239 _ _ _ _ 99,342 188,573 53% K -9 Unit 705 2,223 348 553 10,385 8,287 3,635 13,587 39,018 2,000 0% xxx xxx xxx NA Sub Total m 1,793,198 186,989 60,883 1,821,218 10,129 45,226 1,851,959 5,769,603 8,286,541 70% y - Fire "S Capital 288 38,560 40,567 806,139 697,957 21,335 874,056 322,488 2,801,101 4,581,267 -at 289 105 115 3,017 3,238 3,000 ,er Rescue 291 18,756 1,342 3,654 13,194 2,451 27,675 9,759 76,831 51,666 r xxx 61,657 404 11,487 432,675 b Total m 57,317 41,909 809,897 711,150 23,901 904,748 332,248 2,881,170 4,635,933 of Community Investment Oebaker /Oliver 209 40,451 555 8,786 118,076 13,414 560 23,827 205,670 1,000,000 ife Grant 210 11,492 61,657 404 11,487 432,675 18,003 102,639 1,260,777 D Operating 211 166,430 164,291 237,247 175,425 177,448 163,661 166,317 1,250,819 2,354,331 of. of Community Investment 212 37,133 29,868 83,765 135,853 90,607 284,403 193,480 855,110 6,332,298 of. of Community Investment 212 424 436 26,824 67,062 21,816 7,787 1,557 1,557 224,570 ministration 212 90 98,334 1,991,851 70,876 400 143 95 238 2,565 grams 212 457,037 388,265 394,456 197,024 254,365 174,722 15,983 1,881,851 2,622,393 r xxx 94,299 2,242 52,161 253,515 62,349 9,823 97,234 571,622 1,129,839 b Total W 672,092 582,424 777,126 508,301 533,907 622,929 395,435 4,092,214 13,572,364 ages in Sfreef 601 40,451 555 8,786 118,076 13,414 560 23,827 205,670 301,200 Joseph 601 100% COIT 404 1,604,033 432,675 4,925 4,925 445,103 ghfon Plaza 601 39,892 1,051 23,238 57,671 17,167 1,166 42,988 183,172 486,099 forcement 601 13,443 200 (6,687) 10,705 9,552 200 6,719 34,131 87,390 ryne Street 601 424 436 26,824 67,062 21,816 7,787 18,775 143,124 224,570 dy Street Commons 601 90 98,334 1,991,851 70,876 400 110 6,749,278 600 30,580 r xxx 409 _ _ _ _ _ _ _ _ _ _ _ _ _ b Total NA 94,299 2,242 52,161 253,515 62,349 9,823 97,234 571,622 1,129,839 Capital /Debt Service Hall of Fame 313 633,500 634,500 1,268,000 1,268,000 100% COIT 404 1,604,033 432,675 453,623 1,698,086 445,103 516,990 933,477 6,083,987 9,258,915 66% Cum Capital Development 406 42 42 56,588 42 239,748 56,588 42 353,092 911,220 39% Cum Capital Improvement 407 184,875 182,700 367,575 367,575 100% EDIT 408 1,474,544 100,752 98,334 1,991,851 70,876 98,350 2,914,570 6,749,278 8,933,379 76% Cumulative Sewer 409 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA UDAG 410 268,146 0% Major Moves 412 87,697 162,116 62,989 579,715 123,222 1,015,738 3,395,846 30% Morris PAC Improvement 416 230 6,550 1,474 1,243 10,241 10,691 30,429 72,666 42% CREED 434 36,975 36,975 873,949 4% Palais Historic Preservation 450 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA Hall of Fame Ca ital 677 2,223 348 553 10,385 8,287 3,635 13,587 39,018 179,322 22% xxx xxx xxx NA Sub Total m 3,936,420 628,065 610,572 3,863,722 837,245 1,255,278 4,812,789 15,944,090 25,529,018 62% Fm-wlRepatJ* 2013.x6 - ExperMdwe Sunx Page 18 M28 City of South Bend Period Ending: July 2013 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov 1 Dec 1 Year I ud of of Bud et Other Miscellaneous 'f Funded Liability Ins 226 Excess Lev 103 20,766 16,983 12,478 15,336 41,814 138,548 260,786 bilify Insurance 226 NA 58,289 Gift, Donation, Be uest 217 142,246 35,024 245,942 698,032 1,093,448 siness Insurance 1,310 1,310 11,853 NA 6,625 Loss Recover 221 363,812 16,033 4,880 6,000 226 10,475 27,550 64,938 526,185 12% 11,724 General Grant 250 1,070,000 r _ _ _ _ _ _ _ _ _ _ _ _ NA 3,197 Human Ri hts lBuildingOperations 258 10,686 11,706 15,927 17,604 11,848 18,850 20,799 107,420 228,930 47% b Total Morris Palais Markefin 273 2,049 1,808,364 2,000 2,008,226 2,188,227 2,217,052 1,342 5,391 10,149 53% Economic Revenue Bond 281 33,901 2,388,995 1% TIF Soufhside 430 123,533 143,219 26,106 27,102 0% 203,973 Professional Sorts Development 377 487,548 800 23% TIF Erskine Commons 431 _ 388,123 876,470 876,671 100% _ _ _ _ 600 73,110 71,233 105,481 81,057 74,438 80,459 77,953 563,731 1,148,152 49% 143,950 Ce tury Center 670 185,479 217,733 244,571 218,796 233,991 301,804 57,773 1,460,148 2,935,707 50% 95,488 Century Center Capital 671 Northeast Residential TIF 436 1,371,000 195,888 1,329 991 1,453,324 NA xxx xxx xxx xxx NA Sub Total Sub Total 758,870 317,506 372,859 323,457 320,278 411,588 574,850 3,079,409 5,752,896 54% surance 'f Funded Liability Ins 226 15,212 15,959 20,766 16,983 12,478 15,336 41,814 138,548 260,786 bilify Insurance 226 21,320 58,289 33,770 161,441 142,246 35,024 245,942 698,032 1,093,448 siness Insurance 226 19,087 11,853 14,625 6,625 12,847 6,625 363,812 435,474 491,693 ,rkers Compensation 226 202,349 58,626 32,028 72,301 30,915 11,724 31,155 439,099 1,070,000 r xxx 177,842 668,815 27% TIF Leighton Plaza 425 3,970 3,197 3,197 15,000 b Total xxx 257,968 144,726 101,190 257,351 198,486 68,708 682,723 1,711,153 2,915,927 usf &Agency e Pension 701 464,307 464,608 443,629 479,693 459,567 445,038 447,417 3,204,259 5,900,028 lice Pension 702 542,086 553,264 540,482 540,395 538,344 542,040 536,439 3,793,051 6,929,133 iployee Benefits 711 14 1,1,446 1,271,799 817,518 880,753 1,004,019 1,196,061 1,228,463 7,540,058 13,348,829 employment Comp 713 5,422 9,728 6,734 5,664 6,296 5,089 1,536 40,469 267,247 1CemeteryTrust 730 177,842 668,815 27% TIF Leighton Plaza 425 3,970 3,197 3,197 15,000 I xxx 7,647 61,502 151,185 41% TIF Medical Service 426 233,051 57,906 11,201 b Total 43,938 2,153,261 2,299,400 1,808,364 1,906,504 2,008,226 2,188,227 2,217,052 14,581,034 26,460,237 Civil City Expenditure 21,670,787 16,390,218 18,343,100 25,022,559 16,950,446 18,486,930 24,618,099 - - - - - 141,482,138 304,128,270 47% Tax Increment Financing TIF Air ort 324 1,666,888 1,813,585 551,674 876,628 317,864 262,700 1,594,314 7,083,654 25,244,592 28% TIF Sam /e Ewin 414 NA TIF Central Development 420 48,684 1,278,115 51,308 237,795 39,520 48,560 53,090 1,757,072 5,302,102 33% TIF West Washington 422 90,126 105 237 18,127 27,484 41,972 177,842 668,815 27% TIF Leighton Plaza 425 3,970 4,267 11,307 8,306 7,490 18,516 7,647 61,502 151,185 41% TIF Medical Service 426 233,051 57,906 11,201 171,858 43,938 111,071 127,063 756,087 4,770,544 16% TIF Northeast 429 8,320 22,064 781 2,736 33,901 2,388,995 1% TIF Soufhside 430 123,533 143,219 26,106 15$086 41,934 203,973 709,340 1,406,191 6,122,885 23% TIF Erskine Commons 431 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA TIF Erskine Village 432 344,898 1,157 143,950 490,005 501,268 98% TIF Douglas Road 435 95,231 257 95,488 454,782 21% Northeast Residential TIF 436 1,371,000 195,888 1,329 991 1,453,324 3,022,532 3,229,957 94% xxx xxx xxx NA Sub Total 3,890,468 3,610,169 655,358 1,452,672 469,864 672,304 4,133,437 14,884,273 48,835,125 30% Finn ww/RepatJ* 2013.x& - Expendbne Suns Page 190/28 City of South Bend Period Ending: July 2013 Expenditure Report 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 Year I ..get of Bud et rent Funds 3,883,918 1,046,006 1,545,904 671,419 nfral Bond Proceeds 305 - - - - - 16,335,563 51,176,668 3211 :tricf Capital 2003 428 _ _ _ _ ministration 433 470 384 854 6,787 veleski Bond Construction 438 981 382 197 ,tified Technology Park 439 182 2,423 5,000 port Urban Enterprise Zone 454 19,367,140 28,986,582 0 0 0 0 0 157,817,701 ickfhorn Golf Operations 619 49,154 270,820 63,509 92,200 200,594 206,664 234,559 1,117,500 1,997,705 r 2XX 308 326,120 36 b Total 49,154 270,820 63,509 92,670 200,978 206,664 234,559 1,118,354 2,004,493 3 3,883,918 1,046,006 1,545,904 671,419 880,210 4,368,483 - - - - - 16,335,563 51,176,668 3211 blic Improvement 1990 314 _ _ _ _ _ _ _ _ _ _ _ _ _ _ port Debf Reserve 2003 315 981 382 197 216 465 182 2,423 5,000 veleski Bond Debt Reserve 317 19,367,140 28,986,582 0 0 0 0 0 157,817,701 355,304,938 0 0 0 0 ickfhorn Debt Service 319 308 326,120 36 326,464 326,050 nfral Development reserve 328 1,640 638 329 361 777 304 4,049 6,000 r m b Total 2,929 327,139 562 577 1,243 487 332,936 337,050 Redevelopment Commsssion 3,939,623 3,883,918 1,046,006 1,545,904 671,419 880,210 4,368,483 - - - - - 16,335,563 51,176,668 3211 City Operations Total 25,610,410 20,274,135 19,389,106 26,568,463 17,621,865 19,367,141 28,986,582 - - - - - 157,817,701 355,304,938 44% Expenditure report 25,610,410 20,274,135 19,389,106 26,568,463 17,621,865 19,367,140 28,986,582 0 0 0 0 0 157,817,701 355,304,938 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Fm-wlRepatJ* 2013.x6 - ExperMdwe Sunx Gage 20 or28 City of South Bend Debt Schedule Period Ending: July 2013 Year of Year of Year of Scheduled Payments Debt (Orig /Refl) Debt at 2013 Principal 2013 interest 2013 Debt at 2013 Total Debt Instrument Debt Pur ose Issue Refundin Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2012 Payments Pa ment Addition 12/31/2013 Debt Payments Civil City Debt Bond Debt Ama , * st CEDIT Bond 1997 2006 2017 408 2/1 811 - - 11,870,000.00 3,535,000.00 720,000.00 154,213.75 0.00 2,815,000.00 874,213.75 ss South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 811 - - 9,250,000.00 4,890,000.00 505,000.00 168,526.00 0.00 4,385,000.00 673,526.00 zs Water Works Improvements Water Works 2002 2012 2023 625 1/1 7/1 - - 5,975,000.00 3,785,000.00 335,000.00 82,428.89 0.00 3,450,000.00 417,428.89 ss South Bend Building Corporation Fire HQ/ Police HQ 2003 2012 2023 404/324 2/1 8/1 - - 21,335,000.00 13,595,000.00 1,230,000.00 404,545.67 0.00 12,365,000.00 1,634,545.67 41 Sewage Works Improvements Sewage Works 2004 2024 649 6/1 12/1 - - 11,425,000.00 7,980,000.00 0.00 0.00 (7,980,000.00) 0.00 0.00 24 Water Works Improvements Water Works 2006 2027 625 1/1 7/1 - - 4,710,000.00 3,700,000.00 195,000.00 163,726.00 0.00 3,505,000.00 358,726.00 42 Sewage Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7,630,000.00 6,425,000.00 335,000.00 282,472.50 0.00 6,090,000.00 617,472.50 4o Sewage Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16,600,000.00 13,670,000.00 660,000.00 589,947.50 0.00 13,010,000.00 1,249,947.50 sz Sewage Works Revenue Bonds 20076 Sewage Works 2007 2027 649 611 12/1 - - 16,515,000.00 13,615,000.00 655,000.00 577,741.26 0.00 12,960,000.00 1,232,741.26 az Century Center Special Tax Bonds Century Center 2008 2028 420 511 11/1 - - 4,655,000.00 4,165,000.00 175,000.00 215,213.00 0.00 3,990,000.00 390,213.00 eg Water Works Improvements Water Works 2009 2030 625 1/1 7/1 - - 5,380,000.00 5,185,000.00 200,000.00 278,432.00 0.00 4,985,000.00 478,432.00 7o Sewage Works Revenue Bonds - 2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3,297,000.00 2,822,021.00 145,425.00 80,262.00 34,302.00 2,710,898.00 225,687.00 8o 2010 Sewage Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9,345,000.00 8,630,000.00 360,000.00 343,417.50 0.00 8,270,000.00 703,417.50 85 Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21,500,000.00 20,740,000.00 845,000.00 757,650.00 0.00 19,895,000.00 1,602,650.00 88 2012 Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8,300,000.00 8,300,000.00 340,000.00 237,286.26 0.00 7,960,000.00 577,286.26 tot 2012 Sewage Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25,000,000.00 25,000,000.00 1,015,000.00 549,917.33 0.00 23,985,000.00 1,564,917.33 ios 2013A Sewer Bond Refunding m Sewage Works 2013 2013 2024 649 6/1 1211 - - 14,765,000.00 0.00 1,065,000.00 171,864.60 14,765,000.00 13,700,000.00 1,236,864.60 Total Bond Debt 220,052,000.00 146,037,021.00 8,780,425.00 5,057,644.26 6,819,302.00 144,075,898.00 13,838,069.26 Loans Payable t State Revolving Fund Bosch Properly 2002 2022 210 1/30 10/30 - - 506,448.00 362,337.59 29,819.93 15,242.71 0.00 332,517.66 45,062.64 ea State Revolving Fund Water Works Improvement 2009 2030 625 111 7/1 - - 427,332.00 409,613.00 18,316.00 13,803.96 0.00 391,297.00 32,119.96 az Interfund Loan 410 - UDAG xxx 1st Source /Marriott Garage 2010 2015 410 6/15 12/15 - - 2,700,000.00 2,027,973.00 468,597.00 0.00 0.00 1,559,376.00 468,597.00 Total Loans Payable 8,838,780.00 2,799,923.59 516,732.93 29,046.67 0.00 2,283,190.66 545,779.60 Capital Leases n 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 st Chase LED Equipment 2007 2017 101 1/1 7/1 - - 1,531,573.00 894,298.74 164,040.38 36,539.33 0.00 730,258.36 200,579.71 ss Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 983,508.00 102,062.12 102,062.12 1,918.73 0.00 0.00 103,980.85 se Oce Copier 209 N Main 2008 2013 620 Monthly - - - 12,078.21 1,373.87 1,373.87 24.73 0.00 0.00 1,398.60 sz Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 586.30 586.30 10.52 0.00 0.00 596.82 se Lanier Copier 915 Olive 2008 2013 620 Monthly - - - 5,154.00 586.30 586.30 10.52 0.00 0.00 596.82 ss Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 408.66 408.66 6.29 0.00 0.00 414.95 az Sun Trust Solid Waste Containers/Trucks 2009 2014 611 9/1 3/1 - - 720,990.00 230,257.00 152,089.72 7,144.86 0.00 78,167.28 159,234.58 7t Kansas State Bank Clerk Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,209.00 3,091.43 2,452.59 145.29 0.00 638.84 2,597.88 n Kansas State Bank Cade Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10/23 9,209.00 4,497.64 1,902.89 295.67 0.00 2,594.75 2,198.56 75 Kansas State Bank Engineering Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,391.00 3,152.53 2,501.06 148.18 0.00 651.47 2,649.24 74 CSI Leasing Inc IT Netapp San 2010 2014 404 1/1 4/1 7/1 10/1 207,521.37 69,136.85 54,900.44 2,887.56 0.00 14,236.41 57,788.00 76 Kansas State Bank Central Services Copier 2010 2015 222 2/16 5/16 8/16 11/16 13,366.40 7,066.14 2,703.37 356.63 0.00 4,362.77 3,060.00 n GE Capital information Technology Animal Control Copier 2010 2015 101 2/28 5/30 8/30 11/30 3,550.69 1,880.04 718.07 97.33 0.00 1,161.97 815.40 7e Kansas State Bank Mayor Oce Copier 2010 2015 101 1/8 4/8 7/8 10/8 9,209.00 5,395.33 1,830.88 367.68 0.00 3,564.45 2,198.56 78 Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10,511.02 6,757.73 2,055.32 540.04 0.00 4,702.41 2,595.36 V Public Finance.com Inc Solid Waste Containers/Trucks 2011 2015 611 6/15 12/15 - - 321,853.00 196,824.94 63,572.60 5,692.40 0.00 133,252.34 69,265.00 ss Sun Tmst Police, Parks, Bldg vehicles 2011 2016 4041201/600 3/15 6/15 9/15 12/15 2,068,202.00 1,468,556.77 409,515.93 25,449.47 0.00 1,059,040.84 434,965.40 so Capital One Public Funding Solid Waste Containers/Trucks 2011 2016 611 3/15 6/15 9/15 12/15 207,432.00 157,040.69 40,925.46 2,360.10 0.00 116,115.23 43,285.56 st GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 2,812.10 746.42 142.31 0.00 2,065.68 888.73 sz Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 1,111,166.74 267,571.17 27,828.24 0.00 843,595.57 295,399.41 se Ikon Office Solutions Mayor Ricoh MP 2851 SP Copier 2011 2016 101 2/15 5/15 8/15 11115 2,569.53 2,102.03 481.88 106.60 0.00 1,620.15 588.48 ss Sun Tmst Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 302,832.89 84,802.22 4,520.25 0.00 218,030.67 89,322.47 sz Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1,295,000.00 1,171,344.99 252,666.26 18,785.02 0.00 918,678.73 271,451.28 sa PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15 - - 945,674.38 854,300.45 184,894.68 12,164.16 0.00 669,405.77 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,806,054.00 548,996.45 31,952.89 0.00 2,257,055.55 580,951.34 ioz Ikon Office Solutions/ Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 5,325.70 1,047.38 274.54 0.00 4,278.32 1,321.92 too GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 5,259.30 989.16 281.64 0.00 4,270.14 1,270.80 ios Ricoh USA Central Services Copier 2013 2018 222 2/27 5/27 8/27 11/27 3,622.78 0.00 618.14 221.64 3,622.78 3,004.64 839.78 107 Ricoh USA Street/Sewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 0.00 1,052.81 217.99 5,559.15 4,506.34 1,270.80 toe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5/12 8/12 11/12 5,559.15 0.00 1,030.83 239.97 5,559.15 4,528.32 1,270.80 109 Ricoh USA Parks & Rec Ricoh Copiers(3) 2013 2018 201 2/21 5/21 8/21 11/21 16,129.94 0.00 2,991.45 695.79 16,129.94 13,138.49 3,687.24 tto PNC Equipment Finance Vehicle /Equipment Lease 2013 2018 101/202/406/641 1/15 7/15 - - 1,689,669.59 0.00 0.00 0.00 1,689,669.59 1,689,669.59 0.00 ttt Ricoh USA x�ar Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,666.67 0.00 1,736.32 207.68 10,666.67 8,930.35 1,944.00 Total Capital Lease 17,213,014.81 9,414,171.28 2,353,853.13 181,634.05 1,731,207.28 8,791,525.43 2,535,487.18 Total Civil City 246,103,794.81 158,251,115.87 11,851,011.08 5,288,324.98 8,550,509.28 155,150,614.09 16,919,336.04 rr JWy 1011 -De& Page 21 ar28 City of South Bend Debt Schedule Period Ending: July 2013 Year of Year of Year of Scheduled Payments Debt (Orig /Refi) Debt at 2013 Principal 2013 interest 2013 Debt at 2013 Total Debt Instrument Debt Purpose Issue Refundin Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2012 Payments Pa ment Addition 12/31/2013 Debt Pa ments Redevelopment Commission Debt Bond Debt 9 Central Business TIF 1990 1996 2012 420 2/1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 0.00 +o Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 620,000.00 620,000.00 14,880.00 0.00 0.00 634,880.00 2 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1 - - 6,825,000.00 2,505,000.00 435,000.00 55,100.00 0.00 2,070,000.00 490,100.00 e College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15,370,000.00 6,400,000.00 1,115,000.00 152,705.00 0.00 5,285,000.00 1,267,705.00 ++ South Bend Building Corporation Morris PAC 1998 2009 2017 408 2/1 8/1 - - 13,300,000.00 4,270,000.00 890,000.00 148,325.00 0.00 3,380,000.00 1,038,325.00 12 TJX Special Taxing District 2002 2022 324/404/414 1/1 7/1 - - 6,620,000.00 3,750,000.00 345,000.00 166,512.50 0.00 3,405,000.00 511,512.50 s Downtown Central Area TIF 2003 2011 2024 420 2/1 8/1 - - 19,795,000.00 17,230,000.00 1,110,000.00 805,754.50 0.00 16,120,000.00 1,915,754.50 s Airport Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14,420,000.00 9,830,000.00 635,000.00 459,614.50 0.00 9,195,000.00 1,094,614.50 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1 - - 5,485,000.00 4,660,000.00 195,000.00 293,847.50 0.00 4,465,000.00 488,847.50 s4 Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36,000,000.00 34,950,000.00 900,000.00 1,933,068.00 0.00 34,050,000.00 2,833,068.00 a+ Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4,980,000.00 4,115,000.00 595,000.00 180,670.00 0.00 3,520,000.00 775,670.00 95 SB Economic Develop Revenue Bonds Career Academy 2011 2014 324 2/15 5/15 8/15 11/15 1,500,000.00 1,000,000.00 500,000.00 32,500.00 0.00 500,000.00 532,500.00 Total Bond Debt 137,720,000.00 89,330,000.00 7,340,000.00 4,242,977.00 0.00 81,990,000.00 11,582,977.00 Loans Payable u State Revolving Fund (Refunding) Sewage Works Improvement 1998 2018 649 6/1 12/1 - - 24,095,000.00 9,445,000.00 0.00 0.00 (9,445,000.00) 0.00 0.00 za State Revolving Fund Water Works Improvements 2000 2019 625 1/1 7/1 - - 2,600,000.00 1,172,267.00 153,452.00 3,396.00 0.00 1,018,815.00 156,848.00 2 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 538,508.13 56,486.72 15,523.72 0.00 482,021.41 72,010.44 a Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 148,826.03 0.00 0.00 0.00 148,826.03 0.00 2 State Industrial Development Fund Bosch Property 2002 2017 210 4/1 10/1 - - 1,000,000.00 346,146.00 76,924.00 9,807.00 0.00 269,222.00 86,731.00 +4 Indiana Development Finance Authority Frederickson Park 2003 2012 404 3/31 6/30 9/30 12/31 764,809.60 0.00 0.00 0.00 0.00 0.00 0.00 15 Indiana Development Finance Authority Frederickson Park (Forgive) 2003 2012 404 - - - - 191,202.40 0.00 0.00 0.00 0.00 0.00 0.00 is Indiana Development Finance Authority Anchor 2005 2014 404 6/30 12/31 - - 600,000.00 133,333.38 66,666.66 2,916.67 0.00 66,666.72 69,583.33 n Indiana Development Finance Authority Anchor (Forgive) 2005 2014 404 6/30 12131 - - 75,000.00 21,428.60 0.00 0.00 0.00 21,428.60 0.00 so HUD Section 108 #8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4,000,000.00 1,805,000.00 800,000.00 73,949.00 0.00 1,005,000.00 873,949.00 62 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 430,651.43 82,056.47 25,519.53 0.00 348,594.96 107,576.00 u lnterfund Fund 412 -Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,040,319.00 959,191.00 35,362.00 47,523.00 0.00 923,829.00 82,885.00 as lnterfund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31,032.00 19,395.00 3,879.00 0.00 0.00 15,516.00 3,879.00 m lnterfund Fund 412 - Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2,000,000.00 1,460,723.00 0.00 0.00 53,196.87 1,513,919.87 0.00 as lnterfund Fund 412 -Major Moves Eddy Street Commons 2011 2026 436 2115 8/15 - - 4,100,000.00 3,655,302.57 203,651.54 188,124.46 0.00 3,451,651.03 391,776.00 as lnterfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2026 324 8/9 - - - 500,000.00 500,000.00 0.00 0.00 0.00 500,000.00 0.00 as Blackthorn Loan from Airport xxx Blackthorn Equip (mowers) 2011 2018 619 5115 6/15 7/15 8/15 53,598.50 40,198.82 6,699.84 0.00 0.00 33,498.98 6,699.84 Total Loans Payable 48,753,511.06 20,675,970.96 1,485,178.23 366,759.38 9,391,803.13 9,798,989.60 1,851,937.61 Capital Lease 75 PNC Equipment Financing Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 156,390.02 49,587.52 6,833.48 0.00 106,802.50 56,421.00 Total Capital Lease 246,509.64 156,390.02 49,587.52 6,833.48 0.00 106,802.50 56,421.00 Leases r Transpo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3,000,000.00 541,719.00 170,009.00 29,991.00 0.00 371,710.00 200,000.00 +2 Transpo Lease Main / Colfax Garage 2006 2025 404 3/15 9/15 - - 2,510,278.00 1,895,063.00 106,562.00 93,438.00 0.00 1,788,501.00 200,000.00 Total Lease 5,510,278.00 2,436,782.00 1 276,571.00 1 123,429.00 0.00 1 2,160,211.00 400,000.00 Total Redevelopment Commission 192,230,298.70 112,599,142.98 1 9,151,336.75 1 4,739,998.86 (9,391,803.13) 94,056,003.10 13,891,335.61 Total Debt 438,334,093.51 270,850,258.85 20,802,347.81 10,008,323.84 841,293.85 249,206,617.19 30,810,671.65 .J* 2011xls - Ded P.V 22 d28 City of South Bend Monthly Debt Schedule Period Ending: July 2013 Year of Year of Year of Scheduled Payments Debt (Orig /Refl) Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Pur ose Issue Refundin Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2012 Pa ments Payments Additions 713112013 Civil City Debt Bond Debt amwl5en g at CEDIT Bond 1997 2006 2017 408 2/1 811 - - 11,870,000.00 3,535,000.00 720,000.00 154,213.75 0.00 2,815,000.00 sa South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 811 - - 9,250,000.00 4,890,000.00 250,000.00 87,388.00 0.00 4,640,000.00 zs Water Works Improvements Water Works 2002 2012 2023 625 7/1 12/31 - - 5,975,000.00 3,785,000.00 0.00 44,578.89 0.00 3,785,000.00 sa South Bend Building Corporation Fire HQ/ Police HQ 2003 2012 2023 404/324 2/1 8/1 - - 21,335,000.00 13,595,000.00 685,000.00 169,203.17 0.00 12,910,000.00 41 Sewage Works Improvements Sewage Works 2004 2024 649 6/1 12/1 - - 11,425,000.00 7,980,000.00 0.00 0.00 (7,980,000.00) 0.00 24 Water Works Improvements Water Works 2006 2027 625 7/1 12/31 - - 4,710,000.00 3,700,000.00 0.00 81,863.00 0.00 3,700,000.00 42 Sewage Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7,630,000.00 6,425,000.00 0.00 141,236.25 0.00 6,425,000.00 4o Sewage Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16,600,000.00 13,670,000.00 0.00 294,973.75 0.00 13,670,000.00 sz Sewage Works Revenue Bonds 2007B Sewage Works 2007 2027 649 611 12/1 - - 16,515,000.00 13,615,000.00 0.00 288,870.63 0.00 13,615,000.00 ez Century Center Special Tax Bonds Century Center 2008 2028 420 511 11/1 - - 4,655,000.00 4,165,000.00 175,000.00 109,466.00 0.00 3,990,000.00 eg Water Works Improvements Water Works 2009 2030 625 7/1 12/31 - - 5,380,000.00 5,185,000.00 0.00 139,216.00 0.00 5,185,000.00 7o Sewage Works Revenue Bonds -2009 Sewage Works 2009 2028 649 611 12/1 - - 3,297,000.00 2,822,021.00 0.00 40,131.00 34,302.00 2,856,323.00 so 2010 Sewage Works Revenue Bonds Sewage Works 2010 2030 649 611 12/1 - - 9,345,000.00 8,630,000.00 0.00 158,985.56 0.00 8,630,000.00 sa Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 611 12/1 - - 21,500,000.00 20,740,000.00 0.00 378,825.00 0.00 20,740,000.00 sa 2012 Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8,300,000.00 8,300,000.00 0.00 243,877.54 0.00 8,300,000.00 tot 2012 Sewage Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25,000,000.00 25,000,000.00 0.00 265,477.33 0.00 25,000,000.00 ios 2013A Sewer Bond Refunding m Sewage Works 2013 2013 2024 649 6/1 1211 - - 14,765,000.00 0.00 0.00 0.00 14,765,000.00 14,765,000.00 Total Bond Debt 220,052,000.00 146,037,021.00 1,830,000.00 2,598,305.87 6,819,302.00 151,026,323.00 Loans Payable t State Revolving Fund Bosch Properly 2002 2022 210 1/30 4/30 7/30 10/30 506,448.00 362,337.59 23,156.88 10,640.10 0.00 339,180.71 ea State Revolving Fund Water Works Improvement 2009 2030 625 711 12/31 - - 427,332.00 409,613.00 0.00 6,901.98 0.00 409,613.00 az Interfund Loan 410 - UDAG xxx 1st 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 Total Loans Payable 8,838,780.00 2,799,923.59 23,156.88 17,542.08 0.00 2,776,766.71 Capital Leases n 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 st Chase LED Equipment 2007 2017 101 1/1 7/1 - - 1,531,573.00 894,298.74 164,040.33 36,539.33 0.00 730,258.41 ss Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 963,508.00 102,062.12 102,062.08 1,918.77 0.00 0.04 se Oce Copier 209 N Main 2008 2013 620 Monthly - - - 12,078.21 1,373.87 1,373.87 24.73 0.00 0.00 57 Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 586.30 586.30 10.52 0.00 0.00 se Lanier Copier 915 Olive 2008 2013 620 Monthly - - - 5,154.00 586.30 586.30 10.52 0.00 0.00 ss Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 408.66 408.66 6.29 0.00 0.00 e7 Sun Trust Solid Waste Containers/Trucks 2009 2014 611 3/1 9/1 - - 720,990.00 230,257.00 75,346.02 4,271.27 0.00 154,910.98 7t Kansas State Bank Clerk Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,209.00 3,091.43 1,824.19 124.22 0.00 1,267.24 72 Kansas State Bank Cade Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10/23 9,209.00 4,497.64 1,413.32 235.60 0.00 3,084.32 73 Kansas State Bank Engineering Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,391.00 3,152.53 1,860.24 126.69 0.00 1,292.29 74 CSI Leasing Inc IT Netapp San 2010 2014 404 4/1 7/1 10/1 12/31 207,521.37 69,136.85 27,047.16 1,846.84 0.00 42,089.69 76 Kansas State Bank Central Services Copier 2010 2015 222 2/16 5/16 8/16 11/16 13,366.40 7,066.14 1,331.96 198.04 0.00 5,734.18 77 GE Capital information Technology Animal Control Copier 2010 2015 101 2/28 5/30 8/30 11/30 3,550.69 1,880.04 353.66 54.04 0.00 1,526.38 7e Kansas State Bank Mayor Oce Copier 2010 2015 101 1/8 4/8 7/8 10/8 9,209.00 5,395.33 1,359.83 289.09 0.00 4,035.50 78 Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10,511.02 6,757.73 1,525.18 421.34 0.00 5,232.55 V Public Finance.com Inc Solid Waste Containers/Trucks 2011 2015 611 6/15 12/15 - - 321,853.00 196,824.94 31,538.41 3,094.09 0.00 165,286.53 s9 Sun Police, Parks, Bldg vehicles 2011 2016 4041201/600 3/15 6/15 9/15 12/15 2,068,202.00 1,468,556.77 203,770.13 13,712.57 0.00 1,264,786.64 ,Trust so Capital One Public Funding Solid Waste Containers/Trucks 2011 2016 611 3/15 6/15 9/15 12/15 207,432.00 157,040.69 20,377.73 1,265.05 0.00 136,662.96 st GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 2,812.10 555.77 110.77 0.00 2,256.33 sz Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 1,111,166.74 267,571.17 27,828.24 0.00 843,595.57 9a Ikon Office Solutions Mayor Ricoh MP 2851 SP Copier 2011 2016 101 2/15 5/15 8/15 11/15 2,569.53 2,102.03 237.53 56.71 0.00 1,864.50 9s Sun Trust Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 302,832.89 42,231.71 2,429.53 0.00 260,601.18 97 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 1 1/1 5 - - 1,295,000.00 1,171,344.99 125,800.14 9,925.50 0.00 1,045,544.85 sa PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/640 5/15 11/15 - - 945,674.38 854,300.45 92,100.81 6,428.61 0.00 762,199.64 too PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15 - - 2,806,054.00 2,806,054.00 548,998.45 31,952.89 0.00 2,257,055.55 ioz Ikon Office Solutions/ Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 5,325.70 603.77 167.35 0.00 4,721.93 tea GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11/28 5,471.01 5,259.30 510.52 124.88 0.00 4,748.78 too Ricoh USA Central Services Copier 2013 2018 222 2/27 5/27 8/27 11/27 3,622.78 0.00 303.07 116.81 3,622.78 3,319.71 107 Ricoh USA Street/Sewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 0.00 559.21 76.19 5,559.15 4,999.94 toe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5/12 8/12 11/12 5,559.15 0.00 559.13 76.27 5,559.15 5,000.02 too Ricoh USA Parks & Rec Ricoh Copiers(3) 2013 2018 201 2/21 5/21 8121 11/21 16,129.94 0.00 1,622.48 221.14 16,129.94 14,507.46 tto PNC Equipment Finance Vehicle /Equipment Lease 2013 2018 101/202/406/641 1/15 7/15 - - 1,689,669.59 0.00 0.00 0.00 1,689,669.59 1,689,669.59 ttt Ricoh USA x�ar Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,666.67 0.00 575.63 72.37 10,666.67 10,091.04 Total Capital Lease 17,213,014.81 9,414,171.28 1,719,034.76 143,736.26 1,731,207.28 9,426,343.80 Total Civil City 246,103,794.81 158,251,115.87 3,572,191.84 2,759,584.21 8,550,509.28 163,229,433.51 rr JWy 1011xls - De& Page 23 &28 City of South Bend Monthly Debt Schedule Period Ending: July 2013 Year of Year of Year of Scheduled Payments Debt (Orig /Refi) Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refundin Maturity Fund 1st 2nd 3rd 4th Issue 12/31/2012 Pa ments Payments Additions 713112013 Redevelopment Commission Debt Bond Debt 9 Central Business TIF 1990 1996 2012 420 2/1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 +o Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 620,000.00 620,000.00 14,880.00 0.00 0.00 z Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1 - - 6,825,000.00 2,505,000.00 215,000.00 28,625.00 0.00 2,290,000.00 e College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15,370,000.00 6,400,000.00 555,000.00 78,017.50 0.00 5,845,000.00 ++ South Bend Building Corporation Morris PAC 1998 2009 2017 408 2/1 8/1 - - 13,300,000.00 4,270,000.00 440,000.00 77,462.50 0.00 3,830,000.00 12 TJX Special Taxing District 2002 2022 324/404/414 1/1 7/1 - - 6,620,000.00 3,750,000.00 0.00 83,256.25 0.00 3,750,000.00 s Downtown Central Area TIF 2003 2011 2024 420 2/1 8/1 - - 19,795,000.00 17,230,000.00 550,000.00 408,542.25 0.00 16,680,000.00 s Airport Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14,420,000.00 9,830,000.00 315,000.00 233,051.75 0.00 9,515,000.00 zz Erskine Village TIF Development Bond Erskine Village 2005 2027 432 211 8/1 - - 5,485,000.00 4,660,000.00 195,000.00 149,897.50 0.00 4,465,000.00 se Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36,000,000.00 34,950,000.00 400,000.00 970,534.00 0.00 34,550,000.00 s+ Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4,980,000.00 4,115,000.00 595,000.00 180,670.00 0.00 3,520,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 1,000,000.00 250,000.00 18,750.00 0.00 750,000.00 Total Bond Debt 137,720,000.00 89,330,000.00 4,135,000.00 2,243,686.75 0.00 85,195,000.00 Loans Payable u State Revolving Fund Sewage Works Improvement 1998 2018 649 6/1 12/1 - - 24,095,000.00 9,445,000.00 0.00 0.00 (9,445,000.00) 0.00 za State Revolving Fund Water Works Improvements 2000 2019 625 7/1 12/31 - - 2,600,000.00 1,172,267.00 149,128.00 36,158.00 0.00 1,023,139.00 3 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 538,508.13 28,032.33 7,972.89 0.00 510,475.80 a Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 148,826.03 0.00 0.00 0.00 148,826.03 z State Industrial Development Fund Bosch Property 2002 2017 210 4/1 10/1 - - 1,000,000.00 346,146.00 38,462.00 5,192.00 0.00 307,684.00 +4 Indiana Development Finance Authority Frederickson Park 2003 2012 404 3/31 6/30 9/30 12/31 764,809.60 0.00 0.00 0.00 0.00 0.00 1s 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 12/31 - - 600,000.00 133,333.38 33,333.33 1,666.67 0.00 100,000.05 n Indiana Development Finance Authority Anchor (Forgive) 2005 2014 404 - - - - 75,000.00 21,428.60 0.00 0.00 0.00 21,428.60 so HUD Section 108 #8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4,000,000.00 1,805,000.00 0.00 36,974.50 0.00 1,805,000.00 63 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 430,651.43 43,021.71 10,766.29 0.00 387,629.72 se lnterfund Fund 412 -Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,040,319.00 959,191.00 17,463.00 23,980.00 0.00 941,728.00 as lnterfund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31,032.00 19,395.00 1,939.50 0.00 0.00 17,455.50 m lnterfund Fund 412 - Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2,000,000.00 1,460,723.00 0.00 0.00 53,196.87 1,513,919.87 as lnterfund Fund 412 - Major Moves Eddy Street Commons 2011 2026 436 2/15 8/15 - - 4,100,000.00 3,655,302.57 100,568.66 95,319.34 0.00 3,554,733.91 as lnterfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2026 324 8/9 - - - 500,000.00 500,000.00 0.00 0.00 0.00 500,000.00 as Blackthorn Loan from Airport xxx Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53,598.50 40,198.82 3,349.92 0.00 0.00 36,848.90 Total Loans Payable 48,753,511.06 20,675,970.96 415,298.45 218,029.69 9,391,803.13 10,868,869.38 Capital Lease 75 PNC Equipment Financing Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 156,390.02 23,773.96 4,436.54 0.00 132,616.06 Total Capital Lease 246,509.64 156,390.02 23,773.96 4,436.54 0.00 132,616.06 Leases r Transpo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3,000,000.00 541,719.00 83,748.00 16,252.00 0.00 457,971.00 +3 Transpo Lease Main / Colfax Garage 2006 2025 404 3/15 9/15 - - 2,510,278.00 1,895,063.00 52,623.00 47,377.00 0.00 1,842,440.00 Total Lease 5,510,278.00 2,436,782.00 1 136,371.00 1 63,629.00 0.00 1 2,300,411.00 Total Redevelopment Commission 192,230,298.70 112,599,142.98 4,710,443.41 2,529,781.98 (9,391,803.13) 98,496,896.44 Total Debt 438,334,093.51 270,850,258.85 8,282,635.05 5,289,366.19 (841,293.85) 261,726,329.95 .J*1013.x -Ded Page N ar28 City of South Bend Staffing Headcount Summary Budget Prior Full Time I Jan Feb Mar I Apr I May Jun Jul Aug Sep Oct Nov Dec Year End Full Time Staff 1160.00 1124.00 1122.00 1126.00 1136.00 1125.00 1125.00 1130.00 0.00 0.00 0.00 0.00 0.00 1133.00 Part Time Staff 71.00 76.00 75.00 76.00 78.00 76.00 82.00 0.00 0.00 0.00 0.00 0.00 0.00 Temporary/ Seasonal 107.00 96.00 136.00 181.00 244.00 339.00 348.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 1302.00 1294.00 1337.00 1393.00 1447.00 1540.00 1560.00 0.00 0.00 0.00 0.00 0.00 1133.00 Financial Report July 2013.xis - Headcount Staffing Page 25 of 29 City of South Bend Staffing Headcount Full Time Staff Administration 11.00 Amended 11.00 11.00 11.00 11.00 11.00 11.00 0.00 0.00 0.00 0.00 0.00 13.00 Maintenance 45.00 44.00 Budget 43.00 44.00 44.00 44.00 44.00 0.00 0.00 0.00 0.00 0.00 44.00 Golf Operations Prior 10.00 10.00 FT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year End General Government 25.00 25.00 25.00 25.00 25.00 0.00 0.00 0.00 0.00 0.00 23.00 Zoological Ops 23.00 21.00 20.00 20.00 Mayor 7.00 5.00 5.00 6.00 7.00 7.00 7.00 6.00 0.00 0.00 0.00 0.00 0.00 7.00 0.00 311 Call Center 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 Admin & Finance 21.00 19.00 19.00 19.00 19.00 19.00 20.00 20.00 0.00 0.00 0.00 0.00 0.00 18.00 1.00 Safety & Risk 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 3.00 112.00 Clerk 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 5.00 Common Council 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 0.00 0.00 0.00 0.00 0.00 9.00 Legal 10.00 8.00 7.00 8.00 9.00 10.00 10.00 10.00 0.00 0.00 0.00 0.00 0.00 9.00 Sub Total 60.00 54.00 53.00 55.00 57.00 58.00 59.00 58.00 0.00 0.00 0.00 0.00 0.00 51.00 Code Enfor. /Animal Control Organic Resources 26.00 26.00 25.00 25.00 25.00 25.00 24.00 25.00 0.00 0.00 0.00 0.00 0.00 25.00 Dept. of Community Investment Water Utility Ops 26.00 24.00 25.00 26.00 25.00 24.00 24.00 24.00 0.00 0.00 0.00 0.00 0.00 25.00 Parks & Recreation Sub Total 305.00 299.00 301.00 300.00 300.00 296.00 298.00 297.00 0.00 0.00 0.00 0.00 0.00 299.00 Administration 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 0.00 0.00 0.00 0.00 0.00 13.00 Maintenance 45.00 44.00 43.00 43.00 44.00 44.00 44.00 44.00 0.00 0.00 0.00 0.00 0.00 44.00 Golf Operations 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 0.00 0.00 0.00 0.00 0.00 11.00 Recreation Opsl 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 0.00 0.00 0.00 0.00 0.00 23.00 Zoological Ops 23.00 21.00 20.00 20.00 20.00 19.00 19.00 20.00 0.00 0.00 0.00 0.00 0.00 22.00 Greenhouse Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 Recreation Nonreverling 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 116.00 113.00 111.00 111.00 112.00 111.00 111.00 112.00 0.00 0.00 0.00 0.00 0.00 114.00 Public Safety Financial Report July 2013.xis - Headcount Staffing Page 26 of 29 Police 297.00 292.00 290.00 290.00 289.00 284.00 284.00 290.00 0.00 0.00 0.00 0.00 0.00 293.00 Communications 38.00 34.00 35.00 38.00 38.00 38.00 36.00 35.00 0.00 0.00 0.00 0.00 0.00 35.00 Fire 257.00 249.00 249.00 247.00 256.00 255.00 255.00 255.00 0.00 0.00 0.00 0.00 0.00 258.00 Sub Total 592.00 575.00 574.00 575.00 583.00 577.00 575.00 580.00 0.00 0.00 0.00 0.00 0.00 586.00 Public Works Central Services 44.00 42.00 42.00 42.00 41.00 40.00 41.00 42.00 0.00 0.00 0.00 0.00 0.00 41.00 Engineering 15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00 0.00 0.00 0.00 0.00 0.00 17.00 Maintenance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.00 Solid Waste Operations 28.00 28.00 28.00 28.00 28.00 28.00 28.00 27.00 0.00 0.00 0.00 0.00 0.00 23.00 Street Operations 60.00 58.00 59.00 60.00 60.00 57.00 59.00 59.00 0.00 0.00 0.00 0.00 0.00 58.00 Sewer Operations 35.00 34.00 34.00 34.00 34.00 34.00 33.00 33.00 0.00 0.00 0.00 0.00 0.00 34.00 Waste Water Ops 47.00 46.00 46.00 46.00 46.00 46.00 46.00 46.00 0.00 0.00 0.00 0.00 0.00 49.00 Organic Resources 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Utility Ops 70.00 70.00 71.00 69.00 70.00 70.00 70.00 69.00 0.00 0.00 0.00 0.00 0.00 74.00 Sub Total 305.00 299.00 301.00 300.00 300.00 296.00 298.00 297.00 0.00 0.00 0.00 0.00 0.00 299.00 Building Code 15.00 13.00 13.00 14.00 14.00 14.00 14.00 14.00 0.00 0.00 0.00 0.00 0.00 13.00 Human Rights 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 6.00 Morris & Palais 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 0.00 0.00 0.00 0.00 0.00 14.00 Financial Report July 2013.xis - Headcount Staffing Page 26 of 29 City Total 1160.00 1124.00 1122.00 1126.00 1136.00 1125.00 1125.00 1130.00 0.00 0.00 0.00 0.00 0.00 1133.00 Financial Report July 2013.xis - Headcount Staffing Page 27 of 29 City of South Bend Staffing Headcount Part Time Staff General Government Code Enf. /Animal Control Dept. of Community Investment Parks & Recreation Public Safety Public Works Building Code Human Rights Morris & Palais Prior Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year End Mayor Admin & Finance 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 Clerk Common Council Legal Department 2.00 2.00 2.00 2.00 2.00 2.00 4.00 0.00 0.00 0.00 0.00 0.00 5.00 Sub Total 3.00 3.00 3.00 3.00 3.00 3.00 5.00 0.00 0.00 0.00 0.00 0.00 5.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 2.00 1.00 1.00 1.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 2.00 Administration 5.00 5.00 5.00 4.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 7.00 Maintenance 3.00 3.00 4.00 4.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 3.00 Golf Operations 0.00 4.00 2.00 2.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 31.00 31.00 31.00 32.00 31.00 30.00 32.00 0.00 0.00 0.00 0.00 0.00 33.00 Zoological Ops 6.00 6.00 8.00 8.00 8.00 9.00 9.00 0.00 0.00 0.00 0.00 0.00 5.00 Greenhouse Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 45.00 49.00 50.00 50.00 52.00 52.00 54.00 0.00 0.00 0.00 0.00 0.00 48.00 Police 5.00 5.00 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 3.00 Communications 0.00 Fire 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 Sub Total 6.00 6.00 4.00 4.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 4.00 Central Services 1.00 0.00 Engineering 3.00 3.00 3.00 3.00 3.00 3.00 4.00 0.00 0.00 0.00 0.00 0.00 2.00 Traffic & Lighting 0.00 Maintenance 0.00 Solid Waste Ops 3.00 3.00 3.00 3.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 1.00 Street Ops 4.00 4.00 4.00 4.00 5.00 4.00 5.00 0.00 0.00 0.00 0.00 0.00 4.00 Sewer Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 Water Utility Ops 0.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 Sub Total 10.00 11.00 11.00 11.00 12.00 10.00 12.00 0.00 0.00 0.00 0.00 0.00 9.00 0.00 0.00 4.00 4.00 4.00 4.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 4.00 City Total 76.00 75.00 76.00 78.00 76.00 82.00 0.00 0.00 0.00 0.00= 0.00 74.00 Financial Report July 2013.xis - Headcount Staffing Page 28 of 29 City of South Bend Staffing Headcount Temporay & Seasonal Staff Public Works Central Services 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 Prior 0.00 0.00 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Year End General Government 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 Mayor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.00 3.00 Admin & Finance 2.00 3.00 3.00 3.00 5.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 5.00 Clerk 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6.00 Common Council 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Legal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 2.00 3.00 3.00 3.00 5.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 4.00 Code Enforcement 0.00 0.00 0.00 0.00 1.00 3.00 3.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 0.00 0.00 2.00 Sub Total 12.00 13.00 12.00 15.00 26.00 39.00 38.00 0.00 0.00 0.00 Parks & Recreation 0.00 23.00 Administration 5.00 5.00 6.00 8.00 8.00 7.00 6.00 0.00 0.00 0.00 0.00 0.00 3.00 Maintenance 11.00 4.00 8.00 23.00 34.00 42.00 45.00 0.00 0.00 0.00 0.00 0.00 8.00 Golf Operations 2.00 1.00 28.00 39.00 47.00 50.00 51.00 0.00 0.00 0.00 0.00 0.00 3.00 Recreation Ops 44.00 39.00 31.00 44.00 50.00 140.00 143.00 0.00 0.00 0.00 0.00 0.00 55.00 Zoological Ops 2.00 2.00 21.00 21.00 32.00 36.00 42.00 0.00 0.00 0.00 0.00 0.00 4.00 Greenhouse Ops 0.00 Graffiti Removal 1.00 1.00 2.00 2.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 Sub Total 65.00 52.00 96.00 137.00 172.00 276.00 288.00 0.00 0.00 0.00 0.00 0.00 74.00 Public Safety Police 27.00 27.00 24.00 24.00 36.00 15.00 15.00 0.00 0.00 0.00 0.00 0.00 24.00 Communications 0.00 Fire 0.00 0.00 0.00 0.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 Sub Total 27.00 27.00 24.00 24.00 37.00 1 6.00 16.00 0.00 0.00 0.00 0.00 0.00 24.00 Public Works Central Services 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 0.00 0.00 0.00 0.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 Traffic & Lighting 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Ops 3.00 3.00 3.00 3.00 6.00 10.00 10.00 0.00 0.00 0.00 0.00 0.00 10.00 Street Ops 2.00 3.00 2.00 5.00 5.00 9.00 9.00 0.00 0.00 0.00 0.00 0.00 2.00 Sewer Ops 7.00 7.00 7.00 6.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 7.00 Leaf Pickup 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 1.00 4.00 3.00 0.00 0.00 0.00 0.00 0.00 1.00 Organic Resources 0.00 0.00 0.00 1.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 Water Utility Ops 0.00 0.00 0.00 0.00 3.00 4.00 3.00 0.00 0.00 0.00 0.00 0.00 2.00 Sub Total 12.00 13.00 12.00 15.00 26.00 39.00 38.00 0.00 0.00 0.00 0.00 0.00 23.00 Building Code Human Rights Morris & Palais 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 107.00 96.00 136.00 181.00 244.00 339.00 348.00 0.00 0.00 0.00 0.00 00.00 125.00 Financial Report July 2013.xis - Headcount Staffing Page 29 of 29