The URL can be used to link to this page

Home My WebLink About05-2014 Departmental Financial ReportPeriod Ending: May 31, 2014 Issued By: Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents Mayor Pete Buttigieg 2 Narrative 3 Summaries 9 General Fund 22 Special Revenue Funds 55 Debt Service /Capital Project Funds 68 Enterprise Funds 94 Internal Service Funds 99 Trust Funds 102 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg 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 Jennifer Hockenhull City Finance Director Rahman Johnson Financial Specialist Senior Cecil Eastman Department Heads Fiscal Officers Narrative, May 2014 Description of Monthly Departmental Financial Report The City of South Bend has developed the attached Monthly Departmental Financial Report to provide current year financial information for each City fund, as well as individual departments within the General Fund, in a condensed format. Information is provided for revenue, expenditures, encumbrances, cash balances and staffing levels. Also included in this report are text boxes that allow departmental fiscal officers to provide an explanation of significant expenditure and staffing variances and spending on major capital projects. Departmental fiscal officers are asked to complete the monthly financial reports ( "blue sheets ") for their funds and General Fund departments no later than the 20th of the month following the reporting period. The staff of the Department of Administration & Finance then summarizes the information and publishes this consolidated report no later than 30 days after the end of the reporting period. The Monthly Departmental Financial Report supplements —but does not replace —other financial reports that the City prepares such as the Monthly Financial Report, Controller's Cash Report, the Department of Local Government Finance's Annual Financial Report (AFR), 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 May 31, 2014, total revenue was $71,542,790, 25% of estimated revenue. As of May, 2013 total revenue received was $76,064,967 within the same funds. Excluding inter -fund transfers, YTD revenue is $4.0 million less than at May 31, 2013, caused primarily by the one -time receipts of $2.0 million from Bosch in April 2013, a $1.4 million Certified Technology Park distribution in January 2013, and Neighborhood Stabilization Program Grants totaling $1.1 million by May 2013. As of May 31, 2014, total expenditures were $109,617,863 and outstanding encumbrances were $26,782,624, a total of $136,400,487 which represents 36% of the amended expenditure budget. Encumbrances are either holdovers from previous years or obligations for the remainder of the year. If encumbrances were excluded, expenditures were 29% of the amended expenditure budget at the end of the period, which is lower than expectations after four months. Total expenditures were $109,101,534 as of May 31, 2013, the main difference being an increase in personnel costs by $1.9 million which was somewhat offset by less spending year -to -date on building demolitions, a result of the longer winter weather this year. 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 May 31, 2014 55,453,616 1,216,832 5,469,720 10,212,198 49,983,896 10% Special Revenue 102 Rainy Day 52,000 1,474 14,558 14,689 37,442 28% 201 Parks & Recreation 10,980,407 287,111 953,395 1,381,773 10,027,012 9% 202 Motor Vehicle Highway 9,106,300 927,707 3,854,860 4,353,791 5,251,440 42% 203 Recreation Nonreverting 1,449,592 50,145 408,968 470,173 1,040,624 28% 209 Studebaker - Oliver Reverting Grants 305,000 185 1,830 1,847 303,170 1% 210 Economic Development State Grants 77,016 57 18,627 164,451 58,389 24% 211 Community & Economic Development Admn. 2,278,246 11,562 979,995 1,055,456 1,298,251 43% 212 Community & Economic Development 3,811,000 363,187 835,390 1,780,310 2,975,610 22% 216 Police State Seizures 35,900 12,751 23,800 9,187 12,100 66% 217 Gift, Donation, Bequest 7,290 16 21,255 1,568 - 13,965 292% 218 Police Curfew Violations 1,025 2 158 157 867 15% 220 Law Enforcement Continuing Education 211,000 8,915 86,980 86,760 124,020 41% 227 Loss Recovery 17,000 1,316 13,311 13,727 3,690 78% 244 Emergency Phone System 215,000 0 215,000 0 0 100% 249 Public Safety LOIT 6,391,029 531,932 2,661,555 2,680,756 3,729,474 42% 251 Local Roads & Streets 1,088,000 91,165 486,952 456,206 601,048 45% 252 Excess Welfare Distribution 0 0 2 2 -2 0% 258 Human Rights Federal Grant 210,700 5,145 23,638 16,959 187,062 11% 271 Eastrace Waterway 100 2 24 24 76 24% 273 Morris PAC / Palais Royale Marketing 8,100 932 5,198 3,865 2,902 64% 280 Police Block Grants 0 1 6 7 -6 0% 281 Economic Develop. Commission - Revenue Bonds 0 5 46 46 -46 0% 289 HAZMAT 10,000 3 27 16,732 9,973 0% 291 Indiana River Rescue 45,200 10,619 31,168 38,332 14,032 69% 292 Police Grants 0 0 66,717 0 - 66,717 0% 294 Regional Police Academy 22,000 14 18,035 19,682 3,965 82% 295 COPS MORE Grant 41,600 710 4,341 5,149 37,259 10% 299 Police Federal Drug Enforcement 77,000 14,935 20,568 62,118 56,432 27% 404 County Option Income Tax 9,270,187 765,546 3,844,331 3,504,433 5,425,856 41% 408 Economic Development Income Tax 9,346,481 734,798 4,049,390 3,848,595 5,297,091 43% 410 Urban Development Action Grant 110 5 47 2,792 63 43% 655 Project Releaf 431,700 36,554 183,039 180,781 248,661 42% 705 Police K -9 Unit 2,000 1 1,003 4 997 50% Special Revenue Total 55,490,983 3,856,795 18,824,212 20,170,374 36,666,771 34% City Debt Service 313 Football Hall of Fame Debt Service 1,268,116 7,140 35,699 35,465 1,232,417 3% City Debt Service Total 1,268,116 7,140 35,699 35,465 1,232,417 3% Capital Project 288 Emergency Medical Services Capital Improv. 2,661,000 223,442 1,174,224 1,247,418 1,486,776 44% 377 Professional Sports Development 678,228 106 215,859 340,346 462,369 32% 401 Coveleski Stadium Capital 500 5 45 46 455 9% 403 Zoo Endowment 2,900 8 83 84 2,817 3% 405 Park Nonreverting Capital 195,700 5,448 14,157 10,352 181,543 7% 406 Cumulative Capital Development 568,516 3,998 20,611 25,433 547,905 4% 407 Cumulative Capital Improvement 434,150 0 84 85 434,066 0% 412 Major Moves Construction 581,798 1,220 239,742 250,877 342,056 41% 416 Morris Performing Arts Center Capital 101,500 8,632 46,898 60,275 54,602 46% 434 Community Revitalization Enhancement District 651,000 24 129 299 650,871 0% 450 Palais Royale Historic Preservation 16,125 154 2,877 4,204 13,248 18% 677 Football Hall of Fame Capital 2,500 108 1,097 1,227 1,403 44% Capital Project Total 5,893,917 243,146 1,715,806 1,940,645 4,178,111 29% Enterprise 600 Consolidated Building Fund 3,812,560 104,701 1,624,708 399,480 2,187,852 43% 601 Parking Garages 1,040,400 68,758 466,977 405,020 573,423 45% 610 Solid Waste Operations 5,257,701 434,883 2,143,766 2,029,375 3,113,935 41% 611 Solid Waste Capital 736,202 94,513 450,036 514,414 286,166 61% City of South Bend Monthly Department Financial Report REVENUE SUMMARY May 31, 2014 -,Mq ff�- Fund 911111 Control Type Dept Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Percent Budget Balance of Budget Fu Enterpi 620 Water Works Operations 14,711,333 1,108,537 5,530,295 5,482,942 9,181,038 38% 622 Water Works Capital 10,000 603 5,961 7,080 4,039 60% 623 Water Works Bond Capital 5,000 70 1,213 9,555 3,787 24% 624 Water Works Customer Deposit 6,000 250 2,462 2,375 3,538 41% 625 Water Works Sinking 2,057,224 170,927 854,797 855,091 1,202,427 42% 626 Water Works Bond Reserve 90,073 8,833 45,444 129,239 44,629 50% 629 Water Works Reserve Operations & Maintenance 70,312 356 56,985 48,730 13,327 81% 640 Sewer Repair Insurance 549,200 48,868 242,137 229,479 307,063 44% 641 Sewage Works Operations 34,553,188 2,857,702 13,614,054 12,786,189 20,939,134 39% 642 Sewage Works Capital 3,566,580 1,036 4,008,612 14,647 - 442,032 112% 643 Sewage Works Reserve Operations & Maint. 238,715 585 135,691 205,657 103,024 57% 645 2006 Sewer Bond 0 0 0 0 0 0% 647 Sewer Bond 2007 0 0 2 32 -2 0% 649 Sewage Sinking 9,804,645 775,538 3,878,151 4,034,575 5,926,494 40% 651 2007B Sewer Bond 0 0 0 63 0 0% 653 Sewage Debt Service Reserve 0 0 0 14,096 0 0% 658 Sewer Bond 2010 0 0 4 185 -4 0% 659 Sewer Bond 2011 25,000 1,163 12,486 16,229 12,514 50% 661 Sewer Bond 2012 45,000 3,043 30,396 27,742 14,604 68% 663 Sewer Bond 2013 60,000 0 0 0 60,000 0% 664 2013A Cost of Issuance Fund 0 1 8 85,740 -8 0% 665 2014 Sewer Bond 21,000,000 0 0 0 21,000,000 0% 670 Century Center 4,564,898 162,563 1,370,811 1,230,219 3,194,087 30% 671 Century Center Capital 500 30 145 100,089 355 29% Enterprise Total 102,204,531 5,842,960 34,475,142 28,628,243 67,729,389 34% Internal Service 222 Central Services 7,847,374 544,739 3,262,043 3,196,325 4,585,331 42% 226 Liability Insurance 2,898,690 239,180 1,234,060 1,254,658 1,664,630 43% 278 Take Home Vehicle Police 123,160 9,484 52,550 53,132 70,610 43% 711 Self- Funded Employee Benefits 13,418,450 1,080,537 5,373,142 5,223,769 8,045,308 40% 713 Unemployment Compensation 236,898 8,572 43,080 135,247 193,818 18% Internal Service Total 24,524,572 1,882,512 9,964,875 9,863,131 14,559,697 41% Trust & Agency 701 Firefighters Pension 5,391,332 0 711 1,636 5,390,621 0% 702 Police Pension 6,310,000 0 1,632 4,256 6,308,368 0% 703 Police /Fire 1977 Pension 0 0 0 0 0 0% 730 City Cemetery 250 6 62 70 188 25% Trust & Agency Total 11,701,582 6 2,405 5,962 11,699,177 0% jCity Funds Total 256,537,3149,391 70,487,858 70,856,019 186,049,459 20 Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF Revenue - Airport 13,484,612 4,035 41,123 2,611,017 13,443,489 0% 420 Tax Incremental Financing (TIF) - Downtown 4,418,336 33,199 364,720 413,678 4,053,616 8% 422 TIF - West Washington 422,000 105 1,014 700 420,986 0% 425 Redevelopment Retail & Leighton Plaza 164,303 7,013 63,087 70,088 101,216 38% 426 TIF - Central Medical Service Area 1,615,000 445 5,091 6,302 1,609,909 0% 429 TIF - Northeast Development 827,000 514 5,045 3,776 821,955 1% 430 TIF - Southside Development #1 3,615,000 542 5,580 9,027 3,609,420 0% 435 TIF - Douglas Road 320,750 34 455 216 320,295 0% 436 TIF - Northeast Residential 2,510,000 118 2,146 4,834 2,507,854 0% Tax Increment Financing Total 27,377,001 46,005 488,261 3,119,638 26,888,740 2% Redevelopment 433 Redevelopment General 0 2 33 54 -33 0% 439 Certified Technology Park 1,453,000 630 6,221 1,449,181 1,446,779 0% 454 Airport Urban Enterprise Zone 1,500 64 636 642 864 42% 619 Blackthorn Operations 1,696,879 204,566 543,979 624,187 1,152,900 32% Redevelopment Total 3,151,379 205,262 550,869 2,074,064 2,600,510 17% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 177 1,754 1,776 3,246 35% City of South Bend Monthly Department Financial Report REVENUE SUMMARY May 31, 2014 Redeve Debt S 317 Coveleski Debt Service Reserve 3,000 86 851 858 2,149 28% 319 Blackthorn Redev Bond 0 0 0 464 0 0% 328 Redevelopment Bond - Palais Royale 6,000 297 2,931 2,967 3,069 49% 432 TIF - Southside Development #3 15,000 1,035 10,266 9,181 4,734 68% Debt Service Total 29,000 1,595 15,802 15,246 13,198 54% Redevelopment Commission Controlled Funds Total 30,557,380 27,054,932 5,208,948 29,502,448 3% Grand Total 287,094,697 13,302,253 71,542,790 76,064,967 215,551,907 25% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY May 31, 2014 City Funds General Fund 101 -0101 Mayor's Office 711,711 51,628 284,586 258,368 2,039 425,086 40% 101 -0104 311 Call Center 488,908 35,128 182,540 95,962 6,316 300,053 39% 101 -0201 City Clerk 394,608 25,501 133,489 134,169 19,210 241,909 39% 101 -0301 Common Council 472,598 24,570 126,168 175,271 0 346,430 27% 101 -0401 Administration & Finance 2,091,944 163,566 816,376 741,914 43,483 1,232,086 41% 101 -0404 Morris Performing Arts Center 1,063,527 71,819 412,894 393,317 49,614 601,018 43% 101 -0405 Palais Royale 523,710 32,903 179,539 161,769 32,508 311,664 40% 101 -0501 Legal Department 1,025,635 76,265 420,401 323,406 9,870 595,363 42% 101 -0600 Energy Office 2013 0 0 0 54,256 0 0 0% 101 -0602 Engineering 1,126,302 68,149 431,505 549,991 17,477 677,320 40% 101 -0607 Traffic & Lighting 2013 0 0 0 100,576 0 0 0% 101 -0801 Police Department 24,725,204 1,666,159 9,585,163 9,063,948 320,017 14,820,024 40% 101 -0802 Communications Center 2,236,486 149,202 804,080 833,995 0 1,432,406 36% 101 -0805 Police LOIT 2013 0 0 0 1,594,266 0 0 0% 101 -0901 Fire Department 21,049,415 1,601,475 8,608,657 8,275,951 317,551 12,123,207 42% 101 -0905 Fire LOIT 2013 0 0 0 1,137,477 0 0 0% 101 -1008 Human Rights 367,262 25,976 135,335 128,445 12,495 219,431 40% 101 -1201 Code 2013 5,225 0 851 633,768 2,772 1,602 69% 101 -1203 Code Hearing 2013 0 0 0 9,978 0 0 0% 101 -1204 Junk Vehicle 2013 0 0 0 27,466 0 0 0% 101 -1205 Unsafe Building 2013 0 0 0 13,052 0 0 0% 101 -1207 Animal Control 2013 2,254 0 300 233,453 1,547 407 82% General Fund Total 56,284,789 3,992,340 22,121,883 24,940,798 834,899 33,328,007 41% Special Revenue 102 Rainy Day 0 0 0 0 0 0 0% 201 Parks & Recreation 12,600,878 867,526 4,677,611 4,851,779 455,323 7,467,944 41% 202 Motor Vehicle Highway 9,708,648 500,811 3,570,097 2,712,121 494,617 5,643,934 42% 203 Recreation Nonreverting 1,479,064 74,464 304,312 287,909 125,473 1,049,279 29% 209 Studebaker - Oliver Reverting Grants 1,385,000 0 0 0 0 1,385,000 0% 210 Economic Development State Grants 117,886 0 18,003 84,636 0 99,883 15% 211 Community & Economic Development Admn. 2,404,884 169,920 923,706 920,841 25,420 1,455,758 39% 212 Community & Economic Development 6,910,783 311,285 872,400 2,068,373 2,715,004 3,323,379 52% 216 Police State Seizures 40,000 0 0 10,500 0 40,000 0% 217 Gift, Donation, Bequest 51,010 2,786 2,786 0 12,260 35,963 29% 218 Police Curfew Violations 1,000 0 0 0 0 1,000 0% 220 Law Enforcement Continuing Education 294,802 11,393 69,790 176,075 12,387 212,625 28% 227 Loss Recovery 5,615,805 47,647 343,392 26,913 1,068,567 4,203,847 25% 244 Emergency Phone System 215,000 17,040 96,032 0 0 118,968 45% 249 Public Safety LOIT 7,214,658 573,243 3,007,307 3,569,062 0 4,207,351 42% 251 Local Roads & Streets 1,124,520 0 43,282 302,925 412,857 668,381 41% 252 Excess Welfare Distribution 1,146 0 0 0 0 1,146 0% 258 Human Rights Federal Grant 224,001 18,099 69,860 67,771 13,777 140,363 37% 271 Eastrace Waterway 10,346 7,047 9,092 0 596 658 94% 273 Morris PAC / Palais Royale Marketing 8,100 705 7,767 4,049 4,396 -4,063 150% 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 220 0 10,000 0% 291 Indiana River Rescue 52,300 5,199 6,738 39,396 10,155 35,407 32% 292 Police Grants 228,060 0 138,059 0 0 90,001 61% 294 Regional Police Academy 23,750 6,380 11,011 11,045 0 12,739 46% 295 COPS MORE Grant 141,600 1,328 5,590 6,394 2,177 133,833 5% 299 Police Federal Drug Enforcement 151,499 8,657 45,076 99,342 27,917 78,506 48% 404 County Option Income Tax 11,165,785 420,072 3,809,028 4,633,520 542,039 6,814,719 39% 408 Economic Development Income Tax 10,289,984 119,643 4,827,549 3,736,358 861,664 4,600,771 55% 410 Urban Development Action Grant 0 0 0 0 0 0 0% 655 Project Releaf 430,114 2,823 49,650 274,662 0 380,464 12% 705 Police K -9 Unit 2,000 0 0 0 0 2,000 0% Special Revenue Total 71,902,623 3,166,067 22,908,139 23,883,890 6,784,628 42,209,856 41% City Debt Service 313 Football Hall of Fame Debt Service 1,268,116 0 634,500 633,500 0 633,616 50% City Debt Service Total 1,268,116 0 634,500 633,500 0 633,616 50% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY May 31, 2014 City Funds Capital Project 288 Emergency Medical Services Capital Improv. 5,402,215 306,774 2,339,965 1,604,557 644,400 2,417,850 55% 377 Professional Sports Development 865,746 0 483,673 488,348 0 382,073 56% 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 19,071 149,923 61,692 12,812 42,482 79% 406 Cumulative Capital Development 722,935 135,726 304,922 296,462 0 418,013 42% 407 Cumulative Capital Improvement 364,762 0 185,250 184,875 0 179,512 51% 412 Major Moves Construction 5,823,729 68,110 380,429 312,801 943,300 4,499,999 23% 416 Morris Performing Arts Center Capital 53,200 4,227 7,139 19,738 2,382 43,679 18% 434 Community Revitalization Enhancement District 650,950 0 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 3,521 41,253 21,796 8,908 138,406 27% Capital Project Total 14,290,861 537,429 3,913,529 3,027,243 1,611,802 8,765,530 39% Enterprise 600 Consolidated Building Fund 3,798,909 224,737 1,164,207 405,320 539,094 2,095,607 45% 601 Parking Garages 797,808 51,347 386,517 464,566 77,900 333,391 58% 610 Solid Waste Operations 5,439,463 495,263 2,495,641 2,445,554 588,258 2,355,564 57% 611 Solid Waste Capital 896,070 29,025 502,298 279,248 20,618 373,154 58% 620 Water Works Operations 14,842,004 1,348,816 5,911,245 5,230,418 370,229 8,560,530 42% 622 Water Works Capital 978,258 0 3,600 27,979 29,408 945,250 3% 623 Water Works Bond Capital 811,011 38,778 447,568 1,151,013 5,802 357,641 56% 624 Water Works Customer Deposit 6,000 250 2,462 2,415 0 3,538 41% 625 Water Works Sinking 2,057,224 116 747 1,476 0 2,056,477 0% 626 Water Works Bond Reserve 0 0 0 0 0 0 0% 629 Water Works Reserve Operations & Maintenance 8,500 356 3,478 3,429 0 5,022 41% 640 Sewer Repair Insurance 549,978 50,604 144,779 161,114 0 405,199 26% 641 Sewage Works Operations 35,556,194 2,330,754 15,720,067 12,117,488 1,989,793 17,846,334 50% 642 Sewage Works Capital 9,267,941 164,146 2,292,581 1,003,036 3,571,574 3,403,786 63% 643 Sewage Works Reserve Operations & Maint. 15,000 585 5,727 5,361 0 9,273 38% 647 Sewer Bond 2007 1,138 0 0 13,616 1,138 0 100% 649 Sewage Sinking 9,802,031 1,539,362 1,541,462 2,662,715 0 8,260,569 16% 653 Sewage Debt Service Reserve 0 0 0 2,438,087 0 0 0% 658 Sewer Bond 2010 0 0 0 75,275 0 0 0% 659 Sewer Bond 2011 13,598,486 418,754 1,781,261 1,509,752 4,693,903 7,123,321 48% 661 Sewer Bond 2012 18,868,570 0 507,016 262,234 325,668 18,035,886 4% 663 Sewer Bond 2013 19,100,000 0 0 0 0 19,100,000 0% 664 2013A Cost of Issuance Fund 0 0 0 35,750 0 0 0% 665 2014 Sewer Bond 500,000 0 0 0 0 500,000 0% 670 Century Center 4,564,898 560,565 1,905,192 1,100,571 0 2,659,706 42% 671 Century Center Capital 106,684 0 0 0 0 106,684 0% Enterprise Total 141,566,167 7,253,457 34,815,848 31,396,418 12,213,386 94,536,933 33% Internal Service 222 Central Services 8,036,532 556,636 3,120,895 3,323,801 1,838,387 3,077,250 62% 226 Liability Insurance 2,897,200 122,430 1,023,755 959,722 54,724 1,818,721 37% 278 Take Home Vehicle Police 80,580 0 0 0 0 80,580 0% 711 Self- Funded Employee Benefits 14,483,463 1,128,213 6,240,966 5,115,535 59,410 8,183,087 44% 713 Unemployment Compensation 227,974 18,283 70,057 33,844 0 157,917 31% Internal Service Total 25,725,749 1,825,562 10,455,672 9,432,902 1,952,520 13,317,556 48% Trust & Agency 701 Firefighters Pension 5,874,445 451,651 2,262,922 2,311,804 0 3,611,523 39% 702 Police Pension 7,221,941 530,324 2,916,283 2,714,572 0 4,305,658 40% 730 City Cemetery 20,595 0 0 0 10,595 10,000 51% Trust & Agency Total 13,116,981 981,975 5,179,205 5,026,376 10,595 7,927,181 40% City Funds Total 10016L.- 324,155,286 17,756,831 100,028,776 98,341,12 23,407,831 200,718,679 38% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF Revenue - Airport 27,286,693 433,245 2,953,257 5,226,639 1,300,998 23,032,438 16% 420 Tax Incremental Financing (TIF) - Downtown 5,829,261 42,310 1,763,976 1,655,422 299,673 3,765,612 35% 422 TIF - West Washington 657,534 0 319 108,386 8,300 648,915 1% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY May 31, 2014 Redevelop Tax Increm425 Redevelopment Retail & Leighton Plaza 149,425 15,045 53,791 35,339 0 95,634 36% 426 TIF- Central Medical Service Area 4,103,504 28,057 1,729,515 517,953 225,474 2,148,515 48% 429 TIF - Northeast Development 2,806,117 0 617 31,165 5,500 2,800,000 0% 430 TIF - Southside Development #1 6,487,957 15,925 302,866 492,878 1,530,648 4,654,443 28% 435 TIF - Douglas Road 399,823 0 95,391 95,488 4,200 300,232 25% 436 TIF- Northeast Residential 3,583,228 1,000 1,866,291 1,569,208 0 1,716,937 52% Tax Increment Financing Total 51,303,542 535,582 8,766,023 9,732,478 3,374,793 39,162,726 24% Redevelopment 433 Redevelopment General 20,000 0 15,703 854 0 4,297 79% 439 Certified Technology Park 3,600,000 0 0 0 0 3,600,000 0% 454 Airport Urban Enterprise Zone 0 0 0 0 0 0 0% 619 Blackthorn Operations 1,671,706 204,109 448,070 676,277 0 1,223,636 27% Redevelopment Total 5,291,706 204,109 463,773 677,131 0 4,827,933 9% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 177 1,754 1,776 0 3,246 35% 317 Coveleski Debt Service Reserve 0 0 0 0 0 0 0% 328 Redevelopment Bond - Palais Royale 6,000 297 2,931 2,967 0 3,069 49% 432 TIF - Southside Development #3 494,151 0 354,606 346,055 0 139,545 72% Debt Service Total 505,151 474 359,291 350,798 0 145,860 71% Redevelopment Commission Controlled Funds Total i 57,100,399 740,165& 9,589,087 � 3,374,793 44,136,519- Total 381,255,685 18,496,996 109,617,863 109,101,534 26,782,624 244,855,198 36% 8 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Month Ma Fund /Department Number 101 -0101 Date Updated 6/16/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 51,628 283,897 257,500 - 427,214 40% Local Income Taxes - - - - - - 0% Other Taxes - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - 440 833 - (440) 0% Other Income 600 - 249 35 - 351 42% Transfers In - - - - - - 0% Total Revenue 711,711 51,628 284,586 258,368 - 427,125 40% Expenditures Personnel 632,608 46,226 249,157 206,283 - 383,451 39% Supplies 19,889 1,769 9,487 20,015 164 10,238 49% Services 57,015 3,633 24,696 32,070 1,875 30,444 47% Debt Service 2,199 - 1,246 - - 953 57% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 711,711 51,628 284,586 258,368 2,039 425,086 40% Net - - - - (2,039) 2,039 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 10 2014 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center Month Ma Fund /Department Number 101 -0104 Date Updated 6/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 /Non -Dept Revenue 8,831 1,111 (25,398) 95,962 - 34,229 -288% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 480,077 34,017 207,938 - - 272,139 43% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 488,908 35,128 182,540 95,962 - 306,368 37% Expenditures Personnel 422,705 32,044 159,456 94,030 - 263,249 38% Supplies 24,771 418 12,396 1,275 1,593 10,782 56% Services 41,432 2,665 10,688 657 4,722 26,022 37% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 488,908 35,128 182,540 95,962 6,316 300,053 39% Net - - - - (6,316) 6,316 Cash Balance - - Staffing Full Time 6.50 6.50 6.50 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 7.50 7.50 7.50 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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 10 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Month Ma Fund /Department Number 101 -0201 Date Updated 6/16/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 25,501 133,489 134,169 - 261,119 34% 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 25,501 133,489 134,169 - 261,119 34% Expenditures Personnel 312,763 22,008 117,324 113,418 - 195,439 38% Supplies 8,062 334 1,815 1,759 583 5,664 30% Services 60,383 3,159 14,350 18,992 18,627 27,406 55% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 394,608 25,501 133,489 134,169 19,210 241,909 39% Net - - - - (19,210) 19,210 Cash Balance - - Staffing Full Time 5.00 5.00 5.00 Part -Time /Seasonal /Temporary - - - Total 5.00 5.00 5.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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 second 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 WA 2014 City of South Bend Monthly Financial Report Fund /Department Name Common Council Month Ma Fund /Department Number 101 -0301 Date Updated 6/16/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 24,543 126,046 171,410 - 338,252 27% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 8,300 27 122 3,861 - 8,178 1% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 472,598 24,570 126,168 175,271 - 346,430 27% Expenditures Personnel 297,929 15,601 84,065 76,107 - 213,864 28% Supplies 7,285 24 234 4,538 - 7,051 3% Services 149,884 8,945 41,869 88,337 - 108,015 28% Debt Service - - - - - - 0% Capital 17,500 - - 6,289 - 17,500 0% Transfers Out - - - - - - 0% Total Expenditures 472,598 24,570 126,168 175,271 - 346,430 27% 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. 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 WA 2014 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Month May Fund /Department Number 101 -0401 Date Updated 6/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 /Non -Dept Revenue 2,011,894 163,566 816,376 741,517 - 1,195,518 41% 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 - - 397 - 80,050 0% Transfers In - - - - - - 0% Total Revenue 2,091,944 163,566 816,376 741,914 - 1,275,568 39% Expenditures Personnel 1,869,551 135,557 688,201 610,724 - 1,181,350 37% Supplies 36,140 1,969 13,812 14,695 5,092 17,236 52% Services 182,753 26,040 113,077 116,495 36,462 33,214 82% Debt Service 3,500 - 1,286 - 1,928 286 92% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,091,944 163,566 816,376 741,914 43,483 1,232,086 41% Net - - - - (43,483) 43,483 Cash Balance - - Staffing Full Time 23.00 22.00 22.00 Part -Time /Seasonal /Temporary 2.00 6.00 6.00 Total 25.00 28.00 28.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Added 3.2 positions in 2014. Additionally, January was a 3- paycheck month. New Benefits Manager, Help Desk and Database Administrator positions were approved in the 2014 budget. The Database Administrator position remains unfilled. A new Deputy City Controller began in April, 2014. Additional training costs are being incurred during 2014 for new and existing staff members. Other Income includes $80,000 in P -Card commssions; as of 11 June 2014 the program has yet to begin. Current estimates are for approx. $20,000 to be received this year. Admin & Finance has 5 interns during this summer: 2 in Human Resources, 2 in Information Technology, and 1 in Finance. Explain Significant Spending on Capital Projects Below: None Form 3 13 Form 3 14 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Month May Fund /Department Number 101 -0404 Date Updated 6/9/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 18,217 45,750 (16,321) - 135,777 25% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 876,000 52,715 363,104 407,459 - 512,896 41% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 888 4,040 2,180 - 1,960 67% Transfers In - - - - - - 0% Total Revenue 1,063,527 71,819 412,894 393,317 - 650,633 39% Expenditures Personnel 711,096 52,771 282,439 269,283 2,849 425,808 40% Supplies 32,657 1,880 8,674 9,135 10,033 13,950 57% Services 319,774 17,168 121,782 114,899 36,732 161,260 50% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,063,527 71,819 412,894 393,317 49,614 601,018 43% Net - - - - (49,614) 49,614 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: Fund 416 is used to support renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons at the Morris Performing Arts Center. Not all of the expenses are Capital expenses. Explain Significant Spending on Capital Projects Below: Form 3 14 Form 3 r�.7 2014 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Month Ma Fund /Department Number 101 -0405 Date Updated 6/9/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 (8,199) 86,244 67,123 - 94,978 40% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 291,981 40,123 88,951 83,682 - 203,030 30% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 18,000 979 4,344 10,964 - 13,656 24% Transfers In - - - - - - 0% Total Revenue 523,710 32,903 179,539 161,769 - 311,664 34% Expenditures Personnel 251,265 17,934 96,178 85,928 1,071 154,016 39% Supplies 31,629 373 2,795 7,321 4,230 24,604 22% Services 225,816 14,596 80,565 68,521 27,207 118,044 48% Debt Service - - - - - - 0% Capital 15,000 - - - - 15,000 0% Transfers Out - - - - - - 0% Total Expenditures 523,710 32,903 179,539 161,769 32,508 311,664 40% Net - - - - (32,508) - 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 r�.7 Form 3 iV, 2014 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Month Ma Fund /Department Number 101 -0501 Date Updated 6/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 /Non -Dept Revenue 953,285 76,251 418,779 322,511 - 534,506 44% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 - 1,581 614 - 419 79% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 70,350 14 42 281 - 70,309 0% Transfers In - - - - - - 0% Total Revenue 1,025,635 76,265 420,401 323,406 - 605,234 41% Expenditures Personnel 977,419 73,446 402,837 291,688 - 574,582 41% Supplies 5,083 173 3,288 2,816 1,912 (116) 102% Services 39,933 2,329 13,641 22,885 7,324 18,968 52% Debt Service 3,200 318 635 - 635 1,929 40% Capital - - - 6,016 - 0% Transfers Out - - - - - - 0% Total Expenditures 1,025,635 76,265 420,401 323,406 9,870 595,363 42% Net - - - - (9,870) 9,870 Cash Balance - - Staffing Full Time 9.00 9.00 9.00 Part -Time /Seasonal /Temporary - 3.00 3.00 Total 9.60 12.00 12.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Legal Department was fully staffed in April 2014. In April 2013 positions vacant included Corporation Counsel, Deputy City Attorney and Legal Secretary V. An error in one of the Supplies accounts was corrected in June; they are not actually over - budget. Explain Significant Spending on Capital Projects Below: Form 3 iV, Form 3 17 2014 City of South Bend Monthly Financial Report Fund /Department Name Engineering Month Ma Fund /Department Number 101 -0602 Date Updated 6/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 /Non -Dept Revenue 1,120,202 49,668 412,909 546,041 - 707,293 37% 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 18,481 18,596 3,950 - (12,496) 305% Transfers In - - - - - - 0% Total Revenue 1,126,302 68,149 431,505 549,991 - 694,797 38% Expenditures Personnel 610,675 43,975 230,998 274,654 - 379,677 38% Supplies 18,929 1,931 12,053 6,867 1,758 5,117 73% Services 488,306 22,242 185,251 268,471 12,450 290,605 40% Debt Service 8,392 - 3,202 - 3,269 1,921 77% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,126,302 68,149 431,505 549,991 17,477 677,320 40% Net - - - - (17,477) 17,477 Cash Balance - - Staffing Full Time 6.90 6.90 6.90 Part -Time /Seasonal /Temporary 1.81 10.00 10.00 Total 8.71 16.90 16.90 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Other income included $18,356 received in May as reimbursement for costs in state projects. Summer interns arrived this month. Explain Significant Spending on Capital Projects Below: Form 3 17 Form 3 18 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Department Month Ma Fund /Department Number 101 -0801 Date Updated 6/11/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 24,387,504 1,626,119 9,459,605 8,915,797 - 14,927,899 39% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - 24,316 24,316 - - (24,316) 0% Charges for Services 329,200 15,674 101,042 138,292 - 228,158 31% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 8,500 50 200 9,859 - 8,300 2% Transfers In - - - - - - 0% Total Revenue 24,725,204 1,666,159 9,585,163 9,063,948 - 15,140,041 39% Expenditures Personnel 20,430,704 1,457,044 8,047,090 7,902,879 - 12,383,614 39% Supplies 754,999 19,417 384,526 148,522 90,840 279,633 63% Services 3,219,191 189,513 1,071,498 968,549 229,177 1,918,516 40% Debt Service 15,152 185 16,891 15,602 - (1,739) 111% Capital 305,158 - 65,158 28,396 - 240,000 21% Transfers Out - - - - - - 0% Total Expenditures 24,725,204 1,666,159 9,585,163 9,063,948 320,017 14,820,024 40% Net - - - - (320,017) 320,017 Cash Balance - - Staffing Full Time 253.00 236.00 236.00 Part -Time /Seasonal /Temporary 57.00 28.00 28.00 Total 310.00 264.00 264.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund includes the expenditures for 213 of the 260 budgeted Police officers and 95 civilian staff. Fund 249 contains the funding for 47 of the 260 Police officers that are funded by the LOIT. The 2014 Personnel Expenditure exceeds the prior year amount due to the 2.5 % increase in Police salaries partially offset by resignations and retirements in 2014 compared to 2013. Personnel costs are not expected to exceed the 2014 annual budget. The Supplies, 63% 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: Capital expenditures budget for 2014 is the result of a 2013 encumberance to upgrade the video software for the interview room plus a budget transfer to provide for the conversion of police vehicles to compressed natural gas. The year to date capital expenditure was the cost of the video software for the interview room. Form 3 18 Form 3 19 2014 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Month Ma Fund /Department Number 101 -0802 Date Updated 6/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 /Non -Dept Revenue 2,236,486 149,202 804,080 833,995 - 1,432,406 36% 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 149,202 804,080 833,995 - 1,432,406 36% Expenditures Personnel 2,210,667 147,740 799,970 823,552 - 1,410,697 36% Supplies 4,029 - 60 1,186 - 3,969 1% Services 21,790 1,462 4,050 9,257 - 17,740 19% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,236,486 149,202 804,080 833,995 - 1,432,406 36% Net - - - - - - Cash Balance - - Staffing Full Time 35.00 35.00 35.00 Part -Time /Seasonal /Temporary - - - Total 35.00 35.00 35.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 approximate 2013 due to the 2% salary increase which is partially offset by the 2014 transfer of three supervisiors to Fund 244. Explain Significant Spending on Capital Projects Below: Form 3 19 2014 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Month Ma Fund /Department Number 101 -0901 Date Updated 6/13/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,433,415 1,554,024 8,379,493 7,464,060 11,053,922 43% Local Income Taxes - - - - - 0% Other Taxes - - - - - 0% Grants /Intergovernmental 155,000 - - - - 155,000 0% Charges for Services 455,000 47,451 228,705 273,877 - 226,295 50% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 - 459 38,014 - 5,541 8% Transfers In 1,000,000 - - 500,000 - 1,000,000 0% Total Revenue 21,049,415 1,601,475 8,608,657 8,275,951 - 12,440,758 41% Expenditures Personnel 18,806,414 1,437,725 7,772,516 7,539,523 133,244 10,900,654 42% Supplies 602,477 33,318 140,886 160,452 97,448 364,143 40% Services 1,640,524 130,432 695,255 575,976 86,859 858,410 48% Debt Service - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 21,049,415 1,601,475 8,608,657 8,275,951 317,551 12,123,207 42% Net - - - - (317,551) 317,551 Cash Balance - - Staffing Full Time 219.00 205.00 205.00 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 220.00 206.00 206.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The South Bend Fire Department is budgeted to have 251 sworn firefighters and 6 civilians. 38 firefighters are paid directly through the Public Safety LOIT leaving this account the balance of 219 firefighters. We had one firefighter separate during the month of May. We hold a lengthy recruitment process every 2 years and hire individuals in groups of 6 -10 as needed while that list is in effect. We also employ civilian administrative staff that handle payroll, purchasing and billing for our ambulance service. Explain Significant Spending on Capital Projects Below: The Fire Department uses EMS Capital Fund 288 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through that fund. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Form 3 20 Form 3 21 2014 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Month Ma Fund /Department Number 101 -1008 Date Updated 6/10/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 25,976 135,335 128,203 - 231,927 37% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 242 - - 0% Transfers In - - - - - - 0% Total Revenue 367,262 25,976 135,335 128,445 - 231,927 37% Expenditures Personnel 272,252 20,906 111,134 102,124 - 161,118 41% Supplies 2,394 225 818 1,341 16 1,561 35% Services 78,426 4,845 23,384 24,981 12,480 42,563 46% Debt Service - - - - - - 0% Capital 14,190 - - - - 14,190 0% Transfers Out - - - - - - 0% Total Expenditures 367,262 25,976 135,335 128,445 12,495 219,431 40% Net - - - - (12,495) 12,495 Cash Balance - - Staffing Full Time 4.00 4.00 4.00 Part -Time /Seasonal /Temporary - - - Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Expenditures are consistent with normal operations. Explain Significant Spending on Capital Projects Below: Form 3 21 Form 3 22 2014 City of South Bend Monthly Financial Report Fund /Department Name Rainy Day Month Ma Fund /Department Number 102 Date Updated 6/10/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,474 14,558 14,689 - 37,442 28% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 52,000 1,474 14,558 14,689 - 37,442 28% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 52,000 1,474 14,558 14,689 - 37,442 Cash Balance 8,632,263 8,602,869 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 resulting in South Bend's good AA bond rating with Standard & Poor's. Explain Significant Spending on Capital Projects Below: N/A Form 3 22 2014 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation Month Ma Fund /Department Number 201 1 Date Updated 6/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 7,430,898 - - - - 7,430,898 0% Local Income Taxes - - - 0% Other Taxes 596,878 - - - - 596,878 0% Grants /Intergovernmental 729,437 60,782 303,912 290,004 - 425,525 42% Charges for Services 2,208,344 226,092 644,176 1,083,497 - 1,564,168 29% Interest Earnings 13,000 237 4,346 6,796 - 8,654 33% Bond Proceeds - - 0% Donations - - - 0% Other Income 1,850 - 961 1,476 - 889 52% Transfers In - - - 0% Total Revenue 10,980,407 287,111 953,395 1,381,773 - 10,027,012 9% Expenditures Personnel 7,641,942 499,456 2,712,211 2,953,449 4,142 4,925,589 36% Supplies 1,616,319 137,489 541,101 772,534 303,765 771,454 52% Services 2,750,772 184,999 1,302,524 880,995 147,417 1,300,831 53% Debt Service 313,345 45,583 116,775 94,682 - 196,570 37% Capital 93,000 5,000 150,120 88,000 5% Transfers Out 185,500 - - - - 185,500 0% Total Expenditures 12,600,878 867,526 4,677,611 4,851,779 455,323 7,467,944 41% Net (1,620,471) (580,415) (3,724,217) (3,470,006) (455,323) 2,559,069 Cash Balance 538,568 1,494,735 Staffing Full Time 111.00 92.00 92.00 Part -Time /Seasonal /Temporary 73.00 52.40 25.90 Total 184.00 144.40 117.90 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund 201 accounts for the annual operation of the Parks and Recreation Department. There are six divisions within the department, Administration, Maintenance, Golf, Recreation, Greenhouse, and Graffiti. For 2014, the Potawatomi Zoo 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 pay dates, which resulted in the higher personnel costs. Expenses related to the Zoo transition also contributed to the higher than normal expenses in personnel and services categories and lower cash balance. During February recreation program registrations and the early selling of golf passes helped increase revenues over January. March and April weather prevented the golf courses from opening as scheduled and limited playing opportunities. Ice Rink revenues were lower due to weather, also. Explain Significant Spending on Capital Projects Below: Because of decreasing property tax revenues, the only capital expense for 2014 consists of the purchase of three pickup trucks and two commercial riding mowers. Form 3 23 2014 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month Ma Fund /Department Number 202 Date Updated 6/13/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 882,914 2,210,245 1,835,752 3,423,173 39% Grants /Intergovernmental - - 0% Charges for Services 244,000 43,095 144,839 233,346 99,161 59% Interest Earnings 7,000 494 5,215 4,012 1,785 75% Bond Proceeds - - 0% Donations - - 0% Other Income 5,300 1,204 11,269 3,800 (5,969) 213% Transfers In 3,216,582 1,483,291 2,276,882 1,733,291 46% Total Revenue 9,106,300 927,707 3,854,860 4,353,791 - 5,251,440 42% Expenditures Personnel 3,995,824 258,516 1,668,737 1,480,490 2,327,087 42% Supplies 3,400,615 72,273 730,106 538,213 356,699 2,313,810 32% Services 1,557,564 117,170 909,929 640,426 137,918 509,717 67% Debt Service 408,395 52,851 127,295 52,992 281,100 31% Capital 346,250 134,030 212,220 39% Transfers Out - - 0% Total Expenditures 9,708,648 500,811 3,570,097 2,712,121 494,617 5,643,934 42% Net (602,348) 426,896 284,762 1,641,670 (494,617) (392,494) Cash Balance 3,965,073 3,913,522 Staffing Full Time 58.01 55.01 Part -Time /Seasonal /Temporary 7.14 5.22 Total 65.15 60.23 - 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 and unplanned contractor costs for snow removal during January and February due to extreme weather have pushed our budgets way over where they should be at this time of year. We have already spent 78% of our overtime budget, which has been scaled back to emergencies and Special Events only. We set up a new overtime account so that we can track Special Events overtime costs. A transfer /additional appropriation request will be done in July to cover these costs based on an estimated amount of 400 hours of overtime to cover special events through year end. That will take some of the burden off of the "regular" overtime account. As of May 31st, our vehicle maintenance budget is overdrawn by $147,528.29. We are combing through our Street Department budget to determine where transfers can be made and where expenses can be cut. This ear's planned paving projects will more than likely have to be scaled way back as we try to cover Explain Significant Spending on Capital Projects Below: Form 3 24 Form 3 25 2014 City of South Bend Monthly Financial Report Fund /Department Name Recreation Nonrevertin Month MAY Fund /Department Number 203 Date Updated 6/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 - - - - - - 0% Charges for Services 1,400,592 52,035 387,306 403,575 - 1,013,286 28% Interest Earnings 4,000 151 1,397 1,240 - 2,603 35% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 45,000 (2,041) 20,265 65,358 - 24,735 45% Transfers In - - - - - - 0% Total Revenue 1,449,592 50,145 408,968 470,173 - 1,040,624 28% Expenditures Personnel 613,627 29,541 153,146 141,966 - 460,481 25% Supplies 274,095 23,116 54,770 61,038 110,237 109,088 60% Services 492,342 21,806 96,397 84,905 15,236 380,710 23% Debt Service - - - - - - 0% Capital 99,000 - - - - 99,000 0% Transfers Out - - - - - - 0% Total Expenditures 1,479,064 74,464 304,312 287,909 125,473 1,049,279 29% Net (29,472) (24,319) 104,655 182,265 (125,473) (8,655) Cash Balance 882,904 855,000 Staffing Full Time 1.00 1.00 1.00 Part -Time /Seasonal /Temporary 25.70 8.78 8.60 Total 26.70 9.78 9.60 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund accounts for programs and events that are self funded through user fees. Registration for spring program, classes and softball leagues began in February. Explain Significant Spending on Capital Projects Below: Form 3 25 2014 City of South Bend Monthly Financial Report Fund /Department Name Studebaker - Oliver Reverting Grants Month May Fund /Department Number 209 Date Updated 6/12/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 185 1,830 1,847 - 3,170 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 300,000 - - - - 300,000 0% Transfers In - - - - - - 0% Total Revenue 305,000 185 1,830 1,847 - 303,170 1% 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) 185 1,830 1,847 - (1,081,830) Cash Balance 1,085,217 1,081,522 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: There is $300,000 budgeted in Revenue as an expected insurance payment in this fund. Explain Significant Spending on Capital Projects Below: Funds to be used for environmental clean up as needed. If not used this year, funds will be appropriated for use next year. Form 3 26 Form 3 27 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Month May Fund /Department Number 210 Date Updated 6/12/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 57 4,240 43,576 - 14,573 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 58,203 - 14,387 120,875 - 43,816 25% Transfers In - - - - - - 0% Total Revenue 77,016 57 18,627 164,451 - 58,389 24% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 117,886 - 18,003 84,636 - 99,883 15% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 117,886 - 18,003 84,636 - 99,883 15% Net (40,870) 57 624 79,815 - (41,494) Cash Balance 349,575 998,270 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 27 Form 3 28 2014 City of South Bend Monthly Financial Report Fund /Department Name Community Investment Administration Month Ma Fund /Department Number 211 Date Updated 6/12/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 - 10,680 70,914 - 376,107 3% Charges for Services - - - - - - 0% Interest Earnings 2,200 159 1,582 1,245 - 618 72% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 200,300 11,403 123,253 124,537 - 77,047 62% Transfers In 1,688,959 - 844,480 858,760 - 844,479 50% Total Revenue 2,278,246 11,562 979,995 1,055,456 - 1,298,251 43% Expenditures Personnel 2,069,556 149,273 809,649 762,410 - 1,259,907 39% Supplies 32,475 1,443 9,367 10,175 4,847 18,261 44% Services 302,853 19,204 104,690 143,536 20,573 177,590 41% Debt Service - - - - - - 0% Capital - - - 4,720 - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,404,884 169,920 923,706 920,841 25,420 1,455,758 39% Net (126,638) (158,358) 56,289 134,615 (25,420) (157,507) Cash Balance 963,602 718,451 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 28 Form 3 29 2014 City of South Bend Monthly Financial Report Fund /Department Name Department of Community Investment Month Ma Fund /Department Number 212 Date Updated 6/12/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 361,132 722,341 1,671,118 - 2,802,659 20% Charges for Services - - - - - - 0% Interest Earnings 2,000 20 886 1,055 - 1,114 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 284,000 2,035 112,163 108,137 - 171,837 39% Transfers In - - - - - - 0% Total Revenue 3,811,000 363,187 835,390 1,780,310 - 2,975,610 22% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 6,910,783 311,285 872,400 2,068,373 2,715,004 3,323,379 52% Transfers Out - - - - - - 0% Total Expenditures 6,910,783 311,285 872,400 2,068,373 2,715,004 3,323,379 52% Net (3,099,783) 51,902 (37,010) (288,063) (2,715,004) (347,769) Cash Balance 552,875 224,159 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund covers multiple federal grants. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on -going and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 29 Form 3 30 2014 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Month Ma Fund /Department Number 216 Date Updated 6/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 35,000 12,724 23,533 8,939 - 11,467 67% Charges for Services - - - 0% Interest Earnings 300 27 267 248 - 33 89% Bond Proceeds - - 0% Donations - - 0% Other Income 600 - 600 0% Transfers In - - 0% Total Revenue 35,900 12,751 23,800 9,187 - 12,100 66% Expenditures Personnel - - - - - - 0% Supplies - 0% Services 20,000 - - 500 20,000 0% Debt Service - 0% Capital 20,000 - - 10,000 - 20,000 0% Transfers Out - 0% Total Expenditures 40,000 - - 10,500 - 40,000 0% Net (4,100) 12,751 23,800 (1,313) - (27,900) Cash Balance 182,468 143,612 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Revenue stream is not a steady flow. It is dependent upon the processing and release of funds from the State for seized assets in drug activities. Expenditures are to be used to support the Police Departments effort to combat drug activity. Explain Significant Spending on Capital Projects Below: Form 3 30 Form 3 191 2014 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month Ma Fund /Department Number 217 Date Updated 6/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 - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 290 16 142 109 - 148 49% Bond Proceeds - - - - - - 0% Donations 7,000 - 21,113 1,459 - (14,113) 302% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 7,290 16 21,255 1,568 - (13,965) 292% Expenditures Personnel - - - - - - 0% Supplies 22,100 2,786 2,786 - 10,950 8,364 62% Services 28,910 - - - 1,310 27,600 5% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 51,010 2,786 2,786 - 12,260 35,963 29% Net (43,720) (2,770) 18,468 1,568 (12,260) (49,928) Cash Balance 93,203 64,801 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 191 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Month Ma Fund /Department Number 218 Date Updated 6/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 - - - - - - 0% Charges for Services 1,000 - 138 138 - 862 14% Interest Earnings 25 2 20 19 - 5 80% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,025 2 158 157 - 867 15% 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 2 158 157 Cash Balance 11,705 11,041 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 KYA Form 3 33 2014 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education Month Ma Fund /Department Number 220 Date Updated 6/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,964 - - 0% Charges for Services 180,000 8,352 73,801 77,336 - 106,199 41% Interest Earnings 3,000 169 1,672 1,807 - 1,328 56% Bond Proceeds - - 0% Donations 2,000 - 2,000 0% Other Income 26,000 394 11,507 653 - 14,493 44% Transfers In - - - - - - 0% Total Revenue 211,000 8,915 86,980 86,760 - 124,020 41% Expenditures Personnel - - - - - - 0% Supplies 40,855 - 12,233 27,278 12,387 16,235 60% Services 190,000 11,393 43,610 25,678 - 146,390 23% Debt Service - - - 0% Capital 63,947 - 13,947 123,119 - 50,000 22% Transfers Out - 0% Total Expenditures 294,802 11,393 69,790 176,075 12,387 212,625 28% Net (83,802) (2,478) 17,190 (89,315) (12,387) (88,605) Cash Balance 998,414 997,889 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established for the continuing education and supplies for police and is funded by fees from accident reports, gun permits, false alarm and loud noise fines. Other income includes the receipt of funds from the US Marshal Service for rent of SBPD facility. The increase in Services expenditures over 2013 is due to the planned increase in officer training courses. The 2014 Capital purchase was the license renewal for forensic software. The $100,000 of Capital expended in 2013 was a portion of the purchase of the Police SWAT vehicle. Explain Significant Spending on Capital Projects Below: Form 3 33 Form 3 34 2014 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Month Ma Fund /Department Number 227 Date Updated 6/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 - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 17,000 1,316 13,311 7,418 - 3,690 78% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 6,309 - - 0% Transfers In - - - - - - 0% Total Revenue 17,000 1,316 13,311 13,727 - 3,690 78% Expenditures Personnel - - - - - - 0% Supplies 200,000 - - - 200,000 0% Services 3,315,805 40,205 195,665 26,913 1,022,848 2,097,292 37% Debt Service - - - - - 0% Capital 2,100,000 7,442 147,727 - 45,719 1,906,555 9% Transfers Out - - - - - 0% Total Expenditures 5,615,805 47,647 343,392 26,913 1,068,567 4,203,847 25% Net (5,598,805) (46,331) (330,081) (13,186) (1,068,567) (4,200,157) Cash Balance 7,605,952 4,328,376 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The largest portion of the $685K encumbrance for Services is to Trucks R Us for hauling contaminated refuse from the Organic Resources site. (The material has small pieces of plastic in it from being hauled in plastic bags, rendering it useless as organic compost.) Explain Significant Spending on Capital Projects Below: $15,000 has been encumbered for the Western Ave Corridor Smart Streets initiative to pay for the City Voice application, used to collect citizens' suggestions. Form 3 34 Form 3 1917 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month May Fund /Department Number 244 Date Updated 6/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 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 - - - 100% Expenditures Personnel 215,000 17,040 96,032 - - 118,968 45% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 215,000 17,040 96,032 - - 118,968 45% Net - (17,040) 118,968 - - (118,968) Cash Balance 118,968 - Staffing Full Time 3.00 3.00 3.00 Part -Time /Seasonal /Temporary - - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up per requirement by the State Board Of Accounts (SBOA) to cover the cost of 911 Police Communication personnel costs covered by a State Grant. Personnel expenditures exceed budget due to the fact that the supervisiors have experienced high level of overtime due to lower than budget staffing levels of the Communication Specialists (the savings in staff labor costs are reflected in the Communications budget in Fund 101 -802.) Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 1917 Form 3 1918, 2014 City of South Bend Monthly Financial Report Fund /Department Name Public Safety WIT Month Ma Fund /Department Number 249 Date Updated 6/16/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 2,658,346 2,455,161 - 3,721,684 42% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 11,000 263 3,210 3,855 - 7,790 29% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 221,741 - - 0% Total Revenue 6,391,029 531,932 2,661,555 2,680,756 - 3,729,474 42% Expenditures Personnel 7,214,658 573,243 3,007,307 - - 4,207,351 42% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 3,569,062 - - 0% Total Expenditures 7,214,658 573,243 3,007,307 3,569,062 - 4,207,351 42% Net (823,629) (41,311) (345,752) (888,306) - (477,877) Cash Balance 1,686,442 2,101,634 Staffing Full Time - 85.00 85.00 Part -Time /Seasonal /Temporary - - - Total - 85.00 85.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Prior to 2014, monies in Fund 249 were transferred quarterly to the General Fund to fund police and fire personnel. A quarterly reconciliaton was prepared and any unspent money was transferred back to Fund 249. For 2014, the City has been advised by the DLGF and SBOA that it should budget personnel costs directly from Fund 249. In 2014 the Fund includes the salary and benefit costs for 47 police officers and 38 firefighters. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 1918, Form 3 37 2014 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month Ma Fund /Department Number 251 Date Updated 6/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 1,080,000 90,780 449,626 453,114 - 630,374 42% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 8,000 385 3,524 3,092 - 4,476 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 33,801 - - (33,801) 0% Transfers In - - - - - - 0% Total Revenue 1,088,000 91,165 486,952 456,206 - 601,048 45% Expenditures Personnel - - - - - - 0% Supplies 352,663 - - - 350,000 2,663 99% Services 7,500 - - 7,500 - 7,500 0% Debt Service - - - - - - 0% Capital 764,357 - 43,282 295,425 62,857 658,218 14% Transfers Out - - - - - - 0% Total Expenditures 1,124,520 - 43,282 302,925 412,857 668,381 41% Net (36,520) 91,165 443,669 153,281 (412,857) (67,332) Cash Balance 2,385,044 1,867,579 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Supplies are always street paving materials to be used throughout the year. $33,801 received in April as project reimbursement for Edison & Gordon. Explain Significant Spending on Capital Projects Below: 2014 Budget: Boland Multi -Use Path: $250,000 New traffic devices: $167,000 Other projects: $325,000 Form 3 37 Form 3 38 2014 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Month Ma Fund /Department Number 252 Date Updated 6/10/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 2 2 - (2) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 0 2 2 - (2) 0% Expenditures Personnel - - - - - - 0% Supplies 1,146 - - - - 1,146 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,146 - - - - 1,146 0% Net (1,146) 0 2 2 - (1,148) Cash Balance 1,152 1,148 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 38 Form 3 39 2014 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant Month Ma Fund /Department Number 258 Date Updated 6/10/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 5,000 5,000 2,600 - 182,000 3% Charges for Services - - - - - - 0% Interest Earnings 2,000 75 758 810 - 1,242 38% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 21,700 70 17,880 13,550 - 3,820 82% Transfers In - - - - - - 0% Total Revenue 210,700 5,145 23,638 16,959 - 187,062 11% Expenditures Personnel 112,901 8,538 46,294 45,283 - 66,607 41% Supplies 4,550 163 293 1,111 1,470 2,787 39% Services 105,050 9,398 23,274 21,377 12,308 69,469 34% Debt Service - - - - - - 0% Capital 1,500 - - - - 1,500 0% Transfers Out - - - - - - 0% Total Expenditures 224,001 18,099 69,860 67,771 13,777 140,363 37% Net (13,301) (12,954) (46,222) (50,812) (13,777) 46,698 Cash Balance 421,322 435,352 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. Revenue and Expenditures are consistent with normal operating costs. Explain Significant Spending on Capital Projects Below: A drop down projector and large screen TV has been budgeted in capital for the conference room in the new Human Rights building. Form 3 39 Form 3 40 2014 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Month MAY Fund /Department Number 271 Date Updated 6/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 - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 100 2 24 24 - 76 24% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 100 2 24 24 - 76 24% Expenditures Personnel - - - - - - 0% Supplies 10,346 7,047 9,092 - 596 658 94% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,346 7,047 9,092 - 596 658 94% Net (10,246) (7,044) (9,068) 24 (596) (582) Cash Balance 5,305 14,348 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In past years there have been no races. Explain Significant Spending on Capital Projects Below: Form 3 40 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month May Fund /Department Number 273 Date Updated 5/9/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 928 5,153 3,818 - 2,847 64% Interest Earnings 100 4 45 47 - 55 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 8,100 932 5,198 3,865 - 2,902 64% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 8,100 705 7,767 4,049 4,396 (4,063) 150% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 8,100 705 7,767 4,049 4,396 (4,063) 150% Net - 228 (2,570) (183) (4,396) 6,966 Cash Balance 25,416 28,580 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Morris Performing Arts Center and Palais Royale Marketing Fund was established as a separate non - reverting fund to receive monies from solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marqee sponsorships; and to accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale. The funds in this account at the end of the fiscal year shall not revert to the general fund. A Budget Transfer / Appropriation to cover for encumbrances is in process. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund Form 3 41 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Month Ma Fund /Department Number 280 Date Updated 6/16/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 6 7 - (6) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 6 7 - (6) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 6 7 - (6) Cash Balance 3,823 3,810 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 42 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Month Ma Fund /Department Number 281 Date Updated 6/12/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 46 46 - (46) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 5 46 46 - (46) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 5 46 46 - (46) Cash Balance 27,174 27,081 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 43 2014 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Month Ma Fund /Department Number 289 Date Updated 6/13/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 10,000 - - 16,722 - 10,000 0% Interest Earnings - 3 27 10 - (27) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 3 27 16,732 - 9,973 0% Expenditures Personnel - - - - - - 0% Supplies 10,000 - - - 10,000 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - 220 - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,000 - - 220 - 10,000 0% Net - 3 27 16,512 - (27) Cash Balance 16,234 19,195 Staffing Full Time - - Part-Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Charges for Service for HAZ -MAT responses. By ordinance the South Bend Fire Department charges businesses for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund, responses are made by firefighters of the South Bend Fire Department. Explain Significant Spending on Capital Projects Below: No major capital expenditures are planned through this fund. Major purchases are funded through the Fire Department and EMS Capital and the minimal fees collected in this fund are used to replace equipment and gear used in responses. Form 3 44 Form 3 45 2014 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue Month Ma Fund /Department Number 291 Date Updated 6/13/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 10,600 31,000 38,140 - 14,000 69% Interest Earnings 200 19 168 192 - 32 84% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,200 10,619 31,168 38,332 - 14,032 69% Expenditures Personnel 2,500 - - - 2,500 0% Supplies 8,800 168 352 31,231 - 8,448 4% Services 41,000 5,031 6,386 8,165 10,155 24,459 40% Debt Service - - - - - - 0% Capital - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 52,300 5,199 6,738 39,396 10,155 35,407 32% Net (7,100) 5,420 24,430 (1,064) (10,155) (21,375) Cash Balance 120,146 118,358 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 the maintenance and repair of rescue equipment. Explain Significant Spending on Capital Projects Below: Form 3 45 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Month Ma Fund /Department Number 292 Date Updated 6/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 - 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) 0% Expenditures Personnel - - - - - - 0% Supplies - - 0% Services 138,060 - 138,059 - 1 100% Debt Service - - 0% Capital 90,000 - 90,000 0% Transfers Out - - - - - - 0% Total Expenditures 228,060 - 138,059 - - 90,001 61% Net (228,060) - (71,342) - - (156,718) Cash Balance 133,166 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, $13,753 is from a Federal grant to improve security at South Bend Schools. The South Bend Police Department is the Administrator of the grant. This funding plus cash recieved in December of 2013 will be disbursed to the South Bend School Corporation which spent the funds in accordance with the terms of the grant. The $138,059 Services expenditure is the reimbursement made to the South Bend School Corp for their expenditures under the Federal grant noted previously. Explain Significant Spending on Capital Projects Below: Form 3 46 2014 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Month May Fund /Department Number 294 Date Updated 6/16/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 - 17,900 19,545 - 2,100 90% Interest Earnings 2,000 14 135 137 - 1,865 7% Bond Proceeds - - 0% Donations - - 0% Other Income - - 0% Transfers In - - - - - - 0% Total Revenue 22,000 14 18,035 19,682 - 3,965 82% Expenditures Personnel - - - - - - 0% Supplies 1,750 - 1,750 0% Services 22,000 6,380 11,011 11,045 - 10,989 50% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 6,380 11,011 11,045 - 12,739 46% Net (1,750) (6,366) 7,024 8,637 - (8,774) Cash Balance 75,109 82,452 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 82% 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 47 Form 3 48 2014 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Month Ma Fund /Department Number 295 Date Updated 6/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 - - - 0% Charges for Services - - - 0% Interest Earnings 350 20 191 183 - 159 55% Bond Proceeds - - - - 0% Donations 3,250 - 3,250 0% Other Income 38,000 690 4,150 4,966 - 33,850 11% Transfers In - - - - - - 0% Total Revenue 41,600 710 4,341 5,149 - 37,259 10% Expenditures Personnel - - - - - - 0% Supplies 15,000 115 654 1,565 926 13,420 11% Services 16,000 1,213 4,936 4,829 1,251 9,813 39% Debt Service - - - 0% Capital 110,600 - - 110,600 0% Transfers Out - - - 0% Total Expenditures 141,600 1,328 5,590 6,394 2,177 133,833 5% Net (100,000) (618) (1,249) (1,245) (2,177) (96,574) Cash Balance 112,094 106,045 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds received from the grants along with impound towing fees. Explain Significant Spending on Capital Projects Below: Form 3 48 Form 3 49 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Month May Fund /Department Number 299 Date Updated 6/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 75,000 14,852 20,156 38,672 - 54,844 27% Charges for Services - - 0% Interest Earnings 1,000 83 412 428 - 588 41% Bond Proceeds - - 0% Donations - - 0% Other Income 1,000 23,018 - 1,000 0% Transfers In - - - - - - 0% Total Revenue 77,000 14,935 20,568 62,118 - 56,432 27% Expenditures Personnel - - - - - - 0% Supplies 41,499 7,622 19,842 23,867 13,716 7,941 81% Services 40,000 1,035 25,234 9,530 14,201 565 99% Debt Service - - 0% Capital 70,000 65,945 - 70,000 0% Transfers Out - - - - - - 0% Total Expenditures 151,499 8,657 45,076 99,342 27,917 78,506 48% Net (74,499) 6,278 (24,508) (37,224) (27,917) (22,074) Cash Balance 360,652 298,116 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. Other Revenue in 2013 reflects Federal Grant reimbursement for the purchase of a bomb suit. Explain Significant Spending on Capital Projects Below: The $62,706 expenditure in 2013, was a portion of the purchase of a Swat vehicle. Form 3 49 2014 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax Month May Fund /Department Number 404 Date Updated 6/10/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 3,602,421 3,269,558 - 5,043,390 42% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 75,000 2,481 24,475 25,460 - 50,525 33% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 549,376 42,580 217,434 209,416 - 331,942 40% Transfers In - - - - - - 0% Total Revenue 9,270,187 765,546 3,844,331 3,504,433 - 5,425,856 41% Expenditures Personnel - - - - - - 0% Supplies 1,294,540 95,831 513,451 521,176 25,897 755,192 42% Services 5,166,602 324,241 1,613,320 2,108,598 410,659 3,142,623 39% Debt Service 2,245,628 - 1,112,756 1,088,529 - 1,132,872 50% Capital 1,359,015 - 19,500 238,335 105,483 1,234,032 9% Transfers Out 1,100,000 - 550,000 676,882 - 550,000 50% Total Expenditures 11,165,785 420,072 3,809,028 4,633,520 542,039 6,814,719 39% Net (1,895,598) 345,474 35,303 (1,129,086) (542,039) (1,388,862) Cash Balance 14,959,654 14,197,916 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 December 31, 2014. The amount shown as Transfers Out of $1,100,000 is for the curb and sidewalk program. This is a significant increase (63 %) from last year as the program has been well received by the citizens of South Bend. The amount is transferred to the MVH fund 202. Explain Significant Spending on Capital Projects Below: This year, $297,500 has been budgeted for IT upgrades such as mobile 311 application and fiber enhancements to the County City building, Central Services and the Water Works Olive St. Station. The remaining balance of $89,015 is a prior encumbrance generated the Department of Community Investment for the Dollar Home Program. Form 3 50 Form 3 61 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax Month Ma Fund /Department Number 408 Date Updated 6/16/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 3,665,342 3,407,230 - 5,131,479 42% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 - 354,660 354,660 - 150,000 70% Interest Earnings 45,000 1,730 17,440 16,740 - 27,560 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 11,948 69,965 - (11,948) 0% Transfers In - - - - - - 0% Total Revenue 9,346,481 734,798 4,049,390 3,848,595 - 5,297,091 43% Expenditures Personnel 500,335 28,040 168,125 - - 332,210 34% Supplies - - - - - - 0% Services 2,609,285 91,603 1,056,873 1,010,098 861,664 690,748 74% Debt Service 1,043,263 - 521,500 517,500 - 521,763 50% Capital 275,000 - 150,000 - - 125,000 55% Transfers Out 5,862,101 - 2,931,051 2,208,760 - 2,931,051 50% Total Expenditures 10,289,984 119,643 4,827,549 3,736,358 861,664 4,600,771 55% Net (943,503) 615,155 (778,159) 112,237 (861,664) 696,320 Cash Balance 10,063,969 10,096,648 Staffing Full Time 9.00 6.00 6.00 Part -Time /Seasonal /Temporary 0.50 0.50 0.50 Total 9.50 6.50 6.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. $150,000 expenditure will be addressed in June. Form 3 61 Form 3 M 2014 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Month Ma Fund /Department Number 410 Date Updated 6/12/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 5 47 49 - 63 43% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 2,743 - - 0% Transfers In - - - - - - 0% Total Revenue 110 5 47 2,792 - 63 43% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 110 5 47 2,792 - 63 Cash Balance 27,634 26,545 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 Business Development Corporation are expected until 2015. Explain Significant Spending on Capital Projects Below: Form 3 M Form 3 53 2014 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Month Ma Fund /Department Number 655 Date Updated 6/13/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,376 181,376 179,299 - 247,624 42% Interest Earnings 2,700 179 1,664 1,482 - 1,036 62% Bond Proceeds - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 36,554 183,039 180,781 - 248,661 42% Expenditures Personnel 64,378 25 1,432 1,053 62,946 2% Supplies 8,369 2,798 9,662 347 (1,293) 115% Services 34,583 2,446 11,643 32,137 7% Debt Service 72,784 36,109 11,619 36,675 50% Capital - - 0% Transfers Out 250,000 250,000 250,000 0% Total Expenditures 430,114 2,823 49,650 274,662 - 380,464 12% Net 1,586 33,732 133,389 (93,881) - (131,803) Cash Balance 1,072,058 766,412 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 $250,000 transfer is to MVH to cover their costs in this process. Explain Significant Spending on Capital Projects Below: Form 3 53 Form 3 54 2014 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Month Ma Fund /Department Number 705 Date Updated 6/16/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 3 3 - 7 29% Bond Proceeds - - - - - - 0% Donations 1,990 - 1,000 - - 990 50% Other Income - - - 1 - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 1 1,003 4 - 997 50% 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 1,003 4 - (1,003) Cash Balance 2,316 1,934 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds. Explain Significant Spending on Capital Projects Below: Form 3 54 2014 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service Month Ma Fund /Department Number 313 Date Updated 6/12/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 - - 5,687 - 67,350 0% Grants /Intergovernmental 85,640 7,140 35,699 29,778 - 49,941 42% 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 35,699 35,465 - 1,232,417 3% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 1,268,116 - 634,500 633,500 - 633,616 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,268,116 - 634,500 633,500 - 633,616 50% Net - 7,140 (598,801) (598,035) - 598,801 Cash Balance 117,534 (20,662) 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. The February debt service payment has been made for 2014. 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 6101 Form 3 MR' 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Improv.7 I Month May Fund /Department Number 288 1 Date Updated 6/13/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 219,997 1,154,716 1,237,861 - 1,449,284 44% Interest Earnings 10,000 767 8,840 9,490 - 1,160 88% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 47,000 2,678 10,668 67 - 36,332 23% Transfers In - - - - - - 0% Total Revenue 2,661,000 223,442 1,174,224 1,247,418 - 1,486,776 44% Expenditures Personnel - - - - - - 0% Supplies 300,000 16,408 36,560 62,548 95,508 167,932 44% Services 416,952 55,421 148,755 204,786 33,180 235,017 44% Debt Service 351,106 - 20,333 20,333 - 330,773 1% Capital 3,334,157 234,945 2,134,317 816,890 515,712 684,128 265% Transfers Out 1,000,000 - 500,000 - 1,000,000 0% Total Expenditures 5,402,215 306,774 2,339,965 1,604,557 644,400 2,417,850 55% Net (2,741,215) (83,332) (1,165,741) (357,139) (644,400) (931,074) Cash Balance 4,411,340 5,188,014 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. Operated costs are incurred through the General Fund (101 -0901) and so a transfer of $1,000,000 is processed to cover those expenditures. Explain Significant Spending on Capital Projects Below: Continued construction of Fire Training Facility. Form 3 MR' 2014 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month May Fund /Department Number 377 Date Updated 6/12/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 - 180,139 297,215 - 419,861 30% Charges for Services - - - - - - 0% Interest Earnings 4,000 106 1,112 1,485 - 2,888 28% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 74,228 - 34,608 41,646 - 39,620 47% Transfers In - - - - - - 0% Total Revenue 678,228 106 215,859 340,346 - 462,369 32% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 765,746 - 383,673 388,348 - 382,073 50% Capital - - - - - - 0% Transfers Out 100,000 - 100,000 100,000 - - 100% Total Expenditures 865,746 - 483,673 488,348 - 382,073 56% Net (187,518) 106 (267,814) (148,002) - 80,296 Cash Balance 574,243 892,821 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 Coveleski stadium. 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 Coveleski stadium. Form 3 57 Form 3 58 2014 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month MAY Fund /Department Number 401 Date Updated 6/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 - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 5 45 46 - 455 9% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 5 45 46 - 455 9% 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) 5 45 46 - (3,085) Cash Balance 26,895 26,804 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 58 2014 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Month MAY Fund /Department Number 403 Date Updated 6/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 - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 200 8 83 84 - 117 41% Bond Proceeds - - - - - - 0% Donations 2,700 - - - - 2,700 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,900 8 83 84 - 2,817 3% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 2,900 8 83 84 - 2,817 Cash Balance 49,105 48,930 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to account for donations dedicated to Potawatomi Zoo. In the past few years several endowments that were funding this fund were liquidated resulting in a drop in revenues to this fund. Explain Significant Spending on Capital Projects Below: Form 3 59 2014 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Month MAY Fund /Department Number 405 Date Updated 6/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 - - - - - - 0% Charges for Services 3,000 709 1,276 1,291 - 1,724 43% Interest Earnings 2,200 68 737 756 - 1,463 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 4,671 12,144 8,305 - (12,144) 0% Transfers In 190,500 - - - - 190,500 0% Total Revenue 195,700 5,448 14,157 10,352 - 181,543 7% Expenditures Personnel - - - - - - 0% Supplies 23,417 19,071 42,504 49,225 4,077 (23,164) 199% Services 5,000 - 12,420 - 8,735 (16,155) 423% Debt Service - - - - - - 0% Capital 176,800 - 95,000 12,467 - 81,800 54% Transfers Out - - - - - - 0% Total Expenditures 205,217 19,071 149,923 61,692 12,812 42,482 79% Net (9,517) (13,623) (135,766) (51,340) (12,812) 139,061 Cash Balance 437,125 442,901 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This is a nonreverting capital fund that accounts for revenues collected and expenses for specific purposes or locations. These locations are Potawatomi and Rum Village Picnic Areas, the East Race, Golf Courses, Forestry, Howard Park Ice Rink, and, until 2014, Potawatomi Zoo. The cash balance includes $60,300 that is restricted to expenditures in Voorde Park. Explain Significant Spending on Capital Projects Below: This fund is for expending nonreverting revenue collected from the Zoo, golf courses, East Race Waterway, picnic sites and forestry revenue. Form 3 60 2014 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development Month May Fund /Department Number 406 1 Date Updated 6/16/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 19,455 23,797 - 67,839 22% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 3,500 107 1,157 1,424 - 2,343 33% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - 212 - - 0% Transfers In - - - - - - 0% Total Revenue 568,516 3,998 20,611 25,433 - 547,905 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 210 - - 0% Debt Service 722,935 135,726 304,922 296,252 - 418,013 42% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 722,935 135,726 304,922 296,462 - 418,013 42% Net (154,419) (131,727) (284,310) (271,029) - 129,891 Cash Balance 501,488 564,740 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 61 2014 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement Month May Fund /Department Number 407 Date Updated 6/16/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 - 84 85 - 66 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In - - - - - - 0% Total Revenue 434,150 - 84 85 - 434,066 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 364,762 - 185,250 184,875 - 179,512 51% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 364,762 - 185,250 184,875 - 179,512 51% Net 69,388 - (185,166) (184,790) - 254,554 Cash Balance (8,443) (87,070) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Revenue in this fund includes $150,000 in hotel /motel taxes and $258,990 in cigarette taxes from other units of government. The hotel /motel tax distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December. In 2014, this fund is used to pay 75% of the 2011 Century Center Refunding bonds as it was in 2013. Payments on the Century Center bond are due in February and July. Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year. Explain Significant Spending on Capital Projects Below: None Form 3 62 2014 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction Month May Fund /Department Number 412 Date Updated 6/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 - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 25,000 1,220 12,081 13,546 - 12,919 48% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 556,798 - 227,661 237,331 - 329,137 41% Transfers In - - - - - - 0% Total Revenue 581,798 1,220 239,742 250,877 - 342,056 41% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 5,823,729 68,110 380,429 312,801 943,300 4,499,999 23% Transfers Out - - - - - - 0% Total Expenditures 5,823,729 68,110 380,429 312,801 943,300 4,499,999 23% Net (5,241,931) (66,890) (140,688) (61,924) (943,300) (4,157,943) Cash Balance 7,003,210 7,834,772 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. $762,440 has been encumbered to begin design on the Olive - Sample St. overpass. Form 3 63 Form 3 64 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Month May Fund /Department Number 416 Date Updated 6/9/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 8,549 46,106 59,595 - 53,894 46% Interest Earnings 1,500 83 792 680 - 708 53% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 101,500 8,632 46,898 60,275 - 54,602 46% Expenditures Personnel - - - - - - 0% Supplies 14,700 2,462 5,374 1,243 - 9,326 37% Services 38,500 1,765 1,765 18,495 2,382 34,353 11% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 53,200 4,227 7,139 19,738 2,382 43,679 18% Net 48,300 4,405 39,759 40,537 (2,382) 10,923 Cash Balance 496,569 436,805 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 64 Form 3 65 2014 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Month Ma Fund /Department Number 434 Date Updated 6/12/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 24 129 299 - 871 13% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 651,000 24 129 299 - 650,871 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 650,950 - 20,975 36,975 - 629,975 3% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 650,950 - 20,975 36,975 - 629,975 3% Net 50 24 (20,846) (36,676) - 20,896 Cash Balance (11,309) 186,911 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 65 Form 3 66 2014 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Month Ma Fund /Department Number 450 Date Updated 6/9/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 145 2,784 4,103 - 13,216 17% Interest Earnings 125 10 94 101 - 31 75% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,125 154 2,877 4,204 - 13,248 18% 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 154 2,877 4,204 - 3,248 Cash Balance 56,273 62,509 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. No capital projects are planned for 2014. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund. Form 3 66 Form 3 67 2014 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Month May Fund /Department Number 677 Date Updated 6/12/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 108 1,097 1,227 - 1,403 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 108 1,097 1,227 - 1,403 44% Expenditures Personnel - - - - - - 0% Supplies 15,000 - 365 2,131 - 14,635 2% Services 173,567 3,521 40,888 19,665 8,908 123,771 29% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,567 3,521 41,253 21,796 8,908 138,406 27% Net (186,067) (3,413) (40,156) (20,569) (8,908) (137,003) Cash Balance 618,250 698,518 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 2014. Form 3 67 Form 3 68 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund Month Ma Fund /Department Number 600 Date Updated 6/13/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,000 104,450 466,289 398,042 - 1,036,711 31% Interest Earnings 1,000 84 638 349 - 362 64% Bond Proceeds - - - - - - 0% Donations - 140 3,462 - - (3,462) 0% Other Income 2,000 27 1,038 1,089 - 962 52% Transfers In 2,306,560 - 1,153,280 - - 1,153,280 50% Total Revenue 3,812,560 104,701 1,624,708 399,480 - 2,187,852 43% Expenditures Personnel 2,009,828 138,346 753,918 359,502 3,952 1,251,958 38% Supplies 198,015 8,247 55,123 10,953 12,760 130,132 34% Services 1,314,266 77,863 348,660 29,785 519,784 445,821 66% Debt Service 21,800 282 6,506 5,080 2,598 12,696 42% Capital 203,000 - - - - 203,000 0% Transfers Out 52,000 - - - - 52,000 0% Total Expenditures 3,798,909 224,737 1,164,207 405,320 539,094 2,095,607 45% Net 13,651 (120,036) 460,500 (5,840) (539,094) 92,245 Cash Balance 615,201 198,009 Staffing Full Time 30.00 27.00 28.00 Part -Time /Seasonal /Temporary - - - Total 30.00 27.00 28.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, unlike the Consolidated Building Department, are not enterprises by nature. Explain Significant Spending on Capital Projects Below: Capital includes 5 vehicles for Code Enforcement and 1 for the Building Department. Form 3 68 Form 3 69 2014 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages Month Ma Fund /Department Number 601 Date Updated 6/12/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 62,422 367,124 368,445 - 533,376 41% Interest Earnings 4,000 175 1,570 1,469 - 2,430 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 135,900 6,161 98,283 35,106 - 37,617 72% Transfers In - - - - - - 0% Total Revenue 1,040,400 68,758 466,977 405,020 - 573,423 45% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 663,179 51,347 318,537 322,178 17,000 327,642 51% Debt Service - - - - - - 0% Capital 134,629 - 67,980 142,388 60,900 5,749 96% Transfers Out - - - - - - 0% Total Expenditures 797,808 51,347 386,517 464,566 77,900 333,391 58% Net 242,592 17,411 80,460 (59,546) (77,900) 240,032 Cash Balance 964,647 795,899 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 69 Form 3 70 2014 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations Month Ma Fund /Department Number 610 Date Updated 6/10/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 434,797 2,044,680 2,014,016 - 2,771,150 42% Interest Earnings 6,000 86 1,053 1,741 - 4,947 18% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 435,871 - 98,033 13,617 - 337,838 22% Transfers In - - - - - - 0% Total Revenue 5,257,701 434,883 2,143,766 2,029,375 - 3,113,935 41% Expenditures Personnel 1,502,054 129,303 678,516 691,861 1,350 822,188 45% Supplies 324,095 30,717 188,894 101,288 2,476 132,725 59% Services 2,877,312 240,743 1,178,315 1,138,066 584,432 1,114,564 61% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 736,002 94,500 449,916 514,339 - 286,086 61% Total Expenditures 5,439,463 495,263 2,495,641 2,445,554 588,258 2,355,564 57% Net (181,762) (60,380) (351,874) (416,179) (588,258) 758,371 Cash Balance 436,597 767,784 Staffing Full Time 24.20 24.20 Part -Time /Seasonal /Temporary 8.00 6.00 Total 32.20 30.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. A much needed purchase of trash totes for distribution to City residents is the main reason operating supplies are running high year to date. Service costs are at 61 % of budget, due to higher than expected vehicle repair and maintenance costs, landfill tipping fees, and recycling services. Explain Significant Spending on Capital Projects Below: Form 3 70 2014 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Month Ma Fund /Department Number 611 Date Updated 6/13/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 13 120 76 - 80 60% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 736,002 94,500 449,916 514,339 286,086 61% Total Revenue 736,202 94,513 450,036 514,414 - 286,166 61% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 736,002 - 362,848 279,248 - 373,154 49% Capital 160,068 29,025 139,450 - 20,618 - 100% Transfers Out - - - - - - 0% Total Expenditures 896,070 29,025 502,298 279,248 20,618 373,154 58% Net (159,868) 65,488 (52,262) 235,167 (20,618) (86,988) Cash Balance 66,179 235,275 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. Explain Significant Spending on Capital Projects Below: Year to date capital spending has been for retrofitting trash trucks with on -board RFID tag reader computer systems. Form 3 71 Form 3 72 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations Month Ma Fund /Department Number 620 Date Updated 6.6.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 1,106,294 5,460,811 5,429,636 - 9,128,442 37% Interest Earnings 9,000 545 5,461 2,661 - 3,539 61% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 93,580 974 57,336 44,475 - 36,244 61% Transfers In 19,500 723 6,687 6,170 - 12,813 34% Total Revenue 14,711,333 1,108,537 5,530,295 5,482,942 - 9,181,038 38% Expenditures Personnel 4,594,374 328,207 1,854,574 1,725,780 2,800 2,737,000 40% Supplies 1,624,686 365,731 630,575 358,853 159,787 834,324 49% Services 4,633,411 340,216 1,760,558 1,438,171 207,642 2,665,211 42% Debt Service 6,555 379 2,095 2,160 - 4,460 32% Capital - - - - - - 0% Transfers Out 3,982,978 314,283 1,663,443 1,705,455 - 2,319,535 42% Total Expenditures 14,842,004 1,348,816 5,911,245 5,230,418 370,229 8,560,530 42% Net (130,671) (240,279) (380,950) 252,524 (370,229) 620,508 Cash Balance 3,115,155 1,994,375 Staffing Full Time 70.20 67.20 Part -Time /Seasonal /Temporary 3.00 5.50 Total 73.20 72.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. Total year to date service revenue is .58% above 2013. The metered & fire protection revenue is actually 1.50 % greater than prior year and the miscellaneous service types are less. Supplies expenditures are more year to date due to the water meter demand for the meter exchange program. Encumbrances include numerous blanket /value orders issued in period 1. Surplus operating cash has not been transferred out to the Depreciation Fund and is contributing to the significant difference in the ending cash balance. A transfer will be initiated later in the year. Explain Significant Spending on Capital Projects Below: Form 3 72 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Month Ma Fund /Department Number 622 Date Updated 6.6.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 603 5,961 7,080 - 4,039 60% Bond Proceeds - - - - 0% Donations - - - 0% Other Income - - - 0% Transfers In - - - - 0% Total Revenue 10,000 603 5,961 7,080 - 4,039 60% Expenditures Personnel - - 0% Supplies - - 0% Services 3,600 - 3,600 11,650 - - 100% Debt Service - - - - - 0% Capital 974,658 - - 16,329 29,408 945,250 3% Transfers Out - - 0% Total Expenditures 978,258 - 3,600 27,979 29,408 945,250 3% Net (968,258) 603 2,361 (20,899) (29,408) (941,211) Cash Balance 3,534,087 4,124,418 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. The current encumbrance is engineering cost associated with the next phase of the North Station Roof Restoration Project which is expected to start up mid year. Explain Significant Spending on Capital Projects Below: Form 3 73 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Month May Fund /Department Number 623 Date Updated 6.6.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 70 1,213 9,555 3,787 24% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 70 1,213 9,555 - 3,787 24% Expenditures Personnel - - 0% Supplies 209,422 16,266 34,046 274,908 3,425 171,951 18% Services 74,076 (52,609) 42,103 - - 31,973 57% Debt Service - - - - - - 0% Capital 527,513 75,121 371,419 876,105 2,377 153,717 71% Transfers Out - - - - - 0% Total Expenditures 811,011 38,778 447,568 1,151,013 5,802 357,641 56% Net (806,011) (38,708) (446,355) (1,141,458) (5,802) (353,854) Cash Balance 366,275 4,661,378 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. Interest earnings year to date is minimal due to a lesser amount of cash on hand. A significant credit was processed for the Pinhook WTP Efficiency Improvement Project in the month of May. This project is 97.6% complete. Explain Significant Spending on Capital Projects Below: YTD Spending: Water Meters $17,780 Pinhook WT Efficiency Improv Project $429,788 Form 3 74 Form 3 75 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Month May Fund /Department Number 624 Date Updated 6.6.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 250 2,462 2,375 - 3,538 41% Bond Proceeds - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 250 2,462 2,375 - 3,538 41% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - 0% Transfers Out 6,000 250 2,462 2,415 - 3,538 41% Total Expenditures 6,000 250 2,462 2,415 - 3,538 41% Net - - - (40) - - Cash Balance 1,466,825 1,436,960 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to retain security deposits collected from customers when establishing new service. Upon termination of service, these deposits are released and credited against final bills. Explain Significant Spending on Capital Projects Below: Form 3 75 Form 3 76 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Month Ma Fund /Department Number 625 Date Updated 6.6.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 117 747 326 4,253 15% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income - - - - - 0% Transfers In 2,052,224 170,810 854,050 854,765 1,198,174 42% Total Revenue 2,057,224 170,927 854,797 855,091 - 1,202,427 42% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - 0% Debt Service 2,052,224 - - 1,150 2,052,224 0% Capital - - - - - 0% Transfers Out 5,000 116 747 326 4,253 15% Total Expenditures 2,057,224 116 747 1,476 - 2,056,477 0% Net - 170,811 854,050 853,615 - (854,050) Cash Balance 859,387 858,252 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. The source of monies for debt repayment are transfers from the water utility operating fund 620. Biannual installments are disbursed at the end of June and December. Explain Significant Spending on Capital Projects Below: N/A Form 3 76 Form 3 77 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Month May Fund /Department Number 626 Date Updated 6.6.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 269 2,624 2,253 2,876 48% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income - - - - 0% Transfers In 84,573 8,564 42,820 126,986 41,753 51% Total Revenue 90,073 8,833 45,444 129,239 - 44,629 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 90,073 8,833 45,444 129,239 - 44,629 Cash Balance 1,611,120 1,441,461 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to ensure compliance with certain debt service bond covenants. Balance in fund is determined by debt service financing arrangements at bond issuance. All reserve maximum requirement amounts will be fully satisfied by the end of October this year. Explain Significant Spending on Capital Projects Below: Form 3 77 Form 3 78 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Month May Fund /Department Number 629 Date Updated 6.6.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 356 3,478 3,429 - 5,022 41% Bond Proceeds - - - 0% Donations - - - 0% Other Income - - - 0% Transfers In 61,812 - 53,507 45,301 - 8,305 87% Total Revenue 70,312 356 56,985 48,730 - 13,327 81% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 356 3,478 3,429 5,022 41% Total Expenditures 8,500 356 3,478 3,429 - 5,022 41% Net 61,812 - 53,507 45,301 - 8,305 Cash Balance 2,085,039 2,031,532 Staffing Full Time - - Part-Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to hold cash reserves to serve as fiscal protection against the risk of revenue shortfalls, emergencies and other economic risks that may impact the Water Utility's ability to meet financial commitments. Additional monies were transferred in during the month of February to satisfy 100% of the 2014 requirement. Explain Significant Spending on Capital Projects Below: Form 3 78 Form 3 79 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Month Ma Fund /Department Number 640 Date Updated 6/13/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 48,620 239,766 227,465 - 308,234 44% Interest Earnings 1,200 248 2,372 2,014 - (1,172) 198% Bond Proceeds - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 549,200 48,868 242,137 229,479 - 307,063 44% Expenditures Personnel 177,387 13,325 63,579 46,649 113,808 36% Supplies 17,115 1,744 3,495 9,535 13,620 20% Services 327,041 21,317 63,488 90,713 263,553 19% Debt Service 28,435 14,218 14,218 14,218 14,217 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 549,978 50,604 144,779 161,114 - 405,199 26% Net (778) (1,736) 97,358 68,364 - (98,136) Cash Balance 1,460,187 1,229,708 Staffing Full Time 2.10 2.10 Part -Time /Seasonal /Temporary - - - Total 2.10 2.10 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Increase in salaries due to new allocation of portion of Sewer Manager and Sewer Concrete Job Leader salaries. Explain Significant Spending on Capital Projects Below: Form 3 79 Form 3 80 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations Month May Fund /Department Number 641 Date Updated 6/10/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,847,516 13,566,115 12,747,530 - 20,894,073 39% Interest Earnings 18,000 789 9,326 6,924 - 8,674 52% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,000 8,812 32,886 22,850 - 27,114 55% Transfers In 15,000 585 5,727 8,885 - 9,273 38% Total Revenue 34,553,188 2,857,702 13,614,054 12,786,189 - 20,939,134 39% Expenditures Personnel 6,776,379 496,326 2,859,339 2,660,842 400 3,916,641 42% Supplies 2,419,100 168,848 659,636 592,449 374,172 1,385,293 43% Services 12,452,029 859,091 4,032,044 4,485,047 1,615,222 6,804,763 45% Debt Service 359,746 31,571 164,490 133,270 - 195,256 46% Capital - - - - - - 0% Transfers Out 13,548,940 774,919 8,004,559 4,245,881 - 5,544,381 59% Total Expenditures 35,556,194 2,330,754 15,720,067 12,117,488 1,989,793 17,846,334 50% Net (1,003,006) 526,948 (2,106,013) 668,701 (1,989,793) 3,092,800 Cash Balance 5,052,748 4,957,327 Staffing Full Time 95.04 95.04 Part -Time /Seasonal /Temporary 7.00 7.00 Total 102.04 102.04 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Service revenue is running below budget estimates as the actual rate increase was below the estimated rate. Transfers out, although high at present, will fall in line with budget by year end. Explain Significant Spending on Capital Projects Below: Form 3 80 Form 3 I.1 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Month Ma Fund /Department Number 642 Date Updated 6/10/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 1,036 8,612 14,647 - 30,388 22% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 3,527,580 - 4,000,000 - - (472,420) 113% Total Revenue 3,566,580 1,036 4,008,612 14,647 - (442,032) 112% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 133,264 6,695 40,306 64,867 92,958 0 100% Debt Service - - - - - - 0% Capital 9,134,677 157,451 2,252,275 938,169 3,478,616 3,403,786 63% Transfers Out - - - - - - 0% Total Expenditures 9,267,941 164,146 2,292,581 1,003,036 3,571,574 3,403,786 63% Net (5,701,361) (163,109) 1,716,031 (988,389) (3,571,574) (3,845,818) Cash Balance 5,760,597 7,874,720 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used to purchase capital equipment and fund major renovations /restorations for the Wastewater and Sewer Departments. The primary source of income is from Sewage Works Operating Fund #641, which transfers funds here as needed. Projects budgeted this year include Sewer Relining and Manhole Rehab. work throughout the City, replacing the Eastgate area Lift Station, and rebuilding /replacing the dewatering presses at the Wastewater Plant. Explain Significant Spending on Capital Projects Below: Year to Date totals include WWTP Primary Clarifier rehab $1,141,724; Sewer Dept. tandem axle dump trucks $323,802, Jet Rodder /Vacuum machine $309,680; Manhole Rehab. work $79,365, Sewer lining work $235,834, CNG station upgrade $85,000. Form 3 I.1 Form 3 [:A 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Month May Fund /Department Number 643 Date Updated 6/10/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 585 5,727 5,361 - 9,273 38% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 223,715 - 129,964 200,296 - 93,751 58% Total Revenue 238,715 585 135,691 205,657 - 103,024 57% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 585 5,727 5,361 - 9,273 38% Total Expenditures 15,000 585 5,727 5,361 - 9,273 38% Net 223,715 - 129,964 200,296 - 93,751 Cash Balance 3,422,564 3,292,600 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The sole purpose of this fund is to hold the equivalent of two months of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. Any transfers to this fund are done to adjust the balance as needed to stay in compliance. Explain Significant Spending on Capital Projects Below: Form 3 [:A 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Month Ma Fund /Department Number 647 Date Updated 6/10/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 32 - (2) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - 2 32 - (2) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,138 - - 13,616 1,138 0 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,138 - - 13,616 1,138 0 100% Net (1,138) - 2 (13,583) (1,138) (3) Cash Balance 1,143 5,458 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 this year. Explain Significant Spending on Capital Projects Below: Form 3 83 Form 3 84 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Month Ma Fund /Department Number 649 Date Updated 6/10/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 619 3,556 3,086 - 3,444 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,797,645 774,919 3,874,595 4,031,489 - 5,923,050 40% Total Revenue 9,804,645 775,538 3,878,151 4,034,575 - 5,926,494 40% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,000 - - - - 3,000 0% Debt Service 9,799,031 1,539,362 1,541,462 2,662,715 - 8,257,569 16% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,802,031 1,539,362 1,541,462 2,662,715 - 8,260,569 16% Net 2,614 (763,824) 2,336,689 1,371,860 - (2,334,075) Cash Balance 3,119,496 2,207,905 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to pay all debt service obligations for Wastewater and Sewers (Sewage Works). Mandatory transfers in from Operating Fund 641 are done in specified amounts each month to satisfy bond covenants. Explain Significant Spending on Capital Projects Below: Form 3 84 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Month May Fund /Department Number 653 Date Updated 6/10/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 - - - 14,096 - - 0% Total Revenue - - - 14,096 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - 2,434,563 - - 0% Capital - - - - - - 0% Transfers Out - - - 3,524 - - 0% Total Expenditures - - - 2,438,087 - - 0% Net - - - (2,423,992) - - Cash Balance 7,286,828 7,286,825 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. Explain Significant Spending on Capital Projects Below: Form 3 1:1.7 Form 3 Mt 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Month Ma Fund /Department Number 658 Date Updated 6/10/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 - - 4 185 - (4) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - 4 185 - (4) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 75,275 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 75,275 - - 0% Net - - 4 (75,090) - (4) Cash Balance 2,219 37,113 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 this year. Explain Significant Spending on Capital Projects Below: Form 3 Mt 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 Month Ma Fund /Department Number 659 Date Updated 6/10/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,163 12,486 16,229 - 12,514 50% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 1,163 12,486 16,229 - 12,514 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 705,491 - 300 205,548 5,191 700,000 1% Debt Service - - - - - - 0% Capital 12,892,995 418,754 1,780,961 1,304,203 4,688,712 6,423,322 50% Transfers Out - - - - - - 0% Total Expenditures 13,598,486 418,754 1,781,261 1,509,752 4,693,903 7,123,321 48% Net (13,573,486) (417,591) (1,768,775) (1,493,522) (4,693,903) (7,110,808) Cash Balance 6,079,724 8,672,987 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 $248,000, St. Joseph River CSO Stabilization $171,000, and Wastewater Treatment Plant Digester Upgrade $2,194,108. Form 3 87 Form 3 88 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Month Ma Fund /Department Number 661 Date Updated 6/10/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 3,043 30,396 27,742 - 14,604 68% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,000 3,043 30,396 27,742 - 14,604 68% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,870,000 - - 104,981 - 4,870,000 0% Debt Service - - - - - - 0% Capital 13,998,570 - 507,016 157,253 325,668 13,165,886 6% Transfers Out - - - - - - 0% Total Expenditures 18,868,570 - 507,016 262,234 325,668 18,035,886 4% Net (18,823,570) 3,043 (476,620) (234,491) (325,668) (18,021,282) Cash Balance 17,822,407 23,012,396 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: Projects funded from this Bond include: East Bank Sewer Separation -Phase 4 $2.6 million, Diamond Ave. Sewer Separation -Phase 3, $2.6 million, and Prairie Avenue Sewer Separation $344,390. Form 3 88 Form 3 89 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2013 Month Ma Fund /Department Number 663 Date Updated 6/10/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 budget was set up in this fund in anticipation of the issuance of a Sewer Bond in 2013. However, a bond was not issued, therefore no activity is expected in this fund. Explain Significant Spending on Capital Projects Below: Form 3 89 2014 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund Month Ma Fund /Department Number 664 Date Updated 6/10/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 8 - - (8) 0% Bond Proceeds - - - 85,740 - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 8 85,740 - (8) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 35,750 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 35,750 - - 0% Net - 1 8 49,990 - (8) Cash Balance 4,475 49,990 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 1*10" 2014 City of South Bend Monthly Financial Report Fund /Department Name 2014 Sewer Bond Month May Fund /Department Number 665 Date Updated 6/10/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 this year. Explain Significant Spending on Capital Projects Below: Form 3 1*2 Form 3 MA 2014 City of South Bend Monthly Financial Report Fund /Department Name Century Center Month April Fund /Department Number 670 Date Updated 5/13/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,725 656,718 - 656,711 50% Grants /Intergovernmental - - - - - - 0% Charges for Services 3,236,462 157,897 683,201 527,332 - 2,553,261 21% Interest Earnings - - - 228 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 15,000 4,666 30,885 45,940 - (15,885) 206% Transfers In - - - - - - 0% Total Revenue 4,564,898 162,563 1,370,811 1,230,219 - 3,194,087 30% Expenditures Personnel 2,450,875 173,429 846,748 699,425 - 1,604,127 35% Supplies 476,400 76,895 186,738 (2,361) - 289,662 39% Services 1,222,594 (28,060) 533,405 403,507 - 689,189 44% Debt Service - - - - - - 0% Capital 415,029 338,301 338,301 - - 76,728 82% Transfers Out - - - - - - 0% Total Expenditures 4,564,898 560,565 1,905,192 1,100,571 - 2,659,706 42% Net - (398,002) (534,381) 129,648 - 534,381 Cash Balance 535,004 1,120,633 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. May: credit in Services was $140,050 reclassification to Capital. Explain Significant Spending on Capital Projects Below: Form 3 MA Form 3 1*IN 2014 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Month Ma Fund /Department Number 671 Date Updated 6/16/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 - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 30 145 89 - 355 29% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 30 145 100,089 - 355 29% Expenditures Personnel - - - - - - 0% Supplies 54,184 - - - - 54,184 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 52,500 - - - - 52,500 0% Transfers Out - - - - - - 0% Total Expenditures 106,684 - - - - 106,684 0% Net (106,184) 30 145 100,089 - (106,329) Cash Balance 1,757,843 1,374,967 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: A 2014 Budget amendment was approved by the Common Council on March 24, 2014 for smallware, kitchen improvements and repairs to the freight elevator. Form 3 1*IN Form 3 ME 2014 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month Ma Fund /Department Number 222 Date Updated 6/10/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 541,758 3,159,845 3,111,165 - 4,636,339 41% Interest Earnings 3,000 196 1,917 1,663 - 1,083 64% Bond Proceeds - - 0% Donations - - 0% Other Income 48,190 2,785 100,281 83,498 - (52,091) 208% Transfers In - - - - - - 0% Total Revenue 7,847,374 544,739 3,262,043 3,196,325 - 4,585,331 42% Expenditures Personnel 2,828,264 210,207 1,092,404 1,071,730 1,735,860 39% Supplies 177,649 33,869 43,723 104,112 62,041 71,884 60% Services 4,852,122 311,586 1,981,520 2,120,105 1,774,395 1,096,206 77% Debt Service 6,497 975 3,248 3,037 1,950 1,300 80% Capital 172,000 - 24,817 172,000 0% Transfers Out - - - - 0% Total Expenditures 8,036,532 556,636 3,120,895 3,323,801 1,838,387 3,077,250 62% Net (189,158) (11,898) 141,148 (127,476) (1,838,387) 1,508,081 Cash Balance 1,638,790 1,060,281 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 departments, along with several local county,state and federal agencies. On the Revenue side we received checks for $39,980 from Energizing Indiana. On the expense side, our dept services is at 80% because we encumbered the rental costs for the year. On the Services, monies were also encumbered for the utilities. The supply acct. goes up and down, depending on vehicle repairs. In May we had 1,253 repairs. Year to Date repairs are 7,087. We had two mechanics retire in the last month. Explain Significant Spending on Capital Projects Below: We amended our budget to add the following Capital Projects: Upgrade the Sample St Garage to meet the requirements for Compressed Natural Gas vehicle repairs. Purchase of two in- ground hoists for the Sample St Garage. The purchase of a vehicle diagnostic scanner tool. Radio tower inspection repairs throughout the City. Form 3 ME Form 3 1:17 2014 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance Month Ma Fund /Department Number 226 Date Updated 6/10/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 238,310 1,188,397 1,245,240 - 1,671,293 42% Interest Earnings 22,000 870 8,615 9,124 - 13,385 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 - 37,048 295 - (20,048) 218% Transfers In - - - - - - 0% Total Revenue 2,898,690 239,180 1,234,060 1,254,658 - 1,664,630 43% Expenditures Personnel 189,417 13,943 75,208 67,499 - 114,209 40% Supplies 21,143 1,202 6,911 4,888 - 14,232 33% Services 2,676,640 107,285 941,636 886,482 54,724 1,680,280 37% Debt Service - - - - - - 0% Capital 10,000 - - 853 - 10,000 0% Transfers Out - - - - - - 0% Total Expenditures 2,897,200 122,430 1,023,755 959,722 54,724 1,818,721 37% Net 1,490 116,750 210,305 294,937 (54,724) (154,091) Cash Balance 5,395,802 5,540,349 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 expect to finish the year within budget. Explain Significant Spending on Capital Projects Below: Form 3 1:17 Form 3 Mt 2014 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Month May Fund /Department Number 278 Date Updated 6/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 - - - - - - 0% Charges for Services 60,580 4,700 25,930 26,220 - 34,650 43% Interest Earnings 2,000 84 797 692 - 1,203 40% Bond Proceeds - - 0% Donations - - 0% Other Income 60,580 4,700 25,823 26,220 - 34,757 43% Transfers In - - - - - - 0% Total Revenue 123,160 9,484 52,550 53,132 - 70,610 43% 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 9,484 52,550 53,132 - (9,970) Cash Balance 505,502 444,938 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 Mt Form 3 MA 2014 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits Month Ma Fund /Department Number 711 Date Updated 6/10/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 1,079,706 5,352,316 5,000,500 - 8,032,834 40% Interest Earnings 32,000 831 9,727 12,771 - 22,273 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,300 - 11,099 210,498 - (9,799) 854% Transfers In - - - - - - 0% Total Revenue 13,418,450 1,080,537 5,373,142 5,223,769 - 8,045,308 40% Expenditures Personnel 4,326 - - - - 4,326 0% Supplies 17,875 1,283 25,756 3,529 1,442 (9,323) 152% Services 760,062 48,868 281,340 252,830 18,000 460,722 39% Insurance 13,701,200 1,078,062 5,933,870 4,859,176 39,968 7,727,362 44% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 14,483,463 1,128,213 6,240,966 5,115,535 59,410 8,183,087 44% Net (1,065,013) (47,676) (867,824) 108,234 (59,410) (137,780) Cash Balance 4,793,623 7,536,425 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund handles expenses relating to insurance and claims relating to employees: medical, dental, life, flex spending, etc. For the last several years expenses have significantly exceeded revenues (charges to City Departments and employees) so our cash balance has been eroding. We anticipate losing another $1 million this year; in fact, we've already lost over $800,000. This is not sustainable in the long -term and we need to address this situation. We are working with our insurance advisor about some options. Explain Significant Spending on Capital Projects Below: None Form 3 MA Form 3 14. 2014 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Month Ma Fund /Department Number 713 Date Updated 6/16/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 42,652 135,078 - 193,746 18% Interest Earnings 500 42 428 168 - 72 86% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 236,898 8,572 43,080 135,247 - 193,818 18% Expenditures Personnel 220,750 17,681 67,047 32,059 - 153,703 30% Supplies - - - - - - 0% Services 7,224 602 3,010 1,785 - 4,214 42% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 227,974 18,283 70,057 33,844 - 157,917 31% Net 8,924 (9,711) (26,977) 101,402 - 35,901 Cash Balance 233,053 173,968 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 14. Form 3 1*9 2014 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension Month Ma Fund /Department Number 701 Date Updated 6/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 5,386,832 - - - - 5,386,832 0% Charges for Services - - - - - - 0% Interest Earnings 4,500 - 711 1,636 - 3,789 16% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,391,332 - 711 1,636 - 5,390,621 0% Expenditures Personnel 5,869,495 451,651 2,262,670 2,311,296 - 3,606,825 39% Supplies 200 - - - - 200 0% Services 4,750 - 252 508 - 4,498 5% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,874,445 451,651 2,262,922 2,311,804 - 3,611,523 39% Net (483,113) (451,651) (2,262,211) (2,310,168) - 1,779,098 Cash Balance (1,324,111) (962,304) Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Fire Pension fund receives State of Indiana pension relief payments in June and September to reimburse the City for actual pension costs paid and reported in the previous year. For 2014, the payments are expected to be $2,564,549 by 1 July and again by 1 October, totaling $5,129,098. Explain Significant Spending on Capital Projects Below: No capital expenditures are purchased through this account. Form 3 1*9 Form 3 K1111 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Pension Month May Fund /Department Number 702 Date Updated 6/7/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 - 1,632 3,145 - 4,368 27% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,000 - - 1,111 - 4,000 0% Transfers In - - - - - - 0% Total Revenue 6,310,000 - 1,632 4,256 - 6,308,368 0% Expenditures Personnel 7,216,441 530,324 2,916,065 2,713,194 - 4,300,376 40% Supplies 1,100 - - 642 - 1,100 0% Services 4,400 - 218 736 - 4,182 5% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 7,221,941 530,324 2,916,283 2,714,572 - 4,305,658 40% Net (911,941) (530,324) (2,914,651) (2,710,316) - 2,002,710 Cash Balance (1,205,992) (401,690) Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Police Pension fund receives pension relief distributions from the State of Indiana to reimburse the City for pension costs paid and reported in the previous fiscal year. For 2014, the payments are expected to be $3,055,933 by 1 July and again by 1 October, totaling $6,111,865. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Form 3 K1111 2014 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Month MAY Fund /Department Number 730 Date Updated 6/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 - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 250 6 62 70 - 188 25% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 250 6 62 70 - 188 25% 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) 6 62 70 (10,595) (9,812) Cash Balance 36,996 41,182 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is designated for expenses specifically for the City Cemetery. Revenues were originally derived from the sale of cemetery plots and burial expenses.There are few sites available for sale and most plots are occupied, resulting in little burial activty. Explain Significant Spending on Capital Projects Below: Spending this year will concentrate on repairing headstones and completing the GIS survey of the cemetery and its occupants. Form 3 word 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF Revenue - Airport Month Ma Fund /Department Number 324 1 Date Updated 6/12/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 3,858 39,369 28,718 - 40,243 49% Bond Proceeds - - - - - - 0% Donations - - - 65,000 - - 0% Other Income - - - 2,239,559 - - 0% Transfers In 5,000 177 1,754 277,740 - 3,246 35% Total Revenue 13,484,612 4,035 41,123 2,611,017 - 13,443,489 0% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 6,086,697 260,458 1,515,647 859,251 1,256,393 3,314,657 46% Debt Service 3,561,981 128,750 1,391,721 1,461,802 - 2,170,260 39% Capital 17,638,015 44,037 45,889 2,905,586 44,605 17,547,521 1% Transfers Out - - - - - - 0% Total Expenditures 27,286,693 433,245 2,953,257 5,226,639 1,300,998 23,032,438 16% Net (13,802,081) (429,210) (2,912,134) (2,615,622) (1,300,998) (9,588,949) Cash Balance 22,107,996 15,605,750 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 2013 Revenue from one time payment from AJ Wright of $2 M received in April along with Blackthorn debt service paid off in 2013 and reserve amount returned to this fund. While one can find usefulness in reviewing revenue trends in TIF funds from one year to the next, because projects change wildly from one year to the next, it is less meaningful to examine year to date expenditures against the prior year to date. Major projects carried out in 2013 were: Ignition Park Infrastructure; Data Realty; the SB Animal Shelter reconstruction; continued acquisition in Ignition Park South and East; purchase of Scientific Equipment in Ignition Park; acquisition in the LaSalle Square Area; the Renaissance District Phase I and the beginnings of Phase II; the beginnings of expenditures on the Studebaker /Oliver Project; and Bosch holding costs. In 2014, the major projects thus far approved are: Continuation of projects approved for 2013; and the addition of the Kolata contract. Explain Significant Spending on Capital Projects Below: Capital projects thus far this year are: Renaissance District Phase II; major expenditures in the Certified Tech Park; the Studebaker /Oliver project; and continued Ignition Park South & East acquisitions. Form 3 102 Form 3 103 2014 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown Month Ma Fund /Department Number 420 1 Date Updated 6/12/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 - 200,000 198,500 - 201,000 50% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,000 3,175 15,128 12,568 - 18,872 44% Interest Earnings 49,645 3,311 19,111 29,699 - 30,534 38% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 277,691 26,416 127,550 169,944 - 150,141 46% Transfers In 6,000 297 2,931 2,967 - 3,069 49% Total Revenue 4,418,336 33,199 364,720 413,678 - 4,053,616 8% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 574,131 42,310 217,630 178,797 253,783 102,718 82% Debt Service 2,972,966 - 1,531,010 1,157,042 - 1,441,956 51% Capital 2,282,164 - 15,336 319,583 45,890 2,220,938 3% Transfers Out - - - - - - 0% Total Expenditures 5,829,261 42,310 1,763,976 1,655,422 299,673 3,765,612 35% Net (1,410,925) (9,111) (1,399,256) (1,241,744) (299,673) 288,004 Cash Balance 1,205,218 1,597,613 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF funds are used to fund projects which vary widely from year to year, so no real trend is expected from one year to the next. Explain Significant Spending on Capital Projects Below: Capital projectes committed to in 2014 include: Finishing Century Center West Entrance; Studebaker Plaza; Hill & Colfax Mixed Use Development; and Lasalle Hotel. Capital projects taken on in 2013 were:Century Center West Entrance; Studebaker Plaza; and Wayne Street Garage Facade improvements. Form 3 103 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Month May Fund /Department Number 422 1 Date Updated 6/12/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 105 1,014 700 - 986 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 422,000 105 1,014 700 - 420,986 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,319 - 319 1,678 - 10,000 3% Debt Service - - - - - - 0% Capital 647,215 - - 106,708 8,300 638,915 1% Transfers Out - - - - - - 0% Total Expenditures 657,534 - 319 108,386 8,300 648,915 1% Net (235,534) 105 695 (107,686) (8,300) (227,929) Cash Balance 613,657 344,043 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year so little can be gained by comparing expenditures from year to year. Major projects for 2013 were: Completion of Rushton Square and William Streetscape. Major Projects committed thus far in 2014 are: Completion of Rushton Square. Explain Significant Spending on Capital Projects Below: Major projects committed thus far in 2014 are: Completion of Rushton Square. Form 3 104 Form 3 KIM 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Month Ma Fund /Department Number 425 Date Updated 6/12/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 15 151 148 - 349 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 163,803 6,998 62,936 69,940 - 100,867 38% Transfers In - - - - - - 0% Total Revenue 164,303 7,013 63,087 70,088 - 101,216 38% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 128,373 6,777 39,438 35,339 - 88,935 31% Debt Service - - - - - - 0% Capital 21,052 8,268 14,353 - - 6,699 68% Transfers Out - - - - - - 0% Total Expenditures 149,425 15,045 53,791 35,339 - 95,634 36% Net 14,878 (8,032) 9,296 34,749 - 5,582 Cash Balance 142,363 130,143 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Operations under outside contract with Bradley Co. so all expenses except capital are shown under Services line, to show consistently with Parking Garages and Blackthorn Golf Course. Explain Significant Spending on Capital Projects Below: Form 3 KIM Form 3 `[IN 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Month Ma Fund /Department Number 426 1 Date Updated 6/12/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 445 5,091 6,302 - 9,909 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,615,000 445 5,091 6,302 - 1,609,909 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,721,310 9,000 1,543,685 20,316 175,126 2,499 100% Debt Service - - - - - - 0% Capital 2,382,194 19,057 185,830 497,637 50,348 2,146,016 10% Transfers Out - - - - - 0% Total Expenditures 4,103,504 28,057 1,729,515 517,953 225,474 2,148,515 48% Net (2,488,504) (27,612) (1,724,424) (511,651) (225,474) (538,606) Cash Balance 1,507,989 3,347,450 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Major projects in 2013 were the continuation of: Memorial Campus Street Improvements; 400 Block N. Michigan Parking Lot; and Skyway Bridge /Building Improvements. Projects committed thus far in 2014: Completion of projects worked on in 2013 and 2 -Way Streets. Explain Significant Spending on Capital Projects Below: Projects committed thus far in 2014: Completion of projects worked on in 2013 and 2 -Way Streets. Form 3 `[IN Form 3 107 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Development Month Ma Fund /Department Number 429 1 Date Updated 6/12/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 514 5,045 3,776 - 1,955 72% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 827,000 514 5,045 3,776 - 821,955 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 142,827 - 617 31,165 5,500 136,710 4% Debt Service - - - - - - 0% Capital 2,663,290 - - - - 2,663,290 0% Transfers Out - - - - - - 0% Total Expenditures 2,806,117 - 617 31,165 5,500 2,800,000 0% Net (1,979,117) 514 4,428 (27,389) (5,500) (1,978,045) Cash Balance 3,013,219 2,192,235 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Major projects in 2013 were: Demolition in relation to AEP Easement; Hill Street Improvements and 5 points utility study. Commitments thus far in 2014 are: 5 points utility improvement /move and infrastructure; and completion of Hill Street Improvements. The Capital budget was increased by $450,000 on 6 Mar 2014. Explain Significant Spending on Capital Projects Below: Form 3 107 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 Month Ma Fund /Department Number 430 1 Date Updated 6/12/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 542 5,580 9,027 - 9,420 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 1,100,000 - - - - 1,100,000 0% Total Revenue 3,615,000 542 5,580 9,027 - 3,609,420 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 249,784 13,024 124,097 244,106 114,266 11,421 95% Debt Service - - - - - - 0% Capital 6,238,173 2,901 178,769 248,772 1,416,382 4,643,022 26% Transfers Out - - - - - - 0% Total Expenditures 6,487,957 15,925 302,866 492,878 1,530,648 4,654,443 28% Net (2,872,957) (15,383) (297,286) (483,851) (1,530,648) (1,045,023) Cash Balance 3,142,362 4,910,925 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 `[IN Form 3 `[IR] 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Month Ma Fund /Department Number 432 Date Updated 6/12/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 1,035 10,266 9,181 - 4,734 68% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,000 1,035 10,266 9,181 - 4,734 68% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 656 - 656 1,157 - - 100% Debt Service 493,495 - 353,950 344,898 - 139,545 72% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 494,151 - 354,606 346,055 - 139,545 72% Net (479,151) 1,035 (344,340) (336,874) - (134,811) Cash Balance 6,624,347 5,791,847 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to payoff debt. We will not be requesting additional funds from the TIF. The first opportunity to pay off the bond will be February, 2017. The plan is to payoff the bond at that time along with the prepayment penalty. Explain Significant Spending on Capital Projects Below: Form 3 `[IR] 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Month Ma Fund /Department Number 435 1 Date Updated 6/12/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 34 455 216 - 295 61% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 320,750 34 455 216 - 320,295 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,360 - 160 257 4,200 - 100% Debt Service 190,463 - 95,231 95,231 - 95,232 50% Capital 205,000 - - - - 205,000 0% Transfers Out - - - - - - 0% Total Expenditures 399,823 - 95,391 95,488 4,200 300,232 25% Net (79,073) 34 (94,936) (95,272) (4,200) 20,063 Cash Balance 199,664 65,653 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 lull Form 3 In 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Residential Month May Fund /Department Number 436 Date Updated 6/12/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 118 2,146 4,834 - 7,854 21% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,510,000 118 2,146 4,834 - 2,507,854 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 6,346 - - 1,370 - 6,346 0% Debt Service 3,362,308 1,000 1,651,718 1,567,838 - 1,710,590 49% Capital 214,574 - 214,573 - - 1 100% Transfers Out - - - - - - 0% Total Expenditures 3,583,228 1,000 1,866,291 1,569,208 - 1,716,937 52% Net (1,073,228) (882) (1,864,145) (1,564,374) - 790,917 Cash Balance 689,934 1,936,938 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Major projects for 2014 include a City .contribution to the 2nd Eddy Street Commons Ammendment. The $214,573 Capital Expenditure was to Kite Realty Eddy St. Garage LLC and the budget was adjusted on 6 Mar 2014 to cover it. Explain Significant Spending on Capital Projects Below: Form 3 In Form 3 112 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Month Ma Fund /Department Number 433 Date Updated 6/12/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 33 54 - (33) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 2 33 54 - (33) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 20,000 - 15,703 854 - 4,297 79% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 20,000 - 15,703 854 - 4,297 79% Net (20,000) 2 (15,670) (800) - (4,330) Cash Balance 10,079 30,643 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 112 Form 3 113 2014 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Month May Fund /Department Number 439 Date Updated 6/12/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 630 6,221 3,107 - (3,221) 207% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,453,000 630 6,221 1,449,181 - 1,446,779 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) 630 6,221 1,449,181 Cash Balance 3,688,817 2,265,543 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 113 Form 3 114 2014 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Month May Fund /Department Number 454 Date Updated 6/12/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 64 636 642 - 864 42% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 64 636 642 - 864 42% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 64 636 642 - 864 Cash Balance 377,007 375,724 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 114 Form 3 r&7 2014 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations Month Ma Fund /Department Number 619 Date Updated 6/12/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 204,566 543,979 573,687 - 1,152,900 32% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 50,500 - - 0% Total Revenue 1,696,879 204,566 543,979 624,187 - 1,152,900 32% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,661,128 204,109 448,070 466,635 - 1,213,058 27% Debt Service - - - 207,879 - - 0% Capital 10,578 - - 1,763 - 10,578 0% Transfers Out - - - - - - 0% Total Expenditures 1,671,706 204,109 448,070 676,277 - 1,223,636 27% Net 25,173 457 95,909 (52,090) - (70,736) Cash Balance 193,496 206,019 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 r&7 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Month May Fund /Department Number 315 Date Updated 6/12/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 177 1,754 1,776 - 3,246 35% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 177 1,754 1,776 - 3,246 35% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 177 1,754 1,776 - 3,246 35% Total Expenditures 5,000 177 1,754 1,776 - 3,246 35% Net - - - - - - Cash Balance 1,038,904 1,038,904 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Explain Significant Spending on Capital Projects Below: Form 3 Mr.] 2014 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Month May Fund /Department Number 317 Date Updated 6/12/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 86 851 858 - 2,149 28% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 3,000 86 851 858 - 2,149 28% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 3,000 86 851 858 - 2,149 Cash Balance 504,323 502,606 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 117 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Month May Fund /Department Number 328 Date Updated 6/12/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 297 2,931 2,967 - 3,069 49% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 297 2,931 2,967 - 3,069 49% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 297 2,931 2,967 - 3,069 49% Total Expenditures 6,000 297 2,931 2,967 - 3,069 49% Net - - - - - - Cash Balance 1,735,840 1,735,840 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 M-1