The URL can be used to link to this page

Home My WebLink About01-2015 Departmental Financial ReportPeriod Ending: January 31, 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 56 Debt Service /Capital Project Funds 69 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 January 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 January 31, 2015, total revenue for the year was $12,866,557, 5% of estimated revenue. As of January, 2014 total revenue received was $15,140,898 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 January 31, 2015, total expenditures were $26,687,527 and outstanding encumbrances were $30,678,510, a total of $57,366,307 which represents 17% of the amended expenditure budget. Encumbrances are either holdovers from previous years or obligations for the remainder of the year. If encumbrances were excluded, expenditures were 8% of the amended expenditure budget at the end of the period. Total expenditures were $30,175,198 as of January 31, 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. Fund Type Dept Name City of South Bend Monthly Department Financial Report REVENUE SUMMARY January 31, 2015 City Funds General Fund 52,642,236 1,316,569 1,316,569 1,025,131 2,297,505 3% Special Revenue 102 Rainy Day 34,680 7,630 7,630 1,105 27,050 22% 201 Parks & Recreation 11,030,715 124,803 124,803 92,435 10,905,912 1% 202 Motor Vehicle Highway 8,931,300 716,020 716,020 285,523 8,215,280 8% 203 Recreation Nonreverting 1,578,935 65,607 65,607 76,057 1,513,328 4% 209 Studebaker - Oliver Reverting Grants 574,000 959 959 139 573,041 0% 210 Economic Development State Grants 1,673,510 290 290 85 1,673,220 0% 211 Community & Economic Development Admn. 2,631,625 14,699 14,699 435,848 2,616,926 1% 212 Community & Economic Development 4,100,000 99,143 99,143 125,073 4,000,857 2% 216 Police State Seizures 35,900 162 162 20 35,738 0% 217 Gift, Donation, Bequest 216,100 1,618 1,618 10 214,482 1% 218 Police Curfew Violations 1,025 11 11 14 1,014 1% 220 Law Enforcement Continuing Education 211,000 24,859 24,859 30,248 186,141 12% 227 Loss Recovery 4,200 5,206 5,206 1,018 (1,006) 124% 244 Emergency Phone System 0 19 19 215,000 (19) 0% 249 Public Safety LOIT 6,470,911 540,008 540,008 531,895 5,930,903 8% 251 Local Roads & Streets 1,593,300 87,782 87,782 87,148 1,505,518 6% 258 Human Rights Federal Grant 203,400 2,065 2,065 89 201,335 1% 271 Eastrace Waterway 0 5 5 2 (5) 0% 273 Morris PAC / Palais Royale Marketing 18,000 274 274 354 17,726 2% 280 Police Block Grants 0 3 3 0 (3) 0% 281 Economic Develop. Commission - Revenue Bonds 0 24 24 3 (24) 0% 288 Emergency Medical Services Operating 5,676,065 204,337 204,337 154,587 5,471,728 4% 289 HAZMAT 10,000 3,732 3,732 2 6,268 37% 291 Indiana River Rescue 45,200 3,093 3,093 2,412 42,107 7% 292 Police Grants 90,000 55 55 66,716 89,945 0% 294 Regional Police Academy 22,000 11,010 11,010 13,159 10,990 50% 295 COPS MORE Grant 128,258 564 564 863 127,694 0% 299 Police Federal Drug Enforcement 77,000 1,817 1,817 91 75,183 2% 404 County Option Income Tax 9,881,783 793,050 793,050 765,453 9,088,733 8% 408 Economic Development Income Tax 9,515,499 924,052 924,052 746,358 8,591,447 10% 410 Urban Development Action Grant 438,313 24 24 4 438,289 0% 655 Project Releaf 431,700 37,371 37,371 36,373 394,329 9% 705 Police K -9 Unit 2,000 503 503 0 1,497 25% Special Revenue Total 65,626,419 3,670,797 3,670,797 3,668,082 61,955,622 6% City Debt Service 313 Football Hall of Fame Debt Service 1,274,056 4,297 4,297 7,140 1,269,759 0% City Debt Service Total 1,274,056 4,297 4,297 7,140 1,269,759 0% Capital Project 287 Emergency Medical Services Capital 750,000 0 0 0 750,000 0% 377 Professional Sports Development 671,761 93,375 93,375 101,256 578,386 14% 401 Coveleski Stadium Capital 15,100 36 36 3 15,064 0% 403 Zoo Endowment 200 43 43 6 157 22% 405 Park Nonreverting Capital 143,700 4,435 4,435 79 139,265 3% 406 Cumulative Capital Development 542,691 4,847 4,847 3,987 537,844 1% 407 Cumulative Capital Improvement 422,150 215 215 21 421,935 0% 412 Major Moves Construction 811,187 3,344 3,344 919 807,843 0% 416 Morris Performing Arts Center Capital 101,500 8,323 8,323 7,362 93,177 8% 434 Community Revitalization Enhancement District 650,000 28 28 30 649,972 0% 450 Palais Royale Historic Preservation 16,150 1,281 1,281 1,803 14,869 8% 677 Football Hall of Fame Capital 2,500 495 495 85 2,005 20% Capital Project Total 4,126,939 116,422 116,422 115,552 4,010,517 3% Enterprise 600 Consolidated Building Fund 4,154,113 88,442 88,442 672,217 4,065,671 2% 601 Parking Garages 1,108,726 83,033 83,033 102,089 1,025,693 7% 610 Solid Waste Operations 5,712,289 408,178 408,178 400,585 5,304,111 7% 611 Solid Waste Capital 753,011 190,033 190,033 230,437 562,978 25% 620 Water Works Operations 14,760,483 1,065,650 1,065,650 1,018,172 13,694,833 7% City of South Bend Monthly Department Financial Report REVENUE SUMMARY January 31, 2015 -1q Fund r Current Month Current YTD Prior YTD Budget of Type Dept Name Actual Actual Actual Balance Budget City Fu Enterp 622 Water Works Capital 10,000 2,776 2,776 453 7,224 28% 623 Water Works Bond Capital 0 180 180 223 (180) 0% 624 Water Works Customer Deposit 6,000 1,307 1,307 186 4,693 22% 625 Water Works Sinking 2,050,078 468 468 171,006 2,049,610 0% 626 Water Works Bond Reserve 0 1,425 1,425 8,761 (1,425) 0% 629 Water Works Reserve Operations & Maintenance 162,749 1,840 1,840 261 160,909 1% 640 Sewer Repair Insurance 549,200 51,853 51,853 47,833 497,347 9% 641 Sewage Works Operations 35,334,467 2,786,029 2,786,029 2,674,845 32,548,438 8% 642 Sewage Works Capital 5,398,000 3,385 3,385 2,000,563 5,394,615 0% 643 Sewage Works Reserve Operations & Maint. 250,612 3,020 3,020 130,386 247,592 1 % 649 Sewage Sinking 9,288,088 774,321 774,321 775,028 8,513,767 8% 659 Sewer Bond 2011 6,000 1,477 1,477 1,034 4,523 25% 661 Sewer Bond 2012 20,000 14,968 14,968 2,373 5,032 75% 664 2013A Cost of Issuance Fund 0 4 4 1 (4) 0% 670 Century Center 4,532,562 32,985 32,985 101,443 4,499,577 1% 671 Century Center Capital 500 24 24 30 476 5% Enterprise Total 84,096,878 5,511,397 5,511,397 8,337,925 78,585,481 7% Internal Service 5,000 917 917 133 4,083 18% 222 Central Services 8,121,097 655,888 655,888 670,844 7,465,209 8% 224 Central Services Capital 271,850 0 0 0 271,850 0% 226 Liability Insurance 1,260,227 104,344 104,344 235,841 1,155,883 8% 278 Take Home Vehicle Police 124,200 14,575 14,575 14,378 109,625 12% 711 Self- Funded Employee Benefits 16,223,345 1,248,718 1,248,718 939,099 14,974,627 8% 713 Unemployment Compensation 226,796 8,685 8,685 8,563 218,111 4% Internal Service Total 26,227,515 2,032,210 2,032,210 1,868,724 24,195,305 8% Trust & Agency 701 Firefighters Pension 5,211,592 688 688 157 5,210,904 0% 702 Police Pension 6,360,000 1,133 1,133 261 6,358,867 0% 730 City Cemetery 150 25 25 5 125 17% Trust & Agency Total 11,571,742 1,846 1,846 423 11,569,896 0% City Funds Total 245,565,785 12,653,539 12,653,539 15,022,977 183,884,084 5% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area 14,880,000 50,351 50,351 2,853 14,829,649 0% 420 Tax Incremental Financing (TIF) - Downtown 4,344,202 695 695 30,403 4,343,507 0% 422 TIF - West Washington 422,000 996 996 58 421,004 0% 425 Redevelopment Retail & Leighton Plaza 189,123 18,229 18,229 9,940 170,894 10% 426 TIF - Central Medical Service Area 632,000 1,941 1,941 371 630,059 0% 429 River East Development Area 827,000 23,215 23,215 349 803,785 3% 430 TIF - Southside Development #1 2,410,000 4,144 4,144 402 2,405,856 0% 435 TIF - Douglas Road 320,750 161 161 23 320,589 0% 436 River East Residential 2,604,000 1,215 1,215 244 2,602,785 0% Tax Increment Financing Total 26,629,075 100,947 100,947 44,643 263528,128 0% Redevelopment 433 Redevelopment General 252 9 9 3 243 4% 439 Certified Technology Park 4,404 4,432 4,432 472 (28) 101% 454 Airport Urban Enterprise Zone 1,500 333 333 48 1,167 22% 619 Blackthorn Operations 1,696,879 99,156 99,156 71,571 1,597,723 6% Redevelopment Total 1,703,035 103,930 103,930 72,094 1,599,105 6% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 917 917 133 4,083 18% 317 Coveleski Debt Service Reserve 1,800 446 446 65 1,354 25% 328 Redevelopment Bond - Palais Royale 6,000 1,532 1,532 223 4,468 26% 432 TIF - Southside Development #3 25,000 5,246 5,246 762 19,754 21% Debt Service Total 37,800 8,141 8,141 1,183 29,659 22% Redevelopment Commission Controlled Funds Total 28,369,910 213,018 213,018 117,920 28,156,892 1% Grand Total 273,935,695 12,866,557 12,866,557 15,140,898 212,040,976 5% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY January 31, 2015 City Funds General Fund 101 -0101 Mayor's Office 741,267 80,464 80,464 73,969 893 659,911 11% 101 -0104 311 Call Center 486,733 55,195 55,195 39,235 2,415 429,123 12% 101 -0201 City Clerk 431,573 34,775 34,775 33,254 0 396,798 8% 101 -0301 Common Council 490,150 33,803 33,803 33,804 76,040 380,307 22% 101 -0302 WNIT Contract 43,000 0 0 0 0 0 0% 101 -0401 Administration & Finance 2,020,544 187,532 187,532 184,882 13,900 1,819,112 10% 101 -0404 Morris Performing Arts Center 1,093,132 96,838 96,838 87,838 59,854 936,440 14% 101 -0405 Palais Royale 536,293 41,912 41,912 43,724 41,185 453,196 15% 101 -0501 Legal Department 1,006,979 99,179 99,179 111,670 20,560 887,240 12% 101 -0602 Engineering 1,058,933 72,931 72,931 100,714 107,890 878,112 17% 101 -0801 Police Department 25,633,064 2,557,413 2,557,413 2,352,203 500,932 22,574,719 12% 101 -0802 Communications Center 1,687,540 135,031 135,031 205,840 0 1,552,509 8% 101 -0901 Fire Department 17,774,474 2,150,469 2,150,469 2,004,689 287,911 15,336,094 14% 101 -1008 Human Rights 373,179 50,323 50,323 31,977 13,631 309,225 17% General Fund Total 53,376,861 5,595,865 5,595,865 5,303,799 1,125,210 46,612,786 13% Special Revenue 201 Parks & Recreation 11,063,995 1,205,926 1,205,926 1,514,183 576,165 9,281,904 16% 202 Motor Vehicle Highway 10,485,386 847,279 847,279 868,158 764,179 8,873,928 15% 203 Recreation Nonreverting 1,549,469 43,898 43,898 42,584 76,531 1,428,760 8% 209 Studebaker - Oliver Reverting Grants 600,000 0 0 0 30,000 570,000 5% 210 Economic Development State Grants 1,694,412 12,200 12,200 0 10,200 1,672,012 1% 211 Community & Economic Development Admn. 2,661,730 250,396 250,396 236,843 36,662 2,374,672 11% 212 Community & Economic Development 6,547,968 106,821 106,821 100,807 2,366,131 4,075,016 38% 216 Police State Seizures 35,900 0 0 0 0 35,900 0% 217 Gift, Donation, Bequest 297,182 0 0 0 55,753 241,429 19% 218 Police Curfew Violations 1,000 0 0 0 0 1,000 0% 220 Law Enforcement Continuing Education 362,478 15,730 15,730 11,075 6,498 340,250 6% 227 Loss Recovery 5,237,243 181,590 181,590 5,154 3,975,325 1,080,329 79% 244 Emergency Phone System 0 20 20 27,387 0 -20 0% 249 Public Safety LOIT 7,246,551 732,055 732,055 517,291 0 6,514,496 10% 251 Local Roads & Streets 1,926,221 4,155 4,155 19,206 528,545 1,393,521 28% 258 Human Rights Federal Grant 247,357 22,061 22,061 19,647 21,800 203,496 18% 271 Eastrace Waterway 4,000 0 0 0 0 4,000 0% 273 Morris PAC / Palais Royale Marketing 18,974 0 0 3,628 974 18,001 5% 288 Emergency Medical Services Operating 6,855,366 247,977 247,977 449,207 309,398 6,297,991 8% 289 HAZMAT 31,530 20,939 20,939 0 590 10,000 68% 291 Indiana River Rescue 120,800 0 0 199 20,997 99,803 17% 292 Police Grants 105,145 0 0 0 15,145 90,000 14% 294 Regional Police Academy 23,750 2,724 2,724 136 0 21,026 11% 295 COPS MORE Grant 172,335 20,490 20,490 175 10,483 141,362 18% 299 Police Federal Drug Enforcement 248,960 18,385 18,385 0 24,297 206,278 17% 404 County Option Income Tax 15,660,371 1,322,195 1,322,195 1,612,310 1,068,608 13,269,568 15% 408 Economic Development Income Tax 9,627,618 577,063 577,063 2,229,819 452,110 8,598,445 11% 410 Urban Development Action Grant 438,203 0 0 0 0 438,203 0% 655 Project Releaf 528,358 15,357 15,357 14,433 0 513,001 3% 705 Police K -9 Unit 2,000 0 0 0 0 2,000 0% Special Revenue Total 83,794,302 5,647,259 5,647,259 7,672,244 10,350,390 67,796,372 19% City Debt Service 313 Football Hall of Fame Debt Service 1,266,820 636,000 636,000 634,500 0 630,820 50% City Debt Service Total 1,266,820 636,000 636,000 634,500 0 630,820 50% Capital Project 287 Emergency Medical Services Capital 750,000 0 0 0 35,728 714,272 5% 377 Professional Sports Development 854,803 480,773 480,773 382,873 0 374,030 56% 403 Zoo Endowment 49,000 0 0 0 0 49,000 0% 405 Park Nonreverting Capital 192,933 0 0 4,814 18,520 174,414 10% 406 Cumulative Capital Development 542,691 112,650 112,650 112,650 0 430,041 21% 407 Cumulative Capital Improvement 365,625 183,750 183,750 185,250 0 181,875 50% 412 Major Moves Construction 3,096,061 55,859 55,859 29,594 1,710,201 1,330,001 57% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY January 31, 2015 City Fi Capital Pro 416 Morris Performing Arts Center Capital 70,248 1,268 1,268 0 15,926 53,054 24% 434 Community Revitalization Enhancement District 650,000 3,897 3,897 20,975 0 646,103 1% 450 Palais Royale Historic Preservation 16,150 0 0 0 0 16,150 0% 677 Football Hall of Fame Capital 188,824 6,843 6,843 6,273 0 181,981 4% Capital Project Total 6,776,335 845,040 845,040 742,429 1,780,375 4,150,920 39% Enterprise 600 Consolidated Building Fund 4,205,401 282,377 282,377 248,465 110,967 3,859,831 9% 601 Parking Garages 931,712 89,030 89,030 96,764 158,359 684,323 27% 610 Solid Waste Operations 5,873,863 635,488 635,488 672,124 30,360 5,208,015 11% 611 Solid Waste Capital 752,811 223,749 223,749 264,795 0 529,062 30% 620 Water Works Operations 15,844,471 940,625 940,625 1,198,585 390,793 14,513,053 8% 622 Water Works Capital 838,893 15,382 15,382 3,600 67,463 756,048 10% 623 Water Works Bond Capital 53,085 11,278 11,278 17,780 42,026 -219 100% 624 Water Works Customer Deposit 6,000 452 452 186 0 5,548 8% 625 Water Works Sinking 2,050,078 465 465 196 0 2,049,613 0% 629 Water Works Reserve Operations & Maintenance 8,500 637 637 261 0 7,863 7% 640 Sewer Repair Insurance 545,703 21,449 21,449 17,250 0 524,254 4% 641 Sewage Works Operations 38,196,974 2,564,371 2,564,371 4,598,158 1,303,315 34,329,287 10% 642 Sewage Works Capital 9,071,710 39,115 39,115 978,994 3,686,725 5,345,870 41% 643 Sewage Works Reserve Operations & Maint. 15,000 1,045 1,045 422 0 13,955 7% 649 Sewage Sinking 9,282,109 1,000 1,000 500 0 9,281,109 0% 659 Sewer Bond 2011 3,711,838 143,037 143,037 275,419 1,446,329 2,122,472 43% 661 Sewer Bond 2012 16,624,275 39,170 39,170 272,470 1,698,031 14,887,074 10% 670 Century Center 4,532,562 306,498 306,498 314,628 0 4,226,064 7% 671 Century Center Capital 0 0 0 0 0 0 0% Enterprise Total 112,544,985 5,315,169 5,315,169 8,960,597 8,934,368 98,343,221 13°% Internal Service 222 Central Services 8,279,085 679,565 679,565 672,962 3,300,291 4,299,230 48% 224 Central Services Capital 271,850 0 0 0 0 271,850 0% 226 Liability Insurance 3,056,791 262,238 262,238 103,406 60,524 2,734,029 11% 278 Take Home Vehicle Police 71,100 0 0 0 0 71,100 0% 711 Self- Funded Employee Benefits 16,696,935 1,030,771 1,030,771 526,930 122,941 15,543,223 7°% 713 Unemployment Compensation 226,796 10,126 10,126 9,673 13,200 203,470 10°% Internal Service Total 28,602,557 1,982,700 1,982,700 1,312,970 3,496,956 23,122,902 19% Trust & Agency 701 Firefighters Pension 5,666,579 441,192 441,192 457,164 0 5,225,387 8°% 702 Police Pension 6,832,235 537,112 537,112 542,603 0 6,295,123 8°% 730 City Cemetery 20,000 0 0 0 0 20,000 0% Trust & Agency Total 12,518,814 978,304 978,304 999,767 0 11,540,510 8% City Funds Total 298,880,674 21,000,337 21,000,337 25,626,306 25,687,299 252,197,531 16% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area 20,710,597 2,276,439 2,276,439 1,403,524 3,816,349 14,617,809 29% 420 Tax Incremental Financing (TIF) - Downtown 4,537,169 964,016 964,016 1,015,931 0 3,573,153 21% 422 TIF - West Washington 760,900 0 0 319 30,600 730,300 4% 425 Redevelopment Retail & Leighton Plaza 154,716 6,962 6,962 4,077 0 147,754 4% 426 TIF - Central Medical Service Area 1,790,033 0 0 169,224 179,126 1,610,907 10% 429 River East Development Area 1,439,524 112,956 112,956 617 173,773 1,152,795 20% 430 TIF - Southside Development #1 2,842,535 435,370 435,370 81,949 787,163 1,620,002 43% 435 TIF - Douglas Road 345,389 0 0 160 4,200 341,189 1% 436 River East Residential 3,425,632 1,464,000 1,464,000 1,464,500 0 1,961,632 43% Tax Increment Financing Total 36,006,495 5,259,743 5,259,743 4,140,301 4,991,211 25,755,541 28% Redevelopment 433 Redevelopment General 6,000 0 0 6,072 0 6,000 0% 439 Certified Technology Park 1,549,000 0 0 0 0 1,549,000 0% 619 Blackthorn Operations 1,671,706 69,055 69,055 47,557 0 1,602,651 4% Redevelopment Total 3,226,706 69,055 69,055 53,629 0 3,157,651 2% 61 4,683 6 5,470 9 131,835 73% 141,988 72% 4,991,211 29,055,180 27% Grand Total 338,614,255 26,687,527 26,687,527 30,175,198 30,678,510 281,252,711 17% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY January 31, 2015 Current m Current Fund Type Department Redev Debt Service Amended Month Current YTD Prior YTD 315 Redevelopment Bond - Airport Taxable 5,000 317 317 133 328 Redevelopment Bond - Palais Royale 6,000 530 530 223 432 TIF - Southside Development #3 489,380 357,545 357,545 354,606 Debt Service Total 500,380 358,392 358,392 354,962 Redevelopment Commission Controlled Funds Total 39,733,581 5,687,190 5,687,190 4,548,892 4,683 6 5,470 9 131,835 73% 141,988 72% 4,991,211 29,055,180 27% Grand Total 338,614,255 26,687,527 26,687,527 30,175,198 30,678,510 281,252,711 17% 2015 City of South Bend Monthly Financial Report Fund/Department Name Mayor's Office Fund/Department Number 101 -0101 Month January Date Updated 211212015 Current Current Current Prior 73,742 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 740,667 80,429 80,429 73,742 660,238 11% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations - 35 35 227 (35) 0% Other Income 600 - - - 600 0% Transfers In - - - - - 0% Total Revenue 741,267 80,464 80,464 73,969 660,803 11% Expenditures Personnel 669,877 69,962 69,962 60,686 - 599,915 10% Supplies 12,413 754 754 1,633 878 10,780 13% Services 56,739 9,747 9,747 11,100 14 46,978 17% Debt Service 2,238 - - 550 - 2,238 0% Capital - - - 0% Transfers Out - - - - - - 0% Total Expenditures 741,267 80,464 80,464 73,969 893 659,911 11% Net - - - (893)1 893 Cash Balance I - 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 r-xpiain oignmcanr mevenue, txpenanure ana orarrmg unangesivanances neiow: Expenditures higher in personnel due to three payrolls occurring this month. n aigmricam openaing on uapnai rrotecrs aeiow: are no capital projects budgeted for 2015. Form 3 7 Form 3 8 2015 City of South Bend Monthly Financial Report Fund/Department Name 311 Call Center Month January Fund/Department Number 101 -0104 Date Updated 211412015 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 0 12,726 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 55,195 55,195 26,509 415,096 12% Transfers In - - - - - 0% Total Revenue 486,733 55,195 55,195 39,235 431,538 11% Expenditures Personnel 441,562 46,324 46,324 37,433 - 395,238 10% Supplies 6,125 647 647 653 625 4,853 21% Services 39,046 8,225 8,225 926 1,790 29,031 26% Debt Service - - - 123 - - 0% Capital 100 0% Transfers Out - - - - 0% Total Expenditures 486,733 55,195 55,195 39,235 2,415 429,123 12% Net - - - - (2,415)1 2,415 Cash Balance I - 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 Changes/Variances 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 8 Form 3 9 2015 City of South Bend Monthly Financial Report Fund/Department Name City Clerk Month January Fund/Department Number 101 -0201 Date Updated 211312015 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 34,775 34,775 33,254 396,798 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 431,573 34,775 34,775 33,254 396,798 8% Expenditures Personnel 339,442 33,216 33,216 31,331 306,226 10% Supplies 7,740 24 24 473 7,716 0% Services 70,991 1,535 1,535 1,450 69,456 2% Debt Service - - - - - 0% Capital 13,400 13,400 0% Transfers Out - - - - - 0% Total Expenditures 431,573 34,775 34,775 33,254 396,798 j 8% Net - - Cash Balance I - 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 Changes/Variances 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 9 2015 City of South Bend Monthly Financial Report Fund/Department Name Common Council Fund/Department Number 101 -0301 Month January Date Updated 211312015 Current Current Current Prior 33,763 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 481,684 33,763 33,763 33,763 447,921 7% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 8,466 41 41 41 8,425 0% Other Income - - - - - 0% Transfers In - - - - - 0% Total Revenue 490,150 33,803 33,803 33,804 456,347 7% Expenditures Personnel 325,242 22,601 22,601 21,485 - 302,641 7% Supplies 4,706 34 34 24 303 4,369 7% Services 160,202 11,169 11,169 12,294 75,736 73,297 54% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 490,150 33,803 33,803 33,804 76,040 380,307 22% Net - - - (76,040)1 76,040 Cash Balance I - Staffing Full Time 9.00 9.00 9.00 Part -Time /Seasonal/Temporary - - - Total 9.00 9.00 9.00 n oignmcanr mevenue, r-xpenanure ana orarrmg unangesnranances rseiow: are nine (9) Council Members. One member has declined to receive a salary. Expenditures are consistent with normal operating costs. ibrance of $75K is for Council Attorney for the entire year. n aignricam openaing on �,apnai rrotecrs aeiow: Form 3 10 Form 3 11 2015 City of South Bend Monthly Financial Report Fund/Department Name WNIT Contract Month January Fund/Department Number 101 -0302 Date Updated 211912015 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 j 0% Net - 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 Changes/Variances 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 11 2015 City of South Bend Monthly Financial Report Fund/Department Name Administration & Finance Fund/Department Number 101 -0401 Month January Date Updated 211812015 Current Current Current Prior 184,882 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 1,990,494 187,532 187,532 184,882 1,802,962 9% 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 30,050 0% Transfers In - - - - - 0% Total Revenue 2,020,544 187,532 187,532 184,882 1,833,012 9% Expenditures Personnel 1,806,651 181,925 181,925 173,862 - 1,624,726 10% Supplies 28,109 1,482 1,482 1,736 4,891 21,736 23% Services 183,213 3,482 3,482 8,641 9,009 170,722 7% Debt Service 2,571 643 643 643 - 1,928 25% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,020,544 187,532 187,532 184,882 13,900 1,819,112 10% Net - - - (13,900)1 13,900 Cash Balance Full Time 22.00 22.00 Part -Time /Seasonal/Temporary - 2.00 Total 22.00 24.00 n oigmricanr mevenue, cxpenanure ana ararrmg unangesivanances neiow: Brred Chief Technology Officer to COIT for 2015 budget and added new HR Generalist position. There were 3 payperiods in January 2015, re, personnel costs appear higher than normal for the month. Overall spending appears consistent with expectations. r-xpiain aigmricam openaing on �,apnai rrotecrs aeiow: None Form 3 12 2015 City of South Bend Monthly Financial Report Fund/Department Name Morris Performing Arts Center Fund/Department Number 101 -0404 Month January Date Updated 111012015 Current Current Current Prior 31,686 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 170,132 43,509 43,509 31,686 126,623 26% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 917,000 52,311 52,311 54,711 864,689 6% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 6,000 1,018 1,018 1,441 4,982 17% Transfers In - - - - - 0% Total Revenue 1,093,132 96,838 96,838 87,838 996,294 9% Expenditures Personnel 749,285 76,732 76,732 70,644 4,477 668,076 11% Supplies 33,542 1,234 1,234 1,587 10,667 21,642 35% Services 310,305 18,872 18,872 15,607 44,710 246,722 20% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 1,093,132 96,838 96,838 87,838 59,854 936,440 14% Net - - - (59,854)1 59,854 Cash Balance Staffing Full Time 12.00 12.00 Part-Time /Seasonal/Temporary /Seasonal/Temporary 4.00 4.00 Total 16.00 16.00 r-xpiain oignmcanr mevenue, txpenanure ana orarrmg unangesivanances neiow: Fund 416 is used to support renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons at the Morris Performing Arts Center. Not all of the expenses are Capital expenses. This department of the General Fund comprises basic operating expenditures for the Morris PAC. n argmricam openaing on �,apnai rrojecrs aeiow: Form 3 13 Form 3 14 2015 City of South Bend Monthly Financial Report Fund/Department Name Palais Royale Month January Fund/Department Number 101 -0405 Date Updated 111012015 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 17,544 17,544 14,623 142,744 9% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 315,820 22,832 22,832 27,385 292,988 7% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 19,000 1,536 1,536 1,715 17,464 8% Transfers In - - - - - 0% Total Revenue 536,293 41,912 41,912 43,724 453,196 8% Expenditures Personnel 263,505 25,862 25,862 24,196 1,683 235,960 10% Supplies 23,897 290 290 472 5,154 18,453 23% Services 234,891 15,759 15,759 19,056 34,348 184,784 21% Debt Service - - - - - - 0% Capital 14,000 14,000 0% Transfers Out - - - - - - 0% Total Expenditures 536,293 41,912 41,912 43,724 41,185 453,196 j 15% Net - - - (41,185) Cash Balance I - 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 Changes/Variances Below: This department covers the operating revenues and expenditures for the Palais Royale ballroom. 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 15 2015 City of South Bend Monthly Financial Report Fund/Department Name Legal Department Month January Fund/Department Number 101 -0501 Date Updated 211812015 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 99,179 99,179 111,655 854,800 10% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 3,000 3,000 0% Bond Proceeds - - 0% Donations - - - 0% Other Income 50,000 15 50,000 0% Transfers In - - - - - 0% Total Revenue 1,006,979 99,179 99,179 111,670 907,800 10% Expenditures Personnel 955,213 97,997 97,997 110,680 - 857,216 10% Supplies 5,212 154 154 115 668 4,390 16% Services 45,254 1,028 1,028 875 19,892 24,334 46% Debt Service 1,300 - - - - 1,300 0% Capital - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,006,979 99,179 99,179 111,670 20,560 887,240 12% Net - - - - (20,560)1 20,560 Cash Balance Staffing Full Time 10.60 10.60 Part -Time /Seasonal/Temporary - - Total 10.60 10.60 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Other Income of $50,000 is reimbursement for legal expenses from TIF funds which will be received in December 2015. There were 3 pay periods in January, therefore, personnel expenses appear higher than usual. Explain Significant Spending on Capital Projects Below: Form 3 15 Form 3 16 2015 City of South Bend Monthly Financial Report Fund/Department Name Engineering Month January Fund/Department Number 101 -0602 Date Updated 211312015 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 72,931 72,931 100,599 908,975 7% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 77,027 115 77,027 0% Transfers In - - - - - 0% Total Revenue 1,058,933 72,931 72,931 100,714 986,002 7% Expenditures Personnel 710,552 58,231 58,231 67,342 - 652,321 8% Supplies 29,262 2,008 2,008 1,748 1,009 26,244 10% Services 306,044 10,137 10,137 29,070 104,289 191,618 37% Debt Service 13,075 2,554 2,554 2,554 2,592 7,929 39% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,058,933 72,931 72,931 100,714 107,890 878,112 17% Net - - - (107,890)1 107,890 Cash Balance Staffing Full Time 7.90 6.65 Part -Time /Seasonal/Temporary /Seasonal/Temporary 1.22 1.22 Total 9.12 7.87 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: $104,289 in encumbrance for Services include $41,700 for water system evaluation, $42,750 for 13th floor renovation, and $14,400 for 2015 travel booked in 2014. 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 16 Form 3 17 2015 City of South Bend Monthly Financial Report Fund/Department Name Police Department Month January Fund/Department Number 101 -0801 Date Updated 111612015 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 2,550,809 2,550,809 2,314,150 22,544,555 10% 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 - - - 7,500 0% Other Income 330,200 6,604 6,604 38,053 323,596 2% Transfers In - - - - - 0% Total Revenue 25,633,064 2,557,413 2,557,413 2,352,203 23,075,651 10% Expenditures Personnel 22,989,224 2,389,856 2,389,856 2,059,589 20,599,368 10% Supplies 419,279 38,316 38,316 134,083 135,247 245,716 41% Services 2,201,409 128,664 128,664 157,939 365,685 1,707,060 22% Debt Service 23,152 577 577 592 - 22,575 2% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 25,633,064 2,557,413 2,557,413 2,352,203 500,932 22,574,719 12% Net - - - (500,932)1 500,932 Cash Balance I - Staffing Full Time 263.00 260.00 260.00 Part -Time /Seasonal/Temporary 60.00 30.00 30.00 Total 323.00 290.00 290.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. Supplies and Services expenditures show 41 % and 22% of the Budget as used in the month of January. This is due to the 2014 encumbrances reflected as a use in January. 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 Fund/Department Number 101 -0802 Month January Date Updated 211712015 Current Current Current Prior 205,840 Local Income Taxes Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 1,687,540 135,031 135,031 205,840 Local Income Taxes - - - - Other Taxes 0% 0% Grants /Intergovernmental 0% 0% Charges for Services 8% 8,941 94% - Interest Earnings 1,543,568 0% - 0% Bond Proceeds 0% 0% 1,552,509 Donations Other Income Transfers In - - - - Total Revenue 1,687,540 135,031 135,031 205,840 Expenditures Personnel 143,972 135,031 135,031 205,193 Supplies - - - - Services 1,543,568 647 Debt Service - - Capital Transfers Out - - - - Total Expenditures 1,687,540 135,031 135,031 205,840 Net - - - Cash Balance Full Time Part -Time /Seasonal/Temporary Total 1,552,509 8% - 0% 0% 0% 0% 0% 0% 0% 0% 0% 1,552,509 8% 8,941 94% - 0% 1,543,568 0% - 0% 0% 0% 1,552,509 8% r-xpiain oigmricanr mevenue, rxpenanure ana ararrmg unangesivanances rseiow: 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. n aigmricam openaing on �,apnai rrotecrs aeiow: Form 3 18 2015 City of South Bend Monthly Financial Report Fund /De artment Name I Fire Department Month January Fund /De artment Number 1 101 -0901 Date Updated 211812015 Current Current Current Prior 1,963,626 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes /Non -Dept Revenue 17,762,474 2,140,448 2,140,448 1,963,626 15,622,026 12% Local Income Taxes - - - - 0% Other Taxes - - 0% Grants /Intergovernmental - - 0% Charges for Services 6,000 10,022 10,022 40,938 (4,022) 167% Interest Earnings - - - - 0% Bond Proceeds 0% Donations - - 0% Other Income 6,000 - 125 6,000 0% Transfers In - - - 0% Total Revenue 17,774,474 2,150,469 2,150,469 2,004,689 15,624,005 12% Expenditures Personnel 15,737,086 2,045,419 2,045,419 1,872,469 123,768 13,567,899 14% Supplies 320,618 13,409 13,409 27,374 34,123 273,085 15% Services 1,216,770 91,641 91,641 104,846 130,019 995,110 18% Debt Service - - - - - - 0% Capital - - 0% Transfers Out 500,000 - - - - 500,000 0% Total Expenditures 17.774.474 2.150.469 2,150.469 2,004,689 287.911 15.336.094 14% rver - - - - lcor,�i it corgi i Cash Balance Full Time 170.00 167.00 167.00 Part-Time /Seasonal/Temporary - - - Total 170.00 167.00 167.00 r-xpiain oignmcanr reevenue, txpenanure ana orarring unangesivanances neiow: The South Bend Fire Department is budgeted to have 251 sworn firefighters and 6 civilian full time employees. 37 firefighters are paid directly through the Public Safety LOIT. The costs of 47 sworn employees and 4 civilian employees 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. r-xpiain aignmcam openaing on uapnai rrotecrs aeiow: The Fire Department uses EMS Capital Fund 287 to capture revenue generated 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 January Fund/Department Number 101 -1008 Date Updated 2/312015 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 50,323 50,323 31,977 322,856 13% 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 50,323 50,323 31,977 322,856 13% Expenditures Personnel 286,475 34,772 34,772 27,684 - 251,703 12% Supplies 2,010 95 95 59 400 1,515 25% Services 73,492 5,214 5,214 4,234 12,271 56,007 24% Debt Service - - - - - - 0% Capital 11,202 10,242 10,242 960 100% Transfers Out - - - - - 0% Total Expenditures 373,179 50,323 50,323 31,977 13,631 309,225 17% Net - - - (13,631)1 13,631 Cash Balance I - 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 Changes/Variances 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 this month. Form 3 20 Form 3 21 2015 City of South Bend Monthly Financial Report Fund/Department Name Rainy Day Month January Fund/Department Number 102 Date Updated 211212015 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 7,630 7,630 1,105 27,050 22% Bond Proceeds - - - - 0% Donations - 0% Other Income 0% Transfers In - - - - 0% Total Revenue 34,680 7,630 7,630 1,105 27,050 E% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - - 0% Net 34,680 7,630 7,630 1,105 27,050 Cash Balance 1 8,649,818 8,618,810 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 21 Form 3 22 2015 City of South Bend Monthly Financial Report Fund/Department Name Excess Levy Month January Fund/Department Number 103 Date Updated 211912015 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 3,648 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: A small excess of property tax was received in December 2014. This will be spent in future years as an offset to tax revenues, with approval by DLGF. Explain Significant Spending on Capital Projects Below: N/A Form 3 22 2015 City of South Bend Monthly Financial Report Fund/Department Name Parks & Recreation Fund/Department Number 201 Month January Date Updated 211712015 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 73,736 60,782 811,100 8% Charges for Services 2,025,640 28,289 28,289 17,642 1,997,351 1% Interest Earnings 10,000 2,724 2,724 431 7,276 27% Bond Proceeds - 0% Donations - 0% Other Income 144,200 20,054 20,054 13,579 124,146 14% Transfers In - - 0% Total Revenue 11,030,715 124,803 124,803 92,435 10,905,912 1% Expenditures Personnel 7,105,699 645,103 645,103 810,199 5,324 6,455,273 9% Supplies 1,109,836 27,953 27,953 58,609 462,026 619,857 44% Services 2,443,703 532,871 532,871 645,376 108,815 1,802,017 26% Debt Service 309,257 - - - - 309,257 0% Capital - - 0% Transfers Out 95,500 - - - - 95,500 0% Total Expenditures 11,063,995 1.205.926 1.205.926 1.514.183 576,165 9,281.904 16% Balance Full Time 90.00 88.00 88.00 Part-Time /Seasonal/Temporary /Seasonal/Temporary na 43.00 53.00 Total 90.00 131.00 141.00 108 r-xpiain oigmricanr mevenue, txpenanure ana ararrmg unangesivanances rseiow: 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. r-xpiain aigmncam apenaing on uapnai rrotecrs aeiow: 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 2015 City of South Bend Monthly Financial Report Fund/Department Name Motor Vehicle Highway Fund/Department Number 202 Month January Date Updated 211112015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 5,697,000 682,077 682,077 250,514 5,014,923 12% Grants /Intergovernmental - - 0% Charges for Services 265,000 28,724 28,724 33,056 236,276 11% Interest Earnings 7,000 3,484 3,484 517 3,516 50% Bond Proceeds - - 0% Donations - - 0% Other Income 9,300 1,735 1,735 1,436 7,565 19% Transfers In 2,953,000 2,953,000 0% Total Revenue 8,931,300 716,020 716,020 285,523 8,215,280 8% Expenditures Personnel 4,314,548 471,784 471,784 483,035 3,842,764 11% Supplies 2,631,854 92,303 92,303 147,072 627,814 1,911,737 27% Services 2,951,520 247,554 247,554 202,414 96,907 2,607,059 12% Debt Service 448,006 35,637 35,637 35,637 412,369 8% Capital 139,458 39,458 100,000 28% Transfers Out - - - - - - 0% Total Expenditures 10.485.386 847.279 847.279 868.158 764.179 1 8,873,928 1 15% Balance Full Time 52.65 51.65 Part -Time /Seasonal/Temporary /Seasonal/Temporary 4.98 1.78 Total 57.63 53.43 r-xpiain oigmricanr mevenue, txpenanure ana ararring unangesivanances rseiow: Information included for Streets, Traffic & Lighting, and Curb & Sidewalk. n aigmncam apenaing on �,apnai rrojecrs aeiow: 744 Form 3 24 2015 City of South Bend Monthly Financial Report Fund/Department Name Recreation Nonrevertin Fund/Department Number 203 Month January Date Updated 2/912015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 1,530,935 62,147 62,147 53,950 1,468,788 4% Interest Earnings 3,000 717 717 99 2,283 24% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 45,000 2,743 2,743 22,009 42,257 6% Transfers In - - - - - 0% Total Revenue 1,578,935 65,607 65,607 76,057 1,513,328 4% Expenditures Personnel 737,842 33,751 33,751 31,603 - 704,091 5% Supplies 289,470 4,152 4,152 2,113 63,962 221,356 24% Services 522,157 5,994 5,994 8,869 12,569 503,594 4% Debt Service - - - - - - 0% Capital - 0% Transfers Out - - - 0% Total Expenditures 1,549,469 43,898 43,898 42.584 76,531 1 1,429,041 1 8% Balance 835.622 811.722 Full Time 1.00 1.00 1.00 Part -Time /Seasonal/Temporary - 48.00 48.00 Total 1.00 49.00 49.00 r-xpiain oigmricanr mevenue, txpenanure ana ararrmg unangesivanances tseiow: 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. n aigmncam apenaing on �,apnai rrojecrs aeiow: Form 3 25 Form 3 26 2015 City of South Bend Monthly Financial Report Fund/Department Name Studebaker - Oliver Reverting Grants Month January Fund/Department Number 209 Date Updated 211312015 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 570,000 570,000 0% Charges for Services - - - - - 0% Interest Earnings 4,000 959 959 139 3,041 24% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 574,000 959 959 139 573,041 0% Expenditures Personnel - - - - - 0% Supplies - - - 0% Services 600,000 30,000 570,000 5% Debt Service - - - 0% Capital 0% Transfers Out 0% Total Expenditures 600,000 - - 30,000 570,000 5% Net (26,000) 959 959 139 (30,000)1 3,041 Cash Balance 1 1,087,424 1,083,526 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The $570,000 represents a Brownfield Assessment Grant awarded by EPA for use in South Bend , Mishawaka and St. Joseph County. Explain Significant Spending on Capital Projects Below: Form 3 26 Form 3 27 2015 City of South Bend Monthly Financial Report Fund/Department Name Economic Development State Grants Month January Fund/Department Number 210 Date Updated 211312015 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 290 290 85 13,254 2% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 59,966 59,966 0% Transfers In - - - - - 0% Total Revenue 1,673,510 290 290 85 1,673,220 0% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 1,622,400 12,200 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 12,200 10,200 1,672,012 1% Net (20,902) (11,910) (11,910) 85 (10,200)1 1,208 Cash Balance 1 317,523 349,035 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 2015 City of South Bend Monthly Financial Report Fund/Department Name Department of Community Investment DCI Fund/Department Number 211 Month January Date Updated 211312015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 416,787 416,787 0% Charges for Services - - - - - 0% Interest Earnings 2,200 1,421 1,421 124 779 65% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 245,000 13,278 13,278 13,484 231,722 5% Transfers In 1,967,638 - - 422,240 1,967,638 0% Total Revenue 2,631,625 14,699 14,699 435,848 2,616,926 1% Expenditures Personnel 2,120,943 212,652 212,652 210,971 10,028 1,898,263 10% Supplies 35,753 2,089 2,089 3,437 12,503 21,161 41% Services 505,034 35,655 35,655 22,435 14,131 455,248 10% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 2,661,730 250.396 250.396 236.843 36,662 1 2,374,672 1 11% Balance Full Time 23.00 23.00 23.00 Part-Time /Seasonal/Temporary - - - Total 23.00 23.00 23.00 1.106.613 r-xpiain oigmricanr mevenue, txpenanure ana ararring unangesnranances rseiow: The DCI fund is the main operating fund for this department and is funded by a transfer from the EDIT fund. n aigmncam apenaing on �,apnai rrotecrs aeiow: Form 3 28 Form 3 29 2015 City of South Bend Monthly Financial Report Fund/Department Name Dept of Community Investment Grants Month January Fund/Department Number 212 Date Updated 211312015 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 119,425 3,850,000 0% Charges for Services - - - - - 0% Interest Earnings 2,000 104 104 401 1,896 5% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 248,000 99,039 99,039 5,247 148,961 40% Transfers In - - - - - 0% Total Revenue 4,100,000 99,143 99,143 125,073 4,000,857 2% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Grants 6,547,968 106,821 106,821 100,807 2,366,131 4,075,016 38% Transfers Out - - - - - - 0% Total Expenditures 6,547,968 106,821 106,821 100,807 2,366,131 4,075,016 11 38% Net (2,447,968) (7,678) (7,678) 24,266 (2,366,131) (74,159) Cash Balance 1 784,037 615,552 Staffing Full Time - Part -Time /Seasonal /Tem pora ry Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. Typical grants are from CDBG and HUD. 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 January Fund/Department Number 216 Date Updated 211612015 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 162 162 20 138 54% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 600 - - 600 0% Transfers In - - 0% Total Revenue 35,900 162 162 20 35,738 0% 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 - 162 162 20 (162) Cash Balance 1 187,594 158,687 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 Department's effort to combat drug activity. Explain Significant Spending on Capital Projects Below: Form 3 30 Form 3 31 2015 City of South Bend Monthly Financial Report Fund/Department Name Gift, Donation, Bequest Month January Fund/Department Number 217 Date Updated 211312015 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 122 122 10 (22) 122% Bond Proceeds - - - - - 0% Donations 216,000 1,497 1,497 214,503 1% Other Income - - - - 0% Transfers In - - - - - 0% Total Revenue 216,100 1,618 1,618 10 214,482 1% Expenditures Personnel - - - - - - 0% Supplies 1,552 1,552 0 100% Services 295,630 54,201 241,429 18% Debt Service - - - 0% Capital 0% Transfers Out 0% Total Expenditures 297,182 - - 55,753 241,429 19% Net (81,082) 1,618 1,618 10 (55,753) (26,948) Cash Balance 1 139,557 74,744 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 31 Form 3 32 2015 City of South Bend Monthly Financial Report Fund/Department Name Police Curfew Violations Month January Fund/Department Number 218 Date Updated 211612015 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 - - 13 1,000 0% Interest Earnings 25 11 11 1 14 44% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,025 11 11 14 1,014 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 11 11 14 14 Cash Balance 1 12,016 11,562 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 32 2015 City of South Bend Monthly Financial Report Fund/Department Name Law Enforcement Continuin Education Fund/Department Number 220 Month January Date Updated 211612015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 180,000 21,307 21,307 19,017 158,693 12% Interest Earnings 3,000 849 849 124 2,151 28% Bond Proceeds - - - - - 0% Donations 2,000 - - - 2,000 0% Other Income 26,000 2,703 2,703 11,107 23,297 10% Transfers In - - - - - 0% Total Revenue 211,000 24,859 24,859 30,248 186,141 U% Expenditures Personnel - - - - - - 0% Supplies 122,478 - - 10,855 6,498 115,980 5% Services 190,000 15,730 15,730 220 - 174,270 8% Debt Service - - - - - 0% Capital 50,000 50,000 0% Transfers Out - - - - - - 0% Total Expenditures 362.478 15.730 15,730 11.075 6,498 1 340,250 1 6% Balance Full Time Part -Time /Seasonal/Temporary Total 1 1 r-xpiain oignmcanr mevenue, txpenanure ana orarring unangesnranances rseiow: 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. n aigmncam apenaing on �,apnai rrojecrs aeiow: Form 3 33 Form 3 34 2015 City of South Bend Monthly Financial Report Fund/Department Name Loss Recovery Month January Fund/Department Number 227 Date Updated 211312015 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 5,206 5,206 1,018 (1,006) 124% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 4,200 5,206 5,206 1,018 (1,006) 124% Expenditures Personnel - - - - - 0% Supplies 67,500 - - - 67,500 100% Services 3,280,635 147,040 147,040 5,154 2,053,267 1,080,328 67% Debt Service - - - - - - 0% Capital 1,889,108 34,550 34,550 1,854,558 1 100% Transfers Out - - - - 0% Total Expenditures 5,237,243 181,590 181,590 5,154 3,975,325 1,080,329 79% Net (5,233,043) (176,383) (176,383) (4,135) (3,975,325) (1,081,335) Cash Balance 1 5,687,510 7,931,897 Staffing Full Time - Part-Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. Explain Significant Spending on Capital Projects Below: $1.889 million has been budgeted in 2015 for the Smart Streets initiative. Form 3 34 Form 3 35 2015 City of South Bend Monthly Financial Report Fund/Department Name Emergency Phone System Month January Fund/Department Number 244 Date Updated 211912015 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 (19) 0% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 19 19 215,000 (19) 0% Expenditures Personnel 20 20 27,387 (20) 0% Supplies - - - - 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 20 20 27,387 (20) j 0% Net - (1) (1) 187,613 1 Cash -Balance 33,651 187,613 Staffing Full Time 3.00 3.00 3.00 Part -Time /Seasonal/Temporary - - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 35 2015 City of South Bend Monthly Financial Report Fund/Department Name Public Safety LOIT Fund/Department Number 249 Month January Date Updated 211312015 Current Current Current Prior - - Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes - - - - - 0% Local Income Taxes 6,464,911 538,849 538,849 531,669 5,926,062 8% Other Taxes - - - - - 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 6,000 1,159 1,159 226 4,841 19% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 6,470,911 540,008 540,008 531,895 5,930,903 8% Expenditures Personnel 7,246,551 732,055 732,055 517,291 6,514,496 10% Supplies - - - - - 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 7,246,551 732,055 732,055 517,291 6,514,496 10% Naf 1775 Rd01 11Q9 nA71 11Q9 nA71 1d ROd MR3 SQ31 Balance Full Time 80.00 80.00 Part -Time /Seasonal/Temporary - - Total 80.00 80.00 1.101.185 2.046.798 = xpiain oigmricanr mevenue, r-xpenanure ana ararrmg unangesrvanances neiow: Fhis fund is covering the costs of 43 police officers and 37 firefighters in 2015. r-xpiain aigmncam apenaing on �.apnai rrojecrs aeiow: None. No capital equipment is purchased from this fund. Form 3 36 Form 3 37 2015 City of South Bend Monthly Financial Report Fund/Department Name Local Roads & Streets Month January Fund/Department Number 251 Date Updated 211312015 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 85,628 85,628 86,900 914,372 9% Grants /Intergovernmental - - - - - 0% Charges for Services - - - - - 0% Interest Earnings 5,300 2,155 2,155 248 3,145 41% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 588,000 588,000 0% Transfers In - - - - - 0% Total Revenue 1,593,300 87,782 87,782 87,148 1,505,518 6% Expenditures Personnel - - - - - - 0% Supplies 380,229 229 380,000 0% Services 157,500 - 157,500 0% Debt Service - - - - - - 0% Capital 1,388,492 4,155 4,155 19,206 528,316 856,021 38% Transfers Out - - - - - - 0% Total Expenditures 1,926,221 4,155 4,155 19,206 528,545 1,393,521 28% Net (332,921) 83,628 83,628 67,942 (528,545)1 111,996 Cash Balance 1 2,528,075 2,009,316 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. The Other Income of $588,000 is the matching revenues from INDOT for the capital projects. 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. Form 3 37 Form 3 38 2015 City of South Bend Monthly Financial Report Fund/Department Name Excess Welfare Distribution Month January Fund/Department Number 252 Date Updated 211212015 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 1 8 1,150 Staffing Full Time Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 January Fund/Department Number 258 Date Updated 211312015 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 1,667 185,333 1% Charges for Services - - - - - 0% Interest Earnings 2,000 398 398 61 1,602 20% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 14,400 27 14,400 0% Transfers In - - - - - 0% Total Revenue 203,400 2,065 2,065 89 201,335 1% Expenditures Personnel 123,657 8,568 8,568 12,053 - 115,089 7% Supplies 2,800 - - - 1,800 1,000 64% Services 120,900 13,494 13,494 7,594 20,000 87,407 28% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 247,357 22,061 22,061 19,647 21,800 203,496 11 18% Net (43,957) (19,997) (19,997) (19,559) (21,800) (2,160) Cash Balance 1 510,256 447,216 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 Changes/Variances 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. Explain Significant Spending on Capital Projects Below: No capital projects have been budgeted for this year. Form 3 39 Form 3 40 2015 City of South Bend Monthly Financial Report Fund/Department Name Eastrace Waterway Month January Fund/Department Number 271 Date Updated 2/912015 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 5 2 (5) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 5 5 2 (5) 0% Expenditures Personnel - - - - 0% Supplies 4,000 4,000 0% Services - - 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 4,000 - - - 4,000 0% Net (4,000) 5 5 2 (4,005) Cash Balance 1 5,317 14,374 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In past years there have been no races. Explain Significant Spending on Capital Projects Below: Form 3 40 2014 City of South Bend Monthly Financial Report Fund/Department Name Morris PAC / Palais Royale Marketing Month January Fund/Department Number 273 Date Updated 111012015 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 250 350 17,650 1% Interest Earnings 100 24 24 4 76 24% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 18,000 274 274 354 17,726 2% Expenditures Personnel - - - - - 0% Supplies - - - - 0% Services 18,974 3,628 974 18,001 5% Debt Service - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 18,974 - - 3,628 974 18,001 5% Net (974) 274 274 (3,274) (974) (274) Cash Balance 1 26,987 24,711 Staffing Full Time - - - Part-Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 41 Form 3 42 2015 City of South Bend Monthly Financial Report Fund/Department Name Police Block Grants Month January Fund/Department Number 280 Date Updated 211912015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 3 3 0 (3) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 3 3 0 (3) 0% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - 0% Net 3 3 0 (3) Cash Balance 1 3,831 3,818 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Explain Significant Spending on Capital Projects Below: Form 3 42 Form 3 43 2015 City of South Bend Monthly Financial Report Fund/Department Name Economic Develop. Commission - Revenue Bonds Month January Fund/Department Number 281 Date Updated 211312015 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 24 24 3 (24) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 24 24 3 (24) 0% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - 0% Net 24 24 3 (24) Cash Balance 1 27,229 27,131 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 2015 City of South Bend Monthly Financial Report Fund/Department Name Emergency Medical Services Operating Fund/Department Number 288 Month January Date Updated 211812015 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 199,540 199,540 152,031 4,932,025 4% Interest Earnings 18,000 2,565 2,565 604 15,435 14% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 24,500 2,233 2,233 1,951 22,267 9% Transfers In 502,000 - - - 502,000 0% Total Revenue 5,676,065 204,337 204,337 154,587 5,471,728 4% Expenditures Personnel 4,840,253 - - - 4,840,253 0% Supplies 292,000 16,853 16,853 1,139 130,030 145,117 50% Services 375,337 5,041 5,041 19,082 28,001 342,295 9% Debt Service 448,773 226,083 226,083 20,333 2,364 220,326 51% Capital 149,003 - - 408,653 149,003 - 100% Transfers Out 750,000 - - - - 750,000 0% Total Expenditures 6,855.366 247.977 247.977 449.207 309,398 6,297,991 8% Balance Full Time 51.00 51.00 51.00 Part -Time /Seasonal/Temporary - - - Total 51.00 51.00 51.00 ain oigmricanr mevenue, r-xpenanure ana ararring unangesivanances rseiow: revenues in this account are generated through user fees for the South Bend Fire Department EMS division, Training Bureau, and Inspections. Fund captures personnel and operating expenses primarily for Emergency Medical Services division and reflects a portion of the cost ciated with operating ambulances. r-xpiain aigmncam apenaing on �,apnai rrojecrs aeiow: None Form 3 44 Form 3 45 2015 City of South Bend Monthly Financial Report Fund/Department Name HAZMAT Month January Fund/Department Number 289 Date Updated 211812015 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 3,697 3,697 - 6,303 37% Interest Earnings - 35 35 2 (35) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 10,000 3,732 3,732 2 6,268 37% Expenditures Personnel - - - - - - 0% Supplies 31,530 20,939 20,939 590 10,000 68% Services - - - - - 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 31,530 20,939 20,939 - 590 10,000 68% Net (21,530) (17,207) (17,207) 2 (590) (3,733) Cash Balance 1 22,422 16,209 Staffing Full Time - Part-Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 45 Form 3 46 2015 City of South Bend Monthly Financial Report Fund/Department Name Indiana River Rescue Month January Fund/Department Number 291 Date Updated 211812015 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 3,000 3,000 2,400 42,000 7% Interest Earnings 200 93 93 12 107 46% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 45,200 3,093 3,093 2,412 42,107 7% Expenditures Personnel 7,500 - - - 7,500 0% Supplies 8,800 142 8,800 0% Services 79,500 57 79,500 0% Debt Service - - - - 0% Capital 25,000 20,997 4,003 84% Transfers Out - - - - 0% Total Expenditures 120,800 - - 199 20,997 99,803 17% Net (75,600) 3,093 3,093 2,213 (20,997) (57,696) Cash Balance 1 108,492 97,932 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 46 Form 3 47 2015 City of South Bend Monthly Financial Report Fund/Department Name Police Grants Month January Fund/Department Number 292 Date Updated 211612015 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 (55) 0% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 90,000 55 55 66,716 89,945 0% Expenditures Personnel - - - - - - 0% Supplies 14,186 14,186 100% Services 959 959 100% Debt Service - - 0% Capital 90,000 90,000 0% Transfers Out - - - 0% Total Expenditures 105,145 - - - 15,145 90,000 14% Net (15,145) 55 55 66,716 (15,145) (55) Cash Balance 1 95,464 271,225 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 47 Form 3 48 2015 City of South Bend Monthly Financial Report Fund/Department Name Regional Police Academy Month January Fund/Department Number 294 Date Updated 211612015 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 10,950 10,950 13,150 9,050 55% Interest Earnings - 60 60 9 (60) 0% Bond Proceeds - - - - 0% Donations - - 0% Other Income 2,000 2,000 0% Transfers In - - - - - 0% Total Revenue 22,000 11,010 11,010 13,159 10,990 50% Expenditures Personnel - - - - - 0% Supplies 1,750 - - - 1,750 0% Services 22,000 2,724 2,724 136 19,276 12% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 23,750 2,724 2,724 136 21,026 11% Net (1,750) 8,286 8,286 13,023 (10,036) Cash Balance 1 76,569 81,107 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was established to fund the cost of course material and instructors at the South Bend Police Academy. The enforcement courses are offered to other police departments who pay a fee to attend the training. Explain Significant Spending on Capital Projects Below: Form 3 48 Form 3 49 2015 City of South Bend Monthly Financial Report Fund/Department Name COPS MORE Grant Month January Fund/Department Number 295 Date Updated 211612015 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 94 94 13 256 27% Bond Proceeds - - - - - 0% Donations 3,250 - - - 3,250 0% Other Income 38,000 470 470 850 37,530 1% Transfers In - - - - - 0% Total Revenue 128,258 564 564 863 127,694 0% Expenditures Personnel - - - - - - 0% Supplies 45,735 20,490 20,490 - 10,483 14,762 68% Services 66,000 - - 175 - 66,000 0% Debt Service - - - 0% Capital 60,600 60,600 0% Transfers Out - - - - - - 0% Total Expenditures 172,335 20,490 20,490 175 10,483 141,362 18% Net (44,077) (19,926) (19,926) 688 (10,483) (13,668) Cash Balance 1 86,307 114,031 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 49 Form 3 50 2015 City of South Bend Monthly Financial Report Fund/Department Name Police Federal Drug Enforcement Month January Fund/Department Number 299 Date Updated 211712015 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 1,729 73,271 2% Charges for Services - - - - - 0% Interest Earnings 1,000 88 88 91 912 9% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 1,000 1,000 0% Transfers In - - - - - 0% Total Revenue 77,000 1,817 1,817 91 75,183 2% Expenditures Personnel - - - - - - 0% Supplies 54,759 9,759 9,759 18,722 26,278 52% Services 104,201 8,626 8,626 5,575 90,000 14% Debt Service - - - - - 0% Capital 90,000 90,000 0% Transfers Out - - - - - 0% Total Expenditures 248,960 18,385 18,385 24,297 206,278 17% Net (171,960) (16,568) (16,568) 91 (24,297) (131,095) Cash Balance 1 328,974 385,251 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 50 Form 3 51 2015 City of South Bend Monthly Financial Report Fund/Department Name County Option Income Tax Month January Fund/Department Number 404 Date Updated 211312015 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,857,724 738,326 738,326 720,484 8,119,398 8% Other Taxes - - - - - 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 58,000 13,383 13,383 1,910 44,617 23% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 966,059 41,340 41,340 43,059 924,719 4% Transfers In - - - - - 0% Total Revenue 9,881,783 793,050 793,050 765,453 9,088,733 8% Expenditures Personnel 427,077 25,517 25,517 - - 401,560 6% Supplies 1,384,804 47,944 47,944 114,742 11,182 1,325,678 4% Services 8,159,164 470,044 470,044 809,396 191,928 7,497,192 8% Debt Service 2,487,504 753,365 753,365 688,172 - 1,734,139 30% Capital 1,701,822 25,325 25,325 - 865,498 811,000 52% Transfers Out 1,500,000 - - - - 1,500,000 0% Total Expenditures 15,660,371 1,322,195 1,322,195 1,612,310 1,068,608 13,269,568 15% Net (5,778,588) (529,145) (529,145) (846,857) (1,068,608) (4,180,835) Cash Balance 1 14,432,231 14,059,206 Staffing Full Time 4.00 3.00 - Part -Time /Seasonal/Temporary - - Total 4.00 3. Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 1 st 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 51 Form 3 52 2015 City of South Bend Monthly Financial Report Fund/Department Name Economic Development Income Tax Month January Fund/Department Number 408 Date Updated 211812015 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,970,839 765,101 765,101 733,068 8,205,738 9% Other Taxes - - - - - 0% Grants /Intergovernmental - - - - 0% Charges for Services 504,660 150,082 150,082 - 354,578 30% Interest Earnings 40,000 8,869 8,869 1,342 31,131 22% Bond Proceeds - - - - - 0% Donations - 0% Other Income 11,948 0% Transfers In - - - - 0% Total Revenue 9,515,499 924,052 924,052 746,358 8,591,447 15% Expenditures Personnel - - - 50,463 - 0% Supplies - - - - - 0% Services 1,222,523 135,295 135,295 217,927 451,310 635,918 48% Debt Service 1,917,313 438,568 438,568 962,550 - 1,478,745 23% Capital 4,000 3,200 3,200 - 800 - 100% Transfers Out 6,483,782 - - 998,879 - 6,483,782 0% Total Expenditures 9,627,618 577,063 577,063 2,229,819 452,110 8,598,445 11% Net (112,119) 346,989 346,989 (1,483,461) (452,110) (6,998) Cash Balance 1 10,517,215 9,358,667 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 52 Form 3 53 2015 City of South Bend Monthly Financial Report Fund/Department Name Urban Development Action Grant Month January Fund/Department Number 410 Date Updated 211312015 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 24 24 4 86 22% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 438,203 438,203 0% Transfers In - - - - - 0% Total Revenue 438,313 24 24 4 438,289 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 24 24 4 86 Cash Balance 1 27,690 27,591 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. New payments from the BDC are expected in 2015. Explain Significant Spending on Capital Projects Below: Form 3 53 Form 3 54 2015 City of South Bend Monthly Financial Report Fund/Department Name Project Releaf Month January Fund/Department Number 655 Date Updated 211612015 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,473 36,473 36,254 392,527 9% Interest Earnings 2,700 899 899 119 1,801 33% Bond Proceeds - - - 0% Donations - - 0% Other Income 0% Transfers In - - - 0% Total Revenue 431,700 37,371 37,371 36,373 394,329 9% Expenditures Personnel 64,081 1,403 1,403 1,333 62,678 2% Supplies 6,000 6,000 0% Services 36,058 2,335 2,335 1,481 33,723 6% Debt Service 72,219 11,619 11,619 11,619 60,600 16% Capital - - - 0% Transfers Out 350,000 350,000 0% Total Expenditures 528,358 15,357 15,357 14,433 513,001 3% Net (96,658) 22,015 22,015 21,940 (118,673) Cash Balance 1 1,000,807 960,028 Staffing Full Time - - Part -Time /Seasonal/Temporary /Seasonal/Temporary 2.16 Total 2.16 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Form 3 54 Form 3 55 2015 City of South Bend Monthly Financial Report Fund/Department Name Police K -9 Unit Month January Fund/Department Number 705 Date Updated 211712015 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 3 3 7 30% Bond Proceeds - - - - 0% Donations 1,990 500 500 1,490 25% Other Income - - - - 0% Transfers In - - - - 0% Total Revenue 2,000 503 503 1,497 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 - 503 503 - (503) Cash Balance 1 3,822 1,313 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 55 2015 City of South Bend Monthly Financial Report Fund/Department Name Football Hall of Fame Debt Service Fund/Department Number 313 Month January Date Updated 211312015 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 45,358 45,358 0% Grants /Intergovernmental 51,078 4,256 4,256 7,140 46,822 8% Charges for Services - - - - - 0% Interest Earnings 41 41 (41) 0% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,274,056 4,297 4,297 7,140 1,269,759 0% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 1,266,820 636,000 636,000 634,500 630,820 50% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 1,266,820 636,000 636,000 634,500 630,820 50% Nar 7 WAR Iart1 7n%% IA-11 7n '41 1927 rani a�a o3a Balance Full Time Part -Time /Seasonal/Temporary Total ain oignmcanr reevenue, r-xpenanure ana orarrmg unangesivanances neiow: 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 ge Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will ally have a negative cash balance until the property tax distributions are received. PILOT taxes paid by the utilities are received monthly in this The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. r-xpiain aigmncam apenaing on �.apnai rrojecrs aeiow: None Form 3 56 Form 3 57 2015 City of South Bend Monthly Financial Report Fund/Department Name Emergency Medical Services Capital Month January Fund/Department Number 287 Date Updated 211812015 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 750,000 750,000 0% Total Revenue 750,000 - 750,000 0% Expenditures Personnel - - 0% Supplies 0% Services 0% Debt Service 0% Capital 750,000 35,728 714,272 5% Transfers Out - - - 0% Total Expenditures 750,000 35,728 714,272 5% Net - - (35,728)1 35,728 Cash Balance 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 57 Form 3 58 2015 City of South Bend Monthly Financial Report Fund/Department Name Professional Sports Development Month January Fund/Department Number 377 Date Updated 211312015 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 63,326 63,326 66,547 546,674 10% Charges for Services - - - - - 0% Interest Earnings 1,100 526 526 101 574 48% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 60,661 29,523 29,523 34,608 31,138 49% Transfers In - - - - - 0% Total Revenue 671,761 93,375 93,375 101,256 578,386 14% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 854,803 480,773 480,773 382,873 374,030 56% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 854,803 480,773 480,773 382,873 374,030 56% Net (183,042) (387,398) (387,398) (281,617) 204,356 Cash Balance 1 208,695 560,440 Staffing Full Time - Part-Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Effective January 1, 2013, this fund no longer collects hotel /motel tax allocations from St. Joseph County for payment to the Hall of Fame. This fund is currenty used for debt. PSDA tax revenue is generally received from the State on a monthly basis. PSDA tax is a special tax received from the State of Indiana based on the sales tax, income tax and local income taxes collected in the PSDA area (which includes Coveleski Stadium, Century Center, Morris Performing Arts Center and Studebaker National Museum). Coveleski Stadium generates the majority of PSDA revenue. The January debt service payment has been made for 2015. The final debt service payment on the 2010 Coveleski Stadium bonds was paid January 15, 2013. Explain Significant Spending on Capital Projects Below: Form 3 58 Form 3 59 2015 City of South Bend Monthly Financial Report Fund/Department Name Coveleski Stadium Capital Month January Fund/Department Number 401 Date Updated 2/912015 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 36 36 3 64 36% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 15,100 36 36 3 15,064 0% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - - - 0% Net 15,100 36 36 3 15,064 Cash Balance 1 40,486 26,854 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 59 Form 3 60 2015 City of South Bend Monthly Financial Report Fund/Department Name Zoo Endowment Month January Fund/Department Number 403 Date Updated 2/912015 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 43 43 6 157 22% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 200 43 43 6 157 E% 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) 43 43 6 (48,843) Cash Balance 1 49,205 49,029 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 60 Form 3 61 2015 City of South Bend Monthly Financial Report Fund/Department Name Park Nonreverting Capital Month January Fund/Department Number 405 Date Updated 2/912015 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 3 3 27 33,997 0% Interest Earnings 2,200 432 432 52 1,768 20% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 12,000 4,000 4,000 8,000 33% Transfers In 95,500 - - - 95,500 0% Total Revenue 143,700 4,435 4,435 79 139,265 3% Expenditures Personnel - - - - - - 0% Supplies 67,273 4,814 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 - 4,814 18,520 174,414 10% Net (49,233) 4,435 4,435 (4,735) (18,520) (35,149) Cash Balance 1 525,599 568,156 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 61 Form 3 62 2015 City of South Bend Monthly Financial Report Fund/Department Name Cumulative Capital Develo ment Month January Fund/Department Number 406 Date Updated 211812015 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 4,349 3,891 85,842 5% Grants /Intergovernmental - - - - - 0% Charges for Services - - - - - 0% Interest Earnings 2,500 498 498 96 2,002 20% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 542,691 4,847 4,847 3,987 537,844 1% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 542,691 112,650 112,650 112,650 430,041 21% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 542,691 112,650 112,650 112,650 430,041 21% Net - (107,803) (107,803) (108,663) 107,803 Cash Balance 1 473,447 677,135 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 62 Form 3 63 2015 City of South Bend Monthly Financial Report Fund/Department Name Cumulative Capital Im rovement Month January Fund/Department Number 407 Date Updated 211812015 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 215 215 21 (65) 143% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 25,000 25,000 0% Transfers In - - - - - 0% Total Revenue 422,150 215 215 21 421,935 0% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 365,625 183,750 183,750 185,250 181,875 50% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 365,625 183,750 183,750 185,250 181,875 50% Net 56,525 (183,535) (183,535) (185,229) 240,060 Cash Balance 1 65,948 (8,505) Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 63 2015 City of South Bend Monthly Financial Report Fund/Department Name Major Moves Construction Month January Fund/Department Number 412 Date Updated 211312015 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 3,344 3,344 919 21,656 13% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 786,187 786,187 0% Transfers In - - - - - 0% Total Revenue 811,187 3,344 3,344 919 807,843 0% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 3,096,061 55,859 55,859 29,594 1,710,201 1,330,001 57% Transfers Out - - - - - - 0% Total Expenditures 3,096,061 55,859 55,859 29,594 1,710,201 1,330,001 57% Net (2,284,874) (52,515) (52,515) (28,675) (1,710,201) (522,157) Cash Balance 1 3,589,147 1 7,115,222 Staffing Full Time - Part-Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. The amounts outstanding were $886,677 (Fund 435 - Douglas Road) and $4,740,818 (Fund 436 - Eddy Street /Triangle) at 31 January 2015 with payments received each February and August. These revenue streams are scheduled to cease in 2030. 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 /LW W roundabout, and $30,000 for Corridor alley improvements. Form 3 64 2015 City of South Bend Monthly Financial Report Fund/Department Name Morris Performing Arts Center Capital Fund/Department Number 416 Month January Date Updated 211012015 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 7,870 7,870 7,305 92,130 8% Interest Earnings 1,500 453 453 57 1,047 30% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 101,500 8,323 8,323 7,362 93,177 8% Expenditures Personnel - - - - - - 0% Supplies 21,210 1,268 1,268 15,926 4,016 81% Services 49,038 - - - 49,038 0% Debt Service - - 0% Capital 0% Transfers Out 0% Total Expenditures 70.248 1.268 1.268 15,926 53,054 24% Balance Full Time Part -Time /Seasonal/Temporary Total 172 r-xpiain oignmcanr mevenue, txpenanure ana orarring unangesnranances tseiow: 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. n aigmncam apenamg on uapnai rrotecrs aeiow: are no Capital projects budgeted for this year. Form 3 65 Form 3 66 2015 City of South Bend Monthly Financial Report Fund/Department Name Community Revitalization Enhancement District Month January Fund/Department Number 434 Date Updated 211312015 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 28 28 30 (28) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 650,000 28 28 30 649,972 0% Expenditures Personnel - - - - - 0% Supplies - - 0% Services 462,206 - - - 462,206 0% Debt Service 187,794 3,897 3,897 20,975 183,897 2% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 650,000 3,897 3,897 20,975 646,103 1% Net (3,869) (3,869) (20,945) 3,869 Cash Balance 5,969 (11,408) Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: CREED is derived from State sale taxes generated within the CREED 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 66 Form 3 67 2015 City of South Bend Monthly Financial Report Fund/Department Name Palais Royale Historic Preservation Month January Fund/Department Number 450 Date Updated 211012015 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 1,225 1,225 1,796 14,775 8% Interest Earnings 150 56 56 8 94 37% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 16,150 1,281 1,281 1,803 14,869 8% 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 - 1,281 1,281 1,803 Cash Balance 1 64,442 55,198 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. No capital projects are planned for 2015. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund. Form 3 67 Form 3 68 2015 City of South Bend Monthly Financial Report Fund/Department Name Football Hall of Fame Capital Month January Fund/Department Number 677 Date Updated 211312015 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 495 495 85 2,005 20% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 2,500 495 495 85 2,005 20% Expenditures Personnel - - - - - 0% Supplies 15,000 - - 365 15,000 0% Services 173,824 6,843 6,843 5,908 166,981 4% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 188,824 6,843 6,843 6,273 181,981 4% Net (186,324) (6,348) (6,348) (6,188) (179,976) Cash Balance 1 552,872 652,218 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 68 Form 3 69 2014 City of South Bend Monthly Financial Report Fund/Department Name Consolidated Building Fund Month January Fund/Department Number 600 Date Updated 211112015 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 87,718 87,718 95,396 1,401,184 6% Interest Earnings 1,000 648 648 22 352 65% Bond Proceeds - - - - - 0% Donations - 75 75 160 (75) 0% Other Income 1,067 - - - 1,067 0% Transfers In 2,663,144 - - 576,640 2,663,144 0% Total Revenue 4,154,113 88,442 88,442 672,217 4,065,671 2% Expenditures Personnel 2,454,138 239,220 239,220 195,659 2,160 2,212,758 10% Supplies 181,483 7,549 7,549 9,992 23,056 150,878 17% Services 1,549,288 32,624 32,624 39,909 84,884 1,431,779 8% Debt Service 20,492 2,983 2,983 2,905 867 16,642 19% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,205,401 282,377 282,377 248,465 110,967 3,812,057 9% Net (51,288) (193,935) (193,935) 423,752 (110,967)1 253,614 Cash Balance 540,834 576,114 Staffing Full Time 36.00 36.00 - Part -Time /Seasonal/Temporary /Seasonal/Temporary 2.00 2.00 Total 38.00 38.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund now comprises the Consolidated Building Department, most of Code Enforcement and Animal Control. Code and Animal Control are managed together but are run separately from the Building Department per Council's wishes. There are 9 additional positions for Code Enforcement that are paid from the EDIT fund (408) as it was not possible to increase the expenditures of this fund to accommodate them as a result of an advertising limitation. The $2.3 million transfer is from the General Fund to cover Code and Animal Control activities which, unlike the Consolidated Building Department, are not enterprises by nature. Explain Significant Spending on Capital Projects Below: Capital includes 5 vehicles for Code Enforcement and 1 for the Building Department. Form 3 69 Form 3 70 2015 City of South Bend Monthly Financial Report Fund/Department Name Parking Garages Month January Fund/Department Number 601 Date Updated 211312015 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 77,130 77,130 94,897 896,796 8% Interest Earnings 4,000 958 958 117 3,042 24% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 130,800 4,945 4,945 7,075 125,855 4% Transfers In - - - - - 0% Total Revenue 1,108,726 83,033 83,033 102,089 1,025,693 7% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 746,858 48,862 48,862 96,764 13,673 684,323 8% Debt Service - - - - - - 0% Capital 184,854 40,168 40,168 144,686 100% Transfers Out - - - - - 0% Total Expenditures 931,712 89,030 89,030 96,764 158,359 684,323 27% Net 177,014 (5,997) (5,997) 5,325 (158,359)1 341,370 Cash Balance 1 1,067,632 889,512 Staffing Full Time - - Part-Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 Fagade, Elevator Repairs and Door Repairs. These projects were begun in 2014 and will be finished in 2015. Other major repairs will be undertaken in 2015 will come from the Garage Study completed in 2014. Form 3 70 Form 3 71 2015 City of South Bend Monthly Financial Report Fund/Department Name Solid Waste O erations Month January Fund/Department Number 610 Date Updated 211212015 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 407,832 407,832 400,486 4,811,484 8% Interest Earnings 2,500 346 346 99 2,154 14% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 490,473 490,473 0% Transfers In - - - - - 0% Total Revenue 5,712,289 408,178 408,178 400,585 5,304,111 7% Expenditures Personnel 1,731, 390 171,970 171,970 183,380 1,500 1,557,920 10% Supplies 371,208 19,133 19,133 24,937 27,789 324,286 13% Services 2,991,595 254,385 254,385 233,391 1,071 2,736,139 9% Debt Service 26,859 - - - - 26,859 0% Capital - - - - - 0% Transfers Out 752,811 190,000 190,000 230,416 - 562,811 25% Total Expenditures 5,873,863 635,488 635,488 672,124 30,360 5,208,015 11% Net (161,574) (227,310) (227,310) (271,539) (30,360)1 96,096 Cash Balance 1 171,082 523,283 Staffing Full Time 25.20 24.20 Part -Time /Seasonal/Temporary /Seasonal/Temporary 8.00 7.00 Total 33.20 31.20 Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. Explain Significant Spending on Capital Projects Below: Form 3 71 Form 3 72 2015 City of South Bend Monthly Financial Report Fund/Department Name Solid Waste Capital Month January Fund/Department Number 611 Date Updated 211212015 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 33 21 167 17% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 752,811 190,000 190,000 230,416 562,811 25% Total Revenue 753,011 190,033 190,033 230,437 562,978 25% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 752,811 223,749 223,749 188,809 529,062 30% Capital - - - 75,986 - 0% Transfers Out - - - - - 0% Total Expenditures 752,811 223,749 223,749 264,795 529,062 30% Net 200 (33,716) (33,716) (34,359) 33,916 Cash Balance 1 1,484 84,082 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 January Fund/Department Number 620 Date Updated 2.16.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,060,291 1,060,291 985,445 13,578,112 7% Interest Earnings 9,000 3,691 3,691 406 5,309 41% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 93,580 113 113 31,677 93,467 0% Transfers In 19,500 1,554 1,554 643 17,946 8% Total Revenue 14,760,483 1,065,650 1,065,650 1,018,172 13,694,833 7% Expenditures Personnel 5,023,137 492,705 492,705 482,651 3,200 4,527,232 10% Supplies 1,516,896 29,629 29,629 72,396 70,905 1,416,361 7% Services 4,979,548 255,846 255,846 328,682 312,423 4,411,279 11% Debt Service 17,936 560 560 578 4,265 13,111 27% Capital - - - - - - 0% Transfers Out 4,306,954 161,884 161,884 314,278 - 4,145,070 4% Total Expenditures 15,844,471 940,625 940,625 1,198,585 390,793 14,513,053 8% Net (1,083,988) 125,024 125,024 (180,413) (390,793) (818,219) Cash Balance 1 4,430,070 1 3,327,359 Staffing Full Time 70.20 68.70 Part-Time /Seasonal/Temporary /Seasonal/Temporary 3.00 3.00 Total 73.20 71.70 Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. January 2014 service revenues are very comparable to previous year with the exception of no management fees being receipted in January 2013. A higher encumbrance amount is reported to due value orders being issued at the beginning of the year. Explain Significant Spending on Capital Projects Below: Form 3 73 Form 3 74 2015 City of South Bend Monthly Financial Report Fund/Department Name Water Works Capital Month January Fund/Department Number 622 Date Updated 2.16.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 2,776 2,776 453 7,224 28% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 10,000 2,776 2,776 453 7,224 5% Expenditures Personnel - - - - - 0% Supplies - 0% Services 3,600 0% Debt Service - - - - 0% Capital 838,893 15,382 15,382 67,463 756,048 10% Transfers Out - - - - - - 0% Total Expenditures 838,893 15,382 15,382 3,600 67,463 756,048 10% Net (828,893) (12,606) (12,606) (3,147) (67,463) (748,824) Cash Balance 1 3,112,675 3,528,578 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used for acquiring, constructing, and improving fixed assets. Explain Significant Spending on Capital Projects Below: Chlorine Auto Emergency Shut Off System $15,382 Rollover Encumbrance: Trucks (2) $67,463 Form 3 74 2015 City of South Bend Monthly Financial Report Fund/Department Name Water Works Bond Ca ital Fund/Department Number 623 Month January Date Updated 2.13.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 180 180 223 (180) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 180 180 223 (180) 0% Expenditures Personnel - - 0% Supplies 50,914 8,888 8,888 17,780 42,026 (0) 100% Services 2,171 2,171 2,171 0 100% Debt Service - - - - - - 0% Capital 219 219 (219) 0% Transfers Out - - - - - 0% Total Expenditures 53.085 11,278 11.278 17.780 42,026 (219) 100% Balance Full Time Part -Time /Seasonal/Temporary Total 1 r-xpiain oignmcanr mevenue, txpenanure ana orarrmg unangesnranances rseiow: 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 encumbrances, Pinhook Project's final construction pay application and a small final meter order. r-xpiain aigmncam apenaing on uapnai rrotecrs aeiow: Water Meters $8,888 Pinhook WT Effic Improv Proj(EngFees) $219 Boland Park PRV $2,171 Encumbrance: Water Meters $42,026 Form 3 75 Form 3 76 2015 City of South Bend Monthly Financial Report Fund/Department Name Water Works Customer De osit Month January Fund/Department Number 624 Date Updated 2.13.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 1,307 1,307 186 4,693 22% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 6,000 1,307 1,307 186 4,693 22% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 6,000 452 452 186 5,548 8% Total Expenditures 6,000 452 452 186 5,548 8% Net - 855 855 - (855) Cash Balance 1 1,483,637 1,453,663 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 76 2015 City of South Bend Monthly Financial Report Fund/Department Name Water Works Sinking Fund/Department Number 625 Month January Date Updated 2.13.15 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 5,000 468 468 196 4,532 9% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 2,045,078 - - 170,810 2,045,078 0% Total Revenue 2,050,078 468 468 171,006 2,049,610 0% Expenditures Personnel - - - - 0% Supplies 0% Services - 0% Debt Service 2,045,078 - 2,045,078 0% Capital - - - - 0% Transfers Out 5,000 465 465 196 4,535 9% Total Expenditures 2,050,078 465 465 196 2,049,613 0% Naf 3 3 17n R1n _ 1-41 Balance 4.658 176.147 Full Time Part -Time /Seasonal/Temporary Total r-xpiain oigmricanr mevenue, txpenanure ana ararrmg unangesivanances neiow: 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. A January transfer in was not disbursed from the operating fund but will be included in February's transfer. n aigmncam apenaing on �.apnai rrojecrs aeiow: Form 3 77 Form 3 78 2015 City of South Bend Monthly Financial Report Fund/Department Name Water Works Bond Reserve Month January Fund/Department Number 626 Date Updated 2.13.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 1,425 1,425 197 (1,425) 0% Bond Proceeds - - - 0% Donations 0% Other Income - 0% Transfers In - - 8,564 0% Total Revenue 1,425 1,425 8,761 (1,425) 0% Expenditures Personnel - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - 0% Net 1,425 1,425 8,761 (1,425) Cash Balance 1 1,648,103 1,574,437 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The purpose of this fund is to ensure compliance with certain debt service bond covenants. Balance in fund is determined by debt service financing arrangements at bond issuance. All maximum reserve requirement amounts have been fully satisfied. 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 O erations & Maintenance Month January Fund/Department Number 629 Date Updated 2.13.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 1,840 1,840 261 6,660 22% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 154,249 - - - 154,249 0% Total Revenue 162,749 1,840 1,840 261 160,909 1% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 8,500 637 637 261 7,863 7% Total Expenditures 8,500 637 637 261 7,863 7% Net 154,249 1,203 1,203 153,046 Cash Balance 1 2,085,039 2,031,532 Staffing Full Time - - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The purpose of this fund is to hold cash reserves to serve as fiscal protection against the risk of revenue shortfalls, emergencies and other economic risks that may impact the Water Utility's ability to meet financial commitments. Additional money will be transferred in during the month of February to satisfy 100% of 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 January Fund/Department Number 640 Date Updated 211612015 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 50,523 50,523 47,660 497,477 9% Interest Earnings 1,200 1,330 1,330 173 (130) 111% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 549,200 51,853 51,853 47,833 497,347 9% Expenditures Personnel 206,842 19,867 19,867 12,781 186,975 10% Supplies 28,603 162 162 554 28,441 1% Services 281,802 1,421 1,421 3,915 280,381 1% Debt Service 28,456 28,456 0% Capital - - - - 0% Transfers Out - - - - - 0% Total Expenditures 545,703 21,449 21,449 17,250 524,254 4% Net 3,497 30,404 30,404 30,583 (26,907) Cash Balance 1 1,535,686 1,393,499 Staffing Full Time 2.10 2.10 - Part -Time /Seasonal/Temporary - - Total 2.10 2.10 Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 January Fund/Department Number 641 Date Updated 211312015 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,774,691 2,774,691 2,669,147 32,434,776 8% Interest Earnings 22,000 7,786 7,786 902 14,214 35% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 88,000 2,507 2,507 4,373 85,493 3% Transfers In 15,000 1,045 1,045 422 13,955 7% Total Revenue 35,334,467 2,786,029 2,786,029 2,674,845 32,548,438 8% Expenditures Personnel 7,402,560 780,135 780,135 778,074 6,622,425 11% Supplies 2,154,745 96,072 96,072 124,894 239,930 1,818,743 16% Services 13,178,782 781,681 781,681 657,718 1,063,386 11,333,715 14% Debt Service 585,187 132,947 132,947 132,589 - 452,240 23% Capital - - - - - 0% Transfers Out 14,875,700 773,536 773,536 2,904,883 - 14,102,164 5% Total Expenditures 38,196,974 2,564,371 2,564,371 4,598,158 1,303,315 34,329,287 10% Net (2,862,507) 221,657 221,657 (1,923,313) (1,303,315) (1,780,849) Cash Balance 1 9,011,853 5,130,148 Staffing Full Time 95.25 95.25 Part -Time /Seasonal/Temporary /Seasonal/Temporary 6.62 4.90 Total 101.87 100.15 Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 82 2015 City of South Bend Monthly Financial Report Fund/Department Name Sewage Works Ca ital Month January Fund/Department Number 642 Date Updated 211212015 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 3,385 3,385 563 35,615 9% 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 3,385 3,385 2,000,563 5,394,615 0% Expenditures Personnel - - - - - 0% Supplies - - - - 0% Services 36,043 8,239 8,239 27,803 0 100% Debt Service - - - - - - 0% Capital 9,035,667 30,876 30,876 978,994 3,658,922 5,345,870 41% Transfers Out - - - - - - 0% Total Expenditures 9,071,710 39,115 39,115 978,994 3,686,725 5,345,870 41% Net (3,673,710) (35,730) (35,730) 1,021,570 (3,686,725)1 48,745 Cash Balance 1 3,715,991 5,066,136 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used to purchase capital equipment and fund major renovations /restorations for the Wastewater and Sewer Departments. The primary source of income is from Sewage Works Operating Fund #641, which transfers funds here as needed. Projects budgeted this year include: Explain Significant Spending on Capital Projects Below: Year to Date totals spent include: Wastewater Treatment Plant Primary Clarifier rehab $39,115. Form 3 82 Form 3 83 2015 City of South Bend Monthly Financial Report Fund/Department Name Sewage Works Reserve Operations & Maint. Month January Fund/Department Number 643 Date Updated 211312015 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 3,020 3,020 422 11,980 20% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 235,612 - - 129,964 235,612 0% Total Revenue 250,612 3,020 3,020 130,386 247,592 1% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 15,000 1,045 1,045 422 13,955 7% Total Expenditures 15,000 1,045 1,045 422 13,955 7% Net 235,612 1,975 1,975 129,964 233,637 Cash Balance 1 3,422,564 3,422,564 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The sole purpose of this fund is to hold the equivalent of two months of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. Any transfers to this fund are done to adjust the balance as needed to stay in compliance. Explain Significant Spending on Capital Projects Below: Form 3 83 Form 3 84 2015 City of South Bend Monthly Financial Report Fund/Department Name Sewer Bond 2007 Month January Fund/Department Number 647 Date Updated 211312015 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 1 0 1,141 Staffing Full Time Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 2015 City of South Bend Monthly Financial Report Fund/Department Name Sewage Sinking Fund/Department Number 649 Month January Date Updated 211312015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 7,000 785 785 109 6,215 11% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 9,281,088 773,536 773,536 774,919 8,507,552 8% Total Revenue 9,288,088 774,321 774,321 775,028 8,513,767 8% Expenditures Personnel - - - - 0% Supplies - - - - 0% Services 2,500 1,000 1,000 500 1,500 40% Debt Service 9,279,609 - - - 9,279,609 0% Capital - - 0% Transfers Out - - - - - 0% Total Expenditures 9,282,109 1,000 1,000 500 9,281,109 0% Naf 9 Q7Q 771 191 773 191 77A 9;9R 1797 'td91 Balance Full Time Part -Time /Seasonal/Temporary Total 1.563.658 1 ain oigmricanr mevenue, r-xpenanure ana ararrmg unangesivanances rseiow: fund is used to pay all debt service obligations for Wastewater and Sewers. Mandatory transfers in from Operating Fund 641 are done in ified amounts each month to satisfy bond covenants. n aigmncam apenaing on �.apnai rrojecrs aeiow: Form 3 85 Form 3 86 2015 City of South Bend Monthly Financial Report Fund/Department Name Sewage Debt Service Reserve Month January Fund/Department Number 653 Date Updated 211312015 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 1 7,286,832 7,286,828 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This Debt Reserve fund is held in a separate account with Bank of NY Mellon Trust. A reconcilliation of that account is done monthly. The account was fully funded for existing debt in 2013. Explain Significant Spending on Capital Projects Below: Form 3 86 Form 3 87 2015 City of South Bend Monthly Financial Report Fund/Department Name Sewer Bond 2010 Month January Fund/Department Number 658 Date Updated 211312015 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% Bond Proceeds - 0% Donations 0% Other Income 0% Transfers In - 0% Total Revenue - 0 0% Expenditures Personnel - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - 0% Net 0 Cash Balance 1 2 2,216 Staffing Full Time Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 Form 3 88 2015 City of South Bend Monthly Financial Report Fund/Department Name Sewer Bond 2011 Month January Fund/Department Number 659 Date Updated 211312015 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 1,477 1,477 1,034 4,523 25% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 6,000 1,477 1,477 1,034 4,523 29% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 323,670 3,917 3,917 13,753 306,001 5% Debt Service - - - - - - 0% Capital 3,388,168 139,121 139,121 275,419 1,432,576 1,816,472 46% Transfers Out - - - - - - 0% Total Expenditures 3,711,838 143,037 143,037 275,419 1,446,329 2,122,472 11 43% Net (3,705,838) (141,560) (141,560) (274,385) (1,446,329) (2,117,949) Cash Balance 1 1,457,825 7,574,115 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 through 2014, this bond funded numerous projects including Diamond Ave. Trunk Sewer, Phase II $3.7 million, East Bank Sewer Separation, Phase II $2.8 million, East Bank Sewer Separation, Phase III $2.3 million, LaSalle School area Sewer Separation, $1.7 million, East Bank Sewer Separation, Phase III $545,000, Southwood Sewer Separation, $1,143,059, Diamond Ave. Trunk Sewer, Phase III $248,000, St. Joseph River CSO Stabilization $217,831, Secondary Clarifier Upgrade $154,068, Wastewater Treatment Plant Digester Upgrade $5,307,632. Current year project spending includes: Oliver Plow Phase 3 $3,917, and Digester Upgrade $139,120. Form 3 88 2015 City of South Bend Monthly Financial Report Fund/Department Name Sewer Bond 2012 Fund/Department Number 661 Month January Date Updated 211312015 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 14,968 14,968 2,373 5,032 75% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 20,000 14,968 14,968 2,373 5,032 75% Expenditures Personnel - - - - - 0% Supplies - - 0% Services 1,000,000 1,000,000 0% Debt Service - - - - - 0% Capital 15,624,275 39,170 39,170 272,470 1,698,031 13,887,074 11% Transfers Out - - - - - - 0% Total Expenditures 16,624.275 39.170 39,170 272.470 1.698.031 14.887.074 10% Balance Full Time Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: cx iain ai mncam apenuing on ua nai rro eccs aeiow: 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 Sep. $16,380, Fairfax Sewer $12,160, and misc other $10,630. Form 3 89 Form 3 90 2015 City of South Bend Monthly Financial Report Fund/Department Name 2013A Cost of Issuance Fund Month January Fund/Department Number 664 Date Updated 211312015 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 4 1 (4) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 4 4 1 (4) 0% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - 0% Net 4 4 1 (4) Cash Balance 1 4,484 4,468 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 needs to be transferred to whatever fund is appropriate, so this fund can be closed out. Explain Significant Spending on Capital Projects Below: Form 3 90 Form 3 91 2015 City of South Bend Monthly Financial Report Fund/Department Name Century Center Month January Fund/Department Number 670 Date Updated 211812015 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 1,313,436 0% Grants /Intergovernmental - - 0% Charges for Services 3,194,126 32,985 32,985 99,638 3,161,141 1% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 25,000 1,805 25,000 0% Transfers In - - - - - 0% Total Revenue 4,532,562 32,985 32,985 101,443 4,499,577 1% Expenditures Personnel 2,505,817 145,918 145,918 201,210 2,359,899 6% Supplies 496,646 19,602 19,602 23,480 477,044 4% Services 1,286,148 140,978 140,978 89,938 1,145,170 11% Debt Service - - - - - 0% Capital 243,951 243,951 0% Transfers Out - - - - - 0% Total Expenditures 4,532,562 306,498 306,498 314,628 4,226,064 7% Net (273,513) (273,513) (213,185) 273,513 Cash Balance 1 646,854 705,101 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 second installment was received in July 2014. 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 91 Form 3 92 2015 City of South Bend Monthly Financial Report Fund/Department Name Century Center Capital Month January Fund/Department Number 671 Date Updated 211812015 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 24 24 30 476 5% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 500 24 24 30 476 5% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - 0% Net 500 24 24 30 476 Cash Balance 1 1,418,687 1,757,727 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 will likely be budgeted mid -year for use on necessary items. Explain Significant Spending on Capital Projects Below: Form 3 92 Form 3 93 2015 City of South Bend Monthly Financial Report Fund/Department Name Central Services Month January Fund/Department Number 222 Date Updated 211212015 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 634,838 634,838 668,864 7,434,319 8% Interest Earnings 3,400 1,233 1,233 133 2,167 36% Bond Proceeds - 0% Donations - 0% Other Income 48,540 19,817 19,817 1,847 28,723 41% Transfers In - - - - - 0% Total Revenue 8,121,097 655,888 655,888 670,844 7,465,209 8% Expenditures Personnel 3,099,267 290,646 290,646 281,400 - 2,808,621 9% Supplies 167,428 (6,319) (6,319) (24,366) 6,648 167,099 0% Services 4,611,385 393,823 393,823 415,928 3,173,643 1,043,919 77% Debt Service 9,155 1,414 1,414 7,741 15% Capital 120,000 120,000 - 100% Transfers Out 271,850 - - - 271,850 0% Total Expenditures 8,279,085 679,565 679,565 672,962 3,300,291 4,299,230 48% Net (157,988) (23,676) (23,676) (2,119) (3,300,291)1 3,165,979 Cash Balance 1 1,562,395 1,608,231 Staffing Full Time 42.00 39.00 39.00 Part-Time /Seasonal/Temporary 2.00 1.00 1.00 Total 44.00 40.00 40.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 Jan we had 1,477 repairs. Average Fuel prices for January is $1.49 for Unleaded and $1.83 for Diesel. Budgeted amount per gallon is $3.45. 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 93 Form 3 94 2015 City of South Bend Monthly Financial Report Fund/Department Name Central Services Capital Month January Fund/Department Number 224 Date Updated 211912015 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 j 0% Net - - Cash Balance Staffing Full Time Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 94 2015 City of South Bend Monthly Financial Report Fund/Department Name Liability Insurance Fund/Department Number 226 Month January Date Updated 211312015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 1,222,727 99,293 99,293 235,157 1,123,434 8% Interest Earnings 20,500 5,051 5,051 684 15,449 25% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 17,000 17,000 0% Transfers In - - - - - 0% Total Revenue 1,260,227 104,344 104,344 235,841 1,155,883 8% Expenditures Personnel 212,170 20,913 20,913 19,262 - 191,257 10% Supplies 30,189 2,355 2,355 683 355 27,479 9% Services 2,814,432 238,970 238,970 83,461 60,169 2,515,293 11% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 3,056,791 262.238 262.238 103.406 60,524 1 2,734,029 1 11% Balance Full Time 3.00 3.00 Part -Time /Seasonal/Temporary - - Total 3.00 3.00 179 5.317 ain oignmcanr mevenue, r-xpenanure ana orarrmg unangesivanances rseiow: fund handles operations relating to business insurance and claims: property, liability, workers compensation, etc. and the operation of the y and risk department. n aigmncam apenaing on �,apnai rrojecrs aeiow: Form 3 95 Form 3 96 2015 City of South Bend Monthly Financial Report Fund/Department Name Take Home Vehicle Police Month January Fund/Department Number 278 Date Updated 211612015 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 7,060 7,060 7,160 54,040 12% Interest Earnings 2,000 455 455 58 1,545 23% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 61,100 7,060 7,060 7,160 54,040 12% Transfers In - - - - - 0% Total Revenue 124,200 14,575 14,575 14,378 109,625 12% 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 14,575 14,575 14,378 38,525 Cash Balance 1 530,587 467,330 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 96 Form 3 97 2015 City of South Bend Monthly Financial Report Fund/Department Name Self- Funded Employee Benefits Month January Fund/Department Number 711 Date Updated 211312015 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,764 1,225,764 938,326 14,974,236 8% Interest Earnings 23,345 3,733 3,733 758 19,612 16% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 19,222 19,222 15 (19,222) 0% Transfers In - - - - - 0% Total Revenue 16,223,345 1,248,718 1,248,718 939,099 - 14,974,627 8% Expenditures Personnel 4,326 1 1 - - 4,325 0% Supplies 21,875 80 80 91 800 20,995 4% Services 805,520 73,872 73,872 41,988 68,344 663,304 18% Insurance 15,865,214 956,818 956,818 484,850 53,797 14,854,599 6% Debt Service - - - - - - 0% Capital 0% Transfers Out - - - - - - 0% Total Expenditures 16,696,935 1,030,771 1,030,771 526,930 122,941 15,543,223 7% Net (473,590) 217,947 217,947 412,170 (122,941) (568,596) Cash Balance 1 4,274,934 6,073,617 Staffing Full Time - - Part -Time /Seasonal /Tem pora ry Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 97 Form 3 98 2015 City of South Bend Monthly Financial Report Fund/Department Name Unemployment Compensation Month January Fund/Department Number 713 Date Updated 211812015 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 8,473 8,530 217,523 4% Interest Earnings 800 212 212 33 588 27% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 226,796 8,685 8,685 8,563 218,111 4% Expenditures Personnel 200,000 2,960 2,960 9,071 197,040 1% Supplies - - - - - - 0% Services 26,796 7,166 7,166 602 13,200 6,430 76% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 226,796 10,126 10,126 9,673 13,200 203,470 10% Net (1,441) (1,441) (1,110) (13,200)1 14,641 Cash Balance 1 239,730 258,921 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 to pay the costs from. 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 98 Form 3 99 2015 City of South Bend Monthly Financial Report Fund/Department Name Firefighters Pension Month January Fund/Department Number 701 Date Updated 211912015 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 688 688 157 3,812 15% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 5,211,592 688 688 157 5,210,904 0% Expenditures Personnel 5,661,579 441,109 441,109 457,164 5,220,470 8% Supplies 200 - - - 200 0% Services 4,800 83 83 4,717 2% Debt Service - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 5,666,579 441,192 441,192 457,164 5,225,387 8% Net (454,987) (440,504) (440,504) (457,007) (14,483) Cash Balance 1 198,623 481,093 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 99 Form 3 100 2015 City of South Bend Monthly Financial Report Fund/Department Name Police Pension Month January Fund/Department Number 702 Date Updated 211612015 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 1,133 1,133 261 4,867 19% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 4,000 4,000 0% Transfers In - - - - - 0% Total Revenue 6,360,000 1,133 1,133 261 6,358,867 0% Expenditures Personnel 6,827,035 537,014 537,014 542,603 6,290,021 8% Supplies 800 - - - 800 0% Services 4,400 98 98 4,302 2% Debt Service - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 6,832,235 537,112 537,112 542,603 6,295,123 8% Net (472,235) (535,979) (535,979) (542,342) 63,744 Cash Balance 1 574,792 1,166,315 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 100 Form 3 101 2015 City of South Bend Monthly Financial Report Fund/Department Name City Cemetery Month January Fund/Department Number 730 Date Updated 2/912015 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 25 25 5 125 17% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 150 25 25 5 125 17% 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) 25 25 5 (19,875) Cash Balance 1 28,403 36,939 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 101 Form 3 102 2015 City of South Bend Monthly Financial Report Fund/Department Name River West Development Area (Airport TIF Month January Fund/Department Number 324 Date Updated 211312015 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 - (2,785) 0% Interest Earnings 75,000 29,722 29,722 2,720 45,278 40% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 1,400,000 17,527 17,527 - 1,382,473 1% Transfers In 5,000 317 317 133 4,683 6% Total Revenue 14,880,000 50,351 50,351 2,853 14,829,649 0% Expenditures Personnel - - - - 0% Supplies - - - - - 0% Services 6,296,933 163,298 163,298 270,553 1,613,531 4,520,104 28% Debt Service 6,214,305 2,112,690 2,112,690 1,132,971 - 4,101,615 34% Capital 8,199,359 451 451 - 2,202,818 5,996,090 27% Transfers Out - - - - - - 0% Total Expenditures 20,710,597 2,276,439 2,276,439 1,403,524 3,816,349 14,617,809 11 29% Net (5,830,597) (2,226,088) (2,226,088) (1,400,671) (3,816,349)1 211,840 Cash Balance 1 29,172,181 23,619,459 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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. As a result of the TIF realignment the activity in Fund 426 and a portion of the activity in Fund 420 will be distributed here. 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 103 2015 City of South Bend Monthly Financial Report Fund/Department Name Tax Incremental Financing TIF) - Downtown Month January Fund/Department Number 420 Date Updated 211312015 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 165 165 2,432 33,835 0% Interest Earnings 37,596 - - 3,670 37,596 0% Bond Proceeds - - - 0% Donations - - - 0% Other Income 277,106 - - 24,078 277,106 0% Transfers In 6,000 530 530 223 5,470 9% Total Revenue 4,344,202 695 695 30,403 4,343,507 0% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 485,622 6,768 6,768 44,919 478,854 1% Debt Service 2,879,693 957,248 957,248 955,676 1,922,445 33% Capital 1,171,854 - - 15,336 1,171,854 0% Transfers Out - - - - - 0% Total Expenditures 4,537,169 964,016 964,016 1,015,931 3,573,153 21% Net (192,967) (963,321) (963,321) (985,528) 770,354 Cash Balance 1 3,125,152 1,618,945 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 103 Form 3 104 2015 City of South Bend Monthly Financial Report Fund/Department Name TIF - West Washington Month January Fund/Department Number 422 Date Updated 211312015 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 996 996 58 1,004 50% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 422,000 996 996 58 421,004 0% Expenditures Personnel - - - - - 0% Supplies - - - 0% Services 30,600 319 30,600 100% Debt Service - - - 0% Capital 730,300 730,300 0% Transfers Out - - - - 0% Total Expenditures 760,900 - 319 30,600 730,300 4% Net (338,900) 996 996 (261) (30,600) (309,296) Cash Balance 1 1,196,745 612,701 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 Cemetery Project. Explain Significant Spending on Capital Projects Below: Form 3 104 Form 3 105 2015 City of South Bend Monthly Financial Report Fund/Department Name Redevelopment Retail & Lei hton Plaza Month January Fund/Department Number 425 Date Updated 211312015 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 79 79 12 (79) 0% Bond Proceeds - - - - 0% Donations - - - - - 0% Other Income 189,123 18,150 18,150 9,928 170,973 10% Transfers In - - - - - 0% Total Revenue 189,123 18,229 18,229 9,940 170,894 15% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 154,716 6,962 6,962 4,077 147,754 4% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 154,716 6,962 6,962 4,077 147,754 4% Net 34,407 11,267 11,267 5,863 23,140 Cash Balance 1 183,793 138,929 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 105 Form 3 106 2015 City of South Bend Monthly Financial Report Fund/Department Name TIF - Central Medical Service Area Month January Fund/Department Number 426 Date Updated 211312015 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 1,941 1,941 371 5,059 28% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 632,000 1,941 1,941 371 630,059 0% Expenditures Personnel - - - - - 0% Supplies - - - - 0% Services 179,125 2,452 179,126 (1) 100% Debt Service - - - - 0% Capital 1,610,908 166,772 1,610,908 0% Transfers Out - - 0% Total Expenditures 1,790,033 - 169,224 179,126 1,610,907 10% Net (1,158,033) 1,941 1,941 (168,853) (179,126) (980,848) Cash Balance 1 2,296,474 3,063,559 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 106 Form 3 107 2015 City of South Bend Monthly Financial Report Fund/Department Name River East Development Area NE Dev TIF Month January Fund/Department Number 429 Date Updated 211312015 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 3,858 3,858 349 3,142 55% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 19,357 19,357 (19,357) 0% Transfers In - - - - - 0% Total Revenue 827,000 23,215 23,215 349 803,785 3% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 118,094 35,090 35,090 617 63,644 19,360 84% Debt Service - - - - - - 0% Capital 1,321,430 77,866 77,866 110,129 1,133,435 14% Transfers Out - - - - - - 0% Total Expenditures 1,439,524 112,956 112,956 617 173,773 1,152,795 11 20% Net (612,524) (89,741) (89,741) (268) (173,773) (349,010) Cash Balance 1 4,466,739 3,008,523 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. As a result of the TIF realignment a portion of the activity in Fund 420 will be distributed here. 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 Form 3 108 2015 City of South Bend Monthly Financial Report Fund/Department Name TIF - Southside Development #1 Month January Fund/Department Number 430 Date Updated 211312015 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 4,144 4,144 402 5,856 41% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 2,410,000 4,144 4,144 402 2,405,856 0% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 555,022 33,453 33,453 77,688 521,568 1 100% Debt Service - - - - - - 0% Capital 2,287,513 401,917 401,917 4,261 265,595 1,620,001 29% Transfers Out - - - - - - 0% Total Expenditures 2,842,535 435,370 435,370 81,949 787,163 1,620,002 43% Net (432,535) (431,226) (431,226) (81,547) (787,163)1 785,854 Cash Balance 1 4,526,065 3,358,101 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 108 Form 3 109 2015 City of South Bend Monthly Financial Report Fund/Department Name TIF - Douglas Road Month January Fund/Department Number 435 Date Updated 211312015 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 161 161 23 589 21% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 320,750 161 161 23 320,589 0% Expenditures Personnel - - - - - 0% Supplies - - - 0% Services 4,200 160 4,200 100% Debt Service 341,189 - - 341,189 0% Capital - - 0% Transfers Out - - - - 0% Total Expenditures 345,389 - 160 4,200 341,189 11 1% Net (24,639) 161 161 (137) (4,200) (20,600) Cash Balance 1 221,591 294,463 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 109 Form 3 110 2015 City of South Bend Monthly Financial Report Fund/Department Name River East Residential NE Res TIF Month January Fund/Department Number 436 Date Updated 211312015 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 1,215 1,215 244 3,785 24% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 2,604,000 1,215 1,215 244 2,602,785 0% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 3,425,632 1,464,000 1,464,000 1,464,500 1,961,632 43% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 3,425,632 1,464,000 1,464,000 1,464,500 1,961,632 11 43% Net (821,632) (1,462,785) (1,462,785) (1,464,256) 641,153 Cash Balance 1 242,718 1,089,822 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Explain Significant Spending on Capital Projects Below: Form 3 110 Form 3 111 2015 City of South Bend Monthly Financial Report Fund/Department Name Redevelopment General Month January Fund/Department Number 433 Date Updated 211312015 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 9 9 3 243 4% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 252 9 9 3 243 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) 9 9 (6,069) (5,757) Cash Balance 1 10,099 19,679 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 111 Form 3 112 2015 City of South Bend Monthly Financial Report Fund/Department Name Certified Technology Park Month January Fund/Department Number 439 Date Updated 211312015 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 4,432 4,432 472 (28) 101% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 4,404 4,432 4,432 472 (28) 101% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 1,549,000 1,549,000 0% Transfers Out - - 0% Total Expenditures 1,549,000 - 1,549,000 0% Net (1,544,596) 4,432 4,432 472 (1,549,028) Cash Balance 1 5,024,993 3,683,068 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Capital funds are to be expended in Ignition Park and Innovation Park. Form 3 112 Form 3 113 2015 City of South Bend Monthly Financial Report Fund/Department Name Airport Urban Enterprise Zone Month January Fund/Department Number 454 Date Updated 211312015 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 333 333 48 1,167 22% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,500 333 333 48 1,167 E% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - - - 0% Net 1,500 333 333 48 1,167 Cash Balance 1 377,774 376,420 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 113 Form 3 114 2015 City of South Bend Monthly Financial Report Fund/Department Name Blackthorn Operations Month January Fund/Department Number 619 Date Updated 211312015 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 99,156 99,156 71,571 1,597,723 6% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,696,879 99,156 99,156 71,571 1,597,723 6% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 1,661,128 69,055 69,055 47,557 1,592,073 4% Debt Service - - - - - 0% Capital 10,578 10,578 0% Transfers Out - - - - - 0% Total Expenditures 1,671,706 69,055 69,055 47,557 1,602,651 4% Net 25,173 30,101 30,101 24,014 (4,928) Cash Balance 1 112,190 121,450 Staffing Full Time - - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 114 Form 3 115 2015 City of South Bend Monthly Financial Report Fund/Department Name Redevelopment Bond - Airport Taxable Month January Fund/Department Number 315 Date Updated 211312015 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 917 917 133 4,083 18% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 5,000 917 917 133 4,083 18% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 5,000 317 317 133 4,683 6% Total Expenditures 5,000 317 317 133 4,683 6% Net - 600 600 - (600) Cash Balance 1 1,038,904 1,038,904 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 115 Form 3 116 2015 City of South Bend Monthly Financial Report Fund/Department Name Coveleski Debt Service Reserve Month January Fund/Department Number 317 Date Updated 211312015 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 446 446 65 1,354 25% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,800 446 446 65 1,354 29% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - 0% Net 1,800 446 446 65 1,354 Cash Balance 1 505,349 503,537 Staffing Full Time - - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Debt service reserve fund. The fund is at the proper level per the bond financial advisor, Crowe Horvath. 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 116 2015 City of South Bend Monthly Financial Report Fund/Department Name Redevelopment Bond - Palais Ro ale Fund/Department Number 328 Month January Date Updated 211312015 Current Current Current Prior Local Income Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% 223 Charges for Services - - - Interest Earnings 6,000 1,532 1,532 Bond Proceeds - - - Donations 0% 223 4,468 Other Income 0% Transfers In - - Total Revenue 6,000 1,532 1,532 Expenditures 0% Personnel - - - Supplies 9% Services r1 nngi Debt Service Capital - - - Transfers Out 6,000 530 530 Total Expenditures 6,000 530 530 Net - 1,002 1,002 Cash Balance 1 1,735,840 Staffing Full Time - - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: n aigmncant apenuing on t.apnai rro /ects aeiow: 1 Form 3 117 0% 0% 0% 0% 0% 223 4,468 26% - - 0% 0% 0% 0% 223 4,468 26% 0% 0% 0% 0% 0% 223 5,470 9% 223 5,470 9% r1 nngi 1 Form 3 117 Form 3 118 2015 City of South Bend Monthly Financial Report Fund/Department Name TIF - Southside Development #3 Month January Fund/Department Number 432 Date Updated 211312015 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 5,246 5,246 762 19,754 21% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 25,000 5,246 5,246 762 19,754 21% Expenditures Personnel - - - - - 0% Supplies - - - 0% Services 1,000 - - 656 1,000 0% Debt Service 488,380 357,545 357,545 353,950 130,835 73% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 489,380 357,545 357,545 354,606 131,835 73% Net (464,380) (352,299) (352,299) (353,844) (112,081) Cash Balance 1 6,150,556 6,614,843 Staffing Full Time - Part -Time /Seasonal/Temporary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances 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 118