The URL can be used to link to this page

Home My WebLink About01-2014 Financial ReportPeriod Ending: Issued BY: January 2014 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 Deputy Mayor Chief of Staff Deputy Chief of Staff Controller City Finance Director Financial Specialist Senior Department Heads Fiscal Officers City Common Council Pete Buttigieg Mark Neal Kathryn Roos Brian Pawlowski John Murphy Rahman Johnson Cecil Eastman Financial Report January 2014 Page 1 of 28 January 2014 Revenue by type For discussion on property taxes, see section listed below. The overall percentage of budgeted revenues that have been received by the city is 5 %. In comparison, the collected revenue amount for January 2013 was 5% overall of budgeted revenues. Revenue type 344 (State Grants), has reached 100% of its budgeted revenue. This is 911 revenue received by the county. This was formerly in the general fund and is now in fund 244 the Telephone Emergency System. Revenue by fund As of January 2014, the general fund has received 2% of its budgeted revenue versus 5% last year. Some following funds have reached 50% of their 2014 budgeted revenue amount: Fund 642 (Sewage Capital) is at 55% of its budgeted revenue. This month, a transfer from fund 641 was made for capital projects. Also in January, a transfer was made from fund 641 (Sewage Works Operations) to fund 643 (Sewage Reserve) per city policy. Fund 244, the Telephone Emergency System has reached 100% of its budgeted revenue. This is 911 revenue received by the county. This was formerly in the general fund. Property taxes Property taxes are received in June and December. Information on property taxes payable in 2014 will be available in the coming months. Total property taxes collected for the year 2012 was $72.9 million or 91.56% of the levy collection rate. For 2013, the projected levy collection rate is 95 %. The first distribution amount received was in June 2013 for $38.4 million compared to $39.5 million in June 2012. The second distribution amount was received in December 2013, in the amount of $31.5 million compared to $33.3 million in December 2012. Specifically, in 2013 the City of South Bend received a total of $45,189,966.17 in property tax revenue in the civil city funds (general fund, parks, College Football Hall of Fame, and CCD). This is a shortfall of -$3.7 million compared to 2012, in which $48.8 million was received. For TIF funds, the City received a total of $24,790,321.99 in property tax revenue. This is a surplus of $729,194 as compared to 2012, in which $24,061,128 was received. Overall, total property taxes collected in 2013 is -$70.0 million, which is a net reduction of $2.9 million from 2012. Information on property taxes payable in 2014 will be available in the coming months. Expenditures As of January 2014, the City has spent 8% of budgeted expenditures compared to 7% of budgeted expenditures in January 2013. The General Fund has spent 10% of its 2014 budgeted expenditures, compared to 7% in 2013. The following funds have reached 50% or more of their budgeted expenditures as a result of bond payments: Fund 313 (Hall of Fame), fund 407(Cumulative Capital Improvement), fund 377 ( Professional Sports Development), and fund 432 (TIF - Erskine Village). Debt In January, several debt service payments were made in the amount of - $2.4 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. Headcount The Full Time Headcount as of January 31, 2014 was 1,116 vs. a budgeted amount of 1,157. Currently, there is a total of 41 open positions. The open positions are in Parks (21), Public Safety (11), Public Works (6), and other (6). City of South Bend Period Ending: January 2014 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et Property Tax 312 CREED Tax 312 Auto Excise Tax 311 Pro a Tax Civil City various 2,504,793 0% 45,307,800 0% 311 Pro a Tax TIF Districts various 0% 312 Financial Institutions Tax 26,325,126 0% 311 Pro a Tax Civil City - Prior various 317 Hotel Motel Tax Century Center 670 1,313,436 NA 311 Property Tax TIF Districts - Prior various 420 401,000 0% NA xxx xxx xxx 150,000 0% 377 NA Sub Total NA xxx xxx 71,632,926 0% Income Tax xxx xxx xxx 204,221 NA 315 Econ Development Income Tax -Prh 102 101 136,239 1,588,824 0% NA 315 Econ Development Income Tax 408 733,068 733,068 8,796,821 8% 316 Local Option Income Tax -PS 249 531,669 531,669 6,380,029 8% 316 County Option Income Tax 404 720,484 720,484 8,645,811 8% 316 County Option Income Tax -Prior Yr 102 various 4,314,974 4,314,974 NA Sub Total 1,985,222 1,985,222 23,822,661 8% St Joseph Count Remitted b 312 CREED Tax 312 Auto Excise Tax various 2,504,793 0% 312 Commercial Vehicle Tax van.ous 882,628 0% 312 Financial Institutions Tax van.ous 35,000 NA 317 Hotel Motel Tax Century Center 670 1,313,436 0% 317 Hotel Motel Tax Century Center 420 401,000 0% 317 Hotel Motel Tax Cum Cap Im ry 407 150,000 0% 377 66,547 335 Century Center NA xxx xxx xxx 202 NA xxx xxx xxx 204,221 NA 342 EMS County Contract 101 136,239 1,588,824 0% xxx xxx xxx 4,632,222 NA Sub Total 136,239 136,239 6,840,681 2% State of Indiana (Remitted by) 312 CREED Tax 434 decal Drug 335 Cigarette Tax 1011407 235,157 335 State Pension Subsidy 7011702 216 335 CTP Distribution 439 35,000 335 Gaming Proceeds 101 377,765 335 Gasoline Tax 2021251 337,414 335 Liquor Excise tax 101 13,419 335 Liquor Gallonage Tax 101 55,845 335 Prof Sports Development Tax 377 66,547 335 Century Center 671 47,661 335 Wheel Tax 202 K xxx xxx xxx 204,221 Sub Total b Total 459,805 governmental Sources decal Drug 299 226 235,157 75,000 ite Drug 216 340 General Government Misc Ch s 101 35,000 yment in Lieu of Tax various 377,765 377,765 4,533,175 ntractual Service 211 13,419 13,419 198,800 nds various 151,160 2,600,000 21,000,000 nd premium 6611623 47,661 47,661 619,002 K XXX 222 204,221 204,221 b Total 8% 391,184 391,184 25,841,975 Charge for Service Internal City 340 Liability Insurance 226 235,157 235,157 2,859,690 8% 340 General Government Misc Ch s 101 NA 340 Police Take Home Vehicle 278 7,160 7,160 60,580 12% 342 EMS Capital 288 151,160 151,160 2,600,000 6% 349 Central Service 222 47,661 47,661 619,002 8% 380 Central Service 222 204,221 204,221 2,545,960 8% 380 Energy Office Reimbursements 222 417,066 417,066 4,632,222 9% 380 Internal Service Reimbursement various 138,730 138,730 2,156,750 6% 392 Administration Fee 101 289,249 289,249 3,470,989 8% 392 Internal Fund Transfers various 4,314,974 4,314,974 26,031,652 17% 395 Employee Benefits various 946,856 946,856 13,621,548 7% Financial Report January 2014 - Revenue Report Page 3 028 City of South Bend Revenue by Type Report Period Ending: January 2014 S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et 396 Central Service Refunds 222 1,763 1,763 22,000 8% 396 Self Funded Employee Benefits 711 NA xxx xxx xxx NA Sub Total 6,753,998 6,753,998 58,620,393 12% 3rd Party Revenue 340 ND EMS Service 101 90,000 0% 340 Memorial Hospital Neo Natal 101 40,938 40,938 365,000 11 350 Job Target Penalty Fee 408 354,660 0% 364 Cable TV Franchise Fees 101 750,000 0% 366 AT&T Franchise Fees 101 202,000 0% 380 Loss Recovery 227 401,142 NA 380 Bosch Reimbursement /DCI 324 NA Sub Total 40,938 40,938 1,761,660 2% Grants 331 Federal Grants various 186,142 186,142 4,518,787 4% 334 State Grants various 215,000 215,000 215,000 100% 360 UDAG 410 NA xxx xxx NA Sub Total 401,142 401,142 4,733,787 8% Fees foi 320 321 321 322 322 322 322 341 342 342 343 344 344 344 344 344 346 346 346 347 347 347 349 349 349 349 351 352 354 360 360 360 360 360 360 360 Financial Report January 2014 - Revenue Report Page 4 028 City of South Bend Period Ending: January 2014 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Bud et of Bud et 360 Centu Center 670 1,805 1,805 45,000 4% 360 Code 1011600 46 46 1,000 5% 360 Cumulative Capital Improvement 4061407 1,500 le of Fixed Assets various NA 360 Dept. Of Community Investment 2111212 various 1,000 283,000 0% 360 Stud. /Oliver Rev. Grants 209 b Total 300,000 0% 360 EMS Capital 288 59 59 16,000 0% 360 Engineering/ Curb & Sidewalk 101 89 89 22,000 0% 360 Fire 701 NA 360 Police Pension Fund 702 4,000 0% 360 General Government Various 101131226 1,100 0% 360 P -Card Commissions 101 80,000 0% 360 General SBCDA Account 420 NA 360 Hall of Fame 3131677 NA 360 Motor Vehicle Highway 202 NA 360 Motor Vehicle Highway Scrap Meta 202 4,000 0% 360 Motor Vehicle Highway Curb Pr gm 202 6,563 6,563 25,000 26% 360 Parking Garage Fund 601 275 275 NA 360 ProfessionalSports Development 377 34,608 34,608 74,228 47% 360 Solid Waste Fund 610 1,000 0% 360 Waste Water 6411719 2,621 2,621 24,620 11% 360 Sewage Depreciation Fund 642 NA 360 Streets Scrap Metal Sale 101 NA 360 Water Works Utility 620 31,554 31,554 39,580 80% 362 General Fund 101 NA 362 Dept. Of Community Investment 212 1,847 1,847 NA 362 Palais Royale 101 2,490 2,490 84,000 3% 362 Parks & Recreation 201 1,329 1,329 43,900 3% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 14,675 14,675 201,951 79/ 362 UDAG 410 NA 369 Memorial Hosp Leighton Plaza 408 150,000 0% 371 Century Center Fees 670 90,135 90,135 3,031,462 3% 399 Bosch Retention Project 210 58,203 0% 399 Principal on Loan various 19,196 19,196 195,349 10% 399 Principal Income xxx 556,798 0% xxx xxx xxx NA Sub Total 4,937,828 4,937,828 70,123,276 7% Dine nk Account Interest various 32,479 32,479 992,030 K xxx K xxx b Total 32,479 32,479 992,030 I Contribution 101 330,000 nations van.ous 268 268 32,740 K XXX b Total 268 268 362,740 enervation lais 450 1,796 1,796 16,000 ,neral Fund 101 _ _ _ _ _ _ _ _ _ _ _ _ _ _ K xxx b Total 1, 796 1,796 16,000 ets 420/324 eter Hydrant Reimbursement 620 20,000 oceeds F.A. Disposal 600 1,500 le of Fixed Assets various 12,000 hicle Damage Reimbursement various 1,000 K XXX b Total 34,500 Revenue Total 15,140,898 - - - - - - - - - - - 15,140,898 287,194,697 511 report 15,140, 898 15,140,898 287,194, 697 Financial Report January 2014 - Revenue Report Page 5028 City of South Bend Revenue by Fund Report Period Ending: January 2014 s i Fund Jan Feb I Mar I A r I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Bud et I ofeud et General Government 0000 General Revenues 101 831,705 831,705 51,660,458 2% 0101 Mayor 101 227 227 600 38% 0104 311 Call Center 101 26,509 26,509 480,077 6% 0201 Clerk 101 NA 0301 Common Council 101 41 41 8,300 0% 0401 Controller 101 80,050 0% 0501 Legal 101 15 15 72,350 0% xxx xxx NA Sub Total 858,496 858,496 52,301,835 2% Public Works 0600 Energy Office 101 NA 0602 Engineering 101 115 115 6,100 2% 0606 Building Maintenance 101 NA 0607 Traffic & Lighting 101 NA xxx xxx NA Sub Total 115 115 6,100 2% Public Safety 0801 Police 101 38,053 38,053 337,700 11 0802 Police Communications 101 NA 0805 Police -PS LOIT funded 101 NA 0901 Fire 101 41,063 41,063 1616,000 3% 0905 Fire-PS LOIT funded 101 NA Sub Total 79,116 79,116 1953,700 4% Code Enforcement 1201 Code 101 NA 1203 Code Hearing 101 NA 1204 Code Junk Vehicle 101 NA 1205 Code Unsafe Building 101 2 150 2,150 NA 1207 Code Animal Control 101 NA xxx xxx NA Sub Total 2,150 2,150 NA Arts 8 Culture 0404 Morris PAC 101 56,152 56,152 882,000 6% 0405 Palais Royale 101 29,101 29,101 309,981 9% xxx xxx NA Sub Total 85,253 85,253 1,191,981 7% Human Rights 1008 Human Rights 101 NA xxx xxx NA Sub Total NA General Fund Revenue Total 1,025,130 - - - - - - - - - - - 1,025,130 55,453,616 2% Financial Report January 2014 - &p -dit- Summary Page 6 of 28 City of South Bend Revenue by Fund Report Period Ending: January 2014 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I of8ud et Parks & Recreation 0000 Parks General revenue 201 61,214 61,214 8,770,213 1% 1100 Administration 201 1,551 1,551 45,750 3% 1101 Maintenance 201 6,893 6,893 299,000 2% 1102 Golfo erations 201 2,568 2,568 1,582,000 0% 1103 Recreation Division 201 18,881 18,881 184,140 10% 1104 Potawatomi Zoo 201 NA 1106 Potawatomi Greenhouse 201 NA 1107 Community Svc Block Grant 201 NA 1108 Grafd Removal 201 6,464 6,464 99,304 7% Recreation Non Reverting 203 76,057 76,057 1,449,592 5% East Race 144 terway 271 2 2 100 2% Coveleski Stadium 401 3 3 500 1% Zoo Endowment 403 6 6 2900 0% Park Non Reverting 405 79 79 195,700 0% xxx x xxx NA Sub Total 168,582 168,582 12, 629,199 1% Public Works Motor Vehicle Ni hway 202 285,523 285,523 9,106,300 3% Central Services 222 670,844 670,844 7,847,374 9% Local Roads & Streets 251 87,148 87,148 1,088,000 8% Pro-ect ReLeaf 655 36,373 36,373 431,700 8% xxx xxx xxx NA Sub Total 1,079,887 1079,887 18,473,374 6% Public Works Solid Waste Solid Waste Operations 610 400,585 400,585 5,257,701 8% Solid Waste Ca ital 611 230,437 230,437 736,202 31% xxx x xxx NA Sub Total 631,022 631,022 5,993,903 11% Public Works Water Utility 0000 Water Works Revenues 620 863,045 863,045 12 655,313 7% 0630 Water Leak Insurance 620 80,687 80,687 960,000 8% 0640 Water Works 620 NA 0660 Clay Water 620 74,439 74,439 1,096,020 7% Waterworks Capital 622 453 453 10,000 5% Waterworks Construction 623 223 223 5,000 4% Waterworks Deposit 624 186 186 6,000 3% Waterworks Sinking 625 171,006 171,006 2,057,224 8% Waterworks Bond Reserve 626 8,761 8,761 90,073 10% Waterworks Debt Reserve 629 261 261 70,312 0% xxx xxx xxx NA Sub Total 1,199,062 1,199,062 16,949,942 751 Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 47,833 47,833 549,200 9% 0000 Wastewater Revenues 641 2,517,238 2,517,238 32,588,386 8% 0621 Sewer Department 641 2,000 0% 0625 Concrete Crew 641 4,008 4,008 47,000 9% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 153,599 153,599 1,915,802 8% Sewage Ca ital 642 2,000,563 2,000,563 3,566,580 56% Sewage Reserve 643 130,386 130,386 238,715 55% Sewer Bond 200612006 645 NA Sewer Bond 2007 647 1 1 NA Sewage Bond Sinking 649 775,028 775,028 9,804,645 8% Clay Sewage General 650 NA Sewage Bond 2007 651 NA Sewage Works DS Reserve 653 NA 2010 CSO Net Sewer Bond 658 0 0 NA 2011 Sewer Bond 659 1,034 1,034 25,000 4% 2012 Sewer Bond 661 2372 2372 45,000 5% 2013 Sewer Bond 663 60,000 0% 2013A Sewer Refund Bonds 664 1 1 NA 2014 Sewer Bond 665 21,000,000 0% Sub Total 5,632,063 5,632,063 69,842,328 8% Financial Report January 2014 - Expenddure Summary Page 7 of 28 City of South Bend Revenue by Fund Report Period Ending: January 2014 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I -feud et Public Safe - Police 601 0460 Main Street 601 0462 Leighton Plaza 601 Police Seizures 216 20 20 35,900 0% Curfew Violations 218 14 14 1,025 1% Law Enforcement Education 220 30,247 30,247 211,000 14% Public Safety LOIT 249 531,895 531,895 6,391,029 8% Excess Welfare Public Safety 252 0 0 NA Police Take Home Vehicle 278 14,378 14,378 123,160 12% Police Block Grant 280 0 0 NA Police Grants 292 66,716 66,716 NA Pnlic-Academy 294 13,159 13,159 22,000 60% COPS More Grants 295 863 853 41,600 2% Drug Enforcement 299 91 91 77,000 0% K -9 Unit 705 0 0 2,000 0% xxx xxx Sub Total xxx 657,384 657,384 6,904,714 NA f0% Publie Safe - Fire enc Tele hone S stem 244 215,000 215,000 215,000 100% a ital U 288 154,587 154,587 2,661,000 6% t 289 2 2 10.000 0% River Rescue 291 Z412 Z412 45,200 5% xxx xxx xxx NA Sub Total 372,001 372,001 2,931,200 13% Department of Communi Investment Studebaker /Oliver 209 139 139 305,000 0% State Grant 210 85 85 77,016 0% DCI Operating 211 435,848 435,848 Z278,246 19% 0000 Dept of Community Investment 212 125,073 125,073 3,811,000 3% xxx Pro rams 212 NA 0000 Economic Revenue Bond 281 3 3 NA xxx xxx xxx NA Sub Total 561,149 561,149 6,471,262 9% 0000 Parking Garage Revenue 601 0460 Main Street 601 0462 Leighton Plaza 601 0463 Enforcement 601 0464 Wayne Street 601 0465 Eddy Street Commons 601 xxx xxx xxx Financial Report January 2014 - &p -dit- Summary Page 8 of 28 City of South Bend Revenue by Fund Report Period Ending: January 2014 a i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I Of Bud et Other Miscellaneous Rain Da 102 1,105 1,105 52,000 2% Gift Donation Be nest 217 10 10 7,290 0% Loss Recove 227 1,018 1,018 17,000 6% Human Ri hts 258 89 89 210,700 0% Morris Palais Marketing 273 354 354 8,100 4% Professional Sports Development 377 101,255 101,255 678,228 15% 1201 Code Enforcement 600 585,873 585,873 2,596,460 23% 1207 Animal Control 600 5,770 5,770 57,000 10% 1306 Building Operations 600 80,574 80,574 1,159,100 7% Century Center 670 101,443 101,443 4,564,898 2% Century Center Capital 671 30 30 100,500 0% xxx xxz xxx NA Sub Total 877,520 877,520 9,451,276 9% Business Insurance 0000 Business Insurance Revenues 226 235,841 235,841 2,881,690 8% 0403 Self Funded Liability Ins 226 - - - - - - - - - - - - - - NA 0412 Liability Insurance 226 - - - - - - - - - - - - - - NA 0417 Business Insurance 226 - - - - - - - - - - - - - - NA 0418 Workers Compensation 226 17,000 0% xxx xxx xxx NA Sub Total 235,841 235,841 Z898,690 690 8% FidrCi - Agency sion 701 157 157 5391,332 0% ension 702 261 261 6,310,000 0% Fire Pension 703 NA Employee Benerits 711 939,099 939,099 13 418,450 7% o ment Com 713 8,564 8,564 236,898 4% mte Trust 730 5 5 250 2% xxx xxx xxx NA Sub T otal 948,086 948,086 25 356,930 4% Civil City Revenues 15,022,977 - - - - - - - - - - - 15,022,977 256,637,317 6% Tax Increment Financing rt 324 2,853 2,853 13,484,612 0% ral Develo ment 420 30,402 30,402 4,418,336 1% Washin ton 422 58 58 422,000 0% ton Plaza 425 9,940 9,940 164,303 6% cal Service RNortheast 426 371 371 1,615,000 0% east 429 349 349 827,000 0% hside 430 402 402 3,615,000 0% ine Commons 431 NA TIF Erskine Village 432 762 762 15,000 5% TIF Douglas Road 435 23 23 320,750 0% Northeast Residential TIF 436 244 244 2,510,000 0% xxx xxx xxx NA Sub Total 45,404 45,404 27,392,001 0% Financial Report January 2014 - &pendit- Summary Page 9 of 28 City of South Bend Revenue by Fund Report Period Ending: January 2014 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I of Bud et Redevelo ment Funds Central Bond Proceeds 305 NA District Capital 2003 428 NA Administration 433 3 3 NA Coveleski Bond Construction 438 NA Certified Technology Park 439 472 472 1,453,000 0% Airport Urban Enterprise Zone 454 48 48 1,500 3% Blackthorn Golfo erations 619 71,571 71,571 1,696,879 4% xxx xxz xxx NA Sub Total 72,094 72,094 3,151,379 2% Debt Service Public Improvement 1990 314 - - - - - - - - - - - - - - NA Airport Debt Reserve 2003 315 133 133 5,000 3% Coveleski Bond Debt Reserve 317 65 65 3,000 2% Blackthorn Debt Service 319 NA Central Development reserve 328 223 223 6,000 4% xxx x xxx NA Sub Total 420 420 14,000 3% Redevelopment Commsssion 117,919 - - - - - - - - - - - 117,919 30,557,380 0% City Operations Total 15,140,896 - - - - - - - - - - - 15,140,896 287,194, 697 5% Revenue report 15,140,898 15,140,898 287,194,697 2 0 0 0 0 0 0 0 0 0 0 0 2 0 Financial Report January 2014 - Expenditure Summary Page 10 of 28 City of South Bend Property Tax Revenue 2012 Tax Pay 2013 Fund Period Ending: January 2014 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61412013 611712013 1212312013 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,369,939.03 0.95 36,451,442.08 13,051,204.28 6,798,591.66 16,401,600.74 36,251,396.68 2,118,542.35 94.48% Parks & Recreation 201 7,623,780.24 0.95 7,242,591.23 2,593,163.21 1,350,822.26 3,263,074.28 7,207,059.75 416,720.49 94.53% College Football Hall of Fame 313 1,341,607.54 0.95 1,274,527.16 - 693,822.13 574,356.46 1,268,178.59 73,428.95 94.53% Cumulative Capital District 406 490,121.50 0.95 465,615.43 166,710.61 86,842.35 209,778.19 463,331.15 26,790.35 94.53% Fire Pension 701 - 0.95 - - - 2,618,580.97 - - - Police Pension 702 214,165.13 0.95 Erskine Commons TIF District #2 431 0.95 - - Total - City - 47,825,448.31 Erskine Village TIF District #3 45,434,175.89 15,811,078.10 8,930,078.40 20,448,809.67 45,189,966.17 2,635,482.14 94.49% Tax Increment Financinq Airport TIF District 324 15,275,702.92 0.95 14,511,917.77 7,111,555.29 6,228,798.58 13,340,353.87 1,935,349.05 87.33% South Bend Central TIF District 420 3,761,712.00 0.95 3,573,626.40 1,705,490.58 885,317.48 2,590,808.06 1,170,903.94 68.87% West Washington TIF District 422 584,897.07 0.95 555,652.22 264,689.94 228,918.51 493,608.45 91,288.62 84.39% Central Medical TIFDistrict 426 2,128,725.48 0.95 2,022,289.21 613,184.76 608,491.41 1,221,676.17 907,049.31 57.39% Northeast Residential TIF District 436 2,607,578.70 0.95 2,477,199.77 1,340,027.53 922,737.17 2,262,764.70 344,814.00 86.78% Southside TIF District # 1 430 2,618,580.97 0.95 2,487,651.92 1,381,537.24 1,022,878.60 2,404,415.84 214,165.13 91.82% Erskine Commons TIF District #2 431 0.95 - - - - Erskine Village TIF District #3 432 1,319,469.76 0.95 1,253,496.27 659,734.88 651,393.90 1,311,128.78 8,340.98 99.37% Douglas Road TIF District 435 322,082.97 0.95 305,978.82 164,167.82 159,770.93 323,938.75 (1,855.78) 100.58% Northeast TIF 429 1,152,857.67 0.95 1,095,214.79 431,978.67 409,648.70 841,627.37 311,230.30 73.00% Airport Urban Enterprise Zone 454 0.95 - - - - - Other xxx 0.95 - Total - Tax Increment Financing 29,771,607.54 28,283,027.16 13,672,366.71 11,117,955.28 24,790,321.99 4,981,285.55 83.27% Grand Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 31,566,764.95 69,980,288.16 7,616,767.69 90.18% State Board 2010 Audit Fee Revised Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 31,566,764.95 69,980,288.16 7,616,767.69 90.18% Note(s) 1 Distribution 1 - 2 Distribution 2 - 3 Distribution 3 - x Financial Report January 2014 - 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 January 2014 - 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 January 2014 - 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 January 2014 - 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 January 2014 - Property Tax Revenue Page 15 of 28 City of South Bend Period Ending: January 2014 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et vemment We 101 740 ryor 101 73,969 73,969 711,711 1 Call Center 101 39,235 39,235 488,908 erk 101 33,254 33,254 394,608 immon Council 101 33,804 33,804 472,598 ontroller 101 184,882 184,882 2,091,944 gal 101 111,670 111,670 1,025,635 z 4, 176,421 4,776,421 47,969,186 ib Total 476,814 476,814 5,185,404 cs iergy Office 101 igineering 101 100,714 100,714 1,126,302 affic 8 Lighting 101 K ib Total 100,714 100,714 1,126,302 ty We 101 740 lice 101 2,352,204 2,352,204 24,725,204 Mice Communications 101 205,840 205,840 2,236,486 /ice -PS LOIT funded 101 ode Animal Control 101 ,e 101 2,004,690 2,004,690 21,007,496 -e-PS LOIT funded 101 213,687 213,687 K ib Total 4, 176,421 4,776,421 47,969,186 cement We 101 740 740 5,225 eights and Measure 101 ode Hearing 101 ode Junk Vehicle 101 ode Unsafe Building 101 ode Animal Control 101 2,254 X ib Total 740 740 7,479 ire wis PAC 101 87,838 87,838 1,063,527 dais Royale 101 43,724 43,724 523,710 K ib Total 131,562 131,562 1,587,237 Ws iman Rights 101 31,977 31,977 367,262 K ib Total 31,977 31,977 367,262 General Fund Expenditure Total 5,518,227 - - - - - - - - - - - 5,518,227 56,242,870 10% Financial Report January 2014 - &p -dit- Summary Page 16 of 28 City of South Bend Period Ending: January 2014 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Parks & Recreation )tor Vehicle Highway 1100 Administration 201 113,658 113,658 1,564,813 7% 1101 Maintenance 201 440,988 440,988 4,947,775 9% 1102 Golfo eradons 201 79,201 79,201 1,526,640 5% 1103 Recreation Division 201 195,148 195,148 2,114,512 9% 1104 Potawatomi Zoo 201 669,326 669,326 2,283,664 29% 1106 Potawatomi Greenhouse 201 8,161 8,161 59,614 14% 1107 Community Svc Block Grant 201 196 196 2,057,224 NA 1108 Graffiti Removal 201 7,701 7,701 103,860 7% Recreation Non Reverting 203 42,584 42,584 1,479,064 3% East Race Waterway 271 10,346 0% Coveleski Stadium 401 1,220,608 1,220,608 3,540 0% Park Non Reverting 405 4,814 4,814 205,217 2% xxx )oot xxx NA Sub Total 653 1,561,582 - - - - - - 1,561,582 14,299,045 11% (s )tor Vehicle Highway 202 818,846 818,846 8,555,846 irb and Sidewalk 202 49,312 49,312 1,152,802 antral Services 222 672,962 672,962 7,796,032 Ical Roads &Streets 251 19,206 19,206 1,124,520 oiect ReLeaf 655 14,433 14,433 430,114 X xxx 17,780 17,780 811,011 ib Total Waterworks Deposit 1,574,759 1,574,759 19,059,314 rs Solid Waste did Waste Operations 610 672,124 672,124 5,439,463 ,I1d Waste Capital 611 264,795 264,795 896,070 X xxx ib Total 936,920 936,920 6,335,533 Public Works Water Utility 0630 Water Leak Insurance 620 60,631 60,631 1,115,000 5% 0640 Water Works 620 1,137,738 1,137,738 13,724,004 8% 0660 Clay Water 620 215 215 3,000 7% Waterworks Capital 622 3,600 3,600 978,258 0% Waterworks Construction 623 17,780 17,780 811,011 2% Waterworks Deposit 624 186 186 6,000 3% Waterworks Sinking 625 196 196 2,057,224 0% Waterworks Bond Reserve 626 422 422 15,000 NA Waterworks Debt Reserve 629 261 261 8,500 3% xxx xxx xxx 1,138 NA Sub Total 649 1,220,608 1,220,608 18,702,997 7% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 17,250 17,250 549,978 3% 0621 Sewer Repair 641 461,905 461,905 5,132,912 9% 0625 Concrete Crew 641 39,120 39,120 453,145 9% 0630 Wastewater Operations 641 4,020,021 4,020,021 28,766,521 14% 0631 Organic Resources 641 78,091 78,091 1,202,616 6% 0650 Clay Sewage 641 978 978 1,000 -98% Sewage Ca ital 642 978,994 978,994 9,267,941 11% Sewage Reserve 643 422 422 15,000 3% Sewer Bond 200612006 645 NA Sewer Bond 2007 647 1,138 0% Sewage Bond Sinking 649 500 500 9,802,031 0% Clay Sewage General 650 NA Sewage Bond 2007 651 NA Sewage Works DS Reserve 653 NA 2010 CSO Net Sewer Bond 658 NA 2011 Sewer Bond 659 275,419 275,419 13,598,486 2% 2012 Sewer Bond 661 272,470 272,470 18,868,570 1% 2013 Sewer Bond 663 19,100,000 0% 2014 Sewer Bond 665 500,000 0% Sub Total 6,143,212 - - - - - - - - - - - 6,143,212 107,259,338 6% Financial Report January 2014 - &p -dit- Summary Page 17 of 28 City of South Bend Period Ending: January 2014 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Public Safe - Police 4S Capital 288 449,207 449,207 4,572,215 Police Seizures 216 10,000 ver Rescue 40,000 0% Curfew Violations 218 1,612,310 ib Total 1,000 0% Law Enforcement Education 220 11,075 11,075 294,802 4% Emer enc Tele hone System 244 27,387 27,387 215,000 13% Public Safe LOIT 249 517,291 517,291 7,214,658 7% Excess Welfare Public Safety 252 1,146 0% Police Take Home Vehicle 278 15,269 15,269 80,580 0% Police Block Grant 280 29,594 29,594 5,823,729 NA Police Grants 292 337,650 337,650 90,000 0% Police Academy 294 136 136 23,750 1% COPS More Grants 295 175 175 141,600 0% Drug Enforcement 299 6,273 6,273 151,499 0% K -9 Unit 705 2,000 0% xxx xxx xxx 4,831,372 4,831,372 29,073,445 NA Sub Total 556,065 556,065 8,256,035 7% ty - Fire 4S Capital 288 449,207 449,207 4,572,215 mmat 289 10,000 ver Rescue 291 199 199 52,300 X xxx 1,612,310 ib Total 449,407 449,407 4,634,515 De artmento mmunity Investment Z iin Street StudebakedOliver 209 22,732 203,425 1,385,000 0% State Grant 210 1,612,310 ighton Plaza 117,886 0% CEDO eretin 211 236,843 236,843 2,404,884 TO-To 1001 De t, of Communi Investment 212 85,538 85,538 6,499,680 1% 1002 Dept. of Community Investment 212 2,229,819 2,229,819 15,900 NA 1003 Administration 212 2,328 0% xxx Programs 212 15,269 15,269 408,775 4% xxx xxx xxx 29,594 29,594 5,823,729 NA Sub Total 416 337,650 337,650 10,818,553 3% Capital /Debt Service Z iin Street 601 22,732 22,732 203,425 Joseph 601 COIT 404 1,612,310 ighton Plaza 601 39,122 39,122 337,008 iforoement 601 13,486 13,486 90,606 ayne Street 601 21,424 21,424 150,869 Idy Street Commons 601 2,229,819 2,229,819 15,900 X xxx 409 ib Total NA 96,764 96,764 797,808 Capital /Debt Service Hall of Fame 313 634,500 634,500 1,268,116 50% COIT 404 1,612,310 1,612,310 9,976,202 16% Cum Capital Development 406 112,650 112,650 722,935 16% Cum Capital Improvement 407 185,250 185,250 364,762 51% EDIT 408 2,229,819 2,229,819 10,014,984 22% Cumulative Sewer 409 NA UDAG 410 NA Major Moves 412 29,594 29,594 5,823,729 1% Morris PAC Improvement 416 53,200 0% CREED 434 20,975 20,975 650,950 3% Palais Historic Preservation 450 10,000 0% Hall of Fame Capital 677 6,273 6,273 188,567 3% xxx xxx xxx NA Sub Total 4,831,372 4,831,372 29,073,445 17% Financial Report January 2014 - Expenditure Summary Page 18 of 28 City of South Bend Period Ending: January 2014 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Other Miscellaneous Self Funded Liability Ins Excess Levy 103 20,289 253,743 Liability Insurance NA Gift, Donation, Bequest 217 1,028,811 Business Insurance 1,310 0% Loss Recovery 227 5,154 5,154 5,615,805 0% General Grant 250 xxx 319 657,534 NA Human Rights 258 19,647 19,647 224,001 9% Morris Palais ting 273 3,628 3,628 8,100 45% Economic Revenue Bond 281 617 617 2,356,117 NA ProfessionalSports Development 377 382,873 382,873 865,746 44% 1201 Code Enforcement 600 87,023 87,023 1,836,074 5% 1207 Animal Control 600 58,611 58,611 689,215 9% 1306 Building Operations 600 102,831 102,831 1,273,620 8% Century Center 670 314,629 314,629 4,564,898 7% Century Center Capital 671 NA xxx xxx xxx 4,494,908 4,494,908 51,037,693 NA Sub Total 974,395 974,395 15,078,769 6% Insurance Self Funded Liability Ins 226 20,289 20,289 253,743 Liability Insurance 226 39,002 39,002 1,028,811 Business Insurance 226 6,557 6,557 572,300 Workers Compensation 226 37,558 37,558 1,042,346 xxx xxx 319 657,534 20,595 Sub Total xxx 103,406 103,406 2,897,200 Trust & Agency Fire Pension 701 457,164 457,164 5,874,445 Police Pension 702 542,603 542,603 7,221,941 Employee Benefits 711 526,930 526,930 14,483,463 Unemployment Comp 713 9,673 9,673 227,974 City Cemetery Trust 730 319 657,534 20,595 xxx xxx 4,077 4,077 149,425 Sub Total TIF Medical Service 1,536,369 1,536,369 27,828,418 Civil City Expenditure 25,840,735 - - - - - - - - - - - 25,840,735 321,283,840 8% Tax Increment Financing TIF Air ort 324 1,403,524 1,403,524 27,286,693 5% TIF Sam le Ewing 414 NA TIF Central Development 420 1,015,931 1,015,931 5,829,261 17% TIF West Washington 422 319 319 657,534 0% TIF Lei Leighton Plaza 425 4,077 4,077 149,425 3% TIF Medical Service 426 169,224 169,224 4,103,504 4% TIF Northeast 429 617 617 2,356,117 0% TIF Southside 430 81,949 81,949 6,487,957 1% TIF Erskine Commons 431 NA TIF Erskine Villa a 432 354,606 354,606 494,151 72% TIF Dou las Road 435 160 160 349,823 0% Northeast Residential TlF 436 1,464,500 1,464,500 3,323,228 44% xxx xxx xxx NA Sub Total 4,494,908 4,494,908 51,037,693 9% Financial Report January 2014 - Expendkum Summary Page 19 of 28 City of South Bend Period Ending: January 2014 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Aug Sep I Oct I Nov I Dec I Year I Budget of Bud et Redevelo ment Funds iblic Improvement 1990 Central Bond Proceeds 305 rport Debt Reserve 2003 NA District Capital 2003 428 5,000 rveleski Bond Debt Reserve 317 NA Administration 433 6,072 6,072 NA Coveleski Bond Construction 438 328 223 223 NA Certlfled Technology Park 439 3,600,000 0% Air ort Urban Enterprise Zone 454 356 11,000 NA Blackthorn Go/fOperations 619 47,557 47,557 1,671,706 3% xxx xxx xxx NA Sub Total 53,629 53,629 5,271,706 1% e iblic Improvement 1990 314 rport Debt Reserve 2003 315 133 133 5,000 rveleski Bond Debt Reserve 317 ackthorn Debt Service 319 ?ntral Development reserve 328 223 223 6,000 X xxx ib Total 356 356 11,000 Redevelopment Commsssion 4,548,893 - - - - - - - - - - - 4,548,893 56,320,399 8% City Operations Total 30,389,628 - - - - - - - - - - - 30,389,628 377,604,239 8% Expenditure report 30,389,627 30,389,627 377,604,239 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report January 2014 - Expenditure Summary Page 20 of 28 City of South Bend Debt Schedule Period Ending; January 2014 Year of I Year of Year of Scheduled Payments Debt tOrig / Ran) Debt at 2014 Principal 2014 Interest 2014 Debt at 2014 Total Debt Instrument Debt Purpose Issue Refundin maturi Fund 1st 2nd 3rd 4th Issue 113112014 Pa menu Payment Addition 12131/2014 Debt Pa menu Civil City Debt Bond Debt Arran scn k 3/ CEDIT Bond 1997 2006 2017 408 211 8/1 - - 11,870,000.00 2,815,000.00 760,000.00 121,520.00 0.00 2,055,000.00 881,520.00 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 211 8/1 - - 9,250,000.00 4,385,000.00 525,000.00 145,626.00 0.00 3,860,000.00 670,626.00 25 Water Works Improvements Water Works 2002 2012 2023 625 1/1 7/1 - - 5,975,000.00 3,450,000.00 350,000.00 69,000.00 0.00 3,100,000.00 419,000.00 39 South Bend Building Corporation Fire HO / Police HO 2003 2012 2023 404/324 211 8/1 - - 21,335,000.00 12,365,000.00 1,120,000.00 446,010.00 0.00 11,245,000.00 1,566,010.00 41 Sewage Works Improvements Sewage Works 2004 2024 649 611 12/1 - - 11,425,000.00 0.00 0.00 0.00 0.00 0.00 0.00 24 Water Works Improvements Water Works 2006 2027 625 1/1 7/1 - - 4,710,000.00 3,505,000.00 205,000.00 155,438.00 0.00 3,300,000.00 360,438.00 42 Sewage Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7,630,000.00 6,090,000.00 350,000.00 269,491.26 0.00 5,740,000.00 619,491.26 4o Saw age Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16,600,000.00 13,010,000.00 690,000.00 563,547.50 0.00 12,320,000.00 1,253,547.50 52 Sewage We Revenue Bonds 2007B Sewage Works 2007 2027 649 6/1 12/1 - - 16,515,000.00 12,960,000.00 680,000.00 551,541.26 0.00 12,280,000.00 1,231,541.26 U Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11/1 - - 4,655,000.00 3,990,000.00 240,000.00 104,308.26 0.00 3,750,000.00 344,308.26 69 Water Works Improvements Water Works 2009 2030 625 1/1 7/1 - - 5,380,000.00 4,985,000.00 210,000.00 270,232.00 0.00 4,775,000.00 480,232.00 7o Sewage Works Revenue Bonds -2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3,297,000.00 2,710,898.00 149,511.00 76,176.00 0.00 2,561,387.00 225,687.00 eo 2010 Sewage Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9,345,000.00 8,270,000.00 365,000.00 336,217.50 0.00 7,905,000.00 701,217.50 93 Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21,500,000.00 19,895,000.00 855,000.00 732,300.00 0.00 19,040,000.00 1,587,300.00 sg 2012 Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8,300,000.00 7,960,000.00 340,000.00 233,886.26 0.00 7,620,000.00 573,886.26 101 2012 Sewage Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25,000,000.00 23,985,000.00 1,020,000.00 548,580.00 0.00 22,965,000.00 1,568,580.00 fo52013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14,765,000.00 13,700,000.00 1,845,000.00 265,780.00 0.00 11,855,000.00 2,110,780.00 116 2013 Building Corporation xxx EMS / Fire Department 2013 2033 288 211 8/1 - - 5,580,000.00 5,580,000.00 0.00 142,197.00 0.00 5,580,000.00 142,197.00 Total Bond Debt 225 632 000.00 149 655 898.00 9,704,511.00 5 031 851.04 0.00 139 951 387.00 14 736 362.04 Loans Payable 1 State Revolving Fund Bosch Property 2002 2022 210 1/30 10/30 - - 506,448.00 331,306.86 32,290.71 12,771.93 0.00 299,016.15 45,062.64 6e State Revolving Fund Water Works Improvement 2009 2030 625 1/1 711 - - 427,332.00 391,297.00 18,933.00 13,186.70 0.00 372,364.00 32,119.70 82 lnterfund Loan 410 - UDAG 1st Source/Marriott Garage 2010 2015 410 6/15 1215 - - 2,700,000.00 2,027,973.00 745,565.00 0.00 0.00 1,282,408.00 745,565.00 44 State Revolving Fund (Refunding) Sewage Works Improvement 1998 2018 649 6/1 12/1 - - 24,095,000.00 0.00 0.00 0.00 0.00 0.00 0.00 26 State Revolving Fund Water Works Improvements 2000 2019 625 1/1 7/1 - - 2,600,000.00 1,018,815.00 157,902.00 29,546.00 0.00 860,913.00 187,448.00 Total Loans Pa able 35 533 780.00 3.769.391.86 954 690.71 55 504.63 0.00 2.814.701.15 1 010 195.34 Capital Leases 27 LaSalle Bank - Fire Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 0.00 0.00 0.00 0.00 sf Chase LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 730,258.41 171,136.37 29,443.29 0.00 559,122.04 200,579.66 5s Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 963,508.00 0.00 0.00 0.00 0.00 0.00 0.00 56 Oce Copier 209 N Main 2008 2013 620 Monthly - - - 12,078.21 0.00 0.00 0.00 0.00 0.00 0.00 57 Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 0.00 5s Lanier Copier 915 Oil- 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 0.00 0.00 0.00 0.00 5e Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 0.00 0.00 0.00 0.00 0.00 0.00 67 Sun Trust Solid Waste ContaineraTmcks 2009 2014 611 9/1 3/1 - - 720,990.00 78,167.28 78,167.28 1,450.00 0.00 0.00 79,617.28 71 Kansas State Bank Clark Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,209.00 638.84 638.84 10.63 0.00 0.00 649.47 72 Kansas State Bank Code Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10/23 9,209.00 2,594.75 2,055.52 143.04 0.00 539.23 2,198.56 73 Kansas State Bank Engineering Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,391.00 651.47 651.47 10.84 0.00 0.00 662.31 74 CSI Leasing Inc IT Netapp San 2010 2014 404 1/1 4/1 7/1 10/1 207,521.37 14,236.41 14,236.41 210.59 0.00 0.00 14,447.00 76 Kansas State Bank Central Services Copier 2010 2015 222 2116 5/16 8/16 11/16 13,366.40 4,362.77 2,865.87 194.13 0.00 1,496.90 3,060.00 n GE Capital Information Technology Animal Control Copier 2010 2015 101 2/28 5/30 8/30 11130 3,550.69 1,161.97 758.35 57.05 0.00 403.62 815.40 7e Kansas State Bank Mayor Oce Copier 2010 2015 101 1/8 4/8 7/8 10/8 9,209.00 3,564.45 1,977.73 220.83 0.00 1,586.72 2,198.56 7s Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10,511.02 4,702.41 2,246.64 348.72 0.00 2,455.77 2,595.36 87 Public Finance.- Inc Solid Waste Containers /Trucks 2011 2015 611 6/15 12/15 - - 321,853.00 133,252.34 65,587.04 3,677.96 0.00 67,665.30 69,265.00 as Sun Trust Police, Parks, Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12/15 2,068,202.00 1,05 04 84 417,495.38 17,470.02 0.00 641,545.46 434,965.40 so Capital One Public Funding Solid Waste Containers /Trucks 2011 2016 611 3/15 6/15 9/15 12/15 207,432.00 116,115.23 41,611.14 1,674.42 0.00 74,504.09 43,285.56 s1 GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 2,065.68 790.50 98.22 0.00 1,275.18 888.72 s2 Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 843,595.57 274,272.26 21,127.15 0.00 569,323.31 295,399.41 s4 Ikon Office Solutions Mayor Ricoh MP 2851 SP Copiei 2011 2016 101 2/15 5/15 8/15 11/15 2,569.53 1,620.15 509.86 78.62 0.00 1,110.29 588.48 s5 Sun Trust Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 218,030.66 86,168.37 3,154.11 0.00 131,862.29 89,322.48 s7 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1,295,000.00 918,678.73 256,966.38 14,484.90 0.00 661,712.35 271,451.28 s3 PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202641/640 5/15 11/15 - - 945,674.38 669,405.77 187,687.81 9,371.03 0.00 481,717.96 197,058.84 too PNC Equipment Finance Public Works Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15 - - 2,806,054.00 2,257,055.55 553,306.66 27,644.68 0.00 1,703,748.89 580,951.34 foe Ikon Office Solutions /Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 4,278.32 1,108.21 213.70 0.00 3,170.11 1,321.91 1. GE Capital Information Technology Fire Department Copier 2012 2017 101 2/28 5/28 8/28 11128 5,471.01 4,249.41 1,043.56 227.24 0.00 3,205.85 1,270.80 foe Ricoh USA (New) Central Services Copier 2013 2018 222 2127 5127 8/27 11/27 3,622.78 3,004.64 689.33 150.43 0.00 2,315.31 839.76 107 Ricoh USA StreeUSewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 4,506.34 1,030.99 239.80 0.00 3,475.35 1,270.79 toe Ricoh USA City Adomey Copier 2013 2018 101 2112 5112 8112 11/12 5,559.15 4,528.32 1,035.69 235.12 0.00 3,492.63 1,270.81 fog Ricoh USA Parks & Rep Ricoh Copieri 2013 2018 201 2121 5/21 8/21 11/21 16,129.94 13,138.49 3,005.59 681.63 0.00 10,132.90 3,687.22 11c INC Equipment Finance Vehicle/Equipment Lease 2013 2018 1011202/406/641 1115 7115 - - 1,689,669.59 1,689,669.59 327,718.32 22,182.20 0.00 1,361,951.27 349,900.52 111 Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 8,694.31 1,904.10 687.89 0.00 6,790.21 2,591.99 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 3,854.47 744.54 194.46 0.00 3,109.93 939.00 113 Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 - - 1,506,465.26 1,506,465.26 291,855.59 22,725.55 0.00 1,214,609.67 314,581.14 114 Ricoh USA Admin & Finance Copier 2013 2018 101 1116 4116 7116 10/16 11,247.97 9,620.91 2,055.86 515.39 0.00 7,565.05 2,571.25 115 CSI Leasing Inc 2010 Server IT Lease 2010 2014 404 2/1 5/1 8/1 11/1 28,588.00 5,869.74 5,869.79 169.81 0.00 (0.05) 6,039.60 fn Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 9,678.26 1,728.17 491.83 0.00 7,950.09 2,220.00 113 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 5,647.50 1,008.13 287.27 0.00 4,639.37 1,295.40 fts Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copie 2013 2018 620 Monthly 16th 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 1,085.52 12o Water Works Olive Ricoh Copier xxx Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 4,732.65 844.81 240.71 0.00 3,887.84 1,085.52 Total Capital Lease 18 788 201.74 10 341 870.14 1 2.801.617.37 180 353.97 0.00 7,540,252.77 2 981 971.34 Total Civil City 279,953,981.74 163,767,160.00 13,460,819.08 5,267,709.64 0.00 150,306,340.92 18,728,528.72 Financial RepW January 2014 - Debf Page 21 0/28 City of South Bend Debt Schedule Period Ending; January 2014 Year of I Year of Year of Scheduled Payments I Debt (0i / RanJ Debt at 2014 Principal 2014 Interest 2014 Debt at 2014 Total Debt Instrument Debt Purpose Issue Refundin maturi Fund 1st 2ntl 3rd 4th Issue 1/31/2014 Pa menu Payment Addition 12/31/2014 Debt Pa menu Redevelopment Commission Debt Bond Debt 9 Central Business TIF 1990 1996 2012 420 2J 1 8/1 - - 3,790,000.00 0.00 0.00 0.00 0.00 0.00 0.00 to Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 0.00 0.00 0.00 0.00 0.00 0.00 7 Century Center Lease Rental Revenue Century Canter 1994 2001/2011 2018 407 2J 1 811 - - 6,825,000.00 2,070,000.00 440,000.00 46,350.00 0.00 1,630,000.00 486,350.00 a College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15,370,000.00 5,285,000.00 1,130,000.00 137,687.50 0.00 4,155,000.00 1,267,687.50 ti South Bend Building Corporation Morris PAC 1998 2009 2017 408 2J 1 811 - - 13,300,000.00 3,380,000.00 920,000.00 120,262.50 0.00 2,460,000.00 1,040,262.50 12 TJX Special Taxing District 2002 2022 324/404/414 1/1 7/1 - - 6,620,000.00 3,405,000.00 360,000.00 152,712.50 0.00 3,045,000.00 512,712.50 5 Downtown Central Area TIF 2003 2011 2024 420 2J 8/1 - - 19,795,000.00 16,120,000.00 1,155,000.00 759,297.00 0.00 14,965,000.00 1,914,297.00 5 Airport Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14,420,000.00 9,195,000.00 660,000.00 433,067.75 0.00 8,535,000.00 1,093,067.75 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2J 1 8/1 - - 5,485,000.00 4,465,000.00 210,000.00 281,495.00 0.00 4,255,000.00 491,495.00 sa Lease Rental Revenue Bonds of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36,000,000.00 34,050,000.00 1,030,000.00 1,894,868.00 0.00 33,020,000.00 2,924,868.00 at Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4,980,000.00 3,520,000.00 605,000.00 159,745.00 0.00 2,915,000.00 764,745.00 as SB Economic Develop Revenue Bonds Career Academy 2011 2014 324 2/15 5/15 8/15 11/15 1,500,000.00 500,000.00 500,000.00 12,500.00 0.00 0.00 512,500.00 too 2012 Gates Downtown Campus xxx VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 1,700,000.00 1,133,333.34 566,666.66 0.00 0.00 566,666.68 566,666.66 Total Bond Debt 139,420,000.00 83,123,333.34 7,576,666.66 3,997,985.25 0.00 75,546,666.68 11,574,651.91 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3122 6/22 9122 12122 1,040,000.00 482,021.41 58,200.48 13,809.96 0.00 423,820.93 72,010.44 4 Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 133,214.96 16,084.70 3,816.62 0.00 117,130.26 19,901.32 2 State Industrial Development Fund Bosch Property 2002 2017 210 411 10/1 - - 1,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00 14 Indiana Development Finance Authority Frederickson Park 2003 2012 404 3/31 6/30 9/30 12/31 764,809.60 0.00 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 0.00 15 Indiana Development Finance Authority Anchor 2005 2014 404 6/30 12/31 - - 600,000.00 66,666.72 66,666.72 1,250.00 0.00 0.00 67,916.72 17 Indiana Development Finance Authority Anchor (Forgive) 2005 2014 404 6130 12131 - - 75,000.00 10,714.32 10,714.32 200.89 0.00 0.00 10,915.21 so HUD Section 108#8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4,000,000.00 1,005,000.00 825,000.00 41,949.00 0.00 180,000.00 866,949.00 tf3 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8115 - - 1,102,549.56 343,532.46 91,529.37 16,046.63 0.00 252,003.09 107,576.00 54 interfund Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,040,319.00 923,829.00 37,152.00 45,733.00 0.00 886,677.00 82,885.00 e3 Intertund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5115 6115 7115 8115 31,032.00 15,516.00 3,879.00 0.00 0.00 11,637.00 3,879.00 ea Intedund Fund 412 - Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2,000,000.00 1,460,723.00 44,790.50 15,580.50 0.00 1,415,932.50 60,371.00 es Intertund Fund 412 -Major Moves Eddy Street Commons 2011 2026 436 1115 8/15 - - 4,100,000.00 3,451,651.03 203,399.20 169,036.80 0.00 3,248,251.83 372,436.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 34,615.62 6,699.84 0.00 0.00 27,915.78 6,699.84 Total Loans Payable 22,058,511.06 8427484.52 1,364,116.13 307423.40 0.00 7063368.39 1,671,539.53 Capital Lease 75 PNC Equipment Financing xbc Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 106,802.80 52,087.76 4,333.24 0.00 54,715.04 56,421.00 Total Capital Lease 246 509.64 106 802.80 52 087.76 4,333.24 0.00 54 715.04 56 421.00 Leases 37 Transpo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3,000,000.00 371,710.00 180,363.00 19,637.00 0.00 191,347.00 200,000.00 13 Transpo Lease xxx Main / Colfax Garage 2006 2025 404 3/15 9/15 - - 2,510,278.00 1,788,501.00 111,958.00 88,042.00 0.00 1,676,543.00 200,000.00 Total Lease 5,510,278.00 2,160,211.00 1 292,321.00 107,679.00 0.00 1 1,867,890.00 1 400,000.00 Total Redevelopment Commission 167,235,298.70 93,817,831.66 9,285,191.55 4,417,420.89 0.00 1 84,532,640.11 1 13,702,612.44 Total Debt 0 447,189,280.44 257,584,991.66 22,746,010.63 9,685,130.53 0.00 234,838,981.03 32,431,141.16 Financial Repot January 2014 - Debt Page 22 0/28 City of South Bend Period Ending; January 2014 Monthly Debt Schedule Year of I Year of Year of Scheduled Payments Debt (Orig / Ref•) Debt at YTD Principal YTD Interest YTD Debt at Debt Instrument Debt Purpose Issue Refunding Maturi Fund let 2nd 3rd 4th Issue 1231/2013 Pa ments Payments ALMons 1 113112014 Bond Debt Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 Arran scb k LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 730,258.41 84,662.30 15,627.53 645,596.11 3/ CEDIT Bond Police Vehicles 1997 2006 2017 408 211 8/1 - - 11,870,000.00 2,815,000.00 0.00 2,815,000.00 36 South Bend Building Corporation Public Works Building 2001 2010 2021 404/649 211 8/1 - - 9,250,000.00 4,385,000.00 0.00 4,385,000.00 25 Water Works Improvements Water Works 2002 2012 2023 625 711 12131 - - 5,975,000.00 3,450,000.00 0.00 3,450,000.00 39 South Bend Building Corporation Fire HO / Police HO 2003 2012 2023 404/324 211 8/1 - - 21,335,000.00 12,365,000.00 0.00 12,365,000.00 41 Sewage Works Improvements Sewage Works 2004 2013 2024 649 611 12/1 - - 11,425,000.00 0.00 0.00 0.00 24 Water Works Improvements Water Works 2006 2014 2027 625 7/1 1231 - - 4,710,000.00 3,505,000.00 78,167.28 3,505,000.00 42 Sewage Works Improvements Sewage Works 2006 2014 2026 649 611 12/1 - - 7,630,000.00 6,090,000.00 638.84 638.84 10.63 6,090,000.00 4o Saw age Works Improvements Sewage Works 2007 2015 2027 649 6/1 12/1 - - 16,600,000.00 13,010,000.00 2,594.75 499.11 50.53 13,010,000.00 52 Sewage We Revenue Bonds 2007B Sawage Works 2007 2014 2027 649 6/1 12/1 - - 16,515,000.00 12,960,000.00 651.47 651.47 10.84 12,960,000.00 U Century Center Special Tax Bonds Century Center 2008 2014 2028 420 5/1 11/1 - - 4,655,000.00 3,990,000.00 14,236.41 3,990,000.00 69 Water Works Improvements Water Works 2009 2015 2030 625 7/1 12131 - - 5,380,000.00 4,985,000.00 4,362.77 4,985,000.00 7o Sewage Works Revenue Bonds -2009 Sewage Works 2009 2015 2028 649 6/1 12/1 - - 3,297,000.00 2,710,898.00 1,161.97 2,710,898.00 so 2010 Sawage Works Revenue Bonds Sewage Works 2010 2015 2030 649 6/1 12/1 - - 9,345,000.00 8,270,000.00 3,564.45 480.22 69.42 8,270,000.00 93 Sewage Works Revenue Bonds 2011 Sewage Works 2011 2015 2031 649 6/1 12/1 - - 21,500,000.00 19,895,000.00 4,702.41 19,895,000.00 99 2012 Water Works Revenue Bond Water Works 2012 2015 2033 625 1/1 7/1 - - 8,300,000.00 7,960,000.00 340,000.00 118,643.13 0.00 7,620,000.00 tot 2012 Sewage Works Revenue Bonds Sewage Works 2012 2016 2032 649 6/1 12/1 - - 25,000,000.00 23,985,000.00 1,059,040.84 23,985,000.00 fo5 2013A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14,765,000.00 13,700,000.00 116,115.23 13,700,000.00 tf6 2013 Building Corporation xxx EMS / Fire Department 2013 2016 2033 288 211 8/1 - - 5,580,000.00 5,580,000.00 2,065.68 193.39 28.79 5,580,000.00 Total Bond Debt IT Phone System 2011 2016 404 1/15 225 632 000.00 149 655 898.00 340 000.00 118 643.13 0.00 149 315 898.00 Loans Payable Mayor Ricoh MP 2851 SP Copiei 2011 2016 101 2115 5/15 8/15 11/15 2,569.53 1,620.15 1,620.15 t State Rev olvng Fund Bosch Property 2002 2016 2022 210 1/30 4/30 7/30 10/30 506,448.00 331,306.86 7,952.59 3,313.07 323,354.27 6e State Revolving Fund Water Works Improvement 2009 2017 2030 625 711 12131 - - 427,332.00 391,297.00 918,678.73 391,297.00 82 lnterfund Loan 410 - UDAG tat Source/Marriott Garage 2010 2017 2015 410 6/15 1215 - - 2,700,000.00 2,027,973.00 669,405.77 2,027,973.00 44 State Revolving Fund Sewage Works Improvement 1998 2017 2018 649 6/1 12/1 - - 24,095,000.00 0.00 2,257,055.55 275,754.03 290,475.67 0.00 26 State Revolving Fund Water Works Improvements 2000 2017 2019 625 7/1 12/31 - - 2,600,000.00 1,018,815.00 4,278.32 1,018,815.00 Capital Leases 27 LaSalle Bank - Fire Fire Equipment 2007 2012 288 6/1 12/1 - - 621,520.00 0.00 0.00 sf Chase LED Equipment 2007 2017 101 1/1 711 - - 1,531,573.00 730,258.41 84,662.30 15,627.53 645,596.11 m Commerce Bank Police Vehicles 2008 2008 406 6/1 12/1 - - 963,508.00 0.00 0.00 56 Oce Copier 209 N Main 2008 2013 620 Monthly - - - 12,078.21 0.00 0.00 57 Lanier Copier 830 N Michigan 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 5s Lanier Copier 915 Oil- 2008 2013 620 Monthly - - - 5,154.00 0.00 0.00 59 Lanier Copier Street 2008 2013 202 Monthly - - - 4,300.00 0.00 0.00 67 Sun Trust Solid Waste Containers/Trucks 2009 2014 611 3/1 9/1 - - 720,990.00 78,167.28 78,167.28 71 Kansas State Bank Clark Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,209.00 638.84 638.84 10.63 0.00 72 Kansas State Bank Code Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10/23 9,209.00 2,594.75 499.11 50.53 2,095.64 73 Kansas State Bank Engineering Lanier Oce Copier 2010 2014 101 1/23 4/23 7/23 10/23 9,391.00 651.47 651.47 10.84 0.00 74 CSI Leasing Inc IT Netapp San 2010 2014 404 4/1 7/1 10/1 1231 207,521.37 14,236.41 14,236.41 76 Kansas State Bank Central Services Copier 2010 2015 222 2116 5/16 8/16 11/16 13,366.40 4,362.77 4,362.77 n GE Capital Information Technology Animal Control Copier 2010 2015 101 228 5/30 8/30 11130 3,550.69 1,161.97 1,161.97 78 Kansas State Bank Mayor Oce Copier 2010 2015 101 1/8 4/8 7/8 10/8 9,209.00 3,564.45 480.22 69.42 3,084.23 7s Advanced Imaging Central Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10,511.02 4,702.41 4,702.41 a7 Public Finance.- Inc Solid Waste Containers / Trucks 2011 2015 611 6/15 12115 - - 321,853.00 133,252.34 133,252.34 as Sun Trust Police, Parks, Bldg vehicles 2011 2016 404/201/600 3/15 6/15 9/15 12115 2,068,202.00 1,059,040.84 1,059,040.84 so Capital One Public Funding Solid Waste Containers /Trucks 2011 2016 611 3/15 6/15 9/15 12115 207,432.00 116,115.23 116,115.23 91 GE Capital Information Technology Police Dept Copier 2011 2016 101 1/11 4/11 7/11 10/11 3,836.00 2,065.68 193.39 28.79 1,872.29 92 Key Finance IT Phone System 2011 2016 404 1/15 1,444,995.97 843,595.57 274,272.26 21,127.15 569,323.31 94 Ikon Office Solutions Mayor Ricoh MP 2851 SP Copiei 2011 2016 101 2115 5/15 8/15 11/15 2,569.53 1,620.15 1,620.15 95 Sun Trust Equipment Finance Parks -Golf Cars Lease 2012 2016 201 4/15 10/15 - - 344,500.00 218,030.66 218,030.66 97 Sun Trust Equipment Finance Police Vehicles & Equipment 2012 2017 406 5/15 11/15 - - 1,295,000.00 918,678.73 918,678.73 9e PNC Equipment Finance Public Works Vehicles Lease 2012 2017 2021641/640 5/15 11/15 - - 945,674.38 669,405.77 669,405.77 fop PNC Equipment Finance Public We Vehicles Lease 2012 2017 202/641/600/288 1/15 7/15 - - 2,806,054.00 2,257,055.55 275,754.03 290,475.67 1,981 3 1.52 (o2 Ikon Office Solutions / Ricoh Wastewater Copier 2012 2017 641 Monthly 1st 5,744.95 4,278.32 4,278.32 103 GE Capital Information Technology Fire Department Copier 2012 2017 101 2128 5/28 8/28 11/28 5,471.01 4,249.41 4,249.41 toe Ricoh USA Central Services Copier 2013 2018 222 227 5127 8/27 11/27 3,622.78 3,004.64 3,004.64 107 Ricoh USA StraeUSewer Dept Copier 2013 2018 202/641 3/4 6/4 9/4 12/4 5,559.15 4,506.34 4,506.34 foe Ricoh USA City Attorney Copier 2013 2018 101 2/12 5/12 8/12 11/12 5,559.15 4,528.32 4,528.32 row Ricoh USA Parks & R. Ricoh Copiers(3) 2013 2018 201 2121 5/21 8/21 11121 16,129.94 13,138.49 13,138.49 110 PNC Equipment Finance Vehide/Equipirent Lease 2013 2018 1011202/406/641 1115 7115 - - 1,689,669.59 1,689,669.59 162,086.32 12,863.94 1,527,583.27 111 Ricoh USA Engineering Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10,667.67 8,694.31 8,694.31 112 Ricoh USA Building Dept. Copier 2013 2018 600 Monthly 4,093.64 3,854.47 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 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 9,620.91 502.88 139.93 9,118.03 115 CSI Leasing Inc 2010 Server IT Lease 2010 2014 404 211 5/1 8/1 11/1 28,588.00 5,869.74 5,869.74 fn Police Dept. Record Div. Ricoh Police Records Copier 2013 2018 101 Monthly 3rd 9,678.26 9,678.26 140.40 44.60 9,537.86 113 Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 Monthly 10th 5,647.50 5,647.50 81.90 26.05 5,565.60 119 Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Copie 2013 2018 620 Monthly 16th 4,732.65 4,732.65 68.63 21.83 4,664.02 12o Water Works Olive Ricoh Copier Water Works Olive Ricoh Copier 2013 2018 620 Monthly 10th 4,732.65 4,732.65 68.63 21.83 4,664.02 Financial RepW January 2014 - Debt Page 23 0/28 City of South Bend Period Ending; January 2014 Monthly Debt Schedule Year of I Year of Year of Scheduled Payments Debt (Orig / Reb) Debt at YTD Principal YTD Interest YTD Debt of Debt Instrument Debt Purpose Issue Refunding Maturi Fund let 2ntl 3rd 4th Issue 12/31/2013 Pa ments Payments Atidttions 1 113112014 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 to Blackthom Golf Course Blackthorn Golf 1992 1998 2013 619 3/1 9/1 - - 6,135,000.00 0.00 0.00 0.00 7 Century Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2J 1 811 - - 6,825,000.00 2,070,000.00 0.00 2,070,000.00 a College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15,370,000.00 5,285,000.00 0.00 5,285,000.00 tt South Bend Building Corporation Morris PAC 1998 2009 2017 408 2J 1 811 - - 13,300,000.00 3,380,000.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,405,000.00 345,000.00 83,256.25 0.00 3,060,000.00 5 Downtown Central Area TIF 2003 2011 2024 420 2J1 811 - - 19,795,000.00 16,120,000.00 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,195,000.00 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,465,000.00 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,050,000.00 0.00 34,050,000.00 et Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4,980,000.00 3,520,000.00 300,000.00 82,872.50 0.00 3,220,000.00 95 SB Economic Develop Revenue Bonds Career Academy 2011 2014 324 2/15 5/15 8/15 11/15 1,500,000.00 500,000.00 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,133,333.34 0.00 1,133,333.34 Total Bond Debt 11111111F 139,420,000.00 83 123 333.34 645,000.00 166,128.75 0.00 82,478,333.34 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonforgive) 2001 2021 210 3122 6/22 9122 12122 1,040,000.00 482,021.41 0.00 482,021.41 4 Indiana Development Finance Authority Bosch Property (Forgive) 2001 2021 210 - - - - 260,000.00 133,214.96 0.00 133,214.96 2 State Industrial Development Fund Bosch Property 2002 2017 210 411 10/1 - - 1,000,000.00 0.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 is Indiana Development Finance Authority Frederickson Park (Forgive) 2003 2012 404 - - - - 191,202.40 0.00 0.00 0.00 15 Indiana Development Finance Authority Anchor 2005 2014 404 6/30 12/31 - - 600,000.00 66,666.72 0.00 66,666.72 17 Indiana Development Finance Authority Anchor (Forgive) 2005 2014 404 - - - - 75,000.00 10,714.32 0.00 10,714.32 so HUD Section 108#8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4,000,000.00 1,005,000.00 0.00 1,005,000.00 e3 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8115 - - 1,102,549.56 343,532.46 0.00 343,532.46 s4 interfund Fund 412 - Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,040,319.00 923,829.00 0.00 923,829.00 a1 Intertund Fund 619 - Blackthom Blackthorn Equip (golf carts) 2010 2017 619 5115 6115 7115 8115 31,032.00 15,516.00 0.00 15,516.00 ea Intedund Fund 412 - Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2,000,000.00 1,460,723.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,451,651.03 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 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 34,615.62 0.00 34,615.62 Total Loans Payable 22,058,511.06 8,427,484.52 0.00 0.00 0.00 8,427,484.52 Capital Lease 75 PNC Equipment Financing xbc Blackthorn Golf Carts 2010 2015 619 Monthly 246,509.64 106,802.80 0.00 106,802.80 Total Capital Lease 246 509.64 106 802.80 0.00 0.00 0.00 106 802.80 Leases 37 Transpo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3,000,000.00 371,710.00 0.00 371,710.00 13 Transpo Lease xxx Main /Colfax Garage 2006 2025 404 3/15 9/15 - - 2,510,278.00 1,788,501.00 0.00 1,788,501.00 Total Lease 5,510,278.00 2,160,211.00 1 0.00 0.00 0.00 2,160,211.00 Total Redevelopment Commission 167,235,298.70 93,817,831.66 1 645,000.00 166,12875 0.00 93,172,831.66 Total Debt 0 447,189,280.44 257,584,991.66 1,793,052.97 628,603.69 0.00 255,791,938.69 Financial Repot January 2014 - Debt Page 24 0/28 City of South Bend Staffing Headcount Summary City Total 1328.00 0.00 0.00 1.00 4.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Financial Report January 2014 - Headcount Staffing Page 25 of 28 Budget Prior Full Time Jan I Feb I Mar I Apr I May Jun I Jul Aug Sep Oct I Nov I Dec I Year End Full Time Staff 1160.00 1116.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 Part Time Staff 74.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Temporary /Seasonal 1 138.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 City Total 1328.00 0.00 0.00 1.00 4.00 3.00 2.00 2.00 2.00 2.00 1.00 1.00 0.00 Financial Report January 2014 - Headcount Staffing Page 25 of 28 City of South Bend Staffing Headcount Full Time Staff General Government Mayor 7.00 7.00 311 Call Center 7.00 7.00 Admin & Finance 23.00 21.00 Safety & Risk 3.00 3.00 Clerk 5.00 5.00 Common Council 9.00 9.00 L al De artment 10.00 9.00 Sub Total 64.00 61.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 Code Enfor. /Animal Control 26.00 24.00 Dept. of Community Investment 26.00 26.00 Parks & Recreation Public Safety Public Works Administration 12.00 11.00 Maintenance 44.00 44.00 Golf Operations 8.00 8.00 Recreation Cps/ 26.00 26.00 Zoological Ops 23.00 3.00 Greenhouse Ops 0.00 0.00 Graffiti Removal 1.00 1.00 Recreation Nonreverting 1.00 1.00 Sub Total 115.00 94.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 Police 297.00 289.00 Communications 38.00 32.00 Fire 260.00 263.00 Sub Total 595.00 584.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 Central Services 40.00 37.00 Engineering 15.00 14.00 Maintenance 3.00 3.00 Solid Waste Operations 25.00 25.00 Street Operations 60.00 60.00 Sewer Operations 35.00 35.00 Waste Water Ops 45.00 44.00 Organic Resources 6.00 6.00 Water Utilit O s 70.00 69.00 Sub Total 299.00 293.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 Building Department 15.00 14.00 Human Rights 6.00 6.00 Morris & Palais 14.00 14.00 City Total 1160.00 1116.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report January 2014 - Headcount Staffing Page 26 of 28 City of South Bend Staffing Headcount Part Time Staff Prior Jan Feb Mar I Apr May I Jun I Jul Aug I Sep I Oct Nov I Dec Year End General Government Mayor 1.00 Admin & Finance Clerk Common Council Legal Department 4.00 Sub Total 5.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 Code Ent. /Animal Control 2.00 Dept. of Community Investment 1.00 Parks & Recreation Public Safety Administration 5.00 Maintenance 3.00 Golf Operations Recreation Ops 30.00 Zoological Ops 6.00 Greenhouse Ops Graffiti Removal Sub Total 44.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 Police 4.00 Communications Fire 1.00 Sub Total 5.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 Public Works Central Services 1.00 1.00 0.00 Engineering 4.00 Traffic & Lighting Maintenance Solid Waste Ops 2.00 Street Ops 3.00 Sewer Ops Waste Water Ops Water Utilit Ops 1.00 Sub Total 11.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Building Department 0.00 Human Rights 1.00 0.00 Morris & Palais 5.00 City Total 74.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report January 2014 - Headcount Staffing Page 27 of 28 City of South Bend Staffing Headcount Temporay & Seasonal Staff Public Works Building Department Human Rights Morris & Palais Central Services Engineering 1.00 Traffic & Lighting Maintenance Solid Waste Ops 8.00 Street Ops 2.00 Sewer Ops 5.00 Leaf Pickup Waste Water Ops Organic Resources 1.00 Water Utilit Ops 3.00 Sub Total 20.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 City Total 138.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 Financial Report January 2014 - Headcount Staffing Page 28 of 28 Prior Jan Feb Mar Apr P I May y l Jun Jul Au Aug l Se P Oct Nov Dec Year End General Government Mayor Admin & Finance 1.00 Clerk Common Council Le al Sub Total 1.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 Code Enforcement 1.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 Parks & Recreation Administration 5.00 Maintenance 17.00 Golf Operations 1.00 Recreation Ops 51.00 Zoological Ops 0.00 Greenhouse Ops 0.00 Graffiti Removal 1.00 Sub Total 75.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 Public Safety Police 41.00 Communications Fire Sub Total 41.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 Public Works Building Department Human Rights Morris & Palais Central Services Engineering 1.00 Traffic & Lighting Maintenance Solid Waste Ops 8.00 Street Ops 2.00 Sewer Ops 5.00 Leaf Pickup Waste Water Ops Organic Resources 1.00 Water Utilit Ops 3.00 Sub Total 20.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 City Total 138.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 Financial Report January 2014 - Headcount Staffing Page 28 of 28