Loading...
HomeMy WebLinkAbout03-2017 Departmental Financial ReportPeriod Ending: Issued By: City of South Bend Monthly Departmental Financial Report Page Contents 2 Narrative 3 Summaries 7 General Fund 21 Special Revenue Funds 59 Debt Service/Capital Project Funds 73 Enterprise Funds 98 Internal Service Funds 105 Trust Funds 111 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Deputy Chief of Staff Suzanna Fritzberg Common Council Department Heads Fiscal Officers Controller John Murphy Deputy City Controller Jennifer Hockenhull Director of Treasury Rahman Johnson Sr Budget Analyst Amy Shirk March 31, 2017 Administration/Finance March 2017 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 March 31, 2017, total revenue for the year was $61,812,377, 19% of estimated revenue. As of March 31, 2016, total revenue received was $48,260,398 within the same funds. Property taxes are received in June and December each year and are budgeted at $75,958,124 for 2017. Local income tax (LOIT, COIT and EDIT) receipts are budgeted to be $28.36 million in 2017, to be received in monthly installments of $2.37 million. In March 2017, the City received a $1 million Community Crossings grant from INDOT. As of March 31, 2017, total expenditures were $84,638,506 and outstanding encumbrances were $40,304,155, a total of $124,942,661 which represents 31% 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 21% of the amended expenditure budget at the end of the period. Total expenditures, excluding encumbrances, were $69,059,863 as of March 31, 2016. New for 2017, all costs associated with the Department of Innovation & Technology were consolidated into Fund 279, an internal service fund that already accounts for the 311 Call Center budget. Fund 265 was established to account for the receipt of the Community Crossings grant and matching revenue and for the payment of expenditures on eligible projects, per the Indiana State Board of Accounts. Also, several funds were established to integrate the various trustees cash balances into the City’s regular accounting system. 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 John Murphy, City Controller (574) 235-7678, or Jennifer Hockenhull, Deputy City Controller (574) 235-9822. 2 City of South Bend Monthly Department Financial Report REVENUE SUMMARY March 31, 2017 Values Fund Type Dept Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget Balance Percent of Budget City Funds General Fund 58,587,268 1,198,563 3,814,539 3,049,273 54,772,729 7% Special Revenue 102 Rainy Day 60,000 8,937 24,354 22,398 35,646 41% 103 Excess Levy - - - 7 - 0% 201 Parks & Recreation 13,801,132 167,638 670,804 469,975 13,130,328 5% 202 Motor Vehicle Highway 9,934,110 828,325 2,370,074 2,238,165 7,564,036 24% 203 Recreation Nonreverting 1,381,787 213,432 364,134 291,347 1,017,653 26% 209 Studebaker-Oliver Reverting Grants 104,000 34,113 59,981 34,638 44,019 58% 210 Economic Development State Grants 73,512 18,311 18,820 20,246 54,692 26% 211 Department of Community Investment (DCI)2,291,309 39,598 444,475 726,631 1,846,834 19% 212 Dept of Community Investment Grants 3,348,000 42,852 648,018 585,744 2,699,983 19% 216 Police State Seizures 36,000 200 13,612 15,613 22,388 38% 217 Gift, Donation, Bequest 175,800 69,994 121,991 500 53,809 69% 218 Police Curfew Violations 1,000 24 68 119 932 7% 219 Unsafe Building 793,757 26,129 190,283 445,894 603,474 24% 220 Law Enforcement Continuing Education 221,500 30,754 78,364 86,075 143,136 35% 221 Landlord Registration 1,000 1,245 3,775 - (2,775) 378% 227 Loss Recovery 9,000 851 2,322 2,562 6,678 26% 249 Public Safety LOIT 7,473,618 623,084 1,868,809 1,699,376 5,604,809 25% 251 Local Roads & Streets 1,344,000 130,547 325,873 518,440 1,018,127 24% 257 LOIT Special Distribution 1,318,000 156,406 163,011 - 1,154,989 12% 258 Human Rights Federal Grant 165,040 5,975 102,262 131,578 62,778 62% 265 Local Road & Bridge Grant - 1,000,000 2,000,000 - (2,000,000) 0% 271 Eastrace Waterway 22 1 3 3 19 15% 273 Morris PAC / Palais Royale Marketing 18,300 1,132 1,749 4,223 16,551 10% 280 Police Block Grants - 3 9 10 (9) 0% 281 Economic Develop Commission-Revenue Bonds 200 24 66 71 134 33% 289 HAZMAT 10,000 23 63 83 9,937 1% 291 Indiana River Rescue 45,500 12,724 29,145 26,945 16,355 64% 294 Regional Police Academy 22,500 2,023 12,041 16,641 10,459 54% 295 COPS MORE Grant 92,000 946 38,332 17,657 53,668 42% 299 Police Federal Drug Enforcement 32,000 148 459 324 31,541 1% 404 County Option Income Tax 10,963,839 1,163,973 2,956,565 2,673,428 8,007,274 27% 408 Economic Development Income Tax 11,733,257 877,267 3,900,404 2,928,147 7,832,853 33% 410 Urban Development Action Grant 6,110 493 1,353 1,604 4,757 22% 655 Project Releaf 444,556 37,604 112,482 112,040 332,074 25% 705 Police K-9 Unit 2,020 3 7 10 2,013 0% Special Revenue Total 65,902,869 5,494,780 16,523,707 13,070,495 49,379,162 25% City Debt Service 313 Football Hall of Fame Debt Service 938,228 23 79 28,029 938,149 0% 755 South Bend Building Corp 2,643,214 210 1,326,996 - 1,316,218 50% 757 Parks Bond Debt Service 391,482 124 65,287 - 326,195 17% City Debt Service Total 3,972,924 358 1,392,362 28,029 2,580,562 35% Capital Project 377 Professional Sports Development 732,000 115,357 196,222 286,125 535,778 27% 401 Coveleski Stadium Capital 40,200 79 217 207 39,984 1% 403 Zoo Endowment 200 44 119 127 81 60% 405 Park Nonreverting Capital 339,850 571 5,311 2,124 334,539 2% 406 Cumulative Capital Development 476,500 410 1,203 14,608 475,297 0% 407 Cumulative Capital Improvement 435,000 301 150,862 150,801 284,138 35% 412 Major Moves Construction 1,502,472 2,312 602,479 592,176 899,993 40% 416 Morris Performing Arts Center Capital 104,000 13,666 26,766 16,197 77,234 26% 434 Community Revitalization Enhancement District - - - 156 - 0% 450 Palais Royale Historic Preservation 17,100 428 2,522 2,613 14,578 15% 677 Football Hall of Fame Capital 5,000 431 1,181 1,288 3,819 24% Capital Project Total 3,652,322 133,598 986,880 1,066,422 2,665,442 27% Enterprise 287 Emergency Medical Services Capital 1,285,000 3,021 1,806,922 1,314,585 (521,922) 141% 288 Emergency Medical Services Operating 6,350,012 483,650 1,223,192 1,433,562 5,126,820 19% 600 Consolidated Building Fund 3,968,666 154,187 905,999 867,300 3,062,667 23% 601 Parking Garages 1,097,311 91,364 290,418 265,480 806,893 26% 610 Solid Waste Operations 5,782,675 480,834 1,398,446 1,309,415 4,384,229 24% 611 Solid Waste Capital 835,813 100,039 100,458 562,036 735,355 12% 620 Water Works Operations 17,519,334 1,104,250 3,331,584 3,294,987 14,187,750 19% 622 Water Works Capital 15,000 2,167 6,059 7,422 8,941 40% 624 Water Works Customer Deposit 15,000 1,347 3,680 3,895 11,320 25% 625 Water Works Sinking 2,054,891 164,321 493,435 512,245 1,561,456 24% 626 Water Works Bond Reserve 16,000 1,235 3,462 4,143 12,538 22% 629 Water Works Reserve Operations & Maintenance 174,500 2,292 157,307 233,261 17,193 90% 640 Sewer Repair Insurance 621,788 55,305 164,574 159,382 457,214 26% 641 Sewage Works Operations 37,171,904 3,129,813 9,499,477 9,157,085 27,672,427 26% 642 Sewage Works Capital 4,887,000 5,255 415,282 22,105 4,471,718 8% 643 Sewage Works Reserve Operations & Maint.546,755 520,820 527,836 906,418 18,919 97% 649 Sewage Sinking 9,177,024 1,526,979 2,291,357 2,286,075 6,885,667 25% 653 Sewage Debt Service Reserve 4,400 1,176 2,132 637 2,268 48% 659 Sewer Bond 2011 - 45 125 598 (125) 0% 661 Sewer Bond 2012 50,000 2,530 7,111 35,432 42,889 14% 664 2013A Cost of Issuance Fund - - - 12 - 0% 666 2015 Sewer Bond Issuance - - - 85 - 0% 670 Century Center 4,194,311 (225,009) 897,599 1,412,428 3,296,712 21% 671 Century Center Capital 750 74 214 249 536 28% 672 Century Center Energy Conservation Debt Svc 192,297 4 14 12 192,283 0% Enterprise Total 95,960,431 7,605,699 23,526,681 23,788,851 72,433,750 25% Internal Service 222 Central Services 8,308,569 710,659 2,074,725 1,871,950 6,233,844 25% 224 Central Services Capital 287,600 89 246 476 287,354 0% 226 Liability Insurance 3,557,591 245,267 775,164 576,462 2,782,427 22% 278 Take Home Vehicle Police 4,000 660 1,796 28,440 2,204 45% 279 311 Call Center 5,205,034 430,621 1,291,863 117,939 3,913,171 25% 3 City of South Bend Monthly Department Financial Report REVENUE SUMMARY March 31, 2017 Values Fund Type Dept Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget Balance Percent of Budget 711 Self-Funded Employee Benefits 17,795,850 1,500,195 4,475,013 4,144,244 13,320,837 25% 713 Unemployment Compensation 83,000 244 675 3,593 82,325 1% Internal Service Total 35,241,644 2,887,735 8,619,482 6,743,104 26,622,162 24% Trust & Agency 701 Firefighters Pension 5,217,138 - 419 1,061 5,216,719 0% 702 Police Pension 6,136,500 5,915 9,526 2,773 6,126,974 0% 730 City Cemetery 200 25 69 74 131 34% 750 Equipment/Vehicle Leasing 5,500,000 375 673 - 5,499,327 0% 751 Parks Bond Capital 7,500 539 908 - 6,592 12% 753 Smart Streets Bond Capital 17,000 663 1,267 - 15,733 7% Trust & Agency Total 16,878,338 7,518 12,861 3,907 16,865,477 0% City Funds Total 280,195,796 17,328,250 54,876,513 47,750,082 225,319,283 20% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF - River West Development Area (Airport) 22,763,295 87,148 284,201 193,687 22,479,094 1% 422 TIF - West Washington 436,000 1,721 4,629 3,865 431,371 1% 425 TIF - Leighton Plaza (Redevelop Retail) 197,014 10,498 35,160 35,726 161,854 18% 429 TIF - River East Development Area (NE Dev) 3,065,400 11,342 23,968 19,395 3,041,432 1% 430 TIF - Southside Development #1 3,881,127 4,388 572,145 15,537 3,308,982 15% 432 TIF - Southside Development #3 6,000 791 7,921 13,344 (1,921) 132% 435 TIF - Douglas Road 327,858 95 292 317 327,566 0% 436 TIF - River East Residential (NE Res)3,300,903 - 442 213,108 3,300,461 0% Tax Increment Financing Total 33,977,597 115,983 928,758 494,980 33,048,839 3% Redevelopment 433 Redevelopment General 135 7 20 22 115 15% 439 Certified Technology Park - 1,887 5,142 5,887 (5,142) 0% 454 Airport Urban Enterprise Zone 3,900 336 916 978 2,984 23% 754 Industrial Revolving Fund 210,000 21,526 21,526 - 188,474 10% Redevelopment Total 214,035 23,757 27,605 6,887 186,430 13% Debt Service 315 Redevelopment Bond - Airport Taxable 14,000 902 2,474 2,674 11,526 18% 317 Coveleski Debt Service Reserve 5,000 450 1,225 1,309 3,775 25% 328 Redevelopment Bond - Palais Royale 15,000 1,522 4,149 4,467 10,851 28% 752 South Bend Redevelopment Authority 3,868,169 1,236,763 2,009,432 - 1,858,737 52% 756 Smart Streets Debt Service 855,784 263 441 - 855,343 0% 758 Erskine Village Debt Service 3,960,668 82 3,961,780 - (1,112) 100% Debt Service Total 8,718,621 1,239,982 5,979,501 8,449 2,739,120 69% Redevelopment Commission Controlled Funds Total 42,910,253 1,379,721 6,935,864 510,317 35,974,389 16% Grand Total 323,106,049 18,707,971 61,812,377 48,260,398 261,293,672 19% 4 Values Fund Type Department Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Current Encumbrances Budget Balance Percent of Budget City Funds General Fund 101-0101 Mayor's Office 872,923 57,827 174,762 160,919 119 698,042 20% 101-0104 311 Call Center - - - 2,224 - - 0% 101-0401 Administration & Finance 2,476,351 181,407 544,618 401,467 88,275 1,843,458 26% 101-0404 Morris Performing Arts Center 1,271,039 47,613 202,543 252,973 10,948 1,057,548 17% 101-0405 Palais Royale 530,200 10,824 65,884 123,487 11,278 453,039 15% 101-0501 Legal Department 1,158,567 87,565 261,933 230,967 41,008 855,626 26% 101-0602 Engineering 1,445,157 89,641 259,596 241,739 61,239 1,124,322 22% 101-0801 Police Department 29,668,433 2,099,258 6,582,626 5,612,127 985,890 22,099,918 26% 101-0901 Fire Department 21,111,466 1,582,606 4,694,536 4,194,034 259,661 16,157,269 23% 101-0201 City Clerk 536,216 31,600 113,257 100,296 54,870 368,090 31% 101-0301 Common Council 571,148 27,207 110,385 134,745 85,834 374,928 34% 101-0302 WNIT Contract 43,000 - - - 43,000 - 100% 101-0802 Communications Center - - - 369,753 - - 0% 101-1008 Human Rights 425,805 32,484 110,454 84,714 10,778 304,574 28% 101-1201 Code Enforcement - - - 202,164 - - 0% General Fund Total 60,110,305 4,248,032 13,120,592 12,111,609 1,652,900 45,336,813 25% Special Revenue 103 Excess Levy - - - 3,648 - - 0% 201 Parks & Recreation 13,885,317 824,801 2,777,299 2,633,356 785,026 10,322,992 26% 202 Motor Vehicle Highway 11,565,531 585,340 2,210,909 2,384,624 527,079 8,827,543 24% 203 Recreation Nonreverting 1,599,683 45,821 145,021 161,893 280,357 1,174,305 27% 209 Studebaker-Oliver Reverting Grants 539,393 23,072 98,366 42,272 341,027 100,000 81% 210 Economic Development State Grants 509,757 18,003 18,003 1,494,282 437,745 54,009 89% 211 Department of Community Investment (DCI)2,650,376 175,385 544,640 554,921 52,395 2,053,341 23% 212 Dept of Community Investment Grants 5,455,838 21,621 697,447 544,667 1,730,113 3,028,278 44% 216 Police State Seizures 36,000 - - - - 36,000 0% 217 Gift, Donation, Bequest 238,700 - 72,900 - 663 165,138 31% 218 Police Curfew Violations 1,000 - - - - 1,000 0% 219 Unsafe Building 902,746 41,261 164,602 35,278 301,910 436,235 52% 220 Law Enforcement Continuing Education 788,422 197,939 262,547 66,300 57,687 468,188 41% 221 Landlord Registration 1,000 - 10 - - 990 1% 227 Loss Recovery 598,675 7,600 10,945 23,216 162,730 425,000 29% 249 Public Safety LOIT 7,462,645 613,087 1,567,113 1,527,993 - 5,895,532 21% 251 Local Roads & Streets 2,086,544 3,018 217,818 291,688 371,155 1,497,571 28% 257 LOIT Special Distribution 3,757,457 1,050,366 1,093,717 - 533,740 2,130,000 43% 258 Human Rights Federal Grant 201,773 7,767 28,060 36,562 19,271 154,442 23% 265 Local Road & Bridge Grant 2,000,000 - - - - 2,000,000 0% 271 Eastrace Waterway 1,367 - - - - 1,367 0% 273 Morris PAC / Palais Royale Marketing 21,675 878 3,675 - 2,457 15,544 28% 289 HAZMAT 10,431 - 685 - 2,439 7,307 30% 291 Indiana River Rescue 89,349 231 1,904 6,121 31,607 55,838 38% 294 Regional Police Academy 22,500 692 1,137 581 351 21,013 7% 295 COPS MORE Grant 263,767 108,583 122,999 6,669 61,695 79,073 70% 299 Police Federal Drug Enforcement 196,337 13,200 47,537 12,042 - 148,800 24% 404 County Option Income Tax 12,071,593 840,369 3,283,528 3,751,682 1,127,570 7,660,495 37% 408 Economic Development Income Tax 11,559,184 70,750 2,696,517 2,422,410 2,287,385 6,575,281 43% 410 Urban Development Action Grant 126,144 - 30,702 146,068 - 95,442 24% 655 Project Releaf 525,416 3,684 109,300 20,160 876 415,240 21% 705 Police K-9 Unit 2,020 - - - - 2,020 0% 244 Emergency Phone System 33,671 - - - - 33,671 0% 252 Excess Welfare Distribution 8 - - - - 8 0% 292 Police Grants 10,805 1,330 5,392 18,825 27,542 (22,129) 305% Special Revenue Total 79,215,124 4,654,796 16,212,773 16,185,256 9,142,820 53,859,531 32% City Debt Service 313 Football Hall of Fame Debt Service 1,268,999 (3,265) 631,735 636,000 - 637,264 50% 755 South Bend Building Corp 2,643,214 1,437,970 1,437,970 - - 1,205,244 54% 757 Parks Bond Debt Service 391,482 198,566 198,566 - - 192,916 51% City Debt Service Total 4,303,695 1,633,271 2,268,271 636,000 - 2,035,424 53% Capital Project 377 Professional Sports Development 827,955 - 468,440 473,088 - 359,515 57% 401 Coveleski Stadium Capital 30,000 - - 22,000 6,079 23,921 20% 403 Zoo Endowment 49,688 - - - 49,400 288 99% 405 Park Nonreverting Capital 228,024 22,621 85,745 1,948 39,117 103,161 55% 406 Cumulative Capital Development 476,500 - 140,546 169,196 - 335,954 29% 407 Cumulative Capital Improvement 372,250 - 185,125 184,125 - 187,125 50% 412 Major Moves Construction 2,470,708 62 604 351,475 1,575,724 894,380 64% 416 Morris Performing Arts Center Capital 106,144 1,645 2,053 12,931 9,567 94,524 11% 450 Palais Royale Historic Preservation 5,000 - - - - 5,000 0% 677 Football Hall of Fame Capital 81,091 2,574 21,299 27,415 12,751 47,041 42% Capital Project Total 4,647,360 26,901 903,812 1,242,178 1,692,639 2,050,909 56% Enterprise 287 Emergency Medical Services Capital 3,100,377 - 386,396 152,919 1,382,717 1,331,264 57% 288 Emergency Medical Services Operating 6,117,914 401,753 1,196,785 1,327,177 69,923 4,851,207 21% 600 Consolidated Building Fund 3,777,820 257,588 817,664 858,924 77,997 2,882,159 24% 601 Parking Garages 1,247,254 4,482 109,415 229,526 1,004,123 133,716 89% 610 Solid Waste Operations 5,662,910 388,501 1,190,284 1,393,911 327,490 4,145,137 27% 611 Solid Waste Capital 1,135,613 218 433,832 262,258 - 701,781 38% 620 Water Works Operations 17,727,254 1,136,283 3,896,505 3,692,519 847,060 12,983,689 27% 622 Water Works Capital 1,414,466 13,775 303,490 - 109,653 1,001,323 29% 624 Water Works Customer Deposit 15,000 1,347 3,395 1,927 - 11,605 23% 625 Water Works Sinking 2,054,891 321 1,425 724 - 2,053,466 0% 626 Water Works Bond Reserve 16,000 - - 2,050 - 16,000 0% 629 Water Works Reserve Operations & Maintenance 23,000 2,292 5,581 2,894 - 17,419 24% 640 Sewer Repair Insurance 534,509 29,841 124,631 108,604 25,849 384,028 28% 641 Sewage Works Operations 44,542,335 3,747,161 8,815,789 7,956,475 5,293,697 30,432,849 32% 642 Sewage Works Capital 8,040,455 178,442 1,864,759 839,251 1,946,461 4,229,234 47% 643 Sewage Works Reserve Operations & Maint.30,000 4,065 10,225 4,911 - 19,775 34% 649 Sewage Sinking 9,163,754 - 1,500 1,850 - 9,162,254 0% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY March 31, 2017 5 Values Fund Type Department Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Current Encumbrances Budget Balance Percent of Budget City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY March 31, 2017 659 Sewer Bond 2011 51,688 - - - 51,687 1 100% 661 Sewer Bond 2012 3,010,364 113,521 283,471 1,707,327 2,052,748 674,145 78% 666 2015 Sewer Bond Issuance - - - 2,500 - - 0% 670 Century Center 4,194,310 (15,339) 616,165 956,640 - 3,578,145 15% 672 Century Center Energy Conservation Debt Svc 192,297 - - - - 192,297 0% Enterprise Total 112,052,211 6,264,252 20,061,310 19,502,387 13,189,405 78,801,495 30% Internal Service 222 Central Services 8,564,643 561,962 1,940,960 1,821,890 2,422,666 4,201,017 51% 224 Central Services Capital 326,025 - 14,585 23,369 30,403 281,038 14% 226 Liability Insurance 3,587,586 148,890 505,578 435,308 226,755 2,855,254 20% 278 Take Home Vehicle Police 10,000 - 972 53 - 9,028 10% 279 311 Call Center 5,205,034 205,525 737,935 118,119 521,614 3,945,485 24% 711 Self-Funded Employee Benefits 17,803,200 951,392 3,354,619 4,014,463 928,225 13,520,357 24% 713 Unemployment Compensation 84,105 4,389 18,468 14,567 11,000 54,637 35% Internal Service Total 35,580,593 1,872,158 6,573,116 6,427,769 4,140,662 24,866,816 30% Trust & Agency 701 Firefighters Pension 5,098,269 396,201 1,181,165 1,236,364 - 3,917,104 23% 702 Police Pension 6,423,889 523,297 1,547,536 1,696,645 - 4,876,353 24% 730 City Cemetery 6,000 - - - - 6,000 0% 750 Equipment/Vehicle Leasing 5,500,000 489,584 1,472,626 - - 4,027,374 27% 751 Parks Bond Capital 3,500,000 211,200 274,356 - - 3,225,644 8% 753 Smart Streets Bond Capital 10,000,000 285,891 1,272,543 - - 8,727,457 13% Trust & Agency Total 30,528,158 1,906,174 5,748,226 2,933,009 - 24,779,932 19% City Funds Total 326,437,446 20,605,582 64,888,100 59,038,209 29,818,426 231,730,920 29% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF - River West Development Area (Airport)39,618,887 1,434,861 5,906,309 7,267,599 6,836,928 26,875,650 32% 422 TIF - West Washington 1,428,292 2,420 2,420 6,827 516,114 909,758 36% 425 TIF - Leighton Plaza (Redevelop Retail)158,166 4,480 18,923 15,986 - 139,243 12% 429 TIF - River East Development Area (NE Dev)10,602,696 101,171 173,959 97,847 2,402,597 8,026,141 24% 430 TIF - Southside Development #1 6,917,426 17,419 176,073 297,025 725,891 6,015,462 13% 432 TIF - Southside Development #3 4,878,795 - 3,961,667 365,835 - 917,128 81% 435 TIF - Douglas Road 344,216 - 150,000 140,000 4,200 190,016 45% 436 TIF - River East Residential (NE Res)3,430,231 - 1,683,089 1,684,089 - 1,747,142 49% Tax Increment Financing Total 67,378,709 1,560,351 12,072,439 9,875,208 10,485,729 44,820,541 33% Redevelopment 433 Redevelopment General 4,500 - - - - 4,500 0% 439 Certified Technology Park - - - 142,913 - - 0% 454 Airport Urban Enterprise Zone 50,000 - - - - 50,000 0% 754 Industrial Revolving Fund 157,000 14,437 14,437 - - 142,563 9% Redevelopment Total 211,500 14,437 14,437 142,913 - 197,063 7% Debt Service 315 Redevelopment Bond - Airport Taxable 14,000 902 2,282 1,323 - 11,718 16% 328 Redevelopment Bond - Palais Royale 15,000 1,522 3,828 2,211 - 11,172 26% 752 South Bend Redevelopment Authority 4,603,405 2,004,503 2,739,739 - - 1,863,666 60% 756 Smart Streets Debt Service 855,784 394,784 394,784 - - 461,000 46% 758 Erskine Village Debt Service 4,521,918 3,961,668 4,522,897 - - (979) 100% Debt Service Total 10,010,107 6,363,379 7,663,530 3,534 - 2,346,577 77% Redevelopment Commission Controlled Funds Total 77,600,316 7,938,167 19,750,406 10,021,654 10,485,729 47,364,181 39% Grand Total 404,037,762 28,543,749 84,638,506 69,059,863 40,304,155 279,095,101 31% 6 Department Name Fund/Dept No.101-0101 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 872,323 57,827 174,762 160,614 - 697,561 20% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - - 305 - 600 0% Transfers In - - - - - - 0% Total Revenue 872,923 57,827 174,762 160,919 - 698,161 20% Expenditures Personnel 704,849 47,034 139,156 139,030 - 565,693 20% Supplies 3,119 - 167 722 119 2,833 9% Services 164,955 10,793 35,292 21,019 - 129,663 21% Debt Service - - 147 147 - (147) 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 872,923 57,827 174,762 160,919 119 698,042 20% Net - - - - (119) 119 Cash Balance - - Staffing Budget Actual Full Time 7.00 7.00 Part-Time /Seasonal/Temporary 2.00 1.00 Total 9.00 8.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Leading the community to become a model city through formulating policy, directing operations, and responding to customer concerns. The Mayor is the elected chief executive officer of the city. Increase over 2016 due mainly to the increase in Interfund Allocations for IT which allow for all departments to see the full cost of IT and other administration functions that they would not have seen in the past. Also, health insurance rose approximately 8% per employee. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Mayor's Office General Fund City Funds Form 3 7 Department Name Fund/Dept No.101-0104 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 2,224 - - 0% Transfers In - - - - - - 0% Total Revenue - - - 2,224 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - 1,629 - - 0% Services - - - 595 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 2,224 - - 0% Net - - - - - - Cash Balance - - Department Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: In 2013, the Central 311 Call Center was established to handle citizen telephone calls in an efficient and effective manner. It provides citizens with a "one-stop" shop to contact city departments with inquiries and service requests. In 2016, the budget was moved to a new internal service fund (Fund 279). City of South Bend, Indiana Monthly Financial Report March 31, 2017 311 Call Center General Fund City Funds Form 3 8 Department Name Fund/Dept No.101-0201 Fund Type Date Updated 4/17/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 536,216 31,600 113,257 100,296 - 422,959 21% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 536,216 31,600 113,257 100,296 - 422,959 21% Expenditures Personnel 349,234 24,695 74,363 77,603 - 274,871 21% Supplies 7,800 839 1,261 3,801 2,161 4,378 44% Services 179,182 6,066 37,633 18,892 52,709 88,840 50% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 536,216 31,600 113,257 100,296 54,870 368,090 31% Net - - - - (54,870) 54,870 Cash Balance - - Staffing Budget Actual Full Time 5.00 5.00 Part-Time /Seasonal/Temporary - - Total 5.00 5.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: We ensure the integrity and accuracy of City records, and liaise between the Common Council, City Administration and South Bend residents fostering relationships and common ground. We accomplish our mission by: - Serving as a responsible steward of information and historical artifacts - Empowering the community to engage - Supporting open and transparent government - Striving for the highest degree of excellence in customer service Expenditures are in line with budgeted expectations for 2017, encumbrances from 2016 account for the large differences. City of South Bend, Indiana Monthly Financial Report March 31, 2017 City Clerk General Fund City Funds Form 3 9 Department Name Fund/Dept No.101-0301 Fund Type Date Updated 4/17/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 571,148 27,207 110,385 134,745 - 460,763 19% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 571,148 27,207 110,385 134,745 - 460,763 19% Expenditures Personnel 304,402 22,607 68,191 66,735 112 236,099 22% Supplies 4,503 176 195 5,238 689 3,620 20% Services 262,243 4,423 42,000 62,772 85,034 135,209 48% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 571,148 27,207 110,385 134,745 85,834 374,928 34% Net - - - - (85,834) 85,834 Cash Balance - - Staffing Budget Actual Full Time 9.00 9.00 Part-Time /Seasonal/Temporary - - Total 9.00 9.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The fiscal body of the City, which exists to make certain that our City Government is always responsive to the needs of our residents & that the betterment of South Bend is always our highest priority. There are nine (9) Council Members. Last year, expenditures higher than normal in the services category due to unforseen legal expenses. Encumbrances from 2016 account for the large differences. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Common Council General Fund City Funds Form 3 10 Department Name Fund/Dept No.101-0302 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 43,000 - - - - 43,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 43,000 - - - - 43,000 0% 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 - - - - (43,000) 43,000 Cash Balance - - Department Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: In 2012 the City, along with the City of Mishawaka and St. Joseph County, entered into an agreement with WNIT Public Television for the establishment and maintenance of a public access channel which is used to broadcast all public Common Council meetings, among other things. The allocation of costs is $43,000 to South Bend, $13,000 to Mishawaka and $29,000 to Saint Joseph County. The current WNIT contract expires February 1, 2017. This annual expenditure was previously paid from the Council department (101-0301) but was segregated upon the Council's request. City of South Bend, Indiana Monthly Financial Report March 31, 2017 WNIT Contract General Fund City Funds Form 3 11 Department Name Fund/Dept No.101-0401 Fund Type Date Updated 4/19/2017 Control Current Current 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,464,301 181,399 532,356 387,919 - 1,931,945 22% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 12,050 8 12,262 13,548 - (212) 102% Transfers In - - - - - - 0% Total Revenue 2,476,351 181,407 544,618 401,467 - 1,931,733 22% Expenditures Personnel 2,053,815 146,912 437,998 363,787 - 1,615,817 21% Supplies 25,158 656 5,246 5,177 9,058 10,854 57% Services 392,299 33,840 100,105 31,233 79,217 212,977 46% Debt Service 5,079 - 1,269 1,269 - 3,810 25% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,476,351 181,407 544,618 401,467 88,275 1,843,458 26% Net - - - - (88,275) 88,275 Cash Balance - - Staffing Budget Actual Full Time 23.00 22.00 Part-Time /Seasonal/Temporary - - Total 23.00 22.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Provide financial management and administrative services to City operations including finance and accounting services, human resources, risk management, benefit administration, and purchasing management. The larges encumbrances for services is related to an outstanding contract for diversity consulting. The HR Generalist position was filled in March 2017. The Director of Human Resources position is still vacant, but expected to be filled in April 2017. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Administration & Finance General Fund City Funds Form 3 12 Department Name Fund/Dept No.101-0404 Fund Type Date Updated 4/13/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 306,039 (136,359) (79,050) 31,595 - 385,089 -26% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services 463,000 63,178 136,657 75,669 - 326,343 30% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 502,000 120,793 144,936 145,710 - 357,064 29% Transfers In - - - - - - 0% Total Revenue 1,271,039 47,613 202,543 252,973 - 1,068,496 16% Expenditures Personnel 510,299 20,024 106,364 174,606 - 403,935 21% Supplies 7,697 91 2,660 2,347 2,095 2,942 62% Services 753,043 27,498 93,519 76,020 8,853 650,671 14% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,271,039 47,613 202,543 252,973 10,948 1,057,548 17% Net - - - - (10,948) 10,948 Cash Balance - - Staffing Budget Actual Full Time 6.60 6.00 Part-Time /Seasonal/Temporary 4.00 4.00 Total 10.60 10.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This department accounts for the operating costs of the Morris Performing Arts Center, the Premier Performing Arts Center in this region of the country. It provides improved quality of life to the City citizens, serves as an economic catalyst in the City, and fosters historic preservation of landmark City venues. Starting with 2017, the position of Executive Administrative Assistant was replaced with Operations Manager. 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Morris Performing Arts Center General Fund City Funds Form 3 13 Department Name Fund/Dept No.101-0405 Fund Type Date Updated 4/13/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 171,298 (2,285) 17,165 97,663 - 154,133 10% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services 332,072 11,196 44,812 19,767 - 287,260 13% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 26,830 1,912 3,906 6,057 - 22,924 15% Transfers In - - - - - - 0% Total Revenue 530,200 10,824 65,884 123,487 - 464,316 12% Expenditures Personnel 142,131 766 22,729 62,037 - 119,402 16% Supplies 3,398 - 794 7,730 1,204 1,400 59% Services 384,671 10,058 42,361 53,720 10,074 332,236 14% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 530,200 10,824 65,884 123,487 11,278 453,039 15% Net - - - - (11,278) 11,278 Cash Balance - - Staffing Budget Actual Full Time 2.40 1.00 Part-Time /Seasonal/Temporary - 1.00 Total 2.40 2.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This department accounts for the operating expenses of the Palais Royale, a premier banquet/meeting facility. It provides exquisite food and beverage catering service, for both social events and business events, and supports South Bend's downtown economy. The Palais Royale is distinguished by its history and ambiance. One employee in a Full Time position is in FMLA. A temporary part time employee was hired to help with the day to day operations and event set up, tear down, while the Full Time Position is in FMLA. Capital projects for the Palais Royale are located in the Palais Royale Historic Preservation Fund #450. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Palais Royale General Fund City Funds Form 3 14 Department Name Fund/Dept No.101-0501 Fund Type Date Updated 4/19/2017 Control Current Current 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,083,190 87,565 243,458 230,967 - 839,732 22% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 75,377 - 18,475 - - 56,902 25% Transfers In - - - - - - 0% Total Revenue 1,158,567 87,565 261,933 230,967 - 896,634 23% Expenditures Personnel 966,603 71,426 223,030 219,703 - 743,573 23% Supplies 5,977 2,711 2,875 413 415 2,687 55% Services 184,715 13,428 35,710 10,534 40,593 108,412 41% Debt Service 1,272 - 318 318 - 954 25% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,158,567 87,565 261,933 230,967 41,008 855,626 26% Net - - - - (41,008) 41,008 Cash Balance - - Staffing Budget Actual Full Time 10.00 10.00 Part-Time /Seasonal/Temporary 1.00 1.00 Total 11.00 11.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The Legal Department provides quality legal representation to the City of South Bend’s Mayor, departments, commissions and agencies with a dedicated and professionally-skilled staff, efficiently and cost effectively, in furtherance of the City’s strategic goals, and preserving the legal and ethical integrity of the City. Encumbrances are related to the office remodel project to be completed early 2017. A majority of the supplies budget is already expended due to the purchasing of new furniture for the office renovation. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Legal Department General Fund City Funds Form 3 15 Department Name Fund/Dept No.101-0602 Fund Type Date Updated 4/19/2017 Control Current Current 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,127,820 77,106 207,739 207,695 - 920,081 18% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services 100,000 12,535 51,857 - - 48,143 52% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 217,337 - - 34,044 - 217,337 0% Transfers In - - - - - - 0% Total Revenue 1,445,157 89,641 259,596 241,739 - 1,185,561 18% Expenditures Personnel 841,636 51,623 142,928 144,973 260 698,448 17% Supplies 34,113 985 5,959 27,853 5,146 23,008 33% Services 541,300 34,341 96,436 62,791 55,834 389,031 28% Debt Service 28,108 2,692 14,273 6,120 - 13,835 51% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,445,157 89,641 259,596 241,739 61,239 1,124,322 22% Net - - - - (61,239) 61,239 Cash Balance - - Staffing Budget Actual Full Time 7.93 6.99 Part-Time /Seasonal/Temporary 1.41 0.47 Total 9.34 7.46 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The Engineering Department oversees the design and execution of the City's construction projects. Other income includes reimbursement from the River West TIF for 100% of the salary of an engineer. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Engineering General Fund City Funds Form 3 16 Department Name Fund/Dept No.101-0801 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 29,341,933 2,086,082 6,519,690 5,505,991 - 22,822,243 22% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 7,500 - - - - 7,500 0% Other Income 319,000 13,175 62,935 106,136 - 256,065 20% Transfers In - - - - - - 0% Total Revenue 29,668,433 2,099,258 6,582,626 5,612,127 - 23,085,808 22% Expenditures Personnel 23,671,143 1,746,303 5,267,757 5,073,899 - 18,403,386 22% Supplies 1,231,776 8,870 76,312 52,869 940,995 214,469 83% Services 4,685,514 343,649 1,165,601 483,910 44,895 3,475,018 26% Debt Service 80,000 436 72,956 1,449 - 7,044 91% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 29,668,433 2,099,258 6,582,626 5,612,127 985,890 22,099,918 26% Net - - - - (985,890) 985,890 Cash Balance - - Staffing Budget Actual Full Time 248.00 236.00 Part-Time /Seasonal/Temporary 60.00 5.00 Total 308.00 241.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The South Bend Police Department exists to serve and protect our community with the highest quality emergency services protecting life and property. This fund includes the expenditures for 192 of the 247 budgeted Police officers and 44 full time civilian staff. Fund 249 contains the funding for 43 of the 247 Police officers that are funded by the LOIT. The $924,025 encumbrance amount for Supplies is the cost of replacing video cameras for patrol vehicles. Police cars are leased out of COIT Fund #404. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Police Department General Fund City Funds Form 3 17 Department Name Fund/Dept No.101-0901 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 21,109,966 1,582,606 4,652,163 4,182,872 - 16,457,803 22% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services 500 - - 1,127 - 500 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,000 - 42,373 10,035 - (41,373) 4237% Transfers In - - - - - - 0% Total Revenue 21,111,466 1,582,606 4,694,536 4,194,034 - 16,416,930 22% Expenditures Personnel 17,624,592 1,308,161 3,884,309 3,735,181 10,311 13,729,971 22% Supplies 502,435 31,535 85,160 61,535 70,915 346,360 31% Services 2,984,439 242,910 725,066 397,318 178,435 2,080,938 30% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 21,111,466 1,582,606 4,694,536 4,194,034 259,661 16,157,269 23% Net - - - - (259,661) 259,661 Cash Balance - - Staffing Budget Actual Full Time 180.00 181.00 Part-Time /Seasonal/Temporary - - Total 180.00 181.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The South Bend Fire Department exists to provide our community with the highest quality emergency services protecting life and property through education, response, and dynamic outreach. The South Bend Fire Department is budgeted to have 253 sworn firefighters, 6 recruits and 7 civilian full time employees. 35 firefighters are paid directly through the Public Safety LOIT (Fund 249). 47 Sworn and 4 civilian employees' costs are allocated to EMS Operations (Fund 288). There is a lengthy recruitment process every 2 years. The Fire Department hires individuals in groups of 6-10 as needed. The Fire Department also employs civilian administrative staff who handle payroll, purchasing, and billing for ambulance services. In February, the Fire Department received an insurance reimbursement for a fire truck accident caused by a commercial vehicle. Expenses related to purchasing Fire Department capital equipment and capital improvements are not paid out of the General Fund. All capital projects relating to the Fire Department operations are run through the EMS Capital Fund #287. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Fire Department General Fund City Funds Form 3 18 Department Name Fund/Dept No.101-1008 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 425,805 32,484 110,454 84,714 - 315,351 26% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 425,805 32,484 110,454 84,714 - 315,351 26% Expenditures Personnel 294,036 22,648 80,806 67,967 - 213,230 27% Supplies 1,037 8 153 240 500 384 63% Services 130,732 9,828 29,495 16,507 10,278 90,959 30% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 425,805 32,484 110,454 84,714 10,778 304,574 28% Net - - - - (10,778) 10,778 Cash Balance - - Staffing Budget Actual Full Time 4.00 4.00 Part-Time /Seasonal/Temporary - - Total 4.00 4.00 Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 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 this year in the services category. This is due to a rougly 1,200% increase in allocation costs related to information technology. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Human Rights General Fund City Funds Form 3 19 Department Name Fund/Dept No.101-1201 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - 202,164 - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 202,164 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - 202,164 - - 0% Total Expenditures - - - 202,164 - - 0% Net - - - - - - Cash Balance - - Department Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This department was transferred to the Consolidated Building Fund (600) in 2014. In 2016, $202,164 was transferred to the Unsafe Building Fund 219. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Code Enforcement General Fund City Funds Form 3 20 Fund Name Fund Number 102 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 60,000 8,937 24,354 22,398 - 35,646 41% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 60,000 8,937 24,354 22,398 - 35,646 41% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 60,000 8,937 24,354 22,398 - 35,646 Cash Balance 10,208,727 8,714,505 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used to accumulate cash reserves for unforeseen purposes. This fund receives from time to time certain "catch up" distributions of COIT and EDIT monies from the State that are required to be deposited into this fund. This fund is used for mid-year or year-end advances to other funds that have cash shortages and the advances must be paid back within six months. 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. No expenditures are budgeted in this fund. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Rainy Day Special Revenue City Funds Form 3 21 Fund Name Fund Number 103 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - 7 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 7 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - 3,648 - - 0% Total Expenditures - - - 3,648 - - 0% Net - - - (3,641) - - Cash Balance - 25 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Excess levy distributions of property taxes that are received from the State are deposited here. They are used to reduce future property tax levies. This fund was closed in August 2016. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Excess Levy Special Revenue City Funds Form 3 22 Fund Name Fund Number 201 Fund Type Date Updated 4/14/2017 Control Current Current 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,878,000 - - - - 7,878,000 0% Local Income Taxes - - - - - - 0% Other Taxes 2,085,007 - 353,752 231,567 - 1,731,255 17% Grants/Intergovernmental 315,650 - - - - 315,650 0% Licenses & Permits - - - - - - 0% Charges for Services 2,728,197 159,290 170,897 191,906 - 2,557,300 6% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 10,000 2,796 7,811 9,067 - 2,189 78% Bond Proceeds - - - - - - 0% Donations - - 25,000 - - (25,000) 0% Other Income 158,931 5,552 13,345 37,434 - 145,586 8% Transfers In 625,347 - 100,000 - - 525,347 16% Total Revenue 13,801,132 167,638 670,804 469,975 - 13,130,328 5% Expenditures Personnel 8,386,381 566,042 1,615,885 1,481,947 400 6,770,096 19% Supplies 1,393,820 33,457 123,176 171,907 506,581 764,062 45% Services 3,722,575 223,979 1,007,722 863,488 271,726 2,443,127 34% Debt Service 279,691 1,324 30,516 116,014 6,319 242,857 13% Capital - - - - - - 0% Transfers Out 102,850 - - - - 102,850 0% Total Expenditures 13,885,317 824,801 2,777,299 2,633,356 785,026 10,322,992 26% Net (84,185) (657,163) (2,106,495) (2,163,381) (785,026) 2,807,336 Cash Balance 2,395,770 1,769,327 Staffing Budget Actual Full Time 97.00 95.00 Part-Time /Seasonal/Temporary N/A 54.00 Total 97.00 149.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the operation of the Venues, Parks and Arts (VPA) that are predominantly taxpayer funded. There are six divisions within the department: Administration, Maintenance, Golf, Recreation, Greenhouse, and Graffiti. Part-time staffing is individuals, not FTEs. Property tax and other tax revenues are received in June and December of the year. Charges for Services include intra-City charges such as site mowing and graffiti removal. In 2017, the VPA Maintenance department has assumed responsibility for maintenance of the Morris/Palais building and will receive revenue via a Service Maintenance Agreement, valued at $398K. As part of the process, VPA picked up 3 FTE's from the Morris that are now being paid from this fund. The Cash Balance of this fund is lower than recommended, per the City Cash Reserve Policy, at 17.2% of expected expenditures. The Policy recommends a minimum balance of 25%. This is the normal pattern for this fund. The balance will be up to acceptable levels once the tax revenue has been received. VPA's capital needs are being addressed through a bond that was issued in 2015. Please see Fund 751 for details. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Parks & Recreation Special Revenue City Funds Form 3 23 Fund Name Fund Number 202 Fund Type Date Updated 4/17/2017 Control Current Current Current Prior Amended Month Year to Date 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,650,000 805,688 1,307,841 1,326,910 - 4,342,159 23% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services 223,365 16,474 55,160 49,983 - 168,205 25% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 21,813 4,894 14,264 13,815 - 7,549 65% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 73,958 1,269 1,565 9,207 - 72,393 2% Transfers In 3,964,974 - 991,244 838,250 - 2,973,731 25% Total Revenue 9,934,110 828,325 2,370,074 2,238,165 - 7,564,036 24% Expenditures Personnel 4,585,702 290,026 931,810 953,802 - 3,653,892 20% Supplies 2,639,357 32,126 341,025 652,938 237,372 2,060,960 22% Services 3,544,927 201,551 666,824 595,475 289,708 2,588,395 27% Debt Service 775,545 61,637 271,250 142,951 - 504,295 35% Capital 20,000 - - 39,458 - 20,000 0% Transfers Out - - - - - - 0% Total Expenditures 11,565,531 585,340 2,210,909 2,384,624 527,079 8,827,543 24% Net (1,631,421) 242,985 159,165 (146,459) (527,079) (1,263,507) Cash Balance 6,336,952 5,039,491 Staffing Budget Actual Full Time 55.85 52.35 Part-Time /Seasonal/Temporary 7.68 2.92 Total 63.53 55.27 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the operations of the following departments: Streets, Traffic & Lighting, and Curb & Sidewalk. The major encumbrances were $303k for curb & sidewalk, $225k for road salt, $39k for Corby Blvd Project design services, and $16k for County- City Building van accessible parking. Historically, this fund has received its revenues through gasoline taxes, but since 2008 has also received wheel tax revenues. Currently, it receives transfers from COIT to support the curb and sidewalk program and from EDIT to support street department operations. $20,000 is budgeted for a new printer for the sign shop. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Motor Vehicle Highway Special Revenue City Funds Form 3 24 Fund Name Fund Number 203 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 1,365,787 212,673 360,641 289,175 - 1,005,146 26% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 6,000 758 2,024 2,145 - 3,976 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 10,000 - 1,469 26 - 8,531 15% Transfers In - - - - - - 0% Total Revenue 1,381,787 213,432 364,134 291,347 - 1,017,653 26% Expenditures Personnel 571,393 18,418 62,249 84,570 - 509,144 11% Supplies 326,289 5,577 17,432 27,449 105,224 203,633 38% Services 587,001 21,826 65,340 49,874 175,133 346,527 41% Debt Service - - - - - - 0% Capital 115,000 - - - - 115,000 0% Transfers Out - - - - - - 0% Total Expenditures 1,599,683 45,821 145,021 161,893 280,357 1,174,305 27% Net (217,896) 167,611 219,113 129,454 (280,357) (156,652) Cash Balance 1,029,255 952,095 Staffing Budget Actual Full Time 1.00 1.00 Part-Time /Seasonal/Temporary -32.00 Total 1.00 33.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for recreation programs and events that are self supporting through user fees or sponsorships and donations. This fund is budgeted generally to cover costs of programs. Registration for spring program, classes and softball leagues began in February. Part time employees are individuals, not FTEs. Supplies encumbrances are for annual PO's to suppliers of commodities, such as Sam's Club, and for pool supplies. Services encumbrances are annual PO's for sports referees and contracts for fitness instructors. Capital budget includes $85,000 for Leeper Park tennis court resurfacing and $30,000 for undefined athletics equipment. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Recreation Nonreverting Special Revenue City Funds Form 3 25 Fund Name Fund Number 209 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - 33,398 58,002 31,794 - (58,002) 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 4,000 715 1,979 2,845 - 2,021 49% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 100,000 - - - - 100,000 0% Transfers In - - - - - - 0% Total Revenue 104,000 34,113 59,981 34,638 - 44,019 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 539,393 23,072 98,366 42,272 341,027 100,000 81% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 539,393 23,072 98,366 42,272 341,027 100,000 81% Net (435,393) 11,041 (38,385) (7,633) (341,027) (55,981) Cash Balance 816,700 1,099,568 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used to account for various grants relating to Studebaker/Oliver area and brownfields. Revenues and expenditures in this fund are grant and project specific and will vary from year to year. Brownfield Assessment Grant awarded by EPA for use in South Bend, Mishawaka and St. Joseph County covers the outstanding encumbrance. Consultant work proceeding. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Studebaker-Oliver Reverting Grants Special Revenue City Funds Form 3 26 Fund Name Fund Number 210 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 9,851 2,574 3,083 2,878 - 6,768 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 63,661 15,737 15,737 17,368 - 47,924 25% Transfers In - - - - - - 0% Total Revenue 73,512 18,311 18,820 20,246 - 54,692 26% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 185,120 - - 617,809 185,120 - 100% Debt Service 72,012 18,003 18,003 18,003 - 54,009 25% Capital 252,625 - - 858,470 252,625 - 100% Transfers Out - - - - - - 0% Total Expenditures 509,757 18,003 18,003 1,494,282 437,745 54,009 89% Net (436,245) 308 818 (1,474,035) (437,745) 682 Cash Balance 351,813 (1,299,892) Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established to track the receipt and subsequent expenditure of grants from the State of Indiana. Capital expenditures shown here are for the ND Turbo Project. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Economic Development State Grants Special Revenue City Funds Form 3 27 Fund Name Fund Number 211 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental 440,636 - - 118,805 - 440,636 0% Licenses & Permits - - - - - - 0% Charges for Services 316,000 38,314 60,389 109,773 - 255,611 19% Fines, Forfeitures, and Fees 2,000 245 365 - - 1,635 18% Interest Earnings 10,000 1,039 3,053 3,052 - 6,947 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 2,592 - - 0% Transfers In 1,522,673 - 380,668 492,410 - 1,142,005 25% Total Revenue 2,291,309 39,598 444,475 726,631 - 1,846,834 19% Expenditures Personnel 1,948,112 130,196 395,602 458,959 - 1,552,510 20% Supplies 26,356 700 2,144 4,537 3,182 21,030 20% Services 675,908 44,489 146,894 91,426 49,213 479,801 29% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,650,376 175,385 544,640 554,921 52,395 2,053,341 23% Net (359,067) (135,787) (100,165) 171,710 (52,395) (206,507) Cash Balance 1,262,385 1,297,455 Staffing Budget Actual Full Time 23.00 20.00 Part-Time /Seasonal/Temporary - - Total 23.00 20.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the activities of the Department of Community Investment, formerly known as the Department of Economic Development. Transfers In come from EDIT Fund 408 on a quarterly basis. One position filled in March. The search continues for the Executive Director and one Analyst position also vacant @ 2/28/17. One director position became vacant at end of March and Assistant Director/Business Development Director position will be vacant by end of April. In 2016, a new van was purchased for property inspection work. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Department of Community Investment (DCI) Special Revenue City Funds Form 3 28 Fund Name Fund Number 212 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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,148,000 42,258 578,064 579,662 - 2,569,936 18% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees 1,000 - 20 30 - 980 2% Interest Earnings 2,000 9 190 836 - 1,810 9% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 197,000 585 69,743 5,216 - 127,257 35% Transfers In - - - - - - 0% Total Revenue 3,348,000 42,852 648,018 585,744 - 2,699,983 19% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants & Subsidies 5,455,838 21,621 697,447 544,167 1,730,113 3,028,278 44% Transfers Out - - - 500 - - 0% Total Expenditures 5,455,838 21,621 697,447 544,667 1,730,113 3,028,278 44% Net (2,107,838) 21,231 (49,430) 41,077 (1,730,113) (328,295) Cash Balance 192,497 594,983 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for various grants including Community Development Block Grants (CDBG), Emergency Solutions Grant, Shelter Plus Care, Neighborhood Stabilization Project, etc. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on-going and the timing of funding varies widely. We can only draw revenue in response to funds expended so revenues will come in as funds are spent. The federal government does not allow us to hold too much cash. Expenditures in 2017, as in previous years, will be made by outside not-for-profits for eligible activities such as: Homeownership Assistance; Housing Acquisition/Rehab/Resale; Owner-Occupied Housing Rehab; Spot Blight Clearance; Technical Assistance; Public Services; Public Facility Improvements; Emergency Shelter Operations; Rapid Re-housing; Shelter Plus Supportive Services; and New Housing Construction. All services must either assist low/moderate income households or eliminate slum & blight and/or other requirements specific to the particular grants. The not-for-profits can generally apply for funding for 2018 in the summer of 2017. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Dept of Community Investment Grants Special Revenue City Funds Form 3 29 Fund Name Fund Number 216 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental 35,000 - 13,076 15,083 - 21,924 37% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 1,000 200 536 530 - 464 54% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 36,000 200 13,612 15,613 - 22,388 38% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 36,000 - - - - 36,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 36,000 - - - - 36,000 0% Net - 200 13,612 15,613 - (13,612) Cash Balance 231,217 215,351 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for law enforcement expenditures financed by the authorized state or local agencies sale of confiscated property. This fund's 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Police State Seizures Special Revenue City Funds Form 3 30 Fund Name Fund Number 217 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental 20,000 - - - - 20,000 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 800 84 225 167 - 575 28% Bond Proceeds - - - - - - 0% Donations 155,000 69,910 121,766 333 - 33,234 79% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 175,800 69,994 121,991 500 - 53,809 69% Expenditures Personnel - - - - - - 0% Supplies 8,700 - - - - 8,700 0% Services 230,000 - 72,900 - 663 156,438 32% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 238,700 - 72,900 - 663 165,138 31% Net (62,900) 69,994 49,091 500 (663) (111,328) Cash Balance 165,865 65,373 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for miscellaneous contributions to the City for specific projects and the expenses related to the projects. $350,000 has been budgeted from this fund to help fund public art projects throughout the City. The City wishes to serve as a conduit for this activity and hopes to receive $185,000 in private donations to help fund these projects. This fund is being used to pay for the new sculpture of Dr. Martin Luther King Jr and Father Theodore Hesburgh. The sculpture will be located in Leighton Plaza in downtown South Bend. In March 2017, the Department of Animal Care & Control received a large donation of $23k. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Gift, Donation, Bequest Special Revenue City Funds Form 3 31 Fund Name Fund Number 218 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees 900 13 38 88 - 863 4% Interest Earnings 100 11 30 32 - 70 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,000 24 68 119 - 932 7% 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 - 24 68 119 - (68) Cash Balance 12,631 12,357 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for monies received from Juvenile Positive Assistance. Juvenile Positive Assistance accounts for monies received from penalties paid for curfew violations. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Police Curfew Violations Special Revenue City Funds Form 3 32 Fund Name Fund Number 219 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 214,000 1,672 2,522 47,895 - 211,478 1% Fines, Forfeitures, and Fees - 24,457 42,821 57,566 - (42,821) 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 579,757 - 144,939 340,433 - 434,818 25% Total Revenue 793,757 26,129 190,283 445,894 - 603,474 24% Expenditures Personnel 273,536 20,674 64,695 - - 208,841 24% Supplies 24,959 1,369 4,540 - 1,487 18,932 24% Services 604,251 19,218 95,367 35,278 300,422 208,461 66% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 902,746 41,261 164,602 35,278 301,910 436,235 52% Net (108,989) (15,131) 25,681 410,616 (301,910) 167,240 Cash Balance 397,676 411,141 Staffing Budget Actual Full Time 4.00 4.00 Part-Time /Seasonal/Temporary - - Total 4.00 4.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The Unsafe Building fund is a new fund established in 2016 to receive fines and fees related to Indiana's Unsafe Building law. The costs and expenses incurred in board-ups and other related services are recorded here. This fund accounts for the activities of the Neighborhood Enhancement Activity Team (NEAT) Crew, charged with maintaining property standards regarding property cleanliness and upkeep. The City's mowing and graffiti removal programs are also run through this fund. The NEAT Crew is a subset of Code Enforcement. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Unsafe Building Special Revenue City Funds Form 3 33 Fund Name Fund Number 220 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits 35,000 6,281 14,921 16,910 - 20,079 43% Charges for Services 85,000 13,059 17,843 24,258 - 67,157 21% Fines, Forfeitures, and Fees 86,000 9,574 38,956 25,883 - 47,044 45% Interest Earnings 5,000 691 1,964 2,344 - 3,036 39% Bond Proceeds - - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income 8,500 1,149 4,680 16,680 - 3,820 55% Transfers In - - - - - - 0% Total Revenue 221,500 30,754 78,364 86,075 - 143,136 35% Expenditures Personnel - - - - - - 0% Supplies 318,332 8,805 27,352 1,908 31,426 259,555 18% Services 470,090 189,134 235,196 64,392 26,261 208,633 56% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 788,422 197,939 262,547 66,300 57,687 468,188 41% Net (566,922) (167,184) (184,183) 19,775 (57,687) (325,052) Cash Balance 610,169 910,042 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. During the first quarter of 2017, the majority of expenditures were for travel expenses related to various police training events. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Law Enforcement Continuing Education Special Revenue City Funds Form 3 34 Fund Name Fund Number 221 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits 1,000 1,245 3,775 - - (2,775) 378% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,000 1,245 3,775 - - (2,775) 378% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,000 - 10 - - 990 1% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,000 - 10 - - 990 1% Net - 1,245 3,765 - - (3,765) Cash Balance 4,990 - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the revenues and expenditures related to the Landlord Registration ordinance, enacted by the Common Council in 2016. The proceeds from the registration, $5 per year, will fund Code Enforcement's costs of the program. There is a penalty of $100 to $500 per landlord for failure to comply with the new ordinance. Any revenues from penalties will be used to subsidize the City's Curb and Sidewalk program. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Landlord Registration Special Revenue City Funds Form 3 35 Fund Name Fund Number 227 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 9,000 851 2,322 2,562 - 6,678 26% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 9,000 851 2,322 2,562 - 6,678 26% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 550,333 - 3,345 20,016 121,988 425,000 23% Debt Service - - - - - - 0% Capital 48,342 7,600 7,600 3,200 40,742 - 100% Transfers Out - - - - - - 0% Total Expenditures 598,675 7,600 10,945 23,216 162,730 425,000 29% Net (589,675) (6,749) (8,623) (20,654) (162,730) (418,322) Cash Balance 961,942 972,603 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2008 with the recovery of monies from lawsuits brought about by environmental actions on the Studebaker and Oliver industrial sites. The fund continues to receive, intermittently, monies from similar settlements. The fund is used for capital projects and the Vacant and Abandoned Housing initiative. Services include $350,000 budgeted for Ignition Park land remediation and $70,000 for vacant & abandoned housing. The encumbrances in Services include $50K for the continuation of the vacant & abandoned housing program and $70K for legal services. The capital encumbrance is for costs related to the purchasing of properties along the West Side Corridors (Western & Lincolnway West). These properties are up for tax sale. The City is only purchasing properties which fit into the City’s strategy for future improvement of the corridors. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Loss Recovery Special Revenue City Funds Form 3 36 Fund Name Fund Number 244 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 33,671 - - - - 33,671 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 33,671 - - - - 33,671 0% Net (33,671) - - - - (33,671) Cash Balance 33,671 33,671 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2014 to better track costs related to the City's emergency dispatch center that was funded by State 911 revenue. However, the State mandated consolidation of all dispatch centers within the county the following year. This fund was closed in 2015 with the advent of the county-wide PSAP system. The remaining funds will be used to pay for the county-wide PSAP system in 2017. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Emergency Phone System Special Revenue City Funds Form 3 37 Fund Name Fund Number 249 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 7,467,618 622,302 1,866,905 1,697,790 - 5,600,714 25% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 6,000 783 1,905 1,586 - 4,095 32% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 7,473,618 623,084 1,868,809 1,699,376 - 5,604,809 25% Expenditures Personnel 7,462,645 613,087 1,567,113 1,527,993 - 5,895,532 21% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 7,462,645 613,087 1,567,113 1,527,993 - 5,895,532 21% Net 10,973 9,997 301,696 171,383 - (290,723) Cash Balance 1,242,145 813,318 Staffing Budget Actual Full Time 78.00 68.00 Part-Time /Seasonal/Temporary - - Total 78.00 68.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2010 due to Indiana's property tax "circuit breaker" system that effectively limited property tax receipts. The City has adopted a special income tax of one quarter of one percent (0.25%) to be used solely for the salaries of public safety employees that were formerly paid by property taxes. This fund covered the costs of salaries and fringe benefits for 43 police officers and 35 firefighters in 2017. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Public Safety LOIT Special Revenue City Funds Form 3 38 Fund Name Fund Number 251 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date 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,068,000 92,398 266,076 268,789 - 801,924 25% Grants/Intergovernmental 256,000 35,699 52,765 - - 203,235 21% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 20,000 2,450 6,757 7,306 - 13,243 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 274 242,345 - (274) 0% Transfers In - - - - - - 0% Total Revenue 1,344,000 130,547 325,873 518,440 - 1,018,127 24% Expenditures Personnel - - - - - - 0% Supplies 450,378 - - - - 450,378 0% Services 794,905 - 40,400 125,634 27,312 727,193 9% Debt Service - - - - - - 0% Capital 841,261 3,018 177,418 166,055 343,843 320,000 62% Transfers Out - - - - - - 0% Total Expenditures 2,086,544 3,018 217,818 291,688 371,155 1,497,571 28% Net (742,544) 127,529 108,055 226,752 (371,155) (479,444) Cash Balance 2,938,089 2,954,126 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used to track expenditures for road projects. In 2008, wheel tax revenue was moved from this fund to the Motor Vehicle Highway Fund (202). This fund receives gas taxes as its primary revenue source. This fund receives most of its revenue through the gas tax, budgeted at $1.068 million for 2017. Other Income is reimbursement from the Indiana Department of Transportation (INDOT) as they pay the City back for their share of certain construction projects. The fund is used predominantly for street capital projects. Projects in 2017 include the Safe Routes to School initiative for Coquillard and Harrison schools, Bendix Drive, and the Boland bicycle trail. The encumbrance includes $56K for Bendix Dr. (Lathrop to Toll Road), $43K for the Boland Trail, $68K for Safe Routes to School (Coquillard, Harrison, Perley and Lincoln schools), and $127K for Olive St. at Sample design and construction. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Local Roads & Streets Special Revenue City Funds Form 3 39 Fund Name Fund Number 252 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 0% Expenditures Personnel - - - - - - 0% Supplies 8 - - - - 8 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 8 - - - - 8 0% Net (8) - - - - (8) Cash Balance 8 8 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: In 2009, the City received a one-time $2.9 million distribution for this fund, ear-marked for public safety. In 2012, the City spent approximately $2.1 million for portable radios for both the Police and Fire departments. This fund will be closed in 2017. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Excess Welfare Distribution Special Revenue City Funds Form 3 40 Fund Name Fund Number 257 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental 1,278,000 - - - - 1,278,000 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 40,000 3,511 10,116 - - 29,884 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 152,895 152,895 - - (152,895) 0% Transfers In - - - - - - 0% Total Revenue 1,318,000 156,406 163,011 - - 1,154,989 12% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 655,100 21,886 21,886 - 116,214 517,000 21% Debt Service - - - - - - 0% Capital 2,102,357 28,480 71,831 - 417,525 1,613,000 23% Transfers Out 1,000,000 1,000,000 1,000,000 - - - 100% Total Expenditures 3,757,457 1,050,366 1,093,717 - 533,740 2,130,000 43% Net (2,439,457) (893,960) (930,706) - (533,740) (975,011) Cash Balance 3,094,360 - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2016, per the State Board of Accounts (SBOA), to receive a one-time payment of local income taxes from the State for the purpose of infrastructure expenditures. Per the state statute, a minimum of 75% must be spent on infrastructure projects. The remainder was deposited into the Rainy Day Fund (102). A total of $4,217,549, representing 75% of the total distribution, was deposited in May 2016, comprised of $4,160,901 distributed to the City and $56,648 distributed to the Redevelopment Authority. The capital budget was established in July 2016 and is $850,000 comprised of 3 projects: 2 Safe Routes to School projects (LaSalle/Marquette and Monroe/Studebaker) and initial planning for the Ironwood/Corby/Rockne intersection. The $606K encumbered is comprised of $22K for Safe Routes - Monroe/Studebaker, $78K for Safe Routes - Marquette/LaSalle, $138K for Edison/Ironwood Design, and $368K for design work on the Ironwood/Corby/Rockne intersection. City of South Bend, Indiana Monthly Financial Report March 31, 2017 LOIT Special Distribution Special Revenue City Funds Form 3 41 Fund Name Fund Number 258 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental 145,000 - 91,200 71,000 - 53,800 63% Licenses & Permits - - - - - - 0% Charges for Services - - - 50,000 - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 2,000 418 1,012 975 - 988 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 18,040 5,557 10,051 9,603 - 7,990 56% Transfers In - - - - - - 0% Total Revenue 165,040 5,975 102,262 131,578 - 62,778 62% Expenditures Personnel 126,096 5,642 13,892 28,063 - 112,204 11% Supplies 7,630 - 5,630 629 1,500 500 93% Services 68,047 2,125 8,538 7,870 17,771 41,738 39% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 201,773 7,767 28,060 36,562 19,271 154,442 23% Net (36,733) (1,793) 74,202 95,016 (19,271) (91,664) Cash Balance 554,267 520,412 Staffing Budget Actual Full Time 2.00 2.00 Part-Time /Seasonal/Temporary - - Total 2.00 2.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund tracks that portion of the Human Rights Department that is funded by the federal government, including grants from HUD and EEOC. The Human Rights mission is to educate and promote fair housing as well as ensure that all citizens receive equal employment opportunity. Revenues are lower at this time versus last year due to timing of receipt for grants. Expenditures are consistent with normal operating costs. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Human Rights Federal Grant Special Revenue City Funds Form 3 42 Fund Name Fund Number 265 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - 1,000,000 - - (1,000,000) 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - 1,000,000 1,000,000 - - (1,000,000) 0% Total Revenue - 1,000,000 2,000,000 - - (2,000,000) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,000,000 - - - - 2,000,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,000,000 - - - - 2,000,000 0% Net (2,000,000) 1,000,000 2,000,000 - - (4,000,000) Cash Balance 2,000,000 - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in December 2016 to account for the receipt of the Community Crossings grant and matching revenue and for the payment of expenditures on eligible projects, per the Indiana State Board of Accounts. In February 2017, the City received the $1 million Community Crossings state grant from INDOT. $1 million will be transferred from Fund 257 (LOIT 2016 Special Distribution) to match the grant revenue. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Local Road & Bridge Grant Special Revenue City Funds Form 3 43 Fund Name Fund Number 271 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 22 1 3 3 - 19 15% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 22 1 3 3 - 19 15% Expenditures Personnel - - - - - - 0% Supplies 1,367 - - - - 1,367 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,367 - - - - 1,367 0% Net (1,345) 1 3 3 - (1,348) Cash Balance 1,350 1,338 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. Budgeted expenditures are for East Race equipment. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Eastrace Waterway Special Revenue City Funds Form 3 44 Fund Name Fund Number 273 Fund Type Date Updated 4/12/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 18,000 1,093 1,643 4,145 - 16,357 9% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 300 39 106 78 - 194 35% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 18,300 1,132 1,749 4,223 - 16,551 10% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 21,675 878 3,675 - 2,457 15,544 28% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 21,675 878 3,675 - 2,457 15,544 28% Net (3,375) 255 (1,926) 4,223 (2,457) 1,008 Cash Balance 45,161 34,575 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Morris PAC / Palais Royale Marketing Special Revenue City Funds Form 3 45 Fund Name Fund Number 280 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - 3 9 10 - (9) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 3 9 10 - (9) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 3 9 10 - (9) Cash Balance 3,895 3,860 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund has been used to account for certain Police grants. There are no open grants at this time. Justice Assistance Grant 2009-SB-B9-1280 was essentially completed in 2014. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Police Block Grants Special Revenue City Funds Form 3 46 Fund Name Fund Number 281 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 200 24 66 71 - 134 33% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 200 24 66 71 - 134 33% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 200 24 66 71 - 134 Cash Balance 27,678 27,432 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was used for the expenses of Economic Development Revenue Bonds. These bonds have been paid off. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Economic Develop Commission-Revenue Bonds Special Revenue City Funds Form 3 47 Fund Name Fund Number 289 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 10,000 - - - - 10,000 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - 23 63 83 - (63) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 23 63 83 - 9,937 1% Expenditures Personnel - - - - - - 0% Supplies 10,431 - 685 - 2,439 7,307 30% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,431 - 685 - 2,439 7,307 30% Net (431) 23 (622) 83 (2,439) 2,630 Cash Balance 26,152 32,145 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used to account for the cost of the Hazardous Materials Response team. 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. 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 HAZMAT Special Revenue City Funds Form 3 48 Fund Name Fund Number 291 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 45,000 12,600 28,800 26,700 - 16,200 64% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 500 124 345 245 - 155 69% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,500 12,724 29,145 26,945 - 16,355 64% Expenditures Personnel 15,500 231 692 692 - 14,808 4% Supplies 8,849 0 1,212 847 - 7,637 14% Services 65,000 0 0 4,581 31,607 33,393 49% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 89,349 231 1,904 6,121 31,607 55,838 38% Net (43,849) 12,493 27,240 20,824 (31,607) (39,483) Cash Balance 169,261 116,269 Staffing Budget Actual Full Time - - Part-Time /Seasonal/Temporary - - Total - - Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 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. The City has started to received deposits for 2017 classes. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Indiana River Rescue Special Revenue City Funds Form 3 49 Fund Name Fund Number 292 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,805 1,330 5,392 18,825 27,542 (22,129) 305% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,805 1,330 5,392 18,825 27,542 (22,129) 305% Net (10,805) (1,330) (5,392) (18,825) (27,542) 22,129 Cash Balance 71,237 102,371 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established to track the revenue and expenditures related to specific Federal Grants. The City did not received any grants during 2016 and does not anticipate any grant revenue during 2017. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Police Grants Special Revenue City Funds Form 3 50 Fund Name Fund Number 294 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 20,000 1,950 11,800 16,450 - 8,200 59% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 500 73 191 191 - 309 38% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,000 - 50 - - 1,950 3% Transfers In - - - - - - 0% Total Revenue 22,500 2,023 12,041 16,641 - 10,459 54% Expenditures Personnel - - - - - - 0% Supplies 1,500 - 224 100 351 926 38% Services 21,000 692 913 480 - 20,087 4% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 22,500 692 1,137 581 351 21,013 7% Net - 1,332 10,904 16,060 (351) (10,553) Cash Balance 86,979 86,278 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Regional Police Academy Special Revenue City Funds Form 3 51 Fund Name Fund Number 295 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental 53,750 - - 7,319 - 53,750 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 500 199 541 316 - (41) 108% Bond Proceeds - - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 34,500 747 37,791 10,023 - (3,291) 110% Transfers In - - - - - - 0% Total Revenue 92,000 946 38,332 17,657 - 53,668 42% Expenditures Personnel - - - - - - 0% Supplies 110,467 - 13,156 - 61,015 36,296 67% Services 153,300 108,583 109,843 6,669 680 42,777 72% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 263,767 108,583 122,999 6,669 61,695 79,073 70% Net (171,767) (107,637) (84,667) 10,988 (61,695) (25,405) Cash Balance 152,757 132,726 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. The Community-Oriented Policing Services (COPS) Office of the Department of Justice offers grants through the Making Officer Redeployment Effective (MORE) program. In March, the City of South Bend reimbursed grant sub-recipients, the City of Gary, Indiana and the East Chicago Police Department, totalling $89,270. The encumbrances in the supplies budget line are for in-car video camera systems. City of South Bend, Indiana Monthly Financial Report March 31, 2017 COPS MORE Grant Special Revenue City Funds Form 3 52 Fund Name Fund Number 299 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental 30,000 - - - - 30,000 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 1,000 148 459 324 - 541 46% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,000 - - - - 1,000 0% Transfers In - - - - - - 0% Total Revenue 32,000 148 459 324 - 31,541 1% Expenditures Personnel - - - - - - 0% Supplies 89,337 - 34,337 6,965 - 55,000 38% Services 62,000 13,200 13,200 1,290 - 48,800 21% Debt Service - - - - - - 0% Capital 45,000 - - 3,787 - 45,000 0% Transfers Out - - - - - - 0% Total Expenditures 196,337 13,200 47,537 12,042 - 148,800 24% Net (164,337) (13,052) (47,079) (11,718) - (117,258) Cash Balance 178,979 241,034 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. In the first quarter of 2017, workstations ($11k) and surveillance cameras ($23k) were purchased within the supplies budget. Additionally, $13,200 of the services budget was spent on SWAT training. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Police Federal Drug Enforcement Special Revenue City Funds Form 3 53 Fund Name Fund Number 404 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 10,459,265 871,605 2,614,816 2,363,506 - 7,844,449 25% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 95,000 7,486 20,961 30,067 - 74,039 22% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 409,574 284,882 320,788 279,856 - 88,786 78% Transfers In - - - - - - 0% Total Revenue 10,963,839 1,163,973 2,956,565 2,673,428 - 8,007,274 27% Expenditures Personnel - - - 110,446 - - 0% Supplies 1,234,438 144,721 281,236 188,633 28,652 924,550 25% Services 5,717,611 556,317 1,626,272 1,720,377 890,606 3,200,733 44% Debt Service 1,162,337 114,463 578,095 1,348,042 - 584,242 50% Capital 514,629 24,868 24,868 9,183 208,312 281,449 45% Transfers Out 3,442,578 - 773,058 375,000 - 2,669,520 22% Total Expenditures 12,071,593 840,369 3,283,528 3,751,682 1,127,570 7,660,495 37% Net (1,107,754) 323,604 (326,963) (1,078,253) (1,127,570) 346,779 Cash Balance 8,585,462 11,102,281 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the receipt and expense of county option income tax (COIT). The revenue is determined annually by the Indiana Department of Local Government Finance (DLGF). Expenditures in this fund include debt service payments, maintenance, and the Curb & Sidewalk program. Prior to 2017, this fund paid for Information Technology/Innovation costs, but these consts have been moved into fund 279 for 2017 Certain debt service payments on public facilities including the Publice Works Service Center, Police and Fire Stations and Main Street/Colfax Garage have been paid by the COIT fund, but will be paid from the Tax Increment Financing (TIF) funds in 2017. The curb and sidewalk program increased by $177,224 to the level of $1,677,224. This year, budgeted capital projects include bus shelters of $180,000, and the neighborhood plan program for $95,000. City of South Bend, Indiana Monthly Financial Report March 31, 2017 County Option Income Tax Special Revenue City Funds Form 3 54 Fund Name Fund Number 408 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 10,433,361 866,667 2,633,354 2,398,651 - 7,800,007 25% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services 150,000 - 150,000 150,000 - - 100% Fines, Forfeitures, and Fees 354,660 - 354,660 354,660 - - 100% Interest Earnings 60,000 10,599 27,154 24,837 - 32,846 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 735,236 - 735,236 - - 0 100% Total Revenue 11,733,257 877,267 3,900,404 2,928,147 - 7,832,853 33% Expenditures Personnel - - - - - - 0% Supplies 83 - - - 83 0 100% Services 4,404,649 37,216 854,218 231,866 2,286,151 1,264,280 71% Debt Service 384,256 31,986 131,260 566,970 - 252,996 34% Capital 102,700 1,548 59,165 2,628 1,152 42,383 59% Transfers Out 6,667,496 - 1,651,874 1,620,946 - 5,015,622 25% Total Expenditures 11,559,184 70,750 2,696,517 2,422,410 2,287,385 6,575,281 43% Net 174,073 806,517 1,203,886 505,737 (2,287,385) 1,257,572 Cash Balance 12,364,672 10,399,620 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used to subsidize many operations throughout the City via transfers to those operations' various funds. Services expenditures include the payment to St Joe County for PSAP, various economic development & assistance grants, workforce development programming, and others. The economic develeopment income tax (EDIT) rate was increased from 0.2% of salaries and wages in 2009 to 0.4% in 2010 in response to revenue losses incurred by the "circuit breaker" property tax caps. Transfers out relate to: $1,522,673 - annual subsidy to Fund 211 for DCI, $400,000 to Fund 201 for maintenance and other services formerly provided by DTSB, $1,937,750 to Fund 202 for Street Department expenditures and road paving expenses, $1,438,451 to Fund 600-1201 for Code Enforcement, $579,757 to Fund 219, and $728,865 to Fund 600-1207 for Animal Care & Control. Services expenditures includes the $2,054,126 payment to St Joe County for PSAP, various economic development & assistance grants, workforce development programming, and others. The Debt Service expenditures are payments on the 2015 EDIT Parks Bond. $45K is budgeted for the recording of deeds. $57.7K is for ATVs with plows for snowplowing sidewalks. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Economic Development Income Tax Special Revenue City Funds Form 3 55 Fund Name Fund Number 410 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 6,110 493 1,353 1,604 - 4,757 22% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,110 493 1,353 1,604 - 4,757 22% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 126,144 - 30,702 146,068 - 95,442 24% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 126,144 - 30,702 146,068 - 95,442 24% Net (120,034) 493 (29,348) (144,464) - (90,686) Cash Balance 563,129 485,937 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is currently used to pay for an inter-fund loan from the COIT Fund (404) in connection with a downtown hotel/parking garage project. This budget usually includes payments to the COIT Fund. These payments will not be made unless revenue generated in the fund, primarily from Business Development Corporation (BDC) collections, is actually received. New payments from the BDC were received in 2015 and are expected in 2016. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Urban Development Action Grant Special Revenue City Funds Form 3 56 Fund Name Fund Number 655 Fund Type Date Updated 4/17/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 440,153 36,817 110,349 109,637 - 329,804 25% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 4,403 787 2,133 2,403 - 2,270 48% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 444,556 37,604 112,482 112,040 - 332,074 25% Expenditures Personnel 49,851 - - - - 49,851 0% Supplies 4,344 - - - 876 3,468 20% Services 49,001 3,684 10,181 8,541 - 38,820 21% Debt Service 72,220 - 11,619 11,619 - 60,601 16% Capital - - - - - - 0% Transfers Out 350,000 - 87,500 - - 262,500 25% Total Expenditures 525,416 3,684 109,300 20,160 876 415,240 21% Net (80,860) 33,920 3,182 91,880 (876) (83,166) Cash Balance 879,771 1,016,561 Staffing Budget Actual Full Time - - Part-Time /Seasonal/Temporary 2.02 - Total 2.02 - Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the fall and spring leaf collection program. The program is financed by a $0.99 per month charge on residents' utility bills. 2017 Fall Leaf Pickup program start date - to be determined. The annual transfer of $350,000.00 is to cover a portion of MVH costs paid for spring & fall Project Releaf. These costs include supervisory wages and benefits, gasoline, depreciation on the leaf vacs and other costs. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Project Releaf Special Revenue City Funds Form 3 57 Fund Name Fund Number 705 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 20 3 7 10 - 13 34% Bond Proceeds - - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,020 3 7 10 - 2,013 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,020 - - - - 2,020 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,020 - - - - 2,020 0% Net - 3 7 10 - (7) Cash Balance 2,865 3,879 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Police K-9 Unit Special Revenue City Funds Form 3 58 Fund Name Fund Number 313 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 871,228 - - - - 871,228 0% Local Income Taxes - - - - - - 0% Other Taxes 67,000 - - 28,029 - 67,000 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - 23 79 0 - (79) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 938,228 23 79 28,029 - 938,149 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 1,268,999 (3,265) 631,735 636,000 - 637,264 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,268,999 (3,265) 631,735 636,000 - 637,264 50% Net (330,771) 3,288 (631,656) (607,971) - 300,885 Cash Balance (338,862) (596,575) Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. During 2017, certain debt service payments may need to be transferred to another fund due to a reduction in the property tax levy for this fund. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Football Hall of Fame Debt Service City Debt Service City Funds Form 3 59 Fund Name Fund Number 755 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 4,000 210 246 - - 3,754 6% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 2,639,214 - 1,326,750 - - 1,312,464 50% Total Revenue 2,643,214 210 1,326,996 - - 1,316,218 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 2,643,214 1,437,970 1,437,970 - - 1,205,244 54% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,643,214 1,437,970 1,437,970 - - 1,205,244 54% Net - (1,437,760) (110,974) - - 110,974 Cash Balance 651,115 - Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The South Bend Building Corporation receives debt service payments from the City and passes them through to trustee banks and bondholders. The South Bend Building Corporation is a separate legal entity and the City wishes to formally integrate its operations into its formal accounting system in 2017. The South Bend Building Corporation is reported as a fund in the City's Comprehensive Annual Financial Report (CAFR). Debt service payments are for the 2012 Police & Fire refunding (debt schedule #39), the 2010 Public Works Building refunding (#36), and the 2013 EMS Fire Station/Tower bonds (#116). Debt payments are made twice a year, in February and August. The 2010 Public Works Building refunding bonds are scheduled to be paid off in 2021. The 2012 Police & Fire refunding are scheduled to be paid off in 2023. The 2013 EMS Fire Station/Tower bonds are scheduled to be paid off in 2033. City of South Bend, Indiana Monthly Financial Report March 31, 2017 South Bend Building Corp City Debt Service City Funds Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus, changes are entered in the general ledger the following month. Form 3 60 Fund Name Fund Number 757 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 1,000 124 207 - - 793 21% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 390,482 - 65,080 - - 325,402 17% Total Revenue 391,482 124 65,287 - - 326,195 17% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 391,482 198,566 198,566 - - 192,916 51% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 391,482 198,566 198,566 - - 192,916 51% Net - (198,441) (133,279) - - 133,279 Cash Balance 428,664 - Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: A new Parks Bond Debt Service Fund 757 is being established for 2017 to account for the receipt of monthly lease rental payments from the City's EDIT Fund 408 and the payment of debt service principal and interest semi-annually to the bond holders. The accounting records are maintained in US Bank trustee accounts and, beginning in 2017, will be integrated into the City's regular accounting system. The par amount of the 2015 Parks/EDIT bond was $5,605,000 and the final payment is due August 1, 2035. In February, $65,080 was transferred into this fund from the Bond in anticipation of debt service needs. The first of two semi-annual payments was made in March. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Parks Bond Debt Service City Debt Service City Funds Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus, changes are entered in the general ledger the following month. Form 3 61 Fund Name Fund Number 377 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 700,000 115,348 177,752 261,209 - 522,248 25% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 2,000 9 606 890 - 1,394 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 30,000 - 17,864 24,026 - 12,136 60% Transfers In - - - - - - 0% Total Revenue 732,000 115,357 196,222 286,125 - 535,778 27% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 827,955 - 468,440 473,088 - 359,515 57% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 827,955 - 468,440 473,088 - 359,515 57% Net (95,955) 115,357 (272,218) (186,962) - 176,263 Cash Balance 125,060 240,412 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund collects a special tax which is used primarily for debt service and improvements at the Four Winds Field baseball stadium. The PSDA revenue is projected to end in August 2018. Effective January 1, 2013, this fund no longer collects hotel/motel tax allocations from St. Joseph County for payment to the Hall of Fame, but still receives funding from the State for PSDA on a monthly basis. The PSDA area includes Four Winds field, Century Center, MPAC and Studebaker National Museum. This fund is currenty used for debt service. Four Winds Field generates the majority of PSDA revenue. The PSDA revenue is projected to end in August 2018. The final debt service payment on the 2010 Coveleski Stadium bonds (Four Winds Field) will be paid January 15, 2019. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Professional Sports Development Capital Project City Funds Form 3 62 Fund Name Fund Number 401 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 40,000 - - - - 40,000 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 200 79 217 207 - (17) 108% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 40,200 79 217 207 - 39,984 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 30,000 - - 22,000 6,079 23,921 20% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 30,000 - - 22,000 6,079 23,921 20% Net 10,200 79 217 (21,793) (6,079) 16,063 Cash Balance 90,751 60,761 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used for minor capital improvements for Four Winds Field at Coveleski Stadium. Revenues are in the form of a bonus received by the City if attendance reaches or maintains certain levels. Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. Further, the budgeted items are for repair & maintenance, not capital. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Coveleski Stadium Capital Capital Project City Funds Form 3 63 Fund Name Fund Number 403 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 200 44 119 127 - 81 60% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 200 44 119 127 - 81 60% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 49,688 - - - 49,400 288 99% Transfers Out - - - - - - 0% Total Expenditures 49,688 - - - 49,400 288 99% Net (49,488) 44 119 127 (49,400) (207) Cash Balance 50,017 49,573 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts 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. The 2017 capital budget is for the re-paving of the zoo parking lot. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Zoo Endowment Capital Project City Funds Form 3 64 Fund Name Fund Number 405 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 26,000 392 828 1,014 - 25,172 3% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 4,000 179 483 1,110 - 3,517 12% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 22,000 - 4,000 - - 18,000 18% Transfers In 287,850 - - - - 287,850 0% Total Revenue 339,850 571 5,311 2,124 - 334,539 2% Expenditures Personnel - - - - - - 0% Supplies 67,326 22,621 24,462 1,948 26,351 16,513 75% Services 63,288 - 4,954 - 4,266 54,068 15% Debt Service - - - - - - 0% Capital 97,410 - 56,330 - 8,500 32,581 67% Transfers Out - - - - - - 0% Total Expenditures 228,024 22,621 85,745 1,948 39,117 103,161 55% Net 111,826 (22,050) (80,435) 176 (39,117) 231,378 Cash Balance 230,274 469,900 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This is a 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, and Howard Park Ice Rink. Currently, this fund is used for more than capital expenditures. Annual transfers to this fund from Park Funds (201/203) were not done in 2015 amd 2016 due to an oversight. This will be corrected in 2017 and revenues going forward in this fund should be more consistent. The cash balance includes $60,300 that is restricted to expenditures in Voorde Park. Capital expenditures are for the purchase of equipment for the golf courses. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Park Nonreverting Capital Capital Project City Funds Form 3 65 Fund Name Fund Number 406 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 436,000 - - - - 436,000 0% Local Income Taxes - - - - - - 0% Other Taxes 37,500 - - 13,260 - 37,500 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 3,000 410 1,203 1,348 - 1,797 40% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 476,500 410 1,203 14,608 - 475,297 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 476,500 - 140,546 169,196 - 335,954 29% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 476,500 - 140,546 169,196 - 335,954 29% Net - 410 (139,344) (154,588) - 139,344 Cash Balance 440,970 417,372 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The fund is used to finance police vehicles and related equipment. 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Cumulative Capital Development Capital Project City Funds Form 3 66 Fund Name Fund Number 407 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 408,000 - 150,000 150,000 - 258,000 37% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 2,000 301 862 801 - 1,138 43% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In - - - - - - 0% Total Revenue 435,000 301 150,862 150,801 - 284,138 35% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 372,250 - 185,125 184,125 - 187,125 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 372,250 - 185,125 184,125 - 187,125 50% Net 62,750 301 (34,263) (33,324) - 97,013 Cash Balance 343,982 277,907 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund receives revenues from the hotel/motel tax as well as the cigarette tax. The fund is used to pay debt service on a Century Center bond. Revenue in this fund includes $150,000 in hotel/motel taxes and $258,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. This fund is used to pay 75% of the 2011 Century Center Refunding bonds. 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Cumulative Capital Improvement Capital Project City Funds Form 3 67 Fund Name Fund Number 412 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 25,000 2,312 5,890 5,587 - 19,110 24% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,477,472 - 596,589 586,589 - 880,883 40% Transfers In - - - - - - 0% Total Revenue 1,502,472 2,312 602,479 592,176 - 899,993 40% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,468,808 62 604 - 1,333,825 134,379 91% Debt Service - - - - - - 0% Capital 1,001,900 - - 351,475 241,900 760,001 24% Transfers Out - - - - - - 0% Total Expenditures 2,470,708 62 604 351,475 1,575,724 894,380 64% Net (968,236) 2,250 601,875 240,701 (1,575,724) 5,613 Cash Balance 2,965,965 2,424,674 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2006 with the City's share of the proceeds for the lease of the Indiana Toll Road (I-80/90). The fund is used to finance capital improvements projects and also makes loans to other funds. Annual revenue is the loan payments from those other funds. In recent years the fund has been used in connection with the City's Smart Streets program. 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 I-80 toll road to a private company. This fund has been used in the past to provide seed money for economic development projects at Douglas Road, Eddy Street Commons, and the Triangle Development near Notre Dame. The amounts advanced for these projects are being repaid by the respective tax increment financing (TIF) funds as per formal amortization schedules. In August the fund received the second of two semi-annual payments on these loans, totaling $418,156 in principal and interest. Balances due are $181,081 from Fund 435 (Douglas Rd.) and $3,342,237 from Fund 436 (River East Residential). The 2016 budget continues funding for the Smart Streets initiative and includes $592K for Smart Streets, $250K for the Boland Trail and $80K for Bendix Drive (both projects moved from the LRSA Fund 251). The $265K encumbered comprises $68K for the downtown portion of the 2-way conversion of Main and Michigan/St. Joseph streets from Chippewa to LaSalle (the former IN-933), $1K for the Olive-Sample overpass. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Major Moves Construction Capital Project City Funds Form 3 68 Fund Name Fund Number 416 Fund Type Date Updated 4/13/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 100,000 13,143 25,357 14,863 - 74,643 25% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 4,000 523 1,409 1,334 - 2,591 35% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 104,000 13,666 26,766 16,197 - 77,234 26% Expenditures Personnel - - - - - - 0% Supplies 20,958 828 1,236 5,000 2,698 17,024 19% Services 35,186 817 817 7,931 6,869 27,500 22% Debt Service - - - - - - 0% Capital 50,000 - - - - 50,000 0% Transfers Out - - - - - - 0% Total Expenditures 106,144 1,645 2,053 12,931 9,567 94,524 11% Net (2,144) 12,021 24,713 3,266 (9,567) (17,290) Cash Balance 614,546 519,992 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for capital projects at the Morris Performing Arts Center (MPAC). 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. Dimmer Rack Upgrades (Lighting 1/3) in the amount of $20,000.00. Fall Arrest System and Escape Ladders for the theater (house left an right - required by regulations) in the amount of $30,000.00. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Morris Performing Arts Center Capital Capital Project City Funds Form 3 69 Fund Name Fund Number 434 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - 156 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 156 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - 156 - - Cash Balance - 2,560 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund formerly received a special distribution of state tax revenue captured in the district and was used for debt service. This fund was closed and the remaining cash transferred to COIT Fund #404. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Community Revitalization Enhancement District Capital Project City Funds Form 3 70 Fund Name Fund Number 450 Fund Type Date Updated 4/13/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 600 83 225 197 - 375 38% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 16,500 345 2,297 2,415 - 14,203 14% Transfers In - - - - - - 0% Total Revenue 17,100 428 2,522 2,613 - 14,578 15% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 5,000 - - - - 5,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,000 - - - - 5,000 0% Net 12,100 428 2,522 2,613 - 9,578 Cash Balance 95,432 79,026 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund provides funding for capital projects that preserve the historic character of the Palais Royale Ballroom. This fund is funded through a portion of revenues received from functions held at the Palais. There are no capital projects budgeted at this time. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Palais Royale Historic Preservation Capital Project City Funds Form 3 71 Fund Name Fund Number 677 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 5,000 431 1,181 1,288 - 3,819 24% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 431 1,181 1,288 - 3,819 24% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 81,091 2,574 21,299 27,415 12,751 47,041 42% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 81,091 2,574 21,299 27,415 12,751 47,041 42% Net (76,091) (2,143) (20,118) (26,127) (12,751) (43,222) Cash Balance 475,322 476,749 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established to provide capital repairs and improvements at the former College Football Hall of Fame building. The fund received distributions from the PSDA Tax Fund (377) through 2010. The College Football Hall of Fame ceased operations in South Bend at the end of 2012. Budgeted expenditures are for the utilities and maintenance of the building. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Football Hall of Fame Capital Capital Project City Funds Form 3 72 Fund Name Fund Number 287 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 1,275,000 - 1,798,417 1,307,757 - (523,417) 141% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 10,000 3,021 8,504 6,828 - 1,496 85% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,285,000 3,021 1,806,922 1,314,585 - (521,922) 141% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 184,010 - - - 184,010 - 100% Debt Service 729,756 - 235,792 - - 493,964 32% Capital 2,186,611 - 150,604 152,919 1,198,707 837,300 62% Transfers Out - - - - - - 0% Total Expenditures 3,100,377 - 386,396 152,919 1,382,717 1,331,264 57% Net (1,815,377) 3,021 1,420,525 1,161,666 (1,382,717) (1,853,185) Cash Balance 5,050,059 3,830,498 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2015 to track capital expenditures related to Emergency Medical Services. The fund receives revenues from Medicaid settlements and transfers from EMS Operating Fund (288). These funds are used for capital purchases such as fire apparatus, ambulances and major construction projects. A new, smaller ambulance was purchased in February 2017. Planned purchase of ambulance, replacement cardiac monitors, fleet vehicle. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Emergency Medical Services Capital Enterprise City Funds Form 3 73 Fund Name Fund Number 288 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 6,327,512 481,504 1,217,125 1,426,633 - 5,110,387 19% Fines, Forfeitures, and Fees 2,500 - 700 1,000 - 1,800 28% Interest Earnings 15,000 1,395 4,092 5,729 - 10,908 27% Bond Proceeds - - - - - - 0% Donations - 750 750 - - (750) 0% Other Income 5,000 - 525 200 - 4,475 11% Transfers In - - - - - - 0% Total Revenue 6,350,012 483,650 1,223,192 1,433,562 - 5,126,820 19% Expenditures Personnel 5,180,304 335,834 1,007,522 969,276 - 4,172,782 19% Supplies 358,825 30,046 76,517 76,797 35,528 246,780 31% Services 577,692 35,873 112,428 55,203 32,666 432,598 25% Debt Service 1,093 - 318 225,901 1,729 (954) 187% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,117,914 401,753 1,196,785 1,327,177 69,923 4,851,207 21% Net 232,098 81,897 26,407 106,385 (69,923) 275,614 Cash Balance 1,785,503 2,349,917 Staffing Budget Actual Full Time 51.00 51.00 Part-Time /Seasonal/Temporary - - Total 51.00 51.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the expenditures of the Emergency Medical Services (EMS) program. 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. Fire Department and EMS capital expenditures are accounted for in the EMS Capital Fund #287. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Emergency Medical Services Operating Enterprise City Funds Form 3 74 Fund Name Fund Number 600 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits 25,000 3,017 6,696 7,640 - 18,304 27% Charges for Services 1,477,850 141,666 334,777 310,227 - 1,143,073 23% Fines, Forfeitures, and Fees 280,000 6,185 14,953 14,948 - 265,047 5% Interest Earnings 5,000 2,168 6,077 5,093 - (1,077) 122% Bond Proceeds - - - - - - 0% Donations 4,000 - - 557 - 4,000 0% Other Income 9,500 1,150 1,668 1,319 - 7,832 18% Transfers In 2,167,316 - 541,829 527,517 - 1,625,487 25% Total Revenue 3,968,666 154,187 905,999 867,300 - 3,062,667 23% Expenditures Personnel 2,696,460 188,177 565,574 614,370 - 2,130,886 21% Supplies 113,282 5,899 29,361 22,999 15,268 68,652 39% Services 892,868 61,098 198,460 179,062 61,073 633,335 29% Debt Service 75,210 2,413 24,269 11,885 1,655 49,285 34% Capital - - - 30,608 - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,777,820 257,588 817,664 858,924 77,997 2,882,159 24% Net 190,846 (103,401) 88,335 8,376 (77,997) 180,508 Cash Balance 2,707,472 1,904,738 Staffing Budget Actual Fund Purpose: Code Enforcement (600-1201)/Animal Control (600-1207) Full Time 23.00 23.00 Part-Time /Seasonal/Temporary 1.50 1.50 Building Department (600-1306) Full Time 14.00 14.00 Part-Time /Seasonal/Temporary 0.50 0.50 Total 39.00 39.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Code Enforcement (600-1201)/Animal Control (600-1207) Building Department (600-1306) Explain Significant Spending on Capital Projects Below: Code Enforcement (600-1201)/Animal Control (600-1207) Building Department (600-1306) City Funds City of South Bend, Indiana Monthly Financial Report March 31, 2017 Consolidated Building Fund Enterprise This fund accounts for the expenditures of the Building Department, Code Enforcement, and Animal Care & Control. Code Enforcement and Animal Care & Control are managed together, but are run separately from the Building Department per the Common Council. The $2.1 million transfer is from the EDIT Fund to cover Code and Animal Control activities which, unlike the Consolidated Building Department, are not enterprises by nature. Some revenues are derived from fees for processing abandoned vehicles and animal control activities. This portion of the fund comprises revenues and expenditures for Code Enforcement and its subsidiary, Animal Care and Control. While some revenues are derived from fees for processing abandoned vehicles and animal control activities, the vast majority comes from a transfer from the EDIT fund. Most of the Other Income is from collections for ordinance violations. Capital expenditures are for two pickup trucks. The first truck was paid for in January and the second in June. Purchased 4 new vehicles (lease payments) in November 2016, first payments were in January 2017. Will purchase (lease) 3 new vehicles in June 2017. Form 3 75 Fund Name Fund Number 601 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 986,129 83,097 272,395 248,323 - 713,734 28% Fines, Forfeitures, and Fees 95,900 7,169 15,484 15,470 - 80,416 16% Interest Earnings 4,000 917 2,339 1,687 - 1,661 58% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 11,282 180 200 - - 11,082 2% Transfers In - - - - - - 0% Total Revenue 1,097,311 91,364 290,418 265,480 - 806,893 26% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,208,218 4,482 109,415 229,526 965,087 133,717 89% Debt Service - - - - - - 0% Capital 39,036 - - - 39,036 - 100% Transfers Out - - - - - - 0% Total Expenditures 1,247,254 4,482 109,415 229,526 1,004,123 133,717 89% Net (149,943) 86,881 181,004 35,954 (1,004,123) 673,176 Cash Balance 1,151,255 676,571 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the revenues and expenditures from the various parking garages owned by the City of South Bend. Parking garage operations are under outside contract with Downtown South Bend, Inc. Other contracts are for various repair & maintenance projects among the garages. The vast majority of the Services encumbrance is $892K for the annual Block By Block contract, for maintaining the garages and assisting patrons. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Parking Garages Enterprise City Funds Form 3 76 Fund Name Fund Number 610 Fund Type Date Updated 4/12/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 5,746,175 480,580 1,397,454 1,281,647 - 4,348,721 24% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 2,500 253 727 678 - 1,773 29% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 34,000 - 265 27,090 - 33,735 1% Transfers In - - - - - - 0% Total Revenue 5,782,675 480,834 1,398,446 1,309,415 - 4,384,229 24% Expenditures Personnel 1,781,122 121,502 397,070 352,436 - 1,384,052 22% Supplies 187,532 11,326 57,450 38,254 48,044 82,038 56% Services 2,848,943 155,673 635,763 731,520 269,746 1,943,434 32% Debt Service 9,700 - - 9,700 9,700 - 100% Capital - - - - - - 0% Transfers Out 835,613 100,000 100,000 262,000 - 735,613 12% Total Expenditures 5,662,910 388,501 1,190,284 1,393,911 327,490 4,145,137 27% Net 119,765 92,333 208,163 (84,495) (327,490) 239,092 Cash Balance 420,188 235,205 Staffing Budget Actual Full Time 26.20 26.20 Part-Time /Seasonal/Temporary - - Total 26.20 26.20 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the operations of the Solid Waste Department. It is funded by charging City residents a monthly fee for pick-up and disposal of trash at area landfills and recycling centers. Funds are transferred out to the Solid Waste Capital Fund #611 for the payment of debt service obligations as needed. Year to date service revenue is higher than prior year to date total due to a 9% rate increase. An expected CNG fuel rebate (other income) has not been received yet. Encumbrances for future CNG fuel deliveries are causing the percentage of supplies budget used to appear high. Large encumbrances for landfill tipping fees and trash truck computers are similarly causing the services budget used to appear higher than normal. Transfers out follow debt service payment schedules. Solid Waste capital expenditures are accounted for in the Solid Waste Capital Fund #611. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Solid Waste Operations Enterprise City Funds Form 3 77 Fund Name Fund Number 611 Fund Type Date Updated 4/6/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - 300,000 - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 200 39 458 36 - (258) 229% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 835,613 100,000 100,000 262,000 - 735,613 12% Total Revenue 835,813 100,039 100,458 562,036 - 735,355 12% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 1,123,613 218 433,832 262,258 - 689,781 39% Capital 12,000 - - - - 12,000 0% Transfers Out - - - - - - 0% Total Expenditures 1,135,613 218 433,832 262,258 - 701,781 38% Net (299,800) 99,821 (333,374) 299,778 - 33,574 Cash Balance 3,074 300,221 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used for debt service and capital expenditures related to the Solid Waste Department. This fund receives transfers from the Solid Waste Operations Fund #610. A $300K State grant received in 2016 to cover part of the cost of new CNG fueled trash trucks will not be repeated this year. Interest revenue was underestimated; a budget adjustment will be requested mid-year. Transfers in are done as needed to have funds available for debt service payments, per City debt payment schedules. With few exceptions, all vehicles and equipment are lease-purchased over a five year term. The debt service payments cover lease payments for eleven trucks in the fleet. Four of them will be fully paid for in July 2017. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Solid Waste Capital Enterprise City Funds Form 3 78 Fund Name Fund Number 620 Fund Type Date Updated 4/13/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 17,348,834 1,097,670 3,312,606 3,275,335 - 14,036,228 19% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 35,000 2,584 7,257 9,534 - 27,743 21% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 73,000 35 1,320 2,523 - 71,680 2% Transfers In 62,500 3,961 10,401 7,596 - 52,099 17% Total Revenue 17,519,334 1,104,250 3,331,584 3,294,987 - 14,187,750 19% Expenditures Personnel 5,604,157 393,931 1,231,028 1,205,673 191 4,372,938 22% Supplies 1,727,233 64,798 321,485 245,562 166,289 1,239,460 28% Services 5,995,181 363,955 1,144,782 984,880 677,160 4,173,239 30% Debt Service 328,853 772 109,457 7,491 3,420 215,976 34% Capital - - - - - - 0% Transfers Out 4,071,830 312,827 1,089,753 1,248,913 - 2,982,077 27% Total Expenditures 17,727,254 1,136,283 3,896,505 3,692,519 847,060 12,983,689 27% Net (207,920) (32,033) (564,920) (397,531) (847,060) 1,204,060 Cash Balance 3,164,418 3,589,005 Staffing Budget Actual Full Time 72.00 67.00 Part-Time /Seasonal/Temporary 3.56 1.50 Total 75.56 68.50 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established to account for all revenue and operational expenses 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. Current year budget for Charges for Services revenue includes $2.7 million (half of year) of additional projected sales as planned in the water rate case. Delay in revenues is expected which will impact the percentage of budget year to date. Water Works capital expenditures are accounted for in the Water Works Capital Fund #622. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Water Works Operations Enterprise City Funds Form 3 79 Fund Name Fund Number 622 Fund Type Date Updated 4/12/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 15,000 2,167 6,059 7,422 - 8,941 40% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,000 2,167 6,059 7,422 - 8,941 40% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 1,414,466 13,775 303,490 - 109,653 1,001,323 29% Transfers Out - - - - - - 0% Total Expenditures 1,414,466 13,775 303,490 - 109,653 1,001,323 29% Net (1,399,466) (11,608) (297,430) 7,422 (109,653) (992,383) Cash Balance 2,290,085 2,887,830 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used for acquiring, constructing, and improving water utility capital assets. Water utility capital assets include Wells, Reservoirs,Transmission and Distribution Mains, Pumping, Treatment and Transportation Equipment and other general plant items. Spent YTD: Freightliner Dump Truck (1) $177,777 | Truck w/Utility Body (2) $88,840 | Concrete/Asphalt Saw (1) $23,098 WIP: North Station Well #1 Replacement /Eng Design - $13,775 Encumb: 1 Tn 2WD Dump Truck (1) $48,493, North Station Well #1 Replacement Project - Engineering Design $52,296 and Well Drilling $8,865 City of South Bend, Indiana Monthly Financial Report March 31, 2017 Water Works Capital Enterprise City Funds Form 3 80 Fund Name Fund Number 624 Fund Type Date Updated 4/12/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 15,000 1,347 3,680 3,895 - 11,320 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,000 1,347 3,680 3,895 - 11,320 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 1,347 3,395 1,927 - 11,605 23% Total Expenditures 15,000 1,347 3,395 1,927 - 11,605 23% Net - - 285 1,968 - (285) Cash Balance 1,525,530 1,521,631 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The purpose of this fund is for the retaining of and for the refunding of security deposits collected from utility customers. Upon termination of service, the deposit is returned to the customer through application on the final invoice. Revenue and expenditures are tied to the enrollment and termination of service. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Water Works Customer Deposit Enterprise City Funds Form 3 81 Fund Name Fund Number 625 Fund Type Date Updated 4/12/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 8,500 321 1,435 730 - 7,065 17% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 2,046,391 164,000 492,000 511,515 - 1,554,391 24% Total Revenue 2,054,891 164,321 493,435 512,245 - 1,561,456 24% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 2,046,391 - - - - 2,046,391 0% Capital - - - - - - 0% Transfers Out 8,500 321 1,425 724 - 7,075 17% Total Expenditures 2,054,891 321 1,425 724 - 2,053,466 0% Net - 164,000 492,009 511,521 - (492,009) Cash Balance 542,167 515,926 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. It receives transfers from the Water Works Operations Fund #620. Biannual installments are disbursed at the end of June and December. June's payment includes 50% of the annual interest and December's payment comprises the rest of the interest and all of the principal. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Water Works Sinking Enterprise City Funds Form 3 82 Fund Name Fund Number 626 Fund Type Date Updated 4/12/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 16,000 1,235 3,462 4,143 - 12,538 22% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,000 1,235 3,462 4,143 - 12,538 22% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 16,000 - - 2,050 - 16,000 0% Total Expenditures 16,000 - - 2,050 - 16,000 0% Net - 1,235 3,462 2,092 - (3,462) Cash Balance 1,430,826 1,641,654 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The purpose of this fund is to ensure compliance with certain debt service bond covenants. Required balance is determined by debt service financing arrangements at the time of issuance. Interest earnings are transferred to Water Works Operations Fund #620. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Water Works Bond Reserve Enterprise City Funds Form 3 83 Fund Name Fund Number 629 Fund Type Date Updated 4/12/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 23,000 2,292 6,035 5,800 - 16,965 26% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 151,500 - 151,272 227,461 - 228 100% Total Revenue 174,500 2,292 157,307 233,261 - 17,193 90% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 23,000 2,292 5,581 2,894 - 17,419 24% Total Expenditures 23,000 2,292 5,581 2,894 - 17,419 24% Net 151,500 - 151,727 230,367 - (227) Cash Balance 2,614,000 2,462,728 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. The Cash Balance of this fund is equivalent to two months' worth of the amended annual operating expenditure budget in Water Works Operatons Fund #620, excluding transfers. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Water Works Reserve Operations & Maintenance Enterprise City Funds Form 3 84 Fund Name Fund Number 640 Fund Type Date Updated 4/17/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 613,924 53,742 160,307 155,101 - 453,617 26% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 7,864 1,563 4,266 4,281 - 3,598 54% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 621,788 55,305 164,574 159,382 - 457,214 26% Expenditures Personnel 219,798 14,815 42,758 35,358 - 177,040 19% Supplies 37,970 150 4,641 9,596 4,157 29,172 23% Services 262,444 14,876 77,232 63,650 21,692 163,520 38% Debt Service 14,297 - - - - 14,297 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 534,509 29,841 124,631 108,604 25,849 384,028 28% Net 87,279 25,464 39,942 50,778 (25,849) 73,186 Cash Balance 1,799,731 1,729,237 Staffing Budget Actual Full Time 2.70 2.70 Part-Time /Seasonal/Temporary - - Total 2.70 2.70 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects 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 maximum $500.00 deductible toward the cost of the repair and the city pays the rest. This program is fully staffed with the hiring of a new Sewer Manager. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Sewer Repair Insurance Enterprise City Funds Form 3 85 Fund Name Fund Number 641 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits 3,500 4,580 4,580 1,500 - (1,080) 131% Charges for Services 37,016,904 3,108,251 9,445,849 9,122,198 - 27,571,055 26% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 65,000 12,793 34,559 24,650 - 30,441 53% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 56,500 124 4,264 3,827 - 52,236 8% Transfers In 30,000 4,065 10,225 4,911 - 19,775 34% Total Revenue 37,171,904 3,129,813 9,499,477 9,157,085 - 27,672,427 26% Expenditures Personnel 7,750,680 557,885 1,676,668 1,585,273 6 6,074,006 22% Supplies 2,116,554 54,196 251,349 346,098 154,756 1,710,449 19% Services 15,740,085 699,115 2,671,295 1,711,574 5,136,780 7,932,009 50% Debt Service 882,869 25,081 305,728 216,113 2,154 574,987 35% Capital - - - - - - 0% Transfers Out 18,052,147 2,410,884 3,910,750 4,097,418 - 14,141,398 22% Total Expenditures 44,542,335 3,747,161 8,815,789 7,956,475 5,293,697 30,432,849 32% Net (7,370,431) (617,349) 683,688 1,200,610 (5,293,697) (2,760,422) Cash Balance 14,498,182 10,304,091 Staffing Budget Actual Full Time 94.25 91.25 Part-Time /Seasonal/Temporary 11.47 0.82 Total 105.72 92.07 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the operations of the Wastewater Department, Sewer Department, Organic Resources Department, and Concrete Crew. Sewer rates have increased recently due to higher operating costs and to cover the costs for the EPA-mandated Long Term Control Plan (LTCP), a construction project designed to address overflow issues. License & Permits revenue received this month was for system development fees, a new fee that was not originally budgeted for. Interest earnings are significantly higher than expected; the revenue budget will be revised mid-year to recognize this change. Other income, which is mostly inter- fund reimbursements for sewer cuts and concrete repairs, is usually received in Summer and early Fall. Service expenses appear high due to encumbrances for outside engineering services, manhole/sewer linings, annual contracts and maintenance agreements, and building and equipment repair contracts that have spoken for nearly a third of the annual budget. Sewage Works capital expenditures are accounted for in the Sewage Works Capital Fund #642. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Sewage Works Operations Enterprise City Funds Form 3 86 Fund Name Fund Number 642 Fund Type Date Updated 4/6/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 45,000 5,255 15,282 22,105 - 29,718 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 400,000 - 400,000 - - - 100% Transfers In 4,442,000 - - - - 4,442,000 0% Total Revenue 4,887,000 5,255 415,282 22,105 - 4,471,718 8% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 8,040,455 178,442 1,864,759 839,251 1,946,461 4,229,234 47% Transfers Out - - - - - - 0% Total Expenditures 8,040,455 178,442 1,864,759 839,251 1,946,461 4,229,234 47% Net (3,153,455) (173,187) (1,449,478) (817,146) (1,946,461) 242,484 Cash Balance 5,767,535 7,937,184 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. The $400,000 other income was received in February from the Pokagon Band to cover part of the cost of a new lift station at the site of their tribal village and casino. Year to Date totals spent include: Wastewater Treatment Plant Secondary Improvements $954,303, Grit & Screening Improvements $6,248, Calvert St. Lift Station $194,592. Sewer Vactor Truck $331,398, Sewer Dept Crew Trucks $89,192, Sewer Dump Truck $207,540, Wastewater Crew Trucks $44,596, Wastewater Cargo Van $36,890. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Sewage Works Capital Enterprise City Funds Form 3 87 Fund Name Fund Number 643 Fund Type Date Updated 4/3/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 30,000 4,065 11,081 9,693 - 18,919 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 516,755 516,755 516,755 896,725 - - 100% Total Revenue 546,755 520,820 527,836 906,418 - 18,919 97% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 30,000 4,065 10,225 4,911 - 19,775 34% Total Expenditures 30,000 4,065 10,225 4,911 - 19,775 34% Net 516,755 516,755 517,611 901,507 - (856) Cash Balance 5,153,129 4,575,374 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The purpose of this fund is to hold the equivalent of two month's of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. The funds transferred in this month are to bring the fund balance in compliance with City policy. Interest earned on the fund balance is transferred to Sewage Works Operating Fund #641. Not applicable to this fund. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Sewage Works Reserve Operations & Maint. Enterprise City Funds Form 3 88 Fund Name Fund Number 649 Fund Type Date Updated 4/6/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 13,000 1,384 2,964 3,397 - 10,036 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,164,024 1,525,595 2,288,393 2,282,678 - 6,875,632 25% Total Revenue 9,177,024 1,526,979 2,291,357 2,286,075 - 6,885,667 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 9,163,754 - 1,500 1,850 - 9,162,254 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,163,754 - 1,500 1,850 - 9,162,254 0% Net 13,270 1,526,979 2,289,857 2,284,225 - (2,276,587) Cash Balance 3,105,519 3,088,965 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used to pay all debt service obligations for Wastewater and Sewers. Mandatory transfers from Sewage Works Operating Fund #641 are done in specified amounts each month to satisfy bond covenants. Debt has grown significantly in recent years as the City continues work on the EPA-mandated Long-Term Control Plan (LTCP). Payments are due in June and December. Not applicable to this fund. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Sewage Sinking Enterprise City Funds Form 3 89 Fund Name Fund Number 653 Fund Type Date Updated 4/3/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 4,400 1,176 2,132 637 - 2,268 48% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 4,400 1,176 2,132 637 - 2,268 48% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 4,400 1,176 2,132 637 - 2,268 Cash Balance 4,113,764 4,106,261 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for required debt service reserves as required by bond documents. This Debt Reserve fund is held in a separate account at Bank of NY Mellon Trust. The account was fully funded for existing debt in 2013. Due to the re-funding of three older Sewer Bonds in 2015, the required reserve now has a lower cash balance. A reconcilliation of this account is done on a monthly basis. Not applicable to this fund. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Sewage Debt Service Reserve Enterprise City Funds Form 3 90 Fund Name Fund Number 659 Fund Type Date Updated 4/3/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - 45 125 598 - (125) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 45 125 598 - (125) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 51,688 - - - 51,687 1 100% Transfers Out - - - - - - 0% Total Expenditures 51,688 - - - 51,687 1 100% Net (51,688) 45 125 598 (51,687) (126) Cash Balance 51,803 232,492 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for expenditures of bond proceeds. This Sewage Works Revenue Bond closed in October of 2011. The remaining cash balance has been nearly encumbered and is expected to be spent this year. The significant projects this bond has funded are listed below. From issue late in 2011, this bond has funded numerous projects including Diamond Ave. Trunk Sewer, Phase II $3.7 million, East Bank Sewer Separation, Phase II $2.8 million, East Bank Sewer Separation, Phase III $2.3 million, LaSalle School Area Sewer Separation, $1.7 million, East Bank Sewer Separation, Phase III $545,000, Southwood Sewer Separation, $1,438,816, 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,945,471. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Sewer Bond 2011 Enterprise City Funds Form 3 91 Fund Name Fund Number 661 Fund Type Date Updated 4/3/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 50,000 2,530 7,111 35,432 - 42,889 14% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 50,000 2,530 7,111 35,432 - 42,889 14% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 250,000 - - - - 250,000 0% Debt Service - - - - - - 0% Capital 2,760,364 113,521 283,471 1,707,327 2,052,748 424,145 85% Transfers Out - - - - - - 0% Total Expenditures 3,010,364 113,521 283,471 1,707,327 2,052,748 674,145 78% Net (2,960,364) (110,991) (276,360) (1,671,895) (2,052,748) (631,256) Cash Balance 2,609,996 12,579,754 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for expenditures of bond proceeds. Current year spending from this Bond has been for East Bank Sewer Separation, Phase 5 $113,521, Wastewater Treatment Plant Grit/Screening Improvements $4,500, Wastewater Treatment Secondary Improvements $165,450. Since issue through December 2015, projects funded from this Bond include: East Bank Sewer Separation-Phase 4 $2.6 million, Diamond Ave. Sewer Separation Phase 3, $2.6 million, Prairie Avenue Sewer Separation-Phase I $600,445, Southwood Sewer Separation $919,608, Fairfax Sewer $70,022, East Bank Sewer Separation-Phase 5 $1,431,906, Sewer Sensory Control Network $193,609, Wastewater Treatment Plant Grit/Screening Improvements $184,716, Secondary Improvements $2,838,756, CSO LTCP re-look $1,714,206, and misc other $2,070. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Sewer Bond 2012 Enterprise City Funds Form 3 92 Fund Name Fund Number 664 Fund Type Date Updated 4/3/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - 12 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 12 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - 12 - - Cash Balance - 4,518 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounted for issuance costs for the 2013A Sewer Refunding Bonds. The issuance costs were paid in 2013. In 2016, the remaining cash balance was transferred to the Sewage Sinking Fund #649 to be used for loan payments. Not applicable to this fund. City of South Bend, Indiana Monthly Financial Report March 31, 2017 2013A Cost of Issuance Fund Enterprise City Funds Form 3 93 Fund Name Fund Number 666 Fund Type Date Updated 4/3/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - 85 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 85 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 2,500 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 2,500 - - 0% Net - - - (2,415) - - Cash Balance - 6,675 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounted for the issuance costs of the 2015 Sewer Bond refunding. This fund was set up to pay the legal and financial accounting costs associated with the refunding of the 2006, 2007, and 2007B Sewer bonds. Most of those expenses were paid in December, 2015. In 2016, the cash balance in this fund was transferred to Sewage Sinking Fund #649 to be used for loan payments. Not applicable to this fund. City of South Bend, Indiana Monthly Financial Report March 31, 2017 2015 Sewer Bond Issuance Enterprise City Funds Form 3 94 Fund Name Fund Number 670 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date 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,275,000 (318,750) 318,750 656,725 - 956,250 25% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services 2,909,311 93,164 578,151 748,411 - 2,331,160 20% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 10,000 578 697 7,292 - 9,303 7% Transfers In - - - - - - 0% Total Revenue 4,194,311 (225,009) 897,599 1,412,428 - 3,296,712 21% Expenditures Personnel 2,327,806 176,216 506,541 497,427 - 1,821,265 22% Supplies 513,040 17,785 98,060 151,593 - 414,980 19% Services 1,144,768 (209,341) 11,564 307,621 - 1,133,204 1% Debt Service - - - - - - 0% Capital 126,529 - - - - 126,529 0% Transfers Out 82,167 - - - - 82,167 0% Total Expenditures 4,194,310 (15,339) 616,165 956,640 - 3,578,145 15% Net 1 (209,669) 281,434 455,788 - (281,433) Cash Balance 1,794,924 1,678,323 Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the operating costs of Century Center, the City's convention center. Century Center is currently managed by SMG Corporation. 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Century Center Enterprise City Funds Fund 670 and 671 are reported on an accrual basis, unlike the rest of the City's funds. Form 3 95 Fund Name Fund Number 671 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 750 74 214 249 - 536 28% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 750 74 214 249 - 536 28% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 750 74 214 249 - 536 Cash Balance 866,200 1,002,321 Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2012 to account for capital expenditures at Century Center. A separate capital bank account has been maintained. In 2013, the fund received a capital contribution of $575,000 from the new facility manager and a $100,000 allocation of Professional Sports Development Area (PSDA) taxes. 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Century Center Capital Enterprise City Funds Fund 670 and 671 are reported on an accrual basis, unlike the rest of the City's funds. Form 3 96 Fund Name Fund Number 672 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 110,130 4 14 12 - 110,116 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 82,167 - - - - 82,167 0% Total Revenue 192,297 4 14 12 - 192,283 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 192,297 - - - - 192,297 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 192,297 - - - - 192,297 0% Net - 4 14 12 - (14) Cash Balance 57,067 50,044 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2015 to account for debt service payments of the 2015 Century Center Energy Conservation bonds. This fund receives a federal interest rebate, transfers from Century Century Operating Fund (670), and a County hotel/motel tax allocation. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Century Center Energy Conservation Debt Svc Enterprise City Funds Form 3 97 Fund Name Fund Number 222 Fund Type Date Updated 4/10/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits 11,400 49 196 510 - 11,204 2% Charges for Services 3,754,119 277,929 797,639 713,399 - 2,956,480 21% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 6,800 974 2,306 2,935 - 4,494 34% Bond Proceeds - - - - - - 0% Donations 10,000 - - - - 10,000 0% Other Income 4,526,250 431,707 1,274,584 1,155,106 - 3,251,666 28% Transfers In - - - - - - 0% Total Revenue 8,308,569 710,659 2,074,725 1,871,950 - 6,233,844 25% Expenditures Personnel 3,288,165 230,959 686,097 612,139 15 2,602,053 21% Supplies 170,652 (33,585) 9,390 41,197 18,111 143,152 16% Services 4,803,470 363,754 1,241,644 1,167,230 2,400,572 1,161,255 76% Debt Service 15,656 835 3,829 1,325 3,969 7,858 50% Capital - - - - - - 0% Transfers Out 286,700 - - - - 286,700 0% Total Expenditures 8,564,643 561,962 1,940,960 1,821,890 2,422,666 4,201,017 51% Net (256,074) 148,696 133,765 50,059 (2,422,666) 2,032,827 Cash Balance 1,534,798 1,443,639 Staffing Budget Actual Full Time 42.00 40.00 Part-Time /Seasonal/Temporary 2.00 2.00 Total 44.00 42.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects 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. In March we had 1,514 vehicle repairs. Average Fuel prices for Mar. is $1.70 for Unleaded and $1.80 for Diesel. Budgeted amount per gallon is $2.50. Equipment Services continues to purchase new vehicles with compressed natural gas or hybrids The Compressed Natural Gas price is $1.37. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Central Services Internal Service City Funds Form 3 98 Fund Name Fund Number 224 Fund Type Date Updated 4/10/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 900 89 246 476 - 654 27% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 286,700 - - - - 286,700 0% Total Revenue 287,600 89 246 476 - 287,354 0% Expenditures Personnel - - - - - - 0% Supplies 28,000 - 1,572 - 21,653 4,775 83% Services 69,025 - 13,012 - 8,750 47,263 32% Debt Service - - - - - - 0% Capital 229,000 - - 23,369 - 229,000 0% Transfers Out - - - - - - 0% Total Expenditures 326,025 - 14,585 23,369 30,403 281,038 14% Net (38,425) 89 (14,339) (22,893) (30,403) 6,317 Cash Balance 97,823 164,026 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for capital expenditures for the Central Services department. This fund receives transfers from the Central Services Operating Fund (222). Some expenses are carry overs from 2016. Replacement of Inground Hoists at the Riverside North Garage, new mobile portable lifts for Sample Street garage, one stand alone Hyd. Press City of South Bend, Indiana Monthly Financial Report March 31, 2017 Central Services Capital Internal Service City Funds Form 3 99 Fund Name Fund Number 226 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 2,927,591 241,179 728,311 551,892 - 2,199,280 25% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 30,000 4,088 11,110 11,691 - 18,890 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600,000 - 35,742 12,878 - 564,258 6% Transfers In - - - - - - 0% Total Revenue 3,557,591 245,267 775,164 576,462 - 2,782,427 22% Expenditures Personnel 268,799 23,547 64,821 48,005 - 203,979 24% Supplies 21,062 112 3,068 2,901 2,358 15,635 26% Services 3,297,725 125,232 437,689 384,401 224,396 2,635,640 20% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,587,586 148,890 505,578 435,308 226,755 2,855,254 20% Net (29,995) 96,376 269,586 141,154 (226,755) (72,826) Cash Balance 4,876,880 4,666,614 Staffing Budget Actual Full Time 2.00 2.00 Part-Time /Seasonal/Temporary - - Total 2.00 2.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This internal service fund handles operations relating to business insurance and claims--property, liability, workers compensation, etc.--and the operation of the Safety and Risk Department. Revenues for this fund come from other City funds who pay a share proportionate to their expected expense. The City has budgeted $1 million in 2017 for expected liability cliams, $800,000 for for the City's portion of cost of Beck's Lake clean-up, and $603,386 in expected workers compensation activities. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Liability Insurance Internal Service City Funds Form 3 100 Fund Name Fund Number 278 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 4,000 660 1,796 1,660 - 2,204 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 26,780 - - 0% Transfers In - - - - - - 0% Total Revenue 4,000 660 1,796 28,440 - 2,204 45% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,000 - 972 53 - 9,028 10% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,000 - 972 53 - 9,028 10% Net (6,000) 660 825 28,386 - (6,825) Cash Balance 753,676 669,859 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund charges police officers for liability insurance and gasoline costs for take home police vehicles. Claims have been minimal in this fund since it was created. This fund is classified as an Internal Service Fund for financial reporting. The cash reserves in this fund have increased in recent years. The revenue is the amount deducted from officers' pay for the vehicle take home program. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Take Home Vehicle Police Internal Service City Funds Form 3 101 Fund Name Fund Number 279 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 5,205,034 430,621 1,291,863 117,939 - 3,913,171 25% Transfers In - - - - - - 0% Total Revenue 5,205,034 430,621 1,291,863 117,939 - 3,913,171 25% Expenditures Personnel 2,119,953 139,309 419,201 110,716 - 1,700,752 20% Supplies 981,191 4,843 11,817 1,174 12,779 956,595 3% Services 1,940,570 56,373 282,616 6,229 508,835 1,149,119 41% Debt Service 163,320 5,000 24,300 - - 139,020 15% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,205,034 205,525 737,935 118,119 521,614 3,945,485 24% Net - 225,096 553,928 (180) (521,614) (32,314) Cash Balance 553,928 200 Staffing Budget Actual Full Time 20.00 20.00 Part-Time /Seasonal/Temporary 2.00 2.00 Total 22.00 22.00 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This internal service fund was established in 2016 to track the operational revenues and expenditures on the 311 Call Center, whose expenses in previous years were charged to the General Fund. The 311 Call Center was established to handle citizen telephone calls in an efficient and effective manner. It provides citizens with a "one-stop" shop to contact city departments with inquiries and service requests. Starting in 2017, the Department of Innovation & Technology was moved to this fund. The IT Dept provides technical services to the various departments within the City. This fund's revenue is a monthly allocation between the various City departments that are served by the 311 Call Center and IT Department. Expenditures are predominantly related to salaries & benefits and IT software services. Outstanding encumbrances for supplies are for items that have been ordered and not yet invoiced and for wiring that has been scheduled to be performed. Outstanding encumbrances for services are mainly various software services. PO's are set at the beginning of the year, but services are paid out on a monthly basis. The major expenditures are for Sungard NaviLine hosting, Amazon Web Services hosting, VoIP Phone Service, internet service, storage service, Tier1 Help Desk Support, and MyStaffingPro. The 311 Call Center has 6 full-time employees and 2 part-time employees. The Dept of Innovation & Technology has 14 full-time employees. City of South Bend, Indiana Monthly Financial Report March 31, 2017 IT & Innovation/311 Call Center Internal Service City Funds Form 3 102 Fund Name Fund Number 711 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 17,755,850 1,492,929 4,452,424 4,131,557 - 13,303,426 25% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 40,000 6,771 18,027 11,932 - 21,973 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 496 4,563 756 - (4,563) 0% Transfers In - - - - - - 0% Total Revenue 17,795,850 1,500,195 4,475,013 4,144,244 - 13,320,837 25% Expenditures Personnel - - - - - - 0% Supplies 78,935 2,475 19,866 4,397 33,261 25,808 67% Services 1,216,040 23,886 290,293 516,691 812,653 113,095 91% Insurance 16,508,225 925,031 3,044,460 3,493,375 82,311 13,381,454 19% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 17,803,200 951,392 3,354,619 4,014,463 928,225 13,520,357 24% Net (7,350) 548,803 1,120,395 129,782 (928,225) (199,520) Cash Balance 7,851,210 4,498,880 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund handles expenses relating to insurance and claims relating to employees, including medical, dental, life, flex spending, etc. An Employee Wellness Center was opened on January 18, 2016, which was set in place with the understanding that the City should see a drop in claims expenses over time. For 2017, the City will pay the Wellness Center approx $996,000. This accounts for the majority of the services budget and $755K of the encumbrances. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Self-Funded Employee Benefits Internal Service City Funds Form 3 103 Fund Name Fund Number 713 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services 81,000 - - 2,903 - 81,000 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 2,000 244 675 690 - 1,325 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 83,000 244 675 3,593 - 82,325 1% Expenditures Personnel 45,000 4,080 15,341 8,346 - 29,659 34% Supplies - - - - - - 0% Services 39,105 309 3,127 6,221 11,000 24,978 36% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 84,105 4,389 18,468 14,567 11,000 54,637 35% Net (1,105) (4,145) (17,793) (10,974) (11,000) 27,688 Cash Balance 268,759 258,308 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2011 to account for unemployment claims and outplacement services paid. All unemployment claims and outplacement services are paid through this fund. Typically, this fund charges an allocation of 0.25% of payroll to most departments to cover the cost of unemployment claims paid. However, beginning in Nov 2016, the charge of 0.25% of payroll costs was suspended indefinitely due to the fund's high cash reserves. The allocation will remain suspended during 2017. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Unemployment Compensation Internal Service City Funds Form 3 104 Fund Name Fund Number 701 Fund Type Date Updated Control Current Current Current Prior Amended Month Year to Date 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,212,638 - - - - 5,212,638 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 4,500 - 419 1,061 - 4,081 9% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,217,138 - 419 1,061 - 5,216,719 0% Expenditures Personnel 5,091,119 393,094 1,177,865 1,232,953 - 3,913,254 23% Supplies 200 - 10 13 - 190 5% Services 6,950 3,108 3,290 3,398 - 3,660 47% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,098,269 396,201 1,181,165 1,236,364 - 3,917,104 23% Net 118,869 (396,201) (1,180,746) (1,235,304) - 1,299,615 Cash Balance (1,013,174) (763,000) Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the operation of a pension plan for former Fire Department employees and receives reimbursement from the State of Indiana. Retiree health insurance payments are paid through this fund through 2016; this cost is not reimbursed by the state. 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 2016, the total amount received was $4,866,271.32. The first payment was received in June in the amount of $2,434,635.66. The second payment was received in September in the amount of $2,431,635.66. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Firefighters Pension Trust & Agency City Funds Form 3 105 Fund Name Fund Number 702 Fund Type Date Updated 4/12/2017 Control Current Current Current Prior Amended Month Year to Date 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,130,000 - - - - 6,130,000 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 4,500 215 9,525 2,773 - (5,025) 212% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,000 5,700 7,898 - - (5,898) 395% Transfers In - - - - - - 0% Total Revenue 6,136,500 5,915 17,423 2,773 - 6,119,077 0% Expenditures Personnel 6,415,689 523,297 1,544,261 1,693,353 - 4,871,428 24% Supplies 800 - - - - 800 0% Services 7,400 - 3,276 3,097 - 4,124 44% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,423,889 523,297 1,547,536 1,696,450 - 4,876,353 24% Net (287,389) (517,382) (1,530,114) (1,693,678) - 1,242,725 Cash Balance (745,457) (536,453) Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the operation of a pension plan for former Police Department employees and receives reimbursement from the State of Indiana. Retiree health insurance is paid from this fund through 2016; this cost is not reimbursed by the state. 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 total amount received was $5,991,750.09. The first payment was received in June in the amount of $2,997,375.05. The second payment was received in September in the amount of $2,994,375.04. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Police Pension Trust & Agency City Funds Form 3 106 Fund Name Fund Number 730 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 200 25 69 74 - 131 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 200 25 69 74 - 131 34% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 6,000 - - - - 6,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,000 - - - - 6,000 0% Net (5,800) 25 69 74 - (5,869) Cash Balance 28,872 28,615 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This trust fund is designated for expenses specifically for the City Cemetery. Revenue was 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. This fund is managed by the Parks Department. $6,000 has been generically budgeted for repairs, but no specific projects exist at this time. City of South Bend, Indiana Monthly Financial Report March 31, 2017 City Cemetery Trust & Agency City Funds Form 3 107 Fund Name Fund Number 750 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 1,000 375 673 - - 327 67% Bond Proceeds 5,499,000 - - - - 5,499,000 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,500,000 375 673 - - 5,499,327 0% Expenditures Personnel - - - - - - 0% Supplies 230,000 - - - - 230,000 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 5,270,000 489,584 1,472,626 - - 3,797,374 28% Transfers Out - - - - - - 0% Total Expenditures 5,500,000 489,584 1,472,626 - - 4,027,374 27% Net - (489,209) (1,471,953) - - 1,471,953 Cash Balance 1,705,941 - Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used to pay for City vehicles and equipment that are financed by a lease. The funds are maintained by trustee financial institutions and expended upon the provision by the City of a proper claim form and invoice. The trustee escrow accounts have been maintained by the City for many years and the desire is to integrate these records into the formal accounting system in 2017. The City leases certain vehicles and equipment for the police department, public works and other departments and pays them through capital lease proceeds that are accounted for in this fund. These are the major budgeted capital expenditures: Solid Waste - $275,000 CNG Trash Truck, $65,000 Pickup Truck with Dump Bed, $250,000 Grapple Truck Police - $1,250,000 Police Cars, $250,000 Police Car Equipment EMS - $1,000,000 Aerial Truck Street Dept - $450,000 Tandem Axle Dump Trucks (Qty 2) Building Dept - $90,000 2017 4WD Pickup Trucks (Qty 2), $45,000 2018 Chassis Animal Care & Control - $30,000 Animal Box Water Works - $960,000 Water Meters City of South Bend, Indiana Monthly Financial Report March 31, 2017 Equipment/Vehicle Leasing Trust & Agency City Funds Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus, changes are entered in the general ledger the following month. Form 3 108 Fund Name Fund Number 751 Fund Type Date Updated 4/14/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 7,500 539 908 - - 6,592 12% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 7,500 539 908 - - 6,592 12% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 3,500,000 211,200 274,356 - - 3,225,644 8% Transfers Out - - - - - - 0% Total Expenditures 3,500,000 211,200 274,356 - - 3,225,644 8% Net (3,492,500) (210,662) (273,449) - - (3,219,051) Cash Balance 4,063,750 - Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used to account for the bond proceeds and expenditures of the 2015 Parks/EDIT bond that is accounted for by US Bank in trustee accounts. The original bond was issued in 2015 for $5,605,000. The City submits pay requests for costs incurred under the bond to US Bank. This fund was established in 2017 to integrate these trustee accounts into the City's regular accounting system. The vast majority of the $211K spent on capital is for an HVAC upgrade at the Martin Luther King Center. Capital expenditures include $42,747 for upgrades to the HVAC system at the Martin Luther King Center and $20,000 for miscellaneous park improvements. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Parks Bond Capital Trust & Agency City Funds Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus, changes are entered in the general ledger the following month. Form 3 109 Fund Name Fund Number 753 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 17,000 663 1,267 - - 15,733 7% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 17,000 663 1,267 - - 15,733 7% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 10,000,000 285,891 1,272,543 - - 8,727,457 13% Transfers Out - - - - - - 0% Total Expenditures 10,000,000 285,891 1,272,543 - - 8,727,457 13% Net (9,983,000) (285,228) (1,271,276) - - (8,711,724) Cash Balance 4,658,178 - Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The purpose of the Smart Streets Bond Capital Fund is to account for the remaining expenditures from the bond issued in 2015 in the amount of $25,000,000. Conversion from 1-way to 2-way streets and other improvements associated with the conversion project. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Smart Streets Bond Capital Trust & Agency City Funds Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus, changes are entered in the general ledger the following month. Form 3 110 Fund Name Fund Number 324 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 17,808,613 - - - - 17,808,613 0% Local Income Taxes - - - - - - 0% Other Taxes 394,000 - - - - 394,000 0% Grants/Intergovernmental - 33,745 33,745 - - (33,745) 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 100,957 24,974 72,369 82,737 - 28,588 72% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,430,725 26,005 171,976 107,417 - 4,258,749 4% Transfers In 29,000 2,424 6,111 3,534 - 22,889 21% Total Revenue 22,763,295 87,148 284,201 193,687 - 22,479,094 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,935,776 50,616 342,317 109,185 2,547,901 1,045,558 73% Debt Service 8,182,182 100,000 3,649,640 2,616,949 - 4,532,542 45% Capital 27,500,929 1,284,245 1,914,352 4,541,465 4,289,027 21,297,551 23% Transfers Out - - - - - - 0% Total Expenditures 39,618,887 1,434,861 5,906,309 7,267,599 6,836,928 26,875,650 32% Net (16,855,592) (1,347,713) (5,622,107) (7,073,911) (6,836,928) (4,396,557) Cash Balance 26,888,014 27,328,950 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Collection of Tax Increment Financing Revenues for the River West Development Area. In 2016, major expenditures (other than debt service) included: Ignition Park Infrastructure; LaSalle Hotel; Safe Routes to School @ Harrison School; Advanced Center for Cancer Care; Lippert; Nello; Western Restriping; Hoffman Hotel; Ignition Park Multi-Tenant Bldg; Ignition Park Land Improvements; Bartlett Roundabout; Coal Line Trail; Patel Hotel/Plaza; Ameriplex Lease; Chet Waggoner Drive; Airport Authority; Ignition Park Signage. Expenditures thus far in 2017 include: $232K for Chet Waggoner Drive; $110K for Four Winds Field Planning Area Improvements; $330K for JMS Building; $116K LaSalle Building; $401K Nello; and $330K Berlin Flats. City of South Bend, Indiana Monthly Financial Report March 31, 2017 TIF - River West Development Area (Airport) Tax Increment Financing Redevelopment Commission Controlled Funds Form 3 111 Fund Name Fund Number 422 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 420,000 - - - - 420,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 16,000 1,721 4,629 3,865 - 11,371 29% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 436,000 1,721 4,629 3,865 - 431,371 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,284 2,420 2,420 6,827 864 0 100% Debt Service - - - - - - 0% Capital 1,425,008 - - - 515,250 909,758 36% Transfers Out - - - - - - 0% Total Expenditures 1,428,292 2,420 2,420 6,827 516,114 909,758 36% Net (992,292) (699) 2,209 (2,962) (516,114) (478,387) Cash Balance 1,963,267 1,503,862 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the TIF revenue and expenses of those funds on eligible development projects for this TIF area. Major projects committed thus far in 2017 are: City Cemetery Project. City of South Bend, Indiana Monthly Financial Report March 31, 2017 TIF - West Washington Tax Increment Financing Redevelopment Commission Controlled Funds Form 3 112 Fund Name Fund Number 425 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 1,706 146 398 425 - 1,308 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 195,308 10,351 34,762 35,301 - 160,546 18% Transfers In - - - - - - 0% Total Revenue 197,014 10,498 35,160 35,726 - 161,854 18% Expenditures Personnel - - - - - - 0% Supplies 10,342 - 145 1,148 - 10,197 1% Services 147,824 4,480 18,778 14,838 - 129,046 13% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 158,166 4,480 18,923 15,986 - 139,243 12% Net 38,848 6,018 16,238 19,740 - 22,610 Cash Balance 203,048 228,557 Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund is used for South Bend downtown retail space property management. Operations under outside contract with Bradley Co. City of South Bend, Indiana Monthly Financial Report March 31, 2017 TIF - Leighton Plaza (Redevelop Retail) Tax Increment Financing Redevelopment Commission Controlled Funds Revenue and expenditures are reported one month in arrears. Form 3 113 Fund Name Fund Number 429 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 3,000,000 - - - - 3,000,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services 8,400 350 1,400 - - 7,000 17% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 57,000 6,868 18,444 19,395 - 38,556 32% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 4,124 4,124 - - (4,124) 0% Transfers In - - - - - - 0% Total Revenue 3,065,400 11,342 23,968 19,395 - 3,041,432 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 315,219 24,728 97,352 30,950 167,656 50,211 84% Debt Service - - - - - - 0% Capital 10,287,477 76,443 76,607 66,897 2,234,941 7,975,930 22% Transfers Out - - - - - - 0% Total Expenditures 10,602,696 101,171 173,959 97,847 2,402,597 8,026,141 24% Net (7,537,296) (89,829) (149,991) (78,453) (2,402,597) (4,984,709) Cash Balance 7,725,659 7,482,679 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The boundaries for this TIF district were changed during the 2015 TIF re-alignment. This fund was formerly known as the Northeast TIF. Due to changes in boundary, this area now includes a portion of South Bend Central Development Area (Fund 420). Projects committed to in 2017 include: East Bank Phase 5 CSO; Howard Park Ice Rink; Michiana Brick Demolition; Niles/Jefferson Bridge Tunnel; Newman Center Armory; and Perley School (Safe Routes to School). City of South Bend, Indiana Monthly Financial Report March 31, 2017 TIF - River East Development Area (NE Dev) Tax Increment Financing Redevelopment Commission Controlled Funds Form 3 114 Fund Name Fund Number 430 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,400,000 - - - - 2,400,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 33,000 4,388 10,916 15,537 - 22,084 33% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 1,448,127 - 561,229 - - 886,898 39% Total Revenue 3,881,127 4,388 572,145 15,537 - 3,308,982 15% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 49,988 15,321 15,321 294,460 74,328 (39,661) 179% Debt Service - - - - - - 0% Capital 6,867,438 2,099 160,753 2,565 651,563 6,055,123 12% Transfers Out - - - - - - 0% Total Expenditures 6,917,426 17,419 176,073 297,025 725,891 6,015,462 13% Net (3,036,299) (13,031) 396,071 (281,488) (725,891) (2,706,480) Cash Balance 5,017,959 5,827,126 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund accounts for the TIF revenue and expenses of those funds on eligible development projects for this TIF area. Projects committed to in 2016 include: Chippewa Improvements, Ireland & Miami Area Improvements, and Safe Routes to School (Perley). Major expenditures in 2017 are expected to be: $900K for completion of the Chippewa Roundabout and $280K for Bowen Street Improvements. City of South Bend, Indiana Monthly Financial Report March 31, 2017 TIF - Southside Development #1 Tax Increment Financing Redevelopment Commission Controlled Funds Form 3 115 Fund Name Fund Number 432 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 6,000 791 7,921 13,344 - (1,921) 132% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 791 7,921 13,344 - (1,921) 132% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 3,961,668 - 3,961,667 365,835 - 1 100% Capital - - - - - - 0% Transfers Out 917,127 - - - - 917,127 0% Total Expenditures 4,878,795 - 3,961,667 365,835 - 917,128 81% Net (4,872,795) 791 (3,953,746) (352,491) - (919,049) Cash Balance 904,519 4,949,904 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was used to pay debt service. The bond was paid off in February 2017. The Redevelopment Commission passed a resolution in to close the allocation area. The remaining cash will be transferred to South Side #1 (Fund 430) and the fund closed. City of South Bend, Indiana Monthly Financial Report March 31, 2017 TIF - Southside Development #3 Tax Increment Financing Redevelopment Commission Controlled Funds Form 3 116 Fund Name Fund Number 435 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 327,108 - - - - 327,108 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 750 95 292 317 - 458 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 327,858 95 292 317 - 327,566 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 9,104 - - - 4,200 4,904 46% Debt Service 335,112 - 150,000 140,000 - 185,112 45% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 344,216 - 150,000 140,000 4,200 190,016 45% Net (16,358) 95 (149,708) (139,683) (4,200) 137,550 Cash Balance 7,025 11,983 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The Douglas Road TIF was established to develop the road and area near the border between South Bend and Mishawaka. The fund borrowed money from the City of Mishawaka and Major Moves Fund (412) to finance construction. TIF tax revenue is used to repay the loans. During February 2015, the amounts due to the City of Mishawaka was paid in full. Payments will now be accelerated on the Major Moves loan in order to pay it off as early as available cash allows. City of South Bend, Indiana Monthly Financial Report March 31, 2017 TIF - Douglas Road Tax Increment Financing Redevelopment Commission Controlled Funds Form 3 117 Fund Name Fund Number 436 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 3,298,403 - - - - 3,298,403 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants/Intergovernmental - - - - - - 0% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - 210,999 - - 0% Interest Earnings 2,500 - 442 2,109 - 2,058 18% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 3,300,903 - 442 213,108 - 3,300,461 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 65,050 - - - - 65,050 0% Debt Service 3,365,181 - 1,683,089 1,684,089 - 1,682,092 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,430,231 - 1,683,089 1,684,089 - 1,747,142 49% Net (129,328) - (1,682,647) (1,470,981) - 1,553,319 Cash Balance 713,706 149,037 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The boundaries for this TIF district were changed as part of the TIF re-alignment during 2015. The fund was formerly known as the Northeast Residential TIF. Expenditures are related to debt service for the Eddy Street Commons Project--payment on the ESC Bonds and reimbursement to Major Moves fund for project costs. City of South Bend, Indiana Monthly Financial Report March 31, 2017 TIF - River East Residential (NE Res) Tax Increment Financing Redevelopment Commission Controlled Funds Form 3 118 Fund Name Fund Number 433 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 135 7 20 22 - 115 15% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 135 7 20 22 - 115 15% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,500 - - - - 4,500 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,500 - - - - 4,500 0% Net (4,365) 7 20 22 - (4,385) Cash Balance 8,473 8,724 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund's sole expenditure is for general legal fees for DCI. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Redevelopment General Redevelopment Redevelopment Commission Controlled Funds Form 3 119 Fund Name Fund Number 439 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - 1,887 5,142 5,887 - (5,142) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1,887 5,142 5,887 - (5,142) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - 142,913 - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 142,913 - - 0% Net - 1,887 5,142 (137,026) - (5,142) Cash Balance 2,155,565 2,279,193 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund receives a special state tax distribution and is used for improvements at Innovation Park and Ignition Park, the city's two certified technology parks. Capital funds are to be expended in Ignition Park and Innovation Park. 2017 Appropriation was passed on 4/13/17. $1.8M will be used on Innovation Park. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Certified Technology Park Redevelopment Redevelopment Commission Controlled Funds Form 3 120 Fund Name Fund Number 454 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 3,900 336 916 978 - 2,984 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 3,900 336 916 978 - 2,984 23% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 50,000 - - - - 50,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 50,000 - - - - 50,000 0% Net (46,100) 336 916 978 - (47,016) Cash Balance 384,011 380,599 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund has been used in the past to pay for job training programs. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Airport Urban Enterprise Zone Redevelopment Redevelopment Commission Controlled Funds Form 3 121 Fund Name Fund Number 754 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 175,000 17,704 17,704 - - 157,296 10% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 35,000 3,822 3,822 - - 31,178 11% Transfers In - - - - - - 0% Total Revenue 210,000 21,526 21,526 - - 188,474 10% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 142,000 12,887 12,887 - - 129,113 9% Debt Service 15,000 1,550 1,550 - - 13,450 10% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 157,000 14,437 14,437 - - 142,563 9% Net 53,000 7,089 7,089 - - 45,911 Cash Balance 2,724,543 - Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The Industrial Revolving Fund is a loan fund for small businesses that is governed by a separate Board of Directors which contracts with the City's Community Investment Dept for administration services. The fund is reported in the City's Comprehensive Annual Financial Report (CAFR) and is being integrated into the City's budget during 2017. A City cash reserve target has not been established for the fund but it operates under federal guidelines with respect the amount of loans and cash balances that must be maintained. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Industrial Revolving Fund Redevelopment Redevelopment Commission Controlled Funds Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus, changes are entered in the general ledger the following month. Form 3 122 Fund Name Fund Number 315 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 14,000 902 2,474 2,674 - 11,526 18% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 14,000 902 2,474 2,674 - 11,526 18% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 14,000 902 2,282 1,323 - 11,718 16% Total Expenditures 14,000 902 2,282 1,323 - 11,718 16% Net - - 192 1,351 - (192) Cash Balance 1,038,904 1,038,904 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Redevelopment Bond - Airport Taxable Debt Service Redevelopment Commission Controlled Funds Form 3 123 Fund Name Fund Number 317 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 5,000 450 1,225 1,309 - 3,775 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 450 1,225 1,309 - 3,775 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 5,000 450 1,225 1,309 - 3,775 Cash Balance 513,692 509,128 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: This fund was established in 2010 to collect reserve monies as stipulated in the bond covenants. The fund receives interest earnings revenue. This fund will be used to make the final debt service payment on January 15, 2019. 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Coveleski Debt Service Reserve Debt Service Redevelopment Commission Controlled Funds Form 3 124 Fund Name Fund Number 328 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 15,000 1,522 4,149 4,467 - 10,851 28% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,000 1,522 4,149 4,467 - 10,851 28% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 1,522 3,828 2,211 - 11,172 26% Total Expenditures 15,000 1,522 3,828 2,211 - 11,172 26% Net - - 320 2,257 - (320) Cash Balance 1,735,840 1,735,840 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects 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. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Redevelopment Bond - Palais Royale Debt Service Redevelopment Commission Controlled Funds Form 3 125 Fund Name Fund Number 752 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 2,000 263 432 - - 1,568 22% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 3,866,169 1,236,500 2,009,000 - - 1,857,169 52% Total Revenue 3,868,169 1,236,763 2,009,432 - - 1,858,737 52% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 3,868,169 2,004,503 2,004,503 - - 1,863,666 52% Capital - - - - - - 0% Transfers Out 735,236 - 735,236 - - - 100% Total Expenditures 4,603,405 2,004,503 2,739,739 - - 1,863,666 60% Net (735,236) (767,740) (730,307) - - (4,929) Cash Balance 502,462 - Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The South Bend Redevelopment Authority Funds records debt service payments received by the City that are passed through to the paying agent bank and the bondholders per bond agreements. The South Bend Redevelopment Authority is a separate legal entity that is recorded in the Comprehensive Annual Financial Report (CAFR). This fund was established in 2017 to integrate this activity into the City's formal accounting system. Debt service payments are for the 2009 Morris PAC refunding (debt schedule #11), 2011 Century Center refunding (#7), 2013 Century Center refunding (#62), and 2015 Eddy Street Commons refunding (#54). Debt payments are made twice a year, in February and August. The 2009 Morris PAC bonds are scheduled to be paid off in 2017 and the 2011 Century Center bonds are scheduled to be paid off in 2018. City of South Bend, Indiana Monthly Financial Report March 31, 2017 South Bend Redevelopment Authority Debt Service Redevelopment Commission Controlled Funds Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus, changes are entered in the general ledger the following month. Form 3 126 Fund Name Fund Number 756 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings 1,000 263 441 - - 559 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 854,784 - - - - 854,784 0% Total Revenue 855,784 263 441 - - 855,343 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 855,784 394,784 394,784 - - 461,000 46% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 855,784 394,784 394,784 - - 461,000 46% Net - (394,522) (394,343) - - 394,343 Cash Balance 1,714,097 - Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: The Smart Streets Debt Service Fund records debt service payments made on the 2015 Smart Streets bond that had a par amount of $25,000,000. The final payment is due February 1, 2037. The accounting records are maintained in US Bank trustee accounts and, beginning in 2017, will be integrated into the City's regular accounting system. City lease rental payments are received from the River West TIF Fund (324). The Smarts Streets project converted a number of downtown streets from one-way to two-way traffic and added amenities such as larger sidewalks, bicycle lanes, street trees to increase the attractiveness and economic vitality of the downtown area. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Smart Streets Debt Service Debt Service Redevelopment Commission Controlled Funds Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus, changes are entered in the general ledger the following month. Form 3 127 Fund Name Fund Number 758 Fund Type Date Updated 4/19/2017 Control Current Current Current Prior Amended Month Year to Date Year to Date 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% Licenses & Permits - - - - - - 0% Charges for Services - - - - - - 0% Fines, Forfeitures, and Fees - - - - - - 0% Interest Earnings - 82 113 - - (113) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 3,960,668 - 3,961,667 - - (999) 100% Total Revenue 3,960,668 82 3,961,780 - - (1,112) 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 3,960,668 3,961,668 3,961,668 - - (1,000) 100% Capital - - - - - - 0% Transfers Out 561,250 - 561,229 - - 21 100% Total Expenditures 4,521,918 3,961,668 4,522,897 - - (979) 100% Net (561,250) (3,961,585) (561,117) - - (133) Cash Balance - - Fund Purpose: Accounting Methodology: Explain Significant Revenue and Expenditure Changes/Variances Below: Explain Significant Spending on Capital Projects Below: In February 2017, the 2005 Erskine Village Developer Bond was paid off early, thanks to sufficient tax increment financing revenue. The City plans to close this fund in 2017. City of South Bend, Indiana Monthly Financial Report March 31, 2017 Erskine Village Debt Service Debt Service Redevelopment Commission Controlled Funds Revenue and expenditures are one month in arrears because the City receives the trustee bank statements after the books are closed. Thus, changes are entered in the general ledger the following month. Form 3 128