Loading...
HomeMy WebLinkAbout02-2015 Financial ReportPeriod Ending: February 28, 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 February 2015 Page 1 of 25 February 28, 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 11 %. The overall percentage of collected revenue amount for February 2014 was 10 %. 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 342 (EMS Capital Fund), received $396,727 for fire equipment reimbursed by FEMA. Revenue by fund As of February 28, 2015, the general fund has received 5% of its budgeted revenue versus 4% 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 received their monthly distributions from the County on time this month. 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 37% 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. 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 February 2015, the City has spent 12% of budgeted expenditures compared to 13% of budgeted expenditures in February 2014. The General Fund has spent 18% of its 2015 budgeted expenditures, versus 17% 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) Debt In February 2015, several debt service payments were made in the amount of - $4.78 million 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. Last month, the City added the PSAP (Public Safety Answering Point) to its list of debt in the amount of $2,657,696. Headcount The Full Time Headcount as of February 2015 was 1,076 vs. a budgeted amount of 1,094. Currently, there are a total of 18 vacant positions. The 18 open positions are in the following departments: Public Safety (4), Public Works (7), Code Enforcement / Animal Control (1), Parks Recreation (2) and other (4). If you have any questions regarding this report, please contact John Murphy at (574) 235 -7678. Financial Report February 2015 Page 2 of 25 City of South Bend Period Ending: February 28, 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 1,313,436 45,606,508 0% 311 Pro a Tax T/FDgstricts various 407 150,000 IS County Contract 24,084,000 0% Sub Total 7011702 5,345,126 ntractual Service 211 69,690,508 0% Income Tax 439 nds various 114,172 _ NA 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 1,313,436 tel Motel Tax Century Center 420 489,500 tel Motel Tax Cum Cap Impm 407 150,000 IS County Contract 101 0% b Total 7011702 5,345,126 State of Indiana Remitted b deral Drug 312 CRED Tax 434 99,293 1,729 75,000 650,000 0% 335 Cigarette Tax 1011407 35,000 yment in Lieu of Tax 317,818 0% 335 State Pension Subsidy 7011702 5,439,810 ntractual Service 211 11,557,092 0% 335 CTP Distribution 439 nds various 114,172 _ NA 335 Gaming Proceeds 101 199,523 468,230 464,579 600,000 0% 335 Gasoline Tax 2021251 348,926 369,636 718,562 4,647,000 15% 335 Liquor Excise tax 101 41,349 125,201 41,349 65,000 64% 335 Liquor Gallon eTax 101 67,259 303,580 67,259 200,000 34% 335 ProfSports Development Tax 377 63,326 142,874 206,200 610,000 34% 335 Wheel Tax 202 418,779 1,233,503 418,779 2,050,000 20% Sub Total 939,639 512,510 1,452,149 20,696,910 7% governmental Sources deral Drug 299 1,729 99,293 1,729 75,000 vte Drug 216 340 General Government Misc Ch s 1011289 35,000 yment in Lieu of Tax various 453,318 453,318 906,636 5,439,810 ntractual Service 211 13,183 11,261 24,444 243,000 nds various 114,172 798,302 14% 380 Central Service b Total 199,523 468,230 464,579 932,809 5,792,810 Charge for Service Internal City 340 Liability Insurance 226 99,293 101,897 201,190 1,222,727 16% 340 General Government Misc Ch s 1011289 6,000 0% 340 Police Take Home Vehicle 278 7,060 4,680 11,740 61,100 19% 349 Central Service 222 51,890 62,282 114,172 798,302 14% 380 Central Service 222 199,523 201,656 401,179 2,800,655 14% 380 Energy Office Reimbursements 222 383,538 417,794 801,332 4,471,200 18% 380 Internal Service Reimbursement various 114,099 125,201 239,300 2,837,264 8% 392 Administration Fee 101 303,580 303,580 607,159 3,642,953 17% 392 Internal Fund Transfers various 966,983 3,518,478 4,485,461 27,824,470 16% 395 Employee Benefits 711 1,234,237 1,233,503 2,467,740 16,425,996 15% Financial Report February 2015 - Revenue Report Page 3 or25 City of South Bend Period Ending: February 28, 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 2,968 22,000 13� 396 Self Funded Employee Benefits 711 13,173 13,173 N! Sub Total 3,373,375 5,972,039 9,345,413 60,112,667 16� ,d Party Revenue 340 No EMS Service 101 320 Inspections Central Service 222 150,000 0� 340 Memorial Hospital Neo Natal 101 10,022 56,678 66,699 N! 350 Job Target Penalty Fee 408 22,740 54,706 354,660 0� 364 Cable TV Franchise Fees 101 177,167 177,167 750,000 24� 366 AT&T Franchise Fees 101 69,037 69,037 245,000 28� Sub Total 54,764 10,022 302,882 312,903 1,499,660 21` rants 331 Federal Grants various 321,650 121,681 443,331 5,465,445 8� 334 State Grants various 1,600,000 0� Sub Total 321,650 121,681 443,331 7,065,445 6`, Fees for Services External 320 Inspections Central Service 222 1,400 0% 321 Business License 1011222 31,966 22,740 54,706 117,340 47% 321 Code and Animal Fees 600 3,725 4,795 8,520 59,850 14% 322 Building Fees 600 65,509 54,764 120,273 1,083,832 11% 322 Code Enforcement Fees 600 150 450 600 NA 322 EMS Operating Fund 288 2,233 2,460 4,693 24,500 19% 322 General Government Fees 101 6,640 725 7,365 10,000 74% 341 General Government Various various 1,736 1,940 3,676 27,405 13% 342 Highway & Streets 1011202 24,377 9,564 33,941 390,000 9% 342 Public Safety various 22,350 26,067 48,418 130,000 37% 342 EMS - Count Fees 288 1,667,565 0% 342 EMS - Capital Fund 287 396,727 396,727 NA 342 EMS - Operating Fund 288 198,675 156,466 355,141 2,900,000 12% 342 EMS - Neo Natal 288 385,000 0% 344 Solid Waste 610 401,357 397,131 798,488 5,091,168 16% 344 Code Environmental Clean Up 101 1600 11,215 1,263 12,478 50,000 25% 344 Sewage Waste Water 641 2,776,091 2,783,483 5,559,573 35,234,467 16% 344 Sewer Repair Insurance 640 50,523 52,458 102,981 548,000 19% 344 Water Leak Insurance 620 80,558 79,817 160,374 960,000 17% 346 Water Works Utility 620 979,733 976,299 1,956,032 13,678,403 14% 346 Solid Waste Misc 610 5,075 4,623 9,698 128,148 8% 346 Project ReLeaf 655 36,473 36,203 72,676 429,000 17% 347 Parks& Recreation various 88,374 165,687 254,062 3,565,575 7% 347 Blackthorn Golf Club 619 99,156 20,083 119,238 1,696,879 7% 347 Morris PAC 416 7,870 1,419 9,289 100,000 9% 349 Parking Garage Fees 601 77,130 56,458 133,588 973,926 14% 349 Code Demolition Board Up 1011600 2,932 9,994 12,926 20,000 65% 349 Parking Century Center 670 8,435 17,329 25,764 162,000 16% 349 Parking SBCDA 3241420 2,950 2,981 5,931 34,000 17% 351 Fines &Fees various 21,684 35,187 56,871 270,720 21% 352 Forfeits various 3,455 875 4,330 258,820 2% 354 Ordinance Violation various 1,305 2,165 3,470 35,500 10% 360 Morris PAC various 52,561 22,635 75,195 934,900 8% 360 Palais Royale various 22,259 6,290 28,549 243,820 12% 360 Parks& Recreation various 26,797 14,565 41,363 106,700 39% 360 Police various 3,170 4,378 7,548 46,600 16% 360 TIF various 5,056 2,657 7,713 44,806 17% 360 Central Services 222 19,705 3,212 22,916 11,000 208% 360 Century Center 670 5,117 4,970 148 25,000 4% 360 Dept Of Community Investment 2111212 95,353 95,353 247,000 39% 360 EMS Operating Fund 288 5,000 0% 360 Engineering/ Curb & Sidewalk 101 209 200 409 22,000 2% 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,049 32,100 3% 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 3,939 50,000 8% 360 ProfessionalSports Development 377 29,523 29,523 60,661 49% 360 UDAG 410 438,203 0% 360 Solid Waste Fund 610 2,000 0% 360 Waste Water 641/7/9 2,142 3,229 5,371 53,000 10% Financial Report February 2015 - Revenue Report Page 4 or25 City of South Bend Period Ending: February 28, 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 Water Works Utili 620 908 908 39,580 2% 362 Dept. Of Communi Investment 212 1,847 1,847 NA 362 Palais Royale 101 572 2,269 2,841 72,000 4% 362 Parks B Recreation 201 2,064 4,531 6,595 40,000 16% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 15,621 17,156 32, 777 214,025 15% 369 Memorial Hosp Leighton Plaza 408 150,000 150,000 150,000 100% 371 Century Center Fees 670 29,668 761,205 790,872 3,032,126 26% 399 Bosch Retention Project 210 59,966 0% 399 Principal on Loan various 1,799 20,705 22,504 207,398 11% 399 Principal Income xxx 368,031 368,031 1,224,390 30% Sub Total 5,476,452 6,558,266 12,034,718 77,428,773 16% st Income 1 Bank Account Interest various 197,258 51,054 248,313 742,116 Sub Total 197,258 51,054 248,313 742,116 ions 7 ND Contribution 101 330,000 7 Donations various 2,072 990 3,062 239,206 Sub Total 2,072 990 3,062 569,206 is Preservation 8 Palais 450 1,225 3,703 4,928 16,000 Sub Total 1,225 3,703 4,928 16,000 6Assets 1 TIF various 34,357 34,357 1,400,000 1 Water Hydrant Reimbursement 620 20,000 1 Proceeds F.A. Disposal 600 1 Sale of Fixed Assets van.ous 12,000 1 Vehicle Damage Reimbursement various 1,000 Sub Total 34,357 34,357 1,433,000 Revenue Total 12,866,555 16,029,980 - - - - - - - - - - 28,896,534 274,700,200 11% report 12,866,555 16,029,980 - - - - - - - - - - 28,896,534 274,700,200 0 0 0 Financial Report February 2015 - Revenue Report Page 5 or25 City of South Bend Revenue by Fund Report Period Ending: February 28, 2015 s i Fund Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct Nov Dec I Year I Bud et I of8ud et General Government 0000 General Revenues 101 1,167,120 944,443 2,111,563 50,195,282 4% 0101 Mayor 101 35 35 600 6% 0104 311 Call Center 101 55,195 36,290 91,485 470,291 19% 0301 Common Council 101 41 31 71 8,466 1 0401 Administration and Finance 101 220 220 30,050 1% 0501 Legal 101 508 508 53,000 1% Sub Total 1,222,390 981,491 2,203,882 50,757,689 4% Public Works 0602 Engine rin 101 77,027 OF Sub Total 77,027 0% Public Safety 0801 Police 101 6,604 11,372 17,976 537,700 3% 0901 Fire 101 10,022 59,625 69,647 12000 580% Sub Total 16,625 70,998 87,623 549,700 16% Code Enforcement 1205 Code Unsafe Building 101 143 143 NA 1207 Code Animal Control 101 NA Sub Total 143 143 NA Arts & Culture 0404 Morris PAC 101 53,329 23,300 76,629 923,000 8% 0405 Palais Royale 101 24,368 9,347 33,715 334,820 10% Sub Total 77,697 32647 110,344 1257,820 9% General Fund Revenue Total 1,316,569 1,085,136 - - - - - - - - - - 2,401,706 52,642,236 5% Financial Report February 2015 - Expenditure Summary Page 6 of 25 City of South Bend Revenue by Fund Report Period Ending: February 28, 2015 a % 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 of8ud et Parks & Recreation 0000 Parks General revenue 201 76,460 74,383 150,844 8,860,875 2% 1100 Administration 201 2,119 4,537 6,657 40,600 16% 1101 Maintenance 201 19,996 2425 22,420 319,600 7% 1102 Golfo erations 201 161 63,205 53,366 1,535,000 4% 1103 Recreation Division 201 26,067 16,036 42,103 185,640 23% 1104 Potawatomi Zoo 201 NA 1108 Grafd Removal 201 11,341 11,341 89,000 13% Recreation Non Reverting 203 65,607 98,601 164,208 1,578,935 10% East Race Waterway 271 5 1 6 NA Coveleski Stadium 401 36 9 45 15,100 0% Zoo Endowment 403 43 11 54 200 27% Park Non Reverting 405 4,435 260 4,695 143,700 3% Sub Total 194,930 270,809 465,739 12,768,650 4V Public Works Motor Vehicle Highway 202 716,020 1,133,459 1,849,479 9681,300 19% Central Services 222 655,888 688,603 1,344,491 8,121,097 17% Central Services Capital 224 271,850 0% Local Roads & Streets 251 87,782 90,155 177,937 1593,300 11% Pro'ect ReLeaf 655 37,371 36,419 73,791 431,700 17% Sub Total 1,497,062 1 948 636 3,445,698 20 099,247 17% Public Works Solid Waste Solid Waste Operations 610 408,178 401,846 810,024 5712 289 14% Solid Waste Capital 611 190,033 190,033 753,011 25% Sub Total 598,211 401,846 1000,057 6,465,300 15% Public Works Water Utility 0000 Water Works Revenues 620 916,194 910,250 1826,444 12704,463 14% 0630 Water Leak Insurance 620 80,558 79,817 160,374 960,000 17% 0660 Clay Water 620 68,898 68,829 137,727 1,096,020 13% Waterworks Capital 622 Z 776 682 3,457 10,000 35% Waterworks Construction 623 180 41 221 NA Waterworks Deposit 624 1,307 324 1,630 6,000 27% Waterworks Sinking 625 468 340,551 341,019 2,050,078 17% Waterworks Bond Reserve 626 1,425 353 1,778 NA Waterworks Debt Reserve 629 1,840 150,683 152,523 16Z 749 94% Sub Total 1,073,645 1,551,529 Z 625,174 16,989,310 15% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 51,853 52,790 104,643 549,200 19% 0000 Wastewater Revenues 641 2,628,692 2,622,801 5,251,493 33,197,505 16% 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 319,666 2,059,962 16% Sewage Ca ital 642 3,385 815 4,199 5,398,000 0% Sewage Reserve 643 3,020 256,833 259,853 250,612 104% Sewer Bond 2007 647 NA Sewage Bond Sinking 649 774,321 773,801 1,548,123 9,288,088 17% Sewer Bond 20078 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 1,807 6,000 30% 2012 Sewer Bond 661 14,968 3,669 18,638 20,000 93% 2013A Sewer Refund Bonds 664 4 1 5 NA Sub Total 3,635,057 3,878,074 7,513,131 50,846,367 15% Financial Report February 2015 - Expenditure Summary Page 7 of 25 City of South Bend Revenue by Fund Report Period Ending: February 28, 2015 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 ofeud et Public Safe - Police 601 909 909 4,000 23% Police Seizures 216 162 41 203 35,900 1% Curfew Violations 218 11 3 13 1,025 1% Law Enforcement Education 220 24,859 28,459 53,318 211,000 25% Public Safety LOIT 249 540,008 539,058 1,079,066 6,472,190 17% Excess Welfare Public Safety 252 0 - 0 15.900 NA Police Take Home Vehicle 278 14,575 9,474 24,049 124,200 19% Police Block Grant 280 3 1 4 NA Police Grants 292 55 55 90,000 0% Pnli-Academy 294 11,010 7,628 18,639 22,000 85% COPS More Grants 295 564 782 1,345 128,258 1% Drua Enforcement 299 1,817 83 1,900 77,000 2% K -9 Unit 705 503 1 504 2,000 25% Sub Total 593,567 585,530 1,179,096 7,163,573 16% Publie Safe - Fire Emerge' Telephone System 244 19 19 NA ital 287 396,727 396,727 750,000 53% erafin Fund 288 204,337 16 9,122 373,460 5,676,065 7% 289 3 732 10 095 13 828 f0 000 138% scue 291 3,093 Z423 5,516 45,200 12% Sub Total 211,182 578,368 789,550 6,481,265 12% Department of mmunity Investment Studebaker /Oliver 209 959 3,612 4,572 574,000 1% State Grant 210 290 70 360 1,673,510 0% ,,Cl Operating 211 14,699 503,257 517,957 Z 631,625 20% 0000 De t. of Community Investment 212 3,790 122 753 126,543 4,100,000 3% xxx Pro rams 212 95,353 95,353 NA 0000 Economic Revenue Bond 281 24 6 30 NA Sub Total 115,115 629,699 744,814 8,979,135 8% 0000 Parking Garage Revenue 601 909 909 4,000 23% 0460 Main Street 601 20,879 17,180 38,059 267,487 14% 0462 Leighton Plaza 601 38,528 22,329 60,857 451,691 13% 0463 Enforcement 601 5,219 7,017 12,235 114,900 11% 0464 Wayne Street 601 17,498 16,724 34,222 254,748 13% 0465 Eddv Street Commons 601 - - - 15.900 0% Financial Report February 2015 - Expenditure Summary Page 8 of 25 City of South Bend Revenue by Fund Report Period Ending: February 28, 2015 s % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct Nov Dec I Year I Budget I ofeud et Other Miscellaneous Rain Da 102 7,630 1,888 9,518 34,680 27% Excess Le 103 1 1 NA Gift Donation Bequest 217 1,618 989 2,607 216,100 1% Loss Recovery 227 5,206 4,007 9,213 4,200 219% Human Rights 258 2,065 7,188 9,252 203,400 5% Morris Palais Marketing 273 274 6 280 18,000 2% Professional Sports Development 377 93,375 142,965 236,340 671,761 35% 1201 Code Enforcement 600 18,559 529,948 548,507 2,378,996 23% 1207 Animal Control 600 3,725 162,197 165,922 689,218 24% 1306 Building Operations 600 66,158 54,907 121,065 1,085,899 11% Century Center 670 32,985 783,504 816,489 4,532,562 18% Century Center Capital 671 24 21 45 500 9% Sub Total 231,619 1,687,621 1,919,240 9,835,316 20% Business Insurance 0000 Business Insurance Revenues 226 104,344 103,108 207,451 1,243,227 17% 0418 Workers Compensation 226 17,000 0% Sub Total 104,344 103,108 207,451 1,260,227 16% Fiducia Trust & Agency Fire Pension 701 688 130 818 5,211,592 0% Police Pension 702 1,133 230 1,363 6,360,000 0% Employee Benefits lCi 711 1,248,718 1 226 227 2 474,946 16 223,345 15% Unemployment Comp 713 8,685 8,526 17,211 226,796 8% Cemetery Trust 730 25 6 31 150 21% Sub Total 1,259,249 1 235 119 Z494,369 28 021,883 9% Civil City Revenues 12,653,540 15,953,113 - - - - - - - - - - 28,606,653 246,330,290 12% Tax Increment Financing TIF Air ort 324 50,350 33,228 83,579 14,880,000 1% TIF Central Development 420 695 4,240 4,935 4,344,202 0% TIF West Washington 422 996 261 1,257 422,000 0% TIF Leighton Plaza 425 18,229 12,971 31,199 189,123 16% TIF Medical Service 426 1,941 501 2,442 632,000 0% TIF Northeast 429 23,215 993 24,208 827,000 3% TIF Southside 430 4,144 1,025 5,168 2,410,000 0% TIF Erskine Village 432 5,246 1,268 6,514 25,000 26% TIFDou /as Road 435 161 48 209 320,750 0% Northeast Residential TIF 436 1,215 352 1,567 2,604,000 0% Sub Total 106,191 54,887 161,077 26,654,075 151 Financial Report February 2015 - Expenditure Summary Page 9 of 25 City of South Bend Revenue by Fund Report Period Ending: February 28, 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 - - - - - - - - - - 289,882 28,369,910 1% City Operations Total 12,866,555 16,029,980 - - - - - - - - - - 28,896,535 274,700,200 11% Revenue report 12,866,555 16,029,980 0 0 0 0 0 0 0 0 0 0 28,896,535 274,700,200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report February 2015 - Expenditure Summary Page 10 of 25 City of South Bend Period Ending: February 28, 2015 Property Tax Revenue 2013 Tax Pay 2014 Fund Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy 101 Per County Collection Projected 61612014 612512014 1212412014 Total Property Tax Collection 36,779,631.05 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 February 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 February 2015 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending: February 28, 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 133,014 741,267 1 Call Center 101 55,195 36,290 91,485 486,733 erk 101 34,775 28,270 63,045 431,573 ommon Council 101 33,803 24,869 58,672 490,150 NIT Contract 101 411 411 43,000 Iministration and Finance 101 187,531 134,271 321,801 2,020,544 gal Department 101 99,178 73,129 172,307 1,006,979 ib Total 490,946 349,379 840,325 5,220,246 cs igineering 101 72,931 79,671 152,601 1,058,933 ib Total 72,931 79,671 152,601 1,058,933 ty dice 101 2,557,412 1,878, 728 4,436,141 25, 633,064 lice -PS LOIT funded 101 2,562 6,199 8,761 Mice Communications 101 135,031 97 135,128 1,687,540 •e 101 2,150,469 1,590,349 3,740,818 17,774,474 v-PS LOIT funded 101 411 411 x ib Total 4,845,886 3,475,373 8,321,260 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 184,428 1,093,132 dais Royale 101 41,912 31,105 73,017 536,293 ib Total 138,749 118,696 257,445 1,629,425 Ws iman Rights 101 50,323 31,896 82,219 373,179 ib Total 50,323 31,896 82,219 373,179 General Fund Expenditure Total 5,598,836 4,055,015 - - - - - - - - - - 9,653,850 53,379,131 18% Financial Report February 2015 - Expenditure Summary Page 13 of 25 City of South Bend Period Ending: February 28, 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 175,899 967,568 18% 1101 Maintenance 201 435,157 348,338 783,495 5,178,905 15% 1102 Golfo eradons 201 66,821 76,812 143,633 1,573,436 9% 1103 Recreation Division 201 193,339 143,079 336,419 2,328,698 14% 1104 Potawatomi Zoo 201 392,247 lIZ389 504,635 863,017 58% 1106 Potawatomi Greenhouse 201 5,079 20,391 25,470 53,997 47% 1108 Graffiti Removal 201 9,057 7,116 16,173 98,374 16% Recreation Non Reverting 203 43,898 60,957 104,855 1,549,469 7% East Race Waterway 271 968,839 1,479,202 2,448,041 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 2,090,578 12,862,937 16% Vorks Motor Vehicle Highway 202 734,565 950,683 1,685,248 8,843,890 Curb and Sidewalk 202 lIZ714 39,990 152,704 1,641,496 Central Services 222 679,565 621,835 1,301,399 8,279,085 Central Services Capital 224 4,000 1% Waterworks Capital 271,850 Local Roads & Streets 251 4,155 4,853 9,007 1,926,221 Project ReLeaf 655 15,357 2281 17,638 528,358 Sub Total 624 1,546,355 1,619,642 3,165,997 21,490,900 Vorks Solid Waste Solid Waste Operations 610 635,488 341,051 976,539 5,873,863 Solid Waste Capital 611 223,749 143 223,892 752,811 Sub Total 859,237 341,194 1,200,431 6,626,674 Public Works Water Utility 0630 Water Leak Insurance 620 33,830 53,166 86,996 1,115,000 89/ 0640 Water Works 620 906,773 1,320,043 2,226,816 14,725,471 15% 0660 Clay Water 620 22 29,608 22 4,000 1% Waterworks Capital 622 15,382 67,463 82,845 838,893 10% Waterworks Construction 623 11,278 37,750 49,028 53,085 92% Waterworks Deposit 624 452 324 776 6,000 13% Waterworks Sinking 625 465 1 467 2,050,078 0% Waterworks Debt Reserve 629 637 455 1,092 8,500 13% Sub Total 647 968,839 1,479,202 2,448,041 18,801,027 13% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 21,449 57,144 78,593 545,703 14% 0621 Sewer Repair 641 446,632 360,251 806,883 5,201,049 16% 0625 Concrete Crew 641 44,148 29,608 73,756 450,450 16% 0630 Wastewater Operations 641 2,004,256 2,110,111 4,114,367 31,017,413 13% 0631 Organic Resources 641 69,307 56,543 125,850 1,527,562 8% 0650 Clay Sewage 641 28 28 500 6% Sewage Ca ital 642 39,115 47,104 86,219 9,071,710 1% Sewage Reserve 643 1,045 747 1,792 15,000 12% 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 645,836 3,711,838 17% 2012 Sewer Bond 661 39,170 249,076 288,246 16,624,275 2% 2013 Sewer Bond 663 NA Sub Total 2,809,188 3,414,232 6,223,420 77,447,609 8% Financial Report February 2015 - Expenditure Summary Page 14 of 25 City of South Bend Period Ending: February 28, 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 Seizures 216 35,728 35,728 750,000 35,900 0% Violations 218 280,257 6,855,366 Hazmat 1,000 0% forcement Education 220 15,730 29,274 45,004 362,478 12% nc Tele hone S stem 244 20 1 21 70,730 NA UE- 249 73 2,055 515,347 1,247,402 7,246,551 17% Welfare Pu61ic Safet 252 369,417 329,268 698,685 1,146 0% Take Home Vehicle 278 55,859 153,529 209,388 71,100 0% Grants 292 1,268 15,297 15,297 105,145 15% Academ 294 2,725 9,673 12,398 23,750 52% More Grants 295 20,490 784 21,274 172,335 125/ onto Enforcement 299 18,385 6,474 24,859 248,960 10% K -9 Unit 705 2,899,524 2,754,112 5,653,636 2,000 0% Sub Total 789,405 576,850 1,366,255 8,270,365 17% sfe - Fire EMS Ca ital 287 16,261 35,728 35,728 750,000 EMS O eratin Fund 288 247,977 32,280 280,257 6,855,366 Hazmat 289 20,939 602 21,542 31,530 River Rescue 291 0 2,120 2,120 120,800 Sub Total 212 268,916 70,730 339,646 7,757,696 ent of Community Investment StudebakeLVOliver 209 16,261 3,375 3,375 600,000 State Grant 210 12,200 24,311 12,200 1,694,412 DCl Operating 211 250,396 178,976 429,372 2,661,730 Dept, of Community Investment 212 102,720 134,503 237,223 5,899,970 Administration 212 183,750 365,625 50% 15,900 Programs 212 4,101 12,414 16,514 647,998 Sub Total 410 369,417 329,268 698,685 11,504,110 Garages Main Street 601 16,261 29,534 45,795 187,391 Leighton Plaza 601 16,812 24,311 41,123 296,570 Enforcement 601 1,340 31,872 33,213 89,236 Wayne Street 601 54,617 27,884 82,501 342,615 Eddy Street Commons 601 183,750 365,625 50% 15,900 Sub Total 577,062 89,030 113,600 202,631 931,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 2,119,512 15,660,371 14% Cum Capital Development 406 112,650 112,650 542,691 21% Cum Capital Improvement 407 183,750 183,750 365,625 50% EDIT 408 577,062 1,795,231 2,372,293 9,627,618 25% UDAG 410 438,203 0% Major Moves 412 55,859 153,529 209,388 3,096,061 7% Morris PAC Improvement 416 1,268 1,665 2,933 70,248 4% CRED 434 3,897 3,897 650,000 1% Palais Historic Preservation 450 16,150 0% Hall of Fame Ca ital 677 6,843 6,370 13,213 188,824 7% Sub Total 2,899,524 2,754,112 5,653,636 31,922,611 18% Financial Report February 2015 - Expenditure Summary Page 15 of 25 City of South Bend Period Ending: February 28, 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 27,830 297,182 9% Loss Recovery 227 181,590 298,680 480,270 5,237,243 9% Human Ri hts 258 22,061 9,167 31,228 247,357 13% Morris Palais Marketin 273 Sub Total 96 96 18,974 1 Professionals orts Develo ment 377 480,773 800 481,573 854,803 56% 1201 Code Enforcement 600 120,449 101,851 222,300 2,414,485 9% 1207 Animal Control 600 57,484 47,550 105,034 696,216 15% 1306 Building Operations 600 104,444 75,646 180,090 1,094,700 16% Century Center 670 306,497 285,449 591,945 4,532,562 13% Century Center Capital 671 1,464,000 66,156 66,156 3,425,632 NA Sub Total 1,273,296 913,225 2,186,522 15,393,522 14% s Insurance Self Funded Liability Ins 226 26,134 26,675 52,809 282,900 Liability Insurance 226 156,054 7,585 163,640 1,184,891 Business Insurance 226 15,927 14,875 30,802 600,000 Workers Compensation 226 64,123 206,418 270,541 989,000 Sub Total 730 262,238 255,553 517,792 3,056,791 Trust & A enc Fire Pension 701 441,192 441,276 882,468 5,666,579 Police Pension 702 537,112 524,012 1,061,124 6,832,235 Employee Benefits 711 1,030,771 963 626 1,994,397 16,696,935 Iem to ment Comp 713 10,126 5,167 15,294 226,796 t Cemetery Trust 730 16,624 154,716 11% 20,000 Sub Total 2,019,201 1,934,080 3,953,281 29,442,545 Civil City Expenditure 21,003,306 18,697,459 - - - - - - - - - - 39,700,764 298,887,630 13% Tax Increment Financing TIFAir ort 324 2,276,439 1,684,991 3,961,430 47,710,597 8% TIF Central Development 420 964,016 957,248 6,768 4,537,169 0% TIF West Washington 422 15,300 15,300 760,900 2% TIF Leighton Plaza 425 6,962 9,662 16,624 154,716 11% TIF Medical Service 426 2,476,033 0% TIF Northeast 429 112,956 5,000 117,956 7,239,524 2% TIF Southside 430 435,370 24,431 459,801 2,842,535 16% 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 7,017,358 70,183,875 10% Financial Report February 2015 - Expenditure Summary Page 16 of 25 City of South Bend Period Ending: February 28, 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 5,000,000 Blackthorn Golf Operations 619 69,055 89,358 158,413 1,671,706 Sub Total 69,055 89,358 158,413 6,677,706 Cervlce Airport Debt Reserve 2003 315 317 227 544 5,000 Central Development reserve 328 530 379 909 6,000 Sub Total M 847 606 1,453 11,000 Financial Report February 2015 - Expenditure Summary Page 17 of 25 Redevelopment Commission 5,687,190 1,490,033 - - - - - - - - - - 7,177,223 76,872,581 9% City Operations Total 26,690,496 20,187,492 - - - - - - - - - - 46,877,988 375,755,525 12% Expenditure report 26,690,496 20,187,492 0 0 0 0 0 0 0 0 0 0 46,877,988 375,755,525 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report February 2015 - Expenditure Summary Page 17 of 25 City of South Bend Debt Schedule Period Ending: February 28, 2015 Yearol I Y-1 I Yearo/ 8obedoled Payments Debt[06R /Re1i) Debtat 2015Pdnoioal - 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 lmaq,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 Sswage 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 +0+ 2012 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 +e 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 Revolvino 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 1+ 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 to 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 Technolwv 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 to 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 at 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 a+ GE Capital Information Technolwv Police Dept Cooler 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 Come 2011 2016 101 D15 5115 8115 11/15 2.569.53 1,110.31 539.50 48.98 0.00 570.81 588.48 se 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 GECapitallnfama0on Techn,Iwv Fire Dooe,onent 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 SbaeVSewer Dept Copier 2013 2018 202/861 3/d 6/4 9/4 1216 5.559.15 3.4]5.34 1.092.25 1]8.55 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 Coniers(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 +0 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 ++ 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 +z 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 +s 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 +4 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 +z Police Dept Record Div. Ricoh Police ReceMS 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 +a Wator Works Main Riceh Copier Water Works Main Ricoh Copier 2013 2018 520 Manlhly 10th 5.64].50 4,639.36 1.065.38 230.08 0.00 3,5]3.98 1,285.46 +a 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 MaMhly 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. /Public 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 Leased Computer Equipment Lease 2014 2018 604 M-thly 8th 5.886.15 5,461.99 1.30].5] 188.4] 0.00 4,154.42 1.496.06 za HP Computer Lease #6 Computer Equipment LSase 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 s+ Police COmmunica0ws Copier Ricoh USA Copier 2014 2019 101 Mwthly 12th 8,843.00 8.196.88 1.813.55 618.29 0.00 6.583.31 2.031.86 sz Organic Reswrces B Wastewater Ricoh USA Copiers 2014 2019 641 Mwthly 21st 12.260.18 11.182.59 2.24].61 569.39 0.00 8.934.98 2.817.00 Total Capaal Lease 16,448,834.54 9,666,736.40 3,170,689.31 160,326.53 0.00 6,496,047.09 3,331,015.84 rmaenesa pest reemey zws -Dees nape ormzs City of South Bend Debt Schedule Period Ending: February 28, 2015 Yearol I Yearol I Yearo/ 8obedpled Pavments -It [Odp /Re1i) Debtat 2015Pdncipal - 151nfe 1 1015 Debtat 2015 Total Debt lnsWment Deb[PUmose Issw Rafuntling MaludN Funtl 1s1 Intl 3rd /M Issue 1T/31/. Pavments Payment Atltlltlon 12/31/1015 Debt Pavments Rod-loo menl Commission Debt Bond Debt z 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 Coll- Football Hall of Forma 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 11 South Bend Building Corporation Mans PAC 1998 2009 201] 408 Z1 8/1 - - 13.300000.00 2.480.000.00 950.00.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 7/1 - - 6.620,000.00 3,010,000.00 395,000.00 86.350.00 0.00 2.615.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,535.000.00 690,000.00 404.611.50 0.00 ].845.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.38.00 sa Lease Rental Revenue Bonds of 2008 Eddv S1met Commons 2008 202] 429 2115 8115 - - 36.000,000.00 33,020. 1.075,000.00 1.853.268.00 0.00 31.945.000.00 2,928,268.00 e1 Coveleski Stadium Recovery Coveleski Stadium 2010 2019 37] 1115 ]115 - - 4.980.000.00 2.915.000.00 620.00.00 134.802.50 0.00 2.295.000.00 ]54.802.50 oa 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 666.666.68 21 Blackthorn Golf Cart Lease Blackthorn G.11 2014 2019 619 Monthly 14th 293.]88.00 25].236.64 25].238.04 4.688.91 0.00 0.00 261.926.95 zz Synago�ue at C -leski Improvements Coveleski Stadium 2014 2018 377 1131 500,000.00 400.000.00 100.000.00 0.00 0.00 300.000.00 100,000.00 Total Bond Debt 128.]88,]88.00 76,173.904.72 7.678,904.72 3.703.158.41 0.00 68,495.000.00 11.382,063.13 Loans Payable a Indian a Development Finance Authority Bosch Propertv(Nonforgive) 2001 2021 270 3122 6122 9122 12122 1.04 000,00 423.820.93 59.966.23 12.044.21 0.00 363.854.]0 72.010.44 a Indiana Development Finance AUthaity Basch Pro- v(Fagive) 2001 2021 210 - - 260.000.00 11].130.26 0.00 0.00 0.00 100.55].56 0.00 eo HUD Section 108#8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4,000,000.00 180,000.00 180,000.00 ].]94.00 0.00 0.00 18],]94.00 sJ City d Mishawaka Douglas Road TIF 2009 2029 435 2115 8115 - - 1.102.549.56 47.003.09 47.003.09 1.1]5.08 0.00 0.00 48.1]8.1] ea Intertund FUnd 412 -Maior Moves Douglas Road TIF 2009 2029 435 2175 8/15 1,040,319.00 886.6]].00 251.15].00 41,852.00 0.00 635.520.00 293,009.00 ea Intertund FUnd 619 - Blackthorn Blackthorn Eguip(goff -) 2010 2017 619 5115 6115 7115 8115 31.032.00 11.63].00 3.8]9.00 0.00 0.00 ].]58.00 3.8]9.00 as Intertund FUnd 412 -Maior Moves THangle Development 2011 2029 436 2115 8/15 - - 2.000,000.00 1.513,259.50 90.929.20 29,812.80 0.00 1.422.330.30 120,]42.00 as Intertund FUnd 412 -Maior Moves Eddv Street Commons 2011 2028 436 2115 8115 - - 4.100.000.00 3.22].558.81 213.898.29 158.]39.]1 0.00 3.013.882.52 3]2.436.00 as Intertund Fund 209 to Airport 324 Prairie Ave Brownfeld Proiecl 2011 2020 324 B/9 500.000.00 500.000.00 0.00 0.00 0.00 500,000.00 0.00 ea Blackthorn Loan from Airport Blackthorn Equip (mowers) 2011 2018 619 5115 6115 7115 8115 53.598.50 30.149.06 8.899.84 0.00 0.00 23.449.22 6.699.84 iolal Lwns Payable 14.127.499.06 6.937.235.65 853.330.65 251.417.80 0.00 6.067.332.30 1.104.748.45 Capbal Lease Total Capita/ Lease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leases at Transpp Lease LeigM1ton Plaza Garage 2001 2015 404 6130 12/30 - - 3,000,000.00 191.34].00 191.34].00 8.653.00 0.00 0.00 200.000.00 1s Transpo Lease Main I Colfax Garage 2006 2025 404 3115 9115 - - 2.510.2]8.00 1.6]6.543.00 117.825.00 82.3]5.00 0.00 1.558.918.00 200.000.00 Total Lease 5.510.2]8.00 1.86].890.00 308.9]200 91.028.00 0.00 1.558.918.00 400.000.00 Total Redevelopment Comm /sslon 148.426.585.06 84.9]9.030.3] 8.841.20].3] 4.045.604.21 0.00 ]6.121.25030 12.886.811.58 I Total Debl 111111111111 1 389,062,428.10 240,516,100.27 22,984,241.68 9,108,574.23 0.00 217,515,285.89 32,092,815.911 re'anneiaepwt re0rueryzol5 -peel City of South Bend Period Ending: February 28, 2015 Monthly Debt Schedule Year O/ Vearol Year O/ 8cbetivled Payments DebtlOrrll -i) Debt at YTD Principal YTD Interest YID Debtat Debt.. -nt Deal Pura... .- Refunding Maturity Funtl 1s1 2ntl 3b 1. Issue 12/31/2010 Payments Payments Addition. 2/28/2015 Clvll Citv Debt Bond Debt 31 EDIT Bond 1997 2006 201] 408 2/1 8/1 - - 11.8]0.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 lmaq,ements 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 Sewage 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,OOOW 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 Revenue 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 711 - - 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 2013A 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 COmoraion EMS I Fire Nossirent 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].606.50 20.562.92 12.658.80 0.00 2.63].133.58 Total Bond Debt 194.364.696.50 142.609.083.50 1.625.562.92 519.072.23 0.00 140.983.520.58 Loans Pevable sa State Revolving Fond Water Wake Improvement 2009 2030 625 ]/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) Savo- 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 Lasses 11 Chase LED Equipment 2007 201] 701 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 EMOrcement OCe Cagier 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 Cant. 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 ace Copier 2010 2015 707 1/8 4/8 ]/8 10/8 9,209.00 1,586.72 518.]4 30.90 0.00 1,06].98 zs Advancetl Imaging Central Services Duplicators 2010 2015 222 1/15 4115 7115 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 677 6n5 12/15 321,853.00 6],665.30 0.00 0.00 0.00 6],665.30 as Sun Trust Police. P.ft. Bldg vehicles 2011 2016 404/201/800 3115 8115 9115 12/15 2.068.202.00 641.545.46 0.00 0.00 0.00 841.545.46 so Capital One Public Pon in. Solid Waste Contar- ITmcks 2011 2016 611 3115 6n5 9n5 12/15 20],432.00 ]4,504.09 0.00 0.00 0.00 ]4,504.09 a1 GE Ca vital lnfama0on Technolwv Police Oad Cope 2011 2018 101 1/11 4111 7111 10/11 3.836.00 1.2]5.18 204.82 1].36 0.00 1.0]0.36 az Kev Finance IT Phone Swtem 2011 2016 404 1115 1,444,995.97 569,323.31 281,141.18 14,258.23 0.00 288,182.13 W Ikon Office Sol Mawr Ricoh MP 2851 SP Come 2011 2016 101 2115 5115 8115 11/15 2.569.53 1.110.31 132.03 15.09 0.00 978.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 Equipment Finance Police Vehicles BEmioment 2012 201] 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,717.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,770.10 190.87 29.45 0.00 2,9]9.23 as GE Capital lnfama0on 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] 5 127 8 127 112] 3.622.78 2,315.31 188.32 21.62 0.00 2,126.99 w Ricgh USA SbaeVSewer Not Copier 2013 2018 202/661 3/d 6/4 9/4 1216 5.559.15 3.4]5.36 0.00 0.00 0.00 3.4]5.34 oa Riwh USA City Atlom.v Copier 2013 2018 101 2112 5112 8/12 11112 5.559.15 3,492.63 283.90 33.80 0.00 3,208.]3 oe Ricoh USA Parks 8 Roc Ricoh Cooiers(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 VahiclalEdi want Lease 2013 2018 1011202/406/641 1115 7/15 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 0.00 0.00 0.00 8.]90.21 1z Moat USA Builtlinq D.d. Copier 2013 2018 600 Monthly 4.093.64 3,109.92 128.13 28.3] 0.00 2,981.]9 1s Sun Trust Eguioment Finance Police and PW Vehicles 2013 2018 406/855/811202 4/24 1024 1.506.685.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-- Copier 2013 2018 101 Monthly 3hJ 9.8]8.28 ].950.10 29].41 ]2.59 0.00 ].852.69 fa Water Works Main Riceh Gooier Water Works Main Ricoh Copier 2013 2018 620 Manlhly 10th 5.64].50 4,639.36 1]3.50 42.40 0.00 4,465.86 1a Wate Works COffax Ricoh Gooier WaterWaks Colfax Ricoh pool) 2013 2018 620 .-lhIV 16th 4,]32.65 3.881.86 145.39 35.53 0.00 3.]42.45 za Water Works Olive Riceh Gooier Water Works Olive Ricoh Copies 2013 2018 620 Monthly 10th 4.]32.65 3,887.84 145.39 35,53 0.00 3,]42.45 zs Police Traininq Ded. Ricoh Copier Training Coda 2014 2019 101 Monthly 30th 6.263.00 3.714.38 129.61 36.39 0.00 3.586.]] z4 Kev GOVemment Finance 2014 City Vehicles 2014 2019 411 1011 1,959485.95 1.959,485.95 0.00 0.00 0.00 1.959,4 85.95 zs HP Compute Lease #1 CCRloule Eguigment Lease 2014 2018 Mgnihly 8th 13].106.95 124.556.02 6.8]8.91 925.15 0.00 119.6]5.11 26 HP Computer Leese #2 Ccmode Equipment Lees. 2014 2018 201 and 620 Monthly 8th 4.000.00 3,]20.95 141.65 28,43 0.00 3,5]9.30 zz HP Computer Lease ltd Compute Eguioment Lease 2014 2018 606 Mgnthiv 8th 5.886.15 5.461.99 214.43 36.91 0.00 5.247.56 za HP Computer Leese #6 Ccmode Eguioment Leese 2014 2018 201 Monthly 8th 3.755.50 3,561.10 130.92 28.60 0.00 3,430.18 za HP Computer Lease #7 Compute Eguioment Lease 2014 2018 620 Monthly 8th 1.326.00 1.254.1] 48.26 ].88 0.00 1.205.91 as So lid Waste Gooier Ricoh USA Copier 2014 2019 611 Monthly 17th 5.351.65 5,351.65 233.50 ]3.91 0.00 5,118.15 s1 Police Communications Gooier Riooh USA Copier 2014 2019 101 Mgnthiv 12th 8.843.00 8.196.88 282.]0 ]5.94 0.00 ].934.16 az 0roanic Resources B Wastewater Ricoh USA Copiers 2014 2019 641 Monlhly 21st 12.260.18 11.182.59 365.93 103.5] 0.00 10.816.66 Total Capital Lease 16.448.834.54 9.666.736.40 82],987.73 47.666.92 0.00 8.838.148.67 Total Civil Cav 240.635.863.04 155.537.069.90 2.453.550.65 566.739.15 0.00 153.083.519.25 rerannesaepMreOrveryzol5 -peel City of South Bend Period Ending: February 28, 2015 Monthly Debt Schedule Year O/ Veat Ol Year O/ 8cbedvled Payments Debt lode /Re1i) Debt at YTD Principal YTD Interest YTD Debtat Debt.. -nl Deb[PUmosa Issw Rafundinp Maludty Funtl 1s1 2nd 3nf 4th Issue 12/31/2010 Payments Payments ACdldons 2/28/2015 Rod-loo manl Commission Debt Bond Dabl z CeIt- Center Lease Rental Revenue Century Center 1994 2001/2011 2018 407 2/1 8/1 - - 6.825.000.00 1.630.000.00 225,000.00 19.8]5.00 0.00 1,405.000.00 a Coll- Football Hall of Fame 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 ,t South Bend Buildlnc Con -ation Mans PAC 1998 2009 201] 408 vi 8/1 - - 13.300.000.00 2.480.000.00 4]0.000.00 48.012.50 0.00 1,990.000.00 tz TJX Spacial Tevnq 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,985.000.00 595.000.00 361.248.00 0.00 14.3]0.000.00 e.- 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 Recoveni Covet. Stadium 2010 2019 37] 1115 7115 - - 4.980.000.00 2.915.000.00 310.000.00 ]0.]]2.50 0.00 2.605.000.00 oa 2012 Gates Downtown Campus VA Clinic Agml Loan 2012 2015 420 3/1 8/1 - - 1,]00,000.00 566,666.68 0.00 0.00 0.00 566,666.68 zt Bladethon, Gelf Cart Lease Blackthorn Golf 2014 2019 619 Monthly 14th 293,]88.00 25].236.04 25].238.04 535.91 0.00 0.00 zz Synagogue at COVeleski Improvements Coveleski Stadium 2014 2018 377 1131 500,000.00 400,000.00 100.000.00 0.00 0.00 300,000,00 Total Bond Debt 128,]88,]88.00 76,173,904.72 3,617,238.04 1,837,693.41 0.00 72,556,666.68 Loans Payable a Indiana Development Finance Authority Bosch Propertv(NOnforgive) 2001 2021 210 3122 6122 9122 12122 1,040,000.00 423,820.93 0.00 0,00 0.00 423,820,93 a Ino', Development Finance AUthaity Bosch P- ,aIv(Fargw) 2001 2021 210 - - 260.000.00 11].13026 0.00 0.00 0.00 11].130.26 eo HUD Section 108#8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4,000,OOOAO 180,000.00 0.00 3,89].00 0.00 180,000.00 m City of Mishawaka Douglas Road TIF 2009 2029 435 2115 8115 - - 1.102.549.5fi 4].003.09 4].003.09 1.1]5.08 0.00 0.00 ea Intertund FUnd 412 -Maio, Moves Douglas Road TIF 2009 2029 435 2115 8115 1,040,319.00 886,67].00 99,2]5.00 22,16].00 0.00 ]8],402.00 ea Intertund FUnd 619- Blackthan Blackthorn Equip(gollcarts) 2010 2017 619 5115 6115 7115 8115 31.032.00 11.63].00 0.00 0.00 0.00 11.63].00 a4 Intertund FUnd 412 -Maio, Moves THeDoi, Development 2011 2029 436 2115 8115 - - 2,000,000.00 1.513,259.60 45.238.41 16,132.60 0.00 1.468,021.09 as Intertund FUnd 412 -Maio, MOVes Edov Street Commons 2011 2026 436 D15 8115 - - 4.100.000.00 3,22].558.81 105.529.03 80.688.9] 0.00 3.122.029.]8 as Intertund Fund 209 tc Airport 324 Prairie Ave 3, -fl.ld Project 2011 2020 324 B/9 Soo,000.00 500,000.00 0.00 0.00 0.00 600,000.00 ea Blackthan Loan from Airport Blackthorn Equip (mowers? 2011 2018 619 5115 6115 7115 8115 53.598.50 30.149.06 0.00 Me 0.00 30.149.06 Total Loans Payable 14.127.499.06 6.937.235.65 297.045.53 123.060.65 0.00 6.640.190.12 Caobal Lease Total Capita/ Lease O.00 0.00 0.00 0.00 0.00 Dee Lewes at Transpo Lease Leighton Plaza Garage 2001 2015 404 6130 12130 - - 3,000,000.00 191,34].00 0.00 0.00 O.00 191,34].00 ,s T,an.. Lease Main 1 Colfax Garage 2006 2025 404 3115 9115 - - 2.510.2]8.00 1.6]6.543.00 O.OD 0.00 O.OD 1.676.543.00 Total Lease 5.510.2]8.00 1.867.890.00 0.00 0.00 O.Do 1.88].890.00 Total Redevelopment Comm /sslon 148.426.585.06 84.9]9.030.3] 3.914,283.5] 1.960.]54.06 0.00 81.064.]46.80 Total Debl 1 1 389,062,428.10 240,516,100.27 6,367,834.22 2,527,493.21 0.00 234,148,266.05f re'anneiaepMreOrueryzol5 -peel 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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report February 2015 - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Financial Report February 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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Code Enfor. /Animal Control 24.00 23.00 23.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 25.00 23.00 23.00 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Recreation Nonreverting 1.00 1.00 1.00 0.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 0.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 0.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 Fire 258.00 258.00 258.00 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report February 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Mayor 1.00 1.00 0.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 0.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 0.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 0.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 0.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 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 Administration 5.00 5.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 0.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 0.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 0.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 39.00 41.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 5.00 5.00 0.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 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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Engineering 3.00 3.00 0.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 0.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 0.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 0.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 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report February 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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Maintenance 11.00 10.00 0.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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Police 27.00 27.00 0.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 0.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 0.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 0.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 0.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 0.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 0.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 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 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 0.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 0.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 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Financial Report February 2015 - Headcount Staffing Page 25 of 25