Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
12-2013 Financial Report
Period Ending: Issued BY: December 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 Deputy Chief of Staff Controller City Finance Director Financial Specialist Senior Department Heads Fiscal Officers City Common Council Pete Buttigieg Kathryn Roos Brian Pawlowski John Murphy Rahman Johnson Cecil Eastman Financial Report December 2013 Page 1 of 28 December 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 88 %. In comparison, the collected revenue amount for December 2012 was 99% overall of budgeted revenues The following revenue types have surpassed their 2013 budgeted revenue amount: Revenue type 340 (ND EMS Service) is over by 189% ($80,113). 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 571% ($235,704). 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 $72,551 or 390 %. This program has been well received by homeowners who want to improve their property with new curb and sidewalk. Revenue type 334 (Grants) is over by 2,235% ($170,820). During the month of July, 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 type 391 (Sale of fixed assets) is over by 2,205% ($73,668) as a result of the City's annual auction held at our Central Services Facility. After auctioneer fees, net proceeds totaled $76,268. Revenue by fund As of December 2013, the general fund has received 98% of its budgeted revenue versus 99% last year. Some following funds have surpassed their 2013 budgeted revenue amount: Fund 643 (Sewage Reserve) is over by 166% ($84,234). 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. Total property taxes collected for the year 2012 was $72.9 million or 91.56% of the levy collection rate. For 2013, the projected levy collection rate is 95 %. The first distribution amount received was in June 2013 for $38.4 million compared to $39.5 million in June 2012. The second distribution amount was received in December 2013, in the amount of $31.5 million compared to $33.3 million in December 2012. Specifically, in 2013 the City of South Bend received a total of $45,189,966.17 in property tax revenue in the civil city funds (general fund, parks, College Football Hall of Fame, and CCD). This is a shortfall of -$3.7 million compared to 2012, in which $48.8 million was received. For TIF funds, the City received a total of $24,790,321.99 in property tax revenue. This is a surplus of $729,194 as compared to 2012, in which $24,061,128 was received. Overall, total property taxes collected in 2013 is -$70.0 million, which is a net reduction of $2.9 million from 2012. Expenditures As of December 2013, the City has spent 76% of budgeted expenditures compared to 80% of budgeted expenditures in December 2012. The General Fund has spent 96% of its 2013 budgeted expenditures, compared to 95% in 2012. The following funds have reached their budgeted expenditures as a result of bond payments: Fund 313 (Hall of Fame), fund 407(Cumulative Capital Improvement), fund 377 ( Professional Sports Development), fund 432 (TIF - Erskine Village), fund 664 (2013A Sewer Bond), and fund434 (CRED). At this time, $415,000 from fund 404 (COIT) has been appropriated to fund 434 (CRED). This was approved by the South Bend Common Council in early December. This year, a possible miscalculation from the State caused a distribution shortfall. The money will be reimbursed back to the COIT fund if possible early next year. Debt In December, several debt service payments were made in the amount of - $6.8 million to Bank of New York, Sun Trust, Kansas State Bank, PNC Bank, U.S. Bank and Ricoh USA. Payments are related to IT equipment leases, police / public works vehicles, solid waste containers, and sewer bonds. In October, the City made its final debt payment in the amount of $312,299 to the State Industrial Development Fund for the Bosch property. Also in October, the City added -$5.6 million new debt with the 2013 Building Corporation for the new EMS / Fire Department. Headcount The Full Time Headcount as of December 31, 2013 was 1,131 vs. a budgeted amount of 1,160. Currently, there is a total of 29 open positions. The open positions are in Parks (3), Public Safety (13), Public Works (8), and other (5). City of South Bend Period Ending: December 2013 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et Property Tax 312 Auto Excise Tax various 1,480,802 299 311 Property Tax Civil City various 2,434,362 122% 312 Commercial Vehicle Tax various 74,475 24,741,157 8,607 13,236 160,829 442,706 885,412 20,447,810 45,188,966 48,448,460 93% 311 Pro a Tax TIF Districts various 610 9,724 575 164,319 7,733 13,672,367 317 Hotel Motel Tax Century Center 670 656,718 181,171 656,718 11,118,955 24,791,322 23,751,000 104% 311 Pro a Tax Civil City - Prior various 420 198,500 5,449,495 4,317,309 ntractual Service 200,000 14,469 398,500 398,500 100% 317 Hotel Motel Tax Cum Cap Im ry 407 335 CTP Distribution 439 NA 311 Property Tax TIF Districts - Prior various 150,000 150,000 100% 274,033 287,104 203,718 1,412,953 239,542 _ _ _ _ _ _ _ _ NA NA xxx xxx xxx 41,565 43,743 599,027 42,867 41,528 41,953 NA xxx xxx xxx 100% 335 Gasoline Tax 2021251 247,877 284,905 NA 335,708 Sub Total NA 342 EMS County Contract 101 153,268 132,402 132,402 132,402 132,402 38,413,523 132,402 132,402 132,402 132,402 1,477,288 1,578,277 94% 31,566,765 69,980,288 72,199,460 97% Income Tax 375,407 436,559 380,018 481,541 389,824 NA Sub Total 66,400 656,718 153,268 132,402 330,902 575,108 2,269,922 282,402 132,402 132,402 332,402 132,402 2,055,509 7,185,839 6,758,387 106% 315 Econ Development Income Tax -Prh 102 118,338 53,747 133,849 243,372 198,867 210,000 95% 335 ProfSports Development Tax 377 61,389 54,017 54,274 34,458 93,077 NA 315 Econ Development Income Tax 408 681,446 681,446 681,446 681,446 681,446 681,446 681,446 681,446 681,446 681,446 681,446 681,446 8,177,352 8,177,352 100% 316 Local Option Income Tax -PS 249 491,032 491,032 491,032 491,032 491,032 491,032 491,032 491,032 491,032 491,032 491,032 491,032 5,892,386 5,892,386 100% 316 County Option Income Tax 404 653,912 653,912 653,912 653,912 653,912 653,912 653,912 653,912 653,912 653,912 653,912 653,912 7,846,939 7,846,940 100% 316 County Option Income Tax -Prior Yr 102 NA Sub Total 2,231,334 380,938 609,474 618,706 430,317 6,287,295 346,192 1,123,144 6,138,200 NA 1,931,366 Sub Total 21,962,599 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 1,826,390 21,916,677 21,916,678 100% St Joseph Count Remitted b 312 Auto Excise Tax various 1,480,802 299 312 CREED Tax 1,480,401 2,961,203 2,434,362 122% 312 Commercial Vehicle Tax various 74,475 442,706 8,607 13,236 160,829 442,706 885,412 883,812 100% 312 Financial Institutions Tax various 1011407 3,816 101 610 9,724 575 164,319 7,733 NA 317 Hotel Motel Tax Century Center 670 656,718 181,171 656,718 329,808 105% 335 State Pension Subsidy 1,313,436 1,313,436 100% 317 Hotel Motel Tax Century Center 420 198,500 5,449,495 4,317,309 ntractual Service 200,000 14,469 398,500 398,500 100% 317 Hotel Motel Tax Cum Cap Im ry 407 335 CTP Distribution 439 1,446,074 150,000 6,759 302,740 150,000 150,000 100% 274,033 287,104 203,718 1,412,953 239,542 _ _ _ _ _ _ _ _ NA xxx xxx xxx nd premium 6611623 41,565 43,743 599,027 42,867 41,528 41,953 NA xxx xxx xxx 100% 335 Gasoline Tax 2021251 247,877 284,905 372,655 335,708 337,240 NA 342 EMS County Contract 101 153,268 132,402 132,402 132,402 132,402 132,402 132,402 132,402 132,402 132,402 132,402 1,477,288 1,578,277 94% xxx xxx xxx 370,588 461,654 477,096 24,384 375,407 436,559 380,018 481,541 389,824 NA Sub Total 66,400 656,718 153,268 132,402 330,902 575,108 2,269,922 282,402 132,402 132,402 332,402 132,402 2,055,509 7,185,839 6,758,387 106% State of Indiana Remitted b decal Drug 299 312 CREED Tax 434 7,968 27,926 561 8,734 3,881 74,475 13,224 8,607 13,236 160,829 100,000 244,481 244,481 650,000 38% 335 Ci arette Tax 1011407 3,816 101 610 9,724 575 164,319 7,733 26,972 35,000 yment in Lieu of Tax various 181,171 345,490 329,808 105% 335 State Pension Subsidy 7011702 359,776 359,776 359,776 359,776 359,776 359,776 5,449,495 4,317,309 ntractual Service 5,449,495 14,469 5,688 93,910 10,898,990 10,898,989 100% 335 CTP Distribution 439 1,446,074 18,822 6,759 302,740 291,800 nds various 274,033 287,104 203,718 1,412,953 239,542 2,859,027 2,8591027 100% 335 Gaming Proceeds 101 5,079,387 5,421,277 26,621,279 nd premium 6611623 41,565 43,743 599,027 42,867 41,528 41,953 43,839 599,027 600,000 100% 335 Gasoline Tax 2021251 247,877 284,905 372,655 335,708 337,240 287,713 297,670 458,537 344,646 339,533 352,981 348,529 4,007,993 3,822,432 105% 335 Liquor Excise tax 101 143,575 42,017 370,588 461,654 477,096 24,384 375,407 436,559 380,018 481,541 389,824 643,355 5,466,892 66,400 80,000 83% 335 Liquor Gallonage Tax 101 53,748 357,416 4,363,392 42,850 96% 380 48,522 various 118,338 53,747 133,849 243,372 198,867 210,000 95% 335 ProfSports Development Tax 377 61,389 54,017 54,274 34,458 93,077 94% 392 65,580 101 83,683 269,083 150,633 597,111 600,000 100% 335 Century Center 671 100,000 269,083 269,083 269,083 3,228,996 3,228,996 100% 392 Internal Fund Transfers various 3,543,576 1,023,207 100,000 100,000 100% 335 Wheel Tax 202 322,246 966,095 182,545 205,690 1,415,682 361,384 31,837,780 88% 344,060 167,777 165,432 296,079 2,045,213 1,980,000 103% xxx xxx xxx 1,016,794 1,008,711 996,727 998,075 989,348 1,004,772 12,174,049 12,279,050 99% NA Sub Total 2,231,334 380,938 609,474 618,706 430,317 6,287,295 346,192 1,123,144 6,138,200 644,740 1,931,366 1,220,893 21,962,599 22,130,256 99% governmental Sources decal Drug 299 2,216 Liability Insurance 7,968 27,926 561 8,734 3,881 74,475 13,224 8,607 13,236 160,829 100,000 vte Drug 216 2,988,576 5,124 100% 340 3,816 101 610 9,724 575 599 7,733 26,972 35,000 yment in Lieu of Tax various 359,776 359,776 359,776 359,776 359,776 359,776 359,776 359,776 359,776 359,776 359,776 359,776 4,317,310 4,317,309 ntractual Service 211 14,469 5,688 93,910 3,653 5,580 6,897 76,783 16,362 37,567 16,249 18,822 6,759 302,740 291,800 nds various 274,033 287,104 203,718 85,740 239,542 289,917 325,292 229,008 189,484 256,150 5,079,387 5,421,277 26,621,279 nd premium 6611623 41,565 43,743 42,737 42,867 41,528 41,953 43,839 41,155 42,749 45,244 35,711 47,986 511,075 K XXX 380 Central Service 222 164,610 158,339 205,476 154,014 163,315 144,991 151,451 161,498 152,937 155,455 b Total 143,575 376,462 370,588 461,654 477,096 369,733 375,407 436,559 380,018 481,541 389,824 643,355 5,466,892 10,229,128 31,365,388 Charge for Service Internal City 340 Liability Insurance 226 247,413 247,413 252,318 249,048 249,048 249,048 249,048 249,048 247,413 249,048 250,683 249,048 2,988,576 2,988,576 100% 340 General Government Misc Ch s 101 610 410 599 440 80 5,627 3,838 640 18 12,262 NA 340 Police Take Home Vehicle 278 4,810 4,790 7,140 4,750 4,730 4,680 4,660 7,050 4,790 4,770 4,770 4,780 61,720 63,700 97% 342 EMS Capital 288 152,222 236,226 272,859 274,033 287,104 203,718 226,114 239,542 289,917 325,292 229,008 189,484 2,925,520 2,760,000 106% 349 Central Service 222 41,565 43,743 42,737 42,867 41,528 41,953 43,839 41,155 42,749 45,244 35,711 47,986 511,075 648,228 79% 380 Central Service 222 164,610 158,339 205,476 154,014 163,315 144,991 151,451 161,498 152,937 155,455 119,616 143,575 1,875,276 2,227,398 84% 380 Energy Office Reimbursements 222 349,577 373,748 400,916 424,933 375,278 336,207 375,551 326,894 303,590 407,825 331,458 357,416 4,363,392 4,560,017 96% 380 Internal Service Reimbursement various 118,338 217,335 133,849 243,372 361,836 110,165 148,859 136,250 506,677 260,997 190,705 240,700 2,627,783 2,806,118 94% 392 Administration Fee 101 269,083 269,083 269,083 269,083 269,083 269,083 269,083 269,083 269,083 269,083 269,083 269,083 3,228,996 3,228,996 100% 392 Internal Fund Transfers various 3,543,576 1,023,207 1,783,951 6,232,734 976,509 1,306,404 4,835,492 965,917 966,095 3,045,102 1,894,970 1,415,682 27,989,639 31,837,780 88% 395 Employee Benefits various 1,451,937 601,952 1,022,128 1,032,620 1,027,823 1,023,162 1,016,794 1,008,711 996,727 998,075 989,348 1,004,772 12,174,049 12,279,050 99% Financial Report December 2013 - Revenue Report Page 3 028 City of South Bend Period Ending: December 2013 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et ntral Service Refunds 222 1,577 1,739 1,967 3,080 1,776 5,529 1,674 1,828 3,557 22,726 22,000 If Funded Employee Benefits 711 K XXX b Total 6,345,317 3,177,573 4,392,834 8,928,053 3,759,774 3,691,266 7,326,420 3,412,450 3,781,805 5,764,730 4,315,992 3,926,100 58,822,314 63,421,863 avenue decal Grants various 959,203 417,095 440,882 204,209 202,478 700,426 211,841 142,929 753,839 259,246 674,878 590,981 5,558,006 9,884,592 vte Grants various 178,820 178,820 8,000 IAG 410 448 659 298 345 298 183 137 128 125 125 2,746 I EMS Service 101 44,870 Inspections Central Service 31,631 4,961 3,479 6,414 9,960,307 30 3,603 877 3,157 71,120 170,113 90,000 - morial Hospital Neo Natal 101 12,698 11,638 16,050 113,157 33,334 32,929 35,689 31,631 39,097 37,200 40,305 38,303 442,031 365,000 b Target Penalty Fee 408 13,752 6,056 4,280 354,660 169,617 103% 322 Building Fees 600 88,652 68,472 354,660 354,660 ble TV Franchise Fees 101 73,164 182,109 78,741 92,419 187,926 63,860 951,275 187,431 83% 178,605 EMS Capital 736,071 703,000 AT Franchise Fees 101 1,624 48,974 2,446 1,815 51,758 2,032 1,709 52,656 571 38,141 12,000 191,529 194,000 ss Recovery 227 3,160 4,085 6,309 1,770 3,110 1,985 3,798,548 1,871 835 2,450 2,675 3,804,857 3,804,857 sch Reimbursement /DCI 324 341 General Government Various 90,143 2,073,155 294 1,467 76,417 3,063 155 1,306 4,265 2,239,714 2,239,716 bTotal 2,300 57,569 242,722 144,133 2,545,933 276,497 39,343 3,910,654 271,718 42,700 38,077 260,208 109,424 7,938,975 7,751,233 Fees for Services External decal Grants various 959,203 417,095 440,882 204,209 202,478 700,426 211,841 142,929 753,839 259,246 674,878 590,981 5,558,006 9,884,592 vte Grants various 178,820 178,820 8,000 IAG 410 448 659 298 345 298 183 137 128 125 125 2,746 67,715 K XXX Inspections Central Service 222 b Total 959,651 417,754 440,882 204,506 202,823 700,724 390,844 143,066 753,967 259,371 675,003 590,981 5,739,572 9,960,307 Fees for Services External 320 Inspections Central Service 222 510 10 30 10 10 10 40 620 1,150 54% 321 Business License 1011222 31,365 26,453 24,240 21,556 7,391 9,293 8,127 7,415 16,378 13,752 6,056 4,280 174,961 169,617 103% 322 Building Fees 600 88,652 68,472 84,066 74,583 82,269 68,674 73,164 102,504 78,741 92,419 73,871 63,860 951,275 1,147,035 83% 322 EMS Capital 288 1,666 2,673 979 1,624 1,635 2,446 1,815 2,241 2,032 1,709 2,506 571 21,897 12,000 182% 322 General Government Fees 101 3,160 4,085 1,145 1,770 3,110 1,985 1,970 1,871 835 2,450 2,675 930 25,986 13,000 200% 341 General Government Various various 982 294 1,467 640 3,063 155 1,306 4,265 1,280 1,150 772 2,300 17,674 107,255 16% 342 Highway &Streets 1011202 155,183 43,238 29,026 43,608 9,590 10,677 31,335 1,838 324,494 202,000 161% 342 Public Safety various 25,912 12,212 25,556 12,102 7,398 4,381 16,568 5,302 5,481 12, 762 4,749 5,173 137,595 284,084 48% 343 Highway & Streets 202 - - - - - - - - - - - - - - NA 344 Solid Waste 610 394,808 396,586 398,932 398,295 401,886 404,208 400,738 403,954 403,775 401,652 397,953 397,666 4,800,453 4,766,995 101% 344 Code Environmental Clean Up 101 13,797 8,889 5,947 6,492 3,312 7,041 3,554 4,590 9,546 6,315 4,841 6,981 81,305 50,000 163% 344 Sewage Waste Water 641 2,366,557 2,488,497 2,623,876 2,630,897 2,644,550 2,700,171 2,690,426 2,806,436 2,711,553 2,759,634 2,683,143 2,589,454 31,695,195 33,033,547 96% 344 Sewer Repair Insurance 640 44,566 45,535 45,142 45,786 46,435 45,900 45,344 46,842 45,488 45,443 45,682 46,502 548,665 548,000 100% 344 Water Leak Insurance 620 75,340 75,492 80,340 80,179 80,379 80,920 80,440 80,562 81,187 80,853 80,533 80,698 956,921 958,840 100% 346 Water Works Utility 620 96Z371 1, 002, 564 1,026,177 1,014,284 1,03Z511 1,390,261 1,128, 436 1,603,792 1,198, 498 1,645,935 1,029,285 990,824 14,024,937 14,154, 908 99% 346 Solid Waster Misc 610 4,180 4,490 4,770 5,279 4,790 6,820 5,660 6,250 7,250 6,230 5,250 5,440 66,409 48,835 136% 346 Project ReLeaf 655 35,745 35,760 35,928 35,865 36,001 36,222 36,061 36,238 36,414 36,337 36,196 36,260 433,026 429,000 101% 347 Parks& Recreation various 150,151 170,910 148,652 337,563 543,231 582,796 700,478 564,953 334,201 205,566 64,739 131,534 3,934,774 4,746,083 83% 347 Blackthorn Golf Club 619 83,555 43,855 69,388 149,348 227,562 191,052 226,188 252,788 163,418 88,457 27,419 7,001 1,530,031 1,716,303 89% 347 Morris PAC 416 743 11,904 2,976 5,186 38,786 1,164 3,986 3,422 7,265 25,103 100,535 100,000 101% 349 Parking Garage Fees 601 59,217 72,531 69,079 80,015 87,601 60,806 77,271 68,540 68,466 70,130 75,085 52,707 841,449 963,975 87% 349 Code Demolition Board Up 101 474 3,380 4,882 1,062 4,755 1,883 6,242 8,168 1,411 9,345 5,667 1,478 48,747 50,000 97% 349 Parking Century Center 670 11,950 17,187 18,844 13,008 8,797 7,903 3,050 3,290 8,257 9,507 3,008 6,083 110,884 170,125 65% 349 Parking SBCDA 420 3,688 2,288 3,658 1,613 1,320 3,639 1,914 3,229 3,459 2,968 3,095 3,148 34,021 36,000 95% 351 Fines &Fees various 18,250 9,903 28,021 31,874 17,372 13,711 12,518 35,244 24,258 20,810 12,019 14,200 238,181 227,327 105% 352 Forfeits various 101,169 4,914 9,000 150 72,697 5,000 1,000 3,700 3,300 2,200 82,575 285,704 50,000 571% 354 Ordinance Violation various 6,755 2,888 4,739 4,760 5,223 3,283 3,120 4,435 3,735 3,875 3,244 2,364 48,420 46,000 105% 360 Morris PAC various 16,137 61,947 122,896 53,759 156,538 120,543 25,395 1,964 60,873 26,871 48,820 199,216 894,959 884,000 101% 360 Palais Royale various 21,021 12,991 5,701 7,794 22,887 19,107 36,489 24,589 19,134 18,648 13,076 16,755 218,194 207,981 105% 360 Parks& Recreation various 43,263 24,718 2,588 12,023 4,388 13,585 33,088 14,647 10,509 17,267 2,535 13,869 192,479 66,050 291% 360 Police various 1,043 1,076 880 1,551 1,070 1,815 1,507 1,215 5,426 1,747 1,857 730 19,918 74,850 27% 360 TIF various 4,608 4,638 3,406 76,005 3,749 2,989 2,881 2,170 2,699 23,746 2,868 2,386 132,146 184,471 72% 360 COIT 404 17,500 50,406 67,906 36,458 186% 360 Central Services 222 275 1,773 1,588 708 3 78 2,491 1,337 1 944 9,197 8,000 115% Financial Report December 2013 - Revenue Report Page 4 o/28 City of South Bend Period Ending: December 2013 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et 360 Centu Center 670 8,131 7,823 11,039 9,640 9,307 1,024 3,435 1,194 3,529 7,547 8,977 16,713 88,361 145,578 61% 360 Code 101 43 39 70 70 105 221 25 195 191 60 173 1,152 2,000 58% 360 Cumulative Capital Improvement 4061407 1,000 212 XXX 212 NA 360 Dept. Of Community Investment 2111212 46,235 46,375 23,408 21 59,889 170,147 47,859 68,068 415,768 552,901 75% 360 Stud. /Oliver Rev. Grants 209 NA 360 EMS Capital 288 67 78 84 250 1,179 1,658 16,000 10% 360 Engineering/ Curb & Sidewalk 101 938 1,029 2,913 609 738 475 444 517 502 292 283 108 8,848 22,000 40% 360 Fire 701 - - - - - - - - - - - - - - NA 360 Police Pension Fund 702 4,624 4,624 4,000 116% 360 General Government Various 101131226 3,027 860 499 40 4,504 1,088 10,018 1,100 911% 360 General SBCDA Account 420 621 621 79,419 1% 360 Hall of Fame 3131677 42 42 42 100% 360 Motor Vehicle Highway 202 9 3 12 300 4% 360 Motor Vehicle Highway Scrap Meta 202 250 1,002 514 936 2,702 4,000 68% 360 Motor Vehicle Highway Curb Pr gm 202 557 734 889 643 25,172 21,712 5,380 17,148 6,317 6,772 2,473 9,754 97,551 25,000 390% 360 Parking Garage Fund 601 8 3 33 17 5 10 22 45% 360 ProfessionalSports 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 4,365 4,810 2,584 7,679 5,003 40,257 53,000 76% 360 Sewage Depreciation Fund 642 148,094 20,000 168,094 NA 360 Streets Scrap Metal Sale 101 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 360 Water Works Utility 620 3,799 712 1,423 1,423 37,805 736 846 1,693 15 4,585 53,036 90,500 59% 362 General Fund 101 NA 362 Dept Of Community Investment 212 2,500 1,847 9,674 1,847 1,847 2,500 20,214 40,800 50% 362 Palais Royale 101 2,050 1,199 1,454 5,575 8,416 8,288 9,511 9,502 9,715 2,234 6,208 64,151 84,000 76% 362 Parks & Recreation 201 2,889 3,124 3,013 3,575 6,678 5,518 5,312 3,215 4,411 925 870 40 39,490 36,000 110% 362 S Bend School Corp Fee 407 25,000 25,000 25,000 100% 362 TIF Pro erty various 21,775 35,341 20,163 25,368 26,836 27,215 21,503 23,859 15,054 18,980 14,655 19,489 270,236 276,184 98% 362 UDAG 410 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 369 Memorial Hosp Leighton Plaza 408 150,000 150,000 150,000 100% 371 Century Center Fees 670 114,235 62,402 87,298 94,025 99,586 90,477 156,212 120,553 91,014 337,040 150,093 215,120 1,618,055 2,136,706 76% 399 Bosch Retention Project 210 120,875 28,032 14,174 14,280 177,362 1,462,358 12% 399 Principal on Loan various 18,477 18,726 24,351 18,885 35,287 18,277 21,154 22,214 2,950 34,890 889 34,056 250,156 240,451 104% 399 Principal Income xxx 237,331 1,763 1,763 1,763 618,205 1,763 195,888 1,058,477 1,328,687 80% 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 7,108,103 5,679,605 6,091,571 5,115, 391 5,341,159 67, 614,897 72,352,238 93% oric Preservation 368 Petals 450 1,251 686 339 551 1,277 1,293 2,722 1,757 1,542 1,673 1,088 1,168 15,346 16,000 £ 368 General Fund 101 - - - - - - - - - - - - - - XX XXX XXX Sub Total 1,251 686 339 551 1,277 1,293 2,722 1,757 1,542 1,673 1,088 1,168 15,346 16,000 £ of Assets 391 TIF 4201324 196 1,673 21,513 49,780 (45,376) 27,786 136,673 391 Water Hydrant Reimbursement 620 190 8,214 65 7,347 571 70 39 9 75 65 16,645 21,525 391 Sale of Fixed Assets various 300 80,413 (3,545) 77,168 3,500 22( 391 Vehicle Damage Reimbursement various 1,000 XX XXX XXX Sub Total 386 8,214 1,738 7,347 571 21,583 300 80,452 46,235 9 (45,301) 65 121,599 162,698 Revenue Total 17,428,318 11,882,349 13,122,661 20,422,293 13,209,343 59,913,179 20,786,689 14,548,012 18,959,866 15,406,883 14,885,563 52,169,001 272,732,811 309,813,860 88% report 17,428,318 11,882,349 13,122,661 20,422,293 13,209,343 59,913,179 20,786,689 14,548,012 18,959,866 15,406,883 14,885,563 52,169,002 272,732,811 309,813,860 0 0 0 0 0 Financial Report December 2013 - Revenue Report Page 5028 City of South Bend Revenue by Fund Report Period Ending: December 2013 s i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Bud et I of8ud et General Government 0000 General Revenues 101 1,158,752 1,042,137 741,662 775,058 1,313,822 21,830,281 1,006,054 1,580,853 721,771 769,604 926,866 19,016,692 50,883,552 53,080,130 96% 0101 Mayor 101 151 186 227 151 151 151 251 257 151 351 151 151 2,333 4,617 51% 0104 311 Call Center 101 184,939 33,698 23,606 242,243 320,102 76% 0201 Clerk 101 - - - - - - - - - - - - - - NA 0301 Common Council 101 696 703 1,055 703 703 703 703 1,055 703 27 27 27 7,106 8,300 86% 0401 Controller 101 29 3 365 10 3,679 2,250 530 6,866 50 13731% 0501 Legal 101 560 32 144 21 138 193 18 226 326 116 54,368 41 56,183 72,350 78% xxx xxx NA Sub Total 1,160,189 1,043,061 743,088 776,299 1,314,815 21,831,339 1,007,026 1,582,390 907,891 807,475 1,007,269 19,017,442 51,198,283 53,485,549 96% Public Works 0600 Energy Office 101 - - - - - - - - - - - - - - NA 0602 Engineering 101 45,123 41,173 186 199 200 365 54 125 5,079 36,100 14% 0606 Building Maintenance 101 - - - - - - - - - - - - - - NA 0607 Traffic & Lighting 101 250 100 350 NA xxx xxx NA Sub Total 250 45,123 41,173 186 299 200 365 54 125 5,429 36,100 15% Public Safety 0801 Police 101 29,524 45,699 35,877 15,376 21,676 21,174 3Z314 34,197 4,099 53,251 20,758 55,423 369,367 360,500 102% 0802 Police Communications 101 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 0805 Police -PS LOIT funded 101 992 142 18,184 992 142 992 142 992 142 3,986,751 3,968,567 100% 0901 Fire 101 58,179 17,304 73,555 618,846 44,009 39,551 35,818 37,387 4Z829 42 044 544,231 109,570 1,663,323 1,616,000 103% 0905 Fire-PS LOIT funded 101 783,298 783,298 783,298 1,068,395 135,351 3,553,638 3 133 190 113% Sub Total 1,863,142 63 002 127,615 Z409,661 661 65 685 60,725 1,843,571 71 584 46,928 2 155,831 564,989 300,345 9,573,078 9,078,257 105% Code Enforcement 1201 Code 101 22 Z301 17 8 16 371 36 48 4 2 12 Z838 300 946% 1203 Code Hearin 101 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 1204 Code Junk Vehicle 101 240 120 135 1,976 3,360 500 150 405 6,886 36,000 19% 1205 Code Unsafe Building 101 102 493 9,294 5,032 10,512 4,905 74,580 11,292 9,168 5,111 12 695 7,917 84,053 337,051 103,000 327% 1207 Code Animal Control 101 8 8 70 30,291 4,143 3,650 5,034 3,754 Z668 49,625 1,100 4511 xxx xxx NA Sub Total 102,763 11,723 5,184 10,520 6,967 74,951 41,619 16,671 9,309 17,883 11,673 87,137 396,400 140,400 282% Arts 8 Culture 0404 Morris PAC 101 16,931 59,825 123,647 53,629 155,607 122,628 24,954 2,101 60,731 26,047 48,478 199,308 893,885 882,000 101% 0405 Palais Royale 101 24,589 14,785 7,711 14,554 33,008 28,626 48,532 36,934 20,782 30,695 16,576 24,081 300,874 309,981 97% xxx xxx NA Sub Total 41,520 74,611 131,358 68,182 188,615 151,254 73,486 39,035 81,513 56,742 65,054 223,389 1,194,759 1,191,981 100% Human Rights 1008 Human Rights 101 NA xxx xxx NA Sub Total NA 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 1,709,879 1,046,005 3,037,986 1,649,110 19,628,312 62,367,948 63,932,287 98% Financial Report December 2013 - &p-dk- Summary Page 6 of 28 City of South Bend Revenue by Fund Report 0000 1100 1101 1102 1103 1104 1106 1107 xxx Period Ending: December 2013 a % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I ec I Year I Budget I ofBUd et Public Works Motor Vehicle Hi hwa 202 488 959 201 470 127_712 2,285,212 320 036 613 846 1 606 089 475 730 631 705 125_232 166_222 565 801 9 139,123 8 691,971 105% Cenha/ Services 222 594 468 613 113 655 810 712 436 620 498 560 628 612 323 581 693 540 806 651 023 521 932 590 145 7 254,876 7 922, 703 92% Local Roads 8 Streets 251 23_217 89 429 99 998 92 159 90 773 89 360 92 567 22 361 77 178 91 177 88 095 91 999 1 008,943 1 061,143 95% Pro-ecf ReLeaf 655 36 186 36 134 36 262 36 044 36 154 36 562 36 198 36 419 36 669 36 516 36 313 36 482 435 940 431 700 101% xxx xxx xxx NA Sub Total 1,203,460 940 145 1,249,780 3 726 255 1,067,463 1 300 395 Z347,178 178 1 116 203 1,286,358 1 203 949 1,113,269 1 284,427 17 838,883 18 107,517 99% Public Works Solid Waste Solid Waste Operations 610 399 588 410 140 404 066 408 709 406 873 411 360 585 350 411 196 615 637 478 231 403 310 473,486 5,407,945 5,257,701 103% Solid Waste Ca ifal 611 279 339 29 32 235 002 13 105 315 937 47 90 43 26 44 830,707 784,261 106% xxx xxx xxx NA Sub Total 678,926 410,168 404,098 643,710 406,886 411,465 901,287 411,243 615,727 478,274 403,336 473,531 6,238,653 6.041.962 10351 Public Works Water Utility 0000 Water Works Revenues 620 899,232 945,800 956,340 951,433 975,187 1,302,134 1,032,586 1,464,934 1,090,854 1,503,940 959,649 926,304 13,008,393 13,171,433 99% 0630 Water Leak Insurance 620 75,340 75,492 80,340 80,179 80,379 80,920 80,440 80,562 81,187 80,853 80,533 80,698 956,921 958,840 100% 0640 Water Works 620 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 0660 Clay Water 620 69,426 72,918 73,398 72,030 75,449 133,438 98,110 143,641 110,623 149,426 74,458 71,391 1,144,309 1,159,500 99% Waterworks Ca ifal 622 2,126 1,790 1,521 784 859 1,848 702 871 1,124 754 476 854 13,709 14,000 98% Waterworks Construction 623 2,976 2,475 2,077 995 1,032 2,120 813 1,006 1,250 746 422 638 16,550 18,000 92% Waterworks De osit 624 722 570 520 268 295 642 252 321 437 297 188 350 4,861 6,100 80% Waterworks Sinking 625 170,955 170,979 171,024 171,037 171,096 171,320 171,124 171,127 171,234 171,183 172,373 172,552 2,056,004 2,108,381 98% Waterworks Bond Reserve 626 26,059 25,958 25,882 25,654 25,686 18,094 17,714 17,785 17,905 17,766 17,657 17,828 253,988 313,509 81% Waterworks Debt Reserve 629 46,320 860 747 382 422 910 356 447 614 416 264 490 52,228 52,801 99% xxx xxx xxx NA Sub Total 1,293,155 1,296,842 1,311,848 1,302,762 1,330,406 1,711,426 1,402,098 1,880,694 1,475,228 1,925,381 1,306,020 1,271,103 17,506,963 17,802,564 98% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 45,161 46,036 45,577 46,014 46,690 46,449 45,561 47,122 45,873 45,708 45,853 46,823 552,869 549,200 101% 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 2,654,665 2,549,907 2,609,994 2,532,750 2,437,429 29,885,872 31,288,374 96% 0621 Sewer Department 641 2,142 1,261 2,047 1,346 6,795 2,000 340% 0625 Concrete Crew 641 4,930 4,503 6,237 3,876 7,060 4,890 4,334 4,576 6,694 47,099 75,000 63% 0630 Wastewater Operations 641 3,082 3,082 NA 0631 Organic Resources 641 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 0650 Clay Sewage 641 136,798 151,188 157,884 153,565 135,652 157,535 169,502 157,082 164,866 150,486 155,264 151,873 1,841,695 1,766,173 104% Ca ital 642 4,546 3,819 3,102 1,525 1,655 3,541 1,296 149,658 22,032 1,290 762 1,185 194,410 4,560,000 4% Reserve 643 1,586 1,335 201,432 619 684 1,475 577 732 995 675 428 793 211,332 127,098 166% nd 2006/2006 645 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA nd 2007 647 10 8 7 4 4 2 1 1 2 1 1 1 42 NA Bond Sinkin F 649 814,673 814,684 815,032 814,845 775,341 776,031 774,947 775,266 775,793 775,544 775,260 776,309 9,463,724 8,234,756 115% a a General 650 0 0 0 0 0 0 0 0 0 2 NA Bond 2007 651 20 17 13 6 6 2 1 1 1 1 0 1 69 NA Works DS Reserve 653 3,524 3,524 3,524 3,524 3 14,099 1,805,314 1 % Net Sewer Bond 658 58 48 39 20 20 17 5 3 4 1 0 1 216 NA wer Bond 659 5,214 4,149 3,371 1,669 1,826 3,885 1,518 1,917 2,594 1,737 1,097 1,992 30,970 60,000 52% wer Bond 661 10,033 8,508 4,388 4,814 10,366 4,011 4,885 6,528 4,257 2,581 4,646 65,016 60,000 108% V2201,2 wer Bond 663 21,200,000 0% ewer Refund Bonds 664 85,740 2 1 1 1 1 1 85,747 85,741 100% Sub Total 3,244,109 3,377,066 3,711,847 3,594,701 3,486,911 3,545,950 3,523,745 3,801,475 3,575,533 3,594,030 3,518,572 3,429,098 42,403,038 69,813,656 61% Financial Report December 2013 - &p-dk- Summary Page 7 of 28 City of South Bend Period Ending: December 2013 Revenue by Fund Report % Fund I Jan I Feb I Mar I Apr I May Jun Jul Au ,.p Dec I Year I Bud et I ofeud et Public Safe - Police Police Seizures 216 74 5,186 54 28 3,845 63 25 32 9,768 605 20 7,770 27,470 35,900 77% Curfew Violations 218 43 17 42 27 27 17 139 90 28 87 139 5 663 1,025 65% Law Enforcement Education 220 25,208 10,840 16,746 24,433 9,531 10,554 20,227 10,768 22,072 22,480 9,972 11,698 194,528 347,000 56% Public Safety LOIT 249 492,566 491,812 713,536 491,501 491,342 830,749 491,431 491,351 491,559 510,948 491,251 594,596 6,582,642 5,900,386 112% Excess Welfare Public Safety 252 1 1 0 0 0 1 0 0 0 0 0 0 4 NA Police Take Home Vehicle 278 9,821 9,752 14,430 9,580 9,549 9,530 9,399 14,196 9,703 9,626 9,596 9,666 124,848 129,400 96% Police Block Grant 280 2 2 1 1 1 2 1 1 1 1 1 1 13 185,300 0% Police Grants 292 38,532 124,306 162,838 110,000 148% Police cademy 294 10,138 3,935 1,231 3,415 962 37 14 17 523 15 709 17 21,013 28,500 74% COPS More Grants 295 1,085 1,102 919 950 1,092 737 819 1,144 770 1,101 594 12,755 23,068 41,600 55% Drua Enforcement 299 2,320 23,108 8,046 28,002 641 8,806 64 13,725 74,541 13,302 8,694 13,320 194,559 102,000 191% K -9 Unit 705 1 1 1 1 0 1 0 0 1 0 0 0 8 2,000 0% xxx xxx xxx NA Sub Total 541,259 545,756 755,006 557,939 516,990 860,496 560,652 531,322 608,967 558,166 520,976 774,134 7,331,664 5,883,111 10751 Pub lie Safe -Fire EMS Ca ital 288 158,312 241,519 276,434 277,404 293,748 208,431 230,331 253,354 293,460 328,619 489,248 5,272,172 8,323,033 8322,622 100% Hazmat 289 1 1 16,723 3 4 9 3 4 5 3 2 4 16,762 3,000 559% River Rescue 291 2,561 49 12,538 17,520 5,664 4,053 578 19,520 2027 1,521 13 24 66,068 31,500 210% xxx xxx xxx NA Sub Total 160,875 241,569 305,695 294,927 299,417 21Z493 230,912 272,877 295,492 330,144 489,263 5,272,199 8,405,863 8,357,122 101% Department of mmunity Investment Studebaker /Oliver 209 554 466 397 205 225 484 190 240 327 222 141 261 3,712 5,000 74% State Grant 210 471 163,234 336 201 210 449 175 36,225 18,304 205 89 18,167 238,066 1,646,262 14% DC/ Operating 211 444,219 6,698 165,307 433,348 5,885 7,289 575,019 16,601 37,860 16,446 775,894 7,046 Z491,611 Z486,009 100% 0000 Dept of Community Investment 212 61,995 76,544 144,292 121,560 161,963 504,897 98,665 80,347 533,470 264,199 396,220 230,460 Z674,611 611 6 715,580 40% xxx Programs 212 431,260 390,046 255,729 81,742 55,179 230,679 13,959 49,554 300,682 1,808,829 Z085,605 87% 0000 Economic Revenue Bond 281 14 12 10 5 6 12 5 6 8 6 4 7 93 100 93% xxx xxx xxx NA Sub Total 938,512 636,999 566,070 637,061 223,467 743,811 688,012 18Z974 890,651 281,076 1,172,348 255,940 7,216,922 12,938,556 56% 0000 Parking Garage Revenue 601 367 281 268 123 155 326 103 137 228 148 81 261 2,478 4,010 62% 0460 Main Street 601 16,336 24,002 16,035 18,220 38,122 16,331 36,895 14,945 15,496 20,336 22,498 25,750 264,966 299,246 89% 0462 Leighton Plaza 601 25,840 31,229 35,667 42,758 30,056 29,854 42,255 36,319 34,291 31,932 34,497 17,096 391,792 458,921 85% 0463 Enforcement 601 5,689 7,750 5,449 6,096 8,421 7,024 8,810 10,568 10,086 10,765 7,102 7,658 95,416 96,264 99% 0464 Wayne Street 601 16,989 17,256 17,329 18,992 19,411 14,577 28,521 17,236 18,634 17,817 17,983 9,731 214,476 235,740 91% 0465 Eddy Street Commons 601 1,100 770 310 50 40 200 2,470 15,900 16% xxx xxx xxx NA Sub Total 66.320 80.517 75.518 86.190 96.476 68.111 116.634 79.204 78.735 81.037 82.160 60.697 971.598 1.110.081 88% Financial Report December 2013 - &p-dk- Summary Page 8 of 28 City of South Bend Revenue by Fund Report Period Ending: December 2013 i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep 1 Ocf 1 Nov I Dec I Year I Budget I ofeud et Other Miscellaneous Rain Da 102 4,405 3,708 3,159 1,629 1,787 3,852 1,509 1,913 2,602 1,764 1,119 2,076 29,523 52,000 57% Gift Donation Be nest 217 827 297 154 277 13 9,839 12 16 22 15 10 18 11,501 17,011 68% Loss Recove 227 2,227 1,875 7,905 821 900 1,938 3,799,307 1,502 2,444 1,651 23,147 1,926 3,845,643 3,851,957 100% Human Ri hts 258 264 207 12,147 3,602 740 28,048 127 20,097 117,995 ,764 67 2,619 178,148 237,250 75% Morris Palais Marketing 273 23 2,162 10 265 1,406 13 785 26 183 860 953 429 7,113 8,100 88% Professional Sports Development 377 103,569 54,401 54,533 34,601 93,242 382 36,362 65,750 176 83,807 82 150,800 677,705 687,801 99% Building Operations 600 88,757 68,560 85,230 74,621 82,311 68,761 73,197 103,141 79,394 92,457 73,895 63,905 954,228 1,148,035 83% Century Center 670 791,035 87,640 117,181 116,672 117,690 756,122 162,697 125,037 102,801 356,946 162078 237,916 3,133,815 3,766,205 83% Century Center Capital 671 100,022 21 23 23 46 575,052 32 33 32 32 675,315 675,500 100% xxx xxx xxx NA Sub Total 1,091,128 218,870 280,343 232,512 298,089 869,000 4,073,995 892,534 305,649 529,769 261,381 459,721 9,512,992 10,443,859 91% Business Insurance 0000 Business Insurance Revenues 226 250,264 249,680 254,272 250,212 250,230 251,570 250,040 251,823 249,008 250,130 251,395 251223 3,009,847 3016,076 100% 0403 Self Funded Liability Ins 226 - - - - - - - - - - - - - - NA 0412 Liability Insurance 226 - - - - - - - - - - - - - - NA 0417 Business Insurance 226 - - - - - - - - - - - - - - NA 0418 Workers Compensation 226 17,000 0% xxx xxx xxx NA Sub Total 250,264 249,680 254,272 250,212 250,230 251,570 250,040 251,823 249,008 250,130 251,395 251,223 3,009,847 3,033,076 99% Trust Fiduc- Trust & A enc Fire Pension 701 691 567 311 66 2 517 646 240 Z517,833 2 135 294 427 5,038,211 5,040,279 100% Police Pension 702 1,451 1,249 1,129 294 133 Z931,894 2 19 434 2 932 271 4,916 426 648 5,874,865 5,873,697 100% Police / Fire Pension 703 420,791 (420,791) NA Employee Benefits 711 1,006,296 997 370 996,182 1,005,536 1 218 384 1,005,264 1 002 172 994,404 982 974 983,500 974,281 990,286 12,156,648 12 188,900 100% Unemployment Comp 713 28,475 28,471 28,477 28,462 21,362 21,408 16,029 16,040 16,059 16,041 16,027 16,056 252,907 341,450 74% Ceintery Trust 730 21 18 15 8 9 18 7 9 11 8 5 9 138 250 55% xxx xxx xxx NA Sub Total 1,457,725 606,885 1,026,114 1 034 366 1,239,887 6 476 231 1,018,227 1 011 127 6,449,149 1 004 599 991,032 1,007,426 23 322,769 23 444,576 99% Civil City Revenues 15,759,811 11,753,485 12,571,614 17,870,609 12,900,498 45,953,489 20,426,562 14,231,806 18,709,731 15,022,088 13,528,626 40,968,783 239,697,101 277,300,573 86% Tax Increment Financing TIF Airport 324 74,452 8,846 373,716 2,149,032 4,970 7,120,851 82,267 14,395 (924) 26,747 (61,468) 6,233,780 16,026,663 14,017,269 114% TIF Central Development 420 38,071 45,172 38,158 233,554 58,723 1,765,391 35,447 30,325 67,194 253,613 (38,255) 936,674 3,464,066 4,699,354 74% TIF West Washington 422 232 191 133 69 75 264,847 81 124 139 86 54 229,012 495,043 444,000 111% TIF Leighton Plaza 425 13,032 19,331 10,063 15,086 12,575 16,317 10,321 12,500 12,726 10,904 13,208 13,227 159,289 176,734 90% TIF Medical Service 426 1,979 1,611 1,326 676 709 614,692 624 835 1,111 728 412 609,215 1,233,919 1,732,600 71% TIF Northeast 429 1,138 957 810 415 455 432,960 420 583 793 538 339 410,275 849,685 828,300 103% TIF Southside 430 2,767 2,323 1,931 969 1,036 1,383,745 945 1,267 1,537 923 500 1,023,694 2,421,638 1,840,000 132% TIF Erskine Commons 431 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA TIFErskine Villa a 432 2,855 2,327 1,921 991 1,087 662,077 971 1,296 1,738 1,178 748 652,781 1,329,971 1,350,200 99% TIF Douglas Road 435 83 69 38 12 14 164,197 25 51 55 28 18 159,803 324,393 321,000 101% Northeast Residential TIF 436 1,796 1,493 776 367 403 1,340,895 449 718 552 374 235 923,130 2,271,188 2,460,000 92% xxx xxx xxx NA Sub Total 136,404 82,321 428,873 2,401,173 80,048 13,765,973 131,550 62,094 84,919 295,118 (84,210) 11,191,590 28,575,854 27,869,457 103% Financial Report December 2013 - &p-dk- Summary Page 9 of 28 City of South Bend Revenue by Fund Report Period Ending: December 2013 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Bud et I ofeud et Redevelo ment Funds Central Bond Proceeds 305 NA District Capital 2003 428 NA Administration 433 16 14 12 6 7 14 5 7 9 6 3 6 104 150 69% Coveleski Bond Construction 438 - - - - - - - - - - - - - - NA Certiried Technology Park 439 1,446,493 956 832 429 471 1,014 397 504 685 465 1,413,248 740 2,866,234 2,861,027 100% Airport Urban Enterprise Zone 454 192 162 138 71 78 168 66 84 114 77 49 91 1,289 1,300 99% Blackthorn Golf Operations 619 83,555 43,855 119,869 149,348 227,562 191,052 226,188 25Z 788 163,418 88,457 27,419 7,001 1,580,512 1,766,803 89% xxx x xxx NA Sub Total 1,530,256 44,987 120,850 149,854 228,117 192,248 226,657 253,382 164,225 89,005 1,440,720 7,838 4,448,138 4,629,280 96% Debt Service Public Improvement 1990 314 - - - - - - - - - - - - - - NA Airport Debt Reserve 2003 315 533 449 382 197 216 465 182 231 314 213 135 250 3,567 5,000 71% Coveleski Bond Debt Reserve 317 257 217 185 95 104 225 88 112 152 103 65 121 1,725 3,500 49% Blackthorn Debt Service 319 167 141 120 36 464 50 927% Central Development reserve 328 890 750 638 329 361 777 304 386 525 356 226 418 5,959 6,000 99% xxx x xxx NA Sub Total 1,848 1,556 1,324 657 681 1,468 575 728 991 672 426 790 11,714 14,550 81% Redevelopment Commsssion 1,668,507 128,863 551,047 2,551,683 308,846 13,959,690 358,782 316,205 250,134 384,795 1,356,936 11,200,218 33,035,707 32,513,287 102% City Operations Total 17,428,318 11,882,348 13,122,661 20,422,293 13,209,343 59,913,178 20,786,689 14,548,011 18,959,866 15,406,883 14,885,562 52,169,001 272,732,808 309,813,860 88% Revenue report 17,428,318 11,882,349 13,122,661 20,422,293 13,209,343 59,913,179 20,786,689 14,548,012 18,959,866 15,406,883 14,885,563 52,169,002 272,732,811 309,813,860 0 0 0 0 0 1 0 2 0 0 1 0 4 0 Financial Report December 2013 - Expenditure Summary Page 10 of 28 City of South Bend Property Tax Revenue 2012 Tax Pay 2013 Fund Period Ending: December 2013 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61412013 611712013 1212312013 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,369,939.03 0.95 36,451,442.08 13,051,204.28 6,798,591.66 16,401,600.74 36,251,396.68 2,118,542.35 94.48% Parks & Recreation 201 7,623,780.24 0.95 7,242,591.23 2,593,163.21 1,350,822.26 3,263,074.28 7,207,059.75 416,720.49 94.53% College Football Hall of Fame 313 1,341,607.54 0.95 1,274,527.16 - 693,822.13 574,356.46 1,268,178.59 73,428.95 94.53% Cumulative Capital District 406 490,121.50 0.95 465,615.43 166,710.61 86,842.35 209,778.19 463,331.15 26,790.35 94.53% Fire Pension 701 - 0.95 - - - 2,618,580.97 - - - Police Pension 702 214,165.13 0.95 Erskine Commons TIF District #2 431 0.95 - - Total - City - 47,825,448.31 Erskine Village TIF District #3 45,434,175.89 15,811,078.10 8,930,078.40 20,448,809.67 45,189,966.17 2,635,482.14 94.49% Tax Increment Financinq Airport TIF District 324 15,275,702.92 0.95 14,511,917.77 7,111,555.29 6,228,798.58 13,340,353.87 1,935,349.05 87.33% South Bend Central TIF District 420 3,761,712.00 0.95 3,573,626.40 1,705,490.58 885,317.48 2,590,808.06 1,170,903.94 68.87% West Washington TIF District 422 584,897.07 0.95 555,652.22 264,689.94 228,918.51 493,608.45 91,288.62 84.39% Central Medical TIFDistrict 426 2,128,725.48 0.95 2,022,289.21 613,184.76 608,491.41 1,221,676.17 907,049.31 57.39% Northeast Residential TIF District 436 2,607,578.70 0.95 2,477,199.77 1,340,027.53 922,737.17 2,262,764.70 344,814.00 86.78% Southside TIF District # 1 430 2,618,580.97 0.95 2,487,651.92 1,381,537.24 1,022,878.60 2,404,415.84 214,165.13 91.82% Erskine Commons TIF District #2 431 0.95 - - - - Erskine Village TIF District #3 432 1,319,469.76 0.95 1,253,496.27 659,734.88 651,393.90 1,311,128.78 8,340.98 99.37% Douglas Road TIF District 435 322,082.97 0.95 305,978.82 164,167.82 159,770.93 323,938.75 (1,855.78) 100.58% Northeast TIF 429 1,152,857.67 0.95 1,095,214.79 431,978.67 409,648.70 841,627.37 311,230.30 73.00% Airport Urban Enterprise Zone 454 0.95 - - - - - Other xxx 0.95 - Total - Tax Increment Financing 29,771,607.54 28,283,027.16 13,672,366.71 11,117,955.28 24,790,321.99 4,981,285.55 83.27% Grand Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 31,566,764.95 69,980,288.16 7,616,767.69 90.18% State Board 2010 Audit Fee Revised Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 31,566,764.95 69,980,288.16 7,616,767.69 90.18% Note(s) 1 Distribution 1 - 2 Distribution 2 - 3 Distribution 3 - x Financial Report December 2013 - Property Tax Revenue Page 11 of 28 City of South Bend Property Tax Revenue i1 Tax Pay 2012 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61112012 612212012 1212812012 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Cit General Fund 101 42,159,959.10 0.95 40,051,961.15 14,149,210.75 7,476,750.77 17,742,469.36 39,368,430.88 2,791,528.22 93.38% Parks & Recreation 201 8,374,886.47 0.95 7,956,142.15 2,810,677.15 1,485,222.94 3,528,156.04 7,824,056.13 550,830.34 93.42% College Football Hall of Fame 313 859,959.09 0.95 816,961.14 - 622,017.06 511,188.06 1,133,205.12 (273,246.03) 131.77% Cumulative Capital District 406 554,158.31 0.95 526,450.39 185,979.85 98,275.80 233,454.74 517,710.39 36,447.92 93.42% Fire Pension 701 - 0.95 - - - - - - Police Pension 702 0.95 Total - City 51,948,962.97 49,351,514.82 17,145,867.75 9,682,266.57 22,015,268.20 48,843,402.52 3,105,560.45 94.02% Tax Increment Financing Airport TIF District 324 12,266,234.17 0.95 11,652,922.46 6,111,684.64 5,519,602.49 11,631,287.13 634,947.04 94.82% South Bend Central TIF District 420 3,781,492.40 0.95 3,592,417.78 1,909,554.48 1,761,923.84 3,671,478.32 110,014.08 97.09% West Washington TIF District 422 483,719.73 0.95 459,533.74 225,083.13 197,631.37 422,714.50 61,005.23 87.39% Central Medical TIFDistrict 426 3,668,649.86 0.95 3,485,217.37 876,400.86 730,513.97 1,606,914.83 2,061,735.03 43.80% Northeast Residential TIF District 436 2,542,578.19 0.95 2,415,449.28 1,252,274.84 1,261,773.08 2,514,047.92 28,530.27 98.88% Southside TIF District #1 430 2,608,924.21 0.95 2,478,478.00 1,337,317.29 1,128,885.46 2,466,202.75 142,721.46 94.53% Erskine Commons TIF District #2 431 0.95 - - Erskine Village TIF District #3 432 - 0.95 - - - - - - Douglas Road TIF District 435 561,079.06 0.95 533,025.11 264,862.03 20,851.19 285,713.22 275,365.84 50.92% Northeast TIF 429 1,685,484.97 0.95 1,601,210.72 693,351.99 657,696.09 1,351,048.08 334,436.89 80.16% Airport Urban Enterprise Zone 454 74,480.84 0.95 70,756.80 37,240.42 74,480.84 111,721.26 (37,240.42) 150.00% Other xxx 0.95 - - - - Total -Tax Increment Financing 27,672,643.43 26,289,011.26 12,707,769.68 11,353,358.33 24,061,128.01 3,611,515.42 86.95% Grand Total 79,621,606.40 75,640,526.08 17,145,867.75 22,390,036.25 33,368,626.53 72,904,530.53 6,717,075.87 91.56' tate Board 2010 Audit Fee Revised Total 79,621,606.40 75,640,526.08 17,145,867.75 22,390,036.25 33,368,626.53 72,904,530.53 6,717,075.87 91.56' Note(s) 1 Distribution 1 - 2 Distribution 2 - 3 Distribution 3 - x Comment(s) Financial Report December 2013 - 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 Per County Collection Projected 612112011 1212812011 Date Total Property Tax Collection General Fund Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv 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% 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% 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% 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% Fire Pension 701 - 0.95 - - - - - - Police Pension 702 2,370,799.58 0.95 2,252,259.60 1,136,488.71 672,463.54 1,808,952.25 561,847.33 - Total - City 431 52,223,661.58 0.95 49,612,478.50 26,603,418.72 21,615,298.80 - 48,218,717.52 4,004,944.06 92.33% Tax Increment Financinq 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 Medical TIFDistrict 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.360/6 Note(s) 1 Distribution 1 - Issued by St. Joseph County on 6121111 2 Distribution 2 - 3 Distribution 3 - x Comment(s) Financial Report December 2013 - Property Tax Revenue Page 13 of 28 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 612912010 111912010 1212912010 Total Property Tax Collection Airport TIF District Records Factor Collections Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District 324 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% 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% 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% 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% Fire Pension 701 - 0.95 - - 1,315,314.36 - - - - - Police Pension 702 3,004,554.55 0.95 1,565,972.05 3,140,749.75 21,939.25 99.31% Erskine Village TIF District #3 432 1,919,446.00 - Total - City 959,722.81 53,878,419.00 1,858,426.55 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% Tax Increment Financinq 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 Medical TIFDistrict 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 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 December 2013 - 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 Citv 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 57,997,986.35 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 TIFDistrict 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 (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 December 2013 - Property Tax Revenue Page 15 of 28 City of South Bend Period Ending: December 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 I Year I Budget of Bud et vemment 2WOffice 101 54,256 54,256 54,256 igineering 101 92,121 103,866 131,505 109,771 112,729 76,945 116,507 125,076 97,583 99,154 146,707 88,126 1,300,089 1,393,561 affic 8 Lighting 101 24,326 46,239 10,341 19,670 8,960 109,536 111,815 ryor 101 62,503 47,311 54,127 44,646 49,780 52,944 53,396 61,305 50,138 43,975 49,579 61,865 631,570 694,229 1 Call Center 101 10,455 20,659 27,025 18,726 19,097 18,951 22,094 28,209 19,723 33,698 23,606 26,509 268,752 320,102 erk 101 25,214 22,533 37,222 24,635 24,564 23,219 25,395 33,573 23,307 33,715 22,063 28,323 323,764 365,170 immon Council 101 27,381 22,507 29,612 69,206 26,565 21,305 26,512 22,380 29,516 21,523 30,141 22,273 348,921 515,397 ontroller 101 132,676 133,465 185,982 146,255 143,535 147,644 136,610 198,230 150,758 137,802 144,121 146,567 1,803, 645 1,877,728 gal 101 64,312 57,169 76,908 61,743 63,274 69,686 71,415 113,283 74,577 80,899 77,866 84,657 895,789 1,028,466 K 3,849,063 3,787,951 5,447,214 3,940,341 3,881,069 4,560,197 4,082,798 5,469,788 4,028,859 4,036,450 4,199,333 5,032,045 52,315,109 53,831,388 ib Total 322,541 303,644 410,877 365,212 326,815 333,749 335,422 456,981 348,019 351,613 347,375 370,195 4,272,441 4,801,092 cs 2WOffice 101 54,256 54,256 54,256 igineering 101 92,121 103,866 131,505 109,771 112,729 76,945 116,507 125,076 97,583 99,154 146,707 88,126 1,300,089 1,393,561 affic 8 Lighting 101 24,326 46,239 10,341 19,670 8,960 109,536 111,815 K 101 1,837,065 1,587,293 ib Total 116,446 150,105 141,846 183,697 112,729 85,905 116,507 125,076 97,583 99,154 146,707 88,126 1,463,881 1,559,632 ty lice 101 1,837,065 1,587,293 2,307,957 1,698,826 1,632,809 1,801,813 1,733,157 2,430,256 1,787,921 1,759,291 1,801,379 2,131,760 22,509,527 23,795,376 Mice Communications 101 149,657 146,236 210,289 165,511 162,301 168,876 159,503 215,489 165,492 184,697 154,754 177,838 2,060,643 2,326,560 slice -PS LOIT funded 101 232,248 362,762 415,315 288,534 295,407 408,201 282,287 395,478 294,925 299,933 275,970 435,690 3,986,751 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 2,081,017 1,526,360 1,548,765 1,571,669 2,007,434 20,204,550 20,607,695 -e-PS LOIT funded 101 166,938 164,570 451,790 178,342 175,838 429,118 466,685 347,548 254,162 243,764 395,560 279,324 3,553,638 3,133,190 K 101 41,716 44,150 61,637 40,359 45,592 45,312 51,246 60,067 42,098 41,580 35,193 42,082 551,032 596,111 ib Total 3,849,063 3,787,951 5,447,214 3,940,341 3,881,069 4,560,197 4,082,798 5,469,788 4,028,859 4,036,450 4,199,333 5,032,045 52,315,109 53,831,388 cement We 101 108,213 122,305 148,505 139,379 115,365 111,452 145,251 197,092 407,008 215,694 79,370 200,930 1,990,564 2,270,969 eights and Measure 101 30 (30) ode Hearing 101 1,500 5,478 1,500 1,500 2,500 7,500 3,500 5,000 4,600 99 5,800 38,977 40,000 ode Junk Vehicle 101 4,142 5,020 8,874 4,846 4,584 2,611 (1,874) 1,187 521 528 1,418 547 32,404 65,829 ode Unsafe Building 101 2,765 1,870 5,460 875 2,082 1,695 2,360 1,105 735 1,815 3,040 2,250 26,052 53,684 ode Animal Control 101 41,716 44,150 61,637 40,359 45,592 45,312 51,246 60,067 42,098 41,580 35,193 42,082 551,032 596,111 X ib Total 156,835 174,845 229,954 186,960 169,123 163,286 204,483 262,980 455,333 264,218 119,120 251,609 2,638,746 3,026,593 ire wis PAC 101 79,568 80,987 90,428 72,893 69,441 68,319 80,811 106,419 65,432 68,373 66,094 76,371 925,137 1,033,800 dais Royale 101 31,386 27,038 38,976 32,036 32,333 28,508 37,204 36,977 27,928 45,178 26,324 33,070 396,959 492,830 K ib Total 110,954 108,025 129,405 104,929 101,774 96,826 118,015 143,397 93,360 113,551 92,418 109,441 1,322,096 1,526,630 Ws iman Rights 101 23,083 24,800 31,528 28,881 20,153 24,164 27,355 29,233 20,969 38,295 20,831 24,763 314,055 346,237 K ib Total 23,083 24,800 31,528 28,881 20,153 24,164 27,355 29,233 20,969 38,295 20,831 24,763 314,055 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 6,487,456 5,044,123 4,903,280 4,925,784 5,876,179 62,326,328 65,091,572 96% Financial Report December 2013 - &p-dk- Summary Page 16 of 28 City of South Bend Period Ending: December 2013 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au Sap Oct I Nov I Dec I Year I Budget of Bud et Parks & Recreation Vid Waste Operations 610 640,573 399,576 401,422 613,502 Dtor Vehicle Highway 1100 Administration 201 108,405 89,616 105,106 83,749 84,356 108,543 84,864 108,246 85,430 81,811 83,518 85,529 1,109,172 1,212,578 91% 1101 Maintenance 201 393,900 350,794 452,885 394,825 533,739 458,919 416,673 64Z 133 512367 414,676 428,170 448,280 5,447,359 5,630,357 97% 1102 GolfOperations 201 64,123 175,427 137,984 155,769 145,797 146,068 163,063 216,524 140,046 120,985 92680 170,154 1,728,619 1,742,936 99% 1103 Recreation Division 201 124,459 135,459 182,820 146,559 135,171 162,637 209,878 256,885 127,560 131,248 126,342 144,676 1,883,695 1,988,376 95% 1104 Potawatomi Zoo 201 137,992 133,640 205,665 156,904 158,040 175,569 193,939 235,856 159,628 149,109 132,994 247,056 2,086,392 2,254,702 93% 1106 Potawatomi Greenhouse 201 5,144 8,264 5,540 4,181 2,134 1,706 840 971 815 985 16,814 3,953 51,347 86,865 59% 1107 Community Svc Block Grant 201 - - - - - - - - - - - - - - NA 1108 Graffiti Removal 201 5,920 6,644 7,490 6,983 6,298 5,883 6,310 8,994 6,724 8,095 10,551 6,464 86,355 101,649 85% Recreation Non Reverting 203 45,993 43,310 88,061 43,801 66,744 64,738 168,231 137,825 53,252 71,217 53,635 59,394 896,201 1,560,777 57% East Race Waterway 271 300 300 400 5,615,883 1,237,365 9,516,963 Clay Sewage General 650 346 0% Coveleski Stadium 401 1,171,111 1,391,545 1,432,417 1,144,004 1,277,654 1,753,276 1,575,350 2,084,804 1,252,811 1,894,712 1,852,816 4,244,973 21,075,473 3,540 0% Park Non RevemIng 405 6,302 4,874 10,366 31,388 8,761 3,482 7,275 16,742 2,115 31,835 10,039 15,035 148,214 217,316 68% xxx xxx xxx 2,438,087 2010 CSO Net Sewer Bond 658 518 6,692 4,415 63,651 24,521 8,932 7 NA Sub Total 110,204 892,237 948,028 1,195,916 1,024,158 1,141,041 1,127,545 1,251,072 1,624,176 1,087,938 1009962 954,742 1,180,542 13,437,355 14,799,442 91% ks Vid Waste Operations 610 640,573 399,576 401,422 613,502 Dtor Vehicle Highway 202 483,878 566,089 730,143 463,866 468,146 507,769 588,107 630,306 765,688 781,070 667,294 1,077,633 7,729,988 9,176,496 ?ntral Services 222 563,474 609,351 701,699 677,588 771,690 361,445 610,818 638,598 527,213 624,656 575,474 644,379 7,306,386 7,979,429 )cal Roads &Streets 251 17,647 13,100 500 271,678 542,830 39,810 138,450 215,509 81,906 113 3,154 641 781,866 1,235,924 -olectReLeaf 655 3,735 2354 2447 252179 13,947 826 13,645 2246 5,661 4,757 38,258 17,714 357,767 432,065 X XXX 627,301 1,216,792 52% Waterworks Construction 623 90,214 392,957 345,248 75,752 246,843 34,170 295,145 662,260 50,206 ib Total 703,767 1,068,733 1,190,895 1,434,788 1,665,310 1,253,783 909,850 1,351,020 1,486,659 1,380,468 1,410,595 1,284,180 1,739,726 16,176,007 18,823,914 ks Solid Waste Vid Waste Operations 610 640,573 399,576 401,422 613,502 390,482 387,538 786,291 444,213 431,371 377,426 507,191 424,483 5,804,066 5,942,328 slid Waste Capital 611 188,809 79,617 10,821 45,454 188,809 98,617 19,870 28,923 51,455 712375 880,061 X xxx 1,044,184 1,016,672 936,030 1,009,124 1,114,491 1,055,867 1,085,057 1,019,261 957,020 1,127,061 ib Total 829,382 479,193 412243 613,502 390,482 432,992 975,100 542,830 451,240 377,426 536,114 475,938 6,516,442 6,822,389 Public Works Water Utility 0620 Sewer Repair Insurance 640 0630 Water Leak Insurance 620 57,675 53,878 38,049 49,067 82,881 120,503 130,536 128,426 lIZ767 120,158 111,550 49,379 1,054,870 1,191,000 89% 0640 Water Works 620 1,021,803 929,932 1,044,184 1,016,672 936,030 1,009,124 1,114,491 1,055,867 1,085,057 1,019,261 957,020 1,127,061 12,316,501 13,601,947 91% 0660 Clay Water 620 27,495 235 22,912 3 15 150 2311 198 641 129 138 2, 15Z 180 2915 3,000 97% Waterworks Capital 622 818 10,754 3,600 1,782 11,025 179,210 31,788 236,762 3,450 67,500 79,721 890 627,301 1,216,792 52% Waterworks Construction 623 90,214 392,957 345,248 75,752 246,843 34,170 295,145 662,260 50,206 686,979 703,767 1,423,216 5,006,757 5,566,203 90% Waterworks Deposit 624 7,160 1,332 520 268 295 642 252 321 437 297 188 350 4,901 4,000 123% Waterworks Sinking 625 600 578 71 84 143 408,567 471 524 281 230 167 1,643,587 2,055,303 2,108,381 97% Waterworks Bond Reserve 626 - - - - - - - - - - - - - - NA Waterworks Debt Reserve 629 13,616 1,879 747 382 422 910 356 447 614 416 264 490 6,927 7,500 92% xxx xxx xxx 300 300 400 5,615,883 1,237,365 9,516,963 Clay Sewage General 650 NA Sub Total 1,171,111 1,391,545 1,432,417 1,144,004 1,277,654 1,753,276 1,575,350 2,084,804 1,252,811 1,894,712 1,852,816 4,244,973 21,075,473 23,698,823 89% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 34,416 18,132 32,759 29,708 46,100 26,994 27,995 33,955 14,605 26,666 38,818 20,876 351,024 0621 Sewer Repair 641 445,598 393,031 424,400 321,521 343,147 326,245 362,527 442,030 315,475 371,012 422,395 478,327 4,645,707 0625 Concrete Crew 641 26,901 23,851 37,513 26,075 22,711 29,834 27,495 36,006 22,912 25,553 27,140 41,615 347,605 0630 Wastewater Operations 641 1,947,182 1,828,903 2, 15Z 180 1,864,780 1,918,510 1,857,179 1,805,752 1,819,223 1,823,440 2,035,318 1,712,391 1,935,427 22,700,284 0631 Organic Resources 641 54,465 45,115 63,900 93,819 83,682 107,691 70,761 109,144 117,561 97,909 140,631 142,929 1,127,609 0650 Clay Sewage 641 171 34 379 5,602 139 951 15 177 7,160 Sewage Ca ital 642 47,174 693,978 127,395 50,895 83,594 700,698 322,960 335,613 471,367 871,539 711,780 595,959 5,012,953 Sewage Reserve 643 2921 1,136 619 684 1,475 577 732 995 675 428 793 11,036 Sewer Bond 200612006 645 12 12 Sewer Bond 2007 647 13,616 63 4,263 17,942 Sewage Bond Sinking 649 800 1,080,895 1,581,020 300 300 400 5,615,883 1,237,365 9,516,963 Clay Sewage General 650 698 0 698 Sewage Bond 2007 651 4,582 5,220 26,182 2 3,639 39,624 Sewage Works DS Reserve 653 2,434,563 3,524 2,438,087 2010 CSO Net Sewer Bond 658 518 6,692 4,415 63,651 24,521 8,932 7 1,468 110,204 2011 Sewer Bond 659 745,740 609,749 34,944 113,818 5,500 36,536 14,334 121,611 56,654 58,282 234,583 317,228 2,348,981 2012 Sewer Bond 661 104,981 206 157,047 335,748 978,383 702,522 1,018,716 280,441 885,860 548,973 5,012,877 2013 Sewer Bond 663 2013A Sewer Bond 664 35,750 45,314 215 81,279 Sub Total 3,406,975 3,627,925 2,883,862 6,120,348 4,281,302 3,492,613 3,616,687 3,601,695 3,851,610 3,767,865 9,790,301 5,328,862 53,770,046 Financial Report December 2013 - &p -dkwe Summary Page 17.f28 City of South Bend Period Ending: December 2013 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Public Safe - Police EMS Capital 288 38,560 40,567 806,139 697,957 21,335 874,056 322,488 1,470,247 441,632 296,545 2,045,654 1,241,317 8,296,497 11,528,163 Hazmat Police Seizures 216 115 3,017 500 10,000 3,500 River Rescue 291 18,756 1,342 3,654 13,194 950 27,675 1,279 1,000 13,729 45,900 30% Curfew Violations 218 State Grant 210 11,492 Sub Total 57,317 41,909 809,897 711,150 23,901 904,748 332,248 1,474,703 441,875 301,716 2,047,579 1,242,463 8,389,507 11,623,789 1,000 0% Law Enforcement Education 220 9,543 118,650 11,254 30,860 5,769 1,639 11,575 90,588 1,850 909 20,568 2,696 300,509 478,131 63% Public Safety LOfr 249 1,775,439 1001 18,184 1,775,439 37,133 29,868 1,775,439 135,853 90,607 2,060,536 193,480 135,351 7,540,389 7,101,757 106% Excess Welfare Public Safety 252 6,332,298 35% 1002 Dept. of Community Investment 212 7,787 18,775 9,459 2,910 19,446 1,115 1,557 1,557 224,570 NA Police Take Home Vehicle 278 90 NA 1003 Administration 212 63,700 143 63,700 103,700 61% Police Block Grant 280 238 2,565 9% xxx Programs 212 457,037 388,265 394,456 197,024 254,365 174,722 185,000 0% Police Grants 292 25,102 5,924 2,201,588 2,622,409 84% 36,911 xxx xxx 11,124 93,964 19,543 213,404 56,454 110,000 51% Police cademy 294 1,298 427 8,513 549 259 6,077 130 105 1,853 6,591 411 532 26,744 28,500 949Y COPS More Grants 295 485 2,281 1,784 980 864 600 1,114 2,252 1,134 988 3,126 1,407 17,014 41,980 41% Drim Enforcement 299 6,433 65,631 20,649 3,390 3,239 634,500 12,129 6,162 1,113 5,950 20,054 144,750 188,573 77% K -9 Unit 705 1,604,033 432,675 453,623 1,698,086 445,103 516,990 933,477 352,864 637,092 445,795 489,366 625 625 2,000 31% xxx xxx xxx 42 42 56,588 42 239,748 56,588 42 42 56,588 42 135,768 56,588 602,118 911,220 NA Sub Total 407 1,793,198 186,989 60,883 1,821,218 10,129 45,226 1,851,959 105,075 11,949 2,070,138 50,876 156,272 8,163,913 8,286,541 99% safe - Flre EMS Capital 288 38,560 40,567 806,139 697,957 21,335 874,056 322,488 1,470,247 441,632 296,545 2,045,654 1,241,317 8,296,497 11,528,163 Hazmat 289 105 115 3,017 8,786 3,238 3,500 River Rescue 291 18,756 1,342 3,654 13,194 2,451 27,675 9,759 4,456 243 5,171 1,925 1,147 89,773 92,126 xxx xxx 0% 601 State Grant 210 11,492 Sub Total 57,317 41,909 809,897 711,150 23,901 904,748 332,248 1,474,703 441,875 301,716 2,047,579 1,242,463 8,389,507 11,623,789 Department of Community Investment 0460 Main Street Studebaker /Oliver 209 555 8,786 118,076 13,414 560 23,827 11,437 10,740 21,148 1,277 13,117 241,909 301,200 1,000,000 0% 601 State Grant 210 11,492 61,657 11,487 4,925 18,003 11,483 330,302 11,478 351,670 807,570 1,260,777 64% 39,892 CED Operating 211 166,430 164,291 237,247 175,425 177,448 163,661 166,317 223,857 165,353 172,300 172,804 183,000 2,168,132 2,354,331 92% 1001 Dept. of Community Investment 212 37,133 29,868 83,765 135,853 90,607 284,403 193,480 226,447 151,844 380,538 428,730 161,835 2,204,505 6,332,298 35% 1002 Dept. of Community Investment 212 7,787 18,775 9,459 2,910 19,446 1,115 1,557 1,557 224,570 83% 0465 Eddy Street Commons 601 90 NA 1003 Administration 212 143 95 30,580 2% xxx xxx xxx 238 2,565 9% xxx Programs 212 457,037 388,265 394,456 197,024 254,365 174,722 15,983 187,606 69,208 31,898 25,102 5,924 2,201,588 2,622,409 84% xxx xxx xxx 11,124 93,964 4,323 213,404 942,855 1,129,839 83% NA Sub Total 672,092 582,424 777,126 508,301 533,907 622,929 395,435 647,835 716,707 596,213 626,635 702,429 7,382,033 13,572,380 54% Parking Garages 0460 Main Street 601 40,451 555 8,786 118,076 13,414 560 23,827 11,437 10,740 21,148 1,277 13,117 241,909 301,200 80% 0461 St. Joseph 601 4,925 4,925 0462 Leighton Plaza 601 39,892 1,051 23,238 57,671 17,167 1,166 42,988 23,442 4,980 43,256 1,731 184,768 441,349 486,099 91% 0463 Enforcement 601 13,443 200 6,687 10,705 9,552 200 6,719 9,004 13,975 10,114 200 5,023 72,447 87,390 83% 0464 Wayne Street 601 424 436 26,824 67,062 21,816 7,787 18,775 9,459 2,910 19,446 1,115 10,497 186,550 224,570 83% 0465 Eddy Street Commons 601 90 400 110 600 30,580 2% xxx xxx xxx NA Sub Total 94,299 2,242 52,161 253,515 62,349 9,823 97,234 48,417 11,124 93,964 4,323 213,404 942,855 1,129,839 83% Capital /Debt Service Fame 313 633,500 634,500 1,268,000 1,268,000 100% 404 1,604,033 432,675 453,623 1,698,086 445,103 516,990 933,477 352,864 637,092 445,795 489,366 921,320 8,930,424 9,918,417 90% ital Develo ment 406 42 42 56,588 42 239,748 56,588 42 42 56,588 42 135,768 56,588 602,118 911,220 66% ital lm rovement 407 184,875 182,700 367,575 367,575 100% 408 1,474,544 100,752 98,334 1,991,851 70,876 98,350 2,914,570 107,618 117,004 150,185 581,343 221,933 7,927,361 8,993,379 88% VHalloffame tive Sewer 409 - - - - - - - - - - - - - - NA 410 268,146 0% oves 412 87,697 162,116 62,989 579,715 123,222 47,384 7,858 63,704 82,638 36,360 1,253,680 3,395,846 37% PAClm rovement 416 230 6,550 1,474 1,243 10,241 10,691 5,555 2,200 3,221 41,405 72,666 57% 434 36,975 836,975 415,000 458,949 873,949 53% istoric Preservation 450 20,470 20,470 21,000 97% Hall of Fame Ca ital 677 2,223 348 553 10,385 8,287 3,635 13,587 4,360 5,825 3,146 4,462 6,327 63,137 179,322 35% xxx xxx xxx NA Sub Total 3,936,420 628,065 610,572 3,863,722 837,245 1,255,278 4,812,789 1,354,797 826,566 662,871 1,296,797 847,997 20,933,119 26,269,520 80% Financial Report December 2013 - &p-dk- Summary Page 18 of 28 City of South Bend Period Ending: December 2013 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Other Miscellaneous Self Funded Liability Ins Excess Le 103 15,959 20,766 16,983 12,478 15,336 41,814 23,495 13,306 15,347 16,697 16,429 223,821 262,786 Liability Insurance NA Gift, Donation, Bequest 217 33,770 161,441 142,246 35,024 245,942 198,542 1,310 1,310 47,956 564,616 1,600,410 1,768,448 Business Insurance 10,752 0% Loss Recovery 227 6,625 16,033 4,880 6,000 12,998 10,475 27,550 24,907 10316 20,357 118,713 11,939 251,171 1,276,185 20% General Grant 250 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA Human Rights 258 10,686 11,706 15,927 17,604 11,848 18,850 20,799 17,494 12,244 22,887 12,200 25,293 197,537 266,308 74% Morris Palais Marketing 273 2,049 270,745 2,000 116,768 243,417 639,388 1,342 621 239 886 754 2,299,400 7,891 10,149 78% Economic Revenue Bond 281 1,987,680 2,125,583 2,629,053 2,328,652 2,263,958 25,915,960 27,660,237 19,795 6,821 60,517 27,132 0% ProfessionalSports Development 377 487,548 800 26,106 158,086 41,934 203,973 388,123 726,793 561,778 454,940 632,696 594,368 876,470 876,671 100% Building Operations 600 73,110 71,233 105,481 81,057 74,438 80,459 77,953 108,750 85,403 76,475 76,423 95,555 1,006,337 1,148,152 88% Century Center 670 185,479 217,733 244,571 218,796 233,991 301,804 57,773 470,380 272,748 508,130 358,536 292,656 3,362,598 3,547,459 95% C-hory Center Capital 671 95,231 257 95,230 30,637 161,859 192,495 246,770 78% xxx xxx xxx 1,371,000 195,888 1,329 991 1,453,324 195,888 3,218,420 3,229,957 NA Sub Total xxx 758,870 317,506 372,859 323,457 320,278 411,588 574,850 620,842 380,950 659,371 566,626 587,302 5,894,500 7,409,578 80% Insurance Self Funded Liability Ins 226 15,212 15,959 20,766 16,983 12,478 15,336 41,814 23,495 13,306 15,347 16,697 16,429 223,821 262,786 Liability Insurance 226 21,320 58,289 33,770 161,441 142,246 35,024 245,942 198,542 47,751 43,513 47,956 564,616 1,600,410 1,768,448 Business Insurance 226 19,087 11,853 14,625 6,625 12,847 6,625 363,812 12,998 6,625 6,625 12,847 1,254,582 474,568 493,693 Workers Compensation 226 202,349 58,626 32,028 72,301 30,915 11,724 31,155 35,710 20,608 51,283 165,917 58,343 770,961 1,066,000 xxx xxx 333,810 668,815 50% TIF Leighton Plaza 425 3,970 3,197 11,307 1,118 7,490 18,516 7,647 4,316 15,000 Sub Total xxx 257,968 144,726 101,190 257,351 198,486 68,708 682,723 270,745 88,290 116,768 243,417 639,388 3,069,761 3,590,927 y Trust & A enc Fire Pension 701 464,307 464,608 443,629 479,693 459,567 445,038 447,417 449,953 442,664 443,600 444,020 463,479 5,447,975 5,900,028 Police Pension 702 542 086 553,264 540,482 540,395 538,344 54Z040 536,439 545,829 53Z522 530,726 536,865 535,841 6,474,834 6,929,133 Employee Benefits 711 1,141,446 1,271,799 817,518 880,753 1,004,019 1,196,061 1,228,463 987,317 1,146,565 1,652,769 1,342,102 1,254,582 13,923,392 14,548,829 Unemployment Comp 713 5,422 9,728 6,734 5,664 6,296 5,089 1,536 4,581 2 714 1,958 5,665 10,057 65,443 267,247 City Cemetery Trust 730 333,810 668,815 50% TIF Leighton Plaza 425 3,970 3,197 11,307 1,118 7,490 18,516 7,647 4,316 15,000 xxx xxx 19,827 121,617 151,185 80% TIF Medical Service 426 233,051 57,906 11,201 171,858 43,938 111,071 127,063 128,803 Sub Total 380,064 2,153,261 2,299,400 1,808,364 1,906,504 2,008,226 2,188,227 2,217,052 1,987,680 2,125,583 2,629,053 2,328,652 2,263,958 25,915,960 27,660,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 22,337,715 17,671,235 20,493,934 26,508,842 25,499,434 253,993,298 318,523,075 80% Tax Increment Financing TIFAir ort 324 1,666,888 1,813,585 551,674 876,628 317,864 262,700 1,594,314 718,029 183,740 352,477 189,975 700,032 9,227,906 25,244,592 37% TIF Sample Ewing 414 - - - - - - - - - - - - - - NA TIF Central Development 420 48,684 1,278,115 51,308 237,795 39,520 48,560 53,090 1,281,364 35,984 361,709 231,702 29,643 3,697,473 5,302,102 70% TIF West Washington 422 90,126 105 237 18,127 27,484 41,972 96,240 25,879 6,258 27,591 333,810 668,815 50% TIF Leighton Plaza 425 3,970 4,267 11,307 8,306 7,490 18,516 7,647 4,871 16,407 8,691 10,321 19,827 121,617 151,185 80% TIF Medical Service 426 233,051 57,906 11,201 171,858 43,938 111,071 127,063 128,803 114,921 380,064 161,229 319,503 1,860,607 4,770,544 39% TIF Northeast 429 8,320 22,064 781 2,736 19,795 6,821 60,517 2,388,995 3% TIF Southside 430 123,533 143,219 26,106 158,086 41,934 203,973 709,340 726,793 561,778 454,940 632,696 594,368 4,376,767 6,122,885 71% TIF Erskine Commons 431 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA TIF Erskine Village 432 344,898 1,157 143,950 490,005 501,268 98% TIF Dou /as Road 435 95,231 257 95,230 190,718 454,782 42% Northeast Residential TIF 436 1,371,000 195,888 1,329 991 1,453,324 195,888 3,218,420 3,229,957 100% xxx xxx xxx NA Sub Total 3,890,468 3,610,169 655,358 1,452,672 469,864 672,304 4,133,437 3,051,330 938,709 1,779,822 1,260,335 1,663,372 23,577,840 48,835,125 48% Financial Report December 2013 - &pendk- Summary Page 19 of 28 City of South Bend Period Ending: December 2013 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Redevelo ment Funds 3,883,918 1,046,006 1,545,904 671,419 880,210 4,368,483 central Bond Proceeds 305 314 - - - - NA District Capital 2003 428 rport Debt Reserve 2003 315 981 382 NA Administration 433 470 384 3,272 1,673 5,798 6,787 85% Coveleski Bond Construction 438 19,389,106 26,568,463 ackthorn Debt Service 319 NA Certlfled Technology Park 439 - - - - - - - - - - - - - - NA Air ort Urban Enterprise Zone 454 329 361 777 304 386 525 356 226 418 5,959 6,000 NA Blackthorn Goff Operations 619 49,154 270,820 63,509 92,200 200,594 206,664 234,559 180,423 191,747 98,129 119,227 38,092 1,745,117 1,997,706 87% xxx xxx xxx 2929 327,139 562 577 1,243 487 617 839 569 361 NA Sub Total 0 49,154 270,820 63,509 92,670 200,978 206,664 234,559 183,695 191,747 99,801 119,227 38,092 1,750,915 2,004,493 87% e 3,883,918 1,046,006 1,545,904 671,419 880,210 4,368,483 3,235,641 Vic Improvement 1990 314 - - - - - - - - - - - - - - rport Debt Reserve 2003 315 981 382 197 216 465 182 231 314 213 135 250 3,567 5,000 rveleski Bond Debt Reserve 317 City Operations Total 25,610,410 20,274,135 19,389,106 26,568,463 ackthorn Debt Service 319 308 326,120 36 22,374,125 326,464 326,050 ?ntral Development reserve 328 1,640 638 329 361 777 304 386 525 356 226 418 5,959 6,000 X xxx 18,802,529 22,374,125 27,888,764 27,201,567 279,658,043 369,699,743 ib Total 0 2929 327,139 562 577 1,243 487 617 839 569 361 669 335,989 337,050 Redevelopment Commsssion 3,939,623 3,883,918 1,046,006 1,545,904 671,419 880,210 4,368,483 3,235,641 1,131,294 1,880,191 1,379,922 1,702,133 25,664,745 51,176,668 50% City Operations Total 25,610,410 20,274,135 19,389,106 26,568,463 17,621,865 19,367,141 28,986,582 25,573,356 18,802,529 22,374,125 27,888,764 27,201,567 279,658,043 369,699,743 76% Expenditure report 25,610,410 20,274,135 19,389,106 26,568,463 17,621,865 19,367,140 28,986,582 25,573,357 18,802,529 22,374,125 27,888,764 27,201,567 279,658,043 369,699,743 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report December 2013 - Expenditure Summary Page 20 of 28 City of South Bend Debt Schedule Period Ending; December 2013 Year of I Year of Year of Scheduled Payments Debt (Orig / Ref•) Debt at 2013 Principal 2013 Interest 2013 Debt at 2013 Total Debt Instrument Debt Purpose Issue Refunding maturity Fund list 2nd 3rd 4th Issue 12/31/2012 Pa menu Payment Addition 12/31/2013 Debt Pa menu Civil City Debt Bond Debt Amart scb k 3/ CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11,870,000.00 3,535,000.00 720,000.00 154,213.75 0.00 2,815,000.00 874,213.75 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1 - - 9,250,000.00 4,890,000.00 505,000.00 168,526.00 0.00 4,385,000.00 673,526.00 25 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 38 South Bend Building Corporation Fire HO / Police HO 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,W 67 4f Sewage Works Improvements Sewage Works 2004 2024 649 611 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 52 Sewage Works Revenue Bonds 2007B Sawage Works 2007 2027 649 6/1 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 U Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 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 69 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 eo 2010 Sawage 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 93 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 ss 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 101 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 fo52013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 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 116 2013 Building Corporation xxx EMS / Fire Department 2013 2033 288 2/1 8/1 - - 5,580,000.00 0.00 0.00 0.00 5,580,000.00 5,580,000.00 0.00 Total Bond Debt 225 632 000.00 146 037 021.00 8,780,425.00 5 057 644.26 12 399 302.00 149 655 898.00 13 838 069.26 Loans Payable 1 State Revolving Fund Bosch Property 2002 2022 210 1/30 10/30 - - 506,448.00 362,337.59 31,030.73 14,031.91 0.00 331,306.86 45,062.64 6e State Revolving Fund Water Works Improvement 2009 2030 625 1/1 7/1 - - 427,332.00 409,613.00 18,316.00 13,803.96 0.00 391,297.00 32,119.96 821nterfund Loan 410 -UDAG 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 44 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 26 State Revolving Fund Water Works Improvements 2000 2019 625 1/1 7/1 - - 2,600,000.00 1,172,267.00 153,452.00 33,996.00 0.00 1,018,815.00 187,448.00 Total Loans Pa able 35 533 780.00 13 417 190.59 671 395.73 61 831.87 (9,445,000.00) 3.300.794.86 733 227.60 Capital Leases 27 LaSalle Bank - Fire Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 0.00 0.00 0.00 0.00 sf Chase LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 894,298.74 164,040.38 36,539.33 0.00 730,258.36 200,579.71 5s Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 963,508.00 102,062.12 102,062.12 1,918.73 0.00 0.00 103,980.85 56 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 57 Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 586.30 586.30 10.52 0.00 0.00 596.82 5s Lanier Copier 915 Oil- 2008 2013 620 Monthly - - - 5,154.00 586.30 586.30 10.52 0.00 0.00 596.82 5e Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 408.66 408.66 6.29 0.00 0.00 414.95 67 Sun Trust Solid Waste Containers / Tmcks 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 71 Kansas State Bank Clark 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 Code 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 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 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 2128 5/30 8/30 11130 3,550.69 1,880.04 718.07 97.33 0.00 1,161.97 815.40 78 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 7s 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 87 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 as Sun Trust Police, Parks, Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12115 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 91 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 92 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 N Ikon Office Solutions Mayor Ricoh MP 2851 SP Copies 2011 2016 101 2115 5/15 8/15 11/15 2,569.53 2,102.03 481.88 106.60 0.00 1,620.15 588.48 95 Sun Trust 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 97 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 s8 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 fop 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 580,951.34 /o2 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 fo3 GE Capital Information Technology Fire Department Copier 2012 2017 101 2128 5/28 8/28 11/28 5,471.01 5,233.77 984.36 286.44 0.00 4,249.41 1,270.80 Jos Ricoh USA (New) 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 fo7 Ricoh USA StreeUSewer 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 foe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5112 8112 11/12 5,559.15 0.00 1,030.83 239.97 5,559.15 4,528.32 1,270.80 ms Ricoh USA Parks & Rep Ricoh Copiem(3) 2013 2018 201 2121 5/21 8/21 11121 16,129.94 0.00 2,991.45 695.79 16,129.94 13,138.49 3,687.24 110 PNC Equipment Finance Vehicle/Equipment Lease 2013 2018 1011202/406/641 1115 7115 - - 1,689,669.59 0.00 0.00 0.00 1,689,669.59 1,689,669.59 0.00 111 Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 0.00 1,973.36 618.64 10,667.67 8,694.31 2,592.00 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 0.00 239.19 73.81 4,093.64 3,854.45 313.00 113 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 - - 1,506,465.26 0.00 0.00 0.00 1,506,465.26 1,506,465.26 0.00 114 Ricoh USA Admin & Finance Copier 2013 2018 101 1116 4116 7116 10/16 11,247.97 0.00 1,627.06 301.37 11,247.97 9,620.91 1,928.43 115 CSI Leasing Inc 2010 Server IT Lease 2010 2014 404 211 5/1 8/1 11/1 28,588.00 13,314.67 7,444.93 607.87 0.00 5,869.74 8,052.80 117 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 0.00 0.00 301.37 9,678.26 9,678.26 301.37 118 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 0.00 0.00 301.37 5,647.50 5,647.50 301.37 fts Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copse 2013 2018 620 Monthly 16th 4,732.65 0.00 0.00 301.37 4,732.65 4,732.65 301.37 12o Water Works Olive Ricoh Copier xxx Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 0.00 0.00 301.37 4,732.65 4,732.65 301.37 Total Capital Lease 18 788 201.74 9,427,460.42 2.363.396.55 184 238.34 3,277,806.21 10 341 870.08 1 2547 634.89 Total Civil City 279,953,981.74 168,881,672.01 11,815,217.28 5,303,714.47 6,232,108.21 163,298,562.94 17,118,931.75 Financial RepW December 2013 -Debt Page 21 0/28 City of South Bend Debt Schedule Period Ending; December 2013 Year of I Year of Year of Scheduled Payments Debt long / Ran) Debt at 2013 Principal 2013 Interest 2013 Debt at 2013 Total Debt Instrument Debt Purpose Issue Refunding maturity Fund 1st 2ntl 3rd 4th Issue 12/31/2012 Pa menu Payment Addttion 12/31/2013 Debt Pa menu Redevelopment Commission Debt Bond Debt 9 Central Business TIF 1990 1996 2012 420 2J 1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 0.00 to Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 620,000.00 620,000.00 14,880.00 0.00 0.00 634,880.00 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2J 1 811 - - 6,825,000.00 2,505,000.00 435,000.00 55,100.00 0.00 2,070,000.00 490,100.00 a 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,777.50 0.00 5,285,000.00 1,267,777.50 t1 South Bend Building Corporation Morris PAC 1998 2009 2017 408 2J 1 811 - - 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 5 Downtown Central Area TIF 2003 2011 2024 420 2J 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 5 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 2J 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 sa 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 e1 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 as 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 too 2012 Gates Downtown Campus xxx VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 1,700,000.00 1,700,000.00 566,666.66 0.00 0.00 1,133,333.34 566,666.66 Total Bond Debt 139,420,000.00 91,030,000.00 7,906,666.66 4,243,049.50 0.00 83,123,333.34 12,149,716.16 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3122 6/22 9122 12122 1,040,000.00 538,508.13 56,486.72 15,523.72 0.00 482,021.41 72,010.44 4 Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 148,826.03 0.00 0.00 0.00 133,214.96 0.00 2 State Industrial Development Fund Bosch Property 2002 2017 210 411 10/1 - - 1,000,000.00 346,146.00 346,146.00 9,807.00 0.00 0.00 355,953.00 14 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 15 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 6130 12131 - - 75,000.00 21,428.60 0.00 0.00 0.00 10,714.32 0.00 I 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 tf3 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8115 - - 1,102,549.56 430,651.43 87,118.97 20,457.03 0.00 343,532.46 107,576.00 54 interfund 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 e3 Intertund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5115 6115 7115 8115 31,032.00 19,395.00 3,879.00 0.00 0.00 15,516.00 3,879.00 s4 in erfund 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 0.00 1,460,723.00 0.00 es Intertund Fund 412 -Major Moves Eddy Street Commons 2011 2026 436 1115 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 Interfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 8/9 - - - 500,000.00 500,000.00 0.00 0.00 0.00 500,000.00 0.00 ae Blackthom Loan from Airport xxx Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53,598.50 43,548.74 6,699.84 0.00 0.00 36,848.90 6,699.84 Total Loans Payable 22,058,511.06 10 062 053.88 1,606,010.73 358 300.88 0.00 8,429,717.80 1,964 311.61 Capital Lease 75 PNC Equipment Financing xbc Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 156,390.32 49,587.52 6,833.48 0.00 106,802.80 56,421.00 Total Capital Lease 246 509.64 156 390.32 49 587.52 6,833.48 0.00 106 802.80 56 421.00 Leases 37 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 13 Transpo Lease xxx 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 123,429.00 0.00 1 2,160,211.00 1 400,000.00 Total Redevelopment Commission 167,235,298.70 103,685,226.20 1 9,838,835.91 4,731,612.86 0.00 93,820,064.94 1 14,570,448.77 Total Debt 0 447,189,280.44 272,566,898.21 21,654,053.19 10,035,327.33 6,232,108.21 257,118,627.88 31,689,380.52 Financial Repot December 2013 -Debt Page 22 0/28 City of South Bend Period Ending; December 2013 Monthly Debt Schedule Year of I Year of Year of Scheduled Payments Debt long / Ref•) Debt at YTD Principal YTD Interest YTD Debf at Debt Instrument Debt Purpose Issue Refundin Maturi Fund 1st 2nd 3rd 4th Issue 12/31/2012 Pa ments Payments Addttions 1T/31/2013 Civil City Debt Bond Debt Arran wi, k of CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11,870,000.00 3,535,000.00 720,000.00 154,213.75 0.00 2,815,000.00 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 2/1 8/1 - - 9,250,000.00 4,890,000.00 505,000.00 168,526.00 0.00 4,385,000.00 25 Water Works Improvements Water Works 2002 2012 2023 625 711 12131 - - 5,975,000.00 3,785,000.00 335,000.00 82,428.89 0.00 3,450,000.00 38 South Bend Building Corporation Fire HO / Police HO 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 41 Sawage Works Improvements Sewage Works 2004 2024 649 611 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 195,000.00 163,726.00 0.00 3,505,000.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 4o Sawage 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 52 Sewage Works Revenue Bonds 2007B Sawage Works 2007 2027 649 6/1 12/1 - - 16,515,000.00 13,615,000.00 655,000.00 577,741.26 0.00 12,960,000.00 62 Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11/1 - - 4,655,000.00 4,165,000.00 175,000.00 215,213.00 0.00 3,990,000.00 69 Water Works Improvements Water Works 2009 2030 625 7/1 12131 - - 5,380,000.00 5,185,000.00 200,000.00 278,432.00 0.00 4,985,000.00 7o Sewage Works Revenue Bonds -2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3,297,000.00 2,822,021.00 145,425.00 80,262.00 34,302.00 2,710,898.00 eo 2010 Sawage 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 93 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 ss 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 101 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 fo52013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14,765,000.00 0.00 1,065,000.00 171,864.60 14,765,000.00 13,700,000.00 116 2013 Building Corporation xxx EMS / Fire Department 2013 2033 288 2/1 8/1 - - 5,580,000.00 0.00 0.00 0.00 5,580,000.00 5,580,000.00 Total Bond Debt 225 632 000.00 146 037 021.00 8,780,425.00 5 057 644.26 12 399 302.00 149 655 898.00 Loans Payable 1 State Rev olvng Fund Bosch Property 2002 2022 210 1/30 4/30 7/30 10/30 506,448.00 362,337.59 31,030.73 14,031.91 0.00 331,306.86 6e State Revolving Fund We Works Improvement 2009 2030 625 711 12131 - - 427,332.00 409,613.00 18,316.00 13,803.96 0.00 391,297.00 82 Intedund Loan 410 - UDAG list Source/Marriott Garage 2010 2015 410 6/15 12115 - - 2,700,000.00 2,027,973.00 0.00 0.00 0.00 2,027,973.00 44 State Revolving Fund Sewage Works Improvement 1998 2018 649 611 1211 - - 24,095,000.00 9,445,000.00 0.00 0.00 (9,445,000.00) 0.00 26 State Revolving Fund xxx Water Works Improvements 2000 2019 625 7/1 12/31 - - 2,600,000.00 1,172,267.00 153,452.00 33,996.00 0.00 1,018,815.00 Total Loans Pa able 35 533 780.00 13 417 190.59 202 798.73 61 831.87 (9,445,000.00) 3,769,391.86 Capital Leases 27 LaSalle Bank - Fire Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 0.00 0.00 0.00 sf Chase LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 894,298.74 164,040.33 36,539.33 0.00 730,258.41 5s 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 56 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 5s Lanier Copier 915 Oil- 2008 2013 620 Monthly - - - 5,154.00 586.30 586.30 10.52 0.00 0.00 5e Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 408.66 408.66 6.29 0.00 0.00 67 Sun Trust Solid Waste Containers/ Tmcks 2009 2014 611 3/1 9/1 - - 720,990.00 230,257.00 152,089.72 7,144.86 0.00 78,167.28 71 Kansas State Bank Clark 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 n Kansas State Bank Code 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 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 2,501.06 148.18 0.00 651.47 74 CSI Leasing Inc IT Netapp San 2010 2014 404 4/1 7/1 10/1 12/31 207,521.37 69,136.85 54,900.44 2,887.56 0.00 14,236.41 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 n GE Capital Information Technology Animal Control Copier 2010 2015 101 2/28 5/30 8/30 11130 3,550.69 1,880.04 718.07 97.33 0.00 1,161.97 7e Kansas State Bank Mayor Des 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 7s 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 87 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 as Sun Trust Police, Parks, Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2,068,202.00 1,468,556.77 409,515.93 25,449.47 0.00 1,059,040.84 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 s1 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.41 142.31 0.00 2,065.69 s2 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 s4 Ikon Office Solutions Mayor Ricoh MP 2851 SP Copies 2011 2016 101 2115 5/15 8/15 11/15 2,569.53 2,102.03 481.88 106.60 0.00 1,620.15 s5 Sun Trust Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 302,832.89 84,802.23 4,520.25 0.00 218,030.66 s7 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 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 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 foe 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. GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11128 5,471.01 5,233.77 984.36 286.44 0.00 4,249.41 foe Ricoh USA Central Services Copier 2013 2018 222 2127 5127 8127 11/27 3,622.78 0.00 618.14 221.64 3,622.78 3,004.64 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 toe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5112 8112 11/12 5,559.15 0.00 1,030.83 239.97 5,559.15 4,528.32 fos Ricoh USA Parks & Rep Ricoh Copieni 2013 2018 201 2121 5/21 8/21 11121 16,129.94 0.00 2,991.45 695.79 16,129.94 13,138.49 fto INC Equipment Finance Vehicle/Equipment Lease 2013 2018 1011202/406/641 1115 7115 - - 1,689,669.59 0.00 0.00 0.00 1,689,669.59 1,689,669.59 111 Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 0.00 1,973.36 618.94 10,666.67 8,694.31 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 0.00 239.17 73.81 4,093.64 3,854.47 113 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 - - 1,506,465.26 0.00 0.00 0.00 1,506,465.26 1,506,465.26 114 Ricoh USA Admin & Finance Copier 2013 2018 101 1116 4116 7116 10/16 11,247.97 0.00 1,627.06 301.37 11,247.97 9,620.91 115 CSI Leasing Inc 2010 Server IT Lease 2010 2014 404 211 5/1 8/1 11/1 28,588.00 13,314.67 7,444.93 607.87 0.00 5,869.74 117 Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 0.00 0.00 301.37 9,678.26 9,678.26 118 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 0.00 0.00 301.37 5,647.50 5,647.50 fts Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copie 2013 2018 620 Monthly 16th 4,732.65 0.00 0.00 301.37 4,732.65 4,732.65 12o Water Works Olive Ricoh Copier Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 0.00 0.00 301.37 4,732.65 4,732.65 Total Ca ita /Lease 18,788,201.74 9,427,460.42 2,363,396.44 184,238.68 3,277,805.21 10,341,870.19 Total Glvll city 279,953,961.74 1156,661,672.01 I 11,34i,bZU.17 5,303,714.61 15,232,107.21 163,767,16U.05I Financial RepW December 2013 -Debf Page 23 0/28 City of South Bend Period Ending; December 2013 Monthly Debt Schedule Year of I Year of Year of Scheduled Payments Debt long / Ran) Debt at YTD Principal YTD Interest YTD Debf at Debt Instrument Debt Purpose Issue Refunding maturity Fund 1st 2ntl 3rd 4th Issue 12/31/2012 Pa ments Payments Addttions 17/31/2013 Redevelopment Commission Debt Bond Debt 9 Central Business TIF 1990 1996 2012 420 2J 1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 to Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 620,000.00 620,000.00 14,880.00 0.00 0.00 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2J 1 811 - - 6,825,000.00 2,505,000.00 435,000.00 55,100.00 0.00 2,070,000.00 s 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,777.50 0.00 5,285,000.00 tI South Bend Building Corporation Morris PAC 1998 2009 2017 408 2J 1 811 - - 13,300,000.00 4,270,000.00 890,000.00 148,325.00 0.00 3,380,000.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 5 Downtown Central Area TIF 2003 2011 2024 420 2J1 811 - - 19,795,000.00 17,230,000.00 1,110,000.00 805,754.50 0.00 16,120,000.00 5 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 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2J 8/1 - - 5,485,000.00 4,660,000.00 195,000.00 293,847.50 0.00 4,465,000.00 sa 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 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 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 too 2012 Gates Downtown Campus xxx VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 - - 1,700,000.00 1,700,000.00 566,666.66 0.00 0.00 1,133,333.34 Total Bond Debt 11111111F 139,420,000.00 91,030,000.00 7,906,666.66 4,243,049.50 0.00 83,123,333.34 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3122 6/22 9122 12122 1,040,000.00 538,508.13 56,486.72 15,523.72 0.00 482,021.41 4 Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 148,826.03 0.00 0.00 0.00 133,214.96 2 State Industrial Development Fund Bosch Property 2002 2017 210 411 10/1 - - 1,000,000.00 346,146.00 346,146.00 9,807.00 0.00 0.00 14 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 is Indiana Development Finance Authority Frederickson Park (Forgive) 2003 2012 404 - - - - 191,202.40 0.00 0.00 0.00 0.00 0.00 15 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 11 Indiana Development Finance Authority Anchor (Forgive) 2005 2014 404 - - - - 75,000.00 21,428.60 0.00 0.00 0.00 10,714.32 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 tf3 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8115 - - 1,102,549.56 430,651.43 87,118.97 20,457.03 0.00 343,532.46 54 interfund 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 b3 Intertund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5115 6115 7115 8115 31,032.00 19,395.00 3,879.00 0.00 0.00 15,516.00 ea Intedund Fun d 412 - Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2,000,000.00 1,460,723.00 0.00 0.00 0.00 1,460,723.00 es Intertund 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 ss Interfund Fund 209 to Airport 324 Prairie Ave Brownfield Project 2011 2020 324 8/9 - - - 500,000.00 500,000.00 0.00 0.00 0.00 500,000.00 ae Blackthom Loan from Airport xxx Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53,598.50 43,548.74 6,699.84 0.00 0.00 36,848.90 Total Loans Payable 22,058,511.06 10 062 053.88 1,606,010.73 358 300.88 0.00 8,429,717.80 Capital Lease 75 PNC Equipment Financing xbc Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 156,390.32 49,587.52 6,833.48 0.00 106,802.80 Total Capital Lease 246 509.64 156 390.32 49 587.52 6,833.48 0.00 106 802.80 Leases 37 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 13 Transpo Lease Xxx 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 Total Lease 5,510,278.00 2,436,782.00 1 276,571.00 123,429.00 0.00 2,160,211.00 Total Redevelopment Commission 167,235,298.70 103,685,226.20 1 9,838,835.91 4,731,612.86 0.00 93,820,061 Total Debt 0 447,189,280.44 272,566,898.21 21,185,456.08 10,035,327.67 6,232,107.21 257,587,224.99 Financial Repot December 2013 -Debf Page 24 0/28 City of South Bend Staffing Headcount Summary Budget Prior Full Time Jan Feb Mar Apr 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 1131.00 1130.00 1125.00 1129.00 1131.00 1133.00 Part Time Staff 71.00 76.00 75.00 76.00 78.00 76.00 82.00 80.00 76.00 75.00 74.00 76.00 0.00 Temporary /Seasonal 107.00 96.00 136.00 181.00 244.00 339.00 348.00 344.00 244.00 247.00 210.00 160.00 0.00 City Total 1302.00 1294.00 1337.00 1393.00 1447.00 1540.00 1560.00 1555.00 1450.00 1447.00 1413.00 1367.00 1133.00 Financial Report December 2013 - Headcount Staffing Page 25 of 28 City of South Bend Staffing Headcount Full Time Staff Amended Budget Prior General Government 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 13.00 Maintenance 45.00 Mayor 7.00 5.00 5.00 6.00 7.00 7.00 7.00 6.00 6.00 6.00 6.00 6.00 6.00 7.00 10.00 311 Call Center 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 0.00 25.00 Admin & Finance 21.00 19.00 19.00 19.00 19.00 19.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 18.00 20.00 Safety & Risk 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 0.00 Clerk 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 1.00 Common Council 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 1.00 L al De attment 10.00 8.00 7.00 8.00 9.00 10.00 10.00 10.00 9.00 10.00 10.00 10.00 10.00 9.00 112.00 Sub Total 60.00 54.00 53.00 55.00 57.00 58.00 59.00 58.00 57.00 58.00 58.00 58.00 58.00 51.00 Code Enfor. /Animal Control 15.00 26.00 26.00 25.00 25.00 25.00 25.00 24.00 25.00 24.00 24.00 24.00 24.00 24.00 25.00 Dept. of Community Investment 26.00 24.00 25.00 26.00 25.00 24.00 24.00 24.00 25.00 26.00 26.00 26.00 26.00 25.00 Parks & Recreation 28.00 28.00 28.00 28.00 27.00 26.00 27.00 26.00 26.00 26.00 23.00 Street Operations Administration 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 11.00 13.00 Maintenance 45.00 44.00 43.00 43.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 44.00 43.00 44.00 Golf Operations 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 11.00 Recreation Ops/ 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 24.00 25.00 25.00 25.00 23.00 Zoological Ops 23.00 21.00 20.00 20.00 20.00 19.00 19.00 20.00 21.00 21.00 22.00 22.00 22.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 1.00 1.00 1.00 1.00 1.00 1.00 Recreation Nonreverting 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 Sub Total 116.00 113.00 111.00 111.00 112.00 111.00 111.00 112.00 113.00 112.00 114.00 114.00 113.00 114.00 Public Safety Police 297.00 292.00 290.00 290.00 289.00 284.00 284.00 290.00 290.00 291.00 288.00 291.00 291.00 293.00 Communications 38.00 34.00 35.00 38.00 38.00 38.00 36.00 35.00 38.00 36.00 35.00 33.00 33.00 35.00 Fire 257.00 249.00 249.00 247.00 256.00 255.00 255.00 255.00 255.00 255.00 255.00 255.00 255.00 258.00 Sub Total 592.00 575.00 574.00 575.00 583.00 577.00 575.00 580.00 583.00 582.00 578.00 579.00 579.00 586.00 Public Works Central Services 44.00 42.00 42.00 42.00 41.00 40.00 41.00 42.00 41.00 41.00 40.00 42.00 43.00 41.00 Engineering 15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00 14.00 13.00 13.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 26.00 27.00 26.00 26.00 26.00 23.00 Street Operations 60.00 58.00 59.00 60.00 60.00 57.00 59.00 59.00 59.00 58.00 58.00 60.00 60.00 58.00 Sewer Operations 35.00 34.00 34.00 34.00 34.00 34.00 33.00 33.00 33.00 33.00 33.00 33.00 34.00 34.00 Waste Water Ops 47.00 46.00 46.00 46.00 46.00 46.00 46.00 46.00 46.00 46.00 45.00 45.00 45.00 49.00 Organic Resources 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 0.00 Water Utilit Ops 70.00 70.00 71.00 69.00 70.00 70.00 70.00 69.00 69.00 68.00 69.00 69.00 70.00 74.00 Sub Total 305.00 299.00 301.00 300.00 300.00 296.00 298.00 297.00 295.00 294.00 291.00 294.00 297.00 299.00 Building Department 15.00 13.00 13.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 13.00 Human Rights 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 Morris & Palais 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 City Total 1160.00 1124.00 1122.00 1126.00 1136.00 1125.00 1125.00 1130.00 1131.00 1130.00 1125.00 1129.00 1131.00 1133.00 Financial Report December 2013 - Headcount Staffing Page 26 of 28 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 Department 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 1.00 0.00 0.00 0.00 1.00 0.00 Clerk Common Council Legal Department 2.00 2.00 2.00 2.00 2.00 2.00 4.00 4.00 4.00 4.00 4.00 4.00 5.00 Sub Total 3.00 3.00 3.00 3.00 3.00 3.00 5.00 5.00 4.00 4.00 4.00 5.00 5.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 1.00 1.00 1.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Administration 5.00 5.00 5.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 5.00 7.00 Maintenance 3.00 3.00 4.00 4.00 6.00 6.00 6.00 6.00 4.00 4.00 4.00 3.00 3.00 Golf Operations 0.00 4.00 2.00 2.00 3.00 3.00 3.00 3.00 3.00 3.00 1.00 1.00 0.00 Recreation Ops 31.00 31.00 31.00 32.00 31.00 30.00 32.00 32.00 30.00 30.00 30.00 31.00 33.00 Zoological Ops 6.00 6.00 8.00 8.00 8.00 9.00 9.00 7.00 7.00 6.00 7.00 7.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 4.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 52.00 48.00 47.00 46.00 47.00 48.00 Police 5.00 5.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Communications 0.00 Fire 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Sub Total 6.00 6.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 Central Services 1.00 0.00 Engineering 3.00 3.00 3.00 3.00 3.00 3.00 4.00 4.00 4.00 4.00 4.00 4.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 2.00 2.00 2.00 2.00 2.00 1.00 Street Ops 4.00 4.00 4.00 4.00 5.00 4.00 5.00 5.00 5.00 5.00 4.00 4.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 1.00 1.00 1.00 1.00 1.00 1.00 Sub Total 10.00 11.00 11.00 11.00 12.00 10.00 12.00 12.00 12.00 12.00 11.00 11.00 9.00 0.00 0.00 4.00 4.00 4.00 4.00 3.00 3.00 3.00 3.00 4.00 4.00 5.00 5.00 4.00 City Total 71.00 76.00 75.00 76.00 78.00 76.00 82.00 80.00 76.00 75.00 74.00 76.00 74.00 Financial Report December 2013 - Headcount Staffing Page 27 of 28 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 1.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 4.00 3.00 3.00 2.00 2.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 Le al 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.00 Sub Total 2.00 3.00 3.00 3.00 5.00 4.00 4.00 4.00 3.00 3.00 2.00 2.00 4.00 Code Enforcement 1.00 0.00 0.00 0.00 1.00 3.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Dept. of Community Investment 2.00 3.00 2.00 Sub Total 12.00 13.00 12.00 15.00 26.00 39.00 38.00 31.00 24.00 38.00 Parks & Recreation 21.00 23.00 Administration 5.00 5.00 6.00 8.00 8.00 7.00 6.00 5.00 5.00 5.00 5.00 5.00 3.00 Maintenance 11.00 4.00 8.00 23.00 34.00 42.00 45.00 44.00 30.00 30.00 28.00 17.00 8.00 Golf Operations 2.00 1.00 28.00 39.00 47.00 50.00 51.00 51.00 51.00 49.00 26.00 2.00 3.00 Recreation Ops 44.00 39.00 31.00 44.00 50.00 140.00 143.00 133.00 54.00 53.00 59.00 65.00 55.00 Zoological Ops 2.00 2.00 21.00 21.00 32.00 36.00 42.00 35.00 32.00 24.00 11.00 5.00 4.00 Greenhouse Ops 0.00 Graffiti Removal 1.00 1.00 2.00 2.00 1.00 1.00 1.00 1.00 2.00 2.00 2.00 1.00 1.00 Sub Total 65.00 52.00 96.00 137.00 172.00 276.00 288.00 269.00 174.00 163.00 131.00 95.00 74.00 Public Safety Police 27.00 27.00 24.00 24.00 36.00 15.00 15.00 37.00 41.00 41.00 41.00 41.00 24.00 Communications 0.00 Fire 0.00 0.00 0.00 0.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 Sub Total 27.00 27.00 24.00 24.00 37.00 16.00 16.00 38.00 41.00 41.00 41.00 41.00 24.00 Public Works Central Services 0.00 0.00 0.00 0.00 0.00 1.00 1.00 1.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 2.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 10.00 9.00 10.00 9.00 8.00 10.00 Street Ops 2.00 3.00 2.00 5.00 5.00 9.00 9.00 8.00 6.00 2.00 0.00 0.00 2.00 Sewer Ops 7.00 7.00 7.00 6.00 6.00 6.00 6.00 6.00 6.00 5.00 5.00 5.00 7.00 Leaf Pickup 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18.00 18.00 2.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 1.00 4.00 3.00 3.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 1.00 1.00 1.00 1.00 1.00 Water Utilit Ops 0.00 0.00 0.00 0.00 3.00 4.00 3.00 3.00 2.00 2.00 2.00 3.00 2.00 Sub Total 12.00 13.00 12.00 15.00 26.00 39.00 38.00 31.00 24.00 38.00 35.00 21.00 23.00 Building Department 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 344.00 244.00 247.00 210.00 160.00 125.00 Financial Report December 2013 - Headcount Staffing Page 28 of 28