The URL can be used to link to this page

Home My WebLink About01-2014 Departmental Financial ReportPeriod Ending: January 31, 2014 Issued By: Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents Mayor Pete Buttigieg 2 - 2 Narrative 3 - 8 Summaries 9-21 General Fund 22-54 Deputy City Controller Special Revenue Funds 55-67 Rahman Johnson Debt Service /Capital Project Funds 68-96 Enterprise Funds 97-101 Internal Service Funds 102-104 Trust Funds 105-124 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Deputy Mayor Mark Neal Chief of Staff Kathryn Roos Deputy Chief of Staff Brian Pawlowski South Bend Common Council Controller John Murphy Deputy City Controller City Finance Director Rahman Johnson Financial Specialist Senior Cecil Eastman Department Heads Fiscal Officers Narrative, January 2014 Description of Monthly Departmental Financial Report Beginning with the March 2013 fiscal period, the City of South Bend has developed the attached Monthly Departmental Financial Report, its purpose to provide current year financial information for each City fund, and 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 201h of the month following the reporting period. The staff of the Department of Administration & Finance then summarizes the information and publishes this consolidated report no later than 30 days after the end of the reporting period. The Monthly Departmental Financial Report supplements —but does not replace —other financial reports that the City prepares such as the Monthly Financial Report, Controller's Cash Report, the Department of Local Government Finance's Annual Financial Report (AFR), or the Comprehensive Annual Financial Report (CAFR). Summary Trends & Observations One of the purposes of this report is to focus the reader's attention on current year revenue and expenditure trends in individual funds and General Fund departments. Please refer to the attached pages for this information. As of January 31, 2014, total revenue was $ 15,140,900, 5% of estimated revenue. As of January 31, 2013 total revenue received was $17,428,319 within the same funds. Annual revenues are budgeted to be $4.3 million less than 2013 and the comparative revenue drop corresponds to that circumstance. As of January 31, 2014, total expenditures were $30,389,620 and outstanding encumbrances were $38,769,617, a total of $69,169,237 which represents 18% of the amended expenditure budget. Most encumbrances are either holdovers from previous years or obligations for the remainder of the year; 2014 obligations are naturally large compared to the one month of activity that has passed. If encumbrances were excluded, expenditures were 8% of the amended expenditure budget at the end of the period, which is in line with expectations after one month. Encumbrances represent placeholders for future expenditures anticipated through the rest of the fiscal year and beyond but have not yet been incurred. Total expenditures were $25,610,409 as of January 31, 2013, the main differences being in operations for the Enterprise funds. In many funds there is a marked increase in Personnel expenditures in January which is due to 3 payroll check runs in the month, compared to the usual two. We hope that you find this Monthly Departmental Financial Report useful in understanding the finances of the City of South Bend a little bit better. If you have any questions regarding this report, please contact us at 574 - 235 -7702. Fund Control Type Dept Name City Funds General Fund City of South Bend Monthly Department Financial Report REVENUE SUMMARY January 31, 2014 55,453,616 1,025,130 1,025,131 3,167,863 54,428,485 2% Special Revenue 102 Rainy Day 52,000 1,105 1,105 4,405 50,895 2% 201 Parks & Recreation 10,980,407 92,435 92,435 158,861 10,887,972 1% 202 Motor Vehicle Highway 9,106,300 285,523 285,523 488,959 8,820,777 3% 203 Recreation Nonreverting 1,449,592 76,057 76,057 100,355 1,373,535 5% 209 Studebaker - Oliver Reverting Grants 305,000 139 139 554 304,861 0% 210 Economic Development State Grants 77,016 85 85 471 76,931 0% 211 Community & Economic Development Admn. 2,278,246 435,848 435,848 444,219 1,842,398 19% 212 Community & Economic Development 3,811,000 125,073 125,073 493,255 3,685,927 3% 216 Police State Seizures 35,900 20 20 74 35,880 0% 217 Gift, Donation, Bequest 7,290 10 10 827 7,280 0% 218 Police Curfew Violations 1,025 14 14 44 1,011 1% 220 Law Enforcement Continuing Education 211,000 30,248 30,248 25,208 180,752 14% 227 Loss Recovery 17,000 1,018 1,018 2,227 15,982 6% 244 Emergency Phone System 215,000 215,000 215,000 0 0 100% 249 Public Safety LOIT 6,391,029 531,895 531,895 492,566 5,859,134 8% 251 Local Roads & Streets 1,088,000 87,148 87,148 83,847 1,000,852 8% 252 Excess Welfare Distribution 0 0 0 1 0 0% 258 Human Rights Federal Grant 210,700 89 89 264 210,611 0% 271 Eastrace Waterway 100 2 2 7 98 2% 273 Morris PAC / Palais Royale Marketing 8,100 354 354 23 7,746 4% 280 Police Block Grants 0 0 0 2 0 0% 281 Economic Develop. Commission - Revenue Bonds 0 3 3 14 -3 0% 289 HAZMAT 10,000 2 2 1 9,998 0% 291 Indiana River Rescue 45,200 2,412 2,412 2,561 42,788 5% 292 Police Grants 0 66,717 66,717 0 - 66,717 0% 294 Regional Police Academy 22,000 13,159 13,159 10,138 8,841 60% 295 COPS MORE Grant 41,600 863 863 1,085 40,737 2% 299 Police Federal Drug Enforcement 77,000 91 91 2,320 76,909 0% 404 County Option Income Tax 9,270,187 765,453 765,453 702,571 8,504,734 8% 408 Economic Development Income Tax 9,346,481 746,359 746,359 686,567 8,600,122 8% 410 Urban Development Action Grant 110 4 4 460 106 4% 655 Project Releaf 431,700 36,373 36,373 36,186 395,327 8% 705 Police K -9 Unit 2,000 0 0 1 2,000 0% Special Revenue Total 55,490,983 3,513,498 3,513,498 3,738,073 51,977,485 6% City Debt Service 313 Football Hall of Fame Debt Service 1,268,116 7,140 7,140 5,956 1,260,976 1% City Debt Service Total 1,268,116 7,140 7,140 5,956 1,260,976 1% Capital Project 288 Emergency Medical Services Capital Improv. 2,661,000 154,586 154,586 158,312 2,506,414 6% 377 Professional Sports Development 678,228 101,256 101,256 103,569 576,972 15% 401 Coveleski Stadium Capital 500 3 3 14 497 1% 403 Zoo Endowment 2,900 6 6 25 2,894 0% 405 Park Nonreverting Capital 195,700 79 79 329 195,621 0% 406 Cumulative Capital Development 568,516 3,987 3,987 4,267 564,529 1% 407 Cumulative Capital Improvement 434,150 21 21 50 434,129 0% 412 Major Moves Construction 581,798 919 919 4,050 580,879 0% 416 Morris Performing Arts Center Capital 101,500 7,362 7,362 946 94,138 7% 434 Community Revitalization Enhancement District 651,000 30 30 106 650,970 0% 450 Palais Royale Historic Preservation 16,125 1,803 1,803 1,280 14,322 11% 677 Football Hall of Fame Capital 2,500 85 85 369 2,415 3% Capital Project Total 5,893,917 270,138 270,138 273,317 5,623,779 5% Enterprise 600 Consolidated Building Fund 3,812,560 672,217 672,217 88,757 3,140,343 18% 601 Parking Garages 1,040,400 102,089 102,089 66,320 938,311 10% 610 Solid Waste Operations 5,257,701 400,585 400,585 399,588 4,857,116 8% 611 Solid Waste Capital 736,202 230,437 230,437 279,339 505,765 31% City of South Bend Monthly Department Financial Report REVENUE SUMMARY January 31, 2014 ,q Fund - Current Amended Current Percent .. Control Type Dept Name Budget Budget City Fu Enterpi620 Water Works Operations 14,711,333 1,018,172 1,018,172 1,043,997 13,693,161 7% 622 Water Works Capital 10,000 453 453 2,126 9,547 5% 623 Water Works Bond Capital 5,000 223 223 2,976 4,777 4% 624 Water Works Customer Deposit 6,000 186 186 722 5,814 3% 625 Water Works Sinking 2,057,224 171,006 171,006 170,955 1,886,218 8% 626 Water Works Bond Reserve 90,073 8,761 8,761 26,059 81,312 10% 629 Water Works Reserve Operations & Maintenance 70,312 261 261 46,320 70,051 0% 640 Sewer Repair Insurance 549,200 47,833 47,833 45,161 501,367 9% 641 Sewage Works Operations 34,553,188 2,674,845 2,674,845 2,369,318 31,878,343 8% 642 Sewage Works Capital 3,566,580 2,000,563 2,000,563 4,546 1,566,017 56% 643 Sewage Works Reserve Operations & Maint. 238,715 130,386 130,386 1,586 108,329 55% 645 Sewer Bond 2004/2006 0 0 0 0 0 0% 647 Sewer Bond 2007 0 1 0 10 0 0% 649 Sewage Sinking 9,804,645 775,028 775,028 814,673 9,029,617 8% 650 Clay Sewage 0 0 0 0 0 0% 651 Sewage Bond 20078 0 0 0 20 0 0% 653 Sewage Debt Service Reserve 0 0 0 3,524 0 0% 658 Sewer Bond 2010 0 0 0 58 0 0% 659 Sewer Bond 2011 25,000 1,034 1,034 5,214 23,966 4% 661 Sewer Bond 2012 45,000 2,373 2,373 0 42,627 5% 663 Sewer Bond 2013 60,000 0 0 0 60,000 0% 664 2013A Cost of Issuance Fund 0 1 1 0 -1 0% 665 2014 Sewer Bond 21,000,000 0 0 0 21,000,000 0% 670 Century Center 4,564,898 101,443 101,443 791,035 4,463,455 2% 671 Century Center Capital 100,500 30 30 100,022 100,470 0% Enterprise Total 102,304,531 8,337,927 8,337,926 6,262,324 93,966,605 8% Internal Service 222 Central Services 7,847,374 670,844 670,844 594,468 7,176,530 9% 226 Liability Insurance 2,898,690 235,841 235,841 250,264 2,662,849 8% 278 Take Home Vehicle Police 123,160 14,378 14,378 9,821 108,782 12% 711 Self- Funded Employee Benefits 13,418,450 939,099 939,099 1,006,296 12,479,351 7% 713 Unemployment Compensation 236,898 8,564 8,564 28,475 228,334 4% Internal Service Total 24,524,572 1,868,725 1,868,725 1,889,324 22,655,847 8% Trust& Agency 701 Firefighters Pension 5,391,332 157 157 691 5,391,175 0% 702 Police Pension 6,310,000 261 261 1,451 6,309,739 0% 703 Police /Fire 1977 Pension 420,791 0% 730 City Cemetery 250 5 5 21 245 2% Trust & Agency Total 11,701,582 423 423 422,954 11,701,159 0% City Funds Total 1�11 111111 256,637,317 15,022,98 Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF Revenue - Airport 13,484,612 2,853 2,853 74,452 13,481,759 0% 420 Tax Incremental Financing (TIF) - Downtown 4,418,336 30,403 30,403 38,071 4,387,933 1% 422 TIF - West Washington 422,000 58 58 232 421,942 0% 425 Redevelopment Retail & Leighton Plaza 164,303 9,940 9,940 13,032 154,363 6% 426 TIF - Central Medical Service Area 1,615,000 371 371 1,979 1,614,629 0% 429 TIF - Northeast Development 827,000 349 349 1,138 826,651 0% 430 TIF - Southside Development #1 3,615,000 402 402 2,767 3,614,598 0% 431 TIF - Southside Development #2 0 0 0 0 0 0% 432 TIF - Southside Development #3 15,000 762 762 2,855 14,238 5% 435 TIF - Douglas Road 320,750 23 23 83 320,727 0% 436 TIF - Northeast Residential 2,510,000 244 244 1,796 2,509,756 0% Tax Increment Financing Total 27,392,001 45,405 45,405 136,405 27,346,596 0% Redevelopment 433 Redevelopment General 0 3 3 16 -3 0% 439 Certified Technology Park 1,453,000 472 472 1,446,493 1,452,528 0% 454 Airport Urban Enterprise Zone 1,500 48 48 192 1,452 3% 619 Blackthorn Operations 1,696,879 71,571 71,571 83,555 1,625,308 4% Redevelopment Total 3,151,379 72,094 72,094 1,530,256 3,079,285 2% City of South Bend Monthly Department Financial Report REVENUE SUMMARY January 31, 2014 Redevelopment Commission Controlled Funds Debt Service 314 Redevelopment Bond - Central Development 315 Redevelopment Bond - Airport Taxable 317 Coveleski Debt Service Reserve 319 Redevelopment Bond - Blackthorn Golf 328 Redevelopment Bond - Palais Royale Debt Service Total Redevelopment Commission Controlled Funds Total 0 0 0 0 0 0% 5,000 133 133 533 4,867 3% 3,000 65 65 257 2,935 2% 0 0 0 167 0 0% 6,000 223 223 890 5,777 4% 14,000 421 421 1,847 13,579 3% 30,557,380 117,920 117,920 1,668,508 30,439,460 0% Grand Total 287,194,697 15,140,901 15,140,900 17,428,319 272,053,797 5% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY January 31, 2014 Control Type Name Budget Actual Actual Actual Encumbrances Balance Budget d&partment City Funds General Fund 101 -0101 Mayor's Office 711,711 73,969 73,969 62,503 975 636,766 11% 101 -0104 311 Call Center 488,908 39,235 39,235 10,455 18,855 430,818 12% 101 -0201 City Clerk 394,608 33,254 33,254 25,214 23,382 337,972 14% 101 -0301 Common Council 472,598 33,804 33,804 27,381 0 438,794 7% 101 -0401 Administration & Finance 2,091,944 184,882 184,882 132,676 32,164 1,874,898 10% 101 -0404 Morris Performing Arts Center 1,063,527 87,838 87,838 79,568 61,000 914,689 14% 101 -0405 Palais Royale 523,710 43,724 43,724 31,386 53,856 426,130 19% 101 -0501 Legal Department 1,025,635 111,670 111,670 64,312 17,021 896,944 13% 101 -0602 Engineering 1,126,302 100,714 100,714 92,121 26,973 998,616 11% 101 -0607 Traffic & Lighting 2013 0 0 0 24,326 0 0 0% 101 -0801 Police Department 24,725,204 2,352,204 2,352,204 1,837,065 726,086 21,646,914 12% 101 -0802 Communications Center 2,236,486 205,840 205,840 149,658 570 2,030,076 9% 101 -0805 Police LOIT 2013 0 0 0 232,248 0 0 0% 101 -0901 Fire Department 21,007,496 2,004,687 2,004,687 1,463,151 432,930 18,569,879 12% 101 -0905 Fire LOIT 2013 0 213,687 213,687 166,938 0 - 213,687 0% 101 -1008 Human Rights 367,262 31,977 31,977 23,083 14,374 320,911 13% 101 -1201 Code 2013 5,225 740 740 108,213 4,350 135 97% 101 -1203 Code Hearing 2013 0 0 0 0 0 0 0% 101 -1204 Junk Vehicle 2013 0 0 0 4,142 0 0 0% 101 -1205 Unsafe Building 2013 0 0 0 2,765 0 0 0% 101 -1207 Animal Control 2013 2,254 0 0 41,716 2,254 0 100% General Fund Total 56,242,870 5,518,224 5,518,224 4,578,919 1,414,790 49,309,856 12% Special Revenue 102 Rainy Day 0 0 0 0 0 0 0% 201 Parks & Recreation 12,600,878 1,514,183 1,514,183 839,942 585,478 10,501,216 17% 202 Motor Vehicle Highway 9,708,648 868,158 868,158 483,878 746,391 8,094,099 17% 203 Recreation Nonreverting 1,479,064 42,584 42,584 45,993 109,437 1,327,043 10% 209 Studebaker - Oliver Reverting Grants 1,385,000 0 0 0 0 1,385,000 0% 210 Economic Development State Grants 117,886 0 0 11,492 0 117,886 0% 211 Community & Economic Development Admn. 2,404,884 236,843 236,843 166,430 21,648 2,146,393 11% 212 Community & Economic Development 6,910,783 100,807 100,807 494,170 2,998,974 3,811,002 45% 216 Police State Seizures 40,000 0 0 0 0 40,000 0% 217 Gift, Donation, Bequest 1,310 0 0 0 1,310 0 100% 218 Police Curfew Violations 1,000 0 0 0 0 1,000 0% 220 Law Enforcement Continuing Education 294,802 11,075 11,075 9,543 14,965 268,762 9% 227 Loss Recovery 5,615,805 5,154 5,154 0 1,618,653 3,991,998 29% 244 Emergency Phone System 215,000 27,387 27,387 0 0 187,613 13% 249 Public Safety LOIT 7,214,658 517,291 517,291 1,775,439 0 6,697,367 7% 251 Local Roads & Streets 1,124,520 19,206 19,206 17,647 89,596 1,015,718 10% 252 Excess Welfare Distribution 1,146 0 0 0 0 1,146 0% 258 Human Rights Federal Grant 224,001 19,647 19,647 10,686 21,842 182,512 19% 271 Eastrace Waterway 10,346 0 0 0 346 10,000 3% 273 Morris PAC / Palais Royale Marketing 8,100 3,628 3,628 2,049 0 4,472 45% 280 Police Block Grants 0 0 0 0 0 0 0% 281 Economic Develop. Commission - Revenue Bonds 0 0 0 0 0 0 0% 289 HAZMAT 10,000 0 0 0 0 10,000 0% 291 Indiana River Rescue 52,300 198 198 18,756 0 52,102 0% 292 Police Grants 90,000 0 0 0 0 90,000 0% 294 Regional Police Academy 23,750 136 136 1,298 0 23,614 1% 295 COPS MORE Grant 141,600 175 175 485 0 141,425 0% 299 Police Federal Drug Enforcement 151,499 0 0 6,433 1,499 150,000 1% 404 County Option Income Tax 9,976,202 1,612,310 1,612,310 1,604,033 389,827 7,974,065 20% 408 Economic Development Income Tax 10,014,984 2,229,819 2,229,819 1,474,544 979,353 6,805,811 32% 410 Urban Development Action Grant 0 0 0 0 0 0 0% 655 Project Releaf 430,114 14,433 14,433 3,735 0 415,681 3% 705 Police K -9 Unit 2,000 0 0 0 0 2,000 0% Special Revenue Total 70,250,280 7,223,035 7,223,035 6,966,552 7,579,320 55,447,925 21% City Debt Service 313 Football Hall of Fame Debt Service 1,268,116 634,500 634,500 633,500 0 633,616 50% City Debt Service Total 1,268,116 634,500 634,500 633,500 0 633,616 50% Capital Project 288 Emergency Medical Services Capital Improv. 4,572,215 449,203 449,204 38,560 1,487,566 2,635,445 42% 377 Professional Sports Development 865,746 382,873 382,873 487,548 0 482,873 44% 401 Coveleski Stadium Capital 3,540 0 0 0 0 3,540 0% 403 Zoo Endowment 0 0 0 0 0 0 0% 405 Park Nonreverting Capital 205,217 4,814 4,814 6,302 24,994 175,409 15% 406 Cumulative Capital Development 722,935 112,650 112,650 42 0 610,285 16% 407 Cumulative Capital Improvement 364,762 185,250 185,250 184,875 0 179,512 51% 412 Major Moves Construction 5,823,729 29,594 29,594 0 1,294,135 4,499,999 23% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY January 31, 2014 City Funds Capital Prc 416 Morris Performing Arts Center Capital 53,200 0 0 230 500 52,700 1 % 434 Community Revitalization Enhancement District 650,950 20,975 20,975 36,975 0 629,975 3% 450 Palais Royale Historic Preservation 10,000 0 0 0 0 10,000 0% 677 Football Hall of Fame Capital 188,567 6,273 6,273 2,223 8,908 173,386 8% Capital Project Total 13,460,861 1,191,633 1,191,634 756,754 2,816,103 9,453,124 30% Enterprise 600 Consolidated Building Fund 3,798,909 248,465 248,465 73,110 673,245 2,877,199 24% 601 Parking Garages 797,808 96,764 96,764 94,299 93,630 607,414 24% 610 Solid Waste Operations 5,439,463 672,124 672,124 640,573 874,764 3,892,575 28% 611 Solid Waste Capital 896,070 264,795 264,795 188,809 84,082 547,193 39% 620 Water Works Operations 14,842,004 1,198,585 1,198,585 1,079,479 329,456 13,313,963 10% 622 Water Works Capital 978,258 3,600 3,600 818 21,158 953,501 3% 623 Water Works Bond Capital 811,011 17,780 17,780 90,214 540,480 252,751 69% 624 Water Works Customer Deposit 6,000 186 186 0 0 5,814 3% 625 Water Works Sinking 2,057,224 196 196 600 0 2,057,028 0% 626 Water Works Bond Reserve 0 0 0 0 0 0 0% 629 Water Works Reserve Operations & Maintenance 8,500 261 261 0 0 8,239 3% 640 Sewer Repair Insurance 549,978 17,250 17,250 34,416 18,062 514,667 6% 641 Sewage Works Operations 35,556,194 4,598,158 4,598,158 2,474,146 1,970,300 28,987,736 18% 642 Sewage Works Capital 9,267,941 978,994 978,994 47,174 4,761,369 3,527,578 62% 643 Sewage Works Reserve Operations & Maint. 15,000 422 422 0 0 14,578 3% 645 Sewer Bond 2004/2006 0 0 0 0 0 0 0% 647 Sewer Bond 2007 1,138 0 0 0 1,138 0 100% 649 Sewage Sinking 9,802,031 500 500 0 0 9,801,531 0% 650 Clay Sewage 0 0 0 0 0 0 0% 651 Sewage Bond 2007B 0 0 0 0 0 0 0% 653 Sewage Debt Service Reserve 0 0 0 0 0 0 0% 658 Sewer Bond 2010 0 0 0 518 0 0 0% 659 Sewer Bond 2011 13,598,486 275,419 275,419 745,740 5,323,067 8,000,000 41% 661 Sewer Bond 2012 18,868,570 272,470 272,470 104,981 596,102 17,999,998 5% 663 Sewer Bond 2013 19,100,000 0 0 0 0 19,100,000 0% 664 2013A Cost of Issuance Fund 0 0 0 0 0 0 0% 665 2014 Sewer Bond 500,000 0 0 0 0 500,000 0% 670 Century Center 4,564,898 314,629 314,629 185,479 0 4,250,269 7% 671 Century Center Capital 0 0 0 0 0 0 0% Enterprise Total 141,459,483 8,960,597 8,960,597 5,760,356 15,286,853 117,212,032 17% Internal Service 222 Central Services 7,796,032 672,962 672,962 563,474 3,327,867 3,795,204 51% 226 Liability Insurance 2,897,200 103,406 103,406 257,968 82,000 2,711,794 6% 278 Take Home Vehicle Police 80,580 0 0 0 0 80,580 0% 711 Self- Funded Employee Benefits 14,483,463 526,930 526,930 1,141,446 19,000 13,937,533 4% 713 Unemployment Compensation 227,974 9,673 9,673 5,422 0 218,301 4% Internal Service Total 25,485,249 1,312,970 1,312,970 1,968,309 3,428,867 20,743,412 19% Trust & Agency 701 Firefighters Pension 5,874,445 457,164 457,164 464,307 0 5,417,281 8% 702 Police Pension 7,221,941 542,603 542,603 542,087 0 6,679,338 8% 730 City Cemetery 20,595 0 0 0 10,595 10,000 51% Trust & Agency Total 13,116,981 999,767 999,767 1,006,394 10,595 12,106,619 8% City Funds Total 1000000� 30,536,528 264,906,584 18 °/j Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIFRevenue - Airport 27,286,693 1,403,524 1,403,524 1,666,888 6,895,536 18,987,633 30% 420 Tax Incremental Financing (TIF) - Downtown 5,829,261 1,015,931 1,015,931 48,684 368,701 4,444,629 24% 422 TIF - West Washington 657,534 319 319 90,126 8,300 648,915 1% 425 Redevelopment Retail & Leighton Plaza 149,425 4,077 4,077 3,970 0 145,348 3% 426 TIF - Central Medical Service Area 4,103,504 169,224 169,224 233,051 231,780 3,702,500 10% 429 TIF - Northeast Development 2,356,117 617 617 8,320 5,500 2,350,000 0% 430 TIF - Southside Development #1 6,487,957 81,949 81,949 123,533 719,072 5,686,936 12% 431 TIF - Southside Development #2 0 0 0 0 0 0 0% 432 TIF - Southside Development #3 494,151 354,606 354,606 344,898 0 139,545 72% 435 TIF - Douglas Road 349,823 160 160 0 4,200 345,463 1% 436 TIF - Northeast Residential 3,323,228 1,464,500 1,464,500 1,371,000 0 1,858,728 44% Tax Increment Financing Total 51,037,693 4,494,907 4,494,907 3,890,470 8,233,089 38,309,697 25% Redevelopment 433 Redevelopment General 0 6,072 6,072 0 0 -6,072 0% 439 Certified Technology Park 3,600,000 0 0 0 0 3,600,000 0% 454 Airport Urban Enterprise Zone 0 0 0 0 0 0 0% 619 Blackthorn Operations 1,671,706 47,557 47,557 49,154 0 1,624,149 3% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY January 31, 2014 Redevelop Redevelopment Total Debt Service 314 Redevelopment Bond - Central Development 315 Redevelopment Bond - Airport Taxable 317 Coveleski Debt Service Reserve 319 Redevelopment Bond - Blackthorn Golf 328 Redevelopment Bond - Palais Royale Debt Service Total Redevelopment Commission Controlled Funds Total 5,271,706 53,629 53,629 49,154 0 0 0 0 5,000 133 133 0 0 0 0 0 0 0 0 0 6,000 223 223 0 11,000 356 356 0 56,320,399 4,548,892 4,548,892 3,939,624 0 5,218,077 1% 0 0 0% 0 4,867 3% 0 0 0% 0 0 0% 0 5,777 4% 0 10,644 3% 8,233,089 43,538,418 23% Grand Total 377,604,239 30,389,619 30,389,620 25,610,409 38,769,617 308,445,002 18% Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Month Janua Fund /Department Number 101 -0101 Date Updated 3/3/2014 Current Current 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 711,111 73,742 73,742 62,351 - 637,369 10% Local Income Taxes - - - - - - 0% Other Taxes - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - 227 227 151 - (227) 0% Other Income 600 - - - - 600 0% Transfers In - - - - - - 0% Total Revenue 711,711 73,969 73,969 62,503 - 637,742 10% Expenditures Personnel 632,608 60,686 60,686 39,837 - 571,922 10% Supplies 19,889 1,633 1,633 3,415 438 17,818 10% Services 57,015 11,100 11,100 18,866 537 45,378 20% Debt Service 2,199 550 550 385 - 1,649 25% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 711,711 73,969 73,969 62,503 975 636,766 11% Net - - - - (975) 975 Cash Balance - - Staffing Full Time 7.00 7.00 7.00 Part -Time /Seasonal /Temporary - 1.00 1.00 Total 7.00 8.00 8.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Debt Service is paid quarterly; the first payment was made in January 2014. Explain Significant Spending on Capital Projects Below: There are no capital projects budgeted for 2014. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center Month Janua Fund /Department Number 101 -0104 Date Updated 3/3/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 8,831 12,726 12,726 10,455 - (3,895) 144% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 480,077 26,509 26,509 - - 453,568 6% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 488,908 39,235 39,235 10,455 - 449,673 8% Expenditures Personnel 422,705 37,433 37,433 9,914 - 385,272 9% Supplies 24,771 653 653 540 11,111 13,007 47% Services 41,432 1,149 1,149 - 7,743 32,540 21% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 488,908 39,235 39,235 10,455 18,855 430,818 12% Net - - - - (18,855) 18,855 Cash Balance - - Staffing Full Time 6.50 6.50 6.50 Part -Time /Seasonal /Temporary 1.00 - - Total 7.50 6.50 6.50 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Department wasn't in full operation yet in January 2013. Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted in 2014. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Month Janua Fund /Department Number 101 -0201 Date Updated 3/3/2014 Current Current 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 394,608 33,254 33,254 25,214 - 361,354 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 394,608 33,254 33,254 25,214 - 361,354 8% Expenditures Personnel 312,763 31,331 31,331 20,805 - 281,432 10% Supplies 8,062 473 473 160 2,930 4,659 42% Services 60,383 1,450 1,450 4,249 20,453 38,481 36% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 394,608 33,254 33,254 25,214 23,382 337,972 14% Net - - - - (23,382) 23,382 Cash Balance - - Staffing Full Time 5.00 4.00 4.00 Part -Time /Seasonal /Temporary - - - Total 5.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Personnel costs appear higher than 2013 because there were 3 bi- weekly payroll checks issued in January. This phenomenon usually occurs twice per year; the seond month will be August. Prior to the end of January, the Chief Deputy City Clerk resigned. The position was filled by the Ordinance Officer whose position is currently vacant. Explain Significant Spending on Capital Projects Below: No significant changes at this time. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Common Council Month Janua Fund /Department Number 101 -0301 Date Updated 3/3/2014 Current Current 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 464,298 33,763 33,763 26,685 - 430,535 7% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 8,300 41 41 696 - 8,259 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 472,598 33,804 33,804 27,381 - 438,794 7% Expenditures Personnel 297,929 21,485 21,485 13,865 - 276,444 7% Supplies 7,285 24 24 401 - 7,261 0% Services 149,884 12,294 12,294 6,826 - 137,590 8% Debt Service - - - - - - 0% Capital 17,500 - - 6,289 - 17,500 0% Transfers Out - - - - - - 0% Total Expenditures 472,598 33,804 33,804 27,381 - 438,794 7% 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 ChangesNariances Below: There are nine (9) Council Members. One member has declined to receive a salary. There were 3 payroll checks issued in January compared to the usual 2 issued in January 2013. This phenomenon occurs twice in 2014; the next time will be in August. Explain Significant Spending on Capital Projects Below: The $17,500 in the Capital budget was placed there in error. A budget transfer will be initiaited to correct the items. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Month January Fund /Department Number 101 -0401 Date Updated 3/3/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,011,894 184,882 184,882 132,647 - 1,827,012 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 80,050 - - 29 - 80,050 0% Transfers In - - - - - - 0% Total Revenue 2,091,944 184,882 184,882 132,676 - 1,907,062 9% Expenditures Personnel 1,898,692 173,862 173,862 108,437 - 1,724,830 9% Supplies 31,999 1,736 1,736 2,606 9,893 20,370 36% Services 157,753 8,641 8,641 21,633 22,271 126,841 20% Debt Service 3,500 643 643 - - 2,857 18% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,091,944 184,882 184,882 132,676 32,164 1,874,898 10% Net - - - - (32,164) 32,164 Cash Balance - - Staffing Full Time 21.00 20.00 20.00 Part -Time /Seasonal /Temporary 2.00 1.00 1.00 Total 23.00 21.00 21.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Added 3.2 positions in 2013. Additionally, January was a 3- paycheck month. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Month January Fund /Department Number 101 -0404 Date Updated 2/18/2014 Current Current 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 181,527 31,686 31,686 62,637 - 149,841 17% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 876,000 54,711 54,711 16,129 - 821,289 6% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 1,441 1,441 802 - 4,559 24% Transfers In - - - - - - 0% Total Revenue 1,063,527 87,838 87,838 79,568 - 975,689 8% Expenditures Personnel 711,096 70,644 70,644 49,576 4,477 635,975 11% Supplies 32,657 1,587 1,587 1,302 11,656 19,414 41% Services 319,774 15,607 15,607 28,690 44,866 259,301 19% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,063,527 87,838 87,838 79,568 61,000 914,689 14% Net - - - - (61,000) 61,000 Cash Balance - - Staffing Full Time 12.00 12.00 12.00 Part -Time /Seasonal /Temporary 4.00 4.00 4.00 Total 16.00 16.00 16.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Fund 416 is used to support renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons at the Morris Performing Arts Center. Not all of the expenses are Capital expenses. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Month Janua Fund /Department Number 101 -0405 Date Updated 2/18/2014 Current Current 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 213,729 14,623 14,623 6,797 - 145,249 7% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 291,981 27,385 27,385 23,071 - 264,596 9% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 18,000 1,715 1,715 1,518 - 16,285 10% Transfers In - - - - - - 0% Total Revenue 523,710 43,724 43,724 31,386 - 426,130 8% Expenditures Personnel 251,265 24,196 24,196 13,680 1,683 225,386 10% Supplies 31,629 472 472 502 4,910 26,247 17% Services 225,816 19,056 19,056 17,204 47,263 159,497 29% Debt Service - - - - - - 0% Capital 15,000 - - - - 15,000 0% Transfers Out - - - - - - 0% Total Expenditures 523,710 43,724 43,724 31,386 53,856 426,130 19% Net - - - - (53,856) - Cash Balance - - Staffing Full Time 2.00 2.00 2.00 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Month Janua Fund /Department Number 101 -0501 Date Updated 3/4/2014 Current Current 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,285 111,656 111,656 63,752 - 841,629 12% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 - - 377 - 2,000 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 70,350 15 15 183 - 70,335 0% Transfers In - - - - - - 0% Total Revenue 1,025,635 111,670 111,670 64,312 - 913,965 11% Expenditures Personnel 977,419 110,680 110,680 55,019 - 866,739 11% Supplies 5,083 115 115 182 2,250 2,718 47% Services 43,133 876 876 3,094 13,500 28,757 33% Debt Service - - - 1,271 (1,271) 0% Capital - - - 6,016 - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,025,635 111,670 111,670 64,312 17,021 896,944 13% Net - - - - (17,021) 17,021 Cash Balance - - Staffing Full Time 9.60 10.00 10.00 Part -Time /Seasonal /Temporary - 4.00 4.00 Total 9.60 14.00 14.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Legal Department is currently fully staffed with 14 employees in contrast to January 2013 when there were only 10. Additionally, January had 3 payrolls paid out as well as excess vacation paid to a departing employee. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Engineering Month Janua Fund /Department Number 101 -0602 Date Updated 3/3/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 1,120,202 100,599 100,599 92,121 - 1,019,603 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 6,100 115 115 - - 5,985 2% Transfers In - - - - - - 0% Total Revenue 1,126,302 100,714 100,714 92,121 - 1,025,588 9% Expenditures Personnel 610,675 67,342 67,342 45,093 2,740 540,593 11% Supplies 18,929 1,748 1,748 2,602 1,560 15,621 17% Services 488,306 29,070 29,070 44,425 18,755 440,481 10% Debt Service 8,392 2,554 2,554 - 3,917 1,921 77% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,126,302 100,714 100,714 92,121 26,973 998,616 11% Net - - - - (26,973) 26,973 Cash Balance - - Staffing Full Time 6.90 9.40 9.40 Part -Time /Seasonal /Temporary 1.81 1.80 1.80 Total 8.71 11.20 11.20 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Salaries appear high for two reasons: a) January was a "3- paycheck month" compared to the normal 2, and b) some personnel who are supposed to have their costs allocated via payroll aren't set properly. Corrections will be made in March. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Department Month Janua Fund /Department Number 101 -0801 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 24,387,504 2,314,151 2,314,151 1,807,541 - 22,073,353 9% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 329,200 38,053 38,053 29,524 - 291,147 12% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 8,500 - - - - 8,500 0% Transfers In - - - - - - 0% Total Revenue 24,725,204 2,352,204 2,352,204 1,837,065 - 22,373,000 10% Expenditures Personnel 20,920,704 2,059,589 2,059,589 1,551,737 - 18,861,115 10% Supplies 754,999 134,083 134,083 36,126 289,703 331,213 56% Services 2,969,191 157,940 157,940 249,202 371,225 2,440,026 18% Debt Service 15,152 592 592 - - 14,560 4% Capital 65,158 - - - 65,158 - 100% Transfers Out - - - - - - 0% Total Expenditures 24,725,204 2,352,204 2,352,204 1,837,065 726,086 21,646,914 12% Net - - - - (726,086) 726,086 Cash Balance - - Staffing Full Time 253.00 245.00 245.00 Part -Time /Seasonal /Temporary 57.00 30.00 30.00 Total 310.00 275.00 275.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund includes the expenditures for 213 of the 260 budgeted Police officers and 97 civilian staff. Fund 249 contains the funding for 47 of the 260 Police officers that are funded by the LOIT. The 2014 Personnel Expenditure exceeds the prior year amount due to the timing of payroll paid. There were three payrolls paid by January 31, 2014 compared to two payrolls paid by January 31, 2013. In addition, 2014 includes a 2.5% increase for most officer salaries and 2% for civilians. The Personnel budget is spread evenly across the twelve months, January's three payments represent 11.5 % of the twenty -six budgeted payments for 2014. Personnel costs are not expected to exceed the 2014 annual budget. The Supplies, 58% of budget used, is the result of a number of 2013 purchases encumbered in the 2014 budget as the Supplies were not received /paid for in 2013. Supplies expenditures for the full year 2014 are expected to be within budget. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Month Janua Fund /Department Number 101 -0802 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,236,486 205,840 205,840 149,658 - 2,030,646 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 - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,236,486 205,840 205,840 149,658 - 2,030,646 9% Expenditures Personnel 2,210,667 205,193 205,193 147,881 - 2,005,474 9% Supplies 4,029 - - - - 4,029 0% Services 21,790 647 647 1,777 570 20,573 6% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,236,486 205,840 205,840 149,658 570 2,030,076 9% Net - - - - (570) 570 Cash Balance - - Staffing Full Time 35.00 33.00 33.00 Part -Time /Seasonal /Temporary - - - Total 35.00 33.00 33.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund captures the cost of 35 of the 38 civilians and equipment to maintain the 911 communication center. The cost of three supervisors has been transferred to Fund 244 as their cost is recovered through the Emergency Telephone System funding. 2014 Personnel costs exceed 2013 as there were three payrolls paid in January 2014, compared to only two in January 2013. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Month Janua Fund /Department Number 101 -0901 Date Updated 2/20/2014 Current Current 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 19,391,496 1,963,624 1,963,624 1,404,973 17,427,872 10% Local Income Taxes - - - - - 0% Other Taxes - - - - - 0% Grants /Intergovernmental 155,000 - - 155,000 0% Charges for Services 455,000 40,938 40,938 58,178 - 414,062 9% Interest Earnings - - - - - 0% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 6,000 125 125 - - 5,875 2% Transfers In 1,000,000 - - - - 1,000,000 0% Total Revenue 21,007,496 2,004,687 2,004,687 1,463,151 - 19,002,809 10% Expenditures Personnel 18,806,414 1,872,469 1,872,469 1,355,593 127,731 16,806,214 11% Supplies 602,477 27,374 27,374 21,671 155,945 419,158 30% Services 1,598,605 104,844 104,844 85,887 149,254 1,344,507 16% Debt Service - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 21,007,496 2,004,687 2,004,687 1,463,151 432,930 18,569,879 12% Net - - - - (432,930) 432,930 Cash Balance - - Staffing Full Time 257.00 253.00 253.00 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 258.00 254.00 254.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The South Bend Fire Department is budgeted to have 251 sworn firefighters and 6 civilians. We hold a lengthy recruitment process every 2 years and hire individuals in groups of 6 -10 as needed while that list is in effect. We also employ civilian administrative staff that handle payroll, purchasing and billing for our ambulance service. Explain Significant Spending on Capital Projects Below: The Fire Department uses EMS Capital Fund 288 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through that fund. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvents to buildings in the General Fund. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Month Janua Fund /Department Number 101 -1008 Date Updated 2/20/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 367,262 31,977 31,977 23,083 - 335,285 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 - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 367,262 31,977 31,977 23,083 - 335,285 9% Expenditures Personnel 272,252 27,684 27,684 18,615 - 244,568 10% Supplies 2,394 59 59 213 400 1,935 19% Services 78,426 4,234 4,234 4,256 13,974 60,218 23% Debt Service - - - - - - 0% Capital 14,190 - - - - 14,190 0% Transfers Out - - - - - - 0% Total Expenditures 367,262 31,977 31,977 23,083 14,374 320,911 13% Net - - - - (14,374) 14,374 Cash Balance - - Staffing Full Time 4.00 4.00 4.00 Part -Time /Seasonal /Temporary - - - Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Expenditures in personnel are higher in January this year due to three pay periods. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Rainy Day Month Janua Fund /Department Number 102 Date Updated 2/20/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 52,000 1,105 1,105 4,405 - 50,895 2% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 52,000 1,105 1,105 4,405 - 50,895 2% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 52,000 1,105 1,105 4,405 - 50,895 Cash Balance 8,618,810 8,592,585 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 restulting in South Bend's good AA bond rating with Standard & Poor's. Explain Significant Spending on Capital Projects Below: N/A Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation Month Janua Fund /Department Number 201 1 Date Updated 2/19/2014 Current Current 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,430,898 - - - - 7,430,898 0% Local Income Taxes - - - 0% Other Taxes 596,878 - - - - 596,878 0% Grants /Intergovernmental 729,437 60,782 60,782 58,001 - 668,655 8% Charges for Services 2,208,344 31,000 31,000 98,175 - 2,177,344 1% Interest Earnings 13,000 431 431 2,506 - 12,569 3% Bond Proceeds - - - 0% Donations - - - 0% Other Income 1,850 222 222 179 - 1,628 12% Transfers In - - - 0% Total Revenue 10,980,407 92,435 92,435 158,861 - 10,887,972 1% Expenditures Personnel 8,091,942 810,199 810,199 524,594 5,479 7,276,264 10% Supplies 1,597,319 58,609 58,609 86,740 448,008 1,090,703 32% Services 2,300,772 645,376 645,376 165,338 131,992 1,523,405 34% Debt Service 313,345 - - - - 313,345 0% Capital 107,000 - - 63,270 - 107,000 0% Transfers Out 190,500 - - - - 190,500 0% Total Expenditures 12,600,878 1,514,183 1,514,183 839,942 585,478 10,501,216 17% Net (1,620,471) (1,421,748) (1,421,748) (681,081) (585,478) 386,756 Cash Balance 2,833,108 4,199,221 Staffing Full Time 93.00 93.00 93.00 Part -Time /Seasonal /Temporary 73.00 23.40 23.40 Total 166.00 116.40 116.40 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund 201 accounts for the annual operation of the Parks and Recreation Department. There are six divisions within the department: Administration, Maintenance, Golf, Recreation, Greenhouse, and Graffiti Removal. For 2014, the Potawatomi Zoo will be operated by the Potawatomi Zoological Society.The Zoo revenues have been removed from the budget; however, because of the timing of the change, the original expenses are still included in the above budget in order to cover obligations resulting from the memorandum of understanding between the City and PZS. January had three payroll dates, which resulted in the higher personnel costs. Expenses realated to the Zoo transition also contributed to the higher than normal expenses in personnel and services categories and lower cash balance. Explain Significant Spending on Capital Projects Below: Because of decreasing property tax revenues, the only capital expense for 2014 consists of the purchase of three pickup trucks and two commercial riding mowers. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month Janua Fund /Department Number 202 Date Updated 2/20/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,633,418 250,514 250,514 487,155 5,382,904 4% Grants /Intergovernmental - - 0% Charges for Services 244,000 33,056 33,056 - 210,944 14% Interest Earnings 7,000 517 517 1,165 6,483 7% Bond Proceeds - - 0% Donations - - 0% Other Income 5,300 1,436 1,436 639 3,864 27% Transfers In 3,216,582 3,216,582 0% Total Revenue 9,106,300 285,523 285,523 488,959 - 8,820,777 3% Expenditures Personnel 3,995,824 483,035 483,035 266,667 3,512,789 12% Supplies 3,400,615 147,072 147,072 102,617 585,928 2,667,615 22% Services 1,557,564 202,414 202,414 97,385 26,433 1,328,717 15% Debt Service 408,395 35,637 35,637 11,619 372,758 9% Capital 346,250 5,590 134,030 212,220 39% Transfers Out - - 0% Total Expenditures 9,708,648 868,158 868,158 483,878 746,391 8,094,099 17% Net (602,348) (582,636) (582,636) 5,081 (746,391) 726,679 Cash Balance 3,097,223 2,277,135 Staffing Full Time 52.91 51.91 Part -Time /Seasonal /Temporary 4.98 3.68 Total 57.89 55.59 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Information included for Streets, Traffic & Lighting, and Curb & Sidewalk: Increase in personnel costs - in 2013 the Traffic & Lighting budget was moved from the General Fund (101 -0607) to MVH; additional salary and benefit allocations from Engineering Department. Significant overtime, snow control supplies, vehicle fuel and maintenance expense during January due to extreme weather. In addition, January was a 3- paycheck month. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Recreation Nonreverting Month Janua Fund /Department Number 203 Date Updated 2/14/2014 Current Current 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,400,592 53,950 53,950 59,541 - 1,346,642 4% Interest Earnings 4,000 99 99 344 - 3,901 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 45,000 22,009 22,009 40,469 - 22,991 49% Transfers In - - - - - - 0% Total Revenue 1,449,592 76,057 76,057 100,355 - 1,373,535 5% Expenditures Personnel 613,627 31,603 31,603 20,308 - 582,024 5% Supplies 274,095 2,113 2,113 17,249 95,303 176,679 36% Services 492,342 8,869 8,869 8,436 14,134 469,339 5% Debt Service - - - - - - 0% Capital 99,000 - - - - 99,000 0% Transfers Out - - - - - - 0% Total Expenditures 1,479,064 42,584 42,584 45,993 109,437 1,327,043 10% Net (29,472) 33,473 33,473 54,362 (109,437) 46,492 Cash Balance 811,722 725,493 Staffing Full Time 1.00 1.00 1.00 Part -Time /Seasonal /Temporary 25.70 7.06 7.06 Total 26.70 8.06 8.06 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund accounts for programs and events that are self funded through user fees. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Studebaker - Oliver Reverting Grants Month January Fund /Department Number 209 Date Updated 2/17/2014 Current Current 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 139 139 554 - 4,861 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 300,000 - - - - 300,000 0% Transfers In - - - - - - 0% Total Revenue 305,000 139 139 554 - 304,861 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 1,385,000 - - - - 1,385,000 0% Transfers Out - - - - - - 0% Total Expenditures 1,385,000 - - - - 1,385,000 0% Net (1,080,000) 139 139 554 Cash Balance 1,083,526 1,080,229 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: There is $300,000 budgeted in Revenue as an expected insurance payment into this fund. Explain Significant Spending on Capital Projects Below: Funds to be used for environmental clean up as needed. If not used this year, funds will be appropriated for use next year. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Month January Fund /Department Number 210 Date Updated 2/17/2014 Current Current 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 18,813 85 85 471 - 18,728 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 58,203 - - - - 58,203 0% Transfers In - - - - - - 0% Total Revenue 77,016 85 85 471 - 76,931 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 117,886 - - 11,492 - 117,886 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 117,886 - - 11,492 - 117,886 0% Net (40,870) 85 85 (11,021) - (40,955) Cash Balance 349,035 907,434 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: No significant issues. The IRF Loan was paid off early in 2013. Original maturity date was 07/30/2022. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development Admn. Month Janua Fund /Department Number 211 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 386,787 - - - - 386,787 0% Charges for Services - - - - - - 0% Interest Earnings 2,200 124 124 300 - 2,076 6% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 200,300 13,484 13,484 14,539 - 186,816 7% Transfers In 1,688,959 422,240 422,240 429,380 - 1,266,719 25% Total Revenue 2,278,246 435,848 435,848 444,219 - 1,842,398 19% Expenditures Personnel 2,069,556 210,971 210,971 131,839 - 1,858,585 10% Supplies 32,475 3,437 3,437 1,324 5,046 23,992 26% Services 302,853 22,435 22,435 29,597 16,602 263,816 13% Debt Service - - - - - - 0% Capital - - - 3,670 - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,404,884 236,843 236,843 166,430 21,648 2,146,393 11% Net (126,638) 199,005 199,005 277,789 (21,648) (303,995) Cash Balance 1,106,613 861,801 Staffing Full Time 26.60 25.60 25.60 Part -Time /Seasonal /Temporary - - - Total 26.60 25.60 25.60 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Capital expenditures for 2013 relate to purchase of whiteboard for conference room and electrical work associated with move to 14th floor. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development Month Janua Fund /Department Number 212 Date Updated 2/17/2014 Current Current 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,525,000 119,425 119,425 486,932 - 3,405,575 3% Charges for Services - - - - - - 0% Interest Earnings 2,000 401 401 165 - 1,599 20% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 284,000 5,247 5,247 6,158 - 278,753 2% Transfers In - - - - - - 0% Total Revenue 3,811,000 125,073 125,073 493,255 - 3,685,927 3% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 6,910,783 100,807 100,807 494,170 2,998,974 3,811,002 45% Transfers Out - - - - - - 0% Total Expenditures 6,910,783 100,807 100,807 494,170 2,998,974 3,811,002 45% Net (3,099,783) 24,266 24,266 (915) (2,998,974) (125,075) Cash Balance 615,552 513,530 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund covers multiple federal grants. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on -going and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Month Janua Fund /Department Number 216 Date Updated 2/17/2014 Current Current 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 20 20 74 - 280 7% Bond Proceeds - - 0% Donations - - 0% Other Income 600 - 600 0% Transfers In - - 0% Total Revenue 35,900 20 20 74 - 35,880 0% Expenditures Personnel - - - - - - 0% Supplies - 0% Services 20,000 - - 20,000 0% Debt Service - 0% Capital 20,000 - - 20,000 0% Transfers Out - 0% Total Expenditures 40,000 - - - - 40,000 0% Net (4,100) 20 20 74 - (4,120) Cash Balance 158,687 144,999 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 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month Janua Fund /Department Number 217 Date Updated 2/20/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 290 10 10 32 - 280 3% Bond Proceeds - - - - - - 0% Donations 7,000 - - 795 - 7,000 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 7,290 10 10 827 - 7,280 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,310 - - - 1,310 (0) 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,310 - - - 1,310 (0) 100% Net 5,980 10 10 827 (1,310) 7,281 Cash Balance 74,744 64,060 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Gift, Donation, and Bequest fund may be used by all City departments but the majority of the donations are for Animal Care and Control and Community Investment (i.e. bicycle signs). Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Month Janua Fund /Department Number 218 Date Updated 2/17/2014 Current Current 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 13 38 - 987 1% Interest Earnings 25 1 1 6 - 24 4% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,025 14 14 44 - 1,011 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 14 14 44 - 11 Cash Balance 11,562 10,928 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was established to collect curfew and prostitution fines. Expenditures are used for Police enforcement and training. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education Month Janua Fund /Department Number 220 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - 0% Charges for Services 180,000 19,017 19,017 24,637 - 160,983 11% Interest Earnings 3,000 124 124 558 - 2,876 4% Bond Proceeds - - 0% Donations 2,000 - 2,000 0% Other Income 26,000 11,107 11,107 13 - 14,893 43% Transfers In - - - - - - 0% Total Revenue 211,000 30,248 30,248 25,208 - 180,752 14% Expenditures Personnel - - - - - - 0% Supplies 40,855 10,855 10,855 900 29,100 29% Services 190,000 220 220 9,543 118 189,662 0% Debt Service - - 0% Capital 63,947 13,947 50,000 22% Transfers Out - 0% Total Expenditures 294,802 11,075 11,075 9,543 14,965 268,762 9% Net (83,802) 19,173 19,173 15,665 (14,965) (88,010) Cash Balance 1,000,398 1,102,872 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established for the continuing education and supplies for police and is funded by fees from accident reports, gun permits, false alarm and loud noise fines. Other income includes the receipt of funds from the US Marshal Service for rent of SBPD facility. The January purchase was the license renewal for forensic software. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Month Janua Fund /Department Number 227 Date Updated 3/3/2014 Current Current 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 17,000 1,018 1,018 2,227 - 15,982 6% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 17,000 1,018 1,018 2,227 - 15,982 6% Expenditures Personnel - - - - - - 0% Supplies 200,000 - - - - 200,000 0% Services 3,315,805 5,154 5,154 - 1,468,653 1,841,998 44% Debt Service - - - - - - 0% Capital 2,100,000 - - - 150,000 1,950,000 7% Transfers Out - - - - - - 0% Total Expenditures 5,615,805 5,154 5,154 - 1,618,653 3,991,998 29% Net (5,598,805) (4,135) (4,135) 2,227 (1,618,653) (3,976,016) Cash Balance 7,931,897 4,343,788 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: In February the PO to Rose Cor for hauling of material from Organic Resources was rescinded due to non - performance on the contract. The value was $581,000 and appears as part of the $811,538 encumbrance for the Supplies line. Explain Significant Spending on Capital Projects Below: The $150,000 encumbrance is for the installation of a pump for West Calvert Street at the ethanol plant. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month January Fund /Department Number 244 Date Updated 2/20/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 215,000 215,000 215,000 - - - 100% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 215,000 215,000 215,000 - - - 100% Expenditures Personnel 215,000 27,387 27,387 - - 187,613 13% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 215,000 27,387 27,387 - - 187,613 13% Net - 187,613 187,613 - - (187,613) Cash Balance 187,613 - Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up per requirement by the State Board Of Accounts (SBOA) to cover the cost of 911 Police Communication personnel costs covered by a State Grant. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Public Safety WIT Month Janua Fund /Department Number 249 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 6,380,029 531,669 531,669 491,032 - 5,848,360 8% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 11,000 226 226 1,533 - 10,774 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,391,029 531,895 531,895 492,566 - 5,859,134 8% Expenditures Personnel 7,214,658 517,291 517,291 - - 6,697,367 7% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 1,775,439 - - 0% Total Expenditures 7,214,658 517,291 517,291 1,775,439 - 6,697,367 7% Net (823,629) 14,604 14,604 (1,282,874) - (838,233) Cash Balance 2,046,798 1,707,067 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Prior to 2014, monies in Fund 249 were transferred quarterly to the General Fund to fund police and fire personnel. A quarterly reconciliaton was prepared and any unspent money was transferred back to Fund 249. For 2014, the City has been advised by the DLGF and SBOA that it should budget personnel costs directly from Fund 249. In 2014 the Fund includes the salary and benefit costs for 47 police officers and 38 firefighters. The Police personnel costs for January are 10% of budget as three payrolls were paid in January representing 3 of the 26 payrolls budgeted for 2014 or 11.5% of the annual budget. However, the Fire personnel costs seem to be understated. Any problem will be resolved in March. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month Janua Fund /Department Number 251 Date Updated 3/3/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,080,000 86,900 86,900 82,968 - 993,100 8% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 8,000 248 248 879 - 7,752 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,088,000 87,148 87,148 83,847 - 1,000,852 8% Expenditures Personnel - - - - - - 0% Supplies 352,663 - - - 2,663 350,001 1% Services 7,500 - - 7,500 - 7,500 0% Debt Service - - - - - - 0% Capital 764,357 19,206 19,206 10,147 86,933 658,218 14% Transfers Out - - - - - - 0% Total Expenditures 1,124,520 19,206 19,206 17,647 89,596 1,015,718 10% Net (36,520) 67,942 67,942 66,201 (89,596) (14,866) Cash Balance 2,009,316 1,780,499 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Supplies are always street paving materials to be used throughout the year. Explain Significant Spending on Capital Projects Below: 2014 Budget: Boland Multi -Use Path: $250,000 New traffic devices: $167,000 Other projects: $325,000 Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Month Janua Fund /Department Number 252 Date Updated 2/20/2014 Current Current 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 1 - (0) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 0 0 1 - (0) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,146 - - - - 1,146 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,146 - - - - 1,146 0% Net (1,146) 0 0 1 - (1,146) Cash Balance 1,150 1,146 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: In 2009, the City received a one -time $2.9 million distribution for this fund. In 2012, the City spent approximately $2.1 million for portable radios for the both the Police and Fire departments. Money in this fund may only be used for public safety purposes. The final fund balance will be spent during 2014. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant Month Janua Fund /Department Number 258 Date Updated 2/20/2014 Current Current 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 - - - - 187,000 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 61 61 249 - 1,939 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 21,700 27 27 15 - 21,673 0% Transfers In - - - - - - 0% Total Revenue 210,700 89 89 264 - 210,611 0% Expenditures Personnel 112,901 12,053 12,053 7,995 - 100,848 11% Supplies 4,550 - - 118 1,800 2,750 40% Services 105,050 7,594 7,594 2,573 20,042 77,414 26% Debt Service - - - - - - 0% Capital 1,500 - - - - 1,500 0% Transfers Out - - - - - - 0% Total Expenditures 224,001 19,647 19,647 10,686 21,842 182,512 19% Net (13,301) (19,559) (19,559) (10,422) (21,842) 28,099 Cash Balance 447,216 475,743 Staffing Full Time 2.00 2.00 2.00 Part -Time /Seasonal /Temporary - - - Total 2.00 2.00 2.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Human Rights Federal Grant Fund contains separate departments for EEOC and HUD grants. Personnel costs are higher this year in January due to three pay periods. Explain Significant Spending on Capital Projects Below: A drop down projector and large screen TV has been budgeted in capital for the conference room in the new Human Rights building. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Month Janua Fund /Department Number 271 Date Updated 2/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 100 2 2 7 - 98 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 100 2 2 7 - 98 2% Expenditures Personnel - - - - - - 0% Supplies 10,346 - - - 346 10,000 3% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,346 - - - 346 10,000 3% Net (10,246) 2 2 7 (346) (9,902) Cash Balance 14,374 14,330 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In past years there have been no races. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month January Fund /Department Number 273 Date Updated 2/18/2014 Current Current 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,000 350 350 8 - 7,650 4% Interest Earnings 100 4 4 15 - 96 4% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 8,100 354 354 23 - 7,746 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 8,100 3,628 3,628 2,049 - 4,472 45% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 8,100 3,628 3,628 2,049 - 4,472 45% Net - (3,274) (3,274) (2,026) - 3,274 Cash Balance 24,711 26,737 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Morris Performance 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 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Month Janua Fund /Department Number 280 Date Updated 2/17/2014 Current Current 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 - - 0% Bond Proceeds - - 0% Donations - - 0% Other Income - - 0% Transfers In - - - - - - 0% Total Revenue - - - 2 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - 0% Services - - 0% Debt Service - - 0% Capital - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - 2 - - Cash Balance 3,817 3,804 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Month Janua Fund /Department Number 281 Date Updated 2/17/2014 Current Current 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 14 - (3) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 3 3 14 - (3) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 3 3 14 - (3) Cash Balance 27,131 27,049 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund to be used only for the expenses of EDC revenue bonds. These bonds have been paid off. Fund to be closed during 2014. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Month Janua Fund /Department Number 289 Date Updated 1/30/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 10,000 - - - - 10,000 0% Interest Earnings - 2 2 1 - (2) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 2 2 1 - 9,998 0% Expenditures Personnel - - - - - - 0% Supplies 10,000 - - - 10,000 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,000 - - - - 10,000 0% Net - 2 2 1 - (2) Cash Balance 16,209 2,684 Staffing Full Time - - Part-Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Charges for Service for HAZ -MAT responses. By ordinance the South Bend Fire Department charges business 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. 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 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue Month Janua Fund /Department Number 291 Date Updated 2/20/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 45,000 2,400 2,400 2,500 - 42,600 5% Interest Earnings 200 12 12 61 - 188 6% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,200 2,412 2,412 2,561 - 42,788 5% Expenditures Personnel 2,500 - - - 2,500 0% Supplies 8,800 142 142 18,756 - 8,658 2% Services 41,000 56 56 - 40,944 0% Debt Service - - - - - - 0% Capital - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 52,300 198 198 18,756 - 52,102 0% Net (7,100) 2,214 2,214 (16,195) - (9,314) Cash Balance 97,931 103,228 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 maintenance and repair of rescue equipment. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Month Janua Fund /Department Number 292 Date Updated 2/17/2014 Current Current 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 66,717 66,717 - - (66,717) 0% Charges for Services - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 66,717 66,717 - - (66,717) 0% Expenditures Personnel - - - - - - 0% Supplies - - 0% Services - - 0% Debt Service - - 0% Capital 90,000 - 90,000 0% Transfers Out - - - - - - 0% Total Expenditures 90,000 - - - - 90,000 0% Net (90,000) 66,717 66,717 - - (156,717) Cash Balance 271,225 98,125 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Of the $66,717 of grant money received in 2014, $52,963 is from a Federal grant to improve security at South Bend Schools. The South Bend Police Department is the Administrator of the grant. This funding will be disbursed to the South Bend School Corporation which spent the funds in accordance with the terms of the grant. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Month January Fund /Department Number 294 Date Updated 2/17/2014 Current Current 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 13,150 13,150 10,100 - 6,850 66% Interest Earnings 2,000 9 9 38 - 1,991 0% Bond Proceeds - - 0% Donations - - 0% Other Income - - 0% Transfers In - - - - - - 0% Total Revenue 22,000 13,159 13,159 10,138 - 8,841 60% Expenditures Personnel - - - - - - 0% Supplies 1,750 - 1,750 0% Services 22,000 136 136 1,298 - 21,864 1% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 136 136 1,298 - 23,614 1% Net (1,750) 13,023 13,023 8,840 - (14,773) Cash Balance 81,107 82,655 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to fund the cost of course material and instructors at the South Bend Police Academy. The enforcement courses are offered to other police departments who pay a fee to attend the training. Revenue received is 66% of the estimated annual budget as many of the police departments outside of South Bend have paid their annual cost to participate in the instruction. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Month Janua Fund /Department Number 295 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - 0% Charges for Services - - - 0% Interest Earnings 350 13 13 55 - 337 4% Bond Proceeds - - - 0% Donations 3,250 - 3,250 0% Other Income 38,000 850 850 1,030 - 37,150 2% Transfers In - - - - - - 0% Total Revenue 41,600 863 863 1,085 - 40,737 2% Expenditures Personnel - - - - - - 0% Supplies 15,000 - 15,000 0% Services 16,000 175 175 485 - 15,825 1% Debt Service - - 0% Capital 110,600 - 110,600 0% Transfers Out - - 0% Total Expenditures 141,600 175 175 485 - 141,425 0% Net (100,000) 688 688 600 - (100,688) Cash Balance 114,031 107,889 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds received from the grants along with impound towing fees. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Month January Fund /Department Number 299 Date Updated 2/17/2014 Current Current 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 2,216 - 75,000 0% Charges for Services - - 0% Interest Earnings 1,000 91 91 104 - 909 9% Bond Proceeds - - 0% Donations - - 0% Other Income 1,000 - 1,000 0% Transfers In - - - - - - 0% Total Revenue 77,000 91 91 2,320 - 76,909 0% Expenditures Personnel - - - - - - 0% Supplies 41,499 6,433 1,499 40,000 4% Services 40,000 - 40,000 0% Debt Service - - 0% Capital 70,000 - 70,000 0% Transfers Out - - - - - - 0% Total Expenditures 151,499 - - 6,433 1,499 150,000 1% Net (74,499) 91 91 (4,113) (1,499) (73,091) Cash Balance 385,251 331,228 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to receive the Police Department share of money acquired in drug enforcement activity. Expenditures are to be used to fund drug enforcement and training. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax Month January Fund /Department Number 404 Date Updated 2/20/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 8,645,811 720,484 720,484 653,912 - 7,925,327 8% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 75,000 1,910 1,910 7,861 - 73,090 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 549,376 43,059 43,059 40,799 - 506,317 8% Transfers In - - - - - - 0% Total Revenue 9,270,187 765,453 765,453 702,571 - 8,504,734 8% Expenditures Personnel - - - - - - 0% Supplies 1,288,040 114,742 114,742 83,300 28,685 1,144,613 11% Services 4,990,602 511,984 511,984 433,753 272,127 4,206,491 16% Debt Service 2,211,045 985,585 985,585 972,069 - 1,225,460 45% Capital 386,515 - - 114,911 89,015 297,500 23% Transfers Out 1,100,000 - - - - 1,100,000 0% Total Expenditures 9,976,202 1,612,310 1,612,310 1,604,033 389,827 7,974,065 20% Net (706,015) (846,857) (846,857) (901,461) (389,827) 530,669 Cash Balance 14,059,206 14,425,541 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Significant revenue increase in 2014, due to the City receiving approximately $67,000 more per month in COIT distribution than in the prior year. The 2014 amended budget is negative because it includes $220,263 in encumbrances at 12/31/13 for projects that were in process. For 2014, COIT distribtutions from the County are $720,484.22 per month and are paid through January 31, 2014. The amount shown as Transfers Out of $1,100,000 is for the curb and sidewalk program. This is a significant increase (63 %) from last year as the program has been well received by the citizens of South Bend. The amount is transferred to the MVH fund 202. Explain Significant Spending on Capital Projects Below: This year, $297,500 has been budgeted for IT upgrades such as mobile 311 application and fiber enhancements to the County City building, Central Services and the Water Works Olive St. Station. The remaining balance of $89,015 is a prior encumbrance generated the Department of Community Investment for the Dollar Home Program. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax Month Janua Fund /Department Number 408 Date Updated 3/3/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 8,796,821 733,068 733,068 681,446 - 8,063,753 8% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 - - - - 504,660 0% Interest Earnings 45,000 1,342 1,342 5,121 - 43,658 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 11,948 11,948 - - (11,948) 0% Transfers In - - - - - - 0% Total Revenue 9,346,481 746,359 746,359 686,567 - 8,600,122 8% Expenditures Personnel 500,335 50,463 50,463 - - 449,872 10% Supplies - - - - - - 0% Services 2,609,285 658,977 658,977 527,664 979,353 970,955 63% Debt Service 1,043,263 521,500 521,500 517,500 - 521,763 50% Capital - - - - - - 0% Transfers Out 5,862,101 998,880 998,880 429,380 - 4,863,221 17% Total Expenditures 10,014,984 2,229,819 2,229,819 1,474,544 979,353 6,805,811 32% Net (668,503) (1,483,461) (1,483,461) (787,977) (979,353) 1,794,311 Cash Balance 9,358,667 9,196,434 Staffing Full Time 9.00 7.00 7.00 Part -Time /Seasonal /Temporary 0.50 0.50 0.50 Total 9.50 7.50 7.50 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 2014 Budget includes 10 people (9 FT, 1 PT) from Code Enforcement as a result of the 2014 Budget as advertised and a consequential limitation in Fund 600. Transfers Out include $1.69 million to DCI, $1.87 million to MVH, and $2.3 million to the Building Dept fund for Code Enforcement operations. Explain Significant Spending on Capital Projects Below: There are no Capital expenditures budgeted for 2014. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Month Janua Fund /Department Number 410 Date Updated 2/17/2014 Current Current 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 4 4 12 - 106 4% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 448 - - 0% Transfers In - - - - - - 0% Total Revenue 110 4 4 460 - 106 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 110 4 4 460 - 106 Cash Balance 27,591 24,214 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This budget usually includes payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. No new payments from the BDC are expected until 2015. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Month Janua Fund /Department Number 655 Date Updated 2/20/2014 Current Current 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,254 36,254 35,745 - 392,746 8% Interest Earnings 2,700 119 119 441 - 2,581 4% Bond Proceeds - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 36,373 36,373 36,186 - 395,327 8% Expenditures Personnel 64,378 1,333 1,333 868 63,045 2% Supplies 8,369 8,369 0% Services 34,583 1,481 1,481 2,868 33,102 4% Debt Service 72,784 11,619 11,619 61,165 16% Capital - - 0% Transfers Out 250,000 250,000 0% Total Expenditures 430,114 14,433 14,433 3,735 - 415,681 3% Net 1,586 21,940 21,940 32,450 - (20,354) Cash Balance 960,028 893,428 Staffing Full Time - - Part -Time /Seasonal /Temporary 2.16 Total 2.16 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Program is planned to begin on October 27th and (weather permitting) run through the first week in December. The The $250,000 transfer is to MVH to cover their costs in this process. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Month Janua Fund /Department Number 705 Date Updated 2/20/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10 - - 1 - 10 0% Bond Proceeds - - - - - - 0% Donations 1,990 - - - - 1,990 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 - - 1 - 2,000 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,000 - - - - 2,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,000 - - - - 2,000 0% Net - - - 1 - - Cash Balance 1,313 1,931 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service Month Janua Fund /Department Number 313 Date Updated 2/17/2014 Current Current 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,115,126 - - - - 1,115,126 0% Local Income Taxes - - - - - - 0% Other Taxes 67,350 - - - - 67,350 0% Grants /Intergovernmental 85,640 7,140 7,140 5,956 - 78,500 8% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,268,116 7,140 7,140 5,956 - 1,260,976 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 1,268,116 634,500 634,500 633,500 - 633,616 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,268,116 634,500 634,500 633,500 - 633,616 50% Net - (627,360) (627,360) (627,544) - 627,360 Cash Balance 88,975 (53,105) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to collect a separate property tax levy (distributions received in June and December) and is used to pay debt service on the former College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will typically have a negative cash balance until the property tax distributions are received. PILOT taxes paid by the utilities are received monthly in this fund. Property taxes received in the amount of $693,822.13 during June, 2013 eliminated the negative cash balance in this fund. The property tax collections of $693,822.13 represented 51.73% of the levy amount and 62.03% of the 2013 budgeted revenue amount. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. Both debt service payments have been made for 2013. The fund received $574,356 in property taxes and $27,967 in license excise tax revenue during December, 2013. The cash balance was $716,336 at December 31, 2013. This is a high cash balance for the fund based on historical trends. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Improv.7 I Month January Fund /Department Number 288 1 Date Updated 2/20/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 2,604,000 151,472 151,472 152,514 - 2,452,528 6% Interest Earnings 10,000 604 604 2,832 - 9,396 6% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 47,000 2,510 2,510 2,966 - 44,490 5% Transfers In - - - - - - 0% Total Revenue 2,661,000 154,586 154,586 158,312 - 2,506,414 6% Expenditures Personnel - - - - - - 0% Supplies 150,000 1,138 1,138 - 14,139 134,723 10% Services 416,952 19,081 19,081 17,612 2,925 394,946 5% Debt Service 351,106 20,332 20,333 20,333 - 330,773 1% Capital 2,654,157 408,652 408,652 615 1,470,502 775,003 0% Transfers Out 1,000,000 - - - 1,000,000 0% Total Expenditures 4,572,215 449,203 449,204 38,560 1,487,566 2,635,445 42% Net (1,911,215) (294,617) (294,618) 119,752 (1,487,566) (129,031) Cash Balance 5,245,822 5,658,493 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The revenues in this account are generated through user fees for the South Bend Fire Department EMS division. These funds are used for capital purchases such as fire trucks, ambulances and major construction projects. There are no employees associated with this fund. Incurring project expenses for construction of Fire Training Facility and Fire Station 5 which will be reimbursed through bond. A Bond Reimbursement of $5,079,387 was received from US Bank on 9 Dec 2013. Operating costs are incurred in the General Fund (101 -0901) and so a transfer of $1,000,000 is established to cover those expenditures. Explain Significant Spending on Capital Projects Below: Continued construction of Fire Training Facility. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month January Fund /Department Number 377 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 600,000 66,547 66,547 61,389 - 533,453 11% Charges for Services - - - - - - 0% Interest Earnings 4,000 101 101 534 - 3,899 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 74,228 34,608 34,608 41,646 - 39,620 47% Transfers In - - - - - - 0% Total Revenue 678,228 101,256 101,256 103,569 - 576,972 15% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 765,746 382,873 382,873 387,548 - 382,873 50% Capital - - - - - - 0% Transfers Out 100,000 - - 100,000 - 100,000 0% Total Expenditures 865,746 382,873 382,873 487,548 - 482,873 44% Net (187,518) (281,617) (281,617) (383,979) - 94,099 Cash Balance 560,440 656,844 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Effective January 1, 2013, this fund no longer collects hotel /motel tax allocations from St. Joseph County for payment to the Hall of Fame. This fund is currenty used for debt, and a $100,000 capital transfer to Century Center. 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 payments have been made for 2014. The final debt service payment on the 2010 Coveleski Stadium bonds was paid January 15, 2013. The outsanding principal balance on the bonds is $3,220,000 at January 31, 2014. Explain Significant Spending on Capital Projects Below: A $100,000 transfer is made annually to the Century Center Capital Fund 671. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month January Fund /Department Number 401 Date Updated 2/14/2014 Current Current 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 3 3 14 - 497 1% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 3 3 14 - 497 1% Expenditures Personnel - - - - - - 0% Supplies 2,002 - - - - 2,002 0% Services 1,538 - - - - 1,538 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,540 - - - - 3,540 0% Net (3,040) 3 3 14 - (3,043) Cash Balance 26,854 26,772 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fd 401 accounts for capital spending on Coveleski Stadium. Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Month Janua Fund /Department Number 403 Date Updated 2/14/2014 Current Current 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 6 6 25 - 194 3% Bond Proceeds - - - - - - 0% Donations 2,700 - - - - 2,700 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,900 6 6 25 - 2,894 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 2,900 6 6 25 - 2,894 Cash Balance 49,029 48,871 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to account for donations dedicated to Potawatomi Zoo. In the past few years several endowments that were funding this fund were liquidated resulting in a drop in revenues to this fund. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Month January Fund /Department Number 405 Date Updated 2/14/2014 Current Current 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 3,000 27 27 76 - 2,973 1% Interest Earnings 2,200 52 52 253 - 2,148 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 190,500 - - - - 190,500 0% Total Revenue 195,700 79 79 329 - 195,621 0% Expenditures Personnel - - - - - - 0% Supplies 23,417 4,814 4,814 6,302 19,994 (1,391) 106% Services 5,000 - - - 5,000 - 100% Debt Service - - - - - - 0% Capital 176,800 - - - - 176,800 0% Transfers Out - - - - - - 0% Total Expenditures 205,217 4,814 4,814 6,302 24,994 175,409 15% Net (9,517) (4,735) (4,735) (5,974) (24,994) 20,212 Cash Balance 568,156 486,412 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 2014 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development Month January Fund /Department Number 406 1 Date Updated 3/3/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 477,722 - - - - 477,722 0% Local Income Taxes - - - - - - 0% Other Taxes 87,294 3,891 3,891 3,838 - 83,403 4% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 3,500 96 96 429 - 3,404 3% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 568,516 3,987 3,987 4,267 - 564,529 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 42 - - 0% Debt Service 722,935 112,650 112,650 - - 610,285 16% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 722,935 112,650 112,650 42 - 610,285 16% Net (154,419) (108,663) (108,663) 4,225 - (45,756) Cash Balance 677,135 839,994 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund receives revenue from a property tax levy and distributions are received from St. Joseph County in June and December. Expenditures are for debt service payments on capital leases and the due dates vary per lease. The fund is used to finance police vehicles and related equipment. The fund also receives PILOT payments from the Water Works and Wastewater utilities on a monthly basis. For the 2014 budget, this fund will be used to pay existing police capital lease payments but will not include a capital lease for 2014. This payment will be moved to the COIT Fund No. 404 Explain Significant Spending on Capital Projects Below: There is no capital expenditure budgeted for 2014. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement Month January Fund /Department Number 407 Date Updated 3/3/2014 Current Current 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 150,000 - - - - 150,000 0% Grants /Intergovernmental 259,000 - - - - 259,000 0% Charges for Services - - - - - - 0% Interest Earnings 150 21 21 50 - 129 14% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In - - - - - - 0% Total Revenue 434,150 21 21 50 - 434,129 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 364,762 185,250 185,250 184,875 - 179,512 51% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 364,762 185,250 185,250 184,875 - 179,512 51% Net 69,388 (185,229) (185,229) (184,825) - 254,617 Cash Balance (8,505) (87,104) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Revenue is this fund includes $150,000 in hotel /motel taxes and $258,990 in cigarette taxes from other units of government. The hotel /motel tax distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December. In 201 r, this fund is used to pay 75% of the 2011 Century Center Refunding bonds as it was in 2013. Payments on the Century Center bond are due in February and July. Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year. Explain Significant Spending on Capital Projects Below: None Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction Month January Fund /Department Number 412 Date Updated 3/3/2012 Current Current 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 919 919 4,050 - 24,081 4% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 556,798 - - - - 556,798 0% Transfers In - - - - - - 0% Total Revenue 581,798 919 919 4,050 - 580,879 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 5,823,729 29,594 29,594 - 1,294,135 4,499,999 23% Transfers Out - - - - - - 0% Total Expenditures 5,823,729 29,594 29,594 - 1,294,135 4,499,999 23% Net (5,241,931) (28,675) (28,675) 4,050 (1,294,135) (3,919,120) Cash Balance 7,115,222 7,900,746 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Initial funding for the Major Moves fund in the amount of $12,823,151 was received from the State of Indiana on September 15, 2006. The money was derived from the State lease of the 1 -80 tollroad to a private company. This fund has been used in the past to provide seed money for economic development projects at Douglas Road, Eddy Street Commons, and the Triangle Development near Notre Dame. The amounts advanced for these projects are being repaid by the respective tax increment financing (TIF) funds as per formal amortization schedules. The amounts outstanding were $923,829 (Fund 435 - Douglas Road) and $4,989,008 (Fund 436 - Eddy Street /Triangle) at 31 December, 2013. Explain Significant Spending on Capital Projects Below: The 2014 Budget includes $5.6 million for the Smart Streets initiative, as well as a prior -year encumbrance of $173,020 for utility relocation on the US 31 project south of town. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Month January Fund /Department Number 416 Date Updated 2/18/2014 Current Current 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,305 7,305 743 - 92,695 7% Interest Earnings 1,500 57 57 203 - 1,443 4% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 101,500 7,362 7,362 946 - 94,138 7% Expenditures Personnel - - - - - - 0% Supplies 14,700 - - - - 14,700 0% Services 23,000 - - 230 500 22,500 2% Debt Service - - - - - - 0% Capital 15,500 - - - - 15,500 0% Transfers Out - - - - - - 0% Total Expenditures 53,200 - - 230 500 52,700 1% Net 48,300 7,362 7,362 717 (500) 41,438 Cash Balance 464,172 396,985 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Month Janua Fund /Department Number 434 Date Updated 2/17/2014 Current Current 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 1,000 30 30 106 - 970 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 651,000 30 30 106 - 650,970 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 650,950 20,975 20,975 36,975 - 629,975 3% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 650,950 20,975 20,975 36,975 - 629,975 3% Net 50 (20,945) (20,945) (36,869) - 20,995 Cash Balance (11,408) 186,718 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Variance relates to change in interest cost on amortization schedule. Revenue not expected until October or November. Principal payment made in August. In December, 2013 a % of the Principal was reclassified to Fund 404 COIT due to a shortfall in revenues in this fund. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Month Janua Fund /Department Number 450 Date Updated 2/18/2014 Current Current 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,796 1,796 1,251 - 14,204 11% Interest Earnings 125 8 8 30 - 117 6% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,125 1,803 1,803 1,280 - 14,322 11% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,000 - - - - 10,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,000 - - - - 10,000 0% Net 6,125 1,803 1,803 1,280 - 4,322 Cash Balance 55,198 59,585 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. No capital projects are planned for 2014. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Month January Fund /Department Number 677 Date Updated 2/17/2014 Current Current 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 85 85 369 - 2,415 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 85 85 369 - 2,415 3% Expenditures Personnel - - - - - - 0% Supplies 15,000 365 365 - - 14,635 2% Services 173,567 5,908 5,908 2,223 8,908 158,751 9% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,567 6,273 6,273 2,223 8,908 173,386 8% Net (186,067) (6,188) (6,188) (1,854) (8,908) (170,971) Cash Balance 652,218 717,232 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Hall of Fame Capital fund covers maintenance and utilities expense on the building incurred by the City, including costs of the building after the Hall of Fame ceased operations in South Bend at the end of 2012. The $8,908 encumbrance is for Otis Elevator for maintenance. Explain Significant Spending on Capital Projects Below: No Capital expenditures budgeted for 2013. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund Month Janua Fund /Department Number 600 Date Updated 3/4/2014 Current Current 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,503,500 94,202 94,202 88,652 - 1,409,298 6% Interest Earnings 1,000 22 22 105 - 978 2% Bond Proceeds - - - - - - 0% Donations - 1,353 1,353 - - (1,353) 0% Other Income 1,500 - - - - 1,500 0% Transfers In 2,306,560 576,640 576,640 - - 1,729,920 25% Total Revenue 3,812,560 672,217 672,217 88,757 - 3,140,343 18% Expenditures Personnel 2,009,828 195,660 195,660 63,807 9,577 1,804,592 10% Supplies 193,015 9,992 9,992 1,876 12,696 170,327 12% Services 1,313,266 39,909 39,909 4,522 649,965 623,393 53% Debt Service 21,800 2,905 2,905 2,905 1,008 17,887 18% Capital 209,000 - - - - 209,000 0% Transfers Out 52,000 - - - - 52,000 0% Total Expenditures 3,798,909 248,465 248,465 73,110 673,245 2,877,199 24% Net 13,651 423,752 423,752 15,647 (673,245) 263,144 Cash Balance 576,114 219,799 Staffing Full Time 30.00 27.00 27.00 Part -Time /Seasonal /Temporary - - - Total 30.00 27.00 27.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund now comprises the Consolidated Building Department, most of Code Enforcement and Animal Control. Code and Animal Control are managed together but are run separately from the Building Department per Council's wishes. There are 9 additional positions for Code Enforcement that are paid from the EDIT fund (408) as it was not possible to increase the expenditures of this fund to accommodate them as a result of an advertising limitation. The $2.3 million transfer is from the General Fund to cover Code and Animal Control activities which 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 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages Month Janua Fund /Department Number 601 Date Updated 2/17/2014 Current Current 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 900,500 94,897 94,897 59,217 - 805,603 11% Interest Earnings 4,000 117 117 439 - 3,883 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 135,900 7,075 7,075 6,664 - 128,825 5% Transfers In - - - - - - 0% Total Revenue 1,040,400 102,089 102,089 66,320 - 938,311 10% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 663,179 96,764 96,764 94,299 15,000 551,415 17% Debt Service - - - - - - 0% Capital 134,629 - - - 78,630 55,999 58% Transfers Out - - - - - - 0% Total Expenditures 797,808 96,764 96,764 94,299 93,630 607,414 24% Net 242,592 5,325 5,325 (27,979) (93,630) 330,897 Cash Balance 889,512 827,465 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 2013 projects were: upgrade lighting; new signage; and trash receptacles. 2014 projects currently include: elevator repairs; painting; and storm water drain repairs. Additional capital needs are being identified for possible 2014 appropriation. Operations under outside contract with Downtown South Bend, Inc. so all expenses except capital are shown under Services line to show consistently with Redevelopment Retail and Blackthorn Golf Course. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations Month Janua Fund /Department Number 610 Date Updated 2/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 4,815,830 400,486 400,486 398,988 - 4,415,344 8% Interest Earnings 6,000 99 99 - - 5,901 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 435,871 - - 600 - 435,871 0% Transfers In - - - - - 0% Total Revenue 5,257,701 400,585 400,585 399,588 - 4,857,116 8% Expenditures Personnel 1,502,054 183,380 183,380 126,065 2,500 1,316,174 12% Supplies 324,095 24,937 24,937 18,083 67,123 232,034 28% Services 2,877,312 233,391 233,391 217,086 805,141 1,838,781 36% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 736,002 230,416 230,416 279,339 - 505,586 31% Total Expenditures 5,439,463 672,124 672,124 640,573 874,764 3,892,575 28% Net (181,762) (271,539) (271,539) (240,985) (874,764) 964,541 Cash Balance 523,283 949,883 Staffing Full Time 24.20 24.20 Part -Time /Seasonal /Temporary 8.00 8.00 Total 32.20 32.20 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund charges City residents a nominal 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. Personnel costs are running high this month because there were three payrolls instead of the typical two. Actual supplies expense for the month was right on budget; encumbrances are reserving an additional 20% of the budget dollars. The same is true for services; the actual expenses were right on track. Large encumbrances are reserving an additional 28% of budget dollars for landfill tipping fees. Transfers out are done as needed to fund upcoming purchases and lease payments. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Month Janua Fund /Department Number 611 Date Updated 2/14/2014 Current Current 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 21 21 0 - 179 10% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 736,002 230,416 230,416 279,339 - 505,586 31% Total Revenue 736,202 230,437 230,437 279,339 - 505,765 31% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 896,070 264,795 264,795 188,809 - 631,275 30% Capital - - - - 84,082 (84,082) 0% Transfers Out - - - - - - 0% Total Expenditures 896,070 264,795 264,795 188,809 84,082 547,193 39% Net (159,868) (34,359) (34,359) 90,530 (84,082) (41,427) Cash Balance 84,082 90,638 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to pay for capital items, such as trash trucks, used in the day to day operations of Solid Waste. Other than a small amount of interest income, the sole source of revenue comes from dollars transferred in from the Solid Waste Operations Fund #610. These transfers are done on an as needed basis, rather than a fixed monthly amount. The current cash balance in the fund is there to cover the current encumbrance for some truck upgrade equipment. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations Month Janua Fund /Department Number 620 Date Updated 2.17.14 Current Current 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,589,253 985,445 985,445 1,037,711 - 13,603,808 7% Interest Earnings 9,000 406 406 904 - 8,594 5% Bond Proceeds - - - 0% Donations - - - 0% Other Income 93,580 31,678 31,678 5,382 - 61,902 34% Transfers In 19,500 643 643 - - 18,857 3% Total Revenue 14,711,333 1,018,172 1,018,172 1,043,997 - 13,693,161 7% Expenditures Personnel 4,594,374 482,651 482,651 323,894 3,100 4,108,623 11% Supplies 1,624,686 72,396 72,396 67,866 60,252 1,492,038 8% Services 4,633,411 328,682 328,682 317,156 266,104 4,038,625 13% Debt Service 6,555 578 578 432 - 5,977 9% Capital - - - - - - 0% Transfers Out 3,982,978 314,278 314,278 370,131 - 3,668,700 8% Total Expenditures 14,842,004 1,198,585 1,198,585 1,079,479 329,456 13,313,963 10% Net (130,671) (180,412) (180,412) (35,482) (329,456) 379,197 Cash Balance 3,327,359 1,809,178 Staffing Full Time 70.20 67.20 Part -Time /Seasonal /Temporary 3.00 3.50 Total 73.20 70.70 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to account for all revenue and operational expense of the water utility. This fund provides the monies for debt service obligations, reserve requirements and revenue funded capital improvements through transfer of monies to other funds within the utility operations. Current year charges for service revenue is slightly less than 2013 and is a result of January 2014's utility customer service allocation not being posted for the month. Scrap metal proceeds totaling $29,754 elevated other income for the current year. The 2% increase in current year expenditures is attributed to the rise in salaries, wages, weather related overtime, and blanket/value purchase orders being generated for the new year. Surplus operating money was not tranferred out to the Depreciation Fund in 2013 and is contributing to the significant difference in ending cash balances. A transfer will be initiated later this year. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Month Janua Fund /Department Number 622 Date Updated 2.17.14 Current Current 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 453 453 2,126 - 9,547 5% Bond Proceeds - - - - 0% Donations - - - 0% Other Income - - - 0% Transfers In - - - - 0% Total Revenue 10,000 453 453 2,126 - 9,547 5% Expenditures Personnel - - 0% Supplies - - 0% Services 3,600 3,600 3,600 - - - 100% Debt Service - - - - - 0% Capital 974,658 - - 818 21,158 953,501 2% Transfers Out - - 0% Total Expenditures 978,258 3,600 3,600 818 21,158 953,501 3% Net (968,258) (3,147) (3,147) 1,308 (21,158) (943,953) Cash Balance 3,528,578 4,146,626 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to pay for capital expenditures for various water utility operations. Monies are transferred as required from the water utility operating fund to provide necessary cash for the asset acquisitions. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Month January Fund /Department Number 623 Date Updated 2.14.14 Current Current 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 223 223 2,976 4,777 4% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 223 223 2,976 - 4,777 4% Expenditures Personnel - - 0% Supplies 209,422 17,780 17,780 38,891 152,751 27% Services 74,076 - - - 74,076 0 100% Debt Service - - - - - - 0% Capital 527,513 - - 90,214 427,514 99,999 81% Transfers Out - - - - - 0% Total Expenditures 811,011 17,780 17,780 90,214 540,480 252,751 69% Net (806,011) (17,557) (17,557) (87,238) (540,480) (247,973) Cash Balance 795,073 5,715,598 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to segragate 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 aggregrate principal of $8,300,000. Committed encumbrance amounts are for the Pinhook WTP Efficiency Improvement Project. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Month January Fund /Department Number 624 Date Updated 2.14.14 Current Current 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 186 186 722 - 5,814 3% Bond Proceeds - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 186 186 722 - 5,814 3% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - 0% Transfers Out 6,000 186 186 - - 5,814 3% Total Expenditures 6,000 186 186 - - 5,814 3% Net - - - 722 - - Cash Balance 1,453,663 1,413,600 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to retain security deposits collected from customers when establishing new service. Upon termination of service, these deposits are released and credited against final bills. Explain Significant Spending on Capital Projects Below: N/A Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Month Janua Fund /Department Number 625 Date Updated 2.14.14 Current Current 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 196 196 2 4,804 4% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income - - - - - 0% Transfers In 2,052,224 170,810 170,810 170,953 1,881,414 8% Total Revenue 2,057,224 171,006 171,006 170,955 - 1,886,218 8% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - 0% Debt Service 2,057,224 196 196 600 2,057,028 0% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 2,057,224 196 196 600 - 2,057,028 0% Net - 170,810 170,810 170,355 - (170,810) Cash Balance 176,147 174,992 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. The source of monies for debt repayment are transfers from the water utility operating fund 620. Explain Significant Spending on Capital Projects Below: N/A Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Month January Fund /Department Number 626 Date Updated 2.14.14 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,500 197 197 662 5,303 4% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income - - - - 0% Transfers In 84,573 8,564 8,564 25,397 76,009 10% Total Revenue 90,073 8,761 8,761 26,059 - 81,312 10% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 90,073 8,761 8,761 26,059 - 81,312 Cash Balance 1,574,437 1,337,747 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to ensure compliance with certain debt service bond covenants. Balance in fund is determined by debt service financing arrangements at bond issuance. Maximum requirement amounts will be fully satisfied by the end of October this year. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Month January Fund /Department Number 629 Date Updated 2.14.14 Current Current 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 261 261 1,019 - 8,239 3% Bond Proceeds - - - 0% Donations - - - 0% Other Income - - - 0% Transfers In 61,812 - - 45,301 - 61,812 0% Total Revenue 70,312 261 261 46,320 - 70,051 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 261 261 - 8,239 3% Total Expenditures 8,500 261 261 - - 8,239 3% Net 61,812 - - 46,320 - 61,812 Cash Balance 2,031,532 2,032,550 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to hold cash reserves to serve as fiscal protection against the risk of revenue shortfalls, emergencies and other economic risks that may impact the Water Utility's ability to meet financial commitments. Additional monies is expected to be transferred in during the month of February to satisfy 100% of the 2014 requirement. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Month Janua Fund /Department Number 640 Date Updated 2/20/2014 Current Current 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 47,660 47,660 44,566 - 500,340 9% Interest Earnings 1,200 173 173 595 - 1,027 14% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 549,200 47,833 47,833 45,161 - 501,367 9% Expenditures Personnel 177,387 12,781 12,781 7,676 164,606 7% Supplies 17,115 554 1,791 2,576 42 15,283 11% Services 327,041 3,915 2,678 24,164 18,020 306,343 6% Debt Service 28,435 28,435 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 549,978 17,250 17,250 34,416 18,062 514,667 6% Net (778) 30,583 30,583 10,745 (18,062) (13,299) Cash Balance 1,393,499 1,172,755 Staffing Full Time 2.10 2.10 Part -Time /Seasonal /Temporary - - - Total 2.10 2.10 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Increase in salaries due to new allocation of portion of Sewer Manager and Sewer Concrete Job Leader salaries. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations Month January Fund /Department Number 641 Date Updated 2/18/2014 Current Current 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,460,188 2,669,147 2,669,147 2,366,557 - 31,791,041 8% Interest Earnings 18,000 902 902 2,273 - 17,098 5% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,000 4,373 4,373 488 - 55,627 7% Transfers In 15,000 422 422 - - 14,578 3% Total Revenue 34,553,188 2,674,845 2,674,845 2,369,318 - 31,878,343 8% Expenditures Personnel 6,776,379 778,074 778,074 499,159 2,500 5,995,805 12% Supplies 2,419,100 126,366 126,366 204,237 527,948 1,764,786 27% Services 12,452,029 656,246 656,246 844,415 1,439,851 10,355,932 17% Debt Service 359,746 132,589 132,589 108,568 - 227,157 37% Capital - - - - - - 0% Transfers Out 13,548,940 2,904,883 2,904,883 817,768 - 10,644,057 21% Total Expenditures 35,556,194 4,598,158 4,598,158 2,474,146 1,970,300 28,987,736 18% Net (1,003,006) (1,923,313) (1,923,313) (104,828) (1,970,300) 2,890,607 Cash Balance 5,130,148 4,473,431 Staffing Full Time 95.04 95.04 Part -Time /Seasonal /Temporary 7.00 6.00 Total 102.04 101.04 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Personnel costs are up due to three payrolls and related expenses happening in January. Encumbrances that reserve budget dollars for specific supply purchases account for 22% of the budget; actual spending in January for supplies was at 5% of the annual request. Spending for services was at 5% of budget; encumbrances reserved an additional 12% of the total. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Month Janua Fund /Department Number 642 Date Updated 2/18/2014 Current Current 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 563 563 4,546 - 38,437 1% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 3,527,580 2,000,000 2,000,000 - - 1,527,580 57% Total Revenue 3,566,580 2,000,563 2,000,563 4,546 - 1,566,017 56% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 133,264 - - - 133,264 0 100% Debt Service - - - - - - 0% Capital 9,134,677 978,994 978,994 47,174 4,628,106 3,527,578 61% Transfers Out - - - - - - 0% Total Expenditures 9,267,941 978,994 978,994 47,174 4,761,369 3,527,578 62% Net (5,701,361) 1,021,570 1,021,570 (42,629) (4,761,369) (1,961,562) Cash Balance 5,066,136 8,820,480 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to purchase capital equipment and fund major renovations /restorations for the Wastewater and Sewer Departments. The primary source of income is from Sewage Works Operating Fund #641, which transfers funds here as needed. Projects budgeted this year include Sewer Relining and Manhole Rehab. work throughout the City, replacing the Eastgate area Lift Station, and rebuilding /replacing the dewatering presses at the Wastewater Plant. Explain Significant Spending on Capital Projects Below: Most of this month's spending was for the ongoing $5 million Primary Clarifier Rehab project at the Wastewater Plant. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Month January Fund /Department Number 643 Date Updated 2/17/2014 Current Current 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 422 422 1,586 - 14,578 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 223,715 129,964 129,964 - - 93,751 58% Total Revenue 238,715 130,386 130,386 1,586 - 108,329 55% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 422 422 - - 14,578 3% Total Expenditures 15,000 422 422 - - 14,578 3% Net 223,715 129,964 129,964 1,586 - 93,751 Cash Balance 3,422,564 3,093,890 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The sole purpose of this fund is to hold the equivalent of two months of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. Any transfers to this fund are done to adjust the balance as needed to stay in compliance. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2004/2006 Month Janua Fund /Department Number 645 Date Updated 2/17/2014 Current Current 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 - 12 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: All funds in this bond have been spent. There was no 2013 budget and no 2014 budget. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Month Janua Fund /Department Number 647 Date Updated 2/17/2014 Current Current 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 - 10 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 - 10 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,138 - - - 1,138 0 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,138 - - - 1,138 0 100% Net (1,138) 1 - 10 (1,138) (0) Cash Balance 1,141 19,051 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Bond is almost fully spent. The small encumbrance that remains is expected to be liquidated early this year. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Month Janua Fund /Department Number 649 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 7,000 109 109 429 - 6,892 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,797,645 774,919 774,919 814,244 - 9,022,726 8% Total Revenue 9,804,645 775,028 775,028 814,673 - 9,029,617 8% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,000 500 500 - - 2,500 17% Debt Service 9,799,031 - - - - 9,799,031 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,802,031 500 500 - - 9,801,531 0% Net 2,614 774,528 774,528 814,673 - (771,914) Cash Balance 1,557,334 1,650,718 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to pay all debt service obligations for Wastewater and Sewers (Sewage Works). Mandatory transfers in from Operating Fund 641 are done in specified amounts each month to satisfy bond covenants. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Clay Sewage Month Janua Fund /Department Number 650 Date Updated 2/17/2014 Current Current 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 - 697 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund has been dormant for a number of years. Cash balance was transferred to Fund 641 in 2013 to fully close this fund. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Bond 2007B Month Janua Fund /Department Number 651 Date Updated 2/17/2014 Current Current 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 20 - (0) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 0 0 20 - (0) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 0 0 20 - (0) Cash Balance 2 39,578 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund has been fully spent. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Month January Fund /Department Number 653 Date Updated 2/17/2014 Current Current 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 - - - 3,524 - - 0% Total Revenue - - - 3,524 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - 3,524 - - Cash Balance 7,286,828 9,714,341 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Debt Reserve fund is held in a separate account with Bank of NY Mellon Trust. A reconcilliation of this account is done monthly. The account was fully funded for existing debt in 2013. The fund balance on January 31, 2014 was $7,286,828.66. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Month Janua Fund /Department Number 658 Date Updated 2/18/2014 Current Current 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 58 - (0) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 0 0 58 - (0) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 518 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 518 - - 0% Net - 0 0 (460) - (0) Cash Balance 2,216 111,743 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The small balance in this fund should be used sometime in 2014. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 Month Janua Fund /Department Number 659 Date Updated 2/18/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 25,000 1,034 1,034 5,214 - 23,966 4% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 1,034 1,034 5,214 - 23,966 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 705,491 - - 28,221 5,491 700,000 1% Debt Service - - - - - - 0% Capital 12,892,995 275,419 275,419 717,519 5,317,576 7,300,000 43% Transfers Out - - - - - - 0% Total Expenditures 13,598,486 275,419 275,419 745,740 5,323,067 8,000,000 41% Net (13,573,486) (274,385) (274,385) (740,526) (5,323,067) (7,976,034) Cash Balance 7,574,115 9,425,984 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Sewage Works Revenue Bond closed in October of 2011. A number of projects have been funded from this bond; the more significant projects are listed below. Explain Significant Spending on Capital Projects Below: Bond funds have been used for Diamond Ave. Trunk Sewer, Phase II $3.7 million, East Bank Sewer Sep, Phase II $2.8 million, East Bank Sewer Sep, Phase III $2.3 million, LaSalle School area Sewer Sep, $1.7 million, East Bank Sewer Sep, Phase III $545,000, Southwood Sewer Sep, $229,000, Diamond Ave. Trunk Sewer, Phase III $247,000, St. Joseph River CSO Stabilization $170,000, and Wastewater Treatment Plant Digester Upgrade $757,000 Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Month Janua Fund /Department Number 661 Date Updated 2/18/2014 Current Current 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 45,000 2,373 2,373 - - 42,627 5% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,000 2,373 2,373 - - 42,627 5% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,870,000 - - 104,981 - 4,870,000 0% Debt Service - - - - - - 0% Capital 13,998,570 272,470 272,470 - 596,102 13,129,998 6% Transfers Out - - - - - - 0% Total Expenditures 18,868,570 272,470 272,470 104,981 596,102 17,999,998 5% Net (18,823,570) (270,097) (270,097) (104,981) (596,102) (17,957,371) Cash Balance 18,028,930 23,141,907 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Bond closed in Dec 2012. Explain Significant Spending on Capital Projects Below: From the Bond issue date through January 2014, projects funded include: East Bank Sewer Separation -Phase 4 $2.6 million, Diamond Ave. Sewer Separation -Phase 3, $2.5 million, and Prairie Avenue Sewer Separation $308,000. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2013 Month Janua Fund /Department Number 663 Date Updated 2/18/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 60,000 - - - - 60,000 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 60,000 - - - - 60,000 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 910,000 - - - - 910,000 0% Debt Service - - - - - - 0% Capital 18,190,000 - - - - 18,190,000 0% Transfers Out - - - - - - 0% Total Expenditures 19,100,000 - - - - 19,100,000 0% Net (19,040,000) - - - - (19,040,000) Cash Balance Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: A 2013 Sewer bond was not issued; no activity is expected in this fund. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund Month Janua Fund /Department Number 664 Date Updated 2/18/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 1 1 - - (1) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 1 - - (1) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 1 - - (1) Cash Balance 4,468 - Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up to pay the issue costs related to the re- funding of the 2004 Sewer bond and 1998 SRF Loan. Most of those costs were paid in 2013. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name 2014 Sewer Bond Month January Fund /Department Number 665 Date Updated 2/18/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds 21,000,000 - - - - 21,000,000 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 21,000,000 - - - - 21,000,000 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 500,000 - - - - 500,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 500,000 - - - - 500,000 0% Net 20,500,000 - - - - 20,500,000 Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up in anticipation of a possible Sewer Bond issue sometime in 2014. No activity expected at this time. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Century Center Month Janua Fund /Department Number 670 Date Updated 3/3/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,313,436 - - 656,718 - 1,313,436 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 3,236,462 99,638 99,638 126,185 - 3,136,824 3% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 15,000 1,805 1,805 8,131 - 13,195 12% Transfers In - - - - - - 0% Total Revenue 4,564,898 101,443 101,443 791,035 - 4,463,455 2% Expenditures Personnel 2,450,875 201,210 201,210 125,349 - 2,249,665 8% Supplies 476,400 23,481 23,481 2,014 - 452,919 5% Services 1,222,594 89,938 89,938 58,115 - 1,132,656 7% Debt Service - - - - - - 0% Capital 415,029 - - - - 415,029 0% Transfers Out - - - - - - 0% Total Expenditures 4,564,898 314,629 314,629 185,479 - 4,250,269 7% Net - (213,186) (213,186) 605,556 - 213,186 Cash Balance 705,101 1,539,261 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: SMG has assumed management of Century Center effective 1 July 2013. One of their contractual duties is to reduce the operating deficit in the fund. Covered by hotel /motel tax revenue. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Month Janua Fund /Department Number 671 Date Updated 3/3/2014 Current Current 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 100,000 - - 100,000 - 100,000 0% Charges for Services - - - - - - 0% Interest Earnings 500 30 30 22 - 470 6% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 100,500 30 30 100,022 - 100,470 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 100,500 30 30 100,022 - 100,470 Cash Balance 1,757,727 1,374,899 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Century Center Capital fund receives an annual transfer of PSDA tax money in the amount of $100,000 per year. The Century Center Board of Managers has not approved a 2014 capital budget in this fund. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month Janua Fund /Department Number 222 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 7,796,184 668,864 668,864 591,889 - 7,127,320 9% Interest Earnings 3,000 133 133 559 - 2,867 4% Bond Proceeds - - 0% Donations - - 0% Other Income 48,190 1,847 1,847 2,020 - 46,343 4% Transfers In - - - - - - 0% Total Revenue 7,847,374 670,844 670,844 594,468 - 7,176,530 9% Expenditures Personnel 2,828,264 281,400 281,400 194,504 52 2,546,812 10% Supplies 177,649 (24,366) (24,366) 9,701 89,899 112,116 37% Services 4,783,622 415,928 415,928 357,855 3,234,207 1,133,488 76% Debt Service 6,497 - - 1,414 3,709 2,788 57% Capital - - - 0% Transfers Out - - - - 0% Total Expenditures 7,796,032 672,962 672,962 563,474 3,327,867 3,795,204 51% Net 51,342 (2,118) (2,118) 30,994 (3,327,867) 3,381,327 Cash Balance 1,608,231 1,078,867 Staffing Full Time 42.00 40.00 40.00 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 43.00 41.00 41.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Central Services Division consists of six cost centers that provide a variety of services to other City Depts along with several Local County, State and Federal agencies.We are internally funded by fees charged for services provided. In January we had 428 hrs of overtime, our shop was open almost 7 days /wk, 24 hrs day. More supplies were purchased for Inventory for equipment repairs and for our Central Stores Inventory. Purchase Orders were opened up for the year for our lease purchase equipment, also for the Nipsco and AEP utilities which is why the % is higher for the Service Category. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance Month Janua Fund /Department Number 226 Date Updated 2/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 2,859,690 235,157 235,157 247,413 - 2,624,533 8% Interest Earnings 22,000 684 684 2,690 - 21,316 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 - - 161 - 17,000 0% Transfers In - - - - - - 0% Total Revenue 2,898,690 235,841 235,841 250,264 - 2,662,849 8% Expenditures Personnel 189,417 19,262 19,262 12,918 - 170,155 10% Supplies 21,143 683 683 608 20,460 3% Services 2,676,640 83,461 83,461 244,442 82,000 2,511,179 6% Debt Service - - - - - - 0% Capital 10,000 - - - - 10,000 0% Transfers Out - - - - - 0% Total Expenditures 2,897,200 103,406 103,406 257,968 82,000 2,711,794 6% Net 1,490 132,435 132,435 (7,704) (82,000) (48,945) Cash Balance 5,317,932 5,237,711 Staffing Full Time 3.00 3.00 3.00 Part -Time /Seasonal /Temporary - - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund handles operations relating to business insurance and claims: property, liability, workers compensation, etc. and the operation of the safety and risk department. We are on target and no budget issues are anticipated at this time. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Month January Fund /Department Number 278 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 60,580 7,160 7,160 4,810 - 53,420 12% Interest Earnings 2,000 58 58 201 - 1,942 3% Bond Proceeds - - 0% Donations - - 0% Other Income 60,580 7,160 7,160 4,810 - 53,420 12% Transfers In - - - - - - 0% Total Revenue 123,160 14,378 14,378 9,821 - 108,782 12% Expenditures Personnel - - - - - - 0% Supplies 60,580 - 60,580 0% Services 20,000 - 20,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 80,580 - - - - 80,580 0% Net 42,580 14,378 14,378 9,821 - 28,202 Cash Balance 467,330 401,626 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund charges police officers for liability insurance and gasoline costs for take home police vehicles. No expenditures for vehicle claims have been paid so far in 2014.The cash reserves in this fund have been increasing in recent years and are expected to increase during 2014. Claims have been minimal in this fund since it was created. This fund is classified as an Internal Service Fund for financial reporting. No liability claims were paid during 2013. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits Month Janua Fund /Department Number 711 Date Updated 2/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 13,385,150 938,326 938,326 1,002,442 - 12,446,824 7% Interest Earnings 32,000 758 758 3,810 - 31,242 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,300 15 15 45 - 1,285 1% Transfers In - - - - - - 0% Total Revenue 13,418,450 939,099 939,099 1,006,296 - 12,479,351 7% Expenditures Personnel 4,326 - - - - 4,326 0% Supplies 17,875 91 91 1,242 17,784 1% Services 760,062 41,988 41,988 48,529 7,000 711,074 6% Insurance 13,701,200 484,850 484,850 1,091,675 12,000 13,204,350 4% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 14,483,463 526,930 526,930 1,141,446 19,000 13,937,533 4% Net (1,065,013) 412,170 412,170 (135,149) (19,000) (1,458,183) Cash Balance 6,073,617 7,293,041 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund handles expenses relating to insurance and claims relating to employees: medical, dental, life, flex spending, etc. For the last several years expenses have significantly exceeded revenues (charges to City Departments and employees) so our cash balance has been eroding. We anticipate losing another $1 million this year. This is not sustainable in the long -term and we need to address this situation. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Month Janua Fund /Department Number 713 Date Updated 3/3/2014 Current Current 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 236,398 8,530 8,530 28,438 - 227,868 4% Interest Earnings 500 33 33 37 - 467 7% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 236,898 8,564 8,564 28,475 - 228,334 4% Expenditures Personnel 220,750 9,071 9,071 5,065 - 211,679 4% Supplies - - - - - - 0% Services 7,224 602 602 357 - 6,622 8% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 227,974 9,673 9,673 5,422 - 218,301 4% Net 8,924 (1,109) (1,109) 23,053 - 10,033 Cash Balance 258,921 95,619 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund charges an allocation of 0.5% of payroll to most departments to cover the cost of unemployment claims paid. For the 2014 budget, the rate charged to departments has been reduced to 0.25% due to favorable claims history and increasing cash reserves. At December 31, 2013, claims paid on behalf of former Parks & Recreation department employees were $31,307, or 11 % of total claims paid. Cash reserves are increasing in this fund. The Unemployment Compensation Fund is classified as an Internal Service Fund for financial reporting. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension Month Janua Fund /Department Number 701 Date Updated 3/3/2014 Current Current 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 5,386,832 - - - - 5,386,832 0% Charges for Services - - - - - - 0% Interest Earnings 4,500 157 157 691 - 4,343 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,391,332 157 157 691 - 5,391,175 0% Expenditures Personnel 5,869,495 457,164 457,164 464,227 - 5,412,331 8% Supplies 200 - - - - 200 0% Services 4,750 - - 80 - 4,750 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,874,445 457,164 457,164 464,307 - 5,417,281 8% Net (483,113) (457,007) (457,007) (463,616) - (26,106) Cash Balance 481,093 882,799 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Fire Pension fund receives State of Indiana pension relief payments in June and September to reimburse the City for actual pension costs paid and reported in the previous year. Explain Significant Spending on Capital Projects Below: No capital expenditures are purchased through this account. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Pension Month Janua Fund /Department Number 702 Date Updated 2/11/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 6,300,000 - - - - 6,300,000 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 261 261 1,184 - 5,739 4% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,000 - - 267 - 4,000 0% Transfers In - - - - - - 0% Total Revenue 6,310,000 261 261 1,451 - 6,309,739 0% Expenditures Personnel 7,216,441 542,603 542,603 541,323 - 6,673,838 8% Supplies 1,100 - - 600 - 1,100 0% Services 4,400 - - 164 - 4,400 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 7,221,941 542,603 542,603 542,087 - 6,679,338 8% Net (911,941) (542,342) (542,342) (540,636) - (369,599) Cash Balance 1,166,315 1,769,441 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Police Pension fund receives pension relief distributions from the State of Indiana to reimburse the City for pension costs paid and reported in the previous fiscal year. Per an INPERS letter dated June 3, 2013, the state pension relief payments will be $2,931,848.71 each on July 1, 2013 and October 2, 2013. The projected cash balance in the fund is $1,544,07.43 at December 31, 2013, a decrease of $764,618.46 during the year. The pension relief payments do not cover retiree health insurance premiums paid by the fund. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Month Janua Fund /Department Number 730 Date Updated 2/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 250 5 5 21 - 245 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 250 5 5 21 - 245 2% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,595 - - - 10,595 - 100% Debt Service - - - - - - 0% Capital 10,000 - - - - 10,000 0% Transfers Out - - - - - - 0% Total Expenditures 20,595 - - - 10,595 10,000 51% Net (20,345) 5 5 21 (10,595) (9,755) Cash Balance 36,939 41,133 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is designated for expenses specifically for the City Cemetery. Revenues were originally derived from the sale of cemetery plots and burial expenses.There are few sites available for sale and most plots are occupied, resulting in little burial activty. Explain Significant Spending on Capital Projects Below: Spending this year will concentrate on repairing headstones and completing the GIS survey of the cemetery and its occupants. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF Revenue - Airport Month Janua Fund /Department Number 324 1 Date Updated 2/17/2014 Current Current 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 - - - - - - 0% Interest Earnings 79,612 2,720 2,720 9,452 - 76,892 3% Bond Proceeds - - - - - - 0% Donations - - - 65,000 - - 0% Other Income - - - - - - 0% Transfers In 5,000 133 133 - - 4,867 3% Total Revenue 13,484,612 2,853 2,853 74,452 - 13,481,759 0% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 6,541,053 270,553 270,553 147,671 3,345,397 2,925,103 55% Debt Service 3,562,381 1,132,971 1,132,971 645,000 - 2,429,410 32% Capital 17,183,259 - - 874,217 3,550,139 13,633,120 21% Transfers Out - - - - - - 0% Total Expenditures 27,286,693 1,403,524 1,403,524 1,666,888 6,895,536 18,987,633 30% Net (13,802,081) (1,400,671) (1,400,671) (1,592,436) (6,895,536) (5,505,874) Cash Balance 23,619,459 16,836,816 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 2013 Revenue from one time payment from AJ Wright of $2 M received in April along with Blackthorn debt service paid off in 2013 and reserve amount returned to this fund. While one can find usefulness in reviewing revenue trends in TIF funds from one year to the next, because projects change wildly from one year to the next, it is less meaningful to examine year to date expenditures against the prior year to date. Major projects carried out in 2013 were: Ignition Park Infrastructure; Data Realty; the SB Animal Shelter reconstruction; continued acquisition in Ignition Park South and East; purchase of Scientific Equipment in Ignition Park; acquisition in the LaSalle Square Area; the Renaissance District Phase I and the beginnings of Phase II; the beginnings of expenditures on the Studebaker /Oliver Project; and Bosch holding costs. In 2014, the major projects thus far approved are: Continuation of projects approved for 2013; and the addition of the Kolata contract. Explain Significant Spending on Capital Projects Below: Capital projects thus far this year are: Renaissance District Phase II; major expenditures in the Certified Tech Park; the Studebaker /Oliver project; and continued Ignition Park South & East acquisitions. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown Month Janua Fund /Department Number 420 1 Date Updated 2/17/2014 Current Current 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,650,000 - - - - 3,650,000 0% Local Income Taxes - - - - - - 0% Other Taxes 401,000 - - - - 401,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,000 2,432 2,432 3,688 - 31,568 7% Interest Earnings 49,645 3,670 3,670 5,875 - 45,975 7% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 277,691 24,078 24,078 28,508 - 253,613 9% Transfers In 6,000 223 223 - - 5,777 4% Total Revenue 4,418,336 30,403 30,403 38,071 - 4,387,933 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 535,411 44,919 44,919 43,426 322,811 167,681 69% Debt Service 2,972,966 955,676 955,676 - - 2,017,290 32% Capital 2,320,884 15,336 15,336 5,258 45,890 2,259,658 3% Transfers Out - - - - - - 0% Total Expenditures 5,829,261 1,015,931 1,015,931 48,684 368,701 4,444,629 24% Net (1,410,925) (985,528) (985,528) (10,613) (368,701) (56,696) Cash Balance 1,618,945 2,832,744 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF funds are used to fund projects which vary widely from year to year, so no real trend is expected from one year to the next. Explain Significant Spending on Capital Projects Below: Capital projectes committed to in 2014 include: Finishing Century Center West Entrance; Studebaker Plaza; Hill & Colfax Mixed Use Development; and Lasalle Hotel. Capital projects taken on in 2013 were:Century Center West Entrance; Studebaker Plaza; and Wayne Street Garage Facade improvements. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Month Janua Fund /Department Number 422 1 Date Updated 2/17/2014 Current Current 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 58 58 232 - 1,942 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 422,000 58 58 232 - 421,942 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,319 319 319 315 - 10,000 3% Debt Service - - - - - - 0% Capital 647,215 - - 89,811 8,300 638,915 1% Transfers Out - - - - - - 0% Total Expenditures 657,534 319 319 90,126 8,300 648,915 1% Net (235,534) (261) (261) (89,894) (8,300) (226,973) Cash Balance 612,701 361,834 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year so little can be gained by comparing expenditures from year to year. Major projects for 2013 were: Completion of Rushton Square and William Streetscape. Major Projects committed thus far in 2014 are: Completion of Rushton Square. Explain Significant Spending on Capital Projects Below: Major projects committed thus far in 2014 are: Completion of Rushton Square. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Month Janua Fund /Department Number 425 Date Updated 2/17/2014 Current Current 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 12 12 44 - 488 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 163,803 9,928 9,928 12,988 - 153,875 6% Transfers In - - - - - - 0% Total Revenue 164,303 9,940 9,940 13,032 - 154,363 6% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 128,373 4,077 4,077 3,970 - 124,296 3% Debt Service - - - - - - 0% Capital 21,052 - - - - 21,052 0% Transfers Out - - - - - - 0% Total Expenditures 149,425 4,077 4,077 3,970 - 145,348 3% Net 14,878 5,863 5,863 9,062 - 9,015 Cash Balance 138,929 104,457 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Operations under outside contract with CB Richard Ellis 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 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Month Janua Fund /Department Number 426 1 Date Updated 2/17/2014 Current Current 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,600,000 - - - - 1,600,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 371 371 1,979 - 14,629 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,615,000 371 371 1,979 - 1,614,629 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 189,077 2,452 2,452 1,193 184,126 2,499 99% Debt Service - - - - - - 0% Capital 3,914,427 166,772 166,772 231,858 47,654 3,700,001 5% Transfers Out - - - - - - 0% Total Expenditures 4,103,504 169,224 169,224 233,051 231,780 3,702,500 10% Net (2,488,504) (168,853) (168,853) (231,072) (231,780) (2,087,871) Cash Balance 3,063,559 3,628,030 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Major projects in 2013 were the continuation of: Memorial Campus Street Improvements; 400 Block N. Michigan Parking Lot; and Skyway Bridge /Building Improvements. Projects committed thus far in 2014: Completion of projects worked on in 2013 and 2 -Way Streets. Explain Significant Spending on Capital Projects Below: Projects committed thus far in 2014: Completion of projects worked on in 2013 and 2 -Way Streets. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Development Month Janua Fund /Department Number 429 1 Date Updated 2/17/2014 Current Current 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 349 349 1,138 - 6,651 5% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 827,000 349 349 1,138 - 826,651 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 26,117 617 617 8,320 5,500 20,000 23% Debt Service - - - - - - 0% Capital 2,330,000 - - - - 2,330,000 0% Transfers Out - - - - - - 0% Total Expenditures 2,356,117 617 617 8,320 5,500 2,350,000 0% Net (1,529,117) (268) (268) (7,182) (5,500) (1,523,349) Cash Balance 3,008,523 2,212,441 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Major projects in 2013 were: Demolition in relation to AEP Easement; Hill Street Improvements and 5 points utility study. Commitments thus far in 2014 are: 5 points utility improvement /move and infrastructure; and completion of Hill Street Improvements. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 Month Janua Fund /Department Number 430 1 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,500,000 - - - - 2,500,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 402 402 2,767 - 14,598 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 1,100,000 - - - - 1,100,000 0% Total Revenue 3,615,000 402 402 2,767 - 3,614,598 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 229,384 77,688 77,688 123,533 144,195 7,501 97% Debt Service - - - - - - 0% Capital 6,258,573 4,261 4,261 - 574,877 5,679,435 9% Transfers Out - - - - - - 0% Total Expenditures 6,487,957 81,949 81,949 123,533 719,072 5,686,936 12% Net (2,872,957) (81,547) (81,547) (120,766) (719,072) (2,072,338) Cash Balance 3,358,101 5,274,010 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from one year to the next so expenditure comparison will not yield reliable trend review. Major Projects for 2013 were: completion of the Fellows Street Corridor project; additional work on the Ireland Street project; and the final acquisition and engineering along with construction of the Main /Lafayette Crossover project. Projects committed thus far in 2014 are: completion of the Fellows Street Corridor Project; Ireland & Miami Area Improvements; Main /Lafayette Crossover Project and Walter Street Sidewalks. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #2 Month Janua Fund /Department Number 431 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This TIF fund is no longer used and should be closed. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Month Janua Fund /Department Number 432 Date Updated 2/17/2014 Current Current 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 762 762 2,855 - 14,238 5% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,000 762 762 2,855 - 14,238 5% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 656 656 656 - - - 100% Debt Service 493,495 353,950 353,950 344,898 - 139,545 72% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 494,151 354,606 354,606 344,898 - 139,545 72% Net (479,151) (353,844) (353,844) (342,043) - (125,307) Cash Balance 6,614,843 5,225,585 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to pay off 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 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Month Janua Fund /Department Number 435 1 Date Updated 2/17/2014 Current Current 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 23 23 83 - 727 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 320,750 23 23 83 - 320,727 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,360 160 160 - 4,200 - 100% Debt Service 190,463 - - - - 190,463 0% Capital 155,000 - - - - 155,000 0% Transfers Out - - - - - - 0% Total Expenditures 349,823 160 160 - 4,200 345,463 1% Net (29,073) (137) (137) 83 (4,200) (24,736) Cash Balance 294,463 161,008 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Douglas Road TIF was established to develop the road and area near Brown Mackie College near the South Bend - Mishawaka border. The fund borrowed money from the City of Mishawaka ($1,086,550) and Major Moves Fund 412 ($1,000,000) to finance initial construction. The fund uses TIF tax revenue to repay the loans. At December 31, 2013, the amounts due Mishawaka and Major moves were $343,532 and $923,829, respectively. Explain Significant Spending on Capital Projects Below: Projects for 2014 include: the Douglas Road Turn Lane. Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Residential Month January Fund /Department Number 436 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,500,000 - - - - 2,500,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10,000 244 244 1,796 - 9,756 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,510,000 244 244 1,796 - 2,509,756 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,000 - - - - 2,000 0% Debt Service 3,321,228 1,464,500 1,464,500 1,371,000 - 1,856,728 44% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,323,228 1,464,500 1,464,500 1,371,000 - 1,858,728 44% Net (813,228) (1,464,256) (1,464,256) (1,369,204) - 651,028 Cash Balance 1,089,822 2,132,107 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TI projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Major projects for 2014 include a City .contribution to the 2nd Eddy Street Commons Ammendment. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Month Janua Fund /Department Number 433 Date Updated 2/17/2014 Current Current 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 16 - (3) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 3 3 16 - (3) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - 6,072 6,072 - - (6,072) 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - 6,072 6,072 - - (6,072) 0% Net - (6,069) (6,069) 16 - 6,069 Cash Balance 19,679 31,459 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund's sole expenditure is for general legal fees for DCI based on an engagement letter Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Month January Fund /Department Number 439 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 1,450,000 - - 1,446,074 - 1,450,000 0% Charges for Services - - - - - - 0% Interest Earnings 3,000 472 472 419 - 2,528 16% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,453,000 472 472 1,446,493 - 1,452,528 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 3,600,000 - - - - 3,600,000 0% Transfers Out - - - - - - 0% Total Expenditures 3,600,000 - - - - 3,600,000 0% Net (2,147,000) 472 472 1,446,493 - (2,147,472) Cash Balance 3,683,068 2,262,854 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The 1.45M in Revenue represents the final draw from the State. Capital funds are to be expended in Ignition Park and Innovation Park. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Month January Fund /Department Number 454 Date Updated 2/17/2014 Current Current 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 48 48 192 - 1,452 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 48 48 192 - 1,452 3% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 48 48 192 - 1,452 Cash Balance 376,420 375,274 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: No significant issues. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations Month Janua Fund /Department Number 619 Date Updated 2/17/2014 Current Current 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 71,571 71,571 83,555 - 1,625,308 4% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,696,879 71,571 71,571 83,555 - 1,625,308 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,661,128 47,557 47,557 49,154 - 1,613,571 3% Debt Service - - - - - - 0% Capital 10,578 - - - - 10,578 0% Transfers Out - - - - - - 0% Total Expenditures 1,671,706 47,557 47,557 49,154 - 1,624,149 3% Net 25,173 24,014 24,014 34,401 - 1,159 Cash Balance 121,450 101,335 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Bond was Paid off in early 2013, so debt service expense in 2014 will be much under 2013. Course operations under outside contract with Billy Casper Golf so all expenses except capital are shown under Services to show consistently with Parking Garages and Redevelopment Retail. Explain Significant Spending on Capital Projects Below: Equipment payments Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Central Development Month January Fund /Department Number 314 Date Updated 2/17/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is an old debt service fund for a bond which has been paid off and there is no longer any cash in it. Fund can be closed. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Month January Fund /Department Number 315 Date Updated 2/17/2014 Current Current 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 133 133 533 - 4,867 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 133 133 533 - 4,867 3% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 133 133 - - 4,867 3% Total Expenditures 5,000 133 133 - - 4,867 3% Net - - - 533 - - Cash Balance 1,038,904 1,039,437 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Month January Fund /Department Number 317 Date Updated 2/17/2014 Current Current 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,000 65 65 257 - 2,935 2% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 3,000 65 65 257 - 2,935 2% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 3,000 65 65 257 - 2,935 Cash Balance 503,537 502,005 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Debt service reserve fund. The fund is at the proper level per the bond financial advisor, Crowe Horwath. No additional transfers -in are needed. Any interest variations due to City policy on investments and increase in cash available to earn interest. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Blackthorn Golf Month January Fund /Department Number 319 Date Updated 2/17/2014 Current Current 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 - - - 167 - - 0% Total Expenditures - - - 167 - - 0% Net - - - (167) - - Cash Balance - 326,167 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Generally 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. Please note however: the corresponding bond was paid off in early 2013 so debt service reserve is released and no cash remains in the fund. This fund can now be closed. Explain Significant Spending on Capital Projects Below: Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Month January Fund /Department Number 328 Date Updated 2/17/2014 Current Current 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 223 223 890 - 5,777 4% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 223 223 890 - 5,777 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 223 223 - - 5,777 4% Total Expenditures 6,000 223 223 - - 5,777 4% Net - - - 890 - - Cash Balance 1,735,840 1,736,730 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 420). 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