The URL can be used to link to this page

Home My WebLink About06-2015 Departmental Financial ReportPeriod Ending: June 30, 2015 Issued By: Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents Mayor Pete Buttigieg 1 Narrative 2 Summaries 7 General Fund 21 Special Revenue Funds 55 Debt Service /Capital Project Funds 67 Enterprise Funds 94 Internal Service Funds 100 Trust Funds 103 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Deputy Chief of Staff Brian Pawlowski South Bend Common Council Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Financial Specialist Senior Cecil Eastman Department Heads Fiscal Officers June 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 30 days after the end of the reporting period. The Monthly Departmental Financial Report supplements —but does not replace —other financial reports that the City prepares such as the Monthly Financial Report, Controller's Cash Report, the Department of Local Government Finance's Annual Financial Report (AFR), or the Comprehensive Annual Financial Report (CAFR). Summary Trends & Observations As of June 30, 2015, total revenue for the year was $143,297,202, 50% of estimated revenue. As of June 30, 2014 total revenue received was $131,730,942 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 31 May. Local taxes are received on a monthly basis. In June the City received the first of its two annual property tax payments which totaled $39.7 million, 57% of the budgeted amount. Given that the first payment is usually around 53% of the budgeted amount, the City anticipates overall general property tax receipts to exceed this year's budget projection. On March 4, 2015 the City closed on its sale of Blackthorn Golf Course to a private company and received $1,472,130 in proceeds at that time. This amount represented the City's portion of the $1.655 million sale price. The golf course had realized $119,238 in revenue by the time of its sale, 7% of its annual budget. As of June 30, 2015, total expenditures were $134,228,785 and outstanding encumbrances were $39,960,530, a total of $174,189,315 which represents 46% 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 35% of the amended expenditure budget at the end of the period. Total expenditures were $127,261,195 as of June 30, 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 June 30, 2015 City Funds General Fund 52,8229478 23,228,972 28,512,812 289313,606 1,569,841 54% Special Revenue 102 Rainy Day 34,680 9,170 29,390 16,649 5,290 85% 103 Excess Levy - 4 9 - (9) 0% 201 Parks & Recreation 11,030,715 4,806,322 5,747,608 5,630,929 5,283,107 52% 202 Motor Vehicle Highway 9,701,800 316,657 4,805,519 4,466,109 4,896,281 50% 203 Recreation Nonreverting 1,578,935 82,878 513,230 512,679 1,065,705 33% 209 Studebaker - Oliver Reverting Grants 644,000 16,756 73,862 2,093 570,138 11% 210 Economic Development State Grants 3,673,510 36,192 36,939 18,712 3,636,571 1% 211 Department of Community Investment (DCI) 2,634,425 38,606 1,146,805 1,017,940 1,487,620 44% 212 Dept of Community Investment Grants 5,890,000 237,649 1,133,725 1,055,589 4,756,275 19% 216 Police State Seizures 36,050 200 1,445 23,841 34,605 4% 217 Gift, Donation, Bequest 398,800 174 3,420 21,278 395,380 1% 218 Police Curfew Violations 1,025 38 78 285 947 8% 220 Law Enforcement Continuing Education 270,000 17,495 170,726 105,611 99,274 63% 227 Loss Recovery 50,000 5,168 46,844 15,160 3,156 94% 244 Emergency Phone System 20 - 19 215,000 1 97% 249 Public Safety LOIT 6,472,240 539,985 3,236,774 3,193,609 3,235,466 50% 251 Local Roads & Streets 1,776,300 97,010 585,680 578,454 1,190,620 33% 252 Excess Welfare Distribution - 0 0 2 (0) 0% 258 Human Rights Federal Grant 209,950 699 25,763 23,786 184,187 12% 271 Eastrace Waterway 50 3 16 27 34 32% 273 Morris PAC / Palais Royale Marketing 18,000 428 3,704 6,316 14,296 21% 280 Police Block Grants - 4 13 7 (13) 0% 281 Economic Develop. Commission - Revenue Bonds 300 29 93 52 207 31% 289 HAZMAT 14,100 34 13,900 31 200 99% 291 Indiana River Rescue 45,350 694 22,528 34,797 22,822 50% 292 Police Grants 90,000 - 56,946 66,716 33,054 63% 294 Regional Police Academy 22,700 68 20,721 18,054 1,979 91% 295 COPS MORE Grant 150,258 832 37,110 5,714 113,148 25% 299 Police Federal Drug Enforcement 77,000 98 64,257 24,906 12,743 83% 404 County Option Income Tax 9,883,971 802,366 4,892,568 4,611,836 4,991,403 50% 408 Economic Development Income Tax 9,526,637 759,510 5,029,885 4,784,794 4,496,752 53% 410 Urban Development Action Grant 528,686 131 242,092 53 286,594 46% 655 Project Releaf 431,700 37,776 222,312 219,748 209,388 51% 705 Police K -9 Unit 2,000 1,003 1,511 1,004 489 76% Special Revenue Total 65,193,202 7,807,979 28,165,493 26,671,782 37,027,709 43% City Debt Service 313 Football Hall of Fame Debt Service 1,274,106 542,441 563,765 337,306 710,341 44% City Debt Service Total 1,274,106 542,441 563,765 337,306 710,341 44% Capital Project 377 Professional Sports Development 809,511 43,242 408,603 337,523 400,908 50% 401 Coveleski Stadium Capital 15,100 43 138 52 14,962 1% 403 Zoo Endowment 200 52 167 95 33 84% 405 Park Nonreverting Capital 143,700 1,269 8,878 14,897 134,822 6% 406 Cumulative Capital Development 542,691 260,870 283,806 279,683 258,885 52% 407 Cumulative Capital Improvement 422,350 117,722 118,070 123,637 304,280 28% 412 Major Moves Construction 811,187 3,473 380,132 241,449 431,055 47% 416 Morris Performing Arts Center Capital 101,500 3,069 34,847 48,515 66,653 34% 434 Community Revitalization Enhancement District 150 32 168 154 (18) 112% 450 Palais Royale Historic Preservation 16,150 663 5,446 3,732 10,704 34% 677 Football Hall of Fame Capital 2,500 568 1,860 1,247 640 74% Capital Project Total 2,865,039 431,005 1,242,116 1,050,984 1,622,923 43% Enterprise 287 Emergency Medical Services Capital 1,150,350 383 397,442 - 752,908 35% 288 Emergency Medical Services Operating 5,679,065 508,441 2,425,107 1,479,279 3,253,958 43% 600 Consolidated Building Fund 4,209,213 186,643 1,624,361 1,820,701 2,584,852 39% 601 Parking Garages 1,045,125 91,122 500,777 563,471 544,348 48% 610 Solid Waste Operations 5,712,289 416,858 2,637,589 2,571,924 3,074,700 46% City of South Bend Monthly Department Financial Report REVENUE SUMMARY June 30, 2015 620 Water Works Operations 14,780,483 1,372,068 6,745,972 6,939,618 8,034,511 46% 622 Water Works Capital 10,000 3,225 10,467 6,817 (467) 105% 623 Water Works Bond Capital 450 137 544 1,308 (94) 121% 624 Water Works Customer Deposit 6,000 1,582 5,056 2,817 944 84% 625 Water Works Sinking 2,050,078 171,158 1,023,571 1,025,804 1,026,507 50% 626 Water Works Bond Reserve 9,500 - 2,351 54,391 7,149 25% 629 Water Works Reserve Operations & Maintenance 162,749 2,367 157,637 57,490 5,112 97% 640 Sewer Repair Insurance 554,800 51,875 309,423 292,284 245,377 56% 641 Sewage Works Operations 35,338,567 3,001,884 17,319,892 16,458,469 18,018,675 49% 642 Sewage Works Capital 5,398,000 6,750 4,015,313 4,010,028 1,382,687 74% 643 Sewage Works Reserve Operations & Maint. 271,612 3,895 268,243 136,520 3,369 99% 647 Sewer Bond 2007 - - - 3 - 0% 649 Sewage Sinking 9,288,088 778,095 4,650,245 4,654,102 4,637,843 50% 658 Sewer Bond 2010 - - 0 4 (0) 0% 659 Sewer Bond 2011 6,000 550 3,378 14,021 2,622 56% 661 Sewer Bond 2012 40,000 17,033 56,066 34,713 (16,066) 140% 664 2013A Cost of Issuance Fund 50 5 15 9 35 30% 670 Century Center 3,819,251 268,954 1,669,583 1,534,885 2,149,668 44% 671 Century Center Capital 500 106 270 145 230 54% 672 Century Center Energy Conservation Debt Svc 50,000 7 50,007 - (7) 100% Enterprise Total 90,335,181 6,929,138 44,203,361 42,108,849 46,131,820 49% Internal Service 6,000 1,838 5,896 3,351 104 98% 222 Central Services 8,151,184 584,295 3,880,836 3,735,881 4,270,348 48% 224 Central Services Capital 271,850 - - - 271,850 0% 226 Liability Insurance 1,260,227 112,231 631,994 1,484,260 628,233 50% 278 Take Home Vehicle Police 124,200 9,718 62,239 62,071 61,961 50% 711 Self- Funded Employee Benefits 16,357,770 1,200,207 7,304,658 6,447,480 9,053,112 45% 713 Unemployment Compensation 113,796 8,731 51,662 51,668 62,134 45% Internal Service Total 26,279,027 1,915,182 11,931,388 11,781,360 14,347,639 45% Trust & Agency 701 Firefighters Pension 5,044,525 2,518,013 2,522,628 2,565,260 2,521,897 50% 702 Police Pension 6,385,359 3,187,679 3,189,225 3,057,565 3,196,134 50% 730 City Cemetery 150 30 97 71 53 64% Trust & Agency Total 11,4309034 5,7059722 5,7119950 5,622,896 5,718,084 50% 250,199,067 46,560,439 120,3303884 115,886,782 107,128,357 48°/q Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 24,944,246 9,550,307 16,496,547 7,669,058 8,447,699 66% 420 Tax Incremental Financing (TIF) - Downtown - - - 2,880,622 - 0% 422 TIF - West Washington 422,800 197,103 199,822 305,315 222,978 47% 425 Redevelopment Retail & Leighton Plaza 189,423 15,860 87,443 80,003 101,980 46% 426 TIF - Central Medical Service Area - - - 465,120 - 0% 429 River East Development Area (NE Dev TIF) 3,829,653 1,397,241 2,859,964 813,958 969,689 75% 430 TIF - Southside Development #1 2,410,750 1,303,629 1,314,303 1,275,289 1,096,447 55% 435 TIF - Douglas Road 320,750 163,999 164,277 161,451 156,473 51% 436 River East Residential (NE Res TIF) 2,815,000 1,663,572 1,665,143 1,384,812 1,149,857 59% Tax Increment Financing Total 34,932,622 14,291,711 22,787,499 15,035,628 12,145,123 65% Redevelopment 433 Redevelopment General 252 11 34 36 218 13% 439 Certified Technology Park 11,904 4,878 16,621 7,115 (4,717) 140% 454 Airport Urban Enterprise Zone 1,500 401 1,284 727 216 86% 619 Blackthorn Operations 119,799 - 119,297 773,413 502 100% Redevelopment Total 133,455 5,290 137,236 781,291 (3,781) 103% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 1,100 3,529 2,006 1,471 71% 317 Coveleski Debt Service Reserve 1,800 536 1,717 973 83 95% 328 Redevelopment Bond - Palais Royale 6,000 1,838 5,896 3,351 104 98% 432 TIF - Southside Development #3 25,000 17,202 30,441 20,910 (5,441) 122% 3 Fund �,? Debt Service Total City of South Bend Monthly Department Financial Report REVENUE SUMMARY June 30, 2015 37,800 20,676 41,583 27,240 (3,783) 110% Redevelopment Commission Controlled Funds Total 35,103,877 14,317,677 22,966,318 15,844,159' 12,137,559 65 %I Grand Total 285,302,944 60,878,116 143,297,202 131,730,942 119,265,916 50% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY June 30, 2015 City Funds General Fund 101 -0101 Mayor's Office 741,267 57,124 347,451 336,038 133 393,683 47% 101 -0104 311 Call Center 486,733 35,676 240,000 214,950 1,290 245,443 50% 101 -0201 City Clerk 431,573 28,359 171,331 156,419 17,648 242,594 44% 101 -0301 Common Council 490,150 24,460 272,882 142,939 45,092 172,176 65% 101 -0302 WNIT Contract 43,000 - 43,000 - - - 100% 101 -0401 Administration & Finance 2,008,924 136,652 888,663 972,486 29,122 1,091,139 46% 101 -0404 Morris Performing Arts Center 1,093,132 81,843 497,351 491,710 51,341 544,440 50% 101 -0405 Palais Royale 536,293 37,926 216,778 212,084 51,428 268,087 50% 101 -0501 Legal Department 1,018,599 71,133 452,186 493,835 10,291 556,122 45% 101 -0602 Engineering 1,058,933 70,000 442,400 510,289 117,611 498,922 53% 101 -0801 Police Department 25,633,064 1,977,962 12,125,248 11,416,576 185,021 13,322,795 48% 101 -0802 Communications Center 1,687,540 128,638 906,939 966,702 771,780 8,821 99% 101 -0901 Fire Department 17,774,474 1,472,585 9,361,980 10,385,269 212,842 8,199,652 54% 101 -0905 Fire LOT 2013 - (411) - - - - 0% 101 -1008 Human Rights 373,179 23,670 183,215 160,807 7,957 182,007 51 101 -1201 Code 2013 2,270 - (710) 851 2,269 711 69% 101 -1205 Unsafe Building 2013 - - - 750 - - 0% 101 -1207 Animal Control 2013 - - - 300 - - 0% General Fund Total 53,379,131 4,145,615 26,148,714 26,462,002 1,503,824 25,726,593 52% Special Revenue 201 Parks & Recreation 11,063,995 1,225,483 5,577,755 5,954,147 261,326 5,224,915 53% 202 Motor Vehicle Highway 10,485,386 440,042 4,025,256 4,071,472 568,373 5,891,757 44% 203 Recreation Nonreverting 1,549,469 111,498 455,667 384,975 101,530 992,272 36% 209 Studebaker - Oliver Reverting Grants 630,000 24,190 58,751 - 508,669 62,580 90% 210 Economic Development State Grants 3,694,412 19,293 449,495 36,005 1,206,539 2,038,378 45% 211 Department of Community Investment (DCI) 2,661,730 193,891 1,180,059 1,098,405 31,676 1,449,995 46% 212 Dept of Community Investment Grants 6,547,968 140,658 1,355,832 1,059,718 1,997,393 3,194,743 51 216 Police State Seizures 35,900 - - - - 35,900 0% 217 Gift, Donation, Bequest 297,182 - 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 45,024 171,430 91,832 29,957 161,092 56% 227 Loss Recovery 5,237,243 84,437 2,338,854 473,937 1,657,205 1,241,185 76% 244 Emergency Phone System - - - 108,004 - - 0% 249 Public Safety LOIT 7,246,551 559,128 3,377,956 3,621,341 - 3,868,595 47% 251 Local Roads & Streets 2,126,221 87,781 249,616 87,218 794,735 1,081,870 49% 258 Human Rights Federal Grant 247,357 29,781 111,183 84,413 11,985 124,189 50% 271 Eastrace Waterway 4,000 - 2,098 9,092 - 1,902 52% 273 Morris PAC / Palais Royale Marketing 18,974 878 3,332 8,314 5,089 10,553 44% 289 HAZMAT 31,530 - 21,542 - - 9,988 68% 291 Indiana River Rescue 120,800 5,081 49,870 12,754 - 70,930 41 292 Police Grants 105,145 - 15,297 138,059 - 89,848 15% 294 Regional Police Academy 23,750 678 25,471 11,576 - (1,721) 107% 295 COPS MORE Grant 172,335 2,403 29,903 7,384 10,245 132,187 23% 299 Police Federal Drug Enforcement 248,960 56,869 113,194 49,033 16,669 119,097 52% 404 County Option Income Tax 15,660,371 777,528 5,044,926 4,458,260 1,238,156 9,377,289 40% 408 Economic Development Income Tax 9,943,709 88,516 3,776,696 4,948,809 259,938 5,907,075 41 410 Urban Development Action Grant 438,203 - 146,068 - - 292,135 33% 655 Project Releaf 528,358 2,899 52,375 52,167 - 475,983 10% 705 Police K -9 Unit 2,000 - 970 - - 1,030 49% Special Revenue Total 79,485,027 3,896,056 28,714,688 26,769,703 8,701,036 42,069,303 47% 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 855,603 - 481,573 483,673 - 374,030 56% 403 Zoo Endowment 49,000 - - - - 49,000 0% 405 Park Nonreverting Capital 192,933 11,316 32,935 149,990 42,826 117,172 39% 406 Cumulative Capital Development 542,691 56,546 361,467 361,467 - 181,224 67% 407 Cumulative Capital Improvement 365,625 - 183,750 185,250 - 181,875 50% 412 Major Moves Construction 3,096,061 281,960 1,082,033 500,296 1,623,953 390,074 87% 416 Morris Performing Arts Center Capital 70,248 1,740 27,698 7,139 23,910 18,640 73% 434 Community Revitalization Enhancement District 650,000 - 3,897 20,975 - 646,103 1 450 Palais Royale Historic Preservation 16,150 - - - - 16,150 0% 677 Football Hall of Fame Capital 188,824 2,621 29,361 44,332 - 159,463 16% Capital Project Total 6,027,135 354,183 2,202,715 1,753,121 1,690,689 2,133,731 65% R City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY June 30, 2015 Enterprise 287 Emergency Medical Services Capital 750,000 - 35,728 - - 714,272 5% 288 Emergency Medical Services Operating 6,855,366 402,139 1,658,026 2,456,539 176,330 5,021,010 27% 600 Consolidated Building Fund 4,205,401 239,314 1,523,973 1,353,286 718,051 1,963,376 53% 601 Parking Garages 1,806,712 114,904 523,062 433,059 128,045 1,155,605 36% 610 Solid Waste Operations 5,873,863 482,019 2,642,475 2,903,832 156,011 3,075,377 48% 611 Solid Waste Capital 752,811 45,686 364,502 513,119 - 388,309 48% 620 Water Works Operations 15,844,471 1,258,288 7,080,273 6,981,108 405,577 8,358,621 47% 622 Water Works Capital 838,893 109,780 196,114 3,653 33,406 609,373 27% 623 Water Works Bond Capital 53,085 121,821 175,564 447,998 7,278 (129,757) 344% 624 Water Works Customer Deposit 6,000 1,582 4,201 2,817 - 1,799 70% 625 Water Works Sinking 2,050,078 366,356 367,391 384,814 - 1,682,687 18% 626 Water Works Bond Reserve 14,500 - 7,374 - - 7,126 51% 629 Water Works Reserve Operations & Maintenance 8,500 2,367 6,206 3,983 - 2,294 73% 640 Sewer Repair Insurance 545,703 30,576 254,223 161,578 109,765 181,715 67% 641 Sewage Works Operations 40,196,974 2,240,877 18,002,651 17,915,416 1,296,920 20,897,403 48% 642 Sewage Works Capital 7,071,710 588,063 1,360,753 2,642,927 2,390,670 3,320,287 53% 643 Sewage Works Reserve Operations & Maint. 15,000 3,895 10,182 6,556 - 4,818 68% 647 Sewer Bond 2007 - - - 805 - - 0% 649 Sewage Sinking 9,282,109 1,288,842 1,591,961 1,674,352 - 7,690,148 17% 659 Sewer Bond 2011 3,711,838 - 1,085,357 2,492,907 452,777 2,173,704 41% 661 Sewer Bond 2012 16,624,275 245,591 1,151,836 513,294 2,609,288 12,863,151 23% 670 Century Center 4,532,562 362,358 1,910,521 2,211,806 - 2,622,041 42% 671 Century Center Capital 605,656 130,440 246,596 - - 359,060 41% Enterprise Total 121,645,507 8,034,899 40,198,970 43,103,849 8,484,118 72,962,418 40% Internal Service 222 Central Services 8,300,242 556,899 3,803,897 3,600,719 1,457,112 3,039,233 63% 224 Central Services Capital 271,850 - - - 28,196 243,654 10% 226 Liability Insurance 3,056,791 528,641 1,707,038 1,535,777 46,047 1,303,706 57% 278 Take Home Vehicle Police 71,100 - - - - 71,100 0% 711 Self- Funded Employee Benefits 16,696,935 973,880 6,665,513 7,086,994 206,146 9,825,276 41% 713 Unemployment Compensation 226,796 5,683 48,099 83,371 11,000 167,697 26% Internal Service Total 28,623,714 2,065,103 12,224,547 12,306,862 1,748,501 14,650,665 49% Trust & Agency 701 Firefighters Pension 5,666,579 433,366 2,632,041 2,725,715 - 3,034,539 46% 702 Police Pension 6,832,235 526,174 3,204,666 3,483,196 - 3,627,569 47% 730 City Cemetery 20,000 - - - - 20,000 0% Trust & Agency Total 12,518,814 959,540 5,836,707 6,208,911 - 6,682,108 47% City Funds Total ■ 302,946,148 19,455,397 115,962,341 117,238,948 22,128,169 164,855, Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 47,710,597 1,028,591 7,584,258 3,114,899 14,908,081 25,218,258 47% 420 Tax Incremental Financing (TIF) - Downtown 4,088,473 - 4,088,473 1,796,277 - - 100% 422 TIF - West Washington 760,900 - 30,294 319 3,366 727,240 4% 425 Redevelopment Retail & Leighton Plaza 154,716 17,590 70,421 70,314 - 84,295 46% 426 TIF - Central Medical Service Area 2,294,533 - 2,294,533 1,729,515 - - 100% 429 River East Development Area (NE Dev TIF) 7,239,524 6,600 145,547 1,475 288,791 6,805,186 6% 430 TIF - Southside Development #1 2,842,535 36,484 608,566 345,991 658,344 1,575,625 45% 435 TIF - Douglas Road 345,389 - 169,620 95,391 4,200 171,569 50% 436 River East Residential (NE Res TIF) 3,425,632 - 1,711,589 1,866,291 - 1,714,043 50% Tax Increment Financing Total 68,862,299 1,089,265 16,703,301 9,020,472 15,862,782 36,296,216 47% Redevelopment 433 Redevelopment General 6,000 - - 15,703 - 6,000 0% 439 Certified Technology Park 5,000,000 292,821 794,823 - 1,969,579 2,235,598 55% 619 Blackthorn Operations 201,649 19,744 201,228 626,109 - 421 100% Redevelopment Total 5,207,649 312,565 996,051 641,812 1,969,579 2,242,019 57% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 1,100 2,929 2,006 - 2,071 59% 328 Redevelopment Bond - Palais Royale 6,000 1,838 4,894 3,351 - 1,106 82% 432 TIF- Southside Development #3 691,380 - 559,269 354,606 - 132,111 81% Debt Service Total 702,380 2,938 567,092 359,963 - 135,288 81% development Commission Controlled Funds Total �8 1,404,768 Grand Total 377,718,476 20,860,165 134,228,785 127,261,195 39,960,530 203,529,161 46% Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Month June Fund /Department Number 101 -0101 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 740,567 57,104 347,331 335,321 - 393,236 47% Local Income Taxes - - - - - - 0% Other Taxes - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 50 20 70 20 - (20) 140% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 50 - 50 467 - (0) 100% Other Income 600 - - 229 - 600 0% Transfers In - - - - - - 0% Total Revenue 741,267 57,124 347,451 336,038 - 393,816 47% Expenditures Personnel 669,877 51,159 322,659 295,325 - 347,218 48% Supplies 12,413 754 5,788 11,016 119 6,506 48% Services 56,739 4,506 17,602 28,303 14 39,123 31% Debt Service 2,238 704 1,401 1,394 - 837 63% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 741,267 57,124 347,451 336,038 133 393,683 47% 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 June Fund /Department Number 101 -0104 Date Updated 7/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 - (0) - (24,287) - - 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,676 240,000 239,237 - 246,733 49% Transfers In - - - - - - 0% Total Revenue 486,733 35,676 240,000 214,950 - 246,733 49% Expenditures Personnel 441,562 33,255 213,581 190,752 - 227,981 48% Supplies 6,125 19 1,537 12,461 - 4,588 25% Services 39,046 2,402 24,882 11,737 1,290 12,874 67% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 486,733 35,676 240,000 214,950 1,290 245,443 50% Net - - - - (1,290) 1,290 Cash Balance - - Staffing Full Time 6.50 6.50 6.50 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 7.50 7.50 7.50 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted in 2015. Form 3 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Month June Fund /Department Number 101 -0201 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 431,573 28,359 171,331 156,419 - 260,242 40% 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 28,359 171,331 156,419 - 260,242 40% Expenditures Personnel 339,442 23,787 152,152 139,653 - 187,290 45% Supplies 7,740 110 871 3,310 1,000 5,869 24% Services 70,991 4,461 18,307 13,455 16,648 36,036 49% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 431,573 28,359 171,331 156,419 17,648 242,594 44% 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 Form 3 10 2015 City of South Bend Monthly Financial Report Fund /Department Name Common Council Month June Fund /Department Number 101 -0301 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 481,484 24,429 272,503 142,817 - 208,981 57% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 8,466 31 179 122 - 8,287 2% Other Income 200 - 200 - - - 100% Transfers In - - - - - - 0% Total Revenue 490,150 24,460 272,882 142,939 - 217,268 56% Expenditures Personnel 243,742 16,159 103,396 99,666 10,000 130,346 47% Supplies 4,706 155 819 258 709 3,179 32% Services 241,702 8,146 168,667 43,015 34,383 38,651 84% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 490,150 24,460 272,882 142,939 45,092 172,176 65% Net - - - - (45,092) 45,092 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 10 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name WNIT Contract Month June Fund /Department Number 101 -0302 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 43,000 - 43,000 - - - 100% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 43,000 - 43,000 - - - 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 43,000 - 43,000 - - - 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 43,000 - 43,000 - - - 100% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing 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 was paid 1 May. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 iVA 2015 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Month June Fund /Department Number 101 -0401 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,008,324 136,652 888,107 972,486 - 1,120,217 44% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - 556 - - 44 93% Transfers In - - - - - - 0% Total Revenue 2,008,924 136,652 888,663 972,486 - 1,120,261 44% Expenditures Personnel 1,796,651 122,921 812,969 827,746 - 983,682 45% Supplies 38,109 3,419 17,217 16,358 3,404 17,488 54% Services 171,593 10,313 57,191 127,096 25,718 88,684 48% Debt Service 2,571 - 1,286 1,286 - 1,285 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,008,924 136,652 888,663 972,486 29,122 1,091,139 46% Net - - - - (29,122) 29,122 Cash Balance - - Staffing Full Time 22.00 22.00 Part -Time /Seasonal /Temporary - 5.50 Total 22.00 27.50 - Explain Significant Revenue, Expenditure and Staffing 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. Part Time includes 5 summer interns through the Jobs for American Graduates (JAG) program. Explain Significant Spending on Capital Projects Below: None Form 3 iVA Form 3 13 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Month June Fund /Department Number 101 -0404 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 170,132 (27,180) 99,651 (133,365) - 70,481 59% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 917,000 108,322 394,316 620,519 - 522,684 43% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 700 3,383 4,555 - 2,617 56% Transfers In - - - - - - 0% Total Revenue 1,093,132 81,843 497,351 491,710 - 595,781 45% Expenditures Personnel 749,285 55,046 353,440 338,412 - 395,845 47% Supplies 33,542 2,755 10,900 9,886 7,390 15,251 55% Services 310,305 24,041 133,011 143,412 43,951 133,344 57% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,093,132 81,843 497,351 491,710 51,341 544,440 50% Net - - - - (51,341) 51,341 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 13 Form 3 14 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Month June Fund /Department Number 101 -0405 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 201,023 11,260 88,671 102,430 - 60,924 44% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 316,270 25,473 120,762 103,375 - 195,508 38% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,000 1,194 7,345 6,279 - 11,655 39% Transfers In - - - - - - 0% Total Revenue 536,293 37,926 216,778 212,084 - 268,087 40% Expenditures Personnel 263,505 18,833 119,840 114,112 - 143,665 45% Supplies 23,897 978 4,068 3,327 3,389 16,441 31% Services 234,891 18,115 92,308 94,645 36,527 106,056 55% Debt Service - - - - - - 0% Capital 14,000 - 562 - 11,513 1,925 86% Transfers Out - - - - - - 0% Total Expenditures 536,293 37,926 216,778 212,084 51,428 268,087 50% Net - - - - (51,428) - 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 14 Form 3 W1 2015 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Month June Fund /Department Number 101 -0501 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 965,099 71,131 433,561 492,213 - 531,538 45% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 3,000 - - 1,581 - 3,000 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 50,500 3 18,626 42 - 31,874 37% Transfers In - - - - - - 0% Total Revenue 1,018,599 71,133 452,186 493,835 - 566,413 44% Expenditures Personnel 948,013 66,904 427,934 472,648 - 520,079 45% Supplies 6,832 486 3,604 1,783 10 3,218 53% Services 62,454 3,743 20,012 18,769 9,644 32,798 47% Debt Service 1,300 - 635 635 637 28 98% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,018,599 71,133 452,186 493,835 10,291 556,122 45% Net - - - - (10,291) 10,291 Cash Balance - - Staffing Full Time 11.60 11.60 Part -Time /Seasonal /Temporary - - Total 11.60 11.60 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Other Income of $50,000 is reimbursement for legal expenses from TIF funds which will be received in December 2015. Encumbrances are the reason the expenses appear higher for June 2015. The encumbrances relate to subscriptions paid monthly, debt sevices paid quarterly, and office supplies. Spending appears to be on track with budgeted figures. Explain Significant Spending on Capital Projects Below: Form 3 W1 Form 3 W" 2015 City of South Bend Monthly Financial Report Fund /Department Name Engineering Month June Fund /Department Number 101 -0602 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 981,906 69,365 440,134 491,118 - 541,773 45% 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 635 2,267 19,171 - 74,760 3% Transfers In - - - - - - 0% Total Revenue 1,058,933 70,000 442,400 510,289 - 616,533 42% Expenditures Personnel 710,552 55,406 301,878 286,548 - 408,674 42% Supplies 29,262 622 18,399 11,654 693 10,170 65% Services 306,044 13,323 116,229 208,236 115,622 74,193 76% Debt Service 13,075 648 5,894 3,850 1,296 5,885 55% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,058,933 70,000 442,400 510,289 117,611 498,922 53% Net - - - - (117,611) 117,611 Cash Balance - - Staffing Full Time 7.90 7.65 Part -Time /Seasonal /Temporary 1.22 4.35 Total 9.12 12.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: $115,622 in encumbrance for Services include $53,000 for water system evaluation, $33,000 for a downtown sewer separation study, and $2,400 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 + 3 Interns. Explain Significant Spending on Capital Projects Below: Form 3 W" Form 3 17 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Department Month June Fund /Department Number 101 -0801 Date Updated 7/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 /Non -Dept Revenue 25,077,864 1,966,232 12,033,936 11,280,105 - 13,043,928 48% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - 24,316 - - 0% Charges for Services 200,000 734 759 200 - 199,241 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 7,500 - - - - 7,500 0% Other Income 347,700 10,995 90,553 111,955 - 257,147 26% Transfers In - - - - - - 0% Total Revenue 25,633,064 1,977,962 12,125,248 11,416,576 - 13,507,816 47% Expenditures Personnel 22,809,224 1,741,555 10,714,994 9,615,465 - 12,094,230 47% Supplies 499,279 38,298 223,982 395,077 94,050 181,247 64% Services 2,316,561 197,652 1,183,004 1,338,891 90,971 1,042,586 55% Debt Service 8,000 436 3,247 1,985 - 4,753 41% Capital - 20 20 65,158 - (20) 0% Transfers Out - - - - - - 0% Total Expenditures 25,633,064 1,977,962 12,125,248 11,416,576 185,021 13,322,795 48% Net - - - - (185,021) 185,021 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. Supllies and Services expenditures show 73% and 51 % of the Budget as used year to date. This is due to the 2014 encumbrances reflected as a use. These categories are expected to be on budget for the year. Explain Significant Spending on Capital Projects Below: Form 3 17 2015 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Month June Fund /Department Number 101 -0802 Date Updated 7/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 /Non -Dept Revenue 1,687,540 128,638 906,939 966,702 - 780,601 54% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,687,540 128,638 906,939 966,702 - 780,601 54% Expenditures Personnel 143,972 8 135,159 961,917 - 8,813 94% Supplies - - - 60 - - 0% Services 1,543,568 128,630 771,780 4,725 771,780 8 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,687,540 128,638 906,939 966,702 771,780 8,821 99% Net - - - - (771,780) 771,780 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 18 2015 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Month June Fund /Department Number 101 -0901 Date Updated 7/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 17,636,174 1,470,305 9,231,015 10,111,787 8,405,159 52% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 131,000 2,280 126,593 273,023 - 4,407 97% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 7,300 - 4,372 460 - 2,928 60% Transfers In - - - - - 0% Total Revenue 17,774,474 1,472,585 9,361,980 10,385,269 - 8,412,494 53% Expenditures Personnel 15,737,086 1,327,067 8,632,800 9,381,923 117,199 6,987,086 56% Supplies 320,618 11,995 69,789 166,354 24,716 226,113 29% Services 1,216,770 133,523 659,390 836,992 70,927 486,453 60% Debt Service - - - - - 0% Capital - - - - - - 0% Transfers Out 500,000 - - - - 500,000 0% Total Expenditures 17,774,474 1,472,585 9,361,980 10,385,269 212,842 8,199,652 54% Net - - - - (212,842) 212,842 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 19 Form 3 20 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Month June Fund /Department Number 101 -1008 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 373,179 23,670 183,215 160,807 - 189,964 49% 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 23,670 183,215 160,807 - 189,964 49% Expenditures Personnel 286,475 22,226 142,124 132,008 - 144,351 50% Supplies 2,010 66 639 850 400 971 52% Services 73,492 1,378 30,045 27,949 7,557 35,890 51% Debt Service - - - - - - 0% Capital 11,202 - 10,407 - - 795 93% Transfers Out - - - - - - 0% Total Expenditures 373,179 23,670 183,215 160,807 7,957 182,007 51% Net - - - - (7,957) 7,957 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 are consistent with normal operating costs. 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 20 Form 3 `A 2015 City of South Bend Monthly Financial Report Fund /Department Name Rainy Day Month June Fund /Department Number 102 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 34,680 9,170 29,390 16,649 - 5,290 85% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 34,680 9,170 29,390 16,649 - 5,290 85% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 34,680 9,170 29,390 16,649 - 5,290 Cash Balance 8,671,579 8,634,354 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 `A 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Levy Month June Fund /Department Number 103 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 4 9 - - (9) 0% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 4 9 - - (9) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 4 9 - - (9) Cash Balance 3,657 - 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 RIVA Form 3 23 2015 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation Month June Fund /Department Number 201 Date Updated 7/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 7,340,000 4,145,751 4,145,751 4,021,603 - 3,194,249 56% Local Income Taxes - - - 0% Other Taxes 626,039 327,347 327,347 689,138 - 298,692 52% Grants /Intergovernmental 884,836 73,736 442,418 - - 442,418 50% Charges for Services 2,025,640 256,272 752,426 818,537 - 1,273,214 37% Interest Earnings 10,000 321 5,555 4,539 - 4,445 56% Bond Proceeds - - - 0% Donations - - - 0% Other Income 144,200 2,895 74,111 97,112 - 70,089 51% Transfers In - - - 0% Total Revenue 11,030,715 4,806,322 5,747,608 5,630,929 - 5,283,107 52% Expenditures Personnel 7,105,699 558,117 3,130,912 3,280,753 3,115 3,971,672 44% Supplies 1,109,836 119,138 549,558 644,224 188,934 371,344 67% Services 2,443,703 497,512 1,748,695 1,857,374 69,277 625,732 74% Debt Service 309,257 50,716 148,590 166,796 - 160,667 48% Capital - - - 5,000 - - 0% Transfers Out 95,500 - - - 95,500 0% Total Expenditures 11,063,995 1,225,483 5,577,755 5,954,147 261,326 5,224,915 53% Net (33,280) 3,580,839 169,853 (323,218) (261,326) 58,192 Cash Balance 3,697,491 3,941,446 Staffing Full Time 90.00 89.00 89.00 Part-Time /Seasonal /Temporary na 215.00 215.00 Total 90.00 304.00 304.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 23 Form 3 24 2015 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month June Fund /Department Number 202 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,697,000 279,157 2,915,411 2,781,681 2,781,589 51% Grants /Intergovernmental - - 0% Charges for Services 265,000 32,603 176,040 183,753 88,960 66% Interest Earnings 9,500 4,897 13,990 6,115 (4,490) 147% Bond Proceeds - - 0% Donations - - 0% Other Income 27,300 23,578 11,269 3,722 86% Transfers In 3,703,000 1,676,500 1,483,291 2,026,500 45% Total Revenue 9,701,800 316,657 4,805,519 4,466,109 - 4,896,281 50% Expenditures Personnel 4,314,548 258,971 1,855,937 1,939,467 2,458,611 43% Supplies 2,631,854 60,893 927,724 841,756 551,284 1,152,846 56% Services 2,951,520 119,860 1,013,204 1,028,607 17,089 1,921,226 35% Debt Service 448,006 318 188,932 127,613 259,074 42% Capital 139,458 39,458 134,030 100,000 28% Transfers Out - - - - - - 0% Total Expenditures 10,485,386 440,042 4,025,256 4,071,472 568,373 5,891,757 44% Net (783,586) (123,385) 780,264 394,637 (568,373) (995,477) Cash Balance 4,675,734 4,074,437 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 24 Form 3 `�7 2015 City of South Bend Monthly Financial Report Fund /Department Name Recreation Nonreverting Month June Fund /Department Number 203 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,530,935 71,905 467,545 489,885 - 1,063,390 31% Interest Earnings 3,000 954 2,933 1,612 - 67 98% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 45,000 10,019 42,752 21,182 - 2,248 95% Transfers In - - - - - - 0% Total Revenue 1,578,935 82,878 513,230 512,679 - 1,065,705 33% Expenditures Personnel 737,842 62,600 224,814 188,679 - 513,028 30% Supplies 289,470 27,262 114,422 74,140 73,236 101,812 65% Services 522,157 21,636 112,881 122,157 28,293 380,983 27% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - 3,550 - - (3,550) 0% Total Expenditures 1,549,469 111,498 455,667 384,975 101,530 992,272 36% Net 29,466 (28,620) 57,563 127,704 (101,530) 73,433 Cash Balance 877,064 905,953 Staffing Full Time 1.00 1.00 1.00 Part -Time /Seasonal /Temporary - 54.00 54.00 Total 1.00 55.00 55.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund accounts for Parks and Recreation programs and events that are self funded through user fees. Registration for spring program, classes and softball leagues began in February.Part time employees are individuals, not FTEs. Explain Significant Spending on Capital Projects Below: Form 3 `�7 Form 3 ` ": Form 3 27 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Month June Fund /Department Number 210 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 3,600,000 - - - - 3,600,000 0% Charges for Services - - - - - - 0% Interest Earnings 13,544 6,433 7,180 4,325 - 6,364 53% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 59,966 29,759 29,759 14,387 - 30,207 50% Transfers In - - - - - - 0% Total Revenue 3,673,510 36,192 36,939 18,712 - 3,636,571 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,622,400 1,290 13,490 - 10,200 1,598,710 1% Debt Service 72,012 18,003 36,005 36,005 - 36,007 50% Capital 2,000,000 - 400,000 - 1,196,339 403,661 80% Transfers Out - - - - - - 0% Total Expenditures 3,694,412 19,293 449,495 36,005 1,206,539 2,038,378 45% Net (20,902) 16,899 (412,556) (17,293) (1,206,539) 1,598,193 Cash Balance (83,123) 331,657 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 27 Form 3 28 2015 City of South Bend Monthly Financial Report Fund /Department Name Department of Community Investment _(D-C-1 Month June Fund /Department Number 211 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 416,787 - 1,951 10,680 - 414,836 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 1,283 3,766 1,834 - (1,266) 151% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 247,500 37,323 157,269 160,946 - 90,231 64% Transfers In 1,967,638 - 983,819 844,480 - 983,819 50% Total Revenue 2,634,425 38,606 1,146,805 1,017,940 - 1,487,620 44% Expenditures Personnel 2,120,943 148,519 947,864 958,656 9,161 1,163,918 45% Supplies 35,753 3,488 18,829 10,716 3,230 13,694 62% Services 505,034 41,884 213,366 129,033 19,285 272,383 46% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,661,730 193,891 1,180,059 1,098,405 31,676 1,449,995 46% Net (27,305) (155,285) (33,254) (80,465) (31,676) 37,625 Cash Balance 1,041,192 826,849 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 28 Form 3 29 2015 City of South Bend Monthly Financial Report Fund /Department Name Dept of Community Investment Grants Month June Fund /Department Number 212 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 5,525,000 235,649 935,498 883,073 - 4,589,502 17% Charges for Services - - - - - - 0% Interest Earnings 2,000 15 1,105 1,110 - 895 55% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 363,000 1,985 197,122 171,406 - 165,878 54% Transfers In - - - - - - 0% Total Revenue 5,890,000 237,649 1,133,725 1,055,589 - 4,756,275 19% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 6,547,968 140,658 1,355,832 1,059,718 1,997,393 3,194,743 51% Transfers Out - - - - - - 0% Total Expenditures 6,547,968 140,658 1,355,832 1,059,718 1,997,393 3,194,743 51% Net (657,968) 96,991 (222,107) (4,129) (1,997,393) 1,561,532 Cash Balance 574,389 586,142 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 ongoing and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 29 Form 3 30 2015 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Month June Fund /Department Number 216 Date Updated 7/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 35,000 - 810 23,533 - 34,190 2% Charges for Services - - - - - - 0% Interest Earnings 450 200 636 307 - (186) 141% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - - - - 600 0% Transfers In - - - 0% Total Revenue 36,050 200 1,445 23,841 - 34,605 4% Expenditures Personnel - - - - - - 0% Supplies - 0% Services 35,900 - - 35,900 0% Debt Service - - - - - 0% Capital - - - - - - 0% Transfers Out - 0% Total Expenditures 35,900 - - - - 35,900 0% Net 150 200 1,445 23,841 - (1,295) Cash Balance 188,877 182,507 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 30 Form 3 191 2015 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month June Fund /Department Number 217 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 800 74 365 165 - 435 46% Bond Proceeds - - - - - - 0% Donations 398,000 100 3,055 21,113 - 394,945 1% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 398,800 174 3,420 21,278 - 395,380 1% Expenditures Personnel - - - - - - 0% Supplies 1,552 - - 2,786 1,552 0 100% Services 295,630 - 81,093 - - 214,537 27% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 297,182 - 81,093 2,786 1,552 214,537 28% Net 101,618 174 (77,673) 18,491 (1,552) 180,843 Cash Balance 60,265 93,226 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 191 Form 3 19YA 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Month June Fund /Department Number 218 Date Updated 7/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 1,000 25 38 263 - 963 4% Interest Earnings 25 13 41 22 - (16) 163% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,025 38 78 285 - 947 8% 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 38 78 285 - (53) Cash Balance 12,084 11,833 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 19YA Form 3 33 2015 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education Month June Fund /Department Number 220 Date Updated 7/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 50,000 - 49,119 10,000 - 881 98% Charges for Services 182,000 12,716 106,773 82,180 - 75,227 59% Interest Earnings 3,000 1,044 3,301 1,914 - (301) 110% Bond Proceeds - - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income 33,000 3,735 11,533 11,517 - 21,467 35% Transfers In - - - - - 0% Total Revenue 270,000 17,495 170,726 105,611 - 99,274 63% Expenditures Personnel - - - - - - 0% Supplies 172,478 31,504 55,321 21,494 29,957 87,200 49% Services 190,000 13,520 116,109 56,391 - 73,891 61% Debt Service - - - - - - 0% Capital - - - 13,947 - - 0% Transfers Out - - - - - - 0% Total Expenditures 362,478 45,024 171,430 91,832 29,957 161,092 56% Net (92,478) (27,529) (703) 13,779 (29,957) (61,818) Cash Balance 980,372 995,005 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 33 Form 3 34 2015 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Month June Fund /Department Number 227 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 20,000 4,168 16,844 15,160 - 3,156 84% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 30,000 1,000 30,000 - - - 100% Transfers In - - - - - - 0% Total Revenue 50,000 5,168 46,844 15,160 - 3,156 94% Expenditures Personnel - - - - - - 0% Supplies 67,500 16,673 16,673 - 50,828 - 100% Services 3,280,635 65,854 1,882,249 319,517 157,201 1,241,184 62% Debt Service - - - - - - 0% Capital 1,889,108 1,910 439,932 154,420 1,449,176 1 100% Transfers Out - - - - - 0% Total Expenditures 5,237,243 84,437 2,338,854 473,937 1,657,205 1,241,185 76% Net (5,187,243) (79,269) (2,292,010) (458,777) (1,657,205) (1,238,028) Cash Balance 3,571,883 7,477,256 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Of the $3.28 million budgeted for Services, $157K 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. A budget adjustment will be made in July to increase interest income based on June's YTD receipts of $16,844. Explain Significant Spending on Capital Projects Below: $1.889 million has been budgeted in 2015 for the Smart Streets initiative. As of June, all Capital encumbrances are for the Lincolnway West Corridors project. Form 3 34 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month June Fund /Department Number 244 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - 215,000 - - 0% Charges for Services - - - - - - 0% Interest Earnings 20 - 19 - - 1 97% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 20 - 19 215,000 - 1 97% Expenditures Personnel - - - 108,004 - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 108,004 - - 0% Net 20 - 19 106,996 - 1 Cash Balance 33,671 106,996 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 MA Form 3 Ki: 2015 City of South Bend Monthly Financial Report Fund /Department Name Public Safety WIT Month June Fund /Department Number 249 Date Updated 7/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 6,466,190 538,849 3,233,095 3,190,015 - 3,233,095 50% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 1,136 3,665 3,594 - 2,335 61% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 50 - 13 - - 37 27% Transfers In - - - - - - 0% Total Revenue 6,472,240 539,985 3,236,774 3,193,609 - 3,235,466 50% Expenditures Personnel 7,246,551 559,128 3,377,956 3,621,341 - 3,868,595 47% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 7,246,551 559,128 3,377,956 3,621,341 - 3,868,595 47% Net (774,311) (19,142) (141,182) (427,732) - (633,129) Cash Balance 1,149,241 1,604,462 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 Ki: 2015 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month June Fund /Department Number 251 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,000,000 94,072 556,366 540,556 - 443,634 56% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,300 2,938 8,939 4,097 - (2,639) 142% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 770,000 - 20,375 33,801 - 749,625 3% Transfers In - - - - - - 0% Total Revenue 1,776,300 97,010 585,680 578,454 - 1,190,620 33% Expenditures Personnel - - - - - - 0% Supplies 380,229 - - 20,436 - 380,229 0% Services 157,500 - 11,000 - - 146,500 7% Debt Service - - - - - - 0% Capital 1,588,492 87,781 238,616 66,782 794,735 555,141 65% Transfers Out - - - - - - 0% Total Expenditures 2,126,221 87,781 249,616 87,218 794,735 1,081,870 49% Net (349,921) 9,229 336,065 491,236 (794,735) 108,750 Cash Balance 2,780,512 2,432,611 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 $555K in encumbrance includes $240,000 for Bendix Dr. (Lathrop to Toll Road), $182,000 for Boland Trail, and $202,000 for the Olive from Sample to Tucker. Form 3 37 Form 3 38 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Month June Fund /Department Number 252 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 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 38 Form 3 39 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant Month June Fund /Department Number 258 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 189,000 - 6,667 5,000 - 182,333 4% Charges for Services - - - - - - 0% Interest Earnings 2,000 429 1,450 862 - 550 73% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 18,950 270 17,646 17,924 - 1,304 93% Transfers In - - - - - - 0% Total Revenue 209,950 699 25,763 23,786 - 184,187 12% Expenditures Personnel 123,657 8,949 57,414 54,832 - 66,243 46% Supplies 2,800 416 584 293 1,216 1,000 64% Services 120,900 20,416 53,185 29,288 10,769 56,946 53% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 247,357 29,781 111,183 84,413 11,985 124,189 50% Net (37,407) (29,082) (85,420) (60,627) (11,985) 59,998 Cash Balance 445,601 406,148 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 39 Form 3 40 2015 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Month June Fund /Department Number 271 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 50 3 16 27 - 34 32% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 50 3 16 27 - 34 32% Expenditures Personnel - - - - - - 0% Supplies 4,000 - 2,098 9,092 - 1,902 52% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,000 - 2,098 9,092 - 1,902 52% Net (3,950) 3 (2,082) (9,065) - (1,868) Cash Balance 3,230 5,307 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 40 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month June Fund /Department Number 273 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 17,900 400 3,613 6,265 - 14,287 20% Interest Earnings 100 28 91 51 - 9 91% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 18,000 428 3,704 6,316 - 14,296 21% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 18,974 878 3,332 8,314 5,089 10,553 44% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 18,974 878 3,332 8,314 5,089 10,553 44% Net (974) (449) 373 (1,998) (5,089) 3,742 Cash Balance 27,086 25,987 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 Cy 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Month June Fund /Department Number 280 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 4 13 7 - (13) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 4 13 7 - (13) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 4 13 7 - (13) Cash Balance 3,841 3,825 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 E, VA 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Month June Fund /Department Number 281 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 100 29 93 52 - 7 93% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 200 - - - - 200 0% Transfers In - - - - - - 0% Total Revenue 300 29 93 52 - 207 31% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 300 29 93 52 - 207 Cash Balance 27,297 27,180 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 43 Form 3 44 2015 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Month June Fund /Department Number 289 Date Updated 7/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 14,000 - 13,787 - - 213 98% Interest Earnings 100 34 113 31 - (13) 113% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 14,100 34 13,900 31 - 200 99% Expenditures Personnel - - - - - - 0% Supplies 31,530 - 21,542 - 9,988 68% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 31,530 - 21,542 - - 9,988 68% Net (17,430) 34 (7,642) 31 - (9,788) Cash Balance 31,987 16,239 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. 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 44 Form 3 E117 2015 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue Month June Fund /Department Number 291 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 45,000 600 22,200 34,600 - 22,800 49% Interest Earnings 350 94 328 197 - 22 94% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,350 694 22,528 34,797 - 22,822 50% Expenditures Personnel 7,500 231 1,154 - - 6,346 15% Supplies 8,800 1,365 2,008 406 - 6,792 23% Services 79,500 3,485 25,711 12,348 - 53,789 32% Debt Service - - - - - - 0% Capital 25,000 - 20,997 - - 4,003 84% Transfers Out - - - - - - 0% Total Expenditures 120,800 5,081 49,870 12,754 - 70,930 41% Net (75,450) (4,387) (27,342) 22,043 - (48,108) Cash Balance 78,057 117,762 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: No staffing associated with this fund. The fund collects tuition fees for students attending the Indiana River Rescue School. There are typically 2 -4 schools a year, each a week in duration. Expenditures are for the maintenance and repair of rescue equipment. Explain Significant Spending on Capital Projects Below: Form 3 E117 Form 3 E, P", 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Month June 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 E, P", Form 3 47 2015 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Month June Fund /Department Number 294 Date Updated 7/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 20,500 - 20,488 17,900 - 13 100% Interest Earnings 200 68 234 154 - (34) 117% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In - - - - - - 0% Total Revenue 22,700 68 20,721 18,054 - 1,979 91% Expenditures Personnel - - - - - - 0% Supplies 1,750 158 935 - - 815 53% Services 22,000 520 24,536 11,576 - (2,536) 112% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 678 25,471 11,576 - (1,721) 107% Net (1,050) (610) (4,750) 6,478 - 3,700 Cash Balance 63,533 74,563 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 47 Form 3 48 2015 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Month June Fund /Department Number 295 Date Updated 7/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 86,658 - - - - 86,658 0% Charges for Services - - - - - - 0% Interest Earnings 350 122 345 218 - 5 98% Bond Proceeds - - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 38,000 710 15,800 5,496 - 22,200 42% Transfers In 22,000 - 20,965 - - 1,035 95% Total Revenue 150,258 832 37,110 5,714 - 113,148 25% Expenditures Personnel - - - - - - 0% Supplies 45,735 1,411 27,130 2,204 10,245 8,360 82% Services 66,000 991 2,773 5,180 - 63,227 4% Debt Service - - - - - - 0% Capital 60,600 - - - - 60,600 0% Transfers Out - - - - - - 0% Total Expenditures 172,335 2,403 29,903 7,384 10,245 132,187 23% Net (22,077) (1,571) 7,206 (1,670) (10,245) (19,038) Cash Balance 113,440 111,673 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 48 Form 3 49 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Month June Fund /Department Number 299 Date Updated 7/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 75,000 - 63,744 24,412 - 11,256 85% Charges for Services - - - - - - 0% Interest Earnings 1,000 98 513 493 - 487 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,000 - - - - 1,000 0% Transfers In - - - - - - 0% Total Revenue 77,000 98 64,257 24,906 - 12,743 83% Expenditures Personnel - - - - - - 0% Supplies 84,759 10,711 44,872 23,800 16,669 23,218 73% Services 74,201 7,159 23,102 25,234 - 51,099 31% Debt Service - - - - - - 0% Capital 90,000 39,000 45,221 - - 44,779 50% Transfers Out - - - - - - 0% Total Expenditures 248,960 56,869 113,194 49,033 16,669 119,097 52% Net (171,960) (56,771) (48,937) (24,128) (16,669) (106,354) Cash Balance 335,606 361,032 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 49 2015 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax Month June Fund /Department Number 404 Date Updated 7/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 4,429,956 4,322,905 - 4,429,956 50% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 58,000 15,585 49,744 28,043 - 8,256 86% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 966,059 48,455 412,868 260,888 - 553,191 43% Transfers In - - - - - - 0% Total Revenue 9,883,971 802,366 4,892,568 4,611,836 - 4,991,403 50% Expenditures Personnel 427,077 26,182 154,503 - - 272,574 36% Supplies 1,384,804 75,134 432,841 612,030 13,790 938,173 32% Services 8,159,164 468,014 2,484,698 1,929,517 359,471 5,314,995 35% Debt Service 2,487,504 205,576 1,194,334 1,347,213 - 1,293,170 48% Capital 1,701,822 2,623 28,551 19,500 864,895 808,376 52% Transfers Out 1,500,000 - 750,000 550,000 - 750,000 50% Total Expenditures 15,660,371 777,528 5,044,926 4,458,260 1,238,156 9,377,289 40% Net (5,776,400) 24,838 (152,358) 153,576 (1,238,156) (4,385,886) Cash Balance 14,879,259 15,059,211 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 50 Form 3 ti. 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax Month June Fund /Department Number 408 Date Updated 7/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 8,981,877 748,490 4,490,939 4,398,410 - 4,490,939 50% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 - 504,660 354,660 - - 100% Interest Earnings 40,000 11,020 34,204 19,776 - 5,796 86% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 100 - 82 11,948 - 18 82% Transfers In - - - - - - 0% Total Revenue 9,526,637 759,510 5,029,885 4,784,794 - 4,496,752 53% Expenditures Personnel - - - 195,573 - - 0% Supplies - - - - - - 0% Services 1,799,736 88,516 758,823 709,635 259,138 781,775 57% Debt Service 1,656,191 - 438,568 962,550 - 1,217,624 26% Capital 4,000 - 3,200 150,000 800 - 100% Transfers Out 6,483,782 - 2,576,105 2,931,051 - 3,907,677 40% Total Expenditures 9,943,709 88,516 3,776,696 4,948,809 259,938 5,907,075 41% Net (417,072) 670,994 1,253,189 (164,015) (259,938) (1,410,323) Cash Balance 11,423,414 10,678,113 Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Encumbrances include $90k to DTSB for 2015 operations. In 2015, Code Enforcement personnel expense is fully paid out of Fund 600, so 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 ti. Form 3 N% 2015 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Month June Fund /Department Number 410 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 110 131 243 53 - (133) 221% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 528,576 - 241,849 - - 286,727 46% Transfers In - - - - - - 0% Total Revenue 528,686 131 242,092 53 - 286,594 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 131 96,024 53 - (5,541) Cash Balance 123,689 27,640 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. One payment was made in April for $146,068. Two more payments from the BDC are expected in 2015 - -in July and October. Explain Significant Spending on Capital Projects Below: Form 3 N% Form 3 53 2015 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Month June Fund /Department Number 655 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 429,000 36,613 218,731 217,828 210,269 51% Interest Earnings 2,700 1,163 3,580 1,920 (880) 133% Bond Proceeds - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 37,776 222,312 219,748 - 209,388 51% Expenditures Personnel 64,081 12 1,464 1,457 62,617 2% Supplies 6,000 6,000 0% Services 36,058 2,886 14,802 14,601 21,256 41% 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,899 52,375 52,167 - 475,983 10% Net (96,658) 34,877 169,936 167,581 - (266,594) Cash Balance 1,149,778 1,106,634 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 53 Form 3 54 2015 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Month June Fund /Department Number 705 Date Updated 7/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 10 3 11 4 - (1) 109% Bond Proceeds - - - - - - 0% Donations 1,990 1,000 1,500 1,000 - 490 75% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 1,003 1,511 1,004 - 489 76% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,000 - 970 - - 1,030 49% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,000 - 970 - - 1,030 49% Net - 1,003 541 1,004 - (541) Cash Balance 3,860 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 54 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service Month June Fund /Department Number 313 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 1,177,620 501,785 501,785 271,788 - 675,835 43% Local Income Taxes - - - - - - 0% Other Taxes 45,358 36,400 36,400 22,679 - 8,958 80% Grants /Intergovernmental 51,078 4,256 25,539 42,839 - 25,539 50% Charges for Services - - - - - - 0% Interest Earnings 50 - 41 - - 9 82% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,274,106 542,441 563,765 337,306 - 710,341 44% 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,286 542,441 (72,235) (297,194) - 79,521 Cash Balance 1,887 419,142 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 6101 2015 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month June Fund /Department Number 377 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 747,750 42,734 377,510 301,664 - 370,240 50% Charges for Services - - - - - - 0% Interest Earnings 1,100 508 1,570 1,251 - (470) 143% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,661 - 29,523 34,608 - 31,138 49% Transfers In - - - - - - 0% Total Revenue 809,511 43,242 408,603 337,523 - 400,908 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 855,603 - 481,573 483,673 - 374,030 56% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 855,603 - 481,573 483,673 - 374,030 56% Net (46,092) 43,242 (72,970) (146,150) - 26,878 Cash Balance 523,122 695,907 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. Explain Significant Spending on Capital Projects Below: Form 3 ti7: Form 3 57 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month June Fund /Department Number 401 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 15,000 - - - - 15,000 0% Interest Earnings 100 43 138 52 - (38) 138% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,100 43 138 52 - 14,962 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 15,100 43 138 52 - 14,962 Cash Balance 40,588 26,902 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 57 2015 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Month June Fund /Department Number 403 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 200 52 167 95 - 33 84% Bond Proceeds - - - - - - 0% Donations - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 200 52 167 95 - 33 84% 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) 52 167 95 - (48,967) Cash Balance 49,329 49,117 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 58 2015 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Month June Fund /Department Number 405 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,000 786 3,036 1,924 - 30,964 9% Interest Earnings 2,200 483 1,592 829 - 608 72% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 12,000 4,250 12,144 - 7,750 35% Transfers In 95,500 - - - - 95,500 0% Total Revenue 143,700 1,269 8,878 14,897 - 134,822 6% Expenditures Personnel - - - - - - 0% Supplies 67,273 5,424 27,007 42,570 15,847 24,419 64% Services 50,660 5,892 5,928 12,420 4,480 40,252 21% Debt Service - - - - - - 0% Capital 75,000 - - 95,000 22,499 52,501 30% Transfers Out - - - - - - 0% Total Expenditures 192,933 11,316 32,935 149,990 42,826 117,172 39% Net (49,233) (10,047) (24,057) (135,092) (42,826) 17,650 Cash Balance 499,627 437,799 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 59 Form 3 60 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development Month June Fund /Department Number 406 Date Updated 7/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 450,000 237,380 237,380 235,215 - 212,620 53% Local Income Taxes - - - - - - 0% Other Taxes 90,191 23,093 44,840 42,322 - 45,351 50% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 397 1,587 1,292 - 913 63% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 854 - - 0% Transfers In - - - - - - 0% Total Revenue 542,691 260,870 283,806 279,683 - 258,885 52% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 542,691 56,546 361,467 361,467 - 181,224 67% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 542,691 56,546 361,467 361,467 - 181,224 67% Net - 204,325 (77,661) (81,784) - 77,661 Cash Balance 503,590 704,014 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 60 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement Month June Fund /Department Number 407 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 397,000 117,652 117,652 123,553 - 279,348 30% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 70 418 84 - (268) 279% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,200 - - - - 25,200 0% Transfers In - - - - - - 0% Total Revenue 422,350 117,722 118,070 123,637 - 304,280 28% 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,725 117,722 (65,680) (61,613) - 122,405 Cash Balance 183,803 115,111 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 61 2015 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction Month June Fund /Department Number 412 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - 0% Interest Earnings 25,000 3,473 12,101 13,788 - 12,899 48% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 786,187 - 368,031 227,661 - 418,156 47% Transfers In - - - - - - 0% Total Revenue 811,187 3,473 380,132 241,449 - 431,055 47% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 3,096,061 281,960 1,082,033 500,296 1,623,953 390,074 87% Transfers Out - - - - - - 0% Total Expenditures 3,096,061 281,960 1,082,033 500,296 1,623,953 390,074 87% Net (2,284,874) (278,487) (701,901) (258,846) (1,623,953) 40,980 Cash Balance 2,939,762 6,885,051 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 30 June are $787,402 from Fund 435 (Douglas Rd.) and $4,588,506 from Fund 436 (River East Residential, f /k /a Northeast Residential) Explain Significant Spending on Capital Projects Below: The 2015 budget continues funding for the Smart Streets initiative and includes $950,000 for Smart Streets, $350,000 for the King /LWW roundabout design, and $30,000 for Corridor alley improvements. The $1.6 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 62 Form 3 63 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Month June Fund /Department Number 416 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 100,000 2,522 33,091 47,603 - 66,909 33% Interest Earnings 1,500 547 1,756 912 - (256) 117% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 101,500 3,069 34,847 48,515 - 66,653 34% Expenditures Personnel - - - - - - 0% Supplies 30,210 - 11,225 5,374 8,884 10,101 67% Services 40,038 1,740 16,473 1,765 15,027 8,539 79% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 70,248 1,740 27,698 7,139 23,910 18,640 73% Net 31,252 1,329 7,149 41,376 (23,910) 48,013 Cash Balance 522,569 498,186 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 63 2015 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Month June Fund /Department Number 434 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 32 168 154 - (18) 112% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 150 32 168 154 - (18) 112% 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 (649,850) 32 (3,729) (20,821) - (646,121) Cash Balance 6,109 (11,284) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: CRIED is derived from State sales 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 64 Form 3 65 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Month June Fund /Department Number 450 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 16,000 592 5,224 3,625 - 10,776 33% Interest Earnings 150 71 222 107 - (72) 148% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,150 663 5,446 3,732 - 10,704 34% 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 - 663 5,446 3,732 - (5,446) Cash Balance 68,607 57,128 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 65 Form 3 66 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Month June Fund /Department Number 677 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 568 1,860 1,247 - 640 74% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 568 1,860 1,247 - 640 74% Expenditures Personnel - - - - - - 0% Supplies 15,000 - - 365 - 15,000 0% Services 173,824 2,621 29,361 43,967 - 144,463 17% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,824 2,621 29,361 44,332 - 159,463 16% Net (186,324) (2,053) (27,501) (43,085) - (158,823) Cash Balance 531,719 615,321 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 66 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Month June Fund /Department Number 287 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 400,000 - 396,727 - - 3,273 99% Interest Earnings 350 383 715 - - (365) 204% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 750,000 - - - - 750,000 0% Total Revenue 1,150,350 383 397,442 - - 752,908 35% 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 400,350 383 361,714 - - 38,636 Cash Balance 361,714 - 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 67 Form 3 68 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Operating Month June Fund /Department Number 288 Date Updated 7/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 5,144,065 502,651 2,401,867 1,455,425 - 2,742,198 47% Interest Earnings 18,000 3,716 10,758 11,363 - 7,242 60% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 2,074 12,483 12,491 - 4,517 73% Transfers In 500,000 - - - - 500,000 0% Total Revenue 5,679,065 508,441 2,425,107 1,479,279 - 3,253,958 43% Expenditures Personnel 4,840,253 342,951 1,144,385 - - 3,695,868 24% Supplies 292,000 50,325 185,208 58,800 13,155 93,637 68% Services 375,337 8,862 101,715 164,891 12,444 261,179 30% Debt Service 448,773 - 226,719 20,651 1,728 220,326 51% Capital 149,003 - - 2,212,197 149,003 - 100% Transfers Out 750,000 - - - - 750,000 0% Total Expenditures 6,855,366 402,139 1,658,026 2,456,539 176,330 5,021,010 27% Net (1,176,301) 106,302 767,081 (977,260) (176,330) (1,767,052) Cash Balance 3,652,052 4,610,908 Staffing Full Time 51.00 50.00 50.00 Part -Time /Seasonal /Temporary - - - Total 51.00 50.00 50.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 68 Form 3 69 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund Month June Fund /Department Number 600 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,536,052 173,982 937,325 665,422 - 598,728 61% Interest Earnings 2,100 943 2,968 805 - (868) 141% Bond Proceeds - - - - - - 0% Donations 100 - 52 - - 48 52% Other Income 7,817 11,718 18,231 1,194 - (10,414) 233% Transfers In 2,663,144 - 665,786 1,153,280 - 1,997,358 25% Total Revenue 4,209,213 186,643 1,624,361 1,820,701 - 2,584,852 39% Expenditures Personnel 2,454,138 169,278 1,084,148 896,740 2,160 1,367,830 44% Supplies 181,483 9,209 61,376 65,788 13,347 106,760 41% Services 1,538,733 58,404 367,970 382,076 701,365 469,398 69% Debt Service 31,047 2,422 10,479 8,681 1,180 19,388 38% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,205,401 239,314 1,523,973 1,353,286 718,051 1,963,376 53% Net 3,812 (52,671) 100,388 467,415 (718,051) 621,476 Cash Balance 848,774 620,997 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. As of June 30 only one quarter's transfer has been initiated, but the 2nd and 3rd Quarter payments will be made in July. Explain Significant Spending on Capital Projects Below: Form 3 69 2015 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages Month June Fund /Department Number 601 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 908,675 81,037 456,123 456,984 - 452,552 50% Interest Earnings 5,600 1,136 3,621 1,804 - 1,979 65% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 130,850 8,949 41,033 104,683 - 89,817 31% Transfers In - - - - - - 0% Total Revenue 1,045,125 91,122 500,777 563,471 - 544,348 48% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,621,858 114,904 470,224 365,079 118,430 1,033,204 36% Debt Service - - - - - - 0% Capital 184,854 - 52,838 67,980 9,615 122,401 34% Transfers Out - - - - - - 0% Total Expenditures 1,806,712 114,904 523,062 433,059 128,045 1,155,605 36% Net (761,587) (23,782) (22,285) 130,412 (128,045) (611,257) Cash Balance 1,051,344 1,014,600 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 70 Form 3 VLF 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations Month June Fund /Department Number 610 Date Updated 7/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 416,330 2,550,232 2,472,693 - 2,669,084 49% Interest Earnings 2,500 528 1,385 1,183 - 1,115 55% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 490,473 - 85,973 98,048 - 404,500 18% Transfers In - - - - - - 0% Total Revenue 5,712,289 416,858 2,637,589 2,571,924 - 3,074,700 46% Expenditures Personnel 1,731,390 133,676 785,360 819,186 1,250 944,780 45% Supplies 371,208 22,924 136,815 212,551 32,140 202,254 46% Services 2,991,595 279,419 1,370,401 1,422,179 122,621 1,498,573 50% Debt Service 26,859 - 19,900 - 6,959 74% Capital - - - - - 0% Transfers Out 752,811 46,000 330,000 449,916 422,811 44% Total Expenditures 5,873,863 482,019 2,642,475 2,903,832 156,011 3,075,377 48% Net (161,574) (65,161) (4,885) (331,908) (156,011) (677) Cash Balance 430,277 457,025 Staffing Full Time 25.20 21.20 Part -Time /Seasonal /Temporary 8.00 8.00 Total 33.20 29.20 - Explain Significant Revenue, Expenditure and Staffing 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. Transfers out to Fund 611 for debt service payments are done on an as needed basis. While expenses are generally falling within budgeted expectations, revenues continue to come in slightly below budgeted levels. Explain Significant Spending on Capital Projects Below: Form 3 VLF 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Month June Fund /Department Number 611 Date Updated 7/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 0 53 130 - 147 26% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 752,811 46,000 330,000 449,916 - 422,811 44% Total Revenue 753,011 46,000 330,053 450,046 - 422,958 44% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 752,811 45,686 364,502 373,669 - 388,309 48% Capital - - - 139,450 - - 0% Transfers Out - - - - - - 0% Total Expenditures 752,811 45,686 364,502 513,119 - 388,309 48% Net 200 314 (34,450) (63,073) - 34,650 Cash Balance 775 55,367 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 72 Form 3 73 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations Month June Fund /Department Number 620 Date Updated 7.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 14,638,403 1,344,051 6,677,720 6,861,906 - 7,960,683 46% Interest Earnings 29,000 5,536 16,302 6,206 - 12,698 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 93,580 17,649 32,251 63,761 - 61,329 34% Transfers In 19,500 4,832 19,699 7,745 - (199) 101% Total Revenue 14,780,483 1,372,068 6,745,972 6,939,618 - 8,034,511 46% Expenditures Personnel 5,023,137 359,608 2,269,971 2,198,059 2,050 2,751,116 45% Supplies 1,516,896 184,564 734,358 781,890 71,347 711,191 53% Services 4,979,548 342,195 1,851,647 1,988,343 329,812 2,798,089 44% Debt Service 17,936 1,136 3,860 2,096 2,368 11,708 35% Capital - - - - - - 0% Transfers Out 4,306,954 370,785 2,220,437 2,010,720 - 2,086,517 52% Total Expenditures 15,844,471 1,258,288 7,080,273 6,981,108 405,577 8,358,621 47% Net (1,063,988) 113,780 (334,301) (41,490) 1405577)1- (324,110) Cash Balance 3,833,254 3,325,991 Staffing Full Time 70.20 68.20 Part -Time /Seasonal /Temporary 3.00 3.50 Total 73.20 71.70 - 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. Abnormal weather in June has contributed to the decline in charges for services revenue. The transfers in revenue is impacted by a one time transfer of cumulative interest earnings on investments from the Debt Service Reserve Fund. Other income sources were greater in 2014 because of scrap metal sales from retired water meters and from hydrant damage reimbursements. A significant portion of the expended supplies expense is for water meters and repair part purchases. Explain Significant Spending on Capital Projects Below: Form 3 73 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Month June Fund /Department Number 622 Date Updated 7.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10,000 3,225 10,467 6,817 - (467) 105% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 3,225 10,467 6,817 - (467) 105% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 3,600 - - 0% Debt Service - - - - - - 0% Capital 838,893 109,780 196,114 53 33,406 609,373 27% Transfers Out - - - - - - 0% Total Expenditures 838,893 109,780 196,114 3,653 33,406 609,373 27% Net (828,893) (106,555) (185,647) 3,164 (33,406) (609,840) Cash Balance 2,939,634 3,534,889 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) & Backhoe (1) $180,732 Encumb: Truck (1) $33,406 Form 3 74 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Month June Fund /Department Number 623 Date Updated 7.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 450 137 544 1,308 (94) 121% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 450 137 544 1,308 - (94) 121% Expenditures Personnel - - 0% Supplies 50,914 28,277 79,191 34,046 7,278 (35,555) 170% Services 2,171 34,015 36,843 42,103 (34,672) 1697% Debt Service - - - - - - 0% Capital - 59,529 59,530 371,849 - (59,530) 0% Transfers Out - - - - - 0% Total Expenditures 53,085 121,821 175,564 447,998 7,278 (129,757) 344% Net (52,635) (121,684) (175,020) (446,690) (7,278) 129,663 Cash Balance 7,519 365,939 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. A Budget Transfer Form B will be submitted to appropriate a budget for final use of the proceeds. Remaining unused monies is expected to be approximately $241 and will be transferred out to the sinking fund for formal closure. Explain Significant Spending on Capital Projects Below: Water Meters $50,914 Pinhook WT Effic Improv Proj $124,649 Boland Park PRV $2,171 Form 3 75 Form 3 W" 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Month June Fund /Department Number 624 Date Updated 7.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 1,582 5,056 2,817 - 944 84% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 1,582 5,056 2,817 - 944 84% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - 0% Transfers Out 6,000 1,582 4,201 2,817 - 1,799 70% Total Expenditures 6,000 1,582 4,201 2,817 - 1,799 70% Net - - 855 - - (855) Cash Balance 1,492,808 1,465,420 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 W" Form 3 77 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Month June Fund /Department Number 625 Date Updated 7.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 883 1,921 944 - 3,079 38% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 2,045,078 170,275 1,021,650 1,024,860 - 1,023,428 50% Total Revenue 2,050,078 171,158 1,023,571 1,025,804 - 1,026,507 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 2,045,078 365,473 365,473 383,870 - 1,679,605 18% Capital - - - - - 0% Transfers Out 5,000 883 1,918 944 - 3,082 38% Total Expenditures 2,050,078 366,356 367,391 384,814 - 1,682,687 18% Net - (195,198) 656,180 640,990 - (656,180) Cash Balance 660,835 646,327 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 77 Form 3 78 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Month June Fund /Department Number 626 Date Updated 7.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 9,500 2,351 3,007 7,149 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - 0% Transfers In - - - 51,384 - - 0% Total Revenue 9,500 - 2,351 54,391 - 7,149 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 14,500 - 7,374 - - 7,126 51% Total Expenditures 14,500 - 7,374 - - 7,126 51% Net (5,000) - (5,023) 54,391 - 23 Cash Balance 1,641,654 1,620,067 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. Included in the transfer out expense is prior year interest earnings that were not previously transferred to the Operating Fund. Explain Significant Spending on Capital Projects Below: Form 3 78 Form 3 79 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Month June Fund /Department Number 629 Date Updated 7.10.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 8,500 2,367 7,409 3,983 - 1,091 87% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 154,249 - 150,228 53,507 - 4,021 97% Total Revenue 162,749 2,367 157,637 57,490 - 5,112 97% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 2,367 6,206 3,983 - 2,294 73% Total Expenditures 8,500 2,367 6,206 3,983 - 2,294 73% 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 has been transferred in to comply with 2015's requirement. Explain Significant Spending on Capital Projects Below: Form 3 79 Form 3 80 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Month June Fund /Department Number 640 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 551,200 50,237 304,214 289,559 - 246,986 55% Interest Earnings 3,600 1,638 5,209 2,725 - (1,609) 145% Bond Proceeds - - - 0% Donations - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 554,800 51,875 309,423 292,284 - 245,377 56% Expenditures Personnel 206,842 11,167 81,137 76,618 125,705 39% Supplies 28,603 1,880 10,307 5,351 10,500 7,796 73% Services 281,802 17,529 148,562 65,391 99,265 33,976 88% Debt Service 28,456 14,218 14,218 14,238 50% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 545,703 30,576 254,223 161,578 109,765 181,715 67% Net 9,097 21,299 55,199 130,706 (109,765) 63,662 Cash Balance 1,563,229 1,493,752 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 80 Form 3 81 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations Month June Fund /Department Number 641 Date Updated 7/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,968,262 17,237,502 16,407,801 - 17,971,965 49% Interest Earnings 22,000 8,255 30,261 10,515 - (8,261) 138% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 92,100 21,472 41,946 33,597 - 50,154 46% Transfers In 15,000 3,895 10,182 6,556 - 4,818 68% Total Revenue 35,338,567 3,001,884 17,319,892 16,458,469 - 18,018,675 49% Expenditures Personnel 7,402,560 476,844 3,270,251 3,357,155 - 4,132,309 44% Supplies 2,154,745 95,387 609,424 772,162 177,573 1,367,748 37% Services 15,178,782 894,234 5,033,423 4,842,021 1,119,347 9,026,012 41% Debt Service 585,187 875 192,250 164,600 - 392,937 33% Capital - - - - - - 0% Transfers Out 14,875,700 773,536 8,897,303 8,779,478 - 5,978,397 60% Total Expenditures 40,196,974 2,240,877 18,002,651 17,915,416 1,296,920 20,897,403 48% Net (4,858,407) 761,007 (682,759) (1,456,947) (1,296,920) (2,878,728) Cash Balance 8,233,219 5,755,049 Staffing Full Time 95.25 84.40 Part -Time /Seasonal /Temporary 6.62 2.00 Total 101.87 86.40 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This enterprise fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Debt service payments are made in accordance with City amortization schedules. Vacancies in all four departments operating out of this fund have kept Personnel expenses down, as well as FTE counts. Supplies expense is below budget at mid -year; totals are expected to fall closer to budgeted levels as the year progresses. Explain Significant Spending on Capital Projects Below: Capital spending for Sewage works is shown in Fund 642. Form 3 81 Form 3 E:A 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Month June Fund /Department Number 642 Date Updated 7/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 6,750 15,313 10,028 - 23,687 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 5,359,000 - 4,000,000 4,000,000 - 1,359,000 75% Total Revenue 5,398,000 6,750 4,015,313 4,010,028 - 1,382,687 74% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 36,043 7,632 32,300 43,269 3,743 0 100% Debt Service - - - - - - 0% Capital 7,035,667 580,431 1,328,453 2,599,659 2,386,927 3,320,287 53% Transfers Out - - - - - - 0% Total Expenditures 7,071,710 588,063 1,360,753 2,642,927 2,390,670 3,320,287 53% Net (1,673,710) (581,313) 2,654,560 1,367,101 (2,390,670) (1,937,600) Cash Balance 6,406,282 5,411,667 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 $895,767, Utility vehicle used at WWTP $13,131, Sewer Dept vehicles & equipment $444,223. Form 3 E:A Form 3 83 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Month June Fund /Department Number 643 Date Updated 7/6/2015 Current Current 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 3,895 12,157 6,556 - 2,843 81% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 256,612 - 256,086 129,964 - 526 100% Total Revenue 271,612 3,895 268,243 136,520 - 3,369 99% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 3,895 10,182 6,556 - 4,818 68% Total Expenditures 15,000 3,895 10,182 6,556 - 4,818 68% Net 256,612 - 258,061 129,964 - (1,449) Cash Balance 3,678,649 3,422,564 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing 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 83 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Month June Fund /Department Number 647 Date Updated 7/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - 3 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 3 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 805 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 805 - - 0% Net - - - (802) - - Cash Balance 0 338 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 spent /transferred /removed so the fund can be fully closed. Explain Significant Spending on Capital Projects Below: Form 3 84 Form 3 85 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Month June Fund /Department Number 649 Date Updated 7/6/2015 Current Current 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 4,559 9,028 4,588 - (2,028) 129% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,281,088 773,536 4,641,218 4,649,514 - 4,639,871 50% Total Revenue 9,288,088 778,095 4,650,245 4,654,102 - 4,637,843 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,500 - 2,600 2,100 - (100) 104% Debt Service 9,279,609 1,288,842 1,589,361 1,672,252 - 7,690,248 17% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,282,109 1,288,842 1,591,961 1,674,352 - 7,690,148 17% Net 5,979 (510,747) 3,058,284 2,979,750 Cash Balance 3,848,620 3,762,556 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 85 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Month June Fund /Department Number 653 Date Updated 7/6/2015 Current Current 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 86 Form 3 87 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Month June Fund /Department Number 658 Date Updated 7/6/2015 Current Current 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,220 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 spent /transferred /removed so the fund can be closed. Explain Significant Spending on Capital Projects Below: Form 3 87 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 Month June Fund /Department Number 659 Date Updated 7/6/2015 Current Current 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 550 3,378 14,021 2,622 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 550 3,378 14,021 - 2,622 56% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 323,670 - 7,813 1,764 9,857 306,001 5% Debt Service - - - - - - 0% Capital 3,388,168 - 1,077,545 2,491,143 442,920 1,867,703 45% Transfers Out - - - - - - 0% Total Expenditures 3,711,838 - 1,085,357 2,492,907 452,777 2,173,704 41% Net (3,705,838) 550 (1,081,979) (2,478,886) (452,777) (2,171,081) Cash Balance 517,406 5,369,613 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 its 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 88 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Month June Fund /Department Number 661 Date Updated 7/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 40,000 17,033 56,066 34,713 - (16,066) 140% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 40,000 17,033 56,066 34,713 - (16,066) 140% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,000,000 - - - - 1,000,000 0% Debt Service - - - - - - 0% Capital 15,624,275 245,591 1,151,836 513,294 2,609,288 11,863,151 24% Transfers Out - - - - - - 0% Total Expenditures 16,624,275 245,591 1,151,836 513,294 2,609,288 12,863,151 23% Net (16,584,275) (228,558) (1,095,770) (478,581) (2,609,288) (12,879,217) Cash Balance 15,723,495 17,820,445 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 $118,459, Fairfax Sewer $70,022, East Bank Sewer Separation -Phase 5 $413,589, Sewer Sensory Control Network $176,941, Southwood Sewer Separation $15,838, Wastewater Treatment Plant Grit /Screening Improvements $111,491, Secondary Clarifier Modifications $235,558, and misc other $2,070. Form 3 89 2015 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund Month June Fund /Department Number 664 Date Updated 7/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 50 5 15 9 - 35 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 50 5 15 9 - 35 30% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 50 5 15 9 - 35 Cash Balance 4,496 4,476 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 1!I0: 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Month June Fund /Department Number 670 Date Updated 7/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 1,313,436 - 656,725 656,725 - 656,711 50% Grants /Intergovernmental - - - - - - 0% Charges for Services 2,490,815 268,954 1,012,858 841,945 - 1,477,957 41% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 15,000 - - 36,214 - 15,000 0% Transfers In - - - - - - 0% Total Revenue 3,819,251 268,954 1,669,583 1,534,885 - 2,149,668 44% Expenditures Personnel 2,505,817 176,508 977,776 1,014,786 - 1,528,041 39% Supplies 496,646 63,530 262,401 234,761 - 234,245 53% Services 1,286,148 122,320 670,345 623,958 - 615,803 52% Debt Service - - - - - - 0% Capital 243,951 - - 338,301 - 243,951 0% Transfers Out - - - - - - 0% Total Expenditures 4,532,562 362,358 1,910,521 2,211,806 - 2,622,041 42% Net (713,311) (93,404) (240,938) (676,921) - (472,373) Cash Balance 1,106,150 418,964 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 10 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Month June Fund /Department Number 671 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 106 270 145 - 230 54% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 106 270 145 - 230 54% Expenditures Personnel - - - - - - 0% Supplies 53,356 - 41,156 - - 12,200 77% Services 192,000 130,000 130,000 - - 62,000 68% Debt Service - - - - - - 0% Capital 310,300 440 25,440 - - 284,860 8% Transfers Out 50,000 - 50,000 - - - 100% Total Expenditures 605,656 130,440 246,596 - - 359,060 41% Net (605,156) (130,333) (246,325) 145 - (358,831) Cash Balance 1,172,337 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 MA Form 3 1*x1 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Energy Conservation Debt Svc Month June Fund /Department Number 672 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 7 7 - - (7) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 50,000 - 50,000 - - - 100% Total Revenue 50,000 7 50,007 - - (7) 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 50,000 7 50,007 - - (7) Cash Balance 50,007 - 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*x1 Form 3 ME 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month June Fund /Department Number 222 Date Updated 7/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 8,069,157 578,772 3,830,241 3,630,201 - 4,238,916 47% Interest Earnings 3,400 1,215 4,196 2,217 - (796) 123% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 78,627 4,308 46,399 103,463 - 32,228 59% Transfers In - - - - - - 0% Total Revenue 8,151,184 584,295 3,880,836 3,735,881 - 4,270,348 48% Expenditures Personnel 3,099,267 204,528 1,316,086 1,294,720 1,783,181 42% Supplies 167,428 18,844 61,374 62,223 31,707 74,347 56% Services 4,611,385 333,527 2,303,190 2,240,529 1,404,548 903,647 80% Debt Service 9,155 3,248 3,248 5,907 35% Capital 141,157 120,000 20,857 300 100% Transfers Out 271,850 - - - - 271,850 0% Total Expenditures 8,300,242 556,899 3,803,897 3,600,719 1,457,112 3,039,233 63% Net (149,058) 27,396 76,939 135,162 (1,457,112) 1,231,115 Cash Balance 1,635,155 1,659,661 Staffing Full Time 42.00 39.00 39.00 Part -Time /Seasonal /Temporary 2.00 2.00 2.00 Total 44.00 41.00 41.00 Explain Significant Revenue, Expenditure and Staffing 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 June we had 1,391 vehicle repairs. Average Fuel prices for June is $2.26 for Unleaded and $2.24 for Diesel. Budgeted amount per gallon is $3.45. Explain Significant Spending on Capital Projects Below: The capital expenses for 2015 were moved to a new Fund #224 for $271,850. We are transfering monies out of our cash reserve over to fund 224 to cover our 2015 capital expenses. We had $120,000 roll over from 2014 to 2015 for capital expenses to converting our garage so we can work on CNG vehicles. Form 3 ME 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Capital Month June Fund /Department Number 224 Date Updated 7/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 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:17 Form 3 Xt, 2015 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance Month June Fund /Department Number 226 Date Updated 7/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,222,727 104,502 611,384 1,426,707 - 611,344 50% Interest Earnings 20,500 5,355 18,235 9,886 - 2,265 89% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 2,375 2,375 47,667 - 14,625 14% Transfers In - - - - - - 0% Total Revenue 1,260,227 112,231 631,994 1,484,260 - 628,233 50% Expenditures Personnel 314,491 15,373 112,992 89,150 - 201,499 36% Supplies 30,189 732 16,928 7,616 6,101 7,160 76% Services 2,712,111 512,535 1,577,119 1,439,011 39,946 1,095,047 60% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,056,791 528,641 1,707,038 1,535,777 46,047 1,303,706 57% Net (1,796,564) (416,409) (1,075,044) (51,517) (46,047) (675,473) Cash Balance 4,605,548 5,133,980 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. Position vacancy, due to retirement, has not yet been filled. Explain Significant Spending on Capital Projects Below: No capital expenditures are budgeted in 2015. Form 3 Xt, 2015 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Month June Fund /Department Number 278 Date Updated 7/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 61,100 4,560 30,200 30,630 - 30,900 49% Interest Earnings 2,000 598 1,839 918 - 161 92% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 61,100 4,560 30,200 30,523 - 30,900 49% Transfers In - - - - - - 0% Total Revenue 124,200 9,718 62,239 62,071 - 61,961 50% 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,718 62,239 62,071 - (9,139) Cash Balance 578,251 515,024 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 IM 2015 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits Month June Fund /Department Number 711 Date Updated 7/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 16,315,000 1,195,201 7,269,862 6,425,442 - 9,045,138 45% Interest Earnings 23,345 5,007 15,397 10,939 - 7,948 66% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,425 - 19,399 11,099 - 26 100% Transfers In - - - - - - 0% Total Revenue 16,357,770 1,200,207 7,304,658 6,447,480 - 9,053,112 45% Expenditures Personnel 4,326 1 5 - - 4,321 0% Supplies 21,875 3,023 4,637 27,783 2,801 14,437 34% Services 844,520 53,494 394,265 314,529 171,208 279,047 67% Insurance 15,826,214 917,363 6,266,605 6,744,682 32,138 9,527,471 40% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 16,696,935 973,880 6,665,513 7,086,994 206,146 9,825,276 41% Net (339,165) 226,327 639,145 (639,514) (206,146) (772,164) Cash Balance 4,708,848 5,021,933 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*x1 Form 3 1*111 2015 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Month June Fund /Department Number 713 Date Updated 7/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 112,996 8,473 50,840 51,182 - 62,156 45% Interest Earnings 800 257 821 485 - (21) 103% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 113,796 8,731 51,662 51,668 - 62,134 45% Expenditures Personnel 200,000 5,117 35,901 79,759 - 164,099 18% Supplies - - - - - - 0% Services 26,796 566 12,198 3,612 11,000 3,598 87% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 226,796 5,683 48,099 83,371 11,000 167,697 26% Net (113,000) 3,047 3,563 (31,704) (11,000) (105,563) Cash Balance 244,733 228,326 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 1*111 Form 3 `[1111 2015 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension Month June Fund /Department Number 701 Date Updated 7/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,036,025 2,518,013 2,518,013 2,564,549 - 2,518,012 50% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,500 - 872 711 - 3,628 19% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,000 - 3,743 - - 257 94% Transfers In - - - - - - 0% Total Revenue 5,044,525 2,518,013 2,522,628 2,565,260 - 2,521,897 50% Expenditures Personnel 5,661,579 430,271 2,628,581 2,725,378 - 3,032,998 46% Supplies 200 - - - - 200 0% Services 4,800 3,095 3,460 337 - 1,340 72% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,666,579 433,366 2,632,041 2,725,715 - 3,034,539 46% Net (622,054) 2,084,647 (109,413) (160,455) - (512,641) Cash Balance 529,892 777,645 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 `[1111 Form 3 `1121 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Pension Month June Fund /Department Number 702 Date Updated 7/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 6,375,359 3,187,679 3,187,679 3,055,933 - 3,187,680 50% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 1,546 1,632 - 4,454 26% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,000 - - - - 4,000 0% Transfers In - - - - - - 0% Total Revenue 6,385,359 3,187,679 3,189,225 3,057,565 - 3,196,134 50% Expenditures Personnel 6,827,035 523,078 3,201,278 3,482,877 - 3,625,757 47% Supplies 800 - - - - 800 0% Services 4,400 3,096 3,388 319 - 1,012 77% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,832,235 526,174 3,204,666 3,483,196 - 3,627,569 47% Net (446,876) 2,661,505 (15,441) (425,631) - (431,435) Cash Balance 1,095,332 1,283,026 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 2016, the payments are expected to be $3,062,500 by 1 July and again by 1 October, totaling $6,125,000. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Form 3 `1121 2015 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Month June Fund /Department Number 730 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 30 97 71 - 53 64% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 150 30 97 71 - 53 64% 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) 30 97 71 - (19,947) Cash Balance 28,474 37,005 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 102 Form 3 103 2015 City of South Bend Monthly Financial Report Fund /Department Name River West Development Area Airport TIF Month June Fund /Department Number 324 1 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 16,433,274 9,396,168 9,396,168 7,521,012 - 7,037,106 57% Local Income Taxes - - - - - - 0% Other Taxes 490,500 - 292,000 - - 198,500 60% Grants /Intergovernmental - - - - - - 0% Charges for Services 18,000 - 14,061 - - 3,939 78% Interest Earnings 102,096 37,897 124,520 44,766 - (22,424) 122% Bond Proceeds - - - 101,267 - - 0% Donations - - - - - - 0% Other Income 2,937,336 93,560 1,690,191 7 - 1,247,145 58% Transfers In 4,963,040 22,682 4,979,607 2,006 - (16,567) 100% Total Revenue 24,944,246 9,550,307 16,496,547 7,669,058 - 8,447,699 66% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 7,729,770 678,415 1,989,305 1,669,904 1,506,386 4,234,079 45% Debt Service 6,475,584 43,175 3,596,446 1,399,106 - 2,879,138 56% Capital 33,505,243 307,001 1,998,507 45,889 13,401,695 18,105,041 46% Transfers Out - - - - - - 0% Total Expenditures 47,710,597 1,028,591 7,584,258 3,114,899 14,908,081 25,218,258 47% Net (22,766,351) 8,521,716 8,912,289 4,554,159 (14,908,081) (16,770,559) Cash Balance 40,392,072 29,574,289 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 boundary, this area now includes the former Central Medical District (Fund 426) and a portion of South Bend Central Development Area (Fund 420). The appropriate 2015 budgets, revenues and expenses for these funds have been transferred into this fund. 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 103 Form 3 `1171 2015 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown Month June Fund /Department Number 420 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - 2,485,266 - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - 200,000 - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - 18,858 - - 0% Interest Earnings - - - 22,418 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 150,729 - - 0% Transfers In - - - 3,351 - - 0% Total Revenue - - - 2,880,622 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 249,931 - - 0% Debt Service - - - 1,531,010 - - 0% Capital - - - 15,336 - - 0% Transfers Out 4,088,473 - 4,088,473 - - - 100% Total Expenditures 4,088,473 - 4,088,473 1,796,277 - - 100% Net (4,088,473) - (4,088,473) 1,084,345 - - Cash Balance - 3,688,819 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 `1171 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Month June Fund /Department Number 422 1 Date Updated 7/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 420,000 195,866 195,866 304,152 - 224,134 47% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,800 1,237 3,956 1,163 - (1,156) 141% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 422,800 197,103 199,822 305,315 - 222,978 47% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 30,600 - 30,294 319 3,366 (3,060) 110% Debt Service - - - - - - 0% Capital 730,300 - - - - 730,300 0% Transfers Out - - - - - - 0% Total Expenditures 760,900 - 30,294 319 3,366 727,240 4% Net (338,100) 197,103 169,528 304,996 (3,366) (504,262) Cash Balance 1,365,277 917,958 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 KIM Form 3 `IIII 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Month June Fund /Department Number 425 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 300 174 466 173 - (166) 155% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 189,123 15,686 86,977 79,830 - 102,146 46% Transfers In - - - - - - 0% Total Revenue 189,423 15,860 87,443 80,003 - 101,980 46% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 154,716 17,590 70,421 55,961 - 84,295 46% Debt Service - - - - - - 0% Capital - - - 14,353 - - 0% Transfers Out - - - - - - 0% Total Expenditures 154,716 17,590 70,421 70,314 - 84,295 46% Net 34,707 (1,730) 17,022 9,689 - 17,685 Cash Balance 189,548 142,755 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 `IIII Form 3 `[1yA 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Month June Fund /Department Number 426 Date Updated 7/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 - - - 459,659 - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - 5,461 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 465,120 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 1,543,685 - - 0% Debt Service - - - - - - 0% Capital - - - 185,830 - - 0% Transfers Out 2,294,533 - 2,294,533 - - 100% Total Expenditures 2,294,533 - 2,294,533 1,729,515 - - 100% Net (2,294,533) - (2,294,533) (1,264,395) - - Cash Balance - 1,968,018 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 `[1yA Form 3 `[IN 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Development Area NE Dev TIF Month June Fund /Department Number 429 1 Date Updated 7/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 2,342,330 1,391,012 1,391,012 808,184 - 951,318 59% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 37,000 6,229 18,630 5,774 - 18,370 50% 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,397,241 2,859,964 813,958 - 969,689 75% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 126,044 6,448 62,529 1,475 54,560 8,955 93% Debt Service - - - - - - 0% Capital 7,113,480 152 83,018 - 234,231 6,796,231 4% Transfers Out - - - - - - 0% Total Expenditures 7,239,524 6,600 145,547 1,475 288,791 6,805,186 6% Net (3,409,871) 1,390,641 2,714,417 812,483 (288,791) (5,835,497) Cash Balance 7,270,898 3,821,274 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 `[IN 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 Month June Fund /Department Number 430 Date Updated 7/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 2,400,000 1,298,974 1,298,974 1,268,946 - 1,101,026 54% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10,750 4,655 15,329 6,343 - (4,579) 143% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,410,750 1,303,629 1,314,303 1,275,289 - 1,096,447 55% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 669,885 28,834 157,433 139,345 492,554 19,898 97% Debt Service - - - - - - 0% Capital 2,172,650 7,650 451,133 206,646 165,790 1,555,727 28% Transfers Out - - - - - - 0% Total Expenditures 2,842,535 36,484 608,566 345,991 658,344 1,575,625 45% Net (431,785) 1,267,145 705,737 929,298 (658,344) (479,178) Cash Balance 5,663,029 4,368,946 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 K11:1 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Month June Fund /Department Number 435 1 Date Updated 7/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 320,000 163,944 163,944 160,947 - 156,056 51% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 750 55 333 504 - 417 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 320,750 163,999 164,277 161,451 - 156,473 51% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,200 - - 160 4,200 - 100% Debt Service 341,189 - 169,620 95,231 - 171,569 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 345,389 - 169,620 95,391 4,200 171,569 50% Net (24,639) 163,999 (5,343) 66,060 (4,200) (15,096) Cash Balance 216,087 360,660 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 `sle] Form 3 "`i 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Residential NE Res TIF Month June Fund /Department Number 436 1 Date Updated 7/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 2,599,000 1,663,572 1,663,572 1,382,498 - 935,428 64% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 - 1,571 2,314 - 3,429 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 211,000 - - - - 211,000 0% Transfers In - - - - - - 0% Total Revenue 2,815,000 1,663,572 1,665,143 1,384,812 - 1,149,857 59% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 3,425,632 - 1,711,589 1,651,718 - 1,714,043 50% Capital - - - 214,573 - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,425,632 - 1,711,589 1,866,291 - 1,714,043 50% Net (610,632) 1,663,572 (46,446) (481,479) - (564,186) Cash Balance 1,659,058 2,072,600 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 "`i 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Month June Fund /Department Number 433 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 252 11 34 36 - 218 13% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 252 11 34 36 - 218 13% 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) 11 34 (15,667) - (5,782) Cash Balance 10,124 10,081 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 ISN Form 3 1§93 2015 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Month June Fund /Department Number 439 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 11,904 4,878 16,621 7,115 - (4,717) 140% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 11,904 4,878 16,621 7,115 - (4,717) 140% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - 64 64 - - (64) 0% Debt Service - - - - - - 0% Capital 5,000,000 292,757 794,759 - 1,969,579 2,235,662 55% Transfers Out - - - - - - 0% Total Expenditures 5,000,000 292,821 794,823 - 1,969,579 2,235,598 55% Net (4,988,096) (287,943) (778,202) 7,115 (1,969,579) (2,240,315) Cash Balance 4,242,359 3,689,710 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 1§93 Form 3 ISO 2015 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Month June Fund /Department Number 454 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,500 401 1,284 727 - 216 86% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 401 1,284 727 - 216 86% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 401 1,284 727 - 216 Cash Balance 378,724 377,099 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 ISO Form 3 IfiN 2015 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations Month June Fund /Department Number 619 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 119,799 - 119,297 773,413 - 502 100% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 119,799 - 119,297 773,413 - 502 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 201,649 19,744 201,228 626,109 - 421 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 201,649 19,744 201,228 626,109 - 421 100% Net (81,850) (19,744) (81,931) 147,304 - 81 Cash Balance - 282,494 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 IfiN 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Month June Fund /Department Number 315 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 1,100 3,529 2,006 - 1,471 71% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 1,100 3,529 2,006 - 1,471 71% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 1,100 2,929 2,006 - 2,071 59% Total Expenditures 5,000 1,100 2,929 2,006 - 2,071 59% Net - - 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 `rill 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Month June Fund /Department Number 317 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,800 536 1,717 973 - 83 95% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,800 536 1,717 973 - 83 95% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,800 536 1,717 973 - 83 Cash Balance 506,620 504,445 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 `SVA 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Month June Fund /Department Number 328 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 1,838 5,896 3,351 - 104 98% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 1,838 5,896 3,351 - 104 98% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 1,838 4,894 3,351 - 1,106 82% Total Expenditures 6,000 1,838 4,894 3,351 - 1,106 82% 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 `sM Form 3 ISM 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Month June Fund /Department Number 432 Date Updated 7/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 - 11,490 11,490 9,175 - (11,490) 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 25,000 5,712 18,951 11,735 - 6,049 76% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 17,202 30,441 20,910 - (5,441) 122% 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) 17,202 (528,828) (333,696) - (137,552) Cash Balance 5,974,027 6,634,990 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 ISM