The URL can be used to link to this page

Home My WebLink About05-2015 Departmental Financial ReportPeriod Ending: May 31, 2015 Issued By: Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents Mayor Pete Buttigieg 1 Narrative 2 Summaries 8 General Fund 22 Special Revenue Funds 56 Debt Service /Capital Project Funds 68 Enterprise Funds 95 Internal Service Funds 101 Trust Funds 104 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff Kathryn Roos 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 May 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 18th of the month following the reporting period. The staff of the Department of Administration & Finance then summarizes the data and publishes this consolidated report no later than 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 May 31, 2015, total revenue for the year was $82,419,087, 29% of estimated revenue. As of May 31, 2014 total revenue received was $71,542,700 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; $10.1 million of that total was received as of May 31. Local taxes are received monthly and thus we've received 42% of the annual budget so far. Last month's lackluster cash receipts in the Enterprise funds were remedied in May, apparently due to a timing issue. The General Fund continues to lag, however, having received only 10% of its budgeted revenue as of May 31 due to timing of property tax receipts in June and December. 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 May 31, 2015, total expenditures were $113,368,614 and outstanding encumbrances were $36,711,297, a total of $150,079,911 which represents 40% 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 29% of the amended expenditure budget at the end of the period. Total expenditures were $109,617,867 as of May 31, 2014. 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 May 31, 2015 Fund Dept Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget alance Percent of Budget City Funds General Fund 52,609,678 1,088,889 5,283,840 5,469,630 1,610,303 10% Special Revenue 102 Rainy Day 34,680 2,689 20,220 14,558 14,460 58% 103 Excess Levy - 1 5 - (5) 0% 201 Parks & Recreation 11,030,715 280,074 941,286 953,395 10,089,429 9% 202 Motor Vehicle Highway 9,681,300 1,504,136 4,488,861 3,854,859 5,192,439 46% 203 Recreation Nonreverting 1,578,935 75,090 430,352 408,968 1,148,583 27% 209 Studebaker - Oliver Reverting Grants 644,000 15,140 57,107 1,830 586,893 9% 210 Economic Development State Grants 3,673,510 93 747 18,627 3,672,763 0% 211 Department of Community Investment (DCI) 2,634,125 500,685 1,108,200 979,995 1,525,925 42% 212 Dept of Community Investment Grants 4,100,000 231,389 896,077 835,390 3,203,923 22% 216 Police State Seizures 35,900 59 1,246 23,801 34,654 3% 217 Gift, Donation, Bequest 223,800 195 3,246 21,255 220,554 1% 218 Police Curfew Violations 1,025 4 41 157 984 4% 220 Law Enforcement Continuing Education 211,000 18,300 153,231 86,979 57,769 73% 227 Loss Recovery 50,000 2,128 41,676 13,311 8,324 83% 244 Emergency Phone System 20 - 19 215,000 1 97% 249 Public Safety LOIT 6,472,190 539,072 2,696,788 2,661,555 3,775,402 42% 251 Local Roads & Streets 1,593,300 99,309 488,670 486,952 1,104,630 31% 252 Excess Welfare Distribution - 0 0 2 (0) 0% 258 Human Rights Federal Grant 203,400 6,425 25,064 23,638 178,336 12% 271 Eastrace Waterway - 2 12 24 (12) 0% 273 Morris PAC / Palais Royale Marketing 18,000 1,258 3,276 5,198 14,724 18% 280 Police Block Grants - 1 9 6 (9) 0% 281 Economic Develop. Commission- Revenue Bonds - 8 64 46 (64) 0% 289 HAZMAT 10,000 10 13,866 27 (3,866) 139% 291 Indiana River Rescue 45,200 12,628 21,834 31,168 23,366 48% 292 Police Grants 90,000 - 56,946 66,716 33,054 63% 294 Regional Police Academy 22,000 21 20,653 18,035 1,347 94% 295 COPS MORE Grant 128,258 620 36,278 4,341 91,980 28% 299 Police Federal Drug Enforcement 77,000 18,004 64,159 20,569 12,841 83% 404 County Option Income Tax 9,883,971 784,041 4,090,202 3,844,331 5,793,769 41% 408 Economic Development Income Tax 9,526,537 1,106,220 4,270,375 4,049,390 5,256,162 45% 410 Urban Development Action Grant 528,686 45 241,961 47 286,725 46% 655 Project Releaf 431,700 36,928 184,536 183,039 247,164 43% 705 Police K -9 Unit 2,000 1 508 1,003 1,492 25% Special Revenue Total 62,931,252 5,234,577 20,357,518 18,824,211 42,573,734 32% City Debt Service 313 Football Hall of Fame Debt Service 1,274,056 4,256 21,323 35,699 1,252,733 2% City Debt Service Total 1,274,056 4,256 21,323 35,699 1,252,733 2% Capital Project 377 Professional Sports Development 671,761 29,386 365,361 215,859 306,400 54% 401 Coveleski Stadium Capital 15,100 13 95 45 15,005 1% 403 Zoo Endowment 200 15 115 83 85 58% 405 Park Nonreverting Capital 143,700 1,573 7,609 14,157 136,091 5% 406 Cumulative Capital Development 542,691 4,482 22,936 20,611 519,755 4% 407 Cumulative Capital Improvement 422,150 21 348 84 421,802 0% 412 Major Moves Construction 811,187 1,066 376,659 239,742 434,528 46% 416 Morris Performing Arts Center Capital 101,500 8,413 31,778 46,898 69,723 31% 434 Community Revitalization Enhancement District 650,000 30 136 129 649,864 0% 450 Palais Royale Historic Preservation 16,150 1,136 4,783 2,877 11,367 30% 677 Football Hall of Fame Capital 2,500 168 1,293 1,097 1,207 52% Capital Project Total 3,376,939 46,302 811,112 541,582 2,565,827 24% Enterprise 287 Emergency Medical Services Capital 750,000 112 397,059 - 352,941 53% 288 Emergency Medical Services Operating 5,676,065 434,559 1,916,663 1,174,225 3,759,402 34% 600 Consolidated Building Fund 4,154,113 253,431 1,437,718 1,624,707 2,716,395 35% 601 Parking Garages 1,108,726 97,905 409,655 466,977 699,071 37% 610 Solid Waste Operations 5,712,289 414,603 2,220,732 2,143,766 3,491,557 39% City of South Bend Monthly Department Financial Report REVENUE SUMMARY May 31, 2015 620 Water Works Operations 14,780,483 1,117,461 5,373,904 5,530,295 9,406,579 36% 622 Water Works Capital 10,000 946 7,242 5,961 2,758 72% 623 Water Works Bond Capital - 41 407 1,213 (407) 0% 624 Water Works Customer Deposit 6,000 463 3,474 2,462 2,526 58% 625 Water Works Sinking 2,050,078 170,477 852,412 854,797 1,197,666 42% 626 Water Works Bond Reserve 9,500 - 2,351 45,444 7,149 25% 629 Water Works Reserve Operations & Maintenance 162,749 695 155,271 56,985 7,478 95% 640 Sewer Repair Insurance 549,200 50,308 257,548 242,137 291,652 47% 641 Sewage Works Operations 35,334,467 2,980,691 14,318,008 13,614,054 21,016,459 41% 642 Sewage Works Capital 5,398,000 4,001,015 4,008,563 4,008,612 1,389,437 74% 643 Sewage Works Reserve Operations & Maint. 250,612 1,143 264,348 135,691 (13,736) 105% 647 Sewer Bond 2007 - - - 2 - 0% 649 Sewage Sinking 9,288,088 774,671 3,872,150 3,878,151 5,415,938 42% 658 Sewer Bond 2010 - - 0 4 (0) 0% 659 Sewer Bond 2011 6,000 175 2,827 12,486 3,173 47% 661 Sewer Bond 2012 20,000 5,061 39,033 30,396 (19,033) 195% 664 2013A Cost of Issuance Fund - 1 10 8 (10) 0% 670 Century Center 4,532,562 169,457 1,400,629 1,370,811 3,131,933 31% 671 Century Center Capital 500 74 164 145 336 33% 672 Century Center Energy Conservation Debt Svc 50,000 50,000 50,000 - - 100% Enterprise Total 90,602,443 10,523,307 37,274,219 35,649,367 53,328,224 41% Internal Service 222 Central Services 8,121,097 619,227 3,296,540 3,262,043 4,824,557 41% 224 Central Services Capital 271,850 - - - 271,850 0% 226 Liability Insurance 1,260,227 100,942 519,763 1,234,060 740,464 41% 278 Take Home Vehicle Police 124,200 9,352 52,521 52,550 71,679 42% 711 Self- Funded Employee Benefits 16,357,570 1,200,922 6,104,451 5,373,142 10,253,119 37% 713 Unemployment Compensation 226,796 8,549 42,931 43,080 183,865 19% Internal Service Total 26,361,740 1,938,993 10,016,206 9,964,875 16,345,534 38% Trust & Agency 701 Firefighters Pension 5,211,592 - 4,615 711 5,206,977 0% 702 Police Pension 6,360,000 - 1,546 1,632 6,358,454 0% 730 City Cemetery 150 9 66 62 84 44% Trust & Agency Total 11,571,742 9 6,228 2,405 11,565,514 0% City Funds Tota 727,850 18,836,332 73,770,446 70,487,768 129,241,869 30% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 24,940,646 37,081 6,946,240 41,123 17,994,406 28% 420 Tax Incremental Financing (TIF) - Downtown - - - 364,720 - 0% 422 TIF - West Washington 422,000 364 2,719 1,014 419,281 1% 425 Redevelopment Retail & Leighton Plaza 189,123 8,977 71,583 63,087 117,540 38% 426 TIF - Central Medical Service Area - - - 5,091 - 0% 429 River East Development Area (NE Dev TIF) 3,829,653 1,830 1,462,723 5,045 2,366,930 38% 430 TIF - Southside Development #1 2,410,000 1,371 10,674 5,580 2,399,326 0% 435 TIF - Douglas Road 320,750 16 278 455 320,472 0% 436 River East Residential (NE Res TIF) 2,815,000 - 1,571 2,146 2,813,429 0% Tax Increment Financing Total 34,927,172 49,639 8,495,788 488,261 26,431,384 24% Redevelopment 433 Redevelopment General 252 3 24 33 228 10% 439 Certified Technology Park 4,404 1,558 11,742 6,221 (7,338) 267% 454 Airport Urban Enterprise Zone 1,500 117 883 636 617 59% 619 Blackthorn Operations 1,696,879 59 119,297 543,979 1,577,582 7% Redevelopment Total 1,703,035 1,737 131,946 550,869 1,571,089 8% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 323 2,429 1,754 2,571 49% 317 Coveleski Debt Service Reserve 1,800 157 1,181 851 619 66% 328 Redevelopment Bond - Palais Royale 6,000 539 4,058 2,931 1,942 68% 432 TIF - Southside Development #3 25,000 1,675 13,236 10,266 11,761 53% 3 Fund rype Dept Name City of South Bend Monthly Department Financial Report REVENUE SUMMARY May 31, 2015 37,800 2,694 20,904 15,802 16,893 55% Redevelopment Commission Controlled Funds Total 36,668,007 54,070 8,648,638 15054,932 2850195366 '4% Grand Total 285,395,857 18,890,402 82,419,084 71,542,700 157,261,235 29% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY May 31, 2015 General Fund 101 -0101 Mayor's Office 741,267 53,138 290,326 284,586 133 450,808 39% 101 -0104 311 Call Center 486,733 35,855 204,324 182,540 2,390 280,019 42% 101 -0201 City Clerk 431,573 27,469 142,971 133,489 17,648 270,954 37% 101 -0301 Common Council 490,150 47,806 248,422 126,168 42,005 199,724 59% 101 -0302 WNIT Contract 43,000 43,000 43,000 - - - 100% 101 -0401 Administration & Finance 2,008,924 154,038 752,011 816,376 19,096 1,237,817 38% 101 -0404 Morris Performing Arts Center 1,093,132 75,072 415,508 412,894 34,233 643,390 41 101 -0405 Palais Royale 536,293 34,119 178,851 179,539 35,429 322,013 40% 101 -0501 Legal Department 1,018,599 73,432 381,053 420,401 11,161 626,385 39% 101 -0602 Engineering 1,058,933 67,688 372,400 431,505 123,620 562,913 47% 101 -0801 Police Department 25,633,064 1,869,819 10,147,286 9,585,163 268,697 15,217,081 41 101 -0802 Communications Center 1,687,540 128,638 778,301 804,080 900,410 8,829 99% 101 -0901 Fire Department 17,774,474 1,314,720 7,889,395 8,608,657 230,437 9,654,641 46% 101 -0905 Fire LOIT 2013 - - 411 - - (411) 0% 101 -1008 Human Rights 373,179 27,284 159,545 135,335 7,344 206,290 45% 101 -1201 Code 2013 2,270 (710) (710) 851 2,269 711 69% 101 -1207 Animal Control 2013 - - - 300 - - 0% General Fund Total 53,379,131 3,951,368 22,003,095 22,121,883 1,694,873 29,681,163 44% Special Revenue 201 Parks & Recreation 11,063,995 763,531 4,352,272 4,677,611 325,129 6,386,594 42% 202 Motor Vehicle Highway 10,485,386 440,322 3,585,214 3,570,097 70,658 6,829,514 35% 203 Recreation Nonreverting 1,549,469 84,777 344,169 304,312 118,875 1,086,425 30% 209 Studebaker - Oliver Reverting Grants 630,000 14,798 34,562 - 532,858 62,580 90% 210 Economic Development State Grants 3,694,412 400,000 430,203 18,003 1,206,539 2,057,670 44% 211 Department of Community Investment (DCI) 2,661,730 182,681 986,168 923,706 31,318 1,644,244 38% 212 Dept of Community Investment Grants 6,547,968 284,129 1,215,173 872,400 2,138,052 3,194,743 51 216 Police State Seizures 35,900 - - - - 35,900 0% 217 Gift, Donation, Bequest 297,182 28,211 81,093 2,786 1,552 214,537 28% 218 Police Curfew Violations 1,000 - - - - 1,000 0% 220 Law Enforcement Continuing Education 362,478 29,310 126,405 69,791 61,376 174,697 52% 227 Loss Recovery 5,237,243 555,991 2,254,417 343,392 1,772,002 1,210,824 77% 244 Emergency Phone System - - - 96,032 - - 0% 249 Public Safety LOIT 7,246,551 516,948 2,818,828 3,007,307 - 4,427,723 39% 251 Local Roads & Streets 1,926,221 109,145 161,834 43,282 882,517 881,870 54% 258 Human Rights Federal Grant 247,357 12,797 81,402 69,860 14,709 151,246 39% 271 Eastrace Waterway 4,000 - 2,098 9,092 1,098 804 80% 273 Morris PAC / Palais Royale Marketing 18,974 2,454 7,767 - 16,520 13% 289 HAZMAT 31,530 - 21,542 - 9,988 68% 291 Indiana River Rescue 120,800 20,420 44,790 6,740 76,010 37% 292 Police Grants 105,145 - 15,297 138,059 89,848 15% 294 Regional Police Academy 23,750 477 24,793 11,012 - (1,043) 104% 295 COPS MORE Grant 172,335 479 27,501 5,590 10,761 134,589 22% 299 Police Federal Drug Enforcement 248,960 6,225 56,324 45,076 30,678 161,958 35% 404 County Option Income Tax 15,660,371 914,359 4,267,398 3,809,028 1,291,150 10,101,823 35% 408 Economic Development Income Tax 9,627,618 1,034,072 3,688,180 4,827,548 343,461 5,595,978 42% 410 Urban Development Action Grant 438,203 - 146,068 - - 292,135 33% 655 Project Releaf 528,358 2,442 49,477 49,650 478,881 9% 705 Police K -9 Unit 2,000 - 970 - 1,030 49% Special Revenue Total 78,968,936 5,401,114 24,818,632 22,908,142 8,832,731 45,318,089 43% City Debt Service 313 Football Hall of Fame Debt Service 1,266,820 - 636,000 634,500 - 630,820 50% City Debt Service Total 1,266,820 636,000 634,500 630,820 50% Capital Project 377 Professional Sports Development 854,803 481,573 483,673 373,230 56% 403 Zoo Endowment 49,000 - - 49,000 0% 405 Park Nonreverting Capital 192,933 19,422 21,619 149,923 28,785 142,529 26% 406 Cumulative Capital Development 542,691 135,726 304,922 304,922 - 237,769 56% 407 Cumulative Capital Improvement 365,625 - 183,750 185,250 - 181,875 50% 412 Major Moves Construction 3,096,061 116,706 800,073 380,429 1,905,913 390,074 87% 416 Morris Performing Arts Center Capital 70,248 - 25,958 7,139 21,784 22,506 68% 434 Community Revitalization Enhancement District 650,000 3,897 20,975 - 646,103 1 450 Palais Royale Historic Preservation 16,150 - - 16,150 0% R City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY May 31, 2015 677 Football Hall of Fame Capital 188,824 3,276 26,740 41,253 162,084 14% Capital Project Total 6,026,335 275,130 1,848,532 1,573,564 1,956,482 2,221,321 63% Enterprise 287 Emergency Medical Services Capital 750,000 - 35,728 - - 714,272 5% 288 Emergency Medical Services Operating 6,855,366 383,042 1,255,887 2,339,965 220,910 5,378,570 22% 600 Consolidated Building Fund 4,205,401 238,839 1,284,660 1,164,207 574,389 2,346,352 44% 601 Parking Garages 1,806,712 104,364 408,158 386,517 109,753 1,288,801 29% 610 Solid Waste Operations 5,873,863 461,210 2,160,456 2,495,641 212,951 3,500,456 40% 611 Solid Waste Capital 752,811 168 318,816 502,298 - 433,995 42% 620 Water Works Operations 15,844,471 1,274,807 5,821,985 5,911,245 517,400 9,505,086 40% 622 Water Works Capital 838,893 - 86,334 3,600 33,406 719,153 14% 623 Water Works Bond Capital 53,085 - 53,743 447,568 - (658) 101 624 Water Works Customer Deposit 6,000 463 2,619 2,462 3,381 44% 625 Water Works Sinking 2,050,078 202 1,035 747 2,049,043 0% 626 Water Works Bond Reserve - - 7,374 - (7,374) 0% 629 Water Works Reserve Operations & Maintenance 8,500 695 3,840 3,478 4,661 45% 640 Sewer Repair Insurance 545,703 55,529 223,647 144,779 50,497 271,559 50% 641 Sewage Works Operations 38,196,974 6,207,878 15,761,774 15,720,067 1,402,108 21,033,092 45% 642 Sewage Works Capital 9,071,710 281,988 772,690 2,292,581 2,881,108 5,417,913 40% 643 Sewage Works Reserve Operations & Maint. 15,000 1,143 6,287 5,727 - 8,713 42% 649 Sewage Sinking 9,282,109 301,269 303,119 1,541,462 - 8,978,990 3% 659 Sewer Bond 2011 3,711,838 8,408 1,085,357 1,781,261 515,762 2,110,719 43% 661 Sewer Bond 2012 16,624,275 302,659 906,245 507,016 2,839,259 12,878,771 23% 670 Century Center 4,532,562 340,496 1,548,163 1,905,192 - 2,984,399 34% 671 Century Center Capital 308,156 50,000 116,156 - - 192,000 38% Enterprise Total 121,333,507 10,013,160 32,164,070 37,155,813 9,357,543 79,811,894 34% Internal Service 222 Central Services 8,300,242 537,157 3,246,998 3,120,895 1,756,930 3,296,314 60% 224 Central Services Capital 271,850 - - - 28,196 243,654 10% 226 Liability Insurance 3,056,791 176,737 1,178,398 1,023,755 61,128 1,817,265 41% 278 Take Home Vehicle Police 71,100 - - - - 71,100 0% 711 Self- Funded Employee Benefits 16,696,935 1,140,933 5,691,633 6,240,966 226,728 10,778,574 35% 713 Unemployment Compensation 226,796 10,788 42,416 70,057 11,000 173,380 24% Internal Service Total 28,623,714 1,865,615 10,159,445 10,455,673 2,083,982 16,380,287 43% Trust & Agency 701 Firefighters Pension 5,666,579 432,764 2,198,674 2,262,922 - 3,467,905 39% 702 Police Pension 6,832,235 523,172 2,678,491 2,916,283 4,153,744 39% 730 City Cemetery 20,000 - - - 20,000 0% Trust & Agency Total 12,518,814 955,936 4,877,165 5,179,205 - 7,641,649 39% City Funds Total J111k, 302,117,257 ,506,938 100,028,780 Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 47,710,597 271,305 6,555,668 2,953,257 9,618,075 31,536,854 34% 420 Tax Incremental Financing (TIF) - Downtown 4,537,169 - 4,088,473 1,763,976 - 448,696 90% 422 TIF - West Washington 760,900 - 30,294 319 3,366 727,240 4% 425 Redevelopment Retail & Leighton Plaza 154,716 6,950 52,831 53,791 - 101,885 34% 426 TIF - Central Medical Service Area 2,476,033 - 2,294,533 1,729,515 - 181,500 93% 429 River East Development Area (NE Dev TIF) 7,239,524 4,700 138,947 617 170,389 6,930,188 4% 430 TIF - Southside Development #1 2,842,535 10,969 572,082 302,866 727,319 1,543,134 46% 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,000 1,711,589 1,866,291 - 1,714,043 50% Tax Increment Financing Total 69,492,495 294,924 15,614,037 8,766,023 10,523,349 43,355,109 38% Redevelopment 433 Redevelopment General 6,000 - - 15,703 - 6,000 0 439 Certified Technology Park 5,000,000 96,682 502,001 - 2,262,337 2,235,662 55 619 Blackthorn Operations 1,671,706 227 181,484 448,070 - 1,490,222 11 Redevelopment Total 6,677,706 96,909 683,485 463,773 2,262,337 3,731,884 44% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 323 1,829 1,754 L 3,171 37% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY May 31, 2015 328 Redevelopment Bond - Palais Royale 6,000 539 3,056 2,931 2,944 51 432 TIF - Southside Development #3 691,380 - 559,274 354,606 132,111 81 Debt Service Total 702,380 862 564,159 359,291 138,226 80% Redevelopment Commission Controlled Funds To 81 9,589,087 12, 7,225,219 --M Grand Total 378,989,838 22,855,018 113,368,619 109,617,867 36,711,297 228,910,443 40% Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Month Ma Fund /Department Number 101 -0101 Date Updated 6/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 740,667 53,088 290,226 283,897 - 450,441 39% Local Income Taxes - - - - - - 0% Other Taxes - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - 50 440 - (50) 0% Other Income 600 50 50 249 - 550 8% Transfers In - - - - - - 0% Total Revenue 741,267 53,138 290,326 284,586 - 450,941 39% Expenditures Personnel 669,877 50,578 271,499 249,157 - 398,378 41% Supplies 12,413 942 5,033 9,487 119 7,261 42% Services 56,739 1,617 13,096 24,696 14 43,629 23% Debt Service 2,238 - 697 1,246 - 1,541 31% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 7417267 53,138 2907326 284,586 133 450,808 39% Net - - - - (133) 133 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 ChangesNariances Below: Expenditures are in line with budgeted expectations for 2015. 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 Month Ma Fund /Department Number 101 -0104 Date Updated 6/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 - - - (25,398) - - 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 35,855 204,324 207,938 - 282,409 42% Transfers In - - - - - - 0% Total Revenue 486,733 35,855 204,324 182,540 - 282,409 42% Expenditures Personnel 441,562 33,609 180,326 159,456 - 261,236 41% Supplies 6,125 166 1,518 12,396 - 4,607 25% Services 39,046 2,081 22,480 10,688 2,390 14,176 64% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 486,733 35,855 204,324 182,540 2,390 280,019 42% Net - - - - (2,390) 2,390 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 ChangesNariances Below: Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted in 2015. Form 3 Form 3 10 2015 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Month Ma Fund /Department Number 101 -0201 Date Updated 6/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 431,573 27,469 142,971 133,489 - 288,603 33% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,573 27,469 142,971 133,489 - 288,603 33% Expenditures Personnel 339,442 23,787 128,364 117,324 - 211,078 38% Supplies 7,740 24 760 3,280 1,000 5,980 23% Services 70,991 3,657 13,846 12,885 16,648 40,497 43% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 431,573 27,469 142,971 133,489 17,648 270,954 37% Net - - - - (17,648) 17,648 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 ChangesNariances 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 10 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name Common Council Month Ma Fund /Department Number 101 -0301 Date Updated 6/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 481,684 47,775 248,074 126,047 - 233,610 52% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 8,466 31 148 122 - 8,318 2% Other Income - - 200 - - (200) 0% Transfers In - - - - - - 0% Total Revenue 490,150 47,806 248,422 126,168 - 241,728 51% Expenditures Personnel 243,742 16,159 87,237 84,065 - 156,505 36% Supplies 4,706 58 664 234 830 3,212 32% Services 241,702 31,589 160,521 41,869 41,175 40,006 83% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 490,150 47,806 248,422 126,168 42,005 199,724 59% Net - - - - (42,005) 42,005 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 ChangesNariances 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 iVA 2015 City of South Bend Monthly Financial Report Fund /Department Name WNIT Contract Month Ma Fund /Department Number 101 -0302 Date Updated 6/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 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 43,000 - - - 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 43,000 43,000 43,000 - - - 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 43,000 43,000 43,000 - - - 100% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 will be paid 1 May. Explain Significant Spending on Capital Projects Below: Form 3 iVA Form 3 13 2015 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Month May Fund /Department Number 101 -0401 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,008,874 154,038 751,455 816,376 - 1,257,419 37% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 50 - 556 - - (506) 1112% Transfers In - - - - - - 0% Total Revenue 2,008,924 154,038 752,011 816,376 - 1,256,914 37% Expenditures Personnel 1,806,651 129,975 690,048 688,201 - 1,116,603 38% Supplies 28,109 2,081 13,798 13,812 4,733 9,578 66% Services 171,593 21,982 46,878 113,077 14,364 110,351 36% Debt Service 2,571 - 1,286 1,286 - 1,285 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,008,924 154,038 752,011 816,376 19,096 1,237,817 38% Net - - - - (19,096) 19,096 Cash Balance - - Staffing Full Time 22.00 19.00 Part -Time /Seasonal /Temporary - 1.00 Total 22.00 20.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Transferred Chief Technology Officer to COIT for 2015 budget and added new HR Generalist position. Overall spending appears consistant with expectations. Full time excludes 3 IT /Innovation employees who are paid from COIT. Explain Significant Spending on Capital Projects Below: None Form 3 13 Form 3 14 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Month Ma Fund /Department Number 101 -0404 Date Updated 6/9/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 23,290 126,831 45,750 - 43,301 75% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 917,000 51,617 285,994 363,104 - 631,006 31% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 165 2,683 4,040 - 3,317 45% Transfers In - - - - - - 0% Total Revenue 1,093,132 75,072 415,508 412,894 - 677,624 38% Expenditures Personnel 749,285 55,516 298,394 282,439 - 450,891 40% Supplies 33,542 1,938 8,145 8,674 8,859 16,538 51% Services 310,305 17,618 108,969 121,782 25,374 175,962 43% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,093,132 75,072 415,508 412,894 34,233 643,390 41% Net - - - - (34,233) 34,233 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 ChangesNariances 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 14 Form 3 W1 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Month Ma Fund /Department Number 101 -0405 Date Updated 6/9/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,473 10,129 77,411 86,244 - 88,633 38% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 315,820 22,305 95,289 88,951 - 220,531 30% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,000 1,685 6,151 4,344 - 12,849 32% Transfers In - - - - - - 0% Total Revenue 536,293 34,119 178,851 179,539 - 322,013 33% Expenditures Personnel 263,505 18,833 101,007 96,178 - 162,498 38% Supplies 23,897 283 3,090 2,795 3,968 16,840 30% Services 234,891 14,442 74,193 80,565 19,948 140,750 40% Debt Service - - - - - - 0% Capital 14,000 562 562 - 11,513 1,925 86% Transfers Out - - - - - - 0% Total Expenditures 536,293 34,119 178,851 179,539 35,429 322,013 40% Net - - - - (35,429) - 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 ChangesNariances Below: Explain Significant Spending on Capital Projects Below: AN Upgrades (screen, projector, computer). Curtain replacement project ($30,000.00) defer to 2016. Form 3 W1 Form 3 W" 2015 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Month Ma Fund /Department Number 101 -0501 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 965,599 73,429 362,430 418,779 - 603,169 38% 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,000 3 18,623 42 - 31,377 37% Transfers In - - - - - - 0% Total Revenue 1,018,599 73,432 381,053 420,401 - 637,546 37% Expenditures Personnel 955,213 68,503 361,030 402,837 - 594,183 38% Supplies 6,832 154 3,118 3,288 198 3,517 49% Services 55,254 4,458 16,270 13,641 10,327 28,657 48% Debt Service 1,300 318 635 635 637 28 98% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,018,599 73,432 381,053 420,401 11,161 626,385 39% Net - - - - (11,161) 11,161 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 May 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 W" Form 3 17 2015 City of South Bend Monthly Financial Report Fund /Department Name Engineering Month Ma Fund /Department Number 101 -0602 Date Updated 6/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 66,584 370,769 412,909 - 611,137 38% 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 1,104 1,632 18,596 - 75,395 2% Transfers In - - - - - - 0% Total Revenue 1,058,933 67,688 372,400 431,505 - 686,533 35% Expenditures Personnel 710,552 47,988 246,472 230,998 - 464,080 35% Supplies 29,262 971 17,777 12,053 5 11,480 61% Services 306,044 18,728 102,905 185,251 121,671 81,467 73% Debt Service 13,075 - 5,246 3,202 1,944 5,885 55% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,058,933 67,688 372,400 431,505 123,620 562,913 47% Net - - - - (123,620) 123,620 Cash Balance - - Staffing Full Time 7.90 7.65 Part -Time /Seasonal /Temporary 1.22 2.35 Total 9.12 10.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: $121,671 in encumbrance for Services include $60,000 for water system evaluation, $33,000 for a downtown sewer separation study, and $12,000 for design of Bendix Dr. from Lathrop to the 1 -80 bridge. Other income includes reimbursement from the River West (f /k /a Airport) TIF for 80% of the salary of a new engineer who is scheduled to begin near the end of May. Part -time includes 1.35 FTE's + 1 Intern. Explain Significant Spending on Capital Projects Below: Form 3 17 Form 3 18 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Department Month Ma Fund /Department Number 101 -0801 Date Updated 6/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 25,095,364 1,848,901 10,067,703 9,459,605 - 15,027,661 40% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - 24,316 - - 0% Charges for Services 200,000 - 25 200 - 199,975 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 7,500 - - - - 7,500 0% Other Income 330,200 20,918 79,558 101,042 - 250,642 24% Transfers In - - - - - - 0% Total Revenue 25,633,064 1,869,819 10,147,286 9,585,163 - 15,485,778 40% Expenditures Personnel 22,989,224 1,633,867 8,973,439 8,047,090 - 14,015,785 39% Supplies 419,279 35,266 185,684 384,526 119,098 114,497 73% Services 2,216,561 200,250 985,353 1,071,498 149,599 1,081,609 51% Debt Service 8,000 436 2,810 16,891 - 5,190 35% Capital - - - 65,158 - - 0% Transfers Out - - - - - - 0% Total Expenditures 25,633,064 1,869,819 10,147,286 9,585,163 268,697 15,217,081 41% Net - - - - (268,697) 268,697 Cash Balance - - Staffing Full Time 263.00 253.00 253.00 Part -Time /Seasonal /Temporary 60.00 29.00 29.00 Total 323.00 282.00 282.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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. Suppllies and Services expenditures show 73% and 51 % of the Budget as used year to date. This is due to the 2014 encumberances reflected as a use. These categories are expected to be on budget for the year. Explain Significant Spending on Capital Projects Below: Form 3 18 2015 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Month Ma Fund /Department Number 101 -0802 Date Updated 6/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 1,687,540 128,638 778,301 804,080 - 909,239 46% 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 128,638 778,301 804,080 - 909,239 46% Expenditures Personnel 143,972 8 135,151 799,970 - 8,821 94% Supplies - - - 60 - - 0% Services 1,543,568 128,630 643,150 4,050 900,410 8 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,687,540 128,638 778,301 804,080 900,410 8,829 99% Net - - - - (900,410) 900,410 Cash Balance - - Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 19 2015 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Month Ma Fund /Department Number 101 -0901 Date Updated 6/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 17,762,474 1,304,489 7,760,710 8,379,493 10,001,764 44% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 6,000 10,231 124,313 228,704 - (118,313) 2072% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 - 4,372 460 - 1,628 73% Transfers In - - - - 0% Total Revenue 17,774,474 1,314,720 7,889,395 8,608,657 - 9,885,079 44% Expenditures Personnel 15,737,086 1,202,394 7,305,734 7,772,516 117,365 8,313,987 47% Supplies 320,618 10,395 57,795 140,886 25,808 237,015 26% Services 1,216,770 101,931 525,867 695,255 87,264 603,639 50% Debt Service - - - - - 0% Capital - - - - - - 0% Transfers Out 500,000 - - - - 500,000 0% Total Expenditures 17,774,474 1,314,720 7,889,395 8,608,657 230,437 9,654,641 46% Net - - - - (230,437) 230,437 Cash Balance - - Staffing Full Time 170.00 166.00 166.00 Part -Time /Seasonal /Temporary - - - Total 170.00 166.00 166.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 Employee's and 4 civilian employee's costs are allocated to Fund 288 EMS Operations. We hold a lengthy recruitment process every 2 years and hire individuals in groups of 6 -10 as needed while that list is in effect. We also employ civilian administrative staff that handle payroll, purchasing and billing for our ambulance service. 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, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Form 3 20 Form 3 21 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Month Ma Fund /Department Number 101 -1008 Date Updated 6/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 373,179 27,284 159,545 135,335 - 213,634 43% 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 27,284 159,545 135,335 - 213,634 43% Expenditures Personnel 286,475 22,204 119,898 111,134 - 166,577 42% Supplies 2,010 285 573 818 400 1,037 48% Services 73,492 4,795 28,667 23,384 6,944 37,881 48% Debt Service - - - - - - 0% Capital 11,202 - 10,407 - - 795 93% Transfers Out - - - - - - 0% Total Expenditures 373,179 27,284 159,545 135,335 7,344 206,290 45% Net - - - - (7,344) 7,344 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 ChangesNariances Below: Expenditures higher in personnel than last year, as there were three pay payrolls in the month of January. 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 21 Form 3 RIVA 2015 City of South Bend Monthly Financial Report Fund /Department Name Rainy Day Month Ma Fund /Department Number 102 Date Updated 6/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 - - - - - - 0% Interest Earnings 34,680 2,689 20,220 14,558 - 14,460 58% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 34,680 2,689 20,220 14,558 - 14,460 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 34,680 2,689 20,220 14,558 - 14,460 Cash Balance 8,662,408 8,632,263 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 RIVA 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Levy Month Ma Fund /Department Number 103 Date Updated 6/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 - - - - - - 0% Interest Earnings - 1 5 - - (5) 0% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 5 - - (5) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 5 - - (5) Cash Balance 3,653 - Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: A small excess of property tax was received in December 2014. Explain Significant Spending on Capital Projects Below: N/A Form 3 23 Form 3 24 2015 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation Month Ma Fund /Department Number 201 Date Updated 6/17/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 7,340,000 - 7,340,000 0% Local Income Taxes - - 0% Other Taxes 626,039 - 626,039 0% Grants /Intergovernmental 884,836 73,736 368,681 303,912 - 516,155 42% Charges for Services 2,025,640 194,092 496,154 644,176 - 1,529,486 24% Interest Earnings 10,000 257 5,234 4,346 - 4,766 52% Bond Proceeds - - 0% Donations - - 0% Other Income 144,200 11,990 71,216 961 - 72,984 49% Transfers In - - 0% Total Revenue 11,030,715 280,074 941,286 953,395 - 10,089,429 9% Expenditures Personnel 7,105,699 511,686 2,572,795 2,712,211 3,738 4,529,166 36% Supplies 1,109,836 90,168 430,420 541,101 243,926 435,490 61% Services 2,443,703 160,407 1,251,183 1,302,524 77,465 1,115,055 54% Debt Service 309,257 1,269 97,874 116,775 - 211,383 32% Capital 5,000 - 0% Transfers Out 95,500 - - - - 95,500 0% Total Expenditures 11,063,995 763,531 4,352,272 4,677,611 325,129 6,386,594 42% Net (33,280) (483,457) (3,410,986) (3,724,217) (325,129) 3,702,835 Cash Balance 114,005 538,568 Staffing Full Time 90.00 87.00 87.00 Part-Time /Seasonal /Temporary na 99.00 99.00 Total 90.00 186.00 186.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund 201 accounts for the annual operation of the Parks and Recreation Department. There are six divisions within the department: Administration, Maintenance, Golf, Recreation, Greenhouse, and Graffiti. In 2014 the Potawatomi Zoo began operation by the Potawatomi Zoological Society. Part time staffing is individuals, not FTEs. Property tax and other tax revenues are received in June and December of the year. Explain Significant Spending on Capital Projects Below: Because of decreasing property tax revenues, there is no capital budget in fund 201. A $5.6 million bond has been approved and funding is expected to be received in the second quarter of 2015. Form 3 24 Form 3 `�7 2015 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month Ma Fund /Department Number 202 Date Updated 6/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 5,697,000 558,719 2,636,254 2,210,245 3,060,746 46% Grants /Intergovernmental - - 0% Charges for Services 265,000 85,348 143,437 144,839 121,563 54% Interest Earnings 7,000 1,122 9,093 5,215 (2,093) 130% Bond Proceeds - - 0% Donations - - 0% Other Income 9,300 20,697 23,578 11,269 (14,278) 254% Transfers In 3,703,000 838,250 1,676,500 1,483,291 2,026,500 45% Total Revenue 9,681,300 1,504,136 4,488,861 3,854,859 - 5,192,439 46% Expenditures Personnel 4,314,548 239,278 1,596,966 1,668,737 2,717,582 37% Supplies 2,631,854 29,230 866,831 730,106 55,344 1,709,680 35% Services 2,951,520 118,963 893,345 909,929 15,314 2,042,861 31% Debt Service 448,006 52,851 188,615 127,295 259,391 42% Capital 139,458 39,458 134,030 100,000 28% Transfers Out - - - - - - 0% Total Expenditures 10,485,386 440,322 3,585,214 3,570,097 70,658 6,829,514 35% Net (804,086) 1,063,814 903,648 284,762 (70,658) (1,637,076) Cash Balance 4,780,872 3,965,073 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 `�7 Form 3 ` ": Form 3 27 2015 City of South Bend Monthly Financial Report Fund /Department Name Studebaker - Oliver Reverting Grants Month May Fund /Department Number 209 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 640,000 14,798 54,562 - - 585,438 9% Charges for Services - - - - - - 0% Interest Earnings 4,000 342 2,545 1,830 - 1,455 64% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 644,000 15,140 57,107 1,830 - 586,893 9% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 630,000 14,798 34,562 - 532,858 62,580 90% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 630,000 14,798 34,562 - 532,858 62,580 90% Net 14,000 342 22,545 1,830 (532,858) 524,313 Cash Balance 1,109,010 1,085,217 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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: Form 3 27 Form 3 28 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Month Ma Fund /Department Number 210 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 3,600,000 - - - - 3,600,000 0% Charges for Services - - - - - - 0% Interest Earnings 13,544 93 747 4,240 - 12,797 6% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 59,966 - - 14,387 - 59,966 0% Transfers In - - - - - - 0% Total Revenue 3,673,510 93 747 18,627 - 3,672,763 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,622,400 - 12,200 - 10,200 1,600,000 1% Debt Service 72,012 - 18,003 18,003 - 54,009 25% Capital 2,000,000 400,000 400,000 - 1,196,339 403,661 80% Transfers Out - - - - - - 0% Total Expenditures 3,694,412 400,000 430,203 18,003 1,206,539 2,057,670 44% Net (20,902) (399,907) (429,456) 624 (1,206,539) 1,615,093 Cash Balance (100,023) 349,575 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 28 Form 3 29 2015 City of South Bend Monthly Financial Report Fund /Department Name Department of Community Investment _(D-C-1 Month Ma Fund /Department Number 211 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 416,787 - 1,951 10,680 - 414,836 0% Charges for Services - - - - - - 0% Interest Earnings 2,200 295 2,483 1,582 - (283) 113% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 247,500 8,480 119,947 123,253 - 127,553 48% Transfers In 1,967,638 491,910 983,819 844,480 - 983,819 50% Total Revenue 2,634,125 500,685 1,108,200 979,995 - 1,525,925 42% Expenditures Personnel 2,120,943 148,609 799,345 809,649 9,161 1,312,437 38% Supplies 35,753 1,134 15,341 9,367 4,811 15,601 56% Services 505,034 32,938 171,482 104,690 17,346 316,206 37% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,661,730 182,681 986,168 923,706 31,318 1,644,244 38% Net (27,605) 318,004 122,032 56,289 (31,318) (118,319) Cash Balance 1,196,249 963,602 Staffing Full Time 24.00 24.00 24.00 Part -Time /Seasonal /Temporary - - - Total 24.00 24.00 24.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 29 Form 3 30 2015 City of South Bend Monthly Financial Report Fund /Department Name Dept of Community Investment Grants Month Ma Fund /Department Number 212 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 3,850,000 227,709 699,849 722,341 - 3,150,151 18% Charges for Services - - - - - - 0% Interest Earnings 2,000 104 1,091 886 - 909 55% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 248,000 3,576 195,137 112,163 - 52,863 79% Transfers In - - - - - - 0% Total Revenue 4,100,000 231,389 896,077 835,390 - 3,203,923 22% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 6,547,968 284,129 1,215,173 872,400 2,138,052 3,194,743 51% Transfers Out - - - - - - 0% Total Expenditures 6,547,968 284,129 1,215,173 872,400 2,138,052 3,194,743 51% Net (2,447,968) (52,740) (319,096) (37,010) (2,138,052) 9,180 Cash Balance 471,243 552,875 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 on -going and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 30 Form 3 191 2015 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Month Ma Fund /Department Number 216 Date Updated 6/8/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 - 810 23,533 - 34,190 2% Charges for Services - - - - - - 0% Interest Earnings 300 59 436 268 - (136) 145% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - - - - 600 0% Transfers In - - - 0% Total Revenue 35,900 59 1,246 23,801 - 34,654 3% 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 - 59 1,246 23,801 - (1,246) Cash Balance 188,677 182,467 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 191 Form 3 19YA 2015 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month Ma Fund /Department Number 217 Date Updated 6/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 33 291 142 - 509 36% Bond Proceeds - - - - - - 0% Donations 223,000 162 2,955 21,113 - 220,045 1% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 223,800 195 3,246 21,255 - 220,554 1% Expenditures Personnel - - - - - - 0% Supplies 1,552 - - 2,786 1,552 0 100% Services 295,630 28,211 81,093 - - 214,537 27% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 297,182 28,211 81,093 2,786 1,552 214,537 28% Net (73,382) (28,016) (77,848) 18,468 (1,552) 6,017 Cash Balance 60,091 93,203 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 19YA 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Month Ma Fund /Department Number 218 Date Updated 6/8/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 137 - 987 1% Interest Earnings 25 4 28 20 - (3) 112% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,025 4 41 157 - 984 4% 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 4 41 157 - (16) Cash Balance 12,046 11,705 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 33 Form 3 34 2015 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education Month Ma Fund /Department Number 220 Date Updated 6/8/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 - - 49,119 - - (49,119) 0% Charges for Services 180,000 17,961 94,057 73,801 - 85,943 52% Interest Earnings 3,000 300 2,257 1,672 - 743 75% Bond Proceeds - - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income 26,000 39 7,798 11,506 - 18,202 30% Transfers In - - - - - 0% Total Revenue 211,000 18,300 153,231 86,979 - 57,769 73% Expenditures Personnel - - - - - - 0% Supplies 122,478 2,572 23,817 12,233 61,376 37,285 70% Services 190,000 26,738 102,588 43,611 - 87,412 54% Debt Service - - - - - - 0% Capital 50,000 - - 13,947 - 50,000 0% Transfers Out - - - - - - 0% Total Expenditures 362,478 29,310 126,405 69,791 61,376 174,697 52% Net (151,478) (11,010) 26,826 17,188 (61,376) (116,928) Cash Balance 988,108 998,414 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 34 Form 3 1917 2015 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Month Ma Fund /Department Number 227 Date Updated 6/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 20,000 1,378 12,676 13,311 - 7,324 63% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 30,000 750 29,000 - - 1,000 97% Transfers In - - - - - - 0% Total Revenue 50,000 2,128 41,676 13,311 - 8,324 83% Expenditures Personnel - - - - - - 0% Supplies 67,500 - - - 67,500 - 100% Services 3,280,635 381,938 1,816,395 195,665 253,416 1,210,824 63% Debt Service - - - - - - 0% Capital 1,889,108 174,053 438,022 147,727 1,451,086 1 100% Transfers Out - - - - - 0% Total Expenditures 5,237,243 555,991 2,254,417 343,392 1,772,002 1,210,824 77% Net (5,187,243) (553,863) (2,212,741) (330,081) (1,772,002) (1,202,500) Cash Balance 3,651,152 7,605,952 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Of the $3.28 million budgeted for Services, $236K 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. Explain Significant Spending on Capital Projects Below: $1.889 million has been budgeted in 2015 for the Smart Streets initiative. As of May, all Capital encumbrances are for the Lincolnway West Corridors project. Form 3 1917 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month Ma Fund /Department Number 244 Date Updated 6/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 - - - 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 - - - 96,032 - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 96,032 - - 0% Net 20 - 19 118,968 - 1 Cash Balance 33,671 118,968 Staffing Full Time 3.00 - - Part -Time /Seasonal /Temporary - - - Total 3.00 - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 Ki: Form 3 37 2015 City of South Bend Monthly Financial Report Fund /Department Name Public Safety WIT Month Ma Fund /Department Number 249 Date Updated 6/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 2,694,246 2,658,346 - 3,771,944 42% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 223 2,529 3,210 - 3,471 42% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 13 - - (13) 0% Transfers In - - - - - - 0% Total Revenue 6,472,190 539,072 2,696,788 2,661,555 - 3,775,402 42% Expenditures Personnel 7,246,551 516,948 2,818,828 3,007,307 - 4,427,723 39% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 7,246,551 516,948 2,818,828 3,007,307 - 4,427,723 39% Net (774,361) 22,124 (122,040) (345,752) - (652,321) Cash Balance 1,168,383 1,686,442 Staffing Full Time 80.00 Part -Time /Seasonal /Temporary - - Total 80.00 - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 37 2015 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month Ma Fund /Department Number 251 Date Updated 6/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,000,000 92,815 462,294 449,626 - 537,706 46% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,300 850 6,001 3,524 - (701) 113% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 588,000 5,644 20,375 33,801 - 567,625 3% Transfers In - - - - - - 0% Total Revenue 1,593,300 99,309 488,670 486,952 - 1,104,630 31% Expenditures Personnel - - - - - - 0% Supplies 380,229 - - - - 380,229 0% Services 157,500 - 11,000 - - 146,500 7% Debt Service - - - - - - 0% Capital 1,388,492 109,145 150,834 43,282 882,517 355,141 74% Transfers Out - - - - - - 0% Total Expenditures 1,926,221 109,145 161,834 43,282 882,517 881,870 54% Net (332,921) (9,835) 326,836 443,669 (882,517) 222,760 Cash Balance 2,771,283 2,385,044 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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. 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 $882.5K 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 Overpass, Form 3 38 Form 3 39 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Month Ma Fund /Department Number 252 Date Updated 6/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 - - - - - - 0% Interest Earnings - 0 0 2 - (0) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 0 0 2 - (0) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 0 0 2 - (0) Cash Balance 8 1,152 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 39 Form 3 40 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant Month Ma Fund /Department Number 258 Date Updated 6/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 187,000 5,000 6,667 5,000 - 180,333 4% Charges for Services - - - - - - 0% Interest Earnings 2,000 128 1,021 758 - 979 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 14,400 1,297 17,376 17,880 - (2,976) 121% Transfers In - - - - - - 0% Total Revenue 203,400 6,425 25,064 23,638 - 178,336 12% Expenditures Personnel 123,657 8,949 48,465 46,294 - 75,192 39% Supplies 2,800 - 168 293 1,632 1,000 64% Services 120,900 3,848 32,769 23,274 13,077 75,054 38% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 247,357 12,797 81,402 69,860 14,709 151,246 39% Net (43,957) (6,372) (56,338) (46,222) (14,709) 27,090 Cash Balance 473,914 421,322 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 ChangesNariances 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. Explain Significant Spending on Capital Projects Below: No capital projects have been budgeted for this year. Form 3 40 Form 3 Cy 2015 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Month Ma Fund /Department Number 271 Date Updated 6/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 - 2 12 24 - (12) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 2 12 24 - (12) 0% Expenditures Personnel - - - - - - 0% Supplies 4,000 - 2,098 9,092 1,098 804 80% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,000 - 2,098 9,092 1,098 804 80% Net (4,000) 2 (2,086) (9,068) (1,098) (816) Cash Balance 3,227 5,305 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 Cy 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month May Fund /Department Number 273 Date Updated 6/9/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 1,250 3,213 5,153 - 14,687 18% Interest Earnings 100 8 63 45 - 37 63% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 18,000 1,258 3,276 5,198 - 14,724 18% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 18,974 - 2,454 7,767 - 16,520 13% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 18,974 - 2,454 7,767 - 16,520 13% Net (974) 1,258 822 (2,570) - (1,796) Cash Balance 27,535 25,416 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 E, VA 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Month Ma Fund /Department Number 280 Date Updated 6/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 - 1 9 6 - (9) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 9 6 - (9) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 9 6 - (9) Cash Balance 3,837 3,824 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Explain Significant Spending on Capital Projects Below: Form 3 43 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Month Ma Fund /Department Number 281 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 8 64 46 - (64) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 8 64 46 - (64) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 8 64 46 - (64) Cash Balance 27,268 27,174 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 44 Form 3 45 2015 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Month Ma Fund /Department Number 289 Date Updated 6/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 10,000 - 13,787 - - (3,787) 138% Interest Earnings - 10 79 27 - (79) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 10 13,866 27 - (3,866) 139% 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 (21,530) 10 (7,676) 27 - (13,854) Cash Balance 31,953 16,235 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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. Received reimbursement for extended response to airplane crash. 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 45 Form 3 El i: Form 3 47 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Month Ma Fund /Department Number 292 Date Updated 6/8/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 ChangesNariances 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 47 Form 3 48 2015 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Month Ma Fund /Department Number 294 Date Updated 6/8/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,000 - 20,487 17,900 - (487) 102% Interest Earnings - 21 166 135 - (166) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In - - - - - - 0% Total Revenue 22,000 21 20,653 18,035 - 1,347 94% Expenditures Personnel - - - - - - 0% Supplies 1,750 120 777 - - 973 44% Services 22,000 357 24,016 11,012 - (2,016) 109% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 477 24,793 11,012 - (1,043) 104% Net (1,750) (456) (4,140) 7,023 - 2,390 Cash Balance 64,143 75,109 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 48 Form 3 49 2015 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Month Ma Fund /Department Number 295 Date Updated 6/8/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 - 20,965 - - 65,693 24% Charges for Services - - - - - - 0% Interest Earnings 350 29 223 191 - 127 64% Bond Proceeds - - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 38,000 591 15,090 4,150 - 22,910 40% Transfers In - - - - - - 0% Total Revenue 128,258 620 36,278 4,341 - 91,980 28% Expenditures Personnel - - - - - - 0% Supplies 45,735 479 25,719 654 10,245 9,771 79% Services 66,000 - 1,782 4,936 516 63,702 3% Debt Service - - - - - - 0% Capital 60,600 - - - - 60,600 0% Transfers Out - - - - - - 0% Total Expenditures 172,335 479 27,501 5,590 10,761 134,073 22% Net (44,077) 141 8,777 (1,249) (10,761) (42,093) Cash Balance 115,011 112,094 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 49 Form 3 50 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Month May Fund /Department Number 299 Date Updated 6/8/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 17,913 63,744 20,157 - 11,256 85% Charges for Services - - - - - - 0% Interest Earnings 1,000 91 415 412 - 585 42% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,000 - - - - 1,000 0% Transfers In - - - - - - 0% Total Revenue 77,000 18,004 64,159 20,569 - 12,841 83% Expenditures Personnel - - - - - - 0% Supplies 54,759 - 34,162 19,842 25,103 (4,506) 108% Services 104,201 623 15,942 25,234 5,575 82,684 21% Debt Service - - - - - - 0% Capital 90,000 5,602 6,220 - - 83,780 7% Transfers Out - - - - - - 0% Total Expenditures 248,960 6,225 56,324 45,076 30,678 161,958 35% Net (171,960) 11,779 7,835 (24,507) (30,678) (149,117) Cash Balance 353,376 360,652 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 50 2015 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax Month May Fund /Department Number 404 Date Updated 6/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 8,859,912 738,326 3,691,630 3,602,421 - 5,168,282 42% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 58,000 4,395 34,159 24,475 - 23,841 59% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 966,059 41,320 364,413 217,434 - 601,646 38% Transfers In - - - - - - 0% Total Revenue 9,883,971 784,041 4,090,202 3,844,331 - 5,793,769 41% Expenditures Personnel 427,077 25,702 128,321 - - 298,756 30% Supplies 1,384,804 64,682 357,707 513,451 21,796 1,005,301 27% Services 8,159,164 445,729 2,016,684 1,613,320 404,459 5,738,021 30% Debt Service 2,487,504 2,643 988,758 1,112,756 - 1,498,746 40% Capital 1,701,822 603 25,928 19,500 864,895 810,999 52% Transfers Out 1,500,000 375,000 750,000 550,000 - 750,000 50% Total Expenditures 15,660,371 914,359 4,267,398 3,809,028 1,291,150 10,101,823 35% Net (5,776,400) (130,317) (177,195) 35,303 (1,291,150) (4,308,055) Cash Balance 1 14,774,184 14,959,654 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 ChangesNariances 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 61 Form 3 N% 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax Month Ma Fund /Department Number 408 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 8,981,877 748,490 3,742,449 3,665,342 - 5,239,428 42% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 354,660 504,660 354,660 - - 100% Interest Earnings 40,000 3,070 23,184 17,440 - 16,816 58% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 82 11,948 - (82) 0% Transfers In - - - - - - 0% Total Revenue 9,526,537 1,106,220 4,270,375 4,049,390 - 5,256,162 45% Expenditures Personnel - - - 168,124 - - 0% Supplies - - - - - - 0% Services 1,799,736 78,912 670,307 615,823 342,661 786,768 56% Debt Service 1,340,100 - 438,568 962,550 - 901,533 33% Capital 4,000 - 3,200 150,000 800 - 100% Transfers Out 6,483,782 955,160 2,576,105 2,931,051 - 3,907,677 40% Total Expenditures 9,627,618 1,034,072 3,688,180 4,827,548 343,461 5,595,978 42% Net (101,081) 72,148 582,195 (778,159) (343,461) (339,816) Cash Balance 10,752,420 10,063,969 Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Encumbrances include $315k to DTSB for 2014 operations. In 2015, Code Enforecement personnel expense is fully paid out of Fund 600, therefore, no additional expenses will be incurred in 2015 related to Code in this fund. Transfers out relate to: Community Investment ($1,967,638), Streets ($1,853,000), Code Enforcement ($2,033,776) and Animal Care & Control ($629,368). Explain Significant Spending on Capital Projects Below: $275,000 has been budgeted for the Potawatomi Zoological Society. Form 3 N% Form 3 53 2015 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Month May Fund /Department Number 410 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 110 45 112 47 - (2) 102% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 528,576 - 241,849 - - 286,727 46% Transfers In - - - - - - 0% Total Revenue 528,686 45 241,961 47 - 286,725 46% 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 45 95,893 47 - (5,410) Cash Balance 123,558 27,634 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 53 Form 3 54 2015 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Month Ma Fund /Department Number 655 Date Updated 6/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 429,000 36,590 182,118 181,376 - 246,882 42% Interest Earnings 2,700 338 2,417 1,664 - 283 90% Bond Proceeds - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 36,928 184,536 183,039 - 247,164 43% Expenditures Personnel 64,081 12 1,452 1,432 62,629 2% Supplies 6,000 6,000 0% Services 36,058 2,430 11,916 12,109 24,142 33% Debt Service 72,219 36,109 36,109 36,110 50% Capital - - 0% Transfers Out 350,000 - 350,000 0% Total Expenditures 528,358 2,442 49,477 49,650 - 478,881 9% Net (96,658) 34,486 135,059 133,389 - (231,717) Cash Balance 1,112,376 1,072,058 Staffing Full Time - - Part -Time /Seasonal /Temporary 2.16 - - Total 2.16 - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fall ReLeaf scheduled for October 2015. Explain Significant Spending on Capital Projects Below: Form 3 54 Form 3 1.1.1 2015 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Month Ma Fund /Department Number 705 Date Updated 6/8/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 1 8 3 - 2 80% Bond Proceeds - - - - - - 0% Donations 1,990 - 500 1,000 - 1,490 25% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 1 508 1,003 - 1,492 25% 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 - 1 (462) 1,003 - 462 Cash Balance 2,857 2,317 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 1.1.1 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service Month Ma Fund /Department Number 313 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 1,177,620 - - - - 1,177,620 0% Local Income Taxes - - - - - - 0% Other Taxes 45,358 - - - - 45,358 0% Grants /Intergovernmental 51,078 4,256 21,282 35,699 - 29,796 42% Charges for Services - - - - - - 0% Interest Earnings - - 41 - - (41) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,274,056 4,256 21,323 35,699 - 1,252,733 2% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 1,266,820 - 636,000 634,500 - 630,820 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,266,820 - 636,000 634,500 - 630,820 50% Net 7,236 4,256 (614,677) (598,801) - 621,913 Cash Balance (540,554) 117,534 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 619, 2015 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month May Fund /Department Number 377 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 610,000 29,251 334,776 180,139 - 275,224 55% Charges for Services - - - - - - 0% Interest Earnings 1,100 135 1,062 1,112 - 38 97% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,661 - 29,523 34,608 - 31,138 49% Transfers In - - - - - - 0% Total Revenue 671,761 29,386 365,361 215,859 - 306,400 54% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 854,803 - 481,573 483,673 - 373,230 56% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 854,803 - 481,573 483,673 - 373,230 56% Net (183,042) 29,386 (116,212) (267,814) - (66,830) Cash Balance 479,880 574,243 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 57 Form 3 58 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month Ma Fund /Department Number 401 Date Updated 6/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 15,000 - - - - 15,000 0% Interest Earnings 100 13 95 45 - 5 95% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,100 13 95 45 - 15,005 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 15,100 13 95 45 - 15,005 Cash Balance 40,545 26,895 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 58 2015 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Month Ma Fund /Department Number 403 Date Updated 6/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 200 15 115 83 - 85 58% Bond Proceeds - - - - - - 0% Donations - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 200 15 115 83 - 85 58% 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) 15 115 83 - (48,915) Cash Balance 49,277 49,105 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 59 2015 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Month Ma Fund /Department Number 405 Date Updated 6/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 34,000 1,178 2,250 1,276 - 31,750 7% Interest Earnings 2,200 145 1,109 737 - 1,091 50% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 12,000 250 4,250 12,144 - 7,750 35% Transfers In 95,500 - - - - 95,500 0% Total Revenue 143,700 1,573 7,609 14,157 - 136,091 5% Expenditures Personnel - - - - - - 0% Supplies 67,273 19,410 21,583 42,504 18,473 27,217 60% Services 50,660 12 36 12,420 10,312 40,312 20% Debt Service - - - - - - 0% Capital 75,000 - - 95,000 - 75,000 0% Transfers Out - - - - - - 0% Total Expenditures 192,933 19,422 21,619 149,923 28,785 142,529 26% Net (49,233) (17,850) (14,010) (135,766) (28,785) (6,438) Cash Balance 507,154 437,125 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 60 Form 3 61 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development Month May Fund /Department Number 406 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 450,000 - - - - 450,000 0% Local Income Taxes - - - - - - 0% Other Taxes 90,191 4,349 21,746 19,455 - 68,445 24% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 133 1,190 1,157 - 1,310 48% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 542,691 4,482 22,936 20,611 - 519,755 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 542,691 135,726 304,922 304,922 - 237,769 56% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 542,691 135,726 304,922 304,922 - 237,769 56% Net - (131,244) (281,986) (284,310) - 281,986 Cash Balance 299,265 501,488 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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. No new leases were added in 2014 and old leases are being paid off. Explain Significant Spending on Capital Projects Below: Form 3 61 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement Month May Fund /Department Number 407 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 397,000 - - - - 397,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 21 348 84 - (198) 232% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In - - - - - - 0% Total Revenue 422,150 21 348 84 - 421,802 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 365,625 - 183,750 185,250 - 181,875 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 365,625 - 183,750 185,250 - 181,875 50% Net 56,525 21 (183,402) (185,166) - 239,927 Cash Balance 66,081 (8,443) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 62 2015 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction Month Ma Fund /Department Number 412 Date Updated 6/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 1,066 8,628 12,081 - 16,372 35% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 786,187 - 368,031 227,661 - 418,156 47% Transfers In - - - - - - 0% Total Revenue 811,187 1,066 376,659 239,742 - 434,528 46% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 3,096,061 116,706 800,073 380,429 1,905,913 390,074 87% Transfers Out - - - - - - 0% Total Expenditures 3,096,061 116,706 800,073 380,429 1,905,913 390,074 87% Net (2,284,874) (115,641) (423,414) (140,688) (1,905,913) 44,454 Cash Balance 3,218,248 7,003,210 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 31 May 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.9 million encumbered comprises $667,000 for the 2 -way conversion of Main and Michigan /St. Joseph streets from Chippewa to LaSalle (the former IN -933), $386,000 for the Marion St. roundabout, $140,000 for the Olive - Sample overpass, $104,000 for the Bartlett St. roundabout, and $84,000 for Lincolnway West /Western Ave. Corridor improvements. Form 3 63 Form 3 64 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Month May Fund /Department Number 416 Date Updated 6/9/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 8,253 30,569 46,106 - 69,431 31% Interest Earnings 1,500 160 1,209 792 - 292 81% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 101,500 8,413 31,778 46,898 - 69,723 31% Expenditures Personnel - - - - - - 0% Supplies 21,210 - 11,225 5,374 8,884 1,101 95% Services 49,038 - 14,733 1,765 12,901 21,405 56% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 70,248 - 25,958 7,139 21,784 22,506 68% Net 31,252 8,413 5,820 39,759 (21,784) 47,217 Cash Balance 521,240 496,569 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 64 2015 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Month Ma Fund /Department Number 434 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 650,000 - - - - 650,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 30 136 129 - (136) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 650,000 30 136 129 - 649,864 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 462,206 - - - - 462,206 0% Debt Service 187,794 - 3,897 20,975 - 183,897 2% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 650,000 - 3,897 20,975 - 646,103 1% Net - 30 (3,761) (20,846) - 3,761 Cash Balance 6,077 (11,309) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 65 Form 3 66 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Month Ma Fund /Department Number 450 Date Updated 6/9/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,115 4,632 2,784 - 11,368 29% Interest Earnings 150 21 151 94 - (1) 100% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,150 1,136 4,783 2,877 - 11,367 30% 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,136 4,783 2,877 - (4,783) Cash Balance 67,944 56,273 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 66 Form 3 67 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Month May Fund /Department Number 677 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 168 1,293 1,097 - 1,207 52% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 168 1,293 1,097 - 1,207 52% Expenditures Personnel - - - - - - 0% Supplies 15,000 - - 365 - 15,000 0% Services 173,824 3,276 26,740 40,888 - 147,084 15% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,824 3,276 26,740 41,253 - 162,084 14% Net (186,324) (3,108) (25,447) (40,156) - (160,877) Cash Balance 533,773 618,250 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 67 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Month May Fund /Department Number 287 Date Updated 6/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 - - 396,727 - (396,727) 0% Charges for Services - - - - - - 0% Interest Earnings - 112 332 - - (332) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 750,000 - - - - 750,000 0% Total Revenue 750,000 112 397,059 - - 352,941 53% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 750,000 - 35,728 - - 714,272 5% Transfers Out - - - - - - 0% Total Expenditures 750,000 - 35,728 - - 714,272 5% Net - 112 361,331 - - (361,331) Cash Balance 361,331 - 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 68 Form 3 69 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Operating Month Ma Fund /Department Number 288 Date Updated 6/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 5,141,065 433,206 1,908,459 1,164,299 - 3,232,606 37% Interest Earnings 18,000 1,050 7,042 8,841 - 10,958 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 302 1,162 1,085 - 15,838 7% Transfers In 500,000 - - - - 500,000 0% Total Revenue 5,676,065 434,559 1,916,663 1,174,225 - 3,759,402 34% Expenditures Personnel 4,840,253 327,651 801,433 - - 4,038,820 17% Supplies 292,000 36,817 134,882 36,560 55,303 101,815 65% Services 375,337 18,575 92,852 148,756 14,875 267,609 29% Debt Service 448,773 - 226,719 20,333 1,728 220,326 51% Capital 149,003 - - 2,134,315 149,003 - 100% Transfers Out 750,000 - - - - 750,000 0% Total Expenditures 6,855,366 383,042 1,255,887 2,339,965 220,910 5,378,570 22% Net (1,179,301) 51,516 660,776 (1,165,741) (220,910) (1,619,168) Cash Balance 3,609,022 4,411,341 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 ChangesNariances 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 69 Form 3 70 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund Month Ma Fund /Department Number 600 Date Updated 6/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,488,902 252,661 763,342 469,598 - 725,560 51% Interest Earnings 1,000 304 2,025 638 - (1,025) 202% Bond Proceeds - - - - - - 0% Donations - - 52 - - (52) 0% Other Income 1,067 466 6,513 1,192 - (5,446) 610% Transfers In 2,663,144 - 665,786 1,153,280 - 1,997,358 25% Total Revenue 4,154,113 253,431 1,437,718 1,624,707 - 2,716,395 35% Expenditures Personnel 2,454,138 167,270 914,869 753,918 2,160 1,537,109 37% Supplies 181,483 16,519 52,167 55,123 15,896 113,420 38% Services 1,538,733 54,887 309,566 348,659 555,579 673,588 56% Debt Service 31,047 163 8,057 6,506 754 22,236 28% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,205,401 238,839 1,284,660 1,164,207 574,389 2,346,352 44% Net (51,288) 14,592 153,058 460,501 (574,389) 370,043 Cash Balance 887,827 615,201 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 ChangesNariances 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 General 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 70 2015 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages Month Ma Fund /Department Number 601 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 973,926 90,594 375,086 367,124 - 598,840 39% Interest Earnings 4,000 331 2,485 1,570 - 1,515 62% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 130,800 6,980 32,084 98,283 - 98,716 25% Transfers In - - - - - - 0% Total Revenue 1,108,726 97,905 409,655 466,977 - 699,071 37% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,621,858 104,364 355,320 318,537 100,138 1,166,400 28% Debt Service - - - - - - 0% Capital 184,854 - 52,838 67,980 9,615 122,401 34% Transfers Out - - - - - - 0% Total Expenditures 1,806,712 104,364 408,158 386,517 109,753 1,288,801 29% Net (697,986) (6,459) 1,497 80,460 (109,753) (589,730) Cash Balance 1,075,125 964,647 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 71 Form 3 rP: 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations Month Ma Fund /Department Number 610 Date Updated 6/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 414,480 2,133,902 2,044,680 - 3,085,414 41% Interest Earnings 2,500 123 857 1,053 - 1,643 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 490,473 85,973 98,033 - 404,500 18% Transfers In - - - - - - 0% Total Revenue 5,712,289 414,603 2,220,732 2,143,766 - 3,491,557 39% Expenditures Personnel 1,731,390 128,019 651,683 678,516 1,250 1,078,457 38% Supplies 371,208 44,110 113,891 188,894 12,893 244,424 34% Services 2,991,595 284,232 1,095,832 1,178,315 198,808 1,696,955 43% Debt Service 26,859 4,850 15,050 11,809 56% Capital - - - - 0% Transfers Out 752,811 - 284,000 449,916 468,811 38% Total Expenditures 5,873,863 461,210 2,160,456 2,495,641 212,951 3,500,456 40% Net (161,574) (46,607) 60,276 (351,874) (212,951) (8,899) Cash Balance 424,261 436,597 Staffing Full Time 25.20 24.20 Part -Time /Seasonal /Temporary 8.00 2.00 Total 33.20 26.20 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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. A large encumbrance for landfill tipping fees is causing the percent of Services used year to date to appear high. Transfers out to Fund 611 for debt service payments are done on an as needed basis. Revenue continues to fall slightly below budgeted expectations. Explain Significant Spending on Capital Projects Below: Form 3 rP: 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Month Ma Fund /Department Number 611 Date Updated 6/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 200 17 52 120 - 148 26% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 752,811 - 284,000 449,916 - 468,811 38% Total Revenue 753,011 17 284,052 450,036 - 468,959 38% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 752,811 168 318,816 362,848 - 433,995 42% Capital - - - 139,450 - - 0% Transfers Out - - - - - - 0% Total Expenditures 752,811 168 318,816 502,298 - 433,995 42% Net 200 (150) (34,764) (52,262) - 34,964 Cash Balance 436 66,179 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 73 Form 3 74 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations Month Ma Fund /Department Number 620 Date Updated 6.14.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 14,638,403 1,105,261 5,333,669 5,460,811 - 9,304,734 36% Interest Earnings 29,000 1,671 10,766 5,461 - 18,234 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 93,580 9,170 14,602 57,336 - 78,978 16% Transfers In 19,500 1,360 14,867 6,687 - 4,633 76% Total Revenue 14,780,483 1,117,461 5,373,904 5,530,295 - 9,406,579 36% Expenditures Personnel 5,023,137 342,307 1,910,363 1,854,574 2,050 3,110,724 38% Supplies 1,516,896 232,704 549,893 630,575 173,140 793,863 48% Services 4,979,548 366,928 1,509,451 1,760,558 339,174 3,130,923 37% Debt Service 17,936 704 2,624 2,095 3,036 12,275 32% Capital - - - - - - 0% Transfers Out 4,306,954 332,164 1,849,653 1,663,443 - 2,457,301 43% Total Expenditures 15,844,471 1,274,807 5,821,985 5,911,245 517,400 9,505,086 40% Net (1,063,988) (157,346) (448,081) (380,950) (517,400) (98,507) Cash Balance 3,939,019 1 3,115,155 Staffing Full Time 70.20 68.20 Part -Time /Seasonal /Temporary 3.00 3.00 Total 73.20 71.20 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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. Water's year to date metered revenues have declined 4% in comparison to the same time period in 2014. 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 meter and repair part purchases. Explain Significant Spending on Capital Projects Below: Form 3 74 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Month Ma Fund /Department Number 622 Date Updated 6.14.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 946 7,242 5,961 - 2,758 72% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 946 7,242 5,961 - 2,758 72% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 3,600 - - 0% Debt Service - - - - - - 0% Capital 838,893 - 86,334 - 33,406 719,153 14% Transfers Out - - - - - - 0% Total Expenditures 838,893 - 86,334 3,600 33,406 719,153 14% Net (828,893) 946 (79,091) 2,361 (33,406) (716,396) Cash Balance 3,046,190 3,534,087 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 (2) $70,952 Encumb: Truck (1) $33,406 Form 3 75 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Month Ma Fund /Department Number 623 Date Updated 6.14.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 - 41 407 1,213 (407) 0% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 41 407 1,213 - (407) 0% Expenditures Personnel - - 0% Supplies 50,914 - 50,914 34,046 - (0) 100% Services 2,171 - 2,828 42,103 (657) 130% Debt Service - - - - - - 0% Capital - - - 371,419 - - 0% Transfers Out - - - - - 0% Total Expenditures 53,085 - 53,743 447,568 - (658) 101% Net (53,085) 41 (53,336) (446,355) - 251 Cash Balance 129,203 366,275 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The purpose of this fund is to segregate the use of bond proceeds that are applied to the acquisition, construction and installation of certain additions, extension and improvements. Revenue bonds were issued in June 2012 with an aggregate principal of $8,300,000. A 2015 budget was not established for this fund based on assumptions of bond proceeds being 100% depleted by December 31, 2014. Intended use of remaining cash will go towards the Pinhook Project's final construction pay application and a small final meter order. A Budget Transfer Form B will be submitted to appropriate a budget for projected final use of the proceeds. Explain Significant Spending on Capital Projects Below: Water Meters $50,914 Pinhook WT Effic Improv Proj(EngFees) $657 Boland Park PRV $2,171 Form 3 76 Form 3 77 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Month May Fund /Department Number 624 Date Updated 6.14.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 463 3,474 2,462 - 2,526 58% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 463 3,474 2,462 - 2,526 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - 0% Transfers Out 6,000 463 2,619 2,462 - 3,381 44% Total Expenditures 6,000 463 2,619 2,462 - 3,381 44% Net - - 855 - - (855) Cash Balance 1,493,630 1,466,825 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 77 Form 3 78 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Month Ma Fund /Department Number 625 Date Updated 6.14.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 202 1,037 747 - 3,963 21% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 2,045,078 170,275 851,375 854,050 - 1,193,703 42% Total Revenue 2,050,078 170,477 852,412 854,797 - 1,197,666 42% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 2,045,078 - - - - 2,045,078 0% Capital - - - - - 0% Transfers Out 5,000 202 1,035 747 - 3,965 21% Total Expenditures 2,050,078 202 1,035 747 - 2,049,043 0% Net - 170,275 851,378 854,050 - (851,378) Cash Balance 856,033 859,387 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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. Biannual installments are disbursed at the end of June and December. Explain Significant Spending on Capital Projects Below: Form 3 78 Form 3 79 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Month Ma Fund /Department Number 626 Date Updated 6.14.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 2,351 2,624 7,149 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - 0% Transfers In - - - 42,820 - - 0% Total Revenue 9,500 - 2,351 45,444 - 7,149 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - 7,374 - - (7,374) 0% Total Expenditures - - 7,374 - - (7,374) 0% Net 9,500 - (5,023) 45,444 - 14,523 Cash Balance 1,641,654 1,611,120 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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. A Budget Transfer Form B was submitted for the expenditure budget deficit. Interest earnings previously were not transferred out to Water's Operating Fund. Explain Significant Spending on Capital Projects Below: Form 3 79 Form 3 80 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Month May Fund /Department Number 629 Date Updated 6.14.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 695 5,043 3,478 - 3,457 59% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 154,249 - 150,228 53,507 - 4,021 97% Total Revenue 162,749 695 155,271 56,985 - 7,478 95% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 695 3,840 3,478 - 4,661 45% Total Expenditures 8,500 695 3,840 3,478 - 4,661 45% 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 ChangesNariances 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. Additional monies have been transferred in to comply with 2015's requirement. Explain Significant Spending on Capital Projects Below: Form 3 80 Form 3 81 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Month Ma Fund /Department Number 640 Date Updated 6/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 548,000 49,827 253,977 239,766 - 294,023 46% Interest Earnings 1,200 480 3,571 2,372 - (2,371) 298% Bond Proceeds - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 549,200 50,308 257,548 242,137 - 291,652 47% Expenditures Personnel 206,842 11,146 69,970 63,579 136,872 34% Supplies 28,603 1,000 8,427 3,495 748 19,428 32% Services 281,802 29,165 131,033 63,488 49,749 101,020 64% Debt Service 28,456 14,218 14,218 14,218 14,238 50% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 545,703 55,529 223,647 144,779 50,497 271,559 50% Net 3,497 (5,221) 33,900 97,358 (50,497) 20,094 Cash Balance 1,543,914 1,460,187 Staffing Full Time 2.20 1.85 - Part -Time /Seasonal /Temporary - - - Total 2.20 1.85 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 81 Form 3 82 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations Month Ma Fund /Department Number 641 Date Updated 6/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 35,209,467 2,965,179 14,269,240 13,566,115 - 20,940,227 41% Interest Earnings 22,000 3,199 24,149 9,326 - (2,149) 110% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 88,000 11,170 18,331 32,886 - 69,669 21% Transfers In 15,000 1,143 6,287 5,727 - 8,713 42% Total Revenue 35,334,467 2,980,691 14,318,008 13,614,054 - 21,016,459 41% Expenditures Personnel 7,402,560 463,622 2,793,406 2,859,339 - 4,609,154 38% Supplies 2,154,745 88,414 514,037 674,863 123,287 1,517,421 30% Services 13,178,782 850,235 4,139,189 4,016,817 1,278,821 7,760,773 41% Debt Service 585,187 32,070 191,375 164,490 - 393,812 33% Capital - - - - - - 0% Transfers Out 14,875,700 4,773,536 8,123,767 8,004,559 - 6,751,933 55% Total Expenditures 38,196,974 6,207,878 15,761,774 15,720,067 1,402,108 21,033,092 45% Net (2,862,507) (3,227,186) (1,443,766) (2,106,013) (1,402,108) (16,633) Cash Balance 7,201,303 5,052,748 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 ChangesNariances 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. Large encumbrances for services contribute to the apparent high percentage of budget used. Explain Significant Spending on Capital Projects Below: Capital spending for Sewage works is shown in Fund 642. Form 3 82 Form 3 83 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Month Ma Fund /Department Number 642 Date Updated 6/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 39,000 1,015 8,563 8,612 - 30,437 22% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 5,359,000 4,000,000 4,000,000 4,000,000 - 1,359,000 75% Total Revenue 5,398,000 4,001,015 4,008,563 4,008,612 - 1,389,437 74% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 36,043 7,556 24,667 40,306 11,375 0 100% Debt Service - - - - - - 0% Capital 9,035,667 274,432 748,022 2,252,275 2,869,733 5,417,912 40% Transfers Out - - - - - - 0% Total Expenditures 9,071,710 281,988 772,690 2,292,581 2,881,108 5,417,913 40% Net (3,673,710) 3,719,027 3,235,873 1,716,031 (2,881,108) (4,028,476) Cash Balance 6,987,595 5,760,597 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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, sewer slip lining and manhole rehab. Explain Significant Spending on Capital Projects Below: Year to Date totals spent include: Wastewater Treatment Plant Primary Clarifier rehab $716,116, Utility vehicle used at WWTP $13,131, Sewer Dept vehicle $43,443. Form 3 83 Form 3 84 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Month May Fund /Department Number 643 Date Updated 6/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 15,000 1,143 8,262 5,727 - 6,738 55% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 235,612 - 256,086 129,964 - (20,474) 109% Total Revenue 250,612 1,143 264,348 135,691 - (13,736) 105% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 1,143 6,287 5,727 - 8,713 42% Total Expenditures 15,000 1,143 6,287 5,727 - 8,713 42% Net 235,612 - 258,061 129,964 - (22,449) Cash Balance 3,678,649 3,422,564 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The sole 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 84 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Month Ma Fund /Department Number 647 Date Updated 6/5/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 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 2 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - 2 - - Cash Balance 0 1,143 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Bond, issued in 2007, is now fully spent. There is no 2015 budget. The $.14 cash balance needs to be removed so the fund can be fully closed. Explain Significant Spending on Capital Projects Below: Form 3 85 Form 3 86 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Month Ma Fund /Department Number 649 Date Updated 6/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 7,000 1,135 4,468 3,556 - 2,532 64% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,281,088 773,536 3,867,681 3,874,595 - 5,413,407 42% Total Revenue 9,288,088 774,671 3,872,150 3,878,151 - 5,415,938 42% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,500 750 2,600 2,100 - (100) 104% Debt Service 9,279,609 300,519 300,519 1,539,362 - 8,979,090 3% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,282,109 301,269 303,119 1,541,462 - 8,978,990 3% Net 5,979 473,402 3,569,030 2,336,689 Cash Balance 4,359,367 3,119,496 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 86 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Month May Fund /Department Number 653 Date Updated 6/5/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 ChangesNariances 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 87 Form 3 88 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Month Ma Fund /Department Number 658 Date Updated 6/5/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 4 - (0) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - 0 4 - (0) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - 0 4 - (0) Cash Balance 2 2,219 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This 2010 bond has been fully spent. There is no 2015 budget. The $2.05 cash balance needs to be removed so the fund can be closed. Explain Significant Spending on Capital Projects Below: Form 3 88 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 Month Ma Fund /Department Number 659 Date Updated 6/5/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 175 2,827 12,486 - 3,173 47% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 175 2,827 12,486 - 3,173 47% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 323,670 - 7,813 300 9,857 306,001 5% Debt Service - - - - - - 0% Capital 3,388,168 8,408 1,077,545 1,780,961 505,905 1,804,719 47% Transfers Out - - - - - - 0% Total Expenditures 3,711,838 8,408 1,085,357 1,781,261 515,762 2,110,719 43% Net (3,705,838) (8,233) (1,082,530) (1,768,775) (515,762) (2,107,547) Cash Balance 516,856 6,079,724 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 89 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Month Ma Fund /Department Number 661 Date Updated 6/5/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,000 5,061 39,033 30,396 - (19,033) 195% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 20,000 5,061 39,033 30,396 - (19,033) 195% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,000,000 - - - - 1,000,000 0% Debt Service - - - - - - 0% Capital 15,624,275 302,659 906,245 507,016 2,839,259 11,878,771 24% Transfers Out - - - - - - 0% Total Expenditures 16,624,275 302,659 906,245 507,016 2,839,259 12,878,771 23% Net (16,604,275) (297,598) (867,212) (476,620) (2,839,259) (12,897,804) Cash Balance 15,961,797 17,822,407 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 $106,158, Fairfax Sewer $70,022, East Bank Sewer Separation -Phase 5 $325,179, Sewer Sensory Control Network $88,223, Southwood sewer Separation $10,165, Wastewater Treatment Plant Grit/Screening Improvements $106,619, Secondary Clarifier Modifications $189,030, and misc other $2,070. Form 3 1*10" 2015 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund Month Ma Fund /Department Number 664 Date Updated 6/8/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 10 8 - (10) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 10 8 - (10) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 10 8 - (10) Cash Balance 4,491 4,475 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 Wi Form 3 1% 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Month Ma Fund /Department Number 670 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,313,436 - 656,725 656,725 - 656,711 50% Grants /Intergovernmental - - - - - - 0% Charges for Services 3,194,126 169,457 743,904 683,201 - 2,450,222 23% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - - 30,885 - 25,000 0% Transfers In - - - - - - 0% Total Revenue 4,532,562 169,457 1,400,629 1,370,811 - 3,131,933 31% Expenditures Personnel 2,505,817 171,918 801,268 846,748 - 1,704,549 32% Supplies 496,646 60,789 198,870 186,738 - 297,776 40% Services 1,286,148 107,789 548,025 533,405 - 738,123 43% Debt Service - - - - - - 0% Capital 243,951 - - 338,301 - 243,951 0% Transfers Out - - - - - - 0% Total Expenditures 4,532,562 340,496 1,548,163 1,905,192 - 2,984,399 34% Net - (171,039) (147,534) (534,381) - 147,534 Cash Balance 1,092,103 535,004 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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% 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Month Ma Fund /Department Number 671 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 74 164 145 - 336 33% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 74 164 145 - 336 33% Expenditures Personnel - - - - - - 0% Supplies 41,156 - 41,156 - - - 100% Services 192,000 - - - - 192,000 0% Debt Service - - - - - - 0% Capital 25,000 - 25,000 - - - 100% Transfers Out 50,000 50,000 50,000 - - - 100% Total Expenditures 308,156 50,000 116,156 - - 192,000 38% Net (307,656) (49,926) (115,992) 145 - (191,664) Cash Balance 1,302,671 1,757,843 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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!IN Form 3 1*2 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Energy Conservation Debt Svc Month Ma Fund /Department Number 672 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 50,000 50,000 50,000 - - - 100% Total Revenue 50,000 50,000 50,000 - - - 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 50,000 50,000 50,000 - - - Cash Balance 50,000 - Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 1*2 Form 3 1*11 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month Ma Fund /Department Number 222 Date Updated 6/8/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 609,058 3,251,469 3,159,845 - 4,817,688 40% Interest Earnings 3,400 383 2,981 1,917 - 419 88% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 48,540 9,786 42,091 100,281 - 6,449 87% Transfers In - - - - - - 0% Total Revenue 8,121,097 619,227 3,296,540 3,262,043 - 4,824,557 41% Expenditures Personnel 3,099,267 204,031 1,111,558 1,092,404 52 1,987,657 36% Supplies 167,428 (4,206) 42,530 43,723 33,498 91,400 45% Services 4,611,385 337,122 1,969,663 1,981,520 1,702,103 939,619 80% Debt Service 9,155 210 3,248 3,248 420 5,488 40% Capital 141,157 120,000 20,857 300 100% Transfers Out 271,850 - - - - 271,850 0% Total Expenditures 8,300,242 537,157 3,246,998 3,120,895 1,756,930 3,296,314 60% Net (179,145) 82,070 49,542 141,148 (1,756,930) 1,528,243 Cash Balance 1,619,156 1,638,790 Staffing Full Time 42.00 39.00 39.00 Part -Time /Seasonal /Temporary 2.00 1.00 1.00 Total 44.00 40.00 40.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 May we had 1,212 vehicle repairs. Average Fuel prices for May is $2.14 for Unleaded and $2.21 for Diesel. Budgeted amount per gallon is $3.45. In May, the Office of Sustainability supported green initiatives at the S131 50 Birthday Weekend, including water bottle refilling stations, recycling,food waste collection, and public education. The Office also finalized innovative energy efficiency financing for significant upgrades at the Century Center. 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,00 roll over from 2014 to 2015 for capital expenses to converting our garage so we can work on CNG vehicles. Form 3 1*11 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Capital Month May Fund /Department Number 224 Date Updated 6/8/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 ChangesNariances 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 1*I9: Form 3 IM 2015 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance Month Ma Fund /Department Number 226 Date Updated 6/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,222,727 99,293 506,882 1,188,397 - 715,845 41% Interest Earnings 20,500 1,649 12,881 8,615 - 7,619 63% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 - - 37,048 - 17,000 0% Transfers In - - - - - - 0% Total Revenue 1,260,227 100,942 519,763 1,234,060 - 740,464 41% Expenditures Personnel 314,491 15,107 97,618 75,208 - 216,873 31% Supplies 30,189 4,303 16,195 6,911 4,669 9,324 69% Services 2,712,111 157,327 1,064,584 941,636 56,459 1,591,068 41% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,056,791 176,737 1,178,398 1,023,755 61,128 1,817,265 41% Net (1,796,564) (75,795) (658,635) 210,305 (61,128) (1,076,801) Cash Balance 5,021,439 5,395,802 Staffing Full Time 3.00 2.00 Part -Time /Seasonal /Temporary - - Total 3.00 2.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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. Explain Significant Spending on Capital Projects Below: No capital expenditures are budgeted in 2015. Form 3 IM 2015 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Month Ma Fund /Department Number 278 Date Updated 6/8/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 61,100 4,590 25,640 25,930 - 35,460 42% Interest Earnings 2,000 172 1,241 797 - 759 62% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 61,100 4,590 25,640 25,823 - 35,460 42% Transfers In - - - - - - 0% Total Revenue 124,200 9,352 52,521 52,550 - 71,679 42% Expenditures Personnel - - - - - - 0% Supplies 61,100 - - - 61,100 0% Services 10,000 - - - - 10,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 71,100 - - - - 71,100 0% Net 53,100 9,352 52,521 52,550 - 579 Cash Balance 568,534 505,502 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 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 1*x1 2015 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits Month Ma Fund /Department Number 711 Date Updated 6/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 16,315,000 1,199,431 6,074,661 5,352,316 - 10,240,339 37% Interest Earnings 23,345 1,492 10,390 9,727 - 12,955 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,225 - 19,399 11,099 - (174) 101% Transfers In - - - - - - 0% Total Revenue 16,357,570 1,200,922 6,104,451 5,373,142 - 10,253,119 37% Expenditures Personnel 4,326 1 4 - - 4,322 0% Supplies 21,875 574 1,616 25,756 2,884 17,375 21% Services 844,520 69,585 340,770 281,340 188,720 315,029 63% Insurance 15,826,214 1,070,774 5,349,243 5,933,870 35,123 10,441,848 34% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 16,696,935 1,140,933 5,691,633 6,240,966 226,728 10,778,574 35% Net (339,365) 59,989 412,818 (867,824) (226,728) (525,455) Cash Balance 4,469,805 4,793,623 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 1*111 Form 3 `[1111 2015 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Month Ma Fund /Department Number 713 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 225,996 8,473 42,367 42,652 - 183,629 19% Interest Earnings 800 76 564 428 - 236 71% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 226,796 8,549 42,931 43,080 - 183,865 19% Expenditures Personnel 200,000 8,022 30,784 67,047 - 169,216 15% Supplies - - - - - - 0% Services 26,796 2,766 11,632 3,010 11,000 4,164 84% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 226,796 10,788 42,416 70,057 11,000 173,380 24% Net - (2,239) 515 (26,977) (11,000) 10,485 Cash Balance 241,686 233,053 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 `[1111 Form 3 `1121 2015 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension Month Ma Fund /Department Number 701 Date Updated 6/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,207,092 - - - - 5,207,092 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,500 - 872 711 - 3,628 19% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 3,743 - - (3,743) 0% Transfers In - - - - - - 0% Total Revenue 5,211,592 - 4,615 711 - 5,206,977 0% Expenditures Personnel 5,661,579 432,683 2,198,310 2,262,670 - 3,463,270 39% Supplies 200 - - - - 200 0% Services 4,800 81 365 252 - 4,435 8% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,666,579 432,764 2,198,674 2,262,922 - 3,467,905 39% Net (454,987) (432,764) (2,194,059) (2,262,211) - 1,739,072 Cash Balance (1,554,755) (1,324,111) Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 `1121 Form 3 `111W 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Pension Month Ma Fund /Department Number 702 Date Updated 6/8/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,350,000 - - - - 6,350,000 0% 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 - - - - 4,000 0% Transfers In - - - - - - 0% Total Revenue 6,360,000 - 1,546 1,632 - 6,358,454 0% Expenditures Personnel 6,827,035 523,076 2,678,200 2,916,065 - 4,148,835 39% Supplies 800 - - - - 800 0% Services 4,400 96 291 218 - 4,109 7% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,832,235 523,172 2,678,491 2,916,283 - 4,153,744 39% Net (472,235) (523,172) (2,676,945) (2,914,651) - 2,204,710 Cash Balance (1,566,172) (1,205,992) Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 2015, the payments are expected to be $3,175,000 by 1 July and again by 1 October, totaling $6,350,000. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Form 3 `111W 2015 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Month Ma Fund /Department Number 730 Date Updated 6/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 150 9 66 62 - 84 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 150 9 66 62 - 84 44% 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) 9 66 62 - (19,916) Cash Balance 28,444 36,996 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 103 2015 City of South Bend Monthly Financial Report Fund /Department Name River West Development Area Airport TIF Month Ma Fund /Department Number 324 1 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 16,433,274 - - - - 16,433,274 0% Local Income Taxes - - - - - - 0% Other Taxes 490,500 - 292,000 - - 198,500 60% Grants /Intergovernmental - - - - - - 0% Charges for Services 17,000 - 14,061 - - 2,939 83% Interest Earnings 99,596 12,200 86,623 39,369 - 12,973 87% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,937,236 24,019 1,596,631 - - 1,340,605 54% Transfers In 4,963,040 862 4,956,925 1,754 - 6,115 100% Total Revenue 24,940,646 37,081 6,946,240 41,123 - 17,994,406 28% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 7,727,779 220,962 1,310,891 1,515,647 1,646,435 4,770,453 38% Debt Service 6,475,484 - 3,553,271 1,391,721 - 2,922,213 55% Capital 33,507,334 50,343 1,691,506 45,889 7,971,640 23,844,188 29% Transfers Out - - - - - - 0% Total Expenditures 47,710,597 271,305 6,555,668 2,953,257 9,618,075 31,536,854 34% Net (22,769,951) (234,224) 390,572 (2,912,134) (9,618,075) (13,542,448) Cash Balance 31,771,584 22,107,996 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 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 Bartlett Roundabout, Ignition Park infrastructure, LaSalle Hotel, ND /GE Turbo Project, Nello and Studebaker Envionmental. Form 3 104 Form 3 11111 2015 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown Month Ma Fund /Department Number 420 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - 200,000 - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - 15,128 - - 0% Interest Earnings - - - 19,111 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 127,550 - - 0% Transfers In - - - 2,931 - - 0% Total Revenue - - - 364,720 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 217,630 - - 0% Debt Service - - - 1,531,010 - - 0% Capital 448,696 - - 15,336 - 448,696 0% Transfers Out 4,088,473 - 4,088,473 - - - 100% Total Expenditures 4,537,169 - 4,088,473 1,763,976 - 448,696 90% Net (4,537,169) - (4,088,473) (1,399,256) - (448,696) Cash Balance - 1,205,218 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: In 2015 SBCDA is eliminated and all funds will be 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 11111 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Month May Fund /Department Number 422 1 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 420,000 - - - - 420,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 364 2,719 1,014 - (719) 136% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 422,000 364 2,719 1,014 - 419,281 1% 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,900) 364 (27,575) 695 (3,366) (307,959) Cash Balance 1,168,174 613,657 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 `[IN Form 3 `[1yA 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Month Ma Fund /Department Number 425 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 51 292 151 - (292) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 189,123 8,926 71,291 62,936 - 117,832 38% Transfers In - - - - - - 0% Total Revenue 189,123 8,977 71,583 63,087 - 117,540 38% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 154,716 6,950 52,831 39,438 - 101,885 34% Debt Service - - - - - - 0% Capital - - - 14,353 - - 0% Transfers Out - - - - - - 0% Total Expenditures 154,716 6,950 52,831 53,791 - 101,885 34% Net 34,407 2,027 18,752 9,296 - 15,655 Cash Balance 191,278 142,363 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 `[1yA Form 3 `[11:3 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Month Ma Fund /Department Number 426 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - 5,091 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 5,091 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,613 - - 1,543,685 - 3,613 0% Debt Service - - - - - - 0% Capital - - - 185,830 - - 0% Transfers Out 2,472,420 - 2,294,533 - 177,887 93% Total Expenditures 2,476,033 - 2,294,533 1,729,515 - 181,500 93% Net (2,476,033) - (2,294,533) (1,724,424) - (181,500) Cash Balance - 1,507,989 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 `[11:3 Form 3 `[IBS] 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Development Area NE Dev TIF Month Ma Fund /Department Number 429 1 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,342,330 - - - - 2,342,330 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 37,000 1,830 12,401 5,045 - 24,599 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,357 - 19,357 - - - 100% Transfers In 1,430,966 - 1,430,965 - - 1 100% Total Revenue 3,829,653 1,830 1,462,723 5,045 - 2,366,930 38% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 126,044 4,700 56,081 617 60,260 9,703 92% Debt Service - - - - - - 0% Capital 7,113,480 - 82,866 - 110,129 6,920,485 3% Transfers Out - - - - - - 0% Total Expenditures 7,239,524 4,700 138,947 617 170,389 6,930,188 4% Net (3,409,871) (2,870) 1,323,776 4,428 (170,389) (4,563,258) Cash Balance 5,880,256 3,013,219 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Due to changes in boundary, this area now includes a portion of South Bend Central Development Area (Fund 420). Explain Significant Spending on Capital Projects Below: Projects committed to in 2015 include: 5 Points Utility Study, Hill Street Improvements and the NW Corner of Hill & Colfax. Form 3 `[IBS] 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 Month Ma Fund /Department Number 430 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,400,000 - - - - 2,400,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10,000 1,371 10,674 5,580 - (674) 107% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,410,000 1,371 10,674 5,580 - 2,399,326 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 580,022 10,969 128,599 124,097 520,394 (68,971) 112% Debt Service - - - - - - 0% Capital 2,262,513 - 443,483 178,769 206,925 1,612,105 29% Transfers Out - - - - - - 0% Total Expenditures 2,842,535 10,969 572,082 302,866 727,319 1,543,134 46% Net (432,535) (9,598) (561,408) (297,286) (727,319) 856,192 Cash Balance 4,395,883 3,142,362 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 lull 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Month Ma Fund /Department Number 435 1 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 320,000 - - - - 320,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 750 16 278 455 - 472 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 320,750 16 278 455 - 320,472 0% 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) 16 (169,342) (94,936) (4,200) 148,903 Cash Balance 52,088 199,664 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 "`i Form 3 ISN 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Residential NE Res TIF Month Ma Fund /Department Number 436 1 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,599,000 - - - - 2,599,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 - 1,571 2,146 - 3,429 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 211,000 - - - - 211,000 0% Transfers In - - - - - - 0% Total Revenue 2,815,000 - 1,571 2,146 - 2,813,429 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 3,425,632 1,000 1,711,589 1,651,718 - 1,714,043 50% Capital - - - 214,573 - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,425,632 1,000 1,711,589 1,866,291 - 1,714,043 50% Net (610,632) (1,000) (1,710,018) (1,864,145) - 1,099,386 Cash Balance (4,515) 689,934 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 ISN 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Month May Fund /Department Number 433 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 252 3 24 33 - 228 10% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 252 3 24 33 - 228 10% 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) 3 24 (15,670) - (5,772) Cash Balance 10,114 10,079 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 1§93 Form 3 ISO 2015 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Month Ma Fund /Department Number 439 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,404 1,558 11,742 6,221 - (7,338) 267% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 4,404 1,558 11,742 6,221 - (7,338) 267% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - (319) - - - - 0% Debt Service - - - - - - 0% Capital 5,000,000 97,001 502,001 - 2,262,337 2,235,662 55% Transfers Out - - - - - - 0% Total Expenditures 5,000,000 96,682 502,001 - 2,262,337 2,235,662 55% Net (4,995,596) (95,124) (490,259) 6,221 (2,262,337) (2,243,000) Cash Balance 4,530,302 3,688,817 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Capital funds are to be expended in Ignition Park and Innovation Park. Form 3 ISO Form 3 ISM 2015 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Month May Fund /Department Number 454 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,500 117 883 636 - 617 59% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 117 883 636 - 617 59% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 117 883 636 Cash Balance 378,324 377,007 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 ISM Form 3 `rill 2015 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations Month Ma Fund /Department Number 619 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,696,879 59 119,297 543,979 - 1,577,582 7% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,696,879 59 119,297 543,979 - 1,577,582 7% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,661,128 227 181,484 448,070 - 1,479,644 11% Debt Service - - - - - - 0% Capital 10,578 - - - - 10,578 0% Transfers Out - - - - - - 0% Total Expenditures 1,671,706 227 181,484 448,070 - 1,490,222 11% Net 25,173 (168) (62,187) 95,909 - 87,360 Cash Balance 19,744 193,496 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 `rill 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Month May Fund /Department Number 315 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 323 2,429 1,754 - 2,571 49% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 323 2,429 1,754 - 2,571 49% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 323 1,829 1,754 - 3,171 37% Total Expenditures 5,000 323 1,829 1,754 - 3,171 37% Net - - 600 - - (600) Cash Balance 1,038,904 1,038,904 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 `SVA 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Month Ma Fund /Department Number 317 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,800 157 1,181 851 - 619 66% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,800 157 1,181 851 - 619 66% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,800 157 1,181 851 - 619 Cash Balance 506,084 504,323 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 `sM 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Month May Fund /Department Number 328 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 539 4,058 2,931 - 1,942 68% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 539 4,058 2,931 - 1,942 68% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 539 3,056 2,931 - 2,944 51% Total Expenditures 6,000 539 3,056 2,931 - 2,944 51% Net - - 1,002 - - (1,002) Cash Balance 1,735,840 1,735,840 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 ISM Form 3 IP411 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Month Ma Fund /Department Number 432 Date Updated 6/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 25,000 1,675 13,239 10,266 - 11,761 53% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 1,675 13,239 10,266 - 11,761 53% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 203,000 - 201,724 656 - 1,276 99% Debt Service 488,380 - 357,545 353,950 - 130,835 73% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 691,380 - 559,269 354,606 - 132,111 81% Net (666,380) 1,675 (546,030) (344,340) - (120,350) Cash Balance 5,956,825 6,624,347 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to payoff 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 payoff the bond at that time along with the prepayment penalty. Explain Significant Spending on Capital Projects Below: Form 3 IP411