The URL can be used to link to this page

Home My WebLink About07-2015 Departmental Financial ReportPeriod Ending: Issued By: July 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 66 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 July 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 staffing variances 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 18`" 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 20 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 July 31, 2015, total revenue for the year was $159,482,137, 56% of estimated revenue. As of July 31, 2014 total revenue received was $145,854,527 within the same funds. Property taxes are received in June and December each year and are budgeted at $69,690,508 for 2015, 25% 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 31 July. Local income taxes are received on a monthly basis. 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. 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 July 31, 2015, total expenditures were $163,437,897 and outstanding encumbrances were $38,971,923, a total of $202,409,820 which represents 54% 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 43% of the amended expenditure budget at the end of the period. Total expenditures were $153,799,920 as of July 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 July 31, 2015 General Fund 52,822,478 1,224,771 29,737,583 29,576,454 1,462,385 56% Special Revenue 102 Rainy Day 34,680 5,809 35,199 17,494 (519) 101% 103 Excess Levy 20 2 12 - 8 58% 201 Parks & Recreation 11,030,715 431,931 6,179,539 6,057,540 4,851,176 56% 202 Motor Vehicle Highway 9,701,800 328,650 5,134,169 4,990,015 4,567,631 53% 203 Recreation Nonreverting 1,578,935 97,148 610,379 641,681 968,556 39% 209 Studebaker - Oliver Reverting Grants 644,000 9,340 83,202 2,199 560,798 13% 210 Economic Development State Grants 3,673,510 400,000 436,939 36,749 3,236,571 12% 211 Department of Community Investment (DCI) 2,634,425 9,332 1,156,137 1,077,251 1,478,288 44% 212 Dept of Community Investment Grants 5,890,000 85,649 1,219,374 2,281,771 4,670,626 21% 216 Police State Seizures 36,050 13,631 15,076 23,857 20,974 42% 217 Gift, Donation, Bequest 398,800 370 3,791 171,287 395,009 1% 218 Police Curfew Violations 1,025 21 99 337 926 10% 220 Law Enforcement Continuing Education 270,000 20,976 191,703 127,027 78,297 71% 227 Loss Recovery 60,000 2,938 49,782 15,899 10,218 83% 244 Emergency Phone System 20 - 19 215,000 1 97% 249 Public Safety LOIT 6,472,240 539,392 3,776,166 3,193,760 2,696,074 58% 251 Local Roads & Streets 1,821,300 97,383 683,063 675,981 1,138,237 38% 252 Excess Welfare Distribution - - 0 2 (0) 0% 258 Human Rights Federal Grant 209,950 41,861 67,624 13,850 142,326 32% 271 Eastrace Waterway 50 2 18 27 32 36% 273 Morris PAC / Palais Royale Marketing 18,000 3,164 6,868 6,968 11,132 38% 280 Police Block Grants - 3 16 8 (16) 0% 281 Economic Develop. Commission- Revenue Bonds 300 18 111 55 189 37% 289 HAZMAT 14,100 21 13,921 24,086 179 99% 291 Indiana River Rescue 45,350 8,455 30,983 38,783 14,367 68% 292 Police Grants 90,000 - 56,946 66,716 33,054 63% 294 Regional Police Academy 22,700 43 20,765 18,061 1,936 91% 295 COPS MORE Grant 150,258 807 37,916 6,575 112,342 25% 299 Police Federal Drug Enforcement 77,000 95 64,352 26,656 12,648 84% 404 County Option Income Tax 9,883,971 793,197 5,685,765 4,656,763 4,198,206 58% 408 Economic Development Income Tax 9,526,637 755,698 5,785,582 4,785,807 3,741,055 61% 410 Urban Development Action Grant 528,686 10,083 252,174 56 276,512 48% 655 Project Releaf 431,700 37,365 259,676 256,317 172,024 60% 705 Police K -9 Unit 2,000 3 1,513 1,004 487 76% Special Revenue Total 65,248,222 3,693,387 31,858,878 29,429,581 33,389,344 49% City Debt Service 313 Football Hall of Fame Debt Service 1,274,106 4,256 568,021 344,445 706,085 45% City Debt Service Total 1,274,106 4,256 568,021 344,445 706,085 45% Capital Project 377 Professional Sports Development 809,511 129,447 538,050 409,872 271,461 66% 401 Coveleski Stadium Capital 15,100 27 165 55 14,935 1% 403 Zoo Endowment 200 33 200 100 (0) 100% 405 Park Nonreverting Capital 143,700 918 9,796 19,584 133,904 7% 406 Cumulative Capital Development 542,691 4,642 288,449 283,636 254,242 53% 407 Cumulative Capital Improvement 422,350 150,118 268,188 273,647 154,162 63% 412 Major Moves Construction 811,187 2,079 382,212 242,128 428,975 47% 416 Morris Performing Arts Center Capital 101,500 349 35,195 51,040 66,305 35% 434 Community Revitalization Enhancement District 150 31 199 179 (49) 133% 450 Palais Royale Historic Preservation 16,150 1,602 7,048 3,870 9,102 44% 677 Football Hall of Fame Capital 2,500 358 2,218 1,308 282 89% Capital Project Total 2,865,039 289,604 1,531,720 1,285,418 1,333,319 53% Enterprise 287 Emergency Medical Services Capital 1,150,350 242 397,684 - 752,666 35% 288 Emergency Medical Services Operating 5,679,065 386,909 2,812,016 1,649,899 2,867,049 50% 600 Consolidated Building Fund 4,209,213 1,533,994 3,158,355 1,923,724 1,050,858 75% 601 Parking Garages 1,045,125 83,119 583,896 634,335 461,229 56% 610 Solid Waste Operations 5,712,289 492,885 3,130,475 3,102,707 2,581,814 55% 611 Solid Waste Capital 753,011 189,015 519,067 615,052 233,944 69% 620 Water Works Operations 14,780,483 1,176,602 7,922,574 8,106,663 6,857,909 54% 622 Water Works Capital 10,000 2,006 12,473 7,163 (2,473) 125% 623 Water Works Bond Capital 545 - 544 1,343 1 100% 624 Water Works Customer Deposit 6,000 1,001 6,057 3,000 (57) 101% City of South Bend Monthly Department Financial Report REVENUE SUMMARY July 31, 2015 625 Water Works Sinking 2,050,078 171,165 1,194,735 1,196,712 855,343 58% 626 Water Works Bond Reserve 9,500 1,078 3,429 63,110 6,071 36% 629 Water Works Reserve Operations & Maintenance 162,749 1,499 159,136 57,694 3,613 98% 640 Sewer Repair Insurance 554,800 51,350 360,773 341,134 194,027 65% 641 Sewage Works Operations 35,338,567 3,160,870 20,480,761 19,431,109 14,857,806 58% 642 Sewage Works Capital 5,398,000 4,451 4,019,764 4,010,566 1,378,236 74% 643 Sewage Works Reserve Operations & Maint. 271,612 2,466 270,710 136,855 902 100% 647 Sewer Bond 2007 - - - 3 - 0% 649 Sewage Sinking 9,288,088 776,236 5,426,480 5,429,359 3,861,608 58% 658 Sewer Bond 2010 - - 1 5 (1) 0% 659 Sewer Bond 2011 6,000 347 3,724 14,551 2,276 62% 661 Sewer Bond 2012 40,000 10,588 66,654 36,456 (26,654) 167% 664 2013A Cost of Issuance Fund 50 3 18 9 32 37% 670 Century Center 3,819,251 761,283 2,430,867 2,876,350 1,388,384 64% 671 Century Center Capital 500 95 366 174 134 73% 672 Century Center Energy Conservation Debt Svc 50,000 4 50,011 - (11) 100% Enterprise Total 90,335,276 8,807,210 53,010,571 49,637,973 37,324,705 59% Internal Service 155,455 35201 1405436 1,021,030 155019 90% 222 Central Services 8,151,184 570,801 4,451,637 4,344,238 3,699,547 55% 224 Central Services Capital 271,850 - - - 271,850 0% 226 Liability Insurance 1,262,602 102,631 734,625 1,723,084 527,977 58% 278 Take Home Vehicle Police 124,200 13,925 76,164 71,481 48,036 61% 711 Self- Funded Employee Benefits 16,357,770 1,197,000 8,501,658 7,622,832 7,856,112 52% 713 Unemployment Compensation 113,796 8,634 60,296 60,220 53,500 53% Internal Service Total 26,281,402 1,892,992 13,824,380 13,821,856 12,4579022 53% Trust & Agency 159,482,137 145,854,527 104,277,787 56% 701 Firefighters Pension 5,044,525 1,415 2,524,043 2,565,260 2,520,482 50% 702 Police Pension 6,385,359 62 3,189,287 3,057,565 3,196,072 50% 730 City Cemetery 150 19 116 75 34 77% Trust & Agency Total 119430,034 15496 5,713,446 596223900 597163588 50% City Funds Total 250,256,557 15,913,716 136,244,599 129,718,626 92,389,448 54% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 24,944,246 29,064 16,525,611 7,676,761 8,418,635 66% 420 Tax Incremental Financing (TIF) - Downtown - - - 2,910,786 - 0% 422 TIF - West Washington 422,800 849 200,671 305,381 222,129 47% 425 Redevelopment Retail & Leighton Plaza 189,423 13,155 100,599 92,246 88,824 53% 426 TIF - Central Medical Service Area - - - 465,276 - 0% 429 River East Development Area (NE Dev TIF) 3,829,653 4,408 2,864,372 814,269 965,281 75% 430 TIF - Southside Development #1 2,410,750 3,377 1,317,680 1,275,619 1,093,070 55% 435 TIF - Douglas Road 320,750 346 164,623 161,473 156,127 51% 436 River East Residential (NE Res TIF) 2,815,000 210,999 1,876,142 1,384,906 938,858 67% Tax Increment Financing Total 34,932,622 262,198 23,049,698 15,086,717 11,882,924 66% Redevelopment 433 Redevelopment General 252 7 41 37 211 16% 439 Certified Technology Park 33,904 2,940 19,561 7,476 14,343 58% 454 Airport Urban Enterprise Zone 1,500 254 1,537 764 (37) 102% 619 Blackthorn Operations 119,799 - 119,297 1,012,753 502 100% Redevelopment Total 155,455 35201 1405436 1,021,030 155019 90% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 697 4,225 2,107 775 85% 317 Coveleski Debt Service Reserve 1,800 339 2,057 1,022 (257) 114% 328 Redevelopment Bond - Palais Royale 6,000 1,164 7,059 3,521 (1,059) 118% 432 TIF - Southside Development #3 25,000 3,622 34,063 21,503 (9,063) 136% Debt Service Total 37,800 5,822 47,404 28,154 (9,604) 125% Redevelopment Commission Controlled Funds Total 35,125,877,,M 271,221 23,237,538 16,135,901 11,888,339 i 66% Grand Total 285,382,434 16,184,937 159,482,137 145,854,527 104,277,787 56% t1 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY July 31, 2015 City Funds General Fund 101 -0101 Mayor's Office 741,267 79,991 427,441 387,818 408 313,418 58% 101 - 0104311 Call Center 486,733 48,025 288,025 247,467 1,686 197,022 60% 101 -0201 City Clerk 431,573 37,398 208,728 189,256 15,334 207,511 52% 101 -0301 Common Council 490,150 26,243 299,125 191,535 43,180 147,845 70% 101 -0302 WNIT Contract 43,000 - 43,000 - - - 100% 101 -0401 Administration & Finance 2,008,924 198,795 1,087,458 1,159,361 15,899 905,567 55% 101 -0404 Moms Performing Arts Center 1,093,132 94,489 591,840 556,131 48,916 452,377 59% 101 -0405 Palais Royale 536,293 45,965 262,742 240,438 43,518 230,032 57% 101 -0501 Legal Department 1,018,599 95,236 547,423 562,002 11,573 459,604 55% 101 -0602 Engineering 1,058,933 137,148 579,548 586,686 75,410 403,975 62% 101 -0801 Police Department 25,633,064 2,485,297 14,610,545 13,207,946 129,085 10,893,435 58% 101 -0802 Communications Center 1,687,540 8 906,946 1,128,801 771,780 8,814 99% 101 -0901 Fire Department 17,774,474 1,998,183 11,360,163 12,111,198 212,804 6,201,507 65% 101 -0905 Fire LOIT 2013 - 11,354 11,354 - - (11,354) 0% 101 -1008 Human Rights 373,179 37,717 220,931 187,604 6,155 146,093 61% 101 -1201 Code 2013 2,270 710 - 851 2,269 1 100% 101 -0805 Police LOIT 2013 - (212) (212) - - 212 0% 101 -1205 Unsafe Building 2013 - - - 750 - - 0% 101 -1207 Animal Control 2013 - - - 300 - - 0% General Fund Total 53,379,131 5,296,345 31,445,056 30,758,143 1,378,016 20,556,060 61% Special Revenue 201 Parks & Recreation 11,063,995 1,134,206 6,711,961 6,967,702 258,815 4,093,219 63% 202 Motor Vehicle Highway 10,485,386 736,486 4,761,742 4,599,752 656,059 5,067,585 52% 203 Recreation Nonreverting 1,549,469 117,396 573,063 510,126 91,117 885,289 43% 209 Studebaker - Oliver Reverting Grants 630,000 - 58,751 - 508,669 62,580 90% 210 Economic Development State Grants 3,694,412 11,175 460,670 36,005 791,339 2,442,403 34% 211 Department of Community Investment (DCI) 2,661,730 262,010 1,442,069 1,271,979 45,449 1,174,212 56% 212 Dept of Community Investment Grants 6,547,968 220,716 1,576,548 2,205,311 2,767,996 2,203,424 66% 216 Police State Seizures 35,900 - - - - 35,900 0% 217 Gift, Donation, Bequest 297,182 - 81,093 13,736 1,552 214,537 28% 218 Police Curfew Violations 1,000 - - - - 1,000 0% 220 Law Enforcement Continuing Education 362,478 41,269 212,698 103,622 42,076 107,704 70% 227 Loss Recovery 5,237,243 72,730 2,411,584 578,765 1,584,474 1,241,185 76% 244 Emergency Phone System - - - 120,818 - - 0% 249 Public Safety LOIT 7,246,551 718,301 4,096,257 4,197,184 - 3,150,294 57% 251 Local Roads & Streets 2,126,221 97,882 347,498 294,142 1,149,428 629,295 70% 258 Human Rights Federal Grant 247,357 20,854 132,038 98,857 11,056 104,262 58% 271 Eastrace Waterway 4,000 - 2,098 9,092 1,900 2 100% 273 Morris PAC / Palais Royale Marketing 18,974 - 3,332 8,314 5,089 10,553 44% 289 HAZMAT 31,530 - 21,542 - - 9,988 68% 291 Indiana River Rescue 120,800 2,412 52,283 24,271 - 68,517 43% 292 Police Grants 105,145 - 15,297 138,059 - 89,848 15% 294 Regional Police Academy 23,750 284 25,755 11,834 - (2,005) 108% 295 COPS MORE Grant 172,335 387 30,290 9,802 10,245 131,800 24% 299 Police Federal Drug Enforcement 248,960 9,704 122,898 49,033 46,229 79,833 68% 404 County Option Income Tax 15,660,371 833,731 5,878,658 5,477,058 1,471,229 8,310,484 47% 408 Economic Development Income Tax 9,943,709 2,289,212 6,065,908 6,086,735 214,438 3,663,363 63% 410 Urban Development Action Grant 438,203 - 146,068 - - 292,135 33% 655 Project Releaf 528,358 14,293 66,668 66,433 - 461,690 13% 705 Police K -9 Unit 2,000 - 970 - - 1,030 49% Special Revenue Total 79,485,027 6,583,049 35,297,738 32,878,629 9,657,161 34,530,128 57% City Debt Service 313 Football Hall of Fame Debt Service 1,266,820 636,000 1,272,000 1,270,500 - (5,180) 100% City Debt Service Total 1,266,820 636,000 1,272,000 1,270,500 - (5,180) 100% Capital Project 377 Professional Sports Development 855,603 374,030 855,603 865,545 - - 100% 403 Zoo Endowment 49,000 - - - - 49,000 0% 405 Park Nonreverting Capital 192,933 25,023 57,958 157,463 14,829 120,146 38% 406 Cumulative Capital Development 542,691 112,650 474,118 474,118 - 68,573 87% 407 Cumulative Capital Improvement 365,625 184,125 367,875 369,000 - (2,250) 101% 412 Major Moves Construction 3,096,061 364,718 1,446,751 912,592 1,260,721 388,589 87% 416 Morris Performing Arts Center Capital 70,248 13,568 41,266 7,791 10,569 18,413 74% 434 Community Revitalization Enhancement District 650,000 3,897 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 3,444 32,805 48,453 - 156,019 17% Capital Project Total 6,027,135 1,081,456 3,284,170 2,855,936 1,286,119 1,456,846 76% 4 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY July 31, 2015 City Funds Enterprise 6,000 - - 15,703 - 6,000 0% 287 Emergency Medical Services Capital 750,000 - 35,728 - 425,136 289,136 61 288 Emergency Medical Services Operating 6,855,366 721,466 2,379,492 2,820,521 178,152 4,297,722 37% 600 Consolidated Building Fund 4,205,401 366,042 1,890,015 1,765,361 627,177 1,688,209 60% 601 Parking Garages 1,806,712 88,181 611,243 480,788 94,580 1,100,889 39% 610 Solid Waste Operations 5,873,863 641,738 3,284,213 3,489,299 146,262 2,443,388 58% 611 Solid Waste Capital 752,811 189,188 553,690 733,188 - 199,121 74% 620 Water Works Operations 15,844,471 1,262,393 8,342,665 8,355,066 488,850 7,012,956 56% 622 Water Works Capital 838,893 25,331 221,445 14,903 8,075 609,373 27% 623 Water Works Bond Capital 53,330 7,519 183,082 524,001 - (129,752) 343% 624 Water Works Customer Deposit 6,000 1,001 5,202 2,960 - 798 87% 625 Water Works Sinking 2,050,078 999 368,390 385,262 - 1,681,688 18% 626 Water Works Bond Reserve 14,500 - 7,374 - - 7,126 51% 629 Water Works Reserve Operations & Maintenance 8,500 1,499 7,705 4,187 - 795 91 640 Sewer Repair Insurance 545,703 20,211 274,435 251,167 104,565 166,703 69% 641 Sewage Works Operations 40,196,974 2,527,829 20,530,480 20,212,473 1,142,608 18,523,885 54% 642 Sewage Works Capital 7,071,710 217,648 1,578,401 2,795,399 2,174,874 3,318,435 53% 643 Sewage Works Reserve Operations & Maint. 15,000 2,466 12,649 6,891 - 2,351 84% 647 Sewer Bond 2007 - 0 0 1,143 - (0) 0% 649 Sewage Sinking 9,282,109 350 1,592,311 1,674,702 - 7,689,798 17% 658 Sewer Bond 2010 - 2 2 924 - (2) 0% 659 Sewer Bond 2011 3,711,838 - 1,085,357 2,917,396 452,777 2,173,704 41 661 Sewer Bond 2012 16,624,275 201,706 1,353,542 513,294 2,407,582 12,863,151 23% 670 Century Center 4,532,562 401,596 2,312,117 2,572,675 - 2,220,445 51% 671 Century Center Capital 605,656 87,735 334,331 - - 271,325 55% Enterprise Total 121,645,752 6,764,899 46,963,869 49,521,602 8,250,639 66,431,244 45% Internal Service 222 Central Services 8,300,242 601,324 4,405,221 4,188,530 1,188,060 2,706,961 67% 224 Central Services Capital 271,850 - - - 28,196 243,654 10% 226 Liability Insurance 3,056,791 317,120 2,024,158 1,740,807 40,569 992,064 68% 278 Take Home Vehicle Police 71,100 1,086 1,086 - - 70,014 2% 711 Self- Funded Employee Benefits 16,696,935 1,255,361 7,920,873 8,689,276 193,665 8,582,397 49% 713 Unemployment Compensation 226,796 8,171 56,270 90,506 11,000 159,526 30% Internal Service Total 28,623,714 2,183,061 14,407,609 14,709,118 1,461,489 12,754,616 55% Trust & Agency 701 Firefighters Pension 5,666,579 427,928 3,059,969 3,176,540 - 2,606,610 54% 702 Police Pension 6,832,235 518,215 3,722,881 4,026,322 - 3,109,354 54% 730 City Cemetery 20,000 - - - - 20,000 0% Trust & Agency Total 12,518,814 946,143 6,782,850 7,202,862 - 5,735,964 54% City Funds Total 302,946,393 23,490,954 139,453,291 139,196,791 22,033 Redevelopment Commission Controlled Funds - Tax Increment Financing 324 River West Development Area (Airport TIF) 47,710,597 3,609,185 11,193,443 4,550,399 13,757,657 22,759,497 52% 420 Tax Incremental Financing (TIF) - Downtown 4,088,473 - 4,088,473 3,071,153 - - 100% 422 TIF - West Washington 760,900 - 30,294 319 3,366 727,240 4% 425 Redevelopment Retail & Leighton Plaza 154,716 4,246 74,668 79,118 - 80,048 48% 426 TIF - Central Medical Service Area 2,294,533 - 2,294,533 1,729,515 - - 100% 429 River East Development Area (NE Dev TIF) 7,239,524 3,438 148,985 1,475 288,603 6,801,936 6% 430 TIF - Southside Development #1 2,842,535 8,551 617,117 352,055 652,308 1,573,110 45% 435 TIF - Douglas Road 345,389 - 169,620 95,391 4,200 171,569 50% 436 River East Residential (NE Res TIF) 3,425,632 1,467,450 3,179,039 3,330,291 - 246,593 93% Tax Increment Financing Total 68,862,299 5,092,870 21,796,172 13,209,716 14,706,134 32,359,993 53% Redevelopment 433 Redevelopment General 6,000 - - 15,703 - 6,000 0% 439 Certified Technology Park 5,000,000 492,595 1,287,418 - 2,232,365 1,480,217 70% 619 Blackthorn Operations 201,649 - 201,228 879,931 - 421 100% Redevelopment Total 5,207,649 492,595 1,488,646 895,634 2,232,365 1,486,638 71% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 697 3,626 2,107 - 1,374 73% 328 Redevelopment Bond - Palais Royale 6,000 1,164 6,058 3,521 - (58) 101% 432 TIF- Southside Development #3 691,380 130,835 690,104 492,151 - 1,276 100% Debt Service Total 702,380 132,696 699,788 497,779 - 2,592 100% Redevelopment Commis 74,772,328 5,718,161 23,984,606 14,603,129 N 16,938,499 33,849,223 551 Grand Total 377,718,721 29,209,115 163,437,897 153,799,920 38,971,923 175,308,901 54% u� Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office JMonth I July Fund /Department Number 101 -0101 1 Date Updated 8/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 /Non -Dept Revenue 740,567 79,991 427,321 387,737 - 313,246 58% 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 79,991 427,441 387,818 - 313,826 58% Expenditures Personnel 669,877 72,047 394,706 341,533 - 275,171 59% Supplies 12,413 801 6,589 12,512 394 5,430 56% Services 56,739 7,143 24,745 32,379 14 31,980 44% Debt Service 2,238 - 1,401 1,394 - 837 63% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 741,267 79,991 427,441 387,818 408 313,418 58% Net - - - - (408) 408 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 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Expenditures are in line with budgeted expectations for 2015. Personnel Services category higher due to three pay periods occurring this month. Explain Significant Spending on Capital Projects Below: There are no capital projects budgeted for 2015. Form 3 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center jMonth I July Fund /Department Number 101 -0104 1 Date Updated 8/12/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 - - - (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 48,025 288,025 273,976 - 198,708 59% Transfers In - - - - - - 0% Total Revenue 486,733 48,025 288,025 247,467 - 198,708 59% Expenditures Personnel 441,562 46,724 260,304 222,220 - 181,258 59% Supplies 6,125 - 1,537 12,461 - 4,588 25% Services 39,046 1,302 26,184 12,786 1,686 11,176 71% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 486,733 48,025 288,025 247,467 1,686 197,022 60% Net - - - - (1,686) 1,686 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: Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted in 2015. Form 3 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name I City Clerk jMonth I July Fund /Department Number 101 -0201 1 Date Updated 8/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 /Non -Dept Revenue 431,573 37,398 208,728 189,256 - 222,845 48% 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 37,398 208,728 189,256 - 222,845 48% Expenditures Personnel 339,442 33,553 185,705 162,012 - 153,737 55% Supplies 7,740 301 1,172 5,437 1,000 5,568 28% Services 70,991 3,544 21,851 21,807 14,334 34,806 51% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 431,573 37,398 208,728 189,256 15,334 207,511 52% Net - - - - (15,334) 15,334 Cash Balance - - Staffing Full Time 5.00 5.00 5.00 Part -Time /Seasonal /Temporary - - - Total 5.00 5.00 5.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Expenditures are consistent with normal operating costs. Explain Significant Spending on Capital Projects Below: This year, a copier has been budgeted for capital expenditures. Form 3 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name Common Council jMonth I July Fund /Department Number 101 -0301 1 Date Updated 8/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 /Non -Dept Revenue 481,484 26,197 298,700 190,979 - 182,784 62% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 8,466 46 225 556 - 8,241 3% Other Income 200 - 200 - - - 100% Transfers In - - - - - - 0% Total Revenue 490,150 26,243 299,125 191,535 - 191,025 61% Expenditures Personnel 243,742 24,135 127,531 115,267 8,634 107,577 56% Supplies 4,706 684 1,503 282 163 3,040 35% Services 241,702 1,424 170,091 75,986 34,383 37,228 85% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 490,150 26,243 299,125 191,535 43,180 147,845 70% Net - - - - (43,180) 43,180 Cash Balance - - Staffing Full Time 9.00 9.00 9.00 Part -Time /Seasonal /Temporary - - - Total 9.00 9.00 9.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 Form 3 10 2015 City of South Bend Monthly Financial Report Fund /Department Name WNIT Contract jMonth I July Fund /Department Number 101 -0302 Date Updated 8/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 /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% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance jMonth I July Fund /Department Number 101 -0401 1 Date Updated 8/13/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 2,008,324 198,795 1,086,902 1,159,361 - 921,422 54% 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 - - 44 93% Transfers In - - - - - - 0% Total Revenue 2,008,924 198,795 1,087,458 1,159,361 - 921,466 54% Expenditures Personnel 1,796,651 172,117 985,086 968,366 - 811,565 55% Supplies 38,109 3,227 20,444 19,407 1,598 16,066 58% Services 171,593 22,808 79,999 169,660 14,301 77,292 55% Debt Service 2,571 643 1,928 1,928 - 643 75% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,008,924 198,795 1,087,458 1,159,361 15,899 905,567 55% Net - - - - (15,899) 15,899 Cash Balance - - Staffing Full Time 22.00 22.00 Part -Time /Seasonal /Temporary - 5.50 Total 22.00 27.50 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Part Time includes 5 summer interns through the Jobs for American Graduates (JAG) program. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 WA 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center JMonth I July Fund /Department Number 101 -0404 1 Date Updated 8/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 /Non -Dept Revenue 170,132 90,962 190,613 (93,670) - (20,481) 112% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 917,000 3,274 397,590 644,802 - 519,410 43% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 254 3,637 4,999 - 2,363 61% Transfers In - - - - - - 0% Total Revenue 1,093,132 94,489 591,840 556,131 - 501,292 54% Expenditures Personnel 749,285 76,301 429,740 385,636 - 319,545 57% Supplies 33,542 826 11,726 10,739 7,229 14,586 57% Services 310,305 17,363 150,373 159,756 41,686 118,245 62% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,093,132 94,489 591,840 556,131 48,916 452,377 59% Net - - - - (48,916) 48,916 Cash Balance - - Staffing Full Time 12.00 12.00 Part -Time /Seasonal /Temporary 4.00 4.00 Total 16.00 16.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Royal Box Leasing revenue is expected to be received in the month of December and not in March as in previous years. Explain Significant Spending on Capital Projects Below: 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 WA Form 3 13 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale JMonth I July Fund /Department Number 101 -0405 1 Date Updated 8/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 /Non -Dept Revenue 201,023 11,545 100,216 116,224 - 57,289 50% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 316,270 31,992 152,754 117,021 - 163,516 48% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,000 2,427 9,773 7,193 - 9,227 51% Transfers In - - - - - - 0% Total Revenue 536,293 45,965 262,742 240,438 - 230,032 49% Expenditures Personnel 263,505 26,377 146,217 132,046 - 117,288 55% Supplies 23,897 381 4,449 3,887 3,258 16,190 32% Services 234,891 8,694 101,002 104,506 39,260 94,629 60% Debt Service - - - - - - 0% Capital 14,000 10,513 11,075 - 1,000 1,925 86% Transfers Out - - - - - - 0% Total Expenditures 536,293 45,965 262,742 240,438 43,518 230,032 57% Net - - - - (43,518) - 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: Explain Significant Spending on Capital Projects Below: AN Upgrades (screen, projector, computer). Curtain replacement project ($30,000.00) defer to 2016. Form 3 13 Form 3 14 2015 City of South Bend Monthly Financial Report Fund /Department Name Legal Department jMonth I July Fund /Department Number 101 -0501 1 Date Updated 8/13/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 95,236 528,797 560,379 - 436,302 55% 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 95,236 547,423 562,002 - 471,176 54% Expenditures Personnel 948,013 88,829 516,763 535,704 - 431,250 55% Supplies 6,832 154 3,758 2,043 10 3,064 55% Services 62,454 6,254 26,266 23,619 10,926 25,262 60% Debt Service 1,300 - 635 635 637 28 98% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,018,599 95,236 547,423 562,002 11,573 459,604 55% Net - - - - (11,573) 11,573 Cash Balance - - Staffing Full Time 11.60 11.60 Part -Time /Seasonal /Temporary - - Total 11.60 11.60 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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 June 2015. The encumbrances relate to subscriptions paid monthly, debt sevices paid quarterly, and office supplies. Spending appears to be on track with budgeted figures. Explain Significant Spending on Capital Projects Below: Form 3 14 Form 3 W 2015 City of South Bend Monthly Financial Report Fund /Department Name Engineering jMonth I July Fund /Department Number 101 -0602 1 Date Updated 8/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 /Non -Dept Revenue 981,906 136,873 577,007 567,315 - 404,900 59% 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 275 2,542 19,371 - 74,485 3% Transfers In - - - - - - 0% Total Revenue 1,058,933 137,148 579,548 586,686 - 479,385 55% Expenditures Personnel 710,552 85,661 387,539 336,201 - 323,013 55% Supplies 29,262 953 19,353 12,835 1,193 8,717 70% Services 306,044 47,980 164,209 231,246 72,921 68,914 77% Debt Service 13,075 2,554 8,449 6,405 1,296 3,330 75% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,058,933 137,148 579,548 586,686 75,410 403,975 62% Net - - - - (75,410) 75,410 Cash Balance - - Staffing Full Time 7.90 7.80 Part -Time /Seasonal /Temporary 1.22 4.90 Total 9.12 12.70 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: $72,921 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. Part -time includes .9 FTE's + 4 Interns. Explain Significant Spending on Capital Projects Below: Form 3 W Form 3 iV, 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Department jMonth I July Fund /Department Number 101 -0801 1 Date Updated 8/13/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 2,468,287 14,502,223 13,042,085 - 10,575,641 58% 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 17,010 107,562 141,345 - 240,138 31% Transfers In - - - - - - 0% Total Revenue 25,633,064 2,485,297 14,610,545 13,207,946 - 11,022,519 57% Expenditures Personnel 22,809,224 2,315,225 13,030,219 11,114,961 - 9,779,005 57% Supplies 499,279 37,883 261,865 425,004 69,937 167,478 66% Services 2,316,561 131,531 1,314,535 1,600,430 59,148 942,878 59% Debt Service 8,000 659 3,906 2,393 - 4,094 49% Capital - - 20 65,158 - (20) 0% Transfers Out - - - - - - 0% Total Expenditures 25,633,064 2,485,297 14,610,545 13,207,946 129,085 10,893,435 58% Net - - - - (129,085) 129,085 Cash Balance - - Staffing Full Time 263.00 251.00 251.00 Part -Time /Seasonal /Temporary 60.00 13.00 13.00 Total 323.00 264.00 264.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 66% and 59% of the Budget as used year to date. This is due to the 2014 encumbrances reflected as a use. These categories are expected to be on budget for the year. Explain Significant Spending on Capital Projects Below: Form 3 iV, 2015 City of South Bend Monthly Financial Report Fund /Department Name Communications Center jMonth I July Fund /Department Number 101 -0802 1 Date Updated 8/13/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 1,687,540 8 906,946 1,128,801 - 780,594 54% 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 8 906,946 1,128,801 - 780,594 54% Expenditures Personnel 143,972 8 135,166 1,121,339 - 8,806 94% Supplies - - - 1,362 - - 0% Services 1,543,568 - 771,780 6,100 771,780 8 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,687,540 8 906,946 1,128,801 771,780 8,814 99% Net - - - - (771,780) 771,780 Cash Balance - - Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 JMonth I July Fund /Department Number 101 -0901 1 Date Updated 8/13/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 17,636,174 1,994,030 11,225,045 11,797,285 6,411,129 64% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 131,000 4,152 135,118 313,913 - (4,118) 103% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 7,300 - - 7,300 0% Transfers In - - - - - 0% Total Revenue 17,774,474 1,998,183 11,360,163 12,111,198 - 6,414,311 64% Expenditures Personnel 15,737,086 1,864,541 10,497,342 10,936,872 127,173 5,112,571 68% Supplies 320,618 12,796 82,585 204,523 24,854 213,179 34% Services 1,216,770 120,846 780,236 969,804 60,777 375,757 69% Debt Service - - - - - 0% Capital - - - - - - 0% Transfers Out 500,000 - - - - 500,000 0% Total Expenditures 17,774,474 1,998,183 11,360,163 12,111,198 212,804 6,201,507 1 65% Net - - - - (212,804) 212,804 Cash Balance - - Staffing Full Time 170.00 170.00 170.00 Part -Time /Seasonal /Temporary - - - Total 170.00 170.00 170.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 employees' and 4 civilian employees' 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. Explain Significant Spending on Capital Projects Below: 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, no expenses related to purchasing fire apparatus, or capital improvements to buildings appear in the General Fund. Form 3 18 Form 3 19 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights jMonth I July Fund /Department Number 101 -1008 1 Date Updated 8/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 /Non -Dept Revenue 373,179 37,717 220,931 187,604 - 152,248 59% 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 37,717 220,931 187,604 - 152,248 59% Expenditures Personnel 286,475 31,743 173,867 152,893 - 112,608 61% Supplies 2,010 39 677 894 400 933 54% Services 73,492 5,935 35,980 33,818 5,755 31,757 57% Debt Service - - - - - - 0% Capital 11,202 - 10,407 - - 795 93% Transfers Out - - - - - - 0% Total Expenditures 373,179 37,717 220,931 187,604 6,155 146,093 61% Net - - - - (6,155) 6,155 Cash Balance - - Staffing Full Time 4.00 4.00 4.00 Part -Time /Seasonal /Temporary - - - Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Expenditures are consistent with normal operating costs. This month, there were three pay periods. Explain Significant Spending on Capital Projects Below: Human Rights had money encumbered from last year for a copier. Purchase was made in January. Form 3 19 2015 City of South Bend Monthly Financial Report Fund /Department Name I Rainy Day jMonth I July Fund /Department Number 102 1 Date Updated 8/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 34,680 5,809 35,199 17,494 - (519) 101% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 34,680 5,809 35,199 17,494 - (519) 101% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 34,680 5,809 35,199 17,494 - (519) Cash Balance 8,677,388 8,635,198 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 2015 City of South Bend Monthly Financial Report Fund /Department Name I Excess Levy jMonth I July Fund /Department Number 103 Date Updated 8/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 20 2 12 - - 8 58% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 20 2 12 - - 8 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 20 2 12 - - 8 Cash Balance 3,659 - 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. 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 jMonth I July Fund /Department Number 201 1 Date Updated 8/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 7,340,000 - 4,145,751 4,021,603 - 3,194,249 56% Local Income Taxes - - 0% Other Taxes 1,510,875 73,736 843,501 749,920 - 667,374 56% Grants /Intergovernmental - - - - - - 0% Charges for Services 2,025,640 337,361 1,089,787 1,194,348 - 935,853 54% Interest Earnings 10,000 1,755 7,310 4,808 - 2,690 73% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 144,200 19,079 93,190 86,861 - 51,010 65% Transfers In - - - 0% Total Revenue 11,030,715 431,931 6,179,539 6,057,540 - 4,851,176 56% Expenditures Personnel 7,105,699 926,664 4,057,577 3,940,724 2,989 3,045,133 57% Supplies 1,109,836 70,658 620,216 758,833 194,377 295,243 73% Services 2,443,703 136,884 1,885,579 2,096,349 61,449 496,676 80% Debt Service 309,257 - 148,590 166,796 - 160,667 48% Capital 95,500 - - 5,000 - 95,500 0% Transfers Out - - 0% Total Expenditures 11,063,995 1,134,206 6,711,961 6,967,702 258,815 4,093,219 63% Net (33,280) (702,275) (532,422) (910,162) (258,815) 757,957 Cash Balance 2,978,290 3,355,576 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 was received in the third quarter of 2015. Form 3 22 Form 3 23 2015 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway jMonth I July Fund /Department Number 202 1 Date Updated 8/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 5,697,000 286,014 3,201,425 3,261,792 2,495,575 56% Grants /Intergovernmental - - 0% Charges for Services 265,000 38,480 214,521 215,771 50,479 81% Interest Earnings 9,500 3,255 17,245 6,526 (7,745) 182% Bond Proceeds - - 0% Donations - - 0% Other Income 27,300 900 24,477 22,634 2,823 90% Transfers In 3,703,000 1,676,500 1,483,291 2,026,500 45% Total Revenue 9,701,800 328,650 5,134,169 4,990,015 - 4,567,631 53% Expenditures Personnel 4,314,548 376,094 2,232,031 2,207,336 2,082,517 52% Supplies 2,631,854 203,617 1,131,341 903,352 477,422 1,023,091 61% Services 2,951,520 121,137 1,134,342 1,181,662 178,637 1,638,541 44% Debt Service 448,006 35,637 224,570 173,372 223,436 50% Capital 139,458 39,458 134,030 100,000 28% Transfers Out - - - - - - 0% Total Expenditures 10,485,386 736,486 4,761,742 4,599,752 656,059 5,067,585 52% Net (783,586) (407,836) 372,427 390,263 (656,059) (499,953) Cash Balance 4,248,391 4,069,991 Staffing Full Time 52.65 50.65 Part -Time /Seasonal /Temporary 4.98 2.24 Total 57.63 52.89 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 Nonreverting jMonth I July Fund /Department Number 203 1 Date Updated 8/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 104,399 571,944 611,055 - 958,991 37% Interest Earnings 3,000 592 3,526 1,699 - (526) 118% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 45,000 (7,843) 34,909 28,927 - 10,091 78% Transfers In - - - - - - 0% Total Revenue 1,578,935 97,148 610,379 641,681 - 968,556 39% Expenditures Personnel 737,842 80,693 305,507 260,231 - 432,335 41% Supplies 289,470 21,195 135,616 95,890 68,114 85,740 70% Services 522,157 15,509 128,389 154,004 23,003 370,764 29% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - 3,550 - - (3,550) 0% Total Expenditures 1,549,469 117,396 573,063 510,126 91,117 885,289 43% Net 29,466 (20,247) 37,316 131,554 (91,117) 83,268 Cash Balance 851,228 909,803 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 Form 3 25 2015 City of South Bend Monthly Financial Report Fund /Department Name Studebaker- Oliver Reverting Grants jMonth I July Fund /Department Number 209 1 Date Updated 8/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 640,000 8,600 78,751 - - 561,249 12% Charges for Services - - - - - - 0% Interest Earnings 4,000 740 4,451 2,199 - (451) 111% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 644,000 9,340 83,202 2,199 - 560,798 13% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 630,000 - 58,751 - 508,669 62,580 90% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 630,000 - 58,751 - 508,669 62,580 90% Net 14,000 9,340 24,451 2,199 (508,669)1 498,218 Cash Balance 1,110,916 1,085,586 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The $640,000 represents a Brownfield Assessment Grant awarded by EPA for use in South Bend , Mishawaka and St. Joseph County. Explain Significant Spending on Capital Projects Below: Consultant work proceeding. Form 3 25 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants JMonth I July Fund /Department Number 210 1 Date Updated 8/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 3,600,000 400,000 400,000 - - 3,200,000 11% Charges for Services - - - - - - 0% Interest Earnings 13,544 - 7,180 7,866 - 6,364 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 400,000 436,939 36,749 - 3,236,571 12% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,622,400 11,175 24,665 - - 1,597,735 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 11,175 460,670 36,005 791,339 2,442,403 34% Net (20,902) 388,825 (23,731) 744 (791,339) 794,168 Cash Balance 305,702 349,694 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 Investme jMonth I July Fund /Department Number 211 1 Date Updated 8/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 416,787 - 1,951 10,680 - 414,836 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 742 4,508 1,920 - (2,008) 180% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 247,500 8,590 165,859 220,171 - 81,641 67% Transfers In 1,967,638 - 983,819 844,480 - 983,819 50% Total Revenue 2,634,425 9,332 1,156,137 1,077,251 - 1,478,288 44% Expenditures Personnel 2,120,943 216,833 1,164,697 1,107,969 9,161 947,085 55% Supplies 35,753 1,515 20,344 13,446 3,103 12,306 66% Services 505,034 43,662 257,028 150,564 33,185 214,821 57% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,661,730 262,010 1,442,069 1,271,979 45,449 1,174,212 56% Net (27,305) (252,678) (285,932) (194,728) (45,449) 304,076 Cash Balance 788,287 712,586 Staffing Full Time 25.00 25.00 25.00 Part -Time /Seasonal /Temporary - - - Total 25.00 25.00 25.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. Explain Significant Spending on Capital Projects Below: Form 3 27 Form 3 28 2015 City of South Bend Monthly Financial Report Fund /Department Name Dept of Community Investment Gr jMonth I July Fund /Department Number 212 1 Date Updated 8/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 5,525,000 83,359 1,018,857 1,993,483 - 4,506,143 18% Charges for Services - - - - - - 0% Interest Earnings 2,000 181 1,286 1,206 - 714 64% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 363,000 2,109 199,231 287,082 - 163,769 55% Transfers In - - - - - - 0% Total Revenue 5,890,000 85,649 1,219,374 2,281,771 - 4,670,626 21% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 6,547,968 220,716 1,576,548 2,205,311 2,767,996 2,203,424 66% Transfers Out - - - - - - 0% Total Expenditures 6,547,968 220,716 1,576,548 2,205,311 2,767,996 2,203,424 66% Net (657,968) (135,067) (357,174) 76,460 (2,767,996) 2,467,202 Cash Balance 434,075 667,259 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 ongoing and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 28 Form 3 29 2015 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures jMonth I July Fund /Department Number 216 1 Date Updated 8/13/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 35,000 13,504 14,314 23,533 - 20,686 41% Charges for Services - - - - - - 0% Interest Earnings 450 127 762 324 - (312) 169% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - - - - 600 0% Transfers In - - - 0% Total Revenue 36,050 13,631 15,076 23,857 - 20,974 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% Net 150 13,631 15,076 23,857 - (14,926) Cash Balance 202,508 182,523 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 JMonth I July Fund /Department Number 217 1 Date Updated 8/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 800 40 405 174 - 395 51% Bond Proceeds - - - - - - 0% Donations 398,000 330 3,385 171,113 - 394,615 1% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 398,800 370 3,791 171,287 - 395,009 1% Expenditures Personnel - - - - - - 0% Supplies 1,552 - - 13,736 1,552 0 100% Services 295,630 - 81,093 - - 214,537 27% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 297,182 - 81,093 13,736 1,552 214,537 28% Net 101,618 370 (77,303) 157,551 (1,552) 180,473 Cash Balance 60,636 232,285 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. Explain Significant Spending on Capital Projects Below: None Form 3 30 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations jMonth I July Fund /Department Number 218 1 Date Updated 8/13/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 13 50 313 - 950 5% Interest Earnings 25 8 49 24 - (24) 196% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,025 21 99 337 - 926 10% 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 21 99 337 - (74) Cash Balance 12,105 11,884 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 191 Form 3 KYA 2015 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Educ jMonth I July Fund /Department Number 220 1 Date Updated 8/13/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 18,659 125,432 101,964 - 56,568 69% Interest Earnings 3,000 660 3,961 2,011 - (961) 132% Bond Proceeds - - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income 33,000 1,657 13,191 13,052 - 19,809 40% Transfers In - - - - - 0% Total Revenue 270,000 20,976 191,703 127,027 - 78,297 71% Expenditures Personnel - - - - - - 0% Supplies 172,478 24,792 80,113 21,494 42,076 50,289 71% Services 190,000 16,477 132,585 68,181 - 57,415 70% Debt Service - - - - - - 0% Capital - - - 13,947 - - 0% Transfers Out - - - - - - 0% Total Expenditures 362,478 41,269 212,698 103,622 42,076 107,704 70% Net (92,478) (20,293) (20,995) 23,405 (42,076) (29,407) Cash Balance 981,624 1,004,630 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 the timing of training in 2014. This account is expected to be on budget for the year. Explain Significant Spending on Capital Projects Below: Form 3 KYA Form 3 33 2015 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery IMonth I July Fund /Department Number 227 1 Date Updated 8/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 30,000 2,438 19,282 15,899 - 10,718 64% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 30,000 500 30,500 - - (500) 102% Transfers In - - - - - - 0% Total Revenue 60,000 2,938 49,782 15,899 - 10,218 83% Expenditures Personnel - - - - - - 0% Supplies 67,500 - 16,673 - 50,828 - 100% Services 3,280,635 46,730 1,928,980 424,345 110,471 1,241,184 62% Debt Service - - - - - - 0% Capital 1,889,108 26,000 465,932 154,420 1,423,176 1 100% Transfers Out - - - - - 0% Total Expenditures 5,237,243 72,730 2,411,584 578,765 1,584,474 1,241,185 76% Net (5,177,243) (69,792) (2,361,802) (562,866) (1,584,474) (1,230,967) Cash Balance 3,502,091 7,373,167 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Of the $3.28 million budgeted for Services, $110K 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 Lampposts 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. Explain Significant Spending on Capital Projects Below: $1.889 million has been budgeted in 2015 for the Smart Streets initiative. As of July, all Capital encumbrances are for the Lincolnway West Corridors project. Form 3 33 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System jMonth I July Fund /Department Number 244 1 Date Updated 8/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 - - - 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 - - - 120,818 - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 120,818 - - 0% Net 20 - 19 94,182 - 1 Cash Balance 33,671 94,182 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 Form 3 1911 2015 City of South Bend Monthly Financial Report Fund /Department Name Public Safety LOIT jMonth I July Fund /Department Number 249 1 Date Updated 8/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 6,466,190 538,849 3,771,944 3,190,015 - 2,694,246 58% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 543 4,208 3,745 - 1,792 70% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 50 - 13 - - 37 27% Transfers In - - - - - - 0% Total Revenue 6,472,240 539,392 3,776,166 3,193,760 - 2,696,074 58% Expenditures Personnel 7,246,551 718,301 4,096,257 4,197,184 - 3,150,294 57% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 7,246,551 718,301 4,096,257 4,197,184 - 3,150,294 57% Net (774,311) (178,909) (320,092) (1,003,424) - (454,219) Cash Balance 970,332 1,028,770 Staffing Full Time 80.00 Part -Time /Seasonal /Temporary - - Total 80.00 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund will cover the costs of salaries and fringes for 43 police officers and 37 firefighters in 2015. Explain Significant Spending on Capital Projects Below: None. No capital equipment is purchased from this fund. Form 3 1911 Form 3 191t 2015 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets IMonth I July Fund /Department Number 251 1 Date Updated 8/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 1,045,000 95,500 651,867 637,845 - 393,133 62% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,300 1,882 10,822 4,335 - (4,522) 172% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 770,000 - 20,375 33,801 - 749,625 3% Transfers In - - - - - - 0% Total Revenue 1,821,300 97,383 683,063 675,981 - 1,138,237 38% Expenditures Personnel - - - - - - 0% Supplies 380,229 - - 227,360 452,575 (72,346) 119% Services 157,500 - 11,000 - - 146,500 7% Debt Service - - - - - - 0% Capital 1,588,492 97,882 336,498 66,782 696,853 555,141 65% Transfers Out - - - - - - 0% Total Expenditures 2,126,221 97,882 347,498 294,142 1,149,428 629,295 70% Net (304,921) (500) 335,565 381,839 (1,149,428) 508,942 Cash Balance 2,780,012 2,323,213 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 $697K in encumbrance includes $285,000 for Bendix Dr. (Lathrop to Toll Road), $209,000 for Olive St. pavement design, and $205,000 for the Olive - Sample Overpass. Form 3 191t Form 3 37 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution jMonth I July Fund /Department Number 252 1 Date Updated 8/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 2 - (0) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - 0 2 - (0) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - 0 2 - (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 JMonth I July Fund /Department Number 258 Date Updated 8/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 189,000 41,600 48,267 5,000 - 140,733 26% Charges for Services - - - - - - 0% Interest Earnings 2,000 261 1,711 902 - 289 86% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 18,950 - 17,646 7,948 - 1,304 93% Transfers In - - - - - - 0% Total Revenue 209,950 41,861 67,624 13,850 - 142,326 32% Expenditures Personnel 123,657 12,832 70,247 63,370 - 53,410 57% Supplies 2,800 159 743 1,084 1,057 1,000 64% Services 120,900 7,863 61,048 34,403 10,000 49,853 59% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 247,357 20,854 132,038 98,857 11,056 104,262 58% Net (37,407) 21,007 (64,414) (85,007) (11,056) 38,063 Cash Balance 465,838 381,768 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 jMonth I July Fund /Department Number 271 1 Date Updated 8/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 2 18 27 - 32 36% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 50 2 18 27 - 32 36% Expenditures Personnel - - - - - - 0% Supplies 4,000 - 2,098 9,092 1,900 2 100% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,000 - 2,098 9,092 1,900 2 100% Net (3,950) 2 (2,080) (9,064) (1,900) 30 Cash Balance 3,232 5,308 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 Marke jMonth I July Fund /Department Number 273 1 Date Updated 8/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 17,900 3,145 6,758 6,915 - 11,142 38% Interest Earnings 100 19 110 53 - (10) 110% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 18,000 3,164 6,868 6,968 - 11,132 38% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 18,974 - 3,332 8,314 5,089 10,553 44% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 18,974 - 3,332 8,314 5,089 10,553 44% Net (974) 3,164 3,536 (1,346) (5,089)1 579 Cash Balance 30,250 26,640 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 jMonth I July Fund /Department Number 280 1 Date Updated 8/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 - 3 16 8 - (16) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 3 16 8 - (16) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 3 16 8 - (16) Cash Balance 3,844 3,825 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission-Reven jMonth I July Fund /Department Number 281 1 Date Updated 8/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 100 18 111 55 - (11) 111% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 200 - - - - 200 0% Transfers In - - - - - - 0% Total Revenue 300 18 111 55 - 189 37% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 300 18 111 55 - 189 Cash Balance 27,316 27,183 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 Form 3 43 2015 City of South Bend Monthly Financial Report Fund /Department Name I HAZMAT JMonth I July Fund /Department Number 289 1 Date Updated 8/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 14,000 - 13,787 24,055 - 213 98% Interest Earnings 100 21 135 31 - (35) 135% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 14,100 21 13,921 24,086 - 179 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,430) 21 (7,620) 24,086 - (9,810) Cash Balance 32,008 40,295 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: 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 Form 3 44 2015 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue jMonth I July Fund /Department Number 291 1 Date Updated 8/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 - - 975 - - 0% Charges for Services 45,000 8,400 30,600 37,600 - 14,400 68% Interest Earnings 350 55 383 208 - (33) 109% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,350 8,455 30,983 38,783 - 14,367 68% Expenditures Personnel 7,500 346 1,500 - - 6,000 20% Supplies 8,800 13 2,021 419 - 6,779 23% Services 79,500 2,053 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 2,412 52,283 24,271 - 68,517 43% Net (75,450) 6,042 (21,300) 14,513 - (54,150) Cash Balance 84,100 110,231 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 Form 3 45 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Grants jMonth I July Fund /Department Number 292 1 Date Updated 8/13/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 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 - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This Fund was set up to track the revenue and expenditures related to specific federal grants. Expenditures have been outlined in the grant. Explain Significant Spending on Capital Projects Below: Form 3 45 Form 3 46 2015 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy jMonth I July Fund /Department Number 294 Date Updated 8/13/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 43 277 161 - (77) 139% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In - - - - - - 0% Total Revenue 22,700 43 20,765 18,061 - 1,936 91% Expenditures Personnel - - - - - - 0% Supplies 1,750 - 935 - - 815 53% Services 22,000 284 24,820 11,834 - (2,820) 113% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 284 25,755 11,834 - (2,005) 108% Net (1,050) (241) (4,991) 6,227 - 3,941 Cash Balance 63,291 74,311 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 Form 3 47 2015 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant jMonth I July Fund /Department Number 295 1 Date Updated 8/13/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 - - - - 86,658 0% Charges for Services - - - - - - 0% Interest Earnings 350 77 421 229 - (71) 120% Bond Proceeds - - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 38,000 730 16,530 6,346 - 21,470 44% Transfers In 22,000 - 20,965 - - 1,035 95% Total Revenue 150,258 807 37,916 6,575 - 112,342 25% Expenditures Personnel - - - - - - 0% Supplies 45,735 - 27,130 2,523 10,245 8,360 82% Services 66,000 387 3,160 7,279 - 62,840 5% Debt Service - - - - - - 0% Capital 60,600 - - - - 60,600 0% Transfers Out - - - - - - 0% Total Expenditures 172,335 387 30,290 9,802 10,245 131,800 24% Net (22,077) 420 7,626 (3,227) (10,245) (19,458) Cash Balance 113,860 110,116 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 jMonth I July Fund /Department Number 299 1 Date Updated 8/13/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 26,080 - 11,256 85% Charges for Services - - - - - - 0% Interest Earnings 1,000 95 608 576 - 392 61% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,000 - - - - 1,000 0% Transfers In - - - - - - 0% Total Revenue 77,000 95 64,352 26,656 - 12,648 84% Expenditures Personnel - - - - - - 0% Supplies 84,759 9,704 54,575 23,800 11,739 18,445 78% Services 74,201 - 23,102 25,234 - 51,099 31% Debt Service - - - - - - 0% Capital 90,000 - 45,221 - 34,490 10,289 89% Transfers Out - - - - - - 0% Total Expenditures 248,960 9,704 122,898 49,033 46,229 79,833 68% Net (171,960) (9,609) (58,546) (22,377) (46,229) (67,185) Cash Balance 286,996 362,782 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 jMonth I July Fund /Department Number 404 Date Updated 8/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 8,859,912 738,326 5,168,282 4,322,905 - 3,691,630 58% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 58,000 9,807 59,551 29,525 - (1,551) 103% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 966,059 45,064 457,932 304,332 - 508,127 47% Transfers In - - - - - - 0% Total Revenue 9,883,971 793,197 5,685,765 4,656,763 - 4,198,206 58% Expenditures Personnel 427,077 36,832 191,335 - - 235,742 45% Supplies 1,384,804 66,608 499,449 727,379 25,485 859,870 38% Services 8,159,164 370,499 2,855,197 2,263,943 580,849 4,723,118 42% Debt Service 2,487,504 359,555 1,553,889 1,901,139 - 933,615 62% Capital 1,701,822 237 28,788 34,598 864,895 808,140 53% Transfers Out 1,500,000 - 750,000 550,000 - 750,000 50% Total Expenditures 15,660,371 833,731 5,878,658 5,477,058 1,471,229 8,310,484 1 47% Net (5,776,400) (40,534) (192,893) (820,296) (1,471,229) (4,112,278) Cash Balance 14,758,488 14,085,339 Staffing Full Time 4.00 2.00 2.00 Part -Time /Seasonal /Temporary - - - Total 4.00 2.00 2.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 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 1st Source /Marriott loan based on BDC collections as well as charges to City departments for computer services. Explain Significant Spending on Capital Projects Below: 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 jMonth I July Fund /Department Number 408 1 Date Updated 8/13/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 748,490 5,239,428 4,398,410 - 3,742,449 58% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 - 504,660 354,660 - - 100% Interest Earnings 40,000 7,208 41,412 20,789 - (1,412) 104% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 100 - 82 11,948 - 18 82% Transfers In - - - - - - 0% Total Revenue 9,526,637 755,698 5,785,582 4,785,807 - 3,741,055 61% Expenditures Personnel - - - 221,988 - - 0% Supplies - - - - - - 0% Services 1,799,736 56,107 814,931 858,176 213,638 771,167 57% Debt Service 1,656,191 901,533 1,340,100 1,925,520 - 316,091 81% Capital 4,000 - 3,200 150,000 800 - 100% Transfers Out 6,483,782 1,331,572 3,907,677 2,931,051 - 2,576,105 60% Total Expenditures 9,943,709 2,289,212 6,065,908 6,086,735 214,438 3,663,363 63% Net (417,072) (1,533,514) (280,325) (1,300,928) (214,438) 77,692 Cash Balance 9,889,899 9,541,200 Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Encumbrances include $315k to DTSB for 2014 operations. In 2015, Code Enforcement 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). Explain Significant Spending on Capital Projects Below: $275,000 has been budgeted for the Potawatomi Zoological Society. Form 3 50 Form 3 61 2015 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant jMonth I July Fund /Department Number 410 1 Date Updated 8/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 110 83 325 56 - (215) 295% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 528,576 10,000 251,849 - - 276,727 48% Transfers In - - - - - - 0% Total Revenue 528,686 10,083 252,174 56 - 276,512 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 10,083 106,106 56 - (15,623) Cash Balance 133,772 27,643 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 61 Form 3 M 2015 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf jMonth I July Fund /Department Number 655 1 Date Updated 8/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 429,000 36,605 255,337 254,290 173,663 60% Interest Earnings 2,700 759 4,339 2,027 (1,639) 161% Bond Proceeds - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 37,365 259,676 256,317 - 172,024 60% Expenditures Personnel 64,081 12 1,477 1,481 62,604 2% Supplies 6,000 6,000 0% Services 36,058 2,661 17,463 17,252 18,595 48% Debt Service 72,219 11,619 47,728 47,699 24,491 66% Capital - - 0% Transfers Out 350,000 - 350,000 0% Total Expenditures 528,358 14,293 66,668 66,433 - 461,690 13% Net (96,658) 23,072 193,008 189,884 - (289,666) Cash Balance 1,173,759 1,129,267 Staffing Full Time - - Part -Time /Seasonal /Temporary 2.16 - - Total 2.16 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Fall ReLeaf scheduled for October 2015. Explain Significant Spending on Capital Projects Below: Form 3 M Form 3 53 2015 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit jMonth I July Fund /Department Number 705 1 Date Updated 8/13/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 3 13 4 - (3) 130% Bond Proceeds - - - - - - 0% Donations 1,990 - 1,500 1,000 - 490 75% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 3 1,513 1,004 - 487 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 - 3 543 1,004 - (543) Cash Balance 3,862 2,317 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 Servi jMonth I July Fund /Department Number 313 1 Date Updated 8/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 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 29,795 49,978 - 21,283 58% 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 568,021 344,445 - 706,085 45% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 1,266,820 636,000 1,272,000 1,270,500 - (5,180) 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,266,820 636,000 1,272,000 1,270,500 - (5,180) 100% Net 7,286 (631,744) (703,979) (926,055) - 711,265 Cash Balance (629,856) (209,719) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. PILOT taxes 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. On 15 April 2015 the Mayor announced a possible sale of the Hall of Fame to a private company. If the sale proceeds as planned, this fund will receive $240,000 per year for the next 5 years that will be used to offset debt service costs. 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 IMonth I July Fund /Department Number 377 1 Date Updated 8/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 747,750 102,397 479,907 341,848 - 267,843 64% Charges for Services - - - - - - 0% Interest Earnings 1,100 340 1,910 1,314 - (810) 174% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,661 26,710 56,233 66,710 - 4,428 93% Transfers In - - - - - - 0% Total Revenue 809,511 129,447 538,050 409,872 - 271,461 66% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 855,603 374,030 855,603 865,545 - - 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 855,603 374,030 855,603 865,545 - - 100% Net (46,092) (244,583) (317,553) (455,673) - 271,461 Cash Balance 278,539 386,384 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 611 Form 3 MR' 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital jMonth I July Fund /Department Number 401 Date Updated 8/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 27 165 55 - (65) 165% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,100 27 165 55 - 14,935 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 15,100 27 165 55 - 14,935 Cash Balance 40,615 26,905 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Fd 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 MR' 2015 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment jMonth I July Fund /Department Number 403 1 Date Updated 8/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 33 200 100 - (0) 100% Bond Proceeds - - - - - - 0% Donations - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 200 33 200 100 - (0) 100% 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) 33 200 100 - (49,000) Cash Balance 49,362 49,122 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 IMonth I July Fund /Department Number 405 1 Date Updated 8/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 622 3,658 6,574 - 30,342 11% Interest Earnings 2,200 296 1,888 866 - 312 86% 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 918 9,796 19,584 - 133,904 7% Expenditures Personnel - - - - - - 0% Supplies 67,273 2,500 29,507 44,995 10,349 27,417 59% Services 50,660 24 5,952 17,468 4,480 40,228 21% Debt Service - - - - - - 0% Capital 75,000 22,499 22,499 95,000 - 52,501 30% Transfers Out - - - - - - 0% Total Expenditures 192,933 25,023 57,958 157,463 14,829 120,146 38% Net (49,233) (24,105) (48,162) (137,879) (14,829) 13,758 Cash Balance 473,002 435,012 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 jMonth I July Fund /Department Number 406 1 Date Updated 8/13/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 450,000 - 237,380 235,215 - 212,620 53% Local Income Taxes - - - - - - 0% Other Taxes 90,191 4,349 49,189 46,213 - 41,002 55% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 293 1,880 1,354 - 620 75% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 854 - - 0% Transfers In - - - - - - 0% Total Revenue 542,691 4,642 288,449 283,636 - 254,242 53% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 542,691 112,650 474,118 474,118 - 68,573 87% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 542,691 112,650 474,118 474,118 - 68,573 87% Net - (108,008) (185,669) (190,482) - 185,669 Cash Balance 395,582 595,317 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 PILOT payments 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 jMonth I July Fund /Department Number 407 1 Date Updated 8/13/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 150,000 267,652 273,553 - 129,348 67% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 118 536 94 - (386) 357% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,200 - - - - 25,200 0% Transfers In - - - - - - 0% Total Revenue 422,350 150,118 268,188 273,647 - 154,162 63% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 365,625 184,125 367,875 369,000 - (2,250) 101% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 365,625 184,125 367,875 369,000 - (2,250) 101% Net 56,725 (34,007) (99,687) (95,353) - 156,412 Cash Balance 149,796 81,371 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 IMonth I July Fund /Department Number 412 1 Date Updated 8/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 25,000 2,079 14,181 14,467 - 10,819 57% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 786,187 - 368,031 227,661 - 418,156 47% Transfers In - - - - - - 0% Total Revenue 811,187 2,079 382,212 242,128 - 428,975 47% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 3,096,061 364,718 1,446,751 912,592 1,260,721 388,589 87% Transfers Out - - - - - - 0% Total Expenditures 3,096,061 364,718 1,446,751 912,592 1,260,721 388,589 87% N 60 et (2,284,874) (362,638) (1,064,539) (670,464) (1,2,721) 40,386 Cash Balance 2,577,123 F 6,473,434 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 February, this fund received the first of two semi - annual payments on these loans, totaling $368,031 in principal and interest. Balances due as of 30 June are $787,402 from Fund 435 (Douglas Rd.) and $4,588,506 from Fund 436 (River East Residential, f /k /a Northeast Residential) Explain Significant Spending on Capital Projects Below: The 2015 budget continues funding for the Smart Streets initiative and includes $950,000 for Smart Streets, $350,000 for the King /LWW 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 Form 3 62 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital JMonth I July Fund /Department Number 416 1 Date Updated 8/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 100,000 - 33,091 50,080 - 66,909 33% Interest Earnings 1,500 349 2,104 960 - (604) 140% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 101,500 349 35,195 51,040 - 66,305 35% Expenditures Personnel - - - - - - 0% Supplies 30,210 8,884 20,109 6,026 - 10,101 67% Services 40,038 4,685 21,157 1,765 10,569 8,312 79% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 70,248 13,568 41,266 7,791 10,569 18,413 74% Net 31,252 (13,220) (6,071) 43,250 (10,569) 47,892 Cash Balance 509,349 500,060 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: 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 Enhanceme jMonth I July Fund /Department Number 434 1 Date Updated 8/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 150 31 199 179 - (49) 133% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 150 31 199 179 - (49) 133% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 462,206 - - - - 462,206 0% Debt Service 187,794 3,897 7,794 20,975 - 180,000 4% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 650,000 3,897 7,794 20,975 - 642,206 1% Net (649,850) (3,866) (7,595) (20,796) - (642,255) Cash Balance 2,243 (11,259) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: CRED is derived from State sale taxes generated within the CRED 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 jMonth I July Fund /Department Number 450 1 Date Updated 8/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 16,000 1,556 6,780 3,757 - 9,220 42% Interest Earnings 150 46 268 113 - (118) 179% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,150 1,602 7,048 3,870 - 9,102 44% 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 - 1,602 7,048 3,870 - (7,048) Cash Balance 70,209 57,265 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 jMonth I July Fund /Department Number 677 Date Updated 8/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 2,500 358 2,218 1,308 - 282 89% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 358 2,218 1,308 - 282 89% Expenditures Personnel - - - - - - 0% Supplies 15,000 - - 419 - 15,000 0% Services 173,824 3,444 32,805 48,034 - 141,019 19% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,824 3,444 32,805 48,453 - 156,019 17% Net (186,324) (3,086) (30,587) (47,145) - (155,737) Cash Balance 528,633 611,261 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. Explain Significant Spending on Capital Projects Below: No Capital expenditures budgeted for 2015. Form 3 65 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Cap JMonth I July Fund /Department Number 287 Date Updated 8/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 400,000 - 396,727 - - 3,273 99% Interest Earnings 350 242 957 - - (607) 273% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 750,000 - - - - 750,000 0% Total Revenue 1,150,350 242 397,684 - - 752,666 35% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 750,000 - 35,728 - 425,136 289,136 61% Transfers Out - - - - - - 0% Total Expenditures 750,000 - 35,728 - 425,136 289,136 61% Net 400,350 242 361,956 - (425,136) 463,530 Cash Balance 361,956 - 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 Form 3 67 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Oper jMonth I July Fund /Department Number 288 1 Date Updated 8/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 5,144,065 382,324 2,784,191 1,626,155 - 2,359,874 54% Interest Earnings 18,000 2,348 14,720 13,386 - 3,280 82% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 2,237 13,105 10,358 - 3,895 77% Transfers In 500,000 - - - - 500,000 0% Total Revenue 5,679,065 386,909 2,812,016 1,649,899 - 2,867,049 50% Expenditures Personnel 4,840,253 466,371 1,610,756 - - 3,229,497 33% Supplies 292,000 16,997 202,204 118,308 16,259 73,537 75% Services 375,337 12,515 114,230 199,242 11,162 249,945 33% Debt Service 448,773 225,583 452,302 246,683 1,728 (5,257) 101% Capital 149,003 - - 2,256,288 149,003 - 100% Transfers Out 750,000 - - - - 750,000 0% Total Expenditures 6,855,366 721,466 2,379,492 2,820,521 178,152 4,297,722 37% Net (1,176,301) (334,557) 432,524 (1,170,622) (178,152) (1,430,673) Cash Balance 3,316,865 4,399,314 Staffing Full Time 51.00 51.00 51.00 Part -Time /Seasonal /Temporary - - - Total 51.00 51.00 51.00 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, 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 Form 3 68 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund jMonth I July Fund /Department Number 600 1 Date Updated 8/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 - - - 1,600 - - 0% Charges for Services 1,536,052 198,778 1,136,103 766,784 - 399,949 74% Interest Earnings 2,100 575 3,543 862 - (1,443) 169% Bond Proceeds - - - - - - 0% Donations 100 - 52 - - 48 52% Other Income 7,817 3,069 21,300 1,198 - (13,483) 272% Transfers In 2,663,144 1,331,572 1,997,358 1,153,280 - 665,786 75% Total Revenue 4,209,213 1,533,994 3,158,355 1,923,724 - 1,050,858 75% Expenditures Personnel 2,454,138 238,967 1,323,114 1,037,590 2,160 1,128,864 54% Supplies 181,483 8,117 69,493 81,694 12,270 99,720 45% Services 1,538,733 115,930 483,900 633,870 611,691 443,142 71% Debt Service 31,047 3,029 13,508 12,207 1,056 16,483 47% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,205,401 366,042 1,890,015 1,765,361 627,177 1,688,209 60% Net 3,812 1,167,952 1,268,340 158,363 (627,177) (637,351) Cash Balance 2,003,109 1 311,445 Staffing Full Time 36.00 36.00 - Part -Time /Seasonal /Temporary 2.00 2.00 - Total 38.00 38.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages JMonth I July Fund /Department Number 601 1 Date Updated 8/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 908,675 75,732 531,855 520,233 - 376,820 59% Interest Earnings 5,600 713 4,334 1,903 - 1,266 77% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 130,850 6,674 47,707 112,199 - 83,143 36% Transfers In - - - - - - 0% Total Revenue 1,045,125 83,119 583,896 634,335 - 461,229 56% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,621,858 80,102 550,326 412,808 93,044 978,488 40% Debt Service - - - - - - 0% Capital 184,854 8,079 60,917 67,980 1,536 122,401 34% Transfers Out - - - - - - 0% Total Expenditures 1,806,712 88,181 611,243 480,788 94,580 1,100,889 39% Net (761,587) (5,062) (27,347) 153,547 (94,580) (639,660) Cash Balance 1,046,282 1,037,735 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 jMonth I July Fund /Department Number 610 1 Date Updated 8/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,346 2,961,577 2,889,099 - 2,257,739 57% Interest Earnings 2,500 292 1,676 1,232 - 824 67% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 490,473 81,248 167,221 212,376 - 323,252 34% Transfers In - - - - - - 0% Total Revenue 5,712,289 492,885 3,130,475 3,102,707 - 2,581,814 55% Expenditures Personnel 1,731,390 181,367 966,726 961,578 1,250 763,414 56% Supplies 371,208 16,079 152,894 240,650 42,254 176,060 53% Services 2,991,595 250,442 1,620,843 1,672,155 102,758 1,267,994 58% Debt Service 26,859 4,850 24,750 - 2,109 92% Capital - - - - - 0% Transfers Out 752,811 189,000 519,000 614,916 233,811 69% Total Expenditures 5,873,863 641,738 3,284,213 3,489,299 146,262 2,443,388 58% Net (161,574) (148,853) (153,738) (386,592) (146,262) 138,426 Cash Balance 264,139 411,802 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 slightly 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 jMonth I July Fund /Department Number 611 1 Date Updated 8/3/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 15 67 136 - 133 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 752,811 189,000 519,000 614,916 - 233,811 69% Total Revenue 753,011 189,015 519,067 615,052 - 233,944 69% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 752,811 188,912 553,414 562,006 - 199,397 74% Capital - 276 276 171,182 - (276) 0% Transfers Out - - - - - - 0% Total Expenditures 752,811 189,188 553,690 733,188 - 199,121 74% Net 200 (173) (34,623) (118,136) - 34,823 Cash Balance 577 304 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: 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 jMonth I July Fund /Department Number 620 1 Date Updated 8/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 14,638,403 1,164,495 7,842,214 8,028,113 - 6,796,189 54% Interest Earnings 29,000 2,401 18,702 6,485 - 10,298 64% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 93,580 6,558 38,809 63,875 - 54,771 41% Transfers In 19,500 3,149 22,848 8,191 - (3,348) 117% Total Revenue 14,780,483 1,176,602 7,922,574 8,106,663 - 6,857,909 54% Expenditures Personnel 5,023,137 503,471 2,773,442 2,535,217 2,050 2,247,645 55% Supplies 1,516,896 64,814 799,171 878,136 180,776 536,949 65% Services 4,979,548 361,859 2,213,505 2,613,861 303,746 2,462,296 51% Debt Service 17,936 90 3,951 2,854 2,278 11,708 35% Capital - - - - - - 0% Transfers Out 4,306,954 332,159 2,552,596 2,324,998 - 1,754,358 59% Total Expenditures 15,844,471 1,262,393 8,342,665 8,355,066 488,850 7,012,956 1 56% Net (1,063,988) (85,790) (420,091) (248,403) (488,850) (155,047) Cash Balance 3,849,151 3,248,338 Staffing Full Time 70.20 68.20 Part -Time /Seasonal /Temporary 3.00 2.00 Total 73.20 70.20 - 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 impacted by a one time transfer of cumulative interest earnings on investments from the Debt Service Reserve Fund. Other income sources were greater in 2014 because of scrap metal sales from retired water meters and from hydrant damage reimbursements. A significant portion of the expended supplies expense is for water meters and repair part purchases. 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 jMonth I July Fund /Department Number 622 1 Date Updated 8.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 2,006 12,473 7,163 - (2,473) 125% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 2,006 12,473 7,163 - (2,473) 125% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 3,600 - - 0% Debt Service - - - - - - 0% Capital 838,893 25,331 221,445 11,303 8,075 609,373 27% Transfers Out - - - - - - 0% Total Expenditures 838,893 25,331 221,445 14,903 8,075 609,373 27% Net (828,893) (23,325) (208,971) (7,740) (8,075) (611,847) Cash Balance 2,916,310 3,523,985 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 jMonth I July Fund /Department Number 623 Date Updated 8.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,343 - 1 100% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 545 - 544 1,343 - 1 100% Expenditures Personnel - - - - - - 0% Supplies 50,914 7,278 86,470 107,542 - (35,556) 170% Services 2,171 - 36,843 42,103 (34,672) 1697% Debt Service - - - - - - 0% Capital - - 59,529 374,356 - (59,529) 0% Transfers Out 245 240 240 - 5 98% Total Expenditures 53,330 7,519 183,082 524,001 - (129,752) 343% Net (52,785) (7,519) (182,539) (522,658) - 129,754 Cash Balance - 289,972 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, extensions 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 will be submitted 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 $124,649 Boland Park PRV $2,171 Form 3 74 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit jMonth I July Fund /Department Number 624 Date Updated 8.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 1,001 6,057 2,960 - (57) 101% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 40 - - 0% Total Revenue 6,000 1,001 6,057 3,000 - (57) 101% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - 0% Transfers Out 6,000 1,001 5,202 2,960 - 798 87% Total Expenditures 6,000 1,001 5,202 2,960 - 798 87% Net - - 855 40 - (855) Cash Balance 1,496,731 1,464,997 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 Form 3 76 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking jMonth I July Fund /Department Number 625 1 Date Updated 8.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 5,000 649 2,570 1,042 - 2,430 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 2,045,078 170,515 1,192,165 1,195,670 - 852,913 58% Total Revenue 2,050,078 171,165 1,194,735 1,196,712 - 855,343 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 2,045,078 350 365,823 384,220 - 1,679,255 18% Capital - - - - - - 0% Transfers Out 5,000 649 2,567 1,042 - 2,433 51% Total Expenditures 2,050,078 999 368,390 385,262 - 1,681,688 18% Net - 170,165 826,345 811,450 - (826,345) Cash Balance 831,001 816,787 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Semiannual 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 jMonth I July Fund /Department Number 626 Date Updated 8.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 1,078 3,429 3,162 6,071 36% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - 0% Transfers In - - - 59,948 - - 0% Total Revenue 9,500 1,078 3,429 63,110 - 6,071 36% 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) 1,078 (3,945) 63,110 - (1,055) Cash Balance 1,642,733 1,628,786 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 jMonth I July Fund /Department Number 629 1 Date Updated 8.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 8,500 1,499 8,908 4,187 - (408) 105% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 154,249 - 150,228 53,507 - 4,021 97% Total Revenue 162,749 1,499 159,136 57,694 - 3,613 98% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 1,499 7,705 4,187 - 795 91% Total Expenditures 8,500 1,499 7,705 4,187 - 795 91% 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. Current year transfer in revenue is for compliance puposes. Explain Significant Spending on Capital Projects Below: Form 3 78 Form 3 79 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance jMonth I July Fund /Department Number 640 1 Date Updated 8/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 551,200 50,310 354,524 341,134 196,676 64% Interest Earnings 3,600 1,041 6,249 (2,649) 174% Bond Proceeds - - 0% Donations - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 554,800 51,350 360,773 341,134 - 194,027 65% Expenditures Personnel 206,842 16,671 97,808 94,174 109,034 47% Supplies 28,603 1,451 11,758 6,696 9,451 7,394 74% Services 281,802 2,089 150,651 136,079 95,115 36,037 87% Debt Service 28,456 14,218 14,218 14,238 50% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 545,703 20,211 274,435 251,167 104,565 166,703 69% Net 9,097 31,139 86,338 89,967 (104,565) 27,324 Cash Balance 1,593,874 1,453,503 Staffing Full Time 2.20 1.85 - Part -Time /Seasonal /Temporary - - - Total 2.20 1.85 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 Form 3 80 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations jMonth I July Fund /Department Number 641 Date Updated 8/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 35,209,467 3,135,114 20,372,615 19,358,034 - 14,836,852 58% Interest Earnings 22,000 5,319 35,580 11,050 - (13,580) 162% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 92,100 17,971 59,917 55,134 - 32,183 65% Transfers In 15,000 2,466 12,649 6,891 - 2,351 84% Total Revenue 35,338,567 3,160,870 20,480,761 19,431,109 - 14,857,806 58% Expenditures Personnel 7,402,560 682,129 3,952,379 3,856,612 - 3,450,181 53% Supplies 2,154,745 59,260 668,684 877,590 209,294 1,276,767 41% Services 15,178,782 879,822 5,913,245 5,626,840 933,315 8,332,222 45% Debt Service 585,187 133,082 325,332 297,035 - 259,855 56% Capital - - - - - - 0% Transfers Out 14,875,700 773,536 9,670,840 9,554,397 - 5,204,860 65% Total Expenditures 40,196,974 2,527,829 20,530,480 20,212,473 1,142,608 18,523,885 54% Net (4,858,407) 633,040 (49,719) (781,364) (1,142,608) (3,666,080) Cash Balance 8,873,968 6,415,060 Staffing Full Time 95.25 84.40 Part -Time /Seasonal /Temporary 6.62 2.00 Total 101.87 86.40 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: 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 JMonth I July Fund /Department Number 642 1 Date Updated 8/3/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 39,000 4,451 19,764 10,566 - 19,236 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 5,359,000 - 4,000,000 4,000,000 - 1,359,000 75% Total Revenue 5,398,000 4,451 4,019,764 4,010,566 - 1,378,236 74% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 36,043 5,595 37,895 55,537 - (1,852) 105% Debt Service - - - - - - 0% Capital 7,035,667 212,053 1,540,506 2,739,862 2,174,874 3,320,287 53% Transfers Out - - - - - - 0% Total Expenditures 7,071,710 217,648 1,578,401 2,795,399 2,174,874 3,318,435 53% Net (1,673,710) (213,197) 2,441,363 1,215,167 (2,174,874) (1,940,198) Cash Balance 6,193,084 5,259,733 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: Year to Date totals spent include: Wastewater Treatment Plant Primary Clarifier rehab $1,107,820, Utility vehicle used at WWTP $13,131, Sewer Dept vehicles & equipment $444,223. Form 3 I.1 Form 3 E:YA 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. JMonth I July Fund /Department Number 643 1 Date Updated 8/3/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 2,466 14,624 6,891 - 376 97% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 256,612 - 256,086 129,964 - 526 100% Total Revenue 271,612 2,466 270,710 136,855 - 902 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 2,466 12,649 6,891 - 2,351 84% Total Expenditures 15,000 2,466 12,649 6,891 - 2,351 84% Net 256,612 - 258,061 129,964 - (1,449) Cash Balance 1 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 E:YA 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 jMonth I July Fund /Department Number 647 1 Date Updated 7/3/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 Form 3 84 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking jMonth I July Fund /Department Number 649 1 Date Updated 8/3/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 7,000 2,699 11,727 4,925 - (4,727) 168% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,281,088 773,537 5,414,754 5,424,433 - 3,866,334 58% Total Revenue 9,288,088 776,236 5,426,480 5,429,359 - 3,861,608 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,500 350 2,950 2,450 - (450) 118% 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,311 1,674,702 - 7,689,798 17% Net 5,979 775,886 3,834,169 3,754,656 - (3,828,190) Cash Balance 4,624,506 4,537,463 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve jMonth I July Fund /Department Number 653 Date Updated 8/3/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 1 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 1.1001 Form 3 E: %: 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 jMonth I July Fund /Department Number 658 1 Date Updated 8/3/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 5 - (1) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - 1 5 - (1) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 924 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - 2 2 - - (2) 0% Total Expenditures - 2 2 924 - (2) 0% Net - (2) (1) (919) - 1 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 E: %: 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 IMonth I July Fund /Department Number 659 1 Date Updated 8/3/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 347 3,724 14,551 2,276 62% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 347 3,724 14,551 - 2,276 62% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 323,670 - 7,813 1,984 9,857 306,001 5% Debt Service - - - - - - 0% Capital 3,388,168 - 1,077,545 2,915,412 442,920 1,867,703 45% Transfers Out - - - - - - 0% Total Expenditures 3,711,838 - 1,085,357 2,917,396 452,777 2,173,704 41% Net (3,705,838) 347 (1,081,633) (2,902,845) (452,777) (2,171,428) Cash Balance 517,753 4,945,654 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 JMonth I July Fund /Department Number 661 1 Date Updated 8/3/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 40,000 10,584 66,650 36,456 - (26,650) 167% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - 5 5 - - (5) 0% Total Revenue 40,000 10,588 66,654 36,456 - (26,654) 167% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,000,000 - - - - 1,000,000 0% Debt Service - - - - - - 0% Capital 15,624,275 201,706 1,353,542 513,294 2,407,582 11,863,151 24% Transfers Out - - - - - - 0% Total Expenditures 16,624,275 201,706 1,353,542 513,294 2,407,582 12,863,151 23% Net (16,584,275) (191,117) (1,286,887) (476,838) (2,407,582) (12,889,806) Cash Balance 15,532,377 17,822,189 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 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 $438,074, Sewer Sensory Control Network $176,941, Southwood Sewer Separation $15,838, Wastewater Treatment Plant Grit /Screening Improvements $111,491, Secondary Clarifier Modifications $342,842, and misc other $2,070. Form 3 88 2015 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund jMonth I July Fund /Department Number 664 1 Date Updated 8/3/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 3 18 9 - 32 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 50 3 18 9 - 32 37% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 50 3 18 9 - 32 Cash Balance 4,499 4,477 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 1*10" 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center IMonth I July Fund /Department Number 670 1 Date Updated 8/13/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 656,725 1,313,450 1,324,438 - (14) 100% Grants /Intergovernmental - - - - - - 0% Charges for Services 2,490,815 103,882 1,141,846 1,515,570 - 1,348,969 46% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 15,000 676 (24,429) 36,342 - 39,429 -163% Transfers In - - - - - - 0% Total Revenue 3,819,251 761,283 2,430,867 2,876,350 - 1,388,384 64% Expenditures Personnel 2,505,817 229,630 1,207,406 1,263,773 - 1,298,411 48% Supplies 496,646 59,285 321,686 262,268 - 174,960 65% Services 1,286,148 112,680 783,025 708,334 - 503,123 61% Debt Service - - - - - - 0% Capital 243,951 - - 338,301 - 243,951 0% Transfers Out - - - - - - 0% Total Expenditures 4,532,562 401,596 2,312,117 2,572,675 - 2,220,445 51% Net (713,311) 359,688 118,750 303,675 - (832,061) Cash Balance 1,479,682 886,037 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 1*10" 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital JMonth I July Fund /Department Number 671 1 Date Updated 8/13/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 95 366 174 - 134 73% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 95 366 174 - 134 73% Expenditures Personnel - - - - - - 0% Supplies 53,356 - 41,156 - - 12,200 77% Services 192,000 62,735 192,735 - - (735) 100% Debt Service - - - - - - 0% Capital 310,300 25,000 50,440 - - 259,860 16% Transfers Out 50,000 - 50,000 - - - 100% Total Expenditures 605,656 87,735 334,331 - - 271,325 55% Net (605,156) (87,639) (333,965) 174 - (271,191) Cash Balance 1,084,698 1,757,872 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 F!Y Form 3 MA 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Energy Conservation jMonth I July Fund /Department Number 672 Date Updated 8/13/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 - 4 11 - - (11) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 50,000 - 50,000 - - - 100% Total Revenue 50,000 4 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 4 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 MA Form 3 F!IN 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services jMonth I July Fund /Department Number 222 1 Date Updated 8/7/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 8,069,157 539,723 4,369,964 4,237,957 - 3,699,193 54% Interest Earnings 3,400 826 5,022 2,337 - (1,622) 148% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 78,627 30,252 76,651 103,944 - 1,976 97% Transfers In - - - - - - 0% Total Revenue 8,151,184 570,801 4,451,637 4,344,238 - 3,699,547 55% Expenditures Personnel 3,099,267 285,071 1,601,157 1,493,225 1,498,110 52% Supplies 167,428 15,447 76,820 70,441 35,897 54,711 67% Services 4,611,385 300,806 2,603,996 2,620,202 1,131,307 876,083 81% Debt Service 9,155 3,248 4,661 5,907 35% Capital 141,157 120,000 20,857 300 100% Transfers Out 271,850 - - - - 271,850 0% Total Expenditures 8,300,242 601,324 4,405,221 4,188,530 1,188,060 2,706,961 67% Net (149,058) (30,523) 46,416 155,708 (1,188,060) 992,586 Cash Balance 1,615,563 1,575,256 Staffing Full Time 42.00 39.00 39.00 Part -Time /Seasonal /Temporary 2.00 2.00 2.00 Total 44.00 41.00 41.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 July we had 1,354 vehicle repairs. Average Fuel prices for June is $2.10 for Unleaded and $2.07 for Diesel. Budgeted amount per gallon is $3.45. Explain Significant Spending on Capital Projects Below: 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 F!IN 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Capital JMonth I July Fund /Department Number 224 Date Updated 8/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 - - - - - - 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) 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 ME Form 3 1:xi 2015 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance jMonth I July Fund /Department Number 226 1 Date Updated 8/12/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 99,293 710,677 1,665,017 - 512,051 58% Interest Earnings 20,500 3,338 21,574 10,401 - (1,074) 105% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,375 - 2,375 47,667 - 17,000 12% Transfers In - - - - - - 0% Total Revenue 1,262,602 102,631 734,625 1,723,084 - 527,977 58% Expenditures Personnel 314,491 23,021 136,013 103,093 - 178,478 43% Supplies 30,189 7,024 23,952 9,214 1,383 4,855 84% Services 2,712,111 287,075 1,864,194 1,628,500 39,186 808,731 70% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,056,791 317,120 2,024,158 1,740,807 40,569 992,064 68% Net (1,794,189) (214,489) (1,289,533) (17,722) (40,569) (464,087) Cash Balance 4,390,541 5,167,775 Staffing Full Time 3.00 2.00 Part -Time /Seasonal /Temporary - - Total 3.00 2.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: No capital expenditures are budgeted in 2015. Form 3 1:xi Form 3 Mt 2015 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police jMonth I July Fund /Department Number 278 1 Date Updated 8/13/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 6,770 36,970 35,310 - 24,130 61% Interest Earnings 2,000 385 2,224 968 - (224) 111% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 61,100 6,770 36,970 35,203 - 24,130 61% Transfers In - - - - - - 0% Total Revenue 124,200 13,925 76,164 71,481 - 48,036 61% Expenditures Personnel - - - - - - 0% Supplies 61,100 - - - 61,100 0% Services 10,000 1,086 1,086 - - 8,914 11% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 71,100 1,086 1,086 - - 70,014 2% Net 53,100 12,839 75,078 71,481 - (21,978) Cash Balance 591,090 524,434 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. No expenditures for vehicle claims have been paid so far in 2015.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 Mt 2015 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefit jMonth I July Fund /Department Number 711 1 Date Updated 8/12/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,193,728 8,463,590 7,507,251 - 7,851,410 52% Interest Earnings 23,345 3,272 18,669 11,441 - 4,676 80% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,425 - 19,399 104,139 - 26 100% Transfers In - - - - - - 0% Total Revenue 16,357,770 1,197,000 8,501,658 7,622,832 - 7,856,112 52% Expenditures Personnel 4,326 1 6 - - 4,320 0% Supplies 21,875 2,100 6,737 29,055 5,851 9,287 58% Services 844,520 44,787 439,052 382,114 164,801 240,667 72% Insurance 15,826,214 1,208,473 7,475,079 8,278,106 23,012 8,328,123 47% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 16,696,935 1,255,361 7,920,873 8,689,276 193,665 8,582,397 49% Net (339,165) (58,361) 580,784 (1,066,444) (193,665) (726,285) Cash Balance 4,637,772 4,595,003 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 MA Form 3 14.1 2015 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation jMonth I July Fund /Department Number 713 1 Date Updated 8/13/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 112,996 8,473 59,314 59,712 - 53,682 52% Interest Earnings 800 161 982 508 - (182) 123% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 113,796 8,634 60,296 60,220 - 53,500 53% Expenditures Personnel 200,000 7,605 43,506 86,292 - 156,494 22% Supplies - - - - - - 0% Services 26,796 566 12,764 4,214 11,000 3,032 89% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 226,796 8,171 56,270 90,506 11,000 159,526 30% Net (113,000) 463 4,026 (30,286) (11,000) (106,02mill Cash Balance 245,197 229,745 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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% unless the claims increase substantially. For the 2015 budget, all outplacement services will be 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 14.1 Form 3 1 *9 2015 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension jMonth I July Fund /Department Number 701 1 Date Updated 8/13/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 5,036,025 - 2,518,013 2,564,549 - 2,518,012 50% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,500 - 872 711 - 3,628 19% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,000 1,415 5,159 - - (1,159) 129% Transfers In - - - - - - 0% Total Revenue 5,044,525 1,415 2,524,043 2,565,260 - 2,520,482 50% Expenditures Personnel 5,661,579 427,825 3,056,406 3,176,119 - 2,605,173 54% Supplies 200 - - - - 200 0% Services 4,800 103 3,563 421 - 1,237 74% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,666,579 427,928 3,059,969 3,176,540 - 2,606,610 54% Net (622,054) (426,513) (535,926) (611,280) - (86,128) Cash Balance 103,378 326,820 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: No capital expenditures are purchased through this account. Form 3 1 *9 Form 3 K1101 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Pension jMonth I July Fund /Department Number 702 1 Date Updated 8/7/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 1,546 1,632 - 4,454 26% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,000 62 62 - - 3,938 2% Transfers In - - - - - - 0% Total Revenue 6,385,359 62 3,189,287 3,057,565 - 3,196,072 50% Expenditures Personnel 6,827,035 518,100 3,719,378 4,025,754 - 3,107,657 54% Supplies 800 - - 151 - 800 0% Services 4,400 115 3,503 417 - 897 80% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,832,235 518,215 3,722,881 4,026,322 - 3,109,354 54% Net (446,876) (518,153) (533,594) (968,757) - 86,718 Cash Balance 577,180 739,900 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 K1101 2015 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery jMonth I July Fund /Department Number 730 1 Date Updated 8/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 19 116 75 - 34 77% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 150 19 116 75 - 34 77% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 20,000 - - - - 20,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 20,000 - - - - 20,000 0% Net (19,850) 19 116 75 - (19,966) Cash Balance 28,493 37,009 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 fiord 2015 City of South Bend Monthly Financial Report Fund /Department Name River West Development Area (Airp JMonth I July Fund /Department Number 324 1 Date Updated 8/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 16,433,274 - 9,396,168 7,521,012 - 7,037,106 57% Local Income Taxes - - - - - - 0% Other Taxes 490,500 - 292,000 - - 198,500 60% Grants /Intergovernmental - - - - - - 0% Charges for Services 18,000 - 14,061 - - 3,939 78% Interest Earnings 102,096 24,077 148,597 47,079 - (46,501) 146% Bond Proceeds - - - 101,267 - - 0% Donations - - - - - - 0% Other Income 2,937,336 3,127 1,693,318 5,296 - 1,244,018 58% Transfers In 4,963,040 1,860 4,981,467 2,107 - (18,427) 100% Total Revenue 24,944,246 29,064 16,525,611 7,676,761 - 8,418,635 66% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 7,729,770 193,778 2,183,083 1,967,929 1,325,308 4,221,379 45% Debt Service 6,475,584 2,635,210 6,231,656 2,536,453 - 243,928 96% Capital 33,505,243 780,197 2,778,704 46,017 12,432,349 18,294,190 45% Transfers Out - - - - - - 0% Total Expenditures 47,710,597 3,609,185 11,193,443 4,550,399 13,757,657 22,759,497 52% Net (22,766,351) (3,580,121) 5,332,168 3,126,362 (13,757,657) (14,340,862) Cash Balance 36,664,739 28,146,492 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 boundry, 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. Explain Significant Spending on Capital Projects Below: 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, and Studebaker Envionmental. Major project expenditures (other than debt service) to date have been made on: Nello (about $1.8M) and Renaissance District (about $1.2M). For more information please call 574/235 -9330. Form 3 102 Form 3 103 2015 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing (TIF) - Do jMonth I July Fund /Department Number 420 1 Date Updated 8/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 - - - 2,485,266 - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - 200,000 - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - 22,492 - - 0% Interest Earnings - - - 25,518 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 173,989 - - 0% Transfers In - - - 3,521 - - 0% Total Revenue - - - 2,910,786 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 282,797 - - 0% Debt Service - - - 2,772,964 - - 0% Capital - - - 15,392 - - 0% Transfers Out 4,088,473 - 4,088,473 - - - 100% Total Expenditures 4,088,473 - 4,088,473 3,071,153 - - 100% Net (4,088,473) - (4,088,473) (160,367) - - Cash Balance - 2,444,107 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 JMonth I July Fund /Department Number 422 1 Date Updated 8/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 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 849 4,805 1,229 - (2,005) 172% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 422,800 849 200,671 305,381 - 222,129 47% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 30,600 - 30,294 319 3,366 (3,060) 110% Debt Service - - - - - - 0% Capital 730,300 - - - - 730,300 0% Transfers Out - - - - - - 0% Total Expenditures 760,900 - 30,294 319 3,366 727,240 4% Net (338,100) 849 170,377 305,062 (3,366) (505,111) Cash Balance 1,366,126 918,024 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 so little can be gained by comparing expenditures from year to year. Major Projects committed thus far in 2015 are: City Cemetery Project. Explain Significant Spending on Capital Projects Below: 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 Form 3 KIb1 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton jMonth I July Fund /Department Number 425 1 Date Updated 8/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 300 110 577 181 - (277) 192% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 189,123 13,045 100,022 92,065 - 89,101 53% Transfers In - - - - - - 0% Total Revenue 189,423 13,155 100,599 92,246 - 88,824 53% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 154,716 4,246 74,668 64,765 - 80,048 48% Debt Service - - - - - - 0% Capital - - - 14,353 - - 0% Transfers Out - - - - - - 0% Total Expenditures 154,716 4,246 74,668 79,118 - 80,048 48% Net 34,707 8,909 25,931 13,128 - 8,776 Cash Balance 198,457 146,195 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 KIb1 Form 3 `[IN 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area jMonth I July Fund /Department Number 426 1 Date Updated 8/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 - - - 459,659 - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - 5,617 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 465,276 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 1,543,685 - - 0% Debt Service - - - - - - 0% Capital - - - 185,830 - - 0% Transfers Out 2,294,533 - 2,294,533 - - 100% Total Expenditures 2,294,533 - 2,294,533 1,729,515 - - 100% Net (2,294,533) - (2,294,533) (1,264,239) - - Cash Balance - 1,968,174 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 `[IN Form 3 107 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Development Area (NE D JMonth I July Fund /Department Number 429 1 Date Updated 8/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 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 4,408 23,038 6,085 - 13,962 62% 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 4,408 2,864,372 814,269 - 965,281 75% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 126,044 188 62,717 1,475 54,372 8,955 93% Debt Service - - - - - - 0% Capital 7,113,480 3,250 86,268 - 234,231 6,792,981 5% Transfers Out - - - - - - 0% Total Expenditures 7,239,524 3,438 148,985 1,475 288,603 6,801,936 6% Net (3,409,871) 970 2,715,387 812,794 (288,603) (5,836,655) Cash Balance 7,271,868 3,821,584 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. For more information please call 574/235 -9330. Form 3 107 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 JMonth I July Fund /Department Number 430 1 Date Updated 8/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 2,400,000 - 1,298,974 1,268,946 - 1,101,026 54% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10,750 3,377 18,706 6,673 - (7,956) 174% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,410,750 3,377 1,317,680 1,275,619 - 1,093,070 55% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 669,885 8,551 165,984 141,910 484,003 19,898 97% Debt Service - - - - - - 0% Capital 2,172,650 - 451,133 210,145 168,305 1,553,212 29% Transfers Out - - - - - - 0% Total Expenditures 2,842,535 8,551 617,117 352,055 652,308 1,573,110 45% Net (431,785) (5,174) 700,563 923,564 (652,308) (480,040) Cash Balance 5,657,854 4,363,213 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: TIF projects vary widely from one year to the next so expenditure comparison will not yield reliable trend review. Explain Significant Spending on Capital Projects Below: 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 `[IN 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road JMonth I July Fund /Department Number 435 1 Date Updated 8/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 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 90 423 526 - 327 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 256 256 - - (256) 0% Transfers In - - - - - - 0% Total Revenue 320,750 346 164,623 161,473 - 156,127 51% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,200 - - 160 4,200 - 100% Debt Service 341,189 - 169,620 95,231 - 171,569 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 345,389 - 169,620 95,391 4,200 171,569 50% Net (24,639) 346 (4,997) 66,082 (4,200) (15,442) Cash Balance 216,433 360,683 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: Projects for 2014 include: the Douglas Road Turn Lane. Form 3 `[ID] Form 3 full 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Residential (NE Res TIF) JMonth I July Fund /Department Number 436 1 Date Updated 8/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 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,408 - 3,429 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 211,000 210,999 210,999 - - 1 100% Transfers In - - - - - - 0% Total Revenue 2,815,000 210,999 1,876,142 1,384,906 - 938,858 67% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 3,425,632 1,467,450 3,179,039 3,115,718 - 246,593 93% Capital - - - 214,573 - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,425,632 1,467,450 3,179,039 3,330,291 - 246,593 93% Net (610,632) (1,256,451) (1,302,897) (1,945,385) - 692,265 Cash Balance 402,607 608,694 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 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 full 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General jMonth I July Fund /Department Number 433 1 Date Updated 8/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 252 7 41 37 - 211 16% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 252 7 41 37 - 211 16% 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) 7 41 (15,666) - (5,789) Cash Balance 10,131 10,082 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 ME Form 3 112 2015 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park jMonth I July Fund /Department Number 439 Date Updated 8/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 33,904 2,940 19,561 7,476 - 14,343 58% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 33,904 2,940 19,561 7,476 - 14,343 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - 64 - - (64) 0% Debt Service - - - - - - 0% Capital 5,000,000 492,595 1,287,354 - 2,232,365 1,480,281 70% Transfers Out - - - - - - 0% Total Expenditures 5,000,000 492,595 1,287,418 - 2,232,365 1,480,217 70% Net (4,966,096) (489,655) (1,267,857) 7,476 (2,232,365) (1,465,874) Cash Balance 3,752,704 3,690,071 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 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 jMonth I July Fund /Department Number 454 1 Date Updated 8/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,500 254 1,537 764 - (37) 102% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 254 1,537 764 - (37) 102% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 254 1,537 764 - (37) Cash Balance 378,978 377,136 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 Form 3 114 2015 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations jMonth I July Fund /Department Number 619 1 Date Updated 8/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 119,799 - 119,297 1,012,753 - 502 100% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 119,799 - 119,297 1,012,753 - 502 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 201,649 - 201,228 872,878 - 421 100% Debt Service - - - - - - 0% Capital - - - 7,053 - - 0% Transfers Out - - - - - - 0% Total Expenditures 201,649 - 201,228 879,931 - 421 100% Net (81,850) - (81,931) 132,822 - 81 Cash Balance - 210,548 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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 jMonth I July Fund /Department Number 315 1 Date Updated 8/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 5,000 697 4,225 2,107 - 775 85% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 697 4,225 2,107 - 775 85% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 697 3,626 2,107 - 1,374 73% Total Expenditures 5,000 697 3,626 2,107 - 1,374 73% Net - - 599 - - (599) Cash Balance 1 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 W&I 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve jMonth I July Fund /Department Number 317 1 Date Updated 8/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,800 339 2,057 1,022 - (257) 114% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,800 339 2,057 1,022 - (257) 114% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,800 339 2,057 1,022 - (257) Cash Balance 506,959 504,494 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 Mr.] 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Ro jMonth I July Fund /Department Number 328 1 Date Updated 8/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 6,000 1,164 7,059 3,521 - (1,059) 118% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 1,164 7,059 3,521 - (1,059) 118% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 1,164 6,058 3,521 - (58) 101% Total Expenditures 6,000 1,164 6,058 3,521 - (58) 101% Net - - 1,001 - - (1,001) 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 Form 3 fi-1 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 jMonth I July Fund /Department Number 432 1 Date Updated 8/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 - - 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 3,622 22,573 12,328 - 2,427 90% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 3,622 34,063 21,503 - (9,063) 136% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 203,000 - 201,724 656 - 1,276 99% Debt Service 488,380 130,835 488,380 491,495 - - 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 691,380 130,835 690,104 492,151 - 1,276 100% Net (666,380) (127,213) (656,041) (470,648) - (10,339) Cash Balance 5,846,814 6,498,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 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 fi-1