HomeMy WebLinkAbout05-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
76 Enterprise Funds
101 Internal Service Funds
108 Trust Funds
111 Redevelopmemt Commission Funds
Distribution
Mayor Pete Buttigieg
Interim Chief of Staff Angela Kouters
Deputy Chief of Staff Suzanna Fritzberg
Common Council
Department Heads
Fiscal Officers
Administration & Finance
May 31, 2017
Administration/Finance
May 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 May 31, 2017, total revenue for the year was $98,253,239, 30% of estimated revenue. As of May
31, 2016, total revenue received was $84,824,674 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 May 31, 2017, total expenditures were $132,372,550 and outstanding encumbrances were
$41,372,001, a total of $173,744,551 which represents 43% 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 33% of the amended expenditure budget at the end of
the period. Total expenditures, excluding encumbrances, were $106,928,864 as of May 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 the
Department of Administration & Finance.
2
City of South Bend
Monthly Department Financial Report
REVENUE SUMMARY
May 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,597,022 1,121,067 6,039,062 5,148,569 52,557,960 10%
Special Revenue
102 Rainy Day 60,000 3,906 32,522 1,440,393 27,478 54%
103 Excess Levy - - - 7 - 0%
201 Parks & Recreation 14,078,132 235,917 1,448,907 993,953 12,629,225 10%
202 Motor Vehicle Highway 9,934,110 833,924 4,565,362 4,656,499 5,368,748 46%
203 Recreation Nonreverting 1,381,787 66,022 505,671 465,968 876,116 37%
209 Studebaker-Oliver Reverting Grants 422,587 9,707 126,412 46,653 296,175 30%
210 Economic Development State Grants 73,512 135 19,103 805,930 54,409 26%
211 Department of Community Investment (DCI)2,291,309 8,536 851,635 1,307,011 1,439,674 37%
212 Dept of Community Investment Grants 3,348,000 83,939 896,430 776,235 2,451,570 27%
216 Police State Seizures 36,000 1,986 15,724 16,678 20,276 44%
217 Gift, Donation, Bequest 175,800 220 127,849 1,036 47,951 73%
218 Police Curfew Violations 1,000 17 90 149 910 9%
219 Unsafe Building 793,757 14,230 365,050 528,042 428,707 46%
220 Law Enforcement Continuing Education 221,500 18,459 128,466 119,436 93,034 58%
221 Landlord Registration 7,000 60 3,990 - 3,010 57%
227 Loss Recovery 9,000 368 3,094 3,933 5,906 34%
249 Public Safety LOIT 7,473,618 622,663 3,114,304 2,832,326 4,359,314 42%
251 Local Roads & Streets 1,674,275 107,567 527,432 781,489 1,146,843 32%
257 LOIT Special Distribution 1,471,000 1,183 165,840 4,217,549 1,305,160 11%
258 Human Rights Federal Grant 165,040 356 105,194 140,059 59,846 64%
265 Local Road & Bridge Grant 2,000,000 - 2,000,000 - - 100%
271 Eastrace Waterway 22 1 4 5 18 20%
273 Morris PAC / Palais Royale Marketing 18,300 947 3,273 6,827 15,027 18%
280 Police Block Grants 50 1 12 15 38 25%
281 Economic Develop Commission-Revenue Bonds 200 11 88 109 112 44%
289 HAZMAT 10,000 10 84 127 9,916 1%
291 Indiana River Rescue 45,500 23,462 54,475 53,504 (8,975) 120%
294 Regional Police Academy 22,500 2,483 15,410 18,911 7,090 68%
295 COPS MORE Grant 123,500 10,378 49,740 33,536 73,760 40%
299 Police Federal Drug Enforcement 32,000 161 785 552 31,215 2%
404 County Option Income Tax 10,963,839 874,964 4,751,795 4,359,990 6,212,044 43%
408 Economic Development Income Tax 11,733,257 870,753 5,642,863 4,541,857 6,090,394 48%
410 Urban Development Action Grant 6,110 207 1,796 2,281 4,314 29%
655 Project Releaf 444,556 37,325 187,022 187,004 257,534 42%
705 Police K-9 Unit 2,020 1 9 15 2,011 0%
Special Revenue Total 69,019,281 3,829,897 25,710,432 28,338,079 43,308,849 37%
City Debt Service
313 Football Hall of Fame Debt Service 938,528 10 97 46,715 938,431 0%
755 South Bend Building Corp 2,643,214 117 1,327,178 - 1,316,036 50%
757 Parks Bond Debt Service 391,482 80 130,603 - 260,879 33%
City Debt Service Total 3,973,224 207 1,457,879 46,715 2,515,345 37%
Capital Project
377 Professional Sports Development 732,000 23,146 243,475 439,598 488,525 33%
401 Coveleski Stadium Capital 40,900 35 289 292 40,611 1%
403 Zoo Endowment 200 11 151 197 49 76%
405 Park Nonreverting Capital 439,850 26,282 57,213 4,387 382,637 13%
406 Cumulative Capital Development 476,500 169 1,555 24,075 474,945 0%
407 Cumulative Capital Improvement 435,000 132 151,137 151,188 283,863 35%
412 Major Moves Construction 1,053,786 1,135 604,853 716,568 448,933 57%
416 Morris Performing Arts Center Capital 104,000 5,797 44,148 41,383 59,852 42%
434 Community Revitalization Enhancement District - - - 271 - 0%
450 Palais Royale Historic Preservation 17,100 683 3,634 4,560 13,466 21%
677 Football Hall of Fame Capital 5,000 182 1,562 50,676 3,438 31%
750 Equipment/Vehicle Leasing 5,501,000 2,916,712 2,917,608 - 2,583,392 53%
751 Parks Bond Capital 7,500 517 1,909 - 5,591 25%
753 Smart Streets Bond Capital 17,000 545 2,356 - 14,644 14%
Capital Project Total 8,829,836 2,975,343 4,029,891 1,433,194 4,799,945 46%
Enterprise
287 Emergency Medical Services Capital 4,495,349 1,927 1,810,957 1,319,900 2,684,392 40%
288 Emergency Medical Services Operating 6,350,012 372,922 1,970,421 2,372,479 4,379,591 31%
600 Consolidated Building Fund 3,976,466 155,849 1,727,905 1,118,975 2,248,561 43%
601 Parking Garages 1,122,911 140,159 554,001 448,357 568,910 49%
610 Solid Waste Operations 5,799,475 329,577 2,222,592 2,250,808 3,576,883 38%
611 Solid Waste Capital 836,313 20,027 204,085 562,237 632,228 24%
620 Water Works Operations 15,750,622 1,123,506 5,558,552 5,532,677 10,192,070 35%
622 Water Works Capital 15,000 875 7,893 11,446 7,107 53%
624 Water Works Customer Deposit 15,000 583 4,902 6,016 10,098 33%
625 Water Works Sinking 2,054,891 164,266 821,912 854,030 1,232,979 40%
626 Water Works Bond Reserve 16,000 548 4,604 6,405 11,396 29%
629 Water Works Reserve Operations & Maintenance 174,500 1,000 159,400 236,694 15,100 91%
640 Sewer Repair Insurance 621,788 53,371 271,464 265,507 350,324 44%
641 Sewage Works Operations 37,171,904 3,108,675 15,728,032 15,625,770 21,443,872 42%
642 Sewage Works Capital 4,887,000 502,267 1,362,036 33,166 3,524,964 28%
643 Sewage Works Reserve Operations & Maint.546,755 1,972 531,828 912,795 14,927 97%
649 Sewage Sinking 9,177,024 764,229 3,819,433 3,812,149 5,357,591 42%
653 Sewage Debt Service Reserve 4,400 1,579 4,900 1,746 (500) 111%
659 Sewer Bond 2011 - 7 154 922 (154) 0%
661 Sewer Bond 2012 50,000 984 9,239 52,828 40,761 18%
664 2013A Cost of Issuance Fund - - - 18 - 0%
666 2015 Sewer Bond Issuance - - - 94 - 0%
670 Century Center 4,194,311 412,693 1,710,716 1,798,856 2,483,595 41%
671 Century Center Capital 750 74 358 413 392 48%
672 Century Center Energy Conservation Debt Svc 192,297 4 22 107,742 192,275 0%
Enterprise Total 97,452,768 7,157,095 38,485,406 37,332,027 58,967,362 39%
3
City of South Bend
Monthly Department Financial Report
REVENUE SUMMARY
May 31, 2017
Values
Fund
Type Dept Name
Current Amended
Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget Balance
Percent of
Budget
Internal Service
222 Central Services 8,308,569 623,794 3,242,974 3,098,183 5,065,595 39%
224 Central Services Capital 287,600 35 322 705 287,278 0%
226 Liability Insurance 3,557,591 243,026 1,266,930 955,519 2,290,661 36%
278 Take Home Vehicle Police 4,000 288 2,399 46,972 1,601 60%
279 IT / Innovation / 311 Call Center 5,205,034 430,621 2,153,105 198,069 3,051,929 41%
711 Self-Funded Employee Benefits 17,800,413 1,481,130 7,446,942 7,087,312 10,353,471 42%
713 Unemployment Compensation 83,000 102 890 28,086 82,110 1%
Internal Service Total 35,246,207 2,778,997 14,113,563 11,414,845 21,132,644 40%
Trust & Agency
701 Firefighters Pension 5,217,138 - 419 1,061 5,216,719 0%
702 Police Pension 6,136,500 595 10,685 2,773 6,125,815 0%
730 City Cemetery 200 11 92 113 108 46%
Trust & Agency Total 11,353,838 606 11,196 3,947 11,342,642 0%
City Funds Total 284,472,176 17,863,212 89,847,428 83,717,375 194,624,748 32%
Redevelopment Commission Controlled Funds
Tax Increment Financing
324 TIF - River West Development Area (Airport) 22,888,477 71,358 591,068 735,703 22,297,409 3%
422 TIF - West Washington 436,000 751 6,200 5,962 429,800 1%
425 TIF - Leighton Plaza (Redevelop Retail) 197,014 8,762 52,690 54,830 144,324 27%
429 TIF - River East Development Area (NE Dev)3,069,524 3,279 30,853 29,832 3,038,671 1%
430 TIF - Southside Development #1 3,901,127 2,039 1,480,802 23,722 2,420,325 38%
432 TIF - Southside Development #3 12,000 219 8,518 20,242 3,482 71%
435 TIF - Douglas Road 327,858 3 298 334 327,560 0%
436 TIF - River East Residential (NE Res)3,300,903 - 442 213,108 3,300,461 0%
Tax Increment Financing Total 34,132,903 86,411 2,170,871 1,083,733 31,962,032 6%
Redevelopment
433 Redevelopment General 135 3 27 35 108 20%
439 Certified Technology Park 50,000 825 6,867 8,996 43,133 14%
454 Airport Urban Enterprise Zone 3,900 147 1,223 1,509 2,677 31%
754 Industrial Revolving Fund 210,000 14,952 46,151 - 163,849 22%
Redevelopment Total 264,035 15,927 54,268 10,539 209,767 21%
Debt Service
315 Redevelopment Bond - Airport Taxable 14,000 398 3,306 4,122 10,694 24%
317 Coveleski Debt Service Reserve 5,000 197 1,637 2,018 3,364 33%
328 Redevelopment Bond - Palais Royale 15,000 664 5,538 6,887 9,462 37%
752 South Bend Redevelopment Authority 3,868,169 197,726 2,207,553 - 1,660,616 57%
756 Smart Streets Debt Service 855,784 218 857 - 854,927 0%
758 Erskine Village Debt Service 3,961,782 - 3,961,781 - 1 100%
Debt Service Total 8,719,735 199,202 6,180,671 13,026 2,539,064 71%
Redevelopment Commission Controlled Funds Total 43,116,673 301,541 8,405,810 1,107,299 34,710,863 19%
Grand Total 327,588,849 18,164,753 98,253,239 84,824,674 229,335,610 30%
4
City of South Bend
Monthly Department Financial Report
EXPENDITURE SUMMARY
May 31, 2017
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 54,678 290,550 255,703 239 582,134 33%
101-0104 311 Call Center - - - 3,810 - - 0%
101-0201 City Clerk 536,216 35,273 184,168 159,710 44,588 307,460 43%
101-0301 Common Council 571,148 28,885 189,850 192,130 60,158 321,140 44%
101-0302 WNIT Contract 43,000 43,000 43,000 43,000 - - 100%
101-0401 Administration & Finance 2,476,351 206,704 955,127 679,266 47,248 1,473,975 40%
101-0404 Morris Performing Arts Center 1,271,039 60,629 323,584 414,661 8,592 938,863 26%
101-0405 Palais Royale 530,200 18,169 101,074 190,599 9,411 419,715 21%
101-0501 Legal Department 1,158,567 75,744 454,306 385,121 4,762 699,499 40%
101-0602 Engineering 1,445,157 103,226 452,465 407,533 51,898 940,793 35%
101-0801 Police Department 29,668,433 2,087,143 10,685,805 9,391,698 998,012 17,984,616 39%
101-0802 Communications Center - - - 616,255 - - 0%
101-0901 Fire Department 21,111,466 1,604,395 7,852,991 7,217,144 328,341 12,930,133 39%
101-1008 Human Rights 425,805 31,913 179,774 136,195 8,826 237,205 44%
101-1201 Code Enforcement - - - 202,164 - - 0%
General Fund Total 60,110,305 4,349,760 21,712,697 20,294,990 1,562,076 36,835,532 39%
Special Revenue
103 Excess Levy - - - 3,648 - - 0%
201 Parks & Recreation 13,885,317 1,311,574 5,172,582 4,225,021 987,931 7,724,804 44%
202 Motor Vehicle Highway 11,565,531 685,060 3,457,409 3,629,225 727,626 7,380,496 36%
203 Recreation Nonreverting 1,599,683 71,392 310,773 368,288 207,029 1,081,881 32%
209 Studebaker-Oliver Reverting Grants 539,393 43,825 181,701 69,373 257,692 100,000 81%
210 Economic Development State Grants 509,757 - 18,003 1,494,282 437,745 54,009 89%
211 Department of Community Investment (DCI)2,650,376 195,239 917,479 939,794 46,703 1,686,194 36%
212 Dept of Community Investment Grants 5,455,838 164,147 1,024,942 724,680 1,642,570 2,788,326 49%
216 Police State Seizures 36,000 - - - - 36,000 0%
217 Gift, Donation, Bequest 238,700 760 74,323 - 6,352 158,025 34%
218 Police Curfew Violations 1,000 - - - - 1,000 0%
219 Unsafe Building 902,746 81,628 301,437 283,589 243,585 357,724 60%
220 Law Enforcement Continuing Education 788,422 26,375 317,971 99,916 40,834 429,617 46%
221 Landlord Registration 1,000 - 10 - - 990 1%
227 Loss Recovery 598,675 5,844 18,869 23,216 253,206 326,600 45%
244 Emergency Phone System 33,671 - 4,708 - 28,963 - 100%
249 Public Safety LOIT 7,462,645 610,756 2,776,804 2,548,369 - 4,685,841 37%
251 Local Roads & Streets 2,086,544 92,276 345,772 439,671 1,209,069 531,704 75%
252 Excess Welfare Distribution 8 - - - - 8 0%
257 LOIT Special Distribution 3,757,457 39,807 1,172,144 - 564,685 2,020,628 46%
258 Human Rights Federal Grant 201,773 17,529 54,573 68,759 15,809 131,391 35%
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 1,998 5,673 2,457 - 16,002 26%
289 HAZMAT 10,431 4,057 4,742 1,170 57 5,632 46%
291 Indiana River Rescue 89,349 10,419 36,140 12,672 26,788 26,421 70%
292 Police Grants 10,805 106 5,587 31,964 27,347 (22,129) 305%
294 Regional Police Academy 22,500 515 2,561 2,199 - 19,939 11%
295 COPS MORE Grant 263,767 915 135,578 27,937 41,546 86,643 67%
299 Police Federal Drug Enforcement 196,337 - 47,537 12,042 - 148,800 24%
404 County Option Income Tax 12,071,593 13,821 4,882,696 5,553,922 726,880 6,462,016 46%
408 Economic Development Income Tax 11,559,184 62,665 5,076,596 3,626,285 1,810,532 4,672,057 60%
410 Urban Development Action Grant 126,144 - 62,515 146,068 - 63,629 50%
655 Project Releaf 525,416 3,108 228,325 401,529 - 297,091 43%
705 Police K-9 Unit 2,020 - - - - 2,020 0%
Special Revenue Total 79,215,124 3,443,815 26,637,453 24,736,074 9,302,948 43,274,724 45%
City Debt Service
313 Football Hall of Fame Debt Service 1,268,999 - 631,735 636,000 - 637,264 50%
755 South Bend Building Corp 2,643,214 - 1,437,970 - - 1,205,244 54%
757 Parks Bond Debt Service 391,482 - 198,566 - - 192,916 51%
City Debt Service Total 4,303,695 - 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 4,569 13,111 22,000 9,829 7,060 76%
403 Zoo Endowment 49,688 - 53,599 - - (3,911) 108%
405 Park Nonreverting Capital 228,024 16,930 144,869 52,334 68,508 14,647 94%
406 Cumulative Capital Development 476,500 149,081 289,627 304,922 - 186,873 61%
407 Cumulative Capital Improvement 372,250 - 185,125 184,125 - 187,125 50%
412 Major Moves Construction 2,470,708 910 1,514 532,138 1,574,814 894,380 64%
416 Morris Performing Arts Center Capital 106,144 540 4,016 18,225 630 101,498 4%
450 Palais Royale Historic Preservation 5,000 - - - - 5,000 0%
677 Football Hall of Fame Capital 81,091 2,159 26,666 32,831 13,185 41,240 49%
750 Equipment/Vehicle Leasing 5,500,000 135,750 1,674,132 - 1,718,872 2,106,997 62%
751 Parks Bond Capital 3,500,000 19,839 434,776 - 38,350 3,026,874 14%
753 Smart Streets Bond Capital 10,000,000 617,149 2,402,042 - - 7,597,958 24%
Capital Project Total 23,647,360 946,927 5,697,917 1,619,662 3,424,188 14,525,254 39%
Enterprise
287 Emergency Medical Services Capital 3,100,377 136,287 909,004 585,053 1,307,017 884,356 71%
288 Emergency Medical Services Operating 6,117,914 437,873 2,086,462 2,212,268 49,402 3,982,050 35%
600 Consolidated Building Fund 3,777,820 279,085 1,374,099 1,251,693 63,819 2,339,902 38%
601 Parking Garages 1,247,254 24,534 320,725 348,404 643,822 282,707 77%
610 Solid Waste Operations 5,662,910 347,815 1,923,928 2,110,420 216,155 3,522,827 38%
611 Solid Waste Capital 1,135,613 20,129 537,819 366,205 - 597,794 47%
620 Water Works Operations 17,727,254 1,176,363 6,262,458 6,061,075 747,555 10,717,240 40%
622 Water Works Capital 1,414,466 8,299 321,083 6,750 171,906 921,477 35%
624 Water Works Customer Deposit 15,000 583 4,617 4,048 - 10,383 31%
625 Water Works Sinking 2,054,891 266 1,902 1,499 - 2,052,989 0%
626 Water Works Bond Reserve 16,000 - - 2,050 - 16,000 0%
629 Water Works Reserve Operations & Maintenance 23,000 1,000 7,673 6,327 - 15,327 33%
640 Sewer Repair Insurance 534,509 63,829 241,449 220,918 61,760 231,300 57%
641 Sewage Works Operations 44,542,335 3,172,418 15,180,778 12,816,963 5,176,574 24,184,984 46%
642 Sewage Works Capital 8,040,455 530,257 2,488,259 1,096,392 1,733,768 3,818,429 53%
5
City of South Bend
Monthly Department Financial Report
EXPENDITURE SUMMARY
May 31, 2017
Values
Fund
Type Department Name
Current Amended
Budget
Current Month
Actual Current YTD Actual Prior YTD Actual
Current
Encumbrances Budget Balance
Percent of
Budget*
643 Sewage Works Reserve Operations & Maint.30,000 1,972 14,217 11,288 - 15,783 47%
649 Sewage Sinking 9,163,754 830,476 831,976 1,148,456 - 8,331,778 9%
659 Sewer Bond 2011 51,688 - 51,687 - - 1 100%
661 Sewer Bond 2012 3,010,364 269,318 733,094 2,083,844 1,630,209 647,061 79%
666 2015 Sewer Bond Issuance - - - 2,500 - - 0%
670 Century Center 4,194,310 322,739 1,600,459 1,613,469 - 2,593,851 38%
671 Century Center Capital - - - 38,747 - - 0%
672 Century Center Energy Conservation Debt Svc 192,297 - 95,128 140,609 - 97,169 49%
Enterprise Total 112,052,211 7,623,244 34,986,819 32,128,978 11,801,986 65,263,406 42%
Internal Service
222 Central Services 8,564,643 672,069 3,226,269 2,984,925 1,693,111 3,645,263 57%
224 Central Services Capital 326,025 - 31,549 135,447 13,439 281,038 14%
226 Liability Insurance 3,587,586 736,460 1,525,845 664,363 63,600 1,998,141 44%
278 Take Home Vehicle Police 10,000 (120) 792 53 - 9,208 8%
279 IT / Innovation / 311 Call Center 5,205,034 495,245 1,493,685 198,068 532,133 3,179,216 39%
711 Self-Funded Employee Benefits 17,803,200 1,102,064 5,631,304 6,623,368 609,057 11,562,839 35%
713 Unemployment Compensation 84,105 3,324 27,132 29,293 11,000 45,973 45%
Internal Service Total 35,580,593 3,009,042 11,936,575 10,635,518 2,922,340 20,721,678 42%
Trust & Agency
701 Firefighters Pension 5,098,269 390,847 1,966,312 2,176,111 - 3,131,957 39%
702 Police Pension 6,423,889 517,885 2,585,347 2,736,679 - 3,838,542 40%
730 City Cemetery 6,000 - - - - 6,000 0%
Trust & Agency Total 11,528,158 908,733 4,551,659 4,912,790 - 6,976,499 39%
City Funds Total 326,437,446 20,281,521 107,791,390 94,964,012 29,013,538 189,632,518 42%
Redevelopment Commission Controlled Funds
Tax Increment Financing
324 TIF - River West Development Area (Airport)39,618,887 590,372 7,232,324 8,729,992 9,121,871 23,264,692 41%
422 TIF - West Washington 1,428,292 - 2,805 10,372 515,729 909,758 36%
425 TIF - Leighton Plaza (Redevelop Retail)158,166 9,310 39,633 30,426 - 118,533 25%
429 TIF - River East Development Area (NE Dev)10,602,696 45,684 806,944 133,796 2,134,553 7,661,199 28%
430 TIF - Southside Development #1 6,917,426 100,639 301,524 720,028 582,110 6,033,792 13%
432 TIF - Southside Development #3 4,878,795 - 4,866,186 365,835 - 12,609 100%
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 746,005 15,082,505 11,814,538 12,358,463 39,937,741 41%
Redevelopment
433 Redevelopment General 4,500 316 1,133 - - 3,367 25%
439 Certified Technology Park 2,200,000 1,800,000 1,800,000 142,913 - 400,000 82%
454 Airport Urban Enterprise Zone 50,000 - - - - 50,000 0%
754 Industrial Revolving Fund 157,000 775 31,765 - - 125,235 20%
Redevelopment Total 2,411,500 1,801,091 1,832,898 142,913 - 578,602 76%
Debt Service
315 Redevelopment Bond - Airport Taxable 14,000 398 3,114 2,771 - 10,886 22%
328 Redevelopment Bond - Palais Royale 15,000 664 5,218 4,630 - 9,782 35%
752 South Bend Redevelopment Authority 4,603,405 - 2,739,743 - - 1,863,662 60%
756 Smart Streets Debt Service 855,784 - 394,784 - - 461,000 46%
758 Erskine Village Debt Service 4,521,918 - 4,522,898 - - (980) 100%
Debt Service Total 10,010,107 1,062 7,665,757 7,401 - 2,344,350 77%
Redevelopment Commission Controlled Funds Total 79,800,316 2,548,158 24,581,160 11,964,851 12,358,463 42,860,693 46%
Grand Total 406,237,762 22,829,679 132,372,550 106,928,864 41,372,001 232,493,211 43%
* Includes year to date expenditures and encumbrances
6
Department Name Fund/Dept No.101-0101
Fund Type Date Updated 6/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 872,323 54,678 290,550 255,293 - 581,773 33%
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 - - 410 - 600 0%
Transfers In - - - - - - 0%
Total Revenue 872,923 54,678 290,550 255,703 - 582,373 33%
Expenditures
Personnel 704,849 42,453 228,630 226,916 - 476,219 32%
Supplies 3,119 527 723 792 239 2,157 31%
Services 164,955 11,481 60,614 27,700 - 104,341 37%
Debt Service - 218 583 294 - (583) 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 872,923 54,678 290,550 255,703 239 582,134 33%
Net - - - - (239) 239
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 from 2016 service category 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.
In May 2017, Angela Kouters was hired as Interim Chief of Staff to the Mayor, replacing James Mueller who became the City's new Executive
Director of Community Investment.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Mayor's Office
General Fund
City Funds
Form 3
7
Department Name Fund/Dept No.101-0104
Fund Type Date Updated 6/15/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 - - - 3,810 - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 3,810 - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - 1,629 - - 0%
Services - - - 2,181 - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - 3,810 - - 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
May 31, 2017
311 Call Center
General Fund
City Funds
Form 3
8
Department Name Fund/Dept No.101-0201
Fund Type Date Updated 6/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 536,216 35,273 184,168 159,710 - 352,048 34%
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 35,273 184,168 159,710 - 352,048 34%
Expenditures
Personnel 349,234 25,437 125,152 124,903 - 224,082 36%
Supplies 7,800 276 2,085 4,703 1,356 4,359 44%
Services 179,182 9,560 56,931 30,104 43,232 79,019 56%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 536,216 35,273 184,168 159,710 44,588 307,460 43%
Net - - - - (44,588) 44,588
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. Funds were encumbered
in 2016 to pay for Granicus software for Boards and Commissions (PO: $4,500, YTD Spent: $1,950), Dictation Services for past meeting notices
(PO: $2,000, YTD Spent: $1,300), Electrical Work (PO: $9,000, YTD Spent: $0), the New Legislative Resource Center (POs and YTD Spent:
$3,678), Ongoing in-house remodel (PO and YTD Spent: $6,443), and Legal Advertising in December (POs: $1,872.39, YTD Spent: $1,526.38).
Value Purchase Orders make it look like we've spent more than we have. These include additions to the City's code book through Municode (PO:
$6,000, YTD Spent: $2,679.30), Legal Representation (PO: $10,000, YTD Spent: $350), and Legal Advertising (POs: $20,000, YTD Spent:
$2,642.49).
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
City Clerk
General Fund
City Funds
Form 3
9
Department Name Fund/Dept No.101-0301
Fund Type Date Updated 6/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 571,148 28,885 189,850 192,130 - 381,298 33%
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 28,885 189,850 192,130 - 381,298 33%
Expenditures
Personnel 304,402 22,613 113,416 110,755 112 190,874 37%
Supplies 4,503 59 537 5,589 497 3,469 23%
Services 262,243 6,213 75,897 75,786 59,549 126,797 52%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 571,148 28,885 189,850 192,130 60,158 321,140 44%
Net - - - - (60,158) 60,158
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.
Encumbrances from 2016 account for the large differences. Funds encumbered and spent from 2016 are the following: New furniture for the
Council ($19,119.04), new furniture for the Council Informal Meeting Room ($12,366.24), and new AV equipment for the Council Informal Meeting
Room ($3,572.21). Large Value Purchase Orders account for much of the erncumbrances. These include the Council's Legislative Research
Assistant (PO: $40,800, Spent: $11,066.07) and Additional Legal Services (PO: $29,000, Spent: $525).
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Common Council
General Fund
City Funds
Form 3
10
Department Name Fund/Dept No.101-0302
Fund Type Date Updated 6/15/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 43,000 43,000 - - 100%
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 43,000 43,000 - - 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 43,000 43,000 43,000 43,000 - - 100%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 43,000 43,000 43,000 43,000 - - 100%
Net - - - - - -
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 2, 2020.
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
May 31, 2017
WNIT Contract
General Fund
City Funds
Form 3
11
Department Name Fund/Dept No.101-0401
Fund Type Date Updated 6/15/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,047 206,704 942,865 665,719 - 1,521,182 38%
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,304 - 12,262 13,548 - 42 100%
Transfers In - - - - - - 0%
Total Revenue 2,476,351 206,704 955,127 679,266 - 1,521,224 39%
Expenditures
Personnel 2,053,815 158,284 749,877 596,802 - 1,303,938 37%
Supplies 25,158 1,739 8,360 7,704 9,356 7,442 70%
Services 392,299 45,829 194,561 72,640 37,893 159,846 59%
Debt Service 5,079 852 2,330 2,121 - 2,749 46%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 2,476,351 206,704 955,127 679,266 47,248 1,473,975 40%
Net - - - - (47,248) 47,248
Cash Balance - -
Staffing Budget Actual
Full Time 23.00 23.00
Part-Time /Seasonal/Temporary - -
Total 23.00 23.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 encumbrances for supplies is mainly the
value purchase order with Office Depot.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Administration & Finance
General Fund
City Funds
Form 3
12
Department Name Fund/Dept No.101-0404
Fund Type Date Updated 6/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 306,039 13,838 (77,672) 9,600 - 383,711 -25%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 463,000 34,730 227,792 218,047 - 235,208 49%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 502,000 12,060 173,464 187,013 - 328,536 35%
Transfers In - - - - - - 0%
Total Revenue 1,271,039 60,629 323,584 414,661 - 947,455 25%
Expenditures
Personnel 510,299 34,571 175,448 291,621 - 334,851 34%
Supplies 7,697 77 3,062 4,401 2,008 2,627 66%
Services 753,043 25,980 145,074 118,639 6,584 601,385 20%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,271,039 60,629 323,584 414,661 8,592 938,863 26%
Net - - - - (8,592) 8,592
Cash Balance - -
Staffing Budget Actual
Full Time 6.60 7.00
Part-Time /Seasonal/Temporary 4.00 4.00
Total 10.60 11.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
May 31, 2017
Morris Performing Arts Center
General Fund
City Funds
Form 3
13
Department Name Fund/Dept No.101-0405
Fund Type Date Updated 6/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 171,298 (15,358) 8,803 101,653 - 162,495 5%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 332,072 31,185 85,671 79,389 - 246,401 26%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 26,830 2,342 6,600 9,558 - 20,230 25%
Transfers In - - - - - - 0%
Total Revenue 530,200 18,169 101,074 190,599 - 429,126 19%
Expenditures
Personnel 142,131 9,143 39,841 103,447 - 102,290 28%
Supplies 3,398 - 794 8,809 1,204 1,400 59%
Services 384,671 9,027 60,439 78,342 8,207 316,025 18%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 530,200 18,169 101,074 190,599 9,411 419,715 21%
Net - - - - (9,411) 9,411
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
May 31, 2017
Palais Royale
General Fund
City Funds
Form 3
14
Department Name Fund/Dept No.101-0501
Fund Type Date Updated 6/15/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 56,869 416,957 347,403 - 666,233 38%
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,875 37,350 37,719 - 38,027 50%
Transfers In - - - - - - 0%
Total Revenue 1,158,567 75,744 454,306 385,121 - 704,261 39%
Expenditures
Personnel 966,603 64,059 353,097 366,388 - 613,506 37%
Supplies 5,977 33 2,908 551 4,762 (1,693) 128%
Services 184,715 11,334 97,665 17,547 - 87,050 53%
Debt Service 1,272 318 635 635 - 637 50%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,158,567 75,744 454,306 385,121 4,762 699,499 40%
Net - - - - (4,762) 4,762
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.
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
May 31, 2017
Legal Department
General Fund
City Funds
Form 3
15
Department Name Fund/Dept No.101-0602
Fund Type Date Updated 6/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 1,127,820 99,176 390,358 372,123 - 737,462 35%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 100,000 3,925 61,982 - - 38,018 62%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 217,337 125 125 35,410 - 217,212 0%
Transfers In - - - - - - 0%
Total Revenue 1,445,157 103,226 452,465 407,533 - 992,692 31%
Expenditures
Personnel 841,636 66,244 263,772 244,296 260 577,604 31%
Supplies 34,113 2,437 10,045 44,001 3,421 20,647 39%
Services 541,300 31,902 161,732 109,824 48,217 331,351 39%
Debt Service 28,108 2,644 16,917 9,412 - 11,191 60%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,445,157 103,226 452,465 407,533 51,898 940,793 35%
Net - - - - (51,898) 51,898
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
May 31, 2017
Engineering
General Fund
City Funds
Form 3
16
Department Name Fund/Dept No.101-0801
Fund Type Date Updated 6/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,332,433 2,076,163 10,598,800 9,249,848 - 18,733,633 36%
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 328,500 10,980 87,005 141,850 - 241,495 26%
Transfers In - - - - - - 0%
Total Revenue 29,668,433 2,087,143 10,685,805 9,391,698 - 18,982,628 36%
Expenditures
Personnel 23,671,143 1,646,975 8,575,102 8,455,589 - 15,096,041 36%
Supplies 1,231,776 8,253 101,522 136,378 929,072 201,182 84%
Services 4,685,514 431,479 1,935,353 797,105 68,940 2,681,221 43%
Debt Service 80,000 436 73,829 2,626 - 6,171 92%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 29,668,433 2,087,143 10,685,805 9,391,698 998,012 17,984,616 39%
Net - - - - (998,012) 998,012
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 $914,976 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
May 31, 2017
Police Department
General Fund
City Funds
Form 3
17
Department Name Fund/Dept No.101-0901
Fund Type Date Updated 6/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,604,395 7,810,618 7,205,517 - 13,299,348 37%
Local Income Taxes - - - - - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 500 - - 1,593 - 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,604,395 7,852,991 7,217,144 - 13,258,475 37%
Expenditures
Personnel 17,624,592 1,322,825 6,432,139 6,386,471 6,936 11,185,517 37%
Supplies 502,435 30,375 147,569 126,530 45,311 309,555 38%
Services 2,984,439 251,195 1,273,284 704,144 276,094 1,435,061 52%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 21,111,466 1,604,395 7,852,991 7,217,144 328,341 12,930,133 39%
Net - - - - (328,341) 328,341
Cash Balance - -
Staffing Budget Actual
Full Time 180.00 177.00
Part-Time /Seasonal/Temporary - -
Total 180.00 177.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. This expense hit
services this month for the repair of the fire truck.
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
May 31, 2017
Fire Department
General Fund
City Funds
Form 3
18
Department Name Fund/Dept No.101-1008
Fund Type Date Updated 6/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 425,805 31,913 179,774 136,195 - 246,031 42%
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 31,913 179,774 136,195 - 246,031 42%
Expenditures
Personnel 294,036 22,038 129,988 112,952 - 164,048 44%
Supplies 1,037 - 212 378 500 325 69%
Services 130,732 9,875 49,574 22,865 8,326 72,832 44%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 425,805 31,913 179,774 136,195 8,826 237,205 44%
Net - - - - (8,826) 8,826
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 roughly 1,200% increase in allocation costs related to information
technology.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Human Rights
General Fund
City Funds
Form 3
19
Department Name Fund/Dept No.101-1201
Fund Type Date Updated 6/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 - - - 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
May 31, 2017
Code Enforcement
General Fund
City Funds
Form 3
20
Fund Name Fund Number 102
Fund Type Date Updated 6/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 - - - 1,405,850 - - 0%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 60,000 3,906 32,522 34,543 - 27,478 54%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 60,000 3,906 32,522 1,440,393 - 27,478 54%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 60,000 3,906 32,522 1,440,393 - 27,478
Cash Balance 10,216,895 10,132,500
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
May 31, 2017
Rainy Day
Special Revenue
City Funds
Form 3
21
Fund Name Fund Number 103
Fund Type Date Updated 6/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 - - 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
May 31, 2017
Excess Levy
Special Revenue
City Funds
Form 3
22
Fund Name Fund Number 201
Fund Type Date Updated 6/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 7,878,000 - - - - 7,878,000 0%
Local Income Taxes - - - - - - 0%
Other Taxes 670,000 - - - - 670,000 0%
Grants/Intergovernmental 315,650 - - - - 315,650 0%
Licenses & Permits - - - - - - 0%
Charges for Services 2,734,197 170,259 442,848 530,736 - 2,291,349 16%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 10,000 888 9,895 11,628 - 105 99%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 1,844,938 64,770 796,165 451,588 - 1,048,773 43%
Transfers In 625,347 - 200,000 - - 425,347 32%
Total Revenue 14,078,132 235,917 1,448,907 993,953 - 12,629,225 10%
Expenditures
Personnel 8,386,381 591,867 2,766,946 2,540,093 400 5,619,036 33%
Supplies 1,393,820 114,597 383,255 384,244 365,580 644,985 54%
Services 3,707,575 602,464 1,881,519 1,181,696 617,705 1,208,351 67%
Debt Service 279,691 2,645 140,863 118,989 4,246 134,583 52%
Capital - - - - - - 0%
Transfers Out 102,850 - - - - 102,850 0%
Total Expenditures 13,870,317 1,311,574 5,172,582 4,225,021 987,931 7,709,804 44%
Net 207,815 (1,075,657) (3,723,675) (3,231,069) (987,931) 4,919,421
Cash Balance 819,050 710,069
Staffing Budget Actual
Full Time 97.00 96.00
Part-Time /Seasonal/Temporary N/A 105.00
Total 97.00 201.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 13.7% 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 property 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
May 31, 2017
Parks & Recreation
Special Revenue
City Funds
Form 3
23
Fund Name Fund Number 202
Fund Type Date Updated 6/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 5,650,000 783,029 2,454,479 2,486,248 - 3,195,521 43%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 223,365 43,516 100,997 106,011 - 122,368 45%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 21,813 2,792 19,663 21,351 - 2,150 90%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 73,958 4,587 7,737 16,390 - 66,221 10%
Transfers In 3,964,974 - 1,982,487 2,026,500 - 1,982,487 50%
Total Revenue 9,934,110 833,924 4,565,362 4,656,499 - 5,368,748 46%
Expenditures
Personnel 4,585,702 276,439 1,491,473 1,507,659 - 3,094,229 33%
Supplies 2,639,357 78,762 492,644 772,619 423,825 1,722,888 35%
Services 3,544,927 241,183 1,074,877 1,055,368 303,801 2,166,249 39%
Debt Service 775,545 72,681 382,419 254,121 - 393,126 49%
Capital 20,000 15,995 15,995 39,458 - 4,005 80%
Transfers Out - - - - - - 0%
Total Expenditures 11,565,531 685,060 3,457,409 3,629,225 727,626 7,380,496 36%
Net (1,631,421) 148,864 1,107,953 1,027,275 (727,626) (2,011,749)
Cash Balance 7,288,608 6,204,715
Staffing Budget Actual
Full Time 58.03 52.03
Part-Time /Seasonal/Temporary 7.68 2.92
Total 65.71 54.95
Fund Purpose:
Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
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, from EDIT to support street department operations and from Project ReLeaf to
support leaf collection efforts in the City.
As of the end of May, the Street Department is down by 8 employees: 1 Asset Manager, 1 Superintendent IV, 5 Equipment Operators II and 1
Operations Technician. The Asset Manager is a new position; the Superintendent IV and Operations Technician positions were created by
promotions; the EO II positions are open for a variety of reasons.
Interviews have been conducted to fill the Superintendent IV and EO II positions and we look forward to having them filled within the next couple of
weeks, providing all goes well with the pre-employment screening process. However, even with getting these positions filled, the learning curve for
new employees may require that we work additional overtime during the paving season to reach our goal for the year. Interviews will be conducted
for the Operations Technician position next week.
$20,000 is budgeted for a new printer for the sign shop.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Motor Vehicle Highway
Special Revenue
City Funds
This fund accounts for the operations of the following departments: Streets, Traffic & Lighting, and Curb & Sidewalk.
Form 3
24
Fund Name Fund Number 203
Fund Type Date Updated 6/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 1,365,787 66,987 502,747 462,491 - 863,040 37%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 6,000 385 2,805 3,442 - 3,195 47%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 10,000 (1,350) 119 36 - 9,881 1%
Transfers In - - - - - - 0%
Total Revenue 1,381,787 66,022 505,671 465,968 - 876,116 37%
Expenditures
Personnel 571,393 22,503 105,963 135,675 - 465,430 19%
Supplies 326,289 28,099 59,433 64,702 81,551 185,305 43%
Services 587,001 20,790 145,377 167,912 125,478 316,146 46%
Debt Service - - - - - - 0%
Capital 115,000 - - - - 115,000 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,599,683 71,392 310,773 368,288 207,029 1,081,881 32%
Net (217,896) (5,370) 194,898 97,680 (207,029) (205,765)
Cash Balance 1,014,627 919,723
Staffing Budget Actual
Full Time 1.00 1.00
Part-Time /Seasonal/Temporary -18.00
Total 1.00 19.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
May 31, 2017
Recreation Nonreverting
Special Revenue
City Funds
Form 3
25
Fund Name Fund Number 209
Fund Type Date Updated 6/15/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 318,587 9,396 123,787 42,272 - 194,800 39%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,000 311 2,625 4,381 - 1,375 66%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 100,000 - - - - 100,000 0%
Transfers In - - - - - - 0%
Total Revenue 422,587 9,707 126,412 46,653 - 296,175 30%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 539,393 43,825 181,701 69,373 257,692 100,000 81%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 539,393 43,825 181,701 69,373 257,692 100,000 81%
Net (116,806) (34,118) (55,289) (22,721) (257,692) 196,175
Cash Balance 827,572 1,084,480
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. We are able to draw revenue from the grant as we make expenditures.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Studebaker-Oliver Reverting Grants
Special Revenue
City Funds
Form 3
26
Fund Name Fund Number 210
Fund Type Date Updated 6/15/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 - - - 767,681 - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 9,851 135 3,365 5,607 - 6,486 34%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 63,661 - 15,737 32,642 - 47,924 25%
Transfers In - - - - - - 0%
Total Revenue 73,512 135 19,103 805,930 - 54,409 26%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 185,120 - - 617,809 185,120 - 100%
Debt Service 72,012 - 18,003 18,003 - 54,009 25%
Capital 252,625 - - 858,470 252,625 - 100%
Transfers Out - - - - - - 0%
Total Expenditures 509,757 - 18,003 1,494,282 437,745 54,009 89%
Net (436,245) 135 1,100 (688,352) (437,745) 400
Cash Balance 352,095 (527,996)
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
May 31, 2017
Economic Development State Grants
Special Revenue
City Funds
Form 3
27
Fund Name Fund Number 211
Fund Type Date Updated 6/15/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 - - 120,805 - 440,636 0%
Licenses & Permits - - - - - - 0%
Charges for Services 316,000 7,957 85,639 194,255 - 230,361 27%
Fines, Forfeitures, and Fees 2,000 5 470 165 - 1,530 24%
Interest Earnings 10,000 574 4,189 4,863 - 5,811 42%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 2,604 - - 0%
Transfers In 1,522,673 - 761,337 984,319 - 761,337 50%
Total Revenue 2,291,309 8,536 851,635 1,307,011 - 1,439,674 37%
Expenditures
Personnel 1,948,112 147,117 680,912 746,228 - 1,267,200 35%
Supplies 26,356 1,029 5,477 7,138 1,247 19,633 26%
Services 675,908 47,093 231,090 186,428 45,456 399,362 41%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 2,650,376 195,239 917,479 939,794 46,703 1,686,194 36%
Net (359,067) (186,704) (65,844) 367,217 (46,703) (246,520)
Cash Balance 1,304,019 1,489,509
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. James Mueller named Executive Director in April. Vacant
positions: one Analyst position; Director of Economic Resources and Director of Business Development. May change title of Economic Resources
position to Deputy Director.
In 2016, a new van was purchased for property inspection work.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Department of Community Investment (DCI)
Special Revenue
City Funds
Form 3
28
Fund Name Fund Number 212
Fund Type Date Updated 6/15/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 83,039 754,294 765,105 - 2,393,706 24%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees 1,000 - 40 70 - 960 4%
Interest Earnings 2,000 9 288 1,025 - 1,712 14%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 197,000 892 141,808 10,035 - 55,192 72%
Transfers In - - - - - - 0%
Total Revenue 3,348,000 83,939 896,430 776,235 - 2,451,570 27%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Grants & Subsidies 5,455,838 164,147 1,024,942 724,180 1,642,570 2,788,326 49%
Transfers Out - - - 500 - - 0%
Total Expenditures 5,455,838 164,147 1,024,942 724,680 1,642,570 2,788,326 49%
Net (2,107,838) (80,208) (128,512) 51,555 (1,642,570) (336,756)
Cash Balance 113,186 603,972
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
May 31, 2017
Dept of Community Investment Grants
Special Revenue
City Funds
Form 3
29
Fund Name Fund Number 216
Fund Type Date Updated 6/15/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 1,897 15,003 15,847 - 19,997 43%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 1,000 88 721 830 - 279 72%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 36,000 1,986 15,724 16,678 - 20,276 44%
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 - 1,986 15,724 16,678 - (15,724)
Cash Balance 233,330 216,416
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
May 31, 2017
Police State Seizures
Special Revenue
City Funds
Form 3
30
Fund Name Fund Number 217
Fund Type Date Updated 6/15/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 - 5,150 - - 14,850 26%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 800 65 338 258 - 462 42%
Bond Proceeds - - - - - - 0%
Donations 155,000 155 122,361 778 - 32,639 79%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 175,800 220 127,849 1,036 - 47,951 73%
Expenditures
Personnel - - - - - - 0%
Supplies 8,700 - - - - 8,700 0%
Services 230,000 760 74,323 - 6,352 149,325 35%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 238,700 760 74,323 - 6,352 158,025 34%
Net (62,900) (540) 53,527 1,036 (6,352) (110,075)
Cash Balance 170,301 65,910
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
May 31, 2017
Gift, Donation, Bequest
Special Revenue
City Funds
Form 3
31
Fund Name Fund Number 218
Fund Type Date Updated 6/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 50 100 - 850 6%
Interest Earnings 100 5 40 49 - 60 40%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 1,000 17 90 149 - 910 9%
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 - 17 90 149 - (90)
Cash Balance 12,653 12,387
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
May 31, 2017
Police Curfew Violations
Special Revenue
City Funds
Form 3
32
Fund Name Fund Number 219
Fund Type Date Updated 6/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 214,000 9,892 48,171 126,707 - 165,829 23%
Fines, Forfeitures, and Fees - 4,338 27,001 60,902 - (27,001) 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 579,757 - 289,879 340,433 - 289,879 50%
Total Revenue 793,757 14,230 365,050 528,042 - 428,707 46%
Expenditures
Personnel 273,536 21,212 106,618 102,708 - 166,918 39%
Supplies 24,959 1,489 7,905 5,565 598 16,456 34%
Services 604,251 58,926 186,914 175,315 242,987 174,350 71%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 902,746 81,628 301,437 283,589 243,585 357,724 60%
Net (108,989) (67,397) 63,613 244,453 (243,585) 70,983
Cash Balance 436,441 253,444
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
division of Code Enforcement. Revenue in Fines, Forfeitures, and Fees represent miscellaneous collections for delinquent billing through invoices
which were deemed uncollectible, and therefore turned over to a collection agency. Also included in this category is revenue collected by the
Ordinance Violation Bureau for fines levied against property owners for certain violations tagged by Code Enforcement. In addition, in 2017 Fund
219 will receive interfund operating transfers from Fund 408 (EDIT) in the amount of $579,757.
Current year encumbrances include two large valued purchase orders made payable to the Venues, Parks, and Arts for their services for
Centralized Mowing, and Graffiti removal ($140,000 and $75,000 respectively). An additional value purchase order has encumbered funds for legal
representation for weekly Code Enforcement hearings ($30,000).
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Unsafe Building
Special Revenue
City Funds
Form 3
33
Fund Name Fund Number 220
Fund Type Date Updated 6/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 4,014 23,826 22,870 - 11,174 68%
Charges for Services 85,000 5,837 30,032 40,299 - 54,968 35%
Fines, Forfeitures, and Fees 86,000 8,376 67,368 35,712 - 18,632 78%
Interest Earnings 5,000 237 2,481 3,604 - 2,519 50%
Bond Proceeds - - - - - - 0%
Donations 2,000 - - - - 2,000 0%
Other Income 8,500 (5) 4,759 16,951 - 3,742 56%
Transfers In - - - - - - 0%
Total Revenue 221,500 18,459 128,466 119,436 - 93,034 58%
Expenditures
Personnel - - - - - - 0%
Supplies 318,332 1,330 38,702 10,982 33,334 246,296 23%
Services 470,090 25,046 279,269 88,934 7,500 183,321 61%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 788,422 26,375 317,971 99,916 40,834 429,617 46%
Net (566,922) (7,917) (189,505) 19,520 (40,834) (336,583)
Cash Balance 625,328 909,787
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
May 31, 2017
Law Enforcement Continuing Education
Special Revenue
City Funds
Form 3
34
Fund Name Fund Number 221
Fund Type Date Updated 6/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 7,000 60 3,990 - - 3,010 57%
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 7,000 60 3,990 - - 3,010 57%
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 6,000 60 3,980 - - 2,020
Cash Balance 5,205 -
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.
Primary revenue for this account is generated by landlord registrations, with the majority of the revenue stream flowing in from September through
February.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Landlord Registration
Special Revenue
City Funds
Form 3
35
Fund Name Fund Number 227
Fund Type Date Updated 6/15/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 368 3,094 3,933 - 5,906 34%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 9,000 368 3,094 3,933 - 5,906 34%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 550,333 984 6,009 20,016 217,724 326,600 41%
Debt Service - - - - - - 0%
Capital 48,342 4,860 12,860 3,200 35,482 - 100%
Transfers Out - - - - - - 0%
Total Expenditures 598,675 5,844 18,869 23,216 253,206 326,600 45%
Net (589,675) (5,476) (15,776) (19,283) (253,206) (320,694)
Cash Balance 959,650 973,966
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
May 31, 2017
Loss Recovery
Special Revenue
City Funds
Form 3
36
Fund Name Fund Number 244
Fund Type Date Updated 6/15/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 - 4,708 - 28,963 - 100%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 33,671 - 4,708 - 28,963 - 100%
Net (33,671) - (4,708) - (28,963) -
Cash Balance 28,963 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
May 31, 2017
Emergency Phone System
Special Revenue
City Funds
Form 3
37
Fund Name Fund Number 249
Fund Type Date Updated 6/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 7,467,618 622,302 3,111,508 2,829,650 - 4,356,111 42%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 6,000 362 2,797 2,676 - 3,203 47%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 7,473,618 622,663 3,114,304 2,832,326 - 4,359,314 42%
Expenditures
Personnel 7,462,645 610,756 2,776,804 2,548,369 - 4,685,841 37%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 7,462,645 610,756 2,776,804 2,548,369 - 4,685,841 37%
Net 10,973 11,907 337,500 283,958 - (326,527)
Cash Balance 1,277,949 925,892
Staffing Budget Actual
Full Time 78.00 78.00
Part-Time /Seasonal/Temporary - -
Total 78.00 78.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
May 31, 2017
Public Safety LOIT
Special Revenue
City Funds
Form 3
38
Fund Name Fund Number 251
Fund Type Date Updated 6/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 1,068,000 95,493 454,371 466,486 - 613,629 43%
Grants/Intergovernmental 256,000 10,921 63,687 - - 192,313 25%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 20,000 1,153 9,100 11,516 - 10,900 45%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 330,275 - 274 303,486 - 330,001 0%
Transfers In - - - - - - 0%
Total Revenue 1,674,275 107,567 527,432 781,489 - 1,146,843 32%
Expenditures
Personnel - - - - - - 0%
Supplies 450,378 54,217 54,217 - 395,783 378 100%
Services 794,905 6,970 74,682 183,351 55,230 664,993 16%
Debt Service - - - - - - 0%
Capital 841,261 31,089 216,873 256,321 758,055 (133,667) 116%
Transfers Out - - - - - - 0%
Total Expenditures 2,086,544 92,276 345,772 439,671 1,209,069 531,704 75%
Net (412,269) 15,291 181,660 341,817 (1,209,069) 615,139
Cash Balance 3,081,919 3,070,562
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. The large encumbrance in supplies is for street material.
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
May 31, 2017
Local Roads & Streets
Special Revenue
City Funds
Form 3
39
Fund Name Fund Number 252
Fund Type Date Updated 6/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 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
May 31, 2017
Excess Welfare Distribution
Special Revenue
City Funds
Form 3
40
Fund Name Fund Number 257
Fund Type Date Updated 6/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 - - - 4,217,549 - - 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 1,183 12,945 - - 27,055 32%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 153,000 - 152,895 - - 105 100%
Transfers In - - - - - - 0%
Total Revenue 1,471,000 1,183 165,840 4,217,549 - 1,305,160 11%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 655,100 19,965 41,850 - 96,250 517,000 21%
Debt Service - - - - - - 0%
Capital 2,102,357 19,843 130,294 - 468,435 1,503,628 28%
Transfers Out 1,000,000 - 1,000,000 - - - 100%
Total Expenditures 3,757,457 39,807 1,172,144 - 564,685 2,020,628 46%
Net (2,286,457) (38,624) (1,006,305) 4,217,549 (564,685) (715,467)
Cash Balance 3,018,762 4,217,549
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
May 31, 2017
LOIT Special Distribution
Special Revenue
City Funds
Form 3
41
Fund Name Fund Number 258
Fund Type Date Updated 6/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 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 181 1,391 1,596 - 609 70%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 18,040 175 12,602 17,463 - 5,438 70%
Transfers In - - - - - - 0%
Total Revenue 165,040 356 105,194 140,059 - 59,846 64%
Expenditures
Personnel 126,096 5,642 25,177 46,835 - 100,919 20%
Supplies 7,630 - 6,020 629 1,110 500 93%
Services 68,047 11,886 23,376 21,295 14,699 29,972 56%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 201,773 17,529 54,573 68,759 15,809 131,391 35%
Net (36,733) (17,173) 50,621 71,300 (15,809) (71,545)
Cash Balance 530,965 496,696
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
May 31, 2017
Human Rights Federal Grant
Special Revenue
City Funds
Form 3
42
Fund Name Fund Number 265
Fund Type Date Updated 6/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 1,000,000 - 1,000,000 - - - 100%
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 - - - 100%
Total Revenue 2,000,000 - 2,000,000 - - - 100%
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 - - (2,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
May 31, 2017
Local Road & Bridge Grant
Special Revenue
City Funds
Form 3
43
Fund Name Fund Number 271
Fund Type Date Updated 6/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 22 1 4 5 - 18 20%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 22 1 4 5 - 18 20%
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 4 5 - (1,349)
Cash Balance 1,352 1,340
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. This fund will be closed in 2017.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Eastrace Waterway
Special Revenue
City Funds
Form 3
44
Fund Name Fund Number 273
Fund Type Date Updated 6/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 18,000 930 3,131 6,702 - 14,869 17%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 300 17 142 125 - 158 47%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 18,300 947 3,273 6,827 - 15,027 18%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 21,675 1,998 5,673 2,457 - 16,002 26%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 21,675 1,998 5,673 2,457 - 16,002 26%
Net (3,375) (1,050) (2,400) 4,371 - (975)
Cash Balance 44,687 34,722
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 Marquee 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
May 31, 2017
Morris PAC / Palais Royale Marketing
Special Revenue
City Funds
Form 3
45
Fund Name Fund Number 280
Fund Type Date Updated 6/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 50 1 12 15 - 38 25%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 50 1 12 15 - 38 25%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 50 1 12 15 - 38
Cash Balance 3,898 3,865
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
May 31, 2017
Police Block Grants
Special Revenue
City Funds
Form 3
46
Fund Name Fund Number 281
Fund Type Date Updated 6/15/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 11 88 109 - 112 44%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 200 11 88 109 - 112 44%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 200 11 88 109 - 112
Cash Balance 27,700 27,471
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
May 31, 2017
Economic Develop Commission-Revenue Bonds
Special Revenue
City Funds
Form 3
47
Fund Name Fund Number 289
Fund Type Date Updated 6/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 - 10 84 127 - (84) 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 10,000 10 84 127 - 9,916 1%
Expenditures
Personnel - - - - - - 0%
Supplies 10,431 4,057 4,742 1,170 57 5,632 46%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 10,431 4,057 4,742 1,170 57 5,632 46%
Net (431) (4,047) (4,659) (1,043) (57) 4,285
Cash Balance 22,116 31,019
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
May 31, 2017
HAZMAT
Special Revenue
City Funds
Form 3
48
Fund Name Fund Number 291
Fund Type Date Updated 6/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 23,400 54,000 53,100 - (9,000) 120%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 500 62 475 404 - 25 95%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 45,500 23,462 54,475 53,504 - (8,975) 120%
Expenditures
Personnel 15,500 231 1,154 1,154 777 13,569 12%
Supplies 8,849 187 1,517 4,350 717 6,615 25%
Services 65,000 10,001 33,469 7,168 25,294 6,237 90%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 89,349 10,419 36,140 12,672 26,788 26,421 70%
Net (43,849) 13,043 18,335 40,832 (26,788) (35,396)
Cash Balance 163,071 136,277
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.
Multiple motor repairs were paid in April.
The encumbrances for services include a $18,990 PO for lights on the boats and $6,300 for instructor gear.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Indiana River Rescue
Special Revenue
City Funds
Form 3
49
Fund Name Fund Number 292
Fund Type Date Updated 6/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 106 5,587 31,964 27,347 (22,129) 305%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 10,805 106 5,587 31,964 27,347 (22,129) 305%
Net (10,805) (106) (5,587) (31,964) (27,347) 22,129
Cash Balance 71,041 89,232
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.
All expenses are for the Lexipol implementation
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Police Grants
Special Revenue
City Funds
Form 3
50
Fund Name Fund Number 294
Fund Type Date Updated 6/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 2,450 15,100 18,600 - 4,900 76%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 500 33 260 311 - 240 52%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 2,000 - 50 - - 1,950 3%
Transfers In - - - - - - 0%
Total Revenue 22,500 2,483 15,410 18,911 - 7,090 68%
Expenditures
Personnel - - - - - - 0%
Supplies 1,500 - 574 100 - 926 38%
Services 21,000 515 1,987 2,099 - 19,013 9%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 22,500 515 2,561 2,199 - 19,939 11%
Net - 1,968 12,849 16,712 - (12,849)
Cash Balance 88,924 86,930
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
May 31, 2017
Regional Police Academy
Special Revenue
City Funds
Form 3
51
Fund Name Fund Number 295
Fund Type Date Updated 6/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 2,000 58 681 496 - 1,319 34%
Bond Proceeds - - - - - - 0%
Donations 3,250 - - - - 3,250 0%
Other Income 64,500 10,320 49,059 25,720 - 15,441 76%
Transfers In - - - - - - 0%
Total Revenue 123,500 10,378 49,740 33,536 - 73,760 40%
Expenditures
Personnel - - - - - - 0%
Supplies 110,467 - 23,860 4,010 40,066 46,541 58%
Services 153,300 915 111,718 23,927 1,480 40,102 74%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 263,767 915 135,578 27,937 41,546 86,643 67%
Net (140,267) 9,463 (85,838) 5,599 (41,546) (12,883)
Cash Balance 151,841 127,156
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.
The $40,000 Encumbrances are for dash cameras paid for by a grant.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
COPS MORE Grant
Special Revenue
City Funds
Form 3
52
Fund Name Fund Number 299
Fund Type Date Updated 6/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 161 785 552 - 215 79%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 1,000 - - - - 1,000 0%
Transfers In - - - - - - 0%
Total Revenue 32,000 161 785 552 - 31,215 2%
Expenditures
Personnel - - - - - - 0%
Supplies 89,337 - 34,337 6,965 - 55,000 38%
Services 62,000 - 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 - 47,537 12,042 - 148,800 24%
Net (164,337) 161 (46,752) (11,490) - (117,585)
Cash Balance 179,306 241,261
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
May 31, 2017
Police Federal Drug Enforcement
Special Revenue
City Funds
Form 3
53
Fund Name Fund Number 404
Fund Type Date Updated 6/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 10,459,265 871,605 4,358,027 3,939,176 - 6,101,238 42%
Other Taxes - - - - - - 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 95,000 3,109 27,866 45,710 - 67,134 29%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 409,574 250 365,902 375,105 - 43,672 89%
Transfers In - - - - - - 0%
Total Revenue 10,963,839 874,964 4,751,795 4,359,990 - 6,212,044 43%
Expenditures
Personnel - - - 210,972 - - 0%
Supplies 1,234,438 63,098 400,232 280,119 9,454 824,752 33%
Services 5,717,611 (38,566) 2,333,386 2,932,531 509,114 2,875,111 50%
Debt Service 1,162,337 (10,711) 578,095 1,371,117 - 584,242 50%
Capital 514,629 - 24,868 9,183 208,312 281,449 45%
Transfers Out 3,442,578 - 1,546,116 750,000 - 1,896,463 45%
Total Expenditures 12,071,593 13,821 4,882,696 5,553,922 726,880 6,462,016 46%
Net (1,107,754) 861,143 (130,901) (1,193,932) (726,880) (249,973)
Cash Balance 8,781,524 10,891,357
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 costs have been moved into fund 279 for 2017 Certain debt
service payments on public facilities including the Public 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. Expenditures are consistent with normal operating costs.
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
May 31, 2017
County Option Income Tax
Special Revenue
City Funds
Form 3
54
Fund Name Fund Number 408
Fund Type Date Updated 6/15/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 4,366,689 3,997,751 - 6,066,672 42%
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 4,085 36,273 39,178 - 23,727 60%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 268 - - 0%
Transfers In 735,236 - 735,240 - - (4) 100%
Total Revenue 11,733,257 870,753 5,642,863 4,541,857 - 6,090,394 48%
Expenditures
Personnel - - - - - - 0%
Supplies 83 - - 140 83 0 100%
Services 4,404,649 30,679 1,517,299 417,089 1,810,449 1,076,901 76%
Debt Service 384,256 31,986 195,232 630,323 - 189,024 51%
Capital 102,700 - 60,317 2,628 - 42,383 59%
Transfers Out 6,667,496 - 3,303,748 2,576,105 - 3,363,748 50%
Total Expenditures 11,559,184 62,665 5,076,596 3,626,285 1,810,532 4,672,057 60%
Net 174,073 808,087 566,267 915,572 (1,810,532) 1,418,338
Cash Balance 11,728,948 10,789,617
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 development 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
May 31, 2017
Economic Development Income Tax
Special Revenue
City Funds
Form 3
55
Fund Name Fund Number 410
Fund Type Date Updated 6/15/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 207 1,796 2,281 - 4,314 29%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 6,110 207 1,796 2,281 - 4,314 29%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 126,144 - 62,515 146,068 - 63,629 50%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 126,144 - 62,515 146,068 - 63,629 50%
Net (120,034) 207 (60,719) (143,787) - (59,315)
Cash Balance 531,757 486,614
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
May 31, 2017
Urban Development Action Grant
Special Revenue
City Funds
Form 3
56
Fund Name Fund Number 655
Fund Type Date Updated 6/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 440,153 37,012 184,215 183,197 - 255,938 42%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,403 313 2,807 3,807 - 1,596 64%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 444,556 37,325 187,022 187,004 - 257,534 42%
Expenditures
Personnel 49,851 - - - - 49,851 0%
Supplies 4,344 - 876 - - 3,468 20%
Services 49,001 3,108 16,340 15,420 - 32,661 33%
Debt Service 72,220 - 36,109 36,109 - 36,111 50%
Capital - - - - - - 0%
Transfers Out 350,000 - 175,000 350,000 - 175,000 50%
Total Expenditures 525,416 3,108 228,325 401,529 - 297,091 43%
Net (80,860) 34,217 (41,304) (214,525) - (39,556)
Cash Balance 834,260 708,476
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 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
May 31, 2017
Project Releaf
Special Revenue
City Funds
Form 3
57
Fund Name Fund Number 705
Fund Type Date Updated 6/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 1 9 15 - 11 46%
Bond Proceeds - - - - - - 0%
Donations 2,000 - - - - 2,000 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 2,020 1 9 15 - 2,011 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 - 1 9 15 - (9)
Cash Balance 2,867 3,884
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
May 31, 2017
Police K-9 Unit
Special Revenue
City Funds
Form 3
58
Fund Name Fund Number 313
Fund Type Date Updated 6/15/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 - - - - 67,000 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 300 10 97 - - 203 32%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 46,715 - - 0%
Transfers In - - - - - - 0%
Total Revenue 938,528 10 97 46,715 - 938,431 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 1,268,999 - 631,735 636,000 - 637,264 50%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,268,999 - 631,735 636,000 - 637,264 50%
Net (330,471) 10 (631,638) (589,285) - 301,167
Cash Balance (338,844) (577,889)
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
May 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 6/15/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 117 428 - - 3,572 11%
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 117 1,327,178 - - 1,316,036 50%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 2,643,214 - 1,437,970 - - 1,205,244 54%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 2,643,214 - 1,437,970 - - 1,205,244 54%
Net - 117 (110,792) - - 110,792
Cash Balance 651,297 -
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).
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. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
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
May 31, 2017
South Bend Building Corp
City Debt Service
City Funds
Form 3
60
Fund Name Fund Number 757
Fund Type Date Updated 6/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 1,000 80 343 - - 657 34%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 390,482 - 130,260 - - 260,222 33%
Total Revenue 391,482 80 130,603 - - 260,879 33%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 391,482 - 198,566 - - 192,916 51%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 391,482 - 198,566 - - 192,916 51%
Net - 80 (67,962) - - 67,962
Cash Balance 493,980 -
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.
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. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
Transfers in are from the bond trustee.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Parks Bond Debt Service
City Debt Service
City Funds
Form 3
61
Fund Name Fund Number 377
Fund Type Date Updated 6/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 700,000 23,090 224,912 414,361 - 475,088 32%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,000 56 699 1,210 - 1,301 35%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 30,000 - 17,864 24,026 - 12,136 60%
Transfers In - - - - - - 0%
Total Revenue 732,000 23,146 243,475 439,598 - 488,525 33%
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) 23,146 (224,965) (33,490) - 129,010
Cash Balance 172,313 393,884
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 currently 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
May 31, 2017
Professional Sports Development
Capital Project
City Funds
Form 3
62
Fund Name Fund Number 401
Fund Type Date Updated 6/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 40,000 - - - - 40,000 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 900 35 289 292 - 611 32%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 40,900 35 289 292 - 40,611 1%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 30,000 4,569 13,111 22,000 9,829 7,060 76%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 30,000 4,569 13,111 22,000 9,829 7,060 76%
Net 10,900 (4,535) (12,822) (21,708) (9,829) 33,552
Cash Balance 77,712 60,845
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 significant 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
May 31, 2017
Coveleski Stadium Capital
Capital Project
City Funds
Form 3
63
Fund Name Fund Number 403
Fund Type Date Updated 6/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 200 11 151 197 - 49 76%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 200 11 151 197 - 49 76%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 49,688 - 53,599 - - (3,911) 108%
Transfers Out - - - - - - 0%
Total Expenditures 49,688 - 53,599 - - (3,911) 108%
Net (49,488) 11 (53,448) 197 - 3,960
Cash Balance (3,549) 49,642
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. Correcting entry to alleviate negative cash balance will be prepared in June.
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
May 31, 2017
Zoo Endowment
Capital Project
City Funds
Form 3
64
Fund Name Fund Number 405
Fund Type Date Updated 6/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 26,000 1,218 2,588 2,707 - 23,412 10%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,000 64 625 1,680 - 3,375 16%
Bond Proceeds - - - - - - 0%
Donations 100,000 25,000 50,000 - - 50,000 50%
Other Income 22,000 - 4,000 - - 18,000 18%
Transfers In 287,850 - - - - 287,850 0%
Total Revenue 439,850 26,282 57,213 4,387 - 382,637 13%
Expenditures
Personnel - - - - - - 0%
Supplies 67,326 16,930 47,519 25,529 13,242 6,565 90%
Services 63,288 - 4,954 26,805 4,266 54,068 15%
Debt Service - - - - - - 0%
Capital 97,410 - 92,396 - 51,000 (45,986) 147%
Transfers Out - - - - - - 0%
Total Expenditures 228,024 16,930 144,869 52,334 68,508 14,647 94%
Net 211,826 9,351 (87,656) (47,947) (68,508) 367,990
Cash Balance 223,053 421,776
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 and 2016 due to an oversight. This will be corrected in 2017 and
revenues going forward in this fund should be more consistent. Encumbrances for Supplies are made up of many small PO's, with $500 for
Maintenance, $10.3K for Golf and $2.5K for Recreation.
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. There is a budget adjustment before the Council that will appropriate
necessary funds to alleviate the negative balance in the Capital accounts.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Park Nonreverting Capital
Capital Project
City Funds
Form 3
65
Fund Name Fund Number 406
Fund Type Date Updated 6/15/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 - - - - 37,500 0%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 3,000 169 1,555 1,975 - 1,445 52%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 22,100 - - 0%
Transfers In - - - - - - 0%
Total Revenue 476,500 169 1,555 24,075 - 474,945 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 476,500 149,081 289,627 304,922 - 186,873 61%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 476,500 149,081 289,627 304,922 - 186,873 61%
Net - (148,912) (288,072) (280,847) - 288,072
Cash Balance 292,242 291,113
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
May 31, 2017
Cumulative Capital Development
Capital Project
City Funds
Form 3
66
Fund Name Fund Number 407
Fund Type Date Updated 6/15/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 132 1,137 1,188 - 863 57%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 25,000 - - - - 25,000 0%
Transfers In - - - - - - 0%
Total Revenue 435,000 132 151,137 151,188 - 283,863 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 132 (33,988) (32,937) - 96,738
Cash Balance 344,257 278,294
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
May 31, 2017
Cumulative Capital Improvement
Capital Project
City Funds
Form 3
67
Fund Name Fund Number 412
Fund Type Date Updated 6/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 25,000 1,135 8,264 8,970 - 16,736 33%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 1,028,786 - 596,589 707,598 - 432,197 58%
Transfers In - - - - - - 0%
Total Revenue 1,053,786 1,135 604,853 716,568 - 448,933 57%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 1,468,808 910 1,514 8,459 1,332,915 134,379 91%
Debt Service - - - - - - 0%
Capital 1,001,900 - - 523,679 241,900 760,001 24%
Transfers Out - - - - - - 0%
Total Expenditures 2,470,708 910 1,514 532,138 1,574,814 894,380 64%
Net (1,416,922) 225 603,339 184,430 (1,574,814) (445,446)
Cash Balance 2,967,428 2,466,112
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
May 31, 2017
Major Moves Construction
Capital Project
City Funds
Form 3
68
Fund Name Fund Number 416
Fund Type Date Updated 6/15/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 5,563 42,254 39,328 - 57,746 42%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 4,000 234 1,894 2,055 - 2,106 47%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 104,000 5,797 44,148 41,383 - 59,852 42%
Expenditures
Personnel - - - - - - 0%
Supplies 20,958 540 3,199 5,280 630 17,129 18%
Services 35,186 - 817 12,944 - 34,369 2%
Debt Service - - - - - - 0%
Capital 50,000 - - - - 50,000 0%
Transfers Out - - - - - - 0%
Total Expenditures 106,144 540 4,016 18,225 630 101,498 4%
Net (2,144) 5,257 40,132 23,158 (630) (41,646)
Cash Balance 629,965 539,884
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
May 31, 2017
Morris Performing Arts Center Capital
Capital Project
City Funds
Form 3
69
Fund Name Fund Number 434
Fund Type Date Updated 6/15/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 - - - 271 - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 271 - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net - - - 271 - -
Cash Balance - 2,675
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
May 31, 2017
Community Revitalization Enhancement District
Capital Project
City Funds
Form 3
70
Fund Name Fund Number 450
Fund Type Date Updated 6/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 600 37 302 308 - 298 50%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 16,500 646 3,332 4,252 - 13,168 20%
Transfers In - - - - - - 0%
Total Revenue 17,100 683 3,634 4,560 - 13,466 21%
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 683 3,634 4,560 - 8,466
Cash Balance 96,544 80,973
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
May 31, 2017
Palais Royale Historic Preservation
Capital Project
City Funds
Form 3
71
Fund Name Fund Number 677
Fund Type Date Updated 6/15/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 182 1,562 1,967 - 3,438 31%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 48,709 - - 0%
Transfers In - - - - - - 0%
Total Revenue 5,000 182 1,562 50,676 - 3,438 31%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 81,091 2,159 26,666 32,831 13,185 41,240 49%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 81,091 2,159 26,666 32,831 13,185 41,240 49%
Net (76,091) (1,977) (25,104) 17,845 (13,185) (37,802)
Cash Balance 470,336 520,721
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
May 31, 2017
Football Hall of Fame Capital
Capital Project
City Funds
Form 3
72
Fund Name Fund Number 750
Fund Type Date Updated 6/15/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 212 1,108 - - 892 55%
Bond Proceeds 5,499,000 2,916,500 2,916,500 - - 2,582,500 53%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 5,501,000 2,916,712 2,917,608 - - 2,583,392 53%
Expenditures
Personnel - - - - - - 0%
Supplies 230,000 - - - - 230,000 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 5,270,000 135,750 1,674,132 - 1,718,872 1,876,997 64%
Transfers Out - - - - - - 0%
Total Expenditures 5,500,000 135,750 1,674,132 - 1,718,872 2,106,997 62%
Net 1,000 2,780,962 1,243,477 - (1,718,872) 476,395
Cash Balance 4,421,370 -
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.
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. No expenses show for prior year because the fund was not integrated into City's
books until 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
May 31, 2017
Equipment/Vehicle Leasing
Capital Project
City Funds
Form 3
73
Fund Name Fund Number 751
Fund Type Date Updated 6/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 7,500 517 1,909 - - 5,591 25%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 7,500 517 1,909 - - 5,591 25%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - 29,118 (29,118) 0%
Services - - - - 9,231 (9,231) 0%
Debt Service - - - - - - 0%
Capital 3,500,000 19,839 434,776 - - 3,065,224 12%
Transfers Out - - - - - - 0%
Total Expenditures 3,500,000 19,839 434,776 - 38,350 3,026,874 14%
Net (3,492,500) (19,322) (432,867) - (38,350) (3,021,283)
Cash Balance 3,904,332 -
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.
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. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
The vast majority of the $435K spent on capital is for an HVAC upgrade at the Martin Luther King Center. Effective in May 2017, this fund will now
use PO's to encumber expenditures to enable tracking in NaviLine. The payments will still be made through the bond trustee, but the payments will
be cleared in NaviLine as well.
Capital expenditures include $350K for upgrades to the HVAC system at the Martin Luther King Center and $84K for miscellaneous park
improvements.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Parks Bond Capital
Capital Project
City Funds
Form 3
74
Fund Name Fund Number 753
Fund Type Date Updated 6/15/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 545 2,356 - - 14,644 14%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 17,000 545 2,356 - - 14,644 14%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 10,000,000 617,149 2,402,042 - - 7,597,958 24%
Transfers Out - - - - - - 0%
Total Expenditures 10,000,000 617,149 2,402,042 - - 7,597,958 24%
Net (9,983,000) (616,605) (2,399,686) - - (7,583,314)
Cash Balance 3,529,767 -
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.
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. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
Conversion from 1-way to 2-way streets and other improvements associated with the conversion project.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Smart Streets Bond Capital
Capital Project
City Funds
Form 3
75
Fund Name Fund Number 287
Fund Type Date Updated 6/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 4,485,349 - 1,798,417 1,307,757 - 2,686,932 40%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 10,000 1,927 12,540 12,143 - (2,540) 125%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 4,495,349 1,927 1,810,957 1,319,900 - 2,684,392 40%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 184,010 75,200 75,200 - 108,810 - 100%
Debt Service 729,756 61,062 297,105 - - 432,651 41%
Capital 2,186,611 25 536,699 585,053 1,198,207 451,705 79%
Transfers Out - - - - - - 0%
Total Expenditures 3,100,377 136,287 909,004 585,053 1,307,017 884,356 71%
Net 1,394,972 (134,359) 901,953 734,847 (1,307,017) 1,800,036
Cash Balance 4,531,487 3,307,087
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 payment under services was made for $75,200 for the Locution project that will be installing Station alerting systems in all of the stations.
Planned purchase of ambulance, replacement cardiac monitors, fleet vehicle.
A new, smaller ambulance was purchased in February 2017. 5 homes were purchased in April for the new location of Station #9. Total cost was
$385,570.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Emergency Medical Services Capital
Enterprise
City Funds
Form 3
76
Fund Name Fund Number 288
Fund Type Date Updated 6/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 371,870 1,962,602 2,288,915 - 4,364,910 31%
Fines, Forfeitures, and Fees 2,500 300 1,000 1,300 - 1,500 40%
Interest Earnings 15,000 681 5,472 8,916 - 9,528 36%
Bond Proceeds - - - - - - 0%
Donations - - 750 - - (750) 0%
Other Income 5,000 72 597 73,347 - 4,403 12%
Transfers In - - - - - - 0%
Total Revenue 6,350,012 372,922 1,970,421 2,372,479 - 4,379,591 31%
Expenditures
Personnel 5,180,304 338,623 1,749,124 1,648,354 - 3,431,180 34%
Supplies 358,825 25,994 133,681 120,429 33,592 191,552 47%
Services 577,692 73,255 203,340 156,331 14,081 360,271 38%
Debt Service 1,093 - 318 287,154 1,729 (954) 187%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 6,117,914 437,873 2,086,462 2,212,268 49,402 3,982,050 35%
Net 232,098 (64,950) (116,041) 160,211 (49,402) 397,541
Cash Balance 1,585,416 2,255,436
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.
A payment to Memorial Hospital of $32,700 was made per the contract. Also, $20,000 was spent on fire gear and clothing for the newly sworn
firefighters
Fire Department and EMS capital expenditures are accounted for in the EMS Capital Fund #287.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Emergency Medical Services Operating
Enterprise
City Funds
Form 3
77
Fund Name Fund Number 600
Fund Type Date Updated 6/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 25,000 3,430 12,946 11,640 - 12,054 52%
Charges for Services 1,477,850 146,574 595,060 546,153 - 882,790 40%
Fines, Forfeitures, and Fees 280,000 4,477 25,050 17,305 - 254,950 9%
Interest Earnings 11,000 1,184 8,420 7,838 - 2,580 77%
Bond Proceeds - - - - - - 0%
Donations 4,000 - - 557 - 4,000 0%
Other Income 11,300 184 2,771 7,965 - 8,529 25%
Transfers In 2,167,316 - 1,083,658 527,517 - 1,083,658 50%
Total Revenue 3,976,466 155,849 1,727,905 1,118,975 - 2,248,561 43%
Expenditures
Personnel 2,696,460 201,477 966,830 926,518 - 1,729,630 36%
Supplies 113,282 6,370 45,933 24,062 15,008 52,341 54%
Services 892,868 66,835 332,311 254,032 47,515 513,042 43%
Debt Service 75,210 4,403 29,025 16,474 1,296 44,888 40%
Capital - - - 30,608 - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 3,777,820 279,085 1,374,099 1,251,693 63,819 2,339,902 38%
Net 198,646 (123,236) 353,805 (132,718) (63,819) (91,340)
Cash Balance 2,979,524 1,770,068
Staffing Budget Actual Fund Purpose:
Code Enforcement (600-1201)/Animal Control (600-1207)
Full Time 24.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 40.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
May 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.
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. 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.
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
78
Fund Name Fund Number 601
Fund Type Date Updated 6/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 1,000,629 135,473 527,800 419,913 - 472,829 53%
Fines, Forfeitures, and Fees 99,000 4,150 22,678 25,786 - 76,322 23%
Interest Earnings 12,000 440 3,227 2,650 - 8,773 27%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 11,282 96 296 7 - 10,986 3%
Transfers In - - - - - - 0%
Total Revenue 1,122,911 140,159 554,001 448,357 - 568,910 49%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 1,208,218 24,534 320,725 348,404 604,785 282,708 77%
Debt Service - - - - - - 0%
Capital 39,036 - - - 39,036 - 100%
Transfers Out - - - - - - 0%
Total Expenditures 1,247,254 24,534 320,725 348,404 643,822 282,708 77%
Net (124,343) 115,624 233,276 99,952 (643,822) 286,202
Cash Balance 1,203,688 740,570
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 what remains of $892K for the annual Block By Block contract, for maintaining the garages and
assisting patrons. In addition to revenues for parking fees, $265K in revenue is a reimbursement from DTSB to the City to reimburse for the City's
expenditures to a third party for the Downtown Ambassador program.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Parking Garages
Enterprise
City Funds
Form 3
79
Fund Name Fund Number 610
Fund Type Date Updated 6/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 329,392 2,170,742 2,222,479 - 3,575,433 38%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,500 186 1,079 1,086 - 1,421 43%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 50,800 - 50,771 27,243 - 29 100%
Transfers In - - - - - - 0%
Total Revenue 5,799,475 329,577 2,222,592 2,250,808 - 3,576,883 38%
Expenditures
Personnel 1,781,122 124,972 646,785 576,600 - 1,134,337 36%
Supplies 187,532 25,235 96,336 59,552 35,073 56,123 70%
Services 2,848,943 177,608 977,207 1,202,568 171,382 1,700,354 40%
Debt Service 9,700 - - 9,700 9,700 - 100%
Capital - - - - - - 0%
Transfers Out 835,613 20,000 203,600 262,000 - 632,013 24%
Total Expenditures 5,662,910 347,815 1,923,928 2,110,420 216,155 3,522,827 38%
Net 136,565 (18,238) 298,663 140,388 (216,155) 54,057
Cash Balance 612,932 415,145
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.
Current month and year to date service revenue appears low due to the crediting of year to date recycling fees posted in error to customer
accounts. Encumbrances for future CNG fuel deliveries are causing the percentage of supplies budget used to appear high. 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
May 31, 2017
Solid Waste Operations
Enterprise
City Funds
Form 3
80
Fund Name Fund Number 611
Fund Type Date Updated 6/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 - - - 300,000 - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 700 27 485 237 - 215 69%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 835,613 20,000 203,600 262,000 - 632,013 24%
Total Revenue 836,313 20,027 204,085 562,237 - 632,228 24%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 1,123,613 20,129 537,819 366,205 - 585,794 48%
Capital 12,000 - - - - 12,000 0%
Transfers Out - - - - - - 0%
Total Expenditures 1,135,613 20,129 537,819 366,205 - 597,794 47%
Net (299,300) (102) (333,734) 196,032 - 34,434
Cash Balance 2,713 196,474
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
May 31, 2017
Solid Waste Capital
Enterprise
City Funds
Form 3
81
Fund Name Fund Number 620
Fund Type Date Updated 6/15/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 15,570,122 1,114,582 5,515,534 5,464,117 - 10,054,588 35%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 35,000 1,018 9,460 14,007 - 25,540 27%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 83,000 6,058 19,366 40,630 - 63,634 23%
Transfers In 62,500 1,849 14,192 13,924 - 48,308 23%
Total Revenue 15,750,622 1,123,506 5,558,552 5,532,677 - 10,192,070 35%
Expenditures
Personnel 5,604,157 387,825 2,009,571 2,011,505 3,099 3,591,488 36%
Supplies 1,727,233 89,930 495,204 416,213 163,763 1,068,266 38%
Services 5,995,181 384,196 1,889,308 1,657,832 578,231 3,527,642 41%
Debt Service 328,853 1,580 112,214 9,265 2,463 214,176 35%
Capital - - - - - - 0%
Transfers Out 4,071,830 312,832 1,756,162 1,966,261 - 2,315,668 43%
Total Expenditures 17,727,254 1,176,363 6,262,458 6,061,075 747,555 10,717,240 40%
Net (1,976,632) (52,857) (703,906) (528,398) (747,555) (525,170)
Cash Balance 3,085,991 3,418,001
Staffing Budget Actual
Full Time 72.00 68.00
Part-Time /Seasonal/Temporary 3.56 1.89
Total 75.56 69.89
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. Delays in the adoption of the water rate ordinance has impact on the percentage of revenue budget year to date. Other income year to date
is down as a result of a lesser amount of scrap metal receipts collected.
Water Works capital expenditures are accounted for in the Water Works Capital Fund #622.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Water Works Operations
Enterprise
City Funds
Form 3
82
Fund Name Fund Number 622
Fund Type Date Updated 6/15/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 875 7,893 11,446 - 7,107 53%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 15,000 875 7,893 11,446 - 7,107 53%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 1,414,466 8,299 321,083 6,750 171,906 921,477 35%
Transfers Out - - - - - - 0%
Total Expenditures 1,414,466 8,299 321,083 6,750 171,906 921,477 35%
Net (1,399,466) (7,424) (313,191) 4,696 (171,906) (914,369)
Cash Balance 2,282,623 2,885,104
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 - $31,368
Encumb:
1 Ton 2WD Dump Truck (1) $48,493
Hydraulic Breaker (unit 586) (1) $11,843
Ford Transit Connect Cargo Van (3) $68,247
North Station Well #1 Replacement Project - Engineering Design $43,000 and Well Drilling $323
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Water Works Capital
Enterprise
City Funds
Form 3
83
Fund Name Fund Number 624
Fund Type Date Updated 6/15/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 583 4,902 6,016 - 10,098 33%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 15,000 583 4,902 6,016 - 10,098 33%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 15,000 583 4,617 4,048 - 10,383 31%
Total Expenditures 15,000 583 4,617 4,048 - 10,383 31%
Net - - 285 1,968 - (285)
Cash Balance 1,513,843 1,528,157
Fund Purpose:
Explain Significant Revenue and Expenditure Changes/Variances Below:
Explain Significant Spending on Capital Projects Below:
Security deposits are collected from utility customers and are retained in this restricted fund. Upon termination of service, refunds are credit applied
to the customers final bill.
Revenue and expenditures are tied to the enrollment and termination of service.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Water Works Customer Deposit
Enterprise
City Funds
Form 3
84
Fund Name Fund Number 625
Fund Type Date Updated 6/15/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 266 1,912 1,505 - 6,588 22%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 2,046,391 164,000 820,000 852,525 - 1,226,391 40%
Total Revenue 2,054,891 164,266 821,912 854,030 - 1,232,979 40%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 2,046,391 - - - - 2,046,391 0%
Capital - - - - - - 0%
Transfers Out 8,500 266 1,902 1,499 - 6,598 22%
Total Expenditures 2,054,891 266 1,902 1,499 - 2,052,989 0%
Net - 164,000 820,009 852,531 - (820,009)
Cash Balance 870,167 856,936
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. The fund receives transfers in
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
May 31, 2017
Water Works Sinking
Enterprise
City Funds
Form 3
85
Fund Name Fund Number 626
Fund Type Date Updated 6/15/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 548 4,604 6,405 - 11,396 29%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 16,000 548 4,604 6,405 - 11,396 29%
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 - 548 4,604 4,354 - (4,604)
Cash Balance 1,431,969 1,643,916
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. 2017 cash reserve requirement is $1,421,206.
Interest earnings are transferred to Water Works Operations Fund #620. Future intent is to transfer out the excess monies to the operating fund
620.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Water Works Bond Reserve
Enterprise
City Funds
Form 3
86
Fund Name Fund Number 629
Fund Type Date Updated 6/15/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 1,000 8,128 9,233 - 14,872 35%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 151,500 - 151,272 227,461 - 228 100%
Total Revenue 174,500 1,000 159,400 236,694 - 15,100 91%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 23,000 1,000 7,673 6,327 - 15,327 33%
Total Expenditures 23,000 1,000 7,673 6,327 - 15,327 33%
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 Operations
Fund #620, excluding transfers.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Water Works Reserve Operations & Maintenance
Enterprise
City Funds
Form 3
87
Fund Name Fund Number 640
Fund Type Date Updated 6/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 613,924 52,682 265,761 258,838 - 348,163 43%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 7,864 689 5,703 6,669 - 2,161 73%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 621,788 53,371 271,464 265,507 - 350,324 44%
Expenditures
Personnel 219,798 16,893 79,531 59,357 - 140,267 36%
Supplies 37,970 548 10,481 12,888 6,427 21,062 45%
Services 262,444 32,170 137,219 134,454 55,333 69,892 73%
Debt Service 14,297 14,218 14,218 14,218 - 79 99%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 534,509 63,829 241,449 220,918 61,760 231,300 57%
Net 87,279 (10,458) 30,015 44,589 (61,760) 119,024
Cash Balance 1,788,363 1,696,393
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.
2016 1st quarter Stats/Expenses: "Successful" Second Opinions (when the line can be opened without excavation) - 33; "Unsuccessful" Second
Opinions (when the line cannot be opened without excavation) - 12; "Digs" (when the repair requires excavation because of a blockage or collapse
of the line) - 20. Total program expense $117,408.55.
2017 1st quarter Stats/Expenses: "Successful" Second Opinions - 49; "Unsuccessful" Second Opinions - 9; "Digs" - 19. Total program expense
$124,888.46.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Sewer Repair Insurance
Enterprise
City Funds
Form 3
88
Fund Name Fund Number 641
Fund Type Date Updated 6/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 3,500 11,450 41,220 3,500 - (37,720) 1178%
Charges for Services 37,016,904 3,085,160 15,611,468 15,557,843 - 21,405,436 42%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 65,000 5,424 46,166 38,757 - 18,834 71%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 56,500 4,670 14,961 14,383 - 41,539 26%
Transfers In 30,000 1,972 14,217 11,288 - 15,783 47%
Total Revenue 37,171,904 3,108,675 15,728,032 15,625,770 - 21,443,872 42%
Expenditures
Personnel 7,750,680 548,545 2,757,656 2,604,547 6 4,993,018 36%
Supplies 2,116,554 79,588 410,957 570,667 196,883 1,508,714 29%
Services 15,740,085 858,977 4,535,949 3,140,348 4,979,643 6,224,493 60%
Debt Service 882,869 53,977 360,804 270,188 41 522,024 41%
Capital - - - - - - 0%
Transfers Out 18,052,147 1,631,332 7,115,413 6,231,213 - 10,936,735 39%
Total Expenditures 44,542,335 3,172,418 15,180,778 12,816,963 5,176,574 24,184,984 46%
Net (7,370,431) (63,743) 547,254 2,808,807 (5,176,574) (2,741,112)
Cash Balance 14,330,594 11,744,130
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 is for system development fees, a new fee in 2017 that was not originally budgeted for. A budget amendment will be
requested to adjust this category. 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 year to date due to encumbrances for outside engineering services, manhole/sewer linings, annual contracts
and maintenance agreements, and building and equipment repair contracts that have reserved over half 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
May 31, 2017
Sewage Works Operations
Enterprise
City Funds
Form 3
89
Fund Name Fund Number 642
Fund Type Date Updated 6/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 45,000 2,267 20,036 33,166 - 24,964 45%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 400,000 - 400,000 - - - 100%
Transfers In 4,442,000 500,000 942,000 - - 3,500,000 21%
Total Revenue 4,887,000 502,267 1,362,036 33,166 - 3,524,964 28%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 8,040,455 530,257 2,488,259 1,096,392 1,733,768 3,818,429 53%
Transfers Out - - - - - - 0%
Total Expenditures 8,040,455 530,257 2,488,259 1,096,392 1,733,768 3,818,429 53%
Net (3,153,455) (27,989) (1,126,223) (1,063,226) (1,733,768) (293,464)
Cash Balance 6,239,216 7,673,124
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 $1,167,888
Grit & Screening Improvements $20,067
Calvert St. Lift Station $451,140
Digester Gas Utilization $139,548
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
May 31, 2017
Sewage Works Capital
Enterprise
City Funds
Form 3
90
Fund Name Fund Number 643
Fund Type Date Updated 6/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 30,000 1,972 15,073 16,070 - 14,927 50%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 516,755 - 516,755 896,725 - - 100%
Total Revenue 546,755 1,972 531,828 912,795 - 14,927 97%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 30,000 1,972 14,217 11,288 - 15,783 47%
Total Expenditures 30,000 1,972 14,217 11,288 - 15,783 47%
Net 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 were done 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
May 31, 2017
Sewage Works Reserve Operations & Maint.
Enterprise
City Funds
Form 3
91
Fund Name Fund Number 649
Fund Type Date Updated 6/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 13,000 1,431 5,446 7,686 - 7,554 42%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 9,164,024 762,798 3,813,988 3,804,463 - 5,350,037 42%
Total Revenue 9,177,024 764,229 3,819,433 3,812,149 - 5,357,591 42%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 9,163,754 830,476 831,976 1,148,456 - 8,331,778 9%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 9,163,754 830,476 831,976 1,148,456 - 8,331,778 9%
Net 13,270 (66,247) 2,987,457 2,663,693 - (2,974,187)
Cash Balance 3,803,120 3,468,434
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
May 31, 2017
Sewage Sinking
Enterprise
City Funds
Form 3
92
Fund Name Fund Number 653
Fund Type Date Updated 6/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 4,400 1,579 4,900 1,746 - (500) 111%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 4,400 1,579 4,900 1,746 - (500) 111%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 4,400 1,579 4,900 1,746 - (500)
Cash Balance 4,116,533 4,107,370
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 reconciliation of this account is done on a
monthly basis.
Not applicable to this fund.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Sewage Debt Service Reserve
Enterprise
City Funds
Form 3
93
Fund Name Fund Number 659
Fund Type Date Updated 6/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 - 7 154 922 - (154) 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - 7 154 922 - (154) 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) 7 (51,534) 922 - (154)
Cash Balance 144 232,816
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 will be transferred to the debt service fund #649 to be
applied to future loan payments. 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 $545,828
Wastewater Treatment Plant Digester Upgrade $5,945,471
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Sewer Bond 2011
Enterprise
City Funds
Form 3
94
Fund Name Fund Number 661
Fund Type Date Updated 6/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 50,000 984 9,239 52,828 - 40,761 18%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 50,000 984 9,239 52,828 - 40,761 18%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 250,000 - - - - 250,000 0%
Debt Service - - - - - - 0%
Capital 2,760,364 269,318 733,094 2,083,844 1,630,209 397,061 86%
Transfers Out - - - - - - 0%
Total Expenditures 3,010,364 269,318 733,094 2,083,844 1,630,209 647,061 79%
Net (2,960,364) (268,334) (723,855) (2,031,016) (1,630,209) (606,300)
Cash Balance 2,162,501 11,879,027
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 $235,790
Wastewater Treatment Plant Grit/Screening Improvements $64,037
Wastewater Treatment Secondary Improvements $433,268
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,554,175
Sewer Sensory Control Network $193,609
Wastewater Treatment Plant Grit/Screening Improvements $186,216
Secondary Improvements $3,164,611
CSO LTCP re-look $1,714,206
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Sewer Bond 2012
Enterprise
City Funds
Form 3
95
Fund Name Fund Number 664
Fund Type Date Updated 6/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 - - - 18 - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 18 - - 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net - - - 18 - -
Cash Balance - 4,524
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
May 31, 2017
2013A Cost of Issuance Fund
Enterprise
City Funds
Form 3
96
Fund Name Fund Number 666
Fund Type Date Updated 6/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 - - - 94 - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue - - - 94 - - 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,406) - -
Cash Balance - 6,684
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
May 31, 2017
2015 Sewer Bond Issuance
Enterprise
City Funds
Form 3
97
Fund Name Fund Number 670
Fund Type Date Updated 6/15/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 106,250 531,250 656,725 - 743,750 42%
Grants/Intergovernmental - - - - - - 0%
Licenses & Permits - - - - - - 0%
Charges for Services 2,909,311 306,443 1,178,466 1,134,476 - 1,730,845 41%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings - - - - - - 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 10,000 - 1,000 7,655 - 9,000 10%
Transfers In - - - - - - 0%
Total Revenue 4,194,311 412,693 1,710,716 1,798,856 - 2,483,595 41%
Expenditures
Personnel 2,327,806 194,075 901,041 874,036 - 1,426,765 39%
Supplies 513,040 60,450 225,775 236,827 - 287,265 44%
Services 1,144,768 68,215 473,643 502,606 - 671,125 41%
Debt Service - - - - - - 0%
Capital 126,529 - - - - 126,529 0%
Transfers Out 82,167 - - - - 82,167 0%
Total Expenditures 4,194,310 322,739 1,600,459 1,613,469 - 2,593,851 38%
Net 1 89,954 110,258 185,387 - (110,257)
Cash Balance 1,787,367 1,551,467
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.
Fund 670 and 671 are reported on an accrual basis, unlike the rest of the City's funds.
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
May 31, 2017
Century Center
Enterprise
City Funds
Form 3
98
Fund Name Fund Number 671
Fund Type Date Updated 6/15/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 358 413 - 392 48%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 750 74 358 413 - 392 48%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - 38,747 - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - 38,747 - - 0%
Net 750 74 358 (38,335) - 392
Cash Balance 866,345 963,737
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.
Fund 670 and 671 are reported on an accrual basis, unlike the rest of the City's funds.
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
May 31, 2017
Century Center Capital
Enterprise
City Funds
Form 3
99
Fund Name Fund Number 672
Fund Type Date Updated 6/15/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 22 107,742 - 110,108 0%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 82,167 - - - - 82,167 0%
Total Revenue 192,297 4 22 107,742 - 192,275 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 192,297 - 95,128 140,609 - 97,169 49%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 192,297 - 95,128 140,609 - 97,169 49%
Net - 4 (95,106) (32,867) - 95,106
Cash Balance (38,053) 17,165
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 Operating Fund (670), and a County hotel/motel tax allocation.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Century Center Energy Conservation Debt Svc
Enterprise
City Funds
Form 3
100
Fund Name Fund Number 222
Fund Type Date Updated 6/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 11,400 76 272 570 - 11,128 2%
Charges for Services 3,754,119 259,008 1,295,639 1,234,030 - 2,458,480 35%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 6,800 395 3,154 4,432 - 3,646 46%
Bond Proceeds - - - - - - 0%
Donations 10,000 - - - - 10,000 0%
Other Income 4,526,250 364,315 1,943,909 1,859,151 - 2,582,341 43%
Transfers In - - - - - - 0%
Total Revenue 8,308,569 623,794 3,242,974 3,098,183 - 5,065,595 39%
Expenditures
Personnel 3,288,165 214,595 1,120,498 1,022,093 - 2,167,667 34%
Supplies 170,652 62,053 64,909 98,142 11,841 93,901 45%
Services 4,803,470 393,054 2,033,830 1,860,164 1,679,180 1,090,459 77%
Debt Service 15,656 2,367 7,031 4,526 2,090 6,536 58%
Capital - - - - - - 0%
Transfers Out 286,700 - - - - 286,700 0%
Total Expenditures 8,564,643 672,069 3,226,269 2,984,925 1,693,111 3,645,263 57%
Net (256,074) (48,275) 16,705 113,258 (1,693,111) 1,420,332
Cash Balance 1,436,802 1,403,006
Staffing Budget Actual
Full Time 42.00 39.00
Part-Time /Seasonal/Temporary 2.00 2.00
Total 44.00 41.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 May we had 1,577 vehicle repairs. Average Fuel prices for May is $1.79 for Unleaded and $1.83 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. The large encumbrances for Services are the City Departments Utility Charges from the Sustainability Departments account.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Central Services
Internal Service
City Funds
Form 3
101
Fund Name Fund Number 224
Fund Type Date Updated 6/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 900 35 322 705 - 578 36%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 286,700 - - - - 286,700 0%
Total Revenue 287,600 35 322 705 - 287,278 0%
Expenditures
Personnel - - - - - - 0%
Supplies 28,000 - 9,786 - 13,439 4,775 83%
Services 69,025 - 21,762 - - 47,263 32%
Debt Service - - - - - - 0%
Capital 229,000 - - 135,447 - 229,000 0%
Transfers Out - - - - - - 0%
Total Expenditures 326,025 - 31,549 135,447 13,439 281,038 14%
Net (38,425) 35 (31,227) (134,742) (13,439) 6,240
Cash Balance 80,935 52,178
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).
The encumbrances for the Capital Supplies are for the Radio Shop's tower repairs throughout the city, we have a vendor working on towers around
the city.
Replacement of Inground Hoists at the Riverside North Garage, new mobile portable lifts for Sample Street garage, one stand alone Hyd. Pres.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Central Services Capital
Internal Service
City Funds
Form 3
102
Fund Name Fund Number 226
Fund Type Date Updated 6/15/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 1,216,239 924,461 - 1,711,352 42%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 30,000 1,847 14,949 18,179 - 15,051 50%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 600,000 - 35,742 12,878 - 564,258 6%
Transfers In - - - - - - 0%
Total Revenue 3,557,591 243,026 1,266,930 955,519 - 2,290,661 36%
Expenditures
Personnel 268,799 20,886 106,589 80,052 - 162,210 40%
Supplies 21,062 1,147 4,444 5,373 5,354 11,265 47%
Services 3,297,725 714,427 1,414,812 578,938 58,247 1,824,666 45%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 3,587,586 736,460 1,525,845 664,363 63,600 1,998,141 44%
Net (29,995) (493,434) (258,914) 291,156 (63,600) 292,520
Cash Balance 4,363,255 4,816,361
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 claims, $800,000 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
May 31, 2017
Liability Insurance
Internal Service
City Funds
Form 3
103
Fund Name Fund Number 278
Fund Type Date Updated 6/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 288 2,399 2,592 - 1,601 60%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - 44,380 - - 0%
Transfers In - - - - - - 0%
Total Revenue 4,000 288 2,399 46,972 - 1,601 60%
Expenditures
Personnel - - - - - - 0%
Supplies - (120) (180) - - 180 0%
Services 10,000 - 972 53 - 9,028 10%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 10,000 (120) 792 53 - 9,208 8%
Net (6,000) 408 1,608 46,919 - (7,608)
Cash Balance 754,459 688,391
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
May 31, 2017
Take Home Vehicle Police
Internal Service
City Funds
Form 3
104
Fund Name Fund Number 279
Fund Type Date Updated 6/15/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 2,153,105 198,068 - 3,051,929 41%
Transfers In - - - - - - 0%
Total Revenue 5,205,034 430,621 2,153,105 198,068 - 3,051,929 41%
Expenditures
Personnel 2,119,953 141,956 701,749 182,366 - 1,418,204 33%
Supplies 981,191 5,945 27,175 1,347 6,354 947,662 3%
Services 1,940,570 337,764 698,085 14,356 525,779 716,706 63%
Debt Service 163,320 9,580 66,676 - - 96,644 41%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 5,205,034 495,245 1,493,685 198,068 532,133 3,179,216 39%
Net - (64,624) 659,420 - (532,133) (127,287)
Cash Balance 666,275 -
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
May 31, 2017
IT / Innovation / 311 Call Center
Internal Service
City Funds
Form 3
105
Fund Name Fund Number 711
Fund Type Date Updated 6/15/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,477,818 7,417,692 6,906,884 - 10,338,158 42%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 40,000 3,312 24,688 18,925 - 15,312 62%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 4,563 - 4,563 161,503 - - 100%
Transfers In - - - - - - 0%
Total Revenue 17,800,413 1,481,130 7,446,942 7,087,312 - 10,353,471 42%
Expenditures
Personnel - - - - - - 0%
Supplies 78,935 23,797 50,712 13,901 2,655 25,568 68%
Services 1,217,190 259,700 564,752 788,274 538,308 114,130 91%
Insurance 16,507,075 818,568 5,015,840 5,821,193 68,094 11,423,140 31%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 17,803,200 1,102,064 5,631,304 6,623,368 609,057 11,562,839 35%
Net (2,787) 379,066 1,815,638 463,943 (609,057) (1,209,369)
Cash Balance 8,554,177 4,833,011
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
May 31, 2017
Self-Funded Employee Benefits
Internal Service
City Funds
Form 3
106
Fund Name Fund Number 713
Fund Type Date Updated 6/15/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 - - 27,029 - 81,000 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 2,000 102 890 1,056 - 1,110 45%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 83,000 102 890 28,086 - 82,110 1%
Expenditures
Personnel 45,000 3,015 23,387 15,258 - 21,613 52%
Supplies - - - - - - 0%
Services 39,105 309 3,745 14,035 11,000 24,360 38%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 84,105 3,324 27,132 29,293 11,000 45,973 45%
Net (1,105) (3,223) (26,242) (1,208) (11,000) 36,137
Cash Balance 260,311 268,075
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.
The personnel expenditures line item is unemployment compensation claims paid. Claims have been relatively stable. The services line item
includes a monthly administrative fee of $309 and a $11,000 encumbrances for potential outplacement services. To date, $2,200 has been paid for
outplacement services for one employee.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Unemployment Compensation
Internal Service
City Funds
Form 3
107
Fund Name Fund Number 701
Fund Type Date Updated 6/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 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 390,768 1,962,931 2,172,465 - 3,128,188 39%
Supplies 200 - 10 13 - 190 5%
Services 6,950 79 3,371 3,633 - 3,579 48%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 5,098,269 390,847 1,966,312 2,176,111 - 3,131,957 39%
Net 118,869 (390,847) (1,965,893) (2,175,051) - 2,084,762
Cash Balance (1,798,321) (1,702,746)
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
May 31, 2017
Firefighters Pension
Trust & Agency
City Funds
Form 3
108
Fund Name Fund Number 702
Fund Type Date Updated 6/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 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 - 1,628 2,773 - 2,872 36%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 2,000 595 9,057 - - (7,057) 453%
Transfers In - - - - - - 0%
Total Revenue 6,136,500 595 10,685 2,773 - 6,125,815 0%
Expenditures
Personnel 6,415,689 517,794 2,581,979 2,733,198 - 3,833,710 40%
Supplies 800 - - - - 800 0%
Services 7,400 91 3,369 3,481 - 4,031 46%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 6,423,889 517,885 2,585,347 2,736,679 - 3,838,542 40%
Net (287,389) (517,291) (2,574,662) (2,733,906) - 2,287,273
Cash Balance (1,782,109) (1,576,487)
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
May 31, 2017
Police Pension
Trust & Agency
City Funds
Form 3
109
Fund Name Fund Number 730
Fund Type Date Updated 6/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 200 11 92 113 - 108 46%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 200 11 92 113 - 108 46%
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) 11 92 113 - (5,892)
Cash Balance 28,895 28,655
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 activity. 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
May 31, 2017
City Cemetery
Trust & Agency
City Funds
Form 3
110
Fund Name Fund Number 324
Fund Type Date Updated 6/15/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 - 197,500 198,500 - 196,500 50%
Grants/Intergovernmental 33,745 - 33,745 - - - 100%
Licenses & Permits - - - - - - 0%
Charges for Services - - - - - - 0%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 103,829 9,267 92,388 122,316 - 11,441 89%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 4,519,290 61,029 259,104 407,486 - 4,260,186 6%
Transfers In 29,000 1,062 8,331 7,401 - 20,669 29%
Total Revenue 22,888,477 71,358 591,068 735,703 - 22,297,409 3%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 3,973,916 37,908 635,268 348,759 2,648,478 690,170 83%
Debt Service 8,182,182 - 3,847,140 2,815,449 - 4,335,042 47%
Capital 27,462,789 552,464 2,749,916 5,565,784 6,473,393 18,239,480 34%
Transfers Out - - - - - - 0%
Total Expenditures 39,618,887 590,372 7,232,324 8,729,992 9,121,871 23,264,692 41%
Net (16,730,410) (519,015) (6,641,255) (7,994,289) (9,121,871) (967,284)
Cash Balance 25,868,866 24,772,534
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.
Major capital expenditures thus far in 2017 include: $250K for Chet Waggoner Drive; $91K for Coal Line Trail; $370K for Four Winds Field Planning
Area Improvements; $342K for JMS Building; $140K LaSalle Building; $527K Nello; $226K Patel Hotel; $46K Southeast Master Plan.
City of South Bend, Indiana
Monthly Financial Report
May 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 6/15/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 751 6,200 5,962 - 9,800 39%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 436,000 751 6,200 5,962 - 429,800 1%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 3,284 - 2,805 10,372 479 0 100%
Debt Service - - - - - - 0%
Capital 1,425,008 - - - 515,250 909,758 36%
Transfers Out - - - - - - 0%
Total Expenditures 1,428,292 - 2,805 10,372 515,729 909,758 36%
Net (992,292) 751 3,395 (4,410) (515,729) (479,959)
Cash Balance 1,964,454 1,502,415
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
May 31, 2017
TIF - West Washington
Tax Increment Financing
Redevelopment Commission Controlled Funds
Form 3
112
Fund Name Fund Number 425
Fund Type Date Updated 6/15/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 64 532 656 - 1,174 31%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 195,308 8,698 52,158 54,174 - 143,150 27%
Transfers In - - - - - - 0%
Total Revenue 197,014 8,762 52,690 54,830 - 144,324 27%
Expenditures
Personnel - - - - - - 0%
Supplies 10,342 45 1,285 1,348 - 9,057 12%
Services 147,824 9,265 38,348 29,078 - 109,476 26%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 158,166 9,310 39,633 30,426 - 118,533 25%
Net 38,848 (548) 13,056 24,404 - 25,792
Cash Balance 199,867 233,220
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.
Revenue and expenditures are reported one month in arrears.
Operations under outside contract with Bradley Co.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
TIF - Leighton Plaza (Redevelop Retail)
Tax Increment Financing
Redevelopment Commission Controlled Funds
Form 3
113
Fund Name Fund Number 429
Fund Type Date Updated 6/15/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 2,100 - - 6,300 25%
Fines, Forfeitures, and Fees - - - - - - 0%
Interest Earnings 57,000 2,929 24,629 29,832 - 32,371 43%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 4,124 - 4,124 - - - 100%
Transfers In - - - - - - 0%
Total Revenue 3,069,524 3,279 30,853 29,832 - 3,038,671 1%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 316,219 30,560 146,248 30,950 129,760 40,211 87%
Debt Service - - - - - - 0%
Capital 10,286,477 15,124 660,696 102,846 2,004,793 7,620,988 26%
Transfers Out - - - - - - 0%
Total Expenditures 10,602,696 45,684 806,944 133,796 2,134,553 7,661,199 28%
Net (7,533,172) (42,405) (776,091) (103,964) (2,134,553) (4,622,528)
Cash Balance 7,099,558 7,457,168
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). Capital expenses thus far in
2017 include: $502K for East Bank CSO Phase V and $143K for Newman's Center/Armory project. Also, $115K for Howard Park Ice Rink design
services.
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
May 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 6/15/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 2,039 15,052 23,722 - 17,948 46%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 1,468,127 - 1,465,749 - - 2,378 100%
Total Revenue 3,901,127 2,039 1,480,802 23,722 - 2,420,325 38%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 160,268 33,427 49,117 174,571 40,532 70,619 56%
Debt Service - - - - - - 0%
Capital 6,757,158 67,212 252,407 545,457 541,578 5,963,173 12%
Transfers Out - - - - - - 0%
Total Expenditures 6,917,426 100,639 301,524 720,028 582,110 6,033,792 13%
Net (3,016,299) (98,600) 1,179,278 (696,306) (582,110) (3,613,467)
Cash Balance 5,801,165 5,399,073
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.
Capital project thus far in 2017 is final expenses for Chippewa Roundabout.
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
May 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 6/15/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,000 219 8,518 20,242 - 3,482 71%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 12,000 219 8,518 20,242 - 3,482 71%
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 - 904,519 - - 12,608 99%
Total Expenditures 4,878,795 - 4,866,186 365,835 - 12,609 100%
Net (4,866,795) 219 (4,857,668) (345,593) - (9,127)
Cash Balance 597 4,956,803
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
May 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 6/15/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 3 298 334 - 452 40%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 327,858 3 298 334 - 327,560 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) 3 (149,702) (139,666) (4,200) 137,544
Cash Balance 7,031 11,999
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
May 31, 2017
TIF - Douglas Road
Tax Increment Financing
Redevelopment Commission Controlled Funds
Form 3
117
Fund Name Fund Number 436
Fund Type Date Updated 6/15/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
May 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 6/15/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 3 27 35 - 108 20%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 135 3 27 35 - 108 20%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 4,500 316 1,133 - - 3,367 25%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 4,500 316 1,133 - - 3,367 25%
Net (4,365) (313) (1,106) 35 - (3,259)
Cash Balance 7,347 8,737
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
May 31, 2017
Redevelopment General
Redevelopment
Redevelopment Commission Controlled Funds
Form 3
119
Fund Name Fund Number 439
Fund Type Date Updated 6/15/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 825 6,867 8,996 - 43,133 14%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 50,000 825 6,867 8,996 - 43,133 14%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital 2,200,000 1,800,000 1,800,000 142,913 - 400,000 82%
Transfers Out - - - - - - 0%
Total Expenditures 2,200,000 1,800,000 1,800,000 142,913 - 400,000 82%
Net (2,150,000) (1,799,175) (1,793,133) (133,917) - (356,867)
Cash Balance 357,290 2,139,390
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
May 31, 2017
Certified Technology Park
Redevelopment
Redevelopment Commission Controlled Funds
Form 3
120
Fund Name Fund Number 454
Fund Type Date Updated 6/15/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 147 1,223 1,509 - 2,677 31%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 3,900 147 1,223 1,509 - 2,677 31%
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) 147 1,223 1,509 - (47,323)
Cash Balance 384,318 381,130
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. Staff working to develop appropriate program to use these funds. Significant
staff turnover in DCI has impeded progress. Unsure if funds will be used this year.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Airport Urban Enterprise Zone
Redevelopment
Redevelopment Commission Controlled Funds
Form 3
121
Fund Name Fund Number 754
Fund Type Date Updated 6/15/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 15,046 42,061 - - 132,939 24%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income 35,000 (94) 4,090 - - 30,910 12%
Transfers In - - - - - - 0%
Total Revenue 210,000 14,952 46,151 - - 163,849 22%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services 142,000 - 28,665 - - 113,335 20%
Debt Service 15,000 775 3,100 - - 11,900 21%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 157,000 775 31,765 - - 125,235 20%
Net 53,000 14,177 14,386 - - 38,614
Cash Balance 2,762,824 -
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.
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. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
Expenses include legal costs; staff contract costs; and professional services necessary to properly oversee operations and review new and
outstanding loans. Costs shown under debt service relate to Trustee fees charged by the Trustee bank.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Industrial Revolving Fund
Redevelopment
Redevelopment Commission Controlled Funds
Form 3
122
Fund Name Fund Number 315
Fund Type Date Updated 6/15/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 398 3,306 4,122 - 10,694 24%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 14,000 398 3,306 4,122 - 10,694 24%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 14,000 398 3,114 2,771 - 10,886 22%
Total Expenditures 14,000 398 3,114 2,771 - 10,886 22%
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
May 31, 2017
Redevelopment Bond - Airport Taxable
Debt Service
Redevelopment Commission Controlled Funds
Form 3
123
Fund Name Fund Number 317
Fund Type Date Updated 6/15/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 197 1,637 2,018 - 3,364 33%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 5,000 197 1,637 2,018 - 3,364 33%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures - - - - - - 0%
Net 5,000 197 1,637 2,018 - 3,364
Cash Balance 514,103 509,837
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
May 31, 2017
Coveleski Debt Service Reserve
Debt Service
Redevelopment Commission Controlled Funds
Form 3
124
Fund Name Fund Number 328
Fund Type Date Updated 6/15/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 664 5,538 6,887 - 9,462 37%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In - - - - - - 0%
Total Revenue 15,000 664 5,538 6,887 - 9,462 37%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service - - - - - - 0%
Capital - - - - - - 0%
Transfers Out 15,000 664 5,218 4,630 - 9,782 35%
Total Expenditures 15,000 664 5,218 4,630 - 9,782 35%
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
May 31, 2017
Redevelopment Bond - Palais Royale
Debt Service
Redevelopment Commission Controlled Funds
Form 3
125
Fund Name Fund Number 752
Fund Type Date Updated 6/15/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 226 1,053 - - 947 53%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 3,866,169 197,500 2,206,500 - - 1,659,669 57%
Total Revenue 3,868,169 197,726 2,207,553 - - 1,660,616 57%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 3,868,164 - 2,004,503 - - 1,863,661 52%
Capital - - - - - - 0%
Transfers Out 735,241 - 735,240 - - 1 100%
Total Expenditures 4,603,405 - 2,739,743 - - 1,863,662 60%
Net (735,236) 197,726 (532,191) - - (203,045)
Cash Balance 700,579 -
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.
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. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
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
May 31, 2017
South Bend Redevelopment Authority
Debt Service
Redevelopment Commission Controlled Funds
Form 3
126
Fund Name Fund Number 756
Fund Type Date Updated 6/15/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 218 857 - - 143 86%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 854,784 - - - - 854,784 0%
Total Revenue 855,784 218 857 - - 854,927 0%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 855,784 - 394,784 - - 461,000 46%
Capital - - - - - - 0%
Transfers Out - - - - - - 0%
Total Expenditures 855,784 - 394,784 - - 461,000 46%
Net - 218 (393,927) - - 393,927
Cash Balance 1,714,513 -
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.
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. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
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
May 31, 2017
Smart Streets Debt Service
Debt Service
Redevelopment Commission Controlled Funds
Form 3
127
Fund Name Fund Number 758
Fund Type Date Updated 6/15/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 115 - 114 - - 1 100%
Bond Proceeds - - - - - - 0%
Donations - - - - - - 0%
Other Income - - - - - - 0%
Transfers In 3,961,667 - 3,961,667 - - - 100%
Total Revenue 3,961,782 - 3,961,781 - - 1 100%
Expenditures
Personnel - - - - - - 0%
Supplies - - - - - - 0%
Services - - - - - - 0%
Debt Service 3,960,668 - 3,961,668 - - (1,000) 100%
Capital - - - - - - 0%
Transfers Out 561,250 - 561,230 - - 20 100%
Total Expenditures 4,521,918 - 4,522,898 - - (980) 100%
Net (560,136) - (561,117) - - 981
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.
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. No expenses show for prior year because the fund was not integrated into City's
books until 2017.
City of South Bend, Indiana
Monthly Financial Report
May 31, 2017
Erskine Village Debt Service
Debt Service
Redevelopment Commission Controlled Funds
Form 3
128