Loading...
HomeMy WebLinkAbout02-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 100 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 February 29, 2016 Administration/Finance February 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 February 29, 2016, total revenue for the year was $33,517,175, 12% of estimated revenue. As of February 28, 2015  total revenue received was $28,896,533 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 February 29, 2016, total expenditures were $49,238,024 and outstanding encumbrances were $54,313,676, a   total  of  $103,551,700 which  represents  29%  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 14% of the amended expenditure budget at the end of the period.   Total expenditures were  $46,877,988 as of February 28, 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 February 29, 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,104,802 2,122,170 2,401,706 1,586,585 4% Special Revenue 102 Rainy Day 40,000 3,184 17,573 9,518 22,427 44% 103 Excess Levy 20 1 7 1 13 37% 201 Parks & Recreation 11,179,799 103,101 219,680 296,731 10,960,119 2% 202 Motor Vehicle Highway 9,181,883 254,903 1,403,673 1,849,479 7,778,210 15% 203 Recreation Nonreverting 1,448,565 87,227 146,373 164,208 1,302,192 10% 209 Studebaker-Oliver Reverting Grants 587,250 405 6,735 4,572 580,515 1% 210 Economic Development State Grants 73,511 -18,038 360 55,473 25% 211 Department of Community Investment (DCI)2,647,925 5,114 532,209 517,957 2,115,716 20% 212 Dept of Community Investment Grants 3,800,000 153,909 433,008 221,896 3,366,992 11% 216 Police State Seizures 36,000 3,253 15,494 203 20,506 43% 217 Gift, Donation, Bequest 185,800 39 146 2,607 185,654 0% 218 Police Curfew Violations 1,000 54 88 13 912 9% 219 Unsafe Building 985,240 37,823 398,194 - 587,046 40% 220 Law Enforcement Continuing Education 218,000 27,444 58,149 53,318 159,851 27% 227 Loss Recovery 1,410 614 2,262 9,213 (852) 160% 244 Emergency Phone System- --19 - 0% 249 Public Safety LOIT 6,797,160 566,039 1,133,050 1,079,066 5,664,110 17% 251 Local Roads & Streets 1,269,000 115,867 421,238 177,937 847,762 33% 258 Human Rights Federal Grant 165,040 3,921 125,501 9,252 39,539 76% 271 Eastrace Waterway 30 0 3 6 27 9% 273 Morris PAC / Palais Royale Marketing 18,150 911 1,311 280 16,839 7% 280 Police Block Grants- 1 8 4 (8) 0% 281 Economic Develop. Commission-Revenue Bonds 150 10 55 30 95 37% 289 HAZMAT 10,000 12 65 13,828 9,935 1% 291 Indiana River Rescue 45,200 11,435 16,989 5,516 28,211 38% 292 Police Grants- --55 - 0% 294 Regional Police Academy 22,500 6,928 15,495 18,639 7,005 69% 295 COPS MORE Grant 92,000 8,214 9,305 1,345 82,695 10% 299 Police Federal Drug Enforcement 162,000 115 209 1,899 161,791 0% 404 County Option Income Tax 10,332,984 836,789 1,835,417 1,579,828 8,497,567 18% 408 Economic Development Income Tax 10,159,262 803,193 1,768,975 1,691,411 8,390,287 17% 410 Urban Development Action Grant 169,827 196 1,335 30 168,492 1% 655 Project Releaf 437,290 36,779 74,889 73,791 362,401 17% 705 Police K-9 Unit 2,020 1 8 504 2,012 0% Special Revenue Total 60,069,016 3,067,481 8,655,482 7,783,517 51,413,534 14% City Debt Service 313 Football Hall of Fame Debt Service 1,383,212 9,343 18,686 8,554 1,364,526 1% City Debt Service Total 1,383,212 9,343 18,686 8,554 1,364,526 1% Capital Project 377 Professional Sports Development 709,718 47,553 221,294 236,340 488,424 31% 401 Coveleski Stadium Capital 15,200 30 167 45 15,033 1% 403 Zoo Endowment 200 18 100 54 100 50% 405 Park Nonreverting Capital 162,500 446 1,370 4,695 161,130 1% 406 Cumulative Capital Development 526,737 4,594 9,930 9,314 516,807 2% 407 Cumulative Capital Improvement 435,700 144 150,647 267 285,053 35% 412 Major Moves Construction 1,048,178 587,379 590,953 372,166 457,225 56% 416 Morris Performing Arts Center Capital 102,000 2,891 8,821 9,855 93,179 9% 434 Community Revitalization Enhancement District- 56 101 55 (101) 0% 450 Palais Royale Historic Preservation 17,300 2,145 2,271 2,248 15,029 13% 677 Football Hall of Fame Capital 2,000 184 1,017 617 983 51% Capital Project Total 3,019,533 645,440 986,670 635,655 2,032,863 33% Enterprise 287 Emergency Medical Services Capital 2,075,500 1,308,699 1,312,957 396,727 762,543 63% 288 Emergency Medical Services Operating 5,085,012 497,776 974,737 373,460 4,110,275 19% 600 Consolidated Building Fund 3,517,968 88,486 758,782 835,494 2,759,186 22% 601 Parking Garages 1,052,226 87,084 175,208 146,283 877,018 17% 610 Solid Waste Operations 5,596,749 459,788 865,787 810,024 4,730,962 15% 611 Solid Waste Capital 925,397 25 251,036 190,033 674,361 27% 620 Water Works Operations 14,604,116 1,093,751 2,173,103 2,124,545 12,431,013 15% 622 Water Works Capital 15,000 1,055 5,823 3,457 9,177 39% 623 Water Works Bond Capital- --221 - 0% 624 Water Works Customer Deposit 8,400 553 3,055 1,630 5,345 36% 625 Water Works Sinking 2,049,681 170,519 341,581 341,019 1,708,100 17% 626 Water W orks Bond Reserve 9,500 589 3,250 1,778 6,250 34% 629 Water Works Reserve Operations & Maintenance 175,166 228,278 231,975 152,523 (56,809) 132% 640 Sewer Repair Insurance 564,725 52,457 107,285 104,643 457,440 19% 641 Sewage Works Operations 36,711,600 3,023,545 5,997,024 5,575,864 30,714,576 16% 642 Sewage Works Capital 2,532,000 3,000 17,620 4,199 2,514,380 1% 643 Sewage Works Reserve Operations & Maint.552,997 898,070 904,153 259,853 (351,156) 164% 3 City of South Bend Monthly Department Financial Report REVENUE SUMMARY February 29, 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 Sinking9,274,391 761,612 1,524,111 1,548,123 7,750,280 16% 653 Sewage Debt Service Reserve- -25 - (25) 0% 659 Sewer Bond 2011 2,000 85 469 1,807 1,531 23% 661 Sewer Bond 2012 25,000 5,057 28,135 18,638 (3,135) 113% 664 2013A Cost of Issuance Fund- 2 9 5 (9) 0% 666 2015 Sewer Bond Issuance- 5 81 - (81) 0% 670 Century Center 3,983,787 396,920 1,187,093 816,489 2,796,694 30% 671 Century Center Capital 500 79 164 45 336 33% 672 Century Center Energy Conservation Debt Svc 237,132 4 8 - 237,124 0% Enterprise Total 88,998,847 9,077,439 16,863,472 13,706,859 72,135,375 19% Internal Service 222 Central Services 8,234,637 671,636 1,233,040 1,344,491 7,001,597 15% 224 Central Services Capital 130,519 68 382 - 130,137 0% 226 Liability Insurance 2,253,983 199,828 390,641 207,451 1,863,342 17% 278 Take Home Vehicle Police 64,400 9,197 19,197 24,049 45,203 30% 279 311 Call Center 499,358 39,201 77,979 - 421,379 16% 711 Self-Funded Employee Benefits 17,174,845 1,364,497 2,753,292 2,474,946 14,421,553 16% 713 Unemployment Compensation 107,282 1,837 2,282 17,211 105,000 2% Internal Service Total 28,465,024 2,286,264 4,476,813 4,068,148 23,988,211 16% Trust & Agency 701 Firefighters Pension 5,447,592 131 1,061 818 5,446,531 0% 702 Police Pension 6,133,500 374 2,462 1,363 6,131,038 0% 730 City Cemetery 150 10 58 31 92 38% Trust & Agency Total 11,581,242 516 3,580 2,212 11,577,662 0% City Funds Total 247,369,242 16,191,284 33,126,874 28,606,652 164,098,755 13% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River W est Development Area (Airport TIF)18,885,314 39,097 101,661 83,579 18,783,653 1% 420 Tax Incremental Financing (TIF) - Downtown- --4,935 - 0% 422 TIF - West Washington 424,000 552 3,029 1,257 420,971 1% 425 Redevelopment Retail & Leighton Plaza 172,003 10,732 22,153 31,199 149,850 13% 426 TIF - Central Medical Service Area- --2,442 - 0% 429 River East Development Area (NE Dev TIF)2,757,000 2,739 15,244 24,208 2,741,756 1% 430 TIF - Southside Development #1 2,433,000 2,233 12,174 5,168 2,420,826 1% 435 TIF - Douglas Road 320,750 56 289 209 320,461 0% 436 River East Residential (NE Res TIF)3,162,422 -213,108 1,567 2,949,314 7% Tax Increment Financing Total 28,154,489 55,409 367,659 154,564 27,786,830 1% Redevelopment 433 Redevelopment General 152 3 18 11 134 12% 439 Certified Technology Park 14,637 833 4,625 5,529 10,012 32% 454 Airport Urban Enterprise Zone 1,500 139 767 416 733 51% 619 Blackthorn Operations- --119,238 - 0% Redevelopment Total 16,289 975 5,410 125,194 10,879 33% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 380 2,098 1,143 2,902 42% 317 Coveleski Debt Service Reserve 1,800 186 1,027 556 773 57% 328 Redevelopment Bond - Palais Royale 6,000 635 3,505 1,911 2,495 58% 432 TIF - Southside Development #3 25,000 1,827 10,603 6,514 14,397 42% Debt Service Total 37,800 3,028 17,232 10,124 20,568 46% Redevelopment Commission Controlled Funds Total 28,208,578 59,411 390,301 289,882 27,818,277 1% Grand Total 275,577,820 16,250,696 33,517,175 28,896,533 191,917,032 12% 4 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY February 29, 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 48,772 110,889 133,014 133 638,861 15% 101-0104 311 Call Center 5,933 1,629 1,629 91,485 4,304 - 100% 101-0201 City Clerk 443,475 31,491 62,546 63,045 36,308 344,620 22% 101-0301 Common Council 522,735 59,981 101,524 58,672 99,089 322,122 38% 101-0302 WNIT Contract 43,000 - - - - 43,000 0% 101-0401 Administration & Finance 2,227,488 141,679 272,593 321,801 65,581 1,889,314 15% 101-0404 Morris Performing Arts Center 1,129,897 84,588 160,131 184,428 70,652 899,114 20% 101-0405 Palais Royale 498,438 48,725 85,311 73,017 57,008 356,119 29% 101-0501 Legal Department 1,036,772 76,476 152,189 172,307 19,108 865,476 17% 101-0602 Engineering 1,225,137 91,788 152,456 152,601 95,043 977,638 20% 101-0801 Police Department 26,399,474 1,836,379 3,676,251 4,436,141 131,167 22,592,056 14% 101-0802 Communications Center 1,479,012 - - 135,128 1,479,012 - 100% 101-0901 Fire Department 18,185,989 1,406,545 2,756,238 3,740,818 329,029 15,100,722 17% 101-0905 Fire LOIT 2013- - - 411 - - 0% 101-1008 Human Rights 371,226 31,288 59,082 82,219 8,422 303,722 18% 101-0805 Police LOIT 2013- - - 8,761 - - 0% 101-1201 Code Enforcement 202,164 0 202,164 0 0 0 100% General Fund Total 54,520,623 3,859,341 7,793,003 9,653,851 2,394,856 44,332,764 19% Special Revenue 103 Excess Levy 3,688 3,648 3,648 - - 40 99% 201 Parks & Recreation 11,248,697 747,429 1,454,952 1,985,723 441,025 9,352,720 17% 202 Motor Vehicle Highway 10,977,409 713,525 1,487,910 1,837,952 475,445 9,014,054 18% 203 Recreation Nonreverting 1,459,754 57,650 92,606 104,855 124,271 1,242,877 15% 209 Studebaker-Oliver Reverting Grants 1,683,250 18,732 23,232 3,375 460,019 1,200,000 29% 210 Economic Development State Grants 1,935,497 604,022 1,462,492 12,200 427,003 46,002 98% 211 Department of Community Investment (DCI)2,687,313 183,367 377,158 429,372 52,837 2,257,318 16% 212 Dept of Community Investment Grants 7,356,963 153,095 372,358 253,738 3,159,723 3,825,382 48% 216 Police State Seizures 36,000 - - - - 36,000 0% 217 Gift, Donation, Bequest 362,500 - - 27,830 - 362,500 0% 218 Police Curfew Violations 1,000 - - - - 1,000 0% 219 Unsafe Building 0 14,797 14,797 0 124,063(138,860)0% 220 Law Enforcement Continuing Education 743,508 35,846 52,727 45,004 9,600 681,181 8% 227 Loss Recovery 480,311 3,200 3,208 480,270 127,103 350,000 27% 244 Emergency Phone System- - - 21 - - 0% 249 Public Safety LOIT 6,600,626 492,883 1,014,278 1,247,402 - 5,586,348 15% 251 Local Roads & Streets 2,242,944 139,680 216,660 9,007 788,444 1,237,841 45% 258 Human Rights Federal Grant 221,838 12,344 25,260 31,228 17,839 178,739 19% 273 Morris PAC / Palais Royale Marketing 18,878 - - 96 878 18,001 5% 289 HAZMAT 10,000 - - 21,542 - 10,000 0% 291 Indiana River Rescue 95,300 1,311 2,511 2,120 - 92,789 3% 292 Police Grants 55,373 5,929 12,637 15,296 42,735 1 100% 294 Regional Police Academy 22,500 50 301 12,398 - 22,199 1% 295 COPS MORE Grant 102,245 4,039 4,746 21,274 10,245 87,254 15% 299 Police Federal Drug Enforcement 168,965 1,290 1,290 24,859 6,964 160,711 5% 404 County Option Income Tax 15,162,148 702,384 2,898,030 2,119,512 2,350,107 9,914,011 35% 408 Economic Development Income Tax 10,560,181 59,872 2,252,628 2,372,293 683,300 7,624,254 28% 410 Urban Development Action Grant 238,173 - 146,068 - - 92,106 61% 655 Project Releaf 528,358 2,629 17,223 17,638 - 511,135 3% 705 Police K-9 Unit 2,020 - - - - 2,020 0% Special Revenue Total 75,005,439 3,957,721 11,936,718 11,075,005 9,301,599 53,767,622 28% City Debt Service 313 Football Hall of Fame Debt Service 1,268,015 - 636,000 636,000 - 632,015 50% City Debt Service Total 1,268,015 - 636,000 636,000 - 632,015 50% Capital Project 377 Professional Sports Development 838,052 800 473,088 481,573 - 364,965 56% 401 Coveleski Stadium Capital- 22,000 22,000 - - (22,000) 0% 405 Park Nonreverting Capital 268,333 - - - 39,763 228,570 15% 406 Cumulative Capital Development 526,737 - 112,650 112,650 - 414,087 21% 407 Cumulative Capital Improvement 365,907 - 184,125 183,750 - 181,782 50% 412 Major Moves Construction 2,385,033 312,495 312,605 209,388 632,064 1,440,364 40% 416 Morris Performing Arts Center Capital 78,923 10,464 10,464 2,933 7,445 61,014 23% 434 Community Revitalization Enhancement District- - - 3,897 - - 0% 677 Football Hall of Fame Capital 84,801 15,819 20,477 13,213 229 64,095 24% Capital Project Total 4,547,786 361,579 1,135,409 1,007,404 679,500 2,732,876 40% Enterprise 287 Emergency Medical Services Capital 2,247,611 - - 35,728 363,611 1,884,000 16% 288 Emergency Medical Services Operating 6,115,643 370,131 952,398 280,257 115,869 5,047,376 17% 600 Consolidated Building Fund 4,450,974 278,838 582,013 507,424 284,362 3,584,599 19% 601 Parking Garages 1,393,469 5,924 117,638 202,631 710,528 565,303 59% 610 Solid Waste Operations 5,597,412 359,794 1,018,151 976,539 799,224 3,780,037 32% 611 Solid Waste Capital 925,197 236 251,115 223,892 1,025 673,057 27% 5 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY February 29, 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 620 Water Works Operations 16,984,657 1,527,644 2,583,488 2,313,834 770,605 13,630,564 20% 622 Water Works Capital 821,797 - - 82,845 177,797 644,000 22% 623 Water Works Bond Capital- - - 49,028 - - 0% 624 Water Works Customer Deposit 8,400 553 1,087 776 - 7,313 13% 625 Water Works Sinking 2,049,681 14 565 467 - 2,049,116 0% 626 Water Works Bond Reserve 9,500 - - - - 9,500 0% 629 Water Works Reserve Operations & Maintenance 10,000 817 1,608 1,092 - 8,392 16% 640 Sewer Repair Insurance 549,413 24,473 57,071 78,593 24,901 467,441 15% 641 Sewage Works Operations 39,736,144 3,137,550 5,679,409 5,120,884 2,598,519 31,458,217 21% 642 Sewage Works Capital 7,631,946 53,387 688,430 86,219 4,480,628 2,462,888 68% 643 Sewage Works Reserve Operations & Maint.16,000 1,345 2,646 1,792 - 13,354 17% 649 Sewage Sinking 9,274,298 500 1,850 1,850 - 9,272,448 0% 659 Sewer Bond 2011 172,088 - - 645,836 172,088 - 100% 661 Sewer Bond 2012 20,187,062 1,143,403 1,261,739 288,246 11,693,646 7,231,677 64% 666 2015 Sewer Bond Issuance 0 0 2,500 0 0 (2,500)0% 670 Century Center 3,972,438 310,741 640,098 591,945 - 3,332,340 16% 671 Century Center Capital- - - 66,156 - - 0% 672 Century Center Energy Conservation Debt Svc 237,132 - - - - 237,132 0% Enterprise Total 122,390,862 7,215,351 13,841,804 11,556,034 22,192,804 86,356,254 29% Internal Service 222 Central Services 8,289,479 631,085 1,175,486 1,301,399 2,900,743 4,213,250 49% 224 Central Services Capital 305,584 23,369 23,369 - 151,696 130,519 57% 226 Liability Insurance 3,120,348 236,647 334,089 517,792 114,277 2,671,983 14% 278 Take Home Vehicle Police 10,000 - 53 - - 9,947 1% 279 311 Call Center 499,357 39,201 77,979 0 0 421,378 16% 711 Self-Funded Employee Benefits 17,378,890 1,803,358 2,437,671 1,994,397 1,000,503 13,940,716 20% 713 Unemployment Compensation 113,882 7,828 9,315 15,294 2,200 102,367 10% Internal Service Total 29,717,540 2,741,490 4,057,961 3,828,881 4,169,419 21,490,159 28% Trust & Agency 701 Firefighters Pension 5,464,843 402,025 829,191 882,468 - 4,635,652 15% 702 Police Pension 6,797,398 528,448 1,044,900 1,061,124 - 5,752,498 15% 730 City Cemetery 20,000 - - - - 20,000 0% Trust & Agency Total 12,282,241 930,473 1,874,091 1,943,591 - 10,408,150 15% City Funds Total 299,732,506 19,065,953 41,274,988 39,700,765 38,738,178 219,719,840 27% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF)31,502,077 1,454,126 5,518,560 3,961,430 9,677,081 16,306,436 48% 420 Tax Incremental Financing (TIF) - Downtown- - - 6,768 - - 0% 422 TIF - West Washington 1,403,366 3,366 3,366 15,300 313,800 1,086,200 23% 425 Redevelopment Retail & Leighton Plaza 160,406 4,849 9,330 16,624 - 151,076 6% 429 River East Development Area (NE Dev TIF)8,335,159 3,701 85,611 117,956 4,278,139 3,971,408 52% 430 TIF - Southside Development #1 7,411,815 153,970 154,250 459,801 1,159,364 6,098,201 18% 435 TIF - Douglas Road 354,200 140,000 140,000 169,620 4,200 210,000 41% 436 River East Residential (NE Res TIF)3,430,000 446,589 1,684,089 1,710,589 - 1,745,911 49% Tax Increment Financing Total 52,597,023 2,206,601 7,595,206 6,458,088 15,432,585 29,569,232 44% 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- - - 158,413 - - 0% Redevelopment Total 2,747,413 - - 158,413 142,913 2,604,500 5% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 380 747 544 - 4,253 15% 317 Coveleski Debt Service Reserve- - - - - - 0% 328 Redevelopment Bond - Palais Royale 6,000 635 1,248 909 - 4,752 21% 432 TIF - Southside Development #3 490,503 - 365,835 559,269 - 124,668 75% Debt Service Total 501,503 1,015 367,831 560,722 - 133,672 73% Redevelopment Commission Controlled Funds Total 55,845,939 2,207,615 7,963,037 7,177,224 15,575,498 32,307,404 42% Grand Total 355,578,445 21,273,568 49,238,024 46,877,988 54,313,676 252,027,245 29% 6 Fund/Department Name Month February Fund/Department Number 101-0101 Date Updated 3/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 749,283 48,732 110,689 132,980 - 638,594 15% 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 40 200 - - 400 33% Transfers In- - - - - - 0% Total Revenue 749,883 48,772 110,889 133,014 - 638,994 15% Personnel 685,492 43,841 95,051 120,279 - 590,441 14% Supplies 3,662 630 682 1,558 119 2,861 22% Services 60,139 4,153 15,008 11,030 14 45,117 25% Debt Service 590 147 147 147 - 443 25% Capital- - - - - - 0% Transfers Out- - - - - - 0% 749,883 48,772 110,889 133,014 133 638,861 15% Net- - - - (133) 133 Cash Balance- - Full Time 7.00 6.00 6.00 Part-Time /Seasonal/Temporary 2.00 1.00 1.00 Total 9.00 7.00 7.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 2016. 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. Currently, the Mayor's office is down one position as the position of Deputy Chief of Staff to the Mayor, is vacant. Form 37 Fund/Department Name Month February Fund/Department Number 101-0104 Date Updated 3/14/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 1,629 1,629 - - 4,304 27% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 91,485 - - 0% Transfers In- - - - - - 0% Total Revenue 5,933 1,629 1,629 91,485 - 4,304 27% Personnel- - - 80,083 - - 0% Supplies 2,350 1,629 1,629 647 721 - 100% Services 3,583 - - 10,755 3,583 - 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 5,933 1,629 1,629 91,485 4,304 - 100% Net- - - - (4,304) 4,304 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 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 38 Fund/Department Name Month February Fund/Department Number 101-0201 Date Updated 3/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 443,475 31,491 62,546 63,045 - 380,929 14% 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,491 62,546 63,045 - 380,929 14% Personnel 332,855 23,532 54,008 57,004 - 278,847 16% Supplies 7,582 2,369 2,438 144 796 4,348 43% Services 103,038 5,591 6,101 5,897 35,512 61,425 40% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 443,475 31,491 62,546 63,045 36,308 344,620 22% Net- - - - (36,308) 36,308 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 39 Fund/Department Name Month February Fund/Department Number 101-0301 Date Updated 3/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 522,485 59,981 101,524 58,601 - 420,961 19% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations 250 - - 71 - 250 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 522,735 59,981 101,524 58,672 - 421,211 19% Personnel 279,671 21,093 42,132 38,759 35,776 201,763 28% Supplies 8,936 4,946 5,108 370 946 2,882 68% Services 234,128 33,942 54,283 19,543 62,367 117,478 50% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 522,735 59,981 101,524 58,672 99,089 322,122 38% Net- - - - (99,089) 99,089 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. One member has declined to take a salary. Expenditures higher than normal in the services category due to unforseen legal expenses. Form 310 Fund/Department Name Month February Fund/Department Number 101-0302 Date Updated 3/14/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. The invoice was received 1 April and was paid 1 May. Form 311 Fund/Department Name Month February Fund/Department Number 101-0401 Date Updated 3/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 141,679 259,045 321,581 - 1,958,393 12% 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 220 - (3,498) 135% Transfers In- - - - - - 0% Total Revenue 2,227,488 141,679 272,593 321,801 - 1,954,895 12% Personnel 1,978,924 128,398 252,984 308,509 - 1,725,940 13% Supplies 42,034 2,532 3,249 3,642 4,693 34,092 19% Services 201,358 10,749 15,717 9,008 60,888 124,753 38% Debt Service 5,172 - 643 643 - 4,529 12% Capital- - - - - - 0% Transfers Out- - - - - - 0% 2,227,488 141,679 272,593 321,801 65,581 1,889,314 15% Net- - - - (65,581) 65,581 Cash Balance- - Full Time 23.00 20.00 Part-Time /Seasonal/Temporary- 1.00 Total 23.00 21.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 312 Fund/Department Name Month February Fund/Department Number 101-0404 Date Updated 3/14/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 60,106 104,032 107,799 - 75,865 58% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 943,000 24,482 56,099 74,945 - 886,901 6% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 7,000 - - 1,684 - 7,000 0% Transfers In- - - - - - 0% Total Revenue 1,129,897 84,588 160,131 184,428 - 969,766 14% Personnel 823,612 58,273 114,037 132,414 100 709,475 14% Supplies 22,698 506 1,192 3,110 10,368 11,137 51% Services 283,587 25,809 44,902 48,904 60,184 178,501 37% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,129,897 84,588 160,131 184,428 70,652 899,114 20% Net- - - - (70,652) 70,652 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 New Catering Contract in effect starting with February 2016 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 313 Fund/Department Name Month February Fund/Department Number 101-0405 Date Updated 3/14/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 39,699 69,523 39,302 - 47,895 40% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 301,572 8,470 14,993 31,390 - 286,579 5% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 22,440 555 795 2,325 - 21,645 4% Transfers In- - - - - - 0% Total Revenue 498,438 48,725 85,311 73,017 - 356,119 17% Personnel 244,557 20,948 41,361 44,686 - 203,196 17% Supplies 28,855 7,075 7,639 909 3,208 18,007 38% Services 225,026 20,701 36,311 27,422 53,799 134,916 40% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 498,438 48,725 85,311 73,017 57,008 356,119 29% Net- - - - (57,008) - 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 314 Fund/Department Name Month February Fund/Department Number 101-0501 Date Updated 3/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 76,476 152,189 171,799 - 834,583 15% 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 - - 508 - 50,000 0% Transfers In- - - - - - 0% Total Revenue 1,036,772 76,476 152,189 172,307 - 884,583 15% Personnel 984,630 73,325 146,385 164,877 - 838,245 15% Supplies 3,712 - 247 1,000 15 3,450 7% Services 47,158 2,833 5,240 6,112 19,092 22,826 52% Debt Service 1,272 318 318 318 - 954 25% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,036,772 76,476 152,189 172,307 19,108 865,476 17% Net- - - - (19,108) 19,108 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 315 Fund/Department Name Month February Fund/Department Number 101-0602 Date Updated 3/14/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 89,887 118,432 152,601 - 972,256 11% 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 1,901 34,024 - - 100,425 25% Transfers In- - - - - - 0% Total Revenue 1,225,137 91,788 152,456 152,601 - 1,072,681 12% Personnel 776,239 45,318 96,462 103,029 - 679,777 12% Supplies 66,447 17,949 18,398 4,203 22,231 25,818 61% Services 358,063 27,872 33,519 42,167 70,869 253,676 29% Debt Service 24,388 648 4,076 3,202 1,944 18,368 25% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,225,137 91,788 152,456 152,601 95,043 977,638 20% Net- - - - (95,043) 95,043 Cash Balance- - Full Time 7.93 7.45 Part-Time /Seasonal/Temporary 1.41 1.41 Total 9.34 8.86 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 The Engineering Department oversees the design and execution of the City's construction projects. $22K in encumbrance for Supplies is for the continued remodeling of the Engineering offices. $70K in encumbrance for Services include $56K for updating the City construction standards and $11K for office remodeling. Other income includes reimbursement from the River West TIF for 80% of the salary of an engineer. Staffing includes a mis-allocated Permits Manager that will be corrected in March and is otherwise short by two positions. Form 316 Fund/Department Name Month February Fund/Department Number 101-0801 Date Updated 3/14/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,775,974 3,574,218 4,418,164 - 22,487,556 14% 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 60,405 102,033 17,977 - 228,167 31% Transfers In- - - - - - 0% Total Revenue 26,399,474 1,836,379 3,676,251 4,436,141 - 22,723,223 14% Personnel 23,573,968 1,621,116 3,321,434 4,017,475 2,768 20,249,766 14% Supplies 346,456 29,133 36,743 96,799 71,919 237,794 31% Services 2,471,050 185,694 316,979 320,587 56,480 2,097,591 15% Debt Service 8,000 436 1,095 1,280 - 6,905 14% Capital- - - - - - 0% Transfers Out- - - - - - 0% 26,399,474 1,836,379 3,676,251 4,436,141 131,167 22,592,056 14% Net- - - - (131,167) 131,167 Cash Balance- - Full Time 268.00 260.00 260.00 Part-Time /Seasonal/Temporary 60.00 25.00 25.00 Total 328.00 285.00 285.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 317 Fund/Department Name Month February Fund/Department Number 101-0802 Date Updated 3/14/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,128 - 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,128 - 1,479,012 0% Personnel- - - 135,128 - - 0% Supplies- - - - - - 0% Services 1,479,012 - - - 1,479,012 - 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,479,012 - - 135,128 1,479,012 - 100% Net- - - - (1,479,012) 1,479,012 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. Payments are made to the county on a monthly basis. Form 318 Fund/Department Name Month February Fund/Department Number 101-0901 Date Updated 3/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 18,173,989 1,396,443 2,745,454 3,671,171 15,428,535 15% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 6,000 67 749 66,699 - 5,251 12% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 6,000 10,035 10,035 2,948 - (4,035) 167% Transfers In- - - - - - 0% Total Revenue 18,185,989 1,406,545 2,756,238 3,740,818 - 15,429,751 15% Personnel 16,320,838 1,241,828 2,475,921 3,525,188 125,217 13,719,700 16% Supplies 387,643 25,985 35,887 21,698 81,628 270,128 30% Services 1,477,508 138,732 244,430 193,932 122,184 1,110,894 25% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 18,185,989 1,406,545 2,756,238 3,740,818 329,029 15,100,722 17% Net- - - - (329,029) 329,029 Cash Balance- - Full Time 181.00 175.00 Part-Time /Seasonal/Temporary- - Total 181.00 175.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 that fund. 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 250 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 319 Fund/Department Name Month February Fund/Department Number 101-1008 Date Updated 3/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 371,226 31,288 59,082 82,219 - 312,144 16% 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 31,288 59,082 82,219 - 312,144 16% Personnel 298,643 22,644 45,031 61,652 - 253,612 15% Supplies 1,546 33 239 134 500 807 48% Services 71,037 8,611 13,812 10,026 7,922 49,303 31% Debt Service- - - - - - 0% Capital- - - 10,407 - - 0% Transfers Out- - - - - - 0% 371,226 31,288 59,082 82,219 8,422 303,722 18% Net- - - - (8,422) 8,422 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 320 Fund/Department Name Month February Fund/Department Number 101-1201 Date Updated 3/14/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 - - (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 - - (0) 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 202,164 - 202,164 - - (0) 100% 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 321 Fund/Department Name Month February Fund/Department Number 102 Date Updated 3/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- - - - - - 0% Interest Earnings 40,000 3,184 17,573 9,518 - 22,427 44% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 40,000 3,184 17,573 9,518 - 22,427 44% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 40,000 3,184 17,573 9,518 - 22,427 Cash Balance 8,709,680 8,651,706 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 322 Fund/Department Name Month Februay Fund/Department Number 103 Date Updated 3/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- - - - - - 0% Interest Earnings 20 1 7 1 - 13 37% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 20 1 7 1 - 13 37% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 3,688 3,648 3,648 - - 40 99% 3,688 3,648 3,648 - - 40 99% Net(3,668) (3,647) (3,641) 1 - (27) Cash Balance 25 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 was transferred into the General Fund in 2016. Form 323 Fund/Department Name Month February Fund/Department Number 201 Date Updated 3/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 154,378 147,473 - 1,426,887 10% Grants/Intergovernmental- - - - - - 0% Charges for Services 1,946,740 16,570 40,078 108,490 - 1,906,662 2% Interest Earnings 10,000 1,278 10,913 3,371 - (913) 109% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 154,794 8,064 14,311 37,397 - 140,483 9% Transfers In- - - - - - 0% Total Revenue 11,179,799 103,101 219,680 296,731 - 10,960,119 2% Personnel 7,222,560 478,166 998,205 1,111,410 5,000 6,219,355 14% Supplies 1,139,754 95,620 115,823 87,767 353,753 670,178 41% Services 2,574,261 171,529 320,924 785,319 82,272 2,171,064 16% Debt Service 176,622 2,113 19,999 1,228 - 156,623 11% Capital 50,000 - - - 50,000 0% Transfers Out 85,500 - - - 85,500 0% 11,248,697 747,429 1,454,952 1,985,723 441,025 9,352,720 17% Net(68,898) (644,328) (1,235,272) (1,688,992) (441,025) 1,607,399 Cash Balance 2,707,919 1,809,440 Full Time 90.00 89.00 89.00 Part-Time /Seasonal/Temporary na 87.00 87.00 Total 90.00 176.00 176.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 324 Fund/Department Name Month February Fund/Department Number 202 Date Updated 3/14/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 229,490 508,856 962,107 4,591,144 10% Grants/Intergovernmental- - 0% Charges for Services 366,433 23,217 43,963 43,022 322,470 12% Interest Earnings 9,100 1,896 10,723 4,347 (1,623) 118% Bond Proceeds- - 0% Donations- - 0% Other Income 3,350 299 1,882 1,753 1,468 56% Transfers In 3,703,000 838,250 838,250 2,864,750 23% Total Revenue 9,181,883 254,903 1,403,673 1,849,479 - 7,778,210 15% Personnel 4,411,058 325,205 650,044 826,397 3,761,014 15% Supplies 2,628,660 170,859 305,989 508,908 288,338 2,034,332 23% Services 3,170,906 217,460 411,105 467,010 187,106 2,572,695 19% Debt Service 677,327 81,314 35,637 596,013 12% Capital 89,458 39,458 50,000 44% Transfers Out- - 0% 10,977,409 713,525 1,487,910 1,837,952 475,445 9,014,054 18% Net(1,795,526) (458,621) (84,237) 11,528 (475,445) (1,235,844) Cash Balance 5,194,722 3,891,890 Full Time 52.91 49.96 Part-Time /Seasonal/Temporary 3.14 2.22 Total 56.05 52.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 325 Fund/Department Name Month February Fund/Department Number 203 Date Updated 3/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 1,432,565 86,916 144,670 152,067 - 1,287,895 10% Interest Earnings 6,000 311 1,676 896 - 4,324 28% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 10,000 - 26 11,245 - 9,974 0% Transfers In- - - - - - 0% Total Revenue 1,448,565 87,227 146,373 164,208 - 1,302,192 10% Personnel 655,619 29,320 54,076 62,096 - 601,543 8% Supplies 307,068 11,631 13,243 25,398 61,001 232,824 24% Services 497,067 16,699 25,287 13,810 40,270 431,510 13% Debt Service- - - - - - 0% Capital- - - - 23,000 (23,000) 0% Transfers Out- - 3,550 - - 0% 1,459,754 57,650 92,606 104,855 124,271 1,242,877 15% Net(11,189) 29,577 53,767 59,353 (124,271) 59,315 Cash Balance 875,834 873,266 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 326 Fund/Department Name Month February Fund/Department Number 209 Date Updated 3/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 483,250 - 4,500 3,375 - 478,751 1% Charges for Services- - - - - - 0% Interest Earnings 4,000 405 2,235 1,197 - 1,765 56% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 100,000 - - - - 100,000 0% Transfers In- - - - - - 0% Total Revenue 587,250 405 6,735 4,572 - 580,515 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,683,250 18,732 23,232 3,375 460,019 1,200,000 29% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,683,250 18,732 23,232 3,375 460,019 1,200,000 29% Net(1,096,000) (18,328) (16,497) 1,197 (460,019) (619,484) Cash Balance 1,090,704 1,087,661 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 327 Fund/Department Name Month February Fund/Department Number 210 Date Updated 3/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 360 - 8,847 25% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 61,786 - 15,160 - - 46,626 25% Transfers In- - - - - - 0% Total Revenue 73,511 - 18,038 360 - 55,473 25% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 663,486 604,022 604,022 12,200 85,473 (26,009) 104% Debt Service 72,011 - - - - 72,011 0% Capital 1,200,000 - 858,470 - 341,530 - 100% Transfers Out- - - - - - 0% 1,935,497 604,022 1,462,492 12,200 427,003 46,002 98% Net(1,861,986) (604,022) (1,444,454) (11,840) (427,003) 9,471 Cash Balance(1,284,098) 317,593 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 328 Fund/Department Name Month February Fund/Department Number 211 Date Updated 3/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 2,800 36,085 24,444 - 212,915 14% Grants/Intergovernmental 419,287 - - - - 419,287 0% Charges for Services 2,000 - - 430 - 2,000 0% Interest Earnings 10,000 386 2,287 1,173 - 7,713 23% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- 1,428 1,428 - - (1,428) 0% Transfers In 1,967,638 500 492,410 491,910 - 1,475,229 25% Total Revenue 2,647,925 5,114 532,209 517,957 - 2,115,716 20% Personnel 2,161,561 151,486 312,110 357,253 - 1,849,451 14% Supplies 25,318 1,860 2,366 3,910 5,154 17,798 30% Services 463,434 30,021 62,681 68,209 47,683 353,070 24% Debt Service- - - - - - 0% Capital 37,000 - - - - 37,000 0% Transfers Out- - - - - - 0% 2,687,313 183,367 377,158 429,372 52,837 2,257,318 16% Net(39,388) (178,253) 155,052 88,584 (52,837) (141,603) Cash Balance 1,277,612 1,162,803 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 329 Fund/Department Name Month February Fund/Department Number 212 Date Updated 3/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 150,316 428,053 118,306 - 2,600,199 14% Charges for Services 1,000 30 30 110 - 970 3% Interest Earnings 2,000 105 826 674 - 1,174 41% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 768,748 3,457 4,099 102,806 - 764,649 1% Transfers In- - - - - - 0% Total Revenue 3,800,000 153,909 433,008 221,896 - 3,366,992 11% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Grants 7,356,963 152,595 371,858 253,738 3,159,723 3,825,382 48% Transfers Out- 500 500 - - (500) 0% 7,356,963 153,095 372,358 253,738 3,159,723 3,824,882 48% Net(3,556,963) 814 60,650 (31,842) (3,159,723) (457,890) Cash Balance 614,109 760,761 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--Community Development Block Grant; Emergency Solutions Grant; Shelter Plus Care; Neighborhood Stabiliation Project, etc.. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on-going and the timing of funding varies widely. We can only draw revenue in response to funds expended so revenues will come in as funds are spent. The federal government does not allow us to hold too much cash. Expenditures in 2016, as in previous years, will be made by outside not-for-profits for eligible activities such as: Homeownership Assistance; Housing Acquisition/Rehab/Resale; Owner-Occupied Housing Rehab; Spot Blight Clearance; Technical Assistance; Public Services; Public Facility Improvements; Emergency Shelter Operations; Rapid Re-housing; Shelter Plus Supportive Services; and New Housing Construction. All services must either assist low/moderate income households or eliminate slum & blight and/or other requirements specific to the particular grants. The not-for-profits can generally apply for funding for 2017 in the summer of 2016. Form 330 Fund/Department Name Month February Fund/Department Number 216 Date Updated 3/14/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 3,173 15,083 - - 19,917 43% Charges for Services- - - - - - 0% Interest Earnings 1,000 80 411 203 - 589 41% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - 0% Total Revenue 36,000 3,253 15,494 203 - 20,506 43% Personnel- - - - - - 0% Supplies- 0% Services 36,000 - - 36,000 0% Debt Service- - - - - 0% Capital- - - - - - 0% Transfers Out- 0% 36,000 - - - - 36,000 0% Net- 3,253 15,494 203 - (15,494) Cash Balance 215,232 187,635 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 331 Fund/Department Name Month February Fund/Department Number 217 Date Updated 3/14/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 24 131 152 - 669 16% Bond Proceeds- - - - - - 0% Donations 185,000 15 15 2,456 - 184,985 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 185,800 39 146 2,607 - 185,654 0% Personnel- - - - - - 0% Supplies 12,500 - - - - 12,500 0% Services 350,000 - - 27,830 - 350,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 362,500 - - 27,830 - 362,500 0% Net(176,700) 39 146 (25,223) - (176,846) Cash Balance 65,019 112,716 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 332 Fund/Department Name Month February Fund/Department Number 218 Date Updated 3/14/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 50 63 - - 837 7% Interest Earnings 100 4 25 13 - 75 25% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,000 54 88 13 - 912 9% Personnel- - - - - - 0% Supplies- - - - - 0% Services 1,000 - - - - 1,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,000 - - - - 1,000 0% Net- 54 88 13 - (88) Cash Balance 12,325 12,019 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 333 Fund/Department Name Month February Fund/Department Number 219 Date Updated 3/14/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 37,823 57,761 - 172,239 25% Interest Earnings- 0% Bond Proceeds- 0% Donations- 0% Other Income- 0% Transfers In 755,240 340,433 - 414,807 45% Total Revenue 985,240 37,823 398,194 - - 587,046 40% Personnel- 0% Supplies- 0% Services- 14,797 14,797 124,063 (138,860) 0% Debt Service- 0% Capital- 0% Transfers Out- 0% - 14,797 14,797 - 124,063 (138,860) 0% Net 985,240 23,026 383,398 - (124,063) 725,906 Cash Balance 383,868 - 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 334 Fund/Department Name Month February Fund/Department Number 220 Date Updated 3/14/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 21,102 50,105 46,435 - 149,895 25% Interest Earnings 5,000 334 1,841 1,061 - 3,159 37% Bond Proceeds- - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income 11,000 6,008 6,203 5,822 - 4,797 56% Transfers In- - - .- - 0% Total Revenue 218,000 27,444 58,149 53,318 - 159,851 27% Personnel- - - - - - 0% Supplies 285,508 - 408 6,498 9,600 275,500 4% Services 458,000 35,846 52,319 38,506 - 405,681 11% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 743,508 35,846 52,727 45,004 9,600 681,181 8% Net(525,508) (8,402) 5,422 8,314 (9,600) (521,330) Cash Balance 905,663 969,595 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 335 Fund/Department Name Month February Fund/Department Number 227 Date Updated 3/14/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 364 2,012 6,463 - (602) 143% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- 250 250 2,750 - (250) 0% Transfers In- - - - - - 0% Total Revenue 1,410 614 2,262 9,213 - (852) 160% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 422,302 - 8 423,670 72,294 350,000 17% Debt Service- - - - - - 0% Capital 58,009 3,200 3,200 56,600 54,809 - 100% Transfers Out- - - - - - 0% 480,311 3,200 3,208 480,270 127,103 350,000 27% Net(478,901) (2,586) (946) (471,056) (127,103) (350,852) Cash Balance 992,303 5,392,837 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. The $250 in Other Income was received in error for the 2016 Lamp Post Program, "Light Up South Bend". A correction will be made in March. The $72K encumbrance in Services is for the continuation of the vacant & abandoned housing program. Form 336 Fund/Department Name Month February Fund/Department Number 244 Date Updated 3/14/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- - - 21 - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 21 - - 0% Net- - - (2) - - Cash Balance 33,671 33,649 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 337 Fund/Department Name Month February Fund/Department Number 249 Date Updated 3/14/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 1,131,860 1,077,698 - 5,659,300 17% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 6,000 109 1,190 1,367 - 4,810 20% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 6,797,160 566,039 1,133,050 1,079,066 - 5,664,110 17% Personnel 6,600,626 492,883 1,014,278 1,247,402 - 5,586,348 15% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,600,626 492,883 1,014,278 1,247,402 - 5,586,348 15% Net 196,534 73,156 118,772 (168,336) - 77,762 Cash Balance 760,707 1,122,087 Full Time 70.00 70.00 Part-Time /Seasonal/Temporary- - Total 70.00 70.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 338 Fund/Department Name Month February Fund/Department Number 251 Date Updated 3/14/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 88,123 173,633 175,234 - 894,367 16% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 9,000 1,158 5,660 2,703 - 3,340 63% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 192,000 26,587 241,945 - - (49,945) 126% Transfers In- - - - - - 0% Total Revenue 1,269,000 115,867 421,238 177,937 - 847,762 33% Personnel- - - - - - 0% Supplies 469,668 - - - - 469,668 0% Services 412,369 61,017 125,634 - 106,562 180,174 56% Debt Service- - - - - - 0% Capital 1,360,907 78,663 91,026 9,007 681,882 587,999 57% Transfers Out- - - - - - 0% 2,242,944 139,680 216,660 9,007 788,444 1,237,841 45% Net(973,944) (23,813) 204,578 168,929 (788,444) (390,079) Cash Balance 2,931,953 2,613,377 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 $682K in encumbrance includes $121K for Bendix Dr. (Lathrop to Toll Road), $139K for the Boland Trail, $214K for Safe Routes to School (Coquillard, Harrison, Perley and Lincoln schools) and $180K 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 $106K in Services includes $93K for traffic signal upgrades placed at various intersections around the City and $13K for updates to the City construction standards. Form 339 Fund/Department Name Month February Fund/Department Number 252 Date Updated 3/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- - - - - - 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 340 Fund/Department Name Month February Fund/Department Number 258 Date Updated 3/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 145,000 121,000 1,667 - 24,000 83% Charges for Services- - - - - - 0% Interest Earnings 2,000 143 723 495 - 1,277 36% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 18,040 3,778 3,778 7,090 - 14,263 21% Transfers In- - - - - - 0% Total Revenue 165,040 3,921 125,501 9,252 - 39,539 76% Personnel 122,817 9,371 18,692 12,888 - 104,125 15% Supplies 2,300 629 629 168 1,171 500 78% Services 96,721 2,344 5,939 18,173 16,668 74,114 23% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 221,838 12,344 25,260 31,228 17,839 178,739 19% Net(56,798) (8,423) 100,241 (21,976) (17,839) (139,199) Cash Balance 525,637 508,276 Full Time 2.00 2.00 Part-Time /Seasonal/Temporary 1.00 1.00 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 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 341 Fund/Department Name Month February Fund/Department Number 271 Date Updated 3/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- - - - - - 0% Interest Earnings 30 0 3 6 - 27 9% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 30 0 3 6 - 27 9% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 30 0 3 6 - 27 Cash Balance 1,338 5,318 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 342 Fund/Department Name Month February Fund/Department Number 273 Date Updated 3/14/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 900 1,250 250 - 16,750 7% Interest Earnings 150 11 61 30 - 89 41% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 18,150 911 1,311 280 - 16,839 7% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 18,878 - - 96 878 18,001 5% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 18,878 - - 96 878 18,001 5% Net(728) 911 1,311 184 (878) (1,162) Cash Balance 31,663 26,897 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 343 Fund/Department Name Month February Fund/Department Number 280 Date Updated 3/14/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 8 4 - (8) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 1 8 4 - (8) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- 1 8 4 - (8) Cash Balance 3,858 3,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 Police Block Grants Expenditures Revenue Total Expenditures Staffing Justice Assistance Grant 2009-SB-B9-1280 was essentially completed in 2014. Form 344 Fund/Department Name Month February Fund/Department Number 281 Date Updated 3/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 10 55 30 - 95 37% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 150 10 55 30 - 95 37% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 150 10 55 30 - 95 Cash Balance 27,417 27,235 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 345 Fund/Department Name Month February Fund/Department Number 289 Date Updated 3/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 10,000 - - 13,787 - 10,000 0% Interest Earnings- 12 65 41 - (65) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 10,000 12 65 13,828 - 9,935 1% Personnel- - - - - - 0% Supplies 10,000 - - 21,542 - 10,000 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 10,000 - - 21,542 - 10,000 0% Net- 12 65 (7,714) - (65) Cash Balance 32,127 31,915 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 346 Fund/Department Name Month February Fund/Department Number 291 Date Updated 3/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 45,000 11,400 16,800 5,400 - 28,200 37% Interest Earnings 200 35 189 116 - 11 95% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 45,200 11,435 16,989 5,516 - 28,211 38% Personnel 15,500 231 462 231 - 15,038 3% Supplies 10,800 0 794 0 - 10,006 7% Services 69,000 1,080 1,255 1,889 - 67,745 2% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 95,300 1,311 2,511 2,120 - 92,789 3% Net(50,100) 10,124 14,478 3,396 - (64,578) Cash Balance 109,923 108,796 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 347 Fund/Department Name Month February Fund/Department Number 292 Date Updated 3/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- - - - - - 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 5,929 12,637 15,296 42,735 1 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 55,373 5,929 12,637 15,296 42,735 1 100% Net(55,373) (5,929) (12,637) (15,241) (42,735) (1) Cash Balance 108,558 80,167 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 348 Fund/Department Name Month February Fund/Department Number 294 Date Updated 3/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 20,000 6,900 15,350 18,563 - 4,650 77% Interest Earnings 500 28 145 76 - 355 29% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In- - - - - - 0% Total Revenue 22,500 6,928 15,495 18,639 - 7,005 69% Personnel- - - - - - 0% Supplies 1,500 - - - - 1,500 0% Services 21,000 50 301 12,398 - 20,699 1% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 22,500 50 301 12,398 - 22,199 1% Net- 6,878 15,194 6,241 - (15,194) Cash Balance 85,462 74,524 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 349 Fund/Department Name Month February Fund/Department Number 295 Date Updated 3/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 53,750 7,319 7,319 - - 46,431 14% Charges for Services- - - - - - 0% Interest Earnings 500 45 246 115 - 254 49% Bond Proceeds- - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 34,500 850 1,740 1,230 - 32,760 5% Transfers In- - - - - - 0% Total Revenue 92,000 8,214 9,305 1,345 - 82,695 10% Personnel- - - - - - 0% Supplies 57,245 - - 20,917 10,245 47,000 18% Services 45,000 4,039 4,746 357 - 40,254 11% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 102,245 4,039 4,746 21,274 10,245 87,254 15% Net(10,245) 4,175 4,559 (19,929) (10,245) (4,559) Cash Balance 126,356 86,305 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 350 Fund/Department Name Month February Fund/Department Number 299 Date Updated 3/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 160,000 - - 1,728 - 160,000 0% Charges for Services- - - - - - 0% Interest Earnings 1,000 115 209 171 - 791 21% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,000 - - - - 1,000 0% Transfers In- - - - - - 0% Total Revenue 162,000 115 209 1,899 - 161,791 0% Personnel- - - - - - 0% Supplies 61,965 - - 13,483 6,964 55,001 11% Services 62,000 1,290 1,290 11,376 - 60,710 2% Debt Service- - - - - - 0% Capital 45,000 - - - - 45,000 0% Transfers Out- - - - - - 0% 168,965 1,290 1,290 24,859 6,964 160,711 5% Net(6,965) (1,175) (1,081) (22,960) (6,964) 1,080 Cash Balance 251,671 322,583 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 351 Fund/Department Name Month February Fund/Department Number 404 Date Updated 3/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 1,575,670 1,476,652 - 7,878,353 17% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 95,000 3,992 23,997 16,572 - 71,003 25% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 783,961 44,961 235,749 86,605 - 548,212 30% Transfers In- - - - - - 0% Total Revenue 10,332,984 836,789 1,835,417 1,579,828 - 8,497,567 18% Personnel 419,439 36,631 64,037 50,819 - 355,402 15% Supplies 1,595,825 32,000 82,038 104,846 130,446 1,383,341 13% Services 8,478,544 629,097 1,241,547 1,165,543 1,963,474 5,273,523 38% Debt Service 2,588,970 4,656 1,126,225 397,979 - 1,462,745 44% Capital 579,370 - 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 702,384 2,898,030 2,119,512 2,350,107 9,914,011 35% Net(4,829,164) 134,405 (1,062,614) (539,684) (2,350,107) (1,416,444) Cash Balance 11,105,488 14,411,933 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 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 included 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 352 Fund/Department Name Month February Fund/Department Number 408 Date Updated 3/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 1,599,100 1,530,201 - 7,995,502 17% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 504,660 - 150,000 150,000 - 354,660 30% Interest Earnings 60,000 3,643 19,875 11,128 - 40,125 33% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 82 - - 0% Transfers In- - - - - - 0% Total Revenue 10,159,262 803,193 1,768,975 1,691,411 - 8,390,287 17% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 2,604,237 59,872 128,066 309,580 683,300 1,792,871 31% Debt Service 1,274,662 - 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 59,872 2,252,628 2,372,293 683,300 7,624,254 28% Net(400,919) 743,322 (483,653) (680,882) (683,300) 766,033 Cash Balance 9,398,859 9,489,343 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 $275,000 has been budgeted for the Potawatomi Zoological Society. 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 353 Fund/Department Name Month February Fund/Department Number 410 Date Updated 3/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 196 1,335 30 - (1,225) 1213% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 169,717 - - - - 169,717 0% Transfers In- - - - - - 0% Total Revenue 169,827 196 1,335 30 - 168,492 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 238,173 - 146,068 - - 92,106 61% Capital- - - - - - 0% Transfers Out- - - - - - 0% 238,173 - 146,068 - - 92,106 61% Net(68,346) 196 (144,733) 30 - 76,387 Cash Balance 485,668 27,696 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 354 Fund/Department Name Month February Fund/Department Number 655 Date Updated 3/14/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,432 73,021 72,676 360,269 17% Interest Earnings 4,000 347 1,868 1,115 2,132 47% Bond Proceeds- - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 437,290 36,779 74,889 73,791 - 362,401 17% Personnel 56,649 1,415 56,649 0% Supplies 3,145 3,145 0% Services 46,344 2,629 5,604 4,604 40,740 12% Debt Service 72,220 11,619 11,619 60,601 16% Capital- 0% Transfers Out 350,000 350,000 0% 528,358 2,629 17,223 17,638 - 511,135 3% Net(91,068) 34,151 57,666 56,153 - (148,734) Cash Balance 980,087 1,034,447 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 355 Fund/Department Name Month February Fund/Department Number 705 Date Updated 3/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- - - - - - 0% Interest Earnings 20 1 8 4 - 12 40% Bond Proceeds- - - - - - 0% Donations 2,000 - - 500 - 2,000 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,020 1 8 504 - 2,012 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- 1 8 504 - (8) Cash Balance 3,877 3,823 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 356 Fund/Department Name Month February Fund/Department Number 313 Date Updated 3/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 1,200,000 - - - - 1,200,000 0% Local Income Taxes- - - - - - 0% Other Taxes 183,112 9,343 18,686 8,513 - 164,426 10% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 100 - 0 41 - 100 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,383,212 9,343 18,686 8,554 - 1,364,526 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 1,268,015 - 636,000 636,000 - 632,015 50% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,268,015 - 636,000 636,000 - 632,015 50% Net 115,197 9,343 (617,314) (627,446) - 732,511 Cash Balance(605,918) (553,323) 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 357 Fund/Department Name Month February Fund/Department Number 377 Date Updated 3/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 660,000 47,449 196,456 206,200 - 463,544 30% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,455 104 811 618 - 644 56% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 48,263 - 24,026 29,523 - 24,237 50% Transfers In- - - - - - 0% Total Revenue 709,718 47,553 221,294 236,340 - 488,424 31% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 838,052 800 473,088 481,573 - 364,965 56% Capital- - - - - - 0% Transfers Out- - - - - - 0% 838,052 800 473,088 481,573 - 364,965 56% Net(128,334) 46,753 (251,794) (245,232) - 123,460 Cash Balance 175,580 350,860 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) was paid January 15, 2013. Form 358 Fund/Department Name Month February Fund/Department Number 401 Date Updated 3/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 15,000 - - - - 15,000 0% Interest Earnings 200 30 167 45 - 33 83% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 15,200 30 167 45 - 15,033 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- 22,000 22,000 - - (22,000) 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - 22,000 22,000 - - (22,000) 0% Net 15,200 (21,970) (21,833) 45 - 37,033 Cash Balance 60,721 40,495 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 359 Fund/Department Name Month February Fund/Department Number 403 Date Updated 3/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- - - - - - 0% Interest Earnings 200 18 100 54 - 100 50% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 200 18 100 54 - 100 50% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 200 18 100 54 - 100 Cash Balance 49,546 49,216 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 360 Fund/Department Name Month February Fund/Department Number 405 Date Updated 3/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 34,000 319 488 162 - 33,512 1% Interest Earnings 4,000 127 882 533 - 3,118 22% 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 446 1,370 4,695 - 161,130 1% Personnel- - - - - - 0% Supplies 58,173 - - - 5,422 52,751 9% Services 55,160 - - - 11,160 44,000 20% Debt Service- - - - - - 0% Capital 155,000 - - - 23,181 131,819 15% Transfers Out- - - - - - 0% 268,333 - - - 39,763 228,570 15% Net(105,833) 446 1,370 4,695 (39,763) (67,441) Cash Balance 471,094 525,859 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 361 Fund/Department Name Month February Fund/Department Number 406 Date Updated 3/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 8,840 8,699 - 81,897 10% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 3,000 174 1,090 615 - 1,910 36% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 526,737 4,594 9,930 9,314 - 516,807 2% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 526,737 - 112,650 112,650 - 414,087 21% Capital- - - - - - 0% Transfers Out- - - - - - 0% 526,737 - 112,650 112,650 - 414,087 21% Net- 4,594 (102,721) (103,336) - 102,721 Cash Balance 469,239 477,914 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 362 Fund/Department Name Month February Fund/Department Number 407 Date Updated 3/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 - - 260,000 37% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 700 144 647 267 - 53 92% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In- - - - - - 0% Total Revenue 435,700 144 150,647 267 - 285,053 35% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 365,907 - 184,125 183,750 - 181,782 50% Capital- - - - - - 0% Transfers Out- - - - - - 0% 365,907 - 184,125 183,750 - 181,782 50% Net 69,793 144 (33,478) (183,484) - 103,271 Cash Balance 277,753 65,999 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 363 Fund/Department Name Month February Fund/Department Number 412 Date Updated 3/14/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 790 4,364 4,134 - 20,636 17% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,023,178 586,589 586,589 368,031 - 436,589 57% Transfers In- - - - - - 0% Total Revenue 1,048,178 587,379 590,953 372,166 - 457,225 56% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 750,000 - - - - 750,000 0% Debt Service- - - - - - 0% Capital 1,635,033 312,495 312,605 209,388 632,064 690,364 58% Transfers Out- - - - - - 0% 2,385,033 312,495 312,605 209,388 632,064 1,440,364 40% Net(1,336,855) 274,884 278,347 162,778 (632,064) (983,139) Cash Balance 2,435,336 3,804,440 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 $632K encumbered comprises $279K for the downtown portion of the 2-way conversion of Main and Michigan/St. Joseph streets from Chippewa to LaSalle (the former IN-933), $79K for the Marion St. roundabout, $44K for the Bartlett St. roundabout, $23K for the Western Ave. corridor sidewalks and striping, and $31K 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 Feb 29 are $509,857 from Fund 435 (Douglas Rd.) and $4,075,057 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 364 Fund/Department Name Month February Fund/Department Number 416 Date Updated 3/14/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 2,700 7,776 9,289 - 92,224 8% Interest Earnings 2,000 191 1,045 566 - 955 52% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 102,000 2,891 8,821 9,855 - 93,179 9% Personnel- - - - - - 0% Supplies 30,000 5,000 5,000 1,268 - 25,000 17% Services 48,923 5,464 5,464 1,665 7,445 36,014 26% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 78,923 10,464 10,464 2,933 7,445 61,014 23% Net 23,077 (7,574) (1,643) 6,921 (7,445) 32,165 Cash Balance 515,083 522,342 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 365 Fund/Department Name Month February Fund/Department Number 434 Date Updated 3/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- 56 101 55 - (101) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 56 101 55 - (101) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - 3,897 - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 3,897 - - 0% Net- 56 101 (3,842) - (101) Cash Balance 2,504 5,996 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 366 Fund/Department Name Month February Fund/Department Number 450 Date Updated 3/14/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 2,117 2,117 2,178 - 14,883 12% Interest Earnings 300 28 154 70 - 146 51% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 17,300 2,145 2,271 2,248 - 15,029 13% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 17,300 2,145 2,271 2,248 - 15,029 Cash Balance 78,685 65,409 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 367 Fund/Department Name Month February Fund/Department Number 677 Date Updated 3/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 184 1,017 617 - 983 51% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,000 184 1,017 617 - 983 51% Personnel- - - - - - 0% Supplies 1,000 - - - - 1,000 0% Services 83,801 15,819 20,477 13,213 229 63,095 25% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 84,801 15,819 20,477 13,213 229 64,095 24% Net(82,801) (15,635) (19,460) (12,596) (229) (63,112) Cash Balance 483,417 546,624 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 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 368 Fund/Department Name Month February Fund/Department Number 287 Date Updated 3/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 2,075,000 - - 396,727 - 2,075,000 0% Charges for Services- 1,307,757 1,307,757 - - (1,307,757) 0% Interest Earnings 500 942 5,200 - - (4,700) 1040% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,075,500 1,308,699 1,312,957 396,727 - 762,543 63% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 55,000 - - - - 55,000 0% Capital 2,192,611 - - 35,728 363,611 1,829,000 17% Transfers Out- - - - - - 0% 2,247,611 - - 35,728 363,611 1,884,000 16% Net(172,111) 1,308,699 1,312,957 360,999 (363,611) (1,121,457) Cash Balance 3,885,198 360,999 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 369 Fund/Department Name Month February 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 494,221 965,494 355,773 - 4,058,018 19% Interest Earnings 10,000 800 4,498 3,194 - 5,502 45% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 49,500 2,755 4,745 14,493 - 44,755 10% Transfers In 2,000 - - - - 2,000 0% Total Revenue 5,085,012 497,776 974,737 373,460 - 4,110,275 19% Personnel 4,983,238 316,583 627,891 - - 4,355,347 13% Supplies 276,861 19,920 49,603 45,593 62,056 165,202 40% Services 408,451 33,310 49,003 8,263 51,767 307,681 25% Debt Service 447,093 318 225,901 226,401 2,046 219,146 51% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,115,643 370,131 952,398 280,257 115,869 5,047,376 17% Net(1,030,631) 127,645 22,339 93,203 (115,869) (937,101) Cash Balance 2,300,625 2,980,382 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 370 Fund/Department Name Month February Fund/Department Number 600 Date Updated 3/14/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 86,454 224,550 166,894 - 1,174,850 16% Interest Earnings 5,000 698 3,876 787 - 1,124 78% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 3,500 1,334 2,839 2,026 - 661 81% Transfers In 2,110,068 - 527,517 665,786 - 1,582,551 25% Total Revenue 3,517,968 88,486 758,782 835,494 - 2,759,186 22% Personnel 2,862,499 209,488 414,992 411,680 501 2,447,006 15% Supplies 160,417 7,620 12,061 13,900 14,250 134,106 16% Services 1,311,150 61,420 117,081 78,698 228,081 965,988 26% Debt Service 46,623 311 7,271 3,146 1,853 37,499 20% Capital 70,285 - 30,608 - 39,677 0 100% Transfers Out- - - - - - 0% 4,450,974 278,838 582,013 507,424 284,362 3,584,599 19% Net(933,006) (190,353) 176,769 328,070 (284,362) (825,413) Cash Balance 2,073,593 1,062,839 Full Time 30.00 14.00 - Part-Time /Seasonal/Temporary 1.00 1.00 - Total 31.00 15.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 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.6 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 371 Fund/Department Name Month February Fund/Department Number 601 Date Updated 3/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 86,858 173,886 145,093 - 874,341 17% Interest Earnings 4,000 226 1,323 1,190 - 2,677 33% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,052,226 87,084 175,208 146,283 - 877,018 17% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,141,933 5,924 117,638 149,793 708,992 315,303 72% Debt Service 250,000 - - - - 250,000 0% Capital 1,536 - - 52,838 1,536 (0) 100% Transfers Out- - - - - - 0% 1,393,469 5,924 117,638 202,631 710,528 565,303 59% Net(341,243) 81,161 57,570 (56,348) (710,528) 311,715 Cash Balance 698,187 1,017,281 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 372 Fund/Department Name Month February Fund/Department Number 610 Date Updated 3/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 432,907 838,377 809,585 - 4,753,872 15% Interest Earnings 2,500 56 585 439 - 1,915 23% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 2,000 26,825 26,825 - (24,825) 1341% Transfers In- - - - - - 0% Total Revenue 5,596,749 459,788 865,787 810,024 - 4,730,962 15% Personnel 1,725,395 112,453 240,724 289,821 149 1,484,522 14% Supplies 249,261 12,678 23,747 34,515 6,019 219,495 12% Services 2,678,159 229,813 492,979 462,203 783,357 1,401,823 48% Debt Service 19,400 4,850 9,700 - 9,700 - 100% Capital- - - - 0% Transfers Out 925,197 251,000 190,000 674,197 27% 5,597,412 359,794 1,018,151 976,539 799,224 3,780,037 32% Net(663) 99,994 (152,364) (166,515) (799,224) 950,925 Cash Balance 155,204 229,300 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 service expenses appear high. Form 373 Fund/Department Name Month February Fund/Department Number 611 Date Updated 3/8/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 25 36 33 - 164 18% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 925,197 - 251,000 190,000 - 674,197 27% Total Revenue 925,397 25 251,036 190,033 - 674,361 27% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 925,197 236 251,115 223,892 1,025 673,057 27% Capital- - - - - - 0% Transfers Out- - - - - - 0% 925,197 236 251,115 223,892 1,025 673,057 27% Net 200 (212) (79) (33,858) (1,025) 1,304 Cash Balance 364 1,341 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 374 Fund/Department Name Month February Fund/Department Number 620 Date Updated 3.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 14,423,116 1,088,793 2,159,782 2,116,407 - 12,263,334 15% Interest Earnings 26,000 1,277 7,652 4,582 - 18,348 29% Bond Proceeds- - - - - 0% Donations- - - - - 0% Other Income 123,500 2,296 2,409 1,222 - 121,091 2% Transfers In 31,500 1,384 3,260 2,334 - 28,240 10% Total Revenue 14,604,116 1,093,751 2,173,103 2,124,545 - 12,431,013 15% Personnel 5,440,741 402,749 804,145 851,496 3,656 4,632,940 15% Supplies 1,655,677 101,753 160,637 68,756 133,527 1,361,513 18% Services 5,352,541 453,823 703,951 577,863 629,867 4,018,723 25% Debt Service 119,687 1,373 6,325 1,173 3,555 109,806 8% Capital- - - - - 0% Transfers Out 4,416,011 567,945 908,429 814,546 - 3,507,582 21% 16,984,657 1,527,644 2,583,488 2,313,834 770,605 13,630,564 20% Net(2,380,541) (433,893) (410,385) (189,289) (770,605) (1,199,551) Cash Balance 3,577,786 4,088,524 Full Time 72.30 72.05 Part-Time /Seasonal/Temporary 6.30 2.50 Total 78.60 74.55 - 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 375 Fund/Department Name Month February Fund/Department Number 622 Date Updated 3.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 1,055 5,823 3,457 - 9,177 39% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 15,000 1,055 5,823 3,457 - 9,177 39% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital 821,797 - - 82,845 177,797 644,000 22% Transfers Out- - - - - - 0% 821,797 - - 82,845 177,797 644,000 22% Net(806,797) 1,055 5,823 (79,388) (177,797) (634,823) Cash Balance 2,886,231 3,045,894 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 376 Fund/Department Name Month February Fund/Department Number 623 Date Updated 3.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- - - 221 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 221 - - 0% Personnel- - - - - - 0% Supplies- - - 46,638 - - 0% Services- - - 2,171 - - 0% Debt Service- - - - - - 0% Capital- - - 219 - - 0% Transfers Out- - - - - - 0% - - - 49,028 - - 0% Net- - - (48,807) - - Cash Balance- 171,482 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 cash proceeds were fully expended at July 14, 2015. Form 377 Fund/Department Name Month February Fund/Department Number 624 Date Updated 3.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 553 3,055 1,630 - 5,345 36% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 8,400 553 3,055 1,630 - 5,345 36% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - 0% Transfers Out 8,400 553 1,087 776 - 7,313 13% 8,400 553 1,087 776 - 7,313 13% Net- - 1,968 854 - (1,968) Cash Balance 1,518,811 1,489,519 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 378 Fund/Department Name Month February Fund/Department Number 625 Date Updated 3.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 14 571 469 - 3,029 16% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 2,046,081 170,505 341,010 340,550 - 1,705,071 17% Total Revenue 2,049,681 170,519 341,581 341,019 - 1,708,100 17% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 2,046,081 - - - - 2,046,081 0% Capital- - - - - - 0% Transfers Out 3,600 14 565 467 - 3,035 16% 2,049,681 14 565 467 - 2,049,116 0% Net- 170,505 341,016 340,552 - (341,016) Cash Balance 345,421 345,208 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 379 Fund/Department Name Month February Fund/Department Number 626 Date Updated 3.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 589 3,250 1,778 6,250 34% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 9,500 589 3,250 1,778 - 6,250 34% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 9,500 - - - - 9,500 0% 9,500 - - - - 9,500 0% Net- 589 3,250 1,778 - (3,250) Cash Balance 1,642,812 1,648,455 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 380 Fund/Department Name Month February Fund/Department Number 629 Date Updated 3.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 817 4,514 2,295 - 5,486 45% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - 0% Transfers In 165,166 227,461 227,461 150,228 - (62,295) 138% Total Revenue 175,166 228,278 231,975 152,523 - (56,809) 132% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 10,000 817 1,608 1,092 - 8,392 16% 10,000 817 1,608 1,092 - 8,392 16% Net 165,166 227,461 230,367 151,431 - (65,201) Cash Balance 2,462,728 2,235,267 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 equivalent to two months' worth of operating expenditures in Fund 620, excluding transfers. Form 381 Fund/Department Name Month February Fund/Department Number 640 Date Updated 3/14/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 51,842 103,940 102,981 457,285 19% Interest Earnings 3,500 614 3,345 1,662 155 96% Bond Proceeds- - 0% Donations- - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 564,725 52,457 107,285 104,643 - 457,440 19% Personnel 188,900 11,858 23,665 32,126 - 165,235 13% Supplies 41,569 122 1,650 2,461 11,251 28,667 31% Services 290,487 12,493 31,755 44,006 13,650 245,082 16% Debt Service 28,457 - 28,457 0% Capital- - 0% Transfers Out- - - - - - 0% 549,413 24,473 57,071 78,593 24,901 467,441 15% Net 15,312 27,984 50,214 26,050 (24,901) (10,000) Cash Balance 1,701,637 1,530,104 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 382 Fund/Department Name Month February Fund/Department Number 641 Date Updated 3/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 36,538,600 3,014,643 5,970,582 5,556,698 - 30,568,018 16% Interest Earnings 65,000 3,456 19,381 9,797 - 45,619 30% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 92,000 4,101 4,415 7,577 - 87,585 5% Transfers In 16,000 1,345 2,646 1,792 - 13,354 17% Total Revenue 36,711,600 3,023,545 5,997,024 5,575,864 - 30,714,576 16% Personnel 7,573,583 531,745 1,066,932 1,328,386 33 6,506,618 14% Supplies 2,292,608 96,022 224,764 202,488 251,547 1,816,297 21% Services 16,901,880 852,088 1,778,688 1,653,295 2,343,599 12,779,593 24% Debt Service 678,685 78 190,515 133,557 3,339 484,831 29% Capital- - - - - 0% Transfers Out 12,289,388 1,657,617 2,418,510 1,803,158 9,870,878 20% 39,736,144 3,137,550 5,679,409 5,120,884 2,598,519 31,458,217 21% Net(3,024,544) (114,006) 317,616 454,980 (2,598,519) (743,641) Cash Balance 9,226,110 9,260,229 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 383 Fund/Department Name Month February Fund/Department Number 642 Date Updated 3/8/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 3,000 17,620 4,199 - 27,380 39% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 2,487,000 - - - - 2,487,000 0% Total Revenue 2,532,000 3,000 17,620 4,199 - 2,514,380 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 11,901 - - 0% Debt Service- - - - - - 0% Capital 7,631,946 53,387 688,430 74,319 4,480,628 2,462,888 68% Transfers Out- - - - - - 0% 7,631,946 53,387 688,430 86,219 4,480,628 2,462,888 68% Net(5,099,946) (50,387) (670,810) (82,020) (4,480,628) 51,492 Cash Balance 8,070,261 3,669,702 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, Wastewater Treatment Plant Secondary Improvements $53,387 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 384 Fund/Department Name Month February Fund/Department Number 643 Date Updated 3/8/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 1,345 7,428 3,767 - 8,572 46% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 536,997 896,725 896,725 256,086 - (359,728) 167% Total Revenue 552,997 898,070 904,153 259,853 - (351,156) 164% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 16,000 1,345 2,646 1,792 - 13,354 17% 16,000 1,345 2,646 1,792 - 13,354 17% Net 536,997 896,725 901,507 258,061 - (364,510) Cash Balance 4,575,374 3,678,649 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 was done in this month to adjust the balance to stay in compliance. Form 385 Fund/Department Name Month February Fund/Department Number 649 Date Updated 3/8/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 719 2,325 1,050 - 4,675 33% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 9,267,391 760,893 1,521,785 1,547,073 - 7,745,606 16% Total Revenue 9,274,391 761,612 1,524,111 1,548,123 - 7,750,280 16% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 8,000 500 1,850 1,850 - 6,150 23% Debt Service 9,266,298 - - 9,266,298 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 9,274,298 500 1,850 1,850 - 9,272,448 0% Net 93 761,112 1,522,261 1,546,273 - (1,522,168) Cash Balance 2,327,001 2,336,609 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 386 Fund/Department Name Month February Fund/Department Number 653 Date Updated 3/8/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) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - 25 - - (25) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- - 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 now has a lower cash balance. A reconcilliation of this account is done monthly. Form 387 Fund/Department Name Month February Fund/Department Number 659 Date Updated 3/8/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 85 469 1,807 - 1,531 23% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,000 85 469 1,807 - 1,531 23% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 9,606 - 3,917 9,606 - 100% Debt Service- - - - - - 0% Capital 162,482 - 641,919 162,482 - 100% Transfers Out- - - - - - 0% 172,088 - - 645,836 172,088 - 100% Net(170,088) 85 469 (644,029) (172,088) 1,531 Cash Balance 232,363 955,357 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 388 Fund/Department Name Month February Fund/Department Number 661 Date Updated 3/8/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 5,057 28,135 18,638 - (3,135) 113% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - 0% Total Revenue 25,000 5,057 28,135 18,638 - (3,135) 113% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 850,000 - - - - 850,000 0% Debt Service- - - - - - 0% Capital 19,337,062 1,143,403 1,261,739 288,246 11,693,646 6,381,677 67% Transfers Out- - - - - - 0% 20,187,062 1,143,403 1,261,739 288,246 11,693,646 7,231,677 64% Net(20,162,062) (1,138,346) (1,233,603) (269,608) (11,693,646) (7,234,813) Cash Balance 12,964,479 16,549,657 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 $600,445, 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 $145,736, Secondary Clarifier Modifications $1,357,201, CSO LTCP re-look $1,528,341, and misc other $2,070. Expenditures Revenue Total Expenditures Staffing Current year spending from this Bond has been for the CSO LTCP re-look $215,363, East Bank Sewer Separation-Phase 5 $18,484, WWTP Secondary Clarifier Modifications $1,018,806, and WWTP Grit/Screening Improvements $9,086. Form 389 Fund/Department Name Month February Fund/Department Number 664 Date Updated 3/8/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 9 5 - (9) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 2 9 5 - (9) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- 2 9 5 - (9) Cash Balance 4,515 4,485 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 390 Fund/Department Name Month February Fund/Department Number 666 Date Updated 3/8/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- 5 81 - - (81) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 5 81 - - (81) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - 2,500 - - (2,500) 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - 2,500 - - (2,500) 0% Net- 5 (2,419) - - 2,419 Cash Balance 6,671 - 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. Form 391 Fund/Department Name Month February Fund/Department Number 670 Date Updated 3/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,711 50% Grants/Intergovernmental- - - - - - 0% Charges for Services 2,664,721 390,752 523,821 816,636 - 2,140,900 20% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 5,630 6,169 6,547 (148) - (917) 116% Transfers In- - - - - - 0% Total Revenue 3,983,787 396,920 1,187,093 816,489 - 2,796,694 30% Personnel 2,249,773 174,161 328,637 302,077 - 1,921,136 15% Supplies 473,779 34,350 101,915 50,504 - 371,864 22% Services 1,154,774 102,230 209,546 239,364 - 945,228 18% Debt Service- - - - - - 0% Capital 14,722 - - - - 14,722 0% Transfers Out 79,390 - - - - 79,390 0% 3,972,438 310,741 640,098 591,945 - 3,332,340 16% Net 11,349 86,180 546,995 224,543 - (535,646) Cash Balance 1,750,812 1,310,487 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 392 Fund/Department Name Month February Fund/Department Number 671 Date Updated 3/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 79 164 45 - 336 33% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 500 79 164 45 - 336 33% Personnel- - - - - - 0% Supplies- - - 41,156 - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - 25,000 - - 0% Transfers Out- - - - - - 0% - - - 66,156 - - 0% Net 500 79 164 (66,111) - 336 Cash Balance 1,002,236 1,352,551 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 393 Fund/Department Name Month February Fund/Department Number 672 Date Updated 3/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 8 - - 157,734 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 79,390 - - - - 79,390 0% Total Revenue 237,132 4 8 - - 237,124 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 8 - - (8) Cash Balance 50,040 - 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. The $50,000 was transferred from the capital fund to set up the fund for future bond payments. Form 394 Fund/Department Name Month February Fund/Department Number 222 Date Updated 3/10/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 669,571 1,226,910 1,316,570 - 6,954,597 15% Interest Earnings 3,240 293 2,380 1,490 - 860 73% Bond Proceeds- - 0% Donations- - 0% Other Income 49,890 1,771 3,750 26,432 - 46,140 8% Transfers In- - - - - - 0% Total Revenue 8,234,637 671,636 1,233,040 1,344,491 - 7,001,597 15% Personnel 3,143,175 203,169 408,168 502,373 2,735,007 13% Supplies 190,636 (2,259) (449) (8,996) 9,847 181,238 5% Services 4,812,674 429,965 766,441 806,608 2,890,266 1,155,966 76% Debt Service 12,475 210 1,325 1,414 630 10,520 16% Capital- - - 0% Transfers Out 130,519 - - - 130,519 0% 8,289,479 631,085 1,175,486 1,301,399 2,900,743 4,213,250 49% Net(54,842) 40,550 57,554 43,092 (2,900,743) 2,788,347 Cash Balance 1,488,497 1,676,827 Full Time 42.00 37.00 37.00 Part-Time /Seasonal/Temporary 3.00 3.00 3.00 Total 45.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 Feb we had 1,427 vehicle repairs. Average Fuel prices for February is $1.14 for Unleaded and $1.39 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 395 Fund/Department Name Month February Fund/Department Number 224 Date Updated 3/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- 68 382 - - (382) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 130,519 - - 130,519 0% Total Revenue 130,519 68 382 - - 130,137 0% Personnel- - - - - - 0% Supplies 20,000 - - - - 20,000 0% Services 60,019 - - - - 60,019 0% Debt Service- - - - - 0% Capital 225,565 23,369 23,369 - 151,696 50,500 78% Transfers Out- - - - - - 0% 305,584 23,369 23,369 - 151,696 130,519 57% Net(175,065) (23,301) (22,988) - (151,696) (382) Cash Balance 163,932 - 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 396 Fund/Department Name Month February Fund/Department Number 226 Date Updated 3/14/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 185,290 368,591 201,190 - 1,854,892 17% Interest Earnings 20,500 1,659 9,172 6,261 - 11,328 45% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 10,000 12,878 12,878 - - (2,878) 129% Transfers In- - - - - - 0% Total Revenue 2,253,983 199,828 390,641 207,451 - 1,863,342 17% Personnel 250,135 16,046 32,006 42,663 - 218,129 13% Supplies 30,734 1,282 1,387 5,067 8,693 20,655 33% Services 2,839,479 219,320 300,696 470,062 105,584 2,433,199 14% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 3,120,348 236,647 334,089 517,792 114,277 2,671,983 14% Net(866,365) (36,820) 56,553 (310,340) (114,277) (808,641) Cash Balance 4,581,771 5,369,733 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. Miscellaneous income is slightly over budget due to a higher than expected reimbursement from a worker's compensation claim. The revenue budget will be adjusted in March. Form 397 Fund/Department Name Month February Fund/Department Number 278 Date Updated 3/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- 4,480 8,950 11,740 - (8,950) 0% Interest Earnings 4,000 237 1,297 569 - 2,703 32% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 60,400 4,480 8,950 11,740 - 51,450 15% Transfers In- - - - - - 0% Total Revenue 64,400 9,197 19,197 24,049 - 45,203 30% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 10,000 - 53 - - 9,947 1% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 10,000 - 53 - - 9,947 1% Net 54,400 9,197 19,144 24,049 - 35,256 Cash Balance 660,616 540,061 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. Revenue for 2016 is less than 2015 due to the timing of biweekly payroll. The revenue is the amount deducted from officer pay for the vehicle take home program. In 2015 there were five payrolls paid through the end of February compared to four in 2016. Form 398 Fund/Department Name Month February Fund/Department Number 279 Date Updated 3/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 499,358 39,201 77,979 421,379 16% Interest Earnings- 0% Bond Proceeds- 0% Donations- 0% Other Income- 0% Transfers In- 0% Total Revenue 499,358 39,201 77,979 - - 421,379 16% Personnel 459,575 37,632 74,256 385,319 16% Supplies 5,300 7 599 4,701 11% Services 34,482 1,562 3,124 31,358 9% Debt Service- 0% Capital- 0% Transfers Out- 0% 499,357 39,201 77,979 - - 421,378 16% Net 1 - - - - 1 Cash Balance- - 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 Call Center. The Call Center is still growing, so revenues will increase as more departments are served. Expenditures are predominantly related to salaries and benefits for the Call Center employees. Form 399 Fund/Department Name Month February Fund/Department Number 711 Date Updated 3/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,362,897 2,743,291 2,450,793 - 14,408,210 16% Interest Earnings 23,345 1,817 9,246 4,754 - 14,099 40% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- (217) 756 19,399 - (756) 0% Transfers In- - - - - - 0% Total Revenue 17,174,845 1,364,497 2,753,292 2,474,946 - 14,421,553 16% Personnel 4,316 - - 2 - 4,316 0% Supplies 17,875 906 906 1,784 12,714 4,255 76% Services 1,415,949 253,903 265,738 148,972 950,409 199,802 86% Insurance 15,940,750 1,548,548 2,171,026 1,843,639 37,381 13,732,344 14% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 17,378,890 1,803,358 2,437,671 1,994,397 1,000,503 13,940,716 20% Net(204,045) (438,862) 315,622 480,549 (1,000,503) 480,837 Cash Balance 4,691,091 4,537,536 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 3100 Fund/Department Name Month February Fund/Department Number 713 Date Updated 3/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 1,738 1,738 16,947 - 103,944 2% Interest Earnings 1,600 98 543 264 - 1,057 34% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 107,282 1,837 2,282 17,211 - 105,000 2% Personnel 80,000 2,821 3,701 7,561 - 76,299 5% Supplies- - - - - - 0% Services 33,882 5,007 5,614 7,733 2,200 26,068 23% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 113,882 7,828 9,315 15,294 2,200 102,367 10% Net(6,600) (5,991) (7,033) 1,917 (2,200) 2,633 Cash Balance 262,249 243,088 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 3101 Fund/Department Name Month February Fund/Department Number 701 Date Updated 3/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 5,443,092 - - - - 5,443,092 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 4,500 131 1,061 818 - 3,439 24% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 5,447,592 131 1,061 818 - 5,446,531 0% Personnel 5,457,693 401,833 828,918 882,266 - 4,628,775 15% Supplies 200 - - - - 200 0% Services 6,950 192 273 202 - 6,677 4% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 5,464,843 402,025 829,191 882,468 - 4,635,652 15% Net(17,251) (401,893) (828,131) (881,649) - 810,880 Cash Balance(355,826) (242,522) 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. For 2015, the payments are expected to be $2,603,546 by 1 July and again by 1 October, totaling $5,207,092. Form 3102 Fund/Department Name Month February Fund/Department Number 702 Date Updated 3/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 374 2,462 1,363 - 2,038 55% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 4,000 - - - - 4,000 0% Transfers In- - - - - - 0% Total Revenue 6,133,500 374 2,462 1,363 - 6,131,038 0% Personnel 6,789,198 528,350 1,044,706 1,061,026 - 5,744,492 15% Supplies 800 - - - - 800 0% Services 7,400 98 194 98 - 7,206 3% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,797,398 528,448 1,044,900 1,061,124 - 5,752,498 15% Net(663,898) (528,074) (1,042,438) (1,059,761) - 378,540 Cash Balance 114,982 51,010 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 3103 Fund/Department Name Month February Fund/Department Number 730 Date Updated 3/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- - - - - - 0% Interest Earnings 150 10 58 31 - 92 38% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 150 10 58 31 - 92 38% 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) 10 58 31 - (19,908) Cash Balance 28,599 28,409 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 3104 Fund/Department Name Month February Fund/Department Number 324 Date Updated 3/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 12,523 65,894 38,912 - (3,188) 105% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,692,308 25,559 33,772 41,338 - 1,658,536 2% Transfers In 11,000 1,015 1,996 544 - 9,004 18% Total Revenue 18,885,314 39,097 101,661 83,579 - 18,783,653 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 4,154,311 45,351 69,399 477,162 1,071,304 3,013,608 27% Debt Service 6,217,896 - 2,616,949 3,345,642 - 3,600,947 42% Capital 21,129,870 1,408,775 2,832,213 138,626 8,605,777 9,691,880 54% Transfers Out- - - - - - 0% 31,502,077 1,454,126 5,518,560 3,961,430 9,677,081 16,306,436 48% Net(12,616,763) (1,415,029) (5,416,899) (3,877,851) (9,677,081) 2,477,217 Cash Balance 27,317,645 27,519,308 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 3105 Fund/Department Name Month February Fund/Department Number 420 Date Updated 3/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- - - 3,146 - - 0% Interest Earnings- - - 880 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - 909 - - 0% Total Revenue- - - 4,935 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 6,768 - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 6,768 - - 0% Net- - - (1,833) - - Cash Balance- 4,086,639 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 3106 Fund/Department Name Month February Fund/Department Number 422 Date Updated 3/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 552 3,029 1,257 - 971 76% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 424,000 552 3,029 1,257 - 420,971 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 43,166 3,366 3,366 15,300 13,800 26,000 40% Debt Service- - - - - - 0% Capital 1,360,200 - - - 300,000 1,060,200 22% Transfers Out- - - - - - 0% 1,403,366 3,366 3,366 15,300 313,800 1,086,200 23% Net(979,366) (2,814) (337) (14,043) (313,800) (665,229) Cash Balance 1,506,488 1,181,706 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 3107 Fund/Department Name Month February Fund/Department Number 425 Date Updated 3/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 61 334 98 - 672 33% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 170,997 10,672 21,819 31,101 - 149,178 13% Transfers In- - - - - - 0% Total Revenue 172,003 10,732 22,153 31,199 - 149,850 13% Personnel- - - - - - 0% Supplies 8,742 178 460 463 - 8,282 5% Services 151,664 4,671 8,870 16,161 - 142,794 6% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 160,406 4,849 9,330 16,624 - 151,076 6% Net 11,597 5,884 12,823 14,575 - (1,226) Cash Balance 221,639 187,102 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 3108 Fund/Department Name Month February Fund/Department Number 426 Date Updated 3/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,442 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 2,442 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- - - 2,442 - - Cash Balance- 2,296,975 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 3109 Fund/Department Name Month February Fund/Department Number 429 Date Updated 3/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 2,739 15,244 4,851 - (8,244) 218% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 19,357 - - 0% Transfers In- - - - - - 0% Total Revenue 2,757,000 2,739 15,244 24,208 - 2,741,756 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 652,773 - 30,000 35,090 52,772 570,001 13% Debt Service- - - - - - 0% Capital 7,682,386 3,701 55,611 82,866 4,225,367 3,401,407 56% Transfers Out- - - - - - 0% 8,335,159 3,701 85,611 117,956 4,278,139 3,971,408 52% Net(5,578,159) (962) (70,367) (93,748) (4,278,139) (1,229,652) Cash Balance 7,490,818 4,462,732 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 3110 Fund/Department Name Month February Fund/Department Number 430 Date Updated 3/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 33,000 2,233 12,174 5,168 - 20,826 37% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,433,000 2,233 12,174 5,168 - 2,420,826 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 528,454 152,170 152,450 57,884 136,004 240,000 55% Debt Service- - - - - - 0% Capital 6,883,361 1,800 1,800 401,917 1,023,361 5,858,200 15% Transfers Out- - - - - - 0% 7,411,815 153,970 154,250 459,801 1,159,364 6,098,201 18% Net(4,978,815) (151,737) (142,075) (454,633) (1,159,364) (3,677,375) Cash Balance 5,953,303 4,502,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 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 3111 Fund/Department Name Month February Fund/Department Number 435 Date Updated 3/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 56 289 209 - 461 39% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 320,750 56 289 209 - 320,461 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 13,012 - - - 4,200 8,812 32% Debt Service 341,188 140,000 140,000 169,620 - 201,188 41% Capital- - - - - - 0% Transfers Out- - - - - - 0% 354,200 140,000 140,000 169,620 4,200 210,000 41% Net(33,450) (139,944) (139,711) (169,411) (4,200) 110,461 Cash Balance 11,954 52,019 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 3112 Fund/Department Name Month February Fund/Department Number 436 Date Updated 3/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 - - (0) 100% Interest Earnings 2,500 - 2,109 1,567 - 391 84% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 3,162,422 - 213,108 1,567 - 2,949,314 7% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 61,818 - - - - 61,818 0% Debt Service 3,368,182 446,589 1,684,089 1,710,589 - 1,684,093 50% Capital- - - - - - 0% Transfers Out- - - - - - 0% 3,430,000 446,589 1,684,089 1,710,589 - 1,745,911 49% Net(267,578) (446,589) (1,470,981) (1,709,022) - 1,203,403 Cash Balance 149,037 (3,519) 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 3113 Fund/Department Name Month February Fund/Department Number 433 Date Updated 3/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 3 18 11 - 134 12% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 152 3 18 11 - 134 12% 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) 3 18 11 - (4,366) Cash Balance 8,720 10,101 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 3114 Fund/Department Name Month February Fund/Department Number 439 Date Updated 3/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 833 4,625 5,529 - 10,012 32% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 14,637 833 4,625 5,529 - 10,012 32% 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) 833 4,625 5,529 (142,913) (2,539,988) Cash Balance 2,277,931 5,026,090 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 3115 Fund/Department Name Month February Fund/Department Number 454 Date Updated 3/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 139 767 416 - 733 51% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,500 139 767 416 - 733 51% 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) 139 767 416 - (49,267) Cash Balance 380,389 377,857 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 3116 Fund/Department Name Month February Fund/Department Number 619 Date Updated 3/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- - - 119,238 - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 119,238 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 158,413 - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 158,413 - - 0% Net- - - (39,175) - - Cash Balance- 60,141 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 3117 Fund/Department Name Month February Fund/Department Number 315 Date Updated 3/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 380 2,098 1,143 - 2,902 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 5,000 380 2,098 1,143 - 2,902 42% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 5,000 380 747 544 - 4,253 15% 5,000 380 747 544 - 4,253 15% Net- - 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 3118 Fund/Department Name Month February Fund/Department Number 317 Date Updated 3/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 186 1,027 556 - 773 57% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,800 186 1,027 556 - 773 57% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 1,800 186 1,027 556 - 773 Cash Balance 508,846 505,459 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 3119 Fund/Department Name Month February Fund/Department Number 328 Date Updated 3/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 635 3,505 1,911 - 2,495 58% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 6,000 635 3,505 1,911 - 2,495 58% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 6,000 635 1,248 909 - 4,752 21% 6,000 635 1,248 909 - 4,752 21% Net- - 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 3120 Fund/Department Name Month February Fund/Department Number 432 Date Updated 3/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 1,827 10,603 6,514 - 14,397 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 25,000 1,827 10,603 6,514 - 14,397 42% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,000 - - 201,724 - 1,000 0% Debt Service 489,503 - 365,835 357,545 - 123,668 75% Capital- - - - - - 0% Transfers Out- - - - - - 0% 490,503 - 365,835 559,269 - 124,668 75% Net(465,503) 1,827 (355,232) (552,756) - (110,271) Cash Balance 4,947,163 5,950,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 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 3121