The URL can be used to link to this page

Home My WebLink About06-2014 Departmental Financial ReportPeriod Ending: June 30, 2014 Issued By: Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents Mayor Pete Buttigieg 2 - 2 Narrative 3 - 8 Summaries 9-21 General Fund 22-54 Deputy City Controller Special Revenue Funds 55-67 Rahman Johnson Debt Service /Capital Project Funds 68-93 Enterprise Funds 94-98 Internal Service Funds 99-101 Trust Funds 102-118 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, June 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 June 30, 2014, total revenue was $131,731,032, 50% of estimated revenue. As of June, 2013 total revenue received was $135,978,144 within the same funds. The City received its first of two property tax payments from the state in June, totaling $38,991,282, that was more than half the budgeted annual amount of $67,992,000. As of June 30, 2014, total expenditures were $127,261,195 and outstanding encumbrances were $25,978,193, a total of $153,239,388 which represents 40% 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 33% of the amended expenditure budget at the end of the period, which is lower than expectations after six months. Total expenditures were $128,468,675 as of June 30, 2013. We hope that you find this Monthly Departmental Financial Report useful in understanding the finances of the City of South Bend a little bit better. If you have any questions regarding this report, please contact us at 574 - 235 -7702. City of South Bend Monthly Department Financial Report REVENUE SUMMARY June 30, 2014 City Funds General Fund 54,692,436 22,843,976 28,313,696 32,330,654 26,378,740 52% Special Revenue 102 Rainy Day 52,000 2,091 16,649 18,541 35,351 32% 201 Parks & Recreation 10,899,509 4,677,534 5,630,929 6,108,303 5,268,580 52% 202 Motor Vehicle Highway 9,106,300 611,250 4,466,110 4,967,637 4,640,190 49% 203 Recreation Nonreverting 1,449,592 103,711 512,679 586,599 936,913 35% 209 Studebaker - Oliver Reverting Grants 305,000 263 2,093 2,331 302,907 1 % 210 Economic Development State Grants 77,016 85 18,712 164,900 58,304 24% 211 Community & Economic Development Admn. 2,278,246 37,945 1,017,940 1,062,745 1,260,306 45% 212 Community & Economic Development 6,911,000 220,198 1,055,589 2,515,886 5,855,411 15% 216 Police State Seizures 35,900 40 23,841 9,250 12,059 66% 217 Gift, Donation, Bequest 7,290 23 21,278 11,407 - 13,988 292% 218 Police Curfew Violations 1,025 128 285 174 740 28% 220 Law Enforcement Continuing Education 211,000 18,632 105,611 97,312 105,389 50% 227 Loss Recovery 17,000 1,850 15,160 15,666 1,840 89% 244 Emergency Phone System 215,000 0 215,000 0 0 100% 249 Public Safety LOIT 6,391,029 532,054 3,193,609 3,511,505 3,197,420 50% 251 Local Roads & Streets 1,088,000 91,503 578,454 545,566 509,546 53% 252 Excess Welfare Distribution 0 0 2 2 -2 0% 258 Human Rights Federal Grant 210,700 148 23,786 45,007 186,914 11% 271 Eastrace Waterway 100 3 27 31 73 27% 273 Morris PAC / Palais Royale Marketing 8,100 1,118 6,316 3,878 1,784 78% 280 Police Block Grants 0 1 7 8 -7 0% 281 Economic Develop. Commission - Revenue Bonds 0 7 52 58 -52 0% 289 HAZMAT 10,000 4 31 16,741 9,969 0% 291 Indiana River Rescue 45,200 3,629 34,797 42,385 10,403 77% 292 Police Grants 0 0 66,717 0 - 66,717 0% 294 Regional Police Academy 22,000 19 18,054 19,718 3,946 82% 295 COPS MORE Grant 41,600 1,374 5,714 5,886 35,886 14% 299 Police Federal Drug Enforcement 77,000 4,338 24,906 70,923 52,094 32% 404 County Option Income Tax 9,270,187 767,505 4,611,836 4,221,802 4,658,351 50% 408 Economic Development Income Tax 9,346,481 735,405 4,784,794 4,534,483 4,561,687 51% 410 Urban Development Action Grant 110 7 53 3,102 57 48% 655 Project Releaf 431,700 36,709 219,748 217,342 211,952 51% 705 Police K -9 Unit 2,000 1 1,004 5 996 50% Special Revenue Total 58,510,085 7,847,572 26,671,783 28,799,195 31,838,302 46% City Debt Service 313 Football Hall of Fame Debt Service 649,990 301,607 337,306 763,218 312,684 52% City Debt Service Total 649,990 301,607 337,306 763,218 312,684 52% Capital Project 288 Emergency Medical Services Capital Improv. 2,661,000 305,054 1,479,279 1,455,849 1,181,721 56% 377 Professional Sports Development 678,228 121,664 337,523 340,728 340,705 50% 401 Coveleski Stadium Capital 500 7 52 58 448 10% 403 Zoo Endowment 2,900 12 95 105 2,805 3% 405 Park Nonreverting Capital 195,700 740 14,897 11,387 180,803 8% 406 Cumulative Capital Development 520,794 259,071 279,683 298,465 241,111 54% 407 Cumulative Capital Improvement 434,150 123,553 123,637 129,193 310,513 28% 412 Major Moves Construction 581,798 1,708 241,449 254,403 340,349 42% 416 Morris Performing Arts Center Capital 101,500 1,617 48,515 61,622 52,985 48% 434 Community Revitalization Enhancement District 651,000 25 154 342 650,846 0% 450 Palais Royale Historic Preservation 16,125 855 3,732 5,525 12,393 23% 677 Football Hall of Fame Capital 2,500 150 1,247 1,584 1,253 50% Capital Project Total 5,846,195 814,456 2,530,263 29559,262 3,315,932 43% Enterprise 600 Consolidated Building Fund 3,812,560 195,994 1,820,701 468,240 1,991,859 48% 601 Parking Garages 1,040,400 96,494 563,471 473,131 476,929 54% 610 Solid Waste Operations 5,257,701 428,158 2,571,924 2,440,735 2,685,777 49% 611 Solid Waste Capital 736,202 10 450,046 514,520 286,156 61% City of South Bend Monthly Department Financial Report REVENUE SUMMARY June 30, 2014 622 Water Works Capital 10,000 856 6,817 8,928 3,183 68% 623 Water Works Bond Capital 5,000 94 1,308 11,675 3,692 26% 624 Water Works Customer Deposit 6,000 355 2,817 3,017 3,183 47% 625 Water Works Sinking 2,057,224 171,008 1,025,804 1,026,411 1,031,420 50% 626 Water Works Bond Reserve 90,073 8,946 54,391 147,333 35,682 60% 629 Water Works Reserve Operations & Maintenance 70,312 505 57,490 49,640 12,822 82% 640 Sewer Repair Insurance 549,200 50,147 292,284 275,928 256,916 53% 641 Sewage Works Operations 34,553,188 2,844,415 16,458,469 15,490,370 18,094,719 48% 642 Sewage Works Capital 3,566,580 1,416 4,010,028 18,188 - 443,448 112% 643 Sewage Works Reserve Operations & Maint. 238,715 829 136,520 207,131 102,195 57% 645 2006 Sewer Bond 0 0 0 0 0 0% 647 Sewer Bond 2007 0 0 3 35 -3 0% 649 Sewage Sinking 9,804,645 775,951 4,654,102 4,810,606 5,150,543 47% 651 2007B Sewer Bond 0 0 0 64 0 0% 653 Sewage Debt Service Reserve 0 0 0 14,096 0 0% 658 Sewer Bond 2010 0 1 4 202 -4 0% 659 Sewer Bond 2011 25,000 1,535 14,021 20,114 10,979 56% 661 Sewer Bond 2012 45,000 4,317 34,713 38,108 10,287 77% 663 Sewer Bond 2013 60,000 0 0 0 60,000 0% 664 2013A Cost of Issuance Fund 0 1 9 85,740 -9 0% 665 2014 Sewer Bond 0 0 0 0 0 0% 670 Century Center 4,564,898 164,074 1,534,885 1,986,341 3,030,013 34% 671 Century Center Capital 500 0 145 100,135 355 29% Enterprise Total 81,204,531 6,154,428 40,6299570 35,190,124 40,574,961 50% Internal Service 222 Central Services 7,847,374 473,838 3,735,881 3,756,953 4,111,493 48% 226 Liability Insurance 2,898,690 250,200 1,484,260 1,506,228 1,414,430 51% 278 Take Home Vehicle Police 123,160 9,521 62,071 62,662 61,089 50% 711 Self- Funded Employee Benefits 13,418,450 1,074,338 6,447,480 6,229,033 6,970,970 48% 713 Unemployment Compensation 236,898 8,587 51,667 156,655 185,231 22% Internal Service Total 24,524,572 1,816,485 11,781,359 11,711,532 12,743,213 48% Trust & Agency 701 Firefighters Pension 5,391,332 2,564,549 2,565,260 2,519,282 2,826,072 48% 702 Police Pension 6,310,000 3,055,933 3,057,565 2,936,150 3,252,435 48% 703 Police /Fire 1977 Pension 0 0 0 0 0 0% 730 City Cemetery 250 9 71 89 179 29% Trust & Agency Total 11,701,582 5,620,491 5,622,896 5,455,521 6,078,686 48% City Funds Total 237,129,391 45,399,014 115,886,873 116,809,507 121,242,518 49% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF Revenue - Airport 13,484,612 7,627,935 7,669,058 9,731,867 5,815,554 57% 420 Tax Incremental Financing (TIF) - Downtown 3,368,336 2,515,903 2,880,622 2,179,069 487,714 86% 422 TIF - West Washington 422,000 304,301 305,315 265,547 116,685 72% 425 Redevelopment Retail & Leighton Plaza 164,303 16,916 80,003 86,405 84,300 49% 426 TIF - Central Medical Service Area 640,000 460,029 465,120 620,994 174,880 73% 429 TIF - Northeast Development 827,000 808,914 813,958 436,737 13,042 98% 430 TIF - Southside Development #1 2,515,000 1,269,709 1,275,289 1,392,772 1,239,711 51% 435 TIF - Douglas Road 320,750 160,995 161,451 164,413 159,299 50% 436 TIF - Northeast Residential 2,394,000 1,382,665 1,384,812 1,345,730 1,009,188 58% Tax Increment Financing Total 24,136,001 14,547,367 15,035,628 16,223,534 9,100,373 62% Redevelopment 433 Redevelopment General 0 2 36 68 -36 0% 439 Certified Technology Park 1,462,000 894 7,115 1,450,195 1,454,885 0% 454 Airport Urban Enterprise Zone 1,500 91 727 810 773 48% 619 Blackthorn Operations 1,696,879 229,433 773,413 815,239 923,466 46% Redevelopment Total 3,160,379 230,420 781,291 2,266,312 2,379,088 25% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 252 2,006 2,241 2,994 40% City of South Bend Monthly Department Financial Report REVENUE SUMMARY June 30, 2014 Redeve Debt S 317 Coveleski Debt Service Reserve 1,800 122 973 1,083 827 54% 319 Blackthorn Redev Bond 0 0 0 464 0 0% 328 Redevelopment Bond - Palais Royale 6,000 421 3,351 3,745 2,649 56% 432 TIF - Southside Development #3 15,000 10,644 20,910 671,259 -5,910 139% Debt Service Total 27,800 11,439 27,240 678,792 560 98% Redevelopment Commission Controlled Funds Total 27,324,180 14,789,226 15,8449159 19,168,638 11,480,021 58% Grand Total 264,453,571 60,188,240 131,731,032 135,978,144 132,722,539 50% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY June 30, 2014 City Funds General Fund 101 -0101 Mayor's Office 711,711 51,683 336,038 311,312 1,801 373,873 47% 101 -0104 311 Call Center 488,908 32,410 214,950 114,913 6,250 267,708 45% 101 -0201 City Clerk 394,608 22,930 156,419 157,388 19,030 219,159 44% 101 -0301 Common Council 472,598 16,770 142,939 196,576 0 329,659 30% 101 -0401 Administration & Finance 2,091,944 156,110 972,486 889,557 47,497 1,071,961 49% 101 -0404 Morris Performing Arts Center 1,063,527 78,815 491,710 461,636 61,992 509,825 52% 101 -0405 Palais Royale 523,710 32,545 212,084 190,277 47,276 264,351 50% 101 -0501 Legal Department 1,025,635 76,674 493,835 393,092 8,370 523,429 49% 101 -0600 Energy Office 2013 0 0 0 54,256 0 0 0% 101 -0602 Engineering 1,126,302 83,962 510,289 626,936 28,913 587,101 48% 101 -0607 Traffic & Lighting 2013 0 0 0 109,536 0 0 0% 101 -0801 Police Department 24,725,204 1,831,413 11,416,576 10,865,763 292,406 13,016,222 47% 101 -0802 Communications Center 2,236,486 162,622 966,702 1,002,870 1,302 1,268,482 43% 101 -0805 Police LOIT 2013 0 0 0 2,002,467 0 0 0% 101 -0901 Fire Department 21,049,415 1,776,613 10,385,269 10,028,140 277,835 10,386,311 51% 101 -0905 Fire LOT 2013 0 0 0 1,566,595 0 0 0% 101 -1008 Human Rights 367,262 25,472 160,807 152,609 12,081 194,374 47% 101 -1201 Code 2013 5,225 0 851 745,220 2,269 2,105 60% 101 -1203 Code Hearing 2013 0 0 0 12,478 0 0 0% 101 -1204 Junk Vehicle 2013 0 0 0 30,077 0 0 0% 101 -1205 Unsafe Building 2013 0 750 750 14,747 0 -750 0% 101 -1207 Animal Control 2013 2,254 0 300 278,480 1,547 407 82% General Fund Total 56,284,789 4,348,769 26,462,002 30,204,924 808,569 29,014,217 48% Special Revenue 102 Rainy Day 0 0 0 0 0 0 0% 201 Parks & Recreation 12,600,878 1,276,755 5,954,148 5,911,104 410,805 6,235,926 51% 202 Motor Vehicle Highway 9,708,648 501,375 4,071,473 3,219,891 717,692 4,919,483 49% 203 Recreation Nonreverting 1,479,064 80,663 384,975 352,647 124,348 969,741 34% 209 Studebaker - Oliver Reverting Grants 1,385,000 0 0 0 0 1,385,000 0% 210 Economic Development State Grants 117,886 18,003 36,005 84,636 0 81,881 31% 211 Community & Economic Development Admn. 2,404,884 174,699 1,098,405 1,084,502 29,481 1,276,998 47% 212 Community & Economic Development 6,910,783 187,318 1,059,718 2,527,641 2,481,025 3,370,040 51% 216 Police State Seizures 40,000 0 0 10,500 0 40,000 0% 217 Gift, Donation, Bequest 51,010 0 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 22,041 91,832 177,715 7,059 195,911 34% 227 Loss Recovery 5,615,805 130,545 473,937 37,388 909,227 4,232,641 25% 244 Emergency Phone System 215,000 11,973 108,004 0 0 106,996 50% 249 Public Safety LOT 7,214,658 614,034 3,621,341 3,569,062 0 3,593,317 50% 251 Local Roads & Streets 1,124,520 43,936 87,218 342,735 368,921 668,381 41% 252 Excess Welfare Distribution 1,146 0 0 0 0 1,146 0% 258 Human Rights Federal Grant 224,001 14,553 84,413 86,621 13,777 125,811 44% 271 Eastrace Waterway 10,346 0 9,092 0 596 658 94% 273 Morris PAC / Palais Royale Marketing 8,100 547 8,314 4,049 3,510 -3,724 146% 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 3,238 0 10,000 0% 291 Indiana River Rescue 52,300 6,014 12,754 67,072 7,859 31,687 39% 292 Police Grants 228,060 0 138,059 36,911 0 90,001 61% 294 Regional Police Academy 23,750 564 11,576 17,122 0 12,174 49% 295 COPS MORE Grant 141,600 1,795 7,384 6,993 1,252 132,964 6% 299 Police Federal Drug Enforcement 151,499 3,957 49,033 99,342 23,960 78,505 48% 404 County Option Income Tax 11,165,785 649,232 4,458,260 5,150,510 493,010 6,214,515 44% 408 Economic Development Income Tax 10,289,984 121,261 4,948,809 3,834,708 767,904 4,573,271 56% 410 Urban Development Action Grant 0 0 0 0 0 0 0% 655 Project Releaf 430,114 2,517 52,167 275,487 0 377,947 12% 705 Police K -9 Unit 2,000 0 0 0 0 2,000 0% Special Revenue Total 71,902,623 3,861,782 26,769,703 26,899,872 6,372,687 38,760,233 46% 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 June 30, 2014 City Funds Capital Project 288 Emergency Medical Services Capital Improv. 5,402,215 116,574 2,456,539 2,478,613 563,614 2,382,063 56% 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 67 149,990 65,174 25,425 29,802 85% 406 Cumulative Capital Development 722,935 56,545 361,467 353,050 0 361,468 50% 407 Cumulative Capital Improvement 364,762 0 185,250 184,875 0 179,512 51% 412 Major Moves Construction 5,823,729 119,867 500,296 892,517 2,621,479 2,701,954 54% 416 Morris Performing Arts Center Capital 53,200 0 7,139 19,738 3,034 43,027 19% 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,079 44,332 25,431 8,908 135,327 28% Capital Project Total 14,290,861 296,131 4,209,660 4,544,720 3,222,460 6,858,741 52% Enterprise 600 Consolidated Building Fund 3,798,909 189,079 1,353,286 485,779 545,329 1,900,294 50% 601 Parking Garages 797,808 46,542 433,059 474,388 115,920 248,829 69% 610 Solid Waste Operations 5,439,463 408,192 2,903,832 2,833,091 476,603 2,059,027 62% 611 Solid Waste Capital 896,070 10,821 513,119 324,702 20,618 362,333 60% 620 Water Works Operations 14,842,004 1,087,627 6,981,108 6,360,195 291,787 7,569,109 49% 622 Water Works Capital 978,258 53 3,653 207,189 96,870 877,735 10% 623 Water Works Bond Capital 811,011 430 447,998 1,185,183 75,443 287,570 65% 624 Water Works Customer Deposit 6,000 355 2,817 3,057 0 3,183 47% 625 Water Works Sinking 2,057,224 384,068 384,814 410,044 0 1,672,410 19% 626 Water Works Bond Reserve 0 0 0 0 0 0 0% 629 Water Works Reserve Operations & Maintenance 8,500 505 3,983 4,339 0 4,517 47% 640 Sewer Repair Insurance 549,978 16,799 161,578 188,108 30,996 357,404 35% 641 Sewage Works Operations 35,556,194 2,214,826 17,915,416 14,438,817 1,756,337 15,884,441 55% 642 Sewage Works Capital 9,267,941 350,346 2,642,927 1,703,734 3,221,228 3,403,786 63% 643 Sewage Works Reserve Operations & Maint. 15,000 829 6,556 6,836 0 8,444 44% 647 Sewer Bond 2007 1,138 805 805 13,616 333 0 100% 649 Sewage Sinking 9,802,031 132,890 1,674,352 2,662,715 0 8,127,679 17% 653 Sewage Debt Service Reserve 0 0 0 2,438,087 0 0 0% 658 Sewer Bond 2010 0 0 0 99,796 0 0 0% 659 Sewer Bond 2011 13,598,486 711,646 2,492,907 1,546,287 4,033,200 7,072,379 48% 661 Sewer Bond 2012 18,868,570 6,278 513,294 597,982 319,448 18,035,828 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 81,064 0 0 0% 665 2014 Sewer Bond 500,000 0 0 0 0 500,000 0% 670 Century Center 4,564,898 309,071 2,211,806 1,402,375 0 2,353,092 48% 671 Century Center Capital 106,684 0 0 0 0 106,684 0% Enterprise Total 141,566,167 5,871,162 40,647,311 37,467,384 10,984,113 89,934,744 36% Internal Service 222 Central Services 8,036,532 496,093 3,600,719 3,685,246 1,599,567 2,836,246 65% 226 Liability Insurance 2,897,200 512,130 1,535,777 1,028,430 34,224 1,327,199 54% 278 Take Home Vehicle Police 80,580 0 0 0 0 80,580 0% 711 Self- Funded Employee Benefits 14,483,463 846,028 7,086,994 6,311,595 54,177 7,342,292 49% 713 Unemployment Compensation 227,974 13,315 83,371 38,933 0 144,603 37% Internal Service Total 25,725,749 1,867,566 12,306,862 11,064,205 1,687,967 11,730,920 54% Trust & Agency 701 Firefighters Pension 5,874,445 462,793 2,725,715 2,756,842 0 3,148,730 46% 702 Police Pension 7,221,941 566,915 3,483,195 3,256,612 0 3,738,746 48% 730 City Cemetery 20,595 0 0 0 10,595 10,000 51% Trust & Agency Total 13,116,981 1,029,708 6,208,910 6,013,454 10,595 6,897,476 47% City Funds Total 324,155,286 17,275,118 117,238,948 116,828,058 23,086,391 183,829,947 43% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIFRevenue - Airport 27,286,693 161,642 3,114,899 5,489,340 1,188,986 22,982,808 16% 420 Tax Incremental Financing (TIF) - Downtown 5,829,261 32,302 1,796,277 1,703,981 279,499 3,753,485 36% 422 TIF - West Washington 657,534 0 319 135,870 8,300 648,915 1% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY June 30, 2014 Redevelop Tax Increm425 Redevelopment Retail & Leighton Plaza 149,425 16,524 70,314 53,855 0 79,111 47% 426 TIF - Central Medical Service Area 4,103,504 0 1,729,515 629,024 225,474 2,148,515 48% 429 TIF - Northeast Development 2,806,117 859 1,475 31,165 5,500 2,799,142 0% 430 TIF - Southside Development #1 6,487,957 43,125 345,991 696,851 1,179,843 4,962,123 24% 435 TIF - Douglas Road 399,823 0 95,391 95,488 4,200 300,232 25% 436 TIF - Northeast Residential 3,583,228 0 1,866,291 1,569,208 0 1,716,937 52% Tax Increment Financing Total 51,303,542 254,452 9,020,472 10,404,782 2,891,802 39,391,268 23% 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 Blackthom Operations 1,671,706 199,437 626,109 882,941 0 1,045,597 37% Redevelopment Total 5,291,706 199,437 641,812 883,795 0 4,649,894 12% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 252 2,006 2,241 0 2,994 40% 317 Coveleski Debt Service Reserve 0 0 0 0 0 0 0% 328 Redevelopment Bond - Palais Royale 6,000 421 3,351 3,745 0 2,649 56% 432 TIF - Southside Development #3 494,151 0 354,606 346,055 0 139,545 72% Debt Service Total 505,151 673 359,963 352,041 0 145,188 71% Redevelopment CommissionlFontrolled Funds Tot 57,100,3 547 11,640,61 Grand Total 381,255,685 17,729,680 127,261,195 128,468,675 25,978,193 228,016,297 40% 8 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Month June Fund /Department Number 101 -0101 Date Updated 7/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 711,111 51,656 335,321 310,293 - 375,790 47% Local Income Taxes - - - - - - 0% Other Taxes - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - 20 35 - (20) 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - 27 467 984 - (467) 0% Other Income 600 - 229 - - 371 38% Transfers In - - - - - - 0% Total Revenue 711,711 51,683 336,038 311,312 - 375,673 47% Expenditures Personnel 632,608 46,168 295,325 253,156 - 337,283 47% Supplies 19,889 1,529 11,016 23,365 164 8,709 56% Services 55,853 3,742 27,721 32,367 1,637 26,495 53% Debt Service 3,361 244 1,976 2,424 - 1,385 59% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 711,711 51,683 336,038 311,312 1,801 373,873 47% Net - - - - (1,801) 1,801 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. Payroll costs are slightly heavier because there were 3 payrolls paid in January. 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 June Fund /Department Number 101 -0104 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 8,831 1,111 (24,287) 114,913 - 33,118 -275% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 480,077 31,299 239,237 - - 240,840 50% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 488,908 32,410 214,950 114,913 - 273,958 44% Expenditures Personnel 422,705 31,296 190,752 112,716 - 231,953 45% Supplies 24,771 65 12,461 1,540 1,528 10,782 56% Services 41,432 1,049 11,737 657 4,722 24,973 40% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 488,908 32,410 214,950 114,913 6,250 267,708 45% Net - - - - (6,250) 6,250 Cash Balance - - Staffing Full Time 6.50 6.50 6.50 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 7.50 7.50 7.50 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The negative revenues indicated in the Property Taxes line, Current Year to Date Actual column indicates that this department is collecting more in revenues than it has expended - -this department is paying for itself. 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 June Fund /Department Number 101 -0201 Date Updated 7/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 394,608 22,930 156,419 157,388 - 238,189 40% 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 22,930 156,419 157,388 - 238,189 40% Expenditures Personnel 312,763 22,330 139,653 134,376 - 173,110 45% Supplies 8,062 30 3,310 2,347 2,048 2,704 66% Services 60,383 570 13,455 20,666 16,982 29,945 50% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 394,608 22,930 156,419 157,388 19,030 219,159 44% Net - - - - (19,030) 19,030 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 June Fund /Department Number 101 -0301 Date Updated 7/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 464,298 16,770 142,817 192,011 - 321,481 31% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 8,300 - 122 4,564 - 8,178 1% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 472,598 16,770 142,939 196,576 - 329,659 30% Expenditures Personnel 297,929 15,601 99,666 90,066 - 198,263 33% Supplies 7,285 24 258 4,947 - 7,027 4% Services 149,884 1,146 43,015 95,273 - 106,869 29% Debt Service - - - - - - 0% Capital 17,500 - - 6,289 - 17,500 0% Transfers Out - - - - - - 0% Total Expenditures 472,598 16,770 142,939 196,576 - 329,659 30% Net - - - - - - Cash Balance - - Staffing Full Time 9.00 9.00 9.00 Part -Time /Seasonal /Temporary - - - Total 9.00 9.00 9.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: There are nine (9) Council Members. One member has declined to receive a salary. There were 3 payroll checks issued in January compared to the usual 2 issued in January 2013. This phenomenon occurs twice in 2014; the next time will be in August. Also in 2013, legal expenses were higher due to unforseen circumstances. 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 Form 3 13 2014 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Month June Fund /Department Number 101 -0401 Date Updated 7/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 2,011,894 156,110 972,486 889,151 - 1,039,408 48% 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 - - 406 - 80,050 0% Transfers In - - - - - - 0% Total Revenue 2,091,944 156,110 972,486 889,557 - 1,119,458 46% Expenditures Personnel 1,869,551 139,544 827,746 729,076 - 1,041,805 44% Supplies 36,140 2,546 16,358 17,433 4,076 15,705 57% Services 178,061 13,654 124,900 139,389 41,492 11,669 93% Debt Service 8,192 366 3,482 3,660 1,928 2,782 66% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,091,944 156,110 972,486 889,557 47,497 1,071,961 49% Net - - - - (47,497) 47,497 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. 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 June Fund /Department Number 101 -0404 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 181,527 (179,115) (133,365) (70,631) - 314,892 -73% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 876,000 257,415 620,519 528,001 - 255,481 71% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 515 4,555 4,266 - 1,445 76% Transfers In - - - - - - 0% Total Revenue 1,063,527 78,815 491,710 461,636 - 571,817 46% Expenditures Personnel 711,096 55,973 338,412 318,346 2,442 370,242 48% Supplies 32,657 1,212 9,886 10,710 9,351 13,420 59% Services 319,774 21,630 143,412 132,579 50,199 126,163 61% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,063,527 78,815 491,710 461,636 61,992 509,825 52% Net - - - - (61,992) 61,992 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. At the end of the 2nd quarter, revenue totaling $231.000 was transfered from the Morris PAC Box Office Account to the General Fund 101. Explain Significant Spending on Capital Projects Below: Form 3 14 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Month June Fund /Department Number 101 -0405 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 213,729 16,186 102,430 67,004 - 64,024 48% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 291,981 14,424 103,375 116,482 - 188,606 35% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 18,000 1,936 6,279 6,790 - 11,721 35% Transfers In - - - - - - 0% Total Revenue 523,710 32,545 212,084 190,277 - 264,351 40% Expenditures Personnel 251,265 17,934 114,112 102,960 918 136,235 46% Supplies 31,629 532 3,327 7,694 4,244 24,058 24% Services 225,816 14,079 94,645 79,623 42,114 89,058 61% Debt Service - - - - - - 0% Capital 15,000 - - - - 15,000 0% Transfers Out - - - - - - 0% Total Expenditures 523,710 32,545 212,084 190,277 47,276 264,351 50% Net - - - - (47,276) - 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: No Capital Projects Started. Form 3 Form 3 iV 2014 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Month June Fund /Department Number 101 -0501 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 953,285 76,674 492,213 392,004 - 461,072 52% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 - 1,581 790 - 419 79% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 70,350 - 42 298 - 70,309 0% Transfers In - - - - - - 0% Total Revenue 1,025,635 76,674 493,835 393,092 - 531,800 48% Expenditures Personnel 977,419 69,811 472,648 357,470 - 504,771 48% Supplies 5,083 1,735 1,783 3,409 1,912 1,389 73% Services 39,933 5,128 18,769 24,258 5,824 15,340 62% Debt Service 3,200 - 635 1,938 635 1,929 40% Capital - - - 6,016 - 0% Transfers Out - - - - - - 0% Total Expenditures 1,025,635 76,674 493,835 393,092 8,370 523,429 49% Net - - - - (8,370) 8,370 Cash Balance - - Staffing Full Time 9.60 8.00 Part -Time /Seasonal /Temporary - 3.00 Total 9.60 11.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: As of June 30, 2014 the Legal Department is down by 1 FTE but seeks to fill the position through the Liability Insurance fund. 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 June Fund /Department Number 101 -0602 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 1,120,202 83,387 491,118 622,800 - 629,084 44% 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 575 19,171 4,136 - (13,071) 314% Transfers In - - - - - - 0% Total Revenue 1,126,302 83,962 510,289 626,936 - 616,013 45% Expenditures Personnel 610,675 55,549 286,548 296,134 - 324,127 47% Supplies 18,929 3,678 11,654 7,938 1,758 5,517 71% Services 483,156 24,087 208,236 322,202 24,534 250,386 48% Debt Service 13,542 648 3,850 662 2,621 7,071 48% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,126,302 83,962 510,289 626,936 28,913 587,101 48% Net - - - - (28,913) 28,913 Cash Balance - - Staffing Full Time 6.90 6.90 Part -Time /Seasonal /Temporary 1.81 8.00 Total 8.71 14.90 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Other income included $18,356 received in May as reimbursement for costs in state projects. Part -Time includes 6 interns, one of whom will be transferred to the Wastweater fund in July. 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 June Fund /Department Number 101 -0801 Date Updated 7/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 24,387,504 1,820,500 11,280,105 10,696,438 - 13,107,399 46% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - 24,316 - - (24,316) 0% Charges for Services 329,200 10,913 110,969 159,466 - 218,231 34% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 8,500 - 1,186 9,859 - 7,314 14% Transfers In - - - - - - 0% Total Revenue 24,725,204 1,831,413 11,416,576 10,865,763 - 13,308,628 46% Expenditures Personnel 20,430,704 1,568,374 9,615,465 9,437,005 - 10,815,239 47% Supplies 754,999 10,550 395,077 230,459 90,430 269,493 64% Services 3,234,343 252,242 1,338,891 1,169,903 201,977 1,693,476 48% Debt Service - 246 1,985 - - (1,985) 0% Capital 305,158 - 65,158 28,396 - 240,000 21% Transfers Out - - - - - - 0% Total Expenditures 24,725,204 1,831,413 11,416,576 10,865,763 292,406 13,016,222 47% Net - - - - (292,406) 292,406 Cash Balance - - Staffing Full Time 253.00 236.00 236.00 Part -Time /Seasonal /Temporary 57.00 9.00 9.00 Total 310.00 245.00 245.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, 64% 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 June Fund /Department Number 101 -0802 Date Updated 7/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 2,236,486 162,622 966,702 1,002,870 - 1,269,784 43% 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 162,622 966,702 1,002,870 - 1,269,784 43% Expenditures Personnel 2,210,667 161,947 961,917 990,591 - 1,248,750 44% Supplies 4,029 - 60 1,246 1,302 2,667 34% Services 21,790 675 4,725 11,034 - 17,065 22% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,236,486 162,622 966,702 1,002,870 1,302 1,268,482 43% Net - - - - (1,302) 1,302 Cash Balance - - Staffing Full Time 35.00 33.00 33.00 Part -Time /Seasonal /Temporary - - - Total 35.00 33.00 33.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund captures the cost of 35 of the 38 civilians and equipment to maintain the 911 communication center. The cost of three supervisors has been transferred to Fund 244 as their cost is recovered through the Emergency Telephone System funding. 2014 Personnel costs 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 June Fund /Department Number 101 -0901 Date Updated 7/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 19,433,415 1,732,294 10,111,786 9,176,696 9,321,629 52% Local Income Taxes - - - - - 0% Other Taxes - - - - - 0% Grants /Intergovernmental 155,000 - - - - 155,000 0% Charges for Services 455,000 44,319 273,023 313,300 - 181,977 60% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 - 460 38,144 - 5,540 8% Transfers In 1,000,000 - - 500,000 - 1,000,000 0% Total Revenue 21,049,415 1,776,613 10,385,269 10,028,140 - 10,664,146 49% Expenditures Personnel 18,806,414 1,609,407 9,381,923 9,151,074 117,248 9,307,243 51% Supplies 602,477 25,468 166,354 190,555 85,645 350,478 42% Services 1,640,524 141,737 836,992 686,510 74,941 728,591 56% Debt Service - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 21,049,415 1,776,613 10,385,269 10,028,140 277,835 10,386,311 51% Net - - - - (277,835) 277,835 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 June Fund /Department Number 101 -1008 Date Updated 7/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 367,262 25,472 160,807 152,367 - 206,455 44% 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,472 160,807 152,609 - 206,455 44% Expenditures Personnel 272,252 20,874 132,008 120,927 - 140,244 48% Supplies 2,394 32 850 1,537 16 1,529 36% Services 78,426 4,566 27,949 30,146 12,066 38,411 51% Debt Service - - - - - - 0% Capital 14,190 - - - - 14,190 0% Transfers Out - - - - - - 0% Total Expenditures 367,262 25,472 160,807 152,609 12,081 194,374 47% Net - - - - (12,081) 12,081 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 June Fund /Department Number 102 Date Updated 7/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 52,000 2,091 16,649 18,541 - 35,351 32% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 52,000 2,091 16,649 18,541 - 35,351 32% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 52,000 2,091 16,649 18,541 - 35,351 Cash Balance 8,634,354 8,606,721 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 June Fund /Department Number 201 1 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 7,350,000 4,021,603 4,021,603 3,943,985 - 3,328,397 55% Local Income Taxes - - - - - - 0% Other Taxes 596,878 324,443 324,443 309,952 - 272,435 54% Grants /Intergovernmental 729,437 60,782 364,694 348,005 - 364,743 50% Charges for Services 2,208,344 270,249 913,707 1,421,027 - 1,294,637 41% Interest Earnings 13,000 193 4,539 7,510 - 8,461 35% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,850 263 1,943 77,824 - (93) 105% Transfers In - - - 0% Total Revenue 10,899,509 4,677,534 5,630,929 6,108,303 - 5,268,580 52% Expenditures Personnel 7,641,942 568,543 3,280,753 3,607,426 4,008 4,357,181 43% Supplies 1,616,319 103,123 644,224 909,262 276,813 695,282 57% Services 2,750,772 555,068 1,857,374 1,099,593 129,984 763,414 72% Debt Service 313,345 50,021 166,796 144,703 - 146,549 53% Capital 93,000 - 5,000 150,120 - 88,000 5% Transfers Out 185,500 - - - - 185,500 0% Total Expenditures 12,600,878 1,276,755 5,954,148 5,911,104 410,805 6,235,926 51% Net (1,701,369) 3,400,779 (323,219) 197,200 (410,805) (967,345) Cash Balance 3,941,446 5,091,719 Staffing Full Time 111.00 93.00 93.00 Part -Time /Seasonal /Temporary 73.00 62.00 30.00 Total 184.00 155.00 123.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund 201 accounts for the annual operation of the Parks and Recreation Department. There are six divisions within the department, Administration, Maintenance, Golf, Recreation, Greenhouse, and Graffiti. 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 June Fund /Department Number 202 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,633,418 571,436 2,781,681 2,396,319 2,851,737 49% Grants /Intergovernmental - - 0% Charges for Services 244,000 38,914 183,753 284,547 60,247 75% Interest Earnings 7,000 900 6,115 5,820 885 87% Bond Proceeds - - 0% Donations - - 0% Other Income 5,300 11,269 4,068 (5,969) 213% Transfers In 3,216,582 1,483,291 2,276,882 1,733,291 46% Total Revenue 9,106,300 611,250 4,466,110 4,967,637 - 4,640,190 49% Expenditures Personnel 3,995,824 270,730 1,939,467 1,743,436 2,056,358 49% Supplies 3,400,615 111,650 841,756 663,150 572,764 1,986,095 42% Services 1,557,564 118,678 1,028,607 736,755 134,807 394,150 75% Debt Service 408,395 318 127,613 53,309 10,122 270,661 34% Capital 346,250 134,030 23,240 212,220 39% Transfers Out - - 0% Total Expenditures 9,708,648 501,375 4,071,473 3,219,891 717,692 4,919,483 49% Net (602,348) 109,875 394,637 1,747,746 (717,692) (279,293) Cash Balance 4,074,437 4,019,437 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 79% of our overtime budget, which has been scaled back to emergencies such as the recent storm that went through South Bend. We set up a new overtime account so that we can track Special Events overtime costs which will take some of the burden off of the "regular" overtime account. As of June 30th, our vehicle maintenance budget is overdrawn by $226,136.74, but we have requested a mid -year budget transfer to cover the overdraft and see us through to year's end. We have requested a mid -year appropriation to cover unforeseen expenses such as snow removal, salt use exceeding planned due to severe winter and rental of light standards used downtown during the May power outage. If those come through we should be in good shape for the 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 June Fund /Department Number 203 Date Updated 7/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 1,400,592 102,579 489,885 510,126 - 910,707 35% Interest Earnings 4,000 215 1,612 1,622 - 2,388 40% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 45,000 917 21,182 74,851 - 23,818 47% Transfers In - - - - - - 0% Total Revenue 1,449,592 103,711 512,679 586,599 - 936,913 35% Expenditures Personnel 613,627 35,533 188,679 176,148 - 424,948 31% Supplies 274,095 19,370 74,140 75,892 98,950 101,006 63% Services 492,342 25,760 122,157 100,607 25,399 344,787 30% Debt Service - - - - - - 0% Capital 99,000 - - - - 99,000 0% Transfers Out - - - - - - 0% Total Expenditures 1,479,064 80,663 384,975 352,647 124,348 969,741 34% Net (29,472) 23,049 127,704 233,952 (124,348) (32,828) Cash Balance 905,953 905,084 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 June Fund /Department Number 209 Date Updated 7/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 5,000 263 2,093 2,331 - 2,907 42% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 300,000 - - - - 300,000 0% Transfers In - - - - - - 0% Total Revenue 305,000 263 2,093 2,331 - 302,907 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) 263 2,093 2,331 Cash Balance 1,085,480 1,082,006 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. February 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 June Fund /Department Number 210 Date Updated 7/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 18,813 85 4,325 44,025 - 14,488 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 58,203 - 14,387 120,875 - 43,816 25% Transfers In - - - - - - 0% Total Revenue 77,016 85 18,712 164,900 - 58,304 24% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 117,886 18,003 36,005 84,636 - 81,881 31% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 117,886 18,003 36,005 84,636 - 81,881 31% Net (40,870) (17,918) (17,293) 80,264 - (23,577) Cash Balance 331,657 998,719 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 & Economic Development Admn. Month June Fund /Department Number 211 Date Updated 7/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 386,787 - 10,680 70,914 - 376,107 3% Charges for Services - - - - - - 0% Interest Earnings 2,200 252 1,834 1,597 - 366 83% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 200,300 37,693 160,946 131,474 - 39,354 80% Transfers In 1,688,959 - 844,480 858,760 - 844,479 50% Total Revenue 2,278,246 37,945 1,017,940 1,062,745 - 1,260,306 45% Expenditures Personnel 2,069,556 149,007 958,656 894,754 - 1,110,900 46% Supplies 32,475 1,349 10,716 12,474 15,251 6,508 80% Services 302,853 24,343 129,033 172,554 14,230 159,590 47% Debt Service - - - - - - 0% Capital - - - 4,720 - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,404,884 174,699 1,098,405 1,084,502 29,481 1,276,998 47% Net (126,638) (136,754) (80,465) (21,757) (29,481) (16,692) Cash Balance 826,849 562,079 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 Community & Economic Development Month June Fund /Department Number 212 Date Updated 7/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,625,000 160,732 883,073 2,343,694 - 5,741,927 13% Charges for Services - - - - - - 0% Interest Earnings 2,000 223 1,110 1,199 - 890 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 284,000 59,243 171,406 170,993 - 112,594 60% Transfers In - - - - - - 0% Total Revenue 6,911,000 220,198 1,055,589 2,515,886 - 5,855,411 15% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 6,910,783 187,318 1,059,718 2,527,641 2,481,025 3,370,040 51% Transfers Out - - - - - - 0% Total Expenditures 6,910,783 187,318 1,059,718 2,527,641 2,481,025 3,370,040 51% Net 217 32,880 (4,129) (11,755) (2,481,025) 2,485,371 Cash Balance 586,142 500,423 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund covers multiple federal grants. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on -going and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 29 Form 3 30 2014 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Month June Fund /Department Number 216 Date Updated 7/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 35,000 - 23,533 8,939 - 11,467 67% Charges for Services - - - - - - 0% Interest Earnings 300 40 307 311 - (7) 102% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - - - - 600 0% Transfers In - - 0% Total Revenue 35,900 40 23,841 9,250 - 12,059 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) 40 23,841 (1,250) - (27,941) Cash Balance 182,507 143,675 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 June Fund /Department Number 217 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 290 23 165 138 - 125 57% Bond Proceeds - - - - - - 0% Donations 7,000 - 21,113 11,269 - (14,113) 302% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 7,290 23 21,278 11,407 - (13,988) 292% Expenditures Personnel - - - - - - 0% Supplies 22,100 - 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 - 12,260 35,963 29% Net (43,720) 23 18,491 11,407 (12,260) (49,951) Cash Balance 93,226 74,640 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 Form 3 KYA 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Month June Fund /Department Number 218 Date Updated 7/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 1,000 125 263 150 - 738 26% Interest Earnings 25 3 22 24 - 3 90% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,025 128 285 174 - 740 28% 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 128 285 174 - (260) Cash Balance 11,833 11,058 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 June Fund /Department Number 220 Date Updated 7/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 - 10,000 10,000 6,964 - (10,000) 0% Charges for Services 180,000 8,379 82,180 84,354 - 97,820 46% Interest Earnings 3,000 242 1,914 2,253 - 1,086 64% Bond Proceeds - - - - - - 0% Donations 2,000 - - 1,965 - 2,000 0% Other Income 26,000 11 11,517 1,777 - 14,483 44% Transfers In - - - - - - 0% Total Revenue 211,000 18,632 105,611 97,312 - 105,389 50% Expenditures Personnel - - - - - - 0% Supplies 40,855 9,261 21,494 27,277 7,059 12,301 70% Services 190,000 12,781 56,391 27,318 - 133,609 30% Debt Service - - - - - - 0% Capital 63,947 - 13,947 123,119 - 50,000 22% Transfers Out - 0% Total Expenditures 294,802 22,041 91,832 177,715 7,059 195,911 34% Net (83,802) (3,410) 13,779 (80,403) (7,059) (90,522) Cash Balance 995,005 1,006,804 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 2014 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Month June Fund /Department Number 227 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 17,000 1,850 15,160 9,357 - 1,840 89% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 6,309 - - 0% Transfers In - - - - - - 0% Total Revenue 17,000 1,850 15,160 15,666 - 1,840 89% Expenditures Personnel - - - - - - 0% Supplies 200,000 - - - 200,000 0% Services 3,315,805 123,852 319,517 37,388 899,227 2,097,061 37% Debt Service - - - - - 0% Capital 2,100,000 6,694 154,420 - 10,000 1,935,580 8% Transfers Out - - - - - 0% Total Expenditures 5,615,805 130,545 473,937 37,388 909,227 4,232,641 25% Net (5,598,805) (128,696) (458,777) (21,722) (909,227) (4,230,801) Cash Balance 7,477,256 4,319,839 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used primarily for funding Smart Streets projects as well as the Vacant & Abandoned Housing initiative. The largest portion of the $466K 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 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month June Fund /Department Number 244 Date Updated 7/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 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 11,973 108,004 - - 106,996 50% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 215,000 11,973 108,004 - - 106,996 50% Net - (11,973) 106,996 - - (106,996) Cash Balance 106,996 - 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.) This fund will be closed in 2015 with the advent of the county -wide PSAP system. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 1917 2014 City of South Bend Monthly Financial Report Fund /Department Name Public Safety WIT Month June Fund /Department Number 249 Date Updated 7/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 3,190,015 2,946,193 - 3,190,014 50% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 11,000 384 3,594 4,732 - 7,406 33% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 560,580 - - 0% Total Revenue 6,391,029 532,054 3,193,609 3,511,505 - 3,197,420 50% Expenditures Personnel 7,214,658 614,034 3,621,341 - - 3,593,317 50% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - 3,569,062 - - 0% Total Expenditures 7,214,658 614,034 3,621,341 3,569,062 - 3,593,317 50% Net (823,629) (81,980) (427,732) (57,557) - (395,897) Cash Balance 1,604,462 2,932,383 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. The Police personnel costs year to date through April are 48% of budget. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 K3.; Form 3 37 2014 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month June Fund /Department Number 251 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,080,000 90,930 540,556 541,644 - 539,444 50% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 8,000 573 4,097 3,922 - 3,903 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 33,801 - - (33,801) 0% Transfers In - - - - - - 0% Total Revenue 1,088,000 91,503 578,454 545,566 - 509,546 53% Expenditures Personnel - - - - - - 0% Supplies 352,663 20,436 20,436 2,570 329,564 2,663 99% Services 7,500 - - 7,500 - 7,500 0% Debt Service - - - - - - 0% Capital 764,357 23,500 66,782 332,665 39,357 658,218 14% Transfers Out - - - - - - 0% Total Expenditures 1,124,520 43,936 87,218 342,735 368,921 668,381 41% Net (36,520) 47,567 491,236 202,831 (368,921) (158,835) Cash Balance 2,432,611 1,917,129 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 June Fund /Department Number 252 Date Updated 7/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 - 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 June Fund /Department Number 258 Date Updated 7/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 187,000 - 5,000 30,450 - 182,000 3% Charges for Services - - - - - - 0% Interest Earnings 2,000 104 862 1,008 - 1,138 43% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 21,700 44 17,924 13,550 - 3,776 83% Transfers In - - - - - - 0% Total Revenue 210,700 148 23,786 45,007 - 186,914 11% Expenditures Personnel 112,901 8,538 54,832 53,437 - 58,069 49% Supplies 4,550 - 293 1,111 1,470 2,787 39% Services 105,050 6,014 29,288 32,073 12,308 63,455 40% Debt Service - - - - - - 0% Capital 1,500 - - - - 1,500 0% Transfers Out - - - - - - 0% Total Expenditures 224,001 14,553 84,413 86,621 13,777 125,811 44% Net (13,301) (14,405) (60,627) (41,614) (13,777) 61,103 Cash Balance 406,148 444,550 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 JUNE Fund /Department Number 271 Date Updated 7/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 - - - - - - 0% Interest Earnings 100 3 27 31 - 73 27% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 100 3 27 31 - 73 27% Expenditures Personnel - - - - - - 0% Supplies 10,346 - 9,092 - 596 658 94% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,346 - 9,092 - 596 658 94% Net (10,246) 3 (9,065) 31 (596) (585) Cash Balance 5,307 14,354 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 June Fund /Department Number 273 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 8,000 1,112 6,265 3,818 - 1,735 78% Interest Earnings 100 6 51 60 - 49 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 8,100 1,118 6,316 3,878 - 1,784 78% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 8,100 547 8,314 4,049 3,510 (3,724) 146% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 8,100 547 8,314 4,049 3,510 (3,724) 146% Net - 572 (1,998) (171) (3,510) 5,508 Cash Balance 25,987 28,592 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 June Fund /Department Number 280 Date Updated 7/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 7 8 - (7) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 7 8 - (7) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 7 8 - (7) Cash Balance 3,825 3,812 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 June Fund /Department Number 281 Date Updated 7/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 - 7 52 58 - (52) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 7 52 58 - (52) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 7 52 58 - (52) Cash Balance 27,180 27,093 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 June Fund /Department Number 289 Date Updated 7/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 10,000 - - 16,722 - 10,000 0% Interest Earnings - 4 31 19 - (31) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 4 31 16,741 - 9,969 0% Expenditures Personnel - - - - - - 0% Supplies 10,000 - - - 10,000 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - 3,238 - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,000 - - 3,238 - 10,000 0% Net - 4 31 13,503 - (31) Cash Balance 16,239 16,187 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 June Fund /Department Number 291 Date Updated 7/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 45,000 3,600 34,600 42,140 - 10,400 77% Interest Earnings 200 29 197 245 - 3 98% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,200 3,629 34,797 42,385 - 10,403 77% Expenditures Personnel 2,500 - - - 628 1,872 25% Supplies 8,800 54 406 31,447 - 8,394 5% Services 41,000 5,960 12,348 8,165 7,231 21,422 48% Debt Service - - - - - - 0% Capital - - - 27,460 - - 0% Transfers Out - - - - - - 0% Total Expenditures 52,300 6,014 12,754 67,072 7,859 31,687 39% Net (7,100) (2,385) 22,043 (24,687) (7,859) (21,284) Cash Balance 117,762 94,737 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 June Fund /Department Number 292 Date Updated 7/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 - 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 - - - 36,911 - - 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 36,911 - 90,001 61% Net (228,060) - (71,342) (36,911) - (156,718) Cash Balance 133,166 61,214 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 received in December of 2013 has been disbursed to the South Bend School Corporation which spent the funds in accordance with the terms of the grant. 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 June Fund /Department Number 294 Date Updated 7/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 19 154 173 - 1,846 8% Bond Proceeds - - 0% Donations - - 0% Other Income - - 0% Transfers In - - - - - - 0% Total Revenue 22,000 19 18,054 19,718 - 3,946 82% Expenditures Personnel - - - - - - 0% Supplies 1,750 - 1,750 0% Services 22,000 564 11,576 17,122 - 10,424 53% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 564 11,576 17,122 - 12,174 49% Net (1,750) (546) 6,478 2,597 - (8,228) Cash Balance 74,563 76,412 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 90% 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 June Fund /Department Number 295 Date Updated 7/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 350 27 218 230 - 132 62% Bond Proceeds - - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 38,000 1,346 5,496 5,656 - 32,504 14% Transfers In - - - - - - 0% Total Revenue 41,600 1,374 5,714 5,886 - 35,886 14% Expenditures Personnel - - - - - - 0% Supplies 15,000 1,551 2,204 1,924 - 12,796 15% Services 16,000 244 5,180 5,069 1,252 9,569 40% Debt Service - - - 0% Capital 110,600 - - 110,600 0% Transfers Out - - - 0% Total Expenditures 141,600 1,795 7,384 6,993 1,252 132,964 6% Net (100,000) (421) (1,670) (1,107) (1,252) (97,079) Cash Balance 111,673 106,182 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 June Fund /Department Number 299 Date Updated 7/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 75,000 4,256 24,412 47,406 - 50,588 33% Charges for Services - - - - - 0% Interest Earnings 1,000 82 493 499 - 507 49% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 1,000 - - 23,018 - 1,000 0% Transfers In - - - - - - 0% Total Revenue 77,000 4,338 24,906 70,923 - 52,094 32% Expenditures Personnel - - - - - - 0% Supplies 41,499 3,957 23,800 23,867 9,759 7,941 81% Services 40,000 - 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 3,957 49,033 99,342 23,960 78,505 48% Net (74,499) 380 (24,128) (28,418) (23,960) (26,411) Cash Balance 361,032 306,922 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 June Fund /Department Number 404 Date Updated 7/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 8,645,811 720,484 4,322,905 3,923,470 - 4,322,906 50% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 75,000 3,567 28,043 31,843 - 46,957 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 549,376 43,454 260,888 266,490 - 288,488 47% Transfers In - - - - - - 0% Total Revenue 9,270,187 767,505 4,611,836 4,221,802 - 4,658,351 50% Expenditures Personnel - - - - - - 0% Supplies 1,294,540 98,579 612,030 624,007 27,846 654,663 49% Services 5,166,602 316,196 1,929,517 2,373,020 359,680 2,877,405 44% Debt Service 2,245,628 234,456 1,347,213 1,238,266 - 898,415 60% 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 649,232 4,458,260 5,150,510 493,010 6,214,515 44% Net (1,895,598) 118,273 153,576 (928,708) (493,010) (1,556,164) Cash Balance 15,059,211 14,398,295 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 June Fund /Department Number 408 Date Updated 7/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 4,398,410 4,088,676 - 4,398,411 50% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 - 354,660 354,960 - 150,000 70% Interest Earnings 45,000 2,336 19,776 21,182 - 25,224 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 11,948 69,665 - (11,948) 0% Transfers In - - - - - - 0% Total Revenue 9,346,481 735,405 4,784,794 4,534,483 - 4,561,687 51% Expenditures Personnel 500,335 27,449 195,573 - - 304,762 39% Supplies - - - - - - 0% Services 2,609,285 93,812 709,635 671,397 767,904 1,131,746 57% Debt Service 1,043,263 - 962,550 954,551 - 80,713 92% 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 121,261 4,948,809 3,834,708 767,904 4,573,271 56% Net (943,503) 614,144 (164,015) 699,775 (767,904) (11,584) Cash Balance 10,678,113 10,684,186 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 June Fund /Department Number 410 Date Updated 7/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 110 7 53 61 - 57 48% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 3,041 - - 0% Transfers In - - - - - - 0% Total Revenue 110 7 53 3,102 - 57 48% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 110 7 53 3,102 - 57 Cash Balance 27,640 26,855 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This budget usually includes payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. No new payments from the BDC are expected until 2015. Explain Significant Spending on Capital Projects Below: Form 3 M Form 3 53 2014 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Month June Fund /Department Number 655 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 429,000 36,453 217,828 215,521 - 211,172 51% Interest Earnings 2,700 256 1,920 1,821 - 780 71% Bond Proceeds - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 36,709 219,748 217,342 - 211,952 51% Expenditures Personnel 64,378 25 1,457 1,090 62,921 2% Supplies 8,369 347 8,369 0% Services 34,583 2,493 14,601 12,431 19,982 42% 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,517 52,167 275,487 - 377,947 12% Net 1,586 34,192 167,581 (58,145) - (165,995) Cash Balance 1,106,634 799,804 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 June Fund /Department Number 705 Date Updated 7/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 4 4 - 6 39% Bond Proceeds - - - - - - 0% Donations 1,990 - 1,000 - - 990 50% Other Income - - - 1 - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 1 1,004 5 - 996 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,004 5 - (1,004) Cash Balance 2,317 1,936 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 June Fund /Department Number 313 Date Updated 7/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 497,000 271,788 271,788 693,822 - 225,212 55% Local Income Taxes - - - - - - 0% Other Taxes 67,350 22,679 22,679 33,662 - 44,671 34% Grants /Intergovernmental 85,640 7,140 42,839 35,734 - 42,801 50% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 649,990 301,607 337,306 763,218 - 312,684 52% 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 (618,126) 301,607 (297,194) 129,718 - (320,932) Cash Balance 419,142 707,091 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 61t 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Improv.7 Month June Fund /Department Number 288 Date Updated 7/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 2,623,000 302,517 1,466,816 1,438,711 - 1,156,184 56% Interest Earnings 10,000 1,081 9,922 11,751 - 78 99% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 28,000 1,456 2,541 5,387 - 25,459 9% Transfers In - - - - - - 0% Total Revenue 2,661,000 305,054 1,479,279 1,455,849 - 1,181,721 56% Expenditures Personnel - - - - - - 0% Supplies 300,000 22,240 58,800 124,216 74,779 166,421 45% Services 416,952 16,134 164,891 974,960 49,733 202,328 51% Debt Service 351,106 318 20,651 20,333 1,271 329,184 1% Capital 3,334,157 77,882 2,212,197 859,104 437,830 684,129 265% Transfers Out 1,000,000 - - 500,000 - 1,000,000 0% Total Expenditures 5,402,215 116,574 2,456,539 2,478,613 563,614 2,382,063 56% Net (2,741,215) 188,481 (977,260) (1,022,764) (563,614) (1,200,342) Cash Balance 4,610,908 4,502,762 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 61t 2014 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month June Fund /Department Number 377 Date Updated 7/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 600,000 121,525 301,664 297,215 - 298,336 50% Charges for Services - - - - - - 0% Interest Earnings 4,000 139 1,251 1,867 - 2,749 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 74,228 - 34,608 41,646 - 39,620 47% Transfers In - - - - - - 0% Total Revenue 678,228 121,664 337,523 340,728 - 340,705 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 865,746 - 483,673 388,348 - 382,073 56% Capital - - - - - - 0% Transfers Out - - - 100,000 - - 0% Total Expenditures 865,746 - 483,673 488,348 - 382,073 56% Net (187,518) 121,664 (146,150) (147,620) - (41,368) Cash Balance 695,907 893,203 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Effective January 1, 2013, this fund no longer collects hotel /motel tax allocations from St. Joseph County for payment to the Hall of Fame. This fund is currenty used for debt, and a $100,000 capital transfer to Century Center. PSDA tax revenue is generally received from the State on a monthly basis. PSDA tax is a special tax received from the State of Indiana based on the sales tax, income tax and local income taxes collected in the PSDA area (which includes Coveleski Stadium, Century Center, Morris Performing Arts Center and Studebaker National Museum). Coveleski Stadium generates the majority of PSDA revenue. The January debt service payments have been made for 2014. The final debt service payment on the 2010 Coveleski Stadium bonds was paid January 15, 2013. The outsanding principal balance on the bonds is $3,220,000 at January 31, 2014. Explain Significant Spending on Capital Projects Below: A $100,000 transfer is made annually to the Century Center. Form 3 57 Form 3 58 2014 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month JUNE Fund /Department Number 401 Date Updated 7/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 - - - - - - 0% Interest Earnings 500 7 52 58 - 448 10% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 7 52 58 - 448 10% 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) 7 52 58 - (3,092) Cash Balance 26,902 26,816 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 JUNE Fund /Department Number 403 Date Updated 7/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 - - - - - - 0% Interest Earnings 200 12 95 105 - 105 47% Bond Proceeds - - - - - - 0% Donations 2,700 - - - - 2,700 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,900 12 95 105 - 2,805 3% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 2,900 12 95 105 - 2,805 Cash Balance 49,117 48,952 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 June Fund /Department Number 405 Date Updated 7/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 3,000 648 1,924 2,153 - 1,076 64% Interest Earnings 2,200 92 829 928 - 1,371 38% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 12,144 8,305 - (12,144) 0% Transfers In 190,500 - - - - 190,500 0% Total Revenue 195,700 740 14,897 11,387 - 180,803 8% Expenditures Personnel - - - - - - 0% Supplies 23,417 67 42,570 52,707 16,690 (35,843) 253% 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 67 149,990 65,174 25,425 29,802 85% Net (9,517) 674 (135,092) (53,787) (25,425) 151,000 Cash Balance 437,799 438,598 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 June Fund /Department Number 406 1 Date Updated 7/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 430,000 235,215 235,215 253,553 - 194,785 55% Local Income Taxes - - - - - - 0% Other Taxes 40,400 18,976 18,976 19,926 - 21,424 47% Grants /Intergovernmental 46,894 3,891 23,346 23,027 - 23,548 50% Charges for Services - - - - - - 0% Interest Earnings 3,500 135 1,292 1,747 - 2,208 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 854 854 212 - (854) 0% Transfers In - - - - - - 0% Total Revenue 520,794 259,071 279,683 298,465 - 241,111 54% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 252 - - 0% Debt Service 722,935 56,545 361,467 352,798 - 361,468 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 722,935 56,545 361,467 353,050 - 361,468 50% Net (202,141) 202,526 (81,784) (54,584) - (120,357) Cash Balance 704,014 781,185 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 June Fund /Department Number 407 Date Updated 7/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 123,553 123,553 129,108 - 135,447 48% 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 123,553 123,637 129,193 - 310,513 28% 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 123,553 (61,613) (55,682) - 131,001 Cash Balance 115,111 42,038 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 June Fund /Department Number 412 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 25,000 1,708 13,788 17,072 - 11,212 55% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 556,798 - 227,661 237,331 - 329,137 41% Transfers In - - - - - - 0% Total Revenue 581,798 1,708 241,449 254,403 - 340,349 42% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 5,823,729 119,867 500,296 892,517 2,621,479 2,701,954 54% Transfers Out - - - - - - 0% Total Expenditures 5,823,729 119,867 500,296 892,517 2,621,479 2,701,954 54% Net (5,241,931) (118,159) (258,846) (638,113) (2,621,479) (2,361,605) Cash Balance 6,885,051 7,258,584 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Initial funding for the Major Moves fund in the amount of $12,823,151 was received from the State of Indiana on September 15, 2006. 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 $905,253 (Fund 435 - Douglas Road) and $4,864,913 (Fund 436 - Eddy Street/Triangle) at 30 June 2014. These revenue streams are scheduled to cease in 2030. 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 June Fund /Department Number 416 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 100,000 1,497 47,603 60,759 - 52,397 48% Interest Earnings 1,500 120 912 863 - 588 61% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 101,500 1,617 48,515 61,622 - 52,985 48% Expenditures Personnel - - - - - - 0% Supplies 14,700 - 5,374 1,243 652 8,674 41% Services 38,500 - 1,765 11,945 2,382 34,353 11% Debt Service - - - - - - 0% Capital - - - 6,550 - - 0% Transfers Out - - - - - - 0% Total Expenditures 53,200 - 7,139 19,738 3,034 43,027 19% Net 48,300 1,617 41,376 41,885 (3,034) 9,958 Cash Balance 498,186 438,152 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established for the purpose of renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons of the Morris Performing Arts Center. There is no staffing for this fund. Funds in this account are received from a per ticket surcharge included on every sold ticket. Explain Significant Spending on Capital Projects Below: There are no Capital projects budgeted for this year. Form 3 64 Form 3 65 2014 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Month June Fund /Department Number 434 Date Updated 7/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 650,000 - - - - 650,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,000 25 154 342 - 846 15% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 651,000 25 154 342 - 650,846 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 25 (20,821) (36,633) - 20,871 Cash Balance (11,284) 186,954 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 June Fund /Department Number 450 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 16,000 841 3,625 5,396 - 12,375 23% Interest Earnings 125 14 107 129 - 18 86% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,125 855 3,732 5,525 - 12,393 23% 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 855 3,732 5,525 - 2,393 Cash Balance 57,128 63,829 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 June Fund /Department Number 677 Date Updated 7/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 2,500 150 1,247 1,542 - 1,253 50% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 42 - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 150 1,247 1,584 - 1,253 50% Expenditures Personnel - - - - - - 0% Supplies 15,000 - 365 2,358 - 14,635 2% Services 173,567 3,079 43,967 23,073 8,908 120,692 30% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,567 3,079 44,332 25,431 8,908 135,327 28% Net (186,067) (2,929) (43,085) (23,847) (8,908) (134,074) Cash Balance 615,321 695,240 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 June Fund /Department Number 600 Date Updated 7/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 1,503,000 195,345 661,481 466,716 - 841,519 44% Interest Earnings 1,000 167 805 436 - 195 81% Bond Proceeds - - - - - - 0% Donations - 479 3,941 - - (3,941) 0% Other Income 2,000 2 1,194 1,089 - 806 60% Transfers In 2,306,560 - 1,153,280 - - 1,153,280 50% Total Revenue 3,812,560 195,994 1,820,701 468,240 - 1,991,859 48% Expenditures Personnel 2,009,828 142,822 896,740 428,827 2,891 1,110,197 45% Supplies 198,015 10,666 65,788 15,059 13,471 118,756 40% Services 1,314,266 33,417 382,076 34,639 526,370 405,819 69% Debt Service 21,800 2,175 8,681 7,254 2,598 10,521 52% Capital 203,000 - - - - 203,000 0% Transfers Out 52,000 - - - - 52,000 0% Total Expenditures 3,798,909 189,079 1,353,286 485,779 545,329 1,900,294 50% Net 13,651 6,915 467,415 (17,538) (545,329) 91,565 Cash Balance 620,997 186,311 Staffing Full Time 30.00 27.00 36.00 Part -Time /Seasonal /Temporary - - 2.00 Total 30.00 27.00 38.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 June Fund /Department Number 601 Date Updated 7/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 900,500 89,860 456,984 429,251 - 443,516 51% Interest Earnings 4,000 234 1,804 1,824 - 2,196 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 135,900 6,400 104,683 42,056 - 31,217 77% Transfers In - - - - - - 0% Total Revenue 1,040,400 96,494 563,471 473,131 - 476,929 54% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 663,179 46,542 365,079 324,553 17,000 281,100 58% Debt Service - - - - - - 0% Capital 134,629 - 67,980 149,835 98,920 (32,271) 124% Transfers Out - - - - - - 0% Total Expenditures 797,808 46,542 433,059 474,388 115,920 248,829 69% Net 242,592 49,952 130,412 (1,257) (115,920) 228,100 Cash Balance 1,014,600 854,186 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 June Fund /Department Number 610 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 4,815,830 428,013 2,472,693 2,425,044 - 2,343,137 51% Interest Earnings 6,000 130 1,183 2,074 - 4,817 20% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 435,871 15 98,048 13,617 - 337,823 22% Transfers In - - - - - - 0% Total Revenue 5,257,701 428,158 2,571,924 2,440,735 - 2,685,777 49% Expenditures Personnel 1,502,054 140,670 819,186 836,597 1,350 681,518 55% Supplies 324,095 23,658 212,551 128,950 2,277 109,267 66% Services 2,877,312 243,864 1,422,179 1,353,206 472,976 982,156 66% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 736,002 - 449,916 514,339 - 286,086 61% Total Expenditures 5,439,463 408,192 2,903,832 2,833,091 476,603 2,059,027 62% Net (181,762) 19,967 (331,908) (392,357) (476,603) 626,749 Cash Balance 457,025 763,059 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 66% 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 June Fund /Department Number 611 Date Updated 7/8/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 10 130 181 - 70 65% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 736,002 - 449,916 514,339 286,086 61% Total Revenue 736,202 10 450,046 514,520 - 286,156 61% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 736,002 10,821 373,669 324,702 - 362,333 51% Capital 160,068 - 139,450 - 20,618 - 100% Transfers Out - - - - - - 0% Total Expenditures 896,070 10,821 513,119 324,702 20,618 362,333 60% Net (159,868) (10,812) (63,073) 189,818 (20,618) (76,177) Cash Balance 55,367 189,927 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 June Fund /Department Number 620 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 14,589,253 1,401,095 6,861,906 6,900,816 - 7,727,347 47% Interest Earnings 9,000 745 6,206 3,416 - 2,794 69% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 93,580 6,425 63,761 87,114 - 29,819 68% Transfers In 19,500 1,058 7,745 8,089 - 11,755 40% Total Revenue 14,711,333 1,409,323 6,939,618 6,999,435 - 7,771,715 47% Expenditures Personnel 4,594,374 343,485 2,198,059 2,056,058 6,051 2,390,264 48% Supplies 1,624,686 151,315 781,890 459,369 118,252 724,544 55% Services 4,633,411 245,549 1,988,343 1,783,826 167,484 2,477,584 47% Debt Service 6,555 - 2,096 2,592 - 4,459 32% Capital - - - - - - 0% Transfers Out 3,982,978 347,278 2,010,720 2,058,350 - 1,972,258 50% Total Expenditures 14,842,004 1,087,627 6,981,108 6,360,195 291,787 7,569,109 49% Net (130,671) 321,696 (41,490) 639,240 (291,787) 202,606 Cash Balance 3,325,991 2,059,286 Staffing Full Time 70.20 66.20 Part -Time /Seasonal /Temporary 3.00 5.50 Total 73.20 71.70 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to account for all revenue and operational expense of the water utility. This fund provides the monies for debt service obligations, reserve requirements and revenue funded capital improvements through transfer of monies to other funds within the utility operations. Current year to date revenue is slightly below the prior year. 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 Form 3 73 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Month June Fund /Department Number 622 Date Updated 7.14.14 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10,000 856 6,817 8,928 - 3,183 68% Bond Proceeds - - - - 0% Donations - - - 0% Other Income - - - 0% Transfers In - - - - 0% Total Revenue 10,000 856 6,817 8,928 - 3,183 68% Expenditures Personnel - - 0% Supplies - - 0% Services 3,600 - 3,600 14,050 - - 100% Debt Service - - - - - 0% Capital 974,658 53 53 193,139 96,870 877,735 10% Transfers Out - - 0% Total Expenditures 978,258 53 3,653 207,189 96,870 877,735 10% Net (968,258) 803 3,164 (198,261) (96,870) (874,552) Cash Balance 3,534,889 3,947,056 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used for acquiring, constructing, and improving fixed assets. Explain Significant Spending on Capital Projects Below: Current encumbrance activity: Motor Vehicles w /CNG conversion $67,463 and North Station Roof Restoration engineering $29,408 Form 3 73 Form 3 74 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Month June Fund /Department Number 623 Date Updated 7.11.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 94 1,308 11,675 3,692 26% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 94 1,308 11,675 - 3,692 26% Expenditures Personnel - - 0% Supplies 209,422 - 34,046 274,908 73,496 101,880 51% Services 74,076 - 42,103 - - 31,973 57% Debt Service - - - - - - 0% Capital 527,513 430 371,849 910,275 1,947 153,717 71% Transfers Out - - - - - 0% Total Expenditures 811,011 430 447,998 1,185,183 75,443 287,570 65% Net (806,011) (336) (446,690) (1,173,508) (75,443) (283,878) Cash Balance 365,939 4,629,328 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. Explain Significant Spending on Capital Projects Below: YTD Spending: Water Meters $17,780 Pinhook WT Efficiency Improv Project $430,218 Form 3 74 Form 3 75 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Month June Fund /Department Number 624 Date Updated 7.11.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 355 2,817 3,017 - 3,183 47% Bond Proceeds - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 355 2,817 3,017 - 3,183 47% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - 0% Transfers Out 6,000 355 2,817 3,057 - 3,183 47% Total Expenditures 6,000 355 2,817 3,057 - 3,183 47% Net - - - (40) - - Cash Balance 1,465,420 1,435,625 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 June Fund /Department Number 625 Date Updated 7.11.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 198 944 693 4,056 19% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income - - - - - 0% Transfers In 2,052,224 170,810 1,024,860 1,025,718 1,027,364 50% Total Revenue 2,057,224 171,008 1,025,804 1,026,411 - 1,031,420 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - 0% Debt Service 2,052,224 383,870 383,870 409,351 1,668,354 19% Capital - - - - - 0% Transfers Out 5,000 198 944 693 4,056 19% Total Expenditures 2,057,224 384,068 384,814 410,044 - 1,672,410 19% Net - (213,060) 640,990 616,367 - (640,990) Cash Balance 646,327 621,004 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: Form 3 76 Form 3 77 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Month June Fund /Department Number 626 Date Updated 7/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 5,500 382 3,007 2,886 2,493 55% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income - - - - 0% Transfers In 84,573 8,564 51,384 144,447 33,189 61% Total Revenue 90,073 8,946 54,391 147,333 - 35,682 60% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 90,073 8,946 54,391 147,333 - 35,682 Cash Balance 1,620,067 1,459,021 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 June Fund /Department Number 629 Date Updated 7.11.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 505 3,983 4,339 - 4,517 47% Bond Proceeds - - - 0% Donations - - - 0% Other Income - - - 0% Transfers In 61,812 - 53,507 45,301 - 8,305 87% Total Revenue 70,312 505 57,490 49,640 - 12,822 82% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 505 3,983 4,339 4,517 47% Total Expenditures 8,500 505 3,983 4,339 - 4,517 47% 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 was transferred in during the month of February to satisfy 100% of the 2014 requirement. Explain Significant Spending on Capital Projects Below: Form 3 78 Form 3 79 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Month June Fund /Department Number 640 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - 0% Charges for Services 548,000 49,793 289,559 273,365 - 258,441 53% Interest Earnings 1,200 354 2,725 2,564 - (1,525) 227% Bond Proceeds - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 549,200 50,147 292,284 275,928 - 256,916 53% Expenditures Personnel 177,387 13,039 76,618 55,406 100,769 43% Supplies 17,115 1,856 5,351 11,943 11,764 31% Services 327,041 1,903 65,391 106,542 30,996 230,653 29% Debt Service 28,435 14,218 14,218 14,217 50% Capital - - - 0% Transfers Out - - - - - - 0% Total Expenditures 549,978 16,799 161,578 188,108 30,996 357,404 35% Net (778) 33,348 130,706 87,820 (30,996) (100,488) Cash Balance 1,493,752 1,245,860 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 June Fund /Department Number 641 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,460,188 2,841,686 16,407,801 15,447,701 - 18,052,387 48% Interest Earnings 18,000 1,189 10,515 8,972 - 7,485 58% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,000 711 33,597 23,338 - 26,403 56% Transfers In 15,000 829 6,556 10,359 - 8,444 44% Total Revenue 34,553,188 2,844,415 16,458,469 15,490,370 - 18,094,719 48% Expenditures Personnel 6,776,379 516,977 3,357,155 3,154,239 166 3,419,059 50% Supplies 2,419,100 112,526 772,162 813,441 333,059 1,313,879 46% Services 12,452,029 810,293 4,842,021 5,317,363 1,423,112 6,186,896 50% Debt Service 359,746 110 164,600 133,380 - 195,146 46% Capital - - - - 0% Transfers Out 13,548,940 774,919 8,779,478 5,020,395 - 4,769,462 65% Total Expenditures 35,556,194 2,214,826 17,915,416 14,438,817 1,756,337 15,884,441 55% Net (1,003,006) 629,589 (1,456,947) 1,051,553 (1,756,337) 2,210,278 Cash Balance 5,755,049 5,048,757 Staffing Full Time 95.04 94.04 Part -Time /Seasonal /Temporary 7.00 7.00 Total 102.04 101.04 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. 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 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Month June Fund /Department Number 642 Date Updated 7/15/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,416 10,028 18,188 - 28,972 26% 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,416 4,010,028 18,188 - (443,448) 112% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 133,264 2,963 43,269 79,814 89,995 0 100% Debt Service - - - - - - 0% Capital 9,134,677 347,384 2,599,659 1,623,919 3,131,233 3,403,786 63% Transfers Out - - - - - - 0% Total Expenditures 9,267,941 350,346 2,642,927 1,703,734 3,221,228 3,403,786 63% Net (5,701,361) (348,930) 1,367,101 (1,685,546) (3,221,228) (3,847,234) Cash Balance 5,411,667 7,177,563 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,226,893, Sage /Poppy Rd Lift Station $235,582, Ferric Chloride Feed Facility $17,585; Sewer Dept. tandem axle dump trucks $323,802, Jet Rodder /Vacuum machine $309,680; Manhole Rehab. work $86,694, Sewer lining work $240,515, CNG station upgrade $85,000. Form 3 1.1 Form 3 E:A 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Month June Fund /Department Number 643 Date Updated 7/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 829 6,556 6,836 - 8,444 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 223,715 - 129,964 200,296 - 93,751 58% Total Revenue 238,715 829 136,520 207,131 - 102,195 57% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 829 6,556 6,836 - 8,444 44% Total Expenditures 15,000 829 6,556 6,836 - 8,444 44% 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 E:A 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Month June Fund /Department Number 647 Date Updated 7/15/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 3 35 - (3) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 0 3 35 - (3) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,138 805 805 13,616 333 0 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,138 805 805 13,616 333 0 100% Net (1,138) (805) (802) (13,581) (333) (3) Cash Balance 338 5,460 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 June Fund /Department Number 649 Date Updated 7/15/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 1,032 4,588 4,603 - 2,412 66% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,797,645 774,919 4,649,514 4,806,003 - 5,148,131 47% Total Revenue 9,804,645 775,951 4,654,102 4,810,606 - 5,150,543 47% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,000 - - - - 3,000 0% Debt Service 9,799,031 132,890 1,674,352 2,662,715 - 8,124,679 17% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,802,031 132,890 1,674,352 2,662,715 - 8,127,679 17% Net 2,614 643,061 2,979,750 2,147,891 - (2,977,136) Cash Balance 3,762,556 2,983,936 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 June Fund /Department Number 653 Date Updated 7/15/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 June Fund /Department Number 658 Date Updated 7/15/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 4 202 - (4) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 4 202 - (4) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 99,796 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 99,796 - - 0% Net - 1 4 (99,594) - (4) Cash Balance 2,220 12,609 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 June Fund /Department Number 659 Date Updated 7/15/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,535 14,021 20,114 - 10,979 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 1,535 14,021 20,114 - 10,979 56% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 705,491 1,464 1,764 229,090 3,728 700,000 1% Debt Service - - - - - - 0% Capital 12,892,995 710,182 2,491,143 1,317,197 4,029,472 6,372,380 51% Transfers Out - - - - - - 0% Total Expenditures 13,598,486 711,646 2,492,907 1,546,287 4,033,200 7,072,379 48% Net (13,573,486) (710,111) (2,478,886) (1,526,173) (4,033,200) (7,061,401) Cash Balance 5,369,614 8,640,337 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,903,705. Form 3 87 Form 3 88 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Month June Fund /Department Number 661 Date Updated 7/15/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 4,317 34,713 38,108 - 10,287 77% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,000 4,317 34,713 38,108 - 10,287 77% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,870,000 6,278 513,294 104,981 319,448 4,037,258 17% Debt Service - - - - - - 0% Capital 13,998,570 - - 493,001 - 13,998,570 0% Transfers Out - - - - - - 0% Total Expenditures 18,868,570 6,278 513,294 597,982 319,448 18,035,828 4% Net (18,823,570) (1,961) (478,581) (559,873) (319,448) (18,025,540) Cash Balance 17,820,445 22,687,014 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 $350,668. Form 3 88 Form 3 89 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2013 Month June Fund /Department Number 663 Date Updated 7/15/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 June Fund /Department Number 664 Date Updated 7/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 1 9 - - (9) 0% Bond Proceeds - - - 85,740 - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 9 85,740 - (9) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 81,064 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 81,064 - - 0% Net - 1 9 4,676 - (9) Cash Balance 4,476 4,676 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 June Fund /Department Number 665 Date Updated 7/15/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 - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 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 (500,000) - - - - (500,000) Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up in anticipation of a possible Sewer Bond issue sometime in 2014. No activity expected at this time. Explain Significant Spending on Capital Projects Below: Form 3 F!Y Form 3 MA 2014 City of South Bend Monthly Financial Report Fund /Department Name Century Center Month June Fund /Department Number 670 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,313,436 - 656,725 1,313,436 - 656,711 50% Grants /Intergovernmental - - - - - - 0% Charges for Services 3,236,462 158,745 841,946 625,712 - 2,394,516 26% Interest Earnings - - - 228 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 15,000 5,329 36,214 46,965 - (21,214) 241% Transfers In - - - - - - 0% Total Revenue 4,564,898 164,074 1,534,885 1,986,341 - 3,030,013 34% Expenditures Personnel 2,450,875 170,496 1,014,786 862,128 - 1,436,089 41% Supplies 476,400 48,022 234,761 936 - 241,639 49% Services 1,222,594 90,553 623,958 539,311 - 598,636 51% Debt Service - - - - - - 0% Capital 415,029 - 338,301 - - 76,728 82% Transfers Out - - - - - - 0% Total Expenditures 4,564,898 309,071 2,211,806 1,402,375 - 2,353,092 48% Net - (144,997) (676,921) 583,966 - 676,921 Cash Balance 418,964 1,579,027 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. As of 7/14/14, the revenue accounts and the balance sheet accounts need to be adjusted. These adjustments will be made in July to correct the year. July 2014 is expected to be more in line with budget. Capital expenitures were made for a new freight elevator in prior months. 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 June Fund /Department Number 671 Date Updated 7/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - 100,000 - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 - 145 135 - 355 29% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 - 145 100,135 - 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) - 145 100,135 - (106,329) Cash Balance 1,757,843 1,375,012 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Century Center Board of Managers has not approved a 2014 capital budget in this fund. Explain Significant Spending on Capital Projects Below: Expected to transfer funds (approx. $250,000) to Fund 670 to cover new freight elevator. Form 3 1*IN Form 3 ME 2014 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month June Fund /Department Number 222 Date Updated 7/15/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 470,356 3,630,201 3,668,904 - 4,165,983 47% Interest Earnings 3,000 300 2,217 2,154 - 783 74% Bond Proceeds - - 0% Donations - - 0% Other Income 48,190 3,182 103,463 85,895 - (55,273) 215% Transfers In - - - - - - 0% Total Revenue 7,847,374 473,838 3,735,881 3,756,953 - 4,111,493 48% Expenditures Personnel 2,828,264 202,316 1,294,720 1,258,012 - 1,533,544 46% Supplies 177,649 34,769 62,223 77,827 56,254 59,172 67% Services 4,852,122 259,009 2,240,529 2,324,380 1,541,363 1,070,230 78% Debt Service 6,497 - 3,248 210 1,950 1,300 80% Capital 172,000 - - 24,817 - 172,000 0% Transfers Out - - - - 0% Total Expenditures 8,036,532 496,093 3,600,719 3,685,246 1,599,567 2,836,246 65% Net (189,158) (22,255) 135,162 71,707 (1,599,567) 1,275,247 Cash Balance 1,659,661 1,123,897 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 June we had 1,296 repairs. Year to Date repairs are 8,383. In the process of hiring two new mechanics to replace retirees. 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 June Fund /Department Number 226 Date Updated 7/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 2,859,690 238,310 1,426,707 1,494,288 - 1,432,983 50% Interest Earnings 22,000 1,272 9,886 11,646 - 12,114 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 10,619 47,667 295 - (30,667) 280% Transfers In - - - - - - 0% Total Revenue 2,898,690 250,200 1,484,260 1,506,228 - 1,414,430 51% Expenditures Personnel 189,417 13,943 89,150 79,943 - 100,267 47% Supplies 21,143 704 7,616 7,269 - 13,527 36% Services 2,676,640 497,483 1,439,011 940,365 34,224 1,203,405 55% Debt Service - - - - - - 0% Capital 10,000 - - 853 - 10,000 0% Transfers Out - - - - - - 0% Total Expenditures 2,897,200 512,130 1,535,777 1,028,430 34,224 1,327,199 54% Net 1,490 (261,930) (51,517) 477,798 (34,224) 87,231 Cash Balance 5,133,980 5,723,210 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 June Fund /Department Number 278 Date Updated 7/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 60,580 4,700 30,630 30,900 - 29,950 51% Interest Earnings 2,000 121 918 889 - 1,082 46% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 60,580 4,700 30,523 30,873 - 30,057 50% Transfers In - - - - - - 0% Total Revenue 123,160 9,521 62,071 62,662 - 61,089 50% 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,521 62,071 62,662 - (19,491) Cash Balance 515,024 454,468 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 June Fund /Department Number 711 Date Updated 7/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 13,385,150 1,073,126 6,425,442 6,002,334 - 6,959,708 48% Interest Earnings 32,000 1,212 10,939 16,201 - 21,061 34% 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,074,338 6,447,480 6,229,033 - 6,970,970 48% Expenditures Personnel 4,326 - - - - 4,326 0% Supplies 17,875 2,027 27,783 4,408 - (9,908) 155% Services 760,062 33,189 314,529 287,593 18,000 427,533 44% Insurance 13,701,200 810,812 6,744,682 6,019,595 36,177 6,920,341 49% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 14,483,463 846,028 7,086,994 6,311,595 54,177 7,342,292 49% Net (1,065,013) 228,310 (639,514) (82,563) (54,177) (371,323) Cash Balance 5,021,933 7,345,628 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 2014 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Month June Fund /Department Number 713 Date Updated 7/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 51,182 156,406 - 185,216 22% Interest Earnings 500 57 485 249 - 15 97% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 236,898 8,587 51,667 156,655 - 185,231 22% Expenditures Personnel 220,750 12,713 79,759 36,791 - 140,991 36% Supplies - - - - - - 0% Services 7,224 602 3,612 2,142 - 3,612 50% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 227,974 13,315 83,371 38,933 - 144,603 37% Net 8,924 (4,728) (31,704) 117,722 - 40,628 Cash Balance 228,326 190,288 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund charges an allocation of 0.5% of payroll to most departments to cover the cost of unemployment claims paid. For the 2014 budget, the rate charged to departments has been reduced to 0.25% due to favorable claims history and increasing cash reserves. Budgeted charges for services were adjusted in July 2014 to reflect the change in charges to the departments. 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 June Fund /Department Number 701 Date Updated 7/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 5,386,832 2,564,549 2,564,549 2,517,646 - 2,822,283 48% 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 2,564,549 2,565,260 2,519,282 - 2,826,072 48% Expenditures Personnel 5,869,495 462,708 2,725,378 2,756,253 - 3,144,117 46% Supplies 200 - - - - 200 0% Services 4,750 85 337 589 - 4,413 7% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,874,445 462,793 2,725,715 2,756,842 - 3,148,730 46% Net (483,113) 2,101,756 (160,455) (237,560) - (322,658) Cash Balance 777,645 1,110,305 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 June Fund /Department Number 702 Date Updated 7/1/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 3,055,933 3,055,933 2,931,849 - 3,244,067 49% Charges for Services - - - - - - 0% Interest Earnings 6,000 - 1,632 3,190 - 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 3,055,933 3,057,565 2,936,150 - 3,252,435 48% Expenditures Personnel 7,216,441 566,814 3,482,877 3,255,069 - 3,733,564 48% Supplies 1,100 - - 642 - 1,100 0% Services 4,400 101 319 901 - 4,081 7% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 7,221,941 566,915 3,483,195 3,256,612 - 3,738,746 48% Net (911,941) 2,489,018 (425,631) (320,462) - (486,310) Cash Balance 1,283,026 1,988,164 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 JUNE Fund /Department Number 730 Date Updated 7/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 - - - - - - 0% Interest Earnings 250 9 71 89 - 179 29% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 250 9 71 89 - 179 29% 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) 9 71 89 (10,595) (9,821) Cash Balance 37,005 41,201 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 June Fund /Department Number 324 1 Date Updated 7/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 13,400,000 7,521,012 7,521,012 7,111,555 - 5,878,988 56% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 79,612 5,397 44,766 35,785 - 34,846 56% Bond Proceeds - 101,267 101,267 - - (101,267) 0% Donations - - - 65,000 - - 0% Other Income - 7 7 2,241,322 - (7) 0% Transfers In 5,000 252 2,006 278,205 - 2,994 40% Total Revenue 13,484,612 7,627,935 7,669,058 9,731,867 - 5,815,554 57% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 6,147,201 154,257 1,669,904 934,210 1,145,268 3,332,029 46% Debt Service 3,562,481 7,385 1,399,106 1,545,058 - 2,163,375 39% Capital 17,577,011 - 45,889 3,010,072 43,718 17,487,404 1% Transfers Out - - - - - - 0% Total Expenditures 27,286,693 161,642 3,114,899 5,489,340 1,188,986 22,982,808 16% Net (13,802,081) 7,466,293 4,554,159 4,242,527 (1,188,986) (17,167,254) Cash Balance 29,574,289 22,463,900 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 June Fund /Department Number 420 1 Date Updated 7/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 2,600,000 2,485,266 2,485,266 1,705,491 - 114,734 96% Local Income Taxes - - - - - - 0% Other Taxes 401,000 - 200,000 198,500 - 201,000 50% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,000 3,730 18,858 16,207 - 15,142 55% Interest Earnings 49,645 3,307 22,418 34,373 - 27,227 45% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 277,691 23,179 150,729 220,753 - 126,962 54% Transfers In 6,000 421 3,351 3,745 - 2,649 56% Total Revenue 3,368,336 2,515,903 2,880,622 2,179,069 - 487,714 86% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 574,131 32,302 249,931 226,204 233,609 90,591 84% Debt Service 2,972,966 - 1,531,010 1,440,376 - 1,441,956 51% Capital 2,282,164 - 15,336 37,401 45,890 2,220,938 3% Transfers Out - - - - - - 0% Total Expenditures 5,829,261 32,302 1,796,277 1,703,981 279,499 3,753,485 36% Net (2,460,925) 2,483,601 1,084,345 475,088 (279,499) (3,265,771) Cash Balance 3,688,819 3,314,444 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 June Fund /Department Number 422 1 Date Updated 7/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 420,000 304,152 304,152 264,690 - 115,848 72% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 149 1,163 857 - 837 58% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 422,000 304,301 305,315 265,547 - 116,685 72% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,319 - 319 1,678 - 10,000 3% Debt Service - - - - - - 0% Capital 647,215 - - 134,192 8,300 638,915 1% Transfers Out - - - - - - 0% Total Expenditures 657,534 - 319 135,870 8,300 648,915 1% Net (235,534) 304,301 304,996 129,677 (8,300) (532,230) Cash Balance 917,958 581,406 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 June Fund /Department Number 425 Date Updated 7/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 22 173 187 - 327 35% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 163,803 16,894 79,830 86,218 - 83,973 49% Transfers In - - - - - - 0% Total Revenue 164,303 16,916 80,003 86,405 - 84,300 49% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 128,373 16,524 55,961 53,855 - 72,412 44% Debt Service - - - - - - 0% Capital 21,052 - 14,353 - - 6,699 68% Transfers Out - - - - - - 0% Total Expenditures 149,425 16,524 70,314 53,855 - 79,111 47% Net 14,878 392 9,689 32,550 - 5,189 Cash Balance 142,755 127,944 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 June Fund /Department Number 426 1 Date Updated 7/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 625,000 459,659 459,659 613,185 - 165,341 74% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 370 5,461 7,809 - 9,539 36% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 640,000 460,029 465,120 620,994 - 174,880 73% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,721,310 - 1,543,685 43,187 175,126 2,499 100% Debt Service - - - - - - 0% Capital 2,382,194 - 185,830 585,837 50,348 2,146,016 10% Transfers Out - - - - - 0% Total Expenditures 4,103,504 - 1,729,515 629,024 225,474 2,148,515 48% Net (3,463,504) 460,029 (1,264,395) (8,030) (225,474) (1,973,635) Cash Balance 1,968,018 3,851,071 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 June Fund /Department Number 429 1 Date Updated 7/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 820,000 808,184 808,184 431,979 - 11,816 99% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 7,000 730 5,774 4,758 - 1,226 82% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 827,000 808,914 813,958 436,737 - 13,042 98% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 142,827 859 1,475 31,165 5,500 135,852 5% Debt Service - - - - - - 0% Capital 2,663,290 - - - - 2,663,290 0% Transfers Out - - - - - - 0% Total Expenditures 2,806,117 859 1,475 31,165 5,500 2,799,142 0% Net (1,979,117) 808,055 812,483 405,572 (5,500) (2,786,100) Cash Balance 3,821,274 2,625,195 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 June Fund /Department Number 430 1 Date Updated 7/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 2,500,000 1,268,946 1,268,946 1,381,537 - 1,231,054 51% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 763 6,343 11,235 - 8,657 42% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,515,000 1,269,709 1,275,289 1,392,772 - 1,239,711 51% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 249,784 15,248 139,345 289,460 99,018 11,421 95% Debt Service - - - - - - 0% Capital 6,238,173 27,877 206,646 407,391 1,080,825 4,950,702 21% Transfers Out - - - - - - 0% Total Expenditures 6,487,957 43,125 345,991 696,851 1,179,843 4,962,123 24% Net (3,972,957) 1,226,584 929,298 695,921 (1,179,843) (3,722,412) Cash Balance 4,368,946 6,090,697 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 June Fund /Department Number 432 Date Updated 7/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 - 9,175 9,175 659,735 - (9,175) 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 1,469 11,735 11,524 - 3,265 78% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,000 10,644 20,910 671,259 - (5,910) 139% 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) 10,644 (333,696) 325,204 - (145,455) Cash Balance 6,634,990 6,453,924 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to payoff debt. We will not be requesting additional funds from the TIF. The first opportunity to pay off the bond will be February, 2017. The plan is to payoff the bond at that time along with the prepayment penalty. In June we received $9,175 in the tax distribution we were not expecting to receive. We are working with the County to correct this. Explain Significant Spending on Capital Projects Below: Form 3 `[IR] Form 3 lull 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Month June Fund /Department Number 435 1 Date Updated 7/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 320,000 160,947 160,947 164,168 - 159,053 50% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 750 48 504 245 - 246 67% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 320,750 160,995 161,451 164,413 - 159,299 50% 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) 160,995 66,060 68,925 (4,200) (140,933) Cash Balance 360,660 229,851 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 June Fund /Department Number 436 Date Updated 7/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 2,392,000 1,382,498 1,382,498 1,340,028 - 1,009,502 58% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 167 2,314 5,702 - (314) 116% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,394,000 1,382,665 1,384,812 1,345,730 - 1,009,188 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 6,346 - - 1,370 - 6,346 0% Debt Service 3,362,308 - 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,866,291 1,569,208 - 1,716,937 52% Net (1,189,228) 1,382,665 (481,479) (223,478) - (707,749) Cash Balance 2,072,600 3,277,833 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 June Fund /Department Number 433 Date Updated 7/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 - 2 36 68 - (36) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 2 36 68 - (36) 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,667) (786) - (4,333) Cash Balance 10,081 30,657 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 June Fund /Department Number 439 Date Updated 7/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 1,450,000 - - 1,446,074 - 1,450,000 0% Charges for Services - - - - - - 0% Interest Earnings 12,000 894 7,115 4,121 - 4,885 59% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,462,000 894 7,115 1,450,195 - 1,454,885 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,138,000) 894 7,115 1,450,195 - (2,145,115) Cash Balance 3,689,710 2,266,557 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 June Fund /Department Number 454 Date Updated 7/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 1,500 91 727 810 - 773 48% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 91 727 810 - 773 48% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 91 727 810 Cash Balance 377,099 375,892 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 June Fund /Department Number 619 Date Updated 7/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,696,879 229,433 773,413 764,739 - 923,466 46% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 50,500 - - 0% Total Revenue 1,696,879 229,433 773,413 815,239 - 923,466 46% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,671,706 199,437 626,109 675,062 - 1,045,597 37% Debt Service - - - 207,879 - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,671,706 199,437 626,109 882,941 - 1,045,597 37% Net 25,173 29,996 147,304 (67,701) - (122,131) Cash Balance 282,494 191,026 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 June Fund /Department Number 315 Date Updated 7/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 5,000 252 2,006 2,241 - 2,994 40% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 252 2,006 2,241 - 2,994 40% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 252 2,006 2,241 - 2,994 40% Total Expenditures 5,000 252 2,006 2,241 - 2,994 40% 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 June Fund /Department Number 317 Date Updated 7/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 1,800 122 973 1,083 - 827 54% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,800 122 973 1,083 - 827 54% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,800 122 973 1,083 - 827 Cash Balance 504,445 502,831 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 June Fund /Department Number 328 Date Updated 7/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 6,000 421 3,351 3,745 - 2,649 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 421 3,351 3,745 - 2,649 56% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 421 3,351 3,745 - 2,649 56% Total Expenditures 6,000 421 3,351 3,745 - 2,649 56% 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