Loading...
HomeMy WebLinkAbout03-2015 Financial ReportPeriod Ending: March 31, 2015 Issued By: 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 -12 Property Tax Revenue Collection Status Expenditures 13 -17 Expenditures by Fund and Department Debt 18 -19 Debt Status Debt Monthly 20 -21 Current Debt at Month End Headcount 22 -25 Staffing Levels Distribution Mayor Chief of Staff Deputy Chief of Staff Controller Deputy Controller City Finance Director Sr. Budget Analyst Department Heads Fiscal Officers City Common Council Pete Buttigieg Kathryn Roos Brian Pawlowski John Murphy Jennifer Hockenhull Rahman Johnson Cecil Eastman Financial Report March 2015 Page 1 of 25 March 31, 2015 Financial Report The Financial Report provides current year financial information for each City fund in a condensed format. Information is provided for revenue (by type and fund), expenditures, property taxes, debt status, and staffing levels. This report is prepared monthly and supplements other reports that the City prepares such as, the Controller's Cash Report, the Monthly Departmental Financial Report, and the Comprehensive Annual Financial Report (CAFR). 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 17 %. The overall percentage of collected revenue amount for March 2014 was 15 %. Revenue type 369 (Memorial Hospital), has reached 100% of its budgeted revenue. This is revenue from Leighton Plaza for common area fees. It is a lease between Memorial Hospital and the South Bend Redevelopment Commission. Revenue type 391 (TIF 324), received $1,472,130 from the sale of Blackthorn Golf Club. Revenue by fund As of March 31, 2015, the general fund has received 6% of its budgeted revenue, similar to last year. The following funds have reached slightly above the normal percentage of their 2015 budgeted revenue amount at this time: Funds 249, 404, and 408 did not receive their monthly distributions from the County this month. They will be received in April. Fund 294 (Police Academy). This is tuition revenue related to the advancement of present and future police officers. Fund 289 (Hazmat). This fund has reached 138% of its budgeted revenue. This is revenue generated by the South Bend fire department responding to hazardous materials incidents. Fund 643 (Sewage Reserve), is at 104% or $9,241 over its budgeted revenue. This is due to a transfer of $256,085 from fund 641 (Sewage Works Operations) for reserve purposes. Fund 429 (TIF Northeast), is at 176% or $631,209 over its budgeted revenue. This is due to a transfer of $1,430,965 from various TIF areas being realigned. Property taxes Property taxes are received in June and December. Property taxes collected for the year 2014 totaled -$72 million. Civil city funds received -$45 million and TIF funds received - $27 million. For 2014, the projected levy collection rate is 95% or $72.1 million. Please note, 2014 Civil City funds are $352,000 lower than 2013 budget and TIF funds are -$1.3 million less than 2013 budget. Total property taxes collected for the year 2013 was $69.8 million or 90.18 %. Specifically, in 2013 the City of South Bend received a total of $45,189,966 in property tax revenue in the civil city funds (general fund, parks, College Football Hall of Fame, and CCD). For TIF funds, the City received a total of $24,790,321 in property tax revenue. Expenditures As of March 2015, the City has spent 19% of budgeted expenditures compared to 18% of budgeted expenditures in March 2014. The General Fund has spent 26% of its 2015 budgeted expenditures, versus 24% in 2014. 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), Fund 432 (TIF - Erskine Village), and Fund 436 (Northeast Residential TIF). This month, Funds 420 and 426 had higher expenditures as money was transferred to Fund 324 (River West - Airport). This is a result of the TIF realignment. Debt In March 2015, several debt service payments were made in the amount of - $487,000 to Sun Trust, Kansas State Bank, PNC Bank, U.S. Bank and Ricoh USA. Payments are related to IT equipment leases, police / public works vehicles, solid waste containers, and sewer bonds. This month, $25 million in redevelopment bond debt was added for the purpose of Smart Streets. Headcount The Full Time Headcount as of March 2015 was 1,077 vs. a budgeted amount of 1,094. Currently, there are a total of 17 vacant positions. The 17 open positions are in the following departments: Public Safety (2), Public Works (10), Code Enforcement / Animal Control (2), Parks Recreation (2) and other (3). * In Public Safety (Fire), the headcount is over budget as there are currently three recruits in training to replace planned and unplanned departures. If you have any questions regarding this report, please contact John Murphy at (574) 235 -7678. Financial Report March 2015 Page 2 of 25 City of South Bend Period Ending: March 31, 2015 Revenue by Type Report S Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I f Bud et Property Tax ,to Excise Tax various 2,508,752 mmercial Vehicle Tax 311 Pro a Tax Civil Ci various tel Motel Tax Century Center 670 656,725 656,725 1,313, 436 45,606,508 0% 311 Pro a Tax T/F Districts various 420 489,500 tel Motel Tax Cum Cap Impm 27,117,274 0% Sub Total 656,725 656,725 5,834,126 335 State Pension Subsidy 7011702 72,723,782 0% Income Tax 211 11,557,092 0% 335 CTP Distribution 439 243,000 315 Econ Development Income Tax 408 765,101 765,101 1,530,201 8,981,877 17% 316 Local Option Income Tax -PS 249 538,849 538,849 1,077,698 6,466,190 17% 316 County Option Income Tax 404 738,326 738,326 1,476,652 8,859,912 17% Sub Total 101 2,042,276 2,042,276 4,084,551 24,307,979 17% ;ounty (Remitted by) ,to Excise Tax various 2,508,752 mmercial Vehicle Tax various 883,438 tel Motel Tax Century Center 670 656,725 656,725 1,313, 436 tel Motel Tax Century Center 324 489,000 tel Motel Tax Century Center 420 489,500 tel Motel Tax Cum Cap Impm 407 150,000 b Total 656,725 656,725 5,834,126 State of Indiana Remitted b deral Drug 312 CRED Tax 434 99,293 31,642 33,371 75,000 650,000 0% 335 Cigarette Tax 1011407 810 810 35,000 yment in Lieu of Tax 317,818 0% 335 State Pension Subsidy 7011702 1,359,954 5,439,810 ntractual Service 211 11,557,092 0% 335 CTP Distribution 439 243,000 nds various 162,418 798,302 NA 335 Gaming Proceeds 101 b Total 201,656 468,230 464,579 600,000 0% 335 Gasoline Tax 2021251 348,926 369,636 422,676 1,141,238 4,647,000 25% 335 Liquor Excise tax 101 41,349 125,201 140,744 41,349 65,000 64% 335 Liquor Gallon eTax 101 67,259 303,580 303,580 67,259 200,000 34% 335 ProfSports Development Tax 377 63,326 142,874 63,470 269,670 610,000 44% 335 Wheel Tax 202 418,779 1,233,503 67,941 486,720 2,050,000 24% Sub Total 939,639 512,510 554,087 2,006,236 20,696,910 10% governmental Sources deral Drug 299 1,729 99,293 31,642 33,371 75,000 vte Drug 216 340 General Government Misc Ch s 1011289 810 810 35,000 yment in Lieu of Tax various 453,318 453,318 453,318 1,359,954 5,439,810 ntractual Service 211 13,183 11,261 14,750 39,194 243,000 nds various 162,418 798,302 20% 380 Central Service 222 b Total 201,656 468,230 464,579 500,519 1,433,328 5,792,810 Charge for Service Internal City 340 Liability Insurance 226 99,293 101,897 101,897 303,088 1,222,727 25% 340 General Government Misc Ch s 1011289 6,000 0% 340 Police Take Home Vehicle 278 7,060 4,680 4,670 16,410 61,100 27% 349 Central Service 222 51,890 62,282 48,246 162,418 798,302 20% 380 Central Service 222 199,523 201,656 208,098 609,277 2,800,655 22% 380 Energy Office Reimbursements 222 383,538 417,794 450,403 1,251,735 4,471,200 28% 380 Internal Service Reimbursement various 114,099 125,201 140,744 380,043 2,853,706 13% 392 Administration Fee 101 303,580 303,580 303,580 910,739 3,642,953 25% 392 Internal Fund Transfers various 966,983 3,518,478 7,340,433 11,825,893 27,830,470 42% 395 Employee Benefits 711 1,234,237 1,233,503 1,224,809 3,692,549 16,425,996 22% Financial Report March 2015 - Revenue Report Page 3 or25 City of South Bend Period Ending: March 31, 2015 Revenue by Type Report S Fund % Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I of Bud et 396 Central Service Refunds 222 2,968 1,971 4,939 22,000 22� 396 Self Funded Employee Benefits 711 13,173 13,173 NI Sub Total 3,373,375 5,972,039 9,824,850 19,170,263 60,135,109 32� ,d Party Revenue 340 No EMS Service 101 320 Inspections Central Service 11,080 11,080 150,000 7� 340 Memorial Hospital Neo Natal 101 10,022 56,678 36,788 103,487 N! 350 Job Target Penalty Fee 408 20,630 75,335 117,340 354,660 0� 364 Cable TV Franchise Fees 101 177,167 4,795 177,167 750,000 24� 366 AT&T Franchise Fees 101 69,037 600 69,037 245,000 28� Sub Total 301,582 10,022 302,882 47,868 360,772 1,499,660 24� rants 331 Federal Grants various 321,650 121,681 172,179 615,510 5,465,445 11� 334 State Grants various 1,600,000 0� Sub Total 321,650 121,681 172,179 615,510 7,065,445 9`, Fees for Services External 320 Inspections Central Service 222 330 330 1,400 24% 321 Business License 1011222 31,966 22,740 20,630 75,335 117,340 64% 321 Code and Animal Fees 600 3,725 4,795 5,793 14,313 59,850 24% 322 Building Fees 600 65,509 54,764 181,309 301,582 1,083,832 28% 322 Code Enforcement Fees 600 150 450 1,500 2,100 NA 322 EMS Operating Fund 288 2,233 2,460 1,295 5,988 24,500 24% 322 General Government Fees 101 6,640 725 1,030 Z. 8,395 10,000 84% 341 General Government Various various 1,736 1,940 1,164 4,840 27,405 18% 342 Highway & Streets 1011202 24,377 9,564 2,090 36,031 390,000 9% 342 Public Safety various 22,350 26,067 13,071 61,488 130,000 47% 342 EMS - Count Fees 288 426,728 426,728 1,667,565 26% 342 EMS - Capital Fund 287 396,727 396,727 NA 342 EMS - Operating Fund 288 198,675 156,466 226,551 581,692 2,900,000 20% 342 EMS - Neo Natal 288 385,000 0% 344 Solid Waste 610 401,357 397,131 400,073 1,198,561 5,091,168 24% 344 Code Environmental Clean Up 101 1600 11,215 1,263 1,051 13,529 50,000 27% 344 Sewage Waste Water 641 2,776,091 2,783,483 2,821,111 8,380,684 35,234,467 24% 344 Sewer Repair Insurance 640 50,523 52,458 49,781 152,762 548,000 28% 344 Water Leak Insurance 620 80,558 79,817 80,181 240,555 960,000 25% 346 Water Works Utility 620 979,733 976,299 965,088 2,921,120 13,678,403 21% 346 Solid Waste Misc 610 5,075 4,623 6,710 16,408 128,148 13% 346 Project ReLeaf 655 36,473 36,203 36,396 109,072 429,000 25% 347 Parks& Recreation various 88,374 165,687 152,152 406,214 3,565,575 11% 347 Blackthorn Golf Club 619 99,156 20,083 0 119,238 1,696,879 7% 347 Morris PAC 416 7,870 1,419 9,761 19,050 100,000 19% 349 Parkin Garage Fees 601 77,130 56,458 83,412 216,999 973,926 22% 349 Code Demolition Board Up 1011600 2,932 9,994 467 13,393 20,000 67% 349 Parking Century Center 670 8,435 17,329 24,852 50,616 162,000 31% 349 Parking SBCDA 3241420 2,950 2,981 4,246 10,176 51,000 20% 351 Fines &Fees various 21,684 35,187 12,331 69,202 270,720 26% 352 Forfeits various 3,455 875 2,775 7,105 258,820 3% 354 Ordinance Violation various 1,305 2,165 4,133 7,603 35,500 21% 360 Morris PAC various 52,561 22,635 129,679 204,874 934,900 22% 360 Palais Royale various 22,259 6,290 10,385 38,934 243,820 16% 360 Parks& Recreation various 26,797 14,565 4,051 45,414 106,700 43% 360 Police various 3,170 4,378 2,510 10,058 46,600 22% 360 TIF various 5,056 2,657 3,480 11,193 44,806 25% 360 Central Services 222 19,705 3,212 15 22,932 11,000 208% 360 Century Center 670 5,117 4,970 35,471 35,618 25,000 -142% 360 Dept Of Community Investment 2111212 95,353 85,179 180,532 247,000 73% 360 EMS Operating Fund 288 60 60 5,000 1% 360 Engineering/ Curb & Sidewalk 101 209 200 32,648 32,239 22,000 -147% 360 Police Pension Fund 702 4,000 0% 360 Self Funded Employee Benefits 711 6,000 6,000 NA 360 General Government Various 101131226 196 853 1,386 2,436 2,100 116% 360 Motor Vehicle Highway Scrap Meta 202 1,735 1,735 4,000 43% 360 Motor Vehicle Highway Curb Pr gm 202 3,615 324 6,819 10,758 50,000 22% 360 ProfessionalSports Development 377 29,523 29,523 60,661 49% 360 UDAG 410 98,485 98,485 438,203 22% 360 Code /Animal Control 600 0 0 NA 360 Parkin Garage 601 3 3 NA Financial Report March 2015 - Revenue Report Page 4 025 City of South Bend Period Ending: March 31, 2015 Revenue by Type Report S Fund Reci lent Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov I Dec I Year I Budget I of Bud et 360 Solid Waste Fund 610 391 TIF 2,000 0% 360 Waste Water 6411719 2,142 3,229 2,177 5,371 53,000 10% 360 Water Works Utility 620 908 1,318 2,225 39,580 6% 362 Dept Of Community Investment 212 1,847 1,847 Sub Total NA 362 Palals Royale 101 572 2,269 2,588 5,429 72,000 8% 362 Parks & Recreation 201 2,064 4,531 4,138 10,733 40,000 27% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 15,621 17,156 19,059 51,836 408,733 13% 369 Memorial Hosp Leighton Plaza 408 150,000 150,000 150,000 100% 371 Century Center Fees 670 29,668 761,205 442,960 347,913 3,032,126 11% 399 Bosch Retention Project 210 59,966 0% 399 Principal on Loan various 1,799 20,705 18,387 40,890 414,796 10% 399 Principal Income xxx 368,031 368,031 1,224,390 30% Sub Total 5,476,452 6,558,266 5,412,473 17,447,190 77,817,879 22% iterest Income 361 Bank Account Interest various 197,258 51,054 75,698 324,011 766,712 42� Sub Total 197,258 51,054 75,698 324,011 766,712 42`, onations 367 ND Contribution 101 405 405 330,000 02 367 Donations various 2,072 990 3,062 239,206 1`, Sub Total M 2,072 990 405 3,467 569,206 1`, istoric Preservation 368 Lamp Program 227 19,750 19,750 30,000 66`, 368 Palais 450 1,225 3,703 357 5,285 16,000 33`, Sub Total 1,225 3,703 20,107 25,035 46,000 54`, ale of Assets 391 TIF various 34,357 1,472,130 1,506,487 2,872,130 52! 391 Water Hydrant Reimbursement 620 2,177 2,177 20,000 11`, 391 Proceeds F.A. Disposal 600 N/ 391 Sale of Fixed Assets various 12,000 0`, 391 Vehicle Damage Reimbursement various 1,000 0`, Sub Total 34,357 1,474,307 1,508,664 2,905,130 52! Revenue Total 12,866,555 16,029,980 18,739,220 - - - - - - - - - 47,635,755 280,174,306 171, report 12, 866, 555 16, 029, 980 18,739, 220 - - - - - - - - - 47, 635, 755 280,174,306 0 0 0 0 Financial Report March 2015 - Revenue Report Page 5 or25 City of South Bend Revenue by Fund Report Period Ending: March 31, 2015 s i Fund Jan I Feb I Mar I Apr I May Jun I Jul I u ,,P 1 Oct Nov Dec I Year I Bud et I ofeud et General Government 0000 General Revenues 101 1,167,120 944,443 669,668 2,781,231 50,195,282 6% 0101 Mayor 101 35 15 50 600 8% 0104 311 Call Center 101 55,195 36,290 43,995 135,480 470,291 29% 0301 Common Council 101 41 31 15 87 8,455 1 0401 Administration and Finance 101 220 336 556 30,050 2% 0501 Legal 101 508 508 53,000 1% Sub Total 1,222,390 981,491 714,030 2,917,911 50,757,689 6% Public Works 0602 Engine rin 101 225 225 77,027 0% Sub Total 225 225 77,027 0% Public Safety 0801 Police 101 6,604 11,372 38,367 56,343 537,700 10% 0901 Fire 101 10,022 59,625 37,787 107,434 12000 895% Sub Total 16,625 70,998 76,154 163,775 549,700 30% Code Enforcement 1205 Code Unsafe Building 101 143 733 876 NA 1207 Code Animal Control 101 NA Sub Total 143 733 876 NA Arts & Culture 0404 Morris PAC 101 53,329 23,300 128,425 205,054 923,000 22% 0405 Palais Royale 101 24,368 9,347 13,572 47,287 334,820 14% Sub Total 77,697 32647 141,998 252,342 1257,820 20% General Fund Revenue Total 1,316,569 1,085,136 931,673 - - - - - - - - - 3,333,379 52,642,236 6% Financial Report March 2015. Exp -dk- Summary Page 6 of 25 City of South Bend Revenue by Fund Report Period Ending: March 31, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun Ug I SP Nov Dec I Year I Budget I ofBUd et Parks & Recreation 0000 Parks General revenue 201 76,460 74,383 77,445 228,289 8,860,875 3% 1100 Administration 201 2,119 4,537 4,158 10,815 40,600 27% 1101 Maintenance 201 19,996 2425 3,330 25,750 319,600 8% 1102 GolfOperations 201 161 63,205 31,916 95,283 1,535,000 6% 1103 Recreation Division 201 26,067 16,036 5,765 47,868 185,640 26% 1104 Potawatomi Zoo 201 NA 1108 Grafd Removal 201 11,341 11,341 89,000 13% Recreation Non Reverting 203 65,607 98,601 lIZ441 276,649 1,578,935 18% East Race Waterway 271 5 1 2 8 NA Coveleski Stadium 401 36 9 14 59 15,100 0% Zoo Endowment 403 43 11 17 72 200 36% Park Non Reverting 405 4,435 260 261 4,956 143,700 3% Sub Total 194,930 270,809 235,349 701,088 12,768,650 5V Public Works Motor Vehicle Highway 202 716,020 1,133,459 404,476 2,253,955 9,681,300 23% Central Services 222 655,888 688,603 709,665 2,054,157 8,121,097 25% Central Services Capital 224 271,850 0% Local Roads & Streets 251 87,782 90,155 98,666 276,603 1,593,300 17% Pro'ect ReLeaf 655 37,371 36,419 36,757 110,548 431,700 26% Sub Total 1,497,062 1 948 636 1,249,565 4 695,263 20 099,247 23% Public Works Solid Waste Solid Waste Operations 610 408,178 401,846 406,879 1,216,903 5712 289 21% Solid Waste Capital 611 190,033 10,001 200,034 753,011 27% Sub Total 598,211 401,846 416,880 1416,937 6,465,300 22% Public Works Water Utility 0000 Water Works Revenues 620 916,194 910,250 905,299 Z 731,743 12 704,463 22% 0630 Water Leak Insurance 620 80,558 79,817 80,181 240,555 960,000 25% 0660 Clay Water 620 68,898 68,829 66,186 203,913 1,096,020 19% Waterworks Capital 622 Z 776 682 1,098 4,556 10,000 46% Waterworks Construction 623 180 41 62 283 NA Waterworks Deposit 624 1,307 324 527 2,157 6,000 36% Waterworks Sinking 625 468 340,551 170,359 511,378 2,050,078 25% Waterworks Bond Reserve 626 1,425 353 572 2351 NA Waterworks Debt Reserve 629 1,840 150,683 775 153,298 16Z 749 94% Sub Total 1,073,645 1,551,529 1,225,058 3,850,232 16,989,310 23% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 51,853 52,790 50,328 154,971 549,200 28% 0000 Wastewater Revenues 641 2,628,692 2,622,801 2,675,830 7,927,324 33,197,505 24% 0621 Sewer Department 641 2,000 0% 0625 Concrete Crew 641 4,705 4,705 75,000 6% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 157,337 162,329 150,270 469,936 2,059,962 23% Sewage Capital 642 3,385 815 1,313 5,512 5,398,000 0% Sewage Reserve 643 3,020 256,833 1,248 261,101 250,612 104% Sewer Bond 2007 647 NA Sewage Bond Sinking 649 774,321 773,801 774,198 2,322,320 9,288,088 25% Sewer Bond 2007B 651 0 0 NA Sewage Works DS Reserve 653 NA 2010 CSO Net Sewer Bond 658 0 0 NA 2011 Sewer Bond 659 1,477 330 386 2,193 6,000 37% 2012 Sewer Bond 661 14,968 3,669 5,897 24,535 20,000 123% 2013A Sewer Refund Bonds 664 4 1 2 7 NA Sub Total 3,635,057 3,878,074 3,659,472 11,172,603 50,846,367 22% Financial Report March 2015. Exp -dk- Summary Page 7&25 City of South Bend Revenue by Fund Report Period Ending: March 31, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep 1 Oct Nov Dec I Year I Budget I ofeud et Public Safe - Police 601 909 909 4,000 23% Police Seizures 216 162 41 876 1,079 35,900 3% Curfew Violations 218 11 3 17 30 1,025 3% Law Enforcement Educadon 220 24,859 28,459 17,376 70,694 211,000 34% Public Safe Lon. 249 540,008 539,058 430 1,079,495 6,472,190 17% Excess Welfare Public Safety 252 0 - - 0 15.900 NA Police Take Home Vehicle 278 14,575 9,474 9,529 33,578 124,200 27% Police Block Grant 280 3 1 1 6 NA Police Grants 292 55 55 90,000 0% Police cademy 294 11,010 7,628 1,101 19,740 22,000 90% COPS More Grants 295 564 782 681 2,026 128,258 2% Drua Enforcement 299 1,817 83 31,713 33,613 77,000 44% K -9 Unit 705 503 1 1 505 2,000 25% Sub Total 593,567 585,530 61,724 1,240,821 7,163,573 1751 Publie Safe - Fire nc Te /e hone S stem 244 19 19 NA ital 287 396,727 13 396,740 750,000 53% erafin Fund U 288 204,337 169,122 667,161 1,040,620 5,676,065 18% 289 3 732 10 095 10 13 838 f0 000 138% scue 291 3,093 Z423 3,038 8,554 45,200 19% Sub Total 211,182 578,368 670,222 1459,772 6,481,265 23% Department of mmunity Investment Studebaker /Oliver 209 959 3,612 16,720 21,291 574,000 4% State Grant 210 290 70 112 473 1,673,510 0% ,,Cl Operating 211 14,699 503,257 17,090 535,047 Z 631,625 20% 0000 De t. of Community Investment 212 3,790 122 753 240,619 367,162 4,100,000 9% xxx Pro rams 212 95,353 95,353 NA 0000 Economic Revenue Bond 281 24 6 10 40 NA Sub Total 115,115 629,699 274,551 1,019,365 8,979,135 11 0000 Parking Garage Revenue 601 909 909 4,000 23% 0460 Main Street 601 20,879 17,180 24,111 62,170 267,487 23% 0462 Leighton Plaza 601 38,528 22,329 36,745 97,602 451,691 22% 0463 Enforcement 601 5,219 7,017 6,595 18,830 114,900 16% 0464 Wayne Street 601 17,498 16,724 22,424 56,646 254,748 22% 0465 Eddv Street Commons 601 - - - - 15.900 0% Financial Report March 2015. Exp -dk- Summary Page 8 of 25 City of South Bend Revenue by Fund Report Period Ending: March 31, 2015 s i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Budget I ofeud et Other Miscellaneous Rain Da 102 7,630 1,888 3,064 12,582 34,680 36% Excess Le 103 1 1 2 NA Gift Donation Bequest 217 1,618 989 364 2,972 216,100 1% Loss Recovery 227 5,206 4,007 21,727 30,941 34,200 90% Human Rights 258 2,065 7,188 5,759 15,011 203,400 7% Morris Palais Marketing 273 274 6 1,373 1,652 18,000 9% Professional Sports Development 377 93,375 142,965 63,547 299,888 671,761 45% 1201 Code Enforcement 600 18,559 529,948 11,282 559,789 2,378,996 24% 1207 Animal Control 600 3,725 162,197 5,846 171,768 689,218 25% 1306 Building Operations 600 66,158 54,907 181,599 302,664 1,085,899 28% Century Center 670 32,985 783,504 203,146 1,019,635 4532,562 22% Century Center Capital 671 24 21 23 68 500 14% Sub Total 231,619 1,687,621 497,732 2,416,972 9,865,316 24% Business Insurance 0000 Business Insurance Revenues 226 104,344 103,108 103,815 311,266 1,243,227 25% 0418 Workers Compensation 226 17,000 0% Sub Total 104,344 103,108 103,815 311,266 1,260,227 25% Fiducia Trust & Agency Fire Pension 701 688 130 54 872 5,211,592 0% Police Pension 702 1,133 230 184 1,546 6,360,000 0% Employee Benefits lCi 711 1,248,718 1 226 227 1,217,884 3 692,829 16 223,345 23% Unemployment Comp 713 8,685 8,526 8,559 25,770 226,796 11 Cemetery Trust 730 25 6 10 41 150 28% Sub Total 1,259,249 1 235 119 1,226,689 3 721,058 28 021,883 13% Civil City Revenues 12,653,540 15,953,113 10,816,094 - - - - - - - - - 39,422,747 246,360,290 16% Tax Increment Financing TIF Airport 324 50,350 33,228 6,479,376 6,562,954 20,324,106 32% TIF Central Development 420 695 4,240 (4,935) 4,344,202 0% TIF West Washington 422 996 261 423 1,680 422,000 0% TIF Leighton Plaza 425 18,229 12,971 10,040 41,239 189,123 22% TIF Medical Service 426 1,941 501 (2,442) 632,000 0% TIF Northeast 429 23,215 993 1,434,000 1,458,209 827,000 176% TIF Southside 430 4,144 1,025 1,590 6,758 2,410,000 0% TIF Erskine Village 432 5,246 1,268 1,967 8,481 25,000 34% TIF Douglas Road 435 161 48 23 232 320,750 0% Northeast Residential TIF 436 1,215 352 5 1,571 2,604,000 0% Sub Total 106,191 54,887 7,920,047 8,081,124 32,098,181 25% Financial Report March 2015. Exp -dk- Summary Page 9 of 25 City of South Bend Revenue by Fund Report Period Ending: March 31, 2015 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 ofBUd et Redevelopment Commission 213,015 76,867 7,923,126 - - - - - - - - - 8,213,008 33,814,016 24% City Operations Total 12,866,555 16,029,980 18,739,220 - - - - - - - - - 47,635,755 280,174,306 17% Revenue report 12,866,555 16,029,980 18,739,220 0 0 0 0 0 0 0 0 0 47,635,755 280,174,306 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report March 2015. Expenditure Summary Page 10 of 25 City of South Bend Property Tax Revenue 2013 Tax Pay 2014 Fund Period Ending: March 31, 2015 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61612014 612512014 1212412014 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,715,401.11 0.95 36,779,631.05 13,984,752.01 6,078,082.84 16,646,154.38 36,708,989.23 2,006,411.88 94.82% Parks & Recreation 201 7,760,516.48 0.95 7,372,490.66 2,803,248.70 1,218,353.96 3,343,785.26 7,365,387.92 395,128.56 94.91% College Football Hall of Fame 313 524,471.43 0.95 498,247.86 - 271,788.05 225,979.78 497,767.83 26,703.60 94.91% Cumulative Capital District 406 453,896.12 0.95 431,201.31 163,956.07 71,258.93 195,570.89 430,785.89 23,110.23 94.91% Fire Pension 701 - 0.95 - - - 2,478,709.77 - - - Police Pension 702 99,497.78 0.95 Erskine Commons TIF District #2 431 0.95 - Total - City - 47,454,285.14 Erskine Village TIF District #3 45,081,570.88 16,951,956.78 7,639,483.78 20,411,490.31 45,002,930.87 2,451,354.27 94.83% Tax Increment Financinq Airport TIF District 324 15,600,858.95 0.95 14,820,816.00 7,521,012.22 6,763,722.21 14,284,734.43 1,316,124.52 91.56% South Bend Central TIF District 420 4,376,939.50 0.95 4,158,092.53 2,485,265.66 1,824,461.25 4,309,726.91 67,212.59 98.46% West Washington TIF District 422 602,782.79 0.95 572,643.65 304,152.20 276,835.15 580,987.35 21,795.44 96.38% Central Medical TIF District 426 764,755.26 0.95 726,517.50 459,659.10 391,551.74 851,210.84 (86,455.58) 111.30% Northeast Residential TIF District 436 2,674,146.48 0.95 2,540,439.16 1,382,498.19 1,343,410.58 2,725,908.77 (51,762.29) 101.94% Southside TIF District # 1 430 2,478,709.77 0.95 2,354,774.28 1,268,946.48 1,110,265.51 2,379,211.99 99,497.78 95.99% Erskine Commons TIF District #2 431 0.95 - - - - Erskine Village TIF District #3 432 - 0.95 - 9,175.08 - 9,175.08 (9,175.08) 100.00% Douglas Road TIF District 435 321,894.56 0.95 305,799.83 160,947.28 160,947.28 321,894.56 - 100.00% Northeast TIF 429 1,649,304.42 0.95 1,566,839.20 808,183.73 760,056.03 1,568,239.76 81,064.66 95.08% Airport Urban Enterprise Zone 454 0.95 - - - - Other xxx - Total - Tax Increment Financing 28,469,391.73 27,045,922.14 14,399,839.94 12,631,249.75 27,031,089.69 1,438,302.04 94.95% Grand Total 75,923,676.87 72,127,493.03 16,951,956.78 22,039,323.72 33,042,740.06 72,034,020.56 3,889,656.31 94.88% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 616114 2 Distribution 2 - Issued by St. Joseph County on 6125114 3 Distribution 3 - Issued by St. Joseph County on 12124114 Financial Report March 2015 - Property Tax Revenue Page 11 of 25 City of South Bend Property Tax Revenue 2012 Tax Pay 2013 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61412013 611712013 1212312013 Total Property Tax Collection Airport TIF District Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,369,939.03 0.95 36,451,442.08 13,051,204.28 6,798,591.66 16,401,600.74 36,251,396.68 2,118,542.35 94.48% Parks & Recreation 201 7,623,780.24 0.95 7,242,591.23 2,593,163.21 1,350,822.26 3,263,074.28 7,207,059.75 416,720.49 94.53% College Football Hall of Fame 313 1,341,607.54 0.95 1,274,527.16 - 693,822.13 574,356.46 1,268,178.59 73,428.95 94.53% Cumulative Capital District 406 490,121.50 0.95 465,615.43 166,710.61 86,842.35 209,778.19 463,331.15 26,790.35 94.53% Fire Pension 701 - 0.95 - - - 2,618,580.97 - - - Police Pension 702 214,165.13 0.95 Erskine Commons TIF District #2 431 0.95 - - Total - City - 47,825,448.31 Erskine Village TIF District #3 45,434,175.89 15,811,078.10 8,930,078.40 20,448,809.67 45,189,966.17 2,635,482.14 94.49% Tax Increment Financinq Airport TIF District 324 15,275,702.92 0.95 14,511,917.77 7,111,555.29 6,228,798.58 13,340,353.87 1,935,349.05 87.33% South Bend Central TIF District 420 3,761,712.00 0.95 3,573,626.40 1,705,490.58 885,317.48 2,590,808.06 1,170,903.94 68.87% West Washington TIF District 422 584,897.07 0.95 555,652.22 264,689.94 228,918.51 493,608.45 91,288.62 84.39% Central Medical TIFDistrict 426 2,128,725.48 0.95 2,022,289.21 613,184.76 608,491.41 1,221,676.17 907,049.31 57.39% Northeast Residential TIF District 436 2,607,578.70 0.95 2,477,199.77 1,340,027.53 922,737.17 2,262,764.70 344,814.00 86.78% Southside TIF District # 1 430 2,618,580.97 0.95 2,487,651.92 1,381,537.24 1,022,878.60 2,404,415.84 214,165.13 91.82% Erskine Commons TIF District #2 431 0.95 - - - - Erskine Village TIF District #3 432 1,319,469.76 0.95 1,253,496.27 659,734.88 651,393.90 1,311,128.78 8,340.98 99.37% Douglas Road TIF District 435 322,082.97 0.95 305,978.82 164,167.82 159,770.93 323,938.75 (1,855.78) 100.58% Northeast TIF 429 1,152,857.67 0.95 1,095,214.79 431,978.67 409,648.70 841,627.37 311,230.30 73.00% Airport Urban Enterprise Zone 454 0.95 - - - - - Other xxx 0.95 - Total - Tax Increment Financing 29,771,607.54 28,283,027.16 13,672,366.71 11,117,955.28 24,790,321.99 4,981,285.55 83.27% Grand Total 77,597,055.85 73,717,203.06 15,811,078.10 22,602,445.11 31,566,764.95 69,980,288.16 7,616,767.69 90.18% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 614113 2 Distribution 2 - Issued by St. Joseph County on 6117113 3 Distribution 3 - Issued by St. Joseph County on 12123113 X Financial Report March 2015 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending: March 31, 2015 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et vemment ryor 101 80,464 52,550 48,452 181,466 741,267 1 Call Center 101 55,195 36,290 43,995 135,480 486,733 erk 101 34,775 28,270 26,114 89,159 431,573 immon Council 101 33,803 24,869 110,974 169,646 490,150 NIT Contract 101 411 411 43,000 Iministration and Finance 101 187,531 134,271 139,736 461,537 2,020,544 gal Department 101 99,178 73,129 64,725 237,031 1,006,979 ib Total 490,946 349,379 433,994 1,274,319 5,220,246 cs igineering 101 72,931 79,671 89,919 242,520 1,058,933 ib Total 72,931 79,671 89,919 242,520 1,058,933 ty dice 101 2,557,412 1,878,728 1,990,424 6,426,565 25,633,064 lice -PS LOIT funded 101 2,562 6,199 (8,761) Mice Communications 101 135,031 97 8 135,136 1,687,540 •e 101 2,150,469 1,590,349 1,505,644 5,246,462 17,774,474 v-PS LOIT funded 101 411 411 x ib Total 4,845,886 3,475,373 3,487,315 11,808,575 45,095,078 cement ode 101 2,270 ode Unsafe Building 101 ode Animal Control 101 ib Total 2 270 Ire nris PAC 101 96,838 87,590 80,670 265,098 1,093,132 dais Royale 101 41,912 31,105 39,827 112,844 536,293 ib Total 138,749 118,696 120,497 377,942 1,629,425 Ws iman Rights 101 50,323 31,896 19,693 101,912 373,179 ib Total 50,323 31,896 19,693 101,912 373,179 General Fund Expenditure Total 5,598,836 4,055,015 4,151,418 - - - - - - - - - 13,805,268 53,379,131 26% Financial Report March 2015. Exp -dk- Summary Page 13 of 25 City of South Bend Period Ending: March 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et Parks & Recreation Motor Vehicle Highway 1100 Administration 201 104,226 71,673 67,013 242,912 967,568 25% 1101 Maintenance 201 435,157 348,338 455,082 1,238,577 5,178,905 24% 1102 Golfo eradons 201 66,821 76,812 203,778 347,411 1,573,436 22% 1103 Recreation Division 201 193,339 143,079 147,938 484,357 2,328,698 21% 1104 Potawatomi Zoo 201 392,247 lIZ389 8,788 513,423 863,017 59% 1106 Potawatomi Greenhouse 201 5,079 20,391 5,260 30,731 53,997 57% 1108 Graffiti Removal 201 9,057 7,116 5,887 22,060 98,374 22% Recreation Non Reverting 203 43,898 60,957 66,785 171,640 1,549,469 11% East Race Waterway 271 968,839 1,479,202 1,183,962 3,632,003 4,000 0% Coveleski Stadium 401 1,000 850 1,850 3,540 0% Zoo Endowment 403 _ _ _ _ _ _ _ _ _ _ _ _ _ 49,000 0% Park Non Reverting 405 _ _ _ _ _ _ _ _ _ _ _ _ _ 192,933 0% Sub Total 659 1,249,824 840,754 960,531 3,051,109 12,862,937 24% Vorks Motor Vehicle Highway 202 734,565 950,683 835,051 2,520,298 8,843,890 Curb and Sidewalk 202 lIZ714 39,990 31,802 184,506 1,641,496 Central Services 222 679,565 621,835 691,937 1,993,337 8,300,242 Central Services Capital 224 4,000 8% Waterworks Capital 622 271,850 Local Roads & Streets 251 4,155 4,853 37,032 46,040 1,926,221 Project ReLeaf 655 15,357 2281 2386 20,025 528,358 Sub Total 452 1,546,355 1,619,642 1,598,209 4,764,205 21,512,057 Vorks Solid Waste Solid Waste Operations 610 635,488 341,051 339,903 1,316,442 5,873,863 Solid Waste Capital 611 223,749 143 11,054 234,946 752,811 Sub Total 859,237 341,194 350,957 1,551,388 6,626,674 Public Works Water Utility 0630 Water Leak Insurance 620 33,830 53,166 43,413 130,409 1,115,000 1291 0640 Water Works 620 906,773 1,320,043 1,131,090 3,357,906 14,725,471 23% 0660 Clay Water 620 22 29,608 309 331 4,000 8% Waterworks Capital 622 15,382 67,463 3,489 86,334 838,893 10% Waterworks Construction 623 11,278 37,750 4,276 53,304 53,085 100% Waterworks Deposit 624 452 324 527 1,302 6,000 22% Waterworks Sinking 625 465 1 84 550 2,050,078 0% Waterworks Debt Reserve 629 637 455 775 1,866 8,500 22% Sub Total 647 968,839 1,479,202 1,183,962 3,632,003 18,801,027 19% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 21,449 57,144 43,434 122,027 545,703 22% 0621 Sewer Repair 641 446,632 360,251 404,056 1,210,939 5,201,049 23% 0625 Concrete Crew 641 44,148 29,608 25,634 99,391 450,450 22% 0630 Wastewater Operations 641 2,004,256 2,110,111 1,803,497 5,917,864 31,017,413 19% 0631 Organic Resources 641 69,307 56,543 60,055 185,905 1,527,562 12% 0650 Clay Sewage 641 28 103 130 500 26% Sewage Ca ital 642 39,115 47,104 402228 488,448 9,071,710 5% Sewage Reserve 643 1,045 747 1,248 3,040 15,000 20% Sewer Bond 2007 647 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA Sewage Bond Sinking 649 1,000 850 1,850 9,282,109 0% Sewage Bond 2007 651 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 2010 CSO Net Sewer Bond 658 _ _ _ _ _ _ _ _ _ _ _ _ _ _ NA 2011 Sewer Bond 659 143,037 50Z 799 246,856 89Z 692 3,711,838 24% 2012 Sewer Bond 661 39,170 249,076 234,187 522,432 16,624,275 3% 2013 Sewer Bond 663 NA Sub Total 2,809,188 3,414,232 3,221,297 9,444,718 77,447,609 12% Financial Report March 2015. Exp -dk- Summary Page 14 of 25 City of South Bend Period Ending: March 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et Public Safe - Police EMS Ca ital 287 Seizures 216 35,728 750,000 EMS O eratin Fund 288 35,900 0% Violations 218 Hazmat 289 20,939 602 1,000 0% forcement Education 220 15,730 29,274 27,290 72,294 362,478 20% nc Tele hone S stem 244 20 1 21 183,750 365,625 NA Safe LOIT UE-ergency 249 73 2,055 515,347 549,323 1,796,725 7,246,551 25% Welfare Pu61ic Safet 252 369,417 329,268 372,756 1,146 0% Take Home Vehicle 278 55,859 153,529 335,865 545,253 71,100 0% Grants 292 1,268 15,297 11,946 15,297 105,145 15% Academ 294 2,725 9,673 242 12,639 23,750 53% More Grants 295 20,490 784 4,485 25,759 172,335 15% Dnfa Enforcement 299 18,385 6,474 18,397 43,256 248,960 17% K -9 Unit 705 2,899,524 2,754,112 970 970 2,000 49% Sub Total 789,405 576,850 600,685 1,966,940 8,270,365 24% sfe - Fire EMS Ca ital 287 209 35,728 35,728 750,000 EMS O eratin Fund 288 247,977 32,280 210,228 490,484 6,855,366 Hazmat 289 20,939 602 21,542 31,530 River Rescue 291 0 2,120 21,395 23,515 120,800 Sub Total 134,503 268,916 70,730 231,622 571,268 7,757,696 ent of Community Investment StudebakeLVOliver 209 16,261 3,375 6,335 9,710 630,000 State Grant 210 12,200 24,311 18,003 30,203 3,694,412 DCI Operating 211 250,396 178,976 186,881 616,253 2,661,730 Dept, of Community Investment 212 102,720 134,503 161,537 398,760 5,899,970 Administration 212 183,750 365,625 50% EDIT 15,900 Programs 212 4,101 12,414 64,293 16,514 647,998 Sub Total 369,417 329,268 372,756 1,071,441 13,534,110 Garages Main Street 601 16,261 29,534 14,520 60,314 262,391 Leighton Plaza 601 16,812 24,311 21,634 62,756 696,570 Enforcement 601 1,340 31,872 16,253 49,466 89,236 Wayne Street 601 54,617 27,884 11,887 94,387 742,615 Eddy Street Commons 601 183,750 365,625 50% EDIT 15,900 Sub Total 1,795,231 89,030 113,600 64,293 266,924 1,806,712 Ce I I /Debt Service Hall of Fame 313 636,000 - - 636,000 1,266,820 50% COIT 404 1,322,195 797,317 799,782 2,919,294 15,660,371 19% Cum Capital Development 406 112,650 56,546 169,196 542,691 31% Cum Ca ita /Improvement 407 183,750 183,750 365,625 50% EDIT 408 577,062 1,795,231 126,960 2,499,253 9,627,618 26% UDAG 410 438,203 0% Major Moves 412 55,859 153,529 335,865 545,253 3,096,061 18% Morris PAC Improvement 416 1,268 1,665 11,946 14,879 70,248 21% CRED 434 3,897 3,897 650,000 1% Palais Historic Preservation 450 16,150 0% Hallof Fame Ca ital 677 6,843 6,370 5,998 19,211 188,824 10% Sub Total 2,899,524 2,754,112 1,337,096 6,990,732 31,922,611 22% Financial Report March 2015. Expenditure Summary Page 15 of 25 City of South Bend Period Ending: March 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of Bud et Other Miscellaneous Self Funded Liability Ins Gift Donation _Bequest 217 26,675 27,830 136 27,966 297,182 9% Loss Recovery 227 181,590 298,680 822,026 1,302,296 5,237,243 25% Human Ri hts 258 22,061 9,167 26,033 57,261 247,357 23% Morris Palais Marketin 273 989,000 96 730 96 18,974 1 ProfessionalSports Development 377 480,773 800 2,019,201 481,573 854,803 56% 1201 Code Enforcement 600 120,449 101,851 94,621 316,921 2,414,485 13% 1207 Animal Control 600 57,484 47,550 49,635 154,668 696,216 22% 1306 Building Operations 600 104,444 75,646 91,217 271,307 1,094,700 25% Century Center 670 306,497 285,449 289,304 881,249 4,532,562 19% Century Center Capital 671 1,464,000 66,156 66,156 66,156 100% Sub Total 1,273,296 913,225 1,372,972 3,559,493 15,459,678 23% s Insurance Self Funded Liability Ins 226 26,134 26,675 14,630 67,440 282,900 Liability Insurance 226 156,054 7,585 32,230 195,870 1,184,891 Business Insurance 226 15,927 14,875 21,403 52,205 600,000 Workers Compensation 226 64,123 206,418 63,790 334,331 989,000 Sub Total 730 262,238 255,553 132,053 649,845 3,056,791 Trust & A enc Fire Pension 701 441,192 441,276 450,317 1,332,784 5,666,579 Police Pension 702 537,112 524,012 559,034 1,620,158 6,832,235 Employee Benefits 711 1,030,771 963,626 1,093,990 3,088,387 16,696,935 Unemployment Comp 713 10,126 5,167 9,025 24,318 226,796 Cemetery Trust 730 34,372 154,716 22% TIF Medical Service 20,000 Sub Total 2,019,201 1,934,080 2,112,366 6,065,647 29,442,545 Civil City Expenditure 21,003,306 18,697,459 17,690,217 - - - - - - - - - 57,390,981 301,879,943 19% Tax Increment Financing TIFAir ort 324 2,276,439 1,684,991 1,736,337 5,697,767 47,710,597 12% TIF Central Development 420 964,016 957,248 4,081,705 4,088,473 4,537,169 90% TIF West Washington 422 15,300 7,650 22,950 760,900 3% TIF Leighton Plaza 425 6,962 9,662 17,748 34,372 154,716 22% TIF Medical Service 426 2,294,533 2,294,533 2,476,033 93% TIF Northeast 429 112,956 5,000 117,956 7,239,524 2% TIF Southside 430 435,370 24,431 62,420 522,222 2,842,535 18% TIF Erskine Village 432 357,545 201,724 559,269 691,380 81% TIF Douglas Road 435 169,620 169,620 345,389 49% Northeast Residential TIF 436 1,464,000 246,589 1,710,589 3,425,632 50% Sub Total 5,617,288 1,400,070 8,200,393 15,217,751 70,183,875 22% Financial Report March 2015. Exp -dk- Summary Page 16 of 25 City of South Bend Period Ending: March 31, 2015 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun Jul I Au I Sep I Oct I Nov I Dec I Year I Budget of laud et �elo ment Funds Adminlstratlon 433 6,000 Certified Technology Park 439 198 198 5,000,000 Blackthorn Golf Operations 619 69,055 89,358 22,845 181,258 1,671,706 Sub Total 69,055 89,358 23,043 181,455 6,677,706 Cervlce Airport Debt Reserve 2003 315 317 227 368 912 5,000 Central Development reserve 328 530 379 615 1,524 6,000 Sub Total M 847 606 983 2,436 11,000 Financial Report March 2015. Exp -dk— Summary Page 17 of 25 Redevelopment Commission 5,687,190 1,490,033 8,224,418 - - - - - - - - - 15,401,642 76,872,581 20% City Operations Total 26,690,496 20,187,492 25,914,635 - - - - - - - - - 72,792,623 378,747,838 19% Expenditure report 26,690,496 20,187,492 25,914,635 0 0 0 0 0 0 0 0 0 72,792,623 378,747,838 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report March 2015. Exp -dk— Summary Page 17 of 25 City of South Bend Debt Schedule Period Ending: March 31, 2015 Year O/ I Y-1 I Year O/ 8obedgled Payments Debt[06R /Re1i) Debtat 2015Pdncipal - 151nfe 1 1015 Debtat 7-2-0-15-T.-M.11 Debt.. -nt Deb[PUmose Luw Refund- Matudh, Fantl 1s1 2nd 3rd /tls Issue 1T/3120f0 Payments Payment A2015n 12/31/1015 Debt Pavments CA41 City Debt Bond Debt of CEDIT Bona 1997 2006 201] 408 2/1 8/1 - - 11.810.000.00 2055,000.00 ]96000.00 86,100.00 0.00 1.265,000 .00 8]6,100.01 ss South Bond Building Corporation Public Works Builtlinq 2001 2010 2021 404/649 2J1 8/1 - - 9.250.000.00 3.860.000.00 545,000.00 129.]26.00 0.00 3,315.000.00 6]4,]26.00 zs Water Works lma„ements Water Works 2002 2012 2023 625 1/1 7/1 - - 5,975,000.00 3.100.000.00 355.000.00 62,000.00 0.00 2,]45.000.00 61],000.00 sa South Bend BUildlna Corporation Fire HO /Police HO 2003 2012 2023 404/324 2J1 8/1 - - 21.335,000.00 11.245.000.00 1,160.000.00 403.635.00 0.00 10,085.000.00 1,563,635.00 24 Water Works Improvements WalerWaks 2006 202] 625 7/1 7/1 - - 4,]10,000,00 3,300,000.00 210,000.00 146,]26.00 0.00 3.090,000.00 356.]26.00 4z Sewage Works Improvements Sswaw Works 2008 2026 649 6/1 1211 - - ].630,000.00 5.]40.000.00 365.000.00 255.491.26 0.00 5.3]5.000.00 620.491.2fi ao Sewage Works Improvements Sewage Works 200] 2027 649 6/1 1211 - - 16,600,000.00 12,320,000.00 ]20,000.00 535,94].50 0.00 11.600,000,00 1,255,94].50 sz Sewago Works Revenue Bond, 20078 Savo -Wake 200] 2027 649 fi/1 1211 - - 18.515.000.00 12.280.000.00 ]10.000.00 524,341.26 0.00 11.5]0.000.00 1.234.341.26 ez Canlury Cantor Special Tax Bonds Card - Center 2008 2028 420 5/1 1111 - - 4,655,000,00 3,]50,000.00 285,000.00 10],68].50 0.00 3465. 000.00 392,687.50 sa Water W."'Improvements Water Works 2009 2030 625 1/1 ]/1 - - 5.380,000.00 4,]]5.000.00 220.000.00 261.098.00 0.00 4.555.000.00 481,098.00 ro Sawsw Works Rave -Bonds -2009 Seesaw Works 2009 2028 649 6/1 1211 - - 3,29],000.00 2,561,38].00 153,]12.00 ]1,9]4.00 0.00 2,40],6]5,00 225,686.00 so 2010SmV da Works Revenue Bonds Sswaw Works 2010 2030 649 fi/1 1211 - - 9.345.000.00 ].905.000.00 375.000.00 325.26].50 0.00 ].530.000.00 ]00.26].50 es Sewage Works Revenue Bonds 2011 Seesaw Works 2011 2031 649 6/1 1211 - - 21,500,000.00 19,040,000.00 865.000.00 ]06,650,00 0.00 18.1]5,000.00 1,5]1,650.00 ea 2012 Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8.300,000.00 ].620.000.00 345.000.00 223.686.28 0.00 ],2]5.000.00 568,686.26 1012012 Seesaw Works Revenue Bonds Seesaw Works 2012 2032 649 6/1 1211 - - 25,000,000.00 22,965,000.00 1,030,000.00 528,180.00 0.00 21,935,000,00 1,558,180.00 os 2013A Seger Bond Refuntling Seesaw Works 2013 2013 2024 649 6/1 1211 - - 14.765.000.00 11.855.000.00 1.885.000.00 229.98].00 0.00 9.9]0.000.00 2.114.98].00 to 2013 Building Corporation EMS I Fire Department 2013 2033 288 2/1 8/1 - - 5,580,000.00 5,580,000.00 215,000.00 190,680.00 0.00 5.365,000 .00 405.680.00 as SL Joseph Count, PSAP St. Joseph Cony PSAP 2014 2034 408 Mwthly 2.65],696.50 2.657.69fi.50 123.3]].50 ]5.951.55 0.00 2.534.319.00 199.329.05 Total Bond Debt 194.364.696.W 142.609.083.50 10.352.089.50 4.865.128.83 0.00 132.256.994.00 15,217.218.33 Loans Pevable sa State Revolving Fond Water Works Improvement 2009 2030 625 1/1 7/1 - - 42].332.00 372.3fi4.00 19.5]1.00 12.548.68 0.00 352.]93.00 32.119.66 az Interfuntl Loan 410 -UDAG let SwrcelManiott Garage 2010 2015 470 6175 12/15 - - 2,]00,000.00 2,02],9]3.00 438.202.50 0.00 0,00 1.589,]]0.50 438.202.50 as State Revolving Food(Rdundinq) Sswaw Works Improvement 1998 2018 649 fi/1 1211 - - 24.095.000.00 0.00 0.00 0.00 0.00 0.00 0.00 zs State Revolving Fund Water Works Improvements 2000 2019 625 1/1 7/1 - - 2,600,000.00 860,913.00 162,482.00 24,966.00 0.00 698,431.00 187,448.00 Total Loans Payable 29,822332.00 3.261,250.00 620,255.50 37,514.66 0.00 2.640,994.50 657,770.16 Capital Leases 11 Chase LED Equipment 2007 201] 701 1/1 7/1 1,531,5]3.00 559,122.04 178,539.39 22,040.2] 0.00 380,582.65 200.5]9.66 zz Kansas State Bank Cotle EMOrcement Om Copier 2010 2015 101 1/23 4123 7123 10/23 9.209.00 539.14 539.14 10.50 0.00 0.00 549.64 re Kansas State Bank Cando, Services Copier 2010 2015 222 2176 5176 8176 11/16 13.366.40 1,496.90 1.486.90 33,10 0.00 0.00 1,530.00 n GE Capital Information Technology Animal Control Copier 2010 2015 101 D28 5130 8130 11/30 3.550.69 403.62 403.62 4.04 0.00 0.00 40].68 ra Kansas State Bank Mawr Coe Copier 2010 2015 101 1/8 4/8 7/8 10/8 9,209.00 1,586.72 1,586.]2 62.20 0.00 0.00 1,648,92 zs Adwancetl Imzaing Central Services Duplicators 2010 2015 222 1/15 4115 7115 10/15 10.511.02 2.455.]] 2.455.]] 139.59 0.00 0.00 2.595.38 ar Public Fina m-nn Inc Solt Waste Contair- ITrucks 2011 2015 677 6/75 12/15 321,853.00 6],665.30 6],665.30 1,599.]0 0.00 0.00 69.265.00 as Sun Trust Police. PaMS. Bldg vehicles 2011 2016 404/201/800 3115 BI15 9115 12/15 2.068,202.00 641.545.46 425.630.31 9.335.10 0.00 215,915.15 434,985.41 so Capital One Public Pon in. Solid Waste Contair- ITrucks 2011 2016 611 3115 6HS 9/15 12/15 20],432.00 ]4,504.09 42,308.31 977.25 0.00 32,195.]8 43,285.56 a1 GE Capital Information Technolwv Police Dept COpia 2011 2018 101 1111 4111 7111 10111 3.836.00 1,2]5.18 837.22 51.50 0.00 43].96 888.72 az Kav Finanw IT Phone System 2011 2016 404 1115 1,444,995.97 569,323.31 281,141.18 14,258.23 0.00 288,182.13 295,399.41 W Ikon Office Soot- Mawr Ricoh MP 2851 SP Copse 2011 2016 101 D15 5115 8115 11/15 2.569.53 1,110.31 539.50 48.98 0.00 570.81 588.48 s5 Sun Trust Equipment Finanw Park. df Cars Lease 2012 2016 201 4115 10/15 - - 344.500.00 131,862.30 8],556.51 1,765.9] 0.00 44,305.]9 89,322.48 az Sun Trust Equipment Finance Police Vehicles BEmio -W 2012 201] 406 5/15 11/15 - - 1.295.000.00 881.]12.34 281.339.69 10.111.59 0.00 400.3]2.85 2]1.451.28 as PNC Equipment Finanw Public Works Vehicles Lease 2012 201] 2021641/640 5175 11/15 - - 945.6]4.38 481,77].95 190.523.74 6,535.]1 0.00 291,194.61 197,058.85 m PNC Ewipment Finance Public Works Vehicles Lease 2012 201] 2021641/800288 1/15 ]115 - - 2,806.054.00 1.]03.]48.90 560,548.08 20.403.26 0.00 1.143.200.82 580.951.34 oz Ikon Office Solutions l Ricoh Wastewater Copier 2012 201] 641 Monthly let 5.]44.85 3,770.10 1,172.61 149.31 0.00 1,99].49 1,321.92 as GECapitallnfama,n Technolwv Fire Dooaronent Copier 2012 2017 101 2128 5128 8128 11128 5,4]1.01 3.205.85 1.108.31 184.49 0.00 2.099.54 1.2]0.80 ce Ricoh USA (New) Central Services Copier 2013 2018 222 212] 5127 8127 112] 3.622.78 2,315.31 728.85 110.91 0.00 1,586.46 839,76 w Ricoh USA SbeeVSewer Dept Copier 2013 2018 202/861 3/d 6/4 9/4 1216 5.559.15 3.4]5.34 1.092.25 1]B.SS 0.00 2,383.09 1.2]0.80 oa Ricoh USA City Attomev Copier 2013 2018 101 2112 5112 8/12 11112 5.559.15 3,492.63 1,097.31 1]3.49 0.00 2,395.32 1,270.80 os Ricoh USA Parks 8 Rac Ricoh C,niers(3) 2013 2018 201 D21 5121 8121 1121 16.129.94 10.132.91 3.184.26 502.98 0.00 6,968.65 3.687.26 10 PNC Equipment Finance Vahi la/Edi want Lease 2013 2018 1011202/406/641 1115 7/15 1,689,669.59 1.361,951 .2] 334.301.24 15,599.28 0.00 1,02],650.03 349.900.52 11 Ricoh USA Enginwdng Pld[erlSCanner 2013 2018 101 3/3 6/3 9/3 1213 10.66].6] 6.]90.21 2.0]3.34 518.66 0.00 4,]16.8] 2.592.00 1z Ricoh USA Builtlinq Ded. Copier 2013 2018 600 Monthly 4.093.64 3,109.92 ]86.]6 152,24 0.00 2,323.16 939.00 1s Sun Trust Equipment Finance Police and PW vehicles 2013 2018 404/655/811202 4/24 1024 1,506,465.26 1.214.609.68 296.499.82 18,081.32 0.00 918.109.86 316.581.14 fa Ricoh USA Atlmin B Finance Copier 2013 2018 101 1116 4116 ]116 10/16 11.24].9] ],565.05 2.1]8.10 393.14 0.00 5,386.95 2,5]1.24 1z Police Dept Record Div. Ricoh Police Rewrtls Copier 2013 2018 101 Mwthly 3rd 9.8]8.28 ].950.10 1.828.18 393.82 0.00 8.123.92 2.220.00 fa Wator Works Main Riwh Copier Water Works Main Ricoh Copier 2013 2018 520 Mgnlhly 10th 5.64].50 4,639.36 1.065.38 230.08 0.00 3,5]3.98 1,285.46 1a Water Works COffax Ricoh Copier WaterWaks Colfax Ricoh Cwll 2013 2018 620 Mwthly 16th 6,]32.65 3.88].84 892.]] 192.]5 0.00 2.995.0] 1.085.52 za Watw Works Olive Riceh Copier Water Works Olive Ricoh Copies 2013 2018 620 M,Mhly 10th 4.]32.65 3,887.84 892.]] 192.]5 0.00 2,995.0] 1,085.52 zs Police Traininq Dent. Ricoh Copier Training Coder 2014 2019 101 Mwthly 30th 6.263.00 3,]14.38 ]96.08 18].92 0.00 2.918.30 984.00 z4 Poti. /PUblio Works Vehicle Lease 2014 City Vehicles 2014 2019 Various 4/1 10/1 1,959485.95 1.959,485.95 3]9,888.68 28,90],8] 0.00 1.5]9,59 ].2] 408,796.55 zs HP Computer Lsase#1 Computer Equipment Lease 2014 2018 Mwthly 8th 13].104.95 124.554.02 29.828.93 4.995.44 0.00 94.]25.09 34.824.37 26 HP Computer Lease #2 Computer Equipment Lsase 2014 2018 201 and 620 M-:h" 8th 4.000.00 3,720.95 866.48 154.00 0.00 2,854.4] 1,020.48 zz HP Computer Laase#d Computer Equipment Lease 2014 2018 404 M-thly 8th 5.886.15 5,461.99 1.30].5] 188.4] 0.00 4.156.42 1.496.06 za HP Computer Lease #6 Computer Equipment Lease 2014 2018 201 Monthly 8th 3.]55.50 3,561.10 801.62 155.50 0.00 2,]59.48 957.12 za HP Computer Lease #7 Computer Equipment Lease 2014 2018 620 M-thly 8th 1.328.00 1.256.1] 294.22 62.62 0.00 959.95 336.86 no Solid Wade Copier Ricoh USA Copier 2014 2019 611 Monthly 17th 5.351.65 5,351.65 1.035.84 296.2] 0.00 4,315.81 1,332.11 s1 Police C- onicatiws Copier Ricoh USA Copier 2014 2019 101 Monthly 12th 8.843.00 8.196.88 1.613.55 618.29 0.00 6.583.31 2.031.86 sz Organic Resources B Wastewater Ricoh USA Copiers 2014 2019 641 Monthly 21st 12.260.18 11,182.59 2,24].61 569.39 0.00 8.934.98 2.817.00 as Water Works Coder - North Stator Rich, USA Cwiors 2014 2019 620 Monthly 19th 6,]32.65 3.960.04 888.6] 198.86 0.00 3.0]1.3] 1.085.51 Total Capital Lease 16,453,567.19 9,670,696.41 3,171,577.98 160,523.37 0.00 6,499,118.46 3,332,101.35 rnranne aepwt.uemn zol5 -oeel City of South Bend Debt Schedule Period Ending: March 31, 2015 Yearol I Yeaf I I Yearol Bobedpled Pavments -It [Odo /Re1i) Debtat 2015Pdnoioal - 151nfe 1 1015 Debtat 2015 Total Debt lnsWment Deb[PUmose Issw Rafuntling MatudN Funtl 1s1 Intl 3rd /M Issue 1T/31/. Pavments Payment Atltlltlon 12/31/1015 Debt Pavments Red -lonm t Commission Debt Bontl Debt I Cent - Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1 - - 6.825.000.00 1.630.000.00 450.000.00 37.500.00 0.00 1.180.000.00 487.500.00 a Collew Football Hall of Fama Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 16,3]0,000.00 4,160,000.00 1,150,000.00 116,820.00 0.00 3.010,000.00 1,266,820.00 rt South Bend Building Corporation Mans PAC 1998 2009 201] 408 Z1 8/1 - - 13.300000.00 2.480.000.00 950.000.00 8].212.50 0.00 1.510.000.00 1.03].212.50 1z TJX Special Tavnq District 2002 2014 2022 3241404/414 1/1 ]/1 - - 6,620,000.00 3,010,000.00 395,000.00 86,350.00 0.00 2.616,000.00 481,360.00 s Downtown Cenral Area TIF 2003 2011 2024 420 y1 8/1 - - 19.795.000.00 14.965.000.00 1.205.000.00 ]09.525.00 0.00 13.]80.000.00 1.914.525.00 e.- Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14,420,000.00 8,536,000.00 690,000.00 404,611.60 0.00 7 .846,000.00 1,094,611.50 zz Erskine Villme TIF Development Bond Erskine Village 2005 2027 432 vi 8/1 - - 5.485.000.00 000 4.255.000.00 220.000.00 268.380.00 0.00 4.035.000.00 488.380.00 sa Lease Rental Revenue Bonds of 2008 Eddv Slmet Commons 2008 202] 429 2115 8115 - - 36,000,000.00 33,020. 1,075,000.00 1,853.268 00 0.00 31.946 ,000.00 2,928,268.00 at Coveleski Stadium Recovery CovelesM Stadium 2010 2019 3]] 1115 ]115 - - 4.980.000.00 2.915.000.00 620.000.00 134.802.50 0.00 2.295.000.00 ]54.802.50 oe 2012 Gates Downtown Campus VA Clinic Agml Loan 2012 2015 420 3/1 8/1 1,]00,000.00 666,666.68 566,666.68 0.00 0.00 0.00 566.666.68 zr Blackthorn Gdf Cart Lease Blackthorn GoI1 2014 2019 619 MCnthly 14th 293.]88.00 25].236.64 25].238.04 4.688.91 0.00 0.00 261.926.95 zz SMagoque at C -leski Improvements Coveleski Stadium 2014 2018 3n 1131 500,000.00 400,l)l)l) 100.000.00 0.00 0.00 300,000.00 100,000.00 as 2015 Redevd= -Smart Streets Smarts Streets 2015 2037 324 211 811 25.000000.00 0.00 0.00 0.00 25.000.000.00 25.000.000.00 0.00 Total Bontl Debt 0 153.]88.]88.00 76.173.904.72 7.678.904.72 3.703.158.41 25.000.000.00 93.495.000.00 11.382.063.13 Loans Pavable a Indian a Development Finance AUthaity Bosch P,o v(NOnfogw) 2001 2021 210 3122 6122 9122 1222 1.040.000.00 423.820.93 59.966.23 12.044.21 0.00 363.854.]0 ]2.010.44 4 Indiana Dev -ent Finance AuthMty Bosch Prowrtv(FOmive) 2001 2021 270 - - 260,000.00 11],730.26 0.00 0.00 0.00 100,55].56 0.00 1 HUD SeCticn 108#8 Studebaker Oliver 2008 2025 434 vi 8/1 - - 4.000.000.00 180.000.00 180.000.00 ].]94.00 0.00 0.00 18].]94.00 a1 City of Mishawaka Douglas Road TIF 2009 2029 435 2175 8115 - - 1,102,549.56 47,003.09 4].003.09 1,1]5.08 0.00 0.00 48.1]8.7] sa Intertund FUnd 412 - Major MOVes Douglas Road TIF 2009 2029 435 2115 8115 1.040.319.00 886.6]].00 251.15].00 41.852.00 0.00 835.520.00 293.009.00 as Intertund FUnd 619- Blackthorn BlWMhom Equip(goH Carts) 2010 2017 619 5115 6115 7115 8115 31,0320 11,63].00 3.8]9.00 0.00 0.00 ],]58.00 3,8]9.00 ea Intertund FUnd 412 -Maio, M- Triangle D..I.menl 2011 2029 436 D15 8115 - - 2.000.000.00 1.513.259.50 90.929.20 29.812.80 0.00 1.422.330.30 120.742.00 aS lntedund FUnd 412 -Major MOVes EtlM Street Commons 2011 2026 436 2115 8115 - - 4,700,000.00 3.22],558.81 213.696.29 158,]39.]1 0.00 3.013,862.52 3]2.436.00 as Inertund Fund 209 to Airport 324 P.H. Ave 13 -fidd Project 2011 2020 324 B/9 500.000.00 500.000.00 0 :0 0.00 0.00 500.000.00 0.00 as Blackthorn Loan fmm Ai,.d Blackthorn Equip (mowers) 2011 2018 619 5115 6115 7115 8115 53,598.50 30,149.06 6,699.84 0.00 0.00 23,449.22 6,699.84 Total Loans Pavable 14,127,499.06 6,937,235.65 853,330.65 251,417.80 0.00 6,067,332.30 1,104.748.45 Capital Lease total C-tal Lease A o.00 0.00 0.00 0.00 0.00 0.00 0.00 Leases az Tra -Lease Leighton Plaza Garage 2001 2015 404 6130 12/30 - - 3.000.000.00 191.34].00 191.347.00 8.653.00 0.00 0.00 200.000.00 to T111 -Lease Main l Colfax Garage 2006 2025 404 3115 9115 - - 2,510,2]8.00 1,676,543.00 11],625.00 82,3]5.00 0.00 1.558,978.00 200,000.00 Total Lease 5,510,278.00 1,86],690.00 308.9]2.00 91,028.00 0.00 1.558,878.00 400.000.00 Total Redevelopment Commission 173,426,565.06 84,9]9 :30.3] 8,841,20].3] 4,045,604.21 25,000,000:0 101.121,250.30 12,886.811.58 rn'anne aepwt.ueRn zolS -Deal City of South Bend Period Ending: March 31, 2015 Monthly Debt Schedule Year O/ Vearol Year O/ 5cbetivled Payments DebtlOrrll -i) Debt at YTD Principal YT. Interest YTD Debt at Debt.. -nt Deal Pura... .- Refunding Maturity Funtl 1s1 2ntl 3b 1. Issue 12/31/2010 Payments Payments AtltlL. 3/31/2015 Wall Citv Debt Bond Debt of CEDIT Bond 1997 2006 201] 408 2/1 8/1 - - 11.870.000.00 2055.000.00 200.000.00 21.200.00 0.00 1.855.000.00 ss South Bond Building Corooration Public Works Builtlinq 2001 2010 2021 404/649 2/1 8/1 - - 9.250.000.00 3.860.000.00 2]0,000.00 66.888.00 0.00 3,590.000.00 zs Water Works lma „emends Water Works 2002 2012 2023 625 7/1 12131 - - 5.975.000.00 3.100.000.00 0.00 0.00 0.00 3.100.000.00 sa South Bend Building Corporation Fire Hp /Police Hp 2003 2012 2023 404/324 2/1 8/1 - - 21.335.000.00 11.245.000.00 5]5.000.00 206.130.00 0.00 10,6]0.000.00 24 Water Works Improvements Water Works 2006 2027 625 7/1 12131 - - 4,110,000.00 3,300,000.00 0.00 0.00 0.00 3.300,000.00 4z Sewage Works Improvements Sewage Works 2006 2026 649 6/1 1211 - - ].630.000.00 5.]40.000.00 0.00 0.00 0.00 5.]40.000.00 4o Sewage works Improvements Sewage Works 200] 2027 649 6/1 12n - - 16,600,000.00 12,320,000.00 0.00 0.00 0.00 12.320,000.00 sz Sewage Works Revenue Bond, 2007B Savo- Wake 200] 202] 649 6/1 1211 - - 18.515.000.00 12.280.000.00 0.00 0.00 0.00 12.280.000.00 ez Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11n - - 4,655,000W 3,]50,000.00 0.00 0,00 0.00 3.750,000.00 sa Water Works Improvements Water Wake 2009 2030 625 ]/1 12131 - - 5.380.000.00 4,]]5.000.00 0.00 0.00 0.00 4.]]5.000.00 ro Sawsw Works Rave -Bonds -2009 Sewage Works 2009 2028 649 6/1 1211 - - 3,297,000.00 2,561,38].00 0.00 0.00 0.00 2,561,38],00 so 2010Sewage Works Revenue Bonds Savo. Wake 2010 2030 649 6/1 1211 - - 9.345.000.00 ].905.000.00 0.00 0.00 0.00 ].905.000.00 es Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 1211 - - 21,500,000.00 19,040,000.00 0.00 0.00 0.00 19.040,000.00 ea 2012 Water Works Revenue Bond Water Wake 2012 2033 625 1/1 111 - - 8.300.000.00 ].620.000.00 345.000.00 115.243.13 0.00 ].2]5.000.00 tot 2012 Sewage Works Revenue Bonds Sewage Works 2012 2032 649 6/1 1211 - - 25,000,000.00 22,965,000.00 0.00 0.00 0.00 22.965,000.00 os 2013. Seger Bontl Refuntling Sewage Works 2013 2013 2024 649 6/1 1211 - - 14.]65.000.00 11.855.000.00 0.00 0.00 0.00 11.855.000.00 to 2013 Building Corooration EMS I Fire Dewrlment 2013 2033 288 2/1 8/1 - - 5,580,000.00 5,580,000.00 215,000.00 96,952,50 0.00 5.365,000.00 as SL Joseph Count, PSAP St. Joseph County PSAP 2014 2034 408 Manihly 2.65].696.50 2.65].696.50 30,844.38 18.98].90 0.00 2.626.852.12 Total Bond Debt 194.364.696.50 142.609.083.50 1.635.844.38 525.401.53 0.00 140.973.239.12 Loans Pevable sa State Revolving Fond Water Wake Improvement 2009 2030 625 7/1 12131 - - 42].332.00 372.364.00 0.00 0.00 0.00 3]2.364.00 az Interfuntl Loan 410 -UDAG let SOUrcelManiott Garage 2010 2015 410 6115 12/15 - - 2,]00,000.00 2,02],9]3.00 0.00 0,00 0.00 2,02],9]3.00 44 State Revolving Fund (sch# 105) Sewage Works Improvement 1998 2018 649 6/1 1211 - - 24.095.000.00 0.00 0.00 0.00 0.00 0.00 zs State Revolving Fund Water Works Improvements 2000 2019 625 7/1 12131 - - 2,600,000.00 860,913.00 0.00 0,00 0.00 860,913.00 Total Loans Payable 29,822332.00 3.261,250.00 0.00 0.00 0.00 3,261,250.00 Capital Leases 11 Chase LED Equipment 2007 201] 701 1/1 1/1 1,531,5]3.00 559,122.04 88,324.62 11,965.21 0.00 4]0,]9].42 zz Kansas State Bank Cotle EMOroement 0.. Gooier 2010 2015 101 1/23 4123 7123 10/23 9.209.00 539.14 539.14 10.50 0.00 0.00 rs Kansas State Bank Cando, Services Copier 2010 2015 222 2116 5116 8116 11/16 13,366.40 1,496.90 742.99 2201 . 0.00 ]53.91 n GE Capital Information Twhnolwv Animal Control Cooler 2010 2015 101 2128 5130 8130 11/30 3.550.69 403.82 199.]] 4.08 0.00 203.85 ra Kansas State Bank Mawr Coe Copier 2010 2015 707 1/8 4/8 7/8 1018 9,209.00 1,586.72 518.]4 30.80 0.00 1,06].98 zs Advancetl Imming Central Services Duplicators 2010 2015 222 1115 4115 ]115 10/15 10.511.02 2.455.]] 593.13 55.]1 0.00 1.882.134 ar Public Fir-nn Inc Sditl Waste Contar- ITrecks 2011 2015 617 6115 12/15 321,853.00 6],665.30 0.00 0.00 0.00 6],665.30 ea Sun Trust Police. P.ft.Blcovehicle, 2011 2016 404/201/1300 3115 8115 9115 12/15 2.068.202.00 641.545.46 105.638.79 3.102.56 0.00 535.908.8] so Capital One Public Pon in. Solid Waste Contair- ITmcks 2011 2016 611 3115 6n5 9n5 12/15 20],432.00 ]4,504.09 10,511.2] 310.12 0.00 63,992.82 a1 GE DdPhal lnfama,n Technolwv Police Oad Copier 2011 20113 101 1111 4111 7111 10111 3.836.00 1.2]5.18 204.82 1].38 0.00 1.0]0.36 az Kev Finance IT Phone Swtam 2011 2016 404 1115 1,444,995.9] 569,323.31 281,141.18 14,258.23 0.00 288,182.13 W Ikon Office SduBOns Mawr Ricoh MP 2851 SP Cooie 2011 2016 101 2115 5115 8115 11/15 2.569.53 1.110.31 132.03 15.09 0.00 9]8.28 a5 Sun Trust Equipment Finance Park. df Cars Lease 2012 2016 201 4115 10/15 - - 344.500.00 131,862.30 0.00 0.00 0.00 131,862.30 az Sun Trust Eguioment Finance Police Vehicles BEmioment 2012 2017 406 5/15 11/15 - - 1.295.000.00 881.]12.34 0.00 0.00 0.00 661.]12.34 se PNC Equipment Finance Public Works Vehicles Lease 2012 201] 2021641/640 5115 11/15 - - 945.674.38 481,]1].95 0.00 0.00 0.00 481,]1].95 m PNC Equipment Finance Public Works Vehicles Lease 2012 201] 2021641/800288 1/15 ]115 - - 2.806.054.00 1.]03.]48.90 2]9.362.9] 11.112.]0 0.00 1.424.385.93 oz Ikon Office Solutions l Ricoh Wastewater Copier 2012 201] 641 Monthly let 5.]44.85 3,7]0.10 286.98 43.50 0.00 2,883.12 as GE Capital lnfama,n Technolwv Fire Deoaronent Copier 2012 2017 101 2128 5128 8128 11128 5,4]1.01 3.205.85 2]0.55 4].15 0.00 2.935.30 ce Riwh USA Central Services Copier 2013 2018 222 212] 5127 8127 112] 3.622.78 2,315.31 188.32 21.62 0.00 2,126.99 w Rich USA SbaeVSewer Dept Copier 2013 2018 202/661 3/4 6/4 9/4 1216 5.559.15 3.4]5.36 267.18 50.52 0.00 3.208.18 oa Riwh USA City Atlomev Copier 2013 2018 101 2112 5112 8112 11112 5.559.15 3,492.63 283.90 33.80 0.00 3,208.]3 ,e Ricoh USA Parks 8 Roc Ricoh C,oiers(37 2013 2018 201 2121 5121 8121 1121 16.129.94 10.132.91 823.82 9].99 0.00 9.309.09 fo PNC Equipment Finance Vahicla/Edi want Lease 2013 2018 1011202/406/641 1115 7115 1,689,669.59 1.361,951.2] 166,642.36 8,30].90 0.00 1,195,308.91 11 Ricoh USA Enginaedng Pld[erlSCanner 2013 2018 101 3/3 6/3 9/3 1213 10.66].6] 6.]90.21 501.90 148.10 0.00 6.288.31 1z Moat USA Builtlinq Ded. Copier 2013 2018 600 Monthly 4.093.64 3,109.92 192.64 42.11 0.00 2,91].28 1s Sun Trust Eguioment Finance Police and PW vehicles 2013 2018 406/855/811202 4/24 1024 1.SO6.d85.28 1.214.809.88 0.00 0.00 0.00 1.214.609.88 14 Ricoh USA AEmin B Finance Copier 2013 2018 101 1116 4116 ]116 10/16 11.24].9] ],565.05 532.]9 110.02 0.00 ],032.26 1z Police Not. Record Div. Ricoh Police R-- Gooier 2013 2018 101 M,nihly 3hJ 9.8]8.28 ].950.10 44].14 10].86 0.00 ].502.96 fa Water Works Main Riceh Copier Water Works Main Ricoh Copier 2013 2018 620 Manlhly 10th 5.64].50 4,639.36 260.85 63.00 0.00 4,3]8,51 1a Water Works COffax Ricoh Cooler Waterworks Colfax Ricoh C,oi1 2013 2018 620 .-lhIV 16th 4,]32.65 3.881.86 218.59 52.]9 0.00 3.1313 H za Water Works Olive Riceh Copier Water Works Olive Ricoh Copies 2013 2018 620 Monthly 10th 4.]32.65 3,881.84 218.59 52.]9 0.00 3,669.25 zs Police Training Dent. Ricoh Gooier Train no Coda 2014 2019 101 Monthly 30th 6.283.00 3.]16.38 194.8] 51.13 0.00 3.519.51 z4 Kev Government Finance 2014 City Vehicles 2014 2019 411 1011 1,959485.95 1.959,485.95 0.00 0.00 0.00 1,959,485.95 z6 HP Computer Lsase#1 Computer Eguioment Lease 2014 2018 M,nthiv 8th 13].104.95 124.554.02 ].332.09 1.3]4.00 0.00 11].221.93 zs HP Computer Leese #2 Computer Equipment Lees. 2014 2018 201 and 620 Monthly 8th 4.000.00 3,]20.95 212.88 42.24 0.00 3,508.0] zz HP Compute Laase#d Computer Eguioment Lease 2014 2018 604 M,nthiv 8th 5.886.15 5.461.99 322.1] 51.84 0.00 5.139.82 za HP Computer Leese #6 Computer Equipment Lease 2014 2018 201 Monthly 8th 3.755.50 3,561.10 196.78 42.50 0.00 3,364.32 za HP Computer Lease #7 Compute Eguioment Lease 2014 2018 620 Mordhly 8th 1.326.00 1.254.1] ]2.51 11.]0 0.00 1.181.88 as Solid Waste Copier Ricoh USA Copier 2014 2019 611 Monthly 17th 5.351.65 5,351.65 312.06 91.82 0.00 5,039.59 s1 Police C- onicati ,Cooie, Ricoh USA Gooier 2014 2019 101 Monthly 12th 8.843.00 8.196.88 394.9] 112.99 0.00 ].801.89 az Organic Resources B Wastewater Ricoh USA Copiers 2014 2019 641 Monthly 21st 12.260.18 11.182.59 550.18 164.0] 0.00 10.632.41 a4 Water Works Coder - North Station Rich, USA Cwiem 2014 2019 620 Monthly 19th 4,732.65 3.960.06 217.59 53.79 0.00 3.742.15 Total Caphal Lease 16.453.567.19 9.670.696.1 968.851.16 52.0]3.]0 0.00 8.721.845.28 Total CMI Cltv 240.610.595.69 155.541.029.96 2.580.695.54 5]].475.23 0.00 152.956336.40 rmaene aawt germ zols -Dees City of South Bend Period Ending: March 31, 2015 Monthly Debt Schedule Y@ar O/ Veat Ol Year O/ Scheduled PaVmenfs Debt[06, /Re1i) Debt at YTD Principal YTO Interest YTD Debt dt Debt.. -nt Deb[PD.- Issw Refunding Mat Z' Funtl 1s1 2nd 3n1 4th Issue 12/31/2010 Payments Payments MdZns 3/31/2015 Red -lot, enl Commission Debt Bond Debt I CeIt- Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 B/1 - - 6.825.000.00 1.630.000.00 225,000.00 19.8]5.00 0.00 1,405.000.00 a Collew Football Hall of Forma Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15,3]0,000.00 4,160,000.00 5]0.000.00 61,]58.]5 0.00 3.590,000.00 rt South Bend Building Corporation Mans PAC 1998 2009 201] 408 vi 8/1 - - 13.300000 .00 2.480.000.00 4]0.000.00 48.012.50 0.00 1,990.000.00 tz TJX Special Tavnq District 2002 2014 2022 3241404/414 1/1 7/1 - - 6,620,000.00 3,010,000.00 0.00 0.00 0.00 3,010,000.00 s Downtown Cenral Area TIF 2003 2011 2024 420 y1 8/1 - - 19.]95.000.00 14,965.000.00 595.000.00 361.248.00 0.00 14.3]0.000.00 6.- Development Area TIF Airport TIF 2003 2011 2024 324 2/1 8/1 - - 14,420,000.00 8,535,000.00 340,000.00 206,011.75 0.00 8,195,000,00 zz Erskine Villme TIF Development Bond Erskine Village 2005 2027 432 vi 8/1 - - 5.485.000.00 4.255.000.00 220.000.00 13].545.00 0.00 4.035.000.00 sa Lease Rental Revenue Bonds of 2008 Eddv Street Commons 2008 202] 429 2115 8115 - - 36,000,000.00 33,020,000.00 530,000.00 931,934.00 0.00 32,490,000.00 at Coveleski Stadium Recovery Coveleski Statlium 2010 2019 3]] 1/15 ]/15 - - 4.980.000.00 2.915.000.00 310.000.00 ]0.]]2.50 0.00 2.805.000.00 of 2012 Gates Downtown Campus VA Clinic Agml Loan 2012 2015 420/324 311 811 - - 1,]00,000.00 566,666.68 283,333.33 0.00 0.00 283,333.35 zr Blackthorn Gdf Cart Lease Blackthorn Golf 2014 2019 619 Monthly 14th 293,]88.00 25].238.04 25].238.04 535.91 0.00 0.00 zz Svnaggque at COVeleski Improvements Coveleski Stadium 2014 2018 3n 1131 500,000.00 400,000.00 100.000.00 0.00 0.00 300,000.00 as 2015 Redevelopment Smart Streak Smart Streets 2015 203] 324 2/1 8/1 25.000 000.00 0.00 0.00 0.00 25.000.000.00 25.000.000.00 Total Bond Debt 0 153.]88.]88.00 76.173.90412 3.900.5]1.3] 1.837.693.41 25.000.000.00 9].2]3.333.35 Loans Payable a Indiana Development Finance AUthaity Bosch Prcpntv(NOnfcgw) 2001 2021 210 3/22 6/22 9122 12/22 1.040.000.00 423.820.93 14.823.95 3.1]8.66 0.00 408.996.98 4 Indiana Dev -ent Finance Authonty Bosch Pro- tv(Forgivel 2001 2021 270 - - 260,000.00 11],130.26 0.00 0.00 0.00 11],130.26 I HUD Section 108#8 Studebaker Gliver 2008 2025 434 vi 8/1 - - 4.000.000.00 180.000.00 0.00 3.89].00 0.00 180.000.00 a1 City of Mishawaka Douglas Road TIF 2009 2029 435 2115 8/15 - - 1,702,549.56 47,003.09 4].003.09 1,1]5.08 0.00 0.00 sa Inledund FUnd412 -Maio, MOVes Douglas Road TIF 2009 2029 435 2115 8115 1.040319.00 886.6]].00 99,2]5.00 22.16].00 o.00 ]8].402.00 as Interfund FUnd 619- Blackthorn Blackthorn Equip (golf carts) 2010 2017 619 5115 6 /15 1/15 8/15 31,032.00 11,63].00 0.00 0.00 0.00 11,63],00 ea Inledund FUnd 412 -Maio, MOVes Tdanole D..I.menl 2011 2029 436 D15 8115 - - 2.000.000.00 1,513.259.50 45.238.41 15.132.60 0.00 1.468.021.09 aS lntedund FUnd 412 -Maio, MOVea Eddv Street Commons 2011 2026 436 2115 8115 - - 4,100,000.00 3,22],558.81 105,529.03 80,688.9] 0.00 3,122,029.]8 as Imedund Fund 209 to Airport 324 P.H. Ave 13 -nfidd Protect 2011 2020 324 B/9 500.000.00 500.000.00 0.00 0.00 0.00 500.000.00 as Blackthorn Loan fmm Ai,.d Blackthorn Equip(mowersl 2011 2018 678 5115 6n5 ]115 8115 53.698.50 30,748.06 O.OD Dee 0.00 30,149.06 Total Loans Payable 14,127,499.06 6,937,235.65 311,869.48 126,239.31 0.00 6,626,366.17 Capital Lease total C-tal Lease A o.00 0.00 0.00 DAD O.00 DAD Leases a, Tr a- Lease Leighton Plaza Garage 2001 2015 404 6130 12/30 - - 3.000.000.00 191.34].00 0.00 DAD 0.00 191.34].00 to Tn. -Lease Main l Colfax Garage 2006 2026 404 3115 9115 - - 2,510,2]8.00 1,676,543.00 1 58,086.00 41,914,00 0.00 1,618,45].00 Total Lease 6,510,278.00 1,867,890.00 58.086.00 41,914.00 O.OD 1.809,804 .00 Ttal Redewl,- tCommission 1]3,426,565.06 84,9]9,030.3] 1 4,270,626.85 1 2,006,84872 26,000,000.00 1 105,708,503.52 rn'anne aepwt germ zol5 -oeel City of South Bend Staffing Headcount Summary Budget I I I I I I Full Time Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Full Time Staff 1094.00 1084.00 1076.00 1077.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Part Time Staff 68.00 70.00 90.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Temporary /Seasonal 111.00 109.00 113.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 1263.00 1255.00 1280.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report March 2015 - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Financial Report March 2015 - Headcount Staffing Page 23 of 25 Amended Budget FT Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 7.00 7.00 7.00 7.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 311 Call Center 7.00 7.00 7.00 7.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 21.00 21.00 21.00 21.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Innovation / Technology Office 4.00 2.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Safety & Risk 3.00 3.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Clerk 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Common Council 9.00 9.00 9.00 9.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Le al De artment 11.00 10.00 11.00 11.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 67.00 64.00 65.00 65.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enf. /Animal Control 24.00 23.00 23.00 22.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 25.00 23.00 23.00 24.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Administration 10.00 10.00 10.00 10.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 44.00 44.00 44.00 44.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Golf Operations 8.00 8.00 8.00 8.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 26.00 24.00 24.00 24.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Zoological Ops 1.00 1.00 1.00 1.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Non-reverting 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 91.00 89.00 89.00 89.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Safety Police 306.00 302.00 302.00 304.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Communications 0.00 7.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 * see narrative Fire 258.00 258.00 258.00 260.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 564.00 567.00 560.00 564.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Public Works Central Services 37.00 34.00 34.00 33.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Office of Sustainability 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 16.00 15.00 15.00 15.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Solid Waste Operations 21.00 20.00 21.00 21.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Clean Crew 4.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Street Operations 56.00 56.00 56.00 55.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sewer Operations 33.00 33.00 30.00 30.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 44.00 44.00 44.00 43.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Organic Resources 6.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Utilit O s 68.00 68.00 68.00 68.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 290.00 285.00 283.00 280.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Building Department 13.00 13.00 13.00 13.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Human Rights 6.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Morris & Palais 14.00 14.00 14.00 14.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 1094.00 1084.00 1076.00 1077.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report March 2015 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Dept. of Community Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Administration Jan I Feb I Mar I Apr I May Jun Jul Aug Sep Oct I Nov I Dec General Government 3.00 3.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Mayor 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 311 Call Center 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.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 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 Le al De artment 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enf. /Animal Control 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Administration 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Golf Operations 0.00 1.00 20.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 31.00 32.00 32.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Zoological 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 Graffiti Removal 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 39.00 41.00 62.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Communications Fire Sub Total 5.00 5.00 5.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Traffic & Lighting 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 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 Solid Waste Ops 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Street Ops 4.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.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 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 Water Utility s 3.00 3.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 11.00 11.00 10.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Building Department 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Human Rights 2.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Morris & Palais 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 68.00 70.00 90.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report March 2015 - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Temporary, Seasonal, and Intern Staff General Government Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec Mayor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Admin & Finance 4.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.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 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 Mal0.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 4.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enforcement 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dept, of Community Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Parks & Recreation Public Safety Public Works Building Department Human Rights Morris & Palais Administration 5.00 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 11.00 10.00 9.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Golf Operations 2.00 3.00 10.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Ops 46.00 47.00 38.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Zoological 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 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 Sub Total 64.00 65.00 62.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 27.00 27.00 27.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Communications 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fire 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 27.00 27.00 27.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Central Services 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 4.00 4.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Energy /Sustainability 4.00 4.00 4.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Traffic & Lighting 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 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 Solid Waste Ops 3.00 3.00 9.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Street Ops 1.00 4.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sewer Ops 2.00 0.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leaf Pickup 1.00 0.00 1.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 Organic Resources 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water Utility s 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 16.00 16.00 23.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 City Total 111.00 109.00 113.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report March 2015 - Headcount Staffing Page 25 of 25