The URL can be used to link to this page

Home My WebLink About08-2015 Departmental Financial ReportPeriod Ending: Issued By: August 31, 2015 Administration /Finance City of South Bend Monthly Departmental Financial Report Contents 1 Narrative 2 Summaries 6 General Fund 20 Special Revenue Funds 54 Debt Service /Capital Project Funds 68 Enterprise Funds 93 Internal Service Funds 99 Trust Funds 102 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Deputy Chief of Staff Brian Pawlowski South Bend Common Council Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Financial Specialist Senior Cecil Eastman Department Heads Fiscal Officers August 2015 The Monthly Departmental Financial Report The City of South Bend has developed the attached Monthly Departmental Financial Report to provide current year financial information for each City fund, as well as individual departments within the General Fund, in a condensed format. Information is provided for revenue, expenditures, encumbrances, cash balances and staffing levels. Also included in this report are text boxes that allow departmental fiscal officers to provide an explanation of significant expenditure and staff ingvariances and spending on major capital projects. Departmental fiscal officers are asked to complete the monthly financial reports ( "blue sheets ") for their funds and General Fund departments no later than the 18th of the month following the reporting period. The staff of the Department of Administration & Finance then summarizes the data and publishes this consolidated report no later than 30 days after the end of the reporting period. The Monthly Departmental Financial Report supplements —but does not replace —other financial reports that the City prepares such as the Monthly Financial Report, Controller's Cash Report, the Department of Local Government Finance's Annual Financial Report (AFR), or the Comprehensive Annual Financial Report (CAFR). Summary Trends & Observations As of August 31, 2015, total revenue for the year was $176,155,959, 61% of estimated revenue. As of August 31, 2014 total revenue received was $163,003,494 within the same funds. Property taxes are received in June and December each year and are budgeted at $70,121,112 for 2015 - -24% of annual budgeted revenues. Local income tax (LOIT, COIT and EDIT) receipts are budgeted to be $24.3 million in 2015; $14.2 million of that total was received as of August 31. Local taxes are normally received on a monthly basis, but August's payments weren't received until September. In June the City received the first of its two annual property tax payments which totaled $39.7 million, 57% of the budgeted amount. Given that the first payment is usually around 53% of the budgeted amount, the City anticipates overall general property tax receipts to exceed this year's original budget projection and has adjusted the budgeted estimate upward accordingly. On March 4, 2015 the City closed on its sale of Blackthorn Golf Course to a private company and received $1,472,130 in proceeds at that time. This amount represented the City's portion of the $1.655 million sale price. The golf course had realized $119,238 in revenue by the time of its sale, 7% of its annual budget. As of August 31, 2015, total expenditures were $189,216,188 and outstanding encumbrances were $37,093,550, a total of $226,309,738 which represents 60% of the amended expenditure budget. Encumbrances are either holdovers from previous years or obligations for the remainder of the year. If encumbrances were excluded, expenditures were 50% of the amended expenditure budget at the end of the period. Total expenditures were $175,552,720 as of August 31, 2014. In 2015 the City re- organized some of its TIF funds which resulted in the closure of the Downtown TIF (Fund 420) and the Central Medical Service Area TIF (Fund 426). The cash balances of these funds were transferred to the River West TIF (Fund 324) with a portion to River East TIF (Fund 429). These two funds' expenditures were therefore finalized at $4.1 million and $2.3 million, respectively, as the expenditure budgets were reduced to match actual. Thus, they are both at 100% of expenditures budgeted but will have no further expenditures. We hope that you find this Monthly Departmental Financial Report useful in better understanding the finances of the City of South Bend. If you have any questions regarding this report, please contact us at 574 - 235 -7702. City of South Bend Monthly Department Financial Report REVENUE SUMMARY August 31, 2015 City Funds General Fund 52,822,478 1,073,242 30,810,824 32,312,392 22,011,654 58% Special Revenue 102 Rainy Day 34,680 1,936 37,135 19,001 (2,455) 107% 103 Excess Levy 20 1 12 - 8 62% 201 Parks & Recreation 11,030,715 413,419 6,592,958 6,387,889 4,437,757 60% 202 Motor Vehicle Highway 9,701,800 981,221 6,115,390 5,485,000 3,586,410 63% 203 Recreation Nonreverting 1,578,935 181,580 791,959 727,325 786,976 50% 209 Studebaker - Oliver Reverting Grants 644,000 7,555 90,756 2,389 553,244 14% 210 Economic Development State Grants 3,673,510 35 436,974 36,808 3,236,536 12% 211 Department of Community Investment (DCI) 2,634,425 62,960 1,219,097 1,532,366 1,415,328 46% 212 Dept of Community Investment Grants 5,890,000 375,355 1,594,729 2,411,722 4,295,271 27% 216 Police State Seizures 36,050 43 15,119 23,887 20,931 42% 217 Gift, Donation, Bequest 398,800 76 3,867 171,304 394,933 1% 218 Police Curfew Violations 1,025 41 140 351 885 14% 220 Law Enforcement Continuing Education 270,000 18,422 210,124 136,598 59,876 78% 227 Loss Recovery 60,000 790 50,572 17,194 9,428 84% 244 Emergency Phone System 20 - 19 215,000 1 97% 249 Public Safety LOIT 6,472,240 187 3,776,353 4,257,305 2,695,887 58% 251 Local Roads & Streets 1,821,300 23,823 706,885 700,132 1,114,415 39% 252 Excess Welfare Distribution - - 0 3 (0) 0% 258 Human Rights Federal Grant 209,950 5,098 72,722 40,518 137,228 35% 271 Eastrace Waterway 50 1 19 28 31 37% 273 Morris PAC / Palais Royale Marketing 18,000 256 7,124 8,118 10,876 40% 280 Police Block Grants - 1 16 8 (16) 0% 281 Economic Develop. Commission - Revenue Bonds 300 6 117 60 183 39% 289 HAZMAT 14,100 7 13,928 24,092 172 99% 291 Indiana River Rescue 45,350 17 31,000 38,804 14,350 68% 292 Police Grants 90,000 - 56,946 66,716 33,054 63% 294 Regional Police Academy 22,700 14 20,778 18,074 1,923 92% 295 COPS MORE Grant 150,258 2,366 40,282 7,264 109,976 27% 299 Police Federal Drug Enforcement 77,000 89 64,440 39,492 12,560 84% 404 County Option Income Tax 9,883,971 46,499 5,732,264 6,143,089 4,151,707 58% 408 Economic Development Income Tax 9,526,637 2,467 5,788,049 6,253,786 3,738,588 61% 410 Urban Development Action Grant 528,686 30 252,204 61 276,482 48% 655 Project Releaf 431,700 36,849 296,525 292,915 135,175 69% 705 Police K -9 Unit 2,000 - 1,514 1,004 486 76% Special Revenue Total 65,248,222 2,161,144 34,020,018 35,058,304 31,228,204 52% City Debt Service 313 Football Hall of Fame Debt Service 1,274,106 4,256 572,278 351,585 701,828 45% City Debt Service Total 1,274,106 4,256 572,278 351,585 701,828 45% Capital Project 377 Professional Sports Development 809,511 83 538,133 456,826 271,378 66% 401 Coveleski Stadium Capital 15,100 9 174 59 14,926 1% 403 Zoo Endowment 200 11 211 108 (11) 106% 405 Park Nonreverting Capital 143,700 748 10,544 20,358 133,156 7% 406 Cumulative Capital Development 542,691 4,459 292,907 287,639 249,784 54% 407 Cumulative Capital Improvement 422,350 48 268,236 273,672 154,114 64% 412 Major Moves Construction 811,187 418,790 801,002 284,740 10,185 99% 416 Morris Performing Arts Center Capital 101,500 4,718 39,914 51,127 61,586 39% 434 Community Revitalization Enhancement District 150 33 232 204 (82) 155% 450 Palais Royale Historic Preservation 16,150 879 7,927 5,019 8,223 49% 677 Football Hall of Fame Capital 2,500 119 2,337 1,415 163 93% Capital Project Total 2,865,039 429,898 1,961,617 1,381,169 903,422 68% Enterprise 287 Emergency Medical Services Capital 3,623,089 81 397,765 - 3,225,324 11% 288 Emergency Medical Services Operating 5,679,065 432,486 3,244,503 1,821,929 2,434,563 57% 600 Consolidated Building Fund 4,209,213 120,952 3,279,307 2,008,509 929,906 78% 601 Parking Garages 1,045,125 84,204 668,100 707,160 377,025 64% 610 Solid Waste Operations 5,712,289 412,143 3,542,617 3,526,441 2,169,672 62% 611 Solid Waste Capital 753,011 11,018 530,085 650,058 222,926 70% 620 Water Works Operations 14,780,483 1,513,184 9,435,758 9,713,514 5,344,725 64% 622 Water Works Capital 10,000 655 13,129 7,779 (3,129) 131% 623 Water Works Bond Capital 545 - 544 1,402 1 100% City of South Bend Monthly Department Financial Report REVENUE SUMMARY August 31, 2015 624 Water Works Customer Deposit 6,000 334 6,390 3,256 (390) 107% 625 Water Works Sinking 2,050,078 170,453 1,365,188 1,367,650 684,890 67% 626 Water Works Bond Reserve 9,500 359 3,788 71,952 5,712 40% 629 Water Works Reserve Operations & Maintenance 162,749 499 159,635 58,058 3,114 98% 640 Sewer Repair Insurance 554,800 49,270 410,042 390,423 144,758 74% 641 Sewage Works Operations 35,338,567 3,149,166 23,629,927 22,264,167 11,708,640 67% 642 Sewage Works Capital 5,398,000 4,001,402 8,021,165 4,011,496 (2,623,165) 149% 643 Sewage Works Reserve Operations & Maint. 271,612 821 271,531 137,452 81 100% 647 Sewer Bond 2007 - - - 3 - 0% 649 Sewage Sinking 9,288,088 774,495 6,200,976 6,205,013 3,087,112 67% 658 Sewer Bond 2010 - - 0 5 (0) 0% 659 Sewer Bond 2011 6,000 115 3,840 15,450 2,160 64% 661 Sewer Bond 2012 40,000 3,483 70,138 39,568 (30,138) 175% 664 2013A Cost of Issuance Fund 50 1 19 10 31 39% 670 Century Center 3,819,251 342,621 2,773,488 2,950,857 1,045,763 73% 671 Century Center Capital 500 - 366 233 134 73% 672 Century Center Energy Conservation Debt Svc 50,000 - 50,011 - (11) 100% Enterprise Total 92,808,015 11,067,742 64,078,312 55,952,386 28,729,703 69% Internal Service 222 Central Services 8,151,184 552,107 5,003,744 4,887,109 3,147,440 61% 224 Central Services Capital 271,850 - - - 271,850 0% 226 Liability Insurance 1,262,602 105,519 840,144 1,965,436 422,458 67% 278 Take Home Vehicle Police 124,200 9,150 85,315 85,672 38,885 69% 711 Self- Funded Employee Benefits 16,357,770 1,189,005 9,690,662 8,777,860 6,667,108 59% 713 Unemployment Compensation 113,796 8,527 68,824 68,791 44,972 60% Internal Service Total 26,281,402 1,864,308 15,6889689 159784,868 10,5929713 60% Trust & Agency 701 Firefighters Pension 5,044,525 1,364 2,525,407 2,565,390 2,519,118 50% 702 Police Pension 6,385,359 237 3,189,524 3,057,783 3,195,835 50% 730 City Cemetery 150 6 122 81 28 81% Trust & Agency Total 11,430,034 1,608 5,715,053 5,623,255 5,714,981 50% 252,729,296 146,463,958 9 Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 24,944,246 59,315 16,584,927 7,778,577 8,359,319 66% 420 Tax Incremental Financing (TIF) - Downtown - - - 2,941,026 - 0% 422 TIF - West Washington 422,800 305 200,975 305,541 221,825 48% 425 Redevelopment Retail & Leighton Plaza 189,423 6,162 106,761 107,111 82,662 56% 426 TIF - Central Medical Service Area - - - 465,620 - 0% 429 River East Development Area (NE Dev TIF) 3,829,653 1,623 2,865,995 814,936 963,658 75% 430 TIF - Southside Development #1 2,410,750 1,264 1,318,944 1,276,382 1,091,806 55% 435 TIF - Douglas Road 320,750 48 164,671 161,536 156,079 51% 436 River East Residential (NE Res TIF) 2,815,000 - 1,876,142 1,385,260 938,858 67% Tax Increment Financing Total 34,932,622 68,717 23,118,415 15,235,989 11,814,207 66% Redevelopment 433 Redevelopment General 252 2 43 39 209 17% 439 Certified Technology Park 33,904 888 20,448 8,120 13,456 60% 454 Airport Urban Enterprise Zone 1,500 85 1,622 830 (122) 108% 619 Blackthorn Operations 119,799 - 119,297 1,264,783 502 100% Redevelopment Total 155,455 975 141,410 1,273,772 14,045 91% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 232 4,457 2,289 543 89% 317 Coveleski Debt Service Reserve 1,800 113 2,170 1,110 (370) 121% 328 Redevelopment Bond - Palais Royale 6,000 387 7,447 3,824 (1,447) 124% 432 TIF - Southside Development #3 25,000 1,204 35,268 22,551 (10,268) 141% Debt Service Total 37,800 1,936 49,342 29,774 (11,542) 131% Redevelopment Commission Controlled Funds Total 71,628 23,309,167 16,539,535 11,816,710 66% , Grand Total 287,855,173 16,673,825 176,155,959 163,003,494 111,699,214 61% 3 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY August 31, 2015 City Funds General Fund 101 -0101 Mayor's Office 741,267 61,928 489,369 458,042 999 250,899 66% 101 -0104 311 Call Center 486,733 34,895 322,920 293,253 1,290 162,523 67% 101 -0201 City Clerk 431,573 27,161 235,890 229,752 14,979 180,704 58% 101 -0301 Common Council 490,150 25,524 324,649 214,900 35,052 130,448 73% 101 -0302 WNIT Contract 43,000 - 43,000 - - - 100% 101 -0401 Administration & Finance 2,008,924 124,777 1,212,235 1,377,003 16,287 780,402 61% 101 -0404 Morris Performing Arts Center 1,093,132 84,313 676,152 649,940 40,555 376,425 66% 101 -0405 Palais Royale 536,293 36,263 299,006 281,457 37,704 199,583 63% 101 -0501 Legal Department 1,018,599 70,735 618,158 658,510 6,716 393,725 61 101 -0602 Engineering 1,058,933 71,996 651,545 729,229 69,155 338,233 68% 101 -0801 Police Department 25,633,064 1,806,972 16,417,516 15,539,381 119,618 9,096,702 65% 101 -0802 Communications Center 1,687,540 257,268 1,164,214 1,351,805 514,520 8,806 99% 101 -0901 Fire Department 17,774,474 1,335,120 12,695,283 14,321,725 167,331 4,911,860 72% 101 -0905 Fire LOIT 2013 - 13,015 24,369 - - (24,369) 0% 101 -1008 Human Rights 373,179 26,959 247,889 226,965 5,461 119,829 68% 101 -1201 Code 2013 2,270 - - 851 2,269 1 100% 101 -0805 Police LOIT 2013 - 6,911 6,699 - - (6,699) 0% 101 -1205 Unsafe Building 2013 - - - 750 - - 0% 101 -1207 Animal Control 2013 - - - 180 - - 0% General Fund Total 53,379,131 3,983,839 35,428,895 36,333,743 1,031,935 16,919,073 68% Special Revenue 201 Parks & Recreation 11,063,995 871,789 7,583,750 8,188,970 205,301 3,274,944 70% 202 Motor Vehicle Highway 10,485,386 467,206 5,228,948 5,119,463 1,165,889 4,090,549 61% 203 Recreation Nonreverting 1,549,469 157,046 730,109 651,418 64,031 755,329 51 209 Studebaker - Oliver Reverting Grants 630,000 7,308 66,059 - 501,361 62,580 90% 210 Economic Development State Grants 3,694,412 3,435 464,105 36,005 791,339 2,438,968 34 211 Department of Community Investment (DCI) 2,661,730 188,871 1,630,940 1,512,169 44,050 986,740 63% 212 Dept of Community Investment Grants 6,547,968 142,648 1,719,196 2,555,417 4,043,968 784,804 88% 216 Police State Seizures 35,900 - - - - 35,900 0% 217 Gift, Donation, Bequest 297,182 - 81,093 13,736 217,552 (1,463) 100% 218 Police Curfew Violations 1,000 - - - - 1,000 0% 220 Law Enforcement Continuing Education 362,478 28,910 241,608 120,256 48,728 72,142 80% 227 Loss Recovery 5,237,243 1,245,020 3,656,604 690,616 1,446,720 133,920 97% 244 Emergency Phone System - - - 136,113 - - 0% 249 Public Safety LOIT 7,246,551 503,168 4,599,426 4,976,039 - 2,647,125 63% 251 Local Roads & Streets 2,126,221 210,035 557,533 300,213 1,280,163 288,524 86% 258 Human Rights Federal Grant 247,357 13,597 145,635 121,989 8,749 92,974 62% 271 Eastrace Waterway 4,000 1,900 3,998 9,092 0 2 100% 273 Morris PAC / Palais Royale Marketing 18,974 - 3,332 9,191 5,089 10,553 44% 289 HAZMAT 31,530 - 21,542 - - 9,988 68% 291 Indiana River Rescue 120,800 231 52,514 24,992 - 68,286 43% 292 Police Grants 105,145 - 15,297 138,059 - 89,848 15% 294 Regional Police Academy 23,750 712 26,467 12,544 - (2,717) 111% 295 COPS MORE Grant 172,335 7,135 37,425 11,314 10,271 124,639 28% 299 Police Federal Drug Enforcement 248,960 34,490 157,388 50,661 13,216 78,356 69% 404 County Option Income Tax 15,660,371 613,158 6,491,816 5,869,238 1,629,090 7,539,465 52% 408 Economic Development Income Tax 9,943,709 57,166 6,123,074 6,755,905 284,499 3,536,136 64% 410 Urban Development Action Grant 438,203 - 146,068 - - 292,135 33% 655 Project Releaf 528,358 2,796 69,464 69,284 - 458,894 13% 705 Police K -9 Unit 2,000 - 970 - - 1,030 49% Special Revenue Total 79,485,027 4,556,621 39,854,360 37,372,685 11,760,015 27,870,652 65% City Debt Service 313 Football Hall of Fame Debt Service 1,266,820 - 1,272,000 1,270,500 - (5,180) 100% City Debt Service Total 1,266,820 - 1,272,000 1,270,500 - (5,180) 100% Capital Project 377 Professional Sports Development 855,603 - 855,603 865,545 - - 100% 403 Zoo Endowment 49,000 - - - - 49,000 0% 405 Park Nonreverting Capital 192,933 7,278 65,236 159,215 7,684 120,012 38% 406 Cumulative Capital Development 542,691 - 474,118 474,118 - 68,573 87% 407 Cumulative Capital Improvement 365,625 - 367,875 369,000 - (2,250) 101 412 Major Moves Construction 3,096,061 318,492 1,765,243 1,250,082 1,254,219 76,599 98% 416 Morris Performing Arts Center Capital 70,248 888 42,154 14,819 11,264 16,830 76% 434 Community Revitalization Enhancement District 650,000 - 7,794 20,975 - 642,206 1% 450 Palais Royale Historic Preservation 16,150 - - - - 16,150 0% 677 Football Hall of Fame Capital 188,824 2,860 35,665 51,748 - 153,159 19% Capital Project Total 6,027,135 329,518 3,613,688 3,205,501 1,273,167 1,140,280 81% 4 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY August 31, 2015 City Funds Enterprise 287 Emergency Medical Services Capital 750,000 23,659 59,387 - 612,086 78,527 90 288 Emergency Medical Services Operating 6,855,366 483,130 2,862,622 4,174,208 16,309 3,976,435 42% 600 Consolidated Building Fund 4,205,401 292,139 2,182,155 2,016,904 543,168 1,480,079 65% 601 Parking Garages 1,806,712 38,267 649,510 519,661 69,904 1,087,298 40% 610 Solid Waste Operations 5,873,863 428,284 3,712,497 3,996,744 83,146 2,078,220 65 611 Solid Waste Capital 752,811 (121) 553,569 767,901 - 199,242 74% 620 Water Works Operations 15,844,471 1,219,255 9,561,920 9,562,200 399,803 5,882,748 63 622 Water Works Capital 838,893 - 221,445 16,203 8,075 609,373 27 623 Water Works Bond Capital 53,330 - 183,082 524,356 - (129,752) 343% 624 Water Works Customer Deposit 6,000 334 5,536 3,216 - 464 92% 625 Water Works Sinking 2,050,078 578 368,968 385,790 - 1,681,110 18% 626 Water Works Bond Reserve 14,500 - 7,374 - - 7,126 51 629 Water Works Reserve Operations & Maintenance 8,500 499 8,204 4,551 - 296 97 640 Sewer Repair Insurance 545,703 44,704 319,139 291,347 33,932 192,632 65 641 Sewage Works Operations 40,196,974 6,233,439 26,763,918 22,701,341 1,165,283 12,267,773 69% 642 Sewage Works Capital 7,071,710 430,722 2,009,123 3,114,604 1,831,783 3,230,804 54% 643 Sewage Works Reserve Operations & Maim. 15,000 821 13,470 7,488 - 1,530 90 647 Sewer Bond 2007 - 0 0 1,143 - (0) 0 649 Sewage Sinking 9,282,109 350 1,592,661 1,675,052 - 7,689,448 17% 658 Sewer Bond 2010 - - 2 924 - (2) 0 659 Sewer Bond 2011 3,711,838 251 1,085,608 3,105,288 452,526 2,173,704 41 661 Sewer Bond 2012 16,624,275 398,397 1,751,939 523,779 2,009,247 12,863,090 23% 664 2013A Cost of Issuance Fund - - - - - - 0 670 Century Center 4,532,562 337,516 2,649,633 2,620,391 - 1,882,929 58 671 Century Center Capital 605,656 4,190 338,521 339,363 - 267,135 56% Enterprise Total 121,645,752 9,936,415 56,900,282 56,352,456 7,225,262 57,520,208 53% Internal Service 222 Central Services 8,300,242 548,951 4,954,172 4,833,746 820,639 2,525,431 70% 224 Central Services Capital 271,850 - - - 28,196 243,654 10 226 Liability Insurance 3,056,791 70,834 2,094,992 1,849,233 33,759 928,040 70 278 Take Home Vehicle Police 71,100 - 1,086 - - 70,014 2 711 Self- Funded Employee Benefits 16,696,935 1,246,018 9,166,892 9,898,357 174,498 7,355,545 56% 713 Unemployment Compensation 226,796 5,122 61,393 102,863 11,000 154,403 32 Internal Service Total 28,623,714 1,870,926 16,278,535 16,684,198 1,068,093 11,277,086 61 Trust & Agency 701 Firefighters Pension 5,666,579 433,690 3,493,659 3,624,882 - 2,172,920 62% 702 Police Pension 6,832,235 528,170 4,251,050 4,556,589 - 2,581,185 62% 730 City Cemetery 20,000 - - 8,658 - 20,000 0 Trust & Agency Total 12,518,814 961,860 7,744,709 8,190,129 - 4,774,105 62 City Funds Total Redevelopment Commission Controlled Funds - Tax Increment Financing 324 River West Development Area (Airport TIF) 47,710,597 2,886,042 14,079,485 5,299,856 12,374,929 21,256,183 55 420 Tax Incremental Financing (TIF) - Downtown 4,088,473 - 4,088,473 3,096,252 - - 100 422 TIF - West Washington 760,900 - 30,294 679 3,366 727,240 4 425 Redevelopment Retail & Leighton Plaza 154,716 8,589 83,257 90,475 - 71,459 54 426 TIF - Central Medical Service Area 2,294,533 - 2,294,533 1,781,574 - - 100% 429 River East Development Area (NE Dev TIF) 7,239,524 56,721 205,706 1,475 231,896 6,801,922 6 430 TIF- Southside Development #1 2,842,535 262,737 879,854 553,913 394,572 1,568,109 45% 435 TIF - Douglas Road 345,389 171,567 341,187 395,621 4,200 2 100% 436 River East Residential (NE Res TIF) 3,425,632 246,589 3,425,628 3,330,291 - 4 100% Tax Increment Financing Total 68,862,299 3,632,245 25,428,417 14,550,136 13,008,963 30,424,919 56% Redevelopment 433 Redevelopment General 6,000 - - 15,703 - 6,000 0 439 Certified Technology Park 5,000,000 506,250 1,793,668 - 1,726,115 1,480,217 70% 619 Blackthorn Operations 201,649 - 201,228 1,079,405 - 421 100% Redevelopment Total 5,207,649 506,250 1,994,896 1,095,108 1,726,115 1,486,638 71% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 232 3,857 2,289 - 1,143 77 328 Redevelopment Bond - Palais Royale 6,000 387 6,445 3,824 - (445) 107 432 TIF- Southside Development #3 691,380 - 690,104 492,151 - 1,276 100% Debt Service Total 702,380 619 700,406 498,264 - 1,974 100% Redevelopment�on Controlled Funds Total 4,772,328 28,123,719 1�"" 14,735,078 31,913,531 Grand Total 377,718,721 25,778,293 189,216,188 175,552,720 37,093,550 151,409,755 60% R 2015 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Fund /Department Number 101 -0101 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior 457,962 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 740,567 61,928 489,249 457,962 251,318 66% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 50 70 20 (20) 140% Interest Earnings - - - - 0% Bond Proceeds - - - - 0% Donations 50 50 60 (0) 100% Other Income 600 - - 600 0% Transfers In - - - - - 0% Total Revenue 741,267 61,928 489,369 458,042 251,898 66% Expenditures Personnel 669,877 58,159 452,865 407,750 - 217,012 68% Supplies 12,413 1,030 7,619 14,077 985 3,810 69% Services 56,739 2,593 27,338 34,674 14 29,387 48% Debt Service 2,238 147 1,548 1,541 - 690 69% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 741,267 61,928 489,369 458,042 999 250,899 66% Net - - - (999) 999 Cash Balance Staffing Full Time 7.00 7.00 7.00 Part-Time /Seasonal /Temporary 2.00 1.00 1.00 Total 9.00 8.00 8.00 txpiam signfficant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: Expenditures are in line with budgeted expectations for 2015. Personnel Services category higher due to three pay periods occurring last month. txpiam signrncant spenamg on t apnai vrotecis tseiow: There are no capital projects budgeted for 2015. Form 3 6 2015 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center Fund /Department Number 101 -0104 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior (26,509) Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue (26,509) 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations - - - - 0% Other Income 486,733 34,895 322,920 319,763 163,813 66% Transfers In - - - - - 0% Total Revenue 486,733 34,895 322,920 293,253 163,813 66% Expenditures Personnel 441,562 33,197 293,501 266,629 148,061 66% Supplies 6,125 - 1,537 12,789 - 4,588 25% Services 39,046 1,698 27,882 13,835 1,290 9,874 75% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 486,733 34,895 322,920 293,253 1,290 162,523 67% Net - - - (1,290)1 1,290 Cash Balance Staffing Full Time 6.50 6.50 6.50 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 7.50 7.50 7.50 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: txpiam signmcant spenamg on t apnai vrotects tseiow: No capital expenditures budgeted in 2015. Form 3 7 2015 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Fund /Department Number 101 -0201 Month Au ust Date Updated 9/14/2015 Current Current Current Prior 229,752 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 431,573 27,161 235,890 229,752 195,683 55% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 431,573 27,161 235,890 229,752 195,683 55% Expenditures Personnel 339,442 23,725 209,430 194,000 - 130,012 62% Supplies 7,740 24 1,197 7,027 1,000 5,543 28% Services 70,991 3,413 25,264 28,726 13,979 31,748 55% Debt Service - - - - - - 0% Capital 13,400 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 431,573 27,161 235,890 229,752 14,979 180,704 58% Net - - - (14,979)1 14,979 Cash Balance Staffing Full Time 5.00 5.00 5.00 Part -Time /Seasonal /Temporary - - - Total 5.00 5.00 5.00 txpiam signmcant ttevenue, txpenanure ana statrm Expenditures are consistent with normal operating costs. txpiam signrcicant spenamg on t apnai vrotecis tseiow: This year, a copier has been budgeted for capital expenditures. tseiow: Form 3 8 2015 City of South Bend Monthly Financial Report Fund /Department Name Common Council Fund /Department Number 101 -0301 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior 214,304 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 481,484 25,493 324,193 214,304 157,291 67% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 8,466 31 256 596 8,210 3% Other Income 200 - 200 - - 100% Transfers In - - - - - 0% Total Revenue 490,150 25,524 324,649 214,900 165,501 66% Expenditures Personnel 243,742 17,421 144,950 137,348 7,372 91,420 62% Supplies 4,706 544 2,048 306 89 2,569 45% Services 241,702 7,559 177,650 77,245 27,592 36,460 85% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 490,150 25,524 324,649 214,900 35,052 130,449 73% Net - (35,052)1 35,052 Cash Balance Staffing Full Time 9.00 9.00 9.00 Part -Time /Seasonal /Temporary - - - Total 9.00 9.00 9.00 txpiam signmcant ttevenue, txpenanure ana starting cnangesivanances tseiow: There are nine (9) Council Members. One member has declined to receive a salary. Expenditures higher than normal due to unforseen legal expenses. Explain Significant Spending on Capital Projects Below: Form 3 9 2015 City of South Bend Monthly Financial Report Fund /Department Name WNIT Contract Fund /Department Number 101 -0302 Month Au ust Date Updated 9/11/2015 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 43,000 43,000 100% Local Income Taxes - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In - - 0% Total Revenue 43,000 43,000 100% Expenditures Personnel - - 0% Supplies - - 0% Services 43,000 43,000 100% Debt Service - - 0% Capital 0% Transfers Out - - 0% Total Expenditures 43,000 - 43,000 100% Cash Balance Staffing Full Time Part -Time /Seasonal /Temporary Total txpiam signrcicant ttevenue, txpenanure ana stattmg cnangesivanances tseiow: This annual expenditure was previously paid from the Council department (101 -0301) but was segregated upon the Council's request. The invoice was received 1 April and was paid 1 May. Explain Significant Spending on Capital Projects Below: Form 3 10 2015 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Fund /Department Number 101 -0401 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior 1,376,174 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 2,008,324 124,777 1,211,679 1,376,174 796,645 60% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 600 556 829 44 93% Transfers In - - - - - 0% Total Revenue 2,008,924 124,777 1,212,235 1,377,003 796,689 60% Expenditures Personnel 1,796,651 118,988 1,104,074 1,165,255 - 692,577 61% Supplies 38,109 1,191 21,635 22,344 1,931 14,543 62% Services 171,593 4,599 84,598 187,476 14,356 72,639 58% Debt Service 2,571 - 1,928 1,928 - 643 75% Capital - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,008,924 124,777 1,212,235 1,377,003 16,287 780,402 61% Net - - - (16,287)1 16,287 Cash Balance Staffing Full Time 22.00 19.00 Part -Time /Seasonal /Temporary - 2.00 Total 22.00 21.00 txpiam signrcicant ttevenue, txpenanure ana starring cnangesivanances tseiow: Transferred Chief Technology Officer to COIT for 2015 budget and added new HR Generalist position. Overall spending appears consistent with expectations. Full time excludes 3 IT /Innovation employees who are paid from COIT. txpiam signrcicant spenamg on t apnai vrotecis tseiow: None Form 3 11 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Fund /Department Number 101 -0404 Month Au ust Date Updated 1 9/11/2015 Current Current Current Prior (2,192) Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 170,132 65,332 255,945 (2,192) (85,813) 150% Local Income Taxes - - - 0% Other Taxes 0% Grants /Intergovernmental - - - 0% Charges for Services 917,000 18,957 416,547 646,959 500,453 45% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 6,000 23 3,660 5,173 2,340 61% Transfers In - - - - - 0% Total Revenue 1,093,132 84,313 676,152 649,940 416,980 62% Expenditures Personnel 749,285 56,372 486,113 453,585 7,101 256,071 66% Supplies 33,542 881 12,608 13,032 33,454 (12,519) 137% Services 310,305 27,059 177,432 183,323 - 132,873 57% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 1,093,132 84,313 676,152 649,940 40,555 376,425 j 66% Net - - - - (40,555)1 40,555 Cash Balance Staffing Full Time 12.00 12.00 Part-Time /Seasonal /Temporary 4.00 4.00 Total 16.00 16.00 txpiam signmcant ttevenue, txpenanure ana starting cnangesivanances tseiow: Royal Box Leasing revenue is expected to be received in the month of December and not in March as in previous years. txpiam signmcant spenamg on t apnai vrotecis tseiow: There are no Capital Expenses budgeted for this year. This is an Operating Budget. By Ordinance, Fund 416 is used to support renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons at the Morris Performing Arts Center. There are no Capital Expenses / Projects budgeted this year. Form 3 12 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Fund /Department Number 101 -0405 Month Au ust Date Updated 1 9/11/2015 Current Current Current Prior 133,674 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 201,023 12,538 112,753 133,674 50,566 56% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 316,270 22,739 175,493 138,921 140,777 55% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 19,000 987 10,759 8,862 8,241 57% Transfers In - - - - - 0% Total Revenue 536,293 36,263 299,006 281,457 199,583 56% Expenditures Personnel 263,505 17,905 164,122 157,387 - 99,383 62% Supplies 23,897 580 5,029 4,290 4,968 13,900 42% Services 234,891 17,778 118,780 119,780 31,736 84,376 64% Debt Service - - - - - - 0% Capital 14,000 11,075 1,000 1,925 86% Transfers Out - - - - - - 0% Total Expenditures 536,293 36,263 299,006 281,457 37,704 199,583 j 63% Net - - - (37,704) Cash Balance Staffing Full Time 2.00 2.00 2.00 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: txpiam signmcant spenamg on t apnai vrotects tseiow: AN Upgrades (screen, projector, computer). Curtain replacement project ($30,000.00) defer to 2016. Form 3 13 2015 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Fund /Department Number 101 -0501 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 965,099 70,735 599,532 656,887 365,567 62% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 3,000 1,581 3,000 0% Bond Proceeds - - - 0% Donations - - - - 0% Other Income 50,500 18,626 42 31,874 37% Transfers In - - - - - 0% Total Revenue 1,018,599 70,735 618,158 658,510 400,441 61% Expenditures Personnel 948,013 64,504 581,267 629,884 - 366,746 61% Supplies 6,832 271 4,029 2,297 15 2,788 59% Services 62,454 5,642 31,909 25,376 6,382 24,163 61% Debt Service 1,300 318 953 953 319 28 98% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,018,599 70,735 618,158 658,510 6,716 393,725 61% Net - - - (6,716) 6,716 Cash Balance Staffing Full Time 11.60 11.60 Part -Time /Seasonal /Temporary - - Total 11.60 11.60 txpiam signmcant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: The Other Income of $50,000 is reimbursement for legal expenses from TIF funds which will be received in December 2015. Encumbrances are the reason the expenses appear higher for August 2015. The encumbrances relate to subscriptions paid monthly and debt sevices paid quarterly. Spending appears to be on track with budgeted figures. Explain Significant Spending on Capital Projects Below: Form 3 14 2015 City of South Bend Monthly Financial Report Fund /Department Name Engineering Fund /Department Number 101 -0602 Month Au ust Date Updated 1 9/11/2015 Current Current Current Prior 709,568 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 981,906 71,371 648,378 709,568 333,528 66% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 77,027 625 3,167 19,662 73,860 4% Transfers In - - - - - 0% Total Revenue 1,058,933 71,996 651,545 729,229 407,388 62% Expenditures Personnel 710,552 55,078 442,617 405,682 - 267,935 62% Supplies 29,262 1,923 21,276 13,759 439 7,548 74% Services 306,044 14,347 178,556 303,384 68,069 59,420 81% Debt Service 13,075 648 9,097 6,405 648 3,330 75% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,058,933 71,996 651,545 729,229 69,155 338,233 68% Net - - - (69,155)1 69,155 Cash Balance Staffing Full Time 7.90 7.80 Part -Time /Seasonal /Temporary 1.22 0.90 Total 9.12 8.70 txpiam bigmncant ttevenue, txpenanure ana btattmg L;nangesivanances tseiow: $68,069 in encumbrance for Services include $54,000 for water system evaluation and $5,600 for education and training. Other income includes reimbursement from the River West (f /k /a Airport) TIF for 80% of the salary of a new engineer who began near the end of May. Explain Significant Spending on Capital Projects Below: Form 3 15 Form 3 16 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Department IMonth Au ust Fund /Department Number 101 -0801 Date Updated 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 25,077,864 1,763,755 16,265,978 15,341,106 8,811,886 65% Local Income Taxes - - - - - 0% Other Taxes - 0% Grants /Intergovernmental - - 24,316 0% Charges for Services 200,000 759 200 199,241 0% Interest Earnings - - - - 0% Bond Proceeds - - 0% Donations 7,500 - - - 7,500 0% Other Income 347,700 43,217 150,779 173,758 196,921 43% Transfers In - - - - - 0% Total Revenue 25,633,064 1,806,972 16,417,516 15,539,381 9,215,548 64% Expenditures Personnel 22,809,224 1,632,687 14,662,907 13,214,499 8,146,317 64% Supplies 499,279 38,188 300,053 448,610 51,023 148,203 70% Services 2,316,561 135,661 1,450,194 1,808,372 68,595 797,772 66% Debt Service 8,000 436 4,342 2,742 - 3,658 54% Capital - - 20 65,158 (20) 0% Transfers Out - - - - - - 0% Total Expenditures 25,633,064 1,806,972 16,417,516 15,539,381 119,618 9,095,930 65% Net - - - (119,618)1 119,618 Cash Balance Staffing Full Time 263.00 255.00 255.00 Part -Time /Seasonal /Temporary 60.00 34.00 34.00 Total 323.00 289.00 289.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund includes the expenditures for 217 of the 260 budgeted Police officers and 106 civilian staff. Fund 249 contains the funding for 43 of the 260 Police officers that are funded by the LOIT. The 2015 Personnel Expenditure exceeds the prior year amount due to the increase in Police salaries and the transfer of eight Front Desk Staff from the Communications Budget to the Police Budget in 2015. Supplies and Services expenditures show 70% and 66% of the Budget as used year to date. These categories are expected to be on budget for the year. Explain Significant Spending on Capital Projects Below: Form 3 16 2015 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Fund /Department Number 101 -0802 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior 1,351,805 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 1,687,540 257,268 1,164,214 1,351,805 523,326 69% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,687,540 257,268 1,164,214 1,351,805 523,326 69% Expenditures Personnel 143,972 8 135,174 1,343,696 8,798 94% Supplies - - - 1,362 - - 0% Services 1,543,568 257,260 1,029,040 6,747 514,520 8 100% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 1,687,540 257,268 1,164,214 1,351,805 514,520 8,806 99% Net - - - (514,520)1 514,520 Cash Balance Staffing Full Time Part -Time /Seasonal /Temporary Total txpiam signmcant ttevenue, txpenanure ana starting cnangesivanances tseiow: Prior to December 31, 2014, this fund captured the cost of 35 of the 38 civilians and equipment to maintain the 911 communication center. Effective January 1, 2015 the County PSAP has consolidated the 911 call centers and SBPD no longer maintains a call center. The Personnel costs in January are the 2014 salary costs for the Communications staff paid in 2015. There are no additional salaries to be paid. The Services budget of $1,543,568 is the annual amount that the County will charge SBPD as a participant in using the PSAP. Explain Significant Spending on Capital Projects Below: Form 3 17 2015 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Fund /Department Number 101 -0901 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior 12,962,740 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 17,636,174 1,334,658 12,559,703 12,962,740 5,076,471 71% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 131,000 462 127,125 358,525 3,875 97% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 7,300 8,455 460 (1,155) 116% Transfers In - - - 1,000,000 - 0% Total Revenue 17,774,474 1,335,120 12,695,283 14,321,725 5,079,191 71% Expenditures Personnel 15,737,086 1,226,151 11,723,492 12,956,521 89,318 3,924,275 75% Supplies 320,618 8,288 90,873 245,929 23,496 206,249 36% Services 1,216,770 100,682 880,918 1,119,274 54,516 281,336 77% Debt Service - - - - - 0% Capital - - - 0% Transfers Out 500,000 - - - - 500,000 0% Total Expenditures 17,774,474 1,335,120 12,695,283 14,321,725 167,331 4,911,860 72% Net - - - (167,331) 167,331 Cash Balance btatrmg Full Time 170.00 170.00 170.00 Part-Time /Seasonal /Temporary - - - Total 170.00 170.00 170.00 txpiam signfficant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: The South Bend Fire Department is budgeted to have 251 sworn firefighters and 7 civilian full time employees. 37 firefighters are paid directly through the Public Safety LOIT. 47 Sworn Employee's and 4 civilian employee's costs are allocated to Fund 288 EMS Operations. We hold a lengthy recruitment process every 2 years and hire individuals in groups of 6 -10 as needed while that list is in effect. We also employ civilian administrative staff that handle payroll, purchasing and billing for our ambulance service. txpiam signrcicant spenamg on t apnai vrotecis tseiow: The Fire Department uses EMS Capital Fund 287 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through that fund. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Form 3 18 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Fund /Department Number 101 -1008 Month Au ust Date Updated 1 9/11/2015 Current Current Current Prior 226,965 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 373,179 26,959 247,889 226,965 125,290 66% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 373,179 26,959 247,889 226,965 125,290 66% Expenditures Personnel 286,475 22,034 195,901 182,869 - 90,574 68% Supplies 2,010 123 799 926 400 811 60% Services 73,492 4,802 40,782 43,171 5,061 27,649 62% Debt Service - - - - - - 0% Capital 11,202 10,407 795 93% Transfers Out - - - - - - 0% Total Expenditures 373,179 26,959 247,889 226,965 5,461 119,829 68% Net - - - (5,461) 5,461 Cash Balance Staffing Full Time 4.00 4.00 4.00 Part -Time /Seasonal /Temporary - - - Total 4.00 4.00 4.00 txpiam signmcant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: Expenditures are consistent with normal operating costs. This month, there were three pay periods. txpiam signrcicant spenamg on t apnai vrotecis tseiow: Human Rights had money encumbered from last year for a copier. Purchase was made in January. Form 3 19 Form 3 20 2015 City of South Bend Monthly Financial Report Fund /Department Name Rainy Day Month Au ust Fund /Department Number 102 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 34,680 1,936 37,135 19,001 (2,455) 107% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In - - - 0% Total Revenue 34,680 1,936 37,135 19,001 (2,455) 107% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - - 0% Net 34,680 1,936 37,135 19,001 (2,455) Cash Balance 8,679,324 8,636,706 Staffing Full Time - - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: No significant changes at this time. No expenditures are budgeted in this fund. The establishment of a Rainy Day Fund is looked upon favorably by bond rating agencies and is one of the factors resulting in South Bend's good AA bond rating with Standard & Poor's. Explain Significant Spending on Capital Projects Below: N/A Form 3 20 Form 3 21 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Levy Month Au ust Fund /Department Number 103 Date Updated 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 20 1 12 8 62% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 20 1 12 8 62% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - 0% Net 20 1 12 8 Cash Balance 3,660 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: A small excess of property tax was received in December 2014. The balance will be rolled into the General Fund in 2016. Explain Significant Spending on Capital Projects Below: N/A Form 3 21 Form 3 22 2015 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation IMonth Au ust Fund /Department Number 201 1 1 Date Updated 9/17/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 7,340,000 4,145,751 4,021,603 3,194,249 56% Local Income Taxes - - - - 0% Other Taxes 1,510,875 73,736 917,237 810,702 593,638 61% Grants /Intergovernmental - - - - - 0% Charges for Services 2,025,640 301,215 1,391,002 1,453,377 634,638 69% Interest Earnings 10,000 736 8,046 5,417 1,954 80% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 144,200 37,732 130,922 96,791 13,278 91% Transfers In - - - - - 0% Total Revenue 11,030,715 413,419 6,592,958 6,387,889 4,437,757 60% Expenditures Personnel 7,105,699 621,582 4,679,159 4,831,219 2,908 2,423,632 66% Supplies 1,109,836 83,444 703,660 854,400 154,453 251,723 77% Services 2,443,703 164,897 2,050,475 2,330,208 47,939 345,289 86% Debt Service 309,257 1,866 150,456 168,143 - 158,801 49% Capital - - - 5,000 - 0% Transfers Out 95,500 - - - - 95,500 0% Total Expenditures 11,063,995 871,789 7,583,750 8,188,970 205,301 3,274,944 70% Net (33,280) (458,370) (990,792) (1,801,081) (205,301) 1,162,812 Cash Balance 2,532,663 2,427,789 Staffing Full Time 90.00 89.00 89.00 Part-Time /Seasonal /Temporary na 237.00 237.00 Total 90.00 326.00 326.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Fund 201 accounts for the annual operation of the Parks and Recreation Department. There are six divisions within the department: Administration, Maintenance, Golf, Recreation, Greenhouse, and Graffiti. In 2014 the Potawatomi Zoo began operation by the Potawatomi Zoological Society. Part time staffing is individuals, not FTEs. Property tax and other tax revenues are received in June and December of the year. Explain Significant Spending on Capital Projects Below: Because of decreasing property tax revenues, there is no capital budget in fund 201. A $5.6 million bond has been approved and funding is expected to be received in the second quarter of 2015. Form 3 22 2015 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Fund /Department Number 202 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 5,697,000 974,506 4,175,931 3,709,074 1,521,069 73% Grants /Intergovernmental - - 0% Charges for Services 265,000 5,719 220,240 246,443 44,760 83% Interest Earnings 9,500 996 18,242 7,244 (8,742) 192% Bond Proceeds - 0% Donations - 0% Other Income 27,300 24,477 38,948 2,823 90% Transfers In 3,703,000 1,676,500 1,483,291 2,026,500 45% Total Revenue 9,701,800 981,221 6,115,390 5,485,000 3,586,410 63% Expenditures Personnel 4,314,548 256,176 2,488,207 2,584,144 1,826,341 58% Supplies 2,631,854 52,597 1,183,939 940,448 458,455 989,461 62% Services 2,951,520 158,433 1,292,775 1,297,590 707,434 951,310 68% Debt Service 448,006 224,570 163,250 223,436 50% Capital 139,458 39,458 134,030 100,000 28% Transfers Out - - - - - - 0% Total Expenditures 10,485,386 467,206 5,228,948 5,119,463 1,165,889 1 4,090,549 1 61% Cash Balance 4,782,428 Staffing Full Time 52.65 50.65 Part -Time /Seasonal /Temporary 4.98 2.24 Total 57.63 52.89 txpiam signmcant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: Information included for Streets, Traffic & Lighting, and Curb & Sidewalk. Explain Significant Spending on Capital Projects Below: Form 3 23 Form 3 24 2015 City of South Bend Monthly Financial Report Fund /Department Name Recreation Nonrevertin Month Au ust Fund /Department Number 203 1 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 1,530,935 169,401 741,345 690,351 789,590 48% Interest Earnings 3,000 191 3,717 1,853 (717) 124% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 45,000 11,988 46,897 35,120 (1,897) 104% Transfers In - - - - - 0% Total Revenue 1,578,935 181,580 791,959 727,325 786,976 50% Expenditures Personnel 737,842 55,606 361,113 339,141 - 376,729 49% Supplies 289,470 46,801 182,417 125,594 49,566 57,486 80% Services 522,157 54,640 183,029 186,682 14,465 324,663 38% Debt Service - - - - - - 0% Capital - 0% Transfers Out - - 3,550 - - (3,550) 0% Total Expenditures 1,549,469 157,046 730,109 651,418 64,031 755,329 51% Net 29,466 24,534 61,850 75,907 (64,031) 31,647 Cash Balance 886,645 854,156 Staffing Full Time 1.00 1.00 1.00 Part -Time /Seasonal /Temporary - 54.00 54.00 Total 1.00 55.00 55.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund accounts for Parks and Recreation programs and events that are self funded through user fees. Registration for spring program, classes and softball leagues began in February.Part time employees are individuals, not FTEs. Explain Significant Spending on Capital Projects Below: Form 3 24 2015 City of South Bend Monthly Financial Report Fund /Department Name Studebaker - Oliver Reverting Grants Fund /Department Number 209 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 640,000 7,308 86,059 553,941 13% Charges for Services - - - - - 0% Interest Earnings 4,000 247 4,697 2,389 (697) 117% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 644,000 7,555 90,756 2,389 553,244 14% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 630,000 7,308 66,059 501,361 62,580 90% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 630,000 7,308 66,059 501,361 1 62,580 1 90% Cash Balance 1,111,162 1,085,776 Staffing Full Time - Part -Time /Seasonal /Temporary Total txpiam signrcicant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: The $640,000 represents a Brownfield Assessment Grant awarded by EPA for use in South Bend , Mishawaka and St. Joseph County. Consultant work proceeding. Explain Significant Spending on Capital Projects Below: Form 3 25 Form 3 26 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants I JMonth Au ust Fund /Department Number 210 1 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 3,600,000 400,000 3,200,000 11% Charges for Services - - - - - 0% Interest Earnings 13,544 35 7,215 7,925 6,329 53% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 59,966 29,759 28,883 30,207 50% Transfers In - - - - - 0% Total Revenue 3,673,510 35 436,974 36,808 3,236,536 12% Expenditures Personnel - - - - - 0% Supplies - - - - 0% Services 1,622,400 3,435 28,100 - 1,594,300 2% Debt Service 72,012 - 36,005 36,005 36,007 50% Capital 2,000,000 400,000 - 791,339 808,661 60% Transfers Out - - - - - - 0% Total Expenditures 3,694,412 3,435 464,105 36,005 791,339 2,438,968 34% Net (20,902) (3,400) (27,131) 803 (791,339)1 797,568 Cash Balance 302,302 349,753 Staffing Full Time - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: No significant issues. We received a grant from the IDGF in 2014 in the amount of $2,000,000 to be used for Ignition Park Infrastructure. $1,600,000 of this grant remains. An additional $2,000,000 state grant has been awarded for the ND Turbo Project. Explain Significant Spending on Capital Projects Below: Capital expenditures shown here are for the ND Turbo Project. Form 3 26 Form 3 27 2015 City of South Bend Monthly Financial Report Fund /Department Name Department of Community Investment (DCI) IMonth Au ust Fund /Department Number 211 1 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 416,787 1,951 10,680 414,836 0% Charges for Services - - - - - 0% Interest Earnings 2,500 203 4,711 2,046 (2,211) 188% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 247,500 62,757 228,616 252,921 18,884 92% Transfers In 1,967,638 - 983,819 1,266,719 983,819 50% Total Revenue 2,634,425 62,960 1,219,097 1,532,366 1,415,328 46% Expenditures Personnel 2,120,943 154,844 1,319,541 1,316,814 8,985 792,417 63% Supplies 35,753 1,853 22,197 25,645 2,306 11,250 69% Services 505,034 32,174 289,202 169,710 32,759 183,073 64% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 2,661,730 188,871 1,630,940 1,512,169 44,050 986,740 63% Net (27,305) (125,911) (411,843) 20,197 (44,050)1 428,588 Cash Balance 662,920 927,511 Staffing Full Time 25.00 24.00 24.00 Part-Time /Seasonal /Temporary - - - Total 25.00 24.00 24.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Fund covers operations of the Department of Community Investment. Transfers In come from EDIT on a quarterly basis. One position vacated in August. In the process of finding a replacement, though likely won't be finalized until October. Explain Significant Spending on Capital Projects Below: Form 3 27 2015 City of South Bend Monthly Financial Report Fund /Department Name Dept of Community Investment Grants Fund /Department Number 212 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 5,525,000 317,808 1,336,666 2,090,054 4,188,334 24% Charges for Services - - - - - 0% Interest Earnings 2,000 189 1,475 1,339 525 74% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 363,000 57,358 256,588 320,329 106,412 71% Transfers In - - - - - 0% Total Revenue 5,890,000 375,355 1,594,729 2,411,722 4,295,271 27% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Grants 6,547,968 142,648 1,719,196 2,555,417 4,043,968 784,804 88% Transfers Out - - - - - - 0% Total Expenditures 6,547,968 142,648 1,719,196 2,555,417 4,043,968 784,804 88% Net (657,968) 232,707 (124,467) (143,695) (4,043,968)1 3,510,467 Cash Balance 667,695 446,507 Staffing Full Time - - Part -Time /Seasonal /Temporary cxpiam aignmcant Mevenue, r-xpenuiture anu atarrmg t,nangesivariances aeiow: This fund covers multiple federal grants. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on -going and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 28 2015 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Fund /Department Number 216 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 35,000 14,314 23,533 20,686 41% Charges for Services - - - - - 0% Interest Earnings 450 43 805 354 (355) 179% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 600 - - 600 0% Transfers In - - 0% Total Revenue 36,050 43 15,119 23,887 20,931 42% Expenditures Personnel - - - - - 0% Supplies - 0% Services 35,900 35,900 0% Debt Service - - 0% Capital - 0% Transfers Out 0% Total Expenditures 35,900 35,900 0% Nat 15n d3 15 11Q 93 RR7 - /1d QRQI Cash Balance 0 202,551 1 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam signmcant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: Revenue stream is not a steady flow. It is dependent upon the processing and release of funds from the State for seized assets in drug activities. Expenditures are to be used to support the Police Departments effort to combat drug activity. Explain Significant Spending on Capital Projects Below: Form 3 29 Form 3 30 2015 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest I JMonth Au ust Fund /Department Number 217 1 Date Updated 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 800 13 419 191 381 52% Bond Proceeds - - - - - 0% Donations 398,000 63 3,448 171,113 394,552 1% Other Income - - - - - 0% Transfers In - - - - - 0% Total Revenue 398,800 76 3,867 171,304 394,933 1% Expenditures Personnel - - - - - - 0% Supplies 1,552 - 13,736 1,552 0 100% Services 295,630 81,093 - 216,000 (1,463) 100% Debt Service - - - 0% Capital 0% Transfers Out - - - - 0% Total Expenditures 297,182 81,093 13,736 217,552 1 (1,463) 100% Net 101,618 76 (77,227) 157,568 (217,552)1 396,397 Cash Balance 60,712 232,302 Staffing Full Time - - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The Gift, Donation, and Bequest fund may be used by all City departments but, normally, the majority of donations are for Animal Care and Control and Community Investment (i.e. bicycle signs). In 2015, the second half of a grant for V &A housing in the amount of $216,000 is expected and will be used to remediate or demolish qualifying structures. The $216,000 was encumbered in August. Explain Significant Spending on Capital Projects Below: None Form 3 30 Form 3 31 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations IMonth Au ust Fund /Department Number 218 1 Date Updated 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 1,000 38 88 325 912 9% Interest Earnings 25 3 52 26 (27) 208% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,025 41 140 351 885 14% Expenditures Personnel - - - - - 0% Supplies - 0% Services 1,000 1,000 0% Debt Service - - 0% Capital 0% Transfers Out 0% Total Expenditures 1,000 - - 1,000 0% Net 25 41 140 351 (115) Cash Balance 12,145 11,898 Staffing Full Time - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was established to collect curfew and prostitution fines. Expenditures are used for Police activities and training. Explain Significant Spending on Capital Projects Below: Form 3 31 2015 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education Fund /Department Number 220 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 50,000 - 49,119 10,000 881 98% Charges for Services 182,000 17,467 142,898 111,059 39,102 79% Interest Earnings 3,000 219 4,180 2,185 (1,180) 139% Bond Proceeds - - - - - 0% Donations 2,000 - - - 2,000 0% Other Income 33,000 736 13,927 13,354 19,073 42% Transfers In - - - - 0% Total Revenue 270,000 18,422 210,124 136,598 59,876 78% Expenditures Personnel - - - - - - 0% Supplies 172,478 18,938 99,051 22,058 25,043 48,384 72% Services 190,000 9,972 142,557 84,251 23,685 23,758 87% Debt Service - - - - - - 0% Capital 13,947 0% Transfers Out - - - - 0% Total Expenditures 362,478 28,910 241,608 120,256 48,728 72,142 80% Cash Balance 932,109 997 Staffing Full Time - Part -Time /Seasonal /Temporary Total txpiam signrcicant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: This fund was established for the continuing education and supplies for police and is funded by fees from accident reports, gun permits, false alarm and loud noise fines. The increase in Services expenditures over 2014 is due to increased training in 2015. Explain Significant Spending on Capital Projects Below: Form 3 32 2015 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Fund /Department Number 227 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior - 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Kevenue - - Property Taxes - 0% Local Income Taxes Supplies 0% Other Taxes 53,224 0% Grants /Intergovernmental 118% 0% Charges for Services 1,448 0% Interest Earnings 30,000 790 20,072 17,194 9,928 67% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 30,000 30,500 (500) 102% Transfers In - - - - - 0% Total Revenue 60,000 790 50,572 17,194 9,428 84% Personnel - - - - - 0% Supplies 67,500 36,551 53,224 - 26,426 (12,150) 118% Services 3,280,635 1,448 1,930,428 536,196 1,209,238 140,969 96% Debt Service - - - - - - 0% Capital 1,889,108 1,207,021 1,672,952 154,420 211,055 5,101 100% Transfers Out - - - - - 0% Total Expenditures 5,237,243 1,245,020 3,656,604 690,616 1,446,720 133,920 97% ICash Balance 2,260,236 7,262,610 statnng Full Time Part-Time /Seasonal /Temporary Total txpiam signffscant reevenue, txpenanure ana starting cnangesivanances tseiow: Of the $3.28 million budgeted for Services, $1.2 million remains encumbered for the vacant and abandoned housing initiative. The Other Income is revenue from the Light Up South Bend program, where residents pay $250 of the cost toward installation of lamp posts in their front yards. The extra $500 in revenue is offset by a $500 return as two homeowners weren't able to participate in the program and had their contributions returned to them. txpiam signrcscant spenamg on t apnai vrotecis tseiow: $1.889 million has been budgeted in 2015 for the Smart Streets initiative. As of August, all Capital encumbrances are for the Lincolnway West Corridors project. Form 3 33 Form 3 34 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month Au ust Fund /Department Number 244 Date Updated 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 215,000 0% Charges for Services - - 0% Interest Earnings 20 19 1 97% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 20 19 215,000 1 97% Expenditures Personnel - - 136,113 - 0% Supplies - 0% Services 0% Debt Service 0% Capital 0% Transfers Out - 0% Total Expenditures - 136,113 0% Net 20 19 78,887 1 Cash Balance 33,671 78,887 Staffing Full Time 3.00 - Part-Time /Seasonal /Temporary - Total 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was set up per requirement by the State Board Of Accounts (SBOA) to cover the cost of 911 Police Communication personnel costs covered by a State Grant. This fund will be closed in 2015 with the advent of the county -wide PSAP system. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 34 2015 City of South Bend Monthly Financial Report Fund /Department Name Public Safety LOIT Fund /Department Number 249 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior - - Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes - - - - 0% Local Income Taxes 6,466,190 3,771,944 4,253,353 2,694,246 58% Other Taxes - - - - 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 6,000 187 4,395 3,952 1,605 73% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 50 13 37 27% Transfers In - - - - - 0% Total Revenue 6,472,240 187 3,776,353 4,257,305 2,695,887 58% Expenditures Personnel 7,246,551 503,168 4,599,426 4,976,039 2,647,125 63% Supplies - - - - - 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 7,246,551 503,168 4,599,426 4,976,039 2,647,125 63% Ne} 177A 3111 l5n9 QR11 (R93 n731 l71R 7351 - AR 799 Cash Balance 467,351 Staffing Full Time 80.00 Part-Time /Seasonal /Temporary - Total 80.00 txpiam signfficant ttevenue, txpenanure ana starting cnangesivanances tseiow: This fund will cover the costs of salaries and fringes for 43 police officers and 37 firefighters in 2015. txpiam signrncant spenamg on t apnai vrotecis tseiow: None. No capital equipment is purchased from this fund. Form 3 35 Form 3 36 2015 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month Au ust Fund /Department Number 251 Date Updated 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 1,045,000 23,204 675,070 661,582 369,930 65% Grants /Intergovernmental - - - - - 0% Charges for Services - - - - 0% Interest Earnings 6,300 619 11,440 4,749 (5,140) 182% Bond Proceeds - - - - 0% Donations - - - 0% Other Income 770,000 20,375 33,801 749,625 3% Transfers In - - - - - 0% Total Revenue 1,821,300 23,823 706,885 700,132 1,114,415 39% Expenditures Personnel - - - - - 0% Supplies 380,229 157,706 157,706 233,430 222,294 229 100% Services 157,500 - 11,000 - 72,575 73,925 53% Debt Service - - - - - - 0% Capital 1,588,492 52,329 388,827 66,782 985,294 214,370 87% Transfers Out - - - - - - 0% Total Expenditures 2,126,221 210,035 557,533 300,213 1,280,163 288,524 86% Net (304,921) (186,213) 149,352 399,920 (1,280,163)1 825,890 Cash Balance 2,593,874 2,341,294 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund receives most of its revenue through the gas tax, budgeted at $1 million for 2015. It's used predominantly for street capital projects but $537,000 is used for material for street repairs and other maintenance items. In July a new estimate of gas tax receivable increased the revenue budget by $45,000. Explain Significant Spending on Capital Projects Below: Projects in 2015 include the Safe Routes to School initiative for Coquillard and Harrison schools, Bendix Drive, and the Boland bicycle trail. The $985K in encumbrance includes $223K for Bendix Dr. (Lathrop to Toll Road), $161 K for the Boland Trail, $341 K for Safe Routes to School ( Coquillard, Harrison, Perley and Lincoln schools) and $220K for Olive St. pavement design. Form 3 36 Form 3 37 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Month Au ust Fund /Department Number 252 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0 3 (0) 0% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 0 3 (0) 0% Expenditures Personnel - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - 0% Net - 0 3 (0) Cash Balance 8 1,152 Staffing Full Time Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: In 2009, the City received a one -time $2.9 million distribution for this fund. In 2012, the City spent approximately $2.1 million for portable radios for both the Police and Fire departments. Money in this fund may only be used for public safety purposes. This fund will be closed out in 2015. Explain Significant Spending on Capital Projects Below: Form 3 37 Form 3 38 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant Month Au ust Fund /Department Number 258 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 189,000 5,000 53,267 30,000 135,733 28% Charges for Services - - - - - 0% Interest Earnings 2,000 84 1,795 970 205 90% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 18,950 14 17,660 9,548 1,290 93% Transfers In - - - - - 0% Total Revenue 209,950 5,098 72,722 40,518 137,228 35% Expenditures Personnel 123,657 8,949 79,196 75,665 - 44,461 64% Supplies 2,800 - 743 1,336 1,057 1,000 64% Services 120,900 4,647 65,695 44,988 7,692 47,513 61% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 247,357 13,597 145,635 121,989 8,749 92,974 62% Net (37,407) (8,499) (72,913) (81,471) (8,749)1 44,255 Cash Balance 458,109 385,304 Staffing Full Time 2.00 2.00 2.00 Part-Time /Seasonal /Temporary 2.00 2.00 2.00 Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Human Rights Federal Grant Fund contains separate departments for EEOC and HUD grants. The Human Rights mission is to educate and promote fair housing as well as ensure that all citizens receive equal employment opportunity. Expenditures are higher than last year at this time. Higher spending occurred in the services category as a payment for services from 2014 was paid early this year. In addition, there were three pay periods this month. Explain Significant Spending on Capital Projects Below: No capital projects have been budgeted for this year. Form 3 38 Form 3 39 2015 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Month Au ust Fund /Department Number 271 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 50 1 19 28 31 37% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 50 1 19 28 31 37% Expenditures Personnel - - - - - - 0% Supplies 4,000 1,900 3,998 9,092 0 2 100% Services - - - - - - 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 4,000 1,900 3,998 9,092 0 2 100% Net (3,950) (1,899) (3,979) (9,063) (0)1 29 Cash Balance 1,333 5,309 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In recent years there have been no races. Explain Significant Spending on Capital Projects Below: Form 3 39 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month Au ust Fund /Department Number 273 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 17,900 250 7,008 8,060 10,892 39% Interest Earnings 100 6 116 58 (16) 116% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 18,000 256 7,124 8,118 10,876 40% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 18,974 3,332 9,191 5,089 10,553 44% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 18,974 - 3,332 9,191 5,089 10,553 44% Net (974) 256 3,792 (1,073) (5,089)1 323 Cash Balance 30,506 26,912 Staffing Full Time - - - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Morris Performing Arts Center and Palais Royale Marketing Fund was established as a separate non - reverting fund to receive monies from solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marqee sponsorships; and to accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale. The funds in this account at the end of the fiscal year shall not revert to the general fund. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund Form 3 40 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Month Au ust Fund /Department Number 280 Date Updated 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 1 16 8 (16) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1 16 8 (16) 0% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - 0% Net 1 16 8 (16) Cash Balance 3,845 3,826 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Explain Significant Spending on Capital Projects Below: Form 3 41 Form 3 42 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Month Au ust Fund /Department Number 281 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 100 6 117 60 (17) 117% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 200 200 0% Transfers In - - - - - 0% Total Revenue 300 6 117 60 183 39% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - 0% Net 300 6 117 60 183 Cash Balance 27,322 27,188 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Fund to be used only for the expenses of EDC revenue bonds. These bonds have been paid off. Fund to be closed during 2015. Explain Significant Spending on Capital Projects Below: Form 3 42 2015 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Fund /Department Number 289 Month Au ust Date Updated 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 14,000 - 13,787 24,055 213 98% Interest Earnings 100 7 142 37 (42) 142% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 14,100 7 13,928 24,092 172 99% Expenditures Personnel - - - - - 0% Supplies 31,530 21,542 9,988 68% Services - - - 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 31,530 21,542 9,988 68% Net !17 d301 7 17 6131 9d nQ9 - !Q R171 Cash Balance 32,015 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmrscant stevenue, txpenanure ana btaffmg s:nangesivanances tseiow: Charges for Service for HAZ -MAT responses. By ordinance the South Bend Fire Department charges businesses for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund, responses are made by firefighters of the South Bend Fire Department. txpiam signrcscant spenamg on t apnai vrotecis tseiow: No major capital expenditures are planned through this fund. Major purchases are funded through the Fire Department and EMS Capital and the minimal fees collected in this fund are used to replace equipment and gear used in responses. Form 3 43 2015 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue Fund /Department Number 291 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental - - 975 - 0% Charges for Services 45,000 - 30,600 37,600 14,400 68% Interest Earnings 350 17 400 229 (50) 114% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 45,350 17 31,000 38,804 14,350 68% Expenditures Personnel 7,500 231 1,731 628 5,769 23% Supplies 8,800 - 2,021 512 6,779 23% Services 79,500 27,765 23,852 51,735 35% Debt Service - - - - 0% Capital 25,000 20,997 4,003 84% Transfers Out - - - - - 0% Total Expenditures 120,800 231 52,514 24,992 68,286 43% Nat 175 Arm 121 d1 171 5131 13 R12 /SR Q 17 Cash Balance 83,886 1 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmncant stevenue, txpenanure ana btatrmg s:nanges /variances tseiow: No staffing associated with this fund. The fund collects tuition fees for students attending the Indiana River Rescue School. There are typically 2 -4 schools a year, each a week in duration. Expenditures are for the maintenance and repair of rescue equipment. Explain Significant Spending on Capital Projects Below: Form 3 44 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Fund /Department Number 292 Month Au ust Date Updated 9/14/2015 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 90,000 56,891 66,716 33,109 63% Charges for Services - - - - 0% Interest Earnings 55 (55) 0% Bond Proceeds - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 90,000 56,946 66,716 33,054 63% Expenditures Personnel - - - - 0% Supplies 14,186 14,790 - (604) 104% Services 959 507 138,059 452 53% Debt Service - - - - 0% Capital 90,000 90,000 0% Transfers Out - - - - 0% Total Expenditures 105,145 15,297 138,059 89,848 15% Net (15,145) 41,649 (71,343) (56,794) Cash Balance 137,058 133,166 Staffing Full Time Part-Time /Seasonal /Temporary Total txpiam bigmncant stevenue, txpenanure ana btattmg s:nangesivanances tseiow: This Fund was set up to track the revenue and expenditures related to specific Federal Grants. Expenditures have been outlined in each grant. Explain Significant Spending on Capital Projects Below: Form 3 45 2015 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Fund /Department Number 294 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 20,500 - 20,488 17,900 13 100% Interest Earnings 200 14 290 174 (90) 145% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 2,000 2,000 0% Transfers In - - - - - 0% Total Revenue 22,700 14 20,778 18,074 1,923 92% Expenditures Personnel - - - - - 0% Supplies 1,750 360 1,295 631 455 74% Services 22,000 352 25,172 11,913 (3,172) 114% Debt Service - - - - 0% Capital 0% Transfers Out - - - - 0% Total Expenditures 23,750 712 26,467 12,544 i (2,717) 111% NPt n nrm rrarI is rani r r ,i n I a ran Cash Balance 62,593 73,614 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmncant stevenue, txpenanure ana btaffmg s:nangesivanances tseiow: This fund was established to fund the cost of course material and instructors at the South Bend Police Academy. The enforcement courses are offered to other police departments who pay a fee to attend the training. The Service expenditure in 2015 was the instructor cost for a Field Training Officer course offered by the Academy. Explain Significant Spending on Capital Projects Below: Form 3 46 2015 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Fund /Department Number 295 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 86,658 1,681 1,681 84,977 2% Charges for Services - - - - - 0% Interest Earnings 350 25 446 248 (96) 127% Bond Proceeds - - - - - 0% Donations 3,250 - - - 3,250 0% Other Income 38,000 660 17,190 7,016 20,810 45% Transfers In 22,000 - 20,965 - 1,035 95% Total Revenue 150,258 2,366 40,282 7,264 109,976 27% Expenditures Personnel - - - - - - 0% Supplies 45,735 7,135 34,265 3,665 10,271 1,199 97% Services 66,000 - 3,160 7,649 - 62,840 5% Debt Service - - - - 0% Capital 60,600 60,600 0% Transfers Out - - - - - - 0% Total Expenditures 172,335 7,135 37,425 11,314 10,271 124,639 28% Cash Balance 116,226 1 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam signrcicant rtevenue, txpenanure ana staffing cnangesivanances tseiow: This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds received from the grants along with impound towing fees. In January, $20,490 was expended in Supplies for dashboard cameras for Police vehicles which will be reimbursed by Federal Grant. Explain Significant Spending on Capital Projects Below: Form 3 47 Form 3 48 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Month Au ust Fund /Department Number 299 Date Updated 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 75,000 63,744 31,198 11,256 85% Charges for Services - - - - - 0% Interest Earnings 1,000 89 696 658 304 70% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 1,000 7,636 1,000 0% Transfers In - - - - - 0% Total Revenue 77,000 89 64,440 39,492 12,560 84% Expenditures Personnel - - - - - - 0% Supplies 84,759 54,575 23,800 13,216 16,968 80% Services 74,201 23,102 25,234 - 51,099 31% Debt Service - - - - - 0% Capital 90,000 34,490 79,711 1,628 10,289 89% Transfers Out - - - - - - 0% Total Expenditures 248,960 34,490 157,388 50,661 13,216 78,356 69% Net (171,960) (34,401) (92,948) (11,169) (13,216) (65,796) Cash Balance 252,595 373,991 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was established to receive the Police Department share of money acquired in drug enforcement activity. Expenditures are to be used to fund drug enforcement and training. Explain Significant Spending on Capital Projects Below: Form 3 48 2015 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax Month Au ust Fund /Department Number 404 1 Date Updated 9I11I2015 Current Current Current Prior - 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes - - - - 0% Local Income Taxes 8,859,912 5,168,282 5,763,874 3,691,630 58% Other Taxes - - - - 0% Grants /Intergovernmental 3,262,179 2,553,480 740,548 4,156,438 0% Charges for Services 2,487,504 104,591 1,658,480 1,905,469 0% Interest Earnings 58,000 3,298 62,849 32,086 (4,849) 108% Bond Proceeds - - - - Transfers Out 0% Donations - - - - 750,000 0% Other Income 966,059 43,200 501,132 347,129 464,927 52% Transfers In - - - - - 0% Total Revenue 9,883,971 46,499 5,732,264 6,143,089 4,151,707 58% Personnel 427,077 25,782 217,117 - - 209,960 51% Supplies 1,384,804 75,803 575,252 825,691 23,648 785,904 43% Services 8,159,164 406,982 3,262,179 2,553,480 740,548 4,156,438 49% Debt Service 2,487,504 104,591 1,658,480 1,905,469 - 829,024 67% Capital 1,701,822 - 28,788 34,598 864,895 808,139 53% Transfers Out 1,500,000 - 750,000 550,000 - 750,000 50% Total Expenditures 15.660.371 613,158 6,491,816 5.869.238 1,629,090 7,539,465 52% Cash Balance 14,232,362 15.1 atrmg Full Time 4.00 3.00 3.00 Part-Time /Seasonal/Tem ora - - - Total 4.00 3.00 3.00 txpiam sigmncant rtevenue, txpenanure ana stattmg L;nangesroanances tseiow: Transferred Chief Information Officer (fomerly Director of IT) and Chief Innovation Officer and (2) Business Analysts (new in 2015) to COIT. Budget increase of approximately $3.0 million in "Services" for education and travel due to IT related expenses to COIT to maintain IT professional who support the city. Increase also due to election expense as 2015 is a mayoral election year. This category also increased to include the Supporting Manufacturers And Regional Talent (SMART) program and construction skill training and recruiting expenses. Other income in 2015 includes $438,203 in loan repayments from the UDAG Fund 410 for the 1 st Source /Marriott loan based on BDC collections as well as charges to City departments for computer services. txpiam ssgnmcant spenamg on Lapnai vrotects eseiow: This year, $341,500 has been budgeted for IT upgrades such as fiber enhancements to the County City building, Central Services and the Water Works Olive St. Station. An additional $972,500 was appropriated in May 2014 to pay Transpo for the City's portion of the new CNG fueling station. An encumbered amount of $890,000 remaining has been carried forward to 2015. Lastly, approximately $470,000 has been budgeted for the corridors implementation. Form 3 49 Form 3 50 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax Month Au ust Fund /Department Number 408 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - 0% Local Income Taxes 8,981,877 5,239,428 5,864,547 3,742,449 58% Other Taxes - - - - 0% Grants /Intergovernmental - - - 0% Charges for Services 504,660 504,660 354,660 100% Interest Earnings 40,000 2,467 43,879 22,631 (3,879) 110% Bond Proceeds - - - - 0% Donations - - - 0% Other Income 100 82 11,948 18 82% Transfers In - - - - - 0% Total Revenue 9,526,637 2,467 5,788,049 6,253,786 3,738,588 61% Expenditures Personnel - - - 265,672 - 0% Supplies - - - - - 0% Services 1,799,736 57,166 872,097 1,026,231 283,699 643,940 64% Debt Service 1,656,191 - 1,340,100 1,925,520 - 316,091 81% Capital 4,000 3,200 185,192 800 - 100% Transfers Out 6,483,782 - 3,907,677 3,353,290 - 2,576,105 60% Total Expenditures 9,943,709 57,166 6,123,074 6,755,905 284,499 3,536,136 64% Net (417,072) (54,699) (335,024) (502,119) (284,499) 202,451 Cash Balance 9,835,201 10,340,009 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: In 2015, Code Enforecement personnel expense is fully paid out of Fund 600, therefore, no additional expenses will be incurred in 2015 related to Code in this fund. Transfers out relate to: Community Investment ($1,967,638), Streets ($1,853,000), Code Enforcement ($2,033,776) and Animal Care & Control ($629,368). Services include DTSB management costs, Chamber grants, and others. Explain Significant Spending on Capital Projects Below: $275,000 has been budgeted for the Potawatomi Zoological Society. Form 3 50 Form 3 51 2015 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Month Au ust Fund /Department Number 410 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 110 30 355 61 (245) 323% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 528,576 251,849 276,727 48% Transfers In - - - - - 0% Total Revenue 528,686 30 252,204 61 276,482 48% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 438,203 146,068 292,135 33% Capital - - - 0% Transfers Out - - - 0% Total Expenditures 438,203 146,068 292,135 33% Net 90,483 30 106,136 61 (15,653) Cash Balance 133,802 27,648 Staffing Full Time - - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This budget usually includes payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. New payments from the BDC are expected in 2015. Explain Significant Spending on Capital Projects Below: Form 3 51 2015 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Fund /Department Number 655 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 429,000 36,590 291,927 290,693 137,073 68% Interest Earnings 2,700 259 4,599 2,222 (1,899) 170% Bond Proceeds - 0% Donations 0% Other Income 0% Transfers In - 0% Total Revenue 431,700 36,849 296,525 292,915 135,175 69% Expenditures Personnel 64,081 12 1,489 1,506 62,592 2% Supplies 6,000 6,000 0% Services 36,058 2,784 20,247 20,079 15,811 56% Debt Service 72,219 47,728 47,699 24,491 66% Capital - - 0% Transfers Out 350,000 350,000 0% Total Expenditures 528,358 2,796 69,464 69,284 458,894 13% Nat (UR srR) Rd n53 777 nR1 773 6411 - 1371 71 Ch Cash Balance 1,207,087 1,1 Staffing Full Time - Part-Time /Seasonal /Temporary 2.16 Total 2.16 txpiam signmcant rtevenue, txpenanure ana Fall ReLeaf scheduled for October 2015. Explain Significant Spending on Capital Projects Below: tseiow: Form 3 52 Form 3 53 2015 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Month Au ust Fund /Department Number 705 Date Updated 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 10 14 4 (4) 140% Bond Proceeds - - - - 0% Donations 1,990 1,500 1,000 490 75% Other Income - - - - 0% Transfers In - - - - 0% Total Revenue 2,000 1,514 1,004 486 76% Expenditures Personnel - - - - 0% Supplies - - - 0% Services 2,000 970 1,030 49% Debt Service - - - 0% Capital 0% Transfers Out 0% Total Expenditures 2,000 - 970 - 1,030 49% Net 544 1,004 (544) Cash Balance 3,863 2,318 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds. Explain Significant Spending on Capital Projects Below: Form 3 53 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service Fund /Department Number 313 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Kevenue 0% Supplies 0% Property Taxes 1,177,620 501,785 271,788 675,835 43% Local Income Taxes - - - - 0% Other Taxes 45,358 - 36,400 22,679 8,958 80% Grants /Intergovernmental 51,078 4,256 34,052 57,118 17,026 67% Charges for Services - - - - - 0% Interest Earnings 50 41 9 82% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,274,106 4,256 572,278 351,585 701,828 45% Personnel 0% Supplies 0% Services 0% Debt Service 1,266,820 1,272,000 1,270,500 (5,180) 100% Capital - - - 0% Transfers Out - - - 0% Total Expenditures 1,266,820 1,272,000 1,270,500 (5,180) 100% Net 7 9RR d 95(i IRQ9 7991 !Q1 R Q191 - 7n7 nnR ICash Balance btamng Full Time Part-Time /Seasonal /Temporary Total txpiam bigmncant stevenue, txpenanure ana btatfmg s:nangesivanances tseiow: This fund is used to collect a separate property tax levy distributions (received in June and December) and is used to pay debt service on the former College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will typically have a negative cash balance until the property tax distributions are received. Payments In Lieu Of Taxes (PILOT) paid by the utilities are received monthly in this fund. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. In April 2015 the Mayor announced a lease of the Hall of Fame to a JSK Hospitality, who will transform the building into the lobby for a new Marriott hotel. The building will be leased through 2017 at which time JSK will have the option to buy the property. Explain Significant Spending on Capital Projects Below: None Form 3 54 2015 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month Au ust Fund /Department Number 377 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 747,750 479,907 388,711 267,843 64% Charges for Services - - - - - 0% Interest Earnings 1,100 83 1,993 1,405 (893) 181% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 60,661 56,233 66,710 4,428 93% Transfers In - - - - - 0% Total Revenue 809,511 83 538,133 456,826 271,378 66% Expenditures Personnel - - - - - 0% Supplies 0% Services - - - 0% Debt Service 855,603 855,603 865,545 100% Capital - - - 0% Transfers Out - - - 0% Total Expenditures 855,603 855,603 865,545 100% Net (46,092) 83 (317,470) (408,719) 271,378 Cash Balance 278,622 433,338 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Effective January 1, 2013, this fund no longer collects hotel /motel tax allocations from St. Joseph County for payment to the Hall of Fame. This fund is currenty used for debt. PSDA tax revenue is generally received from the State on a monthly basis. PSDA tax is a special tax received from the State of Indiana based on the sales tax, income tax and local income taxes collected in the PSDA area (which includes Four Winds Field, Century Center, Morris Performing Arts Center and Studebaker National Museum). Four Winds Field generates the majority of PSDA revenue. The January debt service payment has been made for 2015. The final debt service payment on the 2010 Coveleski Stadium bonds (Four Winds Field) was paid January 15, 2013. Explain Significant Spending on Capital Projects Below: Form 3 55 Form 3 56 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month Au ust Fund /Department Number 401 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 15,000 - - - 15,000 0% Interest Earnings 100 9 174 59 (74) 174% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 15,100 9 174 59 14,926 1% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - 0% Net 15,100 9 174 59 14,926 Cash Balance 40,624 26,909 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Fund 401 accounts for capital spending on Coveleski Stadium. Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. Explain Significant Spending on Capital Projects Below: Form 3 56 2015 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Month Au ust Fund /Department Number 403 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 200 11 211 108 (11) 106% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 200 11 211 108 (11) 106% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 49,000 49,000 0% Transfers Out - - 0% Total Expenditures 49,000 - - 49,000 0% Net (48,800) 11 211 108 (49,011) Cash Balance 49,373 49,130 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was established to account for donations dedicated to Potawatomi Zoo. In the past few years several endowments that were funding this fund were liquidated resulting in a drop in revenues to this fund. Explain Significant Spending on Capital Projects Below: Form 3 57 Form 3 58 2015 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Month Au ust Fund /Department Number 405 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 34,000 652 4,310 7,283 29,690 13% Interest Earnings 2,200 96 1,984 932 216 90% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 12,000 4,250 12,144 7,750 35% Transfers In 95,500 - - - 95,500 0% Total Revenue 143,700 748 10,544 20,358 133,156 7% Expenditures Personnel - - - - - - 0% Supplies 67,273 3,458 32,965 44,995 7,024 27,283 59% Services 50,660 3,820 9,772 19,220 660 40,228 21% Debt Service - - - - - - 0% Capital 75,000 22,499 95,000 52,501 30% Transfers Out - - - - - - 0% Total Expenditures 192,933 7,278 65,236 159,215 7,684 120,012 38% Net (49,233) (6,530) (54,692) (138,856) (7,684)1 13,143 Cash Balance 466,472 434,035 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This is a nonreverting capital fund that accounts for revenues collected and expenses for specific purposes or locations. These locations are Potawatomi and Rum Village Picnic Areas, the East Race, Golf Courses, Forestry, Howard Park Ice Rink, and, until 2014, Potawatomi Zoo. The cash balance includes $60,300 that is restricted to expenditures in Voorde Park. Explain Significant Spending on Capital Projects Below: This fund is for expending nonreverting revenue collected from the Zoo, golf courses, East Race Waterway, picnic sites and forestry revenue. Form 3 58 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development Fund /Department Number 406 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior 235,215 212,620 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 450,000 237,380 235,215 212,620 53% Local Income Taxes - - - - - 0% Other Taxes 90,191 4,349 53,538 50,104 36,653 59% Grants /Intergovernmental - - - - - 0% Charges for Services - - - - - 0% Interest Earnings 2,500 110 1,989 1,466 511 80% Bond Proceeds - - - - - 0% Donations - 0% Other Income 854 0% Transfers In - - - - 0% Total Revenue 542,691 4,459 292,907 287,639 249,784 54% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 542,691 474,118 474,118 68,573 87% Capital - - - - 0% Transfers Out - - - - 0% Total Expenditures 542,691 474,118 474,118 i 68,573 j 87% Na} - AARQ 11R1 9111 11 RR AM I 1R1 911 Cash Balance 400,040 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmncant ttevenue, txpenanure ana btattmg L;nangesivanances tseiow: This fund receives revenue from a property tax levy and distributions are received from St. Joseph County in June and December. Expenditures are for debt service payments on capital leases and the due dates vary per lease. The fund is used to finance police vehicles and related equipment. The fund also receives Payments In Lieu Of Taxes (PILOT) from the Water Works and Wastewater utilities on a monthly basis. Explain Significant Spending on Capital Projects Below: Form 3 59 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement Fund /Department Number 407 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 397,000 267,652 273,553 129,348 67% Grants /Intergovernmental - - - - 0% Charges for Services - - - - - 0% Interest Earnings 150 48 584 119 (434) 389% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 25,200 25,200 0% Transfers In - - - - - 0% Total Revenue 422,350 48 268,236 273,672 154,114 64% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 365,625 367,875 369,000 (2,250) 101% Capital - - - 0% Transfers Out - - - 0% Total Expenditures 365,625 367,875 369,000 (2,250) 101% Nat SR 775 AR /QQ fiRQ1 I" 37R1 1 SR IRA Cash Balance 149,844 81 Staffing Full Time - Part -Time /Seasonal /Temporary Total txpiam signmcant ttevenue, txpenanure ana starting cnangesivanances tseiow: Revenue in this fund includes $150,000 in hotel /motel taxes and $247,000 in cigarette taxes from other units of government. The hotel /motel tax distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December. In 2015, this fund is used to pay 75% of the 2011 Century Center Refunding bonds as it was in 2014. Payments on the Century Center bond are due in February and July. Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year. Explain Significant Spending on Capital Projects Below: None Form 3 60 2015 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction Month Au ust Fund /Department Number 412 1 Date Updated 1 9/14/2015 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 76,599 0% Interest Earnings 25,000 634 14,815 15,637 10,185 59% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 786,187 418,156 786,187 269,103 (0) 100% Transfers In - - - - - 0% Total Revenue 811,187 418,790 801,002 284,740 10,185 1 99% Personnel 0% Supplies 0% Services 0% Debt Service 0% Capital 3,096,061 318,492 1,765,243 1,250,082 1,254,219 76,599 98% Transfers Out - - - - - - 0% Total Expenditures 3.096.061 318,492 1,765,243 1,250.082 1,254,219 76,599 98% Cash Balance atrmg Full Time Part-Time /Seasonal/Temporary Total 2,953,412 1 6.1 txpiam sigmncant ttevenue, txpenanure ana stattmg t;nangesroanances tseiow: Initial funding for the Major Moves fund in the amount of $12,823,151 was received from the State of Indiana on September 15, 2006, derived from the State lease of the 1 -80 toll road to a private company. This fund has been used in the past to provide seed money for economic development projects at Douglas Road, Eddy Street Commons, and the Triangle Development near Notre Dame. The amounts advanced for these projects are being repaid by the respective tax increment financing (TIF) funds as per formal amortization schedules. In August the fund received the second of two semi - annual payments on these loans, totaling $418,156 in principal and interest. Balances due as of 31 August are $635,520 from Fund 435 (Douglas Rd.) and $4,436,193 from Fund 436 (River East Residential, f /k/a Northeast Residential). In August the Board of Public Works and the Redevelopment Commission approved a loan to the Parking Garages fund (Fund 601) which will commence in 2016 with the first of two loans of $750,000 each. The second $750,000 will be lent to the Parking Garages fund in 2017. txpiam signmcant spenamg on Lapnai vrotects tseiow: The 2015 budget continues funding for the Smart Streets initiative and includes $950,000 for Smart Streets, $350,000 for the King /LW W roundabout design, and $30,000 for Corridor alley improvements. The $1.3 million encumbered comprises $550K for the 2 -way conversion of Main and Michigan /St. Joseph streets from Chippewa to LaSalle (the former IN -933), $244K for the Marion St. roundabout, $200K for the Western Ave. corridor sidewalks and striping, and $86K for the Olive - Sample overpass. There remains a $173,000 encumbrance for utility relocation for the US 31 construction on the south side of town; this encumbrance may be closed out soon. Form 3 61 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Fund /Department Number 416 Month Au ust Date Updated 1 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 100,000 4,602 37,693 50,080 62,307 38% Interest Earnings 1,500 116 2,221 1,047 (721) 148% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 101,500 4,718 39,914 51,127 61,586 39% Expenditures Personnel - - - - - 0% Supplies 30,210 888 20,997 6,054 - 9,213 70% Services 40,038 - 21,157 8,765 11,264 7,617 81% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 70,248 888 42,154 14,819 11,264 16,830 76% Cash Balance 513,179 493,119 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmrscant stevenue, txpenanure ana btaffmg s:nangesivanances tseiow: This fund was established for the purpose of renovating, remodeling, or otherwise improving the facilities and / or service to the patrons of the Morris Performing Arts Center. There is no staffing for this fund. Funds in this account are received from a per ticket surcharge included on every sold ticket. txpiam signffscant spenamg on t apnai vrotecis tseiow: There are no Capital projects budgeted for this year. Form 3 62 2015 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Fund /Department Number 434 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 150 33 232 204 (82) 155% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 150 33 232 204 (82) 155% Expenditures Personnel - - - - - 0% Supplies - - 0% Services 462,206 - - 462,206 0% Debt Service 187,794 7,794 20,975 180,000 4% Capital - - - - 0% Transfers Out - - - - 0% Total Expenditures 650,000 7,794 20,975 642,206 1% Net IRAQ Rsm 33 17 5691 (9n 7711 - I6A9 9RR1 Cash Balance 2,276 (11 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam signfficant rtevenue, txpenanure ana staffing cnangeslvanances tseiow: CRIED is derived from State sale taxes generated within the CRIED district (within Studebaker /Oliver area) up to a maximum $1 M annually through 2015. The distribution is made once a year in October and amount fluctuates significantly (note historical revenues). Fund did not have sufficient revenue last few years to make full debt payment so COIT had to make a portion of the payments. We are anticipating 2015 revenue will allow us to reimburse COIT at least a portion of its funding. Explain Significant Spending on Capital Projects Below: Form 3 63 Form 3 64 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Month Au ust Fund /Department Number 450 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 16,000 864 7,644 4,896 8,356 48% Interest Earnings 150 15 283 123 (133) 189% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 16,150 879 7,927 5,019 8,223 49% Expenditures Personnel - - - - - 0% Supplies - - 0% Services 16,150 16,150 0% Debt Service - - 0% Capital 0% Transfers Out 0% Total Expenditures 16,150 - - 16,150 0% Net 879 7,927 5,019 (7,927) Cash Balance 71,088 58,415 Staffing Full Time - - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund. Form 3 64 Form 3 65 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Month Au ust Fund /Department Number 677 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 2,500 119 2,337 1,415 163 93% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 2,500 119 2,337 1,415 163 93% Expenditures Personnel - - - - - 0% Supplies 15,000 - - 419 15,000 0% Services 173,824 2,860 35,665 51,329 138,159 21% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 188,824 2,860 35,665 51,748 153,159 19% Net (186,324) (2,741) (33,328) (50,333) (152,996) Cash Balance 525,891 608,074 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Hall of Fame Capital fund covers maintenance and utilities expense on the building incurred by the City, including costs of the building after the Hall of Fame ceased operations in South Bend at the end of 2012. This fund will be closed when the Hall of Fame is sold to a developer in 2017. Explain Significant Spending on Capital Projects Below: No Capital expenditures budgeted for 2015. Form 3 65 Form 3 66 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital JMonth Au ust Fund /Department Number 287 Date Updated 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 2,472,739 - 2,472,739 0% Charges for Services 400,000 - 396,727 3,273 99% Interest Earnings 350 81 1,038 (688) 296% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 750,000 - - 750,000 0% Total Revenue 3,623,089 81 397,765 3,225,324 11% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 750,000 23,659 59,387 612,086 78,527 90% Transfers Out - - - - - 0% Total Expenditures 750,000 23,659 59,387 612,086 78,527 90% Net 2,873,089 (23,578) 338,378 (612,086)1 3,146,797 Cash Balance 338,378 Staffing Full Time - - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The revenues in this account are generated through user fees for the South Bend Fire Department EMS division. These funds are used for capital purchases such as fire apparatus, ambulances and major construction projects. There are no employees associated with this fund. Explain Significant Spending on Capital Projects Below: Planned purchase of ambulance, support SUV, replacement cardiac monitors, fleet vehicle. Form 3 66 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Operating Fund /Department Number 288 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 5,144,065 430,016 3,214,207 1,794,543 1,929,858 62% Interest Earnings 18,000 782 13,887 11,145 4,113 77% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 17,000 1,689 16,409 16,241 591 97% Transfers In 500,000 - - - 500,000 0% Total Revenue 5,679,065 432,486 3,244,503 1,821,929 2,434,563 57% Expenditures Personnel 4,840,253 307,995 1,918,752 - 2,921,501 40% Supplies 292,000 19,813 222,017 137,367 4,684 65,299 78% Services 375,337 6,001 120,231 222,059 9,897 245,209 35% Debt Service 448,773 318 452,620 247,179 1,728 (5,575) 101% Capital 149,003 149,003 149,003 2,567,603 - - 100% Transfers Out 750,000 - - 1,000,000 - 750,000 0% Total Expenditures 6,855.366 483,130 2,862,622 4,174,208 16,309 3,976,435 42% Cash Balance 3,262,644 3,217 Staffing Full Time 51.00 51.00 51.00 Part -Time /Seasonal /Temporary - - - Total 51.00 51.00 51.00 txpiam signmcant ttevenue, txpenanure ana stattmg cnangesivanances tseiow: The revenues in this account are generated through user fees for the South Bend Fire Department EMS division, Training Bureau, and Inspections. This Fund captures personnel and operating expenses primarily for Emergency Medical Services division and reflects a portion of the cost associated with operating ambulances. Explain Significant Spending on Capital Projects Below: None Form 3 67 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund Fund /Department Number 600 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental - - - 1,600 - 0% Charges for Services 1,536,052 116,891 1,252,994 850,645 283,058 82% Interest Earnings 2,100 267 3,810 952 (1,710) 181% Bond Proceeds - - - - - 0% Donations 100 - 52 - 48 52% Other Income 7,817 3,794 25,094 2,032 (17,277) 321% Transfers In 2,663,144 - 1,997,358 1,153,280 665,786 75% Total Revenue 4,209,213 120,952 3,279,307 2,008,509 929,906 78% Expenditures Personnel 2,454,138 166,451 1,489,565 1,236,217 2,160 962,413 61% Supplies 181,483 6,807 76,300 95,680 12,026 93,157 49% Services 1,538,250 118,570 602,470 672,474 528,105 407,675 73% Debt Service 31,530 311 13,819 12,532 876 16,834 47% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,205,401 292,139 2,182,155 2,016,904 543,168 1 1,480,079 1 65% Cash Balance 1,837,359 1 Staffing Full Time 36.00 36.00 - Part-Time /Seasonal /Temporary 2.00 2.00 Total 38.00 38.00 txpiam signrcicant rtevenue, txpenanure ana starting cnangesivanances tseiow: This fund now comprises the Consolidated Building Department, Code Enforcement and Animal Control. Code and Animal Control are managed together but are run separately from the Building Department per Council's wishes. The $2.6 million transfer is from the EDIT Fund to cover Code and Animal Control activities which, unlike the Consolidated Building Department, are not enterprises by nature. Explain Significant Spending on Capital Projects Below: Form 3 68 Form 3 69 2015 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages--------] Month Au ust Fund /Department Number 601 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 908,675 76,345 608,200 586,644 300,475 67% Interest Earnings 5,600 236 4,570 2,082 1,030 82% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 130,850 7,623 55,330 118,434 75,520 42% Transfers In - - - - - 0% Total Revenue 1,045,125 84,204 668,100 707,160 377,025 64% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 1,621,858 35,367 585,693 451,574 68,368 967,797 40% Debt Service - - - - - - 0% Capital 184,854 2,900 63,817 68,087 1,536 119,501 35% Transfers Out - - - - - - 0% Total Expenditures 1,806,712 38,267 649,510 519,661 69,904 1,087,298 40% Net (761,587) 45,937 18,590 187,499 (69,904) (710,273) Cash Balance 1,092,219 1,071,687 Staffing Full Time - - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Operations under outside contract with Downtown South Bend, Inc. so all expenses except capital are shown under Services line to show consistently with Redevelopment Retail and Blackthorn Golf Course. Explain Significant Spending on Capital Projects Below: 2015 projects include: Wayne Street Fagade, Elevator Repairs and Door Repairs. These projects were begun in 2014 and will be finished in 2015. Other major repairs to be undertaken in 2015 will come from the Garage Study completed in 2014. Form 3 69 Form 3 70 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations IMonth Au ust Fund /Department Number 610 1 Date Updated 9/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 5,219,316 411,772 3,373,349 3,303,878 1,845,967 65% Interest Earnings 2,500 58 1,735 1,308 765 69% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 490,473 313 167,534 221,255 322,939 34% Transfers In - - - - - 0% Total Revenue 5,712,289 412,143 3,542,617 3,526,441 2,169,672 62% Expenditures Personnel 1,731,390 126,243 1,092,969 1,154,663 1,250 637,171 63% Supplies 371,208 46,128 199,021 266,826 29,247 142,940 61% Services 2,991,595 239,984 1,860,826 1,925,339 52,649 1,078,119 64% Debt Service 26,859 4,931 29,681 - (2,822) 111% Capital - - - - - 0% Transfers Out 752,811 11,000 530,000 649,916 222,811 70% Total Expenditures 5,873,863 428,284 3,712,497 3,996,744 83,146 2,078,220 65% Net (161,574) (16,142) (169,880) (470,303) (83,146) 91,452 Cash Balance 242,338 307,613 Staffing Full Time 25.20 21.20 Part -Time /Seasonal /Temporary 8.00 8.00 Total 33.20 29.20 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This Enterprise Fund charges City residents a small monthly fee to pick up and dispose of their trash at area landfills and recycling centers. The operations of Solid Waste are totally funded by these user fees. Transfers out to Fund 611 for debt service payments are done on an as needed basis. While year to date operating expenses are within budget, revenues continue to come in below expected levels. Explain Significant Spending on Capital Projects Below: Form 3 70 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Fund /Department Number 611 Month Au ust Date Updated 1 9/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 200 18 85 142 115 43% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 752,811 11,000 530,000 649,916 222,811 70% Total Revenue 753,011 11,018 530,085 650,058 222,926 70% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 752,811 155 553,569 596,719 199,242 74% Capital - (276) - 171,182 - 0% Transfers Out - - - - - 0% Total Expenditures 752,811 (121) 553,569 767,901 199,242 74% Nat 9nn 11 1'{R (Yt ARdl (117 RA-11 - 7x RRd Cash Balance 11,716 597 Staffing Full Time - Part -Time /Seasonal /Temporary Total txpiam signmcant ttevenue, txpenanure ana starting cnanges(vanances tseiow: The purpose of this fund is to pay for capital items, such as trash trucks, used in the day to day operations of Solid Waste. Other than a small amount of interest income, the sole source of revenue for this fund comes from dollars transferred in from the Solid Waste Operations Fund #610. These transfers are done on an as needed basis. txpiam signrcicant spenamg on t apnai vrotecis tseiow: Year to date spending has been for lease purchase payments on prior year equipment acquisitions. Form 3 71 Form 3 72 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations IMonth Au ust Fund /Department Number 620 1 Date Updated 9.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 14,638,403 1,510,466 9,352,681 9,574,815 5,285,722 64% Interest Earnings 29,000 787 19,490 7,016 9,510 67% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 93,580 919 39,729 122,746 53,851 42% Transfers In 19,500 1,010 23,859 8,938 (4,359) 122% Total Revenue 14,780,483 1,513,184 9,435,758 9,713,514 5,344,725 64% Expenditures Personnel 5,023,137 356,379 3,129,821 2,986,464 1,800 1,891,516 62% Supplies 1,531,896 104,605 903,777 940,709 128,973 499,146 67% Services 4,963,695 425,208 2,638,714 2,992,429 267,222 2,057,759 59% Debt Service 18,789 904 4,854 3,322 1,808 12,127 35% Capital - - - - - - 0% Transfers Out 4,306,954 332,159 2,884,754 2,639,276 - 1,422,200 67% Total Expenditures 15,844,471 1,219,255 9,561,920 9,562,200 399,803 5,882,748 63% Net (1,063,988) 293,929 (126,162) 151,314 (399,803) (538,023) Cash Balance 4,008,661 3,318,574 Staffing Full Time 70.20 67.20 Part -Time /Seasonal /Temporary 3.00 2.50 Total 73.20 69.70 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The purpose of this fund is to account for all revenue and operational expense of the water utility. This fund provides the monies for debt service obligations, reserve requirements and revenue funded capital improvements through transfer of monies to other funds within the utility operations. Lower levels of billed consumption continue to contribute to the decline in charges for services revenue. The transfers in revenue is interest earnings from other funds which has been greater year to date than previous year. Other income sources were more in 2014 because of scrap metal sales from retired water meters and from hydrant damage reimbursements. Total expenditures are slightly below budget target. Explain Significant Spending on Capital Projects Below: Form 3 72 Form 3 73 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital IMonth Au ust Fund /Department Number 622 1 Date Updated 9.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 10,000 655 13,129 7,779 (3,129) 131% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 10,000 655 13,129 7,779 (3,129) 131% Expenditures Personnel - - - - 0% Supplies - 0% Services 3,600 0% Debt Service - - - 0% Capital 838,893 221,445 12,603 8,075 609,373 27% Transfers Out - - - - - 0% Total Expenditures 838,893 221,445 16,203 8,075 609,373 27% Net (828,893) 655 (208,316) (8,425) (8,075) (612,502) Cash Balance 2,916,965 3,523,301 Staffing Full Time - - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund is used for acquiring, constructing, and improving fixed assets. Explain Significant Spending on Capital Projects Below: Chlorine Auto Emergency Shut Off System $15,382 Trucks (3) & Backhoe (1) $206,063 Encumb: CNG truck conv (1) $8,075 Form 3 73 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital IMonth Au ust Fund /Department Number 623 1 Date Updated 9.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 545 544 1,402 1 100% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 545 544 1,402 1 100% Expenditures Personnel - - - 0% Supplies 50,914 86,470 107,542 (35,556) 170% Services 2,171 36,843 42,103 (34,672) 1697% Debt Service - - - 0% Capital - 59,529 374,711 (59,529) 0% Transfers Out 245 240 - 5 98% Total Expenditures 53,330 183,082 524,356 i (129,752) 343% Net (52,785) (182,539) (522,954) 129,754 Cash Balance 289,676 Staffing Full Time Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The purpose of this fund is to segregate the use of bond proceeds that are applied to the acquisition, construction and installation of certain additions, extension and improvements. Revenue bonds were issued in June 2012 with an aggregate principal of $8,300,000. A 2015 budget was not established for this fund based on assumptions of bond proceeds being 100% depleted by December 31, 2014. Funds are fully expended as of July 14, 2015. A Budget Transfer Form B was submitted in quarter 3 to appropriate a budget for final use of the proceeds. Explain Significant Spending on Capital Projects Below: Water Meters $58,193 Pinhook WT Effic Improv Proj $122,478 Boland Park PRV $2,171 Form 3 74 Form 3 75 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit IMonth Au ust Fund /Department Number 624 1 Date Updated 9.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 6,000 334 6,390 3,216 (390) 107% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In - - - 40 - 0% Total Revenue 6,000 334 6,390 3,256 (390) 107% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 6,000 334 5,536 3,216 464 92% Total Expenditures 6,000 334 5,536 3,216 464 92% Net - - 855 40 (855) Cash Balance 1,501,671 1,466,809 Staffing Full Time - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The purpose of this fund is to retain security deposits collected from customers when establishing new service. Upon termination of service, these deposits are released and credited against final bills. Explain Significant Spending on Capital Projects Below: Form 3 75 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Fund /Department Number 625 Month Au ust Date Updated 9.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 5,000 178 2,748 1,170 2,252 55% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 2,045,078 170,275 1,362,440 1,366,480 682,638 67% Total Revenue 2,050,078 170,453 1,365,188 1,367,650 684,890 67% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 2,045,078 400 366,223 384,620 1,678,855 18% Capital - - - - - 0% Transfers Out 5,000 178 2,745 1,170 2,255 55% Total Expenditures 2,050,078 578 368,968 385,790 1,681,110 18% Net - 169,875 996,220 981,860 (996,220) Cash Balance 1,000,876 987,197 Staffing Full Time Part -Time /Seasonal /Temporary Total txpiam signrcicant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. The source of monies for debt repayment are transfers from the water utility operating fund 620. Biannual installments are disbursed at the end of June and December. Explain Significant Spending on Capital Projects Below: Form 3 76 Form 3 77 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve IMonth Au ust Fund /Department Number 626 1 Date Updated 9.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 9,500 359 3,788 3,440 5,712 40% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In - - - 68,512 - 0% Total Revenue 9,500 359 3,788 71,952 5,712 40% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 14,500 7,374 7,126 51% Total Expenditures 14,500 7,374 - 7,126 51% Net (5,000) 359 (3,585) 71,952 (1,415) Cash Balance 1,643,092 1,637,628 Staffing Full Time - - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The purpose of this fund is to ensure compliance with certain debt service bond covenants. Balance in fund is determined by debt service financing arrangements at bond issuance. Maximum reserve requirements have been fully satisfied. Included in the transfer out expense is prior year interest earnings that were not previously transferred to the Operating Fund. Explain Significant Spending on Capital Projects Below: Form 3 77 Form 3 78 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance IMonth Au ust Fund /Department Number 629 1 Date Updated 9.8.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 8,500 499 9,407 4,551 (907) 111% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 154,249 - 150,228 53,507 4,021 97% Total Revenue 162,749 499 159,635 58,058 3,114 98% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 8,500 499 8,204 4,551 296 97% Total Expenditures 8,500 499 8,204 4,551 296 97% Net 154, 249 151,431 53,507 2,818 Cash Balance 2,235,267 2,085,039 Staffing Full Time - - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The purpose of this fund is to hold cash reserves to serve as fiscal protection against the risk of revenue shortfalls, emergencies and other economic risks that may impact the Water Utility's ability to meet financial commitments. Investment earnings are greater than anticipated. Current year transfer in revenue is for policy compliance puposes. Explain Significant Spending on Capital Projects Below: Form 3 78 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Fund /Department Number 640 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 551,200 48,917 403,441 387,298 147,759 73% Interest Earnings 3,600 352 6,601 3,125 (3,001) 183% Bond Proceeds - 0% Donations 0% Other Income 0% Transfers In - 0% Total Revenue 554,800 49,270 410,042 390,423 144,758 74% Expenditures Personnel 206,842 10,767 108,575 113,523 - 98,267 52% Supplies 28,603 2,975 13,373 11,474 7,945 7,285 75% Services 281,802 30,962 182,973 152,132 25,988 72,841 74% Debt Service 28,456 14,218 14,218 - 14,238 50% Capital - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 545,703 44,704 319,139 291,347 33,932 192,632 65% Net 9,097 4,565 90,904 99,076 (33,932) (47,874) Cash Balance 1,597,915 1,459,431 Staffing Full Time 2.20 1.85 - Part -Time /Seasonal /Temporary - - Total 2.20 1.85 txpiam signrncant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: The Sewer Insurance program is funded by a monthly charge on city residents' sewer bills. The city is responsible for the main sewer line; from the main line to the house is the homeowner's responsibility. This program helps residents who have an issue with their lateral that cannot be resolved by a simple clean -out by a plumber, i.e., collapsed line, complete root infiltration, etc. that requires excavation work. The program is set up so that the homeowner pays a $500.00 deductible toward the cost of the repair and the city pays the rest. Explain Significant Spending on Capital Projects Below: Form 3 79 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations Fund /Department Number 641 Month Au ust Date Updated 1 9/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 35,209,467 3,135,226 23,507,841 22,177,357 11,701,626 67% Interest Earnings 22,000 1,893 37,473 12,115 (15,473) 170% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 92,100 11,226 71,143 67,207 20,957 77% Transfers In 15,000 821 13,470 7,488 1,530 90% Total Revenue 35,338,567 3,149,166 23,629,927 22,264,167 11,708,640 67% Expenditures Personnel 7,402,560 450,230 4,402,610 4,548,524 2,999,950 59% Supplies 2,154,745 102,748 793,303 976,234 209,941 1,151,501 47% Services 15,178,782 906,377 6,797,750 6,549,591 955,342 7,425,690 51% Debt Service 585,187 548 325,880 297,675 - 259,307 56% Capital - - - - - 0% Transfers Out 14,875,700 4,773,536 14,444,376 10,329,316 - 431,324 97% Total Expenditures 40,196,974 6,233,439 26,763,918 22,701,341 1,165,283 12,267,773 69% Cash Balance 5,791,676 Staffing Full Time 95.25 85.40 Part -Time /Seasonal /Temporary 6.62 2.00 Total 101.87 87.40 txpiam signrcicant ttevenue, txpenanure ana stattmg cnangesivanances tseiow: This enterprise fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Debt service payments are made in accordance with City amortization schedules. All other operating expense categories are falling within budgeted range. txpiam signrcicant spenamg on t apnai vrotecis tseiow: Capital spending for Sewage works is shown in Fund 642. Form 3 80 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Fund /Department Number 642 Month Au ust Date Updated 1 9/10/2015 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Kevenue 0% Property Taxes 0% Local Income Taxes (1,852) 0% Other Taxes - 0% Grants /Intergovernmental 3,232,656 0% Charges for Services - 0% Interest Earnings 39,000 1,402 21,165 11,496 17,835 54% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 5,359,000 4,000,000 8,000,000 4,000,000 (2,641,000) 149% Total Revenue 5,398,000 4,001,402 8,021,165 4,011,496 1 (2,623,165) 149% Personnel 0% Supplies 0% Services 36,043 37,895 55,537 (1,852) 105% Debt Service - - - - - - 0% Capital 7,035,667 430,722 1,971,228 3,059,067 1,831,783 3,232,656 54% Transfers Out - - - - - - 0% Total Expenditures 7,071,710 430,722 2,009,123 3,114,604 1,831,783 3,230,804 54% ICash Balance btatrmg Full Time Part-Time /Seasonal /Temporary Total 947,560 4,941 txpiam signmcant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: This fund is used to purchase capital equipment and fund major renovations /restorations for the Wastewater and Sewer Departments. The primary source of income is from Sewage Works Operating Fund #641, which transfers funds here as needed. Projects budgeted this year include replacement of the Calvert St. /Ethanol Lift station, WWTP stand -by power, and replacement vehicles and equipment. txpiam signmcant spenamg on t apnai vrotecis tseiow: Year to Date totals spent include: Wastewater Treatment Plant Primary Clarifier rehab $1,174,238, East Gate Lift Station $364,307, Utility vehicle used at WWTP $13,131, Sewer Dept vehicles & equipment $444,223. Form 3 81 Form 3 82 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. I JMonth Au ust Fund /Department Number 643 1 Date Updated 9/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 15,000 821 15,445 7,488 (445) 103% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 256,612 - 256,086 129,964 526 100% Total Revenue 271,612 821 271,531 137,452 81 100% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 15,000 821 13,470 7,488 1,530 90% Total Expenditures 15,000 821 13,470 7,488 1,530 90% Net 256, 612 258,061 129,964 (1,449) Cash Balance 3,678,649 3,422,564 Staffing Full Time - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The purpose of this fund is to hold the equivalent of two months of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. A transfer to this fund was done in February to adjust the balance to stay in compliance. Explain Significant Spending on Capital Projects Below: Form 3 82 Form 3 83 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 IMonth Au ust Fund /Department Number 647 1 Date Updated 9/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 3 0% Bond Proceeds - 0% Donations 0% Other Income 0% Transfers In - 0% Total Revenue 3 0% Expenditures Personnel - 0% Supplies - 0% Services 1,143 0% Debt Service - 0% Capital - - 0% Transfers Out 0 0 - (0) 0% Total Expenditures 0 0 1,143 (0) 0% Net (0) (0) (1,141) 0 Cash Balance 0 Staffing Full Time Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This Bond, issued in 2007, is now fully spent. The $.14 cash balance was transferred to Bond Fund 661 so this fund can now be closed. Explain Significant Spending on Capital Projects Below: Form 3 83 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinkin Fund /Department Number 649 Month Au ust Date Updated 9/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 7,000 959 12,686 5,661 (5,686) 181% Bond Proceeds - - - - 0% Donations 0% Other Income - - - - 0% Transfers In 9,281,088 773,536 6,188,290 6,199,352 3,092,798 67% Total Revenue 9,288,088 774,495 6,200,976 6,205,013 3,087,112 67% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 2,500 350 3,300 2,800 (800) 132% Debt Service 9,279,609 - 1,589,361 1,672,252 7,690,248 17% Capital - - - - 0% Transfers Out - - - - - 0% Total Expenditures 9,282,109 350 1,592,661 1,675,052 7,689,448 17% Nat 5 Q7Q 77A 1d5 d finR 31d d 5 ?Q QR1 - !d fin? nns,% Cash Balance 0 5,398,651 5,312,768 Staffing Full Time - Part -Time /Seasonal /Temporary Total txpiam signmcant ttevenue, txpenanure ana statrmg cnangesivanances tseiow: This fund is used to pay all debt service obligations for Wastewater and Sewers. Mandatory transfers in from Operating Fund 641 are done in specified amounts each month to satisfy bond covenants. Explain Significant Spending on Capital Projects Below: Form 3 84 Form 3 85 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve IMonth Au ust Fund /Department Number 653 Date Updated 9/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 0% Expenditures Personnel 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 0% Net - Cash Balance 7,286,832 7,286,828 Staffing Full Time - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This Debt Reserve fund is held in a separate account with Bank of NY Mellon Trust. The account was fully funded for existing debt in 2013. A reconcilliation of the account is done monthly. Explain Significant Spending on Capital Projects Below: Form 3 85 Form 3 86 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 IMonth Au ust Fund /Department Number 658 1 Date Updated 9/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0 5 (0) 0% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 0 5 (0) 0% Expenditures Personnel - - - 0% Supplies - 0% Services 924 0% Debt Service - 0% Capital - 0% Transfers Out 2 - (2) 0% Total Expenditures - 2 924 (2) 0% Net - (2) (919) 2 Cash Balance 1,296 Staffing Full Time Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This 2010 bond has been fully spent. There is no 2015 budget. The $2.05 cash balance has been transferred to the 2012 bond (fund 661) so this fund can be closed. Explain Significant Spending on Capital Projects Below: Form 3 86 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 IMonth Au ust Fund /Department Number 659 1 Date Updated 9/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 6,000 115 3,840 15,450 2,160 64% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 6,000 115 3,840 15,450 2,160 64% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 323,670 251 8,064 1,984 9,606 306,001 5% Debt Service - - - - - - 0% Capital 3,388,168 1,077,545 3,103,303 442,920 1,867,703 45% Transfers Out - - - - - 0% Total Expenditures 3,711,838 251 1,085,608 3,105,288 452,526 2,173,704 41% Net (3,705,838) (136) (1,081,768) (3,089,837) (452,526) (2,171,543) Cash Balance 517,617 4,758,662 Staffing Full Time - - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This Sewage Works Revenue Bond closed in October of 2011. A number of projects have been funded from this bond; the more significant ones are listed below. Explain Significant Spending on Capital Projects Below: From issue late in 2011, this bond has funded numerous projects including Diamond Ave. Trunk Sewer, Phase II $3.7 million, East Bank Sewer Separation, Phase II $2.8 million, East Bank Sewer Separation, Phase III $2.3 million, LaSalle School Area Sewer Separation, $1.7 million, East Bank Sewer Separation, Phase III $545,000, Southwood Sewer Separation, $1,295,171, Diamond Ave. Trunk Sewer, Phase III $248,000, St. Joseph River CSO Stabilization $217,831, Secondary Clarifier Upgrade $494,141, Wastewater Treatment Plant Digester Upgrade $5,639,949. Form 3 87 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Fund /Department Number 661 Month Au ust Date Updated 9/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Kevenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 40,000 3,483 70,133 39,568 (30,133) 175% Bond Proceeds - - - - 0% Donations 0% Other Income - 0% Transfers In - - 5 - (5) 0% Total Revenue 40,000 3,483 70,138 39,568 (30,138) 175% Expenditures Personnel - - - - 0% Supplies - 0% Services 1,000,000 1,000,000 0% Debt Service - - - - - 0% Capital 15,624,275 398,397 1,751,939 523,779 2,009,247 11,863,090 24% Transfers Out - - - - - - 0% Total Expenditures 16,624,275 398,397 1,751,939 523,779 2,009,247 1 12,863,090 1 23% ICash Balance btamng Full Time Part-Time /Seasonal /Temporary Total 137,464 17,814,816 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: txpiam signrcscam spenamg on capnai vrotecis tseiow: Projects funded from this Bond in 2013 and 2014 included: East Bank Sewer Separation -Phase 4 $2.6 million, Diamond Ave. Sewer Separation - Phase 3, $2.6 million, Prairie Avenue Sewer Separation $404,420, and Southwood Sewer Separation $899,943. Spending in 2015 has been for Prairie Ave. Sewer Separation $188,415, Fairfax Sewer $70,022, East Bank Sewer Separation -Phase 5 $442,406, Sewer Sensory Control Network $176,941, Southwood Sewer Separation $18,033, Wastewater Treatment Plant Grit/Screening Improvements $111,491, Secondary Clarifier Modifications $342,842, CSO LTCP re -look $379,701, and misc other $2,070. Form 3 88 Form 3 89 2015 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund IMonth Au ust Fund /Department Number 664 1 Date Updated 9/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 50 1 19 10 31 39% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 50 1 19 10 31 39% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - 0% Net 50 1 19 10 31 Cash Balance 4,500 4,478 Staffing Full Time - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund was set up to pay the issue costs related to the re- funding of the 2004 Sewer bond and 1998 SRF Loan. Those costs were paid in 2013. The remaining cash balance should be transferred to an appropriate fund, so this fund can be closed out. Explain Significant Spending on Capital Projects Below: Form 3 89 Form 3 90 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center IMonth Au ust Fund /Department Number 670 1 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 1,313,436 1,313,450 1,335,426 (14) 100% Grants /Intergovernmental - - - - 0% Charges for Services 2,490,815 342,621 1,460,038 1,574,449 1,030,777 59% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 15,000 40,982 15,000 0% Transfers In - - - - - 0% Total Revenue 3,819,251 342,621 2,773,488 2,950,857 1,045,763 73% Expenditures Personnel 2,505,817 175,853 1,383,259 1,436,579 1,122,558 55% Supplies 496,646 61,112 382,798 358,067 113,848 77% Services 1,286,148 100,551 883,576 825,745 402,572 69% Debt Service - - - - - 0% Capital 243,951 243,951 0% Transfers Out - - - - - 0% Total Expenditures 4,532,562 337,516 2,649,633 2,620,391 1,882,929 58% Net (713,311) 5,105 123,855 330,466 (837,166) Cash Balance 1,440,552 969,389 Staffing Full Time - - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: SMG has assumed management of Century Center effective July 1, 2013. One of their contractual duties is to reduce the operating deficit in the fund. Covered by hotel /motel tax revenue which is received twice per year. The first installment was received in February 2015. Other income includes charges to large conferences for electric costs. Although charges for services are down, personnel expenditures are also down as they are controlling their costs. Also, charges for services will likely stay low as the Century Center is going to begin many energy savings construction projects which is putting many of their rooms out of inventory for months at a time. However, the energy savings and their efforts to become more "green" will likely help attract future business. Explain Significant Spending on Capital Projects Below: Form 3 90 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Month Au ust Fund /Department Number 671 1 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 500 366 233 134 73% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 500 366 233 134 73% Expenditures Personnel - - - - 0% Supplies 53,356 41,156 12,200 77% Services 192,000 192,735 (735) 100% Debt Service - - - - - 0% Capital 310,300 4,190 54,630 339,363 255,670 18% Transfers Out 50,000 - 50,000 - - 100% Total Expenditures 605,656 4,190 338,521 339,363 267,135 56% Net (605,156) (4,190) (338,155) (339,130) (267,001) Cash Balance 1,080,508 1,418,568 Staffing Full Time - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: SMG contributed a one time amount of $575,000 to cover capital expenses in August 2013. The remainder of these funds have been appropriated for spending during 2015. $25,000 was appropriated to help pay for the Wall of Fame in conjunction with the South Bend Alumni Association. $50,000 was transferred out to the new fund 672 for bond payments on the Energy Savings Contract. Explain Significant Spending on Capital Projects Below: A Qualified Energy Conservation Bond was taken out in May 2015. Approximately $192,000 will be used as a down payment on the construction contract, thus reducing the amount necessary to be funded by bond issuance. The actual bond payments will be made with hotel /motel funds through a new fund, Century Center Energy Conservation Debt Service, that was seeded with a $50,000 transfer from this fund in May. Form 3 91 Form 3 92 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Energy Conservation Debt Svc IMonth Au ust Fund /Department Number 672 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 11 (11) 0% Bond Proceeds - - 0% Donations 0% Other Income 0% Transfers In 50,000 50,000 - 100% Total Revenue 50,000 50,011 (11) 100% Expenditures Personnel - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - 0% Net 50,000 50,011 (11) Cash Balance 50,011 Staffing Full Time - - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: A Qualified Energy Conservation Bond was taken out in May 2015. The $50,000 was transferred from the capital fund to set up the fund for future bond payments. Explain Significant Spending on Capital Projects Below: Form 3 92 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month Au ust Fund /Department Number 222 1 Date Updated 1 9/10/2015 Current Current Current Prior 1,776,721 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget mevenue 3,099,267 195,141 1,796,298 1,776,721 1,302,969 Property Taxes Supplies 167,428 (12,657) 64,163 117,175 0% Local Income Taxes 43% Services 4,611,385 366,257 2,970,253 0% Other Taxes 849,878 82% Debt Service 9,155 210 0% Grants /Intergovernmental 210 5,488 40% Capital 141,157 0% Charges for Services 8,069,157 547,866 4,917,830 4,764,907 3,151,327 61% Interest Earnings 3,400 283 5,305 2,530 (1,905) 156% Bond Proceeds - 4,954,172 - 820,639 2,525,431 0% Donations - - 0% Other Income 78,627 3,958 80,609 119,673 (1,982) 103% Transfers In - - - - - 0% Total Revenue 8,151,184 552,107 5,003,744 4,887,109 3,147,440 61% Personnel 3,099,267 195,141 1,796,298 1,776,721 1,302,969 58% Supplies 167,428 (12,657) 64,163 117,175 8,318 94,947 43% Services 4,611,385 366,257 2,970,253 2,934,978 791,254 849,878 82% Debt Service 9,155 210 3,458 4,871 210 5,488 40% Capital 141,157 120,000 20,857 300 100% Transfers Out 271,850 - - - - 271,850 0% Total Expenditures 8,300,242 548,951 4,954,172 4,833,746 820,639 2,525,431 70% Cash Balance d string Full Time 42.00 40.00 40.00 Part-Time /Seasonal /Temporary 4.00 2.00 2.00 Total 46.00 42.00 42.00 txpiam bigmrscant stevenue, txpenanure ana btattmg s:nangesivanances tseiow: The Central Services Division consists of six cost centers that provide a variety of services to other city departments, along with several local county, state and federal agencies. The supply acct. goes up and down, depending on vehicle repairs. In August we had 1,249 vehicle repairs. Average Fuel prices for August is $2.06 for Unleaded and $1.94 for Diesel. Budgeted amount per gallon is $3.45. Sustainability Office ended two internships and made some small expenditures to offer recycling at Art Beat and for Green Ribbon Commission meetings. Majority of recycling costs were volunteer labor and borrowed equipment. A new intern will begin in September. txpiam signrcscant spenamg on t apnai vrotecis tseiow: The capital expenses for 2015 were moved to a new Fund #224 for $271,850. We are transfering monies out of our cash reserve over to fund 224 to cover our 2015 capital expenses. We had $120,000 roll over from 2014 to 2015 for capital expenses to converting our garage so we can work on CNG vehicles. Form 3 93 Form 3 94 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Capital JMonth Au ust Fund /Department Number 224 Date Updated 9/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 271,850 271,850 0% Total Revenue 271,850 271,850 0% Expenditures Personnel - - 0% Supplies 0% Services 0% Debt Service 0% Capital 271,850 28,196 243,654 10% Transfers Out - - - 0% Total Expenditures 271,850 28,196 243,654 10% Net - - (28,196)1 28,196 Cash Balance Staffing Full Time Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This is a new fund for 2015. Revenues are a transfer from Central Services. Explain Significant Spending on Capital Projects Below: Capital projects for 2015 include a roof replacement for the Equipment Services building ($171,850), six (6) mobile comm lifts ($10,000 each) and an inground hoist ($40,000). Form 3 94 2015 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance Fund /Department Number 226 Month Au ust Date Updated 1 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 1,222,727 104,502 815,178 1,906,479 407,549 67% Interest Earnings 20,500 1,017 22,591 11,290 (2,091) 110% Bond Proceeds - - - - 0% Donations - - - 0% Other Income 19,375 2,375 47,667 17,000 12% Transfers In - - - - - 0% Total Revenue 1,262,602 105,519 840,144 1,965,436 422,458 67% Expenditures Personnel 314,491 16,300 152,312 123,054 - 162,179 48% Supplies 30,189 933 24,884 9,510 1,383 3,922 87% Services 2,712,111 53,602 1,917,796 1,716,669 32,377 761,939 72% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 3,056,791 70,834 2,094,992 1,849,233 33,759 928,040 70% Cash Balance 4,425,225 5,301,701 Staffing Full Time 3.00 2.00 Part -Time /Seasonal /Temporary - - Total 3.00 2.00 txpiam bigmricant ttevenue, txpenanure ana btatrmg L;nangesivanances tseiow: This fund handles operations relating to business insurance and claims: property, liability, workers compensation, etc. and the operation of the safety and risk department. Position vacancy, due to retirement, has not yet been filled. txpiam signnicant spenamg on t apnai vrotecis tseiow: No capital expenditures are budgeted in 2015. Form 3 95 Form 3 96 2015 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police IMonth Au ust Fund /Department Number 278 1 Date Updated 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 61,100 4,510 41,480 42,360 19,620 68% Interest Earnings 2,000 130 2,355 1,059 (355) 118% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 61,100 4,510 41,480 42,253 19,620 68% Transfers In - - - - - 0% Total Revenue 124,200 9,150 85,315 85,672 38,885 69% Expenditures Personnel - - - - - 0% Supplies 61,100 - 61,100 0% Services 10,000 1,086 8,914 11% Debt Service - - - 0% Capital 0% Transfers Out 0% Total Expenditures 71,100 1,086 - 70,014 2% Net 53,100 9,150 84,229 85,672 (31,129) Cash Balance 600,241 538,625 Staffing Full Time - - - Part -Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund charges police officers for liability insurance and gasoline costs for take home police vehicles. The cash reserve in this fund has increased in recent years and is expected to increase during 2015. Claims have been minimal in this fund since it was created. This fund is classified as an Internal Service Fund for financial reporting. No liability claims were paid during 2014. Explain Significant Spending on Capital Projects Below: None Form 3 96 Form 3 97 2015 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits IMonth Au ust Fund /Department Number 711 1 Date Updated 9/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental - - - - - 0% Charges for Services 16,315,000 1,187,845 9,651,435 8,594,531 6,663,565 59% Interest Earnings 23,345 1,159 19,829 12,351 3,516 85% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 19,425 19,399 170,978 26 100% Transfers In - - - - - 0% Total Revenue 16,357,770 1,189,005 9,690,662 8,777,860 6,667,108 59% Expenditures Personnel 4,326 1 7 - - 4,319 0% Supplies 21,875 1,302 8,039 29,719 7,271 6,565 70% Services 844,520 55,026 494,078 429,934 144,215 206,227 76% Insurance 15,826,214 1,189,690 8,664,768 9,438,703 23,012 7,138,433 55% Debt Service - - - - - - 0% Capital 0% Transfers Out - - - - - - 0% Total Expenditures 16,696,935 1,246,018 9,166,892 9,898,357 174,498 7,355,545 56% Net (339,165) (57,014) 523,770 (1,120,497) (174,498) (688,437) Cash Balance 4,580,758 4,540,950 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund handles expenses relating to insurance and claims relating to employees: medical, dental, life, flex spending, etc. For the last several years expenses have significantly exceeded revenues (charges to City Departments and employees) so our cash balance has been eroding. This is not sustainable in the long -term and we need to address this situation. For the 2015 Budget, we increased employer and employee contributions significantly, which should help. We are also working with our insurance advisor on some other options. Claim costs (part of "Insurance" above) are typically lower in the early part of the year, but this is attributable to employees still meeting their deductible, so less is paid by the City. We should expect this to trend upwards as the year progresses. Explain Significant Spending on Capital Projects Below: None Form 3 97 2015 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Fund /Department Number 713 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 112,996 8,473 67,787 68,243 45,209 60% Interest Earnings 800 54 1,037 548 (237) 130% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 113,796 8,527 68,824 68,791 44,972 60% Expenditures Personnel 200,000 4,556 48,062 98,047 151,938 24% Supplies - - - - - - 0% Services 26,796 566 13,331 4,816 11,000 2,465 91% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 226,796 5,122 61,393 102,863 11,000 i 154,403 1 32% Cash Balance 248,602 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam signmcant rtevenue, txpenanure ana staffing cnangesivanances tseiow: This fund charges an allocation of 0.5% of payroll to most departments to cover the cost of unemployment claims paid. Due to continued favorable claims, the fund will only charge departments at 0.25% in 2016 unless the claims increase substantially. For the 2015 budget, all outplacement services are paid through this account. These were paid through the General Fund in previous years, however, due to the nature of outplacement claims, the Unemployment Fund is a more appropriate place from which to pay the costs. The Unemployment Compensation Fund is classified as an Internal Service Fund for financial reporting. Claims continue to be lower than anticipated. Explain Significant Spending on Capital Projects Below: None Form 3 98 2015 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension Fund /Department Number 701 Month Au ust Date Updated 1 9/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 5,036,025 2,518,013 2,564,549 2,518,012 50% Grants /Intergovernmental - - - - 0% Charges for Services - - - - 0% Interest Earnings 4,500 984 842 3,516 22% Bond Proceeds - - - - 0% Donations - - 0% Other Income 4,000 1,364 6,411 (2,411) 160% Transfers In - - - - - 0% Total Revenue 5,044,525 1,364 2,525,407 2,565,390 2,519,118 50% Expenditures Personnel 5,661,579 433,611 3,490,016 3,624,375 2,171,563 62% Supplies 200 - - - 200 0% Services 4,800 79 3,642 507 1,158 76% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 5,666,579 433,690 3,493,659 3,624,882 2,172,920 62% Ne} lR99 n5d1 ld39 3981 MAR 7591 11 n5Q d991 - 'AAA 1QR Cash Balance (328,947) (121 Staffing Full Time Part-Time /Seasonal /Temporary Total txpiam aigmncant stevenue, txpenanure ana starting s:nangesivanances tseiow: The Fire Pension fund receives State of Indiana pension relief payments in June and September to reimburse the City for actual pension costs paid and reported in the previous year. For 2015, the payments are expected to be $2,603,546 by 1 July and again by 1 October, totaling $5,207,092. txpiam oignmcam apenamg on -apixai r-rotecis tseiow: No capital expenditures are purchased through this account. Form 3 99 Form 3 100 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Pension Month Au ust Fund /Department Number 702 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 6,375,359 3,187,679 3,055,933 3,187,680 50% Grants /Intergovernmental - - - - 0% Charges for Services - - - - 0% Interest Earnings 6,000 237 1,783 1,850 4,217 30% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 4,000 62 3,938 2% Transfers In - - - - - 0% Total Revenue 6,385,359 237 3,189,524 3,057,783 3,195,835 50% Expenditures Personnel 6,827,035 528,072 4,247,450 4,555,921 2,579,585 62% Supplies 800 - - 151 800 0% Services 4,400 98 3,600 517 800 82% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 6,832,235 528,170 4,251,050 4,556,589 2,581,185 62% Net (446,876) (527,933) (1,061,526) (1,498,806) 614,650 Cash Balance 49,246 209,851 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Police Pension fund receives pension relief distributions from the State of Indiana to reimburse the City for pension costs paid and reported in the previous fiscal year. For 2016, the payments are expected to be $3,062,500 by 1 July and again by 1 October, totaling $6,125,000. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Form 3 100 2015 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Month Au ust Fund /Department Number 730 Date Updated 9/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 150 6 122 81 28 81% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 150 6 122 81 28 81% Expenditures Personnel - - - - - 0% Supplies - - - 0% Services 20,000 8,658 20,000 0% Debt Service - - - 0% Capital 0% Transfers Out 0% Total Expenditures 20,000 - - 8,658 20,000 0% Net (19,850) 6 122 (8,576) (19,972) Cash Balance 28,500 28,358 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is designated for expenses specifically for the City Cemetery. Revenues were originally derived from the sale of cemetery plots and burial expenses.There are few sites available for sale and most plots are occupied, resulting in little burial activty. Explain Significant Spending on Capital Projects Below: Spending this year will concentrate on repairing headstones and completing the GIS survey of the cemetery and its occupants. Form 3 101 2015 City of South Bend Monthly Financial Report Fund /Department Name River West Development Area Airport TIF Month Au ust Fund /Department Number 324 1 Date Updated 1 9/16/2015 Current Current Current Prior 7,521,012 7,037,106 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 16,433,274 9,396,168 7,521,012 7,037,106 57% Local Income Taxes - - - - 0% Other Taxes 490,500 262,315 2,445,398 292,000 1,145,521 198,500 60% Grants /Intergovernmental - - 6,231,656 - - - 0% Charges for Services 18,000 2,623,727 5,402,431 14,061 - 3,939 78% Interest Earnings 102,096 12,591 161,188 52,156 (59,092) 158% Bond Proceeds - - - 101,267 21,256,183 0% Donations - - - - 0% Other Income 2,937,336 46,105 1,739,423 101,853 1,197,913 59% Transfers In 4,963,040 619 4,982,087 2,289 (19,47 0) 100% Total Revenue 24,944,246 59,315 16,584,927 7,778,577 8,359,319 66% Personnel 0% Supplies 0% Services 6,231,817 262,315 2,445,398 2,588,619 1,145,521 2,640,898 58% Debt Service 6,475,584 - 6,231,656 2,663,953 - 243,928 96% Capital 35,003,196 2,623,727 5,402,431 47,284 11,229,408 18,371,357 48% Transfers Out - - - - - - 0% Total Expenditures 47,710,597 2,886,042 14,079,485 5,299,856 12,374,929 21,256,183 55% Cash Balance wring Full Time Part-Time /Seasonal /Temporary Total 736 27 txpiam signrcicant ttevenue, txpenanure ana starting cnangesivanances tseiow: While one can find usefulness in reviewing revenue trends in TIF funds from one year to the next, because projects change wildly from one year to the next, it is less meaningful to examine year to date expenditures against the prior year to date. Due to changes in boundary, this area now includes the former Central Medical District (Fund 426) and a portion of South Bend Central Development Area (Fund 420). The appropriate 2015 budgets, revenues and expenses for these funds have been transferred into this fund. txpiam signmcam spenamg on -.apnai r-rotecis cseiow: Major projects carried out/started in 2014 were: Renaissance District Phase II; the Studebaker /Oliver Project; and continued Ignition Park South & East acquisitions. In 2015, the major projects thus far approved are: the Ameriplex lease, Bartlett Roundabout, Ignition Park infrastructure and Multi- tenant building, LaSalle Hotel, ND /GE Turbo Project, Nello, Noble Energy, Western Avenue Improvements, Patel Hotel, and Studebaker Envionmental. Major project expenditures (other than debt service) to date have been made on: Nello (about $2.1 M); Noble Energy (about $1.4M) and Renaissance District (about $1.4M). Form 3 102 Form 3 103 2015 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown Month Au ust Fund /Department Number 420 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,485,266 0% Local Income Taxes - 0% Other Taxes 200,000 0% Grants /Intergovernmental - 0% Charges for Services 25,599 0% Interest Earnings 29,005 0% Bond Proceeds - 0% Donations - 0% Other Income 197,332 0% Transfers In 3,824 0% Total Revenue 2,941,026 0% Expenditures Personnel - 0% Supplies - 0% Services 307,831 0% Debt Service 2,772,964 0% Capital 15,457 0% Transfers Out 4,088,473 4,088,473 - 100% Total Expenditures 4,088,473 4,088,473 3,096,252 100% Net (4,088,473) (4,088,473) (155,226) Cash Balance 2,449,248 Staffing Full Time Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: In 2015 SBCDA is eliminated and all funds were distributed between Fund 324 River West and Fund 429 River East. This is the result of the TIF realignment. Explain Significant Spending on Capital Projects Below: Form 3 103 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Fund /Department Number 422 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 420,000 195,866 304,152 224,134 47% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 2,800 305 5,109 1,389 (2,309) 182% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 422,800 305 200,975 305,541 221,825 48% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 30,600 30,294 679 3,366 (3,060) 110% Debt Service - - - - - 0% Capital 730,300 730,300 0% Transfers Out - - - - - 0% Total Expenditures 760,900 30,294 679 3,366 727,240 4% Cash Balance 1,366,430 917 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmncant ttevenue, txpenanure ana btattmg L;nangesivanances tseiow: TIF projects vary widely from year to year so little can be gained by comparing expenditures from year to year. Major Projects committed thus far in 2015 are: City Cemetery Project. txpiam signrncant spenamg on t apnai vrojecis tseiow: Major projects committed thus far in 2015 are: City Cemetery Project. Other TIF eligible development projects for this TIF area will be determined by department staff and the Mayor's office as the year progresses. Form 3 104 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Fund /Department Number 425 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 300 37 614 197 (314) 205% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 189,123 6,125 106,147 106,914 82,976 56% Transfers In - - - - - 0% Total Revenue 189,423 6,162 106,761 107,111 82,662 56% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 154,716 8,589 83,257 73,939 71,459 54% Debt Service - - - - - 0% Capital 16,536 0% Transfers Out - - - - 0% Total Expenditures 154,716 8,589 83,257 90,475 71,459 54% NPt 'AA 7m 12 A971 ?a Ana 1 a SIR ii qn3 Cash Balance 196,030 149,703 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmncant stevenue, txpenanure ana btattmg s:nangesivanances tseiow: Operations under outside contract with Bradley Co. so all expenses except capital are shown under Services line, to show consistently with Parking Garages and Blackthorn Golf Course. Explain Significant Spending on Capital Projects Below: Form 3 105 Form 3 106 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Month Au ust Fund /Department Number 426 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 459,659 0% Local Income Taxes - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - 0% Interest Earnings 5,961 0% Bond Proceeds - 0% Donations 0% Other Income 0% Transfers In - 0% Total Revenue 465,620 0% Expenditures Personnel - 0% Supplies - 0% Services 1,543,685 0% Debt Service - 0% Capital 237,889 0% Transfers Out 2,294,533 2,294,533 100% Total Expenditures 2,294,533 2,294,533 1,781,574 100% Net (2,294,533) (2,294,533) (1,315,954) Cash Balance 1,916,459 Staffing Full Time Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: In 2015 Central Medical Service Area is eliminated and all funds will be distributed to Fund 324 River West. This is the result of the TIF realignment. Explain Significant Spending on Capital Projects Below: Form 3 106 Form 3 107 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Development Area NE Dev TIF Month Au ust Fund /Department Number 429 1 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,342,330 1,391,012 808,184 951,318 59% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 37,000 1,623 24,661 6,752 12,339 67% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 19,357 19,357 100% Transfers In 1,430,966 - 1,430,965 - 1 100% Total Revenue 3,829,653 1,623 2,865,995 814,936 963,658 75% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 126,044 62,717 1,475 54,372 8,955 93% Debt Service - - - - - - 0% Capital 7,113,480 56,721 142,989 177,524 6,792,967 5% Transfers Out - - - - - - 0% Total Expenditures 7,239,524 56,721 205,706 1,475 231,896 6,801,922 6% Net (3,409,871) (55,098) 2,660,289 813,461 (231,896) (5,838,264) Cash Balance 7,216,770 3,822,252 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Due to changes in boundary, this area now includes a portion of South Bend Central Development Area (Fund 420). Explain Significant Spending on Capital Projects Below: Projects committed to in 2015 include: 5 Points Utility Study, Hill Street Improvements and the NW Corner of Hill & Colfax. Form 3 107 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 Fund /Department Number 430 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior 1,101,026 54% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 2,400,000 1,298,974 1,268,946 1,101,026 54% Local Income Taxes - - - - 0% Other Taxes - 0% Grants /Intergovernmental 1,548,212 0% Charges for Services - 0% Interest Earnings 10,750 1,264 19,970 7,436 (9,220) 186% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 2,410,750 1,264 1,318,944 1,276,382 1,091,806 55% Personnel 0% Supplies 0% Services 669,885 135,591 301,575 157,506 348,413 19,897 97% Debt Service - - - - - - 0% Capital 2,172,650 127,146 578,279 396,407 46,159 1,548,212 29% Transfers Out - - - - - - 0% Total Expenditures 2,842,535 262,737 879,854 553,913 394,572 1,568,109 45% Cash Balance 5,405,900 4,162,117 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmncant ttevenue, txpenanure ana btatfmg L;nangesivanances tseiow: TIF projects vary widely from one year to the next so expenditure comparison will not yield reliable trend review. txpiam signrncant spenamg on t apnai vrotecis tseiow: Projects committed to in 2014 were: completion of the Fellows Street Corridor Project; Ireland & Miami Area Improvements; Main /Lafayette Crossover Project and Walter Street Sidewalks. Projects committed to in 2015 include: Chippewa Improvements, Fellows Street Corridor, Ireland & Miami Area Improvements, Ireland Road Acquisition Services, Main - Lafayette Crossover Connector and MetroNet. Form 3 108 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Fund /Department Number 435 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 320,000 163,944 160,947 156,056 51% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 750 48 471 589 279 63% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 256 (256) 0% Transfers In - - - - - 0% Total Revenue 320,750 48 164,671 161,536 156,079 51% Expenditures Personnel - - - - - 0% Supplies - - - 0% Services 4,200 - - 160 4,200 100% Debt Service 341,189 171,567 341,187 395,461 - 2 100% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 345,389 171,567 341,187 395,621 4,200 2 100% Cash Balance 44,914 60,516 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmncant ttevenue, txpenanure ana btaffmg L;nangesivanances tseiow: The Douglas Road TIF was established to develop the road and area near Brown Mackie College near the South Bend - Mishawaka border. The fund borrowed money from the City of Mishawaka ($1,086,550) and Major Moves Fund 412 ($1,000,000) to finance initial construction. The fund uses TIF tax revenue to repay the loans. During February, 2015 the amounts due Mishawaka were paid in full and the amount due to Major Moves was $787,402. Payments will now be accelerated on the Major Moves loan in order to pay it off early as well. txpiam signfficant spenamg on t apnai vrotecis tseiow: Projects for 2014 include: the Douglas Road Turn Lane. Form 3 109 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Residential NE Res TIF Fund /Department Number 436 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior 935,428 64% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 2,599,000 1,663,572 1,382,498 935,428 64% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 5,000 1,571 2,762 3,429 31% Bond Proceeds - - - - 0% Donations - - - 0% Other Income 211,000 210,999 1 100% Transfers In - - - - 0% Total Revenue 2,815,000 1,876,142 1,385,260 938,858 67% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 3,425,632 246,589 3,425,628 3,115,718 4 100% Capital - - - 214,573 - 0% Transfers Out - - - - - 0% Total Expenditures 3,425,632 246,589 3,425,628 3,330,291 4 100% Net min 8391 19AS 9RQ1 11 5dQ ARRI (1 Qd5 n311 - Q3R RRA Cash Balance 156,018 Staffing Full Time - Part-Time /Seasonal /Temporary Total txpiam bigmncant ttevenue, txpenanure ana btaffmg L;nangesivanances tseiow: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Debt Service is related to the Eddy Street Commons Bonds Explain Significant Spending on Capital Projects Below: Form 3 110 Form 3 111 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Month Au ust Fund /Department Number 433 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 252 2 43 39 209 17% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 252 2 43 39 209 17% Expenditures Personnel - - - - - 0% Supplies - - - 0% Services 6,000 15,703 6,000 0% Debt Service - - - 0% Capital 0% Transfers Out 0% Total Expenditures 6,000 - 15,703 6,000 0% Net (5,748) 2 43 (15,664) (5,791) Cash Balance 10,134 10,084 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund's sole expenditure is for general legal fees for DCI based on an engagement letter Explain Significant Spending on Capital Projects Below: Form 3 111 2015 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Fund /Department Number 439 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 33,904 888 20,448 8,120 13,456 60% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 33,904 888 20,448 8,120 13,456 60% Expenditures Personnel - - - - - 0% Supplies - - 0% Services 64 (64) 0% Debt Service - - - - - 0% Capital 5,000,000 506,250 1,793,604 1,726,115 1,480,281 70% Transfers Out - - - - - 0% Total Expenditures 5,000,000 506,250 1,793,668 1,726,115 1 1,480,217 1 70% Cash Balance 3,247,341 3,690,715 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: txpiam signrcscam spenamg on capnai vrotecis tseiow: Capital funds are to be expended in Ignition Park and Innovation Park. Form 3 112 Form 3 113 2015 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Month Au ust Fund /Department Number 454 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 1,500 85 1,622 830 (122) 108% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,500 85 1,622 830 (122) 108% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - 0% Net 1,500 85 1,622 830 (122) Cash Balance 379,063 377,201 Staffing Full Time - - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: No significant issues. Explain Significant Spending on Capital Projects Below: Form 3 113 2015 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations Fund /Department Number 619 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 119,799 119,297 1,264,783 502 100% Interest Earnings - - - - 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 119,799 119,297 1,264,783 502 100% Expenditures Personnel - - - - 0% Supplies - - - - 0% Services 201,649 201,228 1,070,589 421 100% Debt Service - - - - 0% Capital 8,816 0% Transfers Out - - - 0% Total Expenditures 201,649 201,228 1,079,405 421 100% Nat /R1 Rrm - /R1 Q111 1RS 37R - R1 Cash Balance 0 293,017 Staffing Full Time Part-Time /Seasonal /Temporary Total txpiam bigmncant Kevenue, txpenanure ana btattmg s:nanges /variances tseiow: Course operations under outside contract with Billy Casper Golf so all expenses except capital are shown under Services to show consistently with Parking Garages and Redevelopment Retail. The course has been sold to a private owner. The sale was completed in February, 2015. Explain Significant Spending on Capital Projects Below: Equipment payments Form 3 114 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Month Au ust Fund /Department Number 315 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 5,000 232 4,457 2,289 543 89% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 5,000 232 4,457 2,289 543 89% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 5,000 232 3,857 2,289 1,143 77% Total Expenditures 5,000 232 3,857 2,289 1,143 77% Net - - 600 (600) Cash Balance 1,038,904 1,038,904 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Explain Significant Spending on Capital Projects Below: Form 3 115 Form 3 116 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Month Au ust Fund /Department Number 317 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 1,800 113 2,170 1,110 (370) 121% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,800 113 2,170 1,110 (370) 121% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - 0% Net 1,800 113 2,170 1,110 (370) Cash Balance 507,072 504,583 Staffing Full Time - - - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Debt service reserve fund. The fund is at the proper level per the bond financial advisor, Crowe Horwath. No additional transfers -in are needed. Any interest variations due to City policy on investments and increase in cash available to earn interest. Explain Significant Spending on Capital Projects Below: Form 3 116 Form 3 117 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Month Au ust Fund /Department Number 328 Date Updated 9/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 6,000 387 7,447 3,824 (1,447) 124% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 6,000 387 7,447 3,824 (1,447) 124% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital - - - - 0% Transfers Out 6,000 387 6,445 3,824 (445) 107% Total Expenditures 6,000 387 6,445 3,824 (445) 107% Net - - 1,002 (1,002) Cash Balance 1,735,840 1,735,840 Staffing Full Time - Part-Time /Seasonal /Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (324 - River West). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Explain Significant Spending on Capital Projects Below: Form 3 117 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Fund /Department Number 432 Month Au ust Date Updated 1 9/16/2015 Current Current Current Prior (11,490) 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 11,490 9,175 (11,490) 0% Local Income Taxes - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - - 0% Interest Earnings 25,000 1,204 23,778 13,376 1,222 95% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 25,000 1,204 35,268 22,551 (10,268) 141% Expenditures Personnel - - - - 0% Supplies - - - 0% Services 203,000 201,724 656 1,276 99% Debt Service 488,380 488,380 491,495 - 100% Capital - - - 0% Transfers Out - - - 0% Total Expenditures 691,380 690,104 492,151 1,276 100% Net (666,380) 1,204 (654,836) (469,600) (11,544) Cash Balance 5,848,019 6,499,086 Staffing Full Time Part-Time /Seasonal /Temporary Total txpiam bigmncant stevenue, txpenanure ana btattmg s:nangesivanances tseiow: The purpose of this fund is to pay off debt. We will not be requesting additional funds from the TIF. The first opportunity to pay off the bond will be February, 2017. The plan is to pay off the bond at that time along with the prepayment penalty. $201,724 payment in 2015 is return of prior year taxes to St. Joseph County. Explain Significant Spending on Capital Projects Below: Form 3 118