The URL can be used to link to this page

Home My WebLink About01-2016 Departmental Financial ReportPeriod Ending: Issued By: City of South Bend Monthly Departmental Financial Report Page Contents 2 Narrative 3 Summaries 7 General Fund 22 Special Revenue Funds 57 Debt Service/Capital Project Funds 69 Enterprise Funds 95 Internal Service Funds 102 Trust Funds 105 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff James Mueller South Bend Common Council Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Senior Budget Analyst Cecil Eastman Department Heads Fiscal Officers January 31, 2016 Administration/Finance January 2016 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 January 31, 2016, total revenue for the year was $17,266,475, 6% of estimated revenue. As of January 31, 2015 total revenue received was $12,866,555 within the same funds. The main differences were transfers between funds, and the receipt of Hotel/Motel tax in Jan 2016 that didn’t occur in 2015. Property taxes are received in June and January each year and were budgeted at $71,976,981 for 2016. Local income tax (LOIT, COIT and EDIT) receipts are budgeted to be $25.8 million in 2016, to be received in monthly installments of $2.15 million. As of January 31, 2016, total expenditures were $27,964,463 and outstanding encumbrances were $48,846,217, a total of $76,810,680 which represents 22% 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 8% of the amended expenditure budget at the end of the period. Total expenditures were $26,690,493 as of January 31, 2015. New for 2016, the 311 Call Center has now been placed in its own internal service fund, (Fund 279) and now appears as its own line item within the Internal Service sections of the summary reports. We hope that you find this Monthly Departmental Financial Report useful in better understanding the finances of the City of South Bend. If you have any questions regarding this report, please contact us at 574‐235‐7702. 2 City of South Bend Monthly Department Financial Report REVENUE SUMMARY January 31, 2016 Values Con 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 53,852,368 1,017,369 1,017,369 1,316,569 52,834,999 2% Special Revenue 102 Rainy Day 40,000 14,388 14,388 7,630 25,612 36% 103 Excess Levy 20 6 6 - 14 30% 201 Parks & Recreation 11,179,799 116,579 116,579 124,803 11,063,220 1% 202 Motor Vehicle Highway 9,181,883 1,148,770 1,148,770 716,020 8,033,113 13% 203 Recreation Nonreverting 1,448,565 59,146 59,146 65,607 1,389,419 4% 209 Studebaker-Oliver Reverting Grants 104,000 6,330 6,330 959 97,670 6% 210 Economic Development State Grants 73,511 18,038 18,038 290 55,473 25% 211 Department of Community Investment (DCI)2,647,925 527,096 527,096 14,699 2,120,829 20% 212 Dept of Community Investment Grants 3,800,000 279,099 279,099 99,143 3,520,901 7% 216 Police State Seizures 36,000 12,241 12,241 163 23,759 34% 217 Gift, Donation, Bequest 185,800 107 107 1,618 185,693 0% 218 Police Curfew Violations 1,000 33 33 11 967 3% 219 Unsafe Building 985,240 360,372 360,372 - 624,868 37% 220 Law Enforcement Continuing Education 218,000 30,704 30,704 24,858 187,296 14% 227 Loss Recovery 1,410 1,648 1,648 5,206 (238) 117% 244 Emergency Phone System- --19 - 0% 249 Public Safety LOIT 6,797,160 567,011 567,011 540,008 6,230,149 8% 251 Local Roads & Streets 1,269,000 305,371 305,371 87,782 963,629 24% 258 Human Rights Federal Grant 165,040 121,580 121,580 2,065 43,460 74% 271 Eastrace Waterway 30 2 2 5 28 7% 273 Morris PAC / Palais Royale Marketing 18,150 400 400 274 17,750 2% 280 Police Block Grants- 6 6 3 (6) 0% 281 Economic Develop. Commission-Revenue Bonds 150 45 45 24 105 30% 289 HAZMAT 10,000 53 53 3,732 9,947 1% 291 Indiana River Rescue 45,200 5,554 5,554 3,093 39,647 12% 292 Police Grants- --55 - 0% 294 Regional Police Academy 22,500 8,566 8,566 11,010 13,934 38% 295 COPS MORE Grant 92,000 1,091 1,091 564 90,909 1% 299 Police Federal Drug Enforcement 162,000 94 94 1,816 161,906 0% 404 County Option Income Tax 10,332,984 998,628 998,628 793,050 9,334,356 10% 408 Economic Development Income Tax 10,159,262 965,781 965,781 924,052 9,193,481 10% 410 Urban Development Action Grant 169,827 1,139 1,139 24 168,688 1% 655 Project Releaf 437,290 38,110 38,110 37,371 399,180 9% 705 Police K-9 Unit 2,020 6 6 503 2,014 0% Special Revenue Total 59,585,766 5,587,996 5,587,996 3,466,459 53,997,770 9% City Debt Service 313 Football Hall of Fame Debt Service 1,383,212 9,343 9,343 4,298 1,373,869 1% City Debt Service Total 1,383,212 9,343 9,343 4,298 1,373,869 1% Capital Project 377 Professional Sports Development 709,718 173,741 173,741 93,375 535,977 24% 401 Coveleski Stadium Capital 15,200 137 137 36 15,063 1% 403 Zoo Endowment 200 82 82 43 118 41% 405 Park Nonreverting Capital 162,500 925 925 4,435 161,575 1% 406 Cumulative Capital Development 526,737 5,335 5,335 4,847 521,402 1% 407 Cumulative Capital Improvement 435,700 150,502 150,502 215 285,198 35% 412 Major Moves Construction 1,048,178 3,574 3,574 3,344 1,044,604 0% 416 Morris Performing Arts Center Capital 102,000 5,931 5,931 8,323 96,069 6% 434 Community Revitalization Enhancement District- 45 45 28 (45) 0% 450 Palais Royale Historic Preservation 17,300 126 126 1,281 17,174 1% 677 Football Hall of Fame Capital 2,000 833 833 495 1,167 42% Capital Project Total 3,019,533 341,231 341,231 116,422 2,678,302 11% Enterprise 287 Emergency Medical Services Capital 2,075,500 4,258 4,258 - 2,071,242 0% 288 Emergency Medical Services Operating 5,085,012 476,961 476,961 204,337 4,608,051 9% 600 Consolidated Building Fund 3,517,968 670,296 670,296 88,442 2,847,672 19% 601 Parking Garages 1,052,226 88,124 88,124 83,033 964,102 8% 610 Solid Waste Operations 5,596,749 405,999 405,999 408,178 5,190,750 7% 611 Solid Waste Capital 925,397 251,011 251,011 190,033 674,386 27% 620 Water W orks Operations 14,604,116 1,079,352 1,079,352 1,065,650 13,524,764 7% 622 Water Works Capital 15,000 4,768 4,768 2,776 10,232 32% 623 Water W orks Bond Capital- --180 - 0% 624 Water Works Customer Deposit 8,400 2,502 2,502 1,307 5,898 30% 625 Water W orks Sinking 2,049,681 171,062 171,062 468 1,878,619 8% 626 Water W orks Bond Reserve 9,500 2,662 2,662 1,425 6,838 28% 629 Water Works Reserve Operations & Maintenance 175,166 3,696 3,696 1,840 171,470 2% 640 Sewer Repair Insurance 564,725 54,828 54,828 51,853 509,897 10% 641 Sewage Works Operations 36,711,600 2,973,480 2,973,480 2,786,029 33,738,120 8% 642 Sewage Works Capital 2,532,000 14,620 14,620 3,385 2,517,380 1% 643 Sewage Works Reserve Operations & Maint.552,997 6,083 6,083 3,020 546,914 1% 3 City of South Bend Monthly Department Financial Report REVENUE SUMMARY January 31, 2016 Values Con Fund Type Dept Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget Balance Percent of Budget 649 Sewage Sinking 9,274,391 762,499 762,499 774,321 8,511,893 8% 653 Sewage Debt Service Reserve- 25 25 - (25) 0% 659 Sewer Bond 2011 2,000 384 384 1,477 1,616 19% 661 Sewer Bond 2012 25,000 23,078 23,078 14,968 1,922 92% 664 2013A Cost of Issuance Fund- 7 7 4 (7) 0% 666 2015 Sewer Bond Issuance- 76 76 - (76) 0% 670 Century Center 3,983,787 790,173 790,173 32,985 3,193,614 20% 671 Century Center Capital 500 85 85 24 415 17% 672 Century Center Energy Conservation Debt Svc 237,132 4 4 - 237,128 0% Enterprise Total 88,998,847 7,786,033 7,786,033 5,715,736 81,212,814 9% Internal Service 222 Central Services 8,234,637 561,404 561,404 655,888 7,673,233 7% 224 Central Services Capital 130,519 313 313 - 130,206 0% 226 Liability Insurance 2,253,983 190,814 190,814 104,344 2,063,169 8% 278 Take Home Vehicle Police 64,400 9,999 9,999 14,575 54,401 16% 279 311 Call Center 499,358 38,778 38,778 - 460,580 8% 711 Self-Funded Employee Benefits 17,174,845 1,388,795 1,388,795 1,248,718 15,786,050 8% 713 Unemployment Compensation 107,282 445 445 8,685 106,837 0% Internal Service Total 28,465,024 2,190,549 2,190,549 2,032,210 26,274,475 8% Trust & Agency 701 Firefighters Pension 5,447,592 929 929 688 5,446,663 0% 702 Police Pension 6,133,500 2,088 2,088 1,133 6,131,412 0% 730 City Cemetery 150 47 47 25 103 31% Trust & Agency Total 11,581,242 3,065 3,065 1,846 11,578,177 0% City Funds Total 246,885,992 16,935,585 16,935,585 12,653,539 229,950,407 7% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River W est Development Area (Airport TIF)18,885,314 62,565 62,565 50,350 18,822,749 0% 420 Tax Incremental Financing (TIF) - Downtown- --695 - 0% 422 TIF - West Washington 424,000 2,477 2,477 996 421,523 1% 425 Redevelopment Retail & Leighton Plaza 172,003 11,420 11,420 18,229 160,583 7% 426 TIF - Central Medical Service Area- --1,941 - 0% 429 River East Development Area (NE Dev TIF)2,757,000 12,505 12,505 23,215 2,744,495 0% 430 TIF - Southside Development #1 2,410,000 9,942 9,942 4,144 2,400,058 0% 435 TIF - Douglas Road 320,750 234 234 161 320,516 0% 436 River East Residential (NE Res TIF)3,162,422 213,108 213,108 1,215 2,949,314 7% Tax Increment Financing Total 28,131,489 312,250 312,250 100,945 27,819,239 1% Redevelopment 433 Redevelopment General 152 14 14 9 138 9% 439 Certified Technology Park 14,637 3,792 3,792 4,432 10,845 26% 454 Airport Urban Enterprise Zone 1,500 628 628 333 872 42% 619 Blackthorn Operations- --99,156 - 0% Redevelopment Total 16,289 4,435 4,435 103,930 11,854 27% 315 Redevelopment Bond - Airport Taxable 5,000 1,718 1,718 917 3,282 34% 317 Coveleski Debt Service Reserve 1,800 841 841 446 959 47% 328 Redevelopment Bond - Palais Royale 6,000 2,870 2,870 1,532 3,130 48% 432 TIF - Southside Development #3 25,000 8,776 8,776 5,246 16,224 35% Debt Service Total 37,800 14,205 14,205 8,140 23,595 38% Redevelopment Commission Controlled Funds Total 28,185,578 330,890 330,890 213,015 27,854,688 1% Grand Total 275,071,570 17,266,475 17,266,475 12,866,555 257,805,095 6% 4 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY January 31, 2016 Co ntr ol 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 749,883 62,117 62,117 80,464 841 686,925 8% 101-0104 311 Call Center 5,933 - - 55,195 5,933 - 100% 101-0201 City Clerk 443,475 31,055 31,055 34,775 12,962 399,458 10% 101-0301 Common Council 522,735 41,543 41,543 33,803 20,397 460,795 12% 101-0302 WNIT Contract 43,000 - - - - 43,000 0% 101-0401 Administration & Finance 2,227,488 130,914 130,914 187,531 34,726 2,061,848 7% 101-0404 Morris Performing Arts Center 1,129,897 75,543 75,543 96,838 72,424 981,930 13% 101-0405 Palais Royale 498,438 36,586 36,586 41,912 75,449 386,403 22% 101-0501 Legal Department 1,036,772 75,713 75,713 99,178 19,141 941,918 9% 101-0602 Engineering 1,225,137 60,668 60,668 72,931 117,842 1,046,627 15% 101-0801 Police Department 26,399,474 1,839,872 1,839,872 2,557,412 100,765 24,458,837 7% 101-0802 Communications Center 1,479,012 - - 135,031 - 1,479,012 0% 101-0901 Fire Department 18,185,989 1,349,693 1,349,693 2,150,469 342,996 16,493,300 9% 101-0905 Fire LOIT 2013- - - 411 - - 0% 101-1008 Human Rights 371,226 27,794 27,794 50,323 9,101 334,330 10% 101-1201 Code 2013 202,164 202,164 202,164 - - (0) 100% 101-0805 Police LOIT 2013- - - 2,562 - - 0% General Fund Total 54,520,623 3,933,663 3,933,663 5,598,835 812,577 49,774,383 9% Special Revenue 103 Excess Levy 3,688 - - - - 3,688 0% 201 Parks & Recreation 11,248,697 707,523 707,523 1,205,926 432,486 10,108,688 10% 202 Motor Vehicle Highway 10,977,409 774,386 774,386 847,279 584,601 9,618,422 12% 203 Recreation Nonreverting 1,459,754 34,956 34,956 43,898 85,155 1,339,643 8% 209 Studebaker-Oliver Reverting Grants 1,683,250 4,500 4,500 - 478,751 1,200,000 29% 210 Economic Development State Grants 1,935,497 858,470 858,470 12,200 1,007,353 69,674 96% 211 Department of Community Investment (DCI)2,687,313 193,791 193,791 250,396 51,758 2,441,765 9% 212 Dept of Community Investment Grants 7,356,963 219,263 219,263 106,821 3,343,859 3,793,841 48% 216 Police State Seizures 36,000 - - - - 36,000 0% 217 Gift, Donation, Bequest 362,500 - - - - 362,500 0% 218 Police Curfew Violations 1,000 - - - - 1,000 0% 219 Unsafe Building 0 0 0 0 138,860-138,860 0% 220 Law Enforcement Continuing Education 743,508 16,882 16,882 15,730 9,600 717,026 4% 227 Loss Recovery 480,311 8 8 181,590 130,303 350,000 27% 244 Emergency Phone System- - - 20 - - 0% 249 Public Safety LOIT 6,600,626 521,395 521,395 732,055 - 6,079,231 8% 251 Local Roads & Streets 2,242,944 76,979 76,979 4,155 944,402 1,221,563 46% 258 Human Rights Federal Grant 221,838 12,916 12,916 22,061 20,134 188,788 15% 273 Morris PAC / Palais Royale Marketing 18,878 - - - 878 18,001 5% 289 HAZMAT 10,000 - - 20,939 - 10,000 0% 291 Indiana River Rescue 95,300 1,200 1,200 0 - 94,100 1% 292 Police Grants 55,373 6,713 6,713 - 48,660 - 100% 294 Regional Police Academy 22,500 251 251 2,724 - 22,249 1% 295 COPS MORE Grant 102,245 707 707 20,490 10,245 91,293 11% 299 Police Federal Drug Enforcement 168,965 - - 18,385 6,964 162,001 4% 404 County Option Income Tax 15,162,148 2,195,646 2,195,646 1,322,195 2,312,115 10,654,387 30% 408 Economic Development Income Tax 10,560,181 2,192,756 2,192,756 577,062 708,871 7,658,554 27% 410 Urban Development Action Grant 238,173 146,068 146,068 - - 92,106 61% 655 Project Releaf 528,358 14,595 14,595 15,357 - 513,763 3% 705 Police K-9 Unit 2,020 - - - - 2,020 0% Special Revenue Total 75,005,439 7,979,004 7,979,004 5,399,282 10,314,992 56,711,443 24% City Debt Service 313 Football Hall of Fame Debt Service 1,268,015 636,000 636,000 636,000 - 632,015 50% City Debt Service Total 1,268,015 636,000 636,000 636,000 - 632,015 50% Capital Project 377 Professional Sports Development 838,052 472,288 472,288 480,773 - 365,765 56% 405 Park Nonreverting Capital 200,333 - - - 14,634 185,699 7% 406 Cumulative Capital Development 526,737 112,650 112,650 112,650 - 414,087 21% 407 Cumulative Capital Improvement 365,907 184,125 184,125 183,750 - 181,782 50% 412 Major Moves Construction 2,385,033 110 110 55,859 879,031 1,505,892 37% 416 Morris Performing Arts Center Capital 78,923 - - 1,268 18,010 60,913 23% 434 Community Revitalization Enhancement District- - - 3,897 - - 0% 677 Football Hall of Fame Capital 84,801 4,658 4,658 6,843 288 79,855 6% Capital Project Total 4,479,786 773,831 773,831 845,040 911,963 2,793,992 38% Enterprise 287 Emergency Medical Services Capital 2,247,611 - - - 363,611 1,884,000 16% 288 Emergency Medical Services Operating 6,115,643 582,267 582,267 247,977 122,543 5,410,833 12% 600 Consolidated Building Fund 4,450,974 303,175 303,175 282,377 286,774 3,861,025 13% 601 Parking Garages 1,393,469 111,714 111,714 89,030 210,428 1,071,326 23% 610 Solid Waste Operations 5,597,412 658,357 658,357 635,488 325,941 4,613,114 18% 611 Solid Waste Capital 925,197 250,879 250,879 223,749 - 674,318 27% 620 Water Works Operations 16,984,657 1,055,844 1,055,844 940,625 680,510 15,248,303 10% 5 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY January 31, 2016 Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Current Encumbrances Budget Balance Percent of Budget Co ntr Fund ol Type Department Name 622 Water Works Capital 821,797 - - 15,382 177,797 644,000 22% 623 Water Works Bond Capital- - - 11,278 - - 0% 624 Water Works Customer Deposit 8,400 534 534 452 - 7,866 6% 625 Water Works Sinking 2,049,681 551 551 465 - 2,049,130 0% 626 Water Works Bond Reserve 9,500 - - - - 9,500 0% 629 Water Works Reserve Operations & Maintenance 10,000 790 790 637 - 9,210 8% 640 Sewer Repair Insurance 549,413 32,598 32,598 21,449 28,751 488,063 11% 641 Sewage Works Operations 39,736,144 2,541,858 2,541,858 2,564,371 2,250,115 34,944,171 12% 642 Sewage Works Capital 7,631,946 635,043 635,043 39,115 3,915,653 3,081,250 60% 643 Sewage Works Reserve Operations & Maint.16,000 1,301 1,301 1,045 - 14,699 8% 649 Sewage Sinking 9,274,298 1,350 1,350 1,000 - 9,272,948 0% 659 Sewer Bond 2011 172,088 - - 143,037 172,088 - 100% 661 Sewer Bond 2012 20,187,062 118,335 118,335 39,170 10,068,728 9,999,999 50% 666 2015 Sewer Bond Issuance 0 2,500 2,500 0 0-2,500 0% 670 Century Center 3,972,438 329,357 329,357 306,497 - 3,643,081 8% 672 Century Center Energy Conservation Debt Svc 237,132 - - - - 237,132 0% Enterprise Total 122,390,862 6,626,453 6,626,453 5,563,143 18,602,939 97,161,469 21% Internal Service 222 Central Services 8,289,479 544,400 544,400 679,565 3,293,695 4,451,383 46% 224 Central Services Capital 305,584 - - - 175,065 130,519 57% 226 Liability Insurance 3,120,348 97,441 97,441 262,238 90,656 2,932,251 6% 278 Take Home Vehicle Police 10,000 53 53 - - 9,947 1% 279 311 Call Center 499,357 38,778 38,778 0 0 460,579 8% 711 Self-Funded Employee Benefits 17,378,890 634,312 634,312 1,030,771 302,717 16,441,861 5% 713 Unemployment Compensation 113,882 1,487 1,487 10,126 6,600 105,795 7% Internal Service Total 29,717,540 1,316,472 1,316,472 1,982,700 3,868,734 24,532,335 17% Trust & Agency 701 Firefighters Pension 5,582,720 427,167 427,167 441,192 - 5,155,553 8% 702 Police Pension 7,008,182 516,452 516,452 537,112 - 6,491,730 7% 730 City Cemetery 20,000 - - - - 20,000 0% Trust & Agency Total 12,610,902 943,618 943,618 978,304 - 11,667,284 7% City Funds Total 299,993,167 22,209,041 22,209,041 21,003,304 34,511,205 243,272,921 19% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF)31,502,077 4,064,434 4,064,434 2,276,439 10,603,697 16,833,946 47% 420 Tax Incremental Financing (TIF) - Downtown- - - 964,016 - - 0% 422 TIF - West Washington 1,403,366 - - - 303,366 1,100,000 22% 425 Redevelopment Retail & Leighton Plaza 160,406 4,481 4,481 6,962 - 155,925 3% 429 River East Development Area (NE Dev TIF)8,335,159 81,910 81,910 112,956 1,969,302 6,283,947 25% 430 TIF - Southside Development #1 7,411,815 280 280 435,370 1,311,534 6,100,001 18% 435 TIF - Douglas Road 354,200 - - - 4,200 350,000 1% 436 River East Residential (NE Res TIF)3,430,000 1,237,500 1,237,500 1,464,000 - 2,192,500 36% Tax Increment Financing Total 52,597,023 5,388,606 5,388,606 5,259,743 14,192,099 33,016,318 37% Redevelopment 433 Redevelopment General 4,500 - - - - 4,500 0% 439 Certified Technology Park 2,692,913 - - - 142,913 2,550,000 5% 454 Airport Urban Enterprise Zone 50,000 - - - - 50,000 0% 619 Blackthorn Operations- - - 69,055 - - 0% Redevelopment Total 2,747,413 - - 69,055 142,913 2,604,500 5% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 367 367 317 - 4,633 7% 328 Redevelopment Bond - Palais Royale 6,000 614 614 530 - 5,386 10% 432 TIF - Southside Development #3 490,503 365,835 365,835 357,545 - 124,668 75% Debt Service Total 501,503 366,816 366,816 358,392 - 134,687 73% Redevelopment Commission Controlled Funds Total 55,845,939 5,755,422 5,755,422 5,687,190 14,335,012 35,755,506 36% Grand Total 355,839,106 27,964,463 27,964,463 26,690,493 48,846,217 279,028,426 22% 6 Fund/Department Name Month January Fund/Department Number 101-0101 Date Updated 2/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 749,283 61,957 61,957 80,429 - 687,326 8% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - 35 - - 0% Other Income 600 160 160 - - 440 27% Transfers In- - - - - - 0% Total Revenue 749,883 62,117 62,117 80,464 - 687,766 8% Personnel 685,492 51,210 51,210 69,962 - 634,282 7% Supplies 3,662 52 52 754 662 2,948 19% Services 60,139 10,855 10,855 9,747 179 49,104 18% Debt Service 590 - - - - 590 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 749,883 62,117 62,117 80,464 841 686,925 8% Net- - - - (841) 841 Cash Balance- - Full Time 7.00 7.00 7.00 Part-Time /Seasonal/Temporary 2.00 1.00 1.00 Total 9.00 8.00 8.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Mayor's Office There are no capital projects budgeted for 2015. Expenditures Revenue Total Expenditures Staffing Expenditures are in line with budgeted expectations for 2016. Last year at this time, three payrolls occurred in January. As a result, personnel services were higher last year. Form 3 7 Fund/Department Name Month January Fund/Department Number 101-0104 Date Updated 2/18/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 5,933 - - 0 - 5,933 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 55,195 - - 0% Transfers In- - - - - - 0% Total Revenue 5,933 - - 55,195 - 5,933 0% Personnel- - - 46,324 - - 0% Supplies 2,350 - - 647 2,350 - 100% Services 3,583 - - 8,225 3,583 - 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 5,933 - - 55,195 5,933 - 100% Net- - - - (5,933) 5,933 Cash Balance- - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report 311 Call Center No capital expenditures budgeted in 2015. Expenditures Revenue Total Expenditures Staffing As of January 1, 2016, the 311 Call Center is now in its own internal service fund, Fund 279. The only budgeted items are remaining encumbrances from 2015 purchase orders that haven't been invoiced by the vendors yet. Form 3 8 Fund/Department Name Month January Fund/Department Number 101-0201 Date Updated 2/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 443,475 31,055 31,055 34,775 - 412,420 7% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 443,475 31,055 31,055 34,775 - 412,420 7% Personnel 332,855 30,476 30,476 33,216 - 302,379 9% Supplies 7,582 69 69 24 782 6,732 11% Services 103,038 510 510 1,535 12,180 90,348 12% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 443,475 31,055 31,055 34,775 12,962 399,458 10% Net- - - - (12,962) 12,962 Cash Balance- - Full Time 5.00 5.00 5.00 Part-Time /Seasonal/Temporary- - - Total 5.00 5.00 5.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report City Clerk This year, no capital projects have been budgeted. Expenditures Revenue Total Expenditures Staffing Expenditures are consistent with normal operating costs. Form 3 9 Fund/Department Name Month January Fund/Department Number 101-0301 Date Updated 2/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 522,485 41,543 41,543 33,763 - 480,942 8% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations 250 - - 41 - 250 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 522,735 41,543 41,543 33,803 - 481,192 8% Personnel 279,671 21,039 21,039 22,601 352 258,281 8% Supplies 8,936 163 163 34 4,847 3,926 56% Services 234,128 20,342 20,342 11,169 15,198 198,588 15% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 522,735 41,543 41,543 33,803 20,397 460,795 12% Net- - - - (20,397) 20,397 Cash Balance- - Full Time 9.00 9.00 9.00 Part-Time /Seasonal/Temporary- - - Total 9.00 9.00 9.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Common Council Expenditures Revenue Total Expenditures Staffing There are nine (9) Council Members. Form 3 10 Fund/Department Name Month January Fund/Department Number 101-0302 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 43,000 - - - - 43,000 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 43,000 - - - - 43,000 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 43,000 - - - - 43,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 43,000 - - - - 43,000 0% Net- - - - - - Cash Balance- - Full Time- - Part-Time /Seasonal/Temporary- - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report WNIT Contract Expenditures Revenue Total Expenditures Staffing This annual expenditure was previously paid from the Council department (101-0301) but was segregated upon the Council's request in 2014. The invoice will arrive in April. Form 3 11 Fund/Department Name Month January Fund/Department Number 101-0401 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 2,217,438 117,366 117,366 187,531 - 2,100,072 5% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 10,050 13,548 13,548 - - (3,498) 135% Transfers In- - - - - - 0% Total Revenue 2,227,488 130,914 130,914 187,531 - 2,096,574 6% Personnel 1,978,924 124,587 124,587 181,926 - 1,854,337 6% Supplies 42,034 717 717 1,482 5,736 35,581 15% Services 201,358 4,968 4,968 3,480 28,990 167,401 17% Debt Service 5,172 643 643 643 - 4,529 12% Capital- - - - - - 0% Transfers Out- - - - - - 0% 2,227,488 130,914 130,914 187,531 34,726 2,061,848 7% Net- - - - (34,726) 34,726 Cash Balance- - Full Time 22.00 23.00 Part-Time /Seasonal/Temporary- 1.00 Total 22.00 24.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Administration & Finance None Expenditures Revenue Total Expenditures Staffing Transferred Chief Technology Officer to COIT for 2015 budget and added new HR Generalist position. Overall spending appears consistent with expectations. Full time excludes 3 IT/Innovation employees who are paid from COIT. Encumbrances relate to an outstanding contract for diversity consulting which will take place in 2016. Form 3 12 Fund/Department Name Month January Fund/Department Number 101-0404 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 179,897 43,926 43,926 43,509 - 135,971 24% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 943,000 31,617 31,617 52,311 - 911,383 3% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 7,000 - - 1,018 - 7,000 0% Transfers In- - - - - - 0% Total Revenue 1,129,897 75,543 75,543 96,838 - 1,054,354 7% Personnel 823,612 55,763 55,763 76,732 384 767,465 7% Supplies 22,698 686 686 1,234 10,122 11,890 48% Services 283,587 19,094 19,094 18,872 61,918 202,575 29% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,129,897 75,543 75,543 96,838 72,424 981,930 13% Net- - - - (72,424) 72,424 Cash Balance- - Full Time 12.00 12.00 Part-Time /Seasonal/Temporary 4.00 4.00 Total 16.00 16.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Total Expenditures Staffing There are no Capital Expenses budgeted for this year. This is an Operating Budget. By Ordinance, Fund 416 is used to support renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons at the Morris Performing Arts Center. There are no Capital Expenses / Projects budgeted this year. 2016 City of South Bend Monthly Financial Report Morris Performing Arts Center Revenue Expenditures Form 3 13 Fund/Department Name Month January Fund/Department Number 101-0405 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 174,426 29,824 29,824 17,544 - 69,154 17% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 301,572 6,522 6,522 22,832 - 295,050 2% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 22,440 240 240 1,536 - 22,200 1% Transfers In- - - - - - 0% Total Revenue 498,438 36,586 36,586 41,912 - 386,403 7% Personnel 244,557 20,412 20,412 25,862 256 223,889 8% Supplies 28,855 564 564 290 10,166 18,125 37% Services 225,026 15,610 15,610 15,759 65,027 144,389 36% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 498,438 36,586 36,586 41,912 75,449 386,403 22% Net- - - - (75,449) - Cash Balance- - Full Time 2.00 3.00 3.00 Part-Time /Seasonal/Temporary 1.00 - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Palais Royale No Capital expenditures budgeted for 2016. Expenditures Revenue Total Expenditures Staffing One Part-Time / Seasonal / Temporary position was eliminated and a full time employee was added (needed for the day to day operations). Form 3 14 Fund/Department Name Month January Fund/Department Number 101-0501 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 986,772 75,713 75,713 99,178 - 911,059 8% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 50,000 - - - - 50,000 0% Transfers In- - - - - - 0% Total Revenue 1,036,772 75,713 75,713 99,178 - 961,059 7% Personnel 984,630 73,059 73,059 97,996 - 911,571 7% Supplies 3,712 247 247 154 15 3,450 7% Services 47,158 2,406 2,406 1,028 19,126 25,626 46% Debt Service 1,272 - - - - 1,272 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,036,772 75,713 75,713 99,178 19,141 941,918 9% Net- - - - (19,141) 19,141 Cash Balance- - Full Time 11.60 11.60 Part-Time /Seasonal/Temporary- - Total 11.60 11.60 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Legal Department Expenditures Revenue Total Expenditures Staffing The Other Income of $50,000 is reimbursement for legal expenses from TIF funds which was received in November 2015. Spending appears to be on track with budgeted figures. Form 3 15 Fund/Department Name Month January Fund/Department Number 101-0602 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 1,090,688 28,545 28,545 72,931 - 1,062,143 3% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 134,449 32,123 32,123 - - 102,326 24% Transfers In- - - - - - 0% Total Revenue 1,225,137 60,668 60,668 72,931 - 1,164,469 5% Personnel 776,239 51,144 51,144 58,231 - 725,095 7% Supplies 66,447 449 449 2,008 28,513 37,485 44% Services 358,063 5,646 5,646 10,137 86,738 265,679 26% Debt Service 24,388 3,428 3,428 2,554 2,592 18,368 25% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,225,137 60,668 60,668 72,931 117,842 1,046,627 15% Net- - - - (117,842) 117,842 Cash Balance- - Full Time 7.93 8.35 Part-Time /Seasonal/Temporary 1.41 1.41 Total 9.34 9.76 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Engineering Expenditures Revenue Total Expenditures Staffing $28K in encumbrance for Supplies is for the continued remodeling of the Engineering offices. $86K in encumbrance for Services include $70K for updating the City construction standards and $16K for office remodeling. Other income includes reimbursement from the River West TIF for 80% of the salary of an engineer. The overage in Full-Time Staffing is due to incorrect position allocations that were corrected in February. Form 3 16 Fund/Department Name Month January Fund/Department Number 101-0801 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 26,061,774 1,798,244 1,798,244 2,550,808 - 24,263,530 7% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations 7,500 - - - - 7,500 0% Other Income 330,200 41,628 41,628 6,604 - 288,572 13% Transfers In- - - - - - 0% Total Revenue 26,399,474 1,839,872 1,839,872 2,557,412 - 24,559,602 7% Personnel 23,573,968 1,700,318 1,700,318 2,389,856 - 21,873,650 7% Supplies 346,456 7,609 7,609 38,316 75,557 263,290 24% Services 2,471,050 131,286 131,286 128,664 25,209 2,314,555 6% Debt Service 8,000 659 659 577 - 7,342 8% Capital- - - - - - 0% Transfers Out- - - - - - 0% 26,399,474 1,839,872 1,839,872 2,557,412 100,765 24,458,837 7% Net- - - - (100,765) 100,765 Cash Balance- - Full Time 268.00 255.00 255.00 Part-Time /Seasonal/Temporary 60.00 25.00 25.00 Total 328.00 280.00 280.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Department Expenditures Revenue Total Expenditures Staffing This fund includes the expenditures for 222 of the 260 budgeted Police officers and 46 full time civilian staff. Fund 249 contains the funding for 38 of the 260 Police officers that are funded by the LOIT. The 2015 Personnel Expenditures are less the prior year amount due to the the fact that there were three payrolls paid in January 2014 compared to two in January 2015. This decrease was offset by increases in Police salaries and transfer of five officer's salaries from the LOIT to the General Fund. Form 3 17 Fund/Department Name Month January Fund/Department Number 101-0802 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 1,479,012 - - 135,031 - 1,479,012 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,479,012 - - 135,031 - 1,479,012 0% Personnel- - - 135,031 - - 0% Supplies- - - - - - 0% Services 1,479,012 - - - - 1,479,012 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,479,012 - - 135,031 - 1,479,012 0% Net- - - - - - Cash Balance- - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Communications Center Expenditures Revenue Total Expenditures Staffing Prior to December 31, 2014, this fund captured the cost of 35 of the 38 civilians and equipment to maintain the 911 communication center. Effective January 1, 2015 the County PSAP has consolidated the 911 call centers and SBPD no longer maintains a call center. The 2015 Personnel costs are the 2014 salary costs for the Communications staff paid in 2015. There are no additional salaries to be paid. The Services budget is the annual amount that the County will charge SBPD as a participant in using the PSAP. Form 3 18 Fund/Department Name Month January Fund/Department Number 101-0901 Date Updated 2/15/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 18,173,989 1,349,011 1,349,011 2,140,448 16,824,978 7% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 6,000 682 682 10,022 - 5,318 11% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 6,000 - - - 6,000 0% Transfers In- - - - - - 0% Total Revenue 18,185,989 1,349,693 1,349,693 2,150,469 - 16,836,296 7% Personnel 16,320,838 1,234,093 1,234,093 2,045,419 123,410 14,963,335 8% Supplies 387,643 9,902 9,902 13,409 90,691 287,051 26% Services 1,477,508 105,698 105,698 91,641 128,895 1,242,915 16% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 18,185,989 1,349,693 1,349,693 2,150,469 342,996 16,493,300 9% Net- - - - (342,996) 342,996 Cash Balance- - Full Time 181.00 181.00 Part-Time /Seasonal/Temporary- - Total 181.00 181.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Fire Department The Fire Department uses EMS Operating Fund 288 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through EMS Capital Fund 287. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Expenditures Revenue Total Expenditures Staffing The South Bend Fire Department is budgeted to have 251 sworn firefighters and 7 civilian full time employees. 32 firefighters are paid directly through the Public Safety LOIT. 47 Sworn Employee's and 4 civilian employee's costs are allocated to Fund 288 EMS Operations. We hold a lengthy recruitment process every 2 years and hire individuals in groups of 6-10 as needed while that list is in effect. We also employ civilian administrative staff that handle payroll, purchasing and billing for our ambulance service. Form 3 19 Fund/Department Name Month January Fund/Department Number 101-1008 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 371,226 27,794 27,794 50,323 - 343,432 7% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 371,226 27,794 27,794 50,323 - 343,432 7% Personnel 298,643 22,387 22,387 34,772 - 276,256 7% Supplies 1,546 206 206 95 500 840 46% Services 71,037 5,201 5,201 5,214 8,601 57,235 19% Debt Service- - - - - - 0% Capital- - - 10,242 - - 0% Transfers Out- - - - - - 0% 371,226 27,794 27,794 50,323 9,101 334,330 10% Net- - - - (9,101) 9,101 Cash Balance- - Full Time 4.00 4.00 4.00 Part-Time /Seasonal/Temporary- - - Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Human Rights Expenditures Revenue Total Expenditures Staffing Expenditures are consistent with normal operating costs. Form 3 20 Fund/Department Name Month January Fund/Department Number 101-1201 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 202,164 202,164 202,164 - - (0) 100% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 202,164 202,164 202,164 - - (0) 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 202,164 202,164 202,164 - - (0) 100% 202,164 202,164 202,164 - - (0) 100% Net- - - - - - Cash Balance- - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Code Enforcement Expenditures Revenue Total Expenditures Staffing This department is being used solely to track the General Fund transfer to the Unsafe Building fund (219). Form 3 21 Fund/Department Name Month January Fund/Department Number 102 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 40,000 14,388 14,388 7,630 - 25,612 36% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 40,000 14,388 14,388 7,630 - 25,612 36% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 40,000 14,388 14,388 7,630 - 25,612 Cash Balance 8,706,495 8,649,818 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Rainy Day N/A Expenditures Revenue Total Expenditures Staffing No significant changes at this time. No expenditures are budgeted in this fund. The establishment of a Rainy Day Fund is looked upon favorably by bond rating agencies and is one of the factors resulting in South Bend's good AA bond rating with Standard & Poor's. Form 3 22 Fund/Department Name Month January Fund/Department Number 103 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 20 6 6 - - 14 30% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 20 6 6 - - 14 30% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 3,688 - - - - 3,688 0% 3,688 - - - - 3,688 0% Net(3,668) 6 6 - - (3,674) Cash Balance 3,671 3,648 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Excess Levy N/A Expenditures Revenue Total Expenditures Staffing A small excess of property tax was received in December 2014. The balance will be rolled into the General Fund in 2016. Form 3 23 Fund/Department Name Month January Fund/Department Number 201 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 7,487,000 - - 7,487,000 0% Local Income Taxes- - - - - - 0% Other Taxes 1,581,265 77,189 77,189 73,736 - 1,504,076 5% Grants/Intergovernmental- - - - - - 0% Charges for Services 1,946,740 23,508 23,508 28,344 - 1,923,232 1% Interest Earnings 10,000 9,635 9,635 2,724 - 365 96% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 154,794 6,247 6,247 19,999 - 148,547 4% Transfers In- - - - - - 0% Total Revenue 11,179,799 116,579 116,579 124,803 - 11,063,220 1% Personnel 7,222,560 520,039 520,039 645,103 5,000 6,697,521 7% Supplies 1,139,754 20,203 20,203 27,953 376,260 743,291 35% Services 2,574,261 149,395 149,395 532,871 51,226 2,373,640 8% Debt Service 176,622 17,886 17,886 - 158,736 10% Capital 50,000 - - - 50,000 0% Transfers Out 85,500 - - - 85,500 0% 11,248,697 707,523 707,523 1,205,926 432,486 10,108,688 10% Net(68,898) (590,943) (590,944) (1,081,123) (432,486) 954,532 Cash Balance 3,325,823 2,416,907 Full Time 90.00 86.00 86.00 Part-Time /Seasonal/Temporary na 79.00 79.00 Total 90.00 165.00 165.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Parks & Recreation Because of decreasing property tax revenues, there is nominal capital budget in fund 201. A $5.6 million bond has been approved and funding was received in the second quarter of 2015 and will largely be spent throughout 2016. Expenditures Revenue Total Expenditures Staffing Fund 201 accounts for the annual operation of the Parks and Recreation Department. There are six divisions within the department: Administration, Maintenance, Golf, Recreation, Greenhouse, and Graffiti. In 2014 the Potawatomi Zoo began operation by the Potawatomi Zoological Society. Part time staffing is individuals, not FTEs. Property tax and other tax revenues are received in June and December of the year. NOTE: Variance in actuals for January 2016 versus January 2015 is due largely because Potawatomi Zoological Society payment for 2016 has not yet benn paid, whereas, last year paymnet was made in January. Form 3 24 Fund/Department Name Month January Fund/Department Number 202 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 5,100,000 279,365 279,365 682,077 4,820,635 5% Grants/Intergovernmental- - 0% Charges for Services 366,433 20,745 20,745 28,724 345,688 6% Interest Earnings 9,100 8,827 8,827 3,484 273 97% Bond Proceeds- - 0% Donations- - 0% Other Income 3,350 1,583 1,583 1,735 1,767 47% Transfers In 3,703,000 838,250 838,250 2,864,750 23% Total Revenue 9,181,883 1,148,770 1,148,770 716,020 - 8,033,113 13% Personnel 4,411,058 324,838 324,838 471,784 4,086,220 7% Supplies 2,628,660 135,130 135,130 92,303 393,480 2,100,050 20% Services 3,170,906 193,645 193,645 247,554 191,121 2,786,140 12% Debt Service 677,327 81,314 81,314 35,637 596,013 12% Capital 89,458 39,458 39,458 50,000 44% Transfers Out- - 0% 10,977,409 774,386 774,386 847,279 584,601 9,618,422 12% Net(1,795,526) 374,384 374,384 (131,258) (584,601) (1,585,309) Cash Balance 5,529,836 3,776,744 Full Time 52.91 48.96 Part-Time /Seasonal/Temporary 2.22 2.22 Total 55.13 51.18 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Motor Vehicle Highway Expenditures Revenue Total Expenditures Staffing Information included for Streets, Traffic & Lighting, and Curb & Sidewalk. Form 3 25 Fund/Department Name Month January Fund/Department Number 203 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 1,432,565 57,754 57,754 62,146 - 1,374,811 4% Interest Earnings 6,000 1,365 1,365 717 - 4,635 23% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 10,000 26 26 2,743 - 9,974 0% Transfers In- - - - - - 0% Total Revenue 1,448,565 59,146 59,146 65,607 - 1,389,419 4% Personnel 655,619 24,756 24,756 33,751 - 630,863 4% Supplies 307,068 1,612 1,612 4,152 48,820 256,636 16% Services 497,067 8,588 8,588 5,994 36,335 452,144 9% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - 0% 1,459,754 34,956 34,956 43,898 85,155 1,339,643 8% Net(11,189) 24,190 24,190 21,709 (85,155) 49,776 Cash Balance 845,897 835,622 Full Time 1.00 1.00 1.00 Part-Time /Seasonal/Temporary-32.00 32.00 Total 1.00 33.00 33.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Recreation Nonreverting Expenditures Revenue Total Expenditures Staffing This fund accounts for Parks and Recreation programs and events that are self funded through user fees. Registration for spring program, classes and softball leagues began in February.Part time employees are individuals, not FTEs. Form 3 26 Fund/Department Name Month January Fund/Department Number 209 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- 4,500 4,500 - - (4,500) 0% Charges for Services- - - - - - 0% Interest Earnings 4,000 1,831 1,831 959 - 2,169 46% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 100,000 - - - - 100,000 0% Transfers In- - - - - - 0% Total Revenue 104,000 6,330 6,330 959 - 97,670 6% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,683,250 4,500 4,500 - 478,751 1,200,000 29% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,683,250 4,500 4,500 - 478,751 1,200,000 29% Net(1,579,250) 1,831 1,831 959 (478,751) (1,102,330) Cash Balance 1,109,032 1,087,424 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Studebaker-Oliver Reverting Grants Expenditures Revenue Total Expenditures Staffing Brownfield Assessment Grant awarded by EPA for use in South Bend , Mishawaka and St. Joseph County covers the outstanding encumbrance. Consultant work proceeding. Form 3 27 Fund/Department Name Month January Fund/Department Number 210 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 11,725 2,878 2,878 290 - 8,847 25% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 61,786 15,160 15,160 - - 46,626 25% Transfers In- - - - - - 0% Total Revenue 73,511 18,038 18,038 290 - 55,473 25% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 663,486 - - 12,200 665,823 (2,337) 100% Debt Service 72,011 - - - - 72,011 0% Capital 1,200,000 858,470 858,470 - 341,530 - 100% Transfers Out- - - - - - 0% 1,935,497 858,470 858,470 12,200 1,007,353 69,674 96% Net(1,861,986) (840,432) (840,432) (11,910) (1,007,353) (14,201) Cash Balance(680,076) 317,523 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Economic Development State Grants Capital expenditures shown here are for the ND Turbo Project. Expenditures Revenue Total Expenditures Staffing We received a grant from the State for BEP for the Vacant & Abondoned Initiative $1,600,000 of this grant remains. An additional $2,000,000 state grant has been awarded for the ND Turbo Project. We must spend money and then seek reimbursement from the State. Reimbursement requests have been submitted. Form 3 28 Fund/Department Name Month January Fund/Department Number 211 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 249,000 33,285 33,285 13,183 - 215,715 13% Grants/Intergovernmental 419,287 - - - - 419,287 0% Charges for Services 2,000 - - 95 - 2,000 0% Interest Earnings 10,000 1,901 1,901 1,421 - 8,099 19% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 1,967,638 491,910 491,910 - - 1,475,729 25% Total Revenue 2,647,925 527,096 527,096 14,699 - 2,120,829 20% Personnel 2,161,561 160,625 160,625 212,652 - 2,000,936 7% Supplies 25,318 506 506 2,089 6,241 18,571 27% Services 463,434 32,660 32,660 35,655 45,516 385,258 17% Debt Service- - - - - - 0% Capital 37,000 - - - - 37,000 0% Transfers Out- - - - - - 0% 2,687,313 193,791 193,791 250,396 51,758 2,441,765 9% Net(39,388) 333,305 333,305 (235,697) (51,758) (320,936) Cash Balance 1,455,597 838,521 Full Time 25.00 22.00 22.00 Part-Time /Seasonal/Temporary- - - Total 25.00 22.00 22.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Department of Community Investment (DCI) Expenditures Revenue Total Expenditures Staffing Fund covers operations of the Department of Community Investment. Transfers In come from EDIT on a quarterly basis. In December, Three positions currently unfilled. One will be filled by end of February--still working on filling the remaining two. Form 3 29 Fund/Department Name Month January Fund/Department Number 212 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 3,028,252 277,736 277,736 - - 2,750,516 9% Charges for Services 1,000 - - 40 - 1,000 0% Interest Earnings 2,000 721 721 104 - 1,279 36% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 768,748 642 642 98,999 - 768,106 0% Transfers In- - - - - - 0% Total Revenue 3,800,000 279,099 279,099 99,143 - 3,520,901 7% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Grants 7,356,963 219,263 219,263 106,821 3,343,859 3,793,841 48% Transfers Out- - - - - - 0% 7,356,963 219,263 219,263 106,821 3,343,859 3,793,841 48% Net(3,556,963) 59,836 59,836 (7,678) (3,343,859) (272,940) Cash Balance 612,675 784,037 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Dept of Community Investment Grants Expenditures Revenue Total Expenditures Staffing This fund covers multiple federal grants. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on-going and the timing of funding varies widely. 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. Form 3 30 Fund/Department Name Month January Fund/Department Number 216 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 35,000 11,910 11,910 - - 23,090 34% Charges for Services- - - - - - 0% Interest Earnings 1,000 331 331 163 - 669 33% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - 0% Total Revenue 36,000 12,241 12,241 163 - 23,759 34% Personnel- - - - - - 0% Supplies- 0% Services 36,000 - - 36,000 0% Debt Service- - - - - 0% Capital- - - - - - 0% Transfers Out- 0% 36,000 - - - - 36,000 0% Net- 12,241 12,241 163 - (12,241) Cash Balance 211,979 187,594 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police State Seizures Expenditures Revenue Total Expenditures Staffing 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. Form 3 31 Fund/Department Name Month January Fund/Department Number 217 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 800 107 107 122 - 693 13% Bond Proceeds- - - - - - 0% Donations 185,000 - - 1,497 - 185,000 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 185,800 107 107 1,618 - 185,693 0% Personnel- - - - - - 0% Supplies 12,500 - - - - 12,500 0% Services 350,000 - - - - 350,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 362,500 - - - - 362,500 0% Net(176,700) 107 107 1,618 - (176,807) Cash Balance 64,981 139,557 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Gift, Donation, Bequest None Expenditures Revenue Total Expenditures Staffing $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. Form 3 32 Fund/Department Name Month January Fund/Department Number 218 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 900 13 13 - - 887 1% Interest Earnings 100 20 20 11 - 80 20% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,000 33 33 11 - 967 3% Personnel- - - - - - 0% Supplies- - - - - 0% Services 1,000 - - - - 1,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,000 - - - - 1,000 0% Net- 33 33 11 - (33) Cash Balance 12,271 12,016 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Curfew Violations Expenditures Revenue Total Expenditures Staffing This fund was established to collect curfew and prostitution fines. Expenditures are used for Police activities and training. Form 3 33 Fund/Department Name Month January Fund/Department Number 219 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- 0% Local Income Taxes- 0% Other Taxes- 0% Grants/Intergovernmental- 0% Charges for Services 230,000 19,939 19,939 - 210,061 9% Interest Earnings- 0% Bond Proceeds- 0% Donations- 0% Other Income- 0% Transfers In 755,240 340,433 340,433 - 414,807 45% Total Revenue 985,240 360,372 360,372 - - 624,868 37% Personnel- 0% Supplies- 0% Services- - - 138,860 (138,860) 0% Debt Service- 0% Capital- 0% Transfers Out- 0% - - - - 138,860 (138,860) 0% Net 985,240 360,372 360,372 - (138,860) 763,728 Cash Balance 360,372 - Full Time- Part-Time /Seasonal/Temporary- - Total- - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Unsafe Building Expenditures Revenue Total Expenditures Staffing Unsafe Building fund is a new fund established in 2016 to receive fines and fees related to the Unsafe building law to defray the costs and expenses incurred in board ups and other services related to the unsafe buildings law. This is a non-reverting fund. Budget expenditures will be approriated at March 2016 budget transfer. Neat Group(600-1209) will bill Unsafe building fund for their expenditures incurred for the first quarter in April 2016. Form 3 34 Fund/Department Name Month January Fund/Department Number 220 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 200,000 29,003 29,003 21,306 - 170,997 15% Interest Earnings 5,000 1,506 1,506 849 - 3,494 30% Bond Proceeds- - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income 11,000 195 195 2,703 - 10,805 2% Transfers In- - - .- - 0% Total Revenue 218,000 30,704 30,704 24,858 - 187,296 14% Personnel- - - - - - 0% Supplies 285,508 408 408 - 9,600 275,500 4% Services 458,000 16,474 16,474 15,730 - 441,526 4% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 743,508 16,882 16,882 15,730 9,600 717,026 4% Net(525,508) 13,822 13,822 9,128 (9,600) (529,730) Cash Balance 904,089 970,410 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Law Enforcement Continuing Education Expenditures Revenue Total Expenditures Staffing 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. Form 3 35 Fund/Department Name Month January Fund/Department Number 227 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,410 1,648 1,648 5,206 - (238) 117% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,410 1,648 1,648 5,206 - (238) 117% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 422,302 8 8 147,040 72,294 350,000 17% Debt Service- - - - - - 0% Capital 58,009 - - 34,550 58,009 - 100% Transfers Out- - - - - - 0% 480,311 8 8 181,590 130,303 350,000 27% Net(478,901) 1,640 1,640 (176,383) (130,303) (350,238) Cash Balance 994,889 5,687,510 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Loss Recovery The capital encumbrances are for the Lincolnway West Corridors project, carried over from 2015. Expenditures Revenue Total Expenditures Staffing Services include $350,000 budgeted for Ignition Park land remediation and $70,000 for vacant & abandoned housing. Form 3 36 Fund/Department Name Month January Fund/Department Number 244 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 19 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 19 - - 0% Personnel- - - 20 - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 20 - - 0% Net- - - (1) - - Cash Balance 33,671 33,651 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Emergency Phone System Expenditures Revenue Total Expenditures Staffing This fund was closed in 2015 with the advent of the county-wide PSAP system. The cash balance will probably remain throughout 2016. Form 3 37 Fund/Department Name Month January Fund/Department Number 249 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes 6,791,160 565,930 565,930 538,849 - 6,225,230 8% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 6,000 1,081 1,081 1,159 - 4,919 18% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 6,797,160 567,011 567,011 540,008 - 6,230,149 8% Personnel 6,600,626 521,395 521,395 732,055 - 6,079,231 8% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,600,626 521,395 521,395 732,055 - 6,079,231 8% Net 196,534 45,616 45,616 (192,047) - 150,918 Cash Balance 687,551 1,101,185 Full Time 80.00 Part-Time /Seasonal/Temporary- - Total 80.00 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Public Safety LOIT None. No capital equipment is purchased from this fund. Expenditures Revenue Total Expenditures Staffing This fund covered the costs of salaries and fringes for 38 police officers and 32 firefighters in 2016. Form 3 38 Fund/Department Name Month January Fund/Department Number 251 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 1,068,000 85,510 85,510 85,628 - 982,490 8% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 9,000 4,502 4,502 2,155 - 4,498 50% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 192,000 215,358 215,358 - - (23,358) 112% Transfers In- - - - - - 0% Total Revenue 1,269,000 305,371 305,371 87,782 - 963,629 24% Personnel- - - - - - 0% Supplies 469,668 - - - 19,668 450,000 4% Services 412,369 64,617 64,617 - 164,189 183,564 55% Debt Service- - - - - - 0% Capital 1,360,907 12,363 12,363 4,155 760,545 587,999 57% Transfers Out- - - - - - 0% 2,242,944 76,979 76,979 4,155 944,402 1,221,563 46% Net(973,944) 228,392 228,392 83,628 (944,402) (257,934) Cash Balance 2,955,766 2,528,075 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Local Roads & Streets Projects in 2016 include the Safe Routes to School initiative for Coquillard and Harrison schools, Bendix Drive, and the Boland bicycle trail. The $760K in encumbrance includes $158K for Bendix Dr. (Lathrop to Toll Road), $148K for the Boland Trail, $240K for Safe Routes to School (Coquillard, Harrison, Perley and Lincoln schools) and $200K for Olive St. at Sample design. Expenditures Revenue Total Expenditures Staffing This fund receives most of its revenue through the gas tax, budgeted at $1.068 million for 2016. 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 but $469,668 is used for material for street repairs and other maintenance items. The encumbrance for $20K in Supplies is for paving material for the Streets Department. The encumbrance for $164K in Services includes $17K for emergency riverbank stabilization at Northshore Drive, $133K for traffic signal upgrades placed at various intersections around the City and $13K for updates to the City construction standards. Form 3 39 Fund/Department Name Month January Fund/Department Number 252 Date Updated 2/12/2026 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 0 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 0 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- - - 0 - - Cash Balance 8 8 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Excess Welfare Distribution Expenditures Revenue Total Expenditures Staffing In 2009, the City received a one-time $2.9 million distribution for this fund. In 2012, the City spent approximately $2.1 million for portable radios for both the Police and Fire departments. Money in this fund may only be used for public safety purposes. This fund will be closed out in 2016. Form 3 40 Fund/Department Name Month January Fund/Department Number 258 Date Updated 2/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 145,000 121,000 121,000 1,667 - 24,000 83% Charges for Services- - - - - - 0% Interest Earnings 2,000 580 580 398 - 1,420 29% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 18,040 - - - - 18,040 0% Transfers In- - - - - - 0% Total Revenue 165,040 121,580 121,580 2,065 - 43,460 74% Personnel 122,817 9,321 9,321 8,568 - 113,496 8% Supplies 2,300 - - - 1,800 500 78% Services 96,721 3,595 3,595 13,494 18,334 74,792 23% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 221,838 12,916 12,916 22,061 20,134 188,788 15% Net(56,798) 108,664 108,664 (19,997) (20,134) (145,328) Cash Balance 534,060 510,256 Full Time 2.00 2.00 2.00 Part-Time /Seasonal/Temporary 2.00 2.00 2.00 Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Human Rights Federal Grant No capital projects have been budgeted for this year. Expenditures Revenue Total Expenditures Staffing The Human Rights Federal Grant Fund contains separate departments for EEOC and HUD grants. The Human Rights mission is to educate and promote fair housing as well as ensure that all citizens receive equal employment opportunity. Revenues higher at this time versus last year due to timing of receipt for grants. Form 3 41 Fund/Department Name Month January Fund/Department Number 271 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 30 2 2 5 - 28 7% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 30 2 2 5 - 28 7% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 30 2 2 5 - 28 Cash Balance 1,337 5,317 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Eastrace Waterway Expenditures Revenue Total Expenditures Staffing 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. Form 3 42 Fund/Department Name Month January Fund/Department Number 273 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 18,000 350 350 250 - 17,650 2% Interest Earnings 150 50 50 24 - 100 33% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 18,150 400 400 274 - 17,750 2% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 18,878 - - - 878 18,001 5% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 18,878 - - - 878 18,001 5% Net(728) 400 400 274 (878) (251) Cash Balance 30,752 26,987 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Morris PAC / Palais Royale Marketing No Capital spending in this fund Expenditures Revenue Total Expenditures Staffing The Morris Performing Arts Center and Palais Royale Marketing Fund was established as a separate non-reverting fund to receive monies from solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marqee sponsorships; and to accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale. The funds in this account at the end of the fiscal year shall not revert to the general fund. Form 3 43 Fund/Department Name Month January Fund/Department Number 280 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 6 6 3 - (6) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 6 6 3 - (6) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- 6 6 3 - (6) Cash Balance 3,857 3,831 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Block Grants Expenditures Revenue Total Expenditures Staffing Justice Assistance Grant 2009-SB-B9-1280 was essentially completed in 2014. Form 3 44 Fund/Department Name Month January Fund/Department Number 281 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 150 45 45 24 - 105 30% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 150 45 45 24 - 105 30% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 150 45 45 24 - 105 Cash Balance 27,407 27,229 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Economic Develop. Commission-Revenue Bonds Expenditures Revenue Total Expenditures Staffing Fund to be used only for the expenses of EDC revenue bonds. These bonds have been paid off. Fund to be closed during 2016. Form 3 45 Fund/Department Name Month January Fund/Department Number 289 Date Updated 2/15/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 10,000 - - 3,697 - 10,000 0% Interest Earnings- 53 53 35 - (53) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 10,000 53 53 3,732 - 9,947 1% Personnel- - - - - - 0% Supplies 10,000 - - 20,939 - 10,000 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 10,000 - - 20,939 - 10,000 0% Net- 53 53 (17,207) - (53) Cash Balance 32,116 22,422 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report HAZMAT 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. Expenditures Revenue Total Expenditures Staffing Charges for Service for HAZ-MAT responses. By ordinance the South Bend Fire Department charges businesses for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund, responses are made by firefighters of the South Bend Fire Department. Form 3 46 Fund/Department Name Month January Fund/Department Number 291 Date Updated 2/15/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 45,000 5,400 5,400 3,000 - 39,600 12% Interest Earnings 200 154 154 93 - 47 77% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 45,200 5,554 5,554 3,093 - 39,647 12% Personnel 15,500 231 231 - - 15,269 1% Supplies 10,800 794 794 0 - 10,006 7% Services 69,000 175 175 0 - 68,825 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 95,300 1,200 1,200 0 - 94,100 1% Net(50,100) 4,354 4,354 3,093 - (54,454) Cash Balance 99,799 108,492 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Indiana River Rescue Expenditures Revenue Total Expenditures Staffing No staffing associated with this fund. The fund collects tuition fees for students attending the Indiana River Rescue School. There are typically 2-4 schools a year, each a week in duration. Expenditures are for the maintenance and repair of rescue equipment. Form 3 47 Fund/Department Name Month January Fund/Department Number 292 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 55 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 55 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 55,373 6,713 6,713 - 48,660 - 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 55,373 6,713 6,713 - 48,660 - 100% Net(55,373) (6,713) (6,713) 55 (48,660) - Cash Balance 114,483 95,464 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Grants Expenditures Revenue Total Expenditures Staffing This Fund was set up to track the revenue and expenditures related to specific Federal Grants. Expenditures have been outlined in the grant. Form 3 48 Fund/Department Name Month January Fund/Department Number 294 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 20,000 8,450 8,450 10,950 - 11,550 42% Interest Earnings 500 116 116 60 - 384 23% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In- - - - - - 0% Total Revenue 22,500 8,566 8,566 11,010 - 13,934 38% Personnel- - - - - - 0% Supplies 1,500 - - - - 1,500 0% Services 21,000 251 251 2,724 - 20,749 1% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 22,500 251 251 2,724 - 22,249 1% Net- 8,315 8,315 8,286 - (8,315) Cash Balance 78,534 76,568 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Regional Police Academy Expenditures Revenue Total Expenditures Staffing 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. Form 3 49 Fund/Department Name Month January Fund/Department Number 295 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 53,750 - - - - 53,750 0% Charges for Services- - - - - - 0% Interest Earnings 500 201 201 94 - 299 40% Bond Proceeds- - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 34,500 890 890 470 - 33,610 3% Transfers In- - - - - - 0% Total Revenue 92,000 1,091 1,091 564 - 90,909 1% Personnel- - - - - - 0% Supplies 57,245 - - 20,490 10,245 47,000 18% Services 45,000 707 707 - - 44,293 2% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 102,245 707 707 20,490 10,245 91,293 11% Net(10,245) 384 384 (19,926) (10,245) (384) Cash Balance 121,941 86,307 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report COPS MORE Grant Expenditures Revenue Total Expenditures Staffing 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. Form 3 50 Fund/Department Name Month January Fund/Department Number 299 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 160,000 - - 1,728 - 160,000 0% Charges for Services- - - - - - 0% Interest Earnings 1,000 94 94 88 - 906 9% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,000 - - - - 1,000 0% Transfers In- - - - - - 0% Total Revenue 162,000 94 94 1,816 - 161,906 0% Personnel- - - - - - 0% Supplies 61,965 - - 9,759 6,964 55,001 11% Services 62,000 - - 8,626 - 62,000 0% Debt Service- - - - - - 0% Capital 45,000 - - - - 45,000 0% Transfers Out- - - - - - 0% 168,965 - - 18,385 6,964 162,001 4% Net(6,965) 94 94 (16,569) (6,964) (95) Cash Balance 252,845 328,974 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Federal Drug Enforcement Expenditures Revenue Total Expenditures Staffing 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. Form 3 51 Fund/Department Name Month January Fund/Department Number 404 Date Updated 2/15/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes 9,454,023 787,835 787,835 738,326 - 8,666,188 8% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 95,000 20,005 20,005 13,383 - 74,995 21% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 783,961 190,788 190,788 41,340 - 593,173 24% Transfers In- - - - - - 0% Total Revenue 10,332,984 998,628 998,628 793,050 - 9,334,356 10% Personnel 419,439 27,406 27,406 25,517 - 392,033 7% Supplies 1,595,825 50,038 50,038 47,944 126,313 1,419,475 11% Services 8,478,544 612,450 612,450 470,044 1,929,615 5,936,479 30% Debt Service 2,588,970 1,121,569 1,121,569 753,365 - 1,467,401 43% Capital 579,370 9,183 9,183 25,325 256,187 314,000 46% Transfers Out 1,500,000 375,000 375,000 - - 1,125,000 25% 15,162,148 2,195,646 2,195,646 1,322,195 2,312,115 10,654,387 30% Net(4,829,164) (1,197,018) (1,197,018) (529,145) (2,312,115) (1,320,031) Cash Balance 10,887,917 14,432,231 Full Time 4.00 3.00 3.00 Part-Time /Seasonal/Temporary- - - Total 4.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report County Option Income Tax This year, $39,000 has been budgeted for IT laserfische replacement. Other budgeted capital projects include facade grants of $200,000, bus shelters of $180,000, and the LWW Ambassador program for $150,000. An encumbered amount of $134,141 remaining was carried forward this year to pay Transpo for the City's portion of the new CNG fueling station. Expenditures Revenue Total Expenditures Staffing Overall decrease in spending in 2016 over 2015 due to the end of the Vacant & Abandoned Housing Program in 2015. This decreased expenditures by approximately $2.0 million. Also, 2015 includeded equipment expenses of approximately $900,000 which is not required in the 2016 budget. Other income in 2016 includes $238,172 in loan repayments from the UDAG Fund 410 for the 1st Source/Marriott loan based on BDC collections as well as charges to City departments for computer services. The curb and sidewalk program remains at the 2015 level of $1,500,000. Form 3 52 Fund/Department Name Month January Fund/Department Number 408 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes 9,594,602 799,550 799,550 765,101 - 8,795,052 8% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 504,660 150,000 150,000 150,000 - 354,660 30% Interest Earnings 60,000 16,231 16,231 8,869 - 43,769 27% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 82 - - 0% Transfers In- - - - - - 0% Total Revenue 10,159,262 965,781 965,781 924,052 - 9,193,481 10% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 2,604,237 68,195 68,195 135,294 708,871 1,827,172 30% Debt Service 1,274,662 503,616 503,616 438,568 - 771,046 40% Capital 197,500 - - 3,200 - 197,500 0% Transfers Out 6,483,782 1,620,946 1,620,946 - - 4,862,837 25% 10,560,181 2,192,756 2,192,756 577,062 708,871 7,658,554 27% Net(400,919) (1,226,974) (1,226,974) 346,990 (708,871) 1,534,926 Cash Balance 8,647,070 10,517,215 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Economic Development Income Tax $197,500 has been budgeted for land acquisitions. Expenditures Revenue Total Expenditures Staffing In 2015, Code Enforcement personnel expense is fully paid out of Fund 600, therefore, no additional expenses will be incurred in 2015 related to Code in this fund. Transfers out relate to: Community Investment ($1,967,638), Streets ($1,853,000), Code Enforcement ($2,033,776) and Animal Care & Control ($629,368). Services include DTSB management costs, Chamber grants, and others. Form 3 53 Fund/Department Name Month January Fund/Department Number 410 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 110 1,139 1,139 24 - (1,029) 1036% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 169,717 - - - - 169,717 0% Transfers In- - - - - - 0% Total Revenue 169,827 1,139 1,139 24 - 168,688 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 238,173 146,068 146,068 - - 92,106 61% Capital- - - - - - 0% Transfers Out- - - - - - 0% 238,173 146,068 146,068 - - 92,106 61% Net(68,346) (144,928) (144,928) 24 - 76,582 Cash Balance 485,472 27,690 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Urban Development Action Grant Expenditures Revenue Total Expenditures Staffing This budget usually includes payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. New payments from the BDC were received in 2015 and are expected in 2016. Form 3 54 Fund/Department Name Month January Fund/Department Number 655 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 433,290 36,589 36,589 36,473 396,701 8% Interest Earnings 4,000 1,521 1,521 899 2,479 38% Bond Proceeds- - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 437,290 38,110 38,110 37,371 - 399,180 9% Personnel 56,649 1,403 56,649 0% Supplies 3,145 3,145 0% Services 46,344 2,976 2,976 2,335 43,368 6% Debt Service 72,220 11,619 11,619 11,619 60,601 16% Capital- 0% Transfers Out 350,000 350,000 0% 528,358 14,595 14,595 15,357 - 513,763 3% Net(91,068) 23,515 23,515 22,015 - (114,583) Cash Balance 943,886 1,000,807 Full Time- - Part-Time /Seasonal/Temporary 2.60 - Total 2.60 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Project Releaf Expenditures Revenue Total Expenditures Staffing Fall ReLeaf scheduled for October 2016. Form 3 55 Fund/Department Name Month January Fund/Department Number 705 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 20 6 6 3 - 14 30% Bond Proceeds- - - - - - 0% Donations 2,000 - - 500 - 2,000 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,020 6 6 503 - 2,014 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 2,020 - - - - 2,020 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 2,020 - - - - 2,020 0% Net- 6 6 503 - (6) Cash Balance 3,875 3,822 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police K-9 Unit Expenditures Revenue Total Expenditures Staffing This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds. Form 3 56 Fund/Department Name Month January Fund/Department Number 313 Date Updated 2/18/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 1,200,000 - - - - 1,200,000 0% Local Income Taxes- - - - - - 0% Other Taxes 183,112 9,343 9,343 4,256 - 173,769 5% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 100 0 0 41 - 100 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,383,212 9,343 9,343 4,298 - 1,373,869 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 1,268,015 636,000 636,000 636,000 - 632,015 50% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,268,015 636,000 636,000 636,000 - 632,015 50% Net 115,197 (626,657) (626,657) (631,702) - 741,854 Cash Balance(615,261) (557,580) Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Football Hall of Fame Debt Service None Expenditures Revenue Total Expenditures Staffing This fund is used to collect a separate property tax levy (distributions received in June and December) and is used to pay debt service on the former College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will typically have a negative cash balance until the property tax distributions are received. PILOT taxes paid by the utilities are received monthly in this fund. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. On 15 April 2015 the Mayor announced a possible sale of the Hall of Fame to a private company. If the sale proceeds as planned, this fund will receive $240,000 per year for the next 5 years that will be used to offset debt service costs. Form 3 57 Fund/Department Name Month January Fund/Department Number 377 Date Updated 2/18/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 660,000 149,007 149,007 63,326 - 510,993 23% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,455 707 707 526 - 748 49% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 48,263 24,026 24,026 29,523 - 24,237 50% Transfers In- - - - - - 0% Total Revenue 709,718 173,741 173,741 93,375 - 535,977 24% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 838,052 472,288 472,288 480,773 - 365,765 56% Capital- - - - - - 0% Transfers Out- - - - - - 0% 838,052 472,288 472,288 480,773 - 365,765 56% Net(128,334) (298,547) (298,547) (387,398) - 170,213 Cash Balance 128,828 208,695 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Professional Sports Development Expenditures Revenue Total Expenditures Staffing Effective January 1, 2013, this fund no longer collects hotel/motel tax allocations from St. Joseph County for payment to the Hall of Fame. This fund is currenty used for debt. PSDA tax revenue is generally received from the State on a monthly basis. PSDA tax is a special tax received from the State of Indiana based on the sales tax, income tax and local income taxes collected in the PSDA area (which includes Four Winds Field, Century Center, Morris Performing Arts Center and Studebaker National Museum). Four Winds Field generates the majority of PSDA revenue. The January debt service payment has been made for 2016. The final debt service payment on the 2010 Coveleski Stadium bonds (Four Winds Field) will be paid January 15, 2019. Form 3 58 Fund/Department Name Month January Fund/Department Number 401 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 15,000 - - - - 15,000 0% Interest Earnings 200 137 137 36 - 63 68% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 15,200 137 137 36 - 15,063 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 15,200 137 137 36 - 15,063 Cash Balance 82,691 40,486 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Coveleski Stadium Capital Expenditures Revenue Total Expenditures Staffing Fund 401 accounts for capital spending on Coveleski Stadium. Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. Form 3 59 Fund/Department Name Month January Fund/Department Number 403 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 200 82 82 43 - 119 41% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 200 82 82 43 - 119 41% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 200 82 82 43 - 119 Cash Balance 49,527 49,205 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Zoo Endowment Expenditures Revenue Total Expenditures Staffing This fund was established to account for donations dedicated to Potawatomi Zoo. In the past few years several endowments that were funding this fund were liquidated resulting in a drop in revenues to this fund. Form 3 60 Fund/Department Name Month January Fund/Department Number 405 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 34,000 169 169 3 - 33,831 0% Interest Earnings 4,000 756 756 432 - 3,244 19% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 24,000 - - 4,000 - 24,000 0% Transfers In 100,500 - - - - 100,500 0% Total Revenue 162,500 925 925 4,435 - 161,575 1% Personnel- - - - - - 0% Supplies 58,173 - - - 3,474 54,699 6% Services 11,160 - - - 11,160 - 100% Debt Service- - - - - - 0% Capital 131,000 - - - - 131,000 0% Transfers Out- - - - - - 0% 200,333 - - - 14,634 185,699 7% Net(37,833) 925 925 4,435 (14,634) (24,124) Cash Balance 470,648 525,599 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Park Nonreverting Capital This fund is for expending nonreverting revenue collected from the Zoo, golf courses, East Race Waterway, picnic sites and forestry revenue. Expenditures Revenue Total Expenditures Staffing This is a nonreverting capital fund that accounts for revenues collected and expenses for specific purposes or locations. These locations are Potawatomi and Rum Village Picnic Areas, the East Race, Golf Courses, Forestry, Howard Park Ice Rink, and, until 2014, Potawatomi Zoo. The cash balance includes $60,300 that is restricted to expenditures in Voorde Park. Form 3 61 Fund/Department Name Month January Fund/Department Number 406 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 433,000 - - - - 433,000 0% Local Income Taxes- - - - - - 0% Other Taxes 90,737 4,420 4,420 4,349 - 86,317 5% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 3,000 915 915 498 - 2,085 31% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 526,737 5,335 5,335 4,847 - 521,402 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 526,737 112,650 112,650 112,650 - 414,087 21% Capital- - - - - - 0% Transfers Out- - - - - - 0% 526,737 112,650 112,650 112,650 - 414,087 21% Net- (107,315) (107,315) (107,803) - 107,315 Cash Balance 464,645 473,447 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Cumulative Capital Development Expenditures Revenue Total Expenditures Staffing This fund receives revenue from a property tax levy and distributions are received from St. Joseph County in June and December. Expenditures are for debt service payments on capital leases and the due dates vary per lease. The fund is used to finance police vehicles and related equipment. The fund also receives PILOT payments from the Water Works and Wastewater utilities on a monthly basis. Form 3 62 Fund/Department Name Month January Fund/Department Number 407 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 410,000 150,000 150,000 - - 260,000 37% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 700 502 502 215 - 198 72% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In- - - - - - 0% Total Revenue 435,700 150,502 150,502 215 - 285,198 35% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 365,907 184,125 184,125 183,750 - 181,782 50% Capital- - - - - - 0% Transfers Out- - - - - - 0% 365,907 184,125 184,125 183,750 - 181,782 50% Net 69,793 (33,623) (33,623) (183,535) - 103,416 Cash Balance 277,609 65,948 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Cumulative Capital Improvement None Expenditures Revenue Total Expenditures Staffing Revenue in this fund includes $150,000 in hotel/motel taxes and $247,000 in cigarette taxes from other units of government. The hotel/motel tax distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December. In 2015, this fund is used to pay 75% of the 2011 Century Center Refunding bonds as it was in 2014. Payments on the Century Center bond are due in February and July. Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year. Form 3 63 Fund/Department Name Month January Fund/Department Number 412 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 25,000 3,574 3,574 3,344 - 21,426 14% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,023,178 - - - - 1,023,178 0% Transfers In- - - - - - 0% Total Revenue 1,048,178 3,574 3,574 3,344 - 1,044,604 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 750,000 - - - - 750,000 0% Debt Service- - - - - - 0% Capital 1,635,033 110 110 55,859 879,031 755,892 54% Transfers Out- - - - - - 0% 2,385,033 110 110 55,859 879,031 1,505,892 37% Net(1,336,855) 3,464 3,464 (52,515) (879,031) (461,288) Cash Balance 2,160,452 3,589,147 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Major Moves Construction 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 $879K encumbered comprises $420K for the downtown portion of the 2-way conversion of Main and Michigan/St. Joseph streets from Chippewa to LaSalle (the former IN-933), $60K for the Marion St. roundabout, $48K for the Bartlett St. roundabout, $24K for the Western Ave. corridor sidewalks and striping, and $36K for the Olive-Sample overpass. There remains a $173K encumbrance for utility relocation for the US 31 construction on the south side of town; this encumbrance may be closed out soon. Expenditures Revenue Total Expenditures Staffing 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 as of Jan 31 are $635,520 from Fund 435 (Douglas Rd.) and $4,436,193 from Fund 436 (River East Residential). In 2016 with the first of two annual loans to the Parking Garages Fund 601 will be paid, $750,000 each year. The second loan will be issued in 2017. Form 3 64 Fund/Department Name Month January Fund/Department Number 416 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 100,000 5,076 5,076 7,870 - 94,924 5% Interest Earnings 2,000 855 855 453 - 1,145 43% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 102,000 5,931 5,931 8,323 - 96,069 6% Personnel- - - - - - 0% Supplies 30,000 - - 1,268 5,000 25,000 17% Services 48,923 - - - 13,010 35,913 27% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 78,923 - - 1,268 18,010 60,913 23% Net 23,077 5,931 5,931 7,055 (18,010) 35,157 Cash Balance 522,656 522,476 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Morris Performing Arts Center Capital There are no Capital projects budgeted for this year. Expenditures Revenue Total Expenditures Staffing 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. Form 3 65 Fund/Department Name Month January Fund/Department Number 434 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 45 45 28 - (45) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 45 45 28 - (45) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - 3,897 - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 3,897 - - 0% Net- 45 45 (3,869) - (45) Cash Balance 2,449 5,969 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Community Revitalization Enhancement District Expenditures Revenue Total Expenditures Staffing CRED is derived from State sale taxes generated within the CRED district (within Studebaker/Oliver area) up to a maximum $1M annually through 2015.The distribution is made once a year in October and amount fluctuates significantly (note historical revenues). Fund did not have sufficient revenue last few years to make full debt payment so COIT had to make a portion of the payments. May close this fund soon. Form 3 66 Fund/Department Name Month January Fund/Department Number 450 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 17,000 - - 1,225 - 17,000 0% Interest Earnings 300 126 126 56 - 174 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 17,300 126 126 1,281 - 17,174 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 17,300 126 126 1,281 - 17,174 Cash Balance 76,540 64,442 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Palais Royale Historic Preservation No Capital spending in this fund. Expenditures Revenue Total Expenditures Staffing This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. Form 3 67 Fund/Department Name Month January Fund/Department Number 677 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 2,000 833 833 495 - 1,167 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,000 833 833 495 - 1,167 42% Personnel- - - - - - 0% Supplies 1,000 - - - - 1,000 0% Services 83,801 4,658 4,658 6,843 288 78,855 6% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 84,801 4,658 4,658 6,843 288 79,855 6% Net(82,801) (3,825) (3,825) (6,348) (288) (78,689) Cash Balance 499,052 552,872 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Football Hall of Fame Capital Expenditures Revenue Total Expenditures Staffing The Hall of Fame Capital fund covers maintenance and utilities expense on the building incurred by the City, including costs of the building after the Hall of Fame ceased operations in South Bend at the end of 2012. Deal struck to sell or lease the building in 2015---to close in early 2016. Our expenses should only be utilities until closing and a contingency for furnace units during first couple years under new ownership. Form 3 68 Fund/Department Name Month January Fund/Department Number 287 Date Updated 2/15/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 2,075,000 - - - - 2,075,000 0% Charges for Services- - - - - - 0% Interest Earnings 500 4,258 4,258 - - (3,758) 852% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,075,500 4,258 4,258 - - 2,071,242 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 55,000 - - - - 55,000 0% Capital 2,192,611 - - - 363,611 1,829,000 17% Transfers Out- - - - - - 0% 2,247,611 - - - 363,611 1,884,000 16% Net(172,111) 4,258 4,258 - (363,611) 187,242 Cash Balance 2,576,498 - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Emergency Medical Services Capital Planned purchase of ambulance, replacement cardiac monitors, fleet vehicle. Expenditures Revenue Total Expenditures Staffing The revenues in this account are generated through user fees for the South Bend Fire Department EMS division. These funds are used for capital purchases such as fire apparatus, ambulances and major construction projects. There are no employees associated with this fund. Form 3 69 Fund/Department Name Month January Fund/Department Number 288 Date Updated 2/15/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 5,023,512 471,274 471,274 198,940 - 4,552,238 9% Interest Earnings 10,000 3,697 3,697 2,565 - 6,303 37% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 49,500 1,990 1,990 2,833 - 47,510 4% Transfers In 2,000 - - - - 2,000 0% Total Revenue 5,085,012 476,961 476,961 204,337 - 4,608,051 9% Personnel 4,983,238 311,308 311,308 - - 4,671,930 6% Supplies 276,861 29,782 29,782 16,853 69,199 177,879 36% Services 408,451 241,176 241,176 5,041 50,980 116,295 72% Debt Service 447,093 - - 226,083 2,364 444,729 1% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,115,643 582,267 582,267 247,977 122,543 5,410,833 12% Net(1,030,631) (105,306) (105,306) (43,639) (122,543) (802,782) Cash Balance 2,124,536 2,832,691 Full Time 51.00 51.00 Part-Time /Seasonal/Temporary- - Total 51.00 51.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Emergency Medical Services Operating None Expenditures Revenue Total Expenditures Staffing 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. Form 3 70 Fund/Department Name Month January Fund/Department Number 600 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 1,399,400 138,096 138,096 87,533 - 1,261,304 10% Interest Earnings 5,000 3,178 3,178 648 - 1,822 64% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 3,500 1,505 1,505 260 - 1,995 43% Transfers In 2,110,068 527,517 527,517 - - 1,582,551 25% Total Revenue 3,517,968 670,296 670,296 88,442 - 2,847,672 19% Personnel 2,862,499 205,504 205,504 239,220 - 2,656,995 7% Supplies 160,417 4,442 4,442 7,549 13,966 142,009 11% Services 1,311,150 55,662 55,662 32,624 231,099 1,024,390 22% Debt Service 46,623 6,960 6,960 2,983 2,033 37,631 19% Capital 70,285 30,608 30,608 - 39,677 0 100% Transfers Out- - - - - - 0% 4,450,974 303,175 303,175 282,377 286,774 3,861,025 13% Net(933,006) 367,121 367,121 (193,935) (286,774) (1,013,353) Cash Balance 2,261,160 540,834 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Consolidated Building Fund Expenditures Revenue Total Expenditures Staffing This fund now comprises the Consolidated Building Department, Code Enforcement and Animal Control. Code and Animal Control are managed together but are run separately from the Building Department per Council's wishes. The $2.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. Form 3 71 Fund/Department Name Month January Fund/Department Number 601 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 1,048,226 87,028 87,028 82,075 - 961,199 8% Interest Earnings 4,000 1,096 1,096 958 - 2,904 27% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,052,226 88,124 88,124 83,033 - 964,102 8% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,141,933 111,714 111,714 48,862 208,892 821,327 28% Debt Service 250,000 - - - - 250,000 0% Capital 1,536 - - 40,168 1,536 (0) 100% Transfers Out- - - - - - 0% 1,393,469 111,714 111,714 89,030 210,428 1,071,326 23% Net(341,243) (23,591) (23,591) (5,997) (210,428) (107,224) Cash Balance 617,027 1,067,632 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Parking Garages Encumbrances cover study to determine improvements to be made $1,500,000 from Major Moves and additional $587,000 from TIF will be spent on necessary improvements in 2016 and 2017. Expenditures Revenue Total Expenditures Staffing Operations under outside contract with Downtown South Bend, Inc. so all expenses except capital are shown under Services line. Form 3 72 Fund/Department Name Month January Fund/Department Number 610 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 5,592,249 405,471 405,471 407,832 - 5,186,778 7% Interest Earnings 2,500 529 529 346 - 1,971 21% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 2,000 - 2,000 0% Transfers In- - - - - - 0% Total Revenue 5,596,749 405,999 405,999 408,178 - 5,190,750 7% Personnel 1,725,395 128,272 128,272 171,970 2,000 1,595,123 8% Supplies 249,261 11,069 11,069 19,133 10,261 227,931 9% Services 2,697,559 268,016 268,016 254,385 313,681 2,115,862 22% Debt Service- - - - 0% Capital- - - - 0% Transfers Out 925,197 251,000 251,000 190,000 674,197 27% 5,597,412 658,357 658,357 635,488 325,941 4,613,114 18% Net(663) (252,358) (252,358) (227,310) (325,941) 577,636 Cash Balance 44,961 171,082 Full Time 26.20 25.10 25.10 Part-Time /Seasonal/Temporary- - - Total 26.20 25.10 25.10 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Solid Waste Operations Expenditures Revenue Total Expenditures Staffing This Enterprise Fund charges City residents a monthly fee to pick up and dispose of their trash at area landfills and recycling centers. The operations of Solid Waste are totally funded by these user fees. Transfers out to Fund 611 are made to pay debt service obligations. Large encumbrances for landfill tipping fees make Services appear high. Form 3 73 Fund/Department Name Month January Fund/Department Number 611 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 200 11 11 33 - 189 6% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 925,197 251,000 251,000 190,000 - 674,197 27% Total Revenue 925,397 251,011 251,011 190,033 - 674,386 27% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 925,197 250,879 250,879 223,749 - 674,318 27% Capital- - - - - 0% Transfers Out- - - - - - 0% 925,197 250,879 250,879 223,749 - 674,318 27% Net 200 133 133 (33,716) - 67 Cash Balance 575 1,484 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Solid Waste Capital Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to pay for capital items, such as trash trucks, used in the day to day operations of Solid Waste. Other than a small amount of interest income, the sole source of revenue for this fund comes from dollars transferred in from the Solid Waste Operations Fund #610. These transfers are done on an as needed basis. Form 3 74 Fund/Department Name Month January Fund/Department Number 620 Date Updated 2.12.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 14,423,116 1,070,988 1,070,988 1,060,291 - 13,352,128 7% Interest Earnings 26,000 6,375 6,375 3,691 - 19,625 25% Bond Proceeds- - - 0% Donations- - - 0% Other Income 123,500 113 113 113 - 123,387 0% Transfers In 31,500 1,876 1,876 1,555 - 29,624 6% Total Revenue 14,604,116 1,079,352 1,079,352 1,065,650 - 13,524,764 7% Personnel 5,440,741 401,397 401,397 492,705 3,656 5,035,688 7% Supplies 1,655,677 58,883 58,883 29,629 142,211 1,454,583 12% Services 5,352,541 250,128 250,128 255,846 534,643 4,567,770 15% Debt Service 119,687 4,952 4,952 560 114,735 4% Capital- - 0% Transfers Out 4,416,011 340,484 340,484 161,885 4,075,527 8% 16,984,657 1,055,844 1,055,844 940,625 680,510 15,248,303 10% Net(2,380,541) 23,508 23,508 125,025 (680,510) (1,723,539) Cash Balance 3,906,206 4,430,070 Full Time 72.30 70.05 Part-Time /Seasonal/Temporary 6.30 2.30 Total 78.60 72.35 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Operations Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to account for all revenue and operational expense of the water utility. This fund provides the monies for debt service obligations, reserve requirements and revenue funded capital improvements through transfer of monies to other funds within the utility operations. Encumbered expenditures include previous year rollover and current year value orders. Form 3 75 Fund/Department Name Month January Fund/Department Number 622 Date Updated 2.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 15,000 4,768 4,768 2,776 - 10,232 32% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 15,000 4,768 4,768 2,776 - 10,232 32% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital 821,797 - - 15,382 177,797 644,000 22% Transfers Out- - - - - - 0% 821,797 - - 15,382 177,797 644,000 22% Net(806,797) 4,768 4,768 (12,606) (177,797) (633,768) Cash Balance 2,885,176 3,112,675 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Capital Encumb: Meter Reading Mobile Management Software (1) $18,188, Interactive Voice Response(IVR) System Upgrade (1) $15,000, and 3 1/2 Tn Utility Truck (1) $144,609 Expenditures Revenue Total Expenditures Staffing This fund is used for acquiring, constructing, and improving fixed assets. Investment income is greater than anticipated. Form 3 76 Fund/Department Name Month January Fund/Department Number 623 Date Updated 2/18/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 180 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 180 - - 0% Personnel- - - - - - 0% Supplies- - - 8,888 - - 0% Services- - - 2,171 - - 0% Debt Service- - - - - - 0% Capital- - - 219 - - 0% Transfers Out- - - - - - 0% - - - 11,278 - - 0% Net- - - (11,098) - - Cash Balance- 180,329 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Bond Capital Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to segregate the use of bond proceeds that are applied to the acquisition, construction and installation of certain additions, extension and improvements. Revenue bonds were issued in June 2012 with an aggregate principal of $8,300,000. The bond cash proceeds were fully expended as of July 14, 2015. Form 3 77 Fund/Department Name Month January Fund/Department Number 624 Date Updated 2.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 8,400 2,502 2,502 1,307 - 5,898 30% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 8,400 2,502 2,502 1,307 - 5,898 30% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - 0% Transfers Out 8,400 534 534 452 - 7,866 6% 8,400 534 534 452 - 7,866 6% Net- 1,968 1,968 855 - (1,968) Cash Balance 1,514,746 1,483,637 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Customer Deposit Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to retain security deposits collected from customers when establishing new service. Upon termination of service, these deposits are released and credited against final bills. Investment earning income is greater than anticipated. Form 3 78 Fund/Department Name Month January Fund/Department Number 625 Date Updated 2.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 3,600 557 557 468 - 3,043 15% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 2,046,081 170,505 170,505 - - 1,875,576 8% Total Revenue 2,049,681 171,062 171,062 468 - 1,878,619 8% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 2,046,081 - - - - 2,046,081 0% Capital- - - - - - 0% Transfers Out 3,600 551 551 465 - 3,049 15% 2,049,681 551 551 465 - 2,049,130 0% Net- 170,511 170,511 3 - (170,511) Cash Balance 174,916 4,658 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Sinking Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. The source of monies for debt repayment are transfers from the water utility operating fund 620. Biannual installments are disbursed at the end of June and December. June's payment includes 50% of the annual interest and December's payment comprises the rest of the interest and all of the principal. Form 3 79 Fund/Department Name Month January Fund/Department Number 626 Date Updated 2.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 9,500 2,662 2,662 1,425 6,838 28% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 9,500 2,662 2,662 1,425 - 6,838 28% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 9,500 - - - - 9,500 0% 9,500 - - - - 9,500 0% Net- 2,662 2,662 1,425 - (2,662) Cash Balance 1,642,223 1,648,103 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Bond Reserve Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to ensure compliance with certain debt service bond covenants. Balance in fund is determined by debt service financing arrangements at bond issuance. The 2016 annual maximum reserve requirement is satisfied. Form 3 80 Fund/Department Name Month January Fund/Department Number 629 Date Updated 2.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 10,000 3,696 3,696 1,840 - 6,304 37% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - 0% Transfers In 165,166 - 165,166 0% Total Revenue 175,166 3,696 3,696 1,840 - 171,470 2% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 10,000 790 790 637 - 9,210 8% 10,000 790 790 637 - 9,210 8% Net 165,166 2,906 2,906 1,203 - 162,260 Cash Balance 2,235,267 2,085,039 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Reserve Operations & Maintenance Expenditures Revenue Total Expenditures Staffing 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. Investment earning income is greater than anticipated. The Cash Balance of this fund is required to be the equivalent of two months' worth of operating expenditures in Fund 620, excluding transfers. Form 3 81 Fund/Department Name Month January Fund/Department Number 640 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 561,225 52,097 52,097 50,523 509,128 9% Interest Earnings 3,500 2,731 2,731 1,330 769 78% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 564,725 54,828 54,828 51,853 - 509,897 10% Personnel 188,900 11,807 11,807 19,867 177,093 6% Supplies 41,569 1,529 1,529 162 3,751 36,289 13% Services 290,487 19,263 19,263 1,421 25,000 246,224 15% Debt Service 28,457 28,457 0% Capital- 0% Transfers Out- - - - - - 0% 549,413 32,598 32,598 21,449 28,751 488,063 11% Net 15,312 22,230 22,230 30,404 (28,751) 21,834 Cash Balance 1,670,172 1,535,686 Full Time 2.20 1.85 - Part-Time /Seasonal/Temporary- - - Total 2.20 1.85 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewer Repair Insurance Expenditures Revenue Total Expenditures Staffing 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. Form 3 82 Fund/Department Name Month January Fund/Department Number 641 Date Updated 2/15/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 36,538,600 2,955,939 2,955,939 2,774,691 - 33,582,661 8% Interest Earnings 65,000 15,925 15,925 7,786 - 49,075 25% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 92,000 315 315 2,507 - 91,685 0% Transfers In 16,000 1,301 1,301 1,045 - 14,699 8% Total Revenue 36,711,600 2,973,480 2,973,480 2,786,029 - 33,738,120 8% Personnel 7,573,583 535,187 535,187 780,135 2,500 7,035,896 7% Supplies 2,292,608 128,743 128,743 96,072 253,825 1,910,040 17% Services 16,901,880 927,179 927,179 781,681 1,990,106 13,984,595 17% Debt Service 678,685 189,857 189,857 132,947 3,684 485,144 29% Capital- - - - 0% Transfers Out 12,289,388 760,893 760,893 773,536 11,528,495 6% 39,736,144 2,541,858 2,541,858 2,564,371 2,250,115 34,944,171 12% Net(3,024,544) 431,621 431,621 221,658 (2,250,115) (1,206,050) Cash Balance 9,227,486 9,011,853 Full Time 93.24 85.43 85.43 Part-Time /Seasonal/Temporary 11.44 8.67 8.67 Total 104.68 94.10 94.10 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Works Operations Capital spending for Sewage works is shown in Fund 642. Expenditures Revenue Total Expenditures Staffing This enterprise fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Large encumbrances for supplies and services contribute to the higher percentage of budget used. Debt service payments are made in accordance with City amortization schedules. Form 3 83 Fund/Department Name Month January Fund/Department Number 642 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 45,000 14,620 14,620 3,385 - 30,380 32% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 2,487,000 - - - - 2,487,000 0% Total Revenue 2,532,000 14,620 14,620 3,385 - 2,517,380 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 8,239 - - 0% Debt Service- - - - - - 0% Capital 7,631,946 635,043 635,043 30,876 3,915,653 3,081,250 60% Transfers Out- - - - - - 0% 7,631,946 635,043 635,043 39,115 3,915,653 3,081,250 60% Net(5,099,946) (620,423) (620,423) (35,730) (3,915,653) (563,870) Cash Balance 8,115,928 3,715,991 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Works Capital Year to Date totals spent include: Wastewater Treatment Plant Primary Clarifier Rehab $158,675, and Digesters #1 & #3 Clean and Rehab $476,368. Expenditures Revenue Total Expenditures Staffing 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. Form 3 84 Fund/Department Name Month January Fund/Department Number 643 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 16,000 6,083 6,083 3,020 - 9,917 38% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 536,997 - 536,997 0% Total Revenue 552,997 6,083 6,083 3,020 - 546,914 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 16,000 1,301 1,301 1,045 - 14,699 8% 16,000 1,301 1,301 1,045 - 14,699 8% Net 536,997 4,782 4,782 1,975 - 532,215 Cash Balance 3,678,649 3,422,564 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Works Reserve Operations & Maint. Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to hold the equivalent of two months of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. A transfer will be done in February to adjust the balance to stay in compliance. The Cash Balance is equivalent to two months' worth of operating expenditures in Fund 641, excluding transfers. Form 3 85 Fund/Department Name Month January Fund/Department Number 649 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 7,000 1,606 1,606 785 - 5,394 23% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 9,267,391 760,893 760,893 773,536 - 8,506,498 8% Total Revenue 9,274,391 762,499 762,499 774,321 - 8,511,893 8% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 8,000 1,350 1,350 1,000 - 6,650 17% Debt Service 9,266,298 - - 9,266,298 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 9,274,298 1,350 1,350 1,000 - 9,272,948 0% Net 93 761,149 761,149 773,321 - (761,056) Cash Balance 1,565,889 1,563,658 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Sinking Expenditures Revenue Total Expenditures Staffing This fund is used to pay all debt service obligations for Wastewater and Sewers. Mandatory transfers in from Operating Fund 641 are done in specified amounts each month to satisfy bond covenants. Form 3 87 Fund/Department Name Month January Fund/Department Number 653 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 25 25 - - (25) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 25 25 - - (25) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- 25 25 - - (25) Cash Balance 4,105,649 7,286,832 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Debt Service Reserve Expenditures Revenue Total Expenditures Staffing 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 is a lower cash balance. A reconcilliation of this account is done monthly. Form 3 88 Fund/Department Name Month January Fund/Department Number 659 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 2,000 384 384 1,477 - 1,616 19% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,000 384 384 1,477 - 1,616 19% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 9,606 - 3,917 9,606 - 100% Debt Service- - - - - - 0% Capital 162,482 - 139,121 162,482 - 100% Transfers Out- - - - - - 0% 172,088 - - 143,037 172,088 - 100% Net(170,088) 384 384 (141,560) (172,088) 1,616 Cash Balance 232,278 1,457,825 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewer Bond 2011 From issue late in 2011, this bond has funded numerous projects including Diamond Ave. Trunk Sewer, Phase II $3.7 million, East Bank Sewer Separation, Phase II $2.8 million, East Bank Sewer Separation, Phase III $2.3 million, LaSalle School Area Sewer Separation, $1.7 million, East Bank Sewer Separation, Phase III $545,000, Southwood Sewer Separation, $1,438,816, Diamond Ave. Trunk Sewer, Phase III $248,000, St. Joseph River CSO Stabilization $217,831, Secondary Clarifier Upgrade $494,141, Wastewater Treatment Plant Digester Upgrade $5,782,989. Expenditures Revenue Total Expenditures Staffing This Sewage Works Revenue Bond closed in October of 2011. The remaining cash balance has been fully encumbered and is expected to be spent in 2016. The significant projects this bond has funded are listed below. Form 3 90 Fund/Department Name Month January Fund/Department Number 661 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 25,000 23,078 23,078 14,968 - 1,922 92% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - 0% Total Revenue 25,000 23,078 23,078 14,968 - 1,922 92% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 850,000 118,335 118,335 - - 731,665 14% Debt Service- - - - - - 0% Capital 19,337,062 39,170 10,068,728 9,268,334 52% Transfers Out- - - - - - 0% 20,187,062 118,335 118,335 39,170 10,068,728 9,999,999 50% Net(20,162,062) (95,257) (95,257) (24,202) (10,068,728) (9,998,078) Cash Balance 13,814,785 16,795,063 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewer Bond 2012 Since issue through 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 $598,923, Southwood Sewer Separation $919,608, Fairfax Sewer $70,022, East Bank Sewer Separation-Phase 5 $574,681, Sewer Sensory Control Network $193,609, Wastewater Treatment Plant Grit/Screening Improvements $139,740, Secondary Clarifier Modifications $342,842, CSO LTCP re-look $1,406,815, and misc other $2,070. Expenditures Revenue Total Expenditures Staffing Current year spending from this Bond has been for the CSO LTCP re-look $93,837, East Bank Sewer Separation-Phase 5 $16,961, WWTP Secondary Clarifier Modifications $4,447, and WWTP Grit/Screening Improvements $3,090. Form 3 91 Fund/Department Name Month January Fund/Department Number 664 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 7 7 4 - (7) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 7 7 4 - (7) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- 7 7 4 - (7) Cash Balance 4,514 4,484 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report 2013A Cost of Issuance Fund Expenditures Revenue Total Expenditures Staffing This fund was set up to pay the issue costs related to the re-funding of the 2004 Sewer bond and 1998 SRF Loan. Those costs were paid in 2013. The remaining cash balance should be transferred to an appropriate fund, so this fund can be closed out. Form 3 92 Fund/Department Name Month January Fund/Department Number 666 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 76 76 - - (76) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 76 76 - - (76) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- 2,500 2,500 - - (2,500) 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - 2,500 2,500 - - (2,500) 0% Net- (2,424) (2,424) - - 2,424 Cash Balance 6,666 - Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report 2015 Sewer Bond Issuance Expenditures Revenue Total Expenditures Staffing This fund was set up to pay the legal and financial accounrting costs associated with the refunding of the 2006, 2007, and 2007B Sewer bonds. Most of those expenses were paid in December, 2015. The amount spent this month was for bank acceptance/administration fees. Form 3 93 Fund/Department Name Month January Fund/Department Number 670 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 1,313,436 656,725 656,725 - - 656,711 50% Grants/Intergovernmental- - - - - - 0% Charges for Services 2,664,721 133,069 133,069 38,103 - 2,531,652 5% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 5,630 379 379 (5,117) - 5,251 7% Transfers In- - - - - - 0% Total Revenue 3,983,787 790,173 790,173 32,985 - 3,193,614 20% Personnel 2,249,773 154,476 154,476 145,918 - 2,095,297 7% Supplies 473,779 67,565 67,565 19,602 - 406,214 14% Services 1,154,774 107,316 107,316 140,976 - 1,047,458 9% Debt Service- - - - - - 0% Capital 14,722 - - - - 14,722 0% Transfers Out 79,390 - - - - 79,390 0% 3,972,438 329,357 329,357 306,497 - 3,643,081 8% Net 11,349 460,815 460,815 (273,511) - (449,466) Cash Balance 1,604,875 646,854 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Century Center Expenditures Revenue Total Expenditures Staffing SMG has assumed management of Century Center effective July 1, 2013. One of their contractual duties is to reduce the operating deficit in the fund. Covered by hotel/motel tax revenue which is received twice per year. The first installment was received in February 2015. Other income includes charges to large conferences for electric costs. Although charges for services are down, personnel expenditures are also down as they are controlling their costs. Also, charges for services will likely stay low as the Century Center is going to begin many energy savings construction projects which is putting many of their rooms out of inventory for months at a time. However, the energy savings and their efforts to become more "green" will likely help attract future business. Form 3 94 Fund/Department Name Month January Fund/Department Number 671 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 500 85 85 24 - 415 17% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 500 85 85 24 - 415 17% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 500 85 85 24 - 415 Cash Balance 1,002,157 1,418,687 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Century Center Capital A Qualified Energy Conservation Bond was taken out in May 2015. Approximately $192,000 will be used as a down payment on the construction contract, thus reducing the amount necessary to be funded by bond issuance. The actual bond payments will be made with hotel/motel funds through a new fund, Century Center Energy Conservation Debt Service, that was seeded with a $50,000 transfer from this fund in May. Expenditures Revenue Total Expenditures Staffing SMG contributed a one time amount of $575,000 to cover capital expenses in August 2013. The remainder of these funds have been appropriated for spending during 2015. $25,000 was appropriated to help pay for the Wall of Fame in conjunction with the South Bend Alumni Association. $50,000 was transferred out to the new fund 672 for bond payments on the Energy Savings Contract. Form 3 95 Fund/Department Name Month January Fund/Department Number 672 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 157,742 4 4 - - 157,738 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 79,390 - - - - 79,390 0% Total Revenue 237,132 4 4 - - 237,128 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 237,132 - - - - 237,132 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 237,132 - - - - 237,132 0% Net- 4 4 - - (4) Cash Balance 50,036 - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Century Center Energy Conservation Debt Svc Expenditures Revenue Total Expenditures Staffing A Qualified Energy Conservation Bond was taken out in May 2015. Form 3 96 Fund/Department Name Month December Fund/Department Number 222 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - 0% Charges for Services 8,181,507 557,339 557,339 634,838 - 7,624,168 7% Interest Earnings 3,240 2,087 2,087 1,233 - 1,153 64% Bond Proceeds- - 0% Donations- - 0% Other Income 49,890 1,979 1,979 19,817 - 47,911 4% Transfers In- - - - - - 0% Total Revenue 8,234,637 561,404 561,404 655,888 - 7,673,233 7% Personnel 3,143,175 204,999 204,999 290,646 2,938,176 7% Supplies 190,636 1,810 1,810 (6,319) 13,287 175,539 8% Services 4,812,674 336,476 336,476 393,823 3,280,409 1,195,789 75% Debt Service 12,475 1,115 1,115 1,414 - 11,360 9% Capital- - - 0% Transfers Out 130,519 - - - 130,519 0% 8,289,479 544,400 544,400 679,565 3,293,695 4,451,383 46% Net(54,842) 17,004 17,004 (23,676) (3,293,695) 3,221,849 Cash Balance 1,356,199 1,562,395 Full Time 42.00 37.00 37.00 Part-Time /Seasonal/Temporary 2.00 3.00 3.00 Total 44.00 40.00 40.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Central Services The capital expenses for 2015 were moved to a new Fund #224 for $271,850. We are transfering monies out of our cash reserve over to fund 224 to cover our 2015 capital expenses. We had $120,000 roll over from 2014 to 2015 for capital expenses to converting our garage so we can work on CNG vehicles. Expenditures Revenue Total Expenditures Staffing 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 Jan we had 1,350 vehicle repairs. Average Fuel prices for January is $1.30 for Unleaded and $1.31 for Diesel. Budgeted amount per gallon is $3.20. The Radio Shop's project was the AVL installation of all new radios without loss of service to all departments. Equipment Services continues to purchase new vehicles with compressed natural gas or hybrids. Sustainability Office had no major expenditures. Due to slow hiring of replacement FTE, a temporary employee is working 20hrs/week. Job should be filled by April. Form 3 97 Fund/Department Name Month January Fund/Department Number 224 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 313 313 - - (313) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 130,519 - - 130,519 0% Total Revenue 130,519 313 313 - - 130,206 0% Personnel- - - - - - 0% Supplies 20,000 - - - - 20,000 0% Services 60,019 - - - - 60,019 0% Debt Service- - - - - 0% Capital 225,565 - - - 175,065 50,500 78% Transfers Out- - - - - - 0% 305,584 - - - 175,065 130,519 57% Net(175,065) 313 313 - (175,065) (313) Cash Balance 187,233 - Full Time- - Part-Time /Seasonal/Temporary- - Total- - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Central Services Capital Capital projects for 2015 including a roof replacement for the Equipment Services building ($150,433), & Scanner/software for Inventory/fleet system for $24,632 encumbrances were carried over to 2016. The 2016 Capital projects are: Radio tower repairs, new overhead door for garage, paving of lot, CNG compressor maintenance costs, inground hoists, new pressure washer. Expenditures Revenue Total Expenditures Staffing This is a new fund for 2015. Revenues are a transfer from Central Services. Form 3 98 Fund/Department Name Month January Fund/Department Number 226 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 2,223,483 183,301 183,301 99,293 - 2,040,182 8% Interest Earnings 20,500 7,513 7,513 5,051 - 12,987 37% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 10,000 - - - - 10,000 0% Transfers In- - - - - - 0% Total Revenue 2,253,983 190,814 190,814 104,344 - 2,063,169 8% Personnel 250,135 15,960 15,960 20,913 - 234,175 6% Supplies 30,734 104 104 2,355 7,500 23,130 25% Services 2,839,479 81,377 81,377 238,970 83,156 2,674,946 6% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 3,120,348 97,441 97,441 262,238 90,656 2,932,251 6% Net(866,365) 93,373 93,373 (157,895) (90,656) (869,081) Cash Balance 4,618,578 5,522,179 Full Time 3.00 3.00 Part-Time /Seasonal/Temporary- - Total 3.00 3.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Liability Insurance No capital expenditures are budgeted in 2016. Expenditures Revenue Total Expenditures Staffing 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. Personnel expenditures are for 2 Safety and Risk personnel and an attorney who processes claims for the City. The City has budgeted $1 million in 2016 for expected liability cliams, $530,000 for excess coverage premiums for property insurance, and $852,000 in expected workers compensation activities. Form 3 99 Fund/Department Name Month January Fund/Department Number 278 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- 4,470 4,470 7,060 - (4,470) 0% Interest Earnings 4,000 1,059 1,059 455 - 2,941 26% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 60,400 4,470 4,470 7,060 - 55,930 7% Transfers In- - - - - - 0% Total Revenue 64,400 9,999 9,999 14,575 - 54,401 16% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 10,000 53 53 - - 9,947 1% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 10,000 53 53 - - 9,947 1% Net 54,400 9,946 9,946 14,575 - 44,454 Cash Balance 651,419 530,587 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Take Home Vehicle Police None Expenditures Revenue Total Expenditures Staffing This fund charges police officers for liability insurance and gasoline costs for take home police vehicles. The cash reserve in this fund has increased in recent years and is expected to increase during 2016. Claims have been minimal in this fund since it was created. This fund is classified as an Internal Service Fund for financial reporting. No liability claims were paid during 2014. Form 3 100 Fund/Department Name Month January Fund/Department Number 279 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- 0% Local Income Taxes- 0% Other Taxes- 0% Grants/Intergovernmental- 0% Charges for Services 499,358 38,778 38,778 460,580 8% Interest Earnings- 0% Bond Proceeds- 0% Donations- 0% Other Income- 0% Transfers In- 0% Total Revenue 499,358 38,778 38,778 - - 460,580 8% Personnel 459,575 36,624 36,624 422,951 8% Supplies 5,300 591 591 4,709 11% Services 34,482 1,562 1,562 32,920 5% Debt Service- 0% Capital- 0% Transfers Out- 0% 499,357 38,778 38,778 - - 460,579 8% Net 1 - - - - 1 Cash Balance 1,318 - Full Time 6.00 6.00 Part-Time /Seasonal/Temporary 2.00 2.00 Total 8.00 8.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report 311 Call Center No capital spending planned for 2016. Expenditures Revenue Total Expenditures Staffing This internal service fund is new in 2016. Expenses in previous years were charged to the General Fund. The fund is used to track operational revenues and expenditures of the 311 Call Center. Revenues are charges for services to the City departments that are served by the Center. The Center is still growing, so revenues will increase as more departments are served. Expenditures are predominantly related to salaries for the Center employees. Form 3 101 Fund/Department Name Month January Fund/Department Number 711 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 17,151,500 1,380,393 1,380,393 1,225,764 - 15,771,107 8% Interest Earnings 23,345 7,429 7,429 3,733 - 15,916 32% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- 973 973 19,222 - (973) 0% Transfers In- - - - - - 0% Total Revenue 17,174,845 1,388,795 1,388,795 1,248,718 - 15,786,050 8% Personnel 4,316 - - 1 - 4,316 0% Supplies 17,875 - - 80 900 16,975 5% Services 1,415,949 11,835 11,835 73,872 256,817 1,147,297 19% Insurance 15,940,750 622,477 622,477 956,818 45,000 15,273,273 4% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 17,378,890 634,312 634,312 1,030,771 302,717 16,441,861 5% Net(204,045) 754,483 754,483 217,947 (302,717) (655,811) Cash Balance 5,123,551 4,274,934 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Self-Funded Employee Benefits None Expenditures Revenue Total Expenditures Staffing This fund handles expenses relating to insurance and claims relating to employees: medical, dental, life, flex spending, etc. For the last several years expenses have significantly exceeded revenues (charges to City Departments and employees) so our cash balance has been eroding. This is not sustainable in the long-term and we need to address this situation. For the 2015 Budget, we increased employer and employee contributions significantly, which has been helping, although we are falling short of our revenue targets. Fortunately, claims costs have been lower than expected. A new Employee Wellness Center was opened on January 18, 2016 which is set in place with the understanding that the City should see a drop in claims expenses over time. Form 3 102 Fund/Department Name Month January Fund/Department Number 713 Date Updated 2/16/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 105,682 - - 8,473 - 105,682 0% Interest Earnings 1,600 445 445 212 - 1,155 28% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 107,282 445 445 8,685 - 106,837 0% Personnel 80,000 880 880 2,960 - 79,120 1% Supplies- - - - - - 0% Services 33,882 607 607 7,166 6,600 26,675 21% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 113,882 1,487 1,487 10,126 6,600 105,795 7% Net(6,600) (1,042) (1,042) (1,441) (6,600) 1,042 Cash Balance 268,241 239,730 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Unemployment Compensation None Expenditures Revenue Total Expenditures Staffing This fund charges an allocation of 0.25% of payroll to most departments to cover the cost of unemployment claims paid. For the 2015 budget, all outplacement services will be paid through this account. These were paid through the General Fund in previous years, however, due to the nature of outplacement claims, the Unemployment Fund is a more appropriate place from which to pay the costs. The Unemployment Compensation Fund is classified as an Internal Service Fund for financial reporting. Claims continue to be lower than anticipated. Form 3 103 Fund/Department Name Month January Fund/Department Number 701 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 5,443,092 - - - - 5,443,092 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 4,500 929 929 688 - 3,571 21% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 5,447,592 929 929 688 - 5,446,663 0% Personnel 5,575,570 427,085 427,085 441,109 - 5,148,485 8% Supplies 200 - - - - 200 0% Services 6,950 82 82 83 - 6,868 1% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 5,582,720 427,167 427,167 441,192 - 5,155,553 8% Net(135,128) (426,237) (426,237) (440,504) - 291,109 Cash Balance 46,067 198,623 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Firefighters Pension No capital expenditures are purchased through this account. Expenditures Revenue Total Expenditures Staffing 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. Form 3 104 Fund/Department Name Month January Fund/Department Number 702 Date Updated 2/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 6,125,000 - - - - 6,125,000 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 4,500 2,088 2,088 1,133 - 2,412 46% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 4,000 - - - - 4,000 0% Transfers In- - - - - - 0% Total Revenue 6,133,500 2,088 2,088 1,133 - 6,131,412 0% Personnel 6,999,982 516,354 516,354 537,014 - 6,483,628 7% Supplies 800 - - - - 800 0% Services 7,400 98 98 98 - 7,302 1% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 7,008,182 516,452 516,452 537,112 - 6,491,730 7% Net(874,682) (514,363) (514,363) (535,979) - (360,319) Cash Balance 643,056 574,792 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Pension No capital expenditures are paid from this fund. Expenditures Revenue Total Expenditures Staffing The Police Pension fund receives pension relief distributions from the State of Indiana to reimburse the City for pension costs paid and reported in the previous fiscal year. For 2016, the payments are expected to be $3,062,500 by 1 July and again by 1 October, totaling $6,125,000. Form 3 105 Fund/Department Name Month January Fund/Department Number 730 Date Updated 2/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 150 47 47 25 - 103 31% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 150 47 47 25 - 103 31% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 20,000 - - - 20,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 20,000 - - - - 20,000 0% Net(19,850) 47 47 25 - (19,897) Cash Balance 28,589 28,403 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report City Cemetery Spending this year will concentrate on repairing headstones and completing the GIS survey of the cemetery and its occupants. Expenditures Revenue Total Expenditures Staffing This fund is designated for expenses specifically for the City Cemetery. Revenues were originally derived from the sale of cemetery plots and burial expenses.There are few sites available for sale and most plots are occupied, resulting in little burial activty. Form 3 106 Fund/Department Name Month January Fund/Department Number 324 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 16,723,300 - - - - 16,723,300 0% Local Income Taxes- - - - - - 0% Other Taxes 396,000 - - - - 396,000 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - 2,785 - - 0% Interest Earnings 62,706 53,371 53,371 29,722 - 9,335 85% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,692,308 8,213 8,213 17,527 - 1,684,095 0% Transfers In 11,000 981 981 317 - 10,019 9% Total Revenue 18,885,314 62,565 62,565 50,350 - 18,822,749 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 4,104,961 24,048 24,048 170,927 1,066,725 3,014,188 27% Debt Service 6,217,896 2,616,949 2,616,949 2,105,061 - 3,600,947 42% Capital 21,179,220 1,423,438 1,423,438 451 9,536,972 10,218,811 52% Transfers Out- - - - - - 0% 31,502,077 4,064,434 4,064,434 2,276,439 10,603,697 16,833,946 47% Net(12,616,763) (4,001,870) (4,001,870) (2,226,088) (10,603,697) 1,988,804 Cash Balance 28,726,528 29,172,181 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report River West Development Area (Airport TIF) In 2015, the major projects were: the Ameriplex lease, Bartlett Roundabout, Ignition Park infrastructure and Multi-tenant building, LaSalle Hotel, ND/GE Turbo Project, Nello, Noble Energy, Western Avenue Improvements, Patel Hotel, and Studebaker Envionmental and Renaissance District. Thus far in 2016, major expenditures (other than debt service) include: $500K for Ignition Park Infrastructure. Expenditures Revenue Total Expenditures Staffing Form 3 107 Fund/Department Name Month January Fund/Department Number 420 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - 165 - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - 530 - - 0% Total Revenue- - - 695 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 6,768 - - 0% Debt Service- - - 957,248 - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 964,016 - - 0% Net- - - (963,321) - - Cash Balance- 3,125,152 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Tax Incremental Financing (TIF) - Downtown Expenditures Revenue Total Expenditures Staffing In 2015 SBCDA is eliminated and all funds were distributed between Fund 324 River West and Fund 429 River East. This is the result of the TIF realignment. Form 3 108 Fund/Department Name Month January Fund/Department Number 422 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 420,000 - - - - 420,000 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 4,000 2,477 2,477 996 - 1,523 62% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 424,000 2,477 2,477 996 - 421,523 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 29,366 - - - 3,366 26,000 11% Debt Service- - - - - - 0% Capital 1,374,000 - - - 300,000 1,074,000 22% Transfers Out- - - - - - 0% 1,403,366 - - - 303,366 1,100,000 22% Net(979,366) 2,477 2,477 996 (303,366) (678,477) Cash Balance 1,509,302 1,196,745 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - West Washington Major projects committed thus far in 2016 are: City Cemetery Project. Other TIF eligible development projects for this TIF area will be determined by department staff and the Mayor's office as the year progresses. Expenditures Revenue Total Expenditures Staffing Major Projects committed thus far in 2016 are: City Cemetery Project. Form 3 109 Fund/Department Name Month January Fund/Department Number 425 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,006 273 273 79 - 733 27% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 170,997 11,147 11,147 18,150 - 159,850 7% Transfers In- - - - - - 0% Total Revenue 172,003 11,420 11,420 18,229 - 160,583 7% Personnel- - - - - - 0% Supplies 8,742 282 282 154 - 8,460 3% Services 151,664 4,199 4,199 6,808 - 147,465 3% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 160,406 4,481 4,481 6,962 - 155,925 3% Net 11,597 6,939 6,939 11,267 - 4,658 Cash Balance 215,755 183,793 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Redevelopment Retail & Leighton Plaza Expenditures Revenue Total Expenditures Staffing Operations under outside contract with Bradley Co. Form 3 110 Fund/Department Name Month January Fund/Department Number 426 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 1,941 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 1,941 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- - - 1,941 - - Cash Balance- 2,296,474 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - Central Medical Service Area Expenditures Revenue Total Expenditures Staffing In 2015 Central Medical Service Area is eliminated and all funds were distributed to Fund 324 River West. This is the result of the TIF realignment. Form 3 111 Fund/Department Name Month January Fund/Department Number 429 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 2,750,000 - - - - 2,750,000 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 7,000 12,505 12,505 3,858 - (5,505) 179% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 19,357 - - 0% Transfers In- - - - - - 0% Total Revenue 2,757,000 12,505 12,505 23,215 - 2,744,495 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 652,773 30,000 30,000 35,090 52,772 570,001 13% Debt Service- - - - - - 0% Capital 7,682,386 51,910 51,910 77,866 1,916,530 5,713,946 26% Transfers Out- - - - - - 0% 8,335,159 81,910 81,910 112,956 1,969,302 6,283,947 25% Net(5,578,159) (69,405) (69,405) (89,741) (1,969,302) (3,539,452) Cash Balance 7,491,727 4,466,739 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report River East Development Area (NE Dev TIF) Projects committed to in 2015 include: 5 Points Utility Study, Hill Street Improvements and the NW Corner of Hill & Colfax. Expenditures Revenue Total Expenditures Staffing Due to changes in boundary, this area now includes a portion of South Bend Central Development Area (Fund 420). Form 3 112 Fund/Department Name Month January Fund/Department Number 430 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 2,400,000 - - - - 2,400,000 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 10,000 9,942 9,942 4,144 - 58 99% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,410,000 9,942 9,942 4,144 - 2,400,058 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 528,454 280 280 33,453 288,174 240,000 55% Debt Service- - - - - - 0% Capital 6,883,361 - - 401,917 1,023,361 5,860,000 15% Transfers Out- - - - - - 0% 7,411,815 280 280 435,370 1,311,534 6,100,001 18% Net(5,001,815) 9,662 9,662 (431,226) (1,311,534) (3,699,942) Cash Balance 6,105,040 4,526,065 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - Southside Development #1 Projects committed to in 2015 include: Chippewa Improvements, Fellows Street Corridor, Ireland & Miami Area Improvements, Ireland Road Acquisition Services, Main-Lafayette Crossover Connector and Safe Routes to School (Perley). The major project expected in 2016 is the construction of the Chippewa Roundabout. Expenditures Revenue Total Expenditures Staffing Form 3 113 Fund/Department Name Month January Fund/Department Number 435 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 320,000 - - - - 320,000 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 750 234 234 161 - 516 31% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 320,750 234 234 161 - 320,516 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 13,012 - - - 4,200 8,812 32% Debt Service 341,188 - - - - 341,188 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 354,200 - - - 4,200 350,000 1% Net(33,450) 234 234 161 (4,200) (29,484) Cash Balance 151,899 221,591 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - Douglas Road Expenditures Revenue Total Expenditures Staffing The Douglas Road TIF was established to develop the road and area near Brown Mackie College near the South Bend-Mishawaka border. The fund borrowed money from the City of Mishawaka ($1,086,550) and Major Moves Fund 412 ($1,000,000) to finance initial construction. The fund uses TIF tax revenue to repay the loans. During February 2015 the amounts due Mishawaka were paid in full and the amount due to Major Moves was $787,402. Payments will now be accelerated on the Major Moves loan in order to pay it off early as well. Form 3 114 Fund/Department Name Month January Fund/Department Number 436 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 2,948,923 - - - - 2,948,923 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 210,999 210,999 210,999 - - (0) 100% Interest Earnings 2,500 2,109 2,109 1,215 - 391 84% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 3,162,422 213,108 213,108 1,215 - 2,949,314 7% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 2,818 - - - - 2,818 0% Debt Service 3,427,182 1,237,500 1,237,500 1,464,000 - 2,189,682 36% Capital- - - - - - 0% Transfers Out- - - - - - 0% 3,430,000 1,237,500 1,237,500 1,464,000 - 2,192,500 36% Net(267,578) (1,024,392) (1,024,392) (1,462,785) - 756,814 Cash Balance 595,626 242,718 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report River East Residential (NE Res TIF) Expenditures Revenue Total Expenditures Staffing Debt Service is related to the Eddy Street Commons Project--payment on the ESC Bonds and reimbursement to Major Moves fund for project costs. Form 3 115 Fund/Department Name Month January Fund/Department Number 433 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 152 14 14 9 - 138 9% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 152 14 14 9 - 138 9% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 4,500 - - - - 4,500 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 4,500 - - - - 4,500 0% Net(4,348) 14 14 9 - (4,362) Cash Balance 8,716 10,099 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Redevelopment General Expenditures Revenue Total Expenditures Staffing This fund's sole expenditure is for general legal fees for DCI based on an engagement letter Form 3 116 Fund/Department Name Month January Fund/Department Number 439 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 14,637 3,792 3,792 4,432 - 10,845 26% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 14,637 3,792 3,792 4,432 - 10,845 26% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital 2,692,913 - - - 142,913 2,550,000 5% Transfers Out- - - - - - 0% 2,692,913 - - - 142,913 2,550,000 5% Net(2,678,276) 3,792 3,792 4,432 (142,913) (2,539,155) Cash Balance 2,277,099 5,024,993 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Certified Technology Park Capital funds are to be expended in Ignition Park and Innovation Park. Expenditures Revenue Total Expenditures Staffing Form 3 117 Fund/Department Name Month January Fund/Department Number 454 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,500 628 628 333 - 872 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,500 628 628 333 - 872 42% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 50,000 - - - - 50,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 50,000 - - - - 50,000 0% Net(48,500) 628 628 333 - (49,128) Cash Balance 380,249 377,774 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Airport Urban Enterprise Zone Expenditures Revenue Total Expenditures Staffing No significant issues. Possible expenditure for job training in Urban Enterprise Zone. Form 3 118 Fund/Department Name Month January Fund/Department Number 619 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - 99,156 - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 99,156 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 69,055 - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 69,055 - - 0% Net- - - 30,101 - - Cash Balance- 112,190 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Blackthorn Operations Equipment payments Expenditures Revenue Total Expenditures Staffing The course has been sold to a private owner. The sale was completed in February, 2015. Form 3 119 Fund/Department Name Month January Fund/Department Number 315 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 5,000 1,718 1,718 917 - 3,282 34% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 5,000 1,718 1,718 917 - 3,282 34% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 5,000 367 367 317 - 4,633 7% 5,000 367 367 317 - 4,633 7% Net- 1,351 1,351 599 - (1,351) Cash Balance 1,038,904 1,038,904 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Total Expenditures Staffing This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. 2016 City of South Bend Monthly Financial Report Redevelopment Bond - Airport Taxable Expenditures Revenue Form 3 120 Fund/Department Name Month January Fund/Department Number 317 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,800 841 841 446 - 959 47% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,800 841 841 446 - 959 47% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 1,800 841 841 446 - 959 Cash Balance 508,660 505,349 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Coveleski Debt Service Reserve Expenditures Revenue Total Expenditures Staffing Debt service reserve fund. The fund is at the proper level per the bond financial advisor, Crowe Horwath. No additional transfers-in are needed. Any interest variations due to City policy on investments and increase in cash available to earn interest. Form 3 121 Fund/Department Name Month January Fund/Department Number 328 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 6,000 2,870 2,870 1,532 - 3,130 48% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 6,000 2,870 2,870 1,532 - 3,130 48% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 6,000 614 614 530 - 5,386 10% 6,000 614 614 530 - 5,386 10% Net- 2,257 2,257 1,002 - (2,257) Cash Balance 1,735,840 1,735,840 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Total Expenditures Staffing 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. 2016 City of South Bend Monthly Financial Report Redevelopment Bond - Palais Royale Expenditures Revenue Form 3 122 Fund/Department Name Month January Fund/Department Number 432 Date Updated 2/17/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 25,000 8,776 8,776 5,246 - 16,224 35% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 25,000 8,776 8,776 5,246 - 16,224 35% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,000 - - - - 1,000 0% Debt Service 489,503 365,835 365,835 357,545 - 123,668 75% Capital- - - - - - 0% Transfers Out- - - - - - 0% 490,503 365,835 365,835 357,545 - 124,668 75% Net(465,503) (357,059) (357,059) (352,299) - (108,444) Cash Balance 4,945,336 6,150,556 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - Southside Development #3 Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to pay debt service. We will not be requesting additional funds from the TIF. The first opportunity to pay off the bond will be February 2017. The plan is to payoff the bond at that time along with the prepayment penalty. $201,724 payment in 2015 is return of prior year taxes to St. Joseph County. Form 3 123