Loading...
HomeMy WebLinkAbout02-2015 Departmental Financial ReportPeriod Ending: February 28, 2015 Issued By: Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents Mayor Pete Buttigieg 1 Narrative 2 Summaries 7 General Fund 21 Special Revenue Funds 55 Debt Service /Capital Project Funds 67 Enterprise Funds 93 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 February 2015 The Monthly Departmental Financial Report The City of South Bend has developed the attached Monthly Departmental Financial Report to provide current year financial information for each City fund, as well as individual departments within the General Fund, in a condensed format. Information is provided for revenue, expenditures, encumbrances, cash balances and staffing levels. Also included in this report are text boxes that allow departmental fiscal officers to provide an explanation of significant expenditure and staffing variances and spending on major capital projects. Departmental fiscal officers are asked to complete the monthly financial reports ( "blue sheets ") for their funds and General Fund departments no later than the 20th of the month following the reporting period. The staff of the Department of Administration & Finance then summarizes the data and publishes this consolidated report no later than 30 days after the end of the reporting period. The Monthly Departmental Financial Report supplements —but does not replace —other financial reports that the City prepares such as the Monthly Financial Report, Controller's Cash Report, the Department of Local Government Finance's Annual Financial Report (AFR), or the Comprehensive Annual Financial Report (CAFR). Summary Trends & Observations As of February 28, 2015, total revenue for the year was $28,896,533, 11% of estimated revenue. As of February, 2014 total revenue received was $28,760,273 within the same funds. Property taxes are received in June and December each year and are budgeted at $69,690,508 for 2015, 25% of annual budgeted revenues. Local income tax (COIT and EDIT) receipts are budgeted to be $17.8 million in 2015; $1.5 million of that total was received in January. As of February 28, 2015, total expenditures were $46,868,823 and outstanding encumbrances were $29,171,739, a total of $76,040,562 which represents 20% 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 12% of the amended expenditure budget at the end of the period. Total expenditures were $49,001,136 as of February 28, 2014. We hope that you find this Monthly Departmental Financial Report useful in better understanding the finances of the City of South Bend. If you have any questions regarding this report, please contact us at 574 - 235 -7702. City of South Bend Monthly Department Financial Report REVENUE SUMMARY February 28, 2015 City Funds General Fund 52,642,236 1,085,136 2,401,705 2,152,458 2,156,811 5% Special Revenue 102 Rainy Day 34,680 1,888 9,518 4,269 25,162 27% 201 Parks & Recreation 11,030,715 171,928 296,731 255,928 10,733,984 3% 202 Motor Vehicle Highway 9,681,300 1,133,459 1,849,479 702,154 7,831,821 19% 203 Recreation Nonreverting 1,578,935 98,601 164,208 180,073 1,414,727 10% 209 Studebaker - Oliver Reverting Grants 574,000 3,612 4,572 537 569,428 1% 210 Economic Development State Grants 1,673,510 70 360 213 1,673,150 0% 211 Department of Community Investment (DCI) 2,631,625 503,258 517,957 447,624 2,113,668 20% 212 Dept of Community Investment Grants 4,100,000 122,754 221,896 283,595 3,878,104 5% 216 Police State Seizures 35,900 41 203 78 35,697 1% 217 Gift, Donation, Bequest 216,100 989 2,607 21,150 213,493 1% 218 Police Curfew Violations 1,025 3 13 56 1,012 1% 220 Law Enforcement Continuing Education 211,000 28,459 53,318 42,920 157,682 25% 227 Loss Recovery 4,200 4,007 9,213 3,931 (5,013) 219% 244 Emergency Phone System 0 0 19 215,000 (19) 0% 249 Public Safety LOT 6,472,190 539,058 1,079,066 1,064,258 5,393,124 17% 251 Local Roads & Streets 1,593,300 90,155 177,937 178,329 1,415,363 11% 258 Human Rights Federal Grant 203,400 7,188 9,253 4,906 194,147 5% 271 Eastrace Waterway 0 1 6 7 (6) 0% 273 Morris PAC / Palais Royale Marketing 18,000 6 280 3,359 17,720 2% 280 Police Block Grants 0 1 4 2 (4) 0% 281 Economic Develop. Commission - Revenue Bonds 0 6 30 13 (30) 0% 289 HAZMAT 10,000 10,095 13,828 8 (3,828) 138% 291 Indiana River Rescue 45,200 2,423 5,516 4,848 39,684 12% 292 Police Grants 90,000 0 55 66,716 89,945 0% 294 Regional Police Academy 22,000 7,629 18,638 17,286 3,362 85% 295 COPS MORE Grant 128,258 782 1,345 1,855 126,913 1% 299 Police Federal Drug Enforcement 77,000 83 1,900 172 75,100 2% 404 County Option Income Tax 9,883,971 786,779 1,579,828 1,533,918 8,304,143 16% 408 Economic Development Income Tax 9,526,537 767,360 1,691,411 1,838,118 7,835,126 18% 410 Urban Development Action Grant 438,313 6 30 14 438,283 0% 655 Project Releaf 431,700 36,419 73,791 72,844 357,909 17% 705 Police K -9 Unit 2,000 1 504 1,001 1,496 25% Special Revenue Total 60,714,859 4,317,061 7,783,517 6,945,182 52,931,342 13% City Debt Service 313 Football Hall of Fame Debt Service 1,274,056 4,256 8,554 14,280 1,265,502 1% City Debt Service Total 1,274,056 4,256 8,554 14,280 1,265,502 1% Capital Project 377 Professional Sports Development 671,761 142,965 236,341 215,100 435,420 35% 401 Coveleski Stadium Capital 15,100 9 45 13 15,055 0% 403 Zoo Endowment 200 11 54 24 146 27% 405 Park Nonreverting Capital 143,700 260 4,695 7,748 139,005 3% 406 Cumulative Capital Development 542,691 4,467 9,314 8,143 533,377 2% 407 Cumulative Capital Improvement 422,150 52 266 84 421,884 0% 412 Major Moves Construction 811,187 368,822 372,166 189,756 439,022 46% 416 Morris Performing Arts Center Capital 101,500 1,532 9,855 15,382 91,645 10% 434 Community Revitalization Enhancement District 650,000 27 55 57 649,945 0% 450 Palais Royale Historic Preservation 16,150 967 2,248 2,157 13,902 14% 677 Football Hall of Fame Capital 2,500 122 617 326 1,883 25% Capital Project Total 3,376,939 519,233 635,655 438,791 297415284 19% Enterprise 288 Emergency Medical Services Operating 5,676,065 169,122 373,459 441,201 5,302,606 7% 287 Emergency Medical Services Capital 750,000 396,727 396,727 0 353,273 53% 600 Consolidated Building Fund 4,154,113 747,052 835,494 736,316 3,318,619 20% 601 Parking Garages 1,108,726 63,250 146,283 173,591 962,443 13% 610 Solid Waste Operations 5,712,289 401,846 810,024 797,032 4,902,265 14% 611 Solid Waste Capital 753,011 0 190,033 230,464 562,978 25% 620 Water Works Operations 14,760,483 1,058,896 2,124,545 2,221,702 12,635,938 14% City of South Bend Monthly Department Financial Report REVENUE SUMMARY February 28, 2015 Type Dept Name Budget Actual Actual Actual Balance Budget City Fu Enterp 622 Water Works Capital 10,000 682 3,457 1,749 6,543 35% 623 Water Works Bond Capital 0 41 221 519 (221) 0% 624 Water Works Customer Deposit 6,000 324 1,630 720 4,370 27% 625 Water Works Sinking 2,050,078 340,551 341,019 341,853 1,709,059 17% 626 Water Works Bond Reserve 0 353 1,778 17,892 (1,778) 0% 629 Water Works Reserve Operations & Maintenance 162,749 150,683 152,523 54,513 10,226 94% 640 Sewer Repair Insurance 549,200 52,790 104,643 94,188 444,557 19% 641 Sewage Works Operations 35,334,467 2,789,835 5,575,864 5,312,055 29,758,603 16% 642 Sewage Works Capital 5,398,000 815 4,199 2,002,085 5,393,801 0% 643 Sewage Works Reserve Operations & Maint. 250,612 256,833 259,853 131,607 (9,241) 104% 649 Sewage Sinking 9,288,088 773,801 1,548,123 1,550,399 7,739,965 17% 659 Sewer Bond 2011 6,000 330 1,807 3,844 4,193 30% 661 Sewer Bond 2012 20,000 3,669 18,638 9,059 1,362 93% 664 2013A Cost of Issuance Fund 0 1 5 2 (5) 0% 670 Century Center 4,532,562 783,504 816,489 931,838 3,716,073 18% 671 Century Center Capital 500 21 45 30 455 9% Enterprise Total 90,522,943 7,991,127 13,706,860 15,052,659 76,816,083 15% Internal Service 222 Central Services 8,121,097 688,603 1,344,491 1,409,603 6,776,606 17% 224 Central Services Capital 271,850 0 0 0 271,850 0% 226 Liability Insurance 1,260,227 103,108 207,451 509,264 1,052,776 16% 278 Take Home Vehicle Police 124,200 9,474 24,049 24,006 100,151 19% 711 Self- Funded Employee Benefits 16,223,345 1,226,227 2,474,946 1,927,982 13,748,399 15% 713 Unemployment Compensation 226,796 8,525 17,211 17,188 209,585 8% Internal Service Total 26,227,515 2,035,937 4,068,148 3,888,043 22,159,367 16% Trust & Agency 701 Firefighters Pension 5,211,592 130 818 488 5,210,774 0% 702 Police Pension 6,360,000 230 1,363 875 6,358,637 0% 730 City Cemetery 150 6 31 18 119 21% Trust & Agency Total 11,571,742 366 2,212 1,381 11,569,530 0% City Funds Total 246,330,290 15,953,115 28,606,651 28,492,794 169,639,920 12% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 14,880,000 33,228 83,579 12,247 14,796,421 1 % 420 Tax Incremental Financing (TIF) - Downtown 4,344,202 4,240 4,935 60,994 4,339,267 0% 422 TIF - West Washington 422,000 261 1,257 283 420,743 0% 425 Redevelopment Retail & Leighton Plaza 189,123 12,971 31,199 25,346 157,924 16% 426 TIF - Central Medical Service Area 632,000 501 2,442 1,512 629,558 0% 429 River East Development Area (NE Dev TIF) 827,000 993 24,208 1,453 802,792 3% 430 TIF - Southside Development #1 2,410,000 1,025 5,168 1,648 2,404,832 0% 435 TIF - Douglas Road 320,750 48 209 131 320,541 0% 436 River East Residential (NE Res TIF) 2,604,000 352 1,567 1,164 2,602,433 0% Tax Increment Financing Total 26,629,075 53,619 154,564 104,778 26,474,511 1% Redevelopment 433 Redevelopment General 252 2 11 12 241 4% 439 Certified Technology Park 4,404 1,097 5,529 1,824 (1,125) 126% 454 Airport Urban Enterprise Zone 1,500 82 416 186 1,084 28% 619 Blackthorn Operations 1,696,879 20,083 119,238 156,016 1,577,641 7% Redevelopment Total 1,703,035 21,264 125,194 158,038 1,577,841 7% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 227 1,143 515 3,857 23% 317 Coveleski Debt Service Reserve 1,800 110 556 249 1,244 31% 328 Redevelopment Bond - Palais Royale 6,000 379 1,911 860 4,089 32% 432 TIF - Southside Development #3 25,000 1,268 6,514 3,039 18,486 26% Debt Service Total 37,800 1,984 10,124 4,663 27,676 27% Redevelopment Commission Controlled Funds Total 28,369,910 76,867 289,882 267,479 28,080,028 1% Grand Total 274,700,200 16,029,982 28,896,533 28,760,273 197,719,948 11% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY February 28, 2015 City Funds General Fund 101 -0101 Mayor's Office 741,267 52,551 133,014 125,973 893 607,360 18% 101 -0104 311 Call Center 486,733 36,290 91,485 77,967 2,565 392,683 19% 101 -0201 City Clerk 431,573 28,270 63,045 58,202 20,112 348,416 19% 101 -0301 Common Council 490,150 24,869 58,673 49,932 69,341 362,136 26% 101 -0302 WNIT Contract 43,000 0 0 0 0 43,000 0% 101 -0401 Administration & Finance 2,020,544 134,270 321,802 314,804 41,186 1,657,556 18% 101 -0404 Morris Performing Arts Center 1,093,132 87,590 184,428 174,091 48,078 860,626 21% 101 -0405 Palais Royale 536,293 31,105 73,017 75,151 40,417 422,858 21% 101 -0501 Legal Department 1,006,979 73,130 172,309 185,814 19,298 815,372 19% 101 -0602 Engineering 1,058,933 79,671 152,601 184,427 123,994 782,338 26% 101 -0801 Police Department 25,633,064 1,878,729 4,436,141 4,241,310 367,046 20,829,877 19% 101 -0802 Communications Center 1,687,540 97 135,128 352,166 0 1,552,412 8% 101 -0901 Fire Department 17,774,474 1,590,349 3,740,818 3,596,492 274,718 13,758,938 23% 101 -1008 Human Rights 373,179 31,896 82,219 58,073 11,997 278,963 25% 101 -1201 Code 2013 2,270 0 0 4,382 2,269 1 100% General Fund Total 53,379,131 4,048,817 9,644,681 9,498,785 1,021,913 42,712,538 20% Special Revenue 201 Parks & Recreation 11,063,995 779,797 1,985,723 2,185,437 536,355 8,541,917 23% 202 Motor Vehicle Highway 10,485,386 990,673 1,837,952 1,793,653 443,079 8,204,356 22% 203 Recreation Nonreverting 1,549,469 60,957 104,855 115,049 79,921 1,364,693 12% 209 Studebaker - Oliver Reverting Grants 600,000 3,375 3,375 0 26,625 570,000 5% 210 Economic Development State Grants 1,694,412 0 12,200 0 10,200 1,672,012 1% 211 Department of Community Investment (DCI) 2,661,730 178,977 429,372 404,654 38,114 2,194,244 18% 212 Dept of Community Investment Grants 6,547,968 146,917 253,738 291,689 2,397,165 3,897,065 40% 216 Police State Seizures 35,900 0 0 0 0 35,900 0% 217 Gift, Donation, Bequest 297,182 27,830 27,830 0 53,981 215,371 28% 218 Police Curfew Violations 1,000 0 0 0 0 1,000 0% 220 Law Enforcement Continuing Education 362,478 29,274 45,004 31,565 1,180 316,294 13% 227 Loss Recovery 5,237,243 298,680 480,270 11,958 3,723,277 1,033,697 80% 244 Emergency Phone System 0 1 21 43,391 0 -21 0% 249 Public Safety LOT 7,246,551 515,347 1,247,402 1,131,036 0 5,999,149 17% 251 Local Roads & Streets 1,926,221 4,853 9,007 31,522 523,692 1,393,521 28% 258 Human Rights Federal Grant 247,357 9,167 31,229 30,293 20,094 196,035 21% 271 Eastrace Waterway 4,000 0 0 0 1,098 2,902 27% 273 Morris PAC / Palais Royale Marketing 18,974 96 96 3,628 2,358 16,520 13% 289 HAZMAT 31,530 602 21,542 0 0 9,988 68% 291 Indiana River Rescue 120,800 2,120 2,120 1,483 20,997 97,684 19% 292 Police Grants 105,145 15,297 15,297 0 0 89,848 15% 294 Regional Police Academy 23,750 9,673 12,398 333 0 11,352 52% 295 COPS MORE Grant 172,335 784 21,274 1,660 13,445 137,616 20% 299 Police Federal Drug Enforcement 248,960 6,474 24,859 2,731 20,524 203,577 18% 404 County Option Income Tax 15,660,371 797,317 2,119,512 1,998,022 1,307,863 12,232,996 22% 408 Economic Development Income Tax 9,627,618 1,795,231 2,372,294 2,474,254 430,320 6,825,004 29% 410 Urban Development Action Grant 438,203 0 0 0 0 438,203 0% 655 Project Releaf 528,358 2,281 17,638 17,648 0 510,720 3% 705 Police K -9 Unit 2,000 0 0 0 0 2,000 0% Special Revenue Total 76,938,936 5,675,723 11,075,007 10,570,007 9,650,287 56,213,642 27% City Debt Service 313 Football Hall of Fame Debt Service 1,266,820 0 636,000 634,500 0 630,820 50% City Debt Service Total 1,266,820 0 636,000 634,500 0 630,820 50% Capital Project 377 Professional Sports Development 854,803 800 481,573 383,673 0 373,230 56% 403 Zoo Endowment 49,000 0 0 0 0 49,000 0% 405 Park Nonreverting Capital 192,933 0 0 116,776 18,520 174,414 10% 406 Cumulative Capital Development 542,691 0 112,650 112,650 0 430,041 21% 407 Cumulative Capital Improvement 365,625 0 183,750 185,250 0 181,875 50% 412 Major Moves Construction 3,096,061 153,529 209,388 100,669 1,556,104 1,330,569 57% 416 Morris Performing Arts Center Capital 70,248 1,665 2,933 0 25,394 41,920 40% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 420 Tax Incremental Financing (TIF) - Downtown 422 TIF - West Washington 425 Redevelopment Retail & Leighton Plaza 426 TIF - Central Medical Service Area 429 River East Development Area (NE Dev TIF) 430 TIF - Southside Development #1 435 TIF - Douglas Road 436 River East Residential (NE Res TIF) Tax Increment Financing Total Redevelopment 433 Redevelopment General 439 Certified Technology Park 619 Blackthorn Operations City of South Bend Monthly Department Financial Report 1,684,991 3,961,430 1,654,102 4,169,637 EXPENDITURE SUMMARY 17% 4,537,169 - 957,248 6,768 1,330,195 0 February 28, 2015 current Current 0% 760,900 15,300 Percent 319 Fund Type Department Name City Ft Capital Prc 434 Community Revitalization Enhancement District Amended Budget 650,000 Month Current Actual 0 YTD Actual 3,897 Prior YTD Actual Encumbrances 20,975 Current 0 Budget Balance 646,103 of Budget 1% 450 Palais Royale Historic Preservation 16,150 0 0 0 0 16,150 0% 677 Football Hall of Fame Capital 188,824 6,370 13,213 14,234 0 175,611 7% Capital Project Total 6,026,335 162,364 1,007,404 934,227 1,600,018 3,418,913 43% Enterprise 169,620 160 4,200 171,569 50% 3,425,632 246,589 288 Emergency Medical Services Operating 6,855,366 32,280 280,257 729,785 315,360 6,261,761 9% 287 Emergency Medical Services Capital 750,000 35,728 35,728 0 0 678,544 5% 600 Consolidated Building Fund 4,205,401 225,047 507,424 447,940 237,154 3,460,823 18% 601 Parking Garages 931,712 113,600 202,631 171,018 158,359 570,722 39% 610 Solid Waste Operations 5,873,863 341,051 976,539 1,036,900 25,712 4,871,612 17% 611 Solid Waste Capital 752,811 143 223,892 344,413 0 528,919 30% 620 Water Works Operations 15,844,471 1,373,209 2,313,834 2,291,704 519,202 13,011,436 18% 622 Water Works Capital 838,893 67,463 82,845 3,600 3,489 752,559 10% 623 Water Works Bond Capital 53,085 37,750 49,028 213,072 4,276 -219 100% 624 Water Works Customer Deposit 6,000 324 776 720 0 5,224 13% 625 Water Works Sinking 2,050,078 1 467 233 0 2,049,611 0% 629 Water Works Reserve Operations & Maintenance 8,500 455 1,092 1,006 0 7,408 13% 640 Sewer Repair Insurance 545,703 57,144 78,593 47,461 90,380 376,730 31% 641 Sewage Works Operations 38,196,974 2,556,513 5,120,884 6,988,332 1,175,672 31,900,418 16% 642 Sewage Works Capital 9,071,710 47,104 86,219 1,395,429 3,639,621 5,345,870 41% 643 Sewage Works Reserve Operations & Maint. 15,000 747 1,792 1,643 0 13,208 12% 649 Sewage Sinking 9,282,109 850 1,850 1,350 0 9,280,259 0% 659 Sewer Bond 2011 3,711,838 502,799 645,836 541,236 943,530 2,122,472 43% 661 Sewer Bond 2012 16,624,275 249,076 288,246 488,626 1,448,955 14,887,074 10% 670 Century Center 4,532,562 285,450 591,948 742,052 0 3,940,614 13% 671 Century Center Capital 0 66,156 66,156 0 0 - 66,156 0% Enterprise Total 120,150,351 5,992,890 11,556,035 15,446,519 8,561,709 99,998,890 17% Internal Service 222 Central Services 8,279,085 621,835 1,301,399 1,283,684 2,916,775 4,060,911 51% 224 Central Services Capital 271,850 0 0 0 0 271,850 0% 226 Liability Insurance 3,056,791 255,553 517,792 593,848 54,734 2,484,266 19% 278 Take Home Vehicle Police 71,100 0 0 0 0 71,100 0% 711 Self- Funded Employee Benefits 16,696,935 963,626 1,994,397 2,334,560 284,787 14,417,751 14% 713 Unemployment Compensation 226,796 5,167 15,293 25,897 13,200 198,303 13% Internal Service Total 28,602,557 1,846,181 3,828,881 4,237,988 3,269,495 21,504,181 25% Trust & Agency 701 Firefighters Pension 5,666,579 441,276 882,468 905,707 0 4,784,111 16% 702 Police Pension 6,832,235 524,012 1,061,124 1,186,599 0 5,771,111 16% 730 City Cemetery 20,000 0 0 0 0 20,000 0% Trust & Agency Total 12,518,814 965,288 1,943,592 2,092,306 0 10,575,222 16% City Funds Total ' 298,882,944 18,691,263 39,691,600 43,414,332 24,103,423 235,054,204 21% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 420 Tax Incremental Financing (TIF) - Downtown 422 TIF - West Washington 425 Redevelopment Retail & Leighton Plaza 426 TIF - Central Medical Service Area 429 River East Development Area (NE Dev TIF) 430 TIF - Southside Development #1 435 TIF - Douglas Road 436 River East Residential (NE Res TIF) Tax Increment Financing Total Redevelopment 433 Redevelopment General 439 Certified Technology Park 619 Blackthorn Operations 47,710,597 1,684,991 3,961,430 1,654,102 4,169,637 39,579,530 17% 4,537,169 - 957,248 6,768 1,330,195 0 4,530,401 0% 760,900 15,300 15,300 319 15,300 730,300 4% 154,716 9,662 16,624 17,742 0 138,092 11% 2,476,033 0 0 169,224 3,613 2,472,420 0% 7,239,524 5,000 117,956 617 173,773 6,947,795 4% 2,842,535 24,431 459,801 90,247 704,062 1,678,672 41% 345,389 169,620 169,620 160 4,200 171,569 50% 3,425,632 246,589 1,710,589 1,865,291 0 1,715,043 50% 69,492,495 1,198,345 6,458,088 5,127,897 5,070,585 57,963,822 17% 6,000 0 0 6,072 0 6,000 0% 5,000,000 0 0 0 0 5,000,000 0% 1,671,706 89,358 158,413 101,236 0 1,513,293 9% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY February 28, 2015 Redev Redevelopment Total Debt Service 315 Redevelopment Bond - Airport Taxable 328 Redevelopment Bond - Palais Royale 432 TIF - Southside Development #3 Debt Service Total Redevelopment Commission Controlled Funds Total 6,677,706 89,358 158,413 107,308 0 6,519,293 2% 5,000 227 544 515 0 4,456 11% 6,000 379 909 860 0 5,091 15% 691,380 201,724 559,269 354,606 0 132,111 81% 702,380 202,330 560,722 355,981 0 141,658 80% 76,872,581 1,490,033 7,177,223 5,591,186 5,070,585 64,624,773 16% Grand Total 375,755,525 20,181,296 46,868,823 49,005,518 29,174,008 299,678,977 20% 6 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Month Februa Fund /Department Number 101 -0101 Date Updated 3/11/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 740,667 52,551 132,979 125,595 - 607,688 18% Local Income Taxes - - - - - - 0% Other Taxes - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - 35 379 - (35) 0% Other Income 600 - - - - 600 0% Transfers In - - - - - - 0% Total Revenue 741,267 52,551 133,014 125,973 - 608,253 18% Expenditures Personnel 669,877 50,317 120,279 108,644 - 549,598 18% Supplies 12,413 804 1,558 3,486 878 9,977 20% Services 56,739 1,283 11,030 13,146 14 45,695 19% Debt Service 2,238 147 147 697 - 2,091 7% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 741,267 52,551 133,014 125,973 893 607,360 18% Net - - - - (893) 893 Cash Balance - - Staffing Full Time 7.00 7.00 7.00 Part -Time /Seasonal /Temporary 2.00 1.00 1.00 Total 9.00 8.00 8.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Expenditures higher in personnel due to three payrolls occurring in January. Explain Significant Spending on Capital Projects Below: There are no capital projects budgeted for 2015. Form 3 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center Month Februa Fund /Department Number 101 -0104 Date Updated 3/10/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 16,442 - - 51,458 - 16,442 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 470,291 36,290 91,485 26,509 - 378,806 19% Transfers In - - - - - - 0% Total Revenue 486,733 36,290 91,485 77,967 - 395,248 19% Expenditures Personnel 441,562 33,759 80,083 66,453 - 361,479 18% Supplies 6,125 - 647 9,316 625 4,853 21% Services 39,046 2,530 10,755 2,198 1,940 26,351 33% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 486,733 36,290 91,485 77,967 2,565 392,683 19% Net - - - - (2,565) 2,565 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: We have budgeted the use of some Property Tax revenues in 2015 - indicating that the department needs to rely somewhat on property taxes in order to cover its budget for 2015. However, at this point, we have not had to utilize any of those funds. The department has paid for itself. Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted in 2015. Form 3 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Month Februa Fund /Department Number 101 -0201 Date Updated 1 3/11/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 431,573 28,270 63,045 58,202 - 368,528 15% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,573 28,270 63,045 58,202 - 368,528 15% Expenditures Personnel 339,442 23,787 57,003 54,017 - 282,439 17% Supplies 7,740 120 144 2,145 1,000 6,596 15% Services 70,991 4,363 5,898 2,040 19,112 45,981 35% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 431,573 28,270 63,045 58,202 20,112 348,416 19% Net - - - - (20,112) 20,112 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: This year, a copier has been budgeted for capital expenditures. Form 3 Form 3 10 2015 City of South Bend Monthly Financial Report Fund /Department Name Common Council Month Februa Fund /Department Number 101 -0301 Date Updated 3/11/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 481,684 24,838 58,602 49,864 - 423,082 12% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 8,466 31 71 68 - 8,395 1% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 490,150 24,869 58,673 49,932 - 431,477 12% Expenditures Personnel 325,242 16,159 38,760 36,910 - 286,482 12% Supplies 4,706 337 371 48 999 3,336 29% Services 160,202 8,374 19,543 12,974 68,342 72,318 55% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 490,150 24,869 58,673 49,932 69,341 362,136 26% Net - - - - (69,341) 69,341 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. Expenditures are consistent with normal operating costs. Explain Significant Spending on Capital Projects Below: Form 3 10 2015 City of South Bend Monthly Financial Report Fund /Department Name WNIT Contract Month Februa Fund /Department Number 101 -0302 Date Updated 3/11/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 43,000 - - - - 43,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 43,000 - - - - 43,000 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 43,000 - - - - 43,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 43,000 - - - - 43,000 0% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This annual expenditure was previously paid from the Council department (101 -0301) but was segregated upon the Council's request. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 iVA 2015 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Month February Fund /Department Number 101 -0401 Date Updated 3/11/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,990,494 134,050 321,582 314,804 - 1,668,912 16% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 30,050 220 220 - - 29,830 1% Transfers In - - - - - - 0% Total Revenue 2,020,544 134,270 321,802 314,804 - 1,698,742 16% Expenditures Personnel 1,806,651 126,583 308,508 296,417 - 1,498,143 17% Supplies 28,109 2,159 3,641 3,368 7,055 17,413 38% Services 183,213 5,528 9,010 14,376 34,131 140,072 24% Debt Service 2,571 - 643 643 - 1,928 25% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,020,544 134,270 321,802 314,804 41,186 1,657,556 18% Net - - - - (41,186) 41,186 Cash Balance - - Staffing Full Time 22.00 22.00 Part -Time /Seasonal /Temporary - 2.00 Total 22.00 24.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Transferred Chief Technology Officer to COIT for 2015 budget and added new HR Generalist position. Overall spending appears consistent with expectations. Explain Significant Spending on Capital Projects Below: None Form 3 iVA Form 3 13 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Month February Fund /Department Number 101 -0404 Date Updated 3/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 170,132 64,290 107,799 69,952 - 62,333 63% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 917,000 22,635 74,945 102,457 - 842,055 8% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 665 1,684 1,682 - 4,316 28% Transfers In - - - - - - 0% Total Revenue 1,093,132 87,590 184,428 174,091 - 908,704 17% Expenditures Personnel 749,285 55,682 132,414 122,478 4,070 612,801 18% Supplies 33,542 1,877 3,110 3,926 10,458 19,974 40% Services 310,305 30,032 48,904 47,688 33,549 227,852 27% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,093,132 87,590 184,428 174,091 48,078 860,626 21% Net - - - - (48,078) 48,078 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: Explain Significant Spending on Capital Projects Below: There are no Capital Expenses budgeted for this year. This is an Operating Budget. By Ordinance, Fund 416 is used to support renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons at the Morris Performing Arts Center. There are no Capital Expenses / Projects budgeted this year. Form 3 13 Form 3 14 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Month Februa Fund /Department Number 101 -0405 Date Updated 3/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 201,473 21,758 39,302 38,666 - 121,754 20% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 315,820 8,558 31,390 34,472 - 284,430 10% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,000 789 2,325 2,012 - 16,675 12% Transfers In - - - - - - 0% Total Revenue 536,293 31,105 73,017 75,151 - 422,858 14% Expenditures Personnel 263,505 18,824 44,686 41,832 1,530 217,289 18% Supplies 23,897 618 909 1,445 4,905 18,084 24% Services 234,891 11,663 27,422 31,874 33,983 173,486 26% Debt Service - - - - - - 0% Capital 14,000 - - - - 14,000 0% Transfers Out - - - - - - 0% Total Expenditures 536,293 31,105 73,017 75,151 40,417 422,858 21% Net - - - - (40,417) - 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: AN Upgrades (screen, projector, computer). Curtain replacement project ($30,000.00) defer to 2016. Form 3 14 Form 3 W1 2015 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Month Februa Fund /Department Number 101 -0501 Date Updated 3/11/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 953,979 72,622 171,801 184,756 - 782,178 18% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 3,000 - - 1,041 - 3,000 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 50,000 508 508 18 - 49,492 1% Transfers In - - - - - - 0% Total Revenue 1,006,979 73,130 172,309 185,814 - 834,670 17% Expenditures Personnel 955,213 66,881 164,878 179,898 - 790,335 17% Supplies 5,212 846 1,000 775 1,620 2,592 50% Services 45,254 5,403 6,431 5,141 16,724 22,099 51% Debt Service 1,300 - - - 954 346 73% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,006,979 73,130 172,309 185,814 19,298 815,372 19% Net - - - - (19,298) 19,298 Cash Balance - - Staffing Full Time 10.60 10.60 Part -Time /Seasonal /Temporary - - Total 10.60 10.60 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Other Income of $50,000 is reimbursement for legal expenses from TIF funds which will be received in December 2015. Encumbrances are the reason the expenses appear higher for February 2015. The encumbrances relate to subscriptions paid monthly, debt sevices paid quarterly, and office supplies. Spending appears to be on track with budgeted figures. Explain Significant Spending on Capital Projects Below: Form 3 W1 Form 3 W" 2015 City of South Bend Monthly Financial Report Fund /Department Name Engineering Month Februa Fund /Department Number 101 -0602 Date Updated 3/11/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 981,906 79,671 152,601 184,312 - 829,305 16% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 77,027 - - 115 - 77,027 0% Transfers In - - - - - - 0% Total Revenue 1,058,933 79,671 152,601 184,427 - 906,332 14% Expenditures Personnel 710,552 44,799 103,029 120,100 - 607,523 14% Supplies 29,262 2,194 4,203 3,185 11,019 14,040 52% Services 306,044 32,029 42,167 57,940 111,031 152,846 50% Debt Service 13,075 648 3,202 3,202 1,944 7,929 39% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,058,933 79,671 152,601 184,427 123,994 782,338 26% Net - - - - (123,994) 123,994 Cash Balance - - Staffing Full Time 7.90 6.50 Part -Time /Seasonal /Temporary 1.22 1.73 Total 9.12 8.23 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: $111,031 in encumbrance for Services include $72,500 for water system evaluation, $25,300 for 13th floor renovation, and $9,000 for 2015 travel booked in 2014. Other income includes reimbursement from the River West (f /k /a Airport) TIF for 80% of the salary of a new engineer who is scheduled to begin near the end of May. Explain Significant Spending on Capital Projects Below: Form 3 W" Form 3 17 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Department Month Februa Fund /Department Number 101 -0801 Date Updated 3/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 25,095,364 1,867,357 4,418,165 4,173,168 - 20,677,199 18% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 200,000 - - - - 200,000 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 7,500 500 500 - - 7,000 7% Other Income 330,200 10,872 17,476 68,142 - 312,724 5% Transfers In - - - - - - 0% Total Revenue 25,633,064 1,878,729 4,436,141 4,241,310 - 21,196,923 17% Expenditures Personnel 22,989,224 1,627,620 4,017,475 3,573,151 - 18,971,749 17% Supplies 419,279 58,483 96,799 229,414 88,984 233,496 44% Services 2,201,409 191,923 320,587 405,204 278,062 1,602,760 27% Debt Service 23,152 703 1,280 962 - 21,872 6% Capital - - - 32,579 - - 0% Transfers Out - - - - - - 0% Total Expenditures 25,633,064 1,878,729 4,436,141 4,241,310 367,046 20,829,877 19% Net - - - - (367,046) 367,046 Cash Balance - - Staffing Full Time 263.00 257.00 257.00 Part -Time /Seasonal /Temporary 60.00 30.00 30.00 Total 323.00 287.00 287.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund includes the expenditures for 217 of the 260 budgeted Police officers and 106 civilian staff. Fund 249 contains the funding for 43 of the 260 Police officers that are funded by the LOIT. The 2015 Personnel Expenditure exceeds the prior year amount due to the increase in Police salaries and the transfer of eight Front Desk Staff from the Communications Budget to the Police Budget in 2015. Supllies and Services expenditures show 44% and 27% of the Budget as used through February. This is due to the 2014 encumberances reflected as a use in February. These categories are expected to be on budget for the year. Explain Significant Spending on Capital Projects Below: Form 3 17 2015 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Month Februa Fund /Department Number 101 -0802 Date Updated 3/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 1,687,540 97 135,128 352,166 - 1,552,412 8% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,687,540 97 135,128 352,166 - 1,552,412 8% Expenditures Personnel 143,972 97 135,128 350,812 - 8,844 94% Supplies - - - 60 - - 0% Services 1,543,568 - - 1,294 - 1,543,568 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,687,540 97 135,128 352,166 - 1,552,412 8% Net - - - - - - Cash Balance - - Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Prior to December 31, 2014, this fund captured the cost of 35 of the 38 civilians and equipment to maintain the 911 communication center. Effective January 1, 2015 the County PSAP has consolidated the 911 call centers and SBPD no longer maintains a call center. The Personnel costs in January are the 2014 salary costs for the Communications staff paid in 2015. There are no additional salaries to be paid. The Services budget of $1,543,568 is the annual amount that the County will charge SBPD as a participant in using the PSAP. Explain Significant Spending on Capital Projects Below: Form 3 18 2015 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Month Februa Fund /Department Number 101 -0901 Date Updated 3/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 17,762,474 1,530,724 3,671,171 3,516,177 14,091,303 21% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 6,000 56,678 66,699 80,062 - (60,699) 1112% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 2,948 2,948 254 - 3,052 49% Transfers In - - - - 0% Total Revenue 17,774,474 1,590,349 3,740,818 3,596,492 - 14,033,656 21% Expenditures Personnel 15,737,086 1,479,769 3,525,189 3,290,546 122,463 12,089,435 23% Supplies 320,618 8,289 21,698 59,696 32,783 266,137 17% Services 1,216,770 102,291 193,932 246,250 119,472 903,366 26% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 500,000 - - - - 500,000 0% Total Expenditures 17,774,474 1,590,349 3,740,818 3,596,492 274,718 13,758,938 23% Net - - - - (274,718) 274,718 Cash Balance - - Staffing Full Time 170.00 167.00 167.00 Part -Time /Seasonal /Temporary - - - Total 170.00 167.00 167.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The South Bend Fire Department is budgeted to have 251 sworn firefighters and 7 civilian full time employees. 37 firefighters are paid directly through the Public Safety LOIT. 47 Sworn Employee's and 4 civilian employee's costs are allocated to Fund 288 EMS Operations. We hold a lengthy recruitment process every 2 years and hire individuals in groups of 6 -10 as needed while that list is in effect. We also employ civilian administrative staff that handle payroll, purchasing and billing for our ambulance service. Explain Significant Spending on Capital Projects Below: The Fire Department uses EMS Capital Fund 287 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through that fund. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Form 3 19 Form 3 20 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Month Februa Fund /Department Number 101 -1008 Date Updated 3/11/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 373,179 31,896 82,219 58,073 - 290,960 22% 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 373,179 31,896 82,219 58,073 - 290,960 22% Expenditures Personnel 286,475 26,880 61,652 48,068 - 224,823 22% Supplies 2,010 39 134 476 400 1,476 27% Services 73,492 4,812 10,026 9,529 11,597 51,869 29% Debt Service - - - - - - 0% Capital 11,202 165 10,407 - - 795 93% Transfers Out - - - - - - 0% Total Expenditures 373,179 31,896 82,219 58,073 11,997 278,963 25% Net - - - - (11,997) 11,997 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 higher in personnel than last year, as there were three pay payrolls in the month of January. Explain Significant Spending on Capital Projects Below: Human Rights had money encumbered from last year for a copier. Purchase was made in January. Form 3 20 Form 3 `A 2015 City of South Bend Monthly Financial Report Fund /Department Name Rainy Day Month Februa Fund /Department Number 102 Date Updated 3/11/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 34,680 1,888 9,518 4,269 - 25,162 27% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 34,680 1,888 9,518 4,269 - 25,162 27% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 34,680 1,888 9,518 4,269 - 25,162 Cash Balance 8,651,706 8,621,973 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Levy Month Februa Fund /Department Number 103 Date Updated 3/11/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 1 - - (1) 0% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 1 - - (1) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 1 - - (1) 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation Month Februa Fund /Department Number 201 Date Updated 3/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 7,340,000 - 7,340,000 0% Local Income Taxes - - 0% Other Taxes 626,039 - 626,039 0% Grants /Intergovernmental 884,836 73,736 147,473 121,565 - 737,363 17% Charges for Services 2,025,640 80,139 108,428 105,169 - 1,917,212 5% Interest Earnings 10,000 647 3,371 1,720 - 6,629 34% Bond Proceeds - - 0% Donations - - 0% Other Income 144,200 17,405 37,459 27,474 - 106,741 26% Transfers In - - - 0% Total Revenue 11,030,715 171,928 296,731 255,928 - 10,733,984 3% Expenditures Personnel 7,105,699 466,307 1,111,410 1,265,435 4,078 5,990,211 16% Supplies 1,109,836 59,814 87,767 111,795 428,212 593,858 46% Services 2,443,703 252,448 785,319 802,286 104,065 1,554,319 36% Debt Service 309,257 1,228 1,228 921 - 308,029 0% Capital - - 5,000 - - 0% Transfers Out 95,500 - - - 95,500 0% Total Expenditures 11,063,995 779,797 1,985,723 2,185,437 536,355 8,541,917 23% Net (33,280) (607,870) (1,688,992) (1,929,509) (536,355) 2,192,068 Cash Balance 1,809,440 2,326,116 Staffing Full Time 90.00 87.00 87.00 Part -Time /Seasonal /Temporary na 36.00 36.00 Total 90.00 123.00 123.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. In 2014 the Potawatomi Zoo began operation by the Potawatomi Zoological Society. Part time staffing is individuals, not FTEs Explain Significant Spending on Capital Projects Below: Because of decreasing property tax revenues, there is no capital budget in fund 201. A $5.6 million bond has been approved and funding is expected to be received late in the first quarter of 2015. Form 3 23 Form 3 24 2015 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month Februa Fund /Department Number 202 Date Updated 3/11/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,697,000 280,030 962,107 631,708 - 4,734,893 17% Grants /Intergovernmental - - - 0% Charges for Services 265,000 14,298 43,022 63,890 - 221,978 16% Interest Earnings 7,000 863 4,347 1,826 - 2,653 62% Bond Proceeds - - - 0% Donations - - - 0% Other Income 9,300 18 1,753 4,730 - 7,547 19% Transfers In 3,703,000 838,250 838,250 - 2,864,750 23% Total Revenue 9,681,300 1,133,459 1,849,479 702,154 - 7,831,821 19% Expenditures Personnel 4,314,548 354,612 826,397 849,000 3,488,151 19% Supplies 2,631,854 419,337 579,760 424,724 309,781 1,742,313 34% Services 2,951,520 216,723 396,157 425,105 93,840 2,461,523 17% Debt Service 448,006 35,637 35,637 412,369 8% Capital 139,458 59,187 39,458 100,000 28% Transfers Out - - - - - - 0% Total Expenditures 10,485,386 990,673 1,837,952 1,793,653 443,079 8,204,356 22% Net (804,086) 142,786 11,528 (1,091,499) (443,079) (372,535) Cash Balance 3,891,890 2,588,527 Staffing Full Time 52.65 47.85 Part -Time /Seasonal /Temporary 4.98 2.24 Total 57.63 50.09 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Information included for Streets, Traffic & Lighting, and Curb & Sidewalk. Explain Significant Spending on Capital Projects Below: Form 3 24 Form 3 `�7 2015 City of South Bend Monthly Financial Report Fund /Department Name Recreation Nonreverting Month Februa Fund /Department Number 203 Date Updated 3/11/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,530,935 89,921 152,067 157,677 - 1,378,868 10% Interest Earnings 3,000 179 896 388 - 2,104 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 45,000 8,502 11,245 22,009 - 33,755 25% Transfers In - - - - - - 0% Total Revenue 1,578,935 98,601 164,208 180,073 - 1,414,727 10% Expenditures Personnel 737,842 28,345 62,096 59,944 - 675,746 8% Supplies 289,470 21,246 25,398 11,306 61,051 203,020 30% Services 522,157 7,815 13,810 43,799 18,870 489,477 6% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - 3,550 3,550 - - (3,550) 0% Total Expenditures 1,549,469 60,957 104,855 115,049 79,921 1,364,693 12% Net 29,466 37,644 59,353 65,024 (79,921) 50,034 Cash Balance 873,266 843,273 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 ` ": Form 3 27 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Month February Fund /Department Number 210 Date Updated 3/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 1,600,000 - - - - 1,600,000 0% Charges for Services - - - - - - 0% Interest Earnings 13,544 70 360 213 - 13,184 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 59,966 - - - - 59,966 0% Transfers In - - - - - - 0% Total Revenue 1,673,510 70 360 213 - 1,673,150 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,622,400 - 12,200 - 10,200 1,600,000 1% Debt Service 72,012 - - - - 72,012 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,694,412 - 12,200 - 10,200 1,672,012 1% Net (20,902) 70 (11,840) 213 (10,200) 1,138 Cash Balance 317,593 349,164 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: No significant issues. We received a grant from the IDGF in 2014 in the amount of $2,000,000 to be used for Ignition Park Infrastructure. $1,600,000 of this grant remains. Explain Significant Spending on Capital Projects Below: Form 3 27 Form 3 28 2015 City of South Bend Monthly Financial Report Fund /Department Name Department of Community Investment DCI Month February Fund /Department Number 211 Date Updated 3/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 416,787 - - - - 416,787 0% Charges for Services - - - - - - 0% Interest Earnings 2,200 (248) 1,173 421 - 1,027 53% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 245,000 11,596 24,874 24,963 - 220,126 10% Transfers In 1,967,638 491,910 491,910 422,240 - 1,475,728 25% Total Revenue 2,631,625 503,258 517,957 447,624 - 2,113,668 20% Expenditures Personnel 2,120,943 144,601 357,253 358,056 9,260 1,754,430 17% Supplies 35,753 1,821 3,910 3,985 11,236 20,607 42% Services 505,034 32,555 68,209 42,613 17,618 419,207 17% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,661,730 178,977 429,372 404,654 38,114 2,194,244 18% Net (30,105) 324,281 88,585 42,970 (38,114) (80,576) Cash Balance 1,162,803 950,365 Staffing Full Time 23.00 23.00 23.00 Part -Time /Seasonal /Temporary - - - Total 23.00 23.00 23.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund covers operations of the Department of Community Investment. Transfers In come from EDIT on a quarterly basis. Explain Significant Spending on Capital Projects Below: Form 3 28 Form 3 29 2015 City of South Bend Monthly Financial Report Fund /Department Name Dept of Community Investment Grants Month Februa Fund /Department Number 212 Date Updated 3/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 3,850,000 118,306 118,306 272,314 - 3,731,694 3% Charges for Services - - - - - - 0% Interest Earnings 2,000 570 674 539 - 1,326 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 248,000 3,878 102,916 10,742 - 145,084 41% Transfers In - - - - - - 0% Total Revenue 4,100,000 122,754 221,896 283,595 - 3,878,104 5% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 6,547,968 146,917 253,738 291,689 2,397,165 3,897,065 40% Transfers Out - - - - - - 0% Total Expenditures 6,547,968 146,917 253,738 291,689 2,397,165 3,897,065 40% Net (2,447,968) (24,163) (31,842) (8,094) (2,397,165) (18,961) Cash Balance 760,761 584,224 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Month Februa Fund /Department Number 216 Date Updated 3/11/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 - - - - 35,000 0% Charges for Services - - - - - - 0% Interest Earnings 300 41 203 78 - 97 68% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - - - - 600 0% Transfers In - - - 0% Total Revenue 35,900 41 203 78 - 35,697 1% Expenditures Personnel - - - - - - 0% Supplies - 0% Services 35,900 - - - 35,900 0% Debt Service - - - - - 0% Capital - - - - - - 0% Transfers Out - 0% Total Expenditures 35,900 - - - - 35,900 0% Net - 41 203 78 - (203) Cash Balance 187,635 158,745 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 a 2015 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month Februa Fund /Department Number 217 Date Updated 3/11/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 30 152 37 - (52) 152% Bond Proceeds - - - - - - 0% Donations 216,000 959 2,456 21,113 - 213,544 1% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 216,100 989 2,607 21,150 - 213,493 1% Expenditures Personnel - - - - - - 0% Supplies 1,552 - - - 1,552 0 100% Services 295,630 27,830 27,830 - 52,429 215,371 27% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 297,182 27,830 27,830 - 53,981 215,371 28% Net (81,082) (26,841) (25,223) 21,150 (53,981) (1,879) Cash Balance 112,716 95,884 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 2015 this account will be used to spend down the grant received in 2014 to pay for remediation and demolition of vacant and abandoned housing. Explain Significant Spending on Capital Projects Below: None Form 3 a 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Month Februa Fund /Department Number 218 Date Updated 3/10/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 - - 48 - 1,000 0% Interest Earnings 25 3 13 8 - 12 52% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,025 3 13 56 - 1,012 1% 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 25 3 13 56 - 12 Cash Balance 12,019 11,601 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 activities and training. Explain Significant Spending on Capital Projects Below: Form 3 19YA Form 3 33 2015 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education Month February Fund /Department Number 220 Date Updated 3/10/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 180,000 25,128 46,435 31,326 - 133,565 26% Interest Earnings 3,000 212 1,061 487 - 1,939 35% Bond Proceeds - - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income 26,000 3,119 5,822 11,107 - 20,178 22% Transfers In - - - - - - 0% Total Revenue 211,000 28,459 53,318 42,920 - 157,682 25% Expenditures Personnel - - - - - - 0% Supplies 122,478 6,498 6,498 11,755 1,180 114,800 6% Services 190,000 22,776 38,506 5,863 - 151,494 20% Debt Service - - - - - - 0% Capital 50,000 - - 13,947 - 50,000 0% Transfers Out - - - - - - 0% Total Expenditures 362,478 29,274 45,004 31,565 1,180 316,294 13% Net (151,478) (815) 8,314 11,355 (1,180) (158,612) Cash Balance 969,595 992,580 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. The increase in Services expenditures over 2014 is due to the timing of training in 2014. This account is expected to be on budget for the year. Explain Significant Spending on Capital Projects Below: Form 3 33 Form 3 34 2015 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Month Februa Fund /Department Number 227 Date Updated 3/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 - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,200 1,257 6,463 3,931 - (2,263) 154% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 2,750 2,750 - - (2,750) 0% Transfers In - - - - - - 0% Total Revenue 4,200 4,007 9,213 3,931 - (5,013) 219% Expenditures Personnel - - - - - - 0% Supplies 67,500 - - - 67,500 - 100% Services 3,280,635 276,630 423,670 11,958 1,823,269 1,033,696 68% Debt Service - - - - - - 0% Capital 1,889,108 22,050 56,600 - 1,832,508 1 100% Transfers Out - - - - - 0% Total Expenditures 5,237,243 298,680 480,270 11,958 3,723,277 1,033,697 80% Net (5,233,043) (294,673) (471,056) (8,027) (3,723,277) (1,038,710) Cash Balance 5,392,837 7,928,006 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Of the $3.28 million budgeted for Services, $289K remains for trucking out contaminated material from Organic Resources. The remainder will be used to pay for the vacant and abandoned housing initiative. The Other Income is revenue from the Light Up South Bend program, where residents pay $250 of the cost toward installation of Lampposts in their front yards. A budget estimate of $30,000 for the year has been processed and will be entered in March. Explain Significant Spending on Capital Projects Below: $1.889 million has been budgeted in 2015 for the Smart Streets initiative. Form 3 34 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month February Fund /Department Number 244 Date Updated 3/11/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 - - 0% Charges for Services - - - - - - 0% Interest Earnings - - 19 - - (19) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - 19 215,000 - (19) 0% Expenditures Personnel - 1 21 43,391 - (21) 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - 1 21 43,391 - (21) 0% Net - (1) (2) 171,609 - 2 Cash Balance 33,649 171,609 Staffing Full Time 3.00 - - Part -Time /Seasonal /Temporary - - - Total 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: 2015 City of South Bend Monthly Financial Report Fund /Department Name Public Safety WIT Month Februa Fund /Department Number 249 Date Updated 3/11/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,466,190 538,849 1,077,698 1,063,338 - 5,388,492 17% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 209 1,367 919 - 4,633 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,472,190 539,058 1,079,066 1,064,258 - 5,393,124 17% Expenditures Personnel 7,246,551 515,347 1,247,402 1,131,036 - 5,999,149 17% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 7,246,551 515,347 1,247,402 1,131,036 - 5,999,149 17% Net (774,361) 23,711 (168,336) (66,779) - (606,025) Cash Balance 1,122,087 1,965,415 Staffing Full Time 80.00 Part -Time /Seasonal /Temporary - - Total 80.00 - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund will cover the costs of salaries and fringes for 43 police officers and 37 firefighters in 2015. Explain Significant Spending on Capital Projects Below: None. No capital equipment is purchased from this fund. Form 3 Ki: 2015 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month Februa Fund /Department Number 251 Date Updated 3/11/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,000,000 89,606 175,234 177,348 - 824,766 18% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,300 548 2,703 981 - 2,597 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 588,000 - - - - 588,000 0% Transfers In - - - - - - 0% Total Revenue 1,593,300 90,155 177,937 178,329 - 1,415,363 11% Expenditures Personnel - - - - - - 0% Supplies 380,229 - - - 229 380,000 0% Services 157,500 - - - - 157,500 0% Debt Service - - - - - - 0% Capital 1,388,492 4,853 9,007 31,522 523,464 856,021 38% Transfers Out - - - - - - 0% Total Expenditures 1,926,221 4,853 9,007 31,522 523,692 1,393,521 28% Net (332,921) 85,302 168,929 146,807 (523,692) 21,842 Cash Balance 2,613,377 2,088,182 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund receives most of its revenue through the gas tax, budgeted at $1 million for 2015. It's used predominantly for street capital projects but $537,000 is used for material for street repairs and other maintenance items. Explain Significant Spending on Capital Projects Below: Projects in 2015 include the Safe Routes to School initiative for Coquillard and Harrison schools, Bendix Drive, and the Boland bicycle trail. In February, the $523,000 encumbrance includes $260,500 for the Boland bicycle trail, $200,000 for Safe Routes to School for Harrison and Coquillard schools, and $60,000 for the Olive - Sample overpass. Form 3 37 Form 3 38 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Month Februa Fund /Department Number 252 Date Updated 3/11/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 0 0 - (0) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 0 0 0 - (0) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 0 0 0 - (0) 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. This fund will be closed out in 2015. Explain Significant Spending on Capital Projects Below: Form 3 38 Form 3 39 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant Month February Fund /Department Number 258 Date Updated 3/11/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 187,000 - 1,667 - - 185,333 1% Charges for Services - - - - - - 0% Interest Earnings 2,000 98 496 228 - 1,504 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 14,400 7,090 7,090 4,677 - 7,310 49% Transfers In - - - - - - 0% Total Revenue 203,400 7,188 9,253 4,906 - 194,147 5% Expenditures Personnel 123,657 4,320 12,888 20,503 - 110,769 10% Supplies 2,800 168 168 130 1,632 1,000 64% Services 120,900 4,679 18,173 9,659 18,462 84,265 30% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 247,357 9,167 31,229 30,293 20,094 196,035 21% Net (43,957) (1,979) (21,976) (25,387) (20,094) (1,887) Cash Balance 508,276 441,388 Staffing Full Time 2.00 2.00 2.00 Part -Time /Seasonal /Temporary 2.00 2.00 2.00 Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Human Rights Federal Grant Fund contains separate departments for EEOC and HUD grants. The Human Rights mission is to educate and promote fair housing as well as ensure that all citizens receive equal employment opportunity. Expenditures are higher than last year at this time. Higher spending occurred in the services category as a payment for services from 2014 was paid early this year. Personnel costs down this year, due to error in account being charged. The error will be corrected in March. Explain Significant Spending on Capital Projects Below: No capital projects have been budgeted for this year. Form 3 39 2015 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Month Februa Fund /Department Number 271 Date Updated 3/11/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 6 7 - (6) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 6 7 - (6) 0% Expenditures Personnel - - - - - - 0% Supplies 4,000 - - - 1,098 2,902 27% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,000 - - - 1,098 2,902 27% Net (4,000) 1 6 7 (1,098) (2,908) Cash Balance 5,318 14,379 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month February Fund /Department Number 273 Date Updated 3/10/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 17,900 - 250 3,345 - 17,650 1% Interest Earnings 100 6 30 14 - 70 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 18,000 6 280 3,359 - 17,720 2% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 18,974 96 96 3,628 2,358 16,520 13% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 18,974 96 96 3,628 2,358 16,520 13% Net (974) (90) 184 (269) (2,358) 1,201 Cash Balance 26,897 27,716 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Month Februa Fund /Department Number 280 Date Updated 3/11/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 4 2 - (4) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 4 2 - (4) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 4 2 - (4) Cash Balance 3,832 3,819 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Month February Fund /Department Number 281 Date Updated 3/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 - - - - - - 0% Interest Earnings - 6 30 13 - (30) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 6 30 13 - (30) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 6 30 13 Cash Balance 27,235 27,141 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 Form 3 44 2015 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Month Februa Fund /Department Number 289 Date Updated 3/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 - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 10,000 10,089 13,787 - - (3,787) 138% Interest Earnings - 6 41 8 - (41) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 10,095 13,828 8 - (3,828) 138% Expenditures Personnel - - - - - - 0% Supplies 31,530 602 21,542 - 9,988 68% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 31,530 602 21,542 - - 9,988 68% Net (21,530) 9,493 (7,714) 8 - (13,816) Cash Balance 31,915 16,215 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 El 1.1 2015 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue Month Februa Fund /Department Number 291 Date Updated 3/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 - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 45,000 2,400 5,400 4,800 - 39,600 12% Interest Earnings 200 23 116 48 - 84 58% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,200 2,423 5,516 4,848 - 39,684 12% Expenditures Personnel 7,500 231 231 - - 7,269 3% Supplies 8,800 - - 142 - 8,800 0% Services 79,500 1,889 1,889 1,340 77,611 2% Debt Service - - - - - - 0% Capital 25,000 - - - 20,997 4,003 84% Transfers Out - - - - - - 0% Total Expenditures 120,800 2,120 2,120 1,483 20,997 97,684 19% Net (75,600) 303 3,396 3,365 (20,997) (58,000) Cash Balance 108,796 99,083 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 El 1.1 Form 3 E, P", 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Month Februa Fund /Department Number 292 Date Updated 3/10/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 90,000 - - 66,716 - 90,000 0% Charges for Services - - - - - - 0% Interest Earnings - - 55 - - (55) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 90,000 - 55 66,716 - 89,945 0% Expenditures Personnel - - - - - - 0% Supplies 14,186 14,790 14,790 - - (604) 104% Services 959 507 507 - - 452 53% Debt Service - - - - - - 0% Capital 90,000 - - - - 90,000 0% Transfers Out - - - - - - 0% Total Expenditures 105,145 15,297 15,297 - - 89,848 15% Net (15,145) (15,297) (15,242) 66,716 - 97 Cash Balance 80,167 271,225 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Fund was set up to track the revenue and expenditures related to specific Federal Grants. Expenditures have been outlined in the grant. Explain Significant Spending on Capital Projects Below: Form 3 E, P", Form 3 47 2015 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Month February Fund /Department Number 294 Date Updated 3/10/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 7,613 18,562 17,250 - 1,438 93% Interest Earnings - 16 76 36 - (76) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In - - - - - - 0% Total Revenue 22,000 7,629 18,638 17,286 - 3,362 85% Expenditures Personnel - - - - - - 0% Supplies 1,750 - - - - 1,750 0% Services 22,000 9,673 12,398 333 - 9,602 56% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 9,673 12,398 333 - 11,352 52% Net (1,750) (2,044) 6,240 16,953 - (7,990) Cash Balance 74,524 85,036 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. The Service expenditure in 2014 was the instructor cost for a Field Training Officer course offered by the Academy. Explain Significant Spending on Capital Projects Below: Form 3 47 Form 3 48 2015 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Month Februa Fund /Department Number 295 Date Updated 3/10/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 86,658 - - - - 86,658 0% Charges for Services - - - - - - 0% Interest Earnings 350 22 115 55 - 235 33% Bond Proceeds - - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 38,000 760 1,230 1,800 - 36,770 3% Transfers In - - - - - - 0% Total Revenue 128,258 782 1,345 1,855 - 126,913 1% Expenditures Personnel - - - - - - 0% Supplies 45,735 427 20,917 30 13,445 11,373 75% Services 66,000 357 357 1,630 - 65,643 1% Debt Service - - - - - - 0% Capital 60,600 - - - - 60,600 0% Transfers Out - - - - - - 0% Total Expenditures 172,335 784 21,274 1,660 13,445 137,616 20% Net (44,077) (2) (19,929) 195 (13,445) (10,703) Cash Balance 86,305 113,539 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. In January, $20,490 was expended in Supplies for dashboard cameras for Police vehicles which will be reimbursed by Federal Grant. Explain Significant Spending on Capital Projects Below: Form 3 48 Form 3 49 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Month February Fund /Department Number 299 Date Updated 3/10/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 - 1,729 - - 73,271 2% Charges for Services - - - - - - 0% Interest Earnings 1,000 83 171 172 - 829 17% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,000 - - - - 1,000 0% Transfers In - - - - - - 0% Total Revenue 77,000 83 1,900 172 - 75,100 2% Expenditures Personnel - - - - - - 0% Supplies 54,759 3,724 13,483 1,480 14,949 26,327 52% Services 104,201 2,750 11,376 1,251 5,575 87,250 16% Debt Service - - - - - - 0% Capital 90,000 - - - - 90,000 0% Transfers Out - - - - - - 0% Total Expenditures 248,960 6,474 24,859 2,731 20,524 203,577 18% Net (171,960) (6,391) (22,959) (2,559) (20,524) (128,477) Cash Balance 322,583 382,602 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: Form 3 49 2015 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax Month February Fund /Department Number 404 Date Updated 3/11/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,859,912 738,326 1,476,652 1,440,968 - 7,383,260 17% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 58,000 3,188 16,572 7,218 - 41,428 29% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 966,059 45,265 86,605 85,732 - 879,454 9% Transfers In - - - - - - 0% Total Revenue 9,883,971 786,779 1,579,828 1,533,918 - 8,304,143 16% Expenditures Personnel 427,077 25,302 50,819 - - 376,258 12% Supplies 1,384,804 56,902 104,846 208,097 8,606 1,271,352 8% Services 8,159,164 337,823 807,867 1,392,222 433,760 6,917,537 15% Debt Service 2,487,504 2,290 755,655 397,703 - 1,731,849 30% Capital 1,701,822 - 25,325 - 865,498 811,000 52% Transfers Out 1,500,000 375,000 375,000 - - 1,125,000 25% Total Expenditures 15,660,371 797,317 2,119,512 1,998,022 1,307,863 12,232,996 22% Net (5,776,400) (10,538) (539,684) (464,104) (1,307,863) (3,928,853) Cash Balance 14,411,933 14,440,081 Staffing Full Time 4.00 2.00 2.00 Part -Time /Seasonal /Temporary - - - Total 4.00 2.00 2.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Transferred Chief Information Officer (fomerly Director of IT) and Chief Innovation Officer and (2) Business Analysts (new in 2015) to COIT. Budget increase of approximately $3.0 million in "Services" for education and travel due to IT related expenses to COIT to maintain IT professional who support the city. Increase also due to election expense as 2015 is a mayoral election year. This category also increased to include the SMART program and construction skill training and recruiting expenses. Other income in 2015 includes $438,203 in loan repayments from the UDAG Fund 410 for the 1st Source /Marriott loan based on BDC collections. Explain Significant Spending on Capital Projects Below: This year, $341,500 has been budgeted for IT upgrades such as fiber enhancements to the County City building, Central Services and the Water Works Olive St. Station. An additional $972,500 was appropriated in May 2014 to pay Transpo for the City's portion of the new CNG fueling station. An encumbered amount of $890,000 remaining has been carried forward to 2015. Lastly, approximately $470,000 has been budgeted for the corridors implementation. Form 3 50 Form 3 ti. 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax Month Februa Fund /Department Number 408 Date Updated 3/11/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,981,877 765,101 1,530,201 1,466,137 - 7,451,676 17% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 - 150,082 - - 354,578 30% Interest Earnings 40,000 2,259 11,128 5,373 - 28,872 28% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 366,608 - - 0% Transfers In - - - - - - 0% Total Revenue 9,526,537 767,360 1,691,411 1,838,118 - 7,835,126 18% Expenditures Personnel - - - 84,410 - - 0% Supplies - - - - - - 0% Services 1,222,523 174,285 309,580 278,415 429,520 483,423 60% Debt Service 1,917,313 - 438,568 962,550 - 1,478,745 23% Capital 4,000 - 3,200 150,000 800 - 100% Transfers Out 6,483,782 1,620,946 1,620,946 998,879 - 4,862,836 25% Total Expenditures 9,627,618 1,795,231 2,372,294 2,474,254 430,320 6,825,004 29% Net (101,081) (1,027,871) (680,883) (636,136) (430,320) 1,010,122 Cash Balance 9,489,343 10,205,993 Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Encumbrances include $315k to DTSB for 2014 operations. In 2015, Code Enforecement personnel expense is fully paid out of Fund 600, therefore, no additional expenses will be incurred in 2015 related to Code in this fund. Transfers out relate to: Community Investment ($1,967,638), Streets ($1,853,000), Code Enforcement ($2,033,776) and Animal Care & Control ($629,368). Explain Significant Spending on Capital Projects Below: $275,000 has been budgeted for the Potawatomi Zoological Society. Form 3 ti. Form 3 N% 2015 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Month February Fund /Department Number 410 Date Updated 3/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 - - - - - - 0% Interest Earnings 110 6 30 14 - 80 27% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 438,203 - - - - 438,203 0% Transfers In - - - - - - 0% Total Revenue 438,313 6 30 14 - 438,283 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 438,203 - - - - 438,203 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 438,203 - - - - 438,203 0% Net 110 6 30 14 - 80 Cash Balance 27,696 27,601 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. A payment of $390,000 is expected from the BDC in May, 2015. Explain Significant Spending on Capital Projects Below: Form 3 N% Form 3 53 2015 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Month Februa Fund /Department Number 655 Date Updated 3/11/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,203 72,676 72,378 - 356,324 17% Interest Earnings 2,700 217 1,115 467 - 1,585 41% Bond Proceeds - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 36,419 73,791 72,844 - 357,909 17% Expenditures Personnel 64,081 12 1,415 1,358 - 62,666 2% Supplies 6,000 6,000 0% Services 36,058 2,269 4,604 4,672 - 31,454 13% Debt Service 72,219 11,619 11,619 - 60,600 16% Capital - - - - 0% Transfers Out 350,000 - 350,000 0% Total Expenditures 528,358 2,281 17,638 17,648 - 510,720 3% Net (96,658) 34,138 56,153 55,196 - (152,811) Cash Balance 1,034,447 993,361 Staffing Full Time - - Part -Time /Seasonal /Temporary 2.16 - - Total 2.16 - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Form 3 53 2015 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Month Februa Fund /Department Number 705 Date Updated 3/10/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 4 1 - 6 40% Bond Proceeds - - - - - - 0% Donations 1,990 - 500 1,000 - 1,490 25% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 1 504 1,001 - 1,496 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,000 - - - - 2,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,000 - - - - 2,000 0% Net - 1 504 1,001 - (504) Cash Balance 3,823 2,314 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 Form 3 55 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service Month February Fund /Department Number 313 Date Updated 3/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 1,177,620 1,177,620 0% Local Income Taxes - - - - - 0% Other Taxes 96,436 4,256 8,513 14,280 87,923 9% Grants /Intergovernmental - - - - - 0% Charges for Services - - 0% Interest Earnings 41 (41) 0% Bond Proceeds - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,274,056 4,256 8,554 14,280 1,265,502 1% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 1,266,820 636,000 634,500 630,820 50% Capital - - - - 0% Transfers Out - - - - 0% Total Expenditures 1,266,820 - 636,000 634,500 630,820 50% Net 7,236 4,256 (627,446 ) (620,220) 634,682 Cash Balance (553,323) 96,115 Staffing Full Time - - Part-Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Chan esNariances 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. PILOT taxes paid by the utilities are received monthly in this fund. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. Explain Significant Spending on Capital Projects Below: None Form 3 55 2015 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month February Fund /Department Number 377 Date Updated 3/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 610,000 142,874 206,200 180,139 - 403,800 34% Charges for Services - - - - - - 0% Interest Earnings 1,100 91 618 353 - 482 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,661 - 29,523 34,608 - 31,138 49% Transfers In - - - - - - 0% Total Revenue 671,761 142,965 236,341 215,100 - 435,420 35% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 854,803 800 481,573 383,673 - 373,230 56% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 854,803 800 481,573 383,673 - 373,230 56% Net (183,042) 142,165 (245,232) (168,573) - 62,190 Cash Balance 350,860 673,484 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 Four Winds Field, Century Center, Morris Performing Arts Center and Studebaker National Museum). Four Winds Field generates the majority of PSDA revenue. The January debt service payment has been made for 2015. The final debt service payment on the 2010 Coveleski Stadium bonds (Four Winds Field) was paid January 15, 2013. Explain Significant Spending on Capital Projects Below: Form 3 ti7: Form 3 57 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month February Fund /Department Number 401 Date Updated 3/11/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 15,000 - - - - 15,000 0% Interest Earnings 100 9 45 13 - 55 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,100 9 45 13 - 15,055 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 15,100 9 45 13 - 15,055 Cash Balance 40,495 26,863 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fd 401 accounts for capital spending on Coveleski Stadium. Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. Explain Significant Spending on Capital Projects Below: Form 3 57 2015 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Month Februa Fund /Department Number 403 Date Updated 3/11/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 200 11 54 24 - 146 27% Bond Proceeds - - - - - - 0% Donations - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 200 11 54 24 - 146 27% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 49,000 - - - - 49,000 0% Transfers Out - - - - - - 0% Total Expenditures 49,000 - - - - 49,000 0% Net (48,800) 11 54 24 - (48,854) Cash Balance 49,216 49,047 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 58 2015 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Month February Fund /Department Number 405 Date Updated 3/11/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,000 159 162 87 - 33,838 0% Interest Earnings 2,200 101 533 239 - 1,667 24% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 12,000 - 4,000 7,423 - 8,000 33% Transfers In 95,500 - - - - 95,500 0% Total Revenue 143,700 260 4,695 7,748 - 139,005 3% Expenditures Personnel - - - - - - 0% Supplies 67,273 - - 116,776 17,860 49,414 27% Services 50,660 - - - 660 50,000 1% Debt Service - - - - - - 0% Capital 75,000 - - - - 75,000 0% Transfers Out - - - - - - 0% Total Expenditures 192,933 - - 116,776 18,520 174,414 10% Net (49,233) 260 4,695 (109,027) (18,520) (35,409) Cash Balance 525,859 463,864 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 59 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development Month February Fund /Department Number 406 Date Updated 3/11/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 450,000 - - - - 450,000 0% Local Income Taxes - - - - - - 0% Other Taxes 90,191 4,349 8,699 7,782 - 81,492 10% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 118 615 361 - 1,885 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 542,691 4,467 9,314 8,143 - 533,377 2% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 542,691 - 112,650 112,650 - 430,041 21% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 542,691 - 112,650 112,650 - 430,041 21% Net - 4,467 (103,336) (104,507) - 103,336 Cash Balance 477,914 681,291 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 and distributions are received from St. Joseph County in June and December. Expenditures are for debt service payments on capital leases and the due dates vary per lease. The fund is used to finance police vehicles and related equipment. The fund also receives PILOT payments from the Water Works and Wastewater utilities on a monthly basis. No new leases were added in 2014 and old leases are being paid off. Explain Significant Spending on Capital Projects Below: Form 3 60 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement Month February Fund /Department Number 407 Date Updated 3/11/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 397,000 - - - - 397,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 52 266 84 - (116) 177% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In - - - - - - 0% Total Revenue 422,150 52 266 84 - 421,884 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 365,625 - 183,750 185,250 - 181,875 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 365,625 - 183,750 185,250 - 181,875 50% Net 56,525 52 (183,484) (185,166) - 240,009 Cash Balance 65,999 (8,443) 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 $247,000 in cigarette taxes from other units of government. The hotel /motel tax distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December. In 2015, this fund is used to pay 75% of the 2011 Century Center Refunding bonds as it was in 2014. Payments on the Century Center bond are due in February and July. Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year. Explain Significant Spending on Capital Projects Below: None Form 3 61 2015 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction Month February Fund /Department Number 412 Date Updated 3/11/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 791 4,134 3,538 - 20,866 17% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 786,187 368,031 368,031 186,218 - 418,156 47% Transfers In - - - - - - 0% Total Revenue 811,187 368,822 372,166 189,756 - 439,022 46% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 3,096,061 153,529 209,388 100,669 1,556,104 1,330,569 57% Transfers Out - - - - - - 0% Total Expenditures 3,096,061 153,529 209,388 100,669 1,556,104 1,330,569 57% Net (2,284,874) 215,293 162,778 89,086 (1,556,104) (891,547) Cash Balance 3,804,440 1 7,232,984 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, derived from the State lease of the 1 -80 toll road to a private company. This fund has been used in the past to provide seed money for economic development projects at Douglas Road, Eddy Street Commons, and the Triangle Development near Notre Dame. The amounts advanced for these projects are being repaid by the respective tax increment financing (TIF) funds as per formal amortization schedules. In February, this fund received the first of two semi - annual payments on these loans, totaling $368,031 in principal and interest. Balances due as of 28 February are $787,402 from Fund 435 (Douglas Rd.) and $4,588,506 from Fund 436 (River East Residential, f /k /a Northeast Residential) Explain Significant Spending on Capital Projects Below: The 2015 budget continues funding for the Smart Streets initiative and includes $950,000 for Smart Streets, $350,000 for the King /LWW roundabout, and $30,000 for Corridor alley improvements. The $1.55 million encumbered is comprises $411,000 for the Marion St. roundabout, $194,000 for the Olive - Sample overpass, $153,000 for the Bartlett St. roundabout, $139,000 for Lincolnway West /Western Ave. Corridor improvements, and $130,000 for the Michigan and Main St. 2 -way conversions. There still remains an encumbrance of $173,000 for utility relocation for the new US 31 connector south of Ireland Rd. Form 3 62 Form 3 63 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Month February Fund /Department Number 416 Date Updated 3/10/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 100,000 1,419 9,289 15,156 - 90,711 9% Interest Earnings 1,500 113 566 226 - 934 38% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 101,500 1,532 9,855 15,382 - 91,645 10% Expenditures Personnel - - - - - - 0% Supplies 21,210 - 1,268 - 9,958 9,985 53% Services 49,038 1,665 1,665 - 15,437 31,936 35% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 70,248 1,665 2,933 - 25,394 41,920 40% Net 31,252 (134) 6,921 15,382 (25,394) 49,725 Cash Balance 522,342 472,192 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 63 2015 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Month Februa Fund /Department Number 434 Date Updated 3/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 650,000 - - - - 650,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 27 55 57 - (55) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 650,000 27 55 57 - 649,945 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 462,206 - - - - 462,206 0% Debt Service 187,794 - 3,897 20,975 - 183,897 2% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 650,000 - 3,897 20,975 - 646,103 1% Net - 27 (3,842) (20,918) - 3,842 Cash Balance 5,996 (11,380) 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 few years to make full debt payment so COIT had to make a portion of the payments. We are anticipating 2015 revenue will allow us to reimburse COIT at least a portion of its funding. Explain Significant Spending on Capital Projects Below: Form 3 64 Form 3 65 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Month February Fund /Department Number 450 Date Updated 3/10/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 16,000 953 2,178 2,130 - 13,822 14% Interest Earnings 150 14 70 28 - 80 46% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,150 967 2,248 2,157 - 13,902 14% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 16,150 - - - - 16,150 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 16,150 - - - - 16,150 0% Net - 967 2,248 2,157 - (2,248) Cash Balance 65,409 55,553 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. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund. Form 3 65 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Month February Fund /Department Number 677 Date Updated 3/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 - - - - - - 0% Interest Earnings 2,500 122 617 326 - 1,883 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 122 617 326 - 1,883 25% Expenditures Personnel - - - - - - 0% Supplies 15,000 - - 365 - 15,000 0% Services 173,824 6,370 13,213 13,869 - 160,611 8% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,824 6,370 13,213 14,234 - 175,611 7% Net (186,324) (6,248) (12,596) (13,908) - (173,728) Cash Balance 546,624 644,498 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 2015. Form 3 66 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Month February Fund /Department Number 287 Date Updated 3/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 - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - 396,727 396,727 - (396,727) 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 750,000 - - - - 750,000 0% Total Revenue 750,000 396,727 396,727 - - 353,273 53% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 750,000 35,728 35,728 - - 714,272 5% Transfers Out - - - - - - 0% Total Expenditures 750,000 35,728 35,728 - - 714,272 5% Net - 360,999 360,999 - - (360,999) Cash Balance 360,999 - Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. Explain Significant Spending on Capital Projects Below: Planned purchase of ambulance, support SUV, replacement cardiac monitors, fleet vehicle. Form 3 67 Form 3 68 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Operating Month February Fund /Department Number 288 Date Updated 3/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 - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 5,131,565 166,033 365,572 434,233 - 4,765,993 7% Interest Earnings 18,000 629 3,194 2,641 - 14,806 18% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 24,500 2,460 4,693 4,327 - 19,807 19% Transfers In 502,000 - - - - 502,000 0% Total Revenue 5,676,065 169,122 373,459 441,201 - 5,302,606 7% Expenditures Personnel 4,840,253 - - - - 4,840,253 0% Supplies 292,000 28,740 45,593 1,139 107,335 139,072 52% Services 375,337 3,222 8,263 23,639 56,975 310,099 17% Debt Service 448,773 318 226,401 20,333 2,046 220,326 51% Capital 149,003 - - 684,674 149,003 - 100% Transfers Out 750,000 - - - - 750,000 0% Total Expenditures 6,855,366 32,280 280,257 729,785 315,360 6,259,750 9% Net (1,179,301) 136,842 93,202 (288,585) (315,360) (957,144) Cash Balance 2,980,382 5,296,697 Staffing Full Time 51.00 51.00 51.00 Part -Time /Seasonal /Temporary - - - Total 51.00 51.00 51.00 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, Training Bureau, and Inspections. This Fund captures personnel and operating expenses primarily for Emergency Medical Services division and reflects a portion of the cost associated with operating ambulances. Personnel costs have been mis- classified in General Fund 101 -0901. The correction will be made in March. Explain Significant Spending on Capital Projects Below: None Form 3 68 Form 3 69 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund Month Februa Fund /Department Number 600 Date Updated 3/11/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,488,902 79,340 166,798 157,500 - 1,322,104 11% Interest Earnings 1,000 139 787 58 - 213 79% Bond Proceeds - - - - - - 0% Donations - 21 96 1,852 - (96) 0% Other Income 1,067 1,766 2,026 265 - (959) 190% Transfers In 2,663,144 665,786 665,786 576,640 - 1,997,358 25% Total Revenue 4,154,113 747,052 835,494 736,316 - 3,318,619 20% Expenditures Personnel 2,454,138 172,460 411,680 340,840 2,160 2,040,298 17% Supplies 181,483 6,351 13,900 21,942 24,519 143,064 21% Services 1,538,733 46,073 78,698 82,018 209,692 1,250,344 19% Debt Service 31,047 163 3,146 3,140 784 27,118 13% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,205,401 225,047 507,424 447,940 237,154 3,460,823 18% Net (51,288) 522,005 328,070 288,376 (237,154) (142,204) Cash Balance 1,062,839 441,050 Staffing Full Time 36.00 36.00 - Part -Time /Seasonal /Temporary 2.00 2.00 - Total 38.00 38.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund now comprises the Consolidated Building Department, Code Enforcement and Animal Control. Code and Animal Control are managed together but are run separately from the Building Department per Council's wishes. The $2.6 million transfer is from the 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: Form 3 69 2015 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages Month Februa Fund /Department Number 601 Date Updated 3/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 973,926 56,458 133,588 159,431 - 840,338 14% Interest Earnings 4,000 232 1,190 442 - 2,810 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 130,800 6,560 11,505 13,718 - 119,295 9% Transfers In - - - - - - 0% Total Revenue 1,108,726 63,250 146,283 173,591 - 962,443 13% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 746,858 100,930 149,793 169,661 13,673 583,392 22% Debt Service - - - - - - 0% Capital 184,854 12,670 52,838 1,357 144,686 (12,670) 107% Transfers Out - - - - - - 0% Total Expenditures 931,712 113,600 202,631 171,018 158,359 570,722 39% Net 177,014 (50,350) (56,348) 2,573 (158,359) 391,721 Cash Balance 1,017,281 886,761 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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: 2015 projects include: Wayne Street Facade, Elevator Repairs and Door Repairs. These projects were begun in 2014 and will be finished in 2015. Other major repairs to be undertaken in 2015 will come from the Garage Study completed in 2014. Form 3 70 Form 3 VLF 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations Month Februa Fund /Department Number 610 Date Updated 3/11/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 5,219,316 401,753 809,585 796,674 - 4,409,731 16% Interest Earnings 2,500 93 439 357 - 2,061 18% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 490,473 - - - - 490,473 0% Transfers In - - - - - - 0% Total Revenue 5,712,289 401,846 810,024 797,032 - 4,902,265 14% Expenditures Personnel 1,731,390 117,851 289,821 314,617 133 1,441,436 17% Supplies 371,208 15,383 34,515 47,512 22,783 313,910 15% Services 2,991,595 207,818 462,203 444,354 2,796 2,526,596 16% Debt Service 26,859 - - - - 26,859 0% Capital - - - - - - 0% Transfers Out 752,811 - 190,000 230,416 - 562,811 25% Total Expenditures 5,873,863 341,051 976,539 1,036,900 25,712 4,871,612 17% Net (161,574) 60,795 (166,515) (239,868) (25,712) 30,653 Cash Balance 229,300 558,774 Staffing Full Time 25.20 25.20 Part -Time /Seasonal /Temporary 8.00 3.00 Total 33.20 28.20 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Enterprise Fund charges City residents a small monthly fee to pick up and dispose of their trash at area landfills and recycling centers. The operations of Solid Waste are totally funded by these user fees, which have not seen a rate increase since 2009. Year to date expenses are in line with budget projections; revenue is down slightly. Explain Significant Spending on Capital Projects Below: Form 3 VLF 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Month Februa Fund /Department Number 611 Date Updated 3/11/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 - 33 48 - 167 17% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 752,811 - 190,000 230,416 - 562,811 25% Total Revenue 753,011 - 190,033 230,464 - 562,978 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 752,811 143 223,892 268,426 - 528,919 30% Capital - - - 75,986 - - 0% Transfers Out - - - - - - 0% Total Expenditures 752,811 143 223,892 344,413 - 528,919 30% Net 200 (143) (33,858) (113,949) - 34,058 Cash Balance 1,341 4,492 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 spending has been for lease purchase payments on prior year equipment acquisitions. Form 3 72 Form 3 73 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations Month Februa Fund /Department Number 620 Date Updated 3.10.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,638,403 1,056,116 2,116,407 2,173,709 - 12,521,996 14% Interest Earnings 9,000 891 4,582 1,601 - 4,418 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 93,580 1,109 1,222 44,434 - 92,358 1% Transfers In 19,500 780 2,334 1,958 - 17,166 12% Total Revenue 14,760,483 1,058,896 2,124,545 2,221,702 - 12,635,938 14% Expenditures Personnel 5,023,137 358,791 851,496 838,636 3,225 4,168,416 17% Supplies 1,516,896 39,127 68,756 128,455 187,940 1,260,200 17% Services 4,979,548 322,017 577,863 641,643 324,151 4,077,534 18% Debt Service 17,936 613 1,173 867 3,885 12,878 28% Capital - - - - - - 0% Transfers Out 4,306,954 652,662 814,546 682,103 - 3,492,408 19% Total Expenditures 15,844,471 1,373,209 2,313,834 2,291,704 519,202 13,011,436 18% Net (1,083,988) (314,313) (189,289) (70,002) (519,202) (375,498) Cash Balance 4,088,524 3,422,102 Staffing Full Time 70.20 68.70 Part -Time /Seasonal /Temporary 3.00 3.00 Total 73.20 71.70 - 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. Water pumpage and billed consumption for service revenues are less year to date compared to previous year. A higher encumbrance amount is attributed to value orders being issued at the beginning of the year. Explain Significant Spending on Capital Projects Below: Form 3 73 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Month Februa Fund /Department Number 622 Date Updated 3.10.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 10,000 682 3,457 1,749 - 6,543 35% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 682 3,457 1,749 - 6,543 35% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 838,893 67,463 82,845 3,600 3,489 752,559 10% Transfers Out - - - - - - 0% Total Expenditures 838,893 67,463 82,845 3,600 3,489 752,559 10% Net (828,893) (66,781) (79,387) (1,851) (3,489) (746,017) Cash Balance 3,045,894 3,529,874 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used for acquiring, constructing, and improving fixed assets. Explain Significant Spending on Capital Projects Below: Chlorine Auto Emergency Shut Off System $15,382 Trucks (2) $67,463 Encumbrance: Truck Liftgate $3,489 Form 3 74 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Month February Fund /Department Number 623 Date Updated 3.10.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 - 41 221 519 (221) 0% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 41 221 519 - (221) 0% Expenditures Personnel - - 0% Supplies 50,914 37,750 46,638 17,780 4,276 (0) 100% Services 2,171 - 2,171 0 100% Debt Service - - - - - - 0% Capital - - 219 195,292 - (219) 0% Transfers Out - - - - - 0% Total Expenditures 53,085 37,750 49,028 213,072 4,276 (219) 100% Net (53,085) (37,709) (48,807) (212,553) (4,276) (2) Cash Balance 171,482 600,077 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. A 2015 budget was not established for this fund based on assumptions of bond proceeds being 100% depleted by December 31, 2014. Intended use of remaining cash will go towards current encumbrance(s), Pinhook Project's final construction pay application and a small final meter order. Explain Significant Spending on Capital Projects Below: Water Meters $46,638 Pinhook WT Effic Improv Proj(EngFees) $219 Boland Park PRV $2,171 Encumbrance: Water Meters $4,276 Form 3 75 Form 3 W" 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Month February Fund /Department Number 624 Date Updated 3.10.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 324 1,630 720 - 4,370 27% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 324 1,630 720 - 4,370 27% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - 0% Transfers Out 6,000 324 776 720 - 5,224 13% Total Expenditures 6,000 324 776 720 - 5,224 13% Net - - 855 - - (855) Cash Balance 1,489,519 1,461,262 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 W" 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Month Februa Fund /Department Number 625 Date Updated 3.10.16 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 1 469 233 - 4,531 9% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 2,045,078 340,550 340,550 341,620 - 1,704,528 17% Total Revenue 2,050,078 340,551 341,019 341,853 - 1,709,059 17% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 2,045,078 - - - - 2,045,078 0% Capital - - - - - 0% Transfers Out 5,000 1 467 233 - 4,533 9% Total Expenditures 2,050,078 1 467 233 - 2,049,611 0% Net - 340,550 340,552 341,620 - (340,552) Cash Balance 345,208 346,957 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. The current year to date transfer in revenue is a combination of two months, both January and February. Explain Significant Spending on Capital Projects Below: Form 3 77 Form 3 78 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Month February Fund /Department Number 626 Date Updated 3.10.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 - 353 1,778 763 (1,778) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - 0% Transfers In - - - 17,128 - - 0% Total Revenue - 353 1,778 17,892 - (1,778) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 353 1,778 17,892 - (1,778) Cash Balance 1,648,455 1,583,568 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. Maximum reserve requirements have been fully satisfied. An error must have occurred during the 2015 budget process to cause no current year budget. A budget transfer form will be submitted to correct this error. Explain Significant Spending on Capital Projects Below: Form 3 78 Form 3 79 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Month February Fund /Department Number 629 Date Updated 3.10.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 455 2,295 1,006 - 6,205 27% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 154,249 150,228 150,228 53,507 - 4,021 97% Total Revenue 162,749 150,683 152,523 54,513 - 10,226 94% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 455 1,092 1,006 - 7,408 13% Total Expenditures 8,500 455 1,092 1,006 - 7,408 13% Net 154,249 150,228 151,431 53,507 - 2,818 Cash Balance 2,235,267 2,085,039 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 monies was transferred in this month to comply 100% with 2015's requirement. Explain Significant Spending on Capital Projects Below: Form 3 79 Form 3 80 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Month Februa Fund /Department Number 640 Date Updated 3/11/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 548,000 52,458 102,981 93,510 - 445,019 19% Interest Earnings 1,200 332 1,662 679 - (462) 138% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 549,200 52,790 104,643 94,188 - 444,557 19% Expenditures Personnel 206,842 12,259 32,126 22,201 174,716 16% Supplies 28,603 2,299 2,461 1,124 26,142 9% Services 281,802 42,586 44,006 24,136 90,380 147,416 48% Debt Service 28,456 28,456 0% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 545,703 57,144 78,593 47,461 90,380 376,730 31% Net 3,497 (4,354) 26,050 46,728 (90,380) 67,827 Cash Balance 1,530,104 1,409,301 Staffing Full Time 2.20 1.85 - Part -Time /Seasonal /Temporary - - - Total 2.20 1.85 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Form 3 80 Form 3 81 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations Month February Fund /Department Number 641 Date Updated 3/11/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 35,209,467 2,782,007 5,556,698 5,297,947 - 29,652,769 16% Interest Earnings 22,000 2,011 9,797 3,351 - 12,203 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 88,000 5,069 7,577 9,114 - 80,423 9% Transfers In 15,000 747 1,792 1,643 - 13,208 12% Total Revenue 35,334,467 2,789,835 5,575,864 5,312,055 - 29,758,603 16% Expenditures Personnel 7,402,560 548,251 1,328,386 1,331,626 - 6,074,174 18% Supplies 2,154,745 106,416 202,488 259,423 185,376 1,766,881 18% Services 13,178,782 871,614 1,653,295 1,584,782 990,296 10,535,191 20% Debt Service 585,187 610 133,557 132,699 - 451,630 23% Capital - - - - - - 0% Transfers Out 14,875,700 1,029,622 1,803,158 3,679,802 - 13,072,542 12% Total Expenditures 38,196,974 2,556,513 5,120,884 6,988,332 1,175,672 31,900,418 16% Net (2,862,507) 233,322 454,980 (1,676,277) (1,175,672) (2,141,815) Cash Balance 9,260,229 5,530,092 Staffing Full Time 95.25 87.40 Part -Time /Seasonal /Temporary 6.62 2.00 Total 101.87 89.40 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This enterprise fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Debt service payments are made in accordance with City amortization schedules. January had three payrolls, which makes personnel costs higher than normal. Large encumbrances for supplies and services contribute to the percentage of budget used. 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 81 Form 3 E:A 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Month Februa Fund /Department Number 642 Date Updated 3/11/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 815 4,199 2,085 - 34,801 11% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 5,359,000 - - 2,000,000 - 5,359,000 0% Total Revenue 5,398,000 815 4,199 2,002,085 - 5,393,801 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 36,043 3,661 11,901 22,841 24,142 0 100% Debt Service - - - - - - 0% Capital 9,035,667 43,443 74,319 1,372,588 3,615,479 5,345,870 41% Transfers Out - - - - - - 0% Total Expenditures 9,071,710 47,104 86,219 1,395,429 3,639,621 5,345,870 41% Net (3,673,710) (46,290) (82,020) 606,657 (3,639,621) 47,931 Cash Balance 3,669,702 4,651,223 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 replacement of the Calvert St. /Ethanol Lift station, WWTP stand -by power, sewer slip lining and manhole rehab. Explain Significant Spending on Capital Projects Below: Year to Date totals spent include: Wastewater Treatment Plant Primary Clarifier rehab $42,776, Sewer Dept vehicle $43,443. Form 3 E:A Form 3 83 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Month February Fund /Department Number 643 Date Updated 3/11/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 747 3,767 1,643 - 11,233 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 235,612 256,086 256,086 129,964 - (20,474) 109% Total Revenue 250,612 256,833 259,853 131,607 - (9,241) 104% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 747 1,792 1,643 - 13,208 12% Total Expenditures 15,000 747 1,792 1,643 - 13,208 12% Net 235,612 256,086 258,061 129,964 - (22,449) Cash Balance 3,678,649 3,422,564 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. This month's transfer to this fund was done to adjust the balance to stay in compliance. Explain Significant Spending on Capital Projects Below: Form 3 83 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Month Februa Fund /Department Number 647 Date Updated 3/11/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 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 1 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - 1 - - Cash Balance 0 1,142 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. There is no 2015 budget. The $.14 cash balance needs to be removed. Explain Significant Spending on Capital Projects Below: Form 3 84 Form 3 85 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Month Februa Fund /Department Number 649 Date Updated 3/11/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 7,000 265 1,050 561 - 5,950 15% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,281,088 773,536 1,547,073 1,549,838 - 7,734,016 17% Total Revenue 9,288,088 773,801 1,548,123 1,550,399 - 7,739,965 17% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,500 850 1,850 1,350 - 650 74% Debt Service 9,279,609 - - - - 9,279,609 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,282,109 850 1,850 1,350 - 9,280,259 0% Net 5,979 772,951 1,546,273 1,549,049 - (1,540,294) Cash Balance 2,336,609 2,331,856 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. 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 85 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Month February Fund /Department Number 653 Date Updated 3/11/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 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. The account was fully funded for existing debt in 2013. A reconcilliation of the account is done monthly. Explain Significant Spending on Capital Projects Below: Form 3 86 Form 3 87 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Month Februa Fund /Department Number 658 Date Updated 3/11/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 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 1 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - 1 - - Cash Balance 2 2,216 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This 2010 bond has been fully spent. There is no 2015 budget. The $2.05 cash balance needs to be removed. Explain Significant Spending on Capital Projects Below: Form 3 87 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 Month Februa Fund /Department Number 659 Date Updated 3/11/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 330 1,807 3,844 - 4,193 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 330 1,807 3,844 - 4,193 30% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 323,670 - 3,917 - 13,753 306,001 5% Debt Service - - - - - - 0% Capital 3,388,168 502,799 641,919 541,236 929,777 1,816,472 46% Transfers Out - - - - - - 0% Total Expenditures 3,711,838 502,799 645,836 541,236 943,530 2,122,472 43% Net (3,705,838) (502,468) (644,029) (537,393) (943,530) (2,118,279) Cash Balance 955,357 7,311,106 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,237,881, Diamond Ave. Trunk Sewer, Phase III $248,000, St. Joseph River CSO Stabilization $217,831, Secondary Clarifier Upgrade $367,788, Wastewater Treatment Plant Digester Upgrade $5,639,949. Form 3 88 Form 3 89 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Month Februa Fund /Department Number 661 Date Updated 3/11/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 20,000 3,669 18,638 9,059 - 1,362 93% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 20,000 3,669 18,638 9,059 - 1,362 93% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,000,000 - - - - 1,000,000 0% Debt Service - - - - - - 0% Capital 15,624,275 249,076 288,246 488,626 1,448,955 13,887,074 11% Transfers Out - - - - - - 0% Total Expenditures 16,624,275 249,076 288,246 488,626 1,448,955 14,887,074 10% Net (16,604,275) (245,406) (269,608) (479,566) (1,448,955) (14,885,712) Cash Balance 16,549,657 17,819,460 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 included: 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. Spending in 2015 has been for Prairie Ave. Sewer Separation $16,380, Fairfax Sewer $12,160, East Bank Sewer Separation -Phase 5 $124,280, and Sewer Sensory Control Network $81,472. Form 3 89 2015 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund Month February Fund /Department Number 664 Date Updated 3/11/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 5 2 - (5) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 5 2 - (5) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 5 2 - (5) Cash Balance 4,485 4,470 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. The remaining cash balance should be transferred to an appropriate fund, so this fund can be closed out. Explain Significant Spending on Capital Projects Below: Form 3 1!I0: Form 3 Wi 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Month Februa Fund /Department Number 670 Date Updated 3/11/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,436 656,725 656,725 656,725 - 656,711 50% Grants /Intergovernmental - - - - - - 0% Charges for Services 3,194,126 126,779 159,764 275,113 - 3,034,362 5% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In - - - - - - 0% Total Revenue 4,532,562 783,504 816,489 931,838 - 3,716,073 18% Expenditures Personnel 2,505,817 156,159 302,077 358,174 - 2,203,740 12% Supplies 496,646 30,902 50,504 55,648 - 446,142 10% Services 1,286,148 98,389 239,367 328,230 - 1,046,781 19% Debt Service - - - - - - 0% Capital 243,951 - - - - 243,951 0% Transfers Out - - - - - - 0% Total Expenditures 4,532,562 285,450 591,948 742,052 - 3,940,614 13% Net - 498,054 224,541 189,786 - (224,541) Cash Balance 1,310,487 1,118,602 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. Covered by hotel /motel tax revenue which is received twice per year. The first installment was received in February 2015. Other income includes charges to large conferences for electric costs. Lower January 2015 revenues due mainly to events that were booked in 2014 were either not rebooked or are shows that are only booked every other year. Explain Significant Spending on Capital Projects Below: Form 3 Wi Form 3 1% 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Month Februa Fund /Department Number 671 Date Updated 3/11/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 21 45 30 - 455 9% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 21 45 30 - 455 9% Expenditures Personnel - - - - - - 0% Supplies - 41,156 41,156 - - (41,156) 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - 25,000 25,000 - - (25,000) 0% Transfers Out - - - - - - 0% Total Expenditures - 66,156 66,156 - - (66,156) 0% Net 500 (66,135) (66,111) 30 - 66,611 Cash Balance 1,352,551 1,757,727 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. SMG contributed a one time amount of $575,000 to cover capital expenses in August 2013. The remainder of these funds have been appropriated for spending during 2015. $25,000 will be appropriated to help pay for the Wall of Fame in conjunction with the South Bend Alumni Association. Explain Significant Spending on Capital Projects Below: Form 3 1% Form 3 F!IN 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month Februa Fund /Department Number 222 Date Updated 3/10/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 8,069,157 681,732 1,316,570 1,335,295 - 6,752,587 16% Interest Earnings 3,400 257 1,490 531 - 1,910 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 48,540 6,614 26,432 73,776 - 22,108 54% Transfers In - - - - - - 0% Total Revenue 8,121,097 688,603 1,344,491 1,409,603 - 6,776,606 17% Expenditures Personnel 3,099,267 211,727 502,373 482,091 - 2,596,894 16% Supplies 167,428 (2,677) (8,996) (52,784) 9,184 167,239 0% Services 4,611,385 412,785 806,608 852,754 2,786,751 1,018,026 78% Debt Service 9,155 - 1,414 1,624 840 6,901 25% Capital 120,000 - - - 120,000 - 100% Transfers Out 271,850 - - - - 271,850 0% Total Expenditures 8,279,085 621,835 1,301,399 1,283,684 2,916,775 4,060,911 51% Net (157,988) 66,768 43,092 125,919 (2,916,775) 2,715,695 Cash Balance 1,676,827 1,683,633 Staffing Full Time 42.00 38.00 38.00 Part -Time /Seasonal /Temporary 2.00 1.00 1.00 Total 44.00 39.00 39.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. The supply acct. goes up and down, depending on vehicle repairs. In Feb we had 1,397 vehicle repairs. Average Fuel prices for February is $1.79 for Unleaded and $2.18 for Diesel. Budgeted amount per gallon is $3.45. The Office of Sustainability hosted its first Green Ribbon Commission meeting of 2015 on Feb 26th. Explain Significant Spending on Capital Projects Below: The capital expenses for 2015 were moved to a new Fund #224 for $271,850. We are transfering monies out of our cash reserve over to fund 224 to cover our 2015 capital expenses. We had $120,00 roll over from 2014 to 2015 for capital expenses to converting our garage so we can work on CNG vehicles. Form 3 F!IN 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Capital Month Februa Fund /Department Number 224 Date Updated 3/10/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 271,850 - - - - 271,850 0% Total Revenue 271,850 - - - - 271,850 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 271,850 - - - - 271,850 0% Transfers Out - - - - - - 0% Total Expenditures 271,850 - - - - 271,850 0% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a new fund for 2015. Revenues are a transfer from Central Services. Explain Significant Spending on Capital Projects Below: Capital projects for 2015 include a roof replacement for the Equipment Services building ($171,850), six (6) mobile comm lifts ($10,000 each) and an inground hoist ($40,000). Form 3 1*21 Form 3 147 2015 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance Month Februa Fund /Department Number 226 Date Updated 3/10/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,222,727 101,897 201,190 470,314 - 1,021,537 16% Interest Earnings 20,500 1,210 6,261 2,573 - 14,239 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 - - 36,377 - 17,000 0% Transfers In - - - - - - 0% Total Revenue 1,260,227 103,108 207,451 509,264 - 1,052,776 16% Expenditures Personnel 212,170 21,749 42,663 33,028 - 169,507 20% Supplies 30,189 2,712 5,067 2,702 2,490 22,632 25% Services 2,814,432 231,092 470,062 558,117 52,244 2,292,126 19% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,056,791 255,553 517,792 593,848 54,734 2,484,266 19% Net (1,796,564) (152,446) (310,340) (84,584) (54,734) (1,431,490) Cash Balance 5,369,733 5,106,829 Staffing Full Time 3.00 2.00 Part -Time /Seasonal /Temporary - - Total 3.00 2.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. Explain Significant Spending on Capital Projects Below: Form 3 147 2015 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Month February Fund /Department Number 278 Date Updated 3/10/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 61,100 4,680 11,740 11,890 - 49,360 19% Interest Earnings 2,000 114 569 226 - 1,431 28% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 61,100 4,680 11,740 11,890 - 49,360 19% Transfers In - - - - - - 0% Total Revenue 124,200 9,474 24,049 24,006 - 100,151 19% Expenditures Personnel - - - - - - 0% Supplies 61,100 - - - 61,100 0% Services 10,000 - - - - 10,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 71,100 - - - - 71,100 0% Net 53,100 9,474 24,049 24,006 - 29,051 Cash Balance 540,061 476,959 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 in 2015.The cash reserve in this fund has increased in recent years and is expected to increase during 2015. Claims have been minimal in this fund since it was created. This fund is classified as an Internal Service Fund for financial reporting. No liability claims were paid during 2014. Explain Significant Spending on Capital Projects Below: None Form 3 Xt, Form 3 IM 2015 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits Month February Fund /Department Number 711 Date Updated 3/10/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 16,200,000 1,225,029 2,450,793 1,925,005 - 13,749,207 15% Interest Earnings 23,345 1,021 4,754 2,961 - 18,591 20% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 177 19,399 17 - (19,399) 0% Transfers In - - - - - - 0% Total Revenue 16,223,345 1,226,227 2,474,946 1,927,982 - 13,748,399 15% Expenditures Personnel 4,326 1 2 - - 4,324 0% Supplies 21,875 1,704 1,784 121 2,188 17,903 18% Services 805,520 75,100 148,972 115,087 231,302 425,246 47% Insurance 15,865,214 886,820 1,843,639 2,219,352 51,297 13,970,278 12% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 16,696,935 963,626 1,994,397 2,334,560 284,787 14,417,751 14% Net (473,590) 262,602 480,549 (406,578) (284,787) (669,352) Cash Balance 4,537,536 5,254,869 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Month February Fund /Department Number 713 Date Updated 3/11/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 225,996 8,473 16,947 17,061 - 209,049 7% Interest Earnings 800 52 264 128 - 536 33% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 226,796 8,525 17,211 17,188 - 209,585 8% Expenditures Personnel 200,000 4,601 7,561 24,693 - 192,439 4% Supplies - - - - - - 0% Services 26,796 566 7,732 1,204 13,200 5,864 78% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 226,796 5,167 15,293 25,897 13,200 198,303 13% Net - 3,358 1,918 (8,708) (13,200) 11,282 Cash Balance 243,088 251,322 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. Due to continued favorable claims, the fund will only charge departments at 0.25% unless the claims increase substantially. For the 2015 budget, all outplacement services will be paid through this account. These were paid through the General Fund in previous years, however, due to the nature of outplacement claims, the Unemployment Fund is a more appropriate place from which to pay the costs. The Unemployment Compensation Fund is classified as an Internal Service Fund for financial reporting. Claims continue to be lower than anticipated. Explain Significant Spending on Capital Projects Below: None Form 3 1*x1 Form 3 1*111 2015 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension Month Februa Fund /Department Number 701 Date Updated 3/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 - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,207,092 - - - - 5,207,092 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,500 130 818 488 - 3,682 18% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,211,592 130 818 488 - 5,210,774 0% Expenditures Personnel 5,661,579 441,157 882,266 905,551 - 4,779,313 16% Supplies 200 - - - - 200 0% Services 4,800 119 202 156 - 4,598 4% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,666,579 441,276 882,468 905,707 - 4,784,111 16% Net (454,987) (441,146) (881,650) (905,219) - 426,663 Cash Balance (242,522) 33,502 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Pension Month Februa Fund /Department Number 702 Date Updated 3/9/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,350,000 - - - - 6,350,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 230 1,363 875 - 4,637 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,000 - - - - 4,000 0% Transfers In - - - - - - 0% Total Revenue 6,360,000 230 1,363 875 - 6,358,637 0% Expenditures Personnel 6,827,035 524,012 1,061,026 1,186,497 - 5,766,009 16% Supplies 800 - - - - 800 0% Services 4,400 - 98 102 - 4,302 2% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,832,235 524,012 1,061,124 1,186,599 - 5,771,111 16% Net (472,235) (523,782) (1,059,761) (1,185,724) - 587,526 Cash Balance 51,009 522,932 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 2015 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Month Februa Fund /Department Number 730 Date Updated 3/11/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 150 6 31 18 - 119 21% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 150 6 31 18 - 119 21% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 20,000 - - - 20,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 20,000 - - - - 20,000 0% Net (19,850) 6 31 18 - (19,881) Cash Balance 28,409 36,952 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 Form 3 102 2015 City of South Bend Monthly Financial Report Fund /Department Name River West Development Area Airport TIF Month February Fund /Department Number 324 1 Date Updated 3/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 13,400,000 - - - - 13,400,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - 2,785 - - (2,785) 0% Interest Earnings 75,000 9,190 38,912 11,732 - 36,088 52% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,400,000 23,811 41,338 - - 1,358,662 3% Transfers In 5,000 227 544 515 - 4,456 11% Total Revenue 14,880,000 33,228 83,579 12,247 - 14,796,421 1% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 7,094,469 306,235 469,533 389,938 1,865,318 4,759,618 33% Debt Service 6,466,854 1,240,581 3,353,271 1,262,971 - 3,113,583 52% Capital 34,149,274 138,175 138,626 1,193 2,304,319 31,706,329 7% Transfers Out - - - - - - 0% Total Expenditures 47,710,597 1,684,991 3,961,430 1,654,102 4,169,637 39,579,530 17% Net (32,830,597) (1,651,763) (3,877,851) (1,641,855) (4,169,637) (24,783,109) Cash Balance 27,519,308 23,378,275 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: While one can find usefulness in reviewing revenue trends in TIF funds from one year to the next, because projects change wildly from one year to the next, it is less meaningful to examine year to date expenditures against the prior year to date. Due to changes in boundry, this area now includes the former Central Medical District (Fund 426) and a portion of South Bend Central Development Area (Fund 420). Explain Significant Spending on Capital Projects Below: Major projects carried out in 2014 were: Renaissance District Phase II; the Studebaker /Oliver Project; and continued Ignition Park South & East acquisitions. In 2015, the major projects thus far approved are: the Bartlett Roundabout, Ignition Park infrastructure, LaSalle Hotel, ND /GE Turbo Project, Nello and Studebaker Envionmental. Form 3 102 Form 3 `rsx3 2015 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown Month Februa Fund /Department Number 420 1 Date Updated 3/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 3,500,000 - - - - 3,500,000 0% Local Income Taxes - - - - - - 0% Other Taxes 489,500 - - - - 489,500 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,000 2,981 3,146 5,252 - 30,854 9% Interest Earnings 37,596 880 880 7,947 - 36,716 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 277,106 - - 46,935 - 277,106 0% Transfers In 6,000 379 909 860 - 5,091 15% Total Revenue 4,344,202 4,240 4,935 60,994 - 4,339,267 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 485,622 - 6,768 75,849 - 478,854 1% Debt Service 2,879,693 (957,248) - 1,239,010 - 2,879,693 0% Capital 1,171,854 - - 15,336 - 1,171,854 0% Transfers Out - - - - - - 0% Total Expenditures 4,537,169 (957,248) 6,768 1,330,195 - 4,530,401 0% Net (192,967) 961,488 (1,833) (1,269,201) - (191,134) Cash Balance 4,086,639 1,335,273 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: In 2015 SBCDA is eliminated and all funds will be distributed between Fund 324 River West and Fund 429 River East. This is the result of the TIF realignment. Explain Significant Spending on Capital Projects Below: Form 3 `rsx3 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Month Februa Fund /Department Number 422 1 Date Updated 3/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 420,000 - - - - 420,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 261 1,257 283 - 743 63% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 422,000 261 1,257 283 - 420,743 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 30,600 15,300 15,300 319 15,300 - 100% Debt Service - - - - - - 0% Capital 730,300 - - - - 730,300 0% Transfers Out - - - - - - 0% Total Expenditures 760,900 15,300 15,300 319 15,300 730,300 4% Net (338,900) (15,039) (14,043) (36) (15,300) (309,557) Cash Balance 1,181,706 612,926 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 committed thus far in 2015 are: City Cemetary Project. Explain Significant Spending on Capital Projects Below: Major projects committed thus far in 2015 are: City Cemetery Project. Other TIF eligible development projects for this TIF area will be determined by department staff and the Mayor's office as the year progresses. Form 3 104 Form 3 11111 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Month Februa Fund /Department Number 425 Date Updated 3/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 - - - - - - 0% Interest Earnings - 20 98 44 - (98) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 189,123 12,951 31,101 25,302 - 158,022 16% Transfers In - - - - - - 0% Total Revenue 189,123 12,971 31,199 25,346 - 157,924 16% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 154,716 9,662 16,624 17,742 - 138,092 11% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 154,716 9,662 16,624 17,742 - 138,092 11% Net 34,407 3,309 14,575 7,604 - 19,832 Cash Balance 187,102 140,671 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 `IIII 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Month February Fund /Department Number 426 1 Date Updated 3/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 625,000 - - - - 625,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 7,000 501 2,442 1,512 - 4,558 35% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 632,000 501 2,442 1,512 - 629,558 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 179,125 - - 2,452 3,613 175,512 2% Debt Service - - - - - - 0% Capital - - - 166,772 - - 0% Transfers Out 2,296,908 - - - 2,296,908 0% Total Expenditures 2,476,033 - - 169,224 3,613 2,472,420 0% Net (1,844,033) 501 2,442 (167,712) (3,613) (1,842,862) Cash Balance 2,296,975 3,064,700 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: In 2015 Central Medical Service Area is eliminated and all funds will be distributed to Fund 324 River West. This is the result of the TIF realignment. Explain Significant Spending on Capital Projects Below: Form 3 `IIII 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Development Area NE Dev TIF Month February Fund /Department Number 429 1 Date Updated 3/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 820,000 - - - - 820,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 7,000 993 4,851 1,453 - 2,149 69% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 19,357 - - (19,357) 0% Transfers In - - - - - - 0% Total Revenue 827,000 993 24,208 1,453 - 802,792 3% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 126,044 - 35,090 617 63,644 27,310 78% Debt Service - - - - - - 0% Capital 7,113,480 5,000 82,866 - 110,129 6,920,485 3% Transfers Out - - - - - - 0% Total Expenditures 7,239,524 5,000 117,956 617 173,773 6,947,795 4% Net (6,412,524) (4,007) (93,748) 836 (173,773) (6,145,003) Cash Balance 4,462,732 3,009,627 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. Due to changes in boundary, this area now includes a portion of South Bend Central Development Area (Fund 420). Explain Significant Spending on Capital Projects Below: Projects committed to in 2015 include: 5 Points Utility Study, Hill Street Improvements and the NW Corner of Hill & Colfax. Form 3 107 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 Month February Fund /Department Number 430 Date Updated 3/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 2,400,000 - - - - 2,400,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10,000 1,025 5,168 1,648 - 4,832 52% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,410,000 1,025 5,168 1,648 - 2,404,832 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 580,022 24,431 57,884 85,986 497,137 25,001 96% Debt Service - - - - - - 0% Capital 2,262,513 - 401,917 4,261 206,925 1,653,671 27% Transfers Out - - - - - - 0% Total Expenditures 2,842,535 24,431 459,801 90,247 704,062 1,678,672 41% Net (432,535) (23,406) (454,633) (88,599) (704,062) 726,160 Cash Balance 4,502,658 3,351,049 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. Explain Significant Spending on Capital Projects Below: Projects committed to in 2014 were: completion of the Fellows Street Corridor Project; Ireland & Miami Area Improvements; Main /Lafayette Crossover Project and Walter Street Sidewalks. Projects committed to in 2015 include: Chippewa Improvements, Fellows Street Corridor, Ireland & Miami Area Improvements, Ireland Road Acquisition Services, Main - Lafayette Crossover Connector and MetroNet. Form 3 `[IN 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Month Februa Fund /Department Number 435 1 Date Updated 3/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 320,000 - - - - 320,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 750 48 209 131 - 541 28% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 320,750 48 209 131 - 320,541 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,200 - - 160 4,200 - 100% Debt Service 341,189 169,620 169,620 - - 171,569 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 345,389 169,620 169,620 160 4,200 171,569 50% Net (24,639) (169,572) (169,411) (29) (4,200) 148,972 Cash Balance 52,019 294,571 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] 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Residential NE Res TIF Month February Fund /Department Number 436 1 Date Updated 3/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 2,599,000 - - - - 2,599,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 352 1,567 1,164 - 3,433 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,604,000 352 1,567 1,164 - 2,602,433 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 3,425,632 246,589 1,710,589 1,650,718 - 1,715,043 50% Capital - - - 214,573 - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,425,632 246,589 1,710,589 1,865,291 - 1,715,043 50% Net (821,632) (246,237) (1,709,022) (1,864,127) - 887,390 Cash Balance (3,519) 689,952 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. Debt Service is related to the Eddy Street Commons Bonds Explain Significant Spending on Capital Projects Below: Form 3 `sle] 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Month Februa Fund /Department Number 433 Date Updated 3/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 - - - - - - 0% Interest Earnings 252 2 11 12 - 241 4% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 252 2 11 12 - 241 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 6,000 - - 6,072 - 6,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,000 - - 6,072 - 6,000 0% Net (5,748) 2 11 (6,060) - (5,759) Cash Balance 10,101 19,688 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Month February Fund /Department Number 439 Date Updated 3/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 - - - - - - 0% Interest Earnings 4,404 1,097 5,529 1,824 - (1,125) 126% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 4,404 1,097 5,529 1,824 - (1,125) 126% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 5,000,000 - - - - 5,000,000 0% Transfers Out - - - - - - 0% Total Expenditures 5,000,000 - - - - 5,000,000 0% Net (4,995,596) 1,097 5,529 1,824 Cash Balance 5,026,090 3,684,420 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Capital funds are to be expended in Ignition Park and Innovation Park. Form 3 ISN Form 3 1§93 2015 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Month February Fund /Department Number 454 Date Updated 3/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 - - - - - - 0% Interest Earnings 1,500 82 416 186 - 1,084 28% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 82 416 186 - 1,084 28% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 82 416 186 - 1,084 Cash Balance 377,857 376,558 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations Month Februa Fund /Department Number 619 Date Updated 3/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 1,696,879 20,083 119,238 156,016 - 1,577,641 7% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,696,879 20,083 119,238 156,016 - 1,577,641 7% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,661,128 89,358 158,413 101,236 - 1,502,715 10% Debt Service - - - - - - 0% Capital 10,578 - - - - 10,578 0% Transfers Out - - - - - - 0% Total Expenditures 1,671,706 89,358 158,413 101,236 - 1,513,293 9% Net 25,173 (69,275) (39,175) 54,780 - 64,348 Cash Balance 60,141 132,995 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Course operations under outside contract with Billy Casper Golf so all expenses except capital are shown under Services to show consistently with Parking Garages and Redevelopment Retail. The course has been sold to a private owner. The sale is expected to be completed on 23 February 2015. Explain Significant Spending on Capital Projects Below: Equipment payments Form 3 ISO 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Month February Fund /Department Number 315 Date Updated 3/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 - - - - - - 0% Interest Earnings 5,000 227 1,143 515 - 3,857 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 227 1,143 515 - 3,857 23% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 227 544 515 - 4,456 11% Total Expenditures 5,000 227 544 515 - 4,456 11% Net - - 599 - - (599) Cash Balance 1,038,904 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Month Janua Fund /Department Number 317 Date Updated 2/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 - - - - - - 0% Interest Earnings 1,800 110 556 249 - 1,244 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,800 110 556 249 - 1,244 31% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,800 110 556 249 - 1,244 Cash Balance 505,459 503,722 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 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Month February Fund /Department Number 328 Date Updated 3/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 - - - - - - 0% Interest Earnings 6,000 379 1,911 860 - 4,089 32% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 379 1,911 860 - 4,089 32% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 379 909 860 - 5,091 15% Total Expenditures 6,000 379 909 860 - 5,091 15% Net - - 1,002 - Cash Balance 1,735,840 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 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Month February Fund /Department Number 432 Date Updated 3/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 - - - - - - 0% Interest Earnings 25,000 1,268 6,514 3,039 - 18,486 26% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 1,268 6,514 3,039 - 18,486 26% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 203,000 201,724 201,724 656 - 1,276 99% Debt Service 488,380 - 357,545 353,950 - 130,835 73% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 691,380 201,724 559,269 354,606 - 132,111 81% Net (666,380) (200,456) (552,755) (351,567) - (113,625) Cash Balance 5,950,099 6,617,119 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. Explain Significant Spending on Capital Projects Below: Form 3 `sM