The URL can be used to link to this page

Home My WebLink About12-2014 Departmental Financial ReportPeriod Ending: December 31, 2014 Issued By: Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents Mayor Pete Buttigieg 1 Narrative 2 Summaries 8 General Fund 21 Special Revenue Funds 55 Debt Service /Capital Project Funds 68 Enterprise Funds 94 Internal Service Funds 99 Trust Funds 102 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff Kathryn Roos Deputy Chief of Staff Brian Pawlowski South Bend Common Council Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Financial Specialist Senior Cecil Eastman Department Heads Fiscal Officers December 2014 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 20th of the month following the reporting period. The staff of the Department of Administration & Finance then summarizes the information 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), orthe Comprehensive Annual Financial Report (CAFR). Summary Trends & Observations The December 2014 departmental financial reports have been delayed due to the extended closing process that is customary for completing end -of -year reporting activities. The values that appear in the following reports are unaudited and may be subject to change. As of December 31, 2014, total revenue for the year was $261,746,676, 95% of estimated revenue. As of December, 2013 total revenue received was $272,732,811 within the same funds. Property taxes which are received in June and December each year, totaled $72,037,668, a difference of less than $55,000 or 0.07% from the budgeted amount. Remaining revenue sources are at 93% of estimates. The City received its semi - annual property tax disbursement of $33,046,388 in December as well as an auto excise tax disbursement of $1.6 million and local income taxes (COIT and EDIT) of $1.45 million. As of December 31, 2014, total expenditures were $268,784,587 and outstanding encumbrances were $24,935,372, a total of $293,719,959 which represents 79% 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 73% of the amended expenditure budget at the end of the period. Total expenditures were $279,658,044 as of December 31, 2013. We hope that you find this Monthly Departmental Financial Report useful in understanding the finances of the City of South Bend a little bit better. If you have any questions regarding this report, please contact us at 574 - 235 -7702. City of South Bend Monthly Department Financial Report REVENUE SUMMARY December 31, 2014 City Funds General Fund 54,882,073 19,504,498 55,106,209 62,367,950 13,658 100% Special Revenue 102 Rainy Day 52,000 (3,287) 24,483 29,524 27,517 47% 201 Parks & Recreation 11,013,940 3,828,489 10,823,968 11,768,205 189,972 98% 202 Motor Vehicle Highway 9,257,615 559,463 8,992,353 9,139,123 265,262 97% 203 Recreation Nonreverting 1,489,178 70,088 945,486 1,003,318 543,692 63% 209 Studebaker - Oliver Reverting Grants 335,000 (413) 3,078 3,712 331,922 1% 210 Economic Development State Grants 2,077,016 17,879 73,042 238,065 2,003,974 4% 211 Community & Economic Development Admn. 2,406,017 12,844 2,360,377 2,491,611 45,640 98% 212 Community & Economic Development 7,688,199 593,483 4,823,851 4,483,441 2,864,348 63% 216 Police State Seizures 36,200 (73) 28,765 27,470 7,435 79% 217 Gift, Donation, Bequest 178,403 3,761 175,299 11,501 3,104 98% 218 Police Curfew Violations 1,125 83 471 663 654 42% 220 Law Enforcement Continuing Education 224,945 14,189 205,888 194,529 19,057 92% 227 Loss Recovery 31,960 (2,148) 22,331 3,845,643 9,629 70% 244 Emergency Phone System 215,000 (19) 214,981 0 19 100% 249 Public Safety LOIT 6,391,029 531,084 6,384,450 6,582,642 6,579 100% 251 Local Roads & Streets 1,124,996 92,354 1,060,548 1,008,943 64,448 94% 252 Excess Welfare Distribution 5 0 4 4 1 78% 258 Human Rights Federal Grant 239,033 101,782 272,697 178,148 (33,664) 114% 271 Eastrace Waterway 100 (2) 32 49 68 32% 273 Morris PAC / Palais Royale Marketing 9,500 1,390 10,685 7,113 (1,185) 112% 280 Police Block Grants 0 (1) 11 13 (11) 0% 281 Economic Develop. Commission - Revenue Bonds 0 (10) 77 93 (77) 0% 289 HAZMAT 34,055 (15) 24,118 16,762 9,937 71% 291 Indiana River Rescue 45,350 2,360 41,275 66,068 4,075 91% 292 Police Grants 228,060 (55) 76,865 162,838 151,195 34% 294 Regional Police Academy 22,000 (26) 18,498 21,013 3,502 84% 295 COPS MORE Grant 41,600 710 12,414 23,068 29,186 30% 299 Police Federal Drug Enforcement 83,636 78 67,724 194,569 15,912 81% 404 County Option Income Tax 9,270,187 760,428 9,208,686 8,509,057 61,501 99% 408 Economic Development Income Tax 9,376,411 728,927 9,209,937 8,785,077 166,474 98% 410 Urban Development Action Grant 110 (11) 78 3,833 32 71% 655 Project Releaf 431,700 36,136 439,394 435,940 (7,694) 102% 705 Police K -9 Unit 2,000 (1) 2,006 8 (6) 100% 103 Excess Levy 3,648 3,648 3,648 0 0 100% Special Revenue Total 62,310,018 7,353,113 55,527,519 59,232,044 6,782,499 89% City Debt Service 313 Football Hall of Fame Debt Service 650,030 256,083 629,087 1,406,963 20,943 97% City Debt Service Total 650,030 256,083 629,087 19406,963 20,943 97% Capital Project 288 Emergency Medical Services Capital Improv. 2,672,935 286,719 2,751,725 8,323,033 (78,790) 103% 377 Professional Sports Development 678,228 (234) 619,580 677,704 58,648 91% 401 Coveleski Stadium Capital 14,026 (15) 13,600 92 426 97% 403 Zoo Endowment 2,900 (19) 139 176 2,761 5% 405 Park Nonreverting Capital 246,420 111,020 137,177 228,721 109,243 56% 406 Cumulative Capital Development 520,794 218,482 518,386 552,148 2,408 100% 407 Cumulative Capital Improvement 434,150 143,800 442,559 446,578 (8,409) 102% 412 Major Moves Construction 581,798 (1,150) 536,455 500,882 45,343 92% 416 Morris Performing Arts Center Capital 76,725 16,904 81,132 101,947 (4,407) 106% 434 Community Revitalization Enhancement District 651,000 24 301 244,899 650,699 0% 450 Palais Royale Historic Preservation 10,500 279 9,766 15,561 734 93% 677 Football Hall of Fame Capital 2,500 (208) 1,823 2,458 677 73% Capital Project Total 5,891,976 775,602 5,112,645 11,094,199 779,331 87% Enterprise 600 Consolidated Building Fund 3,864,537 183,715 3,710,384 954,228 154,153 96% 601 Parking Garages 1,187,350 89,232 1,021,117 971,598 166,233 86% 610 Solid Waste Operations 5,384,723 469,769 5,297,239 5,407,945 87,484 98% City of South Bend Monthly Department Financial Report REVENUE SUMMARY December 31, 2014 611 Solid Waste Capital 836,202 (15) 790,065 830,707 46,137 94% 620 Water Works Operations 14,957,778 1,077,240 14,546,190 15,109,623 411,588 97% 622 Water Works Capital 12,500 (1,189) 10,132 13,709 2,368 81% 623 Water Works Bond Capital 5,000 (72) 1,614 16,550 3,386 32% 624 Water Works Customer Deposit 6,040 (564) 4,182 4,861 1,858 69% 625 Water Works Sinking 2,057,224 171,098 2,052,253 2,056,004 4,971 100% 626 Water Works Bond Reserve 90,073 (614) 81,001 253,988 9,072 90% 629 Water Works Reserve Operations & Maintenance 70,312 (792) 59,382 52,228 10,930 84% 640 Sewer Repair Insurance 578,270 48,726 589,894 552,869 (11,624) 102% 641 Sewage Works Operations 35,013,977 2,764,664 33,455,803 31,784,543 1,558,174 96% 642 Sewage Works Capital 4,039,000 (1,352) 4,015,111 194,410 23,889 99% 643 Sewage Works Reserve Operations & Maint. 238,715 (1,301) 139,626 211,332 99,089 58% 645 2006 Sewer Bond 0 0 0 0 0 0% 647 Sewer Bond 2007 0 0 3 42 (3) 0% 649 Sewage Sinking 9,809,145 774,334 9,309,752 9,463,724 499,393 95% 650 Clay Sewage Gen Fund 0 0 0 2 0 0% 651 2007B Sewer Bond 0 0 0 69 0 0% 653 Sewage Debt Service Reserve 0 3 3 14,099 (3) 0% 658 Sewer Bond 2010 0 0 6 216 (6) 0% 659 Sewer Bond 2011 25,000 (438) 19,665 30,970 5,335 79% 661 Sewer Bond 2012 65,000 (6,277) 51,261 65,016 13,739 79% 663 Sewer Bond 2013 0 0 0 0 0 0% 664 2013A Cost of Issuance Fund 0 (2) 13 85,747 (13) 0% 665 2014 Sewer Bond 0 0 0 0 0 0% 670 Century Center 5,078,128 400,893 4,087,703 3,133,815 990,425 80% 671 Century Center Capital 500 24 328 675,315 172 66% Enterprise Total 83,319,474 5,967,083 79,242,729 71,883,609 4,076,745 95% Internal Service 222 Central Services 8,114,184 556,677 7,064,135 7,254,876 1,050,049 87% 226 Liability Insurance 3,105,399 239,334 3,036,215 3,009,847 69,184 98% 278 Take Home Vehicle Police 123,160 9,241 123,640 124,848 (480) 100% 711 Self- Funded Employee Benefits 14,097,608 1,162,287 13,318,976 12,156,648 778,632 94% 713 Unemployment Compensation 103,214 8,436 103,047 252,907 167 100% Internal Service Total 25,543,565 1,975,976 23,646,012 22,799,126 1,897,553 93% Trust & Agency 701 Firefighters Pension 5,391,332 1,396 5,131,903 5,038,211 259,429 95% 702 Police Pension 6,310,500 (94) 6,118,791 5,874,865 191,709 97% 703 Police /Fire 1977 Pension 0 0 0 0 0 0% 730 City Cemetery 250 (11) 101 138 149 41% Trust & Agency Total 11,702,082 1,291 11,250,795 10,913,213 451,287 96% City Funds Total 244,299833,646 23W,996 239,697,105 14,022,016 90 Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF Revenue - Airport 14,638,874 6,752,676 14,577,530 16,026,663 61,344 100% 420 Tax Incremental Financing (TIF) - Downtown 5,114,778 1,875,705 5,085,358 3,464,065 29,420 99% 422 TIF - West Washington 583,488 276,326 582,799 495,043 689 100% 425 Redevelopment Retail & Leighton Plaza 194,285 9,908 165,149 159,289 29,136 85% 426 TIF - Central Medical Service Area 866,211 390,605 858,194 1,233,918 8,017 99% 429 TIF - Northeast Development 1,577,240 758,176 1,576,991 849,684 249 100% 430 TIF - Southside Development #1 2,515,000 1,108,193 2,388,812 2,421,638 126,188 95% 435 TIF - Douglas Road 322,645 160,831 322,452 324,393 193 100% 436 TIF - Northeast Residential 2,730,109 1,342,498 2,728,305 2,271,188 1,804 100% Tax Increment Financing Total 28,542,630 12,674,918 28,285,590 27,245,881 257,040 99% Redevelopment 433 Redevelopment General 60 (4) 45 104 15 75% 439 Certified Technology Park 1,462,000 (2,084) 1,337,965 2,866,234 124,035 92% 454 Airport Urban Enterprise Zone 1,500 (144) 1,069 1,289 431 71% 619 Blackthorn Operations 1,736,322 6,762 1,539,385 1,580,512 196,937 89% Redevelopment Total 3,199,882 4,530 2,878,464 4,448,139 321,418 90% City of South Bend Monthly Department Financial Report REVENUE SUMMARY December 31, 2014 Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 (395) 2,949 3,567 2,051 59% 317 Coveleski Debt Service Reserve 1,800 (192) 1,430 1,725 370 79% 319 Blackthorn Redev Bond 0 0 0 464 0 0% 328 Redevelopment Bond - Palais Royale 6,000 (660) 4,927 5,959 1,073 82% 432 TIF - Southside Development #3 54,575 (2,260) 26,320 1,329,971 28,255 48% Debt Service Total 67,375 (3,507) 35,626 1,341,686 31,749 53% Redevelopment Commission Controlled Funds Total 31,809,887 12,675,941 M 31,199,680 33,035,706 610,207 98% Grand Total 276,109,105 48,509,587 261,714,676 272,732,811 14,632,223 95% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY December 31, 2014 City Funds General Fund 101 -0101 Mayor's Office 716,646 58,333 697,608 631,570 2,014 17,024 98% 101 - 0104311 Call Center 488,908 32,707 429,313 268,752 16,442 43,153 91% 101 -0201 City Clerk 393,508 26,600 333,593 323,764 1,115 58,800 85% 101 -0301 Common Council 543,698 64,928 417,660 348,921 5,011 121,027 78% 101 -0401 Administration & Finance 2,087,009 145,470 1,951,256 1,803,645 5,325 130,428 94% 101 -0404 Morris Performing Arts Center 1,063,527 80,053 922,302 925,137 23,375 117,849 89% 101 -0405 Palais Royale 523,710 36,630 401,325 396,959 25,425 96,960 81% 101 -0501 Legal Department 1,025,635 66,947 945,954 895,789 1,560 78,121 92% 101 -0600 Energy Office 2013 0 0 0 54,256 0 0 0% 101 -0602 Engineering 1,126,302 58,780 996,749 1,300,089 105,902 23,651 98% 101 -0607 Traffic & Lighting 2013 0 0 0 109,536 0 0 0% 101 -0801 Police Department 24,940,203 2,305,293 23,686,438 22,509,527 521,551 732,214 97% 101 -0802 Communications Center 2,021,486 180,895 1,985,945 2,060,643 0 35,541 98% 101 -0805 Police LOIT 2013 0 - 12,500 0 3,986,751 0 0 0% 101 -0901 Fire Department 21,649,415 2,148,065 21,581,197 20,204,550 14,142 54,006 100% 101 -0905 Fire LOIT 2013 0 0 0 3,553,638 0 0 0% 101 -1008 Human Rights 367,262 25,961 334,144 314,055 12,763 20,355 94% 101 -1201 Code 2013 5,225 0 2,311 1,990,564 2,269 645 88% 101 -1203 Code Hearing 2013 0 0 0 38,977 0 0 0% 101 -1204 Junk Vehicle 2013 0 0 0 32,404 0 0 0% 101 -1205 Unsafe Building 2013 0 0 0 26,052 0 0 0% 101 -1207 Animal Control 2013 2,254 -33 579 550,747 0 1,675 26% General Fund Total 56,954,788 5,218,129 54,686,373 62,326,327 736,894 1,531,451 97% Special Revenue 102 Rainy Day 0 0 0 0 0 0 0% 201 Parks & Recreation 12,600,878 893,464 11,582,413 12,392,940 95,061 923,404 93% 202 Motor Vehicle Highway 10,008,877 740,483 8,791,827 7,729,988 804,085 412,965 96% 203 Recreation Nonreverting 1,479,064 67,599 909,822 896,201 13,206 556,035 62% 209 Studebaker - Oliver Reverting Grants 1,415,000 0 0 0 30,000 1,385,000 2% 210 Economic Development State Grants 2,162,886 18,003 92,560 807,570 22,400 2,047,926 5% 211 Community & Economic Development Admn. 2,404,884 172,644 2,193,474 2,168,133 30,106 181,304 92% 212 Community & Economic Development 7,190,785 441,941 4,623,591 4,406,331 2,447,967 119,227 98% 216 Police State Seizures 40,000 0 0 13,729 0 40,000 0% 217 Gift, Donation, Bequest 201,010 45,776 112,095 0 81,182 7,733 96% 218 Police Curfew Violations 1,000 0 0 0 0 1,000 0% 220 Law Enforcement Continuing Education 294,802 31,851 225,832 300,508 6,498 62,472 79% 227 Loss Recovery 6,615,805 268,708 2,094,471 251,171 4,187,243 334,090 95% 244 Emergency Phone System 215,000 11,637 181,330 0 0 33,670 84% 249 Public Safety LOIT 7,214,658 551,774 7,123,412 7,540,389 0 91,246 99% 251 Local Roads & Streets 1,124,520 2,100 557,475 781,866 333,721 233,324 79% 252 Excess Welfare Distribution 1,146 1,146 1,146 0 0 0 100% 258 Human Rights Federal Grant 274,001 16,401 209,220 197,537 0 64,781 76% 271 Eastrace Waterway 10,346 0 9,092 0 0 1,254 88% 273 Morris PAC / Palais Royale Marketing 18,000 878 11,957 7,891 974 5,070 72% 280 Police Block Grants 0 0 0 0 0 0 0% 281 Economic Develop. Commission - Revenue Bonds 0 0 0 0 0 0 0% 289 HAZMAT 30,000 0 697 3,238 21,530 7,774 74% 291 Indiana River Rescue 52,300 975 31,594 89,773 0 20,706 60% 292 Police Grants 228,060 0 185,965 56,454 15,145 26,950 88% 294 Regional Police Academy 23,750 543 18,300 26,744 0 5,450 77% 295 COPS MORE Grant 141,600 2,867 19,524 17,014 30,735 91,341 35% 299 Police Federal Drug Enforcement 166,499 3,537 107,341 144,750 23,960 35,198 79% 404 County Option Income Tax 11,165,785 1,193,046 9,162,940 8,930,424 1,149,823 853,022 92% 408 Economic Development Income Tax 10,289,984 42,656 9,881,840 7,927,361 142,487 265,657 97% 410 Urban Development Action Grant 0 0 0 0 0 0 0% 655 Project Releaf 430,114 263,586 397,542 357,767 0 32,572 92% 705 Police K -9 Unit 2,000 0 0 625 0 2,000 0% 103 Excess Levy 0 0 0 0 0 0 0% Special Revenue Total 75,802,754 4,771,615 58,525,460 55,048,403 9,436,121 7,841,173 90% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY December 31, 2014 City Debt Service 313 Football Hall of Fame Debt Service 1,271,300 0 1,271,300 1,268,000 0 0 100% City Debt Service Total 1,271,300 0 1,271,300 1,268,000 0 0 100% Capital Project 288 Emergency Medical Services Capital Improv. 6,287,299 205,048 5,446,632 8,296,497 198,332 642,335 90% 377 Professional Sports Development 865,746 0 865,545 876,470 0 201 100% 401 Coveleski Stadium Capital 3,540 0 0 0 0 3,540 0% 403 Zoo Endowment 0 0 0 0 0 0 0% 405 Park Nonreverting Capital 205,217 23,220 188,904 148,214 9,933 6,380 97% 406 Cumulative Capital Development 722,935 56,545 722,934 602,118 0 1 100% 407 Cumulative Capital Improvement 369,800 0 369,800 367,575 0 0 100% 412 Major Moves Construction 5,823,729 780,315 4,038,690 1,253,680 1,766,060 18,978 100% 416 Morris Performing Arts Center Capital 53,200 4,213 22,522 41,405 10,248 20,431 62% 434 Community Revitalization Enhancement District 650,950 - 20,975 0 458,949 0 650,950 0% 450 Palais Royale Historic Preservation 10,000 0 0 20,470 0 10,000 0% 677 Football Hall of Fame Capital 188,567 5,019 101,010 63,137 0 87,557 54% Capital Project Total 15,180,983 1,053,386 11,756,038 12,128,515 1,984,573 1,440,373 91% Enterprise 600 Consolidated Building Fund 3,798,909 291,793 3,128,438 1,006,337 51,287 619,184 84% 601 Parking Garages 1,597,808 184,288 831,676 942,855 192,985 573,147 64% 610 Solid Waste Operations 5,854,463 344,709 5,681,203 5,804,066 1,955 171,304 97% 611 Solid Waste Capital 996,070 10,902 873,306 712,375 0 122,765 88% 620 Water Works Operations 14,842,004 1,114,528 13,760,364 13,374,286 236,229 845,411 94% 622 Water Works Capital 978,258 29,749 416,576 627,301 85,892 475,790 51% 623 Water Works Bond Capital 811,011 19,960 631,706 5,006,757 53,085 126,220 84% 624 Water Works Customer Deposit 6,000 291 4,997 4,901 0 1,003 83% 625 Water Works Sinking 2,057,224 1,666,070 2,052,934 2,055,303 0 4,290 100% 626 Water Works Bond Reserve 0 0 0 0 0 0 0% 629 Water Works Reserve Operations & Maintenance 8,500 411 7,079 6,927 0 1,421 83% 640 Sewer Repair Insurance 549,978 39,546 441,433 351,024 0 108,545 80% 641 Sewage Works Operations 35,556,194 2,158,176 31,610,541 28,828,365 1,253,785 2,691,869 92% 642 Sewage Works Capital 9,436,035 329,856 4,307,956 5,012,953 3,712,709 1,415,370 85% 643 Sewage Works Reserve Operations & Maint. 15,000 674 11,637 11,036 0 3,363 78% 645 2006 Sewer Bond 0 0 0 12 0 0 0% 647 Sewer Bond 2007 1,143 0 1,143 17,942 0 0 100% 649 Sewage Sinking 9,802,231 1,977,890 9,302,222 9,516,963 0 500,009 95°% 650 Clay Sewage Gen Fund 0 0 0 698 0 0 0% 651 20078 Sewer Bond 0 -2 0 39,624 0 0 0% 653 Sewage Debt Service Reserve 0 0 0 2,438,087 0 0 0°% 658 Sewer Bond 2010 2,221 0 2,220 110,204 0 1 100% 659 Sewer Bond 2011 13,598,486 550,237 6,268,779 2,348,981 1,705,838 5,623,870 59% 661 Sewer Bond 2012 18,868,570 558,854 1,531,023 5,012,877 1,624,275 15,713,272 17% 663 Sewer Bond 2013 0 0 0 0 0 0 0% 664 2013A Cost of Issuance Fund 0 0 0 81,279 0 0 0% 665 2014 Sewer Bond 0 0 0 0 0 0 0% 670 Century Center 4,564,898 351,376 3,818,921 3,362,598 0 745,977 84% 671 Century Center Capital 393,547 0 339,363 192,495 0 54,184 86°% Enterprise Total 123,738,550 9,629,307 85,023,516 86,866,248 8,918,039 29,796,995 76% Internal Service 222 Central Services 8,036,532 586,149 7,034,645 7,306,386 167,446 834,441 90% 226 Liability Insurance 2,897,200 374,346 2,541,638 3,069,761 669 354,893 88°% 278 Take Home Vehicle Police 80,580 0 60,580 63,700 0 20,000 75% 711 Self- Funded Employee Benefits 15,931,637 1,410,230 14,923,436 13,923,392 5,000 1,003,201 94°% 713 Unemployment Compensation 227,974 1,241 121,906 65,443 0 106,068 53°% Internal Service Total 27,173,923 2,371,966 24,682,205 24,428,682 173,115 2,318,603 91% Trust & Agency 701 Firefighters Pension 5,874,445 436,047 5,430,699 5,447,975 0 443,746 92°% 702 Police Pension 7,221,941 542,504 6,716,677 6,474,834 0 505,264 93% 730 City Cemetery 20,595 0 8,658 4,316 0 11,937 42°% 703 Police /Fire 1977 Pension 0 0 0 0 0 0 0% L City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY December 31, 2014 Trust & Agency Total 13,116,981 978,551 12,156,033 11,927,125 0 960,948 93% City Funds Total ' 313,239,279 24,022,954 248,100,927 253,993,300 21,248,741 43,889,541 86% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF Revenue - Airport 27,286,693 984,637 8,217,759 9,227,906 1,861,382 17,207,552 37% 420 Tax Incremental Financing (TIF) - Downtown 5,829,261 252,877 3,601,358 3,697,473 192,966 2,034,937 65% 422 TIF - West Washington 657,534 0 12 333,810 38,900 618,622 6% 425 Redevelopment Retail & Leighton Plaza 149,425 4,910 125,690 121,617 0 23,735 84% 426 TIF - Central Medical Service Area 4,103,504 0 1,796,074 1,860,607 179,126 2,128,304 48% 429 TIF - Northeast Development 2,806,117 4,834 29,301 60,517 187,524 2,589,292 8% 430 TIF - Southside Development #1 6,487,957 96,588 871,168 4,376,766 1,222,533 4,394,256 32% 435 TIF - Douglas Road 399,823 0 395,621 190,718 4,200 2 100% 436 TIF - Northeast Residential 3,583,228 0 3,576,880 3,218,420 0 6,348 100% Tax Increment Financing Total 51,303,542 1,343,846 18,613,863 23,087,834 3,686,631 29,003,048 43% Redevelopment 433 Redevelopment General 20,000 0 15,703 5,798 0 4,297 79% 439 Certified Technology Park 3,600,000 0 0 0 0 3,600,000 0% 454 Airport Urban Enterprise Zone 0 0 0 0 0 0 0% 619 Blackthorn Operations 1,671,706 62,721 1,552,466 1,745,117 0 119,240 93% Redevelopment Total 5,291,706 62,721 1,568,169 1,750,915 0 3,723,537 30% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 205 3,548 3,567 0 1,452 71% 317 Coveleski Debt Service Reserve 0 0 0 0 0 0 0% 319 Blackthorn Redev Bond 0 0 0 326,464 0 0 0% 328 Redevelopment Bond - Palais Royale 6,000 342 5,929 5,959 0 71 99% 432 TIF - Southside Development #3 494,151 0 492,151 490,005 0 2,000 100% Debt Service Total 505,151 547 501,628 825,995 0 3,523 99% Redevelopment C�n 57,100,399 1,407,114 20,683,660 25,664 3,686,631 32,730,108 M Grand Total 370,339,678 25,430,068 268,784,587 279,658,044 24,935,372 76,619,649 79% 7 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Month December Fund /Department Number 101 -0101 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 710,257 58,214 691,505 629,236 - 18,752 97% Local Income Taxes - - - - - - 0% Other Taxes - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - 50 80 325 - (80) 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - 69 234 1,968 - (234) 0% Other Income 6,389 - 5,789 40 - 600 91% Transfers In - - - - - - 0% Total Revenue 716,646 58,333 697,608 631,570 - 19,038 97% Expenditures Personnel 631,126 47,053 619,264 509,868 - 11,862 98% Supplies 21,371 1,539 20,584 52,243 661 126 99% Services 60,811 9,192 54,424 67,113 1,352 5,035 92% Debt Service 3,338 550 3,337 2,346 - 1 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 716,646 58,333 697,608 631,570 2,014 17,024 98% Net - - - - (2,014) 2,014 Cash Balance - - Staffing Full Time 7.00 7.00 7.00 Part -Time /Seasonal /Temporary - 1.00 1.00 Total 7.00 8.00 8.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Debt Service is paid quarterly; the first payment was made in January 2014. In an effort to be more Green, the supply category is much lower than prior year as less paper is used. Reports are transmitted electronically and shared on the City's website for public information and transparency. Explain Significant Spending on Capital Projects Below: There are no capital projects budgeted for 2014. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center Month December Fund /Department Number 101 -0104 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 8,831 - (27,409) 26,509 - 36,240 -310% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 480,077 32,707 456,722 242,243 - 23,355 95% Transfers In - - - - - - 0% Total Revenue 488,908 32,707 429,313 268,752 - 59,595 88% Expenditures Personnel 422,705 31,426 392,461 256,411 - 30,244 93% Supplies 24,771 26 15,707 8,860 625 8,439 66% Services 41,432 1,255 21,146 3,481 15,817 4,470 89% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 488,908 32,707 429,313 268,752 16,442 43,153 91% Net - - - - (16,442) 16,442 Cash Balance - - Staffing 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 ChangesNariances Below: The negative revenues indicated in the Property Taxes line, Current Year to Date Actual column indicate that this department is collecting more in revenues than it has expended - -this department is paying for itself. Part of the reason for the negative property tax revenue is also due to timing of recording charges to other departments. There were charges that occured in 2013, however, that were not recorded until January 2014, and thus showing a credit each month YTD. This corrected itself in 2015. Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted in 2014. Form 3 Form 3 10 2014 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Month December Fund /Department Number 101 -0201 Date Updated 2/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 393,508 26,600 333,593 323,764 - 59,915 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 393,508 26,600 333,593 323,764 - 59,915 85% Expenditures Personnel 312,763 22,646 284,153 269,202 - 28,610 91% Supplies 10,992 810 8,771 12,397 - 2,221 80% Services 56,353 3,144 40,668 42,165 1,115 14,570 74% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 393,508 26,600 333,593 323,764 1,115 58,800 85% Net - - - - (1,115) 1,115 Cash Balance - - Staffing 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 ChangesNariances Below: Expenditures are consistent with normal operating costs. Explain Significant Spending on Capital Projects Below: The office equipment budgeted for replacement during 2014 was not addressed this year. Form 3 10 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Common Council Month December Fund /Department Number 101 -0301 Date Updated 2/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 535,398 64,901 416,955 341,815 - 118,443 78% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 8,300 27 704 7,106 - 7,596 8% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 543,698 64,928 417,660 348,921 - 126,038 77% Expenditures Personnel 277,929 15,601 199,752 189,822 - 78,177 72% Supplies 7,285 480 1,094 13,983 303 5,888 19% Services 258,484 48,848 216,813 145,116 4,708 36,963 86% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 543,698 64,928 417,660 348,921 5,011 121,027 78% Net - - - - (5,011) 5,011 Cash Balance - - Staffing 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 ChangesNariances Below: There are nine (9) Council Members. One member has declined to receive a salary. Total expenditures are higher in 2014 due to legal expenses for unforseen circumstances. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 iVA 2014 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Month December Fund /Department Number 101 -0401 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,083,938 145,470 1,946,804 1,796,779 - 137,134 93% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 3,071 - 4,452 6,866 - (1,381) 145% Transfers In - - - - - - 0% Total Revenue 2,087,009 145,470 1,951,256 1,803,645 - 135,753 93% Expenditures Personnel 1,751,616 135,833 1,703,591 1,493,377 - 48,025 97% Supplies 42,140 3,522 32,507 41,012 200 9,434 78% Services 289,453 6,115 212,587 267,971 5,125 71,741 75% Debt Service 3,800 - 2,571 1,286 - 1,229 68% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,087,009 145,470 1,951,256 1,803,645 5,325 130,428 94% Net - - - - (5,325) 5,325 Cash Balance - - Staffing Full Time 23.00 20.00 Part -Time /Seasonal /Temporary 2.00 5.00 Total 25.00 25.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Added 3.2 positions in 2014. New Benefits Manager, Help Desk and Database Administrator positions were approved in the 2014 budget. The Database Administrator position remains unfilled. A new Deputy City Controller began in April, 2014. Additional training costs are being incurred during 2014 for new and existing staff members. Explain Significant Spending on Capital Projects Below: None Form 3 iVA Form 3 13 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Month December Fund /Department Number 101 -0404 Date Updated 1/12/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 179,264 (117,314) (83,660) 31,252 - 262,924 -47% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 878,763 197,089 999,750 887,941 - (120,987) 114% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 5,500 278 6,213 5,944 - (713) 113% Transfers In - - - - - - 0% Total Revenue 1,063,527 80,053 922,302 925,137 - 141,225 87% Expenditures Personnel 711,096 52,839 654,026 632,829 - 57,070 92% Supplies 32,657 2,289 18,106 21,674 692 13,859 58% Services 319,774 24,926 250,170 270,633 22,683 46,920 85% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,063,527 80,053 922,302 925,137 23,375 117,849 89% Net - - - - (23,375) 23,375 Cash Balance - - Staffing 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 ChangesNariances Below: 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. Not all of the expenses are Capital expenses. Explain Significant Spending on Capital Projects Below: Form 3 13 Form 3 14 2014 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Month December Fund /Department Number 101 -0405 Date Updated 1/12/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 295,186 19,681 178,912 96,085 - 90,849 61% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 214,274 15,240 207,619 282,344 - 6,655 97% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 14,250 1,709 14,794 18,529 - (544) 104% Transfers In - - - - - - 0% Total Revenue 523,710 36,630 401,325 396,959 - 96,960 77% Expenditures Personnel 251,265 17,915 229,220 205,555 - 22,045 91% Supplies 31,629 1,348 8,025 10,110 1,140 22,464 29% Services 225,816 17,366 164,080 181,293 24,285 37,451 83% Debt Service - - - - - - 0% Capital 15,000 - - - - 15,000 0% Transfers Out - - - - - - 0% Total Expenditures 523,710 36,630 401,325 396,959 25,425 96,960 81% Net - - - - (25,425) - Cash Balance - - Staffing 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 ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Curtain replacement was budgeted as a capital expenditure in 2014 but wasn't initiated. Form 3 14 Form 3 W1 2014 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Month December Fund /Department Number 101 -0501 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 951,301 12,589 884,628 839,607 - 66,673 93% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 - 1,581 1,075 - 419 79% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 72,334 54,358 59,744 55,108 - 12,590 83% Transfers In - - - - - - 0% Total Revenue 1,025,635 66,947 945,954 895,789 - 79,681 92% Expenditures Personnel 977,419 61,562 902,017 819,999 - 75,402 92% Supplies 5,083 714 3,566 21,510 668 848 83% Services 41,754 4,354 39,099 51,707 892 1,763 96% Debt Service 1,379 318 1,271 2,573 - 108 92% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,025,635 66,947 945,954 895,789 1,560 78,121 92% Net - - - - (1,560) 1,560 Cash Balance - - Staffing Full Time 9.60 9.60 Part -Time /Seasonal /Temporary - 1.00 Total 9.60 10.60 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Other Income of $54,358 is reimbursement for legal expenses from TIF funds which was received in December 2014. $54,388 was received in November 2013 for legal expenses incurred for TIF related activities. Explain Significant Spending on Capital Projects Below: Form 3 W1 Form 3 W" 2014 City of South Bend Monthly Financial Report Fund /Department Name Engineering Month December Fund /Department Number 101 -0602 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 1,100,952 58,780 973,129 1,295,010 - 127,823 88% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,350 - 23,620 5,079 - 1,730 93% Transfers In - - - - - - 0% Total Revenue 1,126,302 58,780 996,749 1,300,089 - 129,553 88% Expenditures Personnel 583,475 37,222 568,947 611,362 - 14,528 98% Supplies 20,129 1,002 17,731 19,213 22 2,376 88% Services 509,156 19,908 402,371 664,920 105,880 906 100% Debt Service 13,542 648 7,701 4,593 - 5,841 57% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,126,302 58,780 996,749 1,300,089 105,902 23,651 98% Net - - - - (105,902) 105,902 Cash Balance - - Staffing Full Time 6.90 6.65 Part -Time /Seasonal /Temporary 1.81 1.28 Total 8.71 7.93 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: $105,880 in encumbrance for Services include $41,700 for water system evaluation, $42,750 for 13th floor renovation, and $14,400 for 2015 travel booked in 2014. Explain Significant Spending on Capital Projects Below: Form 3 W" Form 3 17 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Department Month December Fund /Department Number 101 -0801 Date Updated 1/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 24,509,621 2,253,174 23,294,709 22,140,160 - 1,214,912 95% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 24,316 - 24,316 - - (0) 100% Charges for Services - - 200 395 - (200) 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 7,500 - - - - 7,500 0% Other Income 392,710 46,064 361,156 368,972 - 31,554 92% Transfers In 6,057 6,057 6,057 - - (0) 100% Total Revenue 24,940,204 2,305,295 23,686,438 22,509,527 - 1,253,766 95% Expenditures Personnel 20,080,704 1,884,989 19,834,133 19,287,913 - 246,571 99% Supplies 804,999 42,117 607,080 465,036 130,052 67,868 92% Services 3,981,343 377,670 3,175,189 2,662,555 391,501 414,653 90% Debt Service 8,000 518 4,878 - - 3,122 61% Capital 65,158 - 65,158 94,023 - - 100% Transfers Out - - - - - - 0% Total Expenditures 24,940,204 2,305,295 23,686,438 22,509,527 521,552 732,213 97% Net - - - - (521,552) 521,552 Cash Balance - - Staffing Full Time 253.00 247.00 247.00 Part -Time /Seasonal /Temporary 57.00 31.00 31.00 Total 310.00 278.00 278.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund includes the expenditures for 213 of the 260 budgeted Police officers and 95 civilian staff. Fund 249 contains the funding for 47 of the 260 Police officers that are funded by the LOIT. The 2014 Personnel Expenditure exceeds the prior year amount due to the 2.5 % increase in Police salaries partially offset by resignations and retirements in 2014 compared to 2013. Services expenditures exceed 2013 due to higher than planned legal expenses. Explain Significant Spending on Capital Projects Below: Capital expenditures budget for 2014 is the result of a 2013 encumbrance to upgrade the video software for the interview room plus a budget transfer to provide for the conversion of police vehicles to compressed natural gas. The year to date capital expenditure was the cost of the video software for the interview room. Form 3 17 2014 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Month December Fund /Department Number 101 -0802 Date Updated 1/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,021,486 180,895 1,985,945 2,060,643 - 35,541 98% 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 2,021,486 180,895 1,985,945 2,060,643 - 35,541 98% Expenditures Personnel 1,995,667 179,542 1,973,871 2,036,925 - 21,796 99% Supplies 4,029 - 1,362 1,868 - 2,667 34% Services 21,790 1,353 10,712 21,850 - 11,078 49% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,021,486 180,895 1,985,945 2,060,643 - 35,541 98% Net - - - - - - Cash Balance - - Staffing Full Time 35.00 34.00 34.00 Part -Time /Seasonal /Temporary - - - Total 35.00 34.00 34.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund captures the cost of 35 of the 38 civilians and equipment to maintain the 911 communication center. The cost of three supervisors has been transferred to Fund 244 as their cost is recovered through the Emergency Telephone System funding. 2014 Personnel costs are less than 2013 due to the 2% salary increase which is offset by the 2014 transfer of three supervisiors to Fund 244. This department will be eliminated after 2015 when these personnel become county employees with the creation of the new county -wide PSAP (Public Safety Answering Point) system as of 1 January 2015. 2015 expenditures will be comprised of remaining vacation to be paid. Explain Significant Spending on Capital Projects Below: Form 3 18 2014 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Month December Fund /Department Number 101 -0901 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 20,023,432 2,045,048 20,001,066 18,541,227 22,366 100% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 155,000 - - - - 155,000 0% Charges for Services 463,678 103,017 576,925 624,406 - (113,247) 124% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 7,305 - 3,206 38,917 - 4,099 44% Transfers In 1,000,000 - 1,000,000 1,000,000 - - 100% Total Revenue 21,649,415 2,148,065 21,581,197 20,204,550 - 68,218 100% Expenditures Personnel 19,600,048 2,005,852 19,594,551 18,387,319 3,225 2,272 100% Supplies 388,843 35,670 356,742 374,747 2,101 30,000 92% Services 1,660,524 106,544 1,629,903 1,442,485 8,816 21,805 99% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 21,649,415 2,148,065 21,581,197 20,204,550 14,142 54,076 100% Net - - - - (14,142) 14,142 Cash Balance - - Staffing Full Time 219.00 217.00 217.00 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 220.00 218.00 218.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The South Bend Fire Department is budgeted to have 251 sworn firefighters and 6 civilian full time employees. 38 firefighters are paid directly through the Public Safety LOIT leaving this account the balance. We swore on 1 firefighter in the month of September. 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. Explain Significant Spending on Capital Projects Below: The Fire Department uses EMS Capital Fund 288 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through that fund. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Form 3 19 Form 3 20 2014 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Month December Fund /Department Number 101 -1008 Date Updated 2/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 367,262 25,961 334,144 313,813 - 33,118 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 - - - 242 - - 0% Transfers In - - - - - - 0% Total Revenue 367,262 25,961 334,144 314,055 - 33,118 91% Expenditures Personnel 272,252 20,963 267,336 241,726 - 4,916 98% Supplies 2,394 32 1,354 3,710 - 1,040 57% Services 78,426 4,966 65,453 68,619 1,561 11,412 85% Debt Service - - - - - - 0% Capital 14,190 - - - 11,202 2,988 79% Transfers Out - - - - - - 0% Total Expenditures 367,262 25,961 334,144 314,055 12,763 20,355 94% Net - - - - (12,763) 12,763 Cash Balance - - Staffing 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 ChangesNariances Below: Expenditures are consistent with normal operations. Explain Significant Spending on Capital Projects Below: Form 3 20 Form 3 `A 2014 City of South Bend Monthly Financial Report Fund /Department Name Rainy Day Month December Fund /Department Number 102 Date Updated 2/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 52,000 (3,287) 24,483 29,524 - 27,517 47% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 52,000 (3,287) 24,483 29,524 - 27,517 47% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 52,000 (3,287) 24,483 29,524 - 27,517 Cash Balance 8,632,917 8,617,705 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: N/A Form 3 `A 2014 City of South Bend Monthly Financial Report Fund /Department Name Excess Levy Month December Fund /Department Number 103 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 3,648 3,648 3,648 - - 0 100% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 3,648 3,648 3,648 - - 0 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 3,648 3,648 3,648 - - 0 Cash Balance 3,648 - Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: A small excess of property tax was received in December 2014. Explain Significant Spending on Capital Projects Below: N/A Form 3 RIVA Form 3 23 2014 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation Month December Fund /Department Number 201 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 7,350,000 3,343,785 7,365,388 7,207,060 - (15,388) 100% Local Income Taxes 596,878 - 653,704 619,840 - (56,826) 110% Other Taxes - - - 0% Grants /Intergovernmental 729,437 390,043 729,389 696,009 - 48 100% Charges for Services 2,149,540 72,327 1,907,037 3,083,134 - 242,503 89% Interest Earnings 13,000 (1,841) 6,055 12,082 - 6,945 47% Bond Proceeds - - - 0% Donations - - - 0% Other Income 175,085 24,175 162,395 150,080 - 12,690 93% Transfers In - - - - 0% Total Revenue 11,013,940 3,828,489 10,823,968 11,768,205 - 189,972 98% Expenditures Personnel 7,126,942 455,378 6,805,120 7,609,507 325 321,497 95% Supplies 1,531,319 71,335 1,203,587 1,741,911 35,078 292,653 81% Services 3,323,772 219,299 3,074,013 2,191,885 59,658 190,102 94% Debt Service 315,345 50,633 315,007 291,251 338 100% Capital 93,000 - 87,867 348,562 5,133 94% Transfers Out 210,500 96,819 96,819 209,824 - 113,681 46% Total Expenditures 12,600,878 893,464 11,582,413 12,392,940 95,061 923,404 93% Net (1,586,938) 2,935,025 (758,445) (624,735) (95,061) (733,432) Cash Balance 3,494,861 4,255,160 Staffing Full Time 113.00 88.00 88.00 Part -Time /Seasonal /Temporary na 53.00 53.00 Total 113.00 141.00 141.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. For 2014, the Potawatomi Zoo is operated by the Potawatomi Zoological Society.The Zoo revenues have been removed from the budget. However, because of the timing of the change, the original expenses are still included in the above budget in order to cover obligations resulting from the memorandum of understanding between the City and PZS. Expenses related to the Zoo transition also contributed to the higher than normal expenses in personnel and services categories and lower cash balance. Golf Revenues have been affected by the cold, wet spring, rainy summer weather and early winter. The weather did improve for two weeks in December that allowed play. Part time staffing is individuals, not FTEs Explain Significant Spending on Capital Projects Below: Because of decreasing property tax revenues, the only capital expense for 2014 consists of the purchase of three pickup trucks and two commercial riding mowers. Form 3 23 Form 3 24 2014 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month December Fund /Department Number 202 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,633,418 266,260 5,320,036 5,051,334 - 313,382 94% Grants /Intergovernmental - - - 0% Charges for Services 298,600 30,057 336,930 434,784 - (38,330) 113% Interest Earnings 11,350 (1,379) 10,051 11,791 - 1,299 89% Bond Proceeds - - - 0% Donations - - - 0% Other Income 97,665 14,525 108,754 14,332 - (11,089) 111% Transfers In 3,216,582 250,000 3,216,582 3,626,882 - - 100% Total Revenue 9,257,615 559,463 8,992,353 9,139,123 - 265,262 97% Expenditures Personnel 3,937,510 310,753 3,756,343 3,461,070 181,167 95% Supplies 3,170,848 224,720 2,413,249 2,432,217 617,260 140,340 96% Services 2,466,374 204,693 2,232,980 1,634,235 147,367 86,027 97% Debt Service 255,895 318 255,226 106,618 669 100% Capital 178,250 134,030 95,847 39,458 4,762 97% Transfers Out - - - - - - 0% Total Expenditures 10,008,877 740,483 8,791,827 7,729,988 804,085 412,965 96% Net (751,262) (181,020) 200,526 1,409,136 (804,085) (147,703) Cash Balance 1 3,891,051 3,679,915 Staffing Full Time 58.01 55.01 Part -Time /Seasonal /Temporary 7.14 6.68 Total 65.15 61.69 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Information included for Streets, Traffic & Lighting, and Curb & Sidewalk: Increase in YTD costs attributable to 1st quarter 2014 expense for snow control due to severe winter weather, additional contractor expense for Curb and Sidewalk program. Explain Significant Spending on Capital Projects Below: Form 3 24 Form 3 `�7 2014 City of South Bend Monthly Financial Report Fund /Department Name Recreation Nonreverting Month December Fund /Department Number 203 Date Updated 1/12/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,402,592 39,221 842,288 886,739 - 560,304 60% Interest Earnings 4,000 (307) 2,422 2,692 - 1,578 61% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 82,586 31,174 100,775 113,888 - (18,189) 122% Transfers In - - - - - - 0% Total Revenue 1,489,178 70,088 945,486 1,003,318 - 543,692 63% Expenditures Personnel 613,627 31,230 465,680 438,880 - 147,947 76% Supplies 274,095 29,270 205,890 219,805 11,825 56,380 79% Services 492,342 7,099 238,252 227,141 1,382 252,709 49% Debt Service - - - - - - 0% Capital 99,000 - - - - 99,000 0% Transfers Out - - - 10,375 - - 0% Total Expenditures 1,479,064 67,599 909,822 896,201 13,206 556,035 62% Net 10,114 2,489 35,663 107,117 (13,206) (12,343) Cash Balance 813,708 778,249 Staffing Full Time 1.00 1.00 1.00 Part -Time /Seasonal /Temporary - 48.00 48.00 Total 1.00 49.00 49.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund accounts for 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. Explain Significant Spending on Capital Projects Below: Form 3 `�7 Form 3 26 2014 City of South Bend Monthly Financial Report Fund /Department Name Studebaker - Oliver Reverting Grants Month December Fund /Department Number 209 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 30,000 - - - - 30,000 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 (413) 3,078 3,712 - 1,922 62% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 300,000 - - - - 300,000 0% Transfers In - - - - - - 0% Total Revenue 335,000 (413) 3,078 3,712 - 331,922 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 30,000 - - - 30,000 - 100% Debt Service - - - - - - 0% Capital 1,385,000 - - - - 1,385,000 0% Transfers Out - - - - - - 0% Total Expenditures 1,415,000 - - - 30,000 1,385,000 2% Net (1,080,000) (413) 3,078 3,712 (30,000) (1,053,078) Cash Balance 1,085,299 1,083,387 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: There is $300,000 budgeted in Revenue as an expected insurance payment in this fund. The payment wasn't realized in 2014. Explain Significant Spending on Capital Projects Below: Funds to be used for environmental clean up as needed. If not used this year, funds will be appropriated for use next year. Form 3 26 Form 3 27 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Month December Fund /Department Number 210 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 2,000,000 - - - - 2,000,000 0% Charges for Services - - - - - - 0% Interest Earnings 18,813 3,165 14,842 60,703 - 3,971 79% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 58,203 14,714 58,200 177,362 - 3 100% Transfers In - - - - - - 0% Total Revenue 2,077,016 17,879 73,042 238,065 - 2,003,974 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 45,000 - 20,550 - 22,400 2,050 95% Debt Service 117,886 18,003 72,010 807,570 - 45,876 61% Capital 2,000,000 - - - - 2,000,000 0% Transfers Out - - - - - - 0% Total Expenditures 2,162,886 18,003 92,560 807,570 22,400 2,047,926 5% Net (85,870) (124) (19,518) (569,505) (22,400) (43,952) Cash Balance 329,079 348,950 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: No significant issues. The IRF Loan was paid off early in 2013. Original maturity date was 07/30/2022. We were awarded a grant from the IDGF in the amount of $2,000,000 to be used for Ignition Park Infrastructure. The grant is paid on a reimbursement basis; no expenditures in 2014. Explain Significant Spending on Capital Projects Below: Form 3 27 Form 3 28 2014 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development Admn. Month December Fund /Department Number 211 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 386,787 - 347,467 467,180 - 39,320 90% Charges for Services - - - - - - 0% Interest Earnings 4,200 (364) 2,626 2,610 - 1,574 63% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 326,071 13,208 321,325 304,302 - 4,746 99% Transfers In 1,688,959 - 1,688,959 1,717,519 - - 100% Total Revenue 2,406,017 12,844 2,360,377 2,491,611 - 45,640 98% Expenditures Personnel 2,058,296 153,341 1,902,952 1,780,056 10,868 144,476 93% Supplies 43,735 2,319 31,197 31,103 9,455 3,083 93% Services 302,853 16,984 259,325 352,254 9,783 33,745 89% Debt Service - - - - - - 0% Capital - - - 4,720 - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,404,884 172,644 2,193,474 2,168,133 30,106 181,304 92% Net 1,133 (159,800) 166,903 323,478 (30,106) (135,664) Cash Balance 1,073,066 907,315 Staffing Full Time 26.60 23.00 23.00 Part -Time /Seasonal /Temporary - - - Total 26.60 23.00 23.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is financed through transfers from the EDIT fund made quarterly. Explain Significant Spending on Capital Projects Below: Form 3 28 Form 3 29 2014 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development Month December Fund /Department Number 212 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 6,692,663 590,476 4,287,123 3,995,268 - 2,405,540 64% Charges for Services - - - - - - 0% Interest Earnings 2,200 (346) 1,582 2,152 - 618 72% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 993,336 3,353 535,146 486,021 - 458,190 54% Transfers In - - - - - - 0% Total Revenue 7,688,199 593,483 4,823,851 4,483,441 - 2,864,348 63% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 7,190,785 441,941 4,623,591 4,406,331 2,447,967 119,227 98% Transfers Out - - - - - - 0% Total Expenditures 7,190,785 441,941 4,623,591 4,406,331 2,447,967 119,227 98% Net 497,414 151,542 200,260 77,110 (2,447,967) 2,745,121 Cash Balance 790,334 590,162 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: Form 3 29 Form 3 30 2014 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Month December Fund /Department Number 216 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 35,000 - 28,309 26,972 - 6,691 81% Charges for Services - - - - - - 0% Interest Earnings 600 (73) 456 498 - 144 76% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - - - - 600 0% Transfers In - - 0% Total Revenue 36,200 (73) 28,765 27,470 - 7,435 79% Expenditures Personnel - - - - - - 0% Supplies - 0% Services 20,000 - - 2,729 20,000 0% Debt Service - - - - - 0% Capital 20,000 - - 11,000 - 20,000 0% Transfers Out - 0% Total Expenditures 40,000 - - 13,729 - 40,000 0% Net (3,800) (73) 28,765 13,741 - (32,565) Cash Balance 187,231 158,667 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: Form 3 30 Form 3 191 2014 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month December Fund /Department Number 217 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 290 (44) 382 232 - (92) 132% Bond Proceeds - - - - - - 0% Donations 178,113 3,805 174,918 11,269 - 3,195 98% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 178,403 3,761 175,299 11,501 - 3,104 98% Expenditures Personnel - - - - - - 0% Supplies 22,100 889 14,625 - 1,552 5,923 73% Services 178,910 44,888 97,470 - 79,630 1,810 99% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 201,010 45,776 112,095 - 81,182 7,733 96% Net (22,607) (42,016) 63,204 11,501 (81,182) (4,629) Cash Balance 137,790 74,734 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Gift, Donation, and Bequest fund may be used by all City departments but the majority of the donations are for Animal Care and Control and Community Investment (i.e. bicycle signs). In July this account received a UEA grant for Code Enforcement of $150,000, to be used for demolitions. Explain Significant Spending on Capital Projects Below: None Form 3 191 Form 3 19YA 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Month December Fund /Department Number 218 Date Updated 1/8/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,000 88 438 625 - 563 44% Interest Earnings 125 (5) 33 38 - 92 27% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,125 83 471 663 - 654 42% Expenditures Personnel - - - - - - 0% Supplies - - - - - 0% Services 1,000 - - - - 1,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,000 - - - - 1,000 0% Net 125 83 471 663 - (346) Cash Balance 11,993 11,548 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was established to collect curfew and prostitution fines. Expenditures are used for Police enforcement and training. Explain Significant Spending on Capital Projects Below: Form 3 19YA Form 3 33 2014 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education Month December Fund /Department Number 220 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 10,000 - 10,000 6,964 - - 100% Charges for Services 181,500 12,642 173,953 171,896 - 7,547 96% Interest Earnings 3,000 (363) 2,839 3,491 - 161 95% Bond Proceeds - - - - - - 0% Donations 2,000 - 560 2,725 - 1,440 28% Other Income 28,445 1,910 18,536 9,453 - 9,909 65% Transfers In - - - - - - 0% Total Revenue 224,945 14,189 205,888 194,529 - 19,057 92% Expenditures Personnel - - - - - - 0% Supplies 48,855 - 37,370 131,788 6,498 4,987 90% Services 182,000 31,851 174,515 45,601 - 7,485 96% Debt Service - - - - - - 0% Capital 63,947 - 13,947 123,119 - 50,000 22% Transfers Out - - - - - - 0% Total Expenditures 294,802 31,851 225,832 300,508 6,498 62,472 79% Net (69,857) (17,662) (19,944) (105,979) (6,498) (43,415) Cash Balance 960,250 981,226 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established for the continuing education and supplies for police and is funded by fees from accident reports, gun permits, false alarm and loud noise fines. Other income includes the receipt of funds from the US Marshal Service for rent of SBPD facility. The increase in Services expenditures over 2013 is due to the planned increase in officer training courses. The 2014 Capital purchase was the license renewal for forensic software. Explain Significant Spending on Capital Projects Below: Form 3 33 2014 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Month December Fund /Department Number 227 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 31,960 (2,148) 22,331 18,685 - 9,629 70% Bond Proceeds - - - - - - 0% Donations - - - 22,100 - - 0% Other Income - - - 3,804,857 - - 0% Transfers In - - - - - - 0% Total Revenue 31,960 (2,148) 22,331 3,845,643 - 9,629 70% Expenditures Personnel - - - - - - 0% Supplies 200,000 - - - 67,500 132,500 34% Services 4,315,805 224,508 1,884,503 251,171 2,230,636 200,666 95% Debt Service - - - - - - 0% Capital 2,100,000 44,200 209,968 - 1,889,108 924 100% Transfers Out - - - - - 0% Total Expenditures 6,615,805 268,708 2,094,471 251,171 4,187,243 334,090 95% Net (6,583,845) (270,856) (2,072,140) 3,594,472 (4,187,243) (324,462) Cash Balance 5,857,602 7,936,033 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used primarily to fund Smart Streets projects as well as the Vacant & Abandoned Housing intiative. Most of the $1.2 million encumbrance for Services is to demolition companies for V &A demolitions ($730,000) and Trucks R Us for hauling contaminated refuse from the Organic Resources site ($372,000). (The Organic Resources material has small pieces of plastic in it from being hauled in plastic bags, rendering it useless as organic compost.) Year -end encumbrances include $1.89M for Smart Streets and $1.81 M for vacant and abandoned housing. Explain Significant Spending on Capital Projects Below: Budgeted capital expenditures include $150,000 for a well pump at West Calvert (in association with the ethanol plant) and $1.95 million for the Smart Streets initiative. The well pump has been installed but this account's reserve has yet to be used for the streets. Capital encumbrance includes $1.1 million for Bartlett roundabout. Form 3 34 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month December Fund /Department Number 244 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 215,000 - 215,000 - - - 100% Charges for Services - - - - - - 0% Interest Earnings - (19) (19) - - 19 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 215,000 (19) 214,981 - - 19 100% Expenditures Personnel 215,000 11,637 181,330 - - 33,670 84% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 215,000 11,637 181,330 - - 33,670 84% Net - (11,656) 33,651 - - (33,651) Cash Balance 33,615 - Staffing Full Time 3.00 3.00 3.00 Part -Time /Seasonal /Temporary - - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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 will be closed in 2015 with the advent of the county -wide PSAP system. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 MA Form 3 Ki: 2014 City of South Bend Monthly Financial Report Fund /Department Name Public Safety WIT Month December Fund /Department Number 249 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 6,380,029 531,669 6,380,029 5,892,386 - (0) 100% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 11,000 (585) 4,421 6,954 - 6,579 40% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 683,303 - - 0% Total Revenue 6,391,029 531,084 6,384,450 6,582,642 - 6,579 100% Expenditures Personnel 7,214,658 551,774 7,123,412 - - 91,246 99% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - 7,540,389 - - 0% Total Expenditures 7,214,658 551,774 7,123,412 7,540,389 - 91,246 99% Net (823,629) (20,690) (738,962) (957,746) - (84,667) Cash Balance 1,291,845 2,032,194 Staffing Full Time - 85.00 85.00 Part -Time /Seasonal /Temporary - - - Total - 85.00 85.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Prior to 2014, monies in Fund 249 were transferred quarterly to the General Fund to fund police and fire personnel. A quarterly reconciliaton was prepared and any unspent money was transferred back to Fund 249. For 2014, the City has been advised by the DLGF and SBOA that it should budget personnel costs directly from Fund 249. In 2014 the Fund includes the salary and benefit costs for 47 police officers and 38 firefighters. As of Sep 2014 the police expenditures are in line with budget but firefighters are over by $188,000. Explain Significant Spending on Capital Projects Below: None. No capital equipment is purchased from this fund. Form 3 Ki: Form 3 37 2014 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month December Fund /Department Number 251 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,080,000 90,111 1,017,383 1,001,871 - 62,617 94% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 8,000 (946) 6,174 6,247 - 1,826 77% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 36,996 3,190 36,991 825 - 5 100% Transfers In - - - - - - 0% Total Revenue 1,124,996 92,354 1,060,548 1,008,943 - 64,448 94% Expenditures Personnel - - - - - - 0% Supplies 472,663 - 471,771 397,338 229 663 100% Services 7,500 - - 7,500 - 7,500 0% Debt Service - - - - - - 0% Capital 644,357 2,100 85,704 377,028 333,492 225,161 65% Transfers Out - - - - - - 0% Total Expenditures 1,124,520 2,100 557,475 781,866 333,721 233,324 79% Net 476 90,254 503,073 227,077 (333,721) (168,876) Cash Balance 2,441,825 1,941,375 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Supplies are always street paving materials to be used throughout the year. $33,801 received in April as project reimbursement for Edison & Gordon. Explain Significant Spending on Capital Projects Below: 2014 Budget: Boland Multi -Use Path: $250,000 New traffic devices: $167,000 Other projects: $325,000 $333K encumbered in Capital is $63K for the Olive - Sample overpass and $265K for Boland Trail Form 3 37 Form 3 38 2014 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Month December Fund /Department Number 252 Date Updated 2/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5 0 4 4 - 1 78% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5 0 4 4 - 1 78% Expenditures Personnel - - - - - - 0% Supplies 1,146 1,146 1,146 - - - 100% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,146 1,146 1,146 - - - 100% Net (1,141) (1,146) (1,142) 4 - 1 Cash Balance 8 1,150 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. The final fund balance will be spent during 2014. Explain Significant Spending on Capital Projects Below: Form 3 38 Form 3 39 2014 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant Month December Fund /Department Number 258 Date Updated 2/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 215,333 25,833 185,783 146,650 - 29,550 86% Charges for Services - - - - - - 0% Interest Earnings 2,000 129 1,480 1,593 - 520 74% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 21,700 75,820 85,434 29,905 - (63,734) 394% Transfers In - - - - - - 0% Total Revenue 239,033 101,782 272,697 178,148 - (33,664) 114% Expenditures Personnel 115,401 8,538 109,817 105,880 - 5,584 95% Supplies 4,550 200 1,901 3,801 - 2,649 42% Services 152,550 7,663 97,501 87,857 - 55,049 64% Debt Service - - - - - - 0% Capital 1,500 - - - - 1,500 0% Transfers Out - - - - - - 0% Total Expenditures 274,001 16,401 209,220 197,537 - 64,781 76% Net (34,968) 85,381 63,477 (19,389) - (98,445) Cash Balance 529,763 466,775 Staffing Full Time 2.00 2.00 2.00 Part -Time /Seasonal /Temporary - - - Total 2.00 2.00 2.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Human Rights Federal Grant Fund contains separate departments for EEOC and HUD grants. This month, Human Rights received grant money from HUD in the amount of $25,000 to continue to educate and promote fair housing. Explain Significant Spending on Capital Projects Below: A drop down projector and large screen TV has been budgeted in capital for the conference room in the new Human Rights building. Form 3 39 Form 3 40 2014 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Month December Fund /Department Number 271 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 100 (2) 32 49 - 68 32% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 100 (2) 32 49 - 68 32% Expenditures Personnel - - - - - - 0% Supplies 10,346 - 9,092 - - 1,254 88% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,346 - 9,092 - - 1,254 88% Net (10,246) (2) (9,060) 49 - (1,186) Cash Balance 5,307 14,372 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In past years there have been no races. Explain Significant Spending on Capital Projects Below: Form 3 40 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month December Fund /Department Number 273 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 9,400 1,400 10,610 7,018 - (1,210) 113% Interest Earnings 100 (10) 75 95 - 25 75% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 9,500 1,390 10,685 7,113 - (1,185) 112% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 18,000 878 11,957 7,891 974 5,070 72% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 18,000 878 11,957 7,891 974 5,070 72% Net (8,500) 512 (1,272) (777) (974) (6,255) Cash Balance 26,685 27,985 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Morris Performing Arts Center and Palais Royale Marketing Fund was established as a separate non - reverting fund to receive monies from solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marqee sponsorships; and to accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale. The funds in this account at the end of the fiscal year shall not revert to the general fund. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund Form 3 Cy 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Month December Fund /Department Number 280 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - (1) 11 13 - (11) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - (1) 11 13 - (11) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - (1) 11 13 - (11) Cash Balance 3,824 3,817 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Explain Significant Spending on Capital Projects Below: Form 3 E, VA 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Month December Fund /Department Number 281 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - (10) 77 93 - (77) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - (10) 77 93 - (77) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - (10) 77 93 - (77) Cash Balance 27,176 27,128 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund to be used only for the expenses of EDC revenue bonds. These bonds have been paid off. Fund to be closed during 2015. Explain Significant Spending on Capital Projects Below: Form 3 43 2014 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Month December Fund /Department Number 289 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,055 - 24,055 16,722 - 10,000 71% Interest Earnings - (15) 63 40 - (63) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 34,055 (15) 24,118 16,762 - 9,937 71% Expenditures Personnel - - - - - - 0% Supplies 30,000 - 697 - 21,530 7,774 74% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - 3,238 - - 0% Transfers Out - - - - - - 0% Total Expenditures 30,000 - 697 3,238 21,530 7,774 74% Net 4,055 (15) 23,421 13,524 (21,530) 2,163 Cash Balance 39,586 16,207 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Received reimbursement for extended response to airplane crash. Explain Significant Spending on Capital Projects Below: 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. Form 3 44 Form 3 E117 2014 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue Month December Fund /Department Number 291 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - 975 - - (975) 0% Charges for Services 45,000 2,400 40,000 65,700 - 5,000 89% Interest Earnings 350 (40) 300 368 - 50 86% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,350 2,360 41,275 66,068 - 4,075 91% Expenditures Personnel 2,500 923 2,474 1,508 - 26 99% Supplies 8,800 52 1,973 36,820 - 6,827 22% Services 41,000 - 27,146 23,985 13,854 66% Debt Service - - - - - - 0% Capital - - - 27,460 - - 0% Transfers Out - - - - - - 0% Total Expenditures 52,300 975 31,594 89,773 - 20,706 60% Net (6,950) 1,385 9,681 (23,705) - (16,631) Cash Balance 105,286 95,718 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: Form 3 E117 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Month December Fund /Department Number 292 Date Updated 1/20/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 228,060 - 76,920 162,838 - 151,140 34% Charges for Services - - - - - - 0% Interest Earnings - (55) (55) - - 55 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 228,060 (55) 76,865 162,838 - 151,195 34% Expenditures Personnel - - - - - - 0% Supplies 15,936 958 958 36,911 14,186 792 95% Services 148,264 (958) 147,305 - 959 - 100% Debt Service - - - - - - 0% Capital 63,860 - 37,702 19,543 - 26,158 59% Transfers Out - - - - - - 0% Total Expenditures 228,060 - 185,965 56,454 15,145 26,950 88% Net - (55) (109,100) 106,384 (15,145) 124,245 Cash Balance 95,306 204,509 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Of the $76,920 of grant money received in 2014, $13,753 is from a Federal grant to improve security at South Bend Schools. The South Bend Police Department is the Administrator of the grant. This funding plus cash received in December of 2013 has been disbursed to the South Bend School Corporation which spent the funds in accordance with the terms of the grant. Included in the $147,305 Services expenditure is The $138,059 reimbursement made to the South Bend School Corp for their expenditures under the Federal grant noted previously. Explain Significant Spending on Capital Projects Below: Form 3 E, P", Form 3 47 2014 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Month December Fund /Department Number 294 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 20,000 - 18,275 20,745 - 1,725 91% Interest Earnings - (26) 223 268 - (223) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In - - - - - - 0% Total Revenue 22,000 (26) 18,498 21,013 - 3,502 84% Expenditures Personnel - - - - - - 0% Supplies 1,750 - 1,305 169 - 445 75% Services 22,000 543 16,995 26,575 - 5,005 77% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 543 18,300 26,744 - 5,450 77% Net (1,750) (569) 198 (5,731) - (1,948) Cash Balance 68,210 68,085 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to fund the cost of course material and instructors at the South Bend Police Academy. The enforcement courses are offered to other police departments who pay a fee to attend the training. Explain Significant Spending on Capital Projects Below: Form 3 47 Form 3 48 2014 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Month December Fund /Department Number 295 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 350 (40) 318 364 - 32 91% Bond Proceeds - - - - - - 0% Donations 3,250 - - 250 - 3,250 0% Other Income 38,000 750 12,096 22,454 - 25,904 32% Transfers In - - - - - - 0% Total Revenue 41,600 710 12,414 23,068 - 29,186 30% Expenditures Personnel - - - - - - 0% Supplies 44,000 2,167 8,548 5,635 30,735 4,717 89% Services 16,000 700 10,976 11,379 - 5,024 69% Debt Service - - - - - - 0% Capital 81,600 - - - - 81,600 0% Transfers Out - - - - - - 0% Total Expenditures 141,600 2,867 19,524 17,014 30,735 91,341 35% Net (100,000) (2,157) (7,110) 6,054 (30,735) (62,155) Cash Balance 106,120 113,343 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds received from the grants along with impound towing fees. Explain Significant Spending on Capital Projects Below: Form 3 48 Form 3 49 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Month December Fund /Department Number 299 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 75,000 - 59,110 160,829 - 15,890 79% Charges for Services - - - - - - 0% Interest Earnings 1,000 78 978 947 - 22 98% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 7,636 - 7,636 32,793 - - 100% Transfers In - - - - - - 0% Total Revenue 83,636 78 67,724 194,569 - 15,912 81% Expenditures Personnel - - - - - - 0% Supplies 56,499 3,537 38,767 51,637 9,759 7,973 86% Services 45,000 - 27,395 10,455 14,201 3,404 92% Debt Service - - - - - - 0% Capital 65,000 - 41,179 82,658 - 23,821 63% Transfers Out - - - - - - 0% Total Expenditures 166,499 3,537 107,341 144,750 23,960 35,198 79% Net (82,863) (3,459) (39,617) 49,819 (23,960) (19,285) Cash Balance 345,543 385,160 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to receive the Police Department share of money acquired in drug enforcement activity. Expenditures are to be used to fund drug enforcement and training. Explain Significant Spending on Capital Projects Below: The 2014 capital purchase is the purchase of three Police vehicles. Form 3 49 2014 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax Month December Fund /Department Number 404 Date Updated 2/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 8,645,811 720,484 8,645,811 7,846,939 - 0 100% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 75,000 (5,716) 41,371 50,203 - 33,629 55% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 549,376 45,660 521,505 611,914 - 27,871 95% Transfers In - - - - - - 0% Total Revenue 9,270,187 760,428 9,208,686 8,509,057 - 61,501 99% Expenditures Personnel - - - - - - 0% Supplies 1,294,540 61,603 1,069,185 1,189,293 11,872 213,482 84% Services 5,166,602 972,140 4,902,235 4,260,543 247,128 17,239 100% Debt Service 2,245,628 159,304 1,975,244 2,543,535 - 270,384 88% Capital 1,359,015 - 116,275 260,171 890,822 351,917 74% Transfers Out 1,100,000 - 1,100,000 676,882 - - 100% Total Expenditures 11,165,785 1,193,046 9,162,940 8,930,424 1,149,823 853,022 92% Net (1,895,598) (432,618) 45,746 (421,367) (1,149,823) (791,522) Cash Balance 14,935,342 14,905,635 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Significant revenue increase in 2014, due to the City receiving approximately $67,000 more per month in COIT distribution than in the prior year. The 2014 amended budget balance is negative because it includes $220,263 in encumbrances at 12/31/13 for projects that were in process. For 2014, COIT distributions from the County are $720,484.22 per month and are paid through December 31, 2014. The amount shown as Transfers Out of $1,100,000 is for the curb and sidewalk program. This is a significant increase (63 %) from last year as the program has been well received by the citizens of South Bend. The amount is transferred to the MVH fund 202. Explain Significant Spending on Capital Projects Below: This year, $297,500 has been budgeted for IT upgrades such as mobile 311 application and 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. Form 3 50 Form 3 ti. 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax Month December Fund /Department Number 408 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 8,796,821 733,068 8,796,821 8,177,352 - 0 100% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 - 354,660 504,960 - 150,000 70% Interest Earnings 45,000 (4,142) 28,527 33,100 - 16,473 63% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 29,930 - 29,930 69,665 - 0 100% Transfers In - - - - - - 0% Total Revenue 9,376,411 728,927 9,209,937 8,785,077 - 166,474 98% Expenditures Personnel 500,335 34,445 395,867 - - 104,468 79% Supplies - - - - - - 0% Services 2,140,375 116,711 1,925,807 1,595,628 138,487 76,081 96% Debt Service 1,512,173 (108,500) 1,512,101 1,914,214 - 72 100% Capital 275,000 - 185,964 - 4,000 85,036 69% Transfers Out 5,862,101 - 5,862,101 4,417,519 - - 100% Total Expenditures 10,289,984 42,656 9,881,840 7,927,361 142,487 265,657 97% Net (913,573) 686,271 (671,903) 857,717 (142,487) (99,183) Cash Balance 10,159,360 10,842,128 Staffing Full Time 9.00 7.00 Part -Time /Seasonal /Temporary 0.50 0.50 Total 9.50 7.50 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 2014 Budget includes 10 people (9 FT, 1 PT) from Code Enforcement as a result of the 2014 Budget as advertised and a consequential limitation in Fund 600. Encumbrances include $150K to St Joe Cty Chamber of Commerce. Transfers Out include $1.69 million to DCI, $1.87 million to MVH, and $2.3 million to the Building Dept fund for Code Enforcement operations. Explain Significant Spending on Capital Projects Below: $275,000 has been budgeted for the Potawatomi Zoological Society. Form 3 ti. Form 3 N% 2014 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Month December Fund /Department Number 410 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 110 (11) 78 95 - 32 71% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 3,738 - - 0% Transfers In - - - - - - 0% Total Revenue 110 (11) 78 3,833 - 32 71% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 110 (11) 78 3,833 - 32 Cash Balance 27,636 27,587 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. No new payments from the BDC are expected until 2015. Explain Significant Spending on Capital Projects Below: Form 3 N% Form 3 53 2014 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Month December Fund /Department Number 655 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 429,000 36,464 436,317 433,026 - (7,317) 102% Interest Earnings 2,700 (328) 3,076 2,914 - (376) 114% Bond Proceeds - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 36,136 439,394 435,940 - (7,694) 102% Expenditures Personnel 54,578 10,579 29,420 41,354 - 25,158 54% Supplies 8,369 313 7,050 6,081 1,319 84% Services 44,386 2,695 38,883 37,094 - 5,503 88% Debt Service 72,781 72,189 23,238 - 592 99% Capital - - - - - 0% Transfers Out 250,000 250,000 250,000 250,000 - - 100% Total Expenditures 430,114 263,586 397,542 357,767 - 32,572 92% Net 1,586 (227,450) 41,851 78,173 - (40,265) Cash Balance 978,745 938,578 Staffing Full Time - - Part -Time /Seasonal /Temporary 2.16 - - Total 2.16 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund receives revenues as part of the Water Works billing to customers The $250,000 transfer is to the Motor Vehicle Highway fund from where this department's employee salaries are paid. Explain Significant Spending on Capital Projects Below: Form 3 53 Form 3 54 2014 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Month December Fund /Department Number 705 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10 (1) 6 7 - 4 60% Bond Proceeds - - - - - - 0% Donations 1,990 - 2,000 - - (10) 101% Other Income - - - 1 - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 (1) 2,006 8 - (6) 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,000 - - 625 - 2,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,000 - - 625 - 2,000 0% Net - (1) 2,006 (617) - (2,006) Cash Balance 3,315 1,313 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds. Explain Significant Spending on Capital Projects Below: Form 3 54 2014 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service Month December Fund /Department Number 313 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 497,000 225,980 497,768 1,268,179 - (768) 100% Local Income Taxes - - - - - - 0% Other Taxes 67,350 23,004 45,683 67,316 - 21,667 68% Grants /Intergovernmental 85,680 7,140 85,677 71,468 - 3 100% Charges for Services - - - - - - 0% Interest Earnings - (41) (41) - - 41 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 650,030 256,083 629,087 1,406,963 - 20,943 97% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 1,271,300 - 1,271,300 1,268,000 - - 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,271,300 - 1,271,300 1,268,000 - - 100% Net (621,270) 256,083 (642,213) 138,963 - 20,943 Cash Balance 74,046 716,336 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to collect a separate property tax levy (distributions received in June and December) and is used to pay debt service on the former College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will typically have a negative cash balance until the property tax distributions are received. Payments in lieu of taxes (PILOT) from the utilities are received monthly in this fund. Property taxes were received in the amount of $497,768 during 2014. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. The February and July debt service payments have been made for 2014. Explain Significant Spending on Capital Projects Below: None Form 3 ti -7 Form 3 ti7: 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Improv. Month December Fund /Department Number 288 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 2,630,375 285,445 2,711,158 2,950,999 - (80,783) 103% Interest Earnings 14,341 (1,057) 13,284 16,450 - 1,057 93% Bond Proceeds - - - 5,335,537 - - 0% Donations - - - - - - 0% Other Income 28,219 2,331 27,283 20,047 - 936 97% Transfers In - - - - - - 0% Total Revenue 2,672,935 286,719 2,751,725 8,323,033 - (78,790) 103% Expenditures Personnel - - - - - - 0% Supplies 300,000 32,182 197,381 214,277 31,999 70,621 76% Services 416,952 33,458 354,640 252,342 16,237 46,075 89% Debt Service 351,106 (318) 247,497 40,667 1,093 102,516 71% Capital 4,219,241 139,726 3,647,115 6,789,211 149,003 423,123 90% Transfers Out 1,000,000 - 1,000,000 1,000,000 - - 100% Total Expenditures 6,287,299 205,048 5,446,632 8,296,497 198,332 642,335 90% Net (3,614,364) 81,671 (2,694,906) 26,537 (198,332) (721,126) Cash Balance 2,906,216 5,554,585 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Incurring project expenses for construction of Fire Training Facility and Fire Station 5 which will be reimbursed through bond. Operating costs are incurred through the General Fund (101 -0901) and so a transfer of $1,000,000 is processed to cover those expenditures. Explain Significant Spending on Capital Projects Below: Continued construction of Fire Training Facility. Form 3 ti7: 2014 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month December Fund /Department Number 377 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 600,000 - 551,252 597,111 - 48,748 92% Charges for Services - - - - - - 0% Interest Earnings 4,000 (234) 1,618 2,742 - 2,382 40% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 74,228 - 66,710 77,851 - 7,518 90% Transfers In - - - - - - 0% Total Revenue 678,228 (234) 619,580 677,704 - 58,648 91% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 865,746 - 865,545 776,470 - 201 100% Capital - - - - - - 0% Transfers Out - - - 100,000 - - 0% Total Expenditures 865,746 - 865,545 876,470 - 201 100% Net (187,518) (234) (245,965) (198,766) - 58,447 Cash Balance 595,453 842,057 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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 Coveleski Stadium, Century Center, Morris Performing Arts Center and Studebaker National Museum). Coveleski Stadium generates the majority of PSDA revenue. The January and July debt service payments have been made for 2014. The outstanding principal balance on the bonds is $2,915,000 at December 31, 2014. Explain Significant Spending on Capital Projects Below: Form 3 57 Form 3 58 2014 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month December Fund /Department Number 401 Date Updated 1/12/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 (15) 74 92 - 426 15% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 13,526 - 13,526 - - (0) 100% Transfers In - - - - - - 0% Total Revenue 14,026 (15) 13,600 92 - 426 97% Expenditures Personnel - - - - - - 0% Supplies 2,002 - - - - 2,002 0% Services 1,538 - - - - 1,538 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,540 - - - - 3,540 0% Net 10,486 (15) 13,600 92 - (3,114) Cash Balance 40,407 26,850 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund captures capital spending on Coveleski Stadium. Due to recent lease agreements, no significant revenues have been collected for this fund, limiting its budget. Explain Significant Spending on Capital Projects Below: Form 3 58 2014 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Month December Fund /Department Number 403 Date Updated 1/12/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 200 (19) 139 168 - 61 70% Bond Proceeds - - - - - - 0% Donations 2,700 - - 8 - 2,700 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,900 (19) 139 176 - 2,761 5% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 2,900 (19) 139 176 - 2,761 Cash Balance 49,109 49,022 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: Form 3 59 Form 3 60 2014 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Month December Fund /Department Number 405 Date Updated 1/12/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 12,098 1,975 14,679 4,105 - (2,581) 121% Interest Earnings 2,200 (227) 1,083 1,386 - 1,117 49% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 24,597 12,453 24,597 13,405 - 0 100% Transfers In 207,525 96,819 96,819 209,824 - 110,706 47% Total Revenue 246,420 111,020 137,177 228,721 - 109,243 56% Expenditures Personnel - - - - - - 0% Supplies 64,217 - 50,075 104,634 9,273 4,869 92% Services 46,000 23,220 43,829 6,850 660 1,511 97% Debt Service - - - - - - 0% Capital 95,000 - 95,000 36,731 - - 100% Transfers Out - - - - - - 0% Total Expenditures 205,217 23,220 188,904 148,214 9,933 6,380 97% Net 41,203 87,800 (51,727) 80,506 (9,933) 102,863 Cash Balance 520,605 572,891 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Explain Significant Spending on Capital Projects Below: This fund is for expending nonreverting revenue collected from the Zoo, golf courses, East Race Waterway, picnic sites and forestry revenue. Form 3 60 2014 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development Month December Fund /Department Number 406 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 430,000 195,571 430,786 463,331 - (786) 100% Local Income Taxes - - - - - - 0% Other Taxes 87,294 23,149 84,926 85,903 - 2,368 97% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 3,500 (238) 1,820 2,701 - 1,680 52% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 854 212 - (854) 0% Transfers In - - - - - - 0% Total Revenue 520,794 218,482 518,386 552,148 - 2,408 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 504 - - 0% Debt Service 722,935 56,545 722,934 601,614 - 1 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 722,935 56,545 722,934 602,118 - 1 100% Net (202,141) 161,937 (204,548) (49,971) - 2,407 Cash Balance 580,627 785,799 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund receives revenue from a property tax levy, distributions of which 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. For the 2014 budget, this fund will be used to pay existing police capital lease payments but will not include a capital lease for 2014. This payment will be moved to the COIT Fund No. 404 Explain Significant Spending on Capital Projects Below: There is no capital expenditure budgeted for 2014. Form 3 61 2014 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement Month December Fund /Department Number 407 Date Updated 2/5/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 409,000 143,923 417,476 421,457 - (8,476) 102% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 (123) 83 122 - 67 55% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - 25,000 25,000 - - 100% Transfers In - - - - - - 0% Total Revenue 434,150 143,800 442,559 446,578 - (8,409) 102% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 369,800 - 369,800 367,575 - - 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 369,800 - 369,800 367,575 - - 100% Net 64,350 143,800 72,759 79,003 - (8,409) Cash Balance 249,215 176,724 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Revenue in this fund includes $150,000 in hotel /motel taxes and $258,990 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 2014, this fund is used to pay 75% of the 2011 Century Center Refunding bonds as it was in 2013. 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. Explain Significant Spending on Capital Projects Below: None Form 3 62 2014 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction Month December Fund /Department Number 412 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - 0% Interest Earnings 25,000 (1,150) 20,763 26,221 - 4,237 83% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 556,798 - 515,692 474,661 - 41,106 93% Transfers In - - - - - - 0% Total Revenue 581,798 (1,150) 536,455 500,882 - 45,343 92% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 5,823,729 780,315 4,038,690 1,253,680 1,766,060 18,978 100% Transfers Out - - - - - - 0% Total Expenditures 5,823,729 780,315 4,038,690 1,253,680 1,766,060 18,978 100% Net (5,241,931) (781,465) (3,502,235) (752,798) (1,766,060) 26,365 Cash Balance 3,637,756 7,143,898 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. The money was derived from the State lease of the 1 -80 tollroad 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. The amounts outstanding were $886,677 (Fund 435 - Douglas Road) and $4,740,818 (Fund 436 - Eddy Street/Triangle) at 31 December 2014 with payments received each February and August. These revenue streams are scheduled to cease in 2030. Encumbrances are for projects such as the Marion St. Roundabout, Olive - Sample Overpass, and Two -Way Conversion for Main and St. Joseph Streets. Explain Significant Spending on Capital Projects Below: The 2014 Budget includes $5.6 million for the Smart Streets initiative and a prior -year encumbrance of $173,020 for utility relocation on the US 31 project south of town. Of the $1.76 million encumbered as of 31 December, $484,000 is for Lawson Fisher and the Marion St. roundabout design,$238,000 for Jones Petrie Rafinski and the Bartlett St. roundabout design, $224,000 to DLZ for the Olive - Sample overpass, $180,000 to American Structurepoint for 2 -way street conversion activities (Main & Michigan), and $154,000 to CHA for the Corridors projects. Form 3 63 Form 3 64 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Month December Fund /Department Number 416 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 75,000 17,102 79,779 100,535 - (4,779) 106% Interest Earnings 1,725 (198) 1,353 1,412 - 372 78% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 76,725 16,904 81,132 101,947 - (4,407) 106% Expenditures Personnel - - - - - - 0% Supplies 14,700 2,489 9,583 13,632 1,210 3,907 73% Services 38,500 1,724 12,939 11,945 9,038 16,523 57% Debt Service - - - - - - 0% Capital - - - 15,828 - - 0% Transfers Out - - - - - - 0% Total Expenditures 53,200 4,213 22,522 41,405 10,248 20,431 62% Net 23,525 12,691 58,611 60,542 (10,248) (24,838) Cash Balance 514,868 456,810 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: There are no Capital projects budgeted for this year. Form 3 64 2014 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Month December Fund /Department Number 434 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 650,000 - - 244,481 - 650,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,000 24 301 418 - 699 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 651,000 24 301 244,899 - 650,699 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 650,950 (20,975) - 458,949 - 650,950 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 650,950 (20,975) - 458,949 - 650,950 0% Net 50 20,999 301 (214,050) - (251) Cash Balance 9,838 9,537 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: CRIED is derived from State sale taxes generated within the CRED district (within Studebaker /Oliver area) up to a maximum $1 M 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 year to make full debt payment so COIT had to make $415,000 of the payment. Anticipating revenue will again be short in 2014 to make full payments, but possibly 2015 funding will allow us to reimburse COIT at least a portion of its funding. Explain Significant Spending on Capital Projects Below: Form 3 65 Form 3 66 2014 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Month December Fund /Department Number 450 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 10,300 303 9,607 15,346 - 693 93% Interest Earnings 200 (24) 159 215 - 41 79% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,500 279 9,766 15,561 - 734 93% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,000 - - 20,470 - 10,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,000 - - 20,470 - 10,000 0% Net 500 279 9,766 (4,909) - (9,266) Cash Balance 63,093 53,395 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. No capital projects are planned for 2014. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund. Form 3 66 Form 3 67 2014 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Month December Fund /Department Number 677 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 (208) 1,823 2,416 - 677 73% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 42 - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 (208) 1,823 2,458 - 677 73% Expenditures Personnel - - - - - - 0% Supplies 15,000 - 419 3,242 - 14,581 3% Services 173,567 5,019 100,591 59,895 - 72,976 58% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,567 5,019 101,010 63,137 - 87,557 54% Net (186,067) (5,227) (99,187) (60,679) - (86,880) Cash Balance 558,620 658,407 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: No Capital expenditures budgeted for 2014. Form 3 67 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund Month December Fund /Department Number 600 Date Updated 2/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - 1,600 - - (1,600) 0% Charges for Services 1,554,927 182,685 1,388,948 951,275 - 165,979 89% Interest Earnings 1,000 (247) 930 667 - 70 93% Bond Proceeds - - - - - - 0% Donations - 490 7,919 - - (7,919) 0% Other Income 2,050 787 4,428 2,287 - (2,378) 216% Transfers In 2,306,560 - 2,306,560 - - - 100% Total Revenue 3,864,537 183,715 3,710,384 954,228 - 154,153 96% Expenditures Personnel 2,033,761 129,197 1,769,158 863,990 2,160 262,443 87% Supplies 229,944 18,380 150,060 37,678 9,832 70,051 70% Services 1,415,632 141,040 1,190,179 89,926 39,289 186,164 87% Debt Service 21,801 3,176 19,041 14,744 6 2,755 87% Capital 97,771 - - - - 97,771 0% Transfers Out - - - - - - 0% Total Expenditures 3,798,909 291,793 3,128,438 1,006,337 51,287 619,184 84% Net 65,628 (108,078) 581,946 (52,109) (51,287) (465,031) Cash Balance 733,982 151,741 Staffing Full Time 30.00 34.00 - Part -Time /Seasonal /Temporary - 2.00 - Total 30.00 36.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund now comprises the Consolidated Building Department, most of Code Enforcement and Animal Control. Code and Animal Control are managed together but are run separately from the Building Department per Council's wishes. There are 9 additional positions for Code Enforcement that are paid from the EDIT fund (408) as it was not possible to increase the expenditures of this fund to accommodate them as a result of circumstances during the 2014 budget preparation process. The $2.3 million transfer is from the General Fund to cover Code and Animal Control activities which, unlike the Consolidated Building Department, are not enterprises by nature. Explain Significant Spending on Capital Projects Below: Capital includes 5 vehicles for Code Enforcement and 1 for the Building Department. Form 3 68 Form 3 69 2014 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages Month December Fund /Department Number 601 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 918,342 83,983 876,771 841,449 - 41,571 95% Interest Earnings 4,600 (396) 2,787 2,985 - 1,813 61% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 264,408 5,645 141,559 127,164 - 122,849 54% Transfers In - - - - - - 0% Total Revenue 1,187,350 89,232 1,021,117 971,598 - 166,233 86% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 676,679 48,051 603,342 601,634 8,131 65,206 90% Debt Service - - - - - - 0% Capital 921,129 136,237 228,334 341,221 184,854 507,941 45% Transfers Out - - - - - - 0% Total Expenditures 1,597,808 184,288 831,676 942,855 192,985 573,147 64% Net (410,458) (95,056) 189,441 28,743 (192,985) (406,914) Cash Balance 1,072,477 884,188 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 2014 projects currently include: elevator repairs; painting; and storm water drain repairs. Operations under outside contract with Downtown South Bend, Inc. so all expenses except capital are shown under Services line to show consistently with Redevelopment Retail and Blackthorn Golf Course. Explain Significant Spending on Capital Projects Below: Form 3 69 Form 3 70 2014 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations Month December Fund /Department Number 610 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 4,931,830 408,296 4,936,737 4,866,862 - (4,907) 100% Interest Earnings 6,000 (165) 1,530 2,996 - 4,470 26% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 446,893 61,638 358,971 538,087 - 87,922 80% Transfers In - - - - - - 0% Total Revenue 5,384,723 469,769 5,297,239 5,407,945 - 87,484 98% Expenditures Personnel 1,660,204 119,256 1,632,101 1,665,175 - 28,103 98% Supplies 444,995 21,598 431,025 411,584 199 13,771 97% Services 2,913,262 203,856 2,828,161 2,897,069 1,756 83,345 97% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 836,002 - 789,916 830,239 - 46,086 94% Total Expenditures 5,854,463 344,709 5,681,203 5,804,066 1,955 171,304 97% Net (469,740) 125,060 (383,964) (396,121) (1,955) (83,820) Cash Balance 405,863 795,275 Staffing Full Time 24.20 20.20 21.20 Part -Time /Seasonal /Temporary 9.00 8.00 9.00 Total 33.20 28.20 30.20 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This 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. Only a small percentage of the total operating budget was unspent at year end. Explain Significant Spending on Capital Projects Below: Form 3 70 2014 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Month December Fund /Department Number 611 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 200 (15) 149 469 - 51 74% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 836,002 - 789,916 830,239 46,086 94% Total Revenue 836,202 (15) 790,065 830,707 - 46,137 94% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 737,202 10,902 702,124 649,404 - 35,078 95% Capital 258,868 - 171,182 62,972 87,686 66% Transfers Out - - - - - - 0% Total Expenditures 996,070 10,902 873,306 712,375 - 122,765 88% Net (159,868) (10,917) (83,241) 118,332 - (76,627) Cash Balance 35,162 118,441 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: Year to date capital spending has been for retrofitting trash trucks with on -board RFID tag reader computer systems. Form 3 71 Form 3 rP: 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations Month December Fund /Department Number 620 Date Updated 2.3.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 14,765,453 1,073,756 14,385,342 14,981,858 - 380,111 97% Interest Earnings 11,000 (1,717) 8,523 6,453 - 2,477 77% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 161,825 4,208 137,714 107,421 - 24,111 85% Transfers In 19,500 992 14,611 13,891 - 4,889 75% Total Revenue 14,957,778 1,077,240 14,546,190 15,109,623 - 411,588 97% Expenditures Personnel 4,414,374 325,735 4,275,706 4,107,455 - 138,668 97% Supplies 1,579,690 128,632 1,293,283 965,196 38,929 247,478 84% Services 4,862,481 314,601 4,241,123 4,246,085 197,300 424,058 91% Debt Service 7,985 1,046 5,790 2,592 - 2,195 73% Capital - - - - - - 0% Transfers Out 3,977,474 344,514 3,944,462 4,052,958 - 33,012 99% Total Expenditures 14,842,004 1,114,528 13,760,364 13,374,286 236,229 845,411 94% Net 115,774 (37,288) 785,826 1,735,337 (236,229) (433,823) Cash Balance 4,298,441 3,509,756 Staffing Full Time 70.20 67.20 Part -Time /Seasonal /Temporary 3.00 3.00 Total 73.20 70.20 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Annual service revenues are 4% less compared to 2013. In 2014, water production was down by 243 million gallons. Usage of supplies was greater throughout the year mostly due to a higher number of water main leaks and purchased water meters. Explain Significant Spending on Capital Projects Below: Form 3 rP: Form 3 73 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Month December Fund /Department Number 622 Date Updated 2.3.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 12,500 (1,189) 10,132 13,709 - 2,368 81% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 12,500 (1,189) 10,132 13,709 - 2,368 81% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,600 - 3,600 22,450 - - 100% Debt Service - - - - - - 0% Capital 974,658 29,749 412,976 604,851 85,892 475,790 51% Transfers Out - - - - - - 0% Total Expenditures 978,258 29,749 416,576 627,301 85,892 475,790 51% Net (965,758) (30,938) (406,444) (613,592) (85,892) (473,422) Cash Balance 3,135,399 3,531,725 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used for acquiring, constructing, and improving fixed assets. Explain Significant Spending on Capital Projects Below: North Station Roof Restoration $332,801, Hybrid Vehicle $23,769, SCADA Hardware /Software $42,965, Meter Reading Laptop /Software $13,441 Rollover Encumbrance: North Station Roof Restoration $3,048 Trucks (2) $67,463 Chlorine Auto Emergency Shut Off Device $15,382 Form 3 73 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Month December Fund /Department Number 623 Date Updated 2.3.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 (72) 1,614 16,550 3,386 32% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 (72) 1,614 16,550 - 3,386 32% Expenditures Personnel - - 0% Supplies 287,297 19,960 214,892 2,262,254 50,914 21,491 93% Services 81,089 - 42,103 115,609 2,171 36,815 55% Debt Service - - - - - - 0% Capital 442,625 - 374,711 2,628,894 - 67,914 85% Transfers Out - - - - - 0% Total Expenditures 811,011 19,960 631,706 5,006,757 53,085 126,220 84% Net (806,011) (20,032) (630,092) (4,990,207) (53,085) (122,834) Cash Balance 202,281 812,630 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 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. Annual interest earnings in 2014 are due to a lower cash balance. Intended use of remaining cash will go towards current encumbrance, Pinhook Project's final construction pay application and a potentially small final meter order. Explain Significant Spending on Capital Projects Below: Pinhook WT Efficiency Improv Project $433,080 Rollover Encumbrance: Boland Park PRV $18,760 Water Meters $50,914 Boland Park PRV Proj $2,171 Form 3 74 Form 3 VAA 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Month December Fund /Department Number 624 Date Updated 2.3.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 (564) 4,142 4,861 - 1,858 69% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 40 - 40 - - - 100% Total Revenue 6,040 (564) 4,182 4,861 - 1,858 69% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 291 4,997 4,901 - 1,003 83% Total Expenditures 6,000 291 4,997 4,901 - 1,003 83% Net 40 (855) (815) (40) - 855 Cash Balance 1,478,773 1,452,815 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: Form 3 VAA Form 3 W", 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Month December Fund /Department Number 625 Date Updated 2.3.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 288 2,533 2,064 - 2,467 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 2,052,224 170,810 2,049,720 2,053,940 - 2,504 100% Total Revenue 2,057,224 171,098 2,052,253 2,056,004 - 4,971 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 2,052,224 1,665,779 2,050,399 2,053,240 - 1,825 100% Capital - - - - - 0% Transfers Out 5,000 291 2,535 2,064 - 21465 51% Total Expenditures 2,057,224 1,666,070 2,052,934 2,055,303 - 4,290 100% Net - (1,494,972) (681) 700 - 681 Cash Balance 4,650 5,337 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. All debt obligations were met in 2014. Explain Significant Spending on Capital Projects Below: Form 3 W", Form 3 77 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Month December Fund /Department Number 626 Date Updated 2.3.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,500 (614) 4,459 4,767 1,041 81% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - 0% Transfers In 84,573 - 76,542 249,221 - 8,031 91% Total Revenue 90,073 (614) 81,001 253,988 - 9,072 90% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 90,073 (614) 81,001 253,988 Cash Balance 1,644,945 1,565,676 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. All maximum reserve requirement amounts have been fully satisfied as of December 31, 2014. Explain Significant Spending on Capital Projects Below: Form 3 77 Form 3 78 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Month December Fund /Department Number 629 Date Updated 2.3.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 8,500 (792) 5,875 6,927 - 2,625 69% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 61,812 - 53,507 45,301 - 8,305 87% Total Revenue 70,312 (792) 59,382 52,228 - 10,930 84% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 411 7,079 6,927 - 1,421 83% Total Expenditures 8,500 411 7,079 6,927 - 1,421 83% Net 61,812 (1,203) 52,303 45,301 - 9,509 Cash Balance 2,081,600 2,031,532 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to hold cash reserves to serve as fiscal protection against the risk of revenue shortfalls, emergencies and other economic risks that may impact the Water Utility's ability to meet financial commitments. Additional money was transferred in during the month of February to satisfy 100% of the 2014 requirement. Explain Significant Spending on Capital Projects Below: Form 3 78 Form 3 79 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Month December Fund /Department Number 640 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 573,570 49,302 585,858 548,665 - (12,288) 102% Interest Earnings 4,700 (576) 4,037 4,204 - 663 86% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 578,270 48,726 589,894 552,869 - (11,624) 102% Expenditures Personnel 180,687 13,630 166,773 112,255 13,914 92% Supplies 18,115 364 13,173 15,876 4,942 73% Services 322,218 25,553 233,052 194,458 89,166 72% Debt Service 28,958 28,436 28,436 522 98% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 549,978 39,546 441,433 351,024 - 108,545 80% Net 28,292 9,181 148,461 201,845 - (120,169) Cash Balance 1,505,378 1,363,696 Staffing Full Time 2.10 2.10 - Part -Time /Seasonal /Temporary - - - Total 2.10 2.10 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Increase in salaries due to new allocation of portion of Sewer Manager and Sewer Concrete Job Leader salaries. Explain Significant Spending on Capital Projects Below: Form 3 79 Form 3 80 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations Month December Fund /Department Number 641 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,863,785 2,744,752 33,317,015 31,675,219 - 1,546,770 96% Interest Earnings 18,000 (3,599) 15,306 16,604 - 2,694 85% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 117,192 22,837 123,481 77,462 - (6,289) 105% Transfers In 15,000 674 - 15,258 - 15,000 0% Total Revenue 35,013,977 2,764,664 33,455,803 31,784,543 - 1,558,174 96% Expenditures Personnel 6,776,379 512,997 6,514,307 6,272,283 262,072 96% Supplies 2,419,100 85,984 1,478,907 1,770,501 169,910 770,283 68% Services 12,452,029 784,894 9,857,782 10,843,192 1,083,875 1,510,372 88% Debt Service 359,746 765 331,934 274,506 27,812 92% Capital - - - - - 0% Transfers Out 13,548,940 773,536 13,427,609 9,667,884 121,331 99% Total Expenditures 35,556,194 2,158,176 31,610,541 28,828,365 1,253,785 2,691,869 92% Net (542,217) 606,489 1,845,262 2,956,178 (1,253,785) (1,133,694) Cash Balance 8,982,959 7,286,003 Staffing Full Time 95.04 93.04 Part -Time /Seasonal /Temporary 7.00 7.00 Total 102.04 100.04 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Service revenue is running slightly below budget estimates as the approved rate increase was below the estimated amount. All expenditure categories are running at or below budget estimates. Debt service payments are made in accordance with City amortization schedules. Transfers out are done as needed to fund capital purchases in Fund 642 and to fund scheduled debt service payments. Explain Significant Spending on Capital Projects Below: Capital spending for Sewage works is shown in Fund 642. Form 3 80 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Month December Fund /Department Number 642 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 39,000 (1,352) 15,111 26,316 - 23,889 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 168,094 - - 0% Transfers In 4,000,000 - 4,000,000 - - - 100% Total Revenue 4,039,000 (1,352) 4,015,111 194,410 - 23,889 99% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 133,264 10,875 97,221 201,936 36,043 0 100% Debt Service - - - - - - 0% Capital 9,302,771 318,981 4,210,735 4,811,017 3,676,666 1,415,370 85% Transfers Out - - - - - - 0% Total Expenditures 9,436,035 329,856 4,307,956 5,012,953 3,712,709 1,415,370 85% Net (5,397,035) (331,208) (292,844) (4,818,543) (3,712,709) (1,391,482) Cash Balance 3,747,697 4,044,566 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used to purchase capital equipment and fund major renovations /restorations for the Wastewater and Sewer Departments. The primary source of income is from Sewage Works Operating Fund #641, which transfers funds here as needed. Projects budgeted this year include Sewer Relining and Manhole Rehab. work throughout the City, replacing the Eastgate area Lift Station, and rebuilding /replacing the dewatering presses at the Wastewater Plant. Explain Significant Spending on Capital Projects Below: Year to Date totals include WWTP Primary Clarifier rehab $1,566,878, Sage /Poppy Rd Lift Station $289,919, Ferric Chloride Feed Facility $427,307; Sewer Dept. tandem axle dump trucks $323,802, Jet Rodder /Vacuum machine $309,680, Street Sweeper $207,000; Manhole Rehab. work $131,735, Sewer lining work $633,524, CNG station upgrade $90,000, Wastewater tri -axle roll -off truck $171,693. Form 3 1.1 Form 3 82 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Month December Fund /Department Number 643 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 (1,301) 9,662 11,036 - 5,338 64% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 223,715 - 129,964 200,296 - 93,751 58% Total Revenue 238,715 (1,301) 139,626 211,332 - 99,089 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 674 11,637 11,036 - 3,363 78% Total Expenditures 15,000 674 11,637 11,036 - 3,363 78% Net 223,715 (1,975) 127,989 200,296 - 95,726 Cash Balance 3,416,919 3,292,600 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The sole purpose of this fund is to hold the equivalent of two months of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. Any transfers to this fund are done to adjust the balance as needed to stay in compliance. Explain Significant Spending on Capital Projects Below: Form 3 82 Form 3 83 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Month December Fund /Department Number 647 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - 3 42 (3) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - 3 42 - (3) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,143 - 1,143 17,942 - (0) 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,143 - 1,143 17,942 - (0)1 100% Net (1,143) - (1,141) (17,900) Cash Balance 0 1,141 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Bond, issued in 2007, is now fully spent. Explain Significant Spending on Capital Projects Below: Form 3 83 Form 3 84 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Month December Fund /Department Number 649 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 11,500 798 12,106 10,232 - (606) 105% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,797,645 773,536 9,297,645 9,453,493 - 500,000 95% Total Revenue 9,809,145 774,334 9,309,752 9,463,724 - 499,393 95% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,200 - 3,200 2,300 - - 100% Debt Service 9,799,031 1,977,890 9,299,022 9,514,663 - 500,009 95% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,802,231 1,977,890 9,302,222 9,516,963 - 500,009 95% Net 6,914 (1,203,556) 7,530 (53,239) - (616) Cash Balance 789,489 782,807 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to pay all debt service obligations for Wastewater and Sewers (Sewage Works). Mandatory transfers in from Operating Fund 641 are done in specified amounts each month to satisfy bond covenants. Explain Significant Spending on Capital Projects Below: Form 3 84 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Month December Fund /Department Number 653 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 3 3 3 - (3) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 14,096 - - 0% Total Revenue - 3 3 14,099 - (3) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - 2,434,563 - - 0% Capital - - - - - - 0% Transfers Out - - - 3,524 - - 0% Total Expenditures - - - 2,438,087 - - 0% Net - 3 3 (2,423,989) - (3) Cash Balance 1 7,286,832 7,286,828 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Debt Reserve fund is held in a separate account with Bank of NY Mellon Trust. A reconcilliation of that account is done monthly. The account was fully funded for existing debt in 2013. Explain Significant Spending on Capital Projects Below: Form 3 85 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Month December Fund /Department Number 658 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 0 6 216 - (6) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 0 6 216 - (6) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 925 - 924 110,204 - 1 100% Debt Service - - - - - - 0% Capital 1,296 - 1,296 - 1 100% Transfers Out - - - - - - 0% Total Expenditures 2,221 - 2,220 110,204 - 1 100% Net (2,221) 0 (2,213) (109,988) - (8) Cash Balance 2 2,215 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This 2010 bond has been fully spent, except for a very small ($2.05) allocation of interest earned. Explain Significant Spending on Capital Projects Below: Form 3 86 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 Month December Fund /Department Number 659 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 25,000 (438) 19,665 30,970 - 5,335 79% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 (438) 19,665 30,970 - 5,335 79% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 705,491 6,631 11,008 261,589 17,670 676,814 4% Debt Service - - - - - - 0% Capital 12,892,995 543,607 6,257,771 2,087,392 1,688,168 4,947,056 62% Transfers Out - - - - - - 0% Total Expenditures 13,598,486 550,237 6,268,779 2,348,981 1,705,838 5,623,870 59% Net (13,573,486) (550,675) (6,249,113) (2,318,011) (1,705,838) (5,618,535) Cash Balance 1,597,670 7,848,499 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: From issue late in 2011, this bond has funded numerous projects including Diamond Ave. Trunk Sewer, Phase II $3.7 million, East Bank Sewer Separation, Phase II $2.8 million, East Bank Sewer Separation, Phase III $2.3 million, LaSalle School area Sewer Separation, $1.7 million, East Bank Sewer Separation, Phase III $545,000, Southwood Sewer Separation, $1,143,059, Diamond Ave. Trunk Sewer, Phase III $248,000, St. Joseph River CSO Stabilization $217,831, Secondary Clarifier Upgrade $154,068, and Wastewater Treatment Plant Digester Upgrade $5,307,632. Form 3 87 Form 3 88 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Month December Fund /Department Number 661 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 65,000 (6,277) 51,261 65,016 - 13,739 79% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 65,000 (6,277) 51,261 65,016 - 13,739 79% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,870,000 2 497 104,981 - 4,869,503 0% Debt Service - - - - - - 0% Capital 13,998,570 558,851 1,530,525 4,907,896 1,624,275 10,843,770 23% Transfers Out - - - - - - 0% Total Expenditures 18,868,570 558,854 1,531,023 5,012,877 1,624,275 15,713,272 17% Net (18,803,570) (565,130) (1,479,762) (4,947,861) (1,624,275) (15,699,533) Cash Balance 16,801,222 18,299,027 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Projects funded from this Bond in 2013 and 2014 year -to -date include: East Bank Sewer Separation -Phase 4 $2.6 million, Diamond Ave. Sewer Separation -Phase 3, $2.6 million, Prairie Avenue Sewer Separation $396,810, and Southwood Sewer Separation $898,773. Form 3 88 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2013 Month December Fund /Department Number 663 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - - - - Cash Balance - - Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: A budget was set up in this fund in anticipation of the issuance of a Sewer Bond in 2013. However, a bond was not issued, therefore no activity is expected in this fund. Explain Significant Spending on Capital Projects Below: Form 3 89 Form 3 1!I0: 2014 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund Month December Fund /Department Number 664 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - (2) 13 7 - (13) 0% Bond Proceeds - - - 85,740 - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - (2) 13 85,747 - (13) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - 81,279 - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 81,279 - - 0% Net - (2) 13 4,468 - (13) Cash Balance 4,476 4,468 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: Form 3 1!I0: 2014 City of South Bend Monthly Financial Report Fund /Department Name 2014 Sewer Bond Month December Fund /Department Number 665 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - - - - Cash Balance - - Staffing Full Time - - Part-Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up in anticipation of a possible Sewer Bond issue in the last quarter of 2014. That did not happen, so there was no activity in the fund. Explain Significant Spending on Capital Projects Below: Form 3 Wi Form 3 1% 2014 City of South Bend Monthly Financial Report Fund /Department Name Century Center Month December Fund /Department Number 670 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,313,450 - 1,313,450 1,313,436 - - 100% Grants /Intergovernmental - - - - - - 0% Charges for Services 3,714,678 398,620 2,725,660 1,728,939 - 989,018 73% Interest Earnings - - - 3,079 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 50,000 2,273 48,593 88,361 - 1,407 97% Transfers In - - - - - - 0% Total Revenue 5,078,128 400,893 4,087,703 3,133,815 - 990,425 80% Expenditures Personnel 2,356,075 225,081 2,132,960 1,835,145 - 223,115 91% Supplies 504,952 38,082 501,471 281,676 - 3,481 99% Services 1,288,842 88,213 1,184,489 1,022,801 - 104,353 92% Debt Service - - - - - - 0% Capital 415,029 - - 222,976 - 415,029 0% Transfers Out - - - - - - 0% Total Expenditures 4,564,898 351,376 3,818,921 3,362,598 - 745,977 84% Net 513,230 49,517 268,782 (228,783) - 244,448 Cash Balance 892,876 887,475 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Some expenses are covered by hotel /motel tax revenue which is received twice per year. The second installment was received in July 2014. Other income includes charges to large conferences for electric costs. Explain Significant Spending on Capital Projects Below: Form 3 1% 2014 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Month December Fund /Department Number 671 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - 100,000 - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 24 328 315 - 172 66% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 575,000 - - 0% Transfers In - - - - - - 0% Total Revenue 500 24 328 675,315 - 172 66% Expenditures Personnel - - - - - - 0% Supplies 54,184 - - 114,242 - 54,184 0% Services - - - 10,965 - - 0% Debt Service - - - - - - 0% Capital 339,363 - 339,363 67,288 - - 100% Transfers Out - - - - - - 0% Total Expenditures 393,547 - 339,363 192,495 - 54,184 86% Net (393,047) 24 (339,035) 482,820 - (54,012) Cash Balance 1,418,663 1,757,697 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Century Center Board of Managers has not approved a 2014 capital budget in this fund. An appropriation to cover the cost of the new freight elevator originally paid out of Fund 670 was approved in July 2014. A transfer was done in August to move the cost from Fund 670 to Fund 671. SMG contributed a one time amount of $575,000 to cover capital expenses in August 2013. Explain Significant Spending on Capital Projects Below: New Freight Elevator installed in 2014. Form 3 1*x1 2014 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month December Fund /Department Number 222 Date Updated 1/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 7,972,860 572,565 6,943,879 7,127,623 - 1,028,981 87% Interest Earnings 4,500 (646) 3,062 3,421 - 1,438 68% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 136,824 (15,242) 117,195 123,832 - 19,629 86% Transfers In - - - - - - 0% Total Revenue 8,114,184 556,677 7,064,135 7,254,876 - 1,050,049 87% Expenditures Personnel 2,828,264 195,338 2,579,464 2,487,010 - 248,800 91% Supplies 177,649 26,325 145,522 232,825 6,225 25,903 85% Services 4,852,122 364,485 4,270,903 4,510,076 41,221 539,998 89% Debt Service 6,497 6,495 6,285 2 100% Capital 172,000 32,262 70,190 120,000 19,738 89% Transfers Out - - - - - - 0% Total Expenditures 8,036,532 586,149 7,034,645 7,306,386 167,446 834,441 90% Net 77,652 (29,471) 29,490 (51,510) (167,446)1- 215,608 Cash Balance 1,536,912 1,465,707 Staffing Full Time 42.00 39.00 39.00 Part -Time /Seasonal /Temporary 2.00 1.00 1.00 Total 44.00 40.00 40.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Central Services Division consists of six cost centers that provide a variety of services to other city departments, along with several local county, state and federal agencies. On the Revenue side we received checks for $39,980 from Energizing Indiana. On the expense side,the services acct is at 100% because we encumbered the rental costs on the Printshop equipment for the year, monies were also encumbered for the utilities. The supply acct. goes up and down, depending on vehicle repairs. In Dec we had 1,349 repairs. Year to Date repairs are 15,877. Average Fuel prices for the year is $2.82 for Unleaded and $3.19 for Diesel. Budgeted amount per gallon is $3.45. . Explain Significant Spending on Capital Projects Below: We amended our budget to add the following Capital Projects: Upgrade the Sample St Garage to meet the requirements for Compressed Natural Gas vehicle repairs. Purchase of two in- ground hoists for the Sample St Garage. The purchase of a vehicle diagnostic scanner tool. Radio tower inspection repairs throughout the City. $262,000. Form 3 1*21 Form 3 147 2014 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance Month December Fund /Department Number 226 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 2,904,336 241,463 2,859,719 2,988,576 - 44,617 98% Interest Earnings 22,000 (2,169) 14,433 18,597 - 7,567 66% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 179,063 40 162,063 2,674 - 17,000 91% Transfers In - - - - - - 0% Total Revenue 3,105,399 239,334 3,036,215 3,009,847 - 69,184 98% Expenditures Personnel 187,417 14,325 179,508 165,254 - 7,909 96% Supplies 23,143 2,438 17,192 14,343 - 5,951 74% Services 2,676,640 357,583 2,341,383 2,866,171 669 334,588 87% Debt Service - - - - - - 0% Capital 10,000 - 3,555 23,994 - 6,445 36% Transfers Out - - - - - - 0% Total Expenditures 2,897,200 374,346 2,541,638 3,069,761 669 354,893 88% Net 208,199 (135,011) 494,577 (59,915) (669) (285,709) Cash Balance 5,673,981 5,185,497 Staffing Full Time 3.00 3.00 Part -Time /Seasonal /Temporary - - Total 3.00 3.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund handles operations relating to business insurance and claims: property, liability, workers compensation, etc. and the operation of the safety and risk department. We finished the year within budget. Explain Significant Spending on Capital Projects Below: Form 3 147 Form 3 Xt, 2014 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Month December Fund /Department Number 278 Date Updated 1/8/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 60,580 4,720 61,170 61,720 - (590) 101% Interest Earnings 2,000 (199) 1,407 1,435 - 593 70% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,580 4,720 61,063 61,693 - (483) 101% Transfers In - - - - - - 0% Total Revenue 123,160 9,241 123,640 124,848 - (480) 100% Expenditures Personnel - - - - - - 0% Supplies 60,580 - 60,580 63,700 - - 100% Services 20,000 - - - - 20,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 80,580 - 60,580 63,700 - 20,000 75% Net 42,580 9,241 63,060 61,148 - (20,480) Cash Balance 515,459 452,953 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund charges police officers for liability insurance and gasoline costs for take home police vehicles. No expenditures for vehicle claims have been paid so far in 2014.The cash reserves in this fund have been increasing in recent years and are expected to increase during 2014. 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. Explain Significant Spending on Capital Projects Below: None Form 3 Xt, Form 3 IM 2014 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits Month December Fund /Department Number 711 Date Updated 1/30/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 13,692,308 1,086,338 12,895,536 11,920,784 - 796,772 94% Interest Earnings 32,000 (1,441) 15,785 25,351 - 16,215 49% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 373,300 77,390 407,656 210,513 - (34,356) 109% Transfers In - - - - - - 0% Total Revenue 14,097,608 1,162,287 13,318,976 12,156,648 - 778,632 94% Expenditures Personnel - - - - - - 0% Supplies 38,675 2,481 38,634 11,865 - 41 100% Services 712,909 60,416 635,792 565,482 5,000 72,117 90% Insurance 15,180,053 1,347,333 14,249,010 13,346,045 - 931,043 94% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 15,931,637 1,410,230 14,923,436 13,923,392 5,000 1,003,201 94% Net (1,834,029) (247,943) (1,604,460) (1,766,744) (5,000) (224,569) Cash Balance 4,052,663 5,661,447 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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 should help. We are also working with our insurance advisor on some other options. Explain Significant Spending on Capital Projects Below: None Form 3 IM Form 3 1*x1 2014 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Month December Fund /Department Number 713 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 102,364 8,530 102,364 252,383 - (0) 100% Interest Earnings 850 (94) 683 524 - 167 80% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 103,214 8,436 103,047 252,907 - 167 100% Expenditures Personnel 220,750 639 114,682 61,159 - 106,068 52% Supplies - - - - - - 0% Services 7,224 602 7,224 4,284 - 0 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 227,974 1,241 121,906 65,443 - 106,068 53% Net (124,760) 7,195 (18,859) 187,464 - (105,901) Cash Balance 240,912 260,030 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund charges an allocation of 0.5% of payroll to most departments to cover the cost of unemployment claims paid. For the 2014 budget, the rate charged to departments has been reduced to 0.25% due to favorable claims history and increasing cash reserves. Budgeted charges for services were adjusted in July 2014 to reflect the change in charges to the departments. The Unemployment Compensation Fund is classified as an Internal Service Fund for financial reporting. Claims continue to be lower than anticipated. Explain Significant Spending on Capital Projects Below: None Form 3 1*x1 Form 3 1*111 2014 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension Month December Fund /Department Number 701 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,386,832 - 5,129,098 5,035,292 - 257,734 95% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,500 (88) 1,321 2,918 - 3,179 29% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 1,484 1,484 - - (1,484) 0% Transfers In - - - - - - 0% Total Revenue 5,391,332 1,396 5,131,903 5,038,211 - 259,429 95% Expenditures Personnel 5,869,495 435,964 5,429,859 5,446,594 - 439,636 93% Supplies 200 - - - - 200 0% Services 4,750 84 840 1,380 - 3,910 18% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,874,445 436,047 5,430,699 5,447,975 - 443,746 92% Net (483,113) (434,652) (298,796) (409,764) - (184,317) Cash Balance 638,442 938,100 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: No capital expenditures are purchased through this account. Form 3 1*111 Form 3 `[1111 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Pension Month December Fund /Department Number 702 Date Updated 1/2/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 6,300,000 - 6,111,865 5,863,697 - 188,135 97% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - 881 - - 0% Interest Earnings 6,000 (231) 2,666 5,432 - 3,334 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,500 137 4,259 4,854 - 241 95% Transfers In - - - - - - 0% Total Revenue 6,310,500 (94) 6,118,791 5,874,865 - 191,709 97% Expenditures Personnel 7,216,441 542,380 6,715,611 6,472,309 - 500,830 93% Supplies 1,100 22 173 642 - 927 16% Services 4,400 101 892 1,884 - 3,508 20% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 7,221,941 542,504 6,716,677 6,474,834 - 505,264 93% Net (911,441) (542,598) (597,886) (599,969) - (313,555) Cash Balance 1,109,579 1,708,656 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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 2014, the payments are expected to be $3,055,933 by 1 July and again by 1 October, totaling $6,111,865. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Form 3 `[1111 2014 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Month December Fund /Department Number 730 Date Updated 1/12/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 250 (11) 101 138 - 149 41% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 250 (11) 101 138 - 149 41% Expenditures Personnel - - - - - - 0% Supplies - - - 4,316 - - 0% Services 10,595 - 8,658 - 1,937 82% Debt Service - - - - - - 0% Capital 10,000 - - - - 10,000 0% Transfers Out - - - - - - 0% Total Expenditures 20,595 - 8,658 4,316 - 11,937 42% Net (20,345) (11) (8,556) (4,178) - (11,789) Cash Balance 28,347 36,934 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: Spending this year will concentrate on repairing headstones and completing the GIS survey of the cemetery and its occupants. Form 3 word 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF Revenue - Airport Month December Fund /Department Number 324 1 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 14,284,735 6,763,722 14,284,734 13,340,354 - 1 100% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 115,612 (13,014) 67,124 61,707 - 48,488 58% Bond Proceeds 101,267 - 101,267 - - - 100% Donations - - - - - - 0% Other Income 132,260 1,763 120,857 2,345,072 - 11,403 91% Transfers In 5,000 205 3,548 279,530 - 1,452 71% Total Revenue 14,638,874 6,752,676 14,577,530 16,026,663 - 61,344 100% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 8,250,437 368,994 4,480,510 1,345,228 1,833,972 1,935,955 77% Debt Service 3,526,658 477,475 3,451,956 3,372,027 - 74,702 98% Capital 15,509,598 138,168 285,293 4,510,651 27,410 15,196,895 2% Transfers Out - - - - - - 0% Total Expenditures 27,286,693 984,637 8,217,759 9,227,906 1,861,382 17,207,552 37% Net (12,647,819) 5,768,039 6,359,771 6,798,757 (1,861,382) (17,146,208) Cash Balance 31,359,224 25,020,129 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 2013 Revenue from one time payment from AJ Wright of $2 M received in April along with Blackthorn debt service paid off in 2013 and reserve amount returned to this fund. 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. Major projects carried out in 2013 were: Ignition Park Infrastructure; Data Realty; the SB Animal Shelter reconstruction; continued acquisition in Ignition Park South and East; purchase of Scientific Equipment in Ignition Park; acquisition in the LaSalle Square Area; the Renaissance District Phase I and the beginnings of Phase II; the beginnings of expenditures on the Studebaker /Oliver Project; and Bosch holding costs. In 2014, the major projects thus far approved are: Continuation of projects approved for 2013; and the addition of the Kolata contract. Explain Significant Spending on Capital Projects Below: Capital projects thus far this year are: Renaissance District Phase II; major expenditures in the Certified Tech Park; the Studebaker /Oliver project; and continued Ignition Park South & East acquisitions. Form 3 102 Form 3 103 2014 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown Month December Fund /Department Number 420 1 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 4,309,727 1,824,461 4,309,727 2,590,808 - - 100% Local Income Taxes - - - - - - 0% Other Taxes 401,000 - 400,000 398,500 - 1,000 100% Grants /Intergovernmental - - - - - - 0% Charges for Services 43,700 2,922 37,703 34,021 - 5,997 86% Interest Earnings 49,645 3,241 40,168 59,682 - 9,477 81% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 304,706 44,739 291,831 375,095 - 12,875 96% Transfers In 6,000 342 5,929 5,959 - 71 99% Total Revenue 5,114,778 1,875,705 5,085,358 3,464,065 - 29,420 99% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 165,092 40,466 95,425 467,427 49,121 20,546 88% Debt Service 3,420,577 108,500 3,386,382 2,880,921 - 34,195 99% Capital 2,243,592 103,911 119,551 349,125 143,845 1,980,196 12% Transfers Out - - - - - - 0% Total Expenditures 5,829,261 252,877 3,601,358 3,697,473 192,966 2,034,937 65% Net (714,483) 1,622,828 1,484,000 (233,408) (192,966) (2,005,517) Cash Balance 4,092,219 2,604,474 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF funds are used to fund projects which vary widely from year to year, so no real trend is expected from one year to the next. Explain Significant Spending on Capital Projects Below: Capital projectes committed to in 2014 include: Finishing Century Center West Entrance; Studebaker Plaza; Hill & Colfax Mixed Use Development; and Lasalle Hotel. Capital projects taken on in 2013 were:Century Center West Entrance; Studebaker Plaza; and Wayne Street Garage Facade improvements. Form 3 103 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Month December Fund /Department Number 422 1 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 580,988 276,835 580,987 493,608 - 1 100% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 (509) 1,812 1,435 - 688 72% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 583,488 276,326 582,799 495,043 - 689 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 30,921 - 12 2,308 30,600 309 99% Debt Service - - - - - - 0% Capital 626,613 - - 331,502 8,300 618,313 1% Transfers Out - - - - - - 0% Total Expenditures 657,534 - 12 333,810 38,900 618,622 6% Net (74,046) 276,326 582,787 161,233 (38,900) (617,933) Cash Balance 1,194,467 612,962 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year so little can be gained by comparing expenditures from year to year. Major projects for 2013 were: Completion of Rushton Square and William Streetscape. Major Projects committed thus far in 2014 are: Completion of Rushton Square. Explain Significant Spending on Capital Projects Below: Major projects committed thus far in 2014 are: Completion of Rushton Square. Form 3 104 Form 3 11111 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Month December Fund /Department Number 425 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 3,150 (34) 254 300 - 2,896 8% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 191,135 9,942 164,895 158,989 - 26,240 86% Transfers In - - - - - - 0% Total Revenue 194,285 9,908 165,149 159,289 - 29,136 85% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 128,373 4,910 106,267 115,308 - 22,106 83% Debt Service - - - - - - 0% Capital 21,052 - 19,423 6,309 - 1,629 92% Transfers Out - - - - - - 0% Total Expenditures 149,425 4,910 125,690 121,617 - 23,735 84% Net 44,860 4,998 39,459 37,672 - 5,401 Cash Balance 172,431 133,067 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: Form 3 11111 Form 3 `[IN 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Month December Fund /Department Number 426 1 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 851,211 391,552 851,211 1,221,676 - - 100% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 (947) 6,983 12,242 - 8,017 47% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 866,211 390,605 858,194 1,233,918 - 8,017 99% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,737,312 - 1,558,185 116,014 179,126 1 100% Debt Service - - - - - - 0% Capital 2,366,192 - 237,889 1,744,593 - 2,128,303 10% Transfers Out - - - - - 0% Total Expenditures 4,103,504 - 1,796,074 1,860,607 179,126 2,128,304 48% Net (3,237,293) 390,605 (937,880) (626,689) (179,126) (2,120,287) Cash Balance 2,292,072 3,232,412 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Major projects in 2013 were the continuation of: Memorial Campus Street Improvements; 400 Block N. Michigan Parking Lot; and Skyway Bridge /Building Improvements. Projects committed thus far in 2014: Completion of projects worked on in 2013 and 2 -Way Streets. Explain Significant Spending on Capital Projects Below: Projects committed thus far in 2014: Completion of projects worked on in 2013 and 2 -Way Streets. Form 3 `[IN Form 3 ID]FA 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Development Month December Fund /Department Number 429 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 1,568,240 760,056 1,568,240 841,627 - - 100% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 9,000 (1,880) 8,751 8,057 - 249 97% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,577,240 758,176 1,576,991 849,684 - 249 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 151,577 4,834 29,175 60,517 97,484 24,918 84% Debt Service - - - - - - 0% Capital 2,654,540 - 126 - 90,040 2,564,374 3% Transfers Out - - - - - - 0% Total Expenditures 2,806,117 4,834 29,301 60,517 187,524 2,589,292 8% Net (1,228,877) 753,342 1,547,690 789,167 (187,524) (2,589,043) Cash Balance 4,551,592 3,008,791 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Major projects in 2013 were: Demolition in relation to AEP Easement; Hill Street Improvements and 5 points utility study. Commitments thus far in 2014 are: 5 points utility improvement /move and infrastructure; and completion of Hill Street Improvements. The Capital budget was increased by $450,000 on 6 Mar 2014. Explain Significant Spending on Capital Projects Below: Form 3 ID]FA 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 Month December Fund /Department Number 430 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,500,000 1,110,266 2,379,212 2,404,416 - 120,788 95% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 (2,073) 9,600 17,222 - 5,400 64% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,515,000 1,108,193 2,388,812 2,421,638 - 126,188 95% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 804,334 213 245,126 553,186 555,021 4,187 99% Debt Service - - - - - - 0% Capital 5,683,623 96,375 626,042 3,823,580 667,512 4,390,069 23% Transfers Out - - - - - - 0% Total Expenditures 6,487,957 96,588 871,168 4,376,766 1,222,533 4,394,256 32% Net (3,972,957) 1,011,605 1,517,644 (1,955,128) (1,222,533) (4,268,068) Cash Balance 4,951,973 3,439,648 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from one year to the next so expenditure comparison will not yield reliable trend review. Major Projects for 2013 were: completion of the Fellows Street Corridor project; additional work on the Ireland Street project; and the final acquisition and engineering along with construction of the Main /Lafayette Crossover project. Projects committed thus far in 2014 are: completion of the Fellows Street Corridor Project; Ireland & Miami Area Improvements; Main /Lafayette Crossover Project and Walter Street Sidewalks. Explain Significant Spending on Capital Projects Below: Form 3 `[11:3 Form 3 `[11:1 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Month December Fund /Department Number 435 1 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 321,895 160,947 321,895 323,939 - - 100% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 750 (116) 557 454 - 193 74% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 322,645 160,831 322,452 324,393 - 193 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,361 - 160 257 4,200 1 100% Debt Service 395,462 - 395,461 190,461 - 1 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 399,823 - 395,621 190,718 4,200 2 100% Net (77,178) 160,831 (73,169) 133,675 (4,200) 191 Cash Balance 221,193 294,600 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. At December 31, 2014, the amounts due Mishawaka and Major moves were $47,003 and $847,644, respectively. Explain Significant Spending on Capital Projects Below: Projects for 2014 include: the Douglas Road Turn Lane. Form 3 `[11:1 Form 3 `sle] 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Residential Month December Fund /Department Number 436 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,725,909 1,343,411 2,725,909 2,262,765 - - 100% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,200 (913) 2,396 8,423 - 1,804 57% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,730,109 1,342,498 2,728,305 2,271,188 - 1,804 100% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 6,346 - - 1,370 - 6,346 0% Debt Service 3,362,308 - 3,362,307 3,217,050 - 1 100% Capital 214,574 - 214,573 - - 1 100% Transfers Out - - - - - - 0% Total Expenditures 3,583,228 - 3,576,880 3,218,420 - 6,348 100% Net (853,119) 1,342,498 (848,575) (947,232) - (4,544) Cash Balance 1,703,673 2,554,079 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Major projects for 2014 include a City contribution to the 2nd Eddy Street Commons Ammendment. The $214,573 Capital Expenditure was to Kite Realty Eddy St. Garage LLC and the budget was adjusted on 6 Mar 2014 to cover it. Explain Significant Spending on Capital Projects Below: Form 3 `sle] Form 3 "`i 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Month December Fund /Department Number 433 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 60 (4) 45 104 - 15 75% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 60 (4) 45 104 - 15 75% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 20,000 - 15,703 5,798 - 4,297 79% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 20,000 - 15,703 5,798 - 4,297 79% Net (19,940) (4) (15,658) (5,694) - (4,282) Cash Balance 10,079 25,749 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund's sole expenditure is for general legal fees for DCI based on an engagement letter Explain Significant Spending on Capital Projects Below: Form 3 "`i Form 3 ISN 2014 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Month December Fund /Department Number 439 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 1,450,000 - 1,328,182 2,859,027 - 121,818 92% Charges for Services - - - - - - 0% Interest Earnings 12,000 (2,084) 9,783 7,207 - 2,217 82% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,462,000 (2,084) 1,337,965 2,866,234 - 124,035 92% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 3,600,000 - - - - 3,600,000 0% Transfers Out - - - - - - 0% Total Expenditures 3,600,000 - - - - 3,600,000 0% Net (2,138,000) (2,084) 1,337,965 2,866,234 - (3,475,965) Cash Balance 5,015,175 3,682,595 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The 1.45M in Revenue represents the final draw from the State. Capital funds are to be expended in Ignition Park and Innovation Park. Explain Significant Spending on Capital Projects Below: Form 3 ISN Form 3 1§93 2014 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Month December Fund /Department Number 454 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,500 (144) 1,069 1,289 - 431 71% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 (144) 1,069 1,289 - 431 71% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 (144) 1,069 1,289 - 431 Cash Balance 377,036 376,372 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: No significant issues. Explain Significant Spending on Capital Projects Below: Form 3 1§93 Form 3 ISO 2014 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations Month December Fund /Department Number 619 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,736,322 6,762 1,539,385 1,530,012 - 196,937 89% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 50,500 - - 0% Total Revenue 1,736,322 6,762 1,539,385 1,580,512 - 196,937 89% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,655,827 60,958 1,536,598 1,528,422 - 119,229 93% Debt Service - - - 207,879 - - 0% Capital 15,879 1,763 15,868 8,816 - 11 100% Transfers Out - - - - - - 0% Total Expenditures 1,671,706 62,721 1,552,466 1,745,117 - 119,240 93% Net 64,616 (55,959) (13,081) (164,605) - 77,697 Cash Balance 83,501 83,729 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: One bond was paid off in early 2013, so debt service expense in 2014 has been much lower than 2013. 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. Explain Significant Spending on Capital Projects Below: Equipment payments Form 3 ISO 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Month December Fund /Department Number 315 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 (395) 2,949 3,567 - 2,051 59% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 (395) 2,949 3,567 - 2,051 59% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 205 3,548 3,567 - 1,452 71% Total Expenditures 5,000 205 3,548 3,567 - 1,452 71% Net - (600) (599) - - 599 Cash Balance 1,037,191 1,038,904 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (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. Explain Significant Spending on Capital Projects Below: Form 3 IfiN 2014 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Month December Fund /Department Number 317 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,800 (192) 1,430 1,725 - 370 79% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,800 (192) 1,430 1,725 - 370 79% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,800 (192) 1,430 1,725 - 370 Cash Balance 504,361 503,472 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Explain Significant Spending on Capital Projects Below: Form 3 `rill Form 3 `rrA 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Month December Fund /Department Number 328 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 (660) 4,927 5,959 - 1,073 82% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 (660) 4,927 5,959 - 1,073 82% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 342 5,929 5,959 - 71 99% Total Expenditures 6,000 342 5,929 5,959 - 71 99% Net - (1,002) (1,002) - - 1,002 Cash Balance 1,732,977 1,735,840 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Form 3 `rrA Form 3 `sM 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Month December Fund /Department Number 432 Date Updated 2/4/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 27,575 - 9,175 1,311,129 - 18,400 33% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 27,000 (2,260) 17,145 18,842 - 9,855 64% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 54,575 (2,260) 26,320 1,329,971 - 28,255 48% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 657 - 656 1,157 - 1 100% Debt Service 493,494 - 491,495 488,848 - 1,999 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 494,151 - 492,151 490,005 - 2,000 100% Net (439,576) (2,260) (465,831) 839,966 - 26,255 Cash Balance 6,496,481 6,968,686 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to payoff debt. 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. In June we received $9,175 in the tax distribution we were not expecting to receive. This amount represents collection of delinquent taxes from previous years. Explain Significant Spending on Capital Projects Below: Form 3 `sM