Loading...
HomeMy WebLinkAbout08-2015 Financial ReportPeriod Ending: August 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 James Mueller Brian Pawlowski John Murphy Jennifer Hockenhull Rahman Johnson Cecil Eastman Financial Report August 2015 Page 1 of 25 August 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 61 %. Likewise, the overall collected revenue amount for August 2014 was 61 %. 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 350 (Penalty Fee), has also reached 100% of its budgeted revenue. This is money from AJ Wright for penalties due to the City. Revenue type 367 (donations), has reached 100% as well. This is money ($330,000) donated by the University of Notre Dame, as part of its ten year pledge that will expire in 2018. Revenue by Fund As of August 31, 2015, the general fund has received 58% of its budgeted revenue, compared to 59% last year. The following funds have reached slightly above the normal percentage of their 2015 budgeted revenue amount at this time: - Funds 249 (PS LOIT), 404 (COIT), and 408 (EDIT) did not receive their distributions on time this month. The money for these funds will be received in September, per County representative. -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 99% 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 100% of its budgeted revenue. This is due to a transfer of $256,085 from fund 641 (Sewage Works Operations) for reserve purposes.Works Operations) for reserve purposes. -Fund 661 (2012 Sewer Bond), is at 175% or $30,138 over its budgeted revenue. This is revenue from bank and investment interest. Property Taxes Property taxes are received in June and December. Property taxes collected in June 2015 totaled -$39.6 million. Civil city funds received -$25.5 million and TIF funds received - $14.1 million. For 2015, the projected levy collection rate is 95% or $71.1 million. Please note, 2015 Civil City funds are $273,000 more than 2014 budget and TIF funds are -$1.3 million less than 2014 budget. Total property taxes collected for the year 2014 was - $72 million or 94.88 %. Specifically, in 2014 the City of South Bend received a total of $45,002,931 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 $27,031,090 in property tax revenue. Expenditures As of August 2015, the City has spent 50% of budgeted expenditures, compared to 45% of budgeted expenditures in August 2014. The General Fund has spent 66% of its 2015 budgeted expenditures, versus 64% in 2014. The following funds have reached 70% 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 August 2015, several debt service payments were made in the amount of - $5.16 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. Headcount The Full Time Headcount as of August 2015 was 1,071 vs. a budgeted amount of 1,094. Currently, there are a total of 23 vacant positions. The 23 open positions are in the following departments: Public Safety (8), Public Works (9), Code Enforcement / Animal Control (1), and General Government (5). * In Public Safety (Fire), the headcount was over budget in prior months, as there were currently three recruits in training to replace planned and unplanned departures. Currently, the actual headcount matches the budgeted headcount. If you have any questions regarding this report, please contact John Murphy at (574) 235 -7678. Financial Report August 2015 Page 2 of 25 City of South Bend Period Ending: August 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 1,549,713 1,549,713 311 Property Tax Civil City various various 465,648 226 465,648 25,564,735 tel Motel Tax Century Center 25,564,735 45,606,508 56% 311 Property Tax TIF Districts various tel Motel Tax Century Center 324 292,000 340 14,121,026 490,500 14,121,026 24,514,604 58% Sub Total _ _ _ _ _ tel Motel Tax Cum Cap Impm 407 453,318 39,685,761 150,000 39,685,761 70,121,112 57% Income Tax 806,725 3,770,811 5,346,126 ntractual Service 211 _ _ _ _ _ _ _ _ _ NA 315 Econ Development Income Tax 408 765,101 765,101 1,463,758 748,490 748,490 748,490 5,239,428 8,981,877 58% 316 Local Option Income Tax -PS 249 538,849 538,849 1,077,698 538,849 538,849 538,849 3,771,944 6,466,190 58% 316 County Option Income Tax 404 738,326 738,326 1,476,652 738,326 738,326 738,326 5,168,282 8,859,912 58% Sub Total 101 2,042,276 2,042,276 4,018,108 2,025,665 2,025,665 2,025,665 14,179,654 24,307,979 58% ;ounty (Remitted by) ,to Excise Tax various 1,549,713 1,549,713 2,508,752 mmercial Vehicle Tax various 465,648 226 465,648 883,438 tel Motel Tax Century Center 670 656,725 656,725 1,313,450 1,313,436 tel Motel Tax Century Center 324 292,000 340 292,000 490,500 tel Motel Tax Century Center 420 _ _ _ _ _ _ _ _ _ _ _ _ _ _ tel Motel Tax Cum Cap Impm 407 453,318 150,000 150,000 150,000 b Total 50% 656,725 292,000 2,015,361 806,725 3,770,811 5,346,126 State of Indiana Remitted b 312 CRED Tax 434 299 1,729 226 31,642 12, 460 17,914 104,502 150 0% 335 Cigarette Tax 1011407 vte Drug 216 67% 340 149,739 1011289 149,739 317,818 47% 335 State Pension Subsidy 7011702 35,000 yment in Lieu of Tax various 453,318 5,705,692 453,318 5,705,692 11,411,384 50% 335 CTP Distribution 439 3,626,544 5,439,810 ntractual Service 211 _ _ _ _ _ _ _ _ _ NA 335 Gaming Proceeds 101 62,757 225,706 243,000 nds various 52,953 53,072 600,000 0% 335 Gasoline Tax 2021251 348,926 369,636 422,676 426,523 435,833 373,229 381,514 467,969 3,226,306 4,692,000 69% 335 Liquor Excise tax 101 41,349 475,412 516,075 3,930,308 5,792,810 23,001 64,350 65,000 99% 335 Liquor Gallonage Tax 101 67,259 330,089 30,798 304,027 2,886,320 60,184 158,241 200,000 79% 335 ProfSports Development Tax 377 63,326 142,874 63,470 35,855 29,251 42,734 102,397 479,907 747,750 64% 335 Wheel Tax 202 418,779 67,941 392,533 215,701 303,580 529,741 1,624,695 2,050,000 79% Sub Total 2,428,637 939,639 512,510 554,087 885,709 680,785 6,271,395 567,096 997,710 11,408,931 20,084,102 57% governmental Sources deral Drug 299 1,729 226 31,642 12, 460 17,914 104,502 99,293 104,502 63,744 75,000 vte Drug 216 67% 340 810 1011289 13,504 50 14,314 35,000 yment in Lieu of Tax various 453,318 453,318 453,318 453,318 453,318 453,318 453,318 453,318 3,626,544 5,439,810 ntractual Service 211 13,183 11,261 14,750 69,400 8,480 37,285 8,590 62,757 225,706 243,000 nds various 52,953 53,072 51,034 54,087 425,398 798,302 53% 380 Central Service 222 b Total 201,656 468,230 464,579 500,519 535,178 479,712 490,603 475,412 516,075 3,930,308 5,792,810 Charge for Service Internal City 340 Liability Insurance 226 99,293 101,897 101,897 104,502 99,293 104,502 99,293 104,502 815,178 1,222,727 67% 340 General Government Misc Ch s 1011289 50 280 330 6,000 6% 340 Police Take Home Vehicle 278 7,060 4,680 4,670 4,640 4,590 4,560 6,770 4,510 41,480 61,100 68% 349 Central Service 222 51,890 62,282 48,246 51,834 52,953 53,072 51,034 54,087 425,398 798,302 53% 380 Central Service 222 199,523 201,656 208,098 203,681 214,579 195,611 183,083 189,840 1,596,070 2,800,655 57% 380 Energy Office Reimbursements 222 383,538 417,794 450,403 363,667 331,109 330,089 305,693 304,027 2,886,320 4,471,200 65% 380 Internal Service Reimbursement various 114,099 125,201 140,744 220,036 141,034 112,567 223,242 157,237 1,234,159 3,050,556 40% 392 Administration Fee 101 303,580 303,580 303,580 303,580 303,580 303,580 303,580 303,580 2,428,637 3,642,953 67% 392 Internal Fund Transfers various 966,983 3,518,478 7,340,433 1,062,256 6,327,336 1,021,220 2,472,104 4,957,261 27,666,071 34,300,476 812L 395 Employee Benefits 711 1,234,237 1,233,503 1,224,809 1,216,576 1,207,904 1,203,674 1,202,201 1,196,319 9,719,222 16,427,996 59% Financial Report August 2015 - Revenue Report Page 3 025 City of South Bend Period Ending: August 31, 2015 Revenue by Type Report S Fund % Reci lent Jan Feb Mar Apr May Jun Jul Au I Sep Oct Nov I Dec I Year I Budget I of Bud et ntral Service Refunds 222 2,968 1,971 1,970 1,742 1,618 2,965 13,234 22,000 If Funded Employee Benefits 711 13,173 13,173 13,200 b Total 3,373,375 5,972,039 9,824,850 3,532,789 8,684,121 3,330,492 4,846,999 7,274,607 46,839,271 66,817,165 avenue I EMS Service 288 11,080 4,675 39,099 808 4,069 59,730 150,000 imorial Hospital Neo Natal 101 10,022 56,678 36,788 10,545 10,231 2,280 70 182 126,795 125,000 b Target Penalty Fee 408 1,100 354,660 79% 354,660 354,660 ble TV Franchise Fees 101 177,167 183,970 187,183 548,321 700,000 ' &T Franchise Fees 101 69,037 69,608 73,131 211,775 276,000 b Total 5,793 10,022 302,882 47,868 15,220 657,567 3,088 4,138 260,497 1,301,281 1,605,660 deral Grants various 321,650 121,681 172,179 326,005 247,506 251,238 133,560 331,798 1,905,618 7,317,445 lar Energy Grant 222 29,167 29,167 ite Grants various 400,000 400,000 3,600,000 b Total 321,650 121,681 172,179 326,005 247,506 251,238 562,727 331,798 2,334,785 10,917,445 Fees for Services External 320 Inspections Central Service 222 330 490 10 230 40 1,100 1,400 79% 321 Business License 1011222 31,966 22,740 20,630 13,394 8,091 4,182 1,652 2,233 104,887 126,490 83% 321 Code and Animal Fees 600 3,725 4,795 5,793 6,503 3,595 5,346 4,447 5,073 39,277 75,200 52% 322 Building Fees 600 65,509 54,764 181,309 96,256 225,069 113,669 160,693 95,673 992,940 1,083,832 92% 322 Code Enforcement Fees 600 150 450 1,500 500 50 1,000 1,645 700 5,995 2,800 214% 322 EMS Operating Fund 288 2,233 2,460 1,295 2,375 2,046 2,074 2,237 1,689 16,409 25,000 66% 322 General Government Fees 101 6,640 725 1,030 2,430 2,115 1,605 2,030 5,620 22,195 13,000 171% 341 General Government Various various 1,736 1,940 1,164 1,602 4,952 2,701 1,448 1,331 16,874 33,405 51% 342 Highway &Streets 1011202 24,377 9,564 2,090 80,755 25,490 24,156 166,433 390,000 43% 342 Public Safety various 22,350 26,067 13,071 12,281 10,209 9,641 12,027 10,652 116,298 134,500 86% 342 EMS - Count Fees 288 426,728 142,243 142,243 142,243 142,243 142,243 1,137,940 1,667,565 68% 342 EMS - Capital Fund 287 396,727 396,727 Z872,739 14% 342 EMS - Operating Fund 288 198,675 156,466 226,551 290,112 249,516 246,378 195,180 256,326 1,819,204 2,902,500 63% 342 EMS - Neo Natal 288 74,340 40,500 23,695 138,535 385,000 36% 344 Solid Waste 610 401,357 397,131 400,073 405,112 406,770 408,056 407,018 407,657 3,233,174 5,091,168 64% 344 Code Environmental Clean Up 101 1600 11,215 1,263 1,051 27,629 4,609 11,674 3,439 6,390 67,271 54,000 125% 344 Sewage Waste Water 641 2,776,091 2,783,483 2,821,111 2,926,251 2,971,386 2,975,155 3,138,427 3,139,072 23,530,975 35,234,467 67% 344 Sewer Repair Insurance 640 50,523 52,458 49,781 51,388 49,827 50,237 50,310 48,917 403,441 551,200 73% 344 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 80,717 80,647 80,683 637,367 960,000 66% 346 Water Works Utility 620 979,733 976,299 965,088 992,620 1,024,608 1,263,334 1,083,848 1,429,783 8,715,313 13,678,403 64% 346 Solid Waste Misc 610 5,075 4,623 6,710 97,941 7,710 8,274 4,328 4,115 138,775 128,148 108% 346 Project ReLeaf 655 36,473 36,203 36,396 36,456 36,590 36,613 36,605 36,590 291,927 429,000 68% 347 Parks& Recreation various 88,374 165,687 152,152 218,148 248,263 326,282 439,665 468,053 2,106,624 3,565,625 59% 347 Blackthorn Golf Club 619 99,156 20,083 0 59 119,297 119,799 100% 347 Morris PAC 416 7,870 1,419 9,761 3,266 8,253 2,522 4,602 37,693 100,000 38% 349 Parking Garage Fees 601 77,130 56,458 83,412 67,492 90,594 81,037 75,732 76,940 608,795 908,675 67% 349 Code Demolition Board Up 1011600 2,932 9,994 467 12,513 11,595 22,467 22,601 82,568 39,000 212% 349 Parking Century Center 670 8,435 17,329 24,852 7,896 7,058 10,405 3,115 4,015 83,105 103,297 80% 349 Parking SBCDA 3241420 2,950 2,981 4,246 3,885 14,061 18,000 78% 351 Fines &Fees various 21,684 35,187 12,331 11,314 27,382 12,826 233,090 14,834 368,648 484,020 76% 352 Forfeits various 3,455 875 2,775 4,570 2,352 19,150 5,508 8,289 46,974 258,820 18% 354 Ordinance Violation various 1,305 2,165 4,133 2,313 1,662 3,474 1,287 3,323 19,662 42,000 47% 360 Morris PAC various 52,561 22,635 129,679 31,466 52,867 108,722 6,419 19,207 423,555 934,900 45% 360 Palais Royale various 22,259 6,290 10,385 18,475 17,124 14,402 27,895 13,499 130,328 244,270 53% 360 Parks& Recreation various 26,797 14,565 4,051 10,548 20,675 12,889 4,294 17,376 111,196 106,700 104% 360 Police various 3,170 4,378 2,510 1,609 7,606 4,440 2,373 1,375 27,460 62,100 44% 360 TIF various 5,056 2,657 3,480 3,373 3,284 52,071 4,525 1,218 75,664 44,806 169% 360 Central Services 222 19,705 3,212 15 320 4,646 855 520 588 29,860 37,087 81% 360 Century Center 670 5,117 4,970 35,471 3,054 7,135 324 676 2,608 21,822 15,000 -145% 360 Dept Of Community Investment 2111212 95,353 85,179 2,438 37 53,760 236,767 349,500 68% 360 EMS Operating Fund 288 60 102 38,521 7,398 46,082 5,000 922% 360 Engineering / Curb & Sidewalk 101 209 200 32,648 500 660 785 475 775 29,044 22,000 -132% 360 Fire and Police Pension Fund 7011702 3,743 1,477 1,252 6,473 8,000 81% 360 Self Funded Employee Benefits 711 6,000 6,000 6,000 100% 360 General Government Various 101131226 196 853 1,386 12,290 284 15,009 4,250 353% 360 Motor Vehicle Highway Scrap Meta 202 1,735 1,127 900 3,762 4,000 94% 360 Motor Vehicle Highway Curb Pr gm 202 3,615 324 6,819 4,538 2,992 3,583 5,095 2,580 29,547 50,000 59% 360 Local Roads and Streets 251 14,730 5,644 20,375 22,000 93% 360 ProfessionalSports Development 377 29,523 26,710 56,233 60,661 93% 360 Cumulative Capital Improvement 407 200 0% Financial Report August 2015 - Revenue Report Page 4 025 City of South Bend Period Ending: August 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 UDAG 410 18, 739, 220 15,89Z 928 98,485 143,363 various 34,357 1,472,130 1 10,000 2,554,487 251,849 528,576 48% 360 Code /Animal Control 600 oceeds F.A. Disposal 600 0 0 0 le of Fixed Assets various 0 0 100 0% 360 Parking Garage 601 1,000 3 34,357 1,474,307 473 8,103 16,154 3,195 1,536,588 4 7 NA 360 Solid Waste Fund 610 313 313 2,000 16% 360 Waste Water 6411719 2,142 3,229 998 5,441 14,166 14,343 7,065 47,383 55,200 86% 360 Water Works Utility 620 908 1,318 17 1,382 3,625 39,580 9% 362 Dept Of Community Investment 212 1,847 1,847 1,847 5,540 4,000 139% 362 Palais Royale 101 572 2,269 2,588 10,146 5,182 11,071 4,098 9,241 45,165 72,000 63% 362 Police 101 7,262 7,699 14,961 NA 362 Parks B Recreation 201 2,064 4,531 4,138 4,574 6,162 2,701 2,717 3,215 30,102 40,000 75% 362 S Bend School Corp Fee 407 25,000 0% 362 TIF Property various 15,621 17,156 19,059 30,447 12,509 22,614 11,903 16,104 145,412 339,025 43% 369 Memorial Hosp Leighton Plaza 408 150,000 150,000 150,000 100% 371 Century Center Fees 670 29,668 761,205 442,960 200,587 155,264 258,225 100,767 335,999 1,398,755 2,387,518 59% 399 Bosch Retention Project 210 29,759 29,759 59,966 50% 399 Principal on Loan various 1,799 20,705 18,387 19,002 18,841 36,515 2,067 36,608 153,923 218,398 70% 399 Principal Income xxx 368,031 146,068 418,156 932,255 1,224,390 76% Sub Total 5,476,452 6,558,266 5,412,473 6,162,214 6,036,003 6,561,444 6,413,465 7,236,660 49,856,976 78,601,280 63% ome nk Account Interest various 197,258 51,054 75,698 118,454 65,582 223,194 147,082 55,519 933,842 872,801 b Total 197,258 51,054 75,698 118,454 65,582 223,194 147,082 55,519 933,842 872,801 i Contribution 101 330,000 330,000 330,000 nations various 2,072 990 405 46 3,493 2,131 376 93 9,605 425,356 b Total 2,072 990 405 46 3,493 2,131 330,376 93 339,605 755,356 enervation mpost Program 227 19,750 5,750 750 1,000 500 27,750 30,000 lais 450 1,225 3,703 357 982 1,115 592 1,556 864 10,394 16,000 b Total 1,225 3,703 20,107 6,732 1,865 1,592 2,056 864 38,144 46,000 ets 16, 029, 980 18, 739, 220 15,89Z 928 18, 890, 401 60, 878,117 various 34,357 1,472,130 1 1,506,488 2,554,487 eter Hydrant Reimbursement 620 2,177 472 8,103 16,154 3,195 30,100 20,000 oceeds F.A. Disposal 600 - - 176,155,961 287,855,173 0 0 le of Fixed Assets various 0 0 12,000 hicle Damage Reimbursement various 1,000 b Total 34,357 1,474,307 473 8,103 16,154 3,195 1,536,588 2,587,487 Revenue Total 12, 866, 555 16, 029, 980 18, 739, 220 15,89Z 928 18, 890, 401 60, 878,117 16,184, 938 16, 673, 823 - - - - 176,155,961 287,855,173 61% report 12, 866, 555 16, 029, 980 18, 739, 220 15,89Z 928 18, 890, 401 60, 878,117 16,184, 938 16, 673, 823 - - - - 176,155,961 287,855,173 0 0 0 1 0 0 0 0 0 Financial Report August 2015 - Revenue Report Page 5025 City of South Bend Revenue by Fund Report Period Ending: August 31, 2015 s i Fund Jan I Feb I Mar I Apr I May Jun I Jul I Aug Sep I Oct I Nov I Dec I Year I Bud et I ofeud et General Government 0000 General Revenues 101 1,167,120 944,443 669,668 734,592 944,924 23,042,910 1,117,315 951,306 29,572,277 50,243,482 59% 0101 Mayor 101 35 15 50 20 120 700 17% 0104 311 Call Center 101 55,195 36,290 43,995 32,989 35,855 35,676 48,025 34,895 322,920 486,733 66% 0301 Common Council 101 41 31 15 231 31 31 46 31 456 8,666 5% 0401 Administration and Finance 101 220 336 556 600 93% 0501 Legal 101 508 18,113 3 3 18,626 53,500 35% Sub Total 1,222,390 981,491 714,030 785,924 980,863 23,078,638 1,165,387 986,231 29,914,955 50,793,681 59% Public Works 0602 Engineering 101 225 303 1,104 635 275 625 3,167 77,027 4% Sub Total 225 303 1,104 635 275 625 3,157 77,027 4% Public Safety 0801 Police 101 6,604 11,372 38,367 2,321 20,918 11,729 17,010 43,217 151,539 555,200 27% 0901 Fire 101 10,022 59,625 37,787 11,021 10,231 2,280 4,152 462 135,580 138,300 98% Sub Total 16,625 70,998 76,154 13,343 31,149 14,009 21,162 43,679 287,119 693,500 41% 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 31,841 51,783 109,022 3,527 18,980 420,207 923,000 46% 0405 Palais Royale 101 24,368 9,347 13,572 30,163 23,990 26,667 34,420 23,726 186,253 335,270 56% Sub Total 77,697 3Z647 141,998 62 003 75,773 135,689 37,947 4Z 706 606,460 1,258,270 48% General Fund Revenue Total 1,316,569 1,085,136 931,673 861,573 1,088,889 23,228,972 1,224,771 1,073,241 - - - - 30,810,825 52,822,478 58% Financial Report August 2015. Expenditure Summary Page 6 of 25 City of South Bend Revenue by Fund Report Period Ending: August 31, 2015 a % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Aug Se I Oct I Nov I Dec I Year I Budget I ofBUd et Parks & Recreation 0000 Parks General revenue 201 76,460 74,383 77,445 74,566 73,993 4,547,155 75,491 100,334 5,099,829 8,860,875 58% 1100 Administration 201 2,119 4,537 4,158 4,527 6,168 2,736 2757 3,229 30,232 40,600 74% 1101 Maintenance 201 19,996 2425 3,330 1,823 4,085 2915 99,072 48,521 18Z 166 319,600 57% 1102 GolfOperations 201 161 63,205 31,916 147,893 185,191 234,366 210,016 233,182 1,105,932 1,535,000 72% 1103 Recreation Division 201 26,067 16,036 5,765 54 3,370 19,150 37,653 21,670 129,764 185,640 70% 1104 Potawatomi Zoo 201 NA 1108 Grafd Removal 201 11,341 13,003 7,268 6,941 6,483 45,036 89,000 51% Recreation Non Reverting 203 65,607 98,601 lIZ441 78,613 75,090 82,878 97,148 181,580 791,959 1,578,935 50% East Race Waterway 271 5 1 2 3 2 3 2 1 19 50 37% Coveleski Stadium 401 36 9 14 23 13 43 27 9 174 15,100 1% Zoo Endowment 403 43 11 17 28 15 52 33 11 211 200 106% Park Non Reverting 405 4,435 260 261 1,080 1,573 1,269 918 748 10,544 143,700 7% Sub Total 194,930 270,809 235,349 321,616 356,766 4,890,567 530,060 595,768 7,395,865 12,768,700 58% Public Works Motor Vehicle Highway 202 716,020 1,133,459 404,476 730,770 1,504,136 316,658 328,650 981,221 6,115,390 9,701,800 63% Central Services 222 655,888 688,603 709,665 623,157 619,227 584,294 570,801 55Z 107 5,003,743 8,151,184 61% Central Services Capital 224 271,850 0% Local Roads & Streets 251 87,782 90,155 98,666 112 757 99,309 97,010 97,383 23,823 706,885 1,821,300 39% Pro'ect ReLeaf 655 37,371 36,419 36,757 37,059 36,928 37,776 37,365 36,849 296,525 431,700 69% Sub Total 1,497,062 1 948 636 1,249,565 1 503 744 Z259,601 601 1 035 738 1,034,198 1 594 000 12 122,544 20 377,834 59% Public Works Solid Waste Solid Waste Operations 610 408,178 401,846 406,879 589,225 414,603 416,858 492 885 412 143 3,542,617 5 712 289 62% Solid Waste Capital 611 190,033 10,001 84,001 17 46,000 189,015 11,018 530,085 753,011 70% Sub Total 598,211 401,846 416,880 673,226 414,621 46Z858 681,900 423,160 4,072,703 6,465,300 63% Public Works Water Utility 0000 Water Works Revenues 620 916,194 910,250 905,299 929,577 96Z334 1,179,467 1 007 966 1,280,225 8 091,311 12 724,463 64% 0630 Water Leak Insurance 620 80,558 79,817 80,181 74,113 80,653 80,717 80,647 80,683 637,367 960,000 66% 0660 Clay Water 620 68,898 68,829 66,186 76,543 74,475 111,884 87,990 15Z275 707,080 1,096,020 65% Waterworks Capital 622 Z 776 682 1,098 1,741 946 3,225 Z006 655 13 129 10,000 131% Waterworks Construction 623 180 41 62 83 41 137 544 545 100% Waterworks Deposit 624 1,307 324 527 854 463 1,582 1,001 334 6,390 6,000 107% Waterworks Sinking 625 468 340,551 170,359 170,557 170,477 171,158 171,165 170,453 1,365,188 2,050,078 67% Waterworks Bond Reserve 626 1,425 353 572 1,078 359 3,788 9,500 40% Waterworks Debt Reserve 629 1,840 150,683 775 1,279 695 2367 1,499 499 159,635 16Z 749 98% Sub Total 1,073,645 1,551,529 1,225,058 1,254,745 1,290,083 1,550,537 1,353,351 1,685,484 10,984,432 17,019,355 65% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 51,853 52,790 50,328 52,269 50,308 51,875 51,350 49,270 410,042 554,800 74% 0000 Wastewater Revenues 641 2,628,692 2,622,801 2,675,830 2,753,646 2,798,663 2,811,021 2,962,474 2,957,091 22,210,218 33,201,605 67% 0621 Sewer Department 641 998 530 1,039 2567 2,000 128% 0625 Concrete Crew 641 4,705 10,805 16,966 IZ672 10,912 56,059 75,000 75% 0630 Wastewater Operations 641 NA 0631 Organic Resources 641 NA 0650 Clay Sewage 641 157,337 162,329 150,270 180,708 171,223 173,367 184,685 181,164 1,361,084 2,059,962 66% Sewage Ca ital 642 3,385 815 1,313 2036 4,001,015 6,750 4,451 4,001,402 8,021,165 5,398,000 149% Sewage Reserve 643 3,020 256,833 1,248 2,104 1,143 3,895 2466 821 271,531 271,612 100% Sewer Bond 2007 647 NA Sewage Bond Sinking 649 774,321 773,801 774,198 775,158 774,671 778,095 776,235 774,495 6,200,976 9,288,088 67% 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 460 175 550 347 115 3,840 6,000 64% 2012 Sewer Bond 661 14,968 3,669 5,897 9,437 5,061 17,033 10,588 3,483 70,138 40,000 175% 2013A Sewer Refund Bonds 664 4 1 2 3 1 5 3 1 19 50 39% Sub Total 3,635,057 3,878,074 3,659,472 3,776,819 7,813,066 3,860,087 4,006,311 7,978,754 38,607,639 50,897,117 76% Financial Report August 2015. Expenditure Summary Page 7 of 25 City of South Bend Revenue by Fund Report Period Ending: August 31, 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 30 (30) 909 4,050 22% Police Seizures 216 162 41 876 108 59 200 13,631 43 15,119 36,050 42% Curfew Violations 218 11 3 17 7 4 38 21 40 139 1,025 14% Law Enforcement Education 220 24,859 28,459 17,376 64,238 18,300 17,495 20,976 18,422 210,124 270,000 78% Public Safety LOIT 249 540,008 539,058 430 1,078,221 539,072 539,985 539,392 187 3,776,353 6,472,240 58% Excess Welfare Public Safety 252 0 - - - - 280 - - 0 15.900 NA Police Take Home Vehicle 278 14,575 9,474 9,529 9,591 9,352 9,718 13,925 9,150 85,315 124,200 69% Police Block Grant 280 3 1 1 2 1 4 3 1 16 NA Police Grants 292 55 56,891 56,947 90,000 63% Police cademy 294 11,010 7,628 1,101 893 21 68 43 14 20,778 22,700 92% COPS More Grants 295 564 782 681 33,633 619 832 807 2,367 40,283 150,258 27% Drua Enforcement 299 1,817 83 31,713 12,542 18,004 98 95 89 64,440 77,000 84% K -9 Unit 705 503 1 1 2 1 1,003 3 1 1,514 2,000 76% Sub Total 593,567 585,530 61,724 1,256,127 585,433 569,440 588,894 30,314 4,271,029 7,245,473 595, Publie Safe - Fire Emerge' Telephone System 244 19 19 20 97% ital 287 396,727 13 206 112 383 242 81 397,765 3,623,089 11% erafin Fund 288 204,337 16 9,122 667,161 441,484 434,559 508,444 386,909 432,486 3,244,503 5,679,065 57% 289 3 732 10 095 10 18 f0 34 21 7 13 928 14 100 99% scue 291 3,093 Z423 3,038 651 12 628 694 8,455 17 31,000 45,350 68% Sub Total 211,182 578,368 670,222 44Z360 447,309 509,554 395,628 43Z591 3,687,215 9,361, 624 39% Department of mmunity Investment Studebaker /Oliver 209 959 3,612 16,720 20,676 15,140 16,755 9,340 7,555 90,757 644,000 14% State Grant 210 290 70 112 181 93 36,192 400,000 35 436,974 3,673,510 12% DC/ Operating 211 14,699 503,257 17,090 72,469 500,684 38,606 9,332 6Z959 1,219,096 Z 634,425 46% 0000 Dept of Community Investment 212 3,790 12Z 753 240,619 202 172 106,570 83,119 85,649 373,186 1,217,859 5,890,000 21% xxx Programs 212 95,353 124,819 154,530 2 168 376,870 NA 0000 Economic Revenue Bond 281 24 6 10 16 8 29 18 6 117 300 39% Sub Total 115,115 629,699 274,551 295,513 747,314 329,231 504,340 445,910 3,341,673 12 842,235 26% 0000 Parking Garage Revenue 601 909 30 (30) 909 4,050 22% 0460 Main Street 601 20,879 17,180 24,111 20,473 21,925 20,694 18,076 18,140 161,478 267,737 60% 0462 Leighton Plaza 601 38,528 22,329 36,745 34,605 44,243 40,602 44,536 33,837 295,425 417,088 71% 0463 Enforcement 601 5,219 7,017 6,595 8,281 7,416 10,105 7,428 8,029 60,089 117,400 51% 0464 Wayne Street 601 17,498 16,724 22,424 12,234 24,291 19,471 13,079 24,198 149,919 222,950 67% 0465 Eddv Street Commons 601 - - - - - 280 - - 280 15.900 2% Financial Report August 2015. &p-dk- Summary Page 8 of 25 City of South Bend Revenue by Fund Report Period Ending: August 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 Other Miscellaneous Rain Da 102 7,630 1,888 3,064 4,949 2,689 9,170 5,809 1,936 37,136 34,680 107% Excess Le 103 1 1 2 1 4 2 1 12 20 62% Gift Donation Bequest 217 1,618 989 364 80 195 174 370 76 3,867 398,800 1% Loss Recovery 227 5,206 4,007 21,727 8,608 2,128 5,168 2,938 790 50,572 50,000 84% Human Rights 258 2,065 7,188 5,759 3,628 6,425 699 41,861 5,098 72,722 209,950 35% Morris Palais Marketing 273 274 6 1,373 366 1,258 428 3,164 256 7,124 18,000 40% Professional Sports Development 377 93,375 142,965 63,547 36,086 29,386 43,242 129,447 83 538,133 809,511 66% 1201 Code Enforcement 600 18,559 529,948 11,282 46,664 24,464 56,078 1,050,947 18,564 1,756,505 2,417,446 73% 1207 Animal Control 600 3,725 162,197 5,846 6,503 3,595 5,346 319,201 5,118 511,530 704,768 73% 1306 Building Operations 600 66,158 54,907 181,599 96,899 225,373 125,219 163,847 97,271 1,011,273 1,086,999 93% Century Center 670 32,985 783,504 203,146 211,537 169,457 268,954 761,283 342,621 2,773,488 3,819,251 73% Century Center Capital 671 24 21 23 22 74 106 95 366 500 73% Century Center Energy Saying 672 50,000 7 4 50,011 50,000 100% Sub Total 231,619 1,687,621 497,732 415,343 515,044 514,596 2,478,970 471,813 6,812,738 9,609,925 71% Business Insurance 0000 Business Insurance Revenues 226 104,344 103,108 103,815 107,554 100,942 112,231 102,631 105,519 840,144 1,245,602 57% 0418 Workers Compensation 226 17,000 0% Sub Total 104,344 103,108 103,815 107,554 100,942 112 231 102 631 105,519 840,144 1,262,602 67% Fiducia Trust & Agency Fire Pension 701 688 130 54 3,743 2 518 013 1,415 1,364 2 525,407 5,044,525 50% Police Pension 702 1,133 230 184 3,187,679 62 237 3189,525 6385,359 50% Employee Benefits lCi 711 1,248,718 1 226 227 1,217,884 1 210 699 1,200,922 1 200 207 1,197,000 1 189 005 9,690,662 16 357, 770 59% Unemployment Comp 713 8,685 8,526 8,559 8,613 8,549 8,731 8,634 8,528 68,824 113,796 60% Cemetery Trust 730 25 6 10 16 9 30 19 6 122 150 81% Sub Total 1,259,249 1 235 119 1,226,689 1 223 071 1,209,480 6 914 660 1,207,131 1 199 140 15 474,540 27 901, 600 55% Civil City Revenues 12,653,540 15,953,113 10,816,094 15,511,366 18,836,330 46,560,441 15,913,717 16,602,196 - - - - 152,846,795 252,729,196 60% Tax Increment Financing TIF Airport 324 50,350 33,228 6,479,376 346,205 37,081 9,550,306 29,064 59,315 16,584,926 24,944,246 66% TIF Central Development 420 695 4,240 (4,935) NA TIF West Washington 422 996 261 423 675 364 197,102 849 305 200,975 422,800 48% TIF Leighton Plaza 425 18,229 12,971 10,040 21,366 8,977 15,860 13,156 6,162 106,760 189,423 56% TIF Medical Service 426 1,941 501 (2,442) 0 NA TIF Northeast 429 23,215 993 1,434,000 2,685 1,830 1,397,241 4,408 1,623 2,865,995 3,829,653 75% TIF Southside 430 4,144 1,025 1,590 2,545 1,371 1,303,629 3,377 1,264 1,318,944 2,410,750 55% TIF Erskine Village 432 5,246 1,268 1,967 3,083 1,675 17,202 3,622 1,204 35,268 25,000 141% TIF Douglas Road 435 161 48 23 30 16 163,999 346 48 164,671 320,750 51% Northeast Residential TIF 436 1,215 352 5 1,663,572 210,999 1,876,143 2,815,000 67% Sub Total 106,191 54,887 7,920,047 376,589 51,315 14,308,913 265,821 69,920 23,153,682 34,957,622 66% Financial Report August 2015. &p-dk- Summary Page 9 of 25 City of South Bend Revenue by Fund Report Period Ending: August 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 ud et I ofBUd et Redevelopment Commission 213,015 76,867 7,923,126 381,562 54,071 14,317,676 271,221 71,627 - - - - 23,309,166 35,125,877 66% City Operations Total 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 16,184,938 16,673,823 - - - - 176,155,961 287,855,173 61% Revenue report 12,866,555 16,029,980 18,739,220 15,892,928 18,890,401 60,878,117 16,184,938 16,673,823 0 0 0 0 176,155,961 287,855,173 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report August 2015. Expenditure Summary Page 10 of 25 City of South Bend Property Tax Revenue 2014 Tax Pay 2015 Fund Period Ending: August 31, 2015 Fund # Levy Estimated Distribution 1 Distribution 2 Distribution 3 Levy Per County Collection Projected 61812015 611612015 Total Property Tax Collection Records Factor Collections Collections Collections Collections Collections Receivable Rate Citv Airport TIF District General Fund 101 38,619,247.00 0.95 36,688,284.65 13,463,468.56 7,216,350.23 20,679,818.79 17,939,428.21 53.55% Parks & Recreation 201 7,742,127.00 0.95 7,355,020.65 2,699,065.71 1,446,685.42 4,145,751.13 3,596,375.87 53.55% College Football Hall of Fame 313 937,076.00 0.95 890,222.20 - 501,784.88 501,784.88 435,291.12 53.55% Cumulative Capital District 406 443,304.00 0.95 421,138.80 154,544.81 82,835.23 237,380.04 205,923.96 53.55% Fire Pension 701 - 0.95 - - - - - - Police Pension 702 51.87% 0.95 431 - 0.95 - - - Total - City - 47,741,754.00 432 45,354,666.30 16,317,079.08 9,247,655.76 25,564,734.84 22,177,019.16 53.55% Tax Increment Financinq Airport TIF District 324 17,709,737.84 0.95 16,824,250.95 9,396,167.91 9,396,167.91 8,313,569.93 53.06% South Bend Central TIF District 420 - 0.95 - - - - - West Washington TIF District 422 512,917.39 0.95 487,271.52 195,865.56 195,865.56 317,051.83 38.19% Central Medical TIF District 426 - 0.95 - - - - - NortheastResidentialTIFDistrict 436 3,273,328.42 0.95 3,109,662.00 1,663,572.10 1,663,572.10 1,609,756.32 50.82% Southside TIF District # 1 430 2,504,494.11 0.95 2,379,269.40 1,298,974.33 1,298,974.33 1,205,519.78 51.87% Erskine Commons TIF District #2 431 - 0.95 - - - - - Erskine Village TIF District #3 432 19,182.73 0.95 18,223.59 11,490.26 11,490.26 7,692.47 100.00% Douglas Road TIF District 435 327,887.96 0.95 311,493.56 163,943.98 163,943.98 163,943.98 50.00% Northeast TIF 429 2,743,819.42 0.95 2,606,628.45 1,391,012.32 1,391,012.32 1,352,807.10 50.70% Airport Urban Enterprise Zone 454 0.95 - Other xxx - Total - Tax Increment Financing 27,091,367.87 25,736,799.48 14,121,026.46 14,121,026.46 12,970,341.41 52.12% Grand Total 74,833,121.87 71,091,465.78 16,317,079.08 23,368,682.22 - 39,685,761.30 35,147,360.57 53.03% Note(s) 1 Distribution 1 - Issued by St. Joseph County on 618115 2 Distribution 2 - Issued by St. Joseph County on 6116115 Financial Report August 2015 - Property Tax Revenue Page 11 of 25 City of South Bend Property Tax Revenue 2013 Tax Pay 2014 Fund Period Ending: August 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 August 2015 - Property Tax Revenue Page 12 of 25 City of South Bend Period Ending: August 31, 2015 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au Sap 1 Oct 1 Nov I Dec I Year I Budget of Bud et vemment ryor 101 80,464 52,550 48,452 55,723 53,138 57,124 79,991 61,928 489,370 741,267 1 Call Center 101 55,195 36,290 43,995 32,989 35,855 35,676 48,025 34,895 322,920 486,733 erk 101 34,775 28,270 26,114 26,345 27,469 28,359 37,398 27,161 235,891 431,573 ommon Council 101 33,803 24,869 110,974 30,970 47,806 24,460 26,243 25,524 324,649 490,150 NIT Contract 101 411 43,000 (411) 11,354 13,015 43,000 43,000 Iministration and Finance 101 187,531 134,271 139,736 136,435 154,038 136,652 198,795 124,777 1,212,235 2,020,544 gal Department 101 99,178 73,129 64,725 70,589 73,432 71,133 95,236 70,736 618,158 1,006,979 ib Total 490,946 349,379 433,994 353,052 434,738 353,404 485,688 345,022 3,246,224 5,220,246 cs igineering 101 72,931 79,671 89,919 62,192 67,688 70,000 137,148 71,996 651,545 1,058,933 ib Total 72,931 79,671 89,919 62,192 67,688 70,000 137,148 71,996 651,545 1,058,933 ty dice 101 2,557,412 1,878,728 1,990,424 1,850,902 1,869,819 1,977,962 2,485,297 1,806,971 16,417,516 25,633,064 slice -PS LOIT funded 101 2,562 6,199 (8,761) (212) 6,911 6,699 Mice Communications 101 135,031 97 8 514,528 128,638 128,638 8 257,268 1,164,214 1,687,540 •e 101 2,150,469 1,590,349 1,505,644 1,328,213 1,314,720 1,472,585 1,998,183 1,335,121 12, 695,283 17,774,474 v-PS LOIT funded 101 411 (411) 11,354 13,015 24,369 x ib Total 4,845,886 3,475,373 3,487,315 3,693,643 3,313,177 3,578,773 4,494,629 3,419,286 30,308,081 45,095,078 cement ode 101 (710) 710 2,270 ode Unsafe Building 101 ode Animal Control 101 ib Total (710) 710 2,270 Ire nris PAC 101 96,838 87,590 80,670 75,338 75,072 81,843 94,489 84,313 676,152 1,093,132 dais Royale 101 41,912 31,105 39,827 31,888 34,119 37,926 45,965 36,263 299,006 536,293 ib Total 138,749 118,696 120,497 107,226 109,192 119,769 140,454 120,576 975,158 1,629,425 WS iman Rights 101 50,323 31,896 19,693 30,347 27,284 23,670 37,717 26,959 247,889 373,179 ib Total 50,323 31,896 19,693 30,347 27,284 23,670 37,717 26,959 247,889 373,179 General Fund Expenditure Total 5,598,836 4,055,015 4,151,418 4,246,460 3,951,368 4,145,615 5,296,345 3,983,839 - - - - 35,428,897 53,379,131 66% Financial Report August 2015. &p-dk- Summary Page 13 of 25 City of South Bend Period Ending: August 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au Sap I Oct I Nov I Dec I Year I Budget of Bud et Parks & Recreation Motor Vehicle Highay 1100 Administration 201 104,226 71,673 67,013 81,921 79,879 83,369 98,496 72,911 659,489 967,568 68% 1101 Maintenance 201 435,157 348,338 455,082 344,569 398,104 448,976 525,758 426,831 3,382,815 5,178,905 65% 1102 GolfOperations 201 66,821 76,812 203,778 123,539 118,983 170,789 179,333 132,921 1,072,975 1,573,436 68% 1103 Recreation Division 201 193,339 143,079 147,938 140,851 152,356 160,490 313,935 224,088 1,476,077 2,328,698 63% 1104 Potawatomi Zoo 201 392,247 lIZ389 8,788 7,968 5,262 354,274 6,760 4,890 892,576 863,017 103% 1106 Potawatomi Greenhouse 201 5,079 20,391 5,260 3,156 2005 1,101 821 910 38,724 53,997 72% 1108 Graffiti Removal 201 9,057 7,116 5,887 7,268 6,941 6,483 9,103 9,239 61,094 98,374 62% Recreation Non Reverting 203 43,898 60,957 66,785 87,752 84,777 111,498 117,396 157,046 730,109 1,549,469 47% East Race Waterway 271 637 455 775 2098 695 2367 1,499 1,900 3,998 4,000 100% Coveleski Stadium 401 968,839 1,479,202 1,183,962 1,068,758 1,276,167 1,860,194 1,298,741 1,220,665 10,356,529 3,540 0% Zoo Endowment 403 2 2 49,000 0% Park Non Reverting 405 2,197 19,422 11,316 25,023 7,278 65,236 192,933 34% Sub Total 659 1,249,824 840,754 960,531 801,319 867,731 1,348,296 1,276,625 1,038,013 8,383,093 12,862,937 65% Vorks Motor Vehicle Highay 202 734,565 950,683 835,051 410,155 418,569 407,917 675,925 410,851 4,843,716 8,843,890 Curb and Sidewalk 202 lIZ714 39,990 31,802 29,933 21,753 32,125 60,560 56,355 385,232 1,641,496 Central Services 222 679,565 621,835 691,937 716,505 537,157 556,899 601,324 548,951 4,954,172 8,300 242 Central Services Capital 224 4,000 17% Waterworks Capital 622 15,382 67,463 3,489 1,776,763 5,782,494 271,850 Local Roads & Streets 251 4,155 4,853 37,032 6,650 109,145 87,781 97,882 210,035 557,533 2 126,221 Project ReLeaf 655 15,357 2281 2386 27,010 2442 2899 14,293 2,796 69,464 528,358 Sub Total 1,582 1,546,355 1,619,642 1,598,209 1,190,253 1,089,066 1,087,621 1,449,984 1,228,989 10,810,118 21,712,057 Vorks Solid Waste Solid Waste Operations 610 635,488 341,051 339,903 382,803 461,210 482,019 641,738 428,284 3,712,497 5,873,863 Solid Waste Capital 611 223,749 143 11,054 83,702 168 45,686 189,188 (121) 553,569 752,811 Sub Total 859,237 341,194 350,957 466,506 461,378 527,706 830,925 428,164 4,266,066 6,626,674 Public Works Water Utility 0630 Water Leak Insurance 620 33,830 53,166 43,413 474 131,182 93,577 95,796 144,610 596,049 1,115,000 539/ 0640 Water Works 620 906,773 1,320,043 1,131,090 1,058,030 1,143,612 1,164,702 1,166,484 1,074,463 8,965,197 14,725,471 61% 0660 Clay Water 620 22 29,608 309 26 13 9 113 182 675 4,000 17% Waterworks Capital 622 15,382 67,463 3,489 1,776,763 5,782,494 109,780 25,331 5,849,027 221,445 838,893 26% Waterworks Construction 623 11,278 37,750 4,276 438 85,097 121,821 7,519 74,710 183,082 53,330 343% Waterworks Deposit 624 452 324 527 854 463 1,582 1,001 334 5,536 6,000 92% Waterworks Sinking 625 465 1 84 282 202 366,356 999 578 368,968 2,050,078 18% Waterworks Bond Reserve 626 1,045 747 1,248 7,374 1,143 3,895 2466 821 7,374 14,500 51% Waterworks Debt Reserve 629 637 455 775 1,279 695 2367 1,499 499 8,204 8,500 97% Sub Total 649 968,839 1,479,202 1,183,962 1,068,758 1,276,167 1,860,194 1,298,741 1,220,665 10,356,529 18,815,772 55% Public Works Wastewater Sewage 0620 Sewer Repair Insurance 640 21,449 57,144 43,434 46,092 55,529 30,576 20,211 44,704 319,139 545,703 58% 0621 Sewer Repair 641 446,632 360,251 404,056 284,993 308,945 341,348 427,059 281,841 2,855,125 7,201,049 40% 0625 Concrete Crew 641 44,148 29,608 25,634 23,472 31,229 31,724 33,245 27,715 246,777 450,450 55% 0630 Wastewater Operations 641 2,004,256 2,110,111 1,803,497 1,776,763 5,782,494 1,787,251 2,014,017 5,849,027 23,127,415 31,017,413 75% 0631 Organic Resources 641 69,307 56,543 60,055 54,333 85,097 80,559 53,251 74,710 533,855 1,527,562 35% 0650 Clay Sewage 641 28 103 106 113 5 257 146 747 500 149% Sewage Ca ital 642 39,115 47,104 402228 2254 281,988 588,063 217,648 430,722 2,009,123 7,071,710 28% Sewage Reserve 643 1,045 747 1,248 2,104 1,143 3,895 2466 821 13,470 15,000 90% Sewer Bond 2007 647 0 0 NA Sewage Bond Sinking 649 1,000 850 301,269 1,288,842 350 350 1,592,661 9,282,109 17% Sewage Bond 2007 651 2 2 NA 2010 CSO Net Sewer Bond 658 2 2 NA 2011 Sewer Bond 659 143,037 50Z 799 246,856 184,257 8,408 251 1,085,608 3,711,838 29% 2012 Sewer Bond 661 39,170 249,076 234,187 81,154 302,659 245,591 201,706 398,397 1,751,939 16,624,275 11% 2013 Sewer Bond 663 NA Sub Total 2,809,188 3,414,232 3,221,297 2,455,529 7,158,873 4,397,844 2,970,215 7,108,684 33,535,863 77,447,609 43% Financial Report August 2015. &p -dkure Summary Page 14 of 25 City of South Bend Period Ending: August 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 OOlice EMS Ca ital 287 35,728 23,659 59,387 Seizures 216 288 247,977 32,280 210,228 382,360 383,042 402,139 721,466 483,130 2,862,622 6,855,366 Hazmat 289 20,939 35,900 0% vViolations 218 River Rescue 291 0 2,120 21,395 854 20,421 5,081 2,412 231 52,514 120,800 Sub Total DCI Operating 1,000 0% nforcement Education 220 15,730 29,274 27,290 24,802 29,310 45,024 41,268 28,910 241,608 362,478 67% !ency Telephone System 244 20 1 21 142,648 1,702,681 5,899,970 Administration 212 367,875 365,625 NA SafetyLOIT 249 732,055 515,347 549,323 505,155 516,948 559,128 718,301 503,168 4,599,426 7,246,551 63% E Welfare Public Safety 252 88,181 38,267 16,514 647,998 Sub Total 369,417 329,268 372,756 1,146 0% Take Home Vehicle 278 342,261 3,880,300 13,534,110 138,115 116,706 281,960 1,086 318,492 1,086 71,100 2% Grants 292 1,268 15,297 11,946 11,079 1,740 13,568 888 15,297 105,145 15% Academy 294 2,725 9,673 242 11,678 476 678 284 713 26,468 23,750 111% More Grants 295 20,490 784 4,485 1,262 479 2,403 387 7,135 37,425 172,335 22% enforcement 299 18,385 6,474 18,397 6,844 6,225 56,869 9,704 34,490 157,388 248,960 63% lit 705 2,899,524 2,754,112 970 888,116 2,204,138 1,208,912 4,441,346 992,564 970 2,000 49% Dtal 789,405 576,850 600,685 549,741 553,438 664,102 771,031 574,416 5,079,668 8,270,365 61% sfe - Fire EMS Ca ital 287 35,728 23,659 59,387 750,000 EMSO eratin Fund 288 247,977 32,280 210,228 382,360 383,042 402,139 721,466 483,130 2,862,622 6,855,366 Hazmat 289 20,939 602 210 21,542 31,530 River Rescue 291 0 2,120 21,395 854 20,421 5,081 2,412 231 52,514 120,800 Sub Total DCI Operating 268,916 70,730 231,622 383,215 403,463 407,220 723,879 507,020 2,996,064 7,757,696 ant of Community Investment StudebakeLVOliver 209 16,261 3,375 6,335 10,054 14,798 24,190 11,161 7,308 66,059 630,000 State Grant 210 12,200 24,311 18,003 24,096 400,000 19,293 11,175 3,435 464,105 3,694,412 DCI Operating 211 250,396 178,976 186,881 187,235 182,680 193,891 262,010 188,870 1,630,939 2,661,730 Dept, of Community Investment 212 102,720 134,503 161,537 515,770 284,129 140,658 220,716 142,648 1,702,681 5,899,970 Administration 212 367,875 365,625 101% EDIT 408 577,062 1,795,231 126,960 154,855 15,900 Programs 212 4,101 12,414 64,293 36,871 104,364 114,904 88,181 38,267 16,514 647,998 Sub Total 369,417 329,268 372,756 713,059 881,606 378,031 493,901 342,261 3,880,300 13,534,110 Garages Main Street 601 16,261 29,534 14,520 689 11,980 25,848 11,161 9,999 119,991 262,391 Leighton Plaza 601 16,812 24,311 21,634 24,096 24,047 49,754 21,670 18,562 200,885 696,570 Enforcement 601 1,340 31,872 16,253 335 8,521 13,915 8,272 (17,024) 63,484 89,236 Wayne Street 601 54,617 27,884 11,887 11,750 59,817 25,387 47,078 26,730 265,149 742,615 Eddy Street Commons 601 367,875 365,625 101% EDIT 408 577,062 1,795,231 126,960 154,855 15,900 Sub Total 2,289,212 89,030 113,600 64,293 36,871 104,364 114,904 88,181 38,267 649,510 1,806,712 Ca I I /Debt Service Hall of Fame 313 636,000 636,000 1,272,000 1,266,820 100% COIT 404 1,322,195 797,317 799,782 433,747 914,359 777,528 833,731 613,158 6,491,817 15,660,371 41% Cum Capital Development 406 112,650 56,546 135,726 56,546 112,650 474,118 542,691 87% Cum Ca ita /Improvement 407 183,750 184,125 367,875 365,625 101% EDIT 408 577,062 1,795,231 126,960 154,855 1,034,072 88,516 2,289,212 57,166 6,123,074 9,943,709 62% UDAG 410 146,068 146,068 438,203 33% Major Moves 412 55,859 153,529 335,865 138,115 116,706 281,960 364,718 318,492 1,765,243 3,096,061 57% Morris PAC Improvement 416 1,268 1,665 11,946 11,079 1,740 13,568 888 42,154 70,248 60% CRED 434 3,897 3,897 7,794 650,000 1% Palais Historic Preservation 450 16,150 0% Hall of Fame Ca ital 677 6,843 6,370 5,998 4,253 3,276 2,621 3,444 2,860 35,665 188,824 19% Sub Total 2,899,524 2,754,112 1,337,096 888,116 2,204,138 1,208,912 4,441,346 992,564 16,725,807 32,238,702 529/ Financial Report August 2015. Expenditure Summary Page 15 of 25 City of South Bend Period Ending: August 31, 2015 Expenditure Report S % Fund I Jan I Feb I Mar I Apr I May Jun I Jul I AuIy 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 24,917 28,211 27,374 14,350 155,359 81,093 297,182 27% Loss Recovery 227 181,590 298,680 822,026 396,131 555,991 84,437 72,730 1,245,020 3,656,604 5,237,243 70% Human Ri hts 258 22,061 9,167 26,033 11,344 12,797 29,781 20,854 13,597 145,635 247,357 59% Morris Palais Marketin 273 67,459 96 229,535 2,358 757,297 878 Sub Total 730 3,332 18,974 18% ProfessionalSports Development 377 480,773 800 70,834 2,094,992 3,056,791 Sub Total 374,030 2,019,201 855,603 855,603 100% 1201 Code Enforcement 600 120,449 101,851 94,621 183,959 101,999 106,108 187,286 169,077 1,065,349 2,414,485 44% 1207 Animal Control 600 57,484 47,550 49,635 42,055 56,024 53,681 65,856 48,875 421,159 696,216 60% 1306 Building Operations 600 104,444 75,646 91,217 76,910 80,817 79,524 112,900 74,188 695,646 1,094,700 64% Century Center 670 306,497 285,449 289,304 326,417 340,496 362,358 401,596 337,516 2,649,633 4,532,562 58% Century Center Capital 671 1,464,000 66,156 50,000 130,440 87,735 4,190 338,521 605,656 56% Sub Total 1,273,296 913,225 1,372,972 1,064,090 1,226,335 847,207 1,322,987 1,892,462 9,912,575 15,999,978 62% s Insurance Self Funded Liability Ins 226 26,134 26,675 14,630 19,531 15,003 11,661 27,374 14,350 155,359 282,900 Liability Insurance 226 156,054 7,585 32,230 286,937 18,509 39,921 60,211 22,800 624,248 1,184,891 Business Insurance 226 15,927 14,875 21,403 1,739 75,766 421,849 1,255,361 6,529 558,089 600,000 Workers Compensation 226 64,123 206,418 63,790 43,608 67,459 55,210 229,535 27,154 757,297 989,000 Sub Total 730 262,238 255,553 132,053 351,815 176,737 528,641 317,120 70,834 2,094,992 3,056,791 Trust & A enc Fire Pension 701 441,192 441,276 450,317 433,126 43Z 764 433,366 427,928 433,690 3,493, 659 5,666,579 Police Pension 702 537,112 524,012 559,034 535,159 523,172 526,174 518,215 528,170 4,251,049 6,832,235 Employee Benefits 711 1,030,771 963 626 1,093,990 1 462 313 1,140,933 973 880 1,255,361 1 246 018 9,166,892 16, 696,935 Unemployment Comp 713 10,126 5,167 9,025 7,309 10,788 5,683 8,171 5,122 61,392 226,796 Cit Cemetery Trust 730 83,257 154,716 54% TIF Medical Service 426 2,294,533 20,000 Sub Total 2,019,201 1,934,080 2,112,366 2,437,907 2,107,658 1,939,103 2,209,676 2,213,001 16,972,992 29,442,545 Civil City Expenditure 21,003,306 18,697,459 17,690,217 16,653,639 22,462,321 19,455,397 23,490,956 21,639,180 - - - - 161,092,474 302,951,079 53% Tax Increment Financing TIFAir ort 324 2,276,439 1,684,991 1,736,337 586,596 271,305 1,028,591 3,609,185 2,886,042 14,079,485 47,710,597 30% TIF Central Development 420 964,016 957,248 4,081,705 4,088,473 4,088,473 100% TIF West Washington 422 15,300 7,650 7,344 30,294 760,900 4% TIF Leighton Plaza 425 6,962 9,662 17,748 11,509 6,950 17,590 4,246 8,589 83,257 154,716 54% TIF Medical Service 426 2,294,533 2,294,533 2,294,533 100% TIF Northeast 429 112,956 5,000 16,291 4,700 6,600 3,438 56,721 205,706 7,239,524 3% TIF Southside 430 435,370 24,431 62,420 38,892 10,969 36,484 8,551 262,737 879,854 2,842,535 31% TIF Erskine Village 432 357,545 201,724 130,835 690,104 691,380 100% TIF Douglas Road 435 169,620 171,567 341,187 345,389 99% Northeast Residential TIF 436 1,464,000 246,589 1,000 1,467,450 246,589 3,425,628 3,425,632 100% Sub Total 5,617,288 1,400,070 8,200,393 660,631 294,924 1,089,265 5,223,705 3,632,245 26,118,521 69,553,679 38% Financial Report August 2015. &p-dk- Summary Page 16 of 25 City of South Bend Period Ending: August 31, 2015 Expenditure Report S i Fund I Jan I Feb I Mar I Apr I May Jun I Jul I Au Sep 1 Oct 1 Nov I Dec I Year I Budget of laud et Selo ment Funds Adminlstratlon 433 6,000 Certified Technology Park 439 198 405,121 96,682 292,821 492,595 506,250 1,793,668 5,000,000 Blackthorn Golf Operations 619 69,055 89,358 22,845 227 19,744 201,228 201,649 Sub Total 69,055 89,358 23,043 405,121 96,909 312,565 492,595 506,250 1,994,896 5,207,649 iervlce Airport Debt Reserve 2003 315 317 227 368 594 323 1,100 697 232 3,857 5,000 Central Development reserve 328 530 379 615 993 539 1,838 1,164 387 6,445 6,000 Sub Total M 847 606 983 1,587 862 2,938 1,860 619 10,303 11,000 Financial Report August 2015. &p-dk- Summary Page 17 of 25 Redevelopment Commission 5,687,190 1,490,033 8,224,418 1,067,340 392,695 1,404,768 5,718,161 4,139,114 - - - - 28,123,719 74,772,328 38% City Operations Total 26,690,496 20,187,492 25,914,635 17,720,979 22,855,017 20,860,165 29,209,116 25,778,294 - - - - 189,216,194 377,718,721 50% Expenditure report 26, 690,496 20,187,492 25, 914, 635 17, 720, 979 22, 855, 017 20, 860,165 29, 209,116 25, 778, 294 0 0 0 0 189,216,194 377,718,721 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Financial Report August 2015. &p-dk- Summary Page 17 of 25 City of South Bend Period Ending: August 31, 2015 Debt Schedule Year of Yearof Yearof I Schetluktl Payments Debt (OdylRe1)i Debtaf 2015Principal 20151nterest 2015 Debt at 2015 Total Debt lnsWment Debt PU Issue Refundin Matu Fund 1st 2ntl 3n1 4th Issue 12/31/2014 Pa ants Pa ent AtlOW15- 121312015 Debt Payments CN#C#y Debt Bond Debt A_-k 3f CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11.870.000.00 2.055.000.00 790.000.00 86.100.00 0.00 1.265.000.00 876.100.00 36 South Bend Build Coroordlon Public Works Buildlno 2001 2010 2021 4041649 2/1 8/1 - - 9.250.000.00 3.860.000.00 545.000.00 129.726.00 0.00 3.315.000.00 674.726.00 25 Water Works l mbrovements Water Works 2002 2012 2023 625 111 7/1 - - 5.975.000.00 3.100.000.00 355.000.00 62.000.00 0.00 2.745.000.00 417.000.00 ,South Bend Buildinq Coroordion Fire HQ/ Police HQ 2003 2012 2023 4041324 2/1 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 lmbrovements Water Works 2006 2027 625 111 7/1 - - 4.710.000.00 3.300.000.00 210.000.00 146.726.00 0.00 3.090.000.00 356.726.00 42 Sewsoe Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7.630.000.00 5.740.000.00 365.000.00 255.491.26 0.00 5.375.000.00 620.491.26 40 Sewage Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16.600.000.00 12.320.000.00 720.000.00 535.947.50 0.00 11.600.000.00 1.255.947.50 52 Sewage Works Revenue Bonds 2007B Sewage Works 2007 2027 649 6/1 12/1 - - 16.515.000.00 12.280.000.00 710.000.00 524.341.26 0.00 11.570.000.00 1.234.341.26 s2 Century Center Special Tax Bonds Cent- Center 2008 2028 420 5/1 11/1 - - 4.655.000.00 3.750.000.00 285.000.00 107.687.50 0.00 3.465.000.00 392.687.50 s9 Water Works Improvements Water Works 2009 2030 625 111 7/1 - - 5.380.000.00 4.775.000.00 220.000.00 261.098.00 0.00 4.555.000.00 481.098.00 70 Sewage Works Revenue Bonds - 2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3.297.000.00 2.561.387.00 153.712.00 71.974.00 0.00 2.407.675.00 225.686.00 so 2010 S- Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9.345.000.00 7.905.000.00 375.000.00 325.267.50 0.00 7.530.000.00 700.267.50 Is Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21.500.000.00 19.040.000.00 865.000.00 706.650.00 0.00 18.175.000.00 1.571.650.00 992012Water Works Revenue Bond Water Works 2012 2033 625 111 7/1 - - 8.300.000.00 7.620.000.00 345.000.00 223.686.26 0.00 7.275.000.00 568.686.26 101 2012 Senace Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 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 1. 20, 3A Sewer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14.765.000.00 11.855.000.00 1.885.000.00 229.987.00 0.00 9.970.000.00 2.114.987.00 16 2013 Buildino Corooration EMS / Fire Depadment 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 133 St. Joseoh County PSAP St. Joseoh County PSAP 2014 2034 408 Mon1hN 2.657.696.50 2.657.696.50 123.377.50 75.951.55 0.00 2.534.319.00 199.329.05 139 Century Center Enerov Savinos I- ements at Century Ctr, 2015 2031 672 5/1 11/1 4.167.897.00 0.00 0.00 0.00 4.167.897.00 4.167.897.00 0.00 fof Parks and Recreation Bond Parks Improvements 2015 2035 408 2/1 8/1 - - 5.605.000.00 0.00 100.000.00 90.039.53 5.605.000.00 5.505.000.00 190.039.53 Tokl Bond Debt IN 204.137.593.50 142.609.083.50 10.452.089.50 4.955.168.36 9.772.897.00 141.929.891.00 15.407.257.86 Loans Payabk ss Sods Revolving Fund Water Works Improvement 2009 2030 625 1/1 7/1 - - 427.332.00 372.364.00 19.571.00 12.548.66 0.00 352.793.00 32.119.66 az Interfund Lean 410 - UDAG 1 st S- ace/Manoft G.- 2010 2015 410 6/15 12/15 - - 2.700.000.00 2.027.973.00 438.202.50 0.00 0.00 1.589.770.50 438.202.50 44 State Re..Mac Fund (Refundina) Sewage Works Improvement 1998 2018 649 6/1 12/1 - - 24.095.000.00 0.00 0.00 0.00 0.00 0.00 0.00 zs State Revolving Fund Water Works Imbrovemerts 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 Pa abk J 29.822.332.00 3.261.250.00 620.255.50 37.514.66 0.00 2.640.994.60 657.770.16 Capital Leases sf Chase LED Eauibment 2007 2017 101 111 711 1.531.573.00 559.122.04 178.539.39 22.040.27 0.00 380.582.065 200.579.66 ]z Kansas State Bank Code Enfwcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10123 9.209.00 539.14 539.14 10.50 0.00 0.00 649.64 7s Kansas State Bank Centret Services Gooier 2010 2015 222 2116 5/16 8/16 11/16 13.366.40 1.496.90 1.496.90 33.10 0.00 0.00 1.530.00 n GE Capital Information Technolonv Animal Control Copier 2010 2015 101 2128 5/30 8/30 11/30 3.550.69 403.62 403.62 4.04 0.00 0.00 407.66 ]a Kansas Stale Bank Mavw Ow Copier 2010 2015 101 1/8 4/8 7/8 10/8 9.209.00 1.586.72 1.586.72 62.20 0.00 0.00 1.648.92 7a Advanced Imaging Centre) Services Duplicators 2010 2015 222 1/15 4/15 7/15 10/15 10.511.02 2.455.77 2.455.77 139.59 0.00 0.00 2.595.36 s7 Public Finance. -.Inc Solid Waste Conteiners/trocks 2011 2015 611 6/15 12/15 321.853.00 67.665.30 67.665.30 1.599.70 0.00 0.00 69.265.00 as Sun Trust Police. Parks. Bldg vehicles 2011 2016 404/201/600 3115 6/15 9/15 12/15 2.068.202.00 641.545.46 425.630.31 9.335.10 0.00 215.915.15 434.965.41 ao Capital One Public Funding So lid Waste ConteinersiTrocks 2011 2016 611 3/15 6/15 9/15 12/15 207.432.00 74.504.09 42.308.31 977.25 0.00 32.195.78 43.285.56 sf GE Capital Information Tschnolaov Police Debt Copier 2011 2016 101 1/11 4/11 7/11 10111 3.836.00 1.275.18 837.22 51.50 0.00 437.96 888.72 az Kev Finance IT Phone Svstem 2011 2016 404 1/15 1.444.995.97 569.323.31 281.141.18 14.258.23 0.00 288.182.13 295.399.41 &4 Ikon Office Solutions Mavw Ricoh MP 2851 SP Cable, 2011 2016 101 2115 5/15 8/15 11/15 2.569.53 1.110.31 539.50 48.98 0.00 570.81 588.48 ss Sun Trost Enuiomsat Finance Parks -Goff Cars Lease 2012 2016 201 4/15 10115 - - 344.500.00 131.862.30 87.556.51 1.765.97 0.00 44.305.79 89.322.48 w Sun Trost Eauibmen[Finance Police Vehicles B Eauibmont 2012 2 1 406 5/15 11/15 - - 1.295.000.00 661.712.34 261.339.69 10.111.59 0.00 400.3]2.65 271.451.28 &a PNC Eauabmert Finance Public Works Vehicles Lease 2012 2 1 20216411640 5/15 11/15 - - 945.674.38 481.717.95 190.523.14 6.535.71 0.00 291.194.81 197.058.85 oo PNC Eauabmert Finance Public Works Vehicles Lease 2012 2017 202641/600/288 1/15 7/15 - - 2.806.054.00 1.703.748.90 560.548.08 20.403.26 0.00 1.143.200.82 580.951.34 oz Ikon Office SdWions /Ricoh Wastewater Cooler 2012 201] 641 MonthN 1st 5.744.95 3.170.10 1.172.61 149.31 0.00 1.997.49 1.321.92 os GE Capital information Technolwv Fire Department Gooier 2012 201] 101 2126 5/26 8128 11128 5.471.01 3.205.85 1.106.31 164.49 0.00 2.099.54 1.270.80 oa Ricoh USA (New) Central Services Gooier 2013 2018 222 2127 5/27 8127 1127 3.622.78 2.315.31 728.85 110.91 0.00 1.586.46 839.76 a] Ricoh USA StreetlSewer Den Copier 2013 2018 202641 3/4 06/4 9/4 12/4 5.559.15 3.475.34 1.092.25 178.55 0.00 2.383.09 1.270.80 as Ricoh USA Citv Agar- 2013 2018 101 2112 5/12 8112 11/12 5.559.15 3.492.63 1.097.31 173.49 0.00 2.395.32 1.270.80 o& Ricoh USA Parks & Rec Ricoh Caoiers(3) 2013 2018 201 2121 5121 8121 1121 16.129.94 10.132.91 3.184.26 502.98 0.00 6.948.65 3.687.24 f. PNC Eau Pawl Finance Vehicle/Eauibment Lsase 2013 2018 101/202406/641 1/15 7/15 1.689.669.59 1.361.951.27 334.301.24 15.599.28 0.00 1.027.650.03 349.900.52 1f Ricoh USA Encineel Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10.0667.67 6.790.21 2.073.34 518.66 0.00 4.716.87 2.592.00 12 Ricoh USA Buildinq Den. Calmer 2013 2018 600 MonthN 4.093.64 3.109.92 786.76 152.24 0.00 2.323.16 939.00 fa Sun Trust Enuiomeat Finance Police and PW vehicles 2013 2018 404/655/611/202 4/24 10/24 1.506.465.26 1.214.609.68 296.499.82 18.081.32 0.00 918.109.86 314.581.14 f4 Ricoh USA Adman B Finance Coder 2013 2018 101 1/16 4/16 7/16 10/16 11.247.97 7.565.05 2.178.10 393.14 0.00 5.386.95 2.571.24 n Police Den. Record Div. Ricoh Police Records Cooaw 2013 2018 101 MonthN 3rd 9.678.26 7.950.10 1.826.18 393.82 0.00 6.123.92 2.220.00 fa Water Works Main Racbh Cooaw Water Works Main Racbh Cooaw 2013 2018 620 MonthN 10th 5.647.50 4.639.36 1.065.38 230.08 0.00 3.573.98 1.295.46 fa Water Works Colfax Ricoh Coder Water Works Colfax Ricoh Cade 2013 2018 620 MonthN 16th 4.732.65 3.887.84 892.77 192.75 0.00 2.995.07 1.085.52 zp Water Works Olive Racah Cooaw Water Works Olave Racah Cooaw 2013 2018 620 MonthN 10th 4.732.65 3.887.84 892.77 192.75 0.00 2.995.07 1.085.52 zs P 11 Treinina Debt. Ricoh Cagier Tminina Caller 2014 2019 101 MonthN 30th 4.263.00 3.714.38 796.08 187.92 0.00 2.918.30 984.00 z4 Police/Public Works Vehicle Lease 2014 CiN Vehicles 2014 2019 Various 4/1 10/1 1.959.485.95 1.959.485.95 379.888.68 28.907.87 0.00 1.579.597.27 408.796.55 125 HP Combaer Lease #1 Combutw Eauibmsrt Lease 2014 2018 MonlhN 8th 137.104.95 124.554.02 29.828.93 4.995.44 0.00 94.725.09 34.824.37 1z6 HP Combaer Lease #2 Computer Eauibmert Lease 2014 2018 201 and 620 MonlhN 8th 4.000.00 3.720.95 866.48 154.00 0.00 2.854.47 1.020.48 z] HPCombner Leass#4 Computer Eauibment Lease 2014 2018 404 MonlhN 8th 5.886.15 5.461.99 1.307.57 188.47 0.00 4.154.42 1.496.04 1zs HPComouter Leass#6 Computer Eauibmsrt Lease 2014 2018 201 MonlhN 8th 3.755.50 3.561.10 801.62 155.50 0.00 2.759.48 957.12 za HP Computer Lease #7 Computo, Eauioment Lease 2014 2018 620 MonlhN 8th 1.326.00 1.302.13 294.22 42.62 0.00 1.007.91 336.84 130 Solid Waste Caner Ricoh USA Coder 2014 2019 611 MonlhN 17th 5.351.65 5.351.65 1.035.84 296.27 0.00 4.315.81 1.332.11 131 Police Communicetaons Career Ricoh USA Coder 2014 2019 101 MonlhN 12th 8.843.00 8.196.86 1.613.55 418.29 0.00 6.583.31 2.031.84 13z Organic Resources B Wastewater Ricoh USA Callers 2014 2019 641 MonlhN 21st 12.260.18 11.182.59 2.247.61 569.39 0.00 8.934.98 2.817.00 ta4 Water Works Career - Nwfh Stataan Ricoh USA Callers 2014 2019 620 MonlhN 19th 4.732.65 3.960.04 888.67 196.84 0.00 3.071.37 1.085.51 tab HP Combater Lease #B Combutw Eauaomeat Lease 2015 2019 404/201/611 MonlhN 16th 19.603.94 0.00 3.434.11 759.69 19.603.94 16.169.83 4.193.80 13] Animal Control Ricoh Caner Ricoh USA Coners 2015 2020 600 MonlhN 30th 5.261.50 0.00 694.75 217.13 5.261.50 4.566.75 911.88 138 HP Combater Lease #9 Computer Eauabment Lease 2015 2019 Various MonlhN TBD 135.958.05 0.00 11.883.04 2.710.46 135.958.05 124.075.01 14.593.50 too Vehicle &Eauab. Lease VehidsIE- ibmert Lease 2015 2020 Various 1/15 7/15 3.425.273.58 0.00 0.00 0.00 3.425.273.58 3.425.273.58 0.00 143 HP Combaer Lease #11 Computer EOUibmenl Lease 2015 2019 404 Monthly 3.040.00 0.00 214.67 45.81 3.040.00 2.825.33 260.48 Total Capital Lease 20,042,704.26 9,670,744.40 3,187,804.55 1 164,256.46 3,589,137.07 10,072,076.92 1 3,352,061.01 I gtal 4na 4ny 2n9..- tca.le lbb.b4l.0 / /.YU 14.2CU.1 -bb b.lbti.YJY.9b 11.1e2.U:19.U1 - 14'2.YC2.92 lY.9ll.U6U.UJ City of South Bend Period Ending: August 31, 2015 Debt Schedule Year of Yearof Yearof Schetluletl Payments Debf tOng/Renr Debtaf 2015Principal 20151nterest 2015 Debt at 2015 Total Debt lnsWment Debt PU Issue Refundin Matu Fund 1st 2ntl 3n1 4th Issue 12/31/2014 Pa ants Pa ant Atltlifion 121312015 Debt Payments Retlevelopment Commission Dabt Bontl Debt 7 Century 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 8 College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15.370.000.00 4.160.000.00 1.150.000.00 116.820.00 0.00 3,010,000.00 1,266,820.00 11 Soulh Bend Building Condmation Mom PAC 1998 2009 2017 408 2/1 8/1 - - 13.300.000.00 2.460.000.00 950.000.00 87.212.50 0.00 1,510,000.00 1,037,212.50 12 TJX Special Taxinq Dist ct 2002 2014 2022 324/404/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,350.00 5 Dovmtonn Centel Area TI F 2003 2011 2024 420 2/1 8/1 - - 19.795.000.00 14.965.000.00 1.205.000.00 709.525.00 0.00 13,760.000.00 1,914,525.00 6 Airoad Development Area TI F 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 7,845,000.00 1,094,611.50 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1 - - 5.485.000.00 4.255.000.00 220.000.00 268.380.00 0.00 4,035,000.00 488,380.00 54 Lease Rental Revenue Bwdsof2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36.000.000.00 33.020.000.00 33.020.000.00 1,853.268.00 31.450.000.00 31,450.000.00 34,873,268.00 81 Coveleski Stadium Recovery Coveleski Stadium 2010 2019 377 1/15 7/15 - - 4.980.000.00 2,915.000.00 620.000.00 134.802.50 0.00 2,295,000.00 754,802.50 104 2012 Gates Dovaft w Campus VA Clinic Agmt Loan 2012 2015 420 3/1 8/1 1.700.000.00 566.666.68 566.666.68 0.00 0.00 0.00 566,666.68 121 Blackthorn Golf Carl Lease Blackthorn Golf 2014 2019 619 Monthlv 14th 293.788.00 257.238.04 257.238.04 4.688.91 0.00 0.00 261.926.95 122 Synagogue at Coveleski Improvements Coveleski Stadium 2014 2018 377 1/31 500.000.00 400.000.00 100.000.00 0.00 0.00 300,000.00 100,000.00 135 2015 Redevolament Smart Streets xxx Smarts Steels 2015 2037 324 2/1 8/1 25,000,000.00 0.00 0.00 0.00 25.000.000.00 25.000.000.00 0.00 Totaleontl Debt 153.788.788.00 76.173.904.72 39.623.904.72 3.703.158.41 56.450.000.00 93.000.000.00 43,327.063.13 Loans Payable 3 Intliana Development Finance Authority Bosch PropeM (NOMOrgivel 2001 2021 210 3/22 6/22 9/22 12/22 1,040,000.00 423,820.93 59,968.23 12,044.21 0.00 383.854.70 72,010.44 4 Intliana Development Finance Authority Bosch Prodedy (Fomive) 2001 2021 210 - - 260,000.00 117,130.26 0.00 0.00 0.00 100.557.56 0.00 60 HUD Section 108 #8 Studebaker Oliver 2008 2025 434 2/1 8/1 - - 4.000.000.00 180.000.00 180.000.00 7.794.00 0.00 0.00 187,794.00 63 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1.102.549.56 47.003.09 47.003.09 1.175.08 0.00 0.00 48,178.17 64 Intertund Fund 412 -Maio, Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1.040.319.00 886.677.00 251.157.00 41.852.00 0.00 635.520.00 293.009.00 83 in tertund Fund 619 - BlacMhom Blackthorn Equip (qdf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31.032.00 0.00 0.00 0.00 0.00 0.00 0.00 84 Intedund Fund 412 -Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2.000.000.00 1.513.259.50 90.929.20 29.812.80 0.00 1,422.330.30 120.742.00 85 Into Id Funtl 412 -Major Moves Eddy Street Commons 2011 2028 436 2/15 8/15 - - 4,100,000.00 3,227,558.81 213,888.28 158,739.71 0.00 3,013,882.52 372,438.00 86 Interfund Funtl 209 to Aimort 324 Preide Ave Broomfield Prgect 2011 2020 324 8/9 - - - 500.000.00 500.000.00 0.00 0.00 0.00 500.000.00 0.00 88 Blackthorn Loan from Aimat Blackthorn Equip (mowers) 2011 2018 619 5/15 6115 7/15 8/15 53,598.50 0.00 0.00 0.00 0.00 0.00 0.00 142 Interfund Fund 412 -Major Moves Parking Garage Improvements 2016 2022 601 6/1 12/1 1,500,000.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Loans Payable 15.827.499.06 8.895.449.59 842.751.81 251.417.80 0.00 6,036.125.08 1,094.169.61 CapOal Lease Xxx Total Ca bal Lease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Leases 37 Trenspo Lease Leighton Plaza Garage 2001 2015 404 6/30 12/30 - - 3.000.000.00 191.347.00 191,347.00 8A53.00 0.00 0.00 200,000.00 13 Trenspo Lease xxx Main Colfax l Garage 2006 2025 404 3/15 9/15 - - 2,510.278.00 1.676.543.00 117,825.00 82.375.00 0.00 1.558.918.00 200,000.00 TotalLease 5.510.278.00 1.867.890.00 1 308.972.00 1 91.028.00 0.00 1558.918.00 400,000.00 Total Retlevabpment Commission 174.926.565.06 84.93].244.31 I 40.775.628.53 I 4.045.604.21 56.450.000.00 100.595.043.08 44.821.232.]4 Total Debt 428,929,194.82 240,478,322.21 55,035,778.08 9,202,543.69 69,812,034.07 255,238,005.50 64,238,321.77 City of South Bend Period Ending: August 31, 2015 Monthly Debt Schedule Yearof I Yearof Yearof Schetluktl Payments Debt torg /Rani Debtaf YTD Pdnclpal YTD Interest YTD DeWitt Debt lnsWment Debt PU Issue Refunding Matu w Fund 1st 2ntl 3n1 4th Issue JM12014 Pa ante Pa ants AtltliOOns 1 813112015 CN#C#y Debt Bond Debt A_-k 3f CEDIT Bond 1997 2006 2017 408 2/1 8/1 - - 11.870.000.00 2.055.000.00 405.000.00 38.400.00 0.00 1.650.000.00 36 South Bend Build Corporation Public Works Buildlno 2001 2010 2021 4041649 2/1 8/1 - - 9.250.000.00 3.860.000.00 545.000.00 129.726.00 0.00 3.315.000.00 25 Water Works l mprovements Water Works 2002 2012 2023 625 7/1 12/31 - - 5.975.000.00 3.100.000.00 0.00 31.000.00 0.00 3.100.000.00 ,South Bend Buildinq Corporation Fire HQ/ Police HQ 2003 2012 2023 4041324 2/1 8/1 - - 21.335.000.00 11.245.000.00 1.160.000.00 403.635.00 0.00 10.085.000.00 24 Water Work s Improvements Water Works 2006 2027 625 7/1 12/31 - - 4.710.000.00 3.300.000.00 0.00 73.363.00 0.00 3.300.000.00 42 Sewsoe Works Improvements Sewage Works 2006 2026 649 6/1 12/1 - - 7.630.000.00 5.740.000.00 0.00 127.745.63 0.00 5.740.000.00 40 Sewage Works Improvements Sewage Works 2007 2027 649 6/1 12/1 - - 16.600.000.00 12.320.000.00 0.00 267.973.75 0.00 12.320.000.00 52 Sewage Works Revenue Bonds 20078 Sewage Works 2007 2027 649 6/1 12/1 - - 16.515.000.00 12.280.000.00 0.00 262.170.63 0.00 12.280.000.00 s2 Century Center Special Tax Bonds Century Center 2008 2028 420 5/1 11/1 - - 4.655.000.00 3.750.000.00 285.000.00 55.981.25 0.00 3.465.000.00 s9 Water Works Improvements proveents Water Works 2009 2030 625 7/1 12/31 - - 5.380.000.00 4.775.000.00 0.00 130.549.00 0.00 4.775.000.00 70 Sewage Works Revenue Bonds - 2009 Sewage Works 2009 2028 649 6/1 12/1 - - 3.297.000.00 2.561.387.00 0.00 35.987.00 0.00 2.561.387.00 so 2010 S- Works Revenue Bonds Sewage Works 2010 2030 649 6/1 12/1 - - 9.345.000.00 7.905.000.00 0.00 162.633.75 0.00 7.905.000.00 es Sewage Works Revenue Bonds 2011 Sewage Works 2011 2031 649 6/1 12/1 - - 21.500.000.00 19.040.000.00 0.00 353.325.00 0.00 19.040.000.00 992012Water Works Revenue Bond Water Works 2012 2033 625 1/1 7/1 - - 8.300.000.00 7.620.000.00 345.000.00 227.086.26 0.00 7.275.000.00 fof 2012 Senesce Works Revenue Bonds Sewage Works 2012 2032 649 6/1 12/1 - - 25.000.000.00 22.965.000.00 0.00 264.090.00 0.00 22.965.000.00 1. 20, 3A Sevrer Bond Refunding Sewage Works 2013 2013 2024 649 6/1 12/1 - - 14.765.000.00 11.855.000.00 0.00 114.993.50 0.00 11.855.000.00 16 2013 Buildino Comoration EMS / Fire Depadment 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 f33 St. Joseph County PSAP St. Joseph County PSAP 2014 2034 408 Monthlv - - - 2.657.696.50 2.657.696.50 82.251.68 50.634.40 0.00 2.575.444.82 f39 Century Center En- Savings Improvements Century Cb. 2015 2031 672 5/1 11/1 - - 4.167.897.00 0.00 0.00 0.00 4.167.897.00 4.167.897.00 fof Parks and Rec Bond Parks Improvements 2015 2035 408 2/1 8/1 - - 5.605.000.00 0.00 33.333.34 30.013.18 5.605.000.00 5.571.666.66 Total Bond Debt 204.137.593.50 142.609.083.50 3.070.585.02 2.949.987.35 9.772.897.00 149.311.395.48 Loans Payabk sa State Revolving Fund Water Works Improvement 2009 2030 625 7/1 12/31 - - 427.332.00 372.364.00 0.00 6.274.33 0.00 372.364.00 az Interfund Lean 410 - UDAG 1 st S- ace/Maniod Garage 2010 2015 410 6/15 12115 - - 2.700.000.00 2.027.973.00 146.067.50 0.00 0.00 1.881.905.50 44 State Revolving Fund (sch# 1051 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 12/31 - - 2.600.000.00 860.913.00 0.00 12.483.00 0.00 860.913.00 Total Loans Pa abk 29.822.332.00 3.261.250.00 146.067.50 18.757.33 0.00 3.115.182.50 Capital Leases sf Chase LED E.uipment 2007 2017 101 1/1 7/1 1.531.573.00 559.122.04 178.539.39 22.040.27 0.00 380.582.65 7z Kanas. State Bank Code Enforcement Oce Copier 2010 2015 101 1/23 4/23 7/23 10123 9.209.00 539.14 539.14 10.50 0.00 0.00 ,e Kansas State Bank Central Services Gooier 2010 2015 222 2116 5/16 8/16 11116 13.366.40 1.496.90 1.496.90 33.10 0.00 0.00 n GE Capital Information Technology Animal Control Copier 2010 2015 101 2128 5/30 8/30 11130 3.550.69 403.62 403.62 4.08 0.00 0.00 ,a Kansas Stale Bank M- Ow Copier 2010 2015 101 1/8 4/8 7/8 1018 9.209.00 1.586.72 1.586.72 62.20 0.00 0.00 ]a van Adced ImServices aaina Central S Duplicators 2010 2015 222 1/15 4/15 7/15 10115 10.511.02 2.455.77 1.821.31 125.21 0.00 634.46 a7 Public Finance. -.Inc Solid Waste Conteiners/Irocks 2011 2015 611 6/15 12/15 321.853.00 67.665.30 33.568.80 1.063.70 0.00 34.096.50 as Sun Trust Police. Parks. Bldg vehicles 2011 2016 404/201/600 3115 6/15 9/15 12115 2.068.202.00 641.545.46 211.788.45 5.694.25 0.00 429.757.01 ao Capital One Public Funding Solid Waste ConteinersiTrocks 2011 2016 611 3115 6/15 9/15 12115 207.432.00 74.504.09 21.066.29 576.49 0.00 53.437.80 of GE Capital Information Technology Police Debt Copier 2011 2016 101 1/11 4/11 7/11 10111 3.836.00 1.275.18 623.38 43.10 0.00 651.80 az Kev Finance IT Phone Svstem 2011 2016 404 1/15 1.444.995.97 569.323.31 281.141.18 14.258.23 0.00 288.182.13 &4 Ikon Office Solutions Mayor Ricoh MP 2851 SP Coble, 2011 2016 101 2115 5/15 8/15 11/15 2.569.53 1.110.31 401.76 39.60 0.00 ]08.55 as Sun Trust Equipment Finance Parks -Goff Cars Lease 2012 2016 201 4/15 10115 - - 344.500.00 131.862.30 43.603.35 1.057.89 0.00 88.258.95 a7 Sun Trust Eauipment Finance Police Vehicles &Equipment 2012 2 1 406 5/15 11/15 - - 1.295.000.00 661.712.34 130.118.56 5.607.08 0.00 531.593.78 as PNC Equipment Finance Public Works Vehicles Lease 2012 2 1 20216411640 5/15 11/15 - - 945.674.38 481.]1].95 94.904.49 3.624.93 0.00 386.813.46 o0 PNC Eauipmant Finance Public Works Vehicles Lease 2012 2017 202/64116001288 1/15 7/15 - - 2.806.054.00 1.703.]48.90 560.548.08 20.403.26 0.00 1.143.200.82 oz Ikon Office S.IWians /Ricoh Wastewater Cooler 2012 2 1 641 MonthN 1st 5.]44.95 3.170.10 774.36 106.92 0.00 2.395.74 oa GE Capital Information Technolwv Fire Department Gooier 2012 2 1 101 2/28 5126 8128 11128 5.471.01 3.205.85 823.65 129.45 0.00 2.382.20 oa Ricoh USA Central Services Caviar 2013 2018 222 2127 5127 8127 1127 3.622.78 2.315.31 551.03 78.79 0.00 1.764.28 o7 Ricoh USA SbeebSawer Dart Copier 2013 2018 202/641 3/4 6/4 9/4 1214 5.559.15 3.475.34 538.25 97.15 0.00 2.937.09 pa Ricoh USA Citv Afton- Cobiar 2013 2018 101 2112 5/12 8112 11112 5.559.15 3.492.63 829.86 123.24 0.00 2.662.77 o& Ricoh USA Parks & R- Ricoh Cariers(3) 2013 2018 201 221 521 821 1121 16.129.94 10.132.91 2.408.14 35].29 0.00 ].]24.77 fp PNC Eau Pawl Finance V. icle/Eauinnent Lease 2013 2018 101/202/406/641 1/15 7/15 1.689.669.59 1.361.951.27 334.301.24 15.599.28 0.00 1.02].650.03 1f Ricoh USA Encineel Plotter /Scanner 2013 2018 101 3/3 6/3 9/3 12/3 10.667.67 6.790.21 1.014.60 281.40 0.00 5.]75.61 1z Ricoh USA Buildinq Deal. Calmer 2013 2018 600 Month N - - 4.093.64 3.109.92 519.67 106.33 0.00 2.590.25 fa Sun Trust Eauipmen[ Finance Police and PW vehicles 2013 2018 404I655/611I202 424 1024 1.506.465.26 1.214.609.68 14].664.]9 9.625.78 0.00 1.O6fi.944.89 f4 Ricoh USA Admen B Finance Copier 2013 2018 101 1/16 4/16 7/16 10/16 11.24].97 ].565.05 1.621.72 306.71 0.00 5.943.33 n Police Deal. Record Div. Ricoh Police Records Copier 2013 2018 101 MonthN 3rd - - 9.678.26 7.950.10 1.206.22 273.78 0.00 6.]43.88 fa Water Works Main Ricoh Copier Water Works Main Ricoh Copier 2013 2018 620 MonthN 10th - - 5.64].50 4.639.36 ]03.]0 159.90 0.00 3.935.66 fa Water Works Colfax Ricoh Copier Water Works Colfax Ricoh Code 2013 2018 620 MonthN 16th - - 4.732.65 3.887.84 589.69 133.99 0.00 3.298.15 zp Water Works Olive Ricoh Cagier Water Works Olive Ricoh Cagier 2013 2018 620 Month N 10th - - 4.732.65 3.887.84 589.69 133.99 0.00 3.298.15 za Police Train no Dept. Ricoh Cagier Tminina Copier 2014 2019 101 Month 30th - - 4.263.00 3.714.38 525.77 130.23 0.00 3.188.61 z4 Kev Goverment Finance 2014 CiN Vehicles 2014 2019 4/1 10/1 - - 1.959.485.95 1.959.485.95 189.211.09 15.187.18 0.00 1.]70.274.86 125 HPCombuter Lease #1 Computer Eauiomeat Lease 2014 2018 M.nIhN 8th - - 137.104.95 124.554.02 19.736.70 3.479.54 0.00 104.81].32 1z6 HP Computer Lease #2 C.mrukr Equipment Lease 2014 2018 201aand 620 Month 8th - - 4.000.00 3.720.95 573.19 107.13 0.00 3.14].]6 z7 HPCombuter Laaae#4 Computer Eauirrant Lease 2014 2018 404 Month N 8th - - 5.886.15 5.461.99 866.08 131.28 0.00 4.595.91 1ze HPCombuter Laasa#6 Computer Eauibment Lease 2014 2018 201 Month N 8th - - 3.755.50 3.561.10 530.08 108.00 0.00 3.031.02 za HP Computer Lease #7 C.mrutor Eauirrawt Lease 2014 2018 620 Month N 8th - - 1.326.00 1.302.13 193.67 30.89 0.00 1.108.46 13. Solid Waste Career Ricoh USA Gooier 2014 2019 611 M.nIhN 17th - - 5.351.65 5.351.65 710.41 211.82 0.00 4.641.24 tat Police Communiceti.ns Career Ricoh USA Gorier 2014 2019 101 Month 12th - - 8.843.00 8.196.86 1.065.65 288.91 0.00 7.131.21 13z Organic Resources & Wastewater Ricoh USA Coolers 2014 2019 641 M.nIhN 21 at - - 12.260.18 11.182.59 1.484.40 393.60 0.00 9.698.19 ... Water WorksCrier- Nord-SWtion RIrh.USA Goners 2014 2019 620 Month N 19th - - 4.732.65 3.960.04 586.99 136.69 0.00 3.373.05 tab HPC -ter Lease #B Combater Eauibment Lease 2015 2019 404201/611 Month N 16th - - 19.603.94 0.00 2.043.15 473.13 19.603.94 17.560.79 137 Animal Control Ricoh Career Ricoh USA Coolers 2015 2020 600 Month N 30th - - 5.261.50 0.00 382.21 124.39 5.261.50 4.879.29 138 HP C.mbuter Lease #9 Combater Eauibmant Lease 2015 2019 Various M.nthIv TBD - - 135.958.05 0.00 2.347.14 561.56 135.958.05 133.610.91 too Vehicle &Eauib. Lease Vehide/Enuir -t Lease 2015 2020 Various 1/15 7/15 - - 3.425.2]3.58 0.00 0.00 0.00 3.425.273.58 3.425.273.58 143 HP Computer Lease #11 Combiner Eauibmenl Lease 2015 2019 404 Monthly 3.040.00 0.00 3.040.00 3.040.00 Tota /Ca ital Lease 20.042.704.26 9.670.744.40 2.276.544.56 123.522.24 3.589.137.07 10.983.336.91 Total Ch* City 254.002.629.76 155.541.077.90 5.493.197.08 3.092266.92 13.362.034.07 1 163.409.914.89 City of South Bend Period Ending: August 31, 2015 Monthly Debt Schedule Yearof I Yearof Yearof Schetluletl Payments Debf(Ong /Rani Debtof YTD PAnclpal YTD Interest YTD Debtat Debt lnsWment Debt PU Issue Refunding Matu w Fund 1st 2ntl 3n1 4th Issue 12/31/2014 P.,_. Pa enfs Atltlifions 1 813112015 Retlevelopment Commission Debf Bontl Debt 7 Century 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 8 College Football Hall of Fame Hall of Fame 1994 2000/2011 2018 313 2/1 8/1 - - 15.370.000.00 4.160.000.00 1.150.000.00 116.820.00 0.00 3,010,000.00 11 Soulh Bend Building Coromation Mom PAC 1998 2009 2017 408 2/1 8/1 - - 13.300.000.00 2.460.000.00 950.000.00 87,212.50 0.00 1,510,000.00 12 TJX Special Taxinq Dist ct 2002 2014 2022 324/404/414 1/1 7/1 - - 6.620.000.00 3.010.000.00 0.00 43,175.00 0.00 3,010,000.00 5 Downtown Centel Area TIF 2003 2011 2024 420 2/1 8/1 - - 19.795.000.00 14.965.000.00 1.205.000.00 709.525.00 0.00 13,760.000.00 6 Airoad Development Area TI F 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 7,845,000.00 22 Erskine Village TIF Development Bond Erskine Village 2005 2027 432 2/1 8/1 - - 5.485.000.00 4.255.000.00 220.000.00 268.380.00 0.00 4,035,000.00 54 Lease Rental Revenue B.d. of 2008 Eddy Street Commons 2008 2027 429 2/15 8/15 - - 36.000.000.00 33.020.000.00 33.020.000.00 1,853.268.00 31.450.000.00 31,450.000.00 81 Coveleski Stadium Recovery Cm leski Stadium 2010 2019 377 1/15 7/15 - - 4.980.000.00 2,915.000.00 620.000.00 0.00 2,295,000.00 104 2012 Gates Downtown Campus VA Clinic Acmt Loan 2012 2015 4201324 3/1 8/1 - - 1.700.000.00 566.666.68 566.666.68 0.00 0.00 0.00 121 Blackthorn Golf Cad Lease Blackthorn Golf 2014 2019 619 Monthly 14th 293.788.00 257.238.04 257.238.04 535.91 0.00 0.00 122 Svnscogue at Coveleski Improvements Coveleski Stadium 2014 2018 377 1/31 500.000.00 400.000.00 100.000.00 0.00 0.00 300.000.00 135 2015 Redevelopment Smart Streets Smart Streets 2015 2037 324 2/1 8/1 25.000.000.00 0.00 0.00 0.00 25.000.000.00 25.000.000.00 Tofal BOntl Debt 153.788.788.00 76.173.904.72 39.228.904.72 3.521.027.91 56.450.000.00 93.395.000.00 Loans Payable 3 Indiana Development Finance Authority Bosch Property (Nonfagive) 2001 2021 210 3/22 6/22 9/22 12/22 1.040.000.00 423.620.93 29.759.08 6.246.14 0.00 394.061.85 4 IntlI na Development Finance Authority Bosch Property (Fomive) 2001 2021 210 - - 260.000.00 117.130.26 0.00 0.00 0.00 117.130.26 60 HUD Section 108 #8 Sludebaka Oliver 2008 2025 434 2/1 8/1 - - 4.000.000.00 180.000.00 180.000.00 7.794.00 0.00 0.00 63 City of Mishawaka Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1,102,549.56 47,003.08 47,003.08 1,175.08 0.00 0.00 64 Intertund Fund 412 -Major Moves Douglas Road TIF 2009 2029 435 2/15 8/15 - - 1.040.319.00 886.677.00 251.157.00 41.852.00 0.00 635520.00 83 in tertund Fund 619 - BlacMhom Blackthorn Equip (qdf carts) 2010 2017 619 5/15 6/15 7/15 8/15 31.032.00 0.00 0.00 0.00 0.00 0.00 84 Intedund FUnd 412 -Major Moves Triangle Development 2011 2029 436 2/15 8/15 - - 2.000.000.00 1.513.259.50 90.929.20 29,812.81 0.00 1,422.330.30 85 Intedund FUntl 412 -Major Moves Eddy Street Commons 2011 2028 436 2/15 8/15 - - 4,100,000.00 3,227,558.81 213,888.28 158,73971 0.00 3,013,882.52 86 Interfund Funtl 209 to Aimort 324 Preide Ave Brownfield Prgact 2011 2020 324 8/9 - - - 500.000.00 500.000.00 0.00 0.00 0.00 500.000.00 88 Blackthorn Loan from Aimat Blackthorn Equip (mowers) 2011 2018 619 5/15 6/15 7/15 8/15 53.598.50 0.00 0.00 0.00 0.00 0.00 142 Interfund Fund 412 -Major Moves Parking Garage Improvements 2016 2022 601 6/1 12/1 - - 1,500,000.00 0.00 0.00 0.00 0.00 0.00 Total Loans Payable 15.627.499.06 6.895.449.59 812.544.66 245.619.74 0.00 6,082.904.93 CapOal Lease Xxx Total Ca hal Lease 0.00 0.00 0.00 0.00 0.00 0.00 Leases 37 Trenspo Lease Leiqhton Plaza Garage 2001 2015 404 6/30 12130 - - 3.000.000.00 191.347.00 94,260.00 5.740.00 0.00 97,087.00 13 Trenspo Lease xxx Main l Colfax Garage 2006 2025 404 3/15 9/15 - - 2.510.278.00 1.676.543.00 58.086.00 41.914.00 0.00 1,618,457.00 TotalLease 5.510.278.00 1.867.890.00 1 152.346.00 1 47.654.00 0.00 1 1.715544.00 Total Retlevebpment Commission 174.926.565.06 84.937.244.31 1 40.193.795.38 1 3,814,301.65 56.450.000.00 1 101.193.448.93 Total Debt 428,929,194.82 240,478,322.21 45,686,992.46 6,906,568.57 69,812,034.07 264,603,363.82 City of South Bend Staffing Headcount Summary Budget Full Time I Jan Feb I Mar I Apr I May Jun I Jul I Aug I Sep I Oct I Nov I Dec Full Time Staff 1094.00 1084.00 1076.00 1077.00 1072.00 1073.00 1074.00 1065.00 1071.00 0.00 0.00 0.00 0.00 Part Time Staff 68.00 70.00 90.00 101.00 110.00 109.00 101.00 113.00 0.00 0.00 0.00 0.00 Temporary /Seasonal 111.00 109.00 113.00 126.00 209.00 309.00 257.00 266.00 0.00 0.00 0.00 0.00 City Total 1263.00 1255.00 1280.00 1299.00 1392.00 1492.00 1423.00 1450.00 0.00 0.00 0.00 0.00 Financial Report August 2015 - Headcount Staffing Page 22 of 25 City of South Bend Staffing Headcount Full Time Staff Amended Budget General Government Mayor 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 8.00 0.00 0.00 0.00 0.00 311 Call Center 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 6.00 0.00 0.00 0.00 0.00 Admin & Finance 21.00 21.00 21.00 21.00 21.00 21.00 20.00 19.00 19.00 0.00 0.00 0.00 0.00 Innovation/ Technology Office 4.00 2.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 Safety & Risk 3.00 3.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 Clerk 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 Common Council 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 0.00 0.00 0.00 0.00 L al De artment 11.00 10.00 11.00 11.00 11.00 11.00 11.00 9.00 11.00 0.00 0.00 0.00 0.00 Sub Total 67.00 64.00 65.00 65.00 65.00 65.00 64.00 61.00 63.00 0.00 0.00 0.00 0.00 Code Ent. /Animal Control 24.00 23.00 23.00 22.00 22.00 23.00 23.00 23.00 23.00 0.00 0.00 0.00 0.00 Dept. of Community Investment 25.00 23.00 23.00 24.00 24.00 24.00 25.00 25.00 24.00 0.00 0.00 0.00 0.00 Parks & Recreation Administration 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 11.00 0.00 0.00 0.00 0.00 Maintenance 44.00 44.00 44.00 44.00 43.00 43.00 44.00 45.00 44.00 0.00 0.00 0.00 0.00 Golf Operations 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 0.00 0.00 0.00 0.00 Recreation Ops 26.00 24.00 24.00 24.00 24.00 25.00 25.00 25.00 25.00 0.00 0.00 0.00 0.00 Zoological Ops 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 Graffiti Removal 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 Recreation Non-reverting 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 Sub Total 91.00 89.00 89.00 89.00 88.00 89.00 90.00 91.00 91.00 0.00 0.00 0.00 0.00 Public Safety Police 306.00 302.00 302.00 304.00 300.00 297.00 299.00 297.00 297.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 260.00 260.00 259.00 258.00 259.00 0.00 0.00 0.00 0.00 Sub Total 564.00 567.00 560.00 564.00 560.00 557.00 558.00 555.00 556.00 0.00 0.00 0.00 0.00 Public Works Central Services 37.00 34.00 34.00 33.00 34.00 35.00 34.00 34.00 35.00 0.00 0.00 0.00 0.00 Office of Sustainability 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 Engineering 16.00 15.00 15.00 15.00 16.00 16.00 17.00 16.00 17.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 Solid Waste Operations 21.00 20.00 21.00 21.00 21.00 20.00 19.00 20.00 21.00 0.00 0.00 0.00 0.00 Code Clean Crew 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 Street Operations 56.00 56.00 56.00 55.00 56.00 56.00 56.00 56.00 55.00 0.00 0.00 0.00 0.00 Sewer Operations 33.00 33.00 30.00 30.00 28.00 30.00 31.00 30.00 29.00 0.00 0.00 0.00 0.00 Waste Water Ops 44.00 44.00 44.00 43.00 43.00 42.00 41.00 41.00 41.00 0.00 0.00 0.00 0.00 Organic Resources 6.00 6.00 6.00 6.00 6.00 5.00 5.00 5.00 6.00 0.00 0.00 0.00 0.00 Water Utilit Ops 68.00 68.00 68.00 68.00 67.00 69.00 69.00 66.00 68.00 0.00 0.00 0.00 0.00 Sub Total 290.00 285.00 283.00 280.00 280.00 282.00 281.00 277.00 281.00 0.00 0.00 0.00 0.00 Building Department 13.00 13.00 13.00 13.00 13.00 13.00 13.00 13.00 13.00 0.00 0.00 0.00 0.00 Human Rights 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 Morris & Palais 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 0.00 0.00 0.00 0.00 City Total 1094.00 1084.00 1076.00 1077.00 1072.00 1073.00 1074.00 1065.00 1071.00 QWO 0.00 0.00 0.00 Financial Report August 2015 - Headcount Staffing Page 23 of 25 City of South Bend Staffing Headcount Part Time Staff Financial Report August 2015 - Headcount Staffing Page 24 of 25 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Government Mayor 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 311 Call Center 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 Admin & Finance 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.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 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 Sub Total 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 0.00 0.00 0.00 0.00 Code Enf. /Animal Control 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.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 Administration 5.00 5.00 5.00 4.00 4.00 4.00 2.00 4.00 0.00 0.00 0.00 0.00 Maintenance 3.00 3.00 4.00 7.00 12.00 13.00 13.00 11.00 0.00 0.00 0.00 0.00 Golf Operations 0.00 1.00 20.00 29.00 34.00 34.00 33.00 34.00 0.00 0.00 0.00 0.00 Recreation Ops 31.00 32.00 32.00 30.00 30.00 32.00 25.00 29.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 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Sub Total 39.00 41.00 62.00 71.00 81.00 83.00 73.00 78.00 0.00 0.00 0.00 0.00 Public Safety Police 5.00 5.00 5.00 5.00 5.00 7.00 2.00 9.00 0.00 0.00 0.00 0.00 Communications Fire Sub Total 5.00 5.00 5.00 5.00 5.00 7.00 2.00 9.00 0.00 0.00 0.00 0.00 Public Works Central Services 1.00 1.00 0.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 Engineering 3.00 3.00 3.00 3.00 3.00 2.00 2.00 2.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 2.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Street Ops 4.00 3.00 3.00 3.00 2.00 0.00 7.00 4.00 0.00 0.00 0.00 0.00 Sewer Ops 0.00 0.00 0.00 0.00 1.00 0.00 0.00 3.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 Utilit Ops 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 0.00 0.00 0.00 0.00 Sub Total 11.00 11.00 10.00 12.00 11.00 6.00 13.00 13.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 2.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 0.00 Morris & Palais 5.00 5.00 5.00 5.00 5.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 City Total 68.00 70.00 90.00 101.00 110.00 109.00 101.00 113.00 0.00 0.00 0.00 0.00 Financial Report August 2015 - Headcount Staffing Page 24 of 25 City of South Bend Staffing Headcount Temporary, Seasonal, and Intern Staff General Government Jan I Feb Mar I Apr May I Jun Jul I Aug Sep I Oct I Nov Dec Mayor 0.00 0.00 0.00 0.00 0.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 Admin & Finance 4.00 1.00 1.00 1.00 2.00 5.00 5.00 2.00 0.00 0.00 0.00 0.00 Safety and Risk 0.00 0.00 0.00 0.00 0.00 1.00 1.00 1.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 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 1.00 2.00 7.00 7.00 4.00 0.00 0.00 0.00 0.00 Code Enforcement 0.00 0.00 0.00 0.00 1.00 0.00 0.00 2.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 5.00 7.00 7.00 7.00 7.00 0.00 0.00 0.00 0.00 Maintenance 11.00 10.00 9.00 16.00 35.00 32.00 29.00 25.00 0.00 0.00 0.00 0.00 Golf Operations 2.00 3.00 10.00 11.00 16.00 25.00 20.00 22.00 0.00 0.00 0.00 0.00 Recreation Ops 46.00 47.00 38.00 46.00 83.00 160.00 147.00 135.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 1.00 1.00 2.00 0.00 0.00 0.00 0.00 Sub Total 64.00 65.00 62.00 78.00 141.00 225.00 204.00 191.00 0.00 0.00 0.00 0.00 Police 27.00 27.00 27.00 27.00 27.00 39.00 11.00 42.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 27.00 27.00 39.00 11.00 42.00 0.00 0.00 0.00 0.00 Central Services 0.00 0.00 0.00 0.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Engineering 4.00 4.00 5.00 5.00 10.00 10.00 12.00 4.00 0.00 0.00 0.00 0.00 Energy /Sustainability 4.00 4.00 4.00 4.00 5.00 5.00 0.00 3.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 8.00 10.00 9.00 10.00 9.00 0.00 0.00 0.00 0.00 Street Ops 1.00 4.00 1.00 0.00 4.00 6.00 6.00 6.00 0.00 0.00 0.00 0.00 Sewer Ops 2.00 0.00 2.00 2.00 6.00 5.00 5.00 5.00 0.00 0.00 0.00 0.00 Leaf Pickup 1.00 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste Water Ops 0.00 0.00 0.00 0.00 1.00 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 Utilit Ops 1.00 1.00 1.00 0.00 2.00 2.00 1.00 0.00 0.00 0.00 0.00 0.00 Sub Total 16.00 16.00 23.00 20.00 38.00 38.00 35.00 27.00 0.00 0.00 0.00 0.00 City Total 111.00 109.00 113.00 126.00 209.00 309.00 257.00 266.00 0.00 0.00 0.00 0.00 Financial Report August 2015 - Headcount Staffing Page 25 of 25