Loading...
HomeMy WebLinkAbout12-2015 Departmental Financial ReportPeriod Ending: Issued By: City of South Bend Monthly Departmental Financial Report Page Contents 2 Narrative 3 Summaries 7 General Fund 21 Special Revenue Funds 55 Debt Service/Capital Project Funds 67 Enterprise Funds 95 Internal Service Funds 101 Trust Funds 104 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 December 31, 2015 Administration/Finance December 2015  The Monthly Departmental Financial Report  The City of South Bend has developed the attached Monthly Departmental Financial Report to provide current year  financial information for each City fund, as well as individual departments within the General Fund, in a condensed format.  Information is provided for revenue, expenditures, encumbrances, cash balances and staffing levels. Also included in  this report are text boxes that allow departmental fiscal officers to provide an explanation of significant expenditure and  staffing variances and spending on major capital projects. Departmental fiscal officers are asked to complete the monthly  financial reports (“blue sheets”) for their funds and General Fund departments no later than the 18th of the month  following the reporting period. The staff of the Department of Administration & Finance then summarizes the data and  publishes this consolidated report no later than 30 days after the end of the reporting period.  The Monthly Departmental Financial Report supplements—but does not replace—other financial reports that the City  prepares such as the Monthly Financial Report, Controller’s Cash Report, the Department of Local Government Finance’s  Annual Financial Report (AFR), or the Comprehensive Annual Financial Report (CAFR).  Summary Trends & Observations  As of December 31, 2015, total revenue for the year was $280,940,871, 99% of estimated revenue.  As of  December 31,  2014 total revenue received was $261,714,676 within the same funds.  Property taxes are received in June and December  each year and were budgeted at $71,316,341 for 2015. Actual receipts for the  year were $70,914,835 99%  of  expecte d.    Local income tax (LOIT, COIT and EDIT) receipts are budgeted to be $24,357,812 in 2015; the full amount  was received as of December 31.  Local taxes are normally received on a monthly basis.  On March 4, 2015 the City closed on its sale of Blackthorn Golf Course to a private company and received $1,472,130 in  proceeds at that time.  This amount represented the City’s portion of the $1.655 million sale price.  The golf course had  realized $119,238 in revenue by the time of its sale, 7% of its annual budget.  As of December 31, 2015, total expenditures were $293,505,680 and outstanding encumbrances were $49,033,888,  a   total  of  $342,539,568  which   represents  89%   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  76%  of  the  amended  expenditure  budget  at  the  end  of  the  period.    Total  expenditures  were  $268,784,587 as of December 31, 2014.  In 2015 the City re‐organized some of its TIF funds which resulted in the closure of the Downtown TIF (Fund 420) and the  Central Medical Service Area TIF (Fund 426).  The cash balances of these funds were transferred to the River West TIF  (Fund 324) with a portion to River East TIF (Fund 429).  These two funds’ expenditures were therefore finalized at $4.1  million and $2.3 million, respectively, as the expenditure budgets were reduced to match actual.  Thus, they are both at  100% of expenditures budgeted but will have no further expenditures.  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 December 31, 2015 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 54,344,268 17,486,364 53,719,612 55,106,209 624,656 99% Special Revenue 102 Rainy Day 61,280 (14) 49,919 24,483 11,361 81% 103 Excess Levy 20 - 18 3,648 2 89% 201 Parks & Recreation 11,219,015 3,412,341 11,031,940 10,823,968 187,075 98% 202 Motor Vehicle Highway 9,740,800 501,611 9,895,948 8,992,353 (155,148) 102% 203 Recreation Nonreverting 971,935 44,319 1,008,138 945,486 (36,203) 104% 209 Studebaker-Oliver Reverting Grants 136,000 21,987 134,906 3,078 1,094 99% 210 Economic Development State Grants 1,031,290 156,804 1,013,084 73,043 18,206 98% 211 Department of Community Investment (DCI)2,651,425 10,237 2,493,340 2,360,377 158,085 94% 212 Dept of Community Investment Grants 3,027,035 295,678 2,674,985 4,823,850 352,050 88% 216 Police State Seizures 36,050 4 15,422 28,765 20,628 43% 217 Gift, Donation, Bequest 8,800 2,202 9,378 175,299 (578) 107% 218 Police Curfew Violations 1,025 13 233 471 792 23% 220 Law Enforcement Continuing Education 270,000 14,352 290,316 205,888 (20,316) 108% 227 Loss Recovery 60,500 205 54,051 22,331 6,449 89% 244 Emergency Phone System 20 - 19 214,981 1 97% 249 Public Safety LOIT 6,472,240 538,797 6,471,577 6,384,450 663 100% 251 Local Roads & Streets 1,510,300 166,522 1,507,055 1,060,548 3,245 100% 252 Excess Welfare Distribution- - 0 4 (0) 0% 258 Human Rights Federal Grant 209,950 2,639 103,705 272,697 106,245 49% 271 Eastrace Waterway 50 (0) 21 32 29 41% 273 Morris PAC / Palais Royale Marketing 18,000 1,243 11,179 10,685 6,821 62% 280 Police Block Grants 125 - 22 11 103 18% 281 Economic Develop. Commission-Revenue Bonds 300 (0) 157 77 143 52% 289 HAZMAT 14,100 (0) 13,975 24,118 125 99% 291 Indiana River Rescue 45,350 22,123 54,443 41,275 (9,093) 120% 292 Police Grants 90,000 - 56,946 76,865 33,054 63% 294 Regional Police Academy 22,700 750 23,026 18,497 (326) 101% 295 COPS MORE Grant 272,258 407 75,494 12,414 196,764 28% 299 Police Federal Drug Enforcement 77,000 65 71,288 67,724 5,712 93% 404 County Option Income Tax 9,926,971 1,077,508 9,915,529 9,208,686 11,442 100% 408 Economic Development Income Tax 9,599,470 763,618 9,593,082 9,209,938 6,388 100% 410 Urban Development Action Grant 1,040,686 378 1,040,938 78 (252) 100% 655 Project Releaf 431,700 36,480 444,358 439,394 (12,658) 103% 705 Police K-9 Unit 2,000 - 1,520 2,006 480 76% Special Revenue Total 58,948,395 7,070,268 58,056,014 55,527,520 892,381 98% City Debt Service 313 Football Hall of Fame Debt Service 1,201,160 616,029 1,201,076 629,087 84 100% City Debt Service Total 1,201,160 616,029 1,201,076 629,087 84 100% Capital Project 377 Professional Sports Development 814,011 (50) 686,885 619,580 127,126 84% 401 Coveleski Stadium Capital 42,100 (0) 42,103 13,600 (3) 100% 403 Zoo Endowment 200 (0) 283 139 (83) 142% 405 Park Nonreverting Capital 143,700 (47) 14,372 137,177 129,328 10% 406 Cumulative Capital Development 521,569 191,750 521,372 518,386 197 100% 407 Cumulative Capital Improvement 430,050 136,156 429,624 442,559 426 100% 412 Major Moves Construction 813,687 261 805,256 536,455 8,431 99% 416 Morris Performing Arts Center Capital 101,500 10,016 64,133 81,132 37,367 63% 434 Community Revitalization Enhancement District 450 30 360 301 90 80% 450 Palais Royale Historic Preservation 16,150 660 13,252 9,766 2,898 82% 677 Football Hall of Fame Capital 4,700 5 3,112 1,823 1,588 66% Capital Project Total 2,888,117 338,782 2,580,753 2,360,918 307,364 89% Enterprise 287 Emergency Medical Services Capital 3,630,089 (4) 2,872,979 - 757,110 79% 288 Emergency Medical Services Operating 5,439,065 513,752 5,294,240 2,751,725 144,825 97% 600 Consolidated Building Fund 4,550,013 180,699 4,571,871 3,710,384 (21,858) 100% 601 Parking Garages 1,066,224 67,647 975,147 1,021,117 91,077 91% 610 Solid Waste Operations 5,728,389 514,530 5,367,035 5,297,239 361,354 94% 611 Solid Waste Capital 753,011 46,000 659,713 790,065 93,298 88% 620 Water Works Operations 14,810,483 1,076,423 14,418,676 14,546,190 391,807 97% 622 Water Works Capital 10,000 (5) 17,400 10,132 (7,400) 174% 623 Water Works Bond Capital 545 - 544 1,614 1 100% 624 Water Works Customer Deposit 6,000 (9) 8,595 4,182 (2,595) 143% 625 Water Works Sinking 2,050,078 172,154 2,049,802 2,052,253 276 100% 626 Water Works Bond Reserve 9,500 3 6,166 81,001 3,334 65% 629 Water Works Reserve Operations & Maintenance 162,749 1 162,931 59,382 (182) 100% 640 Sewer Repair Insurance 554,800 51,217 615,288 589,894 (60,488) 111% 641 Sewage Works Operations 36,087,567 2,953,590 36,072,162 33,455,803 15,405 100% 642 Sewage Works Capital 5,398,000 847 8,034,993 4,015,111 (2,636,993) 149% 643 Sewage Works Reserve Operations & Maint.271,612 2 276,955 139,626 (5,343) 102% 3 City of South Bend Monthly Department Financial Report REVENUE SUMMARY December 31, 2015 Values Con Fund Type Dept Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget Balance Percent of Budget Ci Enterpr647 Sewer Bond 2007- - - 3 - 0% 649 Sewage Sinking 9,312,088 770,416 9,300,518 9,309,752 11,570 100% 653 Sewage Debt Service Reserve 4 3 3 3 1 78% 658 Sewer Bond 2010- - 0 6 (0) 0% 659 Sewer Bond 2011 6,000 198 4,801 19,665 1,199 80% 661 Sewer Bond 2012 111,000 436 92,797 51,261 18,203 84% 664 2013A Cost of Issuance Fund 50 (0) 26 13 24 52% 670 Century Center 3,879,495 531,664 3,810,729 4,087,704 68,766 98% 671 Century Center Capital 500 85 809 328 (309) 162% 672 Century Center Energy Conservation Debt Svc 50,040 4 50,032 - 8 100% 666 2015 Sewer Bond Issuance 188,232 188,156 188,156 - 76 100% Enterprise Total 94,075,534 7,067,808 94,852,367 81,994,455 (776,833) 101% Internal Service 222 Central Services 8,180,351 575,700 7,380,274 7,064,135 800,077 90% 224 Central Services Capital 271,850 30 271,929 - (79) 100% 226 Liability Insurance 1,358,412 101,943 1,347,166 3,036,215 11,246 99% 278 Take Home Vehicle Police 124,200 13,443 126,547 123,640 (2,347) 102% 711 Self-Funded Employee Benefits 14,529,340 1,155,120 14,379,513 13,318,977 149,827 99% 713 Unemployment Compensation 114,546 8,464 103,078 103,047 11,468 90% Internal Service Total 24,578,699 1,854,700 23,608,507 23,646,014 970,192 96% Trust & Agency 701 Firefighters Pension 5,044,525 (2,719) 5,044,353 5,131,903 172 100% 702 Police Pension 6,385,359 1,214 6,382,756 6,118,790 2,603 100% 730 City Cemetery 150 (0) 164 101 (14) 109% Trust & Agency Total 11,430,034 (1,504) 11,427,273 11,250,794 2,761 100% City Funds Total 247,466,207 34,432,447 245,445,602 230,514,997 2,020,605 99% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF)25,095,612 7,993,656 24,903,369 14,577,531 192,243 99% 420 Tax Incremental Financing (TIF) - Downtown- - - 5,085,358 - 0% 422 TIF - West Washington 429,800 206,863 409,852 582,799 19,948 95% 425 Redevelopment Retail & Leighton Plaza 210,215 14,676 166,751 165,150 43,464 79% 426 TIF - Central Medical Service Area- - - 858,194 - 0% 429 River East Development Area (NE Dev TIF)3,908,633 1,029,785 3,906,426 1,576,990 2,207 100% 430 TIF - Southside Development #1 2,435,750 905,675 2,232,540 2,388,812 203,210 92% 435 TIF - Douglas Road 321,010 106,675 271,422 322,451 49,588 85% 436 River East Residential (NE Res TIF)3,345,690 1,464,000 3,340,143 2,728,304 5,547 100% Tax Increment Financing Total 35,746,710 11,721,331 35,230,503 28,285,589 516,207 99% Redevelopment 433 Redevelopment General 252 1 59 45 193 23% 439 Certified Technology Park 82,239 123 73,581 1,337,965 8,658 89% 454 Airport Urban Enterprise Zone 2,800 (1) 2,180 1,069 620 78% 619 Blackthorn Operations 119,799 - 119,297 1,539,385 502 100% Redevelopment Total 205,090 123 195,117 2,878,465 9,973 95% Debt Service 315 Redevelopment Bond - Airport Taxable 7,400 0 5,989 2,949 1,411 81% 317 Coveleski Debt Service Reserve 3,800 (1) 2,916 1,430 884 77% 328 Redevelopment Bond - Palais Royale 13,000 1 10,007 4,927 2,993 77% 432 TIF - Southside Development #3 50,785 7,674 50,737 26,320 48 100% Debt Service Total 74,985 7,675 69,649 35,626 5,336 93% Redevelopment Commission Controlled Funds Tota 36,026,785 11,729,129 35,495,269 31,199,679 531,516 99% Grand Total 283,492,992 46,161,575 280,940,871 261,714,676 2,552,121 99% 4 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY December 31, 2015 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 755,912 74,392 735,185 697,608 8,616 12,111 98% 101-0104 311 Call Center 486,733 44,760 464,072 429,313 5,933 16,728 97% 101-0201 City Clerk 431,573 45,112 367,921 333,593 11,902 51,750 88% 101-0301 Common Council 490,150 33,845 443,553 417,660 33,684 12,913 97% 101-0302 WNIT Contract 43,000 - 43,000 - - - 100% 101-0401 Administration & Finance 1,985,279 207,765 1,813,199 1,951,255 74,401 97,679 95% 101-0404 Morris Performing Arts Center 1,093,132 110,479 1,005,105 922,302 19,647 68,379 94% 101-0405 Palais Royale 536,293 44,959 432,524 401,325 26,142 77,627 86% 101-0501 Legal Department 1,018,599 109,416 944,503 945,953 262 73,834 93% 101-0602 Engineering 1,058,933 84,920 936,641 996,749 104,804 17,488 98% 101-0801 Police Department 25,633,064 2,884,449 25,106,273 23,686,438 96,071 430,720 98% 101-0802 Communications Center 1,687,540 131,441 1,681,567 1,985,944 - 5,973 100% 101-0901 Fire Department 17,774,474 2,243,226 17,642,924 21,581,197 84,626 46,923 100% 101-1008 Human Rights 382,179 36,654 371,744 334,144 - 10,435 97% 101-1201 Code 2013 2,270 - - 2,311 - 2,270 0% 101-1207 Animal Control 2013- - - 579 - - 0% General Fund Total 53,379,131 6,051,418 51,988,211 54,686,371 466,089 924,832 98% 201 Parks & Recreation 11,063,995 893,215 10,613,131 11,582,413 70,755 380,108 97% 202 Motor Vehicle Highway 10,485,386 1,508,780 8,630,944 8,791,827 633,517 1,220,925 88% 203 Recreation Nonreverting 1,549,469 63,563 1,000,343 909,822 11,550 537,576 65% 209 Studebaker-Oliver Reverting Grants 630,000 13,041 114,170 - 483,250 32,580 95% 210 Economic Development State Grants 3,694,412 390,636 1,182,161 92,560 1,863,486 648,766 82% 211 Department of Community Investment (DCI)2,661,730 260,505 2,445,266 2,193,473 39,612 176,852 93% 212 Dept of Community Investment Grants 6,547,968 356,121 2,912,529 4,623,591 3,556,962 78,478 99% 216 Police State Seizures 35,900 3,116 3,116 - - 32,784 9% 217 Gift, Donation, Bequest 313,646 1,349 82,443 112,095 - 231,203 26% 218 Police Curfew Violations 1,000 - - - - 1,000 0% 220 Law Enforcement Continuing Education 402,478 30,287 361,330 225,832 10,008 31,140 92% 227 Loss Recovery 5,237,243 107,776 4,924,694 2,094,471 130,311 182,238 97% 244 Emergency Phone System- - - 181,329 - - 0% 249 Public Safety LOIT 7,246,551 799,176 7,122,874 7,123,412 - 123,677 98% 251 Local Roads & Streets 2,423,721 23,102 1,224,128 557,475 1,011,945 187,648 92% 252 Excess Welfare Distribution 8 - - 1,146 - 8 0% 258 Human Rights Federal Grant 249,057 17,742 208,559 209,220 - 40,498 84% 271 Eastrace Waterway 4,000 - 3,998 9,092 0 2 100% 273 Morris PAC / Palais Royale Marketing 18,974 878 7,541 11,957 878 10,555 44% 289 HAZMAT 31,530 - 21,542 697 - 9,988 68% 291 Indiana River Rescue 120,800 231 64,398 31,594 - 56,402 53% 292 Police Grants 105,145 7,325 31,159 185,965 55,373 18,613 82% 294 Regional Police Academy 23,750 443 21,091 18,300 - 2,659 89% 295 COPS MORE Grant 172,335 400 60,171 19,524 10,245 101,919 41% 299 Police Federal Drug Enforcement 248,960 - 164,079 107,341 6,964 77,917 69% 404 County Option Income Tax 15,893,667 1,502,769 12,781,976 9,162,940 2,205,471 906,220 94% 408 Economic Development Income Tax 10,133,749 184,872 9,889,262 9,881,839 109,997 134,490 99% 410 Urban Development Action Grant 438,203 292,135 438,203 - - 1 100% 655 Project Releaf 528,358 9,019 502,888 397,542 - 25,470 95% 705 Police K-9 Unit 2,000 - 970 - - 1,030 49% Special Revenue Total 80,264,035 6,466,479 64,812,964 58,525,458 10,200,323 5,250,748 93% 313 Football Hall of Fame Debt Service 1,272,000 - 1,272,000 1,271,300 - - 100% City Debt Service Total 1,272,000 - 1,272,000 1,271,300 - - 100% 377 Professional Sports Development 855,603 - 855,603 865,545 - 1 100% 403 Zoo Endowment 49,000 - - - - 49,000 0% 405 Park Nonreverting Capital 192,933 - 65,812 188,904 11,333 115,788 40% 406 Cumulative Capital Development 542,691 - 530,663 722,934 - 12,028 98% 407 Cumulative Capital Improvement 367,875 - 367,875 369,800 - - 100% 412 Major Moves Construction 3,096,061 79,033 2,289,929 4,038,690 795,033 11,099 100% 416 Morris Performing Arts Center Capital 80,248 8,631 62,828 22,522 14,923 2,497 97% 434 Community Revitalization Enhancement District 650,000 - 7,794 - - 642,206 1% 450 Palais Royale Historic Preservation 16,150 - - - - 16,150 0% 677 Football Hall of Fame Capital 188,824 2,821 59,456 101,009 - 129,368 31% Capital Project Total 6,039,385 90,485 4,239,960 6,309,405 821,289 978,136 84% 287 Emergency Medical Services Capital 750,000 - 300,738 - 363,611 85,651 89% 288 Emergency Medical Services Operating 6,855,366 671,613 5,963,383 5,446,632 57,305 834,678 88% 600 Consolidated Building Fund 4,205,401 419,399 3,412,627 3,128,438 143,388 649,386 85% 601 Parking Garages 1,806,712 502,872 1,408,159 831,676 211,465 187,088 90% 610 Solid Waste Operations 5,873,863 490,503 5,470,212 5,681,203 16,001 387,650 93% 611 Solid Waste Capital 752,811 45,690 694,470 873,306 - 58,341 92% 620 Water Works Operations 15,844,471 1,529,875 14,856,072 13,760,364 399,556 588,842 96% 622 Water Works Capital 838,893 - 262,273 416,576 177,797 398,824 52% 623 Water Works Bond Capital 183,230 - 183,082 631,706 - 148 100% 624 Water Works Customer Deposit 10,000 1,960 9,709 4,997 - 291 97% 625 Water Works Sinking 2,050,828 1,679,449 2,050,053 2,052,934 - 775 100% 626 Water Works Bond Reserve 14,500 2,096 13,281 - - 1,219 92% 629 Water Works Reserve Operations & Maintenance 14,000 2,907 14,406 7,079 - (406) 103% 5 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY December 31, 2015 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 Enterp 640 Sewer Repair Insurance 545,703 57,649 470,776 441,433 3,751 71,176 87% 641 Sewage Works Operations 40,584,912 2,615,787 36,055,923 31,610,541 2,167,029 2,361,970 94% 642 Sewage Works Capital 9,571,710 568,725 3,050,364 4,307,956 5,144,946 1,376,400 86% 643 Sewage Works Reserve Operations & Maint.21,160 4,784 23,677 11,637 - (2,517) 112% 647 Sewer Bond 2007- - 0 1,143 - (0) 0% 649 Sewage Sinking 9,286,436 6,209,221 9,286,114 9,302,222 - 322 100% 653 Sewage Debt Service Reserve 3,181,211 3,181,211 3,181,211 - - 0 100% 658 Sewer Bond 2010- - 2 2,220 - (2) 0% 659 Sewer Bond 2011 3,711,838 - 1,372,292 6,268,779 172,088 2,167,458 42% 661 Sewer Bond 2012 16,624,275 224,759 3,002,019 1,531,023 10,187,063 3,435,193 79% 670 Century Center 4,532,562 417,540 4,019,600 3,818,922 - 512,962 89% 671 Century Center Capital 605,656 - 417,400 339,363 - 188,256 69% 666 2015 Sewer Bond Issuance 188,232 179,066 179,066 0 0 9,167 95% Enterprise Total 128,053,770 18,805,105 95,696,908 90,470,149 19,044,000 13,312,871 90% 222 Central Services 8,329,409 691,188 7,603,685 7,034,645 129,880 595,844 93% 224 Central Services Capital 271,850 23,352 85,009 - 175,065 11,776 96% 226 Liability Insurance 3,056,791 173,068 2,502,034 2,541,638 46,156 508,601 83% 278 Take Home Vehicle Police 71,100 - 1,086 60,580 - 70,014 2% 711 Self-Funded Employee Benefits 16,696,935 1,419,267 14,067,434 14,923,436 44,959 2,584,542 85% 713 Unemployment Compensation 226,796 5,852 74,966 121,906 6,600 145,230 36% Internal Service Total 28,652,881 2,312,727 24,334,214 24,682,205 402,661 3,916,006 86% 701 Firefighters Pension 5,666,579 447,894 5,211,353 5,430,699 - 455,226 92% 702 Police Pension 6,832,235 508,743 6,336,107 6,716,680 - 496,128 93% 730 City Cemetery 20,000 - - 8,658 - 20,000 0% Trust & Agency Total 12,518,814 956,637 11,547,460 12,156,037 - 971,354 92% City Funds Total 310,180,016 34,682,852 253,891,718 248,100,925 30,934,362 25,353,946 92% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF)47,710,597 3,947,846 23,507,071 8,217,759 11,802,076 12,401,451 74% 420 Tax Incremental Financing (TIF) - Downtown 4,088,473 - 4,088,473 3,601,359 - 0 100% 422 TIF - West Washington 760,900 68,276 98,777 12 303,366 358,757 53% 425 Redevelopment Retail & Leighton Plaza 154,716 15,717 130,461 125,690 - 24,255 84% 426 TIF - Central Medical Service Area 2,294,533 - 2,294,533 1,796,073 - 0 100% 429 River East Development Area (NE Dev TIF)7,239,524 646,127 901,774 29,301 4,535,158 1,802,592 75% 430 TIF - Southside Development #1 2,842,535 1,647 1,094,452 871,169 1,311,814 436,269 85% 435 TIF - Douglas Road 345,389 - 341,187 395,621 4,200 2 100% 436 River East Residential (NE Res TIF)3,425,632 - 3,425,628 3,576,880 - 4 100% Tax Increment Financing Total 68,862,299 4,679,612 35,882,356 18,613,864 17,956,614 15,023,329 78% Redevelopment 433 Redevelopment General 6,000 - 1,447 15,703 - 4,553 24% 439 Certified Technology Park 5,000,000 84,631 2,820,835 - 142,913 2,036,253 59% 619 Blackthorn Operations 201,649 - 201,228 1,552,466 - 421 100% Redevelopment Total 5,207,649 84,631 3,023,509 1,568,169 142,913 2,041,227 61% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 1,351 6,740 3,548 - (1,740) 135% 328 Redevelopment Bond - Palais Royale 6,000 2,257 11,262 5,929 - (5,262) 188% 432 TIF - Southside Development #3 691,380 - 690,104 492,151 - 1,276 100% Debt Service Total 702,380 3,609 708,106 501,628 - (5,726) 101% Redevelopment Commission Controlled Funds Total 74,772,328 4,767,851 39,613,971 20,683,661 18,099,526 17,058,830 77% Grand Total 384,952,344 39,450,703 293,505,689 268,784,587 49,033,888 42,412,776 89% 6 Fund/Department Name Month December Fund/Department Number 101-0101 Date Updated 1/22/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 755,212 74,377 735,007 691,505 - 20,205 97% Local Income Taxes- - - - - - 0% Other Taxes- - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 50 - 90 80 - (40) 180% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations 50 15 65 234 - (15) 131% Other Income 600 - 23 5,789 - 577 4% Transfers In- - - - - - 0% Total Revenue 755,912 74,392 735,185 697,608 - 20,727 97% Personnel 684,522 71,006 682,066 619,264 - 2,456 100% Supplies 12,413 1,626 11,665 20,584 662 87 99% Services 56,739 1,613 39,759 54,424 7,954 9,026 84% Debt Service 2,238 147 1,695 3,337 - 543 76% Capital- - - - - - 0% Transfers Out- - - - - - 0% 755,912 74,392 735,185 697,608 8,616 12,111 98% Net- - - - (8,616) 8,616 Cash Balance- - Full Time 7.00 7.00 7.00 Part-Time /Seasonal/Temporary 2.00 1.00 1.00 Total 9.00 8.00 8.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Mayor's Office There are no capital projects budgeted for 2015. Expenditures Revenue Total Expenditures Staffing Expenditures are in line with budgeted expectations for 2015. Last year at this time, the Mayor's office received a one-time settlement fee (from AEP) in the amount of $5789.49. This fee was related to the power outage that occurred earlier in the year. Form 3 7 Fund/Department Name Month December Fund/Department Number 101-0104 Date Updated 1/25/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- - - (27,409) - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 486,733 44,760 464,072 456,722 - 22,661 95% Transfers In- - - - - - 0% Total Revenue 486,733 44,760 464,072 429,313 - 22,661 95% Personnel 441,562 43,017 426,767 392,461 - 14,795 97% Supplies 6,125 70 3,446 15,707 2,350 329 95% Services 39,046 1,674 33,859 21,146 3,583 1,604 96% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 486,733 44,760 464,072 429,313 5,933 16,728 97% Net- - - - (5,933) 5,933 Cash Balance- - Full Time 6.50 6.50 6.50 Part-Time /Seasonal/Temporary 1.00 1.00 1.00 Total 7.50 7.50 7.50 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report 311 Call Center No capital expenditures budgeted in 2015. Expenditures Revenue Total Expenditures Staffing Form 3 8 Fund/Department Name Month December Fund/Department Number 101-0201 Date Updated 1/22/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 431,573 45,112 367,921 333,593 - 63,652 85% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 431,573 45,112 367,921 333,593 - 63,652 85% Personnel 339,442 33,357 313,772 284,153 - 25,670 92% Supplies 12,588 1,823 9,907 8,771 782 1,899 85% Services 79,543 9,932 44,242 40,668 11,120 24,181 70% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 431,573 45,112 367,921 333,593 11,902 51,750 88% Net- - - - (11,902) 11,902 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: 2015 City of South Bend Monthly Financial Report City Clerk This year, a copier has been budgeted for capital expenditures. Expenditures Revenue Total Expenditures Staffing Expenditures are consistent with normal operating costs. Form 3 9 Fund/Department Name Month December Fund/Department Number 101-0301 Date Updated 1/22/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 481,484 33,814 442,974 416,955 - 38,510 92% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations 8,466 31 379 704 - 8,087 4% Other Income 200 - 200 - - - 100% Transfers In- - - - - - 0% Total Revenue 490,150 33,845 443,553 417,660 - 46,597 90% Personnel 229,742 24,275 222,191 199,752 1,418 6,133 97% Supplies 8,706 368 2,610 1,094 4,436 1,661 81% Services 251,702 9,202 218,752 216,813 27,830 5,120 98% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 490,150 33,845 443,553 417,660 33,684 12,913 97% Net- - - - (33,684) 33,684 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: 2015 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 receive a salary. Expenditures higher than normal due to unforseen legal expenses. Form 3 10 Fund/Department Name Month December Fund/Department Number 101-0302 Date Updated 1/22/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 - - - 100% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 43,000 - 43,000 - - - 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 43,000 - 43,000 - - - 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 43,000 - 43,000 - - - 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: 2015 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 3 11 Fund/Department Name Month December Fund/Department Number 101-0401 Date Updated 1/26/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,983,979 207,765 1,812,031 1,946,804 - 171,948 91% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,300 - 1,168 4,452 - 132 90% Transfers In- - - - - - 0% Total Revenue 1,985,279 207,765 1,813,199 1,951,255 - 172,080 91% Personnel 1,710,406 192,313 1,645,092 1,703,591 - 65,314 96% Supplies 40,709 5,343 32,486 32,506 827 7,396 82% Services 228,992 10,109 131,450 212,587 73,574 23,968 90% Debt Service 5,172 - 4,171 2,571 - 1,001 81% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,985,279 207,765 1,813,199 1,951,255 74,401 97,679 95% Net- - - - (74,401) 74,401 Cash Balance- - Full Time 22.00 23.00 Part-Time /Seasonal/Temporary- 1.00 Total 22.00 24.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Administration & Finance None Expenditures Revenue Total Expenditures Staffing Transferred Chief Technology Officer to COIT for 2015 budget and added new HR Generalist position. Overall spending appears consistent with expectations. Full time excludes 3 IT/Innovation employees who are paid from COIT. Encumbrances relate to an outstanding contract for diversity consulting which will take place in 2016. Form 3 12 Fund/Department Name Month December Fund/Department Number 101-0404 Date Updated 1/21/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 170,132 (60,168) 225,918 (83,660) - (55,786) 133% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 917,000 169,892 773,975 999,750 - 143,025 84% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 6,000 755 5,213 6,213 - 787 87% Transfers In- - - - - - 0% Total Revenue 1,093,132 110,479 1,005,105 922,302 - 88,027 92% Personnel 749,285 77,142 727,372 654,026 - 21,913 97% Supplies 33,542 3,773 21,332 18,106 497 11,713 65% Services 310,305 29,564 256,402 250,170 19,150 34,753 89% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,093,132 110,479 1,005,105 922,302 19,647 68,379 94% Net- - - - (19,647) 19,647 Cash Balance- - Full Time 12.00 12.00 Part-Time /Seasonal/Temporary 4.00 4.00 Total 16.00 16.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Total Expenditures Staffing There are no Capital Expenses budgeted for this year. This is an Operating Budget. By Ordinance, Fund 416 is used to support renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons at the Morris Performing Arts Center. There are no Capital Expenses / Projects budgeted this year. 2015 City of South Bend Monthly Financial Report Morris Performing Arts Center Revenue Expenditures Form 3 13 Fund/Department Name Month December Fund/Department Number 101-0405 Date Updated 1/21/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 201,023 16,877 127,602 178,912 - 47,279 63% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 316,270 26,228 286,390 207,619 - 29,880 91% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 19,000 1,855 18,532 14,794 - 468 98% Transfers In- - - - - - 0% Total Revenue 536,293 44,959 432,524 401,325 - 77,627 81% Personnel 263,505 21,721 237,606 229,220 - 25,899 90% Supplies 23,897 2,787 14,686 8,025 505 8,705 64% Services 234,891 20,451 168,160 164,080 25,636 41,094 83% Debt Service- - - - - - 0% Capital 14,000 - 12,072 - - 1,928 86% Transfers Out- - - - - - 0% 536,293 44,959 432,524 401,325 26,142 77,627 86% Net- - - - (26,142) - Cash Balance- - Full Time 2.00 2.00 2.00 Part-Time /Seasonal/Temporary 1.00 1.00 1.00 Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Palais Royale A/V Upgrades (screen, projector, computer). Curtain replacement project ($30,000.00) defer to 2016. Expenditures Revenue Total Expenditures Staffing Form 3 14 Fund/Department Name Month December Fund/Department Number 101-0501 Date Updated 1/26/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 952,349 109,341 886,415 884,628 - 65,934 93% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 3,000 - - 1,581 - 3,000 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 63,250 75 58,088 59,744 - 5,162 92% Transfers In- - - - - - 0% Total Revenue 1,018,599 109,416 944,503 945,953 - 74,096 93% Personnel 948,013 105,646 891,666 902,017 - 56,347 94% Supplies 6,832 688 5,734 3,566 262 836 88% Services 62,454 3,082 45,832 39,099 - 16,622 73% Debt Service 1,300 - 1,271 1,271 - 29 98% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,018,599 109,416 944,503 945,953 262 73,834 93% Net- - - - (262) 262 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: 2015 City of South Bend Monthly Financial Report Legal Department Expenditures Revenue Total Expenditures Staffing The Other Income of $50,000 is reimbursement for legal expenses from TIF funds which was received in November 2015. Spending appears to be on track with budgeted figures. Form 3 15 Fund/Department Name Month December Fund/Department Number 101-0602 Date Updated 1/22/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 981,906 83,170 929,782 973,129 - 52,124 95% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 77,027 1,750 6,858 23,620 - 70,169 9% Transfers In- - - - - - 0% Total Revenue 1,058,933 84,920 936,641 996,749 - 122,292 88% Personnel 687,352 75,343 675,353 568,947 - 11,999 98% Supplies 52,462 2,443 25,595 17,731 25,948 919 98% Services 306,044 6,486 223,910 402,371 78,856 3,278 99% Debt Service 13,075 648 11,783 7,701 - 1,292 90% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,058,933 84,920 936,641 996,749 104,804 17,488 98% Net- - - - (104,804) 104,804 Cash Balance- - Full Time 7.90 8.35 Part-Time /Seasonal/Temporary 1.22 1.40 Total 9.12 9.75 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Engineering Expenditures Revenue Total Expenditures Staffing $78K in encumbrance for Services include $70K for updating the City construction standards and $8K for office remodeling. Other income includes reimbursement from the River West (f/k/a Airport) TIF for 80% of the salary of a new engineer who began near the end of May. Form 3 16 Fund/Department Name Month December Fund/Department Number 101-0801 Date Updated 1/26/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 25,077,864 2,855,845 24,790,938 23,294,709 - 286,926 99% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - 24,316 - - 0% Charges for Services 200,000 - 759 200 - 199,241 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations 7,500 - - - - 7,500 0% Other Income 347,700 28,604 314,576 367,213 - 33,124 90% Transfers In- - - - - - 0% Total Revenue 25,633,064 2,884,449 25,106,273 23,686,438 - 526,791 98% Personnel 22,609,224 2,632,396 22,405,853 19,834,133 - 203,371 99% Supplies 499,279 38,431 394,461 607,080 73,228 31,590 94% Services 2,516,561 213,186 2,299,649 3,175,189 22,843 194,069 92% Debt Service 8,000 436 6,310 4,878 - 1,690 79% Capital- - - 65,158 - - 0% Transfers Out- - - - - - 0% 25,633,064 2,884,449 25,106,273 23,686,438 96,071 430,720 98% Net- - - - (96,071) 96,071 Cash Balance- - Full Time 263.00 254.00 254.00 Part-Time /Seasonal/Temporary 60.00 25.00 25.00 Total 323.00 279.00 279.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Police Department Expenditures Revenue Total Expenditures Staffing This fund includes the expenditures for 217 of the 260 budgeted Police officers and 106 civilian staff. Fund 249 contains the funding for 43 of the 260 Police officers that are funded by the LOIT. The 2015 Personnel Expenditure exceeds the prior year amount due to the increase in Police salaries, transfer of five officer's salaries from the LOIT to the General Fund and the transfer of eight Front Desk Staff from the Communications Budget to the Police Budget in 2015. The decrease in Services in 2015 compared to 2014 is due to a reduction in the Insurance charge. Form 3 17 Fund/Department Name Month December Fund/Department Number 101-0802 Date Updated 1/26/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,687,540 131,441 1,681,567 1,985,944 - 5,973 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 1,687,540 131,441 1,681,567 1,985,944 - 5,973 100% Personnel 143,972 2,811 138,007 1,973,871 - 5,965 96% Supplies- - - 1,362 - - 0% Services 1,543,568 128,630 1,543,560 10,711 - 8 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,687,540 131,441 1,681,567 1,985,944 - 5,973 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: 2015 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 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 of $1,543,568 is the annual amount that the County will charge SBPD as a participant in using the PSAP. Form 3 18 Fund/Department Name Month December Fund/Department Number 101-0901 Date Updated 1/26/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 17,761,074 2,243,465 17,633,103 20,001,066 127,971 99% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 6,100 (239) 722 576,925 - 5,378 12% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 7,300 9,099 3,206 - (1,799) 125% Transfers In- - - 1,000,000 - - 0% Total Revenue 17,774,474 2,243,226 17,642,924 21,581,197 - 131,550 99% Personnel 16,157,086 2,011,574 16,139,096 19,594,551 13,974 4,016 100% Supplies 320,618 68,214 216,821 356,742 62,492 41,305 87% Services 1,296,770 163,438 1,287,008 1,629,903 8,160 1,602 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 17,774,474 2,243,226 17,642,924 21,581,197 84,626 46,923 100% Net- - - - (84,626) 84,626 Cash Balance- - Full Time 170.00 170.00 Part-Time /Seasonal/Temporary- - Total 170.00 170.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Fire Department The Fire Department uses EMS Capital Fund 287 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through that fund. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Expenditures Revenue Total Expenditures Staffing The South Bend Fire Department is budgeted to have 251 sworn firefighters and 7 civilian full time employees. 37 firefighters are paid directly through the Public Safety LOIT. 47 Sworn Employee's and 4 civilian employee's costs are allocated to Fund 288 EMS Operations. We hold a lengthy recruitment process every 2 years and hire individuals in groups of 6-10 as needed while that list is in effect. We also employ civilian administrative staff that handle payroll, purchasing and billing for our ambulance service. Form 3 19 Fund/Department Name Month December Fund/Department Number 101-1008 Date Updated 1/22/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 382,179 36,654 371,744 334,144 - 10,435 97% 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 382,179 36,654 371,744 334,144 - 10,435 97% Personnel 295,475 30,604 292,814 267,336 - 2,661 99% Supplies 2,010 39 955 1,354 - 1,055 47% Services 73,492 6,011 67,568 65,453 - 5,924 92% Debt Service- - - - - - 0% Capital 11,202 - 10,407 - - 795 93% Transfers Out- - - - - - 0% 382,179 36,654 371,744 334,144 - 10,435 97% Net- - - - - 0 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: 2015 City of South Bend Monthly Financial Report Human Rights Human Rights had money encumbered from last year for a copier. Purchase was made in January. Expenditures Revenue Total Expenditures Staffing Expenditures are consistent with normal operating costs. Form 3 20 Fund/Department Name Month December Fund/Department Number 102 Date Updated 1/22/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 61,280 (14) 49,919 24,483 - 11,361 81% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 61,280 (14) 49,919 24,483 - 11,361 81% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 61,280 (14) 49,919 24,483 - 11,361 Cash Balance 8,678,882 8,632,917 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Rainy Day N/A Expenditures Revenue Total Expenditures Staffing No significant changes at this time. No expenditures are budgeted in this fund. The establishment of a Rainy Day Fund is looked upon favorably by bond rating agencies and is one of the factors resulting in South Bend's good AA bond rating with Standard & Poor's. Form 3 21 Fund/Department Name Month December Fund/Department Number 103 Date Updated 1/22/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- - - 3,648 - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 20 - 18 - - 2 89% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 20 - 18 3,648 - 2 89% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 20 - 18 3,648 - 2 Cash Balance 3,660 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: 2015 City of South Bend Monthly Financial Report Excess Levy N/A Expenditures Revenue Total Expenditures Staffing A small excess of property tax was received in December 2014. The balance will be rolled into the General Fund in 2016. Form 3 22 Fund/Department Name Month December Fund/Department Number 201 Date Updated 1/27/2015 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,488,000 2,938,429 7,487,554 7,365,388 - 446 100% Local Income Taxes- - - - - - 0% Other Taxes 1,551,175 412,614 1,551,060 1,383,093 - 115 100% Grants/Intergovernmental- - - - - - 0% Charges for Services 2,025,640 50,851 1,833,644 1,899,537 - 191,996 91% Interest Earnings 10,000 (1,886) 26,458 24,621 - (16,458) 265% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 144,200 12,334 133,224 151,329 - 10,976 92% Transfers In- - - - - - 0% Total Revenue 11,219,015 3,412,341 11,031,940 10,823,968 - 187,075 98% Personnel 7,081,699 667,615 6,875,781 6,805,120 205,918 97% Supplies 1,153,635 63,146 982,762 1,203,587 42,921 127,953 89% Services 2,528,704 111,489 2,454,731 3,074,013 27,835 46,139 98% Debt Service 299,957 50,965 299,858 315,007 - 99 100% Capital- - 87,867 - - 0% Transfers Out- - - 96,819 - - 0% 11,063,995 893,215 10,613,131 11,582,413 70,755 380,108 97% Net 155,020 2,519,126 418,809 (758,445) (70,755) (193,034) Cash Balance 3,913,925 3,494,861 Full Time 90.00 86.00 86.00 Part-Time /Seasonal/Temporary na 79.00 79.00 Total 90.00 165.00 165.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Parks & Recreation Because of decreasing property tax revenues, there is no capital budget in fund 201. A $5.6 million bond has been approved and funding was received in the second quarter of 2015. 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. Form 3 23 Fund/Department Name Month December Fund/Department Number 202 Date Updated 1/27/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,697,000 434,780 5,814,812 5,320,036 (117,812) 102% Grants/Intergovernmental- - 0% Charges for Services 265,000 85,987 326,231 336,930 (61,231) 123% Interest Earnings 34,500 1,502 27,508 10,051 6,992 80% Bond Proceeds- - 0% Donations- - 0% Other Income 41,300 (20,657) 24,398 108,754 16,902 59% Transfers In 3,703,000 3,703,000 3,216,582 - 100% Total Revenue 9,740,800 501,611 9,895,948 8,992,353 - (155,148) 102% Personnel 4,314,548 407,361 3,665,647 3,756,343 648,901 85% Supplies 2,789,854 464,687 2,086,257 2,413,249 370,477 333,121 88% Services 2,853,520 636,415 2,461,879 2,232,980 223,582 168,059 94% Debt Service 448,006 318 377,703 255,226 70,303 84% Capital 79,458 39,458 134,030 39,458 542 99% Transfers Out- - 0% 10,485,386 1,508,780 8,630,944 8,791,827 633,517 1,220,925 88% Net(744,586) (1,007,169) 1,265,004 200,526 (633,517) (1,376,074) Cash Balance 5,210,952 3,891,051 Full Time 52.65 44.35 Part-Time /Seasonal/Temporary 4.98 2.24 Total 57.63 46.59 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Motor Vehicle Highway Expenditures Revenue Total Expenditures Staffing Information included for Streets, Traffic & Lighting, and Curb & Sidewalk. Form 3 24 Fund/Department Name Month December Fund/Department Number 203 Date Updated 1/22/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 923,935 44,305 944,718 842,288 - (20,783) 102% Interest Earnings 3,000 14 5,004 2,422 - (2,004) 167% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 45,000 - 58,416 100,775 - (13,416) 130% Transfers In- - - - - - 0% Total Revenue 971,935 44,319 1,008,138 945,486 - (36,203) 104% Personnel 737,842 42,277 506,540 465,680 - 231,302 69% Supplies 289,470 11,564 241,911 205,890 1,736 45,823 84% Services 522,157 9,722 248,342 238,252 9,814 264,001 49% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - 3,550 - - (3,550) 0% 1,549,469 63,563 1,000,343 909,822 11,550 537,576 65% Net(577,534) (19,244) 7,795 35,663 (11,550) (573,779) Cash Balance 821,640 813,708 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: 2015 City of South Bend Monthly Financial Report Recreation Nonreverting Expenditures Revenue Total Expenditures Staffing This fund accounts for Parks and Recreation programs and events that are self funded through user fees. Registration for spring program, classes and softball leagues began in February.Part time employees are individuals, not FTEs. Form 3 25 Fund/Department Name Month December Fund/Department Number 209 Date Updated 1/26/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 129,000 22,003 128,597 - - 403 100% Charges for Services- - - - - - 0% Interest Earnings 7,000 (17) 6,309 3,078 - 691 90% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 136,000 21,987 134,906 3,078 - 1,094 99% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 630,000 13,041 114,170 - 483,250 32,580 95% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 630,000 13,041 114,170 - 483,250 32,580 95% Net(494,000) 8,946 20,736 3,078 (483,250) (31,486) Cash Balance 1,105,516 1,085,299 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Studebaker-Oliver Reverting Grants Expenditures Revenue Total Expenditures Staffing The $630,000 represents a Brownfield Assessment Grant awarded by EPA for use in South Bend , Mishawaka and St. Joseph County. Consultant work proceeding. Form 3 26 Fund/Department Name Month December Fund/Department Number 210 Date Updated 1/26/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 957,000 156,299 956,299 - - 701 100% Charges for Services- - - - - - 0% Interest Earnings 13,574 504 11,230 14,842 - 2,344 83% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 60,716 - 45,555 58,200 - 15,161 75% Transfers In- - - - - - 0% Total Revenue 1,031,290 156,804 1,013,084 73,043 - 18,206 98% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,622,400 108,583 310,151 20,550 663,486 648,764 60% Debt Service 72,012 18,003 72,010 72,010 - 2 100% Capital 2,000,000 264,050 800,000 - 1,200,000 - 100% Transfers Out- - - - - - 0% 3,694,412 390,636 1,182,161 92,560 1,863,486 648,766 82% Net(2,663,122) (233,832) (169,077) (19,518) (1,863,486) (630,560) Cash Balance 160,350 329,079 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 No significant issues. 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. Form 3 27 Fund/Department Name Month December Fund/Department Number 211 Date Updated 1/27/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 254,000 9,813 258,381 315,228 - (4,381) 102% Grants/Intergovernmental 416,787 - 257,933 347,467 - 158,854 62% Charges for Services 2,000 - 430 370 - 1,570 22% Interest Earnings 8,500 423 6,477 2,626 - 2,023 76% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 2,500 1 2,481 5,727 - 19 99% Transfers In 1,967,638 - 1,967,638 1,688,959 - - 100% Total Revenue 2,651,425 10,237 2,493,340 2,360,377 - 158,085 94% Personnel 2,120,943 217,680 1,979,897 1,902,952 - 141,046 93% Supplies 35,753 1,159 26,059 31,197 691 9,004 75% Services 505,034 41,666 439,310 259,325 38,922 26,802 95% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 2,661,730 260,505 2,445,266 2,193,473 39,612 176,852 93% Net(10,305) (250,268) 48,074 166,903 (39,612) (18,766) Cash Balance 1,120,584 1,073,066 Full Time 25.00 25.00 25.00 Part-Time /Seasonal/Temporary- - - Total 25.00 25.00 25.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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, 1 person left and it was announced that 2 other positions will be vacated in January. In early January, another staff member announced his departure. One position filled, making progress on the other 3 hope to fill in February. Form 3 28 Fund/Department Name Month December Fund/Department Number 212 Date Updated 1/27/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,514,035 224,646 2,338,715 4,287,123 - 175,320 93% Charges for Services 1,000 10 504 864 - 496 50% Interest Earnings 2,000 (537) 1,252 1,582 - 748 63% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 510,000 71,560 334,514 534,282 - 175,486 66% Transfers In- - - - - - 0% Total Revenue 3,027,035 295,678 2,674,985 4,823,850 - 352,050 88% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 180,000 - 180,000 - - - 100% Capital- - - - - - 0% Grants 6,367,968 356,121 2,732,529 4,623,591 3,556,962 78,478 99% Transfers Out- - - - - - 0% 6,547,968 356,121 2,912,529 4,623,591 3,556,962 78,478 99% Net(3,520,933) (60,442) (237,544) 200,259 (3,556,962) 273,573 Cash Balance 552,313 790,334 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Dept of Community Investment Grants Expenditures Revenue Total Expenditures Staffing This fund covers multiple federal grants. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on-going and the timing of funding varies widely. We can only draw revenue in response to funds expended so revenues will come in as funds are spent. The federal government does not allow us to hold too much cash. Form 3 29 Fund/Department Name Month December Fund/Department Number 216 Date Updated 1/26/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 - 14,314 28,309 - 20,686 41% Charges for Services- - - - - - 0% Interest Earnings 450 4 1,108 456 - (658) 246% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 600 - - - - 600 0% Transfers In- - - 0% Total Revenue 36,050 4 15,422 28,765 - 20,628 43% Personnel- - - - - - 0% Supplies- 0% Services 35,900 3,116 3,116 32,784 9% Debt Service- - - - - 0% Capital- - - - - - 0% Transfers Out- 0% 35,900 3,116 3,116 - - 32,784 9% Net 150 (3,112) 12,306 28,765 - (12,156) Cash Balance 199,434 187,231 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Police State Seizures Expenditures Revenue Total Expenditures Staffing Revenue stream is not a steady flow. It is dependent upon the processing and release of funds from the State for seized assets in drug activities. Expenditures are to be used to support the Police Departments effort to combat drug activity. Form 3 30 Fund/Department Name Month December Fund/Department Number 217 Date Updated 1/22/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 (1) 508 382 - 292 63% Bond Proceeds- - - - - - 0% Donations 8,000 2,203 8,870 174,918 - (870) 111% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 8,800 2,202 9,378 175,299 - (578) 107% Personnel- - - - - - 0% Supplies 1,552 1,349 1,349 14,625 - 203 87% Services 297,094 - 81,093 97,470 - 216,001 27% Debt Service- - - - - - 0% Capital 15,000 - - - - 15,000 0% Transfers Out- - - - - - 0% 313,646 1,349 82,443 112,095 - 231,203 26% Net(304,846) 852 (73,065) 63,204 - (231,781) Cash Balance 64,775 137,790 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Gift, Donation, Bequest None Expenditures Revenue Total Expenditures Staffing The Gift, Donation, and Bequest fund may be used by all City departments but, normally, the majority of donations are for Animal Care and Control and Community Investment (e.g. bicycle signs). In 2015, the second half of a grant for V&A housing in the amount of $216,000 was expected and was to be used to remediate or demolish qualifying structures. There was also $175,000 expected from a DCI grant that never materialized. Form 3 31 Fund/Department Name Month December Fund/Department Number 218 Date Updated 1/26/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,000 13 163 438 - 837 16% Interest Earnings 25 - 70 33 - (45) 280% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,025 13 233 471 - 792 23% Personnel- - - - - - 0% Supplies- - - - - 0% Services 1,000 - - - - 1,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,000 - - - - 1,000 0% Net 25 13 233 471 - (208) Cash Balance 12,219 11,993 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Police Curfew Violations Expenditures Revenue Total Expenditures Staffing This fund was established to collect curfew and prostitution fines. Expenditures are used for Police activities and training. Form 3 32 Fund/Department Name Month December Fund/Department Number 220 Date Updated 1/26/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 50,000 - 49,119 10,000 - 881 98% Charges for Services 182,000 14,368 217,953 173,953 - (35,953) 120% Interest Earnings 3,000 (16) 5,530 2,839 - (2,530) 184% Bond Proceeds- - - - - - 0% Donations 2,000 - 1,245 560 - 755 62% Other Income 33,000 - 16,469 18,536 - 16,531 50% Transfers In- - - .- - 0% Total Revenue 270,000 14,352 290,316 205,888 - (20,316) 108% Personnel- - - - - - 0% Supplies 172,478 26,462 144,117 37,370 10,008 18,353 89% Services 230,000 3,825 217,213 174,515 - 12,787 94% Debt Service- - - - - - 0% Capital- - - 13,947 - - 0% Transfers Out- - - - - - 0% 402,478 30,287 361,330 225,832 10,008 31,140 92% Net(132,478) (15,935) (71,014) (19,944) (10,008) (51,456) Cash Balance 909,540 960,250 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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. The increase in Charges for Service compared to 2014 was due to increased revenue from accident reports and false alarm fees. Supplies expenditures exceeds 2014 due to the transfer of operating supply expenditures from the General Fund and increased training in 2015. Form 3 33 Fund/Department Name Month December Fund/Department Number 227 Date Updated 1/22/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,000 205 23,551 22,331 - 6,449 79% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 30,500 - 30,500 - - - 100% Transfers In- - - - - - 0% Total Revenue 60,500 205 54,051 22,331 - 6,449 89% Personnel- - - - - - 0% Supplies 74,690 - 72,461 - - 2,229 97% Services 3,273,445 33,574 3,021,134 1,884,503 72,302 180,009 95% Debt Service- - - - - - 0% Capital 1,889,108 74,202 1,831,099 209,968 58,009 - 100% Transfers Out- - - - - - 0% 5,237,243 107,776 4,924,694 2,094,471 130,311 182,238 97% Net(5,176,743) (107,571) (4,870,644) (2,072,140) (130,311) (175,788) Cash Balance 991,738 5,857,602 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Loss Recovery $1.889 million has been budgeted in 2015 for the Smart Streets initiative. As of December, all Capital encumbrances are for the Lincolnway West Corridors project. In September, change orders were approved to contracts for Martell Electric, Rieth-Riley Construction and Fuerbringer Landscaping in the amount of $77,970 without a corresponding appropriation. This was corrected in December. Expenditures Revenue Total Expenditures Staffing Of the $3.28 million budgeted for Services, $72K remains encumbered for the vacant and abandoned housing initiative. The Other Income is revenue from the Light Up South Bend program, where residents pay $250 of the cost toward installation of Lampposts in their front yards. The extra $500 in revenue is offset by a $500 return as two homeowners weren't able to participate in the program and had their contributions returned to them. In August an additional $12,150 was added to the purchase order for the yard lamppost program without a corresponding adjustment to the budget. This was corrected in November. Form 3 34 Fund/Department Name Month December Fund/Department Number 244 Date Updated 1/22/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- - - 215,000 - - 0% Charges for Services- - - - - - 0% Interest Earnings 20 - 19 (19) - 1 97% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 20 - 19 214,981 - 1 97% Personnel- - - 181,329 - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 181,329 - - 0% Net 20 - 19 33,651 - 1 Cash Balance 33,671 33,615 Full Time 3.00 - - Part-Time /Seasonal/Temporary- - - Total 3.00 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Emergency Phone System None. No capital is purchased from this fund. Expenditures Revenue Total Expenditures Staffing This fund was set up per requirement by the State Board Of Accounts (SBOA) to cover the cost of 911 Police Communication personnel costs covered by a State Grant. This fund was closed in 2015 with the advent of the county-wide PSAP system. Form 3 35 Fund/Department Name Month December Fund/Department Number 249 Date Updated 1/22/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,466,190 538,849 6,466,190 6,380,029 - (0) 100% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 6,000 (53) 5,373 4,421 - 627 90% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 50 - 13 - - 37 27% Transfers In- - - - - - 0% Total Revenue 6,472,240 538,797 6,471,577 6,384,450 - 663 100% Personnel 7,246,551 799,176 7,122,874 7,123,412 - 123,677 98% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 7,246,551 799,176 7,122,874 7,123,412 - 123,677 98% Net(774,311) (260,380) (651,297) (738,962) - (123,014) Cash Balance 640,958 1,291,845 Full Time 80.00 Part-Time /Seasonal/Temporary- - Total 80.00 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 43 police officers and 37 firefighters in 2015. Form 3 36 Fund/Department Name Month December Fund/Department Number 251 Date Updated 1/22/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,046,000 92,778 1,045,516 1,017,383 - 484 100% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 17,300 (158) 15,179 6,174 - 2,122 88% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 447,000 73,903 446,361 36,991 - 639 100% Transfers In- - - - - - 0% Total Revenue 1,510,300 166,522 1,507,055 1,060,548 - 3,245 100% Personnel- - - - - - 0% Supplies 380,229 13,721 357,704 471,771 19,668 2,857 99% Services 245,000 - 11,000 - 219,369 14,631 94% Debt Service- - - - - - 0% Capital 1,798,492 9,381 855,424 85,704 772,908 170,160 91% Transfers Out- - - - - - 0% 2,423,721 23,102 1,224,128 557,475 1,011,945 187,648 92% Net(913,421) 143,420 282,927 503,073 (1,011,945) (184,403) Cash Balance 2,723,225 2,441,825 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Local Roads & Streets Projects in 2015 include the Safe Routes to School initiative for Coquillard and Harrison schools, Bendix Drive, and the Boland bicycle trail. The $773K in encumbrance includes $158K for Bendix Dr. (Lathrop to Toll Road), $160K for the Boland Trail, $240K for Safe Routes to School (Coquillard, Harrison, Perley and Lincoln schools) and $200K for Olive St. at Sample design. Expenditures Revenue Total Expenditures Staffing This fund receives most of its revenue through the gas tax, budgeted at $1 million for 2015. 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 $537,000 is used for material for street repairs and other maintenance items. In July a new estimate of gas tax receivable increased the revenue budget by $45,000. The encumbrance for $20K in Supplies is for paving material for the Streets Department. The encumbrance for $219K in Services includes $73K for emergency riverbank stabilization at Northshore Drive, $133K for traffic signal upgrades placed at various intersections around the City and $13K for updates to the City construction standards. Form 3 37 Fund/Department Name Month December Fund/Department Number 252 Date Updated 1/22/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 4 - (0) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - 0 4 - (0) 0% Personnel- - - - - - 0% Supplies 8 - - 1,146 - 8 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 8 - - 1,146 - 8 0% Net(8) - 0 (1,142) - (8) 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: 2015 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 was to have been closed out in 2015. Form 3 38 Fund/Department Name Month December Fund/Department Number 258 Date Updated 1/22/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 189,000 2,500 77,117 185,783 - 111,883 41% Charges for Services- - - - - - 0% Interest Earnings 2,000 99 2,506 1,480 - (506) 125% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 18,950 40 24,082 85,434 - (5,132) 127% Transfers In- - - - - - 0% Total Revenue 209,950 2,639 103,705 272,697 - 106,245 49% Personnel 123,657 12,841 118,884 109,817 - 4,773 96% Supplies 2,800 194 1,818 1,901 - 982 65% Services 122,600 4,707 87,857 97,501 - 34,743 72% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 249,057 17,742 208,559 209,220 - 40,498 84% Net(39,107) (15,102) (104,853) 63,477 - 65,746 Cash Balance 424,866 529,763 Full Time 2.00 2.00 2.00 Part-Time /Seasonal/Temporary 2.00 2.00 2.00 Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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. Expenditures are consistent with normal operating costs. Form 3 39 Fund/Department Name Month December Fund/Department Number 271 Date Updated 1/22/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 50 (0) 21 32 - 29 41% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 50 (0) 21 32 - 29 41% Personnel- - - - - - 0% Supplies 4,000 - 3,998 9,092 0 2 100% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 4,000 - 3,998 9,092 0 2 100% Net(3,950) (0) (3,977) (9,060) (0) 27 Cash Balance 1,333 5,307 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Eastrace Waterway Expenditures Revenue Total Expenditures Staffing This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In recent years there have been no races. Form 3 40 Fund/Department Name Month December Fund/Department Number 273 Date Updated 1/21/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,900 1,244 11,021 10,610 - 6,879 62% Interest Earnings 100 (2) 158 75 - (58) 158% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 18,000 1,243 11,179 10,685 - 6,821 62% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 18,974 878 7,541 11,957 878 10,555 44% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 18,974 878 7,541 11,957 878 10,555 44% Net(974) 365 3,638 (1,272) (878) (3,735) Cash Balance 30,306 26,685 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Morris PAC / Palais Royale Marketing No Capital spending in this fund Expenditures Revenue Total Expenditures Staffing The Morris Performing Arts Center and Palais Royale Marketing Fund was established as a separate non-reverting fund to receive monies from solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marqee sponsorships; and to accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale. The funds in this account at the end of the fiscal year shall not revert to the general fund. Form 3 41 Fund/Department Name Month December Fund/Department Number 280 Date Updated 1/22/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 125 - 22 11 - 103 18% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 125 - 22 11 - 103 18% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 125 - 22 11 - 103 Cash Balance 3,844 3,824 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Police Block Grants Expenditures Revenue Total Expenditures Staffing Justice Assistance Grant 2009-SB-B9-1280 was essentially completed in 2014. Form 3 42 Fund/Department Name Month December Fund/Department Number 281 Date Updated 1/27/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 - - - - 200 0% Interest Earnings 100 (0) 157 77 - (57) 157% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 300 (0) 157 77 - 143 52% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 300 (0) 157 77 - 143 Cash Balance 27,320 27,176 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 2015. Form 3 43 Fund/Department Name Month December Fund/Department Number 289 Date Updated 1/26/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 14,000 - 13,787 24,055 - 213 98% Interest Earnings 100 (0) 189 63 - (89) 189% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 14,100 (0) 13,975 24,118 - 125 99% Personnel- - - - - - 0% Supplies 31,530 - 21,542 697 - 9,988 68% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 31,530 - 21,542 697 - 9,988 68% Net(17,430) (0) (7,566) 23,421 - (9,864) Cash Balance 32,014 39,586 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report HAZMAT No major capital expenditures are planned through this fund. Major purchases are funded through the Fire Department and EMS Capital and the minimal fees collected in this fund are used to replace equipment and gear used in responses. Expenditures Revenue Total Expenditures Staffing Charges for Service for HAZ-MAT responses. By ordinance the South Bend Fire Department charges businesses for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund, responses are made by firefighters of the South Bend Fire Department. Form 3 44 Fund/Department Name Month December Fund/Department Number 291 Date Updated 1/28/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- - - 975 - - 0% Charges for Services 45,000 22,150 53,950 40,000 - (8,950) 120% Interest Earnings 350 (27) 493 300 - (143) 141% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 45,350 22,123 54,443 41,275 - (9,093) 120% Personnel 7,500 231 3,512 2,474 - 3,988 47% Supplies 8,800 - 2,259 1,973 - 6,541 26% Services 79,500 - 37,630 27,146 - 41,870 47% Debt Service- - - - - - 0% Capital 25,000 - 20,997 - - 4,003 84% Transfers Out- - - - - - 0% 120,800 231 64,398 31,594 - 56,402 53% Net(75,450) 21,893 (9,955) 9,681 - (65,495) Cash Balance 95,300 105,286 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Indiana River Rescue Expenditures Revenue Total Expenditures Staffing No staffing associated with this fund. The fund collects tuition fees for students attending the Indiana River Rescue School. There are typically 2-4 schools a year, each a week in duration. Expenditures are for the maintenance and repair of rescue equipment. Form 3 45 Fund/Department Name Month December Fund/Department Number 292 Date Updated 1/27/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 90,000 - 56,891 76,920 - 33,109 63% Charges for Services- - - - - - 0% Interest Earnings- - 55 (55) - (55) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 90,000 - 56,946 76,865 - 33,054 63% Personnel- - - - - - 0% Supplies 15,186 - 14,186 958 - 1,000 93% Services 89,959 7,325 16,973 147,305 55,373 17,613 80% Debt Service- - - - - - 0% Capital- - - 37,702 - - 0% Transfers Out- - - - - - 0% 105,145 7,325 31,159 185,965 55,373 18,613 82% Net(15,145) (7,325) 25,787 (109,100) (55,373) 14,441 Cash Balance 121,196 95,306 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Police Grants Expenditures Revenue Total Expenditures Staffing This Fund was set up to track the revenue and expenditures related to specific Federal Grants. Expenditures have been outlined in the grant. Form 3 46 Fund/Department Name Month December Fund/Department Number 294 Date Updated 1/27/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,500 750 22,638 18,275 - (2,138) 110% Interest Earnings 200 - 388 222 - (188) 194% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In- - - - - - 0% Total Revenue 22,700 750 23,026 18,497 - (326) 101% Personnel- - - - - - 0% Supplies 1,750 - 1,295 1,305 - 455 74% Services 22,000 443 19,796 16,995 - 2,204 90% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 23,750 443 21,091 18,300 - 2,659 89% Net(1,050) 307 1,935 198 - (2,985) Cash Balance 70,112 68,210 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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. The Service expenditure in 2015 included the instructor cost for a Field Training Officer course offered by the Academy. Form 3 47 Fund/Department Name Month December Fund/Department Number 295 Date Updated 1/27/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 208,658 - 34,019 - - 174,639 16% Charges for Services- - - - - - 0% Interest Earnings 350 7 620 318 - (270) 177% Bond Proceeds- - - - - - 0% Donations 3,250 - 300 - - 2,950 9% Other Income 38,000 400 19,590 12,096 - 18,410 52% Transfers In 22,000 - 20,965 - - 1,035 95% Total Revenue 272,258 407 75,494 12,414 - 196,764 28% Personnel- - - - - - 0% Supplies 45,735 - 34,265 8,549 10,245 1,225 97% Services 66,000 400 25,906 10,975 - 40,094 39% Debt Service- - - - - - 0% Capital 60,600 - - - - 60,600 0% Transfers Out- - - - - - 0% 172,335 400 60,171 19,524 10,245 101,919 41% Net 99,923 7 15,323 (7,110) (10,245) 94,845 Cash Balance 121,372 106,120 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report COPS MORE Grant Expenditures Revenue Total Expenditures Staffing This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds received from the grants along with impound towing fees. Form 3 48 Fund/Department Name Month December Fund/Department Number 299 Date Updated 1/27/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 75,000 - 66,449 59,110 - 8,551 89% Charges for Services- - - - - - 0% Interest Earnings 1,000 65 975 978 - 25 98% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,000 - 3,864 7,636 - (2,864) 386% Transfers In- - - - - - 0% Total Revenue 77,000 65 71,288 67,724 - 5,712 93% Personnel- - - - - - 0% Supplies 84,759 - 60,827 38,767 6,964 16,968 80% Services 34,201 - 23,541 27,395 - 10,660 69% Debt Service- - - - - - 0% Capital 130,000 - 79,711 41,179 - 50,289 61% Transfers Out- - - - - - 0% 248,960 - 164,079 107,341 6,964 77,917 69% Net(171,960) 65 (92,791) (39,617) (6,964) (72,205) Cash Balance 252,752 345,543 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Police Federal Drug Enforcement Expenditures Revenue Total Expenditures Staffing This fund was established to receive the Police Department share of money acquired in drug enforcement activity. Expenditures are to be used to fund drug enforcement and training. Form 3 49 Fund/Department Name Month December Fund/Department Number 404 Date Updated 1/22/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 8,859,912 738,326 8,859,912 8,645,811 - - 100% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 101,000 921 84,868 41,371 - 16,132 84% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 966,059 338,261 970,749 521,505 - (4,690) 100% Transfers In- - - - - - 0% Total Revenue 9,926,971 1,077,508 9,915,529 9,208,686 - 11,442 100% Personnel 367,077 31,695 326,158 - - 40,919 89% Supplies 1,064,804 41,474 793,012 1,069,185 129,893 141,899 87% Services 9,386,956 1,308,398 6,907,266 4,880,070 1,810,208 669,482 93% Debt Service 2,487,508 121,202 2,446,999 1,997,409 - 40,509 98% Capital 1,087,322 - 808,541 116,275 265,370 13,411 99% Transfers Out 1,500,000 - 1,500,000 1,100,000 - - 100% 15,893,667 1,502,769 12,781,976 9,162,940 2,205,471 906,220 94% Net(5,966,696) (425,260) (2,866,446) 45,747 (2,205,471) (894,778) Cash Balance 12,066,548 14,935,342 Full Time 4.00 3.00 3.00 Part-Time /Seasonal/Temporary- - - Total 4.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report County Option Income Tax This year, $341,500 has been budgeted for IT upgrades such as fiber enhancements to the County City building, Central Services and the Water Works Olive St. Station. An additional $972,500 was appropriated in May 2014 to pay Transpo for the City's portion of the new CNG fueling station. An encumbered amount of $890,000 remaining has been carried forward to 2015. Lastly, approximately $470,000 has been budgeted for the corridors implementation. Expenditures Revenue Total Expenditures Staffing Transferred Chief Information Officer (fomerly Director of IT) and Chief Innovation Officer and (2) Business Analysts (new in 2015) to COIT. Budget increase of approximately $3.0 million in "Services" for education and travel due to IT related expenses to COIT to maintain IT professional who support the city. Increase also due to election expense as 2015 is a mayoral election year. This category also increased to include the SMART program and construction skill training and recruiting expenses. Other income in 2015 includes $438,203 in loan repayments from the UDAG Fund 410 for the 1st Source/Marriott loan based on BDC collections as well as charges to City departments for computer services. Form 3 50 Fund/Department Name Month December Fund/Department Number 408 Date Updated 1/26/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,031,710 765,101 9,031,709 8,796,821 - 1 100% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 504,660 - 504,660 354,660 - - 100% Interest Earnings 63,000 (1,483) 56,631 28,527 - 6,369 90% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 100 - 82 29,930 - 18 82% Transfers In- - - - - - 0% Total Revenue 9,599,470 763,618 9,593,082 9,209,938 - 6,388 100% Personnel- - - 395,866 - - 0% Supplies- - - - - - 0% Services 1,772,236 113,199 1,578,879 1,925,807 109,997 83,360 95% Debt Service 1,873,731 71,673 1,823,401 1,512,101 - 50,330 97% Capital 4,000 - 3,200 185,964 - 800 80% Transfers Out 6,483,782 - 6,483,782 5,862,101 - - 100% 10,133,749 184,872 9,889,262 9,881,839 109,997 134,490 99% Net(534,279) 578,746 (296,180) (671,901) (109,997) (128,102) Cash Balance 9,859,022 10,159,360 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 3 51 Fund/Department Name Month December Fund/Department Number 410 Date Updated 1/27/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,110 378 1,485 78 - (375) 134% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,039,576 - 1,039,452 - - 124 100% Transfers In- - - - - - 0% Total Revenue 1,040,686 378 1,040,938 78 - (252) 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 438,203 292,135 438,203 - - 1 100% Capital- - - - - - 0% Transfers Out- - - - - - 0% 438,203 292,135 438,203 - - 1 100% Net 602,483 (291,757) 602,735 78 - (252) Cash Balance 629,441 27,636 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 are expected in 2015. Form 3 52 Fund/Department Name Month December Fund/Department Number 655 Date Updated 1/27/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 429,000 36,509 438,225 436,317 (9,225) 102% Interest Earnings 2,700 (29) 6,133 3,076 (3,433) 227% Bond Proceeds- - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 431,700 36,480 444,358 439,394 - (12,658) 103% Personnel 64,081 21,711 38,899 29,420 25,182 61% Supplies 900 847 7,050 53 94% Services 41,158 (12,692) 40,924 38,883 234 99% Debt Service 72,219 72,218 72,189 1 100% Capital- - 0% Transfers Out 350,000 350,000 250,000 - 100% 528,358 9,019 502,888 397,542 - 25,470 95% Net(96,658) 27,461 (58,530) 41,851 - (38,128) Cash Balance 920,836 978,745 Full Time- - Part-Time /Seasonal/Temporary 2.16 1.10 - Total 2.16 1.10 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Project Releaf Expenditures Revenue Total Expenditures Staffing Fall ReLeaf scheduled for October 2016. Form 3 53 Fund/Department Name Month December Fund/Department Number 705 Date Updated 1/27/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 10 - 20 6 - (10) 200% Bond Proceeds- - - - - - 0% Donations 1,990 - 1,500 2,000 - 490 75% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,000 - 1,520 2,006 - 480 76% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 2,000 - 970 - - 1,030 49% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 2,000 - 970 - - 1,030 49% Net- - 550 2,006 - (550) Cash Balance 3,863 3,315 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Police K-9 Unit Expenditures Revenue Total Expenditures Staffing This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds. Form 3 54 Fund/Department Name Month December Fund/Department Number 313 Date Updated 1/27/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 906,264 404,478 906,263 497,768 - 1 100% Local Income Taxes- - - - - - 0% Other Taxes 294,846 211,551 294,772 131,360 - 74 100% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 50 (0) 41 (41) - 9 82% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,201,160 616,029 1,201,076 629,087 - 84 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 1,272,000 - 1,272,000 1,271,300 - - 100% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,272,000 - 1,272,000 1,271,300 - - 100% Net(70,840) 616,029 (70,924) (642,213) - 84 Cash Balance 11,396 74,046 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Football Hall of Fame Debt Service None Expenditures Revenue Total Expenditures Staffing This fund is used to collect a separate property tax levy (distributions received in June and December) and is used to pay debt service on the former College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will typically have a negative cash balance until the property tax distributions are received. PILOT taxes paid by the utilities are received monthly in this fund. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. On 15 April 2015 the Mayor announced a possible sale of the Hall of Fame to a private company. If the sale proceeds as planned, this fund will receive $240,000 per year for the next 5 years that will be used to offset debt service costs. Form 3 55 Fund/Department Name Month December Fund/Department Number 377 Date Updated 1/28/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 747,750 - 628,261 551,252 - 119,489 84% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 5,600 (50) 2,391 1,618 - 3,209 43% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 60,661 - 56,233 66,710 - 4,428 93% Transfers In- - - - - - 0% Total Revenue 814,011 (50) 686,885 619,580 - 127,126 84% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 855,603 - 855,603 865,545 - 1 100% Capital- - - - - - 0% Transfers Out- - - - - - 0% 855,603 - 855,603 865,545 - 1 100% Net(41,592) (50) (168,718) (245,965) - 127,126 Cash Balance 426,724 595,453 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 2015. The final debt service payment on the 2010 Coveleski Stadium bonds (Four Winds Field) was paid January 15, 2013. Form 3 56 Fund/Department Name Month December Fund/Department Number 401 Date Updated 1/22/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 42,000 - 41,853 - - 147 100% Interest Earnings 100 (0) 250 74 - (150) 250% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- 13,526 - - 0% Transfers In- - - - - - 0% Total Revenue 42,100 (0) 42,103 13,600 - (3) 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 42,100 (0) 42,103 13,600 - (3) Cash Balance 82,428 40,407 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Coveleski Stadium Capital Expenditures Revenue Total Expenditures Staffing Fund 401 accounts for capital spending on Coveleski Stadium. Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. Form 3 57 Fund/Department Name Month December Fund/Department Number 403 Date Updated 1/22/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 (0) 283 139 - (83) 142% Bond Proceeds- - - - - - 0% Donations- - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 200 (0) 283 139 - (83) 142% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital 49,000 - - - - 49,000 0% Transfers Out- - - - - - 0% 49,000 - - - - 49,000 0% Net(48,800) (0) 283 139 - (49,083) Cash Balance 49,370 49,109 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Zoo Endowment Expenditures Revenue Total Expenditures Staffing This fund was established to account for donations dedicated to Potawatomi Zoo. In the past few years several endowments that were funding this fund were liquidated resulting in a drop in revenues to this fund. Form 3 58 Fund/Department Name Month December Fund/Department Number 405 Date Updated 1/22/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 32 7,614 14,679 - 26,386 22% Interest Earnings 2,200 (79) 2,508 1,083 - (308) 114% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 12,000 - 4,250 121,416 - 7,750 35% Transfers In 95,500 - - - - 95,500 0% Total Revenue 143,700 (47) 14,372 137,177 - 129,328 10% Personnel- - - - - - 0% Supplies 67,273 - 33,541 50,075 173 33,559 50% Services 50,660 - 9,772 43,829 11,160 29,728 41% Debt Service- - - - - - 0% Capital 75,000 - 22,499 95,000 - 52,501 30% Transfers Out- - - - - - 0% 192,933 - 65,812 188,904 11,333 115,788 40% Net(49,233) (47) (51,440) (51,727) (11,333) 13,541 Cash Balance 469,009 520,605 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Park Nonreverting Capital This fund is for expending nonreverting revenue collected from the Zoo, golf courses, East Race Waterway, picnic sites and forestry revenue. Expenditures Revenue Total Expenditures Staffing This is a nonreverting capital fund that accounts for revenues collected and expenses for specific purposes or locations. These locations are Potawatomi and Rum Village Picnic Areas, the East Race, Golf Courses, Forestry, Howard Park Ice Rink, and, until 2014, Potawatomi Zoo. The cash balance includes $60,300 that is restricted to expenditures in Voorde Park. Form 3 59 Fund/Department Name Month December Fund/Department Number 406 Date Updated 1/26/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 428,730 168,250 428,727 430,786 - 3 100% Local Income Taxes- - - - - - 0% Other Taxes 90,339 23,753 90,338 84,926 - 1 100% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 2,500 (253) 2,307 1,820 - 193 92% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 854 - - 0% Transfers In- - - - - - 0% Total Revenue 521,569 191,750 521,372 518,386 - 197 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 542,691 - 530,663 722,934 - 12,028 98% Capital- - - - - - 0% Transfers Out- - - - - - 0% 542,691 - 530,663 722,934 - 12,028 98% Net(21,122) 191,750 (9,291) (204,548) - (11,831) Cash Balance 571,090 580,627 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Cumulative Capital Development Expenditures Revenue Total Expenditures Staffing This fund receives revenue from a property tax levy and distributions are received from St. Joseph County in June and December. Expenditures are for debt service payments on capital leases and the due dates vary per lease. The fund is used to finance police vehicles and related equipment. The fund also receives PILOT payments from the Water Works and Wastewater utilities on a monthly basis. Form 3 60 Fund/Department Name Month December Fund/Department Number 407 Date Updated 1/26/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 404,000 136,334 403,987 417,476 - 13 100% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 850 (178) 637 83 - 213 75% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 25,200 - 25,000 25,000 - 200 99% Transfers In- - - - - - 0% Total Revenue 430,050 136,156 429,624 442,559 - 426 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 367,875 - 367,875 369,800 - - 100% Capital- - - - - - 0% Transfers Out- - - - - - 0% 367,875 - 367,875 369,800 - - 100% Net 62,175 136,156 61,749 72,759 - 426 Cash Balance 310,758 249,215 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Cumulative Capital Improvement None Expenditures Revenue Total Expenditures Staffing Revenue in this fund includes $150,000 in hotel/motel taxes and $247,000 in cigarette taxes from other units of government. The hotel/motel tax distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December. In 2015, this fund is used to pay 75% of the 2011 Century Center Refunding bonds as it was in 2014. Payments on the Century Center bond are due in February and July. Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year. Form 3 61 Fund/Department Name Month December Fund/Department Number 412 Date Updated 1/22/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 261 19,069 20,763 - 5,931 76% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 788,687 - 786,187 515,692 - 2,500 100% Transfers In- - - - - - 0% Total Revenue 813,687 261 805,256 536,455 - 8,431 99% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital 3,096,061 79,033 2,289,929 4,038,690 795,033 11,099 100% Transfers Out- - - - - - 0% 3,096,061 79,033 2,289,929 4,038,690 795,033 11,099 100% Net(2,282,374) (78,772) (1,484,674) (3,502,235) (795,033) (2,667) Cash Balance 2,153,707 3,637,756 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Major Moves Construction The 2015 budget continues funding for the Smart Streets initiative and includes $950,000 for Smart Streets, $350,000 for the King/LWW roundabout design, and $30,000 for Corridor alley improvements. The $795K encumbered comprises $376K for the 2-way conversion of Main and Michigan/St. Joseph streets from Chippewa to LaSalle (the former IN-933), $137K for the Marion St. roundabout, $48K for the Bartlett St. roundabout, $24K for the Western Ave. corridor sidewalks and striping, and $37K 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 Nov 30 are $635,520 from Fund 435 (Douglas Rd.) and $4,436,193 from Fund 436 (River East Residential, f/k/a Northeast Residential). In August the Board of Public Works and the Redevelopment Commission approved a loan to the Parking Garages fund (Fund 601) which will commence in 2016 with the first of two loans of $750,000 each. The second $750,000 will be lent to the Parking Garages fund in 2017. Form 3 62 Fund/Department Name Month December Fund/Department Number 416 Date Updated 1/21/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 10,022 61,164 79,779 - 38,836 61% Interest Earnings 1,500 (6) 2,969 1,353 - (1,469) 198% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 101,500 10,016 64,133 81,132 - 37,367 63% Personnel- - - - - - 0% Supplies 35,210 7,000 30,025 9,583 5,000 185 99% Services 45,038 1,631 32,803 12,939 9,923 2,312 95% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 80,248 8,631 62,828 22,522 14,923 2,497 97% Net 21,252 1,385 1,305 58,611 (14,923) 34,870 Cash Balance 515,940 514,868 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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. A budget appropriation request in the amount of $10,000 was submitted for approval (to improve the Sound System on the main and upper level lobby areas). The appropriation is expected to be be approved in December 2015. Form 3 63 Fund/Department Name Month December Fund/Department Number 434 Date Updated 1/27/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 450 30 360 301 - 90 80% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 450 30 360 301 - 90 80% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 462,206 - - - - 462,206 0% Debt Service 187,794 - 7,794 - - 180,000 4% Capital- - - - - - 0% Transfers Out- - - - - - 0% 650,000 - 7,794 - - 642,206 1% Net(649,550) 30 (7,434) 301 - (642,116) Cash Balance 2,404 9,838 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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. We are anticipating 2015 revenue which will allow us to reimburse COIT for at least a portion of its funding. Form 3 64 Fund/Department Name Month December Fund/Department Number 450 Date Updated 1/21/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 16,000 661 12,864 9,607 - 3,136 80% Interest Earnings 150 (1) 388 159 - (238) 259% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 16,150 660 13,252 9,766 - 2,898 82% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 16,150 - - - - 16,150 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 16,150 - - - - 16,150 0% Net- 660 13,252 9,766 - (13,252) Cash Balance 76,297 63,093 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Palais Royale Historic Preservation No Capital spending in this fund. Expenditures Revenue Total Expenditures Staffing This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. Form 3 65 Fund/Department Name Month December Fund/Department Number 677 Date Updated 1/27/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 4,700 5 3,112 1,823 - 1,588 66% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 4,700 5 3,112 1,823 - 1,588 66% Personnel- - - - - - 0% Supplies 15,000 - - 419 - 15,000 0% Services 173,824 2,821 59,456 100,591 - 114,368 34% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 188,824 2,821 59,456 101,009 - 129,368 31% Net(184,124) (2,816) (56,343) (99,187) - (127,781) Cash Balance 502,111 558,620 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Football Hall of Fame Capital No Capital expenditures budgeted for 2015. 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. Form 3 66 Fund/Department Name Month December Fund/Department Number 287 Date Updated 1/26/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,872,739 - 2,869,467 - - 3,272 100% Charges for Services- - - - - - 0% Interest Earnings 7,350 (4) 3,511 - - 3,839 48% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 750,000 - - - - 750,000 0% Total Revenue 3,630,089 (4) 2,872,979 - - 757,110 79% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital 750,000 - 300,738 - 363,611 85,651 89% Transfers Out- - - - - - 0% 750,000 - 300,738 - 363,611 85,651 89% Net 2,880,089 (4) 2,572,240 - (363,611) 671,460 Cash Balance 2,572,240 - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Emergency Medical Services Capital Planned purchase of ambulance, support SUV, replacement cardiac monitors, fleet vehicle. Expenditures Revenue Total Expenditures Staffing The revenues in this account are generated through user fees for the South Bend Fire Department EMS division. These funds are used for capital purchases such as fire apparatus, ambulances and major construction projects. There are no employees associated with this fund. Form 3 67 Fund/Department Name Month December Fund/Department Number 288 Date Updated 1/26/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 136,000 - 135,288 - - 712 99% Charges for Services 5,268,065 511,513 5,088,370 2,726,511 - 179,695 97% Interest Earnings 18,000 739 19,490 13,284 - (1,490) 108% Bond Proceeds- - - - - - 0% Donations- - - 1,000 - - 0% Other Income 17,000 1,500 51,091 10,930 - (34,091) 301% Transfers In- - - - - - 0% Total Revenue 5,439,065 513,752 5,294,240 2,751,725 - 144,825 97% Personnel 4,740,253 505,498 4,740,168 - - 85 100% Supplies 292,000 18,652 266,488 197,381 6,861 18,651 94% Services 464,372 147,463 354,787 354,640 49,351 60,234 87% Debt Service 459,738 - 452,937 247,497 1,093 5,708 99% Capital 149,003 - 149,003 3,647,115 - - 100% Transfers Out 750,000 - - 1,000,000 - 750,000 0% 6,855,366 671,613 5,963,383 5,446,632 57,305 834,678 88% Net(1,416,301) (157,861) (669,143) (2,694,907) (57,305) (689,853) Cash Balance 2,210,747 2,906,216 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: 2015 City of South Bend Monthly Financial Report Emergency Medical Services Operating None Expenditures Revenue Total Expenditures Staffing The revenues in this account are generated through user fees for the South Bend Fire Department EMS division, Training Bureau, and Inspections. This Fund captures personnel and operating expenses primarily for Emergency Medical Services division and reflects a portion of the cost associated with operating ambulances. Form 3 68 Fund/Department Name Month December Fund/Department Number 600 Date Updated 1/22/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- - - 1,600 - - 0% Charges for Services 1,859,052 176,416 1,864,406 1,396,416 - (5,354) 100% Interest Earnings 5,900 354 6,891 930 - (991) 117% Bond Proceeds- - - - - - 0% Donations 100 - 52 - - 48 52% Other Income 21,817 3,929 37,377 4,878 - (15,560) 171% Transfers In 2,663,144 - 2,663,144 2,306,560 - - 100% Total Revenue 4,550,013 180,699 4,571,871 3,710,384 - (21,858) 100% Personnel 2,454,138 242,376 2,244,995 1,769,158 - 209,143 91% Supplies 157,483 8,817 115,406 150,060 4,759 37,318 76% Services 1,487,410 165,720 1,030,773 1,190,179 68,187 388,450 74% Debt Service 32,370 2,486 21,452 19,041 158 10,760 67% Capital 74,000 - - - 70,285 3,715 95% Transfers Out- - - - - - 0% 4,205,401 419,399 3,412,627 3,128,438 143,388 649,386 85% Net 344,612 (238,700) 1,159,244 581,946 (143,388) (671,244) Cash Balance 1,891,132 733,982 Full Time 36.00 36.00 - Part-Time /Seasonal/Temporary 2.00 2.00 - Total 38.00 38.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2014 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 3 69 Fund/Department Name Month December Fund/Department Number 601 Date Updated 1/27/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,056,987 67,063 968,418 953,902 - 88,569 92% Interest Earnings 9,226 575 6,709 2,787 - 2,517 73% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 11 9 20 64,428 - (9) 182% Transfers In- - - - - - 0% Total Revenue 1,066,224 67,647 975,147 1,021,117 - 91,077 91% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,742,807 502,872 1,345,792 603,342 209,929 187,086 89% Debt Service- - - - - - 0% Capital 63,905 - 62,367 228,334 1,536 2 100% Transfers Out- - - - - - 0% 1,806,712 502,872 1,408,159 831,676 211,465 187,088 90% Net(740,488) (435,225) (433,012) 189,441 (211,465) (96,011) Cash Balance 639,642 1,072,477 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Parking Garages 2015 projects include: Wayne Street Façade, Elevator Repairs and Door Repairs. These projects were begun in 2014 and will be finished in 2015. Other major repairs to be undertaken in 2015 as outlined in the study of needed improvements. Expenditures Revenue Total Expenditures Staffing Operations under outside contract with Downtown South Bend, Inc. so all expenses except capital are shown under Services line. Form 3 70 Fund/Department Name Month December Fund/Department Number 610 Date Updated 1/22/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,219,316 404,867 5,003,801 4,936,737 - 215,515 96% Interest Earnings 2,500 (8) 2,162 1,530 - 338 86% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 506,573 109,671 361,072 358,971 - 145,501 71% Transfers In- - - - - - 0% Total Revenue 5,728,389 514,530 5,367,035 5,297,239 - 361,354 94% Personnel 1,731,390 188,575 1,656,182 1,632,101 75,208 96% Supplies 331,208 20,440 283,986 431,025 3,261 43,961 87% Services 3,005,654 230,638 2,821,444 2,828,161 12,740 171,470 94% Debt Service 52,800 4,850 49,000 - 3,800 93% Capital- - - - - 0% Transfers Out 752,811 46,000 659,600 789,916 93,211 88% 5,873,863 490,503 5,470,212 5,681,203 16,001 387,650 93% Net(145,474) 24,027 (103,177) (383,964) (16,001) (26,297) Cash Balance 318,912 405,863 Full Time 25.20 23.20 Part-Time /Seasonal/Temporary 8.00 6.00 Total 33.20 29.20 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Solid Waste Operations Expenditures Revenue Total Expenditures Staffing This Enterprise Fund charges City residents a small monthly fee to pick up and dispose of their trash at area landfills and recycling centers. The operations of Solid Waste are totally funded by these user fees. Transfers out to Fund 611 for debt service payments are done on an as needed basis. Year to date operating expenses fell within budgeted expectations for 2015; revenues came in slightly lower than expected for the year. Form 3 71 Fund/Department Name Month December Fund/Department Number 611 Date Updated 1/22/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 (0) 113 149 - 87 57% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 752,811 46,000 659,600 789,916 - 93,211 88% Total Revenue 753,011 46,000 659,713 790,065 - 93,298 88% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 752,811 45,690 694,470 702,124 - 58,341 92% Capital- - - 171,182 - - 0% Transfers Out- - - - - - 0% 752,811 45,690 694,470 873,306 - 58,341 92% Net 200 310 (34,757) (83,241) - 34,957 Cash Balance 442 35,162 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Solid Waste Capital Year to date spending has been for lease purchase payments on prior year equipment acquisitions. Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to pay for capital items, such as trash trucks, used in the day to day operations of Solid Waste. Other than a small amount of interest income, the sole source of revenue for this fund comes from dollars transferred in from the Solid Waste Operations Fund #610. These transfers are done on an as needed basis. Form 3 72 Fund/Department Name Month December Fund/Department Number 620 Date Updated 1.22.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,638,403 1,058,877 14,288,228 14,385,342 - 350,175 98% Interest Earnings 29,000 39 24,939 8,523 - 4,061 86% Bond Proceeds- - - 0% Donations- - - 0% Other Income 99,580 8,660 61,847 137,714 - 37,733 62% Transfers In 43,500 8,847 43,661 14,611 - (161) 100% Total Revenue 14,810,483 1,076,423 14,418,676 14,546,190 - 391,807 97% Personnel 4,806,987 498,989 4,669,609 4,275,706 456 136,922 97% Supplies 1,612,911 103,879 1,386,060 1,293,283 126,195 100,656 94% Services 5,105,695 560,501 4,507,263 4,241,123 272,906 325,527 94% Debt Service 11,924 723 8,124 5,790 3,800 68% Capital- - 0% Transfers Out 4,306,954 365,784 4,285,016 3,944,462 21,938 99% 15,844,471 1,529,875 14,856,072 13,760,364 399,556 588,842 96% Net(1,033,988) (453,452) (437,397) 785,826 (399,556) (197,035) Cash Balance 3,889,564 4,298,441 Full Time 70.20 68.20 Part-Time /Seasonal/Temporary 3.00 2.00 Total 73.20 70.20 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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. A cutback in scrap metal sales is attributed to the decline in other income revenue. Form 3 73 Fund/Department Name Month December Fund/Department Number 622 Date Updated 1.21.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 (5) 17,400 10,132 - (7,400) 174% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 10,000 (5) 17,400 10,132 - (7,400) 174% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 3,600 - - 0% Debt Service- - - - - - 0% Capital 838,893 - 262,273 412,976 177,797 398,824 52% Transfers Out- - - - - - 0% 838,893 - 262,273 416,576 177,797 398,824 52% Net(828,893) (5) (244,873) (406,444) (177,797) (406,223) Cash Balance 2,876,026 3,135,399 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Water Works Capital Chlorine Auto Emergency Shut Off System $15,382 Trucks (4) & Backhoe (1) $246,891 Encumb: Meter Reading Mobile Management Software (1) $18,188 , Int'l 3 1/2 Ton Utility Truck (1) $144,609 and Interactive Voice Response(IVR) System Upgrade (1) $15,000 Expenditures Revenue Total Expenditures Staffing This fund is used for acquiring, constructing, and improving fixed assets. Form 3 74 Fund/Department Name Month December Fund/Department Number 623 Date Updated 1.21.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 545 - 544 1,614 - 1 100% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 545 - 544 1,614 - 1 100% Personnel- - - - - - 0% Supplies 86,514 - 86,470 214,892 - 44 100% Services 36,871 - 36,843 42,103 28 100% Debt Service- - - - - 0% Capital 59,600 - 59,529 374,711 - 71 100% Transfers Out 245 - 240 5 98% 183,230 - 183,082 631,706 - 148 100% Net(182,685) - (182,539) (630,092) - (146) Cash Balance- 202,281 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Water Works Bond Capital Water Meters $58,193 Pinhook WT Effic Improv Proj $122,478 Boland Park PRV $2,171 Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to segregate the use of bond proceeds that are applied to the acquisition, construction and installation of certain additions, extension and improvements. Revenue bonds were issued in June 2012 with an aggregate principal of $8,300,000. The bond cash proceeds were fully expended as of July 14, 2015. Form 3 75 Fund/Department Name Month December Fund/Department Number 624 Date Updated 1.21.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 6,000 (9) 8,595 4,142 - (2,595) 143% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - 40 - - 0% Total Revenue 6,000 (9) 8,595 4,182 - (2,595) 143% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - 0% Transfers Out 10,000 1,960 9,709 4,997 - 291 97% 10,000 1,960 9,709 4,997 - 291 97% Net(4,000) (1,968) (1,114) (815) - (2,886) Cash Balance 1,509,816 1,478,773 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 interest earnings were much greater than anticipated in 2015. Form 3 76 Fund/Department Name Month December Fund/Department Number 625 Date Updated 1.21.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 5,000 1,879 6,262 2,533 - (1,262) 125% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 2,045,078 170,275 2,043,540 2,049,720 - 1,538 100% Total Revenue 2,050,078 172,154 2,049,802 2,052,253 - 276 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 2,045,078 1,677,565 2,043,788 2,050,399 - 1,290 100% Capital- - - - - - 0% Transfers Out 5,750 1,885 6,265 2,535 - (515) 109% 2,050,828 1,679,449 2,050,053 2,052,934 - 775 100% Net(750) (1,507,295) (250) (681) - (500) Cash Balance 4,399 4,650 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Water Works Sinking Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. The source of monies for debt repayment are transfers from the water utility operating fund 620. Biannual installments are disbursed at the end of June and December. June's payment includes 50% of the annual interest and December's payment comprises the rest of the interest and all of the principal. Form 3 77 Fund/Department Name Month December Fund/Department Number 626 Date Updated 1.21.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 3 6,166 4,459 3,334 65% Bond Proceeds- - 0% Donations- - 0% Other Income- 0% Transfers In- 76,542 - 0% Total Revenue 9,500 3 6,166 81,001 - 3,334 65% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 14,500 2,096 13,281 - - 1,219 92% 14,500 2,096 13,281 - - 1,219 92% Net(5,000) (2,093) (7,116) 81,001 - 2,116 Cash Balance 1,637,116 1,644,945 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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. Annual maximum reserve requirements were satisfied in 2015. Form 3 78 Fund/Department Name Month December Fund/Department Number 629 Date Updated 1.21.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,500 1 12,703 5,875 - (4,203) 149% Bond Proceeds- - - - - 0% Donations- - - - - 0% Other Income- - - - - 0% Transfers In 154,249 - 150,228 53,507 - 4,021 97% Total Revenue 162,749 1 162,931 59,382 - (182) 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 14,000 2,907 14,406 7,079 - (406) 103% 14,000 2,907 14,406 7,079 - (406) 103% Net 148,749 (2,906) 148,525 52,303 - 224 Cash Balance 2,228,964 2,081,600 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 earnings were greater than anticipated in 2015. Form 3 79 Fund/Department Name Month December Fund/Department Number 640 Date Updated 1/27/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 551,200 51,206 606,291 585,858 (55,091) 110% Interest Earnings 3,600 12 8,996 4,037 (5,396) 250% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 554,800 51,217 615,288 589,894 - (60,488) 111% Personnel 206,842 15,688 158,499 166,773 48,343 77% Supplies 28,603 2,310 18,403 13,173 3,751 6,448 77% Services 281,802 39,651 265,438 233,052 16,364 94% Debt Service 28,456 28,436 28,436 20 100% Capital- - 0% Transfers Out- - - - - - 0% 545,703 57,649 470,776 441,433 3,751 71,176 87% Net 9,097 (6,432) 144,512 148,461 (3,751) (131,663) Cash Balance 1,647,834 1,505,378 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: 2015 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 $500.00 deductible toward the cost of the repair and the city pays the rest. Form 3 80 Fund/Department Name Month December Fund/Department Number 641 Date Updated 1/22/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 35,949,467 2,939,050 35,876,049 33,317,015 - 73,418 100% Interest Earnings 22,000 (2,319) 45,346 15,306 - (23,346) 206% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 92,100 12,075 127,091 111,844 - (34,991) 138% Transfers In 24,000 4,784 23,677 11,637 - 323 99% Total Revenue 36,087,567 2,953,590 36,072,162 33,455,803 - 15,405 100% Personnel 7,402,560 712,504 6,532,654 6,514,307 869,906 88% Supplies 2,142,243 122,925 1,132,393 820,237 253,197 756,652 65% Services 13,682,562 1,018,806 10,471,943 10,516,452 1,913,831 1,296,788 91% Debt Service 592,509 658 393,046 181,234 199,463 66% Capital- - - 150,701 - 0% Transfers Out 16,765,038 760,893 17,525,877 13,427,609 (760,839) 105% 40,584,912 2,615,787 36,055,914 31,610,541 2,167,029 2,361,970 94% Net(4,497,345) 337,803 16,248 1,845,262 (2,167,029) (2,346,564) Cash Balance 8,996,120 8,982,959 Full Time 95.25 87.40 Part-Time /Seasonal/Temporary 6.62 2.00 Total 101.87 89.40 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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. Debt service payments are made in accordance with City amortization schedules. Extra transfers out to Capital Fund 642 to help fund upcoming projects at the Wastewater Plant overdrafted that budget line. All other operating expense categories are falling within budgeted range. Form 3 81 Fund/Department Name Month December Fund/Department Number 642 Date Updated 1/22/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 39,000 847 34,993 15,111 - 4,007 90% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 5,359,000 - 8,000,000 4,000,000 - (2,641,000) 149% Total Revenue 5,398,000 847 8,034,993 4,015,111 - (2,636,993) 149% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 37,896 - 37,895 97,221 - 1 100% Debt Service- - - - - - 0% Capital 9,533,814 568,725 3,012,469 4,210,735 5,144,946 1,376,399 86% Transfers Out- - - - - - 0% 9,571,710 568,725 3,050,364 4,307,956 5,144,946 1,376,400 86% Net(4,173,710) (567,878) 4,984,629 (292,844) (5,144,946) (4,013,394) Cash Balance 8,723,058 3,747,697 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Sewage Works Capital Year to Date totals spent include: Wastewater Treatment Plant Primary Clarifier rehab $1,569,572, East Gate Lift Station $443,850, Wastewater Plant vehicles & equipment $53,959, Sewer Dept vehicles & equipment $982,983. 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. Higher than budgeted transfers in were done to help fund an upcoming Wastewater Plant expansion/renovation, scheduled to start in 2016. Form 3 82 Fund/Department Name Month December Fund/Department Number 643 Date Updated 1/22/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 15,000 2 20,869 9,662 - (5,869) 139% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 256,612 - 256,086 129,964 - 526 100% Total Revenue 271,612 2 276,955 139,626 - (5,343) 102% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 21,160 4,784 23,677 11,637 - (2,517) 112% 21,160 4,784 23,677 11,637 - (2,517) 112% Net 250,452 (4,782) 253,278 127,989 - (2,826) Cash Balance 3,668,277 3,416,919 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 to this fund was done in February to adjust the balance to stay in compliance. Form 3 83 Fund/Department Name Month December Fund/Department Number 647 Date Updated 1/22/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- - - 3 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 3 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 1,143 - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - 0 - - (0) 0% - - 0 1,143 - (0) 0% Net- - (0) (1,141) - 0 Cash Balance- 0 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Sewer Bond 2007 Expenditures Revenue Total Expenditures Staffing This 2007 Bond is fully spent. Form 3 84 Fund/Department Name Month December Fund/Department Number 649 Date Updated 1/22/2015 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 31,000 9,524 30,727 12,106 - 273 99% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 9,281,088 760,893 9,269,791 9,297,645 - 11,297 100% Total Revenue 9,312,088 770,416 9,300,518 9,309,752 - 11,570 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 4,000 379 3,679 3,200 - 321 92% Debt Service 9,282,436 6,208,842 9,282,435 9,299,022 - 1 100% Capital- - - - - - 0% Transfers Out- - - - - - 0% 9,286,436 6,209,221 9,286,114 9,302,222 - 322 100% Net 25,652 (5,438,805) 14,404 7,530 - 11,248 Cash Balance 804,674 789,489 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Sewage Sinking Expenditures Revenue Total Expenditures Staffing This fund is used to pay all debt service obligations for Wastewater and Sewers. Mandatory transfers in from Operating Fund 641 are done in specified amounts each month to satisfy bond covenants. Form 3 85 Fund/Department Name Month December Fund/Department Number 653 Date Updated 1/22/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 4 3 3 3 - 1 78% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 4 3 3 3 - 1 78% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 3,181,211 3,181,211 3,181,211 - - 0 100% Capital- - - - - - 0% Transfers Out- - - - - - 0% 3,181,211 3,181,211 3,181,211 - - 0 100% Net(3,181,207) (3,181,208) (3,181,208) 3 - 1 Cash Balance 4,105,624 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: 2015 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 with Bank of NY Mellon Trust. The account was fully funded for existing debt in 2013. The $3.1 payment this month was to fully fund the debt service reserve for the 2015 refunding of the 2006, 2007, and 2007B bonds. A reconcilliation of this account is done monthly. Form 3 86 Fund/Department Name Month December Fund/Department Number 658 Date Updated 1/22/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 6 - (0) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - 0 6 - (0) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 924 - - 0% Debt Service- - - - - - 0% Capital- - - 1,296 - - 0% Transfers Out- - 2 - - (2) 0% - - 2 2,220 - (2) 0% Net- - (2) (2,213) - 2 Cash Balance- 0 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Sewer Bond 2010 Expenditures Revenue Total Expenditures Staffing This 2010 bond has been fully spent. Form 3 87 Fund/Department Name Month December Fund/Department Number 659 Date Updated 1/22/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 198 4,801 19,665 1,199 80% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 6,000 198 4,801 19,665 - 1,199 80% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 323,670 - 8,064 11,008 9,606 306,001 5% Debt Service- - - - - - 0% Capital 3,388,168 1,364,229 6,257,771 162,482 1,861,457 45% Transfers Out- - - - - - 0% 3,711,838 - 1,372,292 6,268,779 172,088 2,167,458 42% Net(3,705,838) 198 (1,367,491) (6,249,113) (172,088) (2,166,259) Cash Balance 231,542 1,597,670 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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. A number of projects have been funded from this bond; the more significant ones are listed below. Form 3 88 Fund/Department Name Month December Fund/Department Number 661 Date Updated 1/22/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 111,000 436 92,792 51,261 - 18,208 84% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - 5 - - (5) 0% Total Revenue 111,000 436 92,797 51,261 - 18,203 84% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,000,000 - 1,937 497 - 998,063 0% Debt Service- - - - - - 0% Capital 15,624,275 224,759 3,000,082 1,530,525 10,187,063 2,437,130 84% Transfers Out- - - - - - 0% 16,624,275 224,759 3,002,019 1,531,023 10,187,063 3,435,193 79% Net(16,513,275) (224,323) (2,909,222) (1,479,762) (10,187,063) (3,416,990) Cash Balance 13,888,878 16,801,222 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Sewer Bond 2012 Projects funded from this Bond in 2013 and 2014 included: East Bank Sewer Separation-Phase 4 $2.6 million, Diamond Ave. Sewer Separation- Phase 3, $2.6 million, Prairie Avenue Sewer Separation $404,420, and Southwood Sewer Separation $899,943. Spending in 2015 has been for Prairie Ave. Sewer Separation $194,503, Fairfax Sewer $70,022, East Bank Sewer Separation-Phase 5 $574,681, Sewer Sensory Control Network $193,609, Southwood Sewer Separation $19,665, Wastewater Treatment Plant Grit/Screening Improvements $139,740, Secondary Clarifier Modifications $342,842, CSO LTCP re-look $1,406,815, and misc other $2,070. Expenditures Revenue Total Expenditures Staffing Form 3 89 Fund/Department Name Month December Fund/Department Number 664 Date Updated 1/22/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 50 (0) 26 13 - 24 52% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 50 (0) 26 13 - 24 52% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 50 (0) 26 13 - 24 Cash Balance 4,499 4,476 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report 2013A Cost of Issuance Fund Expenditures Revenue Total Expenditures Staffing This fund was set up to pay the issue costs related to the re-funding of the 2004 Sewer bond and 1998 SRF Loan. Those costs were paid in 2013. The remaining cash balance should be transferred to an appropriate fund, so this fund can be closed out. Form 3 90 Fund/Department Name Month December Fund/Department Number 666 Date Updated 1/22/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- (76) (76) - - 76 0% Bond Proceeds 188,232 188,231 188,231 - - 1 100% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 188,232 188,156 188,156 - - 76 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 188,232 179,066 179,066 - - 9,167 95% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 188,232 179,066 179,066 - - 9,167 95% Net- 9,090 9,090 - - (9,090) Cash Balance 58,067 - Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 have been paid this month. Form 3 91 Fund/Department Name Month December Fund/Department Number 670 Date Updated 1/26/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,450 - 1,313,450 1,313,450 - - 100% Grants/Intergovernmental- - - - - - 0% Charges for Services 2,551,045 491,446 2,474,911 2,725,661 - 76,134 97% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 15,000 40,218 22,368 48,593 - (7,368) 149% Transfers In- - - - - - 0% Total Revenue 3,879,495 531,664 3,810,729 4,087,704 - 68,766 98% Personnel 2,306,817 229,664 2,094,960 2,132,960 - 211,857 91% Supplies 598,646 69,230 593,542 501,473 - 5,104 99% Services 1,383,148 118,646 1,331,097 1,184,489 - 52,051 96% Debt Service- - - - - - 0% Capital 243,951 - - - - 243,951 0% Transfers Out- - - - - - 0% 4,532,562 417,540 4,019,600 3,818,922 - 512,962 89% Net(653,067) 114,124 (208,871) 268,782 - (444,196) Cash Balance 1,096,892 892,876 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Century Center Expenditures Revenue Total Expenditures Staffing SMG has assumed management of Century Center effective July 1, 2013. One of their contractual duties is to reduce the operating deficit in the fund. Covered by hotel/motel tax revenue which is received twice per year. The first installment was received in February 2015. Other income includes charges to large conferences for electric costs. Although charges for services are down, personnel expenditures are also down as they are controlling their costs. Also, charges for services will likely stay low as the Century Center is going to begin many energy savings construction projects which is putting many of their rooms out of inventory for months at a time. However, the energy savings and their efforts to become more "green" will likely help attract future business. Form 3 92 Fund/Department Name Month December Fund/Department Number 671 Date Updated 1/26/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 500 85 809 328 - (309) 162% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 500 85 809 328 - (309) 162% Personnel- - - - - - 0% Supplies 52,621 - 41,156 - - 11,465 78% Services 192,735 - 192,735 - - 0 100% Debt Service- - - - - - 0% Capital 310,300 - 133,509 339,363 - 176,791 43% Transfers Out 50,000 - 50,000 - - - 100% 605,656 - 417,400 339,363 - 188,256 69% Net(605,156) 85 (416,591) (339,035) - (188,565) Cash Balance 1,002,072 1,418,663 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Century Center Capital A Qualified Energy Conservation Bond was taken out in May 2015. Approximately $192,000 will be used as a down payment on the construction contract, thus reducing the amount necessary to be funded by bond issuance. The actual bond payments will be made with hotel/motel funds through a new fund, Century Center Energy Conservation Debt Service, that was seeded with a $50,000 transfer from this fund in May. Expenditures Revenue Total Expenditures Staffing SMG contributed a one time amount of $575,000 to cover capital expenses in August 2013. The remainder of these funds have been appropriated for spending during 2015. $25,000 was appropriated to help pay for the Wall of Fame in conjunction with the South Bend Alumni Association. $50,000 was transferred out to the new fund 672 for bond payments on the Energy Savings Contract. Form 3 93 Fund/Department Name Month December Fund/Department Number 672 Date Updated 1/26/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 4 32 - - 8 80% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 50,000 - 50,000 - - - 100% Total Revenue 50,040 4 50,032 - - 8 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 50,040 4 50,032 - - 8 Cash Balance 50,032 - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 3 94 Fund/Department Name Month December Fund/Department Number 222 Date Updated 1/21/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 29,167 - - - 29,167 0% Charges for Services 8,069,157 586,430 7,269,499 6,943,879 - 799,658 90% Interest Earnings 3,400 (281) 6,840 3,062 - (3,440) 201% Bond Proceeds- - - - 0% Donations- - - - 0% Other Income 78,627 (10,450) 103,935 117,194 - (25,308) 132% Transfers In- - - - - - 0% Total Revenue 8,180,351 575,700 7,380,274 7,064,135 - 800,077 90% Personnel 3,099,267 277,343 2,674,471 2,579,464 150 424,646 86% Supplies 167,428 60,203 168,999 145,522 11,182 (12,752) 108% Services 4,640,552 353,643 4,342,543 4,270,903 118,549 179,460 96% Debt Service 9,155 4,965 6,495 4,190 54% Capital 141,157 140,857 32,262 300 100% Transfers Out 271,850 271,850 - - - 100% 8,329,409 691,188 7,603,685 7,034,645 129,880 595,844 93% Net(149,058) (115,489) (223,411) 29,490 (129,880) 204,234 Cash Balance 1,329,793 1,536,912 Full Time 44.00 37.00 37.00 Part-Time /Seasonal/Temporary 6.00 1.00 1.00 Total 50.00 38.00 38.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 Dec. we had 1,317 vehicle repairs. Average Fuel prices for December is $1.45 for Unleaded and $1.47 for Diesel. Budgeted amount per gallon is $3.45. 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 continued rolling out City facility recycling and applied for two state energy grants. Form 3 95 Fund/Department Name Month December Fund/Department Number 224 Date Updated 1/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- 30 79 - - (79) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 271,850 271,850 - - - 100% Total Revenue 271,850 30 271,929 - - (79) 100% Personnel- - - - - - 0% Supplies 29,190 - 29,190 - - - 100% Services 17,492 12,950 17,222 - - 270 98% Debt Service- - - - - - 0% Capital 225,168 10,402 38,598 - 175,065 11,505 95% Transfers Out- - - - - - 0% 271,850 23,352 85,009 - 175,065 11,776 96% Net- (23,322) 186,920 - (175,065) (11,854) Cash Balance 186,635 - Full Time- - Part-Time /Seasonal/Temporary- - Total- - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Central Services Capital Capital projects for 2015 include a roof replacement for the Equipment Services building ($171,850), six (6) mobile comm lifts ($10,000 each) and an inground hoist ($40,000). Scanner/software for Inventory/fleet system. Expenditures Revenue Total Expenditures Staffing This is a new fund for 2015. Revenues are a transfer from Central Services. Form 3 96 Fund/Department Name Month December Fund/Department Number 226 Date Updated 1/22/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,222,727 101,897 1,222,767 2,859,719 - (40) 100% Interest Earnings 31,760 46 29,150 14,433 - 2,610 92% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 103,925 - 95,248 162,063 - 8,677 92% Transfers In- - - - - - 0% Total Revenue 1,358,412 101,943 1,347,166 3,036,215 - 11,246 99% Personnel 314,491 21,559 219,549 179,508 - 94,942 70% Supplies 36,189 432 29,641 17,192 - 6,548 82% Services 2,706,111 151,077 2,252,845 2,341,383 46,156 407,110 85% Debt Service- - - - - - 0% Capital- - - 3,555 - - 0% Transfers Out- - - - - - 0% 3,056,791 173,068 2,502,034 2,541,638 46,156 508,601 83% Net(1,698,379) (71,125) (1,154,869) 494,577 (46,156) (497,354) Cash Balance 4,519,282 5,673,981 Full Time 4.00 3.00 Part-Time /Seasonal/Temporary- - Total 4.00 3.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Liability Insurance No capital expenditures are budgeted in 2015. Expenditures Revenue Total Expenditures Staffing This fund handles operations relating to business insurance and claims: property, liability, workers compensation, etc. and the operation of the safety and risk department. Position vacancy, due to retirement, remains unfilled. The $2.7 million budget for Services includes estimated claims for 2015 of $1 million as well as nearly $1 million in insurance premiums for both liability and workers' compensation policies carried by the City. Staffing includes 3 positions in Safety & Risk and 1 paralegal position for a claims adjuster. Form 3 97 Fund/Department Name Month December Fund/Department Number 278 Date Updated 1/26/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 61,100 6,730 61,660 61,170 - (560) 101% Interest Earnings 2,000 (17) 3,227 1,407 - (1,227) 161% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 61,100 6,730 61,660 61,063 - (560) 101% Transfers In- - - - - - 0% Total Revenue 124,200 13,443 126,547 123,640 - (2,347) 102% Personnel- - - - - - 0% Supplies 61,100 - - 60,580 - 61,100 0% Services 10,000 - 1,086 - - 8,914 11% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 71,100 - 1,086 60,580 - 70,014 2% Net 53,100 13,443 125,461 63,060 - (72,361) Cash Balance 640,497 515,458 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 2015. Claims have been minimal in this fund since it was created. This fund is classified as an Internal Service Fund for financial reporting. No liability claims were paid during 2014. Form 3 98 Fund/Department Name Month December Fund/Department Number 711 Date Updated 1/26/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 14,480,550 1,057,489 14,235,582 12,895,536 - 244,968 98% Interest Earnings 29,355 1,581 28,482 15,785 - 873 97% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 19,435 96,050 115,449 407,656 - (96,014) 594% Transfers In- - - - - - 0% Total Revenue 14,529,340 1,155,120 14,379,513 13,318,977 - 149,827 99% Personnel 4,326 1 10 - - 4,316 0% Supplies 24,275 1,993 14,540 38,633 - 9,735 60% Services 844,520 65,244 732,080 635,791 44,959 67,481 92% Insurance 15,823,814 1,352,029 13,320,804 14,249,012 - 2,503,010 84% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 16,696,935 1,419,267 14,067,434 14,923,436 44,959 2,584,542 85% Net(2,167,595) (264,147) 312,079 (1,604,459) (44,959) (2,434,715) Cash Balance 4,362,460 4,052,663 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Self-Funded Employee Benefits None Expenditures Revenue Total Expenditures Staffing This fund handles expenses relating to insurance and claims relating to employees: medical, dental, life, flex spending, etc. For the last several years expenses have significantly exceeded revenues (charges to City Departments and employees) so our cash balance has been eroding. This is not sustainable in the long-term and we need to address this situation. For the 2015 Budget, we increased employer and employee contributions significantly, which has been helping, although we are falling short of our revenue targets. Fortunately, claims costs have been lower than expected. A new Employee Wellness Center was opened on January 18, 2016 which is set in place with the understanding that the City should see a drop in claims expenses over time. Form 3 99 Fund/Department Name Month December Fund/Department Number 713 Date Updated 1/26/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 112,996 8,473 101,681 102,364 - 11,315 90% Interest Earnings 1,550 (9) 1,397 683 - 153 90% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 114,546 8,464 103,078 103,047 - 11,468 90% Personnel 200,000 886 54,970 114,682 - 145,030 27% Supplies- - - - - - 0% Services 26,796 4,966 19,996 7,224 6,600 200 99% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 226,796 5,852 74,966 121,906 6,600 145,230 36% Net(112,250) 2,612 28,112 (18,859) (6,600) (133,762) Cash Balance 268,873 240,912 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Unemployment Compensation None Expenditures Revenue Total Expenditures Staffing This fund charges an allocation of 0.25% of payroll to most departments to cover the cost of unemployment claims paid. For the 2015 budget, all outplacement services will be paid through this account. These were paid through the General Fund in previous years, however, due to the nature of outplacement claims, the Unemployment Fund is a more appropriate place from which to pay the costs. The Unemployment Compensation Fund is classified as an Internal Service Fund for financial reporting. Claims continue to be lower than anticipated. Form 3 100 Fund/Department Name Month December Fund/Department Number 701 Date Updated 1/28/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,036,025 - 5,039,025 5,129,098 - (3,000) 100% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 4,500 1,025 2,660 1,321 - 1,840 59% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 4,000 (3,743) 2,667 1,484 - 1,333 67% Transfers In- - - - - - 0% Total Revenue 5,044,525 (2,719) 5,044,353 5,131,903 - 172 100% Personnel 5,658,579 447,814 5,207,389 5,429,859 - 451,190 92% Supplies 200 - - - - 200 0% Services 7,800 80 3,964 840 - 3,836 51% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 5,666,579 447,894 5,211,353 5,430,699 - 455,226 92% Net(622,054) (450,613) (167,000) (298,796) - (455,054) Cash Balance 471,586 638,442 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 3 101 Fund/Department Name Month December Fund/Department Number 702 Date Updated 1/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 6,375,359 - 6,378,359 6,111,865 - (3,000) 100% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 6,000 1,214 4,335 2,666 - 1,665 72% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 4,000 - 62 4,259 - 3,938 2% Transfers In- - - - - - 0% Total Revenue 6,385,359 1,214 6,382,756 6,118,790 - 2,603 100% Personnel 6,827,035 508,644 6,332,115 6,715,613 - 494,920 93% Supplies 800 - - 174 - 800 0% Services 4,400 99 3,992 893 - 408 91% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,832,235 508,743 6,336,107 6,716,680 - 496,128 93% Net(446,876) (507,529) 46,649 (597,890) - (493,525) Cash Balance 1,155,658 1,109,579 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Police Pension No capital expenditures are paid from this fund. Expenditures Revenue Total Expenditures Staffing The Police Pension fund receives pension relief distributions from the State of Indiana to reimburse the City for pension costs paid and reported in the previous fiscal year. For 2016, the payments are expected to be $3,062,500 by 1 July and again by 1 October, totaling $6,125,000. Form 3 102 Fund/Department Name Month December Fund/Department Number 730 Date Updated 1/22/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 (0) 164 101 - (14) 109% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 150 (0) 164 101 - (14) 109% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 20,000 - - 8,658 - 20,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 20,000 - - 8,658 - 20,000 0% Net(19,850) (0) 164 (8,556) - (20,014) Cash Balance 28,498 28,347 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report City Cemetery Spending this year will concentrate on repairing headstones and completing the GIS survey of the cemetery and its occupants. Expenditures Revenue Total Expenditures Staffing This fund is designated for expenses specifically for the City Cemetery. Revenues were originally derived from the sale of cemetery plots and burial expenses.There are few sites available for sale and most plots are occupied, resulting in little burial activty. Form 3 103 Fund/Department Name Month December Fund/Department Number 324 Date Updated 1/27/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,433,274 6,897,072 16,293,240 14,284,734 - 140,034 99% Local Income Taxes- - - - - - 0% Other Taxes 492,000 - 492,000 - - - 100% Grants/Intergovernmental- - - - - - 0% Charges for Services 18,000 - 14,061 92,430 - 3,939 78% Interest Earnings 262,096 (1,839) 212,580 67,124 - 49,516 81% Bond Proceeds 7 7 7 101,267 - 0 93% Donations- - - - - - 0% Other Income 2,897,195 1,094,808 2,901,696 28,427 - (4,501) 100% Transfers In 4,993,040 3,609 4,989,785 3,548 - 3,255 100% Total Revenue 25,095,612 7,993,656 24,903,369 14,577,531 - 192,243 99% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 6,870,630 387,209 3,352,581 4,480,510 954,188 2,563,861 63% Debt Service 6,467,955 438,175 6,467,952 3,451,956 - 3 100% Capital 34,372,012 3,122,462 13,686,537 285,293 10,847,888 9,837,587 71% Transfers Out- - - - - - 0% 47,710,597 3,947,846 23,507,071 8,217,759 11,802,076 12,401,451 74% Net(22,614,985) 4,045,810 1,396,298 6,359,772 (11,802,076) (12,209,208) Cash Balance 32,678,602 31,359,224 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report River West Development Area (Airport TIF) Major projects carried out/started in 2014 were: Renaissance District Phase II; the Studebaker/Oliver Project; and continued Ignition Park South & East acquisitions. In 2015, the major projects thus far approved are: the 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. Major project expenditures (other than debt service) to date have been made on: Bartlett Roundabout (about $2M); Ignition Park Infrastructure (about $2.4M); Ignition Park Multi-Tenant Bldg (about $1M); Nello (about $4.6M); Noble Energy (about $2M) and Renaissance District (about $1.8M). Expenditures Revenue Total Expenditures Staffing While one can find usefulness in reviewing revenue trends in TIF funds from one year to the next, because projects change wildly from one year to the next, it is less meaningful to examine year to date expenditures against the prior year to date. Due to changes in boundary, this area now includes the former Central Medical District (Fund 426) and a portion of South Bend Central Development Area (Fund 420). The appropriate 2015 budgets, revenues and expenses for these funds have been transferred into this fund. Form 3 104 Fund/Department Name Month December Fund/Department Number 420 Date Updated 1/27/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- - - 4,309,727 - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - 400,000 - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - 37,703 - - 0% Interest Earnings- - - 40,168 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 291,831 - - 0% Transfers In- - - 5,929 - - 0% Total Revenue- - - 5,085,358 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 95,425 - - 0% Debt Service- - - 3,386,382 - - 0% Capital- - - 119,551 - - 0% Transfers Out 4,088,473 - 4,088,473 - - 0 100% 4,088,473 - 4,088,473 3,601,359 - 0 100% Net(4,088,473) - (4,088,473) 1,483,999 - (0) Cash Balance- 4,092,219 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Tax Incremental Financing (TIF) - Downtown Expenditures Revenue Total Expenditures Staffing In 2015 SBCDA is eliminated and all funds were distributed between Fund 324 River West and Fund 429 River East. This is the result of the TIF realignment. Form 3 105 Fund/Department Name Month December Fund/Department Number 422 Date Updated 1/27/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 207,045 402,911 580,987 - 17,089 96% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 9,800 (182) 6,942 1,812 - 2,858 71% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 429,800 206,863 409,852 582,799 - 19,948 95% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 33,868 - 30,502 12 3,366 0 100% Debt Service- - - - - - 0% Capital 727,032 68,276 68,276 - 300,000 358,757 51% Transfers Out- - - - - - 0% 760,900 68,276 98,777 12 303,366 358,757 53% Net(331,100) 138,587 311,075 582,787 (303,366) (338,809) Cash Balance 1,504,532 1,194,467 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report TIF - West Washington Major projects committed thus far in 2015 are: City Cemetery Project. Other TIF eligible development projects for this TIF area will be determined by department staff and the Mayor's office as the year progresses. Expenditures Revenue Total Expenditures Staffing TIF projects vary widely from year to year so little can be gained by comparing expenditures from year to year. Major Projects committed thus far in 2015 are: City Cemetery Project. Form 3 106 Fund/Department Name Month December Fund/Department Number 425 Date Updated 1/27/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,302 (0) 857 254 - 445 66% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 208,913 14,677 165,894 164,895 - 43,019 79% Transfers In- - - - - - 0% Total Revenue 210,215 14,676 166,751 165,150 - 43,464 79% Personnel- - - - - - 0% Supplies 8,250 86 7,390 4,546 - 860 90% Services 146,466 15,630 123,071 101,720 - 23,395 84% Debt Service- - - - - - 0% Capital- - - 19,423 - - 0% Transfers Out- - - - - - 0% 154,716 15,717 130,461 125,690 - 24,255 84% Net 55,499 (1,040) 36,290 39,460 - 19,209 Cash Balance 208,565 172,431 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Redevelopment Retail & Leighton Plaza Expenditures Revenue Total Expenditures Staffing Operations under outside contract with Bradley Co. so all expenses except capital are shown under Services line, to show consistently with Parking Garages and Blackthorn Golf Course. Form 3 107 Fund/Department Name Month December Fund/Department Number 426 Date Updated 1/27/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- - - 851,211 - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 6,983 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 858,194 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 1,558,185 - - 0% Debt Service- - - - - - 0% Capital- - - 237,889 - - 0% Transfers Out 2,294,533 - 2,294,533 - - 0 100% 2,294,533 - 2,294,533 1,796,073 - 0 100% Net(2,294,533) - (2,294,533) (937,879) - (0) Cash Balance- 2,292,072 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 will be distributed to Fund 324 River West. This is the result of the TIF realignment. Form 3 108 Fund/Department Name Month December Fund/Department Number 429 Date Updated 1/27/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,421,310 1,030,296 2,421,308 1,568,240 - 2 100% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 37,000 (510) 34,796 8,751 - 2,204 94% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 19,357 - 19,357 - - - 100% Transfers In 1,430,966 - 1,430,965 - - 1 100% Total Revenue 3,908,633 1,029,785 3,906,426 1,576,990 - 2,207 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 779,084 616,557 681,504 29,175 82,772 14,808 98% Debt Service- - - - - - 0% Capital 6,460,440 29,570 220,270 126 4,452,386 1,787,784 72% Transfers Out- - - - - - 0% 7,239,524 646,127 901,774 29,301 4,535,158 1,802,592 75% Net(3,330,891) 383,659 3,004,652 1,547,689 (4,535,158) (1,800,385) Cash Balance 7,549,627 4,551,592 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 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 TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Due to changes in boundary, this area now includes a portion of South Bend Central Development Area (Fund 420). Form 3 109 Fund/Department Name Month December Fund/Department Number 430 Date Updated 1/27/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 906,848 2,205,822 2,379,212 - 194,178 92% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 35,750 (1,173) 26,718 9,600 - 9,032 75% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,435,750 905,675 2,232,540 2,388,812 - 203,210 92% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 714,085 1,647 394,254 245,126 288,454 31,378 96% Debt Service- - - - - - 0% Capital 2,128,450 - 700,198 626,042 1,023,361 404,891 81% Transfers Out- - - - - - 0% 2,842,535 1,647 1,094,452 871,169 1,311,814 436,269 85% Net(406,785) 904,028 1,138,088 1,517,643 (1,311,814) (233,059) Cash Balance 6,086,105 4,951,973 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report TIF - Southside Development #1 Projects committed to in 2014 were: completion of the Fellows Street Corridor Project; Ireland & Miami Area Improvements; Main/Lafayette Crossover Project and Walter Street Sidewalks. Projects committed to in 2015 include: Chippewa Improvements, Fellows Street Corridor, Ireland & Miami Area Improvements, Ireland Road Acquisition Services, Main-Lafayette Crossover Connector and Safe Routes to School (Perley). Expenditures Revenue Total Expenditures Staffing TIF projects vary widely from one year to the next so expenditure comparison will not yield reliable trend review. Form 3 110 Fund/Department Name Month December Fund/Department Number 435 Date Updated 1/27/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 106,814 270,758 321,895 - 49,242 85% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 750 (139) 408 557 - 342 54% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 260 - 256 - - 4 98% Transfers In- - - - - - 0% Total Revenue 321,010 106,675 271,422 322,451 - 49,588 85% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 4,200 - - 160 4,200 - 100% Debt Service 341,189 - 341,187 395,461 - 2 100% Capital- - - - - - 0% Transfers Out- - - - - - 0% 345,389 - 341,187 395,621 4,200 2 100% Net(24,379) 106,675 (69,765) (73,170) (4,200) 49,586 Cash Balance 151,435 221,193 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report TIF - Douglas Road Expenditures Revenue Total Expenditures Staffing The Douglas Road TIF was established to develop the road and area near Brown Mackie College near the South Bend-Mishawaka border. The fund borrowed money from the City of Mishawaka ($1,086,550) and Major Moves Fund 412 ($1,000,000) to finance initial construction. The fund uses TIF tax revenue to repay the loans. During February, 2015 the amounts due Mishawaka were paid in full and the amount due to Major Moves was $787,402. Payments will now be accelerated on the Major Moves loan in order to pay it off early as well. Form 3 111 Fund/Department Name Month December Fund/Department Number 436 Date Updated 1/27/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 3,129,690 1,466,109 3,129,681 2,725,909 - 9 100% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 211,000 - 210,999 - - 1 100% Interest Earnings 5,000 (2,109) (537) 2,396 - 5,537 -11% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 3,345,690 1,464,000 3,340,143 2,728,304 - 5,547 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 3,425,632 - 3,425,628 3,362,307 - 4 100% Capital- - - 214,573 - - 0% Transfers Out- - - - - - 0% 3,425,632 - 3,425,628 3,576,880 - 4 100% Net(79,942) 1,464,000 (85,485) (848,576) - 5,543 Cash Balance 1,617,553 1,703,673 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report River East Residential (NE Res TIF) Expenditures Revenue Total Expenditures Staffing TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Debt Service is related to the Eddy Street Commons Bonds Form 3 112 Fund/Department Name Month December Fund/Department Number 433 Date Updated 1/27/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 252 1 59 45 - 193 23% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 252 1 59 45 - 193 23% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 6,000 - 1,447 15,703 - 4,553 24% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,000 - 1,447 15,703 - 4,553 24% Net(5,748) 1 (1,388) (15,658) - (4,360) Cash Balance 8,689 10,079 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Redevelopment General Expenditures Revenue Total Expenditures Staffing This fund's sole expenditure is for general legal fees for DCI based on an engagement letter Form 3 113 Fund/Department Name Month December Fund/Department Number 439 Date Updated 1/27/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,328,182 - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 33,904 123 25,246 9,783 - 8,658 74% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 48,335 - 48,335 - - - 100% Transfers In- - - - - - 0% Total Revenue 82,239 123 73,581 1,337,965 - 8,658 89% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital 5,000,000 84,631 2,820,835 - 142,913 2,036,253 59% Transfers Out- - - - - - 0% 5,000,000 84,631 2,820,835 - 142,913 2,036,253 59% Net(4,917,761) (84,507) (2,747,254) 1,337,965 (142,913) (2,027,594) Cash Balance 2,269,848 5,015,175 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Certified Technology Park Capital funds are to be expended in Ignition Park and Innovation Park. Expenditures Revenue Total Expenditures Staffing Form 3 114 Fund/Department Name Month December Fund/Department Number 454 Date Updated 1/27/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,800 (1) 2,180 1,069 - 620 78% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,800 (1) 2,180 1,069 - 620 78% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 2,800 (1) 2,180 1,069 - 620 Cash Balance 379,043 377,036 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Airport Urban Enterprise Zone Expenditures Revenue Total Expenditures Staffing No significant issues. Form 3 115 Fund/Department Name Month December Fund/Department Number 619 Date Updated 1/27/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,799 - 119,297 1,539,385 - 502 100% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 119,799 - 119,297 1,539,385 - 502 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 181,905 - 181,484 1,552,466 - 421 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 19,744 - 19,744 - - 0 100% 201,649 - 201,228 1,552,466 - 421 100% Net(81,850) - (81,931) (13,081) - 81 Cash Balance- 83,501 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Blackthorn Operations Equipment payments Expenditures Revenue Total Expenditures Staffing Course operations under outside contract with Billy Casper Golf so all expenses except capital are shown under Services to show consistently with Parking Garages and Redevelopment Retail. The course has been sold to a private owner. The sale was completed in February, 2015. Form 3 116 Fund/Department Name Month December Fund/Department Number 315 Date Updated 1/27/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,400 0 5,989 2,949 - 1,411 81% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 7,400 0 5,989 2,949 - 1,411 81% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 5,000 1,351 6,740 3,548 - (1,740) 135% 5,000 1,351 6,740 3,548 - (1,740) 135% Net 2,400 (1,351) (751) (599) - 3,151 Cash Balance 1,035,975 1,037,191 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. 2015 City of South Bend Monthly Financial Report Redevelopment Bond - Airport Taxable Expenditures Revenue Form 3 117 Fund/Department Name Month December Fund/Department Number 317 Date Updated 1/27/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 3,800 (1) 2,916 1,430 - 884 77% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 3,800 (1) 2,916 1,430 - 884 77% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 3,800 (1) 2,916 1,430 - 884 Cash Balance 507,047 504,361 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report Coveleski Debt Service Reserve Expenditures Revenue Total Expenditures Staffing Debt service reserve fund. The fund is at the proper level per the bond financial advisor, Crowe Horwath. No additional transfers-in are needed. Any interest variations due to City policy on investments and increase in cash available to earn interest. Form 3 118 Fund/Department Name Month December Fund/Department Number 328 Date Updated 1/27/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 13,000 1 10,007 4,927 - 2,993 77% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 13,000 1 10,007 4,927 - 2,993 77% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 6,000 2,257 11,262 5,929 - (5,262) 188% 6,000 2,257 11,262 5,929 - (5,262) 188% Net 7,000 (2,257) (1,255) (1,002) - 8,255 Cash Balance 1,730,946 1,732,977 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. 2015 City of South Bend Monthly Financial Report Redevelopment Bond - Palais Royale Expenditures Revenue Form 3 119 Fund/Department Name Month December Fund/Department Number 432 Date Updated 1/27/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 19,185 7,692 19,183 9,175 - 2 100% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 31,600 (18) 31,555 17,145 - 45 100% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 50,785 7,674 50,737 26,320 - 48 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 203,000 - 201,724 656 - 1,276 99% Debt Service 488,380 - 488,380 491,495 - - 100% Capital- - - - - - 0% Transfers Out- - - - - - 0% 691,380 - 690,104 492,151 - 1,276 100% Net(640,595) 7,674 (639,367) (465,831) - (1,228) Cash Balance 5,294,328 6,496,481 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2015 City of South Bend Monthly Financial Report TIF - Southside Development #3 Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to pay debt service. We will not be requesting additional funds from the TIF. The first opportunity to pay off the bond will be February, 2017. The plan is to payoff the bond at that time along with the prepayment penalty. $201,724 payment in 2015 is return of prior year taxes to St. Joseph County. Form 3 120